Nghia Tran Quang

Data Analyst

Abbott | Ho Chi Minh City, Vietnam

Technologies

Statistical poet, weaving elegant stories with the threads of data.

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.

Abbott | Apr 2024 - Present

Sales Force Automation Intern

Deploy & Adjust Target List Automation (TLA) System & Process - Define 50+ test cases and back-and-forth to vendors for features fit with business needs. - Collaborate with stakeholders such as Sales Force Effectiveness (SFE), Sales, and Vendors to propose and align on TLA system enhancements. - Roll out new system (TLA) for 250+ users and maintain system by updating new features for future requirements. Manage TLA System Data & Workflow Process - Ensure data accuracy, integrity, and consistency between TLA and Salesforce system by data extract, data processing, data validation using SQL, Excel, Power Query for semi-automation tasks. - Create Dashboard & Report from Data Warehouse (TLA / Salesforce system) - Support data-driven decision making by developing Target List dashboard, helping SFE team in monitoring sales operation of MR on Ethical channel. - Provide essential data for stakeholders by request using SQL Server for data extraction. - Automate creating report with Power Pivot, helping MKT in tracking overview covered hospitals, doctors in Vietnam. Operation, Help-Desk Support - Provide training and guidance to sales team, enable them to use SFA systems effectively.

AstraZeneca | Apr 2023 - Oct 2023

Data Analyst Intern

KPIs and incentive calculation analysis - Collaborate with Marketing and Regional Sales Manager to identify critical business needs (incentive metrics, design dashboard) and data sources. - Calculate incentive schemes using automation tools (Excel, Power Query) to enhance performance analysis. Build Dashboards - Develop, deploy and maintain 2 Power BI dashboards, empowering 150+ sales rep to track KPIs, incentive, market trend, competitors, and make data-driven decisions. - Build a Target List dashboard in Power BI, analyzing over 250,000 data rows to support Segmentation & Targeting process and field force tracking target. - Design data models in Power BI. - Design automated ETL process in Power Query for handling 4,000,000 records. - Provide training and guidance to sales team, enable them to use dashboards effectively.

My Education

Take a look at my formal education

Bachelor in Mathematics and Computer ScienceUniversity of Science - Vietnam National University Ho Chi Minh City | 2023

About Me

Nghĩa is a Junior data analyst with 1 year of experience in developing and maintain dashboards to grasp the business situation for increasing revenue. Skilled in automating the process and optimizing productivity with tools.

Create Your Data Portfolio for Free