Abhijit R. Tarsekar
Oracle Apps Functional Consultant
Contact no:--
Summary
Over and above 5 years of experience as Oracle Functional Consultant for Financial Applications, and Worked as part of
Implementation, Support, 'Procure to Pay' 11i & R12 including GL, AP, AR.
Experience includes exposure to all the phases of Software Development Life Cycle including Analysis, Design, Development,
Testing, Implementation, Production Support and Maintenance.
Excellent problem solving skills with an ability to identify problems and implement connective solutions.
Experience in providing Level 3 support to resolve high priority production and support tickets.
Have good experience on AIM Methodology Documentation like BP040, BP080, BR100, MD050, MD070 and TE020 Documents.
Good understanding of oracle apps architecture such as integration between modules, profile options, look ups, descriptive as well
as key flex fields, Interfaces, defaulting rules, organizational structure, setups etc.
Have experience on sub ledger accounting (SLA)
Having Good communication with Strong commitment, dedication and efficient problem solving skills.
Extensive understanding of business and accounting in the context of information systems.
Expert in handling various User Training in Financial Modules and created various document's at various stages as per project
scope under AIM methodology.
Technical Skills
ERP Suite: Oracle E-Business Suite R12/11.x; GL, AP, AR,PA,PO,AOL
Database Tools: SQL*Plus, SQL*Loader, Toad
Oracle Tools: Reports 10g/9i/6i, XML Publisher
Other Languages: SQL,PLSQL
Document Methodologies:MD.070, MD.050, TE020, BP040, BP080, BR100
Operating Systems: Windows XP/NT/95, DOS
Other Tools :- Jira,SVN
Testing Tools :- HPQC
Certification:- 1) Training of Oracle apps Functional
2) Completion of Business Analyst course (CBAP)
Professional Experience: 1) Maxima IT Consulting India Pvt ltd.
Designation :- Consultant
Period :- 24th Jan 2018 to till present
Responsibility :-
1) Coordinate with Development Team with new requirement gathering
2)
Attend the CAB meeting
3)
Look out on releases(Major or minor)
4)
Work on new Implementations
2)
Tieto Software Technologies Limited.
Designation : Oracle Apps Techno-Functional Consultant
Period :- 16th April 2013 to 3rd Jan 2018
Project Summary:
Client: -
Telenor
Description: - Telenor Group is a Norwegian multinational telecommunications company headquartered at Fornebu in Bærum, close to
Oslo. It is one of the world's largest mobile telecommunications companies with operations in Scandinavia, Eastern Europe
and Asia
Responsibility:1) Production Support(L3 level) and handle run time business process issue for Oracle application (AP,AR,GL,PA,PO,AME,Ebusiness tax)
2) Involved in Monthly Periodic Book Closure process of Sub-Ledger and General Ledger.
3) Conducting Conference Room Pilot (CRP) and User Acceptance Tests for implementations.
4) Worked on AME (Approval Management Engine)
5) Attend the Weekly meeting with client
6) Follow-up to Oracle SR
7) Prepared TE 40 (User Different Test Scenarios and Manuals)
8) Handle critical SR's (Business Impact) with Oracle On demand.
9) Developed FD's (MD50) for Inbound & outbound interfaces.
10) Prepared User Manuals for all financial Modules and Provided User Trainings
11) Support to on call issues while closing the periods.
12) Troubleshooting and Creation of SR's with Oracle for production support issues and the application of Patches and testing the
same in Testing and Development instance.
13) I am looking after financial areas of the Applications related Issues and resolving them on priority base, coordinating with
other team members (Functional/Technical) in case any help is required. And Responsible for updating and reporting status of the
issues on weekly basis. Getting help from the Oracle Meta link Team in case of Odd issues.
Environment:ERP: - Oracle Apps R12 AOL, GL, AR, AP, PO, PA, AME
Tool: - PL/SQL, Reports 10g/6i, XML Publisher
Internal Projects
a. FJ-BR Split
Scope: - Three companies were in one legal entity so we split three companies with three different legal entity.
Responsibility:1) Creation of documents like MD50,MD70,TE020
2) Create setup toolkit as per business process.
3) Apply the setup for AP, AR, FA, iProc , E-Business tax, AME
4) Setup call with user to get requirements.
5) Interface script creation for payable invoices and API script creation for Supplier Site and bank
6) Creation of toolkit and apply the same setup(AP,AR,FA,iProc,E-Business tax, AME)
7) Support to application after deployment.
8) Support to technical team to understand the requirements.
9) Handle the oracle SR for mostly complicated issues(MPP invoice issue).
10) Complete the work before time period.
b. AR Recurring
Scope: - Recurring invoices creation depends on contract template.
Responsibility:1) Handle the setup part of receivable
2) Creation of documentation like MD50, MD70, TE020.
3) Personalization on Receivable form with the use of custom.pll and form personalization
4) Creation of incomplete recurring invoice report and recurring print invoice report.
5) Handle the call with user in the aspect of requirement gathering.
6) Manage the require setup and development should be done in before time.
7) Support the process after development
8) Handle the transition period after the development.
c. Work on Proposal
Scope:- Pharmaceutical company proposal for use invoice matching process
Responsibility:1) Daily call with respective team for gather the requirement.
1) Work on how to reach the goal as per requirement
2) Make the strategical workarounds
3) Work with the team members
4) Handle the difficulties if any occur while gather the requirement
5) Creation the document after end the discussion
6) Send the daily MOM to respective team for discussed points
d. GST Implementation
Scope :- Implementing the GST as per Company taxation
1)
2)
3)
4)
Configuration of CGST, SGST, IGST and UGST tax procedure.
Configuration of Reverse charge tax procedure in GST.
Work on the Requirement Document and implementing phases
Configuration of TDS procedure.
3) Clover Infotech Pvt Ltd.
Designation: Oracle apps Technical Associate
Period :- 1st Mar 2012 to 15th Apr 2013
Expertise in:
Experience on financial module setup.
Creation of document as per development.
Experience of Development, Interfaces and Customizations of Oracle General Ledger, Accounts Payables,
Purchasing, Account Receivable, Inventory modules.
Designing & coding for Procedures, Packages, Functions in PL/SQL.
Experienced in developing & customizing Reports and Customization of forms by using the form
personalization.
Creation of AOL and sysadmin Objects.
Creation of value sets, profile options and request sets and scheduling the request set.
To use various pl/sql procedures and packages and methods in concurrent programs.
Knowledge on Procure to pay(P2P) and order to cash(O2C) cycle.
Project Summary:
Client:
HSBC
Description : The HSBC Bank offers a comprehensive suite of world-class products and services to its corporate and
commercial banking clients as also to a fast growing personal banking customer base.
Responsibilities
Handle the documentation and setup for payables.
Handling the call with user for requirement.
Development of Exception report in Account Payable.
Development of Procedure and function.
Aol and sysadmin Operation.
Customize the report in account payable.
Form Personalization on Invoice form of account payable.
Daily meeting with users for work completion
Propose the workaround.
Handle the transition period.
Environment: Account Payable
ACADEMIC TRAINING
a.i.1.
Oracle Apps Techno-Functional
Organization:
Blink Consulting
Specifications:
Oracle EBS Techno-Functional
a.i.2.
Business Analysis
Organization:
iBAT
Specification:
Certification of Business Analysis Program (CBAP)
ACADEMICS
*
*
*
*
*
Master in Business Administration From Eiilm university with First class.
PGDBM from Niilm school of Business with first class.
Bachelor of Science (PCM) from Nagpur University with Second class.
SSC from Maharashtra Board with second class.
HSSC from Maharashtra Board with second class.
PERSONAL PROFILE
Date of Birth
:
9th May 1987
Father’s Name
:
Mr.Rajesh Tarsekar
Gender
:
Male
Current Address
:
Rakshak Nagar,Pune
Languages Known
:
English, Marathi,Hindi
Declaration
I hereby declare that the above written information are true to the best of my knowledge and
I bear responsibility for the correctness of the above-mentioned particulars.
Date
Abhijit R. Tarsekar
Place: Pune
