SUMMARY:

• Experienced Oracle Applications Techno Functional consultant, working in ERP for over 7 Years around Financials and Manufacturing modules.
• Proficient in Procure to Pay and Order to Cash business flows, mainly working in Payables, Purchasing, Inventory, Order Management, Receivables, and General Ledger modules.
• Extensively worked on various RICE objects design and development in both Oracle Applications R12 and 11i.
• Proficient with various Reporting techniques and tools including Reports Builder 6i/9i/10g, XML Publisher, EIS Reporting, Discoverer and others.
• Experienced in developing Forms from Scratch for Oracle applications. Extensively customized forms and used forms Personalization, for extending application functionality in Payables, Receivables and Order Management.
• Good Working knowledge on building various objects like business areas, folders, etc., using Discoverer Administrator component. Created various workbooks using Discoverer Desktop and Plus components.
• Well versed in authoring AIM documentation during all stages of the SDLC including BR100s, MD50, MD70, CV40, promotion, integration and configuration documents.
• Hands on Experience in developing Workflows using workflow builder and customized various standard Oracle Workflows. Few of them are PO Approval, INV Approval, OE Headers, OE Lines and others.
• Proficient in System Administration activities including RBAC configuration in R12, managing concurrent managers, Developing custom applications, responsibilities, menus and request groups. Registering Concurrent programs and Request Sets. Defining value sets, flex - fields, lookup values, profile options and printers.
• Proficient in SQL and PLSQL Scripting, developing various database objects such as Tables, Views, Indexes, Sequences and/or PLSQL objects like Stored Procedures, Packages, Triggers, etc.,
• Experienced in UNIX Shell Scripting and command line utility. Developed scripts for automation of various concurrent processes, mail generation, file handling, encrypting, archiving, etc., and registered them as host concurrent programs.
• Actively involved in handling of many production issues and fixing Bugs, working in close proximity with Oracle Support by logging Service requests, escalations, patch analysis and application.
• Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications R12(12.0.6, 12.1.3)/11i(11.5.10.2, 11.5.8, 11.0.3). General Ledger, Accounts Payables, iExpense, Purchasing, Cash Management, Subledger Accounting, Inventory, Accounts Receivables, Fixed Assets, Order Management, Shipping and Advanced Pricing.

Oracle Tools: Reports 6i/9i/10g, Forms 6i/9i/10g/11g, Discoverer 4i/10g, Workflow Builder 2.5, XML Publisher, EIS Reports, More4APPS, JDeveloper.

Database: Oracle 10g/9i/8i, MS SQL Server 6.5/7.0, DB2, Sybase.

Development Tools: SQL*Plus, TOAD, PLSQL Developer, SQL*Developer.

Scripting: SQL/PLSQL, UNIX, JAVA, C/C++.

Application Utilities: SQL*Loader, TKPROF, UTL FILE, FND LOAD.

Operating System: HP-UNIX, SUN Solaris, AIX, LINUX, WINDOWS, NOVELL.

PROFESSIONAL EXPERIENCE:

Confidential, Renton, WA

Sr. Oracle EBS Consultant

Responsibilities:

• Understanding the requirements by involving in the Business meetings, authored Technical Specification, Change analysis and migration documentation.
• Designed and Developed codes for various periodic Inbound and Outbound interfaces including:
• Payables invoice Interface - Inbound
• Bank reconciliation - Inbound
• Journal Import/GL interface -Inbound
• Auto Lock Box - Inbound
• Remittance Advices - Outbound
• Payment Extract - Outbound
• Supplier Extract - Outbound, etc.,
• Extensively utilized SQLLOADER, External tables, UTL FILE concepts for reading files and loading into oracle database. Created various packages, procedures and functions for validating the data and loading into the interface tables. Registered the processes as Concurrent programs and combined and the load, validation and Import script as request sets.
• Performed data conversion for newly implemented applications of R12.1.3, including pricing headers and lines, items and item costs.
• Redesigned and modified various custom codes developed in 11.5.10.2, to work with R12.1.3 applications including, Manual Transaction Workflow, Ship confirm and Delivery detail identification, Drop ship process to block Sales Order Changes, etc.,
• Personalized various forms as per the Business requirement, to block updates on all fields or few based on the responsibility and Operating unit user is accessing. Developed various custom forms using Forms 10g to meet client specific needs.
• Developed various reports in Discoverer Plus, XML publisher, Reports Builder, EIS and PLSQL, including:
• Subledger Activity Report- Discoverer
• Forecast Download - Discoverer
• Vendor Audit - EIS
• Payment Register with Coding - XML
• Invoice Register -XML
• Delivery Detail - XML
• AP Invoice Aging - EIS
• AR transaction Aging - EIS, etc.,
• Designed and developed code to generate XML files for Out-bound extract and report generation using PLSQL and registered as Concurrent program.
• Developed custom mail UNIX script and registered as concurrent program which can be used to send notifications with attachments as of when required.
• Supported existing interfaces into 11.5.10.2, by efficiently communicating and reprocessing as of when required. Enhanced interface codes for better debugging and error handling.
• Extensively worked in collaboration with Oracle Support for resolving various bugs.
• Worked on version control software Clear case, migration tool Kintana & Defect tracking SYSAID.

