Pierre Nguon
Philadelphia,PA
Summary
Analytical and insightful Data Analyst known for productivity and efficiency in task completion. Specialize in data visualization, statistical analysis, and predictive modeling. Excel in problem-solving, critical thinking, and communication, ensuring successful project outcomes and team collaboration.
Overview
8
8
years of professional experience
Work History
Data Analyst
Accelerated Enrollment Solutions (part of Thermo)
Philadelphia, PA
09.2019 - 07.2024
- Efficiently utilized SQL and Python in Databricks to manage, store, process, analyze, and model broad-ranging data from both internal and external sources
- Automated report generation using advanced Excel functions and VBA, resulting in efficient production of monthly reports
- Utilized data analysis skills to identify and interpret trends within complex datasets.
- Utilized Tableau Desktop to create interactive dashboards for monitoring key performance metrics
- Utilized SQL or Python in Oracle or Snowflake environments to extract intricate data and convert it into informative reports, allowing for an extensive exploration of existing problems.
- Identified patterns and trends in large data sets to provide actionable insights
- Worked closely with stakeholders to determine the requirements for business needs and find relevant data sources
- Applied SAS algorithms to identify new patients from IVRS Excel files and implemented significant updates to the internal database (Oracle Developer) based on those findings
Tax Analyst
TMNA Services
Bala Cynwyd, PA
09.2017 - 03.2018
- Researched tax issues and stayed current on all federal, state and local, unclaimed property, personal property tax filling
- Followed up with vendors to collect and update information and prepared 1099 MISC forms in the system to ensure accurate and consistent data
- Analyzed tax issues and made recommendations for remediation to management
- Performed daily, monthly, quarterly, and annually Sale and Used tax in 14 states
- Assisted manager to creating ad-hoc and sale tax data analysis dashboards and other expenses
- Utilized averaging models in Excel spreadsheets for forecasting of future taxable income
Business Analyst
PECO (Exelon Corporation)
Berwyn, PA
09.2016 - 03.2017
- Interacted with stakeholders to gain insight into business requirements and effectively translated them into project scope
- Performed gap analysis to identify areas of improvement
- Utilized internal Gas mapping system (PECO) to enhance location accuracy for the teams' benefit through creating a dynamic gas line map with the use of geographic areas identification.
- Wrote SQL queries to extract data and build dynamic dashboards for analyzing customer account usages and payments for team projects
- Utilized an averaging model to accurately forecast customer usages and revenue for the team
- Developed advanced excel dashboards for monitoring and tracking KPIs
Education
Bachelor of Science - Management Information Systems & Finance
Drexel University
Philadelphia, PA08-2019
Skills
- SQL
- Python
- Analytical Problem Solving
- Business performance analysis
- Database Management
- SAS programming
- Databricks
- Tableau
- Advanced Excel and Some VBA
- Oracle
- Data Analysis
- Variance Analysis
- Statistical Analysis
- Microsoft Excel
Languages
English
Professional
Cambodian
Full Professional
Timeline
Data Analyst
Accelerated Enrollment Solutions (part of Thermo)
09.2019 - 07.2024
Tax Analyst
TMNA Services
09.2017 - 03.2018
Business Analyst
PECO (Exelon Corporation)
09.2016 - 03.2017
Bachelor of Science - Management Information Systems & Finance
Drexel University
Similar Profiles
Jake FlaglerJake Flagler
Digital Ops Manager II – Digital Implementation at Accelerated Enrollment Solutions (PPD and Thermo Fisher Scientific)Digital Ops Manager II – Digital Implementation at Accelerated Enrollment Solutions (PPD and Thermo Fisher Scientific)
Elizabette MolinaElizabette Molina
Senior Training Specialist at Accelerated Enrollment SolutionsSenior Training Specialist at Accelerated Enrollment Solutions
Callie ArnoldCallie Arnold
Site Director at Accelerated Enrollment SolutionsSite Director at Accelerated Enrollment Solutions