We provide IT Staff Augmentation Services!

Sap Hana Consultant Resume

0/5 (Submit Your Rating)

Memphis, TN

PROFESSIONAL SUMMARY:

  • 9years of Information Technology experience inImplementation and Support in SAP HANA/BI/BODS/BW.Including 3+ years of extensive experience in SAPHANA - Data Modeling, Data provisioning through SLT, DXC and BODS.
  • Extensively worked onHANA Modeling (Design Studio), Attribute Views, Analytical Views, Calculation views, Analytic Privileges, Variables, Virtual Tables, Input Parameters, Stored Procedures, Decision tables, Table Functions, Delivery units, PL/SQL Scripting, CE Functions, SLT replication, OData Services, Smart Data Access (SDA), HANA Spatial engine functions and HANA XS applications.
  • Good understanding of SAP HANAarchitecture, user management and security.
  • Migrating HANA content from development, testing environment to Production environment using delivery units.
  • Strong experience in OLAP/OLTP Data Modeling using Entity Relationship, Multidimensional/Star Schema and Snowflake Schema models. Strong knowledge of Data Warehousing (DW).
  • Hands-on experience in project proposals and project preparation, blueprint design, data warehouse/report development, preparing testing scenarios for data validation, preparing technical documents, functional documents, testing, user and support of the BI system.
  • Working closely with Business to understand business process for SAP BI implementations, design of data modeling and reporting and also experience selling major SAP BI implementation consulting projects.
  • In-depth knowledge of SAP Data Services 4.2 which involves creating complex Jobs, Work Flows, Data Flows, Writing Scripts and using different DI/DQ Transformations to successfully load data from multiple sources into a desired target.
  • Strong experience in Development, Testing, Documentation, Requirement analysis, End user documentation, Data extraction, Data modeling, Data loading, Reporting and Production Support.Involved in building reports using SAP BO with BI and HANA.
  • Good Understanding of standard SAP modules. (FI/CO, SD, MM, PP, HR).
  • Experience in SAP BI/BW 7.x, 3.5 with SAP R/3ECC 6.0, BOBJ 4.0 and BOXI R3.1.
  • Experience in SAP BOBI 4.0, 4.1 building Universes, Dashboardsand WEBi Reports by extracting data from HANA Information Views, BEx Queries and SAP BW Cubes.
  • Exceptional record of delivering effectiveness, in design of business applications as Techno Functional consultant.
  • 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.
  • Experience in OLTP extractions of SAP LO-Cockpit, FI-GL, FI-AP, FI-AR, SD, MM, PP, CO-PA, HR, Generic extractions and non-SAP source systems.
  • Experience in building OLAP connections, Universes and creating reports using Business Objects & Web Intelligence Tools.
  • Handling of the production support tickets and resolving them as per the ticket priority and transporting them into Quality and Production environments.
  • Knowledge in SAP HANA security management including user management, roles and privileges.
  • Proficient in databases like Oracle 10g/9i/8i, MS SQL Server including experience in database triggers, views, Packages, stored procedures, functions, and database constraints, Toad, My SQL Workbench,SQL Navigator, PL/SQL and oracle DBMS Packages.
  • Excellent communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS:

Data Warehousing: SAP HANA, NetWeaver BW 7.4, BI 7.0, BW 3.5

ERP: SAP R/3 ECC 6.0, SAP R/3 4.7

Functional Modules: SD, MM, PP, HR, FI-CO, CRM

Data Replication, ETL: SAP BODS 4.2

Reporting Tools: WEBi, Dashboard (Xcelcius), BEx Query Designer, BEx Analyzer, Crystal Reports for Enterprise, MS Excel, BO Explorer, Tableau

Business Modeling: HANA Design Studio, Data Services Workbench, Data Warehousing Workbench (RSA1), Information Design Tool (IDT), Relational OLTP

Programming: PL/SQL, Shell Scripting, Java, C#, C, OOP

Databases: SAP HANA 1.0 (SP10), Oracle 10g/9i/8i, MS SQL server 2008, MS Access, MySQL 5.x

Operating Systems: Windows NT/2000/XP/7, Windows Server 2008, Unix, Linux

Testing: HP Quality Center

Project Methodologies: Agile/Scrum, ASAP

WORK EXPERIENCE:

SAP HANA Consultant

Confidential, Memphis, TN

