We provide IT Staff Augmentation Services!

Sql Tableau Developer Resume

0/5 (Submit Your Rating)

Harrisburg, PennsylvaniA

SUMMARY

  • Around 7 years of IT experience of data visualization using Tableau and Tableau Admin and Database Design, Data Modeling, Migration, Development, Administration, Implementation using SQL Server 2016/2014/2012/2008 R2/ 2008
  • Experienced professional having thorough knowledge ofSQLServer, Dashboards, Reports, Teradata, Excel and desktop management.
  • Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
  • Extensive knowledge of NormalizationandRelational Database Management Systems.
  • Hands on experience on various SQL Server Services like Integration Services SSIS(ETL), Analysis Services (SSAS), and Reporting Services (SSRS).
  • Experience inPerformance Tuning and Query Optimization.
  • Proficient in design and development of various dashboards, reports utilizingTableau Visualizationslikebar graphs,scatter plots,pie-charts,geographic visualization and other making use ofactions,otherlocal and global filtersaccording to the end user requirement.
  • Outstanding Data analysis skills includingData mappingfromsource to targetdatabase schemas,Data Cleansingand processing, writing data extract scripts/programming of data conversion and researching complex data problems.
  • Prepared dashboards using calculated fields, parameters, calculations, groups, setsandhierarchiesin Tableau.
  • Created sheet selector to accommodate multiple chart types likePanelcharts,Bulletcharts andStackbars etc. In a single dashboard by usingparameters.
  • Proficient in developing Entity-Relationship diagrams,Star/Snow Flake SchemaDesigns usingErwinStar and Snowflake Schemas, and Expert in modeling Transactional Databases and Data Warehouse.
  • Well-versed in usage of SSIS(ETL)Control Flowitemstasks and containersand SSISData Flowitemssources,transformationsanddestinations.
  • Proficiency in creating different types of reports such asCross-Tab,Chart,Conditional,Drill-down,Summary,Formandsub reports, and formatting them.
  • Experience in developing OLAP cubes using SSAS and identifying dimensions, attributes,hierarchiesandcalculating measures anddimensionmembersin SQL Server Analysis ServicesSSAS.
  • Expertise in performing development activities from gathering requirements anddesigning solutions, through developing code/ reports to testing, release/deployment.
  • Worked extensively onjoining tables, multiple data connections usingblending, worked on DataExtractsandmanaging queries.
  • Mastered in usingFilters, sorts, groups and Sets, reference lines, Bands and Boxesin different kinds of charts.
  • In depth knowledge in Tableauadvance analysisfeatures likeActions, Calculations, forecasting, Parameters and Trend lines.
  • Mastered the ability to design and deployrich Graphic visualizationsParametersusing Tableau.
  • Experience inCreating and Updating Clustered and Non-Clustered Indexesto keep up the SQL Server Performance.
  • Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managingownerships, working withSites, providing access to the users and adding them to the specificgroups and Projects,Scheduling Refreshes and Subscriptionsin Tableau Server.
  • Proficient in design and development of various dashboards, reports utilizingTableau VisualizationslikeDual Axis,Bar Graphs,Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualizationand other making use ofactions,otherlocal and global filtersaccording to the end user requirement.
  • Expertise in designing and creating various analytical reports and AutomatedDashboardsto help users to identify critical KPIs and facilitate strategic planning in the organization.
  • Experience on Configuring installation and managing Tableau Server with large data volumes like setting up Tableau data sources. Filters, blending, joins for optimum performance and Trouble-shooting issues.
  • In SSIS(ETL) loaded data from various heterogeneous sources like oracle, DB2 into SQL server database and data warehouse.
  • Highly skilled in configuring and creating SSIS(ETL) solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, User-defined Variables for SSIS Packages.
  • Experience in transforming unstructured data from various data sources using SSIS(ETL) Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
  • Created SSIS(ETL) packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
  • High expertise in creating Reports of all types in SSRS, like Ad-hoc Reports, Drill-Down Reports, Drill-Through Reports, parameterized Reports, Pivot and Tabular Reports based on client requirement.
  • Experienced in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema.
  • Expertise in data modelling, logical, physical model, forward and reverse engineering using Erwin tool and Visual studio.
  • Expert in Dimensional Data Modeling and Cube Design in MS SQL Server Analysis Services (SSAS) and deploying them.
  • Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities
  • Excellent problem solving skills, ability to handle multiple projects simultaneously, comfortable in interaction with both business and technical team members.
  • Experience in working with multiple teams under strict deadlines.
  • Quick learner, adaptive and possesses good inter personal skills and work ethics.
  • Excellent communication skills, diligent and good team player.

