| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate
Technical Resume of Candidate's Name
Senior Oracle DBAEMAIL AVAILABLE PHONE NUMBER AVAILABLESUMMARYDavid has 35 years of experience as an Oracle Database Administrator, supporting clients deployed on Oracle RDBMS versions 6 through 19.12, inclusive, on most common implementation platforms (AIX, Solaris, Tru64, HP-UX, Windows, RHEL, CentOS, Ubuntu, etc.). He also possesses 23 years of experience as a PeopleSoft Administrator (both Financials/FSCM and HRMS/HCM) on versions 5 through 9.2. He has nearly two decades of hands-on experience managing teams of experienced Database Administrators and has project-managed multidisciplinary teams distributed across six countries on four continents.
EDUCATION/TRAINING
Ohio University , Athens, OH Bachelor of Science Degree, Economics, Summa Cum LaudeInternship with the Joint Economic Committee of the United States CongressExtensive vendor-provided technical training in all aspects of relational database administration.Former Council Member, Ohio University Arts and Sciences Dean's Advisory CouncilEagle Scout, Boy Scouts of America
PROFESSIONAL CERTIFICATIONS Informix Standard Engine Certified Developer Oracle Master Certification - Application Analyst
Oracle Master Certification - Database Administration
Oracle Master Certification - Designer/2000 Systems Analyst
Oracle Master Certification - Technical Support
ENGAGEMENTSNote: Those client engagements highlighted in red are currently in-process/active.STATE OF OHIO DEPARTMENT OF CHILDREN AND YOUTH, COLUMBUS, OHDates of Engagement(s): 02/2024 - PresentWork efforts were performed on an exclusively remote access basis.Selected as sole Oracle DBA following the migration of database responsibilities from State of Ohio Jobs and Family ServicesWork efforts included: Primary Oracle DBA support for a highly complex deployment of numerous multi-terabyte database environments on Real Application Clusters (RAC) in an Oracle 19 multi-tenant configuration supporting the department s mission-critical child welfare (SACWIS) database environments.
Served as the organization s primary DBA in supporting all aspects of their data warehouse environments deployed on an Oracle RDBMS.
NFOCUS CONSULTING INC., LANCASTER, OHDates of Engagement(s): 03/2022 - PresentWork efforts were performed on an exclusively remote access basis.Work efforts included: Served as Technical Project Manager for an effort to modernize the organizations database and data processing environment, with an objective of streamlining the flow of data and automatic tasks were possible. Provided performance tuning/optimization for the organizations data load and extraction on MS SQL Server database environments.PFIZER INC., GRONTON, CTDates of Engagement(s): 05/2021 12/2021, 10/2022 12/2022Work efforts were performed on an exclusively remote access basis.Work efforts included: Identify and resolve sources of database query performance problems. Optimized mission critical processes via a combination of table partitioning with row movement enabled, trigger and stored procedure modifications, view consolidation, and new index creations. Reduced execution of a critical reporting process from nearly 17 minutes to 10 seconds. Developed modified PL/SQL-based stored procedures to speed bulk data loads and subsequent cleanup/deletion of data. Developed and performed timed execution tests of alternative object designs, including table partitioning with real-time row migration enabled between partitions versus latent partition exchange.
Identifying and communication new features in Oracle19 that the organization might utilize to optimize execution performance. Discovering and implementing solutions that will enable the organization to discontinue use of partitioning and Database In-Memory licensing with an upgrade to an Oracle 19 multitenant cloud environment, yet at a minimum, experience no discernable performance degradation on massive queries.HARTLAGE MANAGEMENT COMPANY, ELIZABETHTOWN, KYDates of Engagement(s): 11/2019 06/2020Work efforts were performed on an exclusively remote access basis.Work efforts included: Evaluation and recommendation of alternative backup/recovery solutions for a legacy Oracle production database environment undergoing application upgrades. Assisted in identifying the root cause of data load failures of customer records. Successfully completed a disaster recovery of the organization s production history database, in the absence of either a controlfile or controlfile backup, but with otherwise viable RMAN backup pieces containing datafile and archive log contents.STATE OF OHIO JOBS AND FAMILY SERVICES, COLUMBUS, OHDates of Engagement(s): 11/2018 01/2024Work efforts included: Full Oracle DBA support for a highly complex deployment of numerous multi-terabyte database environments on Real Application Clusters (RAC) in an Oracle12.1/12.2/18/19 multi-tenant configuration, with monitoring accomplished through Oracle 13 Cloud Control.
Served as the bureau s primary DBA in supporting all aspects of their data warehouse environments deployed on an Oracle RDBMS. These databases were all multi-terabyte in size with tables ranging in size up to 892 million rows.
Worked to develop an automated utility to seamlessly, and without human intervention, execute users data correction requests initiated via Microsoft Outlook e-mail requests, including post-DML update communications back to the requesting end user.
Accomplished over a dozen large-scale schema and data migrations from DB2 LUW to Oracle 18 using SQL Developer migration utilities and the primary conversion tool. Successfully completed a large-scale data migration from a mainframe DB2 ZOS platform to an Oracle 12 database successfully with only two weeks available to accomplish the mission.
Extensive performance tuning of the organization s critical batch processes and online queries developer in Toad, Cognos, Informatica, SASS, and assorted other development tools. Developed PL/SQL procedures to accomplish automated partition creation, deletion, and exchange between massive current and history data tables to minimize ETL processing against data warehouses. Designed/redesigned massive database objects in a data warehouse environment to optimize load and access performances via partitioning, bitmap indexes, bitmap join indexes, and structural code modifications. Developed procedures to automate migration of data between active and historic partitioned tables via dynamic partition exchange. These procedures were invoked by executing Informatic load programs. Developed PL/SQL based procedures to optimize Informatica-based table loads to data warehouse environment by dynamically dropping and rebuilding indexes and primary key constraints. In essence, the logic involved writing a code generator that in turn generated a code generator. The returning code supported normal, bitmap, function-based normal, and function-based bitmap indexes for both partitioned and non-partitioned indexes.
Provided extensive performance tuning of data warehouse queries originating a variety of sources including Cognos, Tableau, SAS, and Informatica, with an emphasis on providing solutions that were viable with machine-generated queries.ABERCROMBIE & FITCHDates of Engagement(s): 06/2017 11/2017Work efforts included: Led and Project Managed a geographically distributed technical team to accomplish a holistic environmental assessment of the organization s recently upgraded PeopleSoft Financials 9.2 / PeopleTools 8.55 environment which was deployed on Oracle 12.1 Exadata with RAC and Real Data Guard components.
Performed a detailed evaluation of the organization s production Oracle 12.1 database for scalability, survivability, and optimal performance attainment. Recommended sequencing of PeopleTools upgrades, PUM image applies, Oracle database version upgrades, and new module implementations/customizations.DISAGGIO CONSULTING, LLC., COCKEYSVILLE, MDDates of Engagement(s): 05/2017 07/2017Work efforts were performed on an exclusively remote access basis.Work efforts included: Provided PeopleSoft/Oracle DBA assistance in support of a PeopleSoft HCM 9.2 upgrade with migration to an Oracle12c Unicode environment.STATE OF OHIO LEGISLATIVE INFORMATION SYSTEMS, COLUMBUS, OHDates of Engagement(s): 01/2017 - PresentWork efforts were performed on a predominately remote access basis.Work efforts included: Technical assessment of the existing deployment of Oracle 10g and Oracle12c RAC on Red Hat Linux, following by remediation of identified suboptimal configurations. Performed architectural design analysis and provided consultative recommendations for a possible Oracle 12c multitenant deployment to support the organization s various database environments following an upcoming re-hosting effort. Provided application tuning to resolve excessive physical I/O and speed execution performances. Provided consultative support in evaluating alternative upgrade and hosting solutions. Migrated database environments from Oracle10.2.0.5 Standard Edition to Oracle 11.2.0.4 Enterprise Edition, implemented environmental monitoring and notification capabilities, deployed RMAN backups, and accomplished database duplication and physical standby database instantiations. Provided extensive training to internal Oracle DBA staff on physical standby instantiation, switchover and failover procedures. Deployed fully automated database and server monitoring utilities to proactively identify and communicate potential areas of concern and to provide near-immediate notification of system problems and performance bottlenecks. Successfully accomplished an Oracle RDBMS upgrade from Oracle 11.2.0.4 to Oracle 12.2.0.1 with tablespace assignment changes in lieu of a multitenant configuration (as requested by the client) to allow application autonomy via tablespace point-in-time recovery capabilities. Established single standby switchover/failover environments for the organization s development and user acceptance testing environments, will multiple switchover/failover environments for production and monitoring databases. Fully documented all processes and procedures to facilitate internal personnel assumption of Oracle DBA responsibilities. Upgraded the organization s Oracle RDBMS environments to an Oracle19 multitenant configuration and updated previously developed automation to utilize the latest features as well as expand the types of DBA activities that are automated.
Expanded previously developed database administration automation utilities to address pluggable database considerations. Further enhanced the software to allow a gui-based interface.R. DORSEY+COMPANY, INC., WORTHINGTON, OHDates of Engagement(s): 04/2016 10/2018Work efforts included: Development on Linux in bash shell of a database administration utility that allows menu-driven execution of multi-threaded hot and cold backups, database restores and recoveries, database duplications, and both physical and logical standby database instantiations without reliance on RMAN multi-threading capabilities. Enhancement of a fully automated and cohesive database and server monitoring utility to allow holistic monitoring of large numbers of distributed Oracle databases. Assisted in the development of responses to governmental RFPs/RPQs.WRIGHT-PATTERSON AIR FORCE BASE, DAYTON, OHDates of Engagement(s): 05/2016 08/2016Work efforts were performed on an exclusively remote access basis.Work efforts included: Performed detailed technical evaluation and performance optimization analysis of the organization s existing data warehouse database and associated ETL processes. The source environment was a multi-terabyte ORACLE EBS financials database. Served as Technical Project Manager on the external consulting team efforts intended to provide an alternative, optimized architectural solution to the existing data warehouse approach as well as optimized extract process from the EBS source database. Prototyped an Oracle 11.2 logical standby database, with various changed-data-capture solutions, as a proof of concept for the alternative architectural solution to the existing design. Change detection was accomplished on the logical standby database through standby trigger executions to system type partitioned tables.
LAUREATE EDUCATION, BALTIMORE, MDDates of Engagement(s): 2011 - 2012Work efforts were performed on an exclusively remote access basis.Work efforts included: Served as Project Manager for the organization s application upgrade from PeopleSoft Financials 9.0/PeopleTools 8.49/Oracle 10.2 to PeopleSoft Financials 9.1/PeopleTools 8.51/Oracle 11.1. Coordinated upgrade-related work efforts provided by Cedar-Crestone hosting services personnel, Oracle Upgrade Lab personnel, and Laureate Educate internal personnel. Ensured a successful Move to Production in only ten (10) weeks.BERKSHIRE-HATHAWAY MEDIA GROUP, RICHMOND, VA and OMAHA, NEDates of Engagement(s): 2012 - 2015Work efforts were performed on an exclusively remote access basis.Work efforts included: Provided full Oracle DBA support for the organization s numerous Oracle primary, standby, and developmental databases underlying the firm s Mactive/ATEX and DSI systems. Upgraded the organization s eleven production DSI databases, as well as their various standby and developmental environments, to Oracle 11.2 on T# Solaris servers.
SAFEAUTO INSURANCE COMPANY, COLUMBUS, OHDates of Engagement(s): 2006 - 2009Work efforts were performed on an exclusively remote access basis.Work efforts included: Technical review of the organizations Oracle 10.2.0.4 database environment. Ongoing database administration support efforts.CROW HOLDINGS, DALLAS, TXDates of Engagement(s): 2001 - 2013Work efforts were performed on an exclusively remote access basis.Work efforts included: Ongoing application and database administration support of the organization s production PeopleSoft Financials environment deployed on an Oracle RDBMS.
Served as upgrade Project Manager and PeopleSoft DBA for the firm s PeopleSoft Financials 7.53 upgrade to release 8 SP1. Served as upgrade Project Manager and PeopleSoft DBA for the firm s PeopleSoft Financials 8 SP1 upgrade to release 8.8 SP1. Served as upgrade Project Manager and PeopleSoft DBA for the firm s PeopleSoft Financials 8.8 SP1 upgrade to release 9.0 SP1. Full PeopleSoft Administrator and Security Administrator responsibilities. Patched the PeopleSoft Financials 8.8 SP1 code base up through Maintenance Pack 9. Patched the PeopleSoft Financials 9.0 code base up through bundle # 30.
Upgraded PeopleTools from 8.45 to 8.48 and Oracle from 9.2.0 to 10.2.0. Upgraded PeopleTools from 8.48 to 8.49 while migrating to an Oracle 10.2 64-bit environment.
Performed all data extraction and conversion work efforts in support of the organization s migration off PeopleSoft Financials.DICKS SPORTING GOODS, PITTSBURGH, PADates of Engagement(s): 2007, 2009, 2013Work efforts were performed on an exclusively remote access basis.Work efforts included: Technical review and assessment of the organization s PeopleSoft Financials environments in anticipation of an impending application upgrade to PeopleSoft 8.8. Technical review and assessment of the organization s PeopleSoft HRMS database environment on Oracle 9.2.x to identify potential Best Practices opportunities.
Technical assessment, tuning, and rebuild of the organization s production PeopleSoft 8.8 SP1 Financials database following the organization s upgrade to Oracle 10.2.0 to resolve severe performance problems.
Full comprehensive environmental assessment of the organization s PeopleSoft Financials and HRMS deployments on Oracle RDBMS platforms to identify sources of on-going suboptimal performances and user session disruptions.
THE TIMKEN COMPANY, RANDLEMAN, NCDates of Engagement(s): 2007Work efforts were performed on an exclusively remote access basis.Work efforts included: Responsible for providing secondary Oracle DBA services in support of the organization s Asheboro Bearing Plan.DONATOS PIZZA, COLUMBUS, OHDates of Engagement(s): 2007Work efforts were performed on an exclusively remote access basis.Work efforts included: Maintained current Financials 8.8 SP1 code base by applying Maintenance Packs up through Maintenance Pack 8. Responsible for environmental cleanup, including resolution of problems detected from execution of dddaudit, sysaudit, and alter audit reports.THE LONGABERGER COMPANY, NEWARK, OHDates of Engagement(s): 2003, 2005Work efforts included: Technical review of the organization s PeopleSoft Financials / Supply Chain, HRMS, and CRM environments to identify potential Best Practices opportunities. Emergency database maintenance efforts to stabilize and improve system performances of the organization s Financials / Supply Chain and CRM environments.
3PF, COLUMBUS, OHDates of Engagement(s): 2004Work efforts were performed on an exclusively remote access basis.Work efforts included: Technical review and evaluation of the organization s Oracle RDBMS environment. Configuration of automatic database exports, as well as misc. other environmental cleanup efforts.ZOOMAX, DUBLIN, OHDates of Engagement(s): 2005Work efforts included: Emergency support to address system performance issues immediately before and after migration to a Baan application environment. Database upgrades to Oracle version 9.2.x and server rehosting to consolidate environments onto a single physical database server. Ongoing Oracle DBA support for Baan, PeopleSoft, and other application environments.eSYLVAN, BALTIMORE, MD
Dates of Engagement(s): 2006Work efforts were performed on an exclusively remote access basis.Work efforts included: Ongoing database administration support of the organization s custom-developed applications residing of Oracle versions 8.0.5 and 8.1.7.DUALITE SALES & SERVICE, INC., WILLIAMSBURG, OHDates of Engagement(s): 2005Work efforts were performed on an exclusively remote access basis.Work efforts included: Technical review and evaluation of the organization s Oracle RDBMS/Baan application deployment.
Emergency problem resolution in support of the production environment.
MAERSK LINES LIMITED, NORFOLK, VADates of Engagement(s): 2006Work efforts were performed on an exclusively remote access basis.Work efforts included: Online Application Upgrader work efforts in support of the organization s PeopleSoft application upgrade from Financials Release 7.53 to Release 8.4
HCR MANORCARE, TOLEDO, OHDates of Engagement(s): 2004Work efforts were performed on an exclusively remote access basis.Work efforts included: Technical evaluation/audit of the organizations PeopleSoft 8 Financials architecture environment, with primary focus on optimizing performance, stability, and security. Technical evaluation/audit of the organizations PeopleSoft 8.8 HRMS architecture environment. Application tuning of various SQR programs in anticipation of production deployment on PeopleSoft HRMS 8.8.
U.S. DEPARTMENT OF STATE, WASHINGTON, D.C.Dates of Engagement(s): 2001Work efforts included: Technical evaluation of client's PeopleSoft HR deployment on Oracle/NT. Consultative assistance in identifying appropriate security and administrative policies and procedures.GENERAL CHEMICAL CORPORATION, PARSIPPANY, NJDates of Engagement(s): 2002 - 2005Work efforts were performed on an exclusively remote access basis.Work efforts included: Provided technical training to the organization's Oracle Database Administrator. Emergency support / problem resolution. Ongoing Oracle Database Administration support for the organization s PeopleSoft 7.51 HRMS environment, PeopleSoft 7.0 Manufacturing environment, and PeopleSoft 7.53 Financials environment.CITY OF CAMBRIDGE, MA, CAMBRIDGE, MADates of Engagement(s): 2003Work efforts included: Provided PeopleSoft/Oracle DBA assistance in support of a PeopleSoft HR upgrade effort. Provided stabilization support and deficiency remediation following completion of the application upgrade.VP BUILDINGS, MEMPHIS, TNDates of Engagement(s): 2002 - 2003Work efforts included: Emergency database tuning and application tuning. Rapid analysis and execution of required emergency database maintenance required to allow month end Financial System processing. Development of a strategy required to rehost the database, PeopleSoft Process Scheduler, and Application Manager on a new production server.BORDEN FOODS CORPORATION, COLUMBUS, OHDates of Engagement(s): 1998 - 2001Work efforts included: Full Oracle8 Database Administration services in support of PeopleSoft Financials, Supply Chain, and Distribution applications. Performed PeopleSoft PeopleTools, Applications, and SQR upgrades. Responsible for all aspects of PeopleSoft security administration. Responsible for all aspects of project migration and patch application. Implemented and administered multiple application servers, with round-robin connectivity, in a three-tier physical architecture. Developed and administered multiple PeopleSoft Process Schedulers. Participated in the full life cycle deployment of the PeopleSoft implementation, then provided both on-site and remote support services.
MEDIA GENERAL, RICHMOND, VADates of Engagement(s): 1998, 2000, 2001, 2005, 2009 - 2015Work efforts were performed on a predominately remote access basis.Work efforts included: Optimized PeopleSoft-generated alter scripts to minimize execution duration associated with a PeopleSoft HRMS upgrade from Version 5.1 to 7.0., while concurrently minimizing the risk of upgrade execution failure due to object sizing, temp space, or rollback segment failures. Assisted the organization s Database Administrators in completing an Oracle upgrade to Release 7.3.4 from Release 7.3.2.3. Provided technical assistance during the organization s PeopleSoft Financials upgrade from release 7.02 to 8 SP2. Provided technical assistance during the organization s PeopleSoft HRMS upgrade from release 7.51 to 8.3.
Technical evaluation of the organization s Oracle database environment to identify causes of severe performance problems following their PeopleSoft Financials upgrade to release 8 SP2. Provided application tuning services in support of the organization s PeopleSoft Financials application upgrade from Release 8 to Release 8 SP3. Pre-production release technical database review for a new application environment deployed on an Oracle 10.2.0.3 RDBMS platform.
Ongoing technical consultative assistance in support of the organizations deployments on Oracle. Upgraded the organization s PeopleSoft Financials environment to PeopleTools 8.50 running on Oracle 10.2.0.4. Completed dry runs for upgrading and rehosting the organization s eleven production DSI databases from Oracle 9 on HP-UX to Oracle 10 on Sun Solaris. Completed a prototype rehosting of the organization s DSI environment from Oracle9 on HP-UX to Oracle11 on Solaris servers, with working RMAN backups and database duplications, as well as a standby database.
Provided Oracle database support and PeopleSoft upgrade expertise in upgrading/rehosting the organization s PeopleSoft HRMS 8.8 SP1 environment on HP-UX/Oracle10 to HRMS 9.1 on Solaris/Oracle11. Providing Oracle database support and PeopleSoft upgrade expertise in upgrading the organization s PeopleSoft Financials 8.8 SP1 environment from Oracle 10 to Financials 9.1 on Oracle11.
Assumed full Oracle DBA responsibilities for the firms PeopleSoft Financials, HRMS, Pilat, Mactive, Onbase, and DSI environments representing a total of 80+ databases. Investigative analysis and rectification of performance problems on VLDB databases following updates to Oracle 11.x and hosting on ZFS filesystems on Solaris T4 servers.FIRST AMERICAN NATIONAL BANK, NASHVILLE, TNDates of Engagement(s): 2003Work efforts included: Conducted an audit of the organization's immediate pre-production deployment of PeopleSoft Financial Application in an Oracle7 environment. Provided technical training to the organization's Oracle Database Administrator. Provided managerial and technical recommendations required to address a doubling of database contents resulting pending merger activity. Performed a tuning analysis of the SQL associated with a key, long running PeopleSoft COBOL process. Participated in the organization's PeopleSoft application upgrade from release 6.11 to release 7.52.
SYLVAN LEARNING, INC., BALTIMORE, MDDates of Engagement(s): 1997 1998, 2005, 2007 - 2012Work efforts were performed on a predominately remote access basis.Work efforts included: Database sizing and design analysis for a full PeopleSoft Financials application environment. Logical and physical cleanup of the production Oracle7 database environment in preparation for production deployment. Provided technical training to the organization's Oracle Database Administrator. Performed tuning analyses of the SQL associated with a key, long running PeopleSoft SQR process. Participated, as Project Manager, in the organization's PeopleSoft application upgrade from release 6.11 to release 7.52. Developed Technical Architecture design definition, documenting the Current, Upgrade, and To Be environments for the client s impending PeopleSoft Financials upgrade from release 7.52 to release 8.4 SP1. Performed multiple upgrades of PeopleSoft databases from Oracle version 8.1.7.2.0 to version 9.2.0.2.0. Performed work efforts associated with the organization s PeopleTools upgrade from release 7.6.1 to release 7.63. Served as Lead Architect for the organization s PeopleSoft Financials application upgrade from release 7.52 to release 8.4 SP1. Served as Online Application Upgrader for the organization s PeopleSoft Financials application upgrade from release 7.52 to release 8.4 SP1.
Full Oracle DBA support of the organization s PeopleSoft 8.4 SP1, PeopleTools 8.42, Oracle 9.2.0 production, development, and test environments during a several month reassignment of internal DBA responsibilities. PeopleTools 8.45 installation and environment creation responsibilities. Efforts associated with the organization s upgrade to PeopleTools 8.46. Ongoing full Oracle DBA support of the organization s PeopleSoft 8.4 SP1, PeopleTools 8.46, Oracle 9.2.0 production, development, and test environments.AMERICAN ELECTRIC POWER, COLUMBUS, OHDates of Engagement(s): 1996 1998, 2005Work efforts included: Project Technical Lead for the Leased Asset Management System upgrade from PeopleSoft Version 5.1 to Version 7.0. Project Technical Lead for work efforts associated with integration of the Leased Asset Management System with the organization s other PeopleSoft Financial System modules. Full Oracle 7.x Database Administration services in support of PeopleSoft Financials applications. Team Leader on Data Conversion project efforts for the Leased Asset Management System. Development of utilities to facilitate PeopleSoft version upgrade efforts. Systems Architect responsibilities on integrated infrastructure design. PeopleSoft/Oracle application tuning support to facilitate the organization s PeopleSoft Financials upgrade to version 9.0.CONQUEST OPERATOR SERVICES, DUBLIN, OHDates of Engagement(s): 1998Work efforts included: Installation support for the Oracle RDBMS 7.3 and SQL*Net products. Logical and physical database design responsibilities.O.M. SCOTT & SONS, MARYSVILLE, OHDates of Engagement(s): 1997 - 2000Work efforts included: Full Oracle 7.x Database Administration support services in support of PeopleSoft HRMS applications. Consultative assistance on heterogeneous database bridging alternatives. Application / database support for installed inventory tracking system.NATIONWIDE INSURANCE, COLUMBUS, OHDates of Engagement(s): 1998Work efforts included: Full Oracle 7.x database design and implementation. Consultative assistance in mass data load efforts.BOEING DEFENSE ENTERPRISE INTEGRATION SERVICES, COLUMBUS, OHDates of Engagement(s): 1996 - 1998Work efforts included: Logical and physical design of VLDB Oracle 7.x database environments. Hardware and operating system software evaluations. Evaluation of CASE and other development tools required to facilitate platform migration/reengineering. Analysis of technical alternatives associated with heterogeneous database bridges. Data Warehouse database design and development.LCI INTERNATIONAL, DUBLIN, OH
Dates of Engagement(s): 1995Work efforts included: Full Oracle 7.0 Database Administration responsibilities. Development of a database backup facility to allow backup of open databases operating in Archive Log mode. Design, tuning, and configuration of large databases. Development of numerous utilities to facilitate database migration between midrange computing platforms. Construction of an OLAP data repository for Executive Information System (EIS) use.CINCINNATI MILACRON, CINCINNATI, OHDates of Engagement(s): 1994Work efforts included: Conducted an audit of the organization's deployed Oracle 7.x-based PeopleSoft Human Resources application environment.PROCTER & GAMBLE, CINCINNATI, OHDates of Engagement(s): 1993 - 1994Work efforts included: Full Oracle 6.x Database Administration and Systems Administration for an HP9000 HP-UX UNIX environment. New development and support of existing mainframe, midrange, and PC based applications.MICRO INDUSTRIES, WESTERVILLE, OHDates of Engagement(s): 1993Work efforts included: Full Oracle 6.x Database Administration responsibilities. Full Systems Administration responsibilities for an HP9000 HP-UX UNIX environment. Support for the firm's use of Oracle Financials applications. Development of an integrated payroll / cost accounting tracking system.AMERITECH SERVICES, CHICAGO, ILDates of Engagement(s): 1989 - 1993Work efforts included: Full Informix SE 4.0 and Oracle 6.0 Database Administration responsibilities. Full Systems Administration responsibilities for NCR 3445 and NCR 3450 UNIX environments. Design, project management, development, and implementation responsibilities for a large-scale Decision Support platform. Hardware and software evaluation/selection.POPULAR CREEK MUSIC THEATRE, CHICAGO, ILDates of Engagement(s): 1991Work efforts included: Hardware and software evaluation/selection. Configuration and installation of the firm's personal computers and peripherals in a small network environment. Hardware and software trouble shooting.BOISE CASCADE OFFICE PRODUCTS, ITASCA, ILDates of Engagement(s): 1986 - 1989Work efforts included: Management consulting to branch personnel at the organization's geographically dispersed locations. Development of regional purchasing and warehousing strategies for the various branch locations. Evaluation of potential purchasing and inventory management software tools and applications. Subject matter expert on the organization's primary forecasting and replenishment application tool.Hewitt Associates, Lincolnshire, ILDates of Engagement(s): 1983 - 1986Work efforts included: Defined Contribution Consulting supporting clients monthly/weekly process of 401(k) plans. Software quality assurance testing of base-release software. Project management for development/enhancements of a state tax reporting subsystem for 401(k) plan disbursements. |
