Dipali Pandya

0016174718950 2014063169

1035 Southern Artery

Current Location: US

Title: / Programmer Analyst/Developer
Work Experience: / 5 years
Skills: / Delphi, Sql Server, Oracle, Crystal Report
Current Organization: / Allied Business Consuling
Previous Organization(s): / Allied Business Consulting
Industry: / Banking/ Financial Services,Hospitals/ Health Care
Highest Degree Held: / B.E/B.Tech (Computers) ,M.S.University
Gender: / Female
Date of Birth: / 20 May 1979
Current Annual Salary (Rs. in Lacs): / 10

Detailed Resume:

Dipali Pandya

617 471 8950

201 406 3169

SUMMARY:

Around Five years experience in designing, developing and deploying

standalone applications for platform agnostic environments in the field of

Finance, Mortgage, Healthcare, Pharmaceuticals, Billing, Order Fulfilling,

Inventory, and Security Systems.

Expertise includes RDBMS technologies SQL Server, Oracle, creating &

maintaining database, writing triggers, views, and stored procedures.

Excellent programming skills, optimizing SQL queries, systems interface

analyzing and documenting experience in Delphi, Visual Basic, and PL/SQL.

Performed systems analysis design and development, as well as testing and

implementation using rapid application development (RAD) tools and version

control tools.

Expertise in Report Development using Crystal Reports, Crystal Enterprise,

Seagate Info, Oracle Reports, Quick Reports and Data Reports.

Experience of Empower (Loan origination software based on OOPS).

Good exposure to N-tier, XML, .NET, ADO, OLE-DB, ODBC, DCOM/COM, MTS,

Component Writing and Object Oriented concepts.

CERTIFICATION:

Delphi Certified from Brain Bench[pic] : Public Transcript Number:

4403874

