SUMMARY:

• About 8 years of IT experience in the Travel and Logistics Domain especially in the Warehouse Management System.
• Experience in Creating and Reviewing BRD, Functional and Technical specs.
• Interacted with business users for requirement gathering and end to end delivery.
• Provided business improvement plans and designs.
• Involved in lean processes and kaizens.
• Extensive experience in Application Development and support using C++, UNIX, SQL Server, Oracle and Informix 4GL.
• Troubleshooting, support & quick turnaround as a tier - 1 support for severity-1 production issues.
• Good understanding of OOPS concepts, STL, data structure and multithreading.
• Good exposure on working with Microsoft SQL Server 2008/2012 and Informix as Databases for Enterprise Applications.
• Good exposure on working with SSRS and Cognos.
• Complete end to end Knowledge of Provia (now Infor) WMS ((Warehouse Management System), product VIAWARE.
• Worked extensively in label designing using label vision.
• Strong understanding of various Business concepts like Inventory Management, Order Management, Warehouse management and EDI.
• Involved in end to end implementation of warehouse management system product.
• Responsibilities include Requirement analysis, designing, Coding and Unit Testing. Interacting with end users for requirement gathering.
• Highly flexible and adaptable contributor; adept at multi-tasking, meeting deadlines and thriving in a fast paced environment.
• Excellent information analysis, logic development, trouble shooting & learning skills
• Actively involved in Client interaction for requirement analysis, project estimation and related discussions.
• Manages a development, support team onsite and offshore for deliverables and works extensively with Product Managers.
• Hands on experience in supporting WMS implementation team and training Different offshore teams.
• Experience in understanding the requirement, dividing it into modules and distributing it among team member.
• Responsible for Mentoring junior associates and providing knowledge sharing sessions.
• Responsible for Work Load balancing, Invoicing and Reporting to client.
• Developed and maintained key metrics.
• Designed and configured WMS with Fortna WCS.

TECHNICAL SKILLS:

Databases: Informix Dynamic Server- 7.23, 7.31, 11.5, SQL Server 2008/2012,Oracle 11i

Language: C, C++, Informix 4-GL, T-SQL

GUI: Visual Studio 6.0, Microsoft Visual Studio 2008/2010/2012

Domain Technology: Warehouse Management System (WMS)

Operating Systems: Red Hat LINUX, UNIX, Windows

BI Technologies: SSIS, SSRS, COGNOS8

Version Control: TCCS, SVN, PVCS

Database Skills: Query Optimization techniques, joins, Stored Procedures, Triggers, Functions, Performance tuning, Execution plans etc.

PROFESSIONAL EXPERIENCE:

Confidential, Illinois

Project Lead

Responsibilities:

• Understanding the requirement, dividing it into modules and distributing it among team member.
• Current system study, interacting with the business users for the requirement gathering and preparing Functional Specification documents.
• Design a client server architecture for message flow between Jennifer and WMS ADS(Exceed).
• Design EDI interface and mapping.
• Understand business rules and design a performance efficient architecture.
• Divide the current picking into modules to support Jennifer implementation.
• Develop the interface in C/C++ and Informix -4gl.
• Troubleshooting, support & quick turnaround as a tier-1 support for go live production issues.
• Providing Knowledge transfer to the support team.

Environment: IBM AIX, Oracle 11i

Project Lead

Responsibilities:

• Understanding the requirement, dividing it into modules and distributing it among team member.
• Work Load balancing.
• Invoicing and Reporting.
• Troubleshooting, support & quick turnaround as a tier-1 support for severity-1 production issues.
• Current system study, interacting with the business users for the requirement gathering and preparing Functional Specification documents.
• Involved in installing and migrating MS SQL Server 2008R2 to MS SQL Server 2012.
• Designed and normalized the database and created different objects like Tables, Views Stored Procedures, UDFs, Indexes Rules and defaults on MS SQL Server.
• Research with team members and came up with the high level design, impact analysis document with several solutions to the problem during implementation proposed new system.
• Created SQL Server reports using SSRS and exported them to Excel format for managers and QA team for easy validation.
• Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various in-house users.
• Monitor all warehouse activities from the Con-Way WMS system including receiving, picking, replenishment, cycle counting and shipping.
• Catch weighted items are addressed through the UCC-128 format
• Supporting Industry standard bar code formats.
• Add accountability, inventory control and accuracy with con-way WMS.
• Preparation of Technical Specification and Test Cases.
• Development of code in languages C++ and Informix - 4GL.
• Making changes in SQL Server and Informix Database.
• SQL query optimization, Analyzing Execution plans and query tuning for Performance issues
• Designing Labels using Label Vision.
• Unit testing of the code changes.
• Designed and configured WMS with Fortna WCS.

Environment: C++ (GUI), Informix 4GL (RF), Informix Dynamic server and SQL server 2008/2012, Microsoft Visual C++ 6.0, Microsoft Visual Studio 2008/2010

Team Lead and onsite coordinator

Responsibilities:

• Current system study, interacting with the business users for the requirement gathering and preparing Functional Specification documents.
• Managing offshore Team and giving training sessions whenever required
• Troubleshooting, support & quick turnaround as a tier-1 support for severity-1 production issues.
• Monitor all warehouse activities from the Con-Way WMS system including receiving, picking, replenishment, cycle counting and shipping.
• Catch weighted items are addressed through the UCC-128 format
• Supporting Industry standard bar code formats.
• Add accountability, inventory control and accuracy with con-way WMS.
• Preparation of Technical Specification and Test Cases.
• Development of code in languages C++ and Informix - 4GL.
• Making changes in SQL Server and Informix Database.
• SQL query optimization, Analyzing Execution plans and query tuning for Performance issues
• Designing Reports using SSRS and Cognos.
• Designing Labels using Label Vision.
• Unit testing of the code changes.

Environment: C++ (GUI), Informix 4GL (RF), Informix Dynamic server and SQL server 2008/2012, Microsoft Visual C++ 6.0, Microsoft Visual Studio 2008/2010

Team Member

Responsibilities:

• Requirement Analysis for the change requests given by the client.
• Preparation of Technical Specification and Test Cases.
• Development of code in languages C++ and Informix - 4GL.
• Making changes in the Informix Database and sql server.
• Changing report formats as required.
• Unit testing of the code changes.

Environment: C++ (GUI), Informix 4GL (RF), Informix Dynamic server and SQL server 2008/2012, Microsoft Visual C++ 6.0, Microsoft Visual Studio 2008/2010