Ankit 8+ Years Power BI, Data Analyst Experience

Ankit- 8+ Years Power BI, Data Analyst Experience

Product Manager – Accenture Feb 2022 – Oct 2022

Roles and Responsibilities Client – Diageo

 Led the Data Products and BI team in India Knowledge Center to design, build and deploy data products

including dashboards to Diageo with the goal of enabling better operational decisions that improve on-time

performance and customer experience.

 Interface with various Ops business groups to understand organizational needs and design requirements,

present solutions to leadership, and engage with Diageo leadership to execute high-priority strategic

projects.

 Help the developer team to build complex datasets that drive BI visualization and help our Ops leaders to go

from data to insights quickly and drive performance.

 Developer backend data layers, maintaining complex queries and generating actionable

insights using Power BI tools.

 Build and maintain the “single source of truth” for Diageo Ops Data and ensure data

integrity through a robust governance process.

 Oversight and leadership on the design, development, and implementation of automation

workflows across multiple functional areas including commercial, marketing, and supply.

Analyst – ValueLabs Feb 2021 – Feb 2022

Roles and Responsibilities Client – BAT

 Led the development of reporting solutions for 3 end markets (SA, Brazil & Chile)

 Lead a team to address the following analytical needs:

 Frontend data strategy – development of design in Figma, maintenance, and support

of our performance Power BI Dashboard.

 Collaborate and partner effectively with various stakeholders across the enterprise,

includingCommercial and Marketing Pod; respond to ad hoc strategic business questions

from senior management.

 Consultant to other areas of the enterprises, helping them built out data analytics

capabilities and resources.

 Manage strategic vendor relationships, e.g., analytics workbench, analytics tools and models,

and data visualizations, with a view to achieving high user satisfaction and optimal benefits for

BAT.

 Worked on new visuals to understand the correlation between different Brands and Competitor Brands.

Lead Associate BI – WNS Global Services July 2019 – Jan 2021

Roles and Responsibilities Client – GSK

 Led the development of reporting solution suite containing 9 Power BI reports and 4 Dashboards

for the US Medical Affairs Analytical department.

 Analyzed business requirements, created business/process flow charts, database flow charts,

andPower BI Reports for tracking Medical Engagements, Speaker Surveys, and understanding

the medical voice of Customers.

 Developed complex SQL queries and complex calculated measures using Data Analysis

Expression language (DAX) to support Power BI reports.

 Embedded Power BI reports on the Power BI Service and managed scheduled refresh and access

of reports and data for individual users using Roles.

 Provided continued maintenance and development of bug fixes for the existing and new Power

BI report.

BI Developer– 1ICT Private Limited Sep 2018 – Jul 2019

Roles and Responsibilities Client – Dominos ANZ

 Develop Enterprise-wide cascading reports in Power BI that were used throughout the Domino’s

store to monitor the sales, employee, and customer requirements.

 Developed multiple dashboards, analytical reports, KPIs, and Interactive reports based on

businessrequirements using Power BI to support executive business needs.

 Established live connection between the Teradata server and Power BI with the help of Power BIGateway.

 Experience in scheduling automatic refresh in Power BI Services, implementing RLS for different

types of management hierarchy.

 Created various financial and performance dashboards like Pizza checker, Product analysis,

DriverScreen Board, Store performance, and Sales performance for Dominos store.

Data Engineer – Wipro Technology Jun 2016 – Feb 2018

Roles and Responsibilities Client – Union Bank of India

 Data Engineer with expertise in the design and development of ETL processes for data

integrationfrom different sources in the banking domain using SSIS.

 Developed various ETL SSIS packages to extract data from SQL Server, applied different

transformations,and load the transformed data into the SQL Server staging tables for daily incremental

loading.

 Developed ETL packages to load daily incremental data to the OCRM application.

 Developed the ETL Data flows containing all the ETL packages for daily incremental loading.

 Developed ETL flow and scheduled it to run on a daily basis at the EOB to perform the ETL activity.

 Developed the T-SQL queries for ETL jobs to monitor the ETL flow rate and loaded data.

Technical Skills

 Technologies : Power BI, Power App, Figma, and Power Automate.

 Languages : DAX, SQL, Python, Statistics, ML, and NLP

 ETL Tools :

 Domain Knowledge : Pharma, Banking, Retail, FMCG & Beverage.

 Operating systems : Windows and Linux

 Microsoft Office : (Excel, Word, PowerPoint, Access)

 Relational databases : Snowflake, Microsoft SQL Server, ADB, Teradata.

Education

 B. TECH (72.83%) in Mechanical Engineering from Graphic Era University, Dehradun, 2016.

 Scored (8.4 CGPA) in Matriculation (2010) from Kendriya Vidyalaya, New Delhi.

 Scored (78%) Intermediate+2 (2012) from Kendriya Vidyalaya, New Delhi.

Declaration

I hereby declare that the Information furnished above is true to the best of my Knowledge.