Todd W. Frankson
940 North Providence Rd., Apt C-8
Media, PA 19063
Home- [Send email to request phone number] 72-4173 Cell- [Send email to request phone number] 09-2456
OBJECTIVE: Seeking a position with a strong growth oriented Corporation.
EMPLOYMENT HISTORY:
Jan. 2006 to Aug. 2008 Delphi Programmer/Analyst
MedTrials, Dallas, TX
Provided Delphi 7 support to a Clinical Trials database applications group.
Maintained consistency within multiple databases, 2 copies of each with
records totaling over 2,000,000.
Supported the System Architect, and the Data management group for reporting
needs.
The system is a 3-part N-tier system.
Wrote custom ad-hoc SQL on a regular basis for management.
Exported data to several formats.
Imported data from several formats
Wrote stored procedures and triggers for the RDBMS.
Interacted with other Departments and managers.
I wrote many small utilities to help my group, as well as other groups,
perform their tasks.
Feb. 2004 to Dec. 2005- Consultant
Modis IT, Conshohocken, PA.
A.I.G.
Code Insurance Policy Forms utilizing DocuCreate.
Support users of Docuview Software with both installation and end user help as
needed.
Code A.I.P.S.O. forms of Policies as Endorsements to Policies.
Interact with The Compliance Department regarding accuracy and solicit sign
off on forms.
Managed over 700 forms, and status/location of the forms between 4
Departments, including farming out some of the document load to an A.I.G.
division located in India.
Work with A.I.G. India on a daily basis via Phone as support for their issues
regarding DocuCreate installation, setup and ongoing support.
Analyze documents and provide workload estimates.
GLAXO SMITH KLINE
Utilized Delphi 6.0 for bug fixes and enhancements in a client server
application provided to 4000 users worldwide, as well as provide end user support
to the user base via phone and email.
Work with end users worldwide in testing bug fixes and new bug reports.
Utilized PL/SQL to debug and enhance Oracle Packages/Stored Procedures.
Utilized InstallShield and WinInstall for deployment in 3 different standard
configurations for company wide rollout.
2 Version releases in less than 6 months time company wide.
Documented system for turnover to a 3rd party for future support.
Sept. 2000 to Mar. 2003- Systems Administrator II / Delphi Programmer
Pharmaceutical Research Associates, Inc., Charlottesville VA
Provided End user support for a project management application.
Supported over 900 users at start, system ended with over 2000 users.
The system projected financial data for the company.
The system was a 3-part N-tier system. A web interface for project data, a
stand alone application for users, and an Oracle database.
I re-wrote the client application in Delphi 5-6 to ensure the company could
expand at the rate it did.
I troubleshot the Web interface and coded in HTML, CSS and ASP to resolve
bugs.
I wrote PL/SQL to help retire the system.
Assisted in Implementing Lawson and Data-basics to replace the system
Interacted with other Departments and managers.
I wrote many small utilities to help my group, as well as other groups,
perform their tasks.
I was promoted From System Administrator I to System Administrator II during
my time at P.R.A.
Dec. 1999 to Sept. 2000- Programmer / Analyst III
First Virginia Banks, Inc., Falls Church, VA
I maintained a client / server GUI application using Delphi 3.0 named the
Automated Collateral Management System.
The system contained all collateral documentation for all loans with the
bank.
There were 70 client workstations connected to an Oracle Database containing
100+ GB of scanned documents and corresponding data.
I was also responsible for a Sendero Asset Liability Management Oracle
database on a Microsoft N.T. server
I worked closely with the acting Oracle DBA regarding both the ACM database
and the Sendero database.
Nov. 1998 to Nov 1999- GUI Programmer / Analyst
Alta Systems, Inc., Alexandria, VA
I developed client/server GUI applications using Delphi 3.0-4.0.
The Database utilized was SYBASE.
I completed the project I was hired for a month ahead of schedule.
The project was a prototype of data analysis software for the detection of
welfare fraud by retailers.
The software was used by Food and Nutritional Services agents to detect
discrepancies in sales within these stores by running algorithms against their
transaction data.
Upon completion, I merged this prototype into a distributed software package,
producing an upgrade. The software is called A.L.E.R.T. (Anti-fraud Locator
using EBT Retailer Transactions).
Merging the products was completed on schedule.
Dec. 1997 Nov. 1998- Applications Developer / Analyst
Telco Communications / Excel, Chantilly, VA
My function was to develop in-house and vendor bound software.
The in-house development ranged from converting Clipper / FoxPro database
applications, utilizing over 50 tables, to client/server applications with SYBASE
database.
I was a member of a team of developers primarily using Delphi 2.0 and Delphi
3.0 client/server to complete the task.
I used and wrote stored procedures and queries.
I also wrote new utilities almost daily to process data in the legacy system
(dBase / Clipper).
I wrote several stand-alone applications for individuals within Telco, as
needed and to their specifications, utilizing Install Shield Express for
installation.
I also created a custom PC inventory program to inventory specific directories
of machines, and silently connect and logon to a secured server and write the
information to the specified drive.
The vendor bound software involved several different teams, and several
different applications. I was required to write a utility that could extract
data via query, and create several output files. It also read the return files
from outside agencies, and updated the database as needed.
I was involved in the life cycle of the project from specifications to
delivery and worked hand-in-hand with Quality Assurance personnel to be proactive
in identifying issues and correcting them.
Jul 1997 Dec 1997- Technical Consultant
Financial Dynamics, Inc., McLean, VA
My duties were to answer questions and address technical issues for end users
of American Express P.O.S Software.
I was also responsible for assisting the development teams, in beta testing
software, and assisting in development as needed.
I wrote several Delphi components at this time.
I wrote several freeware programs that were available on the Internet.
I also started learning C++, J++ and Visual Basic at this time to enhance my
skills and productivity as a developer. I taught myself HTML and built my own
Web site.
Mar 1997 to Jul 1997- Technical Support Specialist
C.A. Consulting for ICF Kaiser, Fairfax, VA
My duties as a Technical Support Specialist were to provide end user support
to over 1200 users.
I provided telephone as well as on site support for users nation wide.
I installed most major software packages of the time, as well as used these
applications on a daily basis.
I wrote several small utilities to assist the technical support team in
maintaining the end-users PCs.
EDUCATION:
Certifications
Element K
Active Server Pages: Level 1, Part One
Active Server Pages: Level 1, Part Two
HTML 4.01 Web Authoring: Level 1
HTML 4.01 Web Authoring: Level 2
HTML 4.01 Web Authoring: Level 1 (Accessible)
HTML 4.01 Web Authoring: Level 2 1 (Accessible)
A+ Certification: Core Hardware Part One
Object-Oriented Programming Principles
Windows 2000 for Windows NT Administrators, Part One
Windows 2000: Installation and Administration, Part One
I-Net+ Certification, Second Edition, Part One
I-Net+ Certification, Second Edition, Part Two
E-Business: Fundamentals of E-Commerce
Server+ Certification
A+ Certification: Operating Systems, Part One
I-Net+ Certification (Third Edition)
Gathering and Analyzing Business Requirements
Project Management Fundamentals, Part One
Project Management Fundamentals, Part Two
A+ Certification: Operating Systems, Part Two
Learning Tree
Oracle PL/SQL Programming: Hands-On
Brainbench
MS Windows 95 Navigation
WWW Concepts
SQL (ANSI)
MS Windows 95 Administration
Web Server Administration
Delphi 3.0
Programmer/Analyst Aptitude
MS Windows 98 Navigation
High School Diploma Graduation date: 1988
The Packer Collegiate Institute
Brooklyn, NY
SOFTWARE / HARDWARE:
Delphi 1-Delphi 2006, Microsoft Visual Basic 4.0, Microsoft Visual C++, Visual
J++, Oracle SQL, Sybase SQL, Clipper, FoxPro, HTML, Lotus 1-2-3, Microsoft
Windows (3.1, 3.11, 95, 98, NT 4.0, 2000, 2000 Advanced Server and XP), Microsoft
Office (Professional and Standard versions 4.3, 95, 97, 2000 and 2003),
WordPerfect version 6.1, WordPerfect Office Suite, Lotus Notes, Remote Mail
(RAS), Microsoft Mail, Microsoft Messaging, Microsoft Internet Explorer, Netscape
Navigator, Peoplesoft, Lawson, Data-basics, DocuCreate, IBExpert.
8+ years experience with full life-cycle development.
NETWORK:
Administrator on a 1200+ user Token Ring LAN/WAN; setup and configuration of
Windows 95 peer-to-peer network; built, configured and installed Windows NT 4.0
servers; troubleshoot network technical difficulties, install and configure
printer drivers for HP 5SI, HP 4MP, HP III, test and troubleshoot memory,
software, hardware and end user PC issues; repair and maintain laptop and desktop
PCs.
|
