SUMMARY

• Chartered Accountant with around 8 years of experience in Oracle Financials as Functional consultant in Financials modules of Oracle Applications. Involved in multiple implementation projects of Oracle Release 12.
• Strong Domain knowledge of Accounts with financial accounting experience in varied industry area including month end and year end consolidations, P&L analysis, Balance sheet reconciliation, fixed asset maintenance, budgeting and forecasting, payroll maintenance, cash flow reporting and variance analysis.
• Strong experience in General Ledger(GL), Receivables(AR),Payables(AP), Cash Management(CE) and Fixed Assets(FA).
• Worked in multiple projects in environment of Multi - Org and Multi-Currency.
• Good Knowledge and experience in Oracle AIM Methodology of implementation and documentation
• Managed CRP Sessions with users providing training and getting UAT Approvals.
• Excellent knowledge of Oracle Financial Modules functionalities, P2P, O2C and their interplay with overall accounting structure
• Expert in Functional Analysis, Requirement Analysis, Process mapping, Functional specification preparation, application configuration, Testing, Data migration and user training. Rich experience in working with multi location technical resources and offshore team to complete deliverables
• Highly Quality oriented, self-driven and motivated for timely target achievement, Effective oral and written communication skills, presentation skills, strong analytical problem solving capabilities, planning and organizational skills.
• Resourceful, creative problem-solver with proven aptitude to analyze and translate complex customer requirements and business problems and design/implement innovative custom solutions in eBusiness Suite, Web ADI and interfaces to external systems.
• Highly customer focused with customer interaction and service skills.

TECHNICAL SKILLS

ERP Applications: Oracle EBS R12 GL (SLA), AP, AR, FA, CE ; PeopleSoft and Tally

Documentation: AIM Methodology (Scope, Business Process, Business Requirement, Conversions, Mapping).

Other Relevant Tools: MS Office, MS Visio, Hyperion

PROFESSIONAL EXPERIENCE

Confidential

Oracle Financials Functional Consultant

Responsibilities:

• Participated in multiple business meetings for Fit-Gap Analysis and Solution.
• Assisted functional lead analyst to conduct CRP1 and CRP2.
• Used the System Administrator responsibility to define users and assign responsibilities and set profile options
• Define Organization Structure, Users and Responsibilities, Security Profiles and Flex Fields
• Involved in setup for Receivables, Payables andGeneral Ledger based on deep understanding of the functional processes.
• Setup payment terms, invoice distribution, matching of invoices against PO.
• Set up Customers, Receipt methods and auto invoicing in Receivables.
• Customized AR invoicing according to user requirements.
• Participated in testing, user accepting testing in test instance and worked with certain key super users
• Provided Training to users, and Created User Manuals for GL, AP and AR modules.
• Involved in Production support activities.

Environment: Oracle Apps R12 Modules: GL, AP, AR and Sys Admin

Confidential, Cincinnati - OH

Oracle Financials Functional Consultant

Responsibilities:

• Defined Business requirements for Oracle GL and AR, involved in identifying GAPS
• Worked with the business to come up with the future business process and define an appropriate accounting structure.
• Performed GAP Analysis.
• Configured multi-org business structure in Oracle, Ledger Setup, Legal Entity, and Establishment Setups.
• Designed Chart of Accounts to meet the client’s business requirements.
• Defined and maintained various flex fields by defining structure and assigning the value sets to the segments with security and cross validation rules.
• Helping users upload journals using Web ADI in GL
• Worked in Order to Cash cycle.
• Setup transaction types, invoices, guarantees, and deposit and credit memos, debit memos.
• Develop extensions like create cash receipts and apply.
• Designed and developed test script, and created user manuals.
• Setup Calendars, Corporate book and Tax book and various flex fields in FA module.
• Uploaded the assets information into Fixed Assets module.
• Worked closely with technical team to resolve issues.
• Contributed towards Conference Room Pilots CRP1 and CRP2
• Coordinate with offshore technical team for data conversion.
• Provided Post Production support.

Environment: Oracle Applications R12, GL, AP, AR, FA.

Confidential, Pittsburgh

Oracle Financials Functional Consultant

Responsibilities:

• Designed and created new CHART OF ACCOUNTS and set of books
• Understand the uniqueness of Customer Business process
• Assessment of business requirements
• Discussing with clients accountants on the accounting, reporting needs.
• Involved in preparation of MD-50 and TE-40
• Created multiple responsibilities, developed security rules and customized menu to restrict user access to GL functionality as per client’s requirement.
• Worked in the Procure to pay cycle.
• Setup auto accounting, payment methods and transaction types for invoices.
• Setup recurring invoices, prepayment invoices
• Created template for employee expense invoices and reports
• Conducted numerous meetings with SME team on business over view of the client and identify the external systems involved in the business functionality.
• Worked on Revenue recognition transactions, involved in invoicing rules.
• Preparing the test cases and test scripts.
• Giving the KT to the on-site time.

Environment: Oracle Applications 11i, GL, PO, AP, AR.

Confidential

Senior Process Lead

Responsibilities:

• Identified Business needs, Gaps and Requirements Analysis
• Defined GL Responsibilities, Value Sets, Key Flexfield Segments, Period Types, Accounting Calendar, Currencies and created Set of Books
• Defined Recurring and Allocations Formulas
• Involved in defining Tax features such as Codes, Rates, Exceptions and Exemptions
• Setup the Global Consolidation System, involved in Creation of customized reports as per the client’s requirement in Oracle GL using FSG
• Performed Complete Setups related to manual and automatic receipts
• Defined Profile Options to specify certain implementation parameters, Processing Options and System Options
• Defined Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources

Environment: Oracle Applications 11.5.9, GL and AR

Confidential

Senior Finance Manager

Responsibilities:

• Process tracking and enhancements for “Order to Cash”
• End-to-end process includes: Customer order, resource allocation, time entry, billing cycle, raising invoices, related accounting and realization of cash
• Process tracking and enhancements for “Billing” of associates with various types of billing, including Cost plus billing, Hourly billing, Fixed bid billing and Full time billing (FTE)
• Defined and managed the integration with internal tools for Time Entry Management and Internal Resource Management
• Process tracking and enhancements for “Procure to Pay”
• End-to-end process includes: Raising a Purchase request (PR), finalization of the order, raising the Purchase order (PO), approval of the PO, receiving the goods, raising GRNs and system receipts, accounting the invoice, 3-way matching, payment process and transferring entries to GL and closing the PO
• Vendor management including creation of vendor and maintenance of vendor master data
• Member of commercial committee to optimize the purchases, finalizing of various HR contracts relating to Background verification, deployment of contractors, staffing vendors, job portals etc.
• Handled monthly closing including reporting of P&L analysis (Budget vs Actuals), Cost per hour analysis, bench and buffer analysis, department wise profitability analysis, Balance sheet reconciliations, Cash flow reporting etc..
• Process tracking and enhancements for “Payroll management” to ensure timeliness and accuracy
• End-to-end process includes: Timely payments and filing of statutory returns relating to Provident Fund, Employee State Insurance, Withholding tax, Income Tax and Professional Tax; Employee payments including travel and medical reimbursements, full and final settlements
• Process adherence for “Budgeting and Forecasting” including yearly budgeting and quarterly forecasting along with the LRP for 3 years
• Process tracking and enhancements for “Fixed Assets”
• End-to-end process includes: Accounting of fixed assets, categorization, depreciation run, sale and retirement of old assets, maintenance of fixed asset register, tracking of fixed assets, conducting physical verification and issuance of variance report comparing the book assets and physical assets
• Led three complete new projects with an area of over 200,000 sqft.
• End-to-end task includes: Feasibility/viability analysis between locations for finalization of the site, bring various package vendors on board, close monitoring of project progress through weekly calls with project manager and architects, complete project documentation (including RFQ, bid submission, release of manual contract and system PO, work in progress reports, running bills accounting and payments, testing and commissioning, project handing over till commercial closure of the project