Lokam Haranjaneyulu MBA

Oracle Financial Functional Senior Consultant (AR,AP,GL,FA,iproc)

Ph 469-***-****/:330-***-****, Email: adki7h@r.postjobfree.com

linkedin.com/in/haranjaneyulu-lokam-29b394151

Professional Summary

Accomplished MBA Professional with total experience of 12 years, of which 11 years in IT industry as an Oracle Applications Functional Consultant-Finance 11i/R12.

Worked extensively on General Ledger, Accounts Payable, Accounts Receivable and Fixed Assets.

Very good understanding of enhance features of R12, MOAC, Retainage release invoice, Third party payment, Payment Manager, AR Refund process, Balance forward billing invoice, Late charges, Data access set, AGIS, SLA, E-Biz Tax and GL Ledger definition.

Having good working experience in Data Conversions, Open invoices, master data loading and Trial Balance Report.

Documenting the Functional Specifications of requirements/Reports.

Hands on expertise in Business Requirements gathering, Requirements definition, mapping to future business models, solution design and testing deliverables.

Having good working experience in period close process and Year end process.

Used AIM Methodologies for various Functional designs-Setup, Test Scripts flows etc.

Possess a good understanding of key business cycles – Procure to Pay and Order to Cash.

Performed Functional Setups & Configurations, Test Case preparation & Test script execution and User Training documentation.

Participated in testing phases like System Testing, Integration Testing and User Acceptance Testing (UAT)

Certified Oracle E-Business Suite 12 Financial Management implementation specialist: Oracle Payables.

Ability to Co-ordinate with End users to build and maintain customer relationship and Technical teams for successful and timely delivery.

Skills and Areas of Expertise in AR/AP/GL/FA

oAR System Options, AR Receipts, Lockbox, Customer profile classes, payment terms, AR distribution sets, Auto Cash Rule Sets, Auto Accounting, Invoicing rules, accounting rules, Territories, Invoice Sources, receivable activities for miscellaneous receipts, finance charges, bank charges.

oRevenue Recognition Invoices to recognize the revenue over period of time, Auto-Invoice Import Process, Receipt creation method, receipt class, receivable activities, handling Refunds, Balance forward Billing invoice, Auto Lockbox.

oAssigned receivable account, revenue account, unbilled account, freight account, cleared account, and unearned account to transaction types, AP/AR Netting, Late Charges process.

Custom Customer invoice print templates, trained users on guarantees, deposit, credit memos

And Debit memos.

oInternal & External supplier Banks for payable use, Retainage release invoice, setup Special Calendar for Recurring Invoice, Payment Terms, Payment Attributes, and Payment Formats.

o Payable Documents, AME, financials options, payables System options, bank documents, expense report templates, invoice distribution, Tax Code, Tax group, Rates using E-Business Tax, Withholding Tax Setups, Payable Transfer to GL.

oPayment setups, Third party payments, trained users on Prepayment and refund process, MOAC Payment process profiles, Requests Formats, XML Publisher Templates and Bank accounts to facilitate the Check and EFT Payment process.

oInvolved with migration of historical data for Accounts Payables and Accounts Receivables.

oMaster Data and Transaction Data (FA and GL) migration using Application Desktop Integrator, Data loader and migration interface, testing for data migration

oConfigured and implemented Chart of Accounts, Value Sets, Ledger, Security Rules, Cross Validation Rules, Calendar, Journal Source, Journal Category, Setup General Ledger, and Secondary ledger, Re-valuation and Translation.

oGL Data Access Sets, Advanced Global Intercompany Systems, Resolve user’s issues in using WEBADI, Design and Implement GL Journal Entry Approval, Currency setups.

oDefined journal source, category, Recurring Journals, privileges for users, reporting currencies and document sequence.

Education

Degree

University

Pass %

MBA

Acharya Nagarjuna university (Regular)

62.5%

B.com

NAGARJUNA UNIVERSITY

64.86%

XII (10+2)

Board of intermediate, Andhra Pradesh

62.7%

X

Board of secondary education, ap

63.5%

Experience

Organization

Designation

Duration

Infosys Limited

Senior Consultant

(11/2017) – Till Date

Tech Mahindra

Team Lead

