We provide IT Staff Augmentation Services!

Sap Fico Consultant Resume

2.00/5 (Submit Your Rating)

IL

Professional Summary:

  • A CPA with Six plus years of SAP FICO functional experience in Implementing, Customizing and Configuring of FICO Module from scoping to go-live phase including post implementation support
  • Experienced with three full life cycle implementations and two system upgrades from 4.6C/4.7 to 6.0
  • Experienced in New Implementations, Enhancements, Upgrades, and Testing & Production Support/User issues, Super-User & End-User Training & Documentation.
  • Configured Accounts Payable and Accounts Receivable, Treasury (TR), Customizing vendor/customer master records, Account groups, Account determinations, Tolerance groups, country/company code specific payment methods, Automatic payment program for outgoing payments, Bank settings, Reason codes and Credit control areas
  • Strong Configuration and Implementation experience in the Controlling Module- Cost Center Accounting (CO-CCA), CO-Profit center Accounting (CO-PCA, Cost and Revenue Element Accounting (CO-CEL), CO-Internal Orders (CO-IO), CO-Product costing (CO-PC), CO-Profitability analysis (CO-PA)
  • Experienced in the integration of FICO with SD (OTC) and MM (PTP) based on functional requirements.
  • Extensively worked on LSMW, CATT, and ABAP Queries with the ability to act as a techno functional consultant.
  • Worked closely with US GAAP & SOX compliance environments.
  • Expertise in analyzing workflows, gathering requirements and writing BPP’s, Use cases, Test script as per requirements
  • Strong expertise in problem solving, decision making, and translating business requirements into business solutions utilizing process improvements as well as ERP solutions.
Certification and Licensing:
  • Certified Public Accountant (CPA), State of Illinois
  • Real Estate Salesperson License, State of Illinois
Skills Profile:

ERP: SAP R/3 4.6c to ECC 6.0
OPERATING SYSTEMS: Windows 7, XP, MS-DOS
WEB: HTML, XML, Illustrator, Photoshop, Flash
TOOLS: MS Office Suite,Visual Basic 6, SnagIt
ACCOUNTING AND TAX: ATX, QuickBooks, CCH Online, Case Ware, Quicken

Professional Experience:

Confidential, Niles, IL
Oct 2010 – Feb 2011
SAP FICO Consultant/ (Prod. support)

Environment: ECC 6.0

With a history of audio innovation spanning over 80 years, Shure manufactures high-end microphones and audio electronics. Shure continues to set the worldwide industry standard for superior microphones and audio electronics.

Responsibilities:

  • A/P – Configure the automatic payment program using the payment medium workbench. Worked on development of function module for the DME to generate flat file based on bank proprietary file format for payment processing.
  • A/P – worked on implementing the printing and emailing of payment advices for payment runs. Setting up the house banks, payment methods, payment terms and variants. Also assisted in development of payment advice form.
  • CO-PA – responsible for the implementing of integrated excel flexible uploads of budget data. Maintaining versions for planning, building report layouts, planning levels and planning packages for the planning data to be loaded.
  • Creating Job aids for users to perform manual planning data loads via flexible upload.
  • CO-PC-Removing and creating new product collectors for materials based on user requirement and desired controlling level
  • CO-PC-Resolving issue related to incorrect confirmation against production order. Determining best possible approach to reverse statistical postings to cost centers.
  • IM-Investment management-Working with users relating to issue in Appropriation requests and ION’s not populating correctly in capital spending reports.
  • Working on issues relating to Dunning runs. Investigating issue with missing customer payments in the dunning list.
  • Assisting in creation of new company code for a holdings company requirement. Maintaining Fiscal year variant, posting period variant, field status variant, global parameters, company code assignments, tolerance group and number ranges.
  • Working with ABAP developers in updating Z-reports. Gathering requirements from business and creating functional specification documents for developers.
  • Worked on issues relating to foreign currency valuation and currency translation, maintaining account determination and foreign currency valuation method.
  • Also involved with end user training for issues relating to vendor invoice posting.
  • Gathering pros and cons and determining SAP best practices for the use of summarization levels in COPA while regenerating the operating concern.

Confidential, Joliet, IL
Apr 2009 – Sep 2010
SAP FICO Consultant

Environment: ECC 6.0

Confidential, which became part of CommScope in December 2007, is a global leader in manufacturing radio frequency subsystem solutions for wireless networks and one of the world’s most recognized brands in communication infrastructure.

Responsibilities:

  • Configuration and testing of system in the areas of FI-GL transactions, configuring adjustment accounts for GL, AP and AR
  • Activated New GL and Document splitting functionality; Configured the NEW GL, AR, AP and the current ledgers being set as leading ledgers and update rules for the other ledgers based on the report requirements
  • AP-vendor transactions, Master data, Master data for house banks, Automatic payment program, payment methods includes ACH, outsource checks, wire and manual checks. Payment terms, split payment for employee expenses, Clearing Inter-company Vendor/Customer Open Items(integration with MM transactions)
  • AR-customer transactions, Master data, credit management, payment terms, Cash application, Lockbox processing, Mapping Bank Lockbox format with Sap lockbox format, Customizing payment advice notes, Post-processing Lockbox data, Classifying deductions with reason codes and reason codes conversion program processing unidentified, on-account and partial payments and Clearing customer accounts through various transactions
  • Worked on Partial, Residual Payment types
  • Configured Cost Center Hierarchy design, creation of Cost Center Groups, Distribution and Assessment Cycles both planned as well as actual.
  • Extensively worked on both Orders to Cash (OTC) business in association with SD team and Procure to pay (PTP) process with the MM and Manufacturing team
  • Defined the basic settings for Product Costing sheet, valuation variant and carried cost estimate with quantity structure
  • Implemented production order costing and configured WIP & variance calculations maintained settlement structures of Product Costing (COPC)
  • Extensively worked on Cost Object controlling, period ending activities such as WIP and Variance calculations, settlements of orders, Cost Split, cost estimation , Costing Run, Marking and Releasing for updating the price in material master records in Product Costing (COPC)
  • Successfully implemented product cost estimate information transfer from CO-PC into CO-PA, through cost component values which facilitated the import of detailed cost-of-sales information into CO-PA for flexible margin reporting.
  • Configured Operating Concern, Operating Concern Attributes, Created characteristics and value fields, defined derivation structures and rules, maintained derivation table, and profitability segments used in Profitability Analysis, created custom reports in COPA
  • In Profitability Analysis (CO-PA) configured costing based CO-PA, assisted client in design and configuration of PA structures, including decisions on characteristics, key figures, derivation rules and settlement to CO-PA
  • Used CO-PA to report profitability by Customer, Product and Market. Created P & L statements CO-PA reporting tools

Confidential, Ontario, Canada
Mar 2008 – Jan 2009
SAP FICO Consultant

Environment: R/3 4.7 to ECC 6.0

Confidential, formerly known as Northern Telecom Limited is a multinational telecommunications equipment manufacturer headquartered in Toronto, Ontario, Canada. They have recently performed an upgrade from SAP R/3 4.7 to ECC 6.0

Responsibilities:

  • Worked on configuration tasks of the organizational structure of GL, AP, AR, CO-CCA
  • Gathered business requirements, participating in system design, configuring and testing existing system and providing post go live production support for enhancements
  • AP - Configured Master Data, Automatic payment program. Payment terms, clearing Inter-company Vendor open items. Worked closely with MM team for purchase process and transferring billing documents to AP and closing procedures in AP
  • AR - Configured Customer Master data, credit management, lockbox processing, payment terms, Allocating deductions with reason codes, partial payments and clearing customer accounts through various AR transactions
  • Worked closely with SD team on the sales process and transferring billing documents to AR and on closing procedures in AR.
  • Used MS Excel SAP LSMW, and SAP CATT to import data from legacy system which included Vendor, Customer, bank master data and transaction data.
  • Maintained tax codes and tax jurisdiction codes for US and CA company codes worked with Vertex system and FTXP.
  • Maintained structure for Cost center Accounting, Profit center Accounting and internal orders, CO-CCA-Assessments/Distribution, PCA-settings, Hierarchy, Account Assignment Objects, and integration with Project Systems
  • Involved in configuring of Product cost CO-PC thru sales order and production order using Variant Configuration for MTO, MTS scenario thru Object dependencies.
  • Involved in configuring Cost Component Structure, Costing Variants and Complex Overhead Costing sheets.
  • Helped end users in month end closing operations involving overhead calculation, variance calculation, Result Analysis settlements and activity price calculations.
  • Configured Account determinations for different material movements and valuation classes.
  • 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 result analysis keys, cost elements, result analysis versions and valuation methods to calculate Work in Process (WIP) and its settlements.
  • Responsible for documentation of implementations and changes. Training of client team members of new system functionality
  • Developed Reporting for FICO environment (FI/CO/PCA). Creation of the test plans based on the test scenarios, prepared functional specs, Unit Test Scripts, Integration Test Script, analysis, design, testing, implementation, and production support and defined Security roles for users

Confidential, Broomfield, CO
December 2006 – January 2008
SAP FICO Consultant

Environment: ECC 6.0

Confidential, is a global generics leader. They develop, produce and distribute high-quality, affordable pharmaceuticals. Sandoz medicines are now available to 90% of people worldwide. Sandoz reported generic pharmaceutical sales of USD 6.9 billion in 2007 and employs more than 23,000 associatesin 130 countries.

Responsibilities:

  • Involved in gathering business requirement, Preparation of Blue Print by reengineering the system to fill the GAP between the existing system and to the TO-BE system of SANDOZ, mapping processes to SAP ECC6.0 functionality, and collecting master data
  • Responsible for the design and blueprint of New General Ledger and Controlling related business processes.
  • Configured New General Ledger with Document Splitting and Segment Reporting.
  • Responsible for configuring and testing the system for New General Ledger and Controlling related business processes.
  • Configured new functionalities available in New General Ledger according to client requirements.
  • Involved as a team member in FI – Accounts Receivable, Accounts Payable sub-modules and CO – Cost Center Accounting, Cost Element Accounting, Internal Order, Profit Center accounting (CO-PC), and Profitability Analysis (CO-PA) implementation
  • Worked on Customer Master, House Banks, Payment Programs, Electronic Bank Statements and Lock Box and had successfully configured Clearing to clearing open items in GL/AR/AP Modules.
  • Configured Profit Center Accounting, Cost Center Accounting by creation Standard Cost Center Hierarchy using CATTs, Alternative Hierarchy, primary and secondary cost elements
  • Configured and used LSMW, CATTs for uploading master data of General Ledger, Customers and Vendors
  • Designed and configured Internal Order types according to the business requirements.
  • Prepared month end close and setting up the master data for Allocations (Assessments and Distribution).
  • Organized the operating concern, configured costing based profitability analysis in profitability analysis (COPA). Created reports using Report Painter
  • 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.
  • Generation of reports through ABAP Query for Vendor and Customers.
  • Ensured compliance requirements (Title 21 CFR Part11) were met
  • Configured new company codes, Inter-company code assignments & processing and Inter-company Transport Orders.
  • Prepare detailed functional specifications for development activities including reports, interfaces, conversions, enhancements, and forms (RICEF)
  • Involved in unit, Integration testing and performed rigorous testing to check the system performance

Confidential, Tempe, AZ
July 2005 – October 2006
SAP FICO Consultant

Environment: R/3 4.7 to ECC 6.0

Confidential, is a Fortune 100 company that invents and manufactures technologies to address tough challenges linked to global megatrends such as safety, security, and energy.

Responsibilities:

  • Mapped current state to future state, developed test scenarios, conversion/Interfaces/validation plans, cutover, end user training and post go-live production support.
  • Responsible for gathering business requirements from Client and properly documenting this information to be used in the design of the system requirements
  • Refined business requirements and suggested improvements to smooth flow of business process
  • Defined and configured chart of accounts, account groups. Assigned Chart of accounts to company codes.
  • Configured General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP) functional areas and business areas based on organizational structure. Defined templates for configuring recurring entries in GL postings.
  • Defined tolerance groups, number ranges, posting keys, document types, fiscal year variants, field status groups.
  • AR - Maintained Customer Master Records and Credit Control Areas. Default Account Assignment Categories for Over and Under Payments, and Cash Discounts.
  • Configured settings for creation of House banks, Bank accounts, Lockbox file formats, required for Lockbox processing to expedite customer payment
  • AP - Vendor transactions, Master data, Check management, house banks, payment program, payment terms, deduction management, Clearing Inter-company Vendor/Customer Open Items, Logistics invoice verification, Evaluated receipt settlement.
  • Coordinated the integration efforts of FI/CO with SD, MM, based on functional requirements, automatic account assignment, maintaining the revenue account determinations & revenue recognition which is useful in integrating AR-SD
  • Knowledge in Profitability Analysis (CO-PA), created the Operating concern, configured costing based Profitability analysis. Defined and configured the reporting characteristics, value field, profitability segments used in Profitability analysis
  • Customized settlement profiles, allocation structures and PA transfer structures to facilitate order settlement to COPA.
  • Designed and developed contribution margin reports in COPA based on a combination of characteristics using Report Painter and Report Writer.
  • Trained Financial Analysts on using COPA to report profitability by customer, product and market
  • Provided one to one end-user training and documented the same for future references
  • Actively involved in user acceptance testing.

