We provide IT Staff Augmentation Services!

Sr. Sap Fico Lead Consultant Resume

Wichita, KS

PROFESSIONAL SUMMARY:

  • SAP FI/CO Functional Consultant with 8 plus years of functional experience in Financial Accounting (FI) and Controlling (CO) modules and integration with logistics modules (SD and MM).
  • Solid Finance, Accounting and Tax background including familiarity with Sarabanes Oxley Act(SOX), conventions and standards of US GAAP and IFRS.
  • Expertise in FI - GL, New GL, AP, AR, AA, SPL, Bank Accounting, Consolidations, workflow approvals and Travel & Expense.
  • Experience in implementing, customizing and configuring SAP R/3 4.7 - ECC 5.0 and ECC6.0 in both FI and CO modules.
  • Three full life cycle implementation experiences with ASAP methodology, proficient in interacting with business users to identify information need and initiate process change and expertise in business process engineering.
  • Solid experience in gathering business requirements, blueprinting, mapping business requirements to SAP environment, realization, final preparation, data migration, cut over planning, go live and supporting.
  • Resourceful problem solver with an excellent ability to understand the shortcomings of SAP business processes, capture justified user requirements, and manage these through to completion within a structured development cycle.
  • Configured Customer Hierarchies, Rebates, and Customer Master Maintenance as this related to the chargeback process common within this industry
  • Maintenance/FI modules (Project to Asset/Acquire to Retire/Record to Report processes
  • Financial Accounting expertise in Configuring General Ledger Accounting (FI-G/L), New G/L, Accounts Payable (FI-AP), Accounts Receivable (FI-AR), Asset accounting (FI-AA), and Treasury-Cash Management (TR-CM).
  • Excellent in working with posting validations, substitution rules, forms, interfaces (ALE & EDI), user-exits, and reporting tools
  • Worked on different aspects of FI Transactions such as Inter Company Transactions, Reconciliation Accounts, Partial and Residual Payments, Credit Memos/ Dunning and Clearing Inter-company Vendor/Customer Open Items.
  • Experience in Integration with SunGard Avant guard, Image now and TM1.
  • Controlling experience includes Cost Element Accounting (CO-CEA), Cost Center Accounting (CO-CCA), Internal Orders (CO-IO), Product Costing (PC), Profitability Analysis (CO-PA), and Profit Center Accounting (CO-PCA).
  • Hands on experience in configuring Cost Elements (CO-CEA), Cost Centers (CO-CCA) and Cost Element Categories and configuring Assessment and Distribution cycles.
  • Sound knowledge in migration from GL to New GL right from creation of blue print for new GL to the customization of document splitting, allocation, planning, Zero Balancing of documents.
  • Configuration of output tax, input tax & withholding (WHT) tax requirements in accordance with local and US tax laws.
  • Experience in configuration of Automatic Payment Run, Banks accounting, Foreign Currency valuation and Electronic Bank Statement (EBS), Lockbox configuration, Lockbox Processing and testing the lockbox functionality.
  • Experience in Product Costing, Cost Controlling, COPA and PS
  • Sound knowledge in validations of SOX, GMP, GXP and FDA regulated environments.
  • Experience in Unit, Integrating and User Acceptance Testing and knowledge of Report Painter, Report Writer.

TECHNICAL SUMMARY:

ERP Systems: R/3, ECC-6.0; FI-CO (GL, AR, AP, AA, New GL, SPL, CCA, PCA, PC, PA); Integration with SD and MM, New GL, Workflow, SAP-Business one, Ramco and Tally

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

Languages: C & C++

Database Products: SQL and MS Access

Project Mgmt. Tools: SharePoint and VISIO

Operating Systems: Windows 98/2000/NT/XP, Z/OS, MVS/ESA, MVS/XA, and UNIX

Reporting Tools: Report Painter, Report Writer, LSMW, CATTS, eCATTS

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

PROFESSIONAL EXPERIENCE:

Sr. SAP FICO Lead Consultant

Confidential, Wichita, KS

Responsibilities:

  • Ticket resolution and answering how-to questions
  • Responsible for detailed problem determination of issues escalated from Level-1.
  • Problem determination includes re-creating the issues, determining the point of failure by stepping through the ABAP Code and identifying the problem resolution.
  • If the resolution is a major development or configuration fix, provide the necessary change detail to Level 3.
  • Good knowledge in working with posting validations, substitution rules, forms, interfaces (ALE & EDI), user-exits, and reporting tools
  • To have the deepest level of application or product understanding.
  • Able to understand both the standard application features (i.e. out of the box functionality) as well as the detailed components of the customize1 d features.
  • Responsible for making changes, migrating them, completing the ticket and communicating the change to the level 2 support person, who can then resolve and close the call.
  • Determine problems found by the proactive application monitoring being done on a regular basis by the level 2-support person. Therefore, the level 3 person may also have to apply patches, complete performance tuning, re-create tables or indices, etc.
  • Co-ordination of problem tickets with offshore resources (functional as well as technical) to ensure that the tickets are resolved within the stipulated SLAs.
  • Ensuring that offshore team resources are properly loaded, help them in solving tickets where required and ascertain that the tickets are resolved well within the stipulated SLA timelines set.
  • Created Trading Partner validation rules for intercompany postings
  • Designed Fresh Start Accounting solution approach for this client emerging from Bankruptcy
  • Configured AP workflow with OPENTEXT
  • Worked on Accounts Payable workflow to have automated approval process
  • Configured settings for revaluation of assets, normal depreciation run, manual and unplanned depreciation.
  • Distribute, settle capital assets under construction and defined maximum amount for low value asset in depreciation areas
  • Configured Credit Check blocks on the sales order
  • Configured Complex FI-SD Warranty process.
  • Involved in loading the Project Definitions, Work Breakdown Structures (WBS Elements), Network Headers, Network Activities as a part of the Master Data.
  • Involved in loading the Statuses to the Projects, Custom Fields to the WBS Elements, Confirmations to Networks and Network Activities.
  • Created standard WBS & Network templates and assigned the products to them which will trigger different types of installation projects.(Assembly Process)
  • Worked on material reservation, deliveries of material, shipping of materials & return deliveries of materials.
  • Worked on creation of services, reservation of services to create a purchase requisition and worked on Service Entry Sheets.
  • Worked on the internal projects in which the costs are settled to Cost Centers (Expense Projects) & costs are settled to AUC and to Fixed Assets (Capital Projects)
  • Created LSMW'S for revaluation of assets and transferring of accounts payable from one company code to another as a part of Fresh start accounting
  • Configured house banks, bank accounts, reason codes, check lots and lockboxes for payments.
  • Worked with Center of excellence team to help them in replacement of third party vendor i.e Travelex as a part of budget control
  • Developed custom report for business to tie intercompany accounts payable and accounts receivable transactions
  • Resolved intercompany markup issues
  • Configured the system to show Purchase price variance and markup separately for (CAS Compliance) government reporting.
  • Configured structures for Tax Jurisdiction codes, calculation procedures, message control and field control for Tax amounts.
  • Worked with Technical team on data archiving of AP Invoices
  • Created 4 new company code as a part of fresh start accounting and client emerging from bankruptcy
  • Developed custom program to users to upload journal entries to SAP system as parked or Post documents based on roles
  • Developed custom program to transfer labor hours (LATS and CATS) Production orders, WBS and Shop orders.
  • Worked on FI-MM and FI-SD Integrations
  • Resolved FI-SD warranty Integration issues
  • Worked extensively on MM and SD pricing schema's
  • Worked on maintenance of Factory/ Holiday Calendars.
  • Created user-exits and routines with help of developer for intercompany markup values in Purchase orders
  • Worked on the user and supervisor roles and authorization with BASIS team.

Environment: SAP ERP ECC 6.0 Eh.P 4, SAP BI, SAP SRM, Vertex, HP Quality Center, Solution Manager, Remedy, SharePoint and Visio.

Sr. SAP FICO Consultant

Confidential, Houston, TX

Responsibilities:

  • Analyzed the organizational structure, business process and provided business analysis in the form of Blue print document for Demand planning and Distribution requirement planning.
  • Worked in various FI aspects relating to AR and AP issues, Recurring entries carry forward balances, residual/ partial payment settings for vendors and customers, down payments, reversal of documents and exchange documents, House Banks, Automatic Payment program (APP). Involved in optimizing bank details for wire payments, check lots, void reason codes and clearing inter-company vendor open items.
  • Configured end-to-end business process for FI (Accounts Payable)-MM integration work flow of Procure to Pay Cycle and worked closely with SD Consultants for integration of FI (Accounts Receivable)-SD for the Order to Cash cycle. Configured Automatic Account determinations for different material movements and valuation classes.
  • Designed, configured and implemented accounts payable check printing, periodic Sales and US tax reporting, and related month end financial reports.
  • Experience in SAP R3 including functional requirements gathering, functional testing, R/3 customizing/configuration, ABAP & BW programming and also worked on UTL SAP IS-U, Device Management.
  • End-to- End implementation experience of Open Text VIM. Configured solution for PC and non PO based invoices including 3-way and 2-way match scenarios in Open Text VIM.
  • Configured document type settings i.e. document process, process determination sequence, set sequence, index screen in Open Text VIM. Also worked on ICC/OCR setup for application creation per Archive document type and hotspot set up, batch jobs for invoice capture center dispatcher in Open Text VIM.
  • Identified invoice standards and multiple formats that includes single sided invoices, multi folded invoices, multi- page invoice with variant dpi in Vendor Invoice Management (VIM).
  • Configured VIM reports/Analytics in order to analyze and to provide updated progress status of invoice in a unified dashboard.
  • Worked on new G/L implementation for managerial and financial accounting, including segment reporting also configured settings for activating cost of goods accounting.
  • Configured lockbox processing with control parameters and posting data to handle incoming customer payments using BAI2 format, Worked on EBS, Positive pay, ACH payments and Wire Transfer.
  • Enhanced functionality of transfer of overhead costs from Cost center accounting on a periodic basis and transfer of activities indirectly into profitability analysis segment also designed the PA transfer structure to control the secondary cost elements.
  • Maintained assessment cycles and the relationship of cost elements to profitability segments for transferring overhead costs to COPA.
  • Wrote Functional Specifications using RICEFW (Reports, Interface, conversion Enhancement, Forms and Workflow) objects for better reporting for the management.
  • Configured tax, used calculation procedure TAXUSX to handle the US sales and use tax calculations.

Environment: ECC 6.0, SAP SRM, Open Text VIM, HPQC, OneSource, SharePoint, IFRS, GL, New GL AP, AR, AA, Inflation Accounting CCA, PCA, COPC, COPA, TR, CM, LIV, P2P, Taxes, Intercompany, Lockbox, EBS, Report writer/Report Painter and Project System.

SAP FICO Consultant

Confidential, Newark, NJ

Responsibilities:

  • Created functional specifications and worked together with the technical team and ABAP developers to develop and modify RICEFW objects.
  • Responsible for the cutover of FI - GL, AP, AR open items from SAP R/3 4.6C to SAP ECC 6.0 systems.
  • Responsible for all issues related to SD, MM integration impacting FI/CO.
  • Responsible for writing functional specifications and unit-testing all of the above mentioned cutover activities.
  • Prepared Legacy Asset Data Transfer for Asset accounting cutover.
  • Created new reports for the validation of SAP R/3 4.6C and SAP ECC 6.0 Asset data.
  • Checked for inconsistencies related to G/L, A/P, A/R modules in financial accounting and CCA, CEA, PCA in controlling modules.
  • Worked on New GL, configured the ledgers, set up integration with Controlling, and made the general setting for the fiscal year, the posting periods and the currencies.
  • Followed the Active Split process for the document splitting, defined the splitting rules, business transaction and item category.
  • Set up parallel accounting by creating additional accounts in New GL, one joint account area for posting that are the same for both accounting principles and one area with specific accounts for each accounting principle.
  • Maintained the GL account master data and Profit Center master data for the New GL.
  • Configured identical settings for updating segments and profit centers as well as the relevant partner information in the ledgers of the New G/L.
  • Configured additional Reconciliation account based on the client requirements.
  • Made necessary settings for the Special Purpose Ledgers.
  • Modified the existing functional specifications for any field changes, new fields and enhancing the customer objects to make them compatible with the new version.
  • Worked on PTP (Procure-To-Pay) business process.
  • Worked on inter-company clearing and recurring entries.
  • Configured automatic posting for reconciliation ledger, real & statistical postings.
  • Configured and customized Cost center standard hierarchy, defined cost elements, and configured settings for assessments, distributions, reporting.
  • Participated in knowledge transfer to the client team members in new system functionality and performed the integration of FI and CO with SD, MM.
  • Documented all changes, revised the business process procedures to facilitate the changes during the upgrade.
  • Support and Regression testing of New GL, AP, AR, AA, FSCM Collections Management and FSCM Credit Management modules.
  • Tested in all modules of FICO with the new functionalities and resolved the issues during integration testing.
  • Performed Go-Live Support to ensure a stable SAP ECC 6.0 system.

Environment: SAPR/3 4.6C & SAP ECC 6.0, New G/L, SOX, OTC, P2P, BA, AA (Asset Accounting), Credit Memos, Taxes, Foreign Currency Valuation, Dunning, Intercompany, eCATTs, LSMW, ABAP, SAP BW, Data Migration, FI-MM& FI-SD Integration

SAP FICO Consultant

Confidential, Camarillo, CA

Responsibilities:

  • Involved in the analysis of AS-IS business - To-Be process, gap analysis, BPP and finalizing the Business Blueprint.
  • Created G/L Master records, accounts groups, assigned number ranges for account groups and G/L accounts for each company code, substitutions and validations rules for documents, recurring entries.
  • Implemented customization in the areas of AP-payment program, AR-credit control, dunning, customer master data, retained earning account assignment, employee tolerance, customer tolerance limits.
  • Configuration and creation of house banks, bank accounts and assignment of these accounts to a check lot. Configured automatic payment program for out-going payments in AP, payment terms, over-due interest calculations, cash discounts and automatic clearing of line items.
  • Configured Cost Center Accounting (CO - CCA) included creation of cost center hierarchy and cost center groups, assigned work center to cost centers.
  • Configured CO-Internal Orders (IO) by maintaining Order Types, Screen Layouts, Order Groups, Settlement Rules and Settlement Profiles.
  • Created cost centers, activity types, statistical key figures, maintained versions, distribution, and assessment.
  • Designed, configured, and implemented accounts payable check printing, periodic Sales and US tax reporting, and related month end financial reports.
  • Customized Credit Management Functionality including Maintenance of Credit Control Areas, Credit Risk Categories, and Credit Representative Groups etc. and performed timely execution of WBS Settlement.
  • Defined Work Breakdown Structures & WBS elements, described individual tasks and activities in the project as individual elements, created various hierarchical structures for work to be performed.
  • Assigned Activities to WBS elements, defined dates and costs in individual activities at WBS level; created Activity Funds and checked these funds against budgets of WBS elements.
  • Used Project Builder to create and edit WBS and networks in an integrated environment & individually. Also designed & implemented various views (detail/overviews), graphics & project board planning for quick & efficient planning and decision-making.
  • Worked on Project costing and resources planning.
  • Defined various user statuses in the status profile in Customizing - Project Definition, WBS element, Network Header & Network Activity for various task's processing stage like Task outstanding, Take released, Task completed or Task Successful.
  • Worked on Budgeting, Planning, Appropriation request, IM structure in IM and Budgeting and availability control for capital, customer and marketing project in PS.
  • Defined Reason codes, Customized Reason Code Conversion Versions & Mapped external reason codes to the defined reason codes to facilitate accountability for the underpayment and overpayment of incoming payments from customers.
  • Within the treasury module configured, Cash Management to obtain the cash position and liquidity forecast and recreated groups within Cash Management.
  • Configuring and testing of the Logistics Invoice Verification (LIV) process including Invoice verification online, Document parking, Invoice verification in the background, Automatic settlements, Invoices received via EDI and Automatic payment processing
  • Configured lockbox, generated bank advices and account posting. Imported and processed Electronic bank statements (EBS) worked with BAI2 file formats. Created lockboxes at house bank and configured control parameters and posting data. Configured G/L account structure for each bank account. Configured electronic bank statement and worked with different file formats (Multi-cash and BAI).
  • Worked on EBS, Positive pay, ACH payments and Wire Transfer, liquidity forecast and configuring and customizing multiple payment methods and automatic clearing.
  • Solved problems on Invoice, Cash Application, Lockbox, Electronic Payments and Automatic Customer Payment, clearing programs, Settlement, Adjustments, Credit Management and Banking integration.
  • Uploaded master data records of customers from the legacy ERP system into SAP through LSMW and ensured that bank and correspondence data is created for all customers.
  • Written Functional Spec's for all RICEFW (Reports, Interfaces, Conversions, Enhancements, Forms, Workflow) objects.
  • Implemented a Custom process with the help of IDOC Functionality, which enables the successful processing of data files even though there are errors at line item level.
  • Wrote the documentation for the roles in the company according to the SOX regulations and created different test scenarios using the Mercury Quality Center in order to test the configuration.

Environment: SAP Version ECC 6.0, SAP BI, SAP SRM, Vertex, HP Quality Center, Solution Manager, SharePoint, UgovernIT and Visio.

SAP FICO Consultant

Confidential, Houston, TX

Responsibilities:

  • Worked as a team member in Requirements gathering for business process and also mapped current state to future state, developed test scenarios, conversion/Interfaces/validation plans, cutover, end user and post go-live production support
  • Documented all changes, revised the business process procedures to facilitate the changes during the upgrade.
  • Created new reports for the validation of SAP R/3 4.7 and SAP ECC 6.0 Asset data.
  • Worked on New GL, configured the ledgers, set up integration with Controlling, and made the general setting for the fiscal year, the posting periods and the currencies.
  • Maintained the GL account master data and Profit Center master data for the New GL
  • Configured identical settings for updating segments and profit centers as well as the relevant partner information in the ledgers of the New G/L.
  • Followed the Active Split process for the document splitting, defined the splitting rules, business transaction and item category.
  • Set up parallel accounting by creating additional accounts in New GL, one joint account area for posting that are the same for both accounting principles and one area with specific accounts for each accounting principle.
  • Provided assistance in developing an interface program for uploading the salary details in the F-02 transaction from legacy system into SAP using LSMW.
  • Created cost elements i.e., Primary & Secondary, Revenue elements, Cost element groups and Overhead structure for Accrual calculation using percentage method.
  • Worked on Project systems, creating of WBS elements, budgeting and cost allocation.
  • Created CCA standard hierarchy, cost element groups, cost element categories like primary cost element group and secondary cost element groups, activity type groups and statistical key figures.
  • Familiarized with business scenario before configuring the steps in controlling module (CO- PA).
  • Worked on Reporting Tools used in Profit Center Accounting and defined Drilldown Reports.
  • Maintained settings related to Controlling Area, Operating Concerns and also maintained Versions.
  • Defined price update for standard cost estimate and inventory cost estimate and worked on and simulation costing.
  • Worked on Primary Cost Planning for Manual and Automatic planning and Secondary Cost Planning for Manual Planning and Periodic Allocations and Inter-company Transport Orders.
  • Worked for the Cost Centers participating in accrual calculation.
  • Assisted Technical Consultants and Super-Users to achieve desired results
  • Documented the end user manuals using Info Pak and involved in the Train the Trainees programs.

Environment: SAP R/3 4.7, ECC 6.0, GL, New GL, AP, AR, LSMW, CCA, PCA, IO, CEA, COPA

SAP FICO Consultant

Confidential, Richmond, VA

Responsibilities:

  • Expertise in using solution manager in Test Plan management, Tester Work list, Business Blueprint, Configuration and Project administration to create the test projects.
  • Creation of business process test cases and upload to solution manager.
  • Configured and tested settings for Fiscal year variants, Chart of accounts, posting period variants, Field status groups, G/L Accounts, Account groups, Retained Earning Account and Tolerance groups for their employees.
  • Worked on testing customer/vendor master records, tolerance limits per business requirement for over payments and under payments, reason codes and in open item management in customer accounts, configured and customized credit control area, credit management, interest calculation and payment terms tailored to specific Customer’s needs, payment advices, check number ranges, check void reasons, check printing, carrying forward balances.
  • Provided configuration and test support in SD, MM integration for account determination, material movement’s setup, and inter-company billing.
  • Worked on testing the flow of P2P (Procure to Pay) including creating Purchases Order, Good Receipts, Invoice Receipt and Outgoing Payments and trained end users on complete existing procurement to pay cycle documenting all accounting entries.
  • Developed interactive and ALV reports which shows the list of paid vendors for any given date with information of payment details, payment run details, check information etc.
  • Worked with technical consultants to design country/company specific forms for check printing and ACH payments and other Banking Interface requirements.
  • Developed test scenarios RICEFW objects which includes both global and regional, like freight payment, case pack, supersession and unit functional testing of the same.
  • Designed and tested dunning procedures, running/ editing dunning proposal and printing dunning notices based on customer segmentation.
  • Testing Tax configuration in Vendor master data as well as customer Master data.
  • Involved in testing Account Determination and Number Ranges.
  • Involved in testing Reconciliation Accounts for Vendors and Customers.
  • Testing TAX calculation procedure TAXUSJ, tax jurisdiction code, tax codes Maintained tax codes and taxable percentage rate calculation, defined tax codes for Nontaxable transactions.
  • Configured and tested House Banks, Payment Programs, Automatic Payment Methods, and Alternate Bank Selections for Payments. Checks Management through assigning number ranges for Check lots, checks printing and defining void reason codes.
  • Tested all modules of FICO with the new functionalities.
  • Resolved help desk tickets with respect to various areas of FI and CO. Developed necessary process flows, documentations, change requests etc. based on the requirements.

Environment: SAP ECC 5.0, AP, AR, GL, FI-SD, Unit testing, Integration testing.

Hire Now