Uploaded File
Kartheek
kartheek2484@gmail.com
630-635-6231
1348 S Finley Rd, Unit #1J
Lombard, IL 60148
Tableau Developer/ Admin
13 years experience W2
0
Recommendations
Average rating
488
Profile views
Summary

  • Over 4+ years of experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7 and Tableau 8, Teradata, and SQL and aware of Tableau 9 features and has hands on experience in the Financial Industry and payment products.

  • 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 creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) using Tableau Desktop.

  • Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.

  • Experience in gathering requirements, analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.

  • Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.

Technical Skills

  • Tools: Tableau Desktop 8.3/8.2/8.1/7/6, Tableau Server 8.2/7/6,Tableau Reader,
    MicroStrategy 9.2.1/9.0.1/8.1.1/8.0.1 (Administrator, Desktop, Web, Architect),
    SSIS, SSAS, and SSRS

  • Operating systems: Windows XP, NT/2000, Windows Server 2003/2008, UNIX
    RDBMS, Oracle 12C/ 11G/9.x , SQL Server, MS Access, Teradata 12.0

  • SDLC Tools: Perforce, Team Foundation Server (TFS)

  • Languages: SQL, HTML, C, Java

  • Methodologies: Complete Software Development Life Cycle, Waterfall, Agile, Iterative, Scrum

Experience
Tableau Developer
Information Technology
Apr 2015 - present
  • Provide solutions to Multinational companies as a technology consultant which include in the recent past, develop Tableau visualizations in Tableau 6, 7, and 8 like dual axis, Gantt charts, Bubble charts, and create calculations required across various platforms.

  • Extensively used data blending, parameters, actions, containers and Vertica, R integration.

  • Experienced with Agile-Scrum development and SDLC process and methodologies.

Tableau SDLC Business Intelligence Analytics Analysis Data Analysis Scrum Agile Methodology
Remove Skill
Sr. Tableau Developer / Admin
Insurance
Oct 2015 - Apr 2016
  • Provide aesthetic dashboards that meet the business process to measure the KPIs.
  • Provide solutions to the current projects migration to Tableau using Tableau Server 9.2 and Desktop 9.2
  • Improve Performance on existing workbooks modifying the datasource based in IBM DB2.
  • Data
Tableau Tableau Server
Remove Skill
Tableau Developer/Admin
Healthcare
Feb 2014 - Mar 2015
  • Dovetail Health offers a unique approach to providing medication management solutions across the continuum of care delivery, engaging with its partners to identify gaps in care where better medication management will result in better quality and lower medical expense.

  • Involved in Planning, Defining and Designing data based on business requirements and provide documentation.

  • Performed Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.

  • Optimized Indexes, Views, Stored Procedures and Functions using T-SQL.

  • Created Schedules and Extracted the data into Tableau Data Engine.

  • Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server.

  • Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.

  • Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.

  • Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.

  • Effectively used data blending feature in tableau.

  • Defined best practices for Tableau report development.

  • Administered user, user groups, and scheduled instances for reports in Tableau.

  • Executed and tested required queries and reports before publishing.

  • Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

  • Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.

  • Executed and tested required queries and reports before publishing dashboards.

  • Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.

  • Extensively worked on Tableau Desktop, by creating Complex reports & Dashboards.

  • Created Tableau scorecards, dashboards, Heat maps using show me functionality.

  • Scheduling the monthly/weekly/daily reports to run automatically.

  • Created procedures to ensure the quality, usability and accuracy of reports.

  • Created Packages to group logically related column types and to transfer data.

  • Designed both logical and physical data models in Erwin.

  • Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.

  • Environment: Oracle SQL Server 2012, Tableau Desktop, Tableau Server, Microsoft Visual Studio, Microsoft Visual Basic, Oracle 11g, SQL Server Management Studio 2010, MS Excel, ERWIN.

