SUMMARY:

• Provided lifecycle support for new Medicare/Medicaid Pharmacy applications and databases implementation for major clients.
• Provided day to day and 7 x 24 production support for large mission critical online (OLTP) Medicare/Medicaid Pharmacy databases running on Oracle, Oracle RAC on IBM AIX environments.
• Provided support to development team with database cloning, application upgrades and database recoveries for data correction using Delphix, RMAN and Oracle data pump utilities.
• Provided HIPPA compliant database security, user auditing, company wide application and database change control.
• Lead the successful Oracle database migration project from Coventry Health to Magellan health Care.
• Participated in yearly strategic off - site disaster recovery plans and exercises on third party locations.
• Provided DBA support for data warehouse running on Confidential .
• Provided technology review and developed implementation technologies and strategies for multiple clients enabling them to implement and upgrade successfully within allocated time and budget.
• Managed development of major database design and deployment projects for new Oracle financials implementations and upgrades across several major companies employing the resources of cross-functional team members encompassing management, staff and outside consultants.
• Provided senior level DBA management of (25) production and (12) development Oracle financial applications, e-commerce applications, data warehouse and home-grown databases for CGISS/ Confidential Global Sales and Support group. Supervised 2 Junior DBA’s and provided development and production support to various personnel in this role.
• Provided senior level DBA management for Sony corporations North American Oracle financials development and support operations maintaining 100% uptime.
• Formed Oracle consulting practice providing Oracle DBA services to several Fortune 100 clients.
• Engineered deployment plans for 19 Oracle databases sites within the United States for RR Donnelley & Sons Company.
• Designed Oracle database security plans for all 23 databases sites of RR Donnelley & Sons Company.
• Completed over 20 Oracle database, financials and manufacturing applications installation and upgrades on numerous hardware platforms.

EXPERTISE AREA:

• Project Planning, Project Management, Business Analysis, System Design, Data Modeling, ER Modeling, Logical Database Design, Physical Database Design, Applications Design and Development and User Training, Database Administration, Backup and Recovery planning, Database Performance tuning. Oracle databases and Financial Applications implementation and upgrade.

TECHNICAL SKILLS:

• Oracle RDBMS 12C, 11C,11g, 10.2.0.4, 9.2.0.3 (9i), 8.1.7, 8.1.6 (8i), 8.0.5, 7.3.4, 6, Oracle Real Application Clusters (RAC), Oracle ASM & Dataguard, RMAN, Oracle Enterprise Manager Grid Control (OEM) 12C, 11C, Oracle data pump, TOAD, Delphix, Aginity workbench tools, Fusion Middle Ware, Talend software, SQL*Forms,, SQL*Plus, SQL* Reports,SQL*Reportwriter, SQL*Net, Oracle Application Server 3.0, 9iAS, Oracle Financial Applications 10.5, 10.7SC, 11.02, 11.03, 11.5.3 (11i) and 11.5.9 (11i).
• H/W & O/S: HP9000 N-class, V-class server operating on HP-UX 10.2, 11.0, Sequent Numa running Dynix Ptx 4.4, Sun Sparc 1000 server operating on Sun Solaris 2.5, IBM RS600 Series: SP 9076, 7013/J40, J30, R50, Power PC 7 248 702 5/F 40 702 5/F50 operating on AIX 4.3, IBM P630 with Aix 5.2, SSA disk array, XP256, EMC drives, Windows, Linux, Confidential Virtual appliance

PROFESSIONAL EXPERIENCE:

Confidential, Schaumburg, IL

Sr. Oracle DBA

Responsibilities:

• Installed and managed day-to-day operations of Oracle 12C and 11C databases for various client in this consulting assignment.
• The assignment include automation of various performance jobs, RMAN backups, data pump utilities to keep logical backups for various schema's.

Confidential, Chicago, IL

Senior Oracle DBA

Responsibilities:

• Monitor daily activities of all production Oracle data warehouse, and database running Fusion middle ware and Talend database using EM12C with performance pack on Linux servers.
• Perform On-Call duties and supported the Oracle development group with creating and cloning new databases using traditional technologies and Delphix appliance.
• Monitor Netezza database using Aginity workbench tools and Confidential Administrator tools.

Confidential, Downers Grove, IL

