SUMMARY OF EXPERIENCE:

• Over 16 years SAP experience in analyzing, developing, implementing and managing applications that support SAP suite of products.
• SAP project manager and solution architect with extensive hands on experience in BPC, SAP ECC FI/CO configuration, Xcelsius, SEM - BPS, BCS, FI/CO, CO-PA, GL, AR, AP, AM, CCA, PCA and PC on various versions of SAP 6.0 being the latest and HANA, BI, BW and BOBJ. ASUG SIG Chair for Professional Services Industry
• Big 5 experience along with experience in professional service industry, semiconductor, high tech, pharma, life science, insurance, energy, consumer products, apparels, gas and electric, communications and engineering services.
• Successful global project execution experience with offshore model.
• Managed onsite and offshore teams ranging from 4 to 30 consultants.
• Served as capability lead for financial and performance management practices.
• Monitored Quality Assurance on project.
• Industry expert with technical skills and strong management skills.
• Ability to work clearly and effectively under pressure and complexity.
• Strong analytical ability with problem solving skills.
• Experienced in BPC 10 NW Planning and consolidation, Input schedules, Reports, functions, script logic, dimension logic, Excel formulae, VBA scripts .
• Experienced in SAP R/3 FI/CO 4.7 EE through ECC 6.0.
• Expert in COPA, Cost Center Accounting and Profit Center Accounting.
• Extensive experience on ASAP methodology, architectural design, development (hands-on), testing, cutover, training and support activities.
• Implemented BPC and SEM BCS and BPS, IP for financial planning for income statement, balance sheet and financial consolidations (legal and managerial consolidations).
• Created BPC reports, input schedules, data manager packages, security setup, advanced script logic, currency conversions, intercompany eliminations using logic and business rules.
• Strong data management skills including defining data manager packages with conversion and transformation settings for loading master data and transaction data.
• Supported data integration team in automating data loads.
• Extensive experience in SAP BW/BI with proficiency in BI Architecture, Data Modeling and BW tool set including creating InfoCubes, MultiProviders, DTP, Transformations, DataSources and BI Integration.
• Experience in data administration, data load process, process chains, data validation and monitoring within BI.
• Knowledge on business content, CO-PA and custom extractions.
• Hands on experience with consolidation methods such as equity, proportionate and purchase.

PROFESSIONAL EXPERIENCE

SAP Solution Architect

Confidential, Montvale, NJ

Responsibilities:

• Solution architected the HR planning for Global and rolled out to Hong Kong, Macau and China
• Created new aging reports for Debtors and with reconciliation to ECC data .
• Created Dash Board for Receivables KPI’s
• Created Dash Board for Utilization, Revenue and Cost KPI’s
• BPC and, BI reports for HR Planning
• Solution Architected the BPC solution for HR - Planning including the following
• Top Down planning and synchronization with Bottom up planning
• Implement product costing and material ledger.
• Provide solution to commingled inventory between Swiss Principal and US companies.
• Provide over all deliver oversight on tax procedures, treasury functions including bank reconciliation statements, liquidity forecast and Electronic Bank statement.

SAP BI Solution Architect

Confidential

Responsibilities:

• Treated business area in SAP as a SBU for Confidential as they underwent reorganization frequently; historical data required realignment with revised master data.
• Reviewed existing structures/reports requirements and suggested changes to master data and accomplished reporting requirements with a combination of Cost Center, WBS element and internal order.
• Designed BW structures for above reorganization process, architected summary and detailed drill down reports with exceptions.
• Provided solution for financial planning using BI-IP and BPC.

Project Manager and Solution Architect

Confidential

Responsibilities:

• Designed cost components and allocation processes using assessment cycles.
• Calculated plan and actual activity cost to transfer cost of manufacturing with primary and auxiliary cost components.
• Activated material ledger with actual costing, for single/multi- level valuation and material ledger close.
• Designed details cost reports with production variances.
• Enabled detailed cost and revenue planning in COPA.
• Created assessment cycles to transfer marketing and travel expenses to customer and product segments to calculate customer wise and product wise profitability duly reconciled at GL accounts level.

Project Manager and Solution Architect

Confidential

Responsibilities:

• Responsible for scoping, planning, blueprinting, developing and implementing Business Intelligence applications.
• Worked directly with business leaders to better articulate metrics and reporting needs, driving information architecture strategy across enterprise, creating a more consistent and robust reporting capability.
• Designed, prototyped, architected and delivered cost planning solution using EMP10.
• Maintained business rules for multicurrency translation, FXTRANS currency translation functionality maintenance with required dimensions, properties and applications.
• Maintained script logic for intercompany elimination, business rules and process chain maintenance.
• Created and maintained planning appset, application such as product line consolidation, rate, ownership and planning.
• Extensively worked on documentation, training users and supported BPC system.
• Involved in troubleshooting BPC performance issue using SAP Tools.
• Designed, prototyped, architected and delivered dashboard for global spend across 8 counties for 1000 users.
• Managed team of 4 developers, 6 functional analyst and 6 core team members.
• Extracted data from ECC, MFGpro, Oracle Applications and custom databases.
• Worked on LCM tool to migrate and SNP for security design and authorization.
• Designed BI objects including cubes, DSO and queries.
• Designed for BOBJ requirements including.
• Provided Universes, web services, Webi reports and dashboard design with drill down capabilities.
• Designed security requirements for dashboards.
• Designed future looking metrics and with interactive capabilities and supplier portal to manage Tier 2 price.
• Conducted workshop for requirements and quickly developed prototypes for early buy in by user community.
• Conducted periodic meeting with various stakeholders to keep them in notified on developments
• Provided leadership and support in areas of where users and developers needed insight/guidance and provided solution road map.
• Managed user expectation and managed scope.
• Avoided any scope creep and successfully delivered project on time and within budget.
• Created several templates for project documentations.
• Managed HPQC to track all issues and resolved all issues in a timely manner.

Environment: BPC NW 10.0 BW 7.3 and BOBJ 4.0.

SAP Solution Architect and FI/CO Team Lead

Confidential

Responsibilities:

• Implemented SAP ECC 6 for packing plant in Pennsylvania; earlier all their packing process were outsourced to Contract manufactures
• Implemented the following modules:
• FI - AP, GL and Asset Accounting
• CO - CCA, Product costing, Material ledger, Multiple valuation, PCA and COPA
• MM and PP Designed, developed and implemented product costing and material ledger with multiple valuations.
• Created cost component structure with primary cost component split, costing variant with costing type, valuation variant for local valuation and group valuation.
• Configured inter plant transfer which include cost transport from CMO and packing plant to 3PL locations.
• Designed and implemented process to track cost of own packing and cost of packing with CMO with one plant.
• Designed and implemented assets procurement and capitalization and integrated with project systems.
• Designed and implemented AP process as part of P2P process for procurement of API, packing materials, consumables and services.
• Performed 2 rounds of integration testing and User Acceptance Testing; system was signed off with validation and went life in January 2012.

Environment: BPC NW 10.0 BW 7.3 and BOBJ 4.0.

Solution Architect and Project Manager

Confidential

Responsibilities:

• Migrated forecasting, budgeting and financial consolidations solution from BPC MS to BPC NW platform.
• Utilized SAP BPC for revenue/COGS, headcount, OPEX, CAPEX planning and financial consolidations.
• Led blueprinting and detail design sessions with client.
• Assisted client manage project to keep it on schedule and under budget.
• Executed initial appset migration including applications, master/transaction data and reports from MS platform to NW platform via SAP migration utility tool.
• Wrote script logic for Cost Center assessments, Profit Center allocations and headcount/salary calculations per NW standards with improved efficiency and enhanced functionality.
• Configured business rule to perform I/C eliminations: AR/AP and revenue/COGS and NI to CYRE reclassification.
• Worked with ABAPER to write BADI functions to execute complex logic calculations.
• Built complex input schedules and reports.
• Perform migration of same from BPC MS to NW.
• Configured DM packages for transaction data loads from SAP BW.

Solution Architect

Confidential

Responsibilities:

• Served as advisor responsible to review, recommend and fix issues so monthly forecast and financial consolidation was effectively used.
• Responsible for consolidation and rate application for forecasting and analysis of revenues in BPC.
• Developed data architecture environment to extract data from BI into BPC fact tables.
• Responsible for creating and modifying applications by adding new members and updating dimension properties in applications.
• Responsible for adding, deleting or modifying applications and dimensions during design of application set.
• Created task profile, member access profile and assigning to teams and to users.
• Reviewed settings and locking mechanism of parameters pertinent to concurrency locking.
• Utilized script logic and validating dimension member formula logic in assigned application set.
• Set currency translation rules and packages, updating in business rules table and validating required script logic file.
• Assigned driver dimensions to an application and validating parameters within web administration.
• Developed BADI program for passing parameters to ABAP custom logic.
• Created EVDRE reports and input schedules using drag and drop functionality using standard EVDRE functions.
• Created comments and audits status on reports.
• Loaded transaction data of BI InfoProvider and flat file into BPC application.
• Loaded master data into a BPC dimension.
• Ran system reports for security and work status and acquire security settings for application set or current work processes.
• Reviewed data model and data flow.
• Performed significant changes to data model to optimize on standard functionality.
• Replaced custom program in SQL with dimension logic and script logic for efficient handling.
• Created validations in place to prevent user from entering invalid characteristic combinations such as (profit center, account, class and sub).
• Optimized layout in a more user friendly manner by utilizing 3 different layouts for each year in 3 different worksheets in same workbook.
• Performed population of CF accounts with help from a Script logic; this can be included in default logic if users want to see periodic and YTD values on a real time basis.
• All accounts planned in previous year for Profit Center can be seen in layout if a column is added in layout for previous year’s figures and hidden. Lite optimization and incremental optimization can be scheduled on a daily basis to improve and full optimization can be schedules on weekly basis during off peak hours.
• Created new documents on design and data flow

Environment: BPC NW 10.0 BW 7.3, BOBJ 4.0

Solution Architect

Confidential

Responsibilities:

• Involved in blueprinting consolidation, planning requirement and developed project plan.
• Designed, tested and supported business consolidation and planning requirements for global rollouts implementation.
• Configured application for financial consolidation and planning such as operational planning, balance sheet planning, sales planning and gross margin planning.
• Extracted and integrated ECC periodical BW data load for transaction data, master data and exchange rate maintenance.
• Migrated legacy financial consolidated data to new consolidations system.
• Maintained business rules for multicurrency translation, FXTRANS currency translation functionality maintenance with required dimensions, properties and applications.
• Maintained script logic for intercompany elimination, business rules and process chain maintenance.
• Created and maintained consolidation appset, application such as legal consolidation, rate, ownership and planning.
• Created planning, forecast category and loaded data through input schedules and flat files.
• Created consolidated report such as cash flow reports, consolidated income statement, consolidated balance sheet, trend reports, actual versus plan and forecast for result comparison.
• Managed and loaded transaction data to BPC using data transformation and conversion logic.
• Validated data loaded to BPC dimensions.
• Responsible for routine maintenance of dimension members (Master data), hierarchies and member’s properties for account, entity and product.
• Created BPC audit reports and comments.
• Utilized work status management to monitor job completion.
• Worked on BPC application architecture and performance enhancement using optimization.
• Prepared planning and consolidation design documents and process flows.
• Responsible for legal consolidation reports: income statement report (guarantor/non-guarantor), balance sheet report, audit report and intercompany matching/elimination, cash flow report, consolidated summary of operations and consolidated balance sheet by company code.
• Extensively worked on documentation, training users and supported BPC system.
• Configured Proof of Concept for BPC 7.5NW to test functionalities.
• Received log using SLG1.
• Debugged script logic and BADI with UJKT.
• Involved in troubleshooting BPC issue with ST22 and SM21.

