We provide IT Staff Augmentation Services!

Sap Fico / Treasury Consultant Resume

3.00/5 (Submit Your Rating)

NJ

SUMMARY

  • SAP FICO and Treasury Consultant with over Eight plus years of IT experience.
  • In depth understanding of business processes relating to SAP Finance and Controlling.
  • Involved in Full Life Cycle Implementation, Rollout, Support and Upgrade projects.
  • Worked on Three Full Life Cycle Implementations using SAP ASAP methodology.
  • Active role in different phases of implementation from gathering client requirements, conducting GAP Analysis, preparing Business Blue Print document, Configuration, Unit Testing, User Training and Production Support.
  • Very good understanding of business processes across different industry verticals like chemical, retail, pharmaceuticals, health care, manufacturing, and water treatment.
  • Strong knowledge in Financial Accounting, Managerial Accounting and Cost Accounting concepts - MBA, Finance.
  • Hands on experience in configuration of FI module, which includes General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Taxation (sales, purchase, VAT and withholding), Asset Accounting, Treasury, Global Payment System (Hanse Orga), Bank Accounting and Special Purpose Ledger.
  • Worked extensively on Payment Factory and Account Statements of Hanse Orga- Global Payment System tool (Treasury).
  • In Treasury-worked on Cash Management, Transaction Management-Money Market, Forex Market, Derivatives, Credit Risk Analyzer (CRA), Market Risk Analyzer (MRA) and EBS.
  • Extensive experience in configuration of CO module, which includes Cost Element Accounting (CEA), Cost Centre Accounting (CCA), Assessment & Distribution, Internal Orders, Profit Centre Accounting (PCA), Product Costing, Profitability Analysis (CO-PA) and Consolidation.
  • Experience in integrating FI and CO modules with logistics modules SD and MM.
  • Knowledge of multi currency and parallel currency evaluation.
  • Worked on different aspects of FI transactions like Inter Company Transactions, Reconciliation Accounts, Automatic Payment Program, Partial & Residual Payments, House Banks, Lockbox, Positive payment and Dunning.
  • Experience in migration of GL to New GL.
  • Experience in configuration of Bank Accounting and Electronic Bank Statement (EBS).
  • Knowledge of US GAAP (Generally Accepted Accounting Principles) and SOX (Sarbanes Oxley Act).
  • Worked on HP Quality Centre (HPQC) for test planning, requirements management, defect reporting and tracking.
  • Experience on preparation of test plan, test procedures, manual and automation test scenarios, test scripts, report defects.
  • Experience in functional testing and assisting users in User Acceptance Testing (UAT).
  • Experience in using tools like Report Painter and Report Writer.
  • Experience in master data upload using LSMW.
  • Provided training for users on various processes, prepared training documents and user manuals.
  • Excellent analytical skills in understanding the business process.
  • Very good organizational, interpersonal, teamwork and communication skills with proven ability to interact across multiple levels of organization.
  • Demonstrated strong technical and leadership skills to deliver projects efficiently.

TECHNICAL SKILLS

ERP Packages: SAP R/3 4.6C, 4.7, ECC 6.0 EHP 6

Tools: Hanse-Orga, gAHD-Global Advance Helpdesk), Global Sap Knowledge Center)

Reporting Tools: Report Painter, Report Writer, LSMW

Testing Tools: HP Quality Centre, Test Director, Load Runner, Win Runner

Documentation: MS Office (MS Word, MS Excel, MS Power Point, MS Project, MS Visio)

Methodologies: Accelerated SAP (ASAP), UML, SDLC, Business process restructuring

PROFESSIONAL EXPERIENCE

Confidential, NJ

SAP FICO / Treasury Consultant

