Customer Service Management

A RUNASISH S IRCAR

***** * * * * B E R RY P L A C E, O A K T O N, V I R G I N I A 22124

F INANCE P ROFESSIONAL

Area of Focus: Finance, Performance Management& Implementation of Oracle Financials

Extensively experienced, dedicated, and goal oriented professional with over 10 years of strong functional experience and 8

years of business performance management experience and Oracle Financials functional implementations. Demonstrates track

record in leading the preparation and analysis of financial reports to summarize and forecast corporate financial position, as

well as implementing Oracle Financial modules, such as GL, AP, AR, FA, and CE using AIM methodology. Possesses

advanced knowledge in developing project plans, performing gap analysis, writing functional specifications, as well as

implementing Oracle applications, testing, Go Live support and post production support. Adept in driving efficiency and

productivity through evaluation of financial management systems as well as process improvements during implementation.

Exemplifies wide ranging knowledge in performance management, scorecard and financial metrics, budgeting and forecasting,

goal setting and creating Crystal Xcelsius dashboards. Recognized by owners, shareholders, and executives as a strong business

leader and trusted advisor regarding Accounting and Finance matters. Possess outstanding oral and written communication

skills; capable of interacting with all kinds of clients in all settings.

A R E A S O F E X P E R T I S E

PROJECT PLANNING GAP ANALYSIS ORACLE APPLICATIONS PROCESS IMPROVEMENT PROJECT MANAGEMENT BUSINESS DEVELOPMENT &

RETENTION FINANCIAL RESEARCH AND ANALYSIS GENERAL MANAGEMENT FIRST CLASS CUSTOMER SERVICE BUDGET PREPARATION &

ADMINISTRATION STAFF TRAINING & DEVELOPMENT REPORTING & DOCUMENTATION ACCOUNTS PAYABLE/RECEIVABLE PROBLEM

RESOLUTION FINANCIAL RECONCILIATION TACTICAL PRIORITIZATION

P ROFESSIONAL E XPERIENCE

ORACLE FINANCIALS EBS R12 SENIOR CONSULTANT

CedarCrestone Inc., Senior Consultant Jan 2012 – Present (Full time)

City of North Las Vegas, NV, (Upgrade to R12 from 11.5.10, Jan 2013 – Jun 2013)

Conducted several knowledge transfer sessions for Oracle R12 General Ledger (GL), Subledger Accounting (SLA),

Cash Management (CE), and Fixed Assets (FA).

Carried out all the pre and post upgrade tasks for GL, FA, SLA and CE.

Designed and implemented a custom SLA solution for Accounts Payable (AP) to Fixed Assets integration.

Made configuration changes to CE and FA as per client requirement. Conducted training sessions to test various

scenarios for the GL, FA, CE modules.

Developed various FSG reports as per the requirements of various departments within the City.

Led team of three members to accomplish all tasks on schedule and within budget.

Javits Convention Center of New York, (new Implementation EBS R12, Mar 2012 – Dec 2012)

• Identified business requirements and mapped them to the Oracle Application functionality through workshops on

Cash Management (CE), E Business Tax, and Accounts Payable (AP) modules.

• Designed solutions and configured AP, CE and E Business Tax to satisfy the business requirements.

• Participated in the development of the reports, Interfaces and Conversions.

• Developed test scripts, completed functional, interface, workflow design and documentation and user training

materials for conference room pilot sessions.

• Supported clients with the execution of test scripts and developed end user documentation and training materials.

City of Las Vegas, NV, Senior Functional Consultant – (Support EBS R12, May 2012 – June 2012)

• Documented processes for year end close and resolved various issues pertaining to year end close and period end

close.

• Conducted workshops on Accounts Payable (AP) and Subledger Accounting (SLA).

1 P a g e

A RUNASISH S IRCAR

10155 T U R N B E R RY P L A C E, O A K T O N, V I R G I N I A 22124

Trained user on the new ways of dealing with exceptions encountered during period close for AP.

•

Managed a team of 2 members who assisted in documentation, test scripts, testing and training users.

•

City of Chandler, AZ, Senior Functional Consultant – (New features implementation, Feb 2012 – Mar 2012)

• Designed, tested and documented the new secondary ledgers after detailed discussion with the client and also brought

in previous years data to cater to the new reporting requirements.

• Fixed issues with existing Financial Statement Generators (FSGs) and also designed and tested new FSGs. Designed,

tested and documented the Subledger Accounting (SLA) after detailed discussion and demo for the client in the

process of gathering requirements for SLA.

•

ORACLE FINANCIALS EBS R12 SENIOR CONSULTANT

