SUMMARY

• Extensive IT experience, which includes 8 years of experience working in analyzing, designing, developing, testing, Implementing, Up - gradation and Post-Production Support for various businesses using Oracle Applications 11i, and R12 with Sub Ledger Accounting (SLA)
• Vast understanding of Corporate Finance, Cost Accounting, Managerial Accounting, and Principles of Financial Accounting, MIS reporting, Regulatory Reporting and IFRS requirements as per industry norms
• Excellent functional expertise in Oracle Applications with Implementation, Up gradation, Testing and Post Production Support of General Ledger (GL) including Advanced Global Intercompany System (AGIS), Accounts Payables (AP), Purchasing (PO) including P2P Cycle, Accounts Receivables (AR), Cash Management (CE), Fixed Assets (FA), E Business Tax (E-B TAX), i-Expenses (iExp) and System
• Administrator, Excellent knowledge on Multi-Org, Intercompany, MOAC and AGIS
• Worked Extensively on Application Implementation Methodology(AIM), business requirement gathering, understanding As-Is Process, designing solutions (To-Be Process), performing gap analysis, building RICE (Report, Interface, Conversion, Extension),components & setup of modules for CRP testing, end-user Training, UAT, documentation and production support
• Delivered Conference Room Pilot (CRP’s) sessions and helped in troubleshooting user concerns, issues during CRP and UAT
• Worked on Sub-Ledger Accounting (SLA) rules for replacing traditional transaction codes needed for generating multiple accounting representations for a business transaction
• Experienced with extensive hands on with creation and maintain of BP80, MD50, BR150, BR30, RD20, TE40, BR100, CV040 documents including Functional Impact Analysis
• Good understanding of Data Conversion and Data Migration process including vast expertise in Global implementations and working with large group of business users and Onsite & Offshore model projects
• Experienced in developing and implementing test strategy for functional testing environments (Unit, Integration & UAT) includes providing functional impact analysis as part of Change Management Process
• Conduct Oracle Web Conference (OWC) with Oracle Technical Support for all high prioritized issues
• Expert in System Administration in defining users, menus, responsibilities, printer set-ups and maintaining concurrent programs. Defined Custom Applications, which includes new Menus, Request Groups and Responsibilities using Application Developer and System Administrator responsibilities
• In depth understanding on Procure to Pay (P2P), Order to Cash (O2C) and Acquire to Retire (A2R), and Record to Report (R2R) business process flows
• Designed & developed training material, User Manuals and conduct training to all levels of users

TECHNICAL SKILLS

Tools: Web ADI, Hyperion, OBIEE, Data Loader, TOAD, SQL Loader, Discoverer, Mercury Testing tools

Oracle Versions: R12.0.3, R12.0.5, R12.0.6, R12.1.1, R12.1.3, R12.2 & 11i - 11.5.10.2

Software and OS: Microsoft Office, SPSS, Windows 7/Vista/XP/ME/98/95

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

Oracle Financials Analyst

Responsibilities:

• My responsibilities include requirement gathering, current business process analysis, re-engineering and designing of business process, system configuration and system testing.
• Designed Key Accounting Flex field structure (COA) for Ledger and configured with Multi Org and Multi Reporting Currency setup. Defined system controls, intercompany accounts, summary accounts, journal sources, and journal categories.
• Conduct multiple meetings with Business and Technical team at different intervals for various purposes.
• Defined payment terms, setup payment process profiles and also configured the payment manager.
• Defined suppliers and supplier sites. Setup bank, bank branches and bank accounts.
• Configured profile options for invoice batches, setup manual holds and reasons, setup invoice tolerances
• Defined various currencies for multi currency operations and currency translation, conversion, revaluation has been done to meet the requirement. Cross validationrules have been setup for various GL codes. Configured Sub-ledger accounting process to GL.
• Reviewed current business process and documented the business procedures for Procure to Pay and Project Invoicing to Cash Receipts.
• Payables process had been designed and system had been 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, cross currency invoices etc.,
• 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.
• Configured CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration.
• Tested various AP inbound and outbound interfaces during CRP2 defects remediation.
• Coordinate with Technical team for timely deliverables of RICE components. Conduct OWC sessions with Oracle Technical Support for all opened and high prioritized issues for its speedy resolution.
• Maintained and updated the development issue log tracker, enhancement tracker and the defects tracker.
• Prepared Cut- over Plan, Listing down all Pre & Post Go- live tasks. Involved in Post-Production support.
• Created/Maintained Business process Documents BP-80,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 as part of project implementation task.
• Provide Month end support in all financial modules CE, AP, GL including P2P.
• Conduct OWC sessions with Oracle Technical support for speedy resolution of existing open issues.

