Data Quality Assurance

RESUME OF EXPERIENCE, TRAINING, AND PUBLICATIONS

Oracle DBA 04/14/2016

KENNETH C. HUGHES

Home: 253-***-**** -- Cell: 206-***-****

E-Mail: ********@*****.***

Web Site: www.kennethchughes.com

LinkedIn: http://www.linkedin.com/in/hugheskc

Experience: 20+ Years Oracle versions: 5.2,6,7,8i,9i,10G,11G,12C

Visa Status: U.S. Citizen Travel: Ready, Willing, & Able

PROFESSIONAL PROFILE .

• A vast amount of experience as a Data professional working for government agencies (US, State, and local), banks, fortune 50 companies, health care, Telecom, and small start-ups

• A professional who demonstrates a commitment to ensuring client success and satisfaction

• Clear concise planning and excellent analytical abilities

PROFESSIONAL SKILLS .

• Managed Dev, test, & Production VLDB, OLTP, & Real Time databases

• Installed, and managed Oracle high availability Data Guard (10G & 11G)

• Proactive Oracle infrastructure and capacity planning, Database

• Performed upgrades & patching, SQL and index tuning

• Data modeler modeling and designing VLDB, OLTP, & Real Time databases

• Oracle Certified Professional trainer for OCP classes at Bellevue College

TECHNICAL SKILLS SUMMARY .

• Methodologies: SCRUM, AGILE, Water Fall, IDEF, Martin Crows foot

• Oracle Tools: RMAN, Data Guard, Golden gate, Partitioned tables, Materialized views, Data Pump

• Applications: Toad for DBA's, TOAD Data Modeler, Erwin, Database Examiner, Visio, Unica, File Maker

• Languages: SQL, PL/SQL, Linux Shell, Windows batch file scripting

• Databases: Oracle versions: 5.2, 7, 8i, 9i, 10G, 11G, 12C & SQL Server 2008, virtual Oracle databases

• Operating Systems: LINUX (Red Hat, Oracle Linux, Centos), SOLARIS, Windows, Virtual servers, VmWare

• Capabilities: Database Administration (Dev, Test, Production), physical database design, Database Quality Assurance, best practices, Health checks, PCI and PII database security.

PUBLICATIONS, PRESENTATIONS, AND USER GROUPS .

• Founding Member of Puget Sound Oracle Users Group

• Lectured on “Designing a High Security Database” at the “Computers and Technology Showcase” convention

• Wrote book on International Finance published in 32 countries

• Investment author for two newsletters "Dollars and $ence" and "Investors Exchange" published internationally

• Authored many technical documents such as Data Guard installation, Database upgrading, RMAN backup

and recovery, and Database Cloning

AWARDS .

• Concert Inc., MCI, and British Telecom were awarded "Best Practices in the United States" from the Data Warehousing Institute (www.dw-institute.com) as a direct result of my data cleansing quality assurance & ETL processing re-design contribution to Concert's Financial Data Warehouse.

EDUCATION .

• University of Washing Certified Oracle Applications Developer (2008)

Program covers Oracle database administration, Database backup and recovery (RMAN, Data Pump, Cloning, Data Guard), SQL and PL/SQL.

• Oracle 11G Certified Associate (OCA) (2016)

• Oracle 9i Certified Professional (OCP) (2003)

• Oracle 7 Certified "Master of Database Administration" (1997)

• Computer Learning Center “Information Systems Programmer/Analyst”, Honors Graduate (1988)

CAREER EXPERIENCE . .

Oracle DBA – Trios Health (Consultant Pixileum LLC) 8/2014 to 4/14/2016

Technical Environment: Oracle 11G, RMAN, PL/SQL, Windows batch file scripting .

• Audited production and test databases for backup/recovery and database performance on Microsoft Windows Server 2008 R2. Performed database RMAN and Data Pump backups and resolved production issues. Cloned, patched, and up graded databases in Production, Test, and Reporting. Wrote and tuned PL/SQL procedures. Wrote batch files to monitor database availability, perform RMAN and Data Pump backups, Version and delete Database backup files.