Senior Oracle DBA

Responsibilities:

• Monitor daily activities of all production Oracle RX point-of sale systems running on IBM unix servers.
• Assign database assignments, new projects OnCall duties and supervise daily activities of senior and junior Oracle DBA’s.
• Provided weekly database status to Sr. Oracle Manager.
• Lead successful data center migration for all Oracle data bases from Arizona to St. Louis data center for company merger.

Confidential, Lisle, IL

Senior Principal Consultant

Responsibilities:

• Installed Oracle 9.2.0.4 database and provided DBA services for Language translation application system running on Linux server. Converted PostgreSQL Server DDL to Oracle 9i serve DDL.

Confidential, Auburn, ME

Responsibilities:

• Provided installation and maintenance services for Baan IVc4 production ERP system running on IBM P630, AIX 5.2, Pseries server. Installed Oracle 9.2.0.3 and Bann IVc4 with automotive extension. Created users, volume group and logical volumes and system setups.

Confidential,Elmhurst, IL

Responsibilities:

• Implemented Oracle financials & manufacturing version 11.5.9.
• Provided DBA support for development and production activities for Oracle financials and manufacturing applications version 11.5.9, database version 9.2.0.3 running on IBM RS6000 servers.

Confidential, Southborough, MA

Responsibilities:

• Supported the production and development DBA activities for Oracle financials and manufacturing applications version 11.5.3, database version 8.1.6 running on HP9000 N-class server.
• Upgraded Oracle financials & manufacturing database version 8.1.6.3 to 8.1.7.2

Confidential, Woodcliff, NJ

Responsibilities:

• Supported the production and development DBA activities for Oracle financials and manufacturing applications version 11.03, database version 8.0.6 running on HP9000 V-class server.

Confidential, Lombard, Illinois

Responsibilities:

• Provided production and development DBA support services for the Lawson financials applications. Oracle Sever 8.1.6 running On Windows NT.

Confidential, Schaumburg, Illinois

Responsibilities:

• Installed Oracle Financial Application 11i (11.5.3) running on HP9000
• Installed Oracle 8i for custom application use on IBM RS6000
• Upgraded Oracle Application AP system from 11. 02 to 11 .03 and database version from 8.0.4 32 bit to 8.0.5 64 bit on IBM RS 6000
• Upgraded Oracle financial application 10.7 char to 11i (11.5.3) on IBM RS6000
• Supported, resolved and maintained the production and development activities of e-commerce databases, Data Warehouse, GL, AP, AR and custom Financial applications.
• Upgraded all database and applications for Y2K compliance by applying oracle financial Y2k patches and upgraded the database to the Y2K supported versions.
• Upgraded the 10.7 AR system from 7.3.3 database to 7.3.4

Confidential, Chicago, IL

Senior Consultant II - Lead DBA

Responsibilities:

• Installed Oracle database 7.3.4.1 on Sun Sparc server 1000 running Sun Solaris 2.5
• Installed and maintained Oracle Financial database 10.7, 10SC product 16.1
• Installed Oracle smart client 10.7SC on Windows 3.11 & Windows 95
• Created the physical database layout for (6) database for optimal performance
• Providing the DBA support for internal software development activities
• Supporting the internal Oracle financial upgrade and implementation activities

Confidential, Downers Grove, Illinois

Responsibilities:

• Supported the implementation activities of Oracle Financial systems 11.0.2 and Database Server 8.0.4 on Sequent Numa server.
• Performing day-to-day database administration duties on (22) production and development Oracle instances running on (6) Unix servers
• Supported the upgrade process of ADP payroll system on Oracle 7.3.4 instance running on Sequent Dynix Ptx 4.4.2 O/S
• Supporting the upgrade process of manufacturing application, Adge on oracle 7.3.4 instance running on Sequent Dynix Ptx 4.4.2 O/S
• Providing the DBA support and Oracle applications patch management functions for Oracle Financial rel 11.01 implementation projects on Oracle 8.0.4.3, running on Sequent, Numa architecture, Dynix Ptx 4.4.2 O/S
• Providing the DBA support to 17 external consultants on Oracle Financial rel 11.02 implementation project
• Supporting the internal user and development staff of Confidential by creating Oracle users, Oracle instances, cloning Oracle production instances to create development environment, providing guide lines in physical layout of files and disk layouts for optimal performance on Sequent systems.

