Carlos Antonio Pérez Aniceto Islas Birth date: February 13th, 1984

Cel: 55-6889-4291

Email: ac40qx@r.postjobfree.com

- 1/3 -

Professional experience

Profile ETL-BI Specialist

With 9 years of experience in ETL&BI Development using InfoSphere DataStage and Cognos. Across this time, I have participated on the different phases of the systems development life cycle.

I have the ability to make a complete ETL system, from analysis to development and the implementation in a productive environment.

I can make ETL/BI project estimations and manage the project plan using Microsoft Project Plan working with the end-users on the business requirements and I can fulfil a leadership position by managing and leading the development team. On my experience, as Technical Leader I’ve had the responsibility of leading the project plan and report the status, issues and risks and take the necessary actions to solve the problems.

My principal role in the last project was Subject Matter Expert (SME) on a DWH migration project but I had to participate on some other activities like analysis, design, development. I have the vision to give all my potential on the company where I work and keep increasing my knowledge with all the new technologies and methodologies to get the success of the company.

Career History 04/2013-08/2017

IBM

IT Specialist

11/2009 – 04/2013

Hildebrando

Systems Development Specialist

07/2009 - 11/2009

PCS de México

ETL Analyst & Developer

04/2008 - 07/2009

SIS Organización

ETL Engineer Systems

03/2008 – 04/2008

Instituto Politécnico Nacional

Java Developer

Carlos Antonio Pérez Aniceto Islas Birth date: February 13th, 1984 Cel: 55-6889-4291

Email: ac40qx@r.postjobfree.com

- 2/3 -

Assignment History IBM

11/2009 – 08/2017

● ETL Infosphere DataStage& BI Cognos: Technical Leader & Developer on DWH migration project. Project planning. Make project estimations of each development phases and lead the team assigned to each phase. Ensure to finish each phase on the proposal date given. Join the project status meetings. Make analysis, design and development of ETL applications, including shell and SQL scripts. We are migrating Datastage server and parallel jobs from version 7.5 to 8.7. Migration of Cognos Reports and Cubes from version 8 to 10. Currently the client has a DWH based on Oracle and Informix DBMS so then we are making the necessary adjustments to SQL Scripts from Oracle and Informix to zDB2. We are applying the necessary test cases to ensure that the data it’s the same than the client has currently on their DWH. We are analyzing the applications and then making improvements to give better performance and more value to the business. Designing database ODS for the different business areas in DB2 DBMS. At the beginning, we work with the client to define the migration process and set all the documents to deliver on each migration, we work together to create the methodology for all steps to put each application on a production environment.

● Subject Matter Expert (SME-IBM). Make project estimations based on business requirements from BI area. Analyze the applications based on DataStage or Cognos software and when I get a give a possible solution for the project, number of resources, time estimated, project cost, etc. Have a frequently relationship with BI leaders on MetLife IT area to sell projects and make proposals. I participated as Technical Leader too. PCS - IXE Banco

07/2009 - 11/2009

● Development ETL Systems using Infosphere DataStage, creation of routines, server and sequence jobs. Analyze data according business requirements, make transformations and then load in database tables and send an email with the notifications of the process.

Monitoring ETL production process. Fix the production problems by SQL Queries and Resetting DataStage jobs

SIS de México - PepsiCo Int.

04/2008 - 07/2009

● Development ETL Systems using Infosphere DataStage, creation of routines, server and sequence jobs. Analyze data according business requirements, make transformations and then load in database tables and send an email with the notifications of the process.

● Proof of Concept with Casa Saba. Implement an ETL system with DataStage 7.5 and DB2. Massive upload information.

● Technical support in Grupo Modelo with ETL production environments. Carlos Antonio Pérez Aniceto Islas Birth date: February 13th, 1984 Cel: 55-6889-4291

Email: ac40qx@r.postjobfree.com

- 3/3 -

Instituto Politécnico Nacional - SIGUE

03/2008

● Development of scholar control system using java applications. This system could manage the information such as score, assignations, courses etc. of students and teachers.

Key Skills Industries: Business Intelligence

Operating Systems: Windows XP, Linux, Windows NT

Languages: Java (basic), c++, html.

RDBMS: Oracle, SQL server, MySql, DB2, Informix.

Other Utilities: Microsoft Office, Project, Visio. Applications: Infosphere DataStage (Version 7.5 and 8.7), Cognos Report Studio, Framework Manager, Transformer

(Version 8 and 10)

Key Courses and

Training

DataStage 7.5, 8.1 – 2008-2009

Cognos 8 BI -2010

Technical Leader - 2015

Important DataStage Readings:

● DataStage Data Flow and Job Design

● InfoSphere DataStage Parallel Framework Standard Practices

● Information Server Installation and Configuration Guide Database Readings:

● Oracle to DB2 Conversion Guide_ Compatibility Made Easy,

● Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows, Dynamic Warehousing_ Data Mining Made Easy

● DB2 Deployment Guide

● Data Modeling Techniques for Data Warehousing

Education

Qualifications IT degree (5905125)

Universidad Tecnológica de México (UNITEC) - 2007

Languages English Fluent

Spanish Native

Contact this candidate