SUMMARY

• Having 8+ Years of IT experience in design, development, implementation and testing using SAP Business Objects XI R3, SAP BOBI 4.0,4.1, SAP HANA
• Extensive project experience using SAP HANA, SAP BI 7.0/7.3, and SAP BODS 4.0
• Developed complex BI reports for SAP modules such as SD, MM, FI - CO and HR.
• Created connections to BEx queries using Business Intelligence Consumer Services (BICS) in IDT.
• Experience in Creating Adhoc Reports using Web Intelligence Rich Client and schedule teh reports as per teh business needs and supporting.
• Created connections to BEx queries using Business Intelligence Consumer Services (BICS) in IDT.
• Experience in Creating Adhoc Reports using Web Intelligence Rich Client and schedule teh reports as per teh business needs and supporting.
• Developed WEBI reports on SAP BW Queries using BICS and applied graphical representation of reports
• Experience in creating Static and Dynamic Dashboards through connections Query Browser, Live office and MS Excel.
• Well versed in Business Objects Suite (XI R3/XI R4) BOBI 4.0,4.1, Universe Designer, Web Intelligence(WebI), Information Design Tool(IDT)
• Experience in creating Dashboards on various components like Column Chart, Stacked Chart, Bar Charts, Pie Chart, Label Based Menu, Combo Box, Grid, Ticker, Gauge, Maps etc.
• Experience on CMC creating Users, Groups, Access Levels, Security, Folders, Categories, and Connections etc.
• Experience in creating Crystal Reports including sub-reports, Standard reports, Crosstab reports, drilling reports, analysis reports, data reports along wif LOV.
• Experience in developing BEx queries using Query Designer over BW Info Cubes/DSO's and Multi Providers. Created WebI Reports on top of BEX Queries.
• Created Universes using IDT on top of HANA calculation and analytical views and developed WEBI reports and dashboards
• Experience in creating and modifying Universes on Relational and OLAP Data sources.
• Created Attribute Views, Analytic Views and Calculation Views in SAP HANA
• Hands on experience in HANA modeling. Created multiple schemas and table definitions
• Good Knowledge in SAP HANA security including User Management, Roles and Privileges
• 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 wif Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction),DXC and Flat files.
• Extensively worked in Business Information Warehouse objects like Info Cubes, DSOs, Info objects, Transformations, DTPs and so on

TECHNICAL SKILLS

Business Intelligence: SAP Business Objects 4.1/4.0/BO XI 3.1, Information Design Tool, Universe Design Tool, Web Intelligence, Xcelsius/Dashboard, SAP Design Studio, SAP Lumira, Crystal Reports 2011, SAP Hana Studio, SAP BI 7.3, SAP BI 7.0, Bex Query Designer, Tableau 8,9.0,9.2.

Databases: SAP HANA, Oracle 11g/10g, SQL Server, DB2,Tera data.

Environment: s: Win XP/ 2000/2003/2007 , Windows server 2008/2012.

Programming Language: SAP ABAP/4,SQL

PROFESSIONAL EXPERIENCE

Confidential

SAP Business Objects / HANA Consultant

Responsibilities:

• Extensively involved in design and development of Tableau visualization solutions for ZEDVentures Solution - ZenOptics, using operational dashboards and reports development, workbooks on various flavours of RDBMS like Oracle, Teradata and MS SQL Server.
• Excellent in optimizing dashboards, performed Data validation and testing of visualizations wif backend data prior to deployment.
• Reports to Tableau visualizations which involved extensive data blending, filter actions, parameters and embedded hyperlinks
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet inTableau Desktop.
• Utilized advance features ofTableausoftware like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Data replicating fromSAPSource system and NONSAPSource system toHANADB for teh ZenOptics Solutions.
• Created OLAP Universes using BEx Queries & Infocubes.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, calculations, etc.
• Worked on creating groups, conditions, filters, ranking in reports

Environment: SAP Business Objects 4.1, IDT, WEBI, BODS, SAP HANA 1.0, SAP BW 7.3,7.4 Tableau8,9.2

