Sr. Sap Fi/co Consultant Resume
Harrisburg, PA
- A finance professional with 8+ years of experience with expertise in planning, analysis and implementation including 3 full life cycle implementations in SAP FICO.
- Excellent domain expertise, functional knowledge and understanding on finance and controlling.
- Strong functional experience in implementing, configuring, integrating, testing, documenting, user training and support in SAP ECC 6.0.
- Experience in business blueprints preparation for the processes and specified the requirements.
- Preparation of documentation and flow charts, collecting the master data, testing and reviewing training documentation.
- Expertise with functional requirement definition, process improvement, and project scope definition, gap analysis, configuration, testing, documentation and support in SAP FICO.
- Excellent SAP FICO configuration skills in general ledger, accounts receivable and accounts payable, basic controlling, cost element accounting, cost center accounting, internal orders, profit center accounting, product cost controlling, profitability analysis, newGL, lockbox processing, foreign currency valuation/translation.
- Strong knowledge in Integration of FI/CO, SD and MM including Procure to pay (P2P).
- Experience in preparation of report design and report creation using report painter, SAP Query.
- Assist in User Acceptance testing (UAT) and hands-on experience in debugging.
- Exceptionally proficient in identifying and solving problems while thinking outside the box; hands-on but capable of interacting with all levels of management and employees.
- Experienced in providing direction and leading cross-functional work teams without a direct reporting relationship.
- Possesses a good understanding of IT project management principles, tools and methodologies.
- Experience in improving business processes to reduce rework on various office functions, multi-tasking among different projects.
- Manages and delivers projects on time, on budget, and meeting or exceeding quality expectations.
SAP Configuration Skills:
- FI Enterprise Structure: Chart of accounts, fiscal year, posting period, company code, business areas, and functional areas.
- General Ledger: Chart of accounts, account groups, GL master records, field status groups, posting keys, automatic account determination, inter-company automatic account posting, sales/use tax assignment, account display, number ranges, document types, tolerance groups and financial statement versions.
- Accounts Payable: Vendor groups, vendor master data, house banks, bank accounts, check lots, automatic payments, recurring entries, invoices, credit memos, closing procedures, AP information system, integration with MM.
- Accounts Receivable: Customer groups, customer master data, billing, payment terms and interest calculation, incoming payments, dunning, AR information system, account systems, credit management, cash discounts, closing operations, sales order and integration with SD.
- Product Costing: Configuring overhead, costing sheet, cost component structure, valuation variant, costing variant and made the assignments, material cost estimate with quantity structure, material only costs, performing costing run for individual and mass materials.
- Cost Element/Cost Center Accounting (CCA): Configuring and customizing the cost elements, reconciliation ledgers, standard hierarchy, cost centers, statistical key figures, master data groups, validations and substitutions, assessments, distributions. Cost center planning including defining versions, planning layouts, planner profiles and activity planning.
- Internal Orders (IO): Configuring and customizing internal orders, order types, screen layout, status management, order groups, substitution rules, commitments, settlement profiles, planning, budget management and availability control.
- Profit Center Accounting (PCA): Planning, profit center, revenue elements, sales order, material master assignment, control parameters and integration with SD.
- Profitability Analysis (COPA): Cost based COPA, planning, planning versions, operating concern, characteristics, value fields, PA – tables, mapping SD condition types to value fields characteristic derivation, reports and transports on profitability analysis.
- Financial Statements: Financial closing of GL, accruals and deferrals for revenues and expenses, GR/IR accounts, creation of a financial statement version for local and foreign subsidiaries.
Client: Jackson, Michigan July 11- Present
Industry: IS-Utilities(Public Sector)
Title: Sr.SAP FI Functional Support Analyst
Project Scope: Worked on Major enhancements,configuration, testing and go live phase
Version: 5H/ECC 6.0
Responsibilities:
- Worked on various Production Change Requests (PCRs) on Finance and AP related Issues. This involved documenting the detailed description of the configuration changes to the SAP production system. Analyzing the changes and business impact of these changes. And documenting the approval response including change implementation information.
- Configured, maintained and trouble shoot business processes in support of the SAP utility ERP-FI module include Accounts Payable, Banks, General Ledger, etc.
- Was Primary team member and responsible for solving the problems/issues with the user, configure and test SAP for change requests, Incident tickets and design and test development objects for the new enhancements needed.
- Support role involved break fixes for Production issues on FI modules and also new Enhancements to facilitate additional functionality requests for the business.
- As an on-site coordinator, worked with the offshore team in India in managing the HP Service Manager for ticket handling for changes and bug fixes to make sure the fixes were done in a timely manner and per the CMS standards.
- Involved in the Test Director testing for the implemented changes.
- Interacted with the client in gathering business requirement, creating business requirement document, and functional design document.
- Created Functional Specification Documents for the enhancements required in AP to enable ABAP programmers to develop custom programs.
- Worked as a liaison between the End-Users and ABAP programmers to cater to the client’s requirements from time to time.
- Involved as one of the senior team members of FI and carried out configuration and enhancements based on the requirements of the client.
- Performed unit, Integration and regression testing and created the test scripts for the tests in HP Quality Center
- Tested AP scenarios: - Vendor master maintenance, vendor invoice and credit memo postings, park and posting parked invoices, automatic payment program for check payments, ACH payments, wire payments, manual outgoing payments, defining check lots, release blocked invoices, cancel vendor invoice posted through invoice verification, price variance, quantity variance, unplanned delivery costs, evaluated receipt settlement printing the check with the existing check number, printing the checks without payment program, cancel payment, reinstate the check information in the check register and AP reporting, void checks, reprint the checks, linking of Vendor documents with EDI
- Helped in documenting Business Process Procedures.
- Responsible for overall lookout of SAP Invoice Management, Payments and downstream Finance transactions Procure-To-Pay and other integrated work processes and other AP issues pertaining within the organization.
- Responsible for Automatic Payment Program for payments to vendors; check lots, void & reissue of checks, online cash and blockage of payments for certain vendors.
- Tested automatic payment run F110 for incoming/outgoing payments.
- Also worked with the Positive Pay interface for Vendors and configured partner profiles for the banks.
- Configured One-time Vendors with Separate Screen Layouts.
- Resolved Interface related issues such as Data upload and download from legacy to SAP.
- Analysed Workflow for the Payment Request for Vendors to design solutions and designed the To-Be Solution and gathered functional requirements for the to-be system.
- Responsible for designing and working with the custom Ardmore interface for freight charges for Vendors and check whether the invoices got posted to SAP.
- Supported a team member in recording the travel expenses for monthly and semi- monthly Employees for our customised web portal
- Co-ordinated with the HR and Security team for the Employee set up for recording the Travel Expenses for the Employees
- Experienced in job scheduling and back ground processing and responsible for checking the jobs run without any issues.
- Involved in FI-MM integration: Worked with MM team to configure movement type, material type, and valuation group. Automatic Account Determination of GR/IR through OBYC using t-key WRX.
- Month-end FI closing, Period closing and opening in FI. Adding/Deleting/Modifying Financial Statement versions in GL, Running Clearing procedures for GR/IR.
- Generated reports using Report Painter, Documentation for end users, end user training and User acceptance testing.
- Supported and worked with the MM team for posting the invoices for several Vendors and also worked with the FI-MM integration. Supported issues related to inbound and outbound processes for Electronic Data Interchange EDI.
- Worked on EBS, check deposits, check forms and wire transfer and ACH Payment, Payment Order / Remittance Advice for EDI 820.
- Reprocessed the Idoc to change the status of Idoc.
- Process designed for PROCARD expense recording and payment process
- Subscriptions Billing and payment process for Vendor Payments
- Configuration of CONCUR Employee travel and non-travel expenses Credit Card Automatic payments through JP Morgan Bank.
- Configured and settled Some vendor payments through Credit Card processing
- Worked on Lockbox processing configured for BAI2 format taking the flexibility feature , worked on Cash Management, cashbook, short term cash forecast, Credit Management and Invoice verification, Prepared bank reconciliation statements made Payments via EDI to Banks for checks, ACH and wires.
- Developed CATT Scripts to load the legacy data. Used CATT Scripts and LSMW to load the legacy data in to SAP.
Client: Houston, TX Apr 10 – June 11
Title: Sr. SAP FI/CO Functional Analyst
Project Scope: Full life cycle implementation (New GL Migration)
Version:ECC6.0
Responsibilities:
- Studied And Understood the Changes in the Standard SAP System for the new version and prepare change configuration scripts.
- Was a Team member of the customization and implementation group of the FI/CO Module
- Interacted with Business Users for Requirements Gathering and Analysis.
- Prepared a document of all the changes made, revised the Business Process Procedures (BPP’s) to facilitate the changes during the Upgrade.
- Supported all phases of a Project Life Cycle Including Analysis, Design, Development, Testing, and Deployment of Solutions, as well as Documentation, and End-User Training.
- Configuration of New G/L.
- Created Blue Print for New G/L, Plan of Migration, Tested and Performed Migration.
- Activated New General Ledger, Created Leading and Non Leading Ledgers for the different Company Codes.
- In Document Splitting defined Splitting Characteristics, and Activated Document Splitting.
- Activated Parallel Accounting for the Different Accounting Principles like US GAAP and other countries.
Foreign Currency Reporting :
- Foreign Currency Valuation (foreign currency to local currency) is ran for all the balance sheet and P&L accounts
- Generated the equivalent USD amount using Foreign Currency Translation (converts Local à Group).
- Configured a new Valuation Method and Valuation area for translating the BS accounts using the S (spot) rate and all the P&L accounts using the business provided 1003 rate.
- Maintained the S (spot rate for all BS a/c) and “1003” rate (P&L accounts) in exchange rate maintenance table.
- Developed LSMW for the creation of more than 200 translation balance sheet and P&L adjustment accounts for each MR item in the financial statement version for all the four foreign subsidiaries.
- Created additional accounts manually and configured them in the revaluation according to the business requirement.
- Mapped the adjustment accounts in the translation hierarchy and PCA account groups of the foreign company codes which are used as the statement versions.
- Configured the account determination for currency translation using the table V_FAGL_T030TR.
- Mapped the FS items of the financial statement version to the balance sheet adjustment account, gain/loss account to post the translation difference.
- SAP calculates the translation on the YTD amount where as the fixed assets should take the cumulative amount.
- ABAP Custom program was developed as a part of functional specifications to create the report that calculates the FASB52 for fixed assets which is not possible directly from SAP.
- Defined Chart of accounts, Assigned company code to Chart of accounts, Transported chart of accounts, Defined Account Group, Defined retained earnings account, Assigned number range to document type, Defined Field status variant, Defined variants for open posting periods, Open and close posting periods, Assigned variants to company code, Assigned company code to field status variant, Defined tolerance groups for employees, Maintained fast entry screens for G/L account items.
- Configured House Banks, Bank Accounts, Bank Account G/L Structure, Check Lots, Void Reason codes etc.
- Configured Vendor Groups & Assigned number ranges to vendor groups.
- Maintained Vendor Group Field Status for General Data, Company Code Data & Purchasing Data which reflected on the Vendor Master Records.
- Maintained Employee Tolerance Groups & Customer Tolerance Groups.
- Worked on Vendor master, Customer master, & open item (for GL, AR & AP) conversion using LSMW & BAPI’s.
- Used CATT Scripts and LSMW to load the legacy data in to SAP.
- Integrated FI with MM & SD modules.
- Configured OBYC and VKOA as part of MM & SD integration with FI.
- Configuration of various areas including purchasing and Inventory Management.
- Configure withholding taxes for Italy and Germany, deferred taxes for France as well as correct previously implemented Canadian taxes from both and FI and SD perspective (this was by working with the condition type).
- Configured the US and Canada tax procedures and rates as per the jurisdiction, Worked on SAP Integration and Certification Center like Vertex and provided high quality solution to end user in calculating tax within the SAP Solution Manager.
- Extensively worked on Tax accounting and configured TAX codes for EDI procedures, Configured Tax clearing accounts, accounts for withholding taxes,tax forms, tax reports, accounts for down payments,
- Used Vertex to consolidate and determine all the domestic and international taxes.
- Trained users to work on calculation and reporting taxes on a single platform to give them a better control on transaction tax compliance and make sure tax liability is determined accurately.
Client: Harrisburg, PA Apr 09 – Feb 10
Title: Sr. SAP FI/CO Consultant
Version:ECC6.0
Responsibilities:
- Prepared the functional specifications ofTyco Electronics for implementingProduct Costing and COPA.
- Analyzed and reviewed processes, user procedures, documented the changes to be done and involved in user meetings to get the requirements.
- Configured the account determination and integration between FI, MM, and SD in P2P and OTC processes.
- Configured settings for controlling area, assigned new company codes to controlling area and maintained versions.
- Cost element analysis configuration involving the creation and activation of primary and secondary cost elements for different business processes.
- Created new cost center hierarchy nodes and cost centers, changed cost center categories, maintained existing cost center master data, statistical key figures and automatic account assignments.
- Configured the allocation structure for assessment run according to the business requirement.
- Created internal orders for various project implementations, assigned the costs incurred by internal orders to different cost centers.
- Created a distribution cycle to allocate the costs incurred by internal orders to the respective cost centers from a generic cost center.
CO-Product Cost Controlling
- Configured product costing (CO-PC) which includes costing type, valuation variants, transfer control, date and quantity structure control within costing variant.
- Created several primary cost elements, material accounts including raw material consumption accounts, packaging material and semi-finished goods consumption accounts.
- Configured the primary cost elements in the automatic account determination and with right general modification depending on the business transaction.
- Created the activity types for labor and machine activities and populated the activity prices
- Worked with the production planning consultants and assisted them in the creation of work centers, BOM and routing for activities on the work floor.
- Configured the bases, overhead rates, credits, assigned it in the costing sheet and then to the valuation variant for calculating the overhead costs of the materials.
- Crated and configured the material revaluation account for increase of decrease of the overall stock value.
- Created a Z-Result analysis key from the standard RA key and configured the version for result analysis.
- Configured the WIP valuation methods for Release state, Delivered and Technically Completed stages.
- Configured the Line item IDs for settled costs, material costs and overhead costs.
- Created the WIP primary and secondary cost elements and assigned it in the configuration.
- Tracked the accounting documents generated for every activity on the floor and involved in the month end tasks like posting the WIP, variance and settlement.
- Created and configured the production variance account and value of finished goods account.
CO-Profitability Analysis
- Configured settings for operating concern, added several characteristics and value fields according to business requirement.
- Configured to make the data flow from SD into CO-PA by maintaining necessary setting for condition types to value fields in KE4i.
- Created the revenue and discount cost element groups and maintained the PA transfer structure where the groups are mapped to value fields to make the revenues and discounts from FI flow to COPA
- Transferred the expenses from FI cost centers to COPA by creating the assessment cycle
- Mapped different variances like input price variance, resource usage variance, quantity variance, scrap variance and other variances to value fields in COPA
- Configured valuation strategy, maintained the costing key at the material type level, created custom value fields and assigned the cost component line items to value fields.
- Created additional quantity field to transfer the sales order cost estimate and billing quantity to COPA
- Maintained the derivation rules for region characteristic depending on the customer account assignment.
- Created reports in COPA based on various customer characteristics like region of the customer, product, customer account assignment, sales area, material, tracked the open demand and operating margin.
- Trained the users about various functionalities in SAP like costing, posting WIP, variance and prepared user training manuals.
Client: Parsippany, NJ Dec 08 – Mar 09
Title: SAP FICO Functional Analyst
Version:ECC 4.7C
Responsibilities:
- Gathered business requirements for implementing FI-AP& FI-ARand defined the business process procedures as per the client\'s requirementskeeping in view the industrypractices.
- Defined customer and vendor account groups with screen layout, created number ranges and assigned to account groups.
- Configured the strategy for bank GL account structure for various payment methods to keep the balance in the bank GL account in sync with the bank account.
- Configured the Automatic Payment Program: defined the paying company code data, country payment methods, company code payment methods and bank selection in which the ranking order has been assigned.
- Developed the functional specs and worked with the ABAPer for creating a Z-payment advice form.
- Extensively used LSMW to create large number of master data for customer master, vendor master, material master, GL accounts etc.
- Worked with team members forautomatic account determinationofFIwithMMandSD.
- Generated the accounting documents after sales order got delivered and created the billing document.
- Configured the terms of payment and interest indicator, interest program run for interest calculation.
- Configured the reason codes, assigned the accounts for over/under payments, cash discount and for write off.
- Conductedunit test, scenario testandintegration testand prepared document.
- Documented the critical changes,trainedthe team members ,end user team about new system functionality, prepared business process documents and user training manuals.
- Analyzed and reviewed processes, user procedures, and system requirements, performed unit testing, worked on SAP FICO end user training and created user documents.
- Production Support after the implementation has gone live.
Client: Vienna, VA June06 – Oct 08
Title: SAP FI/CO Analyst
Version:R/3 4.6C
Responsibilities:
- Tasked 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.
- Analyzed Workflow to design solutions and designed the To-Be Solution and gathered functional requirements for the to-be system.
- 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 the house banks, G/L accounts for Bank accounts and bank account reconciliation program and Defined forms of payment guarantee, defined and assigned payment guarantee, activated documentary payments per item category.
- Maintained number ranges for vendor and customer groups and also 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.
- Experience working on Lockbox processing configured for BAI2 format taking the flexibility feature , worked on Cash Management, cashbook, short term cash forecast, Credit Management and Invoice verification, Prepared bank reconciliation statements made Payments via EDI to Banks for checks, ACH and wires
- Worked on GL master, Vendor master, Customer master, & open item (for GL, AR & AP) conversion using LSMW & BAPI’s.
- Configured Global Settings for Company code, Fiscal year variant, Chart of accounts, posting periods variant, field status variants and field status groups.
- Configured Account groups and retained earning accounts to create GL Master.
- Integration of MM and SD with FI accounts assignment.
- Created primary and secondary cost elements, standard hierarchy, cost center groups and cost centers, activity types
- Created Statistical Key Figures which were used as tracing factors for periodic allocations, Periodic reposting of particular costs in which Cost Center Groups were used as receivers
- Defined Automatic Account Assignment, and planning layouts for cost center planning
- Created standard hierarchy, profit centers and dummy profit center, profit center groups, maintained Planner Profiles and defined Distribution, created Assessment Cost Elements and defined Assessments
Client: Hyderabad, India May 04– Apr 06
Version:R/3 4.6C
Responsibilities:
- Worked Creation of G/L Master Data, Chart of Accounts, Fiscal Year and Posting Period
- Configuring Organizational Units and Basic Settings, Taxes, Documents
- Assigning of GL accounts to Financial Statement Versions.
- Setting up of user-defined Special G/L for reporting purposes.
- Experienced In Travel & Expense
- Configuration of Clearing and Reversal Accounts, Manual Accruals, Internal Correspondence, Balance Interest Calculation and Information System
- Reports configuration in Day-End Closing, Month-End Closing, Year-End Closing, Notes on Programs, Starting Programs and Printing Lists
- Configuration of Fiscal Year, Financial Statement Versions, Preparing Financial Statements, Planning and Documenting Posting Data
- Configuring Business Areas in General Ledger Accounting, Asset Accounting, Accounts Receivable, Accounts Payable, Cost Accounting and Material Management
- Configuring Posting Document, Posting Key, Processing Posted Data, Updating Entered Data, Automatic Postings
- Designing Screen Layout, Preference Methods for Posting, Posting Documents in Foreign Currency, Cross-Company Code Transactions
- Experience in working in a global environment, work with multiple teams across multiple regions
- Configuring for open item processing, Preparing the functional specifications and testing of the report, Invoice verifications through MIRO, Open item clearing and Down payment
- Configuring automatic payment program and configuring dunning
- Reviewed Organizational structure, Asset Classes, Integration with GL, Valuations, master data, Transaction types, data transfer, Settlement of Asset under construction, validations and Substitutions
- Mapping Business Process to Blue prints
- Special Purpose ledger Configuring and Customizing master data, defining tables, activities and field movements, maintaining sets, rollup ledgers, developing various reports using the Report Writer and Report Painter
- Helped troubleshoot and resolve trouble tickets from users for SAP Applications, in the module areas of CO Controlling, Finance (GL, AP, AR), and integration points between FI and MM/SD.
Client: Hyderabad, India Jun 03– Apr 04
Title: Business Analyst
Responsibilities:
- Worked closely with the business and project team members to evaluate business needs, defining and prioritizing requirements and agreeing process flows and analytical capabilities that align wherever possible with leading practice business processes.
- Involved in the study of As Is business process and blueprinting to be processes with gap analysis and identifying custom development objects during implementation.
- Provided Training and Conducted Practice and Additional Business Requirements sessions for change requests.
- Carried data migration involving establishment of conversion strategy, detailed mapping of legacy data elements, conversion and testing.
- Conducted and Prepared Test Scripts, Training manuals, End User Guides for all modules and all related documentation of the Project.