Raymond Krehn

Project Manager

Blog Posts

Microsoft Office 2016 and Activation

I recently purchased a dozen desktops for the office and was tasked with setting them up and installing Microsoft Office 2016. I purchased the Dell Precision towers with Microsoft Office Home and Business 2016 pre-installed on each one. One thing that I did not account for was that Microsoft changed their activation method and now tie each product license to an e-mail address. No problem, right? Except that the activation did not work on each computer. Then another problem occurred: After four installations, there were four different licenses attached to one e-mail account and it was difficult to tell which installation key was tied to which computer. The obvious solution is to use Office 365 and then all of these problems will go away. However, my CEO refuses to buy it. Here’s how I resolved the issue:


Creating SSL Certification

This guide will walk through setting up an SSL certification and installing it on your server. I used these steps in the past for Jira and Confluence, but there are many uses for this. SSL (Secure Sockets Layer) is the standard security technology for establishing an encrypted link between a web server and a browser. According to Digicert, “SSL allows sensitive information such as credit card numbers, social security numbers, and login credentials to be transmitted securely. Normally, data sent between browsers and web servers is sent in plain text—leaving you vulnerable to eavesdropping. If an attacker is able to intercept all data being sent between a browser and a web server they can see and use that information.”


How to: Land a Job

I’ve been interviewing for a position at my company for a few weeks now and I can’t help but notice how frequently some (what I would assume) basic concepts of getting a job are completely ignored. I was recently browsing social media when I came across someone complaining about the difficulty of finding a job. Their gripe with the process was someone telling them to try harder. The person argued, “How do I try harder? Do I type my resume harder? Do I hit submit harder? etc.” It made me chuckle. This sparked a response where I decided to write a quick guide on landing a job. Let’s start with the resume:


Peer-to-peer Lending Evolved

My article relating to Peer-to-Peer Lending is one of my most popular articles with over 6,000 visits. I think that’s a rather huge accomplishment for a personal website with no desire to publically broadcast. One of the items I talk about later in the article is how to reduce risk while increasing rewards. Using backtracked data that spans billions of dollars, I decided to test out a few algorithms that could potentially maximize my return interest.

After testing these algorithms for over a year, I was astonished at the results. I’ll share these in a moment. I thought to myself, “what if I can share this with the world?” It was a unique challenge for me. I knew that Lending Club offered API, as I discussed in the aforementioned article. What I wanted to know was whether or not it was possible to interact with other people’s accounts and share the same algorithm using that same API. It was. While challenging at times, I believe my efforts were worth it.

Today, I introduce to you Flux You can see the results at the bottom of the page or in the performance section.

Reading Lines in C#

I came across an interesting scenario today while I was building an application that required me opening a file, reading it line by line, and importing it into a dataset. The reason this was an interesting scenario is because there is data that belongs to a specific identifier on different lines.


SQL Basic Maintenance Script

I came across a database that has suffered a lot of deadlocks recently. This, along with slow query execution among other problems led me to convince management that the database required downtime. Some of the maintenance I performed was re-building tempdb tables and moving them off the C Drive, which I highly recommend for various reasons. You can read more on that here.


Cutting Television

I’ve had a television service ever since I was a little kid. I remember when I had an antenna on top of my box that we called “bunny ears.” Yes, the television was a large box with ears. We had to adjust the antenna once in a while to get clear reception, or the channels would get some fuzz or be gone completely with white noise. The problem was that some of the channels would be clear and others would not. If I wanted to see another channel, I would go up to the television and change the channel by a knob. I may have had to adjust the antenna again to get a picture. We knew something was on a channel at a certain time through TV Guide. It’s still around today, but it’s all digital. It was similar to a magazine, and it had ads throughout so you knew what the latest and greatest shows were.



Note: Recommendations are at the bottom if you want to skip this article.

I came across an easily one-sided article that states in the opening statement, “The use of ad-blocking software is exploding and is projected to cost websites nearly $22 billion in lost advertising revenue worldwide this year, according to a new study.” Without going into semantics about the definition of cost, what this article should really state is that ad-blocking software projects to reduce potential revenue by $22 billion worldwide this year. The key difference here is the costs haven’t incurred yet and it’s only potential income.


My SSD is near capacity. What can I do?

