Jayesh Tiwari

Data Analyst/Tableau Developer

Phone: +1-314-***-****

Email: adbyuu@r.postjobfree.com

Summary

●Experienced in IT - Business intelligence / Data analysis.

●Experienced in Tableau Desktop/Server. Proficient in creating rich visualizations using Tableau Desktop.

●Extensive experience in acquiring data from multiple data sources, joining them and preparing the Dashboards with useful insights in data.

●Reviewed trends in data sets, used SQL query operations to filter the data to understand the opportunities for brands and clients.

●Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other Local and Global filters according to the end user requirement.

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

●Found the opportunities to improve the current Dashboards

●Hand on experience in Administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.

●Having experience in designing customized interactive dashboards in Tableau using Marks, action, filters, parameter, security concepts, calculations and relationships.

●Worked on analyzing large sets of data using various techniques such as quantitative analysis, advanced analytics, and statistical modeling to find solutions.

●Ability to meet deadlines and handle multiple tasks, team player, motivated, able to grasp things quickly with analytics and problem-solving skills.

● Expert in Preparing dashboards using calculated (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) fields and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding parameters, calculations, groups, sets and hierarchies in Tableau.

●End to end experience in Installation and configuration, designing and deploying data visualizations using Tableau.

●A highly motivated and excellent team player with technical expertise in software engineering processes and outstanding knowledge on the life cycle of software design process (SDLC).

●Extensive knowledge of all phases of the Software development life cycle (SDLC), Agile, Scrum and the iterative Rational Unified Process (RUP) including Waterfall.

●Experience in creating different visualizations using Bars, Lines, and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

●Extensive experience in using Tableau functionalities for creating different Reports, Interactive Dashboards with page and dashboard Prompts.

●Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geo and custom geo maps and other making use of actions, local and global filters based on the end user requirements.

●Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources

●Experienced in preparing the webpages using HTML and CSS.

Education

University of Missouri- Saint Louis May 2019

Master of Science in Management Information Systems CGPA 3.7

Graduate Certification in Business Intelligence and Business Administration

Bhaskar Engineering College (JNTU), Hyderabad - India May 2016

Bachelor of Science in Electronics and Communication Engineering CGPA/Marks -70%

Professional Experience

CENTENE CORPORATION Nov 2019-Present

Role: Data Analyst II

Responsibilities:

●Extract data from Multiple data sources and build reports in Tableau in agile Environment.

●Develop and maintain Financial Model for Customer Service Change Management Team to show FTE’s saved to prove Return on Investment for the Automation and Self-service Initiatives.

●KPI Specific Analysis to back Financial Model by proving savings at member/provider level call and Web information.

●IT Costs and Savings reporting in Wave.

Environment: Teradata SQL Assistant (EDW), ORACLE - SQL Developer 19.1.0, Microsoft SQL server, Tableau 2019.2, Tableau Prep, Adobe Analytics, Micro-Strategy Advanced Excel, Wave.

BJC HEALTHCARE Oct 2018-Oct 2019

Role: Business Intelligence/Tableau Developer.

Responsibilities:

●Lead Tableau Developer for Safety Events Management System (SEMS) report used for medication safety throughout the system. Dashboard focused on multiple drill down capabilities to prioritize strategies to mitigate harm.

●Handled Tableau Administration activities granting access, managing extracts and scheduling of the dashboards.

●Developed Value Based Purchasing (VBP) reports for the organization.

●Developed Tableau Dashboard for Clarity (an Internal reporting tool) pulling out data through SQL query.

●Eliciting requirements from business analysts and managers and preparing FSD's and Technical design documents

●Automated critical Manual Tasks.

●Improvised the existing reports with new visualizations and using calculated fields

●Created Ad-hoc reports for the organization

●Ran SQL queries for pulling the data

●Completed the project from scratch for the Evaluation

●Used Data blending for the tables having duplicates to avoid many to many relations.

●Data Analysis and translate specifications into an interactive Dashboard/Report and/or Working Universe.

Environment: Tableau 2018.2, Microsoft SQL server, IBM DB2, Alteryx, VBA, Tableau server 2018.1.3, Advanced Excel.

University of Missouri – Saint Louis Jan 2017-Oct 2018

Role: Statistical Analysis Tutor

Responsibilities:

Served as a Tutor for University of Missouri- St. Louis students through University Tutoring Center.

Facilitated a learning environment for one-on-one tutoring in 1000-level or above Statistics, Probability, providing students with study techniques that resulted in improved academic performance

Participated in additional seminars to increase skills relating to teamwork, communication, and leadership

PROJECTS

Client : SPIRE INC.

Role: Data Analyst

Description:

Project involved research and data collection from the EIA website for Natural Gas consumption and production, analyzed the effects of changes in prices, population, climate regions on Natural Gas consumption throughout the US and created a data visualization to show trends and other key factors of clients’ interest.

Tools Used: TABLEAU 2018.2, EXCEL

Client : SensrTrx

Role: Data Analyst

Description:

Determined down time and provided preventative maintenance plan for a production line using multiple regression models and decision trees.

Tools Used: SAS, SPSS, TABLEAU 2018.2, EXCEL

TECHNICAL SKILLS

Statistical Analysis Tools: SAS, SPSS, Advanced Excel

Business Intelligence/ETL Tools: Tableau, Alteryx, Advanced Excel

Programming Languages: Python, Java (core), HTML, C

Databases: SQL Server, Microsoft SQL Server, IBM DB2

Methodologies: Scrum, Agile, SDLC

ACHIEVEMENTS

Runner up in UMSL HACKATHON’ 2017.

Head Student Co-Ordinator for ARIANE-2K14 – A Technical Festival for Undergraduates at College.

Organized and Participated in Automatic Video Surveillance workshop.

Certification on ANDROID Mobile Application Development.

Certificate of Career Planning and Personality Development.

Contact this candidate