Oracle Project Manager

CURRENT AND

PAST CLIENTS:

Fidelity National Finance General Dynamics

Fidelity Information Services NCS Pearson

Lender Processes Services Special Metals Corporation

Gevity HR

EDUCATION:

BBA, Management Information Systems, Marshall University

Sun Certified Java Programmer, Sun Java Designing Java Web Services,

BPEL training by IT convergence, Oracle Developer Workshop "Fusion

Developer", Oracle Workshop OBIEE

SKILLS:

Application Oracle E-Business Applications 10.7, 11, 11i (11.5.x) HR, FED HR,

Software Payroll, OAB, Self-Service,

I-Recruitment

Functional Requirements Definition, Gap Analysis, Solution Design and

Development, Training and Conference Pilots, Testing

Technical ORACLE :

Oracle Developer 6i / 9i DS, Oracle Reports 9i DS, Oracle Forms 9i

DS,

Oracle Discoverer, Oracle XML Publisher, Oracle Web Toolkit, Oracle

Fast Formulas, Oracle Business Intelligence, Oracle JDBC, Oracle SQL

Plus, TOAD, SQL Navigator, Crystal Reports V 8.5 / 9 / 10,

Familiarity with JavaScript, J2EE, JSP,OAF,ADF,JDEV 9, JDEV 10

OS:

Windows 3.x/ 95/98/NT/2000/XP/VISTA, SCO-UNIX, Solaris-UNIX, Sun-OS

UNIX, HP-UNIX, LINUX (RHEL/Centos), HP-UX

Total 8 Full Life Cycle Oracle HR and Payroll Implementations

Implementatio 2 Full Life Cycle Oracle Federal HR Implementations

ns: 1 Refresh and Purge Implementation

EXPERIENCE:

2009 - City of St. Petersburg

PRESENT

Oracle Developer III

Oracle HRMS development and support for Payroll, Oracle Advanced

Benefits, Recruitment, Self Service and HR

OAF Java Development for custom iRecruitment criminal history form.

OAF Java Development creating embedded adobe acrobat pay slip in

self service.

OAF Java Development creating OAB custom regions.

OAF Java Development creating custom page context j2ee beans and

custom pages.

SOA suite development with BPEL Asynchronous and Synchronous process

between Police and Fire sub systems

Custom HRMS reports and interfaces to internal systems and external

carriers

Developed Discover Views and Reports

Integration testing of Oracle Patches

Workflow builder for custom notifications and approvals

Java xml extract SAX and DOM interfaces

Custom BI reports via desktop template builder

Customizations with Oracle Forms 6i

Customizations with Oracle Reports6i

Oracle Release 12 analysis and implementation from 11.5.10

JUN-2006 - Fidelity Companies:

DEC-2008 Fidelity National Finance

Fidelity Information Services

Lending Process Services

Oracle 11i HRMS - OAB, Payroll, OTL

Two implementations and one refresh and purge of Oracle 11i HRMS.

Technical resource to create custom solutions comprising of

interfaces, reports, fast formulas and application support

Created 80+ external and internal Interfaces

Created 30+ custom reports

Created and modified 60+ fast formulas

Created and supported application setups such as key and descriptive

flex fields, HR lookups (user tables), OAB reporting groups, element

distribution sets, concurrent and host programs, responsibilities

and security profiles

Created data load programs and support implementations with Oracle

API's

Designed reporting architecture for BI with use of xml publisher

Designed and created technical utility programs such as views,

functions, procedures, packages and established development

standards

Two year post implementation involved in all production support

requests such as HR, payroll, OAB, end of year processing, open

enrollments, W2's, Check Writer, NATCHA, FTP, interfaces and custom

reports

PORTFOLIO of

INTERFACES

for FIDELITY

(2006-2008)

BEN Aetna HMO / PPO Interface Benefit UNUM LTC Inbound

BEN COBRA Outbound Interface Interface

BEN DeltaCare Outbound Interface Benefit Unum LTC Outbound

BEN EyeMed Outbound Interface Interface

