IT professional whose passion is create and develop successful solutions to complex problems. I'm a senior systems analyst and developer with experience in many technologies, platforms and programming languages. Every design and implementation created is aligned to current strategy and policies established by the company. This ensures that any goal is supporting business objectives. I try to be up to date and implement with best Industry and IT practices:

  • Cobit, Control Objectives for Information and related Technology (ISACA).
  • ITIL, Information Technology Infrastructure Library (OGC).
  • PSP, Personal Software Process, TSP Team Software Process, CMMI Capability Maturity Model Integration (SEI - Carnegie Mellon University).
  • Octave, Operationally Critical Threat, Asset, and Vulnerability Evaluation (SEI - Carnegie Mellon University).
  • Project management. Proficient in processes, phases and documentation proposed by PMI, Prince2 (APMG) & IPMA.

Using my personal skills. I've been able to:

  • Integrate and coordinate teams, making of every day a hard effort towards goal achievement. Where Infrastructure and Systems Development teams work together following the same goals.
  • Develop talent within IT dept., by supporting my coworkers on continuous development on their jobs and personal education.
  • Achieve goals; motivating teams on fulfill their promises and challenging status quo.
  • Pioneering, researching on new ways to do things and the functionality of systems and technology. Giving advice to enhance current processes.


  • Information Systems Management.
  • SLC (Systems Life Cycle); Research and development; Systems analysis and design.
  • Compliance (Strategies,regulatory, policies, laws).
  • Information Security (Integrity and recovery); Risk analysis and management.
  • Disaster Recovery Planning (DRP);

Work History

Work History
Jan 2008 - Present

Business Intelligence & Data Management Consultant

Gerencia y Sistemas

Current Job Description & functions include consulting services to GYSSA clients on Data warehousing and Business Intelligence processes. Achievements:

  • Cross Selling & Up Selling Solution, developed for a top 3 bank in Guatemala. Easy to use Data mining solution.
  • Inventory KPI's Analysis Solution, includes a extraction from 2 sources, transformation processes to generate analysis information, dashboards and reports to display analysis information.
  • Production KPI's & Reporting Solution, extracts information from ERP, transforms information to create production (PXO) analysis information, dashboards and reports.
Feb 2006 - Jan 2008

Senior Systems Analyst

Abbott Laboratorios
Job Description & functions include consolidation of current information systems and innovate them by using new technologies and procedures. Design and implement decision-making processes/systems and workflows to enhance current internal procedures. Coordinate 2 junior developers on their job and professional development. Project management and support IT manager and HQ at work. Train users on systems technologies and suggest new technologies and procedures. Achievements: - CACM-P Intranet Site, develop intranet site using Joomla CMS, according to current corporate branding and security guides. - STM ­ Sales To Market Cube, a multidimensional cube were created to do FOB Sales analysis. This includes Datawarehouse creation and all ETL processes needed. - SIF - Sistema de Información Financiera (Financial Information System), Cube implementation to do financial analysis (Expenses, P&L, Balance Sheet, Financial indexes). This project includes multidimensional cube, Datawarehouse y ETL. - CSR - Consolidated Sales Reporting, system analysis and development to consolidate sales information (units sold, net sales, discounts, costs and samples). It's used to report daily information and month end information too. - XRS - Expenses Report System, develop 2 . Version of system. Workflow to control and get expenses authorization and approval.
Feb 2001 - Feb 2006

Senior Systems Analyst

Novartis Farmacéutica
My job description included developing information systems for decision taking and workflow systems. Coordinate a junior analyst on his activities and personal development. Project Management using Crystal Methodology Framework (Novartis own PM methodology) and support IT manager on his duties. Train personnel on the applications usage and suggest new technologies and procedures Achievements: - Intranet implementation before corporate CMS standard implementation. Some web applications were developed as well. - Design, development and implementation of a new drug regulatory affairs system for CAC (Web Application). - Sales Cube, administration, new cube development and data migration. This cube includes FOB sales (to market) and local sales (in market). From Cognos to Hyperion Suite (Web Portal). - Expenses Cube, administration, new cube development and data migration. This cube was loaded from expenses transactions from ERP. From Cognos to Hyperion Suite (Web Portal). - Territorial Sales. Design, develop and implementation of a system to do analysis regarding territorial sales (how products are sold inside a country by region and customer). It includes ETL, management system and cube. - Incentives payment system, this system was developed for specialty products sales department for incentives calculation and payment. - MEGA System implementation, Workflow system using Lotus Notes/Domino C/S platform for expenses approval and control (includes employee expenses, money in advance, purchase orders, payments transactions). - Approval System implementation, workflow system using Lotus Notes/Domino Web platform for expenses approval. - Country Portfolio system. This information system was used to compare different KPI's between CAC Countries. Using this system it was possible to monitor the performance of countries.
Jul 1998 - Feb 2001

Infrastructure Manager

Novartis Farmaceutica
My main responsibility was to ensure local infrastructure (LAN, WAN, Services) work stable and to enhance it by establishing new services. I had a 4 people team 2 in Guatemala and 2 in Dominican Republic. Achievements: - Local services stabled in less than 3 months. - Expanded LAN at building, implementing a new network infrastructure. - Incorporated a new Novartis division (Animal Health) to Pharma's network. - Help Desk system development. It was implemented in Guatemala; Mexico. - PC's & servers migration to GEM (2000) and Engine (2003) platforms. - Enhancements on servers and services.
Dec 1997 - Jul 1998

Systems Analyst

Embocen (Coca Cola Bottler)
My main duties were systems analysis and development for office automation processes. Achievements: - Help Desk system development and implementation for Guatemala, Costa Rica and Nicaragua operations. - Lotus Notes Infrastructure management for Central America operations.
1992 - 1995




2000 - 2010


Atlantic International University




MS SQL Server. Sybase ASE. IBM DB 2. Lotus Notes. Oracle DB. PostgreSQL. MySQL. Java DB.