FERNANDO YURI REYES
Tucson, AZ 85757
520-***-**** *****.***.***@*****.***
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)