SUMMARY:

• 20 years of Information Systems experience with expertise in:
• Database Architecture including Dimensional, Logical, and Physical Data Modeling
• Data Warehousing including Business Intelligence and ETL
• Big Data and Cloud Environments
• Analysis and design conceptual/logical/physical of business systems and information systems
• Planning and working in all phases of complete systems life cycle
• Identifying and prioritizing business requirements
• Installing and monitoring software and systems
• Conducting, mentoring, and leading unit testing, system testing, and user acceptance testing
• 20 years of ORACLE experience
• 16 years of Data Warehousing experience
• 16 years of ETL experience
• 20 years of Master Data Management MDM experience
• 20 years UNIX experience including Linux, Sun Solaris, HP, HP Tru64, IBM AIX
• 14 years IBM Mainframe experience including MVS/ESA, MVS/XA, MVS, VM/SP, VM, DOS/VSE, DOS/VS, DOS, CMS
• Excellent communications skills and team interaction skills
• Top-notch analysis and problem solving skills
• First rate technical skills

SKILLS SUMMARY:

Databases

ORACLE Releases 4, 5, 6, 7, 8, 8i, 9i, 10g, 11g, 12c , MySQL, SQL Server, Sybase, Informix, Teradata, DB2, SQL/DS, FOCUS, RAMIS II, SAS, NOMAD, VSAM, DL/1, DATACOM/DB, IDMS, ADABAS, dBASE, Clipper, FoxPro, MS Access

Languages / Tools

SQL, PL/SQL, Command-level and Batch COBOL, FOCUS, IDEAL, RAMIS II, SAS, NOMAD, FORTRAN, JCL, C, C , Assembler, METHOD/1, ERwin, Oracle Designer, S/Designer, Power Designer, LBMS, PeopleSoft, JD Edwards, Oracle 11 ERP Applications Suite, Oracle Applications Server 9i and 10g , Oracle Enterprise Manager, Oracle RAC, Oracle ASM, Oracle RMAN, Oracle Data Guard, Oracle Advanced Replication, Oracle Streams, Oracle Discoverer, Business Objects, Cognos BI, Micro Strategies, Veritas, HP OpenView, HP PI, ADSM, MS Project, and multiple ETL tools including Informatica, Oracle Warehouse Builder, Cognos, Embarcadero, and Sunopsis

Operating Systems

UNIX Solaris, IBM AIX, Linux, HP, HP Tru64 , NT, Novell, MVS/ESA, MVS/XA, MVS, VM/SP, VM, DOS/VSE, DOS/VS, DOS, CICS, TSO, CMS, Windows XP, Windows 2003, Windows 2000, Windows 98, Windows NT, Windows 95, Windows, Macintosh, OS/2, PC-DOS

PROFESSIONAL EXPERIENCE:

Confidential

present Senior Database Architect / Senior Database Consultant / Senior Database Administrator

• Architect and implement Database Server Environments for Cisco's Network Configuration and Change Management System, including
• analysis, configuration, performance tuning, ETL, and capacity planning on standalone off premise systems, and multiple hosted
• DBaaS Database as a Service systems. Environment includes virtual multi-node, multi-server UCS Blades Servers, utilizing Oracle
• 11g and 12c releases in support of Cloud Computing and Big Data, including high-volume, high-velocity, high-variety data loads.
• Architect and plan the migration of the Austin PNOC Production Data Center from Austin, TX to Allen, TX, including the migration of
• all Oracle 10g Database Servers to 11g, and changing hardware from Sun Sparc to UCS Blades, changing Operating System from Solaris
• to Linux, and new application releases in support of Cloud Computing and Big Data.
• Architect, implement, administrate, and support Oracle DB Systems for HP Openview Applications for FemtoCell project, including
• analysis, configuration, performance tuning, ETL, monitoring, partitioning, capacity planning, User/schema creation, security, backup
• and recovery. Tools utilized include Oracle RMAN, ASM, and Data Guard replication, and writing shell scripts to automate processes.
• Support and develop complex data selections and BI-type reports, including performance tuning of SQL processes. Environment on
• multi-node, multi-server Solaris and Linux systems connecting to high-volume, high-velocity Oracle 10g and 11g Database Servers.

Confidential

Senior Database Consultant

