Business Intelligence Data Visualization

Sr. Tableau Admin/Developer

Professional Summary:

Senior Tableau Admin/Developer with 14 years of experience in programming, data analysis, design, testing, integration, and deployment of enterprise-level business applications. Proficient in data warehousing, business intelligence, and data visualization using Tableau and Cognos. Skilled in Tableau Server administration, including installation, upgrades, and maintenance. Expertise in the full life cycle development of reporting projects, from requirements gathering to deployment. Proven ability to meet deadlines and handle multiple tasks with flexibility.

Work Experience:

IRS, Maryland Oct’2023-Sep’2024

Sr. Tableau Admin\Developer

Developed interactive dashboards and reports, delivering actionable insights for stakeholders to drive informed decision-making.

Connected to diverse data sources including SQL, Excel, Databricks, Redshift, and Oracle to ensure seamless data integration and analysis.

Adhered to Tableau's best practices while developing data solutions for the IRS, ensuring compliance and optimal performance.

Handled all server and desktop-related issues.

Troubleshot performance, scheduling, and server-related issues.

Published Tableau flows, data sources, and workbooks to Tableau Server, ensuring seamless data accessibility and collaboration.

Installed and configured Tableau server in a multi-node environment for the IRS.

Monitored Tableau server health and ensured optimal performance.

Managed content and users on Tableau server.

Collaborated with Tableau vendor to resolve product-related issues.

Utilized Tableau Prep to clean, shape, and combine data from multiple sources.

Environment: Tableau Server 2023.1, Microsoft 365, Wireshark, Fiddler, SecureFX, Tableau Desktop, Tableau Prep Builder, OneDrive and SharePoint online, SharePoint lists (JDBC), Databricks, Amazon Redshift, Excel, Oracle, SQL Server.

Halvik, Remote Aug’2022-Sep’2023

Sr. Tableau Admin\Developer

Developed and modified interactive dashboards and guided navigation links.

Designed and implemented server architecture to address performance, scheduling, and server-related issues.

Created and monitored AutoSys jobs for refreshing Tableau data extracts and resolved production issues.

Monitored Tableau server health and managed content and users.

Onboarded various teams to Tableau server and handled multiple server environments.

Managed server and desktop-related issues and migrated reports across environments.

Provided support for app teams with Tableau-related issues and worked directly with Tableau vendors for product issues.

Collaborated with business power users to create reports/dashboards using Tableau Desktop and followed best practices recommended by Tableau.

Developed SQL queries and created Tableau dashboards and stories.

Utilized Tableau Prep Builder to generate Excel and CSV files and created data flows.

Published Tableau flows, data sources, and workbooks to Tableau server.

Environment: Tableau Desktop & Server 2023.x, 2022.x, MS Office, Jira, Oracle, SQL Server, Tableau Prep Builder, DBeaver, Amazon Redshift, Excel, Confluence.

RELX, Remote Aug’2021-July’2022

Sr. Tableau Admin\Developer

Converted Looker reports, developed on Redshift database, into Tableau visualizations.

Developed SQL queries and created Tableau dashboards and stories.

Participated in weekly meetings, reviews, and user group meetings; communicated with stakeholders and business groups.

Published dashboards to Tableau server and scheduled Tableau dashboards according to user requirements.

Defined best practices for Tableau dashboard development; assisted users in creating and modifying worksheets and data visualization dashboards.

Demonstrated expertise in data building techniques such as Groups, Hierarchies, and Sets.

Designed server architecture and provided solutions to troubleshoot performance, scheduling, and server-related issues.

Created and monitored AutoSys jobs to refresh Tableau data extracts, managed production issues.

Environment: Tableau Desktop & Server 2020.x, MS Office, Jira, Oracle, SQL Server, Amazon Redshift, SQL Developer, Confluence Jira.

Washington Metropolitan Area Transit Authority, DC Feb’2021 -July’2021

Sr. Tableau Admin/Developer

Managed Tableau server administration, including creating users, groups, projects, data connections, and settings.

Defined best practices for Tableau report development; assisted users in creating and modifying worksheets and data visualization dashboards.

Conducted data analysis of reports, debugged report data, and collaborated with DB teams.

Built Tableau visualizations using various data sources like flat files (Excel) and relational databases.

Utilized filters, quick filters, sets, parameters, bins, groups, and calculated fields in Tableau reports.

Participated in weekly meetings, reviews, and user group meetings; communicated with stakeholders and business groups.

Developed Cognos analytics reports using SQL queries.

Reviewed business requirements and ensured alignment with reporting solutions.

Handled user and content management across all environments.

Collaborated with the Tableau vendor team to resolve product issues.

Assisted users with Tableau Desktop-related questions and issues.

Troubleshot issues with Tableau Server; proficient in reading Tableau log files and debugging issues.

Managed Tableau server licensing, maintenance, upgrades, and provided configuration recommendations.

Developed multiple dashboards to monitor server usage.

Participated in meetings addressing development and price analysis for Tableau Server.

Environment: Tableau Desktop & Server 2020.x, MS Office, SQL Developer, Oracle, SQL Server, Cognos Analytics, Report Studio, Framework Manager, Jazz, R, SVN, Wiki, Agile.

Wells Fargo, MN Apr’ 2020 - Jan’ 2021

Sr. Tableau Admin/Developer

Converted SSRS reports, developed based on stored procedures, into Tableau visualizations.

Reviewed business requirements and analyzed data sources from Excel, Oracle, and SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Utilized filters, quick filters, sets, parameters, bins, groups, and calculated fields in Tableau reports.

Created various interactive, customized dashboards and stories.

Conducted data analysis of reports, debugged report data, and collaborated with DB teams.

Generated various dashboards in Tableau Server using sources such as Oracle and SQL Server.

Developed LRM (Liquidity Risk Management) reports for management.

Performed data analysis on daily, weekly, and monthly scheduled refreshes of data based on business needs.

Participated in weekly meetings, reviews, and user group meetings, and communicated with stakeholders and business groups.

Followed best practices for Tableau report development and assisted users in creating and modifying worksheets and data visualization dashboards.

Tested SQL scripts for report development, Tableau reports, dashboards, and scorecards, and effectively handled performance issues.

Ensured data accuracy in dashboards per business requirements and adapted to changes in underlying data.

Combined views and reports into interactive dashboards in Tableau Desktop for presentation to business users, program managers, and end users.

Environment: Tableau Desktop & Server 2020.x, Tableau Prep, SSRS MS Office, SQL Developer, SQL Server management studio, Confluence Jira, R, SVN, Wiki, Agile, Oracle SQL Server.

Dovel Technologies, Rockville, MD Jun’ 2016 – Mar’ 2020

Tableau Admin\Developer

Designed and developed data visualizations, published on Tableau Server.

Extracted data from various sources (SQL Server, Amazon Redshift, Oracle) and developed dashboards.

Converted existing Cognos reports into Tableau dashboards.

Created parameters, quick filters, context filters, and sets to dynamically display top result sets; utilized filters, quick filters, sets, parameters, groups, and calculated fields in Tableau reports.

Compared, validated, and migrated reports across different environments, including Tableau Server administration; developed various SQL queries.

Created custom reports and dashboards for grant solutions agencies like ACF, CDC, CMS, DOT, etc.

Used advanced SQL scripts, aggregation functions, and advanced charts like tree maps and heatmaps for applications.

Worked with Tableau Prep to combine, shape, and clean data for analysis.

Cleaned and blended multiple data sources for comprehensive views on application data in a single dashboard.

Created dashboards using table calculations, logical calculations, and number calculations.

Conducted data analysis of reports, debugged report data, and collaborated with DB teams.

Assisted users in resolving report data queries and provided support to the user community.

Managed user and content access by creating and restricting users and groups.

Scheduled Tableau dashboards and Cognos reports per user requirements.

Set up the Tableau environment from scratch; assisted new users and improved the learning curve

Integrated Tableau Server with single sign-on (SAML).

Assisted users with Tableau Desktop-related questions and issues.

Troubleshot issues with Tableau Server, proficient in reading Tableau log files and debugging issues.

Managed licensing, maintenance, and upgrades of Tableau Server.

Tested new product releases, checked compatibility with single sign-on, and evaluated the upgrade process.

Environment: Tableau Desktop & Server 2019.x, 2018.x,10.X, MS Office, Oracle SQL Server, Cognos, Report Studio, Framework Manager, Active Directory, Oracle11g, SQL Developer, Excel, Confluence Jira, R, Python, SVN, Wiki, Agile, Amazon Redshift.

US Cellular, Itasca, IL Nov’ 2015 – May’ 2016

Business Intelligence Developer

Conducted data analysis of reports and debugged report data in collaboration with DB teams.

Designed functional and technical specifications for reports.

Resolved user queries on report data and provided support to the user community.

Developed framework models and packages using Cognos 10.2 Framework Manager tools.

Analyzed drill-through links, native SQL scripts, filters, calculations, and optimized performance and formatting issues for dashboard reports.

Designed and developed reports and dashboards.

Created charts, graphs, and complex reports with custom calculations using Report Studio.

Utilized conditional techniques like conditional blocking and conditional formatting using report variables.

Developed complex drill-through reports for summary and detailed project analysis using Report Studio.

Created complex reports with multiple data source queries at the report level.

Environment: Cognos 10.2.2, Report Studio, Query Studio, Workspace Advanced, Workspace, Framework, Manager, Transformer, HTML, DHTML, Unix, SQL Scripting, Microsoft office, Active Directory, Teradata, Oracle11g, SQL Developer.

GameStop, Grapevine, TX Aug’ 2013 – Sep’ 2015

Business Intelligence Developer

Created framework models and packages using various data sources for reporting needs.

Conducted data analysis of reports and debugged report data in collaboration with DB teams.

Developed active reports in Cognos 10.2 Report Studio using controls like variable controls, decks, data decks, and prompt controls.

Designed and developed complex lists, crosstabs, charts, and dashboard KPIs, implementing filters, prompts, calculations, and conditional formatting.

Utilized different types of aggregate functions and calculations to display detailed and summarized data at various grouped levels.

Addressed performance tuning issues of the reports.

Assisted users in resolving report data queries and provided support to the user community.

Environment: Cognos 10.2.1, Report Studio, Query Studio, Workspace Advanced, Workspace, Framework Manager, SSIS, Transformer, Microsoft office, Active Directory, MS SQL server 2012, Oracle11g, SQL Developer.

State Farm Insurance, Bloomington, IL Jan’ 2012 – Jul’ 2013

Business Intelligence Developer

Developed dimensional models and published packages in Framework Manager; created database and presentation layers, defining appropriate relationships between query subjects.

Worked with Workspace Advanced to create lists, crosstab reports, and trained power users on tool usage.

Created active reports in Cognos 10.2 Report Studio using controls like variable controls, decks, and prompt controls.

Modified existing reports and developed new reports and dashboards.

Designed reports using filters, prompts, calculations, and conditional formatting.

Created prompt pages to meet business user requirements, adding conditions and filters as needed.

Addressed performance tuning of reports, performed data analysis, and unit tested reports data.

Environment: Cognos 10.2.1, Report Studio, Query Studio, Workspace Advanced, Workspace, Framework Manager, Transformer, Cognos Data Manager, Active Directory, Excel, MS Power point, Oracle 11g and SQL Developer.

Qualcomm, San Diego, CA May’ 2011 – Jan’ 2012

Business Intelligence Developer

Collaborated with users to resolve data, tool usage, and reporting issues.

Scheduled and distributed reports using Schedule Management in Cognos Connection.

Developed customized Power Prompts, including date prompts and search prompts.

Designed multidimensional models and packages using Framework Manager.

Created reports with cascading prompts and conditional formatting.

Defined user access and user classes for different user groups using Access Manager to ensure security.

Designed multidimensional models in Transformer and built cubes.

Environment: Cognos8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio), Access Manager, IIS, Cognos Transformer, Informatica, Power Play, Oracle 10g, MS SQL server 2008, MS Excel, MS office, TOAD.

Medimmune, Gaithersburg, MD Mar’ 2010 – May’ 2011

Business Intelligence Developer

Documented reporting requirements and specifications to forecast patient numbers for study goals.

Developed dimensional models and published packages in Framework Manager; created database and presentation layers, defining relationships between query subjects.

Modified existing reports and developed new reports and templates.

Developed Clinical Trial Enrollment Forecasting reports.

Suggested physician-directed care and patient satisfaction analysis reports.

Utilized Impact for trial design and planning, regulatory document processing, accelerated patient recruitment, and medical writing.

Created prompt pages based on business user requirements, adding conditions and filters.

Developed relational Framework Manager models and published packages to generate BI analytics.

Scheduled reports on a daily, weekly, and hourly basis.

Worked on performance tuning of the reports.

Defined user access and user classes for different groups, ensuring security using Active Directory.

Environment: Cognos 8.4, Report Studio, Analysis Studio, Framework Manager, Transformer, Powerplay Studio, LDAP, Oracle 10g, MS office, TOAD, Windows 2007 server and Unix.

Education:

Bachelor’s degree in mathematics, Osmania University, Hyderabad, Telangana, India (1982-1985)

Master’s degree in education, Kakatiya University, Warangal, Telangana, India (1989-1990)

Master’s degree in philosophy, Osmania University, Hyderabad, Telangana, India (1990-1992)

Skills:

Proficient in Tableau Desktop and Server (versions 10.X, 2018.X, 2019.X, 2020.X, 2022.X, 2023.X)

Experienced in Tableau Server installation, configuration, and environment setup.

Expertise in data warehousing, business intelligence, and data visualization.

Skilled in SQL, Data model, data analysis, and report development.

Experienced in working with various data sources (i.e. SQL, Excel, Databricks, Redshift, Oracle).

Proficient in Tableau Prep for data cleaning, shaping, and combining.

Familiar with Agile methodologies and project management tools (Jira, Confluence).

Strong problem-solving and troubleshooting skills.

Excellent communication and collaboration abilities.

Contact this candidate