Responsibilities:

  • Problem resolution as part of support- analyzing the tickets which included identification of issue, determining the root cause of issue and suggesting the solution to users based on root cause analysis done.
  • Prioritizing issues based on level of severity and priority levels and classified them as problem request, work requests and change requests.
  • Handling assigned tickets based on level of severity and making sure that the service line agreement is not breached.
  • Analyzing and providing quick solutions to the problems raised by FI, CO, and Treasury users.
  • Interacting with users when necessary to solve the problems.
  • Working with technical team (ABAP) to analyze the root cause of the issues like batch job failures, to analyze the functionality of the custom programs.
  • Tickets are mainly based on General Ledger (GL), Accounts Payable (AP), Accounts Receivables (AR), Treasury, Cost Center Accounting (CCA), Internal Orders, FI-SD and FI-MM integration.
  • Supporting users when running F110-Automatic Payment Program (APP) when customer / vendor is not getting picked in the proposal, checking if the IDocs are generated for the payment program. Analyzing the root cause for the issue and suggesting the solutions or configuration changes when necessary.
  • Discussing the effects of changing configuration to the system and suggesting viable solution to users.
  • Treasury-Monitoring the Positive Pay File batch job and pushing the files manually to the bank through GPS system (Hanse-Orga tool) when there is a failure of the job.
  • Treasury- Analyzing the failed jobs related to payment, lockbox, positive pay file in Global Payment System (GPS) and sending the journal records which are in pending to the bank.
  • Analyzing the root cause and sending the file to bank / required system when file is stuck in Global Payment System (Bank Interface) or SAP system.
  • Solving the issues related to bank statements (BAI2 /SWIFT MT940) in Global Payment System (Bank Interface).
  • Working on analyzing why NON-SEPA payments rejected by the bank.
  • Assisting treasury users when needed to change the bank master data.
  • Solving the issues related to Electronic Bank Statement (EBS) after uploading into the SAP system.
  • Treasury- Defining Lockbox reason codes for new company code.
  • Configured missing configuration settings in FBZP when needed / requested by user which involves creating and releasing transports in the development system-includes defining house banks, account ids, adding currencies,etc.
  • In Asset Accounting- assisting users in system behavior in picking the value date, capitalization date for asset.
  • Providing remittance file, when requested by HR team.
  • Supporting users on month end and year end closing activities.
  • Assisting the users in GL transactions like fast data entry, document reset, clearing, splitting, holding and parking.
  • Supporting users to get the required reports from SAP ECC system and assisting them to change the layout of the COPA report.
  • Assisting users in matching FI and COPA document’s amount.
  • Working on changing the Cost Element Master data to allow or block the postings to.
  • Assisting users in assignment of cost elements to value categories, activity types for settlement of plant maintenance orders.
  • Checking validation and substitution rules in analyzing an issue related to automatic account determination.
  • Working on finding the root cause for system not releasing the accounting document to FI from SD.
  • Working with SD and MM team when needed to solve the issues related to condition type and movement types.
  • Providing functional test of the changes built in development system.
  • Assisting users in User Acceptance Testing (UAT) when approval is needed by business to move the changes to production.

Confidential, Sunnyvale, CA

SAP FICO / Treasury Consultant

Responsibilities:

  • Responsible for business process analysis, business requirements gathering, testing, end-user training and production support.
  • Translated business requirements into SAP Functional and Configuration requirements.
  • Involved in preparation of business blue print documents (ASAP methodology)-interacted with team for preparation of Q&Adb.
  • Involved in functional specification design and interacted with technical team for different RICEFW (reports, interfaces, conversion, enhancements, forms, workflows) objects AR Tracking report.
  • Responsible for configuration of General Ledger (GL)- document number ranges, posting period variants, field status variants, fiscal year variant, tolerance groups, reversal of documents, opening and closing of posting periods, field status groups, document types, posting keys etc.
  • In Accounts Receivables (AR)-configured customer account groups, number ranges, tolerance groups, credit control area, customer credit limits, credit limit groups, incoming payments, dunning, AR information system in Account Receivables (AR).
  • Configured system to handle various scenarios in like down payments, discounts, credit memos, customer who is also vendor, etc.
  • In Accounts Payable (AP)- configured vendor groups, number ranges, tolerance limits, payment terms, payment methods and maintained initial settings for recurring entries in accounts payable (AP).
  • Configured Automatic Payment Program for payments to vendors; check lots, void & reissue of checks, online cash and blockage of payments for certain vendors.
  • Identified one time vendors and customers and defined customized screen layouts for them.
  • In FI-treasury, configured house banks with multiple bank accounts, assigned check lots, and defined void reason codes, automatic payment program (APP) for outgoing payments.
  • Configured different payment methods like ACH payments, wire transfer and checks to multiple banks in world through SWIFT.
  • In Banking- designed, configured and tested AP and treasury payments, electronic bank statement and lockbox.
  • Worked on configuration of house banks, available amounts, value dates, Bank accounts, bank sub accounts, specified the document types, etc, for payments.
  • Using In-House Cash (IHC) module designed and configured foreign payments strategy which is executed by the parent company on behalf of its subsidiaries.
  • Involved in setting up centralized treasury operation and global cash pooling using In-House Cash (IHC).
  • Designed, configured and tested transaction manager-money market, securities, forex and derivatives.
  • Designed, configured and tested AP and treasury payments and electronic bank statement (EBS).
  • Configured lockbox programs for Accounts Receivables in BAI2 format.
  • In Cost Element Accounting, created primary & secondary cost elements, cost element groups, maintained cost element attributes, costing sheet, assigned cost elements to various cost centers and maintaining accounts for automatic reconciliation posting.
  • In Cost Center Accounting, created cost centers, cost center standard hierarchy, statistical key figures, master data groups, assessments, distributions, allocations using cycle-segment method for periodic reposting and planning them on different cost centers, attaching work centers to cost centers, planned as well as actual.
  • Worked on integration of FICO with SD and MM modules.
  • Designed and developed test scripts for manual testing of FI modules like Accounts Payable (AP), Accounts Receivable (AR), Treasury and CO-CCA.
  • Involved in preparation of end user documentation and trained end users majorly on GL, AP and AR.
  • Problem resolution as part of support-analyzed the tickets which included identification of issue, determining the root cause of issue and issue resolution.
  • Helped users in handling partial and residual payments.
  • Prioritized issues based on level of severity and priority levels and classified them as problem request, service requests and change requests.

