We provide IT Staff Augmentation Services!

Tableau Developer Resume

Kansas City, MO

SUMMARY:

  • Around 6+ years of experience in IT industry as a Tableau Developer, Data Analyst, with extensive knowledge in functional and technical domain of Business Intelligence, creating reports, dashboards through Tableau, identifying trends and process mapping with a background in Databases and Data Warehousing concepts.
  • Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSRS) including MS solutions like MS EXCEL, Microsoft Office SharePoint server 2007/2010/2013 Performance Point Server and ProClarity analysis server.
  • Experience in Developing and Tuning T - SQL, ANSI SQL Complex Queries, Stored Procedures, UDF’S, triggers, views, Indexed views and error handling using Try-Catch blocks
  • Experience in supporting Very Large databases (VLDB) and Very large tables with millions of rows and troubleshooting the problems
  • Implemented Normalization, Transactional, Snapshot replication and Performed log shipping as Disaster recovery solutions.
  • Experience working with Tableau Desktop, Tableau Server and Tableau Reader in various versions.
  • Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
  • Utilized Tableau to produce appealing data visualizations to clients and to help them make business decisions with the help of Ad hoc reporting and Dashboards.
  • Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
  • Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
  • Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/20 .
  • Designed and built complex cubes using Multidimensional Expressions (MDX) of SQL Server and manipulating the multidimensional data stored in OLAP cubes.
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
  • Generated Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008/2012 .
  • Experienced in using Power Shell / Power BI.
  • Worked in performance tuning, query optimization, client/server connectivity and Database Consistency Checks using DBCC utilities.
  • Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances.
  • Experience in gathering requirements, analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
  • Good Working Knowledge in Agile Project management (Scrum process).
  • Expertise in Using DMVs, DMFs, DTA, ITW, Performance dash board and database snapshot.
  • Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.
  • Expertise in Dashboard design with a working knowledge of Performance Point Server including the ability to design and develop scorecards and dashboards using ProClarity.
  • Experience in developing Life Cycle using Agile Methodology.
  • Excellent communication skills, analytical skills, understand business requirements in various Domains.

SKILL:

Databases: SQL Server 2014/2 R2/2005, Oracle 8i/9i/10g/11g, MYSQL

Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, ANSI SQL, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio (BIDS), SQL CMD.

Reporting Tools: SSRS, Report Builder, Focus, Power BI, Tableau Desktop 9.x/10.x, Tableau Server 9.x/10.x, Tableau Reader.

T: SQL, MDX, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA

OLAP: SQL Server Reporting Services (SSRS), SSIS, Crystal Reports 9.0/8.5, OLAP, Erwin, Tableau, Power BI

Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems: Windows Server 2000/2003/2008/2012 , MS DOS, Unix, Linux.

EXPERIENCE:

Confidential, Kansas City, MO

Tableau Developer

Responsibilities:

  • Analyzed user requirements and functional design, prepared technical specifications, unit test plans, and created platform to run and validate the test cases for updating Early Childhood Data stories.
  • Worked with Subject Matter Experts (SMEs) in understanding, documenting, developing, and testing their requirements.
  • Employed various Tableau functionalities like Parameters, Global Filters, Contexts Filters, Data Source Filters, Actions Filters, Functions, Hierarchies, Sets, Groups, Calculations, etc.
  • Developed xml scripts to add State Color branding to the Tableau preferences file to set as the default color pattern in Tableau Desktop.
  • Responsible for Knowledge transfer and training existing and newly recruited resources on various View practices and processes such as report development, deployment, custom SQL scripts and tools used for managing and developing reports, deploying the developed reports to the server.
  • Generated matrix reports, tabular reports, drill down, drill through, sub reports and multi-parameterized reports.
  • Implemented Row Level Security to restrict rows of data to users for various Districts and Sites.
  • Performed modifications to SQL scripts used to deliver data to downstream report interfaces.
  • Demonstrated solid Reporting and SQL skills to coordinate changes to existing reports and develop new reports needed on the go.
  • Coordinating with other teams working on the same project.
  • Research ways to help the report users to see the bigger picture at a single glance and insert the ability to drill through the different levels of dimensions.
  • Assisting users in creating and modifying worksheets and data visualization dashboards.
  • Testing the reports for formatting and data correctness and publishing the workbooks on the Tableau server for scheduled refreshes.
  • Developed and provided documentation, training, and support for business users.

Environment: Tableau Server 2018.2, Tableau Desktop 2018.2/2019.2 , Excel, SQL Server Management Studios.

Confidential, NYC, NY

Tableau/BI Developer

Responsibilities:

  • Deliver high quality, innovative BI solutions in a fast-paced environment
  • Data mining and modeling, regression analysis, process documentation, profitability analysis, lead/list generation, customer attrition and direct mail campaign analysis
  • Responding to requests from partners for customer information reports, lists etc.
  • Identifying/recommending potential data sources.
  • Responsible for performing assigned database-related analyses and projects.
  • Ensures adherence to compliance regulations and policies.
  • Design and develop ETL solutions for multiple source systems.
  • Implement data cleaning and sorting using DAX.
  • Design, develop, and support BI-related database applications spanning multiple lines of business
  • Evaluate operation of production BI applications/environments and perform appropriate troubleshooting as necessary
  • Perform complex data analysis to identify trends, patterns, and opportunities
  • Collaborate effectively with Engineers, Product Managers, and Project Managers to implement project deliverables.
  • Effectively work with business users to determine project requirements and issues
  • Create and maintain technical documents
  • Generate Dashboards and Reports Using Tableau by extracting data from azure data lake.
  • Integrating data using Azure data factory as an integration platform.
  • Performed the testing of Web methods in J Unit and Testing framework using Selenium. Executed the test scripts using Selenium validate the actual and expected results Responsible for Automation Scripts & library functions maintenance.
  • Creating structured Queries in MS SQL.
  • Log and report defects.
  • High-priority issue handling (hot-fixes).
  • Application, functionality and product sign-offs for release and release tracking.
  • Create and maintain system documentation.
  • Performed regression testing for fixes using QTP and closed the defects in Test Manager. Involved in the end-to-end test using QTP and responsible for the Quality-Assurance of this application to complete in record time.
  • Attend Project/Daily-Scrum meetings.
  • Plan and execute system end-to-end tests for all existing and new applications.
  • Participate in system integration testing with other teams.
  • Participate in integration testing with clients/3rd party vendors.
  • Build regression test suite and plan/execute regression tests as needed.

