iPEN

Header/Margin:

22-01-07

Employers

Main Body (Handwritten Letter/Note):

Dear HR Manager

iPEN stands for 'IndikRecruiter PEN'.

You already know that PEN stands for "Permanent Executive Number".

But non-jobseeking executives may be exercised for thinking that iPEN stands for

I am a Potential Executive Name.

They may even consider printing their iPEN on their business cards!

Then suggest that you look up their Profiles by simply typing their iPEN on your iPhone! [Just wait-we are talking to Steve Jobs]

We hate to make you wait.

Till such time, your option is to type in the box below,

Form/Interface Sketch:

• Executive PEN [Box]
• Executive Name
• First Name [Box]
• Last Name [Box]
• OR Show Profile [Button]
• ADD [Button]

Right Sidebar/Margin:

iPEN

Re: $1=$ per

Click

View

 

INTERVIEWER

Interviewer

Interviewing Made Easy

• Interviewer is a Recruiter's ultimate offline interview tool for IT and Non-IT candidates, with 15,000+ interview questions/answers built into its database.
• Its a hassle free (no more waiting for each pages to load, no more problems of firewalls and proxy servers) software for Interviewers.
• It enables you to add your own, skill-specific interview questions. To see Interview Questions, just click on the automatically extracted / tabulated keywords (Karmascope).
• Interviewer is also your offline Resume Search Engine, enabling you to search resumes (Profiles) downloaded from www.IndiaRecruiter.net You are not merely downloading the "Texts" - you are also downloading the entire structured resume databases, which enables, this offline search engine to search resumes on the following parameters:
1. Function (Non-IT) / Skills (IT)
2. Years of Experience
3. Designation Level
4. Education Level
5. City Location
6. Keywords

RecruitGuru

Address:

A-4/516,

Lok Bharti Complex,

Marol Maroshi Road,

Andheri(E),

Mumbai - 400 059

Tel: 022-6707 0377

Email: reply@recruitguru.com

 

Context-Level DFD

[Diagram: Data Flow Diagram (DFD) with 4 processes]

Process No.	Process Name	Input Data Flows	Output Data Flows	Data Stores
1	Download Candidate Database	Pen Numbers, User Name, Password	Candidate Information (Pen Information)	PERSON_TABLES
2	Search Engine	Pen Numbers / Search Criteria	Candidate Database in tabular format	-
3	Display Candidate Database	Pen Number	Karmascope	-
4	Question Bank	Questions, Function	Question Databank	-

 

1-Level DFD for 'Download Candidate Database'

[Diagram: Data Flow Diagram (DFD) for 'Download Candidate Database' with 4 sub-processes]

Process No.	Process Name	Input Data Flows	Output Data Flows	Data Stores
1.1	Validate Pen Number from IR	Pen Numbers	Login Window / Error Message	-
1.2	Validate User Name & Password from IR	User Name, Password	Valid Flag / Error Message	-
1.3	Update Master List	Data From IR	Master List data	MASTER_TABLES
1.4	Update Candidate Database	Data from IR (all pen information)	Person data	PERSON_TABLES

 

1-Level DFD for 'Display Candidate Database'

[Diagram: Data Flow Diagram (DFD) for 'Display Candidate Database' with 4 sub-processes]

Process No.	Process Name	Input Data Flows	Output Data Flows	Data Stores
3.1	Fill Drop list with Pen	Pen Numbers	Pen Number List	PERSON_TABLES
3.2	Get Person's all Details	PEN Number, Person Data	Dataset having person details	PERSON_TABLES
3.3	Generate 7 (NonIT) / 8 (IT) graphs	Person Data	Graphs	-
3.4	Update Candidate Database	Person Data, IIT Data, Master Data	Karmascope	-

 

1-Level DFD for 'Question Bank'

[Diagram: Data Flow Diagram (DFD) for 'Question Bank' with 4 sub-processes]

Process No.	Process Name	Input Data Flows	Output Data Flows	Data Stores
4.1	Create Your Own Questions	Category, Function id and Question	Questions	IIT_TABLES
4.2	Import Questions	Excel sheet	Questions	IIT_TABLES
4.3	Show Questions	Questions	Questions in Tabular format	IIT_TABLES
4.4	Delete Questions	Question Id	Remove Question	IIT_TABLES

 

Relationship diagram of Access File PERSON_TABLES

[Diagram: Entity-Relationship Diagram showing the relationships between the main entity (GRPERSON) and several related tables.]

The main table appears to be GRPERSON which has a primary key PEN and includes fields like:

• PEN
• FIRSTNM (First Name)
• LASTNM (Last Name)
• ADDRESS1
• ADDRESS2
• ADDRESS3
• PIN
• CITYID
• STATEID
• COUNTRYID
• HOMEPHONE
• WORKPHONE
• MOBILE
• RESUMEPATH
• GENDER
• MARITALSTATUS
• EMAIL
• DODOB
• EXPERIENCE
• PENOID
• ENTERDT
• UPDATEDT
• PREFERREDLOCATION

The GRPERSON table is linked by PEN (1-to-many relationship) to the following tables:

Linked Table	Fields
GRPERSONSCOPE	PEN, FUNCTIONID, FUNCTIONNM, STRENGTH
GRPERSONADDITIONALSKILLS	PEN, SKILLNM, PROFICIENCY
GRPERSONPROJECTEXPOSURE	PEN, PROJECTNM, PROJROL, PROJFROMMONTH, PROJFROMYEAR, PROJTOMONTH, PROJTOYEAR, ROLEPLAYED
GRPERSONKEYWORD	PEN, KEYWORDNM
GRPERSONEDUCATIONAL	PEN, DEGREEID, BRANCHID, PASSTYPE, PASSYEAR, INSTITUTIONNM, HIGHESTLEVEL
GRPERSONEXPERIENCE	PEN, EMPLOYERNM, NOOFYEAR, DESIGNATIONID, DESIGNATIONNM, CITYID, SALARY, CURRENTCOMPANY
GRPERSONRESUME	PEN, RESUMEFILENAME, RESUMEPATH, RESUMEHTML

 

Web services required for 'INTERVIEWER'

• WBSOFFLINEIIT

Tables required for 'INTERVIEWER' (which are in IR of Reliance Server)

• GRPERSONBASIC
• GRPERSONEDUCATION
• GRPERSONEXPERIENCE
• GRPERSONFUNCTION
• GRPERSONINDUSTRY
• GRPERSONADDITIONALSKILLS
• GRPERSONPROJECTEXPOSURE
• GRPERSONKEYWORD
• GRPERSONRESUME
• GRKARMASCOPE
• GRSKILLDICITY
• GRCOUNTRYLIST
• GRDESIGNATIONLEVEL
• GREDUBRANCHLIST
• GREDUDEGREELIST
• GREDULEVELIST
• GRFUNCTIONLIST
• GRINDUSTRYLIST
• GRSTATELIST
• GRFUNCTIONPOPULATION
• GRANNUALGRAPHGENERATION
• GRSALARYGRAPHGENERATION
• IIT_AI_FUNCTION_SUBCATEGORY_MAPPER
• IIT_AIQUESTIONS
• IIT_AIFUNCTION
• IIT_KEYWORDMATCHES
• IIT_SOFTSKILLQUESTIONS
• IIT_SOFTSKILLMASTER
• INTERVIEWER_CONTRIBUTED_QUESTIONS
• IV_DOWNLOAD_INFO
• IV_PEN_DOWNLOAD_DETAILS
• SEQUENCELIST
• GRPARTNERCLIENT

 

Stored Procedures required for 'INTERVIEWER' (which are in IR of Reliance Server)

