Post Job Free

Resume

Sign in

Project Management Data Warehouse

Location:
Santa Fe, TX
Posted:
January 31, 2024

Contact this candidate

Resume:

Michael M. Schlager

**** ***** **** *****, *******, Texas 77059

713-***-****

ad29j6@r.postjobfree.com

SUMMARY

Highly skilled, solution-minded professional in the information technology field. Expertise includes SAS statistical programming, Agile methodology, process improvement planning, business efficiency analysis, project management, data warehouse management, downsize planning, budget analysis, technology improvements and personal communication.

Process Improvement Planning/Business Efficiency Analysis

Reduced company annual costs by over $800,000 and eliminated time constraints for global business systems by analyzing business processes, designing and implementing improvements.

Project Management

Managed digital solution projects at ExxonMobil Baytown Technology and Engineering Company including digital forms, workflows and SAP data cleanup.

Lead analyst and developer on technology exchange projects between legacy mainframe systems and SAP client systems.

Project lead on the Year 2000 analysis project at ExxonMobil Global Services Company for the financial application support team.

Data Warehouse Management

Lead analyst on the SAP Equipment data cleanup project at ExxonMobil BTEC.

Experience as a DBA in database and data warehouse design and management for large data-intensive companies such as ExxonMobil and NASA.

Designed, prototyped and implemented both data warehouse systems and corresponding retrieval and reporting applications.

Downsize Planning/Data Center Consolidation

Analyzed enterprise facilities for potential downsizing of existing mainframe-based applications to distributed architectures.

Developed system cost methodologies to compare total IT costs with industry standards to aid in reducing IT budgets.

Budget Analysis

Produced long range resource assessment and direction plans for large data center computer systems.

Researched and recommended strategies for acquiring equipment based on projected user and technology requirements.

Developed equipment acquisition and life cycle models for obsolescence planning.

Produced complete equipment budget analyses and schedules incorporating resource migration plans and life cycle models.

Personal Communication

Complete personal communication skills, including presentations, technical writing and email systems.

Conducted briefings on current and completed tasks, presenting results and recommendations.

Comfortable presenting to all levels of management.

EMPLOYMENT HISTORY

2021 to 2023 Data Analyst III, on contract to ExxonMobil BTEC, Baytown, Texas.

Project Manager for the Digital Solution Team delivering performance reduction of over 14 Man-Year Equivalent (MYE).

Lead data analyst for the Baytown Chemical Site SAP Equipment table clean-up of over 16K assets.

Designed Power BI reports providing key metrics for upper management on project status and MYE.

1997 to 2020 Application Support Analyst, on contract to ExxonMobil Corporation, Houston, Texas.

Trained in Agile Methodology, Scrum Master, PI Planning.

Lead support analyst of project development for the global financial billing systems operating on both VM/NOMAD and MVS/SAS mainframe platforms.

Realized a $300,000 annual savings by retiring accounting and reporting systems.

Reduced IBM mainframe annual costs by over $250,000 by eliminating unused software.

Improved data file exchange processes between vendor software and SAP systems.

Completed the merger-related Exxon and Mobil financial billing system consolidation earlier than required deadlines.

Automated monthly financial billing process reducing timelines from five days to a single overnight process meeting global customer's expectations.

100% successful implementation as project lead on the Year 2000 project.

1993 to 1997 Senior Software Engineer Specialist, United Space Alliance, Houston, Texas.

Project manager and lead engineer of the IBM mainframe performance and tuning department supporting NASA, Johnson Space Center Shuttle Flight Operations.

Saved NASA over $400,000 in upgrade computer system costs by analyzing system performance, recommending and implementing system improvement changes.

Slashed over $100,000 in annual costs using process improvement automation.

Conducted meetings and presentations to NASA clients on highly visible projects.

1984 to 1993 Member of the Technical Staff, MITRE, Houston, Texas.

Researched and developed solutions to computer-related problems encountered by NASA, Johnson Space Center, Houston, Texas.

Communicated directly with NASA managers through meetings, presentations and electronic mail.

Developed and administered mainframe performance evaluation benchmarks decisive in the NASA computer acquisition process.

Produced long range capacity management plans and budget analyses for equipment life cycles and acquisitions.

Performed independent validation and verification studies for NASA, e.g. cost conversion, workload characterization, new technology assessments.

Authored technical documents summarizing delivered work.

EDUCATION Bachelor Degree, Computer Science, University of Kansas.

EXPERIENCE

Hardware: IBM and compatible mainframes, Windows-based PCs, Teradata

Operating Systems: MVS/XA/ESA/ZOS, VM/ESA/ZVM, Windows

Mainframe Software: SAP, SQL, TSO, ISPF, SMF, SAS, MICS, MXG, OMEGAMON, REXX, NOMAD

PC Software: Microsoft Office 365, Microsoft Project, Outlook, Zoom, Skype, NINTEX, WinShuttle, Power BI

Key Words: Agile, Methodology, Framework, Scrum Master, Kanban, Scrum, Analytics, Metrics, Dashboard, PI Planning, Power Apps, Workflow, Forms,



Contact this candidate