Post Job Free

Resume

Sign in

Sql Server Ms

Location:
Palm Harbor, FL
Posted:
December 24, 2016

Contact this candidate

Resume:

HAN BOK KIM

PRESENT ADDRESS

**** ****** **.

Palm Harbor, FL 34685

(727) 458 - 9303

acxz45@r.postjobfree.com

EDUCATION

MS In Computer Science Courses work completed from Florida State University at Tallahassee, Florida, May 1988

BS In Mathematics from Indiana State University at Terre Haute, Indiana, May 1985

BS In Computer Science from Indiana State University at Terre Haute, Indiana, May 1983

BA In English Literature from Soong Jun University at Seoul, Korea,

February 1981.

WORK EXPERIENCE

08-2014 to Present: Application Database Developer – Eckerd Kids, Inc.

Supervisor: Ray Wright 727-***-**** x 3224

Currently Developing Lease Contract (over 200 different locations) Tracking System for Risk Management Department using ASP.NET/VB.NET/Access 2010/MS SQL Server 2012

Developed Multifunction Device Tracking System for Facility Department and Accounting Department using ASP.NET/VB.NET/Access 2010/MS SQL Server 2012

Developed CMS Tracking System for Children out of Home Care (Foster Home or Group Home) or health check-ups required by Florida Department of Children and Family using ASP.NET/VB.NET/Access 2010/MS SQL Server 2012

Developed Preliminary Family Profile, Family Profile, Household Profile, Placement Profile, Orientation, Pre-service Class Setup, Pre-service Class Registration, Update Pre-service Class Roster Electronically, Initial Licensing Process, Family Notes, FDS Visit Log, Disaster Preparedness Plans for Foster Homes, Relicensing Process including over 75 Reports using ASP.NET/VB.NET/Access 2010/MS SQL Server 2012

Developed Employee Hiring Tracking System for HR using ASP.NET/VB.NET/Access 2010/MS SQL Server 2012

02-2000 to 06-2013: Information System Software Engineer – Florida Blood Services, Inc.

Supervisor: Chandler Mapes 813-***-****

Developed all FBS Vehicle Maintenance Tracking System for FBS Operations Department using ASP.NET/VB.NET/Access 2010/MS SQL Server 2012

Developed the Travel Expenses Tracking System for all FBS Employees using ASP.NET/VB.NET/Access 2010/MS SQL Server 2012

Developed the Reporting Diseases Tracking System to report Donors who has serious diseases to State and County Government using ASP.NET/VB.NET/Access 2010/MS SQL Server 2012

Developed the Critical Equipment Maintenance Tracking System for FBS Operations Department using ASP.NET/VB.NET/Access 2010/MS SQL Server 2012

Developed the Critical Equipment QC, Calibration and Preventive Maintenance Tracking System for FBS Donor Testing Lab Department using ASP.NET/VB.NET/Access 2010/MS SQL Server 2012

Developed the Donor Calls Log Tracking System for FBS Control Document Department using ASP.NET/VB.NET/Access 2010/MS SQL Server 2012

Developed the Vendor Equipment Contract Tracking System for FBS Operations Department using Microsoft Visual Studio.NET/MS SQL Server 2005

Developed the Critical Equipment Request System for all FBS Employees using Microsoft Visual Studio.NET/MS SQL Server 2005

Developed the Critical Equipment Error Management System for FDA requirements using Microsoft Visual Studio.NET/MS SQL Server 2005

Developed the Barcode Check Processing System for FDA requirements using Microsoft Visual Studio.NET/MS SQL Server 2005

Developed the Examiners Log Processing System for FDA requirements using Microsoft Visual Studio.NET/MS SQL Server 2005

Developed all Current Information System Employees Project Progress Tracking System required by FDA using Microsoft Visual Studio.NET/MS SQL Server 2005

Developed the Parvo Pooling Tracking System for FDA requirements using Microsoft Visual Studio.NET/MS SQL Server 2005

Developed the Plasma Freezing Process Tracking System for European Union using Microsoft Acess/MS SQL Server 2005

Developed the Nationwide (US) Blood Sample Tube Testing Tracking System using Microsoft Access/MS SQL Server 2005

Developed Employees and Volunteers Hepatitis B Tracking System using Microsoft Access/MS SQL Server 2005

Developed Employees and Volunteers Training Tracking System using Microsoft Access/MS SQL Server 2000.

Developed Blood Unit Cost per Draw Tracking System for 13 different sites and about 25 mobiles using Microsoft Visual Basic 6.0/Access/MS SQL Server 2000.

