15+ years of IT experience with expertise in Oracle SQL, PL/SQL and Reports in Manufacturing, Banking and Healthcare domains. Experience in Oracle E-Business Suite and have been part of Technical analysis, implementations/development, upgrade, and support projects in R11i and R12 versions by using Oracle EBS suite applications.
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.
Expertise in SCM and Finance modules such as Purchasing(PO), Order Management(OM), General Ledger(GL), Payables(AP), Receivables(AR), Inventory(INV), System Administration(AOL) and iProcurement.
Worked on end to end - Order to Cash (O2C) and Procure to Pay (P2P) Cycle.
Real time Expertise in SQL, PL/SQL, Performance Tuning, Conversions/Data Migration, PL-SQL, Oracle Workflows, Oracle Reports, and Oracle APEX tools.
Extensive experience in PL/SQL Packages, Procedures, Triggers, Indexes, writing dynamic SQL’s, Exception handling, Collections and Materialized Views.
Worked extensively on RICEW components.
Logged service requests with Oracle to resolve application/system defects.
Leading a team of 15 consultants in the role of onsite Support Lead as part of current Oracle EBS Support engagement to provide end to end support and enhancement services to a prestigious Financial and Banking client.
Very good analytical and problem-solving skills.
Worked as onsite Techno Functional Lead for Order Management and Purchasing modules for one of the big ERP implementations for a fortune 50 client.
Strong technical experience of working with SQL, PLSQL, Stored Procedures, Packages Reports 6i, SQL Loader and UTL File.
Created customizations, Interfaces and reports.
Experience in Oracle EBS 10x, 11g and R12 versions.
Thorough Knowledge on Putty, File zilla and Appworx.
Developed Oracle Application Express (APEX) pages for different modules.
Highly motivated and self-starter to successfully contribute towards the success of organization.
Experience with Oracle and Other Utilities: TOAD, SQL*Loader and SQL Developer
Strong understanding of integration issues and business process.