SUMMARY

• 8+ years of IT experience as an Oracle Apps Techno Functional Consultant in Implementing Oracle Applications 11i/R12and related technologies Including Implementations, Upgrades, Data Conversions, Interfaces, and Customizations.
• Successfully completed 4 full life cycle implementations of Oracle Applications release R12 (12.1.3, R12.2, R12.2.2, R12.2.4, R12.2.5, R12.2.6) and 11i (11.5.8, 11.5.9, 11.5.10).
• Worked on different Modules in Oracle Applications (PO, AP, GL, AR, OM, FA and INV) well versed with AOL.
• Proficient in functional flow of Order to Cash (O2C) and Procure to Pay (P2P) andFixed Asset to GL and Account Generator Workflow.
• Experience in working with Standard and Custom Reports and developing the interfaces in GL, AR, PO and AP.
• Experience in the creation of Business to Business (B2B) and Business to Consumer (B2C) web applications utilizingoracle.
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions), CEMLI elements (Configurations/Customization, Extension, Modification, Localization, and Integration)of Oracle Applications 11.5.9/11.5.10 and Release 12 modules such as AP, AR, GL, PO.
• Expertise in Financial Services Data Foundation(FSD).
• Proficient in Risk and Fraud domain.
• Expertise in development tools such as Oracle Forms, Oracle Reports, PL/SQL, SQL*PLUS, UNIX Shell Scripts.
• Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports. Developed and executed test cases, test scripts. Involved in Functional, Performance and Regression testing.
• Proficient in PL/SQL programming, writing Stored Procedures, Functions, Packages and Database Triggers. Create reports include formatting optionssuch as Charting, Mapping, Grouping, Sorting,Alerting, Field highlighting, Drill - down, Parameter prompts.
• Generate financialreports, such as income statements and balance sheets, based upon data in GL usingFSG(Financial Statement Generator).
• Involved in Analytical Infrastructure, Oracle Web Logic, Data Integration.
• Expertise with all ODI tools - Topology, Security Manager, Designer and Operator.
• Involved in writing documents MD50, MD70, CV40, etc. using AIM (Application Implementation Methodology) and OUM (Oracle Unified Methodology).
• Expertise in Analytical infrastructure(AAI) and Data integration hub(DIH).
• Extensively used TCA (Trading Community Architecture) to create customdaers in AR.
• Proficient in Oracle Financial Services Analytical Applications(OFSAA).
• Expert in Requirement gathering, analysis, design, developing and Testing (CRP and UAT).

TECHNICAL SKILLS

ERP APPLICATIONS: Oracle Applications R12 (12.1.3/12.1.1 ) and 11i (11.5.10/11.0.3 ), AR, AP, GL, CE, FA, PA, OM, PO, INV

RDBMS: Oracle 12c, 11g, 10g, 9i/ 8i / 7.x, SQL Server

LANGUAGES: PL/SQL, SQL, C, C++, Java, VB, HTML, XMLXSLT,UNIX Shell Script

BUSINESS INTELLIGENCE: XML/BI Publisher, Discoverer Reports, Developer 10g, 6i Reports

TOOLS: TOAD, SQL Navigator, SQL Developer, SQL* Plus, Visual Source Safe 6.0, SQL*Loader, JDeveloper, ODI, Forms Builder, Reports Builder, Workflow Builder 2.6.3, Discoverer.

HARDWARE: AIX, Sun Solaris (SPARC 32-bit), Pentium M

OPERATING SYSTEM: UNIX, LINUX, Windows 95/98/2000/ XP/ NT/Windows 10Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Oracle Apps IT Consultant

Responsibilities:

• Developed and customized Financial Modules (GL, AR, AP, PO, OM), Interacted with end users to gather requirements and Draft specifications for development Phase.
• Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs.
• Handling daily tickets related to various user problems in AP, AR, AGIS, GL, CE, Projects modules
• Co-ordination with various thirdparty vendors during business impacting changes and deployments.
• Attending calls with the Business and Offshore team on daily basis for Requirement clarifications and delivery Issues.
• Worked on inbound interface for importing the sales invoices from different Project billing application into oracle application using the Auto Invoice Master Program in R12.
• Designed and developed staging tables, conversion routines, custom PL/SQL on AP, AR.
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
• Performed various Setups in Order Management(OM) and supported day to day business issues on EBS R12 and work with Business and IT to resolve issues and enhancements and R12 Implementation and Post-go-live production support.
• Log defects using JIRA application and communicate the defect status updates to the responsible analysis, implementation teams and also involved in filing bugs, verifying fixes, solved them using Jira.
• Developed UNIX scripts to load the external customer data coming from a legacy system into staging tables.
• CustomizedAR-CEBankReconciliationBatch Info Report.
• DevelopedAP Positive pay Extract Reporting Oracle Payables which will extract the Canadian transactions from source systems and sent to bank.
• DevelopedAP Check Printing Reportto produce check file in the Oracle Accounts Payables to complete the correct formatting for checks processed from Oracle payables through check printing software.
• Created Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL. Efficiently used Oracle utilities like SQL Loader, Export/Import in UNIX environment.
• Knowledgeable in the following areas: Order-to-cash, Oracle Order Management including pricing, Oracle Inventory, Purchasing and Oracle Costing Modules. Extremely familiar with all aspects related to the functional aspects and data structures of these applications
• Modified and updated existing custom forms to adapt to new database schema.
• Developed AP Remittance batch report using XML/BI Publisher. Created Data Definition Templates, rtf templates and split the xml file using bursting feature in XML Publisher reports.
• Developed Custom Reports for Billing History by Client, Invoices by Client Report and Projects NDR Report using Discoverer 10g.
• CreatedSQL scriptsand writtenProceduresusingPL/SQLto load data from flat files into new tables (using both UTL and SQL Loader - for different cases).
• Debugging the packages, functions, procedures and triggers.
• Tuning the SQL queries for performance improvement.
• Customized the Accounts Payable (AP) Vendor Entry Form as per business requirements.
• Design and developed an interface between Bank of America and (AR) Oracle Receivables for Cash Receipts (Auto Lockbox).
• Designed and developed Conversion scripts to convert data from 11.5.8 to 11.5.10 systems for AR Module.
• Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40) for importing Legacy Purchase Orders into Oracle Purchasing, Legacy (AP) Payable Invoices into Oracle Payables, Journal Imports Interface from external Payroll, Items into Inventory, from legacy system.
• Worked on Service Contracts for Recurring Billing and maintenance, Install Base, Warranties, lease and Customer Support.
• Wrote Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) for Supplier/Vendor conversion.
• Used standard Order Import to load the Open Orders from the interface tables to the standard OM tables.
• Created new concurrent request set and scheduled the Order Import interface program to run periodically
• Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40) and Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the AR invoice using Open interface tables in Account Receivables (AR)
• Designed and developed an interface between third party billing system (INTUIT) and Oracle Receivables (AR) to load external invoices data on daily basis. Used SQL*Loader for import INTUIT invoices into Staging tables, and developed PL/SQL API’s for complete validation of data and inserting into Interface tables.
• Developed various Custom reports, Customized existing reports according to the functional specifications including Packing Slip, Pick Slip, Daily Inventory Transactions Report, AP NACHA Payment Format Report, Invoice and Expense reports, AR Adjustments etc. using Reports 6i/9i.
• Define and generate Financial statements usingFSG
• As financial Super User, involved in fixing anyFSGrelated issues for printing or uploading
• Involved in Building Customizations and Enhancements using Reports and Forms
• Create custom Data Entry Screen to view serial number information, Inventory Manifest Information, Inventory Availability Form using Forms 6i
• Customized reports in AR such as: Customers Profile Report, Aging Report
• Registration of concurrent programs, defining value sets and parameters for customer reports specific to Applications

Confidential, Columbus, OH

Oracle Apps Techno Functional Consultant

Responsibilities:

• Studied existing system and developed strategies for conversion of Legacy system data into Oracle Applications R12 (12.1.3)
• Planning and performing the configuration, testing and documentation of the Oracle Accounts Receivable (AR) application version 12.1.3 after the reorganization of the company.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability
• Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.
• Designed, developed and documented the Custom Interfaces for AP modifications based on Business requirements when Project Accounting is installed
• Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report and consolidation journal report in General Ledger (GL).
• Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production.
• Involved in Analytical infrastructure(AAI)
• Worked on Data integration hub(DIH).
• Developed Staging Tables, Conversion Routines, and CustomPLSQL API to import.
• AR Invoices
• Customers, Parties, Party Sites, Party Accounts (TCA Architecture).
• Participated in the definition of Oracle lookups for SWIFT Auto-client Server
• Responsible for the Migration of code for other instances using version control software SVN and Kintana.
• Used Financial Services Data Foundation(FSD).
• Designed and developed Customer Statement Reports using XML Serialize API and BIPublisher.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Developedthe interface to integrate Oracle Projects with Oracle Loans.
• Involved in customization for Oracle Loans/Accounts Payables/Fixed Assets Module
• Responsible for performing the end to end testing of Advance Collections with AR and other related modules
• Worked onARinterfaces & discoverer reports of Disgorgements, Section 31, Host Pay and Outstanding Receivables.
• Customized AR-CE Bank Reconciliation Batch Info Report.
• Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances
• Handling daily tickets related to various user problems in AP, AR, GL, CE modules.
• Did SQL and PL/SQL programming for ODI.
• Performance tuned the ODI interfaces.
• Invoice, Customer Invoice, Bill of lading, Purchase order, Mailing Label.
• Developed Ad hoc Reports for clients.
• Customized seeded reports to XML Publisher Standards per the business Requirements.
• Developed Projects budgets, Projects Expenditures, Projects revenue and invoices, Purchasing views using Discoverer
• Modified the existing SQL reports to XML Publisher reports as per the requirements.
• Developed custom forms from TEMPLATE.fmb.
• Schedulingreportsto run automatically with the supportFSG.
• Extensively developed UNIX Shell scripts to transfer and archive account files.
• Developed a report usingXML Publisherof the search results (Order bookable SKU’s) from the Order Booking Validation report.
• Used Bursting technique to email theXML publisheroutput file.

Environment: Oracle 11i (11.5.10), R12 (12.1.3), SQL Plus 9.2.0.4.0, TOAD, FSGAP, AR, INV, PO, OM, PA, GL, CE, CM, Order to Cash(O2C), ODI, Windows XP, PL/SQL, Shell Script, Oracle Forms and Reports 6i, XML/BI Publisher.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in the up-gradation from Oracle 11i (11.5.8) to Oracle R12 (12.1.2).
• Understanding of EBS architecture and underlying tables / columns in Oracle EBS R12 (12.1.2).
• Designed and implemented custom Summary Billing Utility in AR with integration to Trading Community and Receivables.
• Prepared Technical Specification (MD70) documents and conversion mapping (CV40)documents, created Staging tables, conversion routines developed custom PL/SQL API’s to import
• Preparation of GL extract for the legal Audit purpose.
• MigratedGLandAPcustom interfaces and reports, during oracle financials upgrade project.
• Troubleshooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries
• Responsible for Journal Imports from all other modules like Accounts Payables (AP) and Account Receivables (AR) into General Ledger (GL )
• Analyse, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Worked on the Budget Upload Open Interface to load the data from legacy systems to the GL Budget Interface table using SQL*Loader.
• Designed, documented and developed Billing to GL Inbound Interface and validated the data before creating the journal entries.
• Developed UNIX Shell scripts for File Manipulation, Executing DB2 SQLs and archiving log files.
• Unit and Integration testing of Receivables, Payables, General Ledger, Cash Management and Assets
• Designed, wrote Functional (MD050), Technical (MD070) documents, developed custom PL/SQL API’s for interfaces
• Inbound Interface to load Journals from ADP into General Ledger (GL).
• Inbound interface with web based application to Customer Master to register prospective customers.
• Customized Requisition Approval workflow for iProcurement, Purchase Order Approval Workflow.
• Debugged workflow using workflow administrator to approve Requisitions, Purchase Orders.
• Involved in customization of several standard reports to serve important business processes very specific to the client using XML/BI Publisher. Such reports include Purchase Order Detail Report in PO, Invoice on hold report, Vendor, Payments, and analysis reports in AP, and also Customer, receipts, invoice, and adjustment reports in AR.
• Defined and generatedFSG's reportfor Balance Sheets Marquette where rollup groups are considered for aren't/child relationship.
• Prepare custom financial reports for month end MU process usingFSG
• Involved incustomizationof several standard reports to serve important business processes very specific to the client.
• Reports includedPurchase Order DetailReport inPO, Invoice on hold report Vendor, Payments, andanalysisreports inAP, and also Customer, Receipts, Invoice, and Adjustment reports in AR using Reports 10g.
• Involve Functional, Performance and Regression testing.
• Design and development of several PL/SQL packages, procedures and functions that were used inCustom Reportsand Formsdevelopment.
• As per the company requirements, created and implemented XML/BI Publisher reports for the different products like PO, AP and GL.
• Developed approval rules based on invoice amount for the following transaction type Payables Invoice Approval using Oracle Approval Management (AME) and configured action types and actions and set up the profile option to work for Payables only and also the required setup through Payables Options form
• Customized seeded reports such as Invoice print report, Commercial Invoice, Customer Invoice report, Print Selected Invoice, transaction detail report, Account Status report in AR.
• Provided on site solutions and resolved showstopper issues.
• Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports. Developed and executed test cases.
• Developed Reports in Billing and Costing like Customized sales summary report to evaluate the performance of the ware, Billing Review report and Detail Expenses report.

