Penchala Prashanth

Ph: 281-***-**** Email: adkls1@r.postjobfree.com

PROFESSIONAL SUMMARY:

Around 8 years of IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2000/2005/2008/2012/2014/2016 in Development, Test and Production Environments on various business domains like Financial, Insurance and Manufacturing

Proficient in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS)

7+ years of experience in Tableau Development. Involved in complete Software Development Lifecycle (SDLC) by identifying the business requirements and converting them to tableau design. Experience in Tableau as a BI Developer, Analyst and Admin

Proficient in Tableau server commands to migrate workbooks and Tableau server backup, Debugging and monitoring.

Proficient in design and development of various dashboards, reports utilizing 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 end user requirement

Extensive experience using Tableau Server Tableau Desktop and Tableau Public

Proficient in Installing Configuring and Administration of Tableau Server

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 Tableau Administration Tool for Configuration adding users managing licenses and data connections scheduling tasks embedding views by integrating with other platforms like SharePoint

Extensive Tableau Experience in Enterprise Environment and Tableau Admin and Architect.

Experience with complex or large-scale installations and architecture, automation and working with functional teams.

Proficient in Installing, Configuring and Administration of Tableau Server and server performance tuning for optimization.

Experience including technical support, troubleshooting, report design and monitoring of system usage.

Experience in connecting to all type of data sources and able to handle large number of datasets.

Strong knowledge of best practices around dashboards and report visualization

Experience in creating Tableau Data Extracts, publishing to Tableau server and scheduling on - demand to refresh the Tableau Data Extract to get the updated data from original data source.

Experience in the maintenance and scheduling of Tableau Data Extracts using Tableau Server and the Tableau Command Line Utility.

Experience in Installing, configuring and administration, upgrading the Tableau Server in single server installation and distributed installation environments (3 node Cluster setup and design).

Experience in Tableau Server administration tasks including Tableau server optimization and performance tuning.

Managing the Tableau users and group’s security configuration and Integration with active directory.

Providing the best practices and Performance optimization techniques for Development and administration process and documentation of the tableau Platform.

Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and Processing SSAS objects

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports

Linux/Tableau administrator, with a strong performance background in wide variety of professional system support and solution - based IT services for Linux Systems and tableau (or administrations) including, monitoring, configuration, troubleshooting and maintenance of operating systems.

Experience in using SQL server reporting Services (SSRS) and creating various reports such as Parameterized, Cascading, Tabular, Matrix, Chart and Drill down reports

TECHNICAL SKILLS:

SQL Server Tools

SQL Server Management Studio, SQL Server Business Intelligence Development Studio

SQL Server Tools

&Packages/BI tools

SQL Server Management Studio, SQL Server Agent, MDX, ETL, SSIS, SSAS, SSRS, Micro strategy, Erwin Data modeler, IBM Rational Rose, Crystal Reports 11, Tableau Desktop 7/8/9/10, Tableau Server 7/8/9/10, Tableau Reader Tableau Public

Reporting Tools

SSRS, Power BI, Tableau, Crystal reports.

Languages

C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script

Operating Systems

Windows 95/2000/2003/2008/XP/VISTA/7, UNIX (Sun Solar), LINUX

PROFESSIONAL EXPERIENCE

QUALITY REIMBURSEMENT SERVICES, Phoenix, AZ March 2018 to Present

Role: Lead Tableau Developer/Admin

Responsibilities:

Actively participate in review meetings with Project Manager to ensure that the development of projects meet business and system requirements for design development testing and production rollover of reporting and analysis projects within Tableau Desktop

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

Created dashboards by extracting data from different sources and created dashboard using parameters, sets, groups and calculations in Tableau Desktop.

Created calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.

Installed, Configured and setup Tableau environment in the organization.

Worked with Teradata database and extracted data using Alteryx and developed POCs by building reports and dashboards using Tableau 9.2 to demonstrate quick wins.

Incorporating weekly changes of the data source files by integration into Tableau data sources for timely leadership reporting.

