We provide IT Staff Augmentation Services!

Sap Bpc Sap Bi 7.5, Sap Analyst Resume

2.00/5 (Submit Your Rating)

TexaS

SUMMARY:

  • Expertise as a Senior Technical Lead consultant with around 12 years of experience in IT projects, Developing and deploying SAP enterprise application solutions and Implementing latest solutions in SAP Business Analytics.
  • I have worked on 14 projects with 8 end to end global SAP implementations experience with proven experience in Leading teams and providing technical solutions to customers out of which 75% of implementation experience comes from Manufacturing, Finance, Retail industries, Insurance and SAP Internal IT and HR.
  • Worked on multiple Tailored POC’s in different SAP Technologies for customers spanning across Retail industries, HR and finance
  • Strong experience in Data Warehousing, Business Intelligence Concepts in Implementations, migration activities & upgrade projects.
  • Responsible for Development and delivery of SAP BI Solutions in SAP HANA, SAP BW SAP BPC and BO. Developing Architecture and Design flow, writing technical, functional Documents.
  • Responsible for completion of all deliverables resulting high quality and requirements gathering, along with configuration, and overall implementation of the solution.
  • Recommend solutions to leadership, project teams, and other stakeholders adapting style to both technical and non - technical audiences. Collaborate with other architects to ensure continuity of solutions.
  • Communicate effectively with Customers, Business Users, Team Members, Senior management, all other IT Teams and functions to achieve and align with the project.
  • Extensive Experience on SAP BI 7.0, SAP 7.3, SAP BI 7.4, SAP 7.5, Embedded BPC, SAP HANA, Side Car HANA, S/4 HANA, Embedded BW, HANA LIVE, HANA Studio to develop and Implementation the project plans and determine how to leverage technology to create solutions that satisfy the business requirements.

SKILL:

BW Modeling: Composite providers, Advanced DSO’s, Embedded BW in 7.5, ABAP transport workbench, RKF’s, CKF’s, Cubes, DSO’s, Multi providers, Transformations, DTP, Master Data, Process chains, Hierarchies, APD.

BPC Objects: Create Aggregates, Planning Functions, Planning Sequences Filters and Variables. SAP Business Explorer, SAP Query Designer.

SAP HANA Modeling: Calculation Views, Analytical Views, Attribute Views and Scripted Views. SLT & SDA connectivity Joins, Union, Input parameters. Create Users, Roles, Analytical privileges, Grant Roles.

SAP HANA: Native HANA, BW on HANA, HANA Side Car scenario, HANA XS Engine SAP UI5, OData Services.

SAP HANA Performance Tuning Techniques: Star Join concepts and Snapshot on the Dataset Implementing filter conditions materializing the views. SLT Replication.

Reporting Tools: Query Designer, BEx Analyzer, WAD web application designer, Business objects Analysis for Office, Explorer, LUMIRA, Design Studio, SBEE (Smart Business Executive Edition), WebI, Tableau.UI5 and SAP HANA XS Engine.

PROFESSIONAL EXPERIENCE:

Confidential, Texas

SAP BPC SAP BI 7.5, SAP Analyst

Responsibilities:

  • To Engage with customer and involve in Design Discussions to Integrate Work Day to SAP solution
  • Worked on in the initial Blue Printing phase and engaged in workshops with the business to understand the ’AS- IS’ and ‘TO- BE’ requirements and developed the GAP analysis and estimates.
  • Designed and published functional scope and Technical Design Documents.
  • Responsible to Deliver and lead Offshore team in the project
  • Responsible to connect with cross functional teams to plan the delivery activities and communicate to team. worked with HR and Finance team to Smoothly Integrate the Functionality between Work day and SAP BPC Data Flows.
  • Played a key role in the Design, Customization, Development of the solution.
  • Connected with Informatica team to push down the transformation logic and account lookup logic between Work Day &SAP
  • Involved and helped with the mapping exercise with Chart of Accounts for Confidential Between work day accounts and Confidential SAP BPC Accounts
  • Optimized Data elements as a part of design optimization and provided optimized and Improved Solution.
  • Constant Communication with Client on the Development Status Risks and Dependencies.
  • Actively worked in UAT Sessions to Test and Explain the Scope and the functionality of the solution.
  • Majorly GL,HCM, and Project Systems are the Key solutions of this Project
  • Delivered solution from Ideation to Execution Successfully with high quality and at most user satisfaction.

