Tableau Developer/admin Resume
Nashville, TN
SUMMARY
- Over 7+ years of experience in IT working as a Tableau - Analysis, Development, Administration, Implementation, Testing, Support and data Warehouse and Database solutions.
- Skilled in Tableau Desktop version 8.3,9.0 for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
- Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mark Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
- Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
- Good experience on Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using Fact and dimension tables and relational databases (Oracle), Mainframes, MS Access and client/server applications.
- Experience in configuring reports from different data sources using Data Blending
- Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security
- Hands on experience on Tableau Desktop, Tableau Server and Tableau Viewer.
- Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements
- Experience Designing and Developing Reports using Crystal Reports, Cognos and SSRS.
- Improved Reports performance in tableau using Extracts and context Filters
- Hands on experience in installation, administration and configuration of business intelligence tools like Tableau Server and Tableau Professional.
- End to end implementation experience in designing and deploying data visualizations using Tableau
- Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
- Results oriented, self-starter looking for challenges, ability to rapidly learn & apply new technologies & good interpersonal skills
- Expertise in preparing code documentation in support of application development, including high level and detailed design documents, unit test specifications, interface specifications, etc.
- Excellent Communication, Analytical and Programming skills
- Experience in full life cycle development (SDLC)
TECHNICAL SKILLS
BI/Visualization Tools: Tableau Desktop 8.1/8.2/8.3/9.0 , Tableau server 8.2,8.3, Tableau Reader, SSRS, IBM Cognos, Crystal Reports 8.5/9.0/10/11.5/12.
Programming: C, C++, Java, XML &HTML, SQL
Utilities: MS Office Suite, MS SharePoint, MS Project
Databases: Oracle 10g/11i/12c, SQL Server 2008 R2, Teradata, MS Access, MS Excel
OS Platforms: Windows7/8/2003/NT, Mac OS, DOS, UNIX, Linux
ETL Tools: Informatica, SSIS
PROFESSIONAL EXPERIENCE
Confidential, Nashville, TN
Tableau Developer/Admin
Responsibilities:
- Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
- Generated Ad-hoc Tableau reports based on user requirements.
- Combined multiple data sources by joining tables and using Data Blending.
- Generated Tableau reports with Trend lines, Reference lines and Bands and also generated several drill down and drill up reports.
- Worked on Groups, Sets, different calculation functions including Table calculations.
- Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
- Created dashboards with the security using filters for the clients to measure cost saving.
- Performed end-to-end Data Analysis and ensured the data quality gaps are identified.
- Designed and developed Business Intelligence end to end solutions using Tableau.
- Published Workbooks by creating user filters and security, so intended teams can view it.
- Created visualizations in Tableau using Excel data extract source, wrote Test Cases and documented the Test Results.
- Developed tableau dashboards with combination charts for clear understanding.
- Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
- Build complex calculations using advanced functions (ATTR, DATEDIFF, STR, IFs, nested IFs, OR, NOT, AND, SUMIF, COUNTIF, LOOKUPs and QUICK TABLE calculations).
- Performance tuning by analyzing and comparing the turnaround times between SQL and Tableau Involved in design and implement tableau security, and worked with other team members to establish right physical architecture/layout.
- Performed administrative and support activities across a multi environment tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
- Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
- Provided 24/7 production support for Tableau users.
Environment: Tableau Desktop 8.3,9.0, Tableau server / Administrator, SQL developer, SQL-Server 2008/2005, MS-Access, Oracle 11i/11g/12c, SQL,MS Office, Excel, Outlook, Word, PowerPoint, Windows,Unix
Confidential, Lincolnshire, IL
Tableau Developer
Responsibilities:
- Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
- 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.
- 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.
- Developed database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
- Followed AgileScrumprocess to streamline development process with iterative and incremental development.
- Created highly interactive visual Reports using Tableau.
- Designed business intelligence dashboards using Tableau (Desktop/Server), allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
- Gathered, documented requirement from the users and developed Complex Graphical User Interactive reports using various Tableau Objects.
- Strong Skills in Data Modeling & Loading data from multiple data sources.
- Actively involved in deployment and post release support.
- Validated technical design created by developers against functional specifications.
- Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
- Provided formal project presentations to the client, executive management and line staff as required
- Integrated Crystal Reports to Tableau.
- Worked closely with sales, marketing, and production business units to perform business and system analysis.
- Proof-read all documents and maintain accuracy of information and preparingSOP
- Provide Weekly, Monthly metrics and presentations to management on production issues.
Environment: Tableau Desktop 8.2/8.3, SQL Server, oracle 11g,12c, SQL Developer, PL/SQL, Windows, Crystal Reports
Confidential, Richmond, VA
Tableau Developer
Responsibilities:
- Extracting the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input toTableau.
- CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps,Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
- Defined best practices forTableaureport development.Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
- Worked on functional requirements sessions with business and technology stakeholders on data modeling, integration, and configuration for data warehouse with automated and manual field data collection systems
- Coordinated database middleware issues with DBA's, system performance with System Architects.
- Provided 24/7 production support for Tableauusersand conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated throughTableaudesktop.
- Created SQL Queries for testing the tableau Dashboards.
- Designed and developed reports such asDrill down, Drill Through usingMicrosoft Reporting Services (SSRS)
- Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions
- Optimized queries by looking at Execution Plan for better tuning of the database.
- Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.
Environment: Tableau Server 8.1/8.2, Tableau Desktop 8.1/8.2,MS SQL Server 2008, Oracle 10g, SQL BI Suite (SSIS, SSRS, SSAS) Visual Studio 2010, Windows
Confidential
Tableau Developer
Responsibilities:
- Worked with business process owners in collecting project specifications and their analysis.
- Write SQL Ad-hoc reports to feed business teams with feedback on application
- Create the database business objects; develop stored procedure based on the business logic.
- Designed and Developed various Reports in PL/SQL
- Extensive experience in creating Reports with charts (Bar charts, Pie charts etc),Cross tabs and sub reports.
- Analyze requirements and write technical specifications with the business analyst to develop reports that confirm to the enterprise standards.
- Generate a list of deliverables for the team, make cards and ensure they are delivered using Agile methodology.
- Performed Business analyst responsibilities like collecting requirements and draft the functional specifications.
- Followed Microsoft SQL and database best practices to improve the operational reporting environment while focusing on resolving problems reused by team members, stake holders and end users.
- Solid understanding of database concepts and data warehousing methodologies & best practices.
- Extensively participated in the development of the universe based on underlying relational (data structures), Star Schema.
- Resolved several issues with regards to the contest, predefined conditions, same prompts, handling multiple data sources.
- Integrated Cognos reports to tableau.
- Use a comprehensive range of business and time calculations.
- Create new and modify existing Cognos reports for operational reporting.
- Build long-term tools and procedures to enable self-service access to data for customers.
- Identify application issues and develop SQL fixes.
Environment: Tableau Server 6.1, Tableau Desktop 6.1, Oracle 10g/11i/11g,SQL plus, PL/SQL,IBM Cognos, DWH Concepts, SQL Developer, MS SQL 2008, Windows.
Confidential
BI/SQL DEVELOPER
Responsibilities:
- Create Entity Relationship (ER) Diagrams to the proposed database
- Designed and tested solutions to existing database structure, Teradata SQL queries, stored procedures, views, triggers and functions.
- Queried the databases, wrote test validation scripts and performed the System testing.
- Practical experience in managing the internal and external Teradata database security.
- Provided insightful ideas for developing effective and accurate codes - Evaluated latest technology on the market and made recommendations to clients to integrate new designs as available by new technology.
- Conducted root cause analysis and advanced performance tuning for complex process and functionality.
- Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions using DWH concepts.
- Trained and mentored EBI team, users and assisted and coached them in material, processes and delivery of training, training standards and best practices.
- Modeled business and system process based on finding through use case scenarios, workflow diagram and data models.
- Documented the logical and physical components of operational database and their functionality during the course of work.
- Support the Growth leaders and Customer value team with all technical questions
Environment: oracle 9i/10g, SQL plus, SQL Developer, Data ware house concepts, Oracle PL/SQL, Windows, Teradata.