Summary

Expertise

Project Highlights

Education

Agency

ER

English:

Upper Intermediate

Edwin Frederick R.

vetted by Youteam

Vetted by YouTeam

Bolivia

UTC -04:00

America/La_Paz

English:

Upper Intermediate

I started working professionally as a web developer in 2006.

I started working professionally as a web developer in 2006. From 2007 to 2021 I worked in a company that provides telephone, internet, and television services. There, I participated in developing several software projects in teams of 2 to 5 people, although in most projects I worked as a full-stack developer in projects, as a single programmer, in constant communication with the project manager. Since 2015 I have worked using the Scrum methodology and as a company policy, I used TFS for task tracking and updating the product backlog items selected for each sprint. I have also used Git for source code versioning. I have used DDD and Onion Pattern in projects developed in .Net My preferred languages are C#, PHP, and Java, although I have experience in others. Also, I am experienced with frameworks like .net, Entity Framework, angular, and the following DBMS: MySQL, Microsoft SQL Server, PostgreSQL, and MongoDB

Want to hire this engineer?

Check if Edwin Frederick is available

Expertise

Years of commercial development experience

7 years of experience

Core technologies

.NET 7 years
C# 10 years
PHP 10 years
RESTful API 6 years
MySQL 10 years

Other technologies

JavaScript
SQL Server
TypeScript
Scrum
Angular 2x

Project Highlights

icon
Consultant

Quotation Web/mobile App

Currently, the company uses ERP software available only in a desktop version. The purpose of this project is to migrate some features to a mobile/web environment, improving response times in some of the identified business processes. Initially, it was deployed as a web application with the following features: search for spare parts, quotation, sales, approval of credit processes, and sales comparison reports of products in different brands.

Responsibilities & achievements

Main tasks executed in the project:  Docker server installation and configuration  Configure and deploy docker containers  Configure and test CI/CD pipelines in Jenkins  Perform analysis, design, and implementation  Define and implement test cases  Publish services in the test and production environment  Perform task updates on Azure Boards.  Update the Git repository Initially, I worked on the optimization of some functions of the sales module of the company's ERP, where I promoted the use of Git Repositories for the ERP Source Code and services developed later. I configured tools for monitoring the new web services developed. Later these tools were used to monitor other network services of the company Technologies: Docker, Jenkins, .Net 6, C#, Entity Framework, Angular, Ionic, Capacitor, MSSql Server, Zabbix

C#
.NET
Entity Framework
Jenkins
Angular 2x
Docker
icon
Consultant

Statistical sales reports

The implementation of statistical quarterly sales reports was required in addition to optimizing existing reports.

Responsibilities & achievements

Main tasks executed in the project:  Cleaning duplicate data in MS Sql Database  Optimizing slow SQL queries  Creation of stored procedures and functions for generating statistical reports.  Creation of reports using pivot tables / Power Query.  Update assigned tasks using Azure Devops Taskboard. Processing times were optimized in the existing reports. The processing time was reduced from 30 minutes to 18 seconds. Different data sources were integrated for the processing of statistical reports, allowing the generation of unified and updated reports in a matter of minutes. This processing used to take days for the client. Technologies: MS Sql Server, SQL, Python, Power Query, PowerBI, Python, MS Excel

Python
SQL
MS SQL Server
Power BI
icon
Freelancer

Feature Update for LTE Billing System

Due to requirements established by the government, it was necessary to implement new functions that would allow the end customer of LTE services to approve all debits in the assigned money accounts. It was required to implement new functions in the backend, web services, and USSD/SMS interfaces used by the end customer for consultation and approval of debits.

Responsibilities & achievements

Main tasks executed in the project:  Implementation of functions for debit authorization in the billing system  Creating new Web API for Service Integration  Creating new USSD/SMS Accesses for the end customer  Creation of credit balance SMS notifications.  Updating Expiration Processes for data accounts  Testing and deployment to testing and production environment. The client required the implementation of each of the functions to not receive a penalty from the government. After deploying the updated services, personnel assigned by the government were responsible for carrying out the tests that passed satisfactorily. Technologies: Java, MySQL, Web API, JBoss, Maven, Angular, Git

