SUMMARY:

Data architect / Data modeler with an extensive IT management, Project Management, modeling, DBA, programming and real - time background. Diverse experience having worked in the full range of business sizes and many industries. Special strengths include distributed databases, strategic planning, data and application architecture, database design, production process automation, performance problem resolution.

PROFESSIONAL EXPERIENCE:

Data Modeler

Confidential, Houston

Responsibilities:

• Having fun helping design a new Enterprise Data Model (and influence governance) for an ODS in an EDW, MDM, SAP / BW environment with a great group of people with all the normal flash points.
• Primary focus on standards for learn-ability and expandability in an attempt to maximize the lifespan and value of the model.

Confidential

Data Architect

Responsibilities:

• Responsible for the modeling for the Operational data store driving the Customer Centric Database, several of the main reporting schemata and for modeling standards.
• Databases run mainly on Netezza with MicroStrategy as the main reporting tool and an Oracle database as the interface with the Enterprise Service Bus.
• Worked to improve the development process and governance.

Confidential

Data Modeler

Responsibilities:

• Designed and built a Customer Focused Growth decision support system enabling revenue reporting by customer, service and salesman in addition to the dimensions that were already available for sub-sets of the data through other systems.
• Integrated data into the Operational Data Store from eight different invoice systems (20 systems in total) from three different companies to provide a consistent view of the data.

Confidential, Houston

Data Modeler

Responsibilities:

• With one other modeler, developed Enterprise data model for Operational data store and warehouse from scratch; going live on three reporting schemata and one operational schema in seven months.

Confidential, Houston

Data Consultant

Responsibilities:

• Responsible for the Technical data model; covering the primary operational and field technical data of all the main divisions of the company together with the equipment, material, personnel, invoicing and customer data needed in field operations. Worked with groups from every operational business area and geographic location to harmonize the data definitions.
• The result is a self-defining, object oriented, distributed data model underlying all the major field operations, with the field operations still running in ways that are natural in their environment while minimizing duplicate data entry, improving data quality and operational processes, replacing most localized reporting functions and enabling accurate, timely, common reporting of technical operational information across all the divisions and regions for corporate use.
• The OLTP side of the model is about 1600 tables, the DSS side about 100 tables with another 100 tables for ODS use and approximately 1000 additional tables for ETL, control and additional meta-data management. Full meta-data for the databases, instances, schemata, and their data objects as well as data objects for external exchange is maintained within each database as relevant.
• The harmonization and reconciliation of definitions across all the divisions was the most onerous problem; technically the most difficult problem was enabling the data to be distributed across and integrated from, thousands of nodes around the world into some areas with poor or no network connectivity, before tools were commercially available to address the problem. Organizationally, at one time there were 17 concurrent development projects running against the model which was a potential nightmare during which we not merely survived but flourished.
• Responsible for the design, development and maintenance of the model; the design, operation, monitoring and maintenance of the production database environment as well as the provision of databases for the development, test, user trials and training.
• For the data in the production environment I was responsible for the synchronization, quality and reporting on the data over a 5000 node rarely-connected distributed database.
• Improvements in data quality resulting in fewer field mistakes each of which can cost a million or more USD;
• Half normal time from proposal to operation with increased quality;
• Reduced time from operation to invoicing. Automated field capture of customer signature of job approval enabling transition of 6 to 12 week invoicing process into a 6 to 12 day eBiz invoicing processes saving 60 million USD a year in finance charges for one major area of operations.
• Drastically reduced the number of reporting systems used by the field operating units resulting in more consistent management and technical reporting at lower cost.

Confidential, Bellaire, Houston

Data Consultant

Responsibilities:

• Reengineer the report data generation process to be adaptive to data problems and to work incrementally so that report data is made available every hour if requested.
• Led a team of 6; Hand-off day-to-day database support to the production support group. Also (Oracle 10g, RAC, ASM, RMAN, OEM, Packages, PL/SQL, Multi-Terabyte databases, 24x365, Red Hat Linux, EMC SANs, Windows, SQL Server, ErWin, SOX compliance)

Confidential, Bellaire, Houston

Data Consultant

Responsibilities:

• Led a team of 5. Extend OLTP model, data and distributed data model to enable field integration of applications with SAP where connectivity allows.
• Extend reporting schema to cope better with the growing reporting needs and Migrate main databases to Oracle 10g on RAC.
• Formalize report data generation process into standard package structure and rationalize reporting.
• Expanded model to deal with new divisions, regions, processes and applications.
• Migrate to Oracle 10g, RAC, ASM, RMAN, OEM, Packages, PL/SQL, Multi-Terabyte databases, 24x365, Red Hat Linux, EMC SANs, Windows, SQL Server, ErWin)

Confidential, North Belt, Houston

Data Consultant

Responsibilities:

• Led a team of 6. Remodeled reporting schemata to cope with field, district, regional and global management needs.
• Migrated data extraction to take customer, equipment, material, pricing, ticketing and much reference data from the SAP.
• Remodeled data and provided data architecture support to the development team reworking the applications to reflect the change.
• Re-engineered job packet routing, data distribution and data synchronization processes.
• Expanded parallelism of backend processes.
• Started automation of monitoring and recovery of backend processes to improve uptime.
• Continually expanding the ODS model to deal with new divisions, regions, processes, and applications.
• Day-to-day hardware and network support handed over to the relevant production support groups.
• Migrate to Oracle 9i, Packages, Triggers, PL/SQL, 24x365, hot backups, ErWin, Pro-C, SQL, AIX, Red Hat Linux, Korn shell and C-Shell, VB, Windows, MS SQL engine) (Hired domain expert and report writer

Confidential, Highway 6, Houston

Distributed Data Architect

Responsibilities:

• Led a team of 7; Devise data strategy for globally distributed application suite for field operations.
• Set up feeds from third parties to our central server cluster and distribute data to field machines by automated methods where connectivity was available and by sneaker-net for other locations. Expanded model to deal with new divisions, regions, processes and applications.(Migrate to Oracle 8, Triggers, PL/SQL, Oracle Advanced Replication, 24x365, hot backups, ErWin, Pro-C, SQL, AIX, Korn shell and C-Shell, VB, Windows, Jet Engine )
• Advanced Replication done through Oracle Contractors
• Hired Production DBA, trained backup DBAs) (Web tools migrated to Windows and Microsoft tools)

Confidential, Houston

Data Architect, Data Modeler

Responsibilities:

• Led a team that re-worked and expanded Confidential ’s Technical Data model originally developed as part of the POSC initiative from an academic logical model to a practical self-defining, object-supporting physical model on Oracle and Microsoft Access.
• Start to reconcile, clean and load Master data and set up feeds from internal sources to keep the operational data servers up-to-date with the financial, materials, equipment and marketing systems.
• Make data available over intranet. (ErWin, Oracle 7, Triggers, PL/SQL, Pro-C, SQL, AIX, Korn shell and C-Shell, Windows, Jet engine).
• Hired Data modeler, Pro-C programmer, Domain Expert, C++ programmer, Web programmer