Nitya G

Sr. Tableau Consultant

Email: adltbs@r.postjobfree.com

Phone: 630-***-****

Summary:

IT professional with overall 6+ years of experience, over 4+ years mainly with full range of BI technologies like Tableau 10.x/9.x/8.x/ 7.x, Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server 2005, SSIS, SSAS, SSRS, MS Performance Point Server 2007 (PPS 2007) and Informatica .

Expertise in Tableau reporting while creating reports and dashboards using different data sources coming from multiple sources.

Designing, building and deploying, publishing data analysis reports/dashboards for large volumes of data.

Created dashboards using different types of charts like bar chart, line chart, dual axis charts, pie charts, map charts with layers, funnel and pyramid charts etc.

Created parameters to dynamically control the visualizations and created complex calculated fields using LOD functions.

Creating extracts and live connection to load data and refreshing extracts periodically to publish dashboards on Tableau server.

Implemented row level security in dashboards to limit data based on user access.

Hands-on experience with Tableau suite of products- Server, Desktop,ETL, OLAP analysis and reporting processes using Tableau, MS SQL Server 2005 and BO. Working knowledge of ETL processes of SSIS Packages, MS DTS, OLAP analysis SSAS cubes and SSRS reporting applications (Operational and Business Intelligence).

Involved in implementation and maintenance of high performance BI solutions-, ETL, analysis (OLAP) and reporting of techno-commercial solutions for Biz D’Risking Ops.

Good knowledge of Business Intelligence/Data Warehousing BIDW Fundamental architecture concepts, dimensional modeling, requirement gathering.

Strong experience in various top ranked vendor BI specific tools such as Tableau & MS BI.

Strong skills with Business Intelligence application stack including Tableau Desktop/Tableau Server/Tableau Public/SSIS/SSAS/SSRS, Performance Point Server, multi-dimensional cube building, OLAP/MOLAP and have the solid experience in data warehousing/BI environments.

Versatile team player with excellent analytical and presentation skills.

Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.

Experience in analytical Database Design and Data Modeling skills using MS Visio and ERWIN.

Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop report

Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.

Along with Tableau, I do have good skills on other tools like Qlik Sense, Spotfire and Power BI.

Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.

Established Best Practices for Enterprise Tableau Environment and application intake and development processes.

Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms.

Expert in ETL-Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.

Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.

Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.

Experienced in developing and modifying cubes using SSAS and transform into pivot table.

Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008r2/2008/2005.

Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)

Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

Technical Skills:

Tools

Tableau Desktop 10.5/9.x/8.2,8.1,8.0/7.X/6.X, Tableau Server, Tableau Reader,Tableau online,Tableau Administration, Spotfire, Power BI, QlikSense, Alteryx

Operating systems

Windows XP/2003/2007, Windows Server 2003/2008, UNIX

Programming Languages

HTML,SQL, T-SQL,PL/SQL, Java, JQuery, C and C++

Databases

MS SQL Server 2000/2005/2008/2008R2/2012, MS Access 2000,Teradata,Oracle 11g/10g/9i/8i/8.0.

Productivity Tools

MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin

Methodologies

Complete Software Development Life Cycle, Waterfall, Agile, Iterative, Scrum

Operating Systems

UNIX, Linux, Ubuntu and Windows

Professional Experience:

CGI, Burlington MA April 2018 - Till Date

Sr. Tableau Developer

Developed highly polished executive level dashboard prototype regarding total sales views, and Top Payers.

Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions, and provided an interactive reporting environment in the developed dashboards.

Created Bar Charts, pie charts, box plots, scatter plots for patient statuses, sales, and payers illustrating the total value change with respect to several weeks ago data.

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.

Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.

Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform being implemented by the client.

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

Prepared project documentation and supported business users for various requirements to develop multiple reports accordingly

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

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

Involved in creating a Dual-Axes Bar Chart with Multiple Measures.

Extensively using Alteryx tool to combine and prepare data and then exporting as .tds source.

Developed the Reports like Patient Status Metrics, Top Payers, Top Prescribers on Total Patients, Dormant Patients, Days Between Refills, Active Patients, and Total Shipments by Prescriber, Etc.

Validated data between Tableau and Oracle Data base by writing SQL queries.

Created schema on Tableau by joining different tables to eliminate materialized views and flat structures on oracle data base.

Published finished Dashboards to tableau online.

Involved in tables design in Oracle data base.

Environment: Tableau Desktop 10.5, Tableau Server / Administrator, SAP ABAP, SAP BI 7.3, Alteryx.

Amazon (Contract) Seattle WA SEP 2017 – FEB 2018

BI Developer (Tableau)

Responsibilities:

Responsible for interaction with business stake holders, gathering requirements and managing the delivery.

Copied data from SQL server to Oracle thru .CSV files using SQL developer tool.

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.

Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.

Implemented Data modeling as per the requirement and created new Data Mart.

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

Created organized, customized analysis and visualized projects and dashboards to present to Senior Level

Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.

Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Environment: Tableau Desktop 8.2 and 9.0 Tableau Server, DB2, Oracle SQL Server, Teradata, MS Access, Win Server 2008 R2, Active

T Mobile, Redmond, WA Mar 2017 – AUG 2017

Tableau Developer

Description: Worked for exclusively MII (Manufacturing Integration and Intelligence) section. Developed reports and dashboards for production floor performance.

Responsibilities:

Involved in full life cycle implementation for MII, which includes gap analysis, requirements gathering, development, testing, reporting, reconciliation and go - live.

Understood the business challenges and translated them into requirements and developed Reporting Queries according to Business Requirements.

Worked on MII (Manufacturing Integration and Intelligence) Module to develop performance reports by using Capacity Planning for day, shift and crew.

Created entire process steps for MII Module in BI system for three different location plants (Findlay, Texarkana and Tupelo).

Worked extensively on BEx Analyzer (RRMX) and Browser for building queries.

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

Created views in Tableau Desktop that were published to Internal Team for review and further data analysis and customization using Filters and Actions.

Used Open Hub Destination and BEx Queries as a source for Tableau.

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

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.

Tableau reports are mainly used for production floor reporting.

Performed performance tuning for InfoCubes/queries through partitioning, aggregates and compression.

Data loaded to BI info provider, validations done, unit tested and transported to Quality then to Production.

Written ABAP code for data source enhancement and also in BI data modeling like Start Routines, Filed Routines and End Routines.

Developed Reports like: Returns per Customer, Top Customers, Billing Documents and Incoming Orders per Calendar Year and Month.

Environment: Tableau, SAP BEx, SAPBI, and SAP ECC6.0, Functional: SD, MM, and MII.

Capital One, Plano, TX June 2015 - Feb 2017

Tableau Developer

Responsibilities:

Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.

Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.

Created pie and bar charts and combined them into dashboards to show top content viewed by customers in each category including sports and news channels allowing interaction between the two charts for drill down analysis.

Analyzed data from various databases and formatted it into graphs using Tableau Desktop.

Created line charts to show over time in a breakdown of daily, weekly, quarterly, and yearly parameter numbers of viewers watching a particular sports channel.

Blended data from multiple databases such as MS Excel and Oracle SQL database by assigning primary key from each databases.

Developed geographic maps showcasing demographics broken into age, race, and income category that showed content viewed by individual customers across all content providers.

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.

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

Presented, interacted, and communicated with business and user groups for explaining the dashboards that I have created with the ability to change and view the data on the fly.

Environment: Tableau Desktop 7, Tableau Server, Oracle SQL Server, MS Excel.

Contact this candidate