SUMMARY:

• Having around 10+ Years of Experience in SAP BW7.5 on HANA, SAP BI4.2, SAP HANA Studio, and SAP BODS.
• Completed three full life cycle Implementations on SAP BW/BI, Two end to end developments on SAP BI/BO, Worked on BW7.5 on HANA Upgradation project from BW7.3, Created Design Studio dashboards backend BEx query and one implementation on SAP HANA with BODS extraction. Including Requirements gathering, GAP analysis, Business Requirement documentation & Business Blueprint, POC, getting client approvals, Go - Live and Production support. Good exposure with ASAP Methodology. Worked on two support projects in SAP BI 7.0 and BOXI R/2.
• Having work experience on different technologies and versions like, SAP BW 3.x, BI 7.0, BW 7.3, BW 7.5, BOXI R/2, BOBJ 3.1, SAP BI 4.0, SAP BI4.2, SAP HANA 1.5 and SAP BODS 4.0.
• Having the work experience in using Business Objects Suite products like Design Studio, Analysis for Office, Lumira2.0, Web Intelligence, Performance Management, CCM, and CMC.
• Worked on SAP Analytics Cloud on premise data sources HANA and BW
• Having an exposure on SAP BPC, SAP BW4/HANA
• Extensive experience with SAP BW administration using the BW Administrator Workbench, installing Standard Business Content objects, customizing SBC objects, custom data warehouse development, managing ETL jobs, troubleshooting failed processes.
• Hands on knowledge about BW7.5 Modeling tool objects Info Objects maintenance, Composite Provider, Advanced DSO, HANA Analysis Process etc
• Expertise in Netweaver Business Information Warehouse Components such as Transformations, DTPs, DSOs, Start routines, end routines, process chains in Data warehouse Workbench and new features like Real-time data acquisition. Temporary data storage, Error DTP, Enhanced filtering in DTP, Enhanced monitoring.
• Extractions: LO, FI, Master data extraction, Generic Extraction, Delta management, Business Content (Installation & Enhancement), extraction using DB connect.
• Excellent skills to work with Flat File Extraction, BI Content Data Sources and extraction models including Full and Delta updates.
• Good knowledge of developing query objects including restricted key figures, calculated key figures, user entry variables, replacement path variables, customer exit variables, SAP exit variables, and authorization variables.
• Expertise in Performance tuning in evaluating the statistical performance using BW Statistics and suggested recommendations to Basis support for optimization. Improved data load and query performance by doing Compression, creating Aggregates, Rollups, Partitioning, Indexes, and Data packet size.
• Excellent working knowledge of data warehouse concepts and extensive experience in BW Architecture, Extended Star-Schema, Multi-Dimensional Modeling, Data Flow Strategy, Defining ODS, Open Hub Service (OHS), Info Spoke.
• Expertise in Automation of BW jobs - scheduling/monitoring, Process Chains - Creation & Maintenance.
• Expertise in BEx Analyzer, Query Designer, Web Application Designer, Info-Set queries. Experience with Front-end Business Warehouse Components, which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures. Expertise in publishing queries to web portals through Web Analyzer.
• Extensive experience in support, Data loads, Validation and trouble shooting of transaction data, Master Data, Transport Management, Roles & Security System Checks, Performance tuning and process chains.
• Industry Experience: Pharmacy, Financial, Manufacturing, and Home Appliances.
• Hands-on experience in using Business Objects Suite products like Design Studio, Analysis for Office, OLAP for Office, Lumira, Web Intelligence, Crystal Reports, Performance Management, Import Wizard, Export Wizard, CCM, CMC
• Knowledge on BOBI 4.2 & BI Launchpad
• Dashboard development based on BW query as back end source
• Experience in handling CMC functions - Creation of new users, Groups, Folders, Checking Licenses availability, Monitoring Services running, Instances, and memory maintenance
• Capable of preparing suitable tool matrices based on client requirements
• Experience in BOBJ repository creation and maintaining security
• Extended knowledge on the BOXI, BI versions and tools support databases and operating systems.
• Expertise in using Universe Designer and Information Design Tool IDT over BEx queries and Info Cubes to migrate & model data from BI to BO for reporting. Excellent skills to develop reports using WEBI 4.0 and Crystal Reports
• Strong Knowledge in creating Dashboards using Design Studio and Lumira, informative workbooks using Analysis for office2.3
• Experience on Web Intelligence reporting - Filters, Conditions, Multiple tabs in a report, Dynamic or Static Prompts, Deriving Hierarchy levels, Exporting report, and design the report with suitable colors and Logo.
• Experience in creating Design Studio Dashboard - Scorecard component for highly formatted tables, Container Components, Analysis components like Charts, Custom CSS file, Script Objects and formatter functions and deploy and optimize applications on mobile devices.
• Extensive hands on knowledge on Analysis for Office reporting- Creating multiple sheets on multiproviders for different data cuts, data formatting for structured/unstructured report, Background filters, Prompt settings, Charts preparation, Conditions, template design, scheduling workbooks from CMC.
• Exposure in Creating Crystal Reports - Formula Fields, Parameters, Special Fields, Headings at Page level, Report level, Group level, Calculating Group totals and grand totals, Adjusting fields sizes and width.
• Exposure in installation, configuration, and migration of Business Objects XI R3 using CCM, CMC and Infoview.
• Having exposure with SAP BI Universe design
• Hands: on experience in using Business Objects Data Services Suite products like Designer, Repository, Engine, and Administrator.
• Experience in creating the repositories like central and local.
• Maintaining the matrices of memory allocations.
• Testing the connectivity, Dimensional model design, Creation of Jobs, Work flows, Data Flows.
• Experience in using Query options.
• Expertise in using of different Transformations. And setting Break points, Filters.
• Knowledge in using functions, Variables, Parameters, and writing scripts using functions.
• Knowledge in Recovery Mechanisms and Error Handling mechanism.
• Exposure in SAP ERP-IDOC Data Extraction & IDOC Data Loading, SAP BW Source and SAP BW Target Data stores, SAP ERP-Getting RFC enabled Functions Modules.
• Exposure in BODS Objects Migration, Performance Tuning Techniques.
• Good knowledge of SAP HANA modeling, Data Provisioning, Partitioning, Security and Reporting
• In: depth knowledge and experience with information modeling objects like packages, attributes, analytic and calculation views etc
• Strong understanding and working knowledge of SAP HANA Data Provisioning methodologies
• Expertise in data model objects flow like Schemas, tables, views, Functions, Join conditions, Procedures etc., in SAP HANA Modeling
• Extended knowledge on multi: dimensional design using views
• Strong understanding and working knowledge of SQL and CE (Build-in) usage in SAP HANA Modeling
• Strong understanding and knowledge of SLT (Real-time) Data Replication from SAP Systems
• Expertise with Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services 4.0
• Knowledge in connections establishment with different sources systems( SQL Server, DB2, SAP BW, etc.,) using SAP Data Services 4.0
• Responsible for developing high performance data extracts

