SUMMARY:

• Experience in managing and leading the team including - Project Estimates, Project Deliveries, Customer Level meetings.
• Having In depth knowledge in understanding the retail merchandising end to end system with Specialization in Oracle MOM ( Merchandising operation Management ) applications like RMS, ReIM, SIM, RPM.
• Expertise lies with Applying Technical, Functional & Oracle Retail Specific Knowledge During implementation, Development, Support, maintenance and testing projects.
• Worked as various roles - Techno-Functional Consultant, Project Lead, Test Lead, Developer and Production Support lead.
• Worked on Multiple Version 9,13.2, 14.1 of oracle retail and experience in end to end merchandising implementation
• Broad experience in Oracle ERP solutions, home grown solutions and integrations
• Expert in database development that includes writing stored procedures, functions, triggers and creating other database objects like tables, views and indexes using Oracle DB.
• Extensive experience in analysis, design, development, testing using Oracle PL SQL, SQL, UNIX and Oracle forms.
• Experience in writing complex SQL queries for data extraction, initial loads and data debugging.
• Good knowledge of SQL query performance tuning.
• I am an avid learner and never shy from learning new technologies, worked on data warehouse technologies like Informatica.
• Worked as a functional Lead for Planning and executing End to End Test Suit for Complete Merchandising, Supply Chain Solution.
• Have Functional Knowledge on Solution like Oracle Assortment Builder, JDA Allocations and Oracle MFP.
• I am Oracle Certified Associate.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Coordinate with Business teams to prepare the business flow
• Clarifying functional/technical doubts pertaining to system - All Merch Foundation and planning Apps
• Prepare Test scenarios and Test Steps and execution.
• Using JIRA tool for defect management and Tracking.
• Using QTest for test execution and test results.

Confidential

Skills : Oracle SQL, PL SQL, UNIX, ProC, Oracle Forms

Tools : Toad, JIRA, Q-test, Control M, Putty, Dimension

Responsibilities:

• Provide solutions for requirements for custom and product level.
• Prepare Functional and Technical designs for Custom Solutions and Interfaces
• Request, Tracking the Oracle SR’s and deploying the patches in all Env’s.
• Configuring Oracle Retail Applications as per requirements and migrate legacy data
• Development and Customizations
• Clarifying functional/technical doubts pertaining to system - RMS and RPM
• Prepare Test scenarios and Test Steps and execution.
• Using JIRA tool for defect management and Tracking.
• Using QTest for test execution and test result.

Production Support

Confidential

Skills : Oracle SQL, PL SQL, UNIX, ProC, Oracle Forms

Tools : Toad, JIRA, Q-test, Control M, Putty, WINSCP, Dimension

Responsibilities:

• Hot fixing production run time issues.
• Analyzing and building permanent solutions for chronic production problems.
• Batch monitoring merchandising systems.
• Handling complex interdependencies between modules.
• Have worked on many merchandising interfaces such as Receipts (Outbound and
• Inbound), EDI (Electronic Data Interchange), Items Setup and management, Ordering and Transfers, sales etc.
• Apart from regular Prod support activities have lead and handled critical events for the client viz. Anniversary Promotional sales event, Women’s & Kids Clearance event, Physical Inventory.

Confidential

Skills : Oracle SQL, PL SQL, UNIX, ProC, Oracle Forms

Tools : Toad, JIRA, Q-test, Control M, Putty, WINSCP, Dimension

Responsibilities:

• Working as a technology lead to handle team size of 4 people helping them in technology aspects and management aspects.
• Estimation for the Task
• Impact analysis
• Review of Impact analysis and Design with Application Quality team
• Coding/Development in Oracle PL/SQL
• Responsible for Functional and Regression testing
• Requirement understanding of the Task assigned
• Follow up on the approvals required
• Production move preparation
• Implementation & Co-ordination with deployment teams & Business Users

Confidential

Skills : Oracle SQL, PL SQL

Tools : Toad

Responsibilities:

• Responsible for writing business logic in packages and procedures using PL/SQL for incentive calculation reports delivered to client.
• Writing business logic in packages and procedures using PL/SQL for data dump reports and also for front end application.
• Also PL/SQL is used for processing and validation of the client data.

Confidential

Skills : Oracle SQL, PL SQL, UNIX

Tools : Toad, Putty

Responsibilities:

• Estimation for the Task
• Impact analysis
• Review of Impact analysis and Design with Application Quality team
• Coding/Development in Oracle PL/SQL
• Responsible for Functional and Regression testing
• Requirement understanding of the Task assigned
• Follow up on the approvals required
• Production move preparation
• Implementation & Co-ordination with deployment teams & Business Users

Confidential

Skills : Java, JSP, Sun One, Oracle SQL & PL/SQL

Responsibilities:

• Estimation for the Task
• Impact analysis
• Review of Impact analysis and Design with Application Quality team
• Coding/Development in Oracle PL/SQL
• Test Cases execution / Manual Testing of the application
• Responsible for Functional and Regression testing
• Handling all Production Support Activities
• Bug fixing for the production issues.
• Requirement understanding of the Task assigned
• Follow up on the approvals required
• Production move preparation
• Implementation & Co-ordination with deployment teams & Business Users