We provide IT Staff Augmentation Services!

Tableau Developer / Administrator Resume

2.00/5 (Submit Your Rating)

Hoboken, NJ

PROFESSIONAL SUMMARY:

  • Over 6 years of experience in Software Development, Implementation and Maintenance of Business Intelligence (BI) and Database Platforms.
  • Experience in Software Analysis, Design, Development and implementing core business software applications.
  • Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in versions of Tableau.
  • Experience in Tableau server installation, configuration and administration & experience in creating Tableau Mobile dashboards.
  • Extensive Tableau experience in Enterprise Environment and Tableau experience including technical support, troubleshooting, report design and monitoring of system usage.
  • Involved in Full Life Cycle Development of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.
  • Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
  • Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
  • Experience in creating aggregates, hierarchies, filters, table calculations, calculated measures.
  • Ability to connect to different data sources from Tableau, presenting the good Visualization of data, Different way of using the filters and parameters.
  • Extensive experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes and data import/export.
  • Experience in BI Suite for ETL Development DTS/SSIS, Reporting (SSRS) and Analysis SSAS, Performance Point Server, MOSS and Dashboard reporting.
  • Good knowledge of Data warehousing, Bottom - Up and Top-Down Design methodologies, Operational Data Store (ODS), OLAP, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables using Analysis Services.
  • Strong experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints, Indexes and Batch Scripts using various DDL and DML commands.
  • Quick learner, Proactive, self-motivator and highly adaptable to challenging work assignments/roles.
  • Regular communication with Client on gathering the requirements, discussions and in resolving the issues & concerns.
  • Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

Languages: SQL, T: SQL, PL/SQL, HTML, XML, C, C++, CSS, C#, JAVA/J2EE, JavaScript, ASP.NET

Specialties: Data Visualization, Business Intelligence (BI), Software Management and SDLC, ETL, Data Collection.

Database Tools: MS SQL Server Enterprise Manager, MS Office, SQL Server Management, MS Visual Studio, RDBMS SQL Server 2005/2008/2012/2014.

Tableau and BI Tools: Tableau Desktop, Tableau Server, SSIS, SSAS, SSRS, OBIEEE.

Tools: and Packages: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler Import and Export Wizard, Business Intelligence Development Studio (BIDS), Tableau.

Operating System: Windows, UNIX, LINUX

Documenting and Data Modelling Tools: MS Visio, MS Project, MS Office (Word/ excel/ Access/ PowerPoint).

Methodologies: Logical/Physical/Dimensional, Star/Snowflake Schema, OLAP, SDLC (Waterfall, Agile, Iterative).

PROFESSIONAL EXPERIENCE:

Confidential, Hoboken, NJ

Tableau Developer / Administrator

Responsibilities:

  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Converted all existing excel report into Tableau visualizations.
  • Hands on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Working on generating various dashboards in Tableau server using various sources such as SQL Server/Teradata/Oracle/Excel/Text data etc.
  • Involved in the migration of OBIEE reports to Tableau.
  • Involved in the migration of Oracle Discoverer reports toAlteryxApps.
  • Required to create users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Preparing Dashboards using calculations, parameters in Tableau.
  • Involved in creating a dual-axis bar chart with multiple measures.
  • Created report schedules on Tableau server.
  • Developed Tableau data visualization using Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
  • 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.
  • Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
  • Involved in license management SLA's with Tableau support.
  • Developing Dashboards and preparing ad-hoc Reporting.
  • Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
  • Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • Scheduled extract refresh and subscriptions for weekly and monthly reports.

Environment: Tableau 8.x/9.x, SQL Server 2012, Alteryx9.5/10, MS Access, MS Excel

Confidential, Newark, NJ

Tableau Developer

Responsibilities:

  • Involved in designing and deploying rich graphic visualizations with Drill Down and Drop Down menu option and parameterized using Tableau.
  • Extensive worked with Tableau Administration Tool, Tableau Interactive Dashboards and Tableau suite.
  • Designed and implemented proof of concept solutions and created advanced BI visualizations using Tableau platform.
  • Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Involved in creating database objects like tables, views, procedures, triggers, functions using SQL to provide definition, structure and to maintain data efficiently.
  • Created stored procedures, Cursors, Joins in T-SQL.
  • Responsible for creating reports using SQL Server Reporting Services (SSRS) and created various types of reports like table report, trend charts etc.
  • Deployed, Tested and Scheduled SSIS Packages.
  • Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
  • Configured Cache settings which improved the performance of the dashboards and report schedules and also created Custom Hierarchies to meet the Business requirement on Tableau server.
  • Created Workbooks and dashboards for analyzing statistical billing data in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, custom functions usage, and multiple grouping reports in Tableau.
  • 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.
  • 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.

