PROFILE:

• Professional with diverse experience in full lifecycle Information Systems Application Development.
• Specific expertise in designing custom solutions and database schemas in an iSeries (IBM i, AS/400) environment.
• Strong technical background includes hands - on design and development of asynchronous, loosely-coupled processes for ease of implementation and upgrade.
• Proven ability to integrate data and processes of heterogeneous systems.
• Knowledge base includes insurance, distribution, manufacturing, warehousing, finance, association management and retail.
• Possesses strong knowledge of multi-channel order fulfillment processes.
• Knowledge and use of ITIL guidelines for guiding organizations towards best practices, service level metrics and accountability.
• Deep knowledge of encryption and decryption methods for the IBM i and Microsoft SQL Server databases.
• Successfully researched and implemented required encryption protocols required by the Payment Card Industry (PCI).
• Moved company toward modernized, browser-based user interfaces for IBM i (iSeries / AS400) interactive programs via PHP.
• Collaborates with stakeholders to ensure strong alignment between business and IT.
• Effectively shares knowledge with team and supports a learning, continuous improvement mindset.

TECHNOLOGY BACKGROUND:

Programming Languages: RPG/ILE, RPG-XML, Embedded SQL, CLP, XML processing, Subfile Programming, WebSmart, PHP, JavaScript, HTML, T-SQL, FTP, PGP, Lansa (iSeries), AS/SET, PL/SQL, SQL Plus

Databases: DB2 for IBM i, SQL Server 2005, Oracle 9i, mySQL, MS Access

Operating Systems: IBM i (iSeries, AS/400, OS/400, Power i), Windows 7, Linux (Ubuntu 14.04)

Enterprise Applications: CommercialWare Direct (Retail), PKMS (Warehousing/Distribution), MPAct (Association Management), Assist (Retail), BPCS (Manufacturing/Financials), Lawson (Financials), Mapics (Financials/Manufacturing)

Tools: Aldon Change Management System, MKS Implementer, WinSQL, CryptoComplete (iSeries encryption), Protegrity DPS (SQL server encryption), Information Builders iWay (middleware), X-Analysis, iSeries Navigator, WDSC, Case Studio 2, Toad Data Modeler, MS Office, MS Project, MS Outlook, MS Visio, NewLook

Miscellaneous: Expert in asynchronous program design using data queues.

PROFESSIONAL EXPERIENCE:

Consultant

Confidential, Corte Madera, CA

Responsibilities:

• CommercialWare Modifications
• Create Web Services for Billing Feeds
• Ship-Via 11 & 12 Pre-Pickgen Overrides
• Holding Orders with special code based on Order Value
• Line Held Reports
• PKMS (Manhattan) Modifications
• Created Slotting Detail Reports
• Created Location Utilization Reports
• WMS (Knighted Systems) Modifications
• Lock Code Project
• All Inventory Report
• Cycle Count Report
• Bin Capacity Report Enhancements
• Other miscellaneous reports and modifications

Senior Programmer

Confidential, Chicago, IL

Responsibilities:

• Re-architected and reprogrammed the Member’s Web Portal for the Workers’ Compensation .
• Designed and built a Virtual Tape Library (VTL) and automated FTP system to handle daily and full-system backups to a hot offsite location.

Consultant (Contract)

Confidential, Elk Grove Village, IL

Responsibilities:

• Modified the PKMS database and programming in order to comply with the new USPS and UPS barcode specifications (IMpb - Intelligent Mail package barcode).
• Required database field expansion to allow for a 34 character length barcode for tracking purposes. Printer files required precise reformatting and carrier recertification.
• Additional RPG ILE programming work as required.

Consultant

Confidential, Downers Grove, IL

Responsibilities:

• Web-based Information System:
• Modified RPG ILE programs to accept XML requests from a web page and 1) send information in XML format to the webpage 2) update information based on user responses and 3) return information to caller in XML format.
• Wrote and executed test plans for programs.
• Load Planner Decision Support System:
• Created new RPG ILE programs and SQL Stored Procedures to implement backend requests for the new Load Planner decision support system.
• Accepts XML requests from web-based application and updates the server database per specifications.
• Returns responses and error messages to calling programs via result sets.

Application Development and Integration Manager

Confidential, Elk Grove Village, IL

Responsibilities:

