We provide IT Staff Augmentation Services!

Sr Fico Consultant Resume

5.00/5 (Submit Your Rating)

GA

PROFESSIONAL SUMMARY

  • 7+years of IT experience, more than 8+years in SAP ERP FICO implementation and configuration of SAP FICO modules.
  • Experienced in gathering and analyzing business requirements, identifying process gaps between AS-IS and TO-BE processes, re-engineering business processes and mapping processes to SAP R/3 functionality.
  • Involved in 2 full cycle implementations using ASAP (Accelerated SAP) methodology with experience in all project phases - Project Preparation, Business Blue Print documentation, Realization, Final Preparation, Go-Live and Support.
  • Engaged in Upgrade (R/3 4.7 to ECC 6.0) and Production Support Projects.
  • Extensive experience with New G/L - Parallel Accounting, Document splitting, ledger configuration, Real time integration of controlling with FI, Parallel Currencies, periodic processing and Segment Reporting.
  • Did extensive functional design writing for interface and enhancement development.
  • Have demonstrated leadership abilities through various engagements and have been very effective and efficient in C-level executive communication.
  • Proficient in GAP analysis. Solid foundation in accounting concepts and in depth understanding of business processes for most cost effective and efficient business solutions.
  • Extensive experience in Financial Accounting that includes General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Asset Accounting (AA), Fixed Asset, Bank Accounting (BA), Treasury, New GL, Special Purpose Ledger (SPL).
  • Controlling expertise includes Cost Element Accounting (CO-CEL), Cost Center Accounting (CO-CCA), Profit Center Accounting (CO-PCA), Internal Orders (IO), Profitability Analysis (CO-PA) and Product Costing (CO-PC).
  • Maintained Currency exchange (FX) rate tables and worked on Multicurrency valuation and parallel currency set up.
  • Strong functional experience in configuration and integration with other modules like SD, MM, PS, and HR.
  • Sound knowledge in writing functional specifications, creating customized reports and working experience with Legacy System Migration Workbench (LSMW) and eCATTs for conversion and transfer of master and transactional data from legacy to SAP systems.
  • Ability to work with Reporting Tools like Report Painter and Report Writer and extensive experience in extracting reports from BW.
  • Good implementation knowledge of Solution Manager (SolMan). Also, RWD uPerform and its integration with SAP transactions.
  • Hands on experience with ABAP 6.4(Object Oriented).
  • Very proficient in writing Test scenarios, test cases for all FICO related transactions and worked extensively on unit testing, integration testing, functional testing and user acceptance testing using HP Quality Center (HPQC).
  • Highly organized, productive and demonstrated ability to work both in independent and team-oriented environment with excellent Interpersonal and Communication skills.

TECH-SKILLS

  • ERP Tool : SAP R/3 Version 4.6B, 4.6C, 4.7 ECC 6.0
  • Development Tools :LSMW, SAP scripts, Report Painter, Report Writer & BDC
  • R/3 Interface : EDI, ALE, IDoc, BAPI, Workflow
  • Data Warehousing Tools : SAP BW 3.5 / 7.0
  • Programming : ABAP/4, SQL, PL/SQL

EDUCATION:

  • BA in Accounting and Finance

Work Experience/Project Details

Confidential,GA:
Duration: 01/2011 – 05/2012
Role: Sr. FICO Consultant
Project/Scope: Full-Cycle Implementation/Production Support
Responsibilities:

  • Analysis of business requirements, determining organizational structures and classifying business units / locations as company codes, business areas and profitability centre.
  • As a team lead, participated in the preparation of blue print document for financial reporting.
  • Creation of Enterprise Structure: Defining business areas, company and creation of posting period variant, posting keys, field status groups, tolerance groups, fiscal year variant, document number ranges, document types, etc. Defined chart of accounts, account groups, recurring entries, and general ledger accounts for each company code
  • Implemented various SAP functionalities and enhancements that were not included in initial implementation e.g. Park and Post Process, Availability Control on Internal Order Budget, Financial Statement Version etc.
  • New General Ledger: Activation of New GL Accounting, Define ledger for GL Accounting, Integrating the GL with subcomponents, Document splitting, Segmentation and Parallel Accounting.
  • In Document Splitting defined Splitting Characteristics, and Activated Document Splitting.
  • Created Blue Print for New G/L, Plan of Migration, Tested and Performed Migration
  • Activated Parallel Accounting for the Different Accounting Principles like US GAAP and other countries
  • Designed and configured pricing for inter-company billing processes.
  • Configured Automatic Payment Program (APP) for out going payments in Accounts payable.
  • Automatic creation of voluminous inter-company postings with I-doc creations and interfaces.
  • Providing the solution for Procure 2 pay process- Vendor Master, Material Master Purchase Info-Record, Source List and maintained quota arrangement, Purchase Requisition, Purchase Order (PO), Contract, Schedule Agreement, Pricing Procedures, Release Strategies, Split valuation, MRP
  • Created financial statement versions based on client’s reporting needs.
  • Worked on Report Painter / Report Writer in FI/CO modules for developing customized reports.
  • Payment Program with ACH, EFT/Wire Transfer with Positive Pay files.
  • Defined chart of depreciation, depreciation areas, and asset classes. Customized asset accounting structure / valuation of fixed assets, designed asset management to carryout business transactions like acquisitions, retirements, transfers, write-offs, post capitalization, and asset under construction processes.
  • Sale of Asset / Retirement with scrapping / Asset Acquisition w/offsetting entry.
  • Created various new (fixed asset) asset master data and tested them thoroughly in the testing environment and transported them into the production.
  • Responsible for creating depreciation keys for new fixed assets and depreciation testing.
  • Performed integrated testing for transactions relating to fixed asset retirement with scrapping.
  • Experience in configuring asset classes for new fixed assets
  • Monthly Depreciation Run/Creation of Order using internal orders and settlement to AUC and to normal asset.
  • Asset Sale with or without customer & Asset Transfers.
  • Provided end user training for general ledger, accounts payable, and fixed assets.
  • Created structure for Cost / profit Centers and done with lot of assessments and distributions. And also done cost center input / output planning.
  • Post Document, Foreign Currency Valuation Postings, Posting of Outgoing payment against Open item GL and Post FV Valuation doc
  • Involved in Cost center accounting, Profit center accounting, and integration with CO, and SD.
  • Configured cost allocation programs like assessments and distribution.
  • Involved in Cost center assessments to segments, COPA reporting, forms, Planning, Derivation rules and structures, Product and customer hierarchy, PA settlement, realignments and integration issues with SD.
  • Worked on Integrations, I-docs, and program debugging to evaluate the online integration of TMS with SAP for real time transaction processing
  • Unit Testing: Tested the discrete pieces like Functionality of Foreign Currency Valuation, Journal Entry Posting, Entering Exchange Rates, Account Balances, FI Document Validation, Purchase Requisition, and Purchase Order.
  • Identified GAPs across various business processes and designed the Functional Specifications (RICEFW).
  • Integration with MM, PP and SD: Integration of FI with MM, PP and SD modules, Inventory movement related account, Billing and Revenue account determination, Interfaces design and testing.
  • Configured Electronic bank statement (EBS).
  • Implemented Extended Withholding Tax; 1099’s for IRS reporting purposes.
  • Designed and built lockbox process for construction division.
  • Tested in QA environment and transport to production instance.
  • Test build of custom objects in development, testing before moving to Production using Test scripts covering Test scenarios.
  • Coordinate with users for User Acceptance Testing and completion.

Environment: SAP ECC 6.0 Ehp4.

Confidential,Cleveland, OH:
Duration: 04/2009 - 01/2011
Role: Sr. SAP FICO Consultant
Project Scope: Production Support
Finance:

    • Sr. FI/CO Consultant for New G/L, FI-AA, PCA and CCA
    • Implemented new company code for this entity. Parent company already had SAP implemented.
    • Implemented US-GAAP and Statutory Ledgers.
    • Implemented Order to Cash Cycle (Accounts Receivable), Procure to Pay Cycle (Accounts Payable), Asset Management (Fixed Asset, CIP) etc. Also worked on EDI (Inbound and Outbound) invoices generation.
    • Designed and used of additional Dimensions to FAGFLEXT.
    • Documented splitting with Zero Balancing on Profit Center.
    • Responsible for Configuration, system and Integration test planning and execution.
    • Designed Consolidation preparation in ECC 6.0
    • Complete design, configuration and implementation of FI-AA module.
    • Configuration of Asset under Construction using Investment Management Module.
  • Defined chart of depreciation, depreciation areas, derived depreciation areas and account determination for asset class.
  • Mapped the business process to SAP transaction related to asset acquisition (with Vendor/Without Vendor), Planned and Unplanned depreciation run, asset retirement (scrapping), and asset capitalization.
  • Utilization of SAP new GL functionality to support different segment reporting and reconciliation purposes.
  • Classification of GL Accounts and document types for document split activation for inventory postings such as GR/IR and activated the document splitting.
  • Bank & Customer Interfaces: Integrated SAP payment interface with various Banks and adapted SAP Lockbox functionality to process AR payments for automatic cash application against customer invoices, and accounting for automatic zero-balancing account (ZBA) cash movements.
  • Migration: Data migration using LSMW, migration of master records, transactional data, legacy data up-to five years
  • Testing: test scripts creation and development, testing plan including timeline, milestones and track progress, execution, conference room pilot meetings, unit and integration testing, testing team owner
  • Go Live: system validation, data comparison with legacy system, conversion, pre and post go live strategy, post production support, month end closing, hot issue list.

