PROFESSIONAL SUMMARY:

• 8+ years of IT techno - functional experience 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 Certified SAP HANA Modeler.
• Extensively Worked on SAP HANA Modeler (HANA Design Studio), Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytic Privileges, Stored Procedures and CE Functions.
• Exceptional record of delivering effectiveness, in design, development and implementation of business applications as Techno Functional consultant.
• 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, 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/5.0, BOBJ 4.0 and BOXI R3.1.
• Extensive experience of SAP BW/BI components like HANA in-memory optimized and Standard InfoCubes, DSO’s, InfoObjects, MultiProviders, DataSource, InfoSets, Virtual Providers, SPO, Hierarchies, Start/End/Transfer Routines, Open Hubs, Transformations, Transient Providers, Composite Providers, IDocs, User Exits.
• Good Understanding of standard SAP modules. (FI/CO, SD, MM, PP, HR).
• Strong experience in OLAP/OLTP Data Modeling using Entity Relationship, Multidimensional/Star Schema and Extended Star Schema models. Strong knowledge of SAP BW architecture and BW data model.
• Designing the data flows to load the data from non-SAP source systems to SAP HANA.
• Building complex ETL Dataflows/Jobs in SAP Business Object Data Services 4.x and in Informatica Power Center 9.x by 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.
• 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 datasources.
• Expertise in DataSource Enhancement, Loading (Full/Delta Up-Load), Monitoring, Data Mart and Open Hub Service and BW Transports.
• Expertise in creating and maintaining Process Chains and Meta Chains for automating data loads.
• Experience in building OLAP connections, Universes and creating reports using Business Objects & 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: SAP NetWeaver BW 7.3, BI 7.0, BW 3.5

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

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

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

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

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

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

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

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

Testing: HP Quality Center

Project Methodologies: ASAP, Agile/Scrum

Others: Analysis Process Designer(APD), Informatica PowerExchange 9.5, BWA, JavaScript, XMLMS Office 2010, TOAD

PROFESSIONAL EXPERIENCE

SAP HANA/BODS/BI Consultant

Confidential, San Diego CA

Responsibilities:

• Involved in analyzing and designing ECC 6.0 to BI 7.3 Data Flow and responsible for the deployment solutions for FI-AP, GL and HR data extraction, IT Capital Projects Budget Analysis Reports, Version Comparison and IT Capital Dashboard.
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Leverage SAP SLT and Business Object Data Services (BODS) to acquire the data into SAP HANA Data Mart.
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA 1.0 (SP6).
• Configured BODS ETL jobs in data services to call process chain in BW to send data toSAPHANA.
• Resolved issues related with delta loads toSAPHANAvia data services.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating informationInvolved in Monitoring and troubleshooting data loads.
• Created Technical specifications and standard modeling documents for SAP HANA dataflows.
• Performed user training sessions for SAP HANA Information Models.
• Build complex BODS jobs to perform full/delta loads using Source/Target CDC techniques from SAP ECC to corresponding SAP HANA tables.
• Created complex transformation’s in BODS dataflows as per modeling requirements.
• Loaded SAP ECC tables using SAP SLT data replication.
• Performed SLT transformations and enhanced tables with missing fields.
• Performed data loads via SAP BW extractors (DXC) to HANA from legacy BW.
• Extracted Data from FI sources like Accounts Payable, General Ledger(GL) and enhanced Standard data sources like 0FI GL 4, 0FI AP 4, to meet the client's requirements.
• Worked with Production Support team to solve issues like failure due to invalid characters, data inconsistency and job failures.
• 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.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Build BO universes on top of HANA calculation views and developed Webi reports and dashboard reports using IDT.
• Established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Created Project Actuals and Planning reports based on HANA models.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.

Environment: SAP BW BI 7.3(SPS6), SAP HANA 1.0(SP6), SAP R3 ECC 6.0, CRM 7.0, FI, HR, SAP BEx Explorer 7.x, SAP BO 4.0,Visio, MS Office

SAP HANA /BW/BO Consultant

Confidential, Saint Paul, MN

Responsibilities:

• Gathered and analyzed the requirement to replicate the ECC content in 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 PowerExchange 9.5.1 with SAP HANA 1.0 (SP7).
• Worked on trigger based data replication for SAP ECC using SAP Landscape transformation (SLT).
• BuildSAP FI, SD data to build information model for user consumption (Attribute View, Analytical View, and Calculation View.
• Develop ETL jobs with heavy transformations for data acquisition fromSAPECC and NonSAP systems.
• Build Informatica mappings to load Customers data from SAP BW application tables for Confidential ’s various business units into HANA column-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 viaSAPBW extractors (DXC ) toHANAfrom EDW.
• Build HANA Information models (Attribute Views, Analytical Views, Calculation Views and Column/Row based tables) in HANA design studio for efficient data integration.
• Build and imported SAP HANA optimized Infocube’s and DSO’s into SAP HANA environment.
• Created SQL script based Calculation Views using CE functions.
• Developed Real-Time Information models to support SLT replicated tables from SAP ECC.
• Created Variables, Input Parameters and Calculated/Restricted columns on Calculation Views.
• 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.
• Followed Informatica and SAP BI Best practices to build and transport deployment groups between system landscapes.
• Integrated Microsoft Office toHANA reporting.
• 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).

Environment: SAP HANA 1.0(SP7), SAP BI BW 7.4, Informatica PowerCenter 9.5 (HF2), SAP BOBI 4.1, SAP R3 ECC, ABAP, CRM, Oracle DB, Mainframe, UC4 job scheduling, Unix Shell scripts.

Business Intelligence Consultant

Confidential, Pleasanton CA

Responsibilities:

• Full life cycle implementation, which involve Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Created Standard and in-memory optimized BI objects like InfoObjects, DSO’s, InfoCubes, Multiprovider, DataSources, Infosets, InfoSource, InfoPackage, Data Marts and Open Hubs.
• Developed Transformations, DTPs, Start/End routines, User Exits using ABAP/4 to incorporate Business logic and perform data manipulation.
• Performed data loading from non-SAP/ECC tables with complex transformations via SAP Data Services (BODS) into SAP HANA tables with a mix of SLT replication.
• Extraction of AR, AP & GL data from transactional system to BI using standard FI extractors.
• Worked on 0FI GL C10 cube using data sources 0FI GL 10 for GL Balances.
• Developed Balances display report and Balances Comparison with previous year on cube 0FI GL C10.
• Implemented MultiProvider 0PY MC02 on HR for Personnel Management (PA), Payroll (PY) and Time Management (PT).
• Schedule, performance and monitored periodic data loads from R/3 to BW system, delta loading and DSO Loading process.
• Improved data loading performance by limiting data packet sizes, scheduling index deletion and rebuilding jobs as well as through ABAP tuning. As a result of these efforts data loads were conducted successfully within half the time.
• Creating and moving Transports from Development to Production using best practices.
• Building and enhancing BI objects that include Info Objects, DataSources, Transformations, DTP, DSO, InfoCubes, Multi-providers, InfoSet and Open Hub.
• DataSource Objects are created for staging for AP, AR line item data, multi cubes and Infosets are created to satisfy reporting requirements.
• Activation of the Business Content for Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA), General Ledger (GL), Human Resource (HR), Cost Center Accounting (CO-CA), CRM activity items cube and customizing them as per the client requirement.
• HANA information model design and build which includes Package, Attribute View, Analytic View, Calculation View and Schemas.
• Develop SQL scripts and functions for complex reusable scenarios in HANA.
• Worked on building Universes, retrieving data using Universes and creating reports using Business Objects and Web Intelligence Tools.
• Involved in entire Business Objects application suite and in design, development, testing and implementation of Webi, Xcelsius (Dashboards) and Crystal Reports on top of HANA models and legacy BW objects.
• Designing, reporting templates with Bex Analyzer and Web Analyzer using key figures, hierarchies, variables, properties, exceptions and conditions in the query definition.
• Worked on creating HR reports on Headcount, No of Personal actions and Change in Staffing Level.
• Created connections to the BEx queries in BW system through the BICS network layer in the Information design tool (IDT).
• Exported the universes to the Repository making resources available to the users.
• Extensively worked Query performance tuning and testing activities.
• Created ad-hoc reports on Web Intelligence (WEBi) and Desktop Intelligence.
• Involved in documentation and end-user training, Testing, OSS notes, Quality assurance of the data present.

Environment: SAP Business Objects 4.0, SAP BW BI 7.3 (SP6), SAP HANA 1.0 (SP4), SAP BODS 4.0, Oracle 10g, PL/SQL, Xcelcius, Windows 7

BI Analyst

Confidential, Washington D.C

Responsibilities:

• 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.Modeling:
• 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.
• Designed the ETL processes and mappings using Informatica Power center 8.1.0 to load data from MS SQL Server, FileMaker Pro and Excel spreadsheet into the target Oracle database.ETL:
• Developed InfoCubes for Account Receivables and Payment History. Created Sales Cube and Billing Cube for Sales Analysis.
• Extracted data from FI modules of SAP R/3 and from flat files into SAP BI System.
• Performed LO-Cockpit extraction Setup of Sales and Distribution datasources like 2LIS 11 VAITM, 2LIS 11VASCL and 2LIS 11 VAHDR.
• Loaded data into standard Info-cubes 0FIAP C03 and 0FIAR C03 using ODS objects 0FI AP O03 and 0FI AR O03. Enhanced the 0FI AP 4 datasources.
• 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.
• Web Data Extraction and Integration was performed by third party tool Kapow Katalyst 7.2.
• 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.
• Build 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.3, SAP BW 3.5, SAP ECC 6.0, ABAP/4, Informatica Power Center 8.1.0, Kapow Katalyst 7.x, SAP BOXI 3.1, SAP Business Explorer (BEx), PL/SQL, FileMaker Pro 7, Windows 2000 server

Programmer Analyst

Confidential

Responsibilities:

• Analyzed the business requirements and translated into dimensional data models.
• Responsible for design, development and extraction of data from R/3 Source system (SD, MM, PP, FI) and Flat files to the BW system.
• Created BW objects like InfoObjects, InfoCubes, InfoSources, ODS, Update/Transfer rules, InfoPackage.
• Used ODS to stage data before transferring the ODS contents to the relevant InfoCubes.
• Worked on Performance tuning like Compression, Aggregates, Partitioning, Indices and Line item Dimension.
• Tailored transfer structures, communication structures and update rules based on the requirements and scheduled the InfoPackages for data loads.
• Developed, scheduled and managed process chains.
• Built BEx queries using Calculated and Restricted Key Figures, structures, variables to enhance the reporting features. Implemented conditions and restrictions in the reports based on the requirements.
• Used Hierarchies in the reporting to provide drill down features. Designed and developed reports with filters and free characteristics.
• Wrote reports in SD Open sales Order report, which covers all organization levels, delivery status, shipping figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Worked in customizing web templates on Web Application Designer(WAD) and published reports on web.
• Involved in escalating high-prioritized tickets regarding extractions, Performance Issues and also load failures.
• Transported the objects from Development to QA for testing.

Environment: SAP BW 3.5, SAP R/3 4.7, ECC 5.0, SAP Business Explorer (BEx), MS SQL Server, Windows NT