UTKARSH PAL
Pune
Summary
With 7 years of working experience in startups and MNCs, Microsoft certified Azure Data Engineer has expertise in Azure Data Engineering and Analytics Services like Azure Data Factory, Azure Databricks, Synapse Analytics, Azure Data Lake Storage, etc. Proficiency in Python Programming Language, Cloud Computing, SQL and NoSQL Databases, Data Science, and Machine Learning Python libraries. Good interpersonal skills with client interaction experience. Also worked on Circuit designing, sensor data, and PCB designing.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Delivery Lead
Wipro Limited
Pune
07.2024 - Current
- Transforming data through multiple zones under medallion architecture by writing PySpark or SQL notebooks in Databricks.
- Conducted daily team meetings to review performance, set goals and resolve any issues.
- Developed strategies for improving customer satisfaction ratings.
- Trained new employees in safety protocols and operational procedures.
Senior Associate Technology
Synechron Technologies Pvt. Ltd.
Pune
09.2022 - 06.2024
- Data migration from local network share and data warehouse to Azure ADLS account using Azure Data Factory and Databricks.
- Create the managed delta table from migrated files into the RAW Zone.
- Implementation the basic transformation data cleaning logics like trimming, data type changes, column name changes, etc. in the HARMONIZED Zone
- In the CURATED zone, we are implementing business logic to the data like claim and premium transaction calculations (Insurance domain data) for different TPAs and MGAs, joining multiple tables, etc. The tables are then exported to the consumption layer.
Technical Specialist
Mindtree Limited
Hyderabad
04.2021 - 09.2022
- Take the customer issue as a thread. Analyze the issue by reproducing it in our environment. Provide the solution to the customer.
- Responsible for issues related to Azure Data Factory, ADLS, Azure SQL Database, Synapse Analytics, Azure Databricks, and other Azure analytics services.
Senior Software Engineer
SpanIdea Systems Pvt Ltd (worked for TCS)
Pune
07.2019 - 01.2021
- Responsible for writing automation scripts and integration of scripts with Jenkins.
- Complete validation of “patches” provided by developers for testing of internal libraries and machine learning frameworks like TensorFlow and PyTorch.
- Based on the testing, for any genuine issue, JIRA tickets need to be created and followed up on the same
Python Developer and Embedded Design Engineer
Tsecond Generation Technology Pvt. Ltd.
Nagpur
06.2017 - 07.2019
- To fetch the real-time data from turbine flow sensors using Python’s socketIO-Client library. To fetch the data from the Energy Meter/PCC Controller using USB to RS485 Modbus communication protocol.
- Data analysis by applying algorithms to convert text files to CSV format. Applying data cleaning, and data visualization algorithms to prepare a detailed report for the client for business benefits.
- Complete POC hardware development. Power supply circuits using LDO and Buck Convertor. Communication of microcontrollers with peripherals like RTC DS1307, SIM808 Communication Module, etc.
Education
Bachelor of Science - Electronics And Communications Engineering
DIT University
Dehradun, India05-2017
High School Diploma -
Army Public School
Roorkee, India04-2013
Skills
- Azure Databricks
- Data Governance (Unity Catalog)
- Azure Data Factory
- Azure Data Lake and Blob Storage
- Azure SQL Database
- Azure Synapse Analytics
- Azure Key Vault
- Python, Pyspark, SQL
Languages
Hindi
First Language
English
Proficient (C2)
C2
Certification
- DP-203: Microsoft Azure Data Engineer Associate
- DP-900: Microsoft Azure Data Fundamentals
- AZ-900: Microsoft Azure Fundamentals
- Fundamentals of Databricks Lakehouse Platform Accreditation
- Python for Data Science and Machine Learning Bootcamp
Timeline
Delivery Lead
Wipro Limited
07.2024 - Current
Senior Associate Technology
Synechron Technologies Pvt. Ltd.
09.2022 - 06.2024
Technical Specialist
Mindtree Limited
04.2021 - 09.2022
Senior Software Engineer
SpanIdea Systems Pvt Ltd (worked for TCS)
07.2019 - 01.2021
Python Developer and Embedded Design Engineer
Tsecond Generation Technology Pvt. Ltd.
06.2017 - 07.2019
Bachelor of Science - Electronics And Communications Engineering
DIT University
High School Diploma -
Army Public School
Similar Profiles
John MondalJohn Mondal
Senior Analyst at Wipro LimitedSenior Analyst at Wipro Limited
Hari PrasadHari Prasad
Assistant Manager at Wipro LimitedAssistant Manager at Wipro Limited
Trishant AgrawalTrishant Agrawal
Business Finance Manager at WIPRO LIMITEDBusiness Finance Manager at WIPRO LIMITED