PROFESSIONAL SUMMARY:

• 8+ Years of experience working with Business Intelligence, Data visualization tools with specialization on Tableau 7.0/8.0/9.0/10, 10.2
• As Tableau Developer, Responsible for creating wonderful visualizations to help clients to take their decisions.
• Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
• Experience in working with Financial, Healthcare and Retail Clients
• Have been working with various data sources such as Oracle PL/SQL, SQL Server, ODBC and Flat file sources.
• Extensive experience in Business and Data Analysis along with 5 years of data visualization using Tableau Desktop.
• Involved in claim adjudication process of FACETS application.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Proficient in writing complex SQL queries, scripts & automating the data pulling from multiple sources by creating Alteryx ETL workflows
• Tableau tools include Tableau Desktop versions and recent implementation of 8.2, Tableau Server, Tableau Public, and Tableau Reader.
• Experienced on working with EDI 437.
• Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 8.0 to Tableau 8.1
• Extensive Knowledge of Tableau Server Concepts like tabcmd, tabadmin, creating users, sites and projects.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Worked on generating various dashboards in Tableau server using various sources such as Teradata
• Good in writing T - SQL, working on SSIS, SSRS, Data Migration.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, calculations and Relationships.
• Used Teradata utilities (SQL, B-TEQ, Fast Load, Multi Load, Fast Export, T pump, Visual Explain, Query man)
• Having knowledge on gather business requirements and translate them into reporting needs.
• Recommending Dashboards per Tableau visualization features and delivering reports to Business team on timely manner.
• Used Alteryx for Data Blending and Analytics.
• Designed and Developed matrix, tabular, parametric and Sub Reports in the SQL Server Reporting Services (SSRS) 2012.
• Successfully upgraded Tableau platforms in clustered environment and performed content
• Established Best Practices for Enterprise Tableau Environment and application intake and Development processes.
• Designing, Developing and supporting interactive Tableau Dashboard reports.
• Experience in Marks, Publisher, Security concepts, creating Worksheets and Dashboard using Tableau.
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
• Knowledge of Data warehouse Concepts and methodologies.
• Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.
• Generated the OLAP cubes, and extracted the related reports through SSRS
• Performed Extract, Transform and Load operations from the databases using SSIS. Also, created the merge, lookup and send mail tasks.
• Created triggers, stored procedures and complex queries.
• Significant experience in developing practical and effective data visualizations.
• Detail-oriented problem solver, quick learner, and flexible team player
• Excellent skills in communication & collaboration, interest & ability to learn new technologies in short time

TECHNICAL SKILLS:

Reporting Tools: Tableau 10/9.x/8.x/7.x/, SSRS, Crystal Reports, Business Objects

Databases: SQL Server, DB2, Oracle, Netezza, Teradata

ETL Tools: SSIS, SSAS, Informatica 7.x/8.x

Internet Tools: HTML, DHTML, XML,VB Script, Java Script, JSP, ASP

Languages: SQL, PL/SQL, C/C++, C#, Java, Shell Scripting

Operating Systems: MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP/Vista, AIX 5.1\5.3, Sun Solaris 2.7\2.8, Linux

Testing Tools: Quick Test Professional QTP, Win runner, Load Runner

PROFESSIONAL EXPERIENCE:

Confidential, Golden, CO

SQL BI Developer (Tableau)

Responsibilities:

• Assisted in complete Life Cycle including Design, Development and Testing.
• Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided
• Deployed the generated reports onto the Tableau server.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Heated Maps, Pie Charts and Bar Charts and Density Chart.
• Managed and created and altered Databases, Tables, Views, Indexes, Constraints with business rules using T-SQL
• Worked On HIPPA data of Medical assistance and Food Assistance and Created Tableau Reports from the data to predict statistics of the day to year and month to year Budgets of the department.
• Created Parameterized reports, Cross-Tab reports, Drill down reports and summary reports by using SSRS.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Developed SSIS packages using Control and Data Flow to process all excel files within folder, Execute SQL task to insert extract sheets data into the SQL Table
• Created Tableau Worksheets and Dashboards based on prioritized KPIs and data sources.
• Designing dashboards with the use of visualization tools like Tableau, Using SQL for managing large volume of data.
• Performed Job Scheduling Using SQL SERVER Agent
• Created and Configured Dimensions, Attributes and Hierarchies
• Designed and Developed KPIs, Aggregations and Cube Partitions.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS .
• Developed SQL queries or stored procedures used by reports to retrieve information from relational database and data warehouse.
• Developed complex Stored Procedures, Triggers, User Defined Functions based on the requirement

