Loren Mehl
*** *** ***** ? San Marcos, CA ***** ? 760-***-**** ? *********@*****.***
_____________
Business Analyst / Technology Project Manager
Analyze and manage enterprise data that drives strategic planning and key
business decisions for departments throughout the company. Extensive
experience in Business Trending and Analysis, Budget Development and
Implementation, and Income and Expense Supervision. Expertise in Data
Mining and Business Forecasting through SQL queries and custom Excel report
development. Ensure data integrity with large volume of sensitive data.
Skilled at communicating financial data to Executives and Managers that
analyzes their concerns and provide recommendations to address their
business needs.
Professional EXPERIENCE
ResorTime.com, LP, Carlsbad, CA (wholly owned by Grand Pacific Resorts)
2005 - Present
Technology Project Manager / Business Analyst
. Manage web application technology projects for Timeshare/Resort
Reservation System (call center and online booking) including software
development, testing, implementation, and user guides.
- Spearheaded automation processes which streamlined operations and
improved accuracy. Proactively data mined business intelligence to
address problem areas and developed ad hoc reporting for departments
to utilize for creation and validation of strategic business plans.
. Serve as Subject Matter Expert for business analysis and trend reporting
via direct SQL queries and customized ad hoc reporting, data mining, for
Department Managers, General Manager, and Owners.
- Developed and implemented departmental metric reporting. Trained
Managers how to analyze key data trends and metrics and provided
suggestions based on data analysis.
. Designed Financial Statement Forecasting via direct SQL queries and
advanced Excel report builds.
- Improved results of financial forecasts compared to actual revenues
through enhanced reports.
. Research new technologies and industry practices for enhancement of
existing products and procedures. Developed Q/A processes for ensuring
security and best practices IT environment.
- Currently orchestrating entire system redesign and redevelopment to
upgrade technology and content management to support online reservation
system in attempt to compete against industry leaders.
GenaRes Worldwide Reservations, Grapevine, TX 2004 -
2005
Director of Operations
. Championed the development of a startup hotel reservations company.
Created and implemented business plan including planning, cost
forecasting, and implementation of business operations
. Directed office design/setup including all site requirements such as
phone switch and ACD for call center, selection and layout, defined
design criteria, and managed vendors through installation.
. Negotiated and implemented contracts with Pegasus and all GDS
implementations.
. Managed application development of Reservation System ensuring
functionality was delivered on time and as specified. Executed
successful launch for new accounts, including all 5 Lexington Management
Hotels.
Lexington Management Corporation, Dallas, TX 1996 -
2005
Director of Operations / Director of Information Services
. Managed operations for management company with 5 hotels and 3 apartment
complexes. Performed General Manager functions for corporate owned
hotels. IS/IT duties included software development, training, and 24/7
support of property management system.
. Wrote Accounts Payable program to integrate with Budget system to improve
integrity and data usability for Hotel Managers in Visual Basic to
maintain expenses for comparison to budget/forecasts.
. Systems Administrator for hotel reservation division, Lexington Services
Corp. from 1996-1998 prior to sale. Managed all UNIX servers and provided
technical support for over 3,500 connected hotels.
Geac Computers, Inc., Dallas, TX & Tustin, CA
1990 - 1996
Senior Support Technician / Software Developer
. Provided technical and procedural support for proprietary hotel and
construction accounting software to over 200 hotels worldwide. Support
included real time software fixes, system failure diagnostics, custom
programming, client training, and site installation.
Education
University of Phoenix - Axia - enrolled in Finance Program
TECHNICAL SKILLS
ExactTarget email system, Omiture Web Analytics, iCrossings Search Engine
Optimization, SQL, Unix, Visual Basic, HTML, Microsoft Office Suite:
Word, Excel, PowerPoint