Created actions parameters Filter Local Global and calculated sets for preparing dashboards and worksheets using Tableau Desktop

Worked on creation of user’s groups projects workbooks and the appropriate permission sets for Tableau server logons and security checks

Worked as Tableau architect in standardizing Tableau for enterprise wide deployment

Administered and supported a multi-tier Tableau infrastructure including upgrade analysis and planning, security administration, release management, troubleshooting, performance tuning, and general systems maintenance.

Managed the application's users, groups, and integration with Active Directory.

Responsible for ensuring that daily operations support and maintenance is performed related to Tableau infrastructure.

Reviewed complex dashboards for effective and optimum performance by tuning queries

Tableau Server architecture and configuration and experience with Tableau customizations Responsible for gathering requirements and creating functional specifications.

Creating the backup of primary tableau server for high availability and failover support in 3 node cluster environments.

Troubleshooting the tableau server issues and creating archives of logs for troubleshooting.

Developed Tableau workbooks from multiple data sources using Data Blending

Creating the Tableau data layers, dashboards and Publishing to the Tableau server

Manage the Tableau users and group’s security configuration and integration with Active Directory

Responsible for all backup and restore of Tableau server and Tableau server metadata.

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

Used MDX and DAX queries to apply calculations to the cube in SSAS 2016/2014

Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing

Developed, deployed, and monitored SSIS Packages

Worked in Agile/Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010

Developed reports such as tables, matrix, Gauges, Charts, parameter reports, cascading parameter reports using SSRS and exported to EXCEL, CSV and PDF formats bypassing the report manager screen running the reports from ASP.NET application. Microsoft report viewer control

Deployed SSRS reports into a reporting server and implemented security measures at report server

Contracted to design desktop and server systems for companies transitioning from Windows to Unix

Designed systems utilizing Sun Solaris 10, Confidential Linux 6 and AIX 5L

Providing technical support and troubleshooting of Tableau, SSRS, SSIS in Linux environment.

Environment: SQL Server 2017/2019, Tableau Desktop9/10.2, Tableau Server 9/10, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Power Map, Power Pivot, Power View, Power BI 2016, MDX,OLAP, Microsoft Office Share Point Server, XML, MS Visual Source Safe, HTML, Teradata, Adobe Marketing Cloud, Teradata SQL Assistant, Teradata Administrator

C&S Wholesale Grocers, Charleston, SC Jan 2017 to Feb 2018

Role: Sr. Tableau Admin

Responsibilities:

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server

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

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau

Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications

Consistently attended meetings with the Client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business's needs

Provided support for Tableau developed objects and understand tool administration

Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server

Created Custom Hierarchies to meet the Business requirement in Tableau

Created Workbooks and dashboards for analyzing statistical billing data using Tableau 9.0

Understanding and translation of the current existing reporting system SSRS reports to convert them as Tableau reports and dashboards.

Installation and configuration of Tableau Products Tableau Desktop and Tableau Server in different environments DEV, STAGE and PROD.

Experience using the Tableau tool to handle the various data feeds from different data sources using the Tableau Desktop tool

Good Experience in working on Tableau data analysis as Tableau Analyst and building, developing the Tableau development dashboards as a Tableau Developer and Publishing the developed Tableau dashboards to Tableau server with security and authentication as a Tableau Administrator.

Acts as a Tableau Analyst, for performing various report\dashboard activities such as grouping, sorting, filtering, ranking and ordering the data and using Tableau reports for various analysis Top - N Analysis, Comparative Analysis, Systems\Sources GAP Analysis, Trend Analysis (Data vs Time).

Using the Tableau for the data\business predictive findings, for trending, for finding the pattern of data over the period.

Involved in creating the report mapping document, reports specs doc and interacting the cross functional departments and stakeholders for gathering report\dashboards requirements.

Working with various Teradata tools and utilities like Teradata Viewpoint, Multiload, ARC, Teradata Administrator, BTEQ and other Teradata Utilities.

