SUMMARY:

• Business - focused information technology consulting professional with technical disciplines in data architecture data modeling, database management and ERP implementations. Fifteen years of overall experience in information technology, including Big 4 consulting with Accenture. A business and technical leader and “go-to guy” for enterprise-class IT projects. Strong written and verbal communicator with ability to converse and produce documentation at both executive and peer levels. Industry experience includes telecommunications, financial industry, semiconductor, and public sector.
• Conceptual, Logical and Physical Data Modeling BI and Data Warehousing Solutions
• Oracle Database Administration Oracle E-business Implementation
• SAP Implementation Project Management
• Requirements Gathering Business Analysis

TECHNICAL SKILLS:

Data Modeling Tools: ERWin, TOAD Data Modeler, ER/Studio, Visio, IBM Rational Data Architect

Databases: Oracle RDBMS v 7.x, 8.x, 8i, 9i, 10g, DB2 UDB, Microsoft SQL Server 2005

ERP Applications: SAP 4.6, 6.0, Oracle Financials 10.7, 11i (GL, AP, AR, PA, FA, Federal Financials) Supply Chain 11i (INV, PO, BOM, iProcurement), HRMS 11i (HR, PAY), PeopleSoft ERM, Oracle Manufacturing

Tool: /Application Specializations: OBIEE, Cognos, Oracle Dataguard, Oracle Streams, RMAN, Oracle Enterprise Manager, Oracle Grid Control, PL/SQL, TOAD, Quest Shareplex, DBArtisan, Oracle Warehouse Builder, SAP Business Warehouse, WebLogic, ATG Dynamo, Blue Martini, PeopleSoft, HP-OpenView, Tivoli, Informatica Powercenter 5, Veritas Clustering, MC/ServiceGuard, HP-Omniback.

Hardware/Operating Systems: Sun Solaris, HP-UX, AIX, DEC UNIX, EMC Symmetrix Fibre-Channel SAN, BCV s, DEC Tru64, Windows

PROFESSIONAL EXPERIENCE:

BI Architect/DBA

Confidential

Responsibilities:

• Architected and designed master data management solution using SAP MDM (Master Data Management) module to create cross-functional data warehouse repository comprised of 110 categories integrating information from SAP, Oracle 11i Apps, and various legacy applications.
• Provided SAP Basis/Netweaver support as part of O&M (Operations & Maintenance) team for SAP ECC 6.0 implementation, including XI, Portal, and BI running on HP-UX servers in HP Continental Cluster high availability environment.
• Provided Oracle DBA support using SAP DBA and BR*Tools for 10G databases
• Executed backups using HP Data Protector
• Developed dimensional data models for Department of Homeland Security (DHS) Chemical Security Assessment Tool (CSAT) data mart.
• Installed and configured Oracle Enterprise Manager 10g Grid Control for Linux and Windows environments
• Installed and configured Oracle 10g Application Server and 10g RAC database on Red Hat Linux
• Installed and configured Oracle 10g RAC in Red Hat Linux environment.
• Installed and configured Oracle’s Warehouse Builder version 10gR2

Senior Data Architect/Project Manager

Confidential

Responsibilities:

• Lead data architect for the Single Stack Operational Support System (OSS) for Verizon Business; a global service delivery and service management platform for telecommunication services.
• Architected and designed conceptual, logical, and physical data models using E/R Studio for Enterprise Order Manager (EOM).
• Architected and designed dimensional data models for EOM data mart: an enterprise management reporting and analysis of telecommunications orders and the overall provisioning life cycle, which
• Performed data architecture, logical and physical data modeling for SQL Server 2000 PMI privilege management system.
• Developed ETL framework for PMI system using SQL Server Data Transformation Services (DTS) for replication of Oracle 10g database and loading file feeds from upstream systems in to SQL
• Installed and configured Oracle Enterprise Manager 10G Grid Control, including deploying agents to operating systems, app servers and database servers.
• Installed, configured and supported Oracle Data Guard and Oracle Streams for high availability and replication to operational data store (ODS)