• Provided guidance, mentoring, and advice on issues related to their Database environment, especially Best Practices / industry trends.
• Resolved corrupt data issues in production and test Oracle Database Systems. Resolution included analysis, design, configuration,
• trouble-shooting, performance tuning, security evaluations, and adjustments. Wrote DB Health Check/Evaluation White Paper.
• Environment was on multi-node multi-server Unix systems connecting to Solaris and Linux Database Servers.

Confidential

Senior Database Consultant

• Designed, configured, and implemented Data Replication among Oracle Databases in the Dominican Republic Miami via Data Guard.
• Environment was on multi-node, multi-server LAN systems connecting to Microsoft Operating Systems Oracle Database Servers.

Confidential

Senior Database Administrator / Senior Consultant

• Administrated and supported 20 Clustered Oracle Database Warehouses. Administration of these clustered production test systems
• included analysis, design, configuration, implementation, monitoring, partitioning, User and schema creation, security, and backups
• and recovery. Supported development of complex Big Data queries and reports, including performance tuning SQL and processes.
• Environment was on multi-node, multi-server Unix systems connecting to Solaris and Linux clustered Database Servers.

Confidential

Senior Database Administrator / Senior Consultant

• Designed, administrated, and supported Oracle Data Warehouse Systems, including database analysis, design, configuration,
• implementation, monitoring, partitioning, User and schema creation, security, and backups and recovery. Supported development
• of complex Informatica ETL, Big Data processes, Business Objects reports and SAS analysis, including performance tuning SQL.
• Environment was on multi-node multi-server Unix systems connecting to Solaris Database Servers.

Confidential

Senior Database Consultant

Consulted with InComm and benefitfocus.com on their Oracle Databases. Analyzed/evaluated their 10g RAC ASM environment.

Confidential

Senior Database Architect / Senior Data Architect

• Analyzed Business and Software Requirements, and architected Data Warehouse, created Logical and Physical Data Model, ETL and
• Big Data processes for capturing, transforming, aggregating, storing, analyzing, and reporting on data to meet those requirements.
• Designed and tested processes that allowed massive amounts of disparate data to be quickly loaded and analyzed to assess the value
• and provide additional offers to the customer in real time. Utilized Oracle 10g and RAC, as well as Open Source Systems and
• Software Linux, MySQL . Environment was on multi-node, multi-server Unix systems connecting to Red Hat Linux DB Servers.

Confidential

Senior Database Consultant / Senior Database Architect

• Consulted with numerous clients on Oracle Databases and Data Warehouses, Oracle RMAN, Oracle Discoverer, Oracle Data Guard,
• Oracle Data Replication via Snapshots, Advanced Replication or Oracle Streams , and Oracle RAC projects including performance
• tuning of SQL and Big Data processes for complex reports/analysis by tools such as Business Objects, Cognos BI, Micro Strategies.
• Data Warehouse Project at Premier HealthCare. Provided guidance, mentoring, and assistance with planning, architecture, design, and implementation of their Data Warehouse and ETL processes. This included reviewing their business and technical documentation, meeting with their lead technical personnel, Logical and Physical Data Modeling via ERwin design / implementation, PL/SQL ETL design / coding, and advising on issues related to their Data Warehouse, especially Best Practices and industry trends. Also included in this engagement was significant mentoring of the DBA group on performance tuning, Oracle Data Replication, and Oracle Streams.
• Data Warehouse Project at Timken Company. Provided guidance, mentoring, design, and implementation of their Data Warehouse / Data Mart and ETL processes. This included analyzing their business and technical requirements, designing and implementing their Logical and Physical Data Models, designing and implementing their Data Warehouse / Data Mart, designing/coding/implementing their ETL processes via PL/SQL, and advising on issues related to their Data Warehouse, especially Best Practices and industry trends.
• RMAN Implementation and Data Guard / Data Replication Consulting at Georgia Telco. Performed configuration and implementation of Oracle RMAN backups and recovery. Provided guidance, mentoring, and assistance with planning, architecture, and design of their data replication via Oracle Data Guard and Oracle Advanced Replication.
• Database Migrations and Upgrades. Performed Database migration of 70 Oracle 8i / 9i databases from Solaris platform to Fujitsu platform and Oracle 9i /10g at Mirant Corporation. Provided guidance, mentoring, and assistance with planning, architecture, design, and implementation of their Database from Oracle 9i to 10g at Benefitfocus.com. Additionally, performed major performance comparisons between Oracle 9i and Oracle 10g, which resulted in significant performance improvements.
• Remote Database Administration at Ready Mixed Concrete Corporation and BioSignia, Inc. Performed Remote Database Administration, including database design, analysis, support, configuration, maintenance, monitoring, RAC, Database backups and recovery. Provided guidance, mentoring, and assistance with planning, architecture, design, and implementation of their Oracle DB's.
• Database Design Review at Benefitfocus.com, Okuma Corporation, Dimension Data, Provided guidance, mentoring, and assistance with planning, architecture, design, and implementation of their Oracle Databases. This included reviewing their technical documentation, querying their data dictionaries, and offering advice and assistance with issues related to their Databases and RAC environments, especially Best Practices and industry trends.

