We provide IT Staff Augmentation Services!

Sap Hana Consultant Resume

Bartlesville, OK

INTRODUCTION:

SAP HANA / BOBJ Consultant with 13+ years of IT experience in Design and Development of Data warehouse systems primarily using In Memory Database Technology SAP HANA, SAP Business Objects 4.1, 4.0, XIR3.1, XIR2, Web intelligence 6.x/ 2.6, Business Objects Enterprise Suite (Business Objects Reporter, IDT, SAP BO Dashboard) and SSAS Cubes. Executed 4 SAP HANA projects for Oil & Gas Industry on a very large scale and worked on various RFP’s and POC’s across different clients. SAP BO Training to more than 50 consultants.

SUMMARY:

  • Experience in SAP HANA 1.0 - SP 11 includes blueprinting, developing Information models, data provisioning, Performance Optimization and BI Reporting
  • Experience using various Business Objects (BOBJ) Product Suite including Web Intelligence, Advanced Analysis for OLAP, Explorer, Universe Development, Crystal Reports 2011, SAP BO Dashboards 4.1
  • Expertise in BOBJ Development in versions SAP Business Objects XI 4.0/ XI 3.1/ XI R2/ 6.5 and Confidential 2011 and 2008
  • Hands on Experience in creating various Information models in SAP HANA Design Studio.
  • Good hands on experience in writing stored procedures, triggers and queries on SAP HANA and Oracle database
  • Hands on experience in creating Dashboards using Tableau 10.3
  • Experience in executing projects in agile approach and delivering solutions in accordance to business needs.
  • Involvement in establishing technical documentation, functional documentation, migration checklist, conceptual model checklist, and performance benchmarking documents.
  • Designed, implemented, deployed and supported Business Objects Universes
  • Proven track record of successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements
  • Good understanding of Data Warehousing, Star Schema, Snow Flake, OLTP and OLAP
  • Proven abilities in creating complex reports by linking data from multiple data providers
  • Understanding of Business Objects Data Services whilst implementing GL Rapid Mart
  • Experienced in migration of Cognos Cubes to Business Objects Universe and report development
  • Proficient in creating Cube using Microsoft SQL Server Analysis Services ( SSAS )
  • Performance tuning at BO report and universe level with queries, aggregations at DW level, etc.
  • Presentation of Prototype for business processes and interaction with end user and customer for kick off of further development
  • Developed several client server applications using Visual Basic, ASP, MS SQL Server 2000/7.0
  • Involved in complete testing life cycle such as preparing and implementation of test cases for Unit, Integration and System testing and possess a commitment to quality
  • Involved in Training & Supporting end-user reporting needs using Business Objects

SKILLS:

Reporting Tools: Tableau 10.3, BI 4.1, 4.0, BO XI R2/R3, Web Intelligence (Web I 4.1)Information Design Tool, Dashboard Design (Xcelsius), BO ExplorerDesktop Intelligence (Desk I), Crystal Reports 2011

ETL Tools: BODS 4.0/4.1,XIR3.2,BODI, Rapid Marts

In Memory DB: SAP HANA 1.X SP11, SAP HANA Live, Sybase IQ, SDA

Databases : SQL Server 2008, Oracle 9I

Domain Knowledge : Oil & Gas , Insurance, Supply Chain

PROFESSIONAL EXPERIENCE:

Confidential, Bartlesville, OK

SAP HANA Consultant

Responsibilities:

  • Involved in gathering User Requirements by conducting workshops, created detailed Functional Design Documents and converted to Technical document along with Report mockup design documents for the reports.
  • Interact with the Business Users for their KPI & report requirements
  • Experience on Native Data Modeling HANA attribute, analytic, and calculation views (graphical and script).
  • Design the flow of data through various information models
  • Create packages, manage attribute mapping, and create constant columns and analytics privileges.
  • Develop the models using SAP Best practices
  • Extensive Hands on experience on SQL scripting and stored procedures.
  • Performance Optimization to improve performance of models.
  • Provide phase by phase technical estimated for development work packets.
  • Unit Testing of models, and providing inputs to the BI team as and when required for reporting requirements
  • Review of all deliverables
  • Created Technical Documentation of each user story along with Migration Checklist, Conceptual Model Checklist and Performance Benchmarking documents
  • Created 3 complex Dashboards using Tableau as front end.

