Technical Skills:

Implementation

No. Of Years

Team Foundation Server 2008

Share Point 2.0/ 3.0

Installing, configuring and administration

Install, configure, administration & Development

4

4

Sql Server / TSql 7.0/2000/2005/2008

SSIS/SSRS

Design & Development, Administration, DTS

Import/Export, validate, manipulate and process data

12

5

VB.net 7.0 /

3 tire business application - User interface, Business logics and Data access components

6

Visual Basic 5.0 / 6.0 / VBA

Desktop and client server applications

6

ASP.net With C# 2.0,3.0,3.5

Web Application Development - User interface

6

VB Script

Scripting for performance monitoring tasks, System info & mailing

5

Access 97 / 2000

Databases for information & M I S Reporting

4

Crystal Reports 7.0

M I S Reporting

2

C# console applications

Web services/ WCF

Ajax.net for asp.net 2 & 3.5

LINQ / Entity Framework

Telerik rad controls for

Ajax asp.net

Console applications for automating read, write text and excel files and import and export data

Distribute and consolidate organization information

Interactive web pages

Data access and business layers using linq / EF with VB/C#.net

Asp.net application using rad grid for insert, update and display data

3

4

4

3

2

Courses Completed:

ASP.Net 2.0

C# 1.0

Designing & implementing desktop & distributed application with MS VB 6.0

Installing, configuring & administering SQL 2000 Enterprise edition

Implementing a database design using MS Sql Server 7.0

Implementing and administering MS windows 2000 directory services.

2006

2003

2001

2001

2001

2001

Implementing and administering MS windows 2000 professional and server

2001

HTML

1999

Disk operating system

1995

Lotus 1 2 3

1995

Dbase III plus

1995

WordStar

1995

Experience:

Senior Developer Since Sep 2011

Analyst’s international corporation, Raleigh, NC

Project 1: St. Joseph Health Care System, Lexington, KY: Developing several UI’s for inputting clinical care values.(Sql server 2008/ TSql, Asp.net 4.0, C#, Entity Framework, LINQ, Ajax.net, SSRS, Telerik controls & Java script)

Gathering information and Verifying the design documents with business analysts and users

Creating entity model from sql database

Creating business layer for patients, vitals & glucose.

Created UI for entering critical values for glucose and vitals using asp.net, C# and telerik rad controls.

Created new functions and complex types in entity framework for stored procedures and tables.

Validation data input and using rad Ajax controls for updates without post back.

Created several SSRS local reports for patient reports and administrative reviews.

Unit and regression testing UI for various modules.

Used Java script, added attributes and user controls for adding and editing forms for various modules.

Project 2: State of Kansas, Traffic Records System (TRS). Sql server 2008, WCF, Web Services, C#, SSIS: Integrating records from isolated repositories at Kansas Department of Transportation (KDOT), Kansas Highway Patrol (KHP), Kansas Department of Revenue (KDOR), Kansas Bureau of Investigation (KBI) and other agencies. Estimated no of records: 80 Million.

Created services using WCF to transfer vehicle & driver data between various agencies.

Master Entity Index(MEI): Created scripts to transfer records from other entity’s (person & vehicle information’s) from other data sources to master index database, updating the data with vehicle manufactures databases and linking data with person and vehicle records.

Creating full text search queries for querying person and vehicle information and optimizing the indexes for full text queries.

Created SSIS packages for transferring data from several text files into Master Entity Index database and analyzing data for errors.

Created stored procedures to add data to the repository database using web services.(XML & C#)

Developer 6M

Confidential,Department of Agriculture, Agronomic division

Confidentail, NC

Project: Laboratory information management system (LIMS): Developing new application for LIMS using Sql server 2005/ TSql, ASP.net, VB, VB.net, LINQ, Telerik controls, Web services, Java script and Windows forms.

Source Control: VSS, Development Methodology: Agile

LABS: Soil, Plant, Waste, Solution, Media & Nematode

Web forms: vb.net, asp.net 3.5, web services, linq, telerik controls

Designed web forms using asp.net 3.5 and telerik controls for adding, editing and deleting records from grid. Users could edit each row or select multiple rows and edit or add records from a popup form.

Created procedures using linq and vb.net 9.0 for verifying data according to the user requirements and business rules and updating the data with business and data access layers.

Created data entry screen and validating the control using validation controls and updated data using web services.

Created web forms to display summary of work list with telerik controls with add, edit, delete and filtering capabilities.

Created user controls and used java script to add/edit records to reduce post backs

Windows forms: vb.net 9.0, linq

Created windows forms for data entry for soil ammonium, EC, soil skalar, solution skalar, nitrates, organic matter with laboratory equipment interfaces and importing data from excel and test files, validating the data and transferring to the data base.

Created windows forms for Nematode lab and capturing data using specifically assigned keys using key codes and disables other keys in the key board using key codes.

Created windows forms with windows explorer like tree view, populating the nodes with group items and on drill down displaying the details in a grid on right side. Users could then add or edit each item in the grid or in bulk.

Used VB script to transfer files from various instruments to sql server databases.

Database: Sql

Designed tables and created relationships for capturing data according to the business requirements.

Created stored procedures and user defined functions for adding and editing data.

Automated recommendation: Created a procedure to calculate threshold, hazard index and give an automated recommendation based on the calculations and results to the Agronomists.

Created reports as per user requirements for various labs.

Import / Export excel / text files from various instrument readings using VB.net

Developer 5M

Confidential,NY 14618

Project: Migration of applications / databases form windows 2000 to windows 2003/2008 and sql 2000 to sql 2005, VB, VB.net

Migration of Excel VBA & VB applications to .net. Used asp.net and grid views to replace excel sheets with VB connections to sql database

DTS packages to SSIS packages. Replaced Active X components in DTS packages with SSIS script task and used file/db connectors to import/export data

Migration of applications from ASP to ASP.net and IIS 5.0 To IIS 7.0

Used VB script to transfer files from legacy system to sql server databases.

Modifying custom windows services and uninstalling and installing on new servers.

Changed HTML tables in asp application s to use asp.net and grid views

Created sql pass through queries and linked access databases to sql server for querying and reports.

Developer / Admin 3 Years

Confidential, DEPARTMENT OF SAMLL BUSINESS SERVICES

New York

ASP.net Web Application: C#

ASP.net 2.0 with C# web application for users to create excel files from templates; fill in the template for each employer with data from sql server database. Each row in the result data for a period is one excel file for an employer and it is saved with password and transferred to a net work drive. Between excel files are created in one process using excel com object library.

Created a model application in Model view presenter with C# and Ajax.net for Job Order system where work force centers could enter job orders and match job seekers resume to job orders.

C# Console Applications:

Console application using C# to export data to Excel and save with password.

Console application using C# to Automate export of data to 4 text files, send status mail, close batch, upload to sslftp server, read ftp log file and get failed / success status and send conformation mail to users notifying the upload to their ftp server.

Console application using C# to download files from the ftp server and import into sql server database and run stored procedure to update the tables.

Console application using C# to update Active Directory with information from Human Resources database. The updated employee information in the sql database is uploaded to the agency’s Domain controller and the task automated.

Scripting:

VB Script to read server logs and send alerts for service status, disk space, processes info etc.

Used VB Script to automate the process of uploading files to FTP servers.

IIS:

Created Application pools for various applications, administered permissions for SharePoint servers, TFS and reporting services in the IIS.

Trouble shoot errors, fix error, add/modify configuration files & backup

SSRS, SSIS, TFS, Share Point & Access

Introduced SSRS as the reporting system: Installed & Configured new SSRS, created day to day and complex reports for various users and deployed in IIS.

Created reports with SSRS with column grouping, drill down rows, conditional row formatting, sub totals and totals in one table.

Created SSIS packages to transfer data from text files to reports database.

Introduced Team Foundation Server for source control and project management: Installed & Configured TFS server. Configured the TFS, Share point and SSRS. Created projects (MSF for Agile v4.2) and administered users and project permissions. Moved TFS from one hardware to another.

Installed Share point server for integration with web application. Configured new SharePoint server, managed user permissions, created backup jobs, crawl rules and timer jobs. Also exported the sites to another server for development purposes

Created access application for users to create reports from sql server using sql pass through queries.

Developer / Admin 2 years to

Confidentail, DEPARTMENT OF INFORMATION TECHNOLOGY AND COMMUNICATIONS

, Brooklyn, NY

OFFICE OF CHIEF MEDICAL EXAMINER (OCME Project): Dataease, Sql Server, VB6.0, LIMS

Gathering user requirements for new Laboratory Information Management System and designed work flow and data flow chart

Worked with records, forensic & DNA labs to identify the issues in their LIMS system and to recommend changes to their system.

Integrated various WTC (9/11) databases used for victim identifications, DNA lab and records department.

Automating processes for updating integrated case management system with other DOS based application (data ease).

DEPARTMENT OF SMALL BUSINESS SERVICES: Application remodeling (VB.net to C#)

Reviewed the existing applications in vb.net and databases 2000, checked the scalability and prepared a data flow chart

Studied the database/application design, created entity relationship diagram and data flow charts and compared with the user requirements and prepared work sheet for modification.

Trouble shooting performance issues in application and database design

Recommended new design and work flow for the application in C# and database in sql 2005.

Assisted the development team in testing and trouble shooting performance issues.

Assisted the team in developing and implementing the new application.

DEPARTMENT OF INFORMATION TECHNOLOGY & TELECOMUNICATIONS (DoITT): Sql

Evaluating the databases and applications for hosting on DOITT servers and creating disaster recovery plans.

Installing, configuring and administering SharePoint servers.

Creating web pages using SharePoint templates, indexing and optimizing it for searching..

Created a test application in vb.net to test the SSL and monitored encryption using network monitoring tools.

Trouble shooting client’s application for performance issues.

Recommending solutions for performance problems in application and database designs.

Sr. Developer / Architect 2.4 years

Confidentail,New York

Environment: Sql Server 2000, .Net.

Project: Design, develop and administer databases and application for their online pharmacies and accounting software for the pharmacy.

Application Development: ASP.net

Gathering requirements for the online trading and accounting system

Prepared design documents for database and applications and created ERD diagrams

N tire application based on model view presenter.

Several options for users to enter data like upload from excel templates received from vendors, templates saved in data base, reviewing an existing record and duplicating the record in addition to manual data entry.

Mail alerts for new order, status changes, record edit etc.

Import / Export excel files using excel com object to upload keywords to different search engines.

Extracted and transformed data from existing systems, some manual, some in spreadsheets and some in other databases like access and loaded it into the new systems (XTL). DTS packages were created, formatted for the new databases and saved and scheduled for later uses.

Manager Systems Development

(3 Years) Kampala, Uganda.

Confidentail,France.

Environment: Sql Server 2000, VB 6.0, Windows NT 4.0/2000, Exchange server 5.5.

Application Development: VB 6.0 (Developed using VB 6.0(ADO) in 2000 and migrated to VB.net (ADO.net) in 2003)

Studied the existing system, gathered sample documents / Vouchers / Reports and Reinsurance treaties.

Interact with department heads and potential users and discuss with them about the existing system and changes to be made on it.

Designed a data flow chart for the new system.

Identified the tables to be created, information’s to be stored in the tables, data type of columns and the primary key for the table.

Identified the relations between the tables and established a link from one table to another.

Created triggers, stored procedures, views and functions for data entry, data modifications and deletions.

Designed and developed backup and recovery procedures. Installed SQL Analysis Server Used OLAP Services to create multidimensional cubes for reporting.

Automated the quires for checking customer balances / claims and routine letters.

Tested the software, trained the users, implemented the project, managed the users and maintained the product.

Designed stored procedures that could generate transaction details by policy document, customer wise, class of business, reinsurance treaty wise and different accounts for MIS.

Stored procedures used current and previous year’s treaties with different rates for different class of business and sum insured.

Triggers for positing the balances into different accounts and tables with summary balances.

Re-designed the database and normalized the database in SQL Server 2000 in 2001

Nested triggers where used to update customer and agents accounts and summary of customer and agents accounts from the main transaction table.

Merged data from the underwriting, claims and accounts module for online analytical processing of MIS reports.

Features of the accounting package: Accounts payables, Receivables, Check writing, generating payment and receipt vouchers, Online approval system, Complex reinsurance calculations - based on surplus treaty, Quota share & Absolute share (Between head office and branch), receipting module, year to year and month to month comparisons, UPR (unearned premium reserve) calculations based on 1/24 method.

Underwriting Module Features: Fully integrated with other modules, generates underwriting documents and real time updating of accounting and claims module, online approval system, reinsurance calculations, underwriting calculation sheets has facilities of short rates, pro rata calculations, special discounts, no claim discounts, re-insurance options for maximum, separate and add together, default excess and description based on start and end dates.

In the VB.net version payroll was incorporated, which could calculate tax deductions, NSSF remittances (employer’s and employees share), house rent, car and telephone allowances and prepare statements of accounts, which could automatically update GL and Sub Ledgers. Also changed the coding and used new ADO.Net connectivity, data adapters and datasets, redesigned screens and reduced the no: of screens and made navigation mush more easy.