-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.html
413 lines (331 loc) · 16.2 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
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Debbie Macrohon</title>
<meta name="description" content="">
<meta name="author" content="Debbie Macrohon">
<!-- Favicons
================================================== -->
<link rel="shortcut icon" href="img/favicon.ico" type="image/x-icon">
<!-- Bootstrap -->
<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
<!-- <link href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous"> -->
<link rel="stylesheet" type="text/css" href="fonts/font-awesome/css/font-awesome.css">
<!-- <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.7.1/css/all.css" integrity="sha384-fnmOCqbTlWIlj8LyTjo7mOUStjsKC4pOpQbqyi7RrhN7udi9RwhKkMHpvLbHG9Sr" crossorigin="anonymous"> -->
<link rel="stylesheet" type="text/css" href="css/timeline.css">
<link rel="preconnect" href="https://fonts.gstatic.com">
<link href="https://fonts.googleapis.com/css2?family=Montserrat&&family=Quattrocento+Sans&family=Quicksand&family=Tajawal&display=swap" rel="stylesheet">
<!-- Stylesheet
================================================== -->
<link rel="stylesheet" type="text/css" href="css/style.css">
<link rel="stylesheet" type="text/css" href="css/prettyPhoto.css">
<link rel="stylesheet" type="text/css" href="css/treeskills.css">
<script type="text/javascript" src="js/modernizr.custom.js"></script>
</head>
<body>
<div id="nav"><navbar/> </div>
<!-- Header -->
<header class="text-center" name="home">
<div class="intro-text" height="70%">
<p></p>
<p></p>
<p></p>
<p></p>
<!-- <img src="img/logo.png"> -->
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</div>
</header>
<!-- Portfolio Section -->
<div id="works-section" class="section-item">
<div class="container">
<!-- Container -->
<div class="section-title text-center center">
<h2>Portfolio</h2>
<hr>
<div class="clearfix"></div>
<p>Some of the projects I've done</p>
</div>
<div class="categories" id="categories">
<ul class="cat">
<li>
<ol class="type">
<li style="margin-bottom:15px" v-for="cat in categories">
<a href="#" :data-filter="cat.filter" :class="{ active: cat.isActive } ">{{cat.text}}</a>
</li>
</ol>
</li>
</ul>
<div class="clearfix"></div>
</div>
<div class="row">
<div class="portfolio-items" id="proj">
<project v-for="project in projects" v-bind:props="project">
<div class="text-center center">
<span v-for="e in project.exp" class="badge badge-pill badge-primary">{{e}}</span>
</div>
</project>
</div>
</div>
</div>
<div class=" text-center center">
<h3>Work Experience</h3>
</div>
<section class="cd-horizontal-timeline">
<div class="timeline">
<div class="events-wrapper">
<div class="events">
<ol>
<li>
<a href="#0" data-date="16/08/2015">Aug
<br/>2015</a>
</li>
<li>
<a href="#0" data-date="05/05/2016">May
<br/>2016</a>
</li>
<li>
<a href="#0" data-date="19/02/2019" class="selected">Feb
<br/>2019</a>
</li>
<li>
<a href="#0" data-date="27/04/2020">April
<br/>2020</a>
</li>
<li>
<a href="#0" data-date="09/08/2021">Aug
<br/>2021</a>
</li>
<!-- <li><a href="#0" data-date="09/08/2019">Aug 2019</a></li> -->
</ol>
<span class="filling-line" aria-hidden="true"></span>
</div>
<!-- .events -->
</div>
<!-- .events-wrapper -->
<ul class="cd-timeline-navigation">
<li>
<a href="#0" class="prev inactive">Prev</a>
</li>
<li>
<a href="#0" class="next">Next</a>
</li>
</ul>
<!-- .cd-timeline-navigation -->
</div>
<!-- .timeline -->
<div class="events-content">
<ol>
<li class="selected" data-date="16/08/2015">
<h4>Business Intelligence Student Assistant </h4>
<h5 id="uofc">University of Calgary</h5>
<br/>
<pre>
Designed a database for the university’s data dictionary application, documented parts of the
business process as well as the technical process behind the data dictionary
Collaborated with developers and business users for data dictionary and ensure their most urgent
needs were prioritized in the design
Researched other institution’s data dictionaries, and various educational research articles and
IT blogs about implementation methods for data dictionaries
</pre>
</li>
<li data-date="05/05/2016">
<h4>Systems Analyst</h4>
<h5 id="bridgewaterbank">Bridgewater Bank</h5>
<br/>
<pre>
Gathering requirements, creating mockups, test cases, traceability matrix and documentation,
designed database, developed the software and implemented security features of multiple internal
applications for Bridgewater Bank.
Developing on existing company framework that improve data quality using
Data Quality Services, Master Data Management and SSIS.
Ensuring production environment stability and mitigating risks by assessing code reviews
before deployment to production, developing a process to streamline the QA deployment process,
resolving business intelligence tickets.
</pre>
</li>
<li data-date="19/02/2019">
<h4>Software Developer</h4>
<h5 id="arcurve">Arcurve </h5>
<br/>
<pre>
Integrated data from various sources (external API, physical files, databases) into a single
unified source used for business reporting using SSIS (SQL Server Integration Services). Created SSRS
(SQL Server Reporting Services) reports from the consolidated data. Updated SSAS (SQL Server
Analysis Services) cube using DAX and and SQL views.
Created reports through Power BI and developed DAX formulas to achieve dynamic results. Optimized
Kusto queries from Azure Data Explorer and SQL queries from SQL Server Management Studio minimize
performance issues of the reports.
Working with creating, reading, updating, deleting object models through REST-ful APIs.
Developing file (xml, Excel) and web scraping methods (HTML) to parse data, transform them
into business-defined hierarchical models and integrate them into the system.
</pre>
</li>
<li data-date="27/04/2020">
<h4>ETL Developer</h4>
<h5 id="dynamicrisk">Dynamic Risk </h5>
<br/>
<pre>
Integrating data from SQL Server and Oracle sources into environments of clients' choice
(SQL Server or Oracle) for analyzing spillage, cracks or anomalies from inline inspection
data of their pipelines.
Created POC for data migration from on-prem database to Azure (SQL Database) using Data Factory.
Optimized processes and queries.
</pre>
</li>
<li data-date="09/08/2021">
<h4>Data Engineer - Sr Consultant</h4>
<h5 id="avanade">Avanade</h5>
<br/>
<pre>
Managed a group of 7 resources consisting of data, devops and QA engineers.
Created orchestration pipelines using Synapse and ADF and ETL pipelines using Databricks.
Developed PySpark notebook to materialize data and accommodate change data.
Influenced client decisions on best practices, solutions, general design and architecture.
Designed and building row level security for PowerBI reports and the data layer.
Configured resources for Data Lake Trickle from Dynamics365.
Configured Synapse with Data Landing Zone and leveraged CDMUtil to auto-create Synapse views
Built star schema data models using SQL for their supply chain management system in Azure Synapse dedicated pool from Dynamics365
</pre>
</li>
</ol>
</div>
<!-- .events-content -->
</section>
<div class=" text-center center">
<div class = " text-center center">
<h3>Certifications</h3>
<div data-iframe-width="150" data-iframe-height="270" data-share-badge-id="9676207f-fd7b-48b5-a329-91bcc0515fc0" data-share-badge-host="https://www.credly.com"></div><script type="text/javascript" async src="https://cdn.credly.com/assets/utilities/embed.js"></script>
<div data-iframe-width="150" data-iframe-height="270" data-share-badge-id="1b345186-a0b0-4803-ba91-510b3af83a0f" data-share-badge-host="https://www.credly.com"></div><script type="text/javascript" async src="https://cdn.credly.com/assets/utilities/embed.js"></script>
<div data-iframe-width="150" data-iframe-height="270" data-share-badge-id="c60906a1-6869-48d4-862a-bfb50ac5cedd" data-share-badge-host="https://www.credly.com"></div><script type="text/javascript" async src="https://cdn.credly.com/assets/utilities/embed.js"></script>
<div data-iframe-width="150" data-iframe-height="270" data-share-badge-id="6c20b4e0-4183-433f-bd36-c1a50f957757" data-share-badge-host="https://www.credly.com"></div><script type="text/javascript" async src="https://cdn.credly.com/assets/utilities/embed.js"></script>
<div data-iframe-width="150" data-iframe-height="270" data-share-badge-id="a43c709d-a92e-41f0-ae20-a0323ed2a9c3" data-share-badge-host="https://www.credly.com"></div><script type="text/javascript" async src="https://cdn.credly.com/assets/utilities/embed.js"></script>
</div>
<!-- <h3>Technical Experience</h3>
<p>How to read this chart:</p>
<p><strong>Select </strong> <i class="fa fa-hand-o-up"></i> a node to explore what skills make up my technical experience. The bigger the node, the greater experience I have
in that area.
</p>
</div>
<div class="section-item text-center">
<div id="treeskills" class="container thumbnail " style="overflow:scroll;"></div>
<p>powered by D3.js</p>
</div -->
</div>
</div>
<!-- About Section -->
<div id="about-section">
<div class="container">
<div class="section-title text-center center">
<h2>About</h2>
<hr>
<div class="clearfix"></div>
</div>
<div class="row">
<div class="col-md-4">
<div class="thumbnail">
<img class="img-circle" src="img/portfolio/headshot-2022.jpg"> </div>
</div>
<div class="col-md-8">
<div class="about-text">
<h4>Professional Snapshot</h4>
<p>
Emerging from the University of Calgary with a BSc in Computer Science, I’ve carved my niche at Avanade as a Data Engineering Consultant.
My professional canvas is painted with data - constructing sophisticated pipelines, designing compelling visualizations,
and deciphering patterns to extract actionable insights.
</p>
<h4>Beyond the Workstation</h4>
<p>
In the pursuit of technological excellence, I continually explore emerging data technologies, assessing their potential applications. My current professional compass points towards Spark and cloud computing, with Azure being my platform of choice.
Balancing my professional endeavors, I engage in a variety of leisure activities. I appreciate the tranquility of nature walks, the thrill of biking, and the culinary adventure of trying new eateries.
Social interactions are a vital part of my life, whether it’s casual gatherings,
strumming songs on my guitar, or immersing myself in the captivating worlds of video games and board games. 😊
</p>
</div>
<div class="social">
<ol class="typesocial">
<li style="margin-left:0px">
<a href="https://github.com/dtmacroh" target="_blank">
<i class="fa fa-github" aria-hidden="true"></i>
</a>
</li>
<li>
<a href="https://www.linkedin.com/in/debbie-macrohon-218115b3/" target="_blank">
<i class="fa fa-linkedin" aria-hidden="true"></i>
</a>
</li>
<li>
<a href="mailto:debbie.macrohon@gmail.com">
<i class="fa fa-envelope" aria-hidden="true"></i>
</a>
</li>
</ol>
</div>
</div>
</div>
</div>
</div>
<div id="contact-section" class="text-center">
<div class="container">
<div class="section-title center">
<h2>Contact</h2>
</div>
<div class="col-md-8 col-md-offset-2">
<h4>Leave me a message and I'll follow up as soon as I can!</h4>
<form action="https://formspree.io/f/mjvpapdp" method="POST">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<input type="text" name="name" id="name" class="form-control" placeholder="Name" required="required">
<p class="help-block text-danger"></p>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<input type="email" name="email" id="email" class="form-control" placeholder="Email" required="required">
<p class="help-block text-danger"></p>
</div>
</div>
</div>
<div class="form-group">
<textarea type="text" name="message" id="message" class="form-control" rows="4" placeholder="Message" required></textarea>
<p class="help-block text-danger"></p>
</div>
<div id="success"></div>
<button type="submit" value="Send" class="btn btn-default">Send Message</button>
</form>
</div>
</div>
</div>
<div style="position: absolute; bottom: 40px; right: 10px; font-size: 12px">
</div>
</div>
<div id="foot"><foot></foot></div>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script type="text/javascript" src="js/jquery.1.11.1.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="js/vue.js"></script>
<script src="js/navbar.js"></script>
<script src="js/vue-project.js" charset="utf-8"></script>
<script type="text/javascript" src="js/bootstrap.js"></script>
<script type="text/javascript" src="js/SmoothScroll.js"></script>
<script type="text/javascript" src="js/jquery.counterup.js"></script>
<script type="text/javascript" src="js/waypoints.js"></script>
<script type="text/javascript" src="js/jquery.prettyPhoto.js"></script>
<script type="text/javascript" src="js/jquery.isotope.js"></script>
<script type="text/javascript" src="js/jqBootstrapValidation.js"></script>
<!-- Javascripts
================================================== -->
<script type="text/javascript" src="js/main.js"></script>
<script type="text/javascript" src="js/timeline.js"></script>
<script src="https://d3js.org/d3.v3.min.js" charset="utf-8"></script>
<script src="js/treeskills.js" charset="utf-8"></script>
</body>
</html>