Michael K. O’Malley Mobile 913 972-4587
Email: [email protected]
SUMMARY
• Michael is an Information Systems professional with over 27 years experience in systems analysis, architecture and application development.
• He has excelled as a Data Architect, Data Modeler, Business Analyst, Project Lead, Data Analyst and Information Architect.
• Communications experience including analysis, management liaison, facilitator, mentor and educator. TECHNICAL QUALIFICATIONS
Data Architecture, Data Analysis, Data Modeling, Data Warehouse/Data Mart/ Data Store Analysis and System Design, Dimensional Modeling, Star Scheme design, SOA, CASE Tools (ERwin 7.1, ModelMart, Power Designer, Oracle Designer, Bachman), Business Intelligence (Business Objects, Cognos, Hyperion Essbase)
Netezza, Oracle 10G, SQLServer, DB2, UDB, Teradata, Windows NT/9x, Unix, HTML, XML, UML, PL/SQL, J2EE, Rational Unified Process, Microsoft Office Products, Visio, Toad, Access
PROFESSIONAL EXPERIENCE
Client: Marriott Vacation Clubs International Data Architect
February 2008 – Current Prophecy Project
• Responsible for reviewing MVCI’s current Data Warehouse and developing an architectural analysis of current state and future state.
• Published future state Data Architecture blueprint and recommendations. Presented the recommendations to the CIO and IT VP’s.
• Develop a plan for migrating the existing Oracle Data Warehouse to Netezza.
• Developed a plan for designing a new Operational Data Store the will be designed and implemented in Netezza.
• Created a Enterprise Conceptual Data Model and presented to the executive steering committee. • Created a plan for developing an Enterprise Data Warehouse.
• Acted as the Data Modeler developing the Dimensional Data Model. H&R Block
Data Architect
February 2007 – January 2008
Data Architect for all Tax Lines of Business
• Developed Master Data Management Strategy and three year plan for implementation. Responsible for managing Data Integrity, Data Quality,
• Developed Customer Data Integration Strategy to provide single view of the customer to all lines of business.
• Developed Strategy, guidelines and plan for a new Business Intelligence environment.
• Work with Application and Infrastructure Architects to develop a Service Oriented Architecture (SOA) • Helped develop the acquisition plan and cost justification for purchasing a Netezza network appliance to
support the Business Intelligence environment.
• Developed strategy to migrate the existing data warehouse from AS400 DB2 to Netezza NPS.
• Designed Architecture and worked with the data modeler to develop the Netezza database scheme to store Emerald Card transactions for detail analysis.
• Review Architecture, plan and design for all data impacting applications and enhancements. • Member for the Architecture and Governance Board responsible for maintaining the enterprise
technology stack.
• Developed Data Standards and Technology stack. Sprint Nextel Corp
Data Analyst
March 2006 - January 2007 Project: Revenue DWBI
• Design a new data warehouse environment to support combined subscriber, revenue and financial reporting. This new data warehouse environment will integrate financial and revenue data from Sprint Billing System and Nextel’s Billing System into a common reporting environment. This is a multi-phase project with data base structures being designed and implemented in Teradata and Oracle 9i.
• Support existing Nextel Data Warehouse and Operational Data Store which operate in the Oracle 9i environment.
• Lead JAD modeling sessions with Business users, application development, and OLAP reporting teams to develop Logical and Physical data models.
• Create and maintain a fully attributed data model in ERwin.
• Design and document new tables need to support the reporting requirements.
• Produced a source to target attribute level data mapping cross reference document • Work with the DBA on the first cut physical design of the new tables.
Client: Sprint Nextel Corp Conversion Solutions Architect December 2005 – February 2006 Project: Cable Provisioning Systems
• Analyzed existing application systems and documenting the conversion requirements to migrate existing cable customer information into the new cable provisioning system (M6).
• Completed the Application Design Document.
• Presented the ADD and gained approval for moving into the design phase. Client: Yellow Roadway Corp
Data Modeler
August 2004 – November 2005 Project: Corporate system integration
• Designed a new DB2 database that supports historical Line haul data from Yellow and Roadway as well as new combined functionality.
• Conducted JAD Data modeling sessions with business and development teams to gather data requirements for developing the Logical Data Model.
• Conducted Process Modeling sessions with business and development teams to understand the process to validate the Logical Data Model.
• Created a Logical Data Model(LDM) of the Yellow Line haul process in the IE methodology using Erwin. • Created Process Flow Diagram for the Trailer Movement process.
• Worked with Application Architect to map source elements stored in DB2 and VSAM files to the entities and attributes in the LDM.
• Worked with another Data Analyst to merge the Logical model from Roadway with the logical model that he created for Yellow.
• Worked with the development team to understand requirements of a new front end system and ensured that the new database supported it.
• Generated first cut Physical Data Model (PDM) and DDL for DB2 implementation.
• Working with Business Intelligence team to design Business Object Universes for reporting and analysis of Load patterns.
Client: Sprint Corp Data Architect
April 2004 – August 2004 Project: Siebel implementation
• Participated in functional requirement sessions for customer and product areas. • Participated in system requirement sessions for customer and product areas. • Created Logical Data Model for Siebel product area.
• Created Physical Data Model for Siebel product area.
• Assisted in data mapping from P2K source billing system to Siebel Customer Application Data Store (ADS). Client: HR Block
Data Warehouse Architect February 2004 – March 2004 Project: Tax Data Warehouse & ODS
• Interviewed Business Subject Area Experts to create Conceptual Model of existing business. • Created Logical Model for planned Operational Data Store.
• Mapped attributes from source systems to logical Data Model. • Implemented new standard naming convention for tables and attributes. • Project delayed due to funding considerations.
Client: Sprint Local Telephone (non Embarq) Data Warehouse Architect
February 2003 – January 2004 Project: Network Data Mart
• Designed/Modeled data warehouse for network applications – 76 tables.
• Designed/Modeled data mart for reporting of network topology and capacity – 30 tables. • Dimensional Modeling and Star Scheme design.
• Mapped data and structures from multiple systems into data mart – 2 systems/300 elements.
• Designed data mart population system using ETL (Ab Initio) and native database replication functionality • Worked with Developers on application design and verifying business rules and logic.
• Coded and tested database replication portion of data mart population system – 30+ materialized views, functions and standard views.
• Working with Business Intelligence team to design Hyperion Essbase Cubes for network reporting and analysis.
• Performance tuning SQL.
• Performance tuning data mart system and client reports. • The data mart was implemented in Oracle 9i.
Client: Sprint PCS Data Analyst
December 2001 – January 2003 Project: Billing system conversion
• Designed/Modeled new tables to facilitate the movement and conversion of data from the old Convergys Billing system to the new Amdocs Ensemble Billing system – 20 tables.
• Researched and documented enhancements required for data storage and data transportation/ transmission in regards to highly secured (credit card, tax identification, bank account) information.
• Trained and mentored new associates in requirements gathering, data modeling and normalization. Reverse engineering of Amdocs Renaissance Oracle 8i databases using Power Designer. Compare results with data model of business requirements.
• Produced logical data model of 3rd generation voice/data product requirements and logical data model of available vendor packages.
• Managed database changes from Data Model to DDL generation to database implementation. • Mapped data and structures from multiple systems into data mart – 1 system/800 elements.
• Worked with business users and business analysts on understanding the requirements of the new system and defining the conversion rules.
• Wrote SQL to research data integrity issues within the source system. • SQL Query performance tuning.
Client: Sprint PCS
Data Analyst / Business Analyst July 2000 – December 2002
Project: Call detail record data warehouse
• Designed/Modeled star scheme structures to allow fast, easy reporting of Call Detail Record data. • Created a data dictionary for all attributes in the CDR-Archive.
• Worked with business users and business analysts to understand, document and design data structures and processes to the handle new reporting requirements.
• Developed ETL mapping and process specs.
• Worked with ETL developers to ensure that the data was loaded properly.
• Mapped data and structures from multiple systems into Data Mart – 4 system/200 elements. • Database and query performance tuning.
• This warehouse processes over 200 million call detail records a day and is one of the largest warehouses in the United States.
• Designed and created new tables to store 3G (IPDR) records. • The data warehouse was implemented in DB2 UDB.
• Continued to support CDR-Archive, while working on the Billing System Conversion. Client: Sprint PCS
Data Analyst / Business Analyst June 1999 – June 2000
Project: Activity based management data mart
• Lead JAD Sessions with functional Subject Area experts to gather reporting requirements. • Created dimensional matrix to identify and document market facing dimensions.
• Designed/Modeled star scheme structures to allow fast, easy reporting of activity units by dimensions. • Mapped data and structures from multiple systems into Data Mart – 4 system/200+ elements.
• Translated the business requirements of dimensional activity units into Logical and Physical data model. • Developed ETL mapping and process specs.
• Worked with ETL developers to ensure that the data was loaded properly.
• Worked with DBAs and Report Developers on query and database performance tuning. • Data mart was created in Oracle DBMS. Source databases were Oracle and UDB.
• Working with Business Intelligence team to design Hyperion Essbase Cubes for reporting and analysis of Cost based activity.
Client: Sprint PCS Data Warehouse Architect October 1998 - June 1999
Project: Financial data mart performance
• Created CRUD (ISUD) matrix from user queries. 100+ queries analyzed.
• Redesigned data warehouse to allow data to be stored at a lower of granularity than originally planned. 10 fact tables.
• Developed ETL mapping and process specs.
• Worked with ETL developers to ensure that the data was loaded properly. • Query performance tuning using SQLLAB and SQL explain plan – 80+ queries.
Client: United Missouri Bank Senior Data Modeler
May 1998 - October 1998 Project: Enterprise data warehouse
• Mapped data and structures from multiple systems into vendor purchased data warehouse from Fiserv • 12 system/200+ elements.
• Lead JAD sessions with retail banking business users and development staff. • Maintained Data Model and produced DDL for database changes.
• High visibility project.
• Met with Vice President of ISD on a weekly basis to keep him informed of progress. • SQL Query performance tuning.
Client: Sprint PCS Data Warehouse Architect July 1997- April 1998
Project: PeopleSoft data warehouse
• Designed a data warehouse database of PeopleSoft financial information.
• Designed Star-Scheme model to store General Ledger information in a report friendly format. • Create Dimensional Matrix and Dimensional Model.
• Mapped data and structures from PeopleSoft financial into the new data warehouse. • 1 system/100+ elements.
• Designed transformation rules and logic for loading the data warehouse. Client: Sprint PCS
Data Warehouse Architect August 1996 - June 1997
Project: Marketing & Finance data warehouse
• Designed the architecture to build marketing and finance data warehouse.
• Designed Star-Scheme model to store Dimension information in a report friendly format. • Created Dimensional Matrix and Dimensional Model
• Mapped data and structures from Convergys P2K billing system into the new data warehouse. • 1 system/100+ elements.
• Designed transformation rules and logic for loading the data warehouse. • SQL query performance tuning
Client: Hoechst Marion Roussel February 1993 – July 1996
Project: Strategic data warehouse; Data Warehouse Architect (July 1995 - July 1996 ) • Designed the architecture to build a product marketing data warehouse.
• Designed Star-Scheme model to store Dimension information in a report friendly format. • Created Dimensional Matrix and Dimensional Model.
• First year estimate was this warehouse would grow to 500 GB in its first year. • Mapped data and structures from source system into the new data warehouse. • 1 system/75+ elements.
• Designed transformation rules and logic for loading the data warehouse. • SQL query performance tuning
Project: USBR; Oracle Performance Tuning (March 1995 - July 1995) • SQL Query performance tuning
Senior Data Modeler (January 1994 - March 1995)
• Designed the architecture for the areas of planning, benefits & values, samples, account management, contracting, and performance measurement.
• Conducted JAD sessions with Business Users.
• Created Conceptual, Logical and Physical Data Models using Bachman toolset. • Designed Star-Scheme model to store Dimension information in a report friendly format. • Mapping data and structures from source system into the new data warehouse
• 3 system/3 different DBMS/300+ elements.
Project: Marion Merrill Dow ICON; Senior Data Modeler (February 1993 - January 1994) • Designed the architecture for the areas of Integrated Contracts project.
• Led team of two other Data Analysts. • Conducted JAD sessions with business users.
• Created conceptual, Logical and Physical Data Models using Bachman toolset. IBM Services
Data Administration Supervisor January 1991 - January 1993 Project: Santa Fe Railroad FAST
• Led team of five Data Analysts.
• Developed Logical Data Model consisting of 300+ entities. • Lead Data Modeler.
• Conducted JAD Sessions.
IBM Marketing and Services DB2 Specialist 08/1989 – 01/1991
United Telecom DB2 Database Analyst (Local Telephone App) 11/1987 – 08/1989 Yellow Freight Systems Systems Analyst (Transportation App) 12/1986 – 11/1987 Citibank Data Service Programmer Analyst (Credit Card App) 06/1985 – 11/1986 United States Marine Corps Programmer Analyst (Payroll App) 06/ 1980 – 06/1985 EDUCATION & TRAINING
AS, Data Processing Longview CC June 1985
Oracle 8i New feature training March 1999
Oracle 8 New feature training February 1999 Charter member Data Warehousing Institute
The Data Warehouse Institute Conference (TDWI) January 1997 Data Warehouse Conference (DCI) November 1994 Member Kansas City Oracle Users Group
