SUMMARY

• Having 7+ Years of experience in Tableau Solutions Consultant with BI experience.
• Expertise in data cleaning for analysis, perform data quality testing for gaps, and liaising with data origination teams.
• Introduced Tableau to my team to produce beautiful data visualizations to clients and to help them make effective business decisions.
• Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms.
• Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
• Have been working with various data sources such as Oracle, SQL Server, ODBC and flat file sources.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau Server and Reports.
• Experience in Installation, Configuration and administrationof Tableau Server in amulti - serverandmulti-tierenvironment.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Developed Query for generating drill down reports in SSRS 2005.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status..
• Experienced in Business Intelligence (SSIS, SSRS), Data Warehousing and Dashboards.
• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Migrated SSRS Reports to Performance Point server 2007 and published them on to SharePoint.
• Expertise in using Version controllers likeTFS, Visual SourceSafe and Clear Case.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Specialties: Data Visualization, Business Intelligence (BI), Software Management and Data Collection.

BI Tools: Tableau 6.0/6.1/ 7.0,Tableau 8.0/8.1,OBIEE 10g,11g,SSRS.SSIS

Relational Databases: MS SQL Server 2005/2008/2012 , Oracle 8i/9i/10g/11g, MS Access.

Tools: and Packages: SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio, Crystal Reports.

Languages: SQL, PL/SQL, C, C#, ASP.Net, HTML,CSS, XML, XSL

Web/App Servers: MS IIS 5/6.0, Apache Tomcat, Web logic Server 8.1/9.2/10, JBoss

Operating Systems: Windows 2008, Windows 2000/2003 Server, Windows NT, Windows 95/98/2000 XP, UNIX, LINUX.

PROFESSIONAL EXPERIENCE

Confidential, Frankfort, KY

Sr. Tableau Developer

Responsibilities:

• Involved in installation of Tableau desktop 7.0, Tableau server Application software.
• Participated in discussions for Tableau Server architecture design on Cloud, enhancing performance, scalability and high availability.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to Create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls.

Environment: Tableau Desktop 8.1/8.0/7.0, Tableau server / Administrator, tabcmd, XML, SQL Server 2008.

Confidential, Providence, RI

Tableau Developer

Responsibilities:

• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Embedded live Tableau dashboards on PowerPoint presentations, keeping the slides always updated.
• Created dashboards for System Services Company to measure performance of their field engineers and manufacturer defects.
• Also re designed the data source having data from different sources into one SQL Server and to tableau.
• Also developed a process in the company to generated tableau dashboards, which can be used for all the clients in the company by gathering the requirements.
• Setup stand alone and distributed Tableau Server to publish and distribute dashboards easily.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Connected tableau server with SharePoint portal and setup auto refresh.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.

Environment: Tableau Software 7.0, 8.0, Microsoft office, SQL Server, SharePoint.

Confidential, St. Louis, MO

Sr.BI Analyst/ Sr. Data Analyst

Responsibilities:

• Created complex T-SQL queries, stored procedures, and user defined functions (UDF’s) to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1.
• Built complex formulas in Tableau for various business calculations.
• Experience in dynamic configuration of packages in SSIS.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Organized Error and Event handling by giving Precedence Constraints, Break Points, Check Points, Logging and viewers in SSIS.
• Created and assisted users in Tableau dashboard development.
• Designed and developed reports such asDrill down, Drill Through usingMicrosoft Reporting Services.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Optimized the performance of queries with modifications in T-SQL queries, eliminated redundant and inconsistent data, established joins and created indexes whenever necessary.
• Experience in generating on-demand and scheduled reports for business analysis or management decision.
• Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Involved in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.
• Documented all database objects, procedures, views, functions & packages for future references.
• Merged Data from Heterogeneous Data stores and Legacy System implementing SSIS on the System.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS)/DBA, Oracle 11g, Toad, MS Office, Team Foundation Server, Visual Studio 2010

Confidential

SSRS Developer

Responsibilities:

• Experience in generating on-demand and scheduled reports for business analysis or management decision
• Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS and Crystal Reports.
• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files, Oracle etc.
• Experienced into Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups in SSIS.
• Documented all database objects, procedures, views, functions & packages for future references.
• Generated parameterized/Drilldown reports using SSRS and Crystal Reports.
• Write an Adhoc queries for Business analysts to extract required daily data.
• Weekly receive .txt and Excel files to update the tables in DB.
• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files, Oracle etc.

Environment: SQL SERVER, Business Intelligence, T-SQL, SSRS, SSIS, MS Excel, MS Office.

Confidential

MS SQL (SSIS/SSRS) Developer

Responsibilities:

• Responsible for analysis, requirements gathering, documentation of functional/technical Specifications, data mapping, development and testing.
• Worked on Full life cycle development (SDLC) involved in all stages of development.
• Created different types of reports in SSRS such as parameterized and cascaded parameterized reports.
• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Developed multiple Enterprise reports Using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Wrote complex queries, CTE’s (Common table expressions), stored procedures, functions and views to ensure data integrity, data consistency and to meet the business rules.
• Creation of UAT test cases for regressive testing of modifications and up gradations in monthly report.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
• Migration of DDA and TDA data Weekly also Monthly data from 2005 Server to 2008 Server.
• Created OLAP Cubes from the integrated data and generated reports on those cubes.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports.
• Design and develop SSRS reports for crystal reports.
• Worked on error handling a module consisting of data from bank, transactions, currencies, countries, master, static etc.
• Worked on the dirty source data that resulted in errors.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Wrote Parameterized Queries for generating Tabular reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005.
• Designed reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports.

Environment: MS SQL Server 2000/2005/2008, T-SQL, SSRS, SSIS, MS Access.