Project Manager Oracle

Michael James Dalton PMP

Senior Programmer-Analyst

Lead Architect, Developer, Analyst

I am a former Marine with 25 years of experience in Enterprise Solution

Delivery, Enterprise Solution Architecture, Business Transformation,

Desktop Automation, Applications Integration, Project Management, Design,

Development, Automated Testing, CLOUD enablement, and Implementation of

Enterprise systems and applications. I have worked for large companies

including: Technical Manager at Oracle Corporation, Configuration/Delivery

Manager and Enterprise Solutions Architect at HP, Software Development

Manager at CACI, and Global Lead for Oracle Solutions Delivery and Testing

at CSC.

I have worked for clients within the Public Sector - U.S. Federal,

Military, and State Government, as well as Fortune 2000 companies in

automotive, banking, insurance, manufacturing, retail, hazardous waste,

healthcare, pharmaceutical, environmental, energy, communications, and

services industries.

My experience within business and IT includes: Project Management, Account

Management, Configuration Management, Enterprise Solutions Architect,

Oracle Supply Chain, Supply Chain Execution, Courseware Development, Oracle

FUSION (FMW), Order Entry, Order Management, Oracle Advanced Collections,

Oracle Shipping, Oracle Inventory, Oracle Procurement, Oracle BRM, Oracle

Data Integrator (ODI), Oracle iStore, Oracle iReceivables, Oracle WMS/MCSA,

Oracle Enterprise Taxation, Oracle Financials, Oracle Advanced Pricing,

ASCP, APEX, XML Publisher, Oracle WebCenter, Maximo, Quick Test

Professional, Qualitycenter, Loadrunner, Hyperion, Siebel, Eclipse,

Informatica, EAI, ETL, SOA/BPEL, TIBCO, Microsoft Dynamics CRM, Oracle CRM,

Oracle Enterprise Taxation, Database, Database tuning/optimization, Oracle

BI/Data Warehouse (OBIEE), BI Publisher, SaaS, PaaS, Pervasive,

Virtualization, CLOUD, SaaS, PaaS, TaaS, DMaaS, etc.

US Citizen and Canadian Permanent Resident, with Department Of Defense NACI

Level Security Clearance

Professional Experience Highlights

Technicall Lead Technical Lead/Senior Manager - Oracle Solutions Delivery

- Oracle and Testing Services: - Senior Technical Lead responsible

Solutions for the technical implementation of Oracle Applications

Delivery & Globally Including: Database, Networks, Hardware

Testing Configurations, Backups/Recovery, patches, Fit/Gap, RICE

CSC Management, Technical delivery, testing, etc.

Client: Responsible for conceptualizing and designing technology

Various: COBHAM solutions for Federal/State Government, and Commercial

Aerospace sectors

Global Rollout; Coordination, Scrum Master, Project Management, time

State of Utah; management

etc. Develop Marketing Content, and other Pre-Sales, Sales, and

Mar/2012 to Post-Sales assets

Present Primary focus on Oracle R12, 11i: Enterprise Financials,

Payroll, HR, Benefits, Supply Chain, Shipping, etc.

Additional experience: APEX, Weblogic Portals CLOUD, SaaS,

PaaS, TaaS, WebCenter, SOA Integrations, BPM/BPEL, FUSION

(FMW), Work Center, Activity Guide, Fusion HCM, Fusion CRM

Oracle 12.1.3 Senior Technical Lead Developer R12.1.3 EBS & HCM: -

Implementation Senior Technical Lead: - Technical Consultant responsible

for the technical implementation of Oracle R12.1.3

Fusionworx/Cibe Including: Database, Networks, Hardware Configurations,

r Backups/Recovery, patches, RICE Management, Technical

Client: State delivery, testing, etc.

of Hawaii Responsible for conceptualizing and designing technology

Mar/2012 to solutions for the State of Hawaii, Department of

Mar/2013 Transportation Federal Grant Systems

Coordination, Scrum Master, Project Management, time

management

Responsible for developing the State of Hawaii Technical

Design documents and coding/unit-testing each work product.

Designs include: conceptual designs, architecture diagrams,

Use case flows, and much more

Design and Code/Unit-Test PL/SQL packages, Alerts,

Workflows, OpenScript, and mod-PLSQL web pages

Confirm Setups, Installation, Unit Testing, External

Systems connections (FTP, SFTP, DBLINK, SFU, etc.); HR,

Benefits

