We provide IT Staff Augmentation Services!

Sr Tableau Developer Resume

0/5 (Submit Your Rating)

Cincinnati, OhiO

SUMMARY

  • Over 8 years of experience in SQL Developer/SharePoint Developer. Design, Development, Data Warehousing projects using Tableau, Micro Strategy, etc. in Finance, Health Care, Marketing, and Retail and Payroll Services industries.
  • Extensive experience in creating UI visualizations with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.x/8.x/7.x/6.x.
  • Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
  • Proficient in creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bubble Charts, Funnel Charts, Bar Charts ( Horizontal, Stacked), Bullet Graphs, Area Charts, Scatter Plots, etc.
  • Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
  • Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
  • Involved in installation of Tableau desktop 8.2, Tableau server Application software
  • Involved in creating dashboards and reports in Tableau … Created report schedules, incremental refreshes for data sources on Tableau server.
  • Experience in Configuring Interactive Dashboards with Drill - Down capabilities using Filters and Dashboard prompts.
  • Developed many Reports / Dashboards with different Analytics Views (Drill-down / Dynamics, Pivot table, Chart, Column Sector, Narrative view) with local and global filters using OBIWeb.
  • Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services SSIS/DTS.
  • Experienced in tuning long running SQL queries for better performance.
  • In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
  • Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
  • Experience in Developing Performance Dashboards, Score cards, Metrics, What if analysis, Prompts, Drills, Search (using Add-ons),Reports/Dashboards for all the functional areas including Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Supply Chain, and Transportation, Sales/Marketing, Variable Objects with formulas.
  • Knowledge in all the Latest BI Tools Tableau, Qlikview Dashboard Design, and Spotfire.
  • Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development lifecycle
  • Creating dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects.

TECHNICAL SKILLS

Business Intelligence: Tableau 7x/8x/9x, Tableau Server, Retrieving data using Universes, MapBoxData Base HANA, Database Integration and Management among MS SQL Server, Oracle, MS Access, Teradata 12.0/V2R5/V2R4, Oracle 11g,10g/9i/8i/7.x, MS SQL Server 2005/2000/7.0/6.5

Packages: MS Office 2007/2010/2012 , Excel 2007/2010/2012

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, Ohio

SR Tableau Developer

Responsibilities:

  • Created scorecards for BM’s,RMM’s& RM’s to set the limits of credit for their customers by sending dynamic position ID with parameters functionality.
  • Confidential created CRM Pipeline dashboard for RMM’s to see the time spent for Confidential customer in each stage.
  • Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Created rich maps using Map Box services.
  • Migrated dashboard’s data sources from excel to HANA views.
  • Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
  • Used LOD’s extensively.
  • Connected Tableau server to publish dashboard to Confidential central location for portal integration.
  • Connected Tableau server with share-point portal and setup auto refresh feature.
  • Created visualization for logistics calculation and department spend analysis.
  • Maintained Test log and Wrote test Evaluation, Summary Reports.
  • Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
  • 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.
  • Restricted data for particular users using Row level security and User filters.
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Provided 24/7-production support for Tableau users.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
  • Generated context filters and data source filters while handling huge volume of data.
  • Built dashboards for measures with forecast, trend line and reference lines.
  • Published Workbooks by creating user filters so that only appropriate teams can view it.
  • Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
  • Created Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily.
  • Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
  • Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Environment: Tableau Desktop 9.x/8.x, Tableau server,BEX3.x/7.x, Analysis for Office, Map Box,HANA,MS Access, Windows 2008server, Teradata, MS Office 2012,SEBEL.

Confidential, Columbus, Ohio

Sr.Tableau Developer

Responsibilities:

  • Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Transformed TABLEAU into Confidential managed service offering for consumption across Corporate Treasury and Corporate Investments.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data. Scheduled data extracts on Confidential daily basis.
  • Working with team of developers designed, developed and implement Confidential BI solution for Sales, Product and Customer KPIs.
  • Developed Confidential 360 business dashboard with multiple panels and parameters that became Confidential favorite sales tool for most of the sales force at CE.
  • Implemented Tableau mobile dashboards via Tableau mobile application.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Gather data from different data sources like MySQL, Excel.
  • Develop reports, dashboards using Tableau 8.3 for quick reviews to be presented to Business and IT users.
  • Developed POCs by building reports and dashboards using Tableau 8.3 to demonstrate quick wins.
  • Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
  • Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
  • Developed Ad-hoc reports using Tableau Desktop, Excel.
  • Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
  • Involved in project planning, scheduling for database module with project managers.
  • Created new Data source and replaced with existed Data source. Created Schedules and extracted the data into Tableau Data Engine.
  • 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.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Effectively used data blending feature in tableau. Defined best practices for Tableau report development.
  • Created lot of custom reports for the pathologist using complex stored procedures and Crystal reports.
  • Created Standard, Cross-tab, Sub reports and TAT reports for Pathology department management.

Environment: Windows 7,Tableau 8.x, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL.

Confidential, New York City, NY

Tableau Developer

