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), Warehouse Management System (WMS), Application Object Library (AOL), System Administrator, HRMS.
• Experience in other modules like IProcurement, IExpenses, 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.
• Exposure in Trading Community Architecture (TCA), Sub-Ledger Accounting (SLA), EB-Tax.
• Experienced in RICE (Reports, Interfaces, Conversions and Extensions) components.
• Experience with Workflow execution, workflow modification, PL/SQL event support, debugging and testing.
• Experience with AME setups.
• 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.
• OpenedService Requests with Oracle Supportin different scenarios, for providing Solutions to the Bugs identified during Production Support.
• Resolved various bugs, working in collaboration with Oracle Support.
• Extensive experience with all aspects ofOracle Applications R12/11i and Oracle Database 11g/10g/9iproduct versions in large scale environments

TECHNICAL SKILLS

ERP: Oracle E-Business Suite R12, 11i

ERP Modules: GL (General Ledger), AP (Account Payables), AR (Account Receivables), 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, FL

Sr. Oracle Apps Techno-functional Consultant

Responsibilities:

• Worked on the client requirement for for creation Party, Customer, Customer Sites, Bank Accounts and Credit cards, Customer Org Contacts etc., using oracle standard API’s and developed interface this services were utilized there custom third part application, ECM and COM portal.
• Worked on various conversions activity as apart of implementation conversions developed are PO Locations, Employer Conversion, Customer Conversion, GL conversion and PO Conversion.
• Worked on Analysis, design and implementation of custom enrollment process, which includes integration of oracle modules, Campaign, Marketing, Quotes, Order Management, Service Contracts and AR process.
• Developed custom interface for Payments and Authorization while submitting the Quote to Order.
• Created custom Interface between Order management and Service Contract for enrollment process.
• Worked on Oracle Quality Module, created and modified collection plans as per the client Needs.
• Worked on oracle payment process, developed custom Check layout and reports (formatting checks and positive pay file layouts) in AP.
• Extensively used PL/SQL Collections while developing the code.
• Worked on ORACLE Campaign and marketing modules, Development of Custom OA Framework Pages as client requirement.
• Developed reports for correspondence using XML/BI publisher reporting.
• Involved in weekly meeting with business and functional to understand the process and developed the code efficiently.
• Worked on thenewVersion control software GIT/Stash for migrating code to higher instances.

Environment: Oracle E-Business Suite (EBS)/ Oracle Applications (R12 (12.1.3)), AP, AR, PO, OM, GL, INV, OKS, ASO, Oracle Forms& Reports 10g, Workflow Builder, XML Publisher, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, OAF, UNIX, TOAD, WINSCP and Putty.

Confidential, NY

Sr. Oracle Apps Techno-functional Consultant

Responsibilities:

• Handled the production support environment, working with oracle teams raising SR's and handled severity1 issues
• Created Alerts as per the business requirement.
• Involved in creation of punch-out for suppliers
• Involved in customization of IExpenses(APEXP) Workflow.
• Involved in Enhancement of existing custom FORM as per the business requirement.
• Involved in various Data fixes and provided support for the business users.
• Involved in VO extension of custom OAF page.
• Worked on LPN’s, Serial numbers in WMS module.
• Developed a custom program Named “Mass Unpack”, used while unpacking the LPN’s.
• Prepared migration documents for moving components from one instance to another
• Developed XML/BI publisher reports as per the business requirement.
• Involved in Production support for releasing the orders that are struck in between the O2C process.
• Worked On LPN, Serial numbers, WMS, INV, GL, AP modules and handled all the tickets for production support.
• Worked on AME setups in PO approval process.
• Involved in gathering of requirements from the business users and developed the system according to the end users.
• Developed Concurrent Programs, Value Sets & Request Sets based on the 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 10g.

Environment: Oracle E-Business Suite (EBS)/ Oracle Applications (R12 (12.1.3)), AP, AR, PO, OM, GL, INV, WSH, Oracle Forms& Reports 6i/10g, Workflow Builder, Discoverer 4i, XML Publisher, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, OAF, UNIX, TOAD, WINSCP and Putty.

Confidential, NY

Sr. Oracle Apps Techno-functional 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.
• 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 to explain the business requirement and handle the 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.Forms Reports 10g/Discoverer/XML & OAF:
• 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, OM, GL, INV, WIP, BOM, iprocurement, 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 Techno-functional Consultant

Responsibilities:

• Upgrade of 11i custom objects from release 11i to R12 in major financial Modules.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the Customers using TCA (Parties, Party Sites, Party Accounts, Party Account Uses), Items, Item Categories, Item Revisions, Open Sales Ordered., from legacy system.
• Worked extensively on API’s of HZ PARTY V2PUB for TCA, AR INVOICE API PUB for AR.
• Involved in Requirement gathering for landed Costing (Custom Module) and interfacing with Oracle Applications which captures the Overheads before receiving the goods into Inventory.
• 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, 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 Personalization 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, 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, OM, and PA related Interface programs to synchronize the data between existing Legacy system and Oracle Database
• 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 11i(11.5.10), OM, INV, PO, AP, AR, GL, 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 11i(11.5.10), 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.