SUMMARY -

• 10 years of IT Analyst Experience on Oracle ERP/CRM implementations and business process re-engineering.
• Financials Techno Functional Consultant specializing in Oracle Application implementations, specifically Financials.
• Extensive engagement work and project implementation experience in Oracle’s modules and project implementation methodologies.
• Detailed knowledge of best practices regarding the accounting and finance functions.
• Experience in Accounts Receivables (AR), Accounts Payables (AP), I-Expense, i-Procurement, General Ledger (GL), Fixed Assets (FA), Advance Global Intercompany (AGIS), Cash Management (CM), Purchasing (PO), Quoting, Advance Pricing, Shipping, Oracle Order Management (OM), Inventory (INV), AOL and System Admin and integrated custom applications.
• Very Good experience with the new concepts introduced in Release 12 like Multi Org Access Control (MOAC), Sub Ledger Accounting (SLA), Advance Global Intercompany (AGIS), e-Business Tax (eBiz Tax), Financial Accounting Hub (FAH)
• Good on modeling of the Trading Community Architecture (TCA), Have setup parties, customer accounts, party relationships, etc
• Extremely skilled on Procure to Pay as well as Order to Cash business flows.
• Strong experience in functional designs and specifications, developing and writing clear functional specifications, understanding of project life cycles and methodologies, Analytical skills and problem-solving abilities, including the ability to troubleshoot effectively, make applications run very efficiently and/or with excellent real time response and ability to work in a professional manner, be flexible, and handle interactions with all levels of the organization and with external clients.
• Extremely strong on Oracle’s proprietary Application Implementation Methodology (AIM). AIM Documents delivered - BR100, MD050, BP070, RD050, BR030, CV040, CV070, TE040

TECHNICAL EXPERIENCE:

ERP: Oracle Financials (11i and Release 12) - i-Procurement, i-Expense, Oracle Accounts Payables, Oracle General Ledger, Fixed Assets, Accounts Receivables, OM, PO, INV

Scheduling Software: APPWORX

Databases: Oracle 9i/10g

PROFESSIONAL EXPERIENCE -

Confidential, Bothell, WA

Oracle - Finance Functional Analyst

Responsibilities -

• As part of the Production Support team - worked on handling the help desk tickets
• Routinely involved with period close and book closure activities.
• Worked on prioritizing the help desk open requests
• Worked on the support of the users for new enhancement requests.
• Supported the users for developing ad hoc reports as part of the reconciliation process
• Supported the interface issues and resolved the errors
• As part of the production support team - worked on resolving workflow issues
• Supported the users for developing of new error reporting alerts (periodic and event)
• Supported the users in resolving performance issues in the system
• Worked on the close process with the users
• Supported the streamlining of closing of the modules in oracle e-business suite
• Worked on the support of the Auto Invoice interface that loaded invoices from external sources into oracle
• Prepare pre & post-upgrade functional and validation tasks for FIXED ASSETS, AR, AP, Advance Collections, GL modules
• Worked on the implementation of FIXED ASSETS, AR, AP, Advance Collections, GL modules
• Worked on the Revenue Recognition process in AR Module – setting up Accounting and Invoicing rules, defining the daily revenue rules, setting up Customer Acceptance process, deferred revenue, deferred COGS process, etc.
• Worked on the RevPro modules of Revenue Management, Revenue Allocation, Revenue Intelligence, Revenue Forecasting
• Worked on the Dunning Letter Setups In Oracle AR module
• Worked on the Statement Cycle setups in Oracle AR module
• Worked on the configuration of the Advance Collections Module – defining the advance collection engine, defining the collector work queue, setting up scoring components, strategies and dunning plans, delinquency information, etc
• Worked on defining the SOP 97/2 and Revenue Carve Out rules in RevPro.
• Understand AS-IS FIXED ASSETS, AR, AP, Advance Collections, GL system and suggest standard R12 features to replace customizations in 11i
• Prepare test cases to test post upgrade FIXED ASSETS, AR, AP, Advance Collections, GL
• Prepared R12 equivalent of the test scripts (TE040)
• Prepared MD050 and performed functional testing for custom report enlisting compensation details along with YTD summaries for each salesperson
• Prepared and implemented smoke test scripts to test each upgraded instance
• Assisted in rigorous testing of the upgraded instance to identify FITS and GAPS
• Assisted in End User Training and conducting Training Workshops
• Actively involved in answering user questions related to R12 environment & differences from 11i
• Actively involved in preparing cut-over activity tasks, practice upgrades & dry runs

Confidential, Billerica, MA

Financials Functional Analyst

Responsibilities:

• Preparing Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating units for nine fiscal years until Sep-2007.
• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Performed all the setups for FIXED ASSETS, AR, AP, GL, Advance Collections, FA and CM modules.
• Worked on Advance Collections setups – defining the parameters for collection engine, defined the delinquency rules, defined collection strategy, dunning plans, processing promise to pay, dispute invoices, etc.
• Worked on Configuring the Sabrix Tax Engine.
• Worked on the Revenue Recognition Process in Oracle AR module.
• Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
• Worked on the entire upgrade strategy to upgrade the application footprint from 11.5.10.2 to Release 12.1.1
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap & put collaborative effort with the Technical team to address the same thro Technical Specification.
• Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Flow Testing for Modules (FIXED ASSETS, AR, AP, GL, Advance Collections, FA, CM) to make sure flow is working without any issues.
• Conducting Pre Project Review & Post Project Review.
• Providing Post Implementation support
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Environment: Order Management, Sabrix Tax Engine, Advance Collections, Accounts Receivables, WMS, Shipping, Inventory, i-Procurement, Purchasing modules

Confidential, Los Angeles, CA

Finance Business Analyst

Responsibilities:

• Worked on the setups for the FIXED ASSETS, AR, AP, Advance Collections, Advance Global Intercompany (AGIS), Vertex O Series, GL, FA, Project Costing, Project Billing Modules
• Preparing BR30, BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on a customization for Deferred Revenue in AR using Revenue Recognition process.
• Configured Auto Invoice in AR to import Invoices and Billing data from the non Oracle ERP instance in Japan.
• Worked on the setups of e-Business Tax and Vertex O Series module – including the setups of Tax Rates, Tax Codes, Tax Regimes, Regime to Rate flow – for EMEA and US.
• Worked on the integration of Oracle e-Business Tax with Vertex O Series module.
• Worked on the setups of the Scoring Engine in Oracle Advance Collections
• Worked on the definition of the scoring strategies in Oracle Advance Collections.
• Worked on the setups of the Advance Global Intercompany (AGIS) module.
• Implemented TCA – for AR customer master conversions.
• Worked on the setups of the Payment Manager in the AP module.
• Worked on Line Level Matching feature in oracle AP module.
• Setup the Payment Process Profiles (PPP) and Payment Process Requests in the Payment Manager in AP Module.
• Worked on the payment transaction file to be transmitted to the bank using the EDI 820 Payment file
• Worked on the AR/AP netting process in AP module.
• Worked on the AP Processes of Retainage, Recoupment, etc.
• Worked on the defining the transaction types, financial options, tax rules in Oracle AP module
• Setup the Internal banks for Oracle AP in the Cash Management module.
• Involved in understanding the existing business process & conducted meetings on client business overview
• Worked on the setups of Oracle Discoverer 10g EUL
• Worked on several reports in Oracle Discoverer 10g
• Performed Gap Analysis so as to integrate the business requirements to oracle applications
• Prepared business requirements documents for Purchasing and Order Management

Environment - Oracle Applications Release 12.1.3 Upgrade from Release 11.5.10.2 Rollout for US, Canada, EMEA and Middle East AP, GL, i-Procurement, PO, Vertex O Series, INV and Tudor Screen Software

Confidential, Miami, FL

Finance Business Analyst

Responsibilities:

• Involved in the Implementation and Post-Implementation Support of Procure to Pay Applications like FIXED ASSETS, AR, AP, GL, AGIS, FA, Vertex O Series, Project Costing, Project Billing, Cash Management.
• Impact analysis done on the service items and professional service items with the new setup done for the Event-based Revenue Recognition process
• Worked on the PCard functionality setups – setting up the credit card programs, credit card profiles and credit card GL account sets, credit card imports for creating invoices in AP
• Worked on the setups of Vertex O Series to integrate with Oracle e-Business Tax module.
• Worked on the setups of the AP Module – Setting up the AP Payment Manager, Payment process profiles, payment process requests, etc.
• Worked on testing the Revenue Recognition functionality in AR for all the Accounting and Invoicing rules that were defined.
• Worked on the Invoicing and Billing Functionality of the AR module
• Worked on the functional design of an interface to import invoices form an external system into Oracle AR module
• Tested a patch that we had applied for the Revenue Recognition process.
• Performed Standard Functionality testing in PO, AME, i-Procurement, AP, GL and INV.
• Was involved in Standard Functionality testing in Phase I and Phase II for 3 instances.
• Involved in Unit Testing and System Testing.
• Documented and communicated test results to the Test Management and Business Management Team
• Worked closely with Developers team for different issues

Environment: Oracle (FIXED ASSETS, AR, AP, GL, FA, OM, Vertex O Series, INV) Oracle 10g/9i, SQL, PL/SQL, Developer 6i (Report 6i & Forms 6i), Toad 8.1.6, Workflow 2.6.

Confidential

Finance Business Analyst

Responsibilities:

• Study AS-IS Business Process.
• Analyze the Upgrade Requirements and strategize the migration of customizations to Release 12 instance.
• Identification of GAPs & proposal of Solution.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Worked on the Payment Manager in AP Module
• Worked on setting up the Payment Process Profiles, Payment Process Requests, etc in oracle AP
• Worked on the various payment formats in oracle AP module.
• Worked on the Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada in oracle AP Module
• Worked on the setups of Vertex Q Series for tax calculation in AR and AP for sales tax and VAT Tax.
• Worked on setting up of Revenue Recognition process in AR Module
• Defined the Accounting and Invoicing rules to be used in Revenue Recognition process in AR.
• Worked on the setups of the Costing module for Standard and Average costing
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Setup the FIXED ASSETS, AR, AP, GL modules
• Good understanding Financial Accounting standards and Revenue Recognition Standards.
• Understand Division-specific business processes from the end users and implement the same.
• Responsible for training the end users on the new processes and facilitated on-the-job training.
• Performed Item Mapping from legacy system and vendor catalogs into Oracle – to define new items and categories.
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
• Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing track
• Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents.
• Provide inputs and part of the team for new solution.
• Test various business scenarios in the new system.
• Interact directly with end users, infrastructure teams, and project teams.
• Functional design of the Conversion / Integration programs.
• Progress the track thro CRP1, CRP2, UAT & Go Alive.
• Provide user training & documentation.