Used Teradata Fast Load utility to load large volumes of data into empty Teradata tables in the Data mart for the Initial load and Used Teradata Fast Export utility to export large volumes of data from Teradata tables and views for processing and reporting needs.

Prepared complex SQL/R scripts for ODBC and Teradata servers for analysis and modeling.

Extracted, performed validation and generated SAS data sets from Teradata, applied SQL Pass through Facility.

Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012/2014 and Flat files.

Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2008R2/2012.

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database

Used ADO.NET objects to access data from SQL Server 2012 database by using stored procedures and queries in T-SQL

Worked with the group which evaluated and recommended technologies including ASP .NET MVC

Environment: SQL Server 2014/2016, Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), MDX, OLAP, Microsoft Office, Tableau 9.1/9.0, Tableau Server, Share Point Server, Teradata

Tesoro Corporation, San Antonio, TX Aug 2016 to Feb 2017

Role: Tableau Admin

Responsibilities:

Actively involved in design of a new normalized data store (NDS) based on Data Vault Methodology as well as a De – normalized Data Store (DDS) per Dimensional Model

Extensive knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, transformations, filters, Sets, Groups, prompts, Parameters in Tableau.

Deep experience with the design and development of Tableau visualization solutions.

Knowledge of Alteryx

Experience setting up and managing Tableau Server with large volumes of data.

Experience on Configuring installation and managing Tableau Server with large data volumes like

Setting up Tableau data sources. Filters, blending, joins for optimum performance and

Trouble-shooting issues.

Working on generating various dashboards in Tableau server using various sources such as Teradata.

Worked as Tableau Server Administrator and Tableau desktop developer

Installed and configured Tableau Server and Tableau Desktop

Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint

Implemented security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication

Created worksheets and dashboards by using custom queries and multiple tables

Created various interactive customized dashboards and stories

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server

Applied various types filters like Data source filters, Quick filters and Context Filters

Created table calculations, calculated fields and parameters

Extracted data from various sources and performed data blending

Created Custom Admin Views for the server Using SQL Database to track detailed view of usage, user activity, server activity etc

Understanding and translation of the current existing reporting system SSRS reports to convert them as Tableau reports and dashboards.

Installation and configuration of Tableau Products Tableau Desktop and Tableau Server in different environments DEV, STAGE and PROD.

Generated high detail-oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geocoding.

Good Experience in working on Tableau data analysis as Tableau Analyst and building, developing the Tableau development dashboards as a Tableau Developer and Publishing the developed Tableau dashboards to Tableau server with security and authentication as a Tableau Administrator.

Acts as a Tableau Analyst, for performing various report\dashboard activities such as grouping, sorting, filtering, ranking and ordering the data and using Tableau reports for various analysis Top - N Analysis, Comparative Analysis, Systems\Sources GAP Analysis, Trend Analysis (Data vs Time).

Using the Tableau for the data\business predictive findings, for trending, for finding the pattern of data over the period of time.

Involved in creating the report mapping document, reports specs doc and interacting the cross functional departments and stakeholders for gathering report\dashboards requirements.

Involved in creating the report mockups, prototypes for the end dashboards and interacting with stakeholders for report change request and sign -off on the requirements.

Created SSIS Packages to import the data from Oracle databases, XML, text files, Excel files.

Developed and Extending OLAP Cubes, Dimensions and data source view.

Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2008/2012/2014 Analysis Services (SSAS) and Reporting service (SSRS)

Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

Designed and developed the reports according to the requirements using Tableau and Power Map.

Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.

Used SSRS Report Manager to assign roles, permissions and to create report schedules

Environment: SQL Server 2008 R2/2012, Tableau 9.0/8.0, Tableau Server, Business Intelligence Studio (SSAS, SSIS, SSRS), Power BI 2013, SharePoint 2010, XML, T SQL, MS Excel, ASP.NET, ETL, OLAP

Waste Management, Houston, TX May 2015 to July 2017

Role: Tableau Admin

Responsibilities:

Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development

Deep experience with the design and development of Tableau visualization solutions.

