SUMMARY PROFILE

Software developer using .NET platform, ASPNET, MVC, EntityFramework, Ajax, Net Core, SQL Server, Javascript, Jquery, Xamarin-Forms and C#.

I have over 17 years of software development experience in C# .NET, SQL Server, Visual FoxPro for Oil and Gas Company, parking services, transportation, tourism and education. This table outlines my knowlegement in different languages and technical areas. Last technologies used: Net Core 3.1, SQL, SIGNALR, and WEBRTC.

Skills (last 5 years)

No. of Years

Proficiency

4

3

2

1

Programming Languages/Development Tools and technologies / Platforms

C# .Net VS 2010- 2019/ LINQ TO SQL / Entity Framework, ADO, ASP.NET MVC., MVVM, XAMARIN, AZURE, AWS.SQS, AWS.S3 jQuery/JavaScript, JSON,WEBRTC – SIGNALR

4

*

.NET FRAMEWORK. ASP Net CORE

5

*

Reporting services - Report Viewer 8.0-9.0-10

4

*

PATTERNS: SINGLETON, VALUE OBJECTS (VO), DAO, DALC, MVC, DI(IoC), unit of work, Repository pattern, MVVM, AutoMapper.

4

*

Visual FoxPro 9.0 – OLEBD, ODBC.

10

*

PL/SQL

6

*

ANDROID DEVELOP (Android Developer Tools Build: v22.0.1-685705),

1

*

XAMARIN.FORMS

2

*

Internet HTML / JavaScript / CSS / AJAX / JQuery /

5

*

WCF (web services) C# 2008 –2010 framework 3.5 SOAP

1

*

WEB API over AZURE. Or IIS

1

*

Databases

Microsoft SQL Server (2005, 2008, 2012-2017) - Install, configuration and develop (Store Procedures, Functions, constraints and triggers).

Database Design (Tables, Views, Relationships)

9

*

SQLITE within Xamarin environment

2

*

Miscellaneous

Internet Tools (browsers, ftp clients like Filezilla, mail and so on.), WinMerge, mind manager, DBComparer.

10

*

Internet Information Server IIS (60.0 / 7.0)

5.5

*

Office Applications (MS Office, Visio, outlook)- Skype

10

*

Project Management (MS Project)

1

*

UML – Visio technical documentation

2

*

Database Administration Tools (SQL management studio)

9

*

Virtual PC – SUN Virtual Box, VMWare 8.0,9.0, Hyper-V

2

*

Winrar / TeamViewer, Fiddler4, pencil evolus, Balsamiq mockup, postman etc.

4

*

Operating Systems

Windows (versions 8.1, 7, XP, 10) installation / configuration.

13

*

I have been in charge of project individual components as well as complete projects working through the full software development life cycle. I have worked with a waterfall methodology and as well as Agile projects, specifically with scrum as a development team member.

In addition, I have worked with both technical teams and end-users. Recently I take certified as Scrum Master with Scrum Alliance Organization.

RELEVANT EXPERIENCE

