PROFESSIONAL SUMMARY:

• Overall 8+ year experience as a senior SAP HANA consultant which includes data modelling, extraction and report creation and Technical Lead with Client facing roles and responsible for Technical Architecture
• Good Knowledge in Hana Database Architecture and strong understanding of different types of engines; SQL Engine, Calculation Engine, OLAP Engine, Join Engine and XS Engine.
• Experience in HANA Modelling and worked with Attribute, Analytic and Calculation views and strong understanding of when and where to use join types like Text, Left Outer, Right Outer, Referential and Inner.
• Worked with different Data Provisioning Techniques like SAP DS/BODS, SLT, SDA (Smart Data Access), DXC.
• Hands - on experience with Hana Studio - Modeler/Developer/Debug /Admin/Lifecycle/BW perspectives
• HANA security implemented through graphical ap creation, role, user to assign analytical privileges and archiving the historical data for large volumes of the data set.
• Fetched data from various Source systems viz. ECC6.0 (SD, MM, FI, PP, Inventory, HR, PM, CO, COPA, FI-CA, ISU-Utilities...Etc.). SAP EC Environment Compliance and EHSM-Environment, Health and Safety, BODS, Hyperion, Flat-file, SRM, CRM, SCM and SEM-IP modules.
• Experienced in designing and implementation of the Process Chains to automate the process of loading and scheduled the process chains Daily, Weekly, Monthly and Event Based.
• Experienced in Designing Bex Queries and created Calculated Key figures, Restricted Key Figures, Structures and Conditions.
• Conducted trainings in SAP BO/BI to end users, Business Owner and Report leads to enhance and improve reporting and analyzing skills for better decision making and help train users on self service capability of tools.
• In addition to being a positive, motivated and goal oriented person, I have the ability to work well in extreme pressure conditions. With excellent communication skills, I always maintain a gracious and professional manner when communicating with people.
• Knowledge in Implementing SD, MM (Purchasing, Inventory Management, Procurement), Production support & Maintenance Projects, Enhancement Projects.
• Involved in changing the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.
• Involved in creating Generic Extractors using Table and view.
• As part of Data Provider Layer, migrated data from SAP R/3 using LO, Business Content Extractors.
• Extensively worked in Business Information Warehouse Info Cubes, ODS Objects, Info sources, Info objects, Transfer rules, update rules, Extractors, Info sources, Info packages, Info objects Catalogs, Data sources, Data Extraction, Business Content, Data Marts, Process Chains.

TECHNICAL SKILLS:

SAP HANA: SP04, SAP BI 7.0, SAP BO 4.0, SAP BODS

Software Products:  SAP HANA Studio, SAP HANA Information Composer

Admin Tools  : SLT, SAP Data Services, Direct Extractor Connection, Flat file Uploader

Data Provision: Excel, SAP BO Analysis for Office, SAP BO office, SAP BO Analysis for OLAP, Business Reporting Object Explore.

Information Design tool : HANA SQL scripting, JavaScript

Language Tools  : SAP HANA Database, SQL 2005 and 2008

Programming Language: C, C++, and ABAP/4.

Data Warehouse: SAP HANA

E.R. P: SAP R/3, ECC 6.0.

Reporting Tools: SAP Lumira, SAP Design studio.

PROFESSIONAL EXPERIENCE:

Confidential, Virginia

Senior SAP HANA BODS Consultant

• Perform a assessment with the client on Performance optimization on existing model which has issues.
• Developed a SAP HANA modeling views for SAP ERP standard report for displaying Actual Cost Line Items for Cost Centers.
• Developed a SAP HANA modeling views for SAP ERP Cumulated Time Evaluation Results.
• Extensively worked on Calculation Views (Standard, Time and Derived) of both Graphical and Script.
• Creation of Hierarchies, Variables and Input parameters.
• Adopted parallel techniques/filter pushdown/variables/input parameters, Hierarchies in developing models to achieve the performance
• Working on HANA models optimization(Source) for long running reports.
• Develop a new model to implement the Single solution source of truth
• It involves IoT (Internet of things) along with SAP HANA SPS 10, XS ODATA, SAP BODS, and Migrating
• Entities from hdbtable to CDS.
• Involved in various aspect of the software development in HANA i.e. data modeling, Languages such as SQL Script, hdbtable syntax family (hdbview, hdbsequence,), Procedures, HANA XS ODATA, Database procedures, security management (user & role creation), bug fixing. I also have done data migration from
• MySQL to HANA using BODS. Basic administration knowledge (trace files, delivery units, export and import of HANA models, diagnosis files etc.)

Environment - SAP BW 7.5, HANA 1.0, EPM 10, APO EHP2 SCM 7.0, ECC 6.0, Micro strategy

Confidential

SAP HANA

Responsibilities:

• Work across business/technology teams to ensure alignment between business solution definition & technical
• architecture to meet project requirements on Procurement, Inventory Management and Finance, Plant &
• Maintenance, Sales & distribution, fixed gaps on every application to meet customer reporting requirements.
• Designed and implemented SAP HANA data modelling technics using Attribute View, Analytic View, and Calculation Views.
• Instrumental in standardizing the Implementation process in data modelling in sap HANA from ERP
• Involved in SAP HANA Security including User Management, Roles, and Privileges using Life cycle management.

Environment - SAP BODS, HANA 1.0, SLT, NLS, BO 4.0, ECC 6.0, Spot fire, BPC

Confidential, Louisiana

Senior SAP HANA modeling and consultant

Responsibilities:

• Working on all the modeling activities creating attribute views, analytic views, and calculation views.
• Worked extensively on design of the module being undertaken.
• Worked on data provisioning and ETL based replication of data.
• Worked on real time replication technique using SLT replication server.
• Worked on creating analytic privileges and other privileges thus implementing security management
• Worked on advanced modeling features like restricted columns, calculated columns, filters, variables and input parameters.
• User management and security.
• Created External Views.
• Created Database Procedure Proxy’s.

Confidential, Santa Ana, CA

SQL Server Developer

Responsibilities:

• Extracted, transformed and loaded data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created Tables, Stored procedures, and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Provided Full Reporting Life Cycle support using SSRS 2008R2.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill-down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at the report level.
• Created linked, unlinked and on-demand sub Reports.
• Understood the various complex reporting requirements of the company and created web reports using Reporting Services.
• Developed Tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.

Confidential

UNIX & SQL/PLSQL Developer

Responsibilities:

• Involved in resolving, managing issues related to database. Root cause analysis of the issue and providing the permanent solution for the repeated issue which involves code change in DB.
• Written many automated shell scripts.
• Involved in release management.
• Created database triggers to implement and enforce data integrity and security.
• Involved in quality related activities.
• Involved in knowledge management and mentoring team member.
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL languages.