Tableau, Alteryx, SQL, Hadoop Systems

Nithya Ramachandran

**********@*****.*** 732-***-****

SUMMARY

Over 5 years of diversified IT experience in Analysis, Design, and Development in the fields of Business Intelligence, Databases and Web-based Applications.

3 years of experience in Data Visualization development using Tableau to create complex, intuitive dashboards.

Excellent team player with very good communication skills and problem solving abilities.

One year of Data Preparation experience with Alteryx

Well acquainted with SDLC process and it’s various aspects like functionality, performance and integration.

Worked extensively with Advance Analytics, Actions Filters, Calculations, LOD, Blending, Parameters, Background images, Maps, Trend Lines, Statistics, and Dual Axes.

Groups, hierarchies and Sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.

Improved Reports performance in tableau using extracts and user filters.

Implemented security at the Data (Data security) and object (Roles and Permissions) level

Experience in Publishing Tableau Workbooks to Tableau Server and assiging User Access

ISTQB Foundation Level certified

Microsoft certified professional – developing windows based application in Visual studio .Net

Experience in ORACLE 10g and MS SQL Server (2005, 2008, 2012)with good programming knowledge in PL/SQL.

Knowledge of SAP Business Objects and Power BI.

Conversant in writing complex SQL queries and Stored Procedures

Experience in design and development of web applications using .Net 2.0.

Proficient in all phases of the systems development life cycle, including requirements Definition, Data Conversion, System Implementation, System Testing and Acceptance.

Proven ability to deliver and ensure success in high-pressure/high-risk situations.

Experience in documenting the testing process using MS-Office tools including MS-Word, MS-Excel.

Excellent rapport with developers, testers in all the projects and worked in close collaboration with team members to ensure enhancement of software quality

SKILLS

Business Intelligence Tools

Tableau 8.2,9, 9.2,10.1,10.3

Data preparation/ETL

Alteryx 11

Databases

Operating Systems

MS SQL Server (2005, 2008, 2012), Oracle 10g

Windows

Languages

C#, PL/SQL,XML, HTML, ASP.Net, VB.Net.

Other Tools

Toad, MS Office, MS Visual Studio 2008, MS Visio

JOB PROFILE

Currently employed with Wipro Technologies

Project Roles (in reverse chronological order)

A Global Pharma Giant, July 2017 – Till date

Role: Tableau and Alteryx Developer

Project: Supplier Diversity Reporting

Description:

This project was for the procurement department to analyze and report supplier diversity goals and achievements. It has a series of dashboards that play an important role in tracking supplier diversity goals and to identify gaps where there are short falls. The dashboard covers Spend Analysis, Supplier analysis, diversity demographics and benchmark analysis. Data sources were Impala and SQL Server. Alteryx was used for Data Preparation and Tableau for Visualization and Reporting.

Responsibilities:

Interacting with multiple business teams to collect the requirements and arrive at data and reporting specs

Coordinating with data team to source data

Processed the spend and goals data in Alteryx in such a way that it is suitable for reporting

Gathered and loaded data into tableau from various sources( SQL Server, Impala and excel files)

Created Executive dashboards depicting spend vs target data using different features like LOD’s, calculated fields, action filters etc.

Dealt with data volumes ranging from 30 to 40 million records

Generating adhoc reports for the business needs

Adhoc data cleansing and standardization using Alteryx

Unit testing and data validation

Publishing the dashboard and walkthrough with business users

Environment:Tableau 10.1, MS SQL Server 2012, Alteryx 11.

A Global Pharma Giant, Mar 2017 – July 2017

Role: Tableau and Alteryx Developer

Project: Global procurement spend reporting

Description:

This project was designed to report global procurement spend and its compliance across sector, region and category. The dashboard was intended to provide high level summary of spend data and behavorial metrics across different dimensions. Data sources were SQL Server and Excel files.

Data was processed in Alteryx to create tde for reporting.

Responsibilities:

Designed wire frames and prototype

Data analysis and reverse engineering of data model

Data preparation with Alteryx

Development of dashboards in Tableau

Testing and Data Validation

Publishing Dashboard and walkthrough with business users

Environment:Tableau 10.1, MS SQL Server 2012, Alteryx 11.

An US based Auto and Home Insurance Company, Apr 2014 – Dec 2015

Role: Tableau and SQL Developer

Project: Claims Analytics Factory

Description:

The claims analytics factory was a group within the company's IT division to churn out analytical reports and operational reports. Tableau was used for Analytics. Some of the workbooks developed involved claim analysis on region-state-county-demographics, Claims denial analysis based on denial reason/code and profitability analysis on insurance products. Data source was MS SQL Server.

Responsibilities:

Created Tableau dashboards as part of the Analytics/Reporting factory

Used advanced graphs like Box-Whisker plots, Histograms and Tree Maps.