I see this question a lot and it actually bothered me that my 120 GB Solid State Drive (SSD) was near full capacity despite the fact I install almost everything on a secondary drive. I try to keep only my Windows installation on the SSD for incredibly fast boot times. If you’re unfamiliar with the SSD, here’s a simple comparison with the same computer by ASUS:


Password Manager LastPass Security Breach

 “LastPass, a company that offers users a way to centrally manage all of their passwords online with a single master password, disclosed Monday that intruders had broken into its databases and made off with user email addresses and password reminders, among other data.”

But, you probably shouldn’t worry too much. LastPass utilizes AES 256-bit encryption on your device with the lastest PBKDF2 algorithms. I’ll go more in-depth of these shortly, but what you really need to know is that since the data is encrypted on your device, by the time it arrives on the LastPass servers in what they call a vault, they don’t even know what your passwords are. They’ll need to know your salt encryption key to even begin exposing your password. Before this, however, anyone looking at your passwords will need to know your master password, which is also encrypted. If you have two-way authentication, you’ll have to approve their access to your vault. 


Copyright © 2017 All right reserved

My Resume

Qualifications Summary

Detail-oriented and dedicated professional with extensive experience in gathering and evaluating business data to support IT systems and organizational operations. Known for keen eye for detail and analytical problem-solving aptitude in formulating innovative solutions and resolving complex situations. Adept at managing group dynamics, as well as in motivating and working with high-caliber teams of professionals. Equipped with articulate communication and interpersonal skills in building positive work relationships with professionals of all levels.


Project Manager

Gaia Software (2016 - Present)

Managed project activities for multiple projects across all project phases, including initiation, planning, user experience, design, development, QA, launch, and ongoing maintenance.

Software Engineer

American Pathology Partners (2003 - 2004)

Collaborate with organization-wide stakeholders in the research, planning, and execution of process improvement initiatives, application development, and process automations.

Key Highlights:

  • Improved a third-party billing system utilizing WSDL technologies.
  • Developed a software that generated plate setup, consolidated results from PCR 7500 machines, and verified tests for Group A Streptococcus
  • Achieved $30K in annual savings by creating and implementing a billing system in Mirth and Java to parse and send the transformed data
  • Received the Gary Rankin Award in recognition for outstanding support to molecular services

Senior Client Services Reconciliation and Controls Analyst

TIAA-CREF (2007 - 2014)

Led a team in researching, evaluating, and identifying root cause and solutions to several issues, such as system and participant transaction errors. Directly supervised operations, which involved determining control gaps in new processes and providing guidance on corrective transactions. Participated in all phases of transaction processing using extensive knowledge of TIAA-CREF organizational structure, procedures, policies, and business functions.

Key Highlights:

  • Late posting capturing: created a system to track backdated transactions and assigned tasks to associates to identify root cause of transaction backdate
  • Quality improvement: reorganized existing systems to enable call centers to efficiently manage changes without additional call time, thus improving processing speed to three days while increasing quality by 66%
  • Productivity monitoring: collaborated with IT, operations managers, and processors in developing a database and system to track productivity based on designated timings from Standard Work
  • Workflow management: spearheaded process workflow improvement project which mitigated transaction lead time by 5,000 man-hours annually and improved productivity by 28%
  • Conducted training and supervised teams in addressing process issues in accordance with Lean concepts

Other positions held: Associate Business Consultant (2009-2013), Service Representative (2007-2009).

Customer Experience Advisor Back Office Tier 2-Team Lead

Corporate Express (2006 - 2007)

Customer Service Representative

MoneyGram, Intl. (2005 - 2006)

Shift Manager

McDonalds (2002 - 2005)

Bachelor of Science in Management

University of Phoenix (2012 - 2014)

The Bachelor of Science in Management (BSM) degree program is designed to develop the professional knowledge and skills of cross functional managers in an organization. The BSM degree enhances skills necessary for improved organizational effectiveness in a dynamic and evolving workplace. The program focuses on the development of management roles and emphasizes skills necessary to align resources, and to improve communication, productivity, and effectiveness.

GPA: 3.7 | Delta Mu Delta Honors

Associates of Arts in the Foundations of Business

Axia College (2010 - 2012)

The Associate of Arts with a concentration in Business Foundations focuses on a variety of business essentials including management theory and practice, information systems, financial accounting, critical thinking and effective managerial communications.


Lean Six Sigma

