ALEJANDRA HERNANDEZ

(***) *** – ****, Houston, TX - 77079

Email: ac7t0k@r.postjobfree.com

SQL/Web developer with more than 10 years of experience using Microsoft technology such as MSSQL Server and VS.NET (VB) interested in getting a job in which I can participate in different projects applying knowledge acquired over the years.

EDUCATION

Universidad Nacional Autonoma de Mexico (UNAM), Mexico City

1997 - 2001

Bachelor's degree - Computer Engineer

Professional ID #3956090

EXPIRIENCE

AUG 2014 – TO PRESENT

WEB DEVELOPER, Pappas-Haddad VEntures LLC

Design, develop and maintenance of an Administrative Web Site based on MSSQL Server 2012 and VB.NET (MS VS 2010) hosted on Goddady.

Multi-unit support franchise based in Houston, TX

https://phvsystem.com

Develop of all phases of the software development life cycle.

The website is composed by modules like:

oCatalogs: Stores, Artist Staff, Inventory of Paintings, Product Categories, Product Measures, List of Products.

oProcesses for artistic staff: capture of classes and capture of bonuses

oProcesses for managers: Capture of private parties, Party tracking information, Paintings File System, Capture of weekly inventory.

oProcesses for general manager: Review of classes and bonuses captured by artistic staff. Payroll management. Inventory management.

oSearches: Paintings locations around all the stores, Record for artistic staff, Roster.

oOther processes like: Creation of customer email templates, Send employees and customer notifications.

oDifferent reports based on SSRS.

AUG 2004 – SEP 2014

WEB DEVELOPER, universidad autonoma de la ciudad de mexico

This was recent creation University with around 3000 students, working there from 2004 to 2014, my duties were:

At the beginning

Being the leader of a team of 3 people, for 1.5 years

Install and set up the first database server

Create the first desktop application to control all student information using VB6 and SQL Server 2000

Design and create normalized databases

Create store procedures and views

Maintain and develop different modules for the Student Administration App

Create some basic Crystal Reports

Then

Worked as a team player of a 4 developers team

Collaborate with Network and Servers Team to Install and set up a SQL Server 2005 Database Server

Migrate databases, objects and users from MSSQL Server 2000

Review of deficient and slow running queries, missing indexes for better performance.

Translate end users requirements into automated processes

Being involved in all phases of the software development life cycle to create a website based on the Student Administration App using VB.Net (ASPX) with modules like:

oStudents personal information

oStudent enrollment process

oAttendance tracking for student classes (module for teachers)

oEnrollment of students to subjects

oCertification student process tracking.

Develop and maintain store procedures, triggers, functions and views.

Create Jobs to back up databases.

Use of MS SQL Server Reporting Services for reports deployed into websites

Technical support for users of the 5 campuses and 2 administrative buildings

Design and development of different websites like:

oStudent Social Security service Sign In Process

oPsychology department

oGeneral telephone directory of the university

oEmployees information tracking

Interchange information with postgres databases

Manage all information related about more than 25000 students and around 1000 employees

Work with a team of 7 people

For more information about the University please go to the site uacm.edu.mx

MAR 2003 – JUL 2004

DATABASE PROGRAMMER ANALYST, Tecmarketing s.a. de c.v.

Maintaining and adding modules to a system created to keep the mobile internet customers registry for Telmex company.

Monitor different databases between multiple servers

Writing SQL queries, store procedures, views, Jobs.

Technology used MSSQL Server and VB6

Responsible of the maintenance and development different modules related to a desktop application developed using VB6 connected with different SQL Server 2000 databases and a AS400 database, this app was used by hundreds of users.

Tasks:

Create tables, store procedures, views, triggers, indexes

Write queries for different tasks for example:

create massive quantity of users along with their corresponding privileges for different systems access

upload and process massive data coming in different formats like .xls and .txt

deleting duplicated rows

removing corrupted data

replicate thousands of records in up to 7 database servers

generate reports with different information about sales, orders, order status, etc.

Create jobs for tasks like:

Running full and differential backups for several databases

Sending customer sells information to DHL (to ship internet connection devices)

Sending sales information from one server to others

Truncating database logs

Create basic DTS packages

Working with a team of 10 people

JAN 2002 – DIC 2002

PROGRAMMER, avantec s.a. de c.v.

Create tables

Create and modify stores procedures and views

Coding modules using VB for Applications

ERP installation and set up at client office

http://avantec.wixsite.com/dataflow

IT COURSES

2018

Responsive Web Design Certification – 300 hours, FreeCodeCamp.com

2014 Microsoft Certified Solutions Associate (MCSA): SQL Server 2012

70-461 Querying Microsoft SQL Server 2012

70-642 Administering Microsoft SQL Server 2012 Databases

70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012

2008

2787 Designing Security for Microsoft SQL Server 2005, 14 hrs.

2788 Designing High Availability Database Solutions Using Microsoft SQL Server 2005, 21 hrs.

2796 Designing a Multi Dimensional Solution Architecture Using Microsoft SQL Server 2005 Analysis Services, 21 hrs.

2797 Designing a Reporting Solution Architecture using Microsoft SQL Server 2005 Reporting Services, 14 hrs.

2007

2779 Implementing a Microsoft SQL Server 2005, 21 hrs.

2780 Maintaining a Microsoft SQL Server 2005 Database, 21 hrs.

2781 Designing Microsoft SQL Server 2005 Server-Side Solutions, 21 hrs.

2782 Designing Microsoft SQL Server 2005 Databases, 14 hrs

2784 Tuning and Optimizing Queries Using Microsoft SQL Server 2005, 21 hrs.

2786 Designing a Microsoft SQL Server 2005 Infrastructure, 14 hrs.

SKILLS

MSSQL Server (T-SQL, SSRS)

VS.Net (VB.Net)

HTML, HTML5

CSS

Bilingual in Spanish

PERSONAL HIGHLIGHTS

Fast learner

Self-taught

Independent worker and team player

Persistent person

VOLUNTEERING

Worked as a volunteer in Spring Branch Family Developer Center, teaching basic computer and internet classes.

Contact this candidate