Developer .Net Project Sql Server Sales Business

Resume of Yasoda Namala

******.******@*****.***

Phone: 216-***-****

SUMMARY

. Post-Graduate in Computer Applications with over 6+ years of

experience in software development and systems integration using

Microsoft technologies.

. Extensive experience in C#, VB.NET, ASP.NET, VB, ASP, VBScript,

JavaScript, AJAX, JSON, jQuery, SQL Server, Oracle, ADO, ADO.NET,

PL/SQL, XML and Web Services.

. Highly Proficient in Object Oriented Programming techniques.

. Involved extensively in analysis, design, coding, integration testing

and support of various business applications

. Extensive experience in design & development of various Web-Forms

using ASP.NET & HTML for the User Interface Presentation layer of

various applications.

. Experience in developing and consuming XML Web-Services.

. Extensive Experience in Database Programming using MS SQL Server 2000

and

MS Access and good experience in T-SQL, PL/SQL, Triggers, Views and

Stored Procedures.

. Participation in Microsoft Technical Education Program for visual

studio 2005 and SQL Server 2005.

. Worked with Waterfall Methodology and Agile Methodology(Extreme

Programming).

. Extensively used NUnit for Test Driven Development approach.

. Team player with excellent communicational, interpersonal, analytical

and problem solving skill

TECHNICAL SKILLS

Operating Systems Windows XP, Windows 2000

Programming Languages C#

Web Development HTML, JavaScript, CSS, XSL,

XHTML, ASP.NET

Databases (RDBMS) SQL Server 2000-2005

Development Tools MS Visio, Visual Basic

6.0/5.0, Visual Studio.NET

2003,2005,2008, Web-Services,

SQL Server Enterprise, Biz

Talk Server, Manager, SQL

Server Query Analyzer

Testing Tools NUnit

Software Development Methodologies Extreme Programming (Agile)

EDUCATIONAL QUALIFICATION

Master of Computer Applications

Bharathidasan University, India

Bachelor of Commerce

Andhra University, India

PROFESSIONAL CERTIFICATIONS

Certified ASP Developer

W3 Schools

PROJECTS SUMMARY

1. Samsung Training web site - 02/2010 to 10/2010

Role Developer

Location Dallas, TX

Environment Software .NET 3.5 (Visual Studio .NET 2008), Windows Xp

Technologies Used: C#, ASP.NET 2.0,3.5 ADO.NET,

Oracle 10, PL/SQL stored procedures,

HTML, jQuery, JSON, JavaScript, CSS, XML, XHTML

Project Description

Samsung offers training to cell phone carriers and vendors in the US and

Canada through their training web site. Samsung updates their training web

site whenever they release new phone models.

The training web site features informative and context based dynamic

content specific to phone model. Target users of this web site are mainly

sales and marketing associates of cell phone carriers and authorized

vendors. Target users must complete certification for each new phone

before it's launched into the market so they are very well prepared to

market the phone.

The training web site features XHTML and CSS based layout. The training

web site offers multi-browser support for all popular browsers such as

Internet Explorer, FireFox, Safari etc. CSS classes are used to separate

presentation from the content. Separate CSS classes are used to achieve

consistent look for different browsers. Also separate CSS class was used

for printing.

The training web site features multilingual support through backend

databases. To support this feature, content is stored and retrieved from

the backend databases dynamically based on the language selection. User

preferences such as language, avatar etc are remembered through user

preferences table in the backend databases.

The training web site leverages caching for static content such as

graphics, videos, page titles, control labels etc for faster performance

and to minimize network traffic.

The training web site leverages JSON for sending data to the client in a

lightweight manner. This improves performance and minimizes network

traffic.

The training web site features dynamic flash banners based on phone

selection. Flash banners are dynamically loaded using JavaScript and

JQuery. System automatically checks to see required flash plug-in is

installed on the client computer and renders "download plug-in" links

accordingly.

The training web site feature rich HD quality videos which are rendered

using flash plug-in. Videos are loaded dynamically based on phone

selection. Video information is stored in the tables in the backend

database.

The training web site uses Oracle database. All data is stored in tables.

Stored procedures and packages are used to read or update data. Data

objects were created in .NET to invoke stored procedures and retrieve data

from the Oracle backend. No direct SQL statements were used anywhere in

the code to avoid potential security SQL injection attacks.

All user input was validated to make sure that inputs are valid and avoid

security attacks. Regular expressions were used to validate inputs such as

