Docstoc

APPS Functional Consultant

Document Sample
APPS Functional Consultant Powered By Docstoc
					                                               Rajendra Pendurthi
Summary:
Over 10 years of strong experience as Financials consultant Expertise includes over 7 years strong Functional
Experience of which in implementation, customization and testing of Oracle Applications Financials
11i/11.0.3/10.7 with Multi Reporting Currency (MRC), Multi Org and Global Intercompany System setup in a
single instance. Extensive experience in business processes evaluation, process flow development, and
configuration of test instances, unit and integration testing, documentation, end-user training, go-live and post-
implementation support. Knowledge in GAAP analysis, database tables / views and scheduling interface
programs. Knowledge in using Oracle 9i/8i, SQL*Loader, Work Flow. Functional knowledge in
implementation and system testing of core financial modules in R12 version. Proficient in corporate
finance/resource planning, financial systems evaluation, design and implementation

Technical Skills:

ERP:                             Oracle Financials Re. 11i (11.5.4, 11.5.7, 11.5.9, 11.5.10, 11.5.10.2, R12 and
                                 10.7) General Ledger, Accounts Payables, Accounts Receivable, Fixed Assets,
                                 GIS, Cash Management, Purchase Order, Inventory, iExpense, iProcurement,
                                 iReceivables and System Administration,.
Oracle CRM:                              CRM Foundation, Core Service, Sales, Marketing, Contracts.
RDBMS:                           Oracle 9i/ 8i.
Tools/Utilities:                 FSG, Web ADI, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Discoverer,
                                 Work Flow.
O/S:                             Linux, Sun Solaris 2.8, Windows 2000/NT 4.0/98/95.

Education:
MBA Financial Management & Marketing Management, India

Oracle Applications Skills:

Functional Experience:
Thorough functional knowledge including business analysis and setup activities in implementation of General
Ledger, Payable, Receivable, Fixed Assets, Cash Management, Inventory and Purchase, With MRC, Multi-Org
and Global Intercompany System setup in a single instance, which consist all aspects of software Development
Life Cycle and Production troubleshooting of Oracle Financials implementation. Experience in Unit testing,
System integrity tests and user acceptance testing. Comfort Level in Service, Sales, Marketing Modules
Knowledge in CRM Foundation, Service-Contracts, Field Service, and Depot Repair in service module.
Knowledge in Lead creation, Opportunity generation and Quotation in Sales Module and create Programs and
Budget for Programs in Marketing Module and also setups performed in other ERP Applications required to run
CRM.

Technical Experience:
Technical and Business analysis skills to create functional and technical specifications, impact assessments,
including installation, configuration, User administration which includes Defining Application and Oracle
users, Creation of Responsibility and Assigning to users and Setting Profile Options. Scheduling Standard
Request Submission. Concurrent Manager and Standard Request Administration. Ddevelopment and
Registration of Forms, Reports. Experience in building FSG Reports, Concurrent Programs registration and
defining Key Flex field structures. Experience in Journal Interface, Invoice import Interface, Auto Invoice
Interface, Auto Lock box Interface and Customer Interface programs. Experience in credit analysis report.
Experience in Development and Customization of Form, Report and Application. Experience in Designing
Workflow Process. System Administration. Knowledge in cloning, Appling patch, Application up gradation and
Discoverer.

Professional Experience:
As Oracle financial functional consultant I have independently done two full life cycle implementations in GL,
AP, FA and CM modules, Three in AR module and one in PO module. I have also done two upgrade projects in
GL, AP, FA, CM and one each in AR and PO modules.
        In addition to the above I have involved in post implementation enhance in GL, AP, AR, PO modules
and rollout plan and setup documentation provided for GL, AP, AR modules implementation.

Toppan Photomasks, Round Rock, TX                                                             Jan 08 - Present
Sr. Financial Functional Consultant

