PROFESSIONAL SUMMARY:

• Result driven professional with more than twenty years of experience in developing reliable IT solutions for complex mission critical business operations such as sales, manufacturing, and marketing.
• Extensive system design and development experience with IBM midrange systems AS/400, S/34, S/36 and S/8, PCs, Oracle SQL, Unix, Manhattan associates web based WM application, and Ericson E2000 series. Have expertise in all stages of the SDLC - systems analysis, Programming, unit and system testing, troubleshooting, and providing production support.
• Provided consulting for turnkey IT solutions from hardware evaluation and system software requirements to providing cost and development time estimates.
• Team player and clear thinker with a high level of efficiency and productivity.

TECHNICAL SKILLS:

Databases: DB2400, Oracle, MS Access

Operating Systems: OS400, Windows, MS DOS, Unix, Linux, MSVisio, MS Access,VB, Code/400, MS-Project, Turnover, BRMS, ROBOT, FTP, IFS, MIMIX, Manhattan Associates WMS, PKMS, JDA

Langauges: Oracle Pl/SQL, MS Sequel SQL, RPG-II, -III, -IV, RPG 400 RPG-ILE, RPG Free, CLP, Synon, AS/SET, OS/400, S/36 SSP, S-36 OCL, QuerryI4OO, Confidential, DFU, Subfiles, SEU, SDA, RLU, DDS, DFU, DBU, COBOL, UNIBOL4OO, HTML, JavaScript, COBOL, DIL

Methodologies: Client Access, TCP/IP FTP,, Lotus Notes, ShowCase, Imrex, SQL/400, Hawkeye, Silvon, Implementer

PROFESSIONAL EXPERIENCE:

Confidential, Bellingham, MA

Senior Programmer Analyst

Responsibilities:

• Supporting VAI’s S2K ERP software and Retalix applications
• Troubleshoot issues with the applications, including downloads and uploads .
• Streamlined applications to work more efficiently. Automated IPL on I series on a regular basis
• Worked with various teams within the company.
• Provided Quality control and peer reviews, Implemented new process and modified existing process.
• Created unit and user test documents.
• Provided technical support.
• Participated in QA checks to ensure accuracy and & Reliability of program changes.
• Identified and documented existing business and IT processes. Created and simplified on call documentation
• Worked with BRMS Backup and recovery procedures, Work with ROBOT Job scheduler, Worked to upgrade DBU8 to DBU10
• Created unattended Automated IPL process, Worked with FTP and created FTP procedures, Monitored system performance
• 24/7 rotation basis supporting the Distribution Centers. Resolved help desk ticket with all details of deployment steps
• Worked with Itera, Worked with IFS folders, Worked with MQ channels..

Confidential, NJ

Manhattan WMOS Analyst

Responsibilities:

• Supporting Manhattan WMOS 2006 application for BCF’s Edgewater Park NJ and San Bernardino, CA Distribution centers Implemented Manhattan Associates SDN’s on the WMOS Linux servers Troubleshoot issues with the WM applications, including downloads and uploads to the Host System, performance monitoring, Oracle SQL and other tools. Ability to map and troubleshoot the functional flow of systems including EIS Comlink, MQ, WM and Host business system.
• Worked with various teams within the company to support the DC’s.. . Created unit and user test documents. Provided technical support.
• Coordinated with infrastructure teams to get the code built and deployed on the environments.
• Conduct unit testing, acceptance testing and integration testing to ensure accuracy and & Reliability of program changes.
• 24/7 rotation basis supporting the Distribution Centers.

Confidential, MA

Lead Programmer Analyst

Responsibilities:

• Provided leadership and technical expertise during the implementation of the Manhattan WMS solution at Confidential.
• Converted Burlington NJ and Jacksonville FL DC’s reporting on Manhattan’s Performance Management reporting application.
• Assisted the installation of WM OS at Burlington and Jacksonville DC’s and helped to resolved the post installation issues either caused by the database conversion or application. This required extensive use of Oracle DB updates using PL/SQL.
• Support on call on a 24/7 rotation basis.
• SME for Aldon Change management on the client.
• Identified and created procedures to streamline Wm oracle data base.
• Created and Implemented Process to Purge Pick ticket related data not being purged correctly due to modifications to the WM base code, but not made to the base WM purge program.
• Responsible and SME for Performance Manager and day to day running of PM.
• Created Oracle PL/SQL scripts to find the blocking locks and kill the runaway processes on the scanners.
• Created standardized PL/SQL script to support the data base update caused mostly by the DB blocking locks and or runaway processes
• Coordinated with infrastructure teams to get the code built and deployed on the environments.
• Worked with Load Runner tool to create automated testing scripts for WM and ILM. Created and ran monthly reports to show growth of critical tables. Identify root cause of most preventable issues related to records remaining in a "non purgeable status" and devise a fix for the priority itmes.
• Created and scheduled DC daily summary report to be sent as email attachment to the management using crystal report and Oracle PL/SQL.

