Oracle Project

Experience Summary:

Working with Wipro Technologies Ltd from 8 Years and 2 Months. Currently working as Programmer Analyst for R12 Oracle support project.

Having functional knowledge in Finance modules.

Experience in modules like General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), iExpense, Cash management, Payments, Order Purchasing (PO), Inventory (INV),Sub Ledger Accounting (SLA), Service Contracts, procurement Contracts and Trading Community Architecture (TCA).

Experience in working on Conversions, Interfaces, Extensions, Oracle reports, Oracle Forms, BI Publisher Reports.

Work experience in implementations, upgrades and support projects.

Involved in cut-over activities for the implementation and upgrade projects.

Developed custom objects including Oracle forms, Oracle reports, Interfaces, custom APIs and BI Publisher Reports.

Developed interface programs to build integrations between Oracle and third party systems based on customer needs from EBS end.

Developed and customized Oracle seeded reports as well as created several custom objects including custom API’s.

Experience in medium level customizations using OAF (like ex enabling the fields or disabling the fields in the VO).

Worked on Performance tuning for the technical objects to improve the program performance using the advanced PLSQL concepts.

Having hands on experience on PLSQL advanced Concepts.

Experience in using WEBADI features to build custom interfaces likes Items, AP invoices etc

Developed the concurrent programs for Creating Categories, updating the categories and creating cross references for Items in EBS using API’s.

Extensively worked on the Inbound Interfaces and Outbound Interfaces (using FTP and SFTP Unix shell scripting and dblinks).

Experience in latest Release 12 modules like Sub Ledger Accounting and latest features like Multi Org Access Control Features.

Experience in Oracle EBS Applications across Financials, Supply Chain Management (SCM) and Manufacturing modules.

Experience in using version control tools like SVN.

Experience in using migration tools like Kintana to move the code from one instance to another instance.

Trained and gained knowledge on Finance cloud ERP.

Extensive work experience in end-to-end conversion strategy.

Exceptional ability to research, analyze and translate complex technical information to End-users at all levels.

Proactive problem solver, implementing solutions with careful consideration to the bottom line, long-range goals, feasibility, and ease of use.

Experience on Cloud BIP Finance reports.

Currently working for Cloud EBS project as current EBS R12.1.3 system is going to move in cloud.

Highest Education:

Degree/Qualification

Institution Name

Year Passed Out

MS -Software Engineering

Birla Institute of Technology and Sciences

2016

Technical Expertise:

E-Business Suite:

General Ledger(GL), Accounts Receivables(AR), Accounts Payables(AP), Sub Ledger Accounting (SLA) Inventory(INV), Purchasing(PO), Bill of Materials(BOM), Work in Process(WIP) Cash Management(CM), Order Management(OM), Oracle Pricing(QP) in Oracle Applications Release 11i, 12.1.1 and 12.1.3.

Trained in Oracle Fusion cloud in finance.

Tools:

Oracle Developer Suite 10g (Forms and Reports), JDeveloper, SQL*Loader, PVCS, Kintana, Oracle Workflow, Informatica, Datawarehouse Administration Console(DAC), Oracle Application Framework(OAF).

Languages:

PL/SQL, Shell Programming, XML, Java

Project Details:

06-SEP-2018-Till Date

Environment: Oracle EBS R12.1.3

Position – Senior Project Engineer

Project Type: R12 Support, Enhancement Project and Data Strategy.

In Parallel, played different roles in three assignments assigned.

R12 Support:

Responsibilities and experience:

Support Williams ERP system across EBS modules mainly in Financial modules like Accounts Payable (AP), General Ledger (GL), Concur, Account Receivables (AR), Application Object Library (AOL) and Concurrent Managers.

Primary responsible in handling Incidents, enhancements, user requests.

Working on Enhancements (Interfaces) on finance modules like Accounts payables, Accounts Receivables, General ledger purchasing and Inventory module.

Working on form personalization and customizations.

Working with Rimini Street case for data fixes for finance modules like Account payables (AP) and Purchasing (PO).

Working on User requests for solving the issues in production and providing the appropriate solution in the timely manner.

Developing the components on Interfaces or conversions packages on finance modules.

Working on BI Publisher Reports for Custom Reports as per the user Requests.

Working on Performance tuning for few Concurrent Programs using PL SQL advanced Concepts and using Explain Plan, TKPROF, SQL Trace, Hints, and Indexes.

Involving in unit testing, System integration testing and user acceptance testing for the change requests and migrating the same to production.

Preparing the technical documents and functional documents for the developed change requests as well as for the new developments.

Expertise in Accounts payable and Accounts Receivables module EBS flow.

Implementing the new integrations in current on prem system wherever needed so that it requires minimal changes when Williams move to cloud.

Identifying root cause from technical perspective for any existing or new issues.

Preparing Technical Design Document (MD070), Functional Design Document (MD050), Conversion Document (CV060), Technical Test Document (MD0120) and Set up document (BR100).

Performing different activities in Procure to Pay (P2P) and Order to Cash (O2C) cycles.

