SUMMARY

• Eight+ Years of Oracle E - Business Suite (R12 & 11i) experience Oracle Financial modules - GL, AP, AR, CE, FA, iExpense & EB Tax.
• Requirement elicitation and analysis with SME (Subject Matter Experts) Leads / BPO (Business Process Owners) / SPO (Strategic Process Owners), Gap Analysis, Solution, Design and Support Business Processes.
• Design and Development of RICE components for migration from legacy system and up gradation of existing systems.
• Hands on experience with PO, INV, OM, WIP, BOM, CM, HRMS, AME, System Administrator, D2K and OAF form personalization.
• Experienced in 2 Full life cycle implementations going through Development, Conference Room Pilot (CRP), System Integration testing (SIT), User Acceptance Test (UAT) and Production, User Training, go-live and post go-live Support and Proficiency in Software Development Life Cycle (SDLC) methodologies.
• Well versed with AIM Methodology. Created BR100’s, MD050’s & contributed towards MD070 to document configurations Functional and Technical specifications.
• Experienced in all aspects of software development life cycle such as performing gap analysis, writing functional specifications, implementing/customizing oracle applications to suit client requirements.
• Involved in R12 SCM (Procure to Pay and Order to cash) Implementation Projects.
• Worked with oracle support, using metalink, to resolve issues using knowledge base, SR/TAR.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS PROFILE.
• Experienced in Discrete Manufacturing (Inventory, Bill of Materials, Work In Process) and Supply Chain modules (Order Management & Purchasing) modules.
• Worked in Production support and involved in activities like Monitoring, trouble shooting, documenting.
• Experienced in Month end closing process for financial periods.
• Involved in testing of difference oracle modules functionality as and required during the roll outs.
• Worked on ad hoc reports to provide the financial data as per business and user needs.
• Experienced in designing business processes, documenting standard operating procedures and training business users in these procedures. Also training client users at various levels from clerks through superusers.
• Experienced in functional testing, integrated testing, setups, design validation and conducting conference room pilot.
• Technical experience with Design, Development, Implementation, Customization and Production Support of Oracle Applications.
• Excellent communication and verbal skills at both User and Management levels.
• Lead Offshore team related to testing entire cycle end to end.

TECHNICAL SKILLS

Tools: TOAD, SQL Developer, Data Loader

Oracle Tools: Oracle Report Builder, Oracle Form Builder, FSG

Languages: SQL and PLSQL

ERP Oracle: Applications 11i/R12, Web ADI

RDBMS: Oracle and SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Keene, NH

Environment: Oracle Applications Release 12.1.3

Oracle Finance Functional Analyst

Key Responsibilities:

• Involved in active discussions with cross-functional teams, team members and project stake holders during the design phase.
• Responsible with requirement gathering, current business process analysis, re-engineering and designing of business process, system configuration and system testing.
• Reviewed current business process and documented the business procedures for Procure to Pay and Project Invoicing to Cash Receipts
• Designed Key Accounting Flex field structure (COA) for Ledger and configured with Multi Org and Multi Reporting Currency setup. Defined system controls, intercompany accounts, journal sources, and journal categories. Defined various currencies for multi-currency operations and currency translation, conversion, revaluation has been done to meet the requirement, Cross validationrules, Configured Sub-ledger accounting process to GL. Defined Security rules at segment level.
• Configured and setup for Financial option, Payable system option & Payable option to meet the requirements such as batch invoices, batch payments, employee expense report process, withholding tax.
• Reviewed the current reconciliation process in Cash Management and designed business process and system has been configured and tested to meet the Business requirements.
• Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping.
• Changes in Workflow process, monitored CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, feedback integration.
• Streamline the Payment process, Prepared Cut- over Plan, Listing down all Pre & Post Go- live tasks. Involved in Post-Production support.
• Responsibility to manage: Creating & Administering Users, Responsibilities, Profile Options, Application Menus and Forms, User and Role Configurations
• Resolved many month end related issues involving and data fixes or configuration changes, created/Maintained Business process Documents BP80,RD-20,BR-30,BR-100,MD-50,TE-40,CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions (RICE) and test scripts in AIM methodology.
• Technical experience with Design, Development, Implementation, Customization and Production Support of Oracle Applications.