Confidential, Framingham, MA

Sr. Programmer Analyst

Responsibilities:

• Responsible for maintenance and production support of PKMS’ and Legacy WMS application to support Confidential various distribution centers on AS400 in compliance with Sarbanes - Oxley and Confidential SDLC Methodology.
• Worked on Remedy 24/7 on call on weekly basis to resolve various production issues. This requires researching and resolving issues. Part of this is to drill down to and eliminate the root cause. Mentored new team members on how to resolve the issues and what steps needed to be taken to resolve these issues.
• Analyzed user requirements and prepared functional specifications, Business Requirement Document, and Document of understanding Involved in Confidential Stabilization process.
• Identified various issue related to Wrap &Label ASN, Proposed solution, time frame and fixed the issues within the given time frame.
• Worked with user to point out what is caused by user error and present with the solution on how to avoid these in future. Created trigger program so shat any changes made to scan type Changed Inquiry Program to reflect correctly the Carton scanned manually and Remotely Involved in PKMS Upgrade Version V4R1 from version V2000R1. PKMS Version 2004R1 Project. Retrofitting 2000R1 modified a number of programs into new WMS Version.
• Installed, tested and implemented Mark Magic Version 5. Participated and Coordinated Confidential Disaster Recovery Procedures.
• Work with establishing new Distribution center in Montreal, Canada. Also converted existing application to be multilingual English and French as required by law in the Province of Quebec, Canada. .
• This project is unique because we not only have to set up the new facility in the system but we have to offer a French version of all associate facing screens and reports.
• Worked with group member and members of other group to set guidelines for coming changes, additions to existing application.
• On Call, worked with Help Desk and FC’s to resolve on call issue as quickly as possible.
• Modified Host Apply Server Monitor Interface.
• Modified Confidential Dashboard Monitor to feed for all unprocessed, un-waved, pick tickets in PKMS.
• Added checks in Cubiscan program to avoid wave erroring.
• Changed Reorganize PkMS files process to re-organize multiple files at a time and to send e-mail and print error report, if file to be reorganized is locked by another Job the reorgs jobs are now submitted to 3 separate jobQs.
• Re-Send Weekly Slot IT. Created new programs to Back-up Slot IT file into a number of members defined in data area to be re-send by user a later time.
• Work with ROBOT Job scheduler
• OUTQ'S Clean Up Program before daily operations begin to submit Each FC or Group of OUTQ as file as a separate job.

Confidential, Jacksonville, FL

Independent Consultant

Responsibilities:

• Responsible for maintenance PKMS’ post implementation day-to-day support and management of various distribution centers on AS400 for fortune 500 clients. Worked with users and help desk to resolve various issues regarding PKMS application.
• Analyzed user requirements and prepared functional specifications, Business Requirement Document, and Document of understanding.
• Prepared time and cost estimates for development activities and system test design.
• Worked and coordinated with outside vendors, EDI partners and outside software providers.
• Worked with Help desk operations to resolve issues regarding Software Performance, correcting errors caused by data entry error or software bug.
• Worked with QA to setup new test environment, written test scripts for QA and Post implementation follow up. Initiated project and created program to start all server programs without automatically without operator intervention.
• Modified Pull list to print Pick ticket control number and Task Number Bar-coded and its human readable interpretation.
• Written functional specs, document of understanding and Created Trailer Manifest and receiving reports.
• Written and documented program to bridge EDI 856 Inbound and outbound transactions into PKMS Bridge files.
• Created program to change store# in IDCASE file after an ASN has been received, this function is not supported by PKMS Resolved problems caused by operational issues and wrote test notes for QA for changed/modified programs.
• Maintained and enhanced EDI856 inbound & outbound process Designed, document, written and tested Trailer Manifest and Receiving report.
• Written SQL Statements in CL program to mass update warehouse# in various files.
• Written SQLRPGLE programs to update changed Sku attributes in any file wherever it’s used.
• Enhanced and modified several programs to meet company new requirements.
• Written and documented scripts to correct wrong data entries not supported by PKMS
• Modified startup command to block users from entering PKMS if a backup is running.

