Tableau Developer/Admin Resume Example Sheridan Healthcare

TABLEAU DEVELOPER/ADMIN

Professional Summary

Highly-skilled software development professional with over 6 years of experience in Tableau. Advanced knowledge of data discovery, data visualization, data analysis, and report development as a MS SQL Server Developer/ ETL Developer in analysis, design, implementation & administration of Business intelligence solutions (SSIS/SSRS/SSAS) with Microsoft SQL server 2012/2008-R2/2008/2005 in development, testing & production environment. Expert web developer specializing in front end development and experienced manager versed in all stages of the development cycle for dynamic web projects. Hands on experience in migrating the data warehouse from Oracle to Teradata. Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop report Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment. Established Best Practices for Enterprise Tableau Environment and application intake and development processes. Extensive experience in Tableau Administration Tool for Configuration. Extensively used Erwin for Logical Data Modeling, Physical Data Modeling, Logical-to-Physical Transformation, Forward engineering, Reverse engineering, and Model-to-model comparison. Strong knowledge of Data Warehousing methodologies and concepts.

Technical Skills & Technology

Tableau Desktop, Tableau Reader, Tableau Public, Tableau Server 9/8/7/6, Tabcmd, MS SQL Server 2012/2008R2/2008/2005, MS SQL Server Integration Service (SSIS), MS SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), BCP, SQL Profiler, Enterprise manager, Management studio, Microsoft Access, ERWIN 4.0/4.1/4.2/7.2, Microsoft Visio 10.0/11.0, T-SQL, ASP.NET, C#, VB.Net, HTML, XML, XSL, Oracle 11g/10g

Crystal Reports 8.5/9/10/11,TFS, Visual source safe 2005, MS office 2013/2010/2007/2003, Windows 2008/2003 Advanced Server/Professional, Windows NT 4.0 Server/Workstation, UNIX, Perl, VBScript, JavaScript, Dreamweaver CS4, Web Updater II,SPSS, SharePoint 2013. MS SQL Server 2005/2008, SQL Server Reporting Services, T-SQL, Crystal Reports 10,Visual Studio 2005/2008,Erwin, MS Office 2003/2007, SQL Profiler, Windows server 2003.

Work History

Tableau Developer/Admin, 04/2015
Sheridan HealthCare – Sunrise, FL

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions. Implemented various data connections from data source to Tableau Server for report and dashboard development.
Converted charts into Crosstabs for further underlying data analysis in MS Excel.
Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
Combined visualizations into Interactive Tableau Dashboards and published them to the web portal (SharePoint).
Assigned Permissions to the different Lines of Businesses and Users.
Was also responsible for the performance of the tableau Dashboards on the web portal.

Tableau Developer/Admin, 01/2013 to 03/2015
Horizon Blue Cross Blue Shield – Newark, NJ

Created complex dashboards in Tableau using parameters, sets, groups, and calculations. Also built automated reports, report templates and delivered BI solutions.
Evaluated data models to design Tableau solutions.
Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
Involved in creating dashboards by extracting data from different sources.
Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.
Created calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
Implemented proof of concepts on Hadoop stack and different big data analytic tools, migration from different databases (i.e Teradata, Oracle, MySQL) to Hadoop.
Performed Tableau type conversion functions when connected to relational data sources.
Maintained and installed Tableau Server in all environments.
Created incremental refreshes for data sources on Tableau server.
Monitored VizQL server, Application Server and data server activity to track performance and system stability.
Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
Administered user, user groups, and scheduled instances for reports in Tableau Generated insights out of voluminous and complex datasets and built story lines.
Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository Configured Cache settings which improved the performance of the reports and Dashboards.
Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
Created bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Tableau Developer/Admin/SQL Developer, 01/2011 to 12/2012
AIG – BerkeleyHeights, NJ

Worked on strategic reporting development, creating interactive dashboard and visualization of data solutions to support various business operations utilizing Tableau Software and SQL.
Worked in coordination with clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
Created Users, Groups, and Projects as well as managed user schedules in Tableau environment.
Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
Created different views using Tableau Desktop that were published the business stake holders for analysis and customization using filters and actions.
Created Heat Map showing employment vs unemployment by color that were broken into regions allowing business user to understand where we have most unemployment.
Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
Created Bullet graphs to determine average wages and workers compensation by using measures and dimensions data from Oracle SQL Server and MS Excel.
Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
Created trace in SQL Profiler and used Database Engine Tuning Advisor (DTA) for Performance tuning on stored procedures and Scripts.
Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.
Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
Created Bar Charts complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
Built the database system in the Access software and data management systems, quality control system, and conducted programming and data quality checks and validation.
Developed and documented programs to create analysis data sets, summarizing key trial data and SPSS for statistical analysis, documentation, and reporting.
Managed, cleaned and constructed analytical files.
Developed, modified and validated SPSS programs to produce customized weekly and monthly, quarterly, and yearly statistical analysis reports on production operations for risk management and quality improvements by the plant management team.

Tableau Developer/Analytics Reporting Project, 08/2016 to Current
Bank of America – Charlotte, NC

Generated graphical representations of financial activities- time series analysis, visual analysis of content and performed some outlier analysis dashboards with tableau.
Provided the Financial crime Investigators with a dashboard that searched across multiple transactional data sources to see information relevant to our customers, their accounts and wires in different locations.
Working on some Anti Money Laundering and OFAC related dashboards for our other lines of businesses.
Introduced self-service as a concept – With weekly trainings and WebEx sessions our business users are now able to generate quick and advanced visualizations to explore data and detect trends and patterns.
With tableau we now have a visual discovery of Customers, accounts and wires and the future ability to search across other transactional data sources.
Tableau training partner, I have prepared several documentations for all the dashboards and trained our users on how to utilize these documents.
Tableau site Admin- Publishing and removing and granting permissions to the published dashboards.

MS SQL Developer/SSRS Developer/Tableau Developer, 12/2009 to 12/2010
Health Talk Inc – Burke, VA

Built data warehouse to analyze transactions across all the departments and generating Reports using SSRS.

Involved in all the phases of SDLC.
Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
Used Stored Procedures for updating Servers.
Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
Wrote Complex Stored Procedures, Triggers, Views and Queries.
Created indexes, Constraints and rules on database objects.
Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS.
Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
Generated reports using Cross-Tab, Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
Identified the database tables for defining the queries and defined datasets for report generation.
Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
Generated daily, weekly and monthly reports for the managers.
Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
Tested the reports and fixed bugs in the stored procedures.
Created Advance connections, join new tables, create, manage, extract and monitor queries.
Created extract files for improving the performance and set functionality.
Used different mark types and mark properties in views to provide better insight into large data sets.
Created various types of charts to provide better visualizations.
Created complex data views manually using multiple measures, and also used sort, filter, and group.

Education

Bachelors of Science (IT): Virginia Wesleyan College - VA

Resume Overview

Companies Worked For:

Sheridan HealthCare
Horizon Blue Cross Blue Shield
AIG
Bank of America
Health Talk Inc

School Attended

Virginia Wesleyan College

Job Titles Held:

Tableau Developer/Admin
Tableau Developer/Admin/SQL Developer
Tableau Developer/Analytics Reporting Project
MS SQL Developer/SSRS Developer/Tableau Developer

Degrees

Bachelors of Science (IT) :

Tableau Developer/Admin Resume Example

Resume Score: 70%

DISCLAIMER

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes