SUMMARY

• Extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 8.1 as a developer and Administrator
• Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets,create visually compelling and actionable interactive reports and dashboards.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Extensive experience on building Analytic Dashboards using Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Over 6 years of professional experience in client requirement Analysis, Physical and Logical design, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000/7.0, DTS, SSIS,SSRS and SSAS.
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services SSIS/DTS.
• Experience in developing different types of Tabular Reports, Matrix Reports, Drill - Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS) using SSRS.
• Involved inTrouble Shooting, Performance tuning SQL Serverand resolving issues within Tableau Server and Reports.
• Experience in Data Conversion and Data Migration from earlier versions to current SQL server using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experienced with SQL Server and T-SQL in constructing triggers, tables, views, stored procedures, user defined functions, indexes, user profiles and relational database models with data integrity.
• Experienced in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule ETL Packages.
• Experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Excellent verbal and written communication skills combined with strong interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS

Databases & Related Technologies: SQL Server 2008/2005, Oracle 11g/10g/, MS Access, DB2 MS excel 2010, MS Share point

Operating Systems: Windows 8/7/XP/2003

ETL/BI Tools: SSIS (SQL server integration services), SSRS, BIDS,DTS

Modeling Tools: MS-Visio

Reporting Tools: SQL Server Reporting Services

Languages: T-SQL, SQL, PL/SQL, C, C++, JAVA, VB, MS ACCES

Office Tools: Microsoft Office / and XP

PROFESSIONAL EXPERIENCE

Confidential, VA

TABLEAU DEVELOPER/DATA ANALYST

RESPONSIBILITIES:

• Developed various data connections from data source toTableauServer for report and dashboard development.
• Analyzing the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions.
• Developing predictive statistical models using statistical analysis and other predictive modeling techniques.
• As aTableauDeveloper, usingTableaufor Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and various analysis.
• Analyzing the data of patterns, trends and fashions of various KPIs, Measures using various graphs, charts, pivot tables.
• Worked across departments to identify and understand key business questions, and standardize key metrics and measure.
• Analyzed and gained understanding of the underlying data and generatedTableaudashboards with forecast and reference lines.
• Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Waterfall and Agile project methodology approach.
• Act asTableau(for designing and developing, proto typing the various dashboards usingTableau desktop.
• Also involved extensively for building the dashboards such as creatingTableauExtracts, Refreshing extracts,TableauLayout designing,TableauWork Sheet
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Demo ofTableaudashboard to users to enhance their knowledge on all the key capabilities of application.
• Created Actions, Parameters, Filters and calculated sets for preparing dashboards and worksheets usingTableau.
• Worked on querying data and creating on-demand reports usingTableauDesktop and publish the same to Server.
• Used Tab admin and commands in creating backups and restoring backups ofTableaurepository.
• Monitored and maintained incremental refreshes for data sources onTableauserver.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders.
• Focus on getting end-users up to speed onTableaucapability.
• Worked with Individual Axes, Blended Axes, and Dual Axes.
• Worked on multiple Complex tables through custom SQL.
• Generated several drills down and drill up reports.

ENVIRONMENT: Tableau Desktop 8.0, 7.0, 6.02, Tableauserver / Administrator, Oracle 10g, Microsoft Excel 2007,MS Access, Microsoft office, SQL server, SSIS, SSRS.

Confidential, VA

TABLEAU CONSULTANT / BI & ETL DEVELOPER

Responsibilities:

• Extensively worked on production support that includes Deployment ofSSISPackages into Development, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
• CreatingSSISPackage Configurations and maintaining their Tables by editing the values of the variables as per the requirement.
• Closely worked with DBA teams in the maintaining the databases and trouble shoots experiencing from the users
• Worked on Data migration project by validating three source data row by row and field by filed
• Worked on re-design of the fewSSISPackage which involved very complex logic and more than a hundred tables and tasks and developed simplified version of the Packages.
• Created Rich dashboards usingTableauDesktop and prepared user stories to create compelling dashboards to deliver actionable insights.
• Performed data refresh onTableauServer on weekly, monthly and quarterly basis and ensured that the views and dashboards were accurately displaying the changes in data.
• Installed & Configured Tableau on Windows servers.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.

ENVIRONMENT: S: Tableau Server 8.0.3/7.1/6.0, Tableau Desktop 8, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008, TSQL, UNIX, Linux, RHEL 5.4. SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).

Confidential

BI DATA ANALYST

Responsibilities:

• Responsible for all reports creation, deployment and bug fixing.
• Fixed defects and failures using methods such as modifying code, fixing incorrect joins and replacing sub selects with joins.
• Performed tuning and optimization of queries for reports that take longer execution time using SQL Profiler, Index tuning wizard and SQL Query Analyzer.
• Created User Defined functions and used it for creation of stored procedures.
• Involved in creating views to facilitate easy user interface implementation.
• Created different types of reports such as tabular, matrix, drill down and sub reports.
• Wrote parameterized queries for generating tabular reports using expressions, functions, defining data sources.
• Generated reports using SSRS that were used to send information to different vendors, Clients and mangers.
• Added subscription and Snapshot options to deliver the reports to end users.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Created OLAP cubes on top of data warehouse based on facts and dimension tables for analysis purpose using SSAS.

Environment: SQL Server 2008 R2, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Windows Server 2008, VB.NET, Business Intelligence Development Studio (BIDS), Visual Source Safe.