Finance Consultant Resume
AtlantA
SUMMARY:
- Over 11 years of experience with 8+ years of SAP R/3 experience including Seven Full Life Cycle Implementation experience. Three years of experience in Financial Accounting and Cost Accounting systems
- Extensive experience in configuration and implementation of Financial Accounting (FI), Controlling (CO) and Asset Accounting (AA),Treasury modules of SAP R/3 and integration with MM, SD, PP.
- Involvement in Business Process Re-engineering.
SAP Modules Experience from all clients:
New General Migration
- Very strong skills in New General ledger Migration using migration cockpit tool for the Perkin Elmer & Equate petrochemicals Co for a multi currency, multi company environment. Designed ,configured prototype the document splitting , parallel valuation segment reporting . Configured and designed integration with profit center accounting.
Profitability analysis
- Very strong skills in profitability analysis. Implemented for the Gujarat Glass private limited, (GGPL),Equate petrochemicals Co in a multi currency, multi company environment. Designed and configured to meet budgeting needs. Configured and designed integration with sales and profit center accounting. Developed various drill-down reports to meet customer needs.
Cost center accounting and internal orders
- Very strong skills in cost center accounting and internal orders. Implemented for the Gujarat Glass private limited, Equate petrochemicals & Parenteral Drugs India limited Worked with end-user in designing standard hierarchy and master data such as cost centers, activity types, cost elements, allocation cycles and order types. Designed and configured to meet budgeting needs. Configured Excel interface for budget data upload using standard SAP. Developed various report painter reports to meet customer needs. Provided end-user training on using information system reports. Designed and configured integration of internal orders with asset accounting and investment management.
General ledger including chart of accounts and taxation
- Very Strong skills in designing and configuring general ledger module of SAP. For most of the clients implemented company codes, finalized chart of accounts and other related configuration such as SD, MM account determination procedure, document types, number ranges, etc. Conducted various end-user training in this area. Configured taxation procedures including tax codes, tax reports. Designed new interfaces and reports. Provided support to most of the clients for their various needs such as GR/IR clearing, information system, month-end close and reconciliation with profit center accounting, profitability analysis, consolidation etc.
Accounts receivables and Accounts payables
- Very Strong skills in configuration and application of AR and AP. Experienced in creation of Account groups, Payment methods, Automatic check payment, Lock Box, Credit Card payment, Check printing, and integration with materials and sales for invoice verifications. Implemented for most of the clients. Also designed logistics invoice verification (MM) and Billing and Pricing (SD). Provided after go-live support to various clients. Trained end users in various A/R, A/P areas
Asset management, investment management and Project System
- Very Strong skills in designing and configuring assets management module of SAP. Implemented for clients Gujarat Glass private limited, Equate petrochemicals,Parenteral Drugs India limited & Proctor & Gamble. Also implemented interface with investment management with Project System and Internal orders. Worked on Project Structuring, Date scheduling, Status Tracking, Budgeting, Project cost tracking and Project monitoring. Experienced in creation of depreciation areas, chart of depreciation, asset classes, other related configuration and use information system. Strong Skill in configuration of bonus depreciation, mid quarter convention, mass inter company transfers using workflow
Banking, cash management in treasury module
- Very Strong skills in designing and configuring treasury module of SAP. Implemented cash management (liquidity and cash forecast) and treasury modules for client Space Net and their business partner. Experienced in creation of house banks, electronic bank statements, bank reconciliation, check register etc for various clients. Worked extensively on DME, ACH formats with bank for clients like Equate Petrochemical & Procter & Gamble etc.,
Treasury, Electronic Bank Statement and Corporate Finance Management
- Worked extensively on prototype, design, configuration, testing and support on EBS importing both current day and prior day file for US and Canada. Daily cash position and wire payments, ZBA and cash concentration.
- Worked on Prototype, design, configuration, testing of Interest rate instruments like Bank Note
- Borrowing, Credit Facility for Revolving loan Drawdown, Inter-company borrowing/investment Money Market Fund Investment and foreign exchange deals.
My SAP ERP 2005 (SAP ECC 6.0)
- Configuration and Implementation of the New GL Migration and online document splitting functionality using SAP delivered method, defining segment field, defining variants for real time integration with CO, Allocations within the G/L.
SKILLS:
- SAP : SAP R/3 4.6C/ 4.7 (, Treasury, FI, CO, AA, CO-CCA, AM, PS,MM-FI/CO, SD-FI/CO, FI-AM, FI-CA-Contract, FM, CCS, IS-U, MM-AM, AR, AP, GL, Asset Mgmt, Cost Center Accounting, Internal Order, Treasury,Corporate Finance Management, ASAP, Report Painter, Report Writer, LSMW, SCAT, ABAP Query, SAP R/2 (RF, RK)
EDUCATION:
- Master of Business Administration from Osmania University of Hyderabad, India
- SAP Training in: Special Purpose Ledger (AC220-Level 3), Profitability Analysis (AC605-Level 3 Release 4.0B),Funds Mgmt (Level 3) and Treasury (Level 3)
- Certified consultant in My SAP ERP In FICO
EXPERIENCE:
Confidential,Atlanta July 09 Till date
Project: SAP Finance/Procure to pay/SRM
SAP Release: ECC 6.0 & SRM 5.0
Role: Finance Consultant
Modules: SAP FICO & SRM
Responsibilities:
- Understand business process and finalize design in SAP as per agreement with business.
- Preparation of Business blue print documents
- Integration of Open text & kofax with SAP environment
- Make configuration setup and functional design document for technical development in SAP.
- Experience on buyer supplier information exchange ( vendor portal)
- Perform unit test and help test team in creation and finalization of test script for integration testing and resolve their issues and queries while actual test, Help training team in finalization of training material for presentation to business users.
- Conducting workshops with business representatives for changes in critical business processes.
- Contributing towards user acceptance testing with business users for test of business scenario before go live and handle queries from business for business process to be carried out in SAP.
- Supporting data migration and cutover tasks for go live.
- Providing support after go live for in the stabilization phase of project and -Knowledge transition to production support team
- co-ordination & working with sale team for presales activities
Confidential,Waltham Nov2008 -June’09
Project: SAP Cash Management/Electronic Bank Statement , In-house Cash Management
SAP Release: ECC 6.0
Role: Cash Management Consultant
Modules: FI-Bank Accounting, Cash Management, New General Ledger Migration
Responsibilities:
- Designed ,configuration and prototype the document splitting , parallel valuation & segment reporting Configured and designed integration with profit center accounting.
- Worked on requirement gathering, Prototype, Configuration on Electronic bank statement and Cash Management.
- Prototype and workshop for Accounting and treasury team to explain the need to restructuring GL accounts and bank account for implementation of EBS and Cash Management.
Confidential,Kuwait March 2008 Nov ‘2008
Project: SAP Treasury/ Corporate Finance Management implementation
SAP Release: 4.6C CFM Add-on
Role: Senior Treasury/CFM Consultant
Modules: New general ledger Migration, FI-Bank Accounting, Treasury, Corporate Finance Management
Responsibilities:
- Designed ,configuration and prototype the document splitting , parallel valuation & segment reporting Configured and designed integration with profit center accounting.
- Worked on requirement gathering, Prototype, Configuration, unit/integration test, training User on
- Electronic bank statement, Payment Management, Cash Management and Transaction
- Management like Bank note-borrowing, Credit Facility, Credit Facility Drawdown, Intercompany
- Loan, Foreign Exchange transaction (Spot and Forward) and Money Market Fund (Investment).
- EBS importing current day and prior day file from Chase/RBC for US and CA and Posting memo records from current day file for Cash position. Check encashment date and bank reconciliation using prior day file.
- Configured, tested and implemented global definition like creating posting rule for Chase/RBC BAI.
- Cash Management- Grouping and Structure definition for daily Cash Position, wire transfers, ZBA and cash concentration.
- Payment Management- Payment request and Payment handling for Outgoing/Incoming wire payments, Money Market- borrowing/investment Incoming/Outgoing transactions.
- Transaction Management- Bank note borrowing for Lien 1& 2, Facility for Revolving loan, Inter-
- Company borrowing/Investment for Inter-company loan and Foreign Exchange for Spot/Forward Trading. Definition of Product types, transaction types, flow types, condition types for setting up Interest rate instrument. Account determination for Treasury and accrual/deferral Posting.
- Configuration and testing of workflow for Interest rate instrument (Deals) release and Business Partner release.
Confidential,India Aug 2007 Feb 2008
Project: SAP Implementation
SAP Release: ECC 6.0
Role: FI/CO Consultant
Modules: FI-AR, AP, AA, PA and Order and Investment Management.
Responsibilities:
- Responsible for configuration and implementation of SAP implementation to their group companies.
- Responsible for Design, Configuration and implementation of FI modules, Asset Accounting, Cost center accounting and Internal order.
- Responsible for Design, Configuration and Implementation of Profit center accounting and profitability analysis for one of their sister company. Responsible for Data load, Material ledger, Transfer pricing configuration in profit center accounting.
- Configured and Activated Material Ledger to implement Profit center transfer pricing functionality.
- Worked on blue printing and implementation of ECC 6.0 Upgrade and New GL migration project and implemented online document splitting functionality using SAP delivered method, defining segment field, defining variants for real time integration with CO, Allocations within the G/L.
- Configured and implemented - assigning the methods to the ledger and define the splitting fields, Assign GL accounts to item categories, Assign document types to splitting rules and configure account determination.
- Responsible for Design, Configuration and Implementation of Profitability Analysis and worked on identifying character, value fields and derivation rule, developing report using report painter in profitability analysis.
- Involved in Master Data conversion for cost center, profit center, internal order and loading G/L account, AR, AP and asset accounting data using LSMW.
- Responsible for configuration and integration of Credit Management functionality, AP payment program, financial statement versions, capitalization of assets by settlement from orders and depreciation postings
- Responsible for configuration and testing of MM and SD automatic account determinations includes scenarios like rebates , sample etc.,
Confidential,New castle ,UK Oct 2005 Aug 2007
Project: SAP Rollout project for Europe company
SAP Release: ECC 6.0
Role: FI/CO Analyst
Modules: FI, Cost Center, Internal order, Treasury & risk Management
Responsibilities:
- Responsible for analysis, design, configuration and testing of FI/CO modules for their canadian company
- Responsible for canadian tax configuration, setting up profit center hierarchy, income statement for profit center, configuring master record for Cost center accounting and internal order modules
- Worked extensively on configuring costing based profitablity analysis
- Created reports in Profitability Anaysis using report painter and CO reports using report writer.
- Trained profitability users in report painter and writer for a week.
Confidential, India Aug2003 Aug 2005
Project: Production Support & enhancement of SD, Pricing, Billing, GL, AR, AP
SAP Release: 4.6C & 4.7E
Role: FI/CO Analyst
Modules: FI, GL, AR, AP, SD Billing
Responsibilities:
- Providing Production support and enhancement for SD Pricing and Billing, GL, AR, AP
- Worked on condition records, condition tables and pricing procedure to fix pricing issues
- Worked with developers on program modifications on the above areas
- Worked on enhancement Issues such as configuring SAP Auto Clearing Program by modifying SD maintain copying control for billing documents and Created new line layouts
- Responsible for configuration changes and tested on Billing types and Copying control on billing documents
Confidential,India Sep 2002 Aug 2003
Project: Implementation of FI (GL, AR, AP and Profitability Analysis)
SAP Release: 4.7E
Role: FI/CO Analyst
Modules: FI, GL, AR, AP and Profitability Analysis
Responsibilities:
- Design, configuration and implementation of GL, AR, AP and Profitability analysis
- Design, configuration, testing of FI modules AR, in areas such as Lockbox, Dunning, Correspondence, Auto-Payment, Deduction Management Component, Invoice Processing and Credit Card processing (Documented the working) on SAP R/3 Release 4.0B using ASAP (Accelerated SAP) as the implementation methodology
- Responsible for identifying character, value fields and reporting for Profitability.
- Configuration and testing Credit risk categories, credit groups, credit representative and credit monitoring
- Worked on knowledge transfer on AR configurations, AR Reports, credit management, and billing
- Helped Oracle Data Warehousing team engaged in extracting data from SAP AR and SD table for reporting, by providing details of SD and AR tables and fields to be read and logic to be followed
- Responsible for FI-AR, PCA Business blue print, realization, cycle testing and implementation. Worked on Business Process Blue Printing by using business process questions and business process transactions based on discussions with each team on areas such as requirements/expectations, Business Model description of SAP functional deficits and approaches to covering functional deficits
- Working on CO-PCA Master data conversion and set up such as standard hierarchy, revenue account assignment and derivation
- Worked with SD team on Customer master mapping
- Worked on workflow for approval for customer request for payment
Functional experience:
Confidential,India Feb2002 Sep2002
Role: Finance executive
Responsibilities:
- Preparation and Finalization of Financial Statements with Tally accounting software package.
- Preparation of Cash Flow and Fund Flow statements.
- Preparation of working capital proposals.
- Dealing with Company Law and Taxation matters.
- Co-ordination with Auditors for finalization of internal, Statutory and Tax Audits.
- Liaison with Banks and Financial Institutions for day matters.
- Preparation and submission of Progress Reports to Financial Institutions and Banks.
- Preparation and submission of various monthly reports like Book debt statements and Stock statements to Banks.
Confidential,India May 1999- Dec 2000
Role: Audit executive
Responsibilities:
- Preparation of financial statements for various clients.
- Preparations of all necessary statements like Profitability, Sources and application of funds, Debt Service coverage Ratios etc. For term loans appraisal for clients.
- Involved in Internal Audits, statutory Audits and Bank Audits for various clients.
- Applied consolidation, deferred tax and other accounting standards in preparation and finalization of accounts.