Environment: BOBJ - BPC 7.5.

Financial Consolidation and Planning Consultant

Confidential

Responsibilities:

• Designed and configured application set, applications, dimensions, attributes and dimension members.
• Automated master data load and transaction data load from BW InfoCube to BPC cubes.
• Worked on security module with member access profiles, task profiles and user management.
• Input schedules with EVDre (Spread, Weight and Trend) and reports.
• Configured business process flows.
• Identified business rules and script logic coding with look ups.
• Created data manager packages for flat file load and retract plan data to BW InfoCube.
• Legal consolidations: currency translation, validations, intercompany elimination, calculation of cost of investments (equity method) and journal entries.

Environment: BPC 7.5 NW.

Solution Architect

Confidential

Responsibilities:

• Responsible for project plan and execution of migration to New GL.
• Configured New GL which includes creation of leading and non-leading ledgers with different Fiscal Year variants, document splitting, defining segments and their reporting.
• Assigned scenarios and customer fields to ledgers.
• Defined document types and number ranges for entry view and General Ledger views.
• Defined ledger groups.
• Configured real-time integration of CO-FI.
• Configured parallel valuation in Asset Accounting to post delta depreciation to ledgers as per IFRS and GAAP requirements.
• Performed configuration and testing for parallel consolidation in ECCS to roll up from non-leading ledger for US GAAP reporting in addition to real time update for IFRS.
• Configured accounting principles for foreign currency valuation in New GL.
• Performed configuration and testing of New GL migration cockpit.
• Performed correction of EURO conversion differences and other open item issues during migration.
• Migrated data using migration cockpit.
• Environment: BPC NW 10.0 BW 7.3, BOBJ 4.0 and ECC 6.
• Led business requirements gathering sessions to list BPR including dependencies on BW and source transaction systems.
• Defined the enterprise structures like Company code, controlling area, Profit Centers and business area.
• Configured SAP FI, AR, AP and GL processes.
• Implemented Project Systems with WBS, networks and projects.
• Worked on HR for time recording and Travel Management with ESS and MSS.
• Provided integrated solution for time, expenses and revenue recognition.

Project Manager/Solution Architect

Confidential

Responsibilities:

• Responsible for project plan, scope and testing plan and execution.
• Designed system landscape and coordinated with IT for hardware and software requirements.
• Created blueprint for implementation of Rapid Mart for CCA, GL and consolidation reporting.
• Connected rapid mart data sources using BO - data services.
• Utilized BODS to migrate data from SAP to Oracle database- DW system.
• Understood target table editor.
• Defined source and target metadata.
• Utilized built-in transforms and nested data
• Utilized case, merges, validation, data transfer and date generation transforms.
• Handled errors and auditing.
• Environment: BPC NW 10.0 BW 7.3 and BOBJ 4.0.

Project Manager/Solution Architect and Team Lead

Confidential

Responsibilities:

• Responsible for project plan, scope management, escalations and solution.
• Blueprinted to-be process for consolidation of financial data and provided a platform for financial planning.
• Designed source data basis and data stream for loading reported financial data for consolidation.
• Designed basis cube for data extraction from R/3 to basic cube and identified tables in R/3 for data extraction.
• Performed changes to special purpose ledger in line with reporting requirement.
• Created consolidation functions:
• Flexible upload (designing the file layout for upload).
• Load data stream- R/3 extract to BIW and into BCS cube.
• Data mapping between source data basis and data basis.
• Manual posting- Document types and related configuration.
• Validation for reported data and group data.
• Currency translation and rounding.
• Performed IU reconciliation of Receivables /Payables and revenue expenses (one sided and two sided).
• Configured setting for calculation of net income and current year retained earnings.
• Responsible for reclassification and balance carry forward.
• Performed integration testing and user training.
• Designed and configured P&L and balance sheet with drill down capabilities to document level.
• Environment: BPC NW 10.0 BW 7.3 and BOBJ 4.0.
• Configured allocation and distribution cycle.
• Converted legacy financial data to SAP.
• Configured reconciliation ledger.
• Wrote specifications for conversion programs.
• Performed unit test and integration test of above processes.
• Created mercury test scripts and executed test in Mercury.
• Created cut off procedures for production run Integration with HR, Payroll, Travel and MM modules.

