Mehar Ankith Bobbili

Project : High Cash Reports

• Promoted a culture of innovation within the Data Engineering team, encouraging experimentation with new tools and techniques to stay ahead in the field.
• Migrated On premises data to the Azure cloud through ETL framework.
• Analyzed and converted the on premises queries to the spark SQL queries as per business requirement.
• Created Delta tables in Databricks , performed the transformations and load the data into target systems through ETL framework.
• Performed the Data Validation between source and target systems using Spark SQL and PySpark like Count Validation , Row level validation(minus/except query) , primary key duplicate check , NULL check .
• Worked on deployments to deploy the code from one environment to another environment.
• Implemented SCDs type2 to maintain the history.

Project : 1ADM Analytics

• Designed workflows to load data from different external sources(SAPS4HANA,CSV files) into Data Warehouse, Data Mart using Qlik Compose.
• Worked on different POCs to improve the performance of Qlik Compose jobs.
• Developed complex SQL queries to perform the validation between source and target systems.
• Implemented Mappings between source and target tables to load the data into target systems.
• Developed different star schemas and dimensions as per the business requirement using Qlik Compose.
• Implemented Change Data capture to extract updated or latest records from source system.
• Worked on Retry Mechanism to resume the job from the failed point instead of from beginning.