Environment: Oracle Applications R12 (12.1.3/11.5.10.2 ) (GL, AP, PO, INV, AR, OM, iExpense, iSupplier), Oracle Database (9i/11g), Forms 6i/10g, AIX/EXADATA, UNIX, TOAD, Discoverer 4i/10g, Reports 6i/10g, BI Publisher/XML Publisher, EIS Reporting, Workflow Builder, SYSAID, Rational Clear Case, Kintana.

Confidential, Appleton, WI

Sr. Oracle Techno-Functional Consultant

Responsibilities:

• Developed various in oracle BI publisher/XL publisher like Null Buyer Item, Future Cost Update and Backordered items Report and registered them as Concurrent Programs.
• Converted oracle Seeded reports in Reports10g to XML reports.
• Developed Custom packages to fetch ROYALTY item from staging table and load them into Item Master.
• Designed and developed various PLSQL programs and registered them as concurrent programs to fetch the data and write to Comma Separated files in the predefined Server location. Utilized UTL FILE Utility for writing data to the file in middle tier.
• Authored various AIM documentation including Functional Specifications (MD50), Technical Design Specifications (MD70, MD120) and conversion documents CV40.
• Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice Base tables.
• Customized the Accounts Payable Supplier Entry Form as per requirements.
• Created new End User Layer (EUL) for Oracle Discoverer version 10g. Created business areas and folders based on SQL codes and Views. Administered security of Oracle application users and Responsibilities through Discoverer Administrator.
• Developed simple to Complex worksheets, pivot reports using Discoverer Plus and shared the workbooks with users and responsibilities.
• Involved in designing and developing various reusable packages and procedures, which were utilized by various programs.
• Modified Customer Validation Program in Receivables, incorporating client specific Business requirements.
• Extensively worked RBAC, for defining new roles in R12, controlling user security.
• Extensively worked on iExpenses for Integrating Master Cards and loading credit card transactions into Oracle system, which will later be converted as expense reports.
• Worked on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.
• Utilized FND LOAD for data migration of various system administration objects, between various instances such as Menus, Custom Responsibilities, Personalizations, Concurrent Programs, Value Sets, Flex-fields, lookups and others.
• Customized various workflows including Requisitions Approval (REQAPR), Invoice approval (APINVAPR), Order Headers and Order Lines in OM, Expense report approval (APEXP) and others using Workflow Builder.
• Prepared documents and conducted sessions with business users, to train them in the newly developed custom extensions of the existing oracle system.
• Extensively worked on Production issues, and resolved various bugs working in collaboration with Oracle Support on Sev1 and Sev2 Service requests.

Environment: Oracle Applications R12 (12.0.6) (GL, AP, PO, INV, AR, OM, QP, BOM, WIP, SC, iProcurement), Oracle Database (10g), SQL*Plus, SQL*Loader, Forms 10g, SUN SOLARIS, PLSQL Developer, Discoverer 10g, Reports 10g, XML Publisher, CVS, SMILE ticketing system.

Confidential, Princeton, NJ

Sr. Oracle Apps Developer

Responsibilities:

• Requirement Gathering and Business analysis document Preparation. With extensive involvement in the Functional design of r12 implementation and conversions of General Ledger, Fixed Assets and Payables financial modules.
• Developed and customized various XML payment templates and registered them to generate payment files for EFT transmission to various banks like BNY, Credit Suisse, ING, etc.,
• Defined and Customized Journal templates, Budget Entry templates integrated with oracle general ledger for spreadsheet Journal and Budget ADI uploads.
• Converted Balances, Suppliers and Open Invoices into Oracle R12 from the legacy AS400 system.
• Extensively worked and developed reports on Oracle Sub Ledger accounting to analyze and gather information from Payables into GL and reverting back from GL Journal Entries to grab Payables Invoice and Payment Details through XLA.
• Designed and developed various Quarter end and Year end reports for the Higher Management review in AP like Top Ten vendor payments, Overall Payments history, Employee and Tax Payments etc.,
• Developed Business Areas for General Ledger, Budgets, Accounts Payable, Sub Ledger Accounting and System Administrator and Custom folders in Discoverer Administrator, and various workbooks of type table and cross tab in Discoverer Plus.
• Personalized various forms to include additional information such as adding IBAN number on Invoice, mandatory description for Invoice Header line, etc.,
• Designed and implemented XL Downloadable version of Budget Activity in Discoverer for the users to analyze, change and upload the latest version of the current forecast through web ADI.
• Designed and developed the whole process of extracting data from multiple XML Log files downloaded from bank, and sending out single email with attached log report in legitimate format.
• Worked with Oracle Support to identify and solve various R12 Severity 1 issues with 24/7 availability and collaboration.
• Implemented, supported and resolved numerous defects in the oracle General ledger and Budgeting as per the post production issues.
• Developed test scripts and performed testing routines before User Acceptance testing in the oracle Test instance.
• Resoled period closings issues in oracle General Ledger while performing one time translations and auto reversal at the end of the period.
• Implemented new bank, Bank Branch and accounts in oracle Cash Management. Performed all payment setups and check setups for the bank as per the bank requirement in oracle Applications Payables.
• Supported the team with Post production issues. Acted as a Maintenance functional support for guiding users understanding the new system and solve daily problems.
• Worked extensively on client VSS (Visual Source Software) for tracking the changes (Change/ Version Control) and promotion between different instances.

Environment: Oracle Apps Release R12 (12.0.4) (GL, AP, PO, INV, AOL, EB-Tax), Oracle Database (10g), SQL*Plus, SQL*Loader, Forms 10g, TOAD, Discoverer 10g, Reports 10g, XML Publisher, UNIX, Mercury Quality Center, Service Center.

Confidential, Atlanta, GA

EBS Support Specialist

Responsibilities:

• Gathered Business requirements and documented Functional and Technical specifications, for the conversions and interfaces between the merging applications systems.
• Worked on the development of Interfaces and Development and Customization of Reports in Order to Cash Cycle.
• Developed Customer Interface in Receivables, Sales Orders Import in OM and Item Import in Inventory.
• Worked extensively on Auto Lock Box to bring data from external sources into Receivables for developing customer receipts and generated validation programs against invoices.
• Customized the complex Credit Analysis Reports in Order Management for including the customer information & better tracking according to functional specification. Also developed many other reports of different complexities.
• Created Custom responsibilities GL, AR, OM, INV and moved all orders booked and status not closed to the new responsibilities for further processing.
• Developed Programs to renew the sales and expense accounts in Inventory.
• Involved in rewriting some of the existing custom interfaces in PL/SQL tuning the code, to reduce the turnaround time of execution and completion of concurrent processes.
• Involved in integration of Service Contracts management practices with Accounts Receivable, Order Management, and Install Base.
• Developed procedures and SQL queries to run the Ad-hoc reports and tuned the application (report queries, other SQL queries) to improve the performance.
• Interacted with the users for gathering the requirements, after code delivery created test scripts and assisted them in User Acceptance Testing.
• Used Rational Clear Case to maintain custom code and technical or promotion documents.
• Extensively worked with Oracle technical Support team for solving various issues at different severity levels.
• Performed data validations against standard reports to compare the custom built Discoverer reports for eliminating abnormalities.
• Acted as a mediator between the business users and developer team for efficient problem understanding and to deliver accurate codes.
• Performed Unit Testing of various objects and performed defect analysis and FIX during the pre-production stage.

