Candidates About

 

Kashif Hassan

Sr. Tableau Developer/ Visualization Expert

____________________________________________________________________________

 

PROFESSIONAL SUMMARY

Ø  8+ years of experience in Data Analysis, Data Visualization, Business Analysis, System Analysis & Design, Development, testing and implementation of projects using Tableau, Business Objects, SSRS, Informatica, SAP Analytics Cloud, Teradata, Oracle, SQL Server etc. in Retail, Telecommunication, Financial, Banking, Healthcare and Manufacture industry.

Ø  Expertise in BI/Data Warehousing concepts, designs, and project implementations.

Ø  Proficient in Tableau 6.x/7.x/8.x/9.x/10.x product suite (Desktop, Server/Tableau Online).

Ø  Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.

Ø  Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.

Ø  Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.

Ø  Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.

Ø  Experienced in preparing Business Process Re-engineering Models.

Ø  Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.

Ø  Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Ø  Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.

Ø  Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.

Ø  Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.

Ø  Proficient in designing the Design Documents for loading data into Data Warehouse and Data Mart tables.

Ø  Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.

Ø  Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources.

Ø  Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.

Ø  Experienced in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.

Ø  Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.

Ø  Extensive experience working with Offshore Team.

Ø  Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership capabilities to develop creative solution for challenging requirement of client. Willing to relocate: Anywhere.

 

EDUCATION

MBA in Marketing                                                                                                    

University of Houston-  2001

 

 

TECHNICAL SKILLS

 

Analytical Tools: Tableau Desktop/Server, Xcelsius, Dashboard designer, SAP Analyics Cloud

     Reporting Tools: Webi, SSRS, Crystal report.

     ETL Tools:  Informatica, SSIS

Requirements Management: (Microsoft Word, PowerPoint, Excel)

SQL Tools:  Query Analyzer, SSMS, SQL Developer, Toad, SQL Assistant, SQL plus,TFS Methodologies: Kimball/Inmon, OLAP, OLTP, Waterfall, Agile

Databases & Related Technologies: SQL Server 2014/2012/2008, Oracle10g/11g/12g, MS Access, DB2, Teradata, HANA, Big DATA (Hadoop), MS excel, MS Share point, JIRA, Version One

Operating Systems Windows: (Windows, UNIX, LINUX).

Languages: Python, Java, T-SQL, SQL, PL/SQL, Stored Procedure, Custom SQL, ANSI 89/92.

Industries: Finance/Banking, Healthcare, Manufacture, Retail, Telecommunication

 

 

 

WORK EXPERIENCE

 

Capital One - Richmond, VA                                                                March 2014 to Present

Senior Tableau Developer

 

Responsibilities:

Ø  Experience with the design and development of Tableau visualization solutions.

Ø  Worked in developing strategy and technical specifications for implementing                reporting portal / semantic layer in conjunction with data layer.

Ø  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.

Ø  Creating data blending in case of merging two different datasets.

Ø  The ability to interact professionally with a diverse group including executives, managers.

Ø  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.

Ø  Find efficient ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

Ø  Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.

Ø  Proof-read all documents and maintain accuracy of information and preparing SOP.

Ø  Responsible for Developing a Dashboard and preparing ad-Hock Reporting.

Ø  Working knowledge on Tableau Server / Administration.

Ø  Developed complex SQL scripts database for creating BI layer on DW for tableau reporting.

Ø  Identify new metrics and enhance the existing KPI's.

Ø  Dashboard Visualization through Tableau BI application.

Ø  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, filters, actions, Hierarchies feature in tableau.

Ø  Defined best practices for Tableau report development.

Ø  Administered user, user groups, and scheduled instances for reports in Tableau.

Ø  Executed and tested required queries and reports before publishing.

Ø  Converted metric insight reports to tableau reports.

Ø  Working extensively with Tableau Business Intelligence tool to develop various dashboards.

Ø  Working extensively using Excel to validate the data and use as the source data files.

Ø  Analyzing the data using Statistical features in Tableau to develop trend analysis.

Ø  Used Python Scripts to perform advanced statistical calculations like (STD deviation, Percentile, AverageIf and AverageA).

Ø  Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Ø  Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Ø  Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.

Ø  Design and development of various reports and dashboards that can be easily accessible through Tableau App in I pads, iPhones, and other smart mobile phones.

 

Environment: Tableau Desktop, Tableau server / Administrator, Oracle 10/11g, Microsoft Excel, MS Access, Microsoft office MS SQL SERVER 2008, Python, Informatica , SSRS, SQL Profiler, Windows XP / NT / 2000/2003, Microsoft Access.

 

AT&T - Dallas, TX                                                                    February 2013 to March 2014

Sr Tableau Consultant

 

Responsibilities:

Ø  Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Ø  Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Ø  Effectively used data blending feature in tableau.

Ø  Defined best practices for Tableau report development.

Ø  Administered user, user groups, and scheduled instances for reports in Tableau.

Ø  Executed and tested required queries and reports before publishing.

Ø  Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.

Ø  Created advanced calculations using Py Scripts.

Ø  Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

Ø  Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.

Ø  Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.

Ø  Provided support for Tableau developed objects and understand tool administration.

Ø  Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

Ø  Created Custom Hierarchies to meet the Business requirement in Tableau.

Ø  Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.

Ø  Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0

Ø  Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT) for AP Reporting.

Ø  Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.

Ø  Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.

Ø  Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.

Ø  Responsible for developing provisioning reports for various groups and upper management.

Ø  Created Complex Dashboard, Reports using WEBI having multiple metrics and trends and created Hyperlinks for each of the Metric to open a detail report using Open Documents

Ø  Experience on writing SQL Queries.

Ø  Experience on BW Analyzer & Query Designer.

Ø  Strong verbal and written communication skills, ability to work effectively with user departments.

Ø  Worked towards the goals of quality, time and budget.

 

Environment: Tableau Desktop 8.1, Business Objects, Webi, Python, Tableau server / Administrator, SQL server 2008/2012.

 

Canon - Melville, NY                                                           November 2012 to January 2013

Tableau Developer/ Data Analyst

 

Responsibilities:

Ø  Defined data source and data source views for each report as per client requirement.

Ø  Involved in creating dashboards and reports in Tableau 7.0.

Ø  Created report schedules on Tableau server.

Ø  Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 6.1 to Tableau 7.0.

Ø  Worked as technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.

Ø  Created and assisted users in Tableau dashboard development.

Ø  Administered and provided production support for Stakeholders Enterprise wide Tableau application consisting of multiple key functional business domains.

Ø  Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Ø  Defined and created procedures to install Tableau desktop in silent mode.

Ø  Defined best prac1tices for Tableau report development.

Ø  Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Ø  Provided 24/7 production support for Tableau users.

Ø  Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

 

Environment: Tableau Server 7.0, Tableau Desktop 7.0, MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005, MS SQL Server Analysis Services 2005, .NET Framework 3.5, MS SQL Profiler.

 

Analogic Corporation - Peabody, MA                                          July 2010 to October 2012

Tableau Developer

 

Responsibilities:

Ø  Designed Visual Reports and interactive Dashboards in Tableau for Patients Behavior.

Ø   Created Data Connections, published on Tableau Server for usage with Operational / Monitoring Dashboards.

Ø  Administered user, user groups, and scheduled instances for reports in Tableau.

Ø  Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1

Ø  Resolved various performance issues and analyzed the best process distribution for different projects.

Ø  Created and assisted users in Tableau dashboard development

Ø  Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.

Ø  Worked on several complex visualizations that all had to do with improving the programs offered to various Healthcare services in MA.

Ø  Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.

Ø  Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Ø  Developed business process and technical design documentation for each reporting service developed in this project.

Ø  Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services.

Ø  Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.

Ø  Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.

Ø  Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.

Ø  Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.

Ø  Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi team environment.

Ø  Optimized queries by looking at Execution Plan for better tuning of the database.

Ø  Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

 

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS) /DBA, Oracle 11g, Toad, MS Office.

 

 

Costco - Kirkland, WA                                                                   January 2009 to June 2010

BI Consultant

 

Responsibilities:

Ø  Gathered User requirements and reviewed them from a technical perspective and conducted meetings with end users to establish business rules, schedule deliverables and identify potential issues that could impact the development effort.

Ø  Participated in installation and configuration of tableau server and desktop.

Ø  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.

Ø  Working on generating various dashboards in Tableau server using various sources such as Teradata.

Ø  Find ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated

Ø  Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.

Ø  Proof-read all documents and maintain accuracy of information and preparing SOP.

Ø  Responsible for Developing a Dashboard and preparing ad-Hock Reporting.

Ø  Actively written batch scripts as part of deploying and running Cognos10 Power Cubes on UNIX prod box.

Ø  Created scorecard reports and dashboard using Dashboard designer.

Ø  Developed ad-hoc reports, drill through reports and created master detail relationship to burst a crosstab report using Report Studio.

Ø  Designed model using power play transformer and created multiple cube views.

Ø  Deployed the packages and reports from Dev to QA and QA to production environments

Ø  Documentation of the report results and updated daily with the testing results.

Ø  Participated in the testing of the developed reports and reported the defects.

 

Environment: Tableau Desktop 6.2, 7.0, 8.0 Tableau server / Administrator, tabcmd, SQL developer, Cognos 8.4 (Report studio, Query Studio, Analysis Studio), Powerplay Transformer, Oracle, TOAD, Windows, Sun SOLARIS.