(12/2009) – (11/2017)

ICICI Prudential

Financial Service Consultant

(05/2006) – (05/2007)

Adecco Flexione workforce Solutions Ltd

Sales Promoter

(06/2005) – (01/2006)

Technical Skills & Trainings

ERP

Oracle Financials 11i/R12 – General Ledger, Accounts Receivable, Accounts Payable, Fixed Assets, Cash Management, System Administration.

Operating Systems

Windows 2003, Windows XP. Linux Red hat,

Languages

SQL,PL/SQL

Databases

Oracle 9i

Tools & Utilities

ADI, Web ADI, Toad, Data Loader.

SL# No

Trainings

Location

Organized by

Duration

1

Oracle Financials R12 (AP)

Hyderabad

Tech Mahindra

1 Week

2

Oracle Financials Cloud Implementation

Hyderabad

Tech Mahindra

1 Week

Projects Profile

9.

Project Name : GAIA Merger Exit KAI (On-Site) - Support

Client

One of the leading Japanese multinational conglomerate.

Role

Senior Consultant

Organization

Infosys, USA

Duration

(05/2020) – Till Date

Team Size

Project: 6

Module: GL, AP, AR,FA and CE

Description: This Project involves supporting EBS application Release 12.2.6 to the client Toshiba Memory America, Inc. It includes modules like General Ledger, Accounts Payables, Account Receivables, Fixed Assets and Cash Management.

Role and Responsibilities:

Participated in various kinds of issue resolution for financial functional issues. Involved in resolving the day-to-day issues, which are faced by Business users.

Analyzing the issues as per the ticket priority (Business critical, Urgent and Normal), attending the client calls/web ex meetings and providing timely resolution as per SLA time lines.

Coordinated with Business users to understanding the issue, Ensuring the delivery of the solution in production and taking the issue to closure.

Attended OWC Session with Oracle Support to resolve application issues, bugs and TAR/SR management. Provided inputs (AP list, Diagnostics, Trace file and error log files etc.) to Oracle support in Bug fixing.

Testing the solutions provided by oracle after patch/data fix applications.

Participated in Month end closing activities. Debugging the issues which are preventing period close and responsible for smooth period close.

Ability to handle the Re-conciliation issues between Sub-ledgers and GL.

Interacting with Business Users in understanding the Enhancement requirements.

Coordinating with Offshore team members.

Attending Weekly status meetings with Business users and HQ.

Responsible for supporting the application based upon the functional requirements of the client taking into their considerations by discussions, Teleconferences.

8.

Project Name : GAIA Merger Exit KAI (On-Site)

Client

One of the leading Japanese multinational conglomerate.

Role

Senior Consultant

Organization

Infosys, USA

Duration

(02/2020) – (04/2020)

Team Size

Project: 06

Module: GL, AP, AR,FA and CE

Description: This Project involves Merging of Oracle EBS application from 12.1.3 to Release 12.2.6 to the client Toshiba Memory America, Inc. It includes modules like General Ledger, Accounts Payables, Account Receivables, Fixed Assets and Cash Management.

Role and Responsibilities:

Involved in MOK Testing for AP, AR.

Handled below Activities during Go-Live

Handled configurations for AP and AR during GAIA merger

Conversion of FA Data using ADI Template.

Handled existing GL Balance Clean up

Handled GL Balance conversion using ADI Template

Co-ordinating with Technical Team in Master Data Conversion.

Validation of Master data and Open Invoice Transactions after Conversion.

Attending the Meetings and coordinating between onsite and Offshore.

Handling postproduction issues.

7.

Project Name : GAIA Merger (Other OSCs)

Client

One of the leading Japanese multinational conglomerate.

Role

Senior Consultant

Organization

Infosys, India

Duration

(11/2018) – (02/2020)

Team Size

Project: 06

Module: GL, AP, AR,FA and CE

Description: This Project involves Merging of Oracle EBS application from 12.1.3 to Release 12.2.6 to the client Toshiba Memory (Taiwan, Hongkong, China, Europe). It includes modules like Accounts Payable, General Ledger, Account Receivable, Fixed Assets and Cash Management.

Role and Responsibilities:

Solution design, mapping of client’s requirements to standard functionalities, identification of gaps and suggestions / work around.

Prepared Functional Design (BR100 & MD-50) documents for various Financial Modules.

Configuration/ Set-ups of GL, AP, AR, CE, FA, Preparation of test script (TE-040).

Testing the Financial Scenarios after configuration and preparing the TPDs.

Responsible to Provide resolution for the issues identified.

Documentation of issues and its resolutions.

Preparation of data conversion strategy, and uploaded GL Balances using ADI Template.

Preparation of data conversion strategy, and uploaded AR Open Invoice data using AR Uploader Template.

Preparation of data conversion strategy, and uploaded FA Data using ADI Template.

Created dummy payments for existing invoices as a clean-up activity.

Co-ordinating with Technical Team in Master Data Conversion.

Validation of Master data and Open Invoice Transactions after Conversion.

Responsible to Close the issues identified during the Conversion.

Helped Technical Consultants in preparing the conversions, documentation and helped them in preparing the reports by providing them with the functional aspects.

Prepared Solution Design Documents (SDD) for the GAPS identified.

Attending the Meetings, presenting the critical Issue resolutions and coordinating between onsite and Offshore.

Responsible for testing phases like System Testing, Integration Testing and User Acceptance Testing (UAT).

Creation and follow up of Technical Assistance Requests (TARs) with Oracle during setting up and testing of Development.

Preparation of Project Documentation, such as:

oTest plan document

oProcess flows for CRP

oFit GAP file

oData Extraction Templates for Conversion

oSystem Landscape document.

oTest Proof Documents

oUser Manuals.

6.

Project Name : : Oracle EBS upgrade from 11.5.10 to Release 12.2.6

Client

One of the leading Japanese multinational conglomerate.

Role

Senior Consultant

Organization

Infosys, India

Duration

(12/2017) – (10/2018)

Team Size

Project: 15

Module: GL, AP, AR,FA and CE

Description: This Project involves Oracle EBS application upgrade from 11.5.10 to Release 12.2.6 to the client Toshiba Memory America, Inc. It includes modules like Accounts Payable, General Ledger, Account Receivable, Order Management, Purchasing, Expenses. The BI module of the project provides reporting capability to the different departments of the Client while maintaining his Data warehouse and enables the management in making quick decisions by providing most up-to-date data in the reports on a regular basis It also includes supporting the client in the regular SIT and UAT issues and to work on the resolution of bugs encountered during R12 upgrade, undertaking systems study and carrying out technical discussion for the purpose of new systems development.

Role and Responsibilities:

Responsible for Successful upgrade of Finance modules like GL, AP, AR and FA

Prepared the Process List and Setup Document (BR100) for Finance Modules (GL, AP, AR and FA).

Responsible to completed the Pre-upgrade functional activities.

Performed Post-Upgrade functional activities.

Performed sanity testing after upgrade and responsible to provide the resolution for the functional issues identified.

Worked in various issues identified in CRP and responsible for fixing the issues.

Provided Functional inputs to the Technical Consultants in fixing the issues.

Performed rigorous testing during CRP, UAT, SIT Phases for multiple Operating Units.

Overseeing the UAT and assisting the Key users.

Creation and follow up of Technical Assistance Requests (TARs) with Oracle during upgrade and testing of Development.

Attended OWC Session with Oracle Support to resolve application issues, bugs and TAR/SR management. Provided inputs (AP list, Diagnostics, Trace file and error log files etc.) to Oracle support in Bug fixing.

Testing the solutions provided by oracle after patch/data fix applications

Documentation of issues and its resolutions.

Attending the Meetings, presenting the critical Issue resolutions and coordinating between onsite and Offshore.

Conducted training session to Technical Team members on Financial Modules.

Conducted Training sessions for OATS Team to develop the OATS Scripts on Various Financial Modules like GL, AP, AR and FA.

Provided the inputs/worked on the issues raised by OATs team.

Preparation of Project Documentation, such as Test Scripts, TPDs, User Manuals and Setup Documents.

Co-coordinating with Technical Team while retro fitment of reports.

Performed Reconciliation between 11i and R12 Reports after upgrade.

5.

Project Name : Global Business Services (Support)

Client

General Electricals

Role

