Sap Fi/co Consultant Resume
Auburn, IN
SUMMARY
- Over all 19 years of IT and Finance experience including recent 8 + years of SAP FI/CO experience as a Functional Consultant during Blue Print/Design, Realization, Customization/Configuration, Integration, Testing, Go - Live & Support.
- FI expertise in New General Ledger FI-GL, Accounts Payable FI-AP, Accounts Receivable FI-AR and Fixed Assets FI-AA.
- CO expertise Cost Center/Cost Element Accounting, Internal Order Accounting, Profit Center Accounting and Profitability Analysis (COPA).
- Strong qualifications in Business Re-Organization, Business Process Re-engineering, Project Management, and Finance.
- Focused on analysis, design, development and implementation of the financial modules in the most cost effective manner.
- Sound knowledge in integrating FI with SD and MM modules.
- Involved in preparing and executing integration test scripts and User acceptance test scripts
- Participated in ongoing Production Support
- Ensured FICO application user issues are addressed in accordance with the business priorities
- Excellent communication, presentation and knowledge transfer skills
- Strong experience of analyzing the clients business processes and developing the best business practices for long-term growth.
- Expertise in pre-implementation study, end-user training & preparing training manuals.
- Good knowledge in FI-MM, FI-SD, FI-PS Integration Scenarios.
- Worked with LSMW for loading multiple master data
- Worked on BW reporting and analytics.
- Excellent time management skills with an ability to prioritize and meet deadlines.
TECHNICAL SKILLS
FI Enterprise Structure: Company, Company code, Business Areas, Functional Areas, Fiscal Year Variant and Posting Period Variant
General Ledger: New GL, Chart of Accounts, Field Status Groups, Posting Key Configuration, Automatic Account Determination, G/L Display configurations, Tolerance Groups, Number Ranges and Document Types.
Accounts Payable: Creation of House Banks and Bank Accounts, Check lots, Payment Program Configuration and Creation of Vendor Master Data and Vendor Groups. Vendor Invoice Management. Configured Account determination between MM and FI.
Accounts Receivable: Creation of Customer Master Records, Creation of Terms of Payment and Interest Calculation, Reason Codes, Default Account Assignment and Dunning.
Controlling: Configuration of Controlling Area, activate Components/Control indicators, Assign number ranges to Controlling area and Maintaining Cost Center Standard Hierarchy.
Cost Element Accounting: Cost Element Types, Automatic Cost Element Creation, Costing Sheet, Reconciliation Ledger, and Explanation of CO Updates.
Cost Center Accounting: Cost Center Accounting Configuration, Controlling Area/Profit Center Accounting Maintenance, Activity Types and Statistical Key Figures, Assessments, Distributions, Reposting, and Automatic Account Assignment in CO.
Internal Orders/ WBS elements: Creation of Order/WBS type Real and Statistical, Creation of IO group, planning order-wise, Maintain Allocation Structure and Settlement Profile.
Profitability Analysis: Operating Concern Development, Characteristic Derivation, and Assigning Values to Value Fields, CO-PA planning, Activation of CO-PA, CO-PA Reporting and Creating Drilldown Reports.
Profit Center Accounting: Configuration and Customization of Basic Settings, Maintaining Profit Center Hierarchy, Assignment of CO Objects to Profit Centers, Actual Posting Maintenance, Assessment of Costs, Planning and Development of Reports.
Treasury: Bank Account G/L Structure and Lockbox Configuration.
PROFESSIONAL EXPERIENCE
Confidential, Auburn, IN
SAP FI/CO Consultant
Responsibilities:
- Configured Company Code, New general ledger, Vendor and Customer Master Data
- Involved in configuring Document Splitting
- Classified Document Types for Document Splitting
- Classify G/L accounts for Document splitting
- Defined document splitting characteristics for GL and CO
- Worked on multiple interfaces with the New GL.
- Worked on the Integration between NEW GL and PCA, Segments, COPA.
- Worked on multiple RICEF objects including customer master, vendor master and GL master conversion.
- Configured all business transactions for Accounts Payable and Account Receivables including the Payment Program Configuration and Automatic Check Payment Advice and Payment Analysis Printing, Clearing of Vendor and Customer Open Items, Bank Master Data, House Banks for Payment Program, Periodic Processing, and Correspondence.
- Configured the house banks, G/L accounts for Bank accounts and bank account reconciliation program. Defined forms of payment guarantee, defined and assigned payment guarantee, activated documentary payments per item category. Integration of MM and SD with FI account assignment.
- Worked on the different processes of OTC (Order To Cash) and P2P (Procure to pay).
- Worked on the whole flow of P2P (Procure to Pay) including the creation of the purchases order, good receipts, invoice receipt and outgoing payments.
- Define document types for real time updates
- Worked with BI Consultants in finding solution for business requirements
- Worked on the functional specification for multiple custom FI Reports.
- Configured controlling area, assigned company codes to controlling area & assigned number ranges
- Maintained master data in Cost Element Accounting
- Analyzed the client’s organization structure and configured standard hierarchy for cost center and assigned the cost centers to the hierarchy
- Assigned the cost centers to the respective profit centers
- Configured activity types, assessment and distribution cycles
- Created standard hierarchy for profit center, performed assessment and distribution of costs
- Created Internal Orders for various project implementations, assigned the costs incurred by internal orders from different cost centers, distributed the costs incurred by Internal Orders to the respective cost centers
- Maintained over head groups, defined costing sheet, assigned costing sheet to the controlling area.
- Involved in resolving production support issues relating to creation of characteristic fields, value Fields, and assigning values to value field
Confidential, Richmond, VA
SAP FI-CO Consultant
Responsibilities:
- Worked on New General Ledger with reduced total cost of ownership (Faster Close etc.)
- Also worked on System configuration (activating the new general ledger, defining and deriving segments, assigning scenarios, defining customer-specific fields)
- Involved in configuring Document Splitting
- Classified Document Types for Document Splitting
- Classify G/L accounts for Document splitting
- Defined document splitting characteristics for GL and CO
- Worked on Integration with Financial Accounting subsidiary ledgers and with Controlling (real-time integration of Controlling into Financial Accounting)
- Developed design specification for system enhancements, reports and interfaces
- Worked on importing data from legacy systems to SAP R/3 via Legacy System Migration Workbench (LSMW)
- Provided help with test plan and test script development (in the areas of FI and CO), test execution, and issues resolution
- Define document types for real time updates
- Worked with BI Consultants in finding solution for business requirements.
- Accounts Payable & Accounts Receivable: Worked on Configuring Down payment, check forms and worked on Idocs etc
- Configured Automatic payments for Account Payable and dunning for Account Receivable and settings for Outgoing/Incoming payments including Automatic Payment Program, exchange rate differences, payment advices, payment proposal/payment schedule, payment run, payment media, running/editing dunning proposal and printing dunning notices, carrying forward.
- Worked on MM FI (OBYC) and SD FI (VKOA) integration.
- Created Purchase Requisitions and Purchase orders.
- Worked on different kinds of purchase orders according to the client requirements
- Integrated FI with MM, SD, and CO modules with respect to account determination for various clearing and adjustment accounts.
- Configured Vendor/Customer Groups, master records and assigned it to G/L
- Lockbox: Supported lockbox processing which involved issues related to customer payments, formatting issues, clearing of appropriate accounts, manual entry of incomplete or unprocessed documents and month end closing.
- Configured areas of AP, House Banks, Automatic Payment program, optimizing bank by bank group for wire payments, check lots and void reason codes, clearing inter-company vendor/customer open items
- Configured Controlling modules including Cost Element Accounting, Cost Center Accounting, Internal Order Accounting and Profit Center Accounting
- Worked with report painter/writer for creating multiple reports. Also worked upon documenting business process
- Requirements.
- Continuously interacted with the accounting department while creating necessary primary and secondary cost elements to ensure that all the relevant cost data gets captured
- Assigned cost center to the standard hierarchy, configured cost center categories with appropriate block indicators for plan and actual data
- Interacted with the accounting department to identify the scenarios for assessments and distributions
- Configured the assessment and distribution cycle as per requirements
- Created Internal Orders for various project implementations, assigned the costs incurred by internal orders from different cost centers, distributed the costs incurred by Internal Orders to the respective cost centers
- Worked on master data: maintaining hierarchies, creating profit centers, planning: defined number ranges, planner profile, distribution, assessments, actual postings: maintained automatic account assignment of revenue elements, period end closing
Confidential, Mason, OH
SAP FI/CO Consultant
Responsibilities:
- Configuring & Customizing New G/L Accounting, chart of accounts, field status groups, automatic account determination, intercompany clearing, financial statement versions, validations and substitutions.
- Configured posting period variant, open and close posting period, document number ranges, document types, tolerance ranges, line item controls, maintain fast entry screens for GL account items, park documents, individual or mass reversal of documents.
- Configured Accounts Receivables (FI-AR), incoming payments, Check lots, and billings.
- Customized the screens for Document entry, document reversals, invoices and payments.
- Worked on customer, vendor master records, account groups, defined payment terms, vendor invoicing, manual outgoing payment, and automatic payment configuration.
- Defined templates for configuring, recurring entries in GL postings.
- Worked on Month end and Year-end closing for all FI and CO postings.
- Assisted issues relating to LIV (Logistics Invoice verification)
- Performed customization in the FI module for Vendor Aging Reports and Dunning Notices with technical team and tested the data flow.
- Developed a report for monthly Outgoing payments in Accounts Receivables.
Confidential, St. Louis, MO
SAP FI/CO Consultant
Responsibilities:
- Worked extensively in the configuration and enhancement of AP, AR, CEA, and CCA
- Worked on production support role. Resolved outstanding work issues (tickets).
- Coordinated with Offshore team in resolving outstanding work request.
- Created and maintained Chart of Accounts, Customized Account Groups, Field Status Groups, Posting Keys, Document Types, Posting Periods and Created G/L Account master records.
- Worked on Accounts Receivable (AR) module involving manual incoming payments, house banks, ranking order, bank accounts, and check management. Defined account groups, payment terms for incoming payments, outgoing invoices /credit memos.
- Also defined terms of payment for installation payments for incoming payments, maintained terms of payment for cash discounts and down payments for outgoing invoices /credit memos.
- Customized document types, posting keys, posting periods, document number ranges.
- Created Customers and Vendors Account Groups with screen layout.
- Define multiple payment method for ACH, Wire Transfer, checks and for foreign currency.
- Define ranking order, bank accounts, available amounts, value date and house banks.
- Supported lockbox processing which involved issues related to customer payments, formatting issues, clearing of appropriate accounts, manual entry of incomplete or unprocessed documents.
- Resolved various issues related to partial payments and deductions created in A/R.
- Defined check lots, void reason codes and wrote function.
- Maintained tolerances for customers, performed mass changes of correspondent codes and dunning clerks, configured the credit management, deduction management, running/editing dunning proposal and printing dunning notices in AR, worked on integration of FI with SD.
- Maintained settings for Controlling Area, Operating Concern, Primary and Secondary Cost Elements, created Cost Element Groups, maintained Cost Element Attributes, Costing Sheet etc.
- Created Cost Center as per business requirement. Subsequently tested Cost Center in QA and transported to PRD.
- Configured and created new costing variants as a part of suggested improvement in business process. Configured Cost Component structure as per the business requirement.
- Used reporting tools report painter to create forms as per the client’s requirement for managerial reporting.
- Performed integrated testing of problem corrections, changes and enhancements, from unit individual tests through user acceptance.
- Worked with and assisted ABAP team to understand the functional specification and made corrections in the functional specification when there was a need realized to make the output better than what was thought.
- Ensured smooth go live activities that included master data preparation and loading, cut over strategy etc. Played an important role in post-go live support including period end closing of FI/CO and continuous monitoring of FI/CO module activities.
Confidential, Foster City, CA
SAP FICO Functional Consultant
Responsibilities:
- Defined chart of accounts, performed basic configuration of system in areas of global settings, organizational structure, company code definition, account groups, field status groups, line layouts, documents, open items clearing
- Customized document types, posting keys, posting periods, document number ranges.
- Created Customers and Vendors Account Groups with screen layout
- Configured Automatic payments for Account Payable and dunning for Account Receivable.
- Ensured smooth go live activities that included master data preparation and loading, cut over strategy etc. Played an important role in post-go live support including period end closing of FI/CO and continuous monitoring of FI/CO module activities
- Cost Elements Analysis involving both primary and secondary cost elements, activating the reconciliation ledger, and maintaining accounts for automatic reconciliation posting.
- In Cost Center Accounting created cost centers, cost center standard hierarchy, statistical key figures, master data groups, validations and substitutions, reconciliation ledgers, assessments, distributions, allocations using cycle-segment method for periodic reposting, activity types and planning them on different cost centers, planned and actual activity price calculations.
- In Profit Center Accounting configured the basic settings, maintained profit center standard hierarchy, exchange rate types, statistical key figures, distribution and assessment of costs.
- Set up the templates for the projects. Set up grouping for WBS elements.
- Creation of new House Banks
- Auto clearing of the GR/IR account & Vendor open item
- Assigning of G/L accounts to new materials created
Confidential, German Town, MD
SAP FICO Functional Consultant
Responsibilities:
- Posting the vendors invoices.
- Worked with Vendor Invoice Management
- Posting the customer invoices.
- Configuration and Customization of Accounts Receivable and Accounts Payable
- Analyzed data feeds and resolved posting issues across the A/R and A/P areas.
- Processed journal entries and various project transactions. Extensive expertise in account payable and accounts reconciliation.
- Reconciled and analyzed variances of these financial statements with management projections
- Prepare the monthly and quarterly income statements, balance sheets and statements of cash flow.
- Prepare bank reconciliations.
- Assist in monitoring the company’s cash position.
- Investigate significant variances in month-to-month balances and also significant departures from budgeted amounts.
- Perform fixed asset accounting.
Confidential, Marshal, TX
Computer based Facility Management Automation Consultant
Responsibilities:
- Worked with the Business Analyst to Design the requirements using use case.
- Worked with the DBA to design the tables.
- Developed HTML, JSP, Struts classes, DTO, DAO, SQL, EJB.
- Developed code for CRUD, complex business logic and reports for the application.
- Developed JavaScript for screen validation.
- Used UML and Class and Sequence Diagrams for the development of Java code.
- Used design patterns like DAO, DTO, Facade, Iterator, Command, etc for the design of the application and MVC2 architecture and Struts 1.1 for the design and development of the application.
- Used DB2 for database, PVCS for version control and Clear Quest for bug tracking.
- Used IBM WSAD 5 and Websphere 5.0 for development and deployment. The application server is running on IBM AIX.
Confidential, Austin, TX
Software Engineer Consultant
Responsibilities:
- Analyzed Business requirements, product requirements, module specific functionalities, identified testing requirements and documented test plans, Scenarios, and requirements traceability Matrix
- Write functional test cases from use cases and High level design.
- Perform smoke Testing on new application builds prior to venturing into systems/regression testing.
- Identified, prioritized and designed Test Scenarios by grouping the test cases for Batch Testing
- Perform Preliminary Acceptance Testing on QA and client environments.
- Prepared User Acceptance test case on behalf of end client.
- Conducted database testing by executing SQL queries for Database verification
- Defects were logged and change requests are submitted using internal defect management system.
- Regularly attended walkthroughs and review meetings to discuss the requirements and testing status.
- Worked as internal Quality team leader.
Environment: UNIX, Java, EJB, Websphère application server, Informix, 4GL, VSS