Responsibilities:
My primary responsibility is implementation of General Ledger, Account Payables, and Cash Management
modules in multi organization environment. It includes requirement gathering, business process analyses, re-
engineering of Business process, designing, system configuration and testing which includes integrity testing on
R12 version.
     Designed Key Accounting Flex field structure for Ledger with Multi Org and Multi Currency setup.
       Defined system controls, inter company accounts, summary accounts, account aliases, 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 validation rules have
       been setup for various GL codes.
     Defined Access sets to enter transactions across the operating units.
     Configure setups for Consolidation, Multi reporting currency.
     Designed business process for matching options and configured the AP system to meet the requirement.
       Configured setups for multi currency invoices, Payment formats like Check, Wire and EFT payments.
       Defined with holding tax, Employee expense template in AP. Process has been designed for purchase
       returns in Oracle payables system. Configured the setup for Batch invoices and Batch payments.
     Configured Sub-ledger accounting and Tax setups to meet the requirement.
     Cash Management System have been configured and tested to meet the auto reconciliation of bank
       statement with payments, receipts and Journal entries.
     Documented the requirements and provided As Is and To Be process, GAP, BR – 100 and Functional
       specks for reports and conversions.
     CRP has been done and provided tests scripts for GL, AP and AR modules.

Environment: Oracle Apps R12 GL, AP, AR, PO, FA, CM, iExpense, HRMS, OTL, TOAD, ADI.

New York State Insurance Fund, Albany, NY                                                      Jul 07 – Dec 07
Sr. Financial Functional Consultant

Responsibilities:
My primer responsibility is requirement gathering, current system analysis, solution designing, documentation
and Implementation of Oracle Applications Fixed Assets module in 11.5.10.2 version. Provided production
support on GL, AP, AR, FA and PO modules.
    Conducted study on current system, requirements gathering, requirement analysis and documentation,
        new system capability functional training in Fixed Assets module.
    Current business process analysis has been done on assets accounting and asset inventory control and
        provided As-is and To-be process document.
    Functional and technical evaluations have been done in current inventory control system and define the
        need to change to Oracle fixed assets system.
    Requirements were gather form the users designed the process flow to meet the required functionality
        in the new Fixed Assets system. Design and develop application solutions to solve business functional
        requirements.
    Requirements mapping and Gap analysis have been done and identified process and reporting gaps and
        recommended solutions and documented RICE to fulfill the gaps.
    Reviewed the Current system data and data mapping have been done and conversion strategy has been
        designed to migrate the asset data from current system (Access Database) to Oracle Fixed Assets.
    A process flow was designed to create assets in Fixed Assets form Purchase Order and system setups
        have been done accordingly.
    Designed a process for Physical Inventory Stock Taking process through Bar Code Scanner.
    A process have been designed to print Bar Code Labels for fixed assets labeling for accuracy and time
       saving in asset identification and stock taking for audit purpose.
      Configured the setups in Fixed Assets for effective assent management and followed GAAP guidelines
       to depreciate deferent asset categories in corporate Book.
      Key Flex Field structures have been designed as per the requirement to track asset information and
       effective management.
      Configured setups in Inventory, Purchase and Account Payables modules to meet the required
       functionality.
      Performed QA, unit testing, system and module integration testing between Fixed Assets, GL, AP and
       PO to meet the required business process in respective modules.
      CRP and user acceptance test (UAT) was carried out for the Fixed Assets module. Trained the end
       users, resolved the issues during CRP and UAT.
      Data conversion and migration done through ADI from legacy system (Access Database) into Oracle.
      Trained the end users in Fixed Assets module and post-production support provided.
      Prepared the Test Scripts and provided to the user to test the various scenarios in Fixed Asset module in
       11.5.10.2 version.
      Performed the integrity and transaction flow between Purchase, Payables, Fixed Assets and General
       Ledger modules.
      Provided production support on GL, AP, AR, FA and Po modules and resolved period end closing and
       interface issues in production. Process design and training the user on enhancements have been done.
      Worked with super users, users and other functional consultants while requirement analysis, functional
       design, data validation and testing.
      AIM Functional deliverables like As-is, To-be process, future functional model in new system, GAP
       analyses, functional setup BR-100 and data conversion strategy documents, Project Plan, High level
       business process design have been provided.

Environment: Oracle Apps 11.5.10.2 GL, AP, AR, PO, FA, CM, iExpense, iProcurement, TOAD, ADI, Read
hat Linux.

