Aayush Malla

• Enterprise resource planning is a type of software that organizations use to manage day-to-day activities such as finance, HR, accounting, procurement, project management, risk management, and so on. • Collaborate closely with senior data engineers to create ETL pipeline using Azure ADF. • Use Databricks to write PySpark/ Spark SQL scripts to perform data cleaning, transformation and modeling and loading into the azure • Use the ADF pipeline to load data from various sources into azure containers and orchestrate the whole process such as the execution of databricks notebooks. • Use Azure DevOps to maintain git repository and deploy various pipelines. • Perform Data Analysis and Data Quality Analysis of ERP data.

• Collaborate closely with data architect and senior data engineers to understand the requirement and develop the ETL pipeline accordingly. • Build scalable data pipelines to ingest and process data from multiple sources and data warehouses. • Use big data technology such as Apache spark to create ETL pipeline. • Enhanced internal processes by automating manual processes, optimizing data delivery, and redesigning data structure for maximum scalability.

• Analyze, design, test, and implement ETL process in Healthcare Analytics. • Develop ETL process for supporting Data extraction, transformation, and loading using ODI to extract raw health insurance data which is then transformed using reusable mapping, and mappings and then loaded into Oracle 12c. • Prepare and Execute test scripts in ORACLE and PLSQL. • Analyze data to extract insights from health insurance datasets, visualize them, and perform quality checks. • Responsible for creating automation scripts to minimize redundant tasks. • Responsible for maintaining Quality of Health Care data.

Worked as a trainee at COTIVITI where I learned about PLSQL, T-SQL, JAVA, Shell Scripting, and US Health care System.