Tableau Developer Resume
Malvern, PA
PROFESSIONAL SUMMARY:
- About 6 years of experience in Information Technology industry with a strong background in Analysis,
- Design and Development in the field of Data Warehouse, Business Intelligence Data Modeling and Implementation of Tableau Desktop.
- 6 years of experience in the design and development of Tableau visualization and dashboard solutions using
- Tableau Desktop and publishing them on Tableau Server/Public/Reader and external websites Has exposure on MS Excel, Word, Access and MS Project.
- Experience with data analytics, prototyping and designing reports with visualization solutions using Tableau Desktop, Tableau Server and Tableau Reader.
- Experience creating complex data visualizations and interactive dashboard for decision support systems using
- Bars, Lines, Pies, Donuts, Maps, and Scatter plots, Gantts, Bubbles, Histograms, Heat/ Highlight Maps, KPI Scorecards, Tree Maps.
- Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, Security Concepts, calculations and Relationships.
- Good Understanding of existing business processes, data analysis requirements, business systems analysis and design.
- In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
- Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
- Has Knowledge on Splunk that captures, indexes, and correlates real-time data in a searchable repository from which it can generate graphs, reports, alerts, dashboards, and visualizations
- Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
- Developed Security Logic in Tableau Desktop and Published to Server and provided the required access.
- Developed Sample workarounds and prepared documentation on Tableau 10.5 New features.
- Worked on Performance Analysis by using Query Fusion.
- Worked on complicated calculations using LOD Calculations, Windows Functions, and Table Calculations.
- Widespread knowledge in using report building tools like PowerBI, Tableau, Spotfire and Qlikview.
- Experience in working at various levels of software development cycle such as Analysis, Designing,
- Developing, and Testing & Implementation of business applications in Client Server / Relational Database Management environment for Windows Platform.
- An empathetic listener and persuasive speaker with excellent written and verbal skills.
TECHNICAL SKILLS
BI Tools: BI Tools Tableau 9.0/9.1/9.3/10.1/10.2/10.3 , Tableau Server, Crystal Reports Business Intelligence Tableau Desktop 8/7, Tableau Server 7/8Tableau server, Tableau Reader, Tableau Public
BI/Reporting Tools/Operating Systems: Windows 95/98/NT/2000/XP7/8, UNIX (Sun Solaris), AIX, Web Sphere 8.5.5/7.0
Languages: C, C++, SQL, PL/SQL
Databases: Oracle8i/9i/10g/11.x,12c, MS SQL server 2000/05/10/12 , DB2 UDB, MSAccessTeradata 13.x/14.x/V2R6
Development Tools: TOAD, SQL Query Analyzer
Web Technologies: HTML, XML, JavaScript, VB Script, Microsoft FrontPage
Microsoft Tools: Microsoft Office, Visio, MS Excel, MS Word, MS Power Point
BI Tools: Data Manager 10/8.3/8.2, Data Stage 11.3 /8/7.5, Informatica 8/9
Other BI Tools: Tableau 9.03, Microstrategy, Business Objects 5.1
Methodologies: Ralph Kimball’s Data Modeling, Star and Snowflake Schema Modeling
PROFESSIONAL EXPERIECE
Confidential, Malvern, PA
Tableau Developer
Responsibilities:
- Interacting with Business Architecture and Reporting Manager, gathering the requirements according to client needs.
- Gathered user requirements, analyzed and designed software solution based on the requirements.
- Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
- Writing complex SQL queries on Teradata handling source data challenges and adapting to the dynamic nature of the project.
- Developed various reports using SQL for Inventory Management and Innovations team in accordance with Business Strategies.
- Created Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
- Highly experienced in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition.
- Involved in reviewing business requirements and analyzing data sources from Excel/MySQL.
- Designed and deployed interactive reports with Drill Downs, drop down menu option, Parameters and Linked reports using Tableau
- Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts,
- Tree maps, Word clouds, Bubble Charts, Pareto Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on client's need.
- Built reporting against Single, Multiple Tables, Views and Complex Custom SQL
- Converted Pearl Script Query in to SQL Query for ETL.
- Created reports in Tableau using SQL Queries and Stored procedures.
- Created reports using Custom SQL for complex report views.
- Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, and parameters.
- Scheduled data refresh on Tableau Server for Daily/weekly/monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
- Develop parameter-based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop.
- Migrated all dashboards from Tableau 9.3 to 10.3 and 10.5 to 2018.1
- Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many reports.
- Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
Environment: Tableau Desktop (9.x/10.x/2018.x), Tableau Server (9.x/10.x), Teradata, SAS, Flat files, Oracle, SQL, Microsoft Power BI, Microsoft Project 2016, MS Access 2016, Windows 2008 Server.
Oracle9i/10G, Pl/SQL, SQL, SQL developer, UNIX (Putty), Tableau 7.x
Confidential, Grapevine, TX
Tableau Developer
Responsibilities:
- Oversee the performance of design to develop technical solutions from Analysis documents.
- Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel.
- Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and Tableau.
- Involved in creating views, stored procedures, and custom SQL queries to import data from SQL server to Tableau.
- Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
- Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
- Tableau Logs - Reviewing the Server logs for any errors or security issues that are unexpected.
- Performance Logs - Reviewing the performance metrics to determine if the baseline exceeded or for the slow points during the day that need to be reviewed.
- Tested reports and uploaded Tableau dashboards on to server and provided production support for Tableau users.
- Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
- Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
- Created Custom Hierarchies to meet the Business requirement in Tableau.
- Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
- Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
- Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
- 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.
- Oracle Backups - Checking/Verifying all the backups to validate that they were successfully created.
- Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
- Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
Environment: Tableau Desktop 7/8, Tableau Server 7/8, MYSQL Server, Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Oracle 10g, Excel, UNIX, SQL Server 2008, Oracle 11g, Toad, MS Office 2013, Visual Studio 2010.
Confidential, Atlanta, GA
Tableau Developer
Responsibilities:
- Created Interactive dashboards with complicated Layouts.
- Created different kinds of chart, Drill down, Actions.
- Worked on complicated calculations like 12 months rolling, 3 MTD, YTD, YOY%, QTD
- Worked on LOD Calculations and Table Calculations
- Worked on URL Actions and Filtering Actions.
- Create few reports by using Salesforce Web data connectors.
- Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management
- Created Index page for dashboards and done drill down by using Filter Actions.
- Creating database maintenance plan for performance of SQL Server, which covers database integrity checks, update database statistics and re-indexing
- Worked with Tableau administrator in managing Production, Test and Development environments.
- Used data blending feature in tableau and defined best practices for Tableau report development
- Publish the reports to the server and provided the required access to the users and groups.
- Scheduled all the reports and extracts on priority basis.
- Created the Views in Tableau Server.
- Daily basis interaction with Clients for Report development and requirement gathering.
- Code Development, Unit Testing, Data validations, documentation, meeting with customers and Dependent technical teams are like daily activities.
- Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
- Provided support for Tableau developed objects and understand tool administration.
Environment: Tableau Desktop 8.2 & 9.3, Tableau Server, Oracle SQL Server R2, MS Excel, T-SQL.