SUMMARY:

• Worked on system with 7 years of experience in focusing on technical and functional aspects of Oracle applications R12.
• Study, Design, Development and Post implementation maintenance and support of Oracle Applications E - Business Suite.
• Worked on OLFM, full life cycle implementation of Order-To-Cash (O2C), Procure-To-Pay (P2P) and have good understanding of Quote-To-Cash (Q2C) life cycles .
• Experience in Oracle Application modules (OM, INV, PO, AP, AR, GL, FA, OLFM and OTL).
• Experience in Oracle HR and Payroll. Involved in the Conversion of HRMS Data migration and Developed various reports as per the client requirement in Fusion Application.
• Technically proficient in development of RICE components (Reports, Interfaces, Conversions and Enhancements) in Oracle Applications.
• Involved in Implementations, Version Upgrades, Enhancements, Data Conversions and Operating Unit Divestiture projects with post Go-Live, production support capabilities.
• Expertise in working with end-users for support, troubleshooting and giving effective & efficient resolutions for the technical issues.
• Knowledge and Experience of Trading Community Architecture.
• Good hands on experience in System Administration and Oracle Application Object Library (AOL) concepts like Application Users setup, defining Responsibilities, Value sets, flex fields, registering Menus, forms, Reports, Concurrent programs.
• Involved in preparing AIM documents (MD50, MD70, CV40, CV60, BR100) during development and support. Worked developing Conversions and Interfaces using various standard and custom APIs.
• Experience in planning, testing for upgrades, preparation of test plans, test scripts, test cases, training the end users in testing, identification of super users for testing.
• Experience in developing, customizing, extending and personalizing web pages using Oracle Application Framework.
• Excellent knowledge on Functional Analysis and implementation, Techno/Functional analysis on RICE components (Reports, Interfaces, Conversions and Enhancements) in Oracle Applications.
• Well versed with Oracle Databases 8i/9i/10g/11g and have experience using Oracle Forms, Reports, Discoverer and BI XML Publisher.
• Experience with writing SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populate the Staging tables.
• Experience with writing scripts for creating tables, Indexes, Grants and Synonyms and made modifications for the existing tables as per business logic.
• Having hands on experience on Form Personalization and Alerts.
• Experience on disable fields and calling Reports through Form Personalization.
• Proficient using UNIX command and Shell Scripting.

TECHNICAL SKILLS:

ERP: OLFM, Order Management(OM), Inventory(INV), Purchase Order(PO), Requisitions(REQ), Account Payables(AP), Iprpocurement, Account Receivables(AR), Cash Management(CM), Fixed Assets(FA), General Ledger(GL), Approval Management Engine(AME) and Service Contracts(OKS).

Operating Systems: Windows 7/Vista/XP/2000/98/NT, UNIX and LINUX.

Database: Oracle 8i/9i/10g/11g

Developer Tools: Toad, SQL Developer, PL-SQL Developer and Eclipse.

Oracle Tools: Oracle Forms builder 6i/9i/10g, Oracle Reports builder 6i/9i/10g, Discoverer 10g/4i, Oracle workflow builder 2.6, Oracle XML publisher.

Utilities: SQL*Plus, SQL*Loader and Data Loader

PROFESSIONAL EXPERIENCE:

Techno Functional Consultant

Confidential, San Francisco, California

Responsibilities:

• Involved in customer creation Interface to load the customer data from Sales Force to Oracle application and verify the data sync in both systems.
• Over a life of asset, there is a need to change the ownership of assets from one fund to another. Worked on developing a interface in OLFM module to create a new funds which requires assets to be moved from existing legal entities to a new issuer legal entity.
• Involved in Purchase Order, Account Payables,Iprocurement, General Ledger, OLFM(Oracle Lease and Finance Management) and FINANCIAL modules.
• Worked on enhancement of the Customer Interface which overcomes the address validation failures for project creation.
• Supporting Billing Process on daily basis, This process will generate AR Invoice extract and Send the invoice copy to Customer .
• Working on Support tickets related to the Purchase Order, Account Payables,Iprocurement, General Ledger, OLFM(Oracle Lease and Finance Management) on Daily basis based on the priority.
• Support for customer service transfer failure issues on daily basis.
• Involved in the enhancement requests of Oracle 12.1.3 application instance.
• Worked closely with the client Business team to design custom coding standard for the new implementation.
• Worked with DBA team to implement the SOA Annotations code deployment process and releases using Remedy Force & JIRA ticketing system.
• Created custom AR ADI template to upload invoice transactions and credit memos.
• Implemented NACHA/ACH payment with new bank vendor (Silicon Valley Bank). Created new APcheck stub and payment.
• Tuned several reports for performance related issues.
• Implemented Positive Pay with new bank vendor.
• Developed an Interface to SFTP the AR Invoice to RevSpring portal to send the reports to customers.
• Worked with the users in resolving day-to-day production issues.
• Knowledge of using Remedy Force & JIRA ticketing systems for tracking the enterprise level and department level tasks.
• Experience gained in code check-outs/check-ins using GITHUB.
• Deploy the objects into UAT for testing through FND LOAD.
• Writing/managing concurrent requests programs.
• Customized Standard Reports.
• Developed Customer Interface.
• Fixing the Issues in Discoverer Reports in various Modules.
• Developed various reports.
• Developed Fixed Assets Register Report
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements.

Environment: Oracle Applications R12.1.3 (INV, PO, AP, OM, AR and OLFM), Oracle 10g and 11g, SQL, PLSQL, D2K, Toad, SQL Developer, SQL*Plus, XML Developer, Developer 2000(Reports 10g), UNIX, WINSCP, Putty, Windows NT, Windows 2000, Windows 7 and Microsoft Office .

Technical Consultant and

Confidential

Responsibilities:

• Developed HCM Work list Details Report in Fusion Cloud .
• Developed Staff Distribution Report in Fusion Cloud.
• Developed Users and Roles Report in Fusion Cloud.
• Involved in the Conversion of HRMS Data migration in Fusion Cloud.

Techno Functional Consultant

Confidential, Newark, California

Responsibilities:

• Developed Customer Interface Program to import the data from existing Confidential Legacy system to Oracle Database with Error and Success reports.
• Developed Employee Interface to Load the Employee and assignments.
• Used API OE ORDER PUB for importing the Sales Order information into Oracle base tables.
• Tested and fixed the bugs in existing process.
• Developed Sales Order Acknowledgement report (Which Gives Sales Information and sends the output to customer Through XML Bursting), Developed Fixed Asset Register Report, Fixed Asset Projection Report, Customized Aging 7 Buckets Report, Supplier Payment Check Format, Supplier Payment EFT Format, Service Contract Summary Report, AP Expense Report, AR Invoice Print Report and Invoice on Hold Report
• Customized the many forms using forms personalization.
• Customized various Oracle Applications Reports in various modules to accommodate users’ requests.
• Assisted team to prepare technical documentations and involved in technical design review meetings to build the technical solutions.
• Loaded the vendor’s information from legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Implemented Employee Data Interface from Workday to Oracle HRMS.
• Update Employee Assignments by using API
• Developed Timecard Upload Interface from Salesforce to Oracle.
• Developed a Outbound Interface process from OTL to ADP .
• Developed an Oracle Alert which will trigger on the event of any approved timecard is modified. The alert will fire when the changes(Reduce, increase, transfer hours from) are saved by the user.
• Developed Various reports in HRMS Module like below.