Data Project

Swetha Merugu Email: ***********@*****.***

Ph.: 703-***-****

Summary

SAP Consultant over 10 years Professional experience with Business Users Interaction, Requirement Gatherings, Configurations, Development, Testing and End User Training with SAP ERP, SAP BW/BI/BO, SAP HANA, Accounting, Technical and Production Support.

SAP Finance and Controlling with two full life-cycle Implementations of SAP FI/CO Module in SAP Project as per ASAP methodology

Currently working as SAP BI/ HANA/BPC Architect & Practice Lead.

Recommended best practices and ensured Business Partners are aware of various solution options for financial systems automation.

Experience developing short & long term roadmaps closely working with business partners and understanding their future requirements.

Experience running technical governance meetings for developing implementation plans and manage project delivery.

Worked on several implementations and has solid hands-on experience working in SAP BPC/ BW and HANA.

Implemented new Security Model

Implementation experience in General Ledger (GL), Account Receivable (AR), Account Payable (AP), Asset Accounting (AA), Special purpose Ledger, Controlling Areas, Cost Center Accounting (CCA), and Profit Center Accounting (PCA).

Experience covers all stages of SAP BI/BPC,FI/CO activities from Fit Gap analysis, Develop

Creation of business blueprints, Configuration, Realization, Unit Testing, Integration Testing, Learning training, Go Live support, Control Start, Support production.

Experienced in Enhancements, Testing & Production Support/ user issues, super-users and End user training and documentation.

Provided end user support for all issues pertaining to Finance and Controlling modules & Worked closely with Business Leaders to consult and influence direction of business process.

User Training on the processes and assistance in developing End User Document.

Technical Skill Set

Expert in HANA 1.0: Replicating/Security/Reporting

Expert in EPM10: Configuration/Logic/Integration/Reporting

Expert in EPM10: Migration and Performance.

Expert in SAP BPC 7.0/7.5/10.0: Configuration/Logic/Reporting and Security.

Expert in BPC Migration and Upgrades

Expert in BI/BW/BO: Modeling/Design/Configuration/Reporting.

Expert in BI ABAP: User Exits/Routines/Enhancements/BADIs.

Experience/Project work:

Client: CF Industries, Deerfield, IL Sep 2015 – Aug 2016

Role: EPM/BPC Report Writer

Achievements:

Configure Environments, Models, Dimensions, Business Rules and script logic

Implemented Budget and Forecasting Process for Financial Planning,CAPEX Planning and HR Planning

Responsible for Configuration, development and Support for all Planning applications

Review Financial Reporting, Input Schedules and Self Service Query requirements.

Developed various Script Logic and Member formula Calculations required for generating EPM Reports

Developed various Input Forms and Reports using EPM Functions and VBA Macros.

Work with business owners to understand requirements and design financial reports to be supported by the SAP BPC System using the EPM Add-in create and maintain financial reports in BPC using the EPM Excel Add-in

Perform unit testing of EPM Reports/Templates Support the creation/maintenance of data input templates using the EPM Add-in

Responsible for immediate BPC production issues Ability to work with a diverse and integrated team consisting of application developers, technical business users and business analysts Required

Configured Work Status for Locking the data for required periods

Created Drill through so the Reports and Input forms can drill down to a document number level details.

Create unit testing scenarios and resolve/trouble shoot issues identified during testing.

Develop reports:

Consolidated Balance Sheet,

Income Statement reports (monthly and quarterly),

Cash flow report,

Gross Profit report,

Intercompany report,

SG&A reports (by Department, by Product Line),

COGS details report,

CAPEX reports

Client: Woodward INC, Denver CO May 2014 – Aug 2015

Role: EPM/BPC and HANA Architect

Achievements:

Responsible for BPC 7.5 implementation and Subsequent migration to EPM10 and EPM10 on HANA

Gathered and Review Business Requirements.

Review Financial Reporting, Input Schedules and Self Service Query requirements.

Create functional specification documents.

Co-ordinate Design & Build Workshops.

Develop and oversee the system build and design.

Create Dimensions and Models for Budget & Forecast.

In memory planning in BW on HANA--Planning Application Kit (PAK)

Create and Maintain BPC Master Data, create Reports and Templates.

Manage Project & ensure deliverables are met as per plan.

