SUMMARY

 

·         6 years experience in database base administration (Installing, administering, implementing and troubleshooting SQL Server)

·         5 years experience in client/server development (Visual Basic, Crystal Reports, and SQL Server).

·         6 years experience in Windows NT LAN administration (Installing, administering and troubleshooting)  on a 100+  workstation networks

·         MCSE, MCP + Internet, MCP (40252)

·         SQL Server 6.5, Visual Basic 5.0 & Windows NT 4.0 certified. SQL Server 7.0, VB6 & Windows 2000 certifications in progress.

·         2 years experience in training (SQL, NT, VB)

·         1 year experience administrating NetWare 3.1X networks

·         Technical and communication skills, team leader/player

 

 

TECHNICAL SKILLS

 

Languages:      Microsoft Transact SQL 7.0, 6.5, 6.0, 4.2 (6 years), Visual Basic 6.0, 5.0, 4.0, 3.0 (5 years), ANSI-SQL 92 (2 years), Pascal (5 years), C (4 years), BASIC (8 years), Clipper (4 years), Dbase  (4 years), Modula, (1 year), Assembler (1 year), Access (6 months), Filemaker (6 months), Prolog (6 months), COBOL (1 year).

 

Databases:       Microsoft SQL Server 7.0, 6.5, 6.0, 4.2  (6 years), DBASE (9 years), Microsoft Access 97, 7.0, 2.0 (3 years), FileMaker (1 year), Informix  (6 months).

 

O/S:                 Microsoft Windows NT 2000, 4.0, 3.51, 3.5, 3.1 (6 years), Microsoft Windows 95 (4 years), Microsoft Windows 3.11 (6 years), DOS (10 years), Novell NetWare 3.1X (2 years as Manager), System 6.07, 6.08, 7 (Mac OS) (1 year), UNIX (2 years as user).

 

Hardware:        PC (11 years), Macintosh (1 year)

 

Other:             MSOffice (Word, Excel, PowerPoint, Access), MS Project,

                        NT BackupExec 6.2 – 7.3, NetIQ 3.4.

 

 

WORK EXPERIENCE

 

Senior Consultant, Laxmi Group,

(Huntington Beach, California, USA)     

Apr ’99 to Present

 

Project            Database Administrator at Disneyland Resorts (Anaheim, CA)

Software         MSSQL 4.21, MSSQL 6.5, MSSQL 7.0 (Standard & Enterprise),

                       NetIQ 3.4, NT Backup Exec 6.2 – 7.3, Excel (VBA)

O/S                 Windows 95/98, Windows NT (Standard & Enterprise)

Hardware        PC’s, Compaq Proliant 850 – 6000

Role                Contractor as a DBA to support SQL Server system based

                       computers.

 

Description:    I’m working primarily as a member of SQL Server DBA team

                       that supports more than 21 SQL Servers. I also was exclusive

                       SQL Server DBA for all Y2K related test activities.

Responsibilities:

·         Development

·   SQL Server Back-end for maintenance and reporting.

·   SQL Server Automated Maintenance Processes.

·   SQL Server Audit processes for third party applications.

·   SQL Server Back-end to complement other applications.

·   SQL Server automatic e-mail notification and sent of results.

·   Excel-VBA automated report programs that extract SQL Server information using SQL DMO.

·   NetIQ-VBA Creating personalized NetIQ scripts for business necessities.

·   Helping Development team to audit Front-end application calls to SQL Server.

·   Helping Development team to create efficient Queries, Indexes, Views, Stored Procedures

 

·         LAN/Servers Administration

·   Analyze, Design & deploy an accurate method to quantify SQL licenses usage.

·   Installing, Configuring and tuning of software that interact with SQL Server NT Computers.  (NT, Backup Exec, etc)

·   Network Security for SQL Server Computers.

·   Network Backup strategy and automation for SQL Server Computers.

·   Automation of some tasks.

·   Monitoring Network Performance.

·   Installing, Configuring and expanding Hard Disk arrays.

·   Studying different scenarios to accommodate future growth.

 

 

·         Database Administration

·   Handle 2 NT/SQL Cluster configurations.

·   Database Administration (Space, Distribution, Recovery, etc.)

·   Installation & configuration of SQL Servers 6.5 & 7.0.

·   Migrating SQL 6.5 & 7.0 Databases.

·   Migrating SQL 6.5 Servers to a different Sort Order.

