Sawyer Song

Sawyer song

bookmark on deepenrich
location of Sawyer SongSeattle, Washington, United States
Followers of Sawyer Song674 followers
  • Timeline

  • About me

    Business Analyst At Amazon | Data Analytics |Product Management

  • Education

    • China university of petroleum (beijing)

      -
      Bachelor’s degree petroleum engineering

      Activities and Societies: • Arts and Literature Director Student Union, CUPB

    • University of houston

      -
      Master's degree petroleum engineering
    • University of alaska fairbanks

      -
      Bachelor's degree petroleum engineering

      Activities and Societies: Vice President Chinese Student Association, UAF Society of Petroleum Engineers (SPE) American Association of Drilling Engineering (AADE)

  • Experience

    • University of alaska fairbanks

      Sept 2013 - May 2014
      Teaching assistant

      • Tutoring & evaluating Differential Equation and General Physics homework and quizzes prepared by undergraduate students

    • Petrochina co. ltd.

      Jun 2014 - Aug 2016

      • Monitor and diagnose the status of drilling fluid.• Assist senior drilling engineer to solve operational problems; changing drilling bits, replacing casing slips. • Maintain the gas pipeline and additional gas field equipment.• Organize and maintain a centralized database to be used by the team members for natural gas demand and supply analyses. • Analyzed the geological characteristics, oil reserves, reservoir pore structure and percolation characteristics.• Analyzed the formation testing, pilot production and productivity of oil wells • Integrated the geological data for analyzing the daily conditions of different oil wells and drew the production curve• Predicted the future productivity with the 3D numerical simulation software eclipse to determine the well pattern and the optimization of the well network deployment

      • Field Drilling Engineer Intern at Dagang Drilling Company, CNPC

        May 2014 - Aug 2016
      • Injection-Production Engineer Intern at Dagang Gas Storage

        May 2015 - Aug 2015
      • Reservoir Eningeer R&D Research Institute of Huabei Oilfield

        Jun 2014 - Dec 2014
    • University of houston

      Jan 2015 - Jan 2017
      Graduate teaching assistant for petroleum production economics graduate course

      • Past Graduate Teaching Assistant in: Petrophysics lab Pressure Transient testing class Petroleum Production Operation class

    • Calpine

      Jan 2018 - Jul 2018
      Data analyst

      • Project design and support at Calpine data analysis group troubleshooting, producing, troubleshooting, maintaining the real-time database and analytics dashboard (PowerBI) over 79 power plants plus Enterprise Data Historians in Azure.• Applied data modeling, analysis, and calculate key real-time performance characteristics including efficiencies, corrected ambient conditions, and energy totals for over 87 combined cycle, simple cycle, and geothermal power plants using VBA.

    • Energective

      Jul 2018 - Jan 2022
      Senior consultant

      • Created and maintained real-time dashboards (Qlik, PowerBI, Spotfire) providing clean data cross the multiple groups (reserves, subsurface, finance, operation, and facilities of more than 5000 offshore wells in Gulf of Mexico. Provided business insights to the management team and stakeholders.• Guided and supported cross-functional teams (product, development, engineer) of 10 – 15 employees to develop new data applications for E&P planning using domain knowledge (product design, debug engineering issue, implement & test, release), optimized clients’ rig schedule and planning to achieve maximum return.• Applied combination of SQL, Python, and another data analysis technique (data modeling, wrangling, visualization) extracting live daily operational data over 100K reports, designed, and developed multiple databases and dashboard on the live data, and support daily operation for more than 10 assets and across 15+ operators. Show less

    • Amazon

      Jan 2022 - now
      Data product manager

      Achievements• Launched amazon seller insights platform integrates the data pipeline, data reporting, business insight as part of the data ecosystem empowers over 100 cross-functional users and reduces 10% of operating cost.• Implemented 20+ automated reporting and dashboards, reduced the team’s manual effort by 30% within a year. Provided data driven insights for product managers on customer needs and pain points to enhance omnichannel shopping experience.Responsibilities• lead cross-functional teams to collect product requirements and iterate MVPs on data readiness, design data roadmap to support GTM readiness plan for multiple amazon shopping features, set data-driven KPIs to ensure product functionality, and generate an estimated annual $25M+ GMS in 2023.• Develop analytics reports and dashboards to identify growth opportunities for sales team, set data-driven metrics to drive sales strategies, securing 5 strategic sellers to onboard with additional $10M+ GMS in 2022.• Conduct monthly voice-of-customer interviews implement 50+ data requirements and prioritize user stories in dashboard enhancement. Translate customer needs and pain points to the data engineering team to ensure data accuracy and usability.• Design and execute A/B tests to analyze and measure the impact of multiple new shopping features launches and marketing campaigns. Show less

  • Licenses & Certifications

    • Advanced open water diver

      Padi
      Dec 2019
    • Data analyst nanodegree

      Udacity
    • Qlik sense 3 day oem bootcamp

      Qlik
    • Data analysis with pandas and python

      Udemy
      May 2020
      View certificate certificate
    • Python for everybody specialization

      Coursera
      Apr 2020
      View certificate certificate
  • Volunteer Experience

    • Volunteer

      Issued by Society of Petroleum Engineers on Jan 2015
      Society of Petroleum EngineersAssociated with Sawyer Song
    • Board Member

      Issued by Society of Petroleum Engineers - SPE GCS Gulf Coast Section on May 2017
      Society of Petroleum Engineers - SPE GCS Gulf Coast SectionAssociated with Sawyer Song
    • Industry Liaison

      Issued by Society of Petroleum Engineers (SPE) - University of Houston Student Chapter on May 2016
      Society of Petroleum Engineers (SPE) - University of Houston Student ChapterAssociated with Sawyer Song