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.