Candidates About

 

Khizer Qureshi

Sr. Tableau Developer/ Visualization Expert

Professional Summary  

• Tableau Developer with over 9 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms in Financial/ Banking, Sales/Marketing, Healthcare, Education, Manufacturing/Retail and Pharmaceutical domains

·         Expert in data visualization using Tableau Desktop/Server/online 10.x/9.x/8.x/7.x, Alteryx, and Business Objects Dashboard designer to create complex, intuitive, and innovative dashboards.

·         Administered users, groups, and scheduled extracts and instances for reports in Tableau Server.

·         Expert in Trouble shooting, Performance tuning the reports and resolving the issues within the Tableau server and dashboards.

·         Experience in maintenance of Tableau Server, installing patches and upgrades in Tableau Server.

·         Collaborated with Business users to understand user requirements, layout, and look and feel of the dashboards to be developed and created proof of concept / prototype the same using Tableau desktop.

·         Worked closely with stakeholders to create Business Requirement Documents (BRDs) and Functional Requirement Documents (FRD) for users.

·         Involved in major SDLC phases and Agile Methodology for end to end BI Application development involving Requirements Gathering, Design, Development, User Acceptance Testing, Production Deployment, Sprint based development and JIRA tracking.

·         Assisted users in creating and modifying worksheets and data visualization dashboards.

·         Created incremental refreshes for data sources on Tableau server.

·         Experience in Developing Visualizations and Dashboards from multiple data sources using Data Blending and Cross Joins.

·         Experience in Tableau and Database optimization.

·         Proficient in creating Calculations and formatting using Tableau Desktop.

·         Proficient in design and development of various worksheets and data visualization dashboards, reports utilizing Tableau Visualizations like Bars, Lines and Pies, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.

·         Extensively worked on development of Web Intelligence, Desktop Intelligence Reports, Crystal reports, Xcelsius and Dashboard Designer.

·         Provided user interface(UI) design for Web-based projects, including dashboards, widgets, and products.

·         Conducted and performed analytical studies of data content and interactions with existing data.

·         Database experience in Oracle 12g/10g, My SQL, MS Access, MS-SQL Server 2014/2012/2008, Teradata, DB2, Netezza, PostgreSQL.

·         Proficient in performance analysis, monitoring and SQL query tuning in Oracle and SQL server.

·         Worked on Data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files using Informatica Power Center.

·         Excellent communication, interpersonal and analytical skills with ability to manage and work effectively.

·         Experience leading onshore and offshore teams.

Education

Bachelors in Computer Science CUNY (Queens College) 2006

 

Technical Skills

·         Reporting Tools:  Tableau Desktop/Server/Online 10.x/9.x/8.x/7.x/6.x, Business Objects 4.1/4.0/3.1, Xcelsius, Dashboard Designer, SAC, Power BI, SAP Lumira, Alteryx, SSRS.

·         ETL Tool:   Informatica Power Center 9.5, SSIS.

·         Databases:  Oracle 12g/11g/10g/9i, MS Access, Teradata 13x/14x, SQL Server 2008/2012/2014, DB2, My SQL, Netteza, PostgreSQL.

·         Languages:   T SQL, PL/SQL, SQL, ANSI 89, ANSI 92, Custom Sql, XML, Python, UNIX Shell Scripting.

·         Operating Systems:  Windows XP/7/8/10, MS-DOS, UNIX, Linux. 

·         Data warehousing:  Normal forms (OLTP), Star Schemas (OLAP), Snow Flake Schemas, Conformed dimension and slowly changing dimensions Type 1/2/3, Data modeling.

·         Industries:  Financial/Banking, Investments, Manufacturing, Sales/Marketing, Health Care, and Pharmaceutical.

·         Others: JIRA, SharePoint, Version One, Toad, SSMS and Microsoft Office.

 

 

Professional Experience

Optum Analytics, Rocky Hill, CT                                                                                  April 2017 - Present

Sr. Tableau Developer/ Sr. Data Analyst

 

Responsibilities:

 

·         Involved in the solution scoping of the project.

·         Organized workshop sessions to gather business requirements (blue printing) from the business users.

·         Built Strategic, Analytical and operational dashboards using Tableau.

·         Tableau server maintenance, Tableau server backup activity.  Consolidate multiple data silos that exist on campus to one location and Scheduled data extracts daily. 