TECHNICAL SKILLS:

SAP Technologies: Business Objects XI R/2, 3.x, SAP BI 4.x, SAP BW 3.x, BI 7.0, 7.3, SAP BW on HANA 7.5, SAP Business Objects Data Services 4.0, SAP HANA 1.0 SPS5

Function Modules: FI, FM, Retail, MM, SD, HR, CO-PA, PS

Reporting Tools: SAP BEx, Crystal Reports 2008, 2010, Web Intelligence, Design Studio1.6, Analysis for Office2.3

Operating Systems: Windows 98/2000, Windows NT, UNIX

Languages: SAP ABAP, C, C++, SQL Script Language

Database: Oracle 7.x/8.0/8i/9i/10, SQL Server 2000/2003, MS-Access 2000, HANA 1.0

PROFESSIONAL EXPERIENCE:

Confidential, Piscataway, NJ

SAP BW/BI/HANA Sr.Consultant

Responsibilities:

• Implemented Daily board, Smart sales overview, Smart Scorecard, Price Waterfall model, Wholesale OpenQty Quotation report, Inventory walkthrough reports, Material Management, Sales, BIlling and Shipping reports
• Assisted SAP Basis team in installing SAP BW7.5 on HANA and solely integrated it with Business Objects 4.1 and BPC 4.1
• Established the best modeling and recommended strategies for BOBJ environment and architecture for SAP HANA.
• Involved in Upgradation of BOBJ4.2 and configured WindowsAD authentication for Business objects SSO access
• Created Technical specifications and standard modeling documents on new features of SAP BW7.5.
• Worked on various Java sdk scripts to configure authentications, SSO, and web servers for SAP BW7.5, and BOBJ4.2
• Prepared executive task documents on Upgrade like Cutover activities, system testing, reports testing, after and before image, issues and resolutions ect.,
• Worked on upgrade tasks like Cubes optimization, Custom exit code change, System fields installation, Discontinued features adjustments, Source system connectivity issues ect.,
• Developed different modeling objects like Composite Providers, Multiprovider, Advanced DSO, Classical DSO, Cube, Transformations rules, HANA Analysis Process, Open Hub Destination, DTP, Info Package, Datasource, info objects, Process chain, Report schedule
• Worked on BW modeling tools installation. Maintaining infoobject changes, creating composite providers, advanced DSO from BWM tool
• Worked on performance optimization features like using advanced DSO, Composite Provider, Query Execution mode, Cache mode settings, aggregates, partitioning ect.,
• Worked on different data execration methods like file based, application file based, ECC extractors, custom extractors and worked on datasource enhancements based on business requirement
• Created BEx reports for different business departments like sales, backlogs, shipments, stock management, HR. Used to create CKF, RKF, Structures, selections and knowledge on currency conversion settings, exceptional aggregate settings and variables creation.
• Created multiple work books and scheduled for multiple sales reps based on authorization objects
• Created daily sales dashboard, Predictive forecasting reports in SAC
• Developed Dashboards for different operations and finance KPI’S like Gross Orders, Gross Shipments, Forecast, Projected goods, Top materials, Top Customers, Open orders, Projects. Used custom CSS code for different Analytic components like charts, Filter Panel, Geo Map Ect.,
• Developed region level sales, invoices and cancelations dashboard using Geo Map, scorecard, and chart type picker with live numbers.
• Created webi reports for yearly, monthly, and Daily trend charts. Day to day open orders, Actuals vs projection reporting, Inventory Walkthru reports, CRM Opportunity reports, Project Quotation, Installer shipment, Items Packed reports Ect.,
• Created Analysis for office workbooks on BW infoproviders and BEx reports. Extensive knowledge on maintaining number of worksheets for multiple data splits, High level formatting for structured report, standard template creation, creating custom style rules, Charts creation, saving and broadcasting from BI environment.
• Visiting plants and Interacting with business users, Sales reps on report requirements preparation
• Giving web sessions about BI mobile application installation, dashboard access, new reporting tools and technologies introduced
• Prepared technical and functional specification documents on developments
• Conducted sessions for users on Analysis for Office and Webi reporting
• Build root map on collaborative reporting of Design Studio on top of HANA studio views
• Work experience with business teams across different regions like USA, Mexico, Canada, Germany, Japan

