Team Size Project: 10 Module: 5
Environment (with skill versions) Software Oracle 9i forms & reports, SQL, PL/SQL, Pro*C, IBM AIX UNIX 5.0 - Korn shell scripting, Appworx batch scheduler
Hardware Intel

Description
Gymboree Corporation is a specialty retailer operating stores selling high-quality apparel and accessories for children under the Gymboree, Gymboree Outlet, Janie and Jack, and Crazy 8 brands, as well as play programs for children under the Gymboree Play and Music brand, and women's clothing and accessories under the Shade brand.

Gymboree had implemented Oracle Retail version 10 and they wanted to have a retail support team which can look after daily application support activities along with development work for the project enhancements lining up. Currently there are few enhancement projects running such as:
Item Purging, Location Level Pricing extract for Markdown optimization, Warehouse unit retail price devaluation with e-commerce store. Also Gymboree looking for Performance improvements to their existing batch processes across Oracle Retail modules.

Responsibilities:

• Work closely with business to understand the Business Requirements.
• Prepare Technical design documents for the business requirements.
• Work with offshore team to get the deliverables on time.
• Unit testing and deployment of the deliverables.
• Managing the CRs / defects and communicating to the business regularly.
• Provide thorough functional / technical support to the business during User Acceptance Testing phase.
• Provide after Go-live support to the business.
• Involvement in Support & Maintenance activities.

2. ORMS - Cost Accounting
Client Abercrombie & Fitch

02/2013) - Till date

Team Size Project: 25 Module: 15
Environment (with skill versions) Software Oracle 10g forms & reports, SQL, PL/SQL, Pro*C, IBM AIX UNIX 5.0 - Korn shell scripting, Ca ESP batch scheduler
Hardware Intel

Description
Abercrombie & Fitch is an American clothing retailer marketed as a lifestyle brand. The company encompasses five brands and was established in 1892. The company has expanded on an international basis across various world markets with a successful implementation the Oracle Retail suite with products such as ORMS, ORWMS, OReSA, ORIB, ORPM etc.
A&F is currently implementing Cost Accounting Methodology keeping future's growth initiatives in mind. During this project the processes currently operating on Retail method of accounting will be converted to Cost method of accounting. This project involves vast amount of changes in various areas of RMS product suite such as Stock Ledger, International module, Price Management, General Ledger, Financial Reports etc.
Responsibilities:

• Work closely with business to understand the Business Requirements.
• Prepare Technical design documents for the various business requirements.
• Provide functional support to the team in understanding the requirements.
• Work with offshore development team to get the deliverables on time.
• Unit testing and deployment of the deliverables.
• Managing the CRs / defects and communicating to the business regularly.
• Provide thorough functional / technical support to the business during User Acceptance Testing phase.
• Provide after Go-live support to the business.
• Involvement in Support & Maintenance phase.

3. ORMS - Merchandise Reclass
Client Abercrombie & Fitch

Team Size Project: 10 Module: 7
Environment (with skill versions) Software Oracle 10g forms & reports, SQL, PL/SQL, Pro*C, IBM AIX UNIX 5.0 - Korn shell scripting, Ca ESP batch scheduler
Hardware Intel

Description
Abercrombie & Fitch has implemented Oracle Retail Merchandising System with good amount of customization to suite their business for example A&F merchandise hierarchy operates through Key Item, Ticket Style instead of just a SKU. The processes such as Purchase Orders, Commitments, Workroom POs etc. are based upon the Style/Key Item.
The Merchandise Reclass is a process where the Merchandise will be moved to different Department / Class / Subclass from the current hierarchy. During this process the whole Key Item, Style has to be moved safely to the new hierarchy and the POs, Commitments, Workroom POs etc. also need to be mapped to new hierarchy. This involves development of new screens and batch processes. The business may setup a Class move or Key Item move or Style move, the type of movement is the key factor to drive the Merchandise to new hierarchy.
Responsibilities:

• Analyzing the business requirements and work with end users to understand their vision.
• Periodic communication with the business to resolve any functional gaps.
• Prepare technical design documents for the business requirements.
• Provide functional support to the team to understand the functionality of the system.
• Unit testing and deployment of the deliverables.
• Managing the CRs / defects and communicating to the business regularly.

