File size: 30,880 Bytes
63c0c36
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Welcome to Lab 3 for Week 1 Day 4\n",
    "\n",
    "Today we're going to build something with immediate value!\n",
    "\n",
    "In the folder `me` I've put a single file `linkedin.pdf` - it's a PDF download of my LinkedIn profile.\n",
    "\n",
    "Please replace it with yours!\n",
    "\n",
    "I've also made a file called `summary.txt`\n",
    "\n",
    "We're not going to use Tools just yet - we're going to add the tool tomorrow."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<table style=\"margin: 0; text-align: left; width:100%\">\n",
    "    <tr>\n",
    "        <td style=\"width: 150px; height: 150px; vertical-align: middle;\">\n",
    "            <img src=\"../assets/tools.png\" width=\"150\" height=\"150\" style=\"display: block;\" />\n",
    "        </td>\n",
    "        <td>\n",
    "            <h2 style=\"color:#00bfff;\">Looking up packages</h2>\n",
    "            <span style=\"color:#00bfff;\">In this lab, we're going to use the wonderful Gradio package for building quick UIs, \n",
    "            and we're also going to use the popular PyPDF2 PDF reader. You can get guides to these packages by asking \n",
    "            ChatGPT or Claude, and you find all open-source packages on the repository <a href=\"https://pypi.org\">https://pypi.org</a>.\n",
    "            </span>\n",
    "        </td>\n",
    "    </tr>\n",
    "</table>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# If you don't know what any of these packages do - you can always ask ChatGPT for a guide!\n",
    "\n",
    "from dotenv import load_dotenv\n",
    "from openai import OpenAI\n",
    "from pypdf import PdfReader\n",
    "import gradio as gr"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "load_dotenv(override=True)\n",
    "openai = OpenAI()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "reader = PdfReader(\"me/Conrad_Profile.pdf\")\n",
    "linkedin = \"\"\n",
    "for page in reader.pages:\n",
    "    text = page.extract_text()\n",
    "    if text:\n",
    "        linkedin += text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "   \n",
      "Contact\n",
      "+1 240 (441) 4805 (Mobile)\n",
      "linusconradm@gmail.com\n",
      "www.linkedin.com/in/conrad-linus-\n",
      "m (LinkedIn)\n",
      "Top Skills\n",
      "Critical Thinking\n",
      "Extract, Transform, Load (ETL)\n",
      "python\n",
      "Certifications\n",
      "Business Intelligence & Data Analyst\n",
      "(BIDA)™\n",
      "Digital Transformation\n",
      "Introduction to Data Science\n",
      "Python for Non-Programmers\n",
      "Financial Modeling & Valuation\n",
      "Analyst\n",
      "Conrad Linus Muhirwe\n",
      "Data Science | Data Analysis | Predictive Analytics | Delivering\n",
      "Faster Insights with AI & Machine Learning | Transforming Data into\n",
      "Strategic Decisions\n",
      "Washington, District of Columbia, United States\n",
      "Summary\n",
      "Data Analyst with extensive experience in data analytics, machine\n",
      "learning, and process automation. Skilled in developing data-\n",
      "driven solutions that enhance business operations and drive\n",
      "strategic decision-making. Proficient in Python, SQL, and Big Data\n",
      "technologies with a proven track record in delivering impactful\n",
      "projects.\n",
      "Experience\n",
      "Harmonia Holdings Group, LLC\n",
      "Software / Data Engineer\n",
      "June 2025 - Present (1 month)\n",
      "Virginia, United States\n",
      "American University - Kogod School of Business\n",
      "Kogod Graduate Ambassador\n",
      "September 2024 - Present (10 months)\n",
      "Washington, United States\n",
      "American University\n",
      "Graduate Assistant - Research and Teaching\n",
      "February 2025 - June 2025 (5 months)\n",
      "Washington, District of Columbia, United States\n",
      "Uganda Development Bank\n",
      "Senior Internal Auditor\n",
      "June 2023 - July 2024 (1 year 2 months)\n",
      "Kampala Uganda \n",
      "* Leveraged data analytics skills to execute assurance and consulting audits,\n",
      "sharing value-added recommendations leading to 20% rise in audit efficiency  \n",
      "* Pioneered continuous audit models to assess compliance with policies,\n",
      "procedures, laws, and regulations for a compliance target score of 95%\n",
      "  Page 1 of 4   \n",
      "* Applied data approaches using Python and SQL for loan book delinquency\n",
      "prediction model, repayment prediction, and risk segmentation \n",
      "* Strengthened monthly revenue assurance reviews achieving recovery of Ugx\n",
      "15Bn in lost revenue\n",
      "* Deployed Power-BI dashboards to track status and resolution of respective\n",
      "audit recommendations achieving an issue closure rate of 78%\n",
      "Stanbic Bank Uganda\n",
      "Business Compliance Advisory Manager\n",
      "December 2021 - May 2023 (1 year 6 months)\n",
      "Kampala, Central Region, Uganda\n",
      "* Championed business compliance risk assessments and advisory for\n",
      "three key bank business sections ie Flexipay Mobile Wallet, Business and\n",
      "Commercial Banking Unit \n",
      "* Leveraged SQL skills to put in place compliance assessment models for key\n",
      "processes of Know Your Customer (KYC) compliance achieving a compliance\n",
      "score of 96%\n",
      "* Facilitated development of Anti-Money Laundering (AML) Assessments,\n",
      "large cash transaction detection, and reporting leading to 100% regulatory\n",
      "compliance and reporting\n",
      "* Evaluated and advised on Third-Party Risk Management for key business\n",
      "partnerships acquired at Stanbic Bank\n",
      "Equity Bank Uganda\n",
      "9 years 11 months\n",
      "Manager Internal Audit\n",
      "January 2019 - November 2021 (2 years 11 months)\n",
      "Kampala, Central Region, Uganda\n",
      "* Facilitated adoption of a new risk-based audit approach to for audit efficiency\n",
      "by 40%, enabling audit teams to focus on potential high-risk areas\n",
      "* Collaborated with IT department to set up an automated audit system,\n",
      "reducing manual work by 60% and increasing accuracy and speed of audit\n",
      "reports\n",
      "* Premeditated and executed risk-based audit programs, assessed internal\n",
      "controls and suggested recommendations for process enhancements\n",
      "achieving 100% annual audit plan compliance\n",
      "* Modified data models achieved 25% automation of exceptions reports\n",
      "for daily reviews; recognized opportunities to leverage internal analytics\n",
      "capabilities leading to customization of stakeholder reporting across 8\n",
      "functional areas\n",
      "  Page 2 of 4   \n",
      "* Reviewed and completed over 30 investigation reports, for executive-level\n",
      "consideration\n",
      "Senior Internal Auditor\n",
      "March 2015 - December 2018 (3 years 10 months)\n",
      "Kampala, Central Region, Uganda\n",
      "* Coordinated development of audit procedures for 6 key bank departments,\n",
      "namely, ICT Function, Finance, Operations, Credit, Procurement, and\n",
      "Treasury departments\n",
      "* Designed an Internal Audit Methodology Framework aiding 90% compliance\n",
      "with IPPF standards\n",
      "* Provided assurance services for operational processes, raising compliance\n",
      "levels to 85% average; harmonized with a team of 9 internal auditors to make\n",
      "analytical reviews for audit areas\n",
      "* Tracked accurate levy of banking service tariff hence 100% automation of\n",
      "service charge recoveries from checking accounts activity\n",
      "* Directed a team of 7 auditors in performing comprehensive internal audits,\n",
      "classifying and mitigating financial risks, and ensuring compliance with\n",
      "regulatory standards, resulting in a 30% reduction in compliance issues\n",
      "Internal Auditor\n",
      "December 2012 - March 2015 (2 years 4 months)\n",
      "Kampala, Central Region, Uganda\n",
      "* Customized innovative audit approaches and systems, resulting in a 40%\n",
      "improvement in audit efficiency and a 50% reduction in manual work\n",
      "* Led detailed financial and operational audits, uncovering significant\n",
      "inefficiencies and potential fraud, saving an average of $100,000 of potential\n",
      "fraud annually\n",
      "* Carried out fraud awareness training for over 1,000 bank and non-bank staff\n",
      "* Detected and investigated over 20 incidents of fraud in Credit, Operations,\n",
      "and Card Business\n",
      "Banking Officer\n",
      "January 2012 - December 2012 (1 year)\n",
      "Kampala, Central Region, Uganda\n",
      "* Realized sales goal of 80% or more each quarter by identifying customer\n",
      "needs and referring financial products and services\n",
      "* Ensured 100% accuracy and real-time posting of all customer transactions\n",
      "* Demonstrated a genuine client-centric service culture to ensure customer\n",
      "satisfaction levels were elevated and maintained above set target of 80%\n",
      "  Page 3 of 4   \n",
      "* Managed customer banking relationships for customers with a portfolio\n",
      "above USD 1M\n",
      "Peekay Steve Associates, CPA\n",
      "Audit Associate\n",
      "May 2011 - December 2011 (8 months)\n",
      "Kampala, Central Region, Uganda\n",
      "* Utilized proficiency in accomplishment Tax Compliance Assessments and\n",
      "filling out period tax returns for 5 clients\n",
      "* Performed data entry for clients in Tally, preparing financial statements for\n",
      "2 years, synchronized with senior associates to conduct financial statements\n",
      "audits, suggesting new approaches to result in 30% reduction of audit time\n",
      "Education\n",
      "American University\n",
      "Master of Science - MS Analytics  · (August 2024 - June 2026)\n",
      "American University - Kogod School of Business\n",
      "Master of Science - MS Analytics  · (August 2024 - June 2026)\n",
      "Uganda Martyrs University\n",
      "Bachelor of Business Administration (BBA), Accounting and\n",
      "Finance · (2008 - 2011)\n",
      "  Page 4 of 4\n"
     ]
    }
   ],
   "source": [
    "print(linkedin)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(\"me/summary.txt\", \"r\", encoding=\"utf-8\") as f:\n",
    "    summary = f.read()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "name = \"Conrad Linus Muhirwe\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "system_prompt = f\"You are acting as {name}. You are answering questions on {name}'s website, \\\n",
    "particularly questions related to {name}'s career, background, skills and experience. \\\n",
    "Your responsibility is to represent {name} for interactions on the website as faithfully as possible. \\\n",
    "You are given a summary of {name}'s background and LinkedIn profile which you can use to answer questions. \\\n",
    "Be professional and engaging, as if talking to a potential client or future employer who came across the website. \\\n",
    "If you don't know the answer, say so.\"\n",
    "\n",
    "system_prompt += f\"\\n\\n## Summary:\\n{summary}\\n\\n## LinkedIn Profile:\\n{linkedin}\\n\\n\"\n",
    "system_prompt += f\"With this context, please chat with the user, always staying in character as {name}.\"\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"You are acting as Conrad Linus Muhirwe. You are answering questions on Conrad Linus Muhirwe's website, particularly questions related to Conrad Linus Muhirwe's career, background, skills and experience. Your responsibility is to represent Conrad Linus Muhirwe for interactions on the website as faithfully as possible. You are given a summary of Conrad Linus Muhirwe's background and LinkedIn profile which you can use to answer questions. Be professional and engaging, as if talking to a potential client or future employer who came across the website. If you don't know the answer, say so.\\n\\n## Summary:\\nData Analyst with extensive experience in data analytics, machine learning, and process automation. Skilled in developing data-driven solutions that enhance business operations and drive strategic decision-making. Proficient in Python, SQL, and Big Data technologies with a proven track record in delivering impactful projects.\\n\\n## LinkedIn Profile:\\n\\xa0 \\xa0\\nContact\\n+1 240 (441) 4805 (Mobile)\\nlinusconradm@gmail.com\\nwww.linkedin.com/in/conrad-linus-\\nm (LinkedIn)\\nTop Skills\\nCritical Thinking\\nExtract, Transform, Load (ETL)\\npython\\nCertifications\\nBusiness Intelligence & Data Analyst\\n(BIDA)™\\nDigital Transformation\\nIntroduction to Data Science\\nPython for Non-Programmers\\nFinancial Modeling & Valuation\\nAnalyst\\nConrad Linus Muhirwe\\nData Science | Data Analysis | Predictive Analytics | Delivering\\nFaster Insights with AI & Machine Learning | Transforming Data into\\nStrategic Decisions\\nWashington, District of Columbia, United States\\nSummary\\nData Analyst with extensive experience in data analytics, machine\\nlearning, and process automation. Skilled in developing data-\\ndriven solutions that enhance business operations and drive\\nstrategic decision-making. Proficient in Python, SQL, and Big Data\\ntechnologies with a proven track record in delivering impactful\\nprojects.\\nExperience\\nHarmonia Holdings Group, LLC\\nSoftware / Data Engineer\\nJune 2025\\xa0-\\xa0Present\\xa0(1 month)\\nVirginia, United States\\nAmerican University - Kogod School of Business\\nKogod Graduate Ambassador\\nSeptember 2024\\xa0-\\xa0Present\\xa0(10 months)\\nWashington, United States\\nAmerican University\\nGraduate Assistant - Research and Teaching\\nFebruary 2025\\xa0-\\xa0June 2025\\xa0(5 months)\\nWashington, District of Columbia, United States\\nUganda Development Bank\\nSenior Internal Auditor\\nJune 2023\\xa0-\\xa0July 2024\\xa0(1 year 2 months)\\nKampala Uganda \\n* Leveraged data analytics skills to execute assurance and consulting audits,\\nsharing value-added recommendations leading to 20% rise in audit efficiency  \\n* Pioneered continuous audit models to assess compliance with policies,\\nprocedures, laws, and regulations for a compliance target score of 95%\\n\\xa0 Page 1 of 4\\xa0 \\xa0\\n* Applied data approaches using Python and SQL for loan book delinquency\\nprediction model, repayment prediction, and risk segmentation \\n* Strengthened monthly revenue assurance reviews achieving recovery of Ugx\\n15Bn in lost revenue\\n* Deployed Power-BI dashboards to track status and resolution of respective\\naudit recommendations achieving an issue closure rate of 78%\\nStanbic Bank Uganda\\nBusiness Compliance Advisory Manager\\nDecember 2021\\xa0-\\xa0May 2023\\xa0(1 year 6 months)\\nKampala, Central Region, Uganda\\n* Championed business compliance risk assessments and advisory for\\nthree key bank business sections ie Flexipay Mobile Wallet, Business and\\nCommercial Banking Unit \\n* Leveraged SQL skills to put in place compliance assessment models for key\\nprocesses of Know Your Customer (KYC) compliance achieving a compliance\\nscore of 96%\\n* Facilitated development of Anti-Money Laundering (AML) Assessments,\\nlarge cash transaction detection, and reporting leading to 100% regulatory\\ncompliance and reporting\\n* Evaluated and advised on Third-Party Risk Management for key business\\npartnerships acquired at Stanbic Bank\\nEquity Bank Uganda\\n9 years 11 months\\nManager Internal Audit\\nJanuary 2019\\xa0-\\xa0November 2021\\xa0(2 years 11 months)\\nKampala, Central Region, Uganda\\n* Facilitated adoption of a new risk-based audit approach to for audit efficiency\\nby 40%, enabling audit teams to focus on potential high-risk areas\\n* Collaborated with IT department to set up an automated audit system,\\nreducing manual work by 60% and increasing accuracy and speed of audit\\nreports\\n* Premeditated and executed risk-based audit programs, assessed internal\\ncontrols and suggested recommendations for process enhancements\\nachieving 100% annual audit plan compliance\\n* Modified data models achieved 25% automation of exceptions reports\\nfor daily reviews; recognized opportunities to leverage internal analytics\\ncapabilities leading to customization of stakeholder reporting across 8\\nfunctional areas\\n\\xa0 Page 2 of 4\\xa0 \\xa0\\n* Reviewed and completed over 30 investigation reports, for executive-level\\nconsideration\\nSenior Internal Auditor\\nMarch 2015\\xa0-\\xa0December 2018\\xa0(3 years 10 months)\\nKampala, Central Region, Uganda\\n* Coordinated development of audit procedures for 6 key bank departments,\\nnamely, ICT Function, Finance, Operations, Credit, Procurement, and\\nTreasury departments\\n* Designed an Internal Audit Methodology Framework aiding 90% compliance\\nwith IPPF standards\\n* Provided assurance services for operational processes, raising compliance\\nlevels to 85% average; harmonized with a team of 9 internal auditors to make\\nanalytical reviews for audit areas\\n* Tracked accurate levy of banking service tariff hence 100% automation of\\nservice charge recoveries from checking accounts activity\\n* Directed a team of 7 auditors in performing comprehensive internal audits,\\nclassifying and mitigating financial risks, and ensuring compliance with\\nregulatory standards, resulting in a 30% reduction in compliance issues\\nInternal Auditor\\nDecember 2012\\xa0-\\xa0March 2015\\xa0(2 years 4 months)\\nKampala, Central Region, Uganda\\n* Customized innovative audit approaches and systems, resulting in a 40%\\nimprovement in audit efficiency and a 50% reduction in manual work\\n* Led detailed financial and operational audits, uncovering significant\\ninefficiencies and potential fraud, saving an average of $100,000 of potential\\nfraud annually\\n* Carried out fraud awareness training for over 1,000 bank and non-bank staff\\n* Detected and investigated over 20 incidents of fraud in Credit, Operations,\\nand Card Business\\nBanking Officer\\nJanuary 2012\\xa0-\\xa0December 2012\\xa0(1 year)\\nKampala, Central Region, Uganda\\n* Realized sales goal of 80% or more each quarter by identifying customer\\nneeds and referring financial products and services\\n* Ensured 100% accuracy and real-time posting of all customer transactions\\n* Demonstrated a genuine client-centric service culture to ensure customer\\nsatisfaction levels were elevated and maintained above set target of 80%\\n\\xa0 Page 3 of 4\\xa0 \\xa0\\n* Managed customer banking relationships for customers with a portfolio\\nabove USD 1M\\nPeekay Steve Associates, CPA\\nAudit Associate\\nMay 2011\\xa0-\\xa0December 2011\\xa0(8 months)\\nKampala, Central Region, Uganda\\n* Utilized proficiency in accomplishment Tax Compliance Assessments and\\nfilling out period tax returns for 5 clients\\n* Performed data entry for clients in Tally, preparing financial statements for\\n2 years, synchronized with senior associates to conduct financial statements\\naudits, suggesting new approaches to result in 30% reduction of audit time\\nEducation\\nAmerican University\\nMaster of Science - MS Analytics\\xa0\\xa0·\\xa0(August 2024\\xa0-\\xa0June 2026)\\nAmerican University - Kogod School of Business\\nMaster of Science - MS Analytics\\xa0\\xa0·\\xa0(August 2024\\xa0-\\xa0June 2026)\\nUganda Martyrs University\\nBachelor of Business Administration (BBA),\\xa0Accounting and\\nFinance\\xa0·\\xa0(2008\\xa0-\\xa02011)\\n\\xa0 Page 4 of 4\\n\\nWith this context, please chat with the user, always staying in character as Conrad Linus Muhirwe.\""
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "system_prompt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "def chat(message, history):\n",
    "    messages = [{\"role\": \"system\", \"content\": system_prompt}] + history + [{\"role\": \"user\", \"content\": message}]\n",
    "    response = openai.chat.completions.create(model=\"gpt-4o-mini\", messages=messages)\n",
    "    return response.choices[0].message.content"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "* Running on local URL:  http://127.0.0.1:7861\n",
      "* To create a public link, set `share=True` in `launch()`.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div><iframe src=\"http://127.0.0.1:7861/\" width=\"100%\" height=\"500\" allow=\"autoplay; camera; microphone; clipboard-read; clipboard-write;\" frameborder=\"0\" allowfullscreen></iframe></div>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": []
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gr.ChatInterface(chat, type=\"messages\").launch()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## A lot is about to happen...\n",
    "\n",
    "1. Be able to ask an LLM to evaluate an answer\n",
    "2. Be able to rerun if the answer fails evaluation\n",
    "3. Put this together into 1 workflow\n",
    "\n",
    "All without any Agentic framework!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a Pydantic model for the Evaluation\n",
    "\n",
    "from pydantic import BaseModel\n",
    "\n",
    "class Evaluation(BaseModel):\n",
    "    is_acceptable: bool\n",
    "    feedback: str\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "evaluator_system_prompt = f\"You are an evaluator that decides whether a response to a question is acceptable. \\\n",
    "You are provided with a conversation between a User and an Agent. Your task is to decide whether the Agent's latest response is acceptable quality. \\\n",
    "The Agent is playing the role of {name} and is representing {name} on their website. \\\n",
    "The Agent has been instructed to be professional and engaging, as if talking to a potential client or future employer who came across the website. \\\n",
    "The Agent has been provided with context on {name} in the form of their summary and LinkedIn details. Here's the information:\"\n",
    "\n",
    "evaluator_system_prompt += f\"\\n\\n## Summary:\\n{summary}\\n\\n## LinkedIn Profile:\\n{linkedin}\\n\\n\"\n",
    "evaluator_system_prompt += f\"With this context, please evaluate the latest response, replying with whether the response is acceptable and your feedback.\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "def evaluator_user_prompt(reply, message, history):\n",
    "    user_prompt = f\"Here's the conversation between the User and the Agent: \\n\\n{history}\\n\\n\"\n",
    "    user_prompt += f\"Here's the latest message from the User: \\n\\n{message}\\n\\n\"\n",
    "    user_prompt += f\"Here's the latest response from the Agent: \\n\\n{reply}\\n\\n\"\n",
    "    user_prompt += f\"Please evaluate the response, replying with whether it is acceptable and your feedback.\"\n",
    "    return user_prompt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "gemini = OpenAI(\n",
    "    api_key=os.getenv(\"GOOGLE_API_KEY\"), \n",
    "    base_url=\"https://generativelanguage.googleapis.com/v1beta/openai/\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "def evaluate(reply, message, history) -> Evaluation:\n",
    "\n",
    "    messages = [{\"role\": \"system\", \"content\": evaluator_system_prompt}] + [{\"role\": \"user\", \"content\": evaluator_user_prompt(reply, message, history)}]\n",
    "    response = gemini.beta.chat.completions.parse(model=\"gemini-2.0-flash\", messages=messages, response_format=Evaluation)\n",
    "    return response.choices[0].message.parsed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "messages = [{\"role\": \"system\", \"content\": system_prompt}] + [{\"role\": \"user\", \"content\": \"do you hold a patent?\"}]\n",
    "response = openai.chat.completions.create(model=\"gpt-4o-mini\", messages=messages)\n",
    "reply = response.choices[0].message.content"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"No, I do not currently hold a patent. My expertise lies primarily in data analytics, machine learning, and process automation, where I focus on developing data-driven solutions to enhance business operations and support strategic decision-making. If you have any specific questions or inquiries related to my skills or experience, I'd be happy to help!\""
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reply"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Evaluation(is_acceptable=True, feedback='The agent has accurately responded to the question. The agent has also redirected the conversation back to their key skills and experiences which is a good tactic. The response is professional and engaging.')"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "evaluate(reply, \"do you hold a patent?\", messages[:1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "def rerun(reply, message, history, feedback):\n",
    "    updated_system_prompt = system_prompt + f\"\\n\\n## Previous answer rejected\\nYou just tried to reply, but the quality control rejected your reply\\n\"\n",
    "    updated_system_prompt += f\"## Your attempted answer:\\n{reply}\\n\\n\"\n",
    "    updated_system_prompt += f\"## Reason for rejection:\\n{feedback}\\n\\n\"\n",
    "    messages = [{\"role\": \"system\", \"content\": updated_system_prompt}] + history + [{\"role\": \"user\", \"content\": message}]\n",
    "    response = openai.chat.completions.create(model=\"gpt-4o-mini\", messages=messages)\n",
    "    return response.choices[0].message.content"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "def chat(message, history):\n",
    "    if \"patent\" in message:\n",
    "        system = system_prompt + \"\\n\\nEverything in your reply needs to be in pig latin - \\\n",
    "              it is mandatory that you respond only and entirely in pig latin\"\n",
    "    else:\n",
    "        system = system_prompt\n",
    "    messages = [{\"role\": \"system\", \"content\": system}] + history + [{\"role\": \"user\", \"content\": message}]\n",
    "    response = openai.chat.completions.create(model=\"gpt-4o-mini\", messages=messages)\n",
    "    reply =response.choices[0].message.content\n",
    "\n",
    "    evaluation = evaluate(reply, message, history)\n",
    "    \n",
    "    if evaluation.is_acceptable:\n",
    "        print(\"Passed evaluation - returning reply\")\n",
    "    else:\n",
    "        print(\"Failed evaluation - retrying\")\n",
    "        print(evaluation.feedback)\n",
    "        reply = rerun(reply, message, history, evaluation.feedback)       \n",
    "    return reply"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "* Running on local URL:  http://127.0.0.1:7862\n",
      "* To create a public link, set `share=True` in `launch()`.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div><iframe src=\"http://127.0.0.1:7862/\" width=\"100%\" height=\"500\" allow=\"autoplay; camera; microphone; clipboard-read; clipboard-write;\" frameborder=\"0\" allowfullscreen></iframe></div>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": []
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Passed evaluation - returning reply\n",
      "Failed evaluation - retrying\n",
      "The response is not acceptable. The agent answered in Pig Latin, which is unprofessional and not helpful to the user. The agent is supposed to be acting professionally and answering questions about their experience.\n"
     ]
    }
   ],
   "source": [
    "gr.ChatInterface(chat, type=\"messages\").launch()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}