SUMMARY:

• Over 9+ yearsof Data Warehouse/Business Intelligent Experience includes 3 years of extensive experience in SAPHANA - Data Modeling, Data Provisioning, and Reports development on various business domains like Financial, Healthcare and Manufacturing.
• Worked in 3 full life cycle implementation integrated planning, design, implementation and support of SAP HANA based solutions including Data Modeling, SAP ECC, SAP Data Services, SAP Business Warehouse (BW), and SAP BI/Business Objects in large and complex environments.
• Experience in SAP BO BI 4.0, 4.1 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.
• Strong experience in OLAP/OLTP Data Modeling using Entity Relationship, Multidimensional/Star Schema and Extended Star Schema models.
• 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.
• Developed Reports in SAP Business Objects BI 4.x/3.x using tools, BI launch Pad,Web Intelligence (Webi),infoview/launch pad, Crystal Report, Xcelsius/Crystal Dashboard Designer.
• Expertise in Data provisioning including BODS, SLT, DXC and Flat file.
• Worked on SAP Hana Security including user management, roles, and privileges
• Enterprise level hands on experience in providing actionable insights using statistics and machine-learning algorithm.
• Expertise in Data warehouse/data integration, statistical analysis and report building.
• Established guidelines for a defined database architecture and database builds.
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
• Extensively involved in Data load & Report Performancetuning 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.

TECHNICAL SKILLS

Operating Systems: Windows XP/7/8, Linux (Red Hat, SUSE)

Provisioning Tool: BODS, SLT, SSIS, Informatica, Attunity Replicate

Analysis Tools: SAP Hana Studio, Business intelligent development studio, R, Microsoft Excel spreadsheet

RDBMS/Data Warehouse: MS SQL Server 2012/2008/2005, PDW, SAP Hana, SAP BW Net-weaver 7.1, MS Access 2007/2010, MySQL 4.1/5.5, PostgreSQL, MongoDB.

Dashboard/Reporting tools: BOBI 4.1 (Web Intelligence, Crystal reports, Lumira, Dashboard), SSRS, PPS, Tabeau, MS Excel

Languages: T-SQL, SQL-Script, C #, Python, R, Java, XML, HTML, DHTML.

Web Technologies: ASP.Net, HTML 5, CSS 3, Ruby-on-rails, Node.JS

PROFESSIONAL EXPERIENCES

Confidential, Bellevue, WA

SAP BI-BW/BOBJ/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 IQto map data types from databases connected via SAP HANA Smart Data Access (SDA) 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 throughBODS.
• 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.
• Migrated HANA content from development, testing environment to Production environment using Delivery Units.
• Created multiple models in Hana such as model consisting of replicated SAP tables.
• 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 from SAP ECC.
• Created Variables, Input Parameters and Calculated/Restricted columns on Calculation Views.
• 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 between SAP landscapes.
• Develop ETL jobs with heavy transformations for data acquisition fromSAPECC and NonSAP systems.
• 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.
• Optimizing ABAP codes to be able to use HANA advantagein-memory.
• Review and change old design to better use in memory database technology.
• 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 viaSAPBW extractors (DXC) toHANAfrom EDW.
• Build universes on top of HANA information models for Webi/Dashboard reports.
• Worked on lifecycle management procedures for customizing and updating your SAP HANA platform and for managing SAP HANA content products & transports.
• 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, orders, settlement. 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(SP8, SP9), SAP BI BW 7.4, Informatica, SAP BOBI 4.1, SAP R3 ECC, ABAP, CRM, Oracle DB.

Confidential, Lake forest, IL

SAP HANA Consultant

Responsibilities:

• 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 BO 4.0, Visio, MS Office.

Confidential, Philadelphia, PA

SAP Universe/Web Intelligent/Lumira Consultant

Responsibilities:

• Created Universe on SAP Cubes, MultiProviders, BW Queries and exporting the universe to CMC
• Used functions like CustomHierarchy, DelegateSearch, CascadingListofValues, and Hiding Objects
• Creating OLAP Universe and resoling the loops by using aliases or contexts
• Created reports on Cube universe, Query Universe
• Used filters for filtering on Dimensions, Measures
• Used Prompts on the filtered objects
• Worked with Tables & Charts
• Used variable for creating formulas (like calculated Key figures & Restricted Key figures in SAP)

Environment: SAP BW BI 7.3, SAP HANA 1.0(SP8), Web Intelligent, Lumira

Confidential, Hartford, CT

SQL Business Intelligence Developer

Responsibilities:

• Transformed data from MS SQL Server 2000 to MS SQL Server 2005 using OLE DB connection by creating various SSIS packages.
• Used the Execute DTS 2000 package task to execute DTS packages.
• Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Designed a new schema for the Data Mart databases.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis.
• Created MDX queries to extract data from the Data Mart.
• Generated Dynamic reports from Cubes (SSAS) using SSRS-2005.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Created simple data entry applications using C#.Net 2005 and SQL 2005 Server.
• Used HTML code to make Report manager more functional & customizable.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

Environment: SQL Server SSIS/SSAS/SSRS, Visual Studio 2008/2012, Visio, MS Office.