Michael Monks Email & Phone Number | Skill & Experience Summary ● Data Modelling & Data/Change Management o Expertise in data system architecture & DW data modelling ▪ DW/BI Dimensional modelling (Kimball/Inmon - Dimensions/Facts/SCD) ▪ Analysis of user/business requirements ▪ Delivery of data marts/warehouses/reporting systems ▪ Integration of DB systems with BI Toolsets - Qlik/PowerBi/etc o Data & server migrations - Practical skills in Oracle/Teradata/etc to SQL Server/Azure data conversions. SQL version upgrades from legacy to current/cloud o DB Release/Change Management - Across DEV / QA / UAT & Production environments. SQL Versions 6.5 -> 2017/Azure o DB Review – Evaluation of current DB applications & performance. Proposal, plan & implementation of to improve execution, reduce maintenance and increase system resilience ● Data Engineering - SQL DBA & SQL / DW Developer o MS Certified DBA - Since 2005 (MCDBA), re-certified in 2019, currently undertaking additional Azure qualifications o Expert T-SQL/SSIS/SSRS – Highly experienced in DB/DW development, both BAU/re-factoring of existing codebases and with greenfield projects ● ELT/ETL o SSIS - Extensive practical experience in SSIS development & support – DTS/SSIS 2005 - 2017 o Re-architect existing SSIS/ETL solutions - With focus on improving performance, manageability and functionality whilst simplifying implementations o Knowledgeable with Azure ADF pipelines/dataflows with Azure Data Lake, Azure SQL & Azure SSAS o Experienced with legacy & latest MS BI Stack development tools BIDS/SSDT o Informatica versions 9/10 in Financial Services environments ● Reporting/BI Development o SSRS – Developed & supported wide range of reports in – SSRVS versions 2005 – 2017 o QlikView / QlikSense – Review & refresh existing dashboards / applications – primarily moving data load scripting to the appropriate DB layer o PowerBI – Conversion of SSRS reports, development of operational support dashboards o BOXI - SAP Business Objects XI – universe maintenance / report development & conversion o SSAS – Tabular / Cube - SQL Server Analysis Services both on-premises & Azure based

Michael Monks

Skill & Experience Summary ● Data Modelling & Data/Change Management o Expertise in data system arc...
Ireland

*50 free lookup(s) per month.

No credit card required.

Michael Monks’s Email michael_monks@ireland.com

Michael Monks’s Phone Numbers

Get MICHAEL’s Phone Number (For Free)

Social Media

Michael Monks’s Location Ireland

Michael Monks’s Current Industry Optum

Michael Monks’s Prior Industry Sgs Bord Gais Energy Realex Payments Sun Life Financial Bank Of Bearingpoint At Mediolanum Dps At Intel Future Finance Capita Asset Services Spencer Stuart Permanent Tsb Pioneer Investment Fidelity Investments Hewlett Packard Rcpi Microsoft Fleetmatics Health Service Executive | | | | | America Merrill Lynch | | | | | | | | | | | |

Not the Michael Monks you were looking for?

Find accurate emails & phone numbers for over 700M professionals.

Work Experience

Optum

Senior Data Engineer

2020-10-01 00:00:00 - Present

Health Service Executive

ETL/DW Consultant

2019-06-01 00:00:00 - 2020-10-01 00:00:00

Sgs

ETL/DW Consultant (Azure Data Lake/Azure SQL /ADF (SSIS)/SSAS)

2019-03-01 00:00:00 - 2019-05-01 00:00:00

Bord Gais Energy

ETL/DW Senior Consultant (SSIS/T-SQL & DW design/data modelling)

2018-03-01 00:00:00 - 2018-12-01 00:00:00

Realex Payments

Consultant DBA / Data Specialist

2017-12-01 00:00:00 - 2018-03-01 00:00:00

Sun Life Financial

Data Solutions Analyst / SQL-BI Developer

2017-05-01 00:00:00 - 2017-12-01 00:00:00

Bank Of America Merrill Lynch

SQL / SSRS / Python Consultant

2016-11-01 00:00:00 - 2017-05-01 00:00:00

Bearingpoint At Mediolanum

BI / SSIS / SQL Consultant

2016-08-01 00:00:00 - 2016-10-01 00:00:00

Dps At Intel

DBA / SSRS / SQL Developer (Contract)

2016-06-01 00:00:00 - 2016-08-01 00:00:00

Future Finance

Interim DBA / SQL Developer (Contract)