Novatel Wireless, CA                                                                          Apr 07 – Jun 07
Sr. Financial Functional Consultant

Responsibilities:
My primer responsibility is implementation of Oracle Applications Fixed Assets module in 11.5.10 version.
    Conducted study on current system, requirements gathering, requirement analysis and documentation,
       configure the setups in Fixed Assets module.
    Setup heave been done in 11i (11.5.10) system to meet the desired business process and requirements.
    Configured the setups in Fixed Assets for effective assent management in corporate Books and also
       configured setup for tax books for deferent tax authorities.
    Key flexfield structures have been designed as per the requirement to track asset information and
       effective management.
    Configured setup for Multi Reporting Currency to report in CAD currency.
    Designed a process flow for assets purchase and to create assets in Fixed Assets and setups have been
       done accordingly.
    Process has been designed and configured setups in Inventory, Purchase and Account Payables modules
       to meet the required functionality for Purchase to Pay (P2P).
    Implemented Book level security.
    Asset data conversion and migration done from external (FAS) system into Oracle application through
       ADI.
    Data mapping have been done for conversion of asset data.
    Validated and reconciled the assets loaded in to Oracle and conformed the asset cost and depreciation
       reserve amounts to the third party data.
    Performed QA, unit testing, system and module integration testing between Fixed Assets, GL, AP and
       PO to meet the required business process in respective modules.
    Reviewed and conformed the functionality of Mass Additions, Transfer of Asset, Mass Transfer,
        Revaluation, Reclassification, Merge, Retirement and depreciation of assets in version 11.5.10.
       Performed the manual and automated functional test by running the test scripts for various scenarios in
        Purchase, Account Payables, Fixed Assets and General Ledger.
       CRP and user acceptance test (UAT) was carried out for the Fixed Assets module. Trained the end
        users, resolved the issues during CRP and UAT.
       Tested the data conversion and migration upload through ADI into Oracle through conversions from
        other systems.
       Worked with business analyst, super users and tax consultants while requirement analysis, testing and
        data validation.
       Trained the end users in Fixed Assets module and post-production support provided.
       Provided functional documents like requirement and GAP analyses document and data conversion &
        migration plan.
       Prepared the Test Scripts and provided to the user to test the various scenarios in Fixed Asset module in
        11.5.10 version.
       Prepared and provided Project Plan, High level business process design and Setup document (As per
        SOX).

Environment: Oracle Apps 11.5.10 GL, AP, AR, PO, INV, FA, CM, OM, HRMS, TOAD, ADI, Read hat
Linux.

Live Nation, TX                                                                               Jan 07 – Mar 07
Financial Functional Consultant

Responsibilities:
I have played led role in development of Financial and management reports through FSG in GL module
implementation.
     Analyzed the GL accounting structure and set of books used at deferent operating units and
       consolidation in Oracle and Lawson system.
     Extensively worked on FSG repot builder and created 300 reports to meet the requirement.
     Analyzed financial and management report system.
     Created Income statement and Balance Sheet for financial reporting purpose.
     Created Income statements and Balance Sheets to see the results at deferent levels of consolidation for
       management reporting purpose.
     Created several types of Variance analysis reports.
     Enable the security rules to protect the access of report data.
     Setups have been done for printing FSG report through XML publisher.

Environment: Oracle Apps 11.5.10 GL, AP, AR, PO, INV, FA, CM, HRMS, TOAD, ADI, Read hat Linux.

Equitrac Corporation, FL                                                                  Oct 06 – Jan 07
Financial Functional Consultant

