Oracle Financials

(Techno-Functional)

PROFESSIONAL HIGHLIGHTS:

. Permanent Resident of Canada and can work for any employer.

. Over 15 years of (10 years in USA, 4 years in India, 1 year in

Singapore and Currently in Canada) rich comprehensive international

experience in Oracle Financials/Oracle EBS, financial, networking,

healthcare and software industries like Oracle Corp, Fidelity

Investments, Lucent Technologies, Concentra and IBM.

. Strong knowledge of Oracle database systems and Oracle Financials

(Techno-Functional).

. 7 years of experience in Business Intelligence Applications using

Oracle Business Intelligence (OBIEE) / Siebel Analytics/Oracle

Business Intelligence Apps (BI Apps).

. Expertise in Business Intelligence Applications using Oracle Business

Intelligence (OBIEE/OBIA)

. Expertise in various reporting tools like OBIEE, Oracle Reports 2.5,

6i, 8i, 10g, 11g, XML Publisher, BI Publisher and Discoverer.

. International work exposure.

. Singapore: Worked for Oracle Corporation.

. U.S.A: Worked for Fidelity Investments, Concentra, IBM and Lucent

Technologies.

. India: Worked for Mahindra Satyam.

. Bachelor's degree in Engineering.

. Self motivated, able to strategically plan & methodical in handling

assigned tasks and establish internal controls and procedures.

. Creative and innovative skills in designing and developing and

implementing Oracle and Financials projects and promoting a safe work

environment.

. Strong leadership, interpersonal and communication skills gained

through mentoring and motivating team members; ability to develop good

client relationships important for securing repeat business.

. Highly motivated, able to multitask and work with minimum supervision,

committed to highest quality of end result.

. Expertise in taking user requirements, preparation of specifications

and setting up of standards, documentation and user training.

TECHNICAL SKILLS:

. ORACLE Applications: Oracle Financials Rel. 12, 11.5.10, 11.5.8,

11.0.3, 10.7 and 10.6

. ORACLE Financials: Accounts Receivables, Accounts Payables, PO,

iProcurement, General Ledger, Fixed Assets, Inventory, Order

Management, CM, Application Object Library, Oracle Project s.

. Database: Oracle 11g,10g, 9i, 8i, 7.x/6.0, MS Access, MS SQL Server

2000/2005, People soft

. Tools: Forms 10g,6i, Reports 10g,6i, Developer/2000 (Forms 4.5,

Reports 2.5), Designer 2000, Visual Basic 4.0/3.0, Oracle Reports

2.0/1.1, SQL*Loader, TOAD, Workflow Builder, OAF, BI Publisher,

Discoverer 4.1,10g, OBIEE, BI publisher, Data Loader, PVCS and ADI.

. Languages: PL/SQL, SQL*Plus, Pro*C, C, Basic, Pascal, FORTRAN

. Operating Systems: HP UNIX 2000, Sco-Unix 5.0, Windows 3.1, Windows

95, Windows,98/NT/2000/XP

. Hardware: IBM PC Compatibles, Compaq Pentium

. Testing : HPQC

PROFESSIONAL EXPERIENCE:

ERP Support Analyst, Shaw Communications, Inc., Mississauga, Canada

FEB 2012 - JUN 2013

Duties & Achievements:

. Working for production support for various projects mainly in finance

modules like AP, AP, GL, INV, FA and PO in Oracle Financials 11i.

. Working on Asset Tracking.

. Working on configurations, mapping for AR Migration from the external

system.

. Created reports and dashboards as per Business requirements using BI

Publisher and also OBIEE Answers.

. Working on developing reports using BI Publisher for production

support.

. Created numerous executive level reports. 'Dashboards' were generated

to provide insight into the financial data.

. Created Technical Design Documents (TDDs) for OBIEE Semantic Layer,

BI publisher Reports

. Worked on various reports in Finance Modules using Discoverer Plus

Senior Consultant, Oracle Corporation, Singapore

JAN 2011 - DEC 2011

Client: Global Foundries

