Skilled in data cleaning, manipulation, and visualization. Proficient knowledge of SAS, SQL, R, and Python. Experience in building dashboards using Alteryx, Tableau, and Power BI. Have an in-depth understanding of the pharmaceutical industry and drug commercialization.

Industry and Project Experience

This image has an empty alt attribute; its file name is Divider-1.jpg
KMK Consulting, Inc., New Jersey, Associate (Aug 2021 – Present)

⦿ Developed in-depth understanding of pharmaceutical industry including sales measurement, field force, field force activities, managed care, deciling and targeting.
⦿ Performed extensive analysis using SAS/SQL on pharmaceutical datasets such as Xponent, DDD, Roster, Alignment, Xponent Plantrak, Master Profile, Calls, and Samples datasets.
⦿ Conducted market analysis on a branded acne vulgaris drug-ARAZLO Lotion using SWOT model by analyzing prescribing information, mechanism of action, clinical trials, acne treatment options, major competitors, and marketing strategies.
⦿ Analyzed how patients respond to XIFAXAN over time and conducted the duration of treatment analysis using APLD data.

Building Material Firm | China, Business Assistant (May 2018 – Jul 2018)

• Drafted contracts and agreements worth 7 million dollars.
• Checked contract terms, overdue terms, payment terms, and consumer credits.
• Updated the database by creating customer profiles and tracking the process of payment and shipment.
• Helped maintain a good relationship with customers by sending out satisfaction surveys regularly.
• Facilitated in administrative affairs, such as archiving of contracts and keeping records of meetings.

Technical Skills

This image has an empty alt attribute; its file name is Divider-1.jpg
Programming Skills: SAS, SQL, R Studio, Python, Alteryx, Power BI, Tableau, and MS Office Suite
Statistical Skills: Statistical Analysis, Linear/Logistic Regression, Linear Discriminant Analysis, Support Vector Machine, Random Forest, and Resampling Methods (Cross-Validation and Bootstrapping)

Certification

This image has an empty alt attribute; its file name is Divider-1.jpg
SAS Certified Professional: Advanced Programming Using SAS 9.4
IBM Data Science Professional Certificate

Education

This image has an empty alt attribute; its file name is Divider-1.jpg
Master of Science in Economics
Texas A&M University, College Station, Texas (May 2021)
Bachelor of Science in Economics
Capital University of Economics and Business, Beijing, China (Jun 2019)
Get The Latest Updates

Subscribe To Our Monthly Newsletter

No spam, only the content you’ll want to read.

Details about how we process your Information is available in our 

Privacy Policy

Upcoming Webinar

Strategic Planning for Medical Affairs

Adding Value Efficiently

Featured Speakers

More Profiles

TO LEARN MORE ABOUT THIS OR OTHER AVAILABLE RESOURCES, PLEASE CONTACT

melissa

Melissa ArchuIeta

Director of Accounts and Resource Management