Oracle SQL Server Microsoft Excel Tableau Oracle 11i SQL Stored Procedure Triggers T-SQL System Requirements Analysis Business Intelligence Analytics Data Analysis Tableau Desktop Tableau Server Visual Studio Visual Basic Erwin Data Modler MS Active Directory Project Management
Remove Skill
Tableau Developer/Admin
Insurance
May 2013 - Jan 2014
  • Over the last 85 years, Nationwide has grown from a small mutual auto insurer owned by policyholders to one of the largest insurance and financial services companies in the world, with more than $158 billion in statutory assets. Early growth came from working together with Farm Bureaus that sponsored the company. Nine Farm Bureaus continue to promote Nationwide and provide discounts to members.

  • Created stored procedure using nodes method to load XML file data into SQL server tables.

  • Wrote User defined functions, views, trigger, and indexes for various purposes based on the requirements.

  • Rewrote poorly performance stored procedure, functions, triggers, views and indexes.

  • Created reconsolidation reports for conversion purpose using various joins.

  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

  • Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

  • Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users using Tableau.

  • Projected and forecasted future growth in terms of number of subscribers in various services by developing Area Maps to show details on which states were connected the most and publishing it on Tableau Server.

  • Converted charts into Crosstabs for further underlying data analysis in MS Excel.

  • Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel.

  • Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.

  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

  • Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

  • Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

  • Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

  • Rewrote various business process and tested result in MS Excel using various functions and sub query with not exists.

  • Involved in updating functional requirement document after development and created documentation for deployment team.

  • Environment: Windows 2003 Server, Tableau Desktop (Version 6.0.10 - Version 6.1.11), Tableau Server(Version 6.0.10 - Version6.1.11), MS Office Suite, Oracle SQL Server, MS Excel, IIS, ER studio, Microsoft Visual Studio 2008, ERWIN, SQL Profiler, MS Excel.

Tableau Oracle IIS Microsoft Excel SQL Analysis Data Analysis Stored Procedure SQL Server Visual Studio XML Triggers Business Requirements Analytics Erwin Data Modler Tableau Desktop Tableau Server E/R Studio Project Management Program Management Windows
Remove Skill
SSIS/Tableau Developer/Admin
Information Technology
Mar 2012 - Apr 2013
  • Project: Roam Data

  • Roam Data offers commercial and mobile commerce solutions. The aim of the project is to create the database model and load the XML file from the ftp to the relational database. Created various stored procedures and packages to extract data from SQL server tables and load into data warehouse as well as created Tableau interactive dashboards which could help clients to visualize their flow of data and forecasting the business growth over the time.

  • Gathered report requirements and determined the best solution to provide the results in a Reporting Services.

  • Designed SSIS packages to Extract data from different sources like SQL server 2008R2, MS Excel, MS Access; transform them and then load into Dimension and Fact tables in Data Warehouse using SSIS.

  • Developed SSIS packages using for-each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.

  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

  • Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

  • Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.

  • Worked closely with business power users to create reports/dashboards using tableau desktop.

  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

  • Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.

  • Created and modified Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

  • Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.

  • Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

  • Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.

  • Environment: Tableau Desktop (Version 5.2.4 - Version 6.0.9), Tableau Server(Version 5.2.4 - Version 6.0.9),Microsoft SQL Server 2008 Enterprise Edition, Windows 2003 Server, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio(BIDS), Tomcat, Microsoft Visual Studio, ERWIN, SQL Profiler.

Tableau Microsoft Excel SQL SQL Server Data Analysis XML Visual Studio Triggers T-SQL Stored Procedure SSRS SSIS Business Intelligence Analysis Data Warehousing Analytics Erwin Data Modler BIDS Tableau Server Tableau Desktop T-SQL SQL SSMS Oracle Apache Tomcat Windows FTP
Remove Skill
SQL/SSIS/SSRS Developer
Insurance
Oct 2010 - Feb 2012
  • Cigna Health Insurance is a which sells traditional and consumer directed health care insurance plans and related services, such as medical, pharmaceutical, dental, behavioral health, long-term care and investment plans. This project was about collecting information about different client belong to different categories pertaining to demographics, industry, annual income for staging post extraction from various sources and provide daily reports.

  • Gathered functional requirements and Business requirements and wrote the technical specifications for building the Data model.

  • Worked closely with end users in designing and creating the Data warehouse for management group using SSIS and Erwin.

  • Implemented logical and physical database modeling using Erwin tool.

  • Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.

  • Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.

  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

  • Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.

  • Successfully implemented SCD transformation in SSIS and performed security.

  • Created star schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.

  • Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.

  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.

  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.

  • Used TFS for Schema compare, Code Management and Deployment.

  • Performed T-SQL tuning and optimization of queries for reports that takes longer execution time using MS SQL Profiler in MS SQL Server

  • Environment: Microsoft SQL Server 2005 Enterprise Edition, Windows Server 2003, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS), Business Intelligence Development Studio(BIDS), Oracle 10g, Microsoft Visual Studio, IIS.

