We provide IT Staff Augmentation Services!

Tableaulead Developer/admin Resume

New York, NY

SUMMARY:

  • Over 8.5 years of extensive experience in database design, development and administration with Tableau 2019/2018/10/9 BI/MS SQL Server versions 2016/2014/2012/2008 R2/2008, SAP ABAP, T - SQL in various industries
  • Designingand development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts and Geographic Visualization
  • Created technical specifications by understanding the Business requests.
  • Migrated Teradata,Salesforce data to Snowflake .
  • Experience in development, implementation, deployment of tableau reports.
  • Involve in development of Tableau visualizations which includes Preparing Dashboards using cross-database join, joins, calculations, parameters, calculated fields, groups, sets and hierarchies.
  • Implemented actions, other local and global filters according to the business/client requirement to make workbook and dashboard more interactive.
  • Using Tableau Data blending blended data from different data sources (Flat File, MS Excel, MS Access, SQL Server, SalesForce,Amazon Redshift,Oracle, Teradata and many more.)
  • Expertise in Tableau DataExtracts,DataBlending,Dashboard actions, Row Level Security etc.
  • Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, and embedding views.
  • Involved in publishing of various kinds of interactivedatavisualizations, dashboardsand workbooks from TableauDesktopto Tableau Servers /Online.
  • Strong experience in creating T-SQL objects, working with DDL/DML, creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency and also involved in performance tuning
  • Experience in SDLC with Agile and Waterfall development methodologies.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop 2018.1,10.2, 9.0, 8.1, 7.0,Power BI,QlikView,TFS

Domain Areas: Finance, Retail, Health Care and Pharmaceuticals

Data Bases: MS SQL Server 2016/2014/2012/2008 R2/2008, MS SQL SSRS, MS SQL SSAS, MS SSIS, DB2, Oracle 9i/10g, T-SQL, PL/SQL, ODBC

Languages: C, C++, SAP ABAP

Web Technologies: VB 6.0, ASP.NET, HTML, XML, XSL, CSS

Office Applications: Microsoft SharePoint, MS Office (Word, Excel, MS-Access, Visio, PowerPoint)

Other Technologies & Tools: Jira, Visual studio, Erwin 9.64/9.5/8.2 , Crystal Reports, Power BI, SAS

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

TableauLead Developer/Admin

Responsibilities:

  • Developed Tableau dashboards and workbooks for Higher level executives to assist in their executive decision-making process.
  • Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
  • Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
  • Created Tableau workbooks, dashboards using stack bars, donut charts, bar graphs, scattered plots.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created reports to retrieve data using Stored Procedures that accepts parameters
  • Automated the process of uploading the data into SQL tables by creating the stored procedures.
  • Created SAS jobs and procs in order to call the stored procedures.
  • Deployedand scheduledSAS jobs for automating the stored procedure and upload the data automatically into respective tables on every particular day of the month.
  • Managed offshore resources by distributing work and reviewing the quality before presenting to the client. Provided consolidated status weekly status report to the upper management.

Tools: MS SQL Server 2016/2014, SSIS, SSRS,Tableau 2019.3, T-SQL, TFS,SAS Enterprise, Jira, Microsoft SharePoint, Visual Studio, MS Office (Excel, MS-Access, Visio)

Confidential, Bridgewater, NJ

TableauDeveloper/Admin

Responsibilities:

  • Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines.
  • Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
  • Designed and developed various analytical reports from multiple data sources by blending data in Tableau Desktop.
  • Created different KPI's using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations, aggregation options and Logical functions)
  • Extract data from Data Mart and flat files,SQL server,Salesforce to Tableau Prep (2018.1), using joins (inner, left, right &outer), unions, pivoting, aggregation, calculated fields, clean the data to create Flows and datasets (. hyper) for further analysis
  • Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
  • Built dashboards for measures with forecast, trend line and reference lines prepared new datasets from raw data files using SQL scripts.
  • Worked a great extent with the design and development of Tableau Desktop which includes preparing dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
  • Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
  • Design interactive dashboards in Tableau Desktop and published them to Tableau Online.
  • Worked with Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
  • Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
  • Created Users, User Groups and Projects through Tableau Online and assigned roles and permissions forTableau Users.
  • Tableau Online account creation and maintenance on various Tableau sites
  • Worked onTabcmd to schedule the report's and setup email reports using command lines.
  • Published Tableau workbooks (.TWB) from Tableau desktop to Tableau Online.
  • Setup sites, projects & local user groups as per functional teams of the organization and implemented Tableaustandard operational process for granting user access and for publishing workbooks, data sources & migration between Tableau Online environments

Tools: MS SQL Server 2016/2014, SSIS, SSRS, Tableau 10.2/2018.1 , T-SQL, TFS,VB.Net, C#, Oracle, DB2, Jira, Microsoft SharePoint, Visual Studio, MS Office (Excel, MS-Access, Visio)

Confidential, Elkridge, MD

