SUMMARY

• Over 9 years of relevant industry experience in Tableau, SAP BOBI, SAP HANA, SQL, SAP BW and SAP ABAP
• Expertise with SAP HANA Studio with Modeling and Administration Perspectives
• Expertise in creating various Information Models like Attribute, Analytic and Calculated Views. And exposure to Procedures decision tables and calculated columns.
• Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files
• Hands - on experience with SQL scripts like stored procedures and CE scripting and well versed with BW7.3 on HANA working functionalities
• Extensive experience in working with Tableau Desktop Server and SAP BO Suite
• Created dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop and organizing Dashboard views and objects
• Experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive dashboards with Page and dashboard Prompts
• Have experience on building Dashboards in SAP Design Studio
• Expertise in integrating BOBJ reporting tools includes WEBI, Xcelsius/Dashboard Design, Business Layer and Data Foundation in the Universe/Information Design Tool
• Experience in creating the Universes and Resolving Loops Using Contexts and Aliases.
• Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks
• Experience in Data Extraction, Modeling and Reporting in SAP BW
• Experience in SAP ABAP coding at different levels of Data flow like Transformations, Variables, DTP’s and InfoPackages
• Worked on InfoProviders like SPO’s, InfoCubes, DSO’s, MultiProviders and Master data Objects
• Worked on LO Cockpit, FIGL and Generic Extractors
• Worked on Inbound and Outbound interfaces. Have created Open Hub Destinations and APD’s using BEx queries as source
• Extensively worked on BEx Query designer and Analyzer
• Involved in Performance tuning of InfoCubes, Reports and Data loading
• Strong knowledge of BW Architecture and Data Flow Strategy
• Also have exposure to SAP POSDM. Monitoring and processing the inbounds in POSDM and analyzing the errors if there are any failures
• Exceptional ability to quickly master new concepts and technologies
• Capable of working in a group as well as independently with excellent communication skills

Areas of Expertise

• SAP HANA Modeling, Data Provisioning
• SQL Scripting
• SAP BOBI, IDT
• Tableau
• SAP BW/ SAP BEx
• SAP ABAP

TECHNICAL SKILLS

ERP: SAP R/3 ECC 6.0/4.6C/ 4.7E

Data warehousing And ETL: SAP BW 3.5, BI 7.0,BI 7.3, SAP HANA Studio

Reporting Tools: SAP BEx, SAP Business Objects, Tableau

Programming Languages: SAP ABAP (Specific to BW)

DBMS/RDMS: SAP HANA, Oracle, MS Access

Operating Systems: Windows

Packages: MS office

PROFESSIONAL EXPERIENCE

Confidential, Dublin, CA

Sr. SAP BW/HANA/BOBI Consultant / Tableau Consultant

Responsibilities:

• Created HANA modeling scenarios and activities such as setting up HANA environment - adding a system, creating schemas and creation of USERs and ROLES, etc.
• Expert in creation of Attribute Views, Analytical Views and Calculation views Graphical and SQL Script - CE Functions and Stored Procedures
• Data Provisioning and replicating data from source system toHANA Database using SLT Business Objects Data Services
• Monitoring the replication process usingSAPHANAstudio and SAP LT replication server for transactional Integrity
• Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE(In memory calculation Engine) studio
• Consumed BEx queries for developing Dashboards in SAP Design Studio
• Created universes using IDT on SAP HANA views and BW as source system and build report development on the same using Web Intelligence
• Developed Webi reports for different project and extensively used Variables, Drill down, Breaks, Sections, input controls, formatting tables, cross tab representation, data sort options, calculations
• Migrating and transporting the new reports and universes using the CMC
• Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex SQL queries and joins.
• Thus Considering best business Practices using Web intelligence Rich Client
• Designed and developed operational dashboards with parameters, calculated fields, groups and hierarchies
• Developed workbooks with various functionalities and deployed them on server
• Used functionalities like groups, sets, Actions (hyperlinks), context filters wherever required
• Managed and maintained Tableau Server, Desktop, users and user groups
• Scheduling and maintaining the workbooks to synchronize dynamically with run time data
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and Log Axes
• Responsible for overall coordination with Business users and SAP BI team with focus on reports delivery

