Apoorva Joshi Email & Phone Number

Toronto, On, Ca

California, United States

• Currently, I am part of a team that handles the operations of the weekly reports within the organization. My role involves managing the release process and working on enhancements.• I have also worked with the team on a project that involved integrating reporting systems between two big pharmaceutical companies. This required connecting with various team leads, creating timelines, and identifying risks and dependencies.• Worked on a long-term project to develop Tableau dashboards for… Show more • Currently, I am part of a team that handles the operations of the weekly reports within the organization. My role involves managing the release process and working on enhancements.• I have also worked with the team on a project that involved integrating reporting systems between two big pharmaceutical companies. This required connecting with various team leads, creating timelines, and identifying risks and dependencies.• Worked on a long-term project to develop Tableau dashboards for a specific pharmaceutical product. This included gathering business requirements, figuring out key performance indicators, making mockups, building the reports, and taking care of their upkeep and improvements over time. Show less

California, United States

• Collaborated with a pharmaceutical client to merge medical procedural data for different heart conditions, crafting a user-friendly Tableau dashboard. This tool provided insights into yearly procedure counts, age-group distributions, mortality rates, and device usage trends.• Worked on a project building Tableau dashboards for two major pharmaceutical brands, offering insights into market performance, sales, call data, and demand dynamics by specialty and indications, along with… Show more • Collaborated with a pharmaceutical client to merge medical procedural data for different heart conditions, crafting a user-friendly Tableau dashboard. This tool provided insights into yearly procedure counts, age-group distributions, mortality rates, and device usage trends.• Worked on a project building Tableau dashboards for two major pharmaceutical brands, offering insights into market performance, sales, call data, and demand dynamics by specialty and indications, along with patient-level data and subnational assessments.• Partnered with a product team, delivering ad-hoc analyses while overseeing weekly and monthly tasks. These analyses incorporated a wide range of tasks, including assessing patient return rates from IQVIA claims, generating prescriber targeting universes using Xponent and DDD data, and conducting depth and breadth analyses for the brand utilizing DDD data.• Developed a self-service Tableau dashboard for clients, using a master database with calls, targeting, and sales data for easy filtering and access to desired views.• Acted as a Tableau expert on various short-term projects, supporting internal and external teams with data visualization solutions. Show less

United States

• Developed automated job triggers in AWS Glue and Lambda for processing and analysis of internal recruitment data.• Designed and developed python accelerators for converting SQL scripts from one version to another.• Managed sustainment activities for a major pharmaceutical client.• Provided SME support on operations project and worked with the IT System manager early warning system on operations timeliness and quality.• Worked with business teams on meeting business requests… Show more • Developed automated job triggers in AWS Glue and Lambda for processing and analysis of internal recruitment data.• Designed and developed python accelerators for converting SQL scripts from one version to another.• Managed sustainment activities for a major pharmaceutical client.• Provided SME support on operations project and worked with the IT System manager early warning system on operations timeliness and quality.• Worked with business teams on meeting business requests and communicating them to the offshore team. Show less

Illinois, United States

Built summaries and visualizations to generate insights on faculty-student interactions through anonymous surveys filled by both students and professors.

Gurgaon, India

• Managed data operations for commercial sales data lake for one of the Top 10 U.S. pharmaceutical companies to provide field reps weekly sales insights, customer-level analysis, activity call planning, and incentive compensation. • Interacted with clients to gather requirements for bi-weekly enhancement sprints. • Ensured smooth running of operations round the clock and 99% defect-free data deliverables and minimum breach and Service Level Agreement. • Hands-on experience in… Show more • Managed data operations for commercial sales data lake for one of the Top 10 U.S. pharmaceutical companies to provide field reps weekly sales insights, customer-level analysis, activity call planning, and incentive compensation. • Interacted with clients to gather requirements for bi-weekly enhancement sprints. • Ensured smooth running of operations round the clock and 99% defect-free data deliverables and minimum breach and Service Level Agreement. • Hands-on experience in technologies like Python, Airflow, SparkSQL, Airflow, Redshift, Databricks, and Big data. • Onboarded new team members whenever required and played the role of subject matter expert for commercial sales data operations. • Validation of sales data to ensure the correctness of data and gaining a business understanding of the processes. Show less

Master Of Science - Ms, Quality Management And Analytics

Bca - Bachelor Of Computer Application, Computer Science