Confidential, Plano, TX

SAP BW/BI/HANA Sr.Consultant

Responsibilities:

• Participated in project planning sessions with the client, project manager, business analysts and team members to analyze business requirements and outline the proposed solution Gathering report requirements and SAP Data analysis.
• Performed connectivity steps between ECC to BODS systems by creating datastore object
• Established connectivity between BODS and HANA system
• Created repository with Repository Manager and added Repository in CMC
• Created Jobs, Work Flows, Data Flows and Queries.
• Created join conditions in BODS based on design document
• Using different query transformations like Row generation, Case, Merge, and Validation.
• Created the Data flows in Staging-Target Model.
• Filtering and modeling the data by writing SQL Statements in Transformations.
• Achieved the data quality in Country ID, Address Cleanse and by matching data.
• Created the job schedules with a particular time period in DS Management Console.
• Modeled the Data flows with email alerts.
• Involved in creating Universe and designing WEBI reports.
• Production support work to help client continue his business with changing requirements.
• Production support work to help client continue his business with changing requirements.
• Involved in information gather phase
• Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View
• Developed complex SQL scripts in Calculation views
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application
• Involved in SAP HANA Security including User Management, Roles, and Privileges
• Reporting, Accessing Analytical and Calculation views from EXCEL.
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting
• Developed Web Services for SAP HANA database and deliver to ASP.NET developers to consume data in .net based applications

