SUMMARY

• Around 7 years of systematic and vast experience in Business analysis, Business Objects 4.0/4.1 and Tableau as techno functional consultant.
• Experienced in Tableau (Desktop, Server, Online, Reader), Data Analyst and Business Analyst especially in Business Intelligence applications
• Having good hands on experience in development and implementing of end - 2-end DW&BI solutions with BI tools like BO 4.1, Crystal Reports, Design Studio, Xcelsius4.5/2008, CMC,SAP BO Explorer, IDT, SAP BI/BWS
• Experience in implementing Business Intelligence and Data-warehousing solutions using Business Objects 4.1/4.0/XIR3.1/R2 and SAP BI for RDBMS, OLAP Sources and HANA.
• Specialize in migration to SAP BO XI R4.0 Universe Information Design Tool (IDT), Web Intelligence Reporting, SAP Dashboard 4.0 (Xcelsius) and Crystal Report 2011.
• Worked on SAP Lumira 1.20, 1.28 and created Story boards locally.
• Connected SAP Lumira Story Boards to different data sources such as BW BEX, HANA Views and relational Universes (. UNX)
• Experience in using Information design tool (IDT), to create universes using multiple Relational Data Sources.
• Converted Xcelsius dashboard to Design Studio 1.5,1.6
• Expert in creating Dashboards with Dynamic prompts, Drill Downs, Dashboard Jumps and other complex Functionalities on both SAP and NON-SAP Data Sources
• Expertise in creating custom script for Design Studio dashboards
• Expert in creating Design Studio dashboards using BW BEX queries and SAP HANA Views
• Highly proficient in Agile, Scrum and waterfall Software Development Life Cycle (SDLC).
• Worked extensively on creating the BEX Queries using BEX Query Analyzer.
• Leading both Support and Development teams successfully for Onsite & Offshore activities and initiated daily/weekly status review meetings with Customer.
• Hands on experience in publishing of various kinds of interactive dashboards and workbooks from Tableau Desktop to Tableau Servers.
• Experience inTableauOnline, and Tableau Reader.
• Expertise in creating filters, quick filters, context filters and creating Dashboards for key performance Indicators.
• Strong SQL Skills related to information retrieval and analysis
• Created worksheets by implementing different joins (left, inner, right, and outer joins), data blending and custom SQL and data source filters based on business requirements.
• Experience in creating Data Blending by merging data from different datasets. Created visualizations using scatter plots, Gantt charts, Bubbles, Bullets, Heat maps.
• Experience inTableaureport developing, testing and deploying reporting solutions usingTableau Server.
• Experience in creating Database Objects like tables, constraints (Primary Key, Foreign Key, Unique, default, Indexes).
• Expertise in writing SQL Queries, complex joins for generating complex Stored procedures, User-defined functions.
• Experience in creating Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.
• Data manipulation using Hive scripts in the Hadoop platform for Tableau reports.

TECHNICAL SKILLS

Reporting tools: Business Objects XI 3.1 SP1, SP4, Business Intelligence Platform 4.0 SP4, 4.1 SP2, Xcelcius/Dashboard Designer, WEBI, BOBJ Explorer, Crystal 2008/2011, SAP Design Studio1.5,1.6, Analysis for Office, Analysis for OLAP, Design Studio 1.2, SAP Lumira 1.20,1.28, 1.30,1.31,Tableau (Desktop/ Server), Qliksense, OBIEE

databases: Oracle, MSSQL Server, MYSQL, Teradata, Hadoop Hive

scripting languages: C, Html, SQL

data modeling tools: OBIEE

big data: Hadoop, Hive

Data Ware Housing Tools: SAP BI 7.3, BI 7.0 in Nw2004’s, BW 3.5 and 3.1C

PROFESSIONAL EXPERIENCE

Confidential, Irving, Texas

SAP BO/ Tableau Consultant

Responsibilities:

• Worked with the team for various reporting solution needs on SAP BOBJ including Lumira, Design Studio, WEBI, Crystal, Dashboards
• Lead the effort of migrating to newer tools such as Design Studio and Lumira for existing reports.
• Developed Design Studio 1.6 Applications and advised improvements over Dashboards
• Held White boarding sessions with users for aligning the design requirements for Design Studio
• Lead the efforts in upgrading Design Studio 1.5 to Design Studio 1.6
• Worked and familiar with new features of design Studio 1.6 like Advanced selection in Scorecard.
• Familiar with new features of design Studio 1.6 like Visualizing Row Selections in Scorecard and Using Multiselect in Scoreboard.
• Experienced the new feature as Spreadsheet Component of Design Studio 1.6 in which a component which is capable of planning with copy and paste support like an excel grid for data entry. familiar with upgraded features like SAP Business Objects Design Studio 1.6 Scorecard Component
• Used custom code for Design Studio conversion
• Developed highly complex dashboards from the mocked up storyboards using SAP Design Studio
• Wrote and used complex CSS scripting to format the components in Design Studio. CSS Scripts used on the components in CSS Class and CSS Style sections.
• Developed dashboards using most of the components that are pre delivered by Design Studio. For Ex: Date Field, Crosstab, Chart, Dimension Filter, Grid Layout, dropdowns etc
• Used complex java scripting techniques to develop dashboards and provide functionalities like data binding, dynamic visibility, variable handling etc,
• Created arrays and loops in Design Studio to handle the selected data and to pass it to HANA for filtering.
• Installed 3rd party custom components using Design Studio SDK for providing the users with some components like gauges, maps which are not delivered by Design Studio by default.
• Enabled background processing in Design Studio to handle the serial processing of data sources thus increasing the performance of the dashboard.
• Tuned the performance of dashboards by scripting in Design Studio to minimize the number of data sources used and manipulate the data in the whole dashboard with less number of data sources.
• Review, Refine and Validate Data Generated Reports in Excel and SAP Lumira
• Created story boards by using different charts and filters on SAP Lumira 1.28
• Experienced in connecting Lumira story boards with Design Studio 1.5
• Configuration of BOBJ Add-On for SAP LUMIRA.
• Developed story boards on Lumira 1.28 to be able to save on BI Lunch pad instead of SAP Lumira Cloud services.
• Familiar with upgraded Features like wildcard support, combined stacked column line charts Query Panel Extension prompting enhancements in SAP Lumira 1.28
• User support for BEx and all of BOBJ suite including WEBI, Crystal, IDT, Dashboards
• Worked on various Fronted issues in BEx and BOBJ Reports
• Created template for dashboards and WEBI reports using SAP Best Practices for enterprise wide use with standard color coding and labeling for better supportability
• Used Open Doc links for Jumps from Dashboard to dashboard and WEBI reports
• Multi Source Universe creation using BO 4.0 IDT tool, Relational Universes, WEBI reports, Dashboards.
• Worked closely with WEBI Reporting team on the requirements.
• Designed Universes using IDT with Multi source data sources and defined Connection layer such as Data Foundation Layer and Business Layer and published the universes.
• Developed Detail reports with rich formatting and complex formulas for further drill down form Dashboards
• Resolved Issues with backend systems to ensure efficient performance of the dashboards
• Used Query Browser and Web service connections for dashboards
• Redesigned the existing complex dashboard into simple and functional dashboards
• Created WEBI reports using Prompts, filters, Variables, Merged Dimensions and various Manual cell Calculations
• Created WEB Services for using the crosstab data which can be directly used in the Dashboard Designer.
• Created many complex Variables and Prompts in BOBJ according to the end user requirements.
• Created Documentation for Requirements gathered, Development and Testing Phases
• Created WEB I reports using Prompts, filters, Variables, Merged Dimensions and various Manual cell Calculations
• Created WEB Services for using the crosstab data which can be directly used in the Dashboard Designer.
• Resolved Issues during Integrated Testing and UAT with a short turnaround time
• Created objects in the Universe using various formulas and variables as per the requirements of the user.
• Once the universe is done, Developed Reports using Web Intelligence tool. During the development of the reports, had an extensive interaction with the users regarding the progress of the reports and also clarified certain issues with them.
• During the development of the Reports, used different formulas and complex variables so that they precisely meet the requirements of the users.
• During this phase of development, worked with SQL SERVER 2012 in order to validate the data from the database
• Prepared the documentation and any other supporting documents that are needed for the end users.

Environment: SAP BO 4.2/4.1/4.0, SQL SERVER 2012, Information Design Tool, WEBI, BI Launch Pad, and Windows XP/2007.

Confidential, Naperville, Illinois

SAP BO Consultant /Tableau Developer

Responsibilities:

• Involved in requirements from initial phase of the project and vendor Interacted with Business users to understand business needs and prepared technical specifications.
• Involved in database discussion with Architects for creating specific business need tables.
• Analyzed all Ad-hoc requests flow and created KPI dashboards, generic Webi reports to reduce ad-hoc flow.
• Worked with SAP Business Objects BI 4.2/4.1/4.0 Suite tools (IDT, Dashboards, Explorer, BI Launch Pad), Lumira and Salesforce Reporting.
• Created multiple universes using UDT and IDT, business friendly classes, objects, complex measures by providing different business views by including contexts, aliases and derived tables.
• Experience in performance tuning the dashboards with Design Studio 1.5 by utilizing the parallel datasource execution
• Experience in building dashboards connecting to various datasources like SAP HANA, SAP BW, SQL
• Created simple to complex dashboards and static to dynamic dashboards as per user requirements
• Created dashboards using new components delivered in Design studio 1.5 like Scorecard,
• Experience in working with SAP in resolving the issues by creating tickets and following up
• Experience in training the end users getting used to a dashboard or while transitioning from other dashboarding tool
• Experience in customizing the components by overwriting the styling properties and setup as a template across the company for all the business units.
• Worked with the different methods in the design studio like Setfilter, Setitems, Getmemberlist, setSelectedValue etc.
• Designed and developed the dashboard template using CSS and standardized the layout across organization
• Experience in working with different aspects of Scorecard component like visualizing row selections, Multiselect..
• Experience in designing the dashboard that has export capabilities to PDF, Excel thus providing rich experience
• Installed 3rd party extensions like Dials, Guages and more contemporary graphs using SDK and deployed on both desktop and SAP BI platform
• Developed dashboards in Design studio that are mobile compatible
• Utilized the RRI(Report-to-Report) feature in Design Studio to jump from one application to another application. Configured both backend connections and front end settings to enable RRI in Design Studio.
• Created Manual Refresh Button in Design Studio Dashboard to enhance the performance. This helps the user to refresh part of the dashboard without loading the whole page using a browser refresh button.
• Experience in developing dashboard prototypes using Design Studio with Offline data feature in
• Defined Hierarchies in universe to provide the users with drill down option in reports and pre-defined conditions.
• Created Webi Reports in info view and BI launch pad with slice and dice, drill up and drill down, hyper link functionalities to make business analysis easier.
• Created/Enhanced Crystal Reports for Business needs.
• Used filters, conditions, list of values (LOV), calculations, Created Objects, Predefined Conditions, and Joins in the Universe.
• Helping end users with questions/issues, troubleshooting failures to identify root causes.
• Review reports, dashboards and universes to meet best practices.

Environment: SAP Business Objects 4.2/4.1/4.0 (IDT1.5, UDT, BI Launchpad, Explorer, Dashboards, Web Intelligence), Explorer, DB2-SQL, SQL Server, Netezza, Lumira.

Confidential

Business Analyst/ Tableau Developer

Responsibilities:

• Involved in Full life cycle design and development of Business Objects Enterprise Applications.
• Involved in gathering the requirements from Business for reports development.
• Identified the Metrics and sub metrics, Key performance indicators(KPI’s) for Dashboard development.
• Worked onmultipledata providers to develop the dashboards coming from different sources.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in tableau desktop.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created custom Locations on Maps using Longitude and Latitudes.
• Creating users, groups, projects, Data Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver. Creating New Schedule's and checking the task's daily on the server.
• Developed and reviewed SQL queries with use of join clauses intableaudesktop for validating static and dynamic data for data validation.
• Involved in testing the SQL scripts for Tableau reports and Dashboards.
• Designed Stored Procedures while generating the reports and tested them against Oracle Database
• Identified critical areas of business risk and modified business processes to reduce risk by using the Risk-Management Process
• Identifying & Managing risks, Resource analysis, Cost analysis, Post project analysis & coordination among cross-functional teams & follow-up with clients for settlement of project based issues

Environment: Oracle, Tableau 8.x/9.x (Desktop / Server).

Confidential

Tableau Developer

Responsibilities:

• Participated in requirement gathering meetings and translated business requirements into technical design documents
• Synthesized and translated Business data needs into creative visualizations in Tableau.
• Performing joins to combine data from SQL and Oracle by performing relevant mapping.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Developing Reports and creating metrics, hierarchies and filters using Tableau Desktop.
• Developed various reports using best practices and visualizations such as Lollypop Charts, Donut Charts, Funnel Charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles, Scatter Plots, etc.
• Developed reports comparing multiple measures using Individual Axes and Dual Axes.
• Created SQL scripts for testing and validating data on various reports, dashboards, and scorecards and handled performance issues effectively in Tableau.
• Worked in user management, group management and permission management for accessing dashboards based on security requirement.

Environment: Tableau (Desktop/Server) 9.x/8.x, Oracle11g.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in designing the application database.
• Developing program specs based on Functional specifications
• Wrote Views,PL/SQLprocedures and function for processing business logic in the database.
• Used Unix Shell Scripts scheduling processes.
• Worked on AdvancedPL/SQLtechniques including Collections, Materialized views, external table, Bulk Collect and more.
• Involved in Designing of Data Modeling the, Design Specifications and to analyze Dependencies.
• Responsible for creating and maintaining the packages, stored procedures, functions and cursors.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Involved in Unit level testing, Module level testing and System testing.
• Involved in preparing functional specifications, release notes, & documentation using

Environment: Oracle 11g, PL/SQL, Toad developer.