We provide IT Staff Augmentation Services!

Oracle Financial Functional Consultant Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • Overall 7+ years of experience as an Oracle Financial Functional Consultant, experience in full-fledged Support and involved in End-to-End Implementation projects.
  • Experience in the area of Accounts & Finance.
  • Experience with System Administration (Sys Admin), General Ledger (GL), Account Payables (AP), Fixed Assets (FA), Account Receivables (AR), Cash Management (CE) and iExpenses using R12 Oracle E-Business Suite.
  • Experience with Oracle R11i and R12 E-Business Tax.
  • Plan, design, develop, configure, implement, test, deploy and engage in rollout of Oracle E-Business Suite Release 12.
  • Have completed Up gradation assessment for the Client from 11.5.10.2 to R12
  • Completed R12 Implementation for some modules.
  • Strong familiarity with AIM methodology in creating BRD, BR-100, MD-50, MD-40, MD-80 etc documents throughout multiple Projects.
  • Excellent writing skills in authoring Business Requirements Document (BRD), Functional Requirement Design (FRD), Use Case Specifications, Systems Requirements Specification (SRS).
  • Experience in Business Requirement gathering and GAP Analysis and Resolution
  • Working Knowledge in Procure 2 Pay and Order 2 Cash Cycles.
  • Conducted Conference Room Pilot (CRP).
  • Proficient in Training Documentation & Delivering the Training to the End Users.
  • Worked extensively on onsite offshore model and expertise to guide, coordinate and assist team members to provide deliverables.
  • Co-ordinate and follow with offshore team to accomplish the milestones as per project time line.
  • Strong quality bias, self driven and highly motivated for timely target achievement.
  • Excellent written and oral communication skills with a results-oriented attitude.
  • Critical thinking, decision making, coordination and resource management are skills that I have fined-tuned due to my academic and professional experiences.
  • My experiences have taught me to work efficiently even under pressure both as a team and as an individual.

TECHNICAL SKILLS

ERP: Oracle Financials R12

  • General Ledger
  • Account Payables
  • Account Receivables
  • Cash Management
  • Fixed Assets
  • E-business Tax
  • iExpense

Tools: TOAD, SQLLAODER
Accounting Packages: MS Office Suite
Operating Systems: Windows 98/XP/Vista
Software Packages: Adobe Acrobat, Adobe Illustrator, Microsoft Publisher

PROFESSIONAL EXPERIENCE

Confidential, New Orleans, LA November 2011 Till Date

Company Description: Westway Group is a leading global provider of bulk liquid storage and liquid animal feed supplements through its subsidiaries Westway Terminal Company LLC and Westway Feed Products LLC.

Oracle Financials R12 (FA, GL) Implementation
Oracle Financials Lead Functional Consultant

Responsibilities:

  • Worked on Oracle Applications AIM methodology for process of implementation and documented as per BR100.
  • Worked on the Re-implementation plan.
  • Set-up for Fixed Assets including defining book controls and asset categories.
  • Loaded Asset Categories using DataLoader.
  • Used SQLLOADER to update Asset data.
  • Prepared test scripts and performed extensive Unit testing.
  • Worked on issues and fixes at the time of UAT testing with business users.
  • Interacting with development team regarding issues resolutions.
  • Worked extensively on onsite offshore model and expertise to lead, guide, coordinate and assist team members to provide deliverables.
  • Provided the Production support Post Go-live.

Confidential, Emeryville, CA March 2010 to Till Date

Company Description: Confidential, is a company that maintains and licenses an Internet-accessible database containing information about the contents of audio compact discs. It provides its media management technology and global media database of digital entertainment information to the mobile, automobile, portable, home, and PC markets.

Oracle Financials R12 (GL, AP, FA, AR, CE, E-business Tax) Implementation/Support
Oracle Financials Functional Consultant

Responsibilities:

  • Gathering the business requirements and meeting with client business team on business process.
  • Worked on Gap analysis and module design and prepared respective documentation for the process i.e. BP040 and BP080.
  • Worked on Oracle Applications AIM methodology for process of implementation and documented as per MD050 and BR100.
  • Worked on E-Business Tax configuration design to setup the tax structure and testing.
  • Configured the setup of Multi-Org Structure with multiple accounting Ledgers and accounting Legal Entity.
  • Modified and created new configuration setups in Sub-ledger Accounting Method for Fixed Assets (FA) to achieve the accounting requirements.
  • Set up for Fixed Assets including defining category, location and asset key flexfields
  • Defined the prorate convention, prorate calendars, depreciation rate and calendars, fiscal calendars, book controls and system controls.
  • Configuration of Payment Setup Administration setups for Payment methods rules and Payment formats.
  • Created Different bank accounts for Payables.
  • Defined the payment term and recurring Invoice template
  • Used Data Loader to upload suppliers details
  • Prepared Test Scripts and performed unit, integration testing
  • Configured the setups for Global Consolidation process, includes Consolidation mapping rules (segment rules and account rules), Consolidation Sets.
  • Supported the client during period-end closures.
  • Interacting with Oracle development team regarding issues resolutions.
  • Worked extensively on onsite offshore model and expertise to guide, coordinate and assist team members to provide deliverables.
  • Provided the Production support Post Go-live.

Confidential, Seattle, WA October 2009 to March 2010

Company Description: Dendreon Corporation (NASDAQ: DNDN) is a biotechnology company focused on targeting cancer and transforming lives through the discovery, development, and commercialization of novel therapeutics that may significantly improve cancer treatment options for patient.

Oracle Financials R12 (iExpense) Implementation/Support
Oracle Financials Functional Consultant

Responsibilities:

  • Conducted workshops and user interaction session to explain about the benefit of iExpense to the existing business process.
  • Explained the detail process flow and addressed different questions and clarification in the workshop to regarding benefit of implementation.
  • Interacted with business group and created BR.100 and Functional design document for customizations.
  • Performed the set up, configuration and unit testing at the development and controlled environment.
  • Worked with technical team members to work on custom solution development to report aggregate spend expensed in the expense report.
  • Worked on issues and fixes at the time of UAT testing with business users.
  • Created and conducted user training session to train about the usage of iExpense process.

Confidential, Boston, MA April 2008 to September 2009

Company Description: State Street Corporation is a financial services holding company. State Street Corporation provides securities services to institutional investors as a custodian bank and also provides investment management services to mutual funds and other asset managers.

Oracle Financials R12 (GL, AP, FA) Implementation/Support
Oracle Financials Functional Consultant

Responsibilities:

  • Gathering the Client Requirements and preparing the documents using AIM Methodology.
  • Prepare AS-IS of current system, finding and recommending work around of GAPS.
  • Involved in end to end integration between the legacy system and Oracle AP.
  • Part of Suppliers conversion from legacy system to Oracle Account Payables.
  • Created intercompany Transaction, Consolidation, Elimination entries setups and configuration for use.
  • Used ADI Wizards to import journal entries.
  • Mapping the Client Requirements with Oracle standard functionality and finding the Gaps.
  • Prepared RD020, BP040, BP080, BR100, MD050 documents for each financial module.
  • Preparing TE040 Documents, which can helpful to test the application functions.
  • Configuration of Payment Setup Administration setups for Payment methods rules and Payment formats.
  • Created Expense Report Templates for AP module.
  • Created different Bank Accounts for Payables.
  • Participate in Analysis, Design and Testing of the code and documentation.
  • Supported the client during period-end closures.
  • Interacting with Oracle development team regarding issues resolutions.
  • Worked extensively on onsite offshore model and expertise to guide, coordinate and assist team members to provide deliverables.
  • Performed Unit testing, UAT and End-User training for Go-live.

Confidential, Pasadena, CA January 2007 to March 2008

Company Description: The California Institute of Technology is a private research university. Caltech has six academic divisions with strong emphases on science and engineering.

Oracle Financials (GL, AP, FA, AR, E-business Tax) Upgrade from R11.5.10.2 to R12
Oracle Financials Functional Consultant

Responsibilities:

  • Performed Functional Impact Analysis.
  • Identification of custom components that will get affected by the upgrade.
  • Involved in the preparation of cut-over plan.
  • Investigate and analyze the upgrade data per R12 and document the business requirement.
  • Created MD50, BR 100 documents.
  • Conducted EB-Tax Workshops.
  • Mapping the business requirements to the applications and functionalities.
  • Created the Design documents and functional specifications for customizations and interfaces.
  • Design EB-Tax Configuration setups according to Business Process.
  • Design Payment Configuration setups, which include custom electronic payment process.
  • Set up for Fixed Assets including defining category, location and asset key flexfields
  • Defined the prorate convention, prorate calendars, depreciation rate and calendars, fiscal calendars, book controls and system controls.
  • Created and executed the unit/user testing plans and scripts.
  • Review, test, document, and deploy new applications to ensure functionality, efficiency, and adherence to specified standards.
  • Perform hands-on system configurations, testing and troubleshooting.
  • Provided production support during warranty period.

Confidential, Boston, MA March 2006 - November 2006

Company Description: Bain Capital is a private equity firm. The firm includes a large group of investment professionals with consulting or operating experience, and takes an intensive, analytical approach to the investment strategies such as private equity, venture capital, public equity and high-yield assets.

Oracle Financials 11.5.10 (GL, AP, iExpenses) Implementation/Support
Oracle Financials Functional Consultant

Responsibilities:

  • Member of the team responsible for implementing GL, AP and iExpense
  • Interacted extensively with the client to understand business process and define an appropriate accounting structure
  • Performed GAP Analysis
  • Prepared RD020, BP040, BP080, BR100, MD050 documents for each financial module.
  • Set up the organization structure in Oracle.
  • Created Responsibility matrix and set profile options accordingly.
  • Designed Chart of Accounts to meet the client's business requirements
  • Defined value sets, Key Flexfield segments, and rollup groups with security and cross validation rules
  • Setup cross validation, security rules, and recurring journal entries
  • Setup the Payables Sub ledger for different Operating unit
  • Setup the financials options, payables options, payment terms and payables look-ups.
  • Defined Payment terms with discount rates
  • Set up Payables bank accounts
  • Created employee expense templates for different departments
  • Setup the iExpense Module for different Operating Units
  • Set up the approval hierarchy for expense reports
  • Setup of Policy schedules such as Accommodations, Airfare, Car Rental, and Mileage costs
  • Prepared documents to guide the users for creation of vacation rules.
  • Worked closely with the users to define daily limits, roles, and locations in Expense reports
  • Defined iExpense templates in AP
  • Defined numerous signing limits for different managers of various cost centers in AP
  • Developed test scripts, and created user manuals
  • Created signing limits for iExpense users in Payables
  • Designed and developed test script, and Created user manuals
  • Worked closely with technical team to resolve issues
  • Trained users for GL, AP and iExpense
  • Provided Post Production support for a month

Confidential, February 2005 - January 2006

Company Description: 100% Subsidiary of CTE It provides support services to its clients using Oracle tech. products and Unix/ Linux systems. It provides Database, System Admin, Middle Tier Mgmt, Training/ Mentoring & Software Dev. Services Software Licensing

Oracle Financials 11.5.10 (AP, iExpenses) Implementation
Oracle Financials Functional Consultant

Responsibilities:

  • Gathering the business requirements and meeting with client business team on business process.
  • Performed Gap Analysis and mapped the client's requirement in Oracle
  • Prepared RD020, BP040, BP080, BR100, MD050 documents for each financial module.
  • Preparing TE040 Documents, which can helpful to test the application functions.
  • Created custom reports to track the expenses which are approved above the general policies.
  • Involved in the project scoping of the iExpense implementation
  • Defined iExpenses Policy schedules on the basis of location or designation
  • Setup of Policy schedules such as Accommodations, Airfare, Car Rental, and Mileage costs
  • Prepared documents to guide the users for creation of vacation rules.
  • Worked closely with the users to define daily limits, roles, and locations in Expense reports
  • Defined iExpense templates in AP
  • Defined numerous signing limits for different managers of various cost centers in AP
  • Developed test scripts, and created user manuals
  • Provided Up gradation Assessment for the Client from 11.5.10.2 to R 12

Confidential, India October 2003 to December 2004

Company Description: R & D, Manufacturing for OEM in RFID, Mifare, Finger Print solutions.

Oracle Financials 11.5.10 (GL, AP, AR, CM and iExpenses) Implementation/Support
Oracle Financials Functional Consultant

Responsibilities:

  • Application Enhancement and Support for AP, CM and GL modules.
  • Business process analysis and requirement gathering for new customization, report development.
  • Involved in iExpenses project costing, integration, performed configuration setups related to project accounting for expenditures types, expenditure classes and categories.
  • Conducted CRP, UAT and training for end users and production support.
  • Performing Business Requirement Study in Financials and modelling Future Process Model and preparing AS-IS (BP040) and TO-BE (BP080) documents.
  • Prepared RD020, BR100, TE040 (Test Scripts) and End User Training Manuals.
  • Forms and Reports Customization to provide functional specifications to technical team.
  • Mapping bank statement in Oracle.
  • Automatic bank statement reconciliations, Cash pooling, Cash forecasting and Cash positioning.
  • Performing period-end processing for Oracle Cash Management.
  • Gross Sales Report, Report displays the Order Information, AP and AR Invoices, Customer/Supplier Information, Invoice amount details, Trips and shipment information etc.

EDUCATIONAL DETAILS

Bachelor of Science (Biochemistry/Life Sciences)
Statistics, Biochemistry, Neurobiology and Developmental Biology

PROFESSIONAL EXPERIENCE

  • Laboratory Trainee for Tata Pathological Laboratory, Mumbai
  • Medical Researcher/Analyst for Chemical, Industrial & Pharmaceutical Laboratories (CIPLA), Mumbai
  • Laboratory Expert for University of Mumbai, Sophia College, Mumbai

References provided upon request.

We'd love your feedback!