Confidential

Senior Database Consultant / Senior Database Architect

• Consulted with numerous clients on Oracle Data Warehouses, Oracle DB's, Oracle Application Server systems, Oracle Data Guard,
• Oracle Data Replication via Snapshots, Advanced Replication, or Oracle Streams , and Oracle RAC projects including performance
• tuning of SQL and Big Data processes for complex reports/analysis by tools such as Business Objects, Cognos BI, Micro Strategies.
• Data Warehouse Design, Review and Mentoring. Provided guidance, mentoring, and assistance with planning, architecture, design, and implementation of the Data Warehouses for Trilegiant Corporation, IntraLot Corporation, OSI, and California State Poly University at San Luis Obispo. This included reviewing their business and technical documentation, meeting with their lead business and technical personnel, and advising on issues related to their Data Warehouse, especially Best Practices and industry trends. Completed star schema design of the data needed to produce Business Intelligence reports. Included in these engagements was a significant amount of mentoring.
• Data Replication at Alliance Coal Headquarters. Gathered technical and business requirements, then analyzed, designed, configured, implemented, tested, and documented the process to replicate Coal quantity and shipment data from Oracle Databases at remote sites to the Alliance Coal Headquarters Oracle Databases in Tulsa, OK. Mentored the Alliance Coal IT staff in Oracle replication concepts.
• Migrated 3 DB's to 9.2.0.4 and 11 applications to 10gAS at NOAA National Oceanic and Atmospheric Administration . Performed Oracle DBA and Oracle Application Server duties, including
• Migrated 3 DB's from Oracle Release 8.1.7.3 on Solaris Servers to Oracle Release 9.2.0.4 on a bigger Solaris Servers, including Installation / configuration of Oracle 9.2.0.0 and patch sets, Data Migration via Export / Import of the specified schemas.
• Migrated 14 applications from Oracle 9iAS on one Application Server / Unix box to Oracle 10gAS on 2 Servers / Unix boxes, using one box for the Infrastructure Application Server and the other for the Mid-Tier Application Server. Included in this migration was: A Installation / configuration of Oracle 10gAS on both Application Servers, B Conversion of each of the applications to Oracle 10gAS, and C Compilation of each Library, Menu, and Form for each of the applications.
• Performance Tuned DB's, including A putting each of the 3 DB's into Archive log mode, B changing their backups to hot backups, C initialization parameter changes, and D tablespace, application, network, and architectural adjustments.
• JMA Data Warehouse Project at JM Family. Performed development and production DBA duties for the JMA Data Warehouse Reporting Project at JM Family Southeast Toyota , including
• Converted and Transformed the Logical Dimensional DB Design into the Physical Dimensional DB Design using ERwin.
• Analyzed, planned, and designed Oracle Data Warehouse partitioning strategy.
• Designed, administrated, and supported Oracle Data Warehouse and Oracle Database Systems. Administration of these systems included database analysis, design, configuration, implementation, maintenance, monitoring, partitioning, User and schema creation, security, and database backups and recovery.
• Analyzed, designed, coded, tested, implemented, and maintained Stored Procedures, Database Triggers, and ETL processes using Oracle Warehouse Builder, PL/SQL, and SQL.
• Mentored and supported other members of the JMA Reporting Project on Oracle concepts, Databases, Data Warehousing, Security, Partitioning and other database performance options , ETL Processing, and SQL coding.
• DB and Data Warehouse Health Checks. Analyzed the Emory University Enterprise Data Warehouse and the ChoicePoint, Inc. CRUP1 and CRPW2 databases. Activities included evaluating the performance and data architecture issues within the database environments, and analyzing the Application Performance, Database Performance, Configuration of the Operating System, Storage System, and the Database. Interviews were conducted with the DBA team, the Development team, users, and management in order to clearly understand the issues from all sides. At the conclusion of each effort, a 200 page formal Database Health Check Report was prepared on all findings. These reports included a High-level assessment of end-to-end Solution Architecture identifying problem areas observed, Resolution recommendations, a Description of each identified problem area, Expected or typical symptoms caused by the problem area, Possible short term fix options for resolution, Description of long term resolutions, Description of any short/long term redesign considerations, High-level steps for implementing the proposed resolutions, and Expected results after implementation.
• DB, Oracle Application Server, and Data Warehouse Security Assessments and Performance Tuning. Reviewed and analyzed the proposed data warehouse security schema at Syncrude Limited Canada via the CIM Database Security Detailed Design document and offered guidance on how this proposal compared with best practices in the IT industry for data warehouse security. Prepared a formal document of the Pro's and Con's of the proposed data warehouse security schema and presented this information in a live web conference to the involved technical and business parties. Analyzed the Security of the Oracle DB environments and the Oracle Application Server environments at Wycliffe Bible Translators. Recommended numerous changes and adjustments to the Oracle DB environments and the Oracle Application Server environments to make this security configuration match industry Best Practices and trends. Analyzed and assessed the existing Oracle DB environments at Meridian IQ a subsidiary of Yellow Roadway Corporation .