Technologies: SAP HANA 1.0 SP11, Tableau 10.3

Confidential, Bartlesville, OK

SAP HANA Consultant

Responsibilities:

  • Involved in gathering User Requirements by conducting workshops, created detailed Functional Design Documents and converted to Technical document along with Report mockup design documents for the reports.
  • Interact with the Business Users for their KPI & report requirements
  • Experience on Native Data Modeling HANA attribute, analytic, and calculation views (graphical and script).
  • Design the flow of data through various information models
  • Create packages, manage attribute mapping, and create constant columns and analytics privileges.
  • Develop the models using SAP Best practices
  • Extensive Hands on experience on SQL scripting and stored procedures.
  • Performance Optimization to improve performance of models.
  • Provide phase by phase technical estimated for development work packets.
  • Unit Testing of models, and providing inputs to the BI team as and when required for reporting requirements
  • Review of all deliverables
  • Created Technical Documentation of each user story along with Migration Checklist, Conceptual Model Checklist and Performance Benchmarking documents
  • Created models using Smart Data Access (SDA) whilst having Sybase IQ as backend.
  • Achieve Current and Historical Hierarchy of Sales. This was something that Phillips 66 was missing for years.

Technologies: SAP HANA 1.0 SP11, Tableau 10.3, SAP Business Objects, Smart Data Access, Sybase IQ

Confidential, Bartlesville, OK

SAP HANA Consultant

Responsibilities:

  • Understanding the Business Requirement
  • Designing modelling objects which includes creation of Attribute Views, Analytic Views Graphical / Script Calculation views.
  • Design the flow of data through various information models
  • Develop the models using SAP Best practices
  • Performance Optimization
  • Provide Phase by Phase technical estimated for development work packets.
  • Architecture complex reporting requirements
  • Unit Testing of models, and providing inputs to the BI team as and when required for reporting requirements
  • Review of all deliverables
  • Created Technical Documentation of each user story along with Migration Checklist, Conceptual Model Checklist and Performance Benchmarking documents

Technologies: SAP HANA 1.0 SP11, SAP Business Objects WebI

Confidential

SAP BO Lead Consultant

Responsibilities:

  • Responsibilities include understanding the current reports and doing analysis of the current structure
  • Updating the report to ensure that the output in excel comes in line with header and under lying data
  • Unit Testing of reports
  • Review of all deliverables .

Technologies: SAP Crystal Report 11, SAP BW

Confidential

SAP HANA Consultant

Responsibilities:

  • Designing modelling objects which includes creation of attribute views, analytic views, graphical calculation views, stored procedures, decision tables, delivery units, schema mapping, flat file upload, creation of custom tables in HANA
  • Data Provisioning in SAP HANA using SLT (real time replication)
  • Designing analytic privileges, users, roles, security models
  • Design of Stored Procedures using SQL which includes logic of allocation run in COPA Currency Conversion f transaction data to Controlling Area currency
  • Configure R/3 data using SLT DMIS 2010 SP 07
  • Design of SAP Business Objects Universes using Information Design Tool
  • Design of reports using SAP Business Objects reporting tools viz. Crystal
  • Reports, Web Intelligence, Dashboard Designer
  • Help in designing interfaces using SAP ABAP to execute allocation

Technologies: SAP HANA 1.0 SP6, SAP Business Objects, Dashboards

Confidential

SAP BO Lead

Responsibilities:

  • Understand the business requirements
  • Responsible for design and implementation end to end solution in SAP BO technology.
  • Requirement gathering of 500+ reports and 27 dashboards.
  • As a part of solution design team, actively involved in DB design of OLTP and OLAP system.
  • Responsible for Universe Design and Development.
  • Developed 6+ universes on OLTP and OLAP DB using Universe Design Tool.
  • Complex report development in WEBI tool. Provided input to team member for developing logic.
  • Developed complex logic in WEBI report to suffice client requirement which involves use of calculation context with dynamic hiding of report fields.
  • Extensive use of hyperlink, SET operators, ranking functions at WEBI reports, Developed cascading prompts in Universe Design Tool.
  • Used data security using @Variable function. Also used Object level security so that end user can not able to develop adhoc report on certain objects, even though they are having access to view report dependent on those objects.
  • Worked closely with ETL team to design complex mappings in dataflow.
  • Provided module wise estimation to project manager