·   Administering SQL 6.5 & 7.0 Server Security.

·   SQL Server Backup strategy and automation.

·   BCP & DTS Processes.

·   Automation of maintenance jobs.

·   Tuning SQL Server Configuration (Memory, Locks, Indexes, etc.).

·   Troubleshooting.

·   Studying different scenarios to accommodate future growth.

 

Senior Consultant, Laxmi Group,

(Huntington Beach, California, USA)     

Mar ’99 to May ‘99

 

Project            Part time Developer at Importers Software.

Software         Oracle 8i, VB 6, ADO.

O/S                 Windows 98, Windows NT

Hardware        PC’s

Role                Contractor as Part time/Telecommute developer.

Description:     I was helping to start a development project while full time staff

                        was being recruited.

Responsibilities:

·   Develop basic store procedures in Oracle, Develop components to be run in a three-layer system.

DISIS S.A. de C.V.,

(Guadalajara, Jalisco, Mexico) 

Dec ’94 to Apr ’99

 

Project             Development of Health Care systems for Latin America

                        countries.

Software          MS SQL, Visual Basic, Access, Crystal reports.

O/S                   DOS, Windows 3.11, Windows 95, Windows NT

Role                 Development Project Leader / Technical Support Department Manager / Outsourcing

Description:      I was Invited to initiate this company (5 people at beginning actually over 50) to develop Health Care systems for Latin America. Began as a Senior Programmer and later was promoted to Development Project Leader. On December ´95, became the Technical Support Department Manager and since September ’97 I’m outsourcing this company on my own in several areas.

 

Responsibilities:

·         Development

·   Front-end / back-end developer and development leader (5 people).

·   Optimizing, maintaining, developing  and Auditing some specific code, especially back-end (stored procedures, triggers, rules, constraints and defaults)

·   Reviewing Database Designs to optimize them for Microsoft SQL Server.

·   Training developers in development tools (VB & SQL) primarily SQL 6.5 and 7.0.

·   Research SQL Server 7.0 Development.

 

·         LAN Administration

·   Network Administrator (Technical Support Responsibility).

·   Leading LAN Administration (2 Technical Support staff).

·    Installation of new workstations and servers (NT 4.0, NT 5.0, Win 95).

·   Workstations and Servers Configuration.

·   Network Security.

·   Network Backup strategy and automation.

·   Automation of some tasks.

·   Monitoring Network Performance.

·   Installation and configuration of DHCP.

·   Installation and configuration of RAS.

·   Installation and configuration of Proxy.

·   Upgrading (Win95 to Win98, NT 4.0 to NT 5.0).

·   Installing, Configuring and tuning our products at client’s locations.

·   Remote access to client’s networks.

·   Training in Windows NT.

 

·         Database Administration

·   Database Administrator. (Technical Support Responsibility)

·   Leading Database Administration (2 Technical Support staff).

·   Installation & configuration of SQL Servers.

·   Migrating SQL 6.5 Databases to SQL 7.0 Databases.

·   Administering SQL Server Security.

·   SQL Server Backup strategy and automation.

·   Automation of maintenance jobs and products routines at site and with clients (Transaction logs, errors, custom store procedures).

·   Maintenance of several 1GB databases for development, test, technical support (simulations) and training at site.

·   Installing and configuring SQL Server parts of our products at client’s sites (Biggest database 6.5 GB).

·   Tuning SQL Server Configuration (Memory, Locks, Indexes, etc).

·   Troubleshooting.

·   Testing replication scenarios for our products.

·   Training in SQL Server Administration and implementation.

 

·         Technical Support

 

·   Created this area in 1995 to give development team and clients 24 hrs. * 365 days continuous service. This area includes LAN Administration, Database Administration, Clients telephone Technical Support, Knowledge Base Management, Clients Remote Access, Installations & Deployment.

 

·   No longer the Technical Support Department Manager (Since outsourcing), but help with LAN Administration and Database Administration 

 

 

Independent Adviser & Instructor (BackOffice),

(Guadalajara, Jal., Mex)     

Sep ’97 to Apr ’99

 

Project:         Adviser

Software:      Windows NT, Windows 95, and SQL Server

O/S:              Windows NT, Windows 95

Role:              Adviser, Trainer.

Description:   Advise and give specific training to Manufacturing, Developing and Commercial Companies that use Windows NT, SQL and Visual Basic.

