Jorge Mira Yagüe

Senior Python Developer

Bank of America•  July 2016 - December 2017

Working on strategic project to consolidate profit & loss, risk and trade information as part of a dynamic, global team of 15-20 developers in the US, EMEA and Asia. Job responsibilities involved internal bank technologies & frameworks: Python 2.7, SQL (Sybase & Netezza), NoSQL (key-value storage with indexable fields), distributed computing and creating web tools for business users using Flask framework, Jinja template system, SQLAlchemy ORM and Bootstrap framework Hands-on involvement in developing a high performance reporting infrastructure of a consolidated data warehouse which provided daily market risk metrics to risk managers. Trained and mentored junior programmers in programming methodologies and best practices. Contributing to engineering best practices including peer reviews, coding standards, refactoring and performance improvements

Senior Data Engineer

StateStreet•  November 2015 - July 2016

Maintenance, upgrade, configuration and monitoring various in house tools responsible for delivering files into the Extract, Transform an Load (ETL) processes Work closely with various business partners to pick up, transform and deliver time critical data files into an application that processes approximately 250,000 files monthly, having 3,000+ configuration lines driving file transmission and 2000+ transformation processes Maintenance of python scripts used in complex ETL transformations Development with Pervasive Data Integrator, an Extract Transform and Load (ETL) tool, using its embedded VisualBasic-like scripting language Bash programming using cygwin to automate deployment and speed up development process

Python developer

IBM•  October 2014 - October 2015

Back-end core developer for a newly created Data Analytics tool hosted in a cloud environment Development of scalable ETL solutions in Python and Shell scripting using multi threaded algorithms to speed up data processing times Retrieving and processing information from different vendors in different formats DB2 database development for the report generation system Working remotely with most of the members of the team based in India or the US Mentor freshers and develop their coding skills

DB2 Migration Engineer

IBM•  May 2010 - May 2013

Migration of PL/SQL applications to SQL PL Working on site with clients from different geographies, providing them expertise in database application development and performance tuning Development of Perl scripts to process PL/SQL code or replace core Oracle utilities as sqlldr Delivering courses about DB2 advanced features. Migration of Java applications from Oracle to DB2 including building new applications to replicate Oracle packages Development of Apache modules in C

PHP Developer Intern

ISCN Limited•  July 2009 - April 2010

Maintenance of web application with 24/7 high volume availability demands using open source tools such as Linux, Apache, PHP and MySQL Normalized database tables and performed extensive query optimization. Cleaned up and rewrote front end HTML and CSS to meet validation requirements. Installation and configuration of Apache server and SVN server under a Linux environment