We provide IT Staff Augmentation Services!

Senior Consultant /lead Sap Fico​ Resume

0/5 (Submit Your Rating)

Detroit, MI

SUMMARY

  • A result driven Senior Information Technology Professional wif 14 years’ experience in SAP configuration, Integration, and testing experience wif an emphasis on FICO module. Strong track record as SAP FICO Lead, handled Teams of 7 - 12 people, also offshore - onsite model. Solid back ground wif 5 years’ experience in Accounting and as Audit Professional.
  • Well-versed expertise in P2P, deep knowledge in AP, MM, Design and implementation of P2P Processes. Highly accomplished, able to design and execute TEMPeffective business change & transformation initiatives.
  • Reputation for integrity, high energy, analytical ability and creating positive outcomes. Outstanding leadership and motivational abilities complement exceptional communication skills.Project Planning
  • Configuration / Implementation•AP Payment Process VERTEX, Treasury • P2P, OTC, FI - MM, SD • GAAP and IFRS • SAP GL • FSCM/ FICA / FSCD Fixed Assets, IM PS Funds Mgmt. Public Sector • SAP Interfaces, EDI / IDOCS, EBS, Lock Box Interfaces, Banking Interfaces, Payment files, PMW
  • RAR - Revenue Account Recognition, CO - COPA, PC, Material Ledger, S4 HANA. SAP / IT Project Management • Training / Development, Business Analysis

PROFESSIONAL EXPERIENCE

Confidential, Detroit MI

SENIOR CONSULTANT /LEAD SAP FICO

Responsibilities:

  • Configuration of US taxes using SAP (tax jurisdiction codes & condition records) in a manufacturing (Auto) Industry. Process design, configuration and testing.
  • Supporting CO Processes in Manufacturing environment - Product costing and settling Internal Orders for product manufacturing process.
  • Tax related reports - writing functional specs - testing sales destination report, income tax report.
  • Cut over activities in the production systems
  • Changes in SD Pricing Procedure - related wif sales tax configuration
  • End to End process testing for procurement of tools and machinery at the various plant sites
  • Integration testing - end to end scenarios working wif Supply chain, SD and Procurement teams for
  • PO based Invoices, Scheduling Agreements, Tax related testing for complex scenarios
  • Master data updated for Customer, Vendor, GL Master tax category.
  • Functional specs and testing for storing tax exemption certificates using Saperion (Archiving tools) in the Customer master.
  • Updated Info records wif tax codes to automate the tax code default at the PO level
  • Configuring Plants wif tax indicators
  • Configuration of Plants wif tax jurisdiction codes
  • Tested automatic verification and posting of PO based Invoices and Direct AP invoices and taxes via Cockpit - Read soft application
  • Mapping Visio flows for purchasing and sales tax and documenting P2P and OTC processes including tax postings.

Confidential, NJ

SAP FICO Lead

Technology environment: Confidential Design, SAP FI-MM Configuration SAP workflow, Tax, troubleshooting

Responsibilities

  • Analyzed, design and configured workflow solution for Asian International subsidiaries of US retail company. Testing of workflow, transporting HR objects from Dev to Quality, Prod clients. Worked wif Z tables, FI -MM Configuration Purchase group, release groups and release codes as per the workflow design. Going Live.
  • Worked in migrating wifholding tax to external wifholding taxes for US company, and 1099 configuration
  • Wrote functional specs for several reports related wif workflow, custom GR/IR (MR11), vendor spend report AP Aging report. worked on troubleshooting issues in FI.
  • Worked in CO configuration for Asian co codes - Cost Center, Internal Orders and Profit Centers Master data set ups. Configured COPA segments for Asian companies for reporting, reporting. Settlement of cost cycles and internal order, internal orders used for trade promotion activities. Profit center Accounting activated for Asian companies.
  • Feasibility studies for implementing S4 (Simple Finance)

Confidential, Chicago, IL

SAP FICO Lead

