SUMMARY:

• Over 8 years of experience in Analysis, Design, Development and Implementation of Business Intelligence Projectsand 6+ years of experience in data visualization as a Tableau Developer and Tableau Administrator.
• Expertise in Tableau 10.4/10.3.1/10.2/10.1/10.0/9.2/9.1/8. x/7.x, Tableau Desktop, Tableau Server, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader, SQL, PL SQL and Unix Shell Scripting and worked on Tableau 10.5
• Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Online.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Gant Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop
• Created highly interactive Data Visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets and Aggregate measures.
• Proficient in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Generated KPI for organization targets and customer satisfaction Survey results.
• Experience in building Gantt charts for Likert Scale Survey Questions.
• Extensive experience in creating dashboards to showcase the performance of the product in the market based on the Survey data
• Provided tableau training on the Survey dashboards built to the end users.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Created dashboards by using Level of Detail concept (LOD's)
• Produced attractive visuals/dashboards to convey the story inside the data publishing and presenting dashboards on web and desktop platforms
• Extensive experience in creating several reports such as drill down, drill through reports, parameterized reports, linked reports, Heat Maps, Dual Charts, Action Dashboards and cascading reports.
• Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting
• Experience in creating Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report andDashboard using KPI’s
• Extensive usage of Amazon web services (AWS) for connecting to the data sources on cloud using Amazon redshift services.
• Connected to the AWS Redshift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure the views and dashboards were displaying the changed data accurately
• Extensive experience on building dashboards in Tableau and involved in Performance Tuning of reports and resolving issues within Tableau Server and Reports.
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real - time systems all in one dashboard.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository
• Worked heavily using Tabadmin tools and Tab Cmd for setting up security profiles for various User groups and Users.
• Experiencewith Tableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.
• Experienced in managing schedules and scheduling workbooks and activities on Tableau Server
• Created Operational Dashboardsto track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems
• Had experience in Performance tuning for the Tableau Visualizations and Tableau server for more than 150 concurrent users.
• Expertise in Tableau server installation, Configuration, Upgrade, and enforcing security in Tableau.
• Deployed tableau server in clustered environment by adding worker machines.
• Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR.
• Optimized the VizQL server processes to handle loading and rendering views for TableauServer.
• Worked on connecting tableau to various other data sources like Oracle, Teradata, SAP Hana, Microsoft Access, and SQL Server and had experience in establishing respective driver connections.
• Worked on developing complex SQL scripts for Teradata database for creating BI layer on DW for tableaureporting.
• Extensively worked with Microsoft Business Intelligence Services such as SSIS, SSRS, SSAS
• Proficient in database Design, Modeling, Creating StoredProcedures, Indexes, Functions, Triggers, Views using SQL Server
• Played an active role during the requirements gathering and developed Entity Relationship Diagrams using Data Modeler tool
• Written complex SQL queries with complexity using Inner/Outer joins, UnionAll, Intersect&Minus set operators.
• Worked in the conversion of SQL server functions into the Teradata Store procedure for confirming the data.
• Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules
• Extensive experience in mitigating the database redundancy using Normalization techniques.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on Inputs, scheduling the SSIS packages using SQL Server Agent Services.
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Experience authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS)
• Exposure to Big Data Hadoop environment and its components HDFS, Apache Pig, Hive, Sqoop,

TECHNICAL SKILLS:

Tableau: 10.5/ 10.4/10.3.1/10.2/10.1/10.0/9.2/9.1/8. x/7.x, Tableau Server, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader C, C+ +, C#, JavaScript, SQL, PL SQL

Platform: UNIX, Win 98/XP/2000/NT, DOS, Windows 7/8/10

Data Warehousing: BW 3.5, 3.1c, 3.0b, BI 7.0, Oracle 9i/ 8i/7.3, MS SQL Server 2000/7.0/6.5, Access, SAP HANA, Teradata, AWS

PROFESSIONAL EXPERIENCE:

Confidential, Sterling, VA

Tableau Consultant

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Created Actions in Worksheets and Dashboards to interact and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Generated KPI for organization targets and customer satisfaction survey results
• Provided tableau training on the Survey dashboards built to the end users.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, Level-of- Detail (LOD), calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Produced attractive visuals/dashboards to convey the story inside the data publishing and presenting dashboards on web and desktop platforms
• Created automated scripts for tableau workbook refresh when not using live connections.
• Involved in reviewing business requirements and analyzing data sources form Teradata Server for design, development, testing, and production rollover of reporting and analysis projects within TableauDesktop.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Used Data Blending, groups, calculated fields, and aggregated fieldsto compare and analyze data in different perspectives.
• Worked on groups, sets, different calculation functions including Tablecalculations.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Performed end-to-end Data Analysis and ensured the data quality gaps are identified.
• Published Workbooks by creating user filters and security, so intended teams can view it.
• Published Workbooks and Dashboards to the Tableau server.
• Performance Tuning of Dashboards and working with users and Database teams for design review and modeling.
• Scheduled Tableau Data Extracts using Tableau Server and the Tableau Command Utility.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Used R functions as Table calculations (aggregated) like Sum, MIN, MAX etc. in Tableau.
• Testeddashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Used commands in Tabcmd and Tab admin utility tool.
• Involved working in POC to various team for their Adhoc analysis of data with Tableau.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems to effectively develop technical solutions to their requirement.

Confidential,Cincinnati,OH

Sr. Tableau Developer/Tableau SME

• Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Worked extensively with LODs (FIXED, INCLUDE, EXCLUDE) Calculations, Parameters, Background images, Maps.
• Worked in the conversion of SQL server functions into the Teradata Store procedure for confirming the data.
• Worked on Teradata Store procedures and functions to conform the data and load it on the table
• Worked heavily using Tabadmin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
• Worked on creating interactive, real-time dashboards using drillingdowns and customizations.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthlydashboard reports on Tableau Server.
• Used Tableau Cmd for various Dashboard migrations from one environment to another.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Created actionfilters, 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.
• Tested reports, uploaded tableau dashboards on to server, and provided production support for tableau users
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Hands-on development, assisting users in creating and modifying worksheets and data visualization dashboards.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Handled user licenses for projects
• Worked with the administrator to monitor and fine tune SQL queries for better performance of reports

Confidential, Jacksonville, FL

Tableau Developer

• Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards with MS SQL Server as Data Base.
• Extensive experience in reviewing business requirements and analyzing data sources form Excel/MS 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.
• Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Word clouds, Bubble Charts, Pareto Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on client’s need.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth by developing reports to show in detail.
• 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 MS SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed 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.
• Collaborate with development team on data approach for coding Understand data guidelines, and understand data sources available, what is new based on requirements, and how the project will impact common data stores
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Confidential, New York, NY

SQL BI Developer

• Extracted data from various sources like SQL Server 2008/2012/2014, .CSV, Excel and Text files from Client servers.
• Involved in installation and configuration of SQL Server 2012/2008/2005 with latest Service Packs.
• Migrated data from Legacy system (Text files, Excel docs and Access files) to SQL Server Databases using SSIS.
• Involved in the enhancement of SSIS packages according to changing business requirement to support the ETL strategy.
• Built SSIS package to perform extraction, transformation and load (ETL), the data into OLTP data warehouse.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on a daily basis.
• Created numerous SSIS (ETL) packages involving Control Flow, Containers and Data Flow Tasks, Email alerts.
• Optimized the performance of SSIS package and SQL stored Procedures for better package execution.
• Experience in deploying the SSIS packages to stage and production environments and creating SQL Server agentjobs for scheduling
• Generated reports in various formats like Table format and Matrix format using SQL Server Reporting services (SSRS 2005/2008).
• Designed Recon Dashboard using Lists, Rectangles, Indicators, and Gauges, created page breaks, formatting the report, sorting the report data in SSRS
• Using SSRS created Data sources, Datasets populating the report data and created table, chart, Drill through and parameterized reports with drop down option.
• Experience in building and deploying SSRS Report Models with the help of Visual Studio 2008.
• Experience in deploying the SSRS reports to stage and production environments
• Involved in designing Matrix Reports and Cascaded Parameterized Reports (SSRS).
• Using SSAS created Data source, Data Source views (Star Schema), Named Calculations, defined relationship between the tables.
• Created calculated measures, raised change requests by making changes to the SSAS cube as per the requirement.
• Created and processed complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP reporting needs.

Confidential, Tampa, FL

MS SQL Developer

• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Application by using T-SQL.
• Wrote SQL queries using DML, DDL, Table joins, Group functions, Analytical functions, Partition by clause towards Reports and Application development.
• Performed and fine-tuned Stored procedures, SQL Queries and User defined functions.
• Responsible for implementing Table partitioning, Advanced Error Handling, Common Table Expression (CTE).
• Involved in extensive data validation by writing complex SQL queries and involved in back end testing and worked with data quality issues
• Scheduled reports to run on a daily and weekly basis in report manager and emailed them to director and analysts to review in Excel Sheet.
• Performed extensive use of SQL Server DMV's for Performance Tuning.
• Troubleshooting client issues ranging from improper configuration settings or data corruption to issues in underlying code, working with product management to provide enhancement or other resolution.
• Wrote complex SQL queries using Inner/Outer Joins, UnionAll, Intersect & Minus Set operators
• Created Joins and sub queries for complex queries involving multiple queries
• Developed and Modified functions, Procedures as per the client requirement to make new enhancements and to resolve issues
• Actively involved in normalizing the database using Normalization techniques to reduce data redundancy.
• Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.
• Developed SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.
• Involved in writing Complex SQL statements, Database Triggers and stored procedures by using Cursors and indexes in SQL Server 2012.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.