Post Job Free
Sign in

.NET, SharePoint, Sql Server, DB2

Location:
United States
Posted:
March 03, 2010

Contact this candidate

Resume:

R Sundar

*******.***@*****.***

Summary:

• A Microsoft certified with over 11 years experience providing full life cycle solutions as a lead in designing and developing architectures for complex systems with Microsoft technology.

• Project experience includes web-based and client-server applications in leading industries.

• Expert at bringing clarity and ease of use to complex systems and developing guidelines and frameworks for system development.

• Certified in Microsoft. Fluent in Microsoft Framework (MSF)

• Work with clients to document requirements by conducting interviews and facilitating JAD sessions.

• Develop multi-tiered object-oriented system architectures utilizing use cases, UML diagrams, Rational Rose, RUP tools and Visio.

• Developed tools for capturing Use Case Scenarios and translating into reports and object models.

• Expert in developing navigation maps and system prototypes.

• Prepared project plans and budgets. Authored proposals for submission to clients.

• Authored system and functional specifications. Specified testing objectives and acceptance criteria.

• Implemented and deployed development, staging, and production systems for a number of clients and instructed clients on the best practices for maintaining and upgrading these systems.

• Managed teams of up to 25 onsite, offshore and outside consultants.

• Identify the best practices from Client and TCS, and follow it to yield a better value addition to customer

• Experience in Resource Management, Billing and Client Co-ordination

• Lead a team to develop an internal tool to regularize and efficiently maintain the resource log, billing and allocated effort, SLA deadlines and task allocations.

• Exposure to Retail, Travel, Finance and Marketing domains.

• Possess excellent communication skills and frequently author proposals of various cultures.

Education:

M.B.A. in Systems

B. S. in Computer Science Engineering

CERTIFICATIONS:

MCSD, MCAD, MCP, CLS, CLP, MCSE, MCSE+I

Skills:

Internet IIS, ASP.NET, VBScript, JavaScript, Web Services, SharePoint 2003/2007

RDBMS Microsoft SQL Server 2000/2005, DB2, Oracle

Languages/Tools VB 6.0, VB.Net/C#, ASP, ASP.Net, Windows Communication Foundation (WCF), Java, JavaScript, C/C++, AJAX, VBScript, Web Parts, XML, XSLT, HTML/DHTML and SAML 1.1, Visual Interdev, MOSS 2007, COM Family, Compuware TrackRecord, TIDAL

Source Control MS Team Foundation Server, Visual SourceSafe, Mks Source Integrity

Others Microsoft Visual Studio, Install Shield 2007, KoFax Imaging Solution, IDAutomation Barcode Systems

Web IIS, Weblogic

Design Tools Rational Rose, UML, RUP tools and Visio

Testing Tools Mercury Quality Center, Microsoft FxCop

Reporting Tools SQL Reporting Services, Active Reports for .NET, Chart FX for .Net, Crystal Report for .Net

OS Windows 2003, Windows XP, 2000/NT/98, UNIX, DOS

Hardware Intel Pentium Machines

EXPERIENCE:

ACATS, Dallas, TX (11/2008-Present)

Automated Customer Account Transfer System

Technical Architect

This is a suite of applications to handle all the account transfers. The ACATS is developed using ASP.Net with VB.Net/C# as code behind class. The component and services were developed in C# for having the consistency with other apps. Some of the common services are developed using Windows Communication Foundation (WCF). The web application was developed using MVC (Model View controller) architecture, and WCF services are developed using Factory patterns. All these components reside in IIS 6.0.

Environment: WCF, .NET Frame Work 1.1/2.0/3.0/3.5, Web parts, C#/VB.NET, ASP.NET, Windows Services, Web Services, Ajax , DB2, SQL Server 2000/2005, XML, JavaScript, Visual Source Safe, IIS, Windows 2003 Server, TIDAL, Compuware TrackRecord, Microsoft FxCop, KoFax Imaging, IDAutomation Barcode Systems

• Involved in the complete SDLC of at least 3 different applications involving different .NET framework versions.

• Designed DTS package jobs to integrate with TIDAL interface for automated processing replacing Windows Services.

• Utilized Agile (SCRUM) Methodologies

• Requirement gathering and architecture design patterns of the application using UML/Visio

• Decision making in application and database models.

• Developed barcode solution with IDAutomation for Account Processing

• Designed document standard and solution to adhere the KoFax Imaging system protocol.

• Used ADO.Net for database connectivity in C#

• Used latest Caching Services features in C#

• The service components are implemented with C# to maintain consistency with other suite of office applications

