.Net Sql Server Business Developer Management

V I J A Y A L A K S H M I

.Net Developer

______________________________________________________________________________________

SUMMARY

Six years of Information Technology experience in software design, development and Implementation of Client/Server, Web, and Database Applications.

Experienced in developing and deploying Visual Web Parts and ASP.NET Web Parts.

Experienced in writing Server Object Model (SOM), Client Object Model. (COM) and ECMA Script in C# using Visual Studio 2012/2010/2008.

Experience in implementing advanced .NET concepts including .NET 3.0/3.5/4.0, WWF, WCF, WPF, LINQ, Team Foundation Server; Multi threading; .Net Remoting, Web Services using .NET, XML, SOAP; Objected Oriented Programming using UML, MS Visio

Experienced in creating Master Pages, Page Layouts and Application Pages.

Experienced in creating External Content Types using Business Connectivity

Services (BCS) by implementing them in Visual Studio.

Good Experience in writing LINQ Queries.

Experience in creating Sequential Workflows using Visual Studio.

Experience in SQL Server Reporting Services (SSRS).

Utilized, established development tools, guidelines and conventions including but not limited to Visual Studio, ASP.NET, ADO.NET, SQL Server, C # / VB.NET, HTML, XML, XSLT, CSS, AJAX, JQuery and JavaScript.

Experience in implementing Web Services using SOAP, WSDL, XML/HTTP and WCF technologies.

Followed TDD - Test Driven Development (Unit Testing, NUnit) approach

Experienced on Agile development (SCRUM) projects.

Hands-on experience on designing rich internet/ intranet .NET web applications over Enterprise Architect.

Good experience and knowledge in all versions of IIS (IIS 6.0, 7.0 and 7.5) and its architecture with a competent expertise on resolving application performance (High CPU, Memory leak and Crash) issues.

Extensive knowledge in debugging and created Test Plans.

An effective communicator with good analytical, problem solving & organizational abilities.

TECHNICAL SKILLS

Web Technologies : SOAPUI, XML/HTTP, HTML5.0, WCF, ASP.NET, ADO.NET, AJAX, JQuery, XSLT, CSS.

RDBMS : Oracle, DB2, MS Access, MySQland SQL Server.

Database Query Language: LINQ, XQuery.

Languages : C#, C++, VB, SQL.

Scripting Languages : JavaScript, VBScript,XML.

Bug Tracker : Bugzero, Bugzilla.

IDE’s : Visual Studio 2005/2008/2010/2012

Operating Systems : Windows 95/98, Windows NT, and Windows Server 2005/2008, XP/7

Education and Certification

Six Sigma Green Belts Certification

Cisco Certified Network Associate (CCNA)

Microsoft ASP.NET Certifications :

70-536, 70-564, Web Application development with ASP.NET Framework 4

PROJECT DETAILS

Client: MetLife Insurance, Iselin, NJ January 2011 – Current

Role: .Net Developer

Project 1: Help Now! Easy Access 6.1 NLS Version

Description: This is an Intranet application, which automates the password-reset process of an Organization. Easy Access is developed on Microsoft ASP, ASP.NET, COM, C#, IIS5.0 and SQL Server technologies. Requests from the client are formulated into a string using delimiters for each piece of data related to each transaction and stored in the database by ASP server script. The Password Engine developed in C# then pulls up this information from database, validates as per the password rule assigned to target platform and generates password. Microsoft built-in facility for COM objects developed in C# enables the data encryption and decryption process.

This tool has been enhanced into 4 major languages like Japanese, German, French and Spanish apart from existing English version. File Verification Tool, CHKPII is used to facilitate the conversion/translation of ASP pages from English to other languages.

Responsibilities:

Developed based on Service Oriented Architecture utilizing .NET Framework 4.0 with Ajax controls.

Used JavaScript to build the rich text editor with file upload options.

Used HTML and CSS for web page design and JavaScript for client side validations.

Involved in gathering requirements from the business and documenting it for the teams review.

Using WPF applications to access and manage business data.

Used extensive AJAX programming to avoid the server side overload.

Used LINQ for data communication for the web application and the databases.

Responsible for writing SQL Queries, Stored Procedures, DTS packages and Database Triggers using T-SQL.

Developed Service Oriented Architecture (SOA) based system with Windows Communication Foundation (WCF) hosting plans and coverage codes.

Implemented Exception Handling, Data Access Layer and Event logging using Microsoft Application Blocks.

Reporting to client based on requirements using SQL Server Reporting Services (SSRS).

Developed tools, created scripts, and setup systems for a one-step scripted build including unit testing, functional testing and automated the test cases.

Created and scheduled Jobs for SSIS Packages.

Customized existing WPF Client/Server application using XAML.

