SUMMARY

• Have a total experience of 7 years as an Oracle Financials Functional/Business Analyst with experience in multiple versions of Oracle E - Business Suite and Oracle Fusion Financials R9 & also as a Business Analyst in Financial, Healthcare & Hospitality domains.
• Worked on multiple Global Implementation, Upgradation, and Post Production Support projects
• Working knowledge on Finance, Healthcare & Hospitality domains for Business Analysis
• Extensive Knowledge on GDS, CRS like Sabre, Galileo & Armadeus systems in hospitality domain
• Knowledge on HMO, PPO & POS and also EDI Gateway in healthcare domain
• Excellent skills with playing vital role in conducting numerous business meetings for all key important business process decisions and proposed solution in Oracle according to the size and nature of the organization
• Extensive knowledge in General Ledger(GL) with Advanced Global Intercompany Systems(AGIS), (EDI) E-Commerce Gateway, Sub-ledger Accounting(SLA),Account Receivables(AR),Account Payables(AP), iExpenses, Fixed Assets(FA), Cash Management(CE),E-Business Tax(E-B.Tax), Purchasing(PO), iProcurement & BI Publisher
• Having process knowledge on Order Management, Purchasing, and Inventory; moreover, Procure to Pay, Order to Cash, Acquire to Retire process cycles with cross function integration.
• Tremendous knowledge of Multi-org, Advanced Global Consolidation Systems, Advanced Global Intercompany Systems, Financial Statement Generator and Sub-ledger accounting.
• Expertise in requirements gathering, designing, development, documentation & follow ups on business approvals
• Excellent knowledge in preparing and maintain Oracle AIM methodology documentation including RD20, BR30, BR100, BR150, BP80, MD50, TE40, and CV40 and Change Management Process documentation
• Preparing test scripts, performing quality assurance tests (Smoke testing) prior to user testing.
• Proficient in providing design solution for all custom components (RICE/CEMLI)
• Adapt in Data Conversion with data migration Lifecycles
• Expertise in working on multiple versions of Oracle in both R12 and 11iand Fusion Cloud R9
• Experience in using some tools, but not limited to, are ADI, Web ADI, Hyperion, BI/XML, and Discoverer
• Excellent in process mapping, process improvement, configuration, development, functional documentation, documentation, and production support
• Played key role in providing manual work around solutions for critical business scenarios in order to minimize the customizations and provide sophisticated solution for constructive business transaction process
• Knowledge on financial accounting & business processes, but not limited to, but including: financial accounting process through financial closing; revenue & expense cash/accrual concepts; adjustments & financial statements
• Other knowledge areas consist of finance strategies, financial accounting and reporting operations, budgeting, planning and forecasting operations, performance management and measurement, and statutory reporting systems
• People and functional management principles including planning and organizing team work, organizing and monitoring work assigned, motivating team members around shared vision, skill alignment with proper resources
• Excellent analytical, problem-solving, negotiation, task and lean project management skills

TECHNICAL SKILLS

Oracle Modules/Cycles: GL, AGIS, SLA, AP, AR, FA, PA, E-B.Tax, CE, Sys Admin,AGIS, EDI Gateway, Fusion Cloud R9, Procure to Pay(P2P),Order to Cash(O2C), iProcurement & iExpenses

Operating Systems: Microsoft Windows 98/XP/Vista/7, Windows NT 4.0/2000 Server/Workstation, Linux OS Red Hat Enterprise, UNIX OS

Other Tools: ADI, Web ADI, SQL Plus, TOAD, PL/SQL Developer, SQL Loader, Data Loader, HP/Mercury Quality Center, Discoverer, BI/XML Publisher & Hyperion

Programming Languages: SQL & PL/SQL, Mat LAB &C

Other Software: PVCS Tracker, Mercury ITG TD, Microsoft Office Project, Word, Excel, Power point, Visio, Access, BI Publisher, Eclipse IDE, Adobe Photoshop, CorelDraw, AutoCAD, Solid Works, Catia V5

PROFESSIONAL EXPERIENCE:

Confidential, St Louis MO

Oracle Financials Functional/Business Analyst

