SUMMARY

• SAP consultant with 8 years of implementation and configuration experience in Finance (FI), and Controlling (CO).
• Two full life cycle implementations of SAP Finance (FI) and Controlling (CO) modules with hands on experience in up gradation and in following SAP versions, SAP R/3 4.5B, 4.7, ECC 5.0, 6.0
• Expertise in Financial accounting which include FI - AA, FI-AP/AR including Credit Management, FI-G/L including New GL, FI-BL, Special Purpose Ledgers, Treasury Management.
• Data Migration strategies for master and operational data load with LSMW, BDC/batch input, direct input, BAPI, and IDOC infrastructure.
• Strong knowledge in Integration of various SAP FICO applications with SD & MM. Performed integration of FI/CO module with SD, MM and PP modules.
• Configured tax settings, maintained Input and Output tax codes for jurisdiction codes, and maintained jurisdiction code settings, automatic account assignments for tax postings. Addressed issues related to tax calculated from Vertex and helped in documenting the process flow. Performed US taxes (Sales tax & use tax) and Tax ware.
• Knowledge on Product Cost Controlling (CO-PC) with Material Ledger/Actual Costing, strong exposure to Profitability Analysis (CO-PA), internal orders, Profit center accounting (CO-PCA) and Cost center accounting (CO-CCA).
• Configured payment terms for Dunning, Over-Due Interest calculations for Down Payments and Automatic Clearing of line items and for posting net payment amounts for Cash Discounts after calculation of Cash Discounts, Under / Over Payments, write-offs and Reason Codes.
• Implemented audit controls, defined user profiles, authorizations and addressing segregation of duties issues related to Sarbanes Oxley (SOX).
• Expertise in using CATT, SAP Scripts, Smart Forms, ABAP Queries, ABAP debugging and possesses ability to propose and justify technical solutions functionality. Good working knowledge in development of custom reports, Report Painter, Report Writer and ABAP Query.
• Technical proficiency in implementation of major functionalities like Electronic/Manual Bank Statements, Payments, Electronic and Manual Check deposit, Payment Advices, complete Check Management functionality.
• Extensive Experience with SAP FSCM Modules Including SAP Biller Direct: for handling Web-based payments and account and bill display, SAP Dispute Management: for processing customer invoice complaints.
• Performed Lockbox configuration, Lockbox Processing, setting up house banks, defining lockbox accounts at House banks, defining lockbox parameters and Posting data and testing the lockbox functionality.
• Proficient in Manual Testing, Integration, Functional, Regression, User Acceptance Testing, Performance and End-To-End Testing.
• Excellent communication skills, exceptional ability to perform individually as well as part of team.

TECHNICAL SKILLS

ERP: SAP R/3 4.7, ECC 5.0, ECC 6.0

SAP Financial: General Ledger, Accounts Payable, Accounts Receivable, Asset Accounting, Bank Accounting.

Controlling: Cost Element/Cost Center Accounting, Profit Center Accounting, Internal Orders, Profitability Analysis, and Product Costing.

Technical: ABAP Query, Report Painter, Report Writer, CATTS, eCATTS, Infopak, uPerform, LSMW, ASAP Methodology.

Databases: MS Access

Office Tools: MS Word, PowerPoint, Excel.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Senior SAP FICO Functional Consultant

Environment: SAP ECC 6.0

Responsibilities:

• Worked on Business Requirements, Functional Design and gap analysis for Vendor Open Invoices Migrations, GL Account balances migration and Purchase Order Migration from (SAP 4.5B) to (SAP 6.0)
• Formulated functional specs and guided ABAP programs development and custom function module modifications for vendor invoice extraction, convert to Idoc format file, Invoice upload, vendor invoice clearing.
• Designed and executed test cases for System integration, User acceptance and Regression tests along with identifying corner cases following production data analysis.
• Resolve issues with exchange rates (standard and spot rate) calculations, withholding tax (WHT), language types and performance issues associated with vendor open item migrations high volumes.
• Configured business transactions for Accounts payable (A/P) payment runs program, clearing of vendor open items. Company code data, Paying company code, Country payment methods, wire transfer settings, ACH payments, Dunning Notices.
• Created Vendor transactions, Master data, Check management, House banks, Payment Terms, Deduction management, Clearing Inter - company Vendor/Customer open items, Logistic invoice verification, Evaluated settlement.
• Configured settings for integration of SAP with Tax ware. Maintained Input and Output tax codes for different jurisdiction codes, and maintained jurisdiction code settings, automatic account assignments for tax postings. Configured tax determination procedures for US and Canada. Worked on functional specification for user exit for tax determination using Tax ware.
• Designing included process flow, ABAP program developments, logic buildup for balance calculation, Co Code split scenarios and correct mapping for cost center and Business area, custom mapping tables for GL account mapping.
• Configured and customized General Ledger, creation of G/L accounts, screen layout rules, automatic account assignments, financial statement version, and validation and substitutions rules.
• Configured posting period variants, open and close of posting periods, fiscal year variants, field status groups, document ranges, tolerance groups, and assigning the variants to company code etc.
• In Vendor Master Data Migration from (SAP 4.5B) to (SAP 6.0); Analyzed and configured vendor accounting groups, accounting groups number ranges, minority indicators, tolerance groups, country specific field checks, mappings vendor reconciliation accounts.
• Configured Idocs settings for CREMAS, ADRMAS, INVOIC, ACC DOC Idoc types; Reprocess the failed Idocs after the error has been fixed through reprocess programs, blocking of the Idocs, Archived Idocs.
• Coordinated with different teams (TAX, GL, and AP) for test case scenarios, execution and validations for migrated accounting and purchasing vendors.
• Worked on all stages from analysis to GO LIVE, production support and knowledge transfer for new interfaces, for processing employee expense invoices. Maintained Organizational plan for interface Idocs error.
• Experience with AIF for monitoring and error processing of invoices. Monitored test case execution and progress via ALM (formerly HPQC). Scheduled program jobs variants via TIDAL for outbound reconciliation reports.
• Experience with procurement cycle from determination of requirements to payment procedures and order to cash cycle. Worked on Logistics Invoice Verification (LIV or GR-IR verification) in FI-MM (Procure to Pay) integration and configured account determination for FI-SD (Order to Cash) cycles.
• In Fixed Asset Management, Copied Reference Chart of Depreciation, Assigned Chart of Depreciation, Specify Number Assignment across Company Codes & Account Determination.
• Four Depreciation Areas created for Book Depreciation, Tax Depreciation, and Cost Depreciation, Management Depreciation. Created Chart of Depreciation and settings for asset company code. Made settings for GL accounts for AUC, gain/loss on asset disposal/retirement, for posting depreciation under different Depreciation Areas.
• As part of Confidential split (SMO) project, worked on co code make up for each company. Developed and tested custom tools and ABAP program used for cloning and cleansing of Purchase orders, open GR's and IR's (PO/non-PO) in SAP instances.
• Defined cutover strategy, automated test solutions, new cost center configuration and tested EDI and ERS outbound for correct suppliers.

Confidential, San Rafael, CA

SAP FICO Consultant

Environment: SAP ECC 6.0

Responsibilities:

• Configured GL Master records, document number ranges, posting period variants, tolerance groups, reversal of documents, opening and closing of posting periods, field status groups, document types, posting keys, etc.
• Configured relevant settings for Treasury Cash Management position, liquidity forecast, risk management, integration of FI with SD and MM and cash concentration.
• Integration of FI with MM and SD modules included fine-tuning interfaces with FI, GL, A/P, and A/R and also validation and substitution rules, order management, pricing, delivery and transportation and billing.
• Defined both basic reports and form reports for the business units by profit centers to analyze the profit at customer and product levels. Developed multiple reports for the reporting of profitability. Configured the flow of information from SD/CO-CCA/CO-PC/CO-IO/FI and MM, and carried out extraction of data from COPA to SAP BW system.
• Configured Maintaining Controlling Area, Assignment Of Company Codes and Control Indicators, Number Ranges, Standard Hierarchy Creation of Cost Centers and Cost Center groups, primary cost element, primary cost element groups revenue cost elements, secondary cost element Order Types and Number ranges for orders.
• Imputed costs calculation methods, cost element attributes, statistical key figures and activity types in Cost Center Accounting.
• Defined Assessment, Distribution, and Periodic Reposting of costs using cycle segment method in Cost Center Accounting.
• Created Profit Center standard hierarchy, dummy profit center, profit centers and profit center groups. Analysis using account assignment monitor.
• Costing variants for standard cost estimate for planned and actual Production orders
• Defined Settlement Structures and Allocation Structure in Internal orders.
• In Cost Object Controlling configured Product Cost by Order, WIP calculation and Variance Analysis using Planned and Actual Costs.
• Activated Profit Center Accounting, Defined Number Ranges, Activated Direct Postings and Maintain Plan Versions.
• ALE and IDOC’s, Developed inbound and outbound interfaces using standard, custom IDOC’sand RFC technology. Enhanced standard IDOC’s, Building partner profiles, distribution model and configuring SAP workflows for IDOC’s.
• Worked on New GL Document Splitting configuration- Activate Document Splitting, Classify G/L accounts, Classify Document Types, Zero Balancing document splitting GL account, Document splitting characteristic for GL account, Define Document Splitting method, rules, Assign Document Splitting method and Define Business Transaction variants.
• Activated New GL and Leading Ledger with creation of segments and assigning scenarios and customer fields in the parallel ledgers.
• Involved in working with House Banks, Check Lots, Check Register, Correspondence and void of Checks in Accounts Payable (A/P) and configuration of new void and reversal reason codes for check reversal. Involved in modeling of invoice processing, Disbursement run, check printing and bank reconciliation processes for Account Payable (A/P).
• Designed the process of payment proposal approvals for different payment methods like ACH, Wire, Check and P-cards in Account Payable (A/P).
• Maintained Lockbox configuration with BAI2 format, cash management, planning levels in treasury and on Electronic bank statements (EBS).

Confidential, North Wales, PA

SAP FICO Consultant

Environment: SAP ECC 6.0

Responsibilities:

• System configured and tested in the areas of FI-GL-transactions, Account payable (A/P) -paying vendor invoices, Account receivable (A/R)-customer credit, credit controls, applying cash, credit memo, dunning, Master data, CO-CCA-assessments/distribution, PCA-settings, hierarchy, account assignment objects, Product Costing with Cost Splitting Valuation - PA-structure, value fields, planning and reporting.
• Performed and resolved issues in Cost center assessments to segments, (CO-PA) reporting, forms, Planning, Derivation rules and structures, Product and customer hierarchy, PA settlement, realignments and integration issues with SD.
• In Cost Center Accounting Settings for Periodical Processing, Activity Based Costing (ABC), Order processing, maintain/ control Billing documents, Inventory management, Purchasing, Variant Configuration and complete design /configuration of general CO functionality (CCA).
• Setup Internal-Orders and Cost Collector configuration. Customized order classification establishing a sophisticated system of order settlements and cost center assessment cycles. Set-up planning profile for cost centers, activities and statistical key figures.
• The scope of CO included Product Costing and Profitability Analysis (CO-PA).
• Assisted client in design and configuration of PA transfer structures including decisions on characteristics, and settlement to (CO-PA).
• Technical work involved resolution of various issues in Product costing and Material Ledger.
• Created the characteristics and value fields, defined derivation structures and rules, maintained derivation table, and profitability segments used in profitability analysis. Defined various reports.
• Through knowledge in Defining Costing Sheet and calculating Overhead.
• Integrated Cost Object Controlling component in the SAP System, for planned budget using various costing methods, Cost Split, Cost and Valuation Variants in Product Cost Planning.
• Releasing Production Orders, Confirming Operations, Simultaneous Costing, final Costing, Price Transfer / Update, Confirmation/ Settlement, and Period-End closing.
• Developed IDOC’s for Sales Order, Purchase order, Invoice, and Advance Shipment Notification. Mapping of EDI and SAP documents. Produced customized segment types, IDOC’s types, extending IDOC’s, message types, function module, partner profile, port definition, user exit, and output determination.
• Developed program to create the IDOC’s with related transfer Order that automatically updates a custom table with release date and time.
• Worked closely with Supply Chain Management (SCM) and Warehouse Management, involved with LIV, goods receipt, goods issue, inventory management (FI-A/R).
• Performed data extraction, transformation, migration and reconciliation of GL Master, Banks, Business Partner, Market Data, Treasury Deals and A/c Balances during Cut Over Phase
• In Tax accounting performed creation of Input and output tax General Ledger accounts, setting up different tax codes in various countries and assigning them to GL accounts. Resolving user queries in Tax posting journal entries.
• Configured for vendors subject to withholding tax, interest calculations on item balance interest calculation, number ranges for forms, interest on arrears, account balance calculation on account balances line items.
• Transactions - Incoming Invoices/Credit Memos (terms of payment), Outgoing Payment, Incoming Payment, Dunning, Open item Clearing, Down-payment received, Down-payment made, Bill of Exchange, Special G/L accounts (other reconciliation accounts).
• Analyzed end user needs and propose viable solutions for report improvement, QA and user training in CO. Generated reports using tools like Report Writer, Report Painter.
• Provided System configuration, testing to the global Finance user base in the areas of GL, Account payable (A/P), Account receivable (A/R), Fixed Assets, Special ledger, programs on the ECC 6.0 environment.
• Troubleshooting issues involved in analyzing problems, configuring, testing, training and documentation of fixes. Provided production support for FI and related Account receivable (A/R) and SD integration touch points with FI.
• Integrated Fixed Asset accounting with internal orders, maintained settlement profiles for internal orders, Configured capitalization of assets under construction, assigned cost elements.
• Involved in Integration of New general ledger with Controlling for reconciliation activity through real time integration variant.

