Sr.Tableau Developer

Name: Kishan

Email: ac8acu@r.postjobfree.com

Phone#: +1-310-***-****

Experience Summary

My main area of experience has been project delivery of various sizes as reporting lead in the different domains. Overall 9 years of experience in reporting side.

Tableau Developer, Tableau developing and testing analytic and operational Dashboards, Data Visualization. End –to-end experience in designing and deploying data visualization using Tableau having 6+ years’ experience.

TECHNICAL EXPERTISE

Tableau

Tableau 10.x/9.x/8.x/7.x

BI Reporting Tools:

SAP Business Objects 4.2/4.1/4.0/XIR3/R2

Qliksense

QlikSense 10.7.2

Tibco Spotfire

TIBCO Spotfire 7.11

Databases:

MS SQL Server, Tera data, Oracle 9i/10g/11g

Operating Systems:

Windows 98/XP/Vista, UNIX

Special Software

TDXchange, Service Now

Professional Details:

Areas/Applications

Manufacturing

-Delphi Automotive Systems

-Fiat Chrysler Automobiles(FCA)

Media and Entertainment

-Sony pictures Entertainment

Finance

- Custom Automation System

●Working as a Principal Consultant at Client Location (USA) from past 5+ years on extensive on-going implementation, administration and development of various complex Dashboards.

●Functional consultant with ability to define the scope of the business capabilities required to support a project using appropriate models and delivery vehicles. Design solutions that meet the needs of the business, consistent with overall architectural guidance.

●Experience of working in following stages of Software Development Life Cycle:

Requirement Analysis

Technical Design preparation

Application installation and configuration

Development

Unit testing, Integration testing

Production code deployment

●Experience to new version Enterprise suite of all kind of reporting tools as architect.

oExposure to working with complex interactive Dashboards in Tableau.

oGood knowledge in writing SQL queries

●Created customized and interactive dashboard using multiple data sources in Tableau.

●BuildingVisual Analytics, Advance Chart/Graph Types using complex calculations. Led Sears’s migration from Tableau 9.0 to Tableau 10.0 Self learning Tableau 2018.

●Authored Data Visualization Blog for Sears’s Information Analytics Team.

●Dashboards with Trends and Rate of Changes for members of Shop Your Way Program Optimized Tableau Workbooks for Targeted Interactions Analytics and Inventories.

●Improved performance of Operational Dashboards for Teradata-based Data Warehouse.

●Designed 30+ near-real-time monitoring Dashboards for Tableau Server.

●Optimized Data Extracts, Connections and data refreshes for corporate Tableau Server.

●Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

●Developing Tableau data visualization using Donut charts, Waterfall, Cross Map, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Dual axis, Triple axis, scorecards, dashboards using stack bars, scattered plots, Gantt charts and various other charts based on the business desired.

●Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

●Solid Experience in writing SQL queries, stored procedures, stored functions, packages, and database triggers, exception handlers, Cursors, PL/SQL records and tables.

●Created Interactive dashboards power points using Qlick sense.

●Created complex reports using multiple universes and created DESKI, WEBI and Crystal Reports.

●Documented procedures, architecture and defined standards for maintenance of the reports.

PROFESSIONAL EXPERIENCE:

Delphi – Detroit, MI Oct 2017 – Present

Sr. Tableau Developer

Tools Used: Tableau, MS SQL Server

Application: Spend Analytics

Client description:

Delphi Automotive PLC is a vehicle components manufacturer, a leading global supplier of electronics and technologies for automotive, commercial vehicle and other market segments in manufacturing industry. Delphi currently employs approximately 127000 people worldwide with annual sales of USD 17 Billion in F.Y ending Dec 2014.

Project description and Role of TCS:

Delphi is a leading global automotive vehicle components manufacturer providing electrical and electronic &power train, safety solutions to the global automotive and commercial vehicle markets, located in Michigan, USA.

My Responsibilities:

●Conceptualize technical solutions to complex problems and maximize benefit of IT systems by developing reports.

●Work closely with clients to gain organizational commitment for all systems and software plans, as well as evaluate and guide the selection of technologies required to complete those plans.

●Review and analyse business requirements, functional requirements and creating technical design document according to develop the reports.

●Analyse requirements, program and configure warehouses of database information. Review data mart/warehouse deliverables, and suggest and co-create standards and guidelines.

●Carry out detailed analysis to understand requirements and create code and/or build solutions as per requirements in development/maintenance projects in accordance with coding standards.

●Designing, developing, testing, and maintaining Tableau reports and dashboards based on user requirements.

●Working closely with business in creating dashboards based on the data from various Data sources.

●Utilizing Tableau server to publish and share the reports with the business users.

●Collaborated with the security team to develop various Tableau services.

●Prepare the deployment solutions for testing and live environments. Coordinate with client to test the solutions provided and gather the feedback for necessary development of the application. Presenting demos, POCs (Proof of Concept) to the prospect customers and providing them technical help.