Controlling:

    • Configured components of Cost Center Accounting & Profit center accounting based on modified and re-structured Standard Hierarchy.
    • Created a new Operating Concern with custom characteristics and value fields and tested the flows from SD and FI documents into CO-PA.
    • Cost Center allocations and Internal Order settlements.
  • Business processes: procure to pay, order to cash, cost of manufacturing, cost of goods sold, costing based analysis.
    • Internal order accounting: settlement configuration, planning/budgeting profiles, order types.
    • Inventory Analysis: MRO material implementation: as per the requirements they had two types of MRO materials: stock able and non-stock able. So for stock able MRO materials we created the new Material Master and were expensed out at the time of consumption in process order. Other non-stock able MRO materials were expensed out at the goods receipt only.
    • Customized movement types for account determination.
    • Determined inventory price according to Standard Price and also Moving Average Price.
    • In Production Planning, the configuration includes BOM, Recipe (Routing), Resource (Work Center) and other formulas.
    • Configured Costing Variant to generate cost estimate using BOM and Routing. Also defined Cost Component Structure (CCS) with input from Accountants the way they wanted to analyze the cost of the product. Activity Types, Resource, and Period end closing parameters: WIP, Variance and Settlement Profile.
  • Integration: Material management (MM), sales and distribution (SD), business intelligence/ warehouse (BI/BW)

Environment: SAP ECC 6.0

Confidential,Lake Forest, IL
Duration: 03/2008 – 02/2009
Role: SAP FICO Consultant
Project: Full-Cycle Implementation

  • Configured the settings in G/L area, such as creating G/L master data, cross-company code transactions, with multiple currencies and multiple company codes, and open item clearing. Configured GL transactions for business processes such as fast-entry screens, posting, parking, reversals and month end closings.
  • Involved in understanding the Business Requirement, understanding Legacy system functionalities and customizations, gathered functional requirements through user workshops, Gap identification, Analysis and documented As-Is model and To-Be model.
  • Activation of New GL Accounting and Profit Center Accounting for segment reporting.
  • Configured and maintained House banks with multiple bank accounts, Alternate bank selections for payments, assigned check lots and defined void reason codes.
  • Configured Vendor Down payment, Installment payment, Automatic payment program, Check management, and recurring entries.
  • Using RWD uPerform, captured various phases of SAP lifecycle and produced single source XML file. From the XML file created several user content including, Business Process Procedures, configuration document, test script, simulation, eLearning course, assessment, and integrated help.
  • Integrated RWD uPerform with SAP transactions to create instant electronic help for users.
  • Design and configuration of Asset Management: chart of depreciation, asset class and defined the screen layout rules for corresponding asset classes, number ranges, depreciation keys, plan and unplanned depreciation run, period closing, year-end closing, system validation, report comparison with legacy data, asset acquisition through purchase order and without purchase order, asset retirement, asset scrapping, asset sale with vendor/customer, and business process procedures.
  • Configured the account determination and interface points between FI, and SD. Also resolved various issues related to the Order-to-Cash process.
  • Maintained functional specifications for RICEFW’s in Invoice process and Order Process.
  • Involved in resolving various A/R related EDI issues including correction of payment advice related IDOCs with help of ABAP programmers.
  • Provided user training on procedures and assistance in developing user Training manuals and planned the training sessions
  • Training and Documentation of all relevant process UAT (User Acceptance Testing), Unit testing, Regression testing, Integration Testing, Test Scripts arranging and coordinating the testing activities, Trouble Shooting. Cut off procedures along with uploading and tallying of legacy assets and the future depreciations etc., Support and Maintenance of the System.
  • Performed SAP Data Archiving, allowing removing data from the database and storing it in a consistent and secure manner.
  • Worked on integration of FI/CO with MM and SD for Inventory valuation, Movement types, damaged stocks and functions such as GR and Invoice verification, order management, pricing, delivery and transportation and billing.