Environment: SQL Server 2016/2014/2012 , OLTP, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Tableau, AWS, Windows Server 2008, VS 2010/2012, MS SQL, T-SQL, QTP, J Unit, Selenium and Excel.

Confidential, Long Island City, NY

Tableau Developer

Responsibilities:

  • Responsible for SQL Server Reporting Services Planning, Architecture, Training, Support and Administration in Development, Test and Production Environments.
  • Extracting and transforming data within Business Intelligence environment.
  • Worked with Microsoft SQL Server, including SQL Agent jobs, SSIS packages.
  • Designed and developed SQL programming objects, including stored procedures, user defined functions, and common table expressions
  • Used Performance Point Server (PPS)to create interactive reports with an ability to drill down into details
  • Perform unit level analysis on all work done before handing over to the testing team
  • Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic
  • Create SSRS reports according to user requirements and technical standards
  • Customize output formats from SSRS to Excel, PDF, and CSV.
  • Creating stored procedures using MS SQL.
  • Implement ETL processing using DAX.
  • Extract data from AWS server and generate dashboards using Tableau.
  • Creating Report-Models for ad-hoc reporting and analysis.
  • Developed Query for generating drill down reports in SSRS 2008 R2
  • SQL Server 2008 Reports Writer and performed complex SQL report writing and design.
  • Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.
  • Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
  • Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Sql Server Reporting Services 2012.
  • Work frequently in an agile Environment

Environment: SQL Server 2016/2014/2012 , OLTP, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Tableau, AWS, Windows Server 2008, VS 2010/2012, MS SQL, T-SQL, and Excel.

Confidential, Herndon, VA

SQL BI (SSIS) Developer

Responsibilities:

  • Delivered high quality, innovative BI solutions in a fast-paced environment
  • Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application.
  • Designed and developed ETL solutions for multiple source systems
  • Designed, developed and supported BI-related database applications spanning multiple lines of business with loan and leasing applications.
  • Performed complex data analysis to identify trends, patterns, and opportunities
  • Created SSIS packages to extract, load and transform the data from flat files to database tables, API to database
  • Extensively for the Pre-Prime product team
  • Strong SQL Server Development skills including writing Transact-SQL (T-SQL) Queries, Stored Procedures, User Defined Functions (UDF), Views, Calculation Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default.
  • Experience in performance tuning, query optimization, Database Maintenance plans
  • Performed Unit & IT testing& conducted UAT sessions with end users.
  • Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
  • Use Cosmos products in developing internal applications and presentations.
  • Experiences in developing Normalization, Stored Procedures, Views, ETL processes, relational database theory and Complex Queries on SQL Server 2012/2014.
  • Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
  • Created several SSIS Packages from different data sources like CSV Files, Excel Files, Oracle DB, SQL DB, MS Azure.
  • Used multiple transformations in SSIS to meet the business requirements by extracting data from transactional source systems, transform and finally load into the Staging Data base.
  • Worked in designing Cubes in OLAP and identifying the Fact and Dimension tables.
  • Used SQL Server Profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.
  • Excellent in creating reports with SQL Server Reporting Services (SSRS) and Tableau.
  • Used SSRS and Tableau to create reports, Parameterized Reports, drill down & Drill through Reports, Ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Experience in creating Parameterized Reports using Dynamic SQL i.e. Stored Procedures.
  • Provided reporting and analytic solutions to the organization in the form of Reporting Services reports and Analysis Services cubes.
  • Using the above query results from Cosmos, creating reports in Tableau, Ads pulse to show the metrics by server and procedure name, by server etc.
  • Managed complex issues quickly using problem solving techniques such as problem (KT), process and data analysis
  • Developed the T-SQL programs and Involved in performance tuning of SQL queries and stored procedures using SQL techniques and queries for faster retrieval.
  • Involved in performance tuning of SSIS Packages.

Environment: SQL Server 2016/2014/2012 , OLTP, Informatica 9.1, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Tableau, Windows Server 2008, VS 2010/2012, T-SQL, and Excel.

Confidential

SQL Developer

Responsibilities:

  • Involved in migration of SQL Server /2014.
  • SQL Server 2008 Reports Writer and performed complex SQL report writing and design.
  • Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.
  • Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
  • Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Sql Server Reporting Services 2012.
  • Designed SSIS Packages to transfer data from various sources of the Company into the database that was modeled and designed.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Defined best practices for Tableau report development.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau.
  • Create Master Package to run different other ETL in one Master package.
  • Developed complex T-SQL queries, common table expressions (CTE), stored procedures, and functions used for designing SSIS packages.
  • Bug fixes in SSIS, SSRS and stored procedures as necessary.
  • Perform T-SQL tuning and optimizing queries for and SSIS packages.
  • Created SSIS process design architecting the flow of data from various sources to target.
  • Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS

Environment: SQL Server 2014/2012/2008 R2/2005 Enterprise Edition, SQL BI Suite (SSIS, SSRS), VB Script, Tableau, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle.

Hire Now