We provide IT Staff Augmentation Services!

Tableau Administrator /developer Resume

Omaha, NE

SUMMARY

  • I have over 15 years overall experience in Information Technology with 10 plus years hands - on Tableau Developer and Server Administrator experience.
  • Motivated and results-focused experience in Data Analysis, Design, Coding, Testing, Migration, Production Support and implementation of software applications.
  • Proven record in Installations, Configurations, Upgrades, Patches, Performance Tuning, Monitoring and Cache.
  • Consistent track record of successfully demonstrating solid expertise in Tableau Business Intelligence/ Business Analytics software and technical support in major health and financial institutions.
  • Experience in Tableau, MySQL, Teradata, Oracle, DB2, SQL, MS. Access, MS SQL server.
  • Actively participated in Tableau Administration activities, multidimensional database and writing SQL queries.
  • I also have prior 5 years’ experience in SQL server and Oracle Database Administration running on Windows and Linux respectively.
  • Excellent team player, independent, self-motivated, determined and ability to work on multiple projects at the same time.
  • Strong Expertise and Experience in Troubleshooting Software, Hardware and Network issues with excellent communication, analytical, and problem-solving skills.
  • I have a very good understanding of backup and recovery strategies to ensure database availability and recoverability.
  • I have a good client relationship for understanding their business processes, user tasks & goals; analyzing and defining requirements to ensure efficient and cost-effective technological solutions that meet and exceed client needs.

AREAS OF EXPERTISE

  • Tableau Developer
  • Advance BI visualizations
  • BI Software/ Programming languages
  • Operating Systems MVS, z/OS, Unix
  • Middleware Tibco, MQ series
  • Ad-hoc Business Reporting
  • MS SQL server 2014, SSAS, Oracle, Teradata
  • DB2 Utilities, IBM utilities, Visio
  • Big Data: Hadoop/AWS
  • Basic Shell Scripting
  • Database SOP Documentation Skills
  • Tableau Server
  • Alteryx
  • Data Analysis
  • Data Reporting
  • Database DB2, MySQL, MS. Access
  • Migration and New Projects
  • Tableau 10.5.2/10.4/10.3/10.1/10
  • Microsoft Office (Excel, Access, PowerPoint, and Outlook
  • PL/SQL, XML, COBOL, PL/I, EASYTRIEVE+
  • Microsoft SQL Server Administration
  • Proactive Database Monitoring
  • Oracle 10g/11g/12c Database Administration
  • Storage Capacity Planning
  • Database Monitoring
  • Linux/UNIX Administration
  • Oracle /SQL Server Performance Tuning
  • SQL Scripting
  • Oracle Enterprise Manager (OEM)
  • RMAN utilization (backup, restore, recovery)
  • JIRA/Service Now/SQL Developer/SSMS
  • Database Troubleshooting
  • Storage Capacity Planning

PROFESSIONAL EXPERIENCE

Confidential, OMAHA, NE

TABLEAU ADMINISTRATOR /DEVELOPER

Responsibilities:

  • Experience in Tableau Server Management including clustering, load balancing, user management and Tableau server/desktop licensing
  • Installation, configuration and administration of Tableau server with strong expertise on troubleshooting, tuning & disaster recovery
  • Ability to handle large data volumes and perform analysis using Tableau
  • Knowledge of best practices and experience optimizing Tableau for performance.
  • Involved in Validating and Testing the server content after each major or minor version upgrades.
  • Creating/Managing the Projects, Groups, Users, Schedules, tasks and assigning the right permissions to them.
  • Worked with Tableau Elite support to resolve ongoing issue which we faced with server/desktop product related issues and developed multiple custom admin views by connecting to PostGRES database to improve the Server performance and tuning it for optimization.
  • System Administration including the creation of new site, server maintenance/upgrades/patches and schedule control.
  • Hands on experience developing dashboards and reporting visualization using SQL writing skills and strong understanding of relational and dimensional data models.
  • Expertise in Data Visualization including effective communication, appropriate chart types, and best practices.
  • Advanced knowledge of dashboard performance optimization
  • Experience in creating Tableau calculations, table calculations, LOD calculations, blending, actions, time period functions, parameters based on requirements
  • Experience gathering and refining requirements, interviewing business users to understand and document data requirements including elements, entities and relationships, in addition to visualization and report specifications.
  • Ability to communicate to a variety of audiences in both verbal and written form.
  • Run cleanup and create backups of the database as well as performing server automated monitoring & server job processes
  • Provide Tableau support to users
  • Responsible for Tableau Server Administrative functions, upgrades, installations, configuration, license management, backup of servers and load balancing techniques
  • Configured Tableau Server processes to maximize the server performance
  • Establish and deploy Server processes architecture to support redundancy and scalability
  • Provided operational support for all production related issues, troubleshooting and system maintenance and ensured uptime for servers
  • Provided infrastructure sizing, including hardware and software requirements
  • Monitor server activity/usage statistics to identify possible performance issues/enhancements
  • Performed maintenance activities like Log Cleanup and Archiving Log files in prescribed intervals, used for used during a disaster
  • Analyzed and resolved performance and server-based issues and prepared backups using TABADMIN and TABCMD commands Automated Server backups, Server logs, PDF delivery to business users by using Python script.
  • Configured Viziers to trigger email to Production support whenever there is an extract failure.
  • Involved in Validating and Testing the server content after each major or minor version upgrades.
  • Worked closely with data engineers and administrators to construct OLAP (online Analytical processing) system that will be used to make critical business decisions, Client Services/Finance/Fraud & Risk team to gather requirements for designing the data warehouse model using Tableau version 9.3 platform
  • Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the report’s specifications document and report inventory
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently with Tableau 9.3
  • Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop
  • Experience with multiple Business Intelligence tools and report development working with Hadoop data sets
  • Maintained network computer systems current by upgrading hardware, installing newer applications and updating security and antivirus programs

Confidential

ORACLE DATABASE ADMINISTRATOR

Responsibilities:

  • Supported Oracle Production databases on versions 12c, 11g, and 10g. (RAC, ASM & non ASM) Linux and Windows environments.
  • Installed, patched, upgrades, duplicate, configured, managed, databases software.
  • Monitored, maintained, tuned, administered databases.
  • Configured and monitored database backups and performed restores and recoveries using RMAN.
  • Support System Architects, Business Intelligence Engineers and ETL Engineers.
  • Assisting in ETL processes in Agile development with developers using SSIS packages.
  • Troubleshoot SQL queries, Tuning queries and performance issues.
  • Monitors space usage, performance tuning, I/O and memory management
  • Installed procedures and data in dev, test, and acceptance environments.
  • Migration of data to lower environments using data pump export/import.
  • Created tables, sequences, indexes, triggers, partitions and other database objects.
  • Creating and working on tickets using Jira, Kanban and Confluence.
  • Supporting clients in Operation Management tasks like user management and databases.
  • Performs weekly full and incremental backups using RMAN (Oracle) and Agent (Windows).
  • Performed Oracle databases Upgrades and Migration from Oracle 11203 to 11204.
  • Monitor Database using, AWR, ASH Reports and Explain plan.
  • Applied Oracle Critical Patches to databases.
  • Responsible for database security using features like, TDE, Data masking and Auditing in 11g and 12c.
  • Monitoring Databases performance using SQL Profiler, tuning advisor and Index tuning wizard.
  • Create and Manage users, roles, security at object level.
  • Installed, Configured and maintained Always on High Availability Group in SQL Server.
  • Scheduling SQL Server jobs to monitor disk space, CPU activity and Index fragmentation.
  • Scheduling Backups and Log jobs to disk and URL. AWS/Azure.
  • Provides support for multiple applications using Microsoft SQL and Oracle RDBMS. Platforms
  • Excellent skills in using SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and Database Maintenance.
  • Experience in installation, maintenance of different versions of SQL Servers (2016, 2014, 2012, 2008R2/2008) in both OLTP and OLAP lower regions and Production environments.
  • Implemented High Availability & Disaster Recovery techniques like Always-ON Availability Groups, Clustering (Both Active-Active and Active-Passive), Databases Mirroring, Transactional Replication and Log Shipping.
  • Upgraded SQL Server databases from SQL Server 2012 to SQL Server 2016
  • Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities.

Hire Now