Confidential, Houston, Texas

SAP BPC SAP BI 7.5, SAP Analyst

Responsibilities:

  • Analyzing the requirements and design viable data model solutions.
  • Participate in business and project meetings and project blue-printing.
  • Develop software modules such as Data Sources for SAP.
  • Build data models in SAP BW platform using DSOs, Info Cubes and Multi Providers.
  • Develop Reports as per Customer Specifications using Business Explorer.
  • Develop test Scripts. Conduct unit, integration, regression and functional testing.
  • Go live support. Documentation for the developed solutions.
  • Update Project Management on the project status by tracking deliverables.
  • Track issues and risks, communicate status and escalate concerns to project management.

Confidential

Sr. SAP HANA and Tableau Consultant

Technologies: SAP BW 7.4, SAP HANA, SAP Analysis for Office,SAP Side Car HANA, SAP SLT, Tableau 10.1.3

Responsibilities:

  • To Engage with customer and Develop the HANA Models aligning to the BI Reporting solution.
  • Responsible as an SME (Subject matter Expert) to Develop and Deliver HANA Models and Tableau Dashboards.
  • Responsible to connect with other business teams to understand the data flow.
  • Responsible to and design an develop architecture for Tableau dashboarding solution.
  • Created SAP SLT Connectivity to access Data from other Data sources.
  • Configured SAP SDA to access tables from other systems in SAP HANA.
  • Created HANA Views by importing BW objects and developed calculation views in HANA studio
  • Developed analytical privileges on SAP HANA views for data security.
  • Interacted with Business users on the Functionality Tableau Dashboards and UI of the Tableau Dashboards.
  • Arrived at different insights with business data on which added more flexibility to users
  • Worked on reconciliation of data and validation of KPI s Incorporating SAP Bex Query logic in SAP HANA worked with Finance Tables and Business Planning Tables and the sales information.
  • Played a key role in the Design, Customization, Development of the solution.
  • Delivered effective dashboard designs and impressive Dashboard performance using SAP HANA and Tableau.

Confidential

Sr. SAP HANA Lead

Technologies: SAP BW 7.5, S/4 HANA, HANA LIVE, Analysis for Office, SDA, Embedded BW, BPC with HANA.

Responsibilities:

  • To Engage with customer and Develop the unified One SAP solution in the BI Space
  • Responsible as an SME (Subject matter Expert) to Deliver and lead a team of 4 in the project
  • Responsible to connect with cross functional teams to plan the delivery activities and communicate to team.
  • Installation of BI content in S/4 HANA and Executing HANA Live views across all process areas
  • Designed and developed Process Design Documents (PDD) in the areas of OTC. worked with Finance Tables and Business Planning Tables ACDOCA
  • Played a key role in the Design, Customization, Development of the solution.
  • Involved and helped with the mapping exercise with BW, BI Content and HANA optimized Data elements in S/4 HANA to analyze the KPIs in order to recommend new solutions.
  • Created Embedded BW Objects for real-time reporting solution.
  • Created calculation views on S/4 HANA Tables.and CDS Views
  • Implemented and Developed AR, shelf life, and Broker Determination Reports.
  • Optimization by defining Business rules and other specifications to meet business requirements.
  • Worked on Data Conversion efforts specific to shelf life from both the systems east/west and central.
  • Worked on in the initial Blue Printing phase and engaged in workshops with the business to understand the ’AS- IS’ and ‘TO- BE’ requirements and developed the GAP analysis and estimates.
  • Delivering projects from ideation to implementation and support.
  • User acceptance testing UAT participation and led it to closure

