SUMMARY:

SAP Finance Consultant with over 10 years of functional and technical experience in ASAP implementation, customization, and configuration of SAP R/3 4.7 - ECC 6.0 in both FI and CO modules. I am highly skilled with in-depth experience in business systems and process implementation, integration, testing, support, documentation, and user training.

SAP FICO SKILLS:

FI Enterprise Structure: Including Trading Partner, Company Code, Functional Areas, Fiscal Year Variant, Number Ranges, and Posting Period Variant.

General Ledger: G/L Account Groups, Chart of Accounts, Field Status Groups, Automatic Account Determination, G/L upload programs, Tolerance Groups, and Financial Statement Versions. New G/L configuration including document types for document splitting, zero balance accounts, partner fields and characteristics, splitting method and splitting rules and customization of business transaction variants.

Accounts Payable: Settings for Vendor Account Groups such as Suppliers, Returns Vendor, Freight Vendor, Ordering Address, and Payee Vendor, etc. Ownership of finance fields on Vendor Master. Implement OCR and Workflow for inbound invoices using third-party tools. Configure vendor payment terms and special prox terms as per business requirements.

Accounts Receivable and Cash Applications: Configure Lockbox accounts for FBL2 upload and FEBAN post processor. Setup cash application validation rules for postings. SD Account determination for Sales, Cost, and Tax account keys used in condition records.

Treasury: Setup House Bank, Bank Account structure including inbound, outbound, and main accounts for clearing and bank reconciliation. Design European Banking Integration with SEPA Direct Debits and SEPA Credit Transfers. Design File Layouts for BACS (UK) and ACH (US). Build a viable solution for Electronic Bank Statements using BAI, UK APACS, and MT940 file formats, including utilization of SAP Search String Functionality.

Intercompany: Intercompany Condition Type (VK11), Inventory Transfer, Transfer Pricing, Reconciliation, Fixed Assets Transfers, Third Party Sales, AP on behalf, and other Intercompany Procedures.

Taxes: Setup SD and MM input taxes in native SAP using FTXP, including setup of tax code/jurisdiction combinations. Also have experience with integration with Taxware and Vertex.

Asset Accounting: Setup/Copy Chart of depreciation, depreciation areas, asset classes, depreciation keys (including all calculation methods). Have experience in inflationary fiscal depreciation and valuation with Mexico regulatory requirements.

Cost Center Accounting: Cost Center Hierarchy, Cost Center Planning with Activity Types (KP26) and Statistical Key Figures, Assessments and Distributions.

Profit Center Accounting: Profit Center Hierarchy, Dummy Profit Center Assignments (3KEH for classical G/L), and design Profit Center P&L and Balance Sheets.

Project Systems: Project Coding Mask, Status Profile, Project Profile, Network Profile and Parameters, Budget Profile, Tolerances, and Settlement.

Product Costing Standard Cost/Actual Cost: Creation and maintenance of costing variant, including material costing strategies, cost component structure, settlement of actual cost, and variance allocation and analysis.

Profitability Analysis: Maintain Operating Concern, Characteristics, Value Fields, Costing based profitability analysis for Services. Utilize Report Painter to design standard reports with value fields and profitability segments.

Service Order Integration and Resource Related Billing: Maintain Work Center/Cost Center relationship, Activity Cost Planning, flow of planned cost, actual cost, and revenue into Service Order, Configure Dynamic Input Processor Profile with trading and service materials. Configure settlement profiles for flow of actual into CO-PA characteristics and value fields.

Data Migration: Designed LSMW using recording, IDocs, and Batch/Direct Input for all finance objects such as Profit Centers, Cost Centers, G/L Accounts, Fixed Assets. Worked with developers to design load programs/interfaces for G/L balances at cut-over, Open AP, Open AR, and Journal Entry uploads.

WORK EXPERIENCE:

Confidential, Mason, MI

SAP FI/CO Consultant

Responsibilities:

• Participated in blueprint design sessions with process owners gathering business requirements, demo proof of concept, and follow-up on open items/issues.
• Provided technical input in creation of process flows, narratives, and process documentation as part project blueprint deliverables.
• Prepared functional specifications for various Finance Processes such as General Ledger Accounting, A/P Payment Runs, Fixed Asset Accounting, Internal Orders, Intercompany Accounting and Reconciliations, Consolidations, Eliminations, and Planning.
• Gathered requirements for A/P Invoicing, Electronic Payments File Transfer (BACS/SEPA/ACH), Electronic Bank Statements, Asset Accounting, Internal Orders, GL document uploads, GR/IR weekly analysis, and month-end closing processes.
• Work on AP Payment output files for BACS (Great Britain Local Format), including designing file layout as per bank specifications, format maintenance, file destination setup, and final upload onto bank portal.
• Design AP Payments file for Single European Payments Area, which includes file layout, field mapping, identifying key bank information such as SWIFT codes, IBAN determination, preparing bank master uploads, and determination of file output destination.
• Build AP Payments file for ACH specific format for US Payments, including file layout setup, field mapping for US routing numbers, account numbers, and SWIFT codes.
• Work on enhancement to default date layout for all payments made from UK Company codes. This is to avoid formatting errors to prevent vendor payments from the banking portal.
• Design business process to carry out direct debit payments for specific vendor groups using alternative payment method and EBS post-processor.
• Build Electronic Bank Statement solution for UK business, using the existing BAI format implemented. This included working with local bank’s BAI format mapping to current codes setup, account assignments, definition of posting rules, and external transaction assignment to posting rules.
• Define SAP Search String for various un-assigned and redundant transactions with mapping to respective posting rules.
• Work on Intercompany STO process, cross company charges, third party sales, reconciliation and transfer pricing. Also develop process for Intercompany Asset Transfer from US to US and US to foreign plants.
• Work with business to formulate GR/IR Analysis report for unmatched Purchase Orders and Goods Receipts/Invoice Receipts.
• Work on Data Extract, Transform, and Load for various Finance Objects such as Vendor Master, G/L Accounts, Bank Master, Customer Master, and Fixed Assets.
• Develop Load Programs as well as utilize native SAP tools like LSMW to prepare and load legacy data into SAP.

Confidential, Mason, MI

SAP FI/CO Consultant

Responsibilities:

• Gathered finance team requirements as part of the ongoing effort to implement SAT’s Anexo 24 Mexico mandatory fiscal solution.
• Implemented and Tested SAP notes for Mexico Anexo24 fiscal and regulatory reporting with relevant business data.
• Worked on preparing XML formats for Chart of Accounts, Trial Balance Report, and Polizas Report.
• Identify source documents and tables in SAP to derive into the XML files along with key fields for UUID identifier and matching process (which is the key to any Anexo24 document sent to SAT).
• Managed Anexo24 integration with Invoiceware’s (third-party) solution for E-Invoicing implemented for Mexico.
• Worked on Extraction Tool for XML documents to be sent to SAT including initial upload of Nominas and Gastos for each Company Code.
• Designed Mexico DIOT reports for business to submit for Mexico fiscal and financial reporting agency.
• Enhanced SAP delivered IETU report (via SAP note) as per business specifications.
• Supported existing currency translation and revaluation processes and enhanced to calculate using optimal business valuations.
• Worked on identifying Intercompany transactional postings for business objects reports for eliminations, consolidations, and inventory valuations.
• Completed testing cycles and business user training documentation for end users and support teams to utilize post go-live.
• Supported and resolved post go-live items for successful transmission of transactional reporting to Mexico SAT portal, including file transfer, confirmations, and error handling.

Confidential, Milwaukee, WI

SAP Functional and Testing Consultant

Responsibilities:

• Configured Outgoing Payments, Open Item Clearing in Accounts Payable, and Cost Center Accounting Master data, Planning and Cost Allocations in Cost Center Accounting.
• Configured Vendor and Customer Account Group Maintenance, including Freight Vendors and One-time Vendors/Customers.
• Configured Withholding Tax Codes, Rounding Rules, and Withholding Tax Keys as per business requirements.
• Configured House banks, re-designed Automatic Payment Program for AGORA US Company Codes, including FBZP configuration steps for local payment methods and bank accounts.
• Prepared Reporting Requirements and performed appropriate modifications for 1099 Withholdings Tax Report.
• Performed Regression Testing and Integration testing for different modules like HR, SD and FI.
• Extensively worked on IDocs and EDI mapping of Purchase order (EDI 850 Outbound) and Invoice (EDI 810 Inbound).
• Configured Assets Accounting Module integration with Project Systems for AGORA including various Project Types and Settlement Rules.
• Re-Designed Asset Types and Depreciation Keys for AGORA US Asset Classes.
• Created Asset History Sheet reports as per business requirements.
• Involved in the Integration of Accounting Modules with other core modules, mainly Material Management (MM) and Sales & Distribution (SD).
• Worked on Intercompany Transactional Processes for finance such as Transfer Pricing, Cost Allocations, Eliminations, and Consolidations.
• Designed Process for Intercompany payments and receivables using EBS and EBS post-processor functionality of SAP.

Confidential, Lake Forest, IL

Business Systems Analyst

Responsibilities:

• As part of the core solutions delivery team, support and maintained existing business processes for a large number of business units currently on SAP.
• Resolved issues related to Capital Asset Accounting including balancing year over year planned depreciation, discrepancies in General Ledger and Asset Accounting module.
• Designed and prepare quarterly reports for business users to reconcile Accounts Payable postings with various cost object assignments such as G/L, Cost Center, WBS elements.
• Supported bank reconciliation process by overseeing discrepancies in auto-clearing accounts and help identify items from bank file bypassing clearing rules.
• Supported batch jobs for clearing, cash applications, and BAI(2) files from bank.
• Trouble-shoot EDI outbound files to bank for check printing and confirmations for positive pay file process.
• Designed Asset History Sheet reports for business users as per requirements for Acquisitions, Transfers, and Retirements with relevant transaction types.

Confidential, Lake Forest, IL

Responsibilities:

• Participated in blueprint design sessions with process owners gathering business requirements, demo proof of concept, and follow-up on open items/issues.
• Provided technical input in creation of process flows, narratives, and process documentation as part project deliverables.
• Prepared functional specifications for G/L interface with external vendor for periodic postings.
• Prepared functional specifications for conversions for Fixed Assets, G/L Balances, Open Accounts Payable, Cost Centers, Profit Centers.
• Developed LSMW for Hierarchies, Cost Centers, Profit Centers, Fixed Assets, and Open Line Items.
• Maintained Finance Org level configurations for project including Company Codes, G/L Chart of Accounts, Inter-Company Clearing, and Number Ranges.
• Maintained SD and MM tax configuration in native SAP (FTXP) including setup of tax codes, tax jurisdictions, combinations of product hierarchies with various jurisdictions.
• Designed and Configured Asset Accounting functions to support Depreciation Run, Sale/Transfer/Scrap of Asset.
• Setup Alternate Depreciation and Asset Revaluation process for Inflationary Depreciation Fiscal requirements for Mexico.
• Lead the CO and CO-PA integration and testing of ECC Service Management Process for in-house service/rental and 3rd party service/rental scenarios.
• Configured Dynamic Input Processor Profile for quotations and resource related billing including material, cost element determinations.
• Worked on automated batch data communication using RSBDCSUB process steps to facilitate accruals and reversals process.
• Worked on OCR and Workflow process for invoice entry, verification, and three way match using third-party tools such as Captiva and Open Text.
• Worked on outbound A/P payment program using DME formats to create file output to Gentran/Bank for check, ACH, and Wire Transfers.
• Designed Intercompany Payments and Receivables by Payor company code on behalf of various business units.
• Worked with cross functional teams to devise business processes for Intercompany Stock Transfers, Plant Inventory Reconciliations, and Reporting at a corporate level.

Confidential, Paton, IA

