SUMMARY

• Oracle Financials Functional expert with 10.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, 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
• 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.

PROFESSIONAL EXPERIENCE

Oracle Financials Functional

Confidential, Cleveland, OH

Responsibilities:

• Prepare pre & post-upgrade functional and validation tasks for AR, AP, Advance Collections, GL modules
• Worked on the implementation of AR, AP, Channel Revenue Management, 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 Channel Revenue Management module - worked on channel rebate and point of sale management including quota allocation, budget management, worked on the account manager dashboard, chargebacks, third party accruals, soft funds, etc.
• Worked on the setups of Channel Revenue Management - including the setting up of activities, categories, rules, performing the customer setups, setting up buying groups, enabling MOAC, etc.
• Worked on Channel Revenue Management aspects like Channel Rebate and Point of Sale Management, setting up Time structures, setting up calendars and rates, assigning usage to a resource group, configuring user profiles, setting up system parameters, etc.
• 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 AR, AP, Advance Collections, GL system and suggest standard R12 features to replace customizations in 11i
• Prepare test cases to test post upgrade 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

Oracle Financials Functional

Confidential, Teaneck, NJ

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 Oracle General Ledger Module - defined the Ledger (primary and secondary), defined the chart of accounts, calendar, cross validation rules, security rules, worked on translation, revaluation, consolidation
• 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 Dunning Letter setups of defining the dunning letter templates, setting up the dunning letter sets, setting up dunning profiles for customers and customer sites, defining the statement cycles, etc.
• 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.

Finance Functional Lead

Confidential, Santa Ana, CA

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.
• Worked on the General Ledger Module - Defined the Chart of Accounts design, worked on setting up the accounting calendar, defined the cross validation rules, security rules, worked on setting up the journal sources, journal line definitions, etc.
• Worked on the Mass Allocation process in General Ledger module - defined the formulas for Mass Allocation, setup Incremental Mass Allocation and Usage based Mass Allocation.
• 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).
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Canonical Model Definitions, Deriving Use Case scenarios, Flow Diagrams, Data Mapping Documents (DMD) and Functional Testing Documents.
• 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 thro CRP1, CRP2, UAT & Go Alive.
• Provide user training & documentation

Senior Functional Analyst

Confidential, San Diego, CA

Responsibilities:

• As a Business Analyst, I acted as a primary liaison between Business & the development team throughout all phases of SDLC.
• Engaged in different phases of SDLC of the project executing RUP methodology of iterative software development from Inception to Transition phase.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Use Cases, Canonical models, Data Mapping Documents (DMD) and Functional Testing Documents.
• Worked on the Oracle Financials - GL, AP, Fixed Assets, AR, Advance Collections modules
• Worked on the setups of the I-Expense module - defining the expense templates, interfacing i-Expense with AMEX cards, defining categories of expense, setting expense limits per category, defining credit card codes, etc.
• 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.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, expert team, development and QA team for project meetings, walkthroughs and customer interviews.
• Prepared BRD documents based on requirements gathered through JAD sessions and individual elicitation sessions with different IT Group Department Managers.
• 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

Senior Financials Functional Analyst

Confidential

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

Environment: Oracle Apps 11.5.9/11.5.10 e-Business suite (GL, AP, AR)

Finance Functional Business Analyst

Confidential

Responsibilities:

• 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 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.