SUMMARY:

• Over 11+ year’s SAP R/3 functional experience in various areas of FI/CO.
• Expertise in Classic GL, New GL and Simple Finance S4/HANA.
• Expertise in O2C - Order to Cash, P2P-Procure to Pay, R2R-Record to Report & PO -Production Order Cycles
• Involved in three FLC (Full Life Cycle) projects and one version upgrade.
• Experience in Implementing, Configuring FI/CO and integrating with SD/MM and external interfaces including credit cards, CTE Concur travel and expense tool etc.
• Performed Business requirement collection, project analysis, process design, blue print, GAP analysis, design, upgrade, Production Support and train IT and end user staff.
• Knowledge of compliance with Sarbanes-Oxley (SOX).
• Very Good Demonstration & Presentation Skills of Software Products, Documentation of Training materials & manuals and conducting training sessions.
• Possess Strong Communication, Analytical, and Project Planning, Problem Solving Techniques combined with a variety of Functional skills.
• Demonstrated ability to work both in independent and team-oriented environments with well-developed organizational skills, excellent communication and interpersonal skills with problem solving ability.
• Strong experience in documenting existing process, analyzing business requirements, re-engineering business processes and designing.
• Solid understanding of implementation methodologies (ASAP) with project experience in all phases - Business blue print, Realization, Testing, Go-live preparation, Go-live, Post live support.
• Extensive working experience across various industries Retail, Chemical, Telecom and Print technology.

PROFESSIONAL EXPERIENCE:

Confidential

SAP FI/CO & BPC Architect & Lead Analyst

Responsibilities:

• Proof of Concept for S4-HANA migration to New Asset Accounting
• Checked the prerequisites for the migration to New Asset Accounting. (FI-AA, Parallel Valuation(FIN AA PARALLEL VAL) in SAP enhancement package 7 for SAP ERP 6.0) using import program RASFIN MIGR PRECHECK - SAP Note 1939592
• Validated multiple valuation approaches: Leger Approach and Account approach.
• Usage of new depreciation calculation engine.
• Configured associated changes including creation of Accounting principles and ledger groups. Assignment of accounting principles to ledger groups for both approaches. Assigned an accounting principle to each depreciation area. Additional depreciation area set up for additional currencies defined in the company code. Defined technical clearing account for integrated asset acquisition. Defined Asset Balance Sheet Accounts of Parallel valuation as Reconciliation accounts. Defined document types for integrated transactions.
• Proof of Concept for Profitability Analysis with Simple Finance for Account Based COPA integrated in the Universal Journal. Cost Based COPA is not integrated but fully supported. Usage of advanced derivation functionality.
• BPC Planning: Allocation of Back Margin accruals and rebates based on actual gross revenue, cogs and units for a combination of GL Accounts & ORC - Order Reason Code combination.
• Involved in understanding the requirements for back margin allocation and designed the model to pull data from the COPA module in SAP thru HANA into the BW/BPC system.
• Designed the following standard allocation methodologies - Sell in Revenue Current Quarter, Sell in Revenue Previous Quarter, Sell in Units and COGS. Designed the allocation trigger for unique methods including Allocation of Accrual Reversals and Auto Rebate postings
• Specified the driver data sources for allocation trigger based on ABCOPA Actuals including Sell in Revenue Current and Previous quarters, COGS and Auto Rebate FS Line Hierarchies
• Prepared reports for Pre-allocated and Post allocated data
• Designed the UI for the Allocation Rule Maintenance (GL & ORC combination), FPH to Dummy part mapping - Data is at product family level and driver data is at the product level. Allocation Trigger
• Cost based COPA: In Profitability Analysis configured costing based profitability analysis. Defined and configured the reporting characteristics, value field, profitability segments used in profitability analysis including Order reason Codes.
• Configured the derivative structures and rule for characteristics. Defined both basic reports and form reports for the business units 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/FI and MM, and carried out extraction of data from COPA to SAP BW system
• Account Based COPA: Implemented Account Based COPA for reporting with additional characteristic ORC - Order Reason Codes for the Global COPA project.
• Helped in designed new automatic posting utility for month end adjustments (OCOGS and contra revenue adjustments) with COPA characteristics
• Developing rules and filters to be applied for extracting COPA data from R/3 to BW system.
• Custom reconciliation reports (using summarization levels) for assisting in reconciling FI and Account based COPA data and developed a custom data completeness check for data extracted by BW system
• Redesigned the solution for Auto Rebate functionality with new ORC- Order reason codes updated at the Profitability Segment level to help the downstream allocation purposes as part of the Global COPA project at Apple.
• Revenue Recognition: Involved in developing revenue recognition solution for global rollouts of ITunes related products, I Phone, iPad, Software, Apple TV, ADC - Apple Developer Conference and iPod Touch
• Involved in the design of a scalable solution for revenue deferral for Subscription revenue of software bundled with hardware and Software/service Revenue Recognition
• Implemented systematic scalable solution (eliminated standard revenue recognition performance issues in SAP) for new accounting rule EITF 09-03
• Involved in the design and implementation of Revenue and COGS contracts for ITunes Service Products.
• Worked on the design for planning and forecasting models for subscription products
• Developed solution for accurately capturing Front and backend margin to resellers in the transaction system
• Designing solutions for the local GAAP requirements for subscription product line.
• Design key aspects in Profit center accounting POC
• Involved in development of custom BW extraction report for Deferred and Amortized Revenues.
• Configured Item Category and its settings for periodic and Installment Billing along with SD team
• Extensively worked on FI, SD and MM integration
• Designed a new GRIR report to fetch data from MM tables instead of FI tables
• Designed budgeting in the Asset Accounting module with the use of statistical internal orders and settlement of internal orders to Assets. Created cost elements with category 90 for asset balance sheet accounts for the acquisition and production costs of Assets.
• PCS – Payment Consolidation System: Converted existing outbound payments from IDocs to XML generated directly from the payment workbench in payment print program. Aligned the Amendment and Cancellation idoc programs with the new changes for the payment consolidation system process.
• Configured DMEE tree & FBZP configuration for the XML file generation in the payment cycle for both Credit and Debits.