Environment: - Post-Production Support of R12.2

Responsibilities:

• Ran SQL queries to find data in the interface tables and also for report outputs
• Identified and worked on the issue of AP invoice Report.
• Worked on the customization of Account Analysis Report for users & communicated with technical team to make change in the Database.
• Trained Financial Analysts to work on GL Reporting Manager Tool to make changes in any kind of non-standard reports.
• Identified issues in Discoverer Manager for Reconciled AR Reports and communicated with the offshore team to make change in the setup
• Simultaneously worked on identification of issues in AP and AR. For example: Payment Process Request & AR Transaction types and Receipt class and methods
• Created SRs for AR interface lockbox and other customer relationship issues. Simultaneously closed the SRs that were open once the issue was resolved.
• Closed Asset keys for the users so they cannot process any invoice against them as per requirement
• Worked on testing transactions of new transaction type setup in OM & AR to check interface and match the generated invoice number. Also replicated the setup in other instance copies and tested the setup.
• Created BR100, MD050, Instance Configuration Data, Issue log & Daily Waterfall Log Documents for functional & technical support team

Confidential, Santa Clara, CA

Oracle Financials Functional/Business Analyst

Environment: - Post-Production and End-to-End Implementation Lead for R12.2

Responsibilities:

• Troubleshooting of invoices and created SQL queries to find the interface tables and for report outputs
• Analyzing the Business Rule Document and providing different approaches to the technical team for efficient data validation process
• Analyzing issues with invoice, Purchase orders and receipt matching and providing solutions to the AP team
• Migrated trading partners and code conversion from legacy system to Oracle
• Analysis of Business rule document and technical queries for invoices
• Worked on running automatic 810 invoice inbound program at intervals customization setup and 820 payment remittance program
• Ran 824 outbound interface program to send notification to supplier to resend invoices
• Worked on Change request for report customization
• Worked on customer/supplier association in Intercompany setup
• Worked on Account Derivation Rules customization for TAD setup
• Worked on the AP &AR setup for all operating units for testing intercompany transactions
• Analyzed the reason behind missing Invoices from front end and coordinated with the Technical Team in and helped them in Building technical queries
• Updated Business requirement (BR100), module design (MD050) and test plan and test cases documents
• Interacted with Business customers, developers and Oracle support for AP team
• Tested Intercompany transactions and matched with AP & AR invoices and transactions and created test documents
• Team Lead for running UAT for AGIS

Confidential, Hanover, MD

Oracle Financials Functional Analyst

Environment: - Upgradation and Support for 11.5.10.2 to R12.2

Responsibilities:

• Participated in the meetings with the Technical team and coordinated with the Business regarding various methods and approaches for data validation
• Compared the data like Supplier information, Open Invoices, Not-Validated Invoices and Historical Invoices extracted from 11i version and R12 version of Oracle and validated the missing and not-migrated Invoices
• Worked on Base Tables and provided information to the technical team on table names and field names
• Analyzed the R12 Migration Roadmap and helped the technical team in analyzing the outputs of standard programs like Supplier Import Program, Journal Import Program etc.
• Analyzed the errors in the output of standard programs and discussion with the technical team with the solutions
• Understanding the COA mapping from 11i to R12 including account-Subaccount mapping and analyzing the differences
• Involved in creating Custom Reports for different currencies and for multiple Operating Units for Budgets, Suppliers, Employees, Open and not Validated Invoices
• Analyzing the R12 Migration Issues with the Global IT team
• Worked in the environment of report creation in BI publisher for reports & Discoverer Administrator for creating custom folders

Confidential, Greenville, SC

Oracle Financials Functional Analyst

Environment: Post Production Support of 11.5.10.2&R12.1.3; Re-implementation of R12.1.3

Responsibilities:

• Provided 24/7 support for 11i & R12 globally for India, Mexico, North America, Canada, and European countries; furthermore, worked on R12 re-implementation
• Monitored, maintained, and fixed issues related to standard and custom interfaces
• Worked with Oracle Global Customer support in analyzing patches, data fixes, and applying solutions
• Documented root cause analysis (RCA) for all production issues
• Conducted in-depth functional impact analysis on proposed business change request
• Provided support in closing AP, AR, PA, FA, GL periods during month end
• Fixed issues related to sub-ledger accounting for AP, FA, AR, and PA
• Worked on creating projects and project templates as per business requirements
• Added new parent and child values for new stat accounts
• Resolved issues related to MT940 Quantum bank statement data files and fixed bank statements interface errors
• Reconciliation issues between PA and GL, FA and GL, AP and GL, AR and GL were resolved
• Fixed issues related to Financial Statement Generator
• Worked with external and internal Auditors to fulfill Business and IT audit requirements
• Cross-validation rules were revamped and issues related to them were fixed
• Worked on clearing import exceptions related to data flowing in from third party systems
• Set up new asset categories, asset locations, and KFF locations
• Helped business in clearing sub-ledger exceptions for AP, AR, FA, and PA
• Issues related to journal and expenditure web-adi templates were resolved
• Resolved issues related to invalid sub-ledger events
• Set up various taxes for Mexico, NA, and Canada suppliers
• Resolved India localization Non-recoverable tax flow to PA
• Set up suppliers and users; furthermore, worked on security attributes
• Fixed issues related to depreciation process; in addition, setup depreciation for new calendar year
• Assigned menus to custom responsibilities as per business requirements
• Tested various enhancement request (ER) and problem reports in production (PRP); furthermore, UAT was conducted and was signed-off
• Setting up budget templates and fixing issues related to budget uploads from Hyperion to ERP
• Worked on resolving issues with data files when file integration fails due to setup issues or incorrect data coming in from third party systems
• Collaborated with DBAs in executing data fixes and patch applications
• Gathered business requirements and documented enhancement requests
• Worked with solution, release, and global support manager to make sure that the changes are scheduled for production release based on business criticality
• Worked with Oracle to ensure that the modules have up-to-date patches; furthermore, worked on patch impact analysis and testing of functionality after applying patches

Confidential, Wixom, MI

Oracle Business Analyst - GL, AP, FA and P2P

Environment: Oracle Implementation of R12.1.3& Healthcare& Finance domains

Responsibilities:

• Designed and configured Location and Fixed Assets Key Flex Fields, Asset Books, Asset Categories, Asset Sub-Categories, Asset Depreciation, Fiscal Calendar, Prorate Calendar, Security by Book.
• Worked on HMO, PPO & POS configuration
• Interacted with functional team to create tax regimes on premiums & deductibles as per state
• Arranged meetings to conduct workshops for transferring knowledge to the development team on types of insurance & policy clauses
• Worked on the conversion of data from HITT Delivery Systems to Oracle
• Worked on Construction in Process (CIP) assets, adjustments, and classification of assets
• Interacted with business and the implementation team and create a bridge between the gap
• Created test scripts for UAT in TE40 documentation with detailed testing of the modules involved in development of RICE components
• Configuration of CRP2, CRP3, and UAT instances
• Preparing test scripts and performing smoke testing prior to user testing
• Keeping track of and updating issues with proposing resolution in Bugzilla issue tracker
• Involved in month-end closings, interfaces maintenance, and change management
• Designing of user-manuals for the modules and the end users
• Interacting with the technical team for post-production support to the business users

Jr. Oracle Business Analyst

Confidential

Responsibilities:

• Data migration mapping from legacy to Oracle
• Participated in the meetings with the Technical team and coordinated with the Business regarding various methods and approaches for data validation
• Understanding the COA mapping from 11i to R12 including account-Subaccount mapping and analyzing the differences
• Analyzing the R12 Migration Issues with the Global IT team
• Ran queries on TOAD to refer columns in the interface tables to identify issues during migration
• Analyzed the R12 Migration Roadmap and helped the technical team in analyzing the outputs of standard programs like Supplier Import Program, Journal Import Program etc.
• Tested sales orders, bill-to & ship-to locations for customer setup in O2C cycle
• Worked on testing the invoicing rules for recognizing the revenue
• Worked on sales order import issues from legacy to Oracle & bank reconciliation in autolock box