Jaykumar

ac95s4@r.postjobfree.com

609-***-****

Summary of Qualifications

Around 5 years of experience in the IT Industry and worked on Tableau Desktop, Data Analyst with SQL and efficient in connecting various data sources.

4+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 2018.1/2018.2,10.3/10.2/10.1/ 9.x/8.x/7.x, 2018.1 as a Developer.

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

Developed Tableau Data Extracts from the above mentioned data sources using Pentaho Data Integration ETL tool.

Hands on learning with different ETL tools to get data in shape where it could be connected to Tableau through Tableau Data Extract.

Hands-on with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.

Strong Data modeling experience using ER diagram, Dimensional data modeling, Working knowledge of ODBC, OLEDB, T-SQL, SQL, PL/SQL, Teradata, Stored Procedures, Functions, Packages, Triggers, and scripting languages.

Well-versed with Microsoft Office Suite including Office365, Lync, MS Visio, MS Access, Project, Power Query, PowerPivot, DAX, SharePoint, and SharePoint Design.

Experience in deployment of Business Objects and Web Intelligence from various Sources oracle, Teradata, Ms Sql Server.

Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and sequel server reporting services(SSRS).

Have an idea on state of Wisconsin privacy regulations while working on the dashboard workbook.

Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters, sets, groups, calculated fields, parameters, bins, sorting etc. and Dashboard prompts.

Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS ORACLE, Teradata tables using LIBNAME and SQL PASSTHRU facility, SQL, Cloudera Hadoop and Hive, Apache SOLR, Map Reduce, Amazon Redshift.

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

Roles:

Sr. Tableau Developer

SQL Developer

Education:

Bachelors in Computer Engineering – South Gujarat University, India

Skills Inventory

ETL tools

SQL Loader, SQL server Integrating Services(SSIS), Informatica Power Center 8.1, 7.1, 6.2

BI Tools

Tableau Desktop 10.x, Tableau Server, Tableau online, Tableau Public, Tableau Reader, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS), Alteryx 11, Power BI

Python Libraries

Python, Spark, Scala, Panda, Numpy, Scipy, Pydoop, PySpark

Databases

SQL server, Oracle 8i,9i,10g, Teradata, SAP Hana, Redshift, Hadoop

Data Modeling

ER/Studio 3.5/4.0, Erwin 4.1

Languages

Python, PySpark, MS-SQL, MySQL, hive, HTML5, CS3, JavaScript and XML

Web Servers

Apache web server, Microsoft IIS 4.0, Jboss 6.4

OS

Windows XP/03/07/10, OS X, Linux/Unix

Front-End Tools

Microsoft Project, Microsoft Office, Microsoft Excel

Public Profile: https://public.tableau.com/profile/jaykumar#!/

LinkedIn: https://www.linkedin.com/in/jay-patel-b127251b/

Related Experience

Client Name: Southwest Airlines

Location: Dallas, TX

Role: Tableau Developer

Duration Nov 2018 – May 2019

Roles & Responsibilities:

Developed Page layouts, Navigations and presented designs, usability strategies and concepts to the clients and the management to review.

Guide the design and development of data management and business intelligence projects to drive strategic decisions through data driven actionable metrics and insights.

Designing, developing and maintaining business intelligence solutions. Crafting and executing queries upon request for data. Presenting information through reports and visualization.

Assist in evaluating and selecting the best technologies and tools to support the BI mission.

Manage development and testing issues impacting our clients and operations.

Build BI reports, dashboards, drill-downs, filters, graphs, etc. on the Tableau Desktop BI platform.

Planned JRD meetings to gather business requirements from business users and SMEs.

Utilized T-SQL to pull data from various databases and created various dashboards, scorecards and reports to support business decision making.

Documented and maintained database system specifications, diagrams, and connectivity charts.

Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

Created Sub-Queries and Joins for complex queries involving multiple tables.

Monitor and improve data and BI processes to meet firm SLAs and increase efficiency.

Leverage technology capabilities and standards while working with technology system owners to identify appropriate data sources, define and build required data transformation logic.

Perform detailed data analysis to derive insights and deliver operational mechanism such as dashboards or ad-hoc reports.

Maintain in-depth knowledge of IT industry best practices, technologies, architectures and emerging technologies.

Assisted users with publishing Tableau workbooks to internal sites including auto refresh process.