Confidential

Database Administrator / Senior Data Architect / Senior ETL Developer

• Administrated and supported Oracle Data Warehouse and Oracle Database Systems. Administration of these systems included,
• analysis, design, implementation, installations, configurations, maintenance, monitoring, partitioning, and backups and recovery.
• Analyzed, designed, coded, tested, implemented Stored Procedures, Database Triggers, ETL processes using SQL PL/SQL.
• Data Architect for client-server and Web-based applications to OLTP and OLAP systems, and Database Warehouses,
• including Dimensional, Logical, and Physical DB Design via ERwin.
• Environment was on multi-node multi-server LAN systems connecting via client-server and Web-based applications to HP Tru64
• Database Servers utilizing 2 Terabytes of DASD.

Confidential

Senior Database Administrator

• Administrated and supported Oracle 9i Database Systems and Oracle 9i Application Server Systems. Administration of Databases and
• Application Server systems included analysis, design, implementation, installation, maintenance, monitoring, and backup and recovery.
• Environment was on multi-node multi-server LAN systems connecting via client-server and Web-based applications to Solaris
• Database Servers utilizing 4 Terabytes of DASD.

Confidential

Senior Database Architect for the Enterprise Data Warehouse and Business Intelligence System

• Database Architect for Enterprise Data Warehouse, including 73 Data Marts and multiple OLAP systems.
• Provided direction and support for 24-hour off-shore production and development DBA staff. Performed as EDW/BI Project Leader
• on the upgrade / migration of the three largest Enterprise Data Warehouse Database Servers to newer Sun models.
• Designed and created DB Standards and DB Performance Guidelines for all groups and technologies that connected to the GEPS
• Enterprise Data Warehouse / Business Intelligence System, including Dimensional and OLAP Modeling via Erwin , Logical and
• Physical Data Modeling via ERwin , ETL via Informatica and SQL Loader , Reporting and Decision Support via BO and BRIO ,
• Data Mining via BO , SQL Coding including PL/SQL , and support of developers of client-server and Web-based applications.
• Environment was on multi-node multi-server LAN systems connecting via client-server and Web-based applications to Sun DB
• Servers Solaris utilizing 400 Terabytes of DASD. The largest Database Server EDW utilized 40 Gigabytes of memory / RAM.

Confidential

Senior Database Architect / Senior Data Administrator

