SUMMARY

• An IT Systems Professional with years of hands - on experience in problem solving, supervising, developing, and implementing mid-range application systems such as BPCS, Prism, JD Edwards, and RTC. Designed, developed and implemented various projects on time, on budget, and with the desired results.
• Responsible for reducing costs of MIS department assets consistent with the organization's goals and objectives.
• Extensive experience in all aspects of IBM iSeries (AS/400) application development including, but not limited to, RPGII/III/IV, RPG ILE, CLP, Free Syntax, DB2/400, Query/400, SQL, XML and many other related development tools and utilities.

TECHNICAL SKILLS

SOFTWARE: JD Edwards, Inovis (Harbinger/Premenos), BPCS, Prism, RTC, Autotune, DBU, Probe/Abstract, Hawkeye Pathfinder, Query/400, Sequel, SQL, OPTIO, Fastfax, Kronos, Robot, and Visio.

APPLICATIONS: Financial Accounts Payable, Accounts Receivable, General Ledger.

Distribution : Distribution Requirements Planning, Inventory Management, Order Entry, Purchasing, Sales Order, Shipping, Warehousing.

Manufacturing: Material Requirements Planning, Planning and Scheduling, Shipping, Bill of Material, MSDS, and Hazardous Materials.

Other: Return Authorization, EDI, Forms/Data Merging, On Line Faxing Systems Bar-coding, Employee Time tracking.

PROFESSIONAL EXPERIENCE

Program Developer

Responsibilities:

• Working as a contract developer to support migration and development of new sales web site.
• Perform other support functions and development as required.

Confidential, Troy, MI

Systems Analyst

Responsibilities:

• Returned to Proctor as a contractor to develop an in-house application and was hired on full time.
• Worked on various homegrown systems that included calculating billings and tracking claims and payments, and a letter system that produced over 750,000 letters per year.
• Worked on latest IBM Power Systems (iSeries) using combination of CLP, RPG’s, Free, and SQL applications.
• Developed underwriting system to automate the calculation of premiums for various perils.
• Worked on letter systems where I identified and corrected issues, developed a monitoring system for missed letters and implemented improvements in process flow that reduced missed letters.
• Worked on other assignments as required from billing to claims processing.

Confidential, Madison Heights, MI

Contract Sr. Programmer/Systems Analyst

Responsibilities:

• Worked as a Contractor assigned to the Henkel for an initial 6 month engagement that turned into over 5 years.
• Application development and maintenance was done using iSeries (AS/400) Application Development tools such as RPGIII/IV, RPG ILE, CLP, DB2/400, SQL, and Query/400 and related programming tools.
• Responsibilities and key projects completed include, but are not limited to, the following:
• Designed and created a Totes delivery and tracking system to run independently of any other ERP system. Facilitated timely tacking of customer product shipments for freight, EPA, and capital assets accounting to avoid the asset lost of these totes. This system also avoided a costly re-write of an SAP subsystem.
• Performed application development to make sure consolidated systems had critical historical data that required archiving to conform to corporate data retention policies. This work was done on various applications/platforms including SAP R/3, BPCS, CRM and Image Plus. Created systems and processes to automate the uploading processes of historical data to an Oracle database.
• Designed, created, and implemented an automated Material Safety Data Sheets (MSDS) process that would create or update existing MSDS’ when ever a formula was changed in the base application. This provided customers with accurate online information regarding any potential hazardous materials.
• Reduced costs and saved processing time by designing and developing automated BPCS freight/shipping processes to automatically process orders on a scheduled basis. Utilized the Free format Syntax for majority of this project.
• “Go To” technical resource for all production supporting of critical iSeries business systems. Proactively monitored critical system jobs to help prevent possible problems. Troubleshoot all system issues, problems, and error messages and implement resolution to root problems.
• Responsible for maintenance, support, and customization of Kronos Time and Attendance system. Handled setting up security and user profiles, systems modifications, creating and maintaining custom reports and processes as required. Also performed technical support on time clocks, printers, and communications.
• Designed and developed an automated process of check transactions to feed the Wachovia Bank's check cashing system.
• Configured the system environment on a single AS/400 to host several separate ERP and custom application systems so each “environment” was independent and did not interfere with other systems environments. This project help eliminate the costs of multiple legacy computer platforms. Controlled these environments using iSeries utilities and developing unique Sign On processes in CL.

