PROFESSIONAL SUMMARY:

• Over 10 years of extensive experience in ORACLE E - Business Suite/Oracle Application (12i and r12,11i) with core expertise in Asset Management, Cash and Treasury Management, Order Management, Financial Control, and Reporting.
• Extensive experience of Impact Analysis, Process Mapping, Defining Business Requirements, Designing, Implementation, Setup and Configuration across the discrete project and Oracle Financial module including GL, AP, AR, PO, FA, OPM, INV, CE and SLA, MOAC,TCA, E-BUSINESS TAX.
• Extensive experience in the functional and technical aspect of designing, coding/development, customization, testing, custom applications with an integration to Oracle Applications or other custom applications and supporting Oracle EBS solutions.
• Expertise in development of RICE-W (Reports, Interface, Conversion, Extension, and Workflow) components for Oracle EBS.
• Strong exposure in preparation of Technical Design Document (MD-120, MD-070, CV060) based on high-level functional design documents (MD-50, CV-40).
• Extensive technical and business experience in Procure-to-pay, Order-to-cash, Asset to GL record to Report.
• Experienced in customizing Oracle workflows such as the PO approval process, order/line flow to send user notifications based on the business requirement.
• Strong understanding and experience in setting up repository, managing user profile and user groups and publishing reports.
• Interacted with business users and clients for providing Testing and Production Support after Project GO Live.
• Leading developer team member in resolving the issue by creating TAR by using METALINK for effective solutions.
• Possess excellent leadership, team management, communication skills, quick learner, excellent analytical and technical skills.
• Experienced in converting the standard Oracle reports to a more in-depth report using XML BI Publisher.
• Worked independently as well as in team management and experienced in coordinating with different groups in project.
• Extensive experience in creating and modifying stored procedures, functions, packages, triggers, and other database objects using SQL and PL/SQL.
• Experience in UNIX working environment, writing UNIX Shell Script to automate the process and schedule Oracle Current Program.

TECHNICAL SKILLS:

ERP Suite & package: E-Business Suite Oracle Application R12i, 11i, GL, AP, AR, PO, INV, FA Invoice, P2P and O2C

Oracle Tools: Oracle forms 12c, Reports 12c, Workflow Builder.

Database Tools: SQL* PLUS, Loader, SQL Navigator, Toad, SQL developer

BI Tools: OBIEE, XML BI Publishers, Business Objects XIR2, Info View, Crystal Reports 9/10/R11/XIR2.

ELT Tools: ODI, Informatica

RDBMS: Oracle8i/9i/10g/11g/12g, MS Access.

Languages: SQL/PL SQL, C, C++, and Java, JDBC, JSP, J2EE, Servlets.

Tool: & Utilities: TOAD 10.6, PVCS, Workflow, WinSCP.

Office Tools: MS Office Products.

WORK EXPERIENCE:

Confidential, ST. LOUIS, MO

Responsibilities:

• Worked with business users in 12i to Scale R12 upgrade project, which includes 12i analysis for inquiry to order, order to revenue and procure to fulfill processes in 12i.
• Performed systems analysis, design, implementation, maintenance, and enhancement for oracle finance, procurement, cash management, asset management.
• Interacted with end users and functional architects for mapping the legacy data to the Oracle tables.
• Developed a custom program to update the P2P Purchase Orders and PO Requisitions as soon as the sales order is updated.
• Defined Payment Options, Payment terms, Distribution Set, Payment Format, Internal Banks, Recurring Invoices, Prepayments, Expense Report Templates, Interest on Invoice report, Matching options, Adjustment of Prepayments in Payables.
• Defined Profile Class, Dunning letters, Collectors, Customers, Auto Accounting, Transaction Types, Transaction Sources, Payment methods, Receipt classes, Receipt sources, Payment Terms, Receivable Activities in Receivables
• Created custom responsibilities to which were attached specific menus, forms, and reports for restricted user access.
• Did the setup for Accrual options in Purchasing, and helped end-users to understand and run reports like Un-Invoiced Receipt Report (URR), Accrual and Accrual ‘Rebuild’ Reconciliation Reports and use of write-off transactions option.
• Developed and customized reports in AR, AP and PO like aging by amount report, accrual reconciliation report, purchasing activity register report, lot by expiration report, unpaid invoices report using reports 6i.
• Developed and customized standard Oracle reports like customer order acceptance report, bank account single daily report, balance report, AR cash receipt voucher report, payable invoice voucher report etc. using report builder 12c, and BI/XML publisher.
• Developed an outbound interface program to transfer invoice and GL extracts from Oracle.
• Designed integration of Oracle, Maximo and GIS asset information report, Maximo purchasing order details report.
• Performed routine fixes for P2P issues in setup of users, responsibilities, suppliers, requisitioning, purchase orders, receiving, invoicing, payments etc.
• During the post-implementation phase, resolved many issues in Fixed Assets like correcting depreciation amount for assets by running unplanned depreciation, transferring asset location, changing depreciation methods, adjusting assets units for invoice etc.
• Developed an outbound Interface to export GL data to third party systems, also inbound Interfaces to import into GL by populating GL INTERFACE table.
• Worked on errors faced in GL cross validation rules used in requisition account generator validation process.
• Created and used stored procedures, packages, cursors and functions to do the validations on the legacy data, created indexes to enhance the performance of the application.
• Worked on conversion of journal entries from old set of books to new set of books.
• Created staging tables to load the records and uploaded the flat files using SQL*loader.
• Configured concurrent executable, concurrent programs, request sets, request groups, functions, menus, sub-menus, and custom responsibilities.
• Developed custom AR interface program which validates and modifies data in the interface tables to update sales order based data in AR interface tables.
• Developed and customized various custom reports like PO requisition details report, PO report by buyer, open receipts report and PO unsourced requisitions report in reports 10g builder.
• Designed and developed fixed assets conversion by running mass additions concurrent program to transfer the data from interface to base tables in fixed assets (FA).
• Involved in the user acceptance testing and post production support.
• Created and customized reports in AP, AR, FA and credit & collections and GL using reports 10g.
• Used FND LOAD utility to migrate responsibility, request sets, concurrent programs, value sets, concurrent managers, context-sensitive DFF, profile options, form personalization’s etc.
• Developed interface program to close old Purchase Orders in the ERP system.
• Defined payment terms, locations, and Invoice approvals and setting up account information in Oracle financials AR.
• Maintained all projects documentation following MSD standard and program version control. This includes weekly status reporting, service request management, change management, incident management, problem management, project management and knowledge management.
• Customized requisition approval and PO approval workflow for procurement.

