Tableau Developer - Majid

Syed Abdul Majid

Business Intelligence Tableau Developer

E-MAIL: ac25ye@r.postjobfree.com

PROFESSIONAL SUMMARY

• 8 + years of professional experience in Business Intelligence, Software Design, Modeling, Development and Implementation in Information technology with skills in all phases of Data Warehouse lifecycle development.

• 5 + years of Tableau Experience, proficient in designing and creating various Data Visualization Dashboards, worksheets and analytical reports to help users to identify critical KPI(Key Performance Indicators) and facilitate strategic planning in the organization utilizing Tableau Visualizations according to the end user requirement.

• Good knowledge of System Development Life Cycle (SDLC), Agile and Waterfall development environments.

• Posses' strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.

• Worked with SQL server and Oracle databases as the backend and have knowledge in writing various queries, triggers and stored procedures in SQL Server 2008/Oracle 10g.

• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.

• Involved in installation of SAP HANA 1.0.17 in two environments.

• Prepared different highly formatted financial reports such as consolidated income statements and balance sheets using Crystal Report and Ad-hoc reports using Web Intelligence.

• Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, MS access and flat files.

• Experienced with ETL tools like Informatica, SSIS, SSRS

• Excellent interpersonal and customer relational skills. Proven communication, presentation skills and leadership qualities.

• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps. Effectively used Data blending feature in Tableau.

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

TECHICAL SKILLS

Specialties: Data Visualization, Business Intelligence (BI), Software Management and Data Collection.

BI Tools: Tableau Server6/7/8, Tableau Desktop 6/7/8/9, Tableau Online, Tableau Public, Tableau Reader, Informatica Power center 9.5.1, Informatica Power Exchange, Cognos 10, QlikView, OBIEE 10g,11g, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), TabCmd.

Database/ERP: MS SQL Server 2005/2008/2012, Oracle 8i/9i/10g/11g, MS Access, OLAP, OLTP, SAP.

Tools and Packages: SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio, MS Office (Word, Excel, PowerPoint), Adobe Acrobat, Visio, JIRA, TOAD.

Languages: SQL, PL/SQL, C, C++, ASP.Net, HTML, XML, XSL, CSS.

Operating Systems: Windows 2000/2003, 2008 Server, Windows 95/98/2000/XP/7/Vista/8, UNIX, LINUX.

Methodologies: SDLC, Scrum, E-R Modeling, Star Schema, Snowflake Schema.

PROFESSIONAL EXPERIENCE

Tableau Developer/Admin March 2017 to Present

DexYP

Santa Monica, CA/Dallas, TX

Description: The goal of the project is to create a central repository for all data related to Merchants, Merchant Products, Equipment's, Charges Applied needed for reprocessing, recovery, reporting, and retention across mid-range applications and develop various analytical reports, dashboards on the same.

Responsibilities:

• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

• Experience in standardizing Tableau for shared service deployment.

• Extensively used data blending, embed functionalities in Tableau.

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

• Generated server-side PL/SQL scripts for data manipulation and validation and created various materialized views, global temporary table.

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

• Hands-on development, assisting users in creating and modifying worksheets and data visualization dashboards

• Provided 24/7 production support for Tableau users.

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

Environments: Tableau server 9/10, Tableau Desktop 9/10, PL/SQL, MS Excel, SQL, MySQL, Oracle 10g, Crystal XI, Info view, TSQL.

Tableau Developer

Penguin random house, Broadway September 2016 to March 2017

New York, NY

Description: Gathered information from the business and developed dashboards based on the requirements given. Also, designed KPI dashboards and helped the team to create dashboards using Tableau.

Responsibilities:

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

• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring

• Created incremental refreshes for data sources on Tableau server.

• Involved in license management SLA's with Tableau support.

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

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

• Ad-hoc ETL, Reports requirement runs.

• Created visualization for logistics calculation and department spend analysis.

• 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

Environments: TableauDesktop9.0/8.3, Tableau server/Administrator, SQL developer, SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007

Tableau Developer/Admin Feb 2014 to August 2016

Sirius xm radio

Farmington Hills, MI

Description: Worked on the Administering Tableau Server as well as created dashboards related to Tableau Admin views and also helped other departments in developing Tableau Dashboards and published them to the Tableau Server for interactive custom.

Responsibilities:

• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.

• Used Sheet filters to produce multiple chart types in a single view.

• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.

• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.

• Developed Dashboards using OLAP cubes.

• Extensive usage of Amazon web services(AWS) for connecting to the data sources on cloud using Amazon redshift services.

• Use of Java script for creating the client-side validations in the webpages with dashboards.

• Use of Java script for embedding the dashboards on the webpages.

• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.

• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Environments: TableauDesktop9.0/8.3.0, Tableau server/Administrator, SQL developer, SSIS, OLAP, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007

Tableau Developer/Admin April 2012 to Jan 2014

Micron

Boise, ID

Description: Worked on the Administering Tableau Server as well as created dashboards related to Tableau Admin views and helped other departments in developing Tableau Dashboards and published them to the Tableau Server for interactive usage.

Responsibilities:

• Migrated the server from a VM to Physical server to improve the performance.

• Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.

• Enabled SSO to SAP HANA data source from Tableau environments.

• Experienced in writing scripts to remove inactive users on the server.

• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.

• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes

• Connected to Tableau Postgre SQL database to create customized interface for Tableau workbooks to provide native intranet style.

• Created scripts to send automated alerts whenever restore or backup fails

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

• Coordinated database middleware issues with DBA's, query performance with System Architects

• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level •Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.

• Provided 24/7 production support for Tableau users.

Environments: TableauDesktop10.1/9.3, Tableau server/Administrator, SQL developer, SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office.

OBIEE BI Consultant Feb 2011 to April 2012

Studio Geisinger

Bloomsburg, PA

Description: Responsible for all Reporting related activities including Analysis, design, Administration and implementation of the project. Acted as a critical resource right from the process of requirements gathering, data modeling, reports development, security implementation to production deployment.

Responsibilities:

• Assisted with developing and nurturing the overall logical physical Data warehouse/Data-mart data model and data architectures

• Loaded the data to fact and dimension tables from ODS to STG and STG to FCT and DIM

• Developed Different Reports with different Analytic Views (Tables, Pivot Tables, Charts, Column and View Selectors, Narrative, Tabular with Global and Local Filters) using presentation services.

• Configured Analytics Dashboard HTML style sheets to meet reports layout requirements

• Performance tuning in OBIEE for star schemas by implementing aggregate navigation, cache management, Materialized Views and Database tuning

• Created Time Series objects for comparing business performance with previous time periods using Ago and ToDate Functions.

• Implemented the Time Series Wizard YTD, QTD, and MTD for comparing measures in different time Periods.

• Developed complex Informatica mappings and tuned them for better performance

• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges. Implemented Object level as well as Date level security

• Generated reports using BI Publisher

• Extensively used Dynamic Section Prompts and Guided Navigation in dashboards.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11G, BI Analytics, BI Console, BI Enterprise Manager, HTML, Windows 7 Enterprise.

Informatica ETL Developer March 2010 to Jan 2011

CFSA

Washington, DC

Description: CFSA (Child & Family Services Agency) is a child support local government agency located in Washington D.C. which provides financial, household and foster parents for abandon children in the city of Washington.

Responsibilities:

• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.

• Designed, Developed and Supported Extraction, Transformation and Load Process ETL with Informatica Power Center 9.5.1

• Worked with QA team to create test cases and validated the source and target tables.

• Written complex SQL queries and queried the Oracle database to test DataStage ETL code.

• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

• Developing Teradata Utility scripts like Fast Export, FLoad, and MLoad to load data from various source systems to Teradata.

• Extensively worked on designing Business views and writing SQL queries in Teradata catering specific business requirement to generate data.

• Used OBIEE for preparing reports and analysis.

• Creating list reports and cross tab reports using Business Objects and Cognos.

Environment: Informatica Power center 9.5.1, OBIEE, Informatica Power Exchange, Oracle SQL Developer, Cognos 10

SQL, SSRS, SSIS Developer Feb 2009 to March 2010

Honeywell

Morris Plains, NJ

Description: The role was to integrate the data, providing high quality data for decision making working with analysts to understand data requirements, provide clean & correct data for model development and actively participate in defining and governing data.

Responsibilities: -

• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS and integrated in SharePoint environment.

• Used SQL Server profiler for auditing and analyzing the events which occurred during a time horizon and stored in script.

• Worked on scheduling data loading and transformations using SQL Server Integration Services (SSIS) between different maintenance systems.

• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers

• Developed single value and multi valued parameterized reports for Business Users using Microsoft SQL Server Reporting Services (SSRS).

• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

• Designed ETL packages for extracting the data and load into the appropriate tables in the database using SQL Server Integration Services (SSIS).

• Designed and built OLAP cubes to meet reporting needs.

• Used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, before loading the data into the Data warehouse.

Environment: MS SQL Server 2005/2008, SSRS(Reporting Services), SSIS(Integration Services), MS SQL Server Analysis Services 2008, OLAP, DTS/SSIS, BIDS.

EDUCATION

Jawaharlal Nehru Technological University HYD, India

Bachelors of Science in Electronics & Communications Engineering.

Contact this candidate