Confidential, Chicago, Illinois

Responsibilities:

• Provided the technical DBA support activities for the upgrade of Oracle Financial 10.5 GL, AP, and FA to Oracle Financial 10.7 product 16.1 on HP9000 server.
• Actively participated in submitting the RFP’s for implementation & upgrade of the
• Oracle financial system.
• Created the detail work plans for GL & AP upgrade from 10.5 to 10.7 and
• implementation of the 10.7 FA modules.
• Selected the functional & technical team for Oracle Financial GL & AP
• Upgrade and new 10.7 FA implementation.

Confidential, Chicago, IL

Database Administrator

Responsibilities:

• Placed deployment plans for another 19 Oracle databases sites
• Design Oracle database security plans for all 23 database sites.
• Install Oracle on HP 90 00- 220 KV running HP-UX 10.01.
• Install Oracle clients running on Windows 95.
• Manage manufacturing databases running vertical manufacturing applications, BAAN, Dorthy and custom packages.
• Helped in creating backup and recovery plans using Omni back software and Oracle Enterprise backup utilities.
• Evaluated and recommended performance monitoring and database reorganizing tools.
• Set corporate standard in database performance monitoring and Oracle database reorganizing tools.
• Help Delphi developers and development users, with Oracle related problems in the development environment.

Confidential, Chicago, IL

Principal Consultant

Responsibilities:

• Provided extensive project support on Oracle databases and application products.

Confidential, Ledyard, CT

Responsibilities:

• C ustomize Standard Oracle Order Entry screen, Forms 2.3, so users can select standard Food & Beverage Template and have the functionality to select product numbers and product descriptions from pre-defined Food & Beverage Template.
• Users can also view the Quantity on hand and Available to Promise quantity on screen while the items to order are being selected.
• Designed and delivered new Order Template screen for Food & Beverage Department. Wrote reports in SQL*Plus to print Food & Beverage Templates & Order Entry Form

Confidential, Kansas City, KS

Responsibilities:

• Project lead for installation of Oracle Corporate Repository System.
• Managed a team of 5 consultants & $86K budget Created Project plans for Corporate Repository & Customer Relations Toolkit.
• Delivered Corporate Repository server, based on Oracle Database 7.1.6, Developer 2000 & Text Server 3.1 on Sun Sparc server 20 running Solaris 2.51.

Confidential, San Mateo, CA

Responsibilities:

• Supported Data Base built and Q&A of data loading activities

Confidential, San Francisco, CA

Responsibilities:

• The scope of the Q&A was to understand the project management, activities, tasks, tools and overall success of the project through management point of view.
• I interviewed all high level project team members including project director, assistant project director, project lead, DBA and senior team of programmer’s.
• Delivered a complete finding & solutions to the project director.

Confidential, Maywood, Illinois

Responsibilities:

• Supported Veteran Claims processing logical & physical data base design activities.

Confidential, St. Charles, IL

MIS Manager

Responsibilities:

• Organized and developed Management Information System utilized Oracle 6.x database, SQL*Forms, SQL*Report, SQL*ReportWriter on Unix platform. Managed various IS budgets
• Developed and implemented Corporate Management Information System.
• Designed and developed a logical and physical data base.
• Developed mission critical and decision support applications.
• Developed applications for Manufacturing, Inventory, Purchasing, Order Entry, Job Costing, Shipping, Receiving, and Product Scheduling systems.
• Maintained data security for the Management Information System.
• Created policies and procedures of MIS system.
• Evaluated new technologies, purchased software & hardware.
• Implemented new applications and trained personnel in hardware and software usage.
• Managed a four-person team effort, reviewed resource requirements, projected yearly budget, resource requirements and project time line.

Confidential, St. Charles, IL

MIS Manager

Responsibilities:

• Managed Research and Development projects on pressure regulating valves and hand valves.
• Utilized AutoCad 12 on Sun Sparc2, Macintosh and DOS based platforms.
• Wrote programs in Autolisp to improve drafting process in pressure vessels.
• Designed and developed a Hot Gas Defrost valve for industrial refrigeration systems.
• Worked on a Slug suppressing device for refrigeration system.