Centium Consulting Mastec Inc. Atlanta, GA Sep 2011 – Dec 2011(Contract)

Interacted with business customers to understand and document their business processes and requirements.

Conducted a workshop/demo on how Subledger Accounting works and what are the benefits.

Completed functional setups for Oracle iExpense, AP, GL, AR, FA & CE modules after rigorous multiple testing

cycles documenting any issues, resolutions and points to consider.

Configured and Tested Multi Org Setups, Data Definition Set, Security rules and Data Access Set.

Conducted UAT and CRPs to test all business scenarios as per the Test Plans and documented any proposed changes/

enhancement requests within the scope of the project.

Assisted with configuring Project Costing and loading projects data through data loader.

Worked with business users, developers and Oracle Support to research and resolve Oracle system issues.

Created various FSG’s across divisions and departments – tested and incorporated changes to suit the needs of the

client.

Demonstrated new features in R12 including Multi Org, Data Access Sets, Data Definition Set, Line Level

Application etc. and how they can take advantage of it.

ORACLE FINANCIALS EBS R12 SENIOR CONSULTANT

Oracle Consulting. K12 Inc. Reston, VA Jan 2011 – Aug 2011(Contract)

Administered business requirement definition and gap analysis, and defined business processes, setups, and test

scenarios for Oracle Financial modules.

Configured Mass Allocation, Recurring Journals, Cross Validation rules and Security rules additionally as part of the

GL Setup.

Configured GCS (Global Consolidation System) to consolidate balances from Dubai Ledger, Netherlands Ledger, the

Swiss Ledger, the US Corporate Ledger and the US School Ledger to the Consolidated Ledger under multicurrency

and multiple COA situations in a two stage Consolidation.

Created Accounting Flex Field Structure; Chart of Accounts; Set of Books, Budget Upload from legacy systems using

SQL LOADER. Created Master/Detail Budgets, Mass Allocations and Summary Templates. Tested Translation,

Revaluations, and Consolidation features. Designed FSG Report for Budget Balance, Actual Balance, and Funds

Available.

Configured Intra and Intercompany relationship amongst various entities and ledgers.

Created various FSG reports of more than 100 columns for Gross Margin Profit Analysis, Sales Revenue Analysis,

different P & L and Balance Sheet Views and other reports as per business requirements.

Conducted CRP with business process scenarios and captured key requirements during CRP sessions.

Completed functional setups as required for implementation of Oracle iExpense, AP, GL modules and also created the

BR 100 documents.

Completed the Multi Org Access Control, Ledger Set and Data Access Set setups throughout the Corporate and

School Ledgers.

2 P a g e

A RUNASISH S IRCAR

10155 T U R N B E R RY P L A C E, O A K T O N, V I R G I N I A 22124

Created SRs and conducted OWC sessions for problem resolution. Designed training manuals and delivered training to

the users.

Transferred Knowledge, coached, and mentored other consultants under post production support requirement.

Assisted in the development of management decision documents for business process changes or re engineering

efforts, which also identified the pros and cons of the new processes, roles, and responsibilities, versus the current

processes, roles, and responsibilities.

ORACLE FINANCIALS EBS R12 SENIOR CONSULTANT

Enrich IT ALTICOR Ada, MI Aug 2010 – Dec 2010 (Contract)

Administered business requirement definition and gap analysis, and defined business processes, setups, and test

scenarios for Oracle Financial modules.

Configured Account Derivation rules and the Journal Line Definitions as per clients requirement to utilize the

Subledger Accounting (SLA) features in R12

Designed, developed, configured and tested Journal Approval procedure in General Ledger.

Configuration changes made to Production instance in Payables and Fixed Assets module as desired by business after

thorough testing in different instances and gaining requisite approval as part of the process

Involved in performing User Acceptance Testing for Oracle upgrade from 12.0.4 to 12.1.2 Oracle Financials Modules

like Accounts Payable, General Ledger and Fixed Assets.

Resolved defects and issues and raised SRs where necessary in preparation for Go Live.

Worked on production related month end issues and assisted with problem resolution.

Participated in reconciliation between General Ledger and all other subledger modules in Finance and data cleanup

activities.

Prepared BR 100 Configuration documents for GL, AP, FA Modules and user procedures for CE Module.

Trained super users in AP, GL, FA, AR and CE and also created detailed user manual.

Developed Test Plan / Test Cases and conducted User Acceptance Testing (UAT) sessions.

Fixed issues in test environments and interacted closely with users for final testing before solution migration to

production.

Implemented security rules in Oracle EBS to ensure company policy is followed after several discussions with client