Responsibilities:

·   Training /Advising client’s DBAs

§   Installation, Configuration, Security, Maintenance, Backups, Recovery, Tuning, Scheduling Tasks, Replication, Queries, Upgrading, Troubleshooting.

·   Training /Advising client’s LAN Administrators.

§   Installation, Configuration, Security, Backups, Tuning, Scheduling Tasks, DHCP, RAS, Upgrading, Troubleshooting.

·   Training /Advising client’s Developers.

§   Queries, Indexes, Views, Stored Procedures, Rules, Constraints, Permissions, Optimizing processes, Upgrading, Troubleshooting.

 

Project            Delivering Microsoft Official Courses for BackOffice products.

Software         Windows NT, Windows 95, SQL Server, IIS, Proxy, TCP/IP,

                        Visual Basic.

O/S                  Windows 95, Windows NT

Role                 External Instructor.

Responsibilities: 

Teach the following courses at Microsoft CTEC’s:

 

System Administration for Microsoft SQL Server 7.0, Implementing a Database on Microsoft SQL Server 7.0, Upgrading to Microsoft SQL Server 7.0, Microsoft SQL Server 7.0 Overview, System Administration for Microsoft SQL Server 6.5, Implementing a Database Design on Microsoft SQL Server 6.5, Microsoft Visual Basic 5.0 Fundamentals, Microsoft Visual Basic 5.0 Programming, Networking Essentials, Microsoft Windows NT 4.0 Administering, Microsoft Windows NT 4.0 Core Technologies, Microsoft Windows NT 4.0 Enterprise Technologies, Internetworking with Microsoft TCP/IP on Microsoft Windows NT 4.0, Creating and Configuring a Web Server using Microsoft Internet Information Server 3.0, Creating and Configuring a Web Server using Microsoft Internet Information Server 4.0, Securing a Web server with Microsoft Proxy Server 2.0,  and also the Microsoft Office Suite.

 

Programming Languages Professor, Instituto Tecnológico y de Estudios Superiores de Occidente,

(Guadalajara, Jal., Mexico)                    

Jan ’97 to Dec ’97

 

Project:          Delivering University courses for Computer Science Career.

Software:       Visual Basic, C

O/S                 DOS, Windows 95, Novell 3.X & 4.X

Role                Professor

Responsibilities:

·   Delivering Visual Basic & C Courses and coordinating students projects.

 

 

 

System Engineer, Manufacturas Tecnológicas S.A. de C.V.,

(León, Gto., Mexico)   

June ’93 to Nov ’94

 

Project             Outsourcing and Development for other companies.

Software          Clipper, Dbase, Pascal, C, MS Office, File Maker.

O/S                   DOS, Novell 3.X, MAC OS, Windows 3.11

Role                 Computing Adviser and developer.

Description:  This is a familiar company dedicated to Telecommunications projects where I am shareholder. I created Systems Department.

Responsibilities:

·   Analysis, Design, Implementation and Test of short development projects (2 months) to the company and other companies.

·   Network Administrator.

·   Technical support to the company and outsourcing to others.

·   Training people in Software applications.

·   Selling Computing Equipment.

 

Computing Adviser, Instituto de Estudios Superiores de Occidente,

(Guadalajara, Jal., Mexico)         

Jan ’92 to Jun ’93

 

Project:           Partial Time employee for an administrative University

                        Department

Software:        Clipper, Dbase, Pascal, and C, MS Office.

O/S                  DOS, Novell 3.X

Role                 Computing Adviser

Description:     Employed by University as partial time employee to help one of the biggest administrative departments.

Responsibilities:

·   Involved in the Analysis, Design, Implementation and Test for some dependency LAN projects in conjunction with University Computing Department.

·   Evaluating Software and Hardware prior buying.

·   Technical support to department users and PC’s equipment.

·   Training department people in Software applications.

·   Managing Novell Network for my department (40+ people).

·   Administrative Functions.

·   Coordinating Department Social Services projects.

 

Developer at Instituto Tecnológico y de Estudios Superiores de Occidente,

(Guadalajara, Jal., Mexico)         

Jun ’91 to Nov ’91

 

Project:          Social Service Control System (Multi-user)

Software:       Clipper Summer 87

OS                  DOS & Novell 3.X

Role                Developer (Social Service)