Project: Oracle Financials R12 implementation project.

Duties & Achievements:

. Customized various Forms and Reports in Oracle Applications Modules

GL, AP, AR, FA, PO, iProcurement and Projects.

. Worked on capital workflow monitor report for reporting of the

workflow Status of Projects.

. Worked on various objects as per the MD 50s, interacted with users

and gave demonstration.

. Prepared MD 70s for all the components developed.

. Achieved great results in working on interface and conversion of the

data.

. Extensively worked on FA reports and successfully customized Aging

Report in Accounts Receivable (AR) module and developed various

reports using BI Publisher.

. Developed reports in Discoverer and created various business areas,

user views, custom folders and joins for reporting. Created Workbooks

based on the Custom Folders with multiple parameters and calculations

using Discoverer Plus and Discoverer Desktop

. Got appreciations from the managers in working on various Forms

personalization.

. Customizations and Extension of OAF pages

. Created and developed various Packages for the custom sources

required for the Sub Ledger Accounting (SLA) changes in FA and AP.

Defined Account derivation rules (ADR), Journal Line Types, Journal

Line Definition, JLD, AAM and Sub ledger Accounting Methods.

. Successfully migrated the developed components, Concurrent programs

and RTF Templates to different instances using LDT.

. Prepared test scripts for various all the finance modules.

. Successfully conducted training classes to end users for effective

usage of developed objects

Consultant: Satyam Computer Services Ltd., Hyderabad, India

AUG 2007 - DEC 2010

Project: Oracle 11i Implementation

Duties & Achievements:

. Successfully Developed and customized Oracle Applications Modules GL,

AP, AR, OM, PO.

. Interacted with end users to gather requirements and draft

specifications for the development phase.

. Responsible for the development that includes the interface and

conversion of the data from legacy systems to the Oracle database and

customizing reports for the client.

. Got appreciation from the Project Manager and also from the end user

on the customized Invoice Aging Report in Accounts Payable (AP) module

to view the invoices unpaid in the specified time period instead of

all the four time periods which was developed and customized by me.

. Successfully converted flat files from Excel to Data files and

developed the SQL*Loader program to load the data to staging tables

for Order Import program to import orders. Wrote packages to validate

and populate the interface table.

. Responsible for loading the Requisitions and the Open Purchase Orders

data from the legacy system to Oracle Purchasing. Developed PL/SQL

program to perform data validation.

. Registered Inbound Interfaces and Reports in Concurrent Executables

and Concurrent Program.

. Worked on customizations of reports using XML Publisher.

. Involved in developing Reports using Discoverer. Created business

areas, custom views, new folders, conditions and joins based on user

requirements.

. Used Forms and Reports exhaustively for viewing the data extracted or

uploaded into the staging tables.

. Successfully edited existing reports so as to add additional

functionality (calculations, parameters, sorting, conditions).

. Responsible for documentation and training end users for effective

usage of developed packages.

. Developed OBIEE Financial Reports

. Used the OBIEE 10.1.3.3.x Administration tool to develop and enhance

meta-data.

. Worked extensively with Physical Layer, Business Layer and

Presentation Layer.

. Worked and Involved in Semantic Layer of OBIEE.

. Used XML Publisher for creating some reports.

. Used BI Publisher for creating Enterprise reports

Project: HDS Finance Rollout

Duties & Achievements:

. Understanding existing implementations in US.

. Review and scope new requirements, requests for change and problems

for modules already implemented.

. Created new responsibilities and defining the required system profile

options.

. Successfully enabled key flex field and descriptive flex field and

assets key, category, and location key flex fields.

. Successfully carried out mapping and gapping, data conversion and

defined descriptive flex field to capture extra information.

. Created the user, printers, responsibilities, request groups.

. Responsible for creating value set and to assign its values.

. Got achievements in customizing the reports using Reports 6i for AP

concurrent programs as per the requirements of the Clients.

. Responsible for setup for concurrent programs and request set to run

reports.

. Successfully completed the given assignment of development of XML

