Hello, I am elier lopez
and I am a happy coder

Created a solution for downloading a massive number of utility bills from multiple admin email accounts via gmail APIs for saving time and money to the accounting department. Used techs: React, React.Context for state management Typescript.
Some other achievements:
Integrated Keycloak with web api for filtering access based on roles and access policies. Migrated some legacy web api services from old net .46 framework to .Net 6. Migrated legacy system for tracking utility user accounts (bills) from AspNet to React application.

Created a solution integrated by multiple microservices that manages and monitors thousands of devices connected online that traces smoke and fire detections in Carrier clients buildings. Involved techs; Node JS, Typescript, Graphql, Dynamo, Neptune & Sparql, S3, AWS IoT.
Some achievements on this project:
Published lambda functions with Apollo server & GraphQL Published lambda functions handled by S3 object events for reading and managing XML and JSON files. Published lambda functions that manages Okta user via GQL schemas. Published an integrated solution syncing Dynamo & Okta Data via Okta events hooks.

Created a Database Application for managing candidate profiles, skills, history and key information that could be useful for the human resources department. The application provides an easy way to search candidates that make fit for any specific project based on skills or experience. The application saves time and money that was previously invested in finding candidates for open positions. Node Js. React. GraphQL. PostgreSQL. Prisma.

Python application. Pulls Factiva Content by consuming Dow Jones APIs. The app was designed by three basic modules; Factiva Snaphots, factiva stream and azure resource consumer. The app formats downladed files, processes & deduplicate via AI model, seeds Azure Blob and Runs an azure indexer. Develop Factiva modules & queries and stream query. Develop azure resources module. Integrate modules. Setup environment & deployments.

UI: React + react-hooks + redux Web App, SCSS. Backend: Net Core Web API with Clean Arquitechture Design, EF Core, SQL.
Review code inputs from team members Add web methods for executing queries & commands.

Net Core Web API, EF Core with Code First. React + React-Context Web App, Storybook, SCSS. My Participation as tech lead: Lead & support team members in daily tech activities Review code inputs from team members Design the web API template design Integration with external dependencies. Service to Service communication

Net Core Web API, EF Core with Code First.
React + React-Context Web App, Storybook, SCSS. My Participation as Sr. Dev: Design the Web API template design Integration with external service dependencies. Creation of react components

Net Core Azure Functions, EF Code First, Sql, Azure Key Vault Integration and WPF Application. My Participation as Sr. Dev: Implementation of Keyvault provider. I was in charge of moving all sensitive data in existing project files to KeyVault and pulling them by a Custom provider that reads all these secrets and compose a Configuration object that then is injected as dependency to functions Creation of KV manager app. I created a WPF Application to be consumed by Devops team. This application Creates, Updates, Removes secrets from Azure Key Vault resources used in different environments; Dev, QA, UAT, PROD. The app implements MVVM pattern with strict layer separation, Custom Delegate Commands and HttClient Custom Service for http requests and Lazy Loading strategy

Net Core Web API, EF Code First, Sql and React-Redux App and very strict SOLID principles and high MS Coding standard implementations. My participations as Sr. Dev: Creation of Mechanism for queuing remove old data process thru overriding Context Save Changes process Creation of Mechanism for raising remove process of old data in Azure functions project React App bug fixing

Net core Web API and React-Redux App. My participation as Sr. Dev: Create the Web API Template/Architecture. UoW, Generic Repository and four layers design. Automapper, Serilog with Sql, Azure AD Auth, Swagger, Unit Testing with Custom Mocks and Dynamic mocks with Moq, EF Core with Code First Strategy Implementation of Custom authorization header for decorating web methods Implementation of React components and containers (HOCs) Implementation of date formatters (using moment.js) Coaching and technically supporting peers

Net Core Web API and React-Redux App. My participation as Sr. Dev: Implementing custom authentication header for special validations on specific web methods Fixes and refactors of the services layer Implementation of react components Fixes and refactors in the Azure AD authentication

Net core Web API and Job library. Participated as Sr. Dev: creating the template/architecture for both solutions A Migration Job: A library that migrates big bulks of data from a legacy DB. Core API: Is a net core web API that exposes information from an Azure SQL DB. Designed in with UoW, Generic Repository and three layer design; web, services and Repos Implemented some tools: Auto mapper (for avoiding to expose Domain classes out of services layer), Unit testing with Custom Mocks, Azure AD authentication, Swagger (Swashbuckle), Serilog with Sql

