MICHAEL
A. OELKERS
I am a hands on Manager that works well across departmental boundaries. I have built exceptionally strong teams that get results where others fail. My business partners and I have always had a great relationship and they have seen me as a valuable part of their efforts and not an impediment.
As an accomplished IT Manager/Director, my career achievements have included seven-figure revenue growth, improved DSO by 4 days, eliminated manual report distribution processes within areas supported by custom applications, provided business users with efficient tools to access their data,managed a 4+ million dollar budget, and improved business process efficiencies.
EDUCATION:
Major: B.S. degree in Information Systems Management. GPA 3.67
PROFESSIONAL EXPERIENCE:
02/04 – 05/07 Wells
Consultant – Peoplesoft CRM 8.8 Implementation Reporting Lead
Responsibilities:
· Report Environment Architect for Peoplesoft 8.8 CRM implementation
· Report Solutions delivered using Crystal Reports XI, Crystal Enterprise v9 & XI, People Queries, PL/SQL packages and procedures.
· Responsible for Data and Reporting GAP analysis
·
Functional Specification Document creation
consisted of Business Process Analysis and Process Re-Engineering collaborating
with Senior Management and Functional Peoplesoft consultants.
· Technical Specification Document creation
· Creation of Data Flow Diagrams and Entity Relationship Diagrams for the reporting datamart
· Data Extraction, transform, load from multiple sources
· Created audit reports to determine data conversion anomalies
· Assemble reporting team – Interviewing, hiring, assignments
· Project Management – Scheduling, estimating, resource assignments, scope management
· PowerPoint presentations and misc Excel support
· Production Support and performance troubleshooting
02/98 – 04/03 Robert
Half Intl. –
Manager of Custom Applications &
· Managed team of 25-36 comprised of: managers, developers, business analysts and Off Shore personnel in support of a diversely tasked user community.
o Budget planning and allocation
o Annual Team Performance Appraisals
o All Staff related issues: hiring, firing, salary administration, bonuses
o Cross Departmental issue resolution
o Interim
Application Department Director for 6
o Senior Management presentations
o
o Oversee multiple concurrent projects
o Facilitated
o Formulate and present project proposals as a result of facilitated meetings with Senior Business Management
·
Enterprise Reporting Environment architecture and
o Design,
implement
§ Marketing -Web logs for the data source, Sales, Credit,
Payroll, AR, HR
o
o Establish
Coding standards for PL/SQL, Crystal Reports, Data Dictionary,
o Data
Extraction, transform, load from multiple sources(
· Project Management:
o prioritization of projects, Timelines using Microsoft Project
o Resource allocation and forecasting
o Meeting facilitation
08/97 - 02/98 BEA
Systems, Inc. –
Senior Software Engineer – Peoplesoft Applications
Responsibilities:
· Provided production support and system enhancements for Peoplesoft Financials and Human Resource applications.
· Application upgrade from 5.1 to 7.5.
· Project Lead for Peoplesoft supplied upgrade personnel provided by the Peoplesoft upgrade lab.
· Architected and implemented BEA reporting data mart using billing and receivables information.
· Provided business process analysis and functional knowledge support
· Evaluated Essbase and Powerplay to determine applicability for BEA reporting environment.
09/96 - 07/97 Sun Service -
Team Lead, Software Engineer - QTC Support Lead
Responsibilities:
· Technical Support Lead for the Quote To Collect (QTC) project for Sun Service.
· Identified data conversion issues and coordinated the resolution effort.
· Provided technical support for all interface systems that relied on contract data generated by RTS ( supplier of the contract system).
· Developed and reviewed design specs.
· Trained and supervised 2 additional support staff and coordinated their support duties.
· Provided project timelines, database and data mart architecture, creation and maintenance of the Business Object universes.
· Project lead for upgrade and datacenter moves.
· Data Extraction, transform, load from multiple sources
· Facilitated Business Process Reviews with all levels of Business Users to ensure each remote location followed a standard process
12/95 - 7/96 PeopleSoft
-
Asset Management Developer for Finance Department
Responsibilities:
· Modifications for the Public Sector version of the Asset Management application.
· Implemented design changes to the account entry portion of the application to allow reporting to multiple books and multiple currencies for international organizations.
· Developed Data Entry Screens utilizing GUI design standards.
· Provided troubleshooting expertise to external customers and created appropriate patches for future releases.
·
Data Extraction, transform, load from multiple
sources (
9/89 - 12/95
Computer Scientist - AIS
Responsibilities:
· Project Management
· Data modeling, code generation, implementation, maintenance and enhancements.
· Project lead for projects.
·
Team member for the ASSIST data warehouse
project designed to capture lab wide financial transactions to be used in
budget reporting and forecasting.
·
Team Member for the Management Information
Services Team (MIST), a prototype Self Directed Work Team, in Hazards Control.
· Team Lead for the Health Services medical scheduling and tracking system. Facilitated process review meetings and collaborated with Business users in creating proposals and Gap analysis
· Business Analysis for the Radiation Exposure Monitoring (REMs) application to identify data gaps and application requirements
·
Data Extraction, transform, load from multiple
sources (Mapper, Cobol,
6/85
- 8/89 Chevron
Programmer/Analyst
Responsibilities:
· Provided technical support to the accounting user community for all of the Chevron and Gulf Oil operating companies.
· Analyzed business processes and identified gaps that could be resolved programmatically
· Designed and coded conversion applications
· Designed and implemented NOMAD2 hierarchical databases.
· Created LOTUS 123 macros for uploading and downloading mainframe data.
· Project lead on several small development teams.
1/83 - 5/84 DPI
-
Associate Programmer
2/82 - 11/82 Masterbuilt Corporation -
Consultant
8/79 - 2/82 Four Phase Systems, Inc. -
International Marketing Associate Programmer
PROFESSIONAL
AFFILIATIONS: TDWI - The Data Warehouse Institute
Member 02/1999 - Present
Northern California Oracle Users Group (NoCOUG)
Executive Board of Directors 08/89 - 12/95
Member 08/89 – Present
Bay Area Nomad Group (BANG)
Executive Board of Directors 01/87 - 01/89