We provide IT Staff Augmentation Services!

Tableau Consultant Resume

CT

PROFESSIONAL SUMMARY

  • Over 6+ years of experiencein implementation and administration of Tableau Business intelligence solutions and Microsoft SQL server 2012/2008 - R2/2008/2005 in development, testing & production environment.
  • Deep experience wif teh design and development ofTableauvisualization solutions tohelp users to identify critical KPIs and facilitate strategic planning in teh organization.
  • Frequently recognized for Preparing interactive and effective dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies that add value and address key business questions.
  • Expert in evaluating data models to designTableausolutions and fine tuning dashboards to increase performance.
  • Extensive Experience in various Tableau Desktop reporting features like Measures, Dimensions, Folder, Hierarchies, Extract, Filters, Table Calculations, Calculated fields, Sets, Groups, Parameters, Forecasting, blending and Trend Lines.
  • Extensive noledge in various reporting objects like facts, Attributes, Hierarchies, Filters, Sets, Groups, Parameters in Tableau.
  • Combined Reports & views into interactive dashboards in Tableau desktop and presented to Program Managers, Business users and End Users.
  • Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
  • Broad experience on building dashboards using Tableau and Involved in Troubleshooting, Performance tuning of reports and resolving issues wifin Tableau Server and Reports.
  • Well versed in designing and development of various dashboards, reports utilizing Tableau Visualizations likebar graphs,scatter plots,pie-charts,geographic visualizationandother making use ofactions,otherlocal and global filtersaccording to teh end user requirement.
  • Optimized dashboards performance by performing performance tuning procedures to increase installed and upgraded Tableau server and server performance tuning for optimization.
  • Worked on creation of users, groups, projects, workbooks and teh appropriate permission sets for Tableau server logons and security checks.
  • Extensively used Erwin for Logical Data Modeling, Physical Data Modeling, Logical-to-Physical Transformation, Forward engineering, Reverse engineering, and Model-to-model comparison.
  • Strong noledge of Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schema, SSIS processes, Dimensional Modeling and Reporting tools.
  • Created Parameters to achieve desired functionality and create risk metric analysis by co-ordinating wif users.
  • Strong ability in utilizing Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
  • Well versed in Creating, Deploying and Fine-tuning MS SQL Server Integration Service (SSIS) packages.
  • Strong and practical noledge of business intelligence concepts including Extract Transform and Load (ETL)
  • InstallationandConfigurationofTableauServerandTableauDesktoponWindows.
  • Ensuredmaintenanceandsecuritycontrolof theTableauproducts and solutions.
  • Well versed in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS including tools likeBCP utility, DTS and SSIS 2005/2008 Packageswif proper control flow and data flow elements by using MS SQL Server 2012/2008-R2/2008/2005.
  • Good experience in generating Sub-Reports, Drill down reports, Drill through reports, and Parameterized reports using SSRS 2012/2008-R2/2008/2005.
  • Implemented SSRS server level and item level security, subscription, performance tuning and access various reports in multi-user environment.

TECHNICAL SKILLS

Technical Skills: Tableau Desktop 6/7/8/9, Tableau Server 6/7/8/9, Tableau Online, Tableau Public, Tableau Reader, TabCmd, Microsoft SQL Server 2012/2008-R2/2008/2005, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), T-SQL, PL-SQL, OLAP, OLTP, Erwin Data Modeler v7.0/v4.x, Microsoft Visual Studio 2010/2008/2005,Microsoft Access, Microsoft Office(MS Word/Excel/Powerpoint), MS Project, HTML, XML, Java, C++, C#, Visual Basic 6.0, Microsoft Office Visio, Windows 2008/2003/2000 Advanced Server, Ultra Edit Text Editor, Visual Safe Source 2005 (VSS) .

PROFESSIONAL EXPERIENCE

Confidential, CT

Tableau Consultant

Responsibilities:

  • Develop interactive data visualizations and develop automated processes for updating content used in standardized dashboards.
  • Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary reports and dashboards using KPI's
  • Built compelling, interactive dashboards inTableauthat answer key business questions.
  • Audits teh datasets and data analyzed as required ensuring their continuity, accuracy and consistency.
  • Perform administrative and support activities across a multi-environmentTableauinfrastructure including security administration, release management, troubleshooting and general systems maintenance.
  • Good understanding On Web Analytics and Reporting such as Google Analytics and Adobe Site catalyst.
  • Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
  • Creates Users, User GroupsandProjectsthroughTableauServer Web and assignedroles and permissionsforTableauUsers Hold responsibility for integration points and teh order in which these must be executed.
  • Worked wif Business Analysts and Business users to understand teh user requirements, layout of developed applications.
  • Analyzed source data and handled efficiently by modifying data types.
  • Used Excel Sheets, flat files to generate tableau adhoc reports.
  • Generated Tableau dashboards for sales wif forecast and reference lines.
  • Created adhoc reports to users in tableau by connecting various data sources.
  • Creating visually compelling and actionable interactive reports and dashboards.
  • Ensured allprojectrequirements and objectives are properly documented and pursued.
  • Created conditional filters to filter teh data on dashboard.
  • Creating Parameters for desired functionality.
  • Responsible for developing, analyzing and reporting key risk indicator and keyperformance indicator metrics that enable management to make timely and effectivedecisions related to threats, risks and control requirements.
  • Accomplished development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.
  • Reviewed, assessed and promoted adoption and standardization ofTableausupport solutions.
  • Generated insights out of voluminous and complex datasets and built story lines.
  • Produce complex table calculations, use of parameters, actions, filters and other advanced options inTableau.
  • Design excellent tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for teh business.
  • Involved in reviewing business requirements andanalyzingdata sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects wifinTableauDesktop.
  • Create views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
  • Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per teh business requirements
  • Optimized existing stored procedures and various T-SQL queries
  • Wrote Dynamic Store Procedure to move data from Staging to Application
  • Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing teh T-SQL statements using SQL profiler
  • Added more audits and alerts in SSIS Packages in case of package failure

