We provide IT Staff Augmentation Services!

Sap Fico Consultant Resume

5.00/5 (Submit Your Rating)

San Antonio, TX

SUMMARY

  • SAP FICO Consultant with 8 plus years of strong functional experience in the implementation, customization and configuration of SAP FICO module with two full life cycle implementations, with a thorough understanding of integration between MM, SD, CRM, PS modules.
  • Eight plus (8+) years of experience in SAP Finance and Controlling (FICO) modules.
  • Experience working with "ASAP" methodology, with End - to-End Implementation of all stages (Project Preparation, Business Blueprint, Realization, Final Preparation, Go-Live, Hyper Care and Support).
  • Two full life cycle implementation experience with multiple domains.
  • Experience working in diverse domains such as Finance, Oil & Gas, Manufacturing, Pharmaceutical and Retail.
  • Extensively worked in design and configuration of SAP FICO (SAP Enterprise structure, New GL, parallel ledgers, document splitting, Account Payable, Accounts Receivable, Asset Accounting, Cost Element Accounting, Cost Center Accounting, Internal Order, Profit Center Accounting, and COPA.
  • Experience working on functional and technical design document for various RICEFW object with strong techno-functional knowledge.
  • Strong understanding of business workflow, technology, project planning (duration of project, budget estimates, resources, tasks and change management issues etc) and translation of business requirements into SAP solutions.
  • Configured changes in Consolidation task and performed integration testing between special purpose ledger and BCS Consolidation.
  • Report specifications to ABAP programmers regarding report format objects of the report, technical information i.e. tables fields and testing.
  • Worked on lockbox process configuration, bank statement processing, cash management (CM) to monitor payment flows and liquidity and also worked on client's lockbox banks to validate the inbound files.
  • Hands on experience in IDocs, EDI and data upload to SAP table, sending and receiving of data form external system.
  • Extensively worked on BI report mapping of Info cubes coordinating with regular data upload and solve issues on miss match figures in BI and COPA reports.
  • Strong knowledge and worked in Generally Accepted Accounting Principle (GAAP) and (SOX).
  • Excellent team player, great feedback on working with team members, highly motivated with strong analytical and communication skills with an aptitude for success.
  • Exceptional problem solver and decision maker with diverse experience in finance, accounting, and all aspects of office operation, as well as expertise in general accounting, analysis, management, budgeting, cash management, cost accounting, management reporting, inventory.

TECHNICAL SKILLS

ERP System: SAP R/3 versions 4.7, ECC 5.0 and ECC 6.0

Reporting Tools: SAP Queries, Report Painter and Report Writer

Testing Tools: Mercury Tool QAT and Defects Tracking

Methodologies Used: Accelerated SAP (ASAP)

Platforms: C, Java, PL/SQL

Databases: Oracle-9i, MS-SQL Server

Others: HTML, XML, Visio, MS Office

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

SAP FICO Consultant

Environment: SAP ECC 6.0, Life Cycle Implementation

Responsibilities:

  • SAP CO Functional Specialist in providing application and functional implementation of SAP Controlling Module including Product Costing, Cost Center Accounting, Inventory Management, and functionality in ECC 6.0
  • Performed all tasks in system development lifecycle, starting from business process definition to configuration and unit testing, assistance and follow-up with user testing, to co-ordination of transports to production, to training and post go-live support and fixes.
  • Designed and Implemented Product Cost Controlling and Cost Object Controlling, Standard Costing and Period end Closing Process for manufacturing Scenarios Make to Stock.
  • Analyzed business requirements and determined organizational structure, business units, company codes, and profitability centers (AS IS - TO BE)
  • Conducted GAP analysis, documented the findings, assessed scope of studies & suggested solutions through SAP for implementation and customizations. Worked closely with MM, SD and PP-PI consultants so as to ensure that commercial controls and accounting requirements are met as per business process blueprint
  • Defined chart of accounts, GL master records, field status groups, and automatic account determination and sales tax automatic account assignments.
  • Defined adjustment account for GR/IR clearing by configured regrouping postings.
  • Involved in data migration from legacy systems to SAP through LSMW. Extracting Master data & transactions data to Non - R3 format, clean up data, mapping interfaces, loading data into SAP format (IDOC) and testing loaded data.
  • Creation of vendor master records, groups, vendor documents, number ranges, payment terms, discounts, Configured Automatic Payment Program.
  • Configured for vendors subject to withholding tax, interest calculations on item \ balance interest calculation, number ranges for forms, interest on arrears, account balance calculation on account balances / line items
  • Created and defined credit control areas to company code including pre-defined credit limits for customers
  • Configured dunning program, dunning levels, dunning areas and dunning forms for each company at company code level. Configured payment terms for dunning, for over-due interest calculations, for down payments and automatic clearing of line items. Report specifications to ABAP programmers regarding report format objects of the report, technical information i.e. tables fields and then testing
  • Configured and customized integration links between FI/CO/SD/MM/PP to optimize transaction processing
  • Set up Automatic Account Assignments for MM, SD & Intercompany postings.
  • Customized Pricing procedures, Condition technique setting in pricing, Condition records, Special functions, new condition types, access sequences.
  • ConfiguredFI-SDintegrationinterface in the area of Enterprise Structure, and Revenue accounts determination through VKOA, mapping required GL accounts to the account keys
  • Configured Partner Determination Procedure, Text Determination account assignment and automatic Account determination and integration with FI module as per business requirements.
  • Eliminated duplicate inter-company AR/AP postings in Cross-Company Sales Orders and ensured thatSDBilling Document Invoices were posted in FI.
  • Worked on bill of exchange configuration and processing in FI-AR (Account Receivable) by configuring the reconciliation accounts in the special GL.
  • Defined customer master records, customer groups, House bank.
  • Defined and assigned reconciliation ledgers and maintaining accounts for automatic reconciliation posting.
  • Maintained Controlling area settings and made hierarchy and other assignments
  • In Cost Element Accounting created Primary and secondary Cost elements, created Cost Element Groups, Configured the reconciliation ledgers
  • In Cost Center Accounting (CO-CCA) created the cost centers and maintained the Standard hierarchy, assigned cost centers to cost elements. Configured Activities, Statistical Key Figures
  • Developed cost sheet, cycles, segments for cost center distributions and assessment to allocate manufacturing overhead cost-to-cost objects. Configured settlements, cost splits for Activity Price calculations. Setup internal orders and cost collector configuration
  • In Internal Orders configured various internal order types, setup status profile for order type, maintained settlement rules, internal order planning, and budget profile and also set up tolerances for budget cost. Defined the settlement rules, and used internal order with AUC /Capital investment projects,
  • In Profit Center Accounting maintained the basic setting, created hierarchy, dummy profit centers, Profit center master data, profit center groups, activity types, etc and extracted reports using PCA
  • In Asset Management configured asset classes, master depreciation and other business transactions. Fixed asset accounting, reconcile asset management to GL.
  • Configured the chart of depreciation and settings up the various depreciation areas like book depreciation.
  • Worked on special purpose ledger (FI-SL) for special reporting needs at cost center, profit center and business area level. Created and maintained special ledger table groups.
  • Configured document splitting for special purpose ledger, and developed reports using report painter.
  • Worked on lockbox process configuration, bank statement processing, cash management (CM) to monitor payment flows and liquidity and also worked on client's lockbox banks to validate the inbound files.
  • Technical proficiency in implementation of major functionalities like Electronic/Manual Bank Statements, Payments, Electronic and Manual Check deposit, Payment Advices, complete Check Management functionality.

Confidential, Sarasota, FL

SAP FICO Consultant

Environment: SAP ECC 6.0, Implementation

Responsibilities:

  • Collected and analyzed user’s business requirements identified and defined areas for improvements, prepared specifications for development, configuration, troubleshooting and supporting for systems users.
  • Analysis of all open items, foreign currency revaluation, reclassification of payable and receivable, clearing of goods receipt/invoice receipt GI/IR accounts, performing reconciliation s, profitability allocations by business area.
  • Configured company code which includes creating chart of accounts, defined posting period variant, retained earnings account, document types, and tolerance groups for employees, created financial statement version.
  • Followed ASAP Implementation methodology and designed the business processes, wrote blueprint phase documentation and completed Configuration during realization phase.
  • Designed the process of payment proposal approvals for different payment methods like ACH, Wire, Check and P-cards in A/P.
  • Involved in modeling of invoice processing, Disbursement run, check printing and bank reconciliation processes for A/P.
  • Eliminated Duplicated Inter-Company AR/AP Postings in Cross-Company Sales Orders, Ensured That SD Billing Document Invoices Are Posted in FI.
  • Worked on bill of exchange configuration and processing in FI-AR by configuring the reconciliation accounts in the special GL.
  • Worked on customer transactions, Master data, Payment terms, Cash application, Lockbox processing, Mapping Bank Lockbox format with Sap lockbox format, customizing payment advice notes on Accounts Receivable (A/R).
  • Worked on Correspondence types on A/R that means different outputs, which can be printed and sent to your business partners based around customer G/L information.
  • Worked with MM, SD teams and routinely performed FI-SD (Order-to-Cash) and FI-MM (Procure-to-Pay) integration through MIRO (Invoice Verification) and MIGO (Goods Receipt)
  • Worked on day to day user issues in MM and SD (collective billing, netting, invoicing, provisional invoicing, differential invoicing etc.)
  • Configured tax with third party tools/tax engine Vertex and tax ware.
  • HP Quality Center for testing the scenarios sales order cycle, ordered to cash, pricing and promotions
  • Responsible for A/R customer transactions, credit management, check printing, payment terms, Cash application, Lockbox processing, Cash receipts, clearing and month end and Year-end activities.
  • 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.
  • Managed electronic customer billing disputes, receivables, collections and customer credit risk using FSCM.
  • 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.
  • Used Collection Management functionality in FSCM for creating a collection work list, preparing and documenting customer contacts.
  • Cleaned Legacy Customer Master Data. Reviewed customer address data, Credit limits, Dunning, Line item displays and carry forward balances.
  • Configured Automatic Payment Program for Check, Wire and ACH payments.
  • Worked on Logistics Invoice Verification (LIV or GR-IR verification) in FI-MM (Procure to Pay) integration and configured account determination for FI-SD (Order to Cash) cycles.
  • Created Bank Master data, House banks, EDI, ERS, G/L accounts for each bank account and Reconciliation accounts for vendors, customers and assets.
  • Provided functional assistance in the development of RICEF (Reports, Interfaces, Conversions, Enhancements and Forms).
  • Created custom KE31 reports for the management and users in CO-PA.
  • 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.
  • Worked on Business Add-ins (BADI) and user exit while working on Enhancement ofSD-FI interface for preparing the Revenue account determination process.
  • Resolved end-user issues involved in cost roll, WIP calculation, variance calculation and period end settlement in different plants
  • Analyzed variances in order summarization hierarchy and implemented improvements to period end process order confirmation procedures.
  • Analyzed problems with period end production variance reports, and tested and implemented OSS note fixes.
  • By setting the status to TECO that were not billable, resolved issues in Product cost by Sales order / Production order.
  • Configured Cost component structure and roll ups, BOM. Set up material cost estimate with quantity structure.

Confidential, Houston, TX

SAP FI Analyst

Environment: SAP ECC 6.0 Support

Responsibilities:

  • Gathered requirements for JVA legal entities.
  • Configured Joint Venture Company codes for petroleum division.
  • Wrote scripts for integration test and performed testing for scenarios: Goods receipts and issues, Project costs, Operating expenses and revenue, Acquisition, Transfer, Retirements, Assessments and distributions
  • Prepared coaching guide for Joint Venture accounting processes and Month end steps.
  • Resolving issues on Different methods of Payment run via F110 for AP team
  • Perform regular FICO Validation based on the production server patch implementations and communicating to the End Users
  • EDI E Invoice Setup in FTP for Processing the Invoices for Purchase Orders
  • Creating New GL Accounts for Bank Accounts to process the Lockbox activities for new House Bank setups
  • Creating New Payment Methods in FBZP for making payments to vendors for various company codes
  • Open and Close Posting Periods in OB52 by customized ABAP program with variants in each segment of FI areas.
  • Production Support issues on Bug fixes, Maintenance and enhancements.
  • Check Printing Program for F110 Payment Run on Payment Method B & C
  • Check layout design with ABAP team on SAP Script for ABAP customized check-printing program.
  • Performed master data migration of Joint Ventures, Joint operating agreements.
  • Resolved functional issues with North and South America users in various areas of FICO
  • Performed master data changes in Consolidation units, Hierarchies, Financial versions of Plan, Budget and Actual.
  • Configured changes in Consolidation task and performed integration testing between special purpose ledger and SEM-BCS Consolidation.

Confidential, Chicago, IL

SAP FICO Business Analyst

Environment: SAP ECC 6.0 Support

Responsibilities:

  • Determinewhatfunctionalityisrequiredin terms of design, structure and configuration, in line with internal guidelines and procedures, in order to translate the IT requirements into an optimum IT solution.
  • Program, document and maintain (parts of) the product, based on current design methods and techniques, in order to ensure that the product runs according to the specifications.
  • Test, analyze test results and repair new products in a development, test and production environment, in order to develop a product that can be implemented.
  • Performed complete unit testing (UT) of GL, AP and AR and Involved with other core team members to perform Integration testing (IT) across the FI, MM and SD.
  • Co-ordinate with offshore ABAP team on a day to day basis provide technical specs to develop customized solutions
  • Prioritize solution implementation steps according to the most crucial business process improvements, in order to structure the development process.
  • Identify business benefits versus cost of design, building and implementation, in order to realize cost-effective IT solutions.
  • Training IT users in using the IT product, in line with the developed guidelines, to ensure that the productishandled in the correct way.
  • Designing, customizing, testing and implementing local IT solutions.
  • Demonstrates expertise with one or more technology environments, and the ability to learn and apply new and emerging concepts efficiently.
  • Provides technical coaching to other staff members.
  • Demonstrates a strong understanding of the inter-operability of technologies.
  • Assessed the tradeoffs between business needs, technology requirements and costs.
  • Select optimum methods, use new methods, design new interfaces.
  • Independently performs analyses to resolve complex first-time project issues.
  • Designs projects, requiring systems integration of one or more technical platforms.
  • Functions independently with limited work direction. Workisreviewed periodically and on an exception basis.
  • Selects tools and methodologies for projects.
  • Commits to deliverables with customers and/or management.
  • Delivery of specific IT solutions for some business processes, immediate environment.

Confidential, Mars, PA

FICO Consultant

Environment: SAP ECC 5.0Production Support

Responsibilities:

  • Maintained Cost Center Standard Hierarchy, write substitution rules to assign cost centers automatically to G/L accounts according to requirements, defined distribution and assessment cycles for monthly allocations.
  • Worked on FI-SD account determination rule to accurately capture the accounting requirement during Billing and PGI.
  • Involved in the customization of dunning program including creation of the dunning proposals and also editing the dunning proposals.
  • Configured Lockbox Processing program, House Banks with SWIFT code, defining lockbox accounts at House banks, defined lockbox parameters and posted data and tested the lockbox functionality.
  • Configured and Tested the Lockbox program for Accounts Receivables payments in BAI2 Format.
  • In Profit Center Accounting, maintained the basic settings, created Master Data for Profit Centers, Profit Center groups, Dummy Profit Center, Profit Center Hierarchy, Activity Types and assigned different Controlling Objects to Profit Center Accounting.
  • Created report painter and report writer for Profit Center Accounting reporting.
  • Configured planning in PCA - versions, planning layout, planning profile and plan allocations. In EC-PCA created profit center standard hierarchy, dummy profit center, profit centers, profit center groups. Analysis using account assignment monitor.
  • Worked extensively on developing data models for COPA reporting utilizing both Costing based and Account based data source.
  • Worked extensively on the COPA design in integration with SD. Mapping of Value fields to Condition types. Develop COPA derived Characteristics using Derivation rule, Enhancements (User exits), Table move.
  • Configured Summarization Level to in corporate new COPA characteristics for COPA reporting.
  • Developed various COPA report based on the business requirement.
  • In Product Costing, created Costing Variant, Cost Component structure, Configured Material Cost Estimate with quantity structure, maintained settlement structures, configured WIP and Price variance calculations and settlement of Variance to Profitability Analysis; Create, mark and release of cost estimate.
  • Maintained settings for Costing Sheet like calculation bases, percentage overhead rates, and quantity based overhead rate in Product Costing (CO-PC)
  • Configured Material Cost Estimate with Quantity Structure and costing variant for cost component structures like BOM and Routing for the products provided by PP. Worked on integration of PP with SAP-FICO module.
  • 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.
  • Participated in integration testing and supported User Acceptance Testing (UAT)

Confidential, Emeryville, CA

Business System Analyst

Responsibilities:

  • Generate reports on Business Overview, Profitability and Sales Commissions for Senior Management Team.
  • Publish reports on regular basis for Management team: Cockpit Charts, Sales Performance, Outstanding, Stock Consumption, New Lost Existing Customers, Stock Classification and Sales call analysis.
  • Provide ROI analysis for all Marketing and Sales activities.
  • Updating & maintaining Customer database class for publishing Sigma industry mix charts.
  • Reviewed 4010 and 5010 HIPAA guidelines for 837 transaction, performed GAP Analysis and documented it
  • Conducted meetings with Business owners, SME (Subject Matter Experts) to do a walkthrough of the GAP Analysis document
  • Prepared Data Mapping documents to link various claim types and provider data to portal fields for accurate claims status reporting and content display for provider visibility and satisfaction.
  • Defined new set of validity, translation and compatibility custom edits along with HIPAA HL7 edits for the system in order to process the new 5010 version of claims format
  • Implementation of CRM system for tracking Customer Business history and to develop new business leads.
  • Develop new leads for the company through market visits and market intelligence.
  • Publish reports for monitoring: Bad debts, Bad debt forecasting, Collections, Segment wise Aging, Debt provision.
  • To support financial analysis in the absence of Finance Analyst.
  • Publish reports for monitoring and analyzing business process indicators: Customer order cycle time, Turnaround Service Cycle time and others.
  • Publish reports on a regular basis for analyzing Landed Cost and Purchase trend segment wise.
  • Support in Purchase Requisition process.
  • Tracking, Analyzing and Reporting Item creation trend
  • Publish reports for monitoring and analyzing segment wise delivery, stock overview and stock provision.
  • Provide complete ERP support for Reporting and Business Monitoring.

Confidential

Account/ Office Manager

Responsibilities:

  • Plan, organize, direct and control the operations of finance, transportation and purchase and sales.
  • Develop and implement the financial policies, systems and procedures of the company.
  • Prepare and co-ordinate the preparation of financial statements, estimates, summaries and other financial analysis and management reports.
  • Evaluate financial reporting systems, accounting procedures and investment activities and make recommendations for changes to procedures, operating systems, budgets and other financial control functions to the management.
  • Introduced work processes that improved efficiency in activities and work productivity.
  • Prepare monthly statements and assist the accounting firm to make yearly financial statements.
  • Maintain payroll and stock.

We'd love your feedback!