• User Compuware TrackRecord as a replacement for regular project management tool.

• Implemented Fault Contract to catch the Exception from WCF services

• Version management using VSS (Visual Source Safe)

• Involved in identification of optimized solutions.

• Involved in arriving at finalized version of Class diagrams, sequence diagrams and design documents.

• Designed and Implemented Webservices for different interfacing blocks.

• Rich internet client app development using AJAX including Infragistics AJAX

• Logging and Tracking defects in Sharepoint defect management center

• Deployment of application in System, Integration & Production Environment

• Creation of setup and rollback plans for deployment in Production

• Involved in System, Integration & Performance Testing using Microsoft’s FxCop

Retail Automation, Minneapolis, MN (9/2007-10/2008)

Technical Architect

This is developed using ASP.Net with VB.Net/C# as code behind class. The component and services were developed in C# for having the consistency with other apps. Some of the common services are developed using Windows Communication Foundation (WCF). The web application was developed using MVC (Model View controller) architecture, and WCF services are developed using Factory patterns. All these components reside in IIS 6.0. Reporting are generated as XML files and opened in Microsoft Excel.

Environment: WCF, WPF/XAML, MS Project 2003, .NET Frame Work 3.0, Web parts, C#/VB.NET, ASP.NET, Windows Services, Web Services, Ajax , DB2, SQL Server 2000/2005, XML, JavaScript, Ms Team Foundation Server (TFS), IIS, Windows 2003 Server, Mercury Quality Center, SharePoint 2007

• Customized SharePoint architecture for collaboration portal that allowed users to view, store, share and modify standards and procedures.

• Working with IBM/COBOL to analyze the existing modules and design the functionalities.

• Developed and designed Master Pages for SharePoint by utilizing designer & Visual Studio

• Involved in the complete SDLC of the 2nd and 3rd release.

• Data serialization and graphical representation utilized .NET multithreading

• Utilized Agile Methodologies

• Requirement gathering and architecture design patterns of the application using UML/Visio

• Decision making in application and database models.

• Created templates.

• Generated Reports using SQL Server reporting Services and accessed through the web pages.

• Used ADO.Net for database connectivity in C#

• Used latest Caching Services features in C#

• The service components are implemented with C# to maintain consistency with other suite of office applications

• Installed and configured Team Foundation Server on Development and System Test environments.

• Implemented Fault Contract to catch the Exception from WCF services

• Version management using TFS (Team Foundation Server)

• Involved in identification of optimized solutions.

• Involved in arriving at finalized version of Class diagrams, sequence diagrams and design documents.

• Designed and Implemented Webservices for different interfacing blocks.

• Customized and utilized Microsoft Enterprise Library.

• Rich internet client app development using AJAX including Infragistics AJAX

• Logging and Tracking defects in Mercury quality center

• Deployment of application in System, Integration & Production Environment

• Using HPSD Service center to creation of RFC for deployment

• Creation of WBSD package in Dimensions for deployment in Production

• Involved in System, Integration & Performance Testing

• Assisted in migration from SQL Server migration

Internal Product Solutions, Worldspan L.P., Atlanta, GA (7/2004-8/2007)

Tech / Project Lead / Technical Architect

Internal Product Solutions (IPS) is a division in Worldspan. This division maintains Customer related applications, Discrepancy tracking applications, financial applications, Provider related applications, etc. This System produces the invoices for the orders placed by the customers, and the infrastructure provided by Worldspan. Complete process flow from placing an order to the billing is executed with the help of this application.

Microsoft Applications

o Debit Express: System to track the discrepancies rose by travel agents. Asp.NET / C# / Vb.NET application taken care for maintenance and enhancements.

o LINK: System to Create / maintain the customer related information. Existing VB 6.0 Application which we take care of Maintenance and enhancement.

