Chandra Sandhadi Email:

acn811@r.postjobfree.com

Tableau Developer Mobile:

309-***-****

SUMMARY

. Qualified professional has 10 years of extensive IT Experience in Data

Warehousing and Business Intelligence applications in Financial,

Health Care and Automobile industries.

. Proficient in Tableau 6.x/7.x/8.x (Desktop, Server), Micro Strategy

9.x/8.x (Desktop, Intelligence Server, Narrowcast Server) and SSRS.

. Proficient in design and development of various dashboards, reports

utilizing Tableau Visualizations like bar graphs, scatter plots, pie-

charts, geographic visualization and other making use of actions,

other local and global filters according to the end user requirement.

. Expertise in designing and creating various analytical reports and

Dashboards to help users to identify critical KPIs and facilitate

strategic planning in the organization.

. Experience in creating and implementing interactive charts, graphs,

and other user interface elements.

. Proficient in developing Entity-Relationship diagrams, Star/Snow Flake

Schema Designs, and Expert in modeling Transactional Databases and

Data Warehouse.

. Outstanding Data analysis skills including Data mapping from source to

target database schemas, Data Cleansing and processing, writing data

extract scripts/programming of data conversion and researching complex

data problems.

. Expertise in Teradata 13.10, Oracle, SQL Server, Informatica, SSIS,

SSRS, SSAS, Microsoft Office Suite.

. Proficient Star Schema dimensional modeling, which includes

understanding business processes, modeling dimensions, hierarchies and

facts.

. Posses' strong knowledge of database management in writing complex SQL

queries, Stored procedures, database tuning, query optimization and

resolving key performance issues.

. Coordinated Technical Reviews, developed System requirements.

Developed test requirements, test plans, scripts, test conditions and

test data. Supported status reporting and test execution for Unit

testing, Integration testing, System testing, Regression testing, and

User Acceptance Testing (UAT).

. Adept in analyzing bugs, interacting with team members in fixing

errors and UAT and also assisted in Post-Production support.

. Strong influence management skills, reporting and analytical/problem

solving skills with attention to detail.

. Strong understanding of project life cycle and SDLC methodologies

including RUP, RAD, Waterfall and Agile.

. Highly motivated team player with excellent Interpersonal and Customer

Relational Skills, Proven Communication, Organizational, Analytical,

Presentation Skills, and Leadership Qualities

TECHNICAL SKILLS

BI Tools Tableau 7.x/8.x, Trillium Discovery

ETL Tools Informatica, Data Stage, Talend, Microsoft SQL

Server Integrated Services(SSIS)

Requirements Management Requisite Pro, Microsoft Office (Word,

PowerPoint Excel)

Front End Tools Microsoft Project, Microsoft Office, Visible

Analyst

Databases Oracle 9i, MySQL, DB2 9.0

Document management Visual Source Safe 6.0, Share point, Ultra Edit,

Documentum

Defect management tool HP Quality center 10.0

Programming Languages C, C++, COBOL, DB2, JCL, SQL, PL/SQL 2.X.

Data modeling Power Designer, ERwin, ER Studio, MS Visio

Education:

. Bachelors in Computer Applications from Osmania University,

Hyderabad, India.

. Masters in Business Administration from Osmania University,

Hyderabad, India.

PROFESSIONAL EXPERIENCE

TMS Dec-2012 to July-2014

Tableau Developer

Toyota Motor Sales, U.S.A., Inc. (TMS) is the North American Toyota sales,

marketing, and distribution subsidiary

devoted to the U.S. market. TMS oversees sales in 50 states of

Toyota, Lexus, and Scion products through a network of over 1,200 Toyota

dealers (of whom more than 900 also sell Scion vehicles) and over 200 Lexus

dealers. TMS develops Toyota's television campaigns and other nationwide

marketing materials, and supervises dealer marketing to ensure that dealers

present a uniform image. The project is to implement reporting solutions on

to response data of various campaigns and create database layers, the views

of which can be used as data sources in Tableau report development.

Responsibilities:

. Gathered Business Requirements, Interacted with the Users, Project

Manager and SMEs to get a better understanding of the Business

Processes.

. Worked with DBAs to design and implement Conceptual data model,

Physical Data Model, SSIS mappings and workflows to meet business

requirements.

. Responsible for creating ETL mapping documents to define data flow

from source system to target database.

. Worked with Source system Subject Matter Expert (SME) to ensure that

the extracts are properly mapped..

. Worked on the backend SSAS cube development which was the source data

for the tableau.

. Identified Facts, Dimensions, Levels / Hierarchies of Dimensional

