Summary

Information Technology Specialists with 12 years of experience in troubleshooting, network design/administration with strong knowledge in database development, administration and design. Energetic self-starter with excellent analytical, organizational, and creative skills. Extremely proficient in database design, administration and maintenance, also proficient in analysis and reporting solutions. Sound understanding of Object Oriented Programming and Relational Database applications and solutions. Experience in the working complex IT projects with tight deadlines. Knowledge of cGMP, FDA regulations and computer system validation. Proven ability to work under pressure with limited supervision on small and large teams.

Expertise Highlights

Confidential

Professional Experience

Key Results:

• Manage 74 SQL instances and approximate 480 databases
• Created Maintenance plans for backups and database maintenance tasks.
• Created a database for performance monitoring and collect daily and weekly data
• Created integration services jobs to gather information across all servers.
• Created various reporting services reports.
• Install SQL server 2014 on various servers according users requirements.
• Analyze queries and recommend performance optimization.
• Synchronize databases from development to production. Create and test scripts
• Help in the development of integration packages.
• Execute and validate tests scripts.
• Environments: SQL Server 2008R2, 2014, Integration Services, Excel, DB Compare 10, VMWare, Visio other third party databases tools.

MMM

Business Intelligence Developer

Key Results:

Created documentation for a data warehouse.

• Analyze queries and recommend performance optimization.
• Synchronize databases from development to production. Create and test scripts
• Help in the development of integration packages.
• Recommend and develop strategies for transformation and data cleansing.
• Execute and validate tests scripts.
• Open Mobile
• Worked as a technical writer in Oracle databases.

Key Results:

• Create documentation for the data warehouse.
• Create system requirements, design specifications and other technical document as required by the Business.
• Make recommendations on stored procedure performance tuning.
• Make recommendations regarding database tuning, specially indexing and partitioning on large tables.
• Environments: SQL Server 2008R2, Integration Services, Excel, DB Compare 10, VMWare, Oracle 11, Oracle Developer, Visio other third party databases tools.
• Working at PRT Claro as a Business Intelligence developer Oracle and Cognos.

Key Results:

• Analyze requirements for reports requested by users.
• Perform complex queries, stored procedures and Materialized Views for reports and data analysis according to user requirements.
• Perform test scripts and export data to excel to be analyzed and validated by the end user.
• Perform analysis on query performance, and determine best approach scenarios.
• Prepare documentation related to the execution of the reports and coordinate the transfer from development to production.
• Environments: Oracle 11g, Toad, Excel, Word.

Confidential

Administered multiple SQL Server databases. Provided support in performance issues, and Performed System Upgrades to Hospitals and Clinics CDTs

Key Results:

• Monitor performance of multiple databases, create, alter or drop indexes based on statistics, recommends change in stored procedures, views, triggers to the development team for better database and application performance.
• Create partitions, and move tables or indexes to other table spaces/ disks for better performance or maintenance.
• Extensive use of comparison tools such as DB Compare to synchronize development DB with Production DB Online usually this process takes 15 to 25 hours
• Help the development and migration teams during upgrades.
• Recovered databases from offline state usually caused by full disk space
• Database backup and Restore. Test backups for integrity.
• Make recommendations according the performance counters obtained from different analysis for index and database tuning.
• Move database objects between environments and create the required documentation for the process.
• Manage table partitions, schemas and table spaces across different environments.
• Provide technical advice to developers, IT personnel and Hospital management regarding databases.

Environments: SQL Server 2008 R2, SQL Server 2012 testing-evaluating , Visual Studio 2008, DB Compare

Monitor entire network infrastructure.

Key Results:

• Monitor communications between buildings, analyze and report bottlenecks or bandwidth problems.
• Report software or hardware failure to support personnel.
• In charge of solar winds platform for monitoring the entire network, physical, virtual and communications.
• Create and maintain a database application of the entire server room in Manage Engine and Asset Explorer, generate custom reports as requested by IT director.
• Monitor Linux servers, create scripts for automatic backup and maintenance of Linux applications and servers.

Worked on Oracle and Access databases as part of a marketing team.

Key Results:

• Designed and developed various stored procedures to process the Banco Santander and Island Finance Marketing databases cutting the process time in half.
• Summarized and analyzed the marketing data.
• Extensive use of SQL queries to prepare analysis reports based on marketing offers to prospects.
• Distribute excel documents with summaries and statistics based on marketing campaigns y offers to all management levels.
• Transfer data between access and oracle databases for analysis, reporting and storage.
• Extensive use of excel for reporting and data analysis.
• Help in the design and implementation of a marketing data warehouse.
• Create a data dictionary and documentation for the data warehouse and the current marketing database.