Tools & Technologies: Tableau Desktop 9, Tableau Server 9, MS SQL Server 2012, MS SQL Server Integration Services, Microsoft Office Visio, Microsoft Safe Source 2005 (VSS), Erwin r8, Ultra Edit tool, SharePoint, C#.

Confidential, Batesville, IN

Database Developer/Tableau Developer

Responsibilities:

  • Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
  • Performance Tuning and interacting wif Business users for UAT and Reports Modifications.
  • Held responsibility for integration points and teh order in which these must be executed.
  • Built compelling, interactive dashboards inTableauthat answer key business questions.
  • Audited teh datasets and data analyzed as required ensuring their continuity, accuracy and consistency.
  • Mentored less experiencedTableaureporting specialists.
  • Performed administrative and support activities across a multi-environmentTableauinfrastructure including security administration, release management, troubleshooting and general systems maintenance
  • Accomplished development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.
  • Reviewed, assessed and promoted adoption and standardization ofTableausupport solutions.
  • Generated insights out of voluminous and complex datasets and built story lines.
  • Produced complex table calculations, use of parameters, actions, filters and other advanced options inTableau.
  • Designed excellent tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for teh business.
  • Involved in reviewing business requirements andanalyzingdata sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects wifinTableauDesktop.
  • Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
  • Supported teh system management, implementation projects, and other initiatives of HR transformation for teh SAP HR system. Performed integration analysis and maintained master data to ensure correct integration of HR components: Personnel Administration, Organizational Management, Payroll, Compensation Management, Time Management, and teh Benefits interfaces
  • Blendeddata frommultiple databases into one report by selecting primary keysfrom each databasefor data validation.
  • Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
  • Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand teh data on teh fly wif teh usage of quick filters for on demand needed information.
  • Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business changes to ensure that teh views and dashboards displayed teh changed data accurately.
  • Tested dashboards to ensure data was matching as per teh business requirements and if their were any changes in underlying data.

Tools & Technologies: Tableau Desktop 8, Tableau Server 8, MS SQL Server 2012, MS SQL Server Integration Services, SAP, MS Visual Studio 2010, Microsoft Office Visio, Microsoft Safe Source 2005 (VSS), Erwin r8, Ultra Edit tool, SharePoint, C#.

Confidential, Chicago, IL

Tableau/ SQL Server Developer

Responsibilities:

  • Gatheird Business Requirements, interacted wif teh Users, Project Manager and SMEs to get a better understanding of teh Business Processes.
  • Develop, Organize, manage and maintain graphs, tables and document templates for teh efficient creation of reports.
  • Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
  • Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
  • Extensively usedcalculatedfields for different logics for Trend, Extended price calculations for teh different cost types.
  • Foundefficientways to make tables and graphs which were visually easy to understand and at teh same time maintaining teh accuracy of teh core information content.
  • Created visualizations for logistics calculations and departmental spendanalysis.Utilizedsample data to create dashboard while ETL team were cleaning data from source systems,and wasresponsible for replacing teh connection to Oracle 10g
  • Used SQL Queries at teh custom SQL level to pull teh data intableaudesktop.
  • Validated teh results inTableauby running SQL queries in Oracle SQL developer.
  • Attended daily standup meetings to update scrum master wif what is achieved, what is being done and is their any impediment.
  • Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
  • Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented teh feedback and incorporated teh necessary changes.
  • Performed performance tuning of teh dashboard inTableaudesktop.
  • Published teh developed dashboards into production and ensured teh data was up to date by scheduling extract refreshes.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading teh data into teh Data warehouse.
  • Involved in teh development of SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate teh data.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Tools & Technologies: Tableau Desktop 7, Tableau Server 7, MS SQL Server 2008 R2, SAP, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2008, Erwin r7

Confidential

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding teh functional work flow of information from source systems to destination systems for mortgage loan products.
  • Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
  • Elaborated in complete SSIS life cycle in creating SSIS packages, building, deploying and executing teh packages in both teh environments (Development and Production).
  • Used various Transformations such as for loop container, For Each loop container, Execute package task, FTP task, Bull Insert task, Script task in SSIS Control Flow and Row sampling, Fuzzy Lookup, Fuzzy Grouping in SSIS Dataflow.
  • Involved in ETL architecture enhancements to increase teh performance using query optimizer.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Created SSIS packages for Data Conversion using data conversion transformation.
  • Configured teh loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
  • Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
  • Designed and created Report templates, bar graphs and pie charts based on teh financial data regarding competitive rates and financial market.
  • Developed various types of complex reports like Drill Down, Drill through, linked reports, cascading parameter reports for business loan, first time buyer or refinancing home mortgage.
  • Involved in scheduling, creating snapshots and subscriptions for teh reports using SSRS 2008.
  • Perfected in designingParameterized Reportsand Matrix Reports for generatingAd-Hocreports as per teh client requirements.
  • Coordinated wif front-end for implementing logic in stored procedures and functions.
  • Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement teh business logic and also created clustered and non-clustered indexes.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Advised optimization of queries by looking at Execution Plan for better tuning of teh database.

Tools & Technologies:SQL Server 008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TSQL, C#, .Net framework, XML, MS Visual Source Safe, MS Visio 2007.

Hire Now