Etl Developer Sql
Resume:
Rajinikantha Reddy Pidapa
Senior Consultant/Business intelligence Architect
Profile 14 + years of experience in Business Intelligence design/architecture. Helped clients in Insurance, Healthcare, Telecom, Banking and Travel domains by implementing large digital transformation programs. Well-versed expert in all phases of analysis, design, and implementation of Azure and BI applications. Ability to build & optimize organizational processes by employing strong Technical skills.
• Implementing Azure Cloud solutions to end users in migrating data from various systems to Cloud platform and performing the data redundancy, data cleansing and data aggregation
• Expertise in building large scale data warehouses which includes data management & strategy, data governance & data quality, Business Intelligence and data architecture
• Subject Matter Expert in MSBI Product suite/Development/Testing
• Strong Analytical skills with merit of building functional & operational road maps, mapping processes, and enhancing project performance to re-assure business standards
• Involved in designing, implementing, maintaining, and documenting complex OLTP and OLAP applications
• POC for technical support and manage metrics and drive client initiatives
• Provided support to 40+ MSBI projects and help them in completing their release activities
• Highly self-motivated and able to set effective priorities to achieve immediate and long-term goals and Flexible to update my knowledge and learn new skills to perform efficiently
• Experienced with Software Development Life Cycle(SDLC), Agile (SCRUM) methodologies Key Skills
Summary
Software Tools
Experience
Certifications
Data warehouse design and implementation, Data modeling, solution designing, performance optimization of ETLs, Business Intelligence and dashboard reporting, platform modernization Azure Data Factory, ADLS, Azure Synapse Analytics
Microsoft Business Intelligence Suite(SSIS, SSRS and SSAS) MS SQL Server
Tidal Scheduling, SQL Server Agent, Ctrl-M
Microsoft Azure Data Engineer Associate
Microsoft Azure Fundementals
Deloitte Consulting India Private Limited (Nov 2013 – till date) – USA 2 years Verizon Data Services India Ltd, (Jul 2011 to Oct 2013) Syntel India Inc, (Aug 2007 to Jun 2011)
Recent Project Experience
Jan 2020 -
till date
• Creating ETL design for Classification and Allocation of Expenses and Payables data.
• Involved architecture of data movement between different layers and proposed solutions.
• Designing Audit, Balance and Control framework customization and building DQ Strategy for balance check, error check, restart-ability design, reconciliation of total balance from one stage to another.
• Developed ADF pipelines and created Linked Services, Datasets in Azure Data Factory and worked on scheduling these Pipelines.
***********@*****.***
IFRS17 Program
Solution Designer
Client is one of the largest Insurance company, headquartered in Hongkong, China. It provides a wide range of financial planning services and products to multi million customers in SEA, including life insurance, investment-linked insurance, retirement solutions, health and medical protection, general insurance and employee benefit. Client has requirement to create Classification and Allocation engine to process Expense and Payables of the Insurance Contracts. As a Solution Designer I was involved in the following: Mar 2015 -
Dec 2019
SPS
ETL Technical Lead
Client is one of the nation’s largest health benefits companies, with nearly 36 million members in its affiliated health plans and nearly 68 million individuals served through its subsidiaries. This project is primary involved in modernizing the provider data management system with an enterprise model - Strategic Provider System replacing 9 regional PDM systems into a single integrated data platform
As a ETL Technical Lead I was involved in the following:
• Extract and Transform data from multiple source systems like ADLS, BLOB, CSV and SQL Server and load into Azure Synapse DB using Polybase approach.
• Design and develop of SSIS packages for all stages of ETL, stored procedures, functions, views and triggers to be used during the ETL process.
• Involved in Performance tuning like creating Partitions and applying data compression techniques for the huge volume data tables.
• Worked on peer code review, code integration, technical specification documentation and delivering the product with high quality.
• Coordinate with team to implement all ETL procedures for new project and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.
• Led 10-member ETL team and managed E2E delivery of the project.
• Documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts.
• Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems.
• Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems and implement all data warehouse activities and prepare reports for same.
• Performance tuning of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques.
• Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
• Work closely with Functional SME/Client to know the requirement/issue clearly and make sure defect density should be 0 after moving code to Production.
• Documenting ETL data mappings, data dictionaries, processes and solutions as per client standards.
• Fixing Prod Process abends and assisting to Ops & DBA team for Prod releases.
• Working with team members from different modules for supporting and helping them technically and functionally.
• Organized various trainings sessions for new and junior resources on Sql server & SSIS. Nov 2013 -
Feb 2015
WPT 2.0
Senior ETL Developer
Client is one of the largest electrics holding company in the United States by revenue, the largest regulated utility in the United States with approximately 10 million customers, and is also the largest operator of nuclear power plants in the United States. It distributes electricity and gas in Illinois, Maryland, and Pennsylvania. Client’s Power Team is a top wholesale energy marketer and Energy markets retail power and offers other energy-related services. Client wants to add another company on the upgraded platform. That would require new company’s financial data to be converted into WPT system. As a Senior ETL Developer I was involved in the following:
• Worked on migrating and rewriting code from Oracle DB in DB2 format.
• There are no configurations or dynamic parameterization in existing applications, so created configurations in all SSIS packages.
• Migrated all SSIS packages and Cubes from Sql server 2005 to Sql server 2008.
• Worked on creating and scheduling all the Jobs for monthly and daily.
• Migrating SSRS reports from 2005 to 2008 and responsible for Report Services configuration, uploading reports, providing security permission to Users and creating subscriptions.
• Created different types of configurations in SSIS packages like XML, Parent variables etc.
• Migrate and deploying cubes into SSAS 2008.
• Rewriting dts packages code in SSIS packages.
• Moving Databases, Database users and jobs from SQL Server 2005 to 2008.
• Working on fixing all the issues which are occurred in Production releases. EEMS
ETL and Reporting Developer
Client is one of the largest wireless carrier mobile network in the United States, with 121 million subscribers. This project is to migrate Oracle DB Data mart to DB2 DWH. and then extract Metrics data from different sources(DB1, csv etc) and then transform and load into SQL Server 2008 for to generate reports.
As a ETL and Reporting Developer I was involved in the following: July 2011 -
Oct 2013
• New company’s data should be converted and validated prior to Go-Live.
• Need to create pre and post load validation scripts for each step to make sure we are doing correct validation in the data conversion.
• The conversion script or process will be created and utilized to do a onetime conversion for each conversion object. Finalized data sets will be provided by business and loaded by the technical team.
• Data sets will be converted and validated as a part of the initial conversion and subsequent refreshes.
• Coordinating with Data Stewards to identify and resolve the issues/mismatches occurred during the SIT/UAT stage before Go-Live.
• For small data sets or configuration items, information will be manually entered into WPT system and validated.
Dec 2009 -
Jun 2011
Atlas Rewrite
ETL and SQL Developer
Client is one of the largest Credit Card services in the United States. Atlas is a core system in Business Travel Technologies of Client, which caters for all the travel needs of its corporate clients. Atlas pulls down the Passenger Name Record (PNR) data in from the Global Distribution System (GDS) and makes the reports available to the clients as they need. Atlas Rewrite involved uplift of the entire set of Atlas applications to a combination of .NET and Java platforms.
As a ETL and SQL Developer I was involved in the following:
• Understanding existing Atlas system
• Involved in new Design of the .NET components.
• Creating SSIS packages for downloading data from AS400 to MS SQL Server and vice versa
• Uploading files into file servers like Tumbleweed, Stratus, MainFrames and FTP.
• Event Handing in SSIS for Start process, End process, Error Log and current status of the process.
• Responsible for writing complex stored procedures to optimize the speed & N/w traffic
• Design aspx pages and writing .NET code to implement client requirements.
• Documentation of the process followed by creating flow-charts.
• Involved in successful creation of web calendar module.
• Responsible for communicating with onsite team for requirements/enhancements
• Understanding client requirements and implementing technical solution.
• Involved in creating DTS packages for data load from various systems to SQL Server 2000. Higher
Education
Master of Computer Applications
JNTU
EMEA – Web Application
.NET, ETL and SQL Developer
Client is one of the largest Credit Card services in the United States. This application is a Customer Care Portal website. The portal contains all the info about clients like when he enrolled in the company & what are the services he is using etc. The application allows specialist users to fetch client details about their expenditures, investments and calculate their business growth & then accordingly advices the specialist what to do & what to offer the Client so that business can be further improved.
As a .NET,ETL and SQL Developer I was involved in the following: Aug 2007 -
Nov 2009
• Development and Testing of Atlas Monitor Tool which is primarily used for tracking the health of the Atlas System and raise alerts in case of failures.
• Design of the DB changes
• Writing new Stored Procedures and Performance Tuning of the existing stored procedures.
• Code Integration of the entire system.
Contact this candidate