Amir H. Adibi
**********@*******.***
Summary
Over 25 Years of Experience in Object Oriented Design, Modeling,
Programming, Application Development, Maintenance and Testing in
Delphi Applications and Relational databases.
Technical skills
Expertise in Developing Object Oriented Delphi applications using
all major versions of Delphi (Delphi 1 to Delphi XE2).
Expertise in creating joins, views, indexes, stored procedures,
triggers, functions, constraints at various stages of migration,
ad-hoc reports and data validation.
Expertise in writing Perl scripts and using SQL*Loader utility
for moving data from external files into the Oracle database.
Expertise in working with Universal Data Access Components
(UniDAC), Borland Database Engine (BDE) in SQL Server and Oracle
communications to connect in Delphi.
Expertise in Front-end development and efficient Exception
handling
Expertise in upgrading different types of Client server Delphi
applications to higher versions like Delphi 2005 and Delphi XE2.
Experience in developing Delphi Multi-threaded, distributed,
multilevel architecture, Client-Server, Multi-tier Applications.
Experience in Windows API, COM and DCOM (MIDAS) programming in
different Delphi versions.
Experience in Reporting Tools such as Rave Reports, Quick Reports
in Delphi.
Expertise in writing queries in MySQL and PL/SQL development in
Oracle.
Expertise in using StarTeam, a version control management system.
Experience and Involvement in total development life cycle.
Proven decision-making skills and abilities to lead and manage
projects.
Expertise in systems development life cycle (SDLC) and Agile
Methodologies.
Experience
Sr. Programmer Analyst 1999-Present
Mergent Inc. - Charlotte, NC
Primary responsibilities include design and development of
in-house applications with Delphi (Object Pascal), Perl, and PHP.
Here is a brief list of what I have done in my current position:
User Interface for Database Applications
I have created numerous GUI front-end for Database applications.
These applications have been designed and developed under Windows
environment. I usually use Delphi (Object Pascal) to design a
multithreaded GUI interface, which is connected to either Oracle
or MySQL as database to retrieve and or save data.
Windows Service Applications
I have created several Windows service applications. Some of
these applications have been designed to publish all the related
data from Oracle database to a MS-SQL database as they get
updated in the Oracle database in real time. These applications
are multi-threaded, Windows service applications, and I have
implemented them using Delphi (Object Pascal).
Some others have been designed to monitor continuously the output
folder of a PDF generator and move the created PDF files in this
folder to some designated folders in our network.
PL/SQL Packages
I have written several PL/SQL packages for my applications. In
one of them, the objective was to create an automated application
to retrieve, process, and load a daily ratings file from a third
party source. I decided to write a PL/SQL package containing
functions and procedures to take care of all the requirements in
this project. Using packages rather than writing queries inside
the code can be a better approach in some projects and I have
done it several times in my projects.
Perl Scripts
I have written several Perl scripts, which download data in
different formats from a FTP site to a local drive and do all the
necessary processes like unzipping the files and converting them
to a proper format and then finally populate them in a local
database (usually Oracle or MySQL).
Web Applications
I have done a few web applications using PHP. One of them was a
small web application, which I wrote in PHP and I used HTML, and
Java Script to complete the task. Users of this application can
verify an existing annual report in PDF format and or delete
related records of a specific annual report from two MS-SQL
databases and delete the actual PDF file as well.
In another project, which originally has been written in
PHP/Smarty with Oracle as the backend, I had to convert this
application from Oracle to MySQL database. So, I was mostly
involved in converting queries from Oracle to MySQL and connect
them to the PHP code.
Environment: Delphi 6, Delphi 2005, Delphi XE2, Perl, PHP,
Windows NT and Windows 7.
Database: Oracle, MySQL, and MS-SQL
Software Development Approach: SDLC and Agile Methodologies.
Programmer Analyst 1998-1999
Informatica Inc. - Toronto, ON
Designed and developed an inventory management system using
Delphi (Object Pascal).
Programmer Analyst 1996-1998
Teleride Inc. - Toronto, ON
Provided programming and implementation support to an automated
transportation system, written in Delphi (Object Pascal).
Programmer Analyst 1995-19
96
Micro House System Inc. - Toronto, ON
Designed, programmed, and implemented a Point Of Sale application
for fashion industry, written in Delphi (Object Pascal).
Programmer Analyst 1989-1993
Iran Office Machines Center (IOMCent) - Tehran, Iran
Designed, programmed, and implemented an inventory
management system, written in PAL, a programming
language for Paradox, which is a database environment.
Afkar Informatic. - Tehran, Iran
Provided programming and implementation support to an
inventory management system, written in Turbo Pascal.
Provided programming and implementation support to a
student registration system.
Education
York University 1993-1994
Toronto, Canada
Non-Degree Study
Sharif University
1989
Tehran, Iran
H. Bsc in Computer Science