o Configuration Management: System to maintain the Network configuration requirement of the agency/Customer to have access to Worldspan data. Existing VB 6.0 Application which we take care of Maintenance and Enhancement

 Involved in development phase for Business analysis and Requirement gathering.

 Actively participated in data collection and compilation of the User Requirement Document (URD) from the existing VB 6.0 application.

 Responsible for writing stored procedures and functions using T-SQL.

 Requirement gathering and architecture design developed using UML/Visio

 Re-engineered the VB modules into .NET class libraries using VB.NET.

 Rewritten COM/COM+/DCOM objects into Web Services/WCF.

 Component integration and new plug-ins developed with C#

 Coordinated with the team members to translate the new additional business requirements into .NET class libraries using VB.NET.

 Worked with the Microsoft COE group to build a common framework for Stores using .NET framework and VB.NET.

 Developed Web Forms in ASP.NET.

 Developed Web Services.

 Reporting has been enriched, though with mass data, using Infragistics AJAX controls.

 Wrote and executed DB2 stored procedures using DB2/COBOL and SQL Server 2000/2005.

 Managed ADO.NET accessibility across SQL Server.

 Best Utilized Microsoft Enterprise Library for designing security components.

 Created ASP.NET Web service to get user information from Active Directory.

 Reports development with Microsoft Excel objects and VB.NET.

 Implementation of SharePoint intercommunication layer.

 Assisting in SharePoint design and development

 Code Walk Through, Review and Testing

 Reviewing the unit test case documents.

 Performed integration testing.

 Created and managed installation packages for production implementation through PVCS Dimensions and WBSD.

 Coordinated with the deployment team to frame a back out procedure.

 Created support documents for transitioning ownership to the support group.

 Production support for maintaining the application

 Delivery owner for this and related suite of applications.

Reporting System, J.D. Power and Associates, Westlake Village, CA (1/2004-6/2004)

Project / Tech Lead

This product will show the survey results conducted for various car manufacturing clients in US like Mazda, Jaguar, Hyundai, Land Rover, Porsche, etc. This application includes modules like, Dealer Level, Region Level, Market Level and National level Ranking Reports. This development includes designing a Middle-tier DLL, report templates, and integrating DLLs with report pages.

 Designed and implemented the use cases and test cases.

 Implemented master pages with customization for various user roles.

 Implemented user controls that acts as a form to accept basic request details.

 Application Design implementing n-tier architecture developed with UML/Rational tools.

 Wrote Code behind business logic in VB .NET

 Extensively developed components using C#.

 Developed Web Forms in ASP.NET.

 Wrote and executed stored procedures with SQL Server.

 Collection of statistical data was submitted through the web services to the SharePoint library.

 Test Plan Review, Test Case Review.

 Designed Generic Exception handling and use of Error codes for customized error messages.

 Delivery owner from offshore.

 Designed the component interface for Active Reports with .NET.

 Active Reports integration and exposure to other applications with C#

 Designed the input XML inf file for Chart FX.

 Used Cruise Control for project requests and change requests

OSC (Online Shopping Cart), Real Rack LLC, Atlanta, GA (7/2003-12/2003)

Module / Technical Lead

This is an online shopping application. This will track all the orders that you place online and keep record of whatever goods have been delivered. This considers all the features of a commercial Shoppe, viz., Discount, Special Offer, Price Request, Invoice to your email, Order confirmation, Order(s) information, etc.

• ASP.NET Application Design implementing 3-tier architecture.

• Studied existing Java/Web Logic application

• Involved in Design and development of Authorization module.

• Coding of request and response classes in order to enable communication using C# / VB.NET with .Net Framework 2.0.

• The interface for existing modules have been established with C#.

• Involved in writing Unit test case, Use Case diagrams, Design and development of Merchant Profile and Reseller Profile.

• Involved in Design and development of Database in SQL Server 2000.

• Implemented stored procedures to save the response of the system.

• Extensively used the dataset to generate reports with Crystal Reports .NET.

• Implemented the scheduling and process Batch Authorizations requests.

• Implemented Generic Exception handling and use of Error codes for customized error messages.

• Implemented Audit and Exception logs.

• IIS Configuration.

• Deliverable product quality assurance process owner.

Online Storage Services, Real Rack LLC, Atlanta, GA (1/2003-6/2003)

Module / Technical Lead

This is an online data storage application and is used to store file, create directories, perform upload, down load operations in a remote fileserver.

• Created 3 layers In VB.NET – Common for Making the Data Dictionary, Data Layer for Database transactions, and Business layer for business Transaction. This is in order to maintain the N tier Architecture.

• Review of Unit test cases, Use Case diagrams and Design templates.

• Implemented Masterpage and themes in the design of Merchant Incubator Story Board using VB.NET and ASP.NET 2.0.

• Created Database Objects, Tables, Stored Procedure, Scalar Functions with SQL Server

• Statistical reports generated with .NET Crystal Reports

• Peer review & code review.

Wired-E!, Chamisoft Inc, Dulles, VA (3/2002-12/2002)

Team Member / Senior Developer

Wired -E! Is a simple but powerful Intra Enterprise Portal system. Including but not limited to Enterprise asset management, project management, and customer relationship management and communication platform. This system is being developed for Chamisoft Inc, to remotely and centrally manage their various physically isolated departments and consultants. In this, the first module deals with the user management system. The second one is a search engine where we can get the project details.