TECHNICAL SKILLS

  • MS SQL Server 2016/2014/2012/2008 R2/2008
  • Visual Studio 2010/2012/2013/2015/2017
  • MS SQL Server Integration Service (SSIS)
  • MS SQL Reporting Services (SSRS)
  • MS SQL Analysis Services (SSAS)
  • Tableau Desktop 8.0/9.0/10
  • Tableau Server
  • C#
  • .NET
  • HTML
  • CSS
  • MS Azure
  • AWS
  • Jira
  • GIT
  • Power BI
  • Microsoft Access
  • Microsoft Excel
  • Outlook
  • MS SQL Profiler
  • SQL Query Analyzer
  • Database engine tuning advisor
  • Vb.net
  • Excel VBA
  • Crystal Reports
  • T-SQL
  • MS Visio 2005/2010.

PROFESSIONAL EXPERIENCE

Confidential - Harrisburg,Pennsylvania

SQL Tableau Developer

Responsibilities:

  • Extract data from various heterogeneous sources like DB2, oracle, SQL server into SQL server database and data warehouse by using SQL server integration services
  • Designed, developed, tested, and maintained Tableau functional reportsbased on user requirements.
  • Developed Tableau data visualization usingPareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms, Density Chart etc.
  • Created differentKPI'susingTable calculationsandcalculated key figuresManipulating strings, arithmetic calculations, aggregation options and Logical functions
  • Worked extensively with Advance analytics likeReference Lines and Bands, Trend Lines.
  • Expertise in working with data buildingGroups, Hierarchies and sets.
  • Developed effective and interactive Dashboards usingParametersandActions
  • Provided Production support to Tableau users and WroteCustom SQLto support business requirements.
  • Extensively used Tabadminand Tab cmd commands in creating backups and restoring backups ofTableaurepository.
  • Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
  • From staging database loaded data into data warehouse and transform and load into Dimension and Fact tables in Data Warehouse using SSIS(ETL).
  • Implemented ETL to Extract and Transform data from Flat File or CSV, Excel instance and to load into Staging Database.
  • Created Dynamic SSIS(ETL) packages using expressions, variables and control flow
  • Experience in design and development of Tableau visualization solutions.
  • Hands on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
  • Worked with complex SQL, Stored Procedures, Triggers and packages in very large databases from various servers.
  • Created Mapping, Design and technical Documentation for complex SSIS(ETL) packages.
  • Experience in maintaining Error logging using Exceptional Handling in T-SQL and SSIS(ETL).
  • Involved in Maintaining Database with Backup, Restore Strategies and Scheduling those backups using SSIS packages as a Developer.
  • Deployed many packages on different servers using SSIS(ETL) package Configurations.
  • CreatedIndexesfor fast retrieval of the data. Involved inPerformance tuningandQuery Optimization using execution plan.
  • Developeddrill-throughanddrill-downreports usingSSRS.Designed and implemented Parameterized and cascading parameterized reports usingSSRS.
  • Developed custom reports using SQL Server Reporting Services(SSRS)to review score cards, business trends based on the data from different locations.
  • CreatedSubscriptionsandData-driven subscriptionsusingSSRS.
  • Createdsnapshotsof reports to reduce theload on the server using SSRS.
  • Created Cubes usingSSAS 2008that are used by business users
  • Defined KPI’s, Actions and Calculations inSSASusing MDX
  • Working on generating various dashboards in Tableau server using various sources such as SAP HANA/SQL Server/Teradata/Oracle.
  • Experience in creating users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
  • Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
  • Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
  • Understanding of relational database structures, theories, principles, and practices.
  • Involved in creating a dual-axis bar chart with multiple measures.
  • Created report schedules on Tableau server.
  • 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 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 key's from each database for data validation.

