PROFESSIONAL SUMMARY:

• Over 13 years of IT experience in implementing and supporting Finance applications. Certified SAP consultant with over 9 years of SAP FICO experience having carried out 2 full life cycle SAP implementation with multiple releases, 1 SAP global roll out and 2 SAP production support projects. Proven skill in Business process design, Configuration, Testing, Data migration, Cutover and Go - live. Good understanding of Record-to-Report, Acquire-to-Retire, Procure-to-Pay and Order-to-Cash business process. Hands on experience in finance month end and year end process. Experience working with a leading SAP consulting firms and teams in multiple geographies.
• Implementation and configuration of General Ledger (FI-GL), Accounts Receivable (FI-AR), Accounts Payable (FI-AP), Asset Accounting (FI-AA), Banks, Cost center accounting (CO-CCA), Profit center accounting (CO-PCA) and Internal order (CO-IO).
• Integration of FI with Sales and Distribution (SAP-SD), Material Management (SAP-MM) and POSDM.
• Exposure to SAP BI, SAP BPC and Solution manager.
• Other SAP Modules Worked - Project Systems (PS), Configuration of SAP SD for non-Merchandise sales, SAP MM for expense purchase order, Logistics Invoice Verification and Billing processes.
• Mapping & Conversion of master data from legacy system to SAP using LSMW and Idoc.
• Integration of Vertex with SAP. Worked in both internal and external tax interface configurations.
• Experience in designing the integration framework from external applications to SAP, Reconciliation, Error handling and Reporting.
• Requirement gathering, conducting Design workshops, creating Business process design, Functional specifications for RICEFW, Role definitions, End user training and cut over activities.
• Experience in setting up a new SAP support team, transition from implementation team, created dash boards for month end and year end close process.
• Industry experience: Retail, Insurance

TECHNICAL SKILLS:

SAP ECC 6.0 (EHP6), Simple Finance, S/4HANA 1610, SAP IS retail, SAP AFS, SAP BPC, SAP BI, Solution Manager, HP ALM, HP Service manager, DB2, SQL, ARIS business modelling tool, Advantage Gen.

PROFESSIONAL EXPERIENCE:

Process and Data Lead

Confidential, New York, NY

Responsibilities:

• Studied the as-is Confidential reporting process for 180+ entities across 50+ countries and identified the improvement areas in terms of process and system.
• Performed Data modelling to understand the underlying data structure of GL systems in Computron, SUN, SISE, Orion, Mainframe and JDE ledgers.
• Created Data profiling dashboard for data quality analysis and completeness of code blocks required for reporting
• Created template for Data Modelling questionnaire to understand source ledger functional processes, ETL questionnaire for database connectivity, Data Dictionary to understand source ledger data structures, Functional library for mapping of source ledger to SAP ledger and Extraction logic, Remediation Log to identify the data remediation issues in source ledger.
• Designed an integration framework, error and suspense correction process, conversion and interface strategy to interface the GL data to SAP.
• Presented the data integration results, UAT test results and Financial reconciliation results to the corporate, regional and country controller ship team for sign-off.
• Standardized the code blocks required for Confidential reporting and Management reporting and prepared a common financial language that can be used across the organization.
• Established Master Data Governance process for GL accounts, Profit center, Cost center and custom code blocks like Regulatory line of business and producing office.
• Reengineered the Revaluation process, Translation process, Manual journal entry approval process and General operating expense allocation. Created the to-be Business Process Design.
• Identified the remediation items in the source ledgers and resolved the data quality issues working with the Controllership team of each country.
• Automated the data enrichment process for Intercompany transactions, underwriting and expenses for accurate Management Reporting.
• Partnered with Finance warehouse (SAP BI) and Corporate Consolidation team (SAP BPC) to establish Financial data flow and reconciliation from SAP ECC to SAP BI to SAP BPC.
• Created global template for Company code setup and Functional specification for interface of GL data from various source GL platforms.
• Created functional specification for reconciliation of ledgers using Solution Manager
• Automated the posting of reclassification entries for the mapping changes between Source and SAP ledger.
• Configured Chart of accounts - group account number for unit level consolidation and alternate account number for parent level consolidation, Company code, posting period variants, Balance sheet and P&L revaluation, Translation, Exchange rate types, Document types for auto reversing entries, Validation and substitution rules.
• Configured alternate hierarchy for cost center, allocation structure, statistical key figure and assessment cycles.
• Prepared test cases and uploaded them to HP ALM. Executed cut over and go live tasks.
• Trained the Finance center managers on the newly established closing process, provided shadow support and transitioned the operational process to support team.
• Created the use cases for Robotics to automate the monitoring the interface and error handling POC Simple finance migration:
• Performed analysis for migration to simple finance and created a proof of concept for US domestic and international entities

