Post Job Free

Resume

Sign in

.Net Sql Server Java Business Data Experience

Location:
Costa Mesa, CA, 92626
Posted:
November 09, 2010

Contact this candidate

Resume:

[pic]

Amerasan Thiruvenkadam

Career Profile

. Dynamic Software professional with over 9 plus years of professional

experience in the IT industry on developing Web and Client Server

applications using Microsoft Technologies. Sound knowledge on logic

building, conceptual programming techniques.

. Expertise in .NET Application Development, Object Oriented Programming,

Internet / Intranet based Database Applications and also developing,

testing and implementing of application software in Microsoft

Technologies.

. Hands on experience in Requirements gathering and Systems Analysis,

Design and Coding.

. Extensive experience in ASP.NET 1.1/2.0, VB.NET 1.1/2.0, C#.NET 2.0,

ADO.NET, AJAX, XML, XSLT, CSS, HTML, DHTML, VB Script, Java Script,

Visual Source Safe, WinForms.

. Working knowledge of ASP 3.0, VB 6.0, ADO, COM and DCOM objects

. Experience with .NET architecture (CLR, GC and VB.NET programming)

. Extensive experience in Data Modeling, Designing and Creating Tables,

Views, Writing Intermediate level scripts, Stored Procedures, Triggers

against SQL Server and Oracle PL/SQL relational databases.

. Extensive experience generating comprehensive Web enabled reports using

Microsoft SQL Server Reporting Services (SSRS).

. Solid understanding of Service Oriented Architecture, experience of

implementing SOA in .NET

. Experience with Web Services and N-Tier applications environment.

. Exposure in .Net Framework 3.0 / 3.5, VS.NET 2008, ASP.NET 3.5, LINQ,

Windows Communication Foundation (WCF), Windows Presentation Foundation

(WPF) Windows Workflow Foundations (WWF), .NET Framework 3.0 / 3.5.

. Experience in working with LINQ to SQL, LINQ to XML, LINQ to

Collections, Object etc.

. Experience on leading small sized team in different projects.

. Experience working with good programming standards and conventions.

. Willingness to participate in all phases of development either as a

collaborative team member or

With little supervision.

. Maintaining a positive attitude in the face of changes in work

assignments.

Technical Certification

. Microsoft Certified Solution Developer for Microsoft .NET (MCSD)

. Microsoft Certified Application Developer for Microsoft .NET (MCAD)

. Microsoft Certified Professional for Microsoft .NET (MCP)

Technical Skills

Operating Systems Windows Vista/XP, Windows 2003/2000/NT,

Windows 9x

Languages C#.NET, VB.NET, VB 6.0, JAVA, C++, AS400/COBOL

Framework .NET Framework 3.5/3.0/2.0/1.1/1.0

Databases MS-SQL Server 2008/2005/2000, Oracle 9i, MS-Access

2000/97,

AS400/DB2

IDE Visual Studio.NET 2008/2005/2003, VSTS Team system

Web Technologies ASP.NET 3.5/2.0/1.1/1.0, ASP 3.0, AJAX, HTML, XHTML,

DHTML, XML, XSL, XSLT, DTD, VB Script, Java Script,

jQuery.

Distributed Technologies WCF, WPF, WF, .NET Remoting, Web Services and

SOAP.

Source Control Visual Source Safe 2005/6.0

Reporting Tools Crystal Reports.NET, MS-SQL Server Reporting

Services 2005/2000

Web Server IIS 7.0/ 6.0/5.1/ 5.0

Education

Master of Computer Applications, Bharathidasan University, India.

Professional Experience

Orange County Probation Department, CA

Feb'2010 to Present Date

IPFS

The Integrated Probation Financial System (IPFS) is developed to maintain

the court ordered financial obligations of probationers. The financial

obligations which include restitution, fines, cost of probation etc. The

system also interacts with the Probation departments the Integrated Case

Management System (ICMS) to extract the existing probationer data.

Responsibilities

. Involve migrating AS400 COBOL /DB2 application into .NET web

application with C# programming language and back end of SQL Server

2005.

. Assist the team to identify business, functional requirements and the

ease of application development techniques.

