Sql Server Manager

Juan GarciaB.

Email: *********@********.***

Address: *** ****** *** *** **

City: Bronx

State: NY

Zip: 10451

Country: USA

Phone: 347-***-****

Skill Level: Management

Salary Range: $40,000

Primary Skills/Experience:

See Resume

Educational Background:

See Resume

Job History / Details:

Juan Garcia Balbuena Email: ***************@*****.***

Phone: 347-***-**** and 646-***-****

Career Summary

Over 9 year experience Designing, Programming, Implementing and Maintaining relational databases, Designing, Programming and Implementing Information systems over those databases which supports Human Resources, Payroll, Timing, Raw Material and Finished Products Inventory, Sales Retail, Purchase, Payable and Receivable Accounts, General Ledger and Production Operations at large of a 3 different locations' company. In the infrastructure area, done a good experience working on all Microsoft Operating System from Windows 95 to Windows 2008 Enterprise (Operating System install and configuration, troubleshooting and general support, DHCP, DNS and Active Directory Setup) over a 550 desktops' Network.

A versatile professional driven to total customer satisfaction, practical experience in both Information Systems and Infrastructure based with strong growth desire.

Key Strengths

Extensive knowledge Microsoft Operating Systems, Microsoft SQL Server, Relational Database, Application Analysis, Application Design, Development, Implementation and Support systems.

Ability to adapt to new environments, tasks and challenges.

Highly developed analytical, research and problem resolution skills.

Adept at understanding technical solutions.

Excellent communications skills in Spanish and good English understood.

Project experience and good team works player.

Computer Skills

Database

* Maintaining a Microsoft SQL Server 2005 Database

* Designing and Maintaining an OLAP Microsoft SQL Server 2005.

* Deploying and Implementing a Database with Microsoft SQL Server 7.0

Operating Systems/Systems Server

* Install and setup Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP, Windows 2003, Windows Vista, Windows 7 and Windows 2008.

* Windows DNS, DHCP, Active Directory and Terminal services Setup.

* Microsoft Exchange Server 2003 and 2007 Basic.

* Microsoft ISA Server 2006 Basic.

Wireless and Networking

* Extensive Wireless configuration.

* Wiring Planning and installation.

Office Automation Packages

* Experience with Microsoft Office products Suite.

* Experience with Open Office products Suite.

Data Modeling and Development Tools

* Sybase Power Designer (Sybase Power Designer Data Architect).

* Sybase Power Builder (Object Oriented Development Tool).

* Sybase Power Pocket Builder (Object Oriented Development Tool for Mobile Platform)

* Basic of Microsoft Visual Basic 6.5 (Object Oriented Development Tool)

Virtualization Tool and Disaster Recovery Tool

* VMware and Double Take Availability (Basic).

Primary Projects

System Designing, Develop and Implementation

* Payroll system base on efficiency and ticketing

* Payroll system base on efficiency, difficulty production operation level

* Newsoft - Human Resources, Payroll, Timing, Manufacture Operations, Inventory - (Implement)

* Macola - Manufacture and purchasing module - (Implemented, Customized)

* MP2 - Maintenance planning and failure control - (Implemented)

* PackOne - Customer Edi Complain - (Implementation Planned and Managed)

* Carts - customer Edi Complain - (Implementation Planed and Managed)

* Crystal Reports (Basic Business Intelligent, Additional Reports Software implementation)

Data Migration, Transformation and Systems Integration (Planned, Designed, Developed and Implemented)

* DBF files to MS SQL Server (Migrated and Transformed Data), four times over different location.

* Newsoft - Macola; equipment assignment cost, Production cost, Employees' Payment, Etc.

* Newsoft - Macola Integration

Professional Experience

Bellon, S. A. - Santiago, Dominican Republic; January 2009 to October 2012

IT Principal - Analyze company's information needs, designed, developed and implemented software solution that fit actual application (in house developed) also managed help desk activities (infrastructure, application and operating system)

