EXPERIENCE SUMMARY:

• My technological forte is Oracle Applications E - Business Suite. I have worked as a Technical Lead as well as Techno-Functional consultant in Oracle Applications in Payables, Receivables, Purchasing, Costing and HR modules. My functional core competency lies in Finance modules i.e. Oracle Payables, Costing, Receivables and Purchasing Modules; whereas my technical core competency is on PL/SQL in addition to Oracle reports, XML Reports, Discoverer Reports, APIs and Open Interfaces for all major Oracle Apps modules.
• Over 6 years of extensive experience as Oracle Application Technical Developer in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12 and 11i). This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
• Extensively Worked on Oracle apps 11i and R12.
• Extensive experience in Implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in HR Modules Accounts Payables(AP), Accounts Receivable(AR), Costing and Purchasing(PO).
• Have hands on Conversions, Interfaces (Finance and Supply Chain Management), Reports (D2K 10G), XML Publisher (v5.6.2), Discoverer (10g), UNIX Shell Script, Technical Specifications.
• Technically proficient in RICE Components (Reports, interfaces, Conversions and Extensions).
• Experience in Procure to Pay (P2P) life cycle.
• 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.
• Experience in importing data from Legacy System to Oracle Applications using Oracle Interfaces, SQL Loader, UTL FILE, Oracle APIs and Open Import Programs etc.
• Strong Knowledge of Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Expertise on designing and implementing Oracle Alerts and Lookup.
• Experienced in Customizing Oracle Forms with Form Personalization.
• Extensively used TCA (Trading Community Architecture) to create customers in AR.
• Well versed with client server environment and tools like SQL*Plus, PL/SQL, QL*Loader, TOAD, Oracle*Reports and modified the formats using XML Publisher for customizations as per client specifications.
• Registered Concurrent Program and Request Groups for Reports.
• Expertise in Requirement gathering, Requirement Analysis, System Design, Data Flow Designs, Support, Development, Testing, Documentation and Design Reviews.
• Expert in developing Technical Design Documents (MD70), Technical Test Documents (TE120), Conversion (CV50) and Migration Documents (MD120).
• Strong in Performance Tuning using Tools like EXPLAIN PLAN, SQL TRACE, TLPROF, HINTS.
• Worked on India Localization Reports and Tax Calculation Reports.
• Troubleshoot issues including creation/follow-up of Oracle Service Requests (SR).
• Have hands on experience of user defined errors by developing Error-Handling package using PL/SQL.
• Interacted with Users, fixed the bugs, developed Test Plans and provided daily Production Support using tools like HP Quality Centre and BMC Remedy Tool.
• Excellent in Team Collaboration, Quick adaption and problem solving ability with Good Communication Skills

TECHNOLOGY:

Hardware: HP Server with OS as UNIX and windows server

Software Products: Oracle Apps e-Business Suite, C, C++, Java(Core), Developer/2000 Forms & Reports, Oracle Developer Suite 10g, SQL & PL/SQL, HTML, Microsoft Visual Studio IDE

Tools: Oracle Report Builder- Oracle Developer Suite 10g, Oracle Discoverer: Administrator and Desktop, PL/SQL Developer, SQL Developer, Win CVS, HP Kintana, Dimension Express, HP Quality Centre, BMC Remedy Tool, Jdeveloper, Jmeter

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte

Technical Consultant

Responsibilities:

• Technical Consultant for Finance modules (Oracle Apps Payables/ Receivables/ Costing/ General Ledger).
• Preparation and Maintenance of Technical Design Documents (MD070, TE020, Check scripts), as well as code review for various RICE components.
• Implementation of various customisations and developments including XML Reports, Form Personalization, Interfaces (Internal as well as with partner systems) for Finance modules.
• Supported various existing custom workflows, billing extensions, inbound as well as outbound third party interfaces.
• Worked on Language Translations (Xliff files), bursting, form personalisation.
• Developed Custom Reports using complex Queries as per client request as a part of Production Support.
• Worked on various India Localization Reports and Tax Calculation Reports.
• Worked extensively on Conversion Programs and Conversion Tool.
• Developed Conversion programs to load AP Invoice, AR Invoices and Items data from legacy System to Oracle Applications using APIs.
• Also, wrote validation Procedures to validate the data before migration.
• Designed and developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.
• Coded PL/SQL Packages and Procedures to perform Data Loading, Error Handling and Logging.
• Performed SQL Tuning using Explain Plan, Tkprof, Hints and Indexes.
• Analyse SQL statements, Reorganize Database Objects and Design Indexes to Improve Response of Queries.
• Developed Oracle Alerts to show whether the period is open or closed during month end process to minimise P2 Tickets.
• Developed various custom programs to extract Payment related data during month end to fasten the process of Reconciliation and validation.
• Responsible for delivery of objects on time and sometimes ahead of schedule.
• Interacted with Users, fixed the bugs, developed Test Plans and provided daily Production Support.
• As Technical Developer worked through all Software Development Lifecycle (SDLC) process.

