Lead Sap Fi/co Consultant Resume
PROFESSIONAL SUMMARY:
- Certified SAP FI/CO Functional Consultant with 7 years of Professional experience in Module Configuration, Implementation, Template Rollout and Production Support.
- Three Full Life Cycle Implementations with Project Preparation, Blueprint, Realization, Final Preparation, and Go-Live & Support.
- Experience as Business Analyst in developing requirements specifications, proposing improved business processes as per the standards and procedures established, developing testing strategies, verification scenarios, and provided user support.
- Extensive functional experience in General Ledger, New G/L, Accounts Receivable, Accounts Payable, Asset Accounting, Funds Management (FM), Grants Management (GM), Bank Accounting, EBS, Lockbox, Cash Management, and Consolidations.
- CO expertise in Cost and Revenue Element Accounting, Cost Center Accounting, Activity Based Costing, Internal Orders, Profit center Accounting, COPC and COPA.
- Grants Management experience in configuring Grantor, Grantee, Sponsor, Grant, Sponsored Class, Sponsored Program, Fund (External & Internal), and Budget Validity Period, and Reports.
- Experience in Funds Management with configuring FM Area, Fund Center, Hierarchy Variant, Fund Type, Fund, Funded Program, Commitment Item, Update Profile, Budget Profiles, Budgeting, Account Assignment Derivation, Document Type, Number Ranges, and Reports.
- Proficient in cross-functional integration of FI/CO with MM, SD, PP, and HR.
- Conversant with US GAAP and IAS/IFRS. SOX compliance procedure.
- Experience in Report Writer, Report Painter, User-Exits, Data Dictionary, Dialog Programming, Drilldown Reports, Debugging, BDC, EDI, IDOC, and LSMW.
- BIW Expertise in data extractions from CO-PA and FI. Experience in Data Modeling and Reporting with Query designer, BEx Analyzer and Web Application Designer.
- Experience in eCATT and HP Quality Center for Testing, Remedy ticketing system, RWD InfoPak and uPerform for developing documentation and training materials.
- Experience in Configuring Tax interface system with Vertex, Sabrix and Taxware.
CERTIFICATION:
SAP Consultant Certification
TECHNICAL SKILLS:
SAP Environment : R/3 4.6c/4.7, ECC6.0
SAP Modules : FI/CO, Integration (SD, MM, and PP), ABAP, BW 3.5
Operating Systems : WINDOWS 2000/XP/Vista, UNIX, MS-DOS
Packages : MS Word, Excel, Access, PowerPoint, Project
Database Languages : SQL, PL-SQL
Tools : HP Quality Center, Remedy, RWD InfoPak, uPerform
PROFESSIONAL EXPERIENCE:
Confidential, (Montvale, NJ)
Lead SAP FI/CO Consultant May 2007 – Current
Responsibilities:
- Lead implementation project team from Blueprint to Go-Live. Implemented New G/L, AR, AP, AA, PCA, COPA, and Product Costing modules in ECC 6.0.
- Gathered business requirements, developed blueprint design documents, configured and tested the system, trained business users, and provided post go-live support. Developed functional specifications (RICEF), impact and preliminary analyses, and participated in development projects as advisor in the area of business and systems use.
- In New G/L implemented the Parallel Accounting, Segmentation Reporting, Document Splitting, and CO-FI real-time integration functionalities.
- System preparation for the Parallel accounting by defining non-leading ledgers, valuation methods, valuation areas, accounting principles and their assignments.
- Configured system for generating Segmentation reports by assigning the segmentation scenario to the leading and non-leading ledgers.
- Document Splitting was implemented by defining document splitting characteristics, Splitting Method, Business Transaction, Splitting Rule, Item Categories, and Base Item Categories.
- Configured system for real-time integration of CO with FI by defining variants and Account Determination.
- In AR and AP configured Account Groups, Number Ranges, Customers/Vendors master records, House Banks, Interest Calculation,
- Dunning Procedure, Payment Methods, Bank Reconciliation, Automatic Payment Program, Lockbox processing, and Electronic Bank Statement (EBS), and Automatic account assignment for various AR & AP transactions like Bank charges, over/under payments, exchange rate difference, and rounding differences.
- Configuration of Asset Accounting – Basic Settings for Asset Accounting, determine depreciation areas in Asset class, Configured depreciation key, Postings under Fixed Assets, Acquisitions, Intercompany Asset Transfer, Configuration of Retirement, Retirement with Revenue, Asset Retirement by Scrapping, Configuration of Year End Closing, Account Reconciliation.
- Worked with Standard Fixed Asset Reports; Asset Balances, Depreciation of Capitalized Assets, Depreciation Current Year and Asset History Sheet.
- Tax related Configuration include Maintaining of the Pricing procedure (RVAXUD), defining pricing procedure determinations, Activating external system (VERTEX), Assign country to calculation procedure (TAXUSX), Allocate Co code to non-taxable transactions, Creating number ranges for the external Tax documents, Creation of tax codes for external Tax calculations.
- Cost Elements Accounting involving both primary and secondary cost elements.
- In Cost Center Accounting defined and assigned standard hierarchy, validations and substitutions, Assessments and Distributions, integration with MM, SD, PP.
- In PCA, created Standard Hierarchy, Profit Center groups, Dummy profit centers, Profit center Master Data, assigned different Objects to Profit Center, and Reports.
- In Profitability Analysis (CO-PA) configured costing based CO-PA, assisted client in design and configuration of PA structures, including decisions on characteristics derivation, Value Fields, derivation rules and settlement to CO-PA.
- Configured Cost Center Assessments to COPA. COPA Planning Versions, Planning Layout, Planning Profiles, Top-down distribution, Defined External data transfer structure, Assessment groups, Field Assignments, Configured Manual Planning with external data transfer.
- Configured Report Line Structures, Forms, and created COPA drilldown reports.
- Implemented COPC module for Discrete Manufacturing (Make-to-Stock): Product Cost Planning,Cost Object Controlling, Material Ledger configuration.
- Configured Valuation Variant, Costing Type, Costing Variant, Unit Costing, Material Costing with and without quantity structure, Cost Component Split, Costing sheet, and Costing Run (Mark and Release). Configured Integration with PP for material, labor and activity costs (BOM, Routing, Work Centers etc).
- Configured Cost Object Controlling for Make-to-Stock (Costing by Order), Product cost collectors, calculating Planned and actual costs, Work in process, scrap costs, and variances at period end close. Configured Settlement Profile and Settlement Cost Elements, PA Transfer Structure for Settlement of Production Variances (COPA) and Settlement of Price Differences (FI and EC-PCA), Work in Process (FI and EC-PCA), Scrap (COPA) and Product Costing Reports.
- Configured Material Ledger, Material Price Determination, Material price analysis, and multi-level settlement.
- Regression testing against existing SAP system. Unit and Integration testing.
- Documentation of business processes, training, and test scripts.
Confidential, (San Antonio, TX)
Sr. SAP FI/CO Consultant January 2006 – May 2007
Responsibilities:
- Provided production support on resolving day-to-day tickets, month-end closing processes, Financial and Managerial reports in FI/CO. Enhancement projects in FI, EBS, Lockbox, Tax, COPA, and COPC Functionalities.
- Proposed new or improved business processes. Validated new processes with the business process owners. Analyzed change and update requests.
- Organized and supervised the SAP R/3 configuration based on business processes.
- Trained SAP FI-AR, FI-AP, SD, MM end-users on various areas like payment terms, Customer Contracts, process payment runs, manually processing incoming payments, running/editing Dunning proposals, reconciliation accounts in the GL.
- In G/L configured Tolerance Groups for Employees, Assign User/Tolerance Groups, Open and Close Posting Periods, Copy document number ranges to fiscal year (OBH2), GL master records, Defined Automatic Clearing of open items, and Assigning accounts for GL Clearing Differences.
- Configuration for Foreign Currency Valuation, assign GL accounts for Foreign Currency valuation, Maximum Exchange Rate Difference, Adjustment Accounts for GR/IR clearing, and FI Integration with CO, MM, and SD.
- Configured Lockbox and Electronic Bank Statements (EBS) in BAI II Format.
- Configured Chart of Depreciation, Integrated Asset Accounting, structured and valuated Fixed Assets, created Asset class, Acquisitions entry and alterations during use, Asset retirement. Strong working knowledge on Depreciation postings, calculations/reporting and Year-end closing and Change-of year.
- Experience with interfaces to sales and use tax calculation using VERTEX system.
- Configured Cost Center Accounting (CCA), Profit Center Accounting (PCA), Profitability Analysis (COPA), and Product Costing (COPC).
- Design and configuration of costing based Profitability Analysis (CO-PA). Maintained Operating Concern and Controlling Area, Characteristics, Characteristic Derivation, Value fields, and Profitability Segment Characteristics. In COPA Planning maintained Planning Versions, Quantity Fields, Planning Framework, and Receiver Plan Version. In Actual posting maintained Value Field Groups, Assign Quantity Fields, Maintain PA Transfer Structure, Automatic Account Assignment, and Assign PA Transfer Structure to Settlement Profile.
- In COPA Reporting configured Report Line Structures, Variables for Reports, Forms for Profitability Reports (KE34), and Created Profitability Report (KE31).
- Implemented Product Costing for Process Manufacturing. Configured Product Cost Planning (CO-PC-PCP) and Cost Object Controlling (CO-PC-OBJ). Releasing Process Orders, Cost Split, Cost and Valuation Variants, Costing Sheet, Costing Run, Simultaneous Costing, Final Costing, Price Transfer/Update, Confirmation/Settlement and Period-End closing. Calculated Overheads, Work in Process (WIP), variances and settlement. Cost Component Layout with multiple cost component views, additive cost and special procurements.
- Configured Material Ledger settings for valuation area, currency types, Number Ranges. Defined Material Movement Type, Material Update Structure. Configured Actual Costing and Actual Cost Component Split.
Confidential, (Austin, TX)
SAP FI/CO Consultant June 2004 – Dec 2005
Responsibilities:
- Project Preparation and Blueprint activities, Mission Statements, Project goals and deliverables, reporting requirements, Solution Manager, Roles and Authorization. Supported all phases of the ASAP methodology, including BPML, RICEF, TEST SCRIPTS, BPP, IMG Docs and support model. Identified and documented the strategic orientations and project scope. Analyzed user requirements and translated business constraints.
- Identified integration points of external systems to SAP R/3. Coordinated the execution of unit and integration tests. Updated the documentation in accordance with standards.
- In G/L configured company code, Chart of accounts, Account Group, Retained Earnings Account, Fiscal Year Variant, Posting period Variant, Open and Close Posting Periods, document number ranges, Field Status Variants, Tolerance Groups for Employees, and Assign User/Tolerance Groups.
- Company Code settings in Global parameters, GL master records, Automatic Clearing of open items, Assigning accounts for GL Clearing Differences, Foreign Currency Valuation, Maximum Exchange Rate Difference, Assign GL accounts for Foreign Currency valuation, Adjustment Accounts for GR/IR clearing, Financial Statement Version, and FI Integration with CO , MM, and SD.
- Configured FI-AR and FI-AP Vendor/Customer master records, House Banks, Dunning Procedure, Credit/Debit memos, Foreign Currency Valuation, Automatic Payment Program, electronic/manual check deposit, bill of exchange presentation, Payment Terms, Interest Calculations, Lockbox Processing, Electronic Bank Statements (EBS) using BAI II.
- In Fixed Assets Configured Chart of Depreciation, Asset classes, Depreciation areas, Depreciation Key, Depreciation posting rules and Account Determinations.
- Determination of depreciation areas in the asset class, specifying document types to posting depreciation, specifying intervals and posting rules.
- Screen layouts for Asset master data & Asset depreciation areas. Maintained Depreciation key and Depreciation methods. Creation of asset, Asset Under Construction, Low-Value Assets, Retirement of assets, Depreciation run.
- Worked with Standard Fixed Asset Reports; Asset Balances, Depreciation of Capitalized Assets, Depreciation Current Year and Asset History Sheet.
- Configured FI-TR-CMrecords and reports for cash position and liquidity analysis.
- Configured Tax Procedure TAXUSX with external tax system TAXWARE for maintaining tax rates.
- Involved in the data extraction and conversion from legacy system using LSMW.
- Involved in CO module configuration of Cost Centre Accounting, Profit Centre Accounting, Internal Orders, Product Costing and Profitability Analysis.
- Configured Operating Concern for costing-based COPA. Characteristics and Value Fields, Maintained Derivation Tables, Structure and Rules, COPA Reports.
- Implemented Product Cost Controlling for Make-to-Order. Configured Master Data for Product Costing (COPC), creating additional primary cost elements, creating valuation variant, costing variant, Costing Run, Costing Sheet, cost component structure. Integration with PP, and MM.
- Configured Result Analysis, settings for WIP Calculation, Posting Rules for settling WIP, Variance Keys, Production Variances, Price differences, creating settlement profile, PA Transfer Structure, and Product Costing Reports.
- Performed Unit and Integration Testing. Prepared test procedures and scripts.
Confidential, (Houston, TX)
SAP FI/CO Consultant July 2003 – Apr 2004 Responsibilities:
- Developed and analyzed business and functional requirements. Analyzed the “AS IS”, ‘TO BE” systems and carried out Gap-Analysis. Clearly defined and documented required business functionality as well as reporting requirements.
- Data Conversion, Data Validation and Data Migration from Legacy Systems.
- FI-GL Chart of Accounts mapping and maintenance, Financial Statement Version, configuration of document types, number ranges and mapping of GL transactions.
- In AR and AP configured Customers/Vendors master records, Account Groups, Number ranges, House Banks, Billing Processing, Lockbox, EBS, Interest Calculation, Dunning Procedure, Invoice Processing, Payment Methods, Payment Terms, Payment Advice, Tolerances, and Automatic account assignment.
- In Credit Management configured Credit Control Area and Risk Categories, Credit Representatives, Days in Arrears, Customer Analysis with Days in Arrears, Payment History, Cash Discount Overview and Credit Limit Display.
- Configured House Banks, Bank Accounts, GL structure, Posting Rules for Automatic Assignment.
- Integration of FI with MM and SD through Automatic Account Assignment.
- Experience with interfaces to sales and use tax calculation using VERTEX system.
- Configured Controlling modules Cost Element Accounting, Cost Center Accounting, Profit Center Accounting, COPA, and COPC.
- Created Primary and Secondary Cost Elements and Reconciliation with FI.
- In CCA - Defined Standard Hierarchy, Created Cost Centers, Defined Cost Center Categories, Time based fields and configured Allocation Methods.
- In Profit Center Accounting Defined Profit Center Hierarchy, Configured other Basic Settings, Assignments and Actual Posting Maintenance.
- In Profitability Analysis (CO-PA) Created Operating Concern Attributes, Characteristics and Value Fields, Maintained Derivation Tables, Structure and Rules. Defined PA Settlement Structure and CO-PA Cost Center Assessment.
- In Product Costing for Process manufacturing (CO-PC) configured material costing with quantity structure, Costing Run, product cost collectors and period end settlement of WIP and variances.
- Conducted Testing and Validation of processes, End User Training and Post Production Support.
Confidential, (Madison, NJ)
SAP CO-PA/BW Consultant Oct 2002 – Jun 2003
Responsibilities:
- Configured Controlling area settings for implementation of costing-based CO-PA.
- Configured Operating Concern for costing-based Profitability analysis and added user defined characteristics for enhancing the reporting capabilities of CO-PA.
- Created process flow of profit planning and planning levels, and defined planning layouts for entering plan data.
- Created DataSource in the OLTP (SAP R/3) system using transaction KEBO.
- Activated Business Content of COPA, Info Cubes and Info Objects based on Operating Concern in accordance with the Client reporting requirements.
- Replicated DataSource from the Source System (SAP R/3) and assigned to the created InfoSource. Defined Communication Structure and Mapped the DataSource fields with the InfoSource Fields in Transfer Rules.
- Maintained/created InfoObjects, InfoCubes, Master data and hierarchies to suite to CO-PA reporting requirements.
- ETL: Created Update rules connecting InfoCube with the InfoSource and Extracted COPA data into various Datatargets in BW system, ODS and InfoCube. Built Multi-Provider, based on different ODS and InfoCubes.
- Created Direct Schedule Process Chains and used them to create respective Meta-Chains to trigger delta loads in background.
- Customization involved adding new Restricted Key Figures (RKFs), Calculated Key Figures (CKFs) and creating Structures in the Query Designer.
- Developed CO-PA Reports in BEX Analyzer and publishing it on the Web using Web Application Designer (WAD).
- Documentation and End-User Training.
Confidential, (Kansas City, MO)
SAP FI Consultant Feb 2002 – Sep 2002
Responsibilities:
- Configured GL account structure for clearing accounts configured, electronic bank statement processing, created treasury grouping, treasury headers and cash management, account names and tested the configuration.
- Configured End to End AP module including the Vendor Groups, Number Ranges, Automatic Payment Program, Configured Special Ledger Withholding Taxes, Configured AP integrations to MM for various material movements (Automatic Account Assignments),
- Worked on LIV (Logistics Invoice verification) , linking of Vendor documents with EDI. Maintenance of vendor and customer master.
- Created tolerance groups for vendors and customers. Configured for automatic interest calculations on account balances/line items.
- Configured payment terms for dunning, over-due interest calculations, cash discounts and automatic clearing of line items.
- Configured automatic Clearing for AP, AR. Identified one-time vendors and customers and defined a separate screen layout for them.
- Inter-Company Clearing, Release for Payments, check management, and EDI incoming invoices and payment orders.
- Configured Cash Management module incorporating cash position and liquidity forecast. Defined house banks, bank accounts, reason codes, check lots.
- Configured manual and electronic bank statements. Created source symbols, planning groups and planning level for Liquidity forecast.
- Defined variants for check and made settings for check printing and assigned forms to payment methods. Assigned ACH payment methods to EDI compatible payment methods.
- Responsible for Configurations in Asset Accounting, Copying reference Chart of Depreciation, made required settings for account determination, asset classes, screen layout rules, defining number ranges, valuation of assets in different depreciation areas, external asset acquisition, in-house asset acquisition, cross company code
transfers, settings for depreciation runs, Asset Explorer, Settings for automatic account assignment ( FI-AA Integration).
- Carried unit testing and integration testing and provided Post production support.