Professional Summary:

• Developer with 8 years of experience on Tableau, data discovery, data visualization, data analysis, report development, MS SQL Server Developer/ ETL Developer in analysis, design, implementation administration of Business intelligence solutions SSIS/SSRS/SSAS with Microsoft SQL server 2012/2008-R2/2008/2005 in development, testing production environment.
• Designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts and Geographic Visualization
• Experience with the design and development of Tableau visualization and dashboard solutions using Tableau Desktop.
• Involve in development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Implemented actions, other local and global filters according to the business/client requirement to make workbook and dashboard more interactive.
• Expert in evaluating data models to design Tableau solutions.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Tableau tools include Tableau Desktop versions and recent implementation of 8.2, Tableau Server, Tableau Public, and Tableau Reader.
• Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 8.0 to Tableau 8.1
• Extensive Knowledge of Tableau Server Concepts like tabcmd, tabadmin, creating users, sites and projects.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues with in Tableau Server and Reports.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, calculations and Relationships.
• Having knowledge on gather business requirements and translate them into reporting needs.
• Recommending Dashboards per Tableau visualization features and delivering reports to Business team on timely manner.
• Responsible for developing interactive data visualizations.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing, deploying data visualizations using Tableau to provide consultative support and created technical solutions to business challenges.
• Deployed the reports and Scheduled Reports for the use of end users and customers
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Gather business requirements and translate them into reporting needs including documenting and created complex dashboard reports to support IT / Business/ BI operations.
• Provided consultative support and created technical solutions to business challenges. Gather business requirements and translate them into reporting needs including documenting

Technical Skills:

Tableau Desktop 6/7/8, Tableau Server 5/6/7/8, Tableau Online, Tableau Public, Tableau Reader, TabCmd, Microsoft SQL Server 2012/2008-R2/2008/2005, MS SQL Server Integration Services SSIS , MS SQL Server Reporting Services SSRS , MS SQL Server Analysis Services SSAS , T-SQL, PL-SQL, OLAP, OLTP, Erwin Data Modeler v7.0/v4.x, Microsoft Visual Studio 2010/2008/2005,Microsoft Access, Microsoft Office MS Word/ Excel/Powerpoint , MS Project, HTML, XML, Java, C , C , Visual Basic 6.0, Microsoft Office Visio, Windows 2008/2003/2000 Advanced Server, Windows NT/95/98/2000/XP/7, Ultra Edit Text Editor, Visual Safe Source 2005 VSS .

Professional Experience:

Confidential

Role: Tableau Developer/Admin

Responsibilities:

• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Worked with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server based Tableau dashboards with automatic updates.
• Implemented Tableau BI Dashboard reporting solution for different groups in the organization.
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium laptop, pc, IPad
• Created extensive joins for data blending from several different data sources
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Tested Dashboard for data accuracy and Functionality.
• Migrated Reports from Development to Testing and to Production Environment using Import Wizard.
• .Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Tools Technologies:

Tableau Desktop 8, Tableau Server 8, TabCMD, MS SQL Server 2012, MS SQL Server Integration Services, MS Visual Studio 2010, Microsoft Office Visio, Microsoft Safe Source 2005 VSS , Erwin r8, Ultra Edit tool, SharePoint, C .

Confidential

Role: Tableau /SSIS Developer

Responsibilities:

• Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
• Deployment of Tableau Server in clustered environment by mapping server nodes to primary machine.
• Created Users, Groups and projects in Tableau environment.
• Created and managed schedules for users.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Created different views using Tableau Desktop that were published the business stake holders for analysis and customization using filters and actions.
• Created Heat Map showing employment vs unemployment by color that were broken into regions allowing business user to understand where we have most unemployment.
• Implemented various data connections from data source to Tableau Server for report and dashboard development.
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
• Created guided navigation links for Interactive dashboards in Tableau.
• Developed actions, parameters, Filter Local, Global and calculated sets for preparing dashboards and worksheets using Tableau
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Bullet graphs to determine average wages and workers compensation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
• Created and updated stored procedures and functions to meet the requirements and changes specified by the users.
• Pushed all the created stored procedures and functions to the development, training and production servers.
• Created trace in SQL Profiler and used Database Engine Tuning Advisor DTA for Performance tuning on stored procedures and Scripts.
• Highly responsible for scheduling and delivery of jobs using SQL Server Agent. Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.

Tools Technologies:

Tableau Desktop 7, Tableau Server 7, TabCMD, MS SQL Server 2012, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2010, Oracle 10g, Erwin r8, C .

Confidential

Role: Tableau/ SQL Server/SSIS Developer

Responsibilities:

• Created Advance connections, join new tables, create manage Extract and Monitor Queries.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality
• Responsible for creation of Tableau workbooks, dashboards using stack bars, Pie charts, bar graphs, scattered plots, geographical maps, Gantt charts.
• Held responsibility for integration points and the order in which these must be executed.
• Built compelling, interactive dashboards in Tableau that answer key business questions.
• Developed Tableau visualizations to support ad-hoc analyses and interacted with Business users in understanding their requirements.
• Created various SQL objects such as schema, tables, field definitions and mappings, stored procedures, CTE, Triggers, views and indexes/keys.
• Created various objects like stored procedures, tables ,views in SQL server
• Involved in compiling of store procedures in SQL server and troubleshoot errors.
• Created documents for code review in test and prod server.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Provided security to ETL packages and set them as jobs to perform ETL tasks on regular intervals.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager.

Tools Technologies:

Tableau Desktop 6, Tableau Server 6, MS SQL Server 2008 R2, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2008, Erwin r7

Confidential

Role: MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2008 using SSIS Packages.
• Generated ETL packages with different data sources SQL Server, Flat files, Excel source files, Oracle and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension SCD , Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created complex stored procedures and functions for integrity checks of transferred data.
• Performed unit testing and SQL performance tuning.
• Tuned SQL statements Using Indexes and stored procedures.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Involved in implementation and maintenance of disaster recovery solutions such as replication and log shipping.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled report and exported in PDF format.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools Technologies:

MS SQL Server 2008, SSRS, SSIS, SSAS, VB.Net, EXCEL, MS Access, ORACLE 10g, Erwin Data Modeler v7.0/v4.x.

Confidential

Role: MS SQL Server/ SSRS Developer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Involved in ER diagrams Physical and Logical using Erwin and mapping the data into database objects.
• Designed database, tables and views structure for the new data mart.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005 using SSIS Packages.
• Created complex stored procedures and functions for integrity checks of transferred data.
• Performed unit testing and SQL performance tuning.
• Helped provide end users with the ability to access and utilize the data stored in the data mart.
• Tuned SQL statements Using Indexes and stored procedures.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Involved in implementation and maintenance of disaster recovery solutions such as replication and log shipping.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Tools Technologies:

SQL Server 2005/2008, MS Excel, MS Access, Enterprise Manager, Management Studio, SQL Profiler and SQL Server Reporting Services.