Sql Server .Net Business Developer Experience

Shalini R. Janamma

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

Phone No: 901-***-****

KEY SKILLS EXPERIENCE

.NET Development 5+ years

C# 5+ years

SQL 4+ years

ORACLE 4+ years

EDUCATION

University of Memphis, TN

M.S. in Computer Science

Osmania University - India

B.S., Information Technology

SUMMARY

. Over five years of experience in software design, analysis,

development, testing and implementation of web and client server

applications.

. Extensive experience with Microsoft.Net Technologies (.NET Framework,

MS Visual Studio .NET, ADO .NET, ASP.NET, VB.NET, C#.NET, WPF, WCF).

. Proficient in C/C++ application development under both Windows and

UNIX environments.

. Good experience in SQL server 2005, SQL server 2000, Oracle, MS

Access.

. Experience in development of Stored Procedures, Triggers and writing

DTS packages using MS SQL Server.

. Experience in developing Front-End for user Interface.

. Experience in developing web applications using ASP.NET, HTML and XML

Technologies.

. Proficient in distributed computing and developing Enterprise web-

based applications.

. Experience in developing reports using SQL Server 2000 Reporting

Services and Crystal Reports.

. Experience in Manual and Automated testing.

. Proficiency in writing Test Plans.

. Experience in preparation of Test cases.

. Excellent analytical and programming abilities in using technology to

create flexible and maintainable solutions for complex development

problems.

. Effective skills with good written, verbal communication and

presentation skills. Self-motivated with result oriented approach.

EXPERIENCE

Southern Company Services - Atlanta, GA (November 2007 to Till Date)

Software Developer - Contract

Technical Environment: C#.NET 3.5, ORACLE, SQL, WPF, WCF, Silverlight, SDLC

Methodologies

Smart Grid Investment Grant Reporting System

Southern Company received the SGIG from DOE to integrate smart grid

technology into its transmission and distribution system. In order to

receive the stimulus funds, SGIG recipients must submit specific spend

documentation to the DOE. A SGIG reporting and application has been

developed to automate the manual process of gathering reimbursement

information and populating the DOE reimbursement template.

. Gathered requirements from Business Users.

. Developed technical design documents that included screen mockups in

Visual Studio, UML Sequence diagrams, DB design and Data dictionary.

. Created Logical/Physical database structure using Oracle 10g.

. Designed and developed business and process layers using C#. NET and

ASP.NET.

. Designed and developed reports for DOE.

. Extensively used Silverlight to develop cross-browser, cross-platform

Rich Internet Applications (RIAs)

SCS Transmission Portfolio

Designed and developed a secure website to share information with external

parties per FERC standards. The Southeastern Regional Transmission Planning

and Southeast Inter-Regional Participation Process will serve as a conduit

for Southern Company Transmission, GTC, MEAG, Dalton Utilities, AEC, and

SMEPA to communicate with its stakeholders.

http://www.southeastirpp.com/secure.asp

. Gathered requirements from Business Users.

. Designed and developed the Web Application using C#.NET.

. Designed and developed the Database Schema.

. Wrote test cases for User Acceptance testing.

SCS Marketing Portfolio

Outdoor Lighting is an external web site that provides online lighting

catalog. It helps customers design, install and maintain lighting systems

tailored to meet their business needs.

http://outdoorlighting.georgiapower.com/

. Designed and developed a website with product listings in Classic ASP.

. Designed and developed the database in SQL.

SCS Financial & Supply Chain Solutions Portfolio

SoCoFin

This project involved the modification of the current mainframe based SoCo

Financial application to operate in UNIX against the Oracle Financials data

sources. SoCo Financials (Southern Company Financials System) is an

administrative tool which manages metadata used by the Southern Company

financials tools SOFIA (Southern Financial Information Access System) and

SARA (Southern Accounting Reporting Application).

. Extensively used WPF to build feature rich Windows applications which

deliver an outstanding 'user experience (UX)'.

. Designed business and process layers using C#. NET.

. Designed and developed Batch processing in Autosys environment.

. Created Logical/Physical database structure using Oracle 10g.

. Created various database objects such as PL/SQL packages using Oracle

10g.

. Designed and developed the reports using reporting services.

. Implemented and consumed various web services using WCF technologies.

Shelby County Trustee - Memphis, TN (April, 2007 to September, 2007)

Software Programmer - Contract

Designed and developed several modules for STAR.NET in Windows Environment

using Visual Studio 2005 Team Suite with VB.NET front-end and SQL Server

2005 for back-end.

. Conducted system analysis and document data structures associated with

the STAR.NET project. Developed use case diagrams using SDLC method.

. Designed and developed several modules for STAR.NET in Windows Form

environment.

. Developed WinForms and implemented the business logic in VB.NET

. Developed Reporting Services using SQL Server Business Intelligence

Development Studio in SQL Server 2005.

. Create stored procedures, triggers and views.

. Create DTS Package in SQL Server 2000 to transform data to SQL Server

2005.

. Prepared systems flow charts and logic diagrams for the modules in the

system.

. Modified and maintained the STAR system in Windows Forms Environment

and Trustee's Website.

Technical Environment: VB.NET, Visual Studio.NET, SQL Server 2005, Visual

SourceSafe, Crystal Reports (60% of Development and 40% of Database Admin)

Auto Dealer Exchange, United Management, Inc. - Albuquerque, NM

(January, 2006 to March, 2007)

Software Developer - Contract

This project was used for buying and selling cars between auto dealers

spread across different cities in USA. It provided the most cost-effective

and easy method for buying and selling cars on the Internet. Autodx.com

charges Dealers for every on-line transaction.

. Involved in the Design, Coding and Implementation of the Project.

. Involved in Inventory management and Transaction module.

. Involved in validations at client side using Java script, .NET

validation controls and server side using C# business components.

. Developed user interface screens in ASP.NET and implemented the

business logic using C#.

. Implemented validation using validation controls and JavaScript.

. Wrote database components to access Database using ADO.NET. Written

mail components, upload component using .NET Framework classes.

. Wrote user controls for content building. Involved in unit testing and

bug fixing.

. Extensively worked with Web Forms and Server (Web/HTML), Data Binding.

. Created Stored Procedures and triggers to perform automated rules, up

dating to related tables using SQL Server.

. Implemented Security using Forms authentication.

. Extensively worked with complex Crystal reports design, development

using Seagate crystal reports.

. Integrated Crystal Reports with .NET using crystal report viewer

control.

. Implemented web services using XML/SOAP to decode information from

Vehicle identification number (VIN).

Technical Environment: ASP.NET, VB.NET, ADO.NET, C#, Visual Studio.NET,

HTML, JavaScript, XML/SOAP, XSL, MS SQL Server 2000, Windows 2000, Adobe

Photoshop, Crystal Reports, Visual SourceSafe and IIS 5.0, SDLC

methodologies (60% of Development and 40% of SQL Admin)

Department of Safety - Memphis, TN (May, 2004 to December, 2005)

Programmer Analyst - Contract

February, 2005 to December, 2005

Designed and developed various electronic data entry forms (ACIR, TCrash

form) using TraCS software. These forms store data in a local MS-Access

database file. All these records must be uploaded to a central SQL Server.

A tool that uploads these records to central server has been developed.

This tool is integrated with ACIR and TCrash forms so that the officer can

upload the data filled from these forms. The testing of the forms, tool

and the whole system is over and is currently being used by various law

enforcement agencies.

. Collected, studied and analyzed the system requirements.

. Developed Windows based tool that connects to the requested database

and uploads the new records.

. Designed a user-friendly client interface, which allows officers to

select cases by different criteria and transmit those selected cases.

. Designed and developed stored procedures and triggers for maintaining

the data integrity.

. Designed the backup procedures that are scheduled to back up new

records every 24 hours.

. Designed and developed the web services that help the clients to store

data in the SQL Server using C# and ADO.NET.

Technical Environment: TraCS, VB.NET, Web Services, SQL Server 2000, MS

Access, .NET Remoting, SDLC methodologies

(May, 2004 to January, 2005)

Designed and developed a three-tier system for clerks in various courts.

These forms assisted clerks to retrieve, edit and save the criminal records

of a person. These forms helped the clerk to search various electronic

databases for a person based on some information known about the person.

This system is currently implemented by various courts in Tennessee.

. Designed and developed Windows based tool that retrieves requested

records from the server through web services.

. Developed forms in VB.NET.

. Designed and implemented web services that handles requests from the

tool, processes the request and transfer the requested data to front

end tool.

. Created the front-end tier for user interaction.

. Designed and implemented the database.

. Wrote PL/SQL Stored Procedures and Triggers for maintaining the

integrity of the data.

Technical Environment: VB.NET, Web Services, SQL Server 2000, Crystal

Reports, .NET Framework Class Library, .NET Remoting

Visual Soft Technologies - Hyderabad, India (May, 2002 to April, 2004)

Software Developer - Permanent

June, 2003 to April, 2004

Education Information System was developed for HASSERVICES website. It

provided Information about Teaching institutes, Colleges, Universities and

the Courses taught there. This web site has different categories for

specific search. Specific search provided options to the users like,

Location, facilities the institute was providing, affiliation to specific

university etc. It displayed the details of the institutes and the courses

offered by the institute, its selection procedure, student intake, field

specialization, and the duration of course or degree offered. The System

would also enable an institute to provide additional information if it

wanted to do so. If the institute had its own website, the URL would be

displayed to provide information about the institute.

. Involved in design and coding using ASP.

. Used JavaScript for client side validations like validating users

input data, date formats.

. Extensively worked with Data Reports.

. Involved in the Design and coding of business components for the

Middle Tier.

. Configured the components with MTS and created Export Package.

. Invoked components from Client machine using DCOM utility.

. Implemented print functionality using JavaScript.

. Developed mail component using Winsock control.

Technical Environment: Visual Basic 6. 0, MS SQL Server 6.5, Windows NT,

ASP, MTS, IIS, Visual InterDev, HTML, DHTML, JavaScript, VBScript, ADO,

COM, ActiveX, Visual SourceSafe

May, 2002 to May, 2003

SPINS is windows based application for various sorts of educational and

training institutions to measure student's performance in various exams,

subjects, extra curricular activities and attendance. This application

provided statistical analysis, graphical representations for the chosen

comparisons and various sets of input parameters given by the user. It

also provided day-to-day information, monthly attendance, progress report

generation, class analysis, weekend exam analysis, graphs showing the

improvement or downfall of students.

. Involved in the design, analysis and development of application server

and client.

. Involved in the database design and critical areas like database back

up.

. Involved in design and coding of business components for Middle Tier.

. Used OLEDB providers to establish connection to database through ADO.

. Developed mail component using Winsock control.

. Worked with data reports to generate progress report, exam score

sheet, etc.

. Implemented validation using JavaScript.

. Involved in customized report generation for various reports.

Technical Environment: Visual Basic 6, Oracle 8, Windows NT, VB, MTS,

Visual Studio, HTML, DHTML, JavaScript, VBScript, ADO, COM, ActiveX,

Crystal Reports

TECHNICAL SUMMARY

Operating Systems: Windows 2000/XP/NT/Server 2003 R2/Vista, MS DOS, UNIX,

SLES10

Languages: VB.NET, ASP.NET, C#.NET, C, C++, Visual Basic 6.0, Java

Web Technologies: Classic ASP, HTML, XML, XSLT, DHTML, Servlets, Applets,

JSP, WPF, WCF, Silverlight 4.0

Scripting: VBScript, JavaScript, Perl

Web Servers: IIS, Personal Web Server (PWS)

Databases: SQL Server 2008/2005/2000, Oracle 8.0/9i/10g, MS Access

Database Programming: ADO.NET, PL/SQL, SQL Server DTS Programming

Distributed System: DCOM, .NET Remoting, Web Services

Reporting: Crystal Reports, Data Reports, SSRS, SQR Reporting

Testing Tools: WinRunner, LoadRunner, TestDirector

Packages: MS Office, Macromedia Dreamweaver, Flash, Fireworks,

Photoshop5.5

Methodologies: UML, OOPS, OOD

Contact this candidate