.Net Developer Human Resources

JOVEN VILLESTAS

Jamaica, NY *****

929-***-****, ****************@*****.***

Summary

I am a Freelance Software Developer and Consultant with over 25 years of extensive experience in full- stack development. Throughout my career, I have created systems tailored to the unique needs of industries such as Finance, Distribution, Warehousing, Manufacturing, Payroll, Scheduling, Human Resources, Automated Blogging SEO, GPS Tracking, and QuickBooks Pro Accounting Interface Programming.

I am proficient in a wide array of client-server development tools, including .NET, C#, Visual Basic

(4.0/5.0/6.0), ASP.NET, ActiveX components, DLLs, ADO, OLE DB, Crystal Reports, MS Access, XML, HTML, Java, JavaScript, VBScript, and Sybase Database Administration tools on the Sun Solaris Unix platform. Additionally, I have experience in database management using MySQL on Red Hat/Ubuntu Linux and Microsoft SQL Server in a Windows NT server environment.

Technical Skills

Hardware: PC x86/Pentium & other compatibles, Compaq Proliant Srvr 2500, Sun Sparc Center 2000E, IBM E Server X Series 305, Sun SunFire MX Blade, MacBook Pro, MC3090-GU0PPCG00WR – Barcode/Pc Reader

Operating System: Windows Ver x.x, Windows NT, Novell, Sun Unix OS, Red Hat Linux 8.0, Solaris 10, Mac OS/Leopard, Ubuntu Linux x.x

Language: MS Visual Studio, .NET, C#, Visual Basic XX, VB.NET, MS Access Basic XX, Sybase Transact SQL 10/11 ver., MS Transact SQL T-SQL 7.0, FoxPro XX, VbScripting, Sun Java, Sun OS Unix(Shells) Programming, Perl 5.0, PHP ver.xx

Database: MS Access Database ver.xx, Microsoft SQL Server 7.0, Sybase 10/11, MySQL ver.xx Networking: ODBC ver.xx, JDBC, OLE DB, ADO, DCOM, COM, MS Internet Information Server 4.0, TCP/IP, FTP, Apache Web Server

Others: Crystal Report ver.xx, ASP, HTML, MS Office xx, Lotus SmartSuite, XML, VbScripting, Adobe CS4, Accounting/Bookkeeping utilizing QuickBooks Pro Desktop and Online version,.. Joomla (Content Management System), Microsoft Azure Studio etc..

Work History

1. Job Title: Programmer/Developer

Client: NNJEMS New Jersey – (Remote Assignment, On Call) Project: EMS Upload & GPS Emergency Vehicle Tracking System – Reporting System/ SQL Database Real Time DB Updates & XML Conversion

Environment: MS Visual Studio, .NET, C#, Visual Basic 6.0, Crystal Report x.xx, MS Access xxx, MySQL 4.1/5.0/6.0, Windows Server, Active X Control, PHP 5.0, Ubuntu Linux 10., Microsoft SQL Server

Duration of Project: ( July 2015 – Present )

Description: I developed and maintain a real-time application/utility that operates 24/7. This system migrates tables from the EMS GPS Microsoft SQL Database, dynamically converting them into XML files based on specified criteria. The XML files are then transferred remotely to a MySQL database and uploaded via FTP to a designated remote file system/location.

2. Job Title: Programmer Developer (On call - Remote) Client: UP HIGH CAPITAL MANAGEMENT INC. / MCS, New York, NY

Project: UPHIGH INTERPRISE SOLUTION SYSTEM

Environment: MS Visual Studio, .NET, C#, Visual Basic 6.0, Crystal Report 9.0, MS Access xxx, MySQL 4.1/5.0/6.0, Windows XP, Active X Control, PHP 5.0, Ubuntu Linux 10., Microsoft SQL Server

Duration of Project: ( Jan 2020 – Dec 2023 )

Description: Developed a Client/Investor/Properties Maintenance & Investment Tracking System

3. Job Title: Programmer/Developer

Client: DORN (Division One Restoration Network) Inc., Long Island, NY

Project: SEO/Blogging Software & Web Development

Environment: MS Visual Studio, .NET, C#, Visual Basic 6.0, Crystal Report 9.0, MS Access 2000, MySQL 4.1/5.0/6.0, Windows XP, Active X Control, PHP 5.0, Ubuntu Linux 10., Netbeans x.xx, Java

Duration of Project: ( Nov 2011 – Dec 2013 )

Description: I worked on coding and enhancing the existing system to accommodate various website XML requirements. The system, running across multiple virtual machines, automatically generated marketing blogs and write-ups in real-time. Additionally, I maintained and implemented coding upgrades to the company's PBX Asterisk system.

4. Job Title: System Analyst / Developer - Part time

Client: MRP Business Solutions/Rosado Accounting Services, New York, NY

Project: Payroll Processing /Client Profile System Development & QuickBooks Interface Program etc..

Environment: MS Visual Studio, .NET, C#, Visual Basic 6.0, Crystal Report 9.0, MS Access 2000, MySQL 4.1/5.0/6.0, Windows XP, Active X Control, PHP 5.0, Ubuntu Linux 10., Sun Solaris 10, Netbeans x.xx, Java, QuickBooks SDK

