FERNANDO YURI REYES

**** * ****** ******

Tucson, AZ 85757

520-***-**** ac4ghr@r.postjobfree.com

Objective

A motivated, team player with a love for anything data.

Skills

Tools: Informatica, Jupyter Notebook, GitHub

Databases: Teradata, MS SQL Server

Languages: SQL, Javascript, jQuery, AngularJS, Ruby, Python

Operating Systems: Windows XP/Vista/7/10, Linux

Big Data Tools: Hadoop, Cloudera Manager, Map Reduce 2.0, Spark, Hive, Sqoop, Oozie, Kudu, Impala

Experience

ETL Developer

HotFix2

2017 - Present

Work in support of migration from Teradata to Hadoop(Cloudera)/SQL Server for trucking transportation client

Converted TeraData BTEQ scripts to MS SQL Server TSQL Scripts

Involved in optimizing performance using clustered/non-clustered indexes on tables

Created multiple database objects such as stored procedures, indexes, functions, and views

Improved the performance of SQL scripts, procedures, and functions

Created Informatica mappings and workflows using various Informatica designer transformations like Source Qualifier, Dynamic and Static Lookups, connected and Unconnected lookups, Expression, Filter, Router, Joiner and Update Strategy transformation

Work on Performance Tuning Informatica jobs, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions

Comprehensive experience of working with Type1, Type2 methodologies for Slowly Changing Dimensions (SCD) management

Worked with team to develop Python applications

Experience in working with Python packages like Numpy, Pandas, Matplotlib, Scipy

Experience in importing and exporting data from the different data sources like (Teradata and DB2) using Sqoop from HDFS to Relational Database Systems (RDBMS) and vice-versa to load into partitioned Hive tables

Hands on installation and configuration of Multi node Hadoop cluster

Experience with Hadoop, Map Reduce, Spark, Kudu, Sqoop, Oozie, Hive and Impala

Education

Dataquest.io Mar 2018

Data Science

Programming in Python and R

Clean and visualize data

Make predictions using statistics and machine learning

Collaboration tools like git and SQL databases

Full Stack Web Developer Dec 2016

Bloc, Inc.

Relational and nonrelational databases

How to interact with APIs and the external world

User interface and user experience

Quality assurance

Security concerns throughout the program

Understanding customer and business needs

Bachelor of Liberal Arts: Japanese

Arizona State University

Language Skills

Spanish, Japanese - Fluent

Portuguese, Russian - Conversational

Security Clearance - Secret (Inactive)

Contact this candidate