Pravin Teli

• · Developed end-to-end data integration solution for Stanley Black &Decker client using ADF, Azure SQL database, Logic apps
• Created Azure Data factory pipelines for integrating data from various source systems like Workday, ADP, to 20 different vendors.
• Created dynamic ADF pipeline framework, which resulted in optimizing the resources and making it flexible to handle all scenarios
• · Worked on Azure SQL database with Encrypted columns and transformed data using Azure Mapping data flow.
• Implemented Azure integration using Logic apps, APIM
  Involved in the code review and providing the solution to the team
• Deployed the Artifacts using ARM template for ADF and logic apps.

Optimized data processing by implementing efficient ETL pipelines and streamlining database design.

• Developed end-to-end data migration solution for financial services customer
• Involved in creating ADF pipelines for loading data from various source systems like, csv, excel, SQL Server to ADLS Gen 2 and Azure SQL database
• Implemented automation to scale up and scale down azure SQL database, Azure VM using automation runbook
• Implemented the extraction of attachment from outlook mail using LogicApps
• Basic Knowledge of Azure Synapse Analytics
• Implementing CICD for Azure SQL

• Build ETL pipeline in Azure leveraging ADF, ADLS Gen2 and Azure Databricks
• Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
• Managed structured data using Azure Databricks to develop data models and views for easier access and analysis by business intelligence tools.
• Involved in creating the DF framework to orchestrate data
  Created dynamic pipelines by using linked services, datasets, and using different activities
• .Implemented the transformation in Azure Databricks using SPARK SQL
• Involved in performance tuning for SAP BODS Jobs
• Involved in writing and tuning of TSQL procedures

• Performing the role of Oracle PLSQL developer and understanding the design document provided by the client
• Analysis and validation of source data from heterogeneous systems to single data warehouse
• Created procedures for Auditing of source data, which helped client to maintain data clean and regular
• Populated Facts and Dimension tables using Oracle procedures

• Involved in maintenance and development of OWB mappings, process flows, schedules
• Involved in writing sql queries, triggers, procedures, functions, packages
• Involved in creating and scheduling oracle jobs
• Working in Agile Methodology