Confidential, Chicago, IL
October 2004 – May 2005
SAP FICO Consultant

Environment: R/3 4.7

Confidential, are the largest buyers of Foreclosed properties in the Chicago-land area. The company’s strategic objective is to acquire properties (residential, commercial and industrial) at severe discounts before selling them in the marketplace.

Responsibilities:

  • Configuring document types, number ranges, posting keys, field status variant and groups, fiscal year variants with year- dependent periods for yearend closing and posting periods variants.
  • Defining chart of accounts, account group and general ledger accounts for each company code. Customizing screen layouts for document entry at account/document levels, settings for clearing, posting gains and losses on valuation, realization and translation.
  • Configuration for automatic procedures in payment programs and interest calculation on account balances and line items in AP
  • Creating account assignment models for recurring entries.
  • Configuring for inter-company transactions.
  • Created Vendor master, Customer master and specified number ranges, screens layout, credit control areas, credit limits for customers.
  • Configured settings for creation of House banks, Bank accounts, Lockbox file formats, required for Lockbox processing to expedite customer payment
  • Configured for vendor/customer who is also customer/vendor and trading partner.
  • Involved in the design of Asset Class and Charts of Depreciation in Fixed Assets.
  • Designed and configured Asset Management to carry out business transactions like acquisitions, retirements, transfers, write-offs and post capitalization.
  • Responsible for configurations of Assets: reference chart of depreciation, made required settings for account determination, asset classes, screen layout rules, defining number ranges, valuation of assets in different depreciation areas, asset acquisition, cross company code transfers, settings for depreciation runs ( FI-AA Integration)
  • Maintained overhead structure for accrual costs, allocations using cycle-segment method for periodic reposting, distribution and assessment, indirect activity allocations
  • Created Chart of Depreciation and carried out settings for asset company code.
  • Trained Users on daily routines and month end processing.

