Post to myself : 10 Years Ago : Advice to IT professionals
So my story is, I am now 35, I have been working on computers since 4, and started screwing around on a Commodore 64,
Therefore, Logic dictates, that I have been doing this for a while.
I actually found myself in a market space about 12 years ago, whereby I ended up as an ERP manager, purely by accident.
I excelled, liked it and carried on, having only the high school equivalency qualification.
I got given more departments to run, and moved over to operations as well, as ERP = Business fundementals = Strategy ect
Then found myself out of work due to global company closing
I then got certified in SAP Business one in 2005, which was pretty new in my country with zero resources, and I ended up doing about 8 projects varying in size, again ERP was language, Finance, IT, Logistics, became specialty. I was freelancing during this time consulting for/to project houses
I then got offered a job by an ex employer, for another major international. Senior manager, Title of Ops management, responsible for Logistics, ERP, IT, and sometimes Finance (while they were between finance managers)
I did that for about 5 years, I then got bored, everything was working, redefined ERP, processes in place, line managers trained, reporting in place.
Based on my experience, references, ect, I was accepted to do an online MBA through the University of Liverpool. I did that in 3 year while working at the above. I qualified, got paperwork, and boss goes, thats nice. I have a masters degree that cost me more then my car, and boss kinda goes, "well done"
I decided bugger this, I am going back to freelance consulting, but as I hate sitting at home between Projects, I bought a small business in the automotive trade repairing accident damage, idea was, to have an "office" and be able to Freelance.
So I quit my job, got a support agreement from old company, got my SAP clients as well. bought this franchise. Continued to consult,
Franchise started taking up more and more, I hit a huge market boom, and the franchise took over. staff from 8 to 35, vehicles 4 a week small to 30 a week, medium to large.
Right at the end of a seasonal spike, I sold the place at a decent profit, but did not build my consulting client base during this time, so 3 years "out of IT" basically
Now I am unemployed, I have been in IT and Operations for 16 years, market is saying your not an IT guy because of 3 year gap, and you have no real IT paperwork, management is saying well, we see your IT experience, but we want a manager.
I now have to go and re-establish my skills in the form of paperwork.
I sat in for ITIL foundation training, what a continental joke, ITIL itself is not a joke, the standards are pretty cool, if your a multinational with 1000 IT support staff,
The people that attended the training, were there because ITIL is something trendy to put on the CV, have no CLUE, I was stunned at the total lack of application of knowledge, they of course had 100% pass rate, yet I would not trust most of those guys that graduated to make toast, let alone design a service delivery strategy.
I have been an ERP DBA for x amount of years, I am set in my ways, my SQL knowledge, or way of doing things were efficient and effective, was second nature. Never bothered to learn anything else, as I could accomplish any task with SQL nested views and BusinessObjects Crystal Reports, any database, any excel table I could do.
Now I find myself, at 34, "Too Old", I have no paperwork of relevant skills, my path is not clearly defined, am I management, or am I an IT guy, nobody is even looking at me.
I am currently starting of 70-461 with the aim of Business Intelligence, and WOW was I in for a shock, thought I was a 15 year experienced consultant, with SQL being mother tounge, so this should be easy... Im probably going to fail my exam, which is in a weeks time.
Summation
After reading all of the above crap, the punch line is, even if you have decent work and your "future" is set, make sure you do at least one relevant course a year as self study, and show continued improvement in terms of skills. Do not make the same mistake that I did, oh and an MBA is actually not much these days...
Go onto a career site, look for the trendiest certification in demand which is fairly easy to spot, and go do that, regardless of relevance to your future and current state.
I wish I had read this post 10 years back...
Case in point from the training for 70-461
Their way
SELECT
Name,
NumberOfSales,
SalesQuantityTotal,
SalesGrossTotal
FROM
Products pout
LEFT JOIN
(SELECT
s.ProductID,
COUNT(*) as NumberOfSales,
SUM(Quantity) as SalesQuantityTotal,
SUM(Price * Quantity) as SalesGrossTotal
FROM
Sales s
JOIN
Products p on s.ProductID = p.ProductID
GROUP BY
s.ProductID) pin ON pout.ProductID = pin.ProductID
My way, which I have been using for the last 10 years
Select products.name,
(Select Count(sales.ProductID) from Sales where sales.ProductID= products.ProductID) as 'NumberOfSales'
,(Select SUM(Sales.Quantity) from Sales where sales.ProductID= products.ProductID) as 'QtySold'
,(Select SUM(Sales.Quantity) from Sales where sales.ProductID= products.ProductID) * Products.Price
from products Order by products.name
Mine is far simpler to understand, a bit more resource intensive, but has served me well, it also means, I fail....
So who has dinosaur tricks for 70-461 ? I am using CBTNuggets, any other critical tool I should consider.