●Provided UAT support for all bug fixes, new universe and reports as well as change requests.

●Understand the Requirements and Functionality of the application from specifications

●Involved in upgrading Tableau Versions.

●By using Tableau Server, providing row level securities to different users to access dashboards.

●Developing Tableau data visualization using Donut charts, Waterfall, Cross Map, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Dual axis, Triple axis, scorecards, dashboards using stack bars, scattered plots, Gantt charts and various other charts based on the business desired.

●Distributing Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

●Creating New Schedule's and checking the task's daily on the server

●Maintaining server activities, user activity, and customized views on Server Analysis.

●Extracting data from databases like SAS, DB2, SQL server and Excel files for getting data to Tableau for creating various dashboards.

●Creating Business requirement documents and plans for creating dashboards.

●Creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

●Expertise in understanding visual design principles like colour, layouts, and graphics.

●Providing customer support to Tableau users.

●Provide guidance to developers and team members on Tableau development, dashboard usability, user experience design and design best practices.

●Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.

Fiat Chrysler Automobiles (FCA) – Detroit, MI April 2016 to July 2017

Sr. Tableau Developer

Tools Used: Tableau, MS SQL Server

Application: Learning management system

FCA (Fiat Chrysler Automobiles): Automobile Manufacturing

Chrysler, officially FCA, is an American automobile manufacturer headquartered in Auburn Hills, Michigan and owned by Italian automaker Fiat. Chrysler is one of the "Big Three" American automobile manufacturers. It sells vehicles worldwide under its flagship Chrysler brand, as well as the Dodge, Jeep and Ram. Other major divisions include Mopar, its automotive parts and accessories division, and SRT, its performance automobile division. In 2014, FCA is the seventh biggest automaker in the world by production.

Responsibilities

Discussions with client and offshore team based on the System Requirements Document to cover the functionality, operational, technical issues and scope of work.

Worked as a Business analyst to gather the requirements.

Developing Tableau data visualization using Donut charts, Waterfall, Cross Map, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Dual axis, Triple axis, scorecards, dashboards using stack bars, scattered plots, Gantt charts and various other charts based on the business desired.

Utilizing Tableau server to publish and share the reports with the business users.

Collaborated with the security team to develop various Tableau services.

Involved in upgrading Tableau Versions.

By using Tableau Server, providing row level securities to different users to access dashboards.

Distributing Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Designed database model and created SQL Server database objects.

Created Business Requirements Document (BRD), Technical document and User Quick cards.

Developed and managed complex Web Intelligence reports from Infoview.

Helped to fix bugs and performance tuning on Desktop intelligence reports including Free Hand SQL queries.

Scheduled reports to user’s email address and folder locations.

Provided UAT support for all bug fixes, new universe and reports as well as change requests.

Providing training to end-user on webi-adhoc reporting.

Involved in gathering business requirements and designing functional Specifications for Tableau dashboards from Business users.

Worked with business in gathering requirements from the existing reporting tool (Business Objects).

Involved in preparing Functional Specifications, Technical Specifications, Testing Plans and other documentation as required by SDLC.

Geographical maps, Gantt charts using show me functionality.

Worked on analyzing the requirements and the sources data. Worked on mapping document to map the required columns from the data sources.

Sony Pictures Entertainment – LosAngeles, CA Oct 2015 to April 2016

Tableau Lead

Application: GOLD Reporting Mart

Tools Used: Tableau, MS SQL Server.

Project: GOLD Reporting Mart