Java
MySQL
Git
Angular 2x
Maven
icon
Consultant

Bug Fix and features upgrade

The company uses a web application for customer, inventory, and sales management. It was necessary to fix some bugs identified and add new functions in the sales and inventory modules

Responsibilities & achievements

The company uses a web application for customer, inventory, and sales management. It was necessary to fix some bugs identified and add new functions in the sales and inventory modules Main tasks executed in the project:  Implement new features.  Fix bugs  Deploy to test and production environments Functions were implemented according to customer requirements. Each function was aimed at improving the sales processes carried out through the system and eliminating dependence on other systems. Technologies: PHP, Laravel, MySQL, Nginx, Docker.

PHP
Laravel Framework
Docker
icon
Software Developer

Room capacity

COTAS RL is a telecommunications company founded in 1960. It began providing landline telephony services and currently provides Mobile Telephony, Cable TV, and Internet services. They use Scrum methodology for software development processes

Responsibilities & achievements

Every year in September a fair is held in the city of SANTA CRUZ, due to the time of the pandemic, the number of people in closed places was restricted and a means was needed to verify the number of people in each room. An application was implemented, compatible with android TV, that allowed us to see the capacity and the number of people in each room. The application was integrated with recognition services through IP cameras located in each room, which allowed to keep track and show in real-time status of each room Main tasks executed in the project:  Research from recognition services providers  Implement Backend  Implement android application  Deploy backend services to Azure  Updating tasks in TFS  Ongoing support Technologies: Azure, .net 5, MS SQL Server, Entity Framework, Angular, Ionic, Capacitor, C#, Git

Azure
C#
.NET
Entity Framework
Git
Angular 2x
icon
Software Developer

Reports for Bot

Reports of chatbot usage were required to analyze the flows and the most used options to improve the service

Responsibilities & achievements

Main tasks executed in the project:  Requirements capture, Analysis, Design, and implementation.  Updating tasks in TFS  Ongoing support The reports generated allowed us to define improvements in the content of the chatbot. Technologies: .net Core 2.1, MS SQL Server, Entity Framework, Angular, C#, Git

C#
Entity Framework
Git
Angular 2x
MS SQL Server
.NET Core
icon
Software Developer

Equipment recovery Mobile APP

An application was required to assign technical personnel tasks to recover equipment assigned to end customers. Each technician would have the possibility to see a list of assignments and locations on a map from their mobile device and could update the status of each assignment when completing each task

Responsibilities & achievements

Main tasks executed in the project:  Implement frontend based on designs received in JPG format  Implement Backend  Deploy services to test and production environment  Updating tasks in TFS  Publish the application to local android app stores  Ongoing support Technologies: .net Core 2.1, MS SQL Server, Entity Framework, Angular, Ionic, Capacitor, C#, firebase, Git, MongoDB

MongoDB
Entity Framework
Angular 2x
.NET Core
icon
Software Developer

Cotas Play APP

A new service for streaming selected content was defined, such as football championships. Additionally, a list of local channels was drawn up for transmission all through a mobile application. The team of designers prepared images with the required interfaces necessary for the implementation of the application.

Responsibilities & achievements

Main tasks executed in the project:  Implement frontend based on designs received in JPG format  Implement Backend  Deploy services to test and production environment  Updating tasks in TFS  Submit the application to android and iOS app stores  Ongoing support Technologies: .net 4.7, MS SQL Server, Entity Framework, Angular, Ionic, Capacitor, C#, Git

C#
Entity Framework
Git
Angular 2x
MS SQL Server
.NET Core
icon
Software Developer

Campaign conciliation

Once the campaigns were processed and the status received, it was necessary to verify the information by comparing call logs generated through access provided by the company. Campaign data was imported and processed for further analysis

Responsibilities & achievements

