About
Accomplished Senior Software Solutions Engineer with more 10 years’ experience leading projects by acting as the architect, developer, and programmer analyst. Proficient in supporting project deliverables and maintaining releases. Tech leader in guiding support teams and solving complex issues. Steadfast in planning and implementing effective development strategies based on industry best practices. Total involvement with the company, helping them become a global enterprise, providing the necessary computing tools, tools updated and flexible according to the vision of the companies.
Bachelor Of Computer Systems Engineering
Universidad Católica de El Salvador - 2014
Studies focus on application development, IT project management, multimedia design, technical planning, and business case analyses. Created working prototypes for numerous web site projects and desktop applications.
- Microsoft Official Curriculum:
- MOC-2310C Developing Applications Using Microsoft. Visual Studio
- MOC-6463 Visual Studio 2008: ASP.NET 3.5
- MOC 6232 Implementing a Microsoft SQL Server 2008 Database
- MOC 6461: Windows Communication Foundation.
- MOC 6235 - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services.
- MOC -6231 Implementing a Microsoft SQL Server 2008 Database.
- MOC 6234 - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services.
- Microsoft Certified Technology Specialist:
- Microsoft SQL Server® 2008 - Implementation and Maintenance.
- Microsoft .NET Framework 3.5 - ASP.NET.
Skills
In my more than 10 years of experience in software development I have worked in many technologies, some of them are.
Resume
Senior Software Developer
As Contractor
Database Developer
- My role has been to create and manage ETL for migrations and data transformation from different sources such as Azure, SAP Hana, SysBase, SQL Server, PostgreSQL to BI servers, as well as supporting different developers in query optimization and project support, as well as in database administration processes, such as performance, locks, backups and production deployments.
Software Developer
- In this role I design, develop and maintain a customer and sales control system, implementing business logic using ASP.NET NET Core for the backend and React.js for the frontend.
Senior Reports Developer
- • In this role I design, develop, and implement metrics, reports, and dashboards to assist data-driven decisions. Further responsibilities include determining and implementing the visuals that will provide the best insights to support business decisions.
Full Stack Developer
2022 - Contractor
TechAffinity
- Perform the analysis of software projects including performance, diagnosis, and troubleshooting.
- Conduct code reviews for other team members, ensuring the project conventions have been adhered to and that requirements are correctly implemented.
Professional Experience
Senior Software Solutions Engineer
2008 - 2022
Fruit of the Loom El Salvador.
- Implement and manage on-premise source code version control server and in Azure DevOps.
- Analyze, design, coordinate, document, undertake the development of software systems, testing and deploy the assigned projects.
- Contribute to the analysis of software projects including performance, diagnosis, and troubleshooting.
- Conduct code reviews for other team members, ensuring the project conventions have been adhered to and that requirements are correctly implemented.
- Work with staff and clients to identify opportunities for new projects that will be of benefit to the organization.
- Provide feedback to staff and clients about performance considerations or issues concerning the software.
- Provide assistance to testers and support personnel as needed to diagnose and resolve the issues.
- Trainee new programmers on standards operation process IT.
- Implement company policies, technical procedures, and standards for preserving the integrity and security of data, reports, and access.
- Responsible for effectively initiating, planning, scheduling, estimating, forecasting, coordinating, controlling, managing all activities for projects and related release initiatives.
- Communicate/Report progress to the project sponsors.
- Oversee the day-to-day progress of projects and release initiatives regarding time, scope, and quality; apply PMO agile processes to report release status, key metrics, and deliverables.
- Drive and passion to implement processes and procedures to ensure project delivery is on time.
Professor
2014 - Present
Universidad Católica de El Salvador
Faculty of Engineering and Architecture
- Teacher of the subjects of Web Technologies, Development of Web Applications, Computer Systems, Management of Web servers, in which the skills of each student in the Web programming environment are developed.
- In these subjects, it is taught from the development of web layout, creation of Web Api services, user interfaces until the implementation of complete systems either in local environments or on cloud platforms such as Azure.
- As well, I degree thesis advisor to the students in this process.
Portfolio
During the more than 10 years working in software development, I have been improving my programming skills and other soft skills with which, these are some of the projects I have worked on.
Role: Team Lead and Developer
Overview: The internal purchasing control system, designed to manage the catalog of products, suppliers, requisitions, purchase orders and payments to vendors in the region that includes El Salvador, Honduras, Haiti and Mexico.
Responsibilities: My role as Team Lead was of leading the meetings with the stakeholders, taking requirements, making documentation and managing the project schedule, as well as assigning tasks to the
development team, making daily scrum meetings and providing progress each week to the stakeholders.
As a developer, my responsibilities were creating APIs using C# to connect the database in MS SQL with the frontend in React.js, also, create user interfaces with React.js, as well as perform the necessary
Code Reviews prior to any commit from the development team.
Other responsibilities in this project were managing the development and testing environments in the Azure portal, where the Web App and SQL as Services resources were created and the other services necessary
to handle file storage and others, as well, I made each deployment to the development environment, also, I created a continuous integration and deployment plan to test environment at the end of each sprint.
Technologies: Javascript, React.js, ASP.NET Core Web Api, C#, Entity Framework, SQL Server, Azure Web App, Azure SQL as Services, Microsoft Project, Repos in Azure DevOps, Internal Project Task Management.
Role: Developer
Overview: The human resources system, in which the hiring and administration of the profiles of all employees in El Salvador, Honduras and Haiti are carried out, in the system the employee's profile, hierarchical organization chart, positions, time off, disabilities and payroll, among others.
Responsibilities: Acting as a developer, my responsibilities were to create Web API using ASP.NET Core and C# to connect the database in MS SQL with all systems that need employee information, as well,
as performing the necessary Code Reviews prior to any commit from the development team.
Other responsibilities in this project were to manage the development environments and deployment to the IIS, where the Web App resources were created, making the deployments on demand into the development
web server.
Technologies: ASP.NET Core Web Api, C#, Entity Framework, MS SQL Server, Internet Information Services (IIS)
Role: Developer and helpdesk
Overview: The internal project task management system is used to manage all the tasks of the development and production applications, in this, we carry the kanban boards of issues, bug, improvements of all our developments, we make the testplans and documentation in general, as well as the management of every project sprint and backlog.
Responsibilities: My role as analyst and developer, in my responsibilities, was the gathering of the requirements, design and complete development of the system in its version 1.0, programming the
backend using Visual Basic.Net to connect the database in SQL, the frontend was worked with Bootstrap, ASP.NET WebForm, Javascript and Angular.js, as well as performing the necessary Code Review prior to any check-in
from the development team, the reports have been created using SQL Reporting Services, in this project, much of the logic is immersed on the store procedures in SQL Server, the application has an API developed in
ASP.NET WebApi with C#, where other tools can connect and acquire information as for reports such as Power BI.
Other responsibilities in this project were to manage the development and make the deployment into the local environments towards the IIS, where the Web App resources were created, making the deployments
on demand towards the development web server, as well as managing the branches in the control server of versions in Azure DevOps, where I was in charge of making the new branches of each sprint, making the merges
from the sprint branches and the Main Branch.
Technologies: ASP.NET WebForm, ASP.NET Web Api, VB.NET, C#, Entity Framework, JavaScript, Angular.js, BootStrap, MS SQL Server, MS SQL Reporting Services, Internet Information Services (IIS), Repos in Azure DevOps
Role: Developer and helpdesk
Overview: : It's the central system on the production floor, in which the entire process is carried out from the reception of materials, creating their input and distribution programming on the production floor, tracking their inputs and assembly, as well as their storage and export.
Responsibilities: Acting as a developer, in charge of programming the import and export modules of products, as well as the supplies administration module, this system was programmed in ASP.NET WebForm,
using Visual Basic.NET as the language in the backend and ASP.NET Webform with javascript on the frontend, MS SQL Reporting Services was used for the reports, in this project, much of the logic is immersed on the
store procedures in SQL Server.
This system, by keeping the entire production record, a module was programmed to integrate and transfer records from MS SQL Server on the region to the corporate ERP that is in Oracle, for them, ETLs
were created for the transformation of information and sent to tables in Oracle
Other responsibilities in this project were to manage the development and make the deployment into the local environments towards the IIS, where the Web App resources were created, making the deployments
on demand towards the development web server, as well as managing the branches in the control server of versions in Azure DevOps, where I was in charge of making the new branches of each sprint, making the merges
from the sprint branches and the Main Branch.
Technologies: JavaScript, jQuery, BootStrap, ASP.NET WebForm, ASP.NET Web Api, VB.NET, C#, Entity Framework, MS SQL Server, MS SQL Reporting Services, MS SQL Integration Services, Internet Information Services (IIS), Repos in Azure DevOps
Role: Developer and helpdesk
Overview: The application security system is in charge of managing each of the users that in all applications in the region have the rights of use, in this system, users are registered, roles and permissions are assigned to applications and their internal options, the menu options of each system are managed and the credentials of the users are reestablished.
Responsibilities: Develop and support the backend developed in visual basic.net, as well as design and build the forms in ASP.NET WebForm using Bootstrap and Javascript for communication with the backend,
an API service was created using ASP.NET WebApi with C # for the communication with systems that require validation and user information.
Technologies: JavaScript, BootStrap, ASP.NET Webform, ASP.NET Web Api, VB.NET, C#, Entity Framework, jQuery, MS SQL Server, Internet Information Services (IIS), Repos in Azure DevOps
Role: Developer
Overview: : The container control system is in charge of managing the rents of each equipment used to transport material between different locations, in which the number of containers per company, their rental days, movements, and assigned location is kept.
Responsibilities: Design and deploy new layered development architecture in the company, separating each layer in a project, implementing a DDD architecture, developing the services using ASP.NET WebApi,
business logic using OOP with C #, the data model with Entity Framework and the interface of user with ASP.NET MVC, bootstrap and Javascript.
Technologies: ASP.NET MVC, ASP.NET Web Api, C#, Entity Framework, JavaScript, jQuery, Bootstrap, MS SQL Server, MS SQL Reporting Services, Internet Information Services (IIS), Repos in Azure DevOps, DDD
Role: Developer and helpdesk
Overview: This system was developed so that the local municipality that requested it can keep track of each citizen, their property records, companies established, and the management of all service taxes that citizens and companies are obliged to pay to the municipality.
Responsibilities: Take the requirements, analyze and design the application, then carry out the development of said application in multi-layer architecture, where for the frontend ASP.NET MVC was used
with bootstrap and javascript to communicate with the controllers of the layer of applications, likewise, a business loggia layer was developed, using the object-oriented programming paradigm with C # where all
the business validations and their respective connection with the database were carried out using the interface layer, to connect the domain and application layer, a services layer was developed in ASP.NET WebApi,
which is responsible for using each domain class to manage all the information that the application needs.
Technologies: ASP.NET MVC, ASP.NET Web Api, C#, Entity Framework, Bootstrap, Javascript, jQuery, MS SQL Server, MS SQL Reporting Services, Internet Information Services (IIS), DDD
Role: Developer and Helpdesk
Overview: System to carry out the entire ordering process in a restaurant, where the waiters make the orders to the kitchen as requested by the customers, the system shows the dishes available by days and their components, the waiter can add additional components to the dishes, the Kitchen staff sees the preparation orders and changes the status depending on whether it is in preparation or finished so that it is collected and delivered by the waiter, the cashier staff can see the consumption of each client or the tables and make the respective charges , the restaurant manager views ingredient inventories and various reports such as daily sales, revenue
Responsibilities: : Develop the API service in the backend using PHP Laravel, creating the necessary components to obtain the information from the database in MySql and provide it to the frontend where
the forms were programmed using bootstrap and javascript for communication with the API.
Technologies: PHP Laravel, Bootstrap, JavaScript, MySql, Github
Role: Developer
Overview: : The application is responsible for receiving orders from customers, analyze and decide if the order is accepted, when accepted, it is assigned to the delivery staff.
Responsibilities: Developed the mobile application for Android, which was developed using React Native, its respective components were programmed in React Native to list the pending orders, check the
details of each order, carry out the process of accepting the order, and assigning the delivery guy. Also, the backend was programmed using Express.js and MongoDB, using firebase for push communications.
Technologies: React Native, Express.js, Node.js, GitHub, Firebase, MongoDB.
Contact
Contact by email or through my social networks.
Location:
El Salvador, Central America
Email:
emerson.aguilar [at] live.com