Develop and support one of the mobile apps in Ketser infrastructure. Some of the implemented features: MVVM with prism, Custom renders, Resources Localization (multi language), centralized dictionary resources, Static converters, Bound Triggers, Dependency Injection, push notifications with Azure Notification Hub. I am involved in the complete development cycle and also manage/create/update the Certificates, identifiers and provisioning profiles for iOS version.

Designing the template/architecture for the Web API. It implements Asp .Net identity for authorization and simple authorization (since one of the apps does not require user authentication). Azure Sql DB. Some nice design patterns; UoW, Generic Repository, EF 6 with CodeFirst and some solid principles; Dependency Injection, Interface segregation, and layers with limited responsibility.

Develop and support a react web app for managin core data in Ketser backend; core catalogs, admin users, handling statistics and other data queries. It's designed using: react-redux, react-bootstrap, Storybook, axios, and environment management.

A Medical Insurance Tracker System. ASP.Net site, Web API and multiple SQL Databases. I Participated implementing multiple features using Jquery, Javascript, Html5, Sql Stored Procedures and Sql functions, Entity Framework DB first approach, Linq, Unit Testing and UI unit testing with Jasmine.

Based on an MVC.Net project and a worker process raised by windows a task. It tracks the technical growth of employees gathering multiple assessment responses and personal professional milestones each year quarter. Participated implementing multiple reports using Google charts, multiple Sql stored procedures, Sql scalar and table functions, implementing Bootstrap and Jquery for redesigning the front end.

Mobile App. Its social network app. Xamarin Forms framework, MVVM pattern. Amazon Web services; Dynamo DB, Lambda functions. Custom renders, Fresh MVVM, XAML, GEO Fencing among other specs.

Mobile App for IO’s and Android. Xamarin Studio 2015. C#, Rest, Json, Xml, XAML, Google Maps API Javascript implementation.

Several Asp.Net web Sites. Implemented Sql Server, Javascript, VB.Net, Windows service, telerik controls. I participated implementing some customizations, changes to the Win service and Jquery integrations.

MVC.Net project. Implemented SQL server, IOC (inversion of code), LinqToSql, Jquery, a Windows service. I participated for three years implementing many backend changes, Jquery controls, Devexpress controls integration, .net framework upgrade to 4.5.1, changes to the SQL schema and other collaborations.

Windows service and web service (asmx) projects. Implemented, C#, Regex. I participated creating a custom decoder for OCR files.

Asp.net web project. I Participated implementing a jquery plugin for rss and UI customizations.

Asp.Net web project, participated making Javascript, UI and backend changes at C# code.

Asp.net web project page, implemented Javascript and a CRM customization.

MVC.Net web project, implemented SQL server, jquery clientside field validations, EntityFramework, Linq, massive emailing, etc.

SOS site; SQL Server, Implemented membership provider Jquery, EntityFramework, Linq, custom reports, etc.

I​ ​taught Programming fundamentals subject in TecMilenio campus Hermosillo Sonora.
Activities: Teaching students theoretical programming concepts and leading practices and exercices, evaluating evidences, elaborating and evaluating exams, coaching students and supporting them for meeting the proper milestones.

As freelancer: I Developed point of sale system for ​LA FUENTE ​at Huatabampo Son. PVD was based on windows forms, C# .Net and Sql Server 2005. Access functions and Crystal Reports.

I worked for FUTURO INTELIGENTE developing several projects implementing fingerprint identification devices and RFID for Access Control Management, most of them implements TCP/IP and/or serial communication and was based on .Net windows services, Windows Forms with C#.Net and VB.Net.

As freelancer: I developed ​FACTURACION for REMANUFACTURAS ELECTRICAS AUTOMOTRICES in Navojoa Sonora based on windows forms and VB 6.0 and Access DB. functions (SQL Trigger simulations) and Crystal Reports. Provided technical support.

As intern​: I installed and configured a Linux internet server Squid 2.7 and setup a filter DansGuardian for CONALEP campus Huatabampo Sonora.

As intern: ​I​ ​Developed the pack ​SICOHEEP​ based on windows forms and VB 6.0, using Sql Server 2005. Sql SPs, Sql Triggers and Crystal Reports. for CFE facility: Huatabampo Sonora (COMISION FEDERAL DE ELECTRICIDAD).