Set up project review meetings with Business and IT teams.

Recommend SAP Financial and BI solutions as per the client future requirements.

Ensure SAP Best practices are followed.

Implemented Cost center Planning/ Capital and Treasury Planning

Implemented Tax Planning and integration to Corp TAX

Implemented Headcount planning based on HCM Module

Real Time ECC integration

Successfully met all project objectives of Strategic planning

Successfully migrated existing model into EPM10: Models and Business

Implemented 23 new Infoproviders, 9 multi-providers, and 4 virtual cubes to support SD, MM, PP, FI, AR, and AP reporting requirements.

SAP HANA optimized planning (PAK)

Utilized new BI 7.3 transformations and DTPs for all new developments.

Developed numerous custom datasources using database views and custom function modules.

Utilized the Analysis Process Designer (APD) to populate summary cubes using complex queries on other cubes.

Developed 34 process chains to automate the initialization and delta updating of

Created over 50 BEX /BO queries and assigned them to roles by department.

Client: ConocoPhillips, Bartlesville, OK Nov 2013 – April 2014

Role: SAP BPC Consultant

Achievements:

Understand Business Pain Points with the existing BPC System.

Propose Alternate Design Solutions.

Debug/ Rewrite Script Logic for Budgeting Process.

Debug Budgeting/HR templates

Setup new Process Chains and Data Manager Packages.

Support Current Consolidations System.

Document the Consolidations process and BPC workflows.

Participate in Month End close maintenance activities.

Verify Business Rules and Script Logic for Inter Company Eliminations and Consolidations.

Planning Model.

• Create Input templates for Capex Planning model to input various projects

• Develop Scripts to calculate Gross Margins, Cost of Goods Sold.

• Develop Data manager packages to archive forecast and run developed Scripts

• Technical documentations and Process flows for all processes involved.

Recommend SAP Financial and BI solutions as per the client future requirements.

Manage Project & ensure deliverables are met as per plan.

Set up project review meetings with Business and IT teams.

Blueprint support

Client: Pelican Products, Torrance, CA Jan 2012 – Sep 2013

Role: SAP BPC Consultant

Achievements:

SAP BPC Netweaver 10.0 Version

Configure Transformation files and data loading packages

Configure EPM reports on Planning

Developed script logic files using ABAP, BADI, MDX and SQL.

Configure currency translations – Rate of exchange upload, Rate Types and dimensions

Gather and Review Business Requirements.

Review Financial Reporting, Input Schedules and Self Service Query requirements.

Create functional specification documents.

Co-ordinate Design & Build Workshops.

Create Dimensions and Models for Budget & Forecast.

Create and Maintain BPC Master Data.

Create Reports and Templates.

Manage Project & ensure deliverables are met as per plan.

Set up project review meetings with Business and IT teams.

Recommend SAP Financial and BI solutions as per the client future requirements.

Implemented Tax Planning and integration to Corp TAX

Implemented Headcount planning based on HCM Module

Successfully met all project objectives of Strategic planning

Successfully migrated existing model into EPM10: Models and Business

Client: Gtech Corporation, Providence, RI Sep 2010 – Nov 2011

Role: SAP BPC Consultant.

Achievements:

Configure Environments, Models, Dimensions, Business Rules and script logic

Review Financial Reporting, Input Schedules and Self Service Query requirements.

Create functional specification documents.

Configure currency translations – Rate of exchange upload, Rate Types and dimensions

Interco Elimination journal entries in consolidation system and investment in subsidiaries

Consolidations:

Intercompany eliminations: AR AP, bond transfers, reinsurance elimination

Planning:

Design and develop input schedules, reports and custom interfaces, budget actual and forecast models

Create EPM Reports in BPC-Excel

Built consolidation model / Ownership and Rate Model

Configured Intercompany and Currency Translations

Configured COI ( Consolidation of investments)

Configured Ownership model

Developed logic for Cash flow and Treasury Planning

Developed many reports and input schedules

Design Proof of Concept documents

Functional Design of legacy systems to BPC interfaces

Testing of Planning reports, input schedules and data loads from BW cube

Client: Pacific Gas & Electric, San Francisco, CA Aug 2009 to Jul 2010

Role: SAP BPC/BW Consultant

