SUMMARY

• I have a total of 9.5 years of experience in IT industry. I started off as a Software Engineer and currently working as a Senior Retail Consultant in Confidential.
• My overall experience in Retail Domain is around 5 years and I have been a part of almost all the software development Life Cycle from basic Requirement gathering, Coding, Testing, implementation to Production Support.
• I am primarily working in Oracle Retail(RETEK) product and specialize in Merchandising (ORMS, OReSA), Pricing (ORPM) and Store Inventory management (SIM) Modules.
• Functionally, I consider myself an expert in Pricing and Merchandising applications and technically I've sound knowledge in Oracle PL/SQL, Forms, UNIX, BI publisher.
• I have always been a good team player and have good management skills as I have managed teams for project deliverables.
• I am looking forward for a challenging role in Retail Domain and working with driven and likeminded people. My goal would be to add value to the business and grow professionally as well as personally.

TECHNICAL SKILLS

Oracle Tools: Oracle 9i, 10g. Oracle PL/SQL. Oracle Forms 10 g

Oracle Retail Modules: ORPM, ORMS, SIM, ORPOS, OReSA and RIB

Languages: PL/SQL, Unix, Pro* C, shell scripts, Basics of Java

RDBMS: Oracle 10g/9i/8i/7.x, SQL Server

Operating Systems: Windows XP/7/8/2008 R2/2012 R2, DOS 6.0/3.0, UNIX, Linux

Development Tools: TOAD, SQL Developer, Oracle Forms & Reports

PROFESSIONAL EXPERIENCE

Confidential, Santa Barbara CA

Oracle Retail Senior Consultant

Responsibilities:

• Provide Business solution to support Confidential specific business needs and customize/enhance Oracle Retail applications - RMS, RPM, SIM, ReSA, ORPOS
• Critical Production support of RPM, RMS and SIM applications including batch configurations and monitoring.
• Managing a team of 5 people who are responsible for supporting and enhancing RPM and SIM applications.
• Worked on SIM label enhancement project which included integration between BI Publisher and zebra printer.
• Worked in a stock count (RMS) project to incorporate specific business need while doing stock counts.
• Helped Business stabilize RPM with retrofit objects for version 13.3.2
• Driven projects related to data Cleanups for RMS and RPM application for better performance and system stabilization.
• Analyzed and tested Oracle optional functionalities in RPM, RMS and SIM applications and encouraged Client to use relevant ones that would add value to the business processes.

Confidential, San Diego CA

Oracle Retail Consultant

Responsibilities:

• Liaised with client to better understand issues and scenarios related to RPM and its integration with other systems(Polaris) and provide them work around to quickly fix the problem meanwhile analyze and provide long term fix after doing an RCA.
• Solutions provided using Oracle Pl/Sql Packages, Pro*C and shell scripts and created Technical and Functional Design documents for various enhancement requests related to RPM and Legacy System (Polaris) integration
• Worked with Oracle and third part integration vendors to re-produce ORPM base product and integration bugs. Held conference calls and coordinated with the customer and Oracle to get the faster resolution of reported bug.
• Day to day support activities also included catering to customer needs in terms of querying data from the backend and providing them the desired information, managing incident tickets, maintaining code version control, working with offsite team and acting as a coordinator between Business and offsite team.

Confidential, Framingham, Massachusetts

Oracle Retail Consultant

Responsibilities:

• Worked in Confidential ecommerce project as a Merchandising and Planning Consultant.
• Worked with the Client to understand the requirement and wrote Functional Design documents for Items, Purchase Orders modules of NetSuite (Merchandising) system.
• Worked with the Business to understand their Business scenarios for their Planning tool called JUST ENOUGH.
• Worked with the business in understanding their business model and how Oracle Retail would fit into their business along with other legacy systems.

Confidential, Boston Massachusetts

Oracle Retail Consultant

Responsibilities:

• Involved in analyzing Business Requirement Document, designing Functional Design Document and assisting in writing technical design documents for Oracle Retail Merchandising System which required overall understanding of Different types of Items, locations, PO creation, Item Reclassification, Cost Changes and Deal Creation.
• Code development of 3 ORMS Functional Design Documents and worked extensively worked on Oracle Forms 10g and Oracle PL/SQL.
• During system integration phase, assisting testing team with extensive System Integration Testing (SIT) of GAPs related to Oracle Retail Price Management (ORPM); this required an in-depth knowledge of different kinds of Promotions, Clearances and Price Changes, along with how integration works between ORPM and other legacy systems.
• Analyzing test case scope with written TDDs (technical design documents);
• Coordinating directly with customer to find effective solutions for SIT related issues such as environmental discrepancies and defect analysis; Liaison with both the business and offshore team; Completing effort estimations, as well as impact analysis

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Maintained and created educational related data for online and/or classroom environments within Oracle University and Line of Business (LOB)
• Application requirement involved the Analysis, Development, Enhancement and customization;
• Oracle PL/SQL was used to write procedures, triggers
• Documentation and preparation of documents such as Unit test cases, Checklists, Release documents