SUMMARY

• Over 15 years of experience in IT, including Supply Chain Management/Logistics, Manhattan WMS (SCALE/ILS.Net, WMOS), TMS, LMS, Utilities, etc.
• Responsible for turning up an unhappy customer (supply chain) to become referenceable in Asia - Pacific region.
• Expertise in Implementation, upgrade, analysis, design, development of product modifications/enhancements, production support of Supply Chain Management Solution - Manhattan WMOS and SCALE/ILS.Net, LMS, TMS in multiple Distribution Centers (DCs) .
• Awarded with Feather In My Cap (FIMC) by Confidential for the excellent coordination and handling of customer database issues which shows my capability to handle projects single-handedly and as a motivated team player.
• Implementation, customization and technical consultancy for MARC WMS global help desk.
• Demonstrated interaction with operations, good leadership, project management, logical thinking and time management skills.
• Expert in Documenting Functional Designs and Technical writings of operational and system procedures.
• Lead teams in developing new products in Supply Chain Management related to MARC-WMS such as 3rd Party Logistics (3PL), Billing, Transportation Management System, Labor Management System, Spare Parts Management System, eBiznet, etc.
• Experience in i2 applications such as Supply Chain Planner (SCP), Demand Planner (DP), etc.
• Knowledge on Forecasting and Inventory Optimization solutions.
• Experience in Energy & Utilities - Customer Information System (CIS) - Banner, Oracle’s Customer Care &Billing (CC&B) system.
• Expertise in Database Building, Analysis, Design, Coding, Testing and Team Management as a Project Leader.
• Expertise in performance tuning of SQL queries, PL/SQL - stored procedures, database archiving, database backup and recovery techniques.
• Experience in Tibco BW designer 5.9, BE 4.2, EMS scripting for integrating applications at enterprise level.
• Expertise in various technologies: Oracle, Oracle Applications, Developer Forms6i, Reports 6i, PL/SQL, SQL Server, UNIX Shell Scripting, and Informatica ETL.
• Experience in C#, .Net, J2EE, J#, VB Script, C, C++, VC++, ActiveXControls, MFC, ASP, XML, HTML, OOPs Concepts.
• Extensive experience in software configuration management tools such as Team Foundation Server, SVN, First Choice, ClearCase, PVCS, CVS, WinCVS, ClearQuest and Remedy.

TECHNICAL SKILLS

Databases/Data Warehousing: Oracle 7.x/8.x/8i/9i/10g/11g, SQL Server 2003/2005/2008 , Sybase, MySQL, MS Access, Data modeling, Informatica ETL Extract

Programming Languages: ASP, VBScript, Java script, C#, J#, PL/SQL, C, C++, VC++, Pro*C/C++, VB 6, Unix shell scripts, PERL, T-SQL

.Net/Web Technologies: XML, XSLT, ASP.Net, Visual Studio.Net 2003/2005/2008 , ADO.Net, Win Forms, We Forms, XML Web Services, .Net Framework 3.0, Hibernate, WCF, WPF, HTML, DHTML, COM, VBScript, Java script, ODBC, OLEDB, FTP, HTTP, TCP/IP, Serialization, C#/J#.Net

Development/Testing Tools: SQL Profiler, SQL, SQL*PLUS, Developer 2000 Forms 6i, Reports 6i, SQL*Loader, SQL*Plus, Business Objects Crystal Reports XI, Expect, Borland C++, Visual Basic, Oracle Applications, HP QTP10.0, Load Runner, ASP.Net Development Server, MS Office, Install Shield, Tibco EMS, BE 4.2/BW 5.9, EMS server, Xpath Formula editor, BMC Middle ware for MQ queues, Gems, etc.

Software Engineering Methodologies /Tools: FirstWave, First Choice, Borland’s StarTeam, Clear Case, Clear Quest, CVS, Win CVS, PVCS, ER Win and MS Visio, Team Foundation Server (TFS), Tortiose SVN, Teamforge, HPALM, Jira, Confluence

Operating Systems: Functional Areas

MS Windows, Sun Solaris, Unix, Linux: Confidential Warehouse Management Systems - WMOS 2010, WMW/ILS.Net/SCALE, MARC, Supply Chain Management - i2 Demand Planner, i2 Supply Chain Planner, 3PL Billing, Customer Information Systems - Banner and Oracle CC&B, Risk Management, Backup and Recovery, Consulting, Production maintenance and support, host Integration, middleware, BMC MQ, etc.

Domain Areas: Supply Chain Management, Warehouse Management Systems, Embedded Systems, Health Care, Manufacturing, Energy & Utilities

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior WMS Analyst

Responsibilities:

• Responsible for requirements gathering, design, development, code review, integration and deployment of Projects - NCT/ SIT, which transfers Inventory from Stores to all 6 distribution centers of Confidential .com and Bloomies.com.
• Responsible for requirements gathering, design, development, code review, integration and deployment of Projects - ASN Receiving, Item integration through enterprise level and eliminate integration through Legacy systems.
• Visualize models, development, testing, Integration, deployment, support of Single View Inventory project for the entries level visibility to combine/eliminate certain departments.
• Work with Implementation team for the configuration of Confidential warehouse management systems (WMOS 2010) in 3 Mega distribution centers and deployment of new features like to the rest of 3 facilities.
• Implement and support of application Configuration and functionality, Users/Role/Access Administration, Configure Transactions/Tran Params, Putaway Rules setup, Cycle count rules setup, Tasks and Priorities, Work Order Processing, Receiving, Order Allocation, Picking, Packing, Shipping, Transportation planning/Routing, Inventory Management, Cycle counting, physical inventory, Shipment Confirmation, Reports Verification, etc.
• Technical and functional support for enterprise level integration with other systems like Vendor Management, Receiving, Fulfillment, Inventory, Peoplesoft, Logistics, Pricing, PDF for Item, IFS, MQ team, Unix, DBA, etc.
• Document the Functional Designs, Detail Designs, Technical specifications, Process flow, Test Plans design, Use cases, Test cases, User Manuals, etc.
• Work with enterprise teams for business requirements, design changes, application integration, configuration and troubleshooting defects and bad data issues.
• Identify, document and recommend solutions, code enhancements to Manhattan WM application and internal applications, Relational database design, Flow diagrams, Data mapping, etc.
• Design, development, implementation of custom modules for WMOS using Oracle stored procedures, DB scheduler jobs, Tibco BW/BE,Web service calls, EMS, Unix shell scripting, Java, SSRS reporting.
• Setup production servers, WAS configuration, Users Integration/create new users, Configure Listeners, Routers, Schedulers, Device end points, Smoke testing, during go-live.
• Provided techno functional support, debug and enable high logging for Java/C++ PkMS programs, building Jasper, SSRS Reports, SSIS, troubleshooting of production issues reported by operations, analyze the root case and provide a resolution or work-a-round, document the resolution/root cause analysis in First choice, .
• 24x7 Production support during implementation go-lives and peak holiday seasons.
• Explore and recommend solutions to business requirements and issues.
• Setup test environment, deploy and Configure environment to support various testing teams and resolve the defects logged in HPQC, Jira Bug in onsite-offshore model.
• Work with communication to/from MHE material handling systems, RF devices, Pyramid, Baumer, Tilt Tray, CommTool, etc.
• Work with 3rdparty service providers and offshores support teams.
• Schedule, Monitor batch jobs, job logs and take ownership on actions.
• Support DB Refresh, patches, periodic disaster recovery activities and attend change control meetings.

Confidential

Senior IT Consultant

Responsibilities:

• Responsible for design, development, Testing of “Stock Management System” (SMS) application which will fulfill the needs of small stores in managing their products using .Net and SQL Server.
• Application development using ASP.Net, C#, HTML, XML, XSL, etc.
• Backend development in SQL Server Functions, Stored Procedures, Packages, Triggers, Job scheduling, etc.
• Consulting and Technical support for projects related to C++, C#.Net, Java, J2EE, Oracle and SQL Server databases.
• Reports development using crystal reports XI.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Unit testing and system level testing of SMS application.
• Database maintenance for healthcare and supply chain related projects.
• Provide technical support with Supply Chain systems/ Warehouse Management Systems(WMS), Order Fulfillment Systems, Health care related projects in overseas and united states.
• Provide test scripts for testing automation using HP QTP tool.
• Mentor new team members.

Confidential

Independent IT Consultant

Responsibilities:

• Provide technical support with ASP.Net, C#.Net coding, Oracle, SQL Server database development of Warehouse Management Systems and Health care related projects in overseas.
• Testing Automation of Flight reservation application using HP-QTP tool.
• Provide online training on C/C++ programming, Oracle, SQL server databases, C#.Net, Testing Automation tools.
• Reports development using Oracle forms, Crystal reports.

Confidential, Atlanta, GA

Senior Consultant WMS

Responsibilities:

• Consulting and support of the highly complex Confidential Warehouse Management System SCALE (Integrated Logistics Solution-ILS.Net/WMW), Built on SCOPE, Microsoft .Net software system.
• Played a vital role in turning up an unhappy customer to a “REFERENCEABLE” customer in upcoming market region (Asia-Pacific) of the product. Responsible for resolving around 30 issues with SCALE/ILS.Net configuration and software application, which was implemented by channel partner in Russian Language.
• Manage and execute Warehouse Management System implementation projects, product upgrade, modifications and facility upgrade.
• Work independently on tasks while interacting with clients in USA, Canada, Mexico and APAC region.
• Configure functional flows and design modifications for 3PL, pharmaceutical, food & beverage, Retail industries and Electronics Distributors.
• Support customers and channel partners for any functional and technical issues within SCALE/ILS.net WMS.
• Integrate the WMS product with ERP systems like SAP, Peoplesoft, Microsoft Dynamics AX (formerly Axapta), Microsoft Dynamics GP (formerly Great Plains) and other systems like Billing, Fedex Ship Manager, etc.
• Work with vendors like Business Objects, Microsoft, Parcel Carriers like Fedex, USPS, UPS, Connectship-Progistics, DHL for product integration, configuration and trouble shooting.
• Design and development of customized modules for windows application and RF application in C#.Net, ASP.Net, Windows SQL Server 2005/2008, SSIS, SSRS, Crystal Reports, etc.
• Prepare and present requirements documentation per company standards, Design, develop, test and implement patches for defects.
• Responsible for preparing time & cost estimation and get them signed by clients for any new enhancements.
• Assisting customers with Oracle and SQL Server database backup, DB maintenance, cycle counting, Picklist and Packlist, Shipping Barcode Labels printing, Configuring label printers, etc.
• Document and update product installation and DB maintenance instructions for non DBA personnel at client side .
• Train and mentor new team members/clients on ILS.Net WMS software product and technology.
• Work in a collaborative workflow process where multiple people participate in varying roles on one task. Worked with UK and Russian channel partners as well.
• Work with professional services, Research & Development team and the 3rd party integrators and partners to upgrade, enhance the product.
• Responsible for design, develop, test, upgrade, and troubleshoot of ILS.Net WMS software patches.
• Configuring and scheduling automated jobs using Windows scheduler, sending messages using Message Queue Interface (MQI) and Remote Procedure Call (RPC).
• Created and used Web Services, Spring.Net, Hibernate, COM Components, DLLs, Component Services, Event Viewer log, ODBC of System Administration tools.
• Designed and developed around 20 Key Performance Indicators (KPI) reports for various clients which also prints Barcodes and some special labels using Business Objects Crystal reports, SSIS, SSRS reporting.
• Used SQL Profiler extensively for performance, timing measure, tuning.
• Provide 24x7 On-Call support of the WMS product.
• Responsible for building offshore support team in India.

Confidential, Atlanta, GA

Senior Consultant

Responsibilities:

• Banner maintenance, enhancements, and developing custom applications.
• Conversion of Banner database, reports to CC&B database.
• CC&B Configuration Testing -designing data validation criteria andreports.
• Maintenance and support of applications related to Risk and Supply, NYMEX real-time data feed.
• Handling business critical applications to compute monthly natural gas reload.
• Development of custom applications/reports around Banner such as data marts, Life Cycle reports, etc.
• Coding in UNIX shell, Perl scripts, PL/SQL Functions, Stored Procedures, Packages, Triggers and Collections. Job scheduling, etc

Database Analyst and Coordinator

Confidential, Houston, TX

Responsibilities:

• Leading a team of 4 members at offshore and communicate with onsite team/client on the project status.
• Study of the current As-IS Netback System
• Document the functional and technical architecture of the system.
• Define the requirements of the future state of the system.
• Perform a gap analysis between the current state and the requirements and provide an overall high level solution for the future system.
• Database design with the help of inputs from Confidential
• Coding in UNIX shell, Perl scripts, PL/SQL Functions, Stored Procedures, Packages, Triggers and Collections. Job scheduling using tool Maestro.
• Application User Interface development in C#, ASP.Net, Java, ASP, XML, etc.
• Designing the Functional and Technical specifications
• Reviewing the documents during define phase.

Module Leader

Confidential, San Diego, CA

Responsibilities:

• Leading the database team in executing the project related tasks and interaction with the customer.
• Responsible for database requirements capture, design and implementation of the backend functionality.
• Coding in UNIX shell, Perl scripts, PL/SQL Functions, Stored Procedures, Packages, Triggers and Collections. Job scheduling, etc.
• Design and execution of the test plan and test cases for the system.
• Application User Interface development in Java, ASP, HTML, XML, etc.

Technical Lead

Confidential, Minneapolis, MN

Responsibilities:

• Technical Lead from offshore for 4 members’ team and responsible for delivering the quality work for i2 applications’ Demand Planner (DP), Distribution Requirements Planning (DRP), Inventory Planning (IP), Supply Chain Planning (SCP), and Pipeline for its various business units.
• Responsible for Database design alterations, application development, testing and implementation of i2 applications enhancements using Oracle Forms 6i, Oracle Reports 6i.
• Production-support and maintenance of Demand Planner, Supply Chain Planner applications.
• Coding in UNIX shell, Perl scripts, PL/SQL Functions, Stored Procedures, Packages, Triggers and Collections. Job scheduling using tool Maestro.
• Responsible for moving offshore deliverables into production environment.
• Uploading of large data in files into production using SQL*Loader.
• Conducting code review, unit and system level testing.
• Knowledge transition to offshore team on business applications, database schema objects and stored procedures, internal applications on project management, job scheduler (Maestro), PVCS.

Consultant

Confidential, Minneapolis, MN

Responsibilities:

• Database design, development, testing, implementation for SN6000 VTM.
• Implementation of product enhancements like database disaster recovery from remote machine, upgrading to higher product version, and downgrading back.
• Coordinate with client, onsite team and offshore team.
• Maintenance and support of database and embedded interface modules.
• Tuning of SQL queries, PL/SQL procedures and packages and code development.
• Application Interface development in Pro*C/C++, Java, Embedded C/C++ Programming.
• Unit and system level testing.
• Used Toad debugger, Remedy, and CVS extensively.

Confidential

Project Leader

Responsibilities:

• Project Leader for “MARC 3PL Billing” product. Lead the project and responsible for successful development and upgrade of product, in all phases of Product & Software Development Life Cycle (SDLC). Responsibilities include analyzing system requirements, design of functional, technical specifications and QA procedures, source code management using CVS, PVCS, UI design in Developer 2000 Forms 6i, Reports 6i, business logic implementation in PL/SQL, Pro*C.
• Project Leader for MARC WMS based customizations and Implementations for more TEMPthan 30 application programs. Responsibilities include, gathering the requirements, design of technical specifications, assign some of development work to developers, developed interfaces with ERP packages, UI screens, reports and application programs using Pro*C, PL/SQL, Developer 2000 Forms an reports, Unix shell scripts, Bar coding, etc.
• Project Leader for Confidential project. Responsibilities include interacting with business users, analyzing the system requirements, design of functional and technical specifications, development of interface programs using Pro*C, development of forms, performance reports, QA and source code management.
• Responsible for gathering requirements, Technical specifications design, for “Reliance India Mobile (RIM)-eBizNET” Distribution and Warehouse Management System. Design, development, unit and system level testing of backend modules, interfaces using Pro*C/C++, Oracle PL/SQL Packages, Procedures, Functions & Triggers, TOAD, XML, ASP. UI Code development in ASP.Net, Java, etc. Responsible for source code management using Rational ClearCase, CVS and WinCVS. Responsible for build release for testing and client.
• Responsible for design of Technical specifications, development, unit and system level testing of “MARC SCE Configurator” project for centralizing the client configurations and project issues. Designed and development user interface, offline and online help links using Visual C++/C++, XML, XSLT. Developed programs for interacting with MARC database using Packages, Procedures, and Functions & Triggers.
• System level testing
• Responsible for Functional and Technical specifications design, development, unit and system level testing of “checkMARC.net” application, which mobilizes the MARC-WMS. Completely responsible for development of backend modules, generate MARC data as interfaces using Oracle XML utilities, Pro*C/C++, Oracle PL/SQL Packages, Procedures, Functions & Triggers, XML, XSLT, etc.
• Developed MARC WMS Billing module based on events such as picking, packing, shipping. The invoices are triggered based on various criterion like order priority, customer, etc.
• Responsible for development of forms and reports for Strategic Parts Management System (SPMS) application for TNT, Dubai which fulfills the orders received from the Service Partners (SP) for the faulty parts during the warranty period. Generated efficiency, performance reports based on time lag between events.
• Responsible for MARC WMS help desk support, which involves extensive backend coding, functional flow configuration, developing different MIS reports, maintenance screens, etc.
• Responsible for development of “MARC WMS on PDA” project. Developed PDA (Palmtop-V) front end forms using Satellite Forms, MS Access database, and Palm operating system. Developed MARC WMS interfaces using Oracle Developer 2000, Oracle 7.x, ODBC, ActiveX controls and OOPs concepts. Developed database Triggers and Stored Procedures for processing user requests.
• Responsible for development of Spare Parts Management System (pilot project) using Visual Basic as front end and MS Access as back end.

Confidential

Programmer

Responsibilities:

• Responsible for providing project status updates to Defense Electronics Research Labs (DLRL).
• Responsible for development, testing and integration of the Receiver Interface Processor (RIP) Simulator.
• Involved in requirements gathering, design, development and testing of the RIP TestJig.
• Developed programs in VC++/C++ using MFC, ActiveX Controls, API, DLLs. Etc.
• Interface with RIP using RS-232 Serial Communication.