zip code, phone numbers etc.

The training web site features interactive quiz and certification. Each

phone has about 10 to 15 questions. User must answer 60% of question to

complete certification.

Responsibilities:

. Analyzed requirements given by the business analysts.

. Assisted in data modeling by designing tables and stored procedure

required.

. Created tables and developed PL/SQL stored procedures.

. Unit tested PL/SQL stored procedures.

. Created new web forms / ASPX pages.

. Applied style attributes using CSS.

. Created client side functions using Java Script, jQuery.

. Created server side classes using C#.

. Created server side page handlers using C#.

. Elevated code changes to Dev and QA.

. Provided support for QA testing.

. Fixed bugs opened by the QA testers.

. Elevated code to Production.

2. Petro Passport Kiosk Application - 10/2007 to 11/2009

Role Developer

Location TravelCenters of America, West Lake, Ohio

Environment Software .NET 2.0 (Visual Studio .NET 2005), .NET 3.5

(Visual Studio .NET 2008), Windows Xp

Technologies Used: C#, ASP.NET 2.0,3.5 ADO.NET,

Oracle 10, PL/SQL stored procedures,

HTML, JavaScript, CSS, XML, Microsoft Visio

2007, nUnit

Project Description

TravelCenters of America has around 200 travel centers across US and

Canada. Travel centers offer gas and convenient stores to truck, RV, bus

and car drivers/passengers. TravelCenters offer rewards to drivers through

RoadKing club (RKC) and Petro Passport programs. Petro Passport club

provides self-service kiosks to Petro Passport members at Petro Passport

travel centers.

Purpose of this project is to develop a kiosk system which is windows based

application that interacts with the backend databases using web services.

Petro Passport program card holders can access their account using their

card and can perform the following functions. User may need to swipe

his/her card to access some features.

Responsibilities:

. Check locations of other Petro Passport locations across US and

Canada.

. Access user account and update address.

. Upgrade to Platinum membership tier if eligible.

. Check points/rewards/showers available for redemption.

. Transaction Details

. Redeem points/rewards/showers.

. Surveys

Per Business requirements, some content management of Petro Kiosk systems

changes from time to time. Business requested a Content Management

solution to manage the following content types by page: Text, Images, and

Banners

Each content item has effective and expiry date times. The system renders

content dynamically based on the effective date time and content type.

This Content Management system was developed in C# and ASP.NET using Visual

Studio 2008. For faster performance, Content was cached in memory. Cache

can be cleared via an Admin page. For administration of Content

Management, a web based front end utility was also developed.

Responsibilities:

. Check locations of other Petro Passport locations across US and

Canada.

. Access user account and update address.

. Upgrade to Platinum membership tier if eligible.

. Check points/rewards/showers available for redemption.

. Redeem points/rewards/showers.

Contribution

. Analyzed requirements given by the business analysts.

. Assisted in data modeling by designing tables and stored procedure

required.

. Created entity relationship diagrams in Microsoft Visio.

. Created system design documents using Microsoft Visio.

. Created detailed design documents using Microsoft Visio.

. Created tables and developed PL/SQL stored procedures.

. Unit tested PL/SQL stored procedures.

. Created new web forms / ASPX pages.

. Applied style attributes using CSS.

. Created client side functions using Java Script.

. Created server side classes using C#.

. Created server side page handlers using C#.

. Created data access using ADO.net.

. Elevated code changes to Dev and QA.

. Provided support for QA testing.

. Fixed bugs opened by the QA testers.

. Elevated code to Production

3. Impact Enhancements - 07/2006 to 06/2007

Role Developer

Location National City Bank, Strongsville, Ohio

Environment Software .NET 2.0 (Visual Studio .NET 2005), Windows Xp

Technologies Used: C#, ASP.NET 2.0, SQL Server

2005, SQL stored procedures,

HTML, JavaScript, CSS, XML, Microsoft Visio 2003

Project Description

Impact is a web based banking application, originally developed for .NET

1.1. It was developed to automate manual tasks performed by Impact

officers, who work with clients of National City Bank.

Impact enhancements was developed for .NET 2.0. In this project, many new

features have been added.

Contribution

. Analyzed requirements given by the business analysts.

. Assisted in data modeling by designing tables and stored procedure

required.

. Created entity relationship diagrams in Microsoft Visio.

. Created tables and developed SQL stored procedures.

. Unit tested SQL stored procedures.