4. ORMS support and maintenance
Client Abercrombie & Fitch

Team Size Project: 15 Module: 15
Environment (with skill versions) Software Oracle 10g forms & reports, SQL, PL/SQL, Pro*C, IBM AIX UNIX 5.0 - Korn shell scripting, Ca ESP batch scheduler
Hardware Intel

Description
Abercrombie & Fitch is an American clothing retailer, marketed as a lifestyle brand. The company encompasses five brands and was established in 1892. The company has expanded on an international basis across various world markets with a successful implementation the Oracle Retail suite with products such as ORMS, ORWMS, OReSA, ORIB, ORPM etc.
A&F is now into support and maintenance phase after the successful ORMS and other retail products implementation. During this phase the business is being supported by providing extensive RMS batch support along with new / adhoc requests delivery. Since the A&F is operating international there is lot of customization being done to the distribution mechanism that involves changes in RMS PO process, inventory management, stock ledger etc.
Responsibilities:

• Primary business contact for RMS batch support / production issues.
• Analyzing the new business request / change requests coming in.
• Prepare technical design documents for the business requirements.
• Provide functional support to the team on production issues.
• Unit testing and deployment of the deliverables.
• Managing the CRs / defects and communicating to the business regularly.

5. RDM / WMS - Retek Distribution Management System
Client Abercrombie & Fitch

Team Size Project: 12 Module: 5
Environment (with skill versions) Software IBM AIX UNIX 5.0, Oracle 10g forms & reports, IBM MQ Explorer
Hardware Intel

Description
Retek Distribution Management system is Warehouse Management software provided by Oracle used worldwide. Abercrombie extensively uses complete RDM functionality and features along with certain business critical changes specific to A&F. Abercrombie has several external systems such as Pack To Light, P&A, Sort Director, all these system are integrated with RDM / WMS to serve the critical Supply Chain operations.
Responsibilities:

• Gathering business requirements and preparing Technical design documents.
• Develop necessary GUI and RF components according to TDs.
• Creating XML messages and setting up the MQ Explorer message queues.
• Unit and Integration testing the developed business components.
• Deploying the developed solution in the App and DB servers.
• Uploading the business components to Visual Source Safe.

6. Oracle Retail Implementation
Client Abercrombie & Fitch

Team Size Project: 40 Module: 10
Environment (with skill versions) Software Oracle 10g forms & reports, SQL, PL/SQL, Pro*C, IBM AIX UNIX 5.0 - Korn shell scripting, Ca ESP batch scheduler
Hardware Intel

Description
Abercrombie & Fitch is an American clothing retailer, marketed as a lifestyle brand. The company encompasses five brands and was established in 1892. The company has launched four brands in a period of ten years and has begun to expand on an international basis across various world markets. A& F is going international in order to support their business needs, hence they are implementing oracle retail suite with products such as ORMS, ORWMS, OReSA, ORIB, ORPM etc. in two different phases. The phase-1 mainly focuses on Purchase Order and Item maintenance customization. And the phase-2 focuses on end-to-end RMS customization / integration with modules and applications such as Inventory management, Stock Ledger, Sales Audit, Price management, RDM, RIB etc.
Abercrombie's PO life cycle process has gone across major changes to support their business. It has modules such as PO, Commitment, PO Breakout, PO Workroom, HTS. Though the PO process has been renewed as per A&F, the essence of the RMS product still remains the same. Similarly, there are lot of customization done at sales side with base / custom batches of ReSA, Stock Ledger. With respect to these changes new totals have been introduced in both ReSA / SL to provide appropriate figures to the financial system People Soft. The inventory process has also been refined according to A&F business need in terms of transfers / allocations with new functionality and accordingly the RIB has been customized. There are numerous changes to RPM too, and at the end all has gone live well without any hiccups because of the essence of Oracle Retail product suite.
Responsibilities:

• Analyzed functional requirements and understand the business process.
• Prepared technical design documents for the business requirements.
• Extensive participation in development and enhancement of functional concepts of Oracle Retail modules such as RMS, ReSA, RIB and RDM.
• Contributed complete effort in Abercrombie custom modules such as PO, PO Breakout, Item Inquiry and Tansfers / Allocations.
• Unit testing and deployment of the deliverables.
• Involved during integration testing of the whole Oracle Retail product.
• Extensively used technologies such as Oracle 10g forms, UNIX shell scripting, Pro*C, Autosys scheduler.