. Design and develop user-friendly web pages and reusable user controls,

classes, functions using ASP.NET, C#, AJAX Web Extensions.

. Write Stored Procedures, User Defined Functions, and Common Table

Expressions to retrieve the data from databases.

. Use ADO.NET techniques to the access data from different databases.

. Utilize AJAX web development techniques for creating user interactive

web pages.

. Use SQL Server Reporting Services (SSRS) to generate different

financial obligations report of the payor.

. Use XML Web services to provide auto complete features in the web

pages.

. Helped writing data access business logics to develop Windows

application to maintain cashiering and the disbursement info using

C#.NET.

. Helped generating a different automatic Statement of Cost report for a

given Court Order financial obligations of the payor.

. Merge project modules as a single application with unit testing.

. Troubleshoot, debug, and fix bugs at various stages application

development with unit testing and final testing.

Environment: Visual Studio.NET 2005, ASP.NET 2.0, C#, ADO.NET, IIS 5.1/6.0,

AJAX, Java Script, jQuery, AS400 COBOL /DB2, Microsoft Visual Source Safe

2005, MS-SQL Server 2005, Stored Procedures, SQL Jobs, XML Web services,

Microsoft SQL Server Reporting Services (SSRS), Windows XP / Windows 2003.

Orange County Probation Department, CA

Sept'2008 to Dec'2009

ICMS

The Integrated Case Management System (ICMS) is developed to manage a

variety of departmental functions involving probationers. The web

application has been designed to draw all probationer information into a

minimum number of user interfaces, such as the probationer's profile

information, terms and conditions of probation, case plan, officer safety

issues, required registrations, statuses, drug test results, victims and

financial payments etc.

Responsibilities

. Participated in planning, designing overall technical architecture to

integrate and centralize all window applications and web applications

in support of business requirements.

. Helped in identifying technological opportunities to support the

organizations tactical and strategic business plan and objectives.

. Migrated Case Management System of AS400/DB2 with COBOL language into

.NET web application with ASP.NET, C# programming language and back end

of SQL Server 2005.

. Migrated Juvenile Intake Assessment System of AS400/DB2 with JAVA

language into .NET web application with ASP.NET, C# programming

language and back end of SQL Server 2005.

. Used SQL Server Integration Services (SSIS) to do a broad range data

migration tasks.

. Extensively used SQL Server Reporting Services (SSRS) and XML Web

services to generate all case related daily reports and month end

reports etc.

. Designed and developed a portal application to maintain the issues and

feedbacks about the ICMS core applications using ASP.NET, VB.NET and

SQL server 2005.

. Used VB.NET along with SQL Server Reporting Services (SSRS) to create a

various custom made functions to do a different case related reporting

calculation.

. Developed and consumed web services for providing auto complete text

features and XML data sources to generate all system required reports.

. Used ADO.NET methodologies for transmitting the data between the

database and web interfaces

. Wrote stored procedures, user defined functions, views to retrieve data

from the database tables.

. Used Java Script and AJAX web development techniques for creating user

interactive Web Applications.

. Used Windows Services to send emails on all the major activities of the

system.

. Developed WinForms to maintain any new data in case of any maintenance

on core systems.

. Used Microsoft Visual Source Safe (VSS) for the purpose of version

control and source code sharing.

. Worked directly with the users of the system to identify their business

processes and functional requirements.

. Developed user documents for the users.

. Troubleshoot, debugged, and fixed bugs at various stages application

development with unit testing and final testing.

. Merged all the projects, modules and unit tested as a single

application.

Environment: Visual Studio.NET 2005, ASP.NET 2.0, C#, VB.NET, ADO.NET, IIS

5.1/6.0, AJAX, jQuery, AS400/COBOL/JAVA, AS400/DB2, Microsoft Visual Source

Safe 2005, MS-SQL Server 2005, Stored Procedures, SQL Jobs, SQL Server

Integration Services (SSIS), XML Web services, Java Script, Microsoft SQL

Server Reporting Services (SSRS), Windows XP / Windows 2003.

Intel Corporation, CA

July'2007 - June'2008

DTS

