TECHNICAL SKILLS:

Programming Languages: MS SQL Server SQL and T/SQL, Oracle SQL and PL/SQL.

Report Tools: Crystal Reports Versions (6.0, 7.0, 8.0, 9.0, XI, 2008, 2013), SSRS 2008.

Microsoft Office Applications: All versions

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

Software Version Control: Microsoft Visual Source Safe, PVCS Version Manager, Team Foundation Server (TFS).

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

Database Management and Development Tools: Quest Software Confidential for Oracle Versions (8.0, 8.5, 9.0, 10.0, 11.5). Intermediate knowledge of TSQL 2008, 2012.

EHR: Confidential Clarity Crystal Reporting and Data Analysis, NextGen EHR and Axium EHR Data Analysis SSRS/Crystal reporting. Avatar EHR Crystal Reports/ SSRS Reporting and Data Analysis.

EXPERIENCE:

Confidential

Data Analyst/SSRS Report Writer

Responsibilities:

• Creating TSQL 2012 Scripts for Central Services Analytics.
• Creating functions, stored procedures and SSRS reports.

Confidential

Data Analyst/SSRS Report Writer, Cooper City, Florida

Responsibilities:

• Creating TSQL 2012 and 2008 Scripts for the client services department.
• Creating functions and stored procedures and SSRS reports.
• Set up of SSRS report Server.
• Some SSIS programming to produce SSRS reports.
• Creation of SSRS subscriptions.

Confidential, Doral, FL

Data Analyst

Responsibilities:

• Creating TSQL 2012 and 2008 Scripts for the encounters department.
• Publishing above scripts into EXCEL.
• Creating functions and stored procedures and SSRS reports.

Confidential, Orlando, FL

Database Analyst / SSRS/Crystal Reports Developer

Responsibilities:

• Creating TSQL 2012 and 2008 Scripts to include them in the development of SSRS and Crystal Reports
• Publishing reports using SSRS reports server.
• Participated in a Dental Data Mining project involving different dental metrics for special needs patients.
• Analysis of data using NextGen EHR to produce reports
• Publishing Reports using Business Objects scheduler.
• Created SSIS package to export Oracle table data and sql server queries into a text file which was then sent over secure ftp.

Confidential, Lauderdale, FL

Database Analyst / SSRS/Crystal Reports Developer

Responsibilities:

• Creating TSQL 2012 and 2008 Scripts to include them in the development of SSRS and Crystal Reports
• Publishing reports using SSRS reports server.
• Analysis of data using Netsmart EHR to produce SSRS reports.

Confidential, Orlando, FL

Database Analyst, Crystal Reports Developer

Responsibilities:

• Creating SQL Scripts to include them in the development of Crystal Reports.
• Publishing and scheduling reports using Infoview and Business Objects XI.
• Analysis of data using Confidential EHR to produce reports.
• Support patient care and business management through the creative development of data extracts, reports, and dashboards, the execution of complex system upgrades, and the provision of independent consultation on a variety of information sources involving internal systems and the Nemours data warehouse.
• Provide consultation to senior corporate leaders, hospital and practice administration, physicians and clinical personnel, central business office management and supervisors, and general operations on the use of existing Strategic Analytics reports and data and the planning for new sources of reports and data. Design and implement data extractions for electronic submission to external government and industry agencies that are accurate, timely, and support the integrity of our customer privacy commitments.
• Investigate and support platform modifications to service new demands for information consistent with vendor upgrades and new strategic IT investments.

Confidential, Miami, FL

Database Analyst/ Crystal Repots Developer

Responsibilities:

• Development of queries and in lines views using SQL Server 2008 for Confidential Clarity Data Model.
• Development of Crystal Reports for the different Data Models within Confidential .
• Scheduling of Reports using Confidential Crystal Integration.
• Scheduling of Reports using Business Object Enterprise XI Infoview and Central Management Console ( Confidential ) products.
• Creation of task using MS Server 2008 to perform tasks associated with e - mailing Crystal Report output to customers.
• Gathering Report requirements from Managers and Supervisors translating that into SQL code
• Meeting with Department heads as to their repot needs and investigating if we needed to create custom extracts to get the information and come back to the Department heads with a plausible solution.

Confidential, Plantation, FL

Medical Technologist

Responsibilities:

• Perform Duties as a Medical Lab Technologist in Chemistry, Blood Bank and Hematology.
• Process lab specimens to be sent out to the I.R.L. Core Lab.

Confidential, Miami, FL

Report Analyst

Responsibilities:

• 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.

Confidential, Miramar, FL

Crystal Reports Developer

Responsibilities:

• Creation of Entity Relationship diagram of the ARTIVA® System.
• Using Confidential ® for Systems Analyst to create complex SQL Queries and inserting them in Crystal SQL commands to create Crystal Reports.

Confidential, Miami, FL

Crystal Reports Developer

Responsibilities:

• Responsible for creating 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.

Confidential, Fort Lauderdale, FL

Database Developer

Responsibilities:

• 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.

Confidential, Miami Lakes, FL

MS ACCESS Database Administrator/Developer

Responsibilities:

• 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 Confidential (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.

Confidential, Florida

Database/Crystal Reports Developer

Responsibilities:

• 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 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 reports 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.

Confidential

Database Programmer

Responsibilities:

• Responsible for creating 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.

Confidential

Database Programmer, Miami, FL

Responsibilities:

• Responsible for maintenance and additions to the Confidential 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 Confidential 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.

Confidential, Plantation, FL

Programmer Analyst

Responsibilities:

• 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.