• Performed database quality evaluations for:

Adherence to Data Quality standards

Identification of data relationships and potential data integrity issues

Interface with other enterprise databases

Conform to Corporate Data retention polices Legal, Business, and Analytics

Marketing Data Modeler – Nordstrom (Consultant) 8/2014 to 11/2014

Technical Environment: Oracle 11G&s12G, Toad Modeler, Visio professional .

• Logical and Physical Data modeler and database designer of the Marketing Operational Data Store (MODS) database. Created logical ERD’s, record layout proof of concepts, and MODS data dictionary including Source to Target mapping. Worked with stake holders to define the way Nordstrom uses marketing terms across marketing teams and Marketing channels.

• Unica and File Maker analyst. Developed File maker programs and databases. Developed strategic plan for marketing Customer Life Cycle and touch point management. Created Unica flow charts for email trigger campaigns.

• Used CASE tool Toad Modeler and Database Examiner for reverse engineering, comparing database physical models against the actual database design, and for reviewing application and database functionality with end users.

• Data Steward & Data Quality Assurance. Performed Data Governance work (Data Quality, Data Retention, and Data definition & value Governance). Responsible for data retention (legal, analytical, operational life cycle management). Documented and organized data quality assurance (best practices, Health checks, Data Quality rules) for business, analytical, legal.

Production DBA\Data Governance\Database Design – VIX Technology 7/2013 to 2/2014

Technical Environment: Oracle 11G&s12G, Data Guard, RMAN, PL/SQL, Solaris & Windows .

• Logical and Physical Data modeler and database designer. Reverse engineered several Databases using Toad Modeler. Worked with stake holders and development staff to create a data dictionary and ERD of several databases to assist with modifying existing application functionality.

• Production/Development DBA. Managed high availability Data Guard databases, Wrote PL/SQL and used Oracle Wallet to maintain security over PCI data, created views to satisfy reporting requirements, Managed RMAN and Data Pump backup, built new databases and recovered crashed databases, used GRID, Spotlight, TOAD, PL/SQL, SQL Work Bench, and SQL Plus for every day monitoring, issue resolution, and maintenance.

• Data Governance/Database design. Identified data lineage from application front end code via middle tier pl/sql code to database back end schemas and objects. Reverse engineered databases and created ERD’s that identify relationships, and subject areas each table/column affects. Created a data dictionary organized by subject area domains with lineage and physical design characteristics.

Production DBA -- SNBL Inc. (short term Consultant) 2/2013 to 6/2013

Technical Environment: Oracle 11G, RMAN, PL/SQL, Windows batch file scripting .

• Audited production and test databases for backup/recovery and database performance on Microsoft Windows Server 2008 R2. Performed database RMAN and Data Pump backups and resolved production issues. Wrote and tuned PL/SQL procedures. Wrote batch files to monitor database availability, perform RMAN and Data Pump backups, Version and delete Database backup files.

Production DBA -- Cambia Health (Consultant) 9/2012 to 1/2013

Technical Environment: Oracle 10G/11G, Data Guard, TAF & FSF, Toad for DBA's, Linux Shell scripting .

• Installed, configured, patched, and upgraded database versions 10.2 and 11.2. on 10 databases. Installed Data Guard and TAF (Transparent Application Fail over) and FSF (Fast Start Fail over) on two databases. Performed RMAN backups, recoveries, and cloning on five databases, upgraded the database time zone version on 10 databases.

Database Developer -- Fulcrum Technologies 2/2012 to 6/2012

Technical Environment: PL/SQL, Oracle 11G, Toad for DBA's, SQL Developer, Linux Shell scripting .

• Supported Fulcrum's largest customer AT&T with PL/SQL development.

Production DBA -- Boeing Migration Factory group (Consultant) 8/2011 to 2/2012

Technical Environment: MS Office Suite, Oracle v.11.2, PL/SQL, Unix shell scripts, CASE tool Toad Modeler,

Oracle 11G, Oracle RAC & Golden Gate, Toad for DBA's on LINUX and HPUX .

