SUMMARY:

• 8 Years of IT experience in analysis, design, implementation and testing to implement Oracle Retail Merchandising System (ORMS) using Oracle Relational Database Management System (RDBMS).
• Expertise in Stored Procedures, Functions, Packages, Triggers, Indexes and Types .
• Experience in developing materialized views .
• Experience in Oracle supplied packages like DBMS JOB, DBMS LOB and DBMS SQL .
• Expertise in Ref Cursor, External Tables, Dynamic SQL and Exception handling.
• Experience in Range and Hash partition techniques and Performance Tuning .
• Experience in designing and maintaining data extraction & transformation processes ( ETL ).
• Experience in Python scripting for data transfer and manipulation.
• Experience in building ER diagrams for tables.
• Experience in using Bulk Collect and FORALL to reduce context switching between SQL and PL/SQL engines.
• Experience in extracting data from DB into flat text files using UTL FILE package.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Experience in creating Shell Scripts to invoke SQL scripts and schedule them using Crontab .
• Experience in creating Pro*C scripts to call Database Objects according to the needs of the project.
• Expertise in developing forms using Oracle Forms Builder .
• Experience in Purchasing, Shipping, Transfers and Receiving modules.
• Experience in foundation data modules like Org Hierarchy, Merch Hierarchy, Item, Supplier, Store, Warehouse, Location list, Item list, User defined attributes, Cost change.
• Expertise in Custom flex attribute setup (CFAS).
• Experience in Stock Ledger, Inventory adjustment, Stock Count, Wholesale order creation and Future cost process.
• Expertise in Data Migration activity.
• Expertise in RMS forms security, New User creation, New Role creation, Role assignment, Security user group Maintenance and User Attribute Maintenance.

TECHNICAL SKILLS:

Applications: Oracle Retail Merchandising System, Oracle Retail Integration Bus, BI Publisher, Electronic Data Interchange

Languages: Pro*C, SQL, PLSQL, Python, C++, C

Methodology: Agile and Waterfall

Database: Oracle 10g/11g/12c

Scripting Languages: Unix shell Scripting, Java Script, HTML, XML

Software: Oracle Forms Builder, UC4, SVN, Microsoft Office, Putty, WINSCP, TOAD, IBM Inflight

Operating System: Windows, Linux, MAC.

PROFESSIONAL EXPERIENCE:

Oracle Retail Technical Lead

Confidential, California

Responsibilities:

• Direct communication with business team to gather client requirements.
• Developed technical and functional design documents according to client needs.
• Identified integration gaps between systems and provided solutions.
• Developed several UNIX shell Scripts to call SQL Loader to load data from flat files into DB according to project and client requirements.
• Developed PLSQL scripts using Bulk Collections for easy retrieval of data, by reducing context switching between SQL and PL/SQL.
• Experience in application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE
• Developed PLSQL scripts using Pragma Autonomous Transaction to avoid mutating problem in database trigger
• Involved in continuous enhancements and fixing of production issues.
• Cut over design, planning and coordination to ensure very minimal impact to business operations.
• Reviewed and provided feedback to offshore team on their developments and enforced Coding standards.
• Monitored the production logs during the warranty period and took care of fixing the high severity issues in the expected SLA.
• Have Worked with Oracle Retail Sales Audit (ReSA), Oracle Retail Price Management (RPM) and Oracle Retail Invoice Matching (ReIM) teams and their corresponding integrations.
• Hands on experience in U.S Customs and Border Protection HTS yearly upload into RMS.
• Hands on experience with Electronic Data Interchange documents EDI850, EDI860, EDI846, EDI810, EDI810, EDI855, EDI997, EDI852 documents.
• Developed custom package to process Ship from Store (SFS) and Buy Online Pick UP In Store (BOPIS) order requests in RMS.
• Hands on experience with EDI ISA and GS segments, VAN/FTP/SFTP/AS2 connections and EDI providers.

Oracle PLSQL Developer

Confidential

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Data reconciliation between RMS and external systems.
• Developed test cases for various phases of testing like Unit Testing, System Integration Testing and UAT.
• Developed PLSQL package to read data from flat files using UTL FILE package.
• Provided techno functional and mentoring among junior associates.
• Reporting status to the client through daily standup meetings
• Developed custom batches for Purchase Order Consolidation.
• Developed custom batches using PL/SQL functions and shell scripts to process different POS (Point - of-Sale) transactions into RMS.
• Developed custom script for XML to XSD conversion.
• Worked on table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Developed custom forms using Oracle Forms Builder to enable Mass upload feature that accepts .csv files as input.
• Developed custom forms using Oracle Forms builder for PO Finalization, Default replenishment profile, Order Generation Schedule and Store Direct Parameters and Vendor Promotional Agreement.
• Worked on extending base RIB XSDs to add custom attributes for ASNOUT, SOSTATUS, XITEM, XITEMLOC, VENDORCRE subscribers and TRANSFER and STORE publishers.
• Experience in processing XML files using RIB RDMTMENU and clearing RIB poison messages.
• Excellent team player with good communication, people and leadership skills with onshore-offshore experience.
• I can facilitate the continuous development of individual & organizational competencies, developing others' potential through the sharing of expertise and providing timely feedback.

Junior Developer

Confidential

Responsibilities:

• Developed various DML and DDL statements using Oracle Pl/SQL and SQL.
• Developed test case scenarios for regression tests on PL/SQL programs.
• Developed database objects like tables, views, Materialized views.
• Experience in Implicit, Explicit and REF cursors.
• Developed PL/SQL procedures, functions, and triggers.
• Modifying the existing packages, procedure based on project requirements.
• Developed scripts for Data loading using SQL Loader.
• Developed data conversion scripts based on client requirements.
• Developed External tables for data staging and processing.
• Involved in Unit testing and system integration testing process.
• Modified existing SQL Queries to improve the performance of the Packages, Procedures and Functions.
• Developed records, tables, collections (nested tables and arrays) to improve Query performance.
• Take the ownership of critical system issues and resolve them.
• Developed automated scripts for daily reports.