SUMMARY:

• Competent IT Professional with 10 years of extensive experience in Tableau, Business Intelligence, Business Objects and SQL and ETL Developerwithin the finance, sales and marketing, healthcare, and Manufacturing industries.
• Worked on different Tableau versions (Tableau 10.5/10.3/10.2/10.1/10.0/9.3/9.2/9.1/8.0/7.0 ), Tableau server, Tableau online, Tableau public, Tableau reader and SAP BI/BO.
• Experienced in Analysis, Development, Design and Maintenance of Business Intelligence applications, creating dashboards, designing Universes, Full Client/Webi reports etc.
• Used Tableau Cmd for various Dashboard migrations from one environment to another.
• Used efficient load balancing techniques to manage the load on the server for concurrent user logins.
• Created automated scripts for tableau workbook refresh when not using live connections
• Experience with 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 Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real - time systems all in one dashboard.
• Preparing Dashboards using calculations, parameters in Tableau
• Extensive knowledge in various reporting objects like Attributes, Hierarchies, filters, prompts, Calculated fields, Sets, Groups, Parameters, Level-of-Detail (LOD) expressions etc., in Tableau.
• Implemented Binning & Blending concepts in my Tableau Reports.
• Worked on setting permissions on content for specific users or group on a per site basis.
• Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Expertise in web integration of Tableau Reports with HTML or Asp.Net.
• Good usage of Tableau JavaScript API for performance improvement of web page.
• Proficient in design and development of various dashboards, reports utilizing advanced Tableau Visualizations like Waterfall Charts, Funnel Charts, Pareto Charts, Dual Axis, Blended Axes, Scatter Plots, Bar in Bar, Box Plot, Bullet Chart, Gantt Chart, Heat Map, Spark Line, KPI Charts.
• Excellent knowledge on Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report.
• Excellent knowledge in Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts and Tooltips.
• Installed and setup cluster environment for Tableau server and used Jmeter for load balancing and load analysis.
• Experience in working on different data warehousing methodologies including star schema and snowflake schema, ETL processes, dimensional modeling, reporting tools.
• Experience in using Custom SQL for tableau and in writing queries for generating tabular reports, formatting report layout and expressions.
• Involved in complete Software Development Lifecycle (SDLC) by identifying the business requirements and converting them to tableau design.

PROFESSIONAL EXPERIENCE:

Tableau Developer/ Admin

Confidential - Southfield, MI

Responsibilities:

• 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.
• Defined best practices for Tableau report development.
• 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.
• 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 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.
• Created Web reports using custom SQL queries and converted them to tableau dashboards for advanced visualizations.
• Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. in a single dashboard by using parameters.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes.
• Effectively used data blending feature in Tableau to combine the data from different sources like Adobe marketing cloud into a single report.
• Worked closely with end users in identifying and implementing right set of business criteria to convert raw data into meaningful information.
• Defined best practices for Tableau report development. Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Worked on understanding of relational database structures, theories, principles and practices.
• Found efficient ways to make tables and graphs that were visually easy to understand and Confidential the same time maintaining the accuracy of the core information content.
• Used SQL queries Confidential the custom SQL level to pull the data in Tableau desktop and validated the results in Tableau by running SQL queries in Teradata SQL Assistant.
• 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.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created Tableau functional design document.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.

Environment : Tableau Server 8.1/8.2, Tableau Desktop 8.1/8.2, Windows Server Standard R2,, Excel, SQL Server management studio, MS SQL Server 2008R2, UNIX.

Tableau Developer

Confidential - Denver, CO

Responsibilities:

• Worked directly with Business Lines in Customer Care, Loans, Management Information Systems, Card Management to gather dashboard requirements for development.
• Hands-on development assisting power users in creating and modifying worksheets and data visualization dashboards for departmental consumption.
• Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Involved in creating dashboards and reports in Tableau.
• Created report schedules on Tableau server. Published Workbooks by creating user filters so that only appropriate teams could view it.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extracting data from different sources connecting them and used the same to create dashboard.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau Created
• Increased extract performance by aggregating data and rolling up dates when creating extracts.
• Created Parameters, Calculations, Conditions, and Filter (Local, Global) for various analytical reports and dashboards.
• Created and modified Interactive Dashboards and creating guided navigation links within Interactive Dashboards.
• Implemented row-level security to define data access restrictions for users.
• Created new sets and added and removed data using the tooltip, and combined and compared multiple sets.

Environment: Tableau Desktop 7.x, Tableau Server, Metadata, Teradata, Oracle 10g/11g, Windows XP.

Tableau Developer

Confidential, San Ramon, CA

Responsibilities:

• Gathered Business Requirements, Interacted with Strategic Development Team, Business analyst to analyze business needs and developed technical specifications.
• Evaluated data models to design Tableau solutions by created different KPI using calculated key figures and parameters.
• Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server .
• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• 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.
• Creating reports and infrastructure to show migration activities by monthly release, business function, IT projects and overall.
• Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard.
• Created user filters to publish Workbooks making it viewable only to concerned teams.
• Analyzed the source data and handled efficiently by modifying the data types.
• Generated tableau dashboards for sales with forecast and reference lines and generated interactive dashboards with an implementation of Data blending on databases.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE's, Table Variables and Stored Procedures.
• Effectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, aggregate and Slowly Changing Dimension, Merge Join and Union all.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases. Created SSIS packages to Export data from text file to SQL Server Database.
• Responsible for optimizing SQL queries, stored procedures to improve the performance time.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Created visualization for logistics calculation and department spend analysis.
• Generate KPI for customer satisfaction survey results and disease management.
• Maintained Test log and Wrote Test Evaluation, Summary Reports.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Extensively involved in doing user acceptance testing (UAT).
• Support for end users connected to servers in various departments regarding connection and data access issues.
• Designed and deployed reports with Drill Down, Drill Through and Drop-Down menu option and parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.

Environment: Tableau Desktop 10 .x /9.1/9.0/8.2, Windows XP, SQL, Oracle 11g, MS Access, MySQL, Flat files, CSV files, MS Excel, MS Visio, MS Word.

Tableau Developer

Confidential - St. Louis, MO

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form 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 .
• 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.
• Developed Tableau data visualization using Pareto's, Combo charts, Box and Whisker charts, Geographic Map, Cross tabs, Histograms et c.
• Developed donut charts for analyzing sales planning data.
• Created different KPI's using Table calculations and calculated key figures Manipulating's strings, arithmetic calculations, aggregation options and Logical functions.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Oracle, Teradata and SQL Server .
• 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 basic 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.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Developed working documents to support findings and assign specific tasks.

Environment : Tableau Desktop 9.x, 10.x, Tableau Server, MS Office Suite, Oracle SQL Server R2, Amazon Redshift, MS Excel.

SQL Server SSIS Developer

Snap-on Business Solutions, Richfield, OH

Responsibilities:•

• Create and maintain clearly written technical, user, and system documentation.
• Worked with complex SQL Stored Procedures, Triggers and packages in very large databases from various servers.
• Created User Interface reports for validating the Data through Reporting Services.
• Highly responsible for development and management of SSRS and SSIS projects.
• Extracting and Loading data into SQL Server Database using SSIS.
• Extensively involved in designing the SSIS packages to export data from SQL Server database to flat file source.
• Scheduling & Maintaining ETL packages in terms of data validation and consistency.
• Designing SSIS packages to migrate data from database (Hierarchical) to database (Relational).
• Created Mapping, Design and technical Documentation for complex SSIS packages.
• Experience in maintaining Error logging using Exceptional Handling in T - SQL and SSIS.
• Involved in Maintaining Database with Backup, Restore Strategies and scheduling those backups using SSIS packages as a Developer.
• Deployed many packages on different servers using SSIS package Configurations.
• Involved in Backup and Restoring the Databases.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, lookup, Derived Column task and Script Task in SSIS Designer.
• Responsible for scheduling the packages through Jobs.

Environment: MS SQL Server 2012/2008 R2, MS Excel, MS SQL Server Reporting Services, MS SQL Server Integration Services, Team Foundation Server, Share Point Server 2007/2010, SQL Profiler, Windows 2003 Advanced Server, Oracle SQL Developer.

ETL Developer

Confidential, New Brunswick, NJ

Responsibilities:

• Understanding the Requirement Specifications and discussion with PO for further drill down and reqs.
• Writing Teradata merge and Bteqs scripts to load and update data in Teradata systems.
• Developing the mappings using needed Transformations in Informatica tool according to technical specifications to populate the data into Target tables from Source systems.
• Developing and implementing the coding of Informatica Mapping for the different stages of ETL (Extraction Transformation and Loading).
• Developing various Mappings to load the data from various sources by using different Transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Source Qualifier, Expression and Sequence Generator to load the feeds data.
• Fixing the invalid informatica mappings and troubleshoot the technical problems of the database.
• Development of Informatica Mappings to accomplish Auditing and Error handling of Target load.
• Developing Workflows using task, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Debugging the informatica sessions by utilizing the logs of the sessions.
• Creating UNIX shell script for the start and stop procedures of the sessions.
• Performing unit testing Confidential various levels of the ETL
• Extensively worked on identifying the bottlenecks and fine-tune the mappings.

Environment: Informatica Power Center 7.1, Oracle, PL/SQL, SQL Server 2005, Windows Server, Linux.