Ajith Ganthala

• Understanding the data and Provide data related solution to Business Team.

• Developed Data Processing Pipelines in Azure Data Factory.

• Supported in Developing CI/CD Pipelines

• Release code through DevOps CI/CD Pipelines.

• Written Data Cleansing/Processing using PySpark in ADB and linked the codes to ADF.

• Automated the data ingestion process using ADB and ADF where pipelines will pick from Blob Storage and process the data to ADLS Schema and Google Biq Query.

• Demonstrated outstanding technical skill, including comprehensive working knowledge of SQL, Python and Azure Data Factory.

• Developed and designed automated code to load the data into Azure Blob Storage using Python and Data Bricks.

• Worked alongside team members and leaders to identify analytical requirements and collect information to meet customer and project demands.

1. Interacting with SPOC's to understand the requirement and automating the reports as per the business requirement. 2. Performing Various data transformations, Extractions. 3. Migrating AA reports to azure methodology 4. Should build a code which will download files form SharePoint. 5. Need to build a code which can automate the excel file where code should open the file and and perform transformations based on requirement. 6. Need to build a code which will perform the data refresh and query refresh. 7. Need to build a code which will create a pivot table in excel. 8. Should be able to build a code which can perform all the manual steps perfomed in excel. 9. Need to build a code where it can upload files back to sharepoint and send email to stake holder. 10. Should be able to build a code which can automate the SAP of different modules to extract the data and consolidate them. 11. Should be able to write a code to automate AO Hana Sap files to refresh an gather the data. 12. Should be able to build a code which should scrape the data from different kinds of portals and generate a report. 13. Using SharePoint to download and upload the generated reports. 14. Using office 365 to send a communication mail to stake holders.