Dipali Pandya
0016174718950 2014063169
1035 Southern Artery
Current Location: US
Title: / Programmer Analyst/DeveloperWork 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