Confidential, St. Petersburg, FL.

Oracle Financials Analyst

Responsibilities:

• Study of the current Business Process and GAP Analysis using AIM documents,
• Preparation of BR100, Common Set-ups doc, Sys Admin Set-ups documents.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.
• Gathered application requirements and provided design recommendations.
• Assist in functional design with respect to custom data models that integrated with Oracle Applications.
• Involved in Sarbanes-Oxley (SOX) compliance testing process by including paper-based evidence, e.g., invoices, delivery receipts, purchase orders, bank statements and expense receipts
• Defined period types, calendars, Distribution sets, Tolerances, bank accounts payables documents, payment terms, approval groups and approval assignments.
• Participated in customization and personalization of iExpense pages.
• Configure complete GL including Org Structure, Rollup groups, parent child accounts, CVR’s & Value sets.
• Defined Ledgers and Ledger sets, Journal sources and categories.
• Defined Legal Entities and Operating Units for AP configuration. Configured Financial, Payable and Payable System options.
• Created Payment terms and Payment Process Profiles.
• Participated in setting up of tax users and profile option values in EB Tax.
• Configured GL Tax options and Ledger options for E-Business Tax functionality.
• Involved in setting up of Tax Configurator in EB Tax. Defined Tax defaults and Tax rules.
• System Administrator skills - user creation, defining responsibilities, profile options and securities.
• Defined roll up groups to provide the customize reports to the top management with drill down features.
• Involved in regression testing and UAT.
• Configured the setups for prepayments and adjustment to payment to suppliers
• Coordinated and monitored Month End Closing process.
• Generated various reports in GL, AP and SLA. Changed the submission instructions on the iExpenses page
• Established control over data access with creation of Menus and Responsibilities and by setting up flex field security rules.
• Involved in the production support of AP and CE modules and support Month End close process as well

Confidential

Oracle Financials Analyst

Responsibilities:

• Supported Post-Implementation phase for all Oracle Financials Modules
• Production support, interfaces maintenance, change management, month end closing
• Resolved the issues related to credit card payment processing, payment authorization, payment capture
• Prepared and modified MD50’s for different reports like Product profitability report, PO received but not invoiced report, etc.
• Created the extensive test scripts TE 40 to verify the reports; tested, verified and deployed to production
• Resolved the issues related to automatic refund of credit card charges stuck in the receivable workbench
• Researched and resolved PO number in customer credit card statement for refund transactions
• Resolved the issues related to credit card refund, return, bills only, freight charge return, not invoicable items, credit card authorization, consolidated invoicing, in order management and receivables
• Coordinated with the offshore technical team to work on custom reports
• Resolved the issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, customer statement report
• Involved in supporting Super Users and End users in period end closing
• Worked on development of new FSG reports and customized various standard FSG reports
• Worked with technical team regarding RICE components
• Supported Post-Implementation phase for all Oracle Financials Modules
• Worked with Oracle Support to resolve the critical issues through SR/TAR
• Involved in documentation of Frequent Mistakes and Error made by end-user in application based on issue log register

Confidential

Oracle Financials Analyst

Responsibilities:

• Worked with the client team in understanding the business processes to prepare the business requirements definition document
• Worked with technical consultant for data conversion
• Scheduled CRP for Configuration Testing
• Developed FSG Reports for customized Financial Statements - Division wise and Department wise Breakup of Expenses and Revenue and allocation of corporate and Branch expense to their divisions, products and departments
• Involved in documentation of conversion (CV-40), Function extension design document (MD-50), Test scripts (TE-40) and System Set up Document (BR-100) as per AIM Methodology
• Configured Payables System Options, Payable and Financial options
• Setup book controls, corporate book and tax book
• Defined Payment Terms, Payment Set ups and Distribution Sets
• Setup Suppliers, Supplier Sites, Banks, Bank Accounts and documents
• Defined Split payment terms for invoice installments that have different due dates and assigned multiple discounts to each payment line
• Defined formulas for Mass Allocation and Recurring Journals. Completed setup of options required to perform Mass Allocations
• Involved in Period Closing & Reconciliation with GL
• Conducted Training to User and super User for GL, AP, and FA

