-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.html
373 lines (337 loc) · 12.9 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
<!DOCTYPE html>
<html lang="en" dir="ltr">
<head>
<meta charset="utf-8">
<title>Dan Amare Resume</title>
<link rel="stylesheet" href="styles.css">
</head>
<body >
<table >
<tr>
<td><img src="DanAmare.jpg" alt="Picture not found"> </td>
<td> [email protected] <br>
571-719-7589 <br>
Fairfax, VA <br> </td>
</tr>
</table>
<h1 class="index"> Dan Amare</h1>
<strong>Sr. Business Intelligence Engineer, Data Analyst</strong>
<ul>
<li>Over 18 years of designing and implementing BI, data analytics solutions.</li>
<li>Over 5 years of ETL and data engineering with Python. </li>
<li>Recent training and certification in Data Science with Python.</li>
<li>Available asap for permanent or long term contract position, remote/hybrid.</li>
</ul>
<hr>
<h3 id="education">Education</h3>
<p>
<ul>
<li>Certificate in Data Science with Python, <a href="https://www.coursera.org/account/accomplishments/specialization/G8HQNL8LW54F">Coursera University of Michigan.</a></li>
<li>M.A. in Economics, <a href="http://www.Tufts.edu">Tufts University.</a></li>
<li>B.A. in Mathematics, <a href="http://www.Dartmouth.edu">Dartmouth College.</a></li>
</ul>
</p>
<hr>
<h3>Summary Experiences</h3>
<ul>
<li>Sr. Business Intelligence Engineer, Data Analyst.</li>
<li>Expertise in business intelligence, data modeling, ETL, data visualization solutions. 20+ years.</li>
<li>Proficiency in dimensional modeling, ETL, data warehouses.</li>
<li>Sr ETL developer and data engineer with Python. </li>
<li>Working knowledge of data science, machine learning, LLMs, AI.</li>
<li>MicroStrategy certified architect, reports, dashboards developer.</li>
<li>Business Intelligence tools: MicroStrategy, Tableau, Power BI, Ab Initio ETL.</li>
<li>Platforms: Oracle, SQL Server, Teradata, Linux, AWS, MS Azure, Cloudera.</li>
<li>Programming: SQL, Python, Unix Scripts, PL/SQL, JavaScript, CSS, HTML. </li>
<li>Strong business and financial acumen, <a href="Sysplus2020.jpg">customer service skills.</a></li>
<li>Visualization samples: <a href="https://github.com/MstrDan/cv/blob/master/Risk Assessment Data Viz By Dan Amare.pdf">Dashboards</a>,
<a href="https://public.tableau.com/profile/dan.amare#!/">Tableau</a>,
<a href="https://github.com/MstrDan/cv/blob/master/PowerBICert.pdf">Power BI</a>,
<a href="https://mstrdan.github.io/cv/PythonViz.png">Python Matplotlib</a>.
</li>
<li>Technical <a href="https://github.com/MstrDan/cv/blob/master/Data Load Guide - Dan Amare.pdf">Writing sample</a>,
professional and academic <a href="https://github.com/MstrDan/Python-ML">Python code samples</a>.
</li>
<li>Online profiles: <a href="https://www.linkedin.com/in/dan-amare-aa37483/">LinkedIn</a>,
<a href="https://github.com/MstrDan/cv/blob/master/Cover Letter Data Analytics Nov 2024.pdf">Cover Letter</a>.
</li>
</ul>
<hr>
<h3>Skills Summary</h3>
<table>
<tr>
<td>
<table cellspacing="10">
<tr>
<td>Business Intelligence Architect</td>
<td>⭐⭐⭐⭐⭐</td>
</tr>
<tr>
<td>Data Visualization</td>
<td>⭐⭐⭐⭐⭐</td>
</tr>
<tr>
<td>Microstrategy BI Suite</td>
<td>⭐⭐⭐⭐⭐</td>
</tr>
<tr>
<td>Tableau</td>
<td>⭐⭐⭐</td>
</tr>
<tr>
<td>Power BI</td>
<td>⭐⭐⭐</td>
</tr>
<tr>
<td>Microsoft Excel/VBA</td>
<td>⭐⭐⭐⭐</td>
</tr>
</table>
</td>
<td>
<table cellspacing="10">
<tr>
<td>SQL</td>
<td>⭐⭐⭐⭐⭐</td>
</tr>
<tr>
<td>Python</td>
<td>⭐⭐⭐⭐</td>
</tr>
<tr>
<td>Unix Shell Scripting</td>
<td>⭐⭐⭐⭐</td>
</tr>
<tr>
<td>Oracle PL/SQL</td>
<td>⭐⭐⭐</td>
</tr>
<tr>
<td>HTML, CSS, JavaScript</td>
<td>⭐⭐⭐</td>
</tr>
<tr>
<td>C, C++, Java</td>
<td>⭐⭐</td>
</tr>
</table>
</td>
<td>
<table cellspacing="10">
<tr>
<td>Data modeling</td>
<td>⭐⭐⭐⭐⭐</td>
</tr>
<tr>
<td>Oracle, DB2, Sql Server</td>
<td>⭐⭐⭐⭐</td>
</tr>
<tr>
<td>AWS, MS Azure</td>
<td>⭐⭐</td>
</tr>
<tr>
<td>ETL and Data Engineering</td>
<td>⭐⭐⭐⭐</td>
</tr>
<tr>
<td>Data Science and Machine Learning</td>
<td>⭐⭐⭐</td>
</tr>
<tr>
<td>Agile, SDLC</td>
<td>⭐⭐⭐⭐</td>
</tr>
</table>
</td>
</tr>
</table>
<hr>
<h3>Work Experience</h3>
<table cellspacing="10">
<thead>
</thead>
<tbody>
<tr valign="top">
<td >October, 2020 - May, 2024</td>
<td>
<strong>Sr. Data Analyst, AmeriCorps, Washington, D.C.</strong>
<ul>
<li> Provided technical leadership for Risk Assessment data analytics application.</li>
<li> Worked with business users to gather requirements, design ETL applications.</li>
<li> Wrote complex SQL scripts, Python programs, import, transform data from APIs, Websites.</li>
<li> Implement MicroStrategy visualization dashboards, reports, email alerts.</li>
<li> Systems used: MicroStrategy v10.3, Oracle v10.2., Python v3.9.5</li>
</ul>
</td>
</tr>
<tr valign="top">
<td >March, 2018 - March, 2019</td>
<td>
<strong>Sr. BI Architect, CareFirst BCBS, Washington, D.C.</strong>
<ul>
<li> Designed and implemented reporting systems for internal and external clients.</li>
<li> Built interactive dashboards, analytics, visualizations, and user guides.</li>
<li> Created data models, logical views, custom organizational drill functionality.</li>
<li>Implemented report optimizations, indexes, SQL tunings, cubes, summary tables.</li>
<li>Systems used: Microstrategy v10.4, Cloudera Impala, DB2.</li>
</ul>
</td>
</tr>
<tr valign="top">
<td >August, 2016 - December, 2017</td>
<td>
<strong>Sr. Business Intelligence Architect, SEC, Washington, D.C</strong>
<ul>
<li> Architect visualization application for Division of Economic Risk Assessment.</li>
<li> Implement Microstrategy reports, documents, Dashboards, cubes, data integration.</li>
<li> Create data models, logical views, semantic and security layer, data transformations.</li>
<li> Provide demos to executives, functionality, POC results, design docs and user guides.</li>
<li> Systems used: Microstrategy v9.4, Oracle, SQL Developer Linux.</li>
</ul>
</td>
</tr>
<tr valign="top">
<td >November, 2014 - April, 2016</td>
<td>
<strong>Sr. Business Intelligence Consultant, Freddie Mac, Mclean, VA. </strong>
<ul>
<li>Architect Microstrategy reporting applications to track projects performance.</li>
<li>Create data model, design ETL, requirements tracking docs, testing plans.</li>
<li>Optimize reports performance via data cubes, summary tables, SQL tuning.</li>
<li>Research work on Microstrategy mobile reporting and location-based reporting.</li>
<li>Systems used: Microstrategy v10.2, Oracle, SQL Server, DB2, and Linux.</li>
</ul>
</td>
</tr>
<tr valign="top">
<td >April, 2014 - October, 2014</td>
<td>
<strong>Sr. BI Consultant, HUD, Washington, DC. </strong>
<ul>
<li>Data Modeler and developer for reporting application for Housing Inspections group.</li>
<li>Work with clients and architecture team to create data model for reporting solution.</li>
<li>Provide plan for environments set up and implementation of BI application.</li>
<li>Systems used: Microstrategy v9.3.1, Oracle 11g.</li>
</ul>
</td>
</tr>
<tr valign="top">
<td >October, 2012 - March, 2014</td>
<td>
<strong>Sr. BI Developer, USPS, Chantilly, VA. </strong>
<ul>
<li>Develop Dashboards on web and mobile platforms for US Postal CIO group.</li>
<li>Recognized by Microstrategy for excellence in Dashboard design and usability.</li>
<li>Setup Exception reporting using Microstrategy Narrowcast and Distribution Services.</li>
<li>Systems used: Microstrategy v9.3.1, UNIX, Oracle PL/SQL.</li>
</ul>
</td>
</tr>
<tr valign="top">
<td >October, 2010 - September, 2012</td>
<td>
<strong>Sr. Business Intelligence Consultant, Freddie Mac, Mclean, VA</strong>
<ul>
<li>Lead developer for reporting applications; provide administration of reporting servers.</li>
<li>Redesign data warehouse and schema layer to enable inter-departmental analytics.</li>
<li>Set up automation scripts to manage data cubes and exception reporting. </li>
<li>Systems used: Microstrategy v9.0.2/9.3.1, Linux, and SQL Server 2005.</li>
</ul>
</td>
</tr>
<tr valign="top">
<td >May, 2010 - September, 2010</td>
<td>
<strong>Business Intelligence Developer, GEICO, Bethesda, MD.</strong>
<ul>
<li>Develop enhancements to reporting applications, backup administrator.</li>
<li>Set up and implement Microstrategy software version upgrades.</li>
<li>Upgrade support documents on SDK customization; train team.</li>
<li>Systems used: Microstrategy v9.0, UNIX, DB2 development.</li>
</ul>
</td>
</tr>
<tr valign="top">
<td >August, 2009 - February, 2010</td>
<td>
<strong>Reporting Consultant, Bank of America, Charlotte, NC.</strong>
<ul>
<li> Set up Microstrategy server environment on Linux and Windows.</li>
<li> Create data models, schema layer, reports and dashboards.</li>
<li> Worked with data engineers to create Datamart and ETL applications.</li>
<li> Tools used: Microstrategy v9.0, Flex, Oracle, Netezza, and Linux.</li>
</ul>
</td>
</tr>
<tr valign="top">
<td >August, 2008 - June, 2009</td>
<td>
<strong>Sr. BI Developer, Premier Inc, Charlotte, NC.</strong>
<ul>
<li> Design and implement reporting and visualization applications.</li>
<li> Research work on integrating Adobe Flex visualization APIs with Microstrategy.</li>
<li> Design and implement reporting using Microstrategy Enterprise Services.</li>
<li> Tools used: Microstrategy v8.1, Flex, Oracle, SQL Server and Ab initio.</li>
</ul>
</td>
</tr>
<tr valign="top">
<td >June, 2007 - July, 2008</td>
<td>
<strong>Sr. BI Analyst Developer, AT&T, Alpharetta, GA.</strong>
<ul>
<li> Created reporting application for marketing clients, backup administrator.</li>
<li> Implemented software upgrades, configurations, security analysis & testing.</li>
<li> Work with backend teams to optimize performance; resolve QA issues.</li>
<li> Systems used: Microstrategy v8.1 and Teradata data warehouse.</li>
</ul>
</td>
</tr>
<tr valign="top">
<td >July, 2006 - June, 2007</td>
<td>
<strong>Sr. Technical Analyst, Freddie Mac, Mclean, VA.</strong>
<ul>
<li>Design and implement reporting solutions for Corporate Finance division.</li>
<li>Interface with clients, technology teams to implement reporting application.</li>
<li>Work with users to gather requirements, plan system and acceptance testing.</li>
<li>Systems used: Microstrategy v8, SAS and DB2.</li>
</ul>
</td>
</tr>
<tr valign="top">
<td >August, 1998 - April, 2006</td>
<td>
<strong>Manager, Capital One, Richmond, VA.</strong>
<ul>
<li>Progressively accumulated knowledge and experience through various departments.</li>
<li>Started with on-call support card services servers and front-end applications.</li>
<li>Promoted to more senior roles in database marketing and finance divisions.</li>
<li>Implemented ETL applications with Ab Initio, SQL, Unix shell scripts.</li>
<li>Obtain MicroStrategy BI certifications and implement reporting applications.</li>
<li>Served as architect, data steward, data modeler, developer, data engineer.</li>
<li>Travel overseas to Capital One sites to train and provide guidance to users.</li>
<li>Expertise in data warehouse, ETL, database, business intelligence technologies.</li>
<li>Tools used: Microstrategy 7i, Ab initio, C/Unix scripts, Teradata, Oracle, SQL Server.</li>
</ul>
</td>
</tr>
<tr valign="top">
<td >April, 1996 - July, 1998</td>
<td>
<strong>Programmer Analyst, Art Plus Technologies, Boston, MA.</strong>
<ul>
<li>Develop enhancements to reporting applications, backup administrator.</li>
<li> Design and implement document publication applications for financial clients.
<li> Develop code in C/C++ to extract data, transform and publish financial documents.
<li> Tools used: C/C++, Unix Shell scripts, Unisys COMPUSET publishing software.
</ul>
</td>
</tr>
</tbody>
<tfoot>
</tfoot>
</table>
</body>
</html>