SUMMARY

• Well Versed expert with skillful management and technical work experience for 6+ years in Tableau, SQL server BI tools,creating visuals, building dashboards, generating reports and customization to meet needs of end - user.
• Extensive ability to design and display Graphic rich visualizations with Filters, Drill Downs and Parameters.
• End to end experience in Installation and configuration, designing and deploying data visualizations using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to requirements specifications and experience with designing complex dashboards taking advantage of all tableau functions mainly includingdata blending, actions, etc.
• Established Standards and Best Practices for EnterpriseTableauEnvironment, application on boarding and development processes.
• Expertise in transitioning reports from Excel to Tableau.
• Good Knowledge on Tableau Server Concepts like tabcmd, tabadmin, creating users, sites and projects.
• Extensiveexperience in troubleshooting, performance tuning and supporting Business reporting platforms.
• Ability to drive insight by designing visualizations with logical and meaningful data flow and ability to see patterns.
• Expertise inSQL Server Integration Services(SSIS),SQL Server Reporting Services (SSRS), with good knowledge onSQL Server Analysis Services(SSAS).
• Extensive experience with SQL Server and T-SQL in constructing tables, views, triggers, indexes, functions, stored procedures, user profiles, relational database models, data dictionary, data.
• UsedSSISto createETLpackages to extract, transform, validate, and load data to data warehouse, data marts and various databases like SQL SERVER, ORACLE, SYBASE
• Business intelligence project work Expert withSQLand PL/SQLExperienced withSQL-Server databases
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Experienced in data loads, database integration/conversions, performance tuning, and query optimization.
• Familiar with entire software development life cycle (SDLC)and various software development methodologies such as Agile/Scrum and Waterfall Methodology.
• Extensive experience in Data warehousing, Data Marts, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing, Documentation and designing and handling multi-dimensional data structures.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases, SQL Server, Teradata, MS Access, Business Requirements Gathering and Process Engineering, Evaluating Data Sources and Translating Requirements into Specifications.
• Involved in elicitation process to acquire technical specifications from the client.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments with Excellent communication skills, strong team-building and conflict management skills.
• Experience training end users through online and in-class sessions.

TECHNICAL SKILLS

Reporting Tools: Tableau 9.3,9.2, 8.x,7, SQL Server Reporting Services (SSRS) 2008/2005, Microsoft Excel Reports, Crystal Reports

Operating Systems: Windows XP Professional, Windows 2003, Windows 7,MS Windows 9X, Windows 8,UNIX, Linux

Databases: MS SQL Server 2014/2012/2008 R2/2005, MS Access, Teradata, Oracle 9i

Database Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, Import/ Export Wizard, SQL Server Management Studio, Index Analyzer, Business Intelligence Development Studio(BIDS), SQL Server Data Tools (SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS))

External Tools: Quality Center, MS Visio, MS Office, IBM Lotus Notes 8.5.2, Microsoft Outlook

IDE Tools: Microsoft Visual Studio 2010/2008/2005

PROFESSIONAL EXPERIENCE

Confidential, Seattle

Sr. Tableau Developer

Responsibilities:

• Involved in Exploring, Designing, Building, and Deployment of the high level dashboards for Board of Directors, Decision makers, Finance for critical metrics using Tableau.
• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Having Good experience in Tableau Business Intelligence for dashboard development.
• Presented discovered trends and analysis, forecast data, recommendations and risks identified to the higher management.
• Coordinating and conducting business, systems requirements analysis meetings with business and technology partners, business analysts, data modelers, solution architects, DBA's and project managers.
• To understand Business requirements, analysis and rendered into Application and operational requirements.
• Writing SQL validation queries for cross testing the resulting data from the reports.
• Revised the Group Structure of tableau users in both Development and Production Environments.
• Operated in all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Created many worksheets for dashboards that involve Scatter plot, Histogram chart, Bar charts, trend lines, Pareto chart, Map charts etc.
• Assisted Business users and recommended features, charts, KPI’s for their business analysis in Tableau.
• Created Cascading dashboards, data extracts Action filters for better performance of Tableau.
• Used data sources arise fromSQL, Oracle, Salesforce, SSAS cubes and files to generate reports in Tableau.
• Created many parameters, quick filters, sets and shapes for better navigation in Tableau dashboard
• Performed many presentations to business users on data analysis and dashboard features.
• Created complex table calculations involvingMoM, YoY, Moving average, Diff from average in tableau
• Implemented swapping measures as a parameter for bars and tables in tableau.
• Used action filters for better navigation throughout dashboard in tableau particularly using URL action for sending emails when selected.
• Connected to various data sources that arise fromGoogle analytics, Amazon Redshift, Oracle, and SQL to tableau.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAScubes.
• Published Workbooks that utilize user filters.
• Involved actively in supporting the various issues addressed by the users from the client end and providing them with required solutions.
• Well versed Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.

Environment: Tableau 9.3, 9.2, 8.x,SQL Server 2014, SSAS, SSIS, SSRS, Import/Export tools, PL/SQL, SQL Server Agent, T-SQL, SVN source control

Confidential, Providence, RI

Tableau BI Developer/ Data Analyst

Responsibilities:

• Work with customers to define reporting needs and implementTableaureports to satisfy needs.
• Design and create daily, monthly and ad-hoc reports for BI and Analytics customers
• Provide recommendations for data presentation within reports/dashboards
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Connected Tableau server to publish dashboard to a central location for portal integration
• Connected Tableau server with share-point portal, setup auto refresh feature and Embedded Tableau views in to SharePoint using JavaScript to achieve.
• Created visualization for logistics calculation and department spend analysis.
• Generate KPI for customer satisfaction survey results and disease management.
• Maintained Test log and Wrote Test Evaluation, Summary Reports.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Extensively involved in doing user acceptance testing (UAT).
• Support for end users connected to servers in various departments with regard to connection and data access issues
• Played a major role in production support of SSAS cube and SSIS jobs and wrote MDX queries and did performance optimization of the SSAS cubes.
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse and data marts
• ImplementedIncremental load, usedEvent Handlersto clean the data from different data sources
• 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.
• Generated tableau dashboards for sales with forecast and reference lines and generated interactive dashboards with an implementation of Data blending on databases.
• Created SSIS packages to clean and load data to data warehouse and created package to transfer data between OLTP and OLAP databases.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved withQuery Optimizationto increase the performance of the Report.
• EmployedFiltered Indexesto improve query performance and reduce the storage and maintenance cost.

Environment: Tableau 8.x.7, SQL Server 2012, PL/SQL, SSAS, SSRS, Microsoft Visual Studio 2010.

Confidential, Chicago, IL

Tableau Developer

Responsibilities:

• Data blending implemented on databases and generated interactive dashboards in Tableau.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, involved in Debugging and monitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Installed, configured, monitored and maintaineddatabasesin the production, development, andqualityassurance environments.
• Design, create and maintain database objects.
• This includes all database physical and logical primary objects such as table spaces, data files, tables, clusters, indexes, views, sequences, packages, procedures, etc.
• Developed complex stored procedures usingT-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Created Unit Test Cases and documented the Unit Test Results.
• Conducting the Unit testing of the module to identify the bugs.

Environment: Tableau 8.x.7, SQL Server 2008, SSRS, Microsoft Visual Studio 2010, Microsoft Visual Studio 2010.

Confidential, Minnetonka, MN

SQL developer

Responsibilities:

• Created complex SQL stored procedures and functions using Microsoft SQL Server 2008R2
• Involved in code review and code review meetings
• Involved in error handling, performance tuning of stored procedures
• Used Team Foundation Server for version control needs, track check-ins and roll back code as necessary
• Coordinated with Technical Analysts in understanding the business requirements and translated them in to technical specifications
• Analyzed the data as per business needs to build the Interface.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created Views and Index Views to reduce database complexities for the end users.
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Developed Scheduled Jobs to automate the packages.

Environment: ASP.NET, SQL Server 2005, Visio

Confidential

Jr. SQL Server Developer

Responsibilities:

• Applied Normalization rules in designing the database.
• Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
• Developed database objects like tables, views, stored procedures, indexes etc. Fine-tuned the logic in
• Procedures, Functions and Triggers for optimum performance.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Rebuilding the indexes at regular intervals better performance.
• Written various stored procedures for the purpose of application development.
• Design and implemented data access stored procedures and triggers for automating tasks.
• Used joins and sub-queries to simplify complex queries involving multiple tables.
• Worked on crystal reports with many complex stored procedures.
• Created multi-format reports using Crystal report.

Environment: SQL Server 2005, Crystal Reports, MS Office and windows 2003/7, T-SQL