Involved in tuning expensive SQL queries and Stored Procedures for better performance.

Created & consumed web services in the business logic of the application.

Hosted WCF services in IIS.

Used caching to improve the performance of the application.

Used Star Team (VSS) for version controlling and configuration management.

Handled application using multithreading concepts

Environment: C#, .NET Framework 4.0, Visual Studio 2010, XML, XSLT,CSS, Web Services, SOAPUI, WSDL, AJAX, JQuery, ASP.NET, SQL server 2008, LINQ, ASP.NET, ASP, VB script, Java Script, IIS 5.0, COM, MS front Page, RSA SecureID, Windows XP/7.

Project 2: Easy Access 2.0/2.2/6.1 ID and Password Services

Role: .Net Developer

Description: This is an intranet application, which automates the password-reset process of an Organization. HelpNow EasyAccess ID and Password Services provides an automated password reset facility for Windows NT, Novell NetWare, MVS, UNIX and HelpNow ids. There are two interfaces that can be used to perform password resets:

a web interface and a programmable voice response unit interface VRU .

In addition, there is an administrative interface that will allow administrator‘s to: approve HelpNow ID registration requests; assign and verify application/system ids that can be managed by HelpNow EasyAccess ID and Password Services; add, update or delete application servers; and add, update or delete HelpNow ID records. There are two modes that this application can run in. It can be installed by itself and that installation is referred to as standalone mode. It can also be installed with the HelpNow application and that installation is referred to as integrated mode.

Responsibilities:

Developed Interactive content using Active Server Pages ASP 2.0 technology.

Implemented both Client side and Server side scripting using JavaScript.

Developed database communication from Asps using ADO

Developed Active Server Components for the enhancement of application’s functionality.

Developed functions and routines to enhance business functionality.

Used VisualStudio 2008 as IDE for developing HTML and Interactive content for the Application.

Transaction details are passed to the business logic using XML

Environment: ASP, C#, .NET Framework 4.0, Visual Studio 2010, Web Services, Java Script, IIS 4.0, COM, MS front Page, C++, STA Secure token Authentication, XML, CSS.

Client: Northern Trust Bank, Chicago, IL June 2009 - November 2010

Role: Programmer Analyst

Project 1: ID Administration 2.0

Description: The ID Administration application is being developed using XML based messaging architecture. The XML based messaging subsystem is used to communicate between each of the software components. The web layer consists of ASP and servlets processing requests from the web. In the web layer a XML message is formed, this message consists of relevant information for the target operation to be performed. For example if four users are to be added to different target machines, there will be four transaction messages built. Each transaction is a child of a parent request. The requests are submitted to transaction handler, which dispatches each transaction to the business logic engine, which spawns a new thread for each transaction. The number of thread and database connections are configured based on the load.

Business rule layer is a .Net based server, which has pools of custom worker threads waiting for requests to be processed from the request queue. This module implements the business rule logic using a custom state machine and whose rules are stored in DB2. On retrieving a request from the request queue the business rule manager assigns it to one or more worker thread s . These worker threads are responsible for executing the business rule logic. At the end of processing a response XML message is formed, which contains status of each transaction.

Responsibilities:

Worked on the development of .Net based Business Logic Engine BLE with capability to process multiple concurrent transactions

Worked on Revalidation of ID s

Worked on Batch up loader to upload data from a new installation into the ID Management software

Performance optimization of Active Server pages.

Worked on XML message transformation to WEB format

Environment: C#, .NET Framework 4.0, Visual Studio 2010, XML, XSLT,CSS, Web Services, SOAPUI, WSDL, AJAX, JQuery, ASP.NET, SQL server 2008, LINQ, ASP.NET, ASP, VB script, Java Script, IIS 5.0, COM, MS front Page, RSA SecureID, Windows XP/7.

Project 2: ID Management 1.0

Description: This is an Intranet application, which automates the password-reset process of an Organization. ID Management provides an automated User ID Management on different platforms like Help Now, NT, Windows 2005, MVS RACF, LINUX, AIX, HPUX, and Solaris . This tool is used to create, delete, suspend and resume a user Id apart from automated password reset facility for Windows NT, Windows2005, MVS, UNIX and HelpNow ids.

Responsibilities:

Developed User Interface screens using Active Server Pages ASP 2.0 technology.

Developed client side scripting for validating input data using JavaScript.

Developed entity class like InputValidator for validating user input and using C#

Developed various HTML and interactive pages using Asp.Net. Several functions and routines were developed to enhance business functionality.

Environment: Visual Studio 2008 as application server, CTS HTTP server as web server, C#, ASP, XML,, Java Script, and MySql4.0.Web Service, WSDL, SOAPUI, WCF Services, Linq.

Cognizant Internal Product Feb 2009 -May 2009

