SUMMARY:

• Over 10 years of Experience in Oracle Applications EBS(11i/R12) E - Business Suite Modules this includes Oracle Financial Modules (GL,AP,AR), Manufacturing& Distribution Modules (PO,OM and INV), Service Contracts,InstallBase,Advance Pricing and Procurement Contracts and System Administration.
• Extensive experience in Order-to-Cash, HRMS and Procure-to-Pay Business flows of Oracle Applications 11i/12i.
• Extensive experience in Financials, SCM and CRM modules of Oracle Applications 11i/12i.
• Expertise in Reports, Interfaces, Conversions, and Extensions (RICE) and ability to work in most of the Oracle Application modules.
• Experience in Migration of data, Validation of data and Loading data using SQL*Loader from legacy system to Oracle Applications.
• Extensive Knowledge in Creating Procedures, Packages, Functions using SQL and PL/SQL.
• Strong programming experience in using Front-end tools like Report 6i/9i, Discoverer4i/10g, XML publisher, Forms 6i/9i, PL/SQL and TOAD and OAF personalizations
• Perspi Confidential ty in System Administrator activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, profile options as per the requirement
• Having good knowledge in Application Implementation Methodology (AIM).
• Familiarity in developing Project related design documents like MD70, MD50, CV60, MD120, and TE20.
• Strong Communication, Presentation and Analytical Skills. Proven Skills as an efficient Team Member in System Analysis, Designing, Development, Customization, Migration and Documentation.
• Experience in writing Unit test plans and Unit testing.
• Ability to create detailed technical design, code, test, debugs, document, and maintain applications required
• Worked directly with end users and other developers to define requirements, review design, develop and test assigned components
• Extensively worked on ETL extractions and SOAP service to call web services.
• A highly motivated, energetic individual and a Consummate Team Player with ability to lead a team by example and motivate them to achieve desired objectives

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications EBS(11i /R12).

Operating Systems: UNIX, Windows, Confidential Solaris.

Languages: SQL, PL/SQL, C, Shell Scripts and OAF

RDBMS: Oracle 8i/9i/10g.

Development Tools: Oracle Reports builder 6i/10g, Discoverer4i/10g, Form Builder, BI publisher.

Other Software: SQL*Loader, MSOffice, TOAD, Winscp, Putty, PPM, Perforce, SVN, SCM/CCM, OAF, Tracker, bit bucket, JIRA

PROFESSIONAL EXPERIENCE:

Confidential

Oracle apps Developer

Responsibilities:

• Developed new report Integrated Payroll Benefit Issuance Detail Claiming Report using BI publisher
• Developed MED weekly Alert Report detail report by using BI Publisher.
• Extensively worked on project documents like CV60, Use cases, MD70 and TE20's.
• Solved day to day techno functional issues in AP, AR modules.
• Worked on employee conversions in HRMS
• Worked on Integrated payroll with HRMS adhoc reports using BI Publisher.
• Worked on employed contacts conversion in HRMS
• Resolving Functional hurdles for the smooth functioning of Technical Developers wise Setup and Test

Environment: Oracle Applications EBS 11i/12i, AP, AR, GL,HRMS, TCA, Pl/SQL, SQL*Plus, SQL*Loader, SCM/CCMBI Publisher, spring tool suite, JIRA, BitBucket

Confidential

Oracle apps Techno-Functional Consultant

Responsibilities:

• Worked on various conversions activities as apart of implementation, conversions developed are Customer Conversion, Supplier conversion and Invoices conversion
• Designed COA structure as per SIGMA accounting pattern.
• Set up the COA structure and Periods as per the calendar.
• Developed Outbound Interfaces for GAX9 R and JV9 XML Payments.
• Prepared the Use cases-DSDD and provided to the state Users for CQ’s
• Extensively worked in designing project specific documents like CV60’s, MD70’s, MD120’s, TE20’s asPer the requirement using functional design documents (FDD).
• Supporting to ongoing Issues in Operations project.
• Resolving Functional hurdles for the smooth functioning of Technical Developers wise Setup and TestScenarios through front end.
• Worked on Sigma Changes in all impacted interfaces.
• Worked in cloud Medicaid project which is integrated with oracle cloud service.
• Worked on Cash receipts processes and developed cash activity reports
• Involved in designing configuration documents, test scripts and also assisted users in User Acceptance Testing (UAT).
• Worked on warrant reconciliation process and developed the report by using XML Publisher
• Solved day-to-day techno functional issues.
• Generated the Payment cycle reports for each provider by using XML Publisher
• Worked on OAF personalization’s on supplier page and Customer page

