SUMMARY:

• Around 8 years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 9.0 as a developer and Administrator
• Highly Experienced in working with interactive Dashboards, Metadata layer and different types charts in Tableau for different users
• End to end experience in designing and deploying data visualizations using Tableau
• Extensive experience working in Windows, UNIX, LINUX environments.
• Well Experienced in web technologies like HTML, CSS, JavaScript
• Developed property SAS macros that redefined company’s efficiency in data cleaning and reporting
• Good knowledge in performing statistical analysis using R, SAS and Python.
• Connected to SAS ODBC data source from tableau desktop for building an executive dashboard
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Experienced in well designing staging tables at the data base level and performed data loads using ETL tools
• Tested and explored new releases of Tableau Application and drivers, suggested and supported users with proper drives installation
• Performed statistical analysis using control charts which helped the team in determining the root causes
• Created dynamic reporting with the use of SAS and Microsoft Excel
• Performed Regression analysis in Tableau 10.0 desktop to find the fields which are determining the cost and analyzed them
• Developed Trend Lines, Statistics, and Log Axes, Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
• Maintained Security and Create/manage users, Groups, Licenses and integrated with Active Directory
• Scheduled the reports to run on daily/weekly basis and published the reports created to the Tableau Server
• Administered and supported tableau Infrastructure including Upgrades, testing, Security Administration, License Management, troubleshoot workbooks, Performance Monitoring and System maintenance
• Created Tableau reports from the Teradata data sources within Volume 2 Value Reporting team
• Experienced in Business Intelligence Reports, Dashboards, Project Management, Root cause analysis, Resolution Methods Time/ Cost/Budget Management
• Worked on various data sources such as Oracle, Teradata, SQL Server for reporting
• Created universes on Teradata and SQL Server, DB2
• Scheduled the reports to run on daily/weekly basis and published the reports created to the Tableau Server
• Developed List, cross tab, drill through, master - detail, chart and complex reports which involved Multiple Prompts, Conditional formatting, Conditional blocks in ReportStudio and used style sheets.
• 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
• Experienced in creating reports using Business Objects Universes, Power BI, webi and Crystal reports
• Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle
• 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.
• Worked with Oracle, Teradata, Microsoft SQL Server, Microsoft Access databases, and Excel Spreadsheet.

TECHNICAL SKILLS:

ETL Tools: IBM Info Sphere / Web Sphere

Datastage: 8.5 /8.1/8.0 /7.5 (Designer, Director, and Administrator), Info Sphere

Reporting Tools: Tableau, Power BI, OBIEE, SAS

Database: Teradata, MS SQL Server 2005/2000, DB2, Oracle

Languages: SQL, PL/SQL, UNIX Shell Script, PERL, Teradata-BTEQ, TPT

Data Modeling Tools: Erwin 4.0/3.5, Star Schema, Snowflake Schema, OLAP, OLTP

Tools: TOAD, WinSQL, MS Office, Autosys, SQL*Plus, SQL*Loader

Operating Systems: Windows NT, UNIX

Methodologies: Agile, Scrum, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, S an Diego, CA

Tableau Developer

• Worked on migrating the reporting from one database Server to the other in SQL Server environment
• Gathered requirements from users for dashboards and reports. Created user content based on requirements and worked with the users to refine and finalize content
• Assisted with completion of Framework Manager models based on developed guidelines and standards
• Developed property SAS macros that redefined company’s efficiency in data cleaning and reporting
• Performed Regression analysis in Tableau 10.0 desktop to find the fields which are determining the cost and analyzed them
• Performed statistical analysis using control charts which helped the team in determining the root causes
• Created histograms, pie charts, box plots, scatter plots for inventory management, revenue change, destinations flown across different geographic markets, time-series statistics for price variance across different vendors, heat maps for shopping activities across business units.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for the executive dashboard.
• Developed Trend Lines, Statistics, and Log Axes, Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
• Created Stored Procedures, Views and tables for designing the new database in Microsoft SQL Server 2014
• Assembled the facts and dimensions tables as a single view using SQL Server
• Developed reports using various templates like list report, Cross-tab Report and Chart Report using Report Studio and Query studio for the transactional data
• Visualized data using Bar charts, column charts, Pie charts. Created an executive dashboard for the Client requirement in Tableau Desktop
• Worked closely with DBA and other members of the team to resolve the issues.

Environment: Desktop OS: Win2000 Professional, Server OS: Windows 2003/2008; MS SQL Server 12, Tableau 9.2

