Portfolio: Here's the pudding; Digging Deeper; and OCD.

You want to know if I can produce clear, high quality communication, and want to see the range of that work.

The proof is in the pudding. I'm sure you'll find the pudding and your answer below.

Beyond a strong command of language and logic found in the puddings below, a drive to dig deeper has served me and the people I work for quite well.

I have always been driven to find out what is really going on.

I'm driven to find out what is really needed.

I'm driven to find out how it must be presented to deliver it so people can really understand it.

The first item below is a 250 page user manual for a complex system.

We had to build this system first, so the digging was more extensive than usual.

I dug into old software code. I had to find out what some long-gone programmer thought should happen.

I dug into ten years of database records. I had to find out what mistakes that programmer had made.

I dug into departmental practices to find out what was really happening.

I dug into departmental policies to find out what managers hoped was happening.

I dug into people's opinions to find out what the staff thought was happening.

I dug deeper still to find out what everyone thought should be happening.

I dug down to the bottom to find out what ought to happen in this new system.

With that done, we built software to extend the old data and support new practices and requirements.

Finally, it was time to tell people how to get things done in a new way.

And I found myself digging a bit more to figure out the best ways to explain why the new way was better.

You know, we generally view people with OCD sympathetically at best.

We don't want to have OCD. We don't even want anyone nearby to have it.

The "D" of OCD stands for Disorder, after all.

Koreans call people with OCD 피곤한 사람 [PiGohnHahn SaRahm], which translates directly as Tired Person.

That direct translation is incorrect because they mean "that person who makes me tired". So the natural translation would be Tiresome Person. I agree with you: that's not very charitable but it is candid.

To be honest, doesn't it seem amusing, and intriguingly useful, when a TV-show detective has OCD?

And sometimes it's useful when a co-worker has it, especially if they're building software for you or getting your material ready to publish.

It's reassuring to know someone is obsessing over all the details, isn't it?

The point is, I confess to being a bit OCD, but I hope you like that.

And I prefer that you think of me as an Obsessive Compulsive Digger.

Furthermore, if you are Korean, please think of me as a Tireless Person, not a tiresome one.

I've also included one academic paper to show my grasp of academic rhetoric and grammar blended with technical expertise. This piece, "Contrastive Analysis" also demonstrates my skill at translating Korean into English.

** To see the historical record of my well-practiced adaptability gained by working in many industries, cultures, and roles, you can jump to the Resumes page.

Finally, you might like to know that this page is 100% handcrafted HTML in Google Sites style, the kind that has tiresome inline CSS, requiring exquisite attention to detail.

as Writer...

User Manual SWP.NET

This 250-page manual covers every aspect of a system built in Visual Basic.NET with a SQL Server database. The name is SWP.NET, Sheriffs Works Program. One critical customer expectation was that new users should come up to speed quickly and be self-training directly on the system. This PDF version keeps some of the interactive qualities of the online version. The online version responded with pertinent help from every screen in the application. The help offers the "where, when, and why" as well as "how to" of each task, and thoroughly covers how to use each facility.

Project Proposal

This award winning proposal won the bid for SWP.NET, rebuilding the aging InterBase and Delphi Alternative Sentencing program called proSWP in 2006. Our chief concern was to demonstrate our fledgling company's strength in understanding their old environment and the targets of the users' expectations. The SWP.NET system schedules and tracks attendance, billing, and payments for people fulfilling community service sentences.

Contrastive Analysis (academic)

I think I should have at least one academic paper on display. I enjoyed writing this rhetorical analysis of a Korean pastor's sermon. I did all of the translation from Korean to English, and believe it honors Rev. SamHwan Kim's intent. For the analysis, I applied my native tech tools to follow the methods proposed by Korean Linguist KyeongJa Kim to locate the emergent thesis and count categorized t-units. Beyond that analysis, I stretched her method to fit thesis interpretations with sociohistorical views of culture.

as Analyst/Programmer...

A bit of UML

Our original project charter was to migrate a system written in Borland Delphi against an InterBase database. Several exigencies drove the project: the database version was no longer supported; the data was untidy; several new features and many reports were critically needed to meet growing responsibilities; no one on staff could handle development in Delphi. The charter grew a bit as we brought real procedures together with the de-engineered Delphi and data. I was using a Korean diagramming application in beta called Aurora. The first cut was drawn after slicing through the Delphi source files with grep and regex to generate lists of functions, data fields, cross-function calls, and database access queries. Working from this diagram of the functionality in the old code, I fitted user stories into the diagrams to ensure that we would lose none of the functions "hidden in the box" while fitting in new functionality to meet more modern expectations.

A bit more UML

The beta UML diagrammer called Aurora burped occasionally, dropping some nodes in its XML database, but we learned how to patch them, and it worked well for keeping us honest and the structure tight. It could not generate VB, so we coded from the pictures. Aurora also did not do State diagrams. And it was critical to nail down the states of a Sheriffs Work Program Participant, particularly because we wanted to capture policy rules as data tables and drive automatic state changes in code. I diagrammed several versions in PowerPoint.

as Teacher...

Vocab Stories

Learning vocabulary from lists is madness or sure to produce it. Brains hate that kind of stuff, but do love stories. So I wrote stories using the vocabulary for a unit, recorded it, and posted it all on the website.

PowerPoint Deck for one week's session

