Pricing Analyst - Performed ETL and analytical tasks (queries and aggregations) to turn cluttered revenue and sales data into meaningful and comparable data stored in a central SQL Server 
 - Created dashboards in Tableau with key metrics (e.g. historical performance, gross margin by category and coupon performance) to assist stakeholders to set prices for different clients
 - Accomplished North America price optimization project of 3 product categories and 50+ products in Excel; made strategic recommendations for tiered product pricing
 - Assisted product launch in Europe: Performed competitor analysis and price testing to restructure pricing strategy
 - Periodically updated price catalog based on market fluctuations to ensure minimum overall gross margin; generated metrics that were incorporated into sales proposals; reviewed price quotes and generated pricing reports for cross-functional and global teamsProject Owner - Corporation Data Management Platform Upgrade and Migration - Migrated 50K entries of pricing data for 6 clients in North America and Europe including TripAdvisor, Alcone, Usborn
 - Identified mapping problems of product data and created Product Data Dictionary by reconciling Product Catalog and Global Pricing List; allowed SKU filtering in Excel and it functioned as a quick price-lookup tool for sales team
 - Reported migration progress to management, trained sales and business development teams to use the price lookup tool, which reduced 95% manual input errors and standardized pricing optimization processes
 - Consistently met clients’ data migration deadlines and shortened project timeline by 50%

BrainCo is a hardware company that combines neuroscience and artificial intelligence to combat Attention Deficit Hyperactivity Disorder (ADHD). Incubated at the Harvard Innovation Lab, BrainCo grew rapidly since it was founded in 2015, and was awarded the first prize in MassChallenge 2016.Marketing Analyst - Designed and developed a market testing questionnaire with 50+ questions to define target customer and refine product algorithm in company’s first prototype; reached out and partnered with CHADD, a National Resource Center for ADHD, to collect 229 effective responses from ADHD patients and non-ADHD participants - Analyzed responses in SPSS by demographics to understand market segmentation and define target customer, by product design to prioritize feature development, and by attitudinal questions to direct engineering strategy design - Coordinated with cross-functional teams to finalize product launch roadmap and test product functionality and performance - Contributed to the release of BrainCo’s FOCUS 1, world's first real-time attention sensing electroencephalography device, in one yearBusiness Development Lead - Directed business development team to leverage existing business relationships to generate sales leads, established partnerships with Philips Lighting (Smart Home), Hasbro Lightsaber, and drafted partnership framework - Led team to participate in MassChallenge, a global startup accelerator competition, in 2016 and received the first prize (26th out of 4200 participants)

- Designed a conceptual data model (Enhanced Entity-Relationship) and a logical data model (Normalized Relational Schema) to build information system architecture based on company objectives; highlighted and explained benefits of these models to management - Wrote SQL queries to initialize 30+ tables; documented database schema and table relationships; populated with 350 rows of sample data to demonstrate system usability - Created 5 reports as a view in Oracle SQL to tell stories and generate business insights Offered analytical features that can measure and improve classroom utilization, supplier efficiency, and membership upselling