SUMMARY

• Oracle Financials Functional expert with 9.1 years of IT Experience including in - depth experience in design, support and implementation of software applications Including experience as a Functional Consultant
• Extensive experience with Record to Report, procure to Pay and Order to Cash.
• Expertise in Accounts Receivables, Cash Management, e-Business Tax, Accounts Payable, General Ledger, I-Expense and Fixed Assets modules.
• Extensive experience in the Functional aspects of Oracle Applications 11i, release 12.0.3 and 12.1.1 Worked across different modules of the Financials suite including AR, Channel Revenue Management (Chrm), Credit Management, Fixes Assets, Advance Collections, AP, i-Expense, e-Business Tax, GL, i-Expense, Cash Management
• Ensured escalations are met, issues resolved, risk mitigated and task prioritized due to strong technical and executive experience
• Experience with Revenue Recognition concepts like SOP 97-2, VSOE, ASC-606.
• Excellent communication and leadership skills, managed projects with C level executives
• Strong understanding of different methodologies (Agile, Waterfall and Iterative), finance and risk models (CPM, Risk Management), operation (six sigma, supply chain services), marketing and engineering.
• Typical program type: offshore and onsite teams, fixed bid, time and materials, core dependency vendors
• Strong understanding of different methodologies (Agile, Waterfall and Iterative), finance and risk models, operation (six sigma, supply chain services), marketing and engineering.
• Excellent communication skills, managed projects with C Level executives and open source engineers.
• Experience in high volume, high risk, high visibility and low downtime production systems.
• Successfully designed and implemented projects in custom-built products, COTS, version upgrades and services.
• Ensured escalations are met, issues resolved, risk mitigated and task prioritized due to strong technical and executive experience.
• Tools used on projects: MS Office, MS Project, Visio, MySQL and PHP, statistics and risk management modeling.
• Hands on project manager, gathered requirements to develop architecture, logic and data models, used data for project estimations, sign offs and change request approvals.
• Extensive experience with Managing Off Shore and On Site teams.
• Experienced in desktop applications, hosted solutions on server farms and disaster recovery centers.
• Developed several Business Requirement Documents (BRD), Functional Specification Documents (FSD)
• Experience includes execution of 2 full lifecycle Oracle Applications implementations including the exposure to e-Business Suite Release 12, numerous Application Support projects, RICE implementations, upgrades, with high level of Customer Satisfaction.
• Extensive experience in consulting including Quote to Cash and Procure to Pay Executed critical projects as Business Analyst, Functional Consultant, Onsite Coordinator, Designer on Functional & Techno-Functional roles.
• Extensive business area experience & have received great commendations at Client site for excellent interpersonal & Client interaction skills.
• Adept in reviewing and analyzing the 'as-is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in the process.
• Demonstrated abilities in mapping business requirements and translating these requirements into Oracle applications functional specifications and detailed test plans and custom designing solutions.
• Strong communication & leadership skills with an ability to interact with business users and lead business projects.

TECHNICAL SKILLS

ERP: Oracle Applications R12, 11i

Modules: AR, Advance Collections, i-Expense, Credit Management, Channel Revenue Management, AP, GL, Sub Ledger Accounting, e-Business Tax, Fixed Assets, Project Costing, Project Billing and CM

Databases: DB2 and Oracle 7.x./8.0.5/8i/9i/10g.

Oracle Tools/ Utilities: TOAD, PL/SQ developer SQL * Loader, Export, Import, SQL & Monitors.

Operating Systems: UNIX, Windows 95/98/2000, Windows NT

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Oracle Financials Functional Analyst

Responsibilities:

• As a Functional Analyst supported the financial modules: SLA, AR, AP, GL, I-Expense, E-business Tax Release 12.1.3
• Defined Accounting Flex Field Structure, Security Rules, Assigned Security Rules Setup, Define Cross-Validation Rules in Oracle General Ledger
• Defined Period Types, Accounting Calendar, Currencies, Conversion Rate Types, Enter Daily Rates and Ledgers in Oracle General Ledger
• Worked on the Revenue Recognition process in Oracle AR module - defining the Invoicing and Accounting rules, setting up the Customer Acceptance process, working on the Daily Revenue recognition rules, setting up Rule Based and Event Based revenue recognition processes.
• Worked on extracting the Revenue distributions from oracle AR and integrating that data to an external third party application for revenue analysis.
• Worked on i-Expense integration with AMEX Credit Cards.
• User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Created test scripts for UAT (User Acceptance Testing) and helped technical team in testing their all developments in lower instance before migrating them to production.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Created FSG Financial Reports critical to company’s business process.
• Used HP service request manager for logging and capturing the data regarding the tickets raised by the users
• Used Project portfolio manager to make application work request for any change made to the production environment.

Confidential, Boston, MA

Oracle Financials Functional Analyst