Publisher Reports.

. Worked on the Auto Lockbox in receivables that automatically creates

receipts using the electronic information that the bank provides.

. Got appreciation and award for the company in customizing reports

"Customer Open Balance Letter Report" in Accounts Receivable (AR)

module using Oracle reports 6i.

. Developed some adhoc reports using discoverer according to the client

requirement.

. Successfully entered financial and payable options and also opened

payables accounting periods.

. Successfully defined payment terms, reporting sets and tolerance

levels as requested by the client.

Sr.Oracle Financials Developer: Fidelity Investments, Merrimack, NH, USA.

JAN 2006 - DEC 2006

Duties & Achievements:

. Worked on 'AR Upload Tool' project, which provide an Automated Process

for loading Invoices and Credit Memos to Oracle AR.

. Worked on the Project 'AP Mass Invoice Cancellation'.

. Successfully developed a Shell program and called the standard Package

'AP_CANCEL_PKG' into the shell for the mass cancellation of AP

invoices.

. Worked on the project 'Automation of Tax Synchronization between

Master Tax and HRMS Systems'.

. Responsible for various fixes and enhancements as per the business

requirements.

Sr.Oracle Financials Developer: Fidelity Investments, Boston, MA, USA.

FEB 2005 - DEC 2005

Duties & Achievements:

. Worked on '11i Upgrade' project. Worked on upgrading the Oracle

Financials from 11.0.3 to 11.5.10.

. Responsible for AP and PO modules in projects like File Net workflow

Processing, Interfaces, Oracle background Processes, 11i Odyssey

Customizations, Odyssey Interfaces, and Discoverer etc.

. Got Appreciation Awards from Fidelity Investments.

Sr.Oracle Financials Developer: Concentra Integrated Svcs. Waltham, MA,

USA Project: 11i Reimplementation Project

JUL 1998

- JAN 2005

Duties & Achievements:

. Successfully created new reports and customized some of the standard

reports in Accounts Receivables.

. Responsible for conversion of Customers, Addresses, Contacts, Phones

and Site Uses from 10.7 into 11i Receivables.

. Converted Assets from the Legacy system to11i.

. Developed a program to load the Data from the COC_FA_MASS_ADDTIONS

table of the legacy system to the FA_MASS_ADDTIONS of the 11i.

. Created Extracts for ESIS and for Corporate Data warehouse. ESIS

Extract is to send extract of the data of the customer ESIS with the

wholesale and retail rates.

. Extensively utilized the Application Object Library to register

SQL*Loader programs, Shell Scripts, PL/SQL procedures, Forms and

reports.

. Responsible for tuning the PL/SQL Programs and reports for improving

the performance.

. Integrated different custom applications with Oracle Financials.

. Provided production support for Oracle Financials module 'Accounts

Receivables'.

. Developed a project called 'Time Tracking Initiative' for recording

and analyzing time spent on various activities by the field staff.

Programmer: Lucent Technologies, Milpitas CA, U.S.A

DEC 1997 - JUN 1998

Duties & Achievements:

. Successfully developed an Interface program to integrate AR with the

external system

. Customized Standard reports like Receipt History, Billing and Receipt

history etc.

. Adding descriptive flex fields in AR module.

Programmer: IBM Business Solutions/ Konica Business Machines, Windsor CT,

U.S.A Duties

& Achievements: SEP 1997- NOV

1997

. Involved in running concurrent programs, journal import programs, GL

transfer programs, auto invoicing, running Auto Lock box etc.

Programmer: Andhra Pradesh Electrical Equipment Corporation, A.P, India.

Duties & Achievements:

JAN1995 - MAY 1997

. Developed, customized and maintained different systems o the company

including Financial Accounting System, Inventory Control system and

Purchase and Sales order System.

EDUCATION:

. Bachelors Degree in Engineering (1987) - Kakatiya University, India

. Post Graduate Diploma in Computer Applications (1992) - India

. Technical training in Visual Basic, Oracle, Oracle Financials.

Contact this candidate