Main tasks executed in the project:  Requirements capture, Analysis, Design, and implementation.  Deploy services to production  Updating tasks in TFS  Ongoing support Technologies: .net Core, MS SQL Server, Entity Framework, C#, Git

C#
Entity Framework
Git
.NET Core
icon
Software Developer

Campaign Generator

In 2018 the company decided to outsource its collection services. It was necessary to carry out a new development to generate campaigns to collect pending invoices and send them to the new provider of call center services.

Responsibilities & achievements

Main tasks executed in the project:  Requirements capture, Analysis, Design, and implementation.  Deploy services to production  Updating tasks in TFS  Ongoing support Technologies: .net Core, MS SQL Server, Entity Framework, C#, Git

C#
MS SQL Server
.NET Core
icon
Software Developer

Dialer

A new call generator was required with functions that allowed text-to-speech to be integrated. This application should be able to obtain names and addresses from a database and convert them to audio and automatically schedule notification tasks by means of voice calls, with retry and status logging.

Responsibilities & achievements

Main tasks executed in the project:  Requirements capture, Analysis, Design, and implementation.  Configure asterisk services and routing  Deploy services to the Linux server  Updating tasks in TFS  Ongoing support Technologies: .Net Core, MS SQL Server, Asterisk, Git

Git
.NET Core
icon
Software Developer

Anti-fraud system for long-term international calls

Due to fraudulent long-distance calls received through the company, the implementation of an anti-fraud system was required to block calls according to duration parameters and predefined prefixes, to avoid losses for that type of calls.

Responsibilities & achievements

Main tasks executed in the project:  Requirements capture, Analysis, Design, and implementation.  Deploy services  Configure M3UA links  Coordinate tasks with the development team  Training the operations team  Updating tasks in TFS  Document disaster recovery procedures  Execute acceptance tests  Ongoing support Technologies: .Net 4, PostgresSQL, Git

.NET
PostgreSQL
Git
icon
Software Developer

Project monitoring

After an internal restructuring, I was required to implement a web system to track the activities carried out for each project developed by the area.

Responsibilities & achievements

Main tasks executed in the project:  Requirements capture, Analysis, Design, and implementation.  Deploy services  Training the end users  Ongoing support The System helped maintain centralized control of the status of ongoing projects and remained in service until 2015 when there was a new internal restructuring. Technologies: .Net 2.0, MS SQL Server, Telerik, VM Ware

.NET
MS SQL Server

Education

Higher education in Computer Science

Agency

Software development agency #3757

10-50

GMT-5

Lima, Peru

Core Expertise

Agile
Amazon EC2
Amazon S3
AngularJS
AWS
Azure
C#
Django
Elixir
ETL
Express.js
Flask
Google Analytics
Groovy
Hibernate
HTML5
Ionic
Java
JavaScript
jQuery
Kotlin
Kubernetes
Microsoft
Microsoft Dynamics CRM
MongoDB
.NET
Node.js
PHP
PostgreSQL
Python
QlikView
React.js
React Native
Ruby on Rails
Scala
Selenium
Spark
Spring
SQL
SQL Server
SSIS
Tableau
TypeScript
WordPress
Xamarin
Apache Tomcat
Bootstrap
CSS3
Git
Go
Golang
HTML
iOS
Mocha
Oracle database
Pentaho
Project Scheduling
Scrum
SQL Azure
SQL Programming
Unit Testing
Web Services
Sketch
User Experience Design
Angular 2x
Postman
Project management
Docker
DynamoDB
MariaDB
SQL query
InVision
Redux
Project Manager
Scrum Master
Maven
Spring Boot
Illustrator
Photoshop
Jest
Enzyme
Hadoop
Flutter
.NET Core
Figma
AWS Lambda
Firebase
Next.js
SEO
Power BI
AWS Glue
Pyspark
.NET Framework
Snowflake
SAP HANA

Industries

Architecture & Design, E-Commerce & Retail, Information services & Technologies, Construction & Real estate, Data Science & Machine Learning, Branding, design, web development

Want to hire this engineer?

Check if Edwin Frederick is available