2016-04-01 00:00:00 - 2016-05-01 00:00:00

Capita Asset Services

SQL Architect \ DW Designer \ Developer (Contract)

2015-09-01 00:00:00 - 2016-03-01 00:00:00

Spencer Stuart

SQL Development \ Performance DBA

2015-05-01 00:00:00 - 2015-09-01 00:00:00

Permanent Tsb

SQL Architect / DW Developer (Contract)

2014-12-01 00:00:00 - 2015-05-01 00:00:00

Pioneer Investment

Senior SQL Server DBA

2014-07-01 00:00:00 - 2014-12-01 00:00:00

Fidelity Investments

Senior SQL (Oracle) Developer

2013-03-01 00:00:00 - 2013-05-01 00:00:00

Hewlett Packard

HP Financial Services - SQL/BI Developer/Data Warehouse Role (Contract)

2012-03-01 00:00:00 - 2013-03-01 00:00:00

Rcpi

DBA/Server/Applications Support

2011-07-01 00:00:00 - 2011-11-01 00:00:00

Microsoft

L3 Production Support/Subject Matter Expert (SME) (Contract)

2010-08-01 00:00:00 - 2011-06-01 00:00:00

Fleetmatics

DBA/SQL Performance Role

2010-02-01 00:00:00 - 2010-04-01 00:00:00

Skills

No Skills Available

Languages

No Languages Available

FAQ About Michael Monks

Michael Monks is located at
Ireland

Michael Monks is a Skill & Experience Summary ● Data Modelling & Data/Change Management o Expertise in data system architecture & DW data modelling ▪ DW/BI Dimensional modelling (Kimball/Inmon - Dimensions/Facts/SCD) ▪ Analysis of user/business requirements ▪ Delivery of data marts/warehouses/reporting systems ▪ Integration of DB systems with BI Toolsets - Qlik/PowerBi/etc o Data & server migrations - Practical skills in Oracle/Teradata/etc to SQL Server/Azure data conversions. SQL version upgrades from legacy to current/cloud o DB Release/Change Management - Across DEV / QA / UAT & Production environments. SQL Versions 6.5 -> 2017/Azure o DB Review – Evaluation of current DB applications & performance. Proposal, plan & implementation of to improve execution, reduce maintenance and increase system resilience ● Data Engineering - SQL DBA & SQL / DW Developer o MS Certified DBA - Since 2005 (MCDBA), re-certified in 2019, currently undertaking additional Azure qualifications o Expert T-SQL/SSIS/SSRS – Highly experienced in DB/DW development, both BAU/re-factoring of existing codebases and with greenfield projects ● ELT/ETL o SSIS - Extensive practical experience in SSIS development & support – DTS/SSIS 2005 - 2017 o Re-architect existing SSIS/ETL solutions - With focus on improving performance, manageability and functionality whilst simplifying implementations o Knowledgeable with Azure ADF pipelines/dataflows with Azure Data Lake, Azure SQL & Azure SSAS o Experienced with legacy & latest MS BI Stack development tools BIDS/SSDT o Informatica versions 9/10 in Financial Services environments ● Reporting/BI Development o SSRS – Developed & supported wide range of reports in – SSRVS versions 2005 – 2017 o QlikView / QlikSense – Review & refresh existing dashboards / applications – primarily moving data load scripting to the appropriate DB layer o PowerBI – Conversion of SSRS reports, development of operational support dashboards o BOXI - SAP Business Objects XI – universe maintenance / report development & conversion o SSAS – Tabular / Cube - SQL Server Analysis Services both on-premises & Azure based

Michael Monks currently works in the Optum |

No Languages Available

Michael Monks has prior
experience in the following industries:
Health Service Executive | Sgs | Bord Gais Energy | Realex Payments | Sun Life Financial | Bank Of America Merrill Lynch | Bearingpoint At Mediolanum | Dps At Intel | Future Finance | Capita Asset Services | Spencer Stuart | Permanent Tsb | Pioneer Investment | Fidelity Investments | Hewlett Packard | Rcpi | Microsoft | Fleetmatics

Michael Monks has the following professional experience:
Optum | Health Service Executive | Sgs | Bord Gais Energy | Realex Payments | Sun Life Financial | Bank Of America Merrill Lynch | Bearingpoint At Mediolanum | Dps At Intel | Future Finance | Capita Asset Services | Spencer Stuart | Permanent Tsb | Pioneer Investment | Fidelity Investments | Hewlett Packard | Rcpi | Microsoft | Fleetmatics