Producing Unit Test plans, document test results, create test data and test environments for unit testing.

Assisting DBA team in functional modules for major upgrades.

Providing GAP analysis and technical designs.

Tuning the existing oracle jobs for better performance using tools like Explain Plan, TKPROF, SQL Trace, Hints, and Indexes.

Using the third party tools like Oracle Developer Suite 10g (Forms and Reports), JDeveloper, SQL*Loader, SVN, Oracle Workflow, Oracle Application Framework (OAF).

Developing Unix Shell Scripting jobs to support Oracle Applications.

Assist in reviewing the current technical architecture, including design patterns and development methodologies.

Provide month close and peak season support for Oracle Applications.

Identifying the scope of automations to ease the business process.

Analyzing and Automating recurring issues.

Resolve service requests and problem tickets within SLA.

Working closely with onsite and offshore team for deliverables.

Providing technical design documents for existing Oracle on prem system for blue skies\Cloud Project.

Working on OTBI reports in clouds.

Enhancement Project:

Responsibilities and experience:

• Streamlining and fixing PO, Invoice Interface issues.

• Worked on new custom webadi for AR invoice load.

• Worked on Medium-level customizations on GL journal webadi.

- Checking for failures and fixing critical programs and interfaces.

- Identifying root cause from technical perspective for any existing or new issues with functional team.

- Working on reports with layout issues or small enhancements.

- Forms personalization has to achieve any business requirement.

- Working on priority issues during Month End activities.

Data Strategy:

Responsibilities and experience:

Williams’s business wants to use a new set of O&M (Operational and Management) and G&A (General and Administrative) expense Accounts and Sub-accounts values across the organization. As part of phase-1, the same solution implemented only for Access group of companies, as part of phase-2 extended to implement same solution across all existing Williams’s companies. As a technical Consultant, worked on below stuff:

-Analysis on existing technical objects which are impacted with “Data Strategy” changes.

-Delivery in modified technical objects which are impacted after tested the same with new GL Accounts.

-Built a tool based on data strategy rules to provide new GL Account for the old GL account entered based on Data Strategy rules.

Finance charge project:

Responsibilities and experience:

Account Receivable finance charges are being calculated in the CGA application. Williams Planned to transition this functionality to Oracle.

- Developed an invoice and statement template to be more readable for reporting to the CGA finance charge invoice and statement template by using BI publisher.

-Created PLSQL script to update transaction types that are exempt from finance charge calculation.

-Created PLSQL script for update accounting on customer sites.

Mobichord:

Responsibilities and experience:

Williams needed an AP Excel Template to upload AT&T invoices via a new third party vendor named Mobichord (Service Now application).

-Developed a new interface with spreadsheet template and written a PLSQL complex logic for employee hierarchy to assign the expense accounts on AT&T Invoices.

-And added reporting mechanism for notifications to users on the failures and success.

APR 2017-SEP2018

Environment: Oracle EBS 11.5.10, Oracle EBS R12.1.3

Position – Technical Consultant

Project Type – R12 Upgrade

Responsibilities and experience:

• Provided scope and technical feasibility to functional requirements in requirement and design phase.

• Worked on retro fitment of custom objects as per Oracle Release 12.1.3.

• Provided solution to implement MOAC as per customer’s business requirement.

• Provided solutions and technical feasibility around SLA for objects impacted.

• Worked on interfaces like AR invoice, Auto lockbox, AP invoices and GL journals.

• Worked on payment interfaces like positive pay, bank payments etc involving security features like exchange of security keys with banks etc.

• Worked on cash reconciliation interface.

• Provided complete solution around replacing custom EU system (Legacy customer) with TCA.

• Worked on interfaces, conversions and reports in GL, AP and AR.

• Worked on extensions in I-Expense Modules using OAF and workflows.

• Modified multiple workflows and conversions on contracts modules.

• Worked on pre upgrade and post upgrade cutover activities.

• Involved in user sessions and end user trainings.

• Involved in the instance management plan to support the timely delivery of ERP instances

• Worked on major interfaces like AP Invoice, AR Invoice, GL Journals, AR lockbox, Bank Statement Load, HR employee and location, PO, Requisition interfaces etc.

• Worked on Supplier site and customer conversions.

DEC 2014-APR2017

Environment: Oracle EBS Applications from R11.5.10.2 to R12.1.3

Position – Technical Consultant, Re-implementation Project

Responsibilities and experience:

This is an implementation project involving RICE components design and build.

• Have worked extensively in extensions and reports.

• Worked on huge form customizations.

• Worked on complex reports customizations.

• Worked on multiple reports using BI Publisher.

• Worked on customization of check printing report.

Awards:

Excellence Award Winner at Wipro Oracle Practice Level.

Achieved Appreciation award for Williams R12 Upgrade and Support project.

Certificate of Appreciation Award for contributing to Wipro knowledge management.

Employment History:

Company Name

Designation

Start date – End date

Wipro Technologies

Programmer Analyst

JUN 2012-Till Date

Contact this candidate