Priyanka Meka Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

• Led the Business Analytics team in delivering eCommerce analytics for brands and retailers, covering Pricing Intelligence, Digital Shelf Analytics, Assortment, and MAP solutions. On average, handled and individually contributed to 2 development and 4-5 support projects.• Translated business needs into actionable analytics/reporting requirements. Developed and implemented custom dashboards tailored to client specifications. Executed end-to-end solutions from requirements gathering to SQL/Backend Logic Development and Dashboard Development.• Analyzed e-commerce datasets from various data sources (RDBMS, JSON, Excel, CSV, Flat files) using Athena S3, SQL, Python, and Excel. Visualized data in Tableau, Looker, and Sisense, converting complex analytical tasks into actionable insights and clear outputs.• Conducted advanced data analytics using Machine Learning algorithms and statistical methods (e.g., Hypothesis testing, Linear Regression, Clustering, Correlation). Focused on price zone analysis, competitor pricing pattern prediction, customer segmentation, and causal analysis.• Worked closely with Fashion, CPG, and QSR clients to identify price change opportunities, optimize price, assess competitor assortment. Performed various data analysis such as sentiment analysis, ROI analysis, correlation analysis, content analysis, and promotional event analysis. • Conducted quarterly and executive business reviews (QBR/EBR) with impactful storytelling. Presented key metrics and recommendations through high-impact data visuals and PowerPoint presentations, effectively communicating insights to non-technical audiences, stakeholders, and leadership.• Demonstrated decision-making, problem-solving, and strategic initiative skills. Provided technical leadership by mentoring and training analysts, fostering a collaborative and growth-oriented team environment.• Tools Used: Tableau, SiSense, Looker, SQL, Athena/ S3, Python, Excel

- Specialized in Optum Performance Analytics (OPA), a unified clinical and financial healthcare data and analytics platform, contributing to diverse teams in Implementation, ETL processing, and Data Quality Management.- Led end-to-end responsibilities, from client requirement gathering to data normalization, utilizing the Data Validation Platform (DVP) to ensure industry-standard compliance. Presented comprehensive payer-provider statistical analyses on the OPA site.- Prioritized user-centric enhancements, guaranteeing enriched information availability for streamlined analysis.- Played a key role in the internal product, Standards and Analytics, by calculating Key Performance Indicators (KPIs) for service teams. Generated KPI Metrics and collaborated with senior leadership on best practices, aiming to improve organizational KPI goals.

- Delivering business reporting solutions to Westpac Banking Group, collaborating with top management to create dashboards and reports utilizing the TM1 planning tool for data analysis, planning, and forecasting.- Developed Cognos packages, enabling Finance to streamline day-to-day reporting. Implemented TM1 rules and solutions to enhance planning and forecasting, automating report scheduling to minimize manual effort and reduce delays.- Schedule frequently used SSRS reports for Finance Users, crafting SSIS packages to facilitate ETL processes. Designed SSAS cube partitions to optimize report performance effectively.