Responsibilities:
Involved in Oracle application Implementation 11.5.10.2 and configuration the setups and tested the system in
financial modules GL, AP, AR, FA, P2P, Cash Management and iExpense.
     Conducted study on current system and the business requirements and configure the setups in GL, AP,
        AR, FA, Cash Management and iExpense modules.
     Setup heave been done in 11i system to meet the desired business process and requirements.
     New Chart of Accounting structure has been designed and configured the new setup in GL to meet the
        requirement. Segment mapping have been done for data migration between existing system (10.7) and
        the new system. Created the financial statements using FSG.
     Extensively worked on AR and configured setups for organization structure, Auto invoice, Auto
        lockbox, auto accounting, Consolidated Billing, Application of Receipts to transactions and invoice
        printing with remit to address. Statement cycle and Dunning letter are defined for effective monitoring
        of collections. Defined the VAT Tax codes and system setups have been done in Oracle 11i and
        integrated the Vertex tax system with Oracle system to upload the location base tax rates. Customer
        profiles have been created to customer credit management and system options are set to support the
        required functionality.
       Functional spec MD – 50 were provided for Customer and Open invoice migration and Vertex tax
        interfaces.
       Designed and configured setups to meet the requirement like multi currency invoices and cross
        currency payments, Batch invoices, Batch payments, Employee Expense report temple and EFT &
        manual check payments in Accounts Payables.
       Business process has been designed and system is configured to meet the Purchase to Pay process.
       Configured the setup in Fixed Assets for effective assent management and provide functional spec MD-
        50 for migration of assets data to the new system.
       System setup, testing has been done for Internet Expense module to meet the requirement.
       Functional (BR-100) document and test scripts are provided to the user and trained in major changes in
        version.
       Functional and System integrity testing have been done and issues were resolved.

Environment: Oracle Apps 11.5.10.2 (GL, AP, AR, OM, PO, INV, FA, CM, CRM Service Contracts), TOAD,
Read hat Linux.

Roll international, CA                                                                  Jul 06 – Sep 06
Functional Consultant

Responsibilities:
Primary responsibility is requirement analysis and high level designing and Oracle Applications implementation
rollout plan with GL, AP and AR modules for UK operating unit. Secondary responsibility is to design and
developed Financial Statement through FSG for US operating units.
     Oracle applications rollout plan have been prepared to implement GL, AP and AR modules for an
        operating unit.
     Requirement gathering and analyses was done for the new operations.
     Reviewed the current functionality and existing system setups, which designed to meet the current
        business functionality.
     Recommendations were made for inter-company transactions, currency conversions for multi currency
        activities.
     Design has been provide for Application configuration for GL, AP and AR modules.
     Developed and tested the financial statements as per requirement using Financial Statement Generator.

Environment: Oracle Apps 11.5.10 (GL, AP, AR, OM, PO, INV, FA, CM, OPM), PL/SQL, Forms & Reports
6i, Discoverer, Solaris 2.6.

Towers Perrin. PA                                                                           Apr 06 – Jun 06
Functional Consultant

Responsibilities:
Involved requirement analyses, documentation, application Configurations and system audit testing in
implementation of Oracle Applications Financial Account Receivables module for 27 operating units globally.
     Analysed the current system and developed design of business process and documented. Business
       requirement analysis has been done and BR100 document have been raised for application
       configuration.
     Involved in data conversion and migration from legacy to Oracle applications.
     Configure setups in Oracle Receivables to meet the business needs. Specifically defined Memo lines
       and reason codes, Tax codes for various countries, Internal Customers in addition to common setups in
       AR module.
     Coordinated with offshore teem to configure setups in application and System audit have carried out for
       all the operating unites in different responsibilities.
      Reviewed and updated the BR-100 document as per the business requirements.
      Prepared and provided MD-50 functional document towards custom report to extract data of Unpaid
       Advance billing credit, which are in use for advance collections, pertains to Project Invoices.
      Performed complete functional test and provided functional test scripts for different scenarios in AR.
      Created custom responsibilities set with the specific menus, functions and profile options to restrict the
       access of application security.

CompuCom Systems, Inc., TX                                                                Feb 06 – Apr 06
Functional Consultant

