PROFESSIONAL SUMMARY:

• Over 17 years of data management, data architecture, data development and analytics solution delivery experience
• Managed BI development teams for over 5 years
• Performed over 5 years in BI development roles using Oracle and SQL Server
• Performed 13 years as an Oracle eBS database administrator with Oracle Core DBA experience
• Created java web app and custom shell monitoring tools for proactive support of eBS environments
• Managed all levels of a java web application architecture on unix and linux
• Have differentiated database management experience
• Completed Cloudera Hadoop Administrator training
• Have light java web architecture development, having built a reporting utility with Jersey JAX - RS, DataTables js libraries with JSON and XML output
• Have unique startup company experience and supported multiple nonprofit organizations by providing web capabilities through open source architectures in linux, php applications, mysql, and the java JSF framework
• Solid communication and writing skills

AREAS OF EXPERTISE:

• Data Systems Architecture Database Administration BI Data Modeling Oracle Applications Database Admin
• Prototyping System Development Lifecycle Expertise
• CERTIFICATIONS, TECHNICAL TRAINING, AND PROGRAMMING EXPERIENCE shell scripting-PL/SQL (primary skills) OCP Oracle Database Admin. 8i java/JSF/T-SQL (secondary skills) Multiple BI Courses (class w/ R. Kimball)
• Java/Java Web App College Courses Linux CentOS 5 and 6/XenCenter for PoC
• Cloudera Administrator Training For Apache Hadoop

EXPERIENCE PROFILE:

Confidential

Oracle eBS DBA/Upgrade DBA

Responsibilities:

• Part of a DBA team for upgrading eBS from version 11. .2.4. Upgrade role focused on setting-up, maintaining and utilizing Oracle 11.2.0.4 standby databases (Data Guard) on linux over an MPLS network for an eBS cloud implementation. In addition, performed Discoverer, ConfigSnapshot, and UPK implementations for integration with eBS 12.2.4.
• Performed post go-live eBS 12.2.4 maintenance to include patching with adop, monitoring with Grid Control and shelling scripting, cloning, database CPU patching, environment documentation and code release procedures.
• Performed in BI modeling and process support consulting role for an eBS and SQL Server data warehouse project utilizing SQL Server Integration Services (SSIS) and Oracle Business Intelligence Enterprise Edition (OBIEE).
• Oracle Applications DBA for 11i environments running on HP-UX and linux servers. Performed clones, RMAN recoveries, Grid Control monitoring, code deployments, performance tuning and general maintenance work.
• Responsible for creating and implementing a variety of data management documentation, to include data flow diagrams, architecture diagrams, scoping documents, standards documents, project task documents, cloning documents, installation documents and patching documents.

Confidential

BI Manager/DBA

Responsibilities:

• Manage a team of 3 Microsoft Business Intelligence developers in addition to performing as an Oracle and SQL Server DBA. The Microsoft BI technology consists of a SQL Server data warehouse and ETL (SSIS), SQL Server Reporting Services (SSRS) and SQL Services Analysis Services (SSAS). Perform as lead for modeling design, implementation and internal consulting. Performed PL/SQL development, shell script development, T-SQL development, Oracle and SQL Server database backup and recovery. Co-led introduction and implementation of Tableau.
• Performed in overlapping role as the BI Manager and primary Oracle Applications (eBS) DBA saving Confidential over $125 K in managed services costs between 2011 and 2014.
• Support architectures with Solaris, Oracle (eBS/iStore-java web application) and Microsoft BI.

Confidential

Oracle eBS DBA/Core DBA

Responsibilities:

• Supported five Oracle eBS 11i environments with iStore (e-commerce) for development, test, and production, and one administration database. Familiar with using Data Guard. Managed version control, code migrations, utilize RMAN for backups, and performed cloning in support of various development efforts.
• Provided project support for other business channels of Confidential implementing Oracle eBS R12 and Hyperion. This project support focused on international R12 printer deployments, general performance troubleshooting and the deployment and setup of servers for Hyperion.
• As part of a systems consolidation effort within DJO, participated as the Oracle eBS subject matter expert for choosing a managed service organization to support the future global IT operations of DJO.
• In support of the Oracle iStore implementation (direct.empi.com), performed design work and migrated legacy Oracle eBS environment to new infrastructure (EMC SAN, servers, secure network, load balancing, and failover).
• Facilitated initial SOX compliance efforts. Presented with Jeffrey Hare of ERP Seminars concerning the DBA’s role within SOX compliance at OAUG.
• Performed as a technical developer for implementation of the OnBase imaging system.
• Performed as BI internal consultant for modeling and solution delivery.

Confidential

Oracle eBS DBA/Core DBA

Responsibilities:

• Supported nine Oracle eBS environments with iStore (e-commerce) and one administration database. Upgraded from release 11.5.8 to 11.5.9, and upgraded the databases from 8.1.7.4 to 9.2.0.5. Maintained database backups and security (achieved Ambiron’s web security certification). Performed and managed application patches using the utilities adpatch, adctrl, adadmin, adsplice, adconfig.sh, and the Oracle Application Manager.
• Performed modeling and development in support of Oracle Discoverer reporting requirements.

Confidential

Oracle eBS DBA/Core DBA

Responsibilities:

• Managed six Oracle eBS release 11.0.3 development, test, and production environments. Performed and managed application patches using the utilities adpatch, adctrl, and adadmin. Provided backup support to a sister organization running eBS release 11.5.6.
• Migrated Oracle eBS environments and data warehouse environments from the Spine-Tech facility in Minnesota to a data center in Austin, TX.
• Performed as a BI internal consultant, modeler and developer in support of analytic requirements.

Confidential

Manager, Data Technology

Responsibilities:

• Developed technology plan and architecture to support e-commerce, content management, site personalization, decision support (data warehouse, data mining, click-stream analysis), on-line collaborative reporting, and order fulfillment and processing.

Confidential

Data Management Consultant

Responsibilities:

• Performed as a data warehouse consultant on projects
• Advanced Systems International, HBS International, and Novartis Seeds.