Data Microsoft Office

Mohammed

Email: ************@*****.***

Contact: 224-***-****

BI/Tableau Developer/Data Analyst/SQL Developer

Over 5+ years of extensive IT Experience as a Sr. Tableau Developer, Data Visualization Engineer, Power BI Developer and Tableau Server Administrator.

Professional Summary

5+ years of experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.x/9.x/8.x/7. x.

Expertise in Tableau Server Administration and working in DW environment

Outstanding knowledge and working experience of Power BI.

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.

Extensively worked on Prototyping and designing reporting, data analytics and visualization solutions

Create process efficiencies through automation (report delivery, dashboard creation and data management)

Strong knowledge in developing, designing and implementing data mining models using neutral networks and logistic regression

Experience in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.

Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.,

Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.

Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.

Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems via API

Involved in writing detailed as well as high level documents for reports and repository design

Identifying and removing bottlenecks in order to improve the performance of dashboards and reports.

Power BI experience in designing Interactive Reports and Data Visualization using Power BI Desktop.

Technical Skill Set:

BI Tools

Tableau 10.X/9.X/8.X/7.X (Desktop, Server, Reader), SSRS, Cognos, Alteryx 10.0, Power BI.

ETL Tools

Informatica, SSIS

Front End Tools

Microsoft Project, Microsoft Office

Document management

Visual Source Safe 6.0, Share point, Ultra Edit, Documentum

Defect management tool

Test Director, HP Quality center

RDBMS

Hadoop, Teradata, Oracle, SQL Server, MS Access, TFS.

Scripting Languages

C, C++, HTML, CSS,

Operating systems

Windows 7/XP, Windows Server 2012/2008, UNIX/Linux.

Professional Experience

GM Financial (Michigan) Jan’ 2017 to till Date

Sr. Tableau Developer / SQL Developer / Data Analyst

Description: GM Financial is the wholly owned captive finance subsidiary of General Motors. The company is a global provider of auto finance solutions, with operations in the U.S., Canada, China, Europe and Latin America. GM Financial's success is largely dependent on building strong, lasting relationships with our dealers and the consumer customers that we serve

Roles & Responsibilities:

Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.

Developing Tableau interactive dashboards to monitor KPI’s related to Overages, Shortages and Damages etc.

Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project life-cycle.

Working with team of developers to designed, developed and implement a BI solution for Sales, Post Sales Research, Product and Customer KPIs.

Working in Agile Scrum Environment. Working on Jira and Service Now Ticketing.

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

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

Working knowledge in Hadoop HDFS Admin Shell commands.

Scheduling, debugging, and optimizing BI processes based on dependencies.

Restricted data for users using Row level security and User filters.

Developed Tableau workbooks from multiple data sources using Data Blending.

Provided 24/7-production support for Tableau users.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Generated context filters and data source filters while handling huge volume of data.

Built dashboards for measures with forecast, trend line and reference lines.

Published Workbooks by creating user filters so that only appropriate teams can view it. Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups.

Developed effective and interactive Dashboards using Parameters and Actions.

Setting the user permissions in Tableau Sever.

Maintaining server activities, user activity, and customized views on Server Analysis.

Prepared proof of concept for best practices in Tableau deployment.

Worked with Source System Subject Matter Expert (SME) to ensure that the extracts are properly mapped. Used SQL Workbench for data mapping and querying.

Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau (Desktop/ Server)10.0, Microsoft Power B.I., Teradata V2R5/R6/R12/R13, AWS, SQL developer, Sales Force, MS SQL Server & TFS, Teradata SQL Assistant, Toad, MS Access, Windows 2012 R2 server.

CROWE HORWATH LIVINGSTON, NJ Nov’ 2015 to Dec’ 2016

Tableau Report Developer/Data analyst

Description: Crowe Horwath LLP is a North American member of Crowe Horwath International, one of the 10 largest networks in the world. Crowe's services include assurance, benefit plans, financial advisory, forensic services, performance consulting, risk consulting, tax and technology, among others. Crowe customers primarily consist of large and middle market public companies and large privately held businesses.

Roles & Responsibilities:

Created and hands on experience in Level of Detail Expressions (LOD’s) such as Customer order frequency, Cohort analysis, Daily profit KPI, Percent of total, New customer acquisition, Comparative sales analysis, Average of top deals by sales rep, Actual vs. target, Value on the last day of a period, Return purchase by cohort etc.

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

Worked on embedding Tableau reports to Microsoft Power BI Launchpad and Crystal reports.

Implemented Tableau, performed admin activities across multi-environment infrastructure

Interacted with SME & End Users and gathered business requirements.

Performed Data Discovery, development of data set using SQL coding and scheduled jobs to load in Hive.

Sourced data from different databases and built visualizations using Tableau tool at different granular levels.

Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental.

Refresh for the weekly and monthly dashboard reports on Tableau Server.

Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).

Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.

Experienced working in Agile, Rally & Scrum implemented Environment.

Handled the tasks of building, deploying and maintaining metadata inventories and data support tools

Experienced working on different ticketing systems such as Agile ticketing.

Understanding of and experience with real-time analytics, BI platforms and visualization tools such as Tableau

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

Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,

Created and administered user, user groups, and scheduled instances for reports in Tableau Server.

Created detailed dashboards utilizing Tableau and Power BI to improve analysis and decision making.

Exposure to ETL tools such as SSIS, Talend and Informatica.

Extensively working experience in Tableau Server Configuration/DB Connection for Oracle DB.

Excellent in Performing maintenance activities of Tableau Server incl. Backup, Logs Cleanup and Archiving Log files in prescribed intervals

Played an important role in coordination with the entire team and managing the time estimates for the entire project.

Environment: Tableau (Desktop/ Server)9.3 & 10.0, Alteryx, Microsoft Power B.I., Teradata V2R5/R6/R12/R13, Hadoop, AWS, SQL developer, MS SQL Server & TFS, Oracle MySQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Windows 2012 R2 server.

United Health Group July’ 2012 to May’ 2015

SQL Developer / Tableau Developer/Data analyst

Description: United Health Group Is one of the best healthcare company in the world, UnitedHealth Group Incorporated is a health and well-being company. The Company operates through four segments: United Healthcare, OptumHealth, OptumInsight and OptumRx. It conducts its operations through two business platforms: health benefits operating under UnitedHealthcare and health services operating under Optum.

Roles & Responsibilities:

Interacted with the stakeholders by interviewing them, by preparing questionnaire and getting feedback.

Collaborated with Enterprise Architecture, IT leadership and internal stakeholders.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Created reports using Trend Lines, Statistics, and Log Axes, Groups, hierarchies, Sets.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.

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

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

Created new Schedule's and checking the task's daily on the server.

Experience in standardizing Tableau for shared service deployment.

Extensively used data blending, embed functionalities in Tableau.

Prepared Tableau to Connect to Oracle MySQL Using SSL by Creating a TDC file and or Connected through the ODBC driver for MySQL

Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.

Handled the tasks of code development and data analysis

Experienced in a wide variety of telecommunication networks

Experienced in configuring and administering different level of securities.

Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.

Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.

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.

Environment: Tableau Desktop / Serve, Cognos, Alteryx, MicroStrategy, Teradata, Informatica, MS SQL Server, Toad, Teradata SQL Assistant, SQL, PL/SQL, T-SQL, UNIX, PowerShell, Microsoft office Suite (Word, Excel, PowerPoint).

Contact this candidate