Data Manager

EXPERIENCE SUMMARY

Total ** years of IT industry experience in SAP BPC, EPM, FI, HANA, S/4HANA and worked in sectors including Manufacturing, Media, Food & beverages.

Experience in communicating monthly results to the Business Segment management/leadership teams timely with business insight, trends, risks, opportunities, and key performance drivers. Develop management targets as needed in support of the management leadership.

Efficient in managing strong networks and relationships with other Finance teams, identifying strategic contacts within the Finance organization

Good knowledge in Financial and managerial accounting, IFRS, US GAAP Accounting standards analyzing financial statements.

Extensive experience in Business Objects suite (Data services, Crystal reports, Universe, Web Intelligence, Dashboard) for representing ECC, Oracle, SQL, Flat file data sources.

Extensive experience in cost center planning, Profit center planning, HCM planning, CAPEX planning, OPEX planning, Budgeting, top down planning and bottom up planning.

Extensive experience in designing financial applications, Non-financial applications legal consolidation applications, managerial consolidation, rate, and ownership applications.

Extensive experience in creating Data source, info objects,Info packages, PSA, Transformations, Data transfer process, Process chains, BADI’s and Info cubes for loading master data and transaction data from different sources into BPC application.

Efficient in designing business rules, Script logics, process chains, Business add in’s, Data Manager Packages for carry forward, Currency conversion, Account transformation,IC booking, IC Matching, US elimination, Consolidations, Allocations and validations.

Excellent working experience in Financial Reporting for Internal and External reporting requirements using SAP BPC, SAP BI and SAP Integrated Planning.

Expertise in design and configuration of BPC consolidations and planning environments for operating expenses and revenue planning and head count planning.

Functional and Technical expertise in BPC Consolidations and Cash Flows, Business Rules, Journals, Controls, and Work Status.

Worked on creating Reports and Forms using Analysis Office on Both Multi providers & Composite Providers. Excellent experience with consulting, designing, implementing and leading SAP HANA - based solutions.

Involved in business development initiatives – provided demos and discussed advantages on Hana and projected the new projects in HANA 1.0.

Education:

Bachelor of Science from Nagarjuna University

Masters (Master of science) from Nagarjuna University

TECHNICAL SKILLS

ERP

S/4 HANA, SAP-ECC (FI, CO, SD, MM, PM, CRM)

Business Intelligence

BW/4HANA, BI 7.4/7.3/7.0/BW3.5/BO XI R3

Business Planning & Consolidation

IBP, EPM 11.1/10.1/10.0/BPC7.5/7.0NW

OLAP Tools

Business Objects suite, SAP BW, Dashboard, Crystal Reports.

ETL Tools

HANA/BO Data Services, SAS

Language

ABAP/4, PL-SQL, MDX, C, C++

Data Base

Oracle 10.2/ 9i, SQL Server, IBM DB2 etc.

OS

Windows 8/ 7/Vista/XP, Windows 2003, UNIX.

NBC Universal–Universal City, CA Dec 2019 – Present

Sr SAP BPC Consultant

As a BPC Consultant handling the End to End BPC related activities and supporting complete planning cycle’s process & Reporting activities. Coordinating with different stake holders in requirement of BPC HANA related Testing and implementations.

Maintain the BPC applications from End to End process.

Created Transformation Files and Conversion files to load Transactional data and master data texts and hierarchies. Monitoring data loads to BI Cubes from BPC cubes. Monitoring Actual load from ECC.

Worked on BPC Admin team to configure and testing BPC security.Worked on BW Security team to configure security consistent with BPC Security, Users, Teams, Task Profiles and Member Access Profiles.

Worked on creating Data Manager Packages and Data Manager Package Links with Prompts.

Worked on configuring and testing Work Status and Controls.Worked on creating Journal Templates by BPC model.

Worked with user in UAT, loading master and transactional data, creating and posting Journals, creating and posting journals, testing Controls and Work status and running consolidation tasks.

Supporting revenue planning and expenses planning applications and troubleshooting day to day BPC technical issues and BPC performance issues working with SAP basis and DB teams.

