IT Infrastructure and Database Administrator professional with comprehensive experience in designing, implementing, managing and support of enterprise-class solutions for small and medium business companies with a strong emphasis leveraging Microsoft and Mac products and virtualization environment with VMware vSphere and Parallels Desktop for Mac. Deep proficiencies with complex ERP implementation - including systems design/architecture, solution deployment, and support. Extensive database administration with Microsoft SQL Server multiples versions from 6.5 to up to date, T-SQL development implemented data structures, views, store procedures, functions, triggers, DTS/SSIS packages, and reporting with Microsoft Reporting Services/SSRS, Microsoft Access and Crystal Report. Strong background in client-facing troubleshooting and customer service delivery ensuring continuity, reliability, and high availability. Duties like a DBA include common production tasks/administration login privileges, security, etc to maintain 99.98 system uptime routine back-up/restore functions systems monitoring heavy performance tuning/troubleshooting/query optimization. Conduct different data migrations successfully from different sources to SQL Server including previous versions of SQL Server and Windows OS. Provide computer support in Windows and Mac platform, including servers, workstations and others network devices, covering hardware and software issues at differentcomplexity tier levels of support, implemented a Help Desk system in a corporate environmentwith ServiceDeskPlus software. Management IT staff for 7 years in a grown corporate environment including expansion and deployment of new remotely branches. Coordinate and organize the IT projects and the timeline of our IT staff with ClockIngIT. Fully bilingual English/Spanish .

• Operating Systems: Windows Server multiples versions for Standard, Essentials formerly Small Business Server or SBS Enterprise Editions with clustering active/active, active/passive Citrix Presentation Server 4.0/4.5 Windows 8.0/8.1, Windows 7.0 / Windows Vista / XP / NT / 9X DOS. Mac OS X multiples versions including Mac OS X for Server.Experience in installing, configuring, backing up, tuning, and supporting Windows servers and workstations in physical and/or virtualized environments with VMware and Parallels Desktop.
• Networking/Software: Microsoft Exchange multiples versions Standard and Enterprise with clustering IIS 5.0/6.0/7.0/8.0/8.5with soft load balancing VMware ESX/ESXimultiples versions, VMware vSphere 4.0/5.0/5.5, Microsoft Active Directory / Mac Open Directory, TCP/IP, DHCP, DNS, WINS,Group Policy Management, and security group management, Symantec Veritas NetBackup 6.x/5.x, BackupExec 11/12/2010/2012/2014 and use of other backup solutions based on cloud services like Carbonite, Microsoft OneDrive, Google Drive, Apple iCloud and DropBox and theuse of different networks appliances likeRouters, Switches, Wireless System including Access Point, Firewall, E-Mail Firewall and Web Surfing Control.
• Database/Reporting: MS SQL 2000/2005/2008/2008 R2/2012/2012 R2 with clustering, SQL Management Studio, SQL Server Query Analyzer, SQL Server Enterprise Manager, ETL process using SSIS/DTS Packages, Use of T-SQLimplementing Stored Procedures, Functions and Triggers, Performance Tuning, SQL Server Profiler, Data Warehousing and Dashboard, Monitoring and full administration of 24/7 Database environment, Table indexing and query optimization, Database backup and recovery planning, SQL Server Reporting Services/SSRS, Visual Studio multiples versions, Visual Source Safe, Microsoft Access, Microsoft FoxPro, Crystal Report standalone and server versions . Working with others databases systems like MySQL and Sybase servers.

Confidential

IT CONSULTANT

