Seasoned and analytical Information Technology Professional with successful 25 year track record as a Project Manager, Oracle Database Administrator. 20 years Application DBA and 7 years of Oracle development and design experience. Background in consulting and software development life cycle management methodology with ability to create accurate client requirements and design, develop, test, deploy, manage, and maintain critical database solutions that improve operational effectiveness and profitability. A skilled project manager capable of setting expectations, developing realistic schedules, leading technical staff and cross functional teams, resolving critical path issues, and delivering quality results on time. An excellent communicator capable of interfacing at all levels.

Consulting Skills

• Relational database design
• Database development
• Database administration
• Application transition
• System Implementation
• Oracle application installation, implementation, upgrade, debugging, patching, tuning and maintenance
• Requirements documentation and specification
• Design Requirements

Technical Expertise

• Linux RHEL, OEL
• Solaris
• HP 10.2, 11.0 11.1
• A/UX
• Windows NT 3.1, 3.5, 4.x MS Certified, Windows 95, 98 2000, Windows 3.x
• Quest STAT
• Microsoft Project, Word, Excel, PowerPoint and Visio
• Glovia Financials and Manufacturing 3.2, 5.x
• Informix 5.x
• RDBMS 11G, 10G, 9i, 8i, 8.0.x, 7.3.x, 7.2, 7.1, 6
• RAC 11.2
• Oracle Applications EBS 10.2, 10.7, 11.0, 11i, 12.x
• OBIEE 11.x
• Informatica PowerCenter Data Warehouse DAC
• RMAN
• UPK
• Oracle Identity Management OIM/OAM/OID
• Work Asset Management WAM
• Fusion Middleware 11G
• Oracle Enterprise Manager OEM

Experience

Confidential

Principal Consultant

• Upgrade EBS to R12.x.
• Installation of EBS, OBIEE, Informatica Power Center, DAC, UPK and oracle database 11g.
• Install and configure OID/OAM with EBS and Fusion Middleware 11G applications
• Install and configure Work and Asset Management WAM
• Responsible for performing SRR Scans/STIG fixes to Oracle environments
• Research and apply patches following CM methodology to resolve issues and perform quarterly CPU/PSU patches.
• Research and document CPU and PSU patching. Test and deliver patches and documentation to customer.
• Proactively Monitor Customer database instances and Concurrent Managers.
• Document all changes and report to customer on the status of their environment and any future action plans to keep them current with Oracle Support.

Confidential

Senior Application DBA

• Upgrade Oracle CRS and ASM to 11.2 from 10.2.0.4 version
• Support 27 R12 Application with Financial and Manufacturing modules, 11 SOA Application Environments, 5 Infrastructure Environments and 2 GRID servers on a mixture of RAC and Single Node database Servers.
• Responsible for cloning EBS from Production using various methods. RAC-to-RAC, RAC-to-Non RAC and Single Node to Single Node.
• Responsible for performing SRR Scans/STIG fixes to Oracle environments
• Research and apply patches following CM methodology.
• Research and document CPU and PSU patching. Test and deliver patches and documentation to customer.
• Upgrade RAC CRS from 11.1 to 11.2. Migrate the ASM home under the CRS HOME.
• Provide third level support for Application Issues.
• Enforce program design, coding, review, and testing standards and procedures

Confidential

Senior DBA

• Support 27 R12 Application with Financial and Manufacturing modules, 11 SOA Application Environments, 5 Infrastructure Environments and 2 GRID servers on a mixture of RAC and Single Node database Servers.
• Responsible for cloning EBS from Production using various methods. RAC-to-RAC, RAC-to-Non RAC and Single Node to Single Node.
• Responsible for performing SRR Scans/STIG fixes to Oracle environments
• Research and apply patches following CM methodology.
• Research and document CPU and PSU patching. Test and deliver patches and documentation to customer.
• Upgrade RAC CRS from 11.1 to 11.2. Migrate the ASM home under the CRS HOME.
• Provide third level support for Application Issues.
• Enforce program design, coding, review, and testing standards and procedures.

Confidential

Senior Database Lead