Modeling.

. Develop, Organize, manage and maintain graphs, tables and document

templates for the efficient creation of reports.

. Prepared dashboards using calculated fields, parameters, calculations,

groups, sets and hierarchies in Tableau.

. Created sheet selector to accommodate multiple chart types like Panel

charts, Bullet charts and Stack bars etc. In a single dashboard by

using parameters.

. Using Multiple Measures like Individual Axes, Blended Axes, and Dual

Axes..

. Extensively used calculated fields 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.

. Created visualizations for logistics calculations and departmental

spend analysis. Utilized sample data to create dashboard while ETL

team were cleaning data from source systems, and was responsible for

replacing the connection to Google Big-query later.

. Used Sql Queries at the custom Sql level to pull the data in tableau

desktop and validated the results in Tableau by running Sql queries in

Sql developer and Google Big-Query.

. Attended daily standup meetings to update scrum master with what is

achieved, what is being done and is there any impediment.

. Conducted user acceptance testing and mentored business users how to

slice and dice data using filters and parameters.

. Created and maintained issue log where business users enter their

feedback by working on dashboard in test environment. Implemented the

feedback and incorporated the necessary changes.

. Published the developed dashboards into production and ensured the

data was up to date by scheduling extract refreshes, performed

performance tuning of the dashboard and created tableau functional

design document.

. Participated in the retrospective meetings and next sprint planning

meetings.

. Involved in Onsite & Offshore coordination to ensure the completeness

of Deliverables.

Environment: Tableau desktop 8.1/8.2, tableau server 8.1/8.2, OBIEE 11g,

Microsoft SQl Server,Google Big-Query, SSIS,SSAS, Salesforce, Talend.

Franklin Templeton Investments. (Aug 2011 to Dec-2012)

Tableau Developer/Business System Analyst

Project: Migration Project

Franklin Templeton Investments is one of the world's largest asset

management groups which has presence across the globe. Management Dashboard

is an application which is useful for quick view of the Business unit

performance across the globe. It gives the complete and clear data

visualization of the sales reports and the market share reports in the

particular markets.

Responsibilities

. Served as Business Systems Analyst 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.

. Extensively used Visio to create Use Cases Diagrams, Activity

Diagrams.

. Developing and maintaining high level overview of the project and

design flows using MS Visio.

. Worked on Business Intelligence standardization to create database

layers with user friendly views in Teradata that can be used for

development of various Tableau reports/ dashboards.

. Analyzed dimensional and fact tables in a campaign data mart that

details Inclusion, exclusion and Segmentation criteria, Offer

assignment and campaign response by campaign.

. Creating and modifying Business Intelligence analytical reports using

Tableau.

. Used geographic view which clearly gives the performance of a

particular state.

. Developed customized calculations when required.

. Worked on drill through reports by creating HTML references.

. Migrated all the reports, dashboards, scorecards from Tableau 7.0 to

Tableau 8.0 after testing the version on Sand Box.

. Created various actions in database like filter actions to send

information to other tableau worksheets and to connect the same in

analytical flows, URL actions to connect views of data to external

resources and Highlight action to provide rich visual interaction

between the views on the sheet.

. Designed business intelligence dashboard using Tableau Desktop and

publishing the same on Tableau server, allowing executive management

to view current and past performance sales trends at various

geographic locations.

. Actively involved in testing new/upgraded features like new

Visualizations, Forecasting, Data Blending, Parallelized Dashboard,

Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.

. Worked on Performance tuning of report with huge queries using

concurrent query execution for better performance of report.

. Responsible for daily communications to management and internal

organizations regarding status of all assigned projects and tasks.

. Use MS Excel, Word, Access, and Power Point to process data, create

reports, analyze metrics, implement verification procedures, and

fulfill client requests for information.

. 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 7.0/8.0, Teradata 13.10, Teradata SQL Assistant,

Teradata Administrator, SQL, Share Point, Agile-Scrum, Informatica, Autosys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

State Farm Insurance (April-2009 to Aug-2012)

Project: Data Assessment / Profiling

Data Analyst - Insurance

Overview: State Farm was creating a customer friendly application where the

customer can choose the insurance options based on his / her preferences

and also to capture the customer information one time which will be updated

in all lines of business. In order to create the application, the data has

to be assessed and moved to a platform that will be linked to the new

application. By understanding what will be displayed to customers,

appropriate action can be taken in order to ensure we have the cleanest

data possible, to maintain customer confidence.

Responsibilities:

. Data Profiling and Assessment on DB2 Relational database and IMS