Confidential, Houston, TX

SAP FICO Consultant

Environment: SAP ECC 6.0 Full Life Cycle Implementation

Responsibilities:

• Worked in project preparation, business blueprint, and realization, final preparation to Go live & support using ASAP methodology.
• Defined Chart of Accounts, GL Master Records, Field status groups, Automatic account determination and Sales tax automatic account assignments.
• Configured FI-A/P and FI-A/R, Customer/ Vendor Master Records, Account groups, Tolerance groups, Document number ranges and account determination
• Defined Adjustment Account for GR/IR clearing by configured regrouping postings.
• Created Special ledgers for different types of special transactions.
• Involved in data migration from legacy systems to SAP through LSMW. Extracting Master data & transactions data to Non - R3 format, clean up data, mapping interfaces, loading data into SAP format (IDOC) and testing loaded data.
• Identified one time vendors and creation of one time vendors without duplicates.
• Created vendor master records, groups, vendor documents, number ranges, payment terms, discounts, Configured Automatic Payment Program.
• Configured and customized Account receivable (A/R) and Account payable (A/P) modules for vendors subject to withholding tax, interest calculations on item balance interest calculation, number ranges for forms, interest on arrears, account balance calculation on account balances / line items, foreign exchange calculations, automatic payment program, dunning program, credit management etc.
• Defined customer master records, customer groups, House bank.
• Designed, documented SAP (A/R) reports in coordination with ABAP developers for respective functional specs by creating libraries, report groups.
• Defined and assigned Reconciliation ledgers and maintaining accounts for automatic reconciliation posting.
• Worked with SAP (SD) functional team to ensure that account determination met all requirements.
• Involved in the configuration of Valuation areas, Multiple Currency types and number ranges, Movement type groups, Material update structure in the Material Ledger.
• Creation of Customer Account Groups, Billing, Payment terms and interest calculation, Incoming payments, Dunning, Account receivable (A/R) Information System, Credit Management, closing operations, sales order and Integration with SD and thereby improving the business process flow
• Asset Management (AM) implementation, configuring Asset classes, Master Depreciation and other business transactions. Fixed asset accounting, reconcile asset management to GL.
• Configured the chart of Depreciation and settings up the various depreciation areas like Book Depreciation.
• New General Ledger, Created of Chart of Accounts, Account groups, creation of new G/L accounts and Automatic account determination, Materials & SD postings.
• Configured the Chart of Depreciation Created procedural documentation for End users in Asset management (AM) module.
• Worked on Lockbox process configuration, bank statement processing, Cash management (CM) to monitor payment flows and liquidity and also worked on client’s lockbox banks to validate the inbound files.

