Email: ab9pao@r.postjobfree.com home: ***-***-

**** / ******: 347-***-****

Hamilton Straughn

TECHNICAL SKILLS:

Operating Systems:

Windows 7, Windows XP Professional, Windows 2000, Window 9x, Novell, NT,

Centrix, Lantastic, Mainframe

Software / Databases:

Visual FoxPro (all versions including FoxpPro), Visual Basic, SQL Server

(Triggers and Stored Procedures), OCR, Microsoft Word, Microsoft Excel,

Microsoft PowerPoint, Microsoft Access, Microsoft Project

Methodologies / Tools:

ADO, RDO, Active-X, COM, DCOM, ODBC, Transact-SQL, Normalization, Data

Manipulation, Object-Oriented Programming, X-base, GUI, Client / Server,

Stored Procedures, Business Objects, Triggers, MAPI, Automation Server,

Windows API, scanner, VBA

COMPETENCIES:

Analytical thinking, problem solving, customer focus, knowledgeable in

business, healthcare processes and systems infrastructure. Proven

experience in strategic planning and change management. Knowledge of both

theoretical and practical aspects of project management

WORK EXPERIENCE:

Business Analyst with Queens Hospital (Nurses Admin) Center in New York, NY

Oct. 2010 - Present

Responsible for performing and tracking budget modifications of various

difficulty levels for OTPS funds for 40

cost centers. Track workloads for several departments and provide analyst

to management using Excel graph.

Have critical understanding of hospitals' operation and systems. Designed

models in measurable terms to provide

workload and space needs. Designed several application and reports to

monitor in-patient and out-patient care.

Created appointment schedule used for rehabilitation outpatient clinic.

Microsoft Access2010 and Excel2010,

with VBA were used for development and analyst. Used Powerpoint2010 for

presentations and developing

department structures.

Project Analyst with MetLife (consultant) in New York, NY

Apr. 2007 - Mar. 2009

Provide information and help resolve user problems regarding department

systems. Act as liaison between

department and IT personnel to support the business needs. Represent user

in all system enhancements and design

activities. Recommend to management to produce more effective means of

accomplishing work. Reviewed user

requests and conducted data-gathering interviews. Provide support to

operating management by participating in

operational analyses and studies. Provide management with data required for

decision-making. Assist in

evaluating new processes for use in operating areas. Administer time entry

reporting in PeopleSoft 9.0.

Reviewed and validated users access was for SOX compliance. Used Transact -

SQL(SQL Server 2005) for

data to load into Access database or information needed for SOX compliance.

Support Analyst with Morgan Stanley (consultant) in New York, NY

Dec. 2005 - Nov. 2006

Documented and tracked IT related issues until completion. Provided an

overall atmosphere of continuity and

transparency with respect to application releases and resolution of issues.

Worked with supporting IT groups such

as Development, and Help Desk to resolve issues. Participated in

application testing during major releases and

patches. Logged all issues encountered for the purposes of trend

identification and consistent improvement of

services. Third level point of contact for clients and liaison to the

supporting IT teams. Identified, investigated,

and resolved IT related issues as well as escalating to application

specific support groups.

Project Manager with Police Pension Fund (consultant) in NY, NY

Oct. 2004 - Jun 2005

Planning and implementating the conversion of 41,000 personnel cards into

Access 2002. System used to manage

benefits for police officers. Assembled and coordinated a staff of 14

data entry and data analysis personnel. Set

up training classes on the processing of cards and the use of the software

system. Worked with end user to resolve

any problems relating to the conversion process or any additions that would

improve the system. Created data

entry manual and user guide for software system. Managed changes to project

and personnel to stay on schedule. Created workflow chart for the

conversion team. Scheduled work hours for each personnel. Track project

deliverables using Microsoft Project 2003 . Kept track of processing of

each card in Excel 2003.

Database Developer with TrackitandFindit in Pompano Beach, FL

May 2004 - Sep. 2004

Participated in the development of a client server application. Data

uploaded and downloaded to Web Server used

by law enforcement to track items sold and bought at pawnshops. Developed

several statistical reports to show

progress of project. Designed and implemented an on-line help for software.

Developed stored procedures

(combining SQL and Transact SQL language) and packages using SQL Server

2000. Created system flow

charts, manuals and user guide for software personnel and customers. In

charge of resolving any problems that

