SUMMARY:

• SAP Certified Business Intelligence Consultant over 11+ years of techno - functional experience in SAP BW/BI, SAP HANA (Native & BW on HANA), SAP BOBJ, BPC and Tableau - Data extraction, Modeling, Data analysis and Reporting (Visualizations/Dashboards) experience.
• Using SAP LT Replication Server (SLT) done the Data Provisioning into SAP HANA to achieve real time replication.
• Worked on SLT Job scheduling, monitoring, and error resolutions
• SAP HANA-Flat file uploads, Extracting data using SAP Direct Extractor Connection (DXC) through business content extractors.
• Familiar with ODP and SDA data extraction techniques to HANA
• Developed attribute views, analytic views, calculation views (Graphical and SQL-Script), packages in SAP HANA studio
• Worked with variables, Input parameters, Calculated and Restricted measures, Counters, Decision Tables etc.
• Worked on HANA SQL script and CE functions for developing Calculation views and Stored Procedures, Unit/Currency conversion in SAP HANA.
• Worked on HANA live data models and implementation.
• Worked on different SAP ECC modules like SD, FI, MM, HCM etc.. for HANA developments
• Worked on developing cross functional views in HANA for Tableau reporting
• SAP HANA Administration- Analytic Privileges, Managing schemas, data model objects, import/export content.
• Strong experience in cleansing the data using Data Quality transforms at BODS.
• Involved in classic SAP BW to SAP BW on HANA migration
• Involved in optimizing Info cubes and DSOs using T Code RSMIGRHANADB
• Involved in pre and post BW version upgrades and HANA DB including housekeeping tasks and post upgrade/migration issues fixes.
• Upgraded from BW 7.0 to BW 7.3 and 7.5 migrated DB from Oracle to SAP HANA
• Worked on LSA++ latest BW data flows and Info providers like SPOs, Composite provider, Open ODS views, Advanced DSOs, Transient providers and Virtual providers, Eclipse modeling.
• Successfully implemented Sybase IQ Near-Line Storage to archived BW on HANA data into Near-Line Storage
• Developed Composite Provider to combine both data from BW & HANA and designed BEx queries
• Classic BI Design - Info Cubes design, Data Sources, Info Object maintenance, ODS Objects, Info sets, Hierarchies, Multi providers, Transformations, Info Packages using AWB. Proficient in Data modeling using MDM and BW extended star schema models. Experience in ETL i.e. Data Extraction, Data Transferring, Data Loading such as SAP BI
• Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master Data and Transactional Data, transformations creation, Business Content Activation.
• Performance tuning of Queries (SAP BW BEX) by maintaining Aggregates, Compression, partition, indexing of info cubes and use of statistics for the same.
• Reporting Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, Conditions, RRI, and Jump queries.
• Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, partitioning.
• Experience with SAP BPC which Include Requirement Gathering, Development, Test, Support, Migration Activities and Go-Live.
• Experience in setting up various interfaces for the Data Load, Currency Conversion, Group Currency Conversions, Journals, Carry Forward, Account Classifications, Ownership Calculations, Intercompany Matching, Intercompany Booking, Intercompany Eliminations, Minority Interest and Equity Adjustments, Statuary Reporting, Validation Rules, Consolidation Central and Good knowledge on BPC 10.1.
• Planning/Budgeting & Forecasting implementation from Blueprint to implementation and going live. Hands on experience in developing functional models like Procurement planning, Head Count planning and Sales planning using SAP BPC
• Solid experience in Building Input schedules, Reports, Security Set up (Task Profile, Member Access Profiles, Users and Teams), Work Status Settings in SAP BPC
• Extensively worked on design, develop support and enhancements of Business objects reports and dashboards using Webi, Dashboards, Design studio, SAP Lumira, Crystal reports, analysis for office, OLAP Analysis.
• Worked in developing front end visualizations using SAP Lumira
• Created Complex reports which includes Breaks, Sections, Ranks and Filters
• Excellent in creating Webi reports and deploying them through Info view with OLAP universe(UNV-3.1),Relational Universe (UNX-4.x) and BICS connection as source and creating dash boards using BO dash boards (Xcelsius), created Webi reports such as Tabular, Cross tab and Graphical reports with multiple tabs.
• Created Universes based on the Info-cubes/ Queries in SAP BW system and NON-SAP Systems using UDT/IDT.
• Worked on SAP BW BO XI 4.1 Integration using BICS connections for Bex queries and HANA views
• Worked on BO Job scheduling, Server restarting and resetting the failure job instances using CMC.
• Involved in SAP BW BO integration part and resolved integration issues by implemented best practices.
• Worked on SAP BW data models, Bex query designer to create suitable Queries for BO reporting.
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0
• Worked on BO Job scheduling, Server restarting and resetting the failure job instances.
• Worked on Business Objects Explorer (BOE) configuration and daily data refresh
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.

