SUMMARY:

• Expert IBM iSeries Software Developer (25+years) with business experience across variety of industries in cross - platform systems environment.
• Strong Knowledge in all phases of the Software Development Life Cycle (SDLC)..
• Over 25 years of technical expertise in iSeries programming tools and utilities. Applications: DMAS, MAPICS,MAC-PAC, JDE, PkMS, Confidential, IP, ILS, Order Power, etc.

CORE QUALIFICATIONS:

• IBM i (AS/400, iSeries, System i)
• Strong analytical skills
• RPG/400, RPGLE, Free RPG, CL
• Programming and design skills
• Query Manager, Interactive and Embedded SQL
• Ability to multitask
• DB2 UDB, Stored Procedures, Database Triggers
• Lifecycle Project Development
• IBM's APIs, Service programs, Pointer Logic, BIFs
• Communication skills
• Subfile programming
• Software QA Testing
• Journaling and Commitment Control
• Test scripts, regression testing
• IBM Websphere MQ

PROFESSIONAL EXPERIENCE:

Senior Iseries Consultant

Confidential, York, PA

Responsibilities:

• Support of Service Defect Warranty Application
• Maintenance of Contract Booking System (CBS)
• User profiles setup, security codes assignments, providing user s access based n business functions requirements.
• Maintenance of various IBM s Websphere MQ interfaces:
• Siebel s NxGen to SD Warranty
• Lawson to SD Warranty
• CBS to Mapics, etc
• Product pricing releases

Environment: ISeries, RPGLE, ClE, SQL

Programmer/ Consultant

Confidential, Costa Mesa, CA

Responsibilities:

• Analysis of data integration from multiple applications
• Developed algorithms in support of Healthcare analytics.
• Designed of SQL scripts for Data Warehousing.
• Programmed SQL Stored Procedures for ETL functions.

Environment: ISeries, RPGLE, ClE, SQL

Senior Programmer/Analyst- Consultant

Confidential, Fountain Valley, CA

Responsibilities:

• Price Authority Project-Hide cost data from KIA Motors and Confidential applications to accommodate change to PDC's inventory ownership.
• Modified Part's system database and programming to restrict access to certain sensitive cost and pricing information, based on the business user access.
• Document current system processes
• Project involved extensive database modifications, programming changes and SQL processing.
• Environment: iSeries, RPGLE, CLE, SQL, Embedded SQL, Implementer.

Senior Programmer Developer

Confidential, Palo Alto, CA

Responsibilities:

• Member of HP employees team, assigned to maintenance of ISeries based business applications for Confidential company.
• Extensive interaction with all levels of business user departments and end-users community.
• Designed, programmed and implemented changes to the Order Processing module to accommodate Avery.com customers by enabling warehouse inventory handling in 'Eaches'.
• Programmed and implemented multiple CRM's to the ILS enterprise software and interfaces to the manufacturing subsystems.
• Provided production support, significantly reducing mean time resolution of production issues.
• Programmed FTP scripts for EDI communication protocols.
• Provided support and maintenance of EDI transaction processing.
• Environment.iSeries, RPGLE, SQL, Turnover, Hawkeye.

Senior Programmer/Analyst

Confidential, Anaheim, CA

Responsibilities:

• Developed Vendor Compliance processing application.
• Designed, programmed and implemented bridge interface from Order Power to PKMS warehouse package to facilitate order release and shipments.
• Designed and implemented Pre-Pack Tool, providing Buyers and Allocators with functionality to optimize number of prepacks and full cartons in the process of creating Purchase Orders.
• As lead member of E-Commerce team managed numerous enhancements to the international order processing application.
• Designed, programmed and implemented Password Encryption project to provide Confidential with ability to custom encrypt/decrypt and replicate user's passwords across selected servers. Implementation utilized a number of advanced system functions, including IBM's APIs, service programs, creation of special randomization routines to provide unique values for encryption keys.
• Modified Pacific Island and MMS software packages to facilitate additional Distribution Centers.
• Developed Return to Vendor (RTV) module for WM (PkMS) to simplify returns and make them transparent to IP( Confidential ) application.

Senior Programmer/Analyst - Consultant

Confidential, Brea, CA

Responsibilities:

• Developed company-wide warehousing operations project to implement requirements to establish FIFO based stock rotation logic for picking, put-aways, replenishments, intra-warehouse moves, etc.
• Made numerous modifications to Spike Demand Forecasting, Inventory Allocation, Bills of Lading, Pricing and Order Processing applications.
• Extensively worked with EDI applications, developing inbound and outbound mapping to conform to EDI standards and the trading partner's requirements.

Sr. Developer

Confidential, Fountain Valley, CA

Responsibilities:

• Took part in company-wide conversion from mainframe Cobol written applications to RPGLE AS/400 platform.
• Modified and maintained various application modules: Parts, Warranty, Customer Affairs, Dealers.
• Designed and implemented Dropship Order processing for parts vendors.
• Designed, coded and implemented Client Server Cycle Count Inventory application,using IBM's Websphere Visual RPG
• Build complex business forms using advanced IBM's and 3rd party printing software functions.

Project Manager

Confidential, Costa Mesa, CA

Responsibilities:

• Supervised customization of Confidential System 21 software for the following Confidential clients: