DISCLAIMER:
The resume of Alvaro Sanchez (both the online and the downloadable version) are provided for use by potential employers, head hunters, or agents who represent them for the sole purpose of potentially landing Alvaro Sanchez a new job or contract. No part of the resume may be altered or redistributed for any reason without the full, written, and prior consent of Alvaro Sanchez.
Downloadable versions of the resume always include the date it was last modified and a downloaded resume is only guaranteed up to date and complete through that date.
 
 
Background Summary
 
Alvaro Sanchez is a Senior Information Technology Professional with over 13+ years experience holding a variety of positions from Database Administrator/Developer to web developer and database migration specialist.

He is an accomplished programmer using languages such as PL/SQL, Transact-SQL, Visual Basic, ASP and VB Script. Alvaro’s experience includes; database programming, data modeling, analysis, design, and object oriented concepts. Most recently he was the senior component developer/designer on a large scale Enterprise multi tier platform. He holds Bachelor's degree in Computer Science (1990) and is completing the second year of the Computer Science Master Degree Program at the University of Ottawa.
 
Alvaro is self-motivated, team-oriented, highly reliable and responsible with strong work ethics.
 
Security Level: Secret cleared
 
Certifications: Microsoft Certified Application Developer (MCAD)
 
Language: English, Spanish
 
Download resume: Word 6.0 format
 
Skills Profile: See Appendix A
Experience
 
IMMIGRATION AND REFUGEE BOARD OF CANADA
Senior Web Programmer Analyst
Duration: (11/03) - Current
 
 
  • Software development for transactional/multi-tier enterprise web applications using iterative/spiral development approach.
  • Database design and coding for data migration tools using Visual Basic.Net and transact-sql. Integration with enterprise services such scheduler Microsoft Operations Manager (MOM).
  • Preparing technical documentation using UML class and activities diagrams. Code reviews and unit testing.
  • Component-based design and development using web services and net remoting under Visual Basic-Net.
  • Front-end developing using CSS/XSL/XML/HTML/DHTML, ASP.NET, JavaScript.
Environment: Visual Source Safe, UML, .NET Framework, Visual Studio 7, VB.NET, ASP.NET, ADO.NET, HTML, DHTML, XSL-XML Web Services, JavaScript, CSS, MS-SQL server 2000, DTS packages and Transact-SQL store procedures.
 
 
TELESAT CANADA
Senior Web Programmer Analyst
Duration: (09/03) - (10/03)
 
 
  • Provide software development for transactional/multi-tier client-server web applications.
  • Provided database design and development using an iterative approach, middle-tier design and development, front-end design, coding and optimization.
  • Integration with bar code readers and label printer software using label software API and COM.
Environment: Visual Basic 6.0,COM, Source Safe, CSS, HTML, DHTML, XML, ASP, VBScript, JavaScript, Visual Interdev, ADO, MS-SQL server 2000 and Transact-SQL.
 
 
MEDICAL COUNCIL OF CANADA
Database Administrator
Duration: (03/03)
 
 
  • Provided performance analysis and enhancements for backend (sql server) tier. Database design review and Index analysis.
  • Load, stress-testing using automated tools (eValid toolset).
Environment: Transact -SQL, ADO, SQL Server 7/2000 and eValid.
 
EXPORT DEVELOPMENT CANADA
Senior Component Developer (Performance and optimization team)
Duration: 22 months (09/01 - 06/03)
 
 
  • Provided enterprise development in a multi-tier environment
  • Middle/Backend-tier component design and development
  • Provided performance analysis and enhancements in Middle (COM) /Backend (sql server) tiers. (Index analysis, concurrency and contention analysis for deadlocks, locking and isolation levels)
  • Load, stress-testing using automated and in-house tools.
Environment: Visual Basic 6.0, ASP, Interdev, Transact -SQL, ADO, COM, MTS, SQL Server 7/2000
 
COGNILORE INC.
Senior Developer / Architect
Duration: 1 month (08/01 - 08/01)
 
 
  • provided database and system design for content management system using SQL Server 2000, Access 2000, XML and Java for prototype design.
Environment: SQL Server 2000, Transact-SQL, Access 2000, XML, and Java
 
CROSSDRAW TECHNOLOGIES INC.
Lead Developer
Duration: 15 months (07/00 - 09/01)
 
 
  • Provided analysis and design of web applications and enterprise solutions using a multi-tier computer model in SQL Server 7.0/2000, Oracle 8i, Cold Fusion Enterprise 4.5/5.0, JRUN 3.0, JSP, Servlets and EJB
  • Led the design of new solutions and responsible of the redeployment of core products as ASP applications
  • Core modules such as database design, security, administration, reporting, user and group management were completed changed to address ISP/ASP requirements
  • Web load and stress testing using automate tools.
  • Database administration (DBA) for Access, Sql Server and Oracle back ends. Established back/recovery strategies for development/production environments.
Environment: SQL Server 2000, Oracle 8i, Transact-SQL/PL SQL Store procedures, Cold Fusion, JRUN, JSP, Servlets, Access 2000, XML, Java
 
EFTIA OSS SOLUTIONS, LTD.
Prime Data Migration Specialist
Duration: 7 months (01/00 - 07/00)
 
 
  • Established a data migration methodology and best practices for Remedy applications in a multi-tier environment from legacy and version-to-version upgrades in Sybase, Oracle, Informix and SQL Server for NT and Unix environments
  • Software integration and software development in Remedy, Visual Basic, ANSI SQL, Transact-SQL and PL/SQL scripts.
  • Developed data migration utilities for automated data transformation and field mapping for sql server/oracle.
Environment: Remedy, Visual Basic, ANSI SQL, Transact-SQL, PL/SQL scripts for SQL server 7, Oracle7/8i for data migration.
 
TELESAT CANADA
Senior Programmer Analyst
Duration: 10 months (02/99 - 11/99)
 
 
  • Provided software development specializing at migrating legacy systems into client-server computing
  • Responsible for a three-tier computer model implementation using COM, MTS, Visual Basic 5.0, Visual Interdev and MS-SQL server (Inventory and Fixed Asset Application)
  • Provided database design and development, middle-tier design and development, front-end design, coding and optimization
Environment: COM, MTS, Visual Basic 5.0, Visual Interdev, MS-SQL server (Inventory and Fixed Asset Application), Transact-SQL
 
CANADIAN INSTITUTE FOR HEALTH INFORMATION
Senior Programmer Analyst/ Prime DBA
Duration: 23 months (04/97 - 02/99)
 
 
  • Provided software development for projects migrating legacy systems to client Server computing using Visual Basic 5.0 and MS-SQL Server 6.5 (Two tier implementations).
  • Provided Web development using ColdFusion, Active X and HTML.
  • Provided database development, design and optimization using Erwin and Systems Engineering LBMS tools.
  • Database administration for Access and SQL servers (15+ Production servers).
Environment: Visual Basic 5.0, NT 3.5/4.0 MS-SQL Server 6.5, ColdFusion, Active X, HTML, Erwin, Systems Engineering LBMS tools
 
PRIVATE SECTOR
Independent Consultant
Duration: 11 months (06/96 -04/97)
 
 
  • Developed software in client server environments for small/mid-size companies in manufacturing.
  • Provided WebPage design, user support and training in Internet Technology, HTML, FrontPage, and JavaScript.
  • Upgrade end-users software from 16 to 32 bit applications in Visual Basic.
Environment: HTML, FrontPage, JavaScript, and Visual Basic
 
PEMEX REFINERY
MIS
Duration: 34 months (09/93 - 06/96)
 
 
  • Established the IT department and was the technical leader in software development for fully integrated information systems in client server environments for Unix and Windows.
  • Responsible for project control, database design, development and testing.
  • Supervised, upgraded and managed RDBMS systems in UNIX, TCP/IP and Informix.
Environment: Unix, Windows, RDBMS systems in UNIX, TCP/IP, Informix DBA.
 
RECURSOS DE SOFTWARE
Owner/Technical Manager
Duration: 29 months (05/91 - 09/93)
 
 
  • Built strong analytical skills in customer oriented solutions.
  • Responsible for system analysis, system proposals, database design and implementations in client server environments.
  • Provided full life-cycle software development for small/mid-size companies and government departments.
  • In charge of user support and training, hardware maintenance and software implementations.
Environment: Clipper, FoxPro, Dbase, Novell Netware, Lantastic.
 
NATIONAL BANK OF MEXICO BANAMEX
Manager of Statistical Information
Duration: 18 months (12/89 - 05/91)
 
 
  • Acted as project leader in development and implementation of nation-wide information systems regarding the quality and efficiency of services provided by this computer centre.
  • Responsible for planning and implement technical training.
  • Created and edited a local information bulletin and key collaborator of quality committee.
Environment: TANDEM, UNISYS, Clipper, FoxPro, Dbase and Novell Netware.
 
IBM DE MEXICO, ITESM C.S.N.
Tutor/Consultant
Duration: 41 months (08/87 - 12/90)
 
 
  • Responsible for establishing IBM presence at my university's campus with PS/2 proprietary Systems.
  • Responsible for marketing, counseling and user support.
  • Involved with the first online systems implemented in this campus that enabled students access the university's resources from home.
Environment: IBM PS/2
 
Education
 
Master degree in Computer Science, 2nd year in progress
University of Ottawa
Ottawa, Ontario
 
Bachelor's degree in Computer Science
Monterrey Institute of Technology (ITESM, C.S.N.) 1990
 
Professional Development
 
 
  • Attended Microsoft DevCon Conference, Seattle WA, 2002.
  • Systems & Architectures for Electronic Commerce U of O, 2001.
  • Automated Verification and Validation of Software, U of O, 2001.
  • Telco I Fundamentals, Global Link, 2000.
  • Remedy AR User/Admin/Developer, Ottawa, 2000.
  • E-Commerce Technologies, University of Ottawa, 2000.
  • Oracle 8 DBA Course, 2000.
  • Principles of Dist. Computing, University of Carleton, 1999.
  • Usability engineering, University of Ottawa, 1999.
  • Data Mining and Machine Learning, University of Ottawa, 1999.
  • Software Quality Engineering. University of Ottawa, 1998.
  • Implementing Database Design SQL Server 6.5, 1997.
  • Programming with MS Visual Basic 4.0, 1997.
  • Fundamentals of Microsoft Visual Basic 4.0, 1997.
  • Informix SQL, (INFORMIX), 1994.
  • Informix On- Line management (INFORMIX) 1994.
  • Database relational design (INFORMIX), 1994.
  • Basic UNIX management. (UNISYS), 1994.
  • TCP/IP communication protocol (NCR), 1994.
  • LANtastic Seminar-Practice, 1992.
  • Diploma of Management Skills (ITESM), 1992.
  • Seminar of SCO products, 1991.
  • System Manager Course (NOVEL), 1990.
  • Personal systems PS/2 (IBM), 1989.
  • Introduction to Telecommunications systems (IBM), 1988
 
Honours
 
University's scholarship by IBM/ITESM 1990
 
Skills Profile
 
OPERATING SYSTEMS WEB DEVELOPMENT, APPLICATION & HTTP SERVERS
  • Ms-Dos / Windows 95/98Windows NT 4.0
  • Windows 2000
  • Windows XP Pro
  • Novell
  • LANtastic
  • UNIX SCO
  • Windows 2003 (RC1)
  • HTML
  • JavaScript
  • CGI
  • Active X
  • FrontPage
  • ASP
  • JSPServlets, EJBRSA
  • SET/ SSL
  • XML
  • ColdFusion 3.0/4.5/5.0
  • IBM WebSphere
  • JRUN 3.0a and OAS9i
PROGRAMMING LANGUAGES DATABASES ADMINISTRATION /DEVELOPER:
  • Clipper 5.2 /FoxPro
  • Pascal
  • Cobol
  • Visual Basic 5.0/6.0/.Net
  • Java / J2EE
  • Crystal reports
  • Visual Interdev 6.0
  • Remedy 4.x
  • VSS (Aca exp. in Visual C++ 5.0 and J++)
  • COM/ DCOM/ ADO/ ADO.NET/ MTS/
  • UML/Perl
  • Access 95/97/2000
  • Informix
  • SQL Server 6.5/7.0/2000
  • Oracle 8/8i/9i
  • Erwin 3.0/3.5
  • (Knowledge of LBMS systems Engineering tools)
  • ANSI SQL
  • Transact-SQL
  • PL/ SQL
 


Click here to download a resume in pdf format
Click here to download a resume in Word 6.0 format