Environment: Tableau Desktop/Server, Oracle, SQL, PL/SQL, T-SQL, SSRS, SSIS, MS SQL Server, Windows, MS Excel/Access.

Confidential, Belleville, IL

Tableau Developer

Responsibilities:

  • Actively involved in gathering requirements from end users, involved in modifying various technical and functional specifications.
  • Mentored business power users to create reports/dashboards using Tableau Desktop.
  • 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 link to link data from different connections together on one dashboard and to filter data in multiple views at once.
  • Involved in new KPI generation.
  • Data collection and leveraging on data manipulation teams for required data.
  • Identify new metrics and enhance the existing KPI’s.
  • Dashboard Visualization through Tableau BI application.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created actions, data blending, Hierarchies, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets with tableau.
  • Analyzed various reports, dashboards, scorecards in MicroStrategy and created the same using Tableau desktop server.
  • Administered user, user groups and scheduled instances for reports in Tableau.
  • Executed and tested required queries and reports before publishing.
  • Converted metric insight reports to Tableau reports.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
  • Design and development of various reports and dashboards that can be easily accessible.

Environment: Tableau (Desktop, Server), Teradata, SharePoint, Windows, ETL, SQL, PL/SQL, MS Project, MS Office suite (Word, Excel, PowerPoint).

Confidential

SQL/BI Developer

Responsibilities:

  • Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
  • Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
  • Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
  • Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
  • Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
  • Configured the report viewing security for various users at various levels using SSRS Report Manager.
  • Played a major role in production support of SSAS cube and SSIS jobs.
  • Involved in writing MDX queries and performance optimization of the SSAS cubes.
  • UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse and data marts
  • ImplementedIncremental load, usedEvent Handlersto clean the data from different data sources
  • Data blending implemented on databases and generated interactive dashboards.
  • Published Workbooks by creating user filters so that only appropriate teams can view it.
  • Embedded Tableau views in to SharePoint
  • Analyzed the source data and handled efficiently by modifying the data types.
  • Generated tableau dashboards for sales with forecast and reference lines.
  • Created SSIS packages to clean and load data to data warehouse.
  • Created package to transfer data between OLTP and OLAP databases.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, CSV files to data warehouse.
  • Used cascaded parameters to generate a report from two different Data Sets.
  • Involved withQuery Optimizationto increase the performance of the Report.
  • EmployedFiltered Indexesto improve query performance and reduce the storage and maintenance cost.

Environment: SQL Server 2008/2012, SSAS, SQL Server Integration Services 2008, Oracle 11g, SQL Server Reporting Services 2008, PL/SQL, Microsoft Visual Studio 2010, Share point server.

Confidential

MS SQL Server Developer

Responsibilities:

  • Gathered and created user requirements and system specifications.
  • Created complex stored procedures, triggers, functions, indexes, views, tables, and other T-SQL codes, and query writing for applications.
  • Normalized the database into small tables by applying rules of Normalization and defined check constraint as well as preparing ER diagrams for database management.
  • Used SSIS to create ETL packages to validate, extract, transform, and load data to different databases and data warehouse.
  • Created SSIS Packages to extract data from multiple file sources to target databases using different transformations and tasks.
  • Created jobs to execute SSIS Packages in target servers to extract and load daily data to customers.
  • Designed and developed test plans and performed data analysis in order to tune SSIS packages and SQL queries performance.
  • Developed custom reports using SQL Server Reporting Services (SSRS).
  • Proficiency in creating different Parameterized Reports (SSRS) which consist of report criteria in various reports to minimize the report execution time and to limit the number of records required.
  • Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
  • Advised optimization of queries by looking at Execution Plan for better tuning of the database.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

Environment: MS SQL Server 2005/2008 (SSMS, Import and Export Data Wizard), MS-Excel, MS-Word, T-SQL, MS Visual Studio 2005/2008 (SSIS, SSRS), Windows Server 2003, MS Access 2007.

We'd love your feedback!