- Home › Jaime Montoya's one-page resume
Jaime Montoya's one-page resume
Jaime MontoyaCondominio Los Castaños, apartamento 36, Colonia Escalón, San Salvador, El Salvador.
SUMMARY
Data analyst specialist in SSIS 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 Microsoft SSIS ETL packages 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
Microsoft, Online
Microsoft Azure Data Fundamentals DP-900 Exam Prep Specialization, June 2023 - Present
- Five-course program covering the fundamentals of database concepts in a cloud environment, basic skilling in cloud data services, and foundational knowledge of Microsoft Azure.
University of Rochester, Rochester, NY
August 2015 - May 2016
- Teaching Assistant for CSC 261 (Database Systems).
- Completed 16 credits towards a Ph.D. in Computer Science.
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).
STANDARDIZED TESTS
IELTS General Training, September 2022. Overall Band Score: 7.5 | Listening: 8.0 | Reading: 6.5 | Writing: 7.0 | Speaking: 7.5