Business Analyst Resume
PROFESSIONAL SUMMARY
- Has around 8+ years experience including around 6.5 years of experience in Oracle Financials E-Business Suite R12 & 11i functional consulting / analysis and related ERP tools / technologies. Has more than 3 years of experience as an auditor and accounting officer
- Domain specialization in the areas of finance, costing, accounting and auditing
- Chartered Accountant from the Institute of Chartered Accountants of India (equivalent to CPA certification), Cost Management Accountant from the Institute of Cost and Works Accountants of India (equivalent to CMA certification) and a business (finance) graduate from Nagarjuna University, India (equivalent to a BS in Finance)
- Oracle E-Business Suite experience – Oracle R12 & 11i (GL, FA, RXI Reports, AP, AR, Cash Management, utility tools (DataLoad, Oracle ADI, WEB ADI etc)
- Proficient in 11i FSGs, ADI & R12 Report Manager
- Played financial functional roles as a consultant and a business support analyst at client sites. Involved in providing functional consulting and support around Oracle ERP suite (finance modules), helped customers with scoping studies and in mapping / modeling financial business processes (Procure to Pay, Order to Cash, and period end close processes)
- Three full life cycle implementations in Oracle Financials from end to end, Two Support and Upgrade projects
- Hands on experience in Oracle Inventory, Oracle Purchasing, Oracle Order Management, Oracle iProcurement and Oracle iExpenses
- Successfully implemented global implementation for clients from Requirement gathering phase to go-live and post implementation support
- Experience in conducting Gap Analysis between the Oracle Financials 11i Suite and client business requirements. Develop technical specifications for customizations, as needed
- Experience in importing master data from legacy systems to Oracle by using ADI, API
- Knowledge of Oracle Metalink functionality/technical support area to aid in resolving application problems and solutions
- Excellent communication skills with positive attitude, good team player and ability to work in stress environment
- Competent in client relation management, presentation, documentation, User Training and support
- Highly motivated individual with strong interpersonal skills, highly adaptable, quick learner with excellent ability to coordinate in a team environment
WORK EXPERIENCE
Client: Confidential,Burbank, CA Feb 10 – Present
Environment: Oracle E-Business Suite 11i
Modules: GL, AR
Position: Business Analyst
Confidential,is a global Internet media company. It provides a range of products and services including a Web portal, a search engine, the Yahoo! Directory, Yahoo! Mail, news, and posting. Project involves supporting multiple yahoo sites and assist system integration in times of acquisitions.
- Implemented financials for 3 new operating units – Mexico, Brazil and Philipines for Search and Media products in complaint to localizations such as design of Cadena Original, Sello Digital and Boleto AutolockBox process.
- Setting up/Merging of Customers and Approval Groups
- Involved in developing custom programs for Revenue Recognition program to recognize revenue on a daily basis
- Responsible for SOX related activities and maintain and update risk matrices to make sure the established controls are in place within the team
- Worked with the engineering, Corporate Systems (IT), and business teams to complete end-to-end validation processes on a periodical basis.
- Assisted the archival project of financial data in Oracle financials which involved CRP, UAT and deployment stages of the project
- Worked with Technical Team to Develop various Discoverer Reports according to business users’ needs
- Troubleshooted support issues and provide immediate resolution to the finance teams to enable the month end process to complete on time.
- Assisted month end close process and responsible for maintaining SLAs established with every business within Yahoo!
Client: Confidential,Oklahoma City, OK May 08 – Jan 10
Environment: Oracle E-Business Suite R12
Modules: GL, AP, AR, FA, Cash Management and iExpenses
Position: Senior Consultant
Confidential,is a global hospitality company with widely recognized, industry leading brands and a tradition of innovation developed over our more than fifty-year history. They manage, franchise, own and develop Hyatt branded hotels, resorts and residential and vacation ownership properties around the world. The project involved end-to-end implementation of Oracle E-Business Suite R12
- Performed review of the business process, involved in Requirements Analysis (Fit/GAP Analysis), prepared System Design Documents / Flows, Test Plan preparations and Development of Business Process / Work Flow charts
- Prepared AS IS and TO BE process documents, understood legacy system and mapped business process requirements
- Conducted review and delivery of all functional documentation and appendices for any additions/changes to existing Oracle R12 solution, test scripts, and setup documentation (BR100)
- Configured SLA for Fixed Asset Cost and Retirements based on expense cost center
- Involved in document preparation – Business Requirements, Functional Mapping (Fit/Gap analysis documents), application setup documents, functional specification documents for customizations
- Extensively involved in the developing Custom Interfaces, Conversions and reports as per the client requirements and Support across different phases of implementation
- Completed setup procedures for GL, AP, AR, iExpenses, Cash Management and FA
- Coordinated Testing (TE40) all application solutions for verification of correct function and meeting business requirements
- Tested sub/legacy system transactions with Oracle General ledger Implementation and post implementation evaluation of internal control processes and ensuring segregation of duties
- Helped in mapping legacy financial reports to Oracle (Standard reports, RXI and FSG reports)
- Have very good command over E-Business Tax engine configuration
- Defined FSG’s for Balance Sheet, Funds Flow statement, Income Statement and various financial reports by department and various segments as needed. Integrated FSG’s with Report manager
- Prepared training material and provided training for all super and end users.
- System cutover, data conversions and post go-live application support.
Client: Confidential,Dallas Sept 07 – Apr 08
Environment: Oracle E-Business Suite 11.5.10.2
Modules: GL, AP, AR and FA
Position: Senior Consultant
Confidential,is a remanufacture of a wide range of automotive drive train products. ATC Logistics and Electronics’ operations consist of turnkey warehousing, distribution, order fulfillment, reverse logistics, information services and remanufacturing and repair of electronics for automotive and electronics components. The project involved implementing Oracle EBS.
- Prepared Architectural documents and their process of using Oracle Apps
- Performed Techno-Functional Support for Oracle Applications
- Study of exiting business process of GL accounting, AR and AP
- Implemented Recurring Journals and Jounral Approval feature in GL
- Implemented Auto lock box, Auto invoicing, Auto Accounting features and Consolidated Invoicing in AR
- Suggested Descriptive Flexi fields, designed custom forms and lookups to track Additional information AR
- Designed and prepared FSG’s to show the Profit or Loss per Balancing segment, Cost centre
- Was responsible for Production set ups for multiple operating units for Purchasing and GL, AP, AR and Cash Management
- Prepared Set-up and Training Documents
Client: Confidential,Dallas, TX Jan 06- Aug07
Environment: Oracle E-Business Suite 11.5.10
Modules: GL and AP
Position: Functional Consultant
Confidential,engages in the ownership, operation, and franchising of premium convenience restaurants in the United States. It offers sandwiches, salads, bagels, pizzas, and desserts, as well as soft drink beverages, teas, and alcoholic beverages. The project involved implementation of Oracle EBS.
- Studied the client current Business process and understand the critical requirements.
- Mapped the client requirements to Oracle functionalities and configuring the applications.
- Prepared the Design specification document for development of Reports and customized interfaces.
- Interacted with the technical team for carrying out the development of Reports and interfaces.
- Implemented set up for CRP instance, by configuring the application to meet the customers business requirements.
- Conducted the CRP demo including the customizations.
- Implemented set-up and configuration of the User Acceptance Test instance.
- Prepared the User Acceptance Test script.
- Set up the Production instance.
- Prepared of URS, Solution Design, User Training and Set-up documents.
- Involved in manufacturing data migration using Interfaces, customized scripts and Data Loader.
- Was Responsible for Client ‘Sign off’ of all the deliverables in manufacturing modules.
- Trained the Key Users and Offered post live support, to resolve any technical issues.
Client: Confidential,Fairfield, CT Mar 03– Dec 06
Environment: Oracle E-Business Suite 11.5.9
Modules: GL, AP, AR and FA
Position: Financials Analyst
This project involves post implementation support for GE Corporate and GE Capital Corporate groups mainly in Oracle Financials and Distribution modules.
The Process supports the already implemented Oracle Apps ERP system. Apart from identifying and removing the existing bugs in the system, the additional tasks involve analyzing the business’s new requirements and customizing the ERP system accordingly.
Provided Post-implementation support in terms of:
- Implemented financials for 2 new operating units
- Defined Purchasing, Receiving and Financial options, Flex-field maintenance
- Set up Buyers and Approval Groups
- Provided ADHOC reports using TOAD
- Created/ updated of SOP documents.
- Responsible in maintaining the tax codes and tax rates in the system by scheduling an interface manually.
- Creation, consolidation and ongoing modification of all the standard operating procedures (SOPs) pertaining to the Sysadmin role.
- Prepared Architectural documents and their process of using Oracle Apps.
- Prepared and tracked the Project plan. Ensured the timelines are met.
- Prepared of training documents
- Month end closing procedure – design, documentation, training and issue resolution
Confidential,Chennai, India June 01 – Jan 03
Position: Senior Accountant
- Specialized in managing Books of Accounts and Preparation of Financial Statements (Income Statements, Balance Sheets) and Financial Reporting
- Extracted information from Oracle System for the preparation of Financial Statements ( Balance Sheet, Profit & Loss A/c, and other annexure thereto)
- Monitored Invoicing, Payroll Processing, Budgeting and Encumbrances
- Interacted with the Senior Management to give an update of the team’s progress and issues arising in the day-to-day business.
- Reviewed the work of the team members to ensure that the quality product goes out and the productivity increases.
- Conducted meetings with the team members on a regular basis to take the status of the team members’ and make sure that there are no obstacles faced by them.
- Communicated to the team members the decisions taken in the Top management meetings and conveying the feedback to the top officials in the organization.
COMPUTER SKILLS:
Office Packages:
MS Office including advanced excel including VBA coding.
Others:
Crystal Reporting XI
SAS File Management, Data Management, Reporting and Statistical application.
SQL, PL SQL
Knowledge of Relational Database Management Systems (RDBMS), data modeling with Oracle 10g database.