CAREER SUMMARY:

• 6+ years of IT Experience as a Tableau Developer/Data Analystin Data Warehousing and Business Intelligence Projects.
• Good understanding of Tableau Desktop architecture for designing and developing dashboards.
• Created dashboards by connecting to various data sources such as Amazon Redshift, Athena, Snowflake, CDH, Teradata, SQL Server and Excel.
• Experience in installation, Configuration and administration of Tableau Server in multi - server and multi-tier environment.
• Extensive TableauExperience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Created solution driven dashboards by developing different chart types including Crosstabs,Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Expertise in development of Tableau visualizations which includes preparing dashboards using various reporting objects such as facts, attributes, transformations, filters, prompts, calculated fields, parameters, groups, sets and hierarchies.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Worked extensively on joining tables, multiple data connections using data blending, worked on Data Extracts and managing queries.
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources
• Experience in Administering user, user groups, and scheduled instances for reports in Tableau .
• Experience working with Big Data technologies such as H ive, S qoop, AWS EMR, AWS S3, CDH.
• Extensive experience in MSBI stacks like SSRS, SSIS, SSAS.
• Experience in designing and implementing ETL environments using ETL strategies as well as tools like SSIS.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Good knowledge of Relational database and Data Modeling concepts and possess extensive experience in development of T-SQL, PL/SQL, Functions, Stored Procedures, Triggers and ActiveX Scripts.
• Experience with Erwin logical/physical DB diagrams design, reverse engineering, reports.
• Responsible for writing SQL Queries, Dynamic queries, sub queries and complex joins for generating complex Stored Procedures, Triggers, User defined Functions, Views and Cursors.
• Proficiency in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.
• Experienced in tuning long running SQL queries for better performance.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

TECHNICAL QUALIFICATIONS:

Data Visualization Tools: Tableau, DOMO, Informatica, Crystal Reporting, SQL Server Reporting Services, Business Objects.

Big Data: Hive, Sqoop, AWS EMR, AWS S3, CDH

ETL Tools: Tableau Prep, Alteryx, Informatica, SSIS

Database Tools: Teradata SQL Assistant, SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio.

Databases: Teradata, MS SQL Server, MS Access, Oracle, MySQL, PostgreSQL

Languages: T-SQL, PL-SQL, C

Web Technologies: HTML, XML

Operating Systems: Windows, UNIX, Linux, Mac OS

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio, MS Access), ERWIN

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Tableau Developer

Environment: Tableau Desktop 10.3, 10.5, Tableau Server, Hive, Sqoop, AWS EMR, AWS S3, CDH, Athena, Snowflake, Redshift, HTML, Metric Insights

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Created multiple dashboards in Agile environment, that were first published in Pre-Prod server for initial review, suggestions and further data analysis, and then published to the Prod Server.
• Involved in performance tuning, rearchitecting and developing new features for Scoreboard dashboard, which is used by all the store managers. Made significant improvements that led to better load times and made it more user-friendly.
• Connect to different data sources such as Amazon Redshift, Athena, Snowflake, CDH and Excel and build dashboards using data blending, cross database joins, parameters, calculated fields, LOD expressions, and action filters.
• Written SQL queries to validate the data displayed on the dashboards.
• Used HTML, JavaScript to embed the dashboards and Ad-hoc data sources into Nike Analytics portal.
• Created Mobile dashboards that are used by store and territory managers across the US.
• Involved in various POCs conducted as part of improving the overall performance of the dashboards across DTC Analytics.
• Used Active Directory to implement row level security that would allow the store managers to view only their stores’ data.
• Involved in QA by writing SQL queries and validating the data, and then documenting those test cases.
• Enhanced the look and feel of dashboards by using URL actions, action filters, and custom formatting.

Confidential, Indianapolis, IN

Tableau Developer

