SUMMARY

• Confidential TEMPhas had a unique opportunity to manage and design multiple Case Management / Data Service / Warehouse opportunities as well as multiple ERP implementations.
• He TEMPhas worked wif customers to analyze and define their strategic reporting needs using various methodologies, tools, and technology.
• His success is a result of his ability to quickly assess teh task at hand, plan and implement teh optimal solution.
• Confidential brings over 30 years of Confidential experience in designing, developing, managing and implementing Information Systems and Data Warehousing.
• He TEMPhas served as a Program Director, Project and Technical Manager on various Oracle Application upgrades / implementations and data warehouse / Confidential support system engagements.
• Activities has included requirements analysis, chart of accounts design, system design, data conversion design, logical and physical database design, originating design and operational concepts, scheduling and mapping task plans, and performing project - specific resource allocation.

TECHNICAL SKILLS

Languages: C, Java, PL/SQL, SQL, COBOL

Databases: Oracle 12c, Oracle 11g,10g, 9i, 8i, 8, 7.x, DB2, Teradata, MS SQL Server 2008, 2005, 2003, 2000, MySQL, MongoDB, Progress, MS Access

Operating Systems: Unix, LINUX,Sun OS 5.6, Windows Vista,XP,2000,NT,98,95

Oracle Applications: R11i, R11, R10.7,R10.5,R10.3.5

Oracle Applications Modules: Accounts Receivables, Accounts Payables, General Ledger, Cash Management, Project Accounting, Fixed Assets, Global Accounting Engine (AX Payables, AX Receivables), Purchasing and Inventory, Order Management,Process Manufacturing

Applications Components: Application Object Library (AOL), Oracle Alerts

Oracle Tools/Components: Fusion Middleware tools (BPM, ADF, BPEL, OVD, OID, OAM, etc), Oracle Workflow 2.6, Oracle Reports9i, Oracle Forms9i, Oracle Discoverer, SQL*PLUS, SQL*LOADER, OBIEE, BI Publisher, Oracle Warehouse Builder

Hardware Platforms: IBM RS/6000, HP UNIX, LINUX,Pentium PCs as clients in a client-server set up

Software/Tools: CA ERWIN, Oracle Designer, TOAD, Clarify, COGNOS, Confidential Objects, INFORMATICA, IBM InfoSphere DataStage, ODI, OBIEE and OPTIO

SUMMARY OF EXPERIENCE

Confidential, VA

Data Architecture

Responsibilities:

• me was part of a fifteen person team and our four (4) person data base and online transaction procession (OLTP) team that redesign and develop teh Confidential Process Management (BPM) teh new PHMSA Investigation Inspection Enforcement (PIIE) system, Corrective Action Order (CAO) system, Safety Related Condition Report (SRCR) system and Notice of Probable Safety Order (NOPSO) system and using JBoss’ jBPM and Oracle’s Fusion Middleware suite (ADF, OEM, OBIEE, BI Publisher, OAM, OVD, OID, UCM, Web Portal) Oracle SQL Developer and Data Modeler.
• Reviewed teh PHMSA enterprise architecture determining how teh new systems will integrate into their architecture.
• Design & develop new data structure for each new system including any staging structures that may be required for each new system.
• Expanded teh FIM Investigation process to host and process data from our new systems.
• Refactored existing USR MGMT & WMS systems for more efficiency in working wifin teh new systems.
• Design & develop teh BPM and OLTP processes for system based on Confidential rules.
• Design& develop asynchronous interface from PHMSA’s Investigation Assistant (IA) to existing FIM and new systems.
• Design & develop synchronous interface from PHMSA’s Operator Data Entry System (ODES) and PHMSA’s Pipeline Data Mart (PDM) to existing new systems.
• Design & develop various standard and ad-hoc report templates for teh new systems.

Confidential, VA

Solution Architect

Responsibilities:

• Designed and managed multiple Data Warehousing and Fusion BPM opportunities. Manage resources and tasks engagements based on teh identified Confidential requirements. Engagements included:
• Pipeline and Hazardous Materials Safety Administration (PHMSA), October 2015 - April 2018. Responsible for a fourteen (14) person team that redesign teh existing Work Management System (WMS) and teh Failure Investigation Module (FIM) as well as design and deliver a new Facility Response Plan (FRP) system and a new Contact Management System (CMS) using Oracle’s Fusion Middleware suite (ADF, OEM,BPM, BPEL, OBIEE, BI Publisher, OAM, OVD, OID, UCM, Web Portal). Additionally, PHMSA requested EDC to review teh existing infrastructure and provide recommendations to fine tune their hardware.
• Designed and developed a new cloud computing infrastructure to host teh PHMSA portal and applications.
• Created a new WMS portal that will house all PHMSA applications, as part of teh process our team migrated many of legacy application to teh new portal.
• Provision were for high level OBIEE analytical reports across all application.
• Created a new FRP application that allows PHMSA personnel to monitor and approve response plans for pipelines across teh US.
• Refactored existing FIM system more efficient wifin teh new WMS portal application.
• Created a new contact management system incorporating Pipeline and Hazardous Material contacts into one application.
• Bureau of Alcohol, Tobacco, Firearms and Explosives (ATF), December 2012 - September 2015. Responsible for a five (5) person team.
• Designed and developed Oracle Identity Management System and OBIEE Case Management Portal for ATF.
• Designed an enterprise security model. Designed and developed a single sign on (SSO) process providing a single source to log into you're portal and be allowed access to all ATF legacy applications.
• Introduced Cloud Computing to ATF. Using Oracle SOA suite and Virtual Manager to create high availability “Platform As A Service (PAAS) and “Software As A Service” (SAAS) virtual machines for ATF.
• Designed and developed best-in-class Confidential Intelligence (BI) solution based on Oracle’s Confidential Intelligence Enterprise Edition data warehouse solution (OBIEE). This included an enterprise warehouse that drew data from ATF’s legacy application. Teh solution imported and integrated ATF’s key focus areas such as criminal investigations, industry inspections, case management, Frontline Assessment model, geospatial solutions and Key Performance Indicator (KPI) for Department of Justice as well as integrated external data from key Department of Justice agencies into teh enterprise warehouse and OBIEE analytics.

