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.

Professional Experience

Confidential

Business Intelligence Developer

Independent Consultant

Business Intelligence Developer

Key Results:

• Create 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.
• Open Mobile
• Worked as a technical writer in Oracle databases.
• Key Results:
• Create documentation for a 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, DBCompare 10, Oracle 11g, Toad, Oracle Developer.

Confidential

Database Analyst/Oracle-Cognos Developer

Independent Consultant

• Working at Confidential 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

Database Analyst/ Database Administrator

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

Confidential

Network Specialyst

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.

Confidential

Database Analyst

Key Results:

• Worked on Oracle and Access databases as part of a marketing team.
• 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.

Confidential

SQL Database developer in .net / analist consultant

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.

Confidential

consulting tegnologies

Worked with SQL Server 2000 and 2005 and Informix databases as part of a consulting firm.

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

It department

Database administrator

Work as a DBA for the Xamine Enterprise Business Intelligence Project in DB2 9.1 Universal Database environment.

Key Results:

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

Confidential

Database developer in clarion and mysql

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

Key Results:

Confidential

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.

Confidential

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

Confidential

Medical insurance

Databse administrator

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.

Confidential

Consulting technologies

Network administrator/developer/outsourcing

Key Results:

Department of Education

• Collaborated in the coding of modules and reports on various applications in Visual Basic, Crystal Reports and SQL Server. All modules completed on time or ahead of schedule.
• Installed the category 5 cabling structure for Special Educations Program and OMEP office. Installed, configured and administered 5 IBM Servers in 2000 server environment.
• Gathered information on the needs of each office and defined the hardware and software requirements for each project, included but not limited to Windows, Routers and Cabling configurations.
• Designed and developed various Databases and Applications for the Special Educations Program to track budget data.
• Designed the database for students and teachers this was the core of the Special Education Program.
• Generated statistical data analysis for the Finances department for costs-expenses analysis and budgeting, data was exported from SQL server and other sources into Excel spreadsheets via DTS.
• Provided extensive statistical data analysis for the Special Education Program.
• Gathered the students and teachers data from the school districts and generated the Annual Federal Child Count reports.
• Supervised and trained developers or technicians then assign them to other projects or clients

Internal Revenue Service Confidential Managed the Wide Area Network project in Rio Piedras and Parada 20 Offices.

• Gathered information on the needs of each office and defined the hardware and software requirements for each project, included but not limited to Windows, Routers and Cabling configurations.
• Developed a simple MS Access Application to track the inventory of PCs.
• Confidential Worked as part of the Data Migration Team in charge of Task Lists Plant Maintenance Data.
• Analyzed system requirements for the Task List Business Object
• Developed the Data Mapping and System Requirements for the migration process.
• Developed a Stored Procedure in Oracle 8i for the data extract from Maincore into SAP's Data Migration Tables.
• Generated the corresponding documentation for all processes according to cGMP's and computer system validation guidelines.
• Confidential Developed and tested all the web user controls for Sistema Universitario Ana G Mendez web site suam.edu developed in Visual Studio 2005 and Dreamweaver
• Helped in the system requirements, designs and implementation of various Databases needed for web sites.
• Designed the Loteria Electronica systems requirements and database
• Imported all the historical data via DTS. Designed the stored procedure for the import of the subsequent data loads as needed.
• Certifications / Licenses

Business Objects:

• Enterprise Security Administration
• Desktop Intelligence - 16 hour course
• Designer - 16 hour course
• 21 CFR part 11 Pharmaceutical regulations, Computer Validation CSV
• Bank regulations and Money Laundering