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, Visual Basic.Net

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 processes and systems infrastructure

WORK EXPERIENCE:

System Analyst

Confidential

Administering OTPS budget. Track workloads for several departments and provide analyst to management. 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. Assist Rehab with closing procedures.

Microsoft Access2010, Excel2010, and VBA were used for development and analyst.

Confidential

Project Analyst

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 Oracle/PeopleSoft.

Support Analyst

Confidential

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.

Data Management Supervisor

Confidential

Responsible for overseeing the conversion of data from 41,000 personnel cards into software system. System used to manage benefits for police officers. Managed day to day operations of 14 data entry and data analysis personnel. Position included hiring and firing of 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. Created workflow chart for the conversion team. Scheduled work hours for each personnel. Provided time estimates for each phase of the project. Kept track of processing of each card in Access and Excel.

Database Developer

Confidential

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. Designed and implemented an on-line help for software. Developed stored procedures combining SQL and Transact SQL language and packages. 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.

Data Processing

Confidential

Processing State Tax Returns. Created user interface to produce statistical reports. Created in Access 2000.

Support Analyst

Confidential

Developed database system for pre-hire unit. System used to evaluate 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. Originally developed in Access 97. Upgraded to Access 2000. Documented and tracked pre-hire related issues until completion. Worked with supporting IT groups.

Database Developer

Confidential

Created survey reporting system for American Express, utilizing Visual Foxpro. Created user guides and system flow charts. Provided cost and time estimates for project. Upgraded an award system for personnel of American Express using Visual Foxpro. Correct many errors of previous system and made improvements that gave accurate data.

Manager

Confidential

Developed inventory system with Foxpro2.6. System tracked purchase, pricing, consumption, transfer, and elimination of products. Developed reconciliation system with Foxpro2.6. Linked to inventory system. Over 200 stores used system. Reverseded engineered Foxpro2.6. Inventory system and reconciliation system converted to Visual Basic5. As part of conversion had to make sure VB system worked same as Foxpro system by comparing data and reports. Created specifications, system flow charts, all user guides, and technical manuals for system using Microsoft Word. Tested debugged and trouble-shooted all systems. Trained all personnel on use of systems. Created data process system with SQL Server and Visual Basic. Developed stored procedures.Created job scheduler in Visual Basic. Provided support for LAN and all window operations. Supervised seven personnel, which included planning, developing, testing and installing software. Position included hiring and firing personnel.

Database Developer

Confidential

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.

Foxpro Programmer

Confidential

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

Foxpro Programmer

Confidential

Created stand-alone data conversion programs in Foxpro2.6. Enhanced and maintained various reservation modues in Foxpro2.6.

Foxpro Programmer

Confidential

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

Database Manager

Confidential

Maintained data and manuals for FAA. Designed department inventory system in Foxpro. Exported data from