SAP HANA, Business Objects, Business Intelligent, Reporting
Resume:
Hardik Patel
**********@*****.***
SAP HANA Consultant
Professional Summary
•3 years of functional experience in SAP HANA, BW, BOBJ & BODS. Over 2 years of extensive experience in SAP HANA-Data Modeling, Data Provisioning, Reports development.
•Worked in a full life cycle implementation integrated planning, design, implementation and support of SAP HANA based solutions including Data Modeling, SAP ECC, SAP Business Warehouse (BW), and SAP BI/Business Objects in large and complex environments.
•Experience in full lifecycle SAP HANA implementation in HANA Studio and BW on HANA implementation.
•Knowledge on experience on Enterprise Structure on FI and SD side.
•Knowledge about SAP HANA Architecture which includes setting up modeling environment, creating Info views (Attribute view, Analytical view & Calculation view), Importing table definitions and data, Defining Data Access privileges using Analytical Privileges, Additional Functionality for Information Views, Managing Objects, System & User Management.
•Extensive experience in Development, Testing, Documentation, Requirement analysis, End user documentation, Data extraction, Data modeling, Data loading, Reporting and Production Support.
•Strong experience in OLAP/OLTP Data Modeling using Entity Relationship, Multidimensional/Star Schema and Extended Star Schema models.
•Experience in Data-Provisioning techniques using SLT (SAP Landscape Transformation) to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
•Experience in SAP BO BI 4.0 including Crystal Reports 2011, Dashboard Design, Information Design Tool, BI Launch Pad, Web intelligence Rich Client, Universe Designer Tool, BO Explorer, Analysis Edition for OLAP, BI workspace, BO widgets, managing Central Management Console (CMC), Upgrading CMS using Upgrade management Tool.
•Designed and developed queries for reporting using BEx Analyzer, Query.
•Good understanding in extracting maximum value from Big Data by combining the in-memory processing power of SAP HANA with Hadoop ability to store and process huge amounts of data, regardless of structure.
•Developed Reports in SAP Business Objects BI 4.x/3.x using tools, BI launch Pad, Web Intelligence (WEBi), InfoView/launch pad, Crystal Report, Xcelcius/Crystal Dashboard Designer.
•Experienced in Building universes on top of HANA information models for WEBi/Dashboard reports.
•Proficient in databases like Oracle 10g/9i/8i, MS SQL Server 2008/2005 database triggers, views, Packages, stored procedures, functions, and database constraints, SQL Loader, SQL*Plus, SQL Navigator, PL/SQL and oracle DBMS Packages.
•Experience in Configuring and Consuming SAP HANA models in BI clients such as Lumira, Predictive Analysis, and Business Objects Explorer & MS Excel.
•Extensively involved in Data load & Report Performance tuning Techniques and handled daily batch jobs, load failures, delta failures, Performance issues, BIA issues, System issues, reporting issues, locking issues, resource bottleneck issues.
•Excellent communication, interpersonal skills and strong ability to understand business process requirements and translate into client specific SAP solutions.
Skill Profile
SAP BW/BI7.x:
SAP BW3.5/BI7.0,SAP Net Weaver, SAP R/3 ECC 5/6(SD, FI/CO, HR, PM, MM), ABAP, SAP Script, Reporting, Module Pool, ALE, IDOC, RFC, Message Control, BAPI
OLAP Reporting
tools:
SAP Business Explorer (BEx) Analyzer, BEx Browser, Web Application Analysis, edition for OLAP, Design Studio, Dashboards, Lumira, Web Intelligence, Crystal Reports 2011
SAP Business Object
BI 4.x/3.x
Universe Designer, Information design tool, Launch pad, Info View, Xcelsius, Dashboard, Web Intelligence, Desktop Intelligence, Crystal Report Enterprise/2008/2011, Query As A Web Service, Live Office
SAP Data Services
Data Services Management Console, Data Service Designer
SAP HANA
SAP HANA Studio, SAP HANA Database, Information Modeler, SAP LT Replication Server
Databases:
ORACLE, MS SQL Server, DB2, Sybase, MS Access
Operating Systems:
Solaris8/7/2.6/2.5.1, SCO UNIX, HP-UX. AIX5.2/4.3, Windows 2008
Professional Experience
Dow Chemicals, Midland, MI May 2015 – June 2016
SAP HANA Consultant
Responsibilities
•Interacted with the management and business decision makers to identify business requirements.
•Participated in Data Mapping workshops and follow-up meetings with the client business and IT teams. Assists in data mapping and GAP analysis between source and target data in BODS as per the blueprint.
•Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
•Accessed query data from data sources SQL, SYBASE IQ to map data types from databases connected via SAP HANA Smart Data Access to SAP HANA data types.
•Created blueprint for Technical/Functional specifications and standard modeling documents for HANA.
•Data provisioning to replicate data from ECC and non-SAP systems to HANA system through BODS, DXC and SLT.
•Worked with Functional consultant to create the scenario based reports in FI and SD.
•Involved in HANA Modeling Activities for specific report requirement to achieve the real time reporting for high volume data.
•Created catalogs, Schemas, tables and views in HANA system.
•Developed HANA objects Attribute Views, Analytic Views and Calculation Views to implement the real time data reporting directly from ECC through HANA system.
•Involved in importing of BW Models into HANA for specific report requirements.
•Build HANA Information models (Attribute Views, Analytical Views (Star Schema), Calculation Views (Star Schema, Snowflake schema), and Column/Row based tables) in HANA design studio for efficient data integration.
•Developed Real-Time Information models to support SLT replicated tables from SAP ECC.
•Transported objects by creating delivery units between SAP landscapes.
•Developing and transporting BW specific Objects for HANA for new system
•Creation of HANA Optimized InfoCubes and HANA-Optimized DSO for faster loading and reporting performance.
•Worked to reduce redundancy to lower memory footprint. Worked on creating and adjusting new process chain in HANA environment.
•Performed full and delta loads based on MD5 checksum and scheduled workflows.
•Monitored, Debugged and followed ETL best practices for efficient data loading.
•Imported Flat files using SAP HANA import wizard.
•Performed trigger based data replication using SLT technique for SAP ECC SD, FI.
•Monitored triggers, data loads for SLT schema.
•Involved in creating transformation in SLT for enhancing BP Role, BP Status and business required fields.
•Data Load via SAP BW extractors (DXC) to HANA from EDW.
•Build universes on top of HANA information models for WEBi/Dashboard reports.
•Customer Sales Analysis for Denied Party Screening (Sales organization Drilldown, Business Unit Drilldown, Customer Type).
•Migrated HANA content from development, testing environment to Production environment using Delivery Units.
Environment: SAP HANA (SP9), SAP BI BW 7.4, SAP BOBI 4.1, SAP R3 ECC, ABAP, CRM, Oracle DB, Mainframe.
Komatsu America Corp., Rolling Meadows, IL Oct 2014 – April 2015
SAP HANA Consultant
Responsibilities
•Involved in writing the technical specifications, standard modeling and Implementation, documentation for HANA.
•Performed Data Modeling and developed Analytical Views for the transactional data, Attribute Views for the master data, and the Calculation Views as final model in HANA Studio.
•Created the necessary Calculated Attributes, Restricted Measures, Calculated Measures and Input Parameters using the HANA studio tool.
•Used the HANA studio Functions like Conversion, String, Mathematical and Date to suit the business requirements in Calculated Attributes and Calculated Measures.
•Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio as Analytic views and Calculation Views.
•Understanding the existing SAP BW Models and documenting the business flows in SAP HANA.
•Developed the Attribute Views based on Master Data Tables in the SAP ECC.
•Developed the Analytic Views based on Transaction Data Tables in the SAP ECC for SD, FSCM, CO modules.
•Created the Analytic Views based on the Info cube models in SAP BW/BI system.
•Created the Graphical Calculation Views by including the Analytic views using Unions, Projections and Joins based on the business logic.
•Worked on designing SAP BW data Flows (DSOs, Transformation and DTPs) in the BW (on HANA database) scenarios and imported the DSOs, Info cubes to the HANA studio tool.
•Gathered and analyzed the requirement to replicate the ECC content in HANA using the Real-time SLT Process.
•Involved in ETL Based replication to provision the data from SAP ECC to HANA system through BODS.
•Created Universes on top of HANA calculation views and developed the WEBi reports and dashboards using IDT (Information design tool).
•Reconciled the data with the existing BW Reports with the new HANA Models.
•Created Calculation Views using database tables, attribute views, analytic views and created SQL Script based calculation views.
•Called the Calculation View to BOBJ 4.0 IDT Tool to create Universes.
•Created the Visualization Reports in SAP BOBJ Explorer 4.0 based on the Analytic Views, Calculation views and Universes using measures and Facets on the Information Spaces.
•Created Security for the BOBJ reports for the business users.
Environment: SAP BW BI 7.3, SAP HANA 1.0(SP6), SAP R3 ECC 6.0, FI, HR, SAP BEx Explorer 7.x, SAP BO 4.0,Visio, MS Office
CNH Industrial, Racine, WI Mar 2013 – Sept 2014
SAP Business Objects Consultant
Responsibilities:
Designed universes named Accounts Payable, Purchasing and Capital Projects using Oracle 10g/11g.
Converted DESKI reports to WEBI reports using Report Conversion Tool as per business user’s needs.
Involved in heavy interaction with the Business Analysts in the process of gathering Reporting requirements, preparing specification documents and report writing.
Created many WEBI reports like Balance Sheet, Profit and Loss Statements, G/L Balance, and Statement of Cash flow reports with high complexity.
Converted few existing WEBI reports to Crystal reports to overcome the limitations of output data rows in WEBI.
Developed Crystal Reports on top of Universes, SAP ECC and Oracle. Implemented row level security in the crystal report using the security table and Current CE User function.
Scheduled and published WEBI and Crystal Reports using Info view, and trained users on creating reports.
Developed Xcelsius Dashboards with multiple selector components and Bar/Pie charts for MTD, QTD and YTD data comparison. Used Live Office to import data from necessary WEBI and Crystal reports.
Administered and supervised the Business Objects environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.
Migrated all the developed reports from Business Objects development team to test and then test to production using LCM (Life Cycle Manager).
Environment: MS SQL Server 2008 Enterprise Edition, MS SQL Server Reporting Services 2008, SSAS 2008, SQL Server Management Studio, T-SQL, Performance Point Server.
EDUCATION DETAILS:
•Masters in Computer Information and Sciences: Knowledge System Institute, Skokie, IL
Contact this candidate