·         Environment Support to User community, Service Request & Resolution.  Also, Expertise in failed over activities in production Environments.

·         Created users filters and assigned appropriate roles to users in Tableau Server.

·         Deployed Dashboards from Dev to QA and QA to Prod.

·         Sophisticated stored procedures and triggers to provide complete technical solutions.  Participated in test planning and test script definition. Resolved end user reporting problems through collaboration with IT and Operations. 

·         Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau.

·         Implemented row level security for the Tableau dashboards and used various advanced table calculations for the dashboards.

·         Collaborated with team members to streamline and continuously improve reporting solutions. Generated visualization adhoc reports using Alteryx and SSRS.

·         Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and Teradata.

·         Created stored procedures, user defined functions, views, tables and T-SQL scripting for complex business logic.

·         Cleaned data source in SQL Server and prepared data source in Tableau metadata using complex joins, Custom SQL, split and data blending.

·         Designed, developed and maintained daily, weekly, monthly and year-end summary, trending and benchmark reports repository in Tableau Desktop.

·         Generated complex calculated fields and parameters, toggled and global filters, dynamic sets, groups, actions, custom color palettes, statistical analysis to meet business requirements

·         Implemented visualizations and views including combo charts, stacked bar charts, Pareto charts, donut charts, geographic maps, spark lines, crosstabs etc.

·         Defined visualization pixels and created dashboards using vertical/horizontal containers and collected dashboards in Tableau Story Tableau dashboards embedding into Salesforce for the continuous data experience for the users.

·         Built custom tableau dashboards for the Salesforce for accepting the parameters from the Salesforce to show the relevant data for that selected object.

·         Connecting and extraction to different data sources including Teradata, MS SQL Server, flat files using ODBC driver installation on the tableau server machines.

·         Developed tableau dashboard landing page for the embedding into Salesforce to provide integrated views and navigation inside Salesforce for the users.

·         Developed various dashboards for non-Salesforce group of users for their specific goals of understanding data.

·         Tableau administration and development roles and helping the client with the issues of data connections, extraction and maintenance.

·         Tableau server and desktop upgrade from 9.3 to 10.3. 

Environment: Tableau Desktop/Server (9.x/10.x), Alteryx, MS Office Suite, SQL Server, Oracle, Python, Salesforce, DB2, SharePoint, AutoSys, MS Excel

 

 

Amgen Inc. (AMGN), CAMBRIDGE, MASSACHUSETTS                                              April 2015 to April 2017

Lead Tableau Developer/BI Developer

 

Responsibilities:

 

·         Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.

·         Worked closely with different stakeholders to implement successful solutions.

·         Utilized the JavaScript API to create a customized portal for the property management group.

·         Connected to Tableau PostgreSQL database to create customized interface for Tableau workbooks to provide native intranet style navigation.

·         Collaborated with Business Analyst and the Business users to understand user requirements, layout, and look and feel of the dashboards to be developed and created proof of concept / prototype the same using Tableau desktop.

·         Created Bar Charts, which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.

·         Loaded and executed historical usage into the pricing system and resolved historical usage validation errors in a timely manner to be utilized during pricing.

·         Designed, developed, implemented, and supported QlikView dashboards. Integrated data sources and databases with QlikView, and designed and developed data models and backend queries for presenting data.

·         Created data queries and reports using WellView, QlikView, Visual Studio, SQL Server Management Studio, SSRS, and Excel. Created custom queries/reports designed for quality verification and information sharing.

·         Used SQL, PowerPoint, Excel and InfoView daily to generate various performance reports for analysis.

·         Implemented and supported multiple projects at once.

·         Worked with Business users and IT Department together to implemented solutions.

·         Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.

·         Performed Data Warehousing and ETL using Informatica Power Center 9.5.

·         Performed modeling using Erwin, Star Schema modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.

·         Worked in different Phases of the project such as analyzing, requirement gathering, development, UAT and Production support.

·         Created many multi valued custom parameters in the visualization to display “All”/Selected values to filter the visualization data.

·         Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the 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, Sets, Background images, Maps.

·         Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.

·         Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.

·         Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.

·      Creating users, groups, projects, Data connections, settings as a tableau administrator.

·         Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

·         Worked with Big Data sets (about 60 million of rows).

Environment: Tableau Desktop 10.X/9.X, Tableau server / Administrator, Informatica Power Center 9.5, PostgreSQL, SQL Server 2005/2008, MDX/T-SQL, MDX Studio.

 

 

