System Sql Server
Resume:
SUSANT PATRA
Dodda Banaswadi, Bangalore-******, Mobile: +91-973*******, E-mail:
********@*****.***
CAREER OBJECTIVE
I intend to establish myself as Software professional with an integrated
business solution provider through a long time commitment, contributing to
the company's growth and in turn ensuring personal growth with in the
organization. I believe that my technical, functional and communication
skills will enable me in facing the challenging career ahead.
EXPERIENCE SUMMARY
. 6 yrs of strong experience in Lotus Notes / Dominos (R5, R6.x,R7)
development in both Web and Client team studio, Service centre,
Mercury quality centre out of 8 years Overall IT experience.
. Good understanding of diff RDBMS like MS SQL Server 2000, IBM DB2,
Oracle, and MS-Access
. Good insight of Support, Maintenance, Enhancement and Migration
Projects and testing of business applications in Insurance, Retail and
Banking areas.
EMPLOYMENT DETAILS
ITC Infotech. IT consultant
Dec'2008-Tilldate
Accenture Services Pvt. Ltd. SSE Aug'2007-
Dec'2008
Q-source. Software Consultant Dec'2006-
Aug'2007
Adrenalin-e Systems Ltd (Polaris Software Lab). System Engineer
Dec'2004-Dec'2006
Mainstream technologies India Pvt. Ltd. Jr. Programmer
Sep'2002-Nov'2004
TECHNICAL PROFICIENCY
Groupware/Tools: Lotus Domino/Notes - R5/6.5/7.0/8.5
Operating Systems: HTML, JavaScript, CSS, DHTML
Database: Oracle, MS SQL Server, DB2
Other Software: Java, VB 6.0, ASP, D2K, Visual Source Safe, Team
Studio, LEI
EDUCATION
. PGDCA From NIIT, Bhubaneswar, Orissa
. Bachelor of Science from Berhampur University, Orissa
. Pursuing MBA (ICFAI),Bangalore
MAJOR PROJECTS DONE
1. RD Erhvervsvurdering (Enterprise Assessment) (ITC Infotech.)
Client : Danske Bank (Danmark)
Role : Team Member
Description : The RDErhvervsvurdering system is a customized application
used by Danske bank group intended to evaluate the properties
like apartments, renting buildings etc.
The RD Erhvervsvurdering system is used for storing the details
provided by the business customer on the business properties,
buildings, industry, apartments etc. The details provided by the
business customer are stored into the RD Erhvervsvurdering
system by the User who is an employee of the Danske Bank. The
user being a specialist in using the RD Erhvervsvurdering
system, manually evaluates the details provided by the business
customer on the business
property by comparing it with the price level of the property in specific
geographical areas. The User then fills in the details of the business
property in different sections in 'Vurdering' form, specifying the
description of the property, region etc. When the valuation has been
completed manually, certain calculations are done by system and are stored.
And further process started for till final approval .
Responsibilities :
Enhancements, Bug fixing etc
Resolving Tickets
Environment : Lotus Notes 7.0, Formula, Lotus Script, Lotus Database, Win
NT
2. Blanketter (Forms system.) (ITC Infotech.)
Client : Danske Bank (Danmark)
Role : Team Member
Description : The Form Processing System called Blanketter, is an
application implemented at the Danske Bank Group for accessing
the forms in the system which are available for all of the
Danske Bank Group members. The Form system has been established
for use of forms available in the system which are for internal
use only.
The types of forms that available in the Form system are:
1. Passive form for distribution via Lotus Notes mail for
printing out and manual distribution
2. Active forms that provide input for an underlying system
(Pensions Service, IT ordering, file transfer system)
The functionality in the Form Processing System has been
extended to areas mentioned below:
1. Facilitated identification has been provided for the form
identification
. Structured Identification
. Alphabetically identifying the form.
. Lotus notes search.
2. Facilitated data entry into the individual forms.
3. Extensive validation of fields.
4. System automatically fills in 'personal' data.
5. Administrative routines for ordering and updating forms.
6. Each form has an owner responsible for keeping it up to
date.
7. Statistics on the use of the various forms.
Responsibilities :
Enhancements, Bug fixing etc
Resolving Tickets
Environment : Lotus Notes 7.0, Formula, Lotus Script, Lotus Database, Win
NT
3. Enhancement and support (Accenture Services Pvt. Ltd.)
Client : NAG (National Australian Bank).UK
Role : Team Member
Description : This is an enhancement and support type of project for 50 or
more Lotus Client and web Applications.
Responsibilities :
Enhancements, Bug fixing etc
Resolving Tickets
Environment : Lotus Notes 7.0, Formula, Lotus Script, Lotus Database, Win
NT
4. Enhancement and support Client (Accenture Services Pvt. Ltd.)
Client : TELCORDIA.USA
Role : Single Member Team
Description : This is an enhancement and support type of project for 21
Lotus Client and Web Applications used LEI.
Responsibilities :
Enhancements, Bug fixing etc
Resolving Tickets
Environment : Lotus Notes 5, 6.5, Formula, Lotus Script, Lotus Database,
LEI, Win NT
5. Enhancement and support Client (Accenture Services Pvt. Ltd.)
Client : DIAGEO.USA
Role : Single Member Team
Description : This is an enhancement and support type of project for 21
Lotus Client Applications.
Responsibilities :
Enhancements, Bug fixing etc
. Resolving Tickets
Environment : Lotus Notes 6.5, Formula, Lotus Script, Lotus Database, Win
NT
6. Adrenalin HRMS product. (Adrenalin e-Systems, Polaris Groups of Co.)
Client : Product
Role : Team Member
Description : Adrenalin product is a HRMS Suite that manages the activities
of an employee in the HR Space. It is a complex product
comprising of around 150 Notes Database and a 150 table in an
RDBMS.
Responsibilities :
Involved in understanding the module functionality, the data
structure and the report
requirements,
Report generation using HTML and JavaScript, data is retrieved
from both RDBMS and
Domino.
. Ensuring compatibility of product with various databases like SQL
Server, DB2, Oracle etc.
. Unit Testing.
Environment : Lotus Notes, Dominos, Oracle 8i / DB2 /SQL Server2000,
Windows
7. PCPE Website (Web) (Adrenalin e-Systems, Polaris Groups of Co.)
Client : Univar Pharma, UK
Role : Team Member
Description : This was an online drug store where one can order a sample
drug.
Responsibilities :
. Participated in Web designing, layouts.
. Developed Code using Lotus Script and Formula Language.
. Made new Enhancement according to Change Request.
. Created Test Cases for Unit Testing.
Environment : Lotus Notes, Dominos Database, Windows
8. Customer Interact Management system (CIMS) (Adrenalin e-Systems,
Polaris Groups of Co.)
Client : Royal Sundaram Insurance, India
Role : Team Member
Description : This is a Web based call center application where people
register their query and it is escalating to appropriate group
for the resolution. It's a complicated application where several
scheduled agents working one after another and are linked to
live data. The important and most complicated thing is depending
upon the data going to oracle database where all other non-lotus
notes applications are interacting.
Responsibilities :
. Created Forms, Views, Outlines, Pages and Framesets for User
Interface.
. Developed Code using Lotus Script and Formula Language, XML
. Database designing and development.
. Integrated Lotus system with Oracle.
Environment : Lotus Notes, Dominos, Oracle 8i, Windows
9. Sales Force Automation. (Mainstream technologies India Pvt. Ltd.)
Client : Raychem RPG Ltd. MUMBAI
Role : Team Member
Description : This is a CRM application facilitating easier information
sharing. It also had features like Customized Reports, Label
printing, and online product selling etc.
Responsibilities :
. Database designing and development.
. Testing.
Environment : VB, Oracle
Personal Profile
Gender : Male
Date of Birth :
Nationality : Indian
Marital Status : Married
Languages Known : English, Hindi,Oriya
(SUSANT PATRA)
Contact this candidate