SUMMARY

• Over 7 years of experience in Analysis, Development and Implementation of Software Applications.
• Good working knowledge in Retail Domain - Oracle retail (RMS & ReSA)
• Hands on knowledge in RMS modules like Foundation Data, Item Maintenance, PO Workroom, Replenishment, Ordering, Inventory management, Transfers and Commitment.
• Working knowledge of ReSA batches like saimptlogi, sarules
• Expertise in Oracle 8i, 10g - Stored Procedures, Packages & Database Triggers.
• Experienced in development & customization using Oracle Forms and Reports, Pro*C & PL/SQL.
• Proficient in Oracle Import Utilities and converting legacy data into Oracle Database using SQL* Loader
• Experience in developing Unix Shell Scripts for RMS Batches
• Experienced in development and technical support for System integration testing, User acceptance testing & Post Production
• Good debugging and problem solving skills with excellent understanding of system development methodologies, techniques and tools
• Highly organized, can prioritize work to manage time effectively and meet deadlines.
• Team-oriented professional with proven ability in quick understanding and learning of new technologies.

TECHNICAL SKILLS

Development Tools: Oracle Forms & Reports

Databases: Oracle 8i & 10g

Operating systems: Unix & Windows XP & 2000

Scripting Languages: Unix Shell Scripting

Programming Languages: SQL, PL/SQL, Pro*C

Others: SQL*Loader, TOAD, MS Visio, WinSCP, SQL Developer, HP QC, Clear Case

Domain: Retail

PROFESSIONAL EXPERIENCE

Confidential, OH

Oracle Retail Technical Consultant

Responsibilities:

• Analyzed Functional Requirements and prepared Technical Design Document for various work components.
• Developed Oracle forms using features like Tab and stacked canvases
• Created stored procedures, functions, views, sequences, triggers and packages as per the business requirements and used them to populate the data into the custom table
• Developed PL/SQL packages which includes advanced concept of PL/SQL like dynamic queries, REF cursors, collections, exception handling and Pragma.
• Built custom generic procedures to be used across application
• Created Global temporary tables, Views as a part of development to improve the performance of the process
• Worked as Technical Consultant for one of the most complex and custom module - PO workroom
• Followed best practices during development phase like coding standards, defect log maintenance
• Prepared test cases and performed unit testing, bug fixing for all the interfaces developed
• Coordinated with QA and UAT Teams to test the modifications made to the existing application, and resolved the defects rose in Quality center.
• Prepared user manual for Load runner activity as a value-add to the client
• Provided post-production support by handling issues and monitoring batch-processing jobs

Environment: Retek Suite, Oracle 10g, Forms 10g, HP QC, Tortoise SVN, PL/SQL, Toad

Confidential

Oracle Retail Technical Consultant

Responsibilities:

• Independently designed and developed SCA migration tool with zero defects
• Developed batches using Pro*C, shell scripting and PL/SQL
• Worked on major enhancements like Data Integrity reports using SQL Loader and advanced concept of PL/SQL like REF Cursor and Collections.
• Used Oracle's Bulk Collect and Partitioning concepts to process the data with effective performance.
• Worked on change requests related to Posupld batch
• Participated in the walk through of existing code and made changes as per the business requirements.
• Maintenance and support of custom module ORS(order review system)
• Worked on UAT/SIT defect fixes for various ReSA batches like Sarules, Saimptlogi and custom batches
• Coordinated with QA and UAT Teams to test the modifications made to the existing application, and resolved the defects captured in Quality center.
• Mentored new joiners’ and initiated knowledge sharing sessions among team members
• Managed defect triage calls and assigning defects to team
• Prepared Installation guide and release notes for deployment
• Performed coordination between support and development team forRelease deployments
• Resolved Production issues as part of Production Support

Environment: Retek Suite, Oracle 10g, Forms 10g, PL/SQL, PL/SQL developer, Pro*C, Shell scripting, Oracle RMS, HP QC, Clearcase

Confidential

Oracle Retail Technical Consultant

Responsibilities:

• Played an active role in defining the white spaces by conducting requirement gap analysis.
• Prepared technical specification document for requirements identified.
• Developed Forms, Packages and Triggers as per the requirements identified
• Generated SQL Scripts to create relevant tables, views, synonyms, sequences for staging, development, and test environments.
• Prepared test case documents for unit/system testing.
• Coordinated with other team members for Unit, System and regression testing of backend processing logic

Environment: Oracle 10g, Forms 10g, PL/SQL, PL/SQL developer, Oracle RMS

Confidential

Senior Software Engineer

Responsibilities:

• Carried out design and development of the screens using Oracle Forms
• Responsible for Analysis (Preparation of Program Technical Specification by identifying business requirements), Coding & Testing.
• Performed code review, bug fixing and resolving customer issues
• Developed several stored procedures, triggers and reports as per the requirements
• DevelopedMaster Detail reportsto meet the requirements of end users within the system.
• Created SQL script for Tables, Indexes, and sequences.
• Delivered new and complex high quality solutions to clients in response to varying business requirements
• Prepared unit test cases and performed unit testing for all the interfaces implemented
• Quick turnaround in implementing client’s requests

Environment: Oracle 10g, Forms 10g, Reports 10g, PL/SQL, SQL*Plus, Mercury QC

Confidential

Senior Software Engineer

Responsibilities:

• Understand project requirements as specified in functional spec and participated in design discussions.
• Development of the screens using Oracle Forms
• Developed several stored procedures and reports as per the requirements
• DevelopedOracle reportsto meet the requirements of end users
• Performed code review, bug fixing and resolved customer issues
• Prepared unit test cases and performed unit testing for all the interfaces implemented

Environment: Oracle 10g, Forms 10g, Reports 10g, PL/SQL, SQL*Plus, Mercury QC

Confidential

Software Engineer

Responsibilities:

• Development of the screens using Oracle Forms
• Developed several stored procedures and functions as per the requirements
• Created SQL script for Tables, Indexes, sequence.
• Imported data into newly created tables.
• Customization of reports, PL/SQL Stored Procedures/Functions as per new requirement.
• Performed bug fixing and resolved customer issues
• Prepared unit test cases and performed unit testing for all the interfaces implemented

Environment: Oracle 10g, Forms 10g, Reports 10g, PL/SQL, SQL*Plus, Mercury QC

Confidential

Software Engineer

Responsibilities:

• Development of the applications using Oracle Forms and reports
• Developed several stored procedures and triggers as per the requirements
• Prepared unit test cases and performed unit testing for all the interfaces developed

Environment: Oracle 10g, Forms 10g, Reports 10g, SQL*plus, PL/SQL

Confidential

Software Engineer

Responsibilities:

• Customization of reports according to new requirements
• Documentation of business requirements
• Developed several stored procedures and functions
• Prepared unit test cases and performed unit testing for all the interfaces developed

Environment: Oracle 8i, Forms 6i, Reports 6i, SQL*plus, PL/SQL