Alan Wu

San Diego, CA 657-***-**** adzgvc@r.postjobfree.com

Professional Summary

Experienced Data Analyst with strong quantitative and analytical skills. Proficient in utilizing Excel, Tableau, and SQL to extract actionable insights from large datasets. Ability to leverage interpersonal skills to communicate findings to the public, stakeholders, and senior leadership using presentations, dashboards, and written briefs.

Skills & abilities

● Microsoft Excel (Formulas, Pivot table, Vlookup, If statements, Slicer, and Macros)

● Data Visualization Tools: Tableau, Power BI, Qlik

● Programming Languages: SQL, Python, SAS, R

● Databases and CRM: Oracle, MS SQL Server, Tm1, Salesforce Work Experience

Data Analyst Qualcomm September 2022 – Present

● Data Analysis: Transformed disparate data sources using Excel, Tableau, and TM1 into actionable reports and dashboards. Guided licensing decisions through informed recommendations.

● Data Validation: Oversaw 20+ licensee accounts, ensuring strict agreement compliance and accurate quarterly royalty reports. Managed comprehensive licensee database, validating royalty reports to ensure precision and compliance.

● Supply Chain and Inventory Monitor : Leveraged third-party data sources for real-time monitoring of customer inventory and supply chain dynamics. Skillfully identified discrepancies, facilitating swift corrective actions to ensure meticulous royalty collection and precise reporting. Project Experience

PalletPal Freight Forwarder Project Capstone January 2022 – May 2022

● Customer Conversion Analysis: Part of a four-member team focused on boosting PalletPal's customer conversion rates. Employed Google Trends and diverse data sources to analyze online behavior and preferences, culminating in strategic recommendations for engagement and conversion.

● Market Insights: Conducted thorough market research and data analysis within our capstone project. Utilized Tableau for visualizations, presenting actionable findings to the COO. Impressed by our work, the COO expressed interest in implementing the recommendations. Adventure Works Cycle Analysis Data Engineering October 2021 – December 2021

● ETL: Leveraged Tableau Prep Builder to conduct efficient ETL, resulting in increased productivity and focused insights.

● Data visualization & Database Management: Analyzed three years of retail data. Configured data using MS SQL and harnessed Tableau for dynamic visualization. Developed an interactive dashboard encompassing growth, customer insights, and sales analysis. Produced an executive summary for conveying findings to the audience.

Amazon Database Data Management of IT January 2021 – February 2021

● Database Management: Executed a project emulating Amazon's intricate database using Oracle and SQL. Designed a functional database system through logical entity-relationship diagrams and applied SQL queries for data extraction for insights generation. Stock Market Trend Python Programming May 2019 – June 2019

● Python: Engineered an automated Python program utilizing the request module to seamlessly extract and process daily stock market data from diverse sources.

● Statistical Insights & Visualization: Conducted in-depth descriptive statistical analyses on stock market data. Utilized Python's data visualization libraries to translate intricate trends into clear visual representations, facilitating informed investment analysis. Education

Clark University, Worcester MA May 2022

Master of Science in Data Analytics

Fu Jen Catholic University, Taiwan June 2019

Bachelor of Science in Applied Mathematics

Contact this candidate