Akshay Prajapati
321-***-**** • **************@*****.***
Tableau Developer
Professional Summary
3+years of IT Experience in design, analysis, development of Tableau Developer in Manufacturing, Retail and Financial industries.
Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau Tableau 6.x/7.x/8.x Desktop, Server, Mobile, and Public, Micro Strategy, Business Objects and SSRS.
Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
Experience in facilitating Joint Requirement Planning JRP sessions with Business User Groups, conducting Joint Application Development JAD sessions with IT Groups.
Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
Managed cross-functional teams through Software Development Life Cycle.
Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
Posses' strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
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.
Outstanding knowledge in Microsoft Office suite MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio.
Deep experience with the design and development of Tableau visualization solutions.
Working on generating various dashboards in Tableau server using various sources such as Teradata.
Experience setting up and managing Tableau Server with large volumes of data.
Setting up Tableau data sources. Filters, blending, joins for optimum performance and Trouble-shooting issues
Technical Skills
Languages
SQL, PL/SQL, C, C++, ASP.Net, HTML, XML, XSL
Databases
MS SQL Server 2005/2008/2012, Oracle 8i/9i/10g/11g, MS Access.
BI Tools
Tableau 7.0,Tableau 8.0/8.1,OBIEE 10g,11g,SSRS, Agile
Tools and Packages
SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio
IT Processes
Software Development Life Cycle (SDLC), Data Collection, Software Management
Operating Systems
Windows 2000/2003,2008 Server, Windows 95/98/2000/XP, UNIX, LINUX
Education
Masters in Engineering Management
Florida Institute of Technology, FL
Experience
PepsiCo, FL
Tableau Developer May 2018 - Current
Working on generating various dashboards in Tableau server using various sources such as SAP HANA/SQL Server/Teradata/Oracle.
Experience in creating users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
Preparing Dashboards using calculations, parameters in Tableau.
Understanding of relational database structures, theories, principles, and practices.
Created drill down and drill up in worksheets in tableau.
Involved in creating a dual-axis bar chart with multiple measures.
Created report schedules on Tableau server.
Followed Agile methodology for application development and Worked on HTML, JavaScript and JSP for development UI.
Wrote SQL queries to query data from database.
Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
Involved in license management SLA's with Tableau support.
Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
Metasystems, India
Jr. Tableau Developer July 2014 – Dec 2016
Administered user, user groups, and scheduled instances for reports in Tableau.
Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
Tableau Desktop, Tableau server / Administrator, Oracle 10/11g, Microsoft Excel, MS Access, Microsoft office MS SQL SERVER 2008, SSIS, SSAS, SSRS, SQL Profiler, Windows XP / NT / 2000/2003, Microsoft Access.
Converted metric insight reports to tableau reports.
Working extensively with Tableau Business Intelligence tool to develop various dashboards.
Creating dataflow diagram and documenting the whole data movement process.
Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
Created Backup scripts to take periodic backups for the content on Tableau server.
Developed SQL Server Impersonation for Impersonation Requirements, How Impersonation Works,
Impersonating with a Run as User Account, Impersonating with Embedded SQL Credentials.
Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing Deleting Users and Activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.
Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.
Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server.