OBJECTIVE:

• Information Systems/Sr. Programmer Analyst with project/team leading responsibilities.

SUMMARY:

• Thirty two years of progressive Information Systems experience with specialized skills in Financial Systems technology. Expertise in implementation, enhancement and support of information systems, and a broad background in applications and application interfaces. Excellent technical, analytical, and communication skills, with proven track record in team and project leadership. Demonstrated ability to initiate and execute process improvements and program improvements.

TECHNICAL SKILLS:

Application Interfaces: SSIS, FTP, Passport, Data Transformation Server, SNADSHyperion Pillar Budgeting and Planning System, EDI/EFT

Operating Systems: Windows 2008r2, OS, Windows 2000 - Enterprise Server, OS/400, MVS

Databases: Sybase ase 15.7, SQL Server 2000 - Enterprise Edition, DB2/400, DB2, VSAM, IMS

Languages: JD Edwards Nested Event Rules, Transact SQL, SSRS, Formscape, DOS, RPG, CL, Python, QUERY/400, COBOL, JCL, CICS, IMS DB/DC, Easytrieve Plus

Tools: ets: JD Edwards Enterprise One, One World - OMW, Application Design Aid, Enterprise Report Writer, Form Design Aid,BSFN, NER ;Microsoft SQL s - Enterprise Manager, Query Analyzer, T- SQL, WinSQL,Visual Studio, Replication, Shadowing, Covis Formscape, JD Edwards World Vision - FDA, RDA, SDA and World Writer; DBU, DFU, Debugger, ALDON Change Management System

PROFESSIONAL EXPERIENCE:

Confidential, Harvey, IL

JD Edwards Developer/Analyst

Responsibilities:

• Provided Production Support for the Oracle Peoplesoft JD Edwards Enterprise One ERP version 9.1 and 9.2.
• Provided functional and technical resolutions to G/L, A/R, EDI, Sales Order, Inventory,and Warehousing issues.
• Gathered client requirements, designed, spec and coded modifications using OMW, FDA,RDA, ER, NER, BSFN, BSSV.
• Performed proper SDLC phases and installed changes into production using the change control system.
• Assisted with the upgrade of the GL module from 9.1 to 9.2.
• Performed a major role in installing the 9.2 version modules of JD Edwards A/R, EDI, Sales Order Management, Inventory Control, Warehousing, Advance Pricing and Flex Accounting

ENVIRONMENT: Oracle Peoplesoft Enterprise One (General Accounting, Accounts Receivable, Sales Order Management, Inventory Control, Warehousing, Advance Pricing, Flex Accounting) Version 9.2

Confidential, St Louis, MO

JD Edwards Developer/Analyst

Responsibilities:

• Gathered client requirements, designed, spec and coded modifications using OMW, FDA,
• Provided support for the Oracle Peoplesoft JD Edwards Enterprise One ERP version 9.0.
• Assisted with functional resolutions to G/L, Sales Order, Purchase Order, Work Order, Purchasing, and Human Resources issues.
• Performed proper SDLC phases and installed changes into production using the change control system.

ENVIRONMENT: Oracle Peoplesoft Enterprise One (General Accounting, Sales Orders, Purchase Orders, Work Orders, Accounts Payable, Human Resources,) version 9.0

Confidential, IL

Systems Programmer Analyst

Responsibilities:

• Gathered client requirements, designed, spec and coded modifications using SQL programming,
• Performed environment refresh and notification.
• Provided support for the Sybase SQL Freight Payment applications
• Participated in implementation projects and meetings.
• Performed proper SDLC phases and installed changes into production using the change control system.

ENVIRONMENT: Tranzact Freight Payment, Sybase ase 15.7, Windows 2008r2 Server, T-SQlWinSQL, Visual Studio

Confidential, Libertyville, IL

Systems Programmer Analyst

Responsibilities:

• Gathered client requirements, designed, spec and coded modifications using OMW, FDA,
• Performed CNC duties, package builds, package deployments, heavy client and thin client installs.
• Provided support for the Oracle Peoplesoft Enterprise One JD Edward One World ERP version 8.15.
• Assisted with functional resolutions to G/L, Sales Order, Purchase Order, Work Order, Purchasing, Inventory, Warehousing and A/R issues.
• Performed proper SDLC phases and installed changes into production using the change control system.

ENVIRONMENT: Oracle Peoplesoft Enterprise One (JD Edwards One World) (General AccountingSales Orders, Purchase Orders, Work Orders, Inventory, Accounts Payable, Accounts Receivable, Fixed Assets,) version 8.15

Confidential, Chicago, IL

Systems Programmer Analyst

Responsibilities:

• Gathered client requirements, designed, spec and coded modifications using OMW, FDA,
• Performed CNC duties, package builds, package deployment, heavy client and thin client installs.
• Provided security maintenance and support for the Oracle Peoplesoft Enterprise One JD
• Assisted with functional resolutions to G/L, A/P, Purchasing, Fixed Assets and A/R issues.
• Installed the Covis Formscape Document scanning and management sytem.
• Provided security maintenance and support for the Covis Formscape Document scanning and management system for the Purchasing, A/P and G/L applications.
• Gathered client requirements, designed, spec, coded and deployed modifications to the Formscape applicatons.

ENVIRONMENT: Oracle Peoplesoft EnterpriseOne (JDEdwards One World) (General Accounting, Accounts Payable, Accounts Receivable, Fixed Assets, Purchasing) AS400, OS/400, SQL, Covis

Confidential, Westmont, IL

Sr Systems Analyst

Responsibilities:

• Provided security maintenance and support for the JD Edwards Enterprise One ERP
• Coded, tested and analyzed RPG IV and RPG IV ILE programs to retrofit them for the
• Activated Multi-currency functionality for the JD Edwards ERP which included Balance Restatement, Balance by Currency and Detailed Restatement processing.
• Managed the Cume Upgrade project which was completed on time and within budget.

ENVIRONMENT: Oracle Peoplesoft EnterpriseOne 8.10 SP4D(JDEdwards One World) (General Accounting, Accounts Payable, Accounts Receivable, Fixed Assets, Property Management, Purchasing); Oracle Peoplesoft World A7.3.15(JDEdwards World Vison) (General Accounting, Accounts Payable, Accounts Receivable, Fixed Assets, Property Management, Purchasing), AS400, OS/400, RPG IV ILE, CL, SQL, QUERY/400

Confidential, Chicago, IL

Sr Systems Analyst

Responsibilities:

• Worked on full life cycle JDE development projects including gathering requirements, analysis, development, testing and installation.
• Analyzed requirements and programmed applications for Peoplesoft Enterprise One (JDEdwards One World) for internal departments to view check information by various search criteria, resulting in improved cash flow management and reporting.
• Designed and coded modifications for several Peoplesoft Enterprise One (JD Edwards One World) reports to provide General Accounting, A/P, and Fixed Assets groups access to more detailed and useful information for day to day operations and financial audits.
• Collaborated with RCS Cashiering and other key stakeholders to design and implement audit, balancing, and financial enhancements to the RCS Cashiering System. Achieved simplified tax collection processes and established stronger audit and financial controls.
• Involved in support and enhancements for JDE and SQL Server 2000 based applications.
• Utilized FTP, Passport and DTS to interface information.

ENVIRONMENT: Peoplesoft Enterprise One (JDEdwards One World) (General Accounting, Accounts Payable, Fixed Assets), RCS Cashiering System, Clustered Intel Servers, OS, Windows 2000 - Enterprise Server, Enterprise Manager, Query Analyzer, SQL Server 2000

Confidential, Deerfield, IL

Sr Systems Analyst/Project Leader

Responsibilities:

• Managed an employee and consultant based JD Edwards financial modules technical team of ten, providing on-going technical and functional expertise and direction as well as talent and performance development through full life cycle development.
• Coded programs utilizing RPG IV ILE to interface plant purchasing and inventory information.
• The programs performed editing, table lookups, conversions and PO, receipt and invoice matching.
• Programs were also written to perform online inquiries and online modifications. These new programs and processes improved Confidential ’s ability to negotiate favorable payment terms with vendors, and increased cash flow by 20% in North America.
• Led the project team to integrate a newly acquired PPI business into Confidential ’s North America instance of JD Edwards, resolving all issues on time and under budget. Coded RPG IV ILE conversion programs to retrieve the General Accounting data from the PPI system ledger and populate the
• F0911Z1 interface files to load the JD Edwards system ledger. The programs only brought over balances not transactional data for current and three prior years.
• Initiated discovery of unrealized vendor discounts by investigating and resolving the source of the program error, resulting in improved cash flow for Confidential ’s North American region. Setup and utilized Debugger to track logic flow as well as field and variable amounts to identify the reason the discounts weren’t being generated.
• Developed programs and processes to significantly reduce online data storage with archival storage, resulting in lower online costs and increased processing speed. Coded programs utilizing RPG IV ILE to interrogate the Fixed Assets files to determine when an asset had been retired and to flag the asset so that all transactions related to the asset could be archived. Coded Query/ 400 programs to report on the archived data once it was loaded onto an AS400 from tape.
• Supported JDE financial applications including General Accounting, Accounts Payable, Fixed Assets and Job Cost. Utilized SQL, DBU, and DFU to query and maintain tables when needed during system support. Created and maintained the proper audit trails during system support.
• Performed Unit, Stress, System, Integration, Load, Regression and Platform testing utilizing test scripts.
• Led a team to provide additional functionality to Confidential ’s North American region by upgrading the financial modules software to the newest version. The Cum Upgrade project was completed on time and on budget with the system, its customizations and its interfaces working perfectly.

Confidential

Project Manager/Group Manager

Responsibilities:

• Implemented on time and on budget for Confidential ’s North American Region the JD Edwards’ General Accounting, Accounts Payable, Fixed Assets, and Job Cost/Capital Projects modules as the first “go live” of a global integration project. Managed the business and technical teams with a project budget of $7 million. The project achieved Y2K compliance, enabled quicker business acquisition and divestiture, standardized data and processes, created and adopted a global chart of accounts and facilitated the establishment of a regional Financial Center of Excellence (shared service). The new system significantly reduced on-going support costs and personnel costs.
• Created multiple processes and programs to interface data into the North America JD Edwards instance in a pseudo real time fashion, providing consolidation of all transactions for business reporting. Developed 35 interfaces, down from 60 pre-implementation interfaces, with appropriate audit controls and error correction mechanisms to send only correct data.
• Involved in heavy multiple testing scenarios such as Unit, Regression, Load, System and Conference Room Pilot testing.
• Managed department of 30 employees and consultants with operating budget of $2 million. Provided financial services and technical support of Dun and Bradstreet General Ledger, Accounts Payable, Fixed Assets and Capital Projects for Confidential, Confidential, Dade and Nestle Corporations.
• Recognized with 1997 Finance Leadership .

ENVIRONMENT: JD Edwards World (World Vision), (General Accounting, Accounts Payable, Fixed Assets, Job Cost, Inventory Purchasing) IBM AS400, OS/400, RPG IV ILE, CL

Confidential

Team Leader - Financial Systems

Responsibilities:

• Led project team on divestiture of Confidential spin-off from Confidential Corporate Financial Systems. Established new Confidential Corporate Financial System on time and within budget. Recognized with 1996 Finance Leadership .

Confidential

Sr. Programmer Analyst

Responsibilities:

• Designed, coded and tested for the ARMS Accounts Receivable System online cost reduction project that improved processing and code efficiency which resulted in a 35% reduction in online processing cost.
• Coded and tested for multiple projects, including a conversion of the vendor file maintenance system and a conversion of the Inventory Accounts Payable System from Burroughs to IBM.

ENVIRONMENT: Dun and Bradstreet (General Accounting) Millenium CICS, Inventory Accounts Payable IMS TROL, Accounts Receivable IMS DB DC, IBM 3090 Mainframe OS MVS, COBOL, JCL