Environment: Oracle EBS 12i & R12 (GL, INV, AP, AR, CE, PO, FA), OBIEE, PLSQL, TOAD, XML BI Publisher, Unix Shell Script, Report builder(rdf), Oracle 10g, Reports 10g .

Confidential

Responsibilities:

• Involved in planning and implementing data conversion methodology and modified the data collection process.
• Responsible for support activities on an on-demand basis for both custom applications and Oracle Applications
• Worked on AR, AP, GL, PO to maintain consistency between legacy system and Oracle Apps. The interface components include 'Journal Import', 'Payables Invoice Import', 'AR Invoice Import', 'PO Outbound interface for vendors', 'Outbound interface for Customers' etc.
• Designed and customized custom Forms using Oracle Forms 9i
• Developed custom reports using Report 10g and customized seeded reports.
• Wrote SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Customized standard purchase order request form for output communication and created Bursting file and RTF template to generate XML report.
• Designed and Developed PL/SQL Packages to import AR Invoices and AR Receipts legacy information into Oracle.
• Wrote procedures and database triggers for the validation of input data and to implement business rules.
• Involved in the complete order-to-cash and procure -to-pay cycle.
• Created XML Publisher reports and using various templates to publish the reports as per user requirements.
• Worked on check printing, AP cleared checks, Invoice Aging Reports for Payables to accomplish customization according to business requirements.
• Customized the Oracle forms like, account receivables, payment transactions, scheduled payments and various other forms using custom.pll, as per the client requirements.

Environment: Oracle Financial 11.5.10, OBIEE, PL/SQL, TOAD, XML BI Publisher, Unix Shell Script, Report builder(rdf), Oracle 10g, Reports 10g,Forms 10g .

Confidential

Responsibilities:

• Developed PL/SQL packages, procedures and functions for validation of the invoices and payment information from the legacy system to import into Oracle application.
• Designed and developed PL/SQL packages to import AR invoices and AR receipts legacy information into Oracle.
• Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL * loader.
• Wrote procedures and database triggers for the validation of input data and to implement business rules.
• Used exception handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 10g, SQL, PL/SQL, SQL*Plus, TOAD, MS office Products.

Confidential

Responsibilities:

• Gathered requirements for reports to support reporting needs and report requirements for standard reports from the users.
• Identified the tables to be used and all possible relation between the tables to build the universes.
• Involved in the development of reports by using BO and Oracle 9i as database.
• Generated and published several reports in Info view.
• Developed drill down reports for in-depth analysis.
• Organized data in the reports by using filters, sorting, ranking and highlighted data with alert.
• Created complex reports using user defined function and condition objects.
• Improved reports response time by tuning business object queries.
• Experienced in tuning complex SQL, worked with DBA to create aggregate tables, indexes to speed up query time, scheduled client report.
• Scheduled reports based on specific time, events, and calendars in various formats such as PDF.
• Involved in migration from existing 8.5 reports to BO XI R2.

Environment: Business Objects XI-R2, import wizard, report conversion tool, Info View, Crystal reports XI-R2, Oracle 9i, PL/SQL, toad, window 2003 server.

Confidential

Responsibilities:

• Developed the UI using JSPs, JavaScript and CSS and Implemented the business logic using java classes. Integrated with exchange server to confirm acceptance or rejection.
• Created the service layer using JDBC for database, JNDI. And deployed on JBOSS.
• Performed unit testing manually and using JUnits.

Environment: JSP, JAVA Scripts, CSS JAVA’s JBoss web applications, JDBC, Struts, Servlets, PVCS, Ant, Builder Shell scripting, Oracle 9i JUnit.