SUMMARY -

• Oracle Financials Functional expert wif 8 years of IT Experience including in-depth experience in design, support and implementation of software applications Including experience as a Functional Consultant
• Extensive experience wif 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 wif 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 wif 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 wif 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, wif 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 & has 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 wif an ability to interact wif business users and lead business projects.

TECHNICAL SKILLS

ERP: Oracle Applications R12, 11i

Modules: AR, Advance Collections, i-Expense, Credit 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, Ellington, CT

Oracle Financials Functional Consultant

Responsibilities:

• Preparing Business Requirement Documents (BRD) wif 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 wif the business rules associated wif 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 TEMPthan 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 wif 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 Consultant

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 wif stakeholders to collect business requirements. This information along wif the vision document was used to transform business requirements into System Requirement Specifications.
• Gather requirement through various ways including Joint Application Development (JAD) sessions wif end users, expert team, Technical Team and stakeholders.
• Conducted JAD sessions wif 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 wif 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 Consultant

Responsibilities -

• Study AS-IS Business Process of Confidential .
• Identification of GAPs & proposal of Solution.
• 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 wif 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 wif multiple teams. Clarify and prioritize requirements by conducting brainstorming sessions wif the stakeholders and SMEs.
• Experience in conducting Joint Application Development (JAD) sessions wif 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 wif 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

Confidential, Sunnyvale, CA

Oracle Financials Functional Consultant

Responsibilities:

• Understanding the existing business processes including GL, AP, AR modules
• Preparing existing business process documents
• Discussing wif business users and preparing BP80 for current state AS IS and future TO BE Process documents for GL, AP, AR
• Mapping the business processes wif 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 wif Technical team closely and getting done development for customizations for GL, AP, AR Modules.
• Working closely wif 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 Consultant

Responsibilities:

• Worked wif 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 wif the Technical team to Solution.
• Collaborated wif 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 wif 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 wif 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 wif 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 wif 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 dat 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 wif 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 wif the team for debugging
• Involved wif 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)