Managing the BPC upgrade from 10.0 NW to10.1 HANA.

Worked with business users in requirement gathering, and designed, proto-typed, developed, tested and deployed SAP BPC solutions for corporate planning and corporate reporting groups.

Responsible for supporting corporate reporting group with their month/quarter/annual financial close.Configuring Business rules: Currency Conversion, Balance Carry forward, Intercompany eliminations, Inter Company Booking, Account Transformations.

Design reports and input schedules using EPM functions, and advanced script logic, worksheet logic and dimension logic. Monitoring the BPC Cubes optimizations. Data Cleansing and Maintenance of BPC cubes.

Working on POC for new technical and Functional features and enhancements’-note Implementations and closely working with SAP in Product related bug Fixes.

Role: Client facing & interaction, Technical solution, maintenance, Training, Resource hiring.

Environment: BPC 10.1 on HANA.

Team Size: 2.

Cepheid –Sunnyvale, CA Mar 2017 – Nov 2019

SAP BPC / HANA Lead Consultant

Responsibilities

Designing and implementing Models and dimensions.

Designing and implementing transaction and master data flow designs and process.

Configuring Business rules: Currency Conversion, Balance Carry forward, Intercompany eliminations, Inter Company Booking, Account Transformations. Created Transformation Files and Conversion files to load Transactional data and master data texts and hierarchies.

Worked on BPC Admin team to configure and testing BPC security.Worked on BW Security team to configure security consistent with BPC Security, Users, Teams, Task Profiles and Member Access Profiles.

Worked on creating Data Manager Packages and Data Manager Package Links with Prompts.

Worked on configuring and testing Work Status and Controls.Worked on creating Journal Templates by BPC model.

Worked with user in UAT, loading master and transactional data, creating and posting Journals, creating and posting journals, testing Controls and Work status and running consolidation tasks.

Worked on documentation and knowledge transfer to BPC Admin Team.

Extracted data from COPA for profitability analysis reporting in BW. Created custom Info Cube, ODS and reports.

Defined Transfer rules and Update rules for data in SAP-BW. Scheduling, Monitoring and transporting objects in Dev, QA, Prod Systems.

Experienced with design, development and deployment of various reports in BEx and Web Application Server.

Design reports and input schedules using EPM functions, and advanced script logic, worksheet logic and dimension logic.

Monitoring the BPC Cubes optimizations. Data Cleansing and Maintenance of BPC cubes.

Monitoring data loads to BI Cubes from BPC cubes. Monitoring Actual load from ECC.

Working on POC for new technical and Functional features and enhancements’-note Implementations and closely working with SAP in Product related bug Fixes.

Maintenance and Implementation of latest EPM Add in’s.

Role: Client facing & interaction, Technical solution, maintenance, Training, Resource hiring.

Environment: BPC 10.1 on HANA.

Team Size: 4.

Apple, Cupertino, CA Dec2015 – Feb 2017

BPC Solution Consultant

Responsibilities

End-to-End Maintenance, Migration/Upgrade of EPM applications SAP BPC 10.0 (NW) on HANA and SAP BPC 10.1 on HANA. Designing BO Dash boards for BPC P&L statements. And designing EPM Unwired applications for BPC 10 environment.

Single point of contact to client from the vendor side. Involved in training the users and business teams.

Engaged in POC of 10.1. Continuous improvement of the EPM applications like SAP BPC 10.0. Backup and Restoration of Transaction data, Master data and Meta data, Transport Management.

Designed and Implemented Account and Cost center Master data transformations.

BPC Planning Cycles maintenance and Incidents management.

Monitoring the BPC Cubes optimizations. Data Cleansing and Maintenance of BPC cubes.

Monitoring maintenance of Business rules like Currency Conversion, Balance Carry forward, Intercompany eliminations, Inter Company Booking, Account Transformations.

Monitoring and Troubleshooting Business Addin's (BADI's). Monitoring data loads to BI Cubes from BPC cubes. Monitoring the Actual load from ECC and People soft.

Working on POC for new technical and Functional features and enhancements’-note Implementations and closely working with SAP in Product related bug Fixes.

