Vinay Arora

Summary:

• Over eight Years of IT experience in software design, analysis, development, testing and implementation.

• Extensively worked in Microsoft .Net Technologies for Web application development (Web Forms) with ASP. NET 2.0, C#, VB.NET, ADO. NET and AJAX Controls Toolkit.

• Knowledge of working on Visual Studio 2005.

• Extensively worked on XML, XPATH using C#.

• Strong experience in Object Oriented Programming Concepts.

• Worked on n-Tier Architecture.

• Experience with Windows Communication Foundation (WCF) on .Net Framework 3.5 using Visual Studio 2005 for building Web Services

• Experience in Windows Application Development (Win Forms) with C# and ADO.NET

• Knowledge of Windows Presentation Foundation (WPF), XAML.

• Strong experience in analysis and design of relational databases (RDBMS).

• Extensively worked using advance concepts of T-SQL using DML, DDL, DCL

• Extensively used Stored Procedures/Cursors/Joins/Triggers.

• Worked on XML features of SQL Server 2005 for querying and processing the data.

• Extensively wrote user defined function (UDFs) in T-SQL.

• Database programming experience using ADO.NET 2.0 and Typed/unTyped Datasets

• Experience working in Microsoft VSS version control environment.

• Experience in using JavaScript, HTML, CSS

• Experience in interacting between Business Analysts and technical team to facilitate the development lifecycle

• Working Knowledge of Crystal Reports and SQL Reporting Services (SSRS)

• Experience working within an Agile methodology using SCRUM.

• Excellent team player with problem solving and trouble shooting capabilities.

• Excellent aptitude, reasoning, written & verbal communication skills.

• Constantly upgrading and learning new skills and technologies.

Technical Skills

.NET Languages .NET framework 1.1, 2.0, 3.0,C#, ADO.NET 2.0, ASP.NET 2.0, WCF using .Net Framework 3.5

Web Technologies Web Services, SOAP, WSDL, UDDI, XML, XSLT,XPATH, XQUERY,CSS, JavaScript, VBScript, HTML

Other Languages C, C++, Core Java, ASP, VB 6.0, AJAX

Office Products Microsoft Word, Excel, PowerPoint

IDE Visual Studio 2003 & 2005, VS 2008

Methodologies OOPS,OOAD, UML, SOA

Technologies T-SQL, PL/SQL

Databases SQL Server 2000 & 2005, MS Access 2000

Operating Systems Windows Servers 2000 & 2003, Windows XP, UNIX

Reporting Tools SQL Reporting Services, Crystal Reports 9.0

Version Control Microsoft Visual SourceSafe, TFS

Tools Microsoft Visio

Qualification

Education Qualification Bachelors in computer Science.

Client: GlaxoSmithKline (GSK)

May 2009- Present

Role: Senior Software Engineer

Project Description:

This project deals with major enhancements like interacting with External Third Parties like FedEx and DHL. The application also allows for creation and approval of centres for a specific study.

Responsibilities:

• Involved in Analysis, Design, Developing and Testing. Designed high level design document Functional Specifications, Software Requirements Specifications (SRS), Source Code Review report (SCR), Software Project Plan (SPP).

• Designed use cases, generated UML diagrams and sequence diagrams using Visio 2000.

• Developed and implemented entire application in AGILE methodology.

• Created prototype of new enhancement change order status module and then designed and coded in C#.NET.

• Designed the application using C#.NET language for the web application, built on three tier architecture with extensive use of Object Oriented Programming techniques.

• Involved in coding of Business Logic Layer and Data Access Layer using C#.NET.

• Developed web pages using ASP.NET web controls, HTML server controls and created style sheets using CSS.

• Developed the front end GUI using ASP.NET, developed Custom Controls, User Controls for professional and advanced GUI.

• Extensively used JavaScript for validations and customizations of the front-end screens and controls to reduce the load on the server.

• Implemented .NET security with form based authentication, assigned roles and role based authorization in web.config file.

• Published Web services to interact with the other applications and exposed them using SOAP.

• Developed the screens using AJAX for partial page updates.

• Customized the Data Access Module using ADO.NET, to handle the entire transaction with the database.

• Developed stored procedures, views and triggers in for data manipulation and for retrieving data from SQL database.

• Developed Reports using SQL Server Reporting Services (SSRS), extensively used SSIS.

• Conducted knowledge transfer sessions to new team members and junior team members to guide them through data flow through the application

• Deployed the application on Test Server and Production Server.

• Involved in Unit testing, Integrated testing, and Documenting.

Environment:

Microsoft Visual Studio .NET 2005, Visual Source Safe 6.0,Visio 2000, Mercury Quality Centre 9.0, C#.NET, ASP.NET, SQL Server 2005.

Client: Thomson health care,NJ

April’2008 –April’2009

Role: Application Developer

PDR.net, allows its users (physicians, nurses, medical students etc.) to access the PDR website by offering integrated medical information and education tools. This contains the information, which is required by these user sets daily such as drug information, and other medical resources arranged together in one site for convenience and ease-of-use.

Responsbilities:

• Developed user interfaces using ASP.NET controls.

• Implemented business logic using C#.

• Worked extensively on Client Side Validation using Java Script.

• AJAX is established for presentation layer. Cascading Drop downs, Auto complete extenders (Like Google search), Tabs control and collapsible panels.

• Provided database connectivity using Microsoft SQL-Client Provider.

• Utilized database components (Data Adapter and Data set) to access database using ADO.Net.

• Coded and created Stored Procedures for performing repetitive tasks in updating related tables using T-SQL.

• Created Tables and Views in SQL server.

• Worked with the team to develop the web services (WCF) that is used to submit the document and processing it.

• Extensive use of XML features of SQL SERVER 2005 for maintaining xml data based on XPath queries. Reading XML documents and storing data in the relational database using various methods.

• Applied Cascading Style sheets to the pages.

• Developed Custom User Controls to reduce the Complexity in User Interface Coding and provide better look and feel.

• Understand the work flow of the application and make the changes in application pages to incorporate the editing.

• Worked on SSRS for generating reports.

• Design the various formats of the reports.

• Responsible for interaction with the client in collecting the requirements.

• Involved in Unit, Integration and load testing. Well co-ordinated with testing department.

Environment: Visual studio 2008, SQL Server 2005, Transact-SQL, IIS 5.0, .NET Framework 3.5, .NET Technologies (C#, ASP.NET, ADO.NET, Web services), AJAX, ASP, Windows XP, VSS, Java Script, HTML, XML, CSS,XSL

Client: Countrywide Financial, TX

Mar’2007 - Mar’2008

Role: Application Developer

CIWI is an intranet application with enterprise workflow architecture serving to provide support customer requests received via US mail, Fax (paper correspondence) and email. This application uses role based access levels to employees of various departments under the Loan Servicing division of Countrywide. This application integrates with other remote applications like Imaging, email, Automated Letter generation.

Responsibilities:

• Developed Front End Pages using ASP.Net with Master pages, Themes, and standard controls like GridVews, Custom controls, Date Pager, List View, and Validation controls.

• Developed MS Enterprise Libraries and custom-class libraries for Data Manipulation, Data Access components, Utilities components, and Registry or Web.Config access levels. Microsoft Enterprise Libraries using C#.

• InProc Session state management and XML files to store application configuration constants.

• Developed classes for database access, .Net Framework assemblies and other business components Used ADO.NET disconnected DataSet model, stored procedures and fragment caching to enhance performance.

• SQL Server 2005 Enterprise Manager was used to create objects like tables, stored procedures, etc.

• Implemented Role based security.

• Custom .Net developed web services are used for pulling Correspondence Imaging on request.

• Used already existing ASP address book component for Email integration.

• Developed client side validation and dynamic UI using JavaScript and HTML.

• Developed and Implemented Complex Reports on the web by using MS reporting services.

• Workflow Maps were created in MS Visio 2005.

• Used DotNetNuke Content Management System for designing web applications to allow users to manage website easily.

• Continuous Integration was utilized for Quality assurance.

• QA -Testing: Integration, Functional, Validation, &Exception.

Environment: SQL Server 2005, Transact-SQL, IIS 5.0, .NET Framework 3.5, .NET Technologies (C#, ASP.NET, ADO.NET, Web services, WSDL, SOAP, DISCO), ASP, Windows XP, Java Script, HTML, XML, XSL, MS Visio 2005,DotNetNuke.

Client: Camino Medical Group, CA

July’2006 - Feb’2007

Role: Application Developer

The project was created to keep track of patient details with creating web pages using .Net Technology. The Intranet/Internet project was developed to maintain various departments of hospital. The web interface was developed to search pages for patient information, adding and deleting patient information. This web interface was developed for various departments of the hospital like patient registration, create appointments, consultation, message board, and billing and follow up, Nursing Notes. It also includes reports, which makes physicians refer the patients. This application is useful to track the information for both physicians and staff.

Responsibilities:

• Developed front-end screens for registration, consultation, follow-up, coding of application logic in ASP.Net and C# utilizing the power of Microsoft .NET Framework.

• Designed and implemented the GUI (ASP.NET) with Web Form controls, web-server controls including Data Grid, Data List and SQL Server used as a database

• Coded and developed various Web Interfaces with C# for login form, department details form, Patient details form, registration form, physicians form etc.,.

• Used ADO.Net Technology to connect the web forms to data sources such as MS sql server and Xml files for manipulating data in database.

• Designed and developed the required stored procedures, triggers and database functions

• Designed and Administered Security policies in .Net Code based as well role based security.

• Design and developed the C# components for implementing business logic in middle tier in 3-tier application interacting with MS Sql server database using Managed provider using ADO.NET.

• Developed Patient objects, and created functions to get data from data access layer using C#.

• Reusable UI widgets, such as the navigation menus, are implemented as ASP.NET User/Custom Controls.

• Implemented Page Level Caching (i.e. called Output Caching) to store copies of entire pages/page fragments for more static pages.

• Used GetPatients, GetPhysicians web methods in Xml Web Services to retrieve information in a particular city

• Coded using XSLT in generating the patients list taking the data from XML document and formatting with XSL.

• Used IIS authentication and Forms Based authentication for various web pages.

Environment: Visual Studio.NET, C#, ASP.NET, ADO.NET, Webforms, HTML, DHTML,JavaScript, Sql server 2005, XML, XML WebServices, XSLT, IIS6.0 and Windows 2003.

Client: Insure Health Systems , India

May’2004 – June’2006

Role: Application Developer

India Insure provides Risk Management and Insurance Broking services. India Insure is the country's first Licensed Direct Insurance broker in the liberalized Indian Insurance market.

Responsibilities

• Developed website using VB.NET, JavaScript. Responsibilities included database design, performance analysis, and website update when necessary.

• Extremely involved in the principle database system at the back end in order to retrieve customer Information. Used HTML/XHTML, XML to build front end user interface together with JavaScript.

• Design and code (using VB.NET, ASP.NET) a GUI based interface to generate Reports to display those stored data from SQL server.

• Designed Database (using ERD Model and creating Relational Tables) and manipulated Database as per system requirements. Also developed Queries (simple/complex joins, sub-queries) along with stored procedures and Triggers.

• Designed, Normalized Data in order to meet business requirements

• Involved in coding and testing in order to enhance the functionality of the current system.

• Worked extensively on Client Side Validation using Java Script.

• Designed and developed GUI screens using ASP.Net Web Forms with VB.NET.

• Involved in preparing the test cases and performing unit testing and integration testing of the application.

• Involved in writing Stored Procedures, Triggers and Views.

Environment: ASP.NET, Visual Studio, SQL SERVER 2000, XML, IISVB, COM, Java Script, Visual Source Safe, ADO.NET, MS Project.

Client: Strides software, India

March’2002 –April’2004

Role: Developer

Contact this candidate