Information Technology Sql Server

Barry Gallegos

*****.**********@*****.***

**** *. **** ******* ****** Kuna, Idaho 83634

Cell Phone 208-***-****

Home Phone208.387.0305

Objective

Self-motivated, engineering team member with 20 plus years’ experience in the electronics field. Seeking to use my background in review of technical documentation to create work instructions, establish product flow, and managing documentation release for an organization where I can positively impact my employer with my newly acquired information technology education. I am ready, self-disciplined, loyal, and eager to transition into this new career field.

Work Experience

Western Electronics, Meridian Idaho, 06/1999-Present

New Product Introduction Coordinator

Work directly with program managers and process engineers for the development of process critical manufacturing documentation. Program HTML web pages for Online Documentation system, responsible for creating, updating, and maintaining the online document system for the company.

IPC 7711 / IPC 7721 Registered Instructor. (Certification Expired)

IPC-A-610 Class A Instructor. (Certification Expired)

Played key role in the transition from hardcopy paper documentation to online paperless process.

Design and manage Microsoft Access NPI Database with 9 entities & 69 attributes.

Computrol, Meridian Idaho, 06/1994-05/1999

Process Technician

Process Technician – Monitor processes for quality issues.

IPC-A-610 Class A Instructor

Quality Inspector

AES Security, Boise, ID, 1993-1994

Loss Prevention Officer

Uniformed Armed Patrol and Work in plain clothes to mingle with shoppers and prevent thefts. Directly pursue shoplifters and notify management and law enforcement of incidents

Uniformed Armed Security.

Continuously patrol premises to secure patrons and property.

Monitor hot spot areas where security coverage is limited to check for violators.

Report writing, Crime prevention methods, High level of integrity, Observant, Reliable

Payless Retail, Boise, ID, 1992 – 1993

Loss Prevention Officer

Work in plain clothes to mingle with shoppers and prevent thefts. Directly pursue shoplifters and notify management and law enforcement of incidents

Report writing, Crime prevention methods, High level of integrity, Observant, Reliable

TIS Security, Killeen, TX, 1991 – 1992

Loss Prevention Officer

Work in plain clothes to mingle with shoppers and prevent thefts. Directly pursue shoplifters and notify management and law enforcement of incidents

Report writing, Crime prevention methods, High level of integrity, Observant, Reliable

Power Inspection Corporation, Botswana, Africa, 1990-1991

Field Service Engineer

Contract Field Service Engineer to Botswana, Africa Training African soldiers.

United States Army, Ft. Knox Kentucky, 1980-1989

Missile Technician

Sargent E5 Promotable.

Secret Security Clearance.

Basic Non-Commissioned Officers Course

Primary Leadership Development Course

Education

In-Pursuit of Master’s degree (MIS) - Management Information Systems

University of Phoenix, Phoenix, Arizona

Key concepts

IT Infrastructure

Systems Analysis and Development

Enterprise Models

Emerging Technologies and Issues

CIS Project Management

CIS Strategic Planning

IS Integration

Database Management

Business Systems

Bachelor’s degree – INFORMATION MANAGEMENT, June/2015

University of Phoenix, Phoenix, Arizona

Key concepts

Web Design Fundamentals – basic hypertext markup language, scripting, and presentational technologies to create web sites without the aid of a software authoring application.

Introduction to Operating systems

Intro to Information Assurance & Security

Fundamentals of Networking

Technical Writing – strategies, techniques, and nuances for producing e-mails, memos, reports, proposals, project specifications, and user manuals, as well as other technical documents.

Project Planning & Implementation - Microsoft® Project 2010.

Database Concepts – data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration.

Java Programming I – Introduction to object-oriented programming in the context of business applications development. The basics of the Java programming language covered.

SQL for Business – DDL (Data Definition Language), T-SQL (Transactional SQL)

Data Organization Architecture

Data Modeling – ERD (Entity Relationship Design)

Enterprise Database Management Systems – Build Data Warehouse

SDLC (Systems Development Life Cycle) DBDLC (Database Development Life Cycle

Associates degree – Concentration in Information Technology/Database Development, April/2013

University of Phoenix, Phoenix, Arizona

Key concepts

Communications

Critical and Creative Thinking

Management of Information Systems

Database Development using MS Access and SQL Server

Introduction to SQL (Structured Query Language)

Managing the Database Environment

Relevant Coursework Projects

DVD Movie Collection, University of Phoenix, 07/ 2012 – 09/2012

Researched, designed, and developed MS Access database for a personal DVD Movie Collection

Planning and Development Database, University of Phoenix, 09/2012 – 11/2012

Designed and developed an MS Access database normalized to third normal form for a virtual Riordan Manufacturing organization.

Fleet Maintenance Database, University of Phoenix, 04/2014 – 05/2014

Helped to design and develop an MS Access virtual trucking organizations fleet maintenance database

Chart of Accounts Database, University of Phoenix, 11/2014 – 12/2014

Team project to design a SQL Server 2012, Database that contains the fields found in the virtual company’s Chart of Accounts.

SSRS report created that added a balance field to the report that shows the total balance.

Baderman Hotel Maintenance Database, University of Phoenix, 01/2015 – 02/2015

Using Oracle Express Database platform, create a database for a virtual organization Baderman Hotels that consists of three hotels. The database consisted of 7 tables; Hotel, Rooms, and Room Type, Managers, Supervisors, Employees, and Departments.

Created a Visio ERD diagram of the Database

Baderman Hotel Reservations Database, University of Phoenix, 02/2015 – 03/ 2015

Using Oracle Express I expanded upon the original Hotel database to add a reservation system to the existing database and increasing the number of tables/entities from 7 to 14 adding the following tables; Guest, Reservations, Rooms available, check in Check out, Conference Rooms, Convention Centers, Events, and Credit Cards.

Revised the original ERD diagram to include the new entities.

Lafleur Trading Company Data Warehouse, University of Phoenix, 04/2015 – 05/2015

In SQL Server 2012, I created a data warehouse and business intelligence application that was to support the monitoring of sales at Lafleur Trading Company.

The DW consisted of 10 DIM tables/entities and 2 Fact tables/entities.

Created an ERD diagram both in Visio 2010 and within SQL Server

Contact this candidate