OVERVIEW SUMMARY

• Over twenty 20 years as a seasoned and certified data management professional with enterprise experience as technical lead in the full life cycle development and delivery of information solutions across multiple platforms for government and commercial business. Has acquired and applied knowledge in providing data architecture, master data management, data analysis and delivery of business intelligence processing and reporting solutions using industry standard database management systems and access methods including
• The implementation of Oracle EBS R11i/R12i with AIM/OUM methodologies for ERP, CRM, PLM and MDM applications supporting FEA Federal Enterprise , BEA Business Enterprise , TOGAF, and DoDAF Architectures.
• Database experience in Oracle, IBM DB2/UDB, MS SQL Server,
• data/business process modeling with Ganes and Sarson methodology, BPMN 2.0, and DoDAF 2.0 standards using software tools CA Erwin, IBM Rational System Architect, Oracle Designer, etc,
• design and creation of data warehouse/data marts using ETL tools,
• SOA standards using web service HTTP and HTTPS protocols to parse XML data using Java and PL/SQL languages,
• creation/instruction of classes for database design using third normal form TNF for OLTP transactional and dimensional modeling for OLAP business intelligence processing and reporting,
• design/development of reports using Crystal, Business Objects, SSRS and other tools as needed.
• In addition provided full SDLC design/development/implementation and on-call support to ensure SLA agreements are maintained and processes completed on time. Currently serving on the board of the Southwest Ohio Chapter of the Data Management Association DAMA since 2009 and received Certified Data Management Professional CDMP certification by ICCP/DAMA in November 2011.

TECHNICAL SUMMARY

BI Tools: Business Objects, Performance Point Server, Oracle Discoverer/Reports, 2005 Visual Studio, SSAS Analysis Services, SSRS Reporting Services, Sharepoint Server, Oracle Financial/Sales Analyzer, Cognos/Pentaho Research

Database: Oracle RDBMS 11g, 10g , 9i, 8.x, 7.x, Oracle AQ, SQL Server 2005, UDB Aix, DB2, DB2-2, RDB, Supra/SQL, Total, MS/Access, ODBC/JDBC, Explain PLAN, Automated Workload Repository SQL/Developer, Toad, OLAP server, Teradata training

ETL/Tools: Oracle Appl. Integration EAI , Ascential Data Stage, SSIS Integration Services 2005

EA/LDM: IBM/Rational Systems Architect w/DoDAF 2.0

DB Design: Erwin, Oracle Designer, IBM Rational System Architect, Data/Process Modeling,

IBM Rational Team Concert training

Languages: SQL, MDX, Java Jdeveloper , XML, HTML, PL/SQL, COBOL, Visual Basic3.0, Mantis, VI Editor/Unix Scripting

OLTP: CICS/OS2-CICS, NCR Tranpro, UniKix, Cincom-CM, Tuxedo training

Business Apps: Oracle EBS - R12i, CRM 3i, R11i, PIM, Service, Call Center, eCommerce iStore, iSupport ,

AIM/OUM methods, Oracle Tutor, ERP Financials 10.7 NCA, R11i GL, AP, CE, FA, PA, AR ,

Seimens Teamcenter PLM

HW: Sun Solaris, HP 9000, IBM Mainframe, Pyramid NCR, Personal Computers Laptops

OS: Unix/AIX, Linux, J2EE/JSSE, MVS/ESA-XA, OS2, Windows XP/NT/2003 NCR VRX

MS Office: Excel, Word, Projects, Visio

Methodologies/Architecture: Gaines Sarson, Oracle AIM, Oracle OUM 5.5, BPMN 2.0, DoDAF 2.0, BEA 8/9

EXPERIENCE SUMMARY

Confidential

Role: Business Intelligence Architect

• Responsibilities in the Air Force Defense Enterprise Accounting Management System DEAMS program include DoDAF design, managing IBM Rational System Architect tool for the team, developing integration strategy, and assisting with system performance/scalability issues.

Role: Business Intelligence Architect

Confidential

• Responsibility in the Air Force Defense Enterprise Accounting Management System DEAMS program to define, create, and manage the processes for organization, distribution to/from, and communication of all documents among contractors, vendors, and Air Force DEAMS personnel. These documents support methods and standards, to include Accenture ADM, Oracle OUM/AIM, and DoDAF, for the implementation and sustainment of Oracle EBS ERP system EBS R11i/R12i . This role is critical for the Configuration Management team, involved in the team collaboration of the modernization scope, that includes participation in the validation and verification of the EBS setups and software installation. The plan is implementation of a tool and processes to facilitate the automation of the document management using workflow to manage state-in-time of all documents. This included a review of current process and made software recommendation that is CMMI compliant that will assist with project and automation of document management process.

Role: ECSS Data Architect/Data

Confidential

