Sql Server Visual Basic

Balaji Arumugam

Phone No: 310-***-****

Email : *************@*****.***

Objective

Goal Oriented, user focused, articulate and analytical. Strong in design and

development, integration, problem solving kills. Expert in Asp.Net, C#,

VB.net, SQL Server with database analysis and design. Interested in a

challenging technical career in an application development environment.

Experience Summary

More than 11 years of intensive work experience in Web Application

Development, Object Oriented and Application Development on all various

business sectors. Have good record of leading my team with strong

motivation, coordination and attained the desired goal of success.

Experience on Analysis, design and development of applications using

Software development life cycle and Agile Process Methodologies.

Extensive experience on development, all layers, from database to services

to user interfaces. Managing and supporting multiple projects. Highly

adaptable in a fast changing technical environments with very strong

organizational and analytical skills.

Education : Master of Business Administration, Bharathiar

University, India

Training : Oracle Financials ERP v 8

Certifications : Microsoft Certified Solution Developer,

Microsoft Certified Professional in Visual Basic

5.0,

Brain Bench Certified Active Server Pages

Programmer, JavaScript Programmer, VBScript

Programmer, Visual Basic 6.0 Programmer, E-Commerce

Concepts Programmer

Technical Skills

Windows Operating : Windows XP/2000/NT/4.0 / 98 / 95.

System

Linux Operating : Red Hat, Ubuntu 8 / 9 /10

System

Dot-Net & Framework : Framework 1.2 /3/3.5, Asp.Net, VB.Net, ADO.Net,

Silverlight 3, Windows Service, Web Services,

MVC,WPF, WCF

Languages : VB 5 / 6, C#, HTML, DHTML, CSS, XML, XSLT

Scripting Language : VBScript, Jscript, JQuery, Ajax

Business libraries : COM, DCOM, Active X, MTS

Protocols : FTP, HTTP, TCP/IP, SOAP

Tools : Visual Studio.Net 2003 / 2008 / 2010. Microsoft

Visual InterDev 6.0, PageMaker, Corel Web Master

Suite, Adobe Photoshop.

RDBMS/Servers : SQL-Server 2005/2000/7.0/6.5, MS-Access, Oracle 7

Reporting Tools / : Crystal Report 9 / 8 / 5 / 4.6

Services

Versioning Tools : Visual SourceSafe

PROJECTS DETAILS

1) Feb '02 - Till

Date

Organization : HRN Services Inc., Beverly Hills, California

Role : Senior System Engineer / Team Lead

At HRN Services Inc., is a Health Services Support Organization, the Company

offers national traveling assignments for registered Nurses and other

healthcare providers through our "Gateway To Travel" Program. As a team

lead, development involved extensive design, development, managed numerous

modules for Payroll Billing, Accounting, Gateway to Travel Systems. Some of

the challenge works involved during the implementation of various modules

are

Assignment module, involved various nuclear modules such as Stipend, Direct

Housing and Furniture are complex front end using Data-grid Controls. These

modules are tightly integrated with Accounting System which generates

expense checks for above sub modules which in turn talks to the Windows

Services which transfers the data to bank.

Time Sheet module involves capturing per-diem and assignment time data.

Payroll module, this is one of my challenging and sensitive modules which I

accomplished successfully from design, development, and integration and

tested very well. Complex calculations include Insurance, Incidental

Allowance, 401k; Credit Union, Garnishments and other user defined Special

Deductions which are integrated with pay check generation module. These

sensitive calculations are all accomplished using back end SQL Store

procedures, Functions.

Generating General Ledger report from payroll data is another interesting

module to work with. Each weeks Payroll data has to balance, this was

accomplished using Store procedure.

In Accounting System, this is a center and important piece of system which

talks to all other modules like Assignment, Stipend, Direct Housing,

Furniture, chargeback, Invoicing and Payroll.

Reports like Trial Balance, P & L and Balance Sheet which are mission

critical for the accounting department.

For all these Applications, Menu has different Security Level Access

depending on the User Access.

Transferring Pay check Data through Windows service to bank.

Responsibilit : All the applications are accomplished using .NET Framework,

ies ASP.NET, C#, VB.NET, ADO.NET, JavaScript, AJAX, XML, JQuery.

Designed Web forms for all the above modules

Defined Business rules using Classes.

Worked extensively on SQL Stored Procedures, Functions,

Views and Triggers.

Worked on SQL Job agent which runs as per the schedule

defined.

Worked on Windows services for transferring Pay Data to the

Bank.

Most of the mission critical and sensitive payroll formula

and tax calculations were created and handled using SQL

Store procedure, Functions.

Used Crystal Reports for .NET Reporting.

2) Apr'01 - Jan

02'

Organization : NeoTech Systems Inc., La Palma, California