SAP FI/CO Functional Consultant

Responsibilities:

• As a member of the SAP (FI-CO) team, responsibilities included requirement gathering, mapping costing process, and blueprinting.
• Activated New General Ledger functionality, Performed Document Splitting configuration, and Parallel Reporting.
• Configured Automatic Account Determination, GR/IR, and Down Payments.
• Created daily, monthly and yearly closing processes for Cost Center Accounting, Profit Center Accounting, Accounts Payable, Accounts Receivable modules.
• Configured costing module including costing variant, cost component structure, costing sheet (base, overhead and credit).
• Defined vendor account groups and create vendor master data for accounts payable.
• Configured and perform costing estimates via CK11n and CK40n, mark and release costing estimates into Material Master.
• Setup customer/vendor down payment process, including clearing and post-processing.
• Developed test scenarios and user training manuals for client specific processes.

Confidential, St. Paul, MN

SAP FI/CO Functional Consultant

Responsibilities:

• As a member of the SAP (FI-CO) team, responsibilities included design, configuration, and testing of various functionalities in FI and CO modules.
• Maintained and supported Org Structure Data for Cost Center Accounting, Profit Center Accounting, General Ledger, Internal Orders, Accounts Payable, Accounts Receivable modules.
• Account assignment in cost accounting and define base method.
• Configure operating concerns and Profit center.
• Configured Accounts Receivable Order to Cash Process. Defined tolerance groups, tolerance for employees, customers and vendors and maintained initial settings and recurring entries.
• Defined customer account groups and created customer master data for accounts receivable.
• Configured automatic payment program for outgoing payments for company codes in Accounts Payable (AP).
• Performed Lockbox configuration.

Confidential, Milwaukee, WI

SAP FI/CO Functional Consultant

Responsibilities:

• Created fiscal year variants and assigned fiscal year variants to various company codes. Defined posting period variants, field status, number ranges and screen layout rules.
• Configured Customer and Vendor Account Groups, and LSMW their respective master Data.
• Identified one-time vendors and customers and defined a separate screen layout for them.
• Configured and customized Accounts receivable (AR) and Accounts payable (AP) modules including Terms of payment, Interest calculations, country specific and company code specific payment methods, and payments grouping.
• Maintained house banks, GL structure with various bank clearing accounts, check lots for bank accounts and reason codes for voided checks.
• Created Reference Chart of Depreciation, Assigned Chart of Depreciation, Specify Number Assignment across Company Codes, and Account Determination.
• In Cost Center Accounting, created cost centers, activity types, statistical key figures, Cost Center Standard Hierarchy, cost center categories, maintained default and automatic account assignments.
• In Product Costing, Configured standard Cost estimates in Cost object controlling for production orders, Configured WIP calculations and variance calculations and maintained settlement structures.
• Created documentation of end user training procedures and prepared test scenarios, post-implementation review and functional troubleshooting guides.

Confidential, Libertyville, IL

SAP FI/CO Functional Consultant

Responsibilities:

• Configured settings for company code, posting period variants, field status variant, assigned number ranges and defined tolerance group for employees.
• Configured business transactions for Accounts Payable and Account Receivables including the Automatic Payment Program.
• Maintained existing G/L accounts, Bank Master Data, House Banks for Payment Program, and Periodic Processing.
• Worked on SAP MDG Implementation and support including Data modeling, Process modeling, UI Configuration, and Data Replication techniques.
• Supported the project team on managing, tracking and forecasting of solution development Management, Support and Governance for Healthcare Professionals and maintenance of Master data in MDG system.
• Documented business requirements and define To Be process flows.
• Defined future state data standards and validation rules.
• Defined use cases for MDM platform fit gap analysis and support development test cases.
• In product Costing (CO-PC), maintained existing Standard Cost Estimate settings for Production Orders with Quantity Structure. Configure WIP and variance calculations.
• In Profitability Analysis (CO-PA) maintained Operating Concern, Costing based profitability analysis. Utilize Report Painter to design standard reports with value fields and profitability segments.