We provide IT Staff Augmentation Services!

Consultant Resume

5.00/5 (Submit Your Rating)

Professional Profile:

  • Over 8 years of experience in Information Technology with 5 years as Oracle EBS Functional Consultant on EBS Release12 & Release 11i (R11i -11.5.5, 11.5.9, 11.5.7, 11.5, 10.2) financial modules General Ledger, Accounts Payable, Account Receivables, iReceivables and Advance Collections.
  • Skilled in FSG (Financial Statement Generator) to customize reports extensively under GL module.
  • Proficient in the concepts of Global Consolidation System, Multiple Reporting Currencies and Flex field setup
  • Familiar with AIM methodology to implement Oracle Ebusiness suites models
  • Expertise in Financial Statements and ad hoc reports using FSG (Financial Statement Generator)
  • Strong in Vendor Management and Global Delivery Model to develop complex Enterprise Financial and Accounting Solutions using various ERP product suites.
  • Worked cross functionally with Architects, Developers, System Administrator, DBAs, PM’s, Quality Assurance and Application Support Teams.
  • Good understanding in integrating Oracle Financial with Workflows, Document Management and Reporting
  • Strong in analytical and problem solving skills, effective decision making capabilities and team player with good communication, interpersonal & presentation skills
Skill Set
  • Business System Analyst
  • Business/System Requirements
  • Gap Analysis
  • Design and Implementation
  • Testing and Maintenance
  • Project Implementation
  • Requirements Gathering / Business Process Mapping
  • Application Configuration and Maintenance
  • Compliance and Validations
  • Program Management
  • Project Management
  • Vendor Management
  • Global Delivery Model
  • Change Management
  • Financial Modules
  • General Ledger
  • Accounts Receivables
  • Accounts Payables
  • Cash Management
  • iReceivables
  • iExpenses
  • iPayments
  • Other Modules
  • Advanced Collections
  • Application Desktop Integrator
  • Workflows
  • Order Management
  • Purchasing
  • Tools
  • Rational Portfolio Manager
  • Mercury Quality Center
  • Share Point
  • Microsoft Visio
  • MS Office
Professional Work Experience

Consultant, Confidential,NJ 02/2009- Present

Major responsibilities:

  • Involved in Functional analysis of existing systems and GAP analysis for the implementation of Oracle Advance Collections and Accounts Receivables
  • Responsible for performing the end to end testing of Advance Collections with AR ,iReceivables and other related modules
  • Modified the Dunning Notices and other correspondence as per the business requirement
  • Imparted training to the Business Super Users about the new functionalities and the inherent process changes in the application and design test scenarios and test scripts required for CRP testing
  • Responsible for working with Business Process Owners and End Users towards solution adoption.
  • Created the business process mapping and data flows for Consolidated Invoices in AR
  • Involved in Business Requirements Gathering process along with the creation of Functional Specifications.
  • Worked on learning strategy and documented the same for the Business Users and Management
  • Conducted User Acceptance Testing (UAT) for projects, implementations, system fixes and enhancements
  • Supported and maintained 11i application and troubleshoot and resolve applications functional issues

Technical Environment: Release 12, Oracle E-Business Suite 11i on modules General Ledger, Advance Collections, Accounts receivables, iReceivables, iExpenses, and iPayments. Oracle Discoverer, Oracle Reports and Forms 6i, TOAD, PL/SQL, SQL, SQL * Loader

Functional Consultant, Confidential,NJ 05/2006- 10/2008

Major responsibilities:

  • Provided analysis, design, configurations and testing on Financial and Accounting Apps (General Ledger, Accounts Receivables, Accounts Payables and Purchasing) for Offshore and Onshore Projects.
  • Developed questionnaire to congregate information required for the implementation of new ERP platform. Delivered functional documents and setup process for ERP implementations.
  • Build consensus with all stakeholders to formalize, clarify and document functional requirements
  • Created process flow diagrams for Order to Cash Cycle and Intercompany Invoices
  • Involved in managing Concurrent Programs, application user setup and defining responsibilities.
  • Managed testing, training and documentation of financial modules. Writing training documentations and configuring during go-live. Resolving system issues with functional setups.
  • Developed reports to support accounting division in using the new ERP platform.
  • Managed upgrade test cycles and issue tracking with client. Coordinated and participated in the entire phase of project – assessment, business process evaluation, testing, and training.
  • Performed all testing activities such as creating test scripts, test plans, cases, test data and procedures in details.
  • Developed custom financial reports using FSG in collaboration with Oracle Application Desktop Integrator

Created reports in Excel on a disconnected client and then import them directly into Oracle General Ledger

  • Worked on Import Invoices from Legacy to Oracle AR using standard Auto Invoice
  • Identified the gaps in the existing setup in the oracle system by way creating new defects and working closely with oracle support team in issue resolution and change request process (CR)
  • Worked on Invoice Validation, Holds and Release in Procure to Pay Cycle
  • Provided level 1 and 2 post production support to end users

Technical Environment: Oracle E-Business Suite 11i on modules General Ledger, Accounts Payables, Accounts receivables, Cash Management, Fixed Assets, iReceivables, iPayments, Advance Collections, Human Resources and System Administration. Oracle Discoverer, Oracle Reports and Forms 6i, TOAD, PL/SQL, SQL, SQL * Loader

Oracle Consultant, Confidential,NJ 10/2005- 05/2006
Significant project experience:

  • Business Analyst – Oracle App. implementation – NY Offices Of Alcoholism and Substance Abuse Services

