Manuel Fernando Algaba Martinez (C# and VB.Net Software Developer)

Mobil:708-***-**** Email: adl1rr@r.postjobfree.com

PROFESSIONAL SUMMARY:

ERP On-Premise developer for 10 years.

Proficient in Object oriented programming(OOP) Self- directed, detail-oriented, and professional VB6, VB.Net and C# programmer with more than 20 years of experience in designing, developing, analyzing, and implementing Client-Server, Console Projects and Desktop-Based applications using VB6, VB.Net and C# languages.

Experienced in C# Lambda.

Experienced in C# ASP.Net MVC 5.

Experience in MS Test Unit.

Experience in Production Support.

Worked on Database design, Normalization, stored procedures, user defined functions, queries, views and triggers for data manipulation using SQL Server 2005/2008/2012/2014 & MS Access mdb and accdb.

Strong experience with SQL Server xxx and RDBMS concepts.

Expertise in full Software Development Life Cycle (SDLC)(Design, Development, Testing, IT Coding Deployment and maintenance).

Experience to build using event-driven architecture similar to Windows clients and hence on VB.Net and C# environment.

Strong understanding of HTML, CSS, Win Forms, WPF, Visual Studio, design and architectural patterns, and window services.

Ability to analyze and understand complex problems, and generate appropriate technical solutions independently.

Expertise in system designing as well as in testing, debugging and modifying related application code.

Strong use for more than 30 years of Microsoft Automation using Office different versions: Excel, Word, Access, Publisher, Power Point and, Outlook.

Extensive development experience on different IDE's like Eclipse3.x, 5.x, 7.x, Little Eclipse, Intellij.

Some experience and knowledge on Spring Boot with Java8.

Good experience in Version control using Git and BitBucket.

Capable of learn new programming languages and technologies and complete projects within specified deadlines.

Strong experience getting information from DCE (data circuit-terminating equipment or data communication equipment) through RS232 Db 9, Db 25 protocol or Parallel protocol.

Possess excellent communication, problem-solving, documentation, analytical, and decision solving skills.

Excellent to work independently and within teams, effective result-oriented team and interpersonal skills with a positive attitude towards work with adherence to time schedules and quality delivery.

Ability to grasp and apply new concepts quickly and stay updated with latest trends and technical advancements.

Experience processing Json files using Python, Read, Sort and Print Data.

Technical Skills:

.Net Technologies

Microsoft .Net Framework 1.0/1.1/2.0/3.0/3.5/4.0/4.5, C#.NET, VB.Net, Win Forms, ADO.NET, WPF, ASP.Net MVC 5

Languages

C#.NET 1.0/2.0/3.0/4.0, VB.Net, Python, SQL, PL/SQL, PowerShell, RPG II, RPG III

Operating Systems

WINDOWS 7/Vista/ XP/ NT /2003/2000/98, Windows 2003 Server

Web Technologies

XML, XSLT, XAML, CSS, DHTML, HTML5, IIS,ASP.Net MVC 5

Querying Languages/Reports

SQL, PL/SQL, Transact-SQL, Crystal Reports

Databases

SQL Server 2000/2005/2008/2012/2016, MS Access 97/2000.

Other Tools

Microsoft Visual Studio .Net 2005/2008/2010/2013/2017, MS Office, MS Visio.

Networking: TCP/IP, LAN, FTP, DNS, DHCP, IIS, Active Directory.

Visual Studio, Eclipse, Intellij, Notepad++, Atom. Json Files

Continuous Integration(CI/CD): Jenkins

PROFESSIONAL EXPERIENCE:

C# and VB.Net Independent Consultant.

March 2020– November 2020

Providing support to IT personnel in designing, developing, analyzing, testing, debugging, and executing C# programs for windows desktop using Win Forms and WPF applications.

Developing applications Client-Server using TCPIP communications.

Assisting project manager in defining detailed specifications for specific functionality requirements as well as analyzing, designing, and encoding new systems using C# language and VB.Net.

Preparing accurate reports to document design flaws and bugs as well as modifying existing software or system to correct errors and improve performance

Collaborating with other programmers and developers in the whole development process, and using structured analysis and design to determine steps to develop programs

Determining user requirements, including project budgets and timelines as well as providing consultative services to clients and project team members on technical issues

Mentoring and assisting with training of new and junior programmers as well as doing code reviews for other team members to ensure highest possible quality in software products

Researching and evaluating new development tools and software products to increase programming capabilities as well as creating written developers guides, and training users in system operations.

Create source document (UI) to be implemented using C# and WPF.

Create a WPF project.

Use WPF XAML to design the appearance of the application's user interface (UI).

Write code to build the application's behavior.

Create an application definition to manage the application.

Add controls and create the layout to compose the application UI.

Create styles for a consistent appearance throughout the application's UI.

Bind the UI to data, both to populate the UI from data and to keep the data and UI synchronized.

Using CI as a daily commitment, updating code repository including test code after finished the daily work and let Jenkins automation finish this task..

Verified that the build created in a CI/CD process is working accordingly to changes requires for the client and the test were fine.

Create Process using C# and Winform for consult information through Data Grid.

Create Process using C#, Winform and Data Grid to create and print invoices

Create Winform using C# to update Master File data on Desktop Environment accessing data from MS SQL Server.

Expertise with C# MS Automation Process linking Excel Work sheet, Word, Power Point, and Outlook.

Create print reports with C# and Winform through Excel or Word.

Create Menus Using C# and Winform.

Create different C# and Winform associating Pictures, Radio Buttons, Check options and Data Grid.

Create Consulting process using C# and Winform through Data Grid.

Create projects Console, Desktop, Front End using ASP.Net MVC 5

Create consulting process using Json files through Python; Read, Sort and Print Data.

Create MS Test Unit Project, add Test Unit Class to new process.

Production Support in diverse locations.

Create training and support guide

Environment: Windows 7, Windows 10, MSSQL, Office 2010, Office 2013, Windows Server.

Service Now Administrator and Desktop Support, Windows 7, Windows 10

Wipro (Contractor), Northern Trust Bank Chicago, Illinois

August 2019 - February 2020

Service Now Kingston Administrator, Service Now Madrid Administrator.

Follow up until to close, redirect or cancel Numbers of: Requests, Incidents, lost and missing computer assets.

Create PowerShell procedures to verified RAM computer memory don’t get stuck, check IP address.

Create PowerShell procedures to avoid frequently manual tasks.

Create PowerShell procedures to Image computers booting from server.

Follow up organizational goals, policies and procedures.

Support users by phone, email, Skype, remote access or face to face, To: Bank Building, Madison Building, LaSalle Building and Canal Building.

Check Wifi Web pages access work fine.

Remove computers and users from Active Directory using Remote Desktop Connection, change of domain and change rights of users, update Bitlocker Key

Replace Batteries to notebooks computers: DELL different models.(7420,7440,7450,7470,7480)

Replace docking station.

Add locals and Share printer’s different floors.

Image windows 7 Professional, windows 10 Enterprise

Deploy or replace Laptops Dell different models.(7420,7440,7450,7470,7480).

Install Microsoft Office 2010, Visual Studio, Microsoft Visio, Power BI. One drive.

Install Pace Audit, SAP, LaserPrint Software, Reader Adobe Acrobat DC, Reader Acrobat Professional, Symantec VP Acces, Bitlocker.

In charge of projects for deploy Monitors Dell 24” to Desktops and Laptops, between 6 to 42 monitors.

Update .Net frames.

Create share drives

Check backup of users to be updated.

Set up Cisco Conference Phones.

More than 232,000 users spread on USA and Europe.

Environment: Windows 7, Windows 10, Oracle, Citrix, Office 2010, Office 2013, Windows Server xxx

C# and VB.Net Independent Consultant.

January 2019– July 2019

Migrating system Information from Vb6 to Vb.net and C#, and Python procedures

Follow up Json files.

Create Link web pages to automatize user task using: Google Chrome, Internet Explorer 11, HTML5, and CSS files.

Working in an Agile environment.

Using CI as a daily commitment, updating code repository including test code after finished the daily work and let Jenkins automation finish this task..

Verified that the build created in a CI/CD process is working accordingly to changes requires for the client and the test were fine.

Create complex SQL procedures on SQL 2012 R2

Create PowerShell procedures to avoid frequently manual tasks.

Create PowerShell procedures to Image computers booting from server.

Supporting applications running on Windows server OS applications, IIS Server.

Developed parameterized SSRS reports which were used for making current and future business decisions.

Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS.

Created SSRS functional reports for in-house tracking C# app.

Tested data exported from MS Access and imported into Microsoft SQL.

Create consulting process using Json files through Python; Read, Sort and Print Data.

Create projects Console, Desktop, Front End using ASP.Net MVC 5

Create MS Test Unit Project, add Unit Class to new process.

Production Support in diverse locations.

Environment: Windows 7, Windows 10, SQL 6.5, MS Access 2007, MS Access 2017,Office 2010, Office 2013, Windows Server 2018 R2

Desktop Support, Windows 7, Windows 10

Park Hudson (Contractor) North Shore Medical Center Skokie, Illinois

Nov 2018- Dec 2018

Drive around Illinois to branches of North Shore doing: Inventory of computer hardware in order to be updated, Check configuration of computers connected to Card Readers, Scanners and Zebra Label Printers second step project.

Assign MAC Layer in DHCP, Check IP Address, Change PC Name Old and New, Check EPIC Number.

Support users by phone, or by mail.

More than 3,500 users.

Using Update Service Management Intranet

Wrote a SQL based vacation and PTO accrual system with monthly and weekly posting of amounts earned and automatic increments of accrual rates based on hire date and associated reporting.

Create and maintain SSRS reports as Invoices and Monthly Summary Reports for clients.

Environment: Windows 7, Windows 10, Windows Server.

Desktop Support Windows 7 Professional, Windows 10 Enterprise.

VSOFT Consulting (Recruiter) IRI Worldwide Chicago, Illinois

Oct 2018- Oct 2018

Follow up ticket numbers.

Help users by phone, or face to face.

Check Batteries to notebooks computers: DELL different models.

Bios Upgrade, Image windows 7, Windows 7 patching, Windows 7 in place image.

Install: Global Protect, Symantec Endpoint Protection Small Business Edition, Upgrade Java, Citrix Receiver 4.1, Adobe Reader, Microsoft office 2013 32 bits, Office 365, CrashPlan, Step5, SCCM Setup and image, Beachhead.

Create Link web pages to automatize user task using: Google Chrome, Internet Explorer 11, HTML5, and CSS files.

Manage backup, security and user help systems.

Edit power plan to get the most logical benefits.

Develop and interpret organizational goals, policies and procedures.

Setting up PC computers, notebook computers, and printers; initializing and stabilizing performance.

Performing regular maintenance on PC equipment such as computers, notebook computers, printers; scanning computers for viruses.

Setting up conference rooms to use technology services (e.g. presentations, network

Providing inside/outside the building relocation of PC systems as needed..

Providing additional end-user technical support as needed.

Meeting and coordinating with other local Technology department members on product installation, training, and support.

Supporting applications running on Windows server OS applications.

Assisting with special projects on various issues as needed.

Promoting effective work practices, working as a team member, and showing respect for co-workers.

More than 500 users

Use scripting software to create projects to automate database posting in client and company systems, based on database information, as an enhanced productivity tool.

Environment: Windows 7, Windows 10, Windows Server.

C# and VB.Net Independent Consultant.

July 2018– September 2018

Providing support to IT personnel in designing, developing, analyzing, testing, debugging, and executing C# programs for windows desktop using Win Forms and WPF applications.

Developing applications Client-Server using TCPIP communications.

Assisting project manager in defining detailed specifications for specific functionality requirements as well as analyzing, designing, and encoding new systems using C# language and VB.Net.

Using CI as a daily commitment, updating code repository including test code after finished the daily work and let Jenkins automation finish this task..

Verified that the build created in a CI/CD process is working accordingly to changes requires for the client and the test were fine.

Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.

Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.

Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables and calculations.

Create consulting process using Json files through Python; Read, Sort and Print Data.

Create projects Console, Desktop, Front End using ASP.Net MVC 5

Create MS Test Unit Project, add Test Unit Class to new process.

Production Support in diverse locations.

Environment: Windows 7, Windows 10, MSSQL, Office 2010, Office 2013, Windows Server.

Desktop Support Windows 7 Professional, Windows 10.

Hexaware Technology (Recruiter) Assurant Chicago, Illinois

Apr 2018- Jun 2018

Follow up ticket numbers.

Help users by phone, Skype, Email or face to face.

Upgrade memory to notebooks computers: ThinkPad Lenovo and HP different models, Microsoft Surface Pro.

Bios Upgrade, Image windows 10, Windows 10 patching, Windows 10 in place image, windows 7 image.

SCCM Setup and image.

Install: Global Protect, BitLocker, 7-Zip, Upgrade Java, Zoom Client, Skype for Business 2016, Adobe Reader, MDM Enrollment, MAM Enrollment.

Computer inventory control using Office 365.

Remove computers and users from Active Directory using Remote Desktop Connection, change of domain and change rights of users.

Manage backup, security and user help systems.

Create shared drives.

Configure one drive in Azure.

Install and control of GoToAssist professional tool to assist remote users.

Update DLL of Excel.

Create Link web pages to automatize user task using: Google Chrome, Internet Explorer 11, HTML5, and CSS files.

Test connection to AS400.

Test Sales Force user s connection.

Edit power plan to get the most logical benefits.

Develop and interpret organizational goals, policies and procedures.

Remote communication with users from India, Australia, Colombia and Mexico.

Setting up PC computers, notebook computers, and printers; initializing and stabilizing performance.

Performing regular maintenance on PC equipment such as computers, notebook computers, printers, and auto-switches; scanning computers for viruses.

Setting up conference rooms to use technology services (e.g. presentations, network connections, and audio/visual); performing daily checks of conference rooms to ensure all equipment is working properly.

Maintaining an inventory of PC hardware equipment and software programs, track loaner equipment for distribution and recovery.

Providing inside/outside the building relocation of PC systems as needed..

Providing additional end-user technical support as needed.

Meeting and coordinating with other local Technology department members on product installation, training, and support.

Assisting with special projects on various issues as needed.

Promoting effective work practices, working as a team member, and showing respect for co-workers.

More than 2,800 users.

Fully serviced SQL Manager Services Intranet and Content Management Services.

Assist with testing and quality assurance activities with data extracts

Conducts performance tuning of existing data structures

Provide technical support for SSRS business applications, and Identifies critical integration issues and develop corrective solutions

Creates and maintains the logical and physical data models for the production area

Coding, building dimensions, matrices, pulling/creating reports, know components of SSRS

Environment: Windows 7, Windows 10, IBM AS400

Programmer Analyst C# and SQL

Ortiz Buildings Chicago, Illinois

Aug 2017- Feb 2018

Works with other developers and business analysts to develop and write applications systems and programs using C# technology and MSSQL RDBMS.

Ensures development of coding guidelines and best practices & standards, ensuring compliance to the developed coding standards from all developers on the team

Ensure quality by establishing and enforcing development standards

May assist the Application Manager (or Director) in the creation of project plans.

Collaborate with and takes direction from Technical Lead and subject matter experts in Contributes to the development of application standards & procedures, coding guidelines & best practices, and ensures compliance to the developed standards from all developers on the team

Develop and manage business plans to achieve objectives

Provides guidance and assistance to the applications users and support teams on all aspects of application deployment, training and support, including

Collaborate with a cross-functional team of business analysts, architects, developers, and technical managers to create a cohesive multi-year vision across teams and business lines

Participate in the development of business strategy

Solve unique and complex problems with broad impact on the business

Influence senior leadership to adopt new ideas, products, and / or approaches

Direct cross - functional and / or cross - segment teams

Deploy and maintain Applications / Systems

Translate highly complex concepts in ways that can be understood by a variety of audiences

Using CI as a daily commitment, updating code repository including test code after finished the daily work and let Jenkins automation finish this task..

Verified that the build created in a CI/CD process is working accordingly to changes requires for the client and the test were fine.

Developing reports using Microsoft SQL Server Reporting Services (SSRS) 2014 and supporting other analysts who use Report Builder Version 3.0

Developing and maintaining database stored procedures

Using SQL, developing stored procedures, views, triggers, tables, and other database objects

Writing complex T-SQ Work with customers to develop new report or data extract requirements, make changes to existing reports or data extracts and identify any errors in data output

Troubleshoot issues, determine root cause and provide solutions; SQL performance tuning

L queries including dynamic SQL

Design, create and test reports using SSRS

Create consulting process using Json files through Python; Read, Sort and Print Data.

Create projects Console, Desktop, Front End using ASP.Net MVC 5

Create MS Test Unit Project, add Test Unit Class to new process.

Get information from DCE (data circuit-terminating equipment or data communication equipment) through RS232 Db 9, Db 25 protocol or Parallel protocol.

Production Support in diverse locations.

Create training and support guide

Environment: Windows 10, Office, Windows Server

Programmer Analyst VB6, VB.NET, C#

Software Growing and More (SOFGRA) Guatemala City, Guatemala

Jan 2000-Jun 2017

ERP On-Premise developer for 10 years using MSAccess Data Base and Windows 10 Server.

ERP On-Premise developer for 10 years using MSAccess Data Base and Microsoft SQL Server.

ERP On-Premise developer for 10 years using MSSQL Data Base and Windows 10 Server.

ERP On-Premise developer for 10 years using MSSQL Data Base and Microsoft SQL Server.

Exceptional expertise in MS SQL Server.

Excellent knowledge of MS SQL database installation and configuration principles

Conducted MS SQL Server production database analysis on a regular basis.

Provided customer assistance and support pertaining to MS SQL database system queries and complaints.

Installed, administered and updated MS SQL database tools and systems.

Assisted with maintenance items as well as development in new projects

Designed and implemented services that handled sending text messages to subscribed users.

Wrote windows form desktop applications as requested by company's clients to show proof of concept

Flow Charted company's entire web application to fully understand for code maintenance

Created windows form desktop applications for new components to be ported and added to web application

Developed using OOP functionality including the creation of a task scheduler that will become the backbone of the back office functionality.

Developed an ophthalmologist module for exams.

Extended existing project by adding new modules to their leasing system while fixing defects and other basic enhancements using .Net, C# and SQL Server.

Added a REST service using C# and a MVC design.

Upgraded build from using Apex to use Red Gate and integrated data sync and report migration into the build

Implemented a read only feature into the system by extending the base class to consume a new interface.

Configure new SQL servers on both 64 bit and 32 bit

Helped my team adopt and implement agile methodology and practices based on prior experience.

Adopted the scrum master role for the past 2 releases.

Worked on automation of the Price Catalog Manager to manage the pricing and other attributes for products at hospitals. Automation eliminates the export/import process with excel sheets by providing a WPF interface for the Pricing team to update various products available at specific hospitals. Was responsible for requirement gathering, technical design and development for this project.

Worked on an EMR Data Terminology project which serves as a back-office setup for EMR hospitals. Was responsible for requirement gathering, technical design and development for this project.

Worked on the project to enable hospitals to offer annual wellness plans for pets. Was responsible for the requirements gathering, technical design and the development of the setup for wellness plans and also the wellness services catalog which can be configured in an individual wellness plan.

Worked on the development of the Medical History project for pets in hospitals to enable veterinarians to get an 'at-glance' view of the pet's medical condition and history.

Implemented performance improvements for e-mail service.

Develop UML and ER diagrams and manage MS SQL Server databases for web applications for individuals and businesses.

Utilize agile methods such as SCRUM to develop databases and web applications through the SDLC.

Create stored procedures, views, triggers, constraints, functions, indexes, relationships, entity relationship diagrams, queries, etc. for SQL databases using MS SQL Server 2005.

Develop using WCF to mitigate threats such as denial of service, malicious code execution, information disclosure, etc. within the web applications.

Develop using ADO.NET to create and modify entities, associations, mappings, and inheritance relationships.

Responsibilities included developing, designing, modifying codes and adding new modules in complicated and elaborated environmental modeling software(s) used by the organization.

Assisted with all aspects of product lifecycle, from planning, designing to development through elaborative meetings with various stake holders.

Used VB6, .NET, C# for scripting and MSSQL for database management and data mining.

Create MS Test Unit Project, add Test Unit Class to new process.

Proved myself to be a good team player and an excellent time manager by concluding all assigned projects on time as a part of the team.

Demonstrated loyalty towards the company with no absenteeism, lateness or no shows.

Effectively communicated to different origins of people and maintained sound relations with all.

Translating business requirements into well-engineered, tested and deployed application systems that are used by the business

Designing, developing, testing, installing, and deploying the required software applications.

Interface with internal customers to determine the most efficient and cost-effective approach to meet their business requirements.

Get information from Medical DCE (data circuit-terminating equipment or data communication equipment) through RS232 Db 9, Db 25 protocol or Parallel protocol.

Leading Offshore team and co-ordinating with onsite to deliver the requirements before deadlines.

Coding for Windows application with a design tool that balances and upload statements ready to release for customer.

Investigating and analyzing critical production problems and provide solutions for ongoing client requirements.

Designing application and database components for large-sized development projects.

Maintaining Coding Standard practices, high-quality code in .Net, C# and good normalization techniques with SQL and T-SQL.

Used MySql Workbench to query information related to client setups and for testing code.

Used Remote Desktop Connection (RDP) to login to our production server to ensure we sent the data to the client successfully.

Contacted the client via phone to verify if they're receiving the data as expected and if they're providing us with the correct field mappings.

Fixed Web development for share website and internal help desk system based on asp.net, C# and SQL server 2005.

Create projects Console, Desktop, Front End using ASP.Net MVC(Year 2014-2016)

Production Support in diverse locations year 2012-2016.

Create training and support guide.

Environment: Windows 95, Windows XP, Windows 7, Windows 8

Visual Basic 5 and 6 Programmer Free Lance.

Jan 1986-Dec 1999

Field: Hospital (Health care).

Programming in Microsoft Fox Plus multiuser under Novell Network 3.12.

Field: Car Fixed parts.

Programming in Microsoft Visual basic 5.0, Microsoft Visual basic 6.0 under Microsoft Access 2000 and Microsoft SQL Server 7.0, Microsoft Windows NT 4.0 and Microsoft Windows 2000 Network.

Supporting applications running on Windows server OS applications.

Create complex database queries using MS SQL Server.

Environment: Novel Server, Windows NT, DOS 12

Vice manager of IT

Almacenes Paiz Guatemala City, Guatemala

Jan 1979-Dec 1985

working under IBM S/36/AS400, my team work was 5 analyst programmers in RPG II, RPG III and covering different areas as follows:

Retail inventory.

Accounts payable.

Human resources

Accounting.

Banks.

Frequent buyer.

Environment: IBM S/34, IBM S/36, IBM AS400, IBM 1140, IBM 360, IBM 4341

Education:

Bachelor in Computer Sciences, emphasizing in Math, Statistics, Analysis and Programming. University Centroamericana, Managua, Nicaragua, Year 1984

References: Available upon Request

Contact this candidate