Tableau Developer/Admin

Responsibilities:

  • Created Advance connections, join new tables, create manage Extract and Monitor Queries.
  • Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
  • Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
  • Extract data from Data Mart,Teradata and flat files to Tableau Desktop (9.9), create datasets using joins (inner, left, right & outer) and unions, transform and create an Extract for further analysis.
  • Develop and implement Quality Assurance procedures to maintain data consistency and accuracy.
  • Prepared powerful reports by applying Level of Detail (LODs - fixed, included & excluded) calculations, Tableau Functions, Quick Table Calculations, Calculated Fields, Parameters, Filters,ReferenceLines,Sets, Groups, Bins, and other features and capabilities of Tableau Desktop and Tableau Prep.
  • Developed business performance metrics to easily gauge the success of the business/projects.
  • Developed intuitive visualization products using appealing tables, graphs, charts, maps including adopting open sourced visualizations to satisfy specific needs of clients.
  • Developed user friendly dynamic Dashboards and empowered users by enabling them to have multiple selection options using Parameters, Filters and Dashboard Actions/(select, hover & URL) to slice and dice the data and gain in-depth insights to make timely and accurate decisionstorealize sustainable businessgrowth.
  • Scheduled automated refresh of extracted datasets and Dashboards using Tableau Server.
  • Published workbooks, Dashboards, Stories to Tableau Server and shared them to end users
  • Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
  • Responsible for creation of Tableau workbooks, dashboards using stack bars, Pie charts, bar graphs, scattered plots, geographical maps, Gantt charts.
  • Design and optimize existing application database including Data modeling both relational and multidimensional based on business process flows

Tools: MS SQL Server 2014, Visual Studio, SSIS, T-SQL, SSRS, Tableau 9.0,MS Office (Word, Excel, MS-Access, PowerPoint), VB.Net, TFS, SQL Server, Erwin 9.65, Windows 2012, Window 8, Master Data services

Confidential, Hartford, CT.

Tableau Developer

Responsibilities:

  • Planned, Defined and Designed data based on business requirement and provided documentation
  • Gathered data and documenting it for further reference and designed Database using Erwin data modeler
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
  • 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
  • Created reports to retrieve data using Stored Procedures that accepts parameters
  • Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
  • Responsible for Monitoring and Tuning Report performance
  • Created various database object like stored procedures, functions, tables, views

Tools: MS SQL Server 2012/2008, SSIS, SSRS, T-SQL, Tableau 8.1, VB.Net,Visual studio, Erwin 9.5, MS Office (Word, Excel, MS-Access), Window Server 2012, Window 7, SQL Server Agent

Confidential, Greenwich, CT

Tableau Developer

Responsibilities:

  • As part of the Development team, Design and develop innovative dashboard, analytics, and reports.
  • Perform data/systems analysis to determine best BI solution (reports, dashboards, scorecards, data cubes, etc.) using Tableau
  • Develop load scripts for extracting, transforming and loading data into Tableau applications
  • Design and develop new interface elements and objects as required, developed Macros, SET ANALYSIS to provide custom functionality using Tableau
  • Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc.,
  • Developed various data connections from data source to Tableau Desktop for report and dashboard development
  • Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
  • 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 Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Effectively used data blending feature in tableau. Defined best practices for Tableau report development.
  • Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications
  • Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler
  • Conducted user training sessions and supported the requests for enhancements, modifications and new reports

Tools: MS SQL Server 2008R2, Reporting Services (SSRS), Integration Services (SSIS), Tableau 7.0, Microsoft Share Point Server, T-SQL, .NET, C#, CSV, Window Server 2008,Window 7,Erwin 7.0,MS Office (Word, Excel, MS-Access, PowerPoint)

Confidential

SAP ABAP/4 Developer

Responsibilities:

  • Developed an interactive report that displays all Open Sales Orders and their due quantities if partially delivered.
  • Developed batch input program for transaction VF01 to create Bulk Billing Documents in R/3 system.
  • Modified layout sets as per client requirement for delivery note based on stand2ard layout set.
  • Developed a Smartform for Customer Balance which should be sent through mail to the respective mail ids of Customers and also designed and developed a stand-aloneSmartform for Excise Invoice for different plants.
  • Supported in Upgrading from SAP 4.7 to ECC 6.0
  • Developed batch input program for Infotype 0008 to upload the Basic pay information into R/3 system.
  • Developed an interactive report by adding a material group in the selection screen for Material
  • Document List as per the client requirement.
  • Generated a C&F Material Stock Report from the standard T.code.MB5B and MB51.
  • Developed a report for purchase register for both indigenous material and imported material.
  • Developed an interactive report to know the Purchase Requisition for Stock transfer item category between supplying and Receiving Plant.
  • Modified SAP Script (MEDRUCK) for Purchase Orders to suite the requirement.
  • Developed a layout for Vendor Balance Form which should be sent through mail to the respective mail ids of Vendors.

Hire Now