BEN Highmark-Keystone Outbound Benefit UNUM Universal Life

Interface Inbound Interface

BEN Kaiser CA Outbound Interface Benefit Unum Universal Life

BEN Kaiser GAE Outbound Interface Outbound Interface

Certgy ADP Tax Outbound Interface

Active Directory Interface

ADP FUTA Tax Credit Outbound CES (Current Employee Statistics)

Interface Interface

Aetna LTC Outbound Corporate Tax Outbound Interface

BEN Aetna HMO / PPO Interface Earnings Spreadsheet Upload

BEN Aetna HSA Interface Program

BEN Aetna LTC Inbound Interface eFunds India Supervisor Interface

BEN AFLAC Inbound Interface

BEN AFLAC Monthly Outbound Extensity Employee Changes

Interface Interface

BEN AFLAC Outbound Deduction Extensity Setup Changes Interface

Interface

BEN AFLACCENSUS Outbound FLEXAMERDEMO Outbound Interface

Interface HR EFUND SAP Outbound Interface

BEN BCBS of MI Interface HR EFUNDS Notes Outbound

BEN Census Data Download Interface

BEN Cigna Medical Interface HR EFUNDS Validate Outbound

BEN COBRA Outbound Interface Interface

BEN DeltaCare Outbound Interface HR Enterprise Messaging Interface

BEN EyeMed Outbound Interface

BEN FlexAmerica Deduction HR INET and GIO Outbound

Outbound Interface Interface

BEN Hartford Interface HR JDE Category Code (FPSD0100)

BEN Health Advantage Outbound Interface

Interface HR Zones Outbound Interface

BEN Highmark-Keystone Outbound JAX SECURITY Outbound Interface

Interface JDE BU Outbound Interface

BEN HYATT Legal Interface JDE Costing Interface

BEN Kaiser CA Outbound Interface JDEBOOK Outbound Interface

BEN Kaiser GAE Outbound Interface Kronos Accrual Balances

Kronos CSV Outbound Interface

BEN Kaiser WA HMO Interface Kronos Inbound Interface

BEN MEDICA Interface Kronos Outbound Interface

BEN Transit One Monthly Interface Monthly JDEBOOK Outbound

Interface

BEN Transit One OE Interface Newport Census Outbound Interface

BEN Zurich Outbound Census

Interface Newport Outbound Interface

Benefit BCBS FSA/HSA Interface OAB New Pacificare Outbound

Benefit BCBS HMO of Florida Interface

Interface OAB Pacificare Outbound Interface

Benefit BCBS PPO/EPO Interface

Benefit Hodges Mace Outbound PO GenTran Outbound Interface

Interface PO GenTran999 Inbound Interface

Benefit Prudential eligibility RMAX Outbound Interface

Interface Sedgwick Data Map

Benefit Prudential Portability Sedgwick Outbound Interface

Interface TALX Outbound Interface

Wells Fargo 401k Outbound

Interface

Wells Fargo 401K-ESPP Inbound

Interface

Wells Fargo ESPP Outbound

Interface

2005 - JUN Gevity

2006

Oracle 11i HRMS - OAB, Payroll, OTL

Technical resource for application development on Oracle Human

Resources (HRMS) 11i, Payroll, Oracle Advanced Benefits (OAB),

Self-Service, iRecruitment, Cost Work Bench, Billing (Custom),

General Ledger, Accounts Receivable and Accounts Payable modules and

applications

Provided custom development for Custom Interfaces, Conversions, CM,

Custom Forms and Reports

Researched and implemented innovative techniques to increase

application performance

SQL and PL/SQL Performance Tuning

Developed PL/SQL packages, procedures, triggers, functions and fast

formulas

Experience with Oracle API's (load balances, employee information,

jobs, assignments, locations, elements and more)

Developed PL/SQL procedures to define the employee's eligibility,

create XML data files to populate the web and create data extracts

from open enrollment to third party health carriers

Created multiple ANSI 834 downloads

Created and maintained Oracle Reports

Developed custom Oracle Forms, Void and Reissue Forms, Reversal

