Status update (August 2009): Please do not contact me by telephone with interview requests at this time. My project has just gone live to production and I need to keep my phone line available for my customer's support needs.

Career Summary
IT professional experienced in Data Warehousing and Business Intelligence application development and support. Involved in all steps within the application development life-cycle. Proven ability to effectively plan and adapt to rapidly shifting priorities and deadlines.

International Business Machines, Tulsa, OK
Mar 2008 - Present
Hyperion Team Lead
Position summary: Team leader for on-shore and off-shore Hyperion support and software development staff of 5 people in an IT outsourcing arrangement between Williams Energy and IBM.

• Personally performed the first upgrade of any Oracle customer in the world to a "mixed release" of Hyperion System 9 and Oracle EPM 11.1.1.0. Worked closely with Oracle Product Assurance and Oracle developers to resolve bugs as they arose. Provided detailed feedback to Oracle, so that future Oracle customers performing this upgrade would encounter fewer issues.
• As Williams was an early adopter of Oracle EPMA (Enterprise Performance Management Architect) and Oracle EPM 11.1.1.0, worked with Oracle and the customer to identify and resolve numerous instability issues with respect to the vendor's packaged software. Oversaw over 160 Oracle "Service Requests" relating to Hyperion System 9, EPMA and Oracle EPM 11.1.1.0, without which the customer would not have been able to go live with the Hyperion upgrade project. When the upgrade project goes live in August 2009, Williams will be amongst the first handful of companies in the world to use EPMA in a production environment, and the first to do so in a "mixed release".
• Worked with the project architect and Informatica development team to design, build and implement a process to automate nightly processes relating to Essbase data loads and Oracle EPMA nightly metadata updates.
• Instituted automated monitoring to detect Essbase crashes and other failures, enabling the team to immediately respond to such issues. Previously, the team would be unaware of such issues until notified by a customer.
• Worked closely and pro-actively with project leadership to identify and resolve key risks with the Hyperion upgrade project.
• Provided technical leadership and mentoring, helping those on the team less familiar with Hyperion System 9 to come up to speed.
• Intervened in production support issues as necessary to improve issue turnaround time as well as the customer's perception of the team's customer service.

H&R Block, Kansas City, MO
2005-2008
Lead Software Engineer
Position summary: Team leader for software development and support staff responsible for H&R Block's implementation of Hyperion Planning (a corporate budgeting and forecasting system).

• Oversaw production support, provided level-of-effort estimates to project managers, interviewed job applicants and performed other team leadership duties.
• Supervised the migration of the Hyperion Planning 3.5 environment to Hyperion System 9. In addition to rebuilding all of the Hyperion applications, this project also included a new deployment of Hyperion Workforce Planning.
• Designed, developed and implemented a replacement budgeting system for the IT department. This replaced an Excel-based budgeting system with a Hyperion Planning application. The project resulted in IT's management and financial planners being able to see consolidated budgets in real-time, versus having to wait for an overnight batch process.
• Designed and implemented an Oracle Data Mart for the Hyperion team. This Data Mart enabled the Hyperion team to quickly react to district realignments within the Retail Tax business unit. Several years of financials could be restated in a single day, without needing to request upstream data providers to manually re-extract data from PeopleSoft.
• Streamlined the Corporate Allocations process to run in 15 minutes vs. 105 minutes, affording the users the opportunity to run multiple iterations of the process within a short time period.
• Automated the daily general ledger load into Hyperion, and added extra error checking and automated notification processes, so the team is immediately aware of any data, server or process-related issues. The log files had to be manually checked on a daily basis prior to this change.
• Simplified the process of comparing Hyperion Essbase metadata (dimensions) against source trees in PeopleSoft. Created a Visual Basic .NET application that connects to Essbase databases and produces simple text files containing dimension information. These files can be loaded in Excel or Access and quickly compared against PeopleSoft reports. The user I created this process for claimed I reduced 3-4 days of tedious work down to about 3-4 hours.
• Led the Hyperion team to complete the 2006 "Reporting Strategy" project on-time. This project included a complete overhaul of the PeopleSoft chart of accounts and addition of new PeopleSoft chartfields to the Hyperion applications.

International Business Machines, Overland Park, KS
2004-2005
Senior IT Specialist
Position summary: Team leader for on-shore and off-shore Business Intelligence / Data Warehousing software development and support staff of approximately 12 people in a "re-badged" IT outsourcing arrangement between Sprint and IBM.

