Sap Fico Consultant Resume
4.00/5 (Submit Your Rating)
Plano, TX
SUMMARY
- Around 8+ years of strong functional experience in SAP FICO consulting including Two Full Life Cycle Implementations and One System Upgrade.
- Worked in all phases of ASAP Methodology; Project Preparation, Business Blue - Printing, Realization, Final Preparation and Go-Live & Support. Interacted with end users to understand the process flow and suggested improvements.
- Strong expertise in Functional Configuration and implementation of the following SAP R/3 modules: New General Ledger, FI-General Ledger, FI-Accounts Payable, FI-Automatic Payment Program, FI-Accounts Receivable, FI-Asset Accounting, FI-Special Purpose Ledger, CO-Cost Center Accounting, CO- Cost Element Accounting, CO-Internal Order, CO-Profit Center Accounting, CO-Product Costing, CO-Profitability Analysis.
- Accounts Receivable: Customizing Customer Account groups & Creation of Customer Master Data, Maintain Number Ranges & Assign Number Ranges to Customer Account Group, Configuration of Document types and Document Number Ranges.
- Firm integration understanding of AR & AP with FSCM.
- Created reconciliation accounts for Accounts Receivables & Configuration of Dunning.
- Configuration experience with Lockbox, Automatic payment program, Dunning, Credit management.
- Excellent working experience in different industries i.e., Manufacturing, Automotive, and Pharmaceutical firms.
- In depth understanding of Business Processes in SAP ib and Controlling modules and their integration with SD, MM, PS and PP.
- Expertise with sound knowledge in ABAP Queries and Reporting Tools: Report Painter and Report Writer, User-exit programming, LSMW, Programming and Debugging.
- Excellent working experience in configuration of Lockbox Program to clear A/R open items and dunning as well to follow up with Customer and Vendor payments.
- Proficient in Project Evaluation, AS-IS study, Fit-GAP analysis, TO-BE process, troubleshooting, performance tuning, Production Support and End-user training.
- Worked in environments adhering to US GAAP & SOX compliance. Good experience in developing interfaces using EDI and ALE.
- Demonstrated ability to work both in independent and team-oriented environments with well-developed organizational skills, excellent communication and interpersonal skills with problem solving ability.
TECHNICAL SKILLS
Financial Accounting: G/L, Accounts Payable (AP), Accounts Receivable (AR), Asset Accounting (AA), New GL and Material Ledger
Controlling: Cost Center Accounting (CCA), Internal Order Accounting (IO), Profit Center Accounting (PCA), Profitability Analysis (COPA), Product Costing (CO-PC) and Project Systems (PS)
PROFESSIONAL EXPERIENCE
Confidential - Plano, TX
SAP FICO Consultant
Responsibilities:
- Analyzed the existing legacy system, gathering functional requirements through user meetings, gap analysis, and participation in process improvement teams; produced the functional requirements document.
- Activated of New G/L and Leading Ledger with creation of Segments and assigning Scenarios and Customer Fields in the Parallel Ledgers, Document splitting, parallel accounting, parallel currency, Real Time FICO integration.
- Configured Automatic Payment Program for checks, and outgoing payments in Accounts.
- Implementing the Electronic Bank Statement with the bank for all of the cash application.
- Configured Lockbox functionality, defined control parameters for BAI2 file import for handling incoming payments from customers, worked on Special GL transactions such as Down Payments.
- Worked on chart of depreciation, inter-company asset transfers and balance-carry forwards and re-organized accounts for various cost and profit centers and programmed schedules and jobs.
- Integrated AP and AR modules in FI with MM and SD respectively.
- Involved in localization projects for Mexico E invoicing, E accounting and compliment de Pago
- Developed custom reports for special tax auditing/reporting purposes based on business requirement.
- Participated in system integrated testing (SIT) to test FI and CO related multiple scenarios, as part of confidential new Europe release.
- Have been testing various functionalities as part of modular test cases general ledger, account payable, account receivable, fixed assets and month end closing activities for 27 Europe countries.
- Involved and supported FI team in testing the scenarios related to indirect country specific taxes and withholding taxes for all the 27 countries.
- Supported and trained business users in user acceptance testing (UAT), in all test cases related to FI and CO.
- Test case validations were updated, and defects were entered using the quality analysis tool HP ALM.
- Involved in the Development of test cases and resolved issues at Unit Testing and Integration Testing. Provided End User Training, Courseware and Documentation in FI/CO Modules
- Maintained Lockbox Configuration for automatic incoming payments, Cash Management, Planning levels in Treasury and EDI & Month End Closings.
- Provided support for Configuration, Implementation and Testing of the customer master records and incoming payments, banking & Intercompany transactions.
- Responsible for Configuring the Dunning Program and defined the layout and the functional specifications for creating dunning letters which will have the ability to be both mailed and emailed.
Confidential, Shepherdsville, KY
SAP FICO Consultant
Responsibilities:
- Set up company codes, chart of account, account groups, fiscal year variants, tolerance limits, posting periods and financial statement variant.
- Configured General Ledger Accounts (G/L) master records.
- Activated New G/L, leading ledger and parallel ledger for the possibility of parallel accounting according to the US GAAP.
- Created reconciliation accounts for A/P and A/R
- Configured Accounts Payable (A/P) including vendor account groups, number ranges, tolerance groups, automatic payment program, and create house bank.
- Configured Accounts Receivable (A/R) including customer account groups, number ranges, terms of payment, interest calculation procedures, and reason codes for underpayment and overpayment, default account assignments, employee tolerances, Lockbox procedure and configure dunning procedures.
- Configured Credit Control Areas, risk categories and Pre-Defined Credit Limits for customers
- Extensively worked on LSMW, ABAP Queries with the ability to act as a techno functional consultant.
- Configured and customized account groups, posting keys, document number ranges and document types, open and closed posting periods and maintained field status groups.
- Configure Integration of FI with MM & SD
- Configured Controlling area, Cost Elements, Cost Centers, Profit Centers for CCA and PCA
- Configured cost objects, account assignments, allocations and settlements in CO
- Maintained overhead cost elements defined costing sheets, credits, overhead keys. Configured standard cost estimates in Product Cost planning for the production orders with quantity structure and configured WIP calculations and variance calculations.
- Created settlement profile, allocation structure for period end closing and maintained number ranges for settlement documents.
- Finalization of chart of Accounts and LSMW for upload of Accounts Group, Field status Group that existed previously in the company.
- Configured various components in the SAP FI/CO like Accounts Receivable (AR), Accounts Payable (AP) and General Ledger Accounts, mainly differentiated between one-time vendors and regular vendors in manufacturing sector
- Defined and Configured GL, Vendor/Customer master data and account groups.
- Configured the Automatic payment program for Intercompany automatic account posting, running program for Check management, open item clearing and down payments.
- Configured Cash journals and special GL transactions.
- Configured New G/L for document splitting and provide Document simulation facility rather than waiting for period end process.
- Maintained Fiscal Year and Posting Period Variants
- Defined and Maintained tolerance groups for GL, AP and AR
- Provided Consolidated reports for viewing both Finance and controlling activity.
- Preparing User Exits for Characteristics derivation not defined in standard SAP system.
- Mapping SD condition types to value fields (for SD interface)
- Used COPA to report profitability driven by characteristics like customer, product and market for a clearer picture of the company’s profitability. Created CO-PA forms and Report Line Structures.
Confidential - Chicago, IL
SAP FICO Consultant
Responsibilities:
- Involved in blueprinting and workshops, requirement analysis for streamlining the various processes in corporate and management projects in AES.
- Conducted requirements gathering workshops and documented the business processes.
- Configured outgoing payments for ACH, Checks, and Wire payments.
- Configured global settings and enterprise structure.
- Knowledge and experience in all aspects of RTR (Record to Report), PTP (Procure to Pay) and OTC (Order to Cash).
- Configured Automatic Payment Program for Outgoing Payments for Company Codes in Accounts Payable.
- Customized Electronic Bank Statement Reconciliation Accounts. Also completed several Reports, Interfaces, and functional specifications and worked closely with the technical team in developing the functional objects.
- Asset Accounting - Defined chart of depreciation, various depreciation areas and depreciation keys required asset classes, number ranges, revaluation settings etc.
- Worked on several POC’s for S4HANA 1809 like reducing project risk, facilitating productive decision making and improve overall project productivity.
- Created SAP HANA Information Models using Attribute, Analytic and Calculated Views.
- Gather requirements for Simple Finance implementation Develop and Build S/4HANA / Simple Finance Architecture, Build S/4HANA Design Configure, S4/HANA / Simple Finance system. Define HANA sizing, Define Interfaces to the system, Defining Solutions for Proposals and Customer problems, arranging trail for customer to give a feel of service conducting financial analysis for proposed solutions.
- Customizing SAP S/4HANA FICO modules General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Bank Accounting, Fixed Assets Management (AM), Document Splitting, Internal orders.
- Customizing New General Ledger (G/L in SAP Accounting powered by SAP HANA).
- Profitability Analysis (COPA): Planning methods, Layouts, Reports, Planning levels, Planning versions, Derivations rules, Integrated Planning, data uploads from excel.
- Created Planning Layouts, hierarchy and configuration for Cost Center, PCA and COPA.
- Identify RAR relevant data from source for Order/Contract items, Fulfilment items and Invoice (planned and actual) item.
- In Asset Accounting, involved in Configuring and creating Asset Master Records, Chart of Depreciation and Customizing Screens for Asset Creation. Involved in defining Depreciation Keys, Calculation Methods and Depreciation Areas to the Assets Masters.
- Worked on customizing the CVI integration to Business Partner.
- Cost Center Accounting: Created cost centers, activity types, statistical key figures, Cost Center Standard Hierarchy, cost center categories, maintained default account assignments and automatic account assignments.
- Cost Element Accounting: Created Primary and Secondary Cost Elements, created Cost Element Groups.
- Responsible for daily Treasury cash management duties, review bank accounts, positive pay, investment logs and resolve transfer issues.
- Testing, and support of In-House Cash, A/P and Treasury Automatic Payment Programs, IDOC creation/troubleshooting, Configuration of electronic bank statements.
- Validated postings from Sales Order document flow to FI including tax postings in Vertex and performed invoice verification.
- Performed tax interface configuration for Vertex US sales and use tax.
- Worked on integration issues with Vertex.
- Experienced in working with Banking Interfaces, various modes of payments, Forex Instruments and related enhancements.
- Closely collaborated with the procurement department and maintained Capital Equipment Requisitions to ensure accurate and timely reporting of fixed assets.
- Reconciled fixed asset additions of others, pulled data for auditing requests and properly filed backups.
- In Internal Orders maintained order types, screen layouts, maintained order groups, status management, maintained settlement rules, settlement profile, planning profile, budget profile, availability control etc.
- Designed and blueprinted cash management for Cash position Reporting, Cash Forecast Reporting, Liquidity Planner and Transaction Manager for different borrowing and Investment processes.
- In Product Costing, configured standard Cost estimates in Cost object controlling for production orders, Configured WIP calculations, variance calculations, maintained settlement structures and handled month end closing procedures for production order.
- Configured Material Ledger settings for valuation area, currency types, Number Ranges. Defined Material Movement Type, Material Update Structure. Configured Actual Costing and Actual Cost Component Split.
- Profit Center Accounting: Created Profit centers, Standard Hierarchy, Configured Profit center Master Data, maintained Default Account Assignments and Automatic Account Assignments, Validations and Substitutions, Distribution and Assessments.
- Configured PCA by creating profit centers, standard hierarchies, assigned elements, to profit center, planning profile and planning layouts.
- Configured AP (Account Payable): Payment runs, Automatic payments, Manual payments, Check management, GR/IR clearing account maintenance (MIGO, MIRO & LIV) and Account maintenance documents.
- Good understanding about enhancements in New GL in SAP ECC 6.0
- Configured material cost estimate with Quantity structure, costing variant, cost
- Component structure and BOM and Routing settings required for costing the product.
- Good Knowledge of integration between SD, MM, PP with FI/CO with in depth understanding on Order to Cash and Procure to Pay cycles.
- Created new planning layout using Report painter and generated reports using Report Writer.
- Configured valuation areas, multiple currency types, movement type groups and material update structure in product costing.
- Responsible for carrying out valuation in COPA to access pricing and product cost information thereby allowing projected revenue and cost of sales figures to be calculated.
- Implemented transfer of overhead costs, transfer of activities from cost center accounting over to COPA segments.
- Fixed issues with valuation areas for material ledger, maintained number ranges and assigned currency types to material ledger.
- Experience supporting Open Text VIM, and 'Accounts Payable for SAP' by Open Text solution.
- Used LSMW & CATTs to upload Master data.
- Prepared scenarios for unit, functional and integrations testing.
- Worked extensively on Microsoft excel for data analysis and valuation.
Confidential - Milwaukee, WI
SAP FICO Consultant
Responsibilities:
- Responsible for requirements gathering, prototyping, and configuration of GL, AR, AP modules. Responsible for standardizing and organizing the reporting structure which included development of reports using report writer and report painter.
- Setup fixed asset structure - Asset class, Depreciation areas, & Asset master data. Maintained master data and structure for Asset accounting modules.
- Responsible for Configuration of Asset acquisitions, Asset retirements, Asset transfers, revaluation of assets, depreciation run and year-end closing activities in Asset accounting.
- Complete asset accounting with three depreciation areas including Book, Tax - Federal and State, with group and company currency as parallel currencies. It included complex depreciation keys and period controls for each depreciation areas, periodic posting to more than one depreciation area.
- Responsible for posting of lease payments, acquisition of leased assets, processing of the expiration and scrapping of leased assets. Responsible for designing of asset transaction types for capitalization of assets under construction.
- Defined and configured Dunning process which included creation of dunning proposals to creating dunning notices, Interest calculation - open items/balance outstanding, correspondence and account statement process and financial statement versions.
- Responsible for customizing of payment methods, payment terms, cash discount automatic postings, bills of exchange and doubtful receivables postings. Designed and configured Payment program, electronic bank statements for payments such as direct debits, check and bank transfers.
- Period end closing operations for foreign exchange valuations on payables/receivables and G/L account balances.
- Responsible for Lockbox design, configuration and testing the complete lockbox process and incoming payments settings.
- Designed and configured credit management settings and credit card settings from Accounts receivable perspective.
- Maintained settings for Controlling Area, Operating Concern and maintained Versions.
- Configured cost center accounting, profit center accounting, and internal orders.
- Created Profit Center groups under Standard profit center Hierarchy and was responsible for Cost Center and Activity Type Master Data.
- Configured costing-based CO-PA, created characteristics and value fields, used various derivation techniques and rules, configured CO-PA planning including planning levels, plan package and planning methods.
- Defined summarization levels to call up data stored in Profitability analysis and generated Reports on different profitability segments using the data from CO-PA tables.
- Assisted client in design and configuration of PA structures including decisions on characteristics, and settlement to CO-PA. Customized appropriate settlement profiles to facilitate settlement to CO-PA and to CCA.
- Defined additional account determination to default cost centers, profit centers and profitability analysis (CO-PA) for postings to cost element.
- Designed functional specs and tested various Accounts receivable reports and coordinated with ABAP team and Business users to fix the trouble tickets. Designed functional specs and developed Report painter reports by creating libraries, report groups, sets and variables.
- Designed, created, and executed Unit test scripts and integration test scripts at every stage of the project. Coordinated with Users during User acceptance testing and resolved issues during UAT.
Confidential - Bismarck, ND
SAP FICO Consultant
Responsibilities:
- Responsible in preparation of Blueprint of Global Template for the Organization Structure.
- Analyzed the business requirements and mapped them to SAP processes, solutions and products that were being implemented.
- Configured the settings in General Ledger area, Parallel ledger, and Cross-Company Code transactions and for business processes such as fast-entry screens, posting, parking, reversals and month end closings.
- Integrated AP and AR modules with MM and SD respectively with respect to Account Determination for various Clearing and Adjustment Accounts and Automatic Postings.
- Configured Internal Order by maintaining Order Types, Screen Layouts, Order Groups, Status Management, Settlement Rules, Settlement Profile and Planning Profile.
- Maintained Overhead Cost Elements, defined Costing Sheets, Credits, and Overhead Keys in Product Costing.
- Defined distribution and assessment cycles based on cost elements.
- Generated reports through ABAP Query for Vendors and Customers.
- Configured Standard Cost estimates in Product Cost Planning for the production orders with quantity structure and configured WIP Calculations and Variance Calculations.
- In COPA configured both costing-based COPA and account-based COPA.
- Created Characteristics and value fields in COPA
- Maintained assessment cycles and the relationship of cost elements to profitability segments for transferring overhead costs to COPA.
- Configured cost-based COPA and configuration of PA structure, derivation rules and settlement to COPA
- Created report in COPA to report profitability by customer, market and product.
- Defined CSKA and operating concern for profitability analysis reports.
- Configured basic settings and master data of Profit Center Accounting.
- Responsible for unit testing, integration testing, and regression testing.
- Worked on Data conversion from Excel Database using SAP LSMW functionality.
- Configured Report Painter and Report writer reports.