SUMMARY:

• Competent IT Professional with 9+ 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 TableauServer
• 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.

WORK EXPERIENCE:

Tableau Developer/ Admin

Confidential, Southfield, MI

Responsibilities:

• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• 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.
• 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 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:

• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• 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 etc.
• 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.
• 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 TableauServer 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.

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 TableauServer 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.
• 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.
• 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 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 TableauServer.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.

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

SQL Server SSIS Developer

Confidential, 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 Confidential - 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.

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