Deloitte (2013)

Lean Six Sigma is a methodology that relies on a collaborative team effort to improve performance by systematically removing waste, combining lean manufacturing/lean enterprise and Six Sigma to eliminate the eight kinds of waste: Transportation, Inventory, Motion, Waiting, Over production, Over processing, Defects, and Skills.

Managament Academy

TIAA-CREF (2012)

Enhance the value and productivity of key business managers through personal development, collaborative learning, tools and techniques, networking and mentoring, transforming participants into stronger leaders for their organizations and the community!


Project Management Institute

The Project Management Institute (PMI) is a US nonprofit professional organization for project management.


Toastmasters International is a world leader in communication and leadership development.


Visual Studio | .NET | C# | Java | HTML | PHP | CSS | SQL | REST API | SQL Server | MySQL | JavaScript | JQuery | Microsoft Office Applications (Excel, Outlook, Visio, Access, and PowerPoint)| VBA | SharePoint | SharePoint Designer | Reconciliation | ReconNet | JIRA | Confluence | Cortex | LigoLab | OmniPlus | OmniStation | Mirth | Corepoint

Copyright © 2017 All right reserved

My Portfolio

  • All
  • Web Design
  • Applications
  • Games
  • Music

Flux Robot

Automated Investing for Lending Club

Grand Harbor

A site for the community of Grand Harbor, TX

Word Document Bookmark Scanner

This software was built to scan bookmarks within word documents. It was originally built to scan a whole directory of medical documents to gather specific patient information and their test results.

Deep File Scanner

This software will help you find a string of text amongst a group of files.

Dev Studio Tycoon

Dev Studio Tycoon is simulation game where you focus on running a game development studio, rather than an entire empire. Begin as an indie developer and take charge of your studio keeping it as an independent studio, or making it a AAA studio!.


SimHockey is a hockey team simulation where you run your own team and can do a single game for fun or run a full franchise.


SysCracker is a password stealing (hacking/phishing) simulation (or a hacker-style game).

Tutelary: The Adventures of Freyr

A take on an old-school RPG adventure following Freyr and his sister Rán as they fight to return a stolen crystal to their home.

SuperSimpleNews 2.0

A PHP-based news script which doesn't require a database as all news articles are stored in simple CSV files. Originally created by Matt Lester and now it's been updated and improved by Raymond Krehn. This script includes a password protected administrative backend for adding, editing and deleting articles. For editing the text the brilliant widgEditor is utilised for it's lightweight simplicity and effectiveness.

Lord Krehn - e(volve)

Lord Krehn - Parallels

Copyright © 2017 All right reserved

Dream Posts

The Traveler

I didn’t feel there was a reason for such violence. At first, I couldn’t understand why. Then I started to ask various questions: Is it because I have money? Is it because I’m different? Did I hurt them somehow? The more questions I asked, though, the fewer answers I had. None of these questions would have been asked if I weren’t brutally hit several times. This is exactly what happened on my way to Chicago. The worst of it is that I don’t know who did it.



I Shouldn’t be Alive

I shouldn’t be alive. Everyone was running past me towards a large mansion with Roman pillars that held the large deck on the second floor. The paleness of the structure seemed hidden by the reflections of fires on the streets. I stared at the abandoned cars on the once busy highway; all burning making identifying their brands a difficulty. I took a look at the rifle in my hand and swiftly joined the swarm of soldiers running towards the building. It wasn’t easy, though. I crouched down and leapt from one car to another hoping they would protect me from the onslaught of bullets. Others were less fortunate. While leaping I found myself stepping over bodies attempting to avoid tripping over them. I felt and heard one bullet gaze past my ear. I turned my head to find the guy behind me fall down. He was one of us and appeared dead so I kept moving forward.



The Lost Exit

I had just finished getting off of work. After clocking out on my computer, I headed towards the elevator through two glass doors. I push the bottom of the two silver buttons between the elevator doors to call the elevator. Moments later I hear a “ding” sound and walk in to push the ground button so I can finally head home. Before the doors closed a lady with sun-colored hair and pale-white skin walked in. A nod sufficed the acknowledgement of each other’s existence within this confined moving room.



We’re in this dream…

What I saw was two different worlds at the same time. It all started at a theme park with a girl. She was about 5’5” and tanned. She was gorgeous with light brown hair, almost the color of sand. The hair would’ve stopped just above her shoulders had it not been in a short pony tail.