SAP FICO Lead

Confidential, Secaucus, NJ

Responsibilities:

• Primary owner for Business process design of Procure to Pay (Non Merchandise procurement) and Acquire to Retire business process design. Secondary owner for Record to report.
• Created Functional Specification documents for GL interface to Hyperion, Invoice interface from ASPEN, Payment interfaces which included Wire payments to Confidential and TD bank, ACH payments to Confidential, Check interface to check printing system and Positive pay file. Workflow for Invoice approval and tax review.
• Configured Finance Enterprise structure, Chart of accounts, Parallel ledger, Document splitting rules, Financial statement versions, Foreign currency valuation and Translation.
• Configured Purchasing Enterprise structure, PO release procedure and Work flow, Vendor Master, Automatic Payment program and Vendor account statement.
• Configured 1099 Vendors, Tax jurisdiction codes, Tax interface with Vertex for Sales tax, Input tax and Use tax in US and Canada.
• Configured Asset Accounting - Book and tax depreciation areas, Depreciation Keys, Settlement of Internal order to Confidential, Acquisition of asset integrated with AP, Retirements, Transfers, Asset impairment and Settlement of Internal order to Confidential .
• Configured Controlling area, Created planning versions, Standard hierarchy for Cost centers and Profit center, statistical key figures and Developed allocation cycles and Segment for expense allocation.
• Configured Project systems for capital Store construction, DC, IT and expense Corporate and Marketing projects and flow these costs to Confidential .
• Configured Validation & substitutions for Profit center and Cost center substitution. Created LSMW data uploads for GL accounts, Cost center, Profit center, Asset and Vendor master.
• Test script preparation and execution of Integration Test Cycles using HP ALM. End user role requirements and authorization.
• End User Training and created manuals for period end closing processes like Foreign currency valuation, Translation, Reclassification, Depreciation and Asset impairment, Reconciliation of GL account balances, open and closing periods.
• Created Business Process Design for Accounts Receivable including Billing for International/Franchisee sales, Intercompany billing, Wholesale Sales and Gift card bulk sales.
• Created Business Process Design for the Cash Sweep process from the individual bank accounts to the concentration bank account, reconciling the payments from credit card providers, Credit card fees and Bank fees.
• Created Business Process Design for Merchandise Account Payable process which included three-way match (LIV) and payment of Confidential Invoices, Freight Invoices and Customs Duty.
• Created Functional Specification Documents for Invoice interface from merchandise vendor, freight vendors and Payment forecast report for Confidential .
• Configured the Account determination for Inventory movements, Revenue account determination, Tax account and FI-POSDM interface for Revenues, Tenders and Paid-in/Paid outs.
• Configured Customer Master, Customer Credit Management, Dunning, Payment processing, Electronic Bank Statement for reconciliation and Correspondence.
• Configuration of Sales order types, Pricing procedure, Tax withholding for international customers, Output determination and Billing for non-merchandise sales.
• Configured Logistics Invoice Verification, Tolerance keys for price and quantity variations, Vendor specific tolerances, Evaluated Receipt Settlement and Posting of unplanned costs.

