Khalender Mahfooz

• Automated the quarterly national sales comparison process using Python, reducing processing time from 1 day to 5 minutes.
• Developed and implemented Quality Control (QC) checks for pharmaceutical sales data in Snowflake using SQL, improving data accuracy and validation.
• Investigated and resolved sales discrepancies by collaborating with vendors, digital teams, and downstream stakeholders, leading to increased operational effectiveness.
• Leading the development of SOPs and automation for specialty pharma distribution tracking to streamline operations.
• Managing the onboarding of vaccines sales operations for the US market.
• Nurtured strong working relationships with clients, ensuring their needs were met while exceeding expectations on deliverables.

• Led a 3-member data & analytics team, managing MDM systems and ad-hoc data analysis to support business decisions.
• Built and operationalized the data backend for a new biosimilar launch using Alteryx, optimizing data flow and analytics.
• Gathered business requirements, created market-tracking reports, and supported stakeholders with data-driven insights.
• Managed post-split data migration, ensuring seamless data transitions and continuity.

(Datasets: IQVIA One Key, HCOS, DDD, Xponent, ValueTrak, Symphony Plantrak, Integrichain)

• Automated data processes using Alteryx, reducing manual effort and saving 375+ hours annually.
• Developed and maintained Excel-based reports to help business partners visualize market trends and product performance.
• Implemented automated data quality checks, ensuring accuracy by identifying backend mismatches at regular intervals.