Developed the Inventory Tracking System for Software and Hardware in the Company using Microsoft Visual Basic 6.0/Access/MS SQL Server 2000.

Developed Data Warehouse for the Florida Blood Services, Inc using Microsoft Visual Basic 6.0/Access/MS SQL Server 2000. This project had 4 different phases. Data are imported from 2 different Systems.

Collection Tracking System – How many units FBS collects by sites and all mobiles. What different types of blood FBS collects daily, weekly, monthly, quarterly and yearly. Keep tracking of total deferred, new donors etc.

Production Tracking System – What different components FBS makes from units collected.

Transformation Tracking System – Pre-unit and Post-unit numbers by Component Group daily, weekly, monthly, quarterly and yearly.

Issuances Tracking System – Keep tracking of Issuances to all Hospitals by Component Group, by Services, by Facility, by Facility Group.

Developed Blood Transfusion Tracking System (BTTS) for Mease Countryside Hospital and Mease Dunedin Hospital using Access. The BTTS system read the bar codes from the blood packages shipped from Florida Blood Services and processed packages for the final disposition.

Customer Name: Betsy Wetherington 727-***-**** Mease CountrysideHospital

Customer Name: Bob Ferguson 727-***-**** Mease Dunedin Hospital

Processing Level - Unit Assignment to Patient with Doctor’s record. Inventory Control System. Unit Reversal and Substitution System. Unit Pooling and Dividing System. Unit Transfer, Unit Release, Unit Transfuse, Unit Expire, Unit Discard, Unit Back to FBS, All Units History including Pooled or Divided, All Units Final Status etc.

Reports Level - Blood Inventory Status, Patients Receiving Blood in a Given Period, 7 Day Expiration, Blood and Component Shipping Form for Inventory and Inter Hospital, Blood Units Expired, Blood Units Discarded, Hospital Blood Order, Completed and Failed Transfusions Report with C/T Ratio by Specialty and Doctor.

Developed Human Leukocyte Antigen Application Program which searched the Donor Database to find a set of possible donors who had the same antigen type for patients using MS Access.

02-95 to 02-2000: Sr. Software Engineer -- UNISYS INC.

Supervisor: Rose Oaks, Unisys Inc. 850-***-****

Developed the Kentucky Medicaid Eligibility Verification and Voice Response Subsystem using C, UNIX system calls.

Modified the existing Ad Hoc Subsystem in Florida Medicaid Management Information System and implemented this Ad Hoc Subsystem to Kentucky Medicaid Management Information System using Intelligent Query, Mapper, Informix-4GL/SQL Relational Data Base System in UNIX environment.

9-89 to 2-95: Software Engineer -- GTE Telecom Inc.

Supervisor: Stan Bennett, GTE Telecom Inc. 850-***-****

Designed, coded, tested and implemented the site-specific software for the State of Florida SUNCOM NETWORK. Developed various interfaces between PASCAL, C, DCL and Informix-4GL/ESQLRelational Data Base System in VMS environment. Trained and assisted end users. Updated existing software.

Headed following projects from design through implementation

1) SMDR AS ALARM (SAA) project.

2) Trunk Group Peak Usage Project (Phase I).

3) Traffic Management System Project (Phase II).

4) CSA/CPLA Tracking System Project.

5) Master Station List System Project.

6) Pending Order List System Project.

7) Network Facility System.

8) Engineering Traffic Management System (Phase III).

05-85 to 09-89: Programmer Analyst/DBA – Florida State University

Supervisor: Mac Hall, (850) 644 - 3410

Developed the completed accounting package software for Institute of Science and Public Affairs using C, FORTRAN, Awk, Shell Scripts and Unify/SQL Relational Data Base System in UNIX environment. Trained and assisted users. Performed system management, updated systems and existing software, and installed new software.

05-85 to 05-88: Mathematics Instructor – Florida State University

Supervisor: Dr. Betty Case, (850) 644 – 3068

Taught Business Calculus and College Algebra.

TRAINING

Developing Application using INFORMIX-4GL/SQL, October, 1989 Informix Software Inc., California.

Administrating a MS SQL Server 2000 Database, May 7-11, 20001 Microsoft Corp.

Programming a MS SQL Server 2000 Database, June 11-15, 2001 Microsoft Corp.

Database Implementation a MS SQL Server 2000 Database, September 21-55, 2001 Microsoft Corp.

ASP.NET Programming, March 14 – 18, 2005 Microsoft Corp.

SQL Reporting Services, October 17-21, 2005 Microsoft Corp.



Contact this candidate