Sql Server Tableau Developer
Resume:
Navneet Gill
Tableau Developer
******@*****.***
PROFESSIONAL SUMMARY:
Around 8 Years of experience in the field of Information Technology with a strong background in Analysis, Design and Development in the field of Database and implementation of Business Intelligence applications.
Extensive experience in using Tableau functionalities for creating different Reports, Charts, Interactive Dashboards with page and dashboard Prompts.
Develop ad hoc reporting/Self Service platform with appropriate controls over manual, semi-automated, and automated reporting functions for senior management and stakeholder.
Creating dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop and organizing Dashboard views and objects.
Garnered deep experience with all modules of Micro Strategy Product Suite namely MicroStrategy Intelligence Server, Web, Dashboard, Narrowcast Server, and Desktop.
Creating Side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications have hands on experience on AWS cloud platform.
Designing and developing data warehouse and Amazon Redshift BI based solutions transforming complex business requirements into rich data visualizations using Tableau.
Experience in ingestion, storage, querying, processing, and analysis of Bigdata with hands on experience in big data Eco- system related technologies.
Experience in transforming the data as per business needs using different transformations like: Conditional split, Merge join, derived column, data conversion, Fuzzy lookup in SSIS.
Strong experience in writing complex T- SQL queries and creating database objects like tables, views stored Procedures, and Triggers.
Experience in performance tuning of long running SQL queries using SQL server built in tools like: SQL Server profiler and Execution plan.
Good knowledge in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS, Alteryx and Informatica.
Working on great extent with the design and development of Tableau visualizations which includes preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies
Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard Optimization, Hyperlink Objects, Color-coded tabs etc. in Tableau desktop/Server.
TECHNICAL SKILLS:
Analytical Tools
Tableau (Desktop/ Server/ Reader), SSRS, SSAS, Google Analytics (Adobe Site Catalyst).
ETL Tools
Informatica, Talend,Alteryx
Process
Development, Support, Dynamic Parameters, Dashboard Optimization and Maintenance
Reporting Tools
Tableau 2018.1/2/3, 2019.1/2/3,9.0,9.3/8.2,8.1/8.0/7.0, 10.5
Databases
Teradata, Oracle, MS SQL Server 2005/2008/2012, Oracle, MS Access, Active Directory
Languages
SQL, PL/SQL, JavaScript, HTML, XML, C, T-SQL, Python
Operating System
Windows, UNIX (HP-UX, Solaris, AIX), Linux.
Domains
Financial, Banking, Health Care, Retail, Telecom.
PROFESSIONAL EXPERIENCE:
Role: Tableau Developer Nov 2021 – Oct 2022
Client: Citi Bank, NJ
Responsibilities:
Worked on Finance Issue Management project to track the issue status, issue date, due status etc.
Designed, developed and implemented different forms of visualizations for daily business use to see Budget and Forecast provided features like parameters, actions, calculated fields, sorting, and groupings in Tableau dashboards
Gathered user requirements, analysed, and designed software solution based on the requirements publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Developed Tableau workbooks from multiple data sources using Data Blending, restricted data for particular users using Row level security and User filters.
Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite provided support for Tableau developed objects and understand tool administration.
Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
Created Custom Hierarchies to meet the Business requirement in Tableau strong verbal and written communication skills, ability to work effectively with user departments.
Role: SQL/BI Developer April 2021- Nov 2021
Client: Morgan Stanley, NYC
Responsibilities:
Worked on Wealth Management project.
Involved in creating dashboards and reports. Created report schedules on Tableau server creating New Schedule's and checking the task's daily on the server.
Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality. .
Developed, deployed and monitored SSAS cubes performed Column Mapping, Data Mapping and Maintained Data Models and Data Dictionaries.
Strong experience in designing and implementing ETL packages using SSIS for integrating data using OLE DB connection from heterogeneous sources.
Developed ad hoc reporting/Self Service platform with appropriate controls over manual, semi-automated, and automated reporting functions for senior management and stakeholder.
Role: Tableau Developer Jan 2020 - Feb 2021
Client: Therapy Notes, Horsham, PA
Responsibilities:
Worked on healthcare project to track patients’ health.
Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Map functional & technical documentation related to Business Intelligence (BI) solutions.
Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's
Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
Deep experience with the design and development of Tableau visualization solutions production support for Tableau users.
Executed and tested required queries and reports before publishing create, customize & share interactive web dashboards in minutes with simple drag & drop.
Role: Tableau Developer Jan 2019 - Jan 2020
Client: Comcast, Philadelphia, PA
Responsibilities:
Developed and reviewed SQL queries with use of join clauses in Tableau Desktop for validating static and dynamic Parameter’s data for data validation.
Develop load scripts to extract, transform and load data (ETL) into Tableau applications eeffectively used data blending feature in tableau
Designed business intelligence dashboard optimization using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
Conducted multiple Tableau training sessions to educate both high-end BI Reporting and Analytic analysts and low-end business users on how to use Tableau
Used Data Blending and combined Adobe Marketing Cloud data with other aggregated data, to compare and analysed data in different perspective using Alteryx.
Provided ongoing development for functional reporting team when new fields are requested to be added into the data warehouse.
Worked extensively on the SQL Server/MYSQL databases and imported SQL scripts into QlikView. Experience with QlikView functions like fabs, peek, previous, is null etc.
Developed complex Talend ETL jobs to migrate the data from flat files to Oracle database creation of the documents for Tableau user support and trained Power users on self-servicing capability of the tool
Role: Data Analyst/Tableau developer
Client: Primetech Software, India April 2016 – Dec2018
Responsibilities
Implemented list reports, crosstab reports and drill-through reports using prompts, cascading prompts, filters, calculations, and conditional blocks.
Involved in unit and integration testing in Dev, UAT and Production environments. Prepared test case documents for reports validation.
Plan, design, and implement application database code objects, such as stored procedures and views maintain SQL scripts, indexes, and complex queries for data analysis and extraction Responsible in creating the SSIS packages for extracting the data from heterogeneous sources (Excel, Flat file, SQL server) and load them into multiple databases (Staging area, SQL Server, data warehouse) as a part of ETL process using ETL mapping document.
Applied several transformations like lookup, audit, derived column, data conversion, conditional split to perform data cleansing, data validation before loading data to Datawarehouse.
Role: QA Tester
Client: Hinduja Global Solutions, India
March 2014 - March2016
Responsibilities:
Created test cases for various interfaces based on Business Requirement
Used Page Object Pattern using Java.
Developed freehand scripts in Java for Selenium.
Documents and System Specification documents
Interacted with client and Analyzed system requirements.
Developed modules to enter collected data manually, fetch and show the data as per requirements.
Performed End-to-end testing to ensure system behavior matches the business requirements from the clients.
Requirements analysis of new enhancements
Enhancement and maintenance of the code as per requirement
Writing SQL queries as per requirement
Performed Component testing, Functional testing, Integration testing, System testing, and GUI testing.
White Box Testing, Black Box testing, functional and regression testing.
Education:
1.Master’s in engineering and Technology (Information and Technology) from Punjab Technical University, Jalandhar, India (2011).
2.Bachealors in Engineering (Information and Technology) from Punjab Technical University, Jalandhar, India (2009).
Certifications:
1.Oracle Database 11g Administrator Certified Associate. Date: April27,2016
2.Oracle Database 11g Administrator Certified Professional. Date: May 28,2016.
3. Oracle Database SQL Certified Expert. Date: March19,2016.
Contact this candidate