PROFESSIONAL SUMMARY:

• 7+ Years experience working with Business Intelligence, Data visualization tools with specialization on Tableau 7.0/8.0/9.0/10
• 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).
• 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.
• 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 in Python & 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.
• 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.
• 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, Richmond, VA

Tableau Developer

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.
• Involved in license management SLA’s with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Worked with SSIS Packages on SQL Server 2012 and SSIS packages on SQL Server 2008 for the automation of day to day Maintenance Jobs
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• 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.
• 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
• Developed Tableau Data Extracts for dashboards by creating ETL workflows in Alteryx 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.
• Strong hands on experience using Teradata utilities (SQL, Fast Load, MultiLoad, Fast Export, T pump, Visual Explain, Query man) and Teradata parallel support.
• Created Parameterized reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRS using SQL Server.
• 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.
• 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.
• 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 7/8.2 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 and maintained graphs, tables, slides and document templates for the efficient creation of reports.
• Interacted professionally with diverse group of professionals in the organization including managers and executives.
• 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.