. Created new web forms / ASPX pages.

. Applied style attributes using CSS.

. Created client side functions using Java Script.

. Created server side classes using C#.

. Created server side page handlers using C#.

. Created data access using ADO.net.

. Unit tested classes using nUnit.

. Elevated code changes to Dev and QA.

. Provided support for QA testing.

. Fixed bugs opened by the QA testers.

4. Louisiana Health Insurance Premium Payment 01/2006 to

07/2006

Role Programmer/Analyst

Location Baton Rogue, LA

Environment Software Languages : C#, ASP.Net, HTML, Visual Basic .Net

JavaScript

Database : SQL Server 2000, ADO.NET

Tools: Visual Studio .NET, Visual Source Safe,

Biztalk Server 2000

O/S : Windows XP Professional

Project Description

The Louisiana Health Insurance Premium Payment (LaHIPP) program is a

Medicaid program that pays the employee's (policy holder's) share of the

premium for their group health insurance program based on eligibility. The

LaHIPP policy holder or someone in their family must be Medicaid-eligible

and enrolled in Employer Sponsored Insurance (ESI) to receive LaHIPP

benefits. LaHIPP Specialists who administer the program are responsible

for evaluating the cost-effectiveness of the potential policy holder and

determining whether or not it is financially beneficial to the state to

reimburse the insurance premium to the policy holder. The system that

currently administers the program is a 10-year old PC-DOS based system that

does not automatically interface with other systems within DHH. Thus, there

is a significant amount of data re-entry and manual work.

Contribution

. Gathered the business requirements by interviewing the clients.

. Created the system requirements which include both functional and non-

functional requirements.

. Identified the classes and created the sequence diagrams using UML and

Microsoft Visio.

. Designed HTML pages of the application

. Developed the classes using C# and tested them using NUnit.

. Worked with Database Analyst on the data modeling.

. Created stored procedures and triggers using Transact SQL for

implementing business logic

. Used SQL Server system stored procedures and triggers for sending email.

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

. Design and developed web forms based on the mockups created by the Web

Experience team.

. Used Biztalk Server for integrating web application with Peoplesoft

system.

. Developed XML Web Services that communicate with other systems.

5. Status Monitoring System, Chicago, IL

03/2005 to 12/2005

Role Developer

Environment Software Visual Basic 6.0, ADO, Oracle8i, ASP, VBScript,

Data models, SDLC JavaScript, IIS, Visual

Interdev, XML

Description

This system runs on the Intranet. This was developed to enable the user to

schedule his/her daily activities, time spent on a project. The System

administrator is only allowed to add, remove users and projects. Users can

change their profile like project, password. It also makes a log of all his

activities .The client state is maintained using Session of ASP. The System

allows associating the coordinator for the project. The coordinator is only

allowed to create, update, revise the project statements. It also allows

viewing the latest project statement.

Contribution

. Analyzed system requirements and Proposed comprehensive Application

Architecture

. Developed UI logic includes Authentication, browsing screens etc

using ASP

. Developed Client State maintenance using session objects of ASP.

. Involved in coding create, insert, update and select statements for

various operations on the database tables using PL/SQL.

. Developed COM Components for embedding the XML code and style sheets

according to the type of user request and Used Java script for client

side validations.

. Developed XML documents, which were used as input for ASP.

. Developed data Components for database connectivity.

. Used VBScript for server side validation and JavaScript for client

side validation

6. PlanAgrow - Web-based Sales System for Seed Dealers

04/2004 to 12/2004

Location Chennai, India

Role Web Developer

Environment Software Languages : Visual Basic 6, ASP, HTML,

JavaScript

Database : SQL Server

Tools: Visual Interdev, Visual Source Safe

O/s : Windows 2000

Project Description

"PlanAgrow" is a web-based sales system for seed dealers. This application

was developed using Active Server Pages and Visual Interdev. The purpose of

the application was to provide web-based interface for the seed dealers to

purchase seeds from the client. Seed dealers can log into the application

using login and password provided by the customer service and place orders

for various kinds of seeds sold by the client. Seed dealers can check

status of a specific order using the check order status feature.

Contribution

. Gathered requirements from the client.

. Analyzed requirements and created the system requirements

. Created use-case diagrams using UML and Microsoft Visio.

. Worked with the DBA on the database design.

. Created and tested SQL stored procedures.

. Developed ASP pages.

. Involved in the production support and resolved issues.

Contact this candidate