Ravi A Email & Phone Number

Frisco, TX, US

Charlotte, North Carolina, US

Slough, Berkshire, GB

• Extensive experience in developing ELT workflows and logic using PySpark and Cloud Technologies like Azure Databricks, Azure Data Factory and Azure Devops.
• Implemented cost optimization techniques on a project level.
• Handled code optimization.
• Understanding client requirements and interacting with various stakeholders for requirement gathering and analysis for cloud environment.
• Exploring various Azure Services to find the appropriate service needed for the project along with designing, Testing and documentation.
• Extracting data from multiple sources like Google Big Query, Rest API's, flat files and other relational

Mclean, Virginia, US

Worked on architecture design for multi state implementation or deployment.Processed external sources data which is hosted Hadoop environment using Jupyter notebooks.Bulk loading from external stage, internal stage to snowflake using the COPY command.Day to day responsibilities includes developing ETL pipelines in and out of datawarehouse, develop.

Lancaster, PA, US

• Involved in setting up of project environment in Azure.
• Setup the metadata database driven framework for initial sources and migrated the data to Azure Synapse SQL Pools.
• Built automated Azure Data factory pipelines and Synapse notebooks to pull data from different sources and move it across different data layers in data lake and storing it to Synapse warehouse tables.
• Had numerous client interactions to gather requirements and for data analysis.
• Mitigated the issues while migrating data from on-premises to Azure.
• Monitor production triggers and take metrics on productions jobs which ran over a period of time for further improvement of data loads.

Houston, Texas, US

• Used Data Factory as an orchestrator, built various Azure Data Factory pipelines to move data across different zones1. Source to Raw zone2. Raw to Archive zone3. Archive to Azure SQL tables
• Created table schema/structure in Azure SQL Datawarehouse solution
• Used Azure Databricks move and transform js on files to delta archive tables to maintain SCD Type2 data.
• Automated Delta Archive process using Databricks with Scala to fulfill the requirement.
• Handling schema changes when there’s any changes in schema for existing tables in source, these changes automatically taken care by SQL Scripts and updates the changes into Azure SQL tables/Datawarehouse tables.
• Implemented Log Analytics to capture logs different Azure services used in the project

Global, GB

• Used Data Factory as an orchestrator, built various Azure Data Factory pipelines to move data across different zones1. Source to Landing zone2. Landing to Refined zone3. Refined to Immutable zone
• Using Databricks moving CSV file data from landing to refined zone and storing the data Delta tables in refined zone
• Used Azure Databricks notebooks for data transformation in Refined zone
• Used Azure Databricks to flatten JSON source into a table structure.
• Created table schema/structure in Azure SQL (Immutable zone)
• Implemented Log Analytics to capture logs different Azure services used in the project

Jacksonville, FL, US

• Prepare case studies, understand the client requirements and provide cost effective solution.
• Gather requirements, do data analysis and prepare Function specification documents for the System.
• Estimate the project timeline and plan the resource.
• Preparation of detail technical design document for the System.
• Design & develop ETL/Reporting Solutions for analytical reporting capabilities.
• Design & develop Azure Data Factory like Pipelines, Datasets, Linked services, Integration Run Time, Lift and Shift packages using SSIS Integration Run Time, Templates in JSON and deployment using Power Shell script.

Lausanne, CH

• Created ETL (SSIS) process to transfer data from OLTP Files to data warehouse and monitored jobs.
• Identified and resolved the errors raised by job failures.
• Preformed QA Testing for Store Procedures to validate the CRM (Customer Relationship Management) supported by MINT.
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task.
• Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Sort and Execute SQL Task to load data into Database.
• Worked on various enhancements at database level, ETL and cube level.

Bachelor Of Technology - Btech, Computer Science

Ssc