Tableau Developer
Resume:
Prithvi
***********@*****.***
SUMMARY:
8+ years of diversified experience in Software Development, Design, Implementation and Maintenance of Business Intelligence Data Visualization tools.
Proficient in Data Visualization Development using Tableau to create complex, intuitive, and innovative dashboards.
Five years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0,8.1 and 9.3 as a developer and Administrator.
Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.
Experience in creating different visualizations using Bars graphs, Lines and Pie charts, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
Introduced Tableau to Client’s to generate different views of Data Visualizations and presenting dashboards on web and Desktop platforms to End-user and help them analyze and make effective business decisions.
Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining the Data Source and subtotals for the reports using SSRS.
Experience in Agile, Scrum and Waterfall software development life cycle.
Experience in client requirement Analysis, Physical and Logical design, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000/7.0, DTS, SSIS,SSRS and SSAS.
Proficient in ETL-Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
Expert in Trouble Shooting, Performance tuning of reports and resolving complex issues with in Business Objects Enterprise and Reports.
Experience in working with different database platforms including Oracle, PL/SQL, MySQL, SUPRA and DB2.
An excellent and reliable team player with Good interpersonal skills, commitment, result oriented, Multitasking, hard working with Analytical skills.
TECHNICAL SKILLS:
Operating Systems
UNIX, Windows NT, Mac
Reporting Tools
Tableau 9.3, 9.0,8.1,8.0,7.0, SSRS
Database
Oracle, MS SQL Server 2008/2012, DB2, Teradata, MS Access
Languages
SQL, PL/SQL, C, C++, HTML, Python, Java Script
Data Modeling Tools
Erwin 4.0/3.5, Star Schema, Snowflake Schema, OLAP, OLTP
Tools
MS Office, TOAD, WinSQL, Autosys, MS Visio
ETL Tools
SSIS(SQL Server Integration Service), DTS, Informatica
WORK EXPERIENCE:
Mimedx, Atlanta Jan 16 – Till Date
Tableau Developer
Responsibilities:
Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.
Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary reports and dashboard using KPI's.
Installed Tableau Server in Dev, QA, UAT and Prod environments.
Installed patches on the server and documented upgrade plan from Tableau 8.0 to 9.3.
Administered user, user groups, and scheduled instances for reports in Tableau.
Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
Used Sheet filters to produce multiple chart types in a single view.
Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, adhoc, business views along with user acceptance test and data accuracy test.
Involved in creating dashboards and reports in Tableau 9.3 and Maintaining server activities, user activity, and customized views on Server Analysis.
Coordinated database middleware issues with DBA's, system performance with System Architects.
Created organized, Defined best practices for Tableau report development.
Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
Provided 24/7 production support for Tableau users.
Environments: TableauDesktop 9.3/8.0, Tableau server/Administrator, SQL developer, SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office.
Tableau Developer Nov 14 - Dec 15
AT&T, Dallas, TX
The project is aimed to integrate data from multiple sources into data warehouse and develop reports on same using Tableau.
Responsibilities:
Served as Tableau Developer meeting deadlines and budget requirements.
Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
Created interactive dashboard and applied filter, highlight and URL actions to the dashboard.
Developed Standard Operating Procedures (SOP) for Monitoring.
Extensively used data blending, embed functionalities in Tableau.
Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
Administered user, user groups, and scheduled instances for reports in Tableau.
Mentored Power users in creating and modifying worksheets and data visualization dashboards.
Involved in license management SLA's with Tableau support.
Defined best practices for Tableau report development.
Used TabAdmin and TabCMD commands in creating backups and restoring backups of Tableau repository.
Provided 24/7 production support for Tableau users.
Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
Provided Tableau server and Tableau desktop training.
Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using.
Key Performance Indicators (KPI) and Measures.
Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.
Environment: Tableau Desktop/Server 8, 8.1, 8.2 MS SQL Server, Oracle, SAP HANA, Informatica, Teradata, Salesforce, Windows 8, MS Excel/Access, SSIS, SSRS.
Vonage Inc. Apr14 - Sept 14
Tableau Developer
Responsibilities:
Reviewed Business requirements and prepared the dashboards as per the requirements
Extracted data from different sources connecting them and used the same to create dashboard
Modified the existing dashboard as per the user requirements Used Tableau Desktop for creating different interactive views and dashboards.
Used different Mark types and Mark properties in views to provide better insights into large data sets.
Created various types of charts to provide better visualization.
Implemented calculations and parameters wherever needed.
Used Tableau Desktop created Interactive-reporting dashboards by combining multiple views.
Wrote UNIX and SQL scripts for pre & post session processes and to automate daily loads.
Performed unit test/integrated testing scenarios, which were used to obtain the UAT's.
Developed narratives that describe the technical process in business terms.
Communicated on daily basis with stakeholders and clients on Tableau related activities.
AIG, Dallas, TX Oct 12 – Mar 14
Tableau Developer
Responsibilities:
Experience with POC reports, designed and developed many Tableau visualization solutions.
Extensively worked on sales and budget data.
Designed and maintain many ad-hock reports monthly.
Extracting data from multiple sources and using Data Blending technique to create dashboards.
Maintaining administered user, user groups, and scheduled instances for reports in Tableau.
Preparing Dashboards using advance table calculations, parameters, calculated fields, groups, sets, forecasting and hierarchies in Tableau.
The ability to interact professionally with a diverse group including executives, managers and co-workers.
Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
Find efficient ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
Proof-read all documents and maintain accuracy of information and preparing SOP.
Developed complex SQL scripts database for creating BI layer on DW for Tableau reporting.
Identify new metrics and enhance the existing KPI's.
Created actions, parameters, Filter (Local, Global) based upon requirements.
Defined best practices for Tableau report development.
Executed and tested required queries and reports before publishing.
Working extensively using Microsoft access and excel to validate the data and use as the source data files.
Tuned reports performance using Tableau performance recording.
Also assisting users in creating and modifying worksheets and data visualization dashboards.
Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
Design and development of various reports and dashboards that can be easily accessible through Tableau App in I pads, iPhones, other smart mobile phones and Tableau reader 8.3.
Environment: Tableau (Desktop 8 & 8.2, Server), SQL server 2008, SQL, PL/SQL, MS Project, MS Office Suite (Word, Excel, PowerPoint) MS Access.
Northern Trust Bank, Chicago, IL Nov 2011 – Sept 2012
BI Tableau Developer
The project deals with providing web-based tools for clients and salespeople to track the value of savings, investments and what-if analysis to help clients understand the effects of changes in investment decisions Monitor loans and manage risk across geographies with interactive bank dashboards. Dynamically produce reports on outstanding accounts that require attention.
Responsibilities:
Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program.
Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
Administered user, user groups, and scheduled instances for reports in Tableau.
Built complex formulas in Tableau for various business calculations.
Resolved various performance issues and analyzed the best process distribution for different projects.
Created and assisted users in Tableau dashboard development.
Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
Developed business process and technical design documentation for each reporting service developed in this project.
Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services.
Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
Optimized queries by looking at Execution Plan for better tuning of the database.
Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.
Environment: Tableau Server 7, Tableau Desktop 7, MS SQL Server, Oracle 10g, Excel, TSQL, UNIX, SQL BI Suite (SSIS, SSRS), Oracle 11g, Toad, MS Office, Visual Studio 2010
Dr. Reddy’s Lab, Hyderabad, INDIA Oct 2009 - Aug 2011
Business Object Developer
The project deals with the Sales & Marketing Data collected from different tests conducted on the subjects. The data is then consolidated into the data mart which is used for the report generation. The System was primarily designed to provide reports for our Performance Analysts who could use the Daily Operational Reports to investigate discrepancies, thereby creating a streamlined and efficient process.
Responsibilities:
Published reports in Business Objects Enterprise XI R2 using Central Management Console and Publishing Wizard.
Assigned Scheduling Rights as per the User Requirements.
Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management.
Work with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
Work with production team to coordinate and assist in rollout of releases.
Setup hierarchies in the Universe for providing drill down options in the reporting environment.
Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
Worked with BO support in troubleshooting issues and provide logs as per request for resolving several complex issues.
Created various complex Reports and exported to Excel Spreadsheets for Analytical uses.
Provided solutions to various groups for scheduling reports using Packages and event based job scheduling Co-ordinating with various groups in scheduling releases between environments.
Deployment of Crystal Reports via various methodologies Central Management Console(CMC), Publishing Wizard, Infoview, Import Wizard.
Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
Experience on Developing Crystal Reports.
Daily reporting to Management on status, issues, migrations, escalations and progress.
Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit Database for investigating User activity and narrowing down issues.
Assist Team in Optimizing system architecture.
Assist with website deployment architecture (e.g. web servers, databases etc.) and code optimization.
Designed and implemented Adhoc Reports, Extracting Data from an SQL Server database.
Experience managing user accounts and group accounts in Crystal enterprise environment.
Used Clear case Explorer to Take Backup of Webi Reports and Universe.
Environment: Business Objects XIR1/XI R2 SP2, Crystal Enterprise 10, Crystal Reports XI R1/ XI R2, Windows 2k3/2k, Universe Designer, Web Intelligence. Oracle10g, Clear case.
Apollo, Hyderabad, India July 2008 – Sept 2009
Data Analyst
Responsibilities:
Defined and designed the data sourcing and data flows, data quality analysis.
Identified the data source and defined them to build the data source views.
Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
Developed and deployed SSIS packages to load the data from OLTP to DWS.
Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS)
Used SQL Server Agent to automate the SSIS package execution.
Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS.
Configured and maintained Report Manager and Report Server for SSRS.
Identified and added the report parameters and created the reports based on the requirements using SSRS.
Environment: MS SQL Server 2005, MS SSRS, MS SSIS, T- SQL, MS office 2003.
Contact this candidate