Environment: BPC NW 10.0 BW 7.3 and BOBJ 4.0.

SAP FI/CO and BW Lead

Confidential

Responsibilities:

• Team lead for FI/CO, BW implementation and post implementation support with 7 consultants.
• Responsible for blueprint, configuration and delivery of financial account and apparel costing which includes Cost and Financial planning in SAP R/3; Profit Center Accounting is now integrated in financial accounting and configured data flow of actual and plan from Cost Center Accounting and financial to Profit Center structures.
• Responsible for transition from standard costing to moving average price, conducted workshops to gather user requirements and created prototype solution.
• Responsible for complete process from Procure-to-Pay which includes payment check, EDI and ACH payment runs used extensively BTE’s to trigger email as a confirmation for payments made.
• Provided reports for facilitate consolidation of accounts, which includes segment reporting and legal consolidation.
• Responsible for design and configuration of FI organizational structures which were critical success factors for projects.
• Responsible for account determination for SD pricing procedures, which include revenue determination, accrual for rebates and discounts and taxes.
• Created conditions records to accrue for rebates and discounts for customers based on off take and sales.
• Responsible for configuration of account determination for MM integration.
• Configured New GL with leading ledger and splitting of documents for segment reporting.
• Configured integrated data flow from CCA to FI thus avoiding reconciliation.
• Designed chargeback accounting system and also interfaced same for reporting using COGNOS; report displayed deduction by customers and aging of chargeback’s and accounting of charge backs with notes.
• Responsible for landscape recommendation of BW, design, configure and work with BW developer and team to deliver infrastructure for the supply chain reporting which includes open order profitability statement, gross margin on delivery and gross margin on billing documents.
• Activated business content specifically to AFS solution and custom developed environments for AFS solutions.
• Configured V3 updates for Logistics Cockpit Extractions.
• Created order acknowledgement reports and distribution center reports.
• Responsible for planning which included profitability planning, Cost Center, Profit Center and P&L and balance sheet planning.

Project Manager and Solution Architect

Confidential

Responsibilities:

• Assisted with designing, modeling and configuration of planning environment for sales and marketing plan.
• Allowed 75 CSE to plan independently and execute several planning functions and also to upload data from MS Excel.
• Created base planning area, multi planning areas and planning levels.
• Created complex planning layouts based in ALV grids and excel and web layouts with complex VB macros to adjust the screen, columns and work out calculations before screen was presented to planners.
• Utilized characteristic relationship in base planning areas to derive characteristics based on InfoObject attributes, user exits and reference data.
• Created standard functions to distribute top down with reference data.
• Created several fox formula functions to address sales plan selection logic to derive planed sales price from a forecast planning area and apply same in sales planning.
• Developed formula function to calculate weighted average for finished goods and apply the same to calculate cost of goods sold and arrive at planned gross margin.
• Created transactional cube and reference basic cubes and data source for basic cubes.
• Designed update rules for same.
• Developed complex queries including RRI to validate plan data and reconcile same with legacy data; project involved complex calculation using fox formulas and function exits with complex layout with validations.
• Created the test plan, test data to complete unit testing and integration testing and User Acceptance Testing.
• Created entire transport request and transported same to QA and production systems.
• Created several web layouts for manual planning and planning functions which will be executed in web layouts.
• Provided solution to complex allocation processes to arrive at sales volume and sales values and reconcile same with marketing plans.

