Data Professional
Certified Oracle Master
Member: DAMA; IAIDQ
I have 20+ years in IT as a Developer and a Data Professional, including:
• Database Administrator
• Data Architect
• Database Architect
• Data Warehouse Architect
• Data Modeler
• Data Security
• Data Analyst
• Data Governance,
Data Architect – 6 years
At this company, I built a team of 4 specialists to handle the various aspects
of a Data Management area of expertise including: one SQL Server Operations DBA,
one SQL Server Data Warehouse DBA, one Development DBA / Data Modeler, one Data
Analyst, and myself to do everything else.
I implemented a ‘Transactions’ Data Mart to enable the complete revamp of the
billing philosophy in three months. This gave the company visibility into the
number of transactions that our clients were transmitting over our network, so
that we could bill them accordingly. Management had never had such visibility
prior to this. This increased our bottom line by 19%. While doing this, I
uncovered several data anomalies that had the potential to cause financial,
legal, and regulatory problems, and addressed them.
I implemented a cadre of security initiatives to improve the security of the
database environment.
I began educating the developers on good coding practices vs. bad coding
practices. I also created standards for database naming, database coding,
architecture and modeling. I implemented ER/Studio as our data modeling tool and
repository and mentored the DBAs on Branching, Merging, tagging, etc. of model
versions within the tool so that we now have a versioned model. All of this
serves to lay the foundation necessary for a Data Management practice.
I have created a roadmap document to move the company toward a complete Data
Management practice, documenting both the Functional and Organizational aspect.
I’ve begun informal talks with senior executives regarding the value of our data
and the methods by which we should be managing it. I’ve identified several
likely candidates for Data Stewards and am inserting ‘Data Governance’, ‘Data
Stewardship’ and ‘Data Ownership’ into the conversations so that they become
used to the idea and, ideally, will begin discussing it amongst themselves. I am
familiarizing the staff with the ideas that they ‘product’ and ‘consume’ data and
need to work with the people who, in turn, ‘produce’ and ‘consume’ their data to
strengthen the data quality and availability for the enterprise.
I was originally hired as the Database Architect and the senior member of the
Database Team for this company. I had a great enough impact on the efficiency
and effectiveness of IT that I was promoted after @6 months. In my original
role, I implemented Database Change Control that provides review of any and all
code that ran against the database. Previously only DDL was reviewed. In the
first week of review we saved @2 years worth of CPU by showing the Developers
what their code was doing and helping them fix it. Several Processes that never
completed in the past now ran in minutes. I built consensus among the Managers
and personnel of the Development group and the QA group to implement these
practices by showing them how they would benefit. When I mentored the developers
on Explain Plans and wrote scripts that would capture performance statistics for
them, and for the QA teams, we were able to identify and resolve many performance
issues related to application coding.
The databases had not been upgraded or patched in 3 years. I explained the
advantages of upgrading, and the security implications of not upgrading, to
management and got consensus to upgrade the databases. I put together a project
plan and justification for upgrading from 9.2.0.5 to 11.2. That project was
executed by another Senior Oracle DBA in the summer of 2010. I built the testing
environment and mentored the other DBAs on Oracle 11g functionality.
I uncovered evidence that our production databases were being hacked. The VP of
Operations performed a full Security Analysis of our systems and new security
measures were implemented in April of 2010.
In my role as Manager of Enterprise Data Architecture, I mentored the other
members of a Reporting and Analytics team that had been trying to implement some
form of a Data Mart for three years. My team built the ETL processes and Data
Warehouse Data Model based on the Business Requirements, and populated the first
production schema in three months. The Operational source is Oracle. The target
environment is Sybase IQ, Cognos, IBM Datastage and Sybase Powerdesigner. This
project was recognized by Information Week as one of the Top-100 IT Projects of
2009.
I designed a Corporate Information Factory including an Operational Data Store,
Data Warehouse, and Data Marts. The ODS will be implemented in Oracle and
populated in Near-Real-Time by Oracle Goldengate and Microsoft SSIS.
This department is a new concept for this Corporation. I am creating the
internal market for this department from the ground up, building consensus among
the department managers by explaining the benefits that Data Quality and a
re-factored, sane Data Model can provide. I am implementing the processes and
personnel needed to implement the base structure necessary for Data Management
and have begun broaching the subjects of Data Stewardship and Data Governance.
I modeled and implemented the extensive changes to our Data Model that are
required to implement a Federally mandated change to the way Pharmacy Medicare
Part D claims are handled electronically. This is a multi-year effort.
At this consulting firm, as Data Architect for an SCHIP (State Children’s Health
Insurance Program) development effort I worked with Developers, Business
Analysts, and Project Managers to discover new data requirements and implement
them in the most optimal way. The role included providing Conceptual Models for
the Business Requirements Documents, Logical Models for the Functional
Requirements Documents, and Physical Models for the Technical Specifications
Documents, and writing the scripts to migrate the data model and data, when
applicable.
Oracle DBA (Certified Oracle Master) – 13 years
I worked for two corporations that provide remote support for client’s Oracle
databases. I handled the largest clients for each corporation. I mentored the
other DBAs on Oracle Internals, Advanced Queuing, Streams, Advanced Replication,
Data Guard, Data Warehousing, and RAC.
I worked for HP () as a contract RAC resource, supporting a testing environment
consisting of over a dozen Tru64, 3 node clusters, many of over a terabyte in
size.
I designed and implemented an Oracle Streams data archival process for the Mayo
Clinic’s () Specimen Tracking System to offload all but the most recent 45 days
of data to a data warehouse instance. While doing this I identified and applied
multiple Operating System and Oracle upgrades to their production environment. I
also developed PL/SQL to delete the old information from the production instance.
The PL/SQL procedure mimicked the referential constraints that were entirely
contained in the application. The package runs in 5 minutes, replacing the
client’s script that took 18 hours. I instructed the client on the use of
Transportable Tablespaces, reducing their export / import time from 6 hours to 6
minutes.
As the lead DBA and Technical Architect for Halliburton’s Data Warehousing Group
in Houston, TX (), I completed an upgrade of all instances from 8.1.7 to 9.0.1,
and migrated our 9iAS instances off their corresponding database servers where
they co-existed with the database, to their own servers. I implemented
Partitioning for extremely large tables and introduced monitoring via Oracle’s
Enterprise Manager and Performance Manager. I designed the new environment of
RAC, Linux, Intel and Network Appliance SAN. When I delivered presentations on
the RAC / Linux / Intel architecture to upper management it resulted in
Halliburton’s adoption of the architecture as a company directive. Our part of
the business was the first to implement this architecture and the resulting
environment has been featured in Oracle Magazine. The environment is a complex
combination of Data Warehouse, ODS, OLTP and Data Marts all in one instance. As
part of the redesign for RAC I have broken up the applications and data feeds to
separate the Data Marts into two instances, the Data Warehouse into two
additional instances, the OLTP into a third set of two, with a fourth set for ETL
processing. I also designed an enterprise for the future where the data feeds
are live and accomplished via Advanced Queuing and CDC / Streams for a Near Zero
Latency Data Warehouse.
As the Production DBA for ‘Enron Online’(), the world’s largest ecommerce site
at a Fortune 7 company, I bore primary responsibility for a system of production
instances including a demanding 1.2 Terabyte, 24 x 7, OLTP production instance on
Solaris 6800 servers with T3 disk arrays. I brought to bear unique Oracle
analytical experience, working with the Vice President of the division to
identify and help him to understand a long standing deadlock issue.
As a Senior Technical Analyst for Oracle Corporation I managed a team 5 - 12
people, mentoring them on Oracle functionality. Areas of specialization included
Advanced Replication, Tuning, Advanced Queuing, and Dump Analysis.
Developer – 11 years
I operated as a consultant for various agencies at numerous client sites in
roles ranging from a Cobol programmer for the largest project ever undertaken at
St. Luke’s Episcopal Hospital in Houston, TX to a Visual Basic developer at a
small software development company in Colorado Springs, CO, to an Implementation
Manager for an very large and complex project at One Shell Plaza in downtown
Houston, TX.
|
