Arun Prasad. M

 ~ Oracle EBS Finance Functional Lead ~

Professional Snapshot

Ä MBA in Finance from Indian Institute of Science, Bangalore. Close to 10 years of experience in Business Analysis, Management / Client Interaction, Requirement Gathering, and IT Management.

Ä Currently associated with Infosys Ltd as Oracle Financials Consultant, deputed in US since May’13, handling direct US clients.  

Ä 7+ years’ experience in working in Oracle EBS R12 Financials (GL, AP, AR, FA, OLFM, iExpense, Cash Management), including 0.5 years in Oracle Hyperion BI application.

Ä 0.5 years’ experience as SDA Lead (Finance Consultant), to provide Tax Reconciliation data for IRS audit purpose.

Ä Adept in coordinating with Project Managers, Clients and other departments / teams to ensure smooth execution / completion of the project with in the stipulated time frame, with significant cost benefits to the client.

Ä Handling lead roles – Interact with client to understand resource requirement for project, interview and allocate best-fit resources, assign task and monitor performance of the resources per management requirement.

Ä Handling and playing pivotal roles on Oracle Implementation projects through various phases from Requirement gathering to Go Live support including delivery and testing.

Ä Excellent communication, analytical, presentation, negotiation & relationship management skills with proven ability to build healthy relations with business partners and customers.

Competencies Overview

Ä  Responsible for handling the complete project right from designing the scope of the project to delivery of the final analysis.

Ä  Understanding the business needs and identifying initiatives that will allow a business to meet those strategic goals.

Ä  Mapping Business Requirements (As-Is & To-Be Analysis). Examining, reporting, recommending improvements on adequacy & effectiveness of management’s risk management processes.

Ä  Reviewing and editing data to ensure completeness and accuracy of information; performing follow ups with subjects to resolve problems or clarify on the data collected / collated.

Ä  Preparing and presenting research reports comprising of industrial trends, industry information and govt. policies; interpreting the result of research studies and providing business recommendations.

Ä  Understanding business problems of clients and translating them in to research problems. Providing clients with the precise required inputs for business decisions and future planning.

Ä  Serving as key liaison between Clients and Internal Support Teams for executing research

Ä  Handling business development activities like identifying potential clients, getting more projects from the existing clients.

Employment Scan

 Since Nov’10 with Infosys Limited., as Oracle Financial Functional Consultant

The Role

Ä  Worked predominantly for manufacturing clients.

Ä  Worked in Oracle R12 support and R12 upgrade/implementation projects.

Ä  Worked in R12 version upgrade from 12.1 to 12.2 involving Financials and OLFM modules.

Ä  Experienced in R12 versions 12.0, 12.1 and 12.2

Ä  Adept in working across GL, FA, AP, AR, iExpense, Cash Management and OLFM modules. Along with it, possess good experience in EB Tax, Oracle Order-to-cash flow and SLA feature.

Ä  Worked predominantly in Oracle Order to Cash Flow – Handling multiple client requirements in this cycle.

Ä  Working as a SDA (Structured Data Archiving) lead for providing Tax reconciliation data for IRS audit purpose.

Ä  Trained in Oracle Fusion Financials Cloud.

Project Details:

Project1: Finland based Global leader in environmental and industrial measurement (Nov’10 – Dec’12): R12 Finance Functional Support

Ä  Worked as offshore finance functional lead managing across finance modules, also touching upon OM, PO and CRM modules. During this period, also handled the rollouts and transition to support for the same client across US, APAC, Europe and Australia. This is into R12.0.6

Ä  Provide solutions for Finance issues within dedicated SLA & providing critical monthend support for older and newer Orgs.

Project2: World Leader in diversified manufacturing (Jan’13 – Nov’13): R11 to R12 Finance Upgrade project.

Ä  Worked on 11i to R12 upgrade project, involving moving the finance modules - GL, AP, AR and FA to R12 version, which included data extraction, conversion and interfacing and validation of trial balances on these modules.

Ä  Created and maintained BR-100 for above modules and making relevant changes to the same based on changing business requirements, post setup and validation in R12 instance.

Ä  In addition to that, worked on implementing the changes to the Oracle Hyperion BI application, mirroring the Oracle upgrade, creation of web forms, aligning calculation scripts and design of smart view reports to extract P&L and Balance sheet information for varying business needs.

