Mudit Mishra Data Analyst

Data Analyst

Allstate

Jan 2023 - Current (3 years 8 months)

⮚ Conducted SQL-based data analysis, querying large datasets, and performing pivots to drive insights and informed decisions. ⮚ Streamlined reporting by designing an Employee Performance Dashboard in Tableau, reducing reporting time from two weeks to two days. Automated monthly KPIs, boosting real-time decision-making and team transparency ⮚ Collaborated with key stakeholders to understand business requirements, then designed and implemented advanced data models in Snowflake. This involved meticulous data cleaning and transformation, ensuring accurate insights and empowering data-driven strategies across the organization ⮚ Collaborated closely with cross-functional teams, ensuring data quality, consistency, and integrity by leveraging advan

D

SQL Consultant

DataLemur Ace the SQL Interview

Jun 2022 - Sep 2022 (4 months)

⮚ Designed and developed sophisticated SQL queries to enhance and develop individuals SQL skills. Also, conducted rigorous Beta testing to identify and resolve bugs, while refining the SQL query solutions to reduce complexity and improve efficiency. ⮚ Analyzed customer requirements and preferences to determine optimal product features, subsequently driving recommendations for their integration to boost user satisfaction and engagement and contributed significantly to the successful launch of the product.

A

Data Analyst

Above Beyond Studios Inc

Jun 2022 - Aug 2022 (3 months)

• Developed and implemented advanced analytics, creating a comprehensive Tableau dashboard to visualize the impact of cost, sales, channel, and region on revenue, enabling data-driven decision-making for improved business performance. • Established essential performance metrics and advised on tracking methodologies, enabling the continuous monitoring and optimization of marketing efforts. Also, collaborated with senior data analysts in the creation and maintenance of SQL queries and stored procedures to facilitate data extraction and reporting processes. • Collaborated with cross-functional teams to optimize product page design. Conducted internal training sessions on SQL and data analysis techniques, empowering team members to develop es

Statistics Instructor

California State University East Bay

Jan 2022 - Dec 2022 (1 year)

⮚ Elevated student proficiency in statistical data analysis, data interpretation, fostering a culture of data-driven decision making, critical to driving growth strategies in hyper-growth environments. ⮚ Guided more than 50 students in interpreting and analyzing datasets using statistical techniques, and helped them understand how to extract meaningful insights for informed decision-making, which is central to the role of a Data Analyst. ⮚ Developed and implemented a comprehensive curriculum, integrating hands-on applications with software tools, resulting in enhanced practical understanding and a 25% improvement in overall student performance. ⮚ Fostered active collaboration among students through group projects and case studies, simulatin

B

Data Analyst

Brown Frame Technologies

Nov 2019 - Jun 2021 (1 year 8 months)

⮚ Automated routine data processing tasks with Python, elevating the data preparation process's efficiency and accuracy, and facilitating streamlined data-driven decisions across business units. ⮚ Architected and rolled out optimized views and stored procedures in MySQL, catalyzing data accessibility and expediting critical data-driven workflows. ⮚ Leveraged Tableau to create intuitive, actionable dashboards, providing stakeholders with insights into critical business metrics and influencing strategic decisions. ⮚ Employed PySpark for large-scale data processing, ensuring efficient data transformation and analytics for vast datasets. ⮚ Directed and supervised an intern (who subsequently secured a permanent role) to delve into SQL queries,

Data Analyst

Cognizant

Jul 2018 - Oct 2019 (1 year 4 months)

⮚ Employed SQL and Tableau for in-depth healthcare data analysis, generating actionable analysis and insights for senior management. ⮚ Streamlined email campaigns with A/B testing, leveraging data insights to increase open rates by 15% and boost click-through rates by 10%. ⮚ Managed and streamlined healthcare data workflow within Adobe Campaign by orchestrating efficient data ingestion and ensuring seamless export of data to external systems for further quantitative or qualitative analysis. ⮚ Implemented data cleaning and validation techniques, resulting in a 10% reduction in data errors and an improved data integrity score. ⮚ Created and maintained an interactive dashboard and ad-hoc reports to present market research and competitor analy

Mudit Mishra

About

Detail

Timeline

Résumé