I thrive on turning raw data into clear, practical insights that help businesses make smarter decisions. For me, it’s not just about crunching numbers or spotting trends—it’s about finding the story behind the data and using it to solve real operational challenges. My work focuses on bridging the gap between technical analysis and actual business goals, ensuring complex findings are translated into clear strategies that improve efficiency and drive measurable growth.
I bring a mix of analytical rigor, curiosity, and a strongly collaborative approach to problem-solving. Whether it’s diving into large datasets to identify key performance metrics or refining internal processes, I enjoy working alongside cross-functional teams to make an impact. I am always eager to learn new tools and methodologies, embrace fresh challenges, and contribute to a team that values continuous improvement and data-driven innovation.
Career Objective
A highly analytical Data Professional skilled in statistical modeling, data visualization, and pipeline automation, seeking to transform complex raw datasets into clear executive dashboards and strategic business intelligence. Adept at bridging technical analysis with cross-functional leadership, I focus on optimizing reporting workflows and delivering data-backed solutions that streamline operations, improve performance, and drive measurable organizational growth in fast-paced environments.
Experience
16 years 3 months
Projects
1
Skills
20
Key Competencies
Collaborating with stakeholders to translate business problems into analytics solutions.
Handling data mining and data modeling tasks to extract meaningful patterns and trends for informed decision-making.
Implementing efficient data warehousing strategies to ensure streamlined data management and accessibility.
Leveraging advanced data analytical skills to identify key business insights and opportunities for growth.
Proficient in analyzing large and complex datasets to identify valuable trends and patterns.
Exceptional problem-solving abilities to tackle complex challenges and drive innovative solutions.
Skilled in creating storytelling dashboards and reports using Power BI/Tableau.
Expertise in data analysis and visualization using Power BI, Tableau, and Azure Analysis Services.
Strong knowledge of Power BI (Power Query - M Language, DAX, Visualizations, Power BI Service).
Strong knowledge of Excel, Power Pivot, Power View, Power Query.
Connecting Power BI to SAP, Oracle, Sales Force etc.
Perform ad-hoc analysis.
Analyze existing reports and optimize them for better performance and ease of use.
Proficient in developing Rest API endpoints, importing data from Rest APIs into Power BI/Tableau, and integrating them into Power Apps.
Skilled in creating and executing Power Automate Flows from Power BI for streamlined process automation.
Implementing strategy to archiving data that is no longer needed for processing or analysis.
Validate and reconcile data between the source and target systems during incremental or full load processing.
Skilled in designing and creating optimized data models for efficient querying and analysis.
Experienced in implementing various security measures, including Row Level Security, Object Level Security, and Page Level Security in Power BI
Managing gateways to ensure timely data updates and scheduled report refreshes.
Capable of creating custom visuals for Power BI using D3.js and other advanced tools.
Strong understanding of data modeling techniques and SQL queries.
Proficiency in query optimization and performance tuning for enhanced data processing efficiency.
Strong understanding of Data Warehousing concepts, specializing in Star, Snowflake, And Galaxy Schemas.
Proven ability to identify and resolve data quality issues and implement validation processes.
Efficient at diagnosing and resolving technical issues.
Experienced in designing, developing, and maintaining large-scale data solutions for storage, processing, and analysis of big data.
Skills
Python / PySpark
80%
Scala
75%
Spark SQL
80%
Power BI / Tableau
95%
Tabular Editor
80%
DAX Studio
80%
Power Query (M)
95%
Data Modeling
80%
Data Warehouse
80%
SQL / SQL Server
80%
Synapse Analytics
80%
Azure Data Factory
80%
Skills (In Years)
Microsoft Excel
Microsoft Excel
16 years 11 monthsSep-2009 To Sep-2026
VBA
VBA
16 years 11 monthsSep-2009 To Sep-2026
SQL / SQL Server
SQL / SQL Server
16 years 8 monthsJan-2010 To Sep-2026
Projects
Qlik to Power BI Migration
05-Mar-2025 To Current
Summary
An architecture revamp by Implementing a comprehensive modernize architecture by transitioning from on-premises servers to the cloud. The shift included migrating on-prem SSIS packages to Azure Cloud and migrating Qlik reports to Power BI.
Objectives
Enhance and optimize existing workflows using Azure Data Factory and Azure Synapse Analytics.
Process data using Azure Databricks, PySpark, and SparkSQL.
Improve data management by creating semantic models using Azure Analysis Services.
Enhance security by implementing dynamic row level, column level and object level security.
Enable self service
Enhance scalability
Improve Data Management
Technologies Used
ExcelPower BIAzure Data FactoryPySparkSQLSparkSQLAzure DatabricksLogic AppADLSRestAPI
Work History
WNS
WNS
1 year 5 monthsSep-2009 To Mar-2011
Self Employed
Self Employed
7 years 3 monthsMar-2011 To Jul-2018
Maersk
Maersk
3 years 7 monthsJul-2018 To Feb-2022
Education
S.S.C. (10th), Maharashtra Board
S.S.C. (10th), Maharashtra Board
9 years 9 monthsJun-1993 To Mar-2003
H.S.C. (12th), Maharashtra Board
H.S.C. (12th), Maharashtra Board
2 years 9 monthsJun-2003 To Mar-2006
B.Com, Pune University
B.Com, Pune University
Education
B.Com, Pune University
Jun-2006 To Mar-2009
H.S.C. (12th), Maharashtra Board
Jun-2003 To Mar-2006
S.S.C. (10th), Maharashtra Board
Jun-1993 To Mar-2003
Certifications
DP-203 (Microsoft Certified Data Engineer)
Jun-2023
PL-300 (Microsoft Certified Power BI Data Analyst)
Sep-2022
Microsoft Certified - Office Word 2007 Expert
Nov-2012
Microsoft Certified - Office PowerPoint 2007 Specialist
Nov-2012
Microsoft Certified - Office Access 2007 Specialist
Nov-2012
Microsoft Certified - Microsoft Office 2007 Specialist Master
Nov-2012
Microsoft Certified - Office Access 2010 Specialist
Nov-2012
Microsoft Certified - Microsoft Office 2010 Specialist Master
Nov-2012
Personal Information
Gender :
Male
Marital Status :
Married
Birthday :
28-Jun-1988
Email :
hellosagarthorat@gmail.com
Mobile :
+919923103183 | +919130062006
Address :
Malwadi Vasti, Lohgaon-Wagholi Road, Pune - 411047
Country :
India
Certifications
12
Designing the scalable data architecture necessary for storing and processing large volumes of data.
Clean, Transform and Reshape data and create a robust, highly scalable data model as per business requirements and process it using Scala, Python, PySpark and Spark SQL.
Implementing Change data capture (CDC) using Azure Data Factory And Azure Databricks to identify, capture and process only the changed data using Incremental load.
Create CI/CD pipeline for deploying projects to higher environments (test, pre-prod and prod).
Creating and managing integration runtime connects to on-premise servers and moving data to the cloud.
Proficient in integrating data from diverse source systems, including SAP, Oracle, Salesforce, and Rest APIs.
Strong programming proficiency in Python, PySpark, SQL, and VBA, enabling the development of robust data solutions.
Implementation of ETL/ELT pipelines and data warehouse solutions using different Azure services, including Azure Data Factory, Azure Databricks, Azure
Monitoring, debugging, enhancing, and maintaining existing workflows and solutions.
Experienced in utilizing Logic App to perform various automated tasks.
Preparing technical and support documentation.
Developed 150+ automation projects by integrating various applications like Excel, Access - SQL, Word, Power Point, Outlook, Share Point, Internet, Mainframe, SQL Server, SAP, Oracle Database etc.
Provide leadership by training, coaching, mentoring, and managing a team of junior and senior data engineers and analysts. Foster a collaborative and growth-oriented team culture, ensuring the development of skills and knowledge within the team.
Azure Databricks
80%
Logic App / Power App
80%
Power Automate
75%
Azure Key Vault
80%
ADLS / BLOB
80%
Microsoft Excel
95%
VBA
95%
Python
80%
Data Modeling
Data Modeling
14 years 8 monthsJan-2012 To Sep-2026
Data Warehouse
Data Warehouse
14 years 8 monthsJan-2012 To Sep-2026
Power Query (M)
Power Query (M)
13 years 8 monthsJan-2013 To Sep-2026
Power BI / Tableau
Power BI / Tableau
13 years 2 monthsJul-2013 To Sep-2026
Python
Python
9 years 3 monthsJun-2017 To Sep-2026
Tabular Editor
Tabular Editor
8 years 8 monthsJan-2018 To Sep-2026
DAX Studio
DAX Studio
8 years 8 monthsJan-2018 To Sep-2026
Logic App / Power App
Logic App / Power App
8 years 8 monthsJan-2018 To Sep-2026
Python / PySpark
Python / PySpark
8 years 2 monthsJul-2018 To Sep-2026
Scala
Scala
8 years 2 monthsJul-2018 To Sep-2026
Spark SQL
Spark SQL
8 years 2 monthsJul-2018 To Sep-2026
Synapse Analytics
Synapse Analytics
8 years 2 monthsJul-2018 To Sep-2026
Azure Data Factory
Azure Data Factory
8 years 2 monthsJul-2018 To Sep-2026
Azure Databricks
Azure Databricks
8 years 2 monthsJul-2018 To Sep-2026
Azure Key Vault
Azure Key Vault
8 years 2 monthsJul-2018 To Sep-2026
ADLS / BLOB
ADLS / BLOB
8 years 2 monthsJul-2018 To Sep-2026
Power Automate
Power Automate
5 years 8 monthsJan-2021 To Sep-2026
Scala
Roles & Responsibilities
Demonstrated expertise in rewriting and optimizing SSIS packages using Azure Data Factory or Azure Synapse Analytics.
Implemented PySpark And SparkSQL to Clean, transform and reshape data as per business requirements.
Led successful migration of complex Qlik applications to Power BI.
Demonstrated expertise in translating Qlik expressions and scripting to DAX for optimal performance and functionality in Power BI reports and dashboards.
Collaborated closely with cross-functional teams to analyze existing Qlik applications, identify migration challenges, and implement strategic solutions for a smooth transition.
Conducted comprehensive training sessions for end-users and provided ongoing support to ensure a swift and effective migration process.
Bridgestone
Bridgestone
6 monthsMar-2022 To Oct-2022
Damac
Damac
7 monthsOct-2022 To May-2023
Alef Education
Alef Education
5 monthsJun-2023 To Nov-2023
Learning Circle
Learning Circle
2 years 6 monthsMar-2024 To Current
Learning Circle
Founder, BI & Cloud Expert, Pune
01-Mar-2024 To Current
Technologies Used
ExcelPower BIAzure Data FactoryPySparkSQLSparkSQLAzure DatabricksLogic AppADLSRestAPIScala
Roles & Responsibilities
Demonstrated expertise in rewriting and optimizing SSIS packages using Azure Data Factory or Azure Synapse Analytics.
Implemented PySpark And SparkSQL to Clean, transform and reshape data as per business requirements.
Led successful migration of complex Qlik applications to Power BI.
Demonstrated expertise in translating Qlik expressions and scripting to DAX for optimal performance and functionality in Power BI reports and dashboards.
Collaborated closely with cross-functional teams to analyze existing Qlik applications, identify migration challenges, and implement strategic solutions for a smooth transition.
Conducted comprehensive training sessions for end-users and provided ongoing support to ensure a swift and effective migration process.
Collaborate with stakeholders to translate business problems into analytics solutions.
Conducted data mining and modeling tasks.
Extracted meaningful patterns for informed decision-making.
Implemented efficient data warehousing strategies for streamlined data management.
Validated and reconciled data between the source and target systems during incremental or full load processing.
Implemented strategy to archiving data that is no longer needed for reporting or analysis.
Enhance and optimize existing workflows using Azure Data Factory and Azure Synapse Analytics.
Implemented various security measures, including Row Level Security, Object Level Security, and Page Level Security in Power BI/Tableau.
Damac
Senior Data Engineer, Dubai
31-Oct-2022 To 31-May-2023
Technologies Used
Logic AppAzure DatabricksSynapse AnalyticsSpark SQLPower BIAzure Data FactoryExcel
Roles & Responsibilities
Analyzed PII Data and implemented dynamic masking based on user roles and groups.
Clean, Transform and Reshape data and create a robust, highly scalable data model as per business requirements and process it using Scala, Python, PySpark and Spark SQL.
Migrated traditional data pipelines to modern data pipelines using Azure Data Factory And Synapse Analytics.
Created complex interfaces and tuned ETL processes for improved performance using T/SQL Procedures/Functions.
Managed daily data operations and migrated legacy pipelines to Azure ADF.
Addressed ad hoc issues in the business logic layer built using Databricks notebooks.
Designed and developed a comprehensive data analytics platform, including Customer One View for marketing and finance insights.
Deploying project to test and prod environment.
Created Rest API end points to expose data to business users.
Created storytelling dashboards and reports using Power BI, Tableau, and Azure Analysis Services.
Implemented workflows using Azure Data Factory / Azure Synapse Analytics.
Created logic app to send trigger email upon pipeline failure.
Created data validation pipeline to match data from source (raw data) to target (post processing data) and trigger email on gaps.
Created workflows using medallion (bronze, silver and gold layer) architecture.
Implemented Azure Event Grid to centralized event management.
Implemented streaming jobs and create real time dashboard using Power BI
Provided leadership by managing a team of data engineers and analysts, fostering a collaborative and growth-oriented team culture.
Maersk
Senior Data Engineer, Pune
05-Jul-2018 To 25-Feb-2022
Technologies Used
Data ModelingData WarehouseSQLVBAPower BIDAX StudioSpark SQLAzure Key VaultAzure Data FactoryAzure DatabricksADLS / BLOB
Roles & Responsibilities
Utilized Power BI and Tableau skills to create storytelling dashboards and reports, presenting key business insights and opportunities for growth.
Conducted ad-hoc analysis, analyze existing reports, and optimize them for improved performance and user-friendliness.
Created logic app to trigger emails, auto pdf generation, exporting data to csv format.
Created work flows using Azure Databricks, Spark SQL and Scala as per business requirement.
Created ADF Pipeline to load data from various sources to ADLS Gen2.
Performed data mining and modeling tasks to extract meaningful patterns and trends from large and complex datasets, enhancing decision-making processes.
Implemented strategies to optimize data warehousing, ensuring streamlined data management and accessibility for efficient analysis.
Created Data Warehouse using SSIS, SQL Server etc.
Created 100+ dynamic & robust automation Tool using Excel, VBA, Access, SQL, VB.Net, MySQL
Handled multiple trainings For Advanced Excel, VBA Macro, SQL Server, SSIS, VB.Net, VB6, Web Designing, Web Development, SQL, Access & Many More
WNS
Customer Service Associate, Pune
28-Sep-2009 To 02-Mar-2011
Technologies Used
VBAExcelAccessSQLWeb ScrapingWordPower Point
Roles & Responsibilities
Implemented 50+ automation projects by integrating various applications like Excel, VBA Macro, Access, SQL, SQL Server, Word, Power Point, Outlook, Share Point, Internet, Mainframe and Oracle Database
Prepared database tools using Access VBA, SQL and User Forms
Automatic creation of PowerPoint/Word files from excel and access data.
2 years 9 months
Jun-2006 To Mar-2009
Microsoft Certified - Office PowerPoint 2010 Specialist
Nov-2012
Microsoft Certified - Office Word 2010 Expert
Nov-2012
Microsoft Certified - Office Excel 2010 Expert
Nov-2012
Microsoft Certified - Office Excel 2007 Expert
May-2012
Implemented SCD Type 2
Implemented Incremental And Full Load Strategies
Reviewing codes created by other developers before moving them to higher environments.