Senior Oracle Consultant

Confidential

Responsibilities:

• Provided Oracle and infrastructure consulting services to the State of Wyoming Information Technology Division (ITD) and to the Supreme Court of Nevada. Responsibilities included developing enterprise backup and recovery strategy, full Oracle database administration support, Oracle 9i to 10g database upgrade on for court case management systems on Sun Solaris 5.9 Sun-Cluster 3.1 high availability environment. Additionally, configured Oracle Enterprise Manager 10g Grid Control to support enterprise database management infrastructure. Installed and configured Oracle’s Data Guard and Oracle Streams on SunGard Geo-Cluster.

Senior Data Architect/Project Manager

Confidential

Responsibilities:

• Developed conceptual, logical and physical entity relationship and dimensional data models for enterprise justice and public safety software solution that supported investigative case management for federal, state and local law enforcement agencies
• Collaborated with key executive stakeholders to determine key business strategic and tactical business needs
• Managed BI development and implementation project team including data architects, ETL developers and database administrators.
• Forward engineered logical data models into physical Oracle 10G DBMS and provided development DBA support.
• Facilitated and conducted requirements gathering meetings with subject matter experts (SME’s).

Senior Oracle Applications DBA

Confidential

Responsibilities:

• Performed Oracle Financial Applications Rel 11.5.3 to 11.5.6 (GL, CRM, AP, AR, INV, iPro) Multi-Lingual upgrade on IBM RS/6000 Enterprise Servers running AIX 4.3.3 and housed on EMC Symmetrix Fibre-Channel SAN.
• Upgraded Developer 6i Patchset 4 to Patchset 9, Self-Service Framework to 5.6E, Oracle Applications 8.0.6 home to 8.0.6.3, Oracle RDBMS v 8.1.6.2 to 8.1.7.3, and applied Applications Rel 11.5.6 Family Pack.
• Cloned Rel. 11.5.3 and 11.5.6 environments, performed backup and restore activities utilizing EMC BCVs.
• Used EMC Timefinder CLI to associate, disassociate, establish, split and restore for BCV Raid 0+1 disk groups.
• Oracle Applications DBA support of implementation partner on Rel 11.5.3 integration of HRMS and Payroll with Rel 11.5.6.

Senior Oracle Applications/DBA

Confidential

Responsibilities:

• Responsible for architecture, installations, upgrades, configurations and support of Oracle Applications 11i E-business Suite in a Tru64, Trucluster operating environment for the Marconi PLC project.
• Developed patch-tracking management processing system and bug log and tracking procedures. Duties included single and multi-tier installs, upgrades, patching, cloning of the Oracle Applications Rel 11i (GL, HR, PA,FA, AP, AR, INV, PO, BOM, CRM, ONT, BIS, APS, Federal Financials, WF).
• Provided Oracle database architecture, database analysis, design, development and administrative support services for Internet Development Group.

Corporate Data Manager/Oracle Apps DBA

Confidential

Responsibilities:

• Corporate Data Manager and team leader of 4 data architects/DBA's responsible for corporate database infrastructure planning for Oracle and SQL Server database management systems in the worldwide corporate data center, which consisted of 75+ HP 9000 N and L class servers and EMC storage arrays across a fiber channel and gigabit Ethernet LAN.
• Developed and implemented database services and operational support plan for datacenter solutions and applications, including SAP 4.6, Oracle Applications Rel 11.x (BOM, BIS, HR, INV, OFA, PO, AP, AR), data warehousing and custom application systems.
• Database monitoring, tuning, patching, and administration of Oracle 11.x and SAP application environments.
• Utilized EMC Timefinder CLI for management of BCV’s.
• Worked closely with system administrators in the installation and configuration of HP-Omniback and HP-OpenView.