Data Sql Server

Shobha Phone: 678-***-****

Tableau Developer/Business Intelligence Analyst Mail ID: *************@*****.***

EXPERIENCE SUMMARY:

Over 7+ years of professional experience in client requirement Analysis, Resource Planning, Coding, Debugging, Testing, Deployment and creation of dashboard using Tableau Desktop and Server.

Have 3 years of experience on working on Tableau 8.0 to 9.1, Tableau Desktop, Tableau Server.

Extensive experience in Business/Data Analysis and Tableau Desktop and Server development.

Used state of the art technologies and methods we delivered high impact business intelligence solutions, data warehousing solutions and Tableau dashboards and data visualizations.

Excellent technical and analytical skills with ER modeling for OLTP and dimension modeling for OLAP.

Expertise in determining end user needs, converting highly Business oriented information into clear, concise technical dashboards, which allows for effective business development.

Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.

Good understanding of Tableau Desktop and Server architecture for designing and developing dashboards.

Organizes multiple large datasets into Tableau worksheets to be easily navigable to the non-Tableau user.

In-depth knowledge on Tableau Desktop, Reader, Public and Tableau Server.

Skilled in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, scatter plots and pie charts and also use multiple measures for comparison such as Individual Axes, Blended Axes, and Dual Axes.

Working experience in integrating and processing data across multiple platforms (AIX, UNIX and Windows) and database technologies (Netezza, DB2, ISAS, Oracle, SQL Server, MySQL)

Excellent knowledge of operation support ITIL process like incident, change and problem management.

Perform and document data analysis, data validation, data mapping/design, by accessing multiple sources, specifically data residing in data warehouses and build the most ideal Tableau dashboards.

Experience in creating Actions, aggregates, sets, Joins, bins, hierarchies, sorting, grouping and table calculations.

Creating offline, online maps and also create custom geo coding in Tableau Dashboards.

Experience in creating, filters, quick filters, data source filters, global filters and context filters.

Technical Skills:

Reporting tools

Tableau (Desktop/Server, Public/Reader), Qlikview, IBM Cognos, SSRS, SSIS(SQL server integration & Reporting services), Business Objects

Methodologies

Agile Modeling, SDLC model, Waterfall model, Spiral model, Use Cases

Others

Quick Test Professional, Quality Center, Load Runner

Programming

C, C++, XML, HTML, Java/J2EE, Visual Basic, SQL, PL/SQL

Databases

Teradata, Oracle 10g/9i/8i/8.0/7.0, Sybase 12.x/11.x, MS Access 7.0/2000, Erwin 3.5/3.x, SQL, XML, PL/SQL, SQL*Plus and Developer 2000, SAPHANA and Netezza

Office Suite

MS Excel, MS Word, MS Visio, MS Power Point and MS Access

Data modeling Tools

Power Designer, Erwin, ER Studio, MS Visio, Informatica

Professional Experience

Client: Kantar Health, New York Nov 2014 – present

Tableau Developer

Responsibilities:

Involved in reviewing business requirements and analyzing data sources from Excel, Oracle, Teradata and SQL Server for design, development, testing, and production rollover of reporting and analysis project within Tableau Desktop.

Involved in extraction, transformation and loading of data directly from different source systems (flat files/Excel/Oracle).

Involved in creating interactive dashboard and applied Actions (filter, highlight and URL) to dashboard.

Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau.

Created dashboards by extracting data from different sources using parameters and calculations.

Involved in creating Tree Map, Heat Map, calculated fields, mapping and hierarchies.

Involved in generating dual-axis bar chart, Pie chart and Bubble chart with multiple measures and data blending in case of merging different sources.

Performed Tableau type conversion functions when connected to relational data sources.

Developed dashboard reports on the Tableau Server so that the end users having access to the server can view the data.

Developed dashboard report using data extracted from Netezza data structure.

Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Played an important role in coordination with the entire team and managing the time estimates for the entire project.

Environment: Tableau Desktop 8.0,9.0, Tableau server, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007 Windows 2007, Java, SAS, Teradata, Microsoft office 2007 and Netezza data base.

Client: American Arbitration Association, New York June 2013 – Sep 2014

Data Analyst/Tableau Developer

Responsibilities:

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

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

Connected Tableau server with share-point portal and setup auto refresh feature.

Created visualization for logistics calculation and department spend analysis.

Generate KPI for customer satisfaction survey results and disease management.

Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.

Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.

Used SQL Loader to load data from flat files received from various facilities every day.

Created and modified various UNIX shell scripts according to the changing needs of the project.

Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

Environment : Windows 7 and Linux, Tableau, tableau server, MS-Excel, SQL Server, SharePoint, Microsoft office, Jdeveloper, SQL-PLUS, C++, Visual Basic.

Sami Labs limited, India Apr2012 to Feb 2013

Tableau/ETL Business Intelligence Developer

Responsibilities:

•Involved in creating interactive dashboard and applied Actions (filter, highlight and URL) to dashboard.

•Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. Involved in creating Tree Map, Heat maps and background maps.

•Worked extensively on Ref Cursor, External Tables and Collections.

•Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

•Created and modified several database objects such as Tables, Views, Indexes, Constraints, Stored procedures, Packages,

•Developed effective and interactive Dashboards using Parameters and Actions.

•Involved in generating dual-axis bar chart, Pie chart and Bubble chart with multiple measures and data blending in case of merging different sources.

•Played an important role in coordination with the entire team and managing the time estimates for the entire project.

•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.

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

Environment: Tableau Desktop 8.0, 8.1,8.2, Tableau server, Oracle SQL developer, SQL Server 2008, Oracle 10g, PL/SQL, T-SQL, MS Access, Windows 2007 server, Teradata, MS Office 2007

Sami Labs Limited

Software engineer/Business Analyst May 2007 to Mar 2012

Responsibilities:

•Develop relationship with internal operating groups and external customers

•Prepared Test plans and Test specifications based on Functional Requirement Specifications and System Design Specifications.

•Developed test scripts to test the functionality of the applications and scenarios for the regression testing using QTP.

•Conducted walkthrough meetings with team members to review the test strategy.

•Developed Test cases based on the technical specifications and business requirements.

•Wrote complex SQL statements with different kinds of join conditions

•Executed SQL queries on back-end data base (oracle) for Data Validation

•Effectively working with Business Analysts and Product Managers to meet deliverable deadlines for various projects

•Conducting Regular meeting with the Team over project related information sharing and suggestions in improving the team's productivity

•Reporting End of the Day Report to the Project Managers

•Test Preparation Phase – Analyzing the requirements, Test case Creation, Test Scripts upload and Peer Test Case Review.

Education:

Master’s Degree, University of Mysore

Contact this candidate