Oracle Apps Finance Functional Consultant
Talari Mu rthy Mobile: +60-176******
E -Mail:
Oracle Apps F inance Functional Consultant
t ***************@*****.***
P rofile Summary:
• Have an overall 6+ years of professional experience out of which 5+ Years related
t o the O racle Apps Financials as a F inance Functional Consultant .
• Analyzing and identifying the functional requirement of client and maintain its
v isibility throughout the implementation.
• Have been working in Oracle applications financial modules ( GL, AP, AR and
P O) Good knowledge in FA and C M .
• Good exposure on E-Business Tax Setups
• I have been working in O racle HR MS Module (Preparing Template and Extract
t he Data from legacy system and Cleansing duplicate data etc.)
• Hands on experience with D ata cleansing and M igration i n Oracle R12.
• Basic SQL data extraction knowledge
• Comfortable with data presentation / analytics using Excel
• Involve as a team member in P rocure to pay & Order to Cash
I mplementation.
• Configuration of Instances and Prepare Setup Documents (BR-100) and Test
scripts based on the business requirement.
• Preparing the T est Scripts based on the business process of the client and
worked on the Business system testing before submit ting.
• Preparation of t raining documentation for the user t raining and helping
t he technical consultant to arrive at the functional aspects.
• Configuration of Instances and Prepare C ustomization Documents (MD-050)
and T est scripts based on the business requirement.
• Interaction with client through r egular conference and web-cam calls.
• Good Experience in form personalization & Multiple I nstances (DEV, DIT,
T E & Prod).
1
Oracle Apps Finance Functional Consultant
Experience:
1. Working as an O racle Apps Finance Functional Consultant w ith “Amway
A TLAS I n te rnship P rogram” u nder payroll o f D igital Intelligence Systems,
L LC (D ISYS), Kuala Lumpur, Malaysia. F rom April-2014 to till date .
2. Worked as an A pplication Consultant (Oracle Techno functional Consultant ) with
“I nternational Baccalaureate ” under payroll of Optimum Solutions,
S ingapore . (Nov-2013 to Ma r-2014)
3. Worked as an O racle Business System Analyst w ith D ell I nternational Services
I ndia Pvt. Ltd (D IS), Bangalore, I ndia Sep-2011 to Oct-2013.
4. Worked as an Oracle Apps F inancials Associate Consultant w ith S imtec Global I T
Services Pvt. Ltd F rom Nov-2008 to Jun-2011.
5. Worked as a J unior Accountant w ith M ed-Ex Soft I ndia Pvt. Ltd . from Oct-2006 to
M ar-2008.
Educational Qualifications:
• Bachelor of Commerce with Computers (B.com Computers) f rom Sri
K r ishna Devaraya University, Anantapur, Andhra Pradesh.
2
Oracle Apps Finance Functional Consultant
Applications and Development Skills
Operating Systems Windows Server-2003, XP, 2007 & 2008
Package Tally 6.3
Oracle Applications General Ledger, Oracle Purchasing and Accounts Payable,
11i & R12 Accounts Receivables, Fixed Assets and Cash Management.
Project #1: I mplementation & Rollout in R12 (12.1.3)
D uration: April-2014 to Till Date
M odules Involved: GL, AR, OM & OMS
Role: Finance Functional Consultant.
C lient: Amway I T Services Sdn Bhd C yberjaya, Malaysia.
Amway IT Services Sdn Bhd, a subsidiary of Amway Incorporation in USA, is the Global Data Centre and IT
Service Hub for markets in the Asia Pacific region. This Global IT Hub is located in Cyberjaya and serves as a
regional shared services center, regional IT infrastructure and support services center.
Roles and Responsibilities:
A nalyze business requirements to identify testable conditions
Develop or lead functional test planning based on business and functional requirements
Build test cases with detailed test conditions and directional/navigational test steps
Support the creation and maintenance of test data in the test environment
Conduct and participate in functional test plan inspections and obtain key stakeholder signoff
Execute and validate the functional test plan to ensure the business requirements, functional
and navigational requirements are met.
Conduct data analysis and validation to ensure all system and application modifications meet
t he end user business requirements
Preparation of project documentation such as test scripts (TE40), standard operating procedures,
and training materials
Identify, document, communicate, support and follow through to resolution of defects
Review requirements documents for accuracy and completeness and ensure coverage by
appropriate test cases
Partner with the developers in validation and resolution of problems in new and existing
applications.
Develops Quality Assurance standards, practices and procedures, especially as it pertains to test
data creation/maintenance.
Involved in daily conference call with onsite team for UAT Progress
Preparing for and participating in the CRP workshops
Preparing for and conducting FUT,SIT and UAT.
Liaison with Oracle for support on various critical issues
3
Oracle Apps Finance Functional Consultant
Project #2: Upgrade & Implementation from 11i to R12 ( IB)
D uration: Nov-2013 to March -2014 (Onsite)
M odules Involved: GL, AP, AR, FA, CM & HR MS
Role: Application Consultant
O rganization: I nternational Baccalaureate Pte Ltd ( IB), Singapore.
The I nternational Baccalaureate (IB ), formerly the I n ternational Baccalaureate
O rganization (IBO ), is an international educational foundation headquartered in Geneva,
S witzerland and founded in 1968. IB offers four educational programmes for children aged
3–19.The organization's name and logo were changed in 2007 to reflect reorganization.
Consequently, "IB" can refer to the organization itself, any of the four programmes, or the
d iploma or certificates awarded at the end of the diploma programme.
Oracle Apps Implementation in I nternational Baccalaureate Business School. Each
having a Implementation Team of KPMG and we in I nternational Baccalaureate, is giving
Support to them technical and functional. Oracle Application R12 modules General Ledger,
Accounts Payables, Accounts Receivables, Cash management, Fixed Asset, HRMS .
Role: I n terface between the Oracle Implementation team and IB Finance Users .
Responsibilities:
Coordinated between business operational user, end user and project manager.
Review the data conversion requirements and strategy.
Extract conversion Data for financial modules from 11i.
Work with Finance users to reconcile and validate accuracy of converted data.
Review test plans produced by Oracle Implementer and guide finance users in
developing test scenarios and sign-off for UAT test(s).
Review and validate accuracy and correctness of deliverables produced by Oracle
I mplementer for the business requirement definition phase prior to.
Sign-off by finance process Owners.
Participate in cross module testing during the In tegration Testing.
Drive and co-ordinate end-user’s UAT.
Review Users’ M anual & Training documents.
Cleansing the Duplicate or Mul tiple Customer Masters and Vendor Masters.
Preparing Data Template in Oracle HRMS and Financial Modules.
Preparing Conversion and Design documents like CV-010, BP-080 in Oracle
F inancial.
4
Oracle Apps Finance Functional Consultant
As a functional consultant, responsible for studying the business process. P repared
AS-IS understanding document for AP,FA,AR,GL,CM
Transform 11i Data for R12, working with the End Users.
Assisted in business process reengineering, created TO-BE process document .
Performed GAP analysis and prepared solution presentation for review .
Performed functional testing for existing modules to understand existing business
p rocess, created documents to understand functional requirements for interfaces.
Prepared Mapping document RD.50 and setup document BR.100 for
AP,FA,AR,GL,CM module
Testing of various test scenarios.
Understood existing interfaces and provided AS-IS document.
Giving user t raining to end user
Preparing the MD 50 document for various interfaces.
Setting up AP,FA,AR,GL,CM modules
Involved in some activit ies for Oracle System Administration module such as
Registering the Users and assigning responsibilities, printers in Oracle Apps
Creating new responsibilities and defining the required system profile options
Enabling Key Flex field and Descriptive Flex field.
Prepare issue and r isk t racker and submit to client weekly basis
W riting / executing scripts using SQL Navigator to perform various extracts from
database.
P roject #3: OMEGA Environments. (OMAR)
D uration: Sept-2011 to Oct-2013
Modules Involved: AR, GL, OM.
Role: Oracle B usiness System Analyst
Organization: D ell I nternational Services I ndia Pvt. Ltd (D IS),
B angalore.
Team Size& Name: 18 & OTC_FUN_SETUP_TEAM
Role:
Participate in all Instances phases as required and provide input that
helps PMs to create a consistent and relevant schedule (PROD,DIT, DEV,
T E1&TE2)
E-Business Tax Upgrade Considerations
5
Oracle Apps Finance Functional Consultant
US Sales and Use Tax - Setup Considerations
Canada VAT & Recovery - Setup Considerations
Latin Tax Engine - (Mexico, Argentina, Chile and Brazil)
Preparing Business Process As is Document and Mapping with Oracle 11i.
Discrete manufacturing standard process and preparing to be Document for the
business process.
Prepared the Setup documents for the configuration of Oracle Purchasing.
Worked in the Documentation and setting up of the Multi Organization Access
Control (MOAC) Setup.
Prepared the test Plans.
Understanding the methodologies and their interaction with other business
p rocesses and applications.
Taking decisions independently and interacting directly with the implementation
partners.
Preparing Training Documents
Worked as Help Desk member after post implementation providing
f unctional business solutions.
Configuration of Setups for AR, PO and GL Modules in Dev and Test
I nstances
Interacting with the users for process pending activities and
Requirements.
Providing Functional documentation for Technical Team for
developing reports
Project #4: Applera Corporation.
D uration: July-2010 to Jun-2011
Modules Involved: GL, AP, PO and AR.
Role: Oracle Associate Consultant
Organization: Simtec Global I T Services Pvt. Ltd. Bangalore
Applera Corporation consists of the Applied Biosystems Group; The Company is focused on
t he discovery, development, and commercialization of Novel Diagnostic Products. The
p roject was to implement and customize the Oracle Applications R12. The various modules
of Applications
Role:
6
Oracle Apps Finance Functional Consultant
In teract effectively with customers, developers, and peers to ensure the successful
delivery and implementation of the solution.
Modified check-printing program in AP to suit new company requirements. Provided
modifications to custom Expense Distr ibution Report in AP.
Ongoing technical and functional support for oracle application modules like GL, AP,
AR and monitoring user activity, supporting user requests for new oracle reports,
C reating Concurrent Programs and make the report as executable
All Support Tickets in All module in I, Purchasing, General Ledger, Payable, and
Receivable Modules
Involved in solving various functional issues related to GL as well in the functional
analysis of GL reports to meet the User requirements.
Imported assets invoice into accounts payables and integrated to different modules
for fur ther processing of mass additions.
Use the proactive approach in month End closing, cleared all the pending
t ransaction in Inventory and close the sub ledgers.
Discuss all the issues with business on weekly call. Send the document to users for
t he user Training related issue to decrease the no of logs.
Discuss the development and Enhancement Task list with business on weekly.
Project #5 Bridgestone ( Implementation)
D uration: Jul-2009 to Jun-2010
Modules Involved: GL, AP, PO and AR.
Role: Oracle Associate Consultant
Organization: Simtec Global I T Services Pvt. Ltd. Bangalore
Br idgestone is one of the biggest tyre and rubber manufacturers in the world and i t sells its
t yres and other products in more than 150 nations, Tyres and Tubes, Automotive Parts,
Chemical Products, Electro-Materials, Sporting Goods, Bicycles and other products.
Role:
7
Oracle Apps Finance Functional Consultant
Responsible to perform process analysis, design, integration, testing,
i mplementation, documentation based on AI M Methodology
Creating AP Invoice Types like Prepayment (Advance Payment), With hold Tax
setups and AR Invoice Types like Deposit & Accounting Rules, Invoice Rules etc.
Defined Payment terms and recur ring invoice templates. Set up employee expense
templates and distribution sets. Activated some descriptive f lex fields to capture
additional information for the client not available in standard oracle forms. Set up
Suppliers and Banks for AP use.
Order-to-Cash: Receivables processes including Revenue Recognition, Collections,
I nvoicing; understanding of integration with Order Management, Inventory, GL,
Cash Management
Responsible for define different types of standard and financial statement and drill
down through application development integration.
Involved in solving various functional issues related to Financial Module (AP, AR,
PO and GL) as well in the functional analysis of financial reports to meet the User
requirements.
Core Review Team Member: The team reviews of all critical development work,
w hich are planned to go live in production. The primary purpose of review is to find
i mpact of design changes into system so as to have defect free design.
Study and improve performance of existing business functionality within Oracle.
Developed new programs to enhance business functions.
Gathering the requirement for new functionality understand and convert it in
technical terms and assign it to resource and help them to deliver i t on t ime
Responsible to reconcile the all Financial modules (AP, AR, GL and PO) and period
end close by month to all financial modules
P roject # 6 Supporting
Client: B rocade
8
Oracle Apps Finance Functional Consultant
Duration: Nov-2008 to Jun-2009
Role: T eam Member
Organization: Simtec Global I T Services Pvt. Ltd. Bangalore
Brocade is an industry leader in data center networking solutions and services that enable
organizations to manage their most vital information assets. Global 500
companies rely on Brocade technology to keep their businesses running around
t he clock.
Role:
Supporting the Installed product of Oracle financials 11i.
My work is involved in GL,AP and PO
Submission of Weekly reports to the Client about Ticket Statuses
Planning, Designing and delivering custom and standard features including oracle
payables, and oracle general ledger to the end users.
Interacting with Users for required information about the issues arise
Handling the t ickets, resolving the issues on day to day basis on priority.
Undertaking all steps necessary to satisfactorily closure of the t ickets raised by
clients.
Interacting with Project manager on daily and weekly basis and submit ting status
report
Handling situations for run t ime problems and suggesting the work around.
Domain Experience
Responsibilities:
Vouching the bills for sale or purchasing of Materials.
Maintenance of Debtors ledger, Creditor Ledger.
Writing Purchase and Sales registers.
Preparation of final accounts- Trial balances, P&L account and Balance’s
sheet.
9
Oracle Apps Finance Functional Consultant
Computation of total income for individuals.
10