SUMMARY

• I am a Tableau Developer/ Data Analyst with experience in financial, Banking and healthcare domain, having expertise in analysis, design, development and implementation of Data warehouses, data marts using Tableau, ETL Tool (SSIS) and RDBMS like Oracle 10g/11g, MS SQL server 2014/16and MySQL database.
• Have experience in working with Agile environment using JIRA, Rally etc.
• Imported data from multiple source like SQL Server 2016, Excel, Oracle 11g. into tableau.
• Have experience in creating dashboards, reports and ad - hoc reports through Tableau.
• Extensive experience in Metrics analysis, Reporting, Pivot tables, Charts, Graphs using (KPI) Key Performance Indicator
• Have experience in creating operational Tableau dashboard, monitoring Tableau server performance and user activities
• Have experience in tableau using multiple measures like individual Axes, Blended Axes, and Dual Axes for creating worksheet and dashboards.
• Experience in working with huge volume of data
• Hands on building groups, hierarchies, sets to create detail level summary reports and dashboards using KPI’s.
• Extensive experience in tableau parameters, heat maps, tree maps, table calculations, histograms, waterfalls, trend lines, geographic maps etc.
• Strong ability to write SQL/TSQL queries, data analysis, Data profiling and SQL techniques for loading large amount of data
• Excellent analytical skills for understanding the business requirements, business rules, business process and detailed design of the application
• Strong experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Tableau.
• Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Tableau.
• Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts. Data visualizations and interactive dashboard which helped business users.
• Have experience in designing superb visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Worked on data blending and increased the dashboard performance by extracting data.
• Hands on experience on writing complex queries, creating tables, joining etc.
• Experienced working with Excel Pivot, VLOOKUP’s, report design for various business scenarios.
• Experience in interacting with clients, understanding Business Applications, Business Data Flow and Data Relations.
• Good knowledge of Tableau, performed POC for one of the use case.
• Excellent analytical communication and interpersonal skills and proficient in technical writing and presentation and a good team player.

TECHNICAL SKILLS

Reporting tools: Tableau 8.x/9.x/10.2, Tableau 2.7

Database: MS SQL Server 2012/2016, Teradata 15, MySQL 5.2, Oracle 11g

Methodologies: Agile and Waterfall

Languages: C, C++, Core JAVA, SQL, TSQL

MS Office: Word, Excel and Pivot, Visio, Power Point, Outlook

Others: Teradata SQL Assistant, SQL Plus, SQL Developer, MS Access, Rally, JIRA, GIT

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer

Responsibilities:

• Involved in gathering analyzing and documenting business requirements functional requirements and data specifications.
• Understanding the data warehouse Tables and wrote SQL queries joining multiple tables.
• Worked with data modeler to understand data model from different source system and prepared source to target data mapping document.
• Experience in designing and development of Tableau visualization solutions and Created Business Requirement documents and plans for creating dashboards.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Read data from different source like ORACLE, SQL Server CSV, Excel through Tableau.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Worked with different types visualizations like Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts Waterfall and funnel charts, Gauges and single-number cards, Z-order, Visual hierarchies and drill-down in the tableau reports.
• Developed custom SQL queries to minimize the data to improve the performance in Tableau.
• Utilized advanced features of Tableau software like link data from different data sources together on one dashboard to filter data in multiple views.
• 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.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Used Excel sheet for multiple purposes such as data analysis, data comparison, reporting, data mapping etc.
• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.

Environment: Tableau 10.2,Tableau Server,Oracle 12c, MS SQL server 16, SQL Developer, MS-Office suite (Word, Excel, Project and Outlook), Microsoft Share Point, JIRA

Confidential

Tableau developer

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and data modeler for designing the database as per project requirement.
• Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.
• Prepared Data mapping document with Data transformation logic between sources to target.
• Responsible for developing dashboards and preparing ad-hoc reporting in tableau.
• Generated context filters and data source filters while handling large volume of data. Scheduled data extract on a daily basis created various views in Tableau (Tree maps, Heat Maps, Scatter plot). created Filters, quick filters, table calculations, calculated measures and parameters.
• Published workbooks by creating user filters so that only the appropriate team can view it.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Wrote SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Involved in Publishing dashboards to Tableau Server.
• Interaction with Client manager / team members on weekly basis.

Environment: MS SQL Server 2012, SSIS, SSRS, Microsoft Performance Point Server 2010, T-SQL, Citrix, ServiceNow, Microsoft Office, Erwin 7.3

Confidential

Tableau Developer

Responsibilities:

• Use recognized business analysis methodologies to elicit requirements from business users as the foundation for developing solutions to the organization’s business needs
• Documented the software requirement specifications and ensured the timely sign-off
• Played a pivotal role in managing and rolling out process wide software testing framework
• Successfully managed the end-to-end software development life cycle and delivered several key projects
• Worked as a liaison between multiple cross-functional teams and external-internal stakeholders
• Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the business needs.
• Discussed with team to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Participated in building and visualizing dashboards using Tableau Desktop 9.0
• Used Tableau to generate Tableau combination dashboards and wrote SQL Queries for testing the Tableau report/dashboard.
• Implemented Extract filters, Calculation Filters, Context filters, Data source filters to exclude certain values or a range of values as well as batter performance.
• Created story using sequence of worksheets to convey information using Tableau.
• In Tableau dashboards used different bars and charts like stack bars, bar graphs, scattered plots, Gantt charts.
• Blended data from multiple sources into one report by selecting primary keys from each database for data validation.
• Have done advance analysis, through field calculation, table calculation as well as also involved in forecast analysis.
• Used different functions like number, string, date, Type conversions, aggregate functions.
• Created performance recording to improve Tableau’s performance.
• Effectively used data blending feature in Tableau desktop 9.0.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Written complex SQL queries to read data from source databases like Teradata and SQL Server 2014.
• Modified existing Unix shell script to automate the process.

Environment: Tableau 9.3, Microsoft Office Suite, Microsoft Visio, UNIX, Documentum, SQL Server 2012, PostgreSQL, oracle 10g, SQL