hierarchal database across different LOB's in insurance

domain.

. Identify which data elements with the SME (Subject Matter Expert) to

be assessed and loaded into Trillium Discovery (13.5), TS Discovery

14.0 before analyzing the data.

. Create business rules in Trillium, Micro strategy to find the

incorrect data and compare with source allowed values

. Identify the anomalies and follow up with the SMEs to find if it is an

unexpected result or an anomaly and Prepare the data rules spreadsheet

using MS Excel that will be used to update allowed values, findings

and profiling results

. Document data assessment findings and prepare identified anomaly sheet

for internal conversion process and Share the results with

Stakeholders and data assessment core team

. Provided recommendations to clean up the source data, Application /

System modification, perform further research if needed before the

final data transformation Conversion team.

. Suggestions to fix the anomalies during conversion stage or DB

Validation and Prepare Test Cases for Conversion Purposes

. Assist in creating transformation rules with the Business Subject

Matter Experts (SMEs) and involve in the process to create data

mapping requirements for Population / Synchronization (ETL) and DB

Validation.

Environment: Trillium Discovery, PL/SQL, Control-D, Lotus Notes, Micro

Focus Rumba, MS Office, Windows 7, Share Point

Wells Fargo India Solutions (January 2006 to April 2009)

Project Name : Testing

Environment : Mainframe

Role : Team member

Responsibilities:

. Performance testing of the jobs that are imported from SunGard to

Wells Fargo.

. Interface testing (IST) for the files that are sent across various

applications from and to HELMS.

. Region setup for IST testing.

. BCP testing involving the region set up for BCP.

. Analysis of the process involved in HELMS application

. Test plan preparation for the tests involved for IST and BCP testing

. Execution of the jobs in IST region

. Interface testing to see various applications are impacted only in the

right way after HELMS migration.

. Execution of test cases in HPQC.

. Defect tracking on CDTS and monitor to closure

. Onsite interaction for issue tracking and status updates.

Brief description of the project:

HELMS Insourcing project is an initiative to in-house the application

HELMS (Higher

Education Loan Management system) from SunGard, a third party vendor to

Wells Fargo. HELMS is a student loan processing application in credit areas

of Wells Fargo. HELMS handles the loan payment, amortization, repayment

schedules.

FAS91 tables of HELMS holds the amortization amounts for each loan. HELMS

processes the amounts that needs to be populated into the FAS91 tables.

This involved calculations of various new amount fields, generation of

files and send it across interfaces.

Technical Environment: Application Lifecycle Management Version11 (ALM),

JCL, VSAM's, ISPF

Aetna PBC Members (August-2004 to December-2005)

Project : Application Development and Maintenance

(Enhancement Project)

Environment : Mainframe

Role : Team member

Responsibilities:

. As a team member, involved in the activities of Analysis, Design,

Development, Unit & integration testing, Implementation and extended

support to Post-Implementation.

. Played a key role in coordinating the activities, understanding the

existing business requirement and translating them into design

specifications.

. Handled Production Support for Members application everyday by fixing

jobs within the SLA times.

. Coordinated with onsite in resolving critical production issues.

. Handled knowledge sharing session and guidance sessions for trainees

in the project.

. As a key team member, involved in Development, Testing and Baseline

Production Support activities in member application.

. Worked as a key person on member's project and worked in ABEND

analysis, and provided the best solution to fix the High

occurrence ABEND.

. Understanding the business requirements of the End User.

. High level design using MS Visio

. Specification (Low Level Design )Creation for new Requirement and

Enhancement

. Worked in Coding new programs in COBOL, DB2, VSAM.

. Involved in Unit testing, System testing, Regression testing

. Worked on QMF report Creation for SQL testing

Brief description of the project:

Aetna-PBC Members used to Process the Member Information on

Daily basis. If some new member applied for and Aetna Insurance, their

information are Processed through Validation and verification .The Members

information can be enter manually in the online screen,and also can be

updated. Only the Daily batch processing, millions and millions of records

will be processed and executed .It has online and batch applications. The

online part consists of non-interactive systems that validate the data on

received member information. The interactive system is used for member

processors to manually correct errors on member records. The batch

application is used to do periodic activities such as backing up data,

archiving old data and purging duplicate tables.

The project involves maintaining the current system and enhancing it with

features that would increase the efficiency of the entire workflow system.

It also involves providing support by resolving issues and show stoppers as

when they happen.

Technical Environment: COBOL-II, JCL, MVS, DB2, VSAM File Aid, TSO/ISPF,

SPUFI, EXPEDITOR, QMF

Contact this candidate