Description
PROFESSIONAL SUMMARY: 12 Years Experience in Oracle Applications as a Techno Functional consultant with good knowledge in coding and testing of software applications, and in-depth knowledge in Oracle Application 11i/R12 (12.0.6,12.1.1,12.1.3,12.2.4), Framework9i, OAF, ADF, SOA, XML/ BI Publisher, Discoverer10g, Oracle9i/10g/11g, Forms6i/10g, Reports6i/ 10g, Oracle Alerts, Oracle J-developer (10g), Oracle Applications, Workflow Builder2.6, PL/SQL, Triggers, Agile Scrum, CRM * Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in Accounts Receivable (AR), Inventory (INV), General Ledger (GL), Accounts Payables (AP), Purchasing (PO), I-Procurement, CM, Order Management (OM) * Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications. * Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows). * Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles and Supply Chain business flows. * Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader. * Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC). * Expertise on designing and implementing Oracle Alerts and Lookups. * Worked in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions. * Performed User and Administration responsibilities in Discoverer. * Experienced in Customizing Oracle Forms with Forms Personalization using Custom.pll and Zoom functionality. * Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher). * Developed new Concurrent Programs, Custom Forms, Reports and Flex Field Customizations. * Extensively used TCA (Trading Community Architecture) to create customers in AR. * Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL * LOADER, UTL_FILE, Oracle packaged APIs etc. * Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews. * Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120). * Experience in customizing oracle workflows such as the PO approval process, Order/Line Flow to send user notifications based on the business requirement. * Strong in Performance Tuning, UNIX scripting. * Ability to handle user defined errors by developing Error-Handling Package using PL/SQL. * Adroit in Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, HINTS
Accomplishments
Highlights:
Keywords
