Tableau/snowflake Developer Resume
San Diego, CA
SUMMARY:
- 7+ years of experience in IT industry. Including designing complex dashboards taking advantage of all tableau functions including data blending, actions, parameters, etc.
- Familiar with entire software development life cycle (SDLC) and various project methodologies such as Agile and Scrum Methodology.
- Actively involved as part of a team for gathering and analyzing the needs of End User Requirements and System Specifications.
- Experience in handling large databases to perform complex data manipulations performing Tableau functionalities such as Data Blending, Cross database joins, Unions and Joins.
- Designed various Data Visualizations, Charts, Dashboard for Analytical Projects to various business teams.
- Experience in cloud data migration using AWS and Snowflake.
- Experience in designing, publishing and presenting customized interactive dashboards in Tableau using Marks, Action, filters, parameter and calculations.
- Working experience and knowledge in creating tables, reports, graphs and listings using various LOD (Level of Detail) calculations.
- Created business driven dashboards using different chart types like Crosstab's, Geo/Tree/Heat Maps, Dual Axis Charts, Pie/Bar Charts, Line/Area Charts, Gantt charts, Bubble charts, Scatter Plots, Trend lines, Bullet Graphs and Histograms in Tableau Desktop .
- Responsible for developing, analyzing and reporting key risk indicator and key performance indicator metrics that enable management to make timely and effective decisions related to threats, risks and control requirements.
- Created extracts for the workbooks built and published those extracts and scheduled automatic refreshes on Tableau Server.
- Designed and implemented live monitoring Dashboards for Tableau Server and Visualization users.
- In - depth knowledge on Tableau Desktop and Tableau online .
- Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse.
- In-depth knowledge on SQL queries and working with Oracle, PL/SQL, SQL Server and MySQL .
- Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
- Experienced in data loads, database integration/conversions, performance tuning, and query optimization.
- Good understanding and background in financial services, healthcare, and telecom industry.
- An excellent team player with fast learning curve, strong analytical, problem solving, communication and interpersonal skills to work under time constraints and has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.
TECHNICAL SKILLS:
BI /Reporting Tools: Tableau Desktop 8.2/9.0,9.3,10.2, 10.3, Tableau server10.2, SSRS
ETL Tools: SQL Server Integrated Services (SSIS)
RDBMS/DW: MS SQL Server 2008/2012, Oracle, IBM DB2, My SQL, Teradata, Snowflake
Database Tools: My SQL Management studio, Microsoft Visual Studio
Languages: SQL, HTML, XML, C, JAVA
Operating Systems: Windows, Linux, Unix
PROFESSIONAL EXPERIENCE
Confidential, San Diego, CA
Tableau/Snowflake Developer
Responsibilities:
- Worked with the client and team members to understand and clarify visualization requirements.
- Created the reports using external data files (xlsx, csv) or database queries for Tableau Desktop.
- Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
- Written complex SQL queries and optimized queries for performance tuning.
- Involved in data migration to snowflake using AWS S3 buckets.
- Recreated existing SQL Server objects in snowflake.
- Also converted SQL Server mapping logic to Snow SQL queries.
- Built different visualizations and reports in tableau using Snowflake data.
- Wrote different Snow SQL queries to interact with compute layer and retrieve data from storage layer.
- Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
- Worked extensively with Calculations, Actions, Parameters, Background images and Maps. Created Trend Lines, Groups, hierarchies and Sets to create detail level summary reports.
- Created dashboards in Tableau Desktop and published onto Tableau Server.
- Worked on advanced viz charts like Bubble, Donut and Step chart. Created Drill down analysis for dashboards.
- Created conditional filters to filter the data on dashboard and creating Parameters for desired functionality.
- Created complex reports like Detail Level Transaction report's and MTD/YTD calculations.
- Involved in resolving reporting and design issues throughout the reporting life cycle.
- Published completed dashboards on to server and scheduled extract refresh.
- Strong ability in developing SQL queries to fulfil data and reporting requirements including identifying the tables and columns.
- Monitored the project processes, making periodic changes and guaranteeing on-time delivery.
- Documented a whole process of working with Tableau Desktop, and evaluating Business Requirements.
Environment: Tableau 9.x/10.x, Tableau server, Snowflake, SQL Server 2012, Oracle, DB2, SQL, MS Access, MS Excel.
Confidential, Minnetonka, Minnesota
Tableau Developer
Responsibilities:
- Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
- Converted all existing flat files reports into Tableau visualizations.
- Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
- Assisted users in creating and modifying worksheets and data visualization dashboards.
- Working on generating various dashboards in Tableau Desktop using various sources such as SQL Server/Teradata/Oracle/Excel/Text data etc.
- Involved in creating a dual-axis bar chart with multiple measures. Preparing Dashboards using calculations, parameters in Tableau. Involved in creating Ad-hock reports.
- Developed Tableau data visualization using Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
- Created LOD (Level of Detail) and Window calculations.
- Scheduled data refresh on Tableau Server for daily/weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
- 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.
Environment: Tableau 8.x/9.x, SQL Server 2012, Oracle, Teradata, MS Access, MS Excel.
Confidential, Chicago, IL
Tableau developer
Responsibilities:
- Involved in reviewing business requirements and analyzing data sources from Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
- Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
- Created views in Tableau Desktop those were published to internal team for review and further data analysis and customization using filters and actions.
- Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.
- Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
- Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
- 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 daily/weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
- Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
- Participated in meetings, reviews, and user group discussions as well as communicated with stakeholders and business groups.
Environment: Tableau 8.0 desktop, Tableau server, Oracle, SQL Server, UNIX.
Confidential, Minnetonka, MN
SQL developer SSIS/SSRS
Responsibilities:
- Responsible for creating complex SQL stored procedures and functions using Microsoft SQL Server 2008R2.
- Involved in code review and daily meetings.
- Involved in error handling and performance tuning of stored procedures.
- Used Team Foundation Server for version control needs, track check-ins and roll back code as necessary
- Coordinated with Technical Analysts in understanding the business requirements and translated them in to technical specifications
- Analyzed the data as per business needs to build the Interface.
- Generated serve side T-SQL scripts for data manipulation and validation.
- Created Views and Index Views to reduce database complexities for the end users.
- Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements.
- Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
- Developed Scheduled Jobs to automate the packages.
Environment: SQL Server 2008 R2, Visio, SQL, T-SQL, CSS, HTML.
Confidential
SQL Developer SSIS/SSRS
Responsibilities:
- Gathered and analyzed reporting requirements for the sales and marketing departments.
- Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS packages.
- Developed SSIS 2008 Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations.
- Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
- Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
- Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
- Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS.
- Formatted reports using Global Variables, Expressions and Functions for the reports.
- Designed and developed different type of reports including: Tabular forms, Matrix form, Conditional, List items, Charts and Sub reports, Drill down reports.
- Created complex expressions, calculations, sorting, filtering to enhance data presentation in reports.
- Created dashboards using Performance Point Server, combining scorecards and reports generated in SSRS, PPS, and Excel Services.
- Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
Environment: MS SQL Server 2005 and 2008, Windows Server 2008, SSIS, SSAS, SSRS, T-SQL, ETL, MS Access, XML, Excel, Visual Studio 2008.