Sap Fico Consultant Resume
San Diego, CA
PROFESSIONAL SUMMARY:
- SAP FICO Functional Consultant with 5+ years of functional experience in Financial Accounting (FI) and Controlling (CO) modules and integration with logistics modules (SD and MM).
- SAP experience encompasses expertise in Implementing, customizing, configuring, System upgrade, integrating, testing, user training and support of R/3 with different versions including ECC 6.0.
- Worked in 2 Full cycle implementations using ASAP (Accelerated SAP) methodology with experience in all project phases - Business blue print, Realization, Final preparation, Go-live and Support and post live production support, with documentation.
- Worked on project Upgrade from SAP R/3 4.7 to ECC 6.0.
- Extensive hands on experience in Financial Accounting (FI) including General Ledger (GL), New G/L, Asset Accounting (AA), Bank Accounting (BA), Accounts Payable (AP), Accounts Receivable (AR), Special Purpose Ledger and Treasury.
- Experience in configuration of Automatic Payment Run, Lockbox configuration, Banks Accounting and Electronic Bank Statement (EBS).
- Extensive work experience in integration of FICO with SD (Sales & Distribution) and MM (Materials Management).
- Extensive experience in data transfers from CCA, PCA, and INTERNAL ORDERS for Profitability Analysis.
- Ability to work as a SAP techno-functional consultant with sound knowledge in ABAP Queries, Reporting Tools: Report Painter and Report Writer, User-exit programming, CATTs Programming and Debugging.
- Sound Knowledge in migration of data from Legacy system to SAP for Upgrade / new implementation / integration using LSMW, CATTs.
- Integrated Asset Accounting (FI-AA & AM) structured and valuated Fixed Assets, new Acquisitions, Alteration, Retirement, Depreciation postings, Year-End closing and Fiscal Year Change.
- Involved as a team member to ensure quality and adherence to time lines. Familiarity in setting up of onsite and offshore models.
- Worked on Multiple implementations and involved in various projects as a sole point of contact for various testing efforts and documentation.
- Experienced in testing scenarios such as Integration , Functional , Regression , User Acceptance Testing , Performance and End-To-End Testing .
- Industry experience and strong domain knowledge in Manufacturing Industry, Pharmaceutical, Food, Construction and Engineering business processes.
- Ability to work independently as well as in team oriented environments with good organizational skills, excellent communications skills and inter personal skills with problem solving aptitude.
TECHNICAL SKILLS:
ERP: SAP R/3 Release 4.6C, 4.7, ECC 6.0R/3 Interfaces: EDI, ALE, IDoc, and BAPI
Operating Systems: Windows 95/98/2000/XP/Vista/Windows 7, UNIX, Linux
Languages: ABAP, C, C++, SQL
Web Technology: HTML, XML, Photoshop, Flash
Database: Ms-Sql, Oracle10g, MS Access
PROFESSIONAL EXPERIENCE:
Confidential, San Diego, CA
SAP FICO Consultant
Responsibilities:
- Worked with SMEs in gathering business requirements and prepared Blue Prints for as-is and to-be process systems. Performed Gap Analysis to design to-be system.
- Configured and customized the basic settings for Profit Center Accounting. Maintained profit center hierarchy, assignments, CO-Objects to Profit Centers, distribution and assessment of costs.
- Created Standard hierarchy using CATTs in Cost Center Accounting, Cost centers, Assigned cost centers to cost elements, configured Activities and Statistical Key Figures, developed Assessment, Distribution, Periodic reposting cycles and segments.
- Configured Internal Orders (IO) by maintaining Order Types, Screen Layouts, Order Groups, Planning Profile, Allocation Structure and Settlement Profile.
- Customized the FI-SD interface by preparing the Revenue account determination process.
- Well acquainted with MM processes like Logistics Invoice Verification (LIV), maintaining Material master data, material groups, purchasing groups, purchasing info records, MM Pricing procedures, etc
- Configured FI-MM account determination - assigning valuation areas to valuation grouping codes, defining valuation classes, account grouping and account determination.
- Involved in design, configuration, & process re-engineering for Standard Cost Estimates in Product Costing. It has been configured for ‘Product Cost by Order’ and ‘Product Cost by Sales Order.
- Configured the Material Cost estimate with Quantity Structure and Configured the cost component structure, Costing variants for standard cost estimate for planned and actual Production orders in Product Costing Planning (COPC).
- Maintained Overhead cost elements, calculation bases, credits, costing sheets, activity plan, and costing types in Product Costing (COPC).
- Extensively worked on Cost Object controlling period ending activities such as WIP calculations, Variance calculations, settlements of process orders, cost estimate updates, costing run, marking and releasing for updating the price in material master records, display reports etc.
- Maintained setting for Costing Sheet like calculation bases, percentage overhead rates, and quantity based overhead rate in Product costing (COPC).
- Designed and configured Material Valuation in Material Ledger based on standard prices(S) and moving average price (V) including distribution of price difference between raw materials and finished goods inventory.
- Involved in receiving goods against production order and settled them to define accounts for Automatic Postings in Material Ledger.
- Analyzed M aterial Ledger, results analysis and product costing in Make-to-Order (MTO) and Make-to-Stock (MTS) procedures.
- Integrated Cost Object Controlling (CO-PC-OBJ) component in the R/3 System, for planned budget using various costing methods, Cost Split, Cost and Valuation Variants in Product Cost Planning (CO-PC-PCP).
- Responsible for carrying out Valuation in COPA planning to access pricing and product cost information for products having planned quantities, thereby allowing projected revenue and cost-of-sales figures to be calculated automatically
- Responsible for configuration of G/L Master records, 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.
- Configured areas of AP, House Banks and Automatic Payment program (APP). Involved in optimizing bank details for wire payments, check lots, void reason codes and clearing inter-company vendor/customer open items.
- Configured A/R including creation of customer account groups, number ranges for A/R, tolerance groups, credit control area, customer credit limits, credit limit groups etc.
- Maintained Lockbox configuration with BAI2 format, cash management and planning levels in treasury and worked on Electronic bank statements (EBS).
- Participated in transferring G/L accounts, vendor master data using LSMW. Modified the data with addition of payment terms and interest calculation
- Generated reports using Report Painter and Report Writer. Performed Documentation for end users and provided end user training.
- Developed unit and integration test plans and prepared test scripts.
Confidential, Long Beach, CA
SAP FICO Consultant
Responsibilities:
- Defined Controlling areas within the company, assigned number ranges to controlling area, maintained versions, maintained Budget Profile, Planning Profile and Planning Versions in controlling, created various Cost center and Profit center hierarchies, CO object assignments, Substitution and Validations.
- Configured Primary & Secondary Cost Elements, created Cost Element Groups and Assigned Number ranges to groups, configured Automatic and Manual cost element creation.
- Configured CCA through creation of Cost Centers, Activity Types, Cost Center Categories, Statistical Key Figures, Assessments & Distributions cycles and Allocations for periodic reposting, Planned and Actual activity price calculations.
- Created Activity types, Primary & Secondary Cost elements, Profit Center Hierarchy, Cost Center Hierarchy, Profit Centers, Cost Centers, Splitting Structures and Maintained Statistical key figures.
- Created Planning Layouts for Cost Element Planning, Distribution Cycles & Assessment Cycles and Allocation structures.
- Configured Dummy Profit Center for Statistical postings, Maintained Plan/Versions, Maintained the Master data, Defined profit center hierarchy, provided support for Account Determination for internal goods movement and for production variances.
- Modified the copied template operating concern to accommodate client requirements with new characteristics and value fields. Defined derivation structures and rules for customer characteristics.
- Assigned value fields to condition types in MM and SD, performed integration of FI/CO with SD & MM account assignments and used COPA to report profitability by customer, product, and market.
- Examined the company’s document flow, SAP process flow and recommending suitable validation procedures for documents at header, line item and whole document level
- Responsible for business process analysis, business requirements gathering, blueprinting, testing, end-user training and production support. Leading meetings with business owners to define application requirements.
- Extensively worked on Product Costing, configured Local and Group costing variants to create Standard cost estimates for finished products, Raw Materials and Semi finished products.
- Configured Material Cost Estimate with Quantity Structure, costing variant, cost component structure—with structures like BOM and Routing for costing the product provided by PP in Product Costing (COPC).
- Defined cost component structure, origin groups, calculation bases, percentage overhead rates, credit keys, costing sheets, overhead keys and groups and cost components in Product Costing (COPC).
- Worked on Product Costing (COPC) period ending activities such as WIP calculations, Variance calculations, Settlements of process orders, cost estimates updates, costing run, mark and release for updating the price in material records, display reports and so on.
- Configured Result Analysis Keys, Assignments and Updates for WIP calculations.
- Sound working knowledge of Material ledger with Actual Costing and Transfer Pricing in Product Costing (COPC).
- Involved in collecting the values connected with Material Movement in Material Ledger.
- Responsible for assigning Material Ledger types to Valuation area.
- Structures: Created Operating Concern, Maintained Characteristics, Maintained User defined Characteristics, Maintain Value Fields, Assigned Characteristics and Value Fields to Operating Concern, Maintained Operating Concern, and Assigned controlling area to operating concern and activated Profitability Analysis (COPA).
- Activated costing based Profitability Analysis (COPA) to report profitability by customer, product, and market. Monitored actual data flow from SD Billing Documents and FI. Generated Profitability report s using forms.
- Configured both costing based COPA and accounting based COPA, created Operating Concern with characteristics and value fields.
- Developed planning area, planning layout and planner profile in cost center planning. Configured Business processes in Activity Based Costing and configured for transferring data from Business processes into profitability segments in COPA.
- Created Cost Center Standard Hierarchy, cost centers, activity types, statistical key figures, Primary Cost Elements, Secondary Cost Element categories, allocations using cycle-segment method for periodic reposting, distribution and assessment, indirect activity allocations in Cost Center Accounting (CCA).
- Created standard hierarchy, profit centers, dummy profit center, defined document types, number range assignment, PCA planning parameters in Profit Center Accounting (PCA).
- Defined Internal orders for different order types, Planning profile, settlement profile, settlement rules and month end settlements to various cost and profit centers.
- Configured system settings in the areas of FI-GL transactions, House bank, AP - Automatic Payment Program(APP), AR - Customer Credit, Credit Controls, Credit memo and performed Dunning
- Configured Customer Master Data and master groups. Defined cash discounts based upon payment terms, Lockbox Processing for incoming payments in Accounts Receivables.
- Provided functional assistance in the development of RICEF (Reports, Interfaces, Conversions, Enhancements and Forms)
- Involved in the team of Unit and integration testing. Developed end user training manuals and provided end user training on business processes in SAP. Created authorization profiles for end-users
Confidential, New Bremen, OH
SAP FICO Functional Consultant
Responsibilities:
- Involved in gathering business requirement, Preparation of Blue Print by reengineering the system to fill the GAP between the existing system and to the TO-BE system, mapping processes to SAP R/3 functionality, and collecting master data.
- Studied the changes in the standard SAP system for the new version and prepared change configuration scripts.
- Modifications for existing Functional Specifications for any field changes, new field and enhancing the customer objects to make them compatible with new version
- Documented all changes, revised the Business process procedures (BPPs) to facilitate the changes during the upgrade and team and users of new functionality being added with version change.
- Maintained Controlling Area settings and Configured settings for Controlling Area and Operating Concern, maintained Versions.
- Created Primary and Secondary Cost elements, created Cost Element Groups, maintained Cost Element Attributes, Costing Sheet etc.
- Worked on the integration touch points of Product costing with Production planning (PP-PI) using a process setup that included process orders, master recipes, routings, Bill of Materials (BOM & resources).
- Configured valuation areas for Material Ledger, maintained number ranges for documents and assigned currency types to Material ledger
- Defined costing sheets for calculating Over head (percentage based over head calculation) in Product Costing (COPC).
- Extensively worked on Costing run to cost, mark and release multiple materials at same times in Product Costing (COPC). Configured PA Transfer Structures for transferring values from FI and Controlling.
- Configured multiple costing variants for period dependent sales data and involved in testing Bill of Material and Routing Data that is relevant for Product Costing (COPC).
- Customized settlement profiles, allocation structures and PA transfer structures to facilitate order settlement to COPA.
- Configured operating concern attributes and COPA settlement structure with the settlement rules to populate the values in the value fields in COPA.
- Designed and developed contribution margin reports in COPA based on a combination of characteristics using Report Painter and Report Writer.
- Created characteristics and value fields in COPA. Configured the derivative rules for user defined characteristics, created costing keys for transferring current cost estimate in COPA.
- Thorough understanding of the relationship between various SAP modules (FICO, SD, MM, PP) and of overall business processes such as Order To Cash (OTC) and Purchase To Pay (P2P)
- Implementation of Internal Orders for research and development projects. Created Internal Order, Budgeting, Corrected Entry Errors and Reposted Transactions.
- Configured all business transactions for accounts payable and account receivables including the Automatic payment program (APP) configuration, automatic check payment advice, Lockbox Processing, clearing of vendor and customer open items, bank master data, house banks for payment program, credit management, Periodic processing and correspondence.
- Configured and used LSMW for uploading master data of General Ledger, Customers and Vendors.
- Worked on CATT’s for creation and modification of master data of G/L accounts, Customers, Vendors, Internal Orders and Cost Centers.
- Involved in integration testing and Checked GR/IR accounts and vendor accounts for transactions and resolved issues during integration testing
- Resolved issues relating to these upgrade in the modules GL Accounting, Asset Accounting, Cost Center Accounting, Accounts Payable, Profit Center Accounting.
- Helped the training team to develop training material.
- Ensured compliance requirements (Title 21 CFR Part11) were met.
Confidential, MI
SAP FICO Functional Consultant
Responsibilities:
- Monitoring of Background jobs, Interface related issues, Period end closing procedures, Conducted meetings and discussed design, development, enhancement and maintenance of Custom reports to meet customer’s expectations and business goals for Accounts Payable.
- Configured Vendor Account Groups, Vendor Master Records, House Banks, Bank accounts, Check lots, Reason codes, Automatic Payments Program (APP), recurring entries, invoices, credit memos, etc.
- Worked on creation Customer Master Records, Billing, Payment terms and interest calculation, Incoming payments, AR Information System, Credit Management, closing operations, etc
- Integration with Enterprise Consolidation for Intercompany (ECCS).
- Involved in the entire Consolidation (ECCS) process which involves collection, Preparation of reported financial data, and the consolidation of the financial data.
- Worked on Fund center Hierarchy, commitment hierarchy, and generated reports.
- Integrated financials with Funds Management.
- Assigned Funds Management account assignment to controlling account assignment.
- Managed financial information dealing with Assets, liabilities, capital. And prepared B/S, P&L statements and other reports to summarize and interpret current and projected company financial position for department managers
- Designed and configured Asset management to carry out business transactions like acquisitions, retirements, transfers, write-offs and post capitalization
- Maintained validations and substitutions, overhead structure for accrual costs, allocations using cycle-segment method for periodic reposting, distribution and assessment, indirect activity allocations
- Hands on experience in configuring following in the FI Grants Management module: Program Management, Budgeting, Application, Assessment, Agreement, Claims and case management.
- Provided post Go-Live functional and technical consulting support for Grant Management.
- Configured the posting keys, and defined templates for recurring entries/posting in GL accounts.
- AR-customer transactions, Master data, Payment terms, Cash application, Lockbox processing, Mapping Bank Lockbox format with Sap lockbox format, customizing payment advice notes.
- Customized the standard hierarchy, cost centers, activities, and statistical key figures, developed assessment, distribution, periodic reposting cycles and segment in Cost Center Accounting.
- Configured SAP Funds Management Module including FMDERIVE, Budget Control System (BCS) and availability control (AVC) and developed Business Process Procedures (BPPs)
- Configures Funds Management to derive account assignments during asset transactions like creation, settlement, acquisition, retirement and sale of an asset.
- Designed specs for development of FICO Reports and Layouts. Generated reports using tools like Report Writer, Report Painter
- Analyzed monthly Financial Reports for management to assist them in financial decisions.
Confidential, Elk Grove Village, Illinois
SAP FICO Functional Consultant
Responsibilities:
- Involved with all phases of implementation from development of business blueprint, conducting workshops, GAP Analysis, and configured the system for implementation of Cost center Accounting, Profit center Accounting, Profitability Analysis, Product Costing.
- The project involved detailed study of the entire accounting operations, studying the current business process, organization structure finalizing and mapping & configuring of to-be Business process and providing necessary support
- Configured credit control area, cost elements, cost centers, profit centers.
- Configured costing based COPA, account based COPA, created characteristic and value fields, and configured valuation using product costing sheet.
- Extensively worked on cost estimate updates, costing run in Product Costing.
- Implemented Cost Estimate with Quantity Structure and Configured Costing Variants for Base Planning Object, standard cost estimate and current cost estimate.
- Defined Costing Type, Valuation Variant, Date Control, Quantity Structure Control, and Transfer Strategy for the costing variants in Product Costing.
- Created the cost component structure and valuation variants for Product costing purposes; overhead costing sheet with relevant overhead groups;
- Implemented Product Cost by Order. Configured Costing Variants for Preliminary Costing in Cost Object Controlling,
- Maintained overhead cost elements, defined costing sheets, allocations and settlements in CO
- Responsible for carrying out Valuation in COPA planning to access pricing and product cost information for products having planned quantities, thereby allowing projected revenue and cost-of-sales figures to be calculated automatically.
- Defined internal orders, order types, planning and settlement profile.
- Configured master data, standard hierarchy, dummy profit center, distribution and assessments in CO-PCA.
- Maintained number ranges for settlement and controlling documents, and for variance documents, used report painter and report writer.
- Customized General Ledger Accounting, Accounts Receivables and Accounts payable.
- Created Bank Master data, House banks, EDI, ERS, G/L accounts for each bank account and Reconciliation accounts for vendors, customers and assets.
- Configured automatic payment program for payments to vendors, created check lots, voided checks for payment blockage, and reissue of destroyed checks.
- Designed and configured Asset Management to carry out business transactions like acquisitions, retirement, transfers, depreciation calculation, write-offs and post capitalization.
- Made settings for GL accounts for AUC, Loss/gain on asset disposal/retirement, and posting depreciation under different Depreciation Areas.
- Integration of MM and SD with FI accounts assignment and appropriation request, investment measure in Investment Management.
- Documented the end user training manuals using Infopak and involved in the train the trainees programs.
Confidential
SAP FICO Consultant -Trainee
Responsibilities:
- Configured parameters for Company, Company Code, Business Area, Functional Area, and Credit Control Area.
- Defined Fiscal Year Variants and assigned Fiscal Year Variants to various Company Codes.
- Configured and tested General Ledger Accounts GL, AP, AR and assigning different process keys as required.
- Configured Automatic Payment Program (APP) for vendors and worked on daily accounting transactions in AR.
- Configured settings for creation of house banks, bank accounts, lockbox file formats, void reason codes, check lots and other criteria required for lockbox processing to expedite customer payments. Uploaded GL accounts using Batch Input.
- Ensuring master data upload of asset master and configuring FI-Asset integration.
- Participated in data uploads and trouble shooting and also in user training and issue resolution.
- Was also responsible for general controlling of CCA, PCA and IO