Environment: Oracle Applications EBS 11i/12i, AP, AR, GL, TCA, Pl/SQL, SQL*Plus, SQL*Loader, Jira, Stash, OAF, Oracle applications Cloud Integration

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Involved in the development, updating and monitoring of business and action plans in Order to cash modules like OM, AR and Service contracts.
• Resolving Functional hurdles for the smooth functioning of Technical Developers wise Setup and TestScenarios through front end.
• Developed new packages for service contract claim item entitlement checks.
• Developed new packages for equipment in force check.
• Experience delivering in an Agile environment, including discrete functional packages for incremental builds for custom packages and procedures
• Extensively worked in designing project specific documents like CV60’s, MD70’s, MD120’s, TE20’s as
• Per the requirement using functional design documents (FDD).
• Experience delivering in an agile environment, including discrete functional packages for incremental builds

Environment: Oracle Applications EBS 11i/12i, OM, Service Contracts, AR, AP, Install Base, Pl/SQL, SQL*Plus, SQL*Loader, Jira, Stash, BI Publisher

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Involved in the development, updating and monitoring of business and action plans in procure to pay modules
• Resolving Functional hurdles for the smooth functioning of Technical Developers wise Setup and TestScenarios through front end.
• Developed the POC’s on procurement contracts which are feasible for functional requirements.
• Developed new Packages for Contracts conversion from CMS to Oracle.
• Developed new Xml Report for Procurement Contract Risk Report and emailed with bursting conceptto the user.
• Developed new Xml Report for Financial Commitment Report and emailed with bursting concept tothe user.
• Developed new Xml Report for Expiring Contracts Report.
• Worked on adding custom fields in Procurement contract page by using OAF.
• Developed new Xml Report for Estimated Contract Value Against Actuals Report
• Developed Outbound interface for Oracle Project Commitments Outbound to Lucernex
• Developed Outbound interface for Oracle PA Actual Cost to Lucernex
• Played a critical role in developing the test scenarios for various Scenarios, functional testing, defectsfinding and testing/following up till resolution
• Worked on employee conversions in HRMS
• Extensively worked in designing project specific documents like CV60’s, MD70’s, MD120’s, TE20’s asPer the requirement using functional design documents (FDD).

Environment: Oracle Applications EBS 11i/12i, Procurement Contracts, HRMS,PA, AP, BI Publisher, Pl/SQL, SQL*Plus, SQL*Loader, Reports 10g, UNIX, PPM, SVN

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Understanding existing and new business system and developed the below components
• Involved in the development, updating and monitoring of business and action plans in Order-to-Cash modules
• Resolving Functional hurdles for the smooth functioning of Technical Developers wise Setup and Test Scenarios through front end.
• Involved in migration of upgrade objects to R12 Instance.
• Prepared Testing TE020 documents and migration scripts.
• Unit testing and system integration testing of the developed code.
• Developed new Packages for Start and Stop Time from Oracle to RDS.
• Developed new Packages for Customer Orders by Item by Day from Oracle to Food link system
• Developed new Packages for Inventory Adjustments from Outside Storage Facility from EDI to Oracle
• Developed the new form for pricing matrix Form.
• Developed new Packages for Expected PO’s to Outside Storage Selection Facility.
• Played a critical role in developing the test scenarios for various Scenarios, functional testing, defects finding and testing/following up till resolution
• Extensively worked in designing project specific documents like CV60’s, MD70’s, MD120’s, TE20’s as per the requirement using functional design documents (FDD).

Environment: Oracle Applications EBS 11i/12i, Modules (AP, GL, INV, PO), Pl/SQL, SQL*Plus, SQL*Loader, Reports 10g, BI Publisher, UNIX, Forms Builder 10g.

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Involved in end to end implementation of GAP-Vertex project moving entire Tax system from Tax ware to Vertex system.
• Extensively worked in designing Technical design documents (TDD) like MD70 as per the requirement using Functional design documents (FDD).
• Successfully developed a custom interface programs to load the data from a spread sheet into custom table which is based on a front end form which includes inserting, updating and deleting the valid data on the table making the job easy for users.
• Developed new Packages for Gap vertex tax audit analysis.
• Modify the code for the existing Tax effective components in procure to pay modules.
• Developed the new Financials Gap Vertex tax state detail report by using Discoverer 10g
• Developed the Financials new Gap Vertex tax Transaction Report by using Discoverer 10g
• Developed the Financials new Gap Vertex Tax Legal Entity Summary Report by using Discoverer10g
• Developed the Financials new GAP Vertex Division Detail Report
• Developed the SFTP shell scripts. Played Key role for Impact analysis of shell scripts for Re platform of application server
• Worked on developing several reports using Discoverer 10g and also trained the team to work on Discoverer reports
• Worked on uploading and downloading LDT’s for concurrent programs, value sets, and templates using fnd load command to migrate the data from once instance to other instance.
• Fully involved in assisting and coordinating with the offshore team members on the components developed by them.

