Jaime MontoyaCondominio Los Castaños, apartamento 36, Colonia Escalón, San Salvador, El Salvador.
SUMMARY
Data analyst specialist in data migration using Microsoft SSIS technologies.
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., San Salvador, El Salvador
Data Analyst, August 2022 - Present
- Integrated Microsoft SSIS ETL packages to migrate data for merging systems between Republic Services and US Ecology.
Applaudo Studios, San Salvador, El Salvador
ETL Developer, September 2020 - July 2022
- Orchestrated pipes and workflows in Apache Airflow to deploy ETL processes for Walmart Inc. data engineering projects.
- Optimized SQL queries in BigQuery to build financial reports used as inputs for Tableau dashboards.
- 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.
- Developed and fixed Oracle PL/SQL scripts used to populate, data mine and generate production, service, and business reports for Remote Business Management products.
EDUCATION
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 Science in Computer 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 & CERTIFICATIONS
IELTS General Training, September 2022. Overall Band Score: 7.5 | Listening: 8.0 | Reading: 6.5 | Writing: 7.0 | Speaking: 7.5