SUMMARY

• Overall 9 years of IT functional experience with noledge in Implementation, Upgrade and Support in SAP BI/BW/BODS/HANA. Over 2 years of extensive experience in SAP HANA - Data Modeling, data provisioning, Reports development and SAP HANA Modeler.
• Extensively worked on SAP HANA Modeler (HANA Design studio), Designing Schemas, and Creating Packages, Attribute View, Analytical View, Calculation view, Analytic Privileges, Stored Procedures, CE functions and a model consisting of replicated SAP tables.
• Solid understanding of HANA functional architecture/Infrastructure.
• Strong expertise in SAP HANA Data Provisioning/Replication techniques like SLT, SAP BODS 4.0/4.1 and Direct extractor connection (DXC)
• Experience in SAP BOBI 4.0, 4.1 building Universes, Dashboards, and WEBi Reports by extracting data from HANA information Views, BEx Queries and SAP BW cubes.
• Expertise in SAP BI/BW 7.3, 7.1, 3.5 with SAP R/3 (ECC) 6.0, BOBJ 4.0 and BOXI R3.1.
• Extensive experience of SAP BW/BI components like HANA in-memory optimized InfoCubes, DSO’s, Info Objects, Multi Providers, Data Source, Info Sets, Virtual Providers, SPO Hierarchies, Start/End/Transfer Routines, Open Hubs, Transformations, IDocs, and User Exits.
• Strong experience in OLAP/OLTP Data Modeling using Entity Relationship, Multidimensional/Star Schema and Extended Star Schema models. Strong noledge of SAP BW architecture and BW data model. Understanding of standard SAP modules (FI/CO, SD, MM, PP, HR).
• Designing the data flows to load the data from non-SAP source systems to SAP HANA.
• Building complex ETL Data flows/jobs in SAP Business Objects Data Services 4.x implementing Source/Target CDC and Extracting SAP standard business extractors from SAP ERP systems.
• Good understanding of SAP HANA user management and security.
• 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 4.0 and integrating BO with BI and HANA.
• Worked closely with SAP BPC module for planning and budgeting for around 1 year.
• Experience in SAP BO BI 4.0 and integrating BO with BI and HANA.
• 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.
• Worked on BEx Reports providing insight of business Intelligence for Business Analyst for decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure, RRI Jumps and Variables with User Entry/Default value, Replacement Path and Customer Exit.
• 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 extraction from Flat files, SAP data marts, Non SAP data sources.
• Handles on experience on SAP BI, BOBJ and Hana security for around 3 years.
• Expertise in Data Source Enhancements, loading (Full/Delta Up-load), Monitoring, Data Mart and Open Hub Services and BW Transports.
• Expertise in creating and maintaining Process Chains and Meta Chains for automatic data loads.
• Good understanding in extracting maximum value from Big data by combining the in-memory processing power of SAP HANA with Hadoop’s ability to store and process huge amounts of data regardless of structure.
• Experience in building OLAP connections, Universes and creating reports using Business Objects and Web intelligence Tools.
• Experience with Non-SAP ETL tools like Informatica power center and Data integration tools.
• Handling of the production support tickets and resolving them as per the ticket priority and transporting them into quality and production environments.
• Enabled Single Sign On (SSO) feature, imported SAP BI roles into Business Objects, enabled automatic imports of SAP BI users, managed users, applications, security, Universe management, groups in Central Management Console (CMC).
• Worked with LCM (Life Cycle Management Console) to Transport the objects in System Landscape (Dev, QA, and Prod).
• 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, Toad, SQL*Plus, SQL Navigator, PL/SQL and oracle DBMS Packages.
• Excellent communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS

Data Warehousing: SAT NetWeaver BW 7.3, BI 7.0, BW 3.5

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

Functional Modules: FICO, SD, MM, PP, WMS, HR, CRM, SRM

Data Replication, ETL: SAP BODS 4.x, SLT, Kapow Katalyst 7.x/8.x

Business Modeling: HANA Design Studio, Data services Workbench, Data Warehousing Work bench (RSA1), Universe designing for BOXI (UDT), Information Design Tool (IDT)

Programming: ABAP for BI, Java, C#, C, OOP, PL/SQL

Databases: SAP HANA, Oracle 10g/9i/8i, MS SQL 200, MS Access, MySQL 5.x