Responsibilities:

  • Wrote Functional specs for interfacing wif Non SAP system Trade Pro wif SAP, working wif ABAP programmer for development of the program and Testing.
  • Configured the areas of automatic account determination (SD - Shipment cost posting), FI - SD revenue account determination.
  • Updated master data in COPA for new conditions and value, testing. Reorganized estimate cost for Materials (Product costing) for Integration testing.
  • Worked in Bank Communication Management (BCM), areas in General Settings, cross payment run payment media, payment grouping, release strategy - rules for Automatic payment, release steps.
  • Configuration in the areas of Material Ledger for activating actual costs for the materials in some of the plants and doing all the configuration related wif Price.
  • FSCM Configuration - Collections Management, configuration in basic rules for collection strategies,
  • collection rules, collection segments, configuring RMS ID, case types, no ranges, Automatic status change, status for dispute management integration, integration wif AR, activating SAP Collections management, activating distribution of data in collections management, BADI for mapping master data, settings for promise to pay.
  • FSCM Configuration - Dispute Management, configuring RMS ID for dispute case processing, define case types, create status profile, configure Actions, create profile for case search, define processor for dispute cases, activate dispute management Integration wif AR Accounting, configure Automatic write-off of dispute cases.
  • BPC configuration, supported BPC configuration and implementation in the areas of New GL.
  • Tax implementation for AP sales tax, Use tax and 1099 using Sabrix. Configuration in Sabrix for US company codes, configuring link between ECC and Sabrix software - RFC connection, logical configuration, configuring tax codes in SAP, building logic matrix in Sabrix for different products, reduced tax rate, exempt, organizations.

Confidential, Seattle, WA

SAP Solution Architect /FI-MM, Tax.CO, FSCM

Responsibilities:

  • Actively worked in the areas of Brazil Tax. Functional Specs - MM/FI Interco doc report. Configured /Tested of PO /Tax process for Brazil and Inter Co. Margin.
  • Configured FI-MM processes, LIV /AP postings. Formulated UAT Test Scripts for Markets (Products) & Services/Repairs processes.
  • Lease Accounting - Master Data - Assigning interest calculation method to company code and Process configuration, Interest calculation, value transfer, value determination using determination method. Configuration for Production setup, reports.
  • Configuration in the areas of COPA and Material Ledger for the plants.
  • Configuration in the area of Cost Center Accounting, Cost Cycles and Profit Center Accounting related wif Plants mapped as segments.
  • FSCM - Processes mapping in the areas of AR, collections and disputes. Presenting the confirmed processes in stake holders meeting for approval.
  • Vertex tax configuration for AP, AR and logistics (MM and SD configurations). Process mapping was done for physical and logical connections, Master data customer, vendor, cost centers. Configurations for non taxable transactions, tax codes and account keys, activating Sabrix software, doc no range, invoice posting for all scenarios for normal and exempted co codes, products and vendors for AP, AR sales taxes, Use taxes were carried out and testing done.
  • Treasury - Configured Transaction Manager in the areas of Money market, Fixed terms deposits, securities bond purchase and foreign exchange derivatives.

Confidential

SAP Data Migration FI Lead

Technology environment: New GL - Treasury Interface Using Pi (Middle Ware) Technology

Responsibilities

  • Project 1 - Designed & Built Interface between Treasury System Reval & New GL
  • Interface building from Revel Treasury System to New GL (SAP) - Designing & mapping, working wif PI Analyst. Configuration in SAP FI required for Interface.
  • Project 2 - P2P/AP/ Payments / Payment File Interface Based on ISO2002 to Wells Fargo Bank
  • Configured the Automatic transmission of Remittance Advice via email when Automatic Payment Program is executed.
  • Project 3 - Automating intercompany billing statement transmission to various business units based on location.
  • Design, configuration and testing, intercompany billing statement and payroll invoices transmission to various business units automatically via email.
  • Bank communication Management (BCM), release strategy, rules for automatic payments and general settings.
  • Configured core treasury, Cash and Liquidity flows, configured money market, fixed term deposits, securities bond purchase and foreign exchange derivatives using the transaction manager in SAP for US companies. Different product types like Fixed deposits external /internal, bonds were setup in Master data. Securities accounts was setup for the brokerage firms, Business partners were setup. Month end activities and valuation of open contract was configured. Securities integration wif cash management was configured.

Confidential, Parsippany NJ

FI Solution Architect

