Sap Fi-co Mater Data Design Analyst Resume
Beaverton, OR
SUMMARY
- SAP FICO functional consultant with around 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 go live support.
- Strong expertise in financial accounting in configuring and testing General Ledger (FI-G/L), 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 on integration between SD, MM, PP and HR 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).
- Extensively worked on configuring New General Ledger accounting (NEW G/L).
- 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 effectively on configuring (FI-MM integration) MIGO, MIRO and Logistic Invoice Verification (LIV).
- 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.
- Proactive, identify the business problems, trouble shooter, formulate strategic plans, initiate changes, implement new process to the challenging and diverse environment.
- High learning curve with the ability to embrace new tools and technologies with demonstrated leadership, ability to resolve issues, drive projects and meet deadlines.
PROFESSIONAL EXPERIENCE
Confidential, Beaverton, OR
SAP FI-CO Mater Data Design Analyst
Environment: G/L, AP, AR, ASAP, RICEFW, FI-MM, FI-SD, FI-PP, SAP BI, FI-AA, EC-PCA, CO-PA, CO-CCA, CO-ABC, BPT, LOCKBOX, REPORT PAINTING and LSMW.
Responsibilities:
- Designed the business processes using ASAP implementation methodology, 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 from beginning to deployement.
- Worked extensively on RICEFW 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.
- Worked extensively with network of work stream specific business data experts from all Client/functions to align on data definitions, data standards, and use in SAP Fl-CO.
- 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.
- Worked as data design validation leader for each work stream / process design team for Master data CRUD process.
- Integrated FI with SD, PP and MM for the logistics, order management trade and Inter-company transactions.
- Responsible for the functional data definitions, data standards, and use in data dictionary repository tied to process standards in SAP Fl-CO.
- Responsible for documenting client’s business process and performed SAP baseline configuration.
- 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.
- 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 G/L, 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 (EC-PCA) and profitability analysis (CO-PA).
- Created several validations and substitutions for cost accounting, G/L special purpose ledger and profit center accounting.
- Worked effectively on all kinds of variances in Logistics module.
- Worked on designating workflow steps to sort and route invoices based on user roles, Authorization roles.
- Created the Cost variants, valuation variants and made the assignments, created the cost component structure.
- Analyzed end user requirements and proposed some viable solutions for report improvement, QA and user training in CO. Generated reports using Report Painter.
- 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 per schedule before go-live and provided hyper care support in FICO modules.
- 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 FI-CO Mater Data Design Analyst
Environment: SAP SD, SAP BI, RICEFW, G/L, AP, AR, FI-AA, CO-CCA, CO-PA, SAP MM, EBS, LOCKBOX, eCATT, LIV, LSMW, CREDIT MANAGEMENT and EDI.
Responsibilities:
- Performed a full life cycle project implementation and management experience using ASAP methodology, accelerated systems design and development, business process reengineering, strategic analysis and planning, user training, 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.
- Worked extensively with network of work stream specific business data experts from all Client/functions to align on data definitions, data standards, and use in SAP Fl-CO.
- Configured new company codes, Inter-company code assignments & processing and Inter-company 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.
- 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 Cost center accounting, configured cost element, cost center and allocated plan and budget values for Cost center accounting (CO-CCA).
- Configured and customized Internal Orders, allocated budget values for R&D and marketing.
- Created Validation and Substitution Rules for Asset accounting, consolidation, Project system, cost center and profit center accounting.
- Configured the system to handle various receivables scenarios (over, shorts, down payments, reversals and resets, credit memos and adjustments etc.). Verified and Tested G/L transactions for business process (fast-entry screens, posting, parking, reversals, etc.).
- 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.
- Worked on inter-company asset transfers, balance-carry forwards and re-organized accounts for various cost, profit centers and Programmed schedules and jobs.
- Created FM Structure and Integrated with FI and Built the Cash Budget and Funds Management and different planning versions. Set Up the commitment item management in FICO integrated with FM and MM. Integrating the MM Purchase orders with FM.
- Worked on following US GAAP for financial report accounting.
- Worked on maintaining tax rate and posting accounts for output tax.
- Configured Foreign Exchange and Interest Rate Edging.
- Designed and configured theEDIProcess for invoice postings.
- Integration, 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 go live 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 Consultant
Environment: SAP SD, LOCKBOX, P2P, OTC, EBS, CO-PA, MIGO, MIRO, AP, AR, NEW G/L, 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 Inter-company 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 G/L accounting.
- Configured planning periods, planning versions in NEW G/L accounting.
- Worked on open text invoice management with minimizing processing time.
- Worked extensively on PO based invoice processing and non-PO based invoice processing.
- 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 FI-CO Mater Data Design Analyst
Environment: RICEFW, SAP SD, SAP CRM, SAP BI, AP, AR, 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.
- 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.
- 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.
- Analyzed all open items, foreign currency revaluation, re-classification of payable/receivables, clearing of goods receipt/invoice receipt GR/IR accounts, performed reconciliations, profitability allocations by business area.
- 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.
- 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 AR portion of credit management to settle credit limits and monitoring customer against their credit limits.
- Worked on integrating several functions like sales order while maintaining plant abroad functionality.
- 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 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 process flow charts and designed blueprint workshops for finalizing Organization elements and for many integrated processes.
- Worked as data design validation leader for each workstream / process design team for Master data CRUD process.
- 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 Consultant
Environment: AP, AR, EBS, APP, 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.
- 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 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 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 G/L accounts for each company code, accounts maintenance and preparation to master files, substitutions and validations rules for documents, recurring entries, interest calculations etc.