• Support Production 11i Application with Financial and Manufacturing modules
• Implement ASCP in Oracle Apps Release 12.1.
• Implement Grid Control for all Oracle instances with AMP3.1 pack, Data Masking, Performance and Tuning
• Implement and enforce SOX methodology for Oracle Applications and databases. Ensure data security and data masking rules to protect corporate data.
• Performance tuning of Database and Application
• Manage DBA team locally and offshore to provide 7x24 support for all Oracle instances.
• Implement Backup Recovery Strategy and Offsite Disaster Recovery Plan
• Clone and Patch all instance to support Change Management policies
• Workflow Administrator.
• Assist Developers and Functional Analysts in troubleshooting issues.
• Company converted legacy AS400 Financials into Oracle 11.5.10 applications. Installed, configured and patched 11.5.10.2 oracle applications
• Cross trained other DBA's and developers with oracle database and development skills.

Confidential

Senior Consultant

• Design and implement change management policy for corporations across the country.
• Install and configure Quest STAT to track software changes to the Oracle applications. Build workflows to support corporate change management policies
• Knowledge transfer the skills necessary to maintain STAT repository to DBA's and System Administrators
• Fully document change management workflow and installation configuration.
• Conduct formal training classes on the following classes
• STAT Administration
• STAT End-User
• STAT Development

Confidential

Senior Technical Consultant

• Designed, Installed, Configured and Patched 10 11.5.10 applications. Implemented the Enterprise Planning and Budgeting EPB module. Continue to troubleshoot and Performance test 11.5.10.x application with EPB for the FIRST program.
• Analysis and map legacy data to be loaded into the EPB dimensions. Troubleshoot data conversions.
• Maintain existing 11i environments, including managing database operations, installing patches, and troubleshooting problems
• Install new 11i environments to support development and testing operations.
• Document installation and operations procedures for the production staff.
• Responsible for performing SRR Scans/STIG fixes to Oracle 11i environments.
• Coordinate with other development leads including interfaces, data, reporting, conversion, and architecture leads to ensure that all teams stay in sync with one another and share information throughout the design, development and test lifecycle.
• Identify risks and issues along with possible mitigation steps for the Technical Manager.
• Mentor and train application developers on the software development lifecycle process.
• Enforce program design, coding, review, and testing standards and procedures.
• Manage the day-to-day design, develop, and test activities of the team.
• Worked with the design team on the next spiral of the Air Force Budget Formulation System, tools included Designer 2000 and Rational Rose.

Confidential

Senior DBA

• Oracle Application 11.5.3 thru 11.5.9. Installed, upgraded, patched and supported company Oracle Applications. Provided 7x24 production support to 11.5.9 applications Finance and Manufacturing . Technical lead on implementing iprocurement and iStore.
• Extensive performance tuning to maintain Business Owners Service Level Agreements. Constant monitoring and tuning to meet these demands. Tuning included Custom code, Application patches and Database/Server adjustments.
• Successfully converted 5 legacy systems into one 11i applications to support the North American Finance and Manufacturing operations.
• Confidential Manufacturing and Inventory data warehouse.

Confidential

Consultant

• Technical director of Software Development for the PPBES program at MacDill AFB. Team consisted of 10 developers and 2 TQM Analysts.
• Planning Programming Budgeting and Execution System and Management Information System PPBES MIS . PPBES MIS is the government financial system that supports the security intelligence group at the United States Special Operations Command. Redesigned the existing PPBES database to enforce the Customers Business Rules and maintain data integrity using Designer 2000.
• Redesigned a Web-front end for PPBES MIS using developer 2000 toolset. Implemented the database conversion at customer site.
• Other duties included any installations, upgrades and backup/recovery of Oracle Software. Perform UNIX administration for 3 Sun Servers. Monitor and administrate the development network.

Confidential

Enterprise DBA

