Data Tableau

.

CONTACT

Address : Randolph Massachusetts ***68

Phone : 774-***-****

Email : adjmqn@r.postjobfree.com

SKILLS

Tableau

Testing and evaluation

SQL Management studio

Training

CRISP-DM

Informatica 9.6/10.2

Oracle

Presently in the process to learn AWS

PROFESSIONAL SUMMARY

Built a central Database where data comes from different sources like oracle, SQL server and flat files. Actively involved as an Analyst for preparing design documents and interacted with the data modelers to understand the data model and design the ETL logic.

WORK HISTORY

TABLEAU AND ETL Informatica Developer, 04/2018 to Current

RR Donnelley Logistics - Westwood, MA

Built a central Database where data comes from different sources like oracle, SQL server and flat files. Actively involved as an Analyst for preparing design documents and interacted with the data modelers to understand the data model and design the ETL logic.

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.

• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and Union to develop robust mappings in the Informatica Designer.

• Created mapplets to use them in different mappings.

• Developed mappings to load into staging tables and then to Dimensions and Facts.

• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.

• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.

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

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

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

• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's

• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

• Restricted data for users using Row level security and User filters.

• Developed Tableau visualizations and dashboards using Tableau Desktop.

• Developed Tableau workbooks from multiple data sources using Data Blending.

Tableau and ETL Developer, 02/2016 to 01/2018

Ladders Group - Boston, MA

Responsibilities:

• Designing and creating SQL Server tables.

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

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

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

• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's

• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

• Restricted data for users using Row level security and User filters.

• Developed Tableau visualizations and dashboards using Tableau Desktop.

• Developed Tableau workbooks from multiple data sources using Data Blending.

TABLEAU aND ETL Developer, 06/2015 to 01/2016

PennyWise Llc - Cambridge, MA

Built a central Database where data comes from different sources like oracle, SQL server and flat files. Actively involved as an Analyst for preparing design documents and interacted with the data modelers to understand the data model and design the ETL logic.

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.

• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and Union to develop robust mappings in the Informatica Designer.

• Created mapplets to use them in different mappings.

• Developed mappings to load into staging tables and then to Dimensions and Facts.

• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.

• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.

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

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

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

• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's

• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

• Restricted data for users using Row level security and User filters.

• Developed Tableau visualizations and dashboards using Tableau Desktop.

• Developed Tableau workbooks from multiple data sources using Data Blending.

EDUCATION

Master of Science : Data Science, Expected in 04/2021

Southern New Hampshire University - Hooksett, NH

Bachelor of Science : Finance, 03/2017

Bridgewater State University - Bridgewater, MA

.

MAXILIEN NOUTCHA

Contact this candidate