Maintenance and Implementation of latest EPM Addin's. Closely coordinating with the Security Team in designing and assigning the Data access profiles and Task Profiles.

Involved in Designing and implementing phase of the Depreciation model.

Responsible for copying/moving the actual to plan/Budget category by manually running Move/ copy package as per the maintenance activity.

Design reports and input schedules using EPM functions, and advanced script logic, worksheet logic and dimension logic.

Role: Client facing & interaction, Technical solution, maintenance, Training, Resource hiring.

Environment: BPC 10.0 on HANA, BPC 10.1 on HANA, BI 7.4

Team Size: 12.

Sysco, Houston, TX Jan15 – Nov15

BPC Lead Consultant

Responsibilities

End-to-End Maintenance, Migration/Upgrade of EPM applications SAP 7.5 to BPC 10.0, SAP BPC 10.0 (NW) on HANA and SAP BPC 10.1 on HANA. Designing BO Dash boards for BPC P&L statements. And designing EPM Unwired applications for BPC 10 environment.

Single point of contact to client from the vendor side. Involved in training the users and business teams.

Engaged in POC of 10.1. Continuous improvement of the EPM applications like SAP BPC 10.0. Backup and Restoration of Transaction data, Master data and Meta data, Transport Management.

Designed and Implemented Account and Cost center Master data transformations.

BPC Planning Cycles maintenance and Incidents management.

Monitoring the BPC Cubes optimizations. Data Cleansing and Maintenance of BPC cubes.

Monitoring maintenance of Business rules like Currency Conversion, Balance Carry forward, Intercompany eliminations, Inter Company Booking, Account Transformations.

Monitoring and Troubleshooting Business Addin's (BADI's). Monitoring data loads to BI Cubes from BPC cubes. Monitoring the Actual load from ECC and People soft.

Working on POC for new technical and Functional features and enhancements’-note Implementations and closely working with SAP in Product related bug Fixes.

Maintenance and Implementation of latest EPM Addin's. Closely coordinating with the Security Team in designing and assigning the Data access profiles and Task Profiles.

Involved in Designing and implementing phase of the Depreciation model.

Responsible for copying/moving the actual to plan/Budget category by manually running Move/ copy package as per the maintenance activity.

Design reports and input schedules using EPM functions, and advanced script logic, worksheet logic and dimension logic.

Role: Client facing & interaction, Technical solution, maintenance, Training, Resource hiring.

Environment: BPC 10.0 on HANA, BPC 10.1 on HANA, BI 7.4

Team Size: 12.

Boeing, Seattle, WA Jan14 – Nov14

Sr BPC Lead Consultant

Responsibilities

End-to-End Maintenance, Migration/Upgrade of EPM applications SAP 7.5 to BPC 10.0, SAP BPC 10.0 (NW) on HANA and SAP BPC 10.1 on HANA. Designing BO Dash boards for BPC P&L statements. And designing EPM Unwired applications for BPC 10 environment.

Single point of contact to client from the vendor side. Involved in training the users and business teams. Engaged in POC of 10.1. Continuous improvement of the EPM applications like SAP BPC 10.0. Backup and Restoration of Transaction data, Master data and Meta data, Transport Management.

Designed and Implemented Account and Cost center Master data transformations.

BPC Planning Cycles maintenance and Incidents management.

Monitoring the BPC Cubes optimizations. Data Cleansing and Maintenance of BPC cubes.

Monitoring maintenance of Business rules like Currency Conversion, Balance Carry forward, Intercompany eliminations, Inter Company Booking, Account Transformations.

Monitoring and Troubleshooting Business Addin's (BADI's). Monitoring data loads to BI Cubes from BPC cubes. Monitoring the Actual load from ECC and People soft.

Working on POC for new technical and Functional features and enhancements’-note Implementations and closely working with SAP in Product related bug Fixes.

Maintenance and Implementation of latest EPM Addin's. Closely coordinating with the Security Team in designing and assigning the Data access profiles and Task Profiles.

Involved in Designing and implementing phase of the Depreciation model.

Responsible for copying/moving the actual to plan/Budget category by manually running Move/ copy package as per the maintenance activity.

