.Net Development Manager Data Experience Oracle

Rajat Khattar

E-Mail: ****************@*****.*** Contact No: 813-***-****

SUMMARY

Over 7+ years (86 months) of experience in all the phases of SDLC design and development of Enterprise-level web and windows applications using Microsoft Technologies.

Proven Project Management, Resource Management, Estimations, Capacity/Volume Management and Delivery Management (both Offshore and Onsite models) skills.

Extensive Experience in Automobile Manufacturing, Tourism, Banking & Finance and Technology Domain.

Extensive experience in using C#, ASP.NET, VB.NET, ADO.NET, Windows Form, Web Forms, Web Controls, C, C++, Visual C++, ATL COM, Visual Basic, SDK, API, Graphic User Interface (GUI).

Experience in analyzing Functional requirements, designing UML, Use Case and Class Diagrams using Microsoft Visio.

Expertise in designing ASP.NET based Graphical User Interfaces with CSS, JavaScript, J-Query, AJAX, Multithreading, DHTML and HTML.

Excellent experience in dealing with Events, Assemblies, User Control, Custom Controls and handling queries using .Net 3.5 and 4.0 LINQ, PLINQ components.

Experience in designing and branding Master Pages utilizing Server Controls, User Controls, Data Grid control, Form Validation controls, Custom controls and CSS.

Proficient in working with ActiveX, UML Modeling and Shared Assemblies.

Strong experience in data retrieval and manipulation using ADO.NET data objects such as Dataset, Data Reader, Data list, Data Adaptor.

Detailed working knowledge of Data Structures, Compiler, Operating System and Networking.

Experience of working on TCP/IP using Socket programming in VC++, C#.NET, etc.

Proficient in Object Oriented Design/Development (OOD), Object Oriented Analysis and Design (OOAD), Model View Control (MVC) design pattern and Test Driven Development (TDD).

Involved in all phase of SDLC (Software Development Life Cycle) including system analysis, design, coding, Test case review, Code review, testing, debugging and documentation.

Proficient in working with Stored Procedures, Triggers, Cursors, Functions and Views on SQL Server, Sybase and using PL/SQL in Oracle.

Excellent experience in developing and consuming Windows Communication Foundation (WCF) Services.

Experience in using Net remoting, Web Services, XML, XSLT, XPATH and XML Schema.

Experience in working with Visual Studio 2008/05/03, SQL Server 2008/05/00, Sybase and Oracle.

Experience in working with TOAD, Bugzilla, HP Quality Center, SharePoint, Rapid SQL, Visual Source Safe (VSS), PVCS, and Subversion using tortoise SVN.

TECHNICAL KNOWLEDGE

Programming

: C, C++, JAVA, C#.net, VB 6.0, VB .NET.

Scripting

: Java Script, J-Query, VBScript

Frameworks

: .NET 1.1/2.0/3.0/3.5

IDE

: Visual Studio 2003/2005/2008/2010

Middleware

: COM/DCOM, COM+, COM + Interop, ATL

Web Technologies

: ASP.NET 1.0/1.1/2.0/3.5, XML, XSLT, UDDI, WSDL, WCF, WPF, WWF

Web Services

: .NET Remoting, SOAP, HTTP

Web server

: IIS 5.1, IIS 6.0

Database

: SQL Server 2008/2005/2000, Sybase, Oracle, MS Access, Excel 2007/2003/2002

Version Control

: VSS, SVN, PVCS

Operating Systems

: Windows 2000/XP/2003/2008 Server and Unix

PROJECT DETAILS:

October 2009 – Till Date JP Morgan Chase/Cognizant

Consultant/Technical Lead Tampa, FL

Zippy Plus/Apriori Systems

Zippy plus is an Automated Underwriting Software developed for Home Lending department of Chase bank. It serves millions of customers across United States to get the Loan approved from them just in a single click. The whole system consists of multiple applications written in C++, VC++, MFC, C#, VB.NET, ASP.NET, VB 6.0, Sybase, Power Builder, etc. The Communication is done through MSMQ, Sockets and MQ series. The whole system contacts External agencies for Credit check, also the government agencies like HUD, FNMA and FHLMC are contacted to get a loan quotes from secondary vendors.

Role:

• Coordinate with Cognizant offshore teams using Cognizant's proven on-site/offshore methodology.