I found myself waking in what appeared to be a space station. It would make logical sense, to say the least. Plenty of white technological pieces surrounded me as I sat up from my rather tiny bed. The bed was comfortable despite its size. I couldn’t help but think it reminded me of those TempurPedic commercials. After all, they were NASA technology. Getting out of the cramped space where I lay was not the most feasible feat I’ve done, but I got out of it slowly and headed down the corridor grabbing on to the sides to pull myself as gravity was limited. As I got closer to the cockpit, I took a peak outside the windows. There sat Europa, one of the most beautiful sights I have ever seen.

We enclosed upon the georgeous moon like we were landing on our own moon orbiting Earth. Earth was no where in sight though. A soft landing later and we were touching the surface. There was myself and another man, mid-30s with dark short hair and an average build. He was the commander of the flight and my job was to gather samples from the surface of Europa. We put on our suits and headed towards the bottom of the ship. He was the first one down the ladder, being the first man to step on this distant planet. It wasn’t soft, like our own moon, it was hard as ice. The surface was glossy and a whitish-blue color. It’s never been touched before and there’s no tracks to prove it. The commander carried the American flag across the surface as he glided like he was ice skating. I followed pursuit. We didn’t know exactly how we’d walk on the surface, or whether it could even support us. When we moved, it was more like jump-ice-skating than anything else. I found it easiest to do an ice-skating motion. Not more than 20 feet further and we both slammed the flagpole into the ground as if claiming the moon belongs to us,America.

We gazed upon the distance and we see the sun far away. Almost like the brightest star in the night sky on Earth, just a little bigger. It was the first thing I wanted to look for, but of course there was one thing that stood out the most in my vision. The largest planet in our solar system stared right at me not too much further from the right of the sun; Jupiter. They eye of Jupiter was the most captivating sight I’ve ever seen. I was in heaven; a cold, frozen and distant world staring at the eye of Jupiter. I fell on to my knees at the sight of such beauty. For once, I felt like I was somewhere where I belong. It was a frozen landscape before me, with red-colored canals and Jupiter invading most of the sky with a distant bright star to the left of it. Unfortunately, we were not in the situation to live here yet. Someday though, we will…


Castle Rock Fields

Another beautiful day in the valley, and I was sitting out in the back porch of my house. Skies were blue as far as the horizon, with a few occasional clouds. Not much of a backyard beyond the porch. All the houses in the neighborhood were almost exactly the same. They were very dull, but a cost efficient way to build homes I suppose. An awning provided shade over me so my pale-white skin wouldn’t burn. I was staring at the awning and noticed a few sparse holes. Then my girlfriend opened the glass sliding-door behind me and asked “What’re you lookin’ at?”

She sat down in a zero-gravity chair like mine next to me and took a sip of her glass. “Looks like I got to patch more holes in this damn awning again”, I replied calmly. She looked at me and smiled. I loved her beautiful Asian-face. Her tanned-skin drove me erotically crazy. It was the perfect color and the perfect texture. She reached out to me and I held her hand, then we stared off in to the horizon together without words.



Dual Attack at Dawn

Dawn arose in the background, as we leaned over the castle walls to view if the attacking armies had arrived or not. It was pretty quiet; there was only the sound of fellow soldiers breathing and the early birds singing. Unfortunately for us though, the ground was covered in a dark haze. If there was someone there, we wouldn’t have been able to see them. There were still some darkened clouds in the sky from the previous night of hell. Our defensive ballistic missiles and trebuchets gave the surrounding area a night of burning flames. A nearby forest was still partially lit. I can still hear the screams from that previous night, of men screaming in pain from being burned alive. As disturbing as it was, it still brought somewhat of a smile to our faces knowing that the more screams, the less there were to attack us.



Arms of Protection

I started to walk in the living room, as I usually do when I wake up, and headed towards the kitchen. I stopped in the hallway just before the living room starts and my older roommate, about 10 years older than I am, was sitting on the uncomfortable blue-covered, metal barred futon on to the right in his police officer uniform. “You look hott today!” I said jokingly. I received a slight giggle from him and continued in to the kitchen on my left side, which was just on the other side of the wall in the hallway I was currently in.

