Sql Server Project

Ranjeet Kaur

( Email : *************@*****.***

Objective

Aspiring to achieve a challenging, dynamic and responsible position that

will both utilize and strengthen the skills acquired during my software

development experience.

Work Experience

Having over 5 years of experience in Web Application Development on

Microsoft DOTNET Platform, Oracle and shell scripting.

Profile Summary

. Currently working with Infosys Technologies as Senior System Engineer.

. Microsoft 70-562 .NET Framework 3.5 - ASP.NET Application Development -

C# certified.

. I have worked with Larsen & Toubro Pvt. Limited as a senior software

engineer, prior to that I worked with LBP Pvt Ltd as web application

developer.

. Good analytical skills and ability to learn new skills quickly.

. Effective in working independently as well as collaboratively in teams.

. Domain Expertise on Pharmaceuticals, Electrical Engineering and HR set of

applications.

Education

. B.Tech from S.C.R.I.E.T, Meerut with 74% in Year 2007.

Skill Set

Hardware Platforms Pentium Based PC's

Environments worked on Windows NT/2000/XP

Development Tools / SharePoint 2007, ASP.Net 3.5,ASP.Net 1.1,

Languages VB.Net,C#, Visual Studio.Net 2008/2003.

Middleware / Databases Oracle 9i,SQL Server 2005,MS IIS 6.0

Mark Up Technology XML, HTML 5, JQuery, JavaScript, CSS

Infosys Projects

Project Name : Medical Information Site

Environment : SharePoint 2007, Orchestration Framework, SQL Server

2005, JQuery, Html 5.

Description : This site is a global function that informs healthcare

decision-making by providing trusted clinical and scientific information on

client's products to healthcare professionals and patients.

Responsibilities :

. Involved in complete SDLC of the application.

. Worked on Site Analytical tool for tracking and monitoring site

traffic.

. Coordinated with other teams for deployment of the application on Test

and Production Server.

. Prepared Requirement, Design, Test scripts documents.

Project Name : CARS/IS-MBR Enhancement

Environment : SQL Server 2005, VS .NET 2008, ASP.Net 3.5, C#, ADO.Net,

IIS 6.0.

Description : CARS/IS (Contract Administration and Reporting System)

is a contract and membership management application to manage Guaranteed

Price type contracts.

Responsibilities :

. Worked on developing audit report on Business Object.

. Created views in oracle.

. Was a part of CARSIS support team and was responsible for trouble

shooting and debugging minor program bugs.

Project Name : Ideal ECP Coverage GAP Enhancement

Environment : SQL Server 2005, VS .NET 2008, ASP.Net 3.5, C#, ADO.Net,

IIS 6.0.

Description : Ideal ECP (Ideal Electronic Claims Pre-Processing

System) is used to scrub claims before processing it for managed care

rebates. This application provides a multitude of user interactive

functionality for analyzing and scrubbing submissions and finally uploading

it into MCC.

Responsibilities :

. Developed shell scripts for loading data into database and generated

the TPA file in required format.

. Worked on database design.

. Prepared Stored Procedure and cursors.

. Coordinated with other teams for deployment of the application on Test

and Stage Server.

. Prepared Requirement, Design, Test scripts documents.

Project Name : MCC SFTP Enhancement

Environment : SQL Server 2005, VS .NET 2008, ASP.Net 3.5, C#, ADO.Net,

IIS 6.0.

Description : MCC application is primarily used to calculate rebate

payments due to managed care organizations. The other features available in

the application include setting up of contracts, receiving submission data,

verifying formulary information, and generating check request.

Responsibilities :

. Prepared POC for SFTP changes in the shell script.

. Created Public/Private key using UNIX.

. Prepared Requirement, Design, Test scripts documents.

. Part of MCC support team and responsible for trouble shooting and

debugging minor program bugs.

Previous Project Experience

Project Name : SEED (System for Electrical Engineering Design)

Company Name : L&T (Larsen & Toubro) Pvt. Limited.

Duration : Dec 2008 - Till date

Environment : SQL Server 2005, VS .NET 2008, ASP.Net 3.5, C#, ADO.Net,

IIS 6.0.

Description :

1) SEED is developed as a tool to calculate the sizes, schedules and

distribution of Cable, Tray, Drums, Electrical load etc. The system

uses fixed calculation formulas and based on user inputs suggests

the result values and prepares the lists of data as required.