Confidential, MA

President

Responsibilities:

• Designed and managed multiple ERP and Data Warehouse opportunities.
• Managed resources and tasks for ERP and data warehouse / Confidential support system engagements based on teh identified Confidential requirements.
• Confidential, June 2011 - November 2012. Responsible for refining teh Confidential requirements, designing new database structures, designing inbound interfaces.
• Confidential,, June 2010 - May 2011. Designed and implemented financial analytical warehouse and transactional data store. Designed teh new database structures, designed inbound interfaces, and redesigned teh portal application and developed all components of this project.

Confidential, PA

Director Delivery Services

Responsibilities:

• Designed and managed multiple ERP and Data Warehouse opportunities.
• Managed resources and tasks for ERP and data warehouse / Confidential support system engagements based on teh identified Confidential requirements.
• Engagements were in teh steel industry, multinational fine ingredients organization, multinational biopharmaceutical company, chicken processing, and manufacturers of generic pharmaceuticals.
• Engagements included:
• Confidential, Designed and Led an Oracle ERP implementation for a Fortune 1000 chicken processing company.
• Implemented Oracle Financials, Order Management, Process Manufacturing, and Human Resources.
• Confidential, Planned and implemented Oracle OBIEE implementation for Fortune 1000 steel manufacturing company.
• me was responsible for leading teh JAD sessions, defining teh Confidential requirements, designing and developing teh portal for Key Performance Indicators as (KPIs).

Confidential, NH

Director Delivery Services

Responsibilities:

• Designed and managed multiple ERP and Data Warehouse opportunities.
• Manage resources and tasks for ERP and data warehouse / Confidential support system engagements based on teh identified Confidential requirements.
• Engagements were in teh data and record management, Avionic and medical devices, and hospitality.
• Confidential, May 2007 - September 2007. Planned and implemented HR Daily Confidential Intelligence (DBI) for worldwide leader in data protection and record management. Led JAD sessions, Defined teh Confidential requirements, designed Global HR Reporting Strategy and implemented teh internal HR intelligence Dashboards and Key Performance Indicators as (KPIs).
• Confidential, December 2006 - August 2007. Designed and managed teh implementation of corporate portal system for a regional biotechnological organization. Designed and developed teh security model that interfaces wif LDAP security, providing access to several other portals include a SharePoint document repository and Noetix Oracle application reporting portal. Designed and developed all KPIs as well as redesigned and created an operational data store for clinical data.
• Confidential, January 2006 - November 2006. Designed and managed teh implementation of corporate portal system and financial warehouse for a Fortune 100 multi-national hospitality company. Designed a reporting warehouse that identified Diamond customers, as well as provide a member point summary. In addition, developed a combined customer master using a custom master data management process.

Confidential, MA

Director Consulting Services

Responsibilities:

• Designed and managed multiple ERP and Data Warehouse opportunities.
• Managed resources and tasks for ERP and data warehouse / Confidential support system engagements based on teh identified Confidential requirements.
• Engagements were in teh retail office products, specialized computer network, entertainment enterprises, and financial industries.
• Staples, March 2005 - December 2005. Designed and managed teh implementation of financial data warehouse for a Fortune 100 multi-national retail consumer company. me was responsible for defining teh Confidential requirements, estimating project timing and costs, securing project resources, designing and developing teh warehouse, staging, operational data store and designed and developed all KPIs.
• Confidential, September 2004 - February 2005. Designed and managed teh implementation of financial and delivery data warehouse for worldwide leader in package delivery. me was responsible for defining teh Confidential requirements, estimating project timing and costs, securing project resources, designing and developing teh warehouse, staging, operational data store. Additionally, created master data service for product and customer.
• Confidential, June 2004 - August 2004. Developed strategic warehouse assessment for worldwide leader in package delivery. me was responsible for leading teh JAD sessions, defining teh Confidential requirements, designing teh Global Reporting Strategy and Warehouse environment, designing a logical model for teh US implementation of this warehouse environment and prepared an implementation roadmap.
• Confidential, October 2003 - May 2004. Designed and developed warehouse and master data management service for an international provider of financial services and investment resources that help individuals and institutions meet their financial objectives. me was responsible for reviewing designing and developing warehouse, staging and reporting structures.
• Confidential, April 2003 - June 2003. Developed strategic portal assessment for worldwide leader in train engine manufacturing. me was responsible for analyzing their current warehouse and source systems, defining teh warehouse and implementation roadmap.
• Confidential, April 2002 - March 2003. Managed teh implementation of expense portal system for worldwide leader in polymer plastics. me was responsible for defining teh Confidential requirements, designing teh warehouse, reporting KPIs, and managing teh project through successful implementation.
• Confidential, May 2001 - March 2002. Design and implemented a sales and marketing portal system for worldwide leader in aircraft engine manufacturing. me was responsible for defining teh Confidential requirements, designing teh portal, designing teh PDA screens, designing teh data marts, web screens and managing teh project through successful implementation