DEEPTI GUPTA

Strongsville, OH ***** acd4jl@r.postjobfree.com 562-230-

8582(Cell)

Career Summary

. A total of 11 years of diversified IT experience in developing and

testing windows, web based and database applications.

. 5 years of experience in software quality control, primarily in

Automation Testing (using FitNesse (webServices Testing), QTP 10.0 &

11.0)

. 6+ years of experience in software design and development of Windows and

Web based application using Microsoft tools and technologies such as

C#.Net, ASP.NET, ADO.NET and SQL Server.

. 6+ years of experience in handling Databases Such as SQL Server, PL/SQL,

My-SQL, Oracle Forms and MS-Access. Involved in creating Databases,

Joins, Stored Procedures, Views and Triggers.

. Experience in the following aspects of testing life cycle - Requirement

gathering, Risk Analysis, Test Planning, Test Case Design, Test

Environment Setup, Test Data Setup, Test Execution, Reporting, Defect

Management and Test Closure.

. Experience in different levels of testing, namely Component/Unit,

Integration, System, Acceptance Testing.

. Hands on experience in White Box Testing Method.

. Knowledge of Sharepoint 2010 and Infopath.

. Involved in the following stages of Software Development Life Cycle

(SDLC): requirement analysis, design, implementation, integration and

testing, deployment and maintenance.

. Experience in Waterfall and Agile software development process using

Scrum.

. Working knowledge of Share Point Portal Server 2003.

. Good analytical and problem solving skills with ability to work

independently.

. Good interpersonal and learning skills matched with the ability to manage

time and people effectively.

Technical Skills

Testing Tool : QTP 10.0 & 11.0, FitNesse

Defect Management : Quality Center, QC Explorer

.NET Technologies : ASP.NET, C#.NET, VB.NET, ADO.NET

Programming Languages : C, C++, VB, PL/SQL.

RDBMS : MS- SQL Server, Oracle, MS-Access

Scripting Language : Java Script, VBScript

IDE : MS Visual Studio.Net

ETL Tools : Informatica Power Center 7.1

Web Technologies : HTML, XML, Java Script, VB Script, and ASP.

Operating Systems : MS-DOS, Windows 2k/2003/XP/7, Mac OS X.

Certifications/ Programs Attended

. MCP in C#.Net

. Informatica Power Center 7.1 Training.

. Business Intelligence/Data Warehouse (UC Irvine - Extension)

Education

. Bachelor of Science in Computer Application, M. J. P. Rohilkhand

University, India.

. Diploma in Advanced Computing, C-DAC, India.

Professional Experience

Client:Progressive

Role: IT System Test engineer Sr.

Project: Tool Simplification Nov'

12- Feb'14

Progressive's current technology environment contains many out-of-date,

unsupported and redundant software. This complexity hinders company's speed

to market and quality, while increasing risk and cost. To resolve this

issue company launched Tool Simplification Program which brings core

technology up-to-date and enables faster access to new technologies and

features. This help business partners deliver innovations faster, with

quality at a lower cost

Involved with the following waves:

- Policy for Commercial Auto (PCA) - This wave had 25 Web Services and 5

batch files.

- FAO-COI (Certificate of Insurance) - This wave covered complete COI

flow from FAO(For Agent Only application)

- Enterprise Management Organization (EPMO) - This wave covered all web

application which is used by managers to check projects status,

allocation, and assigning to employee. Applications like DQAudit,

HRFeed, EPMOMetadataManager, WFMAllocations, ChargeBackWizard,

JNBridgePro.

- External Data (Vin Services) - It covered all VIN related Web Services

and batch files.

- Policy Servicing (Online services) - This project covered all

application which company use to handle different types of policies

quoting, creation, modification, updates (paperless, billing methods

etc). Application like progressive.com, SBR.Net, FAO, PolicyPro etc.

Responsibilities:

. Involved in project kick-off and planning meetings.

. Designed test plan, test strategy, test cases for the new enhancements

using the Requirement Specification Document.

. Directly interacted with client (Platform team) to understand business

and requirements.

. Designed QTP scripts.

. Created FitNesse test to test Web Services.

. Executed test cases.

. Defect management using HP Quality Center and QC explorer

. Involved in browser compatibility testing - IE 6, IE 8 and IE 9

