Fi/co Consultant Resume
2.00/5 (Submit Your Rating)
Houston, TX
PROFESSIONAL SUMMARY:
- Over 9 years of strong functional experience in implementing, customizing, configuring, integrating, testing, user training and supporting of SAP R/3 FICO module, including three (3) full life cycle system implementations
- Implementation of AR and AP using best practices and custom interfaces;
- Implementation of AA (Asset Accounting) including asset acquisition, depreciation, transfers, retirements, revaluation;
- Experience in activating of New G/L and Leading Ledger with creation of Segments and assigning Scenarios and Customer Fields in the Parallel Ledgers;
- Worked on customization of the real - time integration from CO to FI (defined and assigned Variants, configured account assignment determination, activated the trace to log the transactions);
- Experience in configuration of Automatic Payment Run, Lockbox configuration, Banks Accounting, Cash Journal.
- Configuration and Testing of Tax codes and tax jurisdiction codes
- Exposure to ABAP Environment, User-exits and ABAP query. Participated in Data Migration through LSMW
- Experience in CCA (Cost Center Accounting), PCA (Profit Center Accounting),I/O (Internal Orders), PC (Product Costing) and CO-PA (Profitability Analysis)
- Cost Center hierarchies, profit center hierarchies and alternative hierarchies (manually or using CATTs)
- Knowledge of Overhead Cost Controlling, and activity-based costing; Creating primary and secondary cost elements;
- Configuration of accrual calculations; Configuring assessment and distribution cycles, periodic reposting and PA Assessments;
- Creating, using Internal Orders including overhead cost orders, investment orders, accrual orders, orders with revenues;
- Experience in using statistical Internal orders (I/O); Allocations of Internal orders to other cost objects (including collective processing);
- Creating budget planning profiles; activity types;
- Creating standard and customized reports using report painter, report writer;
- Product costing (CO-PC) with Material ledger
- Extensively worked on cross functional integration between FI-MM and FI-SD with CO-PA and BI Financial reporting prospective.
- Strong Functional experience in SAP FI (GL, AP, AR, AA, Banking, and New GL) and CO (CEA, CCA, PCA, PC, and PA), I-Docs, Bolt-on, Open Text Document management system (Vendor Invoice Management VIM), B2B interfaces such as PeopleSoft, Concur, Sabrix, Smart buy, Card connect and Vertex. Worked on ticketing tools such as Remedy, ServiceNow. Experience on BPC.
- Knowledge on Process Integration and Master Data Management. Worked with Web Methods team and PI Team for source to target mapping with different interfaces with sap, file to file and file to I-Docs, Oracle DB and PL/SQL etc. Worked on HPQC in varies projects.
- Worked on Data Archiving scenarios such as DART tool extraction of financial data. Document archiving for varies billing documents and extraction of data to BI/BW.
- Expertise in Discrete manufacturing and closely worked with Supply chain team with varies scenario’s such as strategy 10, 20, 40 involving Mixed costing, Split valuation, Cost center accounting, product costing.
- Worked on COPA reporting, derivation rules, PA transfer structures, Settlement profile setup and Plan/Actual reports in COPA. Experience in RMCA and FICA.
- Hands on experience with modules dispute management and credit management and FSCM modules.
- Experience in IFRS, GAAP, US tax, VAT, GRC and Worked with KPMG and PwC on audits.
PROFESSIONAL EXPERIENCE:
Confidential, Houston, TX
FI/CO consultant
Responsibilities:
- Provide analysis to external Vendor on the finance and GL tables for building an extractor program in SAP.
- Worked with middleware team to establish an interface between SAP to external system iVAT.
- Worked on Batch jobs setup.
- Involved in all phases of the project from requirements gathering, Blueprinting, Realization, Testing etc.
- Worked on varies landscapes of the Confidential system.
- Created a design to block customers at the customer master and also at the sales order level. Involved in all phases of the project from requirements gathering, Blueprinting, Realization, Testing etc. Worked closely with Sales team, pricing team and also billing team and provided inputs in different areas both FI and SD related. Worked on testing various scenarios belonging to
- Worked on interfacing between Smartbuy system and SAP to confirm Confidential regulations to be applied for non-US vendors.
- Worked on Vendor invoice postings (manual, IDoc, EDI), Resolved issues related purchase order, Goods receipt and Invoice receipt. Test all scenarios related to Accounts payable and Automatic payment run.
Confidential, Lake Forest, IL
FI/CO consultant
Responsibilities:
- Involved in small projects in such as Grainger Tech project, Proco project, Kardex reporting project, Safety solutions project. Worked on production support supporting US based companies for FI-MM and FI-SD related issues. Worked on FSCM modules such as dispute, credit and collections mgmt.
- Worked/Supported Change management, Test management, Production support Break fix service now team, Batch job chronicle team on Sales, Delivery, Billing and Finance related issues such as price update MR22, Standard costing etc. Worked on product costing issues.
- Involved in new company code setup, basic configuration such as company code, Withholding tax, House bank configuration, EBS configuration.
- Worked with change management team, test management team to transport the configuration from development to quantity to productions system.
- Tested the configuration in Development system and coordinated system integration testing with middle ware and external bank systems.
- Communicated and coordinated with HR team, AP and AR team to during system integration testing and Go - Live pre and post activities.
- Involved in designing and configuring for proco project, developed a hybrid of third party drop ship and intercompany sale scenario.
- Worked closely in Sales, Billing, and Account payable, Banking, Account receivable, Purchases, Goods Receipts and vendor invoicing both configuration and business process wise to bring shape to the project.
- Accounts payable included vendor invoice posting and automatic payment run. Tested all scenarios related to Procure to pay cycle from purchase info record to payment methods.
- Worked on creating schemas for attribute, analytical and calculation views in HANA for different Grainger processes. Coordinated on data cleaning for FI - SD tables and COPA related data for system preparation for data uploads.
- Engaged in working with BI/BOBJ team to explore the user requirements and to develop a design in HANA core, so as to mimic the same reports in HANA tool.
- Worked on extracting data from development and quality system for testing/validating the connection between BODS, source and target systems. Also prototyping initial data extractions in HANA system.
- Successfully implemented simple finance in US company code as the pilot batch. Worked with SAP team with configuration validation, change management, Test management and other administrative
Confidential, King of Prussia, PA
FI/CO consultant
Responsibilities:
- Involved in studying and understanding the current system through knowledge transfer for SAP controlling with detail discussions and knowledge transfer sessions on product costing and profitability analysis COPA. Navigated through SOLMAN for documentation
- Setup of batch jobs with variants on programs and reports for Overhead, WIP, Variance, Settlement and Summarization in the background for each plant in Quality and production environment
- Generated ABAP query and linked to a Z transaction code for shipped but not billed report for user as part of month end reconciliation between intercompany billing and KE24 report.
- Worked on Z reports such as ZMB52, Z inventory aging, Z daily sales following the quality assurance policies and creating, updating and achieving sign off from business on documents such as User requirement specification, Functional requirement specification, Software design specification, Technical specification, Test script and Request for change documents and Memo documents.
- Supported cost roll for the year 2014 by providing advice and guidance to users to maintain Purchase info records, BOM, Routings, Material master data for varies plants and price update MR22.
- Developed training documents for costing run CK40N, CK24, and Material price change MR21 after the costing run for US, Canada and Europe company codes.
- Involved in supporting costing run based on Material Ledger using transactions such as Confidential , Maintaining TVARV table and scheduled batch jobs which involved creating and modifying variants for the batch job. Researched SAP notes for solutions for Must Close scenarios.
- Maintained valuation class and default account assignment as part of material, plant extensions and variance regression testing in development and quality environments.
- Supported business through month end and year end activities and resolved incidents with tools such as Remedy especially on transfer price evaluation.
- Involved in exploring flow of values from Billing, controlling and financial transactions to COPA and maintain OKB9 transaction, substitution rules and derivation rules for COPA.
- Worked on Internal orders, Process orders, production orders and various scenarios involving settlement profile setup and reconciliation between FI, CO and COPA.
- Provided daily, one on one and week status reports to business as part of production support project.
Confidential, High Point, NC
FI/CO senior consultant
Responsibilities:
- Involved in Unit testing, Functional testing, Cross functional testing, System integration testing, and User acceptance testing
- Worked with business to develop cost center hierarchy and guided business user to understand and take a decision on required cost centers
- Developed and maintained OKB9 settings in each client as the testing moved into subsequent sub-phases and working with Product costing team, Master data team and business
- Conducted and facilitated master data Migration/Cleansing and Go-live preparation meeting with business and capturing the progress, tracked and reported the same to the higher management using MS-Excel
- Participated in developing functional description (FDD) documents, User Requirement specification (URS) documents, Functional requirement specification (FRS) documents, Software design specification (SDS) documents and also help the technical team to develop Technical design specification documents.
- Researched and tested PeopleSoft, Concur and Vertex interfaces with SAP. Extracted files from production archive and massaged the file in the process of test preparation and uploaded the file for SAP system readiness and Custom table maintenance for PeopleSoft and Concur travel management system. Tested system connectivity and Tax calculation with Vertex.
- Unit testing involved testing request for changes (rfC) in configurations, communicating and observing the progress of the request and coordinating with NA Hub team and Central team in Germany
- Scope of functional testing includes Asset accounting, Cost center accounting, Overhead cost accounting, Product costing, Profitability analysis, Internal order accounting, Project systems, Dispute management, Credit management, Tax accounting, Resource related billing and Project systems.
- Involved in cross functional testing and System integration testing. Led multiple scenarios, identified the stakeholders, lead the team members from other teams to coordinate and complete test cases. Identified and noted down the dependencies and added the same to the pre-go live preparation list and cutover list.
- System integration testing included third party tools such as HOVS and Open text, supported and coordinated with MM team to test a complete workflow using Enterprise Live scanner.
- Coordinated with ABAP team and worked with business to created MS-Excel upload files for Mass upload of master data such as Asset under Construction, Asset master data, Internal order master data, Cost center planning data, Activity type and Statistical key figure data.
- Worked on Fringes and Fringe rates, studied the To-Be documents and explained the requirements from business such as fringe rates and Overhead calculation rates, so as to maintain the custom tables in SAP.
- Developed all the allocation cycles and maintained them in all the clients as required. Worked on both plan and actual cycles of Assessments, Distribution, Periodic reposting, PA-assessments.
- Worked on integrated planning with business on Activity input planning, Activity output planning, Statistical key figure planning, internal order planning, and cost center planning, Depreciation simulating planning, Product costing and MR22
- Maintained plan versions, helped business user understand and evaluate reports for actual, plan line items in COPA.
Confidential, Woodlands, TX
FI/CO team lead
Responsibilities:
- Involved in Unit Testing, Cross functional Testing, System Integration Testing, and User Acceptance Testing.
- Involved in System Integration Testing especially in B2B and EDI interface testing, worked on all the Bank interfaces pertaining to flat file exchange.
- Tested and Maintained Bolt-on such as Vertex, IXOS document system, DaRT reporting, Get Paid applications.
- 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.
- Worked with Control M team to schedule all the batch jobs related to finances, controlling, Material ledger and BW upload.
- Analyzed and reverse engineered all the treasury modules and generated documentation on different process and Z transaction and T codes. Worked closely on Collection, Credit and Dispute management.
- Production support role involved fixing Bank interfaces especially Lockbox process end to end process. Bank master data maintenance and EBS configuration for new bank partners.
- Involved in Knowledge transfer of complete Finance process from Ashland Chemicals to Confidential Solutions. Technical upgrade of the system from 4.7 to 6.0.
- Worked as Team Lead in an Onsite offshore model coordinating with offshore team, delegating work and conducting meetings on regular interval for updates and feedbacks. Maintain defect log, System Integration testing status log, and project finance progress log to update higher management.
- Created documentation for all the finance models. Tested ECC 6.0 system mimicking the 4.7 system configuration. Gathered information on third party tools such as Get Paid, E5, Acuity, Banking structure.
- Conducted and involved in meetings on middleware Control M to restructure the scheduling of batch jobs and impact on the overall business.
- Responsible for benefit analysis of SAP Collections, Dispute and Credit management with Get-paid tool.
- Worked on Banking configuration, Payment methods such as wire, Confidential, Payment order file, Check printing and EBS files processing with Citi bank, Bank of Nova Scotia and Bank of America.
- Worked with ABAP team to analyze and understand all the complex Bank Transactions, concatenation of files and file transfer trigger programs to web methods and from web methods to Bank server and also the other way around. Worked with eight different banks gathering all the requirements such as PGP keys etc.
- Worked closely with business application team to test different applications such as Vendor Inquiry, CASS Logistics, and other small tools generated by the client side IT team.
- Involved in Vertex Q series 4.0 implementation and switch from UNIX based system to Windows based system. Tested vertex functionality and maintained vertex system after Go-live. Part of project exit was to document all the vertex process related to users and IT based maintenance.
Confidential, Lexington, KY
FI/CO consultant
Responsibilities:
- Coordinated with SD team to maintain derivation rules and investigate errors related FI-SD integration and CO-PA reporting.
- Involved in configuring the settings for CO-CEA, CO-CCA, CO-PCA, Internal Orders, CO-PC and COPA. 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.
- Defined origin groups, overhead keys, overhead groups and cost component structure.
- Defined costing sheets for calculating Overhead (percentage based overhead calculation).
- Configured Material Cost Estimate with Quantity Structure, costing variant, cost component structure—with structures like BOM and Routing for costing the product provided by PP.
- Defined price update for standard cost estimate and inventory cost estimate and worked on reference and simulation costing and ad hoc cost estimate
- Supported Month end closing batch jobs involving CKMLCP and material ledger. Part of the responsibilities where to handle tickets related costing runs related to material ledger.
- Configured costing based CO-PA, created characteristics and value fields, used various derivation techniques and rules, configured valuation using product costing and costing sheet.
- Configured CO-PA planning, including creating planning levels plan package and planning methods and mapped SD condition types to value fields to have the system automatically transfer the sales revenues and deductions to CO-PA. Worked on data extracts to BW system and involved in testing BI/BO reports.
- Settled Production cost center variances and production order variances to COPA
- Created reports in CO-PA to Report profitability by Customer, Product and Market.
- Defined summarization levels to call up data stored in Profitability analysis and generated Reports on different profitability segments using the data from CO-PA tables.
- Prepared month end close and setting up the master data for Allocations (Assessments and Distribution).
Confidential, Greensboro, NC
FI/CO consultant
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.
- Activated New G/L, Leading Ledger and Parallel Ledger for the possibility of Parallel Accounting according to the US GAAP.
- Configured Automatic Payment Program for A/P for checks, Confidential and wire transfer; created check lots; Tested and performed web-demos of G/L transactions for fast-entry screens, splitting, posting, parking and reversals;
- Configured A/R including creation of customer account groups, number ranges for A/R, tolerance groups; credit control area, customer credit limits, credit limit groups
- Was responsible for FI-MM integration: configured automatic account determination, insured smooth operation of MIGO-MIRO transactions (procure-to-pay) using 3 Way match; GR/IR Verifications, Both Non Purchase order and Purchase order based Invoice matching, automatic triggering of PO and Blanket PO. Involved in testing integration points with Global Trade Management.
- Customized the real-time configuration from CO to FI (defined and assigned Variants for real-time integration, configured account assignment determination, activated the trace to log the transactions);
- Participated in testing using Solution Manager; Worked with integration and regression testing of FICO, SD, MM Modules. Tested different scenarios pertaining to AP, AR, Lockbox, Dunning.
- On a regular basis performed knowledge transfer to Super users and management using web demos; created BPP documentation;
Confidential, Sacramento, CA
SAP FI/CO consultant
Responsibilities:
- Participated in blueprinting phase using ASAP Methodology;
- Worked on configuration of Accounts Receivable (A/R) customer account groups;
- Created characteristics and value fields in CO-PA. Configured the derivative rules for user defined characteristics, created costing keys for transferring current cost estimate in CO-PA;
- Extensively worked on Product costing period end activities such as WIP calculations, Valiance calculations, Settlements, cost estimate updates, costing run, mark and release for updating the price in material records and price variance postings, reports etc.;
- Provided production support for all issues in I/O, PC & processing EBS; Reported weekly on support ticket numbers and solution turnover time;
- Maintained relations with Banks by resolving the issues in receiving Flat file for processing customer remittances;
- Worked on creation of asset classes, depreciation types, depreciation areas;
- Part of the assignment was to involve in Testing and realization phase for Funds and grants management activated shortlisted company codes.
- Specified automatic account assignments to link asset master data to G/L accounts;
- Created depreciation keys with assignment to depreciation areas;
- Worked on intercompany billing configuration for newly acquired company codes and revenue recognition
- Traveled to company locations with data conversion purposes; Performed other functions assigned my management
- Involved in Source to Target mapping from legacy system to sap system. Migrated legacy master data using LSMW.