Primary focus on Enterprise Financials, Payroll, HR,

Benefits for State Government

Built a large APEX Portal for interfacing with Federal

Government including 35 Database Objects, 28 reports, 23

forms, 3 web services, and 6 EBS Integrations (AP, GL/SLA,

PA, Grant/Awards, CM, FA); Portal provided Waterfall

Funding for payment of DOT grant funding to Federal

Government

UNIX - JAVA - JavaScript - PLSQL - .NET - Subversion - ANT

- PL/SQL - System Administration - C# - DBA roles -

SysAdmin - BI Publisher - Alerts - Workflow - FUSION (FMW)

- APEX 4.2 - APEX Listener 2

Oracle 11.5.9 Tier 1/2/3 Support of Flesh Company Oracle 11.5.9 eBusiness

Support of Suite: Senior Support Technical Lead - Senior Support

eBusiness Suite Technical Lead Developer responsible for all aspects of

& support for the Flesh Company. Including: Database,

Feasibility/Pre Backups/Recovery, Tuning, patches, upgrades, custom

-Sales for enhancements, Data Mart tuning, etc.

Upgrade to Design and Code/Unit-Test PL/SQL packages and mod-PLSQL web

R12.1.3 pages

including Confirm Setups, Installation, Unit Testing, External

Estimates Systems connections (FTP, SFTP, DBLINK, SFU, etc.); HR,

Fusionworx Benefits

Client: Flesh Responsible for conceptualizing and designing Flesh's

Company roadmap to CLOUD

Nov/2011 to Develop training materials for State of Oregon personnel

Present Data Conversions for Payroll File Uploads

UNIX - JAVA - JavaScript - PLSQL - .NET - Subversion - ANT

- PL/SQL - System Administration - DBA roles - SysAdmin -

APEX 3.0 - BI Publisher - OBIEE - Dashboards - FUSION

(FMW) - Fusion HCM & CRM

Fit/Gap Analysis for new R12 Upgrade to R12.1.3

Lead developer and Technical Manager for R12 Upgrade

project

Oracle Enterprise Taxation Management (ETM 2.1.5, ETM2.2.1, ETM

Enterprise 2.3.0): Senior Configurations Technical Lead Developer &

Taxation Enterprise Solutions Architect - Senior Configurations

Management - Technical Lead Developer and Enterprise Solution Architect

Configurations responsible for installing, supporting, and upgrading all

Manager & releases of the Oracle/SPL ETM applications and framework.

ESB/SOA Design, Develop, and Implement back-end 3 Terabyte Data

Enterprise Warehouse using Oracle OBIEE.

Architect Oracle Enterprise Taxation versions 2.1.5, 2.2.0, 2.2.1,

Fusionworx/HP and 2.3.0

Client: State Also Responsible for all SOA/ESB for all Medicaid/Medicare

of Kentucky for the States of Delaware, Ohio, Wisconsin, Georgia,

Jan/2011 to Florida, Rhode Island

Nov/2011 Subversion, HP Quality Center, C3P0, Micro Focus Cobol,

Hibernate, ANT, Apache Tomcat, Catalina, JAVA, BI

Publisher, OBIEE, Dashboards, Weblogic server, Appviewer,

Config Lab, Blueprint, Dialogue, XAI, ESB/SOA/BPEL, WSDL,

Fusion Middleware (FMW), Work Center, Activity Guide, Form

personalizations, Pervasive PBI, SOA Integrations, Weblogic

Portals

Coordination, project management, time management, work

with team of 7 consultants

Design and Code/Unit-Test PL/SQL packages and mod-PLSQL web

pages

Confirm Setups, Installation, Unit Testing, External

Systems connections (FTP, SFTP, DBLINK, SFU, etc.);

OpenScript, Unix Shell scripting

Develop automations for: Database Backup; Middleware

Backups; Web and Business Server backups; ETM Framework 4

and ETM Tax Backups; etc

Data Conversions for upgrades and Data Warehouse load, etc.

Middleware/Fusion layers and testing of all aspects of the

system

UNIX - JAVA - Javascript - PLSQL - .NET - Subversion - ANT

- PL/SQL - Pervasive - PBI - PDI - Hibernate - C3P0 -

Tomcat - Weblogic - SOA/BPEL/WSDL - Microsoft SQL Server -

APEX 3.2 - BIZTALK

Oracle R12 HR/Benefits Web Development and Deployment: Senior

eBusiness Suite Technical Lead Developer - Senior Technical Consultant for