. Participated in status and review meetings.

Environment:

QTP, QC, FitNesse, TeaLeaf, TFS and Visual Studio 2010.

Client: Herbalife, Torrance, CA

Project: OnLine Contract (OLC)

Role: QA Analyst Aug' 11 -

Sept' 12

Herbalife is a global nutrition company that has helped people pursue a

healthy and active life since 1980. They are specialized in nutrition,

weight management and personal care products. These products are available

through independent distributors in more than 75 countries.

OLC (OnLine Contract): This application is used to register distributor in

online system and database. It is a 3 tier application. In front tier

application has separate asp.net page for separate countries. The middle

tier has .Net web services to manage and transfer data to the end tier -

database - Oracle.

Responsibilities:

. Involved in test case design and execution for the new enhancements using

the Requirement Specification Document.

. Tracking and reporting defects using HP Quality Center.

. Running functional and regression tests.

. Involved in multi browser testing.

. Involved in testing data retrieval and storage functionality using SQL

Server and Oracle.

. Used Oracle Forms to create and modify Distributor and Product Order.

. Participated in status and review meetings.

Environment:

Quality Center 10.0, SQL Server, Oracle, Web Services, XML, PL/SQL

Client: The Capital Group Companies, Los Angeles, CA

Project: Capital Investment Calendar (CIC), Capital Research (cResearch),

Portfolio

Review System (PRS)

Role: Quality Management Engineer Aug' 10 -

Jul' 11

The Capital Group Companies is a group of investment management companies

that has earned the respect of millions of investors worldwide. Their

success comes from making every decision with the investor in mind.

CIC (Capital Investment Calendar): This is a Calendar application used for

planning and sharing meeting and conference information among Investment

professionals across the globe.

Cresearch (Capital Research): This application is used by Investment

Analysts to share their research about market. This application also

provides the functionality to comment on the shared research, upload and

download supporting documents.

Portfolio Review System (PRS): This application is used by analyst to look

into investment information of other analyst. This application help them to

make decisions.

Automation Console Tool:

This tool is used to test the quality of a group of applications. It

provides a common interface for QC, QTP and Test Environment.

Responsibilities:

. Responsible for writing/modifying functions in the Automation

Framework as per new/

. Modified features using VBScript.

. Responsible for adding new/modified objects in XML files.

. Responsible for executing test suits for Application.

. Tracking and reporting defects using HP Quality Center.

. Developed automation script using QTP 10.0.

. Running functional and regression tests.

. Involved in testing data retrieval and storage functionality using

Sybase and Oracle as part of leads testing.

. Maintaining automation testing environment.

. Writing queries in scripts to do database check.

. Responsible for modifying Test Console as per requirement using

C#.Net.

. Participated in scrum meetings.

. Used Perforce for version control.

Environment:

Windows XP, Quality Center 10.0, QTP 10.0, VBScript, Sybase, Oracle, C#.Net, XML, PL/SQL,

Perforce.

Client: The Designory Inc, Long Beach, CA

Project: nissanusa.com and infinitiusa.com

Role: Test Engineer Mar'

09 - Jul' 10

As an Interactive Agency of Record for NNA, TDI is responsible for the

development and maintenance of nissanusa.com and infinitiusa.com websites

to have the latest product information available to users and

simultaneously enhance and strive for a great end- user experience.

The nissanusa.com and infinitiusa.com websites undergo periodic changes to

reflect the latest product information of existing and new vehicle models

and also upcoming news and events. There are periodic redesigns for various

functional areas and enhancements based on user behavior data. TDI is

responsible for the creative, production and technical implementation of

these changes. An agreed upon set of changes are developed and tested on a

weekly basis.

Responsibilities:

. Involved in test case design and execution for the new enhancements using

the Requirement Specification Document.

. Tracking and reporting defects using HP Quality Center.

. Developed automation script using QTP 10.0.

. Running functional and regression tests.

. Involved in BI tags and SEO testing

. Involved in multi browser testing.

. Involved in testing data retrieval and storage functionality using SQL

Server as part of leads testing.

. Participated in project kick off and review meetings.

Environment:

Windows XP, Mac OS X, Quality Center 9.2, QTP 10.0, SQL SERVER 2005,

PL/SQL.

