About
My one-page resume.
Jaime MontoyaCondominio Los Castaños, apartamento 36, Colonia Escalón, San Salvador, El Salvador.
SUMMARY
Data analyst specialist in ETL development.
TECHNICAL SKILLS
- Languages: Scala, Java, PHP, Python, Visual Basic for Applications.
- Databases: SQL, SQL Server, Oracle, MySQL, PostgreSQL, SQLite, MongoDB.
- Other: Git, SSIS, Apache Spark, GCS, BigQuery, Azure, Apache Airflow, Tableau, Power BI, HTML, CSS, JavaScript.
EXPERIENCE
TEAM International Services Inc., Remote
Data Analyst, August 2022 - Present
- Performed data cleaning tasks using Fuzzy Lookup and Fuzzy Grouping transformations.
- Integrated ETL processes to migrate data for merging systems between Republic Services and its acquired companies.
Applaudo Studios, Remote
ETL Developer, September 2020 - July 2022
- Orchestrated pipes and workflows in Apache Airflow to deploy ETL processes for Walmart Inc. data engineering projects.
- Created ETL processes in Scala to extract data from ORC files in Google Cloud Storage and load it into MySQL.
Cupón Club, San Salvador, El Salvador
Programmer, October 2016 - September 2020
- Implemented system of push notifications for an Android app using Firebase in Java.
ESEN, La Libertad, El Salvador
Systems Analyst (March 2011 - March 2013), Adjunct Lecturer (January 2018 - July 2018, May 2017 - July 2017)
- Taught Introduction to Databases, Excel VBA and Programming I.
Kodak Alaris, Rochester, NY
Software Intern, May 2016 - August 2016, May 2015 - August 2015, May 2014 - August 2014
- Implemented transformations with SQL Server Data Tools to produce desired output data types for data migrated from Oracle transactional databases to SQL Server data warehouses.
- Created OLAP cubes in SSIS and ETL processes for business intelligence, analytics, and reporting applications.
EDUCATION
Rochester Institute of Technology, Rochester, NY
Master of Science in Information Sciences and Technologies, August 2013 - May 2016
- Fulbright Foreign Student Program Scholarship (flagship U.S. Department of State’s exchange program).
- GPA 3.87/4.0.
- RIT Graduate Merit Scholarship.
Loyola University Chicago, Chicago, IL
Fulbright Intensive English Program, March - August 2013
UNICAES, Santa Ana, El Salvador
Bachelor of Engineering in Computer Systems Engineering, Cum Laude, January 2005 - May 2011
- GPA 8.8/10.0 (Class rank: 1 out of a graduating class of 14).
University of Alabama in Huntsville, Huntsville, AL
Global Undergraduate Exchange Program, August 2009 - May 2010
- Concentration in Computer Engineering.
- GPA 4.0/4.0.
- Global UGRAD Scholarship (U.S. Department of State’s exchange program).