RaptorSync (pronounced Raptors Inc) is a fictitious company created for the purposes of a term project for my Project Management class.

We were tasked to form a Request For Proposal (RFP) Response for a hospital file tracking system.  The project insinuated a preference to adopt Radio-Frequency Identification (RFID) and to establish the foundation for implementing a completely digital file system.

Through the term our company–RaptorSync–grew a personality–complete with history of success in bar-coding, a logo, an executive board, and other weird facts.  To cap it off, I created this imitation Wikipedia page for the company: http://en.wikipedia.org/wiki/raptorsync. In under an hour I created this “external” resource that really set the tone introducing our company and presentation.  This was quicker than building a real website and equally effective.

I just wanted to share a cover letter that I wrote for my application to be a part of the Fox School of Business College Council of Presidents.  This is by far one of the best cover letters I have ever written; it’s passionate and powerful.  One of my colleagues recently found it laying around in our office and  I am finding it to be healthy reminder of why I am doing all of this extra work.

Theresa Jenkins and Kevin Bradley,

Thank you for your consideration thus far, I am interested in applying for President of College Council’s Executive Committee.

I am the current Secretary of AMIS’ Executive Board. Throughout my time with this organization I have been to a number of networking events, professional development events, workshops, and guest speakers. The organization has been critical to my development within the business school and I have developed a strong interest in seeing that my peers have access to similar opportunities.

Coming from the background of being an Executive Member of an SPO, my goal is to make sure that all the SPOs have the resources they need to continue to add value to their members and to the university. SPOs provide complimentary experiences that a university curriculum simply cannot match; for this reason, they are each an extraordinary entity and I want to see them all succeed.

Since the beginning of my “Temple Experience”, I have made a point to become actively involved in the organizations that support my local community. Some of these roles include: Treasurer for Temple Towers’ (Resident Hall) Executive Board, Resident Assistant (RA) of Elmira Jeffries (Resident Hall), Adviser for Elmira Jeffries’ Senate Executive Board, and Co-Founder & Minister of Scrimmages for Temple’s Ultimate Frisbee Team. In these roles I have worked with TSG, Student Affairs, Campus Recreation, and several other functional groups. This experience of having seen so many dimensions of Temple University has been important in helping me understand how to run an organization effectively. I want to do well and I think the experiences and knowledge that I have picked up from these roles will continue to be valuable.

Again, I appreciate the opportunity; I look forward to meeting with both of you.

Sincerely,

Manu Phatak

Over a year ago I launched this site and it was an amazing accomplishment for me. To the average visitor, this site is nothing more than another wordpress blog; to me, on the other hand, it was (is) the pinnacle of my learning success in regards to understanding PHP, WordPress’ API, and web development. I created my own custom theme/widgets and–as flawed as it may be–I was (am) very proud of my work. The site immediately started generating a great deal of interest amongst my peers and the online community; to this day, I find this exciting enough for me to want to keep the site a priority in my busy schedule.

Unfortunately as my coursework began to pick up, these fun, extra-curricular projects were unjustly competing for my attention and had to go. But, without further ado, I am returning to my blog after almost an entire year away. I return with hopes that I can manage this site with minimal effort; being powered by wordpress, I believe this to be possible.

Having just come back I do have a bit of a to-do list to take care of:

• First and foremost, I want to get this blog caught up with my last year of activities. This includes a project I am re-hatching–the project management plugin for wordpress. This is my MIS capstone project, so I can assure the world it will be done.
• I would like to see this site slightly more organized to enhance user navigation. This means changing blog categories and such.
• I want the photo blog moved to a sub-domain. I love the pics, but I feel they distract the blog from its purpose-a professional reference. I don’t know how to do this without installing another instance of wordpress. But, as always, I will be sure to share my solution.
• And finally, I am seriously considering adding in some video blogs. I feel this would be a good way to add personality to my site and show a little more of myself. If nothing else it could be fun-we shall see.

To wrap this up, I appreciate the feedback I have gotten over the past year–even though I have been hiding from the world. I look forward to bringing this site back to life and hopefully it can be exciting as what it was once before.

Nobody needs asset management like Sabre Systems, Inc–a hot-shot, technology enabling consulting firm. Sabre Systems is fueled by the  magic of technology in that they have found a market in collaborating with their clients to inject technology to solve business problems and to build and maintain competitive advantages.

Due to the nature of their business, the firm has “assets”–computers, servers, notebooks, etc–scattered across the country which has become a nuisance to manage.  In an effort to phase out the glorified spreadsheet that logs these assets, they’ve asked a group of four rock stars from Temple–including myself–to build a web-based tool to manage each assets’ information.

About the Tool

The information the tool manages include the following:

• locations,
• status,
• contact, and
• purchase information–

