Sap Fico Functional Consultant Resume
Juno Beach, FL
SUMMARY
- 9 years of IT experience as an SAP FICO Consultant withstrong functional experience in the implementation, customization and configuration of SAP FICO module with two full life cycle implementations, with a thorough understanding of integration between other modules.
- Configuration experience in SAP Finance and Controlling (FICO) modules.
- Two full life cycle implementation experience with multiple domains.
- Experience working in diverse domains such as Oil & Gas, Manufacturing, Pharmaceutical and Retail.
- Expertise in implementation of SAP R/3 Financial and ECC 5.0 & ECC 6.0 Financials (Including New General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Bank Accounting (BL), Asset Accounting (AA), Cost Center Accounting (CCA), Internal Orders (OPA), Profit Center Accounting (PCA), Profitability Analysis (COPA), Product Costing (CO - PC), Funds Management (FM), Grants Management (GM) and integration experience with MM, SD, PP, HR, SRM and SCM as well as experience with BW/BI).
- Experience working on functional and technical design document for various RICEFW object with strong techno-functional knowledge.
- Empowered to evaluate profitability of projects and ensure financial aspects of business and are properly handled.
- Strong understanding of business workflow, technology, project planning (duration of project, budget estimates, resources, tasks and change management issues etc) and translation of business requirements into SAP solutions.
- Configured changes in Consolidation task and performed integration testing between special purpose ledger and SEM-BCS Consolidation.
- Report specifications to ABAP programmers regarding report format objects of the report, technical information i.e. tables fields and then testing.
- Worked on lockbox process configuration, bank statement processing, cash management (CM) to monitor payment flows and liquidity and also worked on client's lockbox banks to validate the inbound files.
- Hands on experience in IDocs, flat files and data upload to SAP table, sending and receiving of data form external system.
- Extensively worked on BI report mapping of Info cubes coordinating with regular data upload and solve issues on miss match figures in BI and COPA reports.
- Strong knowledge and worked in Generally Accepted Accounting Principle (GAAP) and Sarbanes-Oxley Act (SOX).
- Excellent team player, great feedback on working with team members, highly motivated with strong analytical and communication skills with an aptitude for success.
- Exceptional problem solver and decision maker with diverse experience in finance, accounting, and all aspects of office operation, as well as expertise in general accounting, analysis, management, budgeting, cash management, cost accounting, management reporting, inventory, accounts receivable and accounts payable.
- Have exposure to Oil & Gas industry processes.
- Data migration expert - legacy to ECC 6.0 using Legacy System Migration Workbench (LSMW) using Direct batch input and Batch recording input methods.
- Expert use of SAP Apps tools including the Information Systems Reporting Tools SAP Query (SQ01, SQ02, SQ03), ABAP Workbench Utilities Quick Viewer (SQVI).
- Implementation and configuration experience with SAP R/3 4.6C, ECC 5.0, 6.0 and S/4 HANA.
- Worked on Upgrade Projects R/3 to ECC, ECC 6.0 Patches and Support packs. And tested multiple end-to-end scenarios, to ensure system reliability.
- Experienced in Unit, Integration and user Acceptance testing in SAP MM-WM modules.
- Proficiency in Spec Designing, Gap Analysis, Technical Documentation, interacting with the Super Users & End User Training, Reporting and Data Conversion and uploading of Master Data, Go-Live implementation and after go-live support.
- Understanding & Analyzing customer’s ‘AS-IS’ Business Processes and mapping ‘TO-BE’ processes.
TECHNICAL SKILLS
Methodologies Used: Accelerated SAP (ASAP), Agile, Waterfall
Other Tools: Solution Manager, JIRA, MS Office-Excel/Word/PowerPoint/Outlook, Project, MS Visio, SharePoint.
ERP Packages: SAP R/3 ECC 6.0, ECC 5.0, 4.6B, 4.6C, SAP S/4 HANA
Reporting Tools: SAP Queries, Report Painter and Report Writer
SAP Interface tools: ALE, IDOC, EDI
Data Migration: LSMW
Testing Tool: HPQC, Panaya
Integration: QM, SD, PP, MM, WM and PM
PROFESSIONAL EXPERIENCE
Confidential, Juno Beach, FL
SAP FICO Functional Consultant
Responsibilities:
- Analysed business requirements and determined organizational structure, business units, company codes, and profitability centers (AS IS - TO BE)
- Conducted GAP analysis, documented the findings, assessed scope of studies & suggested solutions through SAP for implementation and customizations. Worked closely with MM, SD and PP-PI consultants so as to ensure that commercial controls and accounting requirements are met as per business process blueprint
- Defined chart of accounts, GL master records, field status groups, and automatic account determination and sales tax automatic account assignments.
- Defined adjustment account for GR/IR clearing by configured regrouping postings.
- Involved in data migration from legacy systems to SAP through LSMW. Extracting Master data & transactions data to Non - R3 format, clean up data, mapping interfaces, loading data into SAP format (IDOC) and testing loaded data.
- Creation of vendor master records, groups, vendor documents, number ranges, payment terms, discounts, Configured Automatic Payment Program.
- Configured for vendors subject to withholding tax, interest calculations on item \ balance interest calculation, number ranges for forms, interest on arrears, account balance calculation on account balances / line items
- Created and defined credit control areas to company code including pre-defined credit limits for customers
- Configured dunning program, dunning levels, dunning areas and dunning forms for each company at company code level. Configured payment terms for dunning, for over-due interest calculations, for down payments and automatic clearing of line items. Report specifications to ABAP programmers regarding report format objects of the report, technical information i.e. tables fields and then testing
- Configured and customized integration links between FI/CO/SD/MM/PP to optimize transaction processing
- Defined customer master records, customer groups, House bank.
- Defined and assigned reconciliation ledgers and maintaining accounts for automatic reconciliation posting.
- Maintained Controlling area settings and made hierarchy and other assignments
- In Cost Element Accounting Created Primary and secondary Cost elements, created Cost Element Groups, Configured the reconciliation ledgers
- In Cost Center Accounting (CO-CCA) created the cost centers and maintained the Standard hierarchy, assigned cost centers to cost elements. Configured Activities, Statistical Key Figures
- Developed cost sheet, cycles, segments for cost center distributions and assessment to allocate manufacturing overhead cost-to-cost objects. Configured settlements, cost splits for Activity Price calculations. Setup internal orders and cost collector configuration
- In Internal Orders configured various internal order types, setup status profile for order type, maintained settlement rules, internal order planning, and budget profile and also set up tolerances for budget cost. Defined the settlement rules, and used internal order with AUC /Capital investment projects.
- In Profit Center Accounting maintained the basic setting, created hierarchy, dummy profit centers, Profit center master data, profit center groups, activity types, etc and extracted reports using PCA
- In Asset Management configured asset classes, master depreciation and other business transactions. Fixed asset accounting, reconcile asset management to GL.
- Configured the chart of depreciation and settings up the various depreciation areas like book depreciation.
- Worked on lockbox process configuration, bank statement processing, cash management (CM) to monitor payment flows and liquidity and also worked on client's lockbox banks to validate the inbound files.
- Technical proficiency in implementation of major functionalities like Electronic/Manual Bank Statements, Payments, Electronic and Manual Check deposit, Payment Advices, complete Check Management functionality.
Confidential, Chicago, IL
SAP FICO Functional Consultant
Responsibilities:
- Collected and analysed user’s business requirements identified and defined areas for improvements, prepared specifications for development, configuration, troubleshooting and supporting for systems users.
- Analysis of all open items, foreign currency revaluation, reclassification of payable and receivable, clearing of goods receipt/invoice receipt GI/IR accounts, performing reconciliation, profitability allocations by business area.
- Configured company code which includes creating chart of accounts, defined posting period variant, retained earnings account, document types, and tolerance groups for employees, created financial statement version.
- Followed ASAP Implementation methodology and designed the business processes, wrote blueprint phase documentation and completed Configuration during realization phase.
- Designed the process of payment proposal approvals for different payment methods like ACH, Wire, Check and P-cards in A/P.
- Involved in modelling of invoice processing, Disbursement run, check printing and bank reconciliation processes for A/P.
- Eliminated Duplicated Inter-Company AR/AP Postings in Cross-Company Sales Orders, Ensured That SD Billing Document Invoices Are Posted in FI.
- Worked on bill of exchange configuration and processing in FI-AR by configuring the reconciliation accounts in the special GL.
- Worked on customer transactions, Master data, Payment terms, Cash application, Lockbox processing, Mapping Bank Lockbox format with Sap lockbox format, customizing payment advice notes on Accounts Receivable (A/R).
- Worked on Correspondence types on A/R that means different outputs, which can be printed and sent to your business partners based around customer G/L information.
- Responsible for A/R customer transactions, credit management, check printing, payment terms, Cash application, Lockbox processing, Cash receipts, clearing and month end and Year-end activities.
- Used Biller Direct in FSCM for electronic invoicing and payment collection.
- Defined distribution for cash position and liquidity forecast, cash collection strategy in Biller Direct using FSCM.
- Managed electronic customer billing disputes, receivables, collections and customer credit risk using FSCM.
- Identified technical improvements in FSCM and the related interfaces focusing on application sharing and business process optimization.
- Used FSCM to employ tools to analyze credit worthiness and establish policies. Enabled customer access to invoices, account status and payment information over the Internet.
- Used Collection Management functionality in FSCM for creating a collection work list, preparing and documenting customer contacts.
- Cleaned Legacy Customer Master Data. Reviewed customer address data, Credit limits, Dunning, Line item displays and carry forward balances.
- Configured Automatic Payment Program for Check, Wire and ACH payments.
- Worked on Logistics Invoice Verification (LIV or GR-IR verification) in FI-MM (Procure to Pay) integration and configured account determination for FI-SD (Order to Cash) cycles.
- Created Bank Master data, House banks, EDI, ERS, G/L accounts for each bank account and Reconciliation accounts for vendors, customers and assets.
- Provided functional assistance in the development of RICEF (Reports, Interfaces, Conversions, Enhancements and Forms).
- Created custom KE31 reports for the management and users in CO-PA.
- Resolved end-user issues involved in cost roll, WIP calculation, variance calculation and period end settlement in different plants.
- By setting the status to TECO that were not billable, resolved issues in Product cost by Sales order / Production order.
- Configured Cost component structure and roll ups, BOM. Set up material cost estimate with quantity structure.
Confidential, Smith Field, RI
WM/IM/RF/LE Functional Consultant
Responsibilities:
- Gathered requirements for JVA legal entities.
- Configured Joint Venture Company codes for petroleum division.
- Wrote scripts for integration test and performed testing for scenarios: Goods receipts and issues, Project costs, Operating expenses and revenue, Acquisition, Transfer, Retirements, Assessments and distributions
- Prepared coaching guide for Joint Venture accounting processes and Month end steps.
- Performed master data migration of Joint Ventures, Joint operating agreements. FICO and SEM BCS
- Resolved functional issues with North and South America users in various areas of FICO
- Performed master data changes in Consolidation units, Hierarchies, Financial versions of Plan, Budget and Actual.
- Configured changes in Consolidation task and performed integration testing between special purpose ledger and SEM-BCS Consolidation.
- Supported BOFA interface for ACH, Wire transfers and outsourced checks.
- Designed reports for IFRS financial statement including P & L, cash flow, balance sheet, management & statutory briefing papers and external consolidated financial statements including income statement, balance sheet, recognized income and expenses. Bank Accounting - Lockbox
- Gathered requirements of BAI2 file format.
- Configured lockbox and account determination
- Designed and wrote functional spec for user-exit to maximize clearing.
- Working on to create the BPP's for the business users by using the Upper form software and giving training to the users to execute the BPP's.
- Created the month end closing scenarios for the finance and controlling part of the organization.
- Contributing as SAP FI/CO consultant to the business testers and verified that the solution delivered meets client expectation and business requirements.
- Created data sets related to the scripts of different scenarios used by business.
Confidential, Duluth, GA
SAP FICO Functional Consultant
Environment: ECC 6.0
Responsibilities:
- Maintained Cost Center Standard Hierarchy, write substitution rules to assign cost centers automatically to G/L accounts according to requirements, defined distribution and assessment cycles for monthly allocations.
- Worked on FI-SD account determination rule to accurately capture the accounting requirement during Billing and PGI.
- Involved in the customization of dunning program including creation of the dunning proposals and also editing the dunning proposals.
- Configured Lockbox Processing program, House Banks with SWIFT code, defining lockbox accounts at House banks, defined lockbox parameters and posted data and tested the lockbox functionality.
- Configured and Tested the Lockbox program for Accounts Receivables payments in BAI2 Format.
- In Profit Center Accounting, maintained the basic settings, created Master Data for Profit Centers, Profit Center groups, Dummy Profit Center, Profit Center Hierarchy, Activity Types and assigned different Controlling Objects to Profit Center Accounting.
- Created report painter and report writer for Profit Center Accounting reporting.
- Worked extensively on developing data models for COPA reporting utilizing both Costing based and Account based data source.
- Worked extensively on the COPA design in integration with SD. Mapping of Value fields to Condition types. Develop COPA derived Characteristics using Derivation rule, Enhancements (User exits), Table move.
- Configured Summarization Level to in corporate new COPA characteristics for COPA reporting.
- Developed various COPA report based on the business requirement.
- In Product Costing, created Costing Variant, Cost Component structure, Configured Material Cost Estimate with quantity structure, maintained settlement structures, configured WIP and Price variance calculations and settlement of Variance to Profitability Analysis; Create, mark and release of cost estimate.
- Maintained settings for Costing Sheet like calculation bases, percentage overhead rates, and quantity based overhead rate in Product Costing (CO-PC)
- Configured Material Cost Estimate with Quantity Structure and costing variant for cost component structures like BOM and Routing for the products provided by PP. Worked on integration of PP with SAP-FICO module.
- Calculated Overheads, Work in Process (WIP), variances and settlement. Cost Component Layout with multiple cost component views, additive cost, special procurements and releasing of the new cost estimate.
- Participated in integration testing and supported User Acceptance Testing (UAT)
Confidential, Houston, TX
SAP FICO Functional Consultant
Environment: SAP ECC 6.0
Responsibilities:
- Performed initial analysis of various legacy system fields and developed mapping rule related to the current production SAP system.
- Developed LSMW to upload financial transactions and Master data (Vendor Master, Customer Master, and Asset Master Data) for conversion.
- In Accounts Payable, configured Automatic Outgoing Payment program for Check, ACH and Wire payment and DMEE setup.
- Developed RICEF inventory document, identified inbound/outbound interfaces and it's functionalities
- In New General Ledger, developed parallel ledgers to maintained New GL configuration to create Leading and Non-Leading Ledger for legal and corporate reporting, Reconciliation between Financial Accounting and Cost Center Accounting.
- Worked on and configured Document Splitting on profit center level.
- Worked on design and configuration of US sales/use tax solutions using Sabrix.
- Configured the Tax Calculation Procedure, specified structure for Tax Jurisdiction Code, defined codes for taxes on sales and purchases, defined tax codes for nontaxable transactions.
- Defined Financial Statement Version for the Balance Sheet report run.
- Defined Chart of Depreciation, Depreciation Areas, & account determination for asset class.
- Mapped the business process to SAP transaction related to Asset acquisition, Planned and Unplanned Depreciation Run, Asset Retirement (scrapping), and asset capitalization.
- Implemented Automatic Intercompany and Intra-company Asset transfer.
- Configuration of the Internal Order module to support capital procurement process involving planning, budgeting, approvals, settlements, status management, reporting, in integration with investment management.
- Involved in defining month end closing and year-end closing activities for business units.
- Developed Testing Scenario to Validate GL Account and Open Item Balances.
- Assisted the business user to perform the cutover task and help in validating the data.
Confidential
SAP FICO Functional Consultant
Responsibilities:
- Involved from the very beginning of the project from Project Scope Analysis, Business Requirement Gathering, Gap Analysis, Realization, Testing, Training and Support.
- Created flowcharts and Business Blue Print for the existing processes.
- Joined company at start-up, designing the Chart of Accounts and writing customized General Ledger and Financial Reporting systems.
- Configured and customized General Ledger, creation of G/L accounts, screen layout rules, Automatic Account Assignments, Financial Statement Version.
- Defined templates for configuring recurring entries in general ledger postings.
- Configured the accounts for Foreign Currency Valuation and worked on month end foreign currency valuation.
- Configured and customized Account Receivable and Accounts Payable modules including creation of Vendor/Customer Master Records, account groups, tolerance groups, number ranges, posting keys, document types, fiscal year variants, and field status groups.
- Configured House Banks, Automatic Payment Programs, Automatic Payment Methods, and Alternate Bank Selections for Payments. Checks Management through assigning number ranges for check lots, checks printing and defining void reason codes. Posting Invoices with and without Invoice Verification.
- Coordinated the integration efforts of FICO with SD and MM, based on functional requirements and automatic account assignment.
- In Controlling, maintained Cost Center Standard Hierarchy, Distribution and Assessment Cycle.
- Configured costing-based CO-PA, created characteristics and value fields, used various derivation techniques and rules
- Developed test scripts and test scenarios using HP quality center.