Environment: SAP ECC 5.0
Confidential,Cleveland, OH:
Duration: 01/2007 – 03/2008
Role: SAP FICO Analyst

  • Helped the users to complete year end close; it was first year when client was using SAP system to do year-end close.
  • Supported daily production Issues related Order to Cash Cycle (Accounts Receivable), Procure to Pay Cycle (Accounts Payable), Asset Management (Fixed Asset, CIP) etc.
  • Designed, configured and tested New G/L, Cost of Sales Accounting and EC-PCA.
  • In PCA Material Master Data update, Cost center Master Data update, IO Master Data, Changing Field Status Variant For GL Accounts.
  • Created derivation rules to populate profit center for some SD related transactions
  • Worked on report painter to develop some custom reports.
  • In Product Cost Planning: I configured cost component structure, costing sheet (Overhead Calculation) and Configured material cost estimate with and without quantity structure, by maintaining costing variants and its components: Costing type, Valuation Variant, Quantity Structure Control, Transfer Strategy.
  • Integrated variant configuration with SD, MM, CO, Material Requirements Planning, and Production orders. Also, configured model service specifications, maintenance tasks list, and materials.
  • In CO- Cost Object Controlling: performed the configuration for costing the products on various cost objects: Production order, Product Cost Collector (Period) and Sales Order product cost estimate. Further I configured the period end activities like work in process and posting rules, variance were calculated and finally settled to the PA segments using PA transfer structure in Settlement profiles.
  • Redefined and Configured Payment Methods, Payments Terms, House Bank, Bank Accounts for AP, AR - Dunning process.
  • Involved in populating Costs in Sales Order line items using cost Conditions in SD and CO-PA for Variant Configuration Sales Orders in a Make to Order scenario.
  • Worked along with SD and PP resources in configuring Requirement Class for Configurable Process Materials.
  • Trained key users as well as end users on the business processes affected through the upgrade, performed extensive Unit tests and prepared cut - over activities and provided post go-live support.
  • Created aNew FI Drilldown Report, Financial Statements, Profit Center financial Statements (US GAAP)
  • Created customized reports using report painter, report writer, participated in testing using Solution Manager
  • Performed regular data archiving tasks to move archived data to more cost efficient storage media.
  • Helped Internal and External Audit teams to understand the implemented system.
  • Developed new reports and customized existing reports related to finance using Report Painter.
  • Reviewed various SOX (Audit) concerns and helped the company to improve the security design and implement new controls in the implemented processes.

Environment: SAP R/3 4.7

Confidential,Phoenix Arizona:
Duration: 05/2004 – 12/2006
Business Analyst:

  • Implemented various SAP functionalities and enhancements that were not included in initial implementation e.g. Park and Post Process with workflow that includes multi level approval, Tolerance Groups to handle discounts, Availability Control on Internal Order Budget, Financial Statement Version etc.
  • Supported daily production Issues related Order to Cash Cycle (Accounts Receivable), Procure to Pay Cycle (Accounts Payable), Asset Management (Fixed Asset, CIP) etc.
  • Worked with the finance team to acquire knowledge of their SAP responsibilities and streamline processes.
  • Maintained communication with business partners, functional groups and users to gain in-depth understanding of the month end closing as well as other finance/accounting processes then propose improvements.
  • Used Quality Center testing tool to measure progress, effectiveness of quality activities and manage manual and automated testing assets centrally
  • Worked closely with business users to define system gaps related to master data setup and reporting tools.
  • Developed an understanding of financial reports and tools, which are provided within SAP and utilize this knowledge by providing management with this financial information on an ad-hoc basis.
  • Evaluated alternate approaches as well as establish and foster close working relationship with global finance and logistics organizations.
  • Material Master Data update, Cost center Master Data update, IO Master Data.
  • Worked on report painter to develop some custom reports.
  • Developed various Test Scripts, User Training Documents and conducted workshops to train business users.

Environment: SAP R/3 4.7

We'd love your feedback!