Innovative Database Architect with a solid background in designing, implementing, and maintaining complex database solutions. Possess strong skills in data modeling, system scalability, and ensuring data integrity across diverse platforms.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Programmer Analyst
Cognizant technology solutions
Hyderabad, India
07.2022 - 01.2024
Worked for a well-known American retail chain as a member of MDIP team, a lift and shift cloud data migration project from Teradata to Azure
Created Delta tables in ADLS for the existing Teradata objects using an internal tool and responsible to convert existing SQL logic in BTEQ scripts to PySpark scripts in azure data bricks notebooks
Performed unit testing of notebooks and able to successfully migrate 50+ objects from Teradata to azure
Played a prominent role in implementing new surrogate key logic by using hash function because of which the computational efficiency is up by around 30%
Collaborated with other teams and able to come up with a new approach that reduced the redundant usage of objects, which decreased the overhead in Teradata database by 20% and reduced storage cost in ADLS
Developed ADF pipelines for running PySpark notebooks and for some use cases like sending mail notification, Data movement, transformation activities
Automated history and incremental data load process for ACQ objects along with implanting parallel processing also, resulting in 2x reduction in manual work and consumed time
Intern
Cognizant technology solutions
Remote
01.2021 - 04.2022
Successfully completed training in SQL, Teradata, Data warehousing concepts, Informatica
Helped seniors in managing, analyzing data sets using SQL, contributed to data cleansing, and assisted in data validation checks, which resulted in increased system efficiency by 10%
Developed ETL programs using informatica to implement the business requirements
Diagnosed and resolved bugs in existing data mappings by analyzing data flow and monitored informatica jobs using DIH, reducing data processing errors by 40%
Education
University Of Houston Clear Lake - Management Information Systems
Sr. Executive Support at Cognizant technology Solutions, Cognizant Technology SolutionsSr. Executive Support at Cognizant technology Solutions, Cognizant Technology Solutions
Associate of Projects at Cognizant Technology Solutions India Private LimitedAssociate of Projects at Cognizant Technology Solutions India Private Limited