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 WMOS, 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, BPCS, 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, Brentwood, TN

Senior Manhattan WMOS Support Analyst

Responsibilities:

• Supporting Manhattan WMOS 2006 and 2008 on Linux open systems platform.
• Provided guidance and technical support to business users on the appropriate use on Manhattan WMOS.
• Production support for the application to ensure the integrity, stability and system availability on a 24/7 basis
• Address issues and root cause resulting from application monitoring to ensure system availibilit.
• Performed testing against code fix, implement new SDN’s.

Confidential, Bellingham, MA

Senior Programmer Analyst

Responsibilities:

• 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:

• 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, Natick, MA

Lead Programmer Analyst

Responsibilities:

• Supported Manhattan Associates Web based WMOS 2003 application for Confidential ’s distribution centers at Uxbridge,MA, Burlington, NJ and Jacksonville, FL. This position included troubleshooting using Oracle Sql, working with other IT groups, in addition to documenting procedures and events. Streamlined and helped automate the various day do day operations as scheduled job, Purges, Ilm updates.
• Provided leadership and technical expertise during the implementation of the Manhattan WMS solution at Confidential ’s Confidential and Jacksonville DC’s.
• Converted Confidential NJ and Jacksonville FL DC’s reporting on Manhattan’s Performance Management reporting application.
• Assisted the installation of WM OS at Confidential 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 SCC 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

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 WEA HealthCare Applications using AS/400 and RPG ILE
• Modified and enhanced various health care Insurance related programs

Confidential, Ft. Lauderdale, FL

Senior Programmer Analyst

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.

Confidential, Newton, MA

Responsibilities:

• 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.
• Conversion project for Accounts receivables, Payroll & Human resources applications from S36 mode to full AS400 RPG/400 and DB2/400 compliant.
• 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.
• Year 2000 conversion and S/36 to AS/400 conversion projects
• Designed and created inquiry and update programs for Houston General Inquiries and updating of HG Claim numbers on existing system using RPG400.
• Worked with HG'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.
• Worked with JDE Fixed assets.
• 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
• Compliant outbound format EDI files transfer between EDI partners and Veratec.
• Automated night jobs. By using triggers to DB2/400 files