Venkata Sai Kumar Duddela
Lead Data Engineer
Summary
Experienced Data Warehouse and Reconciliation Specialist with over 10 years of extensive experience in Data Warehouse integration and reconciliation. ~3 years of hands-on experience working within the Citizens Data Ecosystem, with in-depth knowledge of its processes, technologies, and data sources. Experience in end-to-end reconciliations for CCAR using the DCC framework, writing complex SQL queries and implementing robust data quality controls across Risk and Finance domains.
Overview
10
10
years of professional experience
7
7
years of post-secondary education
2
2
Certifications
Work History
Lead Data Engineer
Data Economy Inc
03.2022 - Current
- Delivered end to end solution of migrating risk and finance modernization platform from data stage to Talend
- Developed and reconciled CCAR Schedules and having valuable experience in validation of CCAR schedules using GPR framework and automated recon script
- Experienced in creating data quality solutions using DCC framework concepts like D2P and GPR
- Performed Counts checks, Data validation Checks, Business Rules, and Validations
- Implemented Snowflake storage concepts like Time Travel, Snow pipe, Streams, SnowSQL, Snow procedures
- Involved in Analyzing complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls with Data Science teams
- Designed, developed, evaluated, and maintained ETL /ELT pipelines
- Optimized existing pipelines to deal with growing data requirements which resulted in reducing resource consumption and improve processing time by almost 10x
- Performed Root Cause Analysis (“RCA”) for various bugs and defect detected with pipelines and Data Quality
Senior ETL Developer
Virtusa Technology Solutions
01.2018 - 03.2022
- Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL, and big data installations
- Performed end to end validation of ETL solutions
- Designed and created ETL code installations, aiding in transitions from one data warehouse to another
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals
- Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration
- To Interact with Client for updating Project status and to get notified about Ad hoc requests
- Created Data warehouse solution which eliminate latency while generating extracts from reporting tools
- Managed team of seven members
Programmer Analyst
Cognizant Technology Solutions
04.2015 - 01.2018
- Delivered scalable system architecture to support high-availability Internet site with various internal applications
- Directed software design and development to meet client needs for functionality and performance
- Provided technical support using knowledge of complex technology to solve problems and support new projects
- Participated in design sessions with clients to ascertain project specifications
- Worked on different tools like Informatica, Datastage, Abinitio, Teradata, Unix..etc.
- Worked in Insurance, Telecom, Lifescience domain related projects
Education
Bachelor of Technology - Computer Science And Engineering
JNTU Anantapuram
07.2010 - 09.2014
Intermediate - MPC
Rao's Junior College
07.2008 - 06.2010
SSC - SSC
Vijayavani Public School
06.2007 - 07.2008
Skills
ETL Tools
SNOWFLAKE
SQL
undefinedCertification
01/19, Talend
Accomplishments
- Achieved Super cruiser Award for technology mastery in AI/Ml from DES Global Services Pvt Ltd.
- Achieved Raise the Bar Award for Outstanding Performance from DES Global Services Pvt Ltd.
Timeline
Lead Data Engineer
Data Economy Inc
03.2022 - Current
Senior ETL Developer
Virtusa Technology Solutions
01.2018 - 03.2022
Programmer Analyst
Cognizant Technology Solutions
04.2015 - 01.2018
Bachelor of Technology - Computer Science And Engineering
JNTU Anantapuram
07.2010 - 09.2014
Intermediate - MPC
Rao's Junior College
07.2008 - 06.2010
SSC - SSC
Vijayavani Public School
06.2007 - 07.2008
Similar Profiles
Preethi NallamothuPreethi Nallamothu
Content Specialist at Data EconomyContent Specialist at Data Economy
Karthikeya DevasaniKarthikeya Devasani
Software Engineer at DATA ECONOMYSoftware Engineer at DATA ECONOMY
Rakesh GourishettyRakesh Gourishetty
Data Engineer at Data Economy Global ServicesData Engineer at Data Economy Global Services
Rohit JhaRohit Jha
Lead Data Engineer at AirbusLead Data Engineer at Airbus
Sandeep NattaSandeep Natta
Lead Data Engineer at Fifth Third BankLead Data Engineer at Fifth Third Bank