Sap Fi Consultant Resume
TX
PROFESSIONAL SUMMARY:
- Extensive experience working as an SAP FI consultant.
- Expertise and strong analytical skills in SAP R/3 Environment (SAP-FI).
- 10 years of professional and 9 years of SAP functional experience in implementation, customization, development, integration, and testing of SAP R/3 Finance and controlling modules.
- Implemented Full life cycle of FI projects in General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Asset Accounting (AA), and also integration with CO, MM, and SD.
- Hands-on experience in Implementation of major functionalities within:
- General Ledger: Configuring Account groups, GL master records, Posting Period Variants, field status variants, sample accounts, field status groups, posting keys, Financial Statement Versions, Automatic account determination, sales/use tax assignment, and document number ranges, document types, tolerance groups, recurring entries, Account assignment model and closing procedure.
- Strong knowledge in SAP New GL (Code Blocks, Document Splitting, Parallel Leger)
- Accounts Payable: Configuring and customizing vendor groups, vendor master data, house banks, Bank accounts, check lots, reason codes, Automatic payment Program, Payment using electronic payment advice and clearing of open items at the vendor, recurring entries, invoices, credit memos, integration with MM.
- Accounts Receivable: Configuring and customizing customer groups, customer master data, payment terms and interest calculation program, dunning, credit management, credit card payment using Xi Pay Adapters and integration with SD.
- Treasury: Lockbox configuration setting up house banks, defining lockbox accounts at House banks, Lockbox Posting data, testing the lockbox functionality, treasury groupings, electronic bank statement processing and Cash management (Liquidity Forecast, Cash Concentration, and In-house Cash).
- Fixed Assets including chart of depreciation, asset classes, depreciation areas, depreciation keys, account assignment in cost accounting, number ranges, creating reconciliation accounts for assets
- In-Depth knowledge of GAAP and exposure to IFRS with experience in applying SAP ERP solutions to ensure optimal integration and efficient information availability with strong accounting and Finance knowledge.
- Expertise in applying Project Planning (CaliberRM) including Analysis, Design, Configuration, UAT, SIT, End User Training, Go-Live and Post Go-Live warranty periods.
- Developed and executed data conversion and integration test plans through integration test-scripts and unit testing with testing tools like Mercury Test director & Quality center, End user training and documentation.
- Efficient in analyzing the Business Requirements, needs, Objectives and Mapping them through SAP XI, Custom Unix based mappers, and custom tables as per SAP processes, solutions and products that are being implemented.
- Extensive experience in SAP standard reports, Report painter, migrating/consolidating SAP custom reports from 4.5 to 6.0(AFM Compliant) by mapping source fields to target fields.
- Extensive experience in Win shuttle (Trans/Run), TIDAL Job scheduler, SAP Batch job monitoring (SM36/37), ticket tracking (HP Quality Center, Mercury Test director) and SAP Transport Management (SE09). Proficiency in writing Functional specifications, Technical Specifications, test cases for SIT and Mapping specifications for Interfaces.
- Expertise in Order to Cash (OTC) and Procurement to Pay process (P2P), Automatic Payment Program, Lockbox, LSMW, and IDOCS (Inbound/Outbound).
- Strong planner and organizer with demonstrated ability to master new concepts quickly, incorporate the latest technology, and develop business solutions that increase efficiency, productivity and profitability.
- Excellent communication, presentation, and interpersonal skills.
EDUCATION:
BS: Business Finance
PROFESSIONAL EXPERIENCE:
Client : Confidential, TX (Jan 2010 - Present)
Role : SAP AP/AR Analyst
Environment : SAP R/3 4.5 to SAP ECC 6.0 (Migration)
SAP related Tools : Win shuttle, TIDAL Scheduler, SAP XI, HP Quality Center, CaliberRM
Microsoft Tools : MS Office Suits, Outlook, Communicator, One Note, SharePoint
- Configured Account Receivable (AR), (AP) accounts payable and General Ledger (GL)
- Migrated Vendor master data and customer master data from another system using IDOC types CREMAS and DEBMAS.
- Designed Mapping specifications for several Non SAP interfaces sending invoices (INVOIC01/INVOIC02), Purchase orders (PORDCH02/PORDCR10), Financial documents (ACC_DOC03) in a different formats like SIF, CIF, Invoice voucher etc.
- Configured partner profiles and worked on custom program designed for IDOCs error handling.
- Worked on custom program designed for IDOCs error handling.
- Configured MM - Porgs, Plants, Storage locations, Plants linked to Porgs, Porgs linked to Company codes, Tolerance limits for Price variance, Tolerance limit for invoicing. Invoice verification item amount check, Tax default on invoice verification.
- Configured AFM Compliant Doc Type (Direct bookings and Interfaces) replacing Doc types from 4.5 to 6.0, Number ranges, Reversal Doc types, Recurring invoices, Down payments (GL Indicator A), and Validation/Substitution/User exits.
- Performed UAT for Doc types used for direct bookings, MM related configurations, Validation/Substitutions, POs, Good Receipt, Invoices and Credit Memos using ME21, ME25, MIGO, FB60 etc. Invoice verifications using MIRO.
- Designed Test cases and completed SIT by testing Inbound IDOCS (INVOIC01, INVOIC02, PORDCH02, PORDCR10, DEBMAS, CREMAS) by usingWE05, WE19, WE20, BD87.
- Configured Customer (AR) account groups, terms of payment, tolerance limits for customer payments, special GL indicators, dunning procedure, and down payments.
- Worked on AP/AR Standard and ABAP reports. Helped design the field mappings between reports from 4.5 environments to 6.0 environments.
- Worked on different QC (Project) tickets, IM (Production) tickets related to sub ledger Configurations and for interfaces by interacting with the business users to fully understand the issue to provide deliverables.
- Worked in Intense War-rooms during Post Go-live warranty periods.
Client : Confidential, OR (Nov 2008 - Dec 2009)
Role : SAP FI Consultant
Environment : SAP ECC 6.0
- Lead team member in successfully carrying out the realization phase of FI. Created presentations on current and future state of the project implementation and outcomes.
- Interacted with client for requirements gathering and analysis. Reviewed and Updated the functional design documents for FI developments
- Involved in developing detailed functional specifications and configuration documents
- Configured organization structure for company code, field status variant, fiscal variants, posting periods, document number ranges
- Configured Created GL accounts, Defined posting keys, maintained field status variants and assigned to company code, screen variants for document entry as per business specifications and tested the configuration in various scenarios with test cases.
- Configured the settings in GL area, such as creating G/L master data, open item clearing.
- Setting up of down payment methods, payment files and advices through change in SAP scripts.
- Configuration and creation of house banks, bank accounts and assignment of these accounts to a check lot.
- Involved in their Order to cash and Procure to pay cycle requirement gathering. Understand their OTC and P2P cycle and according to clients requirement configured OTC and P2P cycle for their system.
- Configured automatic payment program for out-going payments in A/P.
- Configured Account Receivable and A/R master Data.
- Configured Special Purpose Ledger (FI-SPL) for External and Internal Reporting Purpose.
- Configured payment terms, over-due interest calculations, cash discounts and automatic clearing of line items.
- Configured Customer (AR) account groups, terms of payment, tolerance limits for customer payments, special GL indicators, dunning, and down payments.
- Configuration for the creation of A/R invoices and posting of manual incoming payments with differences.
- Developed documentation for customizing automatic payment program (changes in segments according to the bank requirements, SAP - bank payment related interfaces).
Client :Confidential, CA (May 2007 - Sep 2008)
Industry : Semiconductor
Role :SAP FI Consultant
- Conducted GAP analysis, documented the findings, assessed scope of studies & suggested solutions through SAP for implementation and customizations.
- Performed Baseline Configurations for FI-GL, AP, AR, and MM modules.
- In FI-AP/MM, configured the Automatic Payment Program, Recurring payments, House Bank, MM related enterprise structure (Plant, Purchasing Organization).
- In FI-GL, configured the Cross Company and Inter-company setups, Foreign Currency Valuation Design (Re-measurement and Revaluation), GL Master Data upload.
- Creation of New G/L Accounts, Chart of Accounts, Fiscal year variants and Posting Period, etc
- Configuration of Cost & Sales Accounting, Parallel Valuation Methods, G/L Account Master Records, Account Balances, Posting Business Transactions in General Ledger and Line Items
- Document Splitting: Item category, Business transaction variant, Account determination, Constants, Splitting rule.
- Configuredparallel ledgers andaccounting principles.
- Assigning of New G/L Accounts to Financial Statement Versions
- Defined templates for configuring recurring entries in GL postings. Configured payment program for third party remittance allowing the check printing and direct deposit programs, RFFOUS_C and RFFOUS_T to generate payments automatically.
- Set up integration between financial and material management through automatic account assignment.
- Functional specifications for account receivable and account payable open items and general ledger balances for data conversion.
- Functional specification and testing for various forms like dealer statement, manual invoice, T4A, and 1099 invoice list.
- Integrated account payable and account receivable modules with material management and sales and distribution respectively with respect to account determination for various clearing and adjustment accounts and automatic postings.
- Assist in business process review for accounts payable, accounts receivable and general ledger.
Client :Confidential, CA (Feb 2006 - Mar 2007)
Industry : Banking/Finance
Role :SAP FI Consultant
- Understood the clients business as a whole, anticipated its needs and clarify it.
- Responsible for FICO module. Team lead for Accounts Receivable (AR), Accounts Payable (AP), GL accounting Asset Accounting (AA).
- Responsible for customization of the organization structure, client interaction, user training, process and transaction testing.
- Analysis of customer requirements in preparing the master data for GL accounts, asset masters, Cost centers, Customer masters etc.
- Cross company code transaction process set up.
- Configuring the Automatic Payment Program in Accounts Payable.
- Accounts Receivable: Configuration for customer incoming payments full, partial, & residual payments.
- Dunning, clearing, statistical postings, down payments.
- General Ledger accounting: GL postings, and foreign currency valuation.
- Bank Accounting Master data for house banks, Bank statement, reason codes, check printing, interest calculation.
- Asset Accounting: Configuration & customizing Chart of Depreciation and its Assignment to Company Code.
- Involved in the Legacy data asset transfer, which is taken into the system using batch data processing.
- Created Asset Master Data, asset classes, and depreciation areas/keys.
- Handled assets acquisition/retirement of assets & postings.
Client : Confidential, CA (July 2003 - Dec 2005)
Industry : Insurance
Role : SAP FICO Consultant
- Team member in creating in-process design, mapping and business process re-engineering to match the client requirements with SAP. Understand Business Process, Creating GL, AP, AR and other FI Masters. Also test of master data, mapping up FI/CO masters with FSV. Passing Document Posting.
- Configured specific aspects of FI/CO Module including GL, AR, AP.
- Completed some critical configuring aspects in AM with a cross-functional team, like Configuring US Chart of Depreciation and its Assignment to Company Code, configuring asset purchases, Master records and postings, Issues of goods for fixed assets, Depreciation adjustment and write-ups with changing the useful life of Asset and Leasing Assets.
- Imparting training to Key users of FI/CO module.
- Unit testing and Integration Testing. Configuring Country US Version.
- Provided support for General Ledger, Asset Accounting, Controlling (including Cost Center Accounting, Internal Orders), and Treasury- Cash Management, Project System modules for Users.
- Maintained cost centers, activity types, statistical key figures, cost center categories, document numbers. Involved in creation of primary and secondary cost elements groups, maintained cost element attributes.
- Creation of Cost Centers, Cost Elements, Activity Types, Standard Hierarchy, Profit Center, and PCA Accounting.
- Responsible for standardizing and organizing the report structure, which included development of reports using SAP Report Writer.
Confidential, Hyderabad (Mar 2002 - Apr 2003)
SAP Consultant
Confidential
Support Project
- Solving the tickets / production tickets
- Solving the tickets using the Synergy tool based on priority.
- Discussing and understanding the application functionality in area of SAP-FI/CO
- Solving the incidents in the order of the priorities with screen service help desk
- Preparing the customized Reports according to the client's requirement.
- Incident is the problem/issue raised by the user and it is solved in a specified
- Period.
- Solved the tickets on General ledger, Accounts payable, Accounts Receivable,
- Fixed Assets, Cost Center Accounting, Internal Orders, Profit Center Accounting.
- Preparing the Design Documents from collecting from the Business group.
- Collected requirements using Question and Answer database.
- Analyzed and decompose the Business Process.
- Development
- Implemented the Lockbox Processing
- SAP Cash Application - specifically ACH and EDI 820 integration
- Developed AR processes in large corporations (open item management, A/R conversions, dunning, clearing items, dealing with deductions, etc) Specialty in cash application - especially manual cash application and lockbox.
- Tested EDI 820 and BAI2.
- Experienced with a live cash application environment and who can work with users on how to handle manual cash application and cash post-processing.
- Implemented Check Printing Process
- Configured the Interface of Check Printing remotely at Citibank for company codes
- US9P and US9Q with TIBCO, GXS, Citibank and Moore System.
- Prepared functional Specification for Check printing, Tested end-to-end scenarios with middle vendors.
Confidential, Hyderabad (Jan 2001 - Feb 2002)
Financial Analyst
- Assisted Controller with preparation, review, and analysis of financial statements.
- Conducted and coordinated company's monthly and year-end closings.
- Performed monthly and quarterly financial accounting reports.
- Reviewed and assisted in supervision of day-to-day work of accounting department staff of 6 people.
- Prepared company's tax return and coordinated internal audit with external auditors.
- Conducted audits for management to assess effectiveness of controls, accuracy of financial records, and efficiency of operations.
- Provided and performed proper checks and balances over company's various financial operations.
- Reorganized and collected data to determine pricing of individual by products.
- Secured and interpreted discrepancies directly to management.
- Succeeded in reducing outstanding account receivables by interacting with customers on a regular basis.
- Monitored and created various expense reports to project company profitability.