SUMMARY

• 7+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• 5+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 8.1 as a developer and Administrator
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau 7.0/8.1.
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• End to end experience in designing and deploying data visualizations using Tableau
• Extensive experience working in Windows, UNIX, LINUX environments.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.0 to Tableau 8.1.
• Created incremental refreshes for data sources on Tableau server.
• Experienced in developing complex reports using Business Objects XIR3/XIR2 Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Experienced in developing the Webi reports using SAP Business objects 4.0/4.1.
• Well experienced in writing complex queries, stored procedures, functions, cursors and packages using PL/SQL programming.
• Extensive experience in development of DATAWAREHOUSING technologies.
• Experienced in developing the Dashboards using Xcelsius 2008.
• Expertise in creating Xcelsius dynamic Dashboard using SAP BI data/BEx Queries. Valuable knowledge on Xcelsius Dashboard Components like charts, selectors (Filters, label Based menus, hyperlinks), canvas containers.
• Designed, implemented and migrated complex Universes and Business Objects Reports, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
• Worked with Oracle, Microsoft SQL Server, Microsoft Access databases, and Excel Spreadsheet.
• Experienced in well designing staging tables at the data base level and performed data loads using ETL tools.
• Highlymotivated team player and aQuick Learnerwith good communication, strongproblem solving skillsand excellent in presentation and interpersonal skills. Extremely well organized, meticulous and highly self-motivated.

TECHNICAL SKILLS

Tools: Tableau 8.0/7.0, BO 4.1/4.0/3.1 Webi reports, IDT, Universe Design Tool, Dashboard Design Tool (Xcelsius 2008), Explorer, Crystal Reports.

ERP: SAP BW/BI.

Functionalities: Master/Detail, Slice and Dice, Drill up/down, Conditions, Filters, Charts, Alerts, LOV, Context, Aliases, Universes, Reports, @Functions, Formulas, Scheduling, Cross tab, Joins.

Database: Oracle, MS SQL Server 2008/2012, DB2, MS Access.

Languages: C, C++,SQL, PL/SQL, Java

ETL: SQL Server Integration Services (SSIS).

Operating Systems: Windows 98/2000/2005/2008/ XP/NT, MS DOS and Unix.

Packages: MS-Office

Web Servers: Web sphere, Apache-Tomcat.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles

Tableau Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models using ERWIN.
• Worked on Database design and Architecture.
• Involved in project planning, scheduling for database module with project managers.
• Created new Data source and replaced with existed Data source.
• Created Schedules and Extracted the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• 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
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that 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.
• Converted metric insight reports to tableau reports.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• See a comprehensive view of your sales pipeline and results.
• Access dashboards from any browser or tablet
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Data analysis and Adhoc workbook creation using Filtering Measures and Dimensions.
• Designed staging tables as per the requirement and used for the report creation.
• Created WEBI reports with complex calculations.
• Designed and maintained Universes and exported them to the repository.
• Developed Webi reports on SAP BW Queries using BICS in Business Objects 4.0/4.1.
• Design and development of Xcelsius dashboards as per the requirement.
• Extensively involved in creating database packages, procedure functions, cursors and triggers using PL/SQL.
• Developed complex webi reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement.
• Experienced in working with grouping, ranking, report variables and different functions in WEBI.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Extensive knowledge in SQL Server 2008/2012, SSIS.

Environment: Tableau Desktop 8.1/8.0/ 7.0, BusinessObjectsXIR3, IDT, CrystalReports, Xcelsius 2008, Web Intelligence 4.1/4.0/3.1, SAP BW, Oracle 11g/10g, SQL Server 2008/2012, Info view, Windows 2008 Server, .NET and Java based Applications.

Confidential, Richmond, Virginia

Tableau Developer

Responsibilities:

• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
• In charge of the team that build tableau architecture and dashboards using Tableau desktop, Tableau Server and Tableau Online.
• Working with User for requirements and part of the team developing the software.
• Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Created Global Filters and applied for all the views in the dashboard.
• Created Data Source and published into the server for other users.
• Good Experience on Data Blending.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server
• Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI ) and Measure
• Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports
• Created Web Intelligence Ad-hoc and canned reports in 3.1.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Troubleshoot issues with existing reports in the production environment.
• Created Views, Stored Procedures and validated data for the Performance.
• Developed various types of complex reports like Standard reports, Group reports, Detail and Summary reports, Crosstab reports, Graphical reports, drilldown reports, on Demand and Linked sub reports using crystal reports, tables, views, stored procedures, business views.
• Experienced in developing Dashboards using Xcelsius 2008.
• Provided daily production support and administration of portal operations, such as problem resolution.
• Worked closely with Data Modelers in designing various data warehouse schema techniques
• Create complex reports against SAP BEx Queries.
• Created the reports on the web by using Web intelligence .
• Worked on the data provider that forms the basis of the ad-hoc analysis

Environment: Tableau 7.0 (Desktop and Server), BusinessObjectsXIR3, Designer, Crystal Reports, Xcelsius, Web Intelligence, Info view, Oracle 10g, SQL Server 2008, Windows 2003Server, .NET and Java based Applications.

Confidential, San Jose, CA

Tableau & Business Objects Developer

Responsibilities:

• Involved in the design of the Application Business logic Components, which formed the architecture for distributed application development encapsulating business and data logic.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Navigation and drill down features were implemented in Tableau dashboards.
• Used advanced mapping techniques, Aggregate Calculations, Duplicate Data connections, swapping dimensions with parameters in Tableau workbooks and dashboard development.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Created visually compelling and actionable interactive reports and dashboards.
• Creating Backup scripts to take periodic backups for the content on Tableau server.
• Defining group/user level security standards for Tableau.
• Created, modified/maintained Products Universe.
• Created web based reporting using web intelligence.
• Created a component, which stores the total business logic of the portal, which contains many class modules related to business.
• Worked with Xcelsius dashboards.
• Developed, deployed, and managed Commerce applications for the Web.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in reports.

Environment: Tableau Desktop and Server, Business Objects 5.x, Erwin, Windows 2000, IIS 5.0, ASP, SQL Server 2005/2008, VB 6.0, COM, MTS, HTML, DHTML, MS Visual SourceSafe, VBA, Excel

Confidential, Denver, CO

Business Objects Developer

Responsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
• Created New Universes and Managed existing Universes
• Migrate, upgrade and test the Business Object XIR3 content/environment
• Setup, execute, and test the assigned programs utilizing BO XIR3 WEBI and DESKI tools
• Creation of multiple Universes and Linked Universes.
• Design complex Web Intelligence and Desktop Intelligence Reports
• Plan the implementation of migration to different Environments in Business Objects.
• Involved in the Data Warehouse design process
• Develop Dashboards for the higher management of the company
• Worked on extensive features of Business Objects XI including Index awareness, Derived tables and Input Controls
• Creation of reports, working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created reports using WEBI, DESKI, full client.
• Analyzed the reports using the Drill Through, Slice and Dice.
• Trained the users in viewing/scheduling the reports using the Info view and Designed security model for users to access the report
• Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects.
• Designed, developed, tested and maintained highly complex reports.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Deployed the reports by using Import Wizard (between DEV and UAT) and archived the reports.
• Used Business Objects supervisor to create repository, creating and managing the users, giving access permission for Business Objects Reports.

Environment: Business Objects XI 3.1/6.5(Web Intelligence/Desktop Intelligence), Designer, Import Wizard) Performance Management, Oracle 9i, DB2, AS/400, SQL Server, Windows XP.