• Managed a team of four internal developers and an offshore group for in-house RPG and iWay data integration projects.
• The offshore team reduced direct costs approximately 54% while providing on-time completion of projects.
• Implemented a peer code review process that eliminated the need for on-call responsibilities for programmers.
• This resulted in project time compression due to the elimination of weekly compensation days.
• Directed the introduction and implementation of PHP technologies for iSeries front-end displays.
• These changes resulted in reduced costs of training of the seasonal order entry workers for the Customer Service department
• Architected and oversaw the PKMS modifications necessary for the drop ship and carrier update modifications.
• Created Business Requirements Documents and Project Documents.
• Developed Technical Design specifications for midrange and integration development projects.
• Ensured the availability of Training and User Acceptance Testing environments for end-users.
• Collaborated with functional departments to ensure adequate testing of applications.
• Monitored and enforced industrywide and customized development standards.
• Continued to maintain 20 - 25% hands-on programming duties in this role.

Senior Programmer

Confidential, Elk Grove Village, IL

Responsibilities:

• Designed, programmed and implemented the SQL Server and iSeries database schemas and processes for the Optical Character Recognition (OCR) Order entry system for mail orders.
• Mail orders were 40% of the order volume at the time.
• This project reduced the manpower required to enter these orders into the Order Entry and Management System by over 60%.
• Engineered the middleware interface and supervised the consultant that programmed the solution for the OCR to OEMS system.
• Designed and implemented the solution for automatically verifying scanned checks with a third-party vendor.
• This process allowed the company to quickly ship merchandise with confidence that the check was good or covered by the third-party vendor in case of insufficient funds. Also freed inventory for those orders submitted with fraudulent checks.
• Modified PKMS applications to accept SKUs from CommercialWare Direct via iWay middleware product.
• Designed and implemented the company’s “Extract - Transform - Load” (ETL) processes for the Marketing Database project.
• Designed, programmed and implemented the control and monitoring programs for the Customer Marketing Database (CMDB) project.
• Maintained company’s Enterprise Application Integration (EAI) framework using Information Builder’s iWay middleware solution.
• Designed, programmed and implemented the integration of Confidential ’s Sales/Use Tax system for CommercialWare software.
• This project resulted in compliance with tax jurisdictions in Kansas and Illinois, avoiding penalties.
• Designed, programmed and implemented On-Line Credit Card processing for CommercialWare’s Order Management system using PaymenTech as credit card processor for e-commerce and call center orders.
• This resulted in a 13% reduction in reserved inventory expense due to avoidance of rejected credit cards at shipment time.

Senior Consultant

Confidential, Schaumburg, IL

Responsibilities:

• Converted client’s legacy accounting and association management systems to Computer Application Specialist’s MPAct (Membership Plus Accounting) system.
• Wrote conversion specifications, wrote testing and verification procedures, coded the conversion programs using RPG/ILE.
• Engineered “bolt-on” enhancements to vendor software using Lansa (case tool) and RPG/ILE.
• Structured the operating environment into production, development, training, and quality-assurance areas.
• Proficient in the Lansa Development Toolset.

Senior Consultant

Confidential, Vernon Hills, IL

Responsibilities:

• Converted client’s legacy financial and purchasing systems from Confidential to a vendor package named Assist.
• Wrote specifications for the conversion programs.
• Wrote testing and verification procedures.
• Programmed all of the above.

Senior Consultant

Confidential, Milwaukee, WI

Responsibilities:

• Converted client’s legacy order entry and billing system to BPCS.
• Wrote conversion programs and wrote procedures for the end-users to verify their information.
• Modified client’s Confidential Manufacturing software to handle backflushing issues that are unique to this manufacturer.
• Wrote a custom subsystem that integrated into Confidential to allow for real-time reports based on government EPA regulations.
• Trained new programmers to use AS/SET case tool.
• Built a custom Project Control and Tracking system using Microsoft Access for the client.
• Modified reports and documents using FormsExpress software.

Engagement Manager / Senior Consultant

Confidential, Rolling Meadows, IL

Responsibilities:

• Modified client’s Confidential Manufacturing software to maintain and track customer orders by product line, grade, and weight.
• Modified Confidential software to streamline the product allocation process.
• Overhauled the order entry and maintenance logic to save the original order quantity for each line item and to allow an easier process for closing partially shipped line items.
• Order Entry, Inventory, Billing, Shop Floor, Advanced Process Industries (API) and Manufacturing Data Management.

Senior Technical Consultant

Confidential, Chicago, IL

Responsibilities:

• Conducted product education, system tuning, and programming services for clients implementing Confidential Manufacturing software.
• Conceptual services provided included Physical Database and Logical Data Modeling, Development Methodologies, and conducting Joint Application Requirements and Definition sessions using Rapid Development Techniques.
• Provided Application Development services with AS/SET Programming tools
• Advised Client Management regarding staffing and hardware requirements for Information Systems department.
• Performed system performance audits.