Sap Fico Consultant Resume
GA
SUMMARY:
- SAP FICO Functional Consultant with 7+ years of experience including 3 Full Life Cycle Implementations.
- Experience includes Implementation, Rollout and Production support in a validated environment.
- Industry experience includes Manufacturing, Service, and Healthcare.
- Strong expertise in Functional Configuration and Implementation of following modules of FICO: FI - GL, AP, AR, FI-AA, CO-CCA, CO-CEA, COPCA, CO-IO.
- Strong experience in Integration of various SAP Modules like SD, MM.
- SAP Information Lifecycle Management (SAP DATA Archiving, SAP DART, SAP DATA Management)
- SAP project experience includes development of Business process procedures, Business process flows, “As-Is” documentation, System blueprint, System test, User acceptance testing.
- Collecting of user requirements and reports and documenting the new functionalities.
- Worked on Reporting tools like Drilldown Reporting, Report writer and Report painter and ABAP Query.
- Performed Unit Testing, Regression Testing, System Integration Testing, and User Acceptance Testing.
- Effective communicator with excellent skills in making Business Presentation Documentation; well versed with ASAP Methodology.
- Hands on expertise in End-User training and documentation.
- Provided post live support, production support and maintenance.
- Individual as well as team oriented ability to work in a collaborative environment.
- A profit conscious individual who is highly motivated and welcomes new challenges and responsibilities. Demonstrated leadership ability to resolve issues, drive projects, and meet the deadlines, highly motivated to develop successful solutions.
TECHNICAL SKILLS
Financial Accounting: General Ledger, Accounts Payable, Accounts Receivable, Asset Accounting, Bank Accounting.
Controlling: Cost Element Accounting, Cost Center Accounting, Internal Order, Profit Center Accounting and Profitability Analysis.
Configuration: FI-GL, FI-AR, FI-AP, FI-AA, CO-CCA, COPCA, CO-IO, COPA
Implementation: Accelerated SAP (ASAP) Methodology, Gap Analysis, SAP Best Practices, professional, Conducting Workshops for gathering requirements, Data migration, Unit Testing, SIT (System Integration Testing), User Acceptance Testing, Training and cutover issue along with Post go live.
SAP ECC 6.0: ABAP Queries, ABAP Debugging, and Monitoring Background jobs, Report Painter, Report Writer, LSMW and CATT, BAPI, BADI.
MS-Office: MS PowerPoint, MS Access, MS Excel, MS Word and MS Outlook.
PROFESSIONAL EXPERIENCE
Confidential
SAP FICO Consultant
Environment: SAP ECC 6.0
Responsibilities:
- Extract and analyze FMC’s Financial Data and provided guidance with risk assessments and investigations independently to ensure that only relevant and valid data is provided to the Auditors.
- Worked on SAP Financial Tables and Fields to provide reports for the Auditors for yearly Audits.
- Exported Financial Data from SAP to Excel and organized as per Business requirements.
- Inform, review and evaluate the potential financial impact on the systems and Data of all new and existing projects with the Manager.
- Participated in meetings to gather business requirements from the Manager and Business Users and provided solutions and identified potential issues and threats with business requirements.
- Worked extensively with DART Project to provide financial data required by The Internal Revenue of Service.
- Discussed issues existing currently in DART with the manager, SAP Technical and Basis teams and provided resolutions by applying SAP notes.
- Ensured that changes made from one system to another system are transferred successfully following the appropriate transfer process.
- Ensure that the results/solutions/changes obtained satisfy client requirements and that the new business processes operate effectively and efficiently in the integrated system environment.
- Log issues into Service Now and then requested approvals from manager via Service Now to comply with any changes in the system.
- Maintained business and technical documentation for end users.
- Provide suggestions to maintain Data Integrity and Security while complying with external and internal Audits and understanding rules and regulations and limitations of Sarbanes - Oxley law.
- Involved in the team discussions with Open Text for Vendor Invoice Management systems.
Confidential, GA
SAP FICO Consultant
Environment: SAP ECC 6.0
Responsibilities:
- Accounts Payable (AP) & Accounts Receivable (AR)-Configured account groups for Customers and Vendors, defined screen layout per activity for customers and vendors, configured payment terms, created number ranges for Vendors/Customers-assign no. ranges to Vendor/Customer account group, tolerance for Vendors/Customers, customized Dunning program.
- Made Settings in OBYA for Intercompany Transaction
- Configured Automatic Payment Program, House banks and Bank accounts, special GL transactions like Down Payment Made or Down Payment Received, Configured Automatic Payment Program, Interface with Bank through EDI
- Configured FI-SD integration and FI-MM integration, Sales tax and Use tax.
- Electronic Bank Statement: Set up the Electronic Bank Statement (EBS) which includes the designing and configuration of Account Symbols, Assigned Account to Account Symbols, Created keys for posting rules, Defined posting rules, Created Transaction Types, Assigned External Transaction Types to Posting rules and Assigned Bank accounts to Transaction Types.
- Lockbox: Set up the Lockbox which includes designing and configuration of Control Parameters and Defined Posting Data. Worked closely with business users for business scenarios for cash discounts, short payments, charge backs and customer credits.
- Extensively worked on BAI2 file format with resolved issues like customer charge backs, Alternative Payer, customer discounts.
- Provide client with coherent transaction data, configured tool to retrieve the archived data into the DART tool's own tables.
- Used (DART) Data Retention tool to extract Data from Online R/3 Systems.
- Used (DART) Data Retention tool to transform database objects into flat files.
- Implemented SAP R/3 and BW data archiving within the regulatory and policy framework of the company.
- Provided the necessary archiving execution of hard hitting archiving objects that accompany a typically scoped SAP business environment.
- Involved in planning, design and implementation of data management, data archiving and system optimization solutions for the SAP ERP in an Oracle/SUN system platform.
- Took initiatives in configuring and implementing transparent user access modules greatly improved the way users can get to offline data.
- Dispute Management: Responsible for setting up the Dispute Management module which include the designing and configuration of attribute Profile, Case Types, Work Flow, Status Profile, Function Profile, Automatic Write-off settings, Profile for Case Search, Category, Reason Codes and Root Cause Codes.
- Worked on AP/AR reports and documented standard reports related to legacy reports and identify gaps for them.
- Resolved authorization issues for Dispute Management.
- Trained business users for EBS and Lockbox.
- Provided Break/Fix support - issue resolution, Issue resolution by working with functional/technical teams
- Provided post go live support.
- Prepared Configuration documents and training documents.
- Prepared functional spec for custom reports and provided to development team to work.
Confidential, NY
SAP FICO Consultant
Environment: SAP ECC 6.0
Responsibilities:
- Conducted requirements gathering workshops with business user’s team and created blueprint documents.
- General Ledger: Configured company code configuration which includes creation of Chart of accounts, Defined posting period variant, Retained Earnings Account, Document types, Tolerance groups for Employees, Configured foreign currency valuation, Created Financial Statement Version i.e. Defined Balance Sheet and Profit and Loss account, Integration FI- MM integration, FI- SD integration, Elimination Accounting
- Used MDM for Business Partner, Vendor, Customer, Bank Master and Material Master data
- Fixed Asset Management (AA): Create the chart of depreciation, depreciation areas for book depreciation, federal tax, state tax, alternative tax, group balance sheet. Finalized and defined asset class entry screens for asset master data record, custom fields for information purposes, Configuring depreciation key using various depreciation methods. Define base method, Maintain period control methods, define Multi-Levels methods & maintain depreciation key, account assignment, configure various sort key for asset reports, integration with PS
- Accounts Payable & Accounts Receivable-Configured account groups for Customers and Vendors, defined screen layout per activity for customers and vendors, configured payment terms, created number ranges for Vendors/Customers-assign no. ranges to Vendor/Customer account group, tolerance for Vendors/Customers, month end closing, Settings for Intercompany Transaction
- In house Cash: Set up bank area, created business partner data for legal entities, maintained number ranges for Internal IHC payment order and External IHC payment order, set up the payment method, paying company code, Set up of house bank. Worked on customized program like 401K, Excess Capital Distribution, COLA (Cost of Living Adjustment), Return on Investment, Income Settlement and RRD (Retired Resigned and Deceased Partner System).
- Customer transactions, Master data, Payment terms, Cash application, Lockbox processing, Mapping Bank Lockbox format with Sap lockbox format, customizing payment advice notes
- Configured EBS (Electronic Bank Statement) and trained business users for the processing for EBS.
- Set up the payment method for Checks, ACH and WIRE
- Configured Payment Program, House banks and Bank accounts, customized Dunning procedures, special GL transactions like Down Payment Made and Down Payment Received, Configured Automatic Payment Program
- Configured tax types, Input tax code and Output tax code, tax rates, and tax accounts.
- Created Non-taxable codes, allocated company code to Non - taxable transactions, created number ranges for External tax documents.
- Wrote Functional Development Specification, worked with ABAP team to implement standard BAPIs and Custom programs based on user requirements.
- Performed testing of implemented BAPI’s.
- Used (DART) Data Retention tool to extract Data from Online R/3 Systems.
- Used (DART) Data Retention tool to transform database objects into flat files.
- Involved in numerous customer-facing activities and user requirement meeting to develop data archiving specifications, establish data retention policies, user access requirements and print list reporting.
- Developed Conversion programs to load legacy data and interfaces programs, tested successfully.
- Worked on Data Conversion, Data mapping.
- Configured tax types, Input tax code and Output tax code, tax rates, and tax accounts
- Provided functional assistance in the development of RICEF (Reports, Interfaces, Conversions, Enhancements and Forms).
- Developed inbound and outbound interfaces which replaced the local planning system used for departmental budgeting and account level analysis.
- LSMW and Conversion programs to load the legacy data in to SAP.
- Performed unit and integration testing, regression testing, user acceptance testing(UAT)
- Provided end user training on business processes in SAP.
- Prepared end user training manuals using RWD Uperform
- Responsible for successful cutover from Legacy systems to SAP Production system.
- Provided Break/Fix support - issue resolution, Issue resolution by working with functional/technical teams
- Provided post go live support.
Confidential, ca
SAP FICO Consultant
Environment: SAP ECC 6.0
Responsibilities:
- Conducted requirements gathering sessions with business users’ team and prepared blueprint document.
- General Ledger: Configuration including Chart of accounts, country and group chart of accounts, company code, fiscal year variant, posting period variant, company code currency, group currency, currency exchange rate type, maintain TCURR table for maintain foreign currency rate, General Ledger master record, General Ledger account groups, field status group, define General Ledger account group screen layout, GL account group field status, assign number ranges to GL account group, define automatic account determination, line item layouts, special fields, sort variants, total variant, posting default document type & posting key and fast entry enjoy screens. Define reconciliation account, sales and use tax assignment, tolerance group and financial statement version, Integration FI- MM integration. Elimination Accounting
- Configured Exchange rate types, translation ratios, rounding rules & set decimal places for currencies.
- Heavily worked on Customization.
- Used MDM for consolidation of Vendor, Customer and GL Master data
- Accounts Payable (AP): Configuration including general AP configuration, Logistic Invoice Verification(MIRO), payment program configuration, payment block using reason codes, Vendor master records, vendor account group, vendor group field status, vendor partner function, line item layout, assign number ranges to vendor account group, automatic clearing of invoices against payments, automatic clearing of GR/IR accounts, Bank master data, configuration of house banks and accounts, bank account of GL structuring, create check lots and check printing and remittance advice, create positive pay file for Bank and bank reconciliation file for check clearing, Set up the payment method for ACH and WIRE.
- Accounts Receivable (AR): Configuration including customer groups, customer master record, define customer account group screen layout, customer group filed status, line items layouts, assign number ranges to customer account group, payment term and interest calculation. Automatics dunning program, reason codes, default account assignments, overpayments & underpayments, cash discount, set up customer tolerance groups, set up credit control areas.
- FI-SD integration
- Configured Payment Program, House banks and Bank accounts, customized Dunning procedures, special GL transactions like Down Payment Made or Down Payment Received, Configured Automatic Payment Program.
- Configured tax types, Input tax code and Output tax code, tax rates, and tax accounts.
- Created Non-taxable codes, allocated company code to Non - taxable transactions, created number ranges for External tax documents.
- Created validation and substitutions in AP.
- Fixed Assets Management (AA) including defining Assets Classes, defined depreciation areas for special depreciation, unplanned depreciation, configured the depreciation keys, special valuation of assets
- Used (DART) Data Retention tool to extract Data from Online R/3 Systems.
- Used (DART) Data Retention tool to transform database objects into flat files.
- Assisted in the SAP data/document management and data archiving, DART expertise, legacy migration requirements using IXOS-COLD and provide system administration for this global company.
- Provided functional assistance in the development of RICEF (Reports, Interfaces, Conversions, Enhancements and Forms).
- Participated in data conversion activity.
- Developed inbound and outbound interfaces which replaced the local planning system used for departmental budgeting and account level analysis.
- Used LSMW to load the legacy data in to SAP.
- Performed unit and integration testing, user acceptance testing(UAT) Provided end user training on business processes in SAP, created authorization profiles for end users.
- Used RWD Upperform for user manuals
- Responsible for successful cutover from Legacy systems to SAP Production system.
- Provided Break/Fix support - issue resolution, Issue resolution by working with functional/technical teams
- Provided post go live support.
Confidential, nj
SAP FICO Functional Consultant
Environment: SAP ECC 6.0
Responsibilities:
- Customization settings for Asset Accounting such as Chart of depreciation, account determination, Depreciation areas, Number ranges, Asset classes, GL accounts etc.
- Defining processes for asset acquisitions such as through PO and GRN or direct purchases. Depreciation related settings-Such as configuring Depreciation keys for books as well as tax depreciation, Depreciation run, Retirement as well as scrapping of assets, year-end closing procedure and activities.
- Automatic Payment Program configuration: Company code data, Paying company code, Country payment methods, wire transfer settings, ACH payments, Dunning Notices.
- Designed and configured Automatic Write off, Clearing, Late Fee for Accounts Receivable including Manual Clearing and Refund Process.
- Designed, configured, and implemented accounts payable check printing, periodic Sales and Use tax reporting, and related month end financial reports.
- Foreign Currency Transactions, translation, Valuation, maintaining Exchange rates.
- Problem Solving with End users involved in, Collections, Adjustments, Credit management, closing, and Payment run, Banking, Reporting and Cash Applications.
- Worked integration BW with FI and Enhancing the Reporting system.
- Provided functional assistance in the development of RICEF (Reports, Interfaces, Conversions, Enhancements and Forms).
- Worked on Data conversion activity
- Designed, configured, and implemented accounts payable check printing, periodic Sales and Use tax reporting, and related month end financial reports.
- Configured SAP Payment Program, EDI Partner/Port, payment methods and IDOCS.
- Foreign Currency Transactions, translation, Valuation, maintaining Exchange rates.
- Worked on various Interface Enhancements including, Lockbox Interfaces, AP-AR From/To Legacy, Inbound and Outbound Interfaces for Electronic Payments, Seibel - AR Integration and Maintenance, AR and Credit Card Integration using Pay metric Solution and Xi pay. AP-integration with legacy systems, MM (LIV), Intercompany Transaction
- Provided support and solved issues with End users involved in, Collections, Adjustments, Credit management, closing, and Payment run, Banking, Reporting and Cash Applications.
- Worked integration BW with FI and Enhancing the Reporting system.
- Provided functional assistance in the development of RICEF (Reports, Interfaces, Conversions, Enhancements and Forms).
- Prepared month end close and setting up the master data for Allocations (Assessments and Distribution).
- Used Data Retention tool to extract Data from Online R/3 Systems.
- Used Data Retention tool to transform database objects into flat files.
- Trained users on daily routines and month end processing.
- Defined the user roles and authorizations. Unit, Integration and User Acceptance testing
- Post production support for the Go-Live systems.
Confidential, nj
SAP FICO Functional Consultant
Environment: (SAP R/3 4.7)
Responsibilities:
- Interviewed end users to understand the As-Is system and identified GAPs in the requirements
- Configured the New GL, wrote the system and functional design for (Procure to Pay) P to P and Order to Cash (OTC) processes
- Designed General Ledger functionality including company code settings, number ranges, chart of accounts, GL master data, field status group, fiscal year variant, posting period variant and special purpose ledger setup. Configured the complete organizational structure for FI, like creation of company codes, business areas, chart of accounts, General Ledger master data and GL account groups
- Configured and customized Account Receivable and Accounts Payable modules-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, foreign exchange calculations, Automatic Payment Program, Dunning program, Intercompany Transaction
- Delivered End user training for new configuration and reporting to management and business groups
- Unit Testing for General Ledger, Accounts Payable, Accounts Receivable, Cost Center Accounting, Profit Center Accounting, COPA, PC functionality and integration testing with SD; User Acceptance Testing for All Modules
- Used Data Retention tool to extract Data from Online R/3 Systems.
- Used Data Retention tool to transform database objects into flat files.
- Prepared configuration documentation and end user documentation for GL, AR, AP
- Provided end user training
- Provided Break/Fix support - issue resolution, Issue resolution by working with Functional/technical teams
- Post production support for the Go-Live system
Confidential, mt
SAP FICO CONSULTANT
Environment: SAP ECC 6.0
Responsibilities:
- ASAP Methodology is used to do a thorough study of Activity flow & AS IS documentation. Resultant BPR studies from Blueprint Workshops documented for TO BE blue prints.
- Configured Vendor Account Groups, Vendor Master Records, House Banks, Bank accounts, Check lots, Reason codes, Automatic payments, recurring entries, invoices, credit memos, etc.
- Worked on creation Customer Master Records, Billing, Payment terms and interest calculation, Incoming payments, Dunning, AR Information System, Credit Management, closing operations, etc
- Managed financial information dealing with Assets, liabilities, capital. And prepared B/S, P&L statements and other reports to summarize and interpret current and projected company financial position for department managers
- Designed and configured Asset management to carry out business transactions like acquisitions, retirements, transfers, write-offs and post capitalization
- Grouped assets into manageable Asset Classes and customized screen layout for each asset class with unique number ranges. Created a Chart of Depreciation and carried out settings for asset company code. Made settings for GL accounts for AUC, loss/gain on asset disposal/retirement, for posting depreciation under different Depreciation Areas.
- Maintained validations and substitutions, overhead structure for accrual costs, allocations using cycle-segment method for periodic reposting, distribution and assessment, indirect activity allocations
- AR-customer transactions, Master data, Payment terms, Cash application, Lockbox processing, Mapping Bank Lockbox format with Sap lockbox format, customizing payment advice notes.
- Customized the standard hierarchy, cost centers, activities, and statistical key figures, developed assessment, distribution, periodic reposting cycles and segment in Cost Center Accounting
- Designed specs for development of FI CO Reports and Layouts. Generated reports using tools like Report Writer, Report Painter.
- Monitoring of Background jobs, Interface related issues, and Period end closing procedures. Provided functional assistance in the development of RICEF (Reports, Interfaces, Conversions, Enhancements and Forms).
- Developed functional specifications for interfaces from Legacy to SAP. Assisted Change Management team to capture the major organizational impacts due to SAP Design.
- Unit Testing for General Ledger, Accounts Payable, Accounts Receivable, Cost Center Accounting, Profit Center Accounting, COPA, PC functionality and integration testing with SD; User Acceptance Testing for All Modules..
- Prepared configuration documentation and end user documentation for General Ledger, Accounts Receivable, Accounts Payable
- Provided end user training.
- Provided Break/Fix support - issue resolution, Issue resolution by working with Functional/technical teams
- Post production support for the Go-Live system.
Confidential, NY
ACCOUNTANT/TAX ADVISOR
Responsibilities:
- Reconcile vendor invoices and statements, research and correct discrepancies and maintained 1099.
- Receive price quotes, negotiate price for large buy outs and make contract purchases for over 30 daily orders.
- Reviewed and Audit over 500 invoices for payment biweekly and assist in month end closing.
- Review and report deficiencies with the Chief Controller and provide alternative solutions to problems.
- Developed forecasting tools and dashboards to analyze revenue variance, business pipeline and industry trends.
- Prepared weekly Job Cost Report in spreadsheet and identified risks associated with projects, contract approvals and other client accounting issues.
- Presented "what if" scenarios for budget assumptions and forecasting strategies.
- Record, classify, and summarize financial transactions and events in accordance with generally accepted accounting principles.
- Prepared over 100 Federal and Multi-State tax returns for individuals and maintained client.
- Performed office duties including, record-keeping, filing, mailings and telephone.
- Assisted the CEO in opening corporations and LLC and filed sales tax for businesses.
- Update and maintain accounting journals, ledgers and other records detailing financial business transactions.
- Updated Monthly payroll worksheets and Process payroll entries.
- Prepared Account Receivables Aging Report on Spreadsheet for businesses.
- Assisted in Preparing Balance Sheet, P/L statements and bank reconciliation.