SUMMARY:

• More than 11+ years’ experience in IT primarily in Retail Domain & Finance Domain
• More than 6 years of experience in Oracle Retail suite of products including ORMS (V13).
• More than 3+ years of experience in implementation and consulting of Oracle Retail suite of products.
• Conducting CRPs, Gap Analysis and designing solutions for large Retail companies across the globe.
• Good understanding of Fashion, Grocery, Apparel and Home Furnishing business processes.
• Extensive Retail domain experience with focus on Retek suite ex: RMS, RIB, RPM, ReIM, and ReSA.
• Exposure to various software delivery model (V model, Waterfall, Agile / Scrum).
• ITIL Foundation V3 Certified.

TECHNICAL SKILLS:

Operating Systems: Windows XP/2007/2010, UNIX, Linux, Windows NT

Languages: SQL, PL - SQL, UNIX Shell Scripts, Pro*C, C, C++, HTML, XML

Database: Oracle 10g, 11g

Browser: Internet Explorer, Mozilla, Google Chrome

Defect Tracking Tools: IBM Clear Quest, IBM RTC

Version Control Tools: IBM Clear Case, SVN

Test Management: IBM CLM Tool (RQM, RDNG)

Project Management: MS Office, MS Project, VISIO

Oracle Tools: Oracle Developer (Forms & Reports), Oracle Application Express (APEX)

Applications: Oracle Retails MOM (RMS, RWMS, RPM, ReSa, ReIM, Allocation), Oracle Finance E business suite (EBS) R12, ERP (Enterprise Resource Planning), Confidential Applications.

Others: Toad, SQL Developer, Pl/Sql Developer, Putty, MS Visio, Basic Mainframe Commands

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Toad, UNIX Shell script, UNIX, PL/SQL, Oracle 11g, Mainframe, XML, Java, .Net

Oracle Developer

Responsibilities:

• Interact with business analyst to gather requirement and understand Use cases.
• Involve in Planning and Estimations of all test related projects.
• Involve in Resource allocations & forecasting’s for each projects
• Attend requirement, Technical design review calls.
• Analyzed System Requirements Specifications (SRS), Functional Requirement Documents (FRD), design specifications& then develop test plans, design test cases and test data for testing the functionality
• Execute UNIX shell scripts to call set of DB procedure or Package which will do validations
• Execute SQL queries to verify the data in backend tables which is populated from GUI or Flat files data.
• Responsible for conducting smoke, functional, regression, UAT & Adhoc testing
• Active involvement in peer reviews of Test case, Test result & test closure documents.
• Worked closely with Development team and product owners for concerns on clarifications on the projects.
• Participate in daily stand-up meetings, project status meetings, Leadership calls, requirement review calls.
• Developed & modified oracle forms & BI Publisher reports as per the requirement
• Involved in developing PL SQL Code & UNIX shell Scripts.
• Developed & modified the Pro*C
• Tested multiple applications & each screens as part of Hardware refresh projects (DB, APP server & UNIX server).
• Co-ordination between Onsite and Offshore team & handle multiple project in single handed.
• Responsible for defect tracking, defect reporting, defect reproducing and verification.
• Understanding the change through the mails sent by support team as no requirement documents are being prepared by them due to time constraint
• Create Test plan/ test schedule, uploaded the TC cases, created TCER (Test Case Executions Records), requirement links etc. in IBM RQM tool for each projects.
• Manage the team of 10 members who’s working from India (Offshore) & Pass all necessary info to team member & assign the work accordingly
• Give UAT sing off & approve the change record (CR) to move code in Productions.
• Involve in test executions & board an accounts from several account Boarding tools & follow up with downstream teams for End to End testing
• Walkthrough Test cases, test results, Test closure & metric reports to groups for each project.
• Involved in preparing the Technical design document based on Requirement doc
• Send weekly metrics about testing for all projects & resource capacity plan & allocations to leadership.
• Got multiple appreciations from client for dedication, hard & quality work.
• Trained the current applications to new comer to the team.

Confidential

Techno Functional Analyst

Environment: Toad, UNIX Shell script, UNIX, PL/SQL, Oracle 11g, Oracle Developers 2000, Oracle Apex, Pro*C

Responsibilities:

• Interact with business analyst & end user to gather requirement
• Involved in Data Conversion & Data Migration
• Involved in modifying the existing BI publisher reports
• Developed & modified oracle form as per the requirement
• Involved in developing PL SQL Code & UNIX shell Scripts.
• Developed & modified the Pro*C
• Involved in ReIM & ReSA modules for production issue fix
• Co-ordination between Onsite and Offshore team.
• Modify the RMS functionality as per client requirements
• Involved in Peer reviews on Technical Spec documents, Test cases, Code, Test results.
• Involved in Preparing & execute in Unit testing, SIT

Confidential

Techno Functional Analyst

Environment: Toad, UNIX Shell script, UNIX, PL/SQL, Oracle 11g, Oracle Developers 2000, Oracle Apex, Pro*C

Responsibilities:

• Interact with business analyst & end user to gather requirement on the enhancements.
• Analyzed Functional Requirement Documents (FRD) then start create technical design specifications, develop code and create test data for testing the functionality.
• Involved in developing PL SQL Code & UNIX shell Scripts.
• Involved in Peer reviews on Technical Spec documents, Test cases, Code, Test results.
• Involved in Preparing & execute in Unit testing, SIT/UAT
• Prepared the release management activity for code deployments.
• Maintained code in code version control tool IBM Clear case & SVN
• Identified the defects & reports to project groups & create the defects in IBM Clear Quests.
• Modified existing ORMS screen with Form developer to meet the Client requirements
• Single handedly installed the complete Oracle Apex installation (Apex) software in all servers’ including Prod & then designed, developed set of new Apex forms & reports for the user.
• Worked as IT consultant at client place (at Sweden) & addressing the user’s issues.
• Addressed the issue at client place (Sweden) for EBS System & created new companies in Ebs system R12
• Involved in production supports, on call supports& retail Job monitor on regular basis.
• Extensive working experience in Oracle retails Jobs (RMS)
• Attended Daily calls, Project calls.
• Developed new UNIX shell scripts for the RMS enhancement projects.
• Helped the end user at Onsite when there was help need on oracle retails suite MOM modules (Like RMS/RPM/Allocations)
• Co-ordination between Onsite and Offshore team.

Confidential

Senior Software Engineer/ Techno Functional Analyst

Environment: Toad, UNIX Shell script, UNIX, PL/SQL, Oracle 10g, Oracle Developers 2000, Pro*C

Responsibilities:

• Co-ordination with onsite person & business team to gathering Business Requirements.
• Involved in developing the Technical Design for the customizations done as part of the implementation of Oracle Retail Suite of products.
• Worked as a Techno Functional Analyst for the RMS modules
• Build new & modified the existing Oracle Forms as per business requirement in RMS module
• Build new & modified the existing UNIX shell scripts as per enhancement in RMS module.
• Involved in developing advance PL-SQL DB objects as per requirements.
• Doing UAT support (monitoring the Nightly jobs & fix the issue if any & re-run the jobs) during the phase1 installation.
• Interaction with the Oracle Support for Service Request (SR) resolution
• Helped the new team members in technical as well as functional issues who are in new to PL SQL/Oracle Forms& RMS modules.
• Provided necessary user training and application demonstration to the key business users
• Fixed the SIT/UAT defects & reports the defect status on the daily status calls & also updates the defects status in IBM CQ Defect tool.
• Involved preparing the release management activity for code the deployment.
• Properly maintained the code version in IBM Clear Case & SVN tool for each enhancement.
• Got Client Appreciation email regarding extensive UAT support during Phase1 Implementation time

Confidential

Senior Software Engineer

Environment: Toad, UNIX Shell script, UNIX, PL/SQL, Oracle 10g, Oracle Developers 2000

Responsibilities:

• Designed Technical documentation &then build code (Oracle Forms & PL/SQL) as per business requirement in RMS module
• Modified couple of RMS functionality (Screen) through Oracle Forms & PL SQL as part enhancement
• Involved in debugging & solving Assembly Test/SIT/UAT defects& at the same time update defect status in Clear Quest tool.
• Mentor to new joiners to the team who are entry level & new to Oracle forms & RMS.
• Involved in validating the codes, screen in RMS after oracle patch installed.
• On regular basis doing audit check in Clear case for the latest code checked-in

Confidential

Software Engineer

Environment: Toad, UNIX Shell script, UNIX, PL/SQL, Oracle 10g, Oracle Developers 2000

Responsibilities:

• Involved in preparing the technical Design &Developed & modified the Pro*C as per requirements
• Modified new oracle Forms & PL Sql in RMS.
• Involved in Fixing the SIT/UAT defects & update the defects status to group regularly

Confidential

Software Engineer

Environment: Toad, UNIX Shell script, UNIX, PL/SQL, Oracle 10g, Oracle Developers 2000

Responsibilities:

• Prepared the Technical Design doc for customization on excel Upload
• Involved in developing the pro*c & UNIX shell scripts to load the excel data into staging & main tables
• Modified excel upload screen in RMS to upload client excel so that screen can create PO/ Promotion as bulk
• Created new error screen in RMS for Excel file basic validation purpose during excel upload
• Developed PL SQL code to validate excels uploaded data & insert into staging & then insert into RMS main tables (PO/Promotions tables).
• Involved in doing peer reviews on Coding, technical spec doc
• Mentors to new joiner for Oracle forms/reports/PL SQL & UNIX shell scripting which was helping them to complete their work in this project.

Confidential

Software Engineer

Environment: Toad, PL/SQL, Oracle 10g, Oracle Developers 2000

Responsibilities:

• Coordinated with Onsite business team to gather requirement by involving our team lead.
• Involved in preparing the technical design as per requirement.
• Developed brand new oracle form in RWMS application as per customer requirement
• Involved in design & develop the new application tool (Automation Tool) where whole RWMS 12 base (both DB/ Application) & patches has been installed by this tool. With this tool achieved manual intervention to install the RWMS application by DBA team.