SUMMARY

• 6+ years of experience in Full Software Development Life Cycle (SDLC) includes requirements definition, design, testing, implementation, production support and enhancements of existing systems.
• 4 years of experience in Warehouse Management Systems such as RedPrairie Discrete Dlx, Dlx plus and Catalyst.
• Experience in RedPrairie Report Designer, Tracelog, Moca Crashlogs and DDA.
• Knowledge in LENS, EMS, LMS and MOCA commands
• Actively involved in System Performance Monitoring including Integrator Dataflow.
• Experience in Unix Shell scripting, Oracle and application development in client/server and distributed environments in Mission critical Enterprise applications.
• Experience in DBMS structure and PL/SQL (Query and Stored Procedures) and SQL programming.
• Experience in Oracle RDBMS, SQL Server and its tools SQL, PL/SQL, SQL* Loader, SQL*Plus, SQL Navigator and TOAD.
• Knowledge in Technical and Functional aspects of Supply Chain, Order to cash and Manufacturing Modules which include Order Management (OM), Inventory (INV), Pricing (QP).
• Worked on large - scale projects from conceptual stages through implementation and rollout on client-server and web-platforms.
• Done Manual Testing with scripts in QA before implementation.
• Good team player with excellent communication skills, interpersonal skills with problem solving, trouble-shooting capabilities.

TECHNICAL SKILLS

Operating Systems: Windows XP/2000/NT, UNIX, Linux, DOS

Scripting Languages: PL/SQL, SQL server and Shell.

Database: Oracle 9iAS/10g DB2 8.0 Sql Server

Web: HTML, DHTML, FrontPage, XML Schema

Front End Tools: TOAD, SQL Builder, Secure CRT, LextEdit.

WMS: RedPrairie Discrete and Catalyst

PROFESSIONAL EXPERIENCE

Confidential, Lynchburg, VA

Red Prairie WMS Production Support

Responsibilities:

• Providing Production support and closely working with the Warehouse team in processing orders and to sort issues if any even during late hours and weekends.
• Working closely with the Wave planning team, Pick and Pack team and the Shipping team to optimize the operations.
• Created and maintained Carryover reports for different warehouses.
• Created Triggers for EMS (Event Management System) and tested it.
• Performance monitoring round the shift to keep the CPU usage under control.
• Frequent Monitoring of Integrator for constant data flow.
• Frequent Monitoring of LMS tasks.
• Developed DDA and MOCA commands and maintained Scheduled agent operations.
• Optimized the goodstock operations for the Customer return stock.
• Supporting this system till date without any escalation and have achieved a good rapport with Confidential Warehouse team.
• Involved in end to end testing from the host to the WMS system.
• Developed and organized test plans and map to functional flow and layout of the WMS System.
• Review the WMS error, warning and message logs, Trace log, Moca Crash log cases with response center.
• Executing adhoc reports for the warehouse managers
• Train warehouse personnel on the warehouse management systems
• Creation of test scripts for new projects and support go-lives for new warehouses
• Translated high-level business requirements into detailed functional specifications and managed requests for changes to the specifications
• Co-ordinated with the business in determining which processes can/should be automated and how they can then be integrated with other business processes
• Managed daily activities, issue resolution and communication across project execution teams in order
• To deliver projects on-time, on-budget, as-requested by customer

Confidential, Mechanicsville, VA

Red Prairie WMS Production Support

Responsibilities:

• Providing Production support and closely working with the Warehouse team in processing orders and to sort issues if any even during late hours.
• In depth knowledge of the warehouse operations, including procedural activities along with RF such as receiving, put away, inventory management, cycle counting, order allocation, picking, packing and shipping
• Executing Adhoc reports for the warehouse managers using RP Report Writer.
• Train warehouse personnel on the warehouse management systems
• Responsible for running the scripts and manually testing it for issues in development, QA and in production.
• Created new Lot Formats for various products for parsing manufacturing date from lot number
• Supporting this system till date without any escalation and have achieved a good rapport with Owens and Minor Warehouse team.
• Experience with MOCA commands, Trace Log files.
• Assisted the personnel in DDA development.
• Experience in creating and maintaining reports in RedPrairie LENS.
• Maintained quality and client satisfaction.
• Monitoring all the warehouse related data through the systems for successful processing. The transactions data included Orders, Receipts, Receipt authorizations, Inventory snapshots, Owner ship change requests/confirmations.

Confidential, Petersburg, VA

Red Prairie WMS Production Support and Developer

Responsibilities:

• Providing production support to the warehouse team and involving in warehouse operations, including procedural activities such as receiving, put away, inventory management, cycle counting, order allocation, picking, packing and shipping
• Coordinated with the Warehouse team to analyse as to where the new Kitting area to be introduced where dispensing of exact amount of the materials to be done needed for production in order to avoid the return of the excess amount which was practiced till recently.
• And also analyzed with the Warehouse team as to when the POCL ( Process Order Component Label ) to be generated in certain Move-Paths.
• Documented as discussed about updating of Movement - Paths of all the existing Production bays from the Warehouse High-Rack and generation of POCL and got approved from the Warehouse team.
• Wrote Shell Scripts for all the move-paths which are to be updated with Kit area for those where POCL are generated.
• Wrote Moca commands to run the scripts
• Solely responsible for running the scripts and manually testing it for issues in development, QA and in production.
• Supporting this system till date without any escalation and have achieved a good rapport with Boehringer Ingelheim Warehouse team and Application Managers
• Maintained quality and client satisfaction.

Confidential, Chicago, IL

Logistics Production Support

Responsibilities:

• Supporting Confidential Logistics two-core applications WMS (Warehouse Management Systems), TMS (Transport Management System) .These are Catalyst’s application products managed by confidential. Working as a production support analyst in various stages of the WMS application and the host system OPM (Order Pool Management ) by Softeon.
• Experience in Implementing Catalyst’s Warehouse Management Systems (WMS) for Third Party customers.
• Experience in Testing Catalyst’s Warehouse Management Systems (WMS).
• In depth knowledge of the warehouse operations, including procedural activities such as receiving, put away, inventory management, cycle counting, order allocation, picking, packing and shipping
• Worked on implementing the Irista system that co-ordinates between WMS system and freight systems (FedEx and UPS)
• Worked on creating Business Intelligence analysis reports KPI Eg: On-time and complete delivery, On-time and complete shipment, Order line cycle time, Order line cycle time Back orders, On-time on complete shipment& Cycle time
• Worked on installing the FedEx ship manager /Power Ship server and supported the ship trip monitor, FedEx services and UPS Host access systems.
• Coordinated with vendor in setting up the communication with our TMS server which holds the FedEx and UPS client, Loftware Server and supported the system.
• Worked on Network communications, Label printers, Pack Printers and Report Printers.
• Worked on implementing Fortna (Auto Labeling platform) & PCC (Price Labeling System) communication systems.
• Working as a production support expert for Sony Logistics Department. Worked with warehouse personals, Business Analysts and Business users through the life cycle of each project.
• Monitoring all the warehouse related data through the systems for successful processing. The transactions data included Orders, Receipts, Receipt authorizations, Inventory snapshots, Owner ship change requests/confirmations.
• Interact and coordinating with the host systems (GDS, Web Methods,COM-Oracle) for any data discrepancy.
• Helping the warehouse users in basic Warehouse functions like Shipping, Receiving and Inventory management.
• Involved in end to end testing from the host to the WMS system.
• Developed and organized test plans and map to functional flow and layout of the Catalyst’s WMS System.
• Review the WMS error, warning and message logs, log cases with response center.
• Executing adhoc reports for the warehouse managers
• Setup master data for the warehouse
• Support all the hardware issues for the warehouse.
• Train warehouse personnel on the warehouse management systems
• Creation of test scripts for new projects and support go-lives for new warehouses
• Enhancements for already existing applications like supply chain visibility, TRS, Out of Balance, SLA cycle count reports etc
• Support the month end close for the order management systems
• Handle all system configurations and setups for new products
• Coordinating with the transportation team and warehouse teams to resolve issues.
• Configuration of RF scanners for warehouse operations
• Convey data discrepancies to the Order Pool Management systems and with the business’s IT Team.
• Involved in collecting evidences for the SOX activities for all the Logistics applications WMS and TMS applications.
• Supporting this system without any escalation and have achieved a good rapport with Sony’s Business users and Application Managers Maintained quality and client satisfaction.

Confidential, San Diego, CA

Production Support Analyst

Environment: UNIX, Oracle, JDBC, DB2, HTML, SQL, Stored Procedures, ToadPL/SQL

Responsibilities:

• Worked as a production support expert for confidential Logistics Department. Worked with Business Analysts and Business users through the life cycle of each project.
• Have complete knowledge in the warehouse management system and Inventory management system. Solely responsible and successfully implemented the Red Prairie WMSlite application project in Hawaii within the given time frame. Ran through the entire business process, from setting up a new Warehouse, creating an order, transportation cost-cutting process and shipping procedures to the stage of setting up of label, laser printer and scanner environment.
• Worked in the Sony enhancement project POD. Wrote PL/SQL’s to connect to different database server and validate the data. UNIX script were written to trigger the .sql file and the process was automated in cron-tab. Wrote Shell scripts to push as well as pull the data from mainframe systems.
• Implemented the UNIX script enhancement (RA- Purging) in testing and production instance and performed Unit, Regression andUser Acceptability testing.
• Involved in database creation, data-mapping, Functional specs and developing interface programs for Sony’s future Freight Billing project for ATLAS. Developed PL/SQL for pulling the data from the created database and output a .txt file using UNIX and Java Script.
• Involved in the TMS-ATLAS enhancement project by implementing the data scripts in the database and performed compatibility test with the WMS applications.
• Supporting Sony’s two core Red Prairie application. TMS (Transport Management System & WMSlite (Warehouse management application). This is a third party vendor application, managed by Sony. Worked as a production support analyst in various stages of the application. Involved in variousautomated servers and database system. Worked extensively in the enhancement projects in TMS.
• Integrated with various groups and applications in implementing and enhancing the OOB (Out Of Balance) application and served as a secondary support for the application.
• Worked with Project Management to scope the Analysis effort and provide status and estimates.
• System expert in WMSlite application .Worked in building, implementing and enhancements of this system. Developed auto-program to generate invalid records. Gained experience in a couple of automation enhancement projects.
• Have in-depth knowledge of the various order cycle.
• Performed Backend testing by extensively using SQL queries to validate data integrity
• Developed stored procedures, triggers to check the data integrity.
• Supporting this system for more than a year without any escalation and have achieved a good rapport with Sony’s Business users and Application Managers.

Confidential

Production Support Analyst

Responsibilities:

• Create/Develop PL SQL procedure for reporting various business requirements.
• Troubleshooting the issues.
• Develops technical system documentation
• Interacting with Business team to collect the requirement.
• Ensures applications meet requirements and is error free
• Generate BRIO reports and making a communication between BRIO and WebSphere web service call.
• Creating and maintaining Properties file for interacting with main frame system
• Deliver design documents and collect the requirement from the concern division manager.
• Creating and executing test cases.
• Server performance and cache management.
• Integrating new modules with existed modules.
• Generate reports using excel adaptor with JSP and Servlet.
• 24 X 7 online production supports for the application and daily jobs.