Environment: Tableau 8, SAP HANA SPS 07/08, SAP BI 7.3/7.4, Business Objects 4.0/4.1

Confidential, Houston, TX

Sr. SAP BW/HANA/BOBI Consultant

Responsibilities:

• Upgrade from BW 7.1 to BW 7.4 on HANA focusing on Modeling, Extraction and Reporting, testing, UAT (User Acceptance Test), defect monitoring and resolution and release management as well as post go-live support
• Carried out the house-keeping activities before moving BW to BW on HANA
• Followed best practices for optimizing the objects, ABAP routines i.e start routines, end routines and field routines
• Redesigned the process chains based on the new functionality, by adding the DTPs and by removing create and delete indexes and aggregates in BW-on-HANA
• Worked on the testing strategy for pre upgrade, post upgrade and data validations. Tested the Dual Delta extraction process and validated the data BW-on-HANA
• Migrated the existing BW DSOs, InfoCubes and SPOs in dataflow to HANA optimized
• Migrated BEx reports from 3.x to 7.4. Fixed the issues faced by the users
• Day to day support for maintaining the BW application especially monitoring the loads and fixing the data errors, performance tuning, change control, security maintenance etc.
• Created BW models to consume different HANA models in FI, CO, COPA, AP, SCM and Assets
• Created MultiProviders using cubes and DSO to leverage for reporting
• Created Composite Providers using multiple providers
• Created APD’s & Open Hub to generate file with huge volume of Assets data
• Worked extensively with BEX Designer in designing Queries and reports using calculated key figures, restricted key figures, free characteristics, filters and Variables.
• Design BI architecture and reporting strategy for integration of BW and BI 4.1, 4.0 for creating WEBI and Analysis for OLAP reports
• Created Universe and Web Intelligence reports using BEx queries. Defined best practices to use BEx queries in Business Objects.
• Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through Crystal Reports, Dashboard Design and Web Intelligence

Environment: SAP HANA SPS04, ECC 6.0, SAP BI 7.1/7.4, Business Objects 4.0

Confidential, Dallas, TX

Sr. SAP BW/HANA/BOBI Consultant

Responsibilities:

• Created SAP HANA Information Models using Attribute, Analytic and Calculated Views
• Replicated data using SLT and BODS and created models as per requirement
• Involved in moving Information models to BW as transient provider and created Reports
• Created SPOs and In memory Cubes and DSOs
• Used Virtual provider and composite provider in BW HANA. Generated composite view in native HANA and replicated to BW HANA for reporting
• Migrated In memory Cubes and DSOs to Hana studio and modified as per requirement to create Calculated and Analytic views.
• Created Decision tables and performed various calculations using best function provided by Hana.
• Created and maintenance of Info Objects, DSO, Cubes, Transformations, DTPs, Data Sources.
• Involved in creation of Reports, formatting reports, generation of charts, bars etc as per user requirements using Webi, Xcelsius 2008
• Created process flow module documents and Scheduled SPM loads through Portal
• Involved in Unit Testing and Business Acceptance Testing using HP Quality Center
• Interacted with Business users and collected requirements and provided solution accordingly

Environment: SAP HANA SPS05, ECC 6.0, SAP BI 7.3, Business Objects 4.0

Confidential

Responsibilities:

• Handled a team of size six for Pre HANA upgradation project
• Identified 3.x flows and migrated to 7.0 to make BI system ready for HANA upgradation
• Have involved in migrating WAD templates from 3.x to to 7.0 and resolved issues post migration
• Converted InfoSpokes to OHD’s and validated across the systems
• Identified and migrated 3.x Queries and Workbooks
• Moved the migrated objects successfully to production and provided post-golive support
• Installed Business Content Objects as and when required
• Extensively involved in setting up the procedures for extracting the data from ECC by using the Lo Cockpit and Generic extractions
• Created Generic Data sources using Tables and Views for extracting Master and Text Data.
• Uploaded master and transaction data from flat files
• Collected, released and imported the BI Objects from Development to Quality boxes
• Direct interaction with the business users
• Created and maintenance of Info Objects, DSO, WODSO, Cubes, Transformations, DTPs, Data Sources
• Created and maintained queries in BEx Query Designer and BEx Web Application Designer for analysis and web reporting respectively which are published in Enterprise Portal