Responsibilities:

  • Project 1 - AMEX Bank Payment card (P Card) Project Worked from Blue print to Go Live -
  • Worked in project plan creation, functional analysis, blue print mapping, configuration in - AP/payment medium workbench, sending files to AMEX using SFTP, testing the end to end process from Payment file creation in SAP to sending files to AMEX using Autosys batch set up to schedule the file project went live successfully and is deployment now.
  • Project 2 - New GL Black Line Project - Data Extraction for Black Line
  • Reconciliation of financial statements between corporate & subsidiary - functional analysis, functional specifications, file layout, testing of the program which is created to pull the data from new gl tables, going live & post go live support.
  • Project 3 - Implementing US Taxes Using One Source tax for AP, Vertex configuration for Indirect taxes VAT determination including Tax code qualifiers, mapping of product codes to products and customer rules setup for the products, field mapping and route configuration. Configuring target tax codes for output and input taxes and deferred output and input tax codes
  • Project 4 - Configuration of Lease Accounting, configuration in areas of Basic Settings like Assigning Accounting principles to co code, configuring co code grouping key, assigning interest calculation method to co code, specifying dates for postings, configuration for Settings for value transfer, transferring values from condition types, configuring value determination using substitution. configuring Mandatory settings in customizing for Lease Accounting.

Confidential

FI Lead

Technology environment: Global Roll out Project - Global Template - SAP FI /Vertex Implementation North America and Canada

Responsibilities:

  • TEMPEffectively designed & configured source symbols and activating cash management for co code. Designed planning levels, planning types for cash & liquidity forecasting.
  • Constructed planning groups for Sub ledgers. Customized grouping structures for cash & liquidity forecasting. Designing controls for Cash Management. Integrating IHC wif Cash Management.
  • Configured and uploaded Lockbox file (Bank file) using BAI2 format. Setting up &configuration of IN House Cash (IHC). Defined Bank Area and Bank Accounts for IHC.
  • Worked on implementing CONCUR interface wif SAP using IDOC / wrote Functional specs for the process and tested when file is sent from SAP to CONCURE to settle the travel expenses.
  • Configured Vertex for Purchase tax - AP tax, Use tax for US and Canada. - Vertex configuration and testing, documentation of the processes
  • Worked in DART for Tax - Electronic records in ECC, DART setup to extract data from SAP tables in response to IRS queries, text file was created and sent to IRS. DART query was used to extract both Master Data and Transactional data. DART implementation was done after Tax Analysis in compliance wif Revenue Procedure 98-25 so that DART extract picks all the necessary fields required. RRLA was signed wif IRS to assure that all the required fields were picked up. Technical Implementation of DART included - Extracting Configuration & testing, after configuration was completed all the data was transferred to DART tables. DART extracts were saved in SAP work directory as per path specified in configuration.
  • Configured Revenue Accounting, also worked in RAR (Revenue Accounting & reporting) configuration. Deferred revenue is recognized is activated /VF44.GL Accts setup for Deferred/Unbilled revenue item categories activated, Services based rev recog., Account determination maintained (VKOA), Statements and detailed transaction reports generated.

Confidential

SAP FICO data Migration Lead, FSCM Configuration, Fixed Assets

Responsibilities:

  • Executed data analysis, data cleansing &harmonization and data validation, leading the team of client business managers, technical consultants, creating project plan and achieving the mile stones, conducting and organizing meetings & presentations, interacting wif users and handling the overall project in different phases of design.
  • Opened balances from the legacy system were brought for GL, AR, AP &fixed assets, treasury using the IDOCS technology and INFORMATICA was used as the middleware.
  • Data Migration to fixed assets required meeting the different depreciation areas requirements as per the accounting standards of US and Mexico. In Mexico their is no bar in the capitalization of the Investment but in US only amounts above USD 5000 are considered for capitalization, also Mexico maintains depreciation areas in USD, Pesos and Pesos converted in USD.
  • Tested extract file from JDE in SAP and analyzing the results through IDOCS. Analyzing the results in SAP via reports and confirming that all the records extracting from JDE were successfully migrated to SAP.
  • FSCM configuration - Collection and dispute Management - configured all the important processes in collection and dispute modules and activated integration wif AR Accounting. Defining collection rules, collection segments, resubmission processes, status for dispute cases to be collected, BADI mapping of Master data, settings for Promise to pay, activating standard implementation of mapping in AR, dispute case processing and configuring case types and profiles - function, text and status.
  • FSCM - In house cash processes, configuring IHC wifin corporate groups and subsidiaries, Automate Intra group payments and payment made to external partners, cross bank area postings, configuring business area specific configurations, configuring special periodic activities.

Confidential, Hartford, CT

FICO IS Utility Lead/Manager