Implemented Mapping features in Tableau for Region Anaysis of claims

Used Tableau URL Actions to navigate from the main Dashboard to detail Reports

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

Worked on Joins and Blending to access data from Multiple Data Sets

Publishing customized interactive reports and dashboards

Assisted in Requirements Analysis by creating prototypes in Tableau

Created custom SQL queries and prepared Tableau specific tables/views in MS SQL Server

Create test plans and reports. Provided UAT support

Created handover documents for the admin and support team

Environment:Tableau 9.2, MS SQL Server 2012, PL/SQL.

A Global Publishing and Education Company, Jan 2013 – Feb 2014

Role: Tableau Developer

Project: Commercial Excellence Reporting

Description:

The project was a series of reports and dashboards for the Sales Department to analyze their Commerical Excellence goals. Some of the dashboards that were developed were Demand Analytics, LoB-Product Profitablity Analysis, Competitor Analysis, Rights Analysis, etc. These dashboards were developed in Tableau and the data for these dashboards were sourced from a Reporting Data Mart in Oracle 10G. The RDM in turn had data fed from Sales Force and EDW. Competitor data was obtained through data streams.

Responsibilities:

Involved in Exploring, Designing, Building, Testing and Deployment of theDashboards for Marketing Decision makers and Sales Analysis for critical metrics.

Involved in understanding the reporting requirements and providing Tableau reporting solutions.

Created Prototypes in Tableau for concurrence on requirement scoping and sign off.

Used multiple charts like Bullet Charts, Scatter Plots and Gantt Charts

Used Tableau features like LOD, Action Filters and URL Actions

Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.

Presented to higher management the discovered trends and analysis, forecast data, recommendations and gaps identified.

Coordinated and conducted business, system requirements analysis meetings with business and technology partners, business analysts and DBA’s.

Analyzed the Business requirements and translated them into Application and operational requirements.

Performed PL/SQL validation queries by cross testing the resulting data from the reports.

Implemented Security Features of Tableau like row level, object level and report level to make the data secure.

Analyzed complex data from various data repositories.

Blended data from multiple databases into one dashboard by selecting primary database from RDM and third party data in CSV files.

Performed unit testing, system testing and user acceptances test (UAT) for reports and security management.

Provided support to minimize data quality risks and proactively identify potential data issues.

Trained end users through online and in-class sessions.

Resolved end user reporting problems through collaboration with IT, during UAT and Warranty Support.

Environment:Tableau 8.2 & 9, Oracle 10g, PL/SQL.

A global Oil and Gas Company, Mar 2006 – Feb 2007

Role:Dot net developer

Project: Comparison test tool – Business Process Reporting Tool

Description: This application is used to compare the Customer invoice data from the new Olympic System (TO-BE) with the existing production Customer (AS-IS) in order to find out the discrepancies in the data. It has various modules like Sales Invoices, Purchase Invoices, Real estate, Sales and Purchase Excise Duty.

Responsibilities:

Worked with onsite team and business users to gather and analyze requirements for customer report generation in .NET.

Involved in design and development of web applications with .NET.

Involved in the presentation logic for GUI of ASP.Net Web pages

Written Stored Procedures using SQL Server 2005.

Created Pl/Sql logic for the web application for data entry & extraction.

Generated various SQL queries to be used in the extraction of data.

Created database tables, constraints, triggers, packages, procedures & functions.

Performed tuning of SQL queries using Explain Plan and created indexes on tables to improve the efficiency of the queries.

Collaborated with technical team members to integrate back-end and front-end elements.

Created Unit and System testing plans as part of the design.

Provided user support during the SIT and UAT phases for bug fixing and minor enhancements.

Environment: Win 2K, IIS 6.0, ASP.NET 2.0, ADO.NET 2.0, VB.NET 2.0, MS SQL Server 2005 and Visual Source Safe 6.0

A Global Oil and Gas Company, June 2005 – Jan 2006

Role:Dot net developer

Project: Well work request – Online data processing application

Description: This application is an online application form for Chevron Engineers to evaluate feasibility before taking up work on an oil well. When adequate data is entered and presented, the application would do a feasibility study and present the result

Responsibilities:

Involved in the complete life cycle of the project.

Involved in gathering the requirements and maintain the required documentation.

Used to analyze the requirements and involved in design and development.

Involved in creating tables, stored procedures using SQL Server 2005

Developed classes and interfaces for the data access layer using VB.Net, ADO.Net and SQL 2005 data access library.

Configures Web.Config file for the configuration of the web application.

Designed and Developed Reports.

Performed Unit and Integration testing.

Environment: Win 2K, IIS 6.0, ASP.NET 2.0, ADO.NET 2.0, VB.NET 2.0, MS SQL Server 2005 and Visual Source Safe 6.0

EDUCATION

Bachelor of Engineering in Electronics and communication, Anna University, India

Contact this candidate