SUMMARY

• Around 10 years of Experience in Business Intelligence with focus on Tableau Desktop/Server/Online/Reader/Mobile9.3/8.x/7.x, Business Objects XI 4.1/3.1 (Designer, Infoview, Web Intelligence, CMC, Query as a Web Service), IBM Cognos 10.x/8.x and Crystal Reports (2013/2011/2008).
• Experienced in interaction with business users, end users to gather requirements, clarify issues, training and co - ordinate with them in various phases of projects to provide end-to-end solutions
• Has 4+ years of Tableau experience including analysis, modeling, design, and development of Tableau, reports and dashboards for analytics and reporting applications.
• Strong experience in building Dashboards/Business Visualizations using Tableau against multiple data sources for What if Analysis, Interactive, Decision Support and other purposes.
• Extensive knowledge in various reporting objects like Measures, Dimensions, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Expertise in Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design, physical and logical data modeling.
• Extensive experience in designing dashboards, reports development and workbooks on various databases like Oracle, MS SQL Server, Google Analytics, Google Big Data, Teradata, MySQL, MS Access and Excel.
• Experienced in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Experienced in SAP Dashboard designer to create interactive dashboards by using Universe and Live Office.
• Utilized advance features of Tableau software to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Experience in Installation, configuration and administration of Tableau Server in a multi-tier environment.
• Worked broadly with Advance investigation Actions, Calculations, Parameters, Background pictures, Maps, Trend Lines, Statistics, and Log Axes. Groups, chains of commands using Tableau's Advanced Capabilities.
• Specialist in planning Universes and creating complex and Ad hoc Reports utilizing the Business Objects Reporter/Desktop Intelligence and Web Intelligence Tools.
• Involved in Tableau Server installation, configuration, creating Users, Groups,Projects and assign Privileges etc. and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Expertise in Tableau Desktop Development, inconvenience shooting, report design, execution tuning, determining issues and distributed dashboards, exercise manuals in Tableau Server.
• Experienced in developing complex reports using Business Objects WEBI Rich Client & Crystal Reports.
• Experienced in creating, maintaining, and modifying universes using IDT (Information Design Tool) and publishing reports on BI launch pad.
• Extensively worked on Business Objects Administration. Created Users and Groups and assigning security in Central Management Console (CMC). Scheduling of Reports in CMC on Daily, Monthly, Weekly basis.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
• Extensive knowledge in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation) and various methodologies like Agile.

TECHNICAL SKILLS

Reporting Tools: Tableau Desktop/Server/Online/Public 9.x/ 8.x/7.x, Business Objects XI 4.1/3.2/3.1/R2/6.x, IBM Cognos 10.x/8.x, WEBI, Crystal Reports 2013/2011,InfoView,QaaWS, Import Wizard, Live Office.

Databases: SQL Server 2012/2008/2005, Guidewire, Oracle 11g/10g/9i,MS Access, DB2,Concept One, MySQL.

Database Tools: Toad, SQLDeveloper

Operating Systems: Windows 10/7/Vista/XP, iOS, MS-DOS, UNIX, Solaris, Linux.

PROFESSIONAL EXPERIENCE

Confidential NC

Sr. Tableau Developer/Analyst

Roles & Responsibilities:

• Extensive development experience in Tableau Desktop/Server/Online/Public 9.3, SAP Business Objects 4.1 - including CMC, Info View, IDT, UDT, Web Intelligence and Crystal reports.
• Interacted with Subject Matter Experts (SME) and business users to gather requirements for the application, through one-on-one interviews, and worked on developing the business rules for cleansing.
• Worked as a TableauDesktopDeveloperfocusing on developing high-end visualizations driven by data coming in from various data sources including MS SQL Server, Oracle and MS Excel.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau desktop.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Experience in Integration of various data feeds from sources like Oracle, SQL Server, Flat Files and XML Files.
• Build Enterprise Reporting Capability, set standards for Semantic layer. Also set up a Big Data environment supporting all vendor extracts & prepare Reconciliation reports out of Facets.
• Developed different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Developed different views usingTableauDesktop that were published to the business stake holders for analysis and customization using filters and actions
• Worked on Business Intelligence standardization to create database layers with user-friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Created Custom complex SQL Queries to generate the data from data base and use it for making Innovate and Powerful Dashboards for easy Data Visualization and Forecasting in Tableau.
• Extensively used tableau features like Data blending, parameters, filters, calculations, context filters, Hierarchies, Actions, and Maps etc.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies in Tabelau.
• Served asTableauAdmin whose duties included configuration, adding Users, groups, managing licenses and data connections, scheduling Tasks, and embedding views in theTableauServer.
• Designed and Developed Webi Reports as per the Users Requirements. Experience using all the features in Business Objects including Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and formulae to analyze the data.
• Projected and forecasted future growth in terms of number of subscribers in various services by developing Area Maps to show details on which counties were connected the most and publishing it on TableauServer.
• Worked extensively with the major functionality of Business Objects like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Helped in figuring out where we can takeTableauin terms of visualization. Also trained end-users up to speed onTableaucapability.

Environment: Tableau Desktop/Server/Public/Online 9.x, Business Objects 4.1, Web Intelligence Rich Client, Crystal Reports, Live Office, ERWIN, SQL Server 2012, SQL Server Management Console.

Confidential, Atlanta,GA

Sr. Tableau Developer/Analyst

Roles & Responsibilities:

• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to acces the data on the fly with usage of quick filters for on demand information.
• Generated tableau dashboards with combination charts for clear understanding with different Data visualization Techniques like:Tree Maps, Geo Maps, Stack Bars and Line Graphs for Showing Trend with Dual-Axis and Data blending Technique.
• 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.
• Developed perspectives using modern counts like Table estimations, Logical computations, date figuring, and Trend Lines.
• Worked on Tableau administration tasks such as publishingworkbooks, settingpermissions, managingownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Generated Tableau Dashboards with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Designed and developedTableauvisualization solutions by connecting to Google Analytics, Oracle and SQL databases.
• Built and published customized interactive reports and dashboards. Administered report scheduling using Tableau server.
• Created report schedules, data connections, projects, groups inTableauserver.
• Utilized capabilities ofTableausuch as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations.
• Mastered the ability to design and deploy rich graphic Visualizations with drill down and drop down menu option and Parameterized usingTableau.
• Installed, administrated SAP Business Objects XI 4.0 on multiple servers (for load sharing) in Development and Production Environment.
• Assed the requirements from customers; proposed and built universes in snowflake schema and star schema model to suit the needs of the project.
• Built Universes and Framework Manager Models, and established the cardinalities to suit the business needs.
• Developed Hierarchies in the universes from PolicyCenter® and BillingCenter® to enable the multi-dimensional analysis in the reports using the drill feature.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/dynamic and static datasets.
• Worked on creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Indicators (KPI) and Measures in Tableau.
• Published the dashboard to the SAP Enterprise Portal, created an iView in SAP BI Portal to enable the access for the users to the dashboard.

Environment:: Tableau Desktop/Server/Public/Online 9.x, Business Objects 4.1, IBM Cognos 10.1.2, Web Intelligence Rich Client, Guidewire, Concept One,QaaWS, ERWIN, Oracle 11g, SQL Server 2008.

Confidential, New York City

Tableau Developer

Roles & Responsibilities:

• Member of Online BI and Analytic team, responsible of providing daily, weekly and monthly reports to support online business operation through analysis of key performance indicators and trends.
• Worked with the stake holders and business users to understand report requirements based on existing reports/dashboards in source systems and other teams on dependencies, timelines and testing.
• Built Dashboards from Tableau using Advanced Multiple Drill Down, Dynamic Visibility, and Alert Features with Flash Variables, web services.
• Created different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc. in Tableau.
• Worked on motion chart, Drill down analysis using tableau desktop for BML eBay & PayPal.
• Created Visuals for Paypal team workflow optimization using different Tableau charts such as KPIs and sparklines in a single view
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Developed Hierarchies in the universes to enable the multi-dimensional analysis in the reports using the drill feature.
• Created SQL scripts for testing and validating data on various reports and dashboards and handled performance issues effectively in Tableau.
• Documented a whole process of working withTableauDesktop, installingTableauServer, evaluating Business Requirements and proposing System Requirements.
• Defined best practices for Tableau report development. Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis) using Web intelligence.
• Involved in overall coordination regarding Installation, configuration and setup ofTableau environment at the client location.
• ConnectedTableauserverto publish dashboard to a central location for portal integration.
• Created ad-hoc reports in Web Intelligence (Info view) and published and maintained them in Central Management Console (CMC). Scheduled to run them on timely basis to be distributed to end users.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and excel.
• Developedtableaureports including highlight tables, stacked bars, side by side bars, symbol maps, filled maps, heat maps
• Also created demo-able marketing database (logical and physical data modeling) to show BI tools (Business Objects and Tableau) functionality.
• Worked as a liaison between client team, account team and BI development team.

Environment: Tableau Desktop/Server/Public/Online 9.x, Business Objects 4.0, Web Intelligence Rich Client, Crystal Reports 2011, 1 Import Wizard, Live Office, Xcelsius, QaaWS, Oracle 11g, SQL Server 2012, SQL Server Management Console.

Confidential, Kansas City

Sr. Business Intelligence Developer

Roles &Responsibilities:

• Collaborated with business users and members of the BI team, including business analysts, data warehouse developers, and managers, to design and develop reports and dashboards as per requirement.
• Interacted with Tableau and Business Objects users by conducting meetings to discuss the projectsenhancements/requirements.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Extensively used Tableau features like Data blending Extracts Parameters Filters Calculations Context Filters Hierarchies Actions Maps etc
• Extensively involved in design and development ofTableauvisualization solutions using operational dashboards.
• Identify and resolve the potential universe issues like loops, Chasm Traps and Fan Traps and resolved them using techniques like Contexts and Aliases.
• Extensively used formula fields, parameter fields, Running Total Fields, Group selection, record selection, and Crystal syntax in Crystal reports.
• Wrote training guide for end users (Developer Edition, User Edition) for Business Objects and Tableau.
• Worked closely with all team members in implementingTableauBI tool in the project.
• Developed interface Creating Dynamic Dashboards. Data can be exposed different levels By Drill down functionality.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Server. Creating new schedules and checking the tasks daily on the server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created complex reports using functions like @variables, @prompt, condition Objects and aggregate Awareness Functions.
• Created WEBI reports and exported the report content as web service to feed the input to Xcelsius dashboards.
• Created IDT connections in dev, test and prod for active reporting.
• Created multiple new universes in BO 4.0 as per the requirements adding new classes and objects. These universes were designed to support multiple levels of hierarchies for drill down functionalities.
• Responsible for Developing and Maintaining and the Business Objects Universes.
• Developed reports using universe and excel data source and used merged dimensions to synchronize the queries.
• Creating the Dynamic and static dashboards using LiveOffice and QaaWS as source.
• Providing the production support and maintaining the SLAs and promoted the code between the environments.

Environment: Tableau Desktop 7.0, Business Objects 4.0/ XI 3.1, Web Intelligence Rich Client,Crystal Reports 2011, Desktop Intelligence, Import Wizard, Live Office, Xcelsius, QaaWS, SQL Server2007, SQL Server Management Console.

Confidential

Roles &Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes and responsible for analysis on crystal reports migration.
• Developed Web Intelligence reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Expertise in resolving joins path problems like Loops and Traps in the Universes using Aliases, Contexts, and Aggregate Awareness in Business Objects Designer.
• Extensive Knowledge in using Business Objects functionalities like Slice and Dice, Drill down, @ Function, Cross Tab, Master Detail, and Complex Formulas.
• Managed users and groups and implemented folder level and application level security in the CMC
• Developed complex reports in Crystal Reports 2008 from multiple data sources, used stored procedures and SQL queries.
• Created SQL statements to verify the data in reports against data in DB.
• Effectively used Database level views and created Derived tables at the Universe level to optimize the Overall Performance
• Scheduled the reports on daily, weekly and monthly basis by using Scheduler.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the Web Intelligence report.
• Improved the performance and reduced the coding with the use of @aggregate aware and tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Worked extensively with the major functionality of BusinessObjects like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008.
• Migrated Crystal Reports 8 to Crystal Reports XI and also responsible for testing and publishing reports.
• Involved in BusinessObjects Support, Problem Solving, Trouble shooting and developing End user Notes.

Environment: Business Objects XI 3.0/R2/6.5, Web Intelligence Rich Client, Xcelsius 2008, Crystal Reports, Infoview, Teradata 13.0, TOAD, Windows 2003 Server.

Confidential

Roles & Responsibilities:

• Managed over 400 users and 30 groups in the entire Business Objects suite
• Involved in resolving problems like ‘Chasm Traps’ and ‘Fan Trap’.
• Created publications using Dynamic Recipients and Enterprise Users. And delivered the report content as inline email using HTML format.
• Created and customized application dashboards using Application foundation to meet the requirements of higher level analysis.
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Involved in migrating code between the dev - test - production environments.
• Created critical visualization using Business Objects Crystal Xcelsius for the Business Dashboard.
• Created predefined conditions in universe to make the filters readily available for the ad-hoc report writers
• Created summary reports in web intelligence using extended syntax operators like ForAll, ForEach and ForIN
• Involved in SQL tuning for better performance while generating Ad-Hoc reports.
• Created and ran ad hoc queries to Test and validate the data pulled in BO reports.
• Updated and maintained Universes to meet new reporting requirements
• Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
• Configured File Repository Servers, Crystal Report Job, Cache and Page Servers, LOV Job server, Web Intelligence Job and Report Servers, Desktop Intelligence Job, Report and Cache Servers, Destination Job Server, Program Job Server, and Event Server.
• Imported data from Business Objects 6.x & Crystal Enterprise 10 to Business Objects Enterprise XIR1
• Configured BO Server Products like WEBI and BCA Publisher & Auditor on different nodes in Distributed Environment
• Worked with database connections, SQL joins, cardinalities, loops, aliases, materialized views, views, aggregate conditions, parsing of objects, LOVs, and hierarchies.
• Scheduled Business Objects Reports using Broad cast Agent and scheduler

Environment: Windows XP, server 2003, Oracle9i, Business Objects 6.5,Designer, WEBI, Publication Wizard, Broad cast Agent, Supervisor, Business Query, Info View. Oracle, MS SQL Server.