Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Edison, NJ
Posted:
June 05, 2014

Contact this candidate

Resume:

acegg6@r.postjobfree.com

Ph: 203-***-****

[pic]

. Has extensive IT experience in Design and Development of Various

Application Systems for E-business, Finance, Inventory Management,

Stock control and Billing, Hotel Management, Pharmaceuticals,

Manufacturing Industries and U.S. Corporate Tax.

. Extensive design and programming experience using VB.NET, C#.NET, VB,

VBA, ASP, ASP.NET, AJAX 1.0 and AJAX 3.5. XML, COM, ADO.NET, XSL, XSLT

and CSS, and Oracle 9i, SQL Server 2000/2005/2008, Source Safe -

Serena Change Man Version Manager 8.1.

. Expertise in Database Design and Database Programming (Stored

procedures, Triggers, Packages, PL/SQL) using SQL Server 6.5/7.0 /

2000 / 2005/2008/2012 and Oracle 7.3 / 8.0.

. Over 8+ Years of experience in development of applications using

VB.NET, C#.NET and ASP.NET.

And SQL Server 2000/2005/2008/2012, Oracle 9i.

. Extensively used ADO.Net with VB.Net, C#.Net, ASP .Net to connect

Presentation layer with DAL using MS SQL Server 2008 and SQL Server

2012 Database. Designed & Developed Reports using Crystal Reports.

. Involved with client in all phases from requirement gathering till

deployment in the whole SDLC.

. Extensive experience with Web based, Client-Server and N-tier

Architectures.

. Experienced in different phases of software development cycle

including Strategic Systems Planning, Designing, Programming, Testing,

Documentation, and Presentation to clients and preparing customer

specifications as part of software technical requirements and Customer

support and Production Support.

. Extensive exposure to object-oriented analysis, Object Oriented Web

Development Programming / Designing and implementation in a multi-tier

application development environment.

. Extensively developed Web Services and consumed in various

application.

. Has Knowledge about Entity Frame Work, MVC, JQUERY, WCF and WF but has

not been deployed in the project.

. Experience in Database Backup, Recovery, Performance tuning, Query

optimization using Database Engine Tuning Advisor.

. Worked as a Team Lead on Onshore and offshore project model.

. Excellent communication, interpersonal skills and self motivated to

implement next-generation paradigms.

Internet ASP.NET 1.1, ASP.NET 2.0, ASP.NET 3.5, WCF and WF etc.,

Technologies

RDBMS MS Access, Oracle9i/8i/7.x, SQL Server

7.0/2000/2005/2008

GUI Visual Basic 5.0 & 6.0

Operating Systems Dos, Windows 95/98/2000/XP, NT 4.0, Unix, Sun Solaris

5.6, Linux

Languages VB.NET, C#.NET, C, T-SQL, HTML, DHTML, VBScript, Java

Script, AJAX 1.0, AJAX 3.5, XML, XSD and XSLT.

Web Designing Visual Studio. NET, Microsoft Interdev, Front Page'98,

Tools 2000, 2005, 2008, 2010 and 2012.

Web Servers Win 2000 Advanced Server, IIS 6.0, Apache web server,

Personal web server

Reporting Tools: Crystal Reports 8.0/7.0/5.0, Data Reports

Software Packages MS Office

Case Tools UML, Visio, Crystal Reports

PROFESSIONAL EXPERIENCE:

Client: Commonwealth Financial Network, Waltham, MA

Project Name: CommAve, CommunityLink and other Tools 02/2013

- till-date

Sr. Developer

CommAve: This is a portal for Commonwealth Financial Network which render

access to Financial Advisors and Commonwealth Employees. This portal

consists of various applications like Accounts Maintenance, Quarterly

Statements, Statement Admin Tool, Client 360, Practice Management 360 and

much more. I have consolidated the existing applications into different

group. The new structure I have designed and developed and deployed.