Design reports and input schedules using EPM functions, and advanced script logic, worksheet logic and dimension logic.

Role: Client facing & interaction, Technical solution, maintenance, Training, Resource hiring.

Environment: BPC 10.0 on HANA, BPC 10.1 on HANA, BI 7.4

Team Size: 12.

Nike, Portland, OR Mar13 – Nov13

BPC Lead Consultant

Responsibilities

Involved in the requirements gathering, Designing and implementing phase of the financial models, Ownership models, rate models and consolidation models.

Implemented data audit and activity audit settings and extracting reports periodically.

Design and Implemented Business process flow templates, activities and Instances.

Designed and configured users, teams, task profiles and data access profiles. Adding new users, installing the application, assigning the team access, providing required Read and write access to certain dimension members as per the maintenance task.

Automated and schedule the DM packages for getting master data and transaction data actuals from the ECC on periodic basis as a maintenance activity.

Designed and implemented the script logic, Business rules, Data manager packages for currency conversion, Automatic adjustments, Intercompany booking, Intercompany matching, Carry forward, US eliminations and created data manager packages.

Created data files, transformation files, conversion files for the DM packages.

Designed and implemented the following EV functions (EVDRE, EVBET, EVMBR, EVCVW, EVPRO, EVDES, EVAPP, EVGET, EVRNG, EVCOM, EVDIM, and EVHOT).

Reports & Input forms: Data validation report analysis, Divisional summary analysis, Detailed P&L by quarter, Top level CCA variance, Account detail CCA variance, Station revenue, Station OCF, Head count reporting, Revenue details by profit center, Detailed cost center and account, Expenses by CCA and company code, Detailed expense estimate, Digital virtual revenue.

Role: Client facing & interaction, Technical solution, Bugfixes.

Environment: BPC7.5 NW, BI 7.3, ECC6

Team Size : 5

Pacific Gas & Electric,San Francisco, CA May2010- Jan 2013

SAP FICO Functional Consultant

Responsibilities

Creation of G/L Masters and Maintaining Field Status Variant.

Defined Fiscal year variant, Posting periods, Tolerance groups, Document types and number ranges

Creation of Customer/Vendor Accounts Groups, Number Ranges, and Customer/ Vendor Masters Creation.

Configuration of Chart of Depreciation, Depreciation Areas, and Depreciation Keys

Creation of Asset Classes, Asset Number Ranges, Account Determination, and related settings

Created Low Valued Assets classes.

Maintain the Versions for actual and planned postings

Creation of Cost Centers and Definition of Cost Centre Hierarchy

Creation of Primary and Secondary Cost Elements with appropriate Cost Element Category.

Responsible for FI-GL / CO (CCA, CEA, PCA, PC and CO-PA) modules.

Identified and documented business process requirements and prepared blueprint.

Involved in configuration and customization as per functional requirements.

Configured global settings, organization structure, company codes and functional areas.

Defined Chart of Accounts, Account Group & GL accounts, Fiscal Year Variants, Posting Period Variants, Field Status Variants and Groups, Screen Variants for Document entry, Doc Types and Number Ranges.

Worked extensively in New GL, Accounts Payable and Accounts Receivable configuration. Involved in FI / MM, FI / SD Integrations.

Involved in Vendor and Customer set-up for Intra &Intercompany processes.

Created Primary and Secondary Cost Elements, Cost Center hierarchy, CC Groups and Cost Centers.

Responsible for assessments, distributions, Statistical Key Figures and Activity Types.

Extensively involved in PCA basic settings, created master data, profit center groups, dummy profit centers, profit center hierarchy.

Involved in set-up Special Purpose Ledger, mapped field movements as per requirements.

Designed and developed custom reports in CCA, PCA and CO-PA for management reporting.

Actively participated in FI and PCA Reconciliations and Month-end process.

Developed and refined business process documentation to leverage standard SAP and custom

Footprint

Role: Coordinated multiple teams to gather functional specific requirements, solution design and implementation.

Environment: SAP ECC5, ECC6, MM, SD, APO, BW 7.0

Team Size: 6

Contact this candidate