SUMMARY

• Certified SAP Business Objects consultant with around 10 years of experience in SAP BO and SAP BI environment and around 4 years of experience in Tableau.
• Experience in Business Objects XIR2, XI 3.1, 4.0, 4.1, Crystal Reports 2008,2011,2013,SAP Business Intelligence 7 and Tableau 7, 8 & 9.0.
• Experience in Tableau Desktop & Server 8.x/7.x in analyzing and creating highly actionable and interactive reports and dashboards by connecting to various data sources.
• Extensive Knowledge in development, maintenance and troubleshooting of Business Objects Enterprise Products using Business Objects XI Enterprise R2, XI3.0 and XI3.1 & XI R 4.0(Desktop intelligence, Web Intelligence), Business Object Universe, Designer, Infoview, Rich Client, Auditor, Migration and Business Objects Reporting
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues with in Tableau Server and Reports.
• In - depth knowledge on Tableau Desktop and Tableau Server.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.,
• Expertise in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.
• Experience in performance tuning of the server, views and dashboards
• Experience in content migration
• Extensively used Tabadmin/Tabcmd commands to perform administrative tasks like taking server backups, to restore processes settings, to change server configurations settings etc.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,
• Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator, experience including technical support, troubleshooting, report design and monitoring of system usage.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Extensive experience in supporting/maintaining/troubleshooting large amount of reports/universes/End user’s issues.
• Distinctive knowledge in Optimization techniques both at universe and report level.
• Created various data visualizations in Xcelsius
• Extensive experience in improving the testing productivity of the BO product when working with SAP.
• Worked on many new features of BO 4.0 in the developing environments.
• Possess excellent debugging and an analytical skill for problem determination of issues comes at different phases of implementation and support platforms.
• Involved in Deploying Business objects versions on Apache Tomcat.
• Hands on experiences in creating Xcelsius dashboards using BI web services
• Created various charts and maps in Xcelsius
• Expertise in building BI components like Info objects, data sources, Info cube, DSO, Transformations, Data Transfer Process (DTP), Multi providers and Master data Info Objects, Transfer Structures, Transfer Rules and Update Rules.
• Worked on BEx query designer and analyzer in building Queries, Columns, Rows, local structures restricted key figures, Variables, Exceptions, and conditions
• Profound experience in BO 4.0 Tools like Interactive analysis and IDT
• Working knowledge in Administration of the BO repository
• Proactively involved with the Testing team in efficiently improving the quality of the product.
• Works well individually or in a team environment and possesses excellent communication skills, both written and verbal.

TECHNICAL SKILLS

DBW Tools: Business Objects XIR2 and XI 3.0, XI 3.1, XI R4.0, Tableau Desktop 7.0, 8.0, 9.0 and SAP BI 7

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, Sharepoint.

Other Reporting Tools: SAP Business Explorer (BEx) Analyzer, BEx Query Designer, Crystal Reports 2008, 2011, 2013, Qlikview 9.0, Xcelsius2008, Live Office, QAAWS, SAP LUMIRA.

Environment: Windows 2008, windows 2003, XP.

Database: Oracle 9i/11g, SQL Server 2005, 2008, NoSQL,Ms Access 2000, Access

Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive

Language: ASP.Net, HTML, C, C++, Java, SQL

Application Servers: Apache Tomcat 5.x 6.0

Other Tools: Toad, WinSql, Clarity 14.0.13, Confluence, and Jira.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Ohio

Sr. SAP BO/Tableau Developer

Environment: Tableau Desktop 8.0, Tableau server / Administrator, Business objects 4.1, SQL Server 2008.Crystal Reports 2013,Hadoop

Responsibilities:

• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created various highly interactive dashboards and data visualizations reports for Rate Quote consolidation system.
• Developed multiple reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Involved in Tableau Server Installation and Configuration, creating users, groups, and projects and assigning access levels.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Developed SQL scripts to generate XML to view in Xcelsius developed dashboards
• Optimized SQL scripts to improve the efficiency on the database.
• Define / Develop SQL queries, Stored Procedures, and data mining as necessary in collaboration with the Database developer and BI Team as needed
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI’s
• Experience in content migration to higher versions
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to Create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server
• Manage Production, Test and Development environments including installation of patches, security administration and access controls.
• Administered users, groups, workbooks, data sources in the server
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created custom Function's (Date range, Time functions, array functions, and Conditional formatting functions) in the reports.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Integrated Business Objects and SAP Business Intelligence as data sources forTableau.
• Migrated Crystal Reports from Crystal Reports XI to Crystal Reports Server 2013 Enterprise
• Created Crystal Reports upon user request with rich content look and Parameters
• Created Crystal Reports Which Involves Dynamic Prompts on Dates, Years and Quarters

Confidential, NY

SAP BO-Tableau Developer

Environment: Tableau Desktop 7.0, SAP Business Objects 3.1 and SAP Business Intelligence 7.3,SQL Server 2005,2008

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications
• Designed, developed, tested, and maintained Tableau reports and dashboards based on user requirements.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as providing access to the users and adding them to the specific group.
• Strong report/dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Provided customer support to Tableau users and Wrote Custom SQL to support business requirements.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
• Integrated Business objects with Tableau and OLAP cubes with Tableau

Confidential, NYC

Sr. SAP BI-BO/ Tableau Consultant

Environment: SAP BI 7.0, SAP BO XI3.1, Tableau 7.0, SQL Server 2005, Teradata 12

Responsibilities:

• Responsible for interacting with the customers, understand their requirements, designing testing and troubleshooting Business Objects Universes and Reports
• Used import wizard in the migrating environments.
• Responsible for all the Business Objects reports and defects.
• Modifying and creating the reports based on the user requirement.
• Created front end business objects reports on Bex Queries
• Created Bex reports and executed in Bex Analyzer.
• Tested the universe structure to ensure the tables are properly updated along with the database.
• Replicating the bugs in different BO versions in different operating systems and forwarding the same to Product group for the Fix.
• Provided support for the users on application usage and conducting training walk through of salient Features of the application
• Mentoring other team members in Business Objects Architecture and Functionality.
• Used BO XIR4 Interactive analysis (Webi) to create the front end reports on Bex Queries
• Extensively used advanced functionalities in Interactive analysis (Web intelligence) to full fill the complex Calculations
• Worked on query performance tuning techniques in BO
• Handling Job Failures
• Identifying the issues at BW level as part of production support
• Involved in making small changes like assignment of Navigational attributes at Multiprovider level
• Creation and maintenance of BI objects (InfoCubes, DSO objects, Infosource, Multi Providers).
• Development of Transformations, DTP, Data Sources (flat file source system), Update Rules and Transfer Rules for BI data flow.
• Developed data loading strategies for master data, transactional data and delta uploads.
• Scheduling and periodic monitoring of extractions through Info Packages and Process Chains.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
• Extracted and loaded data from SAP R/3 into Sales Order InfoCube using DataSources.
• Created Multiprovider on sales and delivery cubes to assist reporting on sales and delivery together.
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively.
• Extensively worked on Query Designer and Web application designer to create Queries to forecast salesbudget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
• Created ODBC connection to integrate webi reports data to Tableau
• Created detail reports in Xcelsius
• Created various data visualizations in Xcelius Dashboards
• Developed data visualizations for higher level management using Tableau Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.,
• Expertise in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,

Confidential, San Jose

Environment: SAP Business Objects 3.1/4.0, BW 3.5, Xcelsius 2008, Oracle 10G, SQL Server 2005

Responsibilities:

