FERDINAND J. TORRES

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

Pembroke Pines, Fla. 33029

Home: 954-***-**** (Secondary)

Cell: 954-***-**** (Secondary)

E-mail: i4vvm4@r.postjobfree.com

SUMMARY

A skilled professional with significant supervisory experience in the Medical Laboratory and I.T. Industry. A team player who utilizes a whole range of skills including: Team Building, Supervising Personnel, Quality Assurance, Quality Control, Database and Crystal reports development. Familiar with ISO (International Standards Organization), GMP (Good Manufacturing Standards), Fluent in English and Spanish.

PROFESSIONAL EXPERIENCE

Lennar Corp 07/2009-08/2009

Contract Consultant TEK Systems, Inc.

Report Analyst

• Modification of current Oracle CRM Seibel reports.

• Creation of new reports per user specifications.

• Creation of report dashboards using the Oracle CRM Tool.

• Documentation of current and new report definitions.

• Creation of the reporting standards for Lennar's BI dept.

Memorial Health Services 01/2009-07/2009

Contract Consultant

Crystal Reports Developer

* Creation of Entity Relationship diagram of the ARTIVA® System.

* Using TOAD® for Systems Analyst to create complex SQL Queries and inserting them in Crystal SQL commands to create Crystal Reports.

Assurant Insurance Company 09/2008-01/2009

Contract Consultant TEK Systems, Inc.

Crystal Reports Developer

* Responsible for creating complex queries and inserting them as crystal report commands for the CAR Collateral Assessment and Recovery Insurance application.

* Created complex reports and charts to produce the amount of repossessions.

* Created reports that contained information detailed information on loan and lease accounts.

* Created a report containing loan, lease and combined account information by inserting 8 sub reports to display the information in one report.

* Created several crystal commands the produced reports containing collateral and assessment information based on shared variables and complex formulas. These reports also displayed a pie chart containing repossession summaries.

ZLB Plasma 5/2008 – 07/2008

Contract Consultant TEK Systems, Inc.

Database Developer

* Responsible for the analysis and development of the ALTO Database Application.

* Loaded data using /SQL scripts to populate the Alt Data from EXCEL to ACCESS 2007

* This application was coded using Visual Basic for applications and ADO.

* Design and Creation of information reports from the ALTO database.

* Design and Creation of Capital Expenditure Database.

Cordis a Johnson & Johnson Company 7/2007 – 04/2008

Contract Consultant Kelly IT Services, Inc.

MS ACCESS Database Administrator/Developer

* Responsible for the development maintenance and improvement of the IT Systems used to support the Change and Process Controls Quality Systems.

* Develop, validate (if required) and maintain MS ACCESS databases to store information.

* Generate metric and information reports from the databases.

* Develop and maintain department web site.

* Create IT solutions to improve the efficiency and compliance of the Change and Process Control processes.

* Interface with the business unit counterparts for the VOC (Voice of the customer) and the implementation of system improvements.

* Recoding in Visual Basic a data entry application using unbound forms ACCESS 2000 VBA ADO.

Discovery Channel Latin America 10/2003 – 12/2006

Contract Consultant for COMSYS Information Technology Services, Inc.

Database/Crystal Reports Developer

* Utilized the oracle backend structure, to emulate IBMS (Integrated Broadcast Management System).

* Analyzed business rules for the reports based on the database structure.

* Created a tape library label system by combining, ACCESS, Visual Basic and Oracle views and stored procedures.

* Set up a Crystal Enterprise 9 Server and supervised users account access.

* Creation of complex views using Oracle.

* Created of functions using Oracle.

* Created of tables with indexes and constraints using Oracle.

* Created of stored procedures using PL/SQL thru packages to loop thru record sets to populate data in temp tables with the creation of sequences using Oracle.

* Created on customized repots using Crystal Enterprise 9.0.

* Created of customized Crystal reports in 3 different languages for the listing of description of programs in Latin America.

* Created of numerous complex reports using Crystal Reports for Media Content along with the corresponding views in Oracle. Types of reports created were Media Library Report, Daily Promotions Report, Delivery Notes, Dubbing Studio Report, Past Due Report, Pull List Report, Dubbing and Distribution Report.

* Reverse Engineering of Tables using Oracle scripts and ERWIN Data Modeler to construct views for the Crystal Reports for IBMS Sales Module.

* Performing ETL techniques by creating PL/SQL stored procedures and then creating Oracle packages and global temp tables for customized Crystal Reports.

United Health Group 8/2003 – 10/2003

Database Programmer (Contractor for TEK Systems)

* Responsible for creating complex queries to summarize member data for the ELDERCARE program using ACCESS 2000. Queries created include, creating temp tables, and summary queries to display statistical data for this program.

* Created code to update tables using VB and ADO.

* Responsible for creating reports and graphs based on the summary queries above using EXCEL and Crystal Reports.

Nordis Direct 12/2002 – 02/2003

