Yifeng Amy Hu

Phone: 626-***-**** Email: adikpq@r.postjobfree.com

QUALIFICATIONS

* *****’ data analysis experience with large relational database and data manipulation and 4 years in Managed care at health care company.

Practical skills in clarifying business requirements, performing analysis to meet goals, improving existing processes to increase productivity and reduce costs.

Extensive experience in business analytic, reporting, developing pricing/predictive models, and forecasting.

Proficient in programming with SQL, Access &Excel. Experienced with SSRS, SSAS, Python, Tableau.

Certified SAS programmer with abundant experience in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS. PROFESSIONAL EXPERIENCES

Part time Consultant, DigitCompass 2019-present

Extract, collect and clean data from different source. Create dashboard and reports to present data. Business Analyst contractor, Chatsworth Products Agoura Hills, CA 2019

Wrote queries and stored procedure in MS SQL Server to produce daily reports. Created dashboard in Tableau for visualization.

Senior Forecast Analyst, Harbor Freight Tools Calabasas, CA, 2016

Utilized extensive analytical skills to develop predictive model forecasting sales of hundreds of SKUs.

Executed forecast and run analysis to support decision-making activities regarding marketing, pricing, purchasing, inventory management, and resource allocation.

Pricing Analyst, Surgical Care Affiliates Woodland Hills, CA, 2009-2012

Investigated payer reimbursement, meticulously tracking billing and payment to ensure accurate payments: identified $900,000 underpayment within three months in collaboration with claim resolution manager.

Created customized calculators to enable quick and accurate implant billing, semi-automating billing to maximize revenue and reducing human errors by 90%.

Reliably generated monthly reports on net revenue, charge and case mix at national, regional, state and facility level in MS SQL Server to support executive decision making. Applied technical skills to develop ad-hoc queries and reports and provide business solutions to enhance organizational efficiency.

Expertly developed pricing models to maximize company profit, guiding contract negotiations. Employed extensive analytical skills to provide data analysis supporting decisions on facility acquisition and contract termination.

Diligently updated the database with latest contract, fee schedule, and crosswalk changes to support 130 facilities. Research Analyst, Waterford Research Institute Salt Lake City, UT, 2008

Performed statistical analysis in SPSS and IRT analysis with students’ math and English test data.

Update database with test data.

Research Analyst, Math ACTS Project, University of California at Riverside Riverside, CA, 2005-2007

Developed and maintained project database with strict attention to detail and ensuring 100% accuracy.

Skillfully performed statistical analysis and longitudinal study with several related data sets of 9,000 students at 19 local schools, providing information for evaluation and decision making.

Expertly extracted, transformed and loaded data from state system, district database, school records, surveys.

Conducted quality control, data validation, data cleaning and database backup to ensure accurate data.

Summarized data and prepared reports in clear, comprehensive format for presentation to the diverse audience. EDUCATION

Boston College, M.Ed., Educational Research, Measurement & Evaluation (Minor: Applied statistics) Boston, MA Northern JiaoTong University, Bachelor of Engineering/ Business Beijing, CHINA

Contact this candidate