Confidential, Madison, WI

Analyst

Responsibilities:

• Production support and maintenance for Confidential Applications using AS/400 and RPG ILE
• Modified and enhanced various health care Insurance related programs

Confidential, Ft. Lauderdale, FL

Senior Programmer Analyst

Responsibilities:

• PKMS 2001R1 Pre implementation Unit tested various PKMS 2001R1 module/programs.
• Modified RPGII and RPG400 based TSA's Bridge programs to feed JDA changes to PKMS and PKMS changes to JDA.
• Modified RPGIII, IV and ILE based TSA's programs to accommodate changes for PKMS 2001.
• Wrote RPG ILE programs to populate PKMS bridge files and server programs to populate PKMS master files.

Confidential, Dedham, MA

Sr. Software Consultant

Responsibilities:

• On site consulting for various clients on IBM AS400 platform using OS/400, RPG, CL, Subfiles, DB21400, triggers, SQL400, SDA, RLU, and QUERY4OO other tools related to AS400. Troubleshoot for a variety of system problems.
• Acted in a technical capacity to complete e assigned programming, testing, and conversion and implementation activities.
• Responsible for the evaluation of hardware and system software alternatives, preparing time and cost estimates for development activities and system test design. Responsible for analyzing functional Requirements, preparing External and Internal Design, preparing detail Program Specifications, all within the approved guidelines for the System Development Life Cycle.
• Modified and enhanced Employee Based System to interface Oracle based Compass system on AS/400 and Unix/Solaris based Unibol/4OO.
• Identified, documented, changed and tested the Changes in business Unit codes on various files to meet Fidelity's new requirements.
• Documented the new Unix Script procedures to be run on the new Unix box.
• Documented the flow of converted and migrated Unibol4OO application to be used as user guide
• Application/Production support to run the day-to-day business.
• Documented the missing application flow from user and technical point of view.
• Enhanced and modified and tested existing programs for more added functionality.
• Combined different language version into one entity.
• Worked as liaison between Prism and release management group.
• Management and implementation of day to operations for the new division financial including invoicing, billings and account receivables.
• Maintained professional contacts inside/outside the organization. Technical support and directions to the corporate headquarter tech. Staff and The Life Stream's end users.
• Analyzed, converted, re-coded, tested and implemented S36 OCL to CL., RPGII to RPG400, S36 data files to DB2400 RDB files.
• Wrote and implemented project plan for the various phases of this project
• Prepared and recommend method for workflow to achieve transition into Y2K and Native As4OO code conversion.
• Worked to resolve user/objects/menu security issues.
• Identified, documented, modified and implement any aspect of Confidential JDA based Merchandise Management System (SMMS) impacted by the Year 2000 (Y2k) and US Retail growth exceeding 999 locations in order to support the business strategy into the next millennium.
• Developed and maintain RPG II, III, IV and RPG ILE programs in the distribution system from JDA which supplies the more than 900 stores and warehouses in the U.S.
• Production support, bugs fix enhancements and production technical support.
• Worked with senior Management on design and enhancements to key business applications that improve overall efficiency and reduce costs and in the development of department standards and procedures.
• Documented and developed systems working methods and standards for Confidential requirements for documentation and testing.
• Developed and Coded in RPG ILE new solution to improve overall business processes.
• Analysis of current process for more functionality and productivity.
• Prepared time and cost estimates for development activities and system test design.
• Modified and enhanced travel reservation entry and marketing systems, billing and account receivables systems
• Evaluated, recommended and integrated new software for Confidential ’s business needs.
• Designed coded and tested downloads of excel spreadsheet to A5400 database to save time and double entries.
• Automated printout of air itineraries to be sent to the customers 90 days prior to departure.
• Enhanced and modified RPG II based pricing and rebates systems.
• Designed and created inquiry and update programs for Houston General Inquiries and updating of Confidential Claim numbers on existing system using RPG400.
• Worked with Confidential 's end user to identify their goals and made and executed plans to implement these goals.
• Designed, coded, tested and implemented batch programs to feed the MC's data warehouse.
• Worked with management and end users to identify their needs in implanting the new TMT to replace the legacy system.
• Prepared time and cost estimates for development activities and system test design.
• Designed and coded Mileage Billing subsystem to replace the Lily's Legacy system. The subsystem feeds the billing and vehicle information system processes in TMT and JDE.
• Designed coded and implemented Customer number, Vendor Number and vehicle number conversion in TMT System to be in consistence with JDE's Address books address number and JDE's fixed asset number.
• Started and managed the pilot phase, analyzed and made technical recommendation for reviewing, renovating programs for Y2K project.
• Worked as liaison between client and offshore Y2k team making technical recommendations, work heavily between end client and development team.
• Prepared time and cost estimates for management.
• Worked extensively with the chief security officer to resolve issues regarding user and object authorities’ issues.
• Started and managed technical design and code enhancement project to accomplish work flow improvements of manufacturing, distribution & order processing software; IMREX and ShawWare.
• Performed user interviews, produced design documents and provided production support
• Designed and coded SAP interfaces between Veratec AS/400 and IP's SAP Applications on IBM mainframe Host.
• Developed from specifications, a data mapping / formatting system, providing order processing transactions in an EDI