• Created and maintained Transfer Structures, Communication Structures, Transfer Rules and Update Rules for InfoSources, ODS objects and InfoCubes.
• Created and maintained Aggregates and Rollup activities as a part of the Infocube Management.
• Implemented several Process Chains for automated data upload.
• Performed LO-Extraction for loading data from SAP R/3 to SAP BW.
• Set up procedures for extracting data from SAP R/3 by using Generic Extraction and Customizing LO Cockpit as per requirements.
• Designed, developed and scheduled process chains for master data loads and transaction data loads with the help of Info Packages.
• Developed queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables etc. for customized reporting using BEX Analyzer, Designed.
• Developed several workbooks and global views.
• Installing Business content in BW and R/3, Activated data sources in R/3 for Transaction data and Master Data.
• Enhanced data source structures and implemented User Exits according to user requirements.
• Designed and developed custom data sources with the help of RS02.
• Installed and modified several business content Info Objects.
• Created and activated several Infosources, ODS, InfoCubes and Multi-Providers.
• Designed and developed reports with filters and free characteristics while implementing conditions and restrictions based on requirements.
• Utilized Hierarchies in the reporting to provide drilldown features.
• Sourced HR data like Personnel and Time Management and Financial data (Payroll) into the Infocube.
• Configured the Enterprise Structure and Employee Structure as per client requirements as part of sourcing Personnel Administration data.
• Worked with Client Payroll Schema and its related sub schemas, as part of sourcing Payroll data.
• Integrated several modules from the HRIS data into Infocubes.
• Maintained both the Master data and Transaction data in the Infocube created for HR.
• Created and maintained Employee Hierarchy Reports, Employee Performance Reports using BEX Analyzer.
• Developed variety of reports like Employee Joining Report, Working Hours report, Payroll reports.
• Utilized Restricted Characteristics functionality to limit selection on certain details in some reports, like Payroll.
• Replicated bex queries in Xcelsius for data visualizations to higher level management
• Converted business objects dashboards to tableau data visualizations
• Created rich data visualizations using best practices in Tableau
• Experience in creating view using Dual Axes charts, Histograms, Filled map, Bar chart, Line chart, Box and Whisker Plot, Stacked Bar etc
• Created KPI’s for different scenarios in Tableau view
• Experience in Tableau server in scheduling the view and publishing them to serer from desktop

Confidential

Environment: Business Objects XI Enterprise R2, XI3.0, XI3.1, Oracle 9.2, Apache Tomcat.

Responsibilities:

• Responsible for interacting with the customers, understand their requirements, designing, testing and troubleshooting Business Objects Universes and Reports for various clients of Business Objects.
• Used Import Wizard, Report conversion tools in the migrating environments.
• Responsible for maintaining and creating the universes, Deski and Webi reports.
• Modifying and creating the reports basing on the user requirement.
• Provided service to customers in troubleshooting of complex and critical reports by providing the absolute and feasible solutions
• Designing of complex report layouts using Business Objects reporting tools for various customers of SAP Business Objects all over the world.
• Interacting with users (all around the world) in collecting requirements and on design discussions of Business Objects universe and reports.
• Created Sub reports using Opendoc function in Webi and Deski.
• Added/created complex objects to the universe to enhance the report functionality.
• Tested the universe structure to ensure the tables are properly updated along with the database
• Replicating the Bugs in different BO versions in different operating systems and forwarding the same to Product group for the Fix.
• Helping the customers to upgrade or move their repositories to different patch levels.
• Mentoring junior level support engineers in Business Objects Architecture and Functionality.
• Meeting with UK and US counter parts to discuss status on the projects.

Confidential

Environment: Business Objects XI Enterprise R2, XI3.0, Oracle 9.2, Apache Tomcat.

Responsibilities:

• Involved in Installing the Business Objects XIR2, creating Repository, creating Users and User Groups using Central Management Console (CMC) and setting appropriate rights.
• Involved in designing, developing & testing the universe and reports for the customers across the APAC Regions.
• Installation and configuration of Business Objects XIR2 Enterprise Server Products on Windows.
• Installing the supported versions of web apps as per the PAR (Product Availability Report)
• Involved in creating objects with open document links in universe and thereby using these objects at the report level (full client and webi) for report navigation.
• Setting up the default and customer hierarchies at universe level for Multi-Dimensional analysis. (Drilling).
• Created Derived tables and @Aggregate awareness functions to improve performance of the Universe.
• Setting object and row level security restrictions in universe designer
• Using of Filters, Complex Conditions according to the customers requirement
• Solving the performance issues related Universes and Reports