Email: ******@***.*** home: ***-***-
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