Confidential, Columbus, Ohio

SAP FICO/Treasury Consultant

Responsibilities:

  • Designed the business processes using ASAP implementation methodology, collected and analyzed users business requirements, identified and defined areas for improvements, prepared specifications for development, configured, troubleshoot and supported the system users.
  • Gathered requirements on current company’s legacy systems, business processes and activities. Performed GAP analysis and actively participated in designing blueprints.
  • In Blue Print phase- conducted interviews-Q&Adb, interacted with managers of various departments to gather the business system requirements and prepared a Business Process Master List (BPML).
  • Designed functional specifications, configuration documents, training and user manuals.
  • Worked on various RICEFW (reports, interfaces, conversion, enhancements, forms, workflows) objects including design and development of various complex interfaces and conversion objects.
  • In General Ledger (GL)- configured document number ranges, posting period variants, tolerance groups, reversal of documents, opening and closing of posting periods, field status groups, document types, posting keys etc.
  • In Accounts Receivables (AR)-configured customer account groups, number ranges, tolerance groups, incoming payments, defined cash discounts based upon payment terms, reason codes in customer accounts, credit control areas, and credit limits.
  • In Accounts Payable- defined vendor account groups and screen layouts, defined number ranges for vendor accounts and assigned these number ranges to vendor account groups.
  • Configured Automatic Payment Program for payments to vendors; check lots, void & reissue of checks, online cash and blockage of payments for certain vendors.
  • Configured payment program- house banks, payment methods, bank chains, company code specification, alternative payee, bank selection, etc.
  • In Treasury module involved in inbound and outbound payment processing-ACH, domestic wire and cross border wires.
  • Using In-House Cash (IHC) module designed and configured foreign payments strategy which is executed by the parent company on behalf of its subsidiaries.
  • Designed, configured and tested transaction manager-money market, securities, forex and derivatives.
  • Maintained Lockbox configuration with BAI2 format, cash management and planning levels in treasury and EBS.
  • Worked on Treasury Bank integration.
  • Involved in configuration of sales and purchase tax- defined tax procedure, tax codes, and tax accounts.
  • Involved in migrating customer and vendor master data through LSMW.
  • Involved in configuration of IDoc interfaces for maximum reuse.
  • In controlling, maintained controlling area, created number ranges, maintained versions.
  • In Profit Center Accounting (PCA)-created standard hierarchy, profit centers, dummy profit center, defined document types, number range assignment, PCA planning parameters.
  • In Internal Orders- defined internal orders for different order types, planning profile, settlement profile, settlement rules and month end settlements to various cost and profit centers.
  • Involved in integration FICO module with SD and MM.
  • Developed various test scripts for various transaction scenarios in FI, CO, SD and MM modules.
  • Involved in unit testing and integration testing.
  • Used HP Quality Centre (HPQC) for defect tracking.
  • Provided user training on various processes, majorly on CO-PA, Internal Orders and basic navigation in SAP system.
  • Prepared configuration and test results documents for FI and CO.
  • Responsible for creation of customized reports.

Confidential, Greensboro, NC

SAP FICO/Treasury Consultant