CommLink: This is a website which is used by Financial Advisors and

Commonwealth Employees. This website has about 22 different widgets like

Alerts, Assets Under Management, News and Special Features, CRM Calendar,

Follow-up Required, Market Summary, Statistics, Surveys, Business Snapshot

and Weather etc. Initially we had about 22 different assembly for each

widget. I consolidated all the 22 assemblies into ONE single assembly

server controls. I refactored the existing assembly codes and deployed

successfully into production.

P360: This is an another application for the clients who can handle their

business efficiently. This application has tools like Daily Summary,

Business Trends, Advisors Documents, Compliance, Reports, Document

Management and Administration etc.

File Download Tool: Developed a windows based application to handle the

data feed comes from NFS through ACD data server. This application talk to

ACD data exchange server and pull the data stored in XML format in a

secured repository (File server) based on SQL job.

Active Directory Login: This assembly allow the users (Financial Advisors

and Employees) to login using Active Directory credential. It validates

necessary security parameters after successful validation it allow the user

to navigate to company portage page.

Responsibilities:

. Had several meeting with Business Owners for requirement gathering.

. I have re-designed the existing application code.

. Played as lead to handle the team for application integration.

. Played significant role in the UI design and development.

. Extensively involved in UI design using Web forms.

. Handled RAD Controls Telerik, Tree Grid, Infragistics 7.3 to handle

the grid functionality.

. Kendo UI components has been used in the StatementAdmin and Report

Library application.

. Used HighChart libraries to generate Bar Charts.

. Modified and Created new Stored Procedures as per requirement.

. For the client validation Java Script and JQuery has been used almost

in every application.

. Design and developed multiple Master page, User controls, Ajax Toolkit

for the ASP.Net pages and implemented them in various pages. The

developed code versioning has been maintained using TFS VS-2012.

. Written Technical Specification documents as Community Wiki.

. Complete support has given during various releases for the above

mentioned application.

. Complete support has given in the Application deployment. Production

support has given to various clients.

Client: Curriculum Associates Inc., MA 01/2011

- 01/2013

Project Name: Brigance Online Management Systems

Sr. Developer/Lead

Brigance online management systems have various products like Special Ed,

Early Childhood and Head Start etc. This online management system is mainly

supplied to leading schools across the nations. The system helps the

teacher and parent to evaluate the children personal activity performance

(Age old from 0 to 15 years). It gives various suggestions to improve

children personality. The system generates question covers the subjects

like Social Emotional behavior, Literacy on English, Science and

Mathematics. Once the teacher / parent entered answers for the questions

then the system will generate various reports and charts based on the

analysis. The individual reports would be generated like Skills Mastered

Summary progress report, Skills Mastered Individual report, Goals and

Objectives, Present Level of Performance report. It also generates group

reports like Group progress report, Group Detail report for the entire

region, individual school, individual department, and individual child. The

questions structures are developed using Obout controls and various charts

(Bar graph and Pie chart) are generated using Corda chart tool. The online

management system has different version like U.S and Canada. Based on the

version the date control functionality has been implemented.

The above mentioned online management system is developed in Visual Studio

2008 using C#.net, Asp.net, SQL Server 2008 with multiple databases. The

bug tracking tool Bugzilla and Rally has been used to improve and keep

track of all the development activities. This system has facility to import

and export students and Screens data in the form of spreadsheet or CSV

file.

Responsibilities:

. Coordinated with Client for requirement gathering.

. Complete Production support has given based on the client's

requirement.

. Played significant role in the UI design and development.

. Extensively developed User interfaces using ASP. NET Forms.

. For front end development used ADO.Net with C#.Net, ASP.Net, AJAX

Control Tool Kit 3.5 and inline SQL queries / Stored procedures are

used for the Back end process.

. Written various Stored Procedures, Modified existing Stored Procedures

based on the user's requirement.