Responsibilities:
Implemented Oracle Financial Account Receivables module for the Operating Units at USA and Canada
    Setup the system to meet the desired business process and requirements based on knowledge about the
      Oracle Financials applications functionality and oracle Application Implementation methodologies.
    Functional design and design review of Oracle Applications data conversions, interfaces, custom
      reporting, and custom applications.
    Customised application according to Account Receivables Business process.
    Designed organization structure, transaction flex field structure (descriptive flex field) and remit to
      territories & locations. Defined transaction types & sources, quick codes, defined grouping and Line
      ordering rules for Auto invoice, Auto accounting rules, Receipt classes and Source, customer profiles,
      Payment terms, Internal Banks, lockbox, Transmission Formats. Set the system options and defined Tax
      Codes, and set the Profile Options.
    Involved in developing Customer and invoice conversion, auto Lockbox and Credit Card programs.
    Worked on data conversion in AR, which includes mapping the data from legacy system to Oracle
      using the Loader and interface programs. Inborn and Outborn interface like Customer Master
      Conversion and Conversion of Open AR Invoices program to load data in to oracle.
    Tested the functionality of auto invoicing, Auto lockbox and Credit Card processing.
    Scheduled the loader, interface programs for customer, auto invoice, and lockbox process through
      Standard Request Submission.
    Prepared and provided the functional specks like BR – 100, MD - 50, MD – 70 and TE – 40.
    Post go-live production support was provided to resolve the issues.
    Created responsibilities with required functions to restrict system access to the users for security.

Environment: Oracle Apps 11.5.4 (GL, AP, AR, PO, FA and CM), PL/SQL, Forms & Reports 6i, Solaris 2.6.

Getty Images, WA                                                                               Oct 05 – Feb 06
Functional Consultant

Responsibilities:
Involved in Upgrade of 11.5.7 to 11.5.10 and testing of Oracle Financial 11i GL, AP, FA, GIS, and Cash
Management modules.
     Conducted study on current business process designed future state functional requirements in GL, AP,
       FA, GIS and Cash Management and mapped them to oracle functionality while Upgrade.
     Ensured the customizations while upgrade process from 11.5.7 to 11.5.10 in the above modules in
       11.5.10. Performed the testing of custom interface program like GL Daily rate, Open Invoices
       conversion and loader programs in AP. to load data in to Oracle through conversions from other
       systems.
     Conformed setups for Global Inter Company transactions.
     Designed custom Check Print format for payments and Withholding tax certificate report for suppliers.
     Performed QA, unit testing and system integration testing of GL, AP, AR, FA, PO and Cash
       Management using the test scripts in respective modules in version 11.5.10.
     Performed the functionality test by running the test scripts for various scenarios in General Ledger,
       Account Payables, Fixed Assets, Cash Management and Global Intercompany System in version
       11.5.10.
      System test have been done to meet the desired business process of Account Payables functionality like
       Creating batch invoices, batch payments and carried out the EFT process.
      CRP and user acceptance test (UAT) was carried out for the above modules. Trained the end users in
       major changes in version 11.5.10 and post-upgrade and resolve the issue during UAT. Production
       support provided.
      Provided functional spec on new requirements (MD- 50) Test Scripts document to test the various
       scenarios in GL, AP, FA, CM, and GIS modules in 11.5.10 version.

Environment: Oracle Apps 11.5.10 (GL, AP, AR, OM, PO, INV, FA, CM, iProcurement), PL/SQL, Forms &
Reports 6i, Discoverer, Solaris 2.6.

S1 Corporation, Atlanta, GA                                                            Apr05 – Sep 05
Functional Consultant

Responsibilities:
Involved in implementation and testing of Oracle Applications Financial 11i General Ledger and Accounts
Payables module with Multi Org setup.
     Involved in Functional analysis of existing systems and GAP analysis for implementation of 11i.
       Discussions with the end users regarding the requirement, limitations of existing system and proposed
       solution.
     Designed Key Accounting Flex field structure, Chart of Accounts with Multi Org and Multi Currency
       setup. Defined rollup groups, security rules, journal sources, journal categories and budgets. Defined
       system controls, inter company accounts, summary accounts, account aliases, encumbrance types.
       Defined currency translation, conversion, revaluation and Set the profile options for GL.
     Configure setups for Consolidation, Multi reporting currency and FSG reports.
     Defined Cross validation rule according to their requirement.
     Created and executed Profit & Loss, Balance sheet through FSG reports considering the oracle GL
       functionality. Tested the functionality by using various tests scripts.
     Carried out the Global consolidation.
     Defined currency conversions, currency translation and reevaluations in GL.
     Configured the setup for multi currency invoices and payments in AP.
     Configured the setup for raising Batch invoices and Batch payments.
     Prepared BR – 100 for configuring the Oracle Applications according to the business requirement.
     Provided functional spec MD-50 on custom programs and Test scripts for various scenarios in GL and
       AP.

