SUMMARY

Solid background encompassing all phases of the system development life cycle, a broad business background, and a strong understanding of business concepts.

SKILLS

Platforms:

• System i iSeries, AS/400 , S/38, S/36, various Unix platforms
• Databases:
• DB2 DB2 UDB, DB2/400 , OS/400 Native Database Manager, Oracle, Sybase
• Programming Languages / Development Tools:
• RPG - RPG ILE: Free-Form Fixed-Form, including sub-procedures and service programs. Also RPG IV, RPG/400, RPG-CGI, RPG III, RPG II
• COBOL - COBOL/400, Microfocus COBOL, ProCOBOL
• SQL - DB2, Oracle, Sybase, SPL, PL/SQL, Embedded SQL SQLRPGLE, SQLCBLI
• CA 2E Synon/Cool/Advantage 2E , CL, API, DDS, OCL, UNIX Bourne Korn Shell scripts , HTML, XML, XSLT, XSD, Tamino XQuery, CSO Sequences

Software:

IBM WDSC Websphere , PDM, iSeries Navigator, Aldon Change Management, TurnOver, Implementer, Microsoft Project, DBU, Hawkeye, Sequel, MQ Messaging, Excel, PowerPoint, Crossvision Service Orchestrator Studio, Manugistics DSM DP/EE, Kapiti International Banking, Skynet Accounting/Payroll, DCS Distribution, SAP, EDI, FTP, Email, RossetaNet, JDA

Business Applications:

Education Financing, Warehouse Management, Order Processing, Retail, Price Management, Point of Sale, Manufacturing, Accounting, Sales, Order Entry, Inventory, Freight Tracking, Payroll, Foreign Exchange, Mining, Refining, Banking, Logistics, Distribution, ERP, B2B

Strengths:

Project Management, Leadership, Analysis, Development and Technical Skills, Modular Programmimg, Documentation, Business Knowledge, Quality Assurance, Training and Mentoring, excellent Oral and Written Communication skills

PROFESSIONAL EXPERIENCE

Confidential

Senior Software Engineer - iSeries contract

• Design, develop and implement technical solutions for education financing systems and services. Technical Lead for development of skip tracing system interfacing with vendors:
• Design, develop and enhance software utilizing CA 2E Synon , RPG ILE, COBOL, SQL.

Confidential

Senior Programmer Analyst

• Supported Merchandising Operations systems principally Supply Chain and Pricing Management applications , and developed data feeds to extenal entity for freight auditing purposes:
• Data analysis, systems analysis, design, coding and system testing of application enhancements, utilizing RPG ILE, SQL, FTP.

Confidential

Contract Systems Analyst and Developer

• Systems enhancements and fixes to Store Management System and the POS interface, for a major convenience store and gas station chain:
• Data analysis, systems analysis, design, coding and system testing of application, utilizing RPG ILE, SQL, FTP.
• Designed, coded, tested, and implemented conversion of c. 5,000,000 e-com merce customers for Fry software implementation at a national retailer:
• Data analysis, mapping, design, coding and system testing of the conversion process, utilizing RPG IV ILE, SQL, FTP.

Confidential

Senior Programmer Analyst

• Supported Customer Support System and Customer Reporting System utilizing iSeries, Oracle, SAP:
• Data analysis and reconciliation between overseas manufacturing facilities and corporate databases.
• Design, development of enhancements and fixes using RPG IV ILE, SQL, XML, CSO Sequencing.

Confidential

Senior Programmer Analyst

• Point of Sales to E-Commerce Ordering P2E project on iSeries to process customer inquiries and customer orders from retail stores:
• Interfacing Point of Sale to Warehouse Management and Order Processing, ensuring data integrity with a goal of maximizing sales opportunities
• Designed, developed, and implemented iSeries inquiry and ordering application interfaced to point of sale via MQ Messaging, RPG IV ILE, SQL, CL.
• Support of existing RPG-CGI applications in a Warehouse environment utilizing WMS PkMS Warehouse Management System and CWD CommercialWare Direct - Order Management

Confidential

Senior Programmer Analyst / Project Leader

Managed Inventory Optimization Directed Put-Away project on iSeries:

• Designed allocation of inventory for orders to optimize inventory, receiving, returns, and replenishment put-away applications to directly replenish picking locations in order to concentrate inventory and decrease forced replenishments.
• Developed dispersal rating algorithm to optimize inventory based on the degree of effort required to move between locations within the distribution center.

Promoted to Project Leader.

• Managed Vendor Returns automation project on iSeries to process returns to vendors through Knapp distribution center automation:
• Designed solution, and led development, system test, demonstration, implementation.
• Delivered on schedule and at budget. Automates return of c.2.5 million units annually.
• Project Leader for up to 3 Programmer Analysts:
• Initiated project controls: future project planning, prioritizing and scheduling problem tracking.
• Took initiative for recruiting and interviewing programmers.
• Warehouse management system on iSeries and Knapp logistics infrastructure automation for distribution center:
• Planned, documented and led system test, release testing, user acceptance testing, and implementation.
• Planned and directed retrofitting of >400 existing programs to new database.
• Designed, developed automation interfaces, inventory control database and software using RPG IV ILE, SQL, CL.

Confidential

Senior Consultant

• Developed order management system for leading consumer electronics retailer utilizing Manugistics:
• Interfaced AS/400, Unix, Oracle and Sybase environments. Developed applications in RPG, ProCOBOL, Microfocus COBOL, SQL.
• Supervised 2 client programmers.
• Automated credit processing and invoicing procedures for major ophthalmic optics manufacturer:
• Designed and developed software for iSeries, using COBOL, CL, SQL, which reduced monthly manual transactions from 1,500 per month to less than 100, reducing hiring requirements by 2 people, and saving 57,000 per year.
• Integrated IT functions for major ophthalmic optics manufacturer after corporate acquisition:
• Designed, implemented merger of 1,852.8M per annum sales histories of parent and subsidiary.
• Performed systems analysis for iSeries Y2K compliance project:
• Analyzed date usage of 3,000 objects. Evaluated date renovation solutions for 250 COBOL programs. Developed test plans, directed EDI system testing. Led up to 5 developers.