Raquel Eunice Cruz Perdomo

Toronto, ON, M*S*H* Mobile: 647-***-**** Email: mailto:adg1bs@r.postjobfree.com adg1bs@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/raquel-cruz-perdomo/

Profile Summary

ETL Developer with over 9 years of experience in Information Technology, 6+ years supporting business intelligence solutions, and 3+ years as a datastage developer. Passionate professional with strong data mapping skills and proficiency with SQL. Highly qualified in data visualization tools and data analysis. Proven written/verbal communication skills, and proficiency in English and Spanish.

Technical Strenghts

Business Intelligence

IBM Infosphere DataStage, Cognos Analytics, Cognos 10/11, Cognos Transformer, Cognos Framework, Cognos Report Studio, Active Reports, Cognos Data Manager, Cognos Connection, Query Studio, Microsoft SSIS, SSAS (Tabular & Multidimensional), SSRS, Power BI, Excel Power Pivot, Tableau, Crystal Reports

Databases

Oracle, Microsoft SQL Server, MySQL, Microsoft Access

Development

PL/SQL, T-SQL, Python, C#, LINQ, Razor, VB.NET, SAS, Java, ASP. NET Web Forms, JavaScript, AJAX, HTML, CSS, XML, jQuery, JSON, .Net, ADO.NET, Entity Framework, Telerik, MVC, SOAP and Restful Web Services, WCF, WPF

Concepts

BI, ETL, Data Warehouse, Data Mart, Data Mapping, Big Data, Analytics, Predictive models, Data Mining, Statistics, Data Visualization, OOP, UML, Agile, SCRUM, CRM, ERP, Finance, Insurance, Banking, OLTP, OLAP, Relational databases, Text Mining, Sentiment Analysis, Big Data, Hadoop/Hive

Other Software

SAS Enterprise Miner, Microsoft Team Foundation Server, Visual Studio, IBM Team Concert, IIS, Microsoft Office 365 Power Suite, MS Project, Visio, Salesforce, SharePoint

Professional Experience

Senior ETL Developer

Apr 2014 to Dec 2019

MAPFRE Insurance – Dominican Republic

Responsibilities:

•Design, write, modify, and integrate ETL models using IBM Infosphere DataStage

•Test, debug, and deploy ETL processes

•Design and develop OLAP structures for data warehousing

•Develop complex SQL queries and stored procedures with ORACLE PL/SQL

•Manage and monitor ETL batch jobs, and resolve defect when needed

•Document data schema, data models and ETL solutions

•Confer with clients to identify and document requirements

•Prepare business reports, cubes, and dashboards by collecting, analyzing, and summarizing information

•Support the full project lifecycle of Business Intelligence (BI) projects

•Lead and co-ordinate members of the teams

Achievements:

Data Integration and Support Implementation of CRM Salesforce

Design, creation, and implementation of Clients OLAP Model for reporting and analytic use

Technical Environment: IBM Infosphere DataStage (version 8.7), ORACLE, PL/SQL, MS SQL Server, Cognos 10/11, Cognos Analytics, Cognos Transformer, Cognos Framework, Cognos Report Studio, Active Reports, Cognos Data Manager, Salesforce

ETL Developer

Oct 2013 to Apr 2014

EIS -> Assigned to MAPFRE Insurance – Dominican Republic

Responsibilities:

•Design and develop OLAP structures for data warehousing

•Design, write, modify, and integrate ETL using IBM Cognos Data Manager

•Prepare business reports and cubes by collecting, analyzing, and summarizing information

Technical Environment: ORACLE, PL/SQL, MS SQL Server, Cognos Transformer, Cognos Framework, Cognos Report Studio, Active Reports, Cognos Data Manager, Cognos Connection, Query Studio

Software & BI Developer

Feb 2012 to Oct 2013

Wind Telecom – Dominican Republic

Responsibilities:

•Develop data models and information repository to perform data analysis using Microsoft BI Suite (SSIS, SSAS and SSRS)

•Analyze, design, develop and implement web applications supporting the business of the company

•Deep expertise and hands on experience with Web Applications and programming languages such as C#, ASP .NET, LINQ, RAZOR, Entity Framework, JavaScript, jQuery, SQL Server

Achievements:

Design, creation, and implementation of a full Customer Relationship Manager CRM

Technical Environment: SSIS, SSRS, SSAS, C#, ASP .NET, LINQ, RAZOR, Entity Framework, JavaScript, jQuery, MS SQL Server

Junior Software Developer

Jul 2010 to Feb 2012

CAM Informatica – Dominican Republic

Responsibilities:

•Develop reports using Crystal Report

•Maintain existing computer programs using Visual Basic .NET, SQL Server

•Develop and implement information systems business solutions

Technical Environment: Visual Basic .NET, MS SQL Server, Crystal Reports

Education

Graduate Certificate in Business Analytics

Jan 2020 – Aug 2020

Seneca College – Canada

Master Executive in Industrial and Technological Business Management

Oct 2012 – Oct 2013

Escuela de Organización Industrial (EOI) Spain

Bachelor’s in Computer Science

Aug 2008 – Jan 2012

Technologic Institute of Santo Domingo (INTEC) – Dominican Republic

Training and Courses

The Business Intelligence Analyst Course

Sep 2020

Udemy

SQL, Tips, Tricks and Techniques

Jul 2020

LinkedIn Learning

Creating Interactive Dashboards in Tableau

Apr 2020

LinkedIn Learning

Cognos Analytics Advanced

2019

TDESOL – Dominican Republic

IBM Infosphere DataStage Fundamentals

2019

TDESOL – Dominican Republic

IBM Cognos Data Manager Advanced

2017

TDESOL – Dominican Republic

Business Intelligence Fundamentals

2013

Technologic Institute of Santo Domingo (INTEC) – Dominican Republic

JAVA WEB Application Development

2012

APEC University – Dominican Republic

ORACLE Database Administration and Programming

2011

APEC University – Dominican Republic

Contact this candidate