Sap Bpc Consultant Resume
Grand Rapids, MI
SUMMARY
- Total 7+ 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.
- 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.
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.
PROFESSIONAL EXPERIENCE
Confidential - Grand Rapids, MI
SAP BPC Consultant
Responsibilities:
- 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.
Confidential - Canton, MI
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.
Confidential, Jackson MI
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.
Environment: BPC 10.0 on HANA, BPC 10.1 on HANA, BI 7.4
Confidential, Houston, TX
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.
Environment: BPC 10.0 on HANA, BPC 10.1 on HANA, BI 7.4
Confidential, Jersey City, NJ
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.
Environment: BPC 10.0 on HANA, BPC 10.1 on HANA, BI 7.4
Confidential, Jersey City, NJ
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.
Environment: BPC7.5 NW, BI 7.3, ECC6
Confidential
SAP BPC 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.
Environment: BPC7.5 NW, BI 7.3, ECC6