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 in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7 and Tableau 8 .
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with 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 knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Highly proficient in the 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 the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008r 2/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 the deadline of any projects.

BUSINESS SKILLS/ 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

WORK EXPERIENCE:

Confidential, NY

Tableau Developer

Responsibilities:

• Directly interacting with clients to elicit the requirements and translate them into terms that 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 the defects detected were tracked and managed using HP Quality Center.
• Produced reporting documents and led weekly meetings with developers and business units to discuss outstanding technical issues and deadlines that 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 the team with appropriate documentation and domain knowledge.
• Perform data modeling, periodic report validation and data analysis by writing SQL queries using TOAD.
• Interaction and coordination with 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 with data, Using the Tableau interface / paradigm to effectively 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 effective visualization.
• Utilized Measure Name and Measure Value fields to create visualizations with multiple measures and dimensions.
• Handle changes in data source such as field addition, deletion or name changes. Sharing visualizations with business users.
• Combine visualizations into interactive dashboards and publish them to the 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 the application.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the 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 with 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 the 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 the overall performance of the database to recommend and initiate actions to improve /optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the 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, Kenilworth, NJ

Tableau Developer/SQL Server Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Involved in reviewing business requirements and analyze data sources from Excel/Oracle SQL Server to design, develop, test report and analyze projects within Tableau Desktop.
• Worked a great extent with the 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 the 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 the migration of data from Flat file to MS SQL Server 2008R2 using Microsoft SQL Server Migration Assistant (SSMA).
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the 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 the requirements and changes specified by the users.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the 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.