Thursday, July 19, 2012

How To Write An Interview Winning Resume


Writing a resume that rocks is not an art. It just requires some planning and an understanding of what you want it to achieve for you.

Of course therein also lies the problem because many people are not exactly sure what they want their resume to do for them. This is why you will often see resumes that have listed every single technology feature a candidate has ever encountered, or why the hiring manager is reading a resume that is eight pages long and wondering when the pain of this monstrosity will all be over. The truth is the hiring manager never even reads the entire resume and instead simply moves immediately on to the next one without giving it a further thought.

Do you want your resume to be one that gets overlooked? Of course not!

I’m going to share with you exactly what you need to do in order to create an interview winning resume for a Database Administrator (DBA), Data Professional or any other darn profession you can think of for that matter. What prompted such an awesome display of generosity you ask? Well there is a story behind it (alluded to here) that you can ask me about next time we meet, but for now let’s just pretend it’s because I’m a super nice chap.

Regular readers will know that I’m a big fan of KISS. Not the awesome rock band but rather the principle of Keep It Simple Stupid! So for your reading pleasure I have compressed a wealth of winning resume writing knowledge into 4 simple rules. I know, impressive right.

In order to ensure that your resume gives you the best possible chance of securing your next interview it MUST be:


  • Readable
  • Relevant
  • Accurate
  • Valuable

Let’s take a look at each rule in a little more detail to find out exactly what is required.

1. Readable
Your resume should be a pleasure to read. It should be an effortless experience for the reader, enabling them to immediately zone in on precisely the information they seek. The language you use should be concise and to the point. You’ve got a limited amount of space to use in order to sell yourself and you want to do so within two pages. That’s right, your resume should be two pages maximum. Anything more and you are not being concise or relevant enough.

In summary some of the points you will want to consider are:

Scannable – Is your resume easy on the eye? Can the reader easily locate information?
Concise – Stay on point. Be specific and don’t waffle.
Incorporate bulleted lists – These will improve the structure of your content, making it scannable and easier to consume.
Consider font choice - Keep it clear and professional. Stay away from creative fonts and color palettes.
Two page limit - Don't squash your content. Be ruthless with what you include.


2. Relevant
Include only what is relevant to the “specific” role you are targeting your resume for. It can be tempting to list each and every skill that you may have, you might be putting your resume forward for a number of different opportunities but if the skills are not relevant then they won’t demonstrate value(see 4.Value below) to the reader. The irony of a catch all resume is that it will actually get you nothing. It’s demonstrably lazy. Don’t do it!

In summary some of the points you will want to consider are:

Be specific – Include ONLY the information pertinent to the role.
Don’t include references – You’ll be asked for them if and when needed. Use the space for “valuable” content.
Exclude personal interests – Your personality will come across/be promoted during the interview.


3. Accurate
The invention of the Spellchecker was a wonderful thing folks, so there really is no excuse for spelling mistakes or poor grammar. All good Data Professionals have excellent attention to detail, fail to get this one right and you’re pretty much just demonstrating that you don’t have what it takes.

In summary some of the points you will want to consider are:

Spelling and Grammar – Check it, double check it, get someone else to proof read.
Accuracy of facts and information – Use of correct product/technology names and versions.

4. Valuable
Why should I hire you? You know SQL Server clustering, so what? Why is that of use to me as a business owner? Demonstrate the business value you have delivered because of what you know or have done. Simply listing technology and skills is boring. Take your resume to the next level by clearly showing the reader how you delivered value using what you know. Be factual in your delivery and mind you don’t take it to the other extreme or you’ll end up coming across as boastful. The emphasis required on demonstrable financial value for a Sales Director is going to be a lot more than is needed for BI Developer. You need to find the right balance for your market.

In summary some of the points you will want to consider are:

Expertise – Demonstrate your value through the results of your actions that were enabled by your skills.
Key Achievements – Make a point of highlighting your big wins and achievements. Deployed an entire DR solution protecting assets worth £x million? Tell the reader.
Demonstrable value – Revenue, costs savings, business awareness. What makes you an asset to have on staff?
Passion – Show your love of technology(or chosen field) and for learning.


