Objective

Employment Application

Summary

Bachelor Degree; Specialist in Programming of Computation. More than 20 years of experience in Computer Programmer and Debase Design.

Expertise

Strong knowledge of Visual Studio 6, Visual Studio. Net (Visual basic and C#, 2003, 2005, and 2008), Mobile Application, Visual SourceSafe.
Strong knowledge of SQL Server 2000, 2005 and 2008 (Store procedure, Functions, Functions Tables, Views, Triggers.
Strong knowledge of SQL Business Intelligence (SSIS,SSRS).
Strong knowledge of Crystal Report (8, 11), Excel Macros and Visual Basic for Application, Microsoft Access, DAO.
Strong knowledge of ASP, ASP.Net, AJAX, ADO, ADO.Net, LINQ, Web Services, Java Script.

Employments

10/5 2011- 5/4/2012
Confidential
VB Developer / Reporting Analist (ETL)
VB.Net, SQL 2005, 2008, SSRS, SSIS (ETL), Cristal Report XI

Developed SSIS Packages for Extraction, Transformation and Load Data from 4D database to SQL Database.
Developed SSIS Packages for Extraction, Transformation and Load Data from TEXT , EXCEL file to SQL Database.
Developed Store Procedures, Tables, Views, Functions in SQL 2008.
Developed and modified Reports in SSRS Visual Studio 2008.
Supported application for process 837 claims.

9/2010 - 6/2011
Confidential
Doral, FL
SQL BUSSINESS INTELIGENCE

SQL 2008,SQL 2005, MICROSOFT ACCESS
Integration Service (SSIS, ETL)
Reporting Services (SSRS)
Crystal Report XI
C#.Net
VB.net

Reports Services (SSRS):

Develop SSRS 2205, 2008 parameter based reports.
Develop complex SSRS 2205, 2008 Matrix reports.
Configure security access to reports.
Develop SQL Server jobs to automate SSRS reporting.
Deploy reports to SSRS server 2005 and 2008.
Create complex queries in SQL 2005 and 2008 from multiple linked servers.
Create complex parameter based Store Procedures from multiples
linked servers.

Report Samples: (All report were doing from CPT , ICD-9 and CDC codes)

• Clinical Flu
• Smoking Assessments
• Child Immunization
• Billable Encounters
• Demographic Reports
• Diabetic report
• Etc.

Integration Service (SSIS, ETL)

• Participated in the exportation of data from 25 servers to Microsoft Amalga Warehouse
• I did Package that run 15 crystal reports with variable parameters and export
• automatic the data to PDF format files and put files in folders.
• I did packages that get files from FTP and put data in SQL Server
• Database.
• I did packages that run store procedures and views and send the data to
• FTP files and send an Email with a excel file attachment.

(Store procedure, Functions, Functions Tables, Views, Triggers, Index,,Linked Server,Cursors).

7/2000 - 6/2010 Confidential MIAMI FLORIDA
SYSTEM DEVELOPER.
Salary: 67600 / Year

Five years of experience in SQL 2000.
Three years of experience in SQL 2005.
Two years of experience in SQL 2008.
Two years of experience in SQL CE.
(Store procedure, Functions, Functions Tables, Views, Triggers, Index,Linked Server,Cursors).

Participated in the design of databases, tables, views, store procedure, functions in SQL Server 2000 and SQL Server 2005.
Developed and tested complex Data transaction service (DTS) in SQL Server 2000.
Developed and tested complex Integration Services (SSIS) in Visual Studio 2003, Visual Studio 2005 , SQL Server 2005, and SQL Server 2008.
Developed and tested complex macros and Visual Basic for Application ( VBA) in Excel and SQL Server 2005.
Developed and tested the code for purchases and sales system in VB6 , SQL Server 2000 and Crystal Report 8.
Developed and tested more than 500 reports in Crystal Report (8.5, 11), SQL Server 2000 and SQL Server 2005.
Developed and tested the code for repair system in VB6 , SQL Server 2000 and Crystal Report .
Developed and tested the code for a program that process and complete orders of reparation when a purchase is received (VB.Net , SQL Server 2000).
Developed and tested the code for Balance Annual System in VB.Net, SQL Server 2005 and Crystal Report.
Developed and tested the code for a system that distribute parts requested by the technicians and actualize the inventory database in Visual Studio 2005 (VB.net Mobile Application).
Participated and tested the system that actualize information for transportation of mail for United Air Lines in Visual Studio 2005 (VB .NET Mobile Application , Integration Services and Web Services)
Developed and tested the code for a program that create and process orders than our clients put by internet.
Participated in the code and tested for a Mosaic Company web Site in Asp.net (Visual Studio .NET 2005).
Developed and tested the code for create orders from excel files in FTP site for Lorillard and Mosaic Company in Visual Studio .NET 2005. I created a DLL and Integration Services for this system.
Developed and tested the code for multiple excel files (Visual Basic for Application) .
Developed and tested reports for Ryder Company from a Web Service (VB .NET).
1994 - 2000 Ministerio de Finanzas y Precios. Havana, Cuba
VB3,VB5, SQL Server 6.5
VB6, SQL Server 7, Crystal Report., Access, Excel

1981 - 1994 ASTRO. Habana, Cuba
Computer Programmer
TURBO BASIC, DBASE , FOXBASE , CLIPPER SUMMER, CLIPPER 5,

Education

1976 - 1981 Confidential
Havana, Cuba

Industrial Engineer

Diploma Work on Programming of Series
Chronological.