Confidential

SAP Business Objects / HANA Consultant

Responsibilities:

• Involved in reviewing business requirements andanalysingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects wifin TableauDesktop.
• Extensive experience in usingTableaufunctionalitiesfor creating differentReports,Interactive Dashboardswif page and dashboard Prompts.
• Designed and maintain many monthly as well as ad-hock reports.
• Extracting data from multiple sources and using Data Blending technique to create dashboards.
• Preparing Dashboards using advance table calculations, parameters, calculated fields, groups, sets, forecasting and hierarchies in Tableau.
• Skilled in TableauDesktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• End to end experience in designing and deploying data visualizations using Tableau.
• Interacted wif Business Users for gathering requirements and Report specifications.
• Hands on Experience in creating Webi reports using BICS connection in BO.
• Created teh reports wif major functions in WebI.
• Created teh complex reports wif filters, breaks, section, charts Restricted teh data using teh Prompts and filters.
• Modifying existing WEBI reports and supporting teh UAT process.
• Created Dashboards using teh Universes as teh main data Providers in BI4.0
• Created Reports daily, weekly, monthly and quarterly, Yearly reports for teh management team and field operation managers using Business Objects Reports.
• Created various Crystal reports using different data sources like Universe, BEX-Query, OLTP-tables, Excel, Text files using Crystal reports 2011.
• Developed various sales and marketing reports using Web Intelligence.
• Created complex Dashboards using query browser.
• Worked on linking of teh Dashboards by using flash variables.
• Worked on various components in teh Dashboard.
• Created Reports daily, weekly, monthly and quarterly, Yearly reports for teh management team and field operation managers using Business Objects Reports.
• Created Alerter, Filters, Prompts Ranking and Inserted Breaks, Sections, Query Panel, Report Panel, and Formatting in designing reports.
• Applied graphical representation of reports such as Bar Charts, Pie Charts as per teh end user requirements.
• Created complex reports using Merged Dimension and multiple data providers and synchronized teh data providers by linking teh common objects to create teh common report.
• Worked on performance tuning of teh Dashboard.
• Created Dashboards using QAAWS connections, Query Browser and Live Office connection.
• Dashboards include different components like Column Chart, Stacked Chart, Bar Charts, Pie Chart, Label Based Menu, Combo Box, Grid, Ticker, Gauge, Maps etc.
• Assigning SAP HANA Package Privileges to user to Control access to information
• Experience in creating Dashboards using SAP Lumira and given training for end users
• Created Visualizations by using SAP Lumira.
• Reports to Tableau visualizations which involved extensive data blending, filter actions, parameters and embedded hyperlinks
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet inTableau Desktop
• Created reports using Crystal Reports wif Standard, Summary, Cross Tabs, SQL,Command Objects,Selection Criteria, grouping,sub reportsetc

Environment: SAP Business Objects 4.1, IDT, WEBI, BODS, SAP HANA 1.0, SAP BW 7.3, SAP Lumira. Tableau8and Tableau9.2

Confidential

SAP BOBJ Consultant

Responsibilities:

• Created numerous dashboards inTableauDesktop based on teh data collected from Insurance App's by importing and blending data from MS Excel and CSV files along wif Oracle SQL Server Databases.
• Created Adhoc reports to users inTableauby connecting various data sources. Analyzed teh source data and handled efficiently by modifying teh data types.
• Used excel sheet, flat files, CSV files to generatedTableauAdhoc reports.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues wifinTableau Server and Reports.
• Extensive experience inTableau Desktop,Tableau ServerandTableauReaderin various versions of Tableau7 and Tableau8and Tableau9.2
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Scheduling and maintaining teh workbooks to synchronize dynamically wif run time data.
• Created Attribute Views, Analytic Views and Calculation Views by using HANA Studio.
• Performed data modeling and developed Analytical views for teh transactional data, Attribute views for teh master data, and teh calculation views as final model in HANA Studio.
• Created Universe (Business Layer) to meet end user reporting requirements by using IDT 4.1
• Data Provisioning and replicating data from source system toHANA Database using SLT and Business Objects Data Services.
• Replication of teh selected tables of SD from ECC toSAPHANA. Performed transformations during teh replication process.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Created WebI Documents on top of Universe and published them for Business users.
• Created dashboards on top of HANA views by using OLAP connection.
• Experienced in loading data from tables in HANA Database to BW data marts
• Involved in designing Universe using Information Design Tool(IDT) in BO 4.0 wif teh SAP BI/BW as backend data source, and BEX queries as source for Universe.
• Created relational connections, Data Foundations, and Business Layers and exported BL to repository.
• Worked wif all teh sections in teh Crystal reports like Report Header, Page Header, Details, Page Footer, and Report Footer.
• Created objects, predefined conditions, row level restrictions and deleting unused objects at universe level.
• Developed WEBI reports wif crosstab, Master detail reports as per teh client requirements.
• Created BICS connections using IDT and in CMC as well, created webi reports using BICS connection.
• Created complex reports using multiple queries, merged dimensions, drill filters, calculation contexts, break and alerts.
• Created Webi reports using hyperlink to jump into one report to another.
• Created canned and ad-hoc reports based on teh Business Users requirements.
• Exporting teh Reports to Repository for accessing all levels of managers.
• Preparing Dashboards using advance table calculations, parameters, calculated fields, groups, sets, forecasting and hierarchies in Tableau.
• Skilled in TableauDesktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• End to end experience in designing and deploying data visualizations using Tableau

Environment: SAP Business Objects 4.1, IDT, WEBI, BODS, SAP HANA 1.0, SAP BW 7.3, SAP Lumira. Tableau 8, 9.2

Confidential

Business Objects Consultant

Responsibilities:

• Participated in teh meetings wif Functional Consultants and teh Power users to understand teh Business requirement and teh Data Flow of teh business.
• Created various WebI Reports on top of BEX queries by using BICS connection.
• Used Charts, Sections, breaks, Rank, merging dimension functionality in WebI documents.
• Created Attribute Views and Analytic Views by using HANA Studio
• Created Variables and Input parameters in HANA Views.
• Created IDT universe by consuming HANA Views and created folders and objects as per report requirement.
• Extensively Worked on SAP HANA Data Provisioning using SAP LT Replication Server (SLT).
• Created Schemas, table definitions, Attributes, Measures & Hierarchies in HANA.
• Good Knowledge in SAP HANA security including User Management, Roles and Privileges
• Migrated Universe and Reports from Dev to Test and Test to Prod environments.
• Scheduled WebI Reports and distributed them to users in PDF, Excel formats.
• Extensively involved in creation of BEx Reports. Worked on Calculated Key Figures Restricted Key Figures, Free Characteristics, Filters.
• Created and Developed BW Queries Using BEx Report Designer to suffice teh report requirement
• Supported production applications and resolved tickets wif in SLA

Environment: SAP Business Objects 4.0,4.1, SAP HANA 1.0, WEBI, Query Designer, Dashboards 4.0, SAP BW 7.3.

Confidential

Business Objects Consultant

Responsibilities:

• Actively involved in gathering requirements from end users.
• Prepared Technical System Design document.
• Created Business Layer to meet end user reporting requirements by using IDT
• Created Folders and Objects
• Achieved row level security
• Created Crystal Reports
• Involved indata migrationfrom various corporate systems and interacted wif end users and functional consultants.
• Understanding source systems and customer requirements.
• Created teh dashboards using Xcelsius Dashboard 4.0 for teh Inventory Management.
• Created Universe using IDT 4.1.
• Created Data Foundation Layer based on teh Star Schema Concept.
• Created Business Layer base on teh Data Foundation Layer.
• Resolving Loop Using Context and Alias.
• Created Static List of Values in Data Foundation for Query Prompt.
• Created Derived Tables based on teh existing database tables.
• Exported teh universes to teh Repository to make resources available to teh users.
• Created Dashboards using teh Universes as teh main data Providers in BI4.0.
• Created complex Dashboards using query browser.
• Worked on various components in teh Dashboard.
• Exported teh data from teh dashboard to teh webi using open doc syntax
• Created URL’s to pass teh parameters from teh dashboard to teh webi download
• Created teh Users and Groups and assign roles and security to teh users.
• Involved in Daily and Monthly Status Meeting for teh Inventory Management Project.
• Converted existing Universe (.unv file) to Business Layer (.unx) and pointed all teh documents to Business Layer (.unx file) and tested them.
• Managed and Supported Production Systems and resolved many production issues wif in SLA.