Client : NeoTech Systems Inc., La Palma, California

Role : Software Application Developer

Environment : Visual Basic 6.0, Oracle 8.x, Crystal Report 8.0, Windows

2000 Server

HOME SCAN is a product developed for hospital management. Takes care of

Patient information, day-to-day transactions, PO's, Supply chain management

with respect to medical supplies in the hospital. Implemented Barcode to read

patient information from a card. Tracking of medical supplies usage by each

patient.

Responsibilit : Gathering application specification.

ies Designed forms and developed various menu programs using VB

6.0.

Defined Business rules using COM Components.

Developed an interface to communicate with EDI and Collect

Data's.

Wrote PL/SQL Stored Procedures, Functions and Triggers.

Used ADO for Backend Database Connectivity.

Used Crystal Reports for reporting.

3) Apr'00 - Mar

'01

Organization : NeoTech Systems Inc, California

Client : Kenexa Inc, Woburn, MA

Role : Software / Web Application Consultant

Kenexa Recruiter is a robust web-based recruiting system that can shrink your

time to hire by 80% and dramatically reduce your costs. Kenexa Recruiter

system is to improve, streamline and automate your recruiting efforts quickly

and cost-efficiently. This system integrates seamlessly with the entire

Kenexa Portfolio of products and services to help you manage all of your

company's recruitment, training and retention efforts, end to end. Basically

the company had large number of customers using the system, one of such

client which I got involved was REI's Job search module.

There were 2 sections involved, external side is where public can apply for

jobs which are open with the company. Internal side is where to maintain the

applications which are received.

Responsibilit : ASP, Visual Basic 6.0, SQL Server 7.0, HTML, IIS, VB

ies Script, MTS, XML, Visual InterDev / Windows NT Server, COM,

Oracle 8

Involved in designing and develop various menu programs

using VB 6.0, Captured business logic into COM Objects.

COM Objects where being deployed into MTS which minimizes the

traffic.

Created Graphics for the Web site using Adobe Photoshop.

Developed HTML Pages and used JavaScript for client side

scripting and VB Script for server side scripting with

relevant validations.

Wrote Stored Procedures for manipulating records.

Created secured emailing features using CDONTS mail.

Used ADO for Backend Database Connectivity.

Interacting with the End Users to fulfill the requirements.

Created Reports with Crystal Reports.

4) Web Site Development for Sharcstar Communications Limited Sep '99 - Mar

'00

Organization : Logic Version Technologies, India

Client : SharcStar Communications Limited

Role : Web/Software Developer

Sharcstar Communications Ltd is a # 1 Satellite company. The purpose of

this application is to advertise market and offer services of company's

satellite products over the Web. This Web Site provides details about Company

Profile, Product Information, Technical Information, Price Details, Online

Inquiry Form, Online Ordering Form, Online Feedback form, Frequently Asked

Questions, Dealers Network & Employment Opportunity.

The total application contains numerous Static Pages and Dynamic Pages.

Information like Inquiry, Feedback and Ordering are maintained at the

back-end database along with the Customer's information. These details are

periodically downloaded from the Web Server for Analysis and further

processing.

Responsibilit : Microsoft Visual InterDev 6.0, FrontPage Express 98, ASP,

ies ADO, IIS, VBScript, Java Script, Corel Web Master Suite 1.0,

MS Sql Server,

Responsibility to interact with the users and meet their

requirements to the very best.

Developed Coding using Active Server Pages.

Database connectivity with SQL Server was done through ADO.

Client level validation was done using Java Script and Server

Side validations were done using VB Script.

Designing Graphics was done using Corel Web Master.

Written back-end Stored Procedures for manipulating records.

6) Smile Patient Care System, Dec '98 - Aug

'99

Organization : Logic Version Technologies, India

Client : Sri Vishnu Priyaa Hospitals Private Limited, Coimbatore

Role : Programmer Analyst

Smile Patient Care System takes care of entire systems of the Hospital which

includes various modules such as Registration, Consultation, Inpatient,

Outpatient, Billing for the In/Out Patients, Laboratory, Pharmacy and

generating Reports. For the entire above module were taken using custom

report using visual basic 6.0. This project was developed using Three Tier

Architecture.

Responsibilit : Visual Basic 6.0, Active-X, COM, ADO, SQL Server 7.0, Windows

ies NT 4.0, Crystal Reports

Developed Inpatient and Outpatient Modules, Details of Doctor

and Billing modules were completed.

Database connectivity with SQL Server was done through ADO.

ActiveX Control was created for Date Validation purposes.

Created Business Tier using ActiveX COM DLL's which

communicates with user and data level.

Written back-end Stored Procedures and triggers for

manipulating and updating records into the database.

Created Reports with Crystal Reports.

7) Manufacturing Industries Business Solution [MIBS] June '98 -

Nov'98

Organization : Logic Version Technologies, India

Client : Sarvalakshmi Foundries, Coimbatore, TN, India

Role : Programmer Analyst

MIBS is a fully integrated Management Information System through which

various functions of the organization can be inter-linked. MIBS Package was

developed using Three Tier Architecture and ActiveX Code Components. RDO Data

Access Object was used for accessing the Database through ODBC. A separate

Error Handling Active-X in process Server component was designed to trap

Errors. It provides options for the end user to take necessary actions.

Reports were developed in Crystal Reports 4.6 and Custom Reports in Microsoft

Visual Basic 5.0. Win32API functions were used to control the behavior of the

forms and Controls.

Responsibilit : The application were completed using Visual Basic 5.0,

ies Active-X, COM, DCOM, Win32 API, Crystal Reports, RDO, ODBC,

MS SQL Server 6.5, Windows NT.

Created Program specifications.

Development of Financial Accounting which includes Account

Master, Daily Transaction, Reports for various Books like

Cash, Sales, Purchase and Bank were Taken.

Daily Ledger Posting and Report for the same.

Writing ActiveX controls. ActiveX Controls where used to

manipulate the Data's.

Captured business logic into ActiveX DLL, which tends to

communicate with user level and Data level.

8) Job Order Processing System Jan '98 - May

'98

Organization : Logic Version Technologies, India

Client : Ashwin Industrial Suppliers, India

Role : Programmer

This package comprises of functional modules involving Contractor Master,

Product Master, Inspection and Payments. It automates various business

processes such as Placing Job Orders, Contractor Details, Product

Specifications, Quality Inspections and Quality Rating & Bills Payables. It

includes reports for Job Allotment, Supplier history, Outstanding Payables,

Supplier ratings and Pending orders.

The data retrieval was done using DAO, which were developed as functions in

separate Class modules. This Software usage was widened by incorporating OLE

connectivity with MS Excel to provide Graphic and Table formatted report

analysis.

Responsibilit : Application was accomplished using VB 4.0, MS-SQL Server 6.0,

ies ODBC, DAO, OLE, Crystal Reports, and Windows 95.

Design and Development of Forms & Reports.

Involved in the Bills Payables Module.

The Outstanding Payables where monitored and report where

taken for the same.

Created Stored Procedures.

9) Sep '96 - Dec

'97

Organization : Nikasoft Technologies, India

Role : Programmer

Inventory Control System

This package was used to maintain the Inventory and Bills of materials for

various items manufactured. Modules are available to produce material

shortage list. It has facilities for printing summary and Detailed stock

statements to be produced to bankers.

The Data tables, relationships, queries and reports for the application were

developed in Access 2.0.

The forms were built as child forms under a common MDI form ensuring integral

user interface.

The data access interface is provided using Data Control DDE connectivity

with Microsoft Excel and representation of graphical analysis through OLE.

Responsibilit : Application was built using VB 4.0, DAO, OLE, MS-Access,

ies Crystal Reports, and Windows 95.

Design and Development of Forms & Reports.

Was involved in the Inspection and maintenance of the

Materials.

Purchase Order Processing System

This Package involves in getting purchase indents from the Planning

Department and Raising Purchase orders based on the current cost, Preparation

of Purchase order/amendments and Maintenance of supplier details. Reports

include Purchase order status, Pending Payments, Supplier wise Product

details, Supplier Rating and Product Price details.

The Analysis graphs were done using Graph controls.

Responsibilit : Forms and Reports designing, coding, testing.

ies Involved in coding and implementation of Purchase Order

Processing module.

Purchase orders are being maintained by raising purchase

indents

The reports were done using Crystal Reports. It also enables

the user to design their own customized reports and was

called from application using Dialog Controls.

Bill Receivables System

This Package involves in getting the Credit Sales Receipts from the Sales

Department and it allows the user to generate Credit notes and Debit notes

along with the bills for the selected party.

It updates the outstanding values, adjusted values, Account Transactions and

Ledgers on-line.

This System allows the user to Query the Details about Received Bills, Credit

Notes, Debit Notes and Out Standing Values. Reports were generated to analyze

Received Bills, Outstanding Values, Credits and Debits

The Project includes Analysis like aging and customer wise analysis of

outstanding receivables. This System mainly deals with balance receipts to

be received from customers. It Helps in maintaining the cash inflow into the

company. It also indicates pending receipts.

Responsibilit : Forms and Reports designing, coding, testing and

ies Implementation.

Programmer - involved in coding and implementation of Bills

Receivables module.

Requirement Study and Preparation of Program Specifications &

allocation.

Monitoring the Credit Receipts and preparing outstanding

amounts and maintain the Cash inflow to Account.

The reports were done using Crystal Reports.

Contact this candidate