Friday, 24 January 2014

Cover Letter For Marketing Executives

Dear Mr./Ms. Name/ Last Name,

I am very interested in the position of “Name of the Position” with you/ your company/ Company name, and believe that my education and employment background are appropriate for the position.

I have (Total experience) years of experience in the field of marketing and I am capable of taking care of a team. I have been heading a team of 5 people now and would love to take up more responsibilities.

In my current position as Sr. Marketing Executive, my primary duties are advertisement and promotion of the product, meeting potential customers/ clients and generating sales.


Thursday, 21 November 2013

Cover Letter For Freshers

Subject Line: Application for the post of “Name of the post”

Dear Sir/ Madam

My name is ”your name” and I have recently seen your position of “position name” as advertised on a job portal (or name the website)/in an English daily (mention the name of news paper) dated (date of advertisement).

I feel that I have the qualifications, experience and accreditation you are seeking for this role.  My resume is enclosed. Thank you for your consideration and I look forward to hearing from you.


Yours sincerely

“Your Name”
Contact No:

Tuesday, 27 August 2013

SQL Interview Questions And Answers

I have made every effort in writing this post to ensure the accuracy of the information. In this section you can find commonly asked SQL interview questions with their answers. This post surely helps you a lot at the interview. Best of Luck!


Q1: What is SQL?
A1: SQL stands for 'Structured Query Language'. SQL is used for accessing and manipulating database.

Q2: What is COUNT keyword in SQL?
A2: COUNT keyword is used to find the total number of records in a table.
Example: SELECT COUNT (*) FROM emp WHERE Sal>10000; returns all the records of the TABLE ‘emp’ where Salary is less than 10000.

Q3: What is GROUP BY clause?
A3: GROUP BY clause is used to group rows that have the same value.

Q4: What is the difference between a "WHERE" clause and a "HAVING" clause?
A4: The WHERE clause places conditions on the selected columns, whereas the HAVING clause places conditions on groups created by the GROUP BY clause.

Q5: What is SELECT statement?
A5: The SELECT statement is used to select a set of values from a table in a database.
For example: SELECT  *FROM emp WHERE Sal>10000


Saturday, 24 August 2013

Simple HR Interview Questions And Answers

In this post you can find General / Easy HR Interview questions for Freshers as well as experienced professionals. I am sure it will help you a lot.

Some of the general tips that a candidate must keep in mind before going for a HR interview are:

  • You must be fully up-to-date about the company in which you are going to attend the interview, so do some research.
  • Highlight the positive aspect of the company and make the interviewer feel that you have researched well about the company.
  • Know about the company thoroughly, and match your goals and objectives with company’s goals and objectives.
  • Clearly state when you will be joining the organization, industry always looks for responsible and honest employees.
  • Be specific and to the point. You don’t have to start with your high school percentages. Instead highlight on the recent past qualification.

Q1: Tell me about yourself.
A1: It is normally the most asked question in the interview. Answer the question by simply talking about your relevant experience and education. Don’t put forward your personal profile.

Q2: What do you know about the organization?
A2: This is the question where your prior research and homework about the company will work. Highlight the positive aspect of the company. Keep your answer short and noteworthy.

Q3: Why should I hire you?
A3: Answer the question by talking about your talents and skills that match the job profile. Give examples of related work experiences that you have accomplished.

Q4: What is important for you money or work/Position?
A4: You may answer this question by saying that money is very important, yet it’s not everything, there’s something beyond it, which is job satisfaction!

Q5: Why did you resign from your previous job?
A5: Do not criticize your previous employer or coworkers. You may say that you are looking for a more challenging role, you may also mention problem like buy out, merger etc.

Q6: How do you handle pressure? Do you like or dislike these situations?
A6: If you do perform well under pressure then give a descriptive example. At last you may say that high achievers tend to perform well in pressure situations.


Friday, 23 August 2013

Java Interview Questions And Answers

I have made every effort in writing this post to ensure accuracy of the information. In this section you can find all commonly asked Java interview question with their answers.  I am sure it will help you a lot. If you have any suggestion about these Java Question & Answer please write to us.


Here Questions and their Answers are arranged in a systematic manner so that you can learn it with ease. 

Q1: What is Abstract Class?
 A1: A class that contains one or more abstract methods, and therefore can never be instantiated, but rather inherited by other classes.

Q2: What is Abstract Method?
A2: A method that has no implementation.

Q3: What do you mean by Encapsulation?
A3: Encapsulation refers to keeping all the variables and methods together in an object. Because objects encapsulate data and implementation, the user of an object can view the object as a black box that provides services.

Q4: Give a few reasons for using Java?
A4: 1) Java is Object Oriented, 2) Platform independent, 3) Built in support for multi-threading, socket communication, memory management, 4) Supports web based applications like Applet, Servlet and JSP.

Q5: What is an Argument?
A5: A data item specified in a method call. An argument can be a literal value, a variable, or an expression.

Q6: What is difference between C++ and Java?
A6: 1) Java does not support pointer, 2) Java does not support multiple inheritance, 3) Java does not support global variables or functions as all the Java program is encapsulated within class while C++ supports global variables and functions and 4) Java includes automatics garbage collection while C++ requires explicit memory management.

Q7: What is Polymorphism?
A7: Polymorphism means the ability of a single variable of a given type to be used to reference objects of different types, and automatically call the method that is specific to the type of object the variable reference.

Q8: What is Exception in Java?
A8: An event during program execution that prevents the program from continuing normally. Exceptions are conditions that occur because of bad input etc. e.g. FileNotFoundException will be thrown if the specified file does not exist.  

Wednesday, 24 July 2013

Simple Cover Letter 5

Dear Sir or Mr. (Name),

I am writing in response to the advertisement dated (Mention date like 25th July 13) in the English/ Hindi daily (Mention the name of Newspaper like Hindustan Times) for the post of (Mention the position).
I have 3 years experience (mention exact years of experience) as a (your job title) in (Company name). I am familiar with (name relevant areas of knowledge).  My skill set includes (name your skills). I have done (mention your educational qualification like MBA in Finance/ Marketing etc and certification in safety management).  I am hard working and capable of leading a team/ able to work in pressure.

Enclosed is my resume.  I hope it will be helpful in evaluating my qualifications for this position.  I look forward to hear from you.

Yours Sincerely
Your Name.

Wednesday, 19 June 2013

RESUME/ CV FORMATS FOR FRESHER

Below are the simple 1-Page Resume/ CV format for fresher. Only you have to edit the information provided here as per your need i.e. educational qualification, personal details like Address, Contact No, e-mail Id, etc. Career objective description in the given CV format is well suited for fresher, but if you still want to edit the information you can.

If you want this CV format, simply mail us on hyderali33@gmail.com and mention resume code02 in the subject line of the mail.



SIMPLE CV/ RESUME FORMAT



This post contains CV/ Resume Format for Fresher as well as experienced IT professionals. Only you have to edit the information provided here as per your need i.e. educational qualification, experience, Computer Skills/ Skills, Personal key competence, etc.

If you want this CV format, simply mail us on hyderali33@gmail.com and mention resume code01 in the subject line.

                                                           First Page

                                                      Second Page


Friday, 7 June 2013

EXPERIENCE CERTIFICATE FORMAT/ RELEAVING LETTER FORMAT

This is my second post on Experience certificate/ Relieving letter. Like pervious one you have to edit the information provided here like company name, logo, address of the company, your name, date of joining and relieving etc and most importantly you require a letterhead on which you print all these matter.

                                                                                                                              Logo
                                                                                                                  Name Of The Company


6th June, 2013

                                       TO WHOMSOEVER IT MAY CONCERN



This is to certify that Mr. Sunil Kumar Sinha was employed in our organization from 25th August 2011 to 20th May 2013. At the time of his leaving, his designation was Sr. Marketing Executive.

He left the organization of his own accord and we wish him all the best for his future endeavors.




FOR XYZ INFOSYSTEMS PVT. LTD.

(Signature)
S K Dhawan
Sr. Executive HR

______________________________________________________
 Branch Office: FB-01, New Friends Colony, Crown Plaza, Okhla.
                   New Delhi-110012,   Tel: 011-33445566

Regd. Office: Company name, Mittal Complex, Opp. Hotel Mazda, Malad , Mumbai-400 0021, Tel: 022-3344547  

Friday, 31 May 2013

SALARY SLIP/ PAY SLIP FORMAT

