We provide IT Staff Augmentation Services!

Tableau Developer\tableau Admin Resume

3.00/5 (Submit Your Rating)

Richardson, TX

PROFESSIONAL SUMMARY

  • 7+(Seven) of experience in design, development, implementation and administration of various Business Intelligence tools and expertise in implementing various functionalities of Data Warehouse
  • Experience wif Informatica Advanced Techniques - Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput
  • Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading
  • Experience in SQL Server development, Analysis, Design, Development and Support of MS SQL Server 2012, 2008 and 2005
  • Worked on latest in-memory Analysis, data analysis, data visualization and data discovery tools such as Tableau BI 7x/8x/9x
  • Extensive experience using Tableau Server, Tableau Desktop and Tableau Public
  • Good experience in drill down approach, Filtering, Parameters, Actions and Dashboard development using Tableau Desktop
  • Technically hands-on commercially experience mainly wif creating the dashboards and reports using Tableau Desktop tool and building various dashboard development activities such as Dashboard layout design and development, Tableau Extracts, Tableau Actions, Tableau Dashboards color coding and formatting, Tableau designs, proto types and Tableau mock up reports, Wireframes, Frame works, Design documents (HLD,LLD),Data mapping documents and reporting
  • Expertise in SQL Query Performance Analysis skills and Ability to Redesign for Optimal Efficiency
  • Using the Tableau Desktop for the Data Analysis, Data Visualizations, and Data Discovery and for the data explorations
  • Using the Tableau server Product for publishing the dashboards to server, user management, user security and administration, Content Restriction as a Tableau Content Administrator
  • Expertise in Tableau Data Extracts, Data Blending, Dashboard actions, Row Level Security etc
  • Proficient in Installing, Configuring and Administration of Tableau Server
  • Expertise in designing and development of various dashboards, reports utilizing various 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 business/client requirement
  • Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating wif other platforms.

TECHNICAL SKILLS

Databases: SQL Server 2012,SQL Server 2008/2008 R2, SQL Server 2005, SQL Server 2000/7, Access, Oracle 8i/9i/10g, MYSQL, Data warehouse.

ETL Tools: Informatica Power Center 9.1/8.6/8.5

Reporting Tools: Tableau 9.X/8.X/7.X/6.X

Languages: PL/SQL, T-SQL,SQL, Java, C, Python

Web Technologies: VBScript, HTML 3.2/4.0, IIS 4.0/5.0

Operating Systems: UNIX, Linux, Microsoft 2003/2000/ NT/98/95

Other Tools: SQL*Loader, Erwin, MS Visio, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Tableau Developer\Tableau Admin

Responsibilities:

  • Involved in Installation and configuration of Tableau Software.
  • Implemented permission rules to control access to specific content on a site
  • Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop
  • Used different Mark properties in views to provide better insights into large data sets
  • Created complex views using Table Functions
  • Imposed security Confidential Dashboard level as well as implemented row level security in views
  • Used Data Blending, groups, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives
  • Importing data from multiple data sources (File based/Server based) to tableau desktop and blending them together to produce meaningful records/Views.
  • Migrated Workbooks and Dashboards from Tableau 8.0 to Tableau 9.2
  • Provided assistance for troubleshooting and resolution of problems relating to Hadoop jobs and custom applications
  • Supported technical team members for creation and implementation of configuration management tools
  • Participated in installation, updating and maintenance of Hadoop software applications
  • Created parameters and quick filters. Created Sets to display top products based on their sale
  • Created Dashboards wif different Action filters, interactive views, trends and drill downs
  • Used Tab cmd utility tool and used Tab admin utility tool and also played the role of Tableau administrator.

Environment: Tableau 9.2, Tableau 9.2 Desktop, Tableau 9.2, Server PL/SQL, SQL 2008R2, DB2, Microsoft Office 2010

Confidential, San Francisco, CA

Tableau Reports Developer\Tableau Admin

Responsibilities:

  • Involved in understanding the BI architecture to design dashboards using Tableau Desktop in Tableau 8.2
  • Involved in Installation and upgrade of Tableau server and server performance tuning for optimization
  • Designed and customized data models for Data warehouse supporting data from multiple sources on real time
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse
  • Created mapping documents to outline data flow from sources to targets
  • Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts
  • Tuned the Informatica mappings for optimal load performance
  • Used data visualization for better understanding, insight and better business decisions, used different Filter techniques like Quick filters and Cascading Filters to create interactive reports and dashboards
  • Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
  • Acted as a Tableau BI end to end life cycle implementer involving in Data Analysis (Tableau Analyst), Dashboards Administration (Tableau Admin)
  • Worked on adding different Actions in Tableau and Parameters to dynamically change the view of report/Dashboard
  • Extensively worked on cross tab formatting, labels, annotations and hierarchies to enhance the visualization of the report
  • Used Pages shelf to create animated views for the end users
  • Worked on Data Blending of two different Data sources in Tableau
  • Created dual-axis bar chart wif multiple measures
  • Hands-on experience in publishing the dashboard, scheduling and projects on Tableau server
  • Created Database Objects such as indexes, sequences, synonyms, views, and materialized views
  • Developed PL/SQL packages, stored procedures, functions and triggers to business requirements

Environment: Informatica Power Center 9.1, Workflow Manager, Workflow Monitor, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Tableau 8.2,SQL Plus, Microsoft Word, Visio, Text pad and Windows 7

Confidential, Paramus, NJ

Tableau Developer\Analyst

Responsibilities:

  • Worked extensively in creating dashboards using Tableau dat includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7, 6 and 5.1. Also involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features
  • Generated reports using SQL queries in Tableau 5.1/6.0/7.0 and published them to users in online thru Tableau server
  • Involved in generating Daily/Weekly Sales & Finance trending reports using Tableau by identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview current Trends
  • Worked on Motion chart, Bubble chart, Drill down analysis using tableau desktop
  • Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
  • Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently
  • Assisted users to publish and collaborate reports via a web browser embed Tableau views in other web applications like SharePoint
  • Worked on Business Objects Universe development wif Universe Designer tool and Document development primarily wif Web Intelligence, Dashboards for executive management decision-making tools
  • Used Flash Variables, Extremely Extensive Dynamic Visualizations, Chart and Map Drill Downs
  • Used Open Docs to allow users to move from the Dashboard to its related detailed Webi report and also from Webi reports to another reports using hyperlinks achieved through using OPEN Docs, used User row level security for data in the Dashboard

Environment: Tableau 7.0, 6.0, 5.1, Oracle 10g, Oracle SQL Server R2, MS Office Suite.

Confidential, Philadelphia, PA

SQL Developer\Tableau Reports Developer

Responsibilities:

  • Generated reports using SQL queries in Tableau 5.1/6.0/7.0 and published them to users in online thru Tableau server
  • Involved in generating Daily/Weekly Sales & Finance trending reports using Tableau by identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview current Trends
  • Developed PL/SQL packages, stored procedures, functions and triggers to business requirements
  • Involved in Installation and upgrade of Tableau server and server performance tuning for optimization
  • Wrote stored Procedures/Functions/Packages in various schemas as per business requirements and was involved wif the tuning, Performance, Optimization of queries and standardization of the code.
  • Monitoring existing SQL code and performance tuning if necessary and reducing the execution times through code optimization.
  • Created PL/SQL stored procedures to generate text files for month end batch processing.
  • Responsible for creating reports dashboards using Tableau 8.0.
  • Developed reports and dashboards using data from multiple source files using Data Blending.
  • Worked on building interactive dashboards by using Filters in Tableau.
  • Created Hierarchies to view the report in drill down approach.
  • Worked on grouping the data using Sets and Bins in Tableau.
  • Scheduled data refresh on Tableau server weekly and monthly to ensure dat the dashboards were displaying the most up to date information
  • Prepared the detailed design documentation for business requirements
  • Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database
  • Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts
  • Created Quick filters and Actions for interaction between Dashboards
  • Used Navigations on dashboards using maps
  • Formatted the Reports as per the Client requirement
  • Implemented Binning & Blending concepts in my Tableau Reports
  • Worked on Dual Axis concept while working wif reports

Environment: Tableau 8.0, Oracle 10g, Oracle SQL Server R2, MS Office Suite.

Confidential

SQL Server Developer

Responsibilities:

  • Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality
  • Actively participated in gathering of User Requirement and System Specification
  • Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency. Used MS access in test environment
  • Carried out a Developer’s role on MS SQL Server, MS Access Databases (Stored Procedures and Views)
  • Involved in developing the SQL code for the application
  • Involved in designing and implementing the Stored Procedures and Triggers for automating tasks
  • Created and automated regular Jobs such as Daily/Weekly Report Generations
  • Managed and Monitored System Utilization. Managed Backup and Disaster Recovery of the systems. Managed the security of the servers as a part of administration duties
  • Managed and resolved design issues during development
  • Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
  • Enrolling users and maintaining system security
  • Created database documentation for table and column dictionaries and other reference material
  • Implemented indexes on tables and views for optimum performance tuning
  • Designed the ETL process using different data sources include Flat files, Access, Excel, SQL Server
  • Responsible for identifying sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions)
  • Optimized the existing queries to improve performance wif the use of Profiler and Execution Plans

Environment: T-SQL, SQL Server, MS ACCESS, SSMS, Oracle

We'd love your feedback!