Database Programmer (Contractor for Global Resource Partners, Miami FL)

* Responsible for maintenance and additions to the NORDIS DIRECT TEAMHEALTH Import Application. This was an ACCESS Database with a front end coded in VB. This application runs complex queries in which the tables are attached to DB5 files. Enhancements coded; routines to parse out address data, updating credit and collections fields, creating complex queries for data extraction and data conversion.

* Responsible for the design and creation of the NORDIS DIRECT TEAMHEALTH ACCOUNTING application. This an ACCESS Database with a front end coded in VB. This application contains various data entry forms to process accounting data. Invoices are generated for the clients using the ACCESS 97 Report Writer. The reports are converted to HTML format; the Invoices are then electronically submitted to each client. This application also contains a routine in which the Database is compacted and repaired once a month.

Kemper National Services, Plantation FL 5/2000 – 6/2002

Programmer Analyst

* Responsible for the design and creation of Nominations, a software application used for storing provider data and using VB 6.0, ADO, Crystal Reports 7.0, ACCESS, SQL Server 7.0 and SQL stored procedures. This application also contains a report feature.

* Responsible for the redesign and coding using SQL Server 7.0. All embedded SQL was converted T/SQL stored procedure connected thru ADO (ActiveX Data Objects) and VB 6.0 as a front end for the wallpro software. Create Visual Basic class objects to minimize code behind the forms.

* Designed and coded a Report Program using VB 6.0 with ADO, SQL Stored Procedures using T/SQL and Active Reports.

* Designed and coded a Web page using ASP, SQL Server 7.0 SQL Stored Procedures using T/SQL ADO (ActiveX Data Objects) to enter and retrieve weekly status report data.

* Designed and coded a FTP component using VB INET control to download dbf and text files with provider information. These tables were then imported into an ACCESS database. Three Visual Basic Class Objects were coded, one for FTP for the file, one for converting of the text file and the other to process the database.

* Designed and coded Provider Reports and Invoices using Crystal 8.5, SQL Server 7.0 views, T/SQL stored procedures and ORACLE views as the data sources thru ODBC connections.

Oral Health Services, Miami, FL 4/2000 – 5/2000

Programmer Analyst (Contractor for the MAXIM Group, Miami FL)

* Responsible for the maintenance of data in the Pro-Claims Dental Insurance software using INFORMIX as the database and creating SQL queries to perform these tasks.

* Responsible for the redesign and creation of E.O.B (Explanation of Benefits) using Informix and ACCESS to extract data and using Crystal Reports.

* Responsible for auto loading Dental Fee Schedules using EXCEL, Informix and SQL into the Pro-Claims System.

* Responsible for the redesign and coding using ACCESS and VB as a front end of the Dental Fee Schedules which are now currently done using EXCEL.

Business Risk Technology Fort Lauderdale FL 5/1999 – 4/ 2000

Database Programmer

* Responsible for maintenance and additions to the WINBOARD Home Insurance Application.

* Created complex queries for data extraction and data conversion.

* Extracted ASCII data files for conversion to ACCESS of JUA (Joint Underwriters Association) for United Property and Casualty for Insurance premium re-rating of their insurance polices assumptions.

* Designed and coded a Function to convert California Homeowners insurance codes from one insurance company to another. Created a report program in which the user generates cancellation notices for the WINBOARD system using VBA.

* Created customized reports for American Superior and United Casualty and incorporated those reports in the WINBOARD system using VBA.

* Created a conversion program using SQL statements and VB for earthquake and homeowners policies for the California clients.

* Created an alignment tool for reports using VB.

* Created check numbering routine using VB and ACCESS.

ProxyMed Inc. Fort Lauderdale FL 8/1997 – 5/1999

Implementation Specialist/QA Tester/Database Programmer

* Designed and coded an Anomaly Tracking System using ACCESS and VB as a front end to keep track of open and closed issues for the ProxyMed products. These modules also had customized reports to print open and closed issues, test cases and scenarios

* Programming macros using Visual Basic for Applications.

* Designed and coded a tool for statistical reporting of number of open and closed issues of the ProxyMed products using ACCESS and VB.

* Programming databases using ACCESS 97.

* Read and interpret Sequel and Visual Basic 5.0 code.

* Create medical laboratory reports using Crystal Reports.

* Documented bugs and failures in the ClinScan Laboratory communications software by using test data from various clients.

* Performed Black Box Testing, White Box Testing, and Unit Testing of the ClinScan Laboratory and Proxycare Pharmaceutical Software.

Proxymed Continued:

* Performed Black Box Testing, Incremental Integration Testing, Functional Testing, End to end Testing, Load Testing and Stress Testing of the ClinScan Laboratory communications software and the Proxycare Pharmaceutical Software.

* Created Scenarios, Test Cases for the ClinScan Laboratory communications software and Proxycare the Pharmaceutical Software.

