Resume

Sign in

SQL,SQLserver,PL/SQL,MS-Access

Location:
Portland, OR, 97305
Posted:
September 19, 2008

Contact this candidate

Resume:

Jayasheela.Doupati E-mail:*************@*****.***

Phone: 503-***-****

Resume

Title

SQL, PL/SQL, MS-SQLserver developer

Professional Summary

3.5years of experience in design and development of database for web applications, and client server applications using Microsoft Technologies

Excellent Analytical and problem solving skills

Technical Experience Summary

Has 3.5 years programming and enterprise-level application development experience.

Through understanding and experience of designing database tables, stored procedures, functions and triggers in SQL Server 2000. / SQL Server 2005.

Client interaction for requirement gathering finalization of technical and functional specification.

Conversion of business requirement into application logic.

Design, development, testing, troubleshooting and debugging of the application.

Provide post implementation application enhancement maintenance support to the client.

Career Experience Summary

Worked as a Database/Web developer in FSELC as a volunteer in SQL,

T-SQL Technologies from December2007 to April 2008 in Salem, OR USA.

Worked as Software Engineer in LotusDigitech Limited, Hyderabad, India from July 2004 – March 2007.

Technical skills

RDBMS- SQL Server 2000/2005, Oracle9i, 10g, SQL, PL/SQL

Programming languages- ASP.net, JAVA,HTML

Operating systems- Windows 2000 server,Windows XP

Application Packages- MS-Office

Educational Profile

Masters in Computer Applications (M.C.A) from Madras University, India - Apr 2004.

Bachelors in computer Applications (B.C.A) From Nagarjuna University India -Apr 2001

Details of Organizational Experience(s)

As a Database/Web Developer (Volunteer)

FSELC (a non-Profit organization, Salem OR December 2007 to April 2008).

Programmed SQL server 2000 reporting services

Support development of custom product and services.

Uploaded SQL server 2000 reporting services RDL files to SQL server 2000.

Created SQL 2000 stored procedures and triggers.

Worked on SQL queries to pass data

As a Software developer in Lotus digitech ltd from July 2004 to March 2007

Project #1

Project : Computerized Horoscope

Client : Lotus Digitech Limited

Environment : Windows 2000, .NET ASP, SQL Server 2000

Role : Designing, Coding

Duration : 8 months (July2006 to March 2007)

Team size : 7

Description: Computerized horoscope is a comprehensive multilingual package in English, Tamil, Malayalam, Hindi & Telugu, developed with an aim to generate a prediction chart and the horoscope of individual when he/she registers his/her date, time and place & birth. The output indicates planetary position, bhav position, rasi position, saptavarga table, rasi chart, drekkana chart and also daily, monthly, yearly panchangam.

Responsibilities:

· Analyzed business requirement.

· Defined technical details of the solution.

· Developed Horoscope template functionality edit/view/report (ASP.NET, MS SQL, Stored Procedures, CSS, and HTML).

· Implemented making and handling web-page snapshots in “Web archive, single file format:

· Saved images into database and showed images from database on web pages.

. Designed database tables.

. Created stored Procedures / Views / User defined functions

Project #2

Project Name : Purchase Module

Client : Lotus Digitech Limited

Environment : Windows 2000, SQL Server 2000

Role : Designing, Coding and Testing.

Duration : 9 months (October 2005 to June 2006)

Team size : 9

Description: Purchase Module is a web-based application. By using this tool we can raise purchase orders and can track the life cycle of purchase order. At the end of PO module it is linked with stocks and Inventory Module. The basic module in PO is administration like vendor management, products inventory and reports. We can generate PO for the corresponding vendor, products and quantity. Reports module provides list of purchase orders based on the given criteria like pending purchase orders and product movement analysis. After authorizing the products of the corresponding vendor the stock details will be updated in Centralized warehouses. We developed this as an Internet application used HTML for page design, JavaScript for validations. .ASP for server side scripting used SQL Server 2000 for database Storage.

Responsibilities:

· Analyzed business requirement.

· Designing database tables

· Defined technical details of the solution.

· Saved images into database and showed images from database on web pages.

. Created stored Procedures / Views / User defined functions

Project #3

Project Name : Web Enabled Newsreader

Client : Lotus Digitech Limited

Environment : Windows 2000, SQL server 2000

Role : Designing, Coding and Testing.

Duration : 7 months (March to September 2005)

Team size : 7

Description: Web enabled Newsreader is light weight user interface built with HTML and JSP to browse articles in news server (NNTP). The core functionality of this newsreader is to store and maintain 'user profile' and the 'read' status information of articles browsed by the users of the newsreader. Unlike MS Outlook which stores profiles and 'read' status of news articles locally, newsreader stores information in a centralized server. This way the user can access news articles from any system and still can have his profile and 'read' status maintained.

Responsibilities:

· involved in database design.

· writing stored procedures, triggers, views and functions etc.

· Requirement gathering and attending change request.

· monitoring project and implementations.

Project #4

Project Name : Lotus Office Automation Package

Client : Engineering Staff College of India, Gachibowli Hyderabad

Environment : Windows 2000, SQL server 2000

Role : Designing, Coding and Testing.

Duration : 8 months (July2004 to February 2005)

Team size : 8

Description: Engineering Staff College of India (ESCI) is an institute that provides Continuous Education Programs (CEP) in advanced engineering concepts for employees sponsored by their organization. Our project introduces an intranet service to automate all the activities with in ESCI like enrolling a new candidate, course, faculty and trading information and also provides mailing service to the registered users.

Responsibilities:

· Requirement gathering

· Involved in database design.

· writing stored procedures, triggers, views and functions etc.

Project #5 (Academic Project)

Project : E-Tendering

Client : ITI Limited, Bangalore

Environment : Windows 2000, ASP, Microsoft IIS Web Server, Oracle

Role : Coding and Testing.

Duration : 4 months (December 2003 to March 2004)

Team size : 12

Description: Existing system for tendering system is manual (paper based). Tenders will be published through newspapers and perspective bidders will submit the filled up tenders document manually. In this project a complete E-Tendering system is developed for carrying out all the required activities: Publishing the tenders, email notifications, bid submission, bid opening, publishing the bid results, electronic signing of documents and registration of tenders and bidders.

Responsibilities:

· Involved in development of application.

· Involved in database design.

· Saved images into database and showed images from database on web pages.

. Designed database tables.

Employer Details:

Current Employer : http://www.symbiountech.com/

Visa Status : H1-B

Validity : October 2008 to September 2011.



Contact this candidate