Confidential, Framingham, MA

Senior Analyst Programmer

Responsibilities:

• Performed coding modification, fixing bugs, enhancements and also daily production support on JDA retail system. Projects included Store to warehouse Returns, Damaged Goods Tracking Systems, Modifications of Payroll and financial systems, establishing Mid Atlantic database, and existing systems improvements and modifications
• Nynex telemarketing Systems maintenance and improvement of existing systems and development of new systems for Confidential telemarketing using AS/Set development tool.
• Confidential software package Modification for Medico's needs.
• Modified Confidential to allow shipping goods on the same order to multiple addresses on a line-by-line basis.
• Designed and created programs to print Bar-code labels for Zebra Printers, designed and wrote programs to download As/400 database files on PC using RPG and AS/Set.

Confidential

Lead Systems Analyst

Responsibilities:

• Responsible for analyzing Functional Requirements, preparing External and Internal Design, preparing detail Program Specifications, data model all within the approved guidelines for the System Development Life Cycle.
• Developed Systems working methods and standards for local requirements of Volvo Auto.
• Enhanced and developed security standards and procedures for existing and new systems.
• Prepared and conducted user training courses and manuals.
• Managed, designed and developed Dealers Follow Up and Management Reporting Systems on AS/400 using Synon/2 and Showcase.
• Project manager responsible for maintenance and enhancements of Marine Motors Warranty systems using Synon/2.
• Managed modifications and enhancements for Truck/Bus Warranty Systems supplied by Volvo Data Ab, Gothenburg Sweden.
• Maintenance and enhancements of material handling, Order Inventories and Volvo Importer Parts Systems according to the local specifications.
• Modified and enhancements of HR and financials including Billing, Accounts payable, accounts receivables, written extensively queries to support users day-to-day operations.
• Maintained Price handling System designed for maintenance of daily sales and purchase price according to local specifications.

Confidential

Lead Systems Analyst

Responsibilities:

• Project management, systems development, EDP designing, documentation and user training for COBOL based Ship Management System on IBM S/36 and AS/400.
• Assigned, directed and coordinated the work of the Programming staff.
• Provided technical support and direction to staff members.
• Managed team for the migration of Ship Management System originally developed on S/36 to AS/400.
• Changed 36 OCL procedures to use A5400 object/PG M/Menu security features.
• Maintained and enhanced RPG II and COBOL based Material Handling, Order Inventories and supply systems for Oy Sinebrychoff Ab Helsinki.
• Designed and programmed data exchange between VAX and S/36 and IBM host.
• Prepared and conducted user training courses.
• Developed systems working methods and standards for company's and customers’ requirements.

Confidential

EDP Analyst

Responsibilities:

• Team member worked in initial phase of new generation ATM machines.
• Maintained and programmed cash deposit and withdrawal transactions on bank Cash Register Terminals.
• Converted existing systems to satisfy software and hardware environments.
• Developed, documented and programmed new general purpose Cash Register System.