Analyst

Guangya "Leo" Wang

484-***-**** ******@***.*** **8 Saint Francis St, San Gabriel, CA 91776

Currently pursuing a second master’s degree at NYU study in Data Analytics. Accumulated rich hands-on experience in generating insights using data analytics skills. Passionate about information management and analytical exploration. Looking for a position that analyzes business performance, processes data sets, provide insights, and drive recommendations to improve performance. EDUCATION

New York University New York, NY

Master of Science in Management of Technology, Concentrated in Data Analytics 2021 - 2022 Relevant course: Business Analytics, Management Science, Data Visualization, Supply Chain Management, Economics and Strategy Northeastern University Boston, MA

Master of Science in Health Informatics, Concentrated in Informatics Analytics 2020 - 2021 Relevant course: Data Management, Database Design, Computational Statistics, Project Management, Quantify Value of Informatics Muhlenberg College Allentown, PA

Bachelor of Arts in Public Health, Scholarship Awards: Commitment to Excellence, Dean’s List (top 15%) 2015 - 2019 PROJECT EXPERIENCE

Search Query Optimization for Human Disease Database MalaCards Spet. 2022 – Nov 2022

• Extracted and analyzed sample top search keywords from historical user data with Python and Excel for performance analysis

• Enhanced MalaCards database search algorithms with Python linear regression model, improving relevance score by 35% Business Analysis for Transit Technologies Transit Technology, LLC Jan. 2022 – May 2022

• Analyzed public transportation breakdown cases to elaborate on the necessity of blockchain applications

• Identified insights from Tableau to suggest Smart Contract and Decentralized Applications usage on vehicle sensors for the real-time update of auto parts records and immediate response to car incidents; drafted a feasible business plan covering potential market size, key stakeholders, profitability calculation, customer journey map, and practical go-to-market strategy Supply Chain Assessment and Data Analysis Nestlé Purina PetCare Company Sept. 2021 – Dec. 2021

• Redesigned pet meal supply chain to minimize disruptions caused by the pandemic and increased demand

• Processed dataset on local market’s customer views on pet meal purchase and volume of demand, and assessed current supply chain strategy using SWOT and DICE framework to predict inventory shortage

• Formulated statistical models with R to predict profitability would increase by 170% in the next 3 years; presented Distribution Requirements Planning (DRP) solutions along with Enterprise Resource Planning (ERP) vendor partnership to mitigate disruptions Healthcare Provider Portal App Launch Intus Care Jan. 2021 – May 2021

• Conducted a comprehensive market analysis with data from 300 test patients based in Boston for launching a healthcare provider portal app to cater for the increasing demand for electronic health records

• Designed a relational database prototype that illustrates the entity-relationship between patients and physicians in SQL to better match patients with their ideal care providers based on medical condition, availability,etc. and faster retrieve medical data

• Performed end-to-end monitor of app and supported services, and handled incidents as app users scale up to near 50k WORK EXPERIENCE

McKinsey & Company Inc. Financial Analyst Intern Shanghai, China Jul. 2019 - Aug. 2019

• Cleaned up annual employee expense raw data via Python and visualized monthly expenditure through Google excel statistic model by expense category to track spending trends, and presented key findings and feasible suggestions to senior manager

• Cooperated with IT team to update employee salary sheets by removing resigned staff and adding new hires, and contributed to informing coworkers on newly automated payroll software

• Increased data accuracy by developing and maintaining VBA codes that reduced paperwork input workload and input errors

• Prepared and reviewed cash flow statements for projects; adjusted multiple tax filling errors and integrated into master sheet Accenture Co., Ltd. Analyst Intern Shanghai, China Jun. 2018 - Jul. 2018

• Devised a comprehensive auto dealership expansion plan for a luxury automotive brand in high-demanding cities

• Utilized Excel model to estimate luxury car market size over the next 4 years for major cities, and combined with 10+ competitors’ information on dealership distribution, sales volume, vehicle type etc. for client assortment planning

• Developed a regression model with 25% higher accuracy to predict car demand in each province and replenish inventory in time OTHER INFORMATION

Tools: Python, SQL, Tableau, Power BI, R, Google Analytics, Google Cloud, Excel, VBA, Access, Words, PowerPoint, Slack

Contact this candidate