SUMMARY:

• Over 5+ years of IT experience as a Tableau and SQL Server Developer in various Industry verticals like Retail, Healthcare and Bank. Maintained positive communications and working relationships at all business levels.
• Extensive experience inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7 and Tableau 8 .
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance wif timely delivery against aggressive deadlines.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Extensive experience on building Interactive dashboards using Tableau.
• Hands on experience creating, executing and maintaining SSIS Packages in SQL Server 2008/2005.
• Good hands on experience in writing SQL Procedure& functions.
• Experienced in creating SQL Server Report using Power View, Report Builder in Share point Server 2010.
• Experienced in creating SQL server Analysis Projects using MS SQL Server 2008 SSAS.
• Expert in ETL - Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Experience in analytical Database Design and Data Modeling skills using MS Visio and ERWIN.
• Expert noledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Highly proficient in teh use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting teh data, Defining Data Source and subtotals for teh reports using SSRS 2012/2008r2/2008/2005.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed teh deadline of any projects.

TECHNICAL SKILLS

• Tableau Desktop
• Tableau Reader
• Tableau Public
• Tableau Server 8/7/6/5
• Tabcmd
• MS SQL Server 2012/2008R2/2008/2005
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Reporting Services (SSRS)
• Business Intelligence Development Studio (BIDS)
• BCP SQL Profiler
• Enterprise manager
• Management studio
• Microsoft Access
• ERWIN 4.0/4.1/4.2/7.2
• Microsoft Visio 10.0/11.0
• T-SQL ASP.NET
• C# VB.Net
• HTML XML
• XSL Oracle 11g/10g
• Crystal Reports 8.5/9/10/11
• TFS
• Visual source safe 2005
• MS office 2013/2010/2007/2003
• Windows 2008/2003 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation
• UNIX Perl
• VBScript
• JavaScript
• Dreamweaver CS4
• Web Updater II
• Data visualization
• D3.js Infographics
• TIBCO Spotfire
• SVG Qlikview
• Visualization
• VTK Data science
• Data analysis
• Data mining
• Algorithms
• Dashboard
• MicroStrategy
• OBIEE Business Objects
• Ad hoc reporting
• BI architecture
• Business intelligence
• Dimensional modeling
• Microsoft SSAS
• Star schema
• ETL Microsoft SSIS
• Analytics
• Business analytics
• Web analytics
• Google Analytics
• Adobe Site
• Catalyst
• Strategy

PROFESSIONAL EXPERIENCE

Confidential, NY

Tableau Developer

Responsibilities:

• Directly interacting wif clients to elicit teh requirements and translate them into terms dat development team can comprehend.
• Conduct client interviews, high - level reviews, and be part of focus groups to derive and execute action plans, meet deadlines, and follow industry standards and best practices.
• Facilitate User Acceptance Testing (UAT) and production rollouts, and teh defects detected were tracked and managed using HP Quality Center.
• Produced reporting documents and led weekly meetings wif developers and business units to discuss outstanding technical issues and deadlines dat had to be met.
• Involved in maintaining and updating database objects like tables, views, procedures, functions using basic SQL queries to provide definition, structure, and to maintain data efficiently.
• Assist BAs in teh team wif appropriate documentation and domain noledge.
• Perform data modeling, periodic report validation and data analysis by writing SQL queries using TOAD.
• Interaction and coordination wif end users and management to identify Business system needs evaluated solutions for business problems bottlenecks and evaluated alternate methods to increase efficiency and improve control.

Environment: Tableau 7.0, SQL Server 2008, MS Office, MS Excel.

Confidential, Chapel Hill, NC

Tableau Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Connecting wif data, Using teh Tableau interface / paradigm to TEMPeffectively create powerful visualizations.
• Create calculations including string manipulation, advanced arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Representing data using various visualizations types: crosstabs-scatter plots, geographical maps-pie and bar charts, motion charts- small multiples, heat maps-density charts, tree maps-highlight tables, different mark types on dual axis/combo charts, drill down/drill across on dashboards.
• Build advanced chart types and visualizations: bar in bar charts - bullet graphs, box and whisker plots - pareto charts, build complex calculations to manipulate data, using statistical techniques to analyze data, using parametersand input controls to give users control over certain values, implement advanced geographic mapping techniques.
• Used statistical techniques to describe data Using groups, bins, hierarchies, sorts and filters to create focused and TEMPeffective visualization.
• Utilized Measure Name and Measure Value fields to create visualizations wif multiple measures and dimensions.
• Handle changes in data source such as field addition, deletion or name changes. Sharing visualizations wif business users.
• Combine visualizations into interactive dashboards and publish them to teh web.
• Involved in Planning, Defining and Designing database using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for teh application.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface teh database and other applications in most efficient manner.

Environment: Tableau Desktop, Tableau Reader, Tableau Public, Tableau Server 7/8, Tabcmd, MS SQL Server 2012, T-SQL, SSIS 2012, SSRS 2012, TFS 2010, SSMS, Erwin v7.2, ASP.Net, MS Office 2010/2013.

Confidential

Tableau Developer

Responsibilities:

• Involved in developing warehouse, including requirement gathering, requirement definition, operations analysis, technical design and implementation.
• Worked wif business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Actively involved as part of a team for gathering and analyzing teh needs of End User Requirement and System Specifications.
• Designed various practical Data Visualizations, Charts, Dashboards published it in various Tableau workbooks for Analytical Projects and Data Visualization teams.
• Create Data Extracts connecting to Teradata database, writing Free hand Sql Using SQL assistant.
• Created Complex workbooks and Dashboards by connecting to multiple data source using data blending.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Designed and implemented near-real-time monitoring Dashboards for Tableau Server and Visualization users.
• Designed and developed monthly, quarterly and yearly reports for branches.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored teh overall performance of teh database to recommend and initiate actions to improve /optimize Performance.
• Used SQL Server Profiler to trace teh slow running queries and teh server activity.

Environment: Tableau Desktop, Tableau Reader, Tableau Public, Tableau Server 6/7, Tabcmd, SQL Server 2008R2, SSRS, SSIS, SSAS, Oracle, DB2, MS Office 2007/2010, MS BIDS, Windows 2008 Server, Visual Studio 2008, VB. Net, C#.net, Performance Point Server.

Confidential, NJ

Tableau Developer/SQL Server Developer

Responsibilities:

• Worked wif application developers and production teams across functional units to identify business needs and discuss solution options.
• Involved in reviewing business requirements andanalyzedata sources from Excel/Oracle SQL Server to design, develop, test report and analyze projects wifinTableauDesktop.
• Worked a great extent wif teh design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Installed and upgraded Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and teh appropriate permission sets for Tableau server logons and security checks.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Produced Crosstabs to display underlying data based on various graphs and charts created for further data analysis.
• Automated teh migration of data from Flat file to MS SQL Server 2008R2 using Microsoft SQL Server Migration Assistant (SSMA).
• Generated assessment reports to analyze teh scope and complexity of teh migration projects.
• Designed a new schema design for teh data warehouse using dimensional modeling and developed it using teh Erwin tool.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing wif different data sources (SQL Server, CSV, Flat Files etc.) and loaded teh data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• 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 teh requirements and changes specified by teh users.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface teh database.

Environment:MS SQL Server 2005/2008,SQL Server Reporting Services, T-SQL, Crystal Reports 10,Visual Studio 2005/2008,Erwin, MS Office 2003/2007, SQL Profiler, Windows server 2003.