Sudharani Lomti

Implemented real world project on Formula1 Racing using Azure Databricks for data transformation, Delta Lake, Unity Catalog and Azure Data Factory for data integration.

Under Synapse Analytics worked for NYC(New York City) project to get hands-on experience. In this project, we implemented the end-to-end operations of ingestion, transformation, and loading as Synapse is a one-stop shop.

Responsibilities:

* Worked on ingesting various data files into the Azure Data Lake.

* Created key vaults to maintain secure data.

* Implemented Filter, Join transformation and aggregate(group by, window) functions on the available files.

* Created Delta tables over data lakes to satisfy ACID properties.

* As part of Azure Data Factory, I created pipelines to execute copy, validation, Get Metadata, if else, and Web activities by creating Datasets and Linked Services And implemented mapping data flows to perform transformations.

* As part of Azure Synapse, the compute services used are serverless SQL pool, dedicated SQL pool, pipelines, and notebooks.

Implemented various types of files like CSV, JSON, and Parquet.

• As a Business Analyst, worked under CAB (Consumer Advisory Board) team and this application will address all Consumers related queries through CCB approvals and finance data issues
• As per SDLC (Software Development Life Cycle) worked for the Gathering of Requirements and Analysis.
• Responsibilities:
• Reviewed and understood the requirements by conducting meetings with the stakeholders.
• Prepared the BRD (Business Requirements Document) and Intake forms.
• Prepared the FRD (Functional Requirements Document) by capturing AS-IS and TO-BE for the mentioned requirement.
• Addressed Change Management queries and checked for release alignment through RSC submission.
• And worked as a Data analyst to address some of the Banking DQ (Data Quality) issues.

• Capgemini is nominated for this Ab Initio Training program, which lasts for 4 weeks. It includes 2 weeks of platform training, followed by assignments and a mini project.
• This module is a comprehensive system that handles data extraction, data transformation, loading, and data warehousing.

• Capgemini is nominated for this Unix training program, which is undergone for 1 week, followed by exercises and assignments.
• In this training program, I have learned all the basic commands, awk, sed, grep, and shell scripting.
• I have completed this training in degreed pathway(NEXT portal).