Sql Server Developer

SHWETA SAXENA

**** ******** *****, ***** ****, TX – 77478

Phone: 281-***-****/ Cell: 832-***-****

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

CAREER SUMMARY: More than five years of experience in software industry as

a programmer and web developer. Strong background in

Microsoft .NET platform, C#, ASP.NET 4.0, SQL Server

2008, and Sales Force. Energetic self-starter with knowledge

of object oriented software design and implementation. MS

in Computer Information Systems from University of

Houston, BS in Electronics Engineering. Experience in Agile

approach of software development.

OBJECTIVE: Seeking a or a Bussiness Analyst position with a progressive

firm offering a challenging, growth oriented career that

utilizes my professional experience and skills.

SKILLS:

Development Tools: Microsoft Visual Studio .NET 2005/2008/2010, Eclipse 3.1.2.

Web Technology: ASP.NET 4.0, WPF, AJAX, Java Script, XHTML, CSS and

PHP.

Languages: C#, ASP.NET, ADO.NET, Silverlight 4, RIA Services, XAML,

Apex.

JAVA: Servlets, Struts, JDBC, Enterprise Java Beans, Java

Swings, JSP, J2EE, XML (SAX, DOM, JAXP, JDOM Parsers)

XSLT, XPath, XQuery, WML, CGI-Perl, PL/SQL.

Database: SQL Server 2005/ 2008.

Report Tools: SQL Server 2000/2005 Reporting Services, Report Builder

3.0

Tools: Code Smith 3.0 with .netTiers Templates, Dundas web charts, N-Unit and

automated testing tool, Altova XML tool, UML, Rational

Rose, Rational Requisite pro, Visual Studio Team

Foundation Server, Visual Source Safe 2005, Visio, WEKA,

WinCVS and Rally.

Server: IIS Server, Tomcat Apache 4.1.

EXPERIENCE:

11/11– 04/12 Developer: Salesmetrix, Houston TX

• Training for Microsoft Dynamics CRM.4.0

• Attained Microsoft Certification for CRM 4.0 Customization and

Configuration.

• Involved with design and development of CRM project at

Universal Weather and Aviation.

• Customizing CRM to Include Meeting Notes functionality using

Silverlight we web resource.

10/10–09/11: Software Developer: Lanyon Inc, Houston TX

Development and design of Lanyon Rate Integrity tool that provides

management solution to the global travel industry. This tool is a

fully automated multi GDS rate availability audit tool that ensures

maximum savings.

Redesigned the User Registration using Silverlight and RIA

Services.

Designed the customer creation tool.

Troubleshooting issues with GDS.

Designed reports using Report Builder 3.0.

Transform Oracle reports to SQL Server reports using Linked

Server.

06/10–10/10: CRM Developer: Waste Management, Houston TX

Design, development, coding, enhancement, testing, and

debugging of Sales Force application.

Enhancement and trouble shoot issues in current Sales Force

application.

Conducting wide range of quality control tests.

Extensive use of Apex and Java Script.

Create customized Visual Force pages.

Extensive use of Eclipse Force.com IDE.

09/06 – 06/10: Product Developer: Acorn Systems Inc., Houston TX

Development and implementation of Enterprise Performance

Suite. EPS is a costing tool that improves client’s insights into

their costs and profits. This tool analyzes and manages business

profitability across an enterprise. It calculates the true cost and

profits of all business objects,

Project is designed using Visual Studio 2005/2008, C# ASP.Net

2.0, Silverlight Java web services and SQL Server 2005/2008 as

backend.

I was involved in various development and support activities like:

Supporting clients in various parts of the world.

Manipulating configuration file programmatically using .Net 2010.

Using various Microsoft sql server dll’s to configure users and

security roles on database server, analysis server and report

server programmatically.

Developing various versions of the tool using .Net application.

Developing manage and edit screens for various modules using

WPF technology.

Enhancing the product using technologies like RIA services for

Silverlight..

Involved in implementation and design of Supply Chain Analyzer

project.

Extensively used SQL Server reporting web services 2005.

Complete testing of Windows 2008R2 Certification to enable the

application earn the R2 version logo in a Hyper V

environment.(Tools used: Windows® System State Analyzer

and Sigcheck.)

Agile development methodologies.

Creating reports using SQL server reporting services.

05/06 – 09/06 Software Developer: Halliburton Digital and Consulting

Solutions, Houston TX

Enhancements for Tracking Actual Costs (TAC) Project and

Redesign of the application as well as database using Visual

Studio 2005, C# ASP.NET 2.0 with SQL Server 2005 as backend.

The project is designed using C#, ASP.NET with SQL Server

2005 as backend. TAC is a tool used all over the company for

employees onsite as well as offsite to enter time for their projects.

Based on the entries the tool calculates the actual cost of the

project. Reports can be generated for each quarter. Employees

can also enter hours for different roles (E.g. Tester, Developer etc)

in different phases of their project (E.g. Envisioning, planning etc).

They can also review the efforts in the form of charts.