(http://www.brainbench.com/transcript.jsp?pid=4403874.)

TECHNICAL SKILLS:

Operating Systems: Windows NT/95/98/XP/2000, HP-UX 11, O/S 390,

UNIX

Languages: Pascal, PL/SQL , Java, Fortran, Cobol, C, C++, C#,

Eastern Script language

GUI: Delphi 5/6/7, Visual Basic 5/6, Empower

RDBMS: Oracle 7/8/8i, MS - SQL server 7/2000, Paradox,

Inter Base

Database Tools: Erwin, Toad

Reporting Tools: Crystal Enterprise 9, Crystal Reports 8/9, Seagate

Crystal Reports 6/7.5,

Quick Report, Data Reports

Web Tools: XML, XSL, Soap, ASP, JSP, COM, DCOM, Multi

Threading, MTS, Active X

Technology, Java Script, HTML, DHTML

Utilities: Win32 API, ASP.NET, MIDAS, Kylix, PVCS Version

Manager, PVCS Tracker,

PVCS Version Manager,

Visual Interdev, ADO, BDE, ODBC, OLE DB, Visio,

Ms Office, Visual Source safe, Install Shield

Professional.

WORK EXPERIENCE:

AmeriQuest Data Services (ADS)

AmeriQuest Mortgage Company, Orange, CA

Programmer Analyst

Project Description:

Oct. 03 - Dec. 03

AmeriQuest Mortgage Company originates and services billions of dollars in

mortgage loans. AmeriQuest is also a nonsupervised mortgagee of the U.S.

Department of Housing and Urban Development. ADS maintain and satisfy

requirements of AmeriQuest mortgage applications.

Responsibilities:

Accomplished software requirements by developing, maintaining application

and database.

Worked as a team member towards accomplishment of Script Loan Document.

Arranged project requirements in programming sequence by analyzing

requirements, preparing work flow charts and diagrams using Visio software.

Worked with business executives/analysts, for enhancing the existing

application modules and to make modules flexible with ongoing changes in

business requirements.

Contributed in development of N-Tier distributed applications, using Data

Snap for Oracle through ADO. Extensive coding was involved in developing

new modules, enhancing/maintaining existing modules.

Used SOAP (Simple Object Access Protocol) to support system web services.

For encoding of remote procedure calls and data mapping implemented XML

objects.

Responsible for designing, developing and maintaining reports using Crystal

Reports. Integrated various reports into the application.

ADO.NET for accessing/manipulating the database.

Involved in Design and development of the user interface using ASP.NET

server controls, HTML and JavaScript.

Confirmed program operations by conducting tests at multiple levels and in

multiple user environments. Developed test scripts for module testing.

Environment: Windows 2000, Oracle 8i, AD Empower 24, Delphi 7, PL/SQL

Developer, PVCS Version Manager 7, PVCS Tracker 6.7, Lotus Notes, and

Crystal Enterprise 9.

Medicore

Private HealthCare System, Waltham, MA

Senior Programmer

Project Description:

Aug. 02 - Aug. 03

Medicore system generates multiple reports and provides the ability to

enter the system through the intranet and create technical documentation in

MS Word/Excel spreadsheet/INI files. System utilizes security information

by permitting the access to the information based on a user login. System

generates different type of reports using Crystal Report for better

decision-making. System deals with Doctors/Patients information. It

monitors patient's account and keeps track of Pharmacy Center Information.

Responsibilities:

As a team member contributed in the design, development and implementation

phase of this complex security based application.

Analyzed the process of the Healthcare Center, understood the requirement

and prepared data flow in VISIO and layout in Delphi.

Contributed in planning the tool layout, reinterpreting complex and

abstract information for security validations, coding and writing stored

procedures for data validations.

Created database objects (tables, indexes, stored procedures, triggers)

extensively in SQL Server.

Analyzed report requirement, designed report layouts and created customized

reports in Crystal Enterprise and Crystal Report. Generated Crystal Reports

for cost, sale and purchase using features like Drill down, running total,

Formula etc. Created different parameterized reports as per requirement.

Responsible for developing report related modules.

Developed Custom DLLs in Delphi.

Enforcing security standards and enhancing the application performance.

Tested the tool with simulated data, documenting, maintenance & user

support.

Environment: Windows NT/2000/XP, SQL Server 7/2000, Delphi 6/7, Install

Shield Professional, Crystal Report 9, Crystal Enterprise 9, Visio, ODBC,

ADO.

Medical Reimbursement System

Genzyme Pharmaceuticals, Cambridge, MA

Programmer Analyst

Project Description:

Jan. 01- Jul. 02

System deals with analyzing Employee Medical Reimbursement Plan (EMRP)

given by the organization. Employee will be eligible for EMRP, based on

his/her designation in organization. Employee select coverage for

himself/herself under the organization's Group Health Plan. Upon becoming

eligible for the EMRP, an employee will automatically be enrolled in the

plan provided he/she is currently enrolled in the Group Health Plan.

Coverage will be extended by the plan for any medical expense, which would

be deductible medical expense under income Tax regulations.

Responsibilities:

Collecting and assimilating data, synthesizing information, business

modeling, conducting systemic assessments, developing creative strategies,

analyzing and designing workflow processes.

Responsible for designing, developing and maintaining standard reports

using Crystal Reports. Integrated various reports into the application.

Responsible for design, testing, and implementation as well as control and

maintenance of organization's logical and relational databases across

platforms and computing environments.

Involved in extraction, manipulation of data, generating and optimizing

queries.

Developed Multi-tier application in Delphi using MIDAS. Used components

like TDOMConnection, TSocketConnection, TDataSetProvider, TClientDataset

etc.

Environment: Windows NT/98/XP, Oracle 8i, Delphi 5/6, Install Shield

Professional, Crystal Report 8, Visio, ADO, Visual Source Safe.

Branch Audit and Security Europe (BASE)

Thomas Cook Group Ltd., UK

Programmer

Project Description:

Mar. 00- Dec. 00

System is aimed to create a base system for Thomas Cook Group Ltd. System

provides the mechanism for auditors and security staff to coordinate and

maintain branch security details and audit reports. Investigation reports

can also be tracked for each branch and details of fraud can be sent

forwarded to NCIS (National Criminal Intelligence Service). System based on

client/server technology and SQL Server. Client PC connects to SQL Server

database using the Client application known as Base. Network connectivity

between server and client is performed over TCP / IP to an NT server.

Responsibilities:

Full life cycle responsibility from analyzing business requirements,

developing and testing software through production to deployment. Wrote the

functional design specs and defined the process workflows.

Coordinated with client's team for developing the data flows.

Due to common pitfalls of client/server programming, used local INTERBASE

for developing and testing a client/server application on a single

computer.

Extensive coding was involved in Delphi. Wrote stored procedures and

optimized the SQL queries to boost up the application performance.

Some modules developed using Java. Developed custom component (Java Beans)

called SQL Connector in Java, which allows the user to select database

source such as SQL Server, Oracle, Access or any other RDBMS. Dependent on

what security level all users have been granted by the DBA the users can

access those tables only.

Finally tested and documented the entire integrated system complying with

the NCIS (National Criminal Intelligence Service) regulations.

Generated reports using Crystal Report.

Environment: Windows NT, SQL Server 7, Delphi 5, Java, Install Shield

Professional, Crystal Report 8, Visio, ADO, Inter Base.

International Voucher Administration System (IVAS)

Morgan Stanley Dean Witter, NYC, NY

Programmer

Project Description:

Sep. 99 - Feb. 00

IVAS is a sales system used for the sale of vouchers (such as gift, pre

paid vacation, hotels etc). Voucher sale can be performed through web

interfaces as well as through sales representatives. System caters for

multi currency vouchers and is based on client/server technology.

These vouchers are used by corporate clients to give away promotions or to

staff as incentives and tax benefits. System also facilitates multi

currency and credit card transactions. Also a tracking voucher module is

incorporated.

Responsibilities:

As an active team member contributed in analyzing the client's

requirements, determining the workflow and writing the design specs.

Designed, developed and deployed the entire application using Delphi as the

main front-end tool and SQL Server as a back end.

Developed the voucher tracking module, the end users as well as the

corporate staff can know the status of any particular voucher based upon

the voucher ID. Also tested the module with simulated data.

Wrote stored procedures, triggers, and queries extensively in SQL Server.

According to the requirement of the client generate reports using CRYSTAL

REPORT.

Environment: Windows NT/98/ME, SQL Server, Delphi, Install Shield

Professional, Seagate Crystal Report, ADO, Visio.

Budget System

Gujarat State Fertilizers and Chemicals Limited, India

Programmer

Project Description:

Apr. 99 - Sep. 99

System deals with analyzing the Budget Process.

Responsibilities:

Polishing of existing code base, debugging and adding new features.

Redesigning corporate logo and adding the desktop publishing values.

Developing the functional specifications, designing and developing the

database, creating tables and writing stored procedures.

Building Custom Objects, Methods and Properties, creation and compilation

of DLL.

Generating multiple reports, documenting, maintenance and user support

Environment: Windows NT/98/95, Oracle 7, Visual Basic 6, Seagate Crystal

Report, Visio, ADO.

Product Costing System

SHRENO Limited, Alembic Group of Organization, India

Developer

Project Description:

Dec. 98 - Apr. 99

Organization manufactures the machines of different sizes for different

clients. System maintains all the details of the suppliers of the raw

goods. It also maintains the records of the goods received in the

organization. It generates the short-excess report of the raw materials in

the stock.

Responsibilities:

Analyze the process of the each department during the making of machine,

understand requirement and prepare data flow and layout in Visual Basic.

Create database objects (tables, indexes, stored procedures, triggers)

extensively in SQL Server.

Responsible for storage and analysis of large volumes of data.

Testing the tool with simulated data, documenting, maintenance & user

support.

Environment: Windows NT/98/95, SQL Server, Visual Basic 5, Ms Access,

Visual Source Safe, Data Reports, Visio, ADO.

EDUCATION:

BS Computer Engineering and Science

References:

Furnish upon request.

Resume of Dipali Pandya Page XXX