Candidates About

 

Nicole Bantique

Professional Summary

v  Over 15 years of IT experience with 12 years of experience in Tableau Desktop/Server.

v  Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.

v  Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.

v  Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets , Groups, Parameters etc., in Tableau.

v  Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.

v  Extensive experience working in Windows, LINUX environment.

v  Extensive experience in development of DATAWAREHOUSING technologies.

v  Self-motivated and trained basics in R programming myself to grow in my career as a data scientist.

v  Trained basics in machine learning future scope for AI (Artificial Intelligence).

v  Very good knowledge on understanding 3tier architectures & SDLC process.

v  Expertise in analysing and documenting business requirement documents (BRD) and functional requirement documents (FRD) along with Use Case Modelling.

v  Experience in creating dashboards and Visualizations using Tableau.

v  Experience in Software QA and Testing Methodologies, verification and validations in all phases of the SDLC.

v  Core technical experience in working with projects on Data Quality across various sources and targets.

v  Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS)

v  Experience in Creating Tables, Views, Triggers, Stored Procedures, and other DDL, DML statements for various applications.

v  Strong Knowledge in SQL databases and moving data from source to destination tables.

v  Hand on experience using SQL Hard & Soft queries.

v  Experienced with different Relational databases like Oracle and SQL Server.

v  Extensive SQL experience in querying, data extraction and data transformations.

v  Experienced working on large volume of Data using SQL and BASE SAS programming.

v  Experienced in Extracting Data from Mainframes Flat File using DB2 SQL.

v  Strong Experience in working on MS Access, MS Excel and MS Power Point.

v  Involved in production batch support for Analysis and fixing database related failures.

v  Experienced in JCL (Job Control Language) for Job Management & Data Management in IBM Mainframe Environment.

v  Hands on Experience in JCL libraries, Procedures & running COBOL programs using JCL.

v  Strong Knowledge in COBOL with Program Structuring, Table Processing, File Handling, Subroutines & Database Interfaces.

v  Experienced in using REXX programming in Control M (z/OS) for running Jobs & Batch processing.

v  Worked as a Dedicated Team member, in a highly dynamic & pressure oriented environment with tight schedules and deadlines in an onsite/offshore delivery model infused by a distinct culture of customer satisfaction.

v  Highly recognized at all jobs for my strong dedication towards work.

v  Excellent analytical and collaboration skills. Adapt quickly changes, self-starter, self-motivated.

v  Goal oriented professional possessing strong work ethics, interpersonal and communication skills. I am a fast learner of new and required tools and technologies.

v  Having working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.

v  Experience in Insurance, Educational, Banking and Financial Service Domains.

v  Extensively worked on databases like Oracle 11g, 10g, SQL Server, DB2. Strong programming and debugging skills in PL/SQL, SQL, MSSQL, Teradata.

v  Knowledge on Google API development skills, SQL Server, ETL processes SSIS, SSAS and SSRS.

v  Expertise in writing Store procedures , SQL Queries, Dynamic-queries, and complex joins for generating

v  Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.

v  Having strong analytical, logical, Communication and problem solving skills.

v  Ability to adapt to new technologies by self-learning.

v  In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

v  Extensive Tableau Experience in Enterprise Environment and Tableau Administration.

v  Built dashboards to help reduction of Market budgets and increase ROI.

v  Lead a small team when doing dashboards for analyzing internal marketing dept performance in ODM consisting Tableau.

v  Experience including technical support, troubleshooting, report design and monitoring of system usage.

Skills

Data Visualization Tools               : Tableau Desktop 10 .X9.x/8.x/7.x, Tableau Server 8.x, 9.x,                                                                                            Oracle, SQL Server

ETL Tools                                             : Informatica 8/9.x, ODI10g, SSRS, SSIS

Operating Systems                         : Windows 2000/XP-Pro/Vista/7/8/10

Programming Languages              : SQL, PL/SQL, T-SQL, C, C++, HTML 4.0

Database Tools                                 : SQL Developer, PLSQL Developer, SQL* Plus, TOAD, T-SQL

RDBMS                                                 : Oracle 11g/10g/9i, SQL SERVER 2005/2008, DB2, Teradata,                                                                                            Netezza, Hadoop

 

 

Professional Experience

Jan 2007 – Present                                                                                                            10 Best SEO, San Francisco, CA

Tableau Admin/Developer

Responsibilities:

·         Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.

·         Mentored business power users to create reports/dashboards using tableau desktop.

·         Used forecasting feature to provide predictive information to model future based on the history which added value to our project.

·         Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.

·         Published reports/dashboards on Tableau server and created & managed tableau server groups and permissions.

·         Created aggregate data extracts for larger tables and configured schedulers on the server to refresh the data.

