Steven Tran Email & Phone Number

Montreal, Qc, Ca

Boucherville, Quebec, Canada

INFORMATIQUE DÉCISIONNELLE➤ Rassembler toutes les données pertinentes liées aux informations commerciales pour comprendre les tendances du marché et acquérir des connaissances concernant les concurrentsANALYSE DE DONNÉES➤ Élaborer un plan optimisé de collecte des données en collaboration avec l’ingénieur de données et transférer les transformations des données brutes au réseau virtuel Azure➤ Utiliser divers logiciels tel que Power BI, Excel, Power Automate, Power Apps, SQL Server Management Studio (SSMS) pour compiler des rapports

Boucherville, Quebec, Canada

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 efficiencyCOORDINATION➤ Develop and implement project management methods and tools to optimize resource allocation, reduce project timelines, and improve project outcomesBIDDING 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 submissionsDATA 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 practicesDATA 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 insightsDRUG 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 platformTOOLS➤ 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

Montreal, Quebec, Canada

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 monitoringREIMBURSEMENT 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 pCPASUPPORT➤ Assist the team in reviewing pharmacoeconomic studies and submissions➤ Provide supporting documentation for different projects➤ Translate documents for internal distributionOPTIMIZING 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

Montreal, Quebec, Canada

SCIENTIFIC COMMUNICATION➤ Summarize information into clear and concise presentation slide decks for the Value Communication teamPUBLISHING 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 awarenessOPTIMIZING 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

Montreal, Quebec, Canada

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

Montreal, Quebec, Canada

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

Montreal, Quebec, Canada

ENVIRONMENT➤ Maintain ecological assets➤ Landscape green areas

Master'S Degree, Pharmaceutical Sciences

Specialized Graduate Diploma In Drug Development, Pharmaceutical Sciences

Bachelor Of Science, Biopharmaceutical Sciences

Double Dec (Life Sciences & Human Sciences)

High School Diploma, Natural Sciences