- Upgrade from the development of Oracle mod-PLSQL web pages and Oracle

11i to R12.1.3 PL/SQL processes to provide for the Health Care of all of

Fusionworx/HP the Educational entities within the State of Oregon.

Client: State Coordination, project management, time management, work

of Oregon with team of 5 consultants

Health Care Design and Code/Unit-Test PL/SQL packages and mod-PLSQL web

Systems pages

Mar/2010 to Confirm Setups, Installation, Unit Testing, External

Jan/2011 Systems connections (FTP, SFTP, DBLINK, SFU, etc.); HR,

Benefits

Develop training materials for State of Oregon personnel

Data Conversions for Payroll File Uploads

UNIX - JAVA - Javascript - PLSQL - .NET - Subversion - ANT

- PL/SQL - Microsoft SQL Server - BI Publisher - OBIEE -

Dashboards

Oracle R12 Financials/OM/P2P/O2C & Data Warehouse: Project Technical

eBusiness Suite Lead - Senior Project Technical Lead Developer for the

- Upgrade from Oracle eBusiness Suite 11.5.10 upgrade to Oracle eBusiness

11i to R12.1.3 Suite R12 - with specific emphasis on Financial Interfaces

Fusionworx to and Fusion Integrations.

Oxford Coordinated team of 3 Line-Managers, 4 local developers in

International a matrix organization

Client: Decker Implement project plans, communication protocols, scoping,

Outdoors Global resource allocations, change management, test

Retail strategy/plans/cycles, architecture, and risk management -

Aug/2010 to mod PL/SQL - PL/SQL Server pages

Dec/2010 Develop XML parsing application using C#.NET

Microsoft Dynamics CRM setup and customizations

Confirm Setups, Installation, Unit Testing, External

Systems connections (FTP, SFTP, DBLINK, SFU, etc.);

Financials, Inventory, Receivables, Cash Management, Order

Entry.

Ability to identify appropriate course of action to achieve

successful project and task completion

Develop reports using Oracle BI Publisher

Also designed and developed a dynamic C#.NET solution for

handling ANY XML file and loading the data into Oracle

tables - this was needed in order to process all the Decker

store nightly cash register closeout files - resulting data

was used to automate the AR receivables processing back to

store over/under

Data Conversions for Store XML files coming in from each

store nightly

AIM - PMBOK - Eclipse - UNIX - JAVA - PLSQL - Subversion -

ANT - .NET - PL/SQL - Pervasive PBI - C# - SOA/BPEL -

System Administrator - FND LOAD - SQL Server

Oracle 11.5.10 e-Business Suite Rapid Accelerator Implementation:

e-Business Technical Lead - Performed project management, requirements

Suite gathering, fit/gap analysis, MD50/60/65/70 creation and

Rapid-Accelerat review

or Lead the development of the design and technical documents

Implementation for the CEMLI's required for this client - Managed team of

Oracle 9 consultants and 5 customer SME's

Corporation Oversight of Accenture team during entire project life

Client: cycle

National Design, Code, and Unit Test the Conversions for General

Casualty Ledger, Suppliers, Employees and Accounts Payables

Insurance Design, develop, and execute all test plans/cases for the

Provider, implementation

California Design, Code, and Unit Test the Interfaces for General

Casualty Ledger and Accounts Payables

San Mateo, CA Involved with PMO, project plans, communication protocols,

Aug/2007 to scoping, resource allocations, change management, test

Feb/2008 cycles, and risk management

Developed Oracle Applications Express (APEX 2.1) portal for

Business Teams, as well as Hyperion Portal with extensive

reporting modules

Fusionworx and Lead Technical Architect, Enterprise Solutions Architect,

IT2000 Lead Developer/Analyst: assist in porting IBM/DB2 Data

Consulting stores to Unix/Oracle 9i platform for use with the SAP

Various Clients Supply Chain Modules

Monitor, Mentor, and direct a small developer teams

Clients: State Requirements Analysis and Writing of Requirements

of Ohio, State Oracle database, SQL Server, Informix, clipper, foxpro,

of Texas, State dbase, ms access, etc.

of Indiana, Unix - Korn shell - Perl

United States IBM Mainframe, Client-Server AS400, Linux/Unix

Marine Corps, Clist, rexx, jcl, cobol, vsam, mvs, os-390, unix, linux,

GM, MCI, Mellon solaris, operations departments, programming department,