Project Methodologies: Agile/Scrum/Kanban - biweekly Sprints, WIP limits.

PROFESSIONAL EXPERIENCE

Confidential, Lake Forest, IL

SAP HANA Consultant

Responsibilities:

• Gathered and analyze the requirement to replicate the ECC content to HANA using data provisioning
• Created blueprint for Technical/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.
• Established the best modeling and recommended strategies and architecture for SAP HANA.
• Integrated BOBI 4.1 and Informatica using Power Exchange 9.5.1 with SAP HANA 1.0 (SP7).
• Worked on trigger based data replication for SAP ECC using SAP Landscape transformation (SLT)
• Build SAP FI, SD data to build information model for user consumption (Attribute view, Analytical view and Calculation view).
• Created multiple models in HANA such as model consisting of replicated SAP tables VBAK, VBAP, VBUP and VBUK.
• RESTful service design and development using either JSON or XML.
• Build HANA information models (Attribute views, Analytical views, Calculation views, and Column/Row based tables) in HANA design studio for efficient data integration.
• Developed Real-Time Information models to support SLT replicated tables for SAP ECC.
• Created SQL script based Calculation views using CE functions.
• Build 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 HANA monitoring traces for performance optimization.
• Worked on SAP Hana security and analytical privileges for user access to different reports.
• Transported objects by creating delivery units between SAP landscapes.
• Developed ETL jobs with heavy transformations for data acquisition for SAP ECC and Non SAP systems.
• Build Informatica mappings to load Customers data from SAP BW application tables for various business units into HANA tables.
• 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).
• 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).

Confidential, King of Prussia, PA

SAP HANA Consultant

Responsibilities:

• Involved in HANA POC to validate the Master Data and Transaction data Tables with multiple Analytical view, Attribute View, Calculation View, Restricted Measures and Calculated Measures.
• Created analytic and complex calculation views using SAP HANA modeler.
• Experience in SAP HANA data modeling using attribute view, analytical view and Calculation view.
• Worked on SAP HANA data provisioning using SAP LT replication server (SLT) and data server.
• Worked on SAP HANA provisioning, Delivery units and schema mapping.
• Worked on reporting techniques such as creating calculation views, managing attributes mappings, creating analytic privileges, adding variables, using system-generating joins.
• Created information Model in SAP HANA and created reports in BOBI 4.0 for Sales and distribution modules towards Comparative Analysis for Actual Sales and Planned Sales
• Worked on Data Replication using BODS 4.0.
• Synchronizing Planning Info Providers within the BW PCA Copy Methodology.
• Execute migration from traditional DWH to HANA.
• Experience implementing Rapid deployment solutions and modify HANA models.
• Worked on Information Model Designing using HANA Studio.
• Created Attribute, Analytical and Calculated views in HANA.
• Created roles and assigned them to users of HANA.
• Stored data in columnar and row store in Database.
• Created multiple Graphical Calculation Views including Projections, Joins and Unions
• Worked on Catalog schemas with System Tables, Content Packages and Roles in the Security Folder.
• Worked on SAP HANA Data Provisioning, Delivery Units and Schema Mapping.
• Review QA deliverables of the team.
• Involved in BW system administration tasks.
• Experience in Creating and executing Data Service Job in SAP BODS to populate HANA.

Confidential, High Point, NC

SAP BI/BW Consultant

Responsibilities:

• Worked extensively on Bex Queries. Created new reports using existing SIS report templates.
• Was involved in development, testing and production of the reports.
• Created email broadcasting settings for all the agents’ reports (reports being distributed to different agents, based on their agent id).
• Created web templates for the required queries and published in their respective portals.
• Worked with the users to make sure all the reporting requirements are met.
• Created ad-hoc reports.
• Generated various queries using SAP BI query analyzer.
• Created reports in the Bex analyzer using concepts like Inception-to-date, year-to-date and month-to-date.
• Worked on the documentation related to the report broadcasting and web templates.
• Worked on ETL (Extraction, Transformation, Loading).
• Activated the Logistic Cockpit Data sources in SAP ECC 6.0 System.
• Enhanced the SD data sources and written the user exit for enhanced fields.
• Created the Generic data source (Sales order partner functions) using Function module (with delta update method).
• Developed the True history Application based on Sales order items (2LIS 11 VAITM).
• Developed Revenue equipment tracking application using Sales orders