Environment: Oracle Apps 11.5.10 (GL, AP, AR, OM, PO, INV, FA), PL/SQL, Reports 6i, Linux.

City of Memphis, TN                                                                          Jul 04 – Dec 04
Functional Consultant

Responsibilities:
    Involved in post implementation functionality enhancement s in Oracle Application 11i GL, AP, PO
      and FA
    modules.
    Conducted study on current business processes, analyzed future state requirement and mapped them to
      Oracle functionality.
    Studied current merchandise system and replaced current process in Oracle Purchasing and Account
      Payables.
    Functional process designed for invoice matching solution, requisition and Purchase order approval
      process.
    Performed setups to meet the requirements in AP, GL, PO, FA and INV modules for functionality
      enhancement.
    Configured the setup for raising Batch invoices, Batch payments, multi currency invoice, cross
       currency payments and auto withholding tax on supplier invoice. New expense reports were defined.
      Configured work flows for Purchase Order and Journal Batch approval.
      New Business process has been designed and configured setups for prepayments and adjustment to
       payment to suppliers and employees.
      Developed test plans and scripts and conducted testing for quality assurance.
      Prepared and provided the functional specks like MD - 50, MD – 70 and TE – 40.
      Identified process and reporting gaps and recommended solutions. Involved in Development and
       customization of several reports as per client specifications.

Environment: Oracle Apps 11.5.9 (GL, AP, AR, OM, PO, INV, FA), PL/SQL, Reports 6i, Solaris 2.8

Perkin- Elmer Life Sciences, MA                                                         Jul 03 - Apr 04
Functional Apps Consultant

Responsibilities:
My primary responsibility is implementation of Oracle financial PO, AP and CM module which includes
requirement gathering, analysis and designing the proposed business process, configure the setups in Oracle
applications and testing the system.
     Involved in Functional analysis, understood limitations and proposed solution for implementation of
        Oracle Applications 11i PO and AP modules.
     Designed and defined inventory key flex field structure for Purchase module and configured setups in
        Inventory module to meet the requirements in Purchase module.
     Designed the Purchases Order process and configured the setups in Oracle Purchases to meet the
        business process and PO approval work flow process.
     Designed the business process in Accounts Payables and Configured setup in application for invoice
        matching, Recurring Invoices, Employee Expense report template, withholding tax on suppliers invoice
        and Payment process.
     Configured the setup for Reconciliation and Cash Forecast in Cash Management.
     Involved in development of year end financial statements through FSG reports.
     Performed unit testing, system integration testing and user acceptance testing of AP, PO and CM
        modules and supported developers in debugging process and data conversion and migration.
     Functional specks like BR – 20, BR – 100, MD - 50, MD – 70 and TE – 40 have been provided.

Environment: Oracle Apps 11.5.8 (AP, AR, OM, Advance Pricing and shipping, PO, INV), PL/SQL, Forms &
Reports 6i, Discoverer, Solaris 2.6

Pride Mobility Products, PA                                                           Nov 02 – May 03
Functional Consultant

Responsibilities:
My primary responsibility includes the Implementation of Oracle Financial PO, AP and FA modules.
    Carried out the business analysis, requirement gathering and analysis and designing business process,
       System configuration and testing.
    My Responsibility included implementing AP, FA, PO and INV Modules. Functional support to
       developers for data conversion: Customer Conversion, and Item Import.
    Designed and defined inventory key flex field structure and configured setups in Inventory module to
       meet the requirements in Purchase Module.
    Configure setups to meet the requirement in business process in Purchase module which includes
       purchase order approve process and approval limits, open PO data conversion.
    Configure the setups to meet the business flow in Account Payables like Asset Batch invoices
       processing and expense invoice processing with matching options, Employee expense report and
       recurring invoice processing and Batch Payments process.
    Designed Assets key flexfield structure as per requirement configured setups in Oracle Assets to meet
       the requirement for effective management for organization assets at corporate Books and tax books.
       Assets are categorized using deferent depreciation methods. Data conversion and migration have been
        done bring the assets from legacy to Oracle applications.
       Configured Standard Request Submission and scheduled the execution of standard API’s and Reports in
        AP, FA.
       Functional documentation like BR – 20, BR – 100, MD - 50, MD – 70 and TE – 40 has been raised.
       Performed QA, unit testing, system integration and user acceptance testing. Worked with technical
        team and business users. Training the end users and resolve the issues during UAT.

