SUMMARY

• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8/7/6 and SQL, PL SQL and VB scripting.
• Deploying and scheduling Reports to generate all daily, weekly, monthly and quarterly Reports including current status. EstablishedBest Practicesfor EnterpriseTableauEnvironment and application intake and development processes.
• Extensive experience inTableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experience in designing Data Mart and Data Warehouse using Erwin Star and Snowflake Schemas.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer 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 onTableauServer for weeklyand monthlyincrementsbased 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.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive Dashboard and other user interface elements.
• Expert in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Thorough understanding of Kimball/Inman strategies, KPI, Data mining structures.
• Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports .
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures.

TECHNICAL SKILLS

• Tableau desktop 6/7/8.1
• Tableau Server 6/7/8.1
• Tableau Reader 6/7/8
• Tableau Public 6/7/8
• MS SQL Server 2012 /2008R 2/2008/2005/2000
• SSRS 2012/2008R 2/2008/2005/2000
• SSAS 2012/2008R 2/2008/2005/2000
• SSIS 2012/2008R 2/2008/2005/2000
• DB2
• MS-Access 2013
• MS Excel
• Erwin 8.0/7.2/7.1
• MS Visio 2010/2007/2005
• VB 6.0
• Oracle 11g/10g
• T-SQL
• HTML
• XML
• XSL
• Java script
• VB Script
• C#
• Visual Studio 2012/2008 R 2/2008/2005/2000
• ODBC
• MS office
• Windows NT/ 2000 Server/ XP
• Oracle
• DB2.

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Tableau Developer/Tableau Server Administrator

Responsibilities:

• Actively involved in creating Custom Reports by understanding the Management and senior level Management’s need to support in business.
• Performed the administration, configuration, maintenance & upgrade of Tableau Servers.
• Ensured Tableau Server configuration settings are optimal.
• Managed Data Extract Schedules and Access to Reports.
• Create custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations.
• Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently.
• Worked on the development of Tableau Dashboard reports for Key Performance Indicators for the top management.
• Rebuild existing Reports into Tableau Visualizations with user and action filters
• Published Workbooks by creating user filters so that only appropriate users can view/edit them.
• Generated context filters and handled performance issues while dealing with huge volume of data.
• Generated tableau dashboards with forecast and reference lines.
• Installing and Configuring of Tableau Server and Tableau Desktop.
• Usage of Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Creating groups, projects, workbooks and the appropriate permissions for Tableau server and security checks.
• Involved in Tableau Administration Tool for configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platform like web portals.
• Creating Bookmarks, Actions, worksheets and workbooks.
• Created extract files for improving the performance and Tableau server performance tuning for optimization
• Involved in troubleshooting and resolving issues within Tableau Server and Reports
• Used Tableau command line commands to publish workbooks periodically.
• Automation of sending Email process on a daily basis, to view refreshed tableau dash boards.
• Performed the administration, configuration, maintenance & upgrade of Tableau Servers.
• Ensured Tableau Server configuration settings are optimal.
• Managed Data Extract Schedules and Access to Reports.
• Performance tuning of workbooks, data sources, and providing best practices for user community.
• Provided guidance and insight on data visualization and reporting/dishoarding best practices.
• Documented reporting requirements and defined report templates and dashboard specifications.
• Established, maintained and ensured adherence to application standards for data reporting.
• Used Tableau to contextualize information in a manner suitable to executive audiences.
• Identified key business metrics measurements and developed methods to represent data in support of the measurements.

Confidential, Jersey City, NJ

Tableau Developer/Tableau Server Administrator

Responsibilities:

• Redesigned the data source having data from different sources into one SQL Server and to tableau.
• Interacted with Business Teams to understand what needs to be visualized.
• Understanding what the client is expecting out of the reports, data cleaning to get to the right numbers for the weekly report.
• Generated tableau dashboards with forecast and reference lines.
• Analyzed and gained understanding of the underlying data. Enterprise Key Metric Tableau dashboard is sourced from multiple Excel files.
• Designed Tableau dashboards for Project/Resource analysis application and Enterprise Key Metric application. These dashboards were utilized by higher management to do analysis, product development and their market share.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Developed Tableau dashboards pertaining to Revenue and Sales monitoring using Tableau 8.1.
• Demo of Tableau dashboard to users to enhance their knowledge on all the key capabilities of application.
• Also developed a process in the company to generated tableau dashboards, which can be used for all the clients in the company by gathering the requirements.
• Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently
• Worked on the development of Tableau Dashboard reports for Key Performance Indicators for the top management
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies 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.
• Converted metric insight reports to tableau reports.
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.

Confidential, PA

Database/Tableau developer

Responsibilities:

• Participated with Business Analyst in order to gather requirements for design and implementation of database.
• Designed logical/physical data models using Erwin tool 7.2.
• Providing ad-hoc reports in both graphical method and tabular method upon requirement by client and management for operational & management requirements
• Generated complex reports utilizing the features like Hierarchy, new Calculated Columns, Drill functionality, Tables, graphs, Line Charts and Bar Charts
• Created Parameters to achieve desired functionality
• Implemented extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created Filters, Groups, Sets on Tableau Reports
• Publishing sheets and dashboards on server using Tableau Desktop
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Used Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Implemented Binning & Blending concepts in my Tableau Reports
• Worked on Dual Axis concept while working with reports
• Created conditional filters and Action links to filter the data on dashboard
• Develop and maintain the documentation level to the team and business
• Designed high level ETL architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL mapping processes and maintained the mapping documents.
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into data warehouse using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.

Confidential, NYC, NY

MS SQL Data Warehouse Developer

Responsibilities:

• Implemented various types of control flow and data flow transformations in packages to handle different logics and Created SQL Server Integration Services package for Market Value Process feed.
• Used C# scripts in SSIS script task to run custom scripts in package flow.
• Created command files to execute the SQL Server Integration packages using dtexec utility and passed connection and variable values to the packages.
• Used event handlers to send custom e-mail notifications to business users as well as technical teams.
• Gathered Business requirement for the Mortgage Information System to support the Truly International AIG Loans and UK Loans. Worked extensively with business users to get approvals on the changes.
• Modified the existing packages to create logging and getting the truly international loans data from the Loan Management workstation.
• Created Portfolio Exposure Report based on the sub segment code of the accountholders which gave the users summary and detailed level info regarding their accounts.
• Created various Reports using SQL Server Reporting Services based on the requirements specified by the business users.
• Performed end to end Analysis of the Mortgage Information System Sources and downstream system and created Mapping documents for project references.
• Enhanced Downstream System process of creating a Mortgage.xml file using Visual Studio 2008.
• Wrote various new and modified the existing Stored Procedures using T SQL based on the project requirement.
• Created various functions to get different kind of spot rates e.g. current spot rate, Average Spot Rates and effective date conversions.
• Created Document of understanding for each enhancement.
• Created Test cases for IT testing of each enhancement and performed system testing.
• Coordinated with the business users to complete the User Acceptance Testing.
• Provided Production Support to business users on daily basis to resolve data related issues and maintained the proper documentation of issues.
• Worked in Agile, scrum, and sprint environment.

Confidential - Mundelein, Illinois

SQL Server /SSIS /SSRS Developer

Responsibilities:

• Involved in gathering the report specifications by interacting with the business users
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard.
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Experienced in creating jobs, Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Planned, defined and designed data based on the business requirement.
• Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Actively participated in interaction with users, Team Lead, DBA's and technical managers to fully understand the requirements of the system.
• Performed Migration of data from SQL Server 2000 to 2005.
• Developed a data model and implemented the same using ERWIN.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers.
• Created Stored Procedures, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Designed and implemented processes for deploying, upgrading, managing and extracting data for reporting.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using SSIS.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Managed and monitored the use of disk space.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Planned Backup strategy based on projects requirements.
• Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.