Confidential - Staten Island, New York

SQL Tableau Developer

Responsibilities:

  • Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
  • Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
  • Experience with the design and development of Tableau visualization solutions.
  • Conducted Data blending, Data preparation usingAlteryxand SQL fortableauconsumption and publishing data sources toTableauserver.
  • Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
  • Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
  • Developed complex SQL scripts database for creating BI layer on DW for tableau reporting.
  • Created sheet selector to accommodatemultiple chart typeslike Panel charts, Bullet charts and Stack bars etc. In a single dashboard by using parameters.
  • Using Multiple Measures like IndividualAxes, Blended Axes, and Dual Axes.
  • Extensively used calculated fields fordifferent logics for Trend,
  • Extended price calculations for the different cost types.
  • Dashboard Visualization through Tableau BI application.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created actions, parameters, Filter Local, Global and calculated sets for preparing dashboards and worksheets using Tableau.
  • Effectively used data blending, filters, actions, Hierarchies feature in tableau.
  • Working extensively with Tableau Business Intelligence tool to develop various dashboards.
  • Attended daily standup meetings to updatescrum masterwith what is achieved, what is being done and is there any impediment.
  • Conducted user acceptance testing and mentored business users how to slice and dice data usingfiltersandparameters.
  • Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performedperformance tuningof the dashboard and created tableau functional design document.
  • Developed complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
  • Designed and developed ComplexSSISpackages for auditing using SQL SERVER Integration Services SSIS(ETL).
  • Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
  • Created complexSSAScubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Good experience in writingMDXqueries while creating and customizing Cubes using SQL Server Analysis Services (SSAS)
  • Defining relationships betweenDimensionsandMeasure groups. Involved in the design and development of the SSAS cubes andMDXqueries
  • Implemented Event Handlers and Error Handling inSSISpackages and notified process results to various user communities.
  • PerformedQuery optimization & Performance Tuning.
  • Formatted theSSRSreports using the Global variables and expressions.
  • DevelopedSSRSreport models as per end user requirements.
  • ScheduledSSRSreports using reports server to run as per business user requirements.
  • Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
  • Deploying, Testing and Scheduling SSIS(ETL) packages using SQL Agent.
  • Developed Custom Functions, Manual Running Totals and Complex Formulas for reports used calculations, sorts, filters and sections to enhance data presentation in reports.
  • Created many Cascaded parameters in the reports using SQL SSRS.
  • Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services.
  • Highly involved in automating reports generated weekly and monthly basis for the client and business sales teams.
  • Worked with production control team to deploy code and for schedule run in both staging while testing and production. Responsible for providing 24/7 on-call production support for daily job and ETL loads.
  • Performed unit testing, user acceptance testing of Reports, T-SQL scripts and database objects to test their functionality by creating comprehensive test plans.
  • Worked onPerformance tuningof report with huge queries using concurrent query execution for better performance of report.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
  • Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
  • Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc. using T-SQL to store data and to maintain database efficiently.
  • Wrote SSIS Packages to migrate user’s logins, stored procedures, and functions.
  • Adding Key Performance Indicator (KPI) to the cube to evaluate business performance.

Confidential - New York, New York

SQL Server/SSIS/SSRS/Tableau Developer

Responsibilities:

  • Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
  • Successfully installed and configured MS SQL Server on the production server.
  • Automated the migration of data from Oracle DB to MS SQL Server DB using Microsoft SQL Server Migration Assistant (SSMA).
  • Worked as a Tableau admin, in charge of the report development and maintenance
  • Built and maintained many dashboards.
  • Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
  • Created Backup scripts to take periodic backups for the content on Tableau server.
  • Worked on the requirement gathering of the reports
  • Analyzed the database tables and created database views based on the columns needed.
  • Implemented calculations and parameters wherever needed.
  • Published dashboards to Tableau server.
  • Expertise in Deployment, Configuration, Administration, Maintenance, Performance and troubleshooting ofTableauServers and Development platform on an Enterprise wide scale
  • IntegratedTableauwith Teradata and created a Data Visualization and Analytics platform onTableau
  • Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing Deleting Users and Activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.
  • Generated assessment reports to analyze the scope and complexity of the migration projects.
  • Converted the Oracle DB objects to MS SQL Server DB objects like tables, views, and stored procedures.
  • Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
  • Created variouscomplex Reports and exportedtoExcel Spreadsheetsfor Analytical uses
  • Migrated the entire schema as well as data into MS SQL Server and also validated the migration process to ensure that it has been successfully migrated.
  • Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
  • Designed drilldown, drill through, and parameterized report using SSRS.
  • Deployed generated reports onto the Report Server to access it through browser.
  • Designed, reviewed, and created primary objects such as views, indexes, views and store procedures.
  • Worked with User Defined Functions, triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least update to improve the query performance.
  • Defined referential relationships with the measure groups and fact tables.
  • Documented the development work and production release for future reference.

