Sanketkumar Parekh
ac8o49@r.postjobfree.com
Summary
3+ years of experience in Design, Development, Integration, Implementation and Maintenance of Tableau Developer.
In depth knowledge of SDLC phases such as Requirement analysis, design, development, implementation, deployment and maintenance with strong understanding of methodologies like Waterfall, Iterative& Incremental, Evolutionary prototyping and Agile.
Experiences on Tableau 7.x, 8.x, 9.x, 10.x tools include Tableau Desktop, Tableau Reader, Tableau Public, and Tableau Server.
Skilled Tableau front - end BI developer integrated with multiple back-end databases and other various data sources
Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. making use of actions and other local and global filters according to the end user requirement.
Experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader
Excellent understanding of Business Requirements Gathering, Translating Requirements into Specifications and Application Design.
Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
Worked on generating various dashboards in Tableau server using various sources such as Teradata
Developed dash boards with rich Graphic visualizations, Drill Down and Drop-down menu options, parameterized using Tableau.
Proficient in migrating workbooks between different environments in Tableau server using Tabcmd
Excellent interpersonal and customer relational skills. Proven communication, presentation skills and leadership qualities.
Created a Star Schema (Facts & Dimensions) using Extract, Transform, Load process (SSIS)
Knowledge to design right solutions with appropriate combination of Azure and custom technologies for deploying on Azure cloud.
Ability to handle multiple tasks and work independently as well as in a team.
Wrote complex SQL queries and generated different reports and graphs.
Education
Master’s Degree in Systems Engineering
Florida Institute of Technology, FL
Technical Expertise
Languages
Oracle SQL, R, SAS, Shell Scripting, SQL-queries
Databases
Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008, DB2, MySQL
Tools
Tableau 6/7/8.1/8.2/8.3 and 9.0, 9.2, Qlikview, SSIS, Crystal Reports, R Studio
Business Intelligence
Tableau Desktop, Tableau Reader, Tableau Server, Informatica
Applications
Advanced MS Excel, MS Visio, MS Access
Operating Systems
Windows 98/XP/7, Windows NT/2000, Server 2003, Vista,7, Unix, Linux
Professional Experience
Humana, FL
Tableau Developer May 2018 - Current
Extracted the business requirements from the end users keeping in mind their need for the application and documented it for the developers.
Gathered requirements for analyzing and designing multi-dimensional reports.
Identified system integration requirement, coordinated, the collection and verification of business needs, use case models for the functional requirement.
Involved in Lead contracting division team in JAD sessions for project needs assessment for process models.
Creating user friendly reports in MS Excel (Highly proficient in pivot tables, v-lookups, linking of sheets, charts etc.),
Developed SSIS Packages for migrating data from different Staging Area.
Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
Interacted with business stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery
Converted the Functional Specs to technical design and designed the overall metadata development in Tableau.
Creating dataflow diagram and documenting the whole data movement process.
Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
Created dashboards for Engineers to measure performance of their field engineers and manufacturer defects.
Preparing Dashboards using calculations, parameters in Tableau.
Developed Tableau Data Extracts for dashboards by creating ETL workflows in Alteryx from multiple data sources and customized data
Defined best practices for Tableau report development.
Setup Tableau Server to publish and distribute dashboards easily.
Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
Working with Multiple Data Connections.
Assisted in mining data from Oracle database for specific reporting purposes.
Provided support to business team by responding to ad-hoc data requests, answering questions, and providing technical support and analysis.
Vivma, India
Jr. tableau Developer Jul 2014 – Dec 2016
Worked on a Project using Microsoft Access to create a Customer Tracking System to track customers, their status and information.
Requirements Gathering and Analysis for the Customer Tracking System.
Gathered requirements from users and created requirement documents.
Involved in the administration tasks of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
Extensively gathered information by conducting walkthrough, workshop, brainstorming sessions and surveys. Identified the business requirements, analyzed and prioritized these requirements that should be included in advantage.
Prepared technical documentation for the reports in the process of migrating from development to production Environment.
Also worked on querying /pulling data extracts (using SQL Server / MS Access) during the Data Cleansing / Migration phase of the project.
Developed advanced queries using SQL to deliver or improve; process automation, data integrity, and adherence to business rule requirements.
Managed & worked on secured Access databases. Creation of Access Forms (using VBA code) to update Oracle database & to pull reports as per requirements.
Embedded live Tableau dashboards on PowerPoint presentations, keeping the slides always updated
Delivered dashboards tracking viewership, HUT and Advertising sales for a Media channel.
Setup stand alone and distributed Tableau Server to publish and distribute dashboards easily
Experience in assisting users in creating and modifying worksheets and data visualization dashboards.
Scheduled frequency and time to refresh data for the data sources are publishes ori extracted to server.
Participated in discussions for Tableau Server architecture design on Cloud, enhancing performance, scalability and high availability
Developed Stored Procedures, Functions, Packages and SQL Scripts using MS SQL.
Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
Created SSIS Packages/projects to move data from source to destination by using Visual Studio 2012