• GET_IV_PEN_DOWNLOAD_COUNT
• INSERT_IV_PEN_DOWNLOAD
• INTERVIEWER_QUESTION_ADD
• IV_DOWNLOAD_ADMIN
• IV_DOWNLOAD_PEN_ADMIN
• IV_UPDATE_COUNTER
• OFFLINE_IIT_GET_LISTS
• OFFLINE_POPULATION_GET_LISTS
• CONTRIBUTED_QUESTION_ADMIN
• SP_SearchInterviewerFunctions
• SP_GETPARTNERIDBYLOGINANDPARTNERID
• SP_GETPERSONBASICBYLOGIN
• SP_GETPERSONBASICBYID
• GETPERSON_BYPENSTRING

 

Some important and different function used in 'INTERVIEWER'

1) Purpose: for getting machine mac address

Code snippet

Public Function machadd() As String()

    Dim mac As String()

    Dim LocalHostName As String

    LocalHostName = Dns.GetHostName()

    Dim ipaddr As String() = New String(2) {}

    ipaddr(0) = LocalHostName

 

    Dim Tempaddr As System.Net.IPHostEntry = Nothing

    Try

        Tempaddr = DirectCast(Dns.GetHostByName(LocalHostName), System.Net.IPHostEntry)

    Catch ex As Exception

    End Try

 

    Dim tempad As System.Net.IPAddress() = Tempaddr.AddressList

    For Each TempA As IPAddress In Tempad

        ipaddr(1) = TempA.ToString()

    Next

 

    Dim ab As Byte() = New Byte(5) {}

    Dim len As Integer = ab.Length

 

    'This Function Used to Get The Physical Address

    Dim r As Integer = SendARP(CInt(TempA.Address), 0, ab, len)

    Dim mac As String = BitConverter.ToString(ab, 0, 6)

 

    ipaddr(2) = mac

    Next

    Return ipaddr

End Function

8¹

2) Purpose : for formatting grid rows with specific colors according to requirment³

Code snippet

Private Sub formatGridRow(ByVal sender As Object, _

    ByVal e As DataGridFormatCellEventArgs)

    Dim discontinuedColumn As Integer = 0

    If Not IsDBNull(grdinfo.Item(e.Row, 2)) Then

 

        If grdinfo.Item(e.Row, 2) >= 80 And grdinfo.Item(e.Row, 2) <= 100 Then

            e.BackBrush = System.Drawing.Brushes.LightGreen

        Else

            If grdinfo.Item(e.Row, 2) >= 60 And grdinfo.Item(e.Row, 2) < 80 Then

                e.BackBrush = System.Drawing.Brushes.LemonChiffon

            Else

                If grdinfo.Item(e.Row, 2) >= 40 And grdinfo.Item(e.Row, 2) < 60 Then

                    e.BackBrush = System.Drawing.Brushes.LightBlue

                Else

                    If grdinfo.Item(e.Row, 2) >= 0 And grdinfo.Item(e.Row, 2) < 40 Then

                        e.BackBrush = System.Drawing.Brushes.MistyRose

 

3) Purpose : for compacting access database

Code snippet

Shared Sub Compact(ByVal fileName As String)

    Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database " & _

        "Password=rsays2007;Data Source=" & fileName

    Dim objJRO As Object = _

        System.Activator.CreateInstance(System.Type.GetTypeFromProgID("JRO.JetEngine"))

    Dim objParms() As Object = New Object() _

        {"Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=rsays2007;Data Source=" & _

         fileName & "_tmp.jet;OLEDB:Engine Type=5", connectionString}

    objJRO.GetType().InvokeMember("CompactDatabase", _

        System.Reflection.BindingFlags.InvokeMethod, Nothing, objJRO, objParms)

    System.IO.File.Delete(fileName)

    System.IO.File.Move(fileName & "_tmp", fileName)

    System.Runtime.InteropServices.Marshal.ReleaseComObject(objJRO)

    objJRO = Nothing

End Sub