12-week full-time immersive program of hands-on professional training in Data Analytics skills including Python, SQL, data cleaning, data visualization (Tableau and Microsoft power BI), regression models, classification models, web-scraping, APIs, and statistics.● Led an in-depth analysis of the Airbnb market in La Jolla, California, which included extensive data cleaning and the use of advanced data visualization techniques within Power BI. Designed comprehensive and clear data reports, successfully communicating insights to technical and non-technical stakeholders.● Conducted a comprehensive investigation of Washington DC's bike-sharing program, Capital Bikes, using SQL and Tableau to analyze and recommend an expansion engineering driven by user demographic analytics and real-time transit system data.● Analyzed 180K+ row wind turbine dataset for Data Sprint project; cleaned data in Python, built Tableau dashboard to visualize key attributes and identify insights on manufacturer investments. Conducted market research on wind turbine data trends. Analyzed gross generation and consumption data for solar, hydro and wind power to identify optimal renewable energy mix; provided recommendations on short and long-term insight of the market.● Capstone Project – EV Market Analysis in WA: Performed competitive analysis (24M rows dataset) of EV brands and charging stations using SQL and Tableau to visualize insights on industry trends for stakeholder BMW. Used Python for data cleaning in the SODA APIs. Analyzed competitors’ charging EV products to identify market opportunities; provided strategic recommendations to client on product development and partnerships based on data-driven insights.

● Utilized data visualization and statistical analysis to assess key metrics before and after the ERP transition, identifying process improvements and new testing strategies based on insights from the data.● Performed analytics over payroll, revenue, assets, and expenses leveraging regression analysis, time series forecasting, and anomaly detection to identify risks and outliers.● Built visual dashboards to track key business metrics and KPIs, enabling dynamic insights into financial performance.● Analyzed various client’s revenues such as using pivot tables to quantify online clickstream data, using regression analysis to determine average revenue from new product releases to end of product life, calculating content subscription revenue, and performing ASC 606 5-step procedures over revenue contracts given the client’s wide range of revenue streams.● Automated data extraction and analysis for revenue recognition testing using GL Analyzer (Global Analytics Platform); modeled expected revenue booking trends based on statistical analysis of historical data.

● Performed substantive analytical procedures primarily over high-risk accounts, engagement planning, testing and reporting of transactions while documenting and maintaining sufficient supporting information.● Performed ASC 606 5-step procedures over customer revenue contracts including assessing contracts for contract modifications, material rights, appropriate SSP allocation, and more.● Utilized GL Analyzer (Global Analytics Platform) to create correlation analysis to understand client revenue trends and investigate any anomalies outside of expectations.● Analyzed legal documents and correspondence for risk analysis and financial projections

● Managed multiple tasks simultaneously, including assisting in task delegation, communicating with 3rd party clients, and ensuring milestones were completed on time.● Collaborated closely with my client’s onsite HR department to obtain payroll data in order to perform audit procedures and acknowledge the internal condition of the company and its processes.● Translated several legal evidence materials for the team from Chinese to English, which saved 5+ hours for the project.

● Validated and cleaned input data which significantly enhanced more than 10% of the efficiency of subsequent analyses for the analysis.● Assisted in drafting and formatting two marketing brochures that highlighted the firm's strengths and expertise.● Performed administrative tasks on an ad-hoc basis. Always found meaning in these tasks as a contribution to the success of the group, no matter how tedious and cumbersome.