Project3: A Large global Water Technology provider(Dec’13-Dec’13) – R12 Financial Post Production support

Ä  Worked for a brief period providing post production support on R12 – AP, AR, CE and GL module and helped the first month end close.

Project4: World’s leading provider of heating, ventilation, air conditioning, and refrigeration solutions for residential, industrial, and commercial applications (Jan’14-Jul’14) – R12 Finance Implementation Project

Ä  Worked in R12 implementation project (AP,AR, GL and Cash Management)– Responsible for requirement gathering, Fit-Gap Analysis, design of MD-50 for interfaces(AP/AR invoice, Customer/Supplier Interface).

Ä  With multiple Orgs live from Legacy as part of project, traveling to individual sites for coordination of various phases of testing (CRP/SIT/UAT/GO Live) and gathering additional requirement from multiple sites & ensuring timely closure of the same.

Ä  Also created UPK document for AP/AR/GL module s to enable end user training.

Ä  Acting as individual onsite spoc for the project handling all activities, coordinating with offshore team, client managers, legacy team, users and offshore managers for critical deliverables and ensuring timely delivery.

Ä  Provided post Go Live support for one month and ensured smooth period close. This is R12.1.3

Ä  Completed implementation per client timelines, with 0% delay in delivery.

Project5: World's largest manufacturers of brand- name products for the home improvement and new home construction markets (Jul’14-Aug’14) – R12 Production Support

Ä  Working as an onsite finance functional consultant for AR and GL modules predominantly and also on enhancements and new project – requirement gathering and MD050 creation.

Ä  Fix Issues within dedicated timeline and providing month end support.

Project6: A Fortune 50 company, a technology leader and the world's largest manufacturer of construction and mining equipment, natural gas and diesel engines, and industrial gas turbines(Sep’14 – May’17)

Ä  Handling lead roles – Interact with client to understand resource requirement for project, interview and allocate best-fit resources, assign task and monitor performance of the resources per management requirement.

Ä  Working as an onsite finance functional consultant for OLFM, AR, AP, GL, FA, SLA, CE modules predominantly and also on enhancements and new project.

Ä  Handling implementation activities from requirement gathering to Go-Live, including CRP, SIT and UAT testing on 12.1 to 12.2 Project.

Ä  Collect Business requirements for new enhancements, Work with offshore technical team to develop, test the enhancements & deliver to client with agreed timeline.

Ä  Handling Monthly Release management and support transitions.

Project7: A multinational conglomerate headquartered in Cork, Ireland that produces automotive parts such as batteries and electronics and HVAC equipment for buildings (Jun’17 – till date)

Multiple Roles

Oracle Financials Lead

Ä  Support & Enhancement of Oracle Financial Applications R12.1.3 - GL,AP, AR, FA, CM, EBTax & SLA

Ä  Understanding the business requirement, Creation/ Updation of relevant BR100, MD050 documents for existing & new implementations.

Ä  Functional Testing on monthly releases.

Ä  Enabling smooth monthend process as well as managing interfaces from and to EBS application

SDA Lead- Tax reconciliation for IRS audit

Ä  Preparing reconciliation between HFM data & corresponding ERP source GL transaction data using Hadoop as the data processing system. 

Ä  It involves understanding the mapping between source ERP(Consisting of ERPs such as Oracle, SAP, iScala, Mapics Lawson, Symix etc) as well as the presence of manual sources feeding financial information to HFM.

Ä  Gathering mapping, source ERP data, manual feed data and HFM balances data from finance business analyst/ process owners.

Ä  Providing mapping requirement to technical analyst for coding.

Ä  Performing functional Testing & initiating reconciliation activities.

Ä  Evaluation of extent of reconciliation at legal entity level and identifying gaps to improving the reconciliation.

Ä  Sharing the reconciliation data to the finance/ tax business analyst for their feedback.

Ä  Sharing the final reconciliation audit data in the IRS-required format to finance/ tax manager for IRS audit.

Preceding Assignment

May’09-Nov’10 with TCS E-Serve Ltd., Chennai as Assistant Manager

The Role

Ä  Understanding US mortgage market operations – Prime Foreclosure. Preparing daily MIS reports through managing deliverables across Chennai & Mumbai.

Ä  Handling a team of 15 members, performing quality checks on team members and providing them feedback / training based on the same. Conducting appraisals for team members.

Ä  Working with clients to enhance process performance by handling exception reports, providing regular process updates to the team and preparation of process update bulletins.

