Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic
Aditya Pratap Singh

Aditya Pratap Singh

Technical Lead BI
Pune

Summary

Experienced Power BI/MSBI Professional with 5.5 years of Power BI experience and 15+ years of IT experience specializing in Microsoft Business Intelligence. Successfully led teams in developing BI solutions and reporting, improving business decision-making through data analysis. Proficient in ETL pipelines, data warehousing, and data visualization using Power BI, with hands-on experience in Power BI Service and report refresh scheduling. Skilled in gathering, analyzing, and visualizing data from Oracle, SQL, and Analysis Services databases, utilizing DAX for complex measures and custom columns. Experienced in creating detailed reports focused on performance optimization for improved customer satisfaction and usability. Familiar with full BI concepts including Power BI, SSIS, and SSAS, with expertise in data modeling using Relational Data Modeling and extensive knowledge of ETL and Business Intelligence processes.

Overview

15
15
years of professional experience
4
4
years of post-secondary education
2
2
Certifications

Work History

Technical Lead (BI)

Birlasoft
07.2020 - Current
  • Led the design and implementation of Power BI architecture to integrate with cloud databases, ensuring scalability and optimized performance.
  • Worked as Team Lead to Gather requirements and Spearheaded discussions with the Client for Solution Discussion and Deliverables.
  • Led a team of junior developers to Migrate Qlik Report to Power BI, migrating Oracle Jde and xls source data to Azure Data Lake Storage.
  • Led the team to Set up data integration solutions using Azure Data Factory.
  • Created KPI'S consuming data from Azure Synapse analytics and visualizing through Power BI.
  • Developed complex data models within Power BI to transform and analyze data efficiently, ensuring accuracy in business reporting and insights.
  • Spearheaded the creation of interactive Power BI reports and dashboards, replacing legacy Qlik dashboards, and aligning with business requirements for improved decision-making.
  • Collaborated with the Azure team to ensure seamless integration of the migrated cloud data into Power BI, optimizing data refresh schedules and performance.
  • Worked closely with business stakeholders to understand reporting requirements, translate them into technical specifications, and deliver user-friendly reports that provide actionable insights.
  • Provided training to end-users and teams on how to utilize Power BI dashboards effectively, ensuring smooth adoption and self-service BI capabilities.
  • Coordinated with Azure teams to ensure optimal data flow between the cloud environment and Power BI, resolving any data integration challenges.
  • As a Power Bi Developer Created and managed power bi reports for Operational plant and supply chain management.
  • Developed, tested, deployed and shared reports to users across business plants and several users and stakeholders.
  • Designed visuals to show KPI'S like on time delivery metrics through bar charts, inventory stock through line charts etc.
  • Worked On SSAS Tabular Models, Partitions, Processing.
  • Experienced in pulling data from different data sources and integration in the SSAS Model.
  • Exposure to Databricks Sql and Azure cloud storage to consume data and include or insert in data model.
  • High level exposure to Power BI Copilot and Q&A,Synonyms,Natural language query processing.
  • Worked on Complex DAX measures and calculations in the Model.
  • Creating interactive visual reports using BI tools.
  • Worked on Gateways, power bi import and direct query mode.
  • Optimized Performance of the SSAS Model by querying and fetching data directly from Databricks Sql and eliminating the Sql layer which was Memory Extensive.
  • Led the design and implementation of Power BI architecture to integrate with cloud databases, ensuring scalability and optimized performance.

Senior Business Intelligence Analyst

Travelex India Pvt Ltd
02.2016 - 05.2020
  • Involved in Cube Migration Activity from dts 2000 to sql 2008.
  • Complex issues Resolution and using technical expertise to provide value add to business and efficient root cause analysis.
  • Worked Onsite (Amsterdam) to handle critical business needs and provide offshore with relevant KT and implementation of new modules in project.
  • Stakeholder management and Biweekly catchup calls with business.
  • Development of SSIS Packages to automate existing manual Loading Process for day-to-day business.
  • SAP Crystal. Report Enhancements and Development.
  • Involved in Unit and Integration testing with UAT.
  • Involved in Cube Migration Activity from dts 2000 to sql 2008.

IT Analyst

Tata Consultancy Services
12.2009 - 05.2015
  • As a Developer played an active role in Working on SQL Server 2005 & SSIS, SSAS and XL Cube interface.
  • Designing cubes on SSAS 2005, with all typical features - dimension, hierarchies, facts, calculated members, partitions, aggregations.
  • Worked on writing mdx queries for data retrieval and reporting from cube.
  • Designed reports and published on XL3 Cubed tool.
  • Developed SSRS reports for POC (Proof Of Concept).
  • Have an apt knowledge about the functionality of the system and was actively involved in all enhancements and modifications which came up in the project.
  • Handled all types of incidents from Business Users which led to code changes if required in SSIS, Cubes or Database and XL Cube.
  • Fair Knowledge of data warehouse concepts used in the project resulted in effective debugging and issue resolution.
  • Handled several calls for requirements gathering for new enhancements.
  • As a Developer played an active role in Working on SQL Server 2005 & SSIS, SSAS and XL Cube interface.

Education

Bachelor of Engineering - Information Technology

GRKIST
06.2005 - 06.2009

Skills

  • Power BI

  • Dax

  • Agile/Scrum Methodology

  • Azure Devops Board

  • Safe Agile Framework

  • Azure Databricks SQL

  • Azure Data Factory

  • DAX Studio

  • SQL Server 2019 (T-SQL)

  • SQL Server Analysis Services (SSAS)

  • SQL Server Integration Services (SSIS)

Certification

Completed DA-100: Analyzing Data with Microsoft Power BI

Accomplishments

  • Highly successful Go Live MSBI Project within one month, post go live client was able to achieve more than the Target Expected.
  • Received Star points from manager for Go getter Attitude and Commitment.
  • Delighted Customer Award for exceeding client expectations (06/2017).
  • Delighted Customer Award for getting Incidents count to 0 (01/2017).

Timeline

Technical Lead (BI)

Birlasoft
07.2020 - Current

Senior Business Intelligence Analyst

Travelex India Pvt Ltd
02.2016 - 05.2020

IT Analyst

Tata Consultancy Services
12.2009 - 05.2015

Bachelor of Engineering - Information Technology

GRKIST
06.2005 - 06.2009

Similar Profiles

CREATE PROFILE
Aditya Pratap SinghTechnical Lead BI