Confidential, Orlando, Florida

Environment: Oracle ApplicationsR12.1.3

Oracle Sr.Finanace Functional Consultant

Key Responsibilities:

• Prepared Gap analysis document based on the study and preparation of the set up documents (BR 100) for the Release R12.Documented “As Is” current business process ( BP.040) and designed “ TO BE” process ( BP .080)
• Define Location, Business group, accounting structure, maintaining flex field value sets, defining flex field hierarchies.
• Created legal entities, Operating Units using Accounting set up manager.
• Good working knowledge and understanding on the brand new features of R12 (Managerial segment, Ledger, Sub ledger accounting).
• Comprehensive understanding of Multi organization access control allowing the users to submit requests, enter, view and access data of different operating units without having to switch between responsibilities.
• Configured the set ups for AP - Purchasing options, Financial options, Payables options, creating debit, credit, mixed invoices and Expense reports. Accounting period control, Maintain withholding tax calendar, creating special calendar for payment term, Bank account set up .Maintain payment terms.
• Month end process - Create Accounting entries, print month end reports, Transfer accounting to General Ledger. Reconcile payables, Close accounting periods. Invoice reports, Supplier reports, payment reports, posted reports.
• Hands on experience on generating FSG’s, defined mass allocation, recurring journals, cross validation rules, security rules, calendar, key flex fields, descriptive flex fields, set of books, sequence in GL
• Requirements Gathering, Conducting work sessions with client, training, conduct system testing, conduct Conference Room Pilot (CRP) and User Acceptance Testing (UAT),Preparation of deliverable documentation using Oracle AIM templates for GL like accounting setup, global consolidation system, inter company, accounting structure, multi-currency, FSG, accounting for multiple companies, month end closing.
• Developed and reviewed functional designs MD050 . Also, worked with the end users and business owners to map Oracle Application BR -100 standard processes to business requirements

Confidential, Sunnyvale, California

Environment: Oracle Applications11i (11.5.10)

Sr.Finance Functional Consultant

Key Responsibilities:

• Identified Business needs, Gaps and Requirements Analysis
• Defined GL Responsibilities, Value Sets, Key Flex field Segments
• Defined Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources
• Defined System Item Flex Field, Defining Organization
• Defined Period Types, Accounting Calendar, Currencies and created Set of Books
• Performed Complete Setups related to manual and automatic receipts
• Created and customized reports as per the client’s requirement in Oracle General Ledger using FSG
• Defined Recurring and Allocations Formulas
• Defined Profile Options to specify certain implementation parameters, Processing Options and System Options
• Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes
• Defined receivable activities for misc. receipts, finance charges, bank charges, defining distribution sets
• Defined receipt class, specifying creation method, Payment method, clearing method, defining collectors, defining aging buckets.
• Set up the Global Consolidation System
• Created Test Scripts (TE-40’s) for UAT sessions
• Trained the users for UAT and conducted UAT
• Resolved the application issues interacting with oracle support through SR/TAR
• Provided with Post production support for various issues after go live.
• Responsible for System Requirement Documents, functional specifications, test and user documentation.

Confidential, Daytona Beach, Florida

Environment: Oracle Applications12.1.1

Oracle Sr.Finanace Functional Group Lead

Key Responsibilities:

• Designed and created new CHART OF ACCOUNTS and set of books. Understand the uniqueness of Customer Business process.
• Assessment of business requirements. Discussing with clients accountants on the accounting, reporting needs. Involved in preparation of MD-50 and TE-40.
• Trained end users in financial modules and prepared the training documents. Involved in preparation of Setup Document (BR-100) and was responsible for making the required setups relevant to financial modules.
• Analyzing and testing of scenarios. Worked on GL setups - Security Rules, Accounting KFF, SOB, COA, Calendar, setting up profiles, legal entity, Organization and Organization parameter, Operating Unit and Inventory Organization, and Currency setups.
• Worked on Account Payables setups - Supplier and Supplier Site creation, Bank and Bank Account setups, Tax Code and Tax Group setups, configuration of Withholding Tax Setups.
• Preparing Delta-Analysis. Preparing the test cases and test scripts. Giving the KT to the on-site time. Coordinating with the automation engineers in testing the scenarios.
• Creation of operating units and up gradations and enhancements. Defined Invoice attributes - distribution sets, payment terms, pay groups. Defined the banks and bank accounts. Defined special calendars for recurring invoices, payment terms
• Setting up Expense Report Templates. P2P Cycle. M2O cycle. I-Expenses Reports. Worked on various catalogues in I-Procurement. Training and preparation of User Manuals.
• Creation of operating units and up gradations and enhancements. Real time exposure to testing and automation of scenarios.
• Worked on turn-key part of testing in automation. Worked on Delta-Analysis. Created users and modified the privileges for users, rollup group and summary accounts.
• Created suspense accounts for automatic balancing journal entries from particular sources and categories.
• Created budget, budget organization, master detail relationship, budgetary control and budgetary control groups.
• Developed several FSG reports, including balance sheet and income statements. Set-up supplier and supplier sites for suppliers in payables.
• Developed several custom reports and customized oracle reports for payables. Set up banks, receipts, transactions, plus training for invoicing, receipts, adjustments, and period close.
• Defined banks, customers, receipt classes, collectors. Analyzed and mapped historical data of existing customers.
• Setup customer profile class, profile attributes customer relationships, statement cycles and accounting rules
• Defined system options, transaction types, auto cash rule sets, remittance banks, bank accounts, receipt classes, distribution sets and payment methods Trained and guided users through the testing period

Confidential, Cleveland, OH

Environment: Oracle Applications11i (11.5.10)

Oracle Finance Functional Consultant

Key Responsibilities:

• Business process study and creating business process maps using Visio for Oracle E-Business Suite GL, AP, PO and AR modules implementation.
• Conduct multiple meetings with business team in understanding the business processes to prepare the business requirements definition document including identifying the GAPs and providing Fit-Gap analysis
• Conduct CRP1, CRP2 and coordinate UAT sessions with keep tracking the pending issue resolutions and work parallel to resolve the same.
• Maintain issue tracker on priority basis and strive to resolve before CRP’s and UAT.
• Involved in Data Conversions, Developing, customizing reports and interfaces in GL Module i.e. Journals importing from mainframe legacy system using SQL Loader.
• Created Accounting Flex Field Structure; Chart of Accounts; Set of Books, Budget Upload from legacy systems using SQL LOADER. Created Master/Detail Budgets, Mass Allocations and Summary Template. Tested features Translation, Reevaluations, and consolidation.
• Designed multiple FSG Reports for Budget Balance, Actual Balance and Funds Available
• Configuration of new customers, new products in Order Management. Developed High Level
• Was a part of team in data conversion for data like supplier data, customer data and Address details
• Customized the Invoice Aging and Customer Balance Report in AR
• Month end support in financial modules AR, AP and GL
• Configuration of new customers, new products in Order Management. Developed High Level
• Developed several BR 100s on required reports to fulfill business needs
• Conduct multiple OWC sessions with Oracle for the speedy resolution of high priority issues
• Registration of Concurrent Programs and Request Sets in AOL and System Administration
• Configure system options, transaction types, auto cash rule sets, remittance banks, bank accounts, receipt classes, distribution sets and payment methods Trained and guided users through the testing period.
• Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions, executing and monitoring of cut over activities
• Create and update all documents and responsible to get signoff from the business team.
• Defined receipt class, specifying creation method, Payment method, clearing method, defining collectors, defining aging buckets