Technologies: SAP Business Objects WEBI, IDT, Dashboards, IBM DB2, SAP BODS

Confidential

Lead Developer

Responsibilities:

  • Gathering information on Cube specification.
  • Providing phase by phase technical estimates for project completion.
  • Conduct review at each level. Project tracking, sharing knowledge, bi-weekly review meeting & project delivery in time.
  • Writing scripts for Fact Table creation.
  • Providing Cube based solution to various Business requirements
  • Understanding the data model, and creating the Cube in MS SSAS 2008
  • Participate in Unit testing.
  • Data validation test for the reports.
  • Self / Peer Review of all deliverables
  • Client Training - How to create adhoc reports using SAP BO OLAP Analysis

Technologies: Microsoft SSAS, SAP OLAP Analysis, WebI, IDT, MS SQL Server 2008

Confidential

SAP BO Lead Developer

Responsibilities:

  • Gathering information on Report specification.
  • Providing phase by phase technical estimates for project completion.
  • Conduct review at each level. Project tracking, sharing knowledge, weekly review meeting & project delivery in time.
  • Creating BEX (OLAP) queries.
  • Architecture of Complex Reporting requirements.
  • Creating a set of high priority and medium to complex reports through Web Intelligence.
  • Created reports using Charts, Tables, Alerter and Drill.
  • Participate in Unit testing.
  • Data validation test for the reports.
  • Self / Peer Review of all deliverables

Technologies: SAP Business Objects WEBI, IDT, Dashboards, SAP BW

Confidential

SAP BO Lead Developer

Responsibilities:

  • Gathering information on Report specification.
  • Providing phase by phase technical estimates for project completion.
  • Conduct review at each level. Client interaction, project tracking, distribution of work, sharing knowledge, weekly review meeting & project delivery in time.
  • Architecture of Complex Reporting requirements.
  • Understanding the data model, and creating the report in WEBI
  • Creating a set of high priority and medium to complex reports through Web Intelligence.
  • Created reports using Charts, Tables, Alerter and Drill.
  • Participated in Unit testing and facilitated UAT.
  • Data validation test for the reports that we create.
  • Providing Definitions for new objects required in Custom Universe.
  • Self / Peer Review of all deliverables
  • Wrote several Stored Procedures and Packages for implementing Mini DWH for The Home Depot

Technologies: SAP Business Objects WEBI, UDT, Oracle 10G

Confidential

SAP BO Lead Developer

Responsibilities:

  • Analysis of existing Cognos Application Architecture, Report net reports, Infrastructure, Database, etc.
  • Proof of concept on Business Objects to verify the feasibility, performance, and ease of migration from Cognos
  • Understanding the data model, Cognos Cubes and creating BO Universe.
  • Creation of Data Mart based on the reporting requirement, design of the load process of data from the OLTP system onto the data mart
  • Planning for migration from Confidential with considerations like complexity of the report, use of the underlying data base, etc
  • Performance analysis for BO reports and fine tuning the queries, universe and reports
  • Creating a set of high priority and medium to complex reports through Web Intelligence.
  • Participated in Unit testing and facilitated UAT
  • Training the user to understand the new system.

Technologies: SAP Business Objects WEBI, UDT, Oracle 9I, MS SQL Server 2000

Confidential

Lead Developer

Responsibilities:

  • Review the requirements and see if reporting can be done using the existing universe.
  • Identify reports that would need a change in the universe and do change required.
  • Resolved loops and traps from the Universe.
  • Tuning the universe for better performance.
  • Created complex reports using Charts, tables, Alerter and Drill.
  • Setting up incompatibilities at Universe level.
  • Impact analyses of the changes required in the Universe and document the same.
  • High Level of user interaction and bridging with User Sign off and Reviews throughout the project.
  • Participate in technical and quality reviews of the release.
  • Preparation of knowledge capture document.
  • Debugging the SSIS packages and stored procedure code for any issues and to perform data cleaning.

Technologies: SAP Business Objects WEBI, UDT, Xcelsius, Info Reports, MS SQL Server 2000, Oracle

Hire Now