Confidential, Troy, MI

Sr. Programmer Analyst

Responsibilities:

• Engaged to document a legacy iSeries application consisting or RPGIII/IV, and CLP, and other iSeries programming tools/utilities using Abstract, Visio, Adobe Acrobat, and Websphere's flowcharting plug-in in order to assist Proctor comply with Sarbanes-Oxley.
• Also modified and created new applications to support Proctor’s insurance applications using SQL, RPGIV, CL, and related tools/utilities.

Confidential, Southfield, MI

Senior Consultant

Responsibilities:

• Working as a Sr. iSeries Programming Analyst worked on the following projects:
• Confidential ,
  • Researched, designed, developed, tested, implemented, and maintained Prism and other legacy applications on an IBM iSeries platform using RPGIV/III/ILE in order to improve the quality, integrity, and efficiency of core systems.
  • Responsible for all planning, design and development necessary to implement Optio’s Forms Overlay Printing system. This system handled Accounts Payable checks, Customer Orders, Shipping Acknowledgments, and Invoices.
  • Assisted the Customer Help Desk department by providing solutions to user problems.
  • Systems analysis, design, application development, and networking were performed in a multiple iSeries environment.
  • Interfaced PCs and iSeries platforms in order to transfer data needed for both MS Windows and iSeries applications. Used various networking techniques such as FTP, TCP/IP, and ODBC.
  • Modified Customer Order, Inventory, and Purchase Order systems programs as required.
  • Helped plan and implement data conversion programs of acquired plant’s data to the company’s PRISM system.
• Confidential
  • Developed plans and programming tools to assist in the successful conversion and implementation of a Y2K compliant Prism ERP system on time and within budget.
  • Enhanced Prism’s data security and user application access.
  • Created several time and money saving utilities and reports to support the ERP system.

Confidential, Taylor, MI

Responsibilities:

• Hands on IS manager responsible for all key business applications running on the IBM iSeries platform such as Route Accounting and Distribution, Garment Tracking, and Invoicing for a multiple division company.
• Responsible for managing Technical Services, Help Desk, Development, and Programming support functions and introduction of new technologies and processes.
• Responsible for transitioning the corporation’s key data files into a relational model to take full advantage of the iSeries system capabilities and application development benefits.
• Responsible for the complete design and implementation of a bar cording system used to label and track garments. Implemented the application and related bar-coding hardware throughout all Garment-Processing Facilities.
• Developed systems and strategies that reduced costs and shortened lead times to improve customer service and increase market share.
• Implemented a Kronos Time Management system for the Michigan and Ohio divisions to track labor costs and support a JD Edwards’ Payroll system.

Confidential, Saginaw, MI

MIS Manager

Responsibilities:

• Responsible for the scheduling, acquisition, and maintenance of department assets.
• Developed and reviewed job quotes for software, hardware, and manpower requirements.
• Introduced and implemented new technologies and processes, such as Scantron Data Scanning to replace manual data entry to reduce manual data entry and costs.

Confidential, Troy, MI

Senior Systems Analyst

Responsibilities:

• Developed and implemented many enhancements to multi-plant MRP applications (RTC and BPCS) that contributed to the competitive and strategic advantage of the company and was directly responsible of increased sales and profits.
• Involved in all aspects of system analysis, design and implementation, quality control, as well as third party software products evaluation, selection, and implementation.
• Responsible for the successful coordination of the hardware and software consolidation of four divisions onto one single platform of hardware and software that eliminated redundant costs.
• Implemented and maintained Premenos EDI on an IBM S/38 and IBM AS/400.
• Introduced IBM-based Bar-coding and Tracking systems to support customer product selection and work in process cost accounting.
• Developed an in-house IBM S/38 based on-line faxing system to support JIT purchase orders that reduced lead times by 3 days.