The Design and Technology Solutions (DTS) online applications provide a

various facilities to track bugs, issues and enhancements on the devices

like motherboard chipsets, network cards and ICs, flash memory, graphic

chips, embedded processors, and other devices related to communications,

computing and their new inventions.

Responsibilities

. To understand the Business and Functional requirements.

. Involved in data analysis to develop and design solutions for

moderately complex processes according to specs, and performing unit

and integration testing.

. Developed flexible, user-friendly and more user interactive Web Pages

and reusable classes, functions using ASP.NET, C#.

. Migrated classic ASP applications into .Net Framework 2.0 applications.

. Migrated applications from Visual Studio 2003 (.Net Framework 1.1) to

Visual Studio 2005 (.Net Framework 2.0)

. Helped the team to upgrade MS SQL 2000 to Yukon (MS SQL Server 2005).

. Installed and maintained MS SQL Server 2005.

. Used SQL Server Integration Services (SSIS) to migrate data from SQL

server 2000.

. Supported MS SQL Server database activities.

. Used ADO.NET technology for transmitting the data between the database

and the user interfaces and web interfaces.

. Developed XML Web services for transmitting the data in XML format

between the database and the user interfaces and web interfaces

. Configured web.config files for ASP.NET Web Forms and the entire Web

Application.

. Wrote Stored Procedures and Triggers as required for the application.

. Used DCOM and COM objects to upload the huge size of data files.

. Used custom controls which build with AJAX web development techniques,

methods for creating user interactive Web Applications.

. Used Java Script for client's validation.

. Used Microsoft Visual Source Safe (VSS) for the purpose of version

control and source code sharing.

. Troubleshoot, debugged, and fixed bugs at every stage application

development with unit testing and final testing.

. Worked directly with the users of the system to identify their business

processes, rules and application user requirements

. Merged all the projects, modules and unit tested as a single

application

Environment: Visual Studio.NET 2005/2003, ASP, VBScript, ASP.NET 2.0/1.1,

C#.NET, ADO.NET, IIS 5.1, AJAX, jQuery, Microsoft Visual Source Safe 2005,

MS-SQL Server 2005/2000, Stored Procedures, Triggers, Cursors, SQL Jobs,

SQL Server Integration Services (SSIS), XML Web services, Java Script,

Windows XP.

American Youth Soccer Organization, CA

Jun'2006 - June'2007

AYSO

AYSO is a nationwide non-profit organization that develops and delivers

quality youth soccer programs in a fun, family environment based on AYSO's

Five Philosophies: Everyone plays, Balanced Teams, Open Registration,

Positive Coaching, Good Sportsmanship enables the ability for over 1000

regions to register their players and volunteers online, maintain their

board information, balance teams, print rosters, conducts courses, etc. The

application also automates the business process happening at the national

office (NSTC). The web applications have been matured to the level where

parents can register their kids and pay online for which the fund directly

goes to the respective regions account. Apart from region classifications,

group of regions are categorized in to areas and group of areas forms a

section totaling up to 16 sections.

Responsibilities

. Understand the Business and Functional requirements.

. Designed and developed the technical detail design documents.

. Developed flexible, more user interactive and user-friendly GUI's and

Web Pages, reusable classes, functions, etc.

. Developed various Classes, Modules, and Assemblies for e.g. Player

Registration and Team Balancing using ASP.NET, VB.NET.

. Application is designed using proper implementation of OOP concepts

like Abstraction, Encapsulation, Inheritance and Polymorphism.

. Implemented Garbage Collection for optimal performance, efficiency and

free up the resources.

. Migrated applications from .Net Framework 1.0/1.1 to .Net Framework 2.0

. Developed XML Web services for years, months and days conversions.

. Simple Object Access Protocol (SOAP) being portable and able to

traverse firewalls has been used for calling web services.

. Used ADO.NET technology for transmitting the data in XML format between

the database and the user interfaces and web interfaces.

. Used multi-threading to process the different tasks simultaneously as

part of the required functionality.

. Utilized COM and DCOM objects and methodologies as required.

. Configured web.config files for ASP.NET Web Forms and the entire Web

Application.