and specifically how each item relates to an asset.

Management is a word our group has been using to describe CRUD operations–Creating, Reading, Updating, and Deleting.  To put it in perspective, some of these functions would include listing assets of a category, assigning an asset to a contact. archiving, and creating an asset, etc.

About the project

All the information about an asset will be stored on a database and a web application will be built to interact with that database.

Each asset will have basic information–an ID, category, description, owner, and status–as well as some additional information including purchase info, pictures, warranty info, and file attachments, etc.  The application will also handle admin levels–restrictions to certain functions–and event logging.

The value of this project is that our group is working through the System Development Life Cycle (SDLC)–analysis, design, development (our current state), implementation, and minor to minimal maintenance–to develop a system.

Pushing the scope of class

This is what this project is all about.

From the very beginning we have found ourselves doing more than just building another web-application–like the ones for class..  Part of our planning phase included creating a development environment that mimics Sabre Systems’ production environment–which they happen to be a Microsoft shop.  To support all the functionality–including category assignments and change logs–our database has become exponentially more complex than any other database any of us have worked with before.

Here’s some more things that I’ve learned about and implemented in practical situation:

Database Recursion

This almost made my head explode, but I understand it now.

For the non-database people, recursion is used to create a “tree” of information; for example, consider categories with subcategories where a subcategory has all the same attributes as its’ parent category–possibly including another subcategory.  This is probably more confusing, so we’ll save this concept for another day.

We are using recursion to manage the categories that an asset can be assigned to–ie Desktop PC > Dell > Optiplex > 745 > Asset # 234.

Microsoft SQL and Microsoft Management Console (MMC)

In class, we learn Oracle at the command line.  For non-database people,  MS SQL, Oracle, and mySQL are all different flavors of databases–they are fundamentally the same with slightly different keywords and syntax.

MMC is a graphical user interface (GUI) that Microsoft created to interact with SQL (Access on steroids)–you can drag and drop different boxes to create relationships and even to create queries.  Think of MS-DOS (the command line) compared to Windows Vista (the GUI); it’s kind of a pain at first, but ultimately it can help.

Nested Queries

A nested querydoes 2 things: (1) it runs a query to find a variable and then (2) runs another query using that variable.

We are using nested queries to update our bridge tables that are logging changes.  We run a SELECT query to find the id of the record that needs updated and then an UPDATE query to update that record.

This is covered in class-briefly; but it’s nice to use this in a practical situation.

Left, Right, and Outer Joins

In class, we are taught implicate inner joins.

When values are called using inner joins, only values that are joined will be returned. Let’s say we wanted to call all assets and their status.  If we used an inner join, only assets that have a status assigned to it will be returned.  Now every asset should have a status–so it should not be an issue.  But, let’s pretend something went wrong and an asset lost its status assignment.  Using a Left or Right join you can populate all the assets-regardless of whether or not they’re assigned a status. Left and Right joins are functionally the same; the difference is in the order that they appear in the query.

If you used an Outer join in this example it would show all assets (regardless of whether or not it has a status assignment) AND it would show all status options (regardless of whether or not the status option is assigned to an asset).  For this project we’re using only Left and Inner joins.

Stored Procedures

A stored procedure, in layman terms is a database query saved with the database; it’s good for separating the business logic from an application’s user interface. Sabre Systems prefers stored procedures over queries to interact with their database for two reasons (two that I’ve been able to identify):

1. The cascading effect of any updates–so if they decided to add any fields or alter the outputs they only need to adjust the stored procedure.  Alternatively without stored procedures, they would be updating every single instance the application calls the database.
   I use the word cascading because a similar and much simpler concept to understand is Cascading Style Sheets (CSS) where you can adjust the style sheet of your website to adjust the output of your entire website.
2. If they decide to rebuild an application–let’s say Sabre Systems wants to integrate two existing systems–they only need to rebuild the “view level”–the user interface.   Ideally with the stored procedures saved in the database they would not have to rebuild the business logic that is running the application.

Needless to say, I’ve stepped up to be the resident database nerd/expert.

Navigating the System

I like PowerPoint.  Here’s a little presentation Taahir and I put together to show Sabre Systems.  Of course, we explained everything as we walked through this, but you should be able to pick everything up from the text.

Download the PDF: Asset Management – Phase I

What to expect

I’ve been playing with words.

Our group has been calling this an asset tracking system and today I have decided to call it Asset Management.  I’ve seen some astonishing correlations with this project and some other information “management” tools.

Look out for a future article detailing the relationships between Asset Management, my Project Management Tool (Planning My First Plugin), and Content Management.

The theme is [insert object here] Management and the topic is Management Information Systems (MIS)–the goal is to close the gap and explain these less than obvious relations..