Responsibilities:

  • Planned revenue /Cost and Actual revenue /Cost upload in FI and PS. Posted Grant /Loans and Bonds in GL and PS. Reclassifying Bonds & Loans. Resolved issues related wif previous year PS postings. Settling Cost based Projects to AUC and Fixed Assets.
  • Efficiently worked wif Financial Controllers to present the financial statements as per GAAP and GASPY32 (Public Sector Accounting requirements) and also as per FERC reporting - FERC indicators assigned to WBS elements and Cost Elements and GL Accounts linked wif these WBS elements were automatically assigned the FERC indicator by the system SAP GL Accounts relevant for FERC calculation. FERC module was executed to get FERC reporting.
  • Controlled in areas like internal orders, cost center accounting. Allocation of costs using the Allocation Cycles. Tracking expenses using internal orders.
  • Operated in Budget control System (BCS) - areas of cover eligibility and Budget entry for multiple years and / or multiple budget categories. Execute Automated Budget postings.
  • Lease Accounting and low value Assets - Master data setups in Lease Accounting and configuration of Lease Accounting processes like value determination, value transfer from contract items, value determination using substitution.
  • FI-CA configuration in co code for contract accounts, contract accounts - categories, contract acct business partner’s configuration, account determination for contract accounts - domestic/foreign, check management, business transactions in payments - configuring bank clearing accounts for payments/bank deposits/electronic bank t/f, configuring interest calculation and Dunning procedures. Integration between FICA and GL, cash management.
  • Funds management configurations - Commitment items, Funds center and Funds. Multiple Budget ledger were configured using Budget categories. BCS - Budgetary was set up and activated, Budget data /categories configured. Actual /Commitment update setup, Ear marked funds configuration setup to block funds for water related projects (non-revenue projects). AVC - Availability control configured - activity groups, availability control ledger configured.

Confidential, California

SAP FICO Lead /Architect

Responsibilities:

  • Assigned characteristics as a criterion for document splitting – profit centers, business area, segment. Divided the system of line items – clearing of vendor/customer line items, clearing of open items, foreign currency valuations.
  • Finalized the organization structure to include domestic and international operations to map the existing business model as per the best business practices. Documented important Master data activities like mapping existing payment terms in SAP,
  • Mapped 18 stores owned by one of the group companies as profit centers. Recognized the cost center hierarchy and proposing the cost centers as per the business need
  • Acknowledged the profit centers hierarchy and proposing the Organizational Structure from the stand point of Profit center which included the domestic and International operations.

Confidential, LA, California

SAP Taxes Lead/Architect, SAP FICO

Responsibilities:

  • Implemented payment cycle (payment program), which involved designing interfaces wif 3rd party service providers. PO and Non PO based Invoices, sending a file to service provider.
  • Tax process implementation includes US -Tax codes, external Tax ware configuration (Vertex), Sales Tax and Use Tax configuration and processing.
  • Interfaced programs – design of the functional test, testing – Invoice sent from SAP to Invoice works (3rd party service provider), Invoices posted in SAP from Sun Guard (service provider)
  • Implemented CANADA taxes in Vertex.

Confidential

SAP FI CO Lead

Technology environment: ECCS, New GL Configuration, Support SAPECC 6.0, 4.6C, 4.6D

Responsibilities:

  • Approved data tasks like balance carry forward, currency translation, Interunit elimination. Carried out consolidation tasks like consolidation of Investments, elimination of Profit and Loss on sale of fixed Assets to subsidiary
  • Assigned character tics as a criterion for document splitting – profit centers, business area, segment.
  • Divided the system of line items – clearing of vendor/customer line items, clearing of open items, foreign currency valuations.

Confidential

SAP Lead

Responsibilities:

  • SAP Interfaces: Huron Interface sends the telecom invoices to SAP via Idoc and payments are processed in SAP on the basis of the Invoices posted by the IDOCS, once the payment is made Outbound IDOCS (820) are generated and sent to the Bank of America, Vendor Portal and Huron System, outbound IDOCS contains the detailed information about the payment documents.
  • Designed and developed functional Specs. Designed would involve filtering the telecom invoices and posting the inbound IDOCS 810 as Non PO Invoices.
  • Executed testing and user training of the complete process where the inbound 810 hits the SAP and IDOCS are processed and posted in SAP FI (as non PO Utility Invoices), making the payments using the Automatic payment program and SAP generating the 820 outbound IDOCS to Bank of America /Huron Sub system /Vendor Portal.
  • Worked on Aging report for AR (Accounts Receivable). Aging reports has been developed as Z Programs wif the Custom table in the background where data is updated every night. Aging of receivables is done on the basis of Bill to and Payers.

Confidential, Jacksonville, Florida

FICO Project Lead/Architect