Addressed business questions with bar charts, line charts, map etc. using Tableau desktop.

Created various reports using Tableau desktop per requirements.

Developed dashboards utilizing Tableau functionality such as sets, filter, parameters, and groups.

Formulated Tableau dashboards utilizing stack bars, bar graphs, scattered plots, geographical maps.

Configured data refresh of datasets using data extract in Tableau online.

Review new and existing solution delivery for compliance with IT standards, policies and Ensure that project documentation captures significant architectural decisions.

Identify architectural risks and propose alternatives and solutions.

Provide analysis of project, including business case, ROI and post-project review.

Drive innovation, best practices and achievement of strategic objectives

Published Tableau workbooks to Tableau Online with user filters so that only appropriate teams can view it.

Restricted data for users using Row level security and User Roles in Tableau.

Environment: Tableau Desktop 2018.1, Tableau Server, MS Office Suite, SQL Server, Oracle, Teradata, MS Excel.

Client Name: CPFPI

Location: Monroe, NJ

Role: Tableau Developer/Analyst

Duration: Feb 2015 – Aug 2018

Roles & Responsibilities:

As Tableau Developer, primary activities included designing technology roadmap for Tableau, product installation and implementation development of insightful dashboards, serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.

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

Created and maintained SOX documentation required for critical financial file systems.

Mentored and trained less tenured Business Analysts for their development.

Use tools such as SQL and In-sync for investigation of issues and work closely with our Actuarial and Underwriting Customers.

Managed projects ranging from large to small.

Created, maintained and queried relational database (MS Access). Understand and use SQL regularly for problem analysis.

Member of a team that created the proof of concept for the selection of the ETL tool (BI tool). Set with vendors and evaluated vendor tools during the proof of concept.

Created report schedules, data connections, projects, groups in Tableau Server.

Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.

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

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.

Created Adhoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used Excel, flat files, CSV files to create Tableau Adhoc reports.

Design and implement BI solutions for key business areas and stakeholders.

Formulated custom T-SQL codes and triggers for providing additional application functionality.

Established system and user defined functions for improving the functionality of T-SQL code.

Developed stored procedures, views, and UDFs to automate data entry by a front-end application.

Created permanent tables, temporary tables and table variables.

Successfully optimized the performance of queries with modifications to the existing index system and the reconstruction of indexes.

Employed bar charts, bubble charts, and map to answer business questions with Tableau.

Created report templates, bar graphs, and pie charts based on available data.

Implemented calculations, trend line and reference lines in Tableau dashboards.

Combined data from multiple sources using data blending in Tableau.

Created new hierarchies and managed relationships of Tableau data models per requirements.

Utilized groups, hierarchies, sets to create detail level summary reports and dashboard in Tableau.

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

Published Tableau reports to Tableau Online.

Configured data refresh of datasets using data extract in Tableau online.

Published Tableau workbooks to Tableau Online with user filters so that only appropriate teams can view it.

Restricted data for users using Row level security and User Roles in Tableau.

Environment: Tableau Desktop 9.0, Tableau Server 9.3, MS Office Suite, SQL, T-SQL, PL/SQL, Ms-Excel.

Client Name: I Infotech

Location: India

Role: SQL Developer

Duration: Feb 2014 - Dec 2014

Roles & Responsibilities:

Built Strategic, Analytical and operational dashboards using Tableau.

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets. Developed Inventory reconciliation, Sales KPI summary update reports, Days Inventory on hand report for different channels, firms and products rolling up by month end.

Created SQL views to pull data from SQL Server and developed reports using advanced calculations, filters and parameters.

Created Business Process Models from the requirement specifications.

Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2005, and MS Access databases.

Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.

Extracted data from xml and flat files using SSIS.

Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.

Created, maintained, modified, and optimized SQL Server databases, database security and auditing.

Designed, programmed, deployed and tested the requested Reports.

Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.

Developed user test cases and validated test results during user acceptance testing.

Assisted in test planning and execution. Created test plan for User Acceptance Testing.

Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures

Environment: SQL Server Management Studio 2012/2008/2008R2, Tableau Desktop 8.1, SSIS, SSAS, SSRS, XML, Oracle, MS Visual Studio, SharePoint 2013, ASP.NET, T-SQL, IBM DB2, Data Mining.

Contact this candidate