Environment: Oracle EBS 11i (11.5.8), R12 (12.1.2), SQL Plus 9.2.0.4.0, TOAD, FSG,AP, AR, PA, GL, CM, FA, Project Accounting (PA), AME, Pentium M’, Windows XP, AIX, PL/SQL, Shell Script, AWK Scripts, Oracle Forms and Reports 6i, SOA, JDeveloper, PVCS, XML/BI Publisher, SFTP,SSH.

Confidential

Oracle Apps Developer

Responsibilities:

• Involved in the up-gradation from Oracle 11i (11.5.10) to Oracle R12 (12.1.1).
• Involved as a team member by interacting with the client to understand user requirements, preparing the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from legacy system into open interface tables.
• Analysis and Design strategy for conversion of Legacy Data into Oracle 11i Project Accounting module.
• Worked on journal import interface program to import journal data from legacy system into GL Base tables.
• Designed and Developed an Outbound Interface of GL Balances from Oracle GL to Assurant System as per the complex extract requirement depending on the flex field segment hierarchy.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to validate and import the Suppliers, Supplier Sites, Open Payable Invoices (AP).
• Designed, documented (Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40) and developed an Interface between Third party Payroll System Ceredian and General Ledger Interface to import monthly Journal entries. Developed staging tables, Custom PL/SQL API to validate and load data into Interface table.
• Integrated Kofax software system to read scanned pdf, fax pdf, email pdf invoice files and loaded them into staging tables and sub-sequently loaded into AP Invoice Interface tables and run Payables Invoice Import program to create AP Invoices.
• Performance tuned the ODI interfaces.
• Involved in customization of several standard reports to serve important business processes very specific to the client. Such reports include Purchase Order Detail Report in PO, Invoice on hold report, Vendor, Payments, and analysis reports in AP, and also Customer, receipts, invoice, and adjustment reports in AR.
• Involved in creating business areas, user views, custom folders and joins for reporting using Oracle Discoverer 4i in Administrative edition as per the user requirements.
• Debug and resolve andFinancial Statement Generator (FSG)reporting problems for month end purpose
• Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports. Developed and executed test cases. Involved in Functional, Performance and Regression testing

Environment: Oracle EBS 11i (11.5.10), R12 (12.1.1), SQL Plus 9.2.0.4.0, TOAD, FSG report, AP, AR, PO, OM, INV, GL, FA, Project Accounting (PA), Oracle Grants,Windows XP, AIX, PL/SQL, Shell Script, Oracle Forms and Reports 6i, Visio 2003, JDeveloper, SFTP,SSH, PVCS, Oracle 9i (9.2.0.5.0), Discoverer 3i/ 4i/ 9i