Stephanie Guo Email & Phone Number

Beijing, China

中国 北京市 朝阳区

Shenzhen, Guangdong, China

Plano, Texas, United States

• Processed ETL with SQL and Python for multiple data sources: Medellia, Marketo and Adobe Analytics, etc.
• Designed time series model with both deep-dive statistical and machine learning solution with limited data inputs
• Built and maintained a data driven business strategy for sales people visit strategy with an overall 4% uplift in target sales
• Created a revenue management system for a nationwide business company with significant uplift in revenue GPI
• Identified, measured… Show more
• Identified, measured and calculated price sensitivity and improved price optimization model with accurate price elasticity Show less

Plano, Texas

Dallas/Fort Worth Area

• Designed and developed metrics, reports and analyses to drive key business decisions using Power BI and SQL
• Collected and cleaned data from different departments and provided a link between raw enterprise data and the business
• Analyzed processes for opportunities to streamline and automate, and built QC processes and reports to inform management of data quality levels and discrepancies
• Built whole ETL process and created business solution reports for vital business… Show more
• Built whole ETL process and created business solution reports for vital business opportunities as expanding rental market Show less

Dallas/Fort Worth Area

• Worked with Revenue Management Team to identify ways to improve its performance and determine which factors have the potential to drive future Revenue Per Available Seat Mile (RASM) and Revenue growth
• Had the monthly presentation to company project managers from different departments; introduced present process and business insights, discussed their expectations and further requirements.
• Built useful database based on quarterly aggregate data with over 70000… Show more
• Built useful database based on quarterly aggregate data with over 70000 observations.
• Started with a linear regression model for descriptive using R Studio. Show less

Dallas/Fort Worth Area

• Communicated with a local start-up client to analyze as-is business processes and future requirements
• Cleansed and analyzed client data and combined this data with external data to extract business insights using Excel andAlteryx
• Developed models and dashboards for the client using Tableau illustrating geospatial, customer, sales, and operation insights
• Based on to-be development strategies generation, formed multiple views of data to develop business insights

Beijing City, China

• Designed practice problems to prepare students for the TOEFL exam (language test) to assist student development
• Mentored students and reviewed work assignments.
• Recorded and reported students’ homework completion to leaders

Shijiazhuang, Hebei, China

• Extracted customer data and validated and edited completed balanced sheets daily for accuracy
• Monitored and developed alerts based on loan status of business accounts using daily financial flows and recent news
• Evaluated potential bad loans and recorded the progress of the loan to department manager
• Recommended advanced financial products to potential customers through social media and face to face

Master'S Degree, Business Analytics, 3.8

Courses: - Database Design For Business Applications - Business Process Analytics - Pricing And Revenue Optimization - Decision Models.

Bachelor Of Arts - Ba, Statistics