SUMMARY

• Over 8+ years of IT experience in Design, Analysis, Development, Documentation using client/server environment using Business Intelligence and Data Platforms.
• Wide experience in various phases of Software Development Life Cycle(SDLC) including Systems Analysis & Design, Development, integrated testing, implementing, User Training.
• Experience in developing multiple dashboards/reports using various charts like Bar, Stacked Bar, Line, Dual - axes charts, Geo-Maps, Bubble, Histograms and Heat Maps.
• Designed Tableau dashboards using Hierarchies, filters, calculated fields, Sets & Groups.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Solid understand of SQL and have worked with various data source types like Oracle, SQL server, Microsoft Access databases, and Excel Spreadsheet.
• Installation and Configuration of Tableau Server and Tableau Desktop on Windows Server R12 2012.
• Implemented data blending, groups, combine fields, and aggregated fields to compare and analyze data in different perspectives in Tableau.
• Responsiblefordesigning and developing Schemas using Entity Relationships, Data Modeling, Normalization, Creating Tables, Views, Indexes and Sequences.
• Expertise in Report Development - Administration for Tableau.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently with Tableau.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security
• Modeling and problem-solving skills with experience in drawing insights from large data sets.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XML and HTML.
• Ensured maintenance and security control of the Tableau products and solutions.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Good Hands on with SQL, TSQL, Stored Procedures and Functions Worked with data model tools as TOAD and Oracle SQL Developer.
• Extensive experience with technical problem solving, testing, debugging and troubleshooting.
• Exposure to multiple platforms like Unix/Linux, Windows.
• Entry level knowledge on ETL processing using Informatica.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

OS: Windows 95/98/NT/2000/XP, Windows 7/8,UNIX

Reporting tools: Tableau 2018.3/10.2.1/10.0.5/10.0/9.1/8.3/8.2/7.0

Databases: MS SQL Server 2008/2005/2000/7.0 , ORACLE 10g/11g, MS Access, BigData,Kognitio and Jethro

ETL Tools: Informatica 7x

RDBMS: Oracle 8.x/9.x/10g/11g, SQL Server 2003/2005/2008

Languages: VB.Net,ASP.NET, PL/SQL, SQL, HTML, XML, CSS

Tools: Toad

PROFESSIONAL EXPERIENCE

Confidential, Bentonville, AR

Tableau Admin/Developer

Responsibilities:

• Working on Tableau installation and configuration with Single Server System and Multi Node Server System in Windows servers.
• Recently upgraded from 2018.2.3 version to 2019.2.4.
• Configuring Users based on Active Directory and logged in through Run as User account.
• Maintaining SSL Certificates for windows users and Mac Users.
• Working on Tableau User based Licensing and Core based licensing.
• Creating Users, User Groups and Projects through Tableau Server Web and assigned roles and permissions for Tableau Users.
• Secured Tableau server on AWS to protect the Tableau Environment using Amazon VPC, security Groups.
• Maintaining Tableau data source connections and scheduled refreshes and updates.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Created Projects, groups and assigned permissions for each group like HR, Sales and Marketing and Finance.
• Monitored server level performance and resolved the errors on 24/7.
• Published Tableau workbooks (.TWB,.TWBX) from Tableau desktop to Tableau Server.
• Worked with Tableau data Extract (.TDE).
• Handling the service now tickets from the user on an average of 30 tickets per day.

Confidential, Pleasanton, CA

Tableau Admin/Developer

Responsibilities:

• Participated in Tableau installation and configuration with Standalone and Distributed environment.
• Created Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau Users.
• Upgraded Tableau server from 10.3 version to 2018.2.3 version
• Onboarding the new users and modifying the existing users’ permissions and their site roles
• Monitoring the server health on the daily basis and make sure that server health is always up and running, monitoring the disk space and weekly cleanup of unwanted cache.
• Making the best governance policies and setting up weekly meetings with the workbook owners to make sure that publishing of the dashboards and extract refreshes are set according the guidelines which we set.
• Monitored server level performance and resolved the errors on 24/7.
• Tableau license project created within out JIRA environment to track our license and desktop account
• Handling of the service requests and the incident tickets.
• Creating Users, User Groups and Projects through Tableau Server Web and Assigned roles and permissions for Tableau Users
• Creating the SSL certificates and using .crt files for SAML setup as well for SSO (single sign-on)
• Created Tableau Admin reports using the Postgres metadata( Tableau usage and Adoption)
• Development of Key Performance Indicators (KPI) dashboards that provides internal employee productivity of specific period.
• Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
• Optimized underlying SQL queries to create “high performance” reports.
• Extensively used TabJolt for Load and Performance Testing of Tableau reports developed and resolved performance related issues as required.
• Hands-on development assisting users in Re-creating and modifying existing worksheets and data visualization dashboards.
• Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots, Radical chart Geographic maps, Line chart, Pie charts etc.
• Enhancement of existing reports to improve performance by modifying the sql code used in extraction of data.
• Created Financial reports, Demographics. This report explains the Company profit and employee relationships and we calculated using norm for comparison.
• Used Context filters and Created Geographic map reports which explains the company financial keys according to the members.
• Created Sets, Groups, and Data Bins as per user requirements.
• Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.
• Created views using various axes like Individual Axes, Dual Axes.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.

Confidential, NC, Cary

Tableau Developer/Admin

Responsibilities:

• Working on Tableau installation and configuration with Single Server System and Multi Node Server System in Windows servers.
• Recently upgraded from 10.5.4 version to 2018.3.
• Configuring Users based on Active Directory and logged in through Run as User account.
• Maintaining SSL Certificates for windows users and Mac Users.
• Working on Tableau User based Licensing and Core based licensing.
• Creating Users, User Groups and Projects through Tableau Server Web and assigned roles and permissions for Tableau Users.
• Developed batch scripts for Tableau Server backup atomization on weekly basis and save the backups in particular folder.
• Secured Tableau server on AWS to protect the Tableau Environment using Amazon VPC, security Groups.
• Maintaining Tableau data source connections and scheduled refreshes and updates.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Created Projects, groups and assigned permissions for each group like HR, Sales and Marketing and Finance.
• Monitored server level performance and resolved the errors on 24/7.
• Published Tableau workbooks (.TWB,.TWBX) from Tableau desktop to Tableau Server.
• Worked with Tableau data Extract (.TDE).
• Worked with key business stakeholders to understand the Tableau Report requirements and then worked with Designers to create Visual Design of the Reports as well as conducted detailed multiple stakeholder walkthroughs on each Tableau report developed.
• Development of Key Performance Indicators (KPI) dashboards that provides internal employee productivity of specific period.
• Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
• Upgraded Tableau Server from 9.3 to 10.4. Currently planning for minor upgrade from Tableau Server 10.4 to 10.5 version.
• Worked in Tableau environment to create dashboards like Yearly, monthly reports using tableaudesktop & publish them to server.
• Converted Excel Reports to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports.
• Used advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Created affinity analysis dashboard and Radical charts for better understanding data.
• Optimized underlying SQL queries to create “high performance” reports.
• Extensively used TabJolt for Load and Performance Testing of Tableau reports developed and resolved performance related issues as required.
• Hands-on development assisting users in Re-creating and modifying existing worksheets and data visualization dashboards.
• Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots, Radical chart Geographic maps, Line chart, Pie charts etc.
• Enhancement of existing reports to improve performance by modifying the sql code used in extraction of data.
• Created Financial reports, Demographics. This report explains the Company profit and employee relationships and we calculated using norm for comparison.
• Used Context filters and Created Geographic map reports which explains the company financial keys according to the members.
• Created Sets, Groups, and Data Bins as per user requirements.
• Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.
• Created views using various axes like Individual Axes, Dual Axes.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Cleared errors according to business requirements excel sheet and helped to create Documentation for the dashboards, Writing SQL queries for data validation by using join conditions.

Environment: Tableau 10.2.1/10.0.5/10.0/9.3.6/9.3.8 , Oracle EBS, SQL Server 2008, SQL developer, Windows Server R122012, Microsoft Excel, Kognitio, Jethro and Access Database.

Confidential, Virginia

Tableau Admin for Tableau, JIRA and Confluence

Responsibilities:

• Participated in Tableau installation and configuration with Standalone and Distributed environment.
• Created Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau Users.
• Account creation for users and stakeholders in both JIRA and Confluence
• As a Tableau Admin, specializing in server worker nodes installation & configuration. Setting up Tableau primary and worker nodes, Disaster recovery setup, including Backup Primary setup and configuration.
• Setting up active directory on tableau server for the effortless password management for the SAML(single sign-on)
• Tableau account creation and maintenance on various Tableau sites
• Tableau license project created within out JIRA environment to track our license and desktop account
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Hands on experience on TabJolt and Tabmon tools.
• Published Tableau workbooks (.TWB) from Tableau desktop to Tableau Server.
• Worked with Tableau data Extract (.TDE).
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Played critical role in establishing Best practices for tableau Reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI’s and developing POC Dashboards.
• Developed Complex dashboards and used advance chart visualizations in Tableau like Pareto Chart, Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to created summary level and detailed Reports.
• Conducted Load and Performance Testing using TabJolt and resolved performance related issues on affected Tableau Reports.
• Connected Tableau server with SharePoint portal and setup auto refresh.
• Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
• Managed Users on Unix/Linux and Windows systems.
• Develop reports using formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Good knowledge in developing and designing reports through SSRS and Excel.
• Strong experience with MS Excel, PowerPoint, Word and Visio.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided 24/7 production support for Tableau users.

Environment: Tableau 7.0/8.0, SQL Server 2008/2008 R2, T-SQL, SQL Server Management Studio, Microsoft Excel.