ERIK SÁNCHEZ

Contact No :516-206-4429
Email Id : [email protected]
https://www.linkedin.com/in/eriksanchezperez/

I have extensive IT experience in the analysis, design, development and testing using Object-
Oriented Java and Java Enterprise Edition for various financial and brokerage houses like HSBC
Global Markets, Santander Bank and Monex Financial Group. My expertise lies in the design
and development of Java related technologies like Java SE 8, Java EE 6, Spring Framework 4,
Spring MVC 4, Spring JDBC, Web Services (RESTful), JSP, Maven, XML, HTML, CSS,
jQuery, JUNIT, JSON, JUnit, Eclipse, Tomcat Application Server. I also have experience with
Oracle 11G and MySQL for persistence, using Hibernate 4.0 for ORM, Selenium for
Automation and Testing as well as VB and Python 2/3 for scripting. I am familiar with various
design patterns such MVC and IoC. I have successfully implemented Agile methodology. My
functional knowledge as a technical consultant covers working in Automation initiatives for
Financial Industries, as well as Data Quality for the Trading operations desk translating
business needs into technical requirements, developing code as well as giving training and support
to both technical and business-oriented teams. I have excellent communication and interpersonal
skills.

TECHNICAL SKILLS:

Development / Scripting Languages: Java 6/8, J2EE, Python 2/3, Visual Basic
Frameworks: Spring 3/4, Spring MVC, JDBC, Junit, Selenium
Server-Side Technologies JDBC, J2EE, XML, Spring Beans, RESTful Web services
Methodologies: Agile Development
Application Servers: Tomcat 8.0
IDE’s and Tools: Netbeans, Eclipse, SpringToolSuite,
Version Control GitHub
Databases/ORMS: Oracle 11G, My SQL 5.1, Hibernate 4, Access
Middleware Murex

PROFESSIONAL EXPERIENCE:

Java Developer, Svam International (New York) 09/19-

Present

Currently looking for a Java related project.

Software Engineer, HSBC Global Markets (México) 06/17-09/19

SWIFT Reconciliation Service

HSBC is one of the largest banking and financial services organizations in the world. Worked as a
software engineer for the Global Markets department with the focus being automation initiatives
for the Trading desk.
Developed the inhouse SWIFT Reconciliation Service for HSBC. The SWIFT Reconciliation
goal was the automatic matching of economic data from Swift messages between HSBC host and
their counterparties.

Responsibilities:

CV of Erik Sánchez – 09/19 page

 Was responsible for gathering requirements from the business analysts, then translating
those business requirements into technical documents.
 Participated in the Sprint planning (Agile-Scrum Methodology) to determine the stories
needed to renew the architecture of the new system.
 In the message store, highly efficient reconciliation tools were developed to run as weekly jobs
on data and multiple filesystems to keep it in sync with all the trades marked in the database
and for cleaning up extra messages in the database, if any were left even after cancellation of
trades. This involved knowledge of algorithms, optimized queries.
 Designed and developed Spring MVC, Spring Boot and Hibernate to expose Rest Services.
 Developed REST API with Java in Spring boot for CRUD operations related chart
configurations and others. Developed reporting software functionality in Java8. Developed the
logic of the application using Spring MVC, Spring IoC, and Dependency Injection modules.
 Was responsible for the design and development of the applications using Java collection
API’s with Java 8 features.
 Developed Java EE application to auto-generate emails with sensitive information. MySQL,
Spring MVC, JSP views. Created Session Factory with Hibernate 4.3.
 Designed and developed JSP based views, heavily using JavaScript, HTML, CSS and jQuery
for wiring the behavior.
 Designed MySQL queries to complete business requirements in Oracle 11G environment.
 Developed framework to report differences between transactional and emails information, using
DAO for database access.
 Developed solution to automatically generate and download invoices from web platform using
mainly JSON as a data-interchange format. Java 8, Selenium libraries.
 Developed Java application for the encryption and password protection of documents in Java 8
SE.
 Was responsible for generating aggregated reports. Worked with IText and Apache Poi for
Excel and PDF reports.
 Worked on JXL for reading, writing and comparing entries in Excel spreadsheets.
 Built Visual Basic scripts for AS400 IBM Terminal. Built Python scripts for reading data
from Outlook inbox.
 Provided training to both technical and business teams to illustrate how to use the tools and
provided support for the applications created.

Environment: Agile/Scrum Methodology, Java 6/8, Spring Framework 4, Spring MVC,

Spring Boot 2.0.2, Hibernate 4.3, Web Services (REST), JavaScript, CSS, HTML, XML/XSD,
jQuery, MySQL, Oracle 11G, Git/Github, JSON, Maven, Eclipse, Tomcat Web Server 8,
Python Scripting 3.

Risk Automation Consultant, Santander Bank, Mexico 11/16-05/17

P&L Reporting Application

Santander Bank is one of the top retail banks by deposits and offers everything from basic checking
and savings accounts to comprehensive financial solutions. Worked as a risk automation consultant
developing Java EE solutions to generate reporting from economic data from Trading and
Treasury Systems.
P&L Reporting Application had the main focus to report daily basis P&L metrics from trading
desks, based on specific algorithms implemented through SQL queries.