. Wrote Stored Procedures and Triggers as required for the application.

. Used AJAX to send and receive data between a web browser and a web

server.

. Used Microsoft Visual Source Safe (VSS) for the purpose of version

control and source code sharing.

. Created, fixed and generated reports for various individual player

statistics, family statistics, events and activities using SQL Server

Reporting Services (SSRS) and Crystal Reports.

. Troubleshoot, debugged, and fixed bugs at every stage application

development with unit testing and final testing.

. Merged all the projects, modules and unit tested as a single

application

Environment: Visual Studio.NET 2005, ASP.NET 2.0, VB.NET, ADO.NET, IIS 5.1,

SOAP, XML Web services, Microsoft Visual Source Safe (VSS), MS-SQL Server

2005, Stored Procedures, SQL Server Reporting Services 2005, Crystal

Reports 9.0, AJAX, Java Script, Windows XP.

Motorola Inc, IL Nov'

2005 - May' 2006

ChangeNet

The ChangeNet is an online repository for managing change at Motorola. It

provides a variety of resources to help you lead, facilitate and manage

change across the business. While there is no one secret recipe for a

successful change project, the tools and resources you'll find here can

improve the likelihood that your project's objectives are realized.

Responsibilities

. Involved in Component Design, prototyped the necessary Business and

Data layer Components in C# and created Dynamic Web Pages using

ASP.NET Web Pages.

. Worked directly with the users of the system to identify their

business processes, rules and application user requirements.

. All User Interface layers Web Pages are created and integrated to

maintain the performance of data flow and data integrity using

ASP.NET, C#.NET and ADO.NET

. Designed and developed the .NET assemblies, classes, modules and

business components.

. Involved in writing Stored Procedures and Query's to retrieve and

manipulate data.

. Used ADO.NET technology for transmitting the data in XML format

between the database and the user interfaces and web interfaces

. Used SQL * Loader for importing the data from external files into

Oracle database tables.

. Application implements the OOP concepts and methodology.

. Leading team of six members in developing the project.

. Used Java Script for client's validation.

. Performed Unit and Integration testing.

Environment: Visual Studio.NET 2003, ASP.NET 1.1, C#.NET, ADO.NET, IIS 6.0,

Java Script, SQL * Loader, Oracle PL/SQL, Packages, Stored Procedures and

Windows 2003.

Trinity Mirror Plc, UK Apr'

2005 - Oct'2005

Talent Management

This is the personal online system of employees for dealing with all the

aspects of Learning and Development in Trinity Mirror. Here the system

provides a variety of online tools which helps to manage and develop an

individual and the team. Hence the system identifies the knowledge,

experience, skills and behaviors that will be required in both the short

and the long-term by the company and seek to ensure that they are made

available.

Responsibilities

. Designed and developed Presentation layer in ASP.NET with code behind

language as C#, HTML and DHTML.

. Responsible for developing class libraries to implement Configuration

and Database connections using C#.NET.

. Written Stored Procedures and Query's to retrieve and manipulate data

using ADO.NET

. Implemented the system and tested with Client's live data

. Implemented new functionalities in the User Interface and Application

logic using C#, ASP.NET and Java Script.

. Generated XML to pass dynamic data's to application for configuration

and connecting to the database.

. Debugging of the application logic if the report fails to give a

result.

. Prepared testing documentation, user documentation and technical

documentation.

Environment: Visual Studio.NET 2003, ASP.NET 1.1, C#.NET, ADO.NET, IIS 5.0,

Java Script, Oracle PL/SQL, Stored Procedures and Windows 2003.

Brite Group Ltd, UK

Mar'2004 - Mar'2005

VAuditions

VAuditions stands for 'Video Auditions'. VAuditions is an exciting, new and

unique way for professionals, or anyone wanting to break into the world of

performing art - regardless of experience and prior knowledge of the

industry - to be seen and recognized within the industry.

Responsibilities

. ASP pages are transformed to ASP.NET Web Forms, taking into

consideration all Properties, Data types, Object conversions and

incorporating namespaces.

. Created Data layer Components in VB.NET and Dynamic Web Pages using

ASP.NET Web Pages