Environment: SAP BI 3.5/7.0, ECC 6.0

Confidential, St. Paul

Sr. SAP BW Consultant

Responsibilities:

• Created Technical Design Documents based on Requirement design Documents
• Installed Business Content for Standard Info Cubes, DSOs and Info Objects as per the Client Requirements
• Created Generic Extractors and involved in enhancing the DataSources
• Worked on Inbound and Outbound interfaces. Used Open hub service to distribute data to other systems(Hyperion)
• Worked on creation Queries, calculated key figures, Restricted Key figures, Structures, Variables to enhance the reporting features.
• Implemented conditions and restriction in the reports based on the requirements, Developed Workbooks
• Involved in collecting all the developed objects and releasing the TR’s
• Created Transformations and involved in creating Start routines, End routines and Filed level routines as per requirement
• Created InfoPackages to do Inits, Full and Delta extraction and also involved in creating dynamic filters in DTP’s
• Designed and created Process chains to automate the data load and data target administration and monitored the processes
• Involved in data reconciliations between ECC, BW and BEx report and also validated the logic in transformation Routines
• As per FUT, have tested BEx reports and also handled defects raised by Users during Integration testing phase

Environment: SAP BI 7.0, ECC 6.0, CRM, SRM

Confidential, Atlanta, GA

SAP BW Consultant

Responsibilities:

• Involved in Enhancing DataSources as per requirement and modified the Data flow in BW
• Performed Cutover activities
• Provided long-term solutions to the tickets by doing Root cause Analysis
• Preparing and performing the repair loads if there are any data mismatches
• Discussing with the Application teams regarding the Drop loads or new demands and validating and performing the steps involved in drop loads
• Check overall health of the production system and performance of BIA in RSDDBIAMON2/TREXADMIN and also Real-time data acquisition
• Worked with BEX analyzer, created queries using Variables, Filters, Calculated key figures and Restricted key figures
• Handling customer loading request tickets and high severity tickets related to data quality issue
• Performance tuning of BW System on various levels such as reporting and data loading
• Maintaining Reconciliations to verify the data in SAP R3 and SAP BW after the daily data loads
• Creating/Modifying process chains as per requirement
• Monitoring the status of all daily/weekly/monthly loads in the system and making sure not to miss the KPI
• Attending calls with Client and discussing overall status of the production system on daily basis
• Resolving the loading issues and reporting it to the users as per the severity

Environment: SAP BI 7.0, SAP R/3 4.7E

Confidential, Houston TX

SAP BW Consultant

Responsibilities:

• Extensively worked with Orders, Deliveries and Billing areas of Sales and Distribution module
• Enhanced Data source as per the user requirement
• Extracted data from R/3 to BI using Logistics Extraction
• Created info objects, Data source, ODS, Info Cubes, Transformations, Info Packages and DTP’s
• Worked on enhancement of DataSource according to client’s requirement
• Designed and developed Process chains for master data loads and Transaction data loads
• Developed/Modified reports using BEx Analyzer that had Structures, Exceptions, Conditions, Restricted Key figures, Calculated Key figures and Variables
• Optimized query performance and loading performance with various tuning like Aggregates, Indexes and Partitioning of InfoCubes etc.
• Created number of reports and done changes to reports as per requirement. Also done appropriate backend changes
• Experienced in all the modeling activities of InfoCube & DSO
• Performance monitoring of BW System on various levels such as reporting and data loading using the Technical content cubes.
• Monitoring Inbounds in SAP POSDM from where the data gets extracted into BW InfoProviders.
• Resolving the common issues in SAP POSDM and reporting to the onsite co-ordinate in case of any major issues.

Environment: SAP BW 7.0, SAP R/3 4.7E (IS Retail)