GATTU SRAVAN KUMAR

ASSET PROTECTION TEAM:

Working for a Insurance Client handling multiple models data.

• Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
• Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
• Create Flask API to convert manual onboard using excel sheet to User onboard Page
• Identified discrepancies in source and target systems, implementing corrective actions to maintain data integrity.

PROJECT_INFORMATION:

MIGRATION PROJECT SAP HANA TO SNOWFLAKE:

• Working with MFGOG Client which maintains their framework in SAP HANA.
• As part of Migration Team , will be provided with all DB Objects such as FUNCTIONS,TABLES,STORED PROCEDURE,SEQUENCES,VIEWS.
• All Hana objects are converted to snowflake format.
• Working as POD lead , assigned with multiple PROJECTS and convert codes and handling Technical issues and checking with clients on blockers.
• Using GIT to commit codes and migrate changes to higher environments
• Played a key role in migrating the complex application from sap hana to snowflake and for successful go live.

AUTOMATION_ACTIVITES: Using Python Script:

• Script to validate the code changes ,code commit.
• Impact Analysis of Object and Schema Changes.
• Extraction of Keyword dependent using REGULAR_EXP

CLIENT AND PROFILE :

• Started Software Career with Accenture had training in INFORMATICA POWER CENTER.
• Allocated to US BASED LARGE PHARMA Client worked for about three years.
• I have been part of APPLICATION DEVELOPMENT Team.
• Client Special Recognition Award “ROCK STAR ASE” within One year of On boarding into Project.

PROJECTS:

CR and ENHANCEMENT Projects :

• Addition of columns /new mappings as per client requirement loads till publish layer which helps for dashboard team for analytical purpose.
• Understanding current pipeline and identifying objects, mapping and interfaces.
• Created DDL's, enhancing scripts and load end to end purpose without any data lineage.
• Created documents with new changes and migrated code to higher environments.

KEY_PROJECT:

INTEGRATION PROJECT: Migrating existing system from different heterogeneous database to Cloud

technology SNOWFLAKE and which works on real time handling JSON data.

➢ Challenges Faced

• Understanding current frame work
• Writhing scripts to execute/connect to new Environment
• Schedule jobs using Autosys
• Ongoing feed and Current Feed Comparison
• Giving assurance to client to cutoff previous feed , which helps to client move to new cloud
  technologies