Sr Tableau Developer Resume
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.