Client: SumTotal Systems, Mountain View, CA

Project: PSE Dashboard, HR Recruitment Process Tracker

Role: Sr. Application Designer and Developer Jan' 08

- Feb' 09

PSE Dashboard: It is a web based interactive application which is developed

to automate the Professional service engineering team dashboard. This

application is used to keep track on the progress of projects from the

start when any project comes to company, till project ends. It also

generates reports like On-going projects, completed projects, total hours

spend by any/all resource, revenue generated, resources booking etc. And

those report company used to make decision like project was over budget or

within budget, resources are working in estimated time or not and who is

booked for which project and for how many hours etc.

HR Recruitment Process Tracker: It is a web based interactive application

which is developed to automate the HR Recruitment tracker. This application

is used to keep track of the process of recruitment from the start when any

CV comes to the company recruiter, till the rejection or conversion in

employee. This application keeps track of all the stages like sourcing, HR

screening, tech screening, interviews, offer made, offer accepted, notice

period. On the bases of this data which is entered by recruiter,

application generate reports like recruiter wise pipeline report, pending

report, turn around time report, aging report, recruiter wise matrix.

Responsibilities:

. Developed User Interfaces, Middle tier business Objects.(

. Developed Web forms using ASP.NET, C#, HTML, CSS, Server Controls.

. Used validation controls like required, regular, range and Custom

validation for front end validations.

. Handled 2 databases simultaneously and maintained DataSet Relations using

ADO.NET.

. Used ADO.NET and data objects such as Data Adapter, Data Reader, Data

Set and Data Table for consistent access to SQL Server data sources.

. Written Stored Procedures and View to access data from main database and

store in local database.

. Written database logic to insert, update and delete data from

database.

. Written code to access data from main and psedashboard databases,

compared that data and updated data in psedashboard with main database.

. Data Grid Controls was used in displaying rows of data in a customized

template format to generate reports.

. Used IO registry to export the report in excel.

. Involve in unit and peer testing.

Environment : Window 2000, ASP.NET, C#.NET, ADO.NET, Visual Studio 2005,

HTML, DHTML, AJAX, CSS, Java Script, SQL SERVER 2005, PL/SQL, IIS 6.0.

Client: SumTotal Systems, Mountain View, CA

Project: New Custom Reports in Change Point

Role: Sr .Net Developer Jan'

07- Dec' 07

Changepoint facilitates the management of end-to-end business processes,

from capturing all demand for services and prioritizing portfolios to

continuous monitoring of project and application health.

In custom reports we have generally 3 level reports. In 1st Level we accept

inputs from user like Billing Office, Engagement names, quarter/date range,

completed/Active projects etc. On the basis of given input we generate 2nd

level of report. Which could be a drop down report or Sortable table report

with that we provide links on data to see details.

Responsibilities:

. Involved in design and developing Web Forms using ASP.NET and C#.NET.

. Data Binding was extensively used to bind various server controls to the

data from database. List controls like Repeater Controls, Data List

Controls and Data Grid Controls was used in displaying rows of data in a

customized template format.

. Used session objects and cookies to security and password authentication.

. Involved in the design of security module that authorizes users based on

the roles.

. Business Logic is written in C#.NET.

. Used Data Grids, Data Sets, Data Views, Data Adapters to extract data

from the backend.

. Implemented client side and server side validations using Java Script &

ASP.NET validation controls.

. Used Cascading style sheets (CSS) to attain uniformity through all pages.

. Wrote SQL Queries and Stored Procedures using various JOIN, Group By and

Order By clauses and aggregate functions.

. Written Stored Procedure to fetch data from database.

. Used IO registry to export the report in excel.

. Involve in unit testing.

Environment : Window2000, ASP.NET, C#.NET,ADO.NET, SQL SERVER 2000, PL/SQL,

CSS, Java Script, IIS 6.0, HTML, DHTML.

Client: Amway Global, Ada, MI

Project: Customization in SumTotal 7x (Learning Management System)

Role: Designer and .Net Developer July'

06 - Dec' 06

To provide e-training to their employees Amway Global uses an Enterprise

Suite, this combines Learning Management System (LMS), Learning Content

Management System (LCMS) and Virtual Classroom Service (VCS) on a single,

integrated platform.

The Purpose of project is to customize the product according to Amway

Global requirements.

Responsibilities:

. Involve in gathering requirement from customer.

. Customized the product according to Customer Requirement. Like UI changes

and changes in conditions on the basis of that product displays data.

. Modified Web form using ASP and HTML.

. Used Cascading style sheets (CSS) to attain uniformity through all pages.

. Worked in an n-tier application.

. Java Script was used for client-side user input validations

. Developed new features as per customer requirements.

. Written Code to generate UI, wrote Stored Procedure using temporary

tables and cursors and Triggers.

. Development of ADO objects to manipulate the database.

. Involve in unit testing.

Environment: ASP, SQL SERVER 2000, ADO, HTML, Microsoft Visual Interdev

6.0, Java Script, VBScript, and HTML

Client: India Insure Risk Management Services Pvt.Ltd., Hyderabad, India

Project: Development and maintenance www.indiainsure.com

Role: Designer and .Net Developer Mar'

05-Jun' 06

The aim of the site is to provide web enabled client wise risk coverage by

insurer, active policies details with renewal dates and risk coverage

details with client's portfolio, Employee Login and HR Login etc. According

to login person's role site provides different interfaces. As HR can view

all employee's information one can add/delete/modify employee information.

An employee can not only see his dependent's information but also

add/delete/modify dependent's information and can send email notification

for claims to Client Relation Manger from web site.

Responsibilities:

. Involve in designing and development of web pages using ASP.NET and

C#.NET.

. Extensively used ADO.NET and data objects such as Data Adapter, Data

Reader, Data Set and Data Table for consistent access to SQL Server

data sources.

. Written code to provide security and Authentication on session level.

. This system assigns company authentications and authorizations and

allows company administrators to manage content security, for specific

user groups.

. System is capable of providing content management restricting users

through a complex authentication and authorization.

. Written conditional based queries, Stored Procedure using temporary

tables and cursors and Triggers.

. Wrote code for Validations using Java Script and Validation Controls

of ASP.NET.

. Involve in unit and peer testing.

Environment: ASP.Net, C#.Net, ADO.Net, HTML, DHTML, IIS 6.0, SQL SERVER

2000, web services

Client: Synfosys Business Solutions, Hyderabad, India

Project: Report Engine for www.reachonline.com

Role: Web Developer Nov' 03

- Feb' 05

The aim of the project is to change the existing report generation module

of the client to ASP.Net and C#. This involves UI improvement of the ASP

pages, Preparation of report engine, Preparation of reports and improving

the reports.

There were 12 reports to be implemented, which are classified, in different

categories. This uses ADO.NET and .Net component classes to access the

database

Responsibilities:

. Responsible for business analysis, system/functional specifications,

requirement and feasibility analysis. Understanding the business

requirements and leverage the technology to meet business requirements

and goals.

. Design application flow using UML Diagrams.

. Developed pages using ASP.NET and C#.NET.

. Migrated some components from classic ASP to ASP.NET

. Used Data Binding and Repeaters Control to display the reports.

. Wrote condition based stored procedures, views using SQL Server 2000.

. Involved in installing and configuring IIS 5.0

. Involve in unit testing.

Environment: ASP.Net, C#.Net, ADO.Net, SQL SERVER 2000, IIS 5.0, Java

Script, VB script, Web Services.

Client: Synfosys Business Solutions, Hyderabad, India

Project: Component writing for Mail Server

Role: Web Developer Aug' 02- Oct' 03

www.enamaskar.com is a mail server like yahoo or rediffmail. The purpose of

site is sending/receiving mail with attachments, reply, forwarding mails,

maintain address book, calendar etc.

The main objective of the project is to change the existing site on new

platform. This involves CDO 2000 for components to access the information

from Exchange Server.

Responsibilities:

. Developed Components for Inbox, Send Mail, Receiving Mails, Reply,

Forward and Attachments etc using CDO 2000.

. Designed Static Web pages using HTML.

. Designed Dynamic Web pages using DHTML.

. Wrote code for Validations using JavaScript.

. Wrote user manual for the system.

. Performed maintenance and enhancements on the product.

. Developed ASP pages and used Session objects to personalize the system.

. Involve in unit testing.

Environment: VB 6.0, Exchange Server, ASP, HTML, CDO 2000.

Contact this candidate