• Responsible for gathering the Business requirements from the Business Analysts group and developing them into a Technical design and Impact Analysis documents.

• Leverage Cognizant proprietary tools & systems to control the quality and processes of the project.

• Responsible for creating POCs for Setup and deployment of applications in Windows 2008 Environment using Visual Studio 2010.

• Used regular expressions and LINQ to make the sorting of several complex collections and datasets much performance oriented.

• Responsible for ZiPPY Non Production/Production Tools Development and Consolidation Project. This will increase system stability and availability for ZiPPY system. I will also be responsible for ZiPPY’s Environment.

• Reverse Engineering of a .NET 1.1 based console applications to Windows Services using .NET version 3.5. Also migration of Windows Services from .NET framework 2.0 to 3.5

• Responsible for Migrating/Testing the whole ZiPPY applications from Windows 2000 to Windows 2008. All these applications are in .NET, C++, Power Builder and Visual Basic 6.0.

• Responsible for Documentation of Apriori Components using Microsoft Visio.

• Maintenance and enhancement of ZiPPY Workbench which is a web based application written using ASP.NET/VB.NET.

• Maintaining/Re-Engineering Apriori Engine/Advisor which are C++/VC++/MFC based multi threaded applications.

• Worked on redesigning a windows service to a WCF service, witch was again hosted by a Windows service.

• Also, created a new module to access Data access layer by replacing a Web service with a WCF service hosted inside IIS.

• Attending trainings and prepared POCs using PLINQ.

Technologies Used: Visual Basic 6.0, C with Data Structures, C++, VC++/MFC, VB.NET, C#.NET, WCF, LINQ, PLINQ, STL and VC++.NET, ASP.NET., Windows Server 2003, Windows Server 2008, UNIX. Sybase, Serena Version Manager (PVCS), VSS

March 2009 – July 2009 Toyota Motors Inc./Terra Infotech

Consultant/Senior Developer Georgetown, KY

Win Backup and WinCRMP

Provide a method to print repair tickets when CIS is down. I Created WinBackup application which can be used at any site to print repair tickets when CIS is down due to hardware failures. Also used CSS, XML, HTML, XHTML, ASP.NET, Web Services for the whole development of project. Necessary changes to regionalize application: Service will check for database connection to data warehouse. Both of these projects were migration from VB 6.0 to ASP.NET and VB.NET and VC++ 6.0 to VB.NET.

Role:

• Design the Business Object Classes using VC++, VB.NET using OOPS/UML design principles.

• Used Data Access Application Block in the Data Access Layer.

• The Whole application was designed/developed and tested using ADM methodology by writing all kinds of Unit test cases, Impact analysis, Technical design documents, etc.

• Developed application by implementing Model View Control (MVC) design patterns.

• Used OOAD principles including UML notations to design the system.

• Developed the Business Layer and UI layer using Win Forms and VB.NET.

• Prepared Requirement Specifications, Technical Specification documents

• Created Use Case diagrams, Activity diagrams, Class diagrams, Sequence diagrams using MS Visio

• Was involved in designing the Database using RDBMS concepts and wrote Stored Procedures in SQL Server 2005

• Configuring and setting up the IIS 6.0 for both 32 bit and 64 bit Windows 2003 server.

• Creating Web Deployment projects to deploy the web applications and services on the Web Server.

• Contribution in developing Win forms and Web forms for both the applications.

• Testing of the application (Unit, Integration).

• Developed using Visual Studio 2008.

• Responsible for analyzing and designing complex modules in the application.

• Implemented EAI methodologies using TIBCO.

• Worked extensively with SQL Server 2005 including Transact SQL

• Used datasets, Data Tables, Data Readers and data grids extensively to retrieve, display, and manipulate data from the database by Using ADO.NET 2.0.

• Designing Unit Test Cases from the requirements.

• Implemented a WCF service for the interfacing requirement for other clients.

• Created a WPF application which replaced an old legacy Windows application.

• Implemented and wrote many Customized web Part controls and Web Controls using Web part manager and web part zones.

Technologies Used: Visual C++ 6.0, VB 6, VB.NET, ASP.NET, Visual C++/MFC, C, C++, Win32, C#.NET, CSS,HTML,XHTML, JavaScript. SQL server 2005. Windows XP. SharePoint Portal, MS VISIO 2003, IIS 6.0, .NET framework 2.0/3.5, Installshield.

