Information Technology Sql Server
Resume:
CLAUDIO G. MEDINA
Miami, Florida 33196
Career Objective Seeking a position in the field of information technology utilizing strong computer and software development skills.
Work Experience 19 years experience in the information technology area
including but not limited to: software development, programming,
analysis, and technical support.
Technical skills
SQL Server 2005, 2008, 2012
SQL Server SSIS, SSRS, SSAS (2005,2008,2012)
Visual Studio BI 2008, 2012
Visual Studio 2005,2010,2012 (C#,VB, .Net)
VBA. (Excel, Word, Power Pint).
ASP/HTML/XML
Microsoft Office 2010. (Excel Power Pivot Power Query, Word, Power Point )
Microsoft Access
Crystal Reports
Power Designer 12.0.
InterBase Borland Data Base.
PASS SUMMIT 2013 SQL Server community. NC.
Professional Experience
CIGNA (Leon Medical Center Health Plans)
2013 January - Current Senior Application Developer Specialist
SQL Searching Tools. Analysis and Development
oVisual Studio 2010
oSQL Server 2008, 2012
Finance DB System. Analysis and Development
oVisual Studio 2005 Visual Basic
oSQL Server 2005
oSSRS 2005
EOA. Enrollment Online Application for IPAD. Analysis and Development
oVisual Studio 2010 C#, .Net. Ajax, JSON.
oSQL Server 2008
EOAL Enrollment Online Application Local Analysis and Development
oVisual Studio 2010 C# .Net, Ajax.
oSQL Server 2008
SQL Replicator Tools. Analysis and Development
oSQL Server 2012
oVisual Studio 2012 C#
ICD-10 Diagnosis Code Conversion Process Analysis and Development
oSQL Server 2012
oVisual Studio 2012 C#
oSSRS 2012
Pharmacy Dashboard. Analysis and Development
oSQL Server 2008
oSQL Server 2008 ETL.
oSQL Server Analysis Server 2008.
oExcel 2010. Power Pivot
Leon Medical Center Health Plans
2009 September – December 2012 Analysis Developer II
RAPS Claims Control. Analysis and Development
oVisual Studio 2005 VB
oSQL Server 2005.
HRA Survey System for Members. (FACETS extensions application)
oVisual Studio 2005 C#
oSQL Server 2005
oSQL Reporting Services SSRS
oSQL Server Integration Services SSIS
Patient Dashboard Control Analysis and Development
oSQL Server 2005
oSQL Reporting Services SSRS
oExcel 2010 VBA.
oExcel 2010 Power Pivot
Multiples Production Report for different department. (60 reports about)
oPart C. SQL Reporting Services SSRS
oClaims. SQL Reporting Services SSRS
oEnrollment. SQL Reporting Services SSRS
Multiples data integration process. (20 reports about)
oSQL Server Integration Services SSIS
SKYNET, Miami, Florida
2007- July 2009 Analysis and Developer System.
Migrated company database from InterBase to SQL Server 2005.
Created an Integration System Billing with Courier System, performed the analysis, gathered
requirements, and developed using VB6, ASP.Net, HTML and SQL Server 2005
Integrated System Billing with Hewlett Packard’s billing. SQL Server 2005, Excel VBA.
Analysis and development of Inventory and Logistics System.
Developed in: ASP.Net, HTML, and SQL Server 2005.
Analysis and Development New SysFinance. A client/server application.
VB6 and SQL Server application migrated to C#.
Analysis and Development a Finance Report that allows managers to view the financial status of their
department.
Developed in: Crystal Reports, OLAP, Excel VBA
Analysis and Development a Courier Report for internal users. Control materials, Labor hours, logistics and
financial information.
Environment: SQL Server 2005, OLAP, Data Analyzer, Crystal Report, Report Services, InterBase
(Borland Database, Excel with VBA, Visual Basic 6.0, C#, PowerPoint)
Lanlogistics –LanChile, Miami, Florida
2001 – 2007
Lead Developer
Managed team of four VB6 / ASP /HTML / OLAP/C#/Web Service developers.
Designed and developed SysCargo Cargo/Courier system which functions to track shipping, billing and
Accounting information . The SysCargo system is installed in 15 North and South American countries.
Environment: SQL Server, Visual Basic 6.0, ASP. HTML, Excel (VBA), Crystal Report.
Analysis and developer system integration of several other system including :
FedEx.
Europe’s Courier. Analysis and Lead developer C# Application, Web Service, XML
USA Customs. Send all the information requested by them. FTP transaction.
The SysFinance system.
QMIRROR
Analysis and Development a tracking application for travel/cargo/US customs that transitions data system control. This application manages the controls of all the Information transmitted between different countries that use SysCargo System.
Environment: Visual Basic 6.0 (windows services), HTML, SQL Server 2000, migrated to 2005.
SIMS
Developed SIMS system to control inventory and process order from customer to shipping products.
SQL Server, Visual Basic 6.0, ASP. HTML, Crystal Reports.
LanChile
Analysis and development of the Control Billing Air Tickets Agencies, an application used by the financial department, and developed in VB6, Excel (VBA), SQL Server 2000, OLAP and Crystal Reports.
LanBox – LanChile (by Professional Aviation)
Developed Control Credit Card Transactions to help customers make online ticket purchases.
Oracle Version.
SQL 2005 Version.
Visual Basic 6.0.
VBA Excel Report.
Crystal Report
OLAP Cube
LanChile Cargo (by Professional Aviation) Miami, Florida 1996 – 2000
Developer/Systems Administrator
Developed cargo analysis reporting system. The reporting program tracked cargo shipped to other countries (USA, France, and Chile). Also developed and administrated the Controller System.
Provided management with sales analysis and general reports
Oracle
HTML, ASP, VBA.
Business Engineers and Software Tools (BEST), Santiago, Chile and USA 1990 – 1995
Project Manager
Developed customized tools and software upon request for the production and financials system.
MIS Developer Tools and Software for different companies. (Production and Financial system)
WIN400 API for DB2400 data base, supported featured work in Brazil, Ecuador, Peru, Argentina, Mexico, USA and Chile.
MALLOA (Chilean Fruit Company), Santiago, Chile
Analysis and Development Fruit Quality Control for all process of export fruit’s products.
C.O.P.E.C (Chilean Petroleum Company), Santiago, Chile
Credit Card COPEC
P.O.S.
Control Pumps (for gasoline station. 120 point of sales)
DataCard and Verifone.
C language.
G.M.T, Textile System, Santiago, Chile
Analysis and Developer Team for Textiles Software Control.
Education System Analysis. ITESA Santiago, Chile.
High school Hermanos Maritas Chile
References available upon request
Contact this candidate