Environment: SAP R/3, Version 6.0

Confidential, Foster City, CA

SAP FI/CO Senior Analyst

Responsibilities:

• Involved in the Activation of New GL Accounting, Defined Leading and Non Leading ledgers for GL Accounting, Integrating the GL with subcomponents, Document splitting, Segmentation and Parallel Accounting, Controlling Component Transfer postings, Integration with Asset accounting.
• Involved in the creation of three new company codes EFI Canada, EFI UK and EFI Newzealand.
• Involved in the cut over strategy including configuration of new company codes, migration of data in AR, AP and the asset accounting module from legacy systems to existing SAP R/3 environment
• GL upload program. Worked with the development team to create a transaction in the front end and a journal upload BAPI at the back end to post journal entries, post journal entries with tax, park journal entry, reverse journal entries and accrue and reverse journal entries via an excel template in text format.
• Created recurring entry documents with automatic run schedules via batch jobs in SM37. Monitored failures in transaction SM35.
• Upgraded Concur Classic to new CTE (Concur Travel and Expense Interface). Activated the Concur pilot roles for select business users and gleaned feedback before the final CTE rollout. Updated the help and documentation for the new interface. Implemented the Concur receipt attachment functionality, Google map integration and mobile interface. Activated EFI Canada and APAC counties for Concur and updated all interface programs with the new company codes including AP module with APP configuration for ACH. Monitoring the incoming expense files from Concur to SAP FI via batch job transaction SM37.
• Primary support for Concur expense and travel tool for US/Europe and India
• In AR Configured automatic account assignments in the integration efforts of FICO with SD including maintenance of the revenue account determinations and implementation of revenue recognition for contracts with a periodic billing plan.
• In AR worked with the development team to generate an automated account statement in PDF format to customers based on a customer aging report with selection criteria for customized input.
• Cognos upload program for revenue accounting. Worked with the development team to create a transaction in the front end to upload revenue entries into Cognos and a Z table in Sap with additional Customer information including Ship to/Sold to, Customer hierarchy information with the ability to post, park, reverse and accrual reversals.
• Pay metric Upgrade project for Credit Card integration to SAP. Involved in the project for level 2 & Level 3 processing solution with Xipay on demand to enable transmission of level 3 data to the merchant processor paymentech for Europe and Vital for all US company codes.
• Outsourcing of Freight Invoicing via the CTSI process. Worked with the development/basis team to have an incoming file from CTSI (to whom we did our outsourcing for freight invoice recording) for posting freight Vendor invoices. Also sending a file via the FTP process with Vendor payment information. Monitor the failures of the load via transaction SM35 and help in processing the failed files and support.
• Xactly project interfaces. Improved the customer payments data file via a Z transaction code for the commissions extract for Xactly.
• Integration with Black line systems. Worked with the development/basis team to extract GL, AR, AP, FA sub ledger balances from SAP for all company codes for reconciliation into external software Black line systems. For the fixed assets sub ledger extract every month on last day as SAP does not save sub ledger balances for FA historically and EFI reconciles the last day balances.
• E Payables project worked with the development/basis team for sending the payment file to E payables after payment run with a new payment method. Also create a new transaction code for incoming file from E payables to clear SAP payment documents.
• Lockbox configuration, Configuration of lockbox for BAI2 file including defining the lockbox, lockbox control parameters and defining lockbox posting data. Monitoring the incoming lockbox files from BOA via batch job transaction SM37, post processing lockbox support for applied, partially applied, On account and unidentified status.
• Electronic Bank Statement. Configuration for EBS including defining electronic bank statement transaction types, Assigning transaction types to house banks, Creating keys for posting rules, mapping external transaction codes to posting rules and posting rules account assignment.
• Vendor payment advices via Email in PDF format for all company codes in Europe in alignment with the practice for the US company code
• GRIR clearing initiative, worked with the development team to create a new Z table for substitution of GL Accounts/Cost Center/ Profit Center and Asset Masters for errors arising from MR11. Developed a test strategy for running F.13 and clearing open item managed accounts with minor differences.
• Configured new allocation methodologies for Assessment cycle with Fixed amounts specified and with fixed percentages.
• Conducted workshops for Finance on Basic FI reporting functionality, all sub processes in AR and Asset Accounting including super user training for Europe and India.
• Created special GL indicator Y for distinguishing prepaid inventory in a different GL bucket from existing advances and down payments from Vendors.
• Created new Asset class building improvements to demarcate building improvements from leasehold improvements.
• Configuration of Product Cost Planning, Product cost by order, period (made to stock/ repetitive manufacturing) and Product cost by Sales Order (made to order/ discrete manufacturing).
• Product cost planning including configuration of costing sheet, costing variant and cost component structure.
• Configuration of base planning objects, material quantity without quantity structure, material costing with quantity structure and cost run for Vutek EFI subsidiary. End user support and month end activities including Overhead calculation, WIP, Variance calculation and settlement.
• Inter-company STO process for a new plant and inter-company customer combination for Europe.
• Worked with the development team to change the standard logic for Vendor invoice verification with SAP business transaction events. They are standard customer enhancements by SAP.

