We provide IT Staff Augmentation Services!

Sr Tableau Developer Resume

Denver, CO

SUMMARY

  • 8+ Years of experience in IT industry with more than 7 years of experience in Business Intelligence, Data Warehouse tools with specialization in Tableau and Power BI
  • As Tableau Developer, Responsible for creating wonderful visualizations to help clients to take their decisions.
  • Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
  • Experience in working with Financial, Healthcare and Retail Clients
  • Have been working with various data sources such as Oracle PL/SQL, SQL Server, ODBC and Flat file sources.
  • Extensive experience in business and data analysis along with 5 years of data visualization using Tableau Desktop.
  • Worked Extensively on Power BI reports for about 3 years and developed many Ad hoc and drill reports.
  • Involved in claim adjudication process of FACETS application.
  • Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
  • Worked on Tableau server regarding Installation, Monitoring, and Integration duties.
  • Worked With Power BI and developed Bar, Gantt and Pie charts whenever got the requirement based for MTD and YTD reports.
  • Strong experience using Tableau Server, Tableau Desktop, tableau online, Prep and Tableau public.
  • Experienced on working with EDI 837 and 835.
  • Worked on Star flake and snowflake schema Methodologies
  • Worked in both Agile and Waterfall Methodology
  • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
  • Extensive Knowledge of Tableau Server Concepts like Tabcmd, Tabadmin, creating users, sites, and projects.
  • Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Worked on generating various dashboards in Power BI using various sources such as Teradata
  • Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, calculations and relationships.
  • Used Teradata utilities (SQL, B - TEQ, Fast Load, Multi Load, Fast Export, T pump, Visual Explain, Query man)
  • Having knowledge on gather business requirements and translate them into reporting needs.
  • Managed and created and altered Databases, Tables, Views, Indexes, Constraints and stored procedures using SQL Server and Oracle with business rules
  • Recommending dashboards as per Tableau visualization features and delivering reports to Business team on timely manner.
  • Used Alteryx and SSIS for ETL work such data blending and analytics.
  • Designed and developed matrix, tabular, parametric and sub Reports in the SQL Server Reporting Services (SSRS) 2012.
  • Successfully upgraded Tableau platforms in clustered environment and performed content
  • Established best practices for Enterprise Tableau Environment and application intake and development processes.
  • Worked extensively on DW concepts like Star flake and Snowflake Schema.
  • Worked with databases like AWS, SQL Server, Jira data and Oracle.
  • Knowledge of Data warehouse concepts and methodologies.
  • Expertise in identification of business and data requirements and converting them into conceptual and logical data models.
  • Performed Extract, Transform and Load operations from the databases using SSIS. Also, created the merge, lookup and send mail tasks.
  • Detail-oriented problem solver, quick learner, and flexible team player

TECHNICAL SKILLS

Reporting Tools: Tableau 2019/2020/10 , SSRS, Crystal Reports, Business Objects, PowerBI

Databases: SQL Server, DB2, Oracle, Teradata

ETL Tools: SSIS, SSAS, Informatica 7.x/8.x, App Maker

Internet Tools: HTML, DHTML, XML, VB Script, Java Script, JSP, ASP

Languages: SQL, PL/SQL, C/C++, C#, Java, Shell Scripting

Operating Systems: MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP/Vista, AIX 5.1\5.3, Sun Solaris 2.7\2.8 Linux

Testing Tools: Quick Test Professional QTP, Win runner, Load Runner

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sr Tableau Developer

Responsibilities:

  • Assisted in complete Life Cycle including Design, Development and Testing.
  • Deployed the generated reports onto the Tableau desktop and server and administered permissions like Read, Edit, Interactor, and publisher privileges to the team and create access to databases according to their Hierarchy.
  • Effectively used data blending, quick filters, actions, hierarchies feature in Tableau.
  • Executed and tested required queries and reports before publishing.
  • Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
  • Developed Live and Extract data to create Tableau dashboards using Bar, Line and Whisker plots for Presenting Statistical Data and Heat Maps and Geographical reports. Published the same to PowerBI online and Confidential ’s sites.
  • Explored variety of data and across multiple visualizations using Power BI. Strategic expertise in design of experiments, data collection, analysis and visualization.
  • Worked on EDI transaction data 837 and 835 which were claims data and payee transactions from Provider and Medicare/Medicaid data.
  • Developed both Tableau and Power BI dashboards from multiple data sources for different departments according to their environment.
  • Worked on the UI development for the Confidential ’s dashboard site and assisted on the back end processing of the changes on the site.
  • Created different KPI determining target and baseline of the Colorado departments achievements and publish To the State departments Governors Sites.
  • Developed and Maintained Confidential ’s OIT dashboards and Publish it to the Confidential ’s Site which involved 19 agencies Workbooks such as Transport, Education and Treasury financials.
  • Managed and created and altered Databases, Tables, Views, Indexes, Constraints using PL/SQL and SQL with business rules.
  • Worked with Alteryx whenever we needed ETL, data transformation while using multiple data sources like AWS and SQL Server.
  • Worked in Medicare and Medicaid and also food Stamps data reports.
  • Developed SSIS packages to conduct simple and complex transformations, data blending and executed these packages using the scheduled jobs using snowflake database
  • Extensively used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks
  • Worked on ETL concepts like Snowflake to check the facts and dimension relations and change it according to the req to extract data for reporting purposes.
  • Worked on AWS database and extracted desired data for data joins to develop Tableau reports.
  • Involved in both Business and Technical Teams and assisted with the requirement gathering BSD doc to Prepare FSD Docs for the Project Workbooks and Dashboard development.
  • Developed SSRS reports whenever we parameterized reports according to the business requirement.
  • Migrated some of the SSRS reports to Tableau when the reports lifecycle was completed, and agency switched to Tableau reports.
  • Worked on SSAS for the development of multidimensional cubes for development of facts and dimensions according to the requirement.
  • Worked on the Server upgrade of Tableau 2019 to tableau 2020 and 2020.2 and assisted all phases to avoids loss of Backups.
  • Developed Version Confidential ’s dashboard and assisted on other Projects dashboards to help complete Version FY2020-21 year state website dashboards and also Advised changes.
  • Used the SQL server through Live and SSIS by Extract data to create PowerBI Dashboards using Bar, Line and Whisker plots for presenting Statistical Data and Heat Maps and Geographical reports using Zip codes for publishing Covid Patient details of Colorado State Health department.
  • Worked on APPmaker Data Tool, Snowflake and GCP data through which state departments use data to connect to Tableau for their assistance to public.

Environment: Tableau Desktop 2019/20, Denodo, SQL server, Teradata 14 Oracle 11g, GCP, JIRA Data, Power BI, Microsoft office 2014, SQL, PL/SQL, T-SQL.

Confidential, Denver CO

Tableau Viz Consultant

Responsibilities:

  • Created tableau dashboards of data throughout complete Life Cycle including Design, Development and Testing.
  • Worked on Data Mining of Jira and chalk (Confluence) Data, Created Tickets according to the Requirement in Sprint.
  • Connected Jira and Chalk data to Tableau desktop and Made status reports Gantt Charts. Line, Bar charts and Ad Hoc reports of Timed Statuses of tickets. And given the performance Statistics.
  • Published the developed Tableau Reports to and sent the links to prescribed users to access it through T ableau Online and online sites.
  • Worked on Tabpy to add additional calculations in the visualization when needed.
  • Worked with SSIS to join confluence and Jira data together through web authoring and connected data to Transform data needed for Tableau for easier application to build dashboards.
  • Wrote Complex JQL and extracted the data from Jira for exporting Files for Data Mining for the outages happened and Listed based on the hierarchy of severity such as High, critical, Urgent and Medium to assist in checking priority of getting resolved.
  • Migrated multiple dashboards from Tableau to PowerBI also designed multiple dashboards.

Environment: Tableau Desktop 2019, SQL server, JQL, JIRA Data, PowerBI, Microsoft office 2014, SQL, T-SQL.

Confidential, Golden, CO

Tableau Developer

Responsibilities:

  • Assisted in complete Life Cycle including Design, Development and Testing.
  • Deployed the generated reports onto the Tableau Desktop and administered permissions like Read, Edit, Interactor, and publisher privileges to the team according to their Hierarchy.
  • Experienced as Tableau admin in monitoring, scheduling refreshes and upgrading server.
  • Experienced in medical data such as Facets and EDI claims data such as EDI 837 and 835..
  • The databases were on snowflake methodology, so checked on the relations and suggested changes needed for the requirement.
  • Expertise in Tableau platform sizing, troubleshooting, tuning & disaster recovery.
  • Worked Tableau Server Update cycle and set up Backups too.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Managed and created and altered Databases, Tables, Views, Indexes, Constraints with business rules using T-SQL and oracle
  • Connected Cloud SQL and SQL Server to tableau to Build reports based on WTD, MTD, YTD based on the dept requirements.
  • Worked on the migration of Tableau dashboards to Power BI
  • Used Python for integration and data accuracy in the tableau dashboards using Tabpy.
  • Involved in designing ETL as a part of Data warehousing and loaded data into Fact tables using SSIS Data Workflow.
  • Worked on HIPPA data of Medical assistance and Food Assistance and Created Tableau Reports from the data to predict statistics of the day to year and month to year Budgets of the department.
  • Worked with Alteryx whenever we needed data blending and data transformation while using multiple data sources.
  • Extensively used SSIS for giving Data analysis and BI software with SQL Server also built different SSRS reports
  • Formulated procedures for installation and configuration of Tableau.
  • Worked on SSAS for the development of multidimensional cubes for development of facts and dimensions according to the requirement.
  • Connected and retrieved data from numerous databases like SQL server, Oracle. denodo.
  • Develop sub reports, Parameterized reports and bar charts using SQL Server Reporting Services ( SSRS ).
  • Developing Agile methodology and written test cases from user stories
  • Statistical Data and Heat Maps and Geographical reports using Zip codes.
  • Developed SSIS packages using Control and Data Flow to process all excel files within folder.
  • Scheduled, enabled/disabled jobs using SQL server job agent for daily, weekly and monthly loads.
  • Performed Job Scheduling Using SQL SERVER Agent
  • Designed and Developed KPIs, Aggregations and Cube Partitions.
  • Developed complex Stored Procedures, Triggers, User Defined Functions based on the requirement

Environment: Tableau Desktop 10.1/10.3, SQL Developer, SQL server, Oracle 11g, java 1.5 platform, Visual Studio Teradata, Microsoft office 2007, Power BI, SQL, PL/SQL, T-SQL.

Confidential, Richmond, VA

BI Developer

Responsibilities:

  • Assisted in complete Life Cycle (SDLC) including Design, Development and Testing.
  • Created Sub Reports, Geo Mapping and Drill down Reports based on the requirements provided Using PowerBI Desktop and Schedule the automation of refreshes of dataflow.
  • Deployed the generated reports onto the report server.
  • Worked in Agile methodology and wrote many user stories and moved them from Design, Development and performed UAT.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Train and manage developers, advising other groups in organization on SSIS development, Data warehouse development, and ETL development best practices.
  • Participated in performance tracking activity by evaluating server tasks.
  • Using SSAS Maintained and modified various Dimension and Facts relations.
  • Migrated the SSRS report data to Power BI Environment.
  • Deep experience with the design and development of Tableau visualization solutions.
  • Involved in upgrading PowerBI platforms in clustered environment and performing content upgrades.
  • Performed all work within the Teradata, RDBMS environment
  • Worked with automation of SSIS Packages on SQL Server 2012 and SSIS packages on SQL Server 2008 for the automation of day to day Maintenance Jobs.
  • Involved in license management SLA’s with Tableau support.
  • Extensively used Alteryx for giving Data analysis and BI software with SQL Server .
  • Defined and created procedures to install Power BI desktop .
  • Extensively used Tab Admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
  • Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multi Load, Fast Export, T pump, Visual Explain, Query man) and Teradata parallel support.
  • Worked with Tableau and Alteryx Schedulers and workflows to provide end-to-end automation.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Created Parameterized reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRS using SQL Server.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Developed Tableau Data Extracts for dashboards by creating ETL workflows in from multiple data sources and customized data
  • Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Preparing Dashboards using calculations, parameters in Tableau.
  • Designed and Developed matrix, tabular, parametric and Sub Reports in the SQL Server Reporting Services 2012.
  • Worked with SSIS packages on SQL Server 2012 for the automation of day to day Maintenance Jobs.
  • Proof-read all documents and maintain accuracy of information and preparing SOP.
  • Responsible for Developing a Dashboard and preparing ad-Hoc Reporting.
  • Managed and created and altered Databases, Tables, Views, Indexes, Constraints with business rules using T-SQL
  • Developed complex Stored Procedures, Triggers, User Defined Functions based on the requirement

Environment: Tableau Desktop 9.0/10, Oracle SQL Developer, SQL server, HPQC, Oracle 11g, java 1.5 platform, Teradata, Microsoft office 2007, Business objects, SQL, PL/SQL, T-SQL.

Confidential, Golden Valley, MN

Tableau Developer

Responsibilities:

  • Actively involved in gathering requirements from end users, involved in modifying various technical &, functional specifications.
  • Analyzed various reports, dashboards, scorecards in MicroStrategy and created the same using Tableau desktop server.
  • 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 data sources together on one dashboard to filter data in multiple views.
  • Developed Sales Analysis Dashboards to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Involved in new KPI generation for Scorecards.
  • Data Manipulation using Oracle, SQL and automated creation of Tableau Data Extract by creating ETL workflow using Alteryx.
  • Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
  • Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
  • Data collection and leveraging on data manipulation teams for required data.
  • Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
  • Effectively used data blending, quick filters, actions, hierarchies feature in Tableau.
  • Executed and tested required queries and reports before publishing.
  • Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
  • Scheduled frequency and time to refresh data for the data sources are publishes or extracted to server.
  • Design and development of various reports and dashboards that can be easily accessible through Tableau App in IPad, IPhones, and other smart mobile phones.

Environment: Tableau 8, Desktop, Alteryx, Tableau server, Oracle 11i, PL/SQL, SQL*Plus, TOAD, Windows 2003/ XP, UNIX.

Confidential, Waukegan, IL

Tableau Developer

Responsibilities:

  • Deployed the generated reports onto the Tableau Desktop and server and administered permissions like Read, Edit, Interactor, and publisher privileges to the team according to their Hierarchy.
  • Designed automated scripts in PL/ SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
  • Exposed to data conversion from different data sources to SQL Server 2012 using SSIS.
  • Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2012.
  • Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS),
  • Developed Trend Analysis reports for the Sales Delivery group based on the sales of their pharmaceutical products.
  • Had to integrate the Medicare (Part A, Part B, Part C, and Part D) data all in one single system for a smooth flow through the claims processing system Facets 4.71.
  • Interacted professionally with diverse group of professionals in the organization including managers and executives.
  • Process claims for Medicaid
  • Experienced in standardizing Tableau for shared service deployment.
  • Developed Standard Operating Procedures ( SOP ) for Monitoring.
  • Extensively used data blending, embed functionalities in Tableau.
  • Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
  • Building, publishing customized interactive reports and dashboards, report scheduling using
  • Tableau server.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • 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 KPIs.
  • 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 and effectively used data blending feature in tableau.
  • Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Environment: Tableau Server 7.0, Oracle SQL Developer, SQL Assistant, Oracle 11g, java 1.5 platform, Teradata, Microsoft office 2007, Business objects, SQL, PL/SQL, T-SQL.

Confidential

SQL Developer

Responsibilities:

  • Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes)
  • Analyzed the requirements and selected the appropriate fact tables/created fact tables
  • Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
  • Configured SSRS 2005 for directly deploying the report in SharePoint 2007.
  • Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
  • Actively involved in Normalization & De-normalization of database
  • Materialized views, dimensions and stored outlines for optimal performance
  • Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
  • Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence

Environment: SQL Server 2005 Enterprise Edition, Enterprise manager, Crystal Reports, Erwin MS, PowerPoint, MS Project.

Hire Now