Developer .Net Sql Server Project Development

Anuja Kulkarni

SUMMARY

• Over *+ years of experience in the IT industry, involved in complete SDLC including architecture, analysis, design, development implementation, testing, documentation & maintenance of Internet/Intranet, Client/Server and software products.

• 5+ Years Experience in development using C#, VB.NET, ASP.NET, ADO.NET, Visual Studio. NET.,WEB SERVICES., MS-TEST,N-UNIT TESTING., SQL SERVER,SHAREPOINT SERVER

• Experience in Designing and developing Winforms as well as Webforms.

• Experience in VB Script. C#, VB.NET, HTML, XML, JavaScript and CSS, SQL SERVER 2000/2005/2008 with Advanced services,Rapid SQL, Windows Mobile 6.0, Win32.MVC,MVP,SSIS,SSRS.

• Experience in WPF, WCF, WF Multi threading, GUI design, OOP

• Extensive experience of handling XML files through Visual Basic as well as from C# using Dom Document

• Expert in C#, ASP.NET/ASP, VB.NET/6.0, ASPX, XML/XSL, C#, ActiveX, HTML/DHTML, CSS, VBScript, JavaScript, IIS

• Expert in databases SQL Server 2005/2008, Oracle, Access and database technologies SQL, PL/SQL, TSQL scripts, ADO.NET, RDO, ODBC.

• Knowledge and exposure to n-tier architecture, OO Design and Development.

• Experience on Manual as well automated unit-testing tool, MS-Test, Nunit testing.

• Excellent analytical, communication and interpersonal skills.

TECHNICAL SKILLS:

OP Systems: Windows XP/2000/NT/98/95, UNIX,WPF.Windows Mobile,MVC,MVP

Languages : C# 2008, VB.NET/6.0, VBA, HTML5/DHTML, XML/XSL/XSLT, VBScript, JavaScript, SQL, PL/SQL, TSQL

Middle ware: COM+/COM/DCOM, ActiveX, ADO.NET/ADO/RDO/OLEDB, WCF

Databases: MY SQL,MS SQL Server 2000/5/2008, Oracle 9i, MS Access,DB2(rapid sql), SSRS

Internet: COM+/COM/DCOM, ASP.NET/ASP, ActiveX, IIS, MTS, ADO/ RDO /ADO.NET, ODBC, WEB SERVICES, Crystal Reports, Visual Studio.NET/6.0, UML, Smart Device Apps,aspx

MS Office, MS Visio, MS FrontPage, Ms-test, Nunit testing

EDUCATION: Bachelors in Computer Science

EXPERIENCE:

Atrium Medical: April 12-June 12

.Net Engineer/Developer

Responsibilities:

• Coding, testing, debugging documenting, and installing both new and existing programs/technologies related to ‘Employee Training Database’.

• Analyzes end users data needs and developing user oriented solutions to interface with existing applications.

• Designing systems, programs and coordinating the review of specification, user sign off process, and the development of user manuals.

• Coordinating all aspects of implementation, documentation, and training to support new programs/systems as well as to support user needs.

• Writing or revising program documentation, operations documentation and user guides as needed.

• Provide our software department with the ability to create, document, and implement customer specific demand for MS SQL custom report programming (SSRS).

• Create/install and maintain portal environment as required and integrate web applications into portal environment.Used javascript, Html 4/5, CSS and Ajax in developing application.

• Used SSRS for Atrium Library iPad App Monitoring Report as main report and Nurses survival kit report. Handled production issues as well RDL fixes for this Report.

• Assist in special projects as needed.

Environment: VB 6.0, C#,ASPX,Visual Studio 6.0, ASP.NET,VB.net 2008, Javascript,CSS, HTML 4/5, Ajax,SSRS,Sharepoint server, MS SQL version 2k and 2005,2008 as well as Oracle and other relational databases.

Company: JAP Network Inc. Feb-11-Mar-12

Jones and Barlett Learning (Ascend learning), Burlington MA

.Net Developer

Project:

JBlearning/JBpub Companion web Sites

Responsibilities:

• Design, Develop and maintain websites for published books.

• Work included hands-on coding, maintenance, enhancements, bug fixes, and new development.

• Work independently.

• Prototyping for new forms as well handle forms based on wpf technology.

Environment:

ASP.Net, C#, HTML5, Javascript, CSS, ASPX,JQuery, WPF,WCF,SQL Server 2010, Web Content Management, Coldfusion,Visual studio 2010, Adobe Flex/flash,Agile-Scrum,Ajax, Sharepoint Server

ADP, Salem NH

Senior .net Software Engineer

Project:

ADP Retirement Services

Responsibilities:

• Design and Develop Client Intranet workflow site for ‘Retirement Services’.

• Work with internal users on daily basis for requirement gathering, web, database development.

• Work on enhancements for project.

• Work on business layer, data layer and UI.

• Perform rigorous Unit testing.

Environment:

Visual studio .net 2008, Sql server 2008,Vb.net,C#,Aspx,WPF,WCF,Sql server,javascript, Asp.net,SSIS,GUI design, Unit-Testing

Voyager Systems, Bedford NH Sep-10-DEC-10

Senior .Net Developer

Project:

Bureau of Labour and Industries(Oregon)

TAMM(TA Marketing and Mailing System (TAMM) Version 1.0.0)

PWR (Prevailing Wage Rate Division (PWR) Version 1.0.0")

Child Labor Unit (CLU)"

ADAM

SWAPPER Land Division Special Waste Profile Tracking System Version 1.0.0"

ASBESTOS Abatement Program Tracking System Version 1.0.0

PREAP Pre-Approval Tracking System Version 1.0.0

Responsibilities:

• Converted Oracle 10g forms to Microsoft .net / WPF screens.

• Did prototyping for all Projects.

• Worked on Infragistics 35/4.0/WPF based framework.

• Handled code in C# through code behind.

• Conversion of old WANG system forms to new WPF forms.

• Handled UI part for any defects or changes.

• Worked on Crystal report 12.0 version for creating reports also conversion from old to new format.

• Handled .net remoting and oracle server.

Environment:

C#, ASP.NET, Visual Studio .Net 2008, WPF, WCF, MVP, MVC,Web services, WF Multi-threading, GUI design.,SSRS,

Tortoise version/Sub version, JavaScript, SQLServer 2008., Windows Mobile 6.0, Win32,Windows –7, Windows-server 2003, IIS, MS-test, Nunit-test.

Schneider Electric Buildings (TAC), Andover MA Jun-09 –Jun-10

Product Management/Workstation/UI Developer –R&D

Web Senior/. Senior .Net Developer

Project: NSP/Struxureware Project

Responsibilities:

• Involved in Gui TF taskforce.

• Handling Client against server side changes.

• Worked on C#, WPF, Visual studio 2008, Web Services, WCF.

• Involved in Object type and property names normalization in Engineering tool.

• Worked on property grid filter control under NSP station.

• Worked on Central IO project for handling/managing IO input/output bus control.

• Handled Defects found in NSPclient, having environment WPF.

• Involved in MS- Test as well Nunit testing.

Project: Web-Reports

Responsibilities:

• Working on C#, ASP.NET website for Struxureware Webreports.

• Worked on Localization and Internationalization.

• Maintaining website by doing enhancements as well UI-changes.

• Worked on Session handling.

• Created program for creating dynamic objects on struxureware client.

• Worked on UI design/development.

• Involved in testing of code developed.

• Worked on defects having environment WCF, as well Web Services.

• Working on defects as well handling defects.

• Worked on SSRS as reporting tool for Stuxureware Reports.

• Handling Client against changes in Reporting side as well server side.

• Defect handling during Work Package-2

• Doing enhancements for Work package-3.

• Handling quality center defects against work package.

• Have done fitnesse test overview/training.

• Maintaining Business side/Reporting agent side, as well installing Sql server 2008 having advanced version.

• Finally did Nunit testing, also MS-Test on the modules developed.

• Install software on Windows-7 for compatibility issues.

Project: Electronic Access Control.

Responsibilities:

• Involved in Task for EAC.

• Working on Client side for UI enhancement according to work package.

• Working on creation of data Model, View Model, Presenter object.

• Developing user viewable C#, WPF functionality.

• Maintaining and handling code base.

Environment:

C#, ASP.NET, Visual Studio .Net 2008, WPF, WCF,ASPX, MVP, MVC, Web services, WF Multi threading, GUI design, SSIS, SSRS.,Sharepoint Server

Tortoise version/Sub version, JavaScript, SQLServer 2008., Windows Mobile 6.0, Win32,Windows –7, Windows-server 2003, IIS.

MS-test, Nunit-test.

AIG (AIUHoldings) : ( ADB unit/Corp- R & D), Bedford, NH Mar 08-Apr09

Web Senior/. Senior .Net Developer

Project: Private Client Group

The Private Client Group assists the PCG group in Managing brokers who submit business on high net worth individuals. PCG staff is able to enter these information regarding these brokers such as contacts, Call reports, and strategies. This Application also allows the ability to record PCG staff assignments to these brokers. This information is then shared with brokers themselves. A policy feed is taken to show, the clients these brokers conduct business with.

Responsibilities:

• Modify/Create new back end APIs which define the business logic and access the data. Create new Web Services and similar AJAX APIs in older version as well new version to dynamically fetch data from the server for the users.

• Handling and maintaining Coding changes for new and existing user interface for Private Client Group in ASP and ASP.NET along with JavaScript and CSS. Visual Studio is used to create new UIs, user controls in a shared development environment.

• Design table requirements and writing queries, stored procedures, user defined functions using DB2, and maintaining them as need for the current APIs and new modules for Private Client Group.

• Work on data related issues/broker/client related issues. Fixing bugs as well do Production support for Private Client Group.

• Creating/Converting Application into new 2.0(Visual Studio 2005) versions as well asp to asp.net.

• Work with people, creating and gathering new requirments and enhancements for Private Client Group.

• Talk/communicate to people regarding changes in code as well API /user interface necessary time to time.

• Talk/communicate with people/users regarding new functionality as well developing it in Private Client Group.

• Work with mainframe developers in creating and maintaining batch jobs for weekly Scheduled basis, as well fixing job as and when required.

• Create and maintain files as and when required for epcg and pcg marketing. Provide files regularly on ftp server, with data elements needed for reporting as well for other purposes.

• Write Batch jobs in VBScript/java to maintain existing functionality as well new developed functionality. Tracking and scheduling batch job, monitor them for any errors.

• Handle data load requests using Excel, MS Access and Rapid SQL from various regions for loading new Accounts into PCG.

• Involved in Unit testing with Nunit-testing.

• Manually monitor various data elements like zone, region, and branch critical to PCG and add/update any changes that come across from PCG/EMIS users.

• Communicate with Users, epcg groups to assess the progress of the system development and draft future tasks as well completed tasks. Document the short comings of the project and make changes.

• Facilitate as a back up for monitoring/maintaining the Web servers for the application and scheduled batch jobs.

Environment:

VB.NET, C#, ASP.NET, Microsoft Office, Web-services, javascript, Aspx, MS-test,Nunit test, VBscript, DB2,FTP Server, Visual Studio.NET 1.1 & 2.0, Rapid SQL/DB2 My-SQL T-SQL,Windows Mobile, Win32 Visual Source safe, Windows 2000/NT, Win.NET Server, IIS.

Choicelinx Corp. Manchester,NH DEC’07– Mar’08

. NET Senior Application Developer

Project: Config app/AO projects(for Cigna client):

A software application that allows entry of client configuration data for a complex benefits management database and web application. The program was designed to allow client managers to directly enter all information in an intuitive and quick manner to facilitate setup of over 60 tables with client specific information to drive the business logic of the main web application. Primarily a data entry program, there were many screens requiring an element of business rules to be applied to validate and coordinate data entry for specific benefit offerings.

Responsibilities:

• Responsible for collection & analysis of requirements, co-ordinate meetings & code-reviews.

• Develop client side application modules and back end applications using various Microsoft tools such as c#, Visual Sourcesafe, P/L SQL and T-SQL.

• Extensively used .NET Framework classes, Threading, XML. and Globalization.

• Extensively used P/L SQL and T-SQL stored procedures and Triggers

• Used SSRS as reporting tool for Client major reports.

• Involved in documenting the tool.

• Worked on several tables & their joins.

• Responsible for debugging Appconfig and for creating process flow of the application which was developed in visual studio 2005 .

• Worked on SSIS for import/Export database.

• Developed database diagram based on available inputs in sql server 2005 ..

• Used Ms-Visio for drawing database diagram.

• Front end was Created & developed in C# .

• I have created Copy Benefit Package Functionality.

• Used SQL server Reporting services in some feature.

• I have created backend (store procedure, Cursors in sql server 2005.) for creating this functionality,& used Ado.net for interaction of user interface as well database.

• For AO project,i was responsible for gathering functional requirments,developed use case diagrams.

• Have used Object oriented principles for creating web application.

• Developing Test Cases & subsequently unit testing with Nunit test of the various modules developed.

Environment:

C#, Visual Studio 2005, win-32,Web services, Sql server 2005, SSIS,SSRS, Nunit-testing

Sanofi-Aventis Pharmaceuticals Bridgewater, NJ Jun’05 – Nov’07

Systems Analyst

Infrastructure Project Warehouse:

• Designed and developed Infrastructure Project Warehouse (IPW) tool to assess functional requirement data at the primary level in order to determine associated Infrastructure project costs. IPW also handles budget considerations and Capital Management process. IPW is a 3-tier System

• Responsibilities:

• Analysis and Design using Object Oriented Methodology UML.

• System Study, Requirement Gathering and Involved in extensive interaction with users.

• Building of task automation and integrated transactions using Windows Workflow Foundation (WF)

• .Net 3.0 (WPF) for UI automation infrastructure, data driven UI and visualization.

• .Net 3.0 (WCS) for security.

• Responsible for collection & analysis of requirements, co-ordinate meetings & code-reviews.

• Responsible for Design of Data Model, Data Flow, Entities & Relations, Creation of Logical & Physical Database Structures.

• Involved in whole SDLC for IPW. Responsible for Requirement analysis, design, development and testing

• Responsible for system, database and presentation layer architecture.

• Designed and developed user interfaces in C# / ASP.NET.

• Extensively used .NET Framework classes, Threading and XML.

• Designed and developed normalized database in SQL Server 2000

• Have experience on DB2 as well.

• Developed and consumed web services using ASP.NET

• Worked on SSIS for import/export database.

• Extensively used T-SQL stored procedures and Triggers

• Used Crystal Reports for reporting Financial Details

• Involved in documenting the tool.

• Responsible for user training and post-development support.

• Maintenance and support of the application.

• Developing Test Cases & subsequently unit testing of the various modules developed.

Environment:

C#, ASP.NET, Web services, Nunit testing,MS Visio,aspx, UML, Win 32, Visual Studio.NET 1.1, SQL Server 2005, T-SQL, Visual Source safe, Windows 200/NT, Win.NET Server, IIS.,SSIS

United Parcel Service Timonium, MD Jul 04 – May 05

. NET Developer/Analyst

WorldShip TradeDirect (WSTD):

WorldShip is a shipping system used at all UPS stores all over the world. It comes with two releases: Worldship Domestic and Worldship International developed in VC ++. WSTD integrates both the releases and it will replace these individual releases. It supports 13 international languages and automatically gets configured with the country language.

Responsibilities:

• Responsible for collection & analysis of requirements, co-ordinate meetings & code-reviews.

• Develop client side application modules and back end applications using various Microsoft tools such as Visual Basic, VB.NET (Webforms), Visual C++, Visual Interdev, Visual Sourcesafe, Oracle 9, P/L SQL and Crystal Reports.

• Migrated and integrated VC ++ windows applications into VB.NET web application.

• Extensively used .NET Framework classes, Threading, XML. and Globalization.

• Extensively used Windows registry and Win32 API’s for application and system settings

• Integrated third party components in the application.

• Integrated unmanaged code in managed code environment.

• Interaction with business users and gather business requirements, demo prototype interfaces and collect feedback, direct user acceptance testing and provide follow-up application support and troubleshooting around software and environment changes.

• Extensively used P/L SQL stored procedures and Triggers

• Used Crystal Reports for generating shipping reports

• Involved in documenting the tool.

• Responsible for user training and post-development support.

• Developing Test Cases & subsequently unit testing of the various modules developed

Environment:

VB.NET, Webforms, VC++, MS Visio, UML, Visual Studio.NET 1.1, Oracle 9, P/L SQL, Visual Source safe, Windows 2000/NT, Crystal Reports,DB2

Wells Fargo Menomonee, WI Aug’03 – Jun’04

.NET Developer & Analyst

Investment Repository Import:

As part of the ongoing efforts and initiatives towards the integration of IT systems existing currently at Strong Financial Corporation and Wells Fargo Capital Management, there was a need to move data from Wells Fargo to Strong, and vice-versa. Due to the inconsistencies in the data formats, as a result of differences in the database structures in the two organizations, coupled with the existing infrastructures differences in terms of how the data itself is organized, it was critical to identify, load and import data accurately, appropriately and on a regular basis.

We developed a compatible and maintainable system, which automated the process of identifying the periodic incoming data from Wells Fargo and loading them into corresponding databases in Strong.

Responsibilities:

• Responsible for collection & analysis of requirements, co-ordinate meetings & code-reviews.

• Responsible for Design of Data Model, Data Flow, Entities & Relations, Creation of Logical & Physical Database Structures.

• Analysis & Design functional & technical specifications using OO Methodology/MS Visio/ UML.

• Responsible for system, database and presentation layer architecture.

• Designed and developed user interfaces in VB.Net

• Used JavaScript along with html for UI interface.

• Extensively used .NET Framework classes and XML.

• Designed and developed normalized database in Oracle 9i

• Extensively used P/L SQL stored procedures and Triggers

• Developed & consumed Web services.

• Involved in documenting the tool.

• Responsible for user training and post-development support.

• Maintenance and support of the application.

• Developing Test Cases & subsequently unit testing of the various modules developed.

Environment:

VB.NET, ASP.NET, Java Script, MS Visio, UML, Visual Studio.NET 1.1, SOAP, Oracle 9i, P/L SQL, Visual Source safe, Windows 2000/NT, IIS.,DB2

Manas Microsystems, Nasik, India Aug’01– Jul’03

Programmer Analyst

Library & Material Management process: This Project designed to help maintaining Library Transaction process, Basically it’s inventory control system. It’s designed to help planning the acquisition material, classification of material, preservation of material, borrowing material, Book processing (selection, ordering, receiving, classification & cataloguing), Audio video materials.

The intranet site developed for the purpose of it. Basically it’s a 3-tier process.

Responsibilities:

• Involved in requirement analysis, and design of the module.

• Prepared the Use Case and Class diagrams using UML.

• Presentation tier developed in Visual Basic 6.0/ASP.

• Designed and Developed GUI using HTML.

• Designed and implement database in Sql Server.

• Involved in unit test and integration testing.

• Prepared test cases and technical support documentation. Created Data Flow Diagrams

Environment: ASP, VBScript, JavaScript, Visual Basic 6.0, SQL Server, HTML

Contact this candidate