• We moved 42 databases from all over the United States to three service centers in Seattle, Phoenix, and St. Louis in RAC/Linux and Service Guard/HPUX environments.

• Worked with Golden Gate and Data Guard to build mission critical 24/7 databases and dramatically reduce down time while maintaining current data replication from the legacy database to the new target database.

• Authored a Migration Factory Staffing Plan for the project MGR.

• Project saved Boeing 4 $million during the first 9 months with less than 150 databases moved.

Database Designer/Administrator -- TWEDDLE Group (Consultant) 01/2011 - 08/2011

.

Technical Environment: Oracle 11G, PL/SQL, shell scripts, Toad Modeler, Database Examiner, Toad for DBA's . .

• Lead Oracle Development DBA and database designer of the first application of its kind to allow Toyota and Lexus automobiles to communicate with the WWW via a smart phone. Entune is a Real Time processing application that enables occupants of the car to do things like make restaurant reservation, reserve parking spots at a garage before arrival. Get real time stock quotes etc.

Data Governance/Database design.

• Designed four databases to support Real Time interaction between the Car and the WWW, historic tracking of user activity, applications content management, and an analytical database for providing Business Intelligence.

• Used CASE tool Toad Modeler and Database Examiner for reverse engineering, comparing database physical models against the actual database design, and for reviewing application and database functionality with end users.

• Worked with end users and corporate executives to identify business processes and application requirements that could be part of a logical ERD and physical ERD.

Production/Development DBA.

• Wrote Shell scripts and SQL scripts for building the entire database including table spaces, schemas, tables, grants etc.

• Wrote Unix shell scripts for proactive DB Health monitoring, import/export (Data pump).

• Authored/co-authored Production and Development standard operational procedures to ensure the confidentiality, integrity, and availability of the corporate data asset.

• Conducted database DDL and DCL code reviews. Assisted management with development of SDLC procedures and entrance and exit criteria.

Data Steward & Data Quality Assurance -- Capital One (Consultant) 08/2010 – 12/2010

Technical Environment: SQL server, Oracle, Teradata, PL/SQL, Ab-Initio, Linux, MS Excel, Visio . .

• Performed Data Governance work (Data Quality, Data Retention, and Data definition & value Governance).

• Worked with production DBA's to establish data quality assurance processes and data quality dash boards related to ETL between production database and analytical databases.

• Performed Source-to-Target data mapping from production ->legacy analytical->additional analytical->data marts/reporting.

• Responsible for data retention (legal, analytical, operational life cycle management).

• Obtained, organized, and defined subject area Meta Data in applicable repositories (Ab-Initio, SQL Server, and Oracle).

• Documented and organized data quality assurance (best practices, Health checks, Data Quality rules) for business, analytical, legal.

• Performed JAD session information identification & subject area segmentation to obtain high quality data for financial analytics, SOX, PII governance, and production/operations forecasting and management.

Team Lead/Senior Oracle DBA -- "The Oracle Club" Study Group 04/2009 - 07/2010

Technical Environment: Oracle 10G&11G, Data Guard, shell scripts, Linux, Centos, Virtual servers, RMAN .

• Lead team of six IT professionals. Installed Oracle 11G Enterprise GRID with Data Guard, RMAN repository, and three "production databases" on nine virtual Oracle Linux servers running on a Centos and Windows 64 bit servers.

Team Lead/Senior Oracle DBA -- Seattle City Light 07/2007 – 03/2009

Technical Environment: Oracle 10G&11G, shell scripts, Linux, Solaris, AIX, RMAN .

• Led a new team of six DBA’s in a business environment recently converted from vertical silos to a matrix organization.

• Responsible over 60 production databases used for billing, customer records, disaster management, electrical power management, enterprise resource management, weather tracking and prediction etc.

• Implemented policies for Oracle DBA roles and responsibilities, primary & backup database support responsibilities, working from home policy, and for Vendor/Contractor management.

• Implemented plans and procedures for Emergency response, Backup and recovery.

• Responsible for Oracle DBA cross training skill assessment and training plans.

