Prince John
Data Analyst | Business Intelligence | Inventory & Sales Analytics | PhD in Statistical Sciences
Hire this person
Send a job offer directly to this candidate
About
Data Analyst with a PhD in Statistical Sciences and 6+ years of experience turning complex sales, inventory, and operational datasets into clear, actionable insights. Currently at HRA Group Holdings, I design and maintain Power BI dashboards, automate recurring reporting workflows, and deliver customer segmentation and inventory optimization analyses that directly inform leadership decisions. Proven ability to bridge the gap between raw data and business strategy — communicating findings to both technical teams and executive stakeholders.
Experienced across the full analytics stack: SQL for data extraction, Excel and Python for transformation and modelling, R and Power BI for analysis and visualization.
Experience
Data Analyst - HRA Group Holdings Ltd. - Vancouver, BC
(2022-03)
- Developed and maintained Power BI dashboards and automated reporting solutions for sales, inventory, deployment, profitability, and operational performance.
- Designed and implemented a sales-to-inventory matching system that automatically compares daily sales against available inventory, identifies unmet demand, and generates a purchasing needs list for buyers; built workflow tracking to monitor purchasing status and improve replenishment visibility.
- Created inventory performance monitoring models that identify products with slower sell-through rates at specific customer locations compared to peer customers; conducted root-cause analysis and provided recommendations for inventory optimization.
- Developed customer segmentation frameworks using RFM (Recency, Frequency, Monetary) analysis to identify high-value customers, dormant accounts, growth opportunities, and accounts requiring intervention.
- Built inventory recommendation and ideal inventory models using historical sales, deployment trends, and inventory turnover metrics to support inventory planning decisions.
- Performed sales forecasting and trend analysis across product categories, customer segments, and geographic regions to support business planning.
- Conducted pricing, margin, deployment, and profitability analysis to support strategic inventory and revenue decisions.
- Developed aging inventory analytics to identify slow-moving inventory and provide recommendations for redeployment, replacement, or inventory reduction.
- Created automated quarterly and monthly business performance reporting processes, significantly reducing manual reporting effort and improving reporting consistency.
- Presented analytical findings, trends, and recommendations to senior leadership and business stakeholders to support decision-making.
- Collaborated with sales, operations, inventory, and management teams to translate business requirements into analytical solutions and actionable insights.
Mathematics Instructor - Columbia College - Vancouver, BC
(2021-05 - 2022-04)
- Taught mathematics courses to students with diverse academic backgrounds.
- Developed instructional materials promoting analytical thinking and clear quantitative reasoning.
Statistics Instructor - Alexander College - Burnaby, BC
(2019-09 - 2022-04)
- Taught statistical analysis, inference, probability, and data visualization.
- Developed course materials building practical analytical thinking and clear communication of quantitative findings.
Business Data Analyst - Standard Chartered Bank - Chennai, India
(2012-07 - 2014-05)
- Extracted, cleaned, and analyzed business data using SQL and Excel for revenue reporting, quality assurance, and decision support across multiple business units.
- Built BI dashboard visuals to communicate business trends, performance indicators, and risk flags to business and corporate stakeholders.
- Supported data quality initiatives, reporting standardization, and process improvement projects; prepared technical documentation including workflows and standard operating procedures.
SAP Materials Management Associate (Intern) - Wipro Technologies - Bengaluru, India
(2008-10 - 2009-10)
- Assisted in requirements gathering, documentation, and implementation for SAP MM modules.
- Supported end-user testing (unit, integration, UAT) and provided analytical troubleshooting.
Education
Doctor of Philosophy (PhD) - Statistical Sciences - University of Padua (2014 - 2018)
Master of Science (M.S.) - Mathematics - Indian Institute of Technology Madras (IIT Madras) (2010 - 2012)
Bachelor of Science (B.S.) - Mathematics - Mahatma Gandhi University (2005 - 2008)