Confidential

Oracle Financials Analyst

Responsibilities:

• Gathering the requirements and preparing the documents using AIM methodology.
• Mapping the Client Requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of Customizations, workarounds, and reengineering and form personalization.
• Prepared RD020, BP040, BP080, BR100, MD050 documents for each financial module
• Prepare AS-IS of current system, find and recommend work around of GAPS.
• Created Data Access Sets, Data Definition Sets for Mass Allocations.
• Defined and Assigned Document Sequencing for Audit trail.
• Created Mapping rules as part of the Consolidation setup and defined intercompany accounts.
• Created Auto Accounting, Distribution sets (AR) and Auto Cash Rule Sets.
• Configured the Category, Asset Key and Locational Flexfields for System Control setup. Created Corporate books and Tax books.
• Created inter company Transactions, Elimination entries setups and configuration for use of ADI wizards like Budget wizard, Journal wizard, simplifying work with general ledger.
• Designed and executed several Customizations and Setups in ERP as a part of Revenue Recognitions
• Provided solution for Revenue Recognition requirements by developing extensions.
• Configuring the Oracle Accelerators, which can do the setups automatically in client’s targeted instance.
• Performed Unit testing, UAT and End-User training for Go-live.
• Preparing TE040 Documents, which can helpful to test the application functions.
• Participate in Analysis, Design and Testing of the code and documentation.

Confidential

Oracle Financials Analyst

Responsibilities:

• Set-up of financials options, payables and payables System options in AP
• Configured the Sub ledger Accounting(SLA) setups
• Created customer profile classes, attached payment terms, collectors, matching receipts, statement cycle to profile classes
• Interacting with Oracle development team regarding issues resolutions.
• Worked with technical consultant for data conversion
• Involved with migration of historical data for Accounts Payables and Oracle Assets
• Configured AP (Financial and Payable Options), Assets (System Controls and Book Controls)
• Configured Auto reconciliation of Bank Statements.
• Interfaced invoicing activity in Payables with Transactions in Assets.
• Set-up of invoices, debit and credit memos, guarantees and chargebacks
• Created user-manuals and trained the end users
• Extensive unit and integrated testing done before CRP & UAT
• Prepared the MD 50 and worked with technical team regarding RICE components
• Conduct multiple CRPs and coordinate UAT with large group of users
• Prepared and executed test scripts (TE 40)

Confidential

Oracle Financials Analyst

Responsibilities:

• Involved in Data Conversions, Developing, customizing reports and interfaces in GL Module i.e. Journals importing from mainframe legacy system using SQL Loader
• Involved in the Functional Setup of GL, AP, AR, and PO
• Identified gaps between system processes and Business processes and documented using Gap Analysis Document. Also analyzed and indicated proposed workarounds and resolutions
• Involved in data conversion for data like supplier data, customer data and Address details.
• Month end support in financial modules CE, PO, AR, AP and GL
• Registration of Concurrent Programs and Request Sets in AOL and System Administration
• Identification of master data like Items / Suppliers and setting up the master data in Oracle 11i
• Customized the Invoice Aging and Customer Balance Report in AR
• Gathered, analyzed and wrote detailed business requirements, user profile, created workflow processes documents and charts
• Knowledge of Performance tuning of various queries and stored procedure
• Involved in post production troubleshooting exercises, bug fixes, raising TAR's and working with oracle support for escalating issues and finding resolutions
• Created Accounting Flex Field Structure; Chart of Accounts; Set of Books, Mass Allocations and Summary Template.
• Perform thorough testing of key features Translation, Reevaluations, and consolidation. Designed FSG Report for Budget Balance, Actual Balance and Funds Available
• Prepared end user training material with specific business cases and conducted end-user training

Confidential

Oracle Financials Analyst

Responsibilities:

• Responsible for the documentation (BR.100 -Application Setup and TE.040 -System Test Script) and setups of the General Ledger and Account Payables Modules
• Created BR100 documentation for GL and AP
• Interacted with the client team to understand the existing business practices and prepared the business requirement definition document
• Participated in designing the chart of accounts to meet the client’s business requirements
• Created Customized responsibilities, customized menus, customized request groups
• Used Accounting Setup Manager for Inter-company Transactions
• Worked with Technical team regarding conversion of data
• Provided various custom solutions for client’s specific needs
• Created the MD 50 for each RICE components
• Created Test Scripts (TE-40’s) for UAT sessions
• Created user-manuals and trained the end users