7. Fresh & Easy, Tesco Operational Model
Client Tesco Fresh & Easy, USA

Team Size Project: 20 Module: 9
Environment (with skill versions) Software SQL, PL./SQL, Oracle 10g forms & reports, Pro*C, IBM UNIX shell scripting, Autosys scheduler
Hardware Intel

Description
Tesco has recently launched its retail business in US with name Fresh and Easy. The Fresh and Easy uses several Oracle applications such as ORMS, ReIM, ORWMS, OFI etc. to maintain their business activities. On top of the Oracle's base product, Tesco has decided to do modifications as per their business need. These modifications have been considered as TOM - Tesco Operational Model. Tesco wants to implement the TOM in other countries too. TOM involves modifications to front-end screens, Pro*C batches, Shell scripts etc. as a common Tesco business across all countries.
Responsibilities:

• Analyzing new functional requirements and understand the business need
• Involved in designing and development of a Pro*C batches
• Involved in System design using UNIX shell scripts and PL/SQL code.
• Given support and fixed the bugs raised during the new development phase
• Responsible for unit testing, Integration Testing and Debugging
• Responsible for implementing change requests and worked on feature enhancements.
• Responsible for maintenance and bug fixing of the application.
• Responsible for deployment activities of newly developed code
• Provide technical support to the users and testers

8. ORMS, Central Europe

Organization Tesco Hindustan Service Center
Duration March 2007 to Dec 2007
Team Size Project: 25 Module: 10
Environment (with skill versions) Software SQL, PL/SQL, Oracle 10g forms & reports, Pro*C, IBM UNIX shell scripting, Autosys scheduler
Hardware Intel

Description
Oracle Retail Merchandise System is a Retek / Retail product from Oracle, which is widely used across the world. Tesco is one of the major retail clients of Oracle. Tesco stores are established and implemented in several countries like UK, Turkey, Central Europe, Korea, Japan, China, USA etc. and became world's 3rd top retailer. Tesco uses several IT applications to smooth run their business activities and they are ORMS, ReIM, ReSA, ORWMS, Store Line, GO, OFI, GRS, TIMS any many more. ORMS is a product with efficient capabilities in running the retail business.
Responsibilities:

• Module lead for CE ORMS application
• Responsible for providing resolutions to the enhancement requests raised through Service Desk.
• Responsible for giving support and fixed the bugs raised through SD+
• Analyzed and developed the new requirements as per the need using various technologies / applications such as Pro*C, Shell script and Oracle PL/SQL coding using PL/SQL developer.
• Involved in deployment activities of Retek applications such as ORMS, RIB, RPM, etc and built the new business environment

9. TESCO New Buying System
Client Tesco HSC

Team Size Project: 30 Module: 9
Environment (with skill versions) Software SQL, PL/SQL, Oracle 10g forms & reports, IBM UNIX shell scripting, UNIX batch scheduler
Hardware Intel

Description
Tesco is the UK's No. 1 retailer; they have their stores operated in over all 13 countries. Tesco use wide range of Oracle Retail products such as ORMS, OReSA, OReIM, RPM etc. to operate their business. The Tesco UK business is vast and it still runs on the Mainframe applications. They wanted to slowly migrate the UK business too from Mainframes to Oracle Retail. For this purpose they have taken Oracle Retail v 12 and on top of that they wanted to add some more functionality especially for UK's business need. Hence, the Tesco NBS (New Buying System) is a special customization for TESCO UK's business need.
Responsibilities:

• Gathered and studied the Business Requirements.
• Responsible for developing Pro*C batches and respective UNIX shell scripts.
• Designing and developing the front-end forms.
• Developed the backend packages, triggers, procedures and functions.
• Responsible for deploying the forms and batches in UNIX server.
• Preliminary testing of the batches before handing over to the test users.
• Assistance on the defects raised by the testers.

10. Order Billing and Invocing

Organization Softlab technologies Pvt. Ltd.
Duration Jul 2005 to May 2006
Team Size Project: 25 Module: 8
Environment (with skill versions) Software SQL, PL/SQL, Oracle 10g forms & reports, IBM UNIX shell scripting, UNIX batch scheduler
Hardware Intel