* Testing of the communication and merge programs with the assistance of the Lab Information systems of Cerner, Sunquest and Antrim.

* Provided working specifications of proposed changes in the software detailing the functionality and logic.

* Documented customer request for the enhancement of the ClinScan software.

* Responsible for the training of the Windows 95 ClinScan clinical laboratory order entry and communications software.

* Responsible for providing customer support of the DOS version of ClinScan clinical laboratory order entry and communications software.

COULTER CORPORATION, Miami FL 1/1994 - 5/1997

Instrument Specialist

* Responsible for the direct supervision of the Hematology Release Testing Laboratories assay section. The primary objective of the Hematology Testing Laboratory was the generation of control and calibrator values for the different blood cell analyzers the Corporation sells and supports.

* Designed, coded and tested a VB macro to process numbers generated by the STKS and MAXM instruments laser positional parameters

* Designed, coded and tested a VB macro that automated a log of products by product identification, lot number, expiration date, and date of the release of the product. This procedure was previously done manually.

ASSOCIATES IN INTERNAL MEDICINE, Hallandale FL 6/1993 - 1/1994

Lab Supervisor

Responsible for supervising the laboratory staff of the doctor’s office

Monitored Quality Control values, wrote new procedures, calibrated instruments

DOCTORS HOSPITAL, Hollywood FL 9/1991 - 6/1993

Shift Supervisor

Responsible for supervising the evening and night shift laboratory staff

USVA MEDICAL CENTER, Miami FL 8/1989 - 9/1991

Medical Technologist

Medical Technologist Generalist on the evening and night shift

PROGRAM PLANNERS, INC., New York NY 1/1987- 8/1989

Computer Programmer

Responsible for designing, maintaining and troubleshooting COBOL programs for the Teacher’s Retirement System of the City of New York. The computer used was the HP3000 microcomputer.

* Designed, coded and debugged COBOL programs involving payroll for Death Benefits payments by accessing KSAM files through menus using subprograms and JCL’s.

* Created a private volume set with retirement applications to be used as a training mechanism for new employees.

* Formatted screens for Data entry using V-Plus 3000.

* Designed, coded and debugged a COBOL program for automated check production. This resulted in a rapid processing of disbursements of funds replacing the manual method.

USVA MEDICAL CENTER Brooklyn NY 11/1984 - 1/1987

Medical Technologist

Generalist on the evening and night shift

Rapides General Hospital Alexandria La 9/1979 - 11/1984

Medical Technologist

Medical Technologist on the evening and night shift

USAF MEDICAL CENTER England AFB La 3/1978 - 12/1982

Medical Laboratory Specialist

Medical Lab Technician Generalist on the day shift

EDUCATION

Louisiana College - BS in Math and Science

Control Data Institute - Certificate in Computer Programming and Operations

School of Health Care Sciences - Associate Degree in Medical Technology

American Society for Clinical Pathologist - Nationally Certified Medical Technologist MT/MLT

Department of Professional Regulation - Licensed Clinical Lab Supervisor for the State of Florida

Technology:

MS Windows OS all versions

Programming Languages:

MS SQL Server SQL and T/SQL, Oracle SQL and PL/SQL, Visual Basic 6.0, Visual Basic for Applications, MS Visual Interdev, COBOL.

Report Tools: Crystal Reports Versions (6.0, 7.0, 8.0, 9.0, XI), Active Reports.

Microsoft Office Applications: All versions

Project Management Tools: MS Project

Data Modeling and Entity Relationship Tools: Erwin Data modeler, Microsoft Visio for Data Architects.

Software Version Control: Microsoft Visual Source Safe, PVCS Version Manager.

Relational Database Management: Oracle Versions (8I, 9I, 10G), Microsoft SQL Server Versions (7.0, 2000), MSACCESS all versions.

Database Management and Development Tools: Quest Software TOAD for Oracle Versions (8.0, 8.5, 9.0).

Training Classes

MCDBA/MCSE Training Courses

Certified Courses Taken:

* Windows 2000 Professional.

* Windows 2000 Server.

* Active Directory Services.

* Windows Server 2000 Network Infrastructure Administration.

* Windows Server 2000 Windows Migration Strategy.

* Windows Server 2000 Deploying and Managing Microsoft Internet Security and Acceleration Server

* SQL Server 2000 System Administration

* Querying Microsoft SQL Server 2000 with Transact-SQL

* Database Design and Implementation with SQL Server 2000

Microsoft Excel

Microsoft Word 6.0

WordPerfect for DOS

Lotus 1-2-3

Visual Basic for Applications

Visual Basic 5.0 at Broward Community College

Mastering Visual Basic 6.0 for Applications at Productivity Point

HTML and ASP training at Kemper National Services

Install Shield Training New York, NY.

Certifications: Microsoft Certified Professional on March 2004 for SQL Server 2000 Administration (MCP ID #3152821).

Contact this candidate