Akhilesh Ummeda
London,ENG
Summary
Accomplished Data Engineer with extensive expertise in data engineering, ELT, and data warehousing. Proficient in Azure Data Factory, Databricks, Azure Synapse, and Data Lake Storage. Skilled in SQL, PySpark, Delta Lake, Power BI, and Excel. Adept at leveraging Azure DevOps and Microsoft SQL-Server to optimise data solutions. Committed to driving data-driven decision-making and enhancing business intelligence through innovative data solutions.
Driven individual with keen interest in data engineering. Possesses strong analytical skills and proficiency in programming languages, complemented by excellent problem-solving abilities. Capable of transforming complex data into actionable insights to drive business success.
Overview
6
6
years of professional experience
4043
4043
years of post-secondary education
Work history
Data Engineer
Essure Technologies
04.2023 - 09.2024
- Developed and managed robust data pipelines using Azure Data Factory (ADF), Synapse, Databricks, Python, and SQL, facilitating seamless data movement across diverse systems, eliminating data silos, and increasing data accessibility by 30%.
- Utilized Azure Databricks notebooks to handle incremental data loads efficiently, applying the Medallion architecture for data transformations, which reduced data processing time by 40% and ensured data consistency.
- Created pipelines in ADF using Linked Services, Datasets, and Pipelines to extract data from local file storage, transform it, and load it into Azure SQL, Blob Storage, and Synapse Analytics, improving data ingestion efficiency by 25%.
- Integrated Azure Databricks as a notebook activity on the ADF canvas, creating event-based and scheduled triggers for data processing. Connected Azure Databricks with ADLS source storage and Azure Blob sink storage, enhancing data workflow automation by 35%.
- Developed continuous integration and continuous deployment (CI/CD) pipelines for both on-premises and cloud environments, focusing on automating build and deployment processes, reducing deployment time by 50% and ensuring consistent and reliable ETL operations.
BI & Data Engineer
Accenture
02.2019 - 01.2022
- Company Overview: Worked on Contract
- Created Parameterized dynamic Azure Data Factory ELT and ETL pipelines, dataflows to extract data from staging tables to partition with the incremental load into Azure SQL DB, DataLake.
- Create, maintain and updated ADF pipelines loading from both OLTP and OLAP database tables.
- Designed ADF, Synapses, Databricks data pipeline using various activities and T-SQL stored procedures to automate the data load process and automated these pipelines using triggers.
- Built end to end ELT solutions using Databricks, Delta Lake, Python, PySpark, that process the semi-structured data in the near real time and orchestrated to bring into structured format.
- Performed data quality analysis using advanced Python, SQL skills, performed count validation, dimensional analysis, and data quality validation in data migration on premises to cloud.
- Automated Databricks notebooks using various clusters, triggers depending on data volume.
- Developed multiple storytelling dashboards, analytical, KPI, and interactive reports based on business requirements using Power BI to support stakeholders, and Executive business needs.
- Generated time series reports for the stakeholders using different techniques like data filtering, adding interactivity, Slice and Dice, and deployed paginated reports to the Power BI services.
- Published paginated Power BI reports into Power BI services, created groups in Active directory to control the users, RLS, OLS, configured gateways to schedule the reports.
- Worked across multiple teams in a highly visible role and own the solution end-to-end.
- Worked on Contract
- Tech Stack: ADF, Synapse, DataLake, SQL Server, Power BI, Azure SQL, GitHub
BI & Data Engineer
Lodha Housing Group Ind
01.2020 - 04.2021
- Interact with stakeholder and to gather and understand the requirements and project objective.
- Consolidated large and complex datasets using Data Factory that met both functional and nonfunctional business requirement for reporting and Data warehousing solutions.
- Developed intuitive pipelines, dataflows for advanced analytics, access, clean, and blend data on multiple sources using Azure data factory pipelines and dataflows.
- Implemented event handlings and error handling in ADF pipelines and dataflows.
- Created event, scheduled, tumbling window triggers to automate Data factory pipelines, also used data factory to schedule data bricks notebooks notebook activity.
- Developed and maintained story telling SSRS, Power BI reports including delivering these reports in an easy way to understand manner for stakeholder and functional users.
- Used T-SQL to pull data from various SQL databases and created various dashboards, live pages, scorecards, and reports to support business decision making using Power BI.
- Created and provided documentations on data mapping, technical and functional specifications, security and production support, test cases and data dictionaries.
- Tech Stack: ADF, SQL Server, Power BI, SSRS, SSAS, Azure SQL, GitHub
BI Developer
Asian Pulp & Paper
02.2019 - 01.2020
- Work with Internal and external stakeholders to gather and understand BI requirements.
- Understanding the full scope of Power BI, Tableau requirements from business, estimating time and effort involved from gathering project requirements till project implementation.
- Using Power BI Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc and provides data insights.
- Develop and maintained and provide production support on business intelligence models to design, develop and generate both standard and ad-hoc reports using Power BI.
- Worked on Power BI, Power Pivot to develop data analysis prototype dashboards and used Power View, DAX, Power Query and Power Map to visualize reports.
- Published the reports, Create and Manage groups, Users, workspaces, Data sources and data connections in the Power BI services. Created RLS to restrict user permissions.
- Presented and communicated actionable insights in a way tailored to the specific stakeholders and client's needs which provided data and business recommendations.
- Worked on Power BI services and Tableau server to publish the reports and automate reports.
- Tech Stack: Power BI, Tableau, SSIS, SSRS, SQL Server, Excel
Education
MSc - Project Management
University of Roehampton
B. Tech - Mechanical Engineering
Guru Nanak Institutions Technical Campus
Skills
- Data Engineering
- ELT
- Data Warehousing
- Azure Data Factory
- Databricks
- Azure Synapse
- Data Lake Storage
- Azure SQL Database
- PySpark
- Delta Lake
- SQL
- Power BI
- Excel
- Azure DevOps
- Microsoft SQL-Server
Timeline
Data Engineer
Essure Technologies
04.2023 - 09.2024
BI & Data Engineer
Lodha Housing Group Ind
01.2020 - 04.2021
BI & Data Engineer
Accenture
02.2019 - 01.2022
BI Developer
Asian Pulp & Paper
02.2019 - 01.2020
MSc - Project Management
University of Roehampton
B. Tech - Mechanical Engineering
Guru Nanak Institutions Technical Campus
Similar Profiles
Vyankatesh WakharkarVyankatesh Wakharkar
Team Lead at Tata Technologies Ltd, Tata Technologies LimitedTeam Lead at Tata Technologies Ltd, Tata Technologies Limited
Ayush SinghAyush Singh
Client Partnership Manager at Tyroo Technologies Ltd (Divison of Smile Internet Technologies Ltd)Client Partnership Manager at Tyroo Technologies Ltd (Divison of Smile Internet Technologies Ltd)
SRIRAM RSRIRAM R
Software Quality Analyst at GAVS Technologies (formerly Neurealm Technologies Pvt Ltd)Software Quality Analyst at GAVS Technologies (formerly Neurealm Technologies Pvt Ltd)
Luther AliLuther Ali
Bus Driver at Stagecoach LondonBus Driver at Stagecoach London
PRAMOTH NAGARAJPRAMOTH NAGARAJ
Digital Marketing Specialist at Chennai DosaDigital Marketing Specialist at Chennai Dosa