Ishrat Azeem

E-mail adaptc@r.postjobfree.com

Cell= 732-***-****

Professional Summary:

●7+ years of experience in Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 6/7/8 and 9.

●Developer/Admin experience on Tableau, data discovery, data visualization, data analysis, report development, MS SQL Server Developer/ ETL Developer in analysis, design, implementation & administration of Business intelligence solutions (SSIS/SSRS/SSAS) with Microsoft SQL server 2012/2008-R2/2008/2005 in development, testing & production environment.

●Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

●Designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts and Geographic Visualization

●Perform Analysis of large data sets using components from the Hadoop ecosystem.

●Familiar with the data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling and data mining, machine learning and advanced data processing.

●Analyze Hadoop clusters using big data analytic tools Hive.

●Experience with the design and development of Tableau visualization and dashboard solutions using Tableau Desktop.

●Involve in development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.

●Implemented actions, other local and global filters according to the business/client requirement to make workbook and dashboard more interactive.

●Expert in evaluating data models to design Tableau solutions.

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

●Extensive experience working as a Business Intelligence Consultant with specialization in Crystal reports and SAP BO.

●Extensive experience working in Windows, UNIX, LINUX environments.

●Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, MS Access and client/server applications.

●Professional in writing complex Formulas, Sub Reports, Summary Reports.

●Involved in Trouble Shooting, Performance tuning of reports and resolving issues within SAP BO.

●Installation, configuration and administration of Crystal reports and SAP BO.

●Deployed the reports and Scheduled Reports for the use of end users and customers.

●In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

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

●End to end experience in designing and deploying data visualizations using Tableau

●Worked extensively with creating reports as per user requirements using MS Reporting Services 2005/2008R2

●Extensive working experience in Packages, Procedures, Cursors and Triggers.

●Experienced in tuning Long running SQL queries for better performance.

TECHNICAL SKILLS

BI Reporting Tools

Tableau Desktop/Server 7.x/8.x/9.x, Cognos, SSIS/SSRS, Informatica, Erwin

Databases

Oracle 9i/10g/11g/12c, MySQL, MS Access SQL Server, Oracle, Flat Files

Application Servers

Web logic, Web Sphere, Tomcat

Operating Systems

Unix, Linux, HP-UX, AIX, Solaris

Office tools

Windows XP/2000/2003/NT 4.0/Vista and MS-Dos.

Programing Language

C#,HTML,SQL,PL/SQL

Tableau Desktop

9.1.1 & 9.3, 10 (Expert)

Tableau Server

(Advanced)

PROFESSIONAL EXPERIENCE

SUEZ Water Technologies & Solutions

Trevose, PA 19053

Sr. Tableau Developer June 19–Till

Responsibilities:

• Translate functional requirements into a Tableau implementation.

• Solve scenarios as a member of Tableau team in organization.

• Have the ability to apply business intelligence solutions to improve business processes. As an Analyst connect to different dimensions of data from the data warehouse (SAP & other sources) and utilize the Tableau model and business logic to produce visualizations that are updatable real-time.

• Serve as liaison between data source teams and the business units to coordinate the onboarding of data onto the data mart and the creation of analytical solutions, dashboards and reports.

• Create database queries to effectively retrieve data from a variety of environments (SAP is the main source of information).

• Implement effective data validation and ensure proper data quality.

Created stacked bars to show the quota and actual performance for each sales rep by region.

Developed benchmark ticket price for each market to understand the quality of discounts offered.

Created report using dual axes to show the gap in performance.

Responsible for analyzing functional Specs and preparing technical specifications per business needs

Created Executive Dashboard Scorecard that provides sales reps and sales manager performance KPIs.

Created story showing the performance of each sales rep since sales territory assignment.

Developed reports for different sales management hierarchies.

Created analytical reports and dashboards using filters, parameters, sets, bins and implemented visualizations with complex calculations to manipulate the data.

Implemented Data blending to pull data from disparate sources.

Used joins and applied filters to limit the data sourced into report.

Created views using various axes like Individual Axes, Dual Axes and Blended Axes.

Used Trend Lines, Reference Lines, box plots and Annotations to describe the data.

Created Data extracts for better performance and accessing data offline.

