Sales Oracle

SUMMARY OF QUALIFICATIONS

Programmer/Analyst with over twenty years of support and development

experience, ten years of analysis experience, six years using Oracle

toolsets and databases, five years in an Oracle Financials

environment, and ten years of mainframe programming. Experienced in

various hardware/software platforms on midrange, PC computers, and

mainframes. Have extensive knowledge about the technical aspects of

Oracle Financials, databases, and toolsets.

PROFESSIONAL SKILLS/TECHNICAL COMPENTENCY SUMMARY

Midrange: Linux Redhat, UNIX/AIX, Oracle Financials, Oracle Database,

PL/SQL, SQL*Loader, C, Pro*C, MatrixOne, Payment Plus Credit Card

System, Vertex Quantum for Sales and Use Tax (PL/SQL), BPA, UNIX Shell

Scripts

PC: Windows, Oracle Reports, Oracle Forms, TOAD, MS Office (Word,

Access, Excel, PowerPoint, Projects)

KEY ACCOMPLISHMENTS

. Technical implementation member upgrading Oracle Financials data to

different ERP system.

. Upgraded MatrixOne software to interface with a different ERP

system.

. Technical implementation member in 11i upgrades.

. Support and development experience in Oracle Financials 10.7, 11.0

and 11i.

. Upgraded and maintained companywide daily sales PL/SQL reporting

applications.

. Database experience with 9i and 10g databases.

LENOX TOOLS (Newell Rubbermaid), East Longmeadow, MA: A manufacturer of saw

blades and hand tools.

Oracle Developer, November 2007 - September 2009

ERP Implementation - September 2008 through September 2009

. Technical implementation team member that extracted EDI, Open

Invoice, Order History, Order Notes, BOM, and PO data via

PL/SQL from Oracle Financials 11 for corporate wide ERP

implementation. Did analysis, specifications, coding, and

acceptance testing. Worked with people from different

corporate locations. Did additional reporting BOM and INV.

Provided SQL for custom bar-code printing application.

. Supported and updated MatrixOne software to interface with a

different ERP system.

Oracle development and support

. Developed reusable code that was added to our nightly data

warehousing package to add reporting information for BOM for

a new Discoverer report.

. Provide periodic 24x7 support to a PL/SQL stored procedure

package that ran daily sales reporting report.

. Oracle 11.0 support and maintenance.

. Experience in OE, AR, Inventory, FA, and PO.

. UNIX shell scripts maintenance and development.

AMES TRUE TEMPER, Camp Hill, PA: Ames True Temper is the largest

manufacturer of non-power lawn equipment.

Oracle Developer, September 2004 - October 2007

Daily Shipping and Sales Report rewrite - November 2006

. Rewrote Stored Procedures application used for the daily

sales and shipment report. Originally written to access 10.7

OE schema, it was modified to read 11i OM schema. Legacy SQL

was tuned. Also performed unit testing.

Developed custom GL Accrual reporting system - January 2005

. Derived custom PL/SQL stored procedure and Oracle Forms

application for monthly GL HPL Accrual reporting.

Oracle 11i Implementation - March 2006 through October 2006

. Technical implementation team member that installed and

tested Oracle Financials 11i for company's financial

software. Implemented functional A/R set-up. Loaded legacy

system data, tested, and created implementation

documentation. Functional and technical experience in OM,

AR, and GL modules. Experience with 10g database.

Oracle 11i Support

. Supported AR interfaces; lock box, invoicing, customers.

. Supported GL ADI application.

. UNIX shell scripts maintenance and development.

. Followed Sarbanes-Oxley standards

ALTEC, Birmingham, AL: Altec is a leading equipment and service provider

for the electric utility, telecommunications and contractor markets.

Oracle Developer, October 2003 - August 2004

Oracle development and support

. Supported companies Oracle Financials 11i software.

. Developed custom financial reports.

. Functional and technical experience in OM and AR modules.

LIFE FITNESS, Franklin Park, IL: Life Fitness is the largest commercial

fitness equipment manufacturer in the world with industry-leading

cardiovascular and strength-training products.

Programmer/Analyst III, January 1997 - September 2002

Oracle 11i Implementation - February 2002 through September

2002

. Technical implementation team member that installed and

tested Oracle Financials 11i for company's financial

software.

. Integrated Vertex Quantum for Sales and Use Tax 2.0 PL/SQL

software for use in the Oracle Financials AR and OE system.

. UNIX shell scripts maintenance and development.

Oracle 10.7 NCA Implementation - February 2000 through August

2000

. Integrated Vertex Sales and Use Tax 1.3 PL/SQL software for

use in the Oracle Financials AR system. Provided technical

and functional installation. Tested final install to

verify correct installation. Installed windows TDM

software.

WM. WRIGLEY JR. COMPANY, Chicago, IL: The Wrigley Company is the world's

largest manufacturer of chewing gum.

Programmer/Analyst, May 1987 - December 1996

. Programmer/analyst involved with legacy mainframe

applications and client server data migration. Developed

COBOL and CICS programs, using VSAM databases.

TOOLSET SUMMARY: IBM ES900, IBM COBOL AND CICS, Software AG

ADABAS/NATURAL, VSAM, PowerBuilder 5.0

EDUCATION

Candidate for Masters in Software Engineering, Software Development path.

GPA 3.44. Programming class work in Java, and related Java technologies.

OOP, C++. DePaul University, Chicago, IL

Computer Career Program, DePaul University, Chicago, IL

Bachelor of Science, Mechanical Engineering, Southern Illinois University,

Carbondale, IL

Associates of Science, College of DuPage, Glen Ellyn, IL

Contact this candidate