Confidential

Oracle Financials Analyst

Responsibilities:

• Reviewed Business Requirement Documents and developed the implementation strategy.
• Identified standard & required functionality, developed gaps document and design solution for GL, CE, AP(with PO)
• Prepared the CRP plan, conducted kick off meetings, created testing trackers and metadata for reference
• Designed COA Structure for Ledgers with Multi Org and Multi Reporting Currency setup.
• Defined system controls, intercompany accounts, summary accounts, journal sources and categories.
• Defined currencies for multi currency operations and currency translation and conversion.
• Set up cross validationrules and configured Sub-ledger accounting process to GL.
• Designed Payables process and configured and setup system financial options, Payable system options & Payables options for P2P.
• Configured and setup Ledger, Legal Entity, Operating Unit and Locations for new countries
• Developed batch invoices, batch payments, employee expense report process, withholding tax, 1099 reporting, cross currency invoices and payments.
• Prepared the custom PO Print Program MD050 and worked on custom PO Detail Report.
• 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.
• Conducted meetings with AP and Treasury to decide the payment methods and further, prepared MD050 and payment generation files for Domestic and International Wire payment methods.
• Completed Mexico bank integration with HSBC for ACH and WIRE payment methods.
• Prepared BR100, MD050, TE40, TE050 and conducted regression testing and OATS testing
• Conducted CRP's and Business Super User Training using Oracle tutor and WebEx virtual training

Confidential

Oracle Financials Analyst

Responsibilities:

• Responsible for preparing upgrade plan for GL, AP & FA
• Prepared impact analysis document for the upgrade of financials module
• Conducted study on current business process and designed future state functional requirements in GL, AP and FA. Designed payment batch process for EFT process and tested.
• Performed system integrity and functionality test by running the regression test suite for various scenarios in General Ledger, Account Payables, Fixed Assets to meet the desired business process.
• CRP’s and user acceptance test (UAT) was carried out in above modules. Trained the end users in major changes in version 11.5.10.2 and resolve the issue during UAT.
• Create and updated MD- 50s for custom reports and documented Test Scripts for user training for the same
• Supporting day to day production issues, gathering requirements, configuring and testing system to meet the requirements. It includes documentation and user training on new processes.
• Provided period end closing process for Payables and General Ledger. Resolved period end closing issues.
• Analyzed the requirements/process issues and designed a business process to meet the functional requirements for enhancements, Period End closing and production issues.
• Coordinated with oracle support, created and followed up with service request

Confidential

Oracle Financials Analyst

Responsibilities:

• Involved in Month-End support for closing, reconciliation for Account Payable and Receivables modules
• Prepared Impact Analysis of critical Post-Production issues
• Resolved issues that had occurred in the Production Phase
• Followed up with the Business Client for the approval of the resolute issues
• Worked with the business clients to create updated business policies based on the resolved issues
• Actively involved in troubleshooting various issues
• Provided functional support to the production environment and performed complete Integration Testing and Analysis for the different modules like AP and AR
• Updated documentation for the proposed custom process issue resolutions
• Provide functional extension design for all proposed custom areas of key business processes
• Resolved all the defects that were raised in Bugzilla
• Interacted with Oracle support to resolve critical issues through service requests
• Periodically send status updates to PMO and followed up with pending business input or issue resolutions

Confidential

Oracle Financials Analyst

Responsibilities:

• Worked with the client team in understanding the Business Process to prepare the Business Requirement definition document (AIM).
• Created the General Accounting functionality by setting up Chart of Accounts and Fiscal Calendars
• Defined the Multiple Set of Books, Accounting Periods, and Journal Sources.
• Defined payment terms, Distribution sets, Tolerances and Expense Templates.
• Defined recurring invoice templates. Set up employee expense templates and distribution sets.
• Defined value sets, key Flex field segments and roll-up groups with security and cross validation rules and Used ADI (General Ledger Desktop Integrator) to integrate the GL module to the Excel spreadsheet.
• Activated some descriptive flex fields to capture additional information for the client not available in standard Oracle forms, set up Suppliers and Banks for AP use
• Created Users and Responsibilities in System Administration.