SUMMARY:

• Around 7+ years of experience in IT industry as a Tableau Developer, Data Analyst, with extensive knowledge in functional and technical domain of Business Intelligence, ETL tools, creating reports, dashboards through Tableau, identifying trends and processing mapping with strong background in Databases and Data Warehousing concepts.
• Extensive experience working with Tableau Desktop, Tableau Server and Tableau Reader in various versions.
• 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.
• Worked in Data Analytics and we designed, developed and we used to a maintain the various data for ease of use
• Utilized Tableau to produce appealing data visualizations to clients and to help them make business decisions with the help of Ad hoc reporting and Dashboards.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
• Involved in full life cycle implementation of data warehouse projects.
• Our team have ability to understand the data and we make our business process design and development for maintain
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources and Tableau servers for maintaining DB schemas
• Well versed in the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS including tools like BCP utility, DTS and SSIS 2014/2012 Packages with the proper control flow and data flow elements by using MS SQL Server 2014/2012/2008 R2/2008.
• Hands on experience in designing complex spreadsheets in Excel and maintaining.
• Very good experience in Oracle database application development using Oracle 12c/11g/10g/9i/8i/x, SQL, PL/SQL,SQL*Loader. Strong experience in writing SQL, PL/SQL-Stored Procedures, Functions and Triggers.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Excellent understanding of relational database concepts and dimensional modeling techniques, Star and Snow-flake schema.
• Good skills in designing and maintain defect reporting and validating defect fixes
• Experience in creating complex SQL queries from scratch, and tuning existing SQL queries for better performance.
• Building user acceptance and monitor test plans, test scenarios, test processes and schedules, and prior testin and training
• Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances.
• Experience in gathering requirements, analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Good Working Knowledge in Agile Project management (Scrum process).

TECHNICAL SKILLS:

BI Tools: Tableau Desktop 9.x/8.x, Tableau Server 9.x/8.x, Tableau Reader, Tableau Public.

ETL Tools: Informatica, SSIS, SSAS, SSRS

RDBMS: Oracle, SQL Server, Teradata, MS Access

Scripting Languages: SQL, HTML, CSS, JAVA

Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin

Operating Systems: Windows 7/XP, Windows Server UNIX/Linux

WORK EXPERIENCE:

Confidential, Cincinnati, OH

Tableau Developer

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Server, Tableau Desktop, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX, LINUX

Confidential, SFO, CA

Tableau Developer

Responsibilities:

• Involved in creating interactive dashboards and applied actions (filter, highlight and URL) to dashboard.
• Worked on generating various dashboards in Tableau Server using different data sources. Used Data Blending to merge data from different sources.
• Created multiple dashboards with Drill Down capabilities using dashboard prompts, Local and Global Filters.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Involved in administering user, user groups and schedule instances for Tableau reports.
• Maintaining Tableau reports & analysis and work on enhancements to existing reports or creating new reports based on business needs.
• Created Stored-procedures in T-SQL for commonly used Query tasks for better efficiency.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Worked on Query Optimization using SQL Query Optimizer, SQL Server Extended Events, SQL Profiler, Set Session Options and temporary tables.
• Extensive practice in extracting, transforming and loading data from OLTP (Transactional) Databases and other data sources into Data Warehouses for further Business Intelligence Analysis using SQL Server
• Worked extensively on Data Migration by using SSIS. Used different transformations lookup, condition split, row count Transformation, Derived Column, Data Conversion and Union All.
• Configured Logging providers to containers and tasks to capture run-time information for troubleshooting of SSIS.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Designed and Deployed UNIX Shell Scripts.

Environment: Tableau desktop, SSRS, SSIS, SQL Server 2008/2005, Linux, JIRA, Tidal Enterprise Scheduler.

Confidential, New York, NY

Tableau Developer

Responsibilities:

• Implemented 60+ minor enhancements in the period covering customer management, recoveries, fulfillment management, customer acquisitions, rewards, high yield accounts, money market accounts.
• Interacted with business to collect and understand Requirements.
• Translated the business needs into system requirements by communicating with the business on nontechnical level and with the System Analyst on technical level.
• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
• Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL packages in SSIS.
• Created Data Definitions and help maintain Metadata repository.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and SSRS.
• Involved in creating stored procedures, views, and custom SQL queries to import data from SQL server to tableau / SSRS.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.

Environment: Tableau (Desktop/ Server), MS SQL Server 2008, Excel, SQL, PL-SQL, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS), MS Office, Visual Studio 2010.

Confidential, Columbus, OH

SQL BI Developer

Responsibilities:

• Created reports using Tableau functionality's like Queries, Drill Down, Prompts Functions to meet the requirements using SQL Server
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports
• Installation, maintenance and administration of Tableau Servers
• Experience in Marks, Publisher and Security
• Experience with creating Worksheets And Dashboard
• Working with Multiple data Connections
• Experience with troubleshooting
• Experience in tableau created Rapid Analytics and Reporting
• Experience with Tableau for Data Acquisition and data visualizations for client and customers.
• Using Multiple Measures like Individual Axes, Blended Axes, Dual Axes
• Expertise in Tableau Analysis
• Experience in BI interactive Dashboards and Tableau Publisher

Environment: Tableau Desktop, Tableau server, SQL Server 2008R2, Informatica 8, SQL

Confidential

SQL Developer

Responsibilities:

• Implemented ETL process to load the Data Warehouse and developed repositories (Microsoft SQL Server)
• Participated in stakeholder and project review meetings on weekly basis.
• Responsible for testing process of extracting, transforming, and loading data from oracle, flat files and placing it into data warehouse.
• Designed and documented the test cases for ensuring quality of data and performed thorough validation.
• Created dashboards and reports using Micro Strategy for managers which involved corporate wide data related to environmental factors
• Performed dimensional modeling to help prioritize different business processes
• Developed several scripts and SQL queries to create various reports for administration
• Developed Micro Strategy reporting tutorial for employees to help them create their own customized report

Environment: Informatica Power Center 6.x/7.1, BO 6.5, Microsoft Visio, Oracle 9i.