Emily Zong Yuan Gan

New York, NY ***** 646-***-**** advu67@r.postjobfree.com Linkedin.com/in/emilyzongyuangan WORK EXPERIENCE

ANALYTICS VISUALIZATION MANAGER, Signify Health, New York, NY July 2021- April 2022 Home health care company that drives to bring health homeward

Worked closely with cross functional teams collaborating with operations and commercial product to execute internal applications and data products.

Led strategic initatives for the Implementation team for >$10M commercial products

Developed dashboards and fostered business team relationships by gathering requirements, writing user stories, and managing tickets in JIRA

Was a liason between stakeholders and engineering teams.

Trained teams on how to use finished data products and improved each monthly iteration from customer feedback.

PCP analysis match on existing members using multiple tables on the sql server and AWS Redshift environment which resulted in the measure being included as a lever in future program metrics.

Performed cost analysis on payor groups between 2018 and 2021.

Maintained python monthly reports for BPCIA new site analysis and progress reports.

Ad hoc analysis and SQL, python pull requests as needed. CREATIVE LEAD/CEO, Soap and Humanity, New York, NY Feb 2021- Present Artisan soap made with compassion and kindness in mind for humankind

Managed organizational strategy and communication across all channels of business, including sales, marketing, and operations.

Implemented organizational vision, mission, and overall direction.

Developed overall design elements and creation of art elements and concepts for finished products. SENIOR SALES FORECASTING ANALYST, Warner Bros., Burbank, CA Feb 2019- Dec 2020 Media and entertainment conglomerate and a leader in the American film industry

Forecasting decay plan, financial plans, and ad hoc insights for physical supply chain in the US and CA new title releases for >$100M grossing titles using SAS processes adjusted accordingly to industry and holiday trends.

Led Sales and Operations cross-functional weekly meetings with internal business clients on the TV, HBO, OAF, Turner, and theatrical teams to determine build quantities for upcoming releases. Titles included Rick and Morty, Arrow, Stargirl, Scooby Doo, Steven Universe, Game of Thrones, and It 2 and others. Organized and maintained meeting materials on Microsoft Teams and Sharepoint.

Created an automated program in Python for preparing weekly S&OP materials from SAP using Business Objects to facilitate the process.

Built, maintained, and optimized KPI tableau dashboards for TNR and OAF/TV/HBO to summarized plan, actual, LTD, and percent difference for Day 1, Week 1, Week 2, and Week 4 and outlook following streeting of the title. Engineered the backend data tables.

Created specs, scripts, documentations, workflows, and business process maps for projects and documented SAS/SQL processes.

EDAs in Python with seaborn package for prelimerary models for TV/HBO titles. DATA ENGINEER, SelectData, Orange County, CA June 2018- Jan 2019 Home health care coding services serving HHAs across the US in a start up environment

Managed day to day operations through Asana to keep track of projects with local and international engineering and data science teammates.

Automated manual excel processes using python. Utilized fuzzywuzzy and openpyxl python packages. Reduced task times from 2 months to an hour.

Emily Zong Yuan Gan Resume Page 2

2

Retrieved, cleaned, and pipelined data for different end users from SQL databases.

Created EDAs in jupyterlab with pandas, numpy, and seaborn python packages. CLINICAL PERFORMANCE MANAGEMENT ANALYST, Healthfirst, New York, NY April 2016- April 2018 Non-profit health insurance company serving New York residents

Deep diving into claims, financial, and member data to provide actionable insights to support business decisions.

Built, managed, and presented Tableau dashboards to management and senior management. Managed dashboards on Tableau Server.

Served as primary data resource and laison between business partners by closing gaps of knowledge in the data.

Gathered, transferred, cleaned, and analyzed data using SQL, python, R, or Alteryx in an Agile SCRUM environment. Each data project was put into an epic with a spec and user story and followed through on an internally built webpage modeled after JIRA.

Built forecast model for quality rates to offset 3-month lag period in measures; forecasted rates were used to set 2018 goals.

Maintained monthly and quarterly performance rates and quality measures reports to state.

Supported data management and automation efforts within the company, mainly with the IT department and saved over 20 hours/month.

Created powerpoint presentations for team and live demos of analyses in R Studio.

HIPPA trained and provided departments with ad-hoc analyses upon request. ACCOUNT EXECUTIVE, Village Print and Media, New York, NY June 2014-Oct 2015 Manhattan’s 24/7 on demand digital and specialty printer

Identified new client and potential business opportunities as well as fostering existing client relationships.

Handled client communications and daily communication with senior executives and managers.

Worked with sales and marketing teams to prepare presentations and sales pitches.

Developed and trained new hires on the team and whatever else was necessary to become an effective liaison between the agency and its clients.

EDUCATION

BS in Biological Sciences, City College of New York School of Medicine (BS/MD), New York, NY June 2014 Minor: Business Management and Administration GPA: 3.7 Certified Data Analytics Practitioner, Principal Analytics Prep, NY, NY April 2016 12 week full time intensive, hands on real world training in data science, analytics & business PEER REVIEWED PUBLICATIONS & ABSTRACTS

Gan ZY, Cosgrave L, Grimm J. Molecular imaging to assess tumor-associated macrophages with targeted nanoparticles. 2011.

Kodela R, Chattopadhyay M, Goswami S, Gan ZY, Rao PP, Nia KV, Velázquez-Martínez CA, Kashfi K. Positional isomers of aspirin are equally potent in inhibiting colon cancer cell growth: differences in mode of cyclooxygenase inhibition. J Pharmacol Exp Ther. 2013 Apr; 345(1):85-94.

Chattopadhyay M, Nath N, Kodela R, Sobocki T, Metkar S, Gan ZY, Kashfi K. Hydrogen sulfide-releasing aspirin inhibits the growth of leukemic Jurkat cells and modulates β-catenin expression. Leuk Res. 2013 Oct;37(10):1302-8.

Contact this candidate