Confidential

Technical Consultant for Finance modules

Responsibilities:

• Technical Consultant for Finance modules (Oracle Apps Payables/ Receivables/ Costing/ General Ledger).
• Preparation and Maintenance of Technical Design Documents (MD070, TE020, Check scripts), as well as code review for various RICE components.
• Implementation of various customisations and developments including XML Reports, Form Personalization, Interfaces (Internal as well as with partner systems) for Finance modules.
• Supported various existing custom workflows, billing extensions, inbound as well as outbound third party interfaces.
• Worked on Language Translations (Xliff files), bursting, form personalisation.
• Developed Custom Reports using complex Queries as per client request as a part of Production Support.
• Worked on various India Localization Reports and Tax Calculation Reports.
• Worked extensively on Conversion Programs and Conversion Tool.
• Developed Conversion programs to load AP Invoice, AR Invoices and Items data from legacy System to Oracle Applications using APIs.
• Also, wrote validation Procedures to validate the data before migration.
• Designed and developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.
• Coded PL/SQL Packages and Procedures to perform Data Loading, Error Handling and Logging.
• Performed SQL Tuning using Explain Plan, Tkprof, Hints and Indexes.
• Analyse SQL statements, Reorganize Database Objects and Design Indexes to Improve Response of Queries.
• Developed Oracle Alerts to show whether the period is open or closed during month end process to minimise P2 Tickets.
• Developed various custom programs to extract Payment related data during month end to fasten the process of Reconciliation and validation.
• Responsible for delivery of objects on time and sometimes ahead of schedule.
• Interacted with Users, fixed the bugs, developed Test Plans and provided daily Production Support.
• As Technical Developer worked through all Software Development Lifecycle (SDLC) process.
• Prepared several Read me documents for users so that they don’t face issue especially during month end.
• Groomed 3 other team members on Oracle Apps Technical skills and mentored them to help them achieve their technical objectives.
• Led a few technical initiatives at offshore location (e.g. CCBT - Customer Centric Business Transformation and Knowledge Sharing Session Initiative).

Confidential

Technical Lead

Responsibilities:

• Techno-Functional Consultant for Oracle Apps Purchasing Module and Technical Consultant for HR/Purchasing modules.
• Setup activities, Preparation of To-be Document, Gap Fit documents, BR100, FDDs and so on for purchasing module.
• Setup and Maintenance of Collection Plans in Quality module.
• Implementation of various customisations and developments including Oracle Reports, XML Reports, Oracle Alerts, Form Personalization for Oracle Purchasing, Oracle Finance and Oracle HR modules.
• Data migration by implementation of data conversion and migration scripts for Purchasing module.
• Extensively worked on P2P cycle both technically and functionally.
• Onsite-offshore management and co-ordination with the onsite team to help resolve technical problems and meet project deadlines.
• Development of a shell script for bulk movement of AOL objects across instances easily, without the need to write the commands for all objects.
• Development of PL/SQL Procedures & packages, Interface programs.
• Development of Complex Reports like Dunning Letters, Self Billing of Invoices and PO PDF Reports.
• Testing and debugging custom components as well as seeded processes, Code and TDD review and documentation.
• Interacted with Users, fixed the bugs, developed Test Plans and provided daily Production Support.
• Responsible for Data Mapping from Legacy and Oracle environment.

Confidential

Techno-functional Consultant

Responsibilities:

• Techno-Functional Consultant for Oracle Apps Purchasing Module.
• Implementation of various customisations and developments including XML Reports for Oracle Purchasing, Customer Relationship Management.
• Data migration by implementation of data migration scripts for various custom modules in the purchasing apart from the seeded Oracle Modules.
• Development of PL/SQL Procedures & packages, Interface programs.
• Testing and debugging components, Code review and documentation.
• Development and Management of a custom Module for Legal Tracking in the Client Organization.

Confidential

Technical Consultant

Responsibilities:

• Implementation of extensive customisations and developments for Accounts Receivables, Public Sector Budgeting, General Ledger modules.
• Successfully teamed up for the extensive development of more than 80 XML reports for different modules.
• Appreciation received from onsite team for excellent offshore support.