NonHyeon High School had me teaching 10 classes of 10th graders and 10 classes of 11th graders. The range of ability (from two cuss words to quite good) and range of interest (negative to enthusiastic) were huge. For the sophomores I built each 50 minute session to be keeping pace with the textbook, with some focused practice and review, but packaged with short diversions of cartoons, animations, video clips, games, songs, and grammar micro-sessions sections. My favorite feature was a link on the master page to return to a "jump" page that served as a table of contents; it let me switch gears and jump to any activity depending on how the class was going. Sadly, you won't be able to hear the music or watch the swfs.

Jeopardy Game in PowerPoint

The huge gap between those with the most English and those with the least English (none) stymied attempts to keep everyone engaged in games. This Jeopardy game usually kept 90 percent of them engaged because it offered a quick pace and some chance reversals to depose the king of the hill. I usually loaded it with material from three weeks past. The main attraction for teachers is that it takes care of all the scoring for any number of teams from two to seven. Everyone is welcome to download it. It uses VBA extensively, and unfortunately requires a licensed copy of PowerPoint 2007 to run it because of the features that it needs. Here I present a series of screen shots, and an opportunity to download it.

as entrepreneur, website builder, speaker...

PowerPoint selling HyCube

This is, shall we say, dated. From 2001 to 2004 we were marketing and building the HyCube database with unique data warehousing and analysis capabilities through the Hyper Query Language (HQL). The heart of the HyCube database was APL, terse to the extreme, able to manipulate vast matrices very quickly. Because it lent itself to working with interim result sets, we could offer a variant of SQL that facilitated sophisticated data analysis in very simple steps. This presentation touts the exploration of data through HQL, explains unique technical features, and invites investment and partnership.

Website HyCube

Also a bit dated. I wrote all of the copy and slogans for this website presenting the HyCube database to investors and purchasers in 2001 - 2004. I'm glad that the website has had such longevity.

Website Epiktools

In 2009, while teaching English at NonHyeon High School in InCheon. South Korea, I leveraged as many technical tools as I possibly could. The English Program In Korea (EPIK) sponsors about 2,500 TESOL instructors to public schools throughout Korea. For these teachers, I presented ideas and how-to-do-it's on this Epiktools website. For some 360 TESOL teachers newly arrived in Korea, I demonstrated and explained many of the tools and techniques at JeonJu University one August.

Business Investment Overview

From 2001 through 2004, I presented a never-ending stream of proposals to potential investors, partners, and customers. Each proposal was tailored and packaged in documents and binders, demonstration suites on CD, brochures, and PowerPoint presentations of HyCube's prowess, growth potential, and potential application to a wide variety of needs and industries. This is the business overview used in 2001-2002.

Website Korean Supermoms

Every Wednesday evening in 2009-2010, YES, the YeonSu English Stars, met in the YeonSu District Hall (a borough of InCheon) to practice English via loosely directed group conversation. One of the YeonSu YES Volunteers, Sylvia, champions a style of language learning for young children that is centered on Storybook readings. I made this website for her.

Website Global Echo at NonHyun High

For the students and teachers at NonHyun High School in InCheon I created a website to communicate schedules, offer reviews of lessons, suggest other language learning tools, give listening practice with MP3 files of stories and vocabulary.

90 minute tech-tools talk for EPIK teachers

The InCheon EPIK (English Program In Korea) office liked the epiktools lecture for new EPIK teachers at JeonJu University. They asked me and my co-teacher Michael Bahk to give new EPIKers a lecture about co-teaching in Korea. Michael (real name YoungSeoh) and I are a great team and of one mind, edutainment is the way to go. After 90 minutes, the new EPIK teachers voted to delay lunch another half hour. On the epiktools website, this is the PowerPoint deck we used.

InCheon Vocabulary

The Education Office of InCheon published a vocabulary of 1500 words, some common, some less. Convinced that the best and easiest way to study them to is to read the sentences while listening to a native speaker read them out loud, I used grep, regex, and sql to rip the textbook into a database of words, definitions, and examples. Then I recorded 1500 words and examples and posted the MP3's online.

Website for Students and Teachers

As the sole native-speaker English teacher in NonHyun High School, I needed a way to keep all of my co-teachers advised about what I was doing in each class, and how they could play an active role beyond keeping the peace. I taught 20 to 22 classes each week with eight different co-teachers. I also wanted to offer students a ready resource for review [preview? really?], and give them extended opportunities for practice. This website resulted. Included are pages with recorded stories for repeated listening, and pages showing the relative effort put forth by students and classes.

Brochure

I did not do any graphic design for this brochure. I did write the copy and I did offer sketches for explaining the arcane nature of the unique features that made the Database Engine so fantastic for ad hoc analysis of big data. I must also accept the blame for coining the names for these features, like "bifold bit-mapping". Believe it or not, that moniker accurately depicts the nature of one devishly clever feature, such that some programmers immediately got it.

User Stories

To keep track of everything I used an Excel workbook as a Project Encyclopedia. It was very convenient to select a bunch of sheets, print, and head for the weekly meeting. Here I have selected Glossary, Issues, Standards, Exhibits, CRC cards, and User Stories.

Status Reports

Several departments were watching the progress of building a new application for the Sheriffs Office Alternate Sentencing program. Keeping everyone informed was one objective in these reports. Across departments, and even within departments, there were differences of opinion about how the system should work. These status reports were designed to spotlight the different viewpoints and the final decisions. I used Word's hidden text feature to hide all but the most recent activity.