Resume

Sign in

Oracle Apps Techno Functional Consultant - Finance

Location:
Miami, Florida, United States
Posted:
February 28, 2018

Contact this candidate

Resume:

Profile

Overall ** Years of IT experience worked on various applications.

About 11 years of Techno-Functional expertise in Oracle Applications Development with extensive hands-on skills in Implementation and Enhancement projects of Oracle EBS 11i / R12 applications from end to end deployment and testing.

Sound knowledge of O2C and P2P cycles with data flows.

Proficiency in Financials (AP, AR & GL), Order Management (OM), Purchasing (PO) and Inventory (INV).

Expertise in Financial domain and laying out Blue prints for complex EBS solutions.

Over 4 years of experience in effectively managing remote and local development team and providing leadership and direction with effective interpersonal and team building skills.

Extensively worked on Interface/Conversion Programs to import data from various sources into Oracle Apps using PL/SQL, SQL*Loader, UTL file etc.

Extensive hands-on experience in Oracle PL/SQL – APIs, Packages, Procedures, Functions, Sequences and Collections.

Strong expertise in improving performance of the query and processes.

Hands-on experience on customization of Oracle Workflows as per client requirements

Strong expertise in Oracle Applications Framework (OAF) – building medium to complex pages from scratch and OAF customizations.

Expertise in Discoverer Report and XML Publisher Reports (BI Publisher) to build custom reports from scratch to provide solution as per business need.

Sound Knowledge in Oracle Forms to build and customize forms as per client requirement.

Sound Knowledge in Oracle Reports to build and customize reports as per business need.

Worked on Documentation using AIM methodology for Functional Design Documents (MD50), Technical Design Documents (MD70), Conversion Mappings (CV40), Conversion Test Plans (CV70), Testing Documents (TE020) and Release Document (MD120).

Worked on SVN, Kintana, JIRA, Mozart and WinCVS tool for versioning and migration.

Familiar with Agile Methodology to deliver story within Sprint.

Experience in interacting with client/business and building the business requirements. Proficient in analyzing and translating business requirements to technical requirements and architecture the solution.

Strong ability to collaborate and coordinate among all levels of organization in both business and IT with excellent results under tight deadlines.

Excellent in team collaboration, quick adaption and problem solving with good communication and interpersonal skills.

Proven ability to lead and manage multiple end-to-end project implementations.

Worked as lead solution architect across multiple projects.

Technology Skills

ERP Suite

Oracle Applications Release 11i, R12 with proficiency in Oracle Financial with Knowledge in SCM (OM and Inventory modules).

Modules

Oracle Applications Financials (AR, AP and GL), PO, iProcurement. iExpense and Supply Chain Management (SCM) with OM, Inventory (INV) with some exposure to BOM.

Languages

SQL, PL/SQL, XML Publisher, Unix Shell Scripting, Java

Databases

Oracle Database 9i/10G/11G

Application Tools/Technologies

Oracle Applications Framework (OAF), Forms 6i/10g, Reports 6i/10g, Oracle BI Publisher, Discoverer 9i/10g, Oracle Work Flow Builder, SQL* Plus, TOAD, SQL Developer and SOA

Operating System

Windows NT 4.0/95/98/2000/2003/2007, Unix

Professional Qualification

Masters in Computer Applications (MCA) from University of Rajasthan, India

2002 - 2006

Post-Graduation Diploma in Banking and Finance (PGDBF)

from Symbiosis Distance Learning Centre, Pune, India

2017

Employment Scan

Organization

From

To

Designation

IBM

Feb 2015

Till date

Senior System Analyst

Sunera Technologies

Jan 2014

Feb 2015

Associate Manager

Computer Science Corporation

May 2011

Jan 2014

Senior Software Engineer

Capgemini

May 2010

May 2011

Consultant (P3)

Oracle

May 2007

May 2010

Associate Consultant

NetSoft Computers

Jan 2006

May 2007

Software Developer

Key Projects

Organisation:

IBM, Doral, FL (From Feb-2017 to Till Now)

