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