Confidential, San Jose, CA

Environment: Oracle Applications11i (11.5.10)

Oracle Finance Functional Consultant

Key Responsibilities:

• My core responsibilities involved with trouble shooting in the area of AR, AP, and GL modules
• Create and follow-up on multiple SEV1 & SEV2 SRs for speedy resolution explain business team with cause of issue
• Followed up with Oracle team to fix errors while conducting sql code writing, upgrading, manipulating, editing, and inserting using SQL Developer for Oracle DBS.
• Created Users and modified the privileges for the Users, Rollup group and Summary Accounts
• Coordinate with DBA team to apply patches proposed by oracle after following up on existing issues
• Defined and generated FSG’s for Balance Sheets where rollup groups are considered for aren’t/child relationship.
• Activities in System administrator to assign user accounts, assigned responsibilities, menu selection, reports, etc.
• Prepare custom financial reports for month-end process using FSG
• Resolve month end reconciliation issues in GL Reporting standard and FSG reports
• Set-up Multiple Organization Access Control (MOAC) and Multiple Reporting Currencies
• Configured the Multi-Organization Access (MOAC), Ledger Setup, and Legal Entities
• Provide detailed root cause analysis on all assigned issues with reproducing the same in latest cloned copy of test environment
• Provided Users with access to multiple ledgers in GL through the use of GL Data Access Sets and to Multi-Operating Units through Security Profile in a secured environment
• Created Customized responsibilities, customized menus, customized request groups.
• Resolved any month end related issues involving and data fixes or configuration changes
• Responsibility to manage: Creating & Administering Users, Responsibilities, Profile Options, Application Menus and Forms, User and Role Configurations.

Confidential, Fairfield, CT

Environment: Oracle ApplicationsR12.0.6

Oracle Finance Functional Consultant

Key Responsibilities:

• Implemented AR/AP/GL/FA/iExpense and iProcurement.
• Managing and guiding collection of Business Requirements, preparing gap analysis.
• For the identified gaps if its business critical and decided to develop within Oracle, then gathering detailed Functional Specification and Design documents.
• Implemented iexpense and iprocurement using AME.
• Achieved automated accounting (GL Code Combinations) system in iprocurement using expense account rules.
• Identifying list of set of books, legal entity, operating unit and inventory orgs.
• Localization: Responding to certain countries exclusive setup requirement and adhering the same within global policies.
• Identifying list of AR transaction types and order/line transaction types based on business requirement.
• Identifying level of revenue tracking accounts definition. This company has certain unique requirement of revenue tracking which is implemented with few custom codes.
• Service revenue recognition based on number of years of service contracts.
• Gave super user training in GL,AP, AR, Fixed assets
• Involved in setup of Vendor hierarchy’s, parent and child customer relationship and system options.
• Involved in requirement gathering, analysis, design, development, testing, deployment, and production support phase of the project.
• Configuration of GL module, creation of Set of Books and development of interfaces for integration of Oracle General Ledger .
• Creation of FSG (Financial Statement Generator) Reports that included Adjusted Trial Balance Report, Profit &Loss Account Details Statement, Profit & Loss Comparative Balance Statement, Balance Sheet, General Balance Statement, GL Annexure, Fortnightly Statement and some other reports developed for audit point of view, as per the client specified formats.
• Developed RDF reports to show the individual account balance complying with government standards in various layouts like Matrix, Tabular and Form etc.
• Creation of template using ADI tools for Journal Upload and Currency Rate upload.
• Development of Functions, Menus, Creation of Responsibilities and Profiles.
• Completing Month and Year Close activities that included Profit transfer to retained earnings and closing income statements and generation of all related fiscal report for the closed periods and year.
• Reconciliation of balances in Oracle General Ledger.
• Documentation of all the changes made during requirement gathering, implementation, development, testing phase of the projects.