IBM, Pune, India (From Feb-2015 to Feb-2017)

Project Description:

Client – World Fuel Services, USA

Duration – Feb 2015 – Till Date

Environment – Oracle Apps 11.0.3 (Financial, OM, PO and INV)

Job Title – Development Lead

Project Type – Enhancement and Implementation

Brief Description of the Project:

This is enhancement project in financial domain to implement changes in the existing system for improvement of business processes.

Modules

Account Payables (AP), Account Receivables (AR), Purchasing (PO), Order Management (OM), Inventory (INV)

Tools & Utilities

Forms 6i, Reports 6i, Oracle BI Publisher, Oracle Applications Framework (OAF),SQL Developer, WinCVS, JIRA and Mozart

Responsibility

Analyse enhancement request of Invoicing (AR and AP) and Matching Application from business and provide technical solution.

Analyse impact of new enhancement on the other application and provide regression testing plans to make sure no breakdown in existing functionality.

Prepare build using PL/SQL, Oracle Reports, Forms and XML publisher as per technical solution.

Worked with offshore team to find any issues for deliverables and guide them to fix it.

Improve performance of slow process by tuning SQL queries.

Optimization and Performance tuning of the developed codes.

Involve in Code Review, Testing, and Effort estimation for the enhancement requests.

Mentor and monitor offshore team.

Worked with Oracle on SR.

Modified the custom form to handle the Auto Carrier Pay functionality.

Prepare Test document and migration of the code using WinCVS, Mozart and JIRA.

Worked with team member of the project to achieve common goal.

Involved in the Post Production support of the Edicom and Qantas Billing projects.

Projects

1) Edicom Mexico Invoicing and Payments

Performed setups in AR for Mexico Invoicing.

Prepared high level detail design document for Invoicing and Payments flow.

Worked with Mexico and Edicom team for the testing of Mexico Invoicing and Payments to make sure flow is working without any issues.

Collaborate with SOA team to send Invoice and Payments to Edicom for Certification.

Build custom API’s to get Mexico Invoicing data from Oracle and pass it to SOA using PL/SQL Collections.

2) Qantas Billing

Performed setups in AR for Qantas Invoicing.

Prepared high level detail design document for Qantas Invoicing.

Worked with Qantas team for the testing of Invoicing to make sure flow is working without any issues.

Collaborate with SOA team to send Qantas Invoice.

Build custom API’s to get Qantas Invoicing data from Oracle and pass it to SOA using PL/SQL Collections.

Key Objects

ANZ Card Processing– Implemented Card processing for Aviation segment for Compaq Customer.

Matching Workbench PO Flow – PO flow needs to incorporate in the matching workbench application to record supplier invoices against blanket PO.

Auto Carrier Pay – This is to auto pay carrier by supplier site if it’s setup for Auto pay.

Organisation:

Sunera Technologies, Hyderabad, India

Project Description:

Client – World Fuel Services, USA

Duration – Jan 2014 – Feb-2015

Environment – Oracle Apps 11.0.3 (Financial, OM, PO and INV)

Job Title – Associate Manager

Project Type – Enhancement

Brief Description of the Project:

This is enhancement project in financial domain to implement changes in the existing system for improvement of business processes.

Modules

Account Payables (AP), Account Receivables (AR), Purchasing (PO), Order Management (OM), Inventory (INV)

Tools & Utilities

Reports 6i, Oracle BI Publisher, SQL* Plus, SQL Developer, WinCVS, JIRA and Mozart

Responsibility

Analyse enhancement request of Invoicing (AR and AP) and Matching Application from business and provide technical solution.

Analyse impact of new enhancement on the other application and provide regression testing plans to make sure no breakdown in existing functionality.

Prepare build using PL/SQL, Oracle Reports, Forms and XML publisher as per technical solution.

Mentor the team members.

Prepare Test document and migration of the code using WinCVS, Mozart and JIRA.

Key Objects