* Managed a team of three staff and relation with two outside contractors.

* Coped the design and deploy rules for reinforce the data integrity and security.

* Ran all needed implementation, maintenance and upgrades for Database, Operating System and software.

* Managed the Information systems activities related to facilities and range of operation.

* Controlled all help desk activities.

* Performed Full DBA works.

* Analyzed of complex situation to decide if a customization is required.

* Performed extensive SQL programming as Stored Procedure, Views, Queries, Tables, Constraint (MS SQL Server from version 2005 and 2008) and minimum in MS Access.

* Performed Extensive programming in Sybase PowerBuilder 11.5 and Pocket PowerBuilder 2.5.

* Health's check of DHCP, DNS and Active Directory services.

* Installed and Configured Windows Server operating system as needed.

* Assured VMware Virtualization updates were correctly installed.

* Assured Severs Mirror Application (Double Take) was Online.

Prodacom. - Santiago, Dominican Republic; December 2007 to December 2008

Technical Support Manager - Internal support (30 Windows XP PCs and a Windows 2003 Server) External general support from installing, repairing and configuring computers to installing and setting servers over Microsoft Windows Operating Systems among several Windows Server services (DNS, DHCP, Terminal Services, File and Print Services and Active Directory)

* Managed a team of seven staff.

* Distributed all received services request (approximately 120/Month) to technicians.

* Supported two Windows 2008 Server (One running Microsoft SQL Server 2005 and One running as File Server plus Microsoft ISA Server 2003)

* Performed online purchase for all Laptop repair.

* Managed Return Merchandise Authorization department.

* Performed in site Setup and Operating System Configuration for servers acquired upon customer request.

Interamericana Products, Inc. - Santiago, Dominican Republic; August 2001 to May 2007

Information System Manager - Designed, Implemented, Maintained, Supported and Managed strategic software solution to afford the company growth and information needs. Role also included integration across 6 different systems and 15 databases.

* Managed a team of three staff and the relation with several outside contractors.

* Coped the design and deployment of all new rules for reinforce the data integrity and security.

* Ran all needed implementation, maintenance and upgrades of all databases and software.

* Handled entire software structure, including maintenance, upgrades, troubleshooting, and improvement strategies according to the company's plans. Some with external contractor.

* Assured stability and optimization of 8 applications system.

* Managed Information systems activities related to integration, facilities and operation range.

* Participated in meetings with customers to coordinate and implement their software requirements.

* Managed all software support activities.

* Performed full DBA works.

Interamericana Products, Inc. - Santiago, Dominican Republic; January 1999 to August 2001

System Analyst and Designer - Analyzed information needs and Designed an Integrated software solution implement with a high acceptance level. Role also included evaluation of integration with any other application.

* Analyzed of complex situation to decide if a new application is required or if one of the actual applications fits the needs. Even with customization

* Analyzed and designed integration and customization.

* Participated in conferences with customers' meetings in order to be able of designing a solution that allows company to manage their data.

* Supported IT manager to make decision over and planning all systems requirements.

* Participated in all new applications, new integrations, new customizations test system.

* Worked together with the programmers, Implementers and Supplier to drive system requirements.

* Developed data flows in order to proceed with the applications' installation.

* Managed data Modeling and Migration.

* Performed full DBA works.

Interamericana Products, Inc. - Santiago, Dominican Republic; January 1997 to December 1999

System Developer - Developed in house system Applications, Integration and customization task among programming and maintaining Relational Databases.

Interamericana Products, Inc. - Santiago, Dominican Republic; February 1996 to January 1997

Help Desk -, Responsible for systems troubleshooting and infrastructure's assistant

Education

Universidad Tecnologica de Santiago

Santiago, Dominican Republic

Information System and Computer Science Engineer

Bachelor's Degree

Personal/Professional References

Edwin Arias 809-***-****)

Carlos Iglesias 809-***-**** Ext. 1204)

Jose Manuel Martinez 809-***-****)

Contact this candidate