Learn Data Skills
Beta
Steven Tran

Steven Tran

Specialist

JAMP Pharma Group | Canada, Montreal

Technologies

My Portfolio Highlights

My New Course

Introduction to DAX in Power BI

My New Course

Introduction to Power BI

Numbers enthusiast, translating data into meaningful insights.

My Work

Take a look at my latest work.

course

Introduction to Power BI

course

Introduction to DAX in Power BI

course

Introduction to ChatGPT

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

JAMP Pharma Group | Jul 2022 - Present

Specialist - Institutional Division

OPTIMIZING PROCESSES ➤ Implement guidelines for document naming conventions, folder structures, and version control ➤ Introduce automation tools (Planner & Power Automate) and techniques that reduce manual errors and increase process efficiency COORDINATION ➤ Develop and implement project management methods and tools to optimize resource allocation, reduce project timelines, and improve project outcomes BIDDING PROCESS ➤ Support the contract manager by maintaining accurate records and effective communication of agreed-upon contract terms to the relevant teams ➤ Consolidate a database with various sources, such as product specifications, IQVIA data, and information from group purchasing organizations (GPO) and distributors, in order to prepare submissions DATA MANAGEMENT ➤ Conduct data analysis and created data visualizations to support business decision-making and inform strategic planning ➤ Collaborate with cross-functional teams to identify data requirements and ensure that data is collected, stored, and analyzed in accordance with best practices DATA ANALYTICS ➤ Utilize Power BI and Excel to transform raw data into visually appealing and interactive dashboards for effective data analysis ➤ Perform in-depth data exploration and trend analysis, enabling data-driven decision-making and providing strategic insights DRUG SHORTAGES MONITORING ➤ Monitor JAMP Pharma products and matching competitor products for opportunities, such as alternative supplier and negotiations ➤ Communicate relevant back-orders by evaluating competitors, market shares and pricing through IQVIA’s database platform TOOLS ➤ Create Power BI dashboards that : - Extract data from Health Canada DPD and Drug Shortages Canada - Evaluate on/off-contract transactions to provide performance insights - Automate the creation of sales and rebate reports to be provided to the GPO - Conduct an analysis of available inventory and estimated quantities to ensure efficient fulfillment of contract terms
Show More

Teva Canada | Sep 2021 - Apr 2022

Market Access Intern

PRODUCT MONITORING ➤ Monitor Teva's products (and competitors) in the areas of migraine and biosimilars — Health Canada, HTA agencies (CADTH, INESSS, etc.), pCPA, public/private listings, and others ➤ Inform new product submissions, Notice of Compliance, HTA key milestones, policy changes, and relevant news ➤ Keep track of public formulary updates and private reimbursement forms for criteria changes ➤ Adept in using IQVIA''s database platform for public listing and price monitoring REIMBURSEMENT PROCESS ➤ Assist with submission requirements for CADTH/INESSS and redact reports ➤ Review product price changes with PMPRB guidelines ➤ Develop slide decks to forecast upcoming changes for CADTH and pCPA SUPPORT ➤ Assist the team in reviewing pharmacoeconomic studies and submissions ➤ Provide supporting documentation for different projects ➤ Translate documents for internal distribution OPTIMIZING PROCESSES ➤ Develop documentation Word templates to standardize the presentation of information ➤ Include new features on Excel product trackers, such as filters and a data entry form ➤ Create a product timeline tracker for project management (CADTH & INESSS automated milestones) TEAM UPDATES ➤ Notify the Market Access team of relevant news, such as policy changes, price updates, and new listing or eligibility criteria changes for a product ➤ Participate and summarize CADTH's information sessions into a shareable document

Purple Squirrel Economics | Jan 2020 - Apr 2020

Student Intern in the Value Communication Team

SCIENTIFIC COMMUNICATION ➤ Summarize information into clear and concise presentation slide decks for the Value Communication team PUBLISHING IN SCIENCE ➤ Research optimal journals and conferences for publishing scientific manuscripts or abstracts ➤ Comprehend the publishing process of scientific manuscripts and the topic of predatory awareness OPTIMIZING PROCESSES ➤ Self-taught on the use of Visual Basic Application (VBA) in Excel to create a user form for guidance and data entry ➤ Develop guidance in decision making when submitting HTA evidence to publishing journals and suitable conferences ➤ Optimize data entry of relevant journals and conferences with decision- making key factors into an Excel file for consulting

Centre de services scolaire de Montréal (CSSDM) | Jun 2018 - Aug 2018

Concierge class III

RESPONSIBILITY ➤ Keep the premises clean and in good condition at the school

Collège de Maisonneuve | Sep 2016 - Jun 2017

Science Tutor for École des Grands

COORDINATION ➤ Prepare and plan scientific activities ➤ Create simple visual presentation in PowerPoint INTERPERSONAL ➤ Animate the group of elementary students and foster an interest for science ➤ Host the group with a warm welcome to the laboratory classroom

Les Pousses urbaines | Jun 2014 - Aug 2014

Apprentice Horticulturist

➤ Maintain ecological assets ➤ Landscape green areas

My Education

Take a look at my formal education

Master's degree, Pharmaceutical SciencesUniversité de Montréal | 2022
Specialized Graduate Diploma in Drug Development, Pharmaceutical SciencesUniversité de Montréal | 2021
Bachelor of Science, Biopharmaceutical SciencesUniversité de Montréal | 2020
Double DEC (Life Sciences & Human Sciences)Collège de Maisonneuve | 2017
High School Diploma, Natural SciencesJoseph-François-Perrault Highschool | 2014

About Me

Steven Tran

I am an open-minded and goal-driven person, working as a Specialist with the Institutional Division at JAMP Pharma Group. I became passionate about data science as I currently work with Power BI doing data analysis and visualization.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free