Margaret Kliban
abig03@r.postjobfree.com
Charleston, SC 29414
Programmer Analyst / Database Architect / Application Developer
. Information Technology Professional with over 18 years of industry
experience and a proven record of success in every phase of full life
cycle application development.
. Technology skills include extensive experience utilizing technologies
and standards such as Visual Basic, Delphi, SQL Server, Crystal
Reports, 4GL, Access, Pascal, SQL, and Open Ingress to produce
superior results for a diverse client base
. Proven success creating interfaces to facilitate database
functionality, overseeing and policing database enhancements and
changes
. Protect overall data integrity through strong management of
development and releases
Expertise
Programming Languages RDBMS Software
ASP, .NET MySQL Open Ingres Crystal Reports
8.0,11.0
VB 6.0, .NET Lotus Notes SQL Server 6.5 - Microsoft Visual
XML 2008 Studio
Coldfusion
C# COBOL MySQL SharePoint
Delphi 6.0, .NET RPG Microsoft Access Microsoft Office
2003
Pascal HTML FoxPro Visio
4GL PHP Publisher 2000
C/C++ Front Page 2000
SQL SC4
Experience
Hudson Mann, Inc (Charleston, SC)
Programmer (March, 2010 - Present)
. Brought on to help with a high profile project for HudsonMann with
tight deadlines. Developed a flexible data processing and import tool
using Coldfusion 9 and SQL Server 2008. Did whatever it took to get
the project done on time by working nights and weekends because of the
tight time constraints. Using Coldfusion 9.0 and SQL server, coded a
very flexible data processor for handling both plain text and Excel
files.
Medical University of South Carolina (MUSC)
Programmer (February, 2008 - January, 2009)
Worked as an administrator and programmer on Clintrack (3M-Softmed) - an
integrated system that uses SQL Server database and Crystal Reports to
oversee all hospital statistical patient information.
Created user groups, user accounts, and set up permissions
Created work lists and assigned them to different user groups
Updated lookup tables in Clintrack to correspond with data found in
Keane database
Created and implemented a Microsoft Access program to parse through
error logs and group errors into various categories
Modified Core Measure screens to make them more users friendly
Redesigned Financial screen
Tested work lists created by 3M
Created custom reports using Crystal Reports.
. Designed, coded, tested and maintained the Projects Database tracking
system of status department's projects using MS Access
. Modified the "Physician Profile for Peer Review" system - added a
report generator and search functionality.
. Designed, coded, tested and maintained an interface between diagnoses
related groups(DRG) and Service Lines using C#, MS Access, Crystal
Reports
. Designed, coded, tested and maintained the "Patient Stay Tracking
Database" using MS Access
Biowarn, LLC
Programmer (March, 2007 - August, 2007) - Contract
. Designed, coded, and tested a system using VB.NET and MS SQL Server to
manage large experimental data
. Designed graphical representation of data reconciliation, sorting, and
statistical analysis
Sigma Xi
Programmer (August, 2006 - February, 2007) - Contract
. Provided security access to an ASP.NET application driven by Pervasive
Database
. Designed and coded an encrypted credit card application using MS SQL
Server, MS Access, and Crystal Reports
Hill-Rom
Programmer (June, 2005 - July, 2006) - Contract
Designed, implemented, and improved statistical tools and user interfaces
using MS Excel and VBA.
Family Medical Care, Inc.
Programmer (April, 2005 - June, 2005) - Contract
Designed, coded, tested, and maintained the Medical Records Archive System
using Delphi.
Greenville Utilities.
Programmer (2000 - 2004)
Designed, coded, tested and maintained the following applications utilizing
Delphi, SQL Server, MySQL and Crystal Reports previously written in COBOL:
. Developed the "Payroll Budget System" - a multi-user application that
forecasts budgets for the following fiscal year and generates payroll
records for all company employees.
. Developed the "Cafeteria Plan" - an application that generates
statements for the accounting and human resources departments based on
entries in the payroll database (Empower)
. Developed the "Preventive Maintenance Program" - an automation
application that replaced manual processes for managing equipment.
. Developed the "Electronic Timesheet" - a timesheet management tool that
allows users to easily record their work hours based on temporal keys and
automatically updates the payroll database at the end of each pay period.
. Developed the "Inventory System" - a tool used to assist the warehouse
supervisor and staff in daily inventory, ordering, and stocking
management. It's updated through an interface with VAX.
. Developed the "Transformer Application" - an application used to certify
new transformers, track the inventory of transformers, and maintain a
history on locations and repair information.
. Developed the "Capital Plan" - a planning application that prepares multi-
year projects and work plans. It anticipates financing issues and rate
changes and supports rate analysis studies.
. Developed the "Telephone Statistics System" - an interface for providing
statistical information regarding all customer service calls.
ASMO
Programmer Analyst (1999 - 2000)
. Created an interface between AS400 and an MK database using 4GL and an
Ingress database.
. Additional projects also involved designing, coding, testing, and
maintaining systems using MS Visual Basic 6.0, MS Access and Crystal
Reports
Compusult, Inc.
Programmer (1997 - 1999)
Designed, coded, tested, and maintained applications using Delphi.
Productivity Systems Development Corp.
Application Developer (1997 - 1999)
Designed, coded, tested, and maintained applications using Visual Basic and
Crystal Reports.
University of Technology (Kharkov, Ukraine)
Application Developer
. Managed a staff of 5 and taught Mathematical Methods in Economics
. Developed, tested, and maintained applications using FoxPro, SQL,
Visual Basic, MS Access, Pascal and C/C++.
Education
University of Technology (Kharkov, Ukraine)
Bachelor of Science in Computer Science (Minors in Mathematics and
Economics)