Kearny Federal Savings Bank, Kearny, NJ                                                                 Jan 2014 to April 2015

Senior Tableau Developer

 

Responsibilities:

 

·         Implemented Tableau BI Dashboard reporting solution for different Stakeholders in the organization and Published Dashboards onto Tableau Server.

·         Created calculated fields using Tableau for implementation of color coding and proper aggregations for data coming from Oracle.

·         Created extensive joins for data blending from several different data sources.

·         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 Tableau Desktop.

·         Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

·         Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.

·         Created and assisted users in Tableau dashboard development.

·         Worked with production team to implement UI and create enhancements to optimize user experience.

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

·         Worked with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server based Tableau dashboards with automatic updates.

·         Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.

·         Created several dashboards with various chart types such as stacked bar charts, scatter plots, heat maps, and text tables that demonstrated insightful trends over a period of time.

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

·         Tested Dashboard for data accuracy and Functionality.

·         Migrated Reports & Universes from Development to Testing and to Production Environment sing Import Wizard.

·         Created canned reports in Web Intelligence, Created New Universes and supported existing                  Business Objects Universes using Universe Designer and IDT.

Environment: Tableau Desktop/server 9.X/8.X, Business Objects 4.X/3.X, Universe Designer, Oracle 10G, UNIX, SQL Server 2005, Excel PivotTable reports.

 

 

 

 

 

NYCDED, NYC NY                                                                                                   Oct 2012 to Dec 2013

Tableau Consultant / Data Analyst

 

Responsibilities:

 

·         Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program.

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

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

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

·         Developed on several complex visualizations that all had to do with improving the programs offered to various schools in NYC.

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

·         Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.

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

·         Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views 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.

·         Optimized queries by looking at Execution Plan for better tuning of the database and Tableau Dashboards.

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

Environment: Tableau Server 8.x, Tableau Desktop 8.x, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, Oracle 11g, Toad, MS Office, Visual Studio 2010.

 

 

 

 

Capital One, Richmond, VA                                                                                  Jan 2011 to Aug 2012

Tableau / Business Objects Developer

 

Responsibilities:

·         Developed and published various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers. 

·         Responsible for gathering business requirements, worked directly with business units to define requirements and support various business initiatives and projects as it relates to analytics and reporting.

·         Involved in full project lifecycle of SDLC and coordinated with all project teams.

·         Led the Team of Offshore and Onshore developer.

·         Assisted users to publish and collaborated reports via a web browser & embed Tableau views in other web applications like SharePoint. 

·         Conducted trainings to user on interacting filters, sorting and customizing views on an existing visualization generated thru Tableau desktop. 

·         Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite. 

·         Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.

·         In charge of the team that builds tableau architecture and dashboards using Tableau desktop, Tableau Server and Tableau Online.

·         Working with User for requirements and part of the team developing the software.

·         Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.

·         Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.

• Executed and tested required queries and reports before publishing dashboards.

·         Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.

·         Created Tableau scorecards, dashboards, Heat maps using show me functionality.

·         Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI ) and Measure


·         Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports 

·         Created Web Intelligence Ad-hoc and canned reports in 3.1.

·         Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.

·         Experienced in developing Dashboards using Xcelsius 2008.

·         Worked closely with Data Modelers in designing various data warehouse schema techniques

·         Worked on the data provider that forms the basis of the ad-hoc analysis.

Environment: Tableau 6.x Desktop/Server, Business Objects XIR3, Universe Designer, Crystal Reports, Xcelsius, Web Intelligence, Info view, Oracle 10g, SQL Server 2008, T-SQL, Windows 2003 Server, .Net and Java based Applications.

 

Merrill Lynch, New York, NY                                                                                March 2009 to Dec 2010

Business Objects Developer/Data Analyst

 

Responsibilities:

 

·         Developed ad-hoc reports for complete Decision Support System.

·         Wrote complex Formulas for predefined conditions, Created Complex Reports in free-hand

·         Worked on development using SQL database system

·         SQL using Decode function for Date field with different formulas,

·         Applied breaks on reports to get appropriate results after converting documents.

·         Analyzed and explored the reports using Slice and Dice and Drill Down.

·         Done Drill down Analysis for various levels including custom-level and made available to end-user.

·         Exported reports to Web Intelligence (WI) module.

·         Developed courseware and instructional hand-outs.

·         Exported the universe to the repository.