• Application Design implementing 3-tier architecture

• Design and development of FTP module incorporating FTP server setup and client module to interact.

• Involved in SQL Server Database Design for the Application

• FTP functionality implementation using VB.NET and ASP.NET with Framework 2.0

• Involved in development of the .NET Components for enforcing the business rules.

• Implemented CSS files for controls used in the application

• For each page there will be .JS file which defines the Validation

• Reports generated with .NET Crystal Reports

• Test Plan Review, Test Case Review, Unit Testing

• Implemented Generic Exception handling and use of Error codes for customized error messages.

Human Resource Tracking System, Techsys Online, Dulles, VA (7/2001-2/2002)

Team Member / Senior Developer

It is used to maintain a resume database from which candidates will be selected as per search criteria. Various modules were designed to handle tasks like, receiving and storing the resumes in the database, categorizing the resumes, user query handling, fetching appropriate candidates, scripts to process the data, handling various forms of requests, etc.

• Application Design implementing 3-tier architecture.

• Design and development of Weekly Plan and Quotation Graph features.

• Coding and Implementation of WSP and Quotation using VB, ASP and Oracle

• User Interface implementation with FrontPage

• Implementation of Master Page and menu controls

• Implementation of CSS and themes.

• Implemented Generic Exception handling and use of Error codes for customized error messages.

Pro-Millennium Portal (1/2001-6/2001)

Team Member / Senior Developer

This Portal involves Web Page development of the Company’s profile and activities. HTML pages were developed to validate the input at the client's end. The objective of the project is to have an access to corporate information using the Intranet. This homepage provides access to on-line information such as Human resources, Product information and the latest news updates of the company. A resume data bank is available where people can post their resumes to this site.

• Application Design implementing 3-tier architecture.

• Coding and Implementation of skeleton using VB.NET and ASP.NET 2.0

• Implementation of Master Page and menu controls

• Implementation of CSS and themes.

• Implemented Generic Exception handling and use of Error codes for customized error messages.

Flair Systems, India (1/2000-12/2000)

Video Library (9/2000-12/2000)

Team Member / Senior Developer

This application keeps track of all the tapes/discs in a video lending library. All transactions are monitored. You are also provided with features like TPIN verification, Photo verification, search database viz., actor/actress name, movie name, etc. This would suit any lending library.

• Coding and Implementation using VB and MS Access ‘97

• COM/DCOM components have been implemented to share centralized information.

• Report generation with Crystal Report

• Implemented Generic Exception handling and use of Error codes for customized error messages.

• Implemented Audit and Exception logs.

Payroll Management System (7/2000-8/2000)

Team Member / Senior Developer

This application package manages employees' information. It covers in depth all processes involved in payroll generation.

• Coding and Implementation using VB and MS Access ‘97

• Report generation with Crystal Report

• Implemented Generic Exception handling and use of Error codes for customized error messages.

• Implemented Audit and Exception logs.

Sales Analyzer, Gee Gee Computers, India (1/2000-6/2000)

Team Member / Senior Developer

This application is developed to control all the sales related dealings in the administration office. It does a statistical analysis of the items that are being sold in various cities. This application includes modules for maintaining product master index, daily transactions, account handling, update of stock-in-hand, etc.

• Coding and Implementation using VB, SQL Server and MS Access ‘97

• Designed and developed Helpdesk with reference documents.

• Regional level statistical reports generated with Crystal Report.

• Implemented 4 level of users to monitor the system namely Administrator, Auditor, Manager and Verifier.

• Implemented Generic Exception handling and use of Error codes for customized error messages.

• Prepared Test Cases and Test plan.

ZEN, Citicorp, India (12/1998-12/1999)

Team Member / Developer

The computers in the clients' place have various installation procedures. The aim of the project is to automate the installation process without manual intervention. The project was finished on time with expected level of quality.

• Project Management activities include under-standing the objectives of Project.

• Designed unattended files for automating the installation in AWK 1.2.1.

• Executed automatic scripts for at least three divisions.

• Stability review.

• Generated Windows NT/98 centralized log file for tracking.

Hospital Management System (7/1998-11/1998)

Team Member / Developer

This application maintains the records of all the patients and medicines. It also keeps track of the billing. This may be a sandwich of Inventory / Payroll package such that it records both stock as well as running information.

• Coding and Implementation using VB and MS Access ‘97

• Report generation with Crystal Report

• Implemented Generic Exception handling and use of Error codes for customized error messages.

• Implemented Audit and Exception logs.

• Functionality Vs Business mapping documents.



Contact this candidate