Environment: Oracle Applications EBS11i/R12 General Ledger (GL), Account Receivables (AR), Account Payables (AP), Pl/SQL, SQL*Plus, SQL*Loader, Reports 10g, XML Publisher, UNIX, Windows XP.

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Developed New Xml Report for Delivery Note Report By using Report6i and BI Publisher in order management, shipping
• Developed New Xml Report for Shortage and Damage Report By using Report6i and BI Publisher
• Developed New Xml Report for Request For Quotation Report By using Report6i and BI Publisher
• Developed New Xml Report for Purchase Order Report By using Report6i and BI Publisher
• Developed New Xml Report for Total Sales Report By using Report6i and BI Publisher.
• Developed New Xml Report for Issued and Non Issued Order Report by using Report6i and BI Publisher.
• Completely involved in end to end implementation of Xml publisher for building More than 20 reports which Includes requirement gathering, developing and assisting users in testing the reports.
• Worked on uploading and downloading LDT’s for concurrent programs, value sets, and templates using fnd load command to migrate the data from once instance to other instance.
• Extensively worked in designing Functional design documents (FDD) and Technical design documents (TDD) like MD50 and MD70 as per the requirement using BR100 documents.
• Trained end users on the new developments and assisted them to perform User Acceptance Testing by describing step-by-step process to be followed to run oracle applications.

Environment: Oracle Applications EBS R12, Order Management (OM), Purchasing (PO), Inventory (INV), Pl/SQL, SQL*Plus, SQL*Loader, Reports 10g, XML Publisher, UNIX, Windows XP.

Confidential

Oracle apps Techno Functional Consultant

Responsibilities:

• Developed packages for Search IB Instance and Save Adjustments.
• Developed Packages for creation of Orders, Order Contracts, Order Contract Roles
• Developed Procedures for creation of Splitting and Termination of Ib’s
• Developed Procedures for Assigning Contract Groups to Contracts
• Developed Procedure for adding existing contract details to the service line based on contract number
• Developed the Eclipse Usage report by Using Oracle Discoverer 10g
• Developed the new report for contract renewal by Using Oracle Discoverer 10g
• Developed the new report the contract which were in the DPL hold by using discoverer 10g
• Responsible to migrate developed components from test instance to Production Instance
• Developed the new reports for Internal Fulfilment Report and by Internal Non-Fulfilment Report Using Oracle Discoverer 10g
• Developed the new report for Rule Engine Report by Using Oracle Discoverer 10g
• Extensively worked in designing Business requirement documents (BR100), Functional design documents (FDD) and Technical design documents (TDD) like MD50 and MD70 as per the requirement using BR100 documents.
• Involved in designing configuration documents, test scripts and also assisted users in User Acceptance Testing (UAT).

Environment: Oracle Applications EBS11i, Service Contracts (OKC), Install base (IB), Order Management (OM), Advance Pricing (QP), Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, Discoverer 10g, UNIX, Windows 7.

Confidential

Oracle apps Techno Functional Consultant

Responsibilities:

• Involved in the areas of testing and supporting the functional setups in Service Contracts, IB and as well as BOM and Inventory applications
• Monitoring and Rectifying the errors of Various inbound and out bound interfaces and resolving them to as easy to end user
• Solved day-to-day techno functional issues
• Support the client in troubleshooting functional issues on an ongoing basis
• Participating in Crisis Calls and Tech calls to resolve the issues on a priority basis
• Checking & validating the QA check package for contracts activation
• Working on pricing of items by using dynamic formulas as per the scenarios in Advanced Pricing.
• Fixing issues in Service Contracts related to Pricing, Service Availability & QA check
• Creating Child tickets and interacting with DBAs and end-users
• Participating in Knowledge Transfer Sessions
• Creating Bugster Entries and Raising GCN Entries
• Creating PRDB (Problem Resolution Database) Entries (i.e., Knowledge Management)
• Extensively involved in designing and developing (MD70) and (MD50) documents which is also used to train the end users regarding the business process.
• Involved in creating some front end forms as per the requirement.
• Trained Users on the new developments and assisted them to perform User Acceptance Testing by describing step-by-step process to be followed to run oracle applications.

Environment: Oracle Applications EBS 11i, Service Contracts (OKC), Install base (IB), Order Management (OM), Advance Pricing(QP), Inventory (INV),Service Requests, Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, Discoverer 10g, UNIX, Confidential Solaris OS,PRDB,GCN

Confidential

Oracle apps Technical Consultant

Responsibilities:

• Developed AP invoices conversion program, GL Import Interface and Closed/cancelled PO outbound interfaces
• Rejected/Return Quantity Vendor Report - This Report shows all the orders for which the received items are rejected by the Quality/Inspection team and show the Rejected/Returned Items with the days between to the Vendor.
• AP Cleared invoice report - This Report will show all the Payables cleared Invoices to be sorted by Invoice groups.
• Custom report to list PO-s waiting for Approval (related to PO Approvals) - This report lists all the purchase orders that are waiting for approval for given number of days.
• Purchasing Matching report - This report is developed to generate a report of all the purchase orders which are matching the match approvals like 2-way, 3- way, and 4-way.

Environment: Oracle Applications EBS 11i, Account Payables (AP), Inventory (INV), Purchasing (PO), Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, UNIX, Windows XP.