Sap Fi Co Consultant Resume
Houston, TX
SUMMARY
- Highly skilled professional with 7 plus years of expertise as SAP FICO Consultant in Designing, Implementing, Customizing, Configuring, Integrating, Testing, Document preparing, User training, Go - Live and Support in SAP R/3 FI CO.
- Was involved in Two Full Life-cycle implementations of SAP R/3 and Upgrade projects from SAP R/3 4.7 to ECC 6.0;
- Collaborated in project evaluation, gathering and analyzing business requirements, creation of business Blueprints, identifying Gaps between AS-IS and TO-BE, mapping processes to SAP R/3 functionality, collecting Master data, Testing, Go-Live, End-user training and documentation.
- Profound Financial Accounting expertise in Configuring & Testing of General Ledger Accounting (GL), Accounts Payable (AP), Accounts Receivable (AR), Bank Accounting (BA), Asset Accounting (AA) & Special Purpose Ledger (SPL) especially in highly Complex Business Environment;
- Worked on Accounts Payable (P2P) and Accounts receivable (OTC) modules with in depth understanding of Logistic Invoice Verification (LIV) with the concentration on Cash Management and Treasury;
- In depth knowledge of FI/CO modules integration with other modules such as Material Management (MM), Sales and Distribution (SD), Plant Maintenance (PM), Production Planning (PP), Project System (PS);
- Controlling expertise includes Cost Center Accounting (CCA), Cost and Revenue Element Accounting (CO-CEL), Profit Center Accounting (EC-PCA), Profitability Analysis (COPA), and Product Costing (COPC);
- Configuration and Implementation of NEW GL with excellent experience in document splitting, parallel accounting, real time integration, parallel ledger and segments;
- Conversant with legacy Data Migration using SAP interfaces like BAPI, IDOCs and LSMW
- Experienced in SAP Upgrade projects from SAP 4.7C to ECC 6.0;
- Strong knowledge in EDI and ALE system integration with ERP and legacy systems, data mapping, data flow and cross system interfacing;
- Engaged in SAP Treasury implementation with experience across Cash management (Cash position/Liquidity forecast), Electronic banking and reconciliation, Lockbox processing, In House Cash, Payment medium workbench and expert in Data medium exchange configuration;
- Experienced with Dunning procedures and Automatic Payment Program;
- Provided training sessions for end users and created training documents using RWD Info Pak and SnagIt tools;
- Reporting tools like SAP Query, Report Painter/ Report Writer and Drill Down Reports.
PROFESSIONAL EXPERIENCE
Confidential, Houston, TX
SAP FI CO Consultant
Environment: SAP ECC 6.0 Full Life Cycle Implementation
Responsibilities:
- Conducted “As-Is” study interaction with core team members and developed a “To-Be”;
- Gathered requirements from business users, defined various business processes to be mapped in to SAP ECC 6.0., wrote the Blueprint Document for specific areas of responsibility, conducted Fit-Gap Analysis;
- Defined Currencies for Leading Ledger in New GL;
- Assigned Scenarios & Customer fields to ledger in New GL;
- Activate Document Splitting, Specified splitting rules, Classified Document Types For Document Splitting; Defined Document Splitting Characteristics For General Ledger Accounting and Controlling in New GL,
- Configuration settings for Accounts Payable (AP) and Accounts Receivable (AR) Screen Layouts, Vendor and Customer Master Data, Set Up Automated Payment Program (APP);
- In Accounts Payable (AP), defined Interest Calculation types, Interest Indicators, accounts for item Interest Calculations;
- Configured Global settings of multiple currencies and Exchange rate differences and round off methods in Accounts Payable (AP);
- Configuration of Cost & Sales Accounting, Parallel Valuation Methods, Posting Business Transactions in General ledger (GL) Line items;
- Assigning of New GL accounts to Financial Statement versions;
- Transferred the FI Accounts Receivable (AR) and FI Accounts payable (AP) to profit center accounting (PCA) in the Period-End Closing;
- Maintained Account Based Settings for Profitability Analysis (COPA) in Operating Concern. Conducted automated planning and transfers from/to other modules like cost center planning data, settle orders;
- Made settings for GL accounts for Assets under Construction (AuC), loss/gain on assetdisposal/retirement, and posting depreciation under different depreciation areas;
- Configured setting for revaluation of Fixed assets, normal depreciation run and posting of assets acquisition;
- Configured CO and Cost Center Accounting (CCA) and Profit Center Accounting (PCA). Created Profit center groups, Dummy profit centers, Profit center standard Hierarchies, assigned objects to the profit centers;
- Customized Model Orders, Allocation Structures, Settlement Rules and Settlement Profile for Internal Orders in cost center accounting (CCA);
- Configured Lockbox Processing. Customized Processing of Incoming Checks. Configured Transaction types and posting rules for Electronic Bank Statement (EBS) processing.
- Integrated the financial accounting and profit center accounting (PCA) in relation of Balance Sheet Items;
- Transaction Data Configuration & Processing Invoice Verification (MIRO - LIV): Maintained Invoice Receipt Tolerance Limits, Reductions in invoice, credit memos and Evaluated receipt settlement;
- Did extensive configurations in Procure to Pay (P2P) process involving Logistics Invoice verifications & MM Purchasing;
- Configured Search String settings to fill other fields (the Cost Center and posting rules) for Electronic Bank Statements (EBS);
- Setup House Bank for Automatic Payments and EDI setup for inbound and outbound IDOCs and ACH Processing.
Confidential, Houston, TX
SAP FI CO Consultant
Environment: SAP ECC 6.0
Responsibilities:
- Solved many configuration issues in General ledger, Accounts receivable (AR) and Accounts Payable (AP);
- Activated New GL, Created Leading and Non Leading Ledgers for the different Company Codes and activated Parallel Accounting for the Different Accounting Principles like US GAAP and other countries;
- Implemented New GL, performed document splitting, parallel accounting and periodic processing;
- In New GL created Leading and Non Leading Ledgers for the different Company Codes and activated Parallel Accounting;
- Configured settings for Cash discount with cost center derivation in New GL;
- The Bill of Exchange Configuration and processing in Accounts payable (AP) by configuring the reconciliation accounts in the Special general ledger (GL);
- Configured the FSCM dispute management, which can process Receivables that are related to disputes and dealt with number of payment deductions;
- Provided Production support for the FI module - General ledger (GL), Accounts payable (AP) & Accounts receivable (AR), Fixed Asset Accounting and for CO module - CEA, cost center accounting (CCA), and profit center accounting (PCA);
- Configured the system to deduct a cash discount for payment of fixed assetinvoice automatically and in real time, to the corresponding asset;
- Transferred the FI Accounts receivable (AR) and FI Accounts payable (AP) to profit center accounting (PCA) in the Period-End Closing;
- In Accounts Payable (AP), define Interest Calculation types, Interest Indicators, accounts for item Interest Calculations;
- Configured CO and Cost Center Accounting (CCA) & Profit Center Accounting (PCA), Created Profit center groups, Dummy profit centers, Profit center standard Hierarchies, assigned objects to the profit centers;
- Configured Lockbox Processing. Customized Processing of Incoming Checks. Configured Transaction types and posting rules for Electronic Bank Statement (EBS) processing;
- Configured automatic payment program (APP) for out-going payments in account payable (AP);
- Maintained the customer master record accordingly to make the customer's bank details appear in the Electronic Bank Statements (EBS) along with the bank transfer;
- Transaction Data Configuration & Processing Invoice Verification (MIRO - LIV): Maintained Invoice Receipt Tolerance Limits, Reductions in invoice, credit memos and Evaluated receipt settlement;
- Customized Model Orders, Allocation Structures, Settlement Rules and Settlement Profile for Internal Orders in cost center accounting (CCA);
- Checked assignments of relevant Cost Objects and in particular materials to Profit Centers;
- Assisted in profit center accounting profit center accounting (PCA) planning which involves Sales plan, Master production plan, Cost center plan, Sales and profit plan etc.;
- Improved company Lockbox Performance with User Exits, a Reformat Program, and Customized Reports.
Confidential, Foster City, CA
SAP FI CO Consultant
Environment: SAP ECC 6.0 Full Life Cycle Implementation
Responsibilities:
- Participated in gathering information on current company’s legacy systems, business processes and activities; analyzed business requirements, determining organizational structure, classifying business units/locations, determining company codes, and profitability centers (AS IS - TO BE).
- Performed Unit Testing and Integration Testing for all business processes related to General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR) & Funds Management;
- Defined Interest Calculation types, Interest Indicators, accounts for item Interest
- Configured automatic payment program (APP) for out-going payments in account payable (AP);
- Configured the FSCM dispute management, which can process Receivables that are related to disputes and dealt with number of payment deductions;
- Configured the system to deduct a cash discount for payment of Fixed AssetInvoice automatically and in real time, to the corresponding asset;
- Configured the Special general ledger (GL) transactions like down payment request (noted item) and down payment received;
- Defined Depreciation Area Posting to General Ledger, Assigned general ledger (GL) Accounts and Assigned Input Tax Indicator for Non-Taxable Acquisition. Depreciation calculation key in fixed assets;
- Assigning of New GL accounts to Financial Statement versions;
- Configured Transaction Data Configuration & Processing Invoice Verification (MIRO - LIV): Maintained Invoice Receipt Tolerance Limits, Reductions in invoice, credit memos and Evaluated receipt settlement;
- The Bill of Exchange Configuration and processing in Accounts payable (AP);
- Transferred the FI Accounts receivable (AR) and FI Accounts payable (AP) to profit center accounting (PCA) in the Period-End Closing;
- Involved in integration process between Fixed Assets, New GLSegment Reporting, document splitting, Tracking Co-pays and Procure to Pay (P2P) and OTC processes;
- Created Cost Center Groups and Cost Centers, Primary and Secondary Cost Elements in cost center accounting (CCA);
- Capitalized Fixed Assets with Budget Monitoring Using Statistical Internal Orders.
- Configured In-House Cash Center Management Payment Processes and Cash Forecasting;
- Improved company Lockbox Performance with User Exits, a Reformat Program, and Customized Reports;
- Assisted client in design and configuration of PA structures including decisions on characteristics and settlement to Profitability Analysis (COPA).
Confidential, San Francisco, CA
SAP FICO Consultant
Environment: SAP ECC 6.0
Responsibilities:
- Solved many configuration issues in General ledger, Accounts Receivable(AR) and Accounts Payable (AP);
- Defined Chart of Accounts, performed basic configuration of system in areas of Global Settings, Organizational Structure, Company Code Definition;
- Configured the special General ledger (GL) transactions like Down Payment Request (noted item) and Down Payment Received;
- Worked on month-end and year-end processes (Balance Sheet and Profit & Loss Statements);
- Created Reason Codes for Payment Differences and worked on Writing Off these differences for General ledger (GL) Accounts;
- The Bill of Exchange Configuration and processing in Accounts payable (AP) by configuring the reconciliation accounts in the Special general ledger (GL);
- Successfully implemented product cost estimate information transfer from COPC into COPA through cost component values. Product Cost through sales order MTO, MTS scenario through object dependencies;
- Maintained transfer structures to post data from FICO and profit center accounting (PCA) to COPA;
- In Accounts Payable (AP), define Interest Calculation types, Interest Indicators, accounts for item Interest Calculations;
- Defined Accounts for Purchase Cash Discounts, Exchange Rate Differences, and Tolerances for Vendors;
- Define Posting Keys and Posting Rules for Check Deposit and Configuration of Automatic Payment program with Check Printing;
- Customized Credit Control Area for Credit Management in the application components, credits limit checks for SD processing and Risk Management for Receivables.
- Wrote Test Scripts in Integration testing. Completed Business Cycles across the Sub Modules were tested Integration of FI with SD;
- Created a new Operating Concern with custom characteristics and value fields and tested the flows from SD and FI documents into COPA;
- Configured Automatic Payment program for Check Run, including Bank Determination, Check Lot creation, House Bank set up and payment methods.
- Transferred the FI Accounts receivable (AR) & FI Accounts payable (AP) to profit center accounting (PCA) in the Period-End Closing.
- Integrated the financial accounting and profit center accounting (PCA) in relation of Balance Sheet Items.
- Maintained transfer structures to post data from FICO and profit center accounting (PCA) to COPA;
- Identified the possible sources of Data Affecting Profit Center accounting and explained to the client end users how data flow into profit center accounting.
- Provided functional resource on troubleshooting, day-to-day and month-end closing production support in controlling worked module.
Confidential, Blythewood, SC
SAP FICO Consultant
Environment: SAP ECC 6.0
Responsibilities:
- Involved in Pre and Post Go live and stabilization phase;
- Implemented New GL, performed document splitting, parallel accounting and periodic processing;
- Configured House Banks, Bank Accounts and assigned to Check lot. Configured automatic payment program (APP) for out-going payments in Accounts payable (AP);
- Configured Payment Terms, Over-Due Interest Calculations, Cash Discount and Automatic Clearing of Line Items;
- Implemented and Resolved issues relating to Automatic Payment Program (APP);
- Setup Lockbox in BAI2 format and configured Electronic Bank Statement (EBS), EDI Processing;
- Configured Dunning procedures, Dunning Levels, Dunning Areas and Dunning Forms at the Company Code Level. Configured Payment Terms for Dunning, for over-due interest calculations Automatic Account Determination, GR/IR clearing;
- Setup House Bank for Automatic Payments and EDI setup for inbound and outbound IDOCs and ACH Processing;
- Transaction Data Configuration & Processing Invoice Verification (MIRO - LIV): Maintained Invoice Receipt Tolerance Limits, Reductions in invoice, credit memos and Evaluated receipt settlement;
- Configuration of Asset Accounting Module;
- Successfully implemented product cost estimate information transfer from COPC into COPA through cost component values. Product Cost through sales order MTO, MTS scenario through object dependencies;
- Maintained transfer structures to post data from FICO and profit center accounting (PCA) to COPA;
- Created Asset Classes and Screen Layout Rules, Defined Number Range Intervals;
- Defined Depreciation Area Posting to General Ledger, Assigned general ledger (GL) Accounts and Assigned Input Tax Indicator for Non-Taxable Acquisition. Depreciation calculation key;
- Maintained the customer master record accordingly to make the customer's bank details appear in the Electronic Bank Statements (EBS) along with the bank transfer;
- Configured Search String settings to fill other fields (the Cost Center and posting rules) for Electronic Bank Statements (EBS);
- Automatic account determination, GR/IR clearing, Automatic clearing issues;
- Set up Vat/Tax Intrastate reporting;
- Created ABAP queries for post validation of data objects in SAP and participated in validation during several mock conversions.
Confidential, Santa Clara, CA
SAP FICO Consultant
Environment: SAP ECC 6.0
Responsibilities:
- Data conversion from Excel Database using SAP LSMW functionality;
- Defined Cost Component Structure in Product Cost Controlling, and configured Origin Groups, Calculation Bases, Percentage Overhead Rates and Credit Keys for defining Costing Sheets;
- Implemented Reference and Simulation Costing, Material Cost estimate with quantity structure;
- Configured Costing Variants for base planning object, Standard Cost Estimate and Current Cost Estimate;
- Defined Costing Type, Valuation Variant, Date Control, Quantity Structure Control, and Transfer Strategy for the Costing Variants;
- Implemented Product Cost by Order and Product Cost by Sales Order in Cost Object Controlling;
- Configured Costing Variants for Preliminary Costing, Simulation Costing and Sales Order Costing;
- Defined Splitting Structures and worked on actual price calculation and revaluation of production orders at actual Prices;
- Set up the Electronic Bank Statements (EBS) to effect automatic assignment of payments into and out of House Bank accounts (Bank Transfers, Checks) to the relevant open items and to clear these open items if possible;
- Configured FI SD integration and Revenue Accounts determination through VKOA, Order To Cash (OTC);
- Customized Account Assignment Categories, requirements classes and requirements types for the Control of Sales order related production;
- Created test scripts and executed the transactions to create base planning object, cost estimate with quantity structure, current cost estimate, mark and release and costing run;
- Performed unit testing on WIP Calculation, variance calculation and settlement and developed the test scripts;
- Configured different Internal Order Types and their Screen Layout and status management according to the business requirements;
- Customized Model Orders, Allocation Structures, Settlement Rules and Settlement Profile for Internal Orders;
- Worked on Cost Center Planning and assessment cycles;
- Worked with different business users on test scripts and coordinated in Unit Testing, Integration Testing and End-User Testing;
- Worked with business users during integration testing on CO month-end closing processes;
- Involved extensively in identifying the issues around Material Master, BOMs, Routings, PIRs, Vendor Master, Fixed Assets, General ledger (GL) Balances and General ledger (GL) Open Items.
- Provided mapping rules for data fields in various data objects;
- Created ABAP queries for post validation of data objects in SAP and participated in validation during several mock conversions;
- Performed Root Cause Analysis on routings and material master data load failures and presented to the leadership team.
Confidential, Oklahoma City, OK
SAP FICO Consultant
Environment: SAP ECC 6.0, Upgrade from SAP R/3 4.7 to ECC 6.0
Responsibilities:
- Participated in implementation and enhancement of the FERC module;
- Con figured settings for The FERC reporting functions to trace utility expenses;
- Master data extraction from legacy system, formatting as per SAP fields, mapping with SAP, data cleaning and preparing upload files;
- Added the FERC entries to the application component hierarchy.
- Identified the cost objects elements, cost centers, orders, cost elements, and other cost collectors relevant for FERC calculation;
- Identified a list of FERC indicators to be assigned later to the cost objects;
- Established the mapping relationships between General Ledger (GL) accounts and FERC accounts using FERC indicators and cost element ranges;
- Creation of New GL Accounts, Chart of Accounts, FSG and Posting periods;
- Configuration of New GL and created Blue Print for New GL, Plan of Migration, Tested and Performed Migration;
- Activated New GL, Created Leading and Non Leading Ledgers for the different Company Codes and activated Parallel Accounting for the Different Accounting Principles like US GAAP and other countries;
- Implemented New GL, performed document splitting, parallel accounting and periodic processing;
- Configuration of Cost & Sales Accounting, Parallel Valuation Methods, Posting Business Transactions in General ledger (GL) Line items;
- Assigning of New General ledger (GL) accounts to Financial Statement versions;
- Activated costing based Profitability Analysis (COPA) to report profitability by customer, product, and market. Monitored actual data flow from SD Billing Documents and FI. Generated Profitability reports using forms;
- Did extensive configurations in Procure to Pay process involving Logistics Invoice verifications & MM Purchasing;
- Configured Product Cost Planning, Marking, Releasing the Cost Estimate in Price Updating and defined Profit Center Hierarchy and Cost Center Hierarchy;
- Configured Material Cost Estimate with Quantity Structure and calculated costs on Production Order, Standard and Modified Cost Estimate and worked on Price Update;
- Configured Costing Variant, Valuation Variant, Cost Component Split, Cost Component Structure, BOM and Route Settings;
- Configured Cost Center Accounting (CCA), maintained Standard Hierarchy, created Cost Centers, Primary Cost Element Categories, Secondary Cost Element Categories, Automatic Cost Element creation, Manual Cost Element creation, activated Reconciliation Ledger;
- Created Projects, WBS Elements, Project coding mask and budgeting. Designed & helped build interfaces to create the WBS elements from the Legacy systems to facilitate the settlement of work orders to WBS elements.
Confidential, Dallas, TX
SAP FICO Consultant
Environment: SAP ECC 6.0
Responsibilities:
- Providing Production support for the FI module - General ledger (GL), Account Payable (AP) and Account receivable(AR), Asset Accounting and for CO module - CEA, cost center accounting (CCA) & profit center accounting (PCA);
- Custom application development for procurement process (non-purchase order/ purchase orderprocessing /receiving);
- Created Integrated Asset Acquisition and defined account assignment type for Asset Account, Account Assignment Objects for the Depreciation Areas;
- Electronic bank reconciliation, Check deposit. Configuration of relevant settings i.e. Settings for Treasury, Electronic Bank Statement, Lock box, Bank Reconciliation, House Banks Settings, collections management. Settings for General ledger (GL) and Sub Ledger Master Data;
- Maintained variants for customer statements and scheduled batch jobs for frequent transactional activities and configured financial statement version;
- Performed Unit Testing and Integration Testing for all business processes related to General Ledger, Accounts Payable, Accounts Receivable, Asset Accounting, Controlling, Project Systems and Funds Management;
- Involved with integration between Fixed Assets, New GLSegment Reporting, document splitting, Tracking Co-pays and PTP and QTC processes;
- Defined Exempt Cost Elements for availability control in Internal Orders(CO IO) and maintained Number Ranges for Planning and Budgeting Objects in Internal Orders(CO IO);
- Supported extensively on FI integrations with MM and SD Modules;
- Configured the system to deduct a cash discount for payment of Fixed AssetInvoice automatically and in real time, to the corresponding asset;
- Configured the Product, Customer and Organization profitability in the COPA module - set up the characteristics and value fields and configured the flow of values from FI to COPA;
- Monitored day-to-day activities and fixed issues/problems as they occurred;
- Checked assignments of relevant Cost Objects and in particular materials to Profit Centers;
- Worked with billing team on issues related to Debit/Credit Memo, and Invoices;
- Worked closely with technical team to design and develop ABAP/4 reports, interfaces and enhancements;
- Involved in writing of Integration test scripts and User acceptance test scripts, trained end-users in the areas of General ledger (GL), Account Payable (AP), Account receivable(AR) and CO modules;
- Developed custom reports in controlling module using Report Painter.