• Redesign, implement and support IT infrastructure for customers owned small and middle range business with corporate networks supported in Windows, Apple, Linux and VMware technologies.
• Networking, including setup and management of:
• o Switches in Unmanaged and Managed mode, multiples brands.
• o Routers, multiples brands.
• o Cisco ASA security appliance or SonicWALL appliance.
• o Wireless AP in corporate environment Ruckus and Dell PowerConnect systems .
• o Coordinate installation of internet service with multiples ISP providers Comcast, AT T and others with different kind of service level including Metro Ethernet, cable, vDSL or DSL.
• o Setup of NAT, firewalls, security access rules and VPN.
• o Setup of Wireless AP in corporate environment Ruckus and Dell PowerConnect systems .
• Install and management virtual servers and workstations using VMware vSphere and VMware ESXi, multiples versions, and Parallels Desktops for Mac.
• Install and management of Windows and Mac OS X networks servers and workstations in mixed mode topology, including management of all network components, services and applications like:
• o Active Directory for Windows Server.
• o Open Directory for Mac OS X Server.
• o DHCP.
• o DNS.
• o WINS.
• o File Server.
• o DFS.
• o FTP Servers IIS and Gene 6 FTP server
• o Print Server.
• o IIS Server.
• o Exchange Server multiples versions: 5.5, 2003, 2007, and 2010 .
• o SQL Server multiples versions: 6.5, 2000, 2005, 2008, 2008 R2, 2010, 2012 .
• o Sybase SQL Anywhere and MySQL management servers multiples versions .
• o Firewall and Security Suites installation in corporate environment for server and client systems based on Symantec EndPoint Protection, Enterprise Edition or Trend Micro Worry-Free Business Security Advanced
• o Symantec Backup Exec 12.5.
• o SharePoint 2010 Foundation and Enterprise editions .
• o Corporate Reporting System.
• o Blackberry server.
• Provide corporate IT support for client system based in Windows 8.1, 8.0, 7.0, Vista and XP and Mac OS in Lion Mountain and Maverick version.
• Setup and deploy of Microsoft Office Suite for Windows and Mac 2003/2007/2010/2013 Office 365, Office for Mac 2011 .
• Management and deploy of software updates centralized for Windows and Mac OS servers and client workstations .
• Deploy and management of multiples mobile iOS devices iPhone, iPad and iPad Mini via Profile Manager in Mac OS X server.
• Provide management and support of accounting system through QuickBooks different versions, including Premier and Enterprise in network environment in share mode.
• Provide full support for a specialized ERP and CRM system for business and residential security industry Alarm SQL 7.0 based in Sybase.
• Install and management of Content Management through EMC ApplicationXtender.
• Remote management, maintenance and migration of web server web hosting server and virtual private server VPS, in Linux CentOS with Web Apache server, PHP and MySQL server in GoDaddy, Advansis Networks and HostGator hosts servicesthrough multiples web hosts management interface Parallels Plesk and cPanel .
• Remote Management of Domain Names through GoDaddy, Advansis Networks GoDaddy - partner , Network Solutions, Yahoo Small Business and HostGator.
• Execute successfully migration of corporate email domains from Microsoft Exchange 2010 installed On-premise to Google Appsthrough Google Apps Migration for Microsoft Exchange GAME . Setup and regular maintenance, including integration of mail, contacts and calendar of Google Apps with Microsoft Outlook through Google Apps Sync for Microsoft Outlook client.
• Setup of Google Drive, DropBox and/or OneDrive for multiples synchronization process from PC, Mac and/or mobile devices.
• Implement the remote support for my clients in their locations for all servers and client systems using LogMeIn and TeamViewer.
• Setup and deploy of different graphics suites like Adobe Creative Cloud, Corel Draw and EnRoute.
• Provide services of IT Consultant for installations and support for final customers in behalf of my customers like a third party service provider for:
• CCTV system multiples DVR, NVR includingsetup of remote access for the final customer via web and/or mobile devices.
• Access Control Keri Systems .
• Document the jobs and settings for future reference with these customers.
• One of the most important functions such as IT consultant is to recommend to my clients IT solutions they require depending on your requests and objectives. Acting on behalf of my clients, establishing relationships with external suppliers of IT products and services, making the coordination and monitoring of their request for purchase or support of equipment, software and services.

BOCA PHARMACAL, INC - Coral Springs, FL, USA June, 2010 October, 2011

ERP and Reporting Writer specialist.

BOCA PHARMACAL, INC - Coral Springs, FL, USA Dec, 2009 - June, 2010

Under 6 month contract through Apex System, a staffing agency.

ERP and Reporting Writer specialist.

• Proposal, implementing and management of virtualization project based on VMware vSphere 4.0 Enterprise level to reconfigure the entire corporate IT infrastructure in a safely and redundancy environment with high level capabilities features like vMotion, Fault Tolerance FT , High Availability HA and Distribution Resources System DRS . The central management was implemented using VMware vCenter Server, creating a Private Cloud Resource Pool with 3 physical hosts based in servers Dell PE R710. The corporate storage was implemented through an EquaLogic PS4000XV iSCSI SAN storage and private iSCSI network. All old physical servers where converted and virtualized.
• The backup solution was implemented through a Dell PowerVault DL2100 Backup to Disk Appliance Powered by Symantec Backup Exec 2010 and extended the storage capabilities with an external Dell PowerVault MD100 Direct Attached Storage device.
• Coordinated and implemented a migration process for the corporate mail server based on Microsoft Exchange hosted with BluePoint, an external IT provider, to Microsoft Online Services.
• Deal with external IT providers to cover the monitoring services and Exchange server hosted externally in a cloud.
• Managementthe ERP system based in Exact Macola Progression in multi-companies environment, including all Macola modules:
  • AR - Account Receivable.
  • AP - Account Payable.
  • GL - General Ledge
  • IM - Inventory Management
  • OE - Order Entry
  • SY - System Management