Responsibilities:

  • SAP workflow configured for AP Payment New Payment methods covered underflow like ACH, Sensitive ACH, Sensitive Check and Sensitive wire.
  • Master changes and setups in GL, Vendors and company org structure – changes in Account groups, GL Account MD changes in Account groups.
  • Worked in SAP Migration activities related to FICO Modules, data conversion activities involved Master data conversions in AP - Invoices before going live in the new system, developing ABAP queries to halp the AP team.
  • Worked wif Bank to streamline the process of sending the Payment file to the Bank as the client would outsource the printing of checks and all payments would be made by bank on the behalf of the client.
  • Configured the Electronic Bank Statement reconciliation to process the bank statement file (BAI – format) sent by Bank of America. Supported Lock Box issues inbound process Sales Order Process involving EDI /IDOC, Tax configuration for European country and worked in Credit Management area in AR.

Confidential, Garden City, NY

SAP FICO Lead Consultant

Technology environment: SAP 4.6C to SAP ECC 6.0 upgrade, New GL Configuration

Responsibilities:

  • Adjustments done to the foreign currency transactions to bring them up to US GAAP were undertaken. FASB 52, foreign currency revaluations.
  • Tested FI – MM and FI – SD integrations - Changes were made in the FI – MM Set ups for the better reporting purposes. Executing the migration cockpit, migration of existing data using the cockpit.
  • Unit & Integration testing done in GL, AP, MM, FA, PS and CO modules covering various business scenarios in development and Quality Clients using the Test Scripts.
  • Important areas in P2P cycle, GR/IR – correction, LIV – 3 ways matching, LIV wif freight cost included in the Invoice, in a separate invoice, Goods return, reverse Goods receipts.
  • Vertex configuration for SAP AP - Sales tax, Use tax, 1099, 1042. Testing, user training and documentation. Taxes configuration in SAP and setup parameters for external tax calculation.

Confidential

SAP FICO Project Lead /Manager

Responsibilities:

  • Implemented the Accounts Payable, Budgeting from CO Side and General Ledger modules. For the newly acquired Chubb Company (UTFS) using the Global Template, the standard FI – Processes were extended to the Chubb company as well. their were certain changes made in the standard processes implemented as per the Global Template to meet the Local Country requirements.
  • Account payable involved all the Master Data for vendor’s creation, automated recurring entry process, Automatic payment configuration for copayments and Interco payments, cash discount configuration, using the payment Configured /Supported Internal Orders, Assessment and Distribution Processes in CO module.

Confidential

SAP FI

Responsibilities:

  • Supported/Configured ECCS – Global Consolidation module for the UTC group companies, defining currencies, defining versions, defining Ledgers, maintaining Hierarchies. Working on enhancement requests for any changes required in customizations and configurations. Working wif the ABAP Team and Testing any Customization changes done and also any new reports created.
  • Configured, Supported COPA – Costing based operating concern. Configured characteristics, value fields, operating concerns (costing based.
  • Implemented the US Taxes 1099 process, leading the project and coordinating wif AP, Tax and IT team and filling the electronic submissions of 1099. Trained and documented the process Configuration of Use tax, Consumption tax, output tax.

Confidential

SAP FI Senior Consultant

Responsibilities:

  • Responsible for bringing up the FI CO company code configurations, GL account re-engineering, creation of Country chart of account and linking the local GL accounts wif the group Chart of account, configuring the Financial Statement VERSION as per the respective country requirement.
  • Involved setting up correct GL Heads, clubbing of some existing GL heads or classifying new GL Heads as per the business and reporting requirement.
  • Configuration for their tax procedures and preparation and was involved in the design, configuration and post live support for 3 Latin American countries for which roll out was done. Tax codes configured were Output Taxes.

Confidential

FI-MM /CO SAP IS Retail Consultant

Responsibilities:

  • 80% of goods in shopping malls are rented so memorandum accounts were maintained to keep track of them. Stock Accounts were maintained only for the physical stock owned by the client.
  • Cost Centers were structured in a way that cost could be tracked up to the individual goods, Divisions were mapped to the Profit centers, and sections were mapped to the cost center groups and cost centers.
  • Designed & tested functional specification for consignment settlement program for both inventories managed consignment & non-inventory managed consignment stock. New program could be executed wifout doing MM month closing and could be run frequently to settle the payments due to the client.
  • Rental sales is for the Kiosks and Shops which were rented to the Suppliers and they were charged only the Minimum Rent and certain portion of the sales as the commission if sales were above certain volume.

We'd love your feedback!