Sai Ganesh Nagulapalli

I am into Database development (ETL) with experience of over 7 years 10 Months. I have extensive knowledge in SQL, Informatica Powercenter, working on data modelling, building new mappings, enhancements, performance improvement.

I have domain knowledge in Banking Financial System(BFS) and Travel sector.

Experience in designing, implementation, development, and maintenance of Data Warehouse Systems, Data Marts with extensive experience in ETL process using Informatica Powercenter, Oracle, SQL server, IICS consisting of Data Sourcing, Data Staging, Data Transformation, Mappings, and Performance Tuning.

I have developed complex SQL queries, Informatica mappings to create a meaningful data of the source data. Worked on source systems like Oracle, SQL server, involved in analyzing web data(raw data) and finding inaccuracies in the data collection process which in turn improved the collection process thereby the accuracy.

Conducted exploratory analysis, performed hypothesis testing and statistical modeling to understand customer booking patterns and variables that contribute to sales.

Good communication and interpersonal skills with a proven ability to perform both as an individual and as a team player.

Principal Software Engineer - Lead ETL Developer

ACS Solutions

Apr 2021 – Nov 2022 Hyderabad, India

• Datawarehouse development and maintenance, Oracle.
• Collaborated with business intelligence team to produce customized

Data solutions for specific goals

• Performed Data profiling and developed design documents for the team.
• CompiledWeekly status, created monthly reports, performed annual performance appraisals of the team.
• Represented and managed the offshore data team as a delivery lead. Supervised work of my team, assigned tasks and monitored performance against targets.
• Mentored junior developers and trained them on Database, Data Modelling,

Datawarehousing concepts, Informatica Powercenter and ETL

Testing.

Senior Software Engineer - ETL Developer

ACS Solutions

Sep 2017 – Apr 2021 Hyderabad, India

• Developed in-application SQL statements, optimized solutions. Performed

Data profiling and developed design documents for the team.

• Developed PowerCenter Mappings,Workflows, and Sessions in Informatica

PowerCenter Version 10.4.

• Scheduled jobs to run in a batch through an orchestration tool, Active-

Batch V12.

• Identified, troubleshot and corrected bugs and bottlenecks, fine-tuned existing processes. Handled heterogeneous data from databases like

SSMS, Oracle, DB2, Excel files, XML. item Data migration from Oracle to Snowflake using Matillion as ETL tool. Developed jobs in Matillion which replicated the existing process in Datastage to load data from source to target.

• Used ActiveBatch as a job scheduler in our project, created dependencies and SLA’s.
• Working knowledge in Unix Shell scripting to extract data from files and workarounds. API data handling using shell scripting.

Programmer Analyst - BI

Cognizant

2015 – 2017 Hyderabad, Cognizant

• Used Alteryx designer to build jobs for Data profiling, Data Analysis.
• Experience in using ICEDQ data comparison tool to perform data validations,

business validations, trending data validations.

• Data validations between different databases like Oracle, SQL Server,

Teradata, Excel files and Db2.

• Maintained Data marts which were used as a source for Cognos reports.

Validated reports against the data marts.

PGD in Business Management(Project

Management)

University of Hyderabad, India

Class of 2021

B.Tech in Information Technology

JNTU Hyderabad, India

Sep 2010 – Apr 2014