The Global Order Library Data (GOLD) provides library management and media ordering for Worldwide Product Fulfilment (WPF). The Library Management module stores all the metadata identifying the vast majority of SPE elements and masters. It manages the inventory facilitating retrieval, movement, shipping, and storage of all elements and masters in SPE warehouses in Inwood and Glendale. The Media Ordering module is used to create orders for internal as well as external SPE customers (HE, airlines, domestic and international television stations, etc.

Responsibilities

Discussions with client and onsite team based on the System Requirements Document to cover the functionality, operational, technical issues and scope of work.

Designing, developing, testing, and maintaining Tableau reports and dashboards based on user requirements.

Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

Created dashboards for analyzing POS data using Tableau 8.0

Good experience in creating tableau worksheets and tableau dashboards.

Analysis and evaluation of alternatives to formulate the mode of implementation of the system.

Estimation of software development effort.

Development of software based on technical design.

Developed unit test cases and system test cases.

Performing unit and system testing based on test cases

Plan release and rollout.

Sony Pictures Entertainment – LosAngeles, CA Jun 2014 to Aug 2015

Tableau Report Lead

Application: INTERPLAN

Tools Used: Tableau, MS SQL Server.

Project

The International Theatrical Distribution and Marketing arm of the studio, Sony Pictures

Releasing International (SPRI) is responsible for the strategic sales, distribution plannin and marketing of films internationally. InterPlan is the Business objects reporting used and holds release information, estimate data, and box office tracking system used by SPRI.

Responsibilities

Discussions with client and onsite team based on the System Requirements Document to cover the functionality, operational, technical issues and scope of work.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Analysis and evaluation of alternatives to formulate the mode of implementation of the system.

Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

Experience with creating Worksheets and Dashboard.

Experience with Tableau for Data Acquisition and data visualizations.

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

Estimation of software development effort.

Creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Development of software based on technical design.

Developed unit test cases and system test cases.

Performing unit and system testing based on test cases

Plan release and rollout

Sony Pictures Entertainment – LosAngeles/Mumbai, Mar 2012 to April 2014

Tableau Report Developer

Application: Automated System for Ad

Tools Used: Tableau, SAP BO, MS SQL Server.

Project

ASAP reports is to distribute various publicity and marketing materials across the world. Orders will be received from the SPRI territory offices across the world and will be fulfilled as per the requests. Application was initially built for managing the SPE’s AdPub, Exhibitor Relations and WPF-NY CSS department’s business operations. AdPub and Exhibitor Relations are the SPE’s marketing departments which interact with SPRI Territory offices and receive the request for promotional items in preparation for a Title release. Consolidated order requests will be sent to WPF-NY for fulfillment. WPF-NY CSS team is responsible for receiving the inventory and shipping it to the SPRI Territory offices as per the order requests.

Responsibilities

Discussions with client and onsite team based on the System Requirements Document to cover the functionality, operational, technical issues and scope of work.

Analysis and evaluation of alternatives to formulate the mode of implementation of the system.

Good experience in creating tableau worksheets and tableau dashboards.

Designing, developing, testing, and maintaining Tableau reports

Estimation of software development effort.

Development of software based on technical design.

Developed unit test cases and system test cases.

Performing unit and system testing based on test cases

Plan release and rollout

Sony Pictures Entertainment – Mumbai, Feb 2011 to Dec 2011

MFT Support Lead

Languages Unix Shell Scripting, SQL

Project

SPE has initiated this project to use MFT tool to allow only secure

Files transaction inside and outside of SPE and decided to opt for

MFT tool which allows managed file transfer only by secure SFTP

Protocol. Implement MFT, SPE has acquired the licenses of a web-

Based GUI Tool known as ‘TDXChange’ developed by B-Trade

Organization.

Responsibilities

Provide Technical Support for the TDXchange Tool.

Coordinate with Business for Change Management Approvals.

Coordinate with Vendor for Credential management and technical issues.

Coordinated with Business Users to Clarify Requirement which includes documented Questionnaire

Prepared Business & Application Navigation flow document, OPD for interfaces and Maintained issues in Issue Tracker

Managed passwords, SSL certificate renewals for accounts. Also monitored file loads.

Coordinated with Business to secure their approval for timing of changes, testing coordination, remediation if required.

Represented in Information Technology Change Control for change Approvals.

Coordinated with Users/Business for Issue escalation related to different file transfers in and out of Sony Pictures Entertainment.

Helios and Matheson information technology Ltd

HLI- Mumbai, July 2010 to Jan 2011

BI Report Lead

Tools Used: SAP BO, Tableau, MS SQL Server.

Project

The Hartford Financial Services Group, Inc. is one of the largest insurance and investment companies and leading provider of life insurance, group and employee benefits, automobile and homeowners insurance and business insurance - as well as investment products main corporate office is located in the United States, with offices in the United States, Japan, the United Kingdom, Canada, Brazil and Ireland.

Responsibilities

Responsible for sap Universe and Reports.

Created Webi Reports.

Used Clear case tool for moving Universe and Crystal reports from local to server.

Created charts to display summary of the data.

Involved in preparation of Plan for Universes and Standard Reports.

Performing regular back-ups and Universe maintenance activities.

Fabian Solutions PVT Ltd

CUSTOMS AUTOMATION SYSTEMS - Mumbai, Dec 2008 to Jun 2010

BI Report Developer

Project

Custom Automation System custom automation system provides information of Ministry of Finance Customs affairs. This site has different users with different logins. Main goal of the project is to Import and Export of goods. When exporting the goods and importing the goods many things happen in between like inspecting the details of the product by various roles (Supervisor, Inspectors etc..) with a particular Declaration Number. Inspection Process from different stations Known as Custom point. http://www.cas.gov.bh/ecas_prod/aspxfiles/Login.aspx

From this site user can login an access the Customs Data.

.

Responsibilities

Involved with the Project Lead for gathering requirements and analysis.

Performed unit testing, system testing and user acceptances test (UAT) .

Deploying the reports in the BO XI Central Management Console(CMC)

Responsible for sap Universe and Reports.

Created Webi Reports.

Used Clear case tool for moving Universe and Crystal reports from local to server.

Created charts to display summary of the data.

Involved in preparation of Plan for Universes and Standard Reports.

Performing regular back-ups and Universe maintenance activities.

Contact this candidate