Team Lead

Organization

Tech Mahindra, India

Duration

(09/2014) – Till Date

Team Size

Project: 10

Module: GL, AP, AR,FA and CE

Project Description (Support)

Global Business Services is a leading Finance, Employee and Administration shared service provider for GE businesses. GBS has centers across various countries in Asia, Europe, and America providing Accounts Payable, Payroll, Travel & Living, Administration, Visa processing, Fiscal processing and Legal entity compliance services to enable GE business to operate efficiently and maintaining the highest levels of Integrity and Controllership. GE GBS is a service provider organization to the internal GE businesses e.g. GE Healthcare, GE Energy, GE Wind etc. They are into the business of providing accounting and other services within and outside GEGBS Asia Pacific countries. GE GBS Project involves bringing of multiple GE operating legacy systems into single platform – ‘Oracle’ to have better maintenance and control over the accounting and event transactions.

Contribution

Participated in various kinds of issue resolution for financial functional issues. Involved in resolving the day-to-day issues, which are faced by the end users.

Analyzing the issues as per the ticket priority (Business critical, Urgent and Normal), attending the client calls/web ex meetings and providing timely resolution as per SLA time lines.

Attended OWC Session with Oracle Support to resolve application issues, bugs and TAR/SR management. Provided inputs (AP list, Diagnostics, Trace file and error log files etc.) to Oracle support in Bug fixing.

Testing the solutions provided by oracle after patch/data fix applications.

Ensuring the delivery of the solution in production and taking the issue to closure.

Helped Technical Consultants in preparing the conversions, documentation and helped them in preparing the reports by providing them with the functional aspects.

Coordinated with core Business users in configuring the new set-ups and updating the existing set ups upon receiving the Site Controllers approval.

Participated in Month end closing activities. Debugging the issues which are preventing period close and responsible for smooth period close as per the period close Calendar and loading the Daily rates (MOR, GLMOR and GAP) for next open period.

Involved in Yearend closing process. Performed P/L Rollover and 1/1 Roll-over in ADJ period as per GE Process.

Ability to handle the Re-conciliation issues between Sub-ledgers and GL.

Conducted Training sessions to new users on financial modules.

Prepared support central cases report set up the MR to discuss the tickets status on weekly basis.

Responsible for supporting the application based upon the functional requirements of the client taking into their considerations by discussions, Teleconferences.

4.

Project Name: GBS Enhancements

Client

General Electricals

Role

Team Member

Organization

Tech Mahindra, India

Duration

(10/2012) – (08/2014)

Team Size

Project: 6

Module: GL, AP, AR and FA

Project Description

Global Business Services is a leading Finance, Employee and Administration shared service provider for GE businesses. GBS has centers across various countries in Asia, Europe, and America providing Accounts Payable, Payroll, Travel & Living, Administration, Visa processing, Fiscal processing and Legal entity compliance services to enable GE business to operate efficiently and maintaining the highest levels of Integrity and Controllership. GE GBS is a service provider organization to the internal GE businesses e.g. GE Healthcare, GE Energy, GE Wind etc. They are into the business of providing accounting and other services within and outside GEGBS Asia Pacific countries. GE GBS Project involves bringing of multiple GE operating legacy systems into single platform – ‘Oracle’ to have better maintenance and control over the accounting and event transactions.

Contribution

Rolled out 18 ledgers for Asia Oracle for 14 Countries covering finance modules GL, AP, AR & FA

Analyzed the business systems, business process requirements and future needs.

Designed customized reports, fit gap analysis, and all documentation and deliverables.

Collection of the necessary master data, Solution design, mapping of client’s requirements to standard functionalities and setting up (application setup) all the financial modules in Test and Production instances to meet the requirements of client.

Preparation of data conversion strategy, data conversion into Production Instance.

Uploaded the data through Data Loader, Open invoices, master data and TB report.

Helped Technical Consultants in preparing the conversions, documentation and helped them in preparing the reports by providing them with the functional aspects.

Tested Sub-ledger integration for procure to pay and order to cash cycles.

Demonstrated Sub ledger Accounting (SLA) functionality and Create Accounting program to streamline month end close process and check sub ledger journal entries before transfer to General Ledger.

