SUMMARY:

• Business intelligence professional with 8 years of IT experience in Analysis, Design, Coding, Testing, Migration, Production support and Implementation of Software applications, with around 4 years of experience on Tableau.
• Extensive Tableau Experience in Enterprise Environment, in Tableau 10.x/9.x/8.x/7.x (Desktop, Server, Mobile) as a developer and analyst in using Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop - down menu option and Parameterized using Tableau, preparing Dashboards using calculations, parameters in Tableau.
• End-to-end experience in designing and deploying data visualizations using Tableau.
• Proficient in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Extensive Experience and in-depth working knowledge in various SQL Server tools and business intelligence-based applications like SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, Data base Engine Tuning Advisor, Query Analyzer.
• Solid understanding of RDBMS database concepts including Normalization and solid experience in creating database objects such as tables, views, stored procedures, triggers, cursors, functions, indexes and other T-SQL (DDL, DML) statements for various applications.
• An enthusiastic and goal-oriented team player with excellent analytical, communication and interpersonal skills.
• Outstanding work ethics and time management skills

SKILLSET:

Tableau10.x/9.x/8.x/7.x, MS SQL Server 2008/2008 R2/2012, 2014 SQL Server Integration Services(SSIS)/SQL Server Analysis Services(SSAS)/SQL Server Reporting Services(SSRS), Oracle 8i/9i/10g, MS Share point, Windows NT, Windows XP/ 2003/2000/98, MS VISIO, MS SQL, Profiler, SQL Query Analyzer, SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, San Diego CA

Sr. Tableau developer

Responsibilities:

• Extensive Tableau experience in Enterprise Environment and Tableau Administration.
• Experience includes technical support, trouble shooting, report design and monitoring of system usage.
• Mastered the ability to design and deploy rich graphic visualizations with Drill down and Drop-down menu options with parameters using Tableau desktop.
• Expertise in using various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated fields, Sets, Combined Sets, Groups, Parameters in Tableau.
• Good hands on experience in developing the Dashboard reports using ‘Key Performance Indicators’ for Top management for quick decision making to drive the business.
• End to End experience in designing and deploying data through different environments.
• Built many Tableau visualizations using Heat Maps, Box Whisker Charts, Scatter plots, Geographic Maps, Pie Charts, Density Charts and Stacked Bar charts.
• Worked extensively with Advanced Actions, Background images, Trend lines, Statistics and Table Calculations.
• Extensive experience in using ‘Level of Detail’ using Fixed, Include and Exclude.
• Provided Production Support to Tableau users and wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as setting permissions, managing ownerships, and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Very strong Dashboard design experience and passionate in building effective data visualizations.
• Familiar with best Practices around visualization and design.
• Good understanding of business environment, excellent communication skills and ability to work proactively in a fast-paced environment.
• Communicate effectively with colleagues and business users.

Environment: Tableau Desktop 2018.02, 10.5, 10.3, 10.2, Tableau Server 10.3, SQL developer, SQL Server 2016, Service Now, T-SQL, SSIS, SSRS, Microsoft SharePoint, Microsoft Excel, MS Access, Windows 2007 server.

Confidential, Los Angeles, CA

Sr. Tableau developer

Responsibilities:

• Using Tableau server as a front-end BI tool and Microsoft SQL Server 2012 as a back-end database designed and developed workbooks, dashboards, global filter page, and complex parameters-based calculations.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Built, published customized interactive reports and dashboards, report scheduling using Tableau server.
• Built dashboards for measures with forecast, trend line and reference lines.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Provided 24/7-production support for Tableau users.
• Responsible for security, administration, release management, troubleshooting and performance tuning.
• Migrated and upgraded SQL Server 2008 database to SQL Server 2014 environment using upgrade advisor and tested their applications.
• Installed and configured the database server (SQL Server 2014) in production, development and testing environments.
• Developed Stored Procedures, Triggers, Functions, and T-SQL scripts.
• Running synchronization process between production, staging, testing and development environment.
• Writing new stored procedures and modifying existing ones and tune them such as they perform well.
• Implemented auditing using triggers and enforcing business rules via checks and constraints. Proper use of views to prevent unauthorized access to sensitive data.

Environment: Tableau Desktop 9.x, Tableau server / Administrator, SQL developer, SQL Server, T-SQL, SSIS, SSRS, Microsoft SharePoint, Microsoft Excel, MS Access, Windows 2007 server.

Confidential, Houston, TX

Tableau Developer

Responsibilities:

• Worked on Reports from requirement gathering to Report Development and involved in migrating it to production.
• Effectively implemented data blending on databases and generated interactive dashboards.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts, Reference lines, bands, Distribution, Trend Lines.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards
• Connected to MS SQL Server 2012 directly to pull data into Tableau and created extracts.
• Created multiple visualizations like Bar Graphs and Bullet Graphs and Prepared Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Developed database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Administer and support a multi-tier Tableau infrastructure including upgrade analysis and planning, security administration, release management, troubleshooting, performance tuning, and general systems maintenance.
• Connected Tableau server with SharePoint portal and setup auto refresh feature.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Provided Weekly, Monthly metrics and presentations to management on production issues.
• Developed Stored Procedures, Triggers, and created indexes. Created Database Tables and database views.
• Created and implemented batch job processing, scheduling and production support.

Environment: Tableau Desktop 8.2/8.1, Tableau server / Administrator, SQL developer, SQL Server2008, T-SQL , SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS) T-SQL, SharePoint server, Microsoft Excel, Microsoft Outlook.

Confidential

ETL Developer

Responsibilities:

• Helped in translating business requirements into technical design specifications and preparing high-level documentation of the Database Design and Database Objects.
• Created SSIS packages to extract data from OLTP to OLAP systems and created alerts for successful and unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Created reports to retrieve data using Stored Procedures that accept parameters depending upon the client requirements.
• Performed error handling using script task and event handlers.
• Planned and Designed SSIS packages based on the business requirements.
• Wrote complex T-SQL queries and Stored Procedures for generating reports.
• Used various SSIS tasks such as Conditional Split, Merge Join, and Derived Column on the data retrieved, Data conversion, OLE DB Command, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.

Environment: MS SQL Server, Business Intelligence Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Query Analyzer, SQL Profiler, PL/SQL.

Confidential

SQL Developer

• Planned and Designed SSIS packages based on the business requirements.
• Participated in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project.
• Created a process to programmatically create ODBC System DSNs within an MS Access database.
• Developed MS Access Data Analysis reports.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using (SSIS).
• Involved in User Acceptance Test throughout the process.
• Performed error handling using script task and event handlers.
• Used various SSIS tasks such as Conditional Split, Merge Join, and Derived Column on the data retrieved, Data conversion, OLE DB Command, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Wrote complex T-SQL queries and Stored Procedures for generating reports.
• Created sub-reports, drill down reports, summary reports, parameterized reports and ad-hoc reports using SSRS.

Environment: MS SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Windows XP, Microsoft Word.