Summary
Overview
Work History
Education
Skills
Timeline
Generic

Shivakumar Nandihalli Rajashekar

Irving,TX

Summary

ETL Lead Developer with over 12+ years of total IT experience and Technical proficiency in the Data Warehousing teamed with Data Analysis, BI, Data Modeling, and ETL Development & ETL Design with full life cycle Implementation of Data Warehouse. Involved in the direct interaction with the clients. Strong knowledge in health Insurance and claim processing. Involved in building the logical and physical model.

Overview

12
12
years of professional experience

Work History

ETL Lead Developer

EVRY USA Corp
08.2019 - Current
  • Discussion with various stake holders on requirements and analyze prepare the data flow for the team.
  • Understand of sub-domain and frameworks related to B2B for HMS Gainwell Technologies.
  • Developed ETL Informatica workflows, B2B Data Exchange profiles, B2B Data transformation projects and creating database tables, indexes and table partitions for Claim processing applications for HMS.
  • Onbaording B2B Data to Enterprise data warehouse in Teradata for BI team using Teradata utilities like TPT and Fast Load.
  • Support all business queries raised by HMS the trading partner on claim processing, data issues, response for multiple clients and resolving the tickets on the priority basis.
  • Approve code deployments after reviewing it in GitHub and Azure pipelines.
  • Involved in the Informatica upgrade from 9.6.1 Hotfix1 to 10.2 Hotfix 1, migration of Cleo MFT to Informatica MFT.
  • Review schemas, data models and data architecture for EDI transaction processing and provide solutions for specific use cases improved operations and provided exceptional client support.
  • Attending meetings with the client time to time in absence of manager.
  • Use Informatica B2B Data Exchange to design the solution and develop workflows, applications, endpoints, and profiles.
  • Perform code review and involve in RCA meetings for any bug reported.
  • Improve Teradata performance using Teradata viewpoint and balance workload.
  • Using Teradata Fast load and Multi-load for handling large scale of data.
  • Discussions with BI team for generating reports in Tableau.
  • POC on Data onboarding from on premises to Azure cloud.
  • Integrating ADF with Azure Synapse Analytics.
  • Generating reports using PowerBI.

Senior ETL Developer

EVRY USA Corp
08.2015 - 07.2019
  • Analyze client requirement, preform impact analysis, prepares the high and low level design documents, and prepares detailed technical design document for HMS clients.
  • Created check-lists for coding, reviewing, bug logging, troubleshooting, testing and release for smooth functioning of the entire project
  • Identified process bottlenecks and implemented performance tuning at mapping and session levels to improve the performance
  • Performed Unit, Functional, Integration testing of the application and involved in Migration
  • Increased customer satisfaction by resolving complex issue with minimum amount of resource.
  • Designing Teradata database schemas, tables, indexes, and views to efficiently store and retrieve data.
  • Ensuring compliance with data governance policies, data security standards, and regulatory requirements using Informatica data catalog, IDQ and Axon.
  • Conducted performance tuning and troubleshooting of Teradata database issues and query logging using Viewpoint.

ETL Developer

Span Infotech Pvt Ltd
05.2013 - 07.2015
  • Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL,Files and mainframe files for HMS client .
  • Managed data quality issues during ETL processes, directing qualitative failures to business analyst.
  • Resolution of production issues within the load-window available, generating Email Notifications through scripts that run in the Post session implementations, minimize downtime required for deployments as well as because of errors.
  • Used Shell Scripts and PMCMD to interact with Informatica Server from command mode.
  • Involved in creating a process flow for the new enhancements in Production environment.
  • CR creation in service now to get required approvals for code deployments.
  • Perform code review, Prepare Unit Test Case document.

Junior Developer

Span Infotech Pvt Ltd
08.2011 - 05.2013
  • Participated in requirements meetings and data mapping sessions to understand business needs.
  • Documented business workflows for stakeholder review.
  • Developed database objects, including tables, views and materialized views using SQL.
  • Transformed project data requirements into project data models.
  • Develop mappings in Informatica Powercenter and tasks in workflow manager.
  • Monitor weekly and monthly runs and notify team in case of failures.
  • Identified and documented project constraints, assumptions, business impacts, risks and scope exclusions.
  • Created reusable mapping and workflows.
  • Designed and developed schema data models.
  • Perform unit testing and documentations.

Education

Bachelor of Science - Computer Science

Visvsvaraya Institute of Technology
Belgaum, India
05.2011

Skills

Technical Skills:
Operating systems: UNIX, Windows
Language/Tools SQL, PL/SQL, C, C
Scheduling Tools TW an, Informatica Scheduler
ETL Tools Informatica Power Center 10x/9x/8x, B2B Data Exchange, B2B Data Transformation, Managed File Transfer (MFT)
Database MS SQL Server, DB2, Teradata and Snowflake
Scripting: Unix Shell Scripting
Data Modeling Tools Microsoft Visio
Excel Tools & Utilities TOAD, SQL Developer, SQL*Loader, MLOAD,FLOAD And TPT

Timeline

ETL Lead Developer

EVRY USA Corp
08.2019 - Current

Senior ETL Developer

EVRY USA Corp
08.2015 - 07.2019

ETL Developer

Span Infotech Pvt Ltd
05.2013 - 07.2015

Junior Developer

Span Infotech Pvt Ltd
08.2011 - 05.2013

Bachelor of Science - Computer Science

Visvsvaraya Institute of Technology

Similar Profiles

CREATE PROFILE
Shivakumar Nandihalli Rajashekar