Description
XEROX Corp. is high-end firm which deals with several huge office based equipment and sells them as per the industry need, to computerize their whole activities such as Sales, Finance, Payments etc. XEROX has developed an IT wing called XCS - Xerox Capital Services. Hence, XCS is responsible for all kind of IT operations of XEROX. There are several modules involved in XCS such as OBI (Order Billing and Invoice), People soft, BI (Business Intelligence) etc. The OBI is sub divided into several modules such as, eCredit / XOE / XCITE / Fast / IA.
Responsibilities:

• Module lead for eCredit application.
• Frequently interacted with the client, gathered requirements.
• Developed PL/SQL coding (Procedures, Functions, Triggers etc) and UNIX shell scripts as per the need.
• Responsible for designing and developing the front-end forms for XOE application.
• Responsible to give the level 3 support to the bugs raised through ITT (Integrated Tracking Tool).
• Responsible for all the change requests (CR's) coming from the users.

11. Material Management
Client Samkey Phistons

Technical Skills 
Operating Systems Windows 2000/98/95/NT/XP, UNIX, Linux, MS-DOS 
Languages Pro*C, UNIX Shell scripting, AWK scripting, SQL, PL/SQL, Oracle forms & reports, Core Java, XML, Java script, Cobol, JCL 
Databases Oracle 8i/9i/10g, SQL Server, and MS-Access 
Web Technologies HTML, DHTML, JSP, XML, DTD, CSS, JavaScript 
Tools & Utilities 
IBM UNIX scheduler, Autosys scheduler, ESP scheduler, Appworx scheduler, IBM MQ Explorer, Oracle SQL developer, PL/SQL developer, Toad 
 
Application Servers Oracle 10g App server 
Source Control Software's Tortoise SVN, CVS, VSS 
Methodologies Software Development Life Cycle, Object Oriented Analysis 
Functional skills Oracle Retail (RMS, ReSA, RIB, WMS, ReIM) 
 
Projects Profile 
1. ORMS 10 - Support and Enhancement projects  
Client Gymboree Corporation

Team Size Project: 15 Module: 5
Environment (with skill versions) Software Oracle forms & reports, SQL, PL/SQL, UNIX shell scripting,
Hardware Intel

Description:
The Order Management Engine (OME) is an application, which has been developed for a manufacturing company to manage various functionalities like Vendor Registration, Generation and Dispatches, Quotation receive, Verification of Quotation for vendor, Purchase order Generation and Issue of Raw Materials to the Production Dept on demand basis. This system automatically updates Stock in case of receiving and issuing (consumption for production) the material. The stock updating is done through procedure. The OME System is a user-friendly system.
Responsibilities:

• Involved in the development of the Purchase Module
• Involved in integration with other modules in the designing part, coding and reports generation part like generation of matrix reports and mailing reports
• Involved in writing complex stored Procedure/ Function/ Package and Triggers for Updating Stock on the basis of receipt and Issue, Excise Calculations, Updating purchase order status on the basis of receipt of materials etc.
• Involved in Creating PL/SQL for Triggers, Procedures and Functions
• Modifying the application screens and reports by analyzing the system requirements
• Involved in Maintenance and Support activities

12. Financial Accounting System
Client Bharathi Rural Development Society

Team Size Project: 15 Module: 4
Environment (with skill versions) Software Oracle 8i forms & reports, SQL, PL/SQL
Hardware Intel

Description:
Financial Accounting system (FAS) processed the log in information and the detailed information about all the financial transactions takes place in the company and/or its multiple branches. The theme behind this Application is to provide complete solution on accounts as per the company's requirement such as maintenance of Branch wise Accounts preparation of Daily Accounts, Monthly Ledger, Trial Balance, Balance Sheet etc. The front end of the application was developed in Developer 2000(Form 5.0). The Back End was Oracle.
Responsibilities:

• Actively involved in writing Triggers, Procedures and Functions
• Involved in the integration with other modules in the designing part, coding and reports generation part like generation of matrix reports and mailing reports
• Installation, Implementation and Maintenance of Software and Database
• Modifying the application screens and reports by analyzing the system requirements
• Actively involved in Coding, Bug fixing and Testing