Duration of Project: ( May 2011 – Present )

Description: I developed the system from the ground up, handling everything from server and database configuration to C# coding, testing, and integrating with live data. The system is now fully operational and is being used for scheduling, payroll, and invoice processing.

5. Job Title: System Analyst / Developer

Client : Rappha Health Care inc., Miami, Florida

Project: Rappha Enterprise System Ver. 1.0.0/2.0.0

Environment: MS Visual Studio, .NET, C#, Visual Basic 6.0, Crystal Report 9.0, MS Access 2000, MySQL 4.1/5.0/6.0, Windows XP, Active X Control, PHP 5.0, Red Hat Linux 8.0., Sun Solaris 10, Netbeans x.xx, Java Duration of

Project: (March 2003 Nov 2011 )

Description: I was responsible for setting up the entire network system, including server, operating system, and database configurations, as well as handling the cabling. I performed software analysis and coding, developing modules for Human Resources, Scheduling, Payroll, Accounting, and reporting. Later, I upgraded the system by migrating it from VB 6.0 to .NET C#, and I wrote reusable classes to streamline the code, improving both efficiency and productivity.

6. Job Title: VBDeveloper / Analyst

Client: Burger King Corporation, Miami, Florida

Project: ProcRepExe (HTML Reporting)

Environment: Visual Basic 6.0, Crystal Report 7.0, MS Access 97, MS SQL Server 7.0, Windows NT,Windows 98, Active X control, XML, Vbscript, HTML

Duration of Project: (Jan. 2001 – To Apr. 2001)

Description: I developed a project module for the POS Compris System, intended for use across all restaurant locations. This module is an executable that generates XML data sources by extracting data from the OLE server (Btrieve) via an ActiveX control, enabling the creation of HTML-based reports such as "The Top 20 Items" and "Trend Report." The program manages XML files and operates as part of the daily end-of-day processing. My responsibilities included designing and coding the module using Visual Basic, VBScript, XML, HTML, and various custom classes.

7. Job Title: VBDeveloper / System Analyst

Client: Lazurde Group For Industrial Investment, KSA

Project: Order Mgt/Design Tracking System (Marketing)

Environment: Visual Basic 6.0, Crystal Report 4.0, MS Access 97, MS SQL Server 7.0, Windows NT,Windows 98

Duration of Project: (Mar. 2000 July 2000)

Description: Developed a system with a job scheduling mechanism and a design tracking flow, networked to all approvers and panelists before triggering the production of a sample model. As a VB Developer, my involvement included gathering system requirements, preparing the workflow as approved by the user, defining subroutines and functions to be used in the program, and establishing naming conventions. For reporting, I utilized Crystal Reports integrated with a report writer ActiveX component to dynamically generate the required reports. Additionally, I handled database configuration, including the creation of tables and fields for the system.

8. Job Title: VB Developer / System Analyst

Client: Lazurde Group For Industrial Investment, KSA

Project: Lazurde Gold Price Analysis Web Reporting (Intranet Prototype)

Environment: Visual Basic 6.0, ASP, VbScripting, HTML, Sun Java, MS SQL Server 7.0, Windows NT, Windows 98

Duration of Project: 3 Months (Dec. 1999 Feb 2000)

Description: I developed an intranet web reporting system that included interactive graphs and a data entry form for storing and displaying daily historical data on gold and silver prices, exchange rates, and stock market trends. I wrote the VBScript for the ASP functionality and used FrontPage 2000 to design the web pages. To dynamically display the graphs, I developed an applet using Sun Java (JDK 1.2). Additionally, I created and managed the system’s data maintenance features using Visual Basic.

9. Job Title: VBDeveloper / System Analyst

Client: Lazurde Group For Industrial Investment, KSA

Project: Payroll Management System (MS Access / SQL Server Version) HRMS Module Environment: Visual Basic 6.0, Crystal Report 4.0, MS SQL Server 7.0, MS Access 7.0, Windows NT, Windows 98

Duration of Project: 9 Months (Feb. 1999 Nov. 1999)

Description: I developed a system that automates payroll preparation and processing by referencing data from the HRMS database. The system generates various reports and prepares the bank file for submission to the bank. My role involved key tasks such as defining the logical flow, setting up and configuring the database, and writing subroutines and functions to facilitate the downloading and processing of the data. Additionally, I handled upgrades to the system, including migrating to MS SQL Server for database setup and configuration, and implemented necessary enhancements to improve functionality.

10. Other Experience: I.T. Lecturer, Informatics Computer Institute, Manila, Philippines. Conducted both classroom and corporate on-site training for various programming courses, including Visual Basic 4.0-6.0, Microsoft Access 7.0, FoxPro 2.5, and Financial Bookkeeping/General Accounting.

Education: Bachelor of Commercial Science Major in Computer Science, Cum Laude 1995 Jose Rizal University (JRC) (Manila, Philippines)

Trainings Acquired:

Fundamental Of Solaris

Shell Programming

Sun Java Programming

SQL Conversion Workbench (DB2)

Contact this candidate