PROFESSIONAL SUMMARY:

• Qualified Professional with 8+ of experience with Databases, Report design, Data Visualization and Business Intelligence tools like Tableau, SSRS.
• Experience in working with Tableau 8.x/9.x/10.x/2018.x/2019.x, Tableau Server, Tableau cloud, Tableau Online, Tableau Public, Tableau Reader, Tableau mobile, SSRS.
• Experience gathering customer requirements , writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Created dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop and organizing Dashboard views and objects.
• Experience in Tableau Server, creating users, groups, projects, providing access levels.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
• Created various MSBI reports that include Charts, Filters, Scorecards, Drilldown and Drill - Through, Cascade, Parameterized reports that involved conditional formatting.
• Experienced in extraction, transformation and loading of data directly from different source systems like Flat files, Excel, and MS SQL Server.
• Extensively used Custom SQL queries to import and manipulate data.
• Created various Mappings by using different kinds of transformations like Source Qualifier, Expression, Join, Lookup, Filter, Rank, Sequence Generator, Stored Procedure, Router, Normalize, Transformations
• Expert level capability in SSRS and applying complex, compound calculations to large and complex data sets.
• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts
• Experience working with Agile Methodology.
• Extensive experience in Preparing Flow Charts, Analysis Reports, Technical Design documents, Profiling.
• Creating user’s groups projects Data connections settings as a tableau administrator, Handled Tableau admin activities.
• Have expertise in Industry’s best practices, Preparing User Manuals, Presentations, Bug Fixing, Troubleshooting, Root Cause analysis and Solution Development.
• Have valuable experience in Managing Team Offshore and Onshore to Coordinate Work with effective communication skills, documentation skills, interpersonal skills and self-motivated, quick learner, team player.
• Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements for reports.

TECHNICAL SKILLS:

Tableau Desktop 2019.x,2018.x,10.5,10.1/9.2/8/7, Tableau Server 2019.x,2018.x,10.5,10.1/9.2/8/7, Tableau Online, Tableau Public, Tableau Reader, SQL Server 2017/2016/2014/2012/2008 R2/2008, SQL Server Reporting Services (SSRS), Microsoft Visual Studio, Microsoft Office (MS Word/Excel/PowerPoint/Project), HTML, XML, Visio, Windows Advanced Server.

PROFESSIONAL EXPERIENCE:

Confidential, Madison WI

Tableau Developer

Responsibilities:

• Roles and responsibilities include developing, enhancing, re-engineering, maintaining and supporting Tableau applications .
• Involved in full project lifecycle of SDLC and coordinated with all project teams
• Involved in reviewing business requirements and analyzing data sources form Excel/SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Actively participated in Business Intelligence standardization to create database layers with user friendly views in SQL Server that can be used for development of various Tableau reports/ dashboards .
• Designed and developed a business intelligence data visualization dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data .
• Used LOD (Level of Details) functions like Fixed, Include and Exclude in Tableau.
• Created Filled maps, actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Experience in creating and scheduling Tableau data extracts for auto refresh. Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts , customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes .
• Created and modified Interactive Dashboards and Creating guided navigation links within Interactive Dashboards. Make use of filters and making them local and global accordingly.
• Generated stories for Finance team and improved the performance by reducing analysis time.
• Resolved performance issues and worked for better scalability and availability of Tableau desktop.

Environment: Tableau (Desktop, Server) 2019.x, 2018.x,10.5, SQL Server 2012 and Microsoft Office, MS VISO 2013, Profiler, Microsoft Office (Word, Access, Excel, Outlook).

Confidential, Rochester, MN

Tableau Developer

Responsibilities:

• Managed Tableau server subscription and customized view for business users to get their data the way they want at the time they need.
• Make adjustment to existing dashboard, including performance tuning and add more information or filters to the dashboard
• Upgrade and trouble shoot the upgrade of Tableau server, write a step by step instruction for IT department to perform the upgrade.
• Worked closely with Tableau server log files, trouble shoot the Tableau server and Tableau server monitoring.
• Worked a great extent with the design and development of Tableau visualizations which includes preparing dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks based on specific requirements.
• Implement user filters in Tableau dashboard and worksheets or the data source to restrict data access at the data row level.
• Maintaining Tableau data source connections and scheduled refreshes and updates.
• Involved in end to end implementation and enhancements on trading behavior data starting from requirement gathering and dashboards development in Tableau Desktop.
• Created numerous dashboards in Tableau Desktop based on the data collected from financial reporting System by importing and blending data from MS Excel and CSV files along with MS SQL Server Databases.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the data with filters and actions for on demand needed information with just a click of a button.

Environment: Tableau Desktop 10.1/9.2, Tableau Server 10.1/9.2,MS SQL Server 2014, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2010, Windows.

Confidential, Houston, TX

Tableau/BI Developer

Responsibilities:

• Understanding business requirements documents and developing design documents.
• Defined data source and data source views for each report as per client requirement.
• Created Tableau scorecards, dashboards using stack bars, bar graphs and geographical maps
• Created Bar Charts which is complied with data sets and added lines and forecasting.
• Created Crosstab reports to display underlying data based on various graphs and charts created for further data analysis.
• Created context filters to limit data sourced into tableau engine.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Prepared dashboards using calculated fields for different logics for trends, parameters, calculations, groups, sets and hierarchies in Tableau.
• Ensured the user security for the views using User filters and shared with business users.
• Published the developed dashboards into production and refreshed the scheduled extract, tuned the performance of the dashboard and created tableau functional design document.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.

Environment: Tableau (Desktop 9.0 & 9.3, Server), SQL server 2012, SQL, PL/SQL, MS Project, MS Office Suite (Word, Excel, PowerPoint), MS Access.

Confidential

BI Developer

Responsibilities:

• Interaction and coordination with robotics team, data modelers, DBA and managers to achieve better data and requirements for generating visually appealing and accurate reports.
• It is one of an automation projects where 90% of the task is automated and remaining are not sure given to the remote associates.
• Building, publishing customized interactive reports and dashboards using MSBI.
• Developed dashboard reports using bar charts, pie, heat maps, and pivot tables in SSRS.
• Extensively worked to design visualizations with functionality like drilldown, drill through and parameters using SSRS.
• Extensively used stored procedures for building complex datasets within SSRS reports to improve the controllability and overall performance of the reports.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Experience in modifying existing worksheets and analyzing it to develop better visualizations with more detail.
• Tested Dashboards to ensure maximum data accuracy and functionality.

Environment: SQL Server 2012/200R2/2008, Windows 2003/2007 server, T-SQL,SQL Server Reporting Services (SSRS), SQL Profiler, TFS.