Confidential, Plano, TX

SAP BW/BI Sr.Consultant

Responsibilities:

• Gathering requirements from users and designing reports as per the business requirements.
• Designed a universe using alias and contexts as per the report requirement.
• Involved in creating and publishing reports on the web using the Info View in Web Intelligence.
• Created various simple and complex reports using drill down/up, slice and dice, breaks, filters and alerts.
• Resolved loops, chasm and fan traps using contexts, aliases and integrity checks.
• Created Classes and Objects taking the information from the database. Also created measured objects.
• Conducted Performance tuning of Universes for time management purpose by creating alternate views and indexes.
• Created Operational Data Source (ODS) to integrate data from SAP R/3 via the Persistent Staging Area (PSA) for reporting purposes
• Worked on Performance Enhancements for Xcelsius Projects built by other teams, by looking into various aspects like Architecture, Design, Server ScalaBIlity and Environment Load Handling
• Perform Management tasks using CCM and CMC. Overall responsible for capacity analysis and planning, performance tuning, auditing, and optimization of BOXI environments.
• Creation and maintenance of all features of BOE CMC including but not limited to security, content, users, groups, applications, data sources, connections, and profiles.
• Creation and maintenance of report schedules, events and triggers.
• Configuration and maintenance of all features of infoview and user desktop.
• Troubleshoots technical issues, communicates issues and impact, creates and delivers action plans, logs and manages support tickets with Business Objects, ensures tickets are resolved in a timely fashion, performs post incident reviews.
• Works with System Engineer to develop roadmap for BOE addressing functionality, hardware sizing, security, performance, backup and recovery, disaster planning and storage needs.
• Cleary define and apply "best practices “for performance, security, and configuration BOE environments
• Implemented FI-GL(New), PS, and CCA modules.
• Created technical specification documents for the BI objects.
• Developed data loading strategies for master data, transactional data delta loads.
• Build activities involve end to end development of clusters from scratch starting from data source to Reports
• Activated standard Extractors in ECC and Collected in a relevant transport request
• Extensively worked on activating the standard delivered business content Info objects, Info sources, Info cubes, ODS initially to show the reports to end users.
• Activated BW standard queries based on user acceptance and collected in BEx transport and imported.
• Changes have done in info provider (0PS C10, 0FIGL C10, 0CCA C20, ect.,) level and query level according to client data.
• Loaded data from two different clients and made changes for info providers according to data.
• Performed loading of Master Data and Transaction Data from SAP ECC source system into SAP BI and involved in validating the data.
• Extensively worked in transporting objects from Development to Quality.
• Created Process Chains for BW data loads.
• Worked on Open Hub Destination by extracting the master data( WBS element, Profit Center, Business Area, etc.,) from BW to ESSBASE system with restrictions.
• Development and Unit Testing of various BI objects as per the client requirement and preparation of the Unit Test Documents
• BPC process chain development to the financial data to staging DSO and to the cube
• Process chain development to support master data loads from BW to BPC
• Executing the optimization tool for lite and full optimization
• Maintaining the FI configuration required for BPC consolidation such as Operations account, group account relationship, intercompany elimination, trading partner related settings, Currency and rate maintenance.
• Loading the historical data, opening balances, current year data to BPC application from Hyperion ESSBASE.
• Reconciling the data of BPC consolidation, planning extracts with BI, ECC application.

