SUSHIL CHAUHAN
Mumbai,MH
Summary
Over 3 years of experience in Azure Data Stack, specializing in data visualization, reporting, and dashboarding. Proficient in Azure Data Factory, GCP BigQuery, SQL, Excel, and Power BI, with a strong focus on analytical skills and problem-solving. Experienced in utilizing Airflow for batch data processing and managing teams for report development, data lake, and data warehouse projects.
Overview
4
4
years of professional experience
Work History
Sr. Associate BI Reporting
Lumina Datamatics
09.2024 - Current
- Orchestrated data from SQL Server using BigQuery (GCP) for efficient processing and analysis
- Performed ETL processes to support Power BI dashboards and reporting
- Gained Hands-On Experience with Apache Airflow to automate ETL workflows from data source to destination
- Worked with the Azure Data Stack, utilizing Azure Data Factory to orchestrate and load data into a Data Warehouse
- Developed Power BI reports to analyse customer support centre performance, created SLA uptime reports, and conducted descriptive analysis
Analyst
Sceniuz
11.2022 - 09.2024
- Automated the data integration using Azure Data Factory, reducing the error and delay for the BI Report generation
- Implemented Azure Data Lake Store for thin provisioning of data, reducing storage costs
- Managed Azure SQL Database for maintaining scalable and reliable data storage solution, improving uptime by 95%
- Orchestrated data from SAP-BW to the SQL Warehouse for Analytics and Reporting, reduce the data gathering and integration time
- Designed and developed Power BI Dashboard and reports for Accounts Receivable to review the KPI; results in better payment collection and achieving the collection target
- Develop scalable data pipelines using Databricks and Apache Spark technologies
- Implement data lake solutions leveraging Delta Lake for efficient data storage & Automate ETL processes to enhance data processing efficiency and reliability
- Automated data validation processes, decreasing error rates and ensuring data accuracy for critical business reports
- Experience in the Project management, managing stakeholder and development team
Business Analyst
Computer Forest Inc
06.2021 - 08.2022
- Collaborated with stakeholders to identify key performance indicators, resulting in improvement in operational efficiency through targeted data insights
- Assisted in the migration of legacy systems to a modern data warehouse, improving data accessibility and reporting capabilities for the organization
- Design and implement data models using advanced BI tools and technologies
- Develop interactive dashboards and reports to support data-driven decision-making
- Collaborate with cross-functional teams to gather and analyse business requirements
Education
Bachelor of Engineering - Information Technology
KJ Somaiya Institute of Technology
Mumbai, Maharashtra05.2015
Skills
- Power BI
- Docker
- Apache Airflow
- Data Modelling
- Pandas
- Project Management
- PySpark
- Data Visualization
- Azure Data Warehouse
- Azure Data Factory
- Python
- Data Cleaning
- DAX
- SQL
- T-SQL
- ETL
- ELT
- Databricks - Apache PySpark
Accomplishments
- DP-600 - Fabric Analytics Engineer Associate.
- DP-203 - Azure Data Engineering.
- PL-300 - Microsoft Power BI Analyst.
- DP-900 Azure Data Fundamental.
- AZ-900 - Azure Fundamental.
Timeline
Sr. Associate BI Reporting
Lumina Datamatics
09.2024 - Current
Analyst
Sceniuz
11.2022 - 09.2024
Business Analyst
Computer Forest Inc
06.2021 - 08.2022
Bachelor of Engineering - Information Technology
KJ Somaiya Institute of Technology
Similar Profiles
Arish SampathArish Sampath
Senior Executive at Lumina DatamaticsSenior Executive at Lumina Datamatics
Sai Sruthi S VSai Sruthi S V
Editorial Assistant at Lumina DatamaticsEditorial Assistant at Lumina Datamatics
Gautam KapahiGautam Kapahi
Head - Presales, Solutions & Transitions at Lumina DatamaticsHead - Presales, Solutions & Transitions at Lumina Datamatics