TECHNICAL SKILLS:

SAP (R/3&BW/BI): BW 7.x /3.x, R/3, ECC 6.0, HANA 1.0, and BPC 10.x

SAP Modules: Logistics (SD, MM), HR, IS-U, FI, CO-PA, IS-Retail, PP, SCM, CRM

ETL: BODS, SLT, Open hub, APD

Programming languages: ABAP/4, JAVA, HTML, SQL and PL/SQL.

Ticketing tools: Remedy, HP quality center, JIRA

Reporting Tools: Tableau 10.x/9.x,Bex query designer, Bex Analyzer, Web Application Designer, WebFOCUS, Business Objects XI 3.1/4.1, Information Design Tool (IDT), Webi, BO Dashboards (Xcelsius), Design studio, Analysis for Office, Crystal reports, SAP Lumira

PROFESSIONAL EXPERIENCE:

SAP BW/BO/HANA/Tableau Senior consultant

Confidential, Boston, MA

• Worked on Real-time FI GL reports using BW on HANA and views from SAP HANA Extracted data from BSEG, BKPF and GLT0 using SLT to get real-time data from SAP ECC.
• Extensively worked on financial reports Profit & Loss, Balance sheet, Profitability Analysis, AP, AR, Procurement, Vendor and Asset accounting etc..
• Extensively worked on error resolutions, Bug fixes for financial reports and month end report bursting.
• Created Composite Providers on HANA Model's in BW to accommodate current & historical reporting.
• Create Open ODS View using SAP HANA Smart Data Access as Data Source from ECC and Combined other Info providers using Composite Provider
• Involved in migrating data base from Oracle to HANA and updating BW 7.3 to 7.5 activities
• Involved in creation of calculated attributes, measures, restricted measures, calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA Studio
• Worked on HANA live views for different functional areas operational reporting.
• Develop SQL scripts and functions for complex reusable scenarios in HANA.Consumption of HANA information Models in BW by creating Composite and Transient Providers.
• Worked on Tableau report developments using HANA views as source
• Used Table Calculations, Parameters, geographic mapping, Sets, Actions and LOD expressions for solving complex business issues and solved Optimize issues in Dashboards in Tableau
• Experienced in forecasting and various trend reports.
• Experience in creating Bar chart, scatter plot and pie chart.Created conditional filters to filter the data on dashboard.Creating Parameters for desired functionality.
• Work with client and team members to understand and clarify visualization requirements needs.
• Designed & developed cross tab reports, reports with sub reports (linked & unlinked) and charts using Crystal Reports.
• Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence (WEBI), Designed Webi Reports Using Bex Queries (BICS Connection).
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Designed and developed Business Intelligence end to end solutions using Tableau.
• Published Workbooks by creating user filters and security, so intended teams can view it.
• Developed tableau dashboards with combination charts for clear understanding.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps,

Tools: used- SAP BW 7.5/7.3, HANA 1.0, Tableau 10.x/9.x, BOBJ 4.1, SAP ECC6, JIRA

SAP BW, HANA, BO, BPC Senior consultant

Confidential, Greensboro, NC