Environment: Windows Server 2008, Windows 7, SAP HANA 1.0 and SAP Business Objects 4.0.

Confidential

Business Objects Developer

Responsibilities:

• Restarted servers on weekly basis and Monitored services regularly.
• Migrated universes and reports from one environment to another environment by using LCM (Life Cycle Manager).
• Improved Server Performance by changing teh server parameters.
• Involved in full life cycle of Business Objects reporting Application.
• Analyze teh reporting requirements wif teh business users and come up wif teh Technical specifications for Universe and BO Reports.
• Modified Universes using OLAP Data sources and Databases.
• Created Context, Alias to resolve teh Loops in teh universe.
• Created teh Reports using Business Objects functionalities like, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.
• Applied graphical representation of reports such as Bar Charts, Pie Charts as per teh end user requirements
• Created Trend Reports wif Charts and drill down on Sales.
• Created User Prompts, Conditions and Filters to improve teh report generation.
• Created Hierarchies from providing drill down options for teh end-users.
• Involved in resolving teh previous reporting issues and trouble shooting.
• Reviews of changes handled by other team members.
• Documented all teh changes made to teh universe and reports for future reference.
• Created webi reports on top of BEX queries.

Environment: Windows 7, SAP BW, SAP BO 4.0, WEBI, CMC, LCM.

Confidential

BW/BO Developer

Responsibilities:

• Created user Prompts, Conditions and Filters for various reports to specify teh reporting parameters.
• Created WEBI reports wif different functionalities like Alerts, Sections, Sorting, Break, Filters, Input Controls, Merge Dimension and Ranking.
• Experienced in developing WEBI reports using advanced features including Hyperlinks, Ranking, Input Controls and Merge Dimensions.
• Used section, break, rank, Alerts, Filters, Sorts chart features in WebI document.
• Creating and Modifying Info Cubes, Data store Objects, Info Objects, Data Transfer process, etc.
• Created and Developed BW Queries Using BEx Report Designer.
• Involved in creation of Data Sources and Info Sources, for Data extraction, transformation and loading from SAP R/3 system & Flat File to SAP BI.
• Creating and Modifying Info Cubes, Data store Objects, Info Objects, Data Transfer process, etc.
• Working on Info cube, DSO, Multiprovider and Info Object Creations.
• Configured and extracted data from teh R/3 to BI System.
• Designed queries using restricted key figures, calculated key figures, Variables, Filter, Free Characteristics, Exceptions and Conditions etc.
• Maintained Info Cube and Creation of Info Package and scheduling teh data into teh Data Targets.
• Identifying Data sources, Installation of Data sources and editing as per requirement.
• Teh Business Content Cubes Activated like Customer (0SD C01), Sales Overview (0SD C03), Delivery Service (0SD C04), Purchasing Data (0PUR C01) and Vendor Evaluation (0PUR C02).
• Created various ad-hoc reports based on teh Business Users requirements using WEBI Tool.
• Experienced in working wif various types of Charts, Graphs and drill down reports.
• Scheduled Web Intelligence reports and managed teh instances using CMC.
• Applied graphical representation of reports such as Bar Charts, Pie Charts as per teh end user requirements.
• Developed Dashboards like Sales by State and Created Dashboards by Region Wise, Geographical area Wise, Top Sales of teh State and Top 5 Product wise Sales.
• Creation of Derived Tables, resolving loops, traps in universe 4.0

Environment: SAPBW, SAP Business Objects, Universe Designer, WEBI.