MICHAEL
A. OELKERS
(925) 443-2333
Cell (925) 200-2145
TECHNICAL SUMMARY:
Operating Systems: UNIX, Windows X/NT,
OSF/1.13, Mac OS 7.5, DOS, VMS, VM,
MVS
Hardware: DEC
Alpha 3000, Sun SPARC 20, HP9000, DEC/VAX 3100, Personal Computers, Macintosh,
IBM 3090x, 370, 3725, 4331, 308x
Languages: SQL, PL/SQL, SQR, Java,
Oracle Tools, PeopleTools 8.45, Crystal Reports v5-XI, Crystal Enterprise XI,
Brio, Business Objects, PL/I, COBOL
DBMS: ORACLE
v6/7/8/9i/10g, SQL-Server 2005, Sybase, SQLBase, Nomad 2, FoxPro
Tools: Microsoft
Office: Word, Excel, PowerPoint, Microsoft Project, Visio,
Database
Tools: TOAD, Oracle Designer 2k, Erwin , Autosys,
Data
Warehouse/BI tools: Informatica (
Methodologies: Oracle
Case, Rational Unified Process (RUP)
PROFESSIONAL EXPERIENCE:
08/07 –
05/08 Perquest Inc –
Product Manager – Analytics & Data
Warehousing
Responsibilities:
· Report Environment Architecture
· ETL process design, implementation
· Ad Hoc reports to support Sales
· Dashboard design
· Project plans/Timelines
· BRD’s TDD’s
· Poduction support
· Code standards
·
Create Stored Procedures
02/04 – 04/07 Wells
Consultant – Peoplesoft CRM 8.8 Implementation Reporting Lead
Responsibilities:
· Report Environment Architecture for Peoplesoft 8.8 CRM implementation for Treasury Management Services utilizing Data warehousing best practices of staging areas, facts and dimensions and data normalization..
· Report Solutions delivered using Crystal Reports XI, Crystal Enterprise v9 & XI, People Queries, PL/SQL packages and procedures.
· Modified the Dispatch Board for online/real-time Service Order status.
· Installed and configured Peoplesoft EPM 8.9 module for CRM for analaysis :
o Efforts included:
§ evaluating Smartviews and PeopleQueries for functionality and to determine level of effort required for modifications.
§ Modifify Ascential ETL scripts to process additional data to reflect ServiceView CRM Modifications
§ Created additional People Queries for audit purposes to validate ETL processes
§ Created additional Trees and branches to facilaitate Provider Group views to select data and KPI’s.
· 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 Conversion from Vantive to Peoplesoft data architecture utilizing existing Peoplesoft ERD’s
· Data Extraction, transform, load from multiple sources using Application Engine processes.
· Created audit reports in both Crystal and People Queries to determine data conversion anomalies at start of project
· Assembled reporting team – Interviewing, hiring, assignments
· Project Management – Scheduling, estimating, resource assignments, scope management
· PowerPoint presentations and misc Excel support
· Production Support and performance tuning
Technologies:
Oracle 9i & 10g, Peoplesoft
CRM 8.8/8.9, Peopletools 8.45, EPM 8.9,
02/98 – 04/03 Robert
Half Intl. –
Manager of
· Managed team of 25-36 comprised of: managers, developers, business analysts, DBA’s 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, training, career planning
o Cross Departmental issue resolution facilitator
o Interim
Application Department Director for 6
o Senior Management presentations for new projects and architectural overviews
o
o Oversee multiple concurrent projects
· Business Community Process Review facilitation
o Facilitated
o Formulate and present proposals as a result of facilitated meetings with key business users
·
Enterprise Reporting Environment architecture and
o Design,
implement
§ Marketing -Web logs for the data source
§
§ 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,
o Resource allocation and forecasting
o Projects were focused on replacing manual processes, reducing costs, increasing end user productivity, creating platform independent applications.
· Developed SQR data extraction and load procedures. Later converted these to Informatica maps with PL/SQL database procedures to improve
· Developer Brio Designed reports
Technologies: Informatica, Brio
Designer, Hyperion Essbase, SQR, Crystal
9, Oracle: 8i, 9i, D2k/IFS/IAS, Java, PL/SQL, SQL+, SQL*Navigator, Toad, Erwin.
Data extracted from Web logs, Peoplesoft Financials and HR and MicroJ (in-house
developed application for the sales force). MS Project, Powerpoint, Excel,
Access,
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.
· Member of upgrade team moving from 5.1 to 7.5.
· Project Lead for Peoplesoft supplied upgrade personnel provided by the Peoplesoft upgrade lab.
· Created financial reporting environments utilizing the Query/Crystal tool as well as SQR.
· Provided business process analysis and functional knowledge support
· Evaluated Essbase and Powerplay to determine applicability for BEA reporting environment.
· Architected and implemented BEA reporting data mart using billing and receivables information. Data extracted using SQR processes.
Technologies: SQR, Crystal, Oracle: PL/SQL, SQL+, Peopletools 7.5, Hyperion Essbase, Brio Designer, People Queries, Windows NT, Unix, MS Project, PowerPoint, Excel, Designer, Erwin, Visio
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.
·
Business
· Project lead for upgrade and datacenter moves.
· Data Extraction, transform, load from multiple sources
· Established business processes and provided QA review of code to ensure standards were followed by offsite organizations.
· Facilitated Business Process Reviews with all levels of Business Users to ensure each remote location followed a standard process
·
Technologies: Oracle – 8i, PL/SQL, SQL+, Designer; Business Objects,
Java, UNIX, MS Project, PowerPoint, Erwin,
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 (
Technologies: SQR,
9/89 - 12/95
Computer Scientist - AIS
Responsibilities:
· Project Management
· Data modeling, code generation, implementation, maintenance and enhancements.
· Created ETL processes to combine legacy data with new application data.
· Project lead for several medium to small projects.
· Daily tasks included:
o creating project timelines,
o coding assignments for team resources,
o data conversions
o system architecture.
o Business Process Analysis and Review/Design
· Team member for the ASSIST data warehouse project designed to capture lab wide financial transactions to be used in budget reporting and forecasting. All systems were designed utilizing Oracle's CASE development Methodology and CASE development tool, which maintains dictionary information, used in ERD's, DFD's, and MDD's. Oracle tools were used for development and implementation.
·
Team Member for the Management Information
Services Team (MIST), a prototype Self Directed Work Team, in Hazards Control.
o Facilitated
business process reviews focused on
identifying functional gaps and DOE non-compliance issues.
· 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 REM’s application to identify data gaps and application requirements
·
Data Extraction, transform, load from multiple
sources (Mapper, Cobol,
Technologies: Oracle 7, 8i, PL/SQL, SQL+, SQL*Loader, Case Designer, Nomad, Business Objects, C++, Unix, VMS, DOS, Mac OS, MS Project, PowerPoint, Excel
6/85
- 8/89 Chevron
Programmer/Analyst
Responsibilities:
· Provided 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 utilizing PL/1 and COBOL.
· Designed and implemented NOMAD2 hierarchical databases.
· Created LOTUS 123 macros for uploading and downloading mainframe data.
· Project lead on several small development teams.
Technologies: PL/I, COBOL, MVS, VMS, JCL, DOS, Lotus 123
1/83 - 5/84 DPI
-
Associate Programmer
Responsibilities:
· maintenance and enhancement of IBM's in-house inventory tracking system written in PL/I and Assembler
· Technologies: PL/1, Assembler, and JCL
2/82 - 11/82 Masterbuilt Corporation -
Consultant
8/79 - 2/82 Four Phase Systems, Inc. -
International Marketing Associate Programmer
Responsibilities:
· Analyzed, designed, coded and implemented a computer configuration system that interfaced with the accounting department for international client credit authorization.
EDUCATION:
Major: B.S. degree in Information Systems Management. GPA 3.67
PROFESSIONAL
AFFILIATIONS: Northern California Oracle Users Group (NoCOUG)
Executive Board of Directors 08/89 - 12/95
Member 08/89 – Present
TDWI
- The Data Warehouse Institute
Member 02/1999 - Present
Bay Area Nomad Group (BANG)
Executive Board of Directors 01/87 - 01/89