Utkarsh Mishra
Bengaluru
Summary
As an accomplished Azure Data Engineer, I excel in orchestrating and delivering highly efficient data processing solutions within the Azure ecosystem. My comprehensive understanding of cloud data technologies, coupled with proficiency in Python and SQL, empowers me to architect robust data pipelines, seamlessly integrating diverse data sources while ensuring paramount data integrity, security, and compliance. My expertise spans Azure Data Factory, Azure Databricks, Azure Synapse Analytics, and other Azure data services. With a keen aptitude for data modeling, performance optimization, and rapid troubleshooting, I consistently craft innovative, tailored solutions that align with clients' unique requirements, propelling them toward their strategic business goals.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Assistant Consultant
Tata Consultancy Services
Noida
12.2022 - Current
- Defining the operating model on the Azure cloud based architecture for the key applications that are moving from on premise to Azure .
- Metrics reporting (CPI, SPI, Burn down/Burn-Up charts, Velocity Graphs etc).
- Risk and Issue Management.
- Worked with the team to ensure timely/quality delivery and meeting the production support SLAs.
- Designed and implemented end-to-end data processing solutions on the Azure platform, leveraging Azure Data Factory, Azure Databricks, Azure Synapse Analytics, and other Azure data services.
- Built and maintained scalable and fault-tolerant data pipelines to collect, transform, and load data from various sources, ensuring data accuracy, consistency, and security.
- Conducted data modeling and performance tuning to optimize query and data processing performance, and developed monitoring and alerting mechanisms to proactively identify and resolve data issues.
- Collaborated with cross-functional teams including data scientists, business analysts, and developers to integrate data into analytics and machine learning models, and to deliver insights that drive business value.
- Developed and maintained documentation for data processing workflows, data dictionaries, and data lineage, ensuring compliance with regulatory requirements and internal policies.
- Stayed current with emerging trends and technologies in cloud data engineering and analytics, and provided thought leadership and recommendations for future data architecture and technology stack.
Application Development Team Lead
Accenture Solution Private Limited
Bengaluru
04.2019 - 11.2022
- Managed Delivery for Hilton Hotels USA , ABINBEV Europe , Wella Europe over the span of 7 years while working with Accenture
- Responsible for client communication on the new requirements and delivery/production support.
- Responsible for Delivery Planning, Tracking, and Monthly/Weekly Reviews
- Representing the team on various forums like weekly connects with the client leadership
- Worked with the team to ensure timely/quality delivery and meeting the production support SLAs.
- Technical mentorship of the team.
- Responsible for driving Agile Scrum ceremonies (Daily Stand-Up, Product Backlog refinement/grooming, Sprint Planning, Sprint Review/Demo with the business leads, Sprint Retrospective).
- Sprint Estimation and Planning using the Poker card estimation leveraging VSTS.
- Hands on experience with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer
- Proficient in creating Data Factory pipelines for on-cloud ETL processing; copy activity, custom Azure development etc
- Good technical knowledge in SQL
- Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
- Developed POC based on Azure data bricks solution for ETL based solution for querying financial data.
- Working with various sources like AWS s3 buckets , SAP , Syspro and integrating them with Azure data factory .
- Experience in migrating ADF code from dev to higher environments
- Experience building ,scheduling and optimizing ADF data pipelines, architectures and data sets.
- Resolved system test and validation problems to provide normal program functioning.
- Participated in design and planning exercises for future software rollouts.
- Guided team in layout modifications to improve functionality.
- Communicated directly with project stakeholders, providing timely updates on project advancement.
- Designed best practice documentation for development.
- Collaborated with stakeholders regarding project capabilities and limitations to deliver optimal functionality
Application Development Senior Analyst
Accenture Solution Private Limited
Bengaluru
04.2015 - 04.2019
- Experience in working with relational databases, query authoring (SQL) as well as working familiarity in SQL Server
- Experience in writing Stored Procedures, SQL Queries based on the requirements
- Experience in troubleshooting data related issues/anomalies in the application and taking complete ownership of the task.
- Drove continual improvement in systems operations by building tools and automation.
- Met with internal and external customers to develop relationships and foster co-innovation opportunities.
Education
B.Tech - Electronics And Instrumentation
Babu Babrasi Das National Institute of Technology
Lucknow2014-06
Skills
- Program, Project and Service Delivery Management, Agile Scrum Management, DevOps, Azure & AWS Cloud
- Methodologies Known: DevOps, Distributed Agile (Scrum and Kanban)
- Service Delivery Tools - ServiceNow, ITSM
- Programming Languages : Python, C#, Visual Basic, T-SQL, PL/SQL
- Database: MS SQL Server , MongoDB and Oracle
- Business Intelligence Tools - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) ,PowerBi
- DevOps Tools - JIRA, TFS, Confluence
- Version Control Tools - TFS, Microsoft VSS
Certification
Az-900
70-461
DP-201
DP-202
Timeline
Assistant Consultant
Tata Consultancy Services
12.2022 - Current
Application Development Team Lead
Accenture Solution Private Limited
04.2019 - 11.2022
Application Development Senior Analyst
Accenture Solution Private Limited
04.2015 - 04.2019
B.Tech - Electronics And Instrumentation
Babu Babrasi Das National Institute of Technology
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services