SUMMARY

• Around 8+ years of IT experience in developing cost - effective solutions as Technical Consultant using Oracle Applications.
• Having experience in Analysis, Design, Development, Data Conversion, Upgrades, Customization, Interfacing & Implementation of business applications using Oracle Applications R12, 11i
• Extensive experience in Oracle Application Modules which include General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Purchasing (PO), Order Management (OM), Inventory (INV), Application Object Library (AOL), System Administrator.
• Experience in other modules like Fixed Assets (FA), Project Accounting (PA).
• Exposure in modules like Bills of Material (BOM), Work in Progress (WIP), Oracle Shipping (WSH), Oracle Alerts (ALR).
• Extensive experience in Procure to Pay (P2P) and Order to Cash (O2C) life cycles with related Open Interfaces and API’s.
• Worked as Techno Functional Consultant in AP Setups for Payments Using Payment Administrator.
• Experience in Trading Community Architecture (TCA), Sub-Ledger Accounting (SLA).
• Experienced in RICE (Reports, Interfaces, Conversions and Extensions) components.
• Experience with Workflow execution, workflow modification, PL/SQL event support, debugging and testing.
• Extensive experience in Personalization of Oracle Forms 6i/10g.
• Extensive experience in Customizing and Developing Oracle Reports 6i/10g.
• Extensive experience in developing Interface and Conversion Programs to import data from various Legacy source files into Oracle Applications using PL/SQL, SQL*Loader, UTL File, Unix Shell script’s, and API’s.
• Expertise in XML Publisher Reports, Creating Data Templates and complex XML Publisher Templates.
• Experience in OA Framework and customization and Personalization of JSP pages.
• Extensive experience in using SQL, PL/SQL, SQL*Loader, UNIX, and Shell Scripts.
• Extensive experience with AOL to develop Flex fields, Lookups, Validation sets, Concurrent programs, Profile Values, Request Sets registration, and Responsibilities.
• Proficient in writing Stored Procedures, Packages, Functions, Triggers using PL/SQL.
• Well versed with client server environment and tools like Developer/2000, SQL* Loader, SQL Developer, JDeveloper, and TOAD.
• Involved Customization of workflows.
• Involved in performance tuning in oracle using Explain plan, Auto Trace, and Tkprof.
• Involved in QA and UAT testing and fixing the issues.
• Extensive experience identifying product gaps coordinated with development team by creating Technical Assistance Request (TAR)/SR and obtained one-off fixes.
• Well versed with AIM (Application Implementation Methodology) Documents.
• Participated in written Functional Document’s (MD .050), Technical Document’s (MD.070) and Migration Documents (MD.120) according to the business requirements.
• Ability to interact effectively with clients, Understanding their requirements and providing optimum solution and support.
• Excellent Analytical, interpersonal and communication skills. And ability to learn quickly to new technologies and methods in a short period of time.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite R12, 11i

ERP Modules: GL (General Ledger), AP (Account Payables), AR (Account Receivables), Trading Community Architecture (TCA), Customer Data Hub ( CDH), PO (Purchasing), OM (Order Management), INV (Inventory), Project Accounting (PA), AOL (Application Object Library), P2P, O2C, and System Administration.

RDBMS: Oracle 8i/9i/10g, SQL Server 7/2000.

Development Tools: XML/ Reports & Forms 6i/10g

Database Tools: SQL*PLUS, SQL*Loader, TOAD, SQL*Navigator, SQL Developer.

Document Methodologies: MD.050, MD.070, MD.120, TE.020, CV.040.

Languages: SQL, PL/SQL

Reporting Tools: Reports 6i/10g, XML/BI Publisher.

Operating Systems: Windows XP/NT/ 2000/98/95/2007, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr Oracle Apps Technical Consultant

Responsibilities:

• Worked on Oracle API bug in Supplier Sites Open Interface Import, causing all the legacy data to be rejected because of duplicate Vendor Site Code.
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP, GL, OM, Quoting, Customer Data hub ( CDH), Product Data Dub ( PDH), Master Data Management ( MDM), INV, Shipping, PO and i-Procurement modules.
• PO Approval Workflow: Implemented notification reminder and Timeout needs for the PO Approval workflow.
• PO Account Generator Workflow.
• Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders in P2P cycle into Production.
• Designed customization, interface/conversion mapping, pre production testing, and related documentation.
• Written an API for Converting the Invoice Payments and was able to convert all the Historical Invoice Payment History into Production.
• Designed and developed Technical Specifications for the Inbound Interfaces as per the Functional Specifications in OM.
• Coordinating with the offshore team with daily status calls.
• Used standard Order Import to load the Open Orders from the interface tables to the standard OM tables.
• Worked with interfaces from PA(Project Accounting) to AR.
• Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.
• Downloading & Upload commands using FNDLOAD for migration from instance to another instance.
• Developed Concurrent Programs, Value Sets & Request Sets based on the business requirements.
• Involved in Personalization of Oracle Forms as per Client Business requirements.
• Involved in extension & customization of OAF Pages as per Client Business requirements.
• Involved in development and customization of major PO Reports
• Developed Oracle Report for End Users to get Banking Information associated to the Employee as a Vendor.
• Customization on Standard Oracle Reports as per the Client Requirements.
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.
• Created custom templates with Data Definitions for XML Publisher and Developed reports using reports 10g and registered as XML reports in applications.

Environment: Oracle Applications (R12 (12.1.3)), AP, AR, PO, Trading Community Architecture (TCA), Customer Data Hub( CDH), OM, GL, INV, WSH Oracle Forms& Reports 6i/10g, Discoverer 4i, XML Publisher, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, OAF, UNIX, TOAD, WINSCP and Putty.

Confidential, Boston, MA

Sr. Oracle Apps Technical Consultant

Responsibilities:

• Upgrade of 11i custom objects from release 11i to R12 in major financial Modules.
• Provided active production support on a broad range of issues for OM, EAM, INVENTORY, Customer Data hub ( CDH), Product Data Dub ( PDH), Master Data Management ( MDM), WMS, AP, AR, PO, GL modules for different Stanford organizations including LBRE, School of Medicine, EHS and ITS.
• Migrated AP, AR, & GL custom Interfaces and reports During this upgrade project.
• Designed customizations, interface/conversion mapping, pre production testing and related documentation.
• Developed and customized Financial Modules (GL, AR, AP, CDH, TCA, PO), Interacted with End users to gather requirements and Draft specifications for development Phase.
• Invoked standard API’s within custom packages for creating and updating Customer Sites and Contacts.
• Strong Oracle RICE development experience in all AP, AR, GL, PO and OM Modules.
• Responsible for converting the Purchase Orders (PO) in P2P cycle using Import standard Purchase Orders.
• Wrote Technical Specification (MD070), Conversion Mapping (CV040) documents for converting Vendors, Vendor Sites and Vendor Contacts.
• Designed, developed and documented an Inbound/Outbound interfaces.
• Designed and developed Asset Conversion by running Mass Additions Concurrent Program to transfer the data from interface to base tables in Fixed Assets (FA).
• Responsible for providing production support for Account Receivables (AR) and Account payables (AP).
• Creating staging tables required for loading the legacy data and loading the staging tables with the legacy data using SQL Loader.
• Downloading & Upload commands using FNDLOAD for migration from instance to another instance.
• Developed Concurrent Programs, Value Sets & Request Sets based on the business requirements.Forms, Reports 6i/Discoverer/XML & OAF:
• Created a Report for End Users to get the vendor and its site information.
• Developed a custom screen/jsp page in the Century Link internal portal using OA Framework (OAF) to import an XML file and PL/SQL logic to validate and create sales orders using the OM public APIs.
• Worked on Customization and Personilization OAF framework.
• Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements.
• Customization and Personalization of Oracle Forms as per Client Business requirements.
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.
• Created custom templates with Data Definitions for XML Publisher and Developed reports using reports 9i and registered as XML reports in applications.

Environment: Oracle Applications 11. i)/R12 (12.1.3) - PA, AP, AR, GL, CM, TCA, CDH, OM, PO, TCA, Workflow Builder 2.6, Oracle 9i, Oracle Forms& Reports 6i, XML publisher, SQL*Loader, PL/SQL Developer, PL/SQL, SQL, TOAD, OAF.

Confidential, Hartford, CT

Sr. Oracle Apps Technical Consultant

Responsibilities:

• Designed and developed GL, AR, AP, CDH, TCA, OM, PA, and WIP related Interface programs to synchronize the data between existing Legacy system and Oracle Database
• Designed and developed 15 Oracle EBS PL/SQL extracts for the OM, INV, WMS, i-Store, Customer Data hub ( CDH), Product Data Dub ( PDH), Master Data Management ( MDM), PO, AR and AP modules to be loaded into the FDS
• Developed GL Account Balances Conversion Programs
• Developed Item conversion program for assigning Items to Item category set and Categories
• Developed PO interface to import PO orders from legacy systems. Used API’s to update quantities and to cancel Orders
• Developed PL/SQL scripts to load order data from external system to OM interface tables
• Used SQL * Loader and UTL FILE packages for data conversion and interfaces
• Converted pricing information from legacy systems into Oracle applications using SQL*Loader and pricing API
• Designed and developed Data Audit System scripts to capture the data from "before" system (10.7) and after system (11i) based on the business requirements
• Developed database triggers on few tables to keep track of changes
• Provided an OAF design, which is configured using OAF personalization.
• Personalized seeded and custom OAF pages to hide fields and buttons on the pages
• Registered the automation scripts as concurrent programs and created a scheduling process that invokes the script periodically
• Coordinating with the offshore team with daily status calls
• Proficient with the System administrator responsibility, which included customizing the menus, adding new concurrent requests, request sets, registering the custom applications etc
• Developed Pick slip template using XML Publisher
• Developed XML template for invoice report using XML Publisher
• Created EUL and BA’s using Discoverer Admin 9i
• Handled security and privilege issues using Discoverer Admin 9i
• Handled performance issues for several reports, which involved code optimizations using auto summary management (ASM) using Discoverer Admin 9i
• Created and scheduled workbooks as per the user requirement using Discoverer
• Developed custom AR Adjustments Aging Report with fixed aging buckets. Designed the technical and user documents
• Customized Inactive Item Report and Cancelled Sales Order Report
• Developed reports to compare the captured data and report the discrepancies in the migrated data
• Built custom reports using Oracle Report builder 6i and integrated them with the application (based on the descriptive flex fields) to solve the client’s reporting needs
• Built custom forms using Oracle Forms 6i Builder to fulfill the business requirements of the client
• Worked with end users to facilitate issue resolution, troubleshooting functional application issues
• Customized existing forms to add search criteria on descriptive flex fields
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom
• Developed Application Extension CV70s using AIM methodology by reviewing CV40s

Environment: Oracle Apps R12(12.1.2), OM, INV, BOM, WIP, PO, AP, AR, GL, CDH, TCA, AOL, ORACLE 8i, 9i, PL/SQL, Forms 6i, XML Publisher, Reports 6i, Discoverer 9i, Toad 2.5, OAF

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Developing new Reports as per client requirement.
• Developed PL/SQL programs for validations.
• Developed Procedures, Packages, Triggers and Functions.
• Development of Customer and Reports.
• Created packaged procedures, triggers validation procedures.
• Created and tested reports, packages, and triggers for the system.
• Developed validation scripts for the complex business rules using PL/SQL.
• Unit and acceptance testing for all the developed forms and reports according to the client requirement.
• Designed the Test Case documents for the product.
• Tested product Performance and Functionality.
• Created test cases at all phases of unit and acceptance testing for all the developed forms and reports according to the client requirement.

Environment: Oracle Applications R12(12.0.3), Oracle 10g, PL/SQL, SQL*PLUS, Oracle Reports, SQL* Loader, WINSCP, Core FTP, Putty, TOAD, Windows 2000/XP, UNIX.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in releases of the projects.
• Actively scheduled meetings to monitor the status of the projects.
• Involved to prepare user level and system level maintenance documentations.
• Attended client daily status meetings and hand off sessions.
• Prepared installation and design documents.
• Worked with and developed scripts for Team leads, QA and Business Team to ensure the Quality of the applications.
• Design of detailed Technical Design (MD70) Design of code.
• Design of Functional Design (MD50) Documents.
• Design of Unit test plan.
• Design of Installation Instruction (Migration Document).
• Reviewing of code and testing.

Environment: Oracle Applications 11i, Oracle 10g, PL/SQL, SQL*PLUS, Oracle Reports, SQL* Loader, WINSCP, Core FTP, Putty, TOAD, Windows 2000/XP, UNIX

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Worked with and developed scripts for Team leads, QA and Business Team to ensure the Quality of the applications.
• Design of detailed Technical Design (MD70) Design of code.
• Design of Functional Design (MD50) Documents.
• Involved to prepare user level and system level maintenance documentations.
• Attended client daily status meetings and hand off sessions.
• Design of Unit test plan.
• Design of Installation Instruction (Migration Document).
• Involved in releases of the projects.
• Actively scheduled meetings to monitor the status of the projects.
• Prepared installation and design documents.
• Reviewing of code and testing.

Environment: Oracle Applications 11i, Oracle 10g, PL/SQL, SQL*PLUS, Oracle Reports, SQL* Loader, WINSCP, Core FTP, Putty, TOAD, Windows 2000/XP, UNIX