Confidential, Woodland, TX

SA BI/BOBJ Consultant

Responsibilities:

• Worked extensively on LO-COCKPIT for loading data into the Standard Cubes.
• Monitoring the Roll-ups and Compressions while loading the data into the Info cubes.
• Base work for the performance tuning which includes fact table partitioning, PSA partitioning.
• Scheduled the data packet size in SAP R/3 according the business requirements.
• Scheduled and monitored periodic data loads from R/3 to BW.
• Monitoring the errors and handling them manually when needed.
• Extensively worked on Design and Development of Cubes, ODS objects, Info objects, multi-providers, Data-sources and Info-sets for reporting on Sales Order Data, Purchase Contracts, and inventory management
• Involved in Partitioning and partitioning cubes to improve performance.
• Developed web based queries for the users within the intranet, used HTML for customizing the reports.
• Extensively worked on fine-tuning of the reports, used various tuning techniques which include building aggregates, Routines, Function modules and also data distribution.
• Developed flexible queries using navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Used ODS to stage the data before transferring the ODS contents to the Info cubes.
• Developed ODS report to give details of delivery items and schedule line items.
• Changing of existing queries to suit the client requirements.

Confidential

SAP BI/BOBJ Consultant

Responsibilities:

• Transported the FI objects 3.1c to BI system and merging with the standard Business content object.
• Involved in the BI 7.0 implementation as part of their ECC 6.0 implementation project
• Involve in Implement of Open Hub features to distribute data from BW to external data marts, analytical applications and other applications
• Involved in Implement new BW 7 Statistics - to both provide the usage statistics as well as to auto-tune the system. Involved in the BWA built on the production system.
• Involved in creating the transformations, mapping the Objects, created start routines and End Routines
• Involved in cube compression, Partitioning, Indexing and Number range buffering its increases performance loading and Reporting performance
• Maintaining Reconciliation’s to verify the Data in SAP R/3 and SAP
• BW are same or not after the Data Loads and prepare test cases compare R/3 values with BW.
• Involved in creating, Planning Area, Planning level, Planning package, Planning functions, Planning groups, Planning layouts and Global Planning sequences.

Confidential, Carlsbad, CA

SAP BI/BOBJ Consultant 

Responsibilities:

• Used Process Chains to schedule data loads from SAP SD, MM and HR to BW.
• Created and activated ODS, Info Cubes, Info Sets, Multi-Providers, Transformations and DTPs.
• Created ODS for incoming sales orders according to sales organization, distribution channels, ship-to-party customers, materials and vendor line items etc.
• Uploaded master data and transactional data from SAP SD, MM, and HR via data staging to Data Source, ODS and Info Cubes.
• SD - Order, Delivery Billing and Overview; COPA - Creating DataMarts across COPA Cube in EU and US across Sales Orders, Production Costs and Production Order Settlements
• Developed Transfer rules, update rules& worked on update routines.
• Created Data marts for DP and SNP APO system loads.
• Open hub destinations for billing data to SAAS systems. Custom transformation for the SAAS customer numbers and product categories.
• Created Info packages to load the data and schedule background jobs.
• Created Aggregates, Compressed Info Cubes, Updating DB Statistics Regularly and rebuilding missing indexes for increasing the Query Response.
• Designed and developed process chains for master data loads and transaction data loads with the halp of Info Packages.
• Created and enhanced User exits on R/3 and BW.
• Configured use of restricted key figures, variables and calculated key figures in queries.
• Maintain Generic Data sources with Delta capability and Extraction checking of the Data source through Extract checker.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Developed reports using BEx Analyzer and Web Application Designer (WAD).
• Developed flexible queries using Variables, Filters, Free Characteristics, Conditions and Exceptions in BEx Query Designer to facilitate data analysis.
• Performed various tuning techniques (aggregates, compression and partitioning) to optimize the query and data load performance.
• Uploaded Transaction Data from the Flat File as the Source System.
• Involved in the documentation for SAP BI NW 7.3 upgrade and follow-up activities in BW perspective.
• Reviewed and validated the inconsistencies in info objects for pre upgrade process.
• Involved in Testing and validating the post upgrade activities and make the documentation.
• Exported selective data from an infocube to csv file by creating an infospoke, using the open hub service mechanism.
• Uploaded Transaction Data from the Flat File as the Source System.