Tableau Developer
Resume:
Chandra Sandhadi Email:
************@*****.**.**
Tableau Developer Mobile:
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