Worked with SQL Server 2005 and 2008, Oracle 10g and Informix databases as part of a consulting firm.

Key Results:

• Designed integration services packages according to user requirements using Visual Studio 2008 and Visual Basic .Net.
• Analyzed several applications stored procedures part of a SAP interfaces and re-developed all of them in SQL server 2008 Stored Procedures
• Generated several SQL DDL scripts to update tables and other objects as part of the requirements of the stored procedures I developed.
• Generate test scripts to validate the stored procedures.
• Generate the documentation of the migration and implementation process.
• Proposed recommendations regarding issues in virtual network, backups and the database.

Key Results:

• Designed integration services packages according to user requirements using Visual Studio 2005 and Visual Basic .Net.
• Recommended migration strategies for visual basic 6 COM packages to Web Services
• Recommended migration strategies for SQL 2000 DTS packages to SQL 2005 Integration services packages.
• Recommended migration strategies Crystal Reports to SQL 2005 Reporting Services
• Performed complex queries for reports and data analysis according to user requirements
• Analyzed and re-designed COM packages in Visual Basic 6 code and developed a Web service that performed the same task.

Confidential

database administrator

• Key Results:Work as a DBA for the Xamine Enterprise Business Intelligence Project in DB2 9.1 Universal Database environment.
• Define storage requirements for the different environments.
• Index creation and tuning for database performance.
• Work with the configuration of the SuSe Linux operating system in an IBM Mainframe Virtual Servers. Create scripts for the directory structure, users, permissions of the different servers Development Quality Assurance and Production. Format and assign virtual drives to the corresponding volumes according the space allocation defined.
• Attend meetings with different outsourcing team and Bank personnel regarding the migration process and the loading of the data warehouse from the legacy systems also recommend various changes in the current loading strategy regarding the concerns of network performance.
• Perform regular backups of the several environments.
• Make recommendations according the performance counters obtained from different analysis
• Move database objects between environments and create the required documentation for the process
• Generate the documentation for the Operating System environment and the databases environment
• Manage table partitions, schemas and table spaces across different environments.
• Support few MS SQL 7, 2000 and 2005 databases in development and production environments.
• Learn the tools used by the end user and work with the developers in the design of customized and complex reports using Business Objects Designer and Desktop Intelligence based on the Data warehouse.
• Download, evaluate and recommend different tools for database management and administration.

Part of a consulting services offering solutions to client's needs.

Key Results:

American Health Medicare

• Developed a Clarion application for the Medical Management department that handles the faxes received in the medical management area, assigns the faxes to the correspondent patient and approves or denies the request.
• Developed a Clarion application for the Appeals and Grievances department that handles the appeals process and keep track of the request according to the department assigned to.

Banco de la Vivienda

• Migrating data and objects from different sources like SQL 7, Excel, and text files into SQL server 2005.
• Supported all production operation activities, with focus on integration and development of new and existing products and services.

• Developed an Access application to generate and track complex invoices needed for closing home loans.Centurion Insurance Agency:
• Developed an application that Tacks the document and workflow of the cases handled by the office.
• Designed the logic to an automated process to handle Schedule A and Schedule B for the home loan insurance.
• Migrated different databases from Access 2000 to SQL 2005 express edition.
• Implemented the backup strategy for the SQL database.
• Managed the Windows 2000 server Active Directory.
• Run various backup tests check every day backup, made recommendations for a better backup strategy.
• Clinical Medical Services:
• IT Support, monitor server performance, monitor backups, schedule and test backups, technical support to users.
• Bonin Electronics:
• Managed the project of Voice and Data cabling for their new facilities.

Market Prominence Database Administrator/ Developer

Key Results:

• Attend a workshop in Connecticut regarding the administration and configuration of Market Prominence software.
• Administered the Oracle database for the application.
• Configured the different modules according to the user specifications and addressing the regulations of Medicare regulations.
• Design and attach multiple mailing letters using Crystal Reports in accordance to user specifications.
• Developed the Credentialing system for Providers and Ancillaries in access 2000.
• Migrated the Credentialing database to SQL Server 2000, most of the system logic was changed from visual basic for applications code to Stored Procedures and Triggers.