Apoorva Gupta Email & Phone Number

Toronto, On, Ca

Toronto, On, Ca

Toronto, Ontario, Canada

Toronto, Ontario, Canada

• Led the design and execution of a tiered testing strategy to optimize meal kit delivery schedules and improve logistics team load balancing across Canada, showcasing advanced project management and strategic planning skills.• Developed a logistics configurator to dynamically adjust delivery days based on provider capacities, ensuring efficient operations and preventing overload.• Managed a critical security incident response, collaborating with global IT to implement a mitigation plan that reduced future threats, highlighting leadership in crisis management and data security.• Enhanced data privacy by designing and implementing materialized views and access controls, improving data governance and Master Data Management. Worked with cross-functional teams on data pipeline design, documentation, and metadata linkage using Collibra, boosting technical metadata creation.• Directed sprint planning, scrum meetings, and backlog estimation, addressing business pain points and ensuring adherence to scrum methodologies.

Mumbai, Maharashtra, India

• Led cloud migration architecture design, translating quality metrics into business language, and managed healthcare data architecture.• Implemented data modeling solutions with relational and dimensional databases, using Erwin and ER Studio, and supported SAP Master Data Governance (MDG).• Provided technical support and design reviews, improving coding standards and data quality, and enhanced data governance with Informatica Data Quality.• Developed data quality dashboards and migrated metrics from legacy systems to Snowflake.• Created and implemented data objects in operations and supply chain to reduce costs and dependency.• Identified and migrated SAP ECC objects for master and reference data management to the cloud.• Prepared data models, functional documents, and metadata for system transformations.• Optimised supply chain with machine learning for inventory tracking and enhanced drug discovery analytics with data scientists, creating and publishing data catalogs.

• Analysed customer data for segmentation and designed CI/CD pipelines.• Built and maintained star and snowflake schema models for data normalization.• Organised data into raw, landing-merge, unification, refinement, and published layers to enhance reusability and integrity.• Provided insights for audience targeting and lead conversion.• Collaborated with BI teams to create Qlik Sense dashboards for data visualisation and reporting.• Used Google Analytics and Python to analyse and optimise frequently accessed views.• Automated processes and streamlined workflows through data analysis.• Coordinated between teams and stakeholders for feasibility, requirements analysis, and data modeling using ER Studio.

Mumbai Area, India

• Contributed to development and analysis projects for a prominent bank, focusing on data-driven solutions.• Analysed educational data to enhance student engagement with events and hackathons.• Executed front-end development for a major educational institution’s application.• Worked on a client-side team to develop both front-end and back-end applications for capturing data for the All India Council for Technical Education (AICTE).• Designed and implemented a reporting module for institution-specific data using Oracle Business Intelligence Publisher, improving efficiency and performance through advanced data visualisation.• Provided post-production troubleshooting and support, ensuring system reliability and client satisfaction.• Received client recognition for delivering exceptional module development, handling complex business logic independently.

Master Of Science - Ms, Data Science

Post Graduate Diploma, Data Science

Bachelor Of Engineering (Be), Computer Engineering

Activities and Societies: debate team, project management activitiesworked on projects based on web development, networking, system.

Icse

Activities and Societies: was part of the National Association for the Blind. participated in activities such as dance, drama, elocution.