INTERNATIONAL TRANSLATORS INC. – GreenBay WI, USA (20/04/2017- current) – supply software services as freelance Developer. (https://itinterpreters.com)

Roles (.Net developer – C# Software supplier)

Project 1: Develop an AUTOMATIC EMAIL SENDER SYSTEM.

Project 2: Develop a Video Chat Service (currently in development process).

Gathering information and requirements from company.

System analysis and design:

Application Logical architecture that include: Defining classes, interfaces and objects needed, web services, business rules, user s role and projects in solution

Database design (tables, relations, stored procedures, constraints, user functions, triggers, index files and backup and maintenance jobs)

Design and develop user interface, and functionality.

Write C# code (Classes and UI functionality, interfaces, hierarchical classes, client s validation rules)

Write SQL SERVER 2014 stored procedures and functions

Work in all software life cycle (SDLC).

Tools and Technologies Used.

Visual Studio 2017-2019, C# MVC, SQL Server 2014, JQuery, Ajax, Json, ASPNET, Entity framework, SQL Server.).

I am using following technologies:

.NET CORE, MVC, WebRTC, SIGNALR, EF Code First, MVC 5.

SHAREIT S.A.S. (20/04/2019- 20/06/2019) – supply software services as freelance Developer with Xamarin Forms

Roles (.Net developer XAMARIN.FORMS – C# Software supplier)

Project 1: To Develop a MOBILE APP. (developed to public users: all those interested in sports issues).

System analysis and design:

Application Logical architecture that include: Defining classes, interfaces and objects needed, web services, business rules, user s role and projects in solution

Application physical architecture that include: Publish web site, API services, files distribution, database location and connection type.

Design and develop user interface, and functionality.

Write C# code using XAMARIN.FORMS (Classes and UI functionality, interfaces, hierarchical classes, client s validation rules)

Write SQL SERVER 2014 stored procedures and functions

Write .NET CORE API (data services) (MVC )

Publish all solution on Azure

Work in all software life cycle (SDLC).

Tools and Technologies Used.

Visual Studio 2017, C# XAMARIN.FORMS, pattern MVVM, SQL Server 2014, Repository and Unit of work patterns, JSON, Visual Studio Team Services, TFS, JIRA, GIT, PostMan, Genymotion emulator, and SQlite. Net CORE, Azure, Prism,

MULTIFOX. (01/02/2018- Current) – supply software services as freelance developer

Roles (.Net developer – C# Software supplier)

Project 1: Develop a WEB APPLICATION TO MANAGE PROJECTS FACTIBILITY.

Project 2: Develop a PAYROLL MODULE FOR THEIR ERP SYSTEM.

Gathering information and requirements from company (starting from a previous FoxPro version).

System analysis and design:

Application Logical architecture that include: Defining classes, interfaces and objects needed, web services, business rules, user s role and projects in solution

Database design (tables, relations, stored procedures, constraints, user functions, triggers, index files and backup and maintenance jobs)

Design and develop user interface, and functionality.

Write C# code (Classes and UI functionality, interfaces, hierarchical classes, client s validation rules)

Write SQL SERVER 2014 stored procedures and functions

Work in all software life cycle (SDLC).

Tools and Technologies Used.

Visual Studio 2017, C# MVC, SQL Server 2014, Repository and Unit of work patterns, JQuery, Ajax, Json, Visual Studio Team Services, ASPNET, Entity framework, SQL Server, JQUERY, LINQ, JSON, AJAX Etc.).

I am using following technologies:

Unit of work, Repository patterns, Automapper, EF Code First, WebApi 2.0, MVC 5.

DICHTER & NEIRA S.A.S. (20/04/2018- 31/03/2019) – Xamarin Developer

Roles (.Net developer XAMARIN.FORMS – C# Software supplier)

Project 1: To Develop a MOBILE APP. (developed to consume Rest services and persist and present the data read in Json format).

System analysis and design:

Application Logical architecture that include: Defining classes, interfaces and objects needed, web services, business rules, user s role and projects in solution

Application physical architecture that include: Publish web site, files distribution, database location and connection type.

Design and develop user interface, and functionality.

Write C# code using XAMARIN.FORMS (Classes and UI functionality, interfaces, hierarchical classes, client s validation rules)

Write SQL SERVER 2014 stored procedures and functions

Work in all software life cycle (SDLC).

Other activities.

Support to a .Net Core Solution with AWS.SQS and AWS.S3. Jira,

Scrum team member as developer

Tools and Technologies Used.

Visual Studio 2017, C# XAMARIN.FORMS, pattern MVVM, SQL Server 2014, Repository and Unit of work patterns, JSON, Visual Studio Team Services, TFS, JIRA, GIT, PostMan, Genymotion emulator, and SQlite.

UNIVERSIDAD SERGIO ARBOLEDA. (30/10/2017- 2018) – Academic Services

Roles (.Net developer – C# Software supplier)

Project 1: To Develop a MOBILE PLATFORM SERVICES. (APPLICATION ORIENTED TO PROVIDE INFORMATION SERVICES FOR STUDENTS AND TEACHER, TAKING DATA FROM SAP backend RESTful API’s.)

Gathering information and requirements.

System analysis and design:

Application Logical architecture that include: Defining classes, interfaces and objects needed, web services, business rules, user s role and projects in solution

Application physical architecture that include: Publish web site, files distribution, database location and connection type.

Database design (tables, relations, stored procedures, constraints, user functions, triggers, index files and backup and maintenance jobs)

Design and develop user interface, and functionality.

Write C# code using XAMARIN.FORMS (Classes and UI functionality, interfaces, hierarchical classes, client s validation rules)

Write SQL SERVER 2014 stored procedures and functions

Work in all software life cycle (SDLC).

Tools and Technologies Used.

Visual Studio 2017, C# XAMARIN.FORMS, pattern VVM, SQL Server 2014, Repository and Unit of work patterns, JQUERY, AJAX, JSON, Visual Studio Team Services,

UNIVERSIDAD SERGIO ARBOLEDA. (01/04/2017- 10/10/2017) – Academic services

Roles (.Net developer – C# Software supplier)

Project 1: Develop an WEB APPLICATION TO MANAGE VISITOR’S INFORMATION.

Gathering information and requirements from security department.

System analysis and design:

Application Logical architecture that include: Defining classes, interfaces and objects needed, web services, business rules, user s role and projects in solution

Application physical architecture that include: Publish web site, files distribution, database location and connection type.

Database design (tables, relations, stored procedures, constraints, user functions, triggers, index files and backup and maintenance jobs)

Design and develop user interface, and functionality.

Write C# code (Classes and UI functionality, interfaces, hierarchical classes, client s validation rules)

Write SQL SERVER 2014 stored procedures and functions

Work in all software life cycle (SDLC).

Tools and Technologies Used.

Visual Studio 2017, C# MVC, SQL Server 2014, Repository and Unit of work patterns, JQuery, Ajax, Json, Visual Studio Team Services,

Project 2: Develop a hybrid mobile APPLICATION TO MANAGE REQUESTS FOR TECHNICAL SUPPORT. Mobile application to android and AIOS devices.

Gathering information and requirements from security department.

System analysis and design:

Application Logical architecture that include: Defining classes, interfaces and objects needed, web services, business rules, user s role and projects in solution

Application physical architecture that include: Publish web site, files distribution, database location and connection type.

Database design (tables, relations, stored procedures, constraints, user functions, triggers, index files and backup and maintenance jobs)

Design and develop user interface, and functionality.

Write C# code (Classes and UI functionality, interfaces, hierarchical classes, client s validation rules)

Write SQL SERVER 2014 stored procedures and functions

Work in all software life cycle (SDLC).

Tools and Technologies Used.

Visual Studio 2017, C# MVC, SQL Server 2014, Repository and Unit of work patterns, JQuery, Ajax, Json, Visual Studio Team Services, ASPNET, Entity framework, SQL Server, JQUERY, LINQ, JSON, AJAX Etc.) I am using following technologies:

Unit of work, Repository patterns, Automapper, EF Code First, first DevOps concepts, WebApi 2.0 XAMARIN, SignalR, SQLDependency, MVC 5.

PROJECTS ON TRACK S.A.S (October 2012 – March 2013) – Technical services

Roles (.Net developer – C# Information Systems Programmer)

To develop an application for management SOD in SAP, Users and roles, make the SOD analysis.

Gathering information, analysis and application develop.

SQL Server 2010 database structure definition.

Design and implementation of SQL server store procedures –Inserts, update and queries.

At moment, right now, I am developing a pay sheet system.

In addition to activities and technologies used on previous developments (and AZURE as platform to publish the application).

ORGANIZACION TERPEL S.A (June 2007 – 2014) – Oil and Gas

Roles (SQL server, .Net Consultant – C# Information Systems Programmer, Android developer and VFP application developer)

Gathering information, analysis and design, and develop an application for about 160 users (gas stations).

My last work (January 2014) was to develop an application using C#, MVC4 pattern and SQL Server 2012 database engine.

Support and maintenance VFP 9.0 application: Database maintenance in each oil/gas station (rebuilds index files, review data integrity, validation database structure, review table’s relationships and update ODBC connections).

SQL Server 2005-2008 store procedures develop and maintenance.

Develop, support and maintenance web ASPX C# 2010 .Net application: The project objective was to migrate the first version (VFP) to a new version with web access technology, also saving operation s data in a central SQL Server database.

Database design (table structures, indexes files, relationships, store procedures, user functions and triggers). In addition, defining maintenance plans, backup, and restores types.

Design software architecture (logical and physical), which include defining projects to be implemented in solution, defining class’s location, methods, attributes and class s visibility.

Database server sizing (defining hardware server configuration and software needed, calculate database s growth per year).

Coordinate and review documentation (technical and user) UML. Review process to create manuals for end user (application operation) and technician user (Installation, configuration, technical manual).

End user training for new software features.

Write technical documentation showing:

The database structure (tables structure, index files, software architecture, files distribution, ODBC version). E-R model, Data Dictionary.

How to use the installer media.

How to configure database connection (ODBC driver)

How to configure the .INI file (Configuration file)

Training end user on software operation.

Testing software functionality like data entry validation, data integrity and operation s flow.

ROYHER LTDA (April – September 2014) – Technical Services

Roles (SQL server, .Net Consultant – C# MVC4 application develop team manager)

Gathering information, analysis and design and develop an application for about 40 users (Consolidate NIIF information).

SQL Server 2012 store procedures develop and maintenance.

VMWare 8.0

Database design (table structures, indexes files, relationships, store procedures, user functions and triggers). In addition, defining maintenance plans, backup, and restores types.

Design software architecture (logical and physical), which include defining projects to be implemented in solution, defining class’s location, methods, attributes and class s visibility.

Calculate database s growth per year.

Coordinate and review documentation (technical and user) UML. Review process of creating manuals for end user (application operation) and technician user (Installation, configuration, technical manual).

Write technical documentation that shows:

The database structure (tables structure, index files, software architecture). E-R model, Data Dictionary.

How to use the installer media.

How to configure the .INI file (Configuration file)

CARREÑO TOURS LTDA. (01/06/2011- 2016) – Tourism Services

Roles (.Net developer – C# Software provider)

Develop an application to manage hotel’s bookings.

Gathering information and requirements from operation area and sales.

System analysis and design:

Application Logical architecture that include: Defining classes, interfaces and objects needed, web services, business rules, user s role and projects in solution

Application physical architecture that include: Publish web site, files distribution, database location and connection type.

Database design (tables, relations, stored procedures, constraints, user functions, triggers, index files and backup and maintenance jobs)

Design and develop user interface, and functionality.

Write C# code (Classes and UI functionality, interfaces, hierarchical classes, client s validation rules)

Write SQL SERVER 2008 stored procedures and functions

Work in all software life cycle (SDLC).

PROJECTS ON TRACK S.A.S (October 2012 – March 2013) – Technical services

Roles (.Net developer – C# Information Systems Programmer)

To develop an application for management SOD in SAP, Users and roles, make the SOD analysis.

Gathering information, analysis and application develop.

SQL Server 2010 database structure definition.

Design and implementation of SQL server store procedures –Inserts, update and queries.

NetPartnerts Ltda- INDRA - ECOPETROL (11/25/2011- 10/Feb/2012) – Oil and Gas services

Roles (.Net developer – C# Information Systems Programmer)

Allegro system s maintenance. Develop of graphics Reports from SQL server to Excel.

VB for Excel develop to graph SQL information.

CITYPARKING S.A. (04/02/2010 - 01/02/2013) – City Parking services

Roles (.Net developer – C# Software provider)

Application Logical architecture that include: Defining classes, interfaces and objects needed, web services, business rules, user s role and projects in solution

Application physical architecture that include: Publish web site, files distribution, database location and connection type.

Database design (tables, relations, stored procedures, constraints, user functions, triggers, index files and backup and maintenance jobs)

Design and develop user interface, and functionality.

Design and review software test plan

Write C# code (Classes and UI functionality, interfaces, hierarchical classes, client s validation rules)

Write C# biometric routines (Human ID, fingerprints)

Write SQL SERVER 2008 stored procedures and functions

Work in all software life cycle (SDLC).

Responsible for the development the software product.

EDUCATION

Universidad CIDE - Bogotá Colombia – Informatic Management Technician.

SCRUM MASTER CERTIFIED (Scrum Alliance 2019-04)

IELTS Academico (5.5)

Azure Self Study

Contact this candidate