Confidential, San Jose, CA

Sr. SAP BW on HANA Architect

Technologies: SAP BW/HANA, R, Predictive analytics

Responsibilities:

  • Responsible to deliver the solution to Confidential and lead the development team
  • Responsible as a single point of contact and lead for delivery activities.
  • Developed and created technical architecture and worked on technical objects to deliver.
  • Primary responsibility was to understand SLT Configuration and Technical Landscape.
  • Followed the Technical Guide provided by SAP to achieve Smooth Migration to SAP SDI
  • Closely worked with SAP Security and lead my development/Admin Colleagues to create and Setup Respective Roles, Profiles and users.
  • Created Schemas as a part of the migration Process.
  • Created the blueprint of the solution
  • Listed and maintained activities to process the migration
  • Connected the views to the new Data source based on SAP SDI.
  • Created Flow graphs on HANA SDQ. performed UAT User Acceptance Test and Regression tests on the solution

Confidential, Newtown Square, PA

SAP HANA and SAP BI Lead

Technologies SAP BW on HANA, HANA Side Car, Native HANA, HANA Studio 95 and SAP CRM, SBEE (Smart Business Executive Edition.

Responsibilities:

  • Leading and Aligning with the functional teams to understand the requirements
  • Lead a team of 5 as SME for this project along with technical delivery activities
  • Data Provisioning from ECC via SLT for Developing CRM Data
  • Cleaning up data and maintaining Data consistency
  • Filtering based on defined criteria, remove or add new calculated columns or changing column data type In SLT.
  • Initial loading of data and Following up with other SLT activities
  • Monitoring the SLT Replication Status in Replication Monitor
  • Validating SLT Replicated Data with the Source Systems.
  • Maintaining Settings in SLT for individual tables as per requirement
  • Followed best practices on Data Provisioning with SLT.
  • Created HANA artifacts such as Attribute views, Analytic views and Calculation views as per the Business requirements/KPI defined.
  • Objective is to reconcile the business master data and the created output from the HANA models and connecting to Tableau Desktop
  • Created Analytical Privileges and procedures to achieve security concept for the users
  • Created roles for the users and enabled them to the respective views
  • Transport of HANA artifacts across landscape using Delivery Units.
  • Followed HANA best practices.
  • Unit Test & Integration test of the deliverables & hand it over for UAT
  • Bug fixing and post go live Support.
  • Actively participated on UAT Activities
  • Developed Dashboards based on HANA views
  • Worked on Odata services for UI5 Development for HANA XS pulling data from HANA views
  • Developed UI5 screens for mobile dashboards with HANA XS worked on SAP HANA XS connectivity for UI5 solution

Confidential, Newtown Square PA

SAP HANA and SAP BI Lead

Technologies SAP BW on HANA, HANA Side Car, Native HANA,HANA Live, HANA Studio 95 and SAP CRM, SBEE (Smart Business Executive Edition.

Responsibilities:

  • Responsible as an SME (Subject matter Expert) to Deliver and lead a team of 4 in the project
  • Responsible to connect with cross functional teams to plan the delivery activities and communicate to team.
  • Created HANA artifacts such as Attribute views, Analytic views and Calculation views as per the Business requirements/KPI defined.
  • Objective is to replicate all the BEX Query's KPI logic into HANA layer importing the BW info Providers.
  • Transport of HANA artifacts across landscape using Delivery Units.
  • Built various stories using SAP’s internal reporting tool SBEE (Smart Business Executive Edition) consuming.
  • Followed HANA best practices.
  • Unit Test & Integration test of the deliverables & hand it over to UAT.
  • Bug fixing UAT and post go live Support.
  • Developed UI5 screens for mobile dashboards with HANA XS worked on SAP HANA XS connectivity for UI5 solution

Confidential, Newtown Square PA

SAP HANA and SAP BI Lead

Technologies SAP BW on HANA, HANA Side Car, HANA Studio 95 and SAP CRM, SBEE (Smart Business Executive Edition.

Responsibilities:

  • As a Lead my primary responsibility was to make a Successful Data provisioning connection with SLT and develop and design HANA Models for Resource management project & develop reports.
  • Involved in design work shop & understand the HANA architecture & requirement scope for RM project.
  • Align with Basis team to Set up SLT Server and establish a successful connection.
  • Align with the HR Functional Team to understand the Tables to be replicated in SAP landscape with SLT.
  • Replicated individual tables in SLT and Monitored the Replication process.
  • Checking the Status in SAP front End and checking table Data in HANA studio. updating current activity SLT status on tables to dependent teams
  • Identifying the required fields from the existing BEx reports in BWand finding the source tables and fields of the same from source system with the platform team to replicate the tables from source systems to HANA system.
  • Coordinating with the platform team to replicate the tables from source systems to HANA system.
  • Creation of Attribute Views, Calculation Views and Analytical Views in HANA.
  • Mapping the text tables with the actual keys in the source to replicate the master data similar to BW.
  • Complete reconciliation of HANA DB with RM Application in reference to BW System.
  • Creation of virtual providers, enabling the Info objects from Hana Studio to BW virtual provider.
  • Creation multi providers and accessing the data from virtual providers for reports.
  • Building BEx reports on top of the data targets. Implementing Business Logics in BEx for HR analytical Reports.
  • Analyzing the data on reports and testing the same in comparison with the existing application.
  • Involved in testing & bug fixing on tickets raised by users in UAT.

Confidential, Newtown Square PA

SAP BI Sr Developer

Technologies SAP BI 7.3 BEx, Query Designer. SAP LUMIRA

Responsibilities:

  • Primary responsibility was to understand the Business Requirements and perform Technical changes.
  • Developed Tech Specs and coordinated different tasks with the extended Team SAP IT TCS Colleagues.
  • Creation and review of new BI Modeling Objects and BEx Queries based on Technical Specifications.
  • Involved in modifications of WAD templates for the complete project as per business requirement.
  • Created Variables, Formulas, and Alerts as per business requirement.
  • Creation and Scheduling of data loads using Process Chains.
  • Creation of Test Description Documents and uploading the same in SAP project space.
  • Documented Reporting Level Architecture along with the load Process of the process chains.
  • Developing BEX and LUMIRA reports

Confidential, Newtown Square PA

SAP BI Sr. Developer

Technologies SAP BI 7.3 BEx Reporting, WAD Reporting.

Responsibilities:

  • Single point of contact for Utilization Projects & requirement changes.
  • Worked in SAP AG for Technical Design discussions in Project Initiation Phase.
  • Developed Technical Specs and co-ordinate tasks with the team.
  • Involved in Requirement gathering for Utilization and P&L Projects
  • Creation of Test Description Documents and uploading the same in SAP Solution Manager.
  • Successful co-ordination &completion of Integration Testing, UAT & Regression Testing.
  • Documented Reporting Level Architecture along with the load Process of the process chains.
  • Responsible for Successful Handover and Post production support.
  • Support the team with complete documentation & process know how.

Confidential, Newtown Square PA

SAP BI /BO Developer

Technologies: SAP BI 7.3 BEx Reporting, WAD Reporting. SAP BO Xcelcius, BO Explorer, Analysis Office

Responsibilities:

  • Creation and review of new BI Modeling Objects and BEx Queries based on Technical Specifications.
  • Created reports for different business logics in BEx Reporting which suits Dashboard report format.
  • Development and testing of backend BEx Queries exclusively for Dashboard creation.
  • Involved in creation of BO Dashboard Design based on BICS Connection (Information Design Tool).
  • Involved in creation of RMDB for SAP using SAP Business Objects Dashboards Tool.
  • Successful co-ordination and completion of Integration Testing, User Acceptance Testing and Regression Testing through SAP Solution Manager. Post production support after Go-Live.
  • To do the year end Hierarchy changes accordingly for these Reports and RM dashboards.

We'd love your feedback!