Confidential, Chalfont, PA

SAP FICO Analyst

Environment: SAP ECC 6.0

Responsibilities:

• Involved in all the phases of Global implementation from development of business blueprint to end user training and Go Live, designed As-IS & To Be diagrams.
• Configured the New GL, AP, In the SAP system as a FICO Analyst.
• Setup Fiscal Year Variant, GL Accounts Group, Field Status variant and Document number ranges.
• Configured New-GL-Segments, Scenarios and assigned Segments to Profit Centers Configured zero-Balance clearing Accounts for document splitting.
• Designed and configured Automatic Payment Program(APP) and Account payable (A/P) Master Data, Vendor group, Vendor Field Status, Creating Vendor and Customer Master Data and Risk Categories.
• Configured EBS, check deposits, check forms and wire transfer and ACH Payment
• Configuration of Tax codes and tax Jurisdiction codes for the USA.
• Extensively involved in Implantation & support Project of CCA, PCA, COPA.
• Configured Controlling Area, assigned number ranges to controlling area, and maintained Versions.
• Created Standard hierarchy of Cost Center Accounting (CCA) and Cost center groups.
• Configured Activities types and Statistical Key Figures & assigned cost centers to cost elements & developed Allocation cycle for Assessment & Distribution.
• Configured EC-PCA by creating profit centers, standard hierarchies, assigned revenue elements, to profit center, planning profile and planning layouts.
• Developed contribution margin and user defined COPA profitability reports using report painter
• Configured the value flow from SD to COPA and also from FI, MM to COPA.
• Configuration of Product Cost Planning and Cost Object Controlling, Material Cost estimate with Quantity Structure which included costing variant, valuation variant, cost component split, costing sheets, cost component structure, BOM and routing settings, origin groups, overhead keys, and overhead groups. Configured Actual Costing/Material ledger.
• Performed Functional Testing for their new unit and designed the Custom Entities in Quality Centre as per the user requirement.
• Expertise in Integration, Functional, Regression, User Acceptance Testing, Performance and End-To-End Testing, Good Knowledge of SDLC, Testing Methodologies.
• Participated in testing using Solution Manager.

Confidential, Los Angeles, CA

SAP FICO Consultant

Environment: SAP ECC 5.0 Full Life Cycle Implementation

Responsibilities:

• Attended design sessions during Blueprint phase of project for specific area of responsibility.
• Prepared and issued invoices for projects according to terms of the contract.
• Managed all Accounts receivable (A/R) functions including account reconciliation and report preparation through Cost point.
• Posted client’s Accounts receivable (A/R) and generated daily deposit reports.
• Setup Fiscal Year Variant, GL Accounts Group, Field Status variant and Document number ranges.
• Determining the organizational structure by understanding business requirements, classified business units as company codes, business areas, functional areas and profitability centers.
• Conducted seminar on “Scope of CO-PA in Profitability Management”, different accounting methods involved and currency issues in Profitability Management.
• Configured Controlling Area and Operating Concern, maintained versions.
• Created primary and secondary cost elements in Cost Element Accounting, configured cost element groups, maintained cost element attributes.
• Created cost centers, activity types, statistical key figures, Cost Center Standard Hierarchy, cost center categories, document numbers, maintained default account assignments and automatic account assignments, validations and substitutions, overhead structure for accrual costs, allocations using cycle-segment method for periodic reposting, distribution and assessment, indirect activity allocations. Developed planning area, planning layout and planner profile.
• Configuring and Customizing Product Cost Planning (CO-PC-PCP) with Quantity Structure and Cost Object Controlling (CO-PC-COC) including product cost by order (product cost collectors and cost object hierarchies), by period (manufacturing orders) and by sales order.
• Involved in configuration of Product cost planning and cost object controlling.
• Configured costing variants, cost component structures in CO-PC for Standard Cost Estimates.
• Customized cost-based CO-PA to assign costs and revenues to the desired value fields to calculate contribution margins as per organization requirements.
• Defined additional characteristics and provided derivation rule to pull the target characteristic value, implemented derivation with move and derivation with clear functions. Good knowledge on sources behind the value fields.
• Configured valuation strategy prior to actual postings for storing estimates and performed planning by accessing pricing and product cost information.
• Implemented CO-PA planning for sales and profit planning by designing different planning layouts.
• Configured planning with ratios from actual reference data to plan/forecast revenues and integrated Microsoft Excel with CO-PA planning.
• Worked on issues related CO-PA in reconciliation with Financial Accounting.
• Involved in ‘cut over planning’ for moving configuration into production environment.

Confidential, Schaumburg, IL

SAP CO Consultant

Environment: Upgrade SAP R/3 4.7 to ECC 5.0

Responsibilities:

• Involved in the Upgrade from SAP R/3 4.7 to ECC 5.0 from testing phase to go-live and production support.
• Performed gap analysis between SAP R/3 4.7 and ECC 5.0 systems, analyzed functional changes or business.
• Resolved major concerns of the client regarding the upgrade to ECC 5.0
• Tested the entire configuration on the QAS Server using Test Director after Upgrade to ECC 5.0
• Track the defects and report for the enhancements to be done
• Performed table comparisons for major General Ledger (GL), Accounts Payable (A/P), Accounts Receivable (A/R), customizing tables to list the differences between SAP R/3 4.7 and ECC 5.0 systems
• Configured Lockbox BAI2 for customer payment processing
• Worked on the configuration changes for the business processes related to Finance and Controlling required as per the upgrade to ECC 5.0
• Configured validation and substitution rules according to new ECC 5.0 system.
• GR/IR ledger configurations. AP/AR Creation of reconciliation accounts for account receivables and accounts payables. Setup of automatic incoming payments.
• Configured Vendor and Customer master data and created vendor and customer groups.
• Configured for Customer and Vendor Master Data migration from legacy system to SAP system through LSMW (IDOC format).
• Worked on the integration issues of Finance and Controlling with MM and SD.
• Configured period end closing transactions and cross checked the posted journal entry batch in GL.
• Worked with GR/IR clearing Accounts from the MM side.
• Prepared and changed the documentation as required by the upgrade to ECC 5.0.
• Trained the end users and prepared training documents on using new ECC 5.0 system.
• Planned and performed all the activities in Cut-Over plan.

Confidential

SAP FI CO Consultant

Environment: SAP R/3 4.7

Responsibilities:

• Involved in understanding the Business Requirements, understanding Legacy system functionalities and customizations, gathered functional requirements through user workshops, Gaps identification and documented As-Is model and To-Be model
• Analyzed and reviewed all processes, user procedures, and system requirements.
• Documented creation of business process, configuration, testing, and end user training material.
• Developed test cases and executed test scripts to test integrity of related configuration
• Designed the legacy organizational structure into SAP company codes, controlling area, profit centers and cost centers. Configured and used LSMW for uploading master data of GL, customers and vendors
• Configured: Account Groups, Document types, Vendor and Customer master data, Document number ranges, Terms of payment, clearing functions - Posting Keys, Reason Codes, Tolerance groups, Bank master data in Accounts Receivable & Accounts Payable.
• Performed Fiscal year change, Year-end closing procedures in Asset Accounting.
• Successfully tested critical business transactions in the finance module including vendor and customer invoices and payments, document fast entry, G/L posting, and recurring entry programs.
• Worked with business users during integration testing on FICO month-end closing processes.
• Wrote test scripts in Integration testing. Complete business cycles across the sub modules were tested Integration of FI with SD and MM.
• Maintained cost element attributes, cost centers, standard hierarchy, cost center categories, distribution, and assessment in Cost element / Cost Center Accounting.
• Configured Standard hierarchies for Profit centers, created profit center groups and profit centers (CO-PCA).
• In Profitability Analysis (CO-PA), created the characteristics and value fields, defined derivation structures and rules, maintained derivation table and profitability segments.
• Training and Documentation of all relevant process UAT (User Acceptance Testing), Integration Testing, Test Scripts arranging and coordinating the testing activities, Trouble Shooting.
• Provided support in unit testing and system testing of FICO Module