Modification in the solution design based on the test results analysis, final testing and sign off.

Preparation of Project Documentation, such as Test Scripts, Standard Operating Procedures, Training Material and Setup Documents.

Overseeing the UAT and assisting the Key users.

Assisted the Client with Operational problems, concerns, Reconciliation and Execute tasks for Go-Live activities

3.

Project Name: GBS (Implementation)

Client

GE

Role

Team Member

Organization

Tech Mahindra

Duration

(07/2011) – (09/2012)

Team Size

9

Module: GL, AP, AR and FA

Project Description

GBS is a leading Finance, Employee and Administration shared service provider for GE businesses. GBS has centers across various countries in Asia, Middle East and America providing AP, Payroll, Supply Chain Legal entity compliance services to enable GE to operate efficiently and maintaining the highest levels of Integrity and Controllership.

Contribution

Responsible for configuring GL, AP, AR and FA, modules.

Solution design, mapping of client’s requirements to standard functionalities, identification of gaps and suggestions / work around.

Prepared data conversion reports, and uploaded data using Data load software.

Attending the Client’s Meetings and presenting the critical Issue resolutions.

Tested Sub-ledger integration for procure to pay and order to cash cycles.

Actively involved in Conference Room Pilot (CRP) for financials modules like GL, AP, AR, and FA modules.

Prepared Functional Design (BR100 & MD-50) documents for various Financial Modules.

Responsible for testing phases like System Testing, Integration Testing and User Acceptance Testing (UAT)

Handled Post Production Issues.

2.

Project Name: ZA Lighting Implementation

Client

GE

Role

Team Member

Organization

Tech Mahindra

Duration

(11/2010) – (06/2011)

Team Size

9

Module: GL, AP, and AR

Project Description

GE has its lighting division across the world & they carry all their operations through Oracle Applications. GE GBS is a service provider organization to the internal GE businesses e.g. GE Lighting, GE Healthcare, GE Energy, GE Wind, etc. They are into the business of providing accounting and other services within and outside GEGBS Asia Pacific countries. GBS Project involves bringing of multiple GE operating legacy systems into single platform – ‘Oracle’ to have better maintenance and control over the accounting and event transactions.

Contribution

Actively participated in implementing and support of Financial Modules

Prepared the ‘To Be’ business process flows based upon the existing business practices and business requirement scenarios.

Mapped business scenarios, and identified the high-level gaps (BR-030).

Collecting inputs and providing the functional specifications in the form of MD-050 to technical team to develop custom reports.

Configuration/ Set-ups of GL, AP, AR, CM, FA, Preparation of test script (TE-040).

Prepared Standard Operating Procedures/User manual for all the financial Modules.

Creation and follow up of Technical Assistance Requests (TARs) with Oracle during setting up and testing of Development.

1.

Project Name : Middle East Implementation

Client

GE

Role

Team Member

Organization

Tech Mahindra

Duration

(12/2009) – (10/2010)

Team Size

7

Module : GL, AP, and AR

Project Description: GBS has centers across various countries in Asia, Europe, Middle East and Africa and America providing Accounts Payable, Payroll, Travel & Living, Administration, Visa processing, Fiscal processing and Legal entity compliance services to enable GE business.

GBS Project involves bringing of multiple GE operating legacy systems into single platform – ‘Oracle’ to have better maintenance and control over the accounting and event transactions.

Contribution:

Responsible for implementation of Financial Modules.

Configuration of GL, AP, AR, FA, Preparation of test script (TE-040).

Responsible for open data loading.

Mapped business scenarios and identified the high-level gaps (BR-030).

Tested Sub-ledger integration for procure to pay and order to cash cycles.

Collecting inputs and providing the functional specifications in the form of MD-050 to technical team to develop custom reports.

Prepared Standard Operating Procedures/User manual for all the financial Modules.

Responsible for raising the TAR/SR to handle Post Production issues.

Personal Details:

Name

Lokam Haranjaneyulu

Email Id

adki7h@r.postjobfree.com

Type of Visa holding (if any)

(H1-B)

Valid Upto: (05/2023)

Location

Irvine, California, USA - 92614

Contact Numbers

Home: 469-***-****/330-***-****

Contact this candidate