Mohit is a Power BI Developer with 6+ years of experience in data analysis and visualization. He has a strong background in SQL and Python, and has successfully led multiple projects in the E-commerce and Education domains.
Designed and developed real-time analytics pipelines to track customer behavior and order trends.
Optimised dashboard performance, reducing load times by 30% for enhanced user experience.
Led the creation of multiple dashboards for educational initiatives, providing actionable insights for stakeholders.
Built Smart Commerce + GKP + Life Skills + Training Dashboards
Overview: Designed and developed real-time analytics pipelines to track customer behavior, order trends, and inventory levels. Responsibilities included implementing Reverse ETL using DBT and migrating the order processing warehouse to Snowflake for improved performance.
Key outcomes:
Migrated order processing and transaction warehouse to Snowflake, improving query performance.
Developed APIs for real-time order tracking and sales reports.
Overview: Led the development of a Power BI dashboard focused on a learning activity. Responsibilities included gathering requirements, designing data models, and optimizing dashboard performance.
Key outcomes:
Gathered and documented detailed project requirements.
Optimised dashboard performance, reducing load times by 30%.
Overview: Led the creation of a Power BI dashboard focused on life skills education. Responsibilities included gathering requirements and establishing data connections using PostgreSQL.
Key outcomes:
Designed and built a comprehensive dashboard to visualize key metrics.
Established and managed data connections with PostgreSQL.
Led the design and development of a Training Dashboard using Looker Studio, focusing on tracking training progress and creating custom tables for specific insights. Utilized SQL and Power Automate to ensure seamless data integration, enabling effective analysis of training outcomes and metrics.
Mohit
Power BI Developer