• Proposal, implementing and management of a new warehouse solution integrated with Exact Macola, based in Wisys WMS Inventory Management and Pick/Pack system integrated with UPS/FedEx through a third party Shipping application - ShipRush . The Wisys WMS implementation was a custom implementation in compliance with the regular standards of pharmaceutical industry and FDA regulations.
• Migrate and keep updated the Exact Macola software up to the last version.
• Management and maintenance SQL Server 2005, Enterprise Edition. Migration to SQL Server 2008 R2.
• Install, management and maintenance SQL Server 2008 R2, Standard Edition with 2 instances of SQL server and 2 instances of SSRS, one in native mode and the second one in SharePoint integrated mode.
• Install and maintenance a SharePoint 2010 server, Enterprise Edition for Intranet purpose.
• Development of a new Corporate Reports System based on SQL Server Reporting Services SSRS integrated with SharePoint 2010.This reports system replaced the old system developed and deployed in Crystal Report Server.
• Development of an Executive Dashboard in SSRS using Visual Studio 2008 and deployed in SharePoint 2010 via SharePoint Web Parts. The store procedures were created in Transact-SQL, using ETL process and some data warehouse techniques in order to boost the performance.

• Development of different reports in SSRS for multiples purposes for Executive area, Accounting, Inventory Management, Order Entry, History Sales and Federal compliances. These reports where orientated to internal and external final users, with multiples delivery methods in real-time, via distribution emails and file server distribution scheduled using Subscriptions in SharePoint and different output formats PDF, HTML, MHTML, Excel, Word, TIFF, XML and CSV .
• Development custom reports for the CRM corporate system based on Microsoft Dynamics CRM 2011, Enterprise Edition. Thesereports weredevelopment in Visual Studio 2008 and deployed in SSRS native mode and reflect the Sales Representativesand Customers activities.
• Desktop/End User Support.

Confidential

IT Director. Infrastructure Engineer /Database Administrator.

