Saturday, December 26, 2015

Project Manager Round FAQ's

In a Typical interview process,Project Management round plays a vital role, based on which the fate of the candidate would be decided.This round would be taken by a project manager and will evaluate the candidate in various aspects.

1)Technical
2)Nature of work
3)leadership qualities
4)Behavioral and commitment aspects
5)Source Control Management
6)Process Oriented

Project Manager will access the candidate to analyze whether he would fit for the current role based on his past experience, nature of work and various motivational and behavioral aspects.

He might ask questions related to the nature of work,roles and responsibility to check your willingness towards work and your ownership towards them,He will try to assess your skills and their experience as well.

He might ask various other thing about the organization in which you are working,its web site URL type of business number of employee, your designation and other things etc.

He might ask you questions related to the project (few in term of technical) size of the team ,client, your role and few of the challenges you faced while handling the project.In turn he will ask you process related question like delivery model,quality standard adaped ,SDLC lifecycle , Waterfall or Agile process.

At this stage he tries to check you in overall aspects to map you a role in his organization.


Technical Aspects FAQ


1) What is your Project Architecture?
2)What was your roles and responsibility in project ?
3)What are the technologies you have worked on ?
4)What are the tools that are used in your project ?
5)Which IDE you have used in development?
6)What are the Databases you worked on?
7)What are the Server/platform you worked on ?
8) Which Operating System/environment you are woking on ?
9) Have you ever been involved  into design?
10)What are the reporting tool you are using in your project ?
11)What are the CIS/build management tool you are using in your project ?
12)What are the volume of the data against which your application runs?
13)How do you manage secuirty like managing user credentials/data encryption etc?
14) how do you write Unit Test Case?


Nature of work FAQ

1) Have you ever participated in release call?
2) Have you ever been involved into testing?
3)What is your team size?
4)What are the corporate training you have attended?
5)Do you have experience on Production Support and What is the Hierarchy in production Support ?

Leadership Qualities FAQ's


1)Tell and explain to us about a specific situation during the project where you have to cope with a less experience candidate in your team and what are the measures you look to meet your deadlines?
2)How do you handle non productive team member?

Behavior and Commitment Aspects


1)Tell us some of your extraordinary skills(if any) which place you in the leading position over the other technical associate?
2)What were the criticism/difficulties you got during your projects, how did you handle it and what are the measures that you took to avoid repitation of the same ?

Source Control Management


1) What is SCM/SVN tool?
2)What are the measures that you take to ensure are minimal code conflicts with other peers in the team?
3)If You are working for a parallel release how do you manage your code?


I have written this contents based on my experience on different interviews.
Any other interview questions are welcome please share on comments.

Working with Stored Procedures.

How to Deal with Stored Procedures with JDBC.


To work with Stored Procedure we need to create connection and callable statement in the init() of the servlet. Here is an example on how to execute a stored procedure with JDBC .
package app;
import java.sql.*;
public class Dips1
{

private String msDbUrl = "jdbc:oracle:thin:@localhost:1521:XE";
private String msJdbcClass = "oracle.jdbc.driver.OdbcDriver";
private Connection con;
private CallableStatement cs;

public Dips1()
{
try {
Class.forName(;
mcDbAccess = DriverManager.getConnection( msJdbcClass, "milestone", "milestone" );
msProcedure = mcDbAccess.prepareCall(
"{? = call sp_sav_Bom_Header( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) }"
);
msProcedure.registerOutParameter( 1, java.sql.Types.VARCHAR );
msProcedure.setInt( 2, -1 );
msProcedure.setInt( 3, 39 );
msProcedure.setString( 4, "format" );
long ltTest = new java.util.Date().getTime();
System.out.println( "Today: " + ltTest );
msProcedure.setTimestamp( 5, new Timestamp( ltTest ) );
msProcedure.setString( 6, "type" );
msProcedure.setString( 7, "submitter" );
msProcedure.setString( 8, "email" );
msProcedure.setString( 9, "phone" );
msProcedure.setString( 10, "comments" );
msProcedure.setString( 11, "label" );
msProcedure.setInt( 12, 52 );
msProcedure.setBoolean( 13, true );
msProcedure.setBoolean( 14, false );
msProcedure.setInt( 15, 53 );
msProcedure.setString( 16, "runtime" );
msProcedure.setString( 17, "configuration" );
msProcedure.setBoolean( 18, true );
msProcedure.setBoolean( 19, false );
msProcedure.setString( 20, "special instructions" );
msProcedure.setInt( 21, 54 );

ResultSet lrsReturn = null;
System.out.println( "Execute: " + (lrsReturn = msProcedure.executeQuery() ) );
while( lrsReturn.next() ) {
System.out.println( "Got from result set: " + lrsReturn.getInt( 1 ) );
}
System.out.println( "Got from stored procedure: " + msProcedure.getString( 1 ) );
} catch( Throwable e ) {
e.printStackTrace();
}
}

public static void main(String[] args) {
new JdbcTest();
}
}
I also tried it by using a native JDBC driver (i-net) and it also works fine. The only problem we encounter with JDBC-ODBC bridge is that a stored procedure pads spaces to the full length of a VARCHAR but the native JDBC behaves right. Therefore I suggest to use JDBC native drivers.
The above example uses the MS SQL Server.