SUMMARY:

• 15 years of professional IT experience in System Analysis, Design, Software Development and Implementation.
• 15 years of experience in Oracle RDBMS using Oracle 10g/11g/12c, PL/SQL, Oracle Forms 6/6i/10g,Oracle Reports 6/6i/10g, Oracle Designer, Triggers, Procedures, Functions, Packages, Object Libraries, UNIX,Pro*C, Materialize Views, Nested tables,collections,Java standard edition,etc.
• Over 12 years of techno/functional experience in Oracle retail suite of products for involving MOM Suite, Oracle Retail Merchandising system (RMS/Retek), Oracle Retail Allocation, ORIB,,ORESA,ARI
• 8 + years of experience working in Agile framework using SCRUM.
• Extensive experience in all phases of project such as project planning, analysis, design, development, execute test plans, implementation, enhancements, and documentation.
• Experienced in leading and managing medium sized technical teams.

• Extensively involved in the integration of multiple applications (In - house custom built and ERP products)
• Experienced in Customization, analysis, designing, coding and testing of ORMS, Oracle Retail Allocations and other Oracle Retail products and PL/SQL based Retail ERP packages like Symphony GOLD.

• Thorough knowledge of Retail merchandising business concepts.
• Worked with variety of different retailers including Apparel, Speciality, Grocery, etc including some of the topmost US retailers.

• Extensive experience in Oracle retail (ERP) Implementation/customizations projects.
• Solid understanding of retail dynamics within a complex, highly integrated environment
• Very strong Retail Functional and Domain knowledge.

• Excellent analytical skills.
• Strong experience in SQL performance tuning using Explain plan, Execution Plan, Trace files, TKProf,indexes,hints,partitioning,multithreading,set based processing.
• Extensively worked in the ProC language used in Oracle Retail ERP.
• Worked on multiple in-house developed retail applications.

TECHNICAL SKILLS:

Industry Solutions: Oracle Retail Merchandising System (ORMS v9, 10, 13.2), Oracle Retail Allocation (RA), ORIB, ORESA, Active Retail Intelligence (ARI),Symphony GOLD

Languages: PL/SQL, ProC, C, UNIX Shell Scripting, D2K (Forms 6i, Forms 10G), Core JavaJ2EE, AWK

Operating Systems: UNIX and MS-DOS, Linux

Version control: GITLAB, Dimensions/PVCS and VSS, CVS.

Scheduling tools: Opcon, ESP and Control - M, AppworxDefect Tracking Tools HP Service Center, Mercury Quality center, Service Now

Other Integration Tools: Seebeyond, Message broker,ORIB

Database: MS-Access, Oracle 10g, Oracle 12c

Oracle Tools: SQL * Loader, SQL * Plus, SQL Navigator and Toad

WORK EXPERIENCE:

Confidential, Goodlettsville, TN

Lead Software Engineer

Responsibilities:

• Work with product owner to create agile stories and provide the technical write-up.
• Review the code from developers for any performance or other issues.
• Assist the developers with the coding and technical requirements to successfully demo the product to the product owner.
• Assist the product owner in sprint planning.
• Consolidate the stories for the sprint to prepare for the release.
• Align the coding/testing and release as per the new DevOps initiative from the management enabling continuous integration.

Confidential

Development and Support

Responsibilities:

• PL/SQL and UNIX shell script based Coding and unit testing.
• Performance tuning of existing PL/SQL code and SQL queries for the long running jobs.
• Provide long term and short term fix for the batch job failures.
• Support the PL/SQL and UNIX shell script based batch jobs and research and perform the data fix.
• Prepare Detailed Technical solution designs.
• Coding and unit testing.
• Performance tuning of PL/SQL programs.
• Provide long term and short term fix for the batch failures.
• Support the PL/SQL and UNIX shell script based batch jobs and research and perform the data fix.

Confidential, Charlotte, NC

Sr. Application Developer

Responsibilities:

• Coding and unit testing oracle forms and ProC programs from scratch
• Designing ARI events for different business rules like PO Approval, PO Review required for submitted orders, Allocation approval, Invoice on Hold, etc.
• Design the logic to leverage the existing DC replenishment process for the IDC replenishment.
• Impact analysis to other existing pieces of code due to the code changes.
• Defect fix to support QA testing or Production emergency changes occasionally.

Sr. Application Developer

Confidential

Responsibilities:

• Analyzing the POS Download batch flow and document the logic.
• Prepare technical design
• Impact analysis on other ORMS functionality due to the removal of POSDOWNLOAD batch program.
• Performance tuning of sql queries.
• Create Informatica Mappings to replace the POSDOWNLOAD flow.

Confidential

Sr. Application Developer

Responsibilities:

• Do the code changes or develop new code to create the extract.
• Creating the informatica mapping and coding the file extract logic.
• Crate and performance tune the sql queries.

Confidential, San Francisco, CA

Technology Lead

Responsibilities:

• Review the plan for the month end/Half End/Year End processing to complete any validations before the month/half/year end critical jobs trigger to avoid any potential failure of jobs.
• To perform code review for the enhancements.
• Create plans for the year end clean-up of inventory queues.
• Activities related to Incident Management - Troubleshooting failed jobs in production, issues related to data discrepancies between different systems integrated with RMS and work with business partners to propose solution of various processes issues in PO creation, Item creation, allocation inventory feed, RDF style/sales feed, planning inventory feed,EDI shipments, PO receipts, allocation, store receipts, pooler receipts etc.
• Identifying and implementing the strategies for batch performance improvement like SQL tuning, scheduling changes in production, etc.
• Analyze data issues and work with business partners to propose solution of various processes issues in PO creation, Item creation, allocation inventory feed, RDF style/sales feed, planning inventory feed, EDI shipments, PO receipts, allocation, store receipts, pooler receipts etc.
• Troubleshooting job failures in data stage ETL tool.
• Create and present the weekly status report which involved the ticket analysis and top high priority tickets for the week to the client Director.
• Reduced number of production incidents by more than 50% by implementing regressive problem management activities.

Confidential, Seattle, WA

Technology Lead

Responsibilities:

• Decomposing functional requirements documents into detailed designs after approval from all the stake holders.
• Create code in PL/SQL, ProC and Unix Shell Scripting
• Implementation planning and go live activities.
• Post implementation support.

Confidential, San Francisco, CA

Sr. Application Developer

Responsibilities:

• Prepare technical designs for the Conversions from legacy to ORMS (Used shell scripts,SQL Loader and Pro*C)and for the interfaces with other applications like WMS,RCOM,RDF,RDW.
• Develop additional screens (from scratch) in Oracle Forms for the customizations related to Internet Channel.
• Creating implementation plan and checklist.
• Customizations and enhancements related to Retail channel.
• Support User acceptance testing.
• Execute Mock conversions, Mock go live and validate the results prior to go live.
• Implementation of modules in production and post go live support
• Creating the scripts to archive and delete the data in custom tables.

Confidential, San Francisco, CA

Application Developer

Responsibilities:

• Code the new functionality based on the technical designs which involved new Java screens (Using eclipse) and Oracle PL/SQL procedure, triggers and Functions and doing the unit testing.
• Analyzing the inputs required to be sent to base Retek allocation calculation engine to calculate the net need and gross need.
• Impact analysis on other RMS functionality due to the change.