Jiefu Han Email & Phone Number

Beijing, China

Beijing, China

Beijing, China

El Segundo, California

El Segundo, California

Shanghai City, China

• Supervise a team overseeing short-term forecasting, product pricing, and yield management for the theme park. • Oversee development of attendance normalization models, pricing sensitivities analyses, and other analytical procedures that yield insightful and pertinent findings used to make strategic business decisions.• Assess implications of new product ideas and provide recommendations to the leadership team whilst considering ability to achieve key metrics within the annual operating plan and long-term forecasts.• Provide foresight to Operations in terms of attendance outlooks which are leveraged to properly schedule and staff the theme park in order to sustain high guest satisfaction and experience.• Manage yield such that revenue is maximized whilst ensuring necessary fluidity of ticket inventory via the various sales channels.

Shanghai City, China

• Part of Shanghai Disney Resort Grand Opening team.• Developed short-term, attendance forecast models utilizing SAS and VBA. For initial modeling, led the development of web scraping tools that collected data from various e-commerce, ticketing platforms and utilized the day-over-day pick-up to formulate an overall booking pace.• Assisted in development of Business Objects reports of which is leveraged by multiple lines of business to ascertain actual attendance and historical sales performance.• Collaborated with Sales and Marketing to define initial ticket allocation strategy amongst the various sales channels.

Detroit, Michigan; Shenzhen, China

• Worked on international project providing functional and technical support from a data perspective for multiple ERP modules (indirect procurement, general ledger, real estate, and accounts payable). • Developed validation procedures using SAS and VBA to test the cleanliness and completeness of data and to ensure business and ERP requirements are met prior to conversion. • Facilitated and led discussions with local business to understand legacy processes and system and identify design gaps between legacy and new ERP system.• Assisted with journal entry testing in order to identify potential fraudulent activity or entries of audit-interest for multiple clients. • Provided audit support on varying regulatory areas ranging from Regulation AB, Securitization, and Dodd Frank. Performed analytics of consumer and commercial portfolios to be reported in 10-K, 10-Q, and other financial disclosures• Trained and acted as onboarding advisor to first-year consultants.

Detroit, Michigan

• Worked with audit team to identify profiling changes of securitization deals. Implemented required changes by creating and modifying Mainframe programs.• Created SAS programs to parse data files and provide summarized reports.

Auburn Hills, Michigan

• Improved data retrieval process for monthly Cp/Cpk reporting by creating an interface that automates the process. Reduced four hour retrieval time to five minutes. • Assessed Jeep Wrangler sport bars impact on BIW build and found root causes to existing variations in build. Proposed possible changes to me implemented in downstream operations.• Created VBA code to verify and validate CMDANA data as well as to perform other miscellaneous tasks.• Managed a group assembled from various cross-functional departments on projects and assignments.