Confidential, Warren, NJ

Sr. Tableau Developer

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 9.0
• Worked on various data sources such as Oracle, Teradata, SQL Server for reporting
• Created universes on Teradata and SQL Server
• Maintained Security and Create/manage users, Groups, Licenses and integrated with Active Directory
• Created dynamic reporting with the use of SAS and Microsoft Excel
• Tested and explored new releases of Tableau Application and drivers, suggested and supported users with proper drives installation
• Administered and supported tableau Infrastructure including Upgrades, testing, Security Administration, License Management, troubleshoot workbooks, Performance Monitoring and System maintenance
• Connected to SAS ODBC data source from tableau desktop for building an executive dashboard
• Scheduled the reports to run on daily/weekly basis and published the reports created to the Tableau Server
• Involved in publishing various kinds of live interactive data visualization dashboards, reports and workbooks from Tableau Desktop to Tableau servers
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau reports from the Teradata data sources within Volume 2 Value Reporting team
• Created calculated fields using Tableau for implementation of color coding and proper aggregations for data coming from SAP BW.
• 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.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• 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.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 9.0 and Tableau 8.0
• Created various connections, Data foundations and Business layers using Information Design Tool 4.1
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Responsible for developing provisioning reports for various groups and upper management.
• Created Complex Dashboard, Reports using WEBI having multiple metrics and trends and created Hyperlinks for each of the Metric to open a detail report using Open Documents
• Experience on writing SQL Queries.
• Experience on BW Analyzer & Query Designer.
• Strong verbal and written communication skills, ability to work effectively with user departments.
• Worked towards the goals of quality, time and budget

Environment: Desktop OS: Win2000 Professional, Server OS: Windows 2003/2008; MS SQL Server 8.0/2005, XML, Tableau 9.0/8.0, SAP Business Objects 4.1/4.0, IDT, UDT, WEBI BI: SAP BW Query Designer, Analyzer

Confidential, East Rutherford, NJ

Tableau Developer/ BI Consultant

• Upgraded tableau 7.0 to tableau 8.0. And gathered requirements, analyzed from raw data.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.
• Involved in created stored procedures, views, and custom SQL queries to import data from SQL Server to tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
• Having experience in SME (Subject Matter Expert) in all BI tools.

Environment: Tableau Desktop 8.0/7.0, Tableau server / Administrator, SQL developer, SAS/SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Confidential, San Jose, CA

Tableau & Business Objects Developer

• 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, Richmond, Virginia

Tableau Developer

• 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 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.
• 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

Business Object Developer

• Published reports in Business Objects Enterprise XI R2 using Central Management Console and Publishing Wizard.
• Assigned Scheduling Rights as per the User Requirements
• Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management
• Work with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
• Work with production team to coordinate and assist in rollout of releases.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Worked with BO support in troubleshooting issues and provide logs as per request for resolving several complex issues
• Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
• Provided solutions to various groups for scheduling reports using Packages and event based job scheduling.
• Co-ordinating with various groups in scheduling releases between environments.
• Deployment of Crystal Reports via various methodologies Central Management Console(CMC),
• Publishing Wizard, Infoview, Import Wizard.
• Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
• Experience on Developing Crystal Reports.
• Daily reporting to Management on status, issues, migrations, escalations and progress.
• Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit Database for investigating User activity and narrowing down issues.
• Assist Team in Optimizing system architecture.
• Assist with website deployment architecture (e.g. web servers, databases etc.) and code optimization.
• Designed and implemented Ad-hoc Reports, Extracting Data from an SQL Server database.
• Experience managing user accounts and group accounts in Crystal enterprise environment.
• Used Clear case Explorer to Take Backup of Webi Reports and Universe.

Environment: Business Objects XIR1/XI R2 SP2, Crystal Enterprise 10, Crystal Reports XI R1/ XI R2, Windows 2k3/2k, Universe Designer, Web Intelligence. Oracle 10g, Clear case

Confidential

Sql Server Developer

• Oversaw installations, upgrades of SQL 2008, SQL 2005 to SQL 2008.
• Involved in Database design, creation and maintenance of Databases.
• Managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Server & Application fine-tuning & trouble shooting.
• Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Monitoring MS SQL Server performance and network issues.
• Performance monitoring and tuning of SQL servers.

Environment: MS SQL Server 2008/2005, Windows XP Server, MS Access.