Responsibilities:

  • Studied AS-IS business process of client with the help of Q&A database.
  • Prepared AS-IS model of the system and problems & inconsistencies in the existing system are identified using GAP Analysis.
  • Worked with ABAP team in preparing functional specification document (RICEFW)
  • Organizational structure and business processes are studied.
  • Configured organizational structure by creating company code, chart of accounts and GL master data.
  • Screen layouts for GL, AR, AP data entry and report displays are customized.
  • Configured customer groups and customer master data.
  • Involved in configuration of different payment methods like wire payments, check lots and defined void reason codes.
  • Involved in Treasury implementations-forex and money market trading, securities management, planning levels including analysis, design and testing of Treasury solution.
  • Designed and configured Electronic Bank Statement-Treasury.
  • Documented Treasury configuration, and trained end users on treasury to resolve issues.
  • Involved in implementing In-House Cash for foreign payments on behalf of subsidiary company codes.
  • Designed, configured and tested liquidity forecast, lockbox, exchange rates, transaction manager (forex, derivatives), credit risk analyzer and market risk analyzer.
  • Risk categories are defined and credit limits for customers are specified.
  • Generated reports for various customer credit management.
  • Defined interest calculation types, reason codes and assigned them to GL accounts.
  • Configured automatic interest calculations on line items.
  • Configured Inter Company Transactions for finance and revenue processes.
  • Designed and configured Electronic Bank Statement.
  • Configured New GL and Document Splitting.
  • Involved in migration from GL to New GL.
  • In Asset Accounting, copied reference chart of depreciation, assigned chart of depreciation, account determination, created screen layout rules, defined number range interval, and defined asset classes.
  • Responsible for integration of asset accounting with GL.
  • Defined screen layouts for asset master data and asset depreciation areas.
  • Involved in configuration of depreciation by defining multi level method key and maintaining depreciation areas.
  • Involved in creation of asset master record.
  • Worked on Order to Cash and Procure to Pay in association with SD and MM teams respectively.
  • Existing system is studied and gaps are identified before going for the configuration.
  • Maintained Controlling Area settings.
  • Configured settings for controlling area and operating concerns.
  • In Profitability Analysis configured both costing based CO-PA.
  • Maintained versions in profitability analysis.
  • Worked on designing standard hierarchy for Profit Centre Accounting (PCA) and Cost Centre Accounting (CCA) to fulfill the reporting requirements.
  • Restructured Profit Centre Hierarchy and Profit Centers.
  • Profit centre account groups are created.
  • Restructured assignments to profit centers.
  • Planning framework is set and worked on planning layout.
  • Configured internal orders by maintaining order types, screen layouts, order groups, planning profile, allocation structure and settlement profiles.
  • Mentored users in CO-PA.

Confidential, Port Washington, NY

SAP FICO Consultant

Responsibilities:

  • Responsible for configuration and testing of Finance and Controlling modules.
  • All processes, user procedures and system requirements which need to be extended to new company code are reviewed and analyzed.
  • Involved in configuration of company code, fiscal year variant, posting period variant, field status variant, document types, number ranges, tolerance groups and assigned them to company code.
  • Extended global chart of accounts and corresponding assignments, account groups, field status variants.
  • Defined reference accounts, sample accounts and account assignment models.
  • Part of master data maintenance, special purpose ledgers, creating house banks, assigning bank accounts to house banks, bank reconciliation statements, and automatic payment program.
  • In FI Treasury-configured different forms of payments like-ACH, wires and EFT.
  • Involved in Asset Accounting by creating chart of depreciation, screen layout rules, asset classes, depreciation areas and depreciation keys.
  • Integrated asset accounting with general ledger after configuring asset master data, depreciation areas and depreciation keys.
  • Involved in maintaining controlling area settings.
  • Involved in integration testing of the accounting modules with SD and MM modules.
  • Created testing strategies for unit testing and regression testing.
  • Involved in testing of document postings, document reversals, invoices and payments.
  • Tested house banks, bank accounts and posting rules for automatic assignments.
  • Verified and validated that tests are conducted and documented according to the standards approved by management.
  • Involved in testing the functionality and usability of the system from end user perspective.
  • Assisted training team in development of training manual and documenting the daily activities.

Confidential, Canonsburg, PA

SAP FICO Consultant / Tester

Responsibilities:

  • Handled assigned tickets based on level of severity.
  • Analyzed and provided quick solutions to the problems raised by FI and CO users.
  • Tickets were mainly based on AP, AR and CO-PA.
  • Interacted with users when necessary to solve the problems.
  • Assisted users in GL transactions like fast data entry, document splitting, holding and parking.
  • Trained end users on day to day to transactions like document reversals, intercompany transactions, etc.
  • Supported users to get the required reports from the SAP ECC system.
  • Prepared training documents for GL, AP, and AR.
  • Trained users on GL, AP, AR and Treasury.
  • Trained users on month end and year end closing activities.
  • Made changes to configuration settings like addition of new account groups and accounts based on the requirement.

Confidential, Pittsburg, PA

SAP Tester-FI

Responsibilities:

  • Mapped client requirements into SAP processes, solutions and products that were being implemented.
  • Involved in preparation of BBP documents.
  • Involved in preparation of functional and technical specifications for the new custom developments.
  • Responsible for configuring and testing the system for GL and New GL related business processes.
  • Involved in migrating customer and vendor master data through LSMW.
  • In GL, tested business processes such as fast entry screens, posting, parking, reversals, holding and month end closings.
  • Manually tested GL master records, field status groups and posting keys.
  • Tested FICO transactions for field errors and missing data in SAP standard programs.
  • Fixed issues with valuation areas for material ledger, maintained number ranges and assigned currency types to material ledger.
  • Involved in integration of AP and AR modules with MM and SD modules respectively.
  • Modified existing test cases and prepared additional test cases as per the new requirements.
  • Involved in unit testing, integration testing and regression testing.
  • Tested report painter and report writer reports.

We'd love your feedback!