Environment: Tableau Server 10.1/10.3, Oracle SQL Developer, SQL server, Oracle 11g, java 1.5 platform, Teradata, Microsoft office 2007, Business objects, SQL, PL/SQL, T-SQL.

Confidential, Richmond, VA

SQL BI Developer (Tableau)

Responsibilities:

• Assisted in complete Life Cycle including Design, Development and Testing.
• Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided
• Deployed the generated reports onto the report server.
• Formatted the reports using the Global variables and expressions.
• Deep experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Worked with SSIS Packages on SQL Server 2012 and SSIS packages on SQL Server 2008 for the automation of day to day Maintenance Jobs.
• Involved in license management SLA’s with Tableau support.
• Extensively used Alteryx for giving Data analysis and BI software with SQL Server .
• Wrote SQL code with multiple joins to pull the data from multiple Oracle Database. Optimized and automated the query in Alteryx
• Defined and created procedures to install Tableau desktop in silent mode.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multi Load, Fast Export, T pump, Visual Explain, Query man) and Teradata parallel support.
• Worked with Tableau and Alteryx Schedulers and workflows to provide end-to-end automation.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created Parameterized reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRS using SQL Server.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Developed Tableau Data Extracts for dashboards by creating ETL workflows in from multiple data sources and customized data
• Defined best practices for Tableau report development.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Designed and Developed matrix, tabular, parametric and Sub Reports in the SQL Server Reporting Services 2012.
• Worked with SSIS Packages on SQL Server 2012 and SSIS packages on SQL Server 2008 for the automation of day to day Maintenance Jobs.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while maintaining the accuracy of the core information content that is being communicated
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing ad-Hoc Reporting.
• Managed and created and altered Databases, Tables, Views, Indexes, Constraints with business rules using T-SQL
• Developed complex Stored Procedures, Triggers, User Defined Functions based on the requirement

Environment: Tableau Server 7.0, Oracle SQL Developer, SQL server, HPQC, Oracle 11g, java 1.5 platform, Teradata, Microsoft office 2007, Business objects, SQL, PL/SQL, T-SQL.

Confidential, Golden Valley, MN

Tableau developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical &, functional specifications.
• Analyzed various reports, dashboards, scorecards in Micro Strategy and created the same using Tableau desktop server.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.
• Developed Sales Analysis Dashboards to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Involved in new KPI generation for Scorecards.
• Data Manipulation using Oracle, SQL and automated creation of Tableau Data Extract by creating ETL workflow using Alteryx.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, quick filters, actions, hierarchies’ features in Tableau.
• Executed and tested required queries and reports before publishing.
• Converted Metric insight reports to tableau reports.
• Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled frequency and time to refresh data for the data sources are publishes ori extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in IPad, IPhones, and other smart mobile phones.

Environment: Tableau 9, Desktop, Alteryx, Tableau server, Oracle 11i,PL/SQL, SQL*Plus, TOAD, Windows 2003/ XP, UNIX.

Confidential, Waukegan, IL

Tableau Developer

Responsibilities:

• Designed automated scripts in PL/ SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Exposed to data conversion from different data sources to SQL Server 2012 using SSIS.
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2012.
• Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS),
• Developed Trend Analysis reports for the Sales Delivery group based on the sales of their pharmaceutical products.
• Had to integrate the Medicare (Part A, Part B, Part C, and Part D) data all in one single system for a smooth flow through the claims processing system Facets 4.71.
• Interacted professionally with diverse group of professionals in the organization including managers and executives.
• Process claims for Medicaid
• Experienced in standardizing Tableau for shared service deployment.
• Developed Standard Operating Procedures ( SOP ) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Building, publishing customized interactive reports and dashboards, report scheduling using
• Tableau server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPIs.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and
• Design process for various Sources and Targets.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Environment: Tableau Server 7.0, Oracle SQL Developer, SQL Assistant, Oracle 11g, java 1.5 platform, Teradata, Microsoft office 2007, Business objects, SQL, PL/SQL, T-SQL.

Confidential

SQL Server Developer

Responsibilities:

• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes)
• Analyzed the requirements and selected the appropriate fact tables/created fact tables
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
• Configured SSRS 2005 for directly deploying the report in SharePoint 2007.
• Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence

Environment: SQL Server 2005 Enterprise Edition, Enterprise manager, Crystal Reports, Erwin MS, PowerPoint, MS Project.