Post Job Free

Resume

Sign in

Sql Server Customer Service

Location:
Charleston, SC, 29407
Posted:
October 05, 2010

Contact this candidate

Resume:

Margaret Kliban

abig03@r.postjobfree.com

**** ********** ******

919-***-****

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)



Contact this candidate