Bank, Conseco leading groups and teams, etc

Insurance and

Finance,

Timkin, Brush

Wellman, etc

Indianapolis,

IN

1993 to

Aug/2007

Project Creation of PMO and PMP Certified

Management Level 3 Certified Oracle Project Manager

Certified EDS and General Motors Project Manager

Ability to bring key players to the table and gain

accountability and buy-in

Managed multi-vendor projects & staffs ranging from 5 to

35+ FTE's

Managed Global projects covering multiple countries &

geographic locations

Ability to work with all levels of the organization, from

CEO's to clerks

PMI member and working on my PMP certification

Process Ability to analyze and design creative solutions to

Automation automate most every process

Ability to refine existing automated processes

Reduced the number of employees by 80% within a Sales

Support department within a large Pharmaceutical Account

Cost Savings accomplished due to process automations in

multiple Accounts

PL/SQL Over 20 years experience designing, coding, and testing

PL/SQL

Over 2500 PL/SQL Procedures and Packages coded and tested

Over 500 PL/SQL Triggers coded and tested

Extensive Apps Schema experience

Extensive experience tuning Joins and other complex queries

Web Development Experience coding Java/JSP for iStore solutions

Experience with Custom.pll and iReceivables HTML based

enhancements

Training in 10g development, J2EE, and custom web based

solutions

Experience in Cold Fusion, Web Caf, Websphere, and

Jdeveloper

Oracle Forms6i Over 6 years experience designing, coding, and testing

and Oracle Forms and Reports

Reports6i Over 500 Forms coded and tested

(including 9i Over 800 Reports coded and tested

and 10g/11g Use of 6i, 9i, and 10g tools for development of Forms and

Forms and Reports

Reports)

Skills Summary

Oracle Inventory OM

Manufacturing Procurement EDI Interfacing

Applications WMS IStore Development

MSCA Oracle API's

Oracle AP AR

Financial GL Discoverer Reporting

Applications COGS ACH

R12 11i

Databases Oracle 7, 8i, 9i, 10G, 11G, DB2 OS390/UNIX

12C MS Access

SQL Server MySQL

Informix

SAS

Hardware & Windows NT HP-UX 11.11

Operating Windows 2000 Red Hat Linux

Systems Windows XP IBM Mainframes/ISPF/OS390

Programming Java/JSP UNIX Shell Scripting

Languages PL/SQL HTML

ASP Pro*C

. NET VB6

PeopleCode Oracle Forms

SQR Oracle Reports

Vb.NET C#.NET

ColdFusion Flash

HTML DB APEX

Engagement Project Management Business & Technical Process

Experience Applications Development Reengineering

Data Conversion End User Training

AIM Methodology Conversion

Fit/Gap Analysis Configuration

Testing Performance Tuning

Reports Definition Scoping

Web Development

PeopleSoft 5.x Human Resources Benefits Administration

Base Benefits PeopleTools

Payroll PeopleCode

Other Microsoft (Word, Excel, Documentum

Access, Project, PowerPoint) Visio

TestDirector Crystal Reports

Informatica Business Objects (BO)

Maximo 3/4/5.2 Vision

TIBCO Harvest

Prism Microsoft CRM Dynamics

SaaS PaaS

IaaS Oracle ETM

Hibernate Pervasive

JD Edwards Oracle ODI

Biztalk Oracle Data Integrator

CLOUD Virtualization

Educations, Training, References

Education Computer Science - Honors Program - Ball State University -

Muncie, IN

Computer Science - Valedictorian - USMC - Quantico, VA

PMP Certified

Oracle 11g Admin/Config/Backups

Training Oracle Release 11 Application Administrator

Oracle Forms and Reports

Oracle Advanced Forms and Reports

Oracle Applications Server 9i and 10g

Oracle Database Administration 10g

Oracle Forms 10g Development (Java/JSP)

PeopleSoft PeopleTools (I)

Project Management

Account and Resource Management

Project Scoping

Relational Database Tuning

Oracle Level 3 Project Manager Certified

Recognition & Employee of the Month (prior Employer)

Awards Bonus for coming in Under Budget and on time for projects

(prior Employer)

Senior Partner recognition (prior Employer)

References

> Justin Coble, CSC Consultant, 3 years 317-***-****

> Mannish Shrinivastiva, Dell Manager, 2 years 901-359-

8010

> Ed McMahon, California Casualty Project Manager, 1 year 480-235-

4496

Contact this candidate