Confidential, Enosburg Falls, VT

SAP BW/BI Consultant

Responsibilities:

• Created Sales Analysis and Direct Margin Analysis WEBI reports based on Universe.
• Created reports using universe as the main data provider as well as directly connection to the database.
• Created different reports like crosstab reports with different tabs to analyze the sales information like MTD & YTD analysis in the reports.
• Used different functionalities like drill down, Slice and Dice, master/detail for reporting analysis.
• Created complex reports using the multiple data providers, Calculations, Sections, Break, Alerter, Local variables.
• Customizing reports using BO, as it would enable drill up/down reports and apply the synchronization drill on the blocks while applying drill on charts and block content of the report.
• Created multiple tabs for differentiating sales persons wise.
• Created variables, Filters and conditions at design level.
• Designed prompts for restricting the data.
• Used Section property to displaying the data section wise based on Sales persons as well as location.
• Managed to co-operate with onsite team even with language barrier between us and successfully implemented the solutions by understanding the requirements.
• Worked extensively on Data warehouse workbench (RSA1) and customized Info Objects, Info Cubes, DSOs, Data Sources, Transformations, Different types of DTP’s, Info sets and Multiprovider.
• Installed Business Content objects for as per our requirement, gathered requirement from the user by discussing report’s result and proceed accordingly for customization.
• Created and scheduled the Error DTP to handle the error records in the Error Stack
• Extensively involved in analyzing the data load issues in process chains and rectification.
• Involved in extracting the R/3 data for MM and Sales and Distribution using LO-Cockpit and Generic extraction. Enhanced the Data sources as per the requirement and using the enhancement RSAP0001 to fill the data into enhanced fields.
• Creating process chains & Meta chains by using advanced process types like Decision between multiple alternatives, Using Interruption to stop the Process chain in a particular time. Involved in Load Monitoring Using RSPC, RSMO.
• Involved in performance tuning of Queries by maintaining Aggregates, Compression, Partition, Repartitioning and indexing of Info cubes.
• Extensively involved in creating a BEx Report (Global Position Query) where I used Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and also Used Variables with User Entry/Default Value, Replacement Path and Customer Exit.
• As part of integrated planning, involved in creating the aggregation level on the Multiprovider and defined the filters to from a data segment containing the Actual data of previous month and used the planning functions like-Copy, revaluation to plan for the next month and then the planning functions were scheduled by using process chains.

Confidential

SAP BW/BI Consultant

Responsibilities:

• Monitoring of Process chains for Master Data and Transactional Data. Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Scheduling and Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages and Worked on Housekeeping activities monthly once, involved in service pack updates.
• Loaded Data from multiple Data Sources to multiple Data Targets with different Transformations and DTP's by scheduling different updates.
• Loaded data from PSA to Data Targets using Transformations and DTPs.
• Corrected Erroneous records in Error Stack and executed the Error DTP to continue the loading process as part of testing in Quality Box.
• Used Write Optimized DSO to improve the Loading performance.
• Involved in resolving issues related to process chain errors and corrective action.
• Involved in Setting of alert messages for Process chains to report any sort of failure in the Process chain during the run time.
• Worked on several issues related to data discrepancy between R/3 and BI.
• Handle the issue related to performance and data inconsistencies faced by end-user.
• To estimate the Work Requests and make sure their completion within the dead line and Responsible for development, validation and integration testing.
• Documented the regular failures which occurred frequently in process chains and made them available to team members.
• Handled the Data source Migration/Maintenance, created new Reports with BI functionality.
• Designed the Queries using Structures, Cells, Variables, Static & Dynamic Filters, Restricted and Calculated Key Figures in Query Designer.
• Fixed DSO activation failures.
• Participated regularly in weekly ticket review meetings.
• Involved in maintaining documentation for all the Support Activities.