Experiencing the installations and administration the tableau server.

Installation of Tableau 8.0 and Upgrade to tableau 9.00 on enterprise platform.

Background in installing and upgrading of Tableau server and server performance tuning for optimization.

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

Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client

Involved in data validation of the results in Tableau by validation the numbers against the data in the database tables by querying on the database

Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization

Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports

Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server

Blended data from multiple databases into one report by selecting primary keys from each database for data validation

Developed highly polished executive level dashboard prototype for the Operations Research Consulting group which provides BI for different Airlines to implement their decision support systems for developing competitive fares, low fare schedules, optimizing the data between partner airlines, etc

Worked on building queries to retrieve data into Tableau from SQL Server 2008 and Oracle SQL Developer, and developed T-SQL statements for loading data into Target Database

Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online

Developed storytelling 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.

Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012.

Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Processing the cubes and dimensions daily using the SSIS tasks.

Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012.

Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.

Created Data warehouse Cubes in SQL Server Analysis Service (SSAS).

Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).

Developed reports in SSRS 2012 and deployed reports into SharePoint Server 2010 (MOSS).

Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.

Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.

Environment: SQL Server 2008 R2/2012, Business Intelligence Studio (SSAS, SSIS, SSRS), Performance Point Server, SharePoint 2007, Proclarity, T SQL, Erwin, Oracle 10g, Tableau Desktop 7 8.1, Tableau Server, MS Excel, ASP.NET, ETL, OLAP, MDX.

Calpers, Sacramento, CA Feb 2014 to May 2015

Role: SQL Server BI (SSRS/SSIS) Developer/Admin

Responsibilities:

Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS

Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)

Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources

Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data modelsPreparing Dashboards using calculations, parameters in Tableau.

Experience in design and development of Tableau visualization solutions.

Working on generating various dashboards in Tableau server using various sources such as SAP HANA/SQL Server/Teradata/Oracle.

Experience in creating users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Preparing Dashboards using calculations, parameters in Tableau.

Created drill down and drill up in worksheets in tableau.

Created report schedules on Tableau server.

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.

Involved in license management SLA's with Tableau support.

Prepared proof of concept for best practices in Tableau deployment

Responsible for creating reports based on the requirements using SSRS

Experience in creating reports using SSRS Report Builder 3.0

Also involved in creating CRM Reports using Visual Studio 2010/2013

Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008R2

Deployed the generated reports on to the server and various environments

Advanced extensible reporting skills, developed SQL Server reports using SSRS

Responsible for scheduling the subscription reports with the subscription report wizard

Designed and implemented SQL Server database objects (Complex stored procedures, functions, views and complex T-SQL/queries) to support reporting and various business processes

Met with various departments and end users to gather requirements for the reports and participated in testing them

Involved in giving demo of the created reports to the concerned department, making necessary changes, or getting the reports signed off and deploy on to the server

Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups

Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios

Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to

Implemented security to restrict the access to users and to allow them to use only certain reports

Environment:

MS SQL SERVER 2012 R2, SQL Server 2014, MS SQL Server 2012/2014, SSIS, SSRS, Microsoft Visual Studio 2014, SQL Profiler, Microsoft Visio, MS Office 360, Excel 2016, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2008

YBrant Digital, Hyderabad, India Aug 2012 to Sep 2013

Role: Database Developer/DBA

Responsibilities:

Installation, configuration the MS SQL Server 2000 and maintenance of servers in various environments.

Performance and tuning of SQL servers and application issues related to migration.

Testing of applications for performance, data integrity and validation issues.

Data Transfers between various servers using BCP and Managing Disk space on NT systems.

Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.

Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.

Develop and maintain in-house utilities to automate problem determination, change implementation and monitoring activities.

Administrative and Production support for various applications in all environments.

Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.

Environment: SQL Server 2000, Query Analyzer, SQL Profiler, Windows 2000 Server, Import & Export Data.

EDUCAION:

Master’s in information management system, Coleman University, San Diego, CA 2015

Bachelors in Computer Science from JNTU, HYD in 2013

Contact this candidate