Fernando Terrazas

t556ld@r.postjobfree.com

t556ld@r.postjobfree.com

t556ld@r.postjobfree.com

Home: (591-*-***-****

Cellular: (591-***-*****

*** ********** **.

Cochabamba, Bolivia

PROFILE

Highly proficient IT professional with over, 5 years as Data Warehouse Business Intelligence Consultant

7 years of work experience as Software Developer & Business Analyst

Oracle PL/SQL developer Certified Associate.

PERSONAL SKILLS

Able to work as a team member and contribute to development, design, administration, production, support, testing and marketing of systems, new products and services.

Leader, venturesome and entrepreneur

Ability to manage work teams and interact with different sorts of people.

Efficient, reliable and self-motivated.

Well organized and hard working individual.

Problem solver with excellent skills to find alternative solutions whenever needed.

MAIN ROLES PERFORMED

Project Manager & Team Leader responsible of Application Development for client-server and multi-tier environments, specialist in Strategic Management Systems and applications of Balanced Scored Card methodology.

Project Leader, Analyst, Designer & Developer of Data Warehouses and Business Intelligence Systems, involved in logical and physical system design, transformations, ETL with Oracle PL/SQL, Data Stage and DTS, applications development and Administration with Microstrategy and Business Objects XI in Telecommunications and Banking business areas.

Developer Analyst involved in design, modeling and development of databases for Oracle, MS SQL Server, Postgres and MySQL platforms; performing analysis, modeling (object oriented and structured), database creation, SQL statements tuning, backup & recovery, general troubleshooting, scripting

Java Developer, 5 years working specially with JDeveloper as IDE, developing Web applications and stand alone programs. Technologies used Swing, J2EE, BC4J, ADF, JSTL, JSP, JDeveloper 9i/10g.

TECHNICAL EXPERTISE

MAIN AREAS

• 5 Years Business Intelligent Specialist

• Relational and star schema data modeling

• Logical and physical relational database design

• 3 years as team & project leader with outstanding technical lead experience

• Formal object-oriented analysis and design

• 5 years experience as Java Developer working specially with Oracle JDeveloper 9i/10g IDE

DATABASES

• Oracle® 9i, 10g, 11g Oracle PL/SQL, Oracle SQL*Plus

• Microsoft SQL Server 2000 / 2005

• Postgres 7 and MySQL 4.1

• DB2 9.7 Data Federation.

BI TOOLS

• 4 Years Business Intelligence - Microstrategy 7.1, 8.0 (Architect Desktop, NarrowCast, Object Manager)

• Business Intelligence - Business Object XI R2 and R3, Designer, Dashboard Manager, XCelsius

• Business Objects Administration XIR2 /XIR3 /Business Objects Universe , Webi, Xcelsius 4.5 and 2008 developer

• OLTP Report tool Crystal Reports 2008.

ETL TOOLS

• ETL - Data Stage IBM v8.0

• Microsoft Data Transformation Services (DTS)

• Stored Procedures, Triggers and PL/SQL Packages

• 24x7 Scheduler Software (Automation process)

DEVELOPMENT TOOLS

• Oracle JDeveloper 9i/10g, Java – Swing, J2EE, BC4J, ADF, JSTL, JSP, Struts

• C++, C Standard, Borland

• PHP, Perl, HTML, CSS, XML,

• Dream Weaver 8.0, Macromedia Cold Fusion

• Quest TOAD, Quest SQL Navigator

DESIGN TOOLS

• Embarcadero, ER Studio, Erwin, Power Designer, Microsoft Visio

• OMT / UML Modeling - Rational Rose

OPERATING SYSTEMS

• UNIX, LINUX (Red hat) Korn, Bourne, C shell scripts, Unix Scripting

• Windows NT/2K/XP/2003 Server

ANALYTICS SYSTEMS

• SPSS

• SAS System

• R plus

WORK EXPERIENCE

Sept 06 – Present NUEVATEL PCS - TELECOMMUNICATIONS COMPANY - COCHABAMBA, BOLIVIA.

Role: Project Manager and Data Warehouse Specialist - IT Department

• Analysis, design and development of Datamarts, Cube Reports, Dashboards for Customer care, Financials, Marketing, Trades and Operations.

• ETL tuning and automation with PLSQL, Data Stage. Jobs and scripts scheduling with 24x7 scheduler software.

• Analysis, design & implementation of a complete Business Intelligence Datawarehousing application for the core business of the company using Business Objects, ETL Data Stage IBM, and SPSS data mining

• Creation of business requirements specification

• Creation of process & work specification for each project phase

• Definition of the tool selection process (definition and criteria) for Business Intelligence development

Professor of Business Objects XIR2, XIR3 / Designer/Webi Intelligence/ Xcelsius.

• DB2 Federation project.

• Transactional reports construction with Macromedia Cold fusion and Java , Crystal Reports2008.

Aug 06 - Preset CATHOLIC UNIVERSITY(UCB) - COCHABAMBA, BOLIVIA.

Role: Professor of Decision Support Systems.

Data Warehouse, Business Intelligence

Professor of PLSQL / Designer/ Admin Oracle

Aug 06 – Aug 06 ENTEL – TELECOMMUNICATIONS COMPANY – LA PAZ, BOLIVIA

Role: Development Consultant at Intersoft SA - Data Warehouse Business

Intelligence Project

• Analysis, design & implementation of Management Dashboards, Cube Reports. CHURN, MOU, ARPU, TRAFIC, REVENUE with Microstrategy BI Tool (Architect Desktop, Narrowcast, Report Services, XSL).

• Creation of business requirements specification

• Development of the project prototype

May 06 – Aug 06 BCP – BANCO DE CRÉDITO DEL PERÚ - FINANCIAL AND BANKING COMPANY, COCHABAMBA, BOLIVIA

Role: Development Consultant for Intersoft SA - Data Warehouse Business Intelligence Project

• Analysis, design, development and implementation of an Information Management System – Data Warehouse application (Bank Segmentation).

• Development of physical model with DTS SQL Server 2000 (ETL).

• Development of dimensional reports for accounts payable/receivable and withdraw/deposit transactions from customers with Micro Strategy Architect Desktop software.

• Migration of the physical model (metadata, objects, reports, etc ) from version 6.2 to 7.1 with Object Manager Tool

May 06 – Jul 06 SIN – BOLIVIA TAXES AND REVENUE GOVERNMENTAL SERVICE, LA PAZ – BOLIVIA

Role: Data Warehouse Consultant for Intersoft SA - Data Warehouse Business Intelligence Project

• Development of the project prototype for a Customer Datamart with Microstrategy Architect Desktop.

• Integration with Analysis Server (SQL Server2005).

• Development of Dimensional reports for Customer Business Area.

• Demonstration of Narrow Cast software as Alert Monitor

• Development of Management Dashboards

Feb 06 – Apr 06 FNDR – BOLIVIA’S GOVERNMENTAL NATIONAL FUND ORGANIZATION, LA PAZ – BOLIVIA

Role: Project Leader and Architect for Balanced Scorecard System - (Senior Java Developer)

• Analysis, design of a Web Information Management System. Using JDeveloper (ADF, JSTL, JSP) and Oracle PL/SQL

• Development of physical and logical model

• Development of user interfaces

• Creation of requirements specification

Jan05 – Jan 06 FPS – BOLIVIA’S GOVERNMENTAL NATIONAL PRODUCTIVITY FUND ORGANIZATION, LA PAZ – BOLIVIA

Role: Project Leader for the development of a Balanced Scorecard System- Controlling (Senior Java)

• Analysis, design, development and implementation of a Web Information Management System. Using JDeveloper (ADF, JSTL, JSP) and Oracle PL/SQL

Jan 04 – Dec 04 FUNDES CONSULTANT AND MANAGEMENT SUPPORT FOR MYPES, COCHABAMBA – BOLIVIA

Role: Consultant, Architect and Java Developer.

• Development of System Management Strategies and Balanced Scored Card client- server (metrics control).

• Development of Multi environment and Multi Data base with Java, using IDE JDeveloper and Oracle, Postgres and MySQL databases using JDBC Connection, Swing and Java 2D Graphics Technology.

• Reporting with JFree Report. Graphics with JFree Chart.

Aug 03 – Nov 03 CBA – AMERICAN BOLIVIAN CENTER, COCHABAMBA – BOLIVIA

Role: IT Analyst Consultant

• Winnebago Library Administration System, installation, implementation and configuration

• Staff training

• Installation and configuration of Apache Linux Server (MySQL, PHP, PERL)

Sept 02 – Mar 03 DAI - (DEVELOPMENT ALTERNATIVES INCORPORATED) USAID BOLIVIA, CODELCA (FIELD CONSULTANT)

Role: Database and System Administrator

• Design and implementation of a relational database for the System UNABANA.

• Database Administration for ORACLE, MS SQLSERVER and MS ACCESS platforms

• Bananxas System Auditory (Auditing of Properties ASP, VBASIC). Program and Website Design

• Network Administrator.

• Design, analysis and development of the prototype for System Scored Card application for management and marketing of supply and demand

Jul 02 – Sept 02 UNIVERSITY MAYOR DE SAN SIMON (UMSS) – SYSTEMS AND COMPUTER SCIENCE LABORATORY, COCHABAMBA, BOLIVIA

Role: Fellow Researcher in CIDAI (Position obtained after a public proficiency examination)

• Development of E-Learning System’s using PHP and Postgres Database in a Linux environment. Investigation of new technologies and network programming related to the area.

• Management and evaluation of Macromedia development tools

Ago 01 – Ago 02 UNIVERSITY MAYOR DE SAN SIMON (UMSS) – SYSTEMS AND COMPUTER SCIENCE LABORATORY, COCHABAMBA, BOLIVIA

Role: Technical support assistant (Position obtained after public proficiency examination)

• Hardware support (preventive and corrective) for PCs, monitors and printers.

• Software support (preventive and corrective).

• Network configuration: structured wiring and installation

• Assembly of PC computers for the university laboratory

• Training on PC assembly, hardware and system configuration

Jan 00 – Ago 00 UNIVERSITY MAYOR DE SAN SIMON (UMSS) – SYSTEMS AND COMPUTER SCIENCE LABORATORY, COCHABAMBA, BOLIVIA

Role: Assistant IT Support, Laboratory Analyst and Teaching Assistant

• Preventive and corrective systems maintenance

• Solving networks problems

• Support of students in programming languages, C++ and Java.

• Practical workshops development.

Ago 99 – Dec 99 INELBO – ELECTRIC AND TELECOMMUNICATIONS ENGINEERING,

Role: Assistant IT Support, Laboratory Analyst and Technical IT Support in computers

• PC hardware support (preventive and corrective)

• Networking and printers support (technical assistance)

• Software support (preventive and corrective).

• Network configuration, installation and structured wiring

• Assembly of PC computers for the laboratory

EDUCATION, TRAINING & CERTIFICATIONS

Main

Master Degree in Applied Statistic at University Mayor de San Simon (UMSS) - Cochabamba, Bolivia 2008 - 2010 (currently working in thesis) Text Mining.

Post Graduate Degree in Higher Education at Bolivian Catholic University (UCB), Cochabamba, Bolivia, 2007

Bachelor of Science in Systems Engineering at University Mayor de San Simon (UMSS). Cochabamba, Bolivia, 2002. Thesis with Honors

Oracle SQL Certified - Oracle Testing ID: OC0853678 1Z0-007 Introduction to Oracle 9i: SQL Score: 90%

Oracle PL/SQL Certified - Oracle Testing ID: OC0853678 1Z0-007 Programming with PL/SQL Oracle Score: 89%

Courses

Data warehouse Oracle 11g Advance Techniques, Tuning at Nuevatel PCS VIVA –2010 – Techne Oracle University.

Certification ISO 20000 - Service Management at Ibnorca Cochabamba, Bolivia, 2010.

Data Federation at Nuevatel PCS VIVA Cochabamba, Bolivia2010

Business Objects XIR3.1 Advance course / XIR3.1 new Features - Business Objects Argentina, Cochabamba, Bolivia2010

Crystal Reports2008 at Nuevatel PCS VIVA – Business Objects Argentina, Cochabamba, Bolivia, 2009.

Agile Development SCRUM at JalaSoft Foundation – Cochabamba, Bolivia. 2009.

Sampling Distribution Statistics at San Simon University (UMSS) – Cochabamba, Bolivia. 2008

Sampling Distribution Statistics at San Simon University (UMSS) – Cochabamba, Bolivia. 2008

Linear Algebra for Statistics at San Simon University (UMSS) – Cochabamba, Bolivia. 2008

Business Objects (BO) - Business Intelligence software (Business Object XI R2, Designer, Dashboard Manager, and XCelsius) at Nuevatel PCS VIVA – Business Objects Argentina, Cochabamba, Bolivia, 2007.

E-Commerce Fundamentals & Best Practices at Bolivian Private University – Cochabamba, Bolivia, 2007.

Microstrategy, Business Intelligence (Architect Desktop, Narrowcast, Object Manager) at Intersoft – Microstrategy Argentina, La Paz , Bolivia, 2006

Oracle PL/SQL at Intersoft SA – Cochabamba, Bolivia, 2006

Java ADF, JSTL, Oracle JDeveloper at Intersoft SA – Cochabamba, Bolivia, 2006

New Information Technologies & Telecommunications Services at the Bolivian Engineers Society (S.I.B) – Cochabamba, Bolivia, 2002.

Structured Wiring - Data and Voice Implementation (TIA/EIA -568-569-606) at SISTECO Company (Systems Telecommunications) – Cochabamba, Bolivia, 2001

LINUX Operating System and Network Configuration at San Simon University (UMSS) – Cochabamba, Bolivia. 2000

Windows NT Operating System and Network Configura1tion at San Simon University (UMSS) – Cochabamba, Bolivia. 2000

Linux Configuration Services (Samba, Send Mail, Myself, Postgress, PHP) at University Mayor de San Simon (UMSS) – Cochabamba, Bolivia 2000

PC Technical Support at San Simon University (UMSS) – Cochabamba, Bolivia. 2000

PC Hardware & Electronics (CPU, motherboards, monitors, CDROM, power source) at University Mayor de San Simon (UMSS) – Cochabamba, Bolivia, 2002

Other Courses

Intensive English & Advanced Grammar at American Bolivian Center – Cochabamba, Bolivia 2004

Introduction to Junior Philosophy at Worldwide Federation of Young Leaders and Entrepreneurs Junior Chamber International (JCI) – Cochabamba, Bolivia 2003

Contact this candidate