• Experience in Data-Provisioning techniques suing SLT (SAP Landscape Transformation) to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
• Experience in Configuring and Consuming SAP HANA models in BI clients such as Lumira, Predictive Analysis Business Objects Explorer & MS Excel.
• Involved in many other changes in modeling, reports and bug fixes.
• Extensively worked on HANA models on BW on HANA environment
• Created HANA-optimized Info Cube for faster reporting, to accelerate data loads, simplify data modeling and to allow faster remodeling of structural changes.
• Working on SAP BW BO XI 4.1 Integration, Information Design Tool (IDT), Webi reports, and Crystal reports.
• Knowledge in developing front end visualizations using SAP Lumira
• Worked on design studio to create summarized reports and dashboards.
• Worked on Xcelsius dashboards and SAP Business Objects Data Services
• Worked on BO Job scheduling, Server restarting and resetting the failure job instances.
• Worked on SAP BW data models, Bex query designer to create suitable Queries for BO reporting
• Corrected the Integration process from ECC, BW, BPC (Master data & Transaction data)
• Created complex Input templates & reports using EPM & also used VBA macros.
• Trained End user how to load data from ECC to BPC on-demand basis.
• Created & maintained BPC launch page so that end user can access all reports using one excel.
• Fixed issue related to data discrepancies in BPC & ECC.
• In BPC support role, resolves many production issues like failure of package, Input template fixes

Tools: used- SAP BW 7.4, BOBJ 4.1, BW on HANA, BPC, SAP BODS, ECC6

SAP BW/BO, BPC, HANA Senior consultant

Confidential, Greenville

• Involved in Business meetings to understand requirements and user specific questions
• Converted functional specifications in to technical specifications
• Coordinated with BASIS team if any system or database issues
• Coordinated with change management team to transport BW objects across landscape
• Lead the off-shore team to build data models and reports as per business requirements.
• Conducted workshops and end user trainings
• Worked on unit, integration, and user acceptance tests (UAT)
• Worked on Asset accounting, cash flow statement, CO-PA and Partner Incentive programming (PIP) reporting
• Worked on Sales, Gross margin, Inventory reports and Dashboard developments
• Created Complex reports which includes Breaks, Sections, Ranks and Filters.
• Worked on change requests, high priority incident and problem/Issue tickets
• Implemented the BI 7.0 concepts of Transformations and DTPs using the existing data source migration and involved in up gradation and migration from BW 3.5 to BW 7.0
• Involved in upgrading BW 7.0 to 7.3 and migrating Data base from oracle to HANA
• Worked on developing analytical reports and dashboards based on HANA views using different reporting tools like BO dashboards, Design studio, Webi and Tableau, etc..
• Design & Maintenance of Customized InfoObjects, Info Cubes, DSO Objects, Multi Providers and Info sets in SAP NetWeaver BW 7.3
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Worked on HANA studio to create Attribute views, analytical views and calculated views.
• Fixing the data load errors and other issues immediately to meet daily SLAs
• Worked on BMC remedy ticketing tool for incident and change request tickets
• Worked on Process chain creation, scheduling and event based triggering in the Process chains.
• Worked on Bex Query designer, WAD reports, Bex analyzer bug fixes.
• Started to work on the Design & Development of SAP BPC 10.0 version, later on upgraded to 10.1 NW
• Implementing requirements on the Planning cycles, continuously enhancing technical and business processes and reporting
• SAP BPC Planning, Budgeting, and Forecasting Implementation - Data Load, Manual Planning via Input Form, Manual Forecast via Input Form, Automated Planning & Forecast via Logic, Budget Allocation, Business Process Flow, Work Status, and Management Reporting.
• Created Process Chains to Automate & Schedule Daily & Monthly Loads to our BPC Models & Dimensions. All the Master Data Loads were automated on the monthly basis with just a file required to be complete the whole process.
• Worked on BO XI 4.1 Universe, Webi reports development and portal monitoring
• Worked on Pre-calculating the Bex queries to improve runtimes
• Worked with Open Hub service for sending the data from BW to External Systems.

Tools: used-SAP BW 3.5/7.0/7.3, BOBJ 3.1/4.0/4.1,HANA, BPC 10.x, ECC6

SAP BW/BO Consultant

Confidential, West Palm Beach, Florida