Keep It Simple
There you have it, four simple rules you should make sure your resume follows to give you the best possible chance of winning that next interview spot.

What do you think is important to creating an interview winning resume?

Best of luck with your job search!

By John Sansom

Thursday, April 19, 2012

Smartphones, tablets to get Android 4.0 in India

Here is a comprehensive list of devices (tablets and smartphones) which are available in India and will get an Ice Cream Sandwich (Android 4.0) update, and the date when they will get that update.
There has been a lot of euphoria in the market about the most advanced Android operating system, which is dubbed as Ice Cream Sandwich. On the same hand, there is a lot of confusion over the availability of Android 4.0 in India as well.
To clear the air, here is a comprehensive list of devices (smartphones/tablets) which are available in India and will soon get the Android ICS. It is to be noted here that currently no phone or tablet, which are available in India, has Android 4.0 ICS.
Smartphones, tablets to get Android 4.0 in India


















 

Google to launch online storage service

You will soon be able to store files as large as 5GB online instead of in PC hard drives after Google launches its "GDrive".

A Google source wrote on the blog "The Next Web" that the company is planning to launch the service mid-next week.

The service will offer 5GB of storage, and appear as an icon on Windows and Mac desktops into which users simply "drop" files, the Daily Mail reported Wednesday.


The service will be a rival to services such as Dropbox, a "cloud" storage start-up recently valued at $4 billion. A Google spokesperson declined to comment on the leak.

The company has long been rumoured to be working on such a service.

Google has spoken about launching a "G Drive" service in the past, but the company has been tight-lipped on the subject recently. 

Thursday, April 12, 2012

Send Free SMS

Your mobile number:

Send SMS using Stored Procedure in Sql Server


create procedure [dbo].[pr_SendSmsSQL]   
    @MobileNo varchar(12),   
    @smstext as varchar(300),   
    @sResponse varchar(1000) OUT as BEGIN       
Declare @iReq int,@hr int       
Declare @sUrl as varchar(500)       
DECLARE @errorSource VARCHAR(8000)   
DECLARE @errorDescription VARCHAR(8000)        
-- Create Object for XMLHTTP
   EXEC @hr = sp_OACreate 'Microsoft.XMLHTTP', @iReq OUT        print @hr        if @hr <> 0     
      Raiserror('sp_OACreate Microsoft.XMLHTTP FAILED!', 16, 1)        
set @sUrl='http://api.clickatell.com/http/sendmsg?user=devendar&password=xxxxxxxxx&api_id=xxxxxxxx&to=#MobNo#&text=#Msg#'        
set @sUrl=REPLACE(@sUrl,'#MobNo#',@MobileNo)       
set @sUrl=REPLACE(@sUrl,'#Msg#',@smstext)        
print @sUrl        
-- sms code start
   EXEC @hr = sp_OAMethod @iReq, 'Open', NULL, 'GET', @sUrl, true       
print @hr        
if @hr <> 0     
      Raiserror('sp_OAMethod Open FAILED!', 16, 1)        
EXEC @hr = sp_OAMethod @iReq, 'send'       
select @iReq       
print @hr        
if @hr <> 0       Begin               
EXEC sp_OAGetErrorInfo @iReq, @errorSource OUTPUT, @errorDescription OUTPUT                SELECT [Error Source] = @errorSource, [Description] = @errorDescription                Raiserror('sp_OAMethod Send FAILED!', 16, 1)       end else Begin    EXEC @hr = sp_OAGetProperty @iReq,'responseText', @sResponse OUT   
    print @hr   
    insert into send_log (Id, mobile, sendtext, response, created, createddate)   
    values(0, @MobileNo, @smstext, @sResponse, 'System', GETDATE())endend



Using the Above Stored Procedure and with SMS Gateway API  - simply u can send sms to anybody - its a simple task

Just pass the parameters to Stored Procedure for which number you want to send sms. thats it.

i tested this using Sql Server 2008 with clickatell sms gateway.

Thanks friends This is my first POst