More more information on Sabre Systems:  http://sabresystems.com/

WordPress plugins open the doors for advanced features and functionality.  Some of the plugins on my site now include:

• NextGEN Gallery — which creates these beautiful photo galleries,
• Google XML Sitemaps — which creates a dynamic site map and notifies the major search engines of site changes, and
• Wordbook — which makes a note on my facebook every time I write a post on my site.

WordPress creates a set of “hooks” that can be used by scripts–”plugins”–to interface with the site.

My plugin is going to be a Project Management Tool that will allow teams to use the wordpress admin console as a center for their project task lists. With no further ado I created a dossier reviewing the planning phase of the plugin:

See the PDF: Project Management

Pictures from the Sears Tower

[View with PicLens]

This is long overdue.

MIS at Temple University has officially been ranked on the top 10 list of programs for undergrad IT.  It’s nice coming from a publication like techrepublic.com–as they actually built a set of metrics and surveyed the schools they ranked.

View the Tech Republic report (pdf).

Pictures from MIS Top 10 Celebration on Facebook

Why Fox MIS Dominated

The curriculum, the professors, the staff and administrators, the students, the alumni, the SPO (AMIS), the internships, and the post-graduation job placements all play a part in earning Temple’s MIS program a spot on the list of top 10 MIS programs in the nation!

Reviewing some of the metrics, there is no question why Fox MIS is on this list.  I can only speak from my experience, so here is what I see:

Curriculum of the IS/IT program

Firms are finding value in employees with practical business knowledge–after all, they are hiring for business needs.  The hardcore programmers that cannot work with “the end in mind”–ie the business solution–are going to be less desirable to a firm.  This day and age firms want to integrate technology to compliment their business model and to integrate business and technology firms need leaders with working knowledge of both.

Fox MIS is taught in the business school by business leaders. There are two parts to this to be considered: (1) Fox MIS students go through the business core classes–ie

• Accounting I & II,
• Finance I & II,
• Human Resources Management,
• Risk Management and Insurance,
• Management Science and Operations Management,
• Marketing;

and (2) MIS professors have nothing less than applicable business experience to relate to–each speaking from a different industry.

Fox MIS is creating a group of extremely well-rounded business leaders.

Cost value analysis for the education

Temple always wins this category. Tuition is slightly more than chump-change compared to our neighbor schools and the university presents just as much opportunity as any other school.

Co-ops  and/or internships offered in the program

Opportunity for Co-op and Internships is a core strength of the Fox School of Business.  Anyone that really tries can get a summer internship or a co-op placement.

My internship experience has been key in making my classroom learning practical and relevant.  Relating classroom material with personal experience is going to be much more effective than just reading text books.

Placement

I am pretty sure Fox MIS still has 100 percent placement for graduates.  Fox MIS is a high performance program with high expectations. And as long as our graduates maintain this work ethic employers will continue to fight each for Fox MIS graduates.

Overall “strength” of the program

This is a very ambiguous criteria from Tech Republic.  Maybe this is refering to group synergy?

In regards to strength I will say that even before this ranking was released I had no doubt in my mind that Fox MIS was one of the best.  I walked with nothing less than confidence that I would get to where I wanted to be.  If the program’s ability to instill confidence into its students is not strength, than I don’t know what strength of a program even could be.

Here is an archive of my first 5 websites. As you look through them, you will notice serious progress from one version to the next–I think so at least. My goals are always to build a fun and interesting website and I think that’s representative of what you see.

Version 1

This site was built for the CIS Computers and Applications course. It looks bad, but I got full credit for it. Check out the awesome rollover buttons–that was extra credit…

Version 2

This site was innovative in how the site navigation worked. On top of a few different pages, there were “tours” that users would walk through and be presented with information I wanted them to see–think of it as a glorified PowerPoint. Though, the design is bad, it has a pretty cool photo gallery in one of the tours.

Version 3

This was the first wordpress implementation that I attempted; it was kind of a disaster. I was trying to do some advanced things that I was not ready for; such as, using posts as news feeds, using a sidebar that picked a random post containing a quote, and using posts to operate the picture of the week. Most of these features actually worked, but I never worked out some of the details–how I wanted the different templates to work.

Version 4

This was a transitional site. Even before I started building it, I had Version 5 in mind–think of it as a “vista”. I had my heart set on building a wordpress theme, but I needed to put something presentable up on my URL. I was trying out some of those web 2.0 design concepts–I think I did it wrong…

Version 5

This is what you are looking at now. As mentioned before, I wanted to balance professionalism with personality. Ideally, this is a site can be used for two purposes: (1) I can share it with potential employers via business cards and my resume to add value to my application, and alternatively (2) I can share my knowledge and contribute to the internet.