Salary Slip Format For Call Centers/ BPO Employees.

This is my third post regarding Salary Slip/ Pay Slip Format. This Payslip format is different from earlier formats, because this is for BPO/ Call Centers employees that usually consists of 2-3 more fields like Attendance Incentives and Performance Incentive. You earn more if your attendance is good in form of Attendance Incentive and Performance Incentive is directly linked to the calls you have received and resolved during a particular month.   

Below is an example of Salary Slip/ Pay Slip format of Technical Support Associate.



















 

Salary Slip Example 1

Salary Slip/ Pay Slip Example 2

Monday, 20 May 2013

RESUME / CV FORMAT

Earlier I have published several Resume/ CV Formats on this blog. But my earlier post contains only image views. In this post I will try to explain how to write a good Resume for fresher. A resume may be written in various formats, in this post I am presenting a simple example.

A Resume for fresher usually has 6-7 basic parts.
  • Firstly header part which consist of your contact information which includes your name, mobile no., e-mail id.
  • Second part would be your career objective.
  • Then project details (if any).
  • Educational Qualification.
  • Key Skills (like MS Office, Tally, Shorthand Typing).
  • Extracurricular activities (like captain of school cricket team/ takes part in social/ cultural activities, etc.).
  • Lastly your personal details which includes your name, address, Date of Birth, Gender, Marital status,  language known (English, Hindi, Urdu, Spanish, Latin, French), language known may be mention separately after educational qualification

Generally the details in a Resume/ CV for fresher are in this format, you may alter the order by exchanging the positions of educational qualification and project details or complete personal information at the top of the page.

Below is a image of 1-page simple CV format for freshers.


Wednesday, 15 May 2013

EXPERIENCE CERTIFICATE / RELIEVING LETTER

This post is about experience certificate / relieving letter. You have to edit the information provided here like company name, logo, address of the company, your name, date of joining and relieving etc. 
 

Logo                                          Name Of The Company


Date: 15 May 2013 
Ref:                                                                                                                                    
                
                                               To Whom It May Concern                                                                                                                                                      
This is to certify that Roshan Kumar Lal s/o Mr. Mohan Kumar Lal has worked as System Administrator in the IT department of our Company from 2nd May 2011 to 20th May 2013.

During his tenure, we found him very co-operative, sincere, disciplined, professional and hardworking.

We wish him a bright and prosperous future.



For (Name Of Company)
(Signature of Employer/ HR Executive)
Authorized Signatory
_________________________________________________________________
Office: 3/22, IIIrd Floor, Mittal Complex, Opp. Hotel Swaraj, Dadar, Mumbai-400 0028 
M-8899667744  Tel: 022-33445566,   Fax: 022-332211445         e-mail: info@companyname



HR Interview Question and Answer

  More Experience Letter Format


Tuesday, 14 May 2013

PAY SLIP FORMAT/ SALARY SLIP FORMAT



                                               Logo Of Company         **Logo is optional

                                           Name Of The Company

                                         Address Of The Company

                                    Payslip for the month of Jan 2013.

Employee No.
678956
Location
Ranchi, Jharkhand
Name
Sunil Kumar Singh
Department
India East region Operation Dept.
Bank Name
Bank Of India
Designation
Engineer.
Bank A/C No.
123-056788-088
Total Days
31
PF No.
MR/SSD/67345/2244
LOP
0
ESI No.

Work Days
31
PAN No.
AMGRP17058
Effective Work Day
31


       Earnings
              Rs.
           Deduction   
            Rs.
Basic Salary
        15,392
Employee Provident Fund
         1,845
HRA
        7,696
Income Tax
         1,374
Conveyance Allowance
        800


Taxable FRP
        20,109


Total Earnings
        43,997
Total Deductions
         3,221

Net Pay: Rs. 40,776 (Rupees Forty Thousand Seven Hundred Seventy Six)
                 **This is a Computer generated payslip and does not require any signature.
                    ______________________________________________________________
(Note: HRA is 50% of Basic Salary (HRA depends upon the city where you are posted), EPF (employee provident fund) is 12% of Basic Salary.)



Salary Slip/ Pay Slip Example 2

Salary Slip/ Pay Slip Example 3

Java Interview Questions and Answers