System Analyst

(•••••) ••••• - •••••
Email: •••••

SUMMARY

Over ten years experience in information technology in the areas of analysis, design, development, and implementation of web and client server architecture based applications. Software utilized includes ASP, .NET, JAVA, SYBASE, SQL Server, Java Beans, Visual Age, JBuilder, IPlanet, ORBIX, VB Script, Javascript, HTML, VISUALBASIC, MTS/COM+, COM, DCOM, SQL SERVER, ACCESS, ODBC under Windows and Windows NT. Demonstrated experience in application development and a hard worker with an ability to lead and manage small to medium sized projects.

EXPERIENCE


Merck Medco Health Systems, NJ Mar •••••Present
Clinical Rule Station Primer

Languages: ASP,Visual Basic, MTS/COM+, •••••
Environment: Windows NT (Workstation & Server), ADO, Windows •••••
Database: SQL Server •••••/SQL Server •••••
Web Server: IIS•••••
Transaction Server: MTS/COM+

Conducted feasibility on Microsoft .NET technologies. Developed prototype using ••••• and ••••• . The prototype includes features that address issues from both migration/conversion and new development perspectives. Currently converting application to .NET framework.

Involved in the development of a Clinical Rule Station (CRS). The system is used to manage the definition and customization of Drug Utilization Review (DUR) rule parameters. The system uses •••••tier architecture. The Data is stored on SQL Server, Business Layer is running on MTS/COM+ developed using Visual Basic and the User Layer is written in ASP.
As a lead member of the team was involved in optimizing the Stored Procedures and involved in creating new Business Access Layer and ASP pages.


AIG/AIU, Parsippany, NJ March ••••• Mar •••••
Module Leader - Personal Lines Auto Applications
Languages: Visual Basic, ASP, VB Script, Java Script, T-SQL
Environment: Windows NT (Workstation & Server), ADO
Database: Sybase •••••
Web Server: IIS•••••
IDE: Visual Interdev
Transaction Server: MTS
Designing Tool: Macro Media-Dreamweaver 2, DBArtisian •••••

Developed an online Auto and Homeowner insurance Quote system for Latin America running under a 3rd party Portal. System was developed using Microsoft IIS and a COM object running under MTS and ASP. Communication with the Quote system WEB site and the 3rd party portal WEB was via XML documents. XML documents with DTD were defined as part of the project.

A lead member of the team involved in the design and development of an internally developed consumer lines insurance package using distributed client/server technology (Visual Basic/Sybase/SQL Server). This package has been successfully implemented in Hong Kong, Brazil, and Thailand. As a senior consultant responsibility included interaction with users and management in Hong Kong / Brazil and the US, requirement gathering and specification definition, software development using Visual Basic and Sybase database (including store procedures). Using the Object Oriented features of VB ••••• to support countrification. Extensive use of Visual Basic ••••• Classes (in-house developed) and Active-X Controls (in-house developed OCX and 3rdParty OCX). Design of these classes was such that the application could be expanded easily to accommodate future enhancements requested by users. The system has both COM and DCOM Components. Extensive use of T-SQL.

Module Leader - Warranty Application
Languages: Visual Basic, T-SQL
Environment: Windows NT (Workstation & Server), ADO
Database: Sybase •••••
Reports: Crystal Reports

Developed Warranty Application for Latin America/Europe and South East Asia. The system would allow a salesman in a store or a retail shop to sell extended warranty on any consumer product purchased by the consumer. The system has the capability to setup store chains, stores within the chain and salesman, manager, supervisor, etc. in a store. I was involved in the design and development of the Warranty Application using distributed client/server technology (Visual Basic/Sybase). My responsibilities included interaction with users and management, requirement gathering and specification definition, software development using Visual Basic and Sybase database (including store procedures). Application Uses Object Oriented features of VB to support countrification. Application has the ability to display the data in different languages. Extensive use of Visual Basic Classes (in-house developed) and Active-X Controls (in-house developed OCX and 3rdParty OCX). Design of these classes was such that the application could be expanded easily to accommodate future enhancements requested by users. The system has a both COM and DCOM Components. Extensive use of T-SQL. The Reports were developed using Crystal Reports.



Module Leader - Commercial Lines Auto Applications
Languages: Visual Basic, Sybase, T-SQL
Environment: Windows NT (Workstation & Server), ADO
Database: Sybase •••••
Designing Tool: DBArtisian •••••

A lead member of the team involved in the design and development of an internally developed Commercial lines insurance package using distributed client/server technology (Visual Basic/Sybase/SQL Server). This package has been successfully implemented in Hong Kong, Brazil, and Thailand. As a senior consultant responsibility included interaction with users and management in Hong Kong / Brazil and the US, requirement gathering and specification definition, software development using Visual Basic and Sybase database (including store procedures). Using the Object Oriented features of VB ••••• to support countrification. Extensive use of Visual Basic ••••• Classes (in-house developed) and Active-X Controls (in-house developed OCX and 3rdParty OCX). The Components were written in using COM Technology. Extensive use of T-SQL.