·         Utilized Alteryx for blending data from multiple databases to create a single Data source.

·         Provided insights of Time series forecasting data analysis of weekly sales for regions and retail users using R and Tableau.

·         Built predictive models for various research using R, including trend analysis, linear regression and logistic regression.

·         Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic datasets.

·         Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

·         Experience in creating advanced Custom Filters by using Pass-Through Expressions in Micro Strategy. Expertise in creating interactive Dashboard Reports and Scorecards to view personalized reports based on user requirements.

·         Built the DW environment using the Tableau and SQL server tables with Terabytes of Data. Using SQL Server Integration Services(SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.

·         Developed various views in Tableau like Tree maps, Heat maps, Scatter plots, Geographic maps, Line chart, Pie charts, etc.

·         Created Special technically directed documents for better acceptance of the reports.

·         Created reports based on Claims Data and EMR data from the Medicaid data base.

·         Created jump plots to analyze the company’s market.

·         Created dashboards to analyze performances of different levels of sales teams in different places of market by using LOD calculations and table calculations

·         Defined best practices for Tableau report development.

·         Implemented Tableau BI Dashboard reporting solution for different groups in the organization.

·         Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.

·         Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.

·         Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.

·         Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.

·         As a part of internal usage, helped the company analyze staff performances by creating visualizations from the data stored in the form of ICD-9 codes and the CPT codes.

·         Created report schedules on Tableau server.

·         Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.

·         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.

·         Proof-read all documents and maintain accuracy of information and preparing SOP.

·         Responsible for Developing a Dashboard and preparing ad-Hock Reporting.

·         Generated Interactive dashboards with filters, Parameters and Actions to handle views more efficiently.

·         Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic datasets.

·         Experienced with different kind of Dashboard like traditional performance summary, traditional metric, dynamic content and dynamic visualization dash boards applications and Score carding.

·         Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.

·         Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.

·         Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

·         Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.

·         Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

·         Assisting users with questions and issues using Tableau. Working with various infrastructure teams and Tableau support team to help improve dashboard response time.

·         Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.

·         Performed Tableau type conversion functions when connected to relational data sources.

·         Maintained and Installed Tableau Server in all the environments.

·         Hands on Experience on converting SAP HANA  Files to Tableau

·         Created incremental refreshes for data sources on Tableau server.

·         Connected Tableau to various databases and performed live data connections, query auto updates on data refresh etc.

·         Provided technical support to all team members during project execution.

·         Performed reports/dashboards performance optimization.

·         Recommending optimized design and chart for specific requirement.

·         Handling change requests and providing support/maintenance for deployed projects.

Environment: Tableau Desktop 10x,9x, Tableau Server 9, SQL Server, Oracle 10, Microsoft Office Suite (Word, Excel, Power Point), HP ALM. Tableau Desktop 8.x, Tableau Server, Windows Server Standard R2, Excel, Oracle, Hadoop)

 

The Rossett Group, Chevy Chase, MD                                             May 2003 to Dec 2006

Data Analyst

Responsibilities:        

·         Did Data Quality Analysis and reported the data quality issues to the client.

·         Created the Data Quality Scorecards for end user review

·         Experienced in documenting the ETL process flow for better maintenance and analysing the process flow.

·         Created an automated ETL summary report which consists of the summary information for all the loading activities done for day and month.

·         Experienced in data mapping using Microsoft Visual Studio Data Tools.

·         Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modelling.

·         Created, Maintained & Scheduled various reports in SSRS like Drill down and Drill through & Parameterized Reports using SQL Server Reporting Services SSRS.

·         Built, published customized interactive reports and dashboards, report scheduling using Tableau server.

·         Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

·         Developed Tableau visualizations and dashboards using Tableau Desktop. 

·         Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

·         Formatting from raw data into clean data, Updating and correcting clean data, and Input of data into database.

·         Responsible for running SQL queries against Oracle database to generate reports.

·         Identification of dataflow/workflow issues, as well as finding the source of the issues and resolving them.

·         Analysing technical requirements and design new data models or update existing data models.

·         Day to Day maintenance activities, Third Party Vendor Support

·         Knowledge and work experience in RDBMS concepts

·         Use z/OS DB2 Native Mainframe daily to perform DB2 DBA functions 

·         Experienced in z/OS mainframe environment using JCL and SQL. 

·         Created and updated JCL so jobs can be tested before they go into production. Use z/OS Mainframe daily to perform DB2 DBA functions. 

 

Environment: Waterfall Model, IBM Mainframes, z/OS operating systems, DB2 database, JCL, COBOL, REXX, MS Excel, MS Powerpoint.

 

Educational Qualifications:

 

Batcher degree in Computer Science and IT,

Southern New Hampshire University, MANCHESTER, NH