SUMMARY

• 8+years of Experience in SAP ECC/BW/BPC/HANA in developing functional and Technical modules like Financial Planning, Reporting and consolidation.
• Experience on System Maintenance, Implementation and production support.
• Migrated and implemented SAP BPC from 7.0 to 7.5 to 10.0 to 10.1 BPC on HANA and to cloud on NW Versions.
• Worked on SSIS packages and configured to Data manager packages.
• Experience on migration of MS version to NW version.
• Proficient in creation of Environment, Models, Dimensions, Dimension Members, Hierarchies Loading Master data and Transaction Data into BPC Applications using Flat File or from BI Cubes.
• Worked on Transformation files, Conversion files, and Data uploading through Data Manager Packages.
• Worked extensively on Logic Scripts for Multi Currency Translations, Allocation and Business Calculations.
• Created Backup and restore, optimization techniques as a part of weekly maintenance activity.
• Created Users, Data Access Profiles, Task Profiles and Teams in Security
• Creating customized Input Schedules EVDRE Grid Reports with EvDRE formulas and Custom Templates, Drill down, Drill through and adding Macros.
• Created EPM Reports and Input forms in Admin, client interface and adhoc reports.
• Extracted data from Source system (SAP ECC) or Non SAP system using process chains and Data manager packages.
• Automating month end process using Business process flows to facilitate users to close the month end reporting.
• Drill through to BW info cube data from EPM add in for Data Reconciliation.
• Developed BADI’s for logic calculations and between Intra - App Applications data transfer.
• Developed Process Chains for retraction of data from BPC to BI using APD.
• Gather the business requirement and design the planning, forecast, budgeting requirements.
• Created Vale types in BW (Categories in BPC) for data loading on MTD, QTD and YTD data loading.
• Legal Consolidation reports: Income Statement Report, Balance Sheet report, Audit Report and Intercom any matching & elimination, Cash Flow report, Consolidated Summary of Operations and Consolidated Balance sheet by Company code etc.
• Transport activities between the Environments( DEV,QA and Production)
• Supported on all system, server and Configuration Related issues.
• Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying Extended Star Schema modelling principles in Data Design, and used expert knowledge of data warehousing concepts.
• Worked on BWA index activities on info cubes and multi providers for Query Performance
• Extensively worked on query development and formatting techniques in both BEx and Web Application Designer (WAD) of key BW reports and created Web Templates. Designed Info Sources, activated Pre/Post transformation rules, scripted extraction routines for master data, texts and hierarchies.
• Setup procedure for extracting R/3 data for Customers, Sales Order, Delivery in Sales and Distribution (SD) using LO-Cockpit. Created info Cubes, DSO, Transformations and DTP for Data Loading through Process chain from Source System.
• Ability to co-ordinate collaborative efforts, meet deadlines and manage time efficiently. Hard working with a high level of motivation.

TECHNICAL SKILLS

Environment: s SAP BI/BW 7.0, 7.3, 7.4 SAP BPC 7.0, 7.5, 10.0, 10.1, BEx 3.5, Office Analsys, ECC 6.0, 7.0 Netweaver&MS Versions.

Programming Languages: HTML, SQL and MDX

Database: Oracle, SQL Server, (OLTP & OLAP), HANA.

BPC: Environment, Dimensions, Security, Excel Reports, Dynamic Templates, Input Forms, data manager packages, Work Status, Transformation and Conversion files, BPC Functions, Custom menus, BPF s, EVDRE and EPM Reports and input forms,Badi's

Operating Systems: Windows Server 2003, 2008.

PROFESSIONAL EXPERIENCE

Confidential, OH

SAP BW/BPC Consultant

Environment: SAP BW 7.3, BPC 10.0 on NW Version.

Responsibilities:

• Created Environment,Models and Dimensions including maintenance of dimension members, Hierarchies and dimension properties.
• Developed Logic Scripts, maintained Badi’s and Configured Business Rules for Business calculations.
• Extracted data from Source system (SAP ECC) using process chains and Data manager packages.
• Loaded master data to dimensions through master data automation and Transaction data to models through BW info cube, flat file and from other non-SAP source systems.
• Created Transformation and Conversion files to import data into BPC from source system and Flat files.
• Created Input Forms and Reports using EPM Functions.
• Configured Consolidation of Intercompany Matching, Elimination and Balance carry forward rules
• Worked on BPC transport activities of the Scripts, Templates etc., across different servers.
• Created the user profiles and provide the access as per requirement.
• Created Reconciliation reports for data push from BPC to BI and from BI to BPC between Infocube,Bex report and from EPM Reports.
• Involved in preparing Documentation, users and educating the users to gain high-level knowledge about BPC system.

Confidential, Chicago, IL

SAP BW/BPC Lead Consultant

Environment: SAP BW 7.3, 7.4, BPC 10.0, 10.1 on HANA NW Versions

Responsibilities:

• Worked on development of Environment,Models and Dimensions including maintenance of dimension members and dimension properties.
• Loaded master data to dimensions through master data automation and Transaction data to models through BW infocube, flat file and from other non-SAP source systems.
• Created Transformation and Conversion files for data loads
• Developed Logic Scripts and BADI’s for Business calculations
• Migrated BPC 10.0 to 10.1 on HANA classic NW version.
• Trained End users on the latest versions and involved in UAT with users for Defect tracking.
• Experience on post GO-Live activities and implementation of SNotes.
• Created process chains and Data Manager Packages and automated the data load.
• Transported BPC object through interfaces (Dev, Quality, Production) through Transport connection in BW and maintained in sync.
• Created EPM Reports like P&L statements,cashflow,Balance sheet and input forms
• Created users and assigned to the users to Teams, Task profiles, Data access profiles.
• Extracted data from Source system (SAP ECC) using process chains and Data manager packages.
• Created Consolidation reports: Income Statement Report, Balance Sheet report, Audit Report and Intercom any matching & elimination, Cash Flow report, Consolidated Summary of Operations and Consolidated Balance sheet by Company code etc.
• Created Web Reports, Adhoc Reports and reconciliation between BPC and BW to check the data load.
• Worked on Intercompany reconciliation and made enhancements to financial statement.
• Performed reporting in, Month-End closing Quarter-End Closing and Year-End Closing.

Confidential, Lexington, KY

SAP BW/BPC Consultant (Tech Lead)

Environment: ECC 6.0, SAP BW 7.3, BPC 7.5, 10.0 on HANA Cloud NW Version

Responsibilities:

• Created EPM reports and Input forms.
• Created Backup and restore, optimization techniques as a part of weekly maintenance activity.
• Transported objects between systems and keeping them in sync
• Migrated 7.5 to 10.0 to BPC on HANA and post Go-live activities and support.
• Involved in UAT in QA system and trained end users for Defect tracking.
• Data Modelling between BW and BPC System.
• Created Process chains, APD Routine, info cubes, MultiProviders, DSO, DTP, Transformations and BW Queries.
• Extracted data from Source system (ECC) or from NON SAP system to BPC.
• Created Transformation and Conversion files to import data into BPC from source system.
• Created Vale types in BW (Categories in BPC) for data loading on MTD, QTD and YTD data loading.
• Created Reconciliation reports for data push from BPC to BI and from BI to BPC between Infocube,Bex report and from EPM Reports.
• Designed script logic and worked on business rule for Currency Conversions.
• Scheduling the BPC jobs and monitoring those from BW and BPC end to complete successfully.
• Created custom specific dynamic and static reports, schedulers and live reports and input forms.
• Involved in Client interactions and processed the needs as per the Business Requirement.

Confidential, NJ

SAP BW/BPC Consultant

Environment: ECC 6.0, SAP BW 7.3, BPC 7.5, 10.0 NW Versions

Responsibilities:

• Worked on development of Application Sets, Applications and Dimensions including maintenance of dimension members and dimension properties.
• Designed Sales application and, Capex applications.
• Worked on Conversion and Transformation files and Data manager for loading data into BPC.
• Created various Reporting (Finance, Sales) & Non-Reporting Applications (Rate) for planning purposes.
• Migrated 7.5 to 10.0 NW version, involved in UAT testing, USER, and all Tasks as per the Migration Plan.
• Legal Consolidation reports: Income Statement Report, Balance Sheet report, Audit Report and Intercom any matching & elimination, Cash Flow report, Consolidated Summary of Operations and Consolidated Balance sheet by Company code etc.
• Worked extensively with Script logics especially around allocation.
• Worked extensively on EVDRE functions.
• Granted access to specific applications using security setup.
• Customizing business rules and automates the consolidation of investment process.
• Working knowledge on Transports to move data from Development environment to Production environment.
• Worked extensively with Script logics especially around allocation.
• Worked on work status, security, and Data manager Packages.

Confidential

SAP BW/BPC Consultant

Environment: ECC 6.0, SAP BW 7.3, BPC 7.5 NW Version

Responsibilities:

• Application management such as creation, maintenance, addition of members.
• User Security such as team, task, member access profile creation, maintenance. Also restricting user access by activity, for reports only and specific to region.
• Script Logic to arrive at net profit and other calculations.
• Data management and loading of transaction data to BPC using the data transformation, conversion logic, Master Data loaded to a BPC Dimensions. Validation of data loaded.
• Work status management to monitor the job completion.
• Implementation of Business Process Flows, Custom Menus
• Exchange rate maintenance in rate application, Creation of input template for sales planning data, material planning, and stock holding inputs etc.
• Customizing business rules and automates the consolidation of investment process.
• Consolidated Summary of Operations and Consolidated Balance
• Creation of journal template and journal entries.

Confidential

SAP BW/BPC Consultant

Environment: ECC 6.0, SAP BW 7.3, BPC 7.0 NW&MS Version

Responsibilities:

• Created Applications, Dimensions.Members and Dimension properties
• Involved in reviewing and redefining the existing budget process, validating and mapping new data requirements to support the budget process.
• Created users,Teams,Task profiles and Member access profiles in Security
• Worked extensively on EVDRE functions in creations of Reports and Input Schedules.
• Granted access to specific applications using security setup and understood BPC audit.
• Developed Process Chains for retraction of data from BPC to BI using APD.
• Developed Script Logics for allocations, Currency conversions and for Business Calculations.
• Developed intercompany Eliminations, matching and Balance carry forward rules.
• Created Conversations and Transformations for Data Loads.
• Created Backup and Restore of complete application set
• Worked on SSIS packages and configured to Data manager packages.
• Involved on migration of MS version to NW version
• Worked on Troubleshoot and on performance issues.
• Created Adhoc reports to check the Reconciliation between BW and BPC for Data load.
• Created Queries (BEx) on BW/BPC Cubes to check the data load for MTD, QTD and YTD.
• Gather the business requirement and design the planning, forecast, budgeting requirements
• Experience on configuring work status and optimization.
• Support for all change requests / data issue / system issue.

Confidential

SAP BW Consultant

Environment: SAP BI/BW 7.0/BEx 3.5 NW Version

Responsibilities:

• Extensively involved in Production Support by loading Daily loads/Weekly loads into the BW system from different source systems.
• Created info Cubes, DSO, Transformations and DTP for Data Loading through Process chain from Source System.
• Involved in BWA index activities on Data loading and Query performance.
• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
• Created and worked on daily basis with LO-Cockpit, Generic Data Source, Info Source, Transfer Rules, Update Rules & Info Package.
• Designed Info Sources, activated Pre/Post transformation rules, scripted extraction routines for master data, texts and hierarchies.
• Setup procedure for extracting R/3 data for Customers, Sales Order, Delivery in Sales and Distribution (SD) using LO-Cockpit.
• Generated the Data Source from SAP R/3 using LO-Cockpit.
• Installed Business Content Info Cubes, Info Sources from BW Side.
• Activated Data Sources in SAP R/3 using T-code RSA5.
• Maintained Info Cube, Update Rules and Creation of Info Package and scheduling the data into the Data Targets.
• Involved in Info Cube maintenance i.e. Compression, Aggregates and Roll-up.
• Handled the tickets of priority 1, 2 and 3.
• Maintain list of all the activities for all the tickets until it is closed down.
• Actively and regularly involved in Load Monitoring of Daily, weekly and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Maintaining the queue - related to the system generated tickets and customer generated tickets.