Resume

Manager Developer

Location:

Paterson, NJ

Posted:

June 28, 2018

Contact this candidate

Resume:

Guillermo B. De Jesus Castillo

Business Intelligence Developer

*** ******* ******, ********, *** Jersey,07524

ac519r@r.postjobfree.com

BOD:5/11/1973

http://www.linkedin.com/in/guillermobenjamin/

Mobile: 973-***-****

Skype:guillermodejesuscastillo

OBJETIVE

Joining the staff of Business Intelligence Developers to contribute to the continuing improvement of decision-making processes, providing products that meet the expectations of customers, whether internal or external. SUMMARY

Business Intelligence professional with extensive experience in matters of information technology, with a wide and varied experience of business intelligence that allows me to proactively respond the most complex and challenging problems. My experience includes full life cycle development of an implementation of a data warehouse, identification of sources, proper selection of tools for loading, development of all implementations, loading and transformation, the entire documentation process and the responsibility to provide the necessary training to empower internal customers with new implementations.

IBM technology

Cognos Impromptu, Cognos Query Studio, Transformer PowerPlay, Report Studio, Analysis Studio, Frame Work Manager.

Sap Technology

SAP Crystal Report, Web Intelligence, Desktop Intelligence,SAP Explorer, SAP Voyager, Information Desiger Tools.

Microsoft Technologies:

SQL Server 2005 Integration Services (SSIS), Sap Data Service, SQL Server 2005 Analysis Services

(SSAS), SQL Server 2005,Excel, Access, Word, PowerPoint, Experience in the use of Program Manager for the scheduling of tasks, implementation of control cubes and ETL

Databases:

MS SQL Server 2005/2008/2012, Oracle, Access, DB2 V10 1

WORK EXPERIENCE

Santander Bank, PR (September 2016 – Present)

Project: Oracle

Role: Data Quality Analyst

Type Full Time.

Location San Juan, Puerto Rico

First Medical Health Plan (July 2015 – September 2016) Project: Sap Business Object 4.1

Role: BI Senior Developer

Environment: SAP BO 4.x

SQL Server/Oracle/Informix

Type Full Time.

Location Guaybabo, Puerto Rico

FirstMedical Health Plan

Administrations SAP BO Platform.

Modeling IDT tools

Reporting with WEBI and Crystal Report

SSIS 2012 and SAP Data Services 4.0

Policia de Puerto Rico, Cuartel General (November 2014-Marzo 2015) Orsyspr.com/Consulting2Success Project: IBM Cognos 8.4.x Project

Role: BI Developer

Environment: IBM OZ/DB2

Upgrade and improvement projects Criminal Monitoring. Type Contract

Location San Juan, Puerto Rico

Policia de Puerto Rico (Police of Puerto Rico.).

Revision of all models Framework

Improvements response times of the reports and queries objects. 2

Development Reports in Report Studio

Banco De Reservas de la Republica Dominicana/Seguros Banreservas (March 2014 –August 2014) Project: IBM Cognos 10.x Project

Role: BI Developer

Environment: Windows Server

Support for this project was conducted through VPN connection from the US to the Dominican Republic. Type Contract

Location Paterson, NJ (Remote Suport)

The largest bank in the Dominican Republic, with branches across the country, with assets of over 5 Billion Dollars.

Dashboard Development with Report Studio/Analysis Studio

Improvements to the Framework Manager packages

Development Reports Report Studio

Orange Dominicana (Telecommunication) (April 2014 –August 2014) Project: IBM Cognos 10.x Project

Role: BI Developer

Environment: Windows Server

Support for this project was conducted through VPN connection from the US to the Dominican Republic. Type Contract

Location Paterson, NJ (Remote Suport)

Orange Dominicana is the largest mobile communications operator in the Dominican Republic with more than 3 million subscribers.

Development of a long list of reports in Report Studio 10.2

3.x BO Migration Reporting to Cognos 10.2

Banco De Reservas de la Republica Dominicana (April 2013 – February 2014) Project: IBM Cognos 10.x Project

Role: BI Developer/Technical Leader

Environment: Windows Server

Type Full Time

Location Santo Domingo, Dominican Republic

The largest bank in the Dominican Republic, with branches across the country, with assets of over 5 Billion Dollars.

Responsibilities:

Technical and Functional Leader for the implementation of BI in the Reserve Bank of the Dominican Republic.

Changes and Enhancements to SQL and ETL Objects found..

Technical Leader ETL development and the implementation of IBM Cognos Project

Directly responsible for model development : loans, Credits card and savings account both the ETL as cubes and reports with Cognos Datamanager.

directly responsible for the modeling of metadata with FrameWork Manager

Development of Model Metrics(Performance Balance) and KPI