CV of Erik Sánchez – 09/19 page

Responsibilities:
 Designed and enforced quality assurance coding policies and good practices based on the Agile
Principles.
 Responsible for monitoring data correct flow from Murex applications to MIS.
 Implemented new functionality of MIS application built on Java 8, Spring Boot and Apache
Tomcat Server.
 Created an Automation Application using Selenium with Java SE 8 used Maven as a
software project management tool.
 Creating Rest full web services using Java 1.8 and Spring Boot. Added services and client
that involves calling external web service and data validation using rules and data enrichment.
 Created spring-based web services to communicating with REST web services.
 Developed Services classes for injection based on the IoC using the Spring Platform.
 Developed JUnit 4 test cases using Java SE 8 in order to ensure that the behavior was as
expected in the development of the Automation tool.
 Used Remedy system to keep track of known issues and bugs.
 Used Python Scripting and MySQL Queries to check data availability and quality.
 Kept track and fixed reported bugs to ensure correct running of the application.

Environment: Agile/SCRUM Methodology, Java 8, Spring Boot, Hibernate, Javascript, Web

Services (REST), Eclipse IDE, Tomcat 4, Selenium WebDriver, Python 2, MySQL 5.6,
Git/Github, Maven, Junit, Murex.

Programmer Analyst, Monex Financial Group (México) 10/15-11/16

Mortgages Administration System

Trust Fund division of Monex Financial Group is focused on the administration of Trust Fund
activities (mortgages). The project’s goal was to complete and add functionality to the Mortgages
Administration System that was keeping the track of the present value of the Trust Fund involved.

Responsibilities:
 Developed Mortgages Administration System using Java EE and Spring MVC platform on
Oracle 11G.
 Worked on DB2 data persistence with the Hibernate object-relational mapping framework.
 Used Spring Boot to develop necessary REST services, using JSON for communication.
 Developed JSP views. Developed Services classes for later injection based on the IoC pattern
using the Spring Platform 3.1.3.
 Developed Java 8 SE application with Selenium libraries to automate the massive download
from critical business documents.
 Was responsible for uploading, branching, versioning and maintaining source code using Git.
 Used Java 8 and JUnit to develop unit testing for said trust fund applications
 Developed Oracle Materialized Views in Data Ware House applications Oracle 11G for
business requirements.

Environment: Java 8, Spring 3.1, Spring MVC, Spring Boot, REST Services, IoC, Tomcat,
Hibernate 4.0.2, MySQL 8, Oracle 11 g, Github, JSON, Maven, JSP, Windows, JSON, JUnit,
Web Services.

Software Developer, National Polytechnic Institute, (México) 07/13 – 10/15

CV of Erik Sánchez – 09/19 page

Business Intelligence Insurance System
Developed a specific Insurance System, the main focus of which was to develop business
intelligence reports about the insurance policies for different type of cars.

Responsibilities:
 Was responsible for gathering requirements from the business analysts, then translating
those business requirements into technical ones.
 Created UML Diagrams for System Structural Design, Class Design and Execution Flow,
Sequence of Use Cases, deployment diagram using Microsoft Visio 2010.
 Was responsible for ETL process from raw data using Java 8 SE. (Java FX application
interface).
 Created Data Warehouse developed in Oracle 12c. (Star Model, SQL Operations).
 Created Session Factory with Hibernate 4.0.2.
 Wrote logging code using Log4j & unit testing using JUnit framework.
 Developed functionalities using Java 8. Developed the logic of the application using Spring
MVC, Spring IoC, and Dependency Injection modules.
 Created Business intelligence reports using MySQL queries.
 Was responsible for JSP views creation. (HTML, JSTL, Bootstrap, CSS, Jquery)

Environment: Java 8, Spring, Spring MVC, Oracle 12c, Hibernate 4.0.2, Github, JSON,
Maven, JSP, Windows, JSON, JUnit, Web Services.

Movies webpage Administration System

Developed a Movies Administration System as a web application in Java 8. The application
manages and performs DML and DDL procedures through Apache Tomcat 8.0 server.

Responsibilities:
 Did the View Component Development in JSF with Prime-Faces. The design was developed
with JavaScript, CSS.
 Did Client-Side Validation in JavaScript. Business logic was implemented for forms
validation.
 Managed Beans and Service Components with Spring. Exposed EJB components as Web
Services for remote consumption.
 Was responsible for Service Transactions for Database persistence. Did the Database Mapping
with MyBatis. Checked the right implementation of MyBatis plugin.
 Created High Performance SQL Queries at Oracle environment.
 Used GSON library from Google (JSON used to retrieve to movies data Tomcat Server)

Environment: Java, PrimeFaces, JSF, Spring, EJB, MyBatis, SQL, Oracle, HTML,
JavaScript, CSS, MySQL, Tomcat, JSON, Eclipse.

EDUCATION:
 Bachelor of Engineering from National Polytechnic Institute, Mexico City, Mexico - 2015.

CERTIFICATIONS/COURSES
 Diploma in Java Technologies
 Informatics Management
 Six Sigma Yellow Belt Certification

CV of Erik Sánchez – 09/19 page