Environment: Oracle Apps Release 11i (11.5.10.2) (GL, AP, PO, INV, AR, OM, QP, SC, AOL), Oracle Database (9i/10g), SQL*Plus, SQL*Developer, Forms 6i, AIX, Reports 6i, BI Publisher/XML Publisher, Workflow Administrator.

Confidential

Oracle Technical Developer

Responsibilities:

• Involved in Customization of various Financials Modules (GL, AP, AR, PO, INV and OM). Successfully Interacted with Functional Consultants, QA team, DBA team and development teams. Developed Technical MD70 specification.
• Customized menus, added new concurrent requests, registered the custom applications, value sets etc. using System Administrator Module.
• Developed Concurrent Programs to interface Customer data from Legacy Systems to AR.
• Developed PL/SQL package to insert customer information using TCA API.
• Implemented Auto Lock Box process.
• Customized AP Check report in accordance to clients check printing stationary. Customized Report for Cash/Bank Book Report.
• Involved in implementing various business process extensions of Order-to-Cash and Procure-to-Pay cycles as per the business requirements.
• Loading Catalogs into iProcurement. Actively participated in the implementation of Punch-out.
• Workflow customizations in Purchasing Module i.e. PO Requisition Approval and PO Approval.
• Customization of Order Management Workflow for Sales Order Approval.
• Developed XML/BI Publisher reports for standard purchase order with 2-Way 3-Way- 4-Way matching, Customer aging report.
• Involved in writing the mapping and process Documents of Journal Import in GL and Invoice Interface in AP, for daily interfaces from the Legacy Mainframes System.
• Developed and Customized Forms, Reports, PL/SQL Procedures, Triggers and Functions.
• Wrote complex SQL queries, Control files, Procedures, Triggers and Packages.
• Worked on Metalink to raise and track Service Requests to Oracle.
• Rectified the errors in the log file and loaded the data into the interface tables usingSQL*Loader.
• Prepared Deployment documents for moving custom developed reports and forms from the development instance to production after code testing.
• Coordinated knowledge transfer to technical team and guided them on prevailing technical issues and general Oracle Applications issues.

Environment: Oracle Apps Release 11i (11.5.10), Oracle Database (9i), SQL*Plus, SQL*Loader, Forms 10g, UNIX, TOAD, Discoverer 10g, Reports 10g, BI Publisher/XML Publisher, SQL DEVELOPER.

Confidential

Oracle Applications Developer

Responsibilities:

• Team member in development of an in house MRP package to integrate Material Procurement, Inventory Control, Spares Management, Preventive Maintenance Planning Module and Production Control System Projects.
• Developed various reports using Reports Builder and PLSQL: Manpower Forecast and Planning, Daily and Monthly Production, Goods Receipt Note, Inspection Report, Acceptance & Rejection Reports, Issue of Material, Material Utilization.
• Worked on fine-tuning of SQL queries and PLSQL procedures for improved performance. Utilized Explain Plans to analyze and SQL Hints where ever required.
• Customized the ‘OM: Generate Cost of Goods Sold Account’ Workflow to generate the COGS account that meets the business requirements.
• Developed Various Reports in GL, AP and AR and customized them using XML Publisher.
• Customized existingDunning Reportand Invoice PrintingReport in Accounts Receivables usingXML/BI Publisher.
• Customized various reports in Order Management, Inventory and Shipping. Some of them are Pack List, Bill of Lading, Sales Acknowledgement Report, Order Holds Report, Delivery Detail Report.
• Involved in writing stored procedures in PL/SQL to validate, select, insert and update data in material procurement module. Material procurement module enables shop floor engineers to requisition and procure items involved in production and maintenance of machinery from central stores as well as from company vendors.
• Designed and developed reports in Oracle Discoverer for tracking Preventive Maintenance of machinery (pumps, motors, heat exchangers, dryers etc.) involved in day-to-day production activities

Environment: Oracle Apps Release 11i (11.0.3/11.5.8 ), Oracle Database (8i/9i), SQL*Plus, SQL*Loader, Forms 10g, UNIX, TOAD, Discoverer 10g, Reports 10g, BI Publisher/XML Publisher, SQL DEVELOPER.