• Client-facing implementation and administration of Exact Macola Progression software, a commercial ERP systembased in MS SQL Server. Duties include:project planning, systems design implementation, and administration support for all modules Accounting, Order Entry, Inventory, Bill of Material, POP and Purchases .
• Core systems infrastructure design, implementation, and administration leveraging Windows Server 2000/2003 with clustering active/active, active/passive , VMware ESX, Exchange 2000/2003, IIS 5.0/6.0/7.0, and Citrix Presentation Server 4.0/4.5 .
• Database administration duties in terabyte Microsoft SQL Server 2000/2005 clustered environments including database design, installation and configuration, clustering, performance tuning/optimization, and back-upusing VeritasNetBackUpwith enterprise SAN/NAS storage solutions.
• Defined linked servers, security, new logins, enterprise user permissions, etc.
• T-SQL development complex queries, stored procedures, triggers, functions, views, etc including ETL process with DTS/SSIS packages, jobs scheduling, maintenance of corporate data integrity, etc.
• Design and development ETL process with store procedures that import sales orders from our external customer's web catalog into our ERP Macola and register the sales transaction under the correct customer account in the CRM system Goldmine .
• Design and development ETL process with store procedures and scheduling jobs importing data from Starship database based in Pervasive SQL to MS SQL Server in order to integrate that information in the corporate daily billing process and optimize and reduce the cost of the company shipping process.
• Development the ETL process that extract and transform the ERP transaction operations Sales Quotes, Sales Orders, Invoices, Inventory Stock and Purchase Orders into our data warehouse.
• Designed SQL scripts and procedures for automating DBA task and proactive performance monitoring.
• Plan capacity specification requirements for new database servers.
• Recommend and implement SQL server consolidation projects.
• Performed several database migrations for server replacements, hardware upgrades.
• Responsible for testing and implementing hot fixes, security patches, and service packs.
• Setup development, testing and staging database environments to allow for proper testing and debugging.
• Deployment/promotion of new data models, structures, and objects to production database environments.
• Provide help to database developers and programmers on create and maintenance data structure, indexing, triggering actions and T-SQL code writing.
• Development and support a new corporate reportingsystem using Microsoft Reporting Services/SSRS with Visual Studio 2005 including complex reports design, data sourcing from disparate repositories, publication to company intranet, providing the Corporate Reporting tools to our different departments dependency of specific data request of each departments Executive, Sales, Marketing, Customer Service, Accounting, Inventory and Supply Chain, Production and Shipping . These reporting tools were deployed in our corporate intranet using Dashboard techniques and detailing reports. The content of corporate dashboard was created to resolve the specific data request needed per intranet user type matched with the departments mentioned above. These reports was development using parameters in order to make more flexible and capable filters for the final users, the common parameters used was Locations, Sales Representative, Customer Type, Customer No., Product Type, Product ID, Date Ranges. These reports were created for corporate internal use or for our customers. The production and distribution of these reports was organize via email in PDF file attached with distribution lists or direct access in our corporate intranet for internal use generate for our MS Reporting Server in real time.
• Assisted and supported the programming staff in all applications development in our company that need data access to our SQL servers development complex queries, views and store procedures accessible from these applications and documented the data structure used.
• Documented the job scheduling used for ETL process and maintenance databases.
• Implemented and check the programming rules to complaint with the security data access that doesn't allow possible injection threads to our databases from our web and windows applications.
• Check OS Event Logs, SQL Server Logs and Security Logs for unusual events.
• Verify that all scheduled jobs have run successfully and detect and fix problems when those happen.
• Monitored the disks space to ensure our SQL server don't run out of disk space, monitored the performance using System Monitor and SQL Profiler. Monitored, identification and resolve databases blocking issues.
• Create and maintenance a log file of any change made it to our SQL servers, including records of any performance issue detected and the corrective action taken.
• Deployment and support a KnowledgeSync 2000 server, product used for an enterprise-wide Business Activity Monitoring application that combines business intelligence, alerts, and workflow to keep you on top of your business.
• Administration and support of corporate CRM system based on Goldmine Corporate Edition version 6.0 and 7.0 .
• Support and maintenance of help desk system using ManageEngine IT ticket system based on ServiceDeskPlus 7.5.
• Remote user support leveraging LogMeIn software.
• Monitoring/management of national WAN/VPN for World Emblem Int. headquarter connecting branch offices in CA, MI, OH, GA and Mexico.
• Installation, management and support of Microsoft Exchange Enterprise 2000 and 2003. Spam support with BorderWareMXtreme Mail Firewall.
• Support of IT security programs within the company.
• Coordinate and organize the IT projects and the timeline of our IT staff with ClockIngIT.
• Management of enterprise virus protection with Norton Antivirus Enterprise.
• Escalated support role for Wintel desktops/laptops.
• Implementation, customization, and support for different Shipping multi-carrier solutions that cover the shipping process with multiple carriers FedEx, UPS, DHL, USPS and other LTL service providers through Ascent software from Pitney Bowes and Starship from V-Technologies. Those customizations include the feedback information Tracking packages and shipping costs from these systems to our ERP solution.
• Deployment and support of EMC ApplicationXtendercontent management software.
• Planning, deployment and maintenance of QuoteWerks software.
• Desktop/End User Support.

Confidential

Network Administrator.

• Planning and deployed and support all activities in the network LAN and WAN , servers and workstations, based in Microsoft Windows platform, server and workstations.
• Deployment and Administration of SQL Server, Data Migration from FoxPro to SQL server successfully.
• Setup and maintenance mail servers in Lotus CC-Mail and Lotus Notes in the headquarters and different branches.
• Programming Corp. Sales Reports in Access and SQL server.

Confidential

GIS specialist.

• Create and maintenance a Cuban Hydrographic Data Center based in SQL server and Windows application development in Visual Basic.
• Installation and administration of a LAN supported in Novell 3.12.
• Create Nautical Touristic maps in hardcopy and digital format using AutoCad and Corel Draw.

Confidential

Marine Geographer investigator

• Conduct investigations related with dynamics process on the beaches.
• Realize topographic controls in different Cuban beaches.
• Created a program for calculate, design and management topographic levels in GW Basic.