Description:    Institution accepted this project as my Social Service. I worked in coordination with University Computing Department, because all systems had communication with each other, and including Multi-user capabilities.

 Responsibilities:

·   Analysis, Design, Implementation and Test of the Project. (With University Specifications)

 

Jr. Programmer at Banca Serfín, S.N.C,

(Guadalajara, Jalisco, Mexico)                

Oct ‘88 to Apr’89

 

Project:           Internal Administrative Requests System  

Software:        DBASE III plus and Clipper Summer 87

OS:                  DOS

Role:               Programmer (Professional Practices)

Description:    SERFIN was the third biggest Bank in Mexico. I was accepted by the Institution to participate in this Internal Administrative Request System. 6 people formed the team and a Systems Engineer coordinated us

Responsibilities:

·   Documenting processes.

·   Programming in DBASE III +  & Clipper Summer 87

·   Testing

 

Jr. Programmer at BANAMEX, S.N.C.,

(Guadalajara, Jalisco, Mexico) 

Feb ‘88 to Aug’88

 

Project:          Internal Administrative Requests System  

Software:       DBASE III plus and Clipper Summer 87

OS:                 DOS

Role:               Programmer (Social Service)

Description:    BANAMEX was the biggest Bank in Mexico. I was accepted by the Institution to participate in this Internal Administrative Request System. 3 people formed the team and a Systems Engineer coordinated us.

Responsibilities:

·   Documenting processes.

·   Programming in DBASE III + & Clipper Summer 87

·   Testing

 

 

EDUCATION

 

“Instituto Tecnológico y de Estudios Superiores de Occidente”, Bachelor Degree in Computer Science  1993

MCP, MCP + Internet, MCSE, Authorized Prometric Testing Center Administrator.

Technical Programmer Degree in addition to High School 1989

Has attended ongoing seminars in Computer Science, Engineering, Medical Informatics and Humanistic areas.

English language studies

TOEFL score 537 pt. (Nov. 1990)

 

TRAINING

I used to teach the following courses at Microsoft CTEC’s:  

System Administration for Microsoft SQL Server 7.0, Implementing a Database on Microsoft SQL Server 7.0, Upgrading to Microsoft SQL Server 7.0, Microsoft SQL Server 7.0 Overview, System Administration for Microsoft SQL Server 6.5, Implementing a Database Design on Microsoft SQL Server 6.5, Microsoft Visual Basic 5.0 Fundamentals, Microsoft Visual Basic 5.0 Programming, Networking Essentials, Microsoft Windows NT 4.0 Administering, Microsoft Windows NT 4.0 Core Technologies, Microsoft Windows NT 4.0 Enterprise Technologies, Internetworking with Microsoft TCP/IP on Microsoft Windows NT 4.0, Creating and Configuring a Web Server using Microsoft Internet Information Server 3.0, Creating and Configuring a Web Server using Microsoft Internet Information Server 4.0, Securing a Web server with Microsoft Proxy Server 2.0,  and also the Microsoft Office Suite.

 

CERTIFICATIONS

 

Microsoft Certified Professional, Microsoft Certified Professional + Internet, Microsoft Systems Engineer (MCP ID 40252) with the following certification exams: Microsoft SQL Server v4.2 Database Administration for Microsoft Windows NT, Microsoft SQL Server v4.2 Database Implementation, System Administration for Microsoft SQL Server 6.5 and Implementing a Database Design on Microsoft SQL Server 6.5, Developing Applications with Microsoft Visual Basic 5.0, Networking Essentials, Implementing and Supporting Microsoft Windows NT Workstation 3.51, Implementing and Supporting Microsoft Windows NT Server 3.51, Implementing and Supporting Microsoft Windows NT Workstation 4.0, Implementing and Supporting Microsoft Windows NT Server 4.0, Implementing and Supporting Microsoft Windows NT Server in the Enterprise, Internetworking with Microsoft TCP/IP on Microsoft Windows NT 4.0, Implementing and Supporting Microsoft Internet Information Server 3.0 and Microsoft Index Server 1.1, Implementing and Supporting Microsoft Internet Information Server 4.0, Implementing and Supporting Microsoft Proxy Server 2.0 (DT1587746).

 

Authorized Prometric Testing Center Administrator with the following certification exams: General Knowledge Test I: Policies and Procedures for Latin America, General Knowledge Test II: Basic Windows Usage, General Knowledge Test III: The Prometric Testing System.