Confidential - Melville, New York

Senior SQL Server/SSIS/SSRS/Tableau Developer

Responsibilities:

  • Involved in Planning, Defining and Designing database using Erwin on business requirement and provided documentation.
  • InstalledSQL Serverand Management tools usingSQL ServerSetup Program.
  • Designed SSIS Packages to transfer data from various sources like Text Files, XML Files,SQL Server, Excel and Access toSQL Serverusing Business Intelligence Development Studio.
  • Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column.
  • Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
  • Find efficient 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.
  • Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
  • Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
  • Created actions, parameters, Filter Local, Global and calculated sets for preparing dashboards and worksheets using Tableau.
  • Effectively used data blending, filters, actions, Hierarchies feature in tableau.
  • Defined best practices for Tableau report development.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Executed and tested required queries and reports before publishing.
  • Create views and dashboards on end client's sales data. Produce powerful dashboards telling story behind the data in an easy to understand format such as pie, bar, geo, and line charts that are viewed daily by CEO and CFO.
  • Perform Tableau Server admin duties add users/groups from Active Directory and schedule instances in Tableau Server including weekly data dump.
  • Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.
  • Wrote T-SQL queries, Store Procedures and used them to build packages.
  • Handled slowly changing dimensions to maintain the history of the data.
  • Migrated packages from development server to production server using package configuration.
  • Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS.
  • Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS.
  • Implemented AD HOC reporting with the report builder for the end users.
  • Created reports to retrieve data using Stored Procedures that accepts parameters.
  • Generated reports using Expressions and Functions using SSRS.
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
  • Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
  • Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • UsedSQL Serverprofiler for auditing and analyzing the events, which occurred during a particular time horizon and stored in script.
  • Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

Confidential

Jr. SQL/SSIS/SSRS/Tableau Server Developer

Responsibilities:

  • 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 modeled Microsoft SQL Server data warehouse and data marts, including the modification of existing Microsoft SQL Server data warehouse and data marts.
  • Used SSIS packages to roll our data to Live Tables and to Processing Database.
  • Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet inTableauDesktop
  • Utilized advance features ofTableausoftware like to link data from different connections together on one dashboard and to filter data in multiple views at once.
  • DevelopedTableaudashboards by using Teradata, Hadoop and Excel as data sources
  • Worked closely with business users to create reports/dashboards usingtableaudesktop.
  • Expertise inTableauEnterprise Scalability and Integration with existing Data Flow Architecture
  • Involved in Deployment, Maintenance and Troubleshooting ofTableauServers and integration with Teradata
  • Experienced in Optimization and Performance improvement ofTableauWorkbooks
  • Developed database objects such as Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
  • Develop the Documents for Logging/Error Handling for SSIS Packages
  • Schedule Package using SQL Server Job for weekly/monthly basis.
  • Used Checkpoint for avoiding re-executes Package from the first task.
  • Develop the Slowly Changing Transformation to maintain the Historical Data.
  • Handling the errors during data moving and Sequencing the task as per requirements.
  • Perform T-SQL tuning and optimizing queries for Reports, which take longer time in execution SQL Server .
  • Migrated some Crystal reports to SSRS reports manually
  • XML result set from Stored Procedures to create custom XML file for third party data export.
  • Extensive work on SSIS creating all the interfaces between front end application and SQL Server database, then from legacy database to SQL Server Database and vice versa.

We'd love your feedback!