Environment: SAP R/3, Version 6.0

Confidential, Naperville, IL

SAP FI/CO Senior Architect & Consultant

Responsibilities:

• Lead FICO Analyst for DOF - Distributed Order Fulfillment Project at client Confidential
• Analyzed the as-Is system, did a profound GAP analysis and successfully designed and mapped the To-Be system with the SD consultant.
• Conducted interviews with users to gather requirements and to understand the workflow of the As-Is system of the inter-company process (DOF- Distributed Order Fulfillment project)
• Analyzed and reviewed all processes, user procedures, and system requirements for the DOF project.
• Configured FI revenue recognition settings including FI account set up (U/R & D/R) customized Account determination for deferred revenue (D/R) account settings and unbilled receivable (U/R) account for a partial billing plan scenario.
• Configured the deferred COGS and additional Accrual accounts to post in the customer invoice.
• Configured a subset of deferred Inventory postings in the system
• Configured the Automated Vendor Invoice receipt process via IDoc’s (ALE) and inter-company accrual additional postings at the customer invoice level for all sales org/plant combinations.
• Worked with user exits to populate the trading partner fields at the Customer invoice, Inter-company invoice and Vendor invoice receipt postings.
• Automated the inter-company process with the automatic creation of the AP Vendor Invoice receipt thru EDI and ALE.
• Created flowcharts and got it approved from Key users, and created Business Blue Print for the existing processes.
• Configured company code, posting period variants, opening of posting periods, fiscal year variants, field status groups, document ranges, tolerance groups, and assigning the variants to company code etc.
• Configured and customized General Ledger, creation of G/L accounts, screen layout rules, automatic account assignments, financial statement version, validation and substitutions for new company codes.
• Configured and customized Account Receivable and Accounts Payable modules including creation of Vendor Master Records, account groups, tolerance groups, account determination, and default account assignments for the new company codes.
• Configured House Banks, Payment Programs, Automatic Payment Methods, and Alternate Bank Selections for Payments. Checks Management through assigning number ranges for check lots, checks printing and defining void reason codes. Posting Invoices with and without Invoice Verification.
• In Cost Center Accounting, 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, distribution and assessment.
• In Profit Center Accounting, configured Profit center structure, Standard Hierarchy, Configured Profit center Master Data, assigned different Controlling Objects to Profit Center Accounting.
• Responsible for identifying and documenting all FI GL, AP, AR, CCA and PCA test cases.
• Generated reports using Report Painter and Report Writer.
• Performed Unit Testing. Prepared Documentation for business users. Performed End User Training. Production Support after the go-live.

Environment: SAP R/3, Version 5.0

Confidential, Deerfield, IL

SAP FI/CO Senior Business Analyst & Architect

Responsibilities:

• FICO Analyst for the RTS Implementation & Build teams (Reseller Technology Solutions) at client Confidential (UNITED STATIONERS SUPPLY COMPANY)
• Configured Asset class, asset master records, and chart of depreciation, acquisition, scrapping, inventory lists, and history sheets. Also involved in the setting up of capital assets that represented a majority of assets that Confidential owned
• Configured the Country chart of Accounts for subsidiary based in France.
• Configured Foreign Currency Translation of all transactions for the foreign operations for month end management and legal reporting.
• Configured the global settings of G/L, such as creating G/L master data, cross-company code transactions, and Integration.
• Configured Special G/L transaction, such as down payment program to meet the customer requirement.
• In Accounts Receivables, configured Customer Master Data and master groups. Configured Automatic Dunning program for overdue customers by setting up dunning. Defined cash discounts based upon payment terms, Lockbox Processing for incoming payments. Configuration of terms of payment and interest calculation on open items/ balance outstanding.
• In Accounts Payable, created Vendor Master Data, configured vendor groups, vendor field status and assigned number ranges for vendor account groups. Configuration of payment program for posting invoices with and without invoice verification. Customized accounting transactions for postings and recurring entries.
• Configured Controlling Area, assigned number ranges to controlling area, and maintained versions.
• Created primary and secondary Cost Elements created cost element groups and assigned number ranges to groups. Configured automatic and manual cost element creation.
• Created cost center standard hierarchy, configured the Reconciliation Ledgers, activity types and statistical key figures.
• Created order types and Order Master Records and assigned the order master records to the respective order types. Created order groups to process the orders collectively.
• In Profit Center Accounting, maintained the basic settings, created master data for profit centers, profit center groups, Dummy Profit Center, profit center hierarchy, activity types etc.
• Configured profit center structure, standard hierarchy, master data, and assigned different Controlling Objects to Profit Center Accounting.
• In Product Costing Configured the material cost estimate with and without quantity structure, configured cost object controlling, variance calculations, maintained settlement structures, and configured costing variants in Product Costing.

Environment: SAP R/3, Version 4.6C

Confidential

SAP FI/CO Cross-Functional Consultant

Responsibilities:

• Involved in production support for FI and CO sub modules including GL, AR, AP, Bank Accounting, CCA, and Internal order Accounting and Profit Center Accounting.
• Responsible for gathering business requirements, participating in system design, configuring and testing existing system applications and providing post implementation support for enhancements to the current system.
• Implemented Company code configurations; including defining company codes, business area, fiscal year variants, posting period variants, chart of accounts, account groups, retained earnings accounts, field status variants, tolerance groups, document types and entering global parameters for new acquisitions for end clients
• Implemented Asset Accounting: Including reference chart of depreciation, assigning chart of depreciation to company code, specifying account determination, screen layout rules, number range intervals, asset classes and depreciation keys and migrated Asset Master data for legacy systems
• Performed Unit Testing, Integration testing, functional testing and assisted with User Acceptance testing. Prepared Documentation for business users. Performed End User Training. Production Support after the go-live
• In Accounts Payable configured end to end module including Vendor groups, vendor master data, house banks, bank accounts, check lots, automatic payments, recurring entries, invoices, credit memos, closing procedures, AP information system, integration with MM on LIV (Logistics Invoice Verification)
• In Accounts Receivable configured Customer groups, customer master data, billing, payment terms and interest calculation, incoming payments, dunning, AR information system, account systems, credit management, cash discounts, closing operations, sales order, and migrated open AR data from legacy systems using LSMW.
• Tested Z transactions as per the user requirements and worked closely with the users during month, quarter and year-end support.

Environment: SAP R/3, Version 4.6B