-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
328 lines (325 loc) · 21.5 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
<!DOCTYPE html>
<html lang="en">
<head>
<title>My Resume</title>
</head>
<body>
<h1>Paul Mascard</h1>
<img src="IMG_0584.JPEG" alt="profile image of Paul Mascard" height="175">
<hr>
<h1>Summary</h1>
<p>
I am a data management professional, with extensive experience of consolidating business operational data into, strategically and operationally aligned, consumable data repositories.
</p>
<p>
Role profiles have included:
<ul>
<li>Managerial - defining, building, restructuring, mentoring, and managing teams.</li>
<li>Analytical - business analysis, data analysis, data mapping, and process reengineering.</li>
<li>Development - data definition, manipulation, extraction, transforming and conforming.</li>
<li>Reporting - Semantic layer and reporting development.</li>
<li>Architectural - Data modelling, solution design and administration.</li>
<li>Governance - Data quality assessment, remediation, catalogues, policies, and frameworks.</li>
<li>Operational - Performance tuning, load process management and release management.</li>
</ul>
</p>
<p>
I am motivated by a desire to see organisations improve the effectiveness of data within their business processes, through sustainable practices that foster ownership, direction, and personal development within the team.
</p>
<p>
I am proficient in SQL and data development/transformation practices as well as being comfortable supporting the workflow using Microsoft Office, SharePoint, Confluence and Jira. I am always happy to improve skills and to learn new ones as the role demands.
</p>
<hr>
<h1>Skills</h1>
<h2>Experience and Role Proficiency</h2>
<ul>
<li>Data Management (60%)</li>
<li>Data Governance (Policies/Frameworks/Catalogue/Glossary/DQ/MDM/RDM) (80%)</li>
<li>Business Intelligence (75%)</li>
<li>Business Analysis (80%)</li>
<li>Data Modelling (60%)</li>
<li>Team Management (85%)</li>
<li>Business & IT Relations (90%)</li>
<li>Stakeholder Management (80%)</li>
<li>Coaching & Mentoring (90%)</li>
</ul>
<h2>Notable Skill Proficiency</h2>
<ul>
<li>SQL (as a data analyst and data warehouse developer) (75%)</li>
<li>Ataccama (PaaS, ONE Desktop, Glossary, DQ, DQIT, RDM) (45%)</li>
<li>Excel (workbooks, formulas, pivot tables and miinor VBA) (65%)</li>
<li>SharePoint (as a user/site owner) (65%)</li>
<li>Confluence (as a user/space owner) (50%)</li>
<li>Jira (as a product owner and contributor) (45%)</li>
</ul>
<hr>
<h1>Experience</h1>
<p>
Since 2008 I have predominantly operated as a freelance contractor but have held permanent positions including my last role. I have worked for high profile companies including Convex, LV Financial Services, MS Amlin, XL Catlin, Allianz Insurance, Aviva, and Sage.
</p>
<p>
The larger number of roles have been within the financial services sector, but I have also had experience of working within manufacturing, engineering, and SaaS.
</p>
<ul>
<li>
<h2>Data Culture Analyst - Convex</h2>
<p>11/2022 - 02/2024</p>
<p>Employed to take ownership of the technical aspects of operating and delivering data governance and data quality solutions using Ataccama and coordinating and mentoring two offshore resources that support delivery.</p>
<ul>
<li>Reviewed and analysed the current implementation identifying risk and operational weaknesses.</li>
<li>Development of data quality rules in support of business requirements.</li>
<li>Collaborate with existing data governance product owners to ensure to ensure DQ, RDM and Glossary supported their needs.</li>
<li>Guide the technical delivery team through the design and draft build of a data mart in support of future reporting from Ataccama use.</li>
<li>Delivered security improvements in support of internal audit findings.</li>
<li>Worked closely with Ataccama to improve knowledge and support for the business.</li>
<li>Developing ONE Desktop components for DQ, DQIT and RDM projects.</li>
</ul>
<p style="text-align: center;">| Ataccama | Snowflake | Confluence | Jira | Dropbox Paper |</p>
</li>
<li>
<h2>Technical Data Manager - LV Financial Services</h2>
<p>03/2021 - 10/2022 (FTC)</p>
<p>Providing maternity leave cover. My responsibilities included hands on development and delivery of business-driven MI and legacy data warehouse solutions as well as day to day management of requests, stakeholders, workload, and the single team member.</p>
<ul>
<li>Migrated spreadsheet based BAU request tracking to Jira.</li>
<li>Development and operation of progress tracking MI for a project processing a collection of high priority risk events.</li>
<li>Managed the development of MI for a migrated annuity book to meet actuarial modelling needs.</li>
<li>Analysis and solution input to a strategic customer trace and re-connection project with development of the solution scheduled to begin at the end of Q1.</li>
<li>Operational support and enhancement of the Finance data warehouse and BI deliverables.</li>
</ul>
<p style="text-align: center;"></p>
</li>
<li>
<h2>Senior Business Intelligence Manager - Audatex UK Limited</h2>
<p>07/2017 - 07/2019 (Contract to Permanent)</p>
<p>Reporting directly to the UK MD and managing senior stakeholder expectations in defining the business data strategy. Lead the MI development team through infrastructure and development improvements that would be able to deliver data solutions in line with that strategy.</p>
<ul>
<li>Restructured the existing MI team, justifying and recruiting additional resource.</li>
<li>Halved data warehouse load times and tripled reporting volume output.</li>
<li>Adjusted team practices resulting in a reduction in MI delivery failures.</li>
<li>Worked with technical, business and management teams to improve perceptions and relations.</li>
<li>Proposed UK/EMEA data strategy and led subsequent technology investigations.</li>
<li>Collaborated with corporate data teams on global data solutions and strategies.</li>
<li>Product owner for the data delivery needs of the business.</li>
</ul>
<p style="text-align: center;">| PL/SQL | Oracle 12 | Jira | SharePoint | Surface Hub | Teams |</p>
</li>
<li>
<h2>Functional Data Analyst - MS Amlin</h2>
<p>04/2016 - 06/2017 (Contract)</p>
<p>Master data management and data governance support during the final development phases of a new corporate data warehouse project.</p>
<ul>
<li>Improved the process for generating business natural keys for master data dimensions.</li>
<li>Performed the data steward role for unidentified business dimensional elements.</li>
<li>Provided data quality analysis and remediation actions for data load processes.</li>
<li>Defined and performed master data tests as part of the phased project deployments.</li>
<li>Developed and performed data governance processes to manage and maintain data quality.</li>
</ul>
<p style="text-align: center;">| Excel 2016 | SharePoint | Access 2016 | T-SQL |</p>
</li>
<li>
<h2>Data Warehouse Business Analyst - XL Catlin</h2>
<p>08/2014 - 03/2016 (Contract)</p>
<p>I joined XL Catlin as a member of the Data Warehouse Development Team to assist in general development and change request management for existing and new data warehouse projects.</p>
<ul>
<li>Defined requirements for data import and reconciliation on US data migration project.</li>
<li>Active participant in team based small-change analysis, development, and delivery for existing solutions.</li>
<li>Designed and developed schema and processes for performance monitoring of underwriting digitisation team.</li>
<li>Defined and performed master data tests as part of the phased project deployments.</li>
<li>Coordinated the business user group small-change request and prioritisation processes and stakeholder management for DW team requests.</li>
</ul>
<p style="text-align: center;">| T-SQL | SQL | SQL Server | Netezza | Jira | Cognos |</p>
</li>
<li>
<h2>MI Data Governance Analyst - Aviva</h2>
<p>09/2012 - 12/2013 (Contract)</p>
<p>Provide data governance and management expertise to the Guidewire implementation project.</p>
<ul>
<li>Defined project governance framework to ensure work met industry and regulatory requirements.</li>
<li>Governed the flow of data from Guidewire front end and event delivery to MI interfaces.</li>
<li>Defined and documented capture of architectural data flow metadata.</li>
<li>Instrumental in relaunching Data Architecture and Modelling as part of Aviva's Enterprise Architecture function.</li>
<li>Led the canonical data model work for the general insurance business.</li>
<li>Facilitated and assisted in the creation of the dimensional bus data model for general insurance.</li>
</ul>
<p style="text-align: center;">| SharePoint | Visio | Office |</p>
</li>
<li>
<h2>Data Analyst - Allianz</h2>
<p>10/2011 - 01/2012 (Contract)</p>
<p>Documenting data flows and classifying cross boundary risks in preparation for Allianz’s Solvency II submission.</p>
<ul>
<li>Ran workshops with actuaries to identify data elements and data flows used in risk models.</li>
<li>Documented data flow boundaries and assessed data degradation risks.</li>
<li>Created data directory, diagrams, and reports to highlight the value of metadata and interactive use.</li>
<li>Presented findings to FSA and Allianz gained approval for workstream standards and approach.</li>
</ul>
<p style="text-align: center;">| Excel | Workshops |</p>
</li>
<li>
<h2>Business Analyst - Aviva</h2>
<p>04/2010 - 07/2011 (Contract)</p>
<h3>Claims Control</h3>
<p>Defined all Claims Control project requirements for all identified interfaces and led the analysis of all data elements within the project, including transit control, batch process, interface schema & connected systems.</p>
<ul>
<li>Mapped data flows between claims and interfaced solutions, including the financial payment system.</li>
<li>Provided input to solution design for message handling and control.</li>
<li>Created test cases to investigate message failure scenarios and conducted testing.</li>
</ul>
<h3>Legacy MI Data Governance</h3>
<p>Improving data governance practices and issue tracking, escalation, and visibility for legacy MI platforms.</p>
<ul>
<li>Consulted with key MI stakeholders to define Data Quality Assurance requirements & highlight data governance weaknesses.</li>
<li>Designed and created SharePoint team site to track, manage & monitor MI data control issues.</li>
<li>Transitioned MI Issue Log and Tracker to operational use by the DQA team.</li>
</ul>
<h3>Critical Data Items</h3>
<p>Analysis of legacy data warehouses to identify and document critical data items as part of Aviva’s preparation for their Solvency II submission.</p>
<ul>
<li>Documented high-level architecture for data flows in and out of the legacy MI systems.</li>
<li>Designed and implemented data dictionary and document library.</li>
<li>Mapped data flow and identified areas of weakness.</li>
<li>Performed a data quality assessment for identified critical data items.</li>
</ul>
<p style="text-align: center;">| SharePoint | Visio | Excel | Google Graphs |</p>
</li>
<li>
<h2>MIS Developer - Halcrow</h2>
<p>03/2009 - 04/2010 (Contract)</p>
<p>Developing data warehouse solutions as part of the MIS team delivering products and services for train operators.</p>
<ul>
<li>Rapidly transitioned to a to the Halcrow ETL development product and automated test platform.</li>
<li>Designed, developed, and implemented ETL, dimensional structures to meet product requirements.</li>
</ul>
<p style="text-align: center;">| Hummingbird Genio | FitNesse | DokuWiki | IBM Rational Rose |</p>
</li>
<li>
<h2>BI Developer - Sage</h2>
<p>11/2008 - 11/2008 (Fixed Price Contract)</p>
<p>Converting Sage's BI product to process multi company data from multiple Sage products into a single database backend for common reporting. Developed and delivered the solution for deployment within 10 working days.</p>
<ul>
<li>Analysed the Sage BI Product data structures, load processes and control methods.</li>
<li>Designed and developed an SSIS solution to wrap the existing DTS packages using multiple dynamic connections to the multiple Sage accounting platforms.</li>
<li>Modified the data model to cater for the multi-entity storage and BI product reporting.</li>
<li>Developed deployment code to be run after the normal product deployments maintaining original product integrity.</li>
</ul>
<p style="text-align: center;">| SSIS | DTS | T-SQL |</p>
</li>
<li>
<h2>BI Developer - BGL Group</h2>
<p>02/2008 - 08/2008 (Contract)</p>
<p>Made operational improvements to the development team and then provide development services.</p>
<ul>
<li>Engaged with key stakeholders to establish appropriate operational service levels.</li>
<li>Developed & implemented a load process monitor tool providing operational failure call out capability.</li>
<li>Improved release processes & environment isolation.</li>
<li>Pioneered a culture of performance testing/improvement.</li>
<li>Created a solid foundation for future development and improved release success rates.</li>
<li>Analysed requirements & developed end to end consolidated Executive MI reporting platform.</li>
</ul>
<p style="text-align: center;">| SSIS | T-SQL | Excel | SSRS |</p>
</li>
<li>
<h2>MI Technical Lead - GMAC-RFC</h2>
<p>2005 - 01/2008</p>
<p>After the business appointed consultants to re-engineer the IT function, I elected to focus on technical development and delivery.</p>
<ul>
<li>Administration of the data warehouse and business intelligence platform.</li>
<li>Development and delivery of data warehouse work items as part of the development team.</li>
<li>Conducted various development and infrastructure upgrades.</li>
<li>Development and release management practices to be an intrinsic part of the team.</li>
<li>Mentored developers on problem solving, practices and standards.</li>
</ul>
<p style="text-align: center;">| SQL Server | Business Objects | T-SQL | SSIS |</p>
</li>
<li>
<h2>Data Warehouse Manager - GMAC-RFC</h2>
<p>2000 - 2005</p>
<p>I was asked to lead and build a team to manage the centralised storage and delivery of systems data in a data warehouse.</p>
<ul>
<li>Created and recruited the Data Warehouse Development team.</li>
<li>Successfully implemented historical data warehouse reporting alongside new operational data capture project.</li>
<li>Created standards and practices for robust data warehouse development and deployment.</li>
<li>Implemented Business Objects and managed semantic layer development.</li>
</ul>
<p style="text-align: center;">| SQL Server | Business Objects | T-SQL | SSIS |</p>
</li>
<li>
<h2>PC Systems Development Manager</h2>
<p>1997 - 2000</p>
<p>The overhead of a flat hierarchy had proven difficult to manage and I applied to manage the team formally again.</p>
<ul>
<li>Managed and grew the development team during the era of burgeoning PC system development.</li>
<li>Created working standards and practices to formalise SDLC in a fluid team environment.</li>
<li>Managed the transition from DOS to Windows based solutions.</li>
<li>Developed numerous departmental applications and management information systems.</li>
</ul>
<p style="text-align: center;">| Paradox |</p>
</li>
<li>
<h2>Senior MI Analyst Programmer - GMAC-RFC</h2>
<p>1995 - 1997</p>
<p>After starting my first management role, operating a flat hierarchy became fashionable and I was asked to lead the team from a technical perspective.</p>
<ul>
<li>Continued to develop and operationally manage the PC applications and business requests.</li>
<li>Formed relationships with the IT infrastructure and support teams as PCs and networking grew in performance and functionality.</li>
<li>Started to formalise development standards for user interface and data structures.</li>
</ul>
<p style="text-align: center;">| Paradox |</p>
</li>
<li>
<h2>Distributed Systems Manager - GMAC-RFC</h2>
<p>12/1993 - 1995</p>
<p>I was recruited to provide hands on management of a team developing early PC solutions to enhance the IT offerings from operational mainframe data.</p>
<ul>
<li>Took over existing data import and reporting processes from a long-term consultant.</li>
<li>Developed processes around the imported mainframe data to enhance and improve business exploitation.</li>
<li>Managed business work requests for small applications ahead of the long lead times for mainframe changes.</li>
<li>Centralised imported mainframe data for general consumption by an increasingly PC/data literate business community.</li>
</ul>
<p style="text-align: center;">| Paradox |</p>
</li>
<li>
<h2>Senior Analyst Programmer - Smith's Snackfood Company</h2>
<p>11/1990 - 11/1993</p>
<p>Developing PC business supporting applications and MI reporting in Paradox as well as aiding network implementation for the business as it moved away from mainframe only office solutions.</p>
<p style="text-align: center;">| Paradox |</p>
</li>
<li>
<h2>Senior Analyst - SEMA Group</h2>
<p>04/1990 - 10/1990</p>
<p>Systems analysis and documentation on MOD submarine systems.</p>
</li>
<li>
<h2>Senior Analyst Programmer - Prudential</h2>
<p>01/1988 - 03/1990</p>
<p>Developing PC business supporting and MI applications in Paradox as well as providing PC and network support.</p>
<p style="text-align: center;">| Paradox |</p>
</li>
<li>
<h2>Systems Engineer - Ferranti International</h2>
<p>06/1985 - 01/1988</p>
<p>Analysis and documentation on MoD naval missile systems including on site testing and sea trials.</p>
</li>
<li>
<h2>Electronics Engineer - Cirtronic Instruments</h2>
<p>07/1984 - 05/1985</p>
<p>PCB assembly and test. Instrument performance testing and calibration.</p>
</li>
</ul>
<hr>
<h1>Education</h1>
<h2>HND in Electronic Engineering - Reading College of Technology</h2>
<p>1982 - 1985</p>
<h2>OND in Electrical Engineering - Reading College of Technology</h2>
<p>1980 - 1982</p>
<h2>4 O-Levels & 2 GCSEs - Reading Blue Coat School</h2>
<p>1975 - 1980</p>
<hr>
<h1>Other</h1>
<ul>
<li><a href="contact.html">Contact Me</a></li>
<li><a href="bibliography.html">Reference Material</a></li>
</ul>
</body>
</html>