Environment: Oracle Apps 11i (11.5.4 AR, AP, FA, PO, OM, INV, EDI) Data Load, PL/SQL, Sun Solaris 2.8

PR NEWSWIRE, NJ                                                                 Mar 02 – Oct 02
APPS Functional Consultant

Responsibilities:
    Involved in Functional analysis of existing systems and databases and GAP analysis for implementation
      of 11i. Discussions with the client/users regarding the user’s requirement, limitations of existing
      database and proposed solution.
    Configured GL Key Accounting Flex field structure, Chart of Accounts, calendar, currencies. Defined
      cross validation rules, security rules, budgets. Defined inter company accounts, account aliases. Defined
      currency translation, conversion, revaluation and Set the system profile options.
    Configure setups for Consolidation, Multi reporting currency and FSG reports.
    Designed organization structure consisting territory & location flex field structure. Defined transaction
      structure of transaction sources, quick codes, transaction types, receivable activities and classes,
      customers, customer profiles, Banks, lock box etc for AR.
    Define the system parameters such as banks, cash clearing, bank charges, and bank errors in AP.
    Defined system parameters, such as remittance and cash accounts for each bank and miscellaneous
      transactions in AR for Cash management.

Environment: Oracle Apps 11i (AP, AR, GL, FA, PO, CM), PL/SQL, Forms 6i, Reports 6i, Toad, Sun Solaris

Apogee Networks, Inc., NJ                                                                      Jul 01 - Apr 02
APPS Functional Consultant

Responsibilities:
Involved in configuring the setups in Oracle applications GL, AP and AR modules as per BR-100 Doc
     Configured setups in Oracle GL, AP and AR modules as per BR-100 document. Setup audit has been
       done.
     Tested the functionality according business flow and system integrity test carried out for GL, AP and
       AR modules.

Environment: Oracle Apps 11i Ver11.5.3 (AP, AR, GL with MRC & Multi-Org), Toad, Sun Solaris 2.8

Milkoma Foods (P) Ltd., India                                                                 Jan 96 – Jun 01
Financial Consultant

Responsibilities:
    Implemented Financial Accounting packages ex next gen.
    Involved in System Analysis, designing of database, Reports, implementation and testing of custom
      software in Procurement and Sales.
    Involved in system and accounting structure design including re-engineering of business process
      according to business needs.
    Involved in product pricing analyses preparation and filing of sale tax returns.
    Involved in financial planning and management.
    Developed finance proposals for projects and working capital proposals.
    Responsibilities include project appraisal, sanction and release of funds from commercial banks and
      State authorities and availing the investment, sales tax incentives from various Govt. bodies.
       Involved in preparation of annual budgets.

Ventch Retrading, India                                                                  Oct 94 - Dec 95
Executive (Accountant)
Involved in financial planning and management. Involved in System Analysis, designing of data based Tables,
Reports, testing and implementation of software for sales. Approved various expenses of branch on basis of
company policies and effectively maintained the accounts and records. Involved in year-end reconciliation and
preparing financial statements and getting it audited.

Vijai Electricals Ltd., India                                                                     Aug 87 - Sep 94
Executive (Sales)
My career started as Management Trainee and I have been appointed as Junior Executive With a fairly wide
range of responsibilities like floating tenders, analyzing market competitors of there price and activities,
organizing QC checks for customers, deliveries scheduling, raising invoice against supplies and follow-up of
payments from customers. Designed few reports like Order execution status report, Periodical Payment dues
statements, withholding guaranties amounts report for MIS. Involved in day-to-day operations, annual
budgeting, planning and controlling of expenditure incurred at after sales service division as an incharge.
Designed deferent types of failure analyses reports for MIS to insure the quality at various levels of process

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:186
posted:7/25/2011
language:English
pages:10