• team collaboration participation to establish the Way-Forward strategy and plans for data management, data governance, and data architecture that supports the current and future implementation activities for development of the ECSS project Enterprise Architecture EA . This includes process BPM and data model CDM/LDM development and advisory using IBM Rational System Architect as the central repository. Received training on System Architect with DoDAF 2.0 and Oracle Unified Method OUM to use for bridging the data gap between OUM End-to-End E2E processes and the LDM models for purpose of maintaining and sustaining lifecycle of ECSS. Collaborated with working AirForce Chief Architect and ECSS data and process teams.
• providing recommendations for the development of the Enterprise Architecture environment for the Way-Forward that include improvements of the data governance processes using DMBOK principles and incorporation of processes to capture process and data model information in IBM Rational System Architect.
• giving input to Air Force chief architect SA DoDAF 2.0 meta model modifications to support structures for importing information from multiple data sources: Walk-the-Diamond WTD Access DB, LTO E2E in Provision/Visio, contractor E2E in Access DB/Visio.
• working with Oracle OUM to integrate business processes with the Logical Data Model LDM .
• assisting with issues in Blueprinting phase capturing data requirements with WTD technology and participating in the review of requirements with Air Force Subject Matter Experts SME and System Integrator SI team.
• providing data modeling assistance with master data management team and data associations to business processes for Risk Reduction analysis.
• incorporating methodology Air Force Business Environment-ABE for Proof of Concept to ensure completeness of data with simulations to maintain continuity with blueprinting process activities and data objects using Oracle.
• providing production support for problem tickets and data analysis by developing SQL queries to verify, validate, and recommend modifications to production data on Oracle EBS R12i application and Oracle 10g database. Developed solution scenarios for end users to modify business process procedures and to update end user training material.

Confidential

Role: Data Architect, Integration Specialist, Business Intelligence Architect

• Provide consulting services for data integration, data/process analysis and business intelligence design and reporting.

Confidential

• Principal Consultant providing primary responsibility to the Business Intelligence practice and secondary responsibility to the Enterprise Business practice for Master Data Management MDM . Enterprise consulting services were provided to clients with requirements for data integration, conversions and transformations, SOA web services, XML query and parsing , logical and physical data modeling, data base administration/change management, performance tuning, and software upgrades. Roles performed at enterprise clients are as follows:

Confidential

Performance Tuning Specialist

• Write guidelines for training reporting personnel in data model navigation and the conversion of Cognos 7 to Cognos 8 reports across six subject matter areas including AR, AP, Sales, etc.
• Analyze and redesign the Sales Cost ETL process in Informatica for ETL performance improvement to deliver reports more efficiently and in a timely manner.

Confidential

Data Integration Architect

• Perform database administrative services for managing six source database schemas ie. create, backup, restore,etc for data mart
• Design and develop SOA web services and XML Query XQuery to access XML documents using Oracle PL/SQL and HTTP protocol to extract and load data into Oracle database staging tables.
• Create test data for developers using Oracle database utilities and extended feature of varray data structures for capturing periodic
• performance data.
• Install Oracle Warehouse Builder for creation of ETL processes.

Confidential

Data Conversion/Migration Specialist

• Perform data migration services for converting existent Peregrine Incident management transaction centric call center data to RightNow Technologies customer centric call center data.
• Design and develop data migration strategy using Oracle SQL Developer, Microsoft Access, and SQL transformation scripts
• Assist personnel with the data mapping, design tables to convert incident contacts, and develop SQL scripts to generate .CSV
• files for data load into the target system RightNow Technologies database.
• Interface with RightNow Technologies personnel to verify and validate data migration requirements.

Confidential

Role: Data Architect, Integration Specialist

• Train and support Oracle CRM Sales, Service, and Call Center for North American pre-sales support teams,
• Present applications architecture and technology stack for Oracle CRM eBusiness Suite R11i EBS R11i applications software, specializing in the Oracle applications data model and EAI technology strategy.
• Designed call center infrastructure requirements for prospect/client demonstrations. Also produced implementation plan and cost estimates for management approval.
• Demonstrate development use of Oracle EBS R11i technologies workflow, forms, pl/sql, reports, etc. that support the CRM apps.
• Develop responses for RFP/RFI's.
• Develop methodology to document and distribute advanced demonstration techniques.
• Prepare technical and end user documentation using AIM methodology.

Role: Senior Consultant

Confidential

• Manage and develop OLAP data warehouses for consumer packaged goods and document services organizations. Design and develop conversion mapping interfaces for Oracle EBS pre-R11i applications using PL/SQL stored procedures, functions, and triggers for executing data loads and managing data integrity messages.
• Provide performance-tuning expertise and data and process model analysis.
• Write project proposals.
• Design and develop custom reports, forms and alerts using Oracle Forms, Reports, Discoverer and Oracle Alerts/PLSQL triggers.