2) During the design as well as verification stages this increases the

speed of calculation as well as eliminates the possible error

inherent in manual calculation processes.

3) Increased accuracy as well as shorter design / verification time

resulting in departmental efficiency.

Responsibilities :

. Taken leadership role on Client and user interaction with the

objective of gather and analyze requirement, knowledge acquisition,

development of test cases and problem reproduction.

. Extensively used GridViews sorting and paging.

. Implemented Template Columns for Custom Nested GridViews.

. Worked on exporting reports to Excel from Gridviews.

. Deployment of Application on Test and Production Server.

. Prepared Technical and User documentation.

. Ensured functionalities that guaranteed database integrity while

maintaining application performance efficiency.

Project Name : PAL (Present Absent Leave)

Company Name : L&T (Larsen & Toubro) Pvt. Limited.

Duration : March 2008 - Dec-2009

Environment : Oracle 9i, VS .NET 2003, ASP.Net 1.1, C#, ADO.Net, IIS

Description :

1) PAL is a software application that provides timely Management

information on the effects of absenteeism in the workplace. Features

include highly configurable timesheet and expense reporting.

2) Leave Management module provides the organization the approval process

of leave request.

3) Leave profile is maintained which is customizable as per the

organization requirements which keeps the records of the entire leave

policy of the organization.

4) It uses a defined workflow that begins with the user filling in the

information and submits the application and goes through the defined

approval hierarchy. It includes the facility to accept / cancel the

leaves by the approvers and will detail the reason for the same. It

ends with the information reaching the HR helpdesk to further

processes the leaves and updates the leave records. Similarly a user

can also request for cancellation /extension / of a processed record.

At each stage the user will be notified via email. The facility is

provided to export the information to payroll application.

Responsibilities :

. Client interaction in various phases; Requirement gathering,

clarification, knowledge acquisition, test results and problem

reproduction.

. Wrote stored procedures and triggers using SQL in Oracle 9i.

. Developed Cascading Style Sheets (CSS) for User Interface uniformity

throughout the application.

. Extensively used GridViews with sorting and paging.

. Implemented Template Columns for Custom Nested GridViews.

. Developed User Documents for the users.

. Provided Post-Release support.

Project Name : TMS (Time Sheet Management System)

Company Name : LnT (Larsen & Toubro) Pvt. Limited.

Duration : March 2008 - Dec-2009

Environment : Oracle 9i, VS .NET 2003, ASP.Net 1.1, C#, ADO.Net, IIS

Description :

1) TMS is an advanced system designed for the engineering and

construction environment to manage the booking, record keeping and

calculation of expenditure of efforts in terms of person-hours.

2) It is used to manage hours spent against budget in terms of

deliverables.

3) Web base timesheets makes tracking time and managing projects easier

for individual employees. It helps employees with a time tracking

solution that makes entering time easy to promote is as a part of

their every day routine.

4) Through an easy to use dashboard and reports it provides the managers

and admin the visibility into the activities of their employees and an

understanding of where they stand with their projects and project's

budgets. It gives the executives accurate cost, billing and

profitability information so they can evaluate their company's

performance while looking ahead in the future.

5) The "TMS Report" module gives the power to plot the relationship

between all the system data such as clients, projects groups and users

and their relationship.

6) Through TMS reports organization can plan to utilize the work force

effectively, and aims to know the usage level quantitatively.

Responsibilities :

. Responsible for developing the logical middle tier and database

designing.

. Responsible for User Interface Design and developing Web Forms using

C# and ASP.NET

. Development of the reports section

. Framework for generating analyzed and customizable Reports based on

user selected parameters

. Tested and deployed the application with zero-bug reported by client.

Project Name : Traine-e

Company Name : LBP.

Duration : Jul 2007 - Feb-2008

Environment : Oracle 9i, VS .NET 2003, ASP.Net 1.1, VB, ADO.Net, IIS

6.0.

Description :

A System for the audience being "HR & Training" department and HODs. The

new training modules would be uploaded by Training Dept., can be seen by

HODs and has the facility to nominate their team members for different

trainings as per business needs. This application has 3 major modules:

. Add training

. Booking Module

. Reporting Module

Responsibilities :

. Software Trainee.

. Development and implementation of User Interface.

Personal Details

Name Ranjeet Kaur

E-mail *************@*****.***

Date of Birth 09th Jul 1986

References

Will be furnished upon request.

Contact this candidate