Product: Sanova

Role: .Net Developer

Description:

Sanova is a single product where students and instructors can access and purchase content using the Global pages. Products like Video Streaming Content, E-books, University Specific products and Instructor Resources are all integrated in to this product. All the Content is imported from Documentum by making calls to the Documentum web services. Students take their assignments which are provided through a third party component called Question Mark.

Responsibilities:

• Converted from classic ASP pages to ASP.Net.

• Referenced an external CSS style sheet to encapsulate all styles for the site, and then used the Master

Pages to define the overall layout of the site.

• Designed the Web Service using classic ASP using WSDL with SOAP object.

• Used Microsoft Visio to develop activity diagrams, flow charts, sequence diagrams and Data flow

diagrams to prepare the technical design documents for the use cases.

• Worked with Web Forms using different controls and also creating new custom controls.

• Written data access code that interfaces to a SQL server database, stored procedures and reports

utilizing SQL reporting and extensively used of Dataset and Data Reader classes for the same.

• Developed User Controls to reduce the Complexity in User Interface Coding.

• Client side validations are done using Java Script and .NET validation controls to provide better look

• Deployed the application on to IIS using GAC and created strong key.

• Deployed in both Testing and Development Server.

• Used Rational Rose to design Object Oriented analysis.

• Followed Incremental Software Development Methodology.

• Delivered Rich User Interface by using front-end web technologies like AJAX and JQuery.

Environment: .NET Framework 2.0, ASP.NET, JavaScript, CSS, C#, VB.NET, XML, MS Visio,ADO.NET, IIS, Visual Studio 2005, Win Forms, HTML, XML,AJAX, Active Directory, Rational Suite, Windows 2003/XP, SQL Server 2005, VSS.

Client: Discover Travels, Nov 2008 -February2009

Role: Programmer Analyst

Project: Airline Reservations Booking System

Description: Discover Travels is one of the leading online travel agencies. Their e-commerce solution has been developed to provide the customers, an access to their online services, which include Online Reservations, Cancellations, Information, Package Deals and Tour Guides.

Responsibilities:

Various HTML and interactive pages were developed using Microsoft Visual Studio2008.

Interactive content was developed using Active Server Pages ASP technology.

Both Client side and Server side scripting was accomplished using JavaScript.

ActiveX Data Objects ADO were used to communicate with data layer.

Several functions and routines were developed to enhance business functionality.

Several Active Server Components were used for the enhancement of application s functionality.

C# was used for creating COM Objects and accessed through active server pages.

Internet Information Server IIS 4.0 was used.

Data was stored in Microsoft SQL Server 6.5 database on Windows NT Operating System.

Environment: C# 3.0, Active X components, ASP, COM, DCOM, Java script, SQL Server 6.5, IIS 4.0, Visual Studio 2008, Windows NT, DHTML.

Client: Novell, Chicago, IL June 2006-October2008

Project: ZEN works Policy Management

Description: Novell ZEN works Configuration Management provides policies to configure operating system settings and select application settings. By applying a policy to multiple devices, you can ensure that all of the devices have the same configuration.

A policy is a rule that controls a range of hardware and software configuration settings on the managed devices. You can assign a policy directly to a device or a user. You can also assign the policy to a folder or group where the user or device is a member. On managed devices, each policy type is enforced by a Policy Handler or Enforcer, which makes all the configuration changes necessary to enforce or unenforced the settings in a given policy. ZENworks Configuration Management allows you to create the following polices:

Dynamic Local User Policy: Allow you to create new users and manage existing users created on Windows 2000, Windows XP, and Windows Vista workstations; and Windows 2000, 2003, and Windows 2008 Terminal Server sessions after the users have successfully authenticated to the user source.

Roaming Profile Policy allows you to create a user profile that is stored in a network path. A user profile contains information about a user's desktop settings and personal preferences, which are retained from session to session. Any user profile that is stored in a network path is known as a roaming profile. Every time the user logs on to a machine, his profile are loaded from the network path. This helps the user to move from machine to machine and still retain consistent personal settings. Windows Group Policy: Lets you configure a group policy for Windows devices. Printer Policy: Lets you configure Local, SMB, HTTP, and iPrint printers on a Windows machine.

Responsibilities:

Involved in complete designing and planning.

Owned the complete development of Windows Group Policy, Roaming Profile Policy, and Dynamic Local User Policy.

Involved in major part of data model and web service development.

Designed XML Schema

Involved in Code reviews and design reviews.

Involved in performance and scale test case reviews.

Involved in customer enhancements discussions.

Mentoring the freshers joined in the team.

Environment: Forms 4.5, Reports 2.5, C#, ASP.Net, C++, ADO.Net, SQL

Contact this candidate