• Provided production support for the Executive Management Information System (EMIS), a web reporting portal to Hyperion Essbase and ORACLE data sources.
• Oversaw production support and software development for Sprint's Wireless Finance Data Mart and Activity Based Management systems.
• Meet weekly with clients within Sprint Finance to review production support and software development status. Responsible for maintaining client satisfaction in the midst of outsourcing and offshoring.
• Provided Level of Effort estimates for application development projects ranging from <200 to >1500 hours.
• Regarded by clients as a subject matter expert in Sprint Wireless financial data and systems.
• Managed the monthly resource-level forecast for my teams.

Sprint Corporation, Overland Park, KS
1999-2004
Supervisor, Software Engineer V, Software Engineer IV, Software Engineer III
Position summary: Team leader for Business Intelligence / Data Warehousing software development and support staff of approximately 12 people.

• Designed and implemented infrastructure to automate Hyperion Essbase processes for Sprint's Wireless Finance Data Mart. Infrastructure could be deployed on UNIX and Microsoft-based systems without rewriting code or similar re-work.
• Provided secondary support and performance troubleshooting for Sprint's "Prophet" forecasting system. Received client recognition for resolving performance problems on an emergency basis in time for 2002 forecast cycle in coordination with Sprint Finance and Hyperion consultants.
• Wrote several C programs using the Hyperion Essbase API to automate various functions, ranging from security to dimension maintenance.
• Installed, upgraded and administered Hyperion Essbase servers running on HP-UX and Windows NT servers. Deployed Cygwin tools to Windows NT environments so servers could be remotely maintained in a fashion identical to the HP-UX servers.
• Built a Visual Basic application using the Hyperion Essbase API to assist in “Prophet” performance testing.
• Wrote a Visual Basic dimension maintenance application that presented hierarchical data contained within an ORACLE database in an interface familiar to Hyperion Essbase users.
• Converted client and 3rd party contractor developed Hyperion Essbase applications from manually-run prototypes to production automated systems. Provided ongoing production support for those systems.
• Determined and implemented performance optimizations for over a dozen Hyperion Essbase cubes.
• In Supervisor role (2003-2004), conducted staff performance reviews, career counseling, and other management functions.
• Interviewed and assessed internal and external job applicants (2000-2004).
• Oversaw production support and software development for Sprint's Wireless Finance Data Mart.

Pacific Linen Inc., Woodinville, WA
1994-1999
Senior Programmer/Analyst, Programmer/Analyst
Position summary: Led effort to transition company’s Business Intelligence from a legacy Retail STS system to database-driven ad-hoc reporting. Designed and implemented systems benefiting Distribution, Loss Prevention, Merchandising and Finance using Hyperion Essbase and Microsoft Access. Key systems designed and deployed were:

• Hyperion Essbase – Prior to the rollout of this system, detailed product sales history for roughly 60,000 SKUs (Stock Keeping Units) were only known for a rolling 13-week period. End-users used manually-intensive Monarch reports and spreadsheets. This project resulted in a data mart that was easy-to-use by non-technical users and retained data for a rolling 3-year period. End-user productivity dramatically improved – tasks previously taking 4-6 hours were completed within 5-20 minutes.
• Freight Tracking – This system transformed the Distribution department from using a manual (pen & paper) method of tracking inbound merchandise shipments to an automated database integrated with a legacy retail system (STS System). This resulted in Merchandise Planning being able to check shipment status from the PC rather than sifting through a spiral notebook.
• Sales Audit – This system allowed Loss Prevention to cross-reference credit card numbers with Point-of-Sale transactions to track potential credit card fraud. The system was later expanded to track employees who gave out too many discretionary in-store discounts.
• Merchandise Planning – The company could not afford to buy a retail modeling/allocation system, so an application was custom-built in Microsoft Access that interfaced with the STS Retail system and Hyperion Essbase. Merchandise Planners assessed product sales history and current stock levels in a single tool. Re-stocking parameters were easily entered in a GUI screen instead of the time-consuming legacy STS screens. Re-stock parameters for hundreds of products were remodeled in a single day – a task that took weeks prior to the introduction of this tool.

Vacation Internationale Ltd., Bellevue, WA
1992-1994
Programmer/Operator
Position summary: Performed software maintenance and enhancements for small projects requiring rapid turn-around. Also participated in daily computer center operations.

• Worked on numerous small programming projects (less than 400 hours per project) for in-house legacy system written in DATABUS
• Provided decision support to company management using Informix database of Call Detail Records. Utilized Call Detail Records to uncover internal telecommunication fraud.
• Participated in daily AIX RS/6000 computer center operations.
• Performed troubleshooting for end-users of hardware/software problems.
• Earned informal title of “the phone guy”: Primary person responsible for maintenance of company telecommunications systems (Harris 1200 PBX and ECD 2000 ACD). Primary liaison to telecommunications vendors (MCI, Sprint resellers, local contractors, etc.). Administered company voice mail (Smooth Operator 3.1).