SUMMARY

• 9 Yrs. of experience in Oracle Retail v12, v13, and v14 as Technical Consultant which includes design, development, testing, and deployment phase of the project in implementation & support engagements.
• Familiar using the Oracle SQL/PL - SQL, Pro*C, UNIX to work with interactive applications, batch applications and good knowledge on the functional aspects in Retek applications like RMS, ReSA & RIB modules.
• Experience in Development, Testing, and supporting Retail applications Retail Merchandize System (ORMS), Oracle Retail Sales Audit (ReSA),Oracle Retail Price Management (ORPM) and Retail Integration (RIB).
• Basic Technical Knowledge of Oracle Retail Pricing Management (RPM) and Store inventory management(SIM)
• Extensively designed and developed Interfaces (Inbound/Outbound) Open Interfaces, APIs, SQL, PL/SQL, and UNIX Shell Scripts.
• Expertise in SQL and PL/SQL programming. Extensive experience in developing Stored Procedures, Functions, Packages, Triggers, Indexes and SQL queries using SQL*Plus, TOAD, sql Loader and SQL Developer development tools.
• Expertise in Production support such as defect fixing, designing automated monitoring jobs/utilities to ensure sync between various applications
• Expertise in Integration of RETEK Applications with other applications - downstream or upstream based on customer business structure.
• Expertise in working in onsite-offshore across multiple projects and environments, Agile and Water fall Model of workflows.
• Good knowledge of Oracle Retail RMS Data model.
• Having sound idea on performances tuning features like optimization, hints and execution plans.
• Has the motivation to take independent responsibility as well as ability to contribute and be a productive team member.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.
• Flexible to adapt to new environment and work on any project.

TECHNICAL SKILLS

ERP/Oracle Retail Modules: Oracle Retail v12, 13, 14, ORMS, ReSA, RPM, SIM, RIB

Languages: PL-SQL, SQL, Pro*C, Shell Scripting

Databases: Oracle 9i, 10g

Design Tools: Oracle Forms, CAWA, Toad, SQL Developer, SQL*Plus and Erwin

Operating Systems: Windows NT/98/95/2000/XP, UNIX 4.0, Sun Solaris5.8

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead

Environment: /Software: Oracle Retail Suite, RMS, ReSA, RPM, RIB, SOA, OSB, PL/SQL, Pro*C, Forms, Oracle BI, CAWA, Windows XP/2000, Oracle 10g Database and TOAD

Responsibilities:

• Automated the daily checks of ReSA - store closure, data exported to downstream applications, RMS and ReSA in sync etc.,
• Identification and resolution of screen issues, data discrepancies issues to other interfaces, bugs etc., on time (to meet the SLA).
• Coordination with POS team/finance team for all Sale related issues as part of Sales Audit.
• Working on discrepancies related to postings to GL Variances because of incorrect totals.
• Load monitoring and handling changes to the existing application tuning for best Performance
• Providing regular status updates to Client.
• Coordination with offshore team and guiding them to resolve the batch issues.
• Fix defects and change request for the customized modules in the production system.
• Perform the system and integration testing wherever applicable.
• Developed customized forms along with PL/SQL stored procedures and Pro*c batch programs in the area of ReSA.
• Client co-ordination
• Participate in business requirement gathering meetings with business users to understand all aspects of the business (functionality, processes, technologies, determine feasibility of requests and Identify best approach to provide technology solutions to meet business needs)
• Performs high and low-level designs
• Code walkthrough and performing various testing
• Interface changes to convert sku level receiving to carton level receiving.
• Vendor shipment interface changes to route new wh based on vendor shipment.
• Perform deployment of applications/infrastructure and post-production support
• Resolve batch issues to make sure the applications are available to business on time
• Supports the team in developing optimized high quality deliverables, performs reviews in order to meet the defined quality SLAs activities. Review production issue analysis and fixes, interface with customer to clarify issues and ensures timely closure
• Establish support processes required to stabilize the system

Confidential

Technology Lead

Environment: /Software: Oracle Retail Suite, RMS, ReSA, SIM, RPM and RIB Oracle PL/SQL, Pro*C, Forms, CAWA, Windows XP/2000, Oracle 10g Database and TOAD

Responsibilities:

• Automated the daily checks of ReSA - store closure, data exported to downstream applications, RMS and ReSA in sync etc.,
• Automated the daily activities which involved Price check between RMS-SIM-RPM, check stock on hand between SIM and RMS, check in transit quantity between SIM and RMS.
• Identification and resolution of screen issues, data discrepancies issues to other interfaces, bugs etc., on time (to meet the SLA).
• Coordination with POS team/finance team for all Sale related issues as part of Sales Audit.
• Working on discrepancies related to postings to GL Variances because of incorrect totals.
• Load monitoring and handling changes to the existing application tuning for best Performance
• Providing regular status updates to Client.
• Coordination with offshore team and guiding them to resolve the batch issues.
• Fix defects and change request for the customized modules in the production system.
• Perform the system and integration testing wherever applicable.
• Developed customized forms along with PL/SQL stored procedures and Pro*c batch programs in the area of ReSA.

Confidential

Technical developer

Environment: /Software: Retek Suite, Oracle PL/SQL, UNIX Scripts, Windows XP/2000, Oracle 10g Database

Responsibilities:

• Requirement gathering for data load and synchronization (RMS) from TICB team.
• Prepared Technical Solution Design document for data load and synchronization
• Developed new Interfaces for RMS V10 to RMS V12.05T.
• Designed and developed packages, triggers for data load and Sync
• Database management and performance testing
• Coordinating with the onsite team in client-place testing and implementation of the entire process.
• Designed the entire batch jobs through Autosys scheduler which are running in the production environment.

Confidential

Technical developer

Environment: /Software: Retek Suite, Oracle PL/SQL, Pro C batch, Unix Scripts, Windows XP/2000, Oracle 10g Database

Responsibilities:

• Implementing the required code change to the Respective module/program (PO, WH, etc.) in Oracle RMS RIB Subscription and publishing packages.
• WH Publication Package
• PO Publication Package
• Merch Hier Publication Package
• Vendor Publication Package
• Appointment Subscription Package...Etc...
• Extension table creation for the RMS core tables for the RDM to SIMS and OBWIMS functionality
• Developed ANF customized RIB Subscription and publishing packages.
• Worked on ReSA batches which are the key to update the sales data into RMS financial system which is the key input for Stock Ledger.

Technical developer

Confidential

Environment: /Software: Retek Suite, Oracle PL/SQL, Forms 10g, Windows XP/2000, Oracle 10g Database

Responsibilities:

• Analysis of the specifications provided by the clients
• Developed ANF customized forms along with PL/SQL stored procedures.
• Database management and performance testing
• Unit testing and deployment of the Deliverable.
• Developed Procedures, Functions, packages and triggers.
• Involving in Test Case and Test Data preparation.
• Support to the UAT team.
• Conducting Code reviews.