Tableau Reports Developer And Analyst Resume
Bothell, WA
PROFESSIONAL SUMMARY:
- Extensive experience of 6+ years in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9, Tableau 9.1,Tableau 8.3,8.2, 8.1, 8.0, Tableau 7 and Tableau 6.
- Tableau/BI Developer with IT Experience in Business Intelligence and Data Warehousing applications in Retail, Financial, Health Care, Pharmacy and Manufacturing industries.
- Extensive working experience in creating visualizations and Dashboards using Tableau Server, Tableau Desktop and Tableau Public.
- Experience with Dimensional modeling, star and snowflake schema.
- Good Understanding knowledge of Ralph Kimball & Bill Inman Methodologies
- Experience in Data Analysis, Dimensional Data Modeling, Data Extraction Transformation & Loading (ETL), Building Cubes, Creating Meta layer, Data Mining, End User Reporting; Web based Reporting & Implementation, Creating Test scripts and user signoff documents.
- Experience in creating reports using BO/Crystal/Tableau/Cognos reporting Applications.
- Extensively created and maintained complex Business Objects Universes and Reports using the Designer and Reporting modules.
- 4 years of Tableau experience with extensive knowledge as a Tableau Developer/SME & Server Administrator with strong understanding of Tableau Architecture, providing the best practices for deployment and maintenance of Enterprise class dashboards on Tableau Server.
- Extensively involved in design and development of Tableau visualization solutions using operational dashboards, reports, workbooks on various flavors of RDBMS like Oracle, Teradata and MS SQL Server.
- Very good at implementing Tableau visualizations and dashboard design with best practices to facilitate in - depth analytics and decision making among business users.
- Developed Interactive Dashboards, Analytics in Crystal Xcelsius using Live Office
- Experience using Business Objects Administration, Web-Intelligence, BO Developer Suite using SDK, Application foundation. Broadcast Agent, Auditor, Web Admin tool, Supervisor, Designer, Web Intelligence/Info view
- Testing, Debugging Reports, Managing server for Crystal Reports, Worked in Development, Quality and Production Environments. Preparing Report Prototype, Prepared Report Design Document, Prepared User test cases for the report
- Strong technical background, and possess excellent analytical & Communication skills, Creativity, Leadership qualities, Team spirit & above all a Positive attitude to shoulder successfully, any responsibility or challenges.
- Strong experience in building Dashboards/Business Visualizations using Crystal Xcelsius against multiple data sources for What if Analysis, Interactive, Decision Support and other purposes.
- Extensive experience building DashboardsUsing Advanced Multiple Drill Down, Dynamic Visibility, and Alert Features with Flash Variables, web services.
- Professional in writing complex formulas, sub reports and summary reports.
- Very good hands-on experience in writing complex SQL scripts/ queries to perform End-to-End
- Experience in requirement gathering and designing windows and web application solution andDesign Patterns.
- Excellent interpersonal and customer relational skills. Proven communication, presentation skills and leadership qualities.
- Ability to handle multiple tasks and work independently as well as in a team.
TECHNICAL SKILLS:
Reporting Tools: Tableau 9/8, BO 4.1/3.1, Crystal Reports 2008 /XI R3/ XI R2 / R1 / 10 / 9 / 8 (Designer, Reporter, Supervisor), Auditor, Performance Management, Application Foundation, Microsoft Visual Studio SDK using ASP,BO SDK Using JSP and Cognos10.
ETL: Data stage 7.5/7.0/6.x, Informatica 8.0/7.1/6.0 (Power Mart & Power Center)
RDBMS: Oracle 10g/9i/8i/7, DB2, TeraData, SQL SERVER 2005/2000, MS-Access.
Internet: J2EE, XML, JSP, ASP, VBScript, JavaScript
Languages: PERL, C++, C, VB, Shell Scripting
OS: AIX, Sun Solaris UNIX, Windows NT/2003/2000/XP.
Tools: ER-Studio 7.3.2.ERwin 4.1/4.0, MS Project, TOAD 6.5 and SQL Navigator 4.1, Data Studio 3.1
PROFESSIONAL EXPERIENCE:
Confidential, Bothell, WA
Tableau Reports Developer and Analyst
Responsibilities:
- Interacted with business users and performed Gap Analysis of Client requirements.
- Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
- Worked closely with business power users to create reports/dashboards using tableau desktop.
- Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
- Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
- Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
- Involved in creating advanced Tableau functionalities such as geographic mapping, data blending, extract optimization to create advanced chart types and visualizations.
- Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
- Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
- Connected Tableau server to publish dashboards and visualizations to central location for portal integration.
- Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
- Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
- Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
- 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.
- Involved in report tuning, caching, specifying query governing thresholds, and report optimizations and created test cases and documented the test results.
- Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
Environment: Tableau Desktop 8.x/9, Tableau Server, Oracle 10g, SQL Server 2008, Toad 9.0, Agile Methodology
Confidential, Round Rock TX .
Tableau Reports Developer and Analyst
Responsibilities:
- Delivered a vision that is aligned with roadmap, along with a plan for evolution and iterative updates.
- Analyze and understand the existing Reporting system, legacy Excel dashboards and critical backend objects to setup the base tables and views exclusively for Tableau visualizations.
- Involve in requirement gathering and interface directly with stake holders and business teams in coordinating the reporting needs.
- Implemented few pilots and given demos to Dept. heads and executives to explain the capabilities and functionality of Tableau tool.
- Lead and drive the Reporting team to develop 4 major Tableau visualizations which accommodates various KPIs and metrics related to Inventory, Demand, Sales and Manufacturing departments.
- Developed dashboards with data being fed from multiple sources like JD Edwards and many other front end legacy systems.
- Dashboards included various components and functionalities involving dual axis, combo graphs/charts, complex conditional formatting, trend lines, parameters, filters (extract, context and quick filters) using Tableau desktop.
- Supported .Net Framework for the tabuleau Interface
- Worked heavily on table calculations and Tableau window functions for KPI’s
- Work with ETL team to setup aggregate tables, data security tables, Source to Target (STT) transformations and data mappings.
- Setup Tableau Schedules and assign dashboards to schedules based on users/group security.
- Worked on converting few SAP Business Objects and Cognos reports into Tableau visualizations.
- Collaborated with internal stakeholders to drive efficiency and effectiveness of the metrics and reporting in Tableau Enterprise.
Environment: Tableau Desktop and Server 9.23/8.x, Big Data, Hive,SQL Server 2012, Management Studio, SAP Business Objects 4.1, Python, Windows OS.
Confidential, Jacksonville, FL
Sr. Tableau Developer
Responsibilities:
- Understanding existing business model and customer's new requirements.
- Created workbooks and Dashboards using calculated metrics for different visualization requirements
- Drew upon full range ofTableauplatform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
- Created dashboard views from provider information data to members
- Extensively created visualization dashboards for the claims
- Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.
- Involved in creating dashboards, reports and then published onto the Tableau server.
- Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
- Incorporated a regional and national comparative / benchmark metrics to give context to Horizon performance
- Effectively used data blending, filters, actions, Hierarchies feature intableau
- Created extensive custom joins for blending data from several different data sources
- Helped customizeTableauServer with Company Logo
- Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics. Created and assisted users inTableaudashboard development
- Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
- Coordinate new data development, which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse with ETL Development team.
- Collaborated with business users and members of the BI team, including business analysts, data warehousedevelopers, and managers, to design and develop as per requirement.
- Created a proof of concept for the optimal data integration process.
- CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality during POC.
- 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
- Created workbooks and Dashboards using calculated metrics for different visualization requirements
Environment: Tableau Desktop 9.1/9.0/8.2, Windows XP, SQL, Oracle 11g, MS Access, MySQL, Flat files, CSV files, MS Excel, MS Visio, MS Word.
Confidential, Southfield, MI
Sr. Tableau Developer
Responsibilities:
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Effectively used data blending feature in tableau.
- Defined best practices for Tableau report development.
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Executed and tested required queries and reports before publishing.
- Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
- Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
- 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.
- Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
- Provided support for Tableau developed objects and understand tool administration.
- Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
- Created Custom Hierarchies to meet the Business requirement in Tableau.
- Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
- Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
- Created various connections, Data foundations and Business layers using Information Design Tool 4.1
- (IDT) for AP Reporting.
- Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
- Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
- Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
- Responsible for developing provisioning reports for various groups and upper management.
- Created Complex Dashboard, Reports using WEBI having multiple metrics and trends and created
- Hyperlinks for each of the Metric to open a detail report using Open Documents
- Experience on writing SQL Queries.
- Experience on BW Analyzer & Query Designer.
- Strong verbal and written communication skills, ability to work effectively with user departments.
- Worked towards the goals of quality, time and budget.
Environment: Tableau Server 8.1/8.2, Tableau Desktop 8.1/8.2, Windows Server Standard R2,, Excel, SQL Server management studio, MS SQL Server 2008R2, UNIX .
Confidential, Detroit, MI
Tableau Developer
Responsibilities:
- Liaison for project managers, directors, and stakeholders.
- Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.
- Conducted gap analysis for re-engineering, and upgrading the current system where ever necessary.
- Develop, derive and clarify functional specifications and Use cases.
- Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
- Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
- Designed the conceptual and business process models.
- Implementation of new systems including the integration of the new system with existing systems.
- Verifying installed systems to ensure that they adequately meet user requirements.
- Physical design of data record data files and databases.
- Involved in writing Test Cases, procedures, reports and approval of software release.
- Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing.
- Designed and Developed Complex Active reports and Dashboards with different data visualizations using Tableau desktop on Sales, Finance data.
- Designed and developed complex views based on reporting requirements in Teradata and used the same as source in Tableau report development.
- Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables to improve the performance of Tableau reports/Dashboards.
- Developed Technical requirements, design requirements and user acceptance documentation by placing Screen shots of actual Report and tested report in documentation.
- Worked with power users in user acceptance testing of various reports/ dashboards in Tableau prior to deployment of same in Production environment.
- Assisted in project management activities like planning, development, task allocation, project execution
- Provided full project life cycle flowcharting, analysis and documentation.
- Deployment of defect free code while managing the timeline set for the project.
Environment: Tableau (Desktop/Server), MicroStrategy (Desktop/ Server), Teradata, Oracle, Teradata SQL Assistant, TOAD, PLSQL Developer, MS VISIO, Microsoft (Word, Access, Excel, Outlook)