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.

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

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.

Bachelor of Business Administration (BBA)

• May 2010 Graduation
• Finance
• Management Information Systems (MIS)

About Temple

This school is driven by visionaries, diversity, and diligent workers. Temple is a school where our people–students and professors alike–are working towards fulfilling their life goals; there is so much more to this community than simply graduating and getting a job.

The diversity you would find on this campus teaches us to be empathetic towards culture and difference–we are accepted, in return we accept.

The unofficial university mantra of “student by day and worker by night” speaks to the dedication found on this campus. This is a working campus–we work to support our selves, our lifestyles, and, for some, our families. This added commitment teaches due diligence–using lunch breaks to study, learning to learn efficiently, and–when “doing more” is no longer an option–understanding what it means to “work smarter, not harder“.

Association of Management Information Systems (AMIS) – Temple University

AMIS is a Student Professional Organization (SPO) devoted to those interested in Management Information Systems (MIS).  Our themes include:

• running Professional Development activities (develop soft skills),
• MIS related workshops (develop hard skills),
• and bringing employers, students, alumni, staff, and faculty together for a variety of events including recruiting events, guest speakers, and networking events.

This school year I am the acting Secretary for AMIS. I manage the record keeping activities and the general information dissemination for the organization. I team directly with the following teams within the organization:

• Webmasters — This team manages site design, site enhancements and upgrades, and site support. This year our webmasters have launched the AMIS site powered by WordPress, a very powerful Content Management System (CMS). The are constantly investigating or implementing plug ins to add features to the site; examples include the following:
  • Paypal/E-commerce – Empowers site users with the ability to pay membership dues, activity fees, and make donations online
  • Calendar – Automates the event calendar as seen on the homepage.
  • Custom Forms - Create custom forms/questionnaires on the go.
  • Custom Admin – Customize every detail of user privileges in the admin console.
• Marketing — This team is fundemental in the success of AMIS’ activities; they support the organizations’ event planners–Directors of Professional Development, Networking/Community, External Relations, etc–with the skill set to distribute information throughout the organization. Marketing has been known to produce high quality email fliers, print fliers, and display cases throughout the business campus.
• Membership — AKA the organization’s database manager. Membership keeps detailed records of our events, members, meetings, attendance, and whatever else you can think of. This is crucial creating reports that are required by the university to stay in play.

http://www.temple-amis.org

AMIS at the IT Awards

J.P. Morgan

Investment Bank Technology: Core Processing North American Equities Plan (IBT CP NA Equities Plan)

For Summer 2008 I worked out of the Newark, DE office for JP Morgan. I filled a support role for a plan team working on a variety of different projects. I participated in implementing the quarterly release of a fairly ubiquitous, vendor-managed processing system; I was also creating and distributing management newsletters, and designing a training platform for a highly-anticipated, globally-released application.

The take-aways were about understanding the value of project management and business process analysis. I left with a practical and applicable understanding of IT solutions and Financial Markets. The keys of success for the internship were to test what I have learned in the classroom in the real-world and to bring the practicality of the “real-world” back to the classroom.

Computer & Information Science – Temple University

I was Lab Assistant for Temple’s CIS department for the 2007 to 2008 academic year. As a lab assistant I sat in on lab sessions for a CIS Intro course: Computers and Applications–a BBA core requirement. The focus of the lab sessions was to give the class a hands-on experience with Dreamweaver and Excel–and other office applications including Word, Powerpoint, and Access. My role in the classroom was to float around and help people keep up with the lecture. Outside of the classroom I offered everyone office hours, tutoring by appointment, email support, and I was responsible for grading all of the assignments.

This was a great experience; I learned more about the applications we taught then what I could have even potentially learned when I took the course. Through the year I became very effective at teaching the applications and material taught in the course–which turns out to be fairly universal skill. I took interest in pushing the scope of the class and investigating topics on my own.

Management Information Systems – Temple University

I am relatively good at relational databases–ie MS SQL, Oracle, mySQL, and Access.  I have been tutoring since the beginning of the semester; as a tutor, I make my self available to help people through the Database Management course.  Through helping others with database concept and syntax I have found my own understanding of the material to be developing immensely.