SUMMARY

• Highly experienced in the Financials domain with 8+ Years as Cloud technical consultant and Oracle EBS with extensive experience in full life cycle implementations, Support, upgrades and extensions of Oracle Technical Cloud ERP R12/R13 applications and Oracle EBS 11i/R12.
• Extensively worked on business process analysis, fit gap analysis, evaluation and integration of internal systems, configuration, testing, & On boarding users, production planning and support.
• Multiple project life cycles experience with Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Integration & User Acceptance Testing, cut off, Go - live and Post-Implementation Support.
• Experience in creating users, defining roles & responsibilities, value sets, Key Flex fields.
• Experienced team player with good communication, interpersonal, analytical, and problem-solving skills to take over any phase of the project.
• Expertise in Oracle Applications performing multiple implementations, Upgrade and Postproduction Support of Financials in Oracle Cloud.
• Extensive knowledge in providing solutions, designing, customization, implementation, configuration, thorough testing and documentation of Oracle Fusion Financials including General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management (CE), Sub Ledger Accounting (SLA(FAH)) Tax (Tax), Purchasing (PO), Cost Management and Security Console.
• Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring.
• Good knowledge on business process flows in the areas of Procure to Pay (P2P), Order to Cash (O2C) and Sub-Ledger Accounting (SLA).
• Experience in the Oracle File Based Data Import (FBDi) and Desktop Integration (ADFDi) feature to load the data.
• Creating SR’s with Oracle Technical Support, coordinating and following on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
• Excellent communication skills and leadership qualities with analytical problem-solving abilities including playing vital role in coordinating multiple business meetings and following up on open item.

TECHNICAL SKILLS:

Development Tools: Reports Builder 6i/9i/10g, Forms Builder 6i/9i/10g, OTBI, SQL Loader, TOAD, XML/BI Publisher, SQL Developer, PL/SQL Developer, Kintana, ServiceNow, Remedy, FileZilla, UTL FILE, Putty

Programming: SQL, PL/SQL, XML, HTML, JSON

Oracle Application Modules: Oracle Cloud R12/R13(18A), Oracle R12 (12.0.6, 12.1.3, 12.2.4), Oracle 11i (11.5.3/11.5.8/11.5.9/11.5.10 ) General Ledger (GL), Subledger Accounting (SLA), Oracle Purchasing (PO), Accounts Payables (AP), EBTax, Cash Management (CM), Fixed Assets, Accounts Receivables (AR), Order Management (OM), Sys Admin, AOL Modules and Alerts

Databases: Oracle 10g/9i

Packages: Microsoft Office

Operating systems: Linux, Mac OS, Windows 8/7/XP/2003

PROFESSIONAL EXPERIENCE:

Confidential, Texas

Oracle ERP Cloud Consultant

Responsibilities:

• Moved reports from one instance to another using Archive / Un Archive options.
• Responsible for various phases of software development including System Analysis, Design, Development, Integration Testing and Implementation.
• As an Oracle Cloud consultant, involved in Data conversions using FBDI (master data and Transactional Data) Templates and Rapid Implementation (Configuration data) Sheets with the ability to reconcile the data and correct it using ADFDI, handled multiple tasks, coordinated issues and delivering excellent results.
• Responsible for development of new reports, interfaces and customization of existing reports in various financial modules.
• Responsible for development of new & customization of SQL/ PLSQL packages apart from OTBI/BI/XML Publisher Reports and Bursting.
• Responsible for OracleERPCloudfinance reports interfaces and conversions across customers, suppliers, open AR transactions and fixed assets modules using Oracle FBDI and ADFDI templates.
• Responsible for System Integration Testing (SIT) and Mock Conversion Cycle processes in anOracleCloudenvironment.
• Responsible to support production systems included interaction with users, checking for the tickets on ServiceNow databases and resolving them.
• Followed by SDLC/Agile methodologies for development and deployment of applications.
• Responsible for understanding ofOracleEBS base tables, interface tables, APIs and OIC.
• Development of Cheque Print reports using Disbursement Payment File Formats for various Banks.
• Developed Custom Reports related to Finance modules (Payables, Receivable Module) using BI Analytics.
• Worked on Fusion Bursting.

Environment: Cloud ERP R12/R13, GL, AR, CM, AP, XML Publisher, BI/OTBI Reports, OIC.

Confidential, Austin, TX

Senior Oracle Application Technical Consultant

Responsibilities:

• Development of Cheque Print reports using Disbursement Payment File Formats for various Banks.
• Developed Custom Reports related to Finance module (Payables, Fixed Assets) using BI Analytics.
• Customized Asset Cost and Reserve Standard Reports as per client requirement.
• Responsible for creation and scheduling Oracle Cloud ESS Jobs and BIP Jobs, reconcile with source system data and present the results as per business requirements.
• Developed Apex Reports and linked those reports to SaaS.
• Responsible for System Integration Testing (SIT) and Mock Conversion Cycle processes in anOracleCloudenvironment.
• Created Sandbox to secure APEX Reports in SaaS.
• Developed Etext formats for Online Payments.
• Moved reports from one instance to another using Archive / Un Archive options.
• Customized Standard View Image Report from Bill
• Presentment folder based on client requirement.
• Developed OTBI Reports and Dashboards.
• Followed by SDLC/Agile methodologies for development and deployment of applications.

Environment: Cloud ERP R12/R13, GL, AR, CM, AP, XML Publisher, BI/OTBI Reports, OIC

Confidential, Texas

Oracle EBS Sr. Developer

Responsibilities:

• As an Oracle EBS consultant, involved in technical upgrade of Oracle EBS R12.2.6, a fully integrated financial solution comprised of EBS and PPS (Premium filing Systems), handled multiple tasks, coordinated issues management, and demonstrated leadership skills in building teams, managing expectations, and delivering excellent results.
• Developed Custom Finance Reports related to AP, AR, FA, GL as per client requirement using XML publisher.
• Developed custom Finance Reports using XML Bursting to send report outputs to provided emails.
• Responsible for development of new & customization of SQL/ PLSQL packages, procedures, functions, interfaces, conversions, and triggers as per business requirements.
• Responsible for creation of design specifications, development, and customization of RICEW components like Oracle Forms, Reports and XML/BI Publisher Reports.
• Involved in theanalysisof the assignedsupportticketsincluding replicating the issue, analyzing the custom processes/API’s/reports/forms and providing the bug fixes.
• Worked on development and customization of Oracle forms includes Template.fmb, Custom.pll, Personalization and Application Object Library (AOL) for Development.
• Involved in development of code, debugging, build issues and code moving into different environments along with establish time frame for all releases in an Oracle EBS Applications.
• Created Service Requests (SR) with Oracle Support, troubleshooting and fixing the bugs.
• Responsible to co-ordinate with Business Users, DBA’s, Unix Admin, Network Security team and third-party vendors to resolve the issues.
• Developed MD120 technical documentation for Oracle Forms, Reports and extensions.
• Responsible to execute Integration testing and Regression testing for all critical process transactions in Invoicing integration.

Environment: Oracle EBS Applications R12, Sys Admin AOL, GL, AR, AP, CM, SLA, FA, Oracle 10g PL/SQL, SQL Developer, SQL*Plus, FND, Toad, Reports 10g and Forms 10g.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• As a Oracle technical consultant, my responsibilities are providing data fix and break fix for the custom objects developed. Communicating with Oracle product support team and DBA team by creating TARs.
• My responsibilities include various activities such as Creating and Scheduling Concurrent Programs and Executables, Responsibility Creation, Menu, Sub-menus, Function Creation, Changing and setting Profile Options, Password Reset for development and test instances, Adding, and deleting printers, FTP destinations, Execution of Change Requests, Creating TAR’s (Technical Assistance Requests) and interacting with clients to resolve issues.
• Involved in converting legacy data into Oracle Application tables, developing Interfaces, developing and as per the requirement specification document provided by client.
• Involved in development of reports in Oracle apps environment using Reports 6i as per the requirement specification document provided by client.
• Involved in the developing, unit testing and review.
• Involved in the Requirement analysis, design, data mapping and client interaction.
• Developed Custom Finance XML 2nd method Reports related to AP, GL using XML publisher.
• Customized Standard Customer Aging 7 Buckets and Account Analysis reports based on client requirement.
• Handled following Data Migration Activity like Supplier Loading, Customer Loading, AP and AR Open Balances Loading.

Environment: Oracle EBS Applications R12, Sys Admin, AOL, AR, AP, PO, GL, Oracle 9i, 10g PL/SQL, SQL*Plus, SQL*Loader, SQL Developer, UTL FILE, ADF, Toad, Developer 2000 (Forms & Reports 9i) and XML Publisher.