. Handled XML to SQL data conversion. Corda Chart tool was used to

generate Bar Charts.

. Handled various Reports to improve performance.

. For the client validation Java Script has been used almost in every

application.

. Design and developed multiple Master page, User controls for the

ASP.Net pages and implemented them in various pages.

. I have maintained different products (Brigance Head Start / Early

Childhood / Special Ed (US/Canada) code has been maintained using

Microsoft Visual Source Safe 6.0 .

. Extensively involved in the Unit Testing.

. Written Technical Specification documents.

. Complete support has given during various releases of the products for

U.S version and Canada version.

. Complete support has given in the Application deployment. Production

support has given to various clients.

Client: Amtrak, Washington, DC 05/2010

- 11/2010

Project Name: ASIS - Amtrak Safety Information Systems

Technical Lead

ASIS is Amtrak Safety System provides the users to monitor and maintain

their Employee safety and public safety while travelling in the train.

Claims is one of the core section of this application provides

Administration, Case maintenance, Collections and Reports.

Claims Administration module facilitates to the Admin user to handle the

claims users to grant or revoke the privileges to access different modules

belong to the Claims. This module also has an option to Create / Update /

Delete offices for the Claim Agents and the Manager. Admin module can able

to transfer the cases from one Agent to another Agent. It also merges the

cases of the two different Incidents. Claims module has ability to monitor

the collections from the Passenger / Employee and settlement detail for the

specific cases. It also generates the pending logs for the case by period

and statewide.

Claims reports has been designed and developed by using Crystal report and

the following significant reports were generated:

1. Auditing Reports

2. Financial Management Reports

3. Workload Management Reports

4. Incident Reports

5. Lookup and Search tools

This application was converted from Classic ASP to ASP.Net and developed by

using .Net Frame Work 3.5, ASP.NET, C# and Crystal Report 10.5.

Responsibilities:

. Participated with Client for requirement gathering.

. Involved in the UI design and development.

. Developed User interfaces using ASP. NET Forms.

. Extensively used HTML and DHTML technique.

. Used ADO.Net with C#.Net, ASP.Net, AJAX Control Tool Kit 3.5 in the

Back end process.

. Extensively created and used Web Services in the application.

. Created various Stored Procedures, Modified Stored Procedures based on

the user's requirement.

. Extensively used Java Script for the client side validations.

. Design and developed multiple Master page, User controls for the

ASP.Net pages and implemented them in various pages.

. Extensively used Microsoft Visual Source Safe 6.0 for versioning the

source code.

. Involved in the Unit Testing

. Complete support was given in the Application deployment.

. Coordinated with Client for Production issues and Enhancements.

Environment: Visual Studio 2008, ASP.NET 3.5, C#.NET, ASP Forms, ADO.NET,

AJAX Control Tool Kit, JavaScript, XML, XSD, XSLT, IIS 6.0, SQL Server

2005, CSS, Windows XP.

Client: Unilever, Trumbull, CT 10/2009

- 03/2010

Project Name: MDA - Master Data Application

Sr. Developer

MDA is an Enterprise application which helps the user to define the product

request using SCP (Supply Chain Management). Once the request is created by

the user it has to undergo different approval process from different

department like DMO, Finance, Sales, Quality Control, Promo Admin. Once

all the approval is done the final DU Material (Distribution Unit material)

entry would be approved by DMO. The approved DU's would be transferred to

concern department through SAP. This application was developed in .Net

Framework 3.5 using C# and TOAD SQL Server 2005. This application was used

by approximately 215 users. In this application major control objects like

Grid view, ASP.Net Tree controls were used through third party tool called

Obout controls and Infragistics.

Responsibilities:

. Coordinated with Client for Production issues and Enhancements.

. Played significant role in the development and deliverables.

. Developed User interfaces using ASP. NET Forms.

. Extensively used HTML and DHTML technique.

. Used ADO.Net with C#.Net, ASP .Net, LINQ, AJAX Control Tool Kit 3.5

in the Back end process.

. Developed the Business Logic using C#.Net.

. Extensively developed Web Services and consumed the services in the

application.

. Generated Stored Procedures, Modified Stored Procedures based on the

client requirement.

. Extensively used Java Script for client side validations.

. Design and developed Master page, User controls for the ASP.Net pages

and implemented them in various pages.

. Extensively used Source Safe - Serena Change Man Version Manager 8.1

for versioning the source code.

. Involved in the Unit Testing

. Coordinated in the Data Migration

. Complete support was given in the Application deployment.

Environment: ASP.NET 3.5, C#.NET, ASP Forms, OOAD, ADO.NET, AJAX Control

Tool Kit, JavaScript, XML, XSD, XSLT, IIS 6.0, SQL Server 2005, TOAD SQL

2005,Obout controls, CSS, Windows 2003 Professional.

Client: Nestle Holdings Inc. Norwalk, CT 11/2006

- 09/2009

Project Name: Roseland - Tax Return

Team Lead / Sr. Developer

Developed following Applications:

1. Roseland - Corporate Tax Analysis - Visual Studio 2008 (ASP.NET 3.5 /

VB.NET 3.5)

2. RITS - Records Information Tracking Systems - Visual Studio 2005

(ASP.NET 2.0 / C#.NET 2.0)

3. RITS Admin Tool - Administration tool for Records Department - Visual

Studio 2005 (ASP.NET 2.0 / C#.NET 2.0)

Supporting Tools:

1. DQM - Data Query Manager (Query Analyzer)

2. GLValidation Tool - Data migration tool

Description: Roseland is a powerful web-based application for the tax

reviewer and tax preparer of the Nestle Tax Department. This application

gateway is Team Roster and it has a Portal page with multiple modules of

Federal, State and International and it navigates through powerful

Dashboard page. The Portal and Dashboard page is an anchor pages and user

can navigate across the different modules, navigates across sub modules in

more granular and also can zoom-in and zoom-out of the tax accounts for

multiple entities for any tax year period. Tax preparer can raise the

questions for different Tax SKU and also can generate comments for the

selected Tax SKU. This application also has a search tool for Tax SKU for

multiple entities and for different tax year. LinQ to SQL Server queries

were built using DBML files for datasets definitions. Multiple Joins were

used in complex LinQ in DAL.

It also powered with Data Query Manager Tool which helps the user to get

the desired query result or the user could customize the query as they

required. This application generates the reports of Schedule-1, Form-1120

and Schedule-M3 etc. for the tax return.

This application has the capability to upload different types of Tax

documents (like doc, xls, txt, pdf,etc.) across the servers. Roseland also

has a provision to send email alerts to the Tax Portal Users.

RITS application is the Record Information Tracking System which helps

approximately 300 users of the Records Department to keep track of their

various Records belongs to different department categories. This

application generates various reports like Label printing and Inventory

status. It allows the user to order Boxes to ship their records to various

storage locations and order can be confirmed through email. This

application also maintains the Stock about the issues of Boxes and Labels

to the various Records Department for shipping their records to Iron

Mountain. It also generates a Stock Register in the Box Type-wise and Label

type-wise.

GLValidation Tool: This is a stand-alone powerful tool helps the Tax

Department, they get the audited GL data from the Account department which

ran by SAP department, it consists of 100's of mega size flat files which

would be imported by using this tool and this application would scan all

the received flat files, checks the data format with the data layout, it

generate the error log shows up all erroneous files Entity wise those

doesn't match up with the data layout. It also maintains the meta data of

the imported files, once the data was imported then it valid the complete

GL data and it also prepare the Balance Sheet, eventually it compares with

the received Balance Sheet from the Audit department, if any discrepancy

found it would shows all GL A/c. entries with differences.

Responsibilities:

. Coordinated with Client for system gathering and in designing.

. Prepared project budget, plan and delivery schedules.

. Developed Mocks Screens.

. Involved in the Database design.

. Lead the team in the development and deliverables.

. Developed User interfaces using ASP. NET Forms.

. Extensively used HTML and DHTML technique.

. Used ADO.Net with VB. Net, C#.Net, ASP .Net, Entity Frame work, LINQ,

AJAX Control Tool Kit 3.5 in the Back end process.

. Built complex queries using LinQ to SQL joining multiple Tables and

Views.

. Used DBML files for multiple DATASETS definitions.

. Developed the Business Logic using and VB .NET and C#.Net.

. Extensively developed Web Services and consumed the services in the

application.

. Involved in DBA tasks such as SQL Server Installation, Server

configuration, database creation, schema handling, maintenance, and

performance tuning and query optimization.

. Implemented client side validations using Java Script.

. Design and developed Master page, User controls for the ASP.Net pages

and implemented them in various pages.

. Developed Threading functions in retrieving data from the back end.

. Email functionality incorporated to send the alert messages to the

users.

. Reports were generated through Microsoft Report Viewer control.

. Reports were Exported the data to Microsoft Excel and PDF.

. Involved in the Unit Testing

. Coordinated in the Data Migration

. Complete Production Support was given after Application deployment.

. Developed Functional Spec and Technical documentation for all the

above applications.

Environment: ASP.NET 3.5, ASP.NET 2.0, VB.NET, C#.NET, ASP Forms, OOAD,

ADO.NET, AJAX Control Tool Kit, JavaScript, XML, XSD, XSLT, IIS 6.0, SQL

Server 2005, Microsoft Report viewer control, CSS, Windows 2003

Professional and Windows Vista.

Client: FSSA (Family Social Service Administration)

State of Indiana, Indianapolis, Indiana

08/2006 - 10/2006

Project Name: Vision Impaired Vendor Reporting Project (VIVRP)

Analyst / Sr. Developer

Description: VIVRP allow for the development of a solution to the current

Vendor reporting system which will include the following; User Maintenance

(Vendor and State Employee), Vendor Maintenance includes commission rate

maintenance and their sites. Product maintenance includes product category,

products and product price. Site maintenance includes new sites, Site owner

Transfer, View and Edit sites, Vending machine and activate / de-activate

sites. State employee can handle the above mentioned features to help the

vendors. This system also generates the following reports; Monthly report,

Monthly High report, RSA-15 Federal report (consists of ten sub reports).

The Sub reports are Earnings and Employment, Vending Facilities and

Vendors, Program Expenditures, Accountability of Program Funds collected

and Vending Machine Funds collected, Number of Sites surveyed and vending

locations under the Interstate Highway program.

Responsibilities:

. Developed User interfaces using ASP. NET Forms.

. Involved in retrieving data using ADO.Net with VB. NET, ASP .Net.

. Developed the Business Logic using and VB .NET.

. Involved in UI Design using ASP.NET.

. Worked with the database using ADO.NET library.

. Extensively used Grid Views, Data Sets, Data Views, Data Adaptors to

extract data from the backend.

. Implemented client side validations using Java Script.

. Developed Custom Controls To enhance the Functionality to meet User

requirement like Data Grid control with printing the data, providing

Multiple columns with different controls like one with Combo Box, One

with Date Picker Controls. Text Box control to provide all the

validations like text only numeric only or both and so on to reduce

the development.

. Implemented Accessibility checks for the Vision impaired users.

. Complete Production Support was given after Application deployment.

. Reports are generated through Microsoft Report Viewer control.

. Reports are Exported data to Microsoft Word document templates.

Environment: ASP.NET 2.0,VB.NET, WIN CVS, ASP Forms, OOAD, ADO.NET, Vb

Script, JavaScript, IIS, SQL Server2005, Microsoft Report viewer control,

CSS, Windows2000.

Neha Net, Santa Clara, CA

12/2005 - 06/2006

.NET Application Developer

Description: Sales Automation System manages the customer opportunity

pipeline, customer contacts, pipeline forecasts, customer quotes and sample

requests as well as design registrations. This system also generates

activity call report, forecast report, opportunities tracking list.

Responsibilities:

. Developed User interfaces using ASP. NET Forms.

. Involved in writing complex Stored Procedures, Triggers.

. Involved in retrieving data using ADO.Net with VB. NET, ASP .Net and

presenting it to XSLT.

. Developed the Business Logic using and VB .NET.

. Involved in UI Design using ASP.NET.

. Worked with the database using ADO.NET library.

. Design, Development of Web Forms, WIN Forms using Vb.Net for the user

interface using the and DHTML.

. Extensively Used Data Grids, Data Sets, Data Views, Data Adaptors to

extract data from the backend.

. Involved creating Win Forms using VB.NET.

. Implemented client side validations using Java Script.

. Developed Custom Controls To enhance the Functionality to meet User

requirement like Data Grid control with printing the data, providing

Multiple columns with different controls like one with Combo Box, One

with Date Picker Controls. Text Box control to provide all the

validations like email validation, text only numeric only, or both and

so on to reduce the development.

. Developed user controls (.ascx files) for reuse.

. Used Win Forms for new user registration and tracking system modules.

. Implemented Forms-based Authentication in ASP.NET to authenticate the

users.

. Created Reporting will be done through Crystal Reports 9.0 to show

load results and server data.

Environment: ASP.NET 2.0, VB.NET 2.0, Visual Sourcesafe6.0, Win Forms,

OOAD, ADO.NET, COM/COM+, JavaScript, IIS, SQL Server2000, SOAP, Crystal

Reports 9.0, Web Services, XML, XSL, Windows2000.

Endoxy Health Care Associates, IL

03/2005 - 10/2005

.NET Application Developer

Description: Developed a web based n-tier application that has two

modules, Operations and Reimbursements. The Operations module allows the

healthcare company to maintain data about patients, doctors, visit details

and treatments The Reimbursement module enables hospitals and doctors to

bill health care providers for the services used by their patients.

Responsibilities:

. Understanding and analyzing the client's requirement and involved in

GUI designing of the application.

. Designed, Developed Business Logic, Data Access COM Components in

Visual Basic.

. Developed User interfaces using VB. NET 2.0 Forms, User Controls using

VB.NET 2.0.

. Involved in the design of the Database and Developed Stored Procedures

using SQL for all the interaction with the database.

. Used Data Grids, Data Sets, Data Views, Data Adaptors to extract data

from the backend.

. Updated the Online Quotes according to the business logic and

marketing analysis.

. Developed user controls (.ascx files) for reuse.

. Responsible for encryption and decryption of data.

. Created application and form level security.

. Worked with the database using ADO.NET library.

. Wrote database adapter components in VB .NET. 2.0

. Used SOAP protocol for creating web services.

. Designed the database table according to the forms.

Environment: VB.NET 2.0, ASP.NET 2.0, Visual Sourcesafe6.0, Win Forms,

OOAD, ADO.NET, COM/COM+, JavaScript, VB, IIS, Oracle 9i, SOAP, Crystal

Reports 9.0, XML, XSL, Windows2000

Iowa Foundation for Medical Care, West Des Moines IA 06/2004

- 01/2005

.NET Application Developer

Description:

Medicaid Quality Utilization and Improvement System:

Medical service review frequently involves the documentation of health

information on individual members that must be protected. MQUIDS is a data

entry and retrieval application designed to facilitate IME workers' job

functions through common graphical interfaces that attempt to hide the

complexities of business rules associated with data entry and display of

the information for user analysis. In addition to the Application's

primary functionality, it also generates management reports, letters and

other outputs required in compliance with the IME RFP.

Responsibilities:

. Development of the application in VB.NET with SQL SERVER as backend

database.

. Design and development of Windows Forms and using data binding for

the controls using both the designer and manually in the code.

. Designing and Creating Typed Datasets to store, manipulate, and using

both Datasets and Data Reader to gather and manipulate data from the

database.

. Creating configuration files including App.Config and Web.config.

. Development of the application using n-tier distributed architecture

and the use of .NET Remoting.

. Design and Developing crystal reports using Visual Studio.Net

. Design and Development of database using SQL SERVER including

creation of Stored Procedures, user

defined functions, and triggers.

. Development of the application as n-tier distributed architecture.

. Using and configuring the IIS application server.

. Creating the setup program in VB.Net for installing and deploying the

application and used merge modules setup program to deploy other

related components.

. Created and Used Web User and Web Custom Controls.

. Using existing COM components developed earlier with VB6 in the .NET

application.

. Using form-based authentication to authenticate users. Created a

login page and stored the user information such as Use Id and Password

in the database.

. Used Visual Source Safe as the shared resource for the project.

. Used event logging, and tracing in the application.

. Used Data Grids, Repeater control, and Data View to filter the data

based on certain criteria.

. Developed business and database objects and assemblies using VB.NET

and .NET Framework.

. Wrote SQL jobs for auto-escalation of pending complaints of emergency

nature.

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

MS SQL Server 2000, Visual Source Safe, MS Access.

Durrant Info Links Pvt. Ltd, Chennai, India 12/2003

- 04/2004

Senior Programmer

Description: This web application brings to Chennai an online one-roof

shopping mall, where one can have all the necessary details of products of

choice. This site allows to shop online with various modes of payment (like

cash, cheques, credit-cards and finance schemes). This site has online

administration through a site administration web application for updating

the information online.

Responsibilities:

. Responsible for user requirements collection, preliminary analysis,

high level and detailed design.

. Scheduled project plan, created software requirements specification

for the entire project.

. Maintained the source files in Visual Source Safe.

. Developed Cybicshop Web application using ASP, SQL Server 2K, Visual

Interdev, HTML

. Designed and developed the Cybicshop Core business logic in VB 6.0.

. Created help documentations for all the applications in HTML.

Environment: ASP.NET, VB.NET, ADO.NET, ASP, COM/COM+, VB, IIS, VSS 6.0,

SQL Server 2000, Crystal Reports 9.0

Mirihi Resorts, Republic Of Maldives 07/2002

- 10/2003

Senior Programmer

Description: The application was developed to maintain the resort

activities like Front office operation which controls Guest entries, Room

maintenance, Rooms allotment and generate room availability chart, Guest

deposits, Check-in, Check-out, Billing, and Permit Room module allow the

user to control the sales and stock handled in the Permit room then Back

Office modules controls the complete accounting of purchase, sales, banking

and stock control of the items purchased for Restaurant and to other

department.

Responsibilities:

. Developed User interfaces using ASP.NET Forms, Win Forms, User

Controls using VB.NET

. Implemented input validation using the ASP.NET Input Validation

Controls.

. Worked with the database using ADO.NET library.

. Developed ASP and ASP.NET pages to meet the business requirements and

also involved in replace ASP pages with redesigned ASP.NET pages.

. Developed reusable and optimized .NET components using VB.NET

. Created stored procedures in SQL Server 2000, wrote the SQL statements

using T-SQL, executed and tested stored procedures on SQL Server 2000.

. Developed Interfaces for data exchange using SQL Server, Visual Basic

and XML.

. Designed, Developed Business Logic, Data Access COM Components in

Visual Basic and deploying in COM+ application.

. Stock Management concepts were used to handle the complete stock

controls for the back office operation in the Purchase department for

Restaurant raw materials and Permit Room stocks.

. Used Win forms for new user registration and tracking system modules.

. Creating Indexes, Triggers, and Stored procedures on various business

rules.

. Imported XML output to SQL Server 2000.

Environment: ASP.NET, VB.NET, ADO.NET, Win Forms, ASP, COM/COM+, VB, IIS,

VSS 6.0, SQL Server 2000, Crystal Reports 9.0, XML, XSL, Web Services,

SOAP, Visual Interdev, Visual Studio 6.0, Windows 2000.

Bengal Chemicals & Pharmaceuticals Ltd., (Govt. of India Enterprises)

Chennai, India 03/2001 -

06/2002

Senior Programmer

Description: This application was developed for the manufacturer of the

Pharmaceuticals and cosmetic products. This system monitors the products

received from the Head office and Depot activities like Invoicing, Credit

Notes, Stock Issue Slip. The Significant feature of the system is Cash

Receipt Sheet which covers collection made from the Sundry Debtors and

advanced collection Security Deposits. The system also generates State-

wise Sales summary, Collection Summary, Sales Tax Register, Sales Tax

analysis, auto ledger generation, Trial balance and Balance sheet. This

application were used the Stock Management in handling the products like

Cosmetics and Hospital supply. It generates the Product-wise Stock

Register, Depot-wise Stock Issue Ledger and also generate the Re-order

level report for Product-wise.

Responsibilities:

. Interacted with end users for Collection and Analysis of System

Requirements.

. Designed and Developed GUI using Visual Basic 6.0

. Developed COM components for Business Logic.

. Designed and Developed database in ORACLE with ODBC.

. Designed, Developed and Tested Crystal Reports.

. Prepared Documentation.

. Reports were designed for Product Register, Product-wise Stock

Ledger, Item-wise Issued ledger, Product-wise damages register.

Environment: Visual Basic 6.0, COM, ActiveX, ADO, Crystal Reports 6.0,

ORACLE 8.0, SCO UNIX

Karvy Consultants (Share Register), Hyderabad, India

03/2000 - 02/2001

Programmer

Description: This Client Server application provided Share Register to

maintain their Client share certificates, Dividend process, Warrant

generation, Certificate generation, handling top share holders data and

various analysis.

Responsibilities:

. Involved in complete System Development Life Cycle.

. Prepared SQL Queries and written Stored Procedures and Database

triggers in Oracle.

. Database created in Oracle 8.

. Used ADO for retrieval of data from the backend Oracle.

. Helped in the generation of forms for the application in Visual Basic

for the stand-alone application.

. Involved in Process Management.

. Designed, Developed and Tested Crystal Reports

ENVIRONMENT: Visual Basic 6.0, COM, ActiveX, ADO, Win Forms, OOP, Crystal

Reports 6.0, I E Controls, Oracle 8, SCO UNIX.

Madras Port Trust, Madras, India

04/1997 - 02/2000

Programmer

Description: This application developed to monitor industry power

consumption. This application is used in EMS unit (8085 Microprocessor

based) interfaced with PC/AT. This on-line system receives data from EMS

unit and monitored in PC. Instantaneous data an be viewed in on-line.

Based on time interval setting average demand status can study using load

curve. Periodic status and maximum demand reports can be generated.

Responsibilities:

. Designed and Developed API calls using TURBO-C.

. Designed and created UI, Coding, Debugging and Testing.

. Designed & Developed Graphical reports of Load curve and Periodic status.

. Created Command Batch Files.

. Testing/Maintenance/ Documentation.

ENVIRONMENT:: ASSEMBLER, Turbo-C.

Education

. Bachelor Degree in Computer Science, University of Madras, India

Professional Certifications

. Visual Studio .Net

. SQL Server 2000 & SQL Server 2005

. Visual Basic Programming,

. Programming using C

. ORACLE 8.0

. Diploma in Hardware Assembling & Servicing

Visa Status - H1 B

Professional Summary

Technical Skills



Contact this candidate