Microsoft Power Platform
SAMBIT MISHRA
Senior Associate (BI &Data Analysis)
Bengaluru
Summary
- Business and data analyst with 11 years of experience across diverse industries such as Technology, Life Science, Media, and food/beverage industry.
- Expertise in analysis and testing of business requirements to drive deployment of applications, business processes and system solutions.
- Motivated and results-driven Analyst with proven track record in data analytics and process mapping. Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency. Drives business effectiveness through making recommendations based on data findings.
- Experience in design, building rich dashboards and reports using Power BI & Tableau.
- Used Data Wrangling Technologies/tools (Alteryx/Tableau Prep) to clean and customize data from multiple sources to build semantic layer for Self-Serve Reporting solution.
- Experience in working Relational Database design/modeling, and using tools like Teradata SQL Assistance, Oracle SQL Developer, SSMS and BTEQ for data analysis and validation. Also experience in working with Big Data (Hive) environment.
- Strong understanding of Data warehouse, Data Marts, ETL, Star Schema, Snowflake Schema, FACT and Dimensions tables, conceptual, logical, and physical data modeling.
- Advance SQL knowledge with hands-on experience to write custom SQL and Stored Procedures to implement presentation layer to build the aggregates/KPI.
- Extensive knowledge in various reporting objects like Dimension, Measures, Hierarchies, filters, calculated fields, Sets, Groups, Parameters etc.
- Mastered the ability to design and deploy rich Graphic visualizations using Dual axis, Dashboard Action, Drill Down, Quick Filters and Parameters.
- Follow Best Practices to build effecting and good enough to great dashboard, experience in performance tuning and troubleshooting of Power BI & Tableau Dashboards/Reports.
- Highly analytical and detailed with documented track record in full software development life cycle (SDLC) methodologies and Agile techniques.
- Strong Problem-solving skills with the ability to determine Business Partner needs and create purpose-built solution.
- Self-Learner and Ability to work both independently and as a Team member.
Overview
12
12
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
Work History
Senior Associate Technology
PepsiCo Inc
Bengalu
04.2021 - Current
- Gathered Business Requirements, interacted with Users, Business Analyst, Project Manager and SMEs to get better understanding of Business Processes.
- Performed data analysis and data profiling using SQL on both cloud (Azure Data Lake) and on-prem system (Teradata).
- Writing complex queries to join/combine data from different table in multiple data bases/schema to build/model presentation layer to support reporting application requirement.
- Assist Pepsi Foodservice Business partner with ad-hoc analysis, UAT support, and testing of different data and reporting applications.
- Co-ordinate with IT team to convert Custom SQL to create materialized tables/views and provide support during data center migration activities.
- Working with SSTP business team to gather the requirement for Power BI premium workspace set up and user access management.
- Work with complex Database queries and slow running reports and applied performance optimization/improvement steps/techniques to improve report queries and report performance.
- Partnership with Cloud Data Engineer to migrate on-premises database to Azure Data Lake and leading data validation of application post migration to cloud.
Senior Data & Reporting Analyst
PepsiCo Inc.
White Plains
09.2017 - 03.2022
- Gathered Business Requirements, interacted with Users, Business Analyst, Project Manager and SMEs to get better understanding of Business Processes.
- Performed data analysis and data profiling using SQL on both cloud (Azure Data Lake) and on-prem system (Teradata).
- Writing complex queries to join/combine data from different table in multiple data bases/schema to build/model presentation layer to support reporting application requirement.
- Assist Pepsi Retail and Foodservice Business partner with ad-hoc analysis, UAT support, and testing of different data and reporting applications.
- Co-ordinate with IT team to convert Custom SQL to create materialized tables/views and involve in performance tuning of queries.
- Data Cleaning and preparation using Alteryx and Tableau Prep to build semantic layer for Self-Serve reporting tool.
- Created End-to-End test cases; involved in integrated testing and support user acceptance testing.
- Created tableau Data extract and used shared Tableau extract to use across different reports and manage user access request.
- Work with complex Database queries and slow running reports and applied performance optimization/improvement steps/techniques to improve report queries performance by 70-80%.
- Partnership with Cloud Data Engineer to migrate on-premises database to Azure Data Lake and leading data validation of application post migration to cloud.
- Prepared product demo for end users to help them understand tool and application functionality.
Senior BI Developer
The Walt Disney Company
ORLANDO
03.2017 - 09.2017
- Partner with internal and external teams; working across multiple functional units including internal system end users, Revenue Management and Technology.
- Understand and analyze the existing visualization and underlying source system.
- Build Pricing and Booking dashboard to help the team in Business and Operation dashboard development activity to meet the delivery deadline.
- Created Calculated metrics to convert Number format to represent the KPI in Thousands (K), Millions (M) and Billion (B).
- Created Tableau Data extract and used the shared data extract on server for dashboard reporting.
- Querying data from Oracle and SQL Server to analyze and validate the quality of data, built Custom SQL and PL/SQL for reporting need.
- Prepared one and two parameters Visualization link and co-ordinate with the UI team to embed the server links with UI portal.
- Used quick table calculation and calculated field for Top/Bottom analysis, Parameter control for User interaction.
- Used Dashboard action to switch among the different reports, Navigation between Summary and detail reporting.
BI Developer
Biogen Inc
Durham
07.2016 - 02.2017
- Requirement analysis and creating data mapping documents identifying key data elements and prepared requirement specifications and data flow diagrams.
- Worked in coordination with clients for feasibility study of the project in Tableau and with DB Teams for designing the database as per project requirement.
- Prepared High-level design document and project plan.
- Designed and developed various analytical reports from multiple data sources by blending data in Tableau Desktop.
- Used custom SQL queries to fetch data from the presentation layer to Tableau for reporting.
- Build Tableau dashboard and Stories using Bar, Line, Text Table and Tree Map for FDA Reporting.
- Created Heat Map, Tree Map, Highlighted tables to report the Active/In-active Patients, Prescribes & Pharmacies information across territory and states.
- Developed various reports using Tableau features like Parameters, Filters, Sets, Groups, Actions, etc.
- To present users with various scenarios of predictive analysis.
- Prepared FDA Submission document and review with Business team.
BI Techno Functional Lead
Apple
Sunnyvale
07.2010 - 06.2016
- Analyze the Business Requirement Doc, Creating Requirement gap tracker, and project plan.
- Developed the ER diagrams for reports, which gives the information about the underlying source and their relationship.
- Created data mapping documents identifying key data elements and prepared requirement specifications, data flow diagrams and design doc.
- Review the Data Mapping and Design Doc with Business team and update the documents based on Business feedback and created Dashboard mock-up.
- Modeled the underlying source that used in Tableau visualization and dashboard for Reseller WW Operation team.
- Performance analysis of BO reports and database queries.
- Preparing Unit and Integration test scripts and provide supports during User Acceptance Testing.
- Preparing Implementation Plan, back out Plan and involved in Release management activity.
- Provide support after project deployment (Release note, Post Validation, and warrant Support etc.
Education
Bachelor of Technology - Electrical & Electronics Engineering
Silicon Institute of Technology
Odisha, India 07.2006 - 06.2010
Skills
Business Intelligence
Microsoft Power BI
Tableau
SQL
Data Analysis
Cloud (Microsoft Azure)
Teradata & Data Warehousing
Certification
Tableau Desktop Certified Associate
Interests
Microsoft Azure
Timeline
Senior Associate Technology
PepsiCo Inc
04.2021 - Current
AZ:900 Microsoft Azure Fundamentals
06-2020
Tableau Desktop Certified Associate
07-2019
Senior Data & Reporting Analyst
PepsiCo Inc.
09.2017 - 03.2022
Senior BI Developer
The Walt Disney Company
03.2017 - 09.2017
BI Developer
Biogen Inc
07.2016 - 02.2017
BI Techno Functional Lead
Apple
07.2010 - 06.2016
Bachelor of Technology - Electrical & Electronics Engineering
Silicon Institute of Technology
07.2006 - 06.2010