Sambit Mishra

About Sambit Mishra

11 years of experience in Business Requirement Analysis, design, and development of various BI projects in Technology, Life Science, Media, and food/beverage industry as a BI developer and Reporting Analyst.• 5+ years of experience in design, building Visualization/Dashboards/Stories using Tableau and Microsoft Power BI for business data analytics and reporting applications.• Used Data Wrangling Technologies/tools (Alteryx/Tableau Prep) to clean and customize data from multiple sources to build semantic layer for the Self-Serve Reporting solution.• Using Microsoft POWER BI to report App Insights Data which is hosted in Microsoft Azure and Building Visual/Dashboard solution for Soda stream application.• 5+ years of experience in working Relation Database (Teradata, Oracle) using tools like Teradata SQL Assistance, Oracle SQL Developer and BTEQ for data analysis. Also, experienced in working with Big Data (Presto) environment to pull data for analysis and reporting.• Advance SQL knowledge with hands-on experience to write custom SQL and Stored Procedures to implement presentation layer and Data Validation.• Strong understanding of Data warehouse, Data Marts, ETL, Star Schema, Snowflake Schema, FACT and Dimensions tables, conceptual, logical, and physical data modeling.• Mastered the ability to design and deploy rich Graphic visualizations using Dual-axis, Dashboard Action, Drill Down, Quick Filters and Parameters, Used Data Blending, Cross Database join & Union technique to combine data from multiple sources to define aggregates.• Publish and Manage Data extract, user restriction on Tableau Workbook and data source in Tableau/Power BI Server.• Follow Best Practices to build effecting and good enough to great dashboard, experience in performance tuning and troubleshooting of Dashboards/Reports.• 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.

Experience

1. Data & Analytics

   PepsiCo

   Mar 2021 — Present · White Plains, NY, US

   PepsiCo Foodservice (PBNA)

Education

• Silicon Institute of Technology

  Bachelor’s Degree, Electrical and Electronics Engineering

  2010