Vigo-Spain Invoice– New Legal Entity in Vigo – Spain called “WF Lubricants S.L.” has been created in the Land Operating unit and AR Invoices format changed for this Legal Entity.

Credit and Rebill – Customize process for Credit and Rebill in Land Operating Units.

Reverse Charge Setup for Slovakian Customer - Reverse Charge for the Slovakian Customer added for Aviation Segment.

Rematching for Splits - One AP line should be able to match to multiple AR lines. The business would also like to be able to retrieve the references/links associated to the AP and AR. The new functionality should also update the accrual table.

Organisation:

Computer Science Corporation, Hyderabad, India

Project Description:

Client – Omnicare, USA

Duration – Dec 2011 – Jan 2014

Environment – Oracle Apps R12.1.3

Job Title – Techno Functional Consultant

Project Type – Implementation

Brief Description of the Project:

This project was implementation project of AR operations of Omnicare.

Modules

Account Receivables (AR) and General Ledger (GL)

Tools & Utilities

PL/SQL, Oracle Applications Framework (OAF), Reports 6i, Oracle BI Publisher, TOAD

Responsibility

Worked in the full implementation cycle and post implementation support.

To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.

Involved in developing technical design document ( MD 70 ), Testing Documents ( TE020 ) and release documents ( MD120 ) for technical solutions using oracle AIM standard.

Extensively worked on Oracle Applications Framework (OAF) to build third party cash application from scratch. This application had four new OAF pages for Tie-Out Summary, Details and Batches to review, validate and process payments from third party.

Mentor the team members.

Key Objects

CCE001 Third Party Cash Application – Third party payers send payment information in Electronic Remittance Advices (835) to Omnicare. Omnicare converts multiple 835 files from different payer into a standard CRFF format. CRFF file is interfaced to Oracle for cash application for third party payer. As Oracle doesn’t have the ability to apply cash payments to invoices based on custom attributes like TCN, Rx #, RAF, NABP and Amount Paid, there is a need for developing a custom object.

FIN-E012 Unbilled Charges to Omniview– This program is designed to collect unbilled charges for Facilities, Facility+Patient, Facility+Nursing Stations and House Stock. Unbilled charges are any transactions in OCEAN for a Facility.For a Facility that has not been consolidated and presented to the Customer for payment.

FINI001 AR Customer outbound from Oracle to Sunguard – ARCUST would be used to extract oracle customer data and send it to sungaurd system. This outbound would include converted and non-converted customer.

FIN-E-001 Auto invoicing & auto accounting EXTENSION – The Extension for Auto Invoice and Auto Accounting is required because this extension allows to create AR Transactions at the time of interfacing eligible billable lines from Oracle Order Management to Accounts Receivable and consists of business rules and logic to derive appropriate Transaction Types, create proper accounting entries and enable accurate posting of GL entries based on Omnicare’s specific requirements for Revenue Management of its LTC Pharmacy sales transactions. It also enables assigning the correct legal entity values to the Ar Transactions whether Invoices, Debit Memos or Credit Memos.

FIN-E003 AR Rebilling Extension Credit Application– The Extension to Apply Credits against Open Facility and Patient Charges within a Billing Period is thus required to meet bill presentment requirements to Facility and Patient Customers through the customer portal and/or through third party agencies (such as Endeon for Private Patients); and to ensure that any charges that are not liable to be paid by the customer due to credits issued arising out of re-billing activity are not presented in their consolidated bills/statement of charges.

Organisation:

Computer Science Corporation, Hyderabad, India

Project Description:

Client – Centric Group, USA

Duration – Jun 2011 – Nov 2011

Environment – Oracle Apps R12.1.3

Job Title – Techno Functional Consultant

Project Type – Enhancement

Brief Description of the Project:

This project was enhancement projects of AR and OM operations of Centric Group.

Modules

Account Receivables (AR) and Order Management (OM)

Tools & Utilities

Oracle Apps 12i, XML Report, SQL Developer, Oracle Report 10g

Responsibility

Worked in the full implementation cycle and post implementation support.

To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.