• Enterprise Data Governance committee member. Assessed and developed long-term strategic Data Governance goals, Data Quality Assurance processes, Data Retention Life Cycle policy, Data Steward responsibility points within the data retention Life Cycle, and Data Security policy.

• Used RMAN and data pump for backing up databases.

• Used Erwin for designing databases.

• Performed Oracle database cloning and migration, used data pump, RMAN, and Data Guard.

Team Lead/Senior Oracle DBA -- Kent School District 01/2004 – 05/2007

Technical Environment: MS Office Suite, Oracle (v.8, 10G, & 11G), Unix shell scripts, Solaris, RMAN .

• Supported a suite of applications used by over 3,000 staff members, 27,000 students, and 30,000 parents. Average concurrent sessions were between 500 and 700 Concurrent users on HP True 64 UNIX and windows 2003 servers.

• Led a team of two Senior Oracle Database Administrators, one Contract Oracle Database Administrator and two Junior Oracle Database Administrators.

• Responsible for Oracle Database Real Time performance monitoring, database troubleshooting & tuning, Vendor/Contractor management, database emergency response/Disaster Recovery (DR), and performed on call and support rotation responsibilities.

• Wrote an Oracle database reporting tool that collected Oracle database information every day and performed trend analysis and change analysis on current data compared to past data with over 50 reports.

• Wrote an Oracle database backup application that Versions Hot and Cold backups, automatically deleted old backups in accordance with a retention policy, and recorded backup information in an Oracle database.

• Performed data migration (ETL) to a replacement application/database using Erwin, SQL and PL/SQL, Data Pump, and Materialized Views. This resulted in a suit of 24/7 applications that had zero unplanned downtime over 12 months.

PRIOR CAREER EXPERIENCE .

Team Lead Enterprise Database Design

-- White House special project "Re-inventing government"

• Responsible for the overall design of database in 6 divisions of the USAID. Audited database design for 6 development teams to ensure information could move from one database into any other database as needed without data changes.

• Served as point of escalation and review/approval for key design issue decisions with regards to enterprise data and information

• Helped pioneer Enterprise Master Data Management, Data Quality Assurance, and Service Oriented Architecture before those terms were industry standards

• Worked with end users and corporate executives to identify business processes that can be part of a process model, Conceptual Model, logical ERD, and then a physical ERD

• Translated enterprise and business requirements into long-term information/data architecture solutions

• Developed, and audited enterprise databases for compliance with master data management, Data Quality Assurance, and Service oriented architecture road maps, best practice guidelines, and standards

• Defined and maintained best practice guidelines and standards for data stewardship, data modeling, database physical design, and DBA operations

• Advised business and technology groups on future technology options, outlining risks, costs, benefits and capabilities

Database Cleansing and Feeder System Architect & DBA Team Lead

-- Concert Inc. (a partnership between British Telecom, MCI, and AT&T).

• Re-Designed the Operational Data Store and Data Cleansing databases for Concert's Financial Data Warehouse.

• Lead Oracle DBA team Development/Production (Team of 3 DBA’s) for Concert's Financial Data Warehouse, Operational Data Store, and Data Mart databases.

• This database system won the “Best Practices Award for 1997” from the Data Warehousing Institute. Saved over 50 million dollars in lost revenue through more accurate customer billing.

Dev Team Lead -- Perot Systems

• Team Lead (myself, one DBA, one Data Modeler, and one business analyst) created a physical model, built, and was the production DBA for a database that received over 30 million Call Detail Records loaded into it every week. The application and database provided efficient and secure access to over 20 billion Call Detail Records for AT&T, Bell South, and Sprint customer billing on the east coast of the United States.

Development/Production DBA -- United States Postal Service (USPS)

• Used Erwin to create and convert Logical designs into a Physical Database design to satisfy production mail-forwarding requirements for use in 250 mail processing facilities. Senior Database Administrator for 15 Dev, QA, and Test databases. Senior production DBA for databases in Cincinnati OH, Frederick MD, Reston VA, and Sacramento CA. This “Real Time” application was estimated to exceed four $million dollars in savings per year.

Contact this candidate