Development of Sophisticated reporting and Dashboard in Report Studio.

Allocation and development of security profiles

Sued Pharmaceutical (May 2012 – August 2012)

Project: BI Sued

Role: BI Developer

Environment: Sap BO 4.x

Type Full Time

Location Santo Domingo, Dominican Republic

Pharmaceutical Sued is an important laboratory in Dominican Republic that is dedicated to the production and distribution of drugs.

Responsibilities:

Creation of ETL for Models of Warehouse, Sales, Purchases through SSIS

Development of Universes with Information Designer Tools.

Development Reports

Development of Balance Score Card.

Agrifeed (June 2012 to July 2012)

Project: Business Intelligence

Role: BI Developer.

Environment: Sap BO 4.x/Windos Server 2000

Type Full Time

Location Santo Domingo, Dominican Republic

Industry dedicated to the production of food for the poultry and Livestock industry. Responsibilities:

Development SSIS with Etl tool models and included Finance, Sales, stock and purchase.

Development of Universes.

Development Reports.

Development of Balance Score Card.

BI Santo Domingo Motors (May 2012 – November 2012) Project: BI Santo Domingo Motors.

Role: BI Developer

Environment: Sap BO 4.x

Type Full Time

Location Santo Domingo, Dominican Republic

Santo Domingo Motors is the largest car dealer in the Dominican Republic and is the representative of GM in the Caribbean area.

Responsibilities:

Development of ETL in Data Integrator SAP 4.x Models were developed Sales and Warehouse.

Development in Xcelsius Dashboard

Development of Mobile Sap BI 4.0

Development Information Universe Designer Tools. ESPALSA (March 2011 to July 2011)

Project: BI Espalsa.

Role: BI Developer.

Environment: Sap BO 4.x

Type Full Time

Location Santo Domingo, Dominican Republic

Company dedicated to the production of food for human consumption. Responsibilities:

Development in Xcelsius Dashboard

Development of Mobile Sap BI 4.0

Development Information Universe Designer Tools.

Implementation and development of the ETL in SSIS and include models for Finance, Sales, Purchasing. EDESUR (January 2010 to October 2010)

Project: BI Edesur.

Role: Business Intelligence Consultant

Environment: IBM Cognos 8.0

Type Full Time

Location Santo Domingo, Dominican Republic

Company dedicated to the production and distribution of power in the Dominican Republic.. Responsibilities:

Changes and Enhancements to SQL and ETL Objects found..

Compilation of immediate mdc Cognos cubes once finished the execution of your ETL process.

directly responsible for the modeling of metadata with FrameWork Manager

Development of Model Metrics(Performance Balance) and KPI

Development of Sophisticated reporting and Dashboard in Report Studio.

Allocation and development of security profiles

ARS PALIC SALUD (February 2009 to January 2010)

Project BI Ars Palic

Role: Business Intelligence Consultant

Environment: IBM Cognos 8.0

Type Full Time

Location Santo Domingo, Dominican Republic

Health Risk Management.

Responsibilities:

Changes and Enhancements to SQL and ETL Objects found..

Compilation of immediate mdc Cognos cubes once finished the execution of your ETL process.

directly responsible for the modeling of metadata with FrameWork Manager

Development of Model Metrics(Performance Balance) and KPI

Development of Sophisticated reporting and Dashboard in Report Studio.

Allocation and development of security profiles

Telefonica Viva (Telecommunication) (August 2008 - February 2009 ) Role: BI Developer.

Role: Business Intelligence Consultant

Environment: IBM Cognos 8.0

Type Full Time

Location Santo Domingo, Dominican Republic

Responsibilities:

Reports and Dashboard Development

Building Cubes MDC

Metadata Development and packages with FrameWork Manager 6

BI Banco Central (January 2008 to August 2008)

Role: BI Developer.

Role: Business Intelligence Consultant

Environment: IBM Cognos 8.0

Type Full Time

Location Santo Domingo, Dominican Republic

Central Bank of the Dominican Republic, Regulatory Body of monetary policy. Responsibilities:

Reports and Dashboard Development

Building Cubes MDC

Metadata Development and packages with FrameWork Manager EDUCATION

Bachelor Degree, Computer Science. Apec University, Santo Domingo, Dominican Republic Bachelor Degree certified by World Education Services (WES).-https://www.wes.org Reference Number: 2620973

LANGUAGES

Spanish: Native or bilingual proficiency

English: Full professional proficiency

Reference

Ana Rita Perez Jimenez, PMP

Project Manager

GBM Dominicana, S.A. an IBM Alliance Company

Phone 809-***-**** ext 8281 Fax. 809-***-****

Cel. 809-***-**** / 829-***-****

Email: ac519r@r.postjobfree.com

Miguel E. Yeara

Cel 905-***-****