Summary

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 t up t 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 t 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 t 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 different complexity tier levels of support, implemented a Help Desk system in a corporate environment with ServiceDesk Plus 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 .

Skills

• 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.5 with soft load balancing VMware ESX/ESXi multiples 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, Backup Exec 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 the use of different networks appliances like Routers, 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-SQL implementing 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 Studi 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.

Experience

Confidential

IT Consultant / IT Infrastructure and Services Freelance

• Blackberry server.
• Corporate Reporting System.
• SharePoint 2010 Foundation and Enterprise editions .
• Symantec Backup Exec 12.5.
• Firewall and Security Suites installation in corporate environment for server and client systems based on Symantec EndPoint Protection, Enterprise Edition or Trend Micr Worry-Free Business Security Advanced
• Sybase SQL Anywhere and MySQL management servers multiples versions .
• SQL Server multiples versions: 6.5, 2000, 2005, 2008, 2008 R2, 2010, 2012 .
• Exchange Server multiples versions: 5.5, 2003, 2007, and 2010 .
• IIS Server.
• Print Server.
• FTP Servers IIS and Gene 6 FTP server
• DFS.
• File Server.
• WINS.
• DNS.
• DHCP.
• Open Directory for Mac OS X Server.
• Active Directory for Windows Server.
• 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:
• Install and management virtual servers and workstations using VMware vSphere and VMware ESXi, multiples versions, and Parallels Desktops for Mac.
• Setup of Wireless AP in corporate environment Ruckus and Dell PowerConnect systems .
• Setup of NAT, firewalls, security access rules and VPN.
• Coordinate installation of internet service with multiples ISP providers Comcast, AT T and others with different kind of service level including Metr Ethernet, cable, vDSL or DSL.
• Wireless AP in corporate environment Ruckus and Dell PowerConnect systems .
• Cisc ASA security appliance or SonicWALL appliance.
• Routers, multiples brands.
• Switches in Unmanaged and Managed mode, multiples brands.
• Networking, including setup and management of:
• 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.
• 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 services through multiples web hosts management interface Parallels Plesk and cPanel .
• Remote Management of Domain Names through GoDaddy, Advansis Networks GoDaddy - partner , Network Solutions, Yaho Small Business and HostGator.
• Execute successfully migration of corporate email domains from Microsoft Exchange 2010 installed On-premise t Google Apps through 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 including setup 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 t recommend t 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.

Confidential

ERP and Reporting Writer specialist

• Proposal, implementing and management of virtualization project based on VMware vSphere 4.0 Enterprise level t 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 t 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, t Microsoft Online Services.
• Deal with external IT providers t cover the monitoring services and Exchange server hosted externally in a cloud.
• Management the ERP system based in Exact Macola Progression in multi-companies environment, including all Macola modules:
• SY - System Management
• OE - Order Entry
• IM - Inventory Management
• GL - General Ledge
• AP - Account Payable.
• AR - Account Receivable.
• 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 t the last version.
• Management and maintenance SQL Server 2005, Enterprise Edition. Migration t 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 Studi 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 t 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 t 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. These reports were development in Visual Studi 2008 and deployed in SSRS native mode and reflect the Sales Representatives and 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 system based 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-up using Veritas NetBackUp with 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 int 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 t MS SQL Server in order t 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 int 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 t allow for proper testing and debugging.
• Deployment/promotion of new data models, structures, and objects t production database environments.
• Provide help t database developers and programmers on create and maintenance data structure, indexing, triggering actions and T-SQL code writing.
• Development and support a new corporate reporting system using Microsoft Reporting Services/SSRS with Visual Studi 2005 including complex reports design, data sourcing from disparate repositories, publication t company intranet, providing the Corporate Reporting tools t 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 t resolve the specific data request needed per intranet user type matched with the departments mentioned above. These reports was development using parameters in order t 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 t 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 t complaint with the security data access that doesn't allow possible injection threads t 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 t 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 t 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 t 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 ServiceDesk Plus 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 BorderWare MXtreme 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 t our ERP solution.
• Deployment and support of EMC ApplicationXtender content management software.
• Planning, deployment and maintenance of QuoteWerks software.
• Desktop/End User Support.

Confidential.

• 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 FoxPr t 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

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.