may arise from the customers use of software. Software developed in Visual

Foxpro 7.

Data Processing with JPMorganChase in Brooklyn, NY

Feb. 2002 - Apr. 2004

Processing State Tax Returns. Created user interface to produce statistical

reports. Created in Access 2000.

Support Analyst with Prudential Insurance in New York, NY

May 2001 - Jan. 2002

Lead the planning and implementation of database system for pre-hire unit.

System evaluates potential brokers

credit and criminal histories, by using a point system. New system was

authorized after providing charts and

reports that it would improve processing (accuracy and time).Created

several reports for system usin Access

Reporting. Originally developed in Access 97/VBA. Upgraded to Access

2000/VBA. Presented reports defining

project progress, problems and solutions. Project evaluations and

assessment of results.Delivered progress reports

to all stakeholders.

Database Developer with Vitaver & Associates in Planatation, FL

Feb. 1999 - Mar. 2001

Created survey reporting system for American Express, utilizing Visual

Foxpro 5. Created user guides and system flow charts. Provided cost and

time estimates for project. Upgraded an award system for personnel of

American Express. Correct many errors of previous system and made

improvements that gave accurate data.

Constantly monitored and reported on progress of all projects to

stakeholders. Implemented and managed

project changes and interventions to achieve project outputs. Provided

quality assurance. Tracked project deliverables using Microsoft Project 9.

Manager with Discovery Zone in Plantation, FL

Oct. 1997 - Nov. 1998

Lead the planning and implementation of developing an inventory system

using Clipper as POS and Foxpro 2.6

has back office. Helped facilitate the definition of project scope, goals

and deliverables. Coordinated 4 man

programming staff. Constantly monitored and reported on progress of the

project to all stakeholders. System

tracked purchase, pricing, consumption, transfer, and elimination of

products. Reconciliation system was added

using Foxpro 2.6. Over 200 stores utilized system. Developed plans for an

exact version in Visual Basic 5.0 as a

comparison to Foxpro. Developed specifications for job scheduler developed

in Visual Basic. Used SQL Server 7.0 for databases. Developed stored

procedures. Created specifications, system flow charts, all user guides,

and technical manuals for systems. Tested debugged and trouble-shooted all

systems. Trained all personnel on use of systems. Provided support for LAN

and all window operations. Position included hiring and firing personnel.

Database Developer with American Telnet in Plantation, FL

May 1996 - Sep. 1997

Converted a collection system developed in Foxpro2.6 to Visual Foxpro. MS

Word used to print letter from collection system. Upgraded customer credit

card debt system to Visual Basic. Designed accounting reporting system in

Visual Foxpro. Trained individuals on use of systems. Provided system

flowcharts for all systems.

Created technical and user manuals.

Foxpro Programmer with Vacation Break in Ft. Lauderdale, FL

Apr. 1996 - May 1996

Converted customized accounting system in Foxpro2.6 to Visual Foxpro.

Reversed engineered Foxpro2.6

Presented reports defining project progress, problems and solutions.

Reported evaluations and assessment of

results.

Project Lead with Discovery Zone in Ft. Lauderdale, FL June

1995 - Feb. 1996

Created stand-alone data conversion programs in Foxpro2.6. Enhanced and

maintained various reservation modules in Foxpro2.6. Lead the planning and

implementation of project. Facilitated the definition of project

scope, goals and deliverables. Defined project tasks and resource

requirements for programmers.

Foxpro Programmer with Cost Management Systems in Ft. Lauderdale, FL

July 1994 - May 1995

Enhanced a procurement system in Foxpro2.5. Maintained ad hoc reporting

system for procurement program in Foxpro2.5

Database Manager with Martin Marietta in Washington DC

Sep. 1991 - Oct. 1993

Maintained data and manuals for FAA. Designed department inventory system

in Foxpro. Exported data from

Dbase III, Lotus, and Excel. Determine what type of inventory would be most

useful for department. Report

the best use of the inventory.

Military: Served twelve years in the Air Force. Served eight of those years

with an elite unit the White House Communications Agency. Trained as

telecommunication personnel. Supervised from 4 to 30 personnel.

Clearance: Last clearance held was Top Secret / SBI

Education:

Associates degree in CIS

Currently enrolled (2005 - Present) - New York City College of Technology

(part of CUNY).

Studying Computer Systems

Contact this candidate