Major responsibilities:

  • Responsible for on going System Integration Testing and UAT phase and user training
  • Perform gap analysis in current system. Assess, evaluate and establish the business requirements for implementing ERP solutions
  • Design discussions with the development team and review all documentation and code samples
  • Validate and test the developed system with business users and operation team
  • Work with business users for any change requests and coordinate with the development team for implementing change requests
  • Work with training group to develop training material for the business users
  • Provide functional knowledge and best practice business process expertise across the Order to Cash cycle
  • Actively involved in Oracle Financials Implementation and Oracle Application Support

Technical Environment: Oracle E-Business Suite 11i on modules General Ledger, Accounts Payables, Accounts Receivables, Cash management, Fixed Assets. Oracle Discoverer, Oracle Reports and Forms 6i, TOAD, PL/SQL, SQL, SQL * Loader

Accounting/Financial Supervisor, Confidential,India 04/2003- 03/2005

Significant project experience:

  • Accounting Financial Analyst – Maintain accounting division in a real estate company

Major responsibilities:

  • Developed and monitored all planning and budgeting parameters and internal financial reports, including allocation factors for distribution of common costs and analysis of profits by projects
  • Responsible for all accounting, budgeting, financial reporting, and tax operations for real estate investment subsidiary.
  • Performed Finance and Accounting functions for several departments.
  • Handled budgets, reports and financial statements. Maintained account reports, and tracked spending and cost variances for reporting to senior management.
  • Conducted the overall financial analysis
  • Assist Accounts Payable accountants in resolving operational matters and work closely with the Procurement department to resolve receiving and other Purchasing activities and related matters
  • Processed invoices for payments and purchases. Gathered, analyzed and prepared financial summaries.

Investment Assistant, Confidential,India 08/2002- 03/2003

Significant project experience:

  • Investment Assistant – Provide client services for high net worth investment clients

Major responsibilities:

  • Responsible for all shares, debentures and fixed incomes and other records as per Stock Exchange requirements for a company
  • Prepared analysis and interpretation of financial statements and related reports
  • Involved in the Compliance of Company law matters of all the group companies and responsible for all other secretarial matters
  • Research and analyze financial data; prepare summary analyses as assigned
  • Collected information used for financial analyses through internal and external reports
  • Participated in preparing long-term strategic plans for the Portfolios
  • Research client portfolio holdings.

Education and Professional Training

MBA (Specialized in Finance)

Oracle Apps R12
(General Ledger, Accounts Receivable, Accounts Payable)
Oracle 11i
(General Ledger, Accounts Receivable, Accounts Payable,
Fixed Assets and Cash Management)

Key ERP Implementation – Project Details Role: Functional Consultant

Key Clients: Office Depot, Johnson and Johnson, Caribbean Financials, Carlson Companies, Martha Transportation and NYOASAS

  • Implementation of Oracle Financials at a Global supplier of office products and services - Successfully executed SIT01 (System Integration Testing) testing on time by working closely with Accounts Receivables Team, Implementation Team and off shore development team. Reviewed and made recommendations to improve business process flows for customer strategies for collections such as, Collection strategies, dunning plans, delinquencies. Also worked with Oracle Support Team for issue resolution and change request. Responsible for performing the end to end testing of Advance Collections and iReceivables with AR. Designed script for Month End Process, Promo Code and Bank Handling Errors. Worked on defects, fixing it and retesting the scripts and updating the QC.
  • Implementation of ERP Application for a leading Pharmaceutical Firm – Support the program office in managing a complex effort. This effort consisted of rotating 8 different operating companies through a centralized program in the attempts to resolve any and all outstanding problems related to each Operating Company, critically handled tracking, managing and following up on all working session actions. (Issue Tracking, Work assignments, User Acceptance Testing )
  • Implementation of Oracle Financials on for an International Financial Firm – Evaluated the requirements and performed FIT-GAP analysis between functional features and business needs. Completed the as-is study of the project including open issues, pain areas and expectations. Interacted with the key users to understand the existing business practices and gather business requirements (Business Process Analysis, Gap Analysis, and Business Functional Requirements) Presented Intra company transaction process flow.
  • Implemented Oracle Financial Suite for a Global Leader in marketing, travel and hospitality industry – Worked on order to cash module and performed system integration testing to identify any potential production issues. The result of the team\'s work led to 30% reduction in the time to process invoice and other accounting processes.Handled Integration issues, testing strategy included SIT, UAT and Regression Testing processes. Reviewed and approved the RICE items (Reports, Interfaces, Conversions, and Extensions) for the financial modules along with Accounts Payable, Order Management.
  • ERP implementation for a Mass Transit Authority – Successfully designed, configured and tested FSG (Financial Statement Generator) reports in using the new ERP platform for 11i. The result of the team’s work led to improved reporting capabilities and increased employee information and data ownership required to support the current accounting process and 50% reduction in the time required to retrieve and analyze data.
  • Upgrading of ERP Application for a Federal Client – Up gradation of Oracle Applications of General Ledger, Accounts Payables, Accounts Receivables, Purchasing, and Fixed Assets. Performed UAT (User Acceptance Testing) Managed upgrade test cycles and issue tracking with testers and technical team. Trained employees on upgrade and testing procedures. Assessed the current use of Oracle Applications 5.03 and the mapping of new features and functionality of 11i to the functionality required in the new CAS environment
  • Worked for Real Estate Company as an Accounting /Financial Analyst – Responsible for all accounting, budgeting, financial reporting, and tax operations for the real estate investment subsidiary. Performed Finance and Accounting functions for several departments. Handled budgets, reports and financial statements. Maintained account reports, and tracked spending and cost variances for reporting to senior management. Processed invoices for payments and purchases.
  • Worked for Financial firm as an Investment Assistant – Resolved and respond to routine client inquiries. Worked with Financial planner to research client portfolio holdings. Clients were pleased with services which lead to more business for the firm.

We'd love your feedback!