Involved in developing technical design document ( MD 70 ), Testing Documents ( TE020 ) and release documents ( MD120 ) for technical solutions using oracle AIM standard.

Involved in design and development of Oracle Report, XML Publisher and PL/SQL.

Key Objects

OMR2381 Buying Group Report-Internal Use – This report allows Courtesy Products to standardize the format for the sales tracking reports for Buy Efficient, Gus Vending, American Hotel Register, Wasserstrom, Interstate Hotels Corp., HMA, and Accor

FINR2139 Rebate Checks Report – This report is required because it will allow Courtesy to determine which customers should be receiving rebates for CV1 Brewers for the month as part of the CV1 In-Room Coffee System Volume Rebate Program and the information needed to manually calculate that rebate. This report will also be used to see what customers are currently on the program for accrual of rebate information.

OMR2925 Vendor Rebates – This is a report of sales for specific items to Avendra customers to be used in the calculation of vendor rebates. The report will list the sales of the specific items to Avendra customers on a period basis. This excel based report will allow the user to have a detailed and summary version of sales of the specific items to be used in the calculation of the vendor rebates. In Oracle every time it prints 2 reports based on parameters passed House Hold Essentials (Note: New name Whitney Design ) and China International.

MFGC168 BOM conversion - The MFGC168 BOM conversion is required because there are too many BOM records in ALICE to be converted manually.

Organisation:

Capgemini India Pvt Ltd

Project Description:

Client – AT&T, USA

Duration – May 2010 – May 2011

Environment – Oracle Apps R12

Job Title – Developer

Project Type –Enhancement

Brief Description of the Project:

This project was enhancement projects of PO, AP and INV operations of AT&T.

Modules

Project Accounting (PA), Accounts Payable (AP), Accounts Receivable (AR), Purchasing (PO), iExpense and iProcurement

Tools & Utilities

PL/SQL, Oracle Apps R12, Oracle 10g and OAF

Responsibility

Worked in the full implementation cycle and post implementation support.

To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.

Involved in developing technical design document (TDD) for technical solutions using oracle AIM standard.

Involved in design and development of interfaces, customized standard workflow and OAF task.

Key Objects

Manual Hold on EDI Invoices

Applying manual hold on the EDI invoices if invoice lines have the fractional quantity.

Extract PO from Oracle to Data2Logictics

This object would extract the po information from the oracle and send it to Data2Logictics server using sftp connection.

Item Exclusion from iProcurement Category

The iProcurement browsing for items process should exclude certain items from a mapped Oracle iProcurement categories based on the exclusions defined by the administrator.

Organisation:

Oracle India Pvt Ltd

Project Description:

Client – VMware, USA

Duration – Dec 2008 – Apr 2010

Environment – Oracle Apps 11i

Job Title – Associate Consultant

Project Type –Enhancement

Brief Description of the Project:

This project was enhancement of Payable operations.

Modules

Accounts Payable (AP), General Ledger (GL) and Purchasing (PO)

Tools & Utilities

PL/SQL, Oracle Apps 11i, Oracle 9i, Workflow and Discoverer Report

Responsibility

Worked in the full implementation cycle and post implementation support.

To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.

Involved in developing technical design document (TDD) for technical solutions using oracle AIM standard.

To develop SQL scripts to create staging tables and developing SQL*Loader control files to load the legacy data into the staging tables. Perform data validations and mappings at staging table level. Wrote PL/SQL validation packages.

Involved in design and development of interfaces, Discovere Report and customized standard workflow according to project need.

Creating PPM Package for object migration.

Key Objects

Journal Line Sequencing Interface

Create a unique line number sequence for manual and generated journal entries in the Italian set of books.

TLC(Transacting Local Currency) Release

TLC changes applied on Revenvue Pending, Revenue Closed and Daily Receipt Recon Discoverer Report.

TouchLess PO Release

Automated the process of PO creation from a Purchase Requisition without the manual intervention of buyers, thereby, eliminating the necessity of the buyers going to the Auto-Create Screen in Oracle and creating the PO manually.