• Data Architect for client-server and Web-based applications to OLTP and OLAP systems, Database Warehouses, and Data Marts,
• including Dimensional, Logical, and Physical DB Design via ERwin Oracle Designer.
• Performed as the Project Leader on multiple projects, including DB migrations/conversions and development projects.
• Analyzed, designed, tested, and implemented multiple Database Warehouses and multiple Data Marts.
• Administrated and supported Oracle7, Oracle8, Oracle8i and 9i Database Systems. Administration of database systems included
• database analysis, design, implementation, installations, configurations, maintenance, monitoring, partitioning, parallel server,
• developer/user support and training, and Database Server backups and recovery.
• Analyzed, designed, coded, tested, and implemented Stored Procedures, DB Triggers, and ETL processes using SQL and PL/SQL.
• Administrated and supported full Oracle 11 ERP Applications Suite on Sun database servers. Administration of DB system included
• database analysis, design, implementation, developer/tester/user support, partitioning, parallel server, maintenance, and monitoring.
• Environments were on multi-node multi-server LAN systems connecting via client-server and Web-based applications to Unix and
• Windows Servers utilizing up to 600 Terabytes of DASD.
• Companies included Sprint, Coca-Cola Enterprises, Wachovia, GE Power Systems, Cox Communications, Assurant Group,
• FleetCor Technologies, and AON Group Services.

Confidential

Senior Database Architect / Senior Data Administrator

• Performed as the Database Architect on the conversion of Time Management System from Sybase and SQL Server to Oracle, including
• Logical, and Physical Database Design via EasyCASE.
• Administrated and supported multiple development/test Databases on project to convert from SQLServer and Sybase to Oracle7 and 8.
• Administration of database systems included database design, analysis, developer/tester/user support and training, installations,
• configurations, maintenance, monitoring, partitioning, parallel server, software evaluations, Database Server backups and recovery.
• Environment was on multi-node multi-server LAN system connecting via client-server and Web-based applications to Novell and
• Windows NT DB Servers.

Confidential

Senior Database Architect / Senior Database Administrator

• Database Architect for 1st Internet Banking Application. Performed Logical / Physical DB Design via S/Designer Power Designer.
• Analyzed, designed, coded, tested, and implemented Production Database solutions in the form of DB Triggers, Stored Procedures,
• DB Constraints, and SQL reports using SQL and PL/SQL.
• Administrated and supported 150 development/test and 12 production Informix and Oracle Databases running Financial Applications
• for the world's first Internet Bank. Administration of database systems included database design, configurations, analysis, evaluations,
• developer/tester/user support and training, trouble-shooting, data communications, ensuring data integrity, DB Server backup/recovery.
• Development environment was on 200 node HP-UX system connecting via client-server and Web-based applications to DB Servers.
• Production environment was World Wide Web utilizing Net Browsers to connect via firewalls to application servers and DB servers.

Confidential

Senior Database Administrator / Senior Database Architect

• Administrated and supported 9 production and 4 development/test Oracle 7 Databases. Administration of database systems
• included database design, analysis, developer/tester/user support and training, trouble-shooting, installations, configurations,
• maintenance, monitoring, evaluations, partitioning, parallel server, Database Server backups and recovery.
• Database Architect for client-server and Web-based applications OLTP . Performed Logical and Physical Database Design via
• S/Designer and Oracle's Designer/2000.
• Analyzed, designed, coded, tested, and implemented Stored Procedures, DB Triggers, and ETL functions using SQL and PL/SQL.
• Environment was on 300 node multi-server LAN system connecting via client-server and Web-based applications to UNIX HP-UX
• AIX, LINUX and Windows NT DB Servers. Applications included PeopleSoft Payroll / Human Resources JD Edwards Financials.

Confidential

Senior Database Administrator / Senior Database Architect

• Administrated and supported 21 development and test Oracle 7 Databases. Administration of database systems included
• database design, analysis, developer/tester support and training, trouble-shooting, installations, configurations, maintenance,
• monitoring, evaluations, data communications, ensuring data integrity, Database Server backups and recovery.
• Database Architect for client-server applications to OLTP DB systems. Performed Logical and Physical Database Design via ERwin.
• Performed competitive analysis and evaluations of SQL Financials' Software versus Oracle Financials.
• Environment was on 100 node multi-server LAN system connecting via client-server applications to UNIX HP-UX, LINUX ,
• Windows NT, and Novell Database Servers.

