SUMMARY

• Developer with 8 years of experience onTableau, 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
• Experience with the design and development ofTableauvisualization and dashboard solutions using Tableau Desktop.
• Involve in design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Expert in evaluating data models to designTableausolutions.
• 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.
• End to end experience in designing and deploying data visualizations using Tableau
• Deployed the reports andScheduled Reportsfor 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.
• Extensively used Erwin for Logical Data Modeling, Physical Data Modeling, Logical-to-Physical Transformation, Forward engineering, Reverse engineering, and Model-to-model comparison.
• Strong knowledge of Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schema, SSIS processes, Dimensional Modeling and Reporting tools.
• Proficient in Installing, Configuring and Administration of Tableau Server.
• Expertise in designing and development of various dashboards, reports utilizingvarious TableauVisualizations 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 business/client requirement.
• Extensive experience inTableauAdministration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms..
• Highly proficient in using T-SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Well versed in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS including tools likeBCP utility, DTS and SSIS 2005/2008 Packageswith proper control flow and data flow elements by using MS SQL Server 2012/2008-R 2/2008/2005.
• Good experience in generating Sub-Reports, Drill down reports, Drill through reports, and Parameterized reports using SSRS 2012/2008-R 2/2008/2005.

TECHNICAL SKILLS

• Tableau Desktop 7/8
• Tableau Server 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
• DHTML
• XML
• Java Script
• 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, Chicago, IL

Tableau Developer/Admin

Responsibilities:

• Evaluated data models to designTableausolutions.
• Involved in creating dashboards by extracting data from different sources and created dashboard using parameters, sets, groups and calculations in Tableau Desktop
• Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.
• Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
• Implemented data blending to blend related data from two different data sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Monitored and maintained incremental refreshes for data sources on Tableau server.
• Generated insights out of voluminous and complex datasets and built story lines.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository
• Configured Cache settings which improved the performance of the reports and Dashboards.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• 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 changes to ensure that the views and dashboards displayed the changed data accurately.
• Involved in reviewing business requirements andanalyzingdata sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Converted charts into Crosstabs for further underlying data analysis inMSExcel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blendeddata frommultiple databases into one report by selecting primary keysfrom each databasefor data validation.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby 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.

Confidential, NJ

Tableau Developer / Admin

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 TableauServer in clustered environment by mapping server nodes to primary machine.
• Created Users, Groups and projects in Tableau environment.
• 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 Heat Map showing employment vs unemployment by color that were broken into regions allowing business user to understand where we have most unemployment.
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Worked with Individual Axes, Blended Axes, and Dual Axes.
• 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.

Confidential, Detroit, MI

Tableau/ SQL Server Developer/ SSRS/ SSIS

Responsibilities:

• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Extracted files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets.
• 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
• Held responsibility for integration points and the order in which these must be executed.
• Built compelling, interactive dashboards inTableauthat answer key business questions.
• DevelopedTableauvisualizations 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.
• Involved In migration of various objects like stored procedures, tables, views from Sybase to SQL server
• Involved in compiling of store procedures in SQL server and troubleshoot errors.
• Created documents for code review in test and prod server.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Created complex Stored Procedures, packages, tables, views and SQL joins and statements for applications.
• Created ETL process for overall data transfer from the OLTP to Data Warehouse with the help of SSIS.
• 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.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2005.
• 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.

Confidential, NYC, NY

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2005 to SQL Server 2008 a using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Made reports to retrieve data using Stored Procedures that accept parameters.
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Confidential

MS SQL Server/ SSRS Developer

Responsibilities:

• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources. .
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Analyzed and designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
• Migrated packages from development server to production server using package configuration.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Generated various reports by comparing the growth of company based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Used Visual Source safe for repository and maintaining versions.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Improved Performance of the database by creating Clustered and Nonclustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Conducted user training sessions and supported the requests for enhancements, modifications and new reports.