Sap Fico Functional Consultant Resume
Redmond, WA
SUMMARY
- SAP FICO Functional Analyst with 8 years of functional experience in Financial Accounting (FI) and Controlling (CO) modules in Implementation, System user training and support of R/3 with different versions including ECC 6.0.
- Three full life cycle implementation experience with ASAP methodology, proficient in interacting with business users to identify information need and initiate process change.
- Strong experience in analysis, design development, blue printing, detailed configuration, testing, documentation, training, data uploading, preparing the cutover strategy, Go - live and post implementation support.
- Strong expertise in financial accounting in configuring and testing General Ledger (FI-GL), Accounts Payable (FI-AP), Accounts Receivable (FI-AR).
- Strong expertise in Controlling: Cost Center Accounting (CO-CCA), Cost Element Accounting (CO-CEA), Internal Orders (CO-IO), Profit Center Accounting (CO-PCA), Profitability Analysis (CO-PA), Product Costing (CO-PC).
- Strong experience in understanding Purchase Requisitions, Purchase Orders, procure to pay, vendor maintenance and integration between SD, MM, PP and HR payroll, Budget with FICO with in depth understanding on Order to Cash, and Procure to Pay cycles.
- Extensively worked on Credit management, Cash Management including bank accounting, cash concentration, cash position and liquidity forecast.
- Extensive working experience in Treasury system application, UAT related to Treasury, Bank Accounting and Special Ledger Transactions.
- Strong expertise in Automatic payment program, Lockbox with BAI and BAI2 formats and Electronic bank statement (EBS) with different file formats like NACHA, SWIFT, MT 940..
- Extensively worked on configuring New General Ledger accounting (NEW GL).
- Efficiently worked on WTH reporting with t-codes to print 1099 form and created the electronic file.
- Experience in different testing phases like Application Testing, Integration testing and User Acceptance testing.
- Proficient in using Quality center for Test planning, Requirements Management and Defect reporting and tracking.
- Very good experience in handling tickets during production support, ticket monitoring and reporting with SAP solution manager.
- Worked on different SAP Tax interfaces using Sabrix, Vertex and Taxware.
- Strong Experience in customer facing skills, working directly with End Users to Define Change Request Details.
- Experience with Class, Objects, Function Module, BAPI, Proxy, LSMW.
- Worked extensively with ABAPers on explaining RICEFW objects using functional specs.
- Expert in solution builder installation, BC sets and eCATT activation and trouble shoot, preparation of scenario documentation, configuration guide, variant files, master lists, Report Painter and LSMW.
PROFESSIONAL EXPERIENCE
Confidential, Redmond, WA
SAP FICO Functional Consultant
Environment: s: SAP BW, WRICEF, GL, AP, AR, FI-MM, FI-SD, FI-AA, CO-CCA, CO-PCA, CO-PA, LOCKBOX, EBS, IDOCS, eCATT, NEW GL, SPL, LSMW, BAPI.
Responsibilities:
- Carried out current business process study and Preparation of AS-IS document,carried GAP study & prepared GAP analysis report, prepared TO-BE solution, prepared business blue print documentand worked on identification and preparation of Financial Accounting Master Data and also worked on Post Go live and stabilization phase and resolved issues relating to different modules in FICO.
- Configured down payment functionally and payment medium workbench and also worked extensively on bank specific payment files to automate check and electronic payments to meet client's specific requirements.
- Worked on resolving the issues related to Payment program, Intercompany reconciliation, GR/IR clearing, Automatic clearing Issues and Issues related Invoice verification (MIRO).
- Trained business users on various business processes like applying lockbox, running payment run and recurring entries for periodic transactions.
- Performed unit testing and regression testing for different accounts payable and accounts receivable functionalities.
- Configured changes to conditions types and pricing procedures for the additional posting for the intercompany transactions.
- Created various new (fixed asset) asset master data and tested them thoroughly in the testing client and transported them into the production.
- Configured sales and usage tax calculations in VERTEX interface and worked on Physical Inventory postings, Solving Integration issues, Failed IDocs Processing and Month end closing activities.
- Created Validation and Substitution Rules for Asset accounting, consolidation, Project system, cost center and profit center accounting.
- Worked on configuring Inflation accounting for GL account, assets and in MM for several company codes during regular intervals.
- Worked extensively on support for CCA, PCA, product costing, Material Ledger and CO-PA.
- Worked on Cost center accounting, configured cost element, cost center and allocated plan and budget values for Cost center accounting (CO-CCA).
- Worked on issues related to Center Hierarchy, Profit Center Hierarchy, Cost Center Categories, Activity Types, and Statistical Key Figures.
- Worked on substitutions for Profit center derivations and Master Data Maintenance in PCA, which included set up of new Profit centers and Enhanced COPA reports.
- Worked on Profitability Analysis (CO-PA), created the Operating concern, configured cost based Profitability analysis. Defined and configured the reporting characteristics, value field, profitability segments used in Profitability analysis.
- Worked on configuring the necessary settings to transfer plan data from controlling components to Special Purpose Ledger (SPL) and resolved issues.
- Supported the functionality of price control with and without the material ledger in product costing.
- Worked on Brazilian taxation with Vertex and configured tax accounts for PIS, ICMS and COFINS tax codes, Worked on Vertex to update and change the tax calculation processes.
- Experience with enhancements (BADI, Enhancement Points, User Exits), worked on with report development (ALV, classic & interactive).
- Worked on different features of NEW GL like document splitting (segment reporting) and parallel ledger etc.
- Worked on NEW GL document splitting for segment reporting and also used zero balance clear account feature in NEW GL.
- Provided SAP FI/CO tuning and troubleshooting including the identification and resolution of performance related issues.
- Provided End user support to the SAP user community & strictly followed SOX rules for the Support Phase.
- Prepared month end close reports and set up the master data for Allocations (Assessments and Distribution) and trained users on daily routines and month end processing.
Confidential, Beaverton, OR
SAP FICO Functional Consultant
Environment: SAP BI, GL, AP, AR, ASAP, RICEFW, FI-MM, FI-SD, FI-PP, PROCURE TO PAY, FI-AA, CO-PCA, CO-PA, CO-CCA, CO-CEL, CO-IOA, CO-OM, IDOCs, SABRIX, LOCKBOX, EBS, NEW GL SPL and LSMW.
Responsibilities:
- Designed the business processes using ASAP implementation methodology, followed GAP analysis, collected and analyzed users business requirements, identified and defined areas for improvements, prepared specifications for development, configured, troubleshoot and supported the system users, Responsible for whole process of implementation (road map) from beginning to deployment.
- Worked extensively on WRICEF functional specifications like, new reports with table and filed names, performed conversions to convert standard sap form to user understandable forms, with enhancements added functionalities to standard SAP, interfaces to bring data from third party system to the SAP and worked with ABAP team to explain these specifications.
- Customized and configured AP and AR modules, worked on Automatic payment program for different payment methods like ACH, wire and Checks.
- Assigned unique number ranges to various document types for different transactions.
- Configured house banks, bank accounts, reason codes, check lots and lockbox for payments.
- Configured automatic interest calculation procedure, payment terms, correspondence and dunning procedures.
- Integrated FI with SD, PP and MM for the logistics, order management trade and Inter-company transactions.
- Worked on account determination for MM and SD modules.
- Responsible for troubleshooting and resolving SD billing issues, including pricing and account determination errors, and billing job failures.
- Implemented the correct process for invoice entry. Included usage of subsequent invoice pricing for price adjustment and teaching the payables group how to investigate and understand postings made against a purchase order.
- Worked as lead on transferring data from legacy system to SAP using LSMW and uploaded customer master data using LSMW techniques.
- Configuration of FI-AA Asset classes, depreciation areas, assigning company codes to chart of depreciation.
- Worked extensively on Order to Cash, Procure to Pay, Make to Stock, Make to Order scenarios.
- Responsible for year-end close activities like executing pending invoices, clearing open items for GR,IR and freight, open posting periods for next year, opening new CO posting period, Reconciliation of AM sub ledger with GL, Review internal order postings etc.
- Worked on Cost Center Accounting (CO-CCA), configured cost element and cost center, designed the structure for Cost Center Hierarchy based on client’s business requirements.
- Configured Internal Orders (IO) including real and statistical orders, Budget management using internal orders to be used for recording marketing related expenses.
- Design and implementation of comprehensive reporting solution in profit center accounting (CO-PCA) and profitability analysis (CO-PA).
- In Profit Center (CO-PCA), worked on Configuring and customizing the basic settings, maintaining profit center hierarchy, and assignments. Maintenance of master data and operating concern, periodic overhead allocation, setting up planning, transferring external data.
- Successfully implemented product cost estimate information transfer from CO-PC into CO-PA, through cost component values which facilitated the import of detailed cost-of-sales information into CO-PA for flexible margin reporting.
- Created several validations and substitutions for cost accounting, GL special purpose ledger (SPL) and profit center accounting.
- Worked on configuring User exits for Tax Calculation and other enhancements for standard sap functionalities.
- Worked on configuring Inflation accounting for GL account, assets and in MM for several company codes during regular intervals.
- Implemented a Custom process with the help of IDOC Functionality which enables the successful processing of data files even though there are errors at line item level including integration with ALE.
- Worked on executing unit test scripts, and supporting function and user acceptance testing.
- Responsible for translating other customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including Functional, Technical Specification and testing plan that culminate in client acceptance of the results.
- Monitored day-to-day activities like posting invoices open item clearing and fixed some incorrect postings.
- Prepared month end close activities like posting recurring entries, GR/IR clearing, period close in CO, CO-PA assessment, reconciliation between CO-CCA-CO-PA and set up the master data for Allocations (Assessments and Distribution).
Confidential, Toledo, OH
SAP FICO Functional Consultant
Environment: SAP SD, SAP BI, SAP BW, WRICEF, GL, AP, AR, PROCURE TO PAY, FI-AA, CO-CCA, CO-PA, CO-CEL, CO-IOA, CO-OM, CO-PCA, SAP MM, EBS, LOCKBOX, eCATT, LIV, LSMW, CREDIT MANAGEMENT IDOCs and EDI.
Responsibilities:
- Performed a full life cycle project implementation (road map) involved from business requirement gathering to the deployment, followed GAP analysis and management experience using ASAP methodology, accelerated systems design and development, business process reengineering, strategic analysis and planning, user training, cutover phase, demand analysis and sales pursuits.
- Worked extensively with ABAPers on explaining RICEFW functional specs like, new reports with table and filed names, interfaces for bringing data from third party system to SAP, with Enhancements brought additional functionalities to the SAP standard Workflow to define standard task, define triggering event and to specify how a document to be printed etc.
- Configured new company codes, Intercompany code assignments & processing and Intercompany Transport Orders.
- Worked on Customer Master, House Banks, Payment Programs, Electronic Bank Statements, Lock Box and had successfully configured clearing of open items in GL/AR/AP Modules.
- Worked on data migration tools like LSMW to migrate data from legacy system to SAP and uploaded vendor, customer master data using LSMW.
- Configured and customized AR and AP modules, for vendors subject to withholding tax, interest calculations on item balance interest calculation, number ranges for forms.
- Worked extensively on FI with MM, SD, PP integrations and configured account determination for integrating modules.
- Configured and Customized the Credit Management (Credit Control Area) to manage the receivables in association with SD team.
- Assigned various permittedCredit Control Areasto company code, made necessary settings forcredit limitcheck,risk categories,credit groups and automatic credit control.
- Designed and implemented all cash management and bank account structures within the region in cooperation with local management.
- Worked on Asset accounting (FI-AA), asset classes, chart of depreciation, different depreciation areas like book, group and ACRS and assigning company code to chart of depreciation.
- Created Validation and Substitution Rules for Asset accounting, consolidation, Project system, cost center and profit center accounting.
- Worked on exchange rates (FX) configuration and updated it during month end closing activities.
- Configured the system to handle various receivables scenarios (over, shorts, down payments, reversals and resets, credit memos and adjustments etc.). Verified and Tested GL transactions for business process (fast-entry screens, posting, parking, reversals, etc.).
- Worked on Cost center accounting, configured cost element, cost center and allocated plan and budget values for Cost center accounting (CO-CCA).
- Worked on CCA and PCA planning phases and defined cost element, cost center and profit center.
- Configured Cost Center Hierarchy, Profit Center Hierarchy, Created Cost Center Categories, Activity Types, and Statistical Key Figures.
- Configured and customized Internal Orders, allocated budget values for R&D and marketing.
- Maintained settings related to Controlling Area, Operating Concerns and also maintained Versions.
- Configured costing based CO-PA, created characteristics and value fields, used various derivation techniques and rules, also did CO-PA planning including planning levels, plan package and planning methods.
- Configured Derivation Rules to derive the required CO-PA characteristics and allocation structure to be used for CO-PA Assessment cycles.
- Worked on inter-company asset transfers, balance-carry forwards and re-organized accounts for various cost, profit centers and Programmed schedules and jobs.
- Worked on maintaining tax rate and posting accounts for output tax.
- Worked on tax calculation procedures in Europe countries followed through IFRS.
- Worked on writing functional specifications to create user exits for Menu exits, screen exits and Functional module exits.
- Worked on Outbound interface through IDOC (Change pointer) to transfer material pricing group and product number.
- Worked on integration, user acceptance testing and Quality assurance, supported on technical documentation and end-user documentation and Courseware. Designed, developed and maintained reports with support from ABAP Team.
- Worked in post implementation support (hyper care) and maintained the production system.
- Worked on month-end and year-end processes like preparing Balance Sheet, Profit & Loss Statements and income statements.
Confidential, Springfield, MA
SAP FICO Functional Consultant
Environment: SAP SD, SAP BI, LOCKBOX, P2P, OTC, EBS, CO-PA, MIGO, MIRO, PROCURE TO PAY, AP, AR, NEW GL, VERTEX, CO-CCA, CO-PCA.
Responsibilities:
- Developed business process flows, closing schedule and desktop procedures for all the activities in FICO.
- Worked on AP- Vendor transactions, Master data, Check management, house banks, payment program, payment terms, deduction management, Clearing Intercompany Vendor/Customer.
- Configured AR-customer transactions, credit management, payment terms, Cash application, Lockbox processing, mapping Banking data format and Cash receipts.
- Experience in configuration of Automatic Payment Run, Banks Accounting and Electronic Bank Statement (EBS).
- Worked effectively in configuring Bank Accounting relating to FI and management.
- Worked on configuring and testing on OTC and P2P life cycles.
- Documented critical changes performed system tests and trained client team members on new system functionality.
- Configured source symbols, planning levels, planning groups, treasury groupings for liquidity forecast, Cash management and Cash concentration.
- Worked on open item clearing, cross-company code transactions in NEW GL accounting.
- Configured planning periods, planning versions in NEW GL accounting.
- Worked on open text invoice management with minimizing processing time.
- Worked extensively on PO based invoice processing and non-PO based invoice processing.
- Worked on revenue recognition and implemented crediting differed revenues while billing with sales order.
- Designed structure for Cost center Accounting, Profit center Accounting and Internal orders.
- Worked on Profitability Analysis (CO-PA), created the Operating concern, configured cost based Profitability analysis. Defined and configured the reporting characteristics, value field, profitability segments used in Profitability analysis.
- Configured the derivative structures and rule for characteristics. Defined both basic reports and form reports for the business units by profit centers to analyze the profit at customer and product levels.
- Experienced in working with treasury workstation in liquidity risk analysis, transaction and position management.
- Worked on indirect taxes using vertex, basic settings and various scenarios of tax ware interfaces.
- Worked on integration of vertex with sales order and used some user exits regarding these.
- Worked on various testing methodologies like regular unit testing, integrated testing and User acceptance testing (UAT).
Confidential, Scottsdale, AZ
SAP FICO Functional Consultant
Environment: RICEFW, SAP SD, SAP CRM, SAP BI, SAP BW, AP, AR, PROCURE TO PAY, EBS, LOCKBOX, DUNNING, LSMW, BADI, BAPI, IDOC, WTH, LIV.
Responsibilities:
- Worked on Customer Transactions, Master Data, Payment Terms, Customizing payment advice notes on A/R.
- Worked on transfer pricing to valuate goods movement between profit centers.
- Configured Automatic Payment Program for Check, Wire, ACH payments and also created variant for programs which create payment medium like RFFOUS C, RFFOUS T.
- Worked extensively on configuring and also support for Tax related management.
- Configured house banks, bank accounts, assignment of the accounts to a check lot, automatic payment program for out-going payments in A/P and worked on global banking for EMEA countries like Jordan, Poland, Hungary & Egypt.
- Created FI/AR number ranges, incoming payments, reconciliation accounts, overall receivables management and terms of payment.
- Responsible for configuring the Dunning program, Interest Calculation on Open Items, Correspondences and Account Statement process and also customized the layout and the functional specifications for creating dunning letters which will have the ability to be both mailed and e-mailed.
- Configured assigning Accounts to Account Symbols in EBS and processed Electronic bank statement.
- Worked extensively on Lockbox with both BAI and BAI2 formats to clear customer open items.
- Worked effectively on transferring customer master data from legacy systems using LSMW.
- Worked on Logistics Invoice Verification in FI/MM integration and configured account determination for FI/SD cycles.
- Created planning layouts for cost element planning and statistical key figure planning.
- Configured costing based CO-PA, created characteristics and value fields, used various derivation techniques and rules, configured CO-PA planning including planning level.
- Worked in the area of Asset accounting i.e. FI-AA module, configured Chart of Depreciations and Asset master data.
- Worked on trouble-shoot ABAP development and have demonstrated ability to design custom programs and interfaces.
- Worked on experience creating and supporting validations, substitutions, CATT and LSMW.
- Experienced working in Sarbanes Oxley (SOX) compliant processes.
- Worked on promoting policies and procedures to ensure adherence to FDA and other regulatory requirements.
- Configured specifications for account determination in Asset accounting.
- Implemented a Custom process with the help of IDOC Functionality which enables the successful processing of data files even though there are errors at line item level including integration with ALE.
- Developed and designed efficient and effective daily monitoring cash flow through local and cross border cash pooling.
- Configured the automatic write-off process, which included the implementation of BADI for getting cost center to the correct reason code.
- Configured settings related to Business Application Interfaces (BAPI).
- Worked effectively on Credit and debit memos related to logistics invoice verification.
- Worked on withhold tax (WTH) taxes for invoices and payments.
- Eliminated duplicate inter-company AR/AP postings in cross-company sales orders and ensured that SD billing invoices were posted in FI.
- Developed various test scenarios for the payments which include automatic payment program.
- Thoroughly analyzed the client’s business requirements, identified and defined areas for improvements, prepared specifications for development, configured, troubleshoot and supported the system users.
- Followed ASAP implementation methodology, planned, designed, developed, implemented (road map) and supported the business processes.
- Wrote blue print phase documentation and completed configuration during realization phase.
- Worked on writing RICEFW functional specifications and performed functional support to RICFEW object development technical team.
- Involved in AS-IS (GAAP) process flow charts and designed blueprint workshops for finalizing Organization elements and for many integrated processes.
- Worked on supporting client subject forCompliance and Change Management.
- Configured company code which includes creating of chart of accounts, number ranges, retained earning account, document types and tolerance groups.
- Configured and designed the full functionality of FI module relating to FI-AR & FI-AP.
- Worked on Credit management, tolerance limits, open item clearing, account groups, Incoming & Outgoing payments, Automatic Payment Program, field status groups.
Confidential, Pittsburgh, PA
SAP FICO Functional Consultant
Environment: AP, AR, EBS, APP, SPL, LOCKBOX (BAI2), CREDIT MANAGEMENT, HPQC, LSMW, FI-AA, REPORT PAINTER, BPT, CATTs.
Responsibilities:
- Configured house banks, bank accounts, assignment of the accounts to a check lot, automatic payment program for out-going payments in AP.
- Configured and executed the Automatic Payment Program (APP) and worked exclusively on payment methods like ACH processing and check runs.
- Maintained Lockbox configuration with BAI2 format and also worked on Electronic bank statements (EBS) with MT 940 format.
- Worked extensively in the area of Asset accounting (FI-AA), Chart of Depreciations, Asset master data and Configured specifications for account determination in Asset accounting.
- Worked effectively on transferring customer master data from legacy systems using LSMW.
- Special emphasis on Data Migration specifications with BDC, Legacy System Migration workbench (LSMW) for data uploads for various SAP Projects.
- Configured special purpose ledger (SPL) for down payments and reporting purposes.
- Calculated Overheads, Work in Process (WIP), variances and settlement and also worked on Cost Component Layout with multiple cost component views, additive cost and special procurements and releasing of the new cost estimate.
- Worked on supporting for the SAP FICO production applications by responding to support desk calls, tracking problems/issues, and following up with customers.
- Worked on Quality centre for scripts, execution and defects, worked on defect reports, testers daily execution reports, defects closing reports daily.
- Executed the automated test scripts and worked on Quick Test Professional.
- Prepared Test Conditions, test cases and scripted in Quality Centre for Project systems, CO-PA, AP, AR.
- Configured functional test cases utilizing Business Process Testing (BPT) methodology in HP Quality Center.
- Completed Unit testing and integration testing. Created authorization profiles, tested the system before go-live and hyper care (post implementation) support.
- Tested report generation using reporting tools Report Painter, worked extensively on eCATTs programs and trained user in working with this reports for end users and provided end user training.
- Configured and designed the full functionality of FI module relating to AP & AR configuration: Credit management, tolerance limits, open item clearing, account groups, field status groups and reason codes.
- Configured General Ledger: Created Master records, accounts groups, number ranges and GL accounts for each company code, accounts maintenance and preparation to master files, substitutions and validations rules for documents, recurring entries, interest calculations etc.