Results oriented Business Analyst with an in-depth background in ad tech programmatic and search ads. Able to synthesize information quickly and assimilate into new scenarios to come up with creative solutions. Expertise in Excel modeling, SQL and VBA programming. Have a Master of Science degree in Finance and Bachelor degree in Financial Engineering.
SQL, Python, ETL
Excel Modeling, Tableau, Power Query
Programmatic, Search Ads
Business Analyst II08/2017
to Current Amazon – New York,
Develop and automate 10+ weekly KPI reporting dashboard using ETL, SQL, Tableau and Excel for worldwide Amazon Search Ads team to drive customer retention rate and engagement effectiveness, reduced teamwork spend by at least 15 hours per week.
Lead data migration project from Oracle to Redshift across 5 worldwide teams, partner with different Data Engineer teams to identify business needs to ensure transform data logic accuracy and integrity.
Lead the the agency mapping consolidation project in worldwide team, built agency Redshift tables, successfully migrated data from multiple sources to database and maintain mapping update on weekly basis. Team is able to utilize the new table to build ETL jobs and agency dashboard in Quicksight to replace heavy Excel workbook .
Develop and maintain internal CRM tool based on Excel VBA used by over 30 marketing program managers from worldwide team on daily basis. The tool helps Self-service advertising team to bridge the gap between Salesforce and advertiser performance, serves as main tracking platform for Onboarding team.
Lead Seller Central website user journey analysis to understand user behavior through different approaches include but not limit to, exploratory analysis, Markov Chain investigation and Bayes regression.
Configuration Specialist/Application Engineer06/2015
to 08/2017 Operative Media, Inc. – New York,
Configured 70+ items into the Enterprise Software Product Operative.One for 43 clients across 6 environments including but not limited to staging, AWS and production, achieved 98％ completion rate in 22 consecutive months.
Designed and delivered Proserv revenue automation Excel VBA Model under limited time frame for auditing purpose, the tool helped to collect over 1M unrecognized revenue left on table.
to 06/2015 First Image Design, Corp – New York,
Managed 4 people team to drive company product and pricing strategy, back-order management across 8000+ products, generated over 2 million revenue from special order management.
Product strategy: Breakdown cost of items to identify opportunities to negotiate better pricing, performed margin and pricing analysis to support key initiatives as required, managed data integrity and consistency in production for all items.
Pricing strategy: Developed automatic pricing calculator and diamond reconciliation model for five vendors, boosted pricing and reconciliation efficiency and accuracy.
Product forecasting model: Delivered qualitative and quantitative sales analysis to management and clients for better re-stocking and marketing strategy. Fully in charge of salesman commission report for the fiscal year of 2013 and 2014.
Master of Science : Finance GPA 3.722012Syracuse University-
Bachelor of Science: Financial Engineering GPA 85/1002011Wuhan University-