Sr. Tableau Developer Resume Kansas City - Hire IT People (2024)

SUMMARY

• Around 7+ years of Experience in Information technology and a good professional experience in Business requirements gathering, business intelligence, development, Testing, documentation, coding, product design, good management skills. Capable of understanding projects in different levels and business Intelligence implementation and maintenance, Data warehousing, good in web application development.
• Professional experience on Tableau Desktop, Reader and Server. (Tableau versions 7 / 8 / 9/10)
• Analyzing and acquire experiences into large data sets, create visually compelling and actionable interactive reports and dashboards.
• Define specifications, design, and build of Tableau desktop reports and dashboards.
• Installation setup, performance tuning, user management and other administration of Tableau Server.
• Professional expert in Data Visualization development using tableau to creating complex, intuitive and dashboards.
• 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 Tableau’s Advanced Capabilities.
• Implemented Data blending on multiple data sources and generated interactive dashboards.
• Used Performance monitoring tool of tableau desktop to analyze the performance of data heavy dashboards and implemented the best practices to improve the end user experience.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Professional expert in roles such as BI End - to-End and solution implantation expert in data warehouse, BI KPIs modeling.
• Expert in designing customized interactive dashboards in tableau using marks, Action, filters, parameters, Security Concepts, calculations, and relationships.
• Expert in RDBMS concepts and constructs along with Database objects creation such as tables, Index’s, stored procedures, Views, user Defined functions, Triggers, and cursors.
• Extensive knowledge in creating Tableau scorecards, bar graphs, dashboards using stack bars, geographical maps, scattered plots, Gantt charts using show me functionality.
• Good experience in Software Development Life Cycle like project documentation design, testing and production development.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Involved in the installation of Tableau Server Application software, Tableau Desktop 8.0.
• Expert in Tableau Administration Tool for configuration, adding users, managing licenses, and data connections, scheduling tasks.
• Good experience on Databases skills with testing complex SQL & PL/SQL queries.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expert in modeling, Extraction Transform and Loading (ETL) using DTS and SSIS.
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS. Proficient in handling parameterized reports in SSRS.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server
• Extensive Dimensional Modelling experience in Star Schema/Snowflake schema design, Fact, and Dimensions tables.
• Having knowledge onETLtools likeInformaticaand all Informatica Designer tools including (Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer).
• Extensive knowledge on various Internet-related platforms with specialization in SQL, PL/SQL, VB, HTML, DHTML, and XML.1
• Good communication skills, collaboration & am building skills, ready to work with new team employees, flexible to work in different project levels.

TECHNICAL SKILLS

BI Tools Experience: Tableau (Desktop 7 to 10, Tableau Server and Reader), Microstrategy

Data warehousing ETL Tools: Informatics Power Center 8 .X,7.X

Operating Systems: Windows 95/98/XP/2000/2003, UNIX, Linux.

Languages: HTML, CSS, JSP, SQL, PL/SQL, Python, Java, C, R.

Databases: Teradata, ORACLE 9i, 10g, 11g, DB2, MS SQL Server 2012, and MS-Access.

Software Packages: MS-Office 2003, Microsoft Word, Excel and Power Point.

Database Tools: Toad, SQL Navigator.

PROFESSIONAL EXPERIENCE

Confidential, Kansas City

Sr. Tableau Developer

Responsibilities:

• Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
• Worked in Tableau environment to create dashboards like Yearly, monthly reports using tableau desktop & publish them to server.
• Converted Excel Reports to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports.
• Used advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Created affinity analysis dashboard and Radical charts for better better understanding data.
• Used Trend Lines, Reference Lines and statistical techniques to describe data.
• Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots,Radical chart Geographic maps, Line chart, Pie charts and etc.,
• Created Financial reports, Demographics. This reports explains the Company profit and employe relationships and we calculated using norm for comparison.
• Used Context filters and Created Geographic map reports which explains the company financial keys according to the members.
• Created Sets, Groups, and Data Bins as per user requirements.
• Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.
• Created views using various axes like Individual Axes, Dual Axes.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Cleared errors according to business requirements excel sheet and helped to create Documentation for the dashboards.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.
• Created SQL Documentation for Benchmark queries and implemented new methods for better performance.
• Provided support for Tableau developed objects and understand tool administration.
• Involved to create Documentation for debugging report for Tableau.
• Developed the table documentation for Tableau Dashboards.
• Enhancement of existing reports to improve performance by modifying the sql code used in extraction of data.
• Worked with subject matter experts to update existing Medicaid Management Information System (MMIS) in order to ensure HIPPA compliance.
• Involved in design requirement meeting with clients and internal employees.
• UAT testing of the reports developed along with Dev and SIT testing.
• Development of Key Performance Indicators (KPI) dashboards that provides internal employee productivity of specific period.
• Designing excel based reports on tableau.
• Working with Level of Details expressions and Regular Expressions which are helpful in providing etl functionality for tableau.
• Migrating reports from standard reporting tools like excel to tableau.
• Migrating all the reports from tableau 9.3 to tableau 10.3 and publishing them on the server.

Environment: Tableau Desktop 10.1.3/9.3, Tableau server 10.1.3/9.3, Microsoft SQL Server 2012, MS Excel, MS Access, Windows 2007 server.

Confidential, IL

Sr. Tableau Developer/Admin

Responsibilities:

• Creating Patient satisfaction dashboards is designed to show the performance of key activities that directly or indirectly impact patient satisfaction, such as length of stay and lab test turnaround.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• TheAverage Length of Stay KPI dashboardsmeasures how long, on averarge, patients stay in your hospital after having a specific procedure, such as an appendectomy.
• ER Wait Timesmeasures the amount of time patients are currently waiting before being seen by an ER physician.
• The ER status dashboard provides an example of the type of real-time metrics ER workers need to track and monitor. By monitoring ER wait time and patient status, hospital staff can better respond to patient needs and deliver a high quality of service that reflects when on the entire organization.
• Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau. 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.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• 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 in Tableau.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Responsible for developing provisioning reports for various groups and upper management.
• Used Trend Lines, Reference Lines and statistical techniques to describe data.
• Creating Patient Insurance claims dashboard, Patient Insurance satisfaction& Patient Claims Ratio and net income Ratios.
• Created report schedules, data connections, projects, groups inTableauserver.
• Used Toad for Data Validation.Defined best practices forTableaureport development
• Set Email subscriptions using SMTP emailserver.
• Create Groups, Projects and add Users inTableauServer.
• Involve in deployment of new dashboards to Test and Production environment.
• Create Schedules for dashboards to refresh automatically.
• Working with User for requirements and part of the team developing the software.
• PublishTableauworkbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
• Designing Proof of Concept and Mock-ups for new projects.
• Navigation and drill down features were implemented inTableaudashboards.
• Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.,
• Created Sets, Groups, and Data Bins as per user requirements.
• Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.
• Created views using various axes like Individual Axes, Dual Axes, and Blended Axes.
• Used Trend Lines, Reference Lines, and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Built Stories in Tableau with various Data points to narrate the data to the end users.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.
• Performed Data Analysis and Data validation by writing complex SQL queries using SQL against the SQLserverdatabase.
• Worked with the DBA and Database developers to convert the functional specification to technical specification.
• Closely monitored the system performance after implementation to address any minor performance issues and evaluate the overall system.
• Wrote complex SQL queries to pull and process data from multiple data sources (SQLServer, flat files, etc.).
• Designed and programmed re-usable SQL code to prepare data for analysis.
• Downloaded data from various sources.

Environment: Tableau Desktop 8 & 9, Tableau server 9.2 / Administration, tabcmd, SQL Server, Teradata Studio Express, Teradata Aster, Oracle, Microsoft Excel 2007, MS Access, Windows 2007 server.

Confidential, CA

Tableau Developer

Responsibilities:

• Created reports using Tableau functionality’s like Queries, Drill Down, Prompts Functions to meet the requirements using SQL Server
• Creating Customer RetentionDashboards for measuring the ability of your organization to retain customers over the long term and to generate recurring revenue from existing customers. Retention rate: The number of customers that make repeat purchases from your organization. Attrition rate: The number of customers that no longer make purchases from your organization.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Creating ThePoint of PurchaseorPoint of Sale KPIdashboards for the retail transactions are completed and compares each "point" over a given period.
• Creating Customer Satisfaction dashboard metricsmeasurethe quality of your customer service and providea reflection of the public's perception of your business.
• TheCost of Goods Sold KPImeasures the actual profit margin on products and services by analyzing how costs such as labour or shipping affect your profit margin.
• TheSales per Square FootKPI measures how much sales revenue you are able to generate for each foot of retail space provided. Use the following formula when calculating the sales per square foot KPI: Total Net Sales ÷ Total Floor Area
• Experience in Marks, Publisher, and Security.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Responsible for developing provisioning reports for various groups and upper management.
• Used Trend Lines, Reference Lines and statistical techniques to describe data.
• Creating Patient Insurance claims dashboard, Patient Insurance satisfaction& Patient Claims Ratio and net income Ratios.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Acloud dashboardhas key advantages overon-premise software such as being easier to deploy, requiring little to no IT support and is accessible on multiple devices.
• TheSales TargetTarget dashbords measures current sales (either dollar value or number of wins) and compares that value to a target orpast performance.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server
• Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL’s, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Experience with creating Worksheets and Dashboard.
• Working with Multiple Data Connections.
• Using Multiple Measures like Individual Axes, Blended Axes, Dual Axes.
• Experience in BI interactive Dashboards and Tableau Publisher.

Environment: Tableau 8 Desktop, Tableau server, SQL Server 2008, R2, Informatics 8, SQL. Web Intelligence, SAP BW, Oracle 11g/10g, SQL Server 2008/2012, Info view, Windows 2008 Server.

Confidential, CA

Tableau Developer

Responsibilities:

• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Creating Sales Growth Dashboardmetrics measure the pace at which your organization's sales revenue is increasing or decreasing.Current sales revenue: The total dollar value of sales during the current time period. Previous period sales revenue: The total dollar value of sales during the period time period.
• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc...
• Creating TheSales Bookingsmetric measures the value of bookings over a given time period, where a "booking" is a won, signed, or committed sale. Booking: A won, signed, or committed sale where the purchase order has been received and approved.
• TheSales Opportunity Dashboardmetricorganizes prospects based on opportunity value and the probability of closing the sale. Each prospect has an estimated purchase value associated with them to help your team prioritize their efforts.
• Stage: Based on the type of contact your sales team has had with the prospect. Stages may include proposal (sales quote sent and received), qualified, or negotiation.
• Weighted value: A multiplier that is applied to the estimated value of a prospect based on the probability of closing the sale.
• Created Sets, Groups and Data Bins as per user requirements.
• TheSales TargetDashboards measures current sales (either dollar value or number of wins) and compares that value to a target orpast performance. Wins: The number of new customers over a certain time period. Revenue: Income received through sales activities.
• Calculating TheAverage Purchase ValueKPI measures the average value of each purchase order your sales team processes. Purchase order: A document used to indicate the type of product ordered, number of units, and agreed upon prices and Purchase value, Units per transaction.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• TheSales by Contact Methodmetric measures which contact methods are the most successful at generating sales, such as email, telephone, or in person.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Used Trend Lines, Reference Lines and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.
• Developed set analysis to provide custom functionality in tableau application.
• Expertise in creating Hierarchies for proving drill down option for the end user.

Environment: Desktop OS: Win2000 Professional, Server OS: Windows 2003/2008; MS SQL Server 8.0/2005,XML, Tableau 8.1/8.0,SAP Business Objects 4.1/4.0, IDT, UDT, WEBI BI: SAP BW Query Designer, Analyzer.

Confidential, Canonsburg, PA

Tableau developer/SQL BI developer

Responsibilities:

• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Involved in design and development of two main technological components, a Database to store data of all transactions related to each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Patient Record Dashboards for patient visiting doctor information and pharmacy bills, medical assistance, insurance track records and all categories included in this dash board.
• Origination Profit Analysis Dashboards: As is the case in any business, hospitals are always looking for ways to reduce costs and increase revenue.
• Patient Claim Payouts by Region this dashboard useful to find patient insurance claims records and payments
• Involved in the publishing of various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.
• Involved in created stored procedures, views, and custom sql queries to import data from sql server to tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Involved in conducting training to a user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop
• Involved a key member in the development of E-R modeling (Logical design) of database incorporating business logic and user requirement
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to the server and exporting the reports in different Formats.
• Good experience in using URL’s, Hyperlinks, Filters for developing Complex dashboards

Confidential

SQL BI Developer

Responsibilities:

• Directly interacting with clients to elicit the requirements and translate them into terms that development team can comprehend.
• Various ETL Transformation tools were used for Control Flow and Data Flow tasks
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent. Performed upgrades from Business Objects 6.x to Business Objects XI R2
• In the process of Upgrading Business Objects XI R1 to Business Objects XI R2.
• Installed and configured Weblogic 8.1 SP2 for Business Objects XI R1.
• Installed and configured Weblogic 8.1 SP5 for Business Objects XI R2.
• Configuration and Deployment of webcompadapter, jsfadmin, admin, desktop, analysishelp, styles, adhoc war files.
• Responsible for Providing sizing and recommendations on scaling the BOXI systems.
• Installation of Business Objects patches as on demand basis.
• Involved in installing DST patches to BO XI R1 environments.
• Used various transforms in SSIS to load data from Flat files, XML and FTP to SQL Databases.
• Migrated old data from MS Access and Excel into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages (.dtsx files) using SSIS to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints.
• Facilitate User Acceptance Testing (UAT) and production rollouts, and the defects detected were tracked and managed using HP Quality Center.
• Perform data modeling, periodic report validation, and data analysis by writing SQL queries using TOAD.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Involved in writing queries for Stored procedures, clustered and non-clustered indexes

Environment: Business Objects XIR1/XI R2 SP2, Crystal Enterprise 10, Crystal Reports XI R1/ XI R2, SQL Server 05/08, MS Office, MS Excel, MS SQL Server 2005 Management Studio, Windows XP Server, MS Excel, MS Access, Text Pad text editor, MS Visio 2005, DTS, SQL Query Analyzer, SQL Developer.