SOFTWARE/DATABASES:

• VBA, Access, Excel, SQL Programming, MSQL Server, Java, Python, Visual Basic, XML,
• Crystal Reports, C

VBA Development

• Proven background translating cell formulas in Excel to VBA code. Using Access and Excel based VBA
• to design, analyze, and deploy programs for financial and health services. Extensive experience creating
• user interfaces. Experience in completing projects under financial and time constraints. Using Rapid
• Application Development RAD techniques. Use Open Database Connectivity ODBC to connect to
• SQL Relational Database Management Systems RDBMS .

Data Analyst

• Skilled in researching and analyzing data. Diligent in analysis to come to correct conclusions. Can easily transfer
• data into an understandable document. Can write and speak clearly, easily communicating complex ideas. Can
• look at the numbers, trends, and data and come to new conclusions based on the findings. Highly skilled in math
• to estimate numerical data.

Project Coordinator

• Knowledge of industries includes financial services, software and, health care. Can write and speak clearly easily
• communicating complex ideas. Experience with Microsoft Project. Proven supervisory experience. Experience in
• completing projects in timely manner. Experience with working with Executive management. Skilled in various
• software including coding and querying. Ability to create reports for projects. Extensive experience in planning,
• designing, and implementing each stage of a process. Make sure team has material and support to complete project. Experience with budget reports. Basic Accounting principles. Customer services experience. Expertise
• in Microsoft Office Suite. Experience scheduler.

WORK EXPERIENCE:

System Analyst

Confidential

• Produce Other than Personal Staffing OTPS Budget reports for 30 departments.
• Create workloads reports 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.
• VBA Developer Responsible for all project life cycle from specifications and coding through
• deployment, testing, debugging, and documentation, and maintenance.
• Assist Rehab with financial closing procedures in Unity.
• Ensure projects were completed on time and within budget.
• Created VBA programs to automatically update Excel workbooks.
• Provided customer service for Rehabilitation department.
• Scheduled patients using Soarian system.
• Microsoft Access2010, Excel2010, and VBA for development, reporting and analyst.

Project Analyst

Confidential

• Provide information and help resolve user problems regarding department systems.
• Act as liaison between department and IT personnel to support the business needs.
• Instruct user in all system enhancements and design activities.
• Provide 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 analyst required for decision-making.
• Assist in evaluating new processes for use in operating areas.
• Administer PeopleSoft.HCM.
• SQL to extract data for reporting and analyst.
• Microsoft Access, Excel, VBA, and SQL for development, reporting, and analyst.

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.

Manager

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.
• Reporting
• 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.
• SQL queries for Ad Hoc Reporting.
• 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.
• Responsible for specifications, coding, deployment, testing, debugging, documentation, and maintenance.
• Developed using VBA.
• SQL queries for Ad Hoc Reporting.
• Worked with supporting IT groups.

Database Developer with Vitaver Associates in Planatation, FL Feb 1999 Mar 2001

Confidential

• Created survey reporting system for American Express, utilizing Microsoft Access.
• Created user guides and system flow charts. Provided cost and time estimates for project.
• Upgraded an award system for personnel of American Express using Microsoft Access. Corrected 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.
• 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.
• Ad Hoc Reporting.
• 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.
• Reverse engineered Foxpro2.6.

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 Dbase III, Lotus, and Excel.