Management.

Provided users with access to multiple ledgers in GL through the use of GL Data Access Sets and access to multiple

operating units through security profiles in a secured environment.

Discussed the possibilities with secondary ledger and the reporting currency feature.

Created the Responsibilities for all the ledgers.

Participated in discussions on Subledger Accounting and how it can benefit the client – also did a demo to

demonstrate the features that SLA provides.

SENIOR PRINCIPAL CONSULTANT

Rapid Budgeting Washington, DC Feb 2009 Jul 2010 (Contract)

Created and implemented annual budgets to include profit and loss, balance sheets, and cash flow statements for

different clients; established a variety of reports and Xcelsius dashboards for budgets and forecasts, including KPIs to

assist in management’s decision making process.

Developed the detail understanding of the Organization Structure, Chart of Account Structure Financial & Accounting

Management and suggesting changes.

Rendered assistance to client management in the enhancement of company’s annual budget and operating plan;

managed the timely maintenance of budget against actual expenditures throughout the year.

Devised timelines and deliverables and fabricated standards and procedures to create an effective workflow process in

order to complete budget activities within time constraints; prioritized prerequisites to meet and exceed customer

specifications and to enhance software development.

3 P a g e

A RUNASISH S IRCAR

10155 T U R N B E R RY P L A C E, O A K T O N, V I R G I N I A 22124

Identified the needs of the finance team, budget owners, and upper management, and instigated the resolution of needs

being met in the financial system; re assessed and documented high quality functional, technical, security, and report

requirements; and tendered innovative and economical solutions to a range of complicated problems.

Supported the infrastructure development through modifying and validating new assessment methods, measures, and

procedures.

SENIOR CONSULTANT

ISA Consulting Bluebell, PA Aug 2008 Dec 2008

Oversaw mapping business processes to ERP modules and conducted functional analysis, requirements gathering, and

ERP module configuration and testing; designed and operated financial reports through the use of FSG tool; and

trained users on various processes, such as AP, AR, GL, and CM (Release 12) while creating a detailed user manual.

Generated reports and dashboards in OBIEE through utilization of business process knowledge of procure to pay, GL

chart of accounts, profit management and financial reporting.

Tendered support and resolved critical issues for budgeting and forecasting models for clients; conducted design

development and made decisions on data deployment and collection in a team.

Created and tested corporate book, asset categories, system controls, and flex fields in fixed assets module.

Involved in the design and configuration of chart of accounts, accounting periods and accounting calendar for each

legal entity.

Conducted analysis focusing on the development of creative solutions, delivering substantial results to clients;

evaluated business needs, user requirements, and functional specifications; and demonstrated an understanding of the

client’s strategic direction, issues, and project goals in order to deliver exemplary customer service.

PERFORMANCE MANAGEMENT CONSULTANT

Data Management Group Springfield, VA May 2007 Jul 2008

Spearheaded the implementation of budgeting and forecasting applications and Xcelsius dashboards for Department of

State (Office of Public Diplomacy) used by U.S. Consulates from all over the world; carried out in depth analytical

reviews on existing financial and budgeting processes to align them with functional and technical requirements of the

software (Business Objects Planning), resulting in enhanced efficiency and effectiveness.

Organized and applied strong and effective financial modeling skills, and constructed Xcelsius visualization models to

include “what if” analysis that altered the performance of various departments, resulting in operational efficiency.

Provided help in the development of client information management standards and evaluation of technology trends;

assisted in the employee review and assessment procedures.

Devised complex financial reports for forecasting, trending, and results analysis; conducted unit testing and user

acceptance testing while training users; engaged and learned Earned Value Management System in an internal

workshop; and developed and implemented models, KPIs, and analytical tools to enhance the understanding of

performance and the automation of budgeting and forecasting processes.

Worked closely with clients to resolve problems, capitalize on opportunities, and improve business outcomes; devised

and modified costing proposals for projects, performed risk analysis, and managed change control.

CONSULTANT

Blue Line Planning Crosswicks, NJ Dec 2005 Mar 2007

Engaged in the maintenance of the Cognos Enterprise Planning, Analyst, and Contributor models, which included

mapping of actual data from Costpoint ERP system to Cognos EP to observe and inspect budgeting, forecasting, and

KPIs resulting in an improved time cycle for budgets and forecasts.

Validated updates between data transfers from and to Cognos planning, data store, and GL system; devised and

employed internal control procedures surrounding budgeting, forecasting, and planning processes; and documented

4 P a g e

A RUNASISH S IRCAR

10155 T U R N B E R RY P L A C E, O A K T O N, V I R G I N I A 22124

business processes and system design after the requirements gathering phase.

Situated data from flat files through utilizing File Maps; importing, loading, and preparing functions; building access

tables; saving selections; publishing contributor data; and effectively synchronizing applications.

Rendered assistance in the employee review and assessment processes; liaised with other personnel to ensure proper

delivery of exemplary customer service to clients; and complied with enforced regulations for improved organizational

safety and productivity.

SENIOR FINANCIAL ANALYST

Gate Gourmet Reston, VA Jan 2005 Nov 2005

Arranged and processed financial statements through utilizing the newly implemented SAP ERP system and migration

of data to the Hyperion Global Reporting System for global headquarters at Zurich.

Observed and audited general ledger postings from 46 field units; developed and amended internal controls, policies,

and procedures; enhanced and modified the documentation of the business processes and documented procedures; and

observed various types of reconciliations and spreadsheets, including the upload of data to SAP through the uploaded

template.

Analyzed financial information to generate forecasts of business, industry, and economic conditions for utilization in

making investment decisions.

Prepared plans of action for investment based on financial analyses; suggested investments and collaborated with

investment bankers to attract new corporate clients to securities firms.

BUSINESS ANALYST

ADP Canada Toronto, CAN Aug 2000 Nov 2004

Participated in the deployment of Oracle Financials as a functional resource in the project team, and relayed new and

existing processes to process owners and users; developed and maintained positive and strong internal consulting

relationships with managers and end users in serviceable areas.

Defined Customers and attached customer profile classes, Invoice rules, Sales Persons, Transaction Types, and

Payment Terms in Accounts Receivable.

Handled system integration testing and user acceptance testing, which involved preparation of test scripts during

Oracle Financials Release 11i (11.5.9) upgrade, Tax EDI, AIX, and Autopay migration.

Trained super users in AR, AP, GL, FA and CE and also created detailed user manual.

Completed the validation and testing of various new procedures and recommendations, and researched the efficiency

of different complex accounting procedures; ensured that all enhancements are carefully and properly planned and

tested prior to implementation in the production environment.

Supervised the fabrication of reports for refund management and payment to third party vendors; examined out of

balance scenarios in the Oracle GL, and instigated proper actions to correct them within time constraints; and

managed the logging of exceptions report to Oracle DBA and escalated as needed.

Directed and involved in process mapping of significant transactions and risk and control identification; conducted

extensive tests as per test plans to evaluate the design and operating effectiveness of controls and mitigation of

identified weaknesses; and spearheaded training of four team members on business processes and Oracle Financials.

MANAGER ACCOUNTING

Tata Steel India Dec 1995 Jun 2000

Administered a part of the annual revenue of approximately $8 billion and became one of the best steel manufacturing

companies in the world.

Handled the review and analysis of quarterly and annual financial statements and documented information summary

utilized for making critical and strategic financial decisions.

5 P a g e

A RUNASISH S IRCAR

10155 T U R N B E R RY P L A C E, O A K T O N, V I R G I N I A 22124

Assessed monthly financial statements and reported to support the Sales and Marketing division in their decision

making to include month end closing entries and adjustments for account finalization.

Planned and prepared monthly performance report for various sales units and warehouses as a customer support

function; settled SAP (ERP) financial codes with legacy financial codes and prepared revenue analysis; updated

monthly budget for budgetary compliance report.

Improved operational efficiency of Finance Systems by 9% through the effective implementation of streamlined data

management procedures; motivated a staff of 6 members and tracked their performances and organized training needs.

E DUCATION AND T RAINING

E Business Suite R12 Financials Certified Expert Consultant Payables Oracle Certified Professionals (OCP) Mar 2010,

E Business Suite R12 Financials Certified Expert Consultant General Ledger – Jun 2013

Certified in Adaptive Planning, Budgeting, and Forecasting Software Dec 2009

Certified in Cognos Planning 8.3 2008, Certified in Costpoint 2007

Certified Public Accountant (CPA) Pending –Expected completion 2012

Certified General Accountant (CGA) Certified General Accountants Toronto, CAN Mar 2004

Certified Management Accountant (CMA) Institute of Management Accountant Montvale, NJ Jan 2003

Master of Business Administration in Finance (MBA) IGNOU New Delhi, India Dec 1999

Cost Accountant ICWA – Institute of Cost & Works Accountant of India Dec 1994

P ROFESSIONAL A FFILIATIONS

Institute of Management Accountants Montvale, NJ, USA

Certified General Accountants Association of Canada

Institute of Cost and Works Accountants of India

6 P a g e

Contact this candidate