Manish Yadav Email & Phone Number

Edmonton, Alberta, Canada

• Optimized data warehouse schema design (BigQuery) and complex SQL queries, accelerating analytics performance by 30%.• Built a data quality monitoring framework (Python, Looker), reducing data inconsistencies by 15% and improving confidence in business decisions.• Optimized data quality and streamlined processes. Improved data quality by 15% and reduced processing errors by 10% through cleansing and optimization using SQL and Python.• Delivered actionable insights through targeted analysis. Analyzed customer segmentation and campaign data using SQL, Python, and Excel (Macros) to develop targeted marketing lists (~6K per list), directly contributing to a 15% sales increase.• Created financial dashboards for informed budgeting. Developed Power BI/Looker dashboards for revenue tracking, facilitating real-time forecasting and data-driven budget insights.• Developed a robust ETL process (Python, SQL) to integrate data from multiple sources, increasing data accessibility and completeness for business intelligence.• Proactively optimized data processes, including complex customer segmentation analysis. Documented streamlined workflows and automated them leading to a 10% reduction in processing errors.

Toronto, Ontario, Canada

• Analyzed financial statements, business summary reports, and dashboard recaps to attain data based on product comparable percentages to help clients sell their products right.• Coordinate all the stages of various projects: developing measurement tools (discussion guides, questionnaires), equipment management, validating questionnaire test links, field monitoring, verifying, and analyzing results, data entry, writing summaries, preparing strategic recommendations and qualitative research follow-ups• Evaluated 100+ employees in 6 departments through surveys and office hours assessing strengths and overall skills which improved productivity for tasks by 23% daily.

Toronto, Ontario, Canada

• As a data analyst I worked with election data of City of Toronto using Shiny R, Excel, and Power BI, I was responsible for analyzing and visualizing the city council election results from the past 10 years. One of the key highlights of my job was using my analytical skills to uncover patterns and trends in the election data, which helped inform decision-making for future elections.• Using Shiny R, I developed interactive dashboards that allowed stakeholders to explore the data in a user-friendly and accessible way. I also used Excel to clean and manipulate the data, ensuring its accuracy and completeness. In addition, I leveraged Power BI to create compelling visualizations that communicated complex data insights to a variety of audiences.• Overall, my work as a data analyst with election data of City of Toronto allowed me to play a critical role in improving the city's electoral processes. By using data-driven insights to inform decision-making, I was able to contribute to a more transparent, fair, and effective election system.

• Surveyed hundreds of patients and doctors using SurveyMonkey and mail survey.• Entered the collected survey data in Excel and combined that with the Hospital data.• Lead a deep-dive analysis of hospital data to identify inefficiencies in the data recording process.• Analyzed the cleaned data, prepared visualization, and presented it to the doctors and researcher.• Prepare background information and research for proposals and reports. • Worked with a research team in proposal development, questionnaire design, and creating discussion guides. • Collected desired number of respondents through mail surveys and telephone interviews with physicians in rural areas. • Analysed data using Excel and SPSS and prepared visualization as part of the final report.

Post Graduate Certificate, Big Data Analytics, 7.9 Cgpa

Post Graduate Certificate, Research Analysis, 8.0 Cgpa

Bachelor'S Degree, Mathematics, 7.37 Cgpa