Confidential, Chicago, IL
June 2003 – September 2004
Senior Accountant

Environment: JD Edwards

Confidential, are the largest buyers of Foreclosed properties in the Chicago-land area. The company’s strategic objective is to acquire properties (residential, commercial and industrial) at severe discounts before selling them in the marketplace.

Responsibilities:

  • Administered staff accountants and directed financial analysis, financial audits, GL, AR, AP and fixed-asset accounting in accordance with GAAP standards
  • Developed several investment related reports (IRR, ROI, NOI, EML, Pro-forma Rent Rolls and etc.) for executive management to devise strategy of investing in the recent housing market collapse.
  • Calculating and recording depreciation for rental inventory, calculating and applying amortizations schedules for properties sold on articles.
  • Performed Budgeting and forecasting analysis for the Formation of multiple LLC’s with short term investments to buy and sell properties from various city and state REO auctions.
  • Complete monthly bank reconciliations. Balanced and reconciled intercompany accounts between various LLC’s.
  • Developed an in house marketing and advertising system to compile brochures and flyers that are distributed nationally to capture potential investors.
  • Designed and developed Access databases to maintain inventory (Real Estate) and Investor accounts. Investor database provides real time reports for all investment related queries.
  • Processed accounts payable and entered rental collections weekly. Reconciled rental accounts at month end.
  • Responsible for fixed asset (real estate properties) inventory keeping. Maintained an active inventory of all fixed assets (properties, Land, Notes, Mortgages, Certificates)
  • Participated in the formation of LLC’s for new investor portfolios. Assisted in analyzing results and creating rate of return schedules to communicate with the investors on their investments.
  • Assisted real estate agents in compiling reports for executive management to actively participate in real estate and real estate tax auctions.
  • Assisted in tax compliance and review projects for corporations, partnerships and LLC’s
Education:
  • Bachelor of Science, Accounting
  • Bachelor of Science, Management Information System

References Available upon request

We'd love your feedback!