SQL Server Windows Server Oracle Visual Studio IIS SSRS SSIS SSAS CUbe SSAS Business Intelligence Triggers Stored Procedure SQL Data Warehousing Analysis Data Analysis SSMS T-SQL OLTP Data Mining MS TFS ETL Data Modeling Erwin Data Modler Database Design Windows
Remove Skill
PHP Developer & SQL Server Programmer
Information Technology
Jan 2008 - Oct 2010
  • Visa is an American multinational financial services corporation. Visa provides financial institutions with Visa-branded payment products that they then use to offer credit, debit, prepaid and cash-access programs to their customers. The aim of this project was to create and develop multiple data warehouses from the new data sources.

  • Interacted with business users and analysts and gathered and documented the technical and business metadata.

  • Building PHP websites using PHP based frameworks testing and validating work produced as part of the development process.

  • Developing advanced database driven websites & systems including ecommerce.

  • Back end development and maintenance of websites using PHP and MYSQL.

  • Developing web sites using MYSQL, PHP.

  • Working in a data analyst role and with business intelligence applications.

  • Documenting features, technical specifications & infrastructure requirements.

  • Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.

  • Made sure that standards and best practices in database development were followed and maintained.

  • Scheduled and monitored all maintenance activities of SQL Server including database consistency checks and index defragmentation.

  • Set up database backup and recovery strategies.

  • Maintained all records of project status and followed changes as per control procedures.

  • Provided technical support to internal developers and external clients.

  • Environment: PHP, MS SQL Server, MS Access, Erwin, T-SQL, MS-Excel, MS-Access, SQL Query Analyzer, MS SQL Profiler.

PHP SQL Server MySQL Technical Support Technical Specifications T-SQL SQL MS Access Microsoft Excel Business Intelligence Database Backups Data Warehousing Capacity Planning Data Analysis Erwin Data Modler Metadata
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Mechanical Engineering
Birla Institute of Technology
Skills
Business Intelligence
2021
6
Data Analysis
2021
6
Erwin Data Modler
2015
6
SQL
2015
6
SQL Server
2015
6
T-SQL
2015
6
Data Warehousing
2013
5
Microsoft Excel
2015
5
Agile Methodology
2021
4
Analysis
2021
4
Oracle
2015
4
Stored Procedure
2015
4
Tableau
2021
4
Triggers
2015
4
Visual Studio
2015
4
Windows
2014
4
Analytics
2021
3
Tableau Server
2016
3
Capacity Planning
2010
2
Data Modeling
2012
2
Database Backups
2010
2
Database Design
2012
2
ETL
2012
2
IIS
2014
2
Metadata
2010
2
MS Access
2010
2
MySQL
2010
2
PHP
2010
2
Project Management
2015
2
SSIS
2013
2
SSMS
2013
2
SSRS
2013
2
Tableau Desktop
2015
2
Technical Specifications
2010
2
Technical Support
2010
2
Apache Tomcat
2013
1
BIDS
2013
1
Data Mining
2012
1
FTP
2013
1
MS Active Directory
2015
1
MS TFS
2012
1
OLTP
2012
1
Oracle 11i
2015
1
Program Management
2014
1
SSAS
2012
1
SSAS CUbe
2012
1
System Requirements
2015
1
Visual Basic
2015
1
Windows Server
2012
1
XML
2014
1
Business Requirements
2014
1
C
0
1
E/R Studio
2014
1
HTML
0
1
Iterative
0
1
Java
0
1
MicroStrategy
0
1
RDBMS
0
1
Scrum
2021
1
SDLC
2021
1
Teradata
0
1
UNIX
0
1
Waterfall
0
1
Windows XP
0
1