Responsibilities:

  • Established the best modeling and recommended strategies and architecture for SAP HANA by providing end-to-end solution for enterprise subscription analytics.
  • Designed and developedHANA Artifacts (models) like attribute views, analytical views, calculation views (Graphical/Scripted), stored procedures usingSAPHANA Studio.
  • Developed strategies for business intelligence, analytics, and enterprise reporting.
  • Created blueprint for Functional specifications and standard modeling documents for HANA.
  • Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
  • Liaison with business and offshore teams to collaborate on project.
  • Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
  • Migrated the developed HANA models/procedures and Data services jobs/scripts across the system landscape from Dev to QA etc.
  • Responsible for effective communication between the project team and the stake holders. Provided day to day inputs to team members and regular project status to the stake holders.
  • Built HANA Information models (Attribute Views, Analytical Views, Calculation Views and Column based tables) in HANA design studio for efficient data integration.
  • Designed and created column store tables and HANA views to support 17 reports based on closed opportunities from Salesforce platform (SFDC) for Enterprise term licensing business users.
  • Implemented currency conversion, input variables and parameters and analytic privileges security.
  • Created the database procedures and script based calculation views using HANA programming languages such as SQL Script and CE functions or native SQL.
  • Created SQL script based Calculation Views using CE functions.
  • Developed and imported SAP HANA optimized Infocube and DSO’s into SAP HANA environment and vice versa (mixed scenarios).
  • Developed Real-Time Information models to support SLT replicated tables from SAP ECC.
  • Created Variables, Input Parameters and Calculated/Restricted columns on Calculation Views.
  • Built Schemas, analytic privileges and granted permissions for BI users.
  • Identified expensive statements using HANA monitoring traces for performance optimization.
  • Transported objects by creating delivery units between SAP landscapes.
  • Performs manual tasks as required to implement solution in production.
  • Followed ETL and SAP BI Best practices to build and transport deployment groups between system landscapes.
  • Built universes on top of HANA information models for WEBi/Dashboard reports.
  • Customer Sales Analysis for Distribution Center andForward Deployed (Sales organization Drilldown, Business Unit Drilldown, Customer Type).
  • Customer Touches/ Visits Reporting (The purpose of this report is to allow Business Users to have transparency into the level and type of activity that is occurring with our customers, prospects and suspects. This can provide insight into how effective and frequent the marketing and sales activities are for different cross sections of the customer base).

Environment: SAP HANA 1.0(SP9), HANA Design Studio,SAP ECC 6.0, SAP BODS 4.2, SDA, SLT, SQL scripting, My SQL Workbench 6.3, Toad 12.6

SAP HANA/BODS Consultant

Confidential, St. Louis, MO

