Albert Doroba
Altamonte Springs, FL 32714
Home [Send email to request phone number] 32-5125
E-mail: [Send email using form at bottom]
OBJECTIVE: To secure employment as a Software Application Developer using
PowerBuilder.
TECHNICAL SKILLS:
PowerBuilder 5.0/6.5/8.0/9.0, PFC (PowerBuilder Foundation Class Library)
DataWindows, Inheritance, OLE, User Events, User Objects, Functions, Cursors,
Structures, Triggers
DB2, Informix 7/9, Microsoft SQL Server 6.5/7.0/2000, Oracle 7/8/9 PL/SQL, MS
Access 97/MS Access 2000,
Sybase 11x, Sybase SQL Anywhere 5.5 Server, Sybase Adaptive Server Anywhere 8
Citrix Server, Database, S-Designer 5.0, PowerDesigner 6.1
Database Design, ER Modeling, Programming Logic, Object Oriented Programming
Techniques
Java, Java Beans, JSP (Java Server Pages), Servlets, Scriptlets, Applets, Tomcat
4.0, JavaScript, HTML, C++
Visual Basic 6.0 / Visual Basic for Applications
Windows 95/98, Windows NT, Windows 2000, MS Office 97, MS Office 2000, DOS, FTP,
TCP/IP, VAX
WORK EXPERIENCE:
June 2004 / Jan 2005 – Senior PowerBuilder Programmer. Vistar Technologies,
Wellington, FL. The PowerBuilder position was 100% telecommute. Developed a new
Scheduling Application by myself using PowerBuilder 9.0. The Application will be
used by Blue Cross / Blue Shield of Illinios, New Mexico, and Texas and Medical
Mutual of Ohio. The Application imports medical group data and physician data
from an existing Credentialing Application and database. The Application allows
an administrator or scheduler to schedule an appointment for a nurse’s visit to a
physician’s office. The Application allows nurses to view their appointments on a
daily, weekly, or monthly calendar. The nurses conduct surveys of physician’s
offices and patient’s charts. The Scheduling Application was designed to work
with 3 different databases, Oracle 8, MS SQL Server 2000, and Sybase Adaptive
Server Anywhere 8.0. The Application datawindow SQL and global functions were
written to work with all 3 databases. Tested the Application using all 3
databases. Created Oracle 8, MS SQL Server, and Sybase database scripts to create
tables, alter tables, create database indexes, create synonyms, modify fields,
and grant table permissions. Modified 3 separate Site Survey PowerBuilder
Applications to work with the Scheduling Application. The Site Survey Download
Application downloads physician information from the Scheduling Application
database to a laptop Sybase Adaptive Server database. The Site Survey Data Entry
Application allows nurses to input survey information to the laptop database. The
Site Survey Upload Application uploads survey information from the laptop
database to the Scheduling Application database. Developed an Application to
write validated physician data using a specification to a text file as one long
string. The text file is then sent to the Federation of State Medical Boards
(FSMB). The file data is loaded and the data parsed and a Credentialing report is
generated showing whether the physician’s license is valid.
Nov 1999 / June 2004 - PowerBuilder & Java Developer. American Automobile
Association, Heathrow, FL, Responsible for providing software development for 5
PowerBuilder PFC Applications: RAP (Roadside Assistance Program), RAP Billing and
Payment System, RAP Billing and Payment Online via IE 5.5 browser & Citrix, PC
Data Entry Application, and Avatar. Used PowerBuilder 6.5/8.0, PFC, Informix 7/9,
Oracle 8, MS SQL Server and Sybase SQL Anywhere Network Server 5.5 databases. RAP
is used by 95 AAA Clubs nationally to provide emergency road service to motorists
for GM, Volkswagen, and Lexus Vehicles. The Application reads, validates, and
processes messages (New, Cancel, Close, Acknowledgement) coming from the EDS
Mainframe by checking an FTP Directory every 60 seconds. The Application
determines the Services (Tow, Locksmith, Jumpstart, etc.) a motorist is entitled
to and tracks the Services provided. The VIN is validated. The Call Status
(Received, Dispatched, On Location, Cleared) for each Call is tracked. Programmed
datawindows, datastores, tabpages, non-visual user objects, functions, etc. Used
SQL Anywhere Network Server 5.5 as the database. Provided troubleshooting support
using TCP/IP. Deployed new releases and patches to the Clubs. Worked extensively
on the RAP Billing and Payment and RAP Billing and Payment Online Systems. The
Applications are Call Editing, Billing and Payment Systems for paying AAA Clubs
for emergency roadside services provided. Constructed the Application Framework
using the PFC Library, Menus, the Application Manager, MDI Frame, non-visual user
objects, and 2 transaction objects (SQLCA & IFMXSQLCA). Enabled PFC E-Mail
Notification of errors for the Application. When an Application error occurs, an
e-mail message is sent to the developers indicating where in the Application the
error occurred. Worked on the Call Details Window that contained 9 tabpages with
multiple datawindows per tabpage. Programmed windows, datawindows, datastores,
shared datawindows, non-visual (n_cst_appmanager) and visual user objects,
tabpages, menus, filter windows, reports, structures, functions, transaction
objects, and user-events. Used PFE objects inherited from the PFC layer. Used OLE
(Object Linking and Embedding) to copy and paste Excel spreadsheets into the
Application. . Used OLE to fill out Excel Spreadsheets and Outlook E-mails.
Programmed cursors, stored procedures, and used embedded SQL. Created database
tables and added fields to the database. Compiled and distributed the Application
Source Code (PBDS and DLLs). Used the PB Sync utility to synchronize (copy) the
Application PBDs / DLLs from the NT Drive to the user’s PC. Installed the
Application on user’s PCs. Deployed and supported the application over an
Intranet using Citrix Servers. Installed printers for Citrix Clients. Worked on
the PC Data Entry Application. The Application allows AAA Clubs to edit, correct
and validate data, import text files, save changes to text files. The corrected
files are then FTPed via TCP/IP to the AAA National Office, and an e-mail is sent
from the Application to alert the National Office that a file has been FTPed.
Completed the Project after 3 other developers failed to complete the project.
Modified the Application from a Non-PFC Application to a PFC Application. Created
Global datastores that use text files as the datasource for drop down
datawindows. Shared datastore data with drop down datawindows. Programmed
functions, user events, windows, datawindows, datastores, shared drop down
datawindows, filters, sorting. Added FTP and e-mail capability to the Application
to send files, e-mail, and attachments. Developed a C++ program to install the
Application from a CD.
Worked on converting the RAP/PC Application from a PowerBuilder Application to a
browser based Java Application. Created a Java Connection Pool class for creating
pooled connections, getting connections from the stack, connecting to an Informix
database using JDBC, executing a SQL statement, loading the ResultSet to a
Vector, disconnecting from the database, and returning the connection back to the
stack and pool. Installed and configured Tomcat 4.0 JSP / Servlet container for
serving up Java Server Pages and Servlets. Developed Java classes, Java Beans,
Java Server Pages, Servlets, Scriptlets, Applets, Javascript, and HTML Pages for
displaying the ResultSet data retrieved from an Informix database. Developed
Applets that displayed Informix database data using JInternalFrames, JPanels,
Containers, ContentPanes, and Swing Components.
1999 - PowerBuilder Developer. Romac Intl., Palm Beach Gardens, FL. Member of a
6 person software development team that was working on AIM (Asset Inventory
Management System) at Capital Asset Research Corp (Div of MBIA). Used
PowerBuilder 6.5, PFC, Sybase 11.x. AIM is being used by over 60 users. AIM
tracks Real Estate property liens purchased from Government agencies. Liens are
placed against Residential and Commercial Properties for non-payment of Real
Estate and School Taxes and Utilities. AIM tracks payments, over-payments,
electronic transactions, redemptions, collections, correspondence, properties,
and generates reports. Programmed PFC inherited windows, datawindows controls
u_dw, child datawindows, search criteria screens, events (item changed, open,
pfc_post_open, etc), tab-pages, menus. Created reports, PFC transaction objects
n_tr, window functions, datawindow objects, datastores, visual and non-visual
user objects and functions, user events, and cursors for manipulation of data.
Used SQL, Do and For Next Loops, cursors, functions, datastores for selecting,
inserting, deleting, and updating data in tables. Created tables for data
storage. Used OLE for connecting to MS Excel Files and PFC string parsing, arrays
for importing Excel data into datawindows. Modified datawindow where clause
dynamically. Used PFC MultiTable Update for datawindow update.
1998 / 1999 Systems Analyst. Computer Management Sciences Corp, Tallahassee, FL.
Member of a 2 person software development team that worked on Aramis (Automated
Reemployment and Medical Information System) for Florida Dept of Labor, Division
of Worker’s Compensations using PowerBuilder 5.0/6.5, PFC, and a DB2 Database.
150 users are using the system statewide. Aramis uses 8 modules to track injured
employees, treatment by physicians, fees charged for services, insurance
reimbursements, employee retraining, communications by phone, fax, or mail.
Worked independently adding functionality to new and existing modules.
Interviewed users. Conducted JAD sessions. Developed storyboards. Programmed PFC
inherited windows, datawindows controls u_dw, tab-pages, DDDWs, filter windows,
graphs, and reports. Used embedded SQL extensively. Used PFC services. Used PFC
transaction objects n_tr for connecting to databases. Created functions,
structures, cursors, tables, visual and non-visual user objects. Built OLE
interface to MS Word 95/97 to generate form letters. Exported data to flat-files.
Worked also at FL Dept of Transportation using Pontis, PowerBuilder 5.0 and an
Oracle 7.3 database. Created composite, group, crosstab reports. Programmed
windows, datawindows, child datawindows, and filters windows.
Sept. 1997 / March 1998 PowerBuilder Programming Training. FutureWise Inc,
Houston, TX. Received 6 months of classroom education in PowerBuilder 5.0 and SQL
Anywhere. Developed a Computer Asset Management System using PowerBuilder 5.0 as
class project. The system was designed as an MDI Frame application that gave the
user the ability to search for information about computer resources, vendors,
employees, addresses and record pertinent data on computer assets. Created an
application using: Inherited objects, windows, events, visual and non-visual user
objects, structures, structures, tab-pages, functions and database tables.
1995 / 1997 Process Engineer. Amoco Chemical Corp, Texas City, TX, Safety Relief
Valve Resizing Project. Performed engineering, relief valve, pressure drop, and
thrust calculations for process systems and refrigeration units using VAX
Mainframe, and Excel Spreadsheets. Used Aspen Plus extensively to simulate
chemical processes. Worked with PowerBuilder 5.0 applications that tracked
chemicals.
1989 / 1994 Process Engineer. John Brown E & C., Bridgewater, NJ, Engineering &
Construction. Worked at Merck & Co, Inc. Safety Valve Resizing Project. Performed
engineering calculations using Excel and Lotus. Worked at American Cyanamid
designing process to remove wastewater contaminants. Designed heat exchangers
using BJAC. Designed chemical process equipment. Acted as lead engineer on BASF
Resin Plant project. Developed and updated PIDs and PFDs using Intergraph
Microstation.
1988 / 1989 Process Engineer AT&T Bell Labs, Murray Hill, NJ, manufacturers of
lasers and light-wave devices. Operated Unix computer-controlled reactor to
produce laser diodes. Worked with VAX mainframe.
1983 / 1988 Senior Lab Technician. Witco Chemical Corp., Perth Amboy, NJ,
Specialty Chemicals. Performed in-process testing of Polyesters, Stearates, and
Surfactants using various instruments.
EDUCATION:
June 2002 – Java Programming (40 hour course) Productivity Point Inc, Maitland,
FL
Jan / March 2001 - Intro to C++ Programming (6 week 24 hour course ) Computer
Institute, SCC, Sanford, FL
October / Nov 2000 - Java Intermediate Programming (6 week 24 hour course)
Computer Institute, SCC, Sanford, FL
August / Oct 2000 – Intro to Java Programming (6 week 24 hour course ) Computer
Institute, SCC, Sanford, FL
Sept 1997 / March 1998 – PowerBuilder Programming Training (6 months)
FutureWise, Houston, TX
Bachelor of Science in Chemical Engineering, BSChe New Jersey Institute of
Technology, Newark, NJ GPA 3.43/4.0 |