SAP Integration manager SAP

Confidential

Responsibilities:

• Responsible for design and development of financial consolidation, management reporting, budgeting and planning environment for one of world's leading Reinsurance Company.
• Designed BW-Based Business Consolidation (SEM-BCS) in SEM-BCS 3.2 and BW 3.5.
• Led team in blueprinting, customizing functional design, data modeling, unit testing, integration testing and coordinating data migration for this integrated BCS project.
• Created data basis and assigning roles.
• Created consolidation area.
• Created master data - Consolidation groups, units, FS items, version and breakdown category.
• Designed the following consolidation functions:
• Data load from flat file to BCS cube.
• Manual posting- Document types and related configuration.
• Validation for reported data and group data.
• Currency translation and rounding.
• IU elimination and reconciliation.
• Reclassification and balance carry forward.
• Created integration test and User Acceptance Test plan.
• Responsible for creation of business scenarios and test scripts for integration testing.
• Resolved issues relating to process flow across modules.
• Assisted and developed conversion strategy for master data and transaction data.
• Led team of 7 consultants for creating functional specs for all reports from SAP R/3 and BW.
• As a BW lead, responsible for team of 3 onsite and 5 off shore consultants which includes design of InfoProviders for Reinsurance specific requirements and extractors.
• Created and monitored BW plan.
• Delivered functional specifications for BW reports and BW reports; reports include profit and loss account, balance sheet and cash flow statements and reinsurance specific reports which were to be submitted to various authorities in US and worldwide since Insurance is a controlled industry.
• Extracted data which included data from collection and distribution module of SAP R/3 Insurance solution, 8 special ledgers and Cost Center Accounting.
• Accessed BW data from legacy application using WEB query and converting same into an XML code.
• Utilized structure in BW query which involved complex calculations.
• Provided common and synchronized master data for using a data mart concept.
• Utilized pre-calculated queries to provide solution to complex calculations.
• Provided solution to changing business environment by reports which gives historical and current view of changed business environment for example realignment of certain lines of business to different Profit Centers.
• Utilized hierarchies both BW hierarchies and SAP R/3 hierarchies.
• Created related tasks and configuration of consolidation monitor.

SAP FI/CO Team lead

Confidential

Responsibilities:

• Implemented SAP finance process for Confidential which was a reimplementation of SAP R/3 which was originally fully customized; this implementation resulted in transition to standard SAP solution which in turn became a successful case study for SAP America.
• Developed an all in one solution for professional services industry.
• Configured and implemented the following modules:
• Project Systems with WBS and project structures.
• FI - AR, AP, GL, Asset Accounting, COPA, CCA and Internal orders.
• Integrated Travel Management with FI, PS and SD.
• Responsible for integration of PS and SD for revenue recognition and resource related billing.
• Provided solution for financial planning

Reporting Lead

Confidential

Responsibilities:

• Responsible for requirement study, InfoObjects activation, construction and modification of standard business content cubes and ODS relating to FI AP, GL, AA, CO- CCA, CO- IO, CO- Projects, MM cubes, related InfoObjects and query development.
• Responsible for data validations, documentation, knowledge transfer and post implementation support.
• Evaluated data sources and InfoSources and modified update rules to meet requirements.
• Modified standard cube to meet requirements of CO- CCA, CO- IO and CO-Projects resulted in considerable savings in terms of time and effort.
• In-depth functional knowledge with BW skills helped to meet all reporting requirements without any gap.
• Created several complex queries, RRI’s and using variables of all type and restricted and calculated key figures.
• Utilized hierarchies to meet reporting requirements.
• Provided specifications for DataSource enhancements.
• Enhanced FI data sources to include vendor number, check information and purchase order details.
• Proactively interacted with all super users to ascertain key inputs for queries and trained key users in query navigation and constructions.