Saitya Komuravelly

● Developed pre-processing and Data Extraction NoteBooks for multiple ERPs(JDEdwards , Oracle) as part of migration of SQL to cloud which helped most of the support team members to process data easily and store the data on cloud platform.

● Provided required support to the KPMG Global Support team

in identifying and resolving bugs and issues of KCw which is hosted in Cloud i.e; KCw Paas Version

● Developed pyspark scripts for the support team members for getting the Log information using Azure Data Bricks (ADB) notebook and for debugging the data stored in ADLS Gen2

Azure Developer

● Worked on Data Ingestion project, this project is to ingest data from On-Premises to Azure Cloud SQL DataWareHouse , data is then taken from Azure DWH to Power BI for interactive dashboards for the end-users to use effectively

● Worked as a developer and used Azure Data Factory V2 pipelines which were designed to ingest various sources into ADLS using ADF. Used Activities like Copy, Notebook, stored procedures, Databricks Notebook activity.

● Py Spark commands were written on Azure Data Bricks (ADB) Notebook to process the data and store in ADLS Gen2.

● Worked on enhancements of the project, monitored the pipelines from day to day basis and fixed the issues.

ETL DataStage Developer

● Involved in Designing of Data Stage jobs, Linux scripting and SQL codes

● Worked on redesigning the server jobs to parallel.

● Involved in DataStage code movement from DataStage 8.5 to DataStage 11.5 and Oracle to SQL Server.

● Also worked on the functionality check for all Jobs and made the code compatible with SQL Server.

● Involved in data fix and end-to-end testing of the application.

● Regular interactions with clients on requirements, progress status.

● Worked with team in updating all the documents which includes Design specification, Unit and System Test Cases, Results