The interesting thing is, is that I haven’t seen this roommate in nearly 3 years, and we were back at my old apartment inLakewoodwhere he used to live with me. I had just started college and he recently just divorced his wife. He was a far cry from becoming a police officer, he held no degree, never finished high school, and was a manager at McDonald’s with 3 divorces. I remember when we first moved in together he was having a rough time. When his wife left him, with no given explanation, at least to me, he couldn’t afford a home by himself and I couldn’t afford an apartment by myself, so we signed a lease and moved in together along with his son.

After I ate some breakfast I went back in the living room and saw my girlfriend sitting on the couch, next to the futon, and my roommate already left for work. I sat along the side with her and we decided to watch TV. She explained to me how he thought our relationship was illegal and she suspected that he would be coming back to arrest us. She also told me how he found out about the illegal programs I downloaded. I didn’t think much about it at the time, or what was going through my head, but I changed the lock on the main door so he couldn’t come in to arrest us.

Moments later I heard a “Bang! Bang Bang Bang!”, he was pounding on my door begging to get in. “Ray! It’s the police, let us in!” he yelled. I knew it had to by my roommate, because I don’t think any other police officer knows my shorter name. I started looking for things to block the door, but then I noticed that the door was partially opened on the top-left side, and I knew they were going to come in at a moments notice. My girlfriend took my hand and hid us behind the couch. She said “If they come in, they can look around, and when they get passed this couch we’ll run for the door.” It was a great plan at the time and I couldn’t think of any other way to handle the situation.

The door finally busted open and we waited patiently for them to walk past the couch. They started coming, but they were coming towards the end of the couch that was facing the entrance. We abandoned our plan and ran the other way and broke through a window and made a run for it. Of course they notice us in the process and one of the officers claimed “There they are!”. Once we got passed the window we ran for the hills on this winters day, and it was snowing gently with a thick fog. We reached the mountains summit and we took a break to look behind us. The officers were no where in sight, but we decided to continue to move forward going at a walking pace. With her hand in mine we journeyed through the thick woods and heard a large machine moving away from us. As we approached where the sound was coming we noticed that it was a tank heading away from us. It stopped suddenly but we kept walking towards it to see what it was doing. As we got even closer, we noticed that the tank was waiting for a gate to open in a large electric-fenced area. We got closely behind the tank and followed it inside the fenced area, and the gates closed behind us.

Looking around the tank infrequently, still behind it, it appeared as if we were in a military base. The tank took a right turn where it appeared to be heading towards a rather large garage-like building. With my girlfriend’s hand still in mine, we took a left and headed towards the barracks. Near the entrance of the barracks, there were rows of barbed wire that were about a foot off the ground, like one of those military training courses from television that reached as far left as we could see to as far right as we could see. We got on our stomachs and inched towards where the entrance was. When we finally neared the end, two soldiers were casually standing in front of the enterence looking at us generously. They offered us to come inside, and we took the offer and headed inside with them.

A cooked meal approached some tables as they led us towards it. They questioned us on why we were there and how we found them. We told them everything, and they explained to us that it was a secret military base hidden in the thick forrests. After a great meal they began to show us where we would be allowed to sleep. We waited outside what seemed like a room where there were cloudy translucent curtains leading inside. I could tell the curtains themselves were somewhat transparent, but seeing beyond them was difficult to see anything. As we waited, my girlfriend told me that her bra was hurting her, so I told her just to take it off to get comfortable and I would hold on to the bra. She took it off while keeping her shirt on, only exposing her left breast briefly by mistake. We walked in to the room where there was a collection of beds and went to sleep in our separate beds.


The Ride of No Return

There’s a ride that is completely black, and I’ve seen it, I have been on it. Black is the absence of light, the absence of color, or is it all the colors combined? Black also represents dark, lost, empty, gloomy, sinister, mystery, depression, or misplaced. The ride is in the shape of a spider. Many people have arachnophobia. To me, the ride also represents fear, terror, dread, horror, and panic. So the black spider ride was dark fear, lost horror, sinister terror, or empty depression. This is what it represented itself as at least. However, could these emotions have exact opposites? Of course, but did you think that these emotions can also cause the opposite feelings? I think so. If this is all confusing, read on and you will see what I am talking about.



Copyright © 2017 All right reserved


Contact Form

What is 6 + 5?

Copyright © 2017 All right reserved