• Worked as a SAP BI/BO Senior Technical Consultant
• Monitored the daily, weekly and month end data loads
• Maintained the statics of DTP's, Info packages, Process chains and APD Jobs
• Stabilized the data loads which were newly added to the systems in project landscape environment.
• Optimized the existing extractor enhancement codes and improved the data load completion timings those are overrunning in Production system
• Rectified the Errors at various levels during the Production BW batch execution times.
• Monitoring the Process chains through RSPC, RSPCM and ST13 TXN codes.
• Analyzed the Short dumps related to BI errors and taken the necessary actions.
• Created the process chains for Maintenance activities of BW objects( PSA master data and DSO change log data deletion
• Created the Indexes and Aggregates for Improvements of the Query run time performance
• Compressed the data in info cubes for Improvement of query execution times.
• Responsible for Monitoring Failed BO report Instances on a daily basis and Managing Universes and Connections.

SAP BW Consultant

Confidential, Long Beach, California

• Actively participated in Project Preparation, Business Blueprint Requirements Discussion and Realization
• Involved in Activating the Business Content Data Sources, Generating the Data Source.
• Enhanced the standard data sources to meet the requirement.
• Performed Data Extraction and Data Staging using LO Cockpit (LBWE) and extended the Structures using user exits to support the Business needs for SD and MM modules
• Created Generic Data source using Table, View and Function Module.
• Worked on extracting data from ECC system and in modeling BI objects to publish the data at Feed store side by using Open hubs.
• Worked on extracting data from R/3 systems and in modeling BI objects to provide the data for reporting through Bex and WAD.
• Developed BI customized data targets like DSOs, Cubes, Multi providers, Process chains.
• Created Direct process chains and Meta chains for all Master data attribute, Master data Text and transaction data loads.
• Scheduled the Process chains as per the client requested timings and also resolved the upcoming issues during the Monitoring of Process chains.
• Worked extensively with the Transportation activities.
• Working in resolving the issues during data loads, Unit testing and SIT of the build objects and in fixing bugs

SAP BW Consultant

Confidential

• Worked on IS-Utilities module implementation.
• Installed relevant SAP business content objects and enhanced them as per requirement.
• Created Info objects, Info cubes, DSO's, Data Source and Multi Cubes.
• Created Transformations, DTP's between the Objects.
• Created Multi providers for reconciliation.
• Created Queries on Multi providers and Info cubes. Worked on Web Application Designer.
• Data Modeling, extraction and reporting areas with respect to Sales and Contracting of IS-U.
• Enhanced the Sales Statistics Data Source 0UC SALES STATS 02.
• Did the data modeling for Sales and Contracting Area.
• Generated Reports with BI 7.0 functionality
• Developed flexible queries using Filters, Variables, Exceptions, Conditions, restricted key
• Figures and calculated key figures in Bex query designer and WAD to facilitate data analysis in a drill down or summarized way to give detailed levels of information.

SAP BW executive

Confidential

• Involved in the design, development of Multi dimensional Data Models, Info Cubes, Data Store Objects (DSO), Aggregates, Hierarchies, Info Objects, Data Sources, Info Sources, Info Providers, Data Transfer Processes (DTPs), Transformations Using BI 7.0.
• Activation of Standard HCM Business Content cubes for Personal administration, Time management, Payroll for HR implementation
• Worked on Retail module implementation for Reliance retail business.
• Involved in Installed Info Objects, Data Sources, Info Sources, Data targets, Info Packages and Info Providers to load master and Transaction data from SAP R/3 system into BW system.
• Worked extensively on extractions loaded the data from R/3 to BW and used Initialization with delta update and full update methods.
• Extensive Worked in building Queries by using Calculated and Restricted key figures, Structures, Variables, Exceptions, Conditions, Cell restrictions, Formulas, RRI (Report to Report interface) by creating Multi providers.
• Involved in creating Dashboard reports in HR for top management using Web application designer
• Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Worked on Reliance financial planning development using BI-Integrated Planning (IP)

SAP BW Associate consultant

Confidential

• Developed new Info cubes, communication Structure, transfer rules, Update rules.
• Worked on creating single roles, composite roles and providing authorizations to respective end users as per the business requirements.
• Worked on creation, maintenance of aggregates and hierarchies for the Info cubes to access data in an efficient and ordered level.
• Worked with Open Hub service for sending the data from BW to External Systems.
• Handled performance issues like - Info cube Compressions, partitioning, query performance, Selective deletion of cube data on monthly basis etc.
• In case of data load failures, took corrective actions using appropriate extraction programs after making corrective actions.
• Scheduled extract jobs with Process Chain and monitored transfer/update of data loads into data targets with View Log.
• Extensively worked in many Performance issue improvements in both loading and Execution activities.
• Worked in roles and authorizations
• Created web dashboards using WAD tool.