P-Card Invoice Integration with Project

This Integrate Project Accounting with Accounts payables for manual invoices.

Recurring Invoice Automation

This is about to generation of recurring invoices automatically and plug in the Approver Name in each of these invoices for approval.

Organisation:

Oracle India Pvt Ltd

Project Description:

Client – CVRD Inco, CANADA

Duration – Feb 2008 – Nov 2008

Environment – Oracle Apps 11i

Job Title – Associate Consultant

Project Type –Implementation

Brief Description of the Project:

This project was implemented to create multiple reports.

Modules

Accounts Payable (AP) and Accounts Receivable (AR)

Tools & Utilities

PL/SQL, Oracle Apps 11i and Oracle 9i

Responsibility

Worked in the full implementation cycle and post implementation support.

To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.

Involved in developing technical design document ( MD 70 ), Testing Documents ( TE020 ) and release documents ( MD120 ) for technical solutions using oracle AIM standard.

Involved in design and development of Oracle Report using PL/SQL procedure.

Key Objects

AR TINO Transactions

The report displays matching sales transactions in TINO and ORACLE. The record for each transaction in both systems is compared and the difference in sales amount is calculated

AP Managers Cost Center

This report is intended for each manager to have information available to show him or her exactly what travel costs or transactions will be charged to their cost center for the respective month.

Organisation:

Oracle India Pvt Ltd

Project Description:

Client – Mitra (Internal Oracle Project)

Duration – May 2007 – Feb 2008

Environment – Oracle Apps 11i

Job Title – Associate Consultant

Project Type –Internal Project

Brief Description of the Project:

This project was implemented to create repository of most commonly used Conversions.

Modules

Accounts Payable (AP), Accounts Receivable (AR), Purchasing (PO),

Inventory (INV)

Tools & Utilities

PL/SQL, Oracle Apps 11i and Oracle 9i

Responsibility

Involved in developing technical design document (MD 70 ), Testing Documents ( TE020 ) and release documents ( MD120 ) for technical solutions using oracle AIM standard.

Involved in development of custom API’s for the Conversion.

Key Objects

AP Invoices Conversion

This conversion imports all open AP invoices from legacy system to Oracle Application of VeriFone Corporation.

Open Purchase Order Conversion

The Open Purchase Order Conversion is the process of bringing over open purchase order data from the legacy system (MARS/G) to Oracle Purchasing

Iron Mountain Customer Conversion

This Customer conversion allows you to insert and update customer information from the Iron Mountain legacy and billing systems into Oracle Applications.

The Maximo Item Conversion

This Conversion processes the mapping Maximo aviation items from the legacy system to Master Items in Oracle Inventory.

Inventory On hand Quantities Conversion

This conversion provides City Of Chattanooga (CoC) with a method to migrate their inventory balances from System (BIC, City Works, TMS, RTA and Access) to Oracle Inventory

Organisation:

NetSoft Computers, Mumbai

Project Description:

Client – RK Hotels

Duration – Jan 2006 – Apr 2007

Environment – ASP.Net with C#

Job Title – Software Developer

Project Type – Implementation

Brief Description of the Project:

This project was creating software to implement hotel processes.

Modules

Receivables, Expenses and Check In/Out operations

Tools & Utilities

ASP.Net with C# and SQL Server

Responsibility

Worked in the full implementation cycle from scratch.

To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.

Involved in design and development of the project with ASP.Net with C# technology with SQL Server as backend.

Certification/Trainings/Chief Accomplishments

Oracle Certified Associate (OCA) Certification

Oracle Certified in Receivables module.

Oracle Certified in Payables module.

Client appreciation for Third Party Cash application in Omnicare project.

Got appreciation from VMware client as exceptional work for TouchLess PO task.

Member of QA/QC team in CSC. Awarded for the best reviewer of October 2012.

Attended Oracle AIA 11g R1 Foundation Pack Implementation Training

Attended Oracle SOA Training

Got 4th rank in University of Rajasthan in I Semester of MCA.



Contact this candidate