Module Leader - Retailer Billing
Languages: Java, Servlets, JDBC•••••, JSP, T-SQL, Visual Basic
Environment: Windows NT (Workstation & Server), JConnect •••••
Database: Sybase •••••
Web Server: iPlanet Web Server
IDE: Visual Age •••••
Designing Tool: MacroMedia Dreamweaver 2, DBArtisian •••••
Reporting Tool: Crystal Clear

Retailer Billing is a web utility developed for AIGs Partner in Brazil Garanatech. The system was developed in Java (JDK•••••), Servlets, JSP, HTML. The data is stored in SYBASE (ASE•••••). The system is hosted on iPlanet Web Server. The entire user interface is implemented using JSPs with embedded Javascripts and static HTML. The system has the ability to display Crystal Reports. The system has the capability to display multi-language and can adapt to any international settings. Every interaction with the web server goes through a switching servlet, which recognizes the caller and passes on the control to the appropriate business objects. The business objects would contain all the necessary business logic necessary for the task. The database interactions are performed by entity objects. The entity objects are self-contained data objects, which have dedicated methods to search and persist entities. Each entity could comprise of one table or more than one tables. Business objects instantiate entity objects for any database activity. The system has a lot of Stored procedures written using T-SQL.

Module Leader Web EDI
Languages: Java, Servlets, JDBC•••••, and JSP
Environment: Windows NT (Workstation & Server), JConnect •••••
Database: Sybase •••••
Web Server: Netscape Enterprise Server •••••, ServletExec
IDE: Visual Age •••••
Designing Tool: MacroMedia Dreamweaver 2, DBArtisian •••••
Reporting Tool: Crystal Clear

Web EDI is a web utility developed for AIGs Partner in Brazil Garanatech. It enables retailers to upload data file, view reports using Crystal Clear, assign plan prefix to new articles, lock and unlock file and send mail to system administrator using SMTP protocol. The system was developed in Java (JDK•••••), Servlets, JSP, and HTML. The data is stored in SYBASE (ASE•••••). Stored Procedures were written using ••••• system is hosted on iPlanet Web Server. The entire user interface is implemented using JSPs with embedded Javascripts, static HTML. The system has the ability to display Crystal Reports. The system has the capability to display multi language and can adapt to any international settings. Every interaction with the web server goes through a switching servlet, which recognizes the caller and passes on the control to the appropriate business objects. The business objects would contain all the necessary business logic necessary for the task. The database interactions are performed by entity objects. The entity objects are self-contained data objects, which have dedicated methods to search and persist entities. Each entity could comprise of one table or more than one tables. Business objects instantiate entity objects for any database activity.

Module Leader - Warranty EDI Application
Languages: Visual Basic, T-SQL
Environment: Windows NT (Workstation & Server), ADO
Database: Sybase •••••
Reports: Crystal Reports

Developed an EDI Application for Latin America/Europe and South East Asia. The system has the capability to accept text files which have a predefined format and convert them into individual Warranty Contracts. The system has the capability to define/modify feed definition. The system has a high conversion rate to incorporate the high volume of the business.I was involved in the design and development of the Warranty EDI Application using distributed client/server technology (Visual Basic/Sybase). My responsibilities included interaction with users and management, requirement gathering and specification definition, software development using Visual Basic and Sybase database (including store procedures). Application Uses Object Oriented features of VB. Extensive use of Visual Basic Classes (in-house developed). Design of these classes was such that the application could be expanded easily to accommodate future enhancements requested by users. The system has a both COM and DCOM Components. Extensive use of T-SQL. The Reports were developed using Crystal Reports.

Consultant, Pershing Computers, Jersey City, NJ October ••••• March •••••
Was a core member of the team involved in the design and development of an On Line Brokerage System. The system was integrated with the PRODIGY System. The system was developed in Visual Basic.


Senior Systems Executive, Esseven Infotech, India November ••••• September •••••
Worked as a core member of the team involved in the design and development of a computer-based tutor. The system was developed using C, C•••••, Visual Basic and MS-SQL Server. Provided technical guidance in client/server technology, developed specifications, designed and optimized RDBMS to implement an information warehouse. Was responsible for the analysis, technical architecture, database design, system standards, development and implementation of a records management system. The system was developed C, Visual Basic, and MS-SQL Server. Provided technical guidance in client/server technology, developed specifications, designed and optimized RDBMS to implement computer aided dispatch system. The system was developed C, Visual Basic, and MS-SQL Server. Extensive use of T-SQL.

Project Trainee, Indian Institute of Science, India January ••••• August •••••
Client: Indian Institute of Science
Language /Tools: Prolog, Pascal
Responsibilities: A core member of the team involved in the Development of the Expert System for the Diagnosis Electro Cardio Arrhythmias

EDUCATION

Bachelors in Electronics and Communication Engineering
Advanced Course in UNIX and C
Advanced Course in JAVA Development