November 2008 – Feb 2009 Toyota Motors Inc. /Terra Infotech

Consultant Georgetown, KY

CIS (Computer Inspection System) Web Applications

This is a migration project for CIS applications in Toyota, there were a set of 5 Applications which were converted from Windows applications written in VC++ 6.0 and VB 6.0 to ASP.NET 2.0 using VB.NET, this was a pending part of CIS Kaizen, which was implemented in late 2007.

Role:

• Created GUI User Controls using server controls of ASP.Net Like data grids, repeaters, textbox, button, dropdown list etc. All the validations are done using validation controls. The presentation layer is separated from the implementation using the code behind.

• Developed secure login interfaces with ASP.NET Server controls. Security features were provided using Cookies and Session Id so that unauthorized access could be denied.

• Developed business use cases, sequential, collaborative, activity and class diagrams for the enterprise presentation, and business and data access components of the system using UML.

• Designed User Controls in the Application using ASP.NET.

• Involved in designing Database Architecture and written Optimized SQL Stored Procedures.

• ADO.NET was used to implement the data layer to communicate with different databases.

• Wrote the T-SQL Database Triggers, Views, and Indexes.

• Worked on a WPF application newly for the Intranet based users in Toyota.

• Used Data Grid, Dataset and Data Reader to retrieve, display and manipulate data.

• Front end development using CSS, HTML, XHTML, JavaScript.

• Performed validations on Web Forms using .NET Validation Controls and also JavaScript.

• Working with advanced Server Controls like Data list, DataGrid, Panels.

• Designed and developed N tier architecture using .NET framework with C#.NET based on MVC.

• Used ADO.NET components like Adapter, Reader, and Dataset.

• Used TIBCO as a middleware.

• Designing CSS and Skin Templates and Implementing these Templates in Web Pages. Used Version control tool named

• Utilized Visual Source Safe for version control during development and maintenance.

• Responsible for successful planning, allocation and execution regarding maintenance and enhancements during service delivery of the project.

• Involved in Creating Stored Procedures, Views, and Triggers and Designing the tables.

Worked on the following:

Master Pages

ASP.NET 2.0

VB.NET 2.0 (Generics, Events, delegates etc.)

Multilanguage Support (Localization and Globalization).

Web Services.

XML.

HTML, CSS and JavaScript.

Web Parts Controls and Web controls

Authorization and Authentication.

Technologies Used: ASP.NET, VB.NET with .NET framework 2.0, VC++ 6.0, CSS, HTML, XHTML, JavaScript. SQL server 2005. Windows XP. VSS and MOSS 2007, .NET framework 2.0/3.5, VS 2005/2008, TIBCO.

August 2007 - July 2008 Sonata, India

Senior System Analyst Hyderabad

Booking Recall, Amend and Cancel (BRAC):

Role:

• Analysis of the specification provided by the client for Enhancements.

• Technical Development for the Enhancement in ASP.NET and HTML.

• Continuously working with the C++ and ASP.NET development teams for making the whole functionality understanding.

• Being a 3-tier, it was very much required to give technical support to the different user accessing the centralized application/Database.

• CSS, HTML, XHTML, JavaScript was implemented for the Web development part of the project.

• Using Oracle database procedures to fetch the data from Oracle tables put them into XMLs using Meta data and then using the XMLs for providing a local reference database in MS ACCESS using some VB.NET windows services.

• Writing/modifying PL-SQL procedures and getting the data for the XMLs in a loop doing it programmatically. Only the requests are sent through in parameters but the response comes from the out parameters.

• Creation of XMLs using the DOM (Document Object Model) Element Class, creating both the fields and the attributes and dynamically handling the values that needs to be set to fields.

• Using XML and XSL to convert it into a User invoice which is a PDF file, here the XMLs give the data and the XSLs give the style in which these needs to represent in the PDF.

• Implemented the MVC design pattern and used VTABLE to display the real-time data with the touch-based monitor

• To integrate with the final package into the product

• Done the Performance Bench-marking for the huge amounts of Data using ASP.NET and C++

• Implemented Web parts and embedded many customized and out of box web controls.

Technologies Used:

VC++ 6.0, VB.NET, ASP.NET, RMI, SWING, Applets, HTML, UNIX Shell scripts, Windows-NT, UNIX, LINUX, C, Oracle 9i, Merant Version Manager, Toad, Bugzilla

December 2006 - July 2007 Sonata, India

System Analyst Hyderabad, India

RAPID VISION HOVA:

A Client Server Model, where the data from Client is passed through a Secured layer using Sockets to the Server, this is analogous to MTI architecture. The major Business Logic is stored in the form of DLLs written in C, C++, VC++ and ATL COM using Visual Studio environment. This Project also handles certain Windows services implemented in VB.NET.

Role:

• Analysis of the specification provided by the client for Enhancements.

• Technical Development for the Enhancement in C, C++, VC++, ATL COM, VB and VB.NET.

• Using callback functions, which are basically called by the OS, these functions are written both in the GUI as well as the DLLs.

• Being a 3-tier, it was very much required to give technical support to the different user accessing the centralized application/Database.

• Using Oracle database procedures to fetch the data from Oracle tables put them into XMLs using Meta data and then using the XMLs for providing a local reference database in MS ACCESS using some VB.NET windows services.

• Writing/modifying PL-SQL procedures and getting the data for the XMLs in a loop doing it programmatically. Only the requests are sent through in parameters but the response comes from the out parameters.

• Using XML and XSL to convert it into a User invoice which is a PDF file, here the XMLs give the data and the XSLs give the style in which these needs to represent in the PDF.

Technologies Used: Visual Basic 6.0, C with Data Structures, C++, VC++/MFC, ATL COM, VB.NET, PRO *C, STL and VC++.NET, ASP.NET. Windows Server 2003, UNIX. Oracle 9i, Merant Version Manager, Toad, Bugzilla

September 2005 –November 2006 Sonata, India

System Analyst Hyderabad

VISION VIEW & COMPARE BOOKING (VCB):

• Requirement gathering and brain storming discussions with the people involved in the development of the application as well as the users.

• Major involvement in the GUI and MS Access Database design.

• Development of the application from scratch.

• Testing of the application.

• Also involved in creating a MSI file so that the application files can be installed across various User desktops.

• Creating MSI files for installation of the software in various client machines, this involves the dll files that need to be included, the executables of VB and VB.NET. There were no such software previously in the organization, before it was a manual process, I came and made it an automated process using the MSI.

• Standardized way of writing stored procedure following a specific pattern and naming conventions.

• Created stored procedures for maintaining Oracle Database and for supporting the Application Development to get an easy access to data objects.

Technologies Used: Visual Basic.NET 2003, C#,ASP.NET, C #, VB.NET, ADO.NET, SQL Server 2000,Oracle, Windows Server 2003, Toad

June 2004 –July 2004 Ranbaxy Laboratories

Software Trainee New Delhi, India

Server Inventory Management System

Role:

• Requirement gathering and brain storming discussions with the people involved in the development of the application as well as the users.

• Major involvement in the GUI and MS SQL server Database design.

• Development of the application from scratch.

• Troubleshooting the problems faced by peers in the ASP.NET.

• Responsible for the installation and managing connections being used by the web application from the IIS (Internet information Services).

• Wrote complex stored procedures to process Inventory records pertaining to configuration, condition and other Technical factors such as Model, Make, Accessories, etc.

Technologies Used: ASP.NET 1.1, VB.NET, MS- SQL server 2000, Windows Server 2000.

June 2003 –July 2003 IBM, India

Software Trainee New Delhi, India

Data Recovery from Hard Disk

Role:

• Requirement gathering and brain storming discussions with the people involved in the development of the application as well as the users.

• Major involvement in the GUI and System level design.

• Development of the application from scratch.

• Testing of the application and preparing the test cases as according to the business requirements.

• Doing performance testing to make the application stable even in extreme conditions.

• Using file handling concepts.

Technologies Used: C, VC++ 6.0, Windows 98.

EDUCATIONAL BACKGROUND

• Bachelor of Engineering in Computer Science, Maharishi Dayanand University, India

PROFESSIONAL TRAINING

• Customer Centric Impact (CCI) training conducted at Sonata Software Ltd., Hyderabad.

• Training on .Net Framework and VB.Net by Sonata Software Limited, Hyderabad.

• Nominated as the Best team of the Quarter by Sonata Software Ltd.

• Corporate Training by Sonata Software Limited, Hyderabad.

Contact this candidate