Forms, New Hire Forms and more

Created UNIX shell scripts to encrypt and FTP data files to client

sites

Provided functional and technical documentation

Responsible for daily high priority "Hot Fixes" to find solutions

and deliver payroll/HR services

2003 - 2005 General Dynamics

Custom Oracle Application for (DOT) Department of Transportation

The Federal Motor Carrier Agency engaged General Dynamics to design

and implement a custom web application used by carriers domestically

and internationally to register trucking fleets for DOT inspection

and to track crashes, reviews and safety ratings for North America

Provided technology consulting services to the Federal Motor Carrier

Agency

Created Congressional reports used to allocate Federal funding to

the Department of Transportation for each State.

Designed and implemented a custom web application used by carriers

domestically and internationally to register trucking fleets for DOT

inspection to track crashes, reviews and safety ratings for North

America. It provided each State with the ability to upload their

inspection, crash and review data via an online application,

eliminating the need for independently operated State systems

Responsible for all reports development, assigning development work

and setting project timeframes

Managed the functional architectural design of the application and

identified business rules and objects

Technical Project Manager for a team of 16 developers and multiple

third party vendors in the custom development of the online

application

Established processes, traceability within ISO standards and

implemented a (CMM) capability maturity module within the

development full life cycle

Researched innovative techniques, increased project performance and

scope, monitored and administered the Oracle 9i AS server and lead

projects to completion

Performed as a functional and technical liaison between the

development staff and DOT

2002 - 2003 NCS Pearson Government Solutions

Oracle 11i Federal HRMS

Provided technology consulting services for the Federal Emergency

Management Agency and the Department of Transportation for the

Homeland Security contract

Implemented Oracle Federal HRMS to create an interface to every

national airport with security personnel

Developed Oracle Applications to meet the massive hiring

requirements (40,000 employees), configuring workflow and applicant

approvals using Oracle Federal Human Resources

Created custom form development for Federal HR system

Created Custom Forms that combined Federal HR forms calling Federal

HR API's and validations

Responsible for Oracle Federal Reports development and project

proposal development

Designed, performed analysis, implemented, integrated and maintained

support of Federal HR

Functional and Technical Support performing as a Oracle Federal

Business Analyst

Performed strategic analysis to define Federal competencies and

establish proficiency scales within OFHR

Developed an employee disaster deployment system based upon

proficiency and setup within Oracle Federal HR

Designed and implemented the Oracle Federal Human Resources

application and configuration of web-based Self-Service for 360

competency assessments and appraisals

Managed multiple third party vendors and lead a staff of 10

application developers and database administrators

Established workflow and developed Business Intelligence within

Federal HR

1996 - 2002 Special Metals Corporation

Oracle HRMS, Financials, Inventory, Manufacturing Modules

Completed the development of three full life cycle Oracle HRMS and

Payroll implementations and custom software development

Managed functional and technical teams to create business rules for

Labor Relations (UNIONS), including employee seniority,

qualifications systems, recruitment, benefits, open enrollment,

training, employee development, safety (OSHA) regulations, time and

attendance, retirement plans/funds, workers compensation, payroll,

competency modeling, general ledger, accounts receivable, cost

accounting, inventory and manufacturing shop floor

Converted and established migration plans to new systems for legacy

data to meet Y2K requirements

Designed and developed custom Oracle Forms and Reports to be used

within Oracle Applications 10.7

Performed feasibility analysis (RFQs) to outsource third party

payroll and benefit providers and created custom interfaces to Blue

Cross Blue Shield, ADP and Pro-Business Payroll Solutions

Functional and Technical project lead responsible for managing

independent and corporate consultants (Oracle Corporation, ADP,

Pro-Business, and E&Y) to support projects and meet deadlines

Designed and implemented the multi-domain enterprise for Special

Metals Corporation

Provided ongoing maintenance and support of the Network Enterprise

Architecture

Administration and Support of Microsoft NT, Novell, Systems

Management Server, SQL Server, Lotus Notes, OS2 and Hardware Support

REFERENCES: Available upon request.

Contact this candidate