PROFESSIONAL SUMMARY:

• Business intelligence professional with 8+ years of IT experience in Analysis, Design, Coding, Testing, Migration, Production support and Implementation of Software applications, which also includes 5 years of experience on Tableau.
• Extensive Tableau Experience in Enterprise Environment, in Tableau 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.
• Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs
• Extensively worked with Ranks, filters, prompts, variables and calculation contexts in designing reports.
• Extensive knowledge in Dimensional data modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modeling.
• Good understanding of Tableau Desktop architecture for designing and developing dashboards.
• 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

TECHNICAL SKILLS:

• Tableau Suite of tools 10.5/10.3/10.2/9. x/8.x/7.x
• Tableau Desktop
• Tableau Server
• MS SQL Server 2008/2008 R2/2012, 2014
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• T - SQL
• Service-Now
• GIT
• 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:

Sr. Tableau Programmer Analyst

Confidential, San Diego, CA

Responsibilities:

• Worked closely with business stake holders to understand the business requirement.
• Interacting with business to understand and identify the dimensions, measures and metrics they needed and done gap analysis in documenting BRD.
• Involved in designing and developing the architecture of reporting layer.
• Designed lot of mockup dashboards and reviewed with business and solution architecture team in the reporting layer and suggested changes and modifications to the model
• Developed POC for user security for restricting users to access the data in dashboards.
• Developed powerful and most interactive Profit and Loss dashboards for business for easy comparison of ‘Actuals’ with various types and versions of Forecast.
• Expert level capability in Tableau Calculations and applying complex, compound calculations to large complex sets of data
• Mastered the ability to design and deploy rich Graphic visualizations with Drill-down and Drop- down menu options and Parameterized them using Tableau.
• Hands on building Groups, Hierarchies, Sets, Calculated fields, Table Calculations to create detailed level summary reports and Dashboards using KPI’s.
• Designed Weekly, Monthly and Daily reports using Tableau Desktop and published them to server to share it with Business Users.
• Extensively used LODs, Date Calculations and derived complex business logics and projected the reports to Users as business expected.
• Developed Interactive Dashboards with blended views and provided multiple filtering options and action filters for optimal interaction.
• Maintained published extracts, extract refreshes, created new projects in Tableau server as and when required and defined the roles and securities.
• Automated extract refreshes in Tableau server with ETL loads and tracked the refresh time frames and optimized them for better performance.
• Also used performance recorder extensively to check the time consumed for each action and improvised the SQL queries for better performance.
• Developed and optimized complex SQL queries for querying data against different databases for data verification, checking duplicates, null values and ensuring correct data aggregations as a part of validating workbooks and dashboards.
• Actively participated in final UAT phase in assisting and leading the users in testing the data in the ad-hoc workbooks and dashboards.
• Aggressively worked and resolved service now tickets raised by users in UAT and Production support.
• Worked on various ad-hoc issues in Production and user support.

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

Sr. Tableau Developer

Confidential, Los Angeles, CA

Responsibilities:

• 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.
• Building, publishing 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 10.1/ 9.0/ 9.2 , Tableau Server 10.1 / 9.0.3, SQL developer, SQL Server, T-SQL, SSIS, SSRS, Microsoft SharePoint, Microsoft Excel, MS Access, Windows 2007 server.

Tableau Developer

Confidential, Houston, TX

Responsibilities:

• Worked on Reports from requirement gathering to Report Development and also 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.
• 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 10.1/9.0/9.2 , Tableau server 10.1/9.0.3, SQL developer, MS SQL Server2008, T-SQL, Microsoft SharePoint, Microsoft Excel, MS Access, Windows 2007 server

Tableau Developer

Confidential, Reston, VA

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation for the collected data.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Preparing Dashboards using table level calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Creating Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Also used DTS packages for creating job on the SQL Server 2000. Creating and integrating User Defined Functions and Stored Procedures for reporting purpose.
• Developed Ad-Hoc reports, sub reports, drill down reports, parameterized reports and dirty reports.
• Designing and testing (Unit, Integration and Regression) packages to extract, transform and load data using (SSIS)
• Designing packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Moving the entire phase from the Staging to the Production.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS packages which download files daily from web and load in to databases using FTP Component, For Each Loop.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user and reporting requirements.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager.

Environment: Tableau Desktop 8.3/8.0/7.0, Tableau server, MS SQL Server 2005/2008/2008 , SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS), SharePoint, Windows XP, Microsoft Office 2003, Microsoft Outlook

SQL Developer

Confidential

Responsibilities:

• 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 2003.