Achievements:

Developed Data Model for BPC Account Based model from BI KPI's.

Created Application Set from APPSHELL. Developed Applications, Dimensions, Properties and Hierarchies

Configured Application Set and Application parameters for Journals and work status settings.

Involved in data extraction and conversion between BPC and BW systems.

Worked on Setting up Security features with Task profiles and Member Access Profiles.

Integrated SAP BPC Data Manager Packages with SAP BI process chains.

Developed script logic files using ABAP, BADI, MDX and SQL.

Perform Planning using internal data base routines (PAK)

Created EVDRE Input Schedules, Reports and Journals, Script Logic and Business rules.

Worksheet formulas, and Dimension Formulas for G/L Accounts, P & L, AR, AP, Income Statements which involved Budgeting and Forecasting.

Worked on month end closing consolidation Reports.

Performed reporting and data collection using Distributor & Collector functionality.

Extract data from SAP and non - SAP systems into BPC/BI/BW with ETL tools

BI mapping Master Data to Source Data, create Transformations

Client: Home Meridian, Phoenix, AZ Dec 2008 to July 2009

Role: SAP BW Consultant

Achievements:

Requirement gathering, design and analysis – Worked with end users to identify and advise on existing info structures updated by business events in R/3. Identify potential uses and conduct functionality gap-analysis. Identify potential solutions, implement enhancements to existing functionality.

Responsible for business data modeling, data mapping, and gap analysis.

Designed and developed custom DTPs, Transformations, and Cubes, DSO, Aggregates, queries and workbooks.

Created Hierarchies on 0ACCOUNT, 0GL_ACCOUNT and 0PROFIT_CTR for financial reports.

Created and automated monthly P & L reconciliation of budget, actuals and variances

Created P & L Reports, Balance Sheet, Cash Flow Statement, FRP and Vision Reports.

Distributed P & L Workbooks to field managers across the global using Broadcasting.

Created Broadcasting Process Chain and created job to send emails automatically using SCOT. Distributed monthly financial reports using broadcasting.

Created Generic Extractor using function module.

Created WebI report directly on Bex queries without any universe layer in BOBJ 4.0.

Prepare and deliver training materials station managers, technical project, business process owners and other end-users.

Designed Security profiles for functional users, developers, and budget users. Created Authorization based on profit center hierarchy nodes.

Client: Panasonic, Secaucus, NJ Jun 2008 to Nov 2008

Role: SAP BW Developer

Achievements:

Involved in creating Info Objects, Infosources, and Infocubes, Multi Providers, Infoset and all other infrastructure changes.

Created BI Dashboard for Procurement Top Sheet module for higher management to keep track of all the materials status in the warehouse.

Using Web application Designer, designed many web reports, templates, Graphs, Uploading logo, Icons, Style sheets, creating tabs etc.

Actively involved in creating default web template

Using BEx Query Designer, created many queries using pre queries, filters, variables, calculated Keyfigures/Restricted Keyfigures, Exceptions, and Conditions etc.

Created Master Data and transactional Infosources for uploading attributes and texts.

As part of upgrade team, involved in migrating many BW 3.X queries to BI7.X

Worked closely with SAP to resolve upgrade issues.

Created multiple Generic Data Extractors to create Data Sources for transaction and master data.

Client: Orient Paper Mills March 2007 – May 2008

SAP BW Consultant

Role: SAP BW Developer

Achievements:

Participated in user meetings to discuss project concept, design, and schedule. Worked with different users to gather business requirements and transformed them into a data model using Extended Star Schema model.

Extensively involved in the enhancement of BCT Data Sources and development of Generic Data sources.

Customizing Standard InfoSources 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_13_VDITM, 0FI_AP_4 from the Business Content for Sales order and deliveries Transactional data.

Created Info-Packages group to schedule Info-Packages to load master data.

Wrote ABAP/4 routines to enhance business content Data Sources to meet the business requirements.

Query development using the BEx Analyzer, BEx Browser and WAD functionality of BW. Developed flexible queries using filters, conditions, navigational attributes, calculated key figures and restricted key figures to facilitate data analysis in a drilldown or summarized way to give detailed levels of information per business application and user requirements.

Created drill through queries from summarized Info Cube to detail ODS data.

Contact this candidate