Responsibilities:

• Study AS-IS Business Process (on version 11.5.10.2)
• Analyze the Business Enhancement Requirements.
• Identification of GAPs & proposal of Solution.
• Impact Analysis of all customizations that existed on 11i and if they were needed to be moved over to Release 12.
• Order Management - Worked on the Standard Order Cycle, Drop Ship process, Back to Back order process, IRISO process
• Order Management - Worked on the configurations of transaction types, security rules, processing constraints in OM
• AR - Worked on the Auto Invoice Process, Auto Lock Box setups in Oracle AR
• Worked on the Credit Management - defining check lists, defining scoring models, automation rules, credit data points, etc.
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution 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 through CRP1, CRP2, UAT & Go Alive.
• Provide user training & documentation

Confidential, Teaneck, NJ

Oracle Financials Functional Analyst

Responsibilities:

• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Worked on Revenue Recognition process in Oracle AR Module
• Defined the Accounting and Invoicing rules in Oracle AR Module
• Worked on the Auto Invoice, Auto Lock Box, Revenue Recognition, Auto Accounting setups in Oracle AR
• Worked on the Refund Functionality in Oracle AR
• Worked on the AR/AP Netting process in Oracle AR module
• Worked on the Tax setups for AR module and Bank Setups in oracle AR module
• Worked on setup of Ledgers, Ledger Sets, Data Access sets in GL module
• Worked on the setups of the Chart of Account, Calendar on Oracle GL
• Worked on the setups of the cross validation and security rules in Oracle GL
• Worked on the Revaluation and Translation functionality in Oracle GL

Confidential, Ellington, CT

Oracle 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.
• Worked on the Record to Report flow - setups and business process definition.
• Worked on the setups of the Primary Ledger, Secondary Ledger (for Statutory reporting), Design of the chart of accounts, worked on translation and revaluation, consolidation in GL.
• Performed all the setups for Fixed Assets, i-Expense, Advance Collections, Credit Management, GL, Sub Ledger Accounting, e-Business Tax, FA and CM modules.
• Worked on Mass Allocation process - defined the formula for Mass Allocations, worked on usage based mass allocations and incremental mass allocations
• Developed several Row Sets, Column Sets, Row Set Account Assignments, Row Set Calculations, Column Set Account Assignments and Calculation, Content Sets for FSG Reports
• Developed and defined more than 50 FSG reports and also created FSG report sets.
• Created and maintained FSG Financial Reports critical to company’s business process.
• Consolidation and mapping of reports between different instances
• Transferring reports to different instances
• Worked on the Revenue Recognition Process in Oracle AR module.
• Worked on the setups and configurations of Oracle e-Business Tax module - defining the tax rates, tax codes, rates, regimes, rate to regime flows, etc.
• Configured e-business tax to integrate with Vertex.
• Worked on Production support, handling month end and quarter end support for the Record to Report Track.
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Worked on Financials Reporting using Discoverer reports and Hyperion.

Confidential, Minneapolis, MN

Oracle Financials Functional Analyst

Responsibilities:

• Analyze the Business Enhancement Requirements.
• Identification of GAPs & proposal of Solution.
• Documents the AS IS and TO BE Processes.
• Experience in designing and developing project document templates based on SDLC methodology.
• Worked on GL, AP, AR, i-Expense, Advance Collections, Credit Management, Revenue Recognition
• Involved in the JAD Project Design and Business Requirement Documentation and created the Functional System Design.
• Conducted meetings, interviews and JAD sessions with stakeholders to collect business requirements.
• This information along with the vision document was used to transform business requirements into System Requirement Specifications.
• Gather requirement through various ways including Joint Application Development (JAD) sessions with end users, expert team, Technical Team and stakeholders.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Developed several FSG using reports using the Row Sets, Content Sets, Column Sets etc.
• Worked on the setups of the Credit Management modules.
• Worked on the entire Software Development Life Cycle (SDLC).
• Worked on User Training - developing User Training Manuals, Conducting Class room as well as Remote training of users using WebEx.
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution 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 through CRP1, CRP2, UAT & Go live.
• Provide user training & documentation

Confidential, Petaluma, CA

Oracle Financials Functional Analyst

Responsibilities:

• Identification of GAPs & proposal of Solution.
• Worked on the Oracle Financials - GL, AP, Fixed Assets, AR, Advance Collections modules
• Worked on conducting Conference Room Pilots (CRP), Joint Application Design (JAD), User Acceptance Testing (UAT).
• Worked on the entire Software Development Life Cycle (SDLC).
• Coordinated JAD sessions to understand the user requirements and also their system’s implementation.
• Conduct JAD sessions for better understanding and refining of requirements in coordination with multiple teams.
• Clarify and prioritize requirements by conducting brainstorming sessions with the stakeholders and SMEs.
• Worked on the setups of OM, Quoting, Advance Pricing, AR, Revenue, GL modules
• Worked on configuring the GL Module - Defining the Ledgers, Org Structure, setting up Translation, Revaluation, Consolidation process.
• Developed the Revenue Recognition rules as per the US GAAP standards.
• Formulate Test Strategy, Test Scenarios & Test Cases
• Perform Unit Testing & Co-Ordinate User Testing.
• Documented Functional Design, Applications Setups & User Manuals