Maintained and provided 7x24-hour support for all Oracle databases for all facilities worldwide. Upgraded and maintained/backup the production, development and month-end database for Chess Chess is the corporate financial database that operates 7x24 for Breed Corporation . Installed and Supported Glovia 5 Beta product in Lakeland and Italy. The Glovia databases ran on the HP 10.2 platform. The servers in the US were running Oracle v7.2.3 and in Italy 8.0.5. De-bug, Performance Tuned and backup shop floor database in Lakeland and Mexico. Install, debug and maintain helpdesk database on NT platform. Performed NT administration on this server as well. Used Enterprise Manager with the Performance Tuning Pack.

Confidential

Senior DBA

• Develop STAT interface and re-engineer Database Design for Data Warehouse using Developer 2000 and Designer 2000. STAT is a statistical analysis tool to help predict the amount of data that will be generated across the WAN so the proper network can be budgeted for in future years. The front-end clients were Windows 95 and NT with the backend server on Sun's or NT.
• Develop a Web interface to Oracle for the PACMEDNET survey using the Oracle Webserver 3.0. The survey was used to collect hardware and software information from the Government bases. The development was on the NT platform with Production on Sun Sparc Station. Provided full Database Administrator Functions, including Performance Tuning. Database versions 7.3.x on NT 4.0 and Solaris 2.5.

Confidential

Enterprise DBA

• Oracle Financials - Managed Oracle Financials Installations. Installed, Upgraded and Maintained 3 Oracle Financial Databases. Started with Financials 9.x, Migrated to 10.2 and then 10.5. Worked with a team of 3 Systems Analyst and 2 Financial Analysts on customization and reporting requirements. The Oracle database was 7.x. The platform was a Sun Supercenter 1000 running Solaris 2.4. Used Forms 3.x and Developer 2000.
• CellCAD - CellCAD was a tool used by cellular engineers to design a cellular network. Installed and Debugged Development Databases Oracle 7.x and Informix 5.x on Sun Solaris 2.4 and NT platforms. Installed, Upgraded and Maintained the Corporate NT Domain. Provided 24-hour support on CellCAD and Unix Administration. Provided CellCAD training at the customer site and on-site troubleshooting. Co-authored the training manual for CellCAD software.
• HelpDesk - HelpDesk is an application used to track customer incidents and their status along with bugs and patches. Led a team of 3 developers in designing and developing a customer support application HelpDesk in Lotus Notes 4.x on an NT 4.x platform. The modules included Helpdesk, Bug Tracking, Feature Request and Knowledgebase. Also co-authored the training manual.
• OIMD - On-line Incident Management System provided end-users immediate access to customer information in order to make better business decisions. Lead a team of 2 analysts on the design and implementation of OIMD. This was built with Oracle 6.x, SQL forms 3.0 on the A/UX platform. The system provided order tracking, incident reporting, bug tracking, order requests, future release requests and 'Hot-Site' tracking Sites that are experiencing an above average amount of trouble calls .
• Technical Support - Provided 7x24 Microsoft Support to the Government as a subcontractor to Microsoft. Products included MS NT, MS Word, MS Excel, MS Access and MS PowerPoint.
• Technical Support - Provided Oracle and A/UX Support for WWMCCS World Wide Military Command Control Services Community. Provided Microsoft Support to the Government as a subcontractor to Microsoft.
• Performed in-depth technical analysis, diagnosis and resolution of technical problems particularly pertaining to relational database management, SQL Server and NT. Migrated the Oracle database for the WWS program. Tracked and solved conflicts between multiple vendor products on the WIS Workstation.
• Developed specialized tools for use in the Customer Support Center. These include templates, training guides, decision support systems and customized reports. Assisted junior level support staff in training of analytical support. Followed up on open incidents and kept the customer informed of status.
• Eagle - Eagle was a financial application written in COBOL on a Bull Mainframe. Updated and maintained the Traveletter database and updated the mainframe on a daily basis. Created a program to assist the accounting personnel in tracking employee relocation expenses and then compiling the data into a report that meets the Government standards. Both databases were in Dbase and uploaded to Eagle. Assisted with writing the conversion and SqlLoader scripts when this system was eventually replace with Oracle Financials.
• Developed macros in Eagle that eliminated 93 of the manually generated invoices for Finance and Accounting. Assisted Customer Administrators with data input and queries on Eagle.