Sap Fico Consultant Resume
San Jose, CA
PROFESSIONAL SUMMARY:
- Experienced SAP FICO functional consultant with 9 years of implementation, configuration integrating, testing, customizing, support and providing End - user training in Pharmaceuticals, Manufacturing, & Consumer Electronics industries.
- Involved in 3 full Confidential cycle implementations, AS-IS studies, Fit-GAP analysis, TO-BE process, Blue-Printing, troubleshooting, upgrades & production support projects, participated in all phases of ASAP Methodology.
- Financial accounting expertise includes configuring GeneralLedger (GL), Accounts Payable (FI-AP), Accounts Receivable (FI-AR), Asset Accounting (A/A) and Controlling (CO).
- Intercompany setting in AP/AR, worked on the process from a Logistics standpoint to the end result In Finance.
- Controlling expertise includes configuring Cost Element Accounting (CO-CEL), Cost Center Accounting (CO-CCA), Profit Center Accounting (CO-PCA), Cost and Profit Center Accounting (CPA), CO-I/O, CO-PA and Product Costing(CO-PC) in highly Complex Business Environment.
- Rich experience in integration of SD/MM modules with FI/ overall business process with expert inOrder-to-cash (OTC), Make-to-Order (MTO) and Procure-to-Pay (P2P)
- Experience in configuration of Automatic Payment Program (APP), Lockbox configuration, Electronic Bank Statement (EBS), Check management , Document Splitting and Zero balancing of Documents in New G/L.
- Configured New G/L fordocument splittingand provide Document simulation facility rather than waiting for period end process.
- Responsible for configuration of Tax on sales and purchases, Withholding tax, Tax jurisdiction codes, Tax Procedures, Cross Company code configuration.
- Expert in SAP Strategic Enterprise Management - Business Consolidation System (SEM-BCS ) controls the consolidation activities in the SAP system, including currency translation and validation
- Expert in Designed and configuration of Credit Management, Collections Management, automatic correspondences to Customers and workflow for internal business users in FSCM.
- Responsible for the projects of A/Rand FSCM and driving the blue print discussions for both A/R, Cash application Dispute and collection modules.
- Worked on Biller direct, RMCA, Bank Settings , EBS Settings, Basic Treasury management settings- risk and securities management, Funds Management, Dispute Management module , which includes the designing and configuration of Check free case record model using FSCM.
- Expert in SAP Simple Finance add-on - Check New GL Settings, Settings for Journal Ledger, Ledger for CO Version, Document Types for Posting in Controlling etc
- Experiencedin working on different functionalities of HANA Studio - Complex Analytic and Calculation views, Modeling, Data Provisioning, and Development of HANA based applications.
- Expert in handling of complex custom Interface EDI, IDOCS, XML Processing .
- Expert in Business Planning and Consolidation (BPC) and Proficient in Project Systems- Planning, Budgeting, and Cost Allocation .
- Functional specification for Customized Reports, LSMW for conversion, transfer of master and transactional data from legacy to SAP system, ABAP/4 reports, Solution Manager.
- Proficient in External Reporting and preparation of Financial Statements with solid knowledge of International Financial Reporting concepts (IFRS), Generally Accepted Accounting Principles (GAAP) and Sarbanes-Oxley (SOX) compliance.
TECHNICAL SKILLS:
ERP System: SAP R/3 ver. 4.7, ECC 5.0, ECC 6.0, S/4HANA
Project Management: MS Project, Visio, Lotus Notes, SharePoint, Access
Finance & Accounting: GL/AP/AR/BA, FI/ Confidential integration with SD, MM & PP, CEA/CCA/PCA/IO/COPA/COPC
Platforms: Windows 95/98/2000/NT/XP/7, UNIX, Mac OSX, Advanced Server
Reporting Tools: Report Painter, Report Writer, LSMW, CATTs &eCATTs
Applications: MS Word, PowerPoint, Excel & MS Access, HP ALM, HPQC
PROFESSIONAL EXPERIENCE:
Confidential, San Jose, CA
SAP FICO Consultant
Environment: SAP ECC, A2R, P2P, OTC, SAP supply chain, BW, BPC
Responsibilities:
- Participated in gathering information on company locations on current company’s legacy systems, business processes and activities; analyzed business requirements, determining organizational structure, classifying business units/locations, determining company codes, and profitability centers (AS IS - TO BE).
- Configured and Customized FICO modules including GL, AP, AR, CEA, CCA, PCA, RMCA, and CO-PA.
- Designing the HANA Information Models like Attribute Views, Analytical Views, Calculation Views and Column/Row based tables in HANA design studio and making them available in the BW system via Virtual provider.
- Conducting POCs simultaneously to make the existing architecture more scalable and robust.
- Designing the System Landscape Architecture and the Data Flow Diagram.
- Migration activities in Simple Finance- Migrate Secondary Cost Elements to Chart of Accounts, Migrate Default Account Assignments, Migrate Accounting Documents to Universal Journal Entry Structure, Transaction Data.
- Creating a Dynamic planning model with Simple Finance in the lights of Actual, Budget and Estimate data.
- Creating SAP Integrated Planning related Data Models like Aggregation Level, Confidential Enabled queries, Planning Functions, Planning Sequences, Filters etc.
- Leveraging both standard and customized planning functions to achieve critical business prospects.
- Analyzing, developing and modifying different Routines and critical Process Chains.
- A comparative literature has been performed in HANA modeling to enhance the existing SFIN models as well as to create the new models.
- Creation of Assessment Cycles, Costing Sheet and Activity types and configured operating concern attributes, and COPA settlement structure with the settlement rules, to populate the value to value fields in COPA.
- CO-PA Planning with Plan versions, Planning Profiles and Planning layouts and creation of Derivation Structure and derivation rules.
- Facilitated planning for Product Costing and Cost Object controlling by creating product cost by order, product cost by sales order and product cost by period.
- Running Standard Cost Cycles, Actual Costing, Variance Analysis and Settlement.
- Worked on SAP SEM-BCS establishing SAP solution for the creation of consolidated financial statements which is fully integrated into the SAP Netweaver BW platform
- Used SEM-BCS software solution for the creation of consolidated financial statements and is equally suited for statutory reporting and management reporting.
- Configured the Automatic payment program for Intercompany automatic account posting, running program for Check management, open item clearing and down payments.
- Configured Cash journals and special GL transactions and configured New G/L for document splitting and provide Document simulation facility rather than waiting for period end process.
- Used COPA to report profitability driven by characteristics like customer, product and market for a clearer picture of the company’s profitability. Created CO-PA forms and Report Line Structures.
- Integrated Cost Object Controlling (CO-PC-OBJ) component in the SAP System, for planned budget using various costing methods, Cost Split, Cost and Valuation Variants in Product Cost Planning (CO-PC-PCP).
- Implemented a Lean Cost Control Process in a Repetitive Manufacturing Environment to Improve System Performance.
- Releasing Production Orders, Confirming Operations, 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, special procurements and releasing of the new cost estimate.
- Made configuration in the FICO and FI module with a focus on Contract accounting areas, and Integrated with IS-PS.
- Conducted training sessions in the FICO area and cover integration issues FICO and FI in the design/support development after Go-Live.
- Preparing Business Process Descriptions (BPD), designing Solution Papers for the system and configuring the system for FICO.
- Involved in configuring field status groups, posting keys, inter-company postings, financial statement version, field status variants, validation/substitution, document types, Open and Close Posting Periods and carried out Mass change in G/L, AP and AR.
- Worked with all the A/P and A/R payments in the FI area including the F110 payment program and lockbox.
- Worked on Customer Master, House Banks, Payment Programs, Electronic Bank Statements and Lock Box and had successfully configured Clearing to clearing open items in GL/AR/AP Modules.
- Worked on configuration areas of Bank Accounts, House Banks, defined Posting Rules and keys for check deposit, configured variants for Confidential Statement.
- Designed specs for development of FI/ reports and layouts. Generated reports using tools like Report WriterReport Painter and runABAP Queries.
- Extensively worked on EDI IDOC (inbound, outbound, mapping with third party logistics service providers’ WM system, message type, segment extension, IDoc monitoring, posting)/ ALE (distribution model maintenance, logical system, ports, partner profiles.
- Manipulated data in IDocs, Analyzed and Solved IDocs errors.
Confidential, San Diego, CA
SAP FICO Consultant
Environment: SAP ECC 6.0
Responsibilities:
- Participated in gathering information on three company locations on current company’s legacy systems, business processes and activities; analyzed business requirements, determining organizational structure, classifying business units/locations, determining company codes, and profitability centers (AS IS - TO BE).
- Configured and Customized FICO modules including GL, AP, AR, CEA, CCA, PCA, RMCA, and CO-PA.
- Defined and Configured GL,Vendor/Customer master data and account groups.
- Configured Cash journals and special GL transactions and configured New G/L for document splitting and provide Document simulation facility rather than waiting for period end process.
- Made configuration in the FICO and FI module with a focus on Contract accounting areas, and Integrated with IS-PS.
- Conducted training sessions in the FICO area and cover integration issues FICO and FI in the design/support development after Go-Live.
- Worked on SAP SEM-BCS establishing SAP solution for the creation of consolidated financial statements which is fully integrated into the SAP Netweaver BW platform
- Used SEM-BCS software solution for the creation of consolidated financial statements and is equally suited for statutory reporting and management reporting
- Involved in configuring field status groups, posting keys, inter-company postings, financial statement version, field status variants, validation/substitution, document types, Open and Close Posting Periods and carried out Mass change in G/L, AP and AR.
- Worked with all the A/P and A/R payments in the FI area including the F110 payment program and lockbox.
- Worked on configuration areas of Bank Accounts, House Banks, defined Posting Rules and keys for check deposit, configured variants for Confidential Statement.
Confidential, San Diego, CA
SAP FICO Consultant
Environment: SAP ECC 6.0, Full Confidential Cycle Implementation
Responsibilities:
- Diagnosing and mapping the existing business processes (As-Is Analysis) related to FI-CO. Analyzing how to improve business process and efficiencies using the IS-U system in the FI-CA area (To-Be processes).
- Basic customization for RMCA, FICO Business process .
- Perform Integration Testing in between IS-U Modules and ERP Modules to ensuring processes results requirement based results.
- Provided cross team support for integration touch points between FICO/FICA and other modules such as Billing/Invoicing, Device Management and CRM.
- Made configuration in the FICO and FI module with a focus on Contract accounting areas, and Integrated with IS-PS.
- Conducted training sessions in the FICO area and cover integration issues FICO and FI in the design/support development after Go-Live.
- Participated in the bi-weekly Change Control Board (CCB) meeting for the approval of changes to move to the production client.
- CO-PA Planning with Plan versions, Planning Profiles and Planning layouts and creation of Derivation Structure and derivation rules.
- Integrated Cost Object Controlling (CO-PC-OBJ) component in the SAP System, for planned budget using various costing methods, Cost Split, Cost and Valuation Variants in Product Cost Planning (CO-PC-PCP).
- Configured Cash journals and special GL transactions and configured New G/L for document splitting and provide Document simulation facility rather than waiting for period end process.
- Involved in configuring field status groups, posting keys, inter-company postings, financial statement version, field status variants, validation/substitution, document types, Open and Close Posting Periods and carried out Mass change in G/L, AP and AR
- Worked with all the A/P and A/R payments in the FI area including the F110 payment program and lockbox.
- Worked on configuration areas of Bank Accounts, House Banks, defined Posting Rules and keys for check deposit, configured variants for Confidential Statement.
- Defined the process around creating/distributing invoices, customer correspondences, accounting updates, credit checks, interest calculation/late fee payment terms, dunning forms, reason codes and overall AR tolerances, over/under payment and discounts
- Configured source symbols, planning levels, planning groups, treasury groupings for liquidity forecast, Cash management and Cash concentration
- Worked on SAP SEM-BCS establishing SAP solution for the creation of consolidated financial statements which is fully integrated into the SAP Netweaver BW platform.
- Used SEM-BCS software solution for the creation of consolidated financial statements and is equally suited for statutory reporting and management reporting
- Performed treasury operational functions such as cash management, cash forecasting, interest rate monitoring and forecasting, capital funding and financial derivative analysis
- Provided support on customer and vendor payments posting and clearing, credit management, deduction management, check runs, correspondence and reporting.
- Configured Cost Center Accounting (CCA), maintained standard hierarchy, created cost centers, primary cost element categories, secondary cost element categories, automatic cost element creation, manual cost element creation, activated reconciliation ledger.
- In Profit center accounting created standard hierarchy, profit centers, dummy profit center, defined document types, number range assignment, PCA planning parameters.
- Acquired complete knowledge of the workflow from the creation of sales order to delivery and billing in the Sales & Distribution module.
- LSMW data upload templates, testing and performing data upload. GL balances both cumulative and line item balances including vendor, customer and asset master data were loaded via LSMW technique.
Confidential, Ridgefield Park, NJ
SAP FICO/FSCM Consultant
Environment: SAP ECC 6.0, Full Confidential Cycle Implementation
Responsibilities:
- Defined G/L account groups; created chart of accounts, participated in modifying and uploading G/L accounts, Account Determination with regards to movement types. Worked on assignment of G/L accounts in Transaction OBYC
- Created reconciliation accounts for A/P and A/R;
- Configured Accounts payable (A/P) including vendor account groups, number ranges, tolerance groups; uploaded A/P master data.
- Configured Automatic Payment Program for A/P for checks, Funds Management (FM ), ACH and wire transfer; created check lots
- CO-PA Planning with Plan versions, Planning Profiles and Planning layouts and creation of Derivation Structure and derivation rules.
- Facilitated planning for Product Costing and Cost Object controlling by creating product cost by order, product cost by sales order and product cost by period.
- Integrated Cost Object Controlling (CO-PC-OBJ) component in the SAP System, for planned budget using various costing methods, Cost Split, Cost and Valuation Variants in Product Cost Planning (CO-PC-PCP).
- Configured Cash journals and special GL transactions and configured New G/L for document splitting and provide Document simulation facility rather than waiting for period end process
- Worked on SAP SEM-BCS establishing SAP solution for the creation of consolidated financial statements which is fully integrated into the SAP Netweaver BW platform
- Used SEM-BCS software solution for the creation of consolidated financial statements and is equally suited for statutory reporting and management reporting
- Controlled company’s accounts receivable processes and ensure cash flows through online billing, more streamlined handling of billing disputes and collections using FSCM
- Used Collection management in FSCM to ensure faster collection of delinquent payments. Resolved accounts receivable disputes faster and more systematically through prioritized collection management.
- Managed electronic customer billing disputes, receivables, collections and customer credit risk using FSCM.
- Configured SAP Payment Program, EDI Partner/Port, and payment methods.
- Extensively worked on EDI IDOC (inbound, outbound, mapping with third party logistics service providers’ WM system, message type, segment extension, IDoc monitoring, posting)/ ALE (distribution model maintenance, logical system, ports, partner profiles.
- Foreign Currency Transactions, translation, Valuation, maintaining Exchange rates
- Worked with the business users, validation, and QA teams during Asset cutover to process the Master data transfer from Legacy into the SAP system.
- Planned, conducted meetings on User Acceptance Testing for Asia Pacific, EMEA and North America region, worked with users regarding concerns during UAT and worked in Agile UAT environment.
- Engaged in Dress rehearsal and cutover activities, worked on Pre-Go Live activities and Go Live activities
- Customized Period end closing functions including overhead costing, interest calculation and result analysis and settlement procedures.
- Prepared month end close and setting up the master data for Allocations (Assessments and Distribution).
- Defined variance keys, valuation variants for WIP and scrap, target cost versions for variance calculation and result analysis keys, result analysis version, valuation methods, line ids and assignment for work in process (WIP).
- Defined Costing type, valuation variant, date control, quantity structure control, transfer control and reference variant for defining costing variant in product costing CO-PC.
Confidential, Foster City, CA
SAP FICO/FSCM Consultant
Environment: SAP ECC 6.0, Full Cycle Implementation
Responsibilities:
- Worked in Production Support in Finance (FI), Controlling (CO) & Asset Accounting (AA) and responsible for resolving all IT issues relating to FI, AP, AR, PCA, CCA, CO-PA and CO-PC.
- Documented blue-prints for new company code and configured the system for implementation of CO-CCA, CO-PCA, CO-PA, CO-PC; responsible updating for Finance Work plan for new company code.
- Provided production support for all the issues involved in AP, AR, Special G/L & ERS.
- Involved as a team member in FI - General ledger, Accounts Receivable, Accounts Payable sub-modules and CO - Cost Center Accounting, Cost Element Accounting, Internal
- Used Biller Direct in FSCM for electronic invoicing and payment collection.
- Defined distribution for cash position and liquidity forecast, cash collection strategy in Biller Direct using FSCM.
- Configured Cash journals and special GL transactions and configured New G/L for document splitting and provide Document simulation facility rather than waiting for period end process
- Managed electronic customer billing disputes, receivables, collections and customer credit risk using FSCM.
- Treasury In house cash Management, Electronic bank statements ( EBS ), Lockbox, Cash Concentration, and Liquidity Forecast.
- Identified technical improvements in FSCM and the related interfaces focusing on application sharing and business process optimization.
- Used FSCM to employ tools to analyze credit worthiness and establish policies. Enabled customer access to invoices, account status and payment information over the Internet.
- Controlled company’s accounts receivable processes and ensure cash flows through online billing, more streamlined handling of billing disputes and collections using FSCM.
- Used Collection management in FSCM to ensure faster collection of delinquent payments. Resolved accounts receivable disputes faster and more systematically through prioritized collection management.
- Used Collection Management functionality in FSCM for creating a collection work list, preparing and documenting customer contacts.
- Worked with Customer Logistics Team and gathered requirements for applying Routines and Sub-routines during sales order creation for Credit checks for different customer risk categories and Pricing Conditions.
- Assessment & Distribution Cycles, Budget Uploads, Primary & Secondary cost elements, Activity Types and Statistical Key Figures.
- Worked closely with MM consultants for integration of FI-MM and Procure to Pay.
- CO-PA Planning with Plan versions, Planning Profiles and Planning layouts and creation of Derivation Structure and derivation rules.
- Facilitated planning for Product Costing and Cost Object controlling by creating product cost by order, product cost by sales order and product cost by period.
- Worked on SAP SEM-BCS establishing SAP solution for the creation of consolidated financial statements which is fully integrated into the SAP Netweaver BW platform
- Used SEM-BCS software solution for the creation of consolidated financial statements and is equally suited for statutory reporting and management reporting
- Configured SD Condition records in COPA by creating access sequence; tables, condition types and mapping of these value fields to SD condition types and assigned pricing procedure in COPA.
- Prepared/updated Functional Specs for changes in various interfaces relating to payroll and freight handling, created functional specs for forms/exits/conversions/reports/other developments needed for material costing, AR open deductions/items report, obsolete material report, CO-PA user exit, profit center substitution, material PPV detail report and worked with development team on various enhancements relating to remittance forms, check forms, logo changes and report changes.
Confidential, St. Louis, MO
SAP FI/ Confidential Consultant
Environment: Upgrade from SAP R/3 4.7 to ECC 6.0
Responsibilities:
- Responsible for the cutover of FI - GL, AP, AR open items from SAP R/3 4.7 to SAP ECC 6.0 system.
- 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.7 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.
- Configured Tax Reconciliation account.
- 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
- 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 new version
- Worked on PTP (Procure-To-Pay) business process
- CO-PA Planning with Plan versions, Planning Profiles and Planning layouts and creation of Derivation Structure and derivation rules.
- Facilitated planning for Product Costing and Cost Object controlling by creating product cost by order, product cost by sales order and product cost by period.
- Worked on inter-company clearing and recurring entries.
- Configured and customized Cost center standard hierarchy, defined cost elements, configured settings for assessments, distributions, reporting.
- Documented all changes, revised the business process procedures to facilitate the changes during the upgrade
- Tested FICO modules withnew functionalities. Resolved issues during integration testing
- Performed Go-Live Support to ensure a stable SAP ECC 6.0 system.
Confidential
SAP FICO with Production Engineer
Environment: SAP R/3 4.7 (Enhancement)
Responsibilities:
- Researched and analyzed business processes related to FI/CO, and involved in configuration, testing, support of various functionalities on FI/ Confidential module.
- Configured Company code, Business Area, Functional Area, and Controlling Area.
- Created Reconciliation accounts, and transferred Advances from Reconciliation accounts to Special GL accounts.
- Configured Chart of depreciation, Account determination, Asset classes, Depreciation key, Depreciation areas, and Depreciation running.
- Configured Acquisitions, Retirements, Transfers, and Write-offs and Capitalizations of AUC (Assets under construction).
- Configured Cost element, Cost center, Cost Center hierarchy, Cost Center accounting, Internal Order, Profit center, and Profitability analysis.
- CO-PA Planning with Plan versions, Planning Profiles and Planning layouts and creation of Derivation Structure and derivation rules.
- Facilitated planning for Product Costing and Cost Object controlling by creating product cost by order, product cost by sales order and product cost by period.
- Involved in SD and MM integration for Accounts determination, Material movement’s set up and intercompany billing.
- Designed and prepared training materials for End Users.
- Carried out unit and integration testing, and Post production support.