Ä  Analyzing loan database to identify the needs in process improvement using statistical methods with extensive usage of excel functions like pivot tables, charts and reporting of the same to senior management.

The Highlights

Ä  Adeptly handled COPC, TPISA audit deliverables with stringent deadlines. The process got “Re-certified in COPC” and cleared TPISA audit requirements by end of Dec’09.

Ä  Ensured stability of process metrics like quality, UPT, bond factor, schedule adherence, etc. under ramp-ups.

Ä  Maintained the attrition rate within the specified target.

Ä  Drove the process improvement initiatives and completed domain certifications.

Ä  Ensured Foreclosure process turnover rate above 3% at all times. Designed and implemented improvised format for MIS.

Ä  Built various tracking tools in Excel to track the status of client requirements, team performance, etc.

Jul’06-Jul’07 with Cognizant Technology Solutions, Chennai as Programmer Analyst

The Highlights

Ä  Effectively designed & maintained a software system for the client “UHG” with back-end as AS/400 platform & RPG/400 and CL programming.

Ä  Designed program templates, which reduced coding time by 30%. Adeptly completed domain certifications, designed program code template. Completed CCP on Healthcare.

Ä  Prepared Business KT document through analysis of program codes.

Summer Internship

Company:                      ING Vysya Bank Ltd.                              

Title:                               To study impact of Optionality on the pricing strategy of term deposits at ING Vysya Bank Ltd. (IVBL)

Duration:                        3 Months / May – July’08

Department:                    Market Risk Management

Responsibilities:

-          Determination of Pre-closure patterns of term deposits and fitting a model to describe the same by performing a thorough data analysis using Microsoft Access and Excel.

-          Predicting the expected level of pre-closure for the next quarter.

-          Analysis of various option models for determining the option premium for pre-closure of term deposits and hence a brief study of Client behavior on pre-closures.

-          Identification and reporting of the impact of option costs on pre0closures in the balance sheet of the bank under the current interest rate cycle.

Projects & Papers

Ä  Term Paper:

o    To understand status of implementation of BASEL-II Standards at Vijaya Bank by analyzing its financial reports and comparing it with RBI requirements.

o    To understand the performance of HDFC Growth fund in comparison with CNX 100 and NIFTY using various portfolio management metrics like sharpe ratio, information ratio, etc.

Ä  Project on / to:

o    Forecasting GDP and 3-month T-Bill rates using Time Series Methodology.

o    Study the practical implications of Managerial Economics in the Garment industry.

o    Patent landscaping of Security in High Performance Buildings for Siemens which comprised of comprehensive patent analysis using USPTO.

o    “Eigen Value Assignment for Linear Time Varying Systems using Spectral Theory”.

Ä  Analyzed and prepared a report on Economic Survey of 2008-09.

Ä  Project on Technology Adoption

o    Description: Research to identify various factors influencing technology adoption and utilization through literature survey and compare it with actual factors influencing CAD technology adoption obtained through discussions with managers of SME manufacturing industries. Identifying interdependency of these factors which would have an impact on adoption of technology.

Scholastics

Ä  MBA in Finance from Indian Institute of Science, Bangalore in 2009 with CGPA 6/8 (First Class).

Ä  B.E. (Electrical & Electronics Engineering) from CEG, Anna University, Chennai in 2006 with CGPA 8 /10 (Distinction).

Ä  HSC (TN) from DAV Mat School, Chennai in 97.7% in 2002. Among top 5 in School, 100% in Maths & Chemistry.

Ä  SSC (CBSE) from Adarsh School, New Delhi in 2000 with 84.6%. School Topper in Maths.

IT Skills

Ä  Oracle EBS R12,11i Financials, OLFM

Ä  Oracle Hyperion BI application

Ä  Hadoop, Big Data

Ä  Hive & Beeline using Putty

Ä  SQL, Toad

Ä  Microsoft Office Tools

Trainings Attended

Ä  Trained in Oracle 11i and R12 applications in finance modules and also client consulting. Completed internal certifications on the same.

Ä  Received trainings in OM and Purchasing modules.

Ä  First Time Manager as part of TCS E-serve initiative.

Ä  Yellow Belt Training as part of TCS E-Serve initiative.

Ä  Advanced Excel training.

Ä  Max Plank - IISc International Conference on Economics held at IISc during October 2007.