Environment: Tableau Desktop 10.0, 10.1, Tableau Server, Teradata, Teradata SQL Assistant, TABCMD, HTML, Batch Scripting, Business Objects, ServiceNow

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, and Testing of various Reporting and Analysis Projects.
• Connected to different data sources such as Teradata,Amazon Redshift, SQL Server, Excel to gather the required data.
• Created various complex workbooks by connecting to multiple data sources using data blending.
• Created Text tables, side-by-side bars, Scatter Plots, Treemaps, Stacked Bars, Heat Maps, Filled Maps, and Symbol Maps per deliverable specifications.
• Created Excel files using various formulas and used it in dashboards when a dedicated table was not available in DW for that specific information, as it is easy to update for frequent changing data.
• Consistently attended meetings with different teams inside the organization to acquire functional business requirements to build SQL queries that would be used in dashboards, to satisfy the teams' needs.
• Worked with multiple teams such as ETL/BI, Strategy and Business Development, Ad Operations, and Sales and Marketing inside the organization to create Tableau workbooks per their needs.
• Converted existing Business Objects reports into Tableau dashboards and embed views to SharePoint.
• Created dashboards using various filters, groups, bins, sets, hierarchies, reference lines, trend lines, forecast, parameters, level of detail (LOD) calculations, and other complex calculated fields.
• Created batch scripts and used tabcmd to automate the process of generating various month end reports as PDFs and sending them out to the partners' email addresses.
• Involved in publishing of dashboards to Tableau server, scheduling extract refresh and subscriptions.
• Worked with the Business Objects Designer in preparing Universes from the warehouse database.
• Created and maintained Business Objects Web Intelligence reports.
• Used ServiceNow to solve several incidents such as helping users with any issues with the existing dashboards, data related questions, providing access, etc.
• Trained users on using various Tableau related products and provide 24/7 support whenever needed.

Confidential, San Jose, CA

Tableau Developer/Administrator

Environment: Tableau Desktop 9.1/9.2/9.3, Tableau Server 9.1/9.2/9.3, OBIEE 11g, Axure, Alteryx, Toad, DB2, Oracle SQL Server, Teradata, MS Access, SQL Server 2008 R2, TABADMIN, TABCMD, APIs, CSV files, Apache 2.2, Share point, TDE Files

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Created views in Tableau Desktop in Agile environment, that were published to internal team for review and further data analysis and customization using filters and actions.
• Created dashboards by extracting data from different sources and created dashboard using parameters, sets, groups and calculations in Tableau Desktop.
• Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.
• Created calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
• Gathered Business Requirements, interacted with Strategic Development Team, Business analyst to analyze business needs and developed technical specifications.
• Installed, Configured and setup Tableau environment in the organization.
• Develop, organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Worked with Teradata database and extracted data using Alteryx and developed POCs by building reports and dashboards using Tableau 9.2 to demonstrate quick wins.
• Incorporating weekly changes of the data source files by integration into Tableau data sources for timely leadership reporting.
• Creating reports and infrastructure to show migration activities by monthly release, business functions and IT projects.
• Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard.
• Worked on converting map shape files to tableau readable CSV format using R software
• Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool.
• Participated and coordinated daily stand-ups with clients on daily design and development effort.
• Extensively used LOD expressions for cohort analysis and aggregation.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis. Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Generated the test plans specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope. Prepared test scripts and documented user training modules.
• Maintained Test log and created Test Evaluations, Summary Reports.
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Provided Ongoing support to BI applications running in production & troubleshoot any issues.

Confidential, Omaha, NE

Tableau Developer/Administrator

Environment: Tableau Desktop, Tableau server/Administrator, Oracle, OBIEE, PostgreSQL, Microsoft Excel, MS Access, Microsoft office.

Responsibilities:

• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Provided direction, expertise, feedback, and coaching to build the capability of Off-shore project team and other onsite coordinators.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Experience with the design and development of Tableau visualization solutions.
• Performed ETL packages to extract data from OLTP data sources such as Excel, Access, Text files and Oracle, SQL Server using SSIS.
• Designed, developed, deployed and supported ETL to load data into Data Warehouse from PostgreSQL Server.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Involved in supporting existing ETL processes, based on SSIS and Informatica Data Integration Tool.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Generate KPI for customer satisfaction survey results and disease management.
• Utilized the JavaScript API to create a customized portal for the insurance group.
• Maintained Test log and wrote Test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Installed Tableau Server in Dev, QA, UAT and Prod environments.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extracting data from different sources connecting them and used the same to create dashboard
• 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, calculated fields, groups, sets and hierarchies in Tableau.
• Designed the Conceptual and Physical Data Models, as well as the major components of the user Created and assisted users in Tableau dashboard development.