Responsibilities:

  • Established the best modeling and recommended strategies and architecture for SAP HANA.
  • BuildSAP, Non-SAP data flows to create information model for user consumption (Attribute View, Analytical View, and Calculation View.
  • Gathered and analyzed the requirement to replicate the ECC content in HANA using SAP Data services.
  • Worked on trigger based data replication for SAP ECC using SAP Landscape transformation (SLT).
  • Translates functional specifications into technical specifications.
  • Assists BI COE Team to define HANA Modeling standards and best practices, release management process, validation, and testing process
  • Ability to communicate effectively with end users and company executives.
  • Built HANA Information models (Attribute Views, Analytical Views, Calculation Views and Column based tables) in HANA design studio for efficient data integration.
  • Developed and imported SAP HANA optimized Infocube and DSO’s into SAP HANA environment and vice versa (mixed scenarios).
  • Developed Real-Time Information models to support SLT replicated tables from SAP ECC.
  • Creates Design documents for the HANA models.
  • Creates functional specifications.
  • Created Variables, Input Parameters and Calculated/Restricted columns on Calculation Views.
  • Built Schemas, analytic privileges and granted permissions for BI users.
  • Identified expensive statements using HANA monitoring traces for performance optimization.
  • Transported objects by creating delivery units between SAP landscapes.
  • DevelopedETL jobs with heavy transformations for data acquisition fromSAPECC and NonSAP systems using SAP BODS 4.0.
  • Built BODS jobs to load Customers data from SAP application tables for Ecolab’s various business units into HANA column-tables.
  • Performed Source and Target CDC techniques for efficient data loading.
  • Monitored, debugged and followed SAP BODS optimization techniques.
  • Imported Flat files using SAP HANA import wizard.
  • Performed trigger based data replication using SLT technique for SAP ECC SD, FI.
  • Involved in creating transformation in SLT for enhancing BP Role, BP Status and business required fields.
  • Integrated Microsoft Office toHANA reporting.
  • Worked on Tableau for ad-hoc reporting.
  • MicroStrategy dashboards were developed as per business logic.
  • Experience in reporting methodologies, scheduled delivery of reports, ad-hoc execution of reports, metadata, drill-downs/through, and HANA views and Composite model using HANA and/or BW.

Environment: SAP HANA 1.0(SP4), HANA Design Studio, SLT, SAP BODS 4.0, SAP R3 ECC 6.0, ABAP, CRM, Oracle DB, Toad

SAP BI/BODS Consultant

Confidential, Albany, GA

Responsibilities:

  • Full life cycle implementation, which involve Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
  • Analyzed and translated the client’s business requirements and functional specifications into technical specifications, data flow diagrams and data models
  • Worked closely with Business Users to understand business processes and functional specifications.
  • Conducted Gap analysis to determine enhancements in BI system.
  • Did sophisticated BI Data modeling and BI conceptual/logical/physical Design for enabling a new platform to fulfill reporting needs of the organization by following SAP recommended practices.
  • Designing and Development of the Business Information Warehouse and enhancing the Business Content InfoCubes and R/3 extractors using ABAP/4.
  • Activated Business Content for standard SD, MM InfoCubes, Info Sources and Info Objects and enhanced standard Business Content based on client requirements for Transaction, master and texts data
  • Extensively worked in Data modeling techniques like Transformations, DTP’S, Data migration, DSO and structuring the InfoCubes as per the requirements.
  • Developed InfoCubes for Account Receivables and Payment History. Created Sales Cube and Billing Cube for Sales Analysis.
  • Extracted data from FImodules of SAP R/3 and from flat files into SAP BI System.
  • Used DSO to stage the data before transferring the DSO contents to the InfoCube and worked extensively on Data Marts.
  • Used both initializations with Delta Update and Full Update methods depending on the business requirement.
  • Created and monitored various Process Chains, Managed and monitored data loads, job scheduling and updating DB Statistics regularly and rebuilding missing indexes for increasing the Query Response.
  • Identified required and key data points responsible for Data Warehousing.
  • Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
  • Involved in Performance tuning and bottleneck resolution.
  • Used Error handling strategy for trapping errors in a mapping and sending errors to log table.
  • Assigned tolerance levels to individual data points and automated quality assurance checks.
  • Involved in creation of universe, classes, objects, created joins and contexts.
  • Involved in creating client reports as per the user requirements by using the Formulas, Master/Detail, Cross Tabs, Slice and Dice, Drill up and Drill Down.
  • Built knowledge and executed the project in agile development methodology.
  • Involved in the Unit testing and User Acceptance Testing (UAT) phases of the project.
  • Created classical and interactive reports using BEx Reports, Workbooks and Queries for the required Purchasing and Sales Order queries.
  • Extensively worked on Query building, filtering, free Characteristics, Restricted Key Figures and variables, Query variants using BEx Analyzer.
  • Created Conditions, Exceptions, Structures, and Variables to use them in BEx Reporting.
  • Used RRI (Report-Report Interface) in order to get detailed information about Sales orders.
  • Built BEx queries using Query Designer and setup Universes to integrate between BI and BO systems to deliver reports and KPIs.
  • Business Objects reports were created using WEBi with merging dimensions, sub query concepts applied.

Environment: SAP BW 7.1, SAP BW 3.5, SAP ECC 6.0, ABAP/4,, SAP BOXI 3.1, SAP Business Explorer (BEx), PL/SQL, FileMaker Pro 7, Windows 2003 server

SAP System Analyst

Confidential

Responsibilities:

 
  • Analyzed the user requirement for the data modeling and reporting requirement.
  • Designed the data model for the flat file extraction.
  • Involved in Finance Reporting and data modeling activities for FI-AR, FI-AP and FI-GL.
  • Gathering requirements for Finance reporting requirements with end users.
  • Worked on Accounts Receivable, Accounts Payable and General Ledger data modeling.
  • Worked on COPA Data extraction into BW for See through profitability project.
  • Extracted the data from the flat files to ODS and checked the performance of the ODS and reports.
  • Designed the reports as per the business requirement.
  • Involved in Unit Testing, Data Loading, Execute Workbooks, Integration Testing, User Acceptance Test.
  • Analyzed the user requirement for the data modeling and reporting requirement.
  • Participated inn Spend Procurement project for creating Spend tracking and supplier score card.
  • Worked on Finance reports as per user requirements.
  • Gathering requirements for Finance reporting requirements with end users.
  • Creating dash board and reports query as web services through crystal reports.
  • Created user required reports and user interactive reports through crystal reports.
  • Created Xcelsius dash board’s based on current fiscal year and previous fiscal period comparison for Profitability analysis.
  • Finance and Controlling (FI/CO) data analysis.
  • Design and configure the system to support the organization’s process vision, together with the technical team and Business Process Owners.
  • Resolving the issues related to different areas like Sales and Distribution, Material management, HR, Purchasing.
  • Resolved issues related to special processes such as regrinding, Credit & Re-bill, Sales order, Delivery, Billing, Pricing, tax conditions, purchase order, purchase requisition etc.
  • Resolved issues related to Account Determination
  • Resolved issues related to output determination and made enhancements to SAP scripts, output programs for output type by coordinating with technical team
  • Resolving issues related to Customer master and Material Master data such as creation, Extension, field value changes.
  • Business Warehouse Reporting tool(HP Corporate Financial Reporting Tool)
  • Accounting and reporting teams the right foundation to produce high-quality results using powerful management accounting tools.
  • Batch Job Input and Output Analysis
  • Problem analysis is supported by background job logs that record all messages issued by programs run in the background.
  • User Maintenance & Security Profiles.
  • Thoroughly involved in creation of Test Scenarios, Unit and Integration Testing and Documented the Results.
  • Transferring the Time management and Absences data of users, creation of HR master records in PA20.
  • Resolving incidents tickets raised by the users for Login, transaction authorization issues.
  • Analyzing P&L and providing detail usage of Result Analysis calculation.
  • Resolved Forecasting issues generate while planning.
  • User Acceptance testing.
  • Escalating the critical issues to next level or superiors to solve with in SLA.

We'd love your feedback!