Sap Data

SAP HANA / BI Certified Consultant

Prince J. Kingsley

**** *********** ****, ***** ****, TX 77479

Phone: 832-***-**** E-Mail: ***********@*****.***

Seeking assignments or employment in SAP HANA; BW; BOBJ from an organization of high repute in IT sector, preferably in Houston

Profile Snapshot

SAP HANA Certified Consultant with 11 years’ experience in SAP Business Analytics Implementation. Rich experience in project management, entailing planning, scheduling, negotiations with the client for service level agreements / terms, project progress monitoring and delivery as per quality, time and budgetary norms. Serving as Internal Trainer for HANA. Adept in creating & testing End-to-End Scenarios in SAP HANA, Dashboards in SAP BOBJ & BODS

Insightful knowledge of business process analysis (As-Is, To-Be) and design, application based process reengineering, process optimization, cost control & revenue maximization from SAP BW, HANA, Business Objects, and Tableau systems solutions using cutting edge technologies.

Rich experience with strong knowledge in SAP BW, BW on HANA and Business Objects (Reporting & Data Services).

Reporting experience includes BEx, Business Objects and Tableau.

Extensive data modeling in SAP BW and SAP BW on HANA using Info Objects, DSOs, Info cubes, composite providers, semantically partitioned objects etc.

Data Migration experience using SAP BODS into SAP BW and SAP CRM.

Data Extraction from SAP R/3 and non-SAP systems.

Analytically driven and deep expertise in development and execution of SAP BW & HANA Implementation projects.

Experience working in complex big implementation thru onsite-offshore model.

Extensive data modeling, reporting and error analysis skills.

SAP HANA administration

Monitoring

Configure alerts in HANA for memory consumption

Create and configure connection SLT to HANA

Setup roles for admin, consumers, HANA modelers

Create IDs for end-users in BOBJ and integrate with SAP HANA

Created schemas on HANA Server

Create and schedule regular backup

Created and Assigned Analytic Privileges to users

SAP HANA development

Created Attribute Views

Create Analytic Views

Created Calculation Views

Created SQL scripts for Calculation views

Created Analytic Privileges

Data loading using BODS

Extracted data from using BW extractors from ECC

Create universes on HANA tables/views

SAP HANA on BW

Converted Native BW models to HANA optimized models (Info Cube, DSO’s)

Created Sematic Partitioned Objects. Ex Info cubes

Created Transient provider & Composite provider

Imported BW cubes in SAP HANA

SAP BUSINESS OBJECTS

Installation & patching of SAP BI and SAP BODS.

Configuration of CMS and repository for BODS.

Data replication through ETL process

Created & designed Universe for reporting from Information models

Creating Universes using Business Objects Universe Designer and Reports in Web Intelligence and Crystal Reports

Designed functional and Technical specifications for Implementation and Development of BO Universes, Webi Reports Dashboards and Lumira Reports

Working in different projects providing Business Intelligence solutions.

Involved in development of Business Object components and executive dashboards using Central Management Server, Desktop Intelligence, Crystal Report, Live Office, Query as Web Service, Web Intelligence, Universe Designer, Info view.

Manage Users, Groups, Folder Level Securities

Used QAAWS for pulling information from the universe and developing Dashboards.

Installed, configured and maintained Business objects 4.1

Upgrade from 3.1 to 4.1

Performed User Accounts Administration

Conduct group training to users on Business objects tools.

Involved in Project Documentation including Requirements Collection, preparing Specification Document, Technical Document, User Manual, etc.

Excellent interaction and communication skills and can work efficiently in problem analysis and providing efficient solutions to business.

Deftness in understanding business process, study and analyzing workflow to design solutions (To-Be, Why-why Analysis and Freezing); preparing the detailed process flow for functional requirements. Demonstrated excellence in integration with other modules, integration & user acceptance testing & extending post go-live support, including training support to end-users. A focused leader with communication skills and expert analytical, relationship management and coordination skills.

Skill Set

Strategy Planning Quality & Process Standardisation Setup of IT Roadmap

Drafting Blueprints Business Process Reengineering SAP Implementation

Go-live and Post Go -Live Technico Documentation Solution Identification

Employment Details

CVR Energy, Sugar Land, TX 02/15 – 12/15

Roles: Lead SAP Business Objects Administrator /Developer

Shell Oil Company. Houston, TX 06/14 – 01/15

Role: Solutions Architect: SAP BOBJ/BODS/HANA Architect

University of Texas MD Anderson Cancer Center, Houston, TX 01/14 – 05/14

Sr. Applications System Analyst

Reliant Global Technology, Houston, TX 08/11 - 08/13

Sr. SAP BW/HANA/BOBJ Consultant

Rockwell Automation, Milwaukee, Wisconsin 10/09 – 02/11

SAP BW/BOBJ Consultant

Monsanto: St. Louis, MO 11/07 - 08/09

SAP BW Consultant

Intercontinental Exchange, Atlanta, GA 08/05 – 09/07

SAP BW Consultant

SABIC Americas, Inc., Houston, TX 07/04 – 06/05

SAP BW Production Support

Key Result Areas

Handling project planning, execution and management in tune with the core business objectives (including risk management, effort / time / cost estimation)

Setting-up of master data and function locations, importing the relevant data, task lists and maintenance orders of system as per functional requirement

Developing all relevant reports per user requirements including maintenance notifications, activity and malfunction reports

Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting).

Expert in creation of Analytical and Attribute Views and complex models by using SQL script in Calculation Views.

Created Analytical Privileges and Procedures for modeling

Good understanding of various components of SAP HANA.

Overview working knowledge with SAP BO Data services & SLT replication methods.

Designed and Created Universe for reporting from Information models.

Deliverables My responsibilities as part of this project included,

Forming a data migration strategy for migration of data from production system to HANA system.

Setting up the SAP SLT landscape. The landscape included the source system(Production system), a dedicated SLT server and SAP HANA

Configuring the SLT server and the required DB tables

Coming up with a strategy for database table partitioning for larger tables in SAP HANA

Establishing project plans within pre-set budgets and deadlines as well as monitoring project progress as per scheduled deadlines for various tasks and taking necessary steps to ensure completion within time, cost and effort parameters

Planning various activities involving resources management, project expenses, etc., while analysing user requirements in order to understand the problem domain and suggesting the alternatives available for a solution to them

Performing configuration of various documents, reports and configuration of different accounts as well as reviewing various alternatives available and choosing the best solution available

Providing an appropriate solution to client to meet business needs and guiding the setup and customization of release procedures for classification of various internal & external documents, etc.

Coordinating with the development team for development / customisation of software, while ensuring integration with other modules, integration & user acceptance testing & extending post go-live support, including training support to end-users

Supporting and monitoring for preparing help manuals for all modules to reduce queries from implementation sites and conducting internal audits to ensure on-going improvements in the quality assurance systems.

IT Skills

Business Intelligence: SAP (HANA / BW / BODS / BOBJ) ERP SAP R/3 and TABLEAU 8.2 to 9.3

Reporting Tools: BEX Analyzer, Query Designer, WAD, Report Designer, SAP BO Dashboards, Design Studio, WEBI and Tableau 8.2 to 9.3

Microsoft: SSIS, SSAS, SSRS and SharePoint Implementation.

Predictive Modelling & Data Mining: Basis knowledge of SAS, and R programming for Boosting, Association Rule Mining, Clustering, Neural Networks, Regression, Support, Time Series Analysis, Decision Trees, Bayesian Inference.

Certifications

SAP HANA Certified

SAP BOBJ Certified

Oracle 10g Certified

Microsoft SQL Server Database Certified

Microsoft SharePoint Certified

Microsoft Business Intelligence Certified

Academic Qualifications

BSC (Finance) University of Houston, Down Town 2004.

Contact this candidate