Used parameters and input controls to give users control over certain values.

Developed Custom Geo-coding for organizational territory alignment requirements.

Created and Published Tableau Dashboards into Tableau Server.

Write SQL queries for data validation and data integration where necessary.

Created incremental refreshes for data sources on Tableau server.

Evaluate live vs extracts connections based on data size and performance requirements.

Environment: Tableau Desktop 9.3, Tableau Server 8.1, Oracle 11g, UNIX, MS Access, SQL Developer, MS Excel

Gemland, Houston TX

Sr. Tableau Developer July 16 – May 19

Responsibilities:

●Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.

●Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.

●Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

●Involved in creating and visualizing dashboards using Tableau Desktop.

●Generated Tableau combination charts using Tableau visualization software.

●Involved in discussing Requirement Clarifications with multiple technical and Business teams.

●Created Technical Design Document from the functional specification documents.

●In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

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

●Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once

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

●Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data

●Dashboard Visualization through Tableau BI application.

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

●Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.

●Effectively used data blending, filters, actions, Hierarchies feature in tableau.

●Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows

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

●Executed and tested required queries and reports before publishing.

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

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

●Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server

Environment: Tableau Desktop 8, Excel 2013, Outlook 2013,Microsoft Office Suite ( Word, Excel, Power Point, Visio).

Money Grams, Dallas, TX Mar 2014-June 2016

Tableau/Developer

Money Gram International Inc. is a money transfer company which helps customers to transfer money all over the world. As a Tableau Developer, my tasks were mainly based on creating informative and interactive shareable dashboards.

Responsibilities:

●Involved in Interacting with business users and performed Gap Analysis according to Client requirements.

●Reviewed business requirements and analyzed data from various sources like Excel/ SQL Server for design, development, testing and analyze the projects within Tableau Desktop.

●Created various interactive reports/dashboards using tableau desktop.

●Expertise in Creating Heat Maps showing registers service subscribers by using parameters, colors that were broken into regions allowing business users to make better decisions and improve data performance.

●Experienced in designing and developing multiple analytical reports from multiple data sources by data blending on a single worksheet in Tableau Desktop.

●Used advance features of Tableau like to link data from various sources merged on one dashboard and to filter data in multiple views at once.

●Created different Calculation fields according to requirement, various conditions and applied multiple Filters for various analytical reports and dashboards.

●To estimate profit generation by creating calculated fields and calculation across the table on the data from Micro SQL Server and MS Excel.

●Created worksheets reports and converted into interactive dashboards by using Tableau Desktop and provided to Business Users, Project Managers and End Users.

●Experienced in writing SQL queries to extract data from databases and connecting live/dynamic and static datasets to tableau desktop.

●Involved in scheduling data refresh on Tableau Server for weekly and monthly basis on business change to ensure that the views and dashboards were displaying the updated data accurately.

●Experienced on creating, executing test Cases and documenting the Test Results.

Environment: Tableau Desktop 8.x, Tableau Server 8.x, MS Excel, Microsoft SQL Server 2012

Central Pacific Bank, Annandale, VA

Tableau Developer Jan 2013 -Feb 2014

Responsibilities:

●Involved in business requirement gathering and technical specifications document design.

●Created report on sum of sales for each product name about region.

●Created sum of parts quantity used for each description broken down by machine and parts number vs department date and time quarter and total meter

●Used filters on Date, assigned to, Priority, Originated from, Property Name, Request Type, State, Sub type and Status.

●For the Performance issue sum of the records broken down by Response Time, Completion Time, and Work Order Volume.

●Created dashboards per user specifications and prepared stories to provide an understandable vision.

●Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.

●Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.

●Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.

●Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

●Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

●Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately

● Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

●Participated in meetings, reviews, and user group discussions

● Worked with testing and production teams for code validation and deployment.

Environment: Tableau Desktop 8.0/9.1, Tableau Server 9.1, MS Office Suite, Oracle, MS SQL Server 2000, JIRA, SQL Developer.

EDUCATION AND CREDENTIALS

Brookdale Community College May 2010

Lincroft,NJ

Associate “Science and Maths”

Peru state College Sep 2015-Till

Peru, Nebraska

Bachalor “Psycalogy”

Contact this candidate