Responsibilities:

  • Consolidated multiple Tableau workbooks into single workbook for Amex TVO group single source Tableau report central
  • Developed Tableau visuals for Controls and Compliance team mapping banking regulations to internal policies, standards, and processes to be used in presentations for AMEX leadership
  • Cleaning and blending multiple data sources to allow for different views on application data in Confidential single dashboard.
  • Designing data model from scratch to aid team in data collection to be used for Tableau visuals
  • Conducted presentations to other lines of business as Confidential Meta role to show value of Tableau as Confidential BI tool.
  • Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.
  • Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
  • Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
  • Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
  • Designing and Developing Dashboards using Tableau for various ROI metrics.
  • Automate monthly excel reports into Tableau Workbooks and Dashboards.
  • Design Dashboards using Filters, Parameters and Action Filters
  • Produce standard monthly reports using Tableau.
  • Design and develop Tableau visualization solutions.
  • Work on generating various dashboards in Tableau server using various data source
  • Install upgrade Tableau server and server performance tuning for optimization.
  • Administer user, user groups, and scheduled instances for reports in Tableau.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Defined best practices for Tableau report development.
  • Prepare Dashboards using calculations, parameters in Tableau.
  • Proof-read all documents and maintain accuracy of information and preparing SOP.
  • Responsible for Developing Dashboard and preparing ad-Hoc Reporting.

Environment: Tableau Desktop 7.x Tableau Server, Microsoft Office 2007, SQL Server 2008, PL/SQL, T-SQL.

Confidential, Fremont, CA

Tableau Developer

Responsibilities:

  • Involved in project planning, scheduling for database module with project managers.
  • Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine.
  • 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.
  • Created Tableau scorecards, 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.
  • Effectively used data blending feature in tableau. Defined best practices for Tableau report development.
  • Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get Confidential better understanding of the Business Processes.
  • Worked closely with end users in identifying and implementing right set of business criteria to convert raw data into meaningful information.
  • Collaborate with business leadership to identify potential areas of analysis
  • Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
  • Prepared dashboards using calculated fields, actions, parameters, groups, sets and hierarchies in Tableau.
  • Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. in Confidential single dashboard by using parameters.
  • Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes.
  • Effectively used data blending feature in Tableau to combine the data from different sources like Adobe marketing cloud into Confidential single report.
  • Defined best practices for Tableau report development.
  • Found efficient ways to make tables and graphs that were visually easy to understand and at the same time maintaining the accuracy of the core information content.
  • 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.

Environment: Windows 7,Tableau 6.x, tableau server, MS-Excel, SQL Server, Microsoft office, Jdeveloper, SQL-PLUS, C++, Visual Basic.

Confidential

SQL Developer

Responsibilities:

  • Experience in writing SQL queries and optimizing the queries in SQL Server 2008.
  • Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraints.
  • Performeddata analysisanddata profilingusingSQLon various sources systems including SQL Server 2008.
  • Planned & Facilitated Joint Application Development (JAD) sessions Designed/developed database using SQL SERVER 2008.
  • Developed all the required stored procedures, user defined functions, triggers using T-SQL.
  • Created High level Normalized Database and Detail Design using Erwin. Used Enterprise Manager to create schema and Analysis Manager to create OLAP cubes.
  • Designed and created the Star schema for OLAP .Supported OLAP team to provide data from SQL Servers.
  • Fine-tuned queries, assigned proper Indexes for better performance.
  • Prepared Patch and upgrade scripts for service packs and new releases
  • Interacted with business users and managers and gathered the database needs of the various business groups for reporting purposes.
  • Implemented automatic delivery of the report using subscription options. Responsible for implementing security at report server and reports level using the predefined roles as well creating user defined roles.
  • Created reports with query parameter to present only the required data to the users and reduce the required data retrieval time.
  • Responsible for configuring Report server and report manager using reporting server configuration manager.

Environment: SQLServer2008/2005, SSIS, SSAS, SSRS, ER-Win, Windows XP/2003, Windows NT.

Confidential

SharePoint Developer

Responsibilities:

  • Involved in gathering and preparation of requirements specification documents.
  • Creating Sites, Lists, Libraries.
  • Involved in using Microsoft Cloud technologies including Office 365 and SharePoint Online.
  • Migrated existing BCBS Portal from MOSS 2010 to MOSS 2013 using Metalogix migration tool.
  • Migrated SP Farm from SharePoint using db attach method which involves restoring, mounting, upgrading content databases.
  • FMR consists of an InfoPath form library with different content types to enable users to request for Confidential change in the project requirement.
  • Request for Confidential change in the project requirement has to undergo different level of approvals.
  • Created different views in InfoPath forms.
  • Used SharePoint Web services in InfoPath.
  • Created Confidential visual studio workflow using CAML queries and object model to detach an attachment from the InfoPath form and store it in Confidential document center.
  • Developed custom scheduler Web Part for integrating custom corporate calendar events and outlook resource management using SharePoint Client Side Object Model (CSOM).
  • Sending notifications through email using visual studio workflow.
  • Used client side, XML technologies like CSS, HTML5, JQuery, XML, and XSLT.
  • Created custom web service to send the data from InfoPath form to SQL database.
  • Used SPServices in JQuery to query the list and update the list item.
  • Created Dashboards in SharePoint2013 using Excel Services and KPI Lists for displaying key data and metrics to managers.
  • Customized CSS styles to change the look and feel of New, Edit and Display form.
  • Deployed WSP’s and Features using Power Shell comments.
  • Created custom action.
  • Created application page with user controls.
  • Created BI apps, dashboards, scorecards, etc., using Performance Point and Dashboard Designer. Worked extensively with Performance Point and Dashboard Designer.
  • Used Photoshop to create images.
  • Designing the database.
  • Creating tables, stored procedures, user defined functions.
  • Creating SharePoint groups and giving permissions.
  • Involved in creating reports using Enesys RS Data Extension and SSRS.
  • Involved in team meetings to clarify the requirements.
  • Involved in deployment and testing.
  • Demonstrating the project.
  • Fixing Production issues.

Environment: SharePoint2007, Visualstudio2007, Office 365, SQLsever2008, C#, SSRS, EnesysRSDataExtension, TortoiseSVN, JQuery, SharePoint Designer.

We'd love your feedback!