Program managers have the ability to maintain their own

dashboard and assign projects to their team. TAC also sends out

weekly reminders to all the employees registered in TAC to enter

their time. It also takes snapshots of the Tracking Actual table in

the database.

Involved in:

Automating email reminders by developing a separate application

and sending mail through SMTP mail server. The application

is scheduled for sending email regularly using Windows Task

Scheduler.

Modifying the code to support TAC on different domains, so that

employees in different countries can log into TAC.

Fixing bugs in the current application as reported by the users.

Deployment of the project in production.

Constantly supporting users all over Halliburton.

Gathering user preferences and requirements for the new

version.

06/05 – 05/06 Software Developer: Stewart Title Houston, TX

Development and Implementation of AIM+ Project

AIM+ is the title production software used for order entry,

document preparation, file tracking, file management, Electronic

Policy Reporting and closing. It is designed for title and escrow

personnel to use in both large and small office settings, and is

flexible so it can be used for both commercial and residential

transactions.

In the AIM+ application, the user interacts with Win Forms that

use VB.NET code to react to user activity and apply business

rules. SQL Server 2000 is used as a backend. The requests to

retrieve or store data are maintained through web services.

Appropriate stored procedures are called along with valid SQL

parameters for any requests made by the user. The web services

access various databases using ADO.NET. The Data Access

Microsoft Code Block is used for data access functionality.

The module that I was mostly involved was Policy Transmittal.

The user interface initiates the policy transmittal process. The

client application sends all the information regarding the policy

order and endorsements if any, in the XML format to Microsoft

Message Queuing (MSMQ) server using web service. A windows

service running on the server checks for any messages in the

Policy transmittal queue reads them and logs the data in the

database. The xml files generated are then transmitted to external

components where it undergoes schema validations.

Involved in:

Agile development methodology initiated in one of the

enhancements of AIM+.

Performance improvement initiatives such as code refactoring.

Test-driven development by creating test cases using Nunit

automated testing tool.

Maintenance and support of one of the modules of AIM+ namely

Policy Transmittals.

Requirements gathering from users.

Code reviews.

Environment: Windows2000/XP, VB.NET, ADO.NET, XML, Web

Service, SQL Server 2000, IIS 6.0, NUnit Automated Testing tool.

08/03–12/05 Academic projects: University of Houston at Clear Lake,

Houston TX.

08/01–01/02 Java Programmer : Eulan Information Service Solutions,

Houston TX.

Project: EES (Enron Energy Services) Training/Reference

System.

The EES Training/References system is a web-based solution

designed to link all documentation in an intuitive environment. It

allows the user to access the information about the work in

progress, quickly and easily. I was involved in the Java

programming and script part to make the site interactive and

easily navigable.

Developed web page for logon and designed tree structured index

using a new tool Auscomp.

Designed different icons for processes and procedures to identify

them in the index.

Designed a feature that allows user to navigate conveniently

through the links.

Environment: Java, Java Script, Visio, and Auscomp eNavigator

tool.

03/00 - 08/0 IT Administrator, American Montessori School, Houston TX

Managed IT support for the educational institution.

Developed an interactive web site for performing online

registrations/appointments.

03/98 - 03/00 Software Engineer, Wipro Ltd., India.

Developed tools for the online registration of students and the

logon screen.

Developed web pages to upload courses and practice questions.

Developed tool to monitor time management & student

performance.

Developed various SQL stored procedures, functions, triggers

and views

Developed forms and reports using Forms6.0 and Reports 3.0 on

WIN NT platform.

Design and layout of the report according to client’s need.

Performing System testing.

07/97 - 03/98 Technical Support Engineer, Unicorp Overseas Ltd., India.

(Franchise of Compaq Computers in India)

Maintained the computer systems.

Supported clients with trouble shooting of hardware, software and

network problems.

Installed and configured Local Area Network consisting of 2

Novell NetWare servers and 30 nodes.

Created and managed users and group accounts.

Monitored connectivity to optimize the performance of entire

network.

Networked using TCP/IP protocol.

Administered the network at one of the biggest hospital in India.

EDUCATION:

08/03 –12/05 MS in Computer Information Systems, University of Houston

at ClearLake, Houston TX.

08/93 - 11/97 BS in Electronics Engineering, Pune University, India.

01/98 - 03/98 Academic Course on Oracle 8.0 with Developer 2000 leading to

Diplomain Data Base Management

09/99 -12/99 Academic Course on JAVA and its advanced topics leading to

Diploma in Internet Technologies.

ACADEMIC HONORS:

Ranked 2nd overall among 40 students in the bachelor’s program for Electronics

Engineering.

Received merit scholarship in all eight semesters for scholastic excellence.

PROFESSIONAL AFFILIATIONS:

Actively participated in the Mentorship program at Stewart Title Houston.

Mentored a sixth grade student at Grady’s Middle School Houston, TX.

Successfully completed Associate’s continuing education program at Stewart

Title, Houston, TX.

REFERENCES: Available upon request.

Contact this candidate