Confidential

Senior Database Administrator / Database Architect

• Administrated and supported 7 Production Database Servers Oracle 6 , with 450 Users, and 3 Test Oracle 7 Database Servers.
• Administration of database systems included database design, installations, analysis, configurations, evaluations, trouble-shooting,
• monitoring, maintenance, user/developer support and training, data and voice communications, Database Server backups and recovery.
• Database Architect for client-server applications to Data Marts OLAP . Analyzed, designed, coded, tested, and implemented ETL
• functions using SQL and PL/SQL from mainframe OLTP to Data Marts.
• Environment was on 700 node multi-server Novell LAN system utilizing Macintosh Clients connecting to UNIX Solaris, LINUX
• and Macintosh Database Servers. Performed Dimensional, Logical, and Physical Database Design via Oracle's CASE tool.

Confidential

Senior Consultant to Equitable Real Estate and Crawford Company

• Analyzed, coded, and tested applications and designed databases at Equitable Real Estate utilizing Oracle 7, SQL PLUS,
• PL/SQL, ERwin, and LBMS on Novell LAN with Windows Clients and UNIX HP-UX Database Server.
• Analyzed, coded, and tested COBOL and Assembler programs being converted from DOS/VSE to MVS/ESA system
• 235 programs, approximately 335,000 total lines of code at Crawford Company on IBM 9000 Mainframe.

Confidential

Senior Systems Analyst / Senior DBA

• Administered and supported 500 node multi-server Novell LAN system. Administration of Oracle Databases and LAN systems
• included end-user and developer support, and the following for both applications and systems: analysis, design, evaluations,
• installations, protocol analysis, configurations, monitoring, maintenance, trouble-shooting, data communications, and backups.
• Analyzed, designed, coded, tested, implemented, and served as Database Administrator on ORACLE Version 6 OS/2
• Database Server system communicating to 500 PC-DOS workstations. Performed Logical and Physical Database Design.
• Analyzed, designed, coded, tested, and implemented applications on LAN and on ORACLE Database Server systems.
• Environments were on Novell LAN's, DEC VAX's, and IBM Mainframes, from IBM PS/2's and PC Clones XT, AT, and 386
• utilizing Novell Netware, PC-DOS, OS/2, All-in-One, ORACLE RDMS, 4GL's, and End-User Tools , Clipper, dBASE III, LBMS,
• Project Workbench, METHOD/1, DESIGN/1, R R Relational Report Writer, Harvard Graphics, Lotus 1-2-3, DB2 and ECF.

Confidential

Systems Engineer

• Managed technical evaluation projects, installed software, performed product presentations, trained users, and designed,
• coded, tested, and implemented Financial, Banking, Telephonic, Health-Care, Information Systems, Marketing, Manufacturing,
• University, and Governmental applications.
• The environments were on IBM Mainframes 3090, 308X, 43XX , IBM Mini's 9370 , LAN's Novell, XENIX, Banyan Vines , and
• PC's XT, AT, 386, PS/2 utilizing MVS/XA, MVS, VM/SP, VM, DOS/VSE, DOS/VS, PC-DOS, OS/2, UNIX, CICS, VSAM, TSO,
• CMS, ISPF, JCL, DB2, SQL/DS, FOCUS, SAS, ORACLE RDMS, 4GL's, and End-User Tools , QMF, RAMIS II, NOMAD,
• ADABAS, DATACOM/DB, IDEAL, DL/1, IMS/DB, COBOL/XE, Lotus 1-2-3, Symphony, T-A-C, Freelance, Manuscript,
• dBASE III, dBASE II, dBASE, PROFS, VTAM, LU6.2, 3270, X.25, TCP/IP, Relay Gold, CrossTalk, and various LAN's.

Confidential

Programmer/Analyst

• Analyzed, designed, coded, and tested CICS Billing System applications and ad hoc requests for marketing and financial reports.
• The environments were on IBM and Amdahl Mainframes 308X,43XX, 370/158, 370/138 utilizing MVS, VM, CICS, DOS/VSE,
• DOS/VS, DOS, COBOL, QUICKJOB, VTAM, TSO, CMS, ISPF, ROSCOE, EDGAR, IDCAMS, and JCL.