Frank Li Email & Phone Number

Greater New York City Area

An Omnicom Company

Greater New York City Area

Greater New York City Area

Greater New York City Area

Greater New York City Area

Park Ridge, Nj

- Performed complex data mining and analysis in all areas of sales reporting through forecasting, regression, cannibalization, risk and probability modeling- Developed and managed relational databases for comprehensive analysis and tracking- Produced scheduled and ad-hoc reports to be utilized by senior management for the growth and development of global sales operations - Responsible for travel agency and corporate market share data load and validation- Created and managed preferred vendor agreement bonus and commission statements- Gathered business and technical requirements from companies internally/externally to conform to projects and business needs- Assisted in the strategic planning of increasing rate per day for corporate contracts- Responsible for the redesign and implementation of Hertz Global Sales Library intranet

Park Ridge, Nj

Proficiency: Microsoft Excel, Microsoft Access, IBM Cognos, Rubicon Decision Point, RAM, Emulation and Databases- Devised and executed pricing strategies for $450M North American one-way business segment- Determined accuracy of pricing positions and analyze current and historical trends to uncover areas of revenue opportunities- Evaluated and consolidated one-way rate canvassing data process resulting in a 30 percent reduction in costs- Provided ad-hoc analysis for management to drive critical business decisions- Ran multiple queries on reservation data to forecast P&L while monitoring competitive behavior- Monitored reservation build and KPI's to ensure channel sales were optimized- Developed and maintained emulation involving logic formulas and macros creating a dynamic, automated pricing system for one-way business and leisure segments

Greater San Diego Area

- Developed and maintained a detailed project schedule which includes weekly status reports to the director, administrative tasks, and all aspects involved within a project- Provided oversight of 100+ projects while tracking project changes, progress, goals, milestones and tasks, and time and resource planning within Microsoft Project- Directed technical and personnel resources to ensure project results conform to quality, time and budgetary stipulations- Responsible for managing project budget management to allocate overall cost estimate to individual tasks- Developed and maintained Change Management ensuring that all Production Changes and Service Requests adhere to guidelines of process flow chart- Provided the business and technical expertise in the planning and execution of large-scale fundraising initiatives including mass mailings, telemarketing drives, direct mail, data loads, and e-commerce- Coordinated meetings, including travel arrangements and expense reports- Ensured coordination of all EASS interfaces- Evaluation of Project and Portfolio Management software and application vendors to improve process and adapt into organizational culture.- Defined goals and outline approach and make adjustment within the constraints set to achieve the optimum results- Worked with specialists in the field of development, produce goal and target specifications, solve any conflicts that arise, and minimize potential risks- Provided technical support and testing for various applications and software for administrators and users- Developed training plans to help with specific tasks such as creating web based training videos and provides training information on the web- Researched and recommend software solutions for applications- Maintained a appropriate relationship with customers and ensure that the project results are comprehensible to management- Produced technical, business, and economical feasibility documentation for project ideas

Greater San Diego Area

- Provided quality technical frontline support configuring the development environment to mirror production, and in-depth troubleshooting including parsing multiple logs, data sources and systems in order to help diagnose and fix issues that spanned a variety of connected systems- Wrote technical documents describing how to perform various technical tasks associated with the Portal- Worked in a team concept with Admissions and other departments to create and update development of channels in the Portal