Divya Pokhriyal, Ph.D. Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

Toronto, Ontario, Canada

Toronto, Ontario, Canada

• Spearheading the development of visually captivating and interactive risk reports and dashboards using advanced Power BI features, enhancing data visualization and enabling data-driven storytelling for effective decision-making.• Used SQL and Python to develop profit analysis models by leveraging financial data and key performance indicators for a retail chain and achieving revenue stream optimization and maximizing customer outreach, leading to an increase in profit margins by 14%.• Utilized SQL and SAS to assess credit risk associated with credit card usage for microfinance institutions (MFI) and reduced default payments by 4% by identifying customers at high risk of defaulting on their payments by cleaning and analyzing customer data, including payment history and credit utilization.• Used DAX libraries on Power BI and conducted a data analysis of the relationship between company stock prices and industry trends, achieving a 3% more accurate performance prediction than in previous years.• Collaborated with the customer Strategy and Insights teams Power BI dashboards to deliver insights and recommendations to senior leadership teams.

• Led requirement gathering sessions with stakeholders to define project scope and objectives, ensuring alignment with business goals.• Analyzed competitors' sales performance and market positioning using SQL for an e-commerce platform to identify areas of improvement. Leveraged findings to devise competitive strategies that contributed to a 7% increase in the total market share.• Developed and maintained best practices for Tableau report automation, ensuring consistency and efficiency in reporting processes across the organization.• Led a customer churn analysis using PowerBI for a retail company. Used DAX libraries and analyzed customer data to identify factors contributing to customer churn.• Created a real-time, interactive PowerBI dashboard that visualizes churn rates, customer demographics, and feedback data. Employed predictive modelling to forecast potential churn and recommend retention strategies.• Collaborated in optimizing transportation routing by leveraging historical data by using Python. Suggested improved route recommendations for upcoming trips, resulting in ~9% reduction in transportation costs and an improved on-time delivery rate of 6%.

Delhi, India

Delhi, India

1. Part of the Strategic Advisory team of India's central government and collaborated on a project that utilized SQL and Excel to analyze import and export trade data with various countries, with the aim of studying the impacts of post-pandemic trade restrictions.2. Used PowerBI to build a Commodity Price Forecasting project. Designed a powerful forecasting dashboard engineered to accurately predict future prices for pivotal commodities essential to the international trade landscape.3. Leveraged extensive historical pricing data, comprehensive analysis of supply and demand dynamics, and insightful evaluation of key economic indicators to provide actionable insights.4. Empowered traders and procurement teams with invaluable predictive analytics, enabling them to make well-informed and strategic decisions in a rapidly evolving global market. 5. Built and maintained queries in Excel and SQL for consistent team use and utilized Alteryx for data cleansing, transformation, and integration.6. The project effectively identified key commodities that drove growth and facilitated sustainable development of small-scale industries, resulting in an impressive 17% growth.7. Lead a team studying India's trade policy, specifically technical barriers to trade. Built real time dashboards with KPI’s for diverse stakeholders.8. Responsible for assessing Internal trade data and external trade indices to advise policy and measures to support trade for India to the Minister of Commerce of India.9. Generated detailed studies and interactive dashboards using Tableau and PowerBI to track potential third-party data solutions, verifying compliance with internal needs and stakeholder requirements. Other projects included recommending restructuring Bureau of International Standards, India

Dean'S List, Big Data Analytics, 8.4

Doctor Of Philosophy - Phd

Master Of Arts - Ma, A

Bachelor'S Degree, A

High School Diploma, A