. Written class library in VB.NET to handle multiple files uploads and

written code for sending email programs.

. XML Schemas and XML namespaces are used for data transfer.

. Implemented Forms Authentication in ASP.NET to authenticate the users.

. Created Stored Procedures and Query's to retrieve and manipulate data

. Written class library in VB.NET for application configuration and

database activities.

. Migrated classic ASP application into ASP.NET 1.1 application (.NET

Framework 1.1).

. Used DCOM and COM objects to access the existing Video/Audio files.

. Prepared User Documentation and technical documentation.

. Used Java Script for client's validation.

. Performed Unit and Integration testing

Environment: Visual Studio.NET 2003, ASP, VBScript, ASP.NET 1.1, VB.NET, VB

6.0, ADO.NET, IIS 5.0, XML Schemas and XML Namespaces, Java Script, SQL

Server 2000 and Windows 2000.

Brite Group Ltd, UK

Jan'2003 - Feb'2004

Ask Guru

AskGuru is an intelligent Q&A software tool. It enables employees,

customers, suppliers or even shareholders to ask inquisitive and formal

questions on a breadth of subjects and in return receive an accurate answer

within 3-5 seconds. AskGuru is an automated self learning optimization tool

using natural language. Its capability creates, builds and manages your FAQ

and general knowledge base. It enables you to seamlessly and creatively

bring knowledge experts from across your business together 24x7 365 days a

year.

Responsibilities

. Designed and Implemented Web Forms by using ASP.NET, VB.NET based on

new logic/processes.

. Design and Development of Business Components using VB.NET.

. Generated Reports through MS-SQL Server Reporting Services 2000

(SSRS).

. Created Stored Procedures and Query's to retrieve and manipulate data.

. Designed and developed Presentation layer in ASP.NET with code behind

language as VB.NET, HTML, and DHTML.

. Involved in Troubleshooting of Centura and VB application with the

customer databases & fixing the bugs.

. Used ODBC programming concepts to import data from Microsoft Excel

worksheet into SQL server data base table.

. Code on client side program developed in Java Script

. Performed Unit and Integration testing

Environment: Visual Studio.NET 2003, ASP.NET 1.1, VB.NET, IIS 5.0, Java

Script, SQL Server 2000, Stored Procedures, MS-SQL Server Reporting

Services 2000 (SSRS) and Windows 2000.

Better My Quote Ltd, UK

Nov'2001 - Dec'2002

Better My Quote

The online Better My Quote for the cheapest quotes. Just complete our

online forms then Better My Quote will look for the best value deal around.

You decide how much you want to spend and when you want to receive your

quote by No more spending countless hours on the telephone, Internet or

waiting for companies to get back to you with their price.

Responsibilities

. All User Interface layers Web Pages are created and integrated to

maintain the performance of data flow and data integrity using ASP.NET

and ADO.NET.

. Created Data layer Components in VB.NET and Dynamic Web Pages using

ASP.NET Web Pages

. Design and Development of Business Components using VB.NET

. Created Stored Procedures and Query's to retrieve and manipulate data

. Responsible for Coding and Testing.

Environment: Visual Studio .NET 2002, ASP.NET 1.0, IIS 5.0, VB.NET,

ADO.NET, Java Script, SQL Server 2000, Stored Procedures and Windows 2000.

Brite Group Ltd, UK

Apr'2001 - Oct'2001

E-Recruit

This web enabled system helps the consultancy to recruit people in online.

The candidate can directly log on to our Web Site to post their resumes.

This system applies fuzzy logic to shortlist resumes and sends to the

client based on the requirements. The unmatched resumes would be rejected

and also the system validates to avoid the redundancy of resume to the same

client.

Responsibilities

. Designed and developed Presentation layer in ASP, HTML, and XHTML.

. Responsible for development of Connecting to SQL Server and accessing

the information using ADO.

. Responsible for creating Stored Procedures, query's in SQL Server for

handling data in the application.

. Code on client side program developed in Java Script and VB Script.

Environment: ASP 3.0, IIS 5.0, VB Script, Java Script, SQL Server 2000,

Stored Procedures and Windows 2000.



Contact this candidate