SAP FICO/BI lead

Confidential

Responsibilities:

• Played a key role to set up a new production support team at Confidential India.
• Provided shadow support and transitioned the knowledge to support team.
• Designed SAP support team roles for all FI modules.
• Analysis and requirement gathering for new enhancements and coordinating the monthly release.
• Assisted BTO’s/End users in monthly closing processes with closing cockpit functionality and automatic inter-company reconciliation. Upload of winshuttle template for posting FI entries.

SAP FICO Consultant

Confidential, Minneapolis, MN

Responsibilities:

• Responsible for creation of business blueprint for Accounts Receivable process which included more than 20 types of receivables.
• Responsible for creation of business blueprint for Accounts Payable process which included Automatic payment processing, Recurring invoice entry and payment, Escheatment process, 1099 process and Accounts payable closing.
• Created to-be business process flows to Maintain Customer Master Data, Execute Credit Analysis, Dispute Management, month end and year end closing.
• Designed the Bank Reconciliation Process which included 11 banks with more than 70 accounts in two separate SAP instance.
• Created functional specification for interfaces which included Invoice interface in EDI format, inbound electronic payment, ACH and Wire payments to Bank and EDI 835 claim payments.
• Configured the Tax procedure and Tax codes for the sales tax, use tax and withholding tax.
• Configured the Invoice approval workflow based on the Invoice data from the AP Imaging system.
• Configured Customer Account Groups, Dunning Process, Reason codes for payment difference, Interest calculation and Open item clearing.
• Executed data conversion for Customer and Vendor Accounts.

SAP FICO Consultant

Confidential

Responsibilities:

• Responsible for creation of business blueprint documentation for Record to Report process which had 60 company codes and two segments.
• Created to-be business process flows to Maintain GL Master Data, Manage Journal entries, Intercompany reconciliation and Manage closing.
• Involved in design of the Common Interface Framework for GL data interface with SAP ECC from more than 20 applications which included Lawson, People soft, PACMAN-Fixed assets, Sales Audit, ecommerce applications, Credit card applications, Inventory applications and Hyperion.
• Enhancement to split the documents with more than 990 line items.
• Created a common operating chart of accounts consolidating seven charts of accounts used by various companies. Five Fiscal year variants were created to meet the reporting needs for the legal entities.
• Configured Financial Accounting enterprise structure, Controlling enterprise structure, Extended document splitting, Exchange rate load, Foreign currency revaluation and Financial Statement Versions.
• Performed data conversion for GL Master data, GL account balance at profit center level and GL line item conversion for clearing accounts.
• Created Test plans, End user Training materials, Cut over plan, Security roles in compliance with SOX regulations.
• Created period close task list and provided transition to support teams.

Senior Business Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Analyzed 30+ finance applications and prepared a roadmap for SAP implementation and retirement of legacy applications

Application Owner

Confidential, Minneapolis, MN

Responsibilities:

• Worked as primary application owner at client site for various finance applications.
• Collaborate with the business community to identify the Application issues, Compliance needs and Reporting requirements. Estimate the effort required to build, test and deploy the enhancements
• Execute finance month end, year-end processes and suggest business process improvements.
• Coordinate with the team members across three locations - onsite, nearshore and offshore model

Enterprise Finance Support

Confidential

Responsibilities:

• Offshore application owner for various finance applications - General ledger, Accounts Receivables, Lawson Accounts Payable, Sales processing and audit, Key Performance Measures and Financial Reporting.
• Support the system job flows and recovery of the failed business processes.
• Monitor Finance month end and year end processes.
• Analyzed the application failures and created permanent resolution through code fix, performance tuning and eliminating redundant business processes.
• Worked on service requests to execute ad-hoc/rerun of finance month end and year end business processes, GL, AP, AR interfaces, Fixed Assets year end close.