Confidential, Sunnyvale, CA

Oracle Financials Functional Analyst

Responsibilities:

• Understanding the existing business processes including GL, AP, AR modules
• Preparing existing business process documents
• Discussing with business users and preparing BP80 for current state AS IS and future TO BE Process documents for GL, AP, AR
• Mapping the business processes with Oracle 11.5.10 standard functionalities and identifying the gaps.
• Giving demonstration of standard functionalities of GL, AP, AR to the Business Users.
• Proposing solutions and customization for gaps and getting the approval from business users.
• Working with Technical team closely and getting done development for customizations for GL, AP, AR Modules.
• Working closely with Business users to understand the criteria’s and filters for converting data from 11.0.3 to 11.5.10 for GL, AP, AR
• Preparing BR100 and Completing the Setups and configurations for GL, AP, AR
• Preparing the test cases for GL, AP, AR modules
• Conducting CRP1, CRP2 UAT1 and UAT2 and helping the user for going through all the test cases.
• Fixing the issues collecting during CRP1, CRP2 and UAT.
• Working 24 by 7 during cutover and down time
• Providing support to users after implementation is done and fixing all issues related to set ups
• Fixing the issues for converted data for GL, AP, AR modules

Confidential, Fremont, CA

Oracle Finance Functional Analyst

Responsibilities:

• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap & put collaborative effort with the Technical team to Solution.
• Collaborated with Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Worked on the setups of AP, AR, Revenue, GL modules.
• Worked on conducting Conference Room Pilots (CRP), Joint Application Design (JAD), User Acceptance Testing (UAT).
• Worked on the entire Software Development Life Cycle (SDLC).
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Assisted Business for Business Acceptance Testing and obtain Sign off.
• Worked with the Business team to baseline NPI ‘As Is’ Process and derive ‘To Be’ flow.
• 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.
• 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: Oracle Applications 11.5.9 (AR, AP, GL, AOL)

Confidential, San Diego, CA

Oracle Finance Functional Analyst

Responsibilities:

• Actively Participated in collecting current business process requirements to map with new environment to Implementation purpose.
• Preparation of Set up Document (BR100) in various modules GL, AP, AR
• Defining Accounts Payable Setups financial options, payables options, payment terms Banks, based on new requirement.
• Defining Journal Line Types, Journal Entry Description, Mapping Sets, Account Derivation Rules,Supporting Reference.
• Defining Purchasing Setups Purchasing Catogery Flex field, Purchasing Options, Receiving Options.
• Prepared few functional Design Documents for application extensions (MD.050)
• Defining Set Up Rules, Profile Options, and System Parameters.
• Preparation of Integration Test Script (TE040)
• Resolved Bugs that cropped up during the time of testing.
• Raised Technical Assistance Requests(TARs/SR) for issues where more clarity was required OR where there was a bug in standard functionality provided by Oracle.
• Training the Functional Users of the system in order to enable them to proceed with the User Acceptance Testing of the configured

Environment: Oracle Applications 11.5.9(AP, OM, GL)

Confidential

Oracle Finance Functional Analyst

Responsibilities:

• Prepared business requirement documentation by analyzing new business process design, requirements analysis, and solution design using oracle AIM methodology
• Part of a business transformation project team and assisted the end-users in the functional configuration of Order Management, WIP, BOM and Inventory modules
• Involved in a feasibility analysis of integrating oracle functionality and legacy system
• Analyzing the parameters involved in physical inventory and cycle counting, and setup of ABC classes for teams to aid in implementation of counting methodology
• Analyzed the need for sub inventories, stock locators & setup shipping networks transfer
• Performed organizational set ups including inventory organizations, item categories, product catalogs, locations, freight carriers, item parameters etc
• Responsible for defining and setting up complete Order Cycle setups from, order entry in order management to ship confirm in shipping execution module to support business requirements
• Performed setups for process involving split shipment process, drop shipment process, RMA process, in Order Management.
• Performed setups for shipping parameters like picking rules, pick slip grouping rules, release sequence rules for Order Management
• Conducted CRP and Integration testing for related modules
• Maintain issue tracker and coordinated with the team for debugging
• Involved with user acceptance testing (UAT) and end user training
• Prepared and provided comprehensive training materials and practice exercises

Environment: Oracle Applications 11.03/11i (GL, AOL, Sys Admin, Alerts)