Developed a full digital eSignature automation workflow for BIR 2316 documents by combining **Excel VBA, a C# processing engine, and Google Apps Script** into one integrated solution. The project transformed a manual document signing process into a faster, more controlled, and traceable digital workflow.

The system allows users to prepare and manage BIR 2316 records directly from Excel, trigger automated processing through a C# engine, and connect securely with a Google Apps Script web application where employees can review and sign their documents online. Signed records are then captured, tracked, and managed with improved accuracy and reduced manual handling.

This project demonstrates my ability to design practical business automation by combining multiple technologies into one seamless workflow. It highlights real world experience in **process automation, document digitization, web based signing, Excel system integration, backend logic, and user focused workflow design**.

✅ Built an end to end digital signing workflow for BIR 2316 documents

✅ Integrated Excel VBA, C#, and Google Apps Script into one automation process

✅ Reduced manual document handling and improved tracking visibility

✅ Created a user friendly signing flow accessible through a web interface

✅ Applied secure and structured data handling for employee document processing

✅ Designed the solution around real business needs, accuracy, and operational efficiency

QBiometric delivers real time fingerprint identification with a cinematic desktop experience, pairing reliable biometrics with a fast, modern WinForms UI. It gives operators crisp feedback and dependable results without sacrificing performance.

What it does

• Live capture, matching, and membership validation with instant visual cues.

• Neon fingerprint rendering with adjustable tint, brightness, zoom, rotation, and optional flip to mirror the device view.

• Red scan targets animate across real ridge structures during touch, then steady focus markers lock to the darkest ridges after a successful match.

• Transparent in app logging that fades older lines and snaps to nine preset placements, so messages appear printed on the interface.

• Hot swappable client logo loading from a folder with safe memory cloning.

How it is built

• C# 7.3 on Visual Studio 2022 for predictable performance on Windows 10 x64.

• DevExpress WinForms 25.1.x for polished UI components and layout.

• GrFingerX for sensor events and template handling.

• Custom GDI plus pipeline with double buffering that keeps the live fingerprint visible without flicker.

• Async ADO.NET with SqlDependency so new templates and status changes refresh in real time.

Key components

• FingerprintFx for neon color mapping with curve and lightness controls plus view transforms.

• TargetAnimator and TargetOverlayControl that draw inside PictureBox paint so effects never hide the live image.

• TransparentLogView, a true glass overlay with fade out, line cap, placement presets, and optional dim.

• DataService for reads, health checks, and policy aware punch logic.

• SessionManager for in memory template caching.

Tech stack

C# 7.3, WinForms, DevExpress 25.1.x, GrFingerX, SQL Server 2019, ADO.NET, GDI plus, async await, SqlDependency.

Simple and easily tracker manager-employee work hours and collaborate with your out-of-office employees. View employee time clock app comes with the right tools for non-desk employees. Clock in and out using with the GPS location stamp or Geofencing with maps display and now employees report when they work. The power of Geo-fence Ensure employees is in the work zone.

Designed and developed an enterprise level data integration automation workflow using **SSIS with C# scripting**, built with a dynamic and reusable approach to support multiple data sources, business rules, and integration scenarios.

The solution connected **Boomi, SharePoint, MS SQL Server, and SAP SuccessFactors** into a structured automation pipeline that improved data movement, validation, transformation, and synchronization across business systems. Instead of building a fixed process for one scenario, I leveraged a dynamic workflow design that allowed the integration logic to adapt based on source data, configuration, database rules, and target requirements.

This project demonstrates my ability to modernize enterprise workflows by combining **database automation, integration platforms, cloud document storage, HR system data, and custom C# logic** into a reliable operational solution. It highlights strong experience in system integration, backend automation, data processing, and business process optimization.

**Key Highlights**

✅ Built an SSIS based automation workflow enhanced with C# scripting

✅ Integrated Boomi, SharePoint, MS SQL Server, and SAP SuccessFactors

✅ Designed a dynamic workflow approach instead of a hardcoded process

✅ Improved data validation, transformation, and synchronization between systems

✅ Automated repetitive integration tasks and reduced manual intervention

✅ Created a scalable structure that can support changing business requirements

✅ Applied practical enterprise automation for real business operations

Designed and developed a customized **Biometric Employee Authentication System** that leverages **10 finger enrollment**, online authentication, and centralized employee access control to improve workforce monitoring and login security.

The system allows employees to enroll all 10 fingerprints for more reliable biometric identification, reducing failed authentication and improving identity verification accuracy. It also includes an online authentication workflow, enabling the system to validate employee access securely and consistently across the organization.

Beyond biometric login, the solution includes a manager controlled timesheet management module where authorized managers can monitor employee attendance, manage timesheet records, and block employees from logging in when required based on company rules or access restrictions.

This project demonstrates my ability to build secure, practical, and business focused systems that combine **biometric technology, employee access control, attendance monitoring, online validation, and management workflow automation** into one integrated platform.

✅ Built a biometric authentication system with 10 finger enrollment

✅ Improved employee identity verification and login reliability

✅ Implemented online authentication for controlled system access

✅ Created manager level control for timesheet monitoring and employee access

✅ Enabled blocking of employee login based on business rules or restrictions

✅ Reduced manual attendance tracking and improved workforce control

✅ Delivered a practical security and HR automation solution for real business operations

Designed and developed a specialized **Cashiering System for Sugar Mill Planters** to automate and control planter related financial transactions within a sugar milling operation.

The system was built to support cashiering workflows for planters, including transaction recording, payment processing, deductions, balances, settlement monitoring, and reporting. It helped replace manual cashiering activities with a more organized, accurate, and traceable digital process.

This project demonstrates my ability to understand real business operations, especially in industrial and agricultural environments, and convert complex manual workflows into practical software solutions. It reflects strong experience in **custom business system development, financial workflow automation, database driven processing, and operational reporting**.

✅ Developed a custom cashiering system for sugar mill planter transactions

✅ Automated manual cashiering and financial recording processes

✅ Improved accuracy, traceability, and control of planter related transactions

✅ Supported payment tracking, deductions, balances, and reporting

✅ Built around actual sugar mill business rules and operational requirements

✅ Reduced manual work and improved cashiering efficiency

✅ Delivered a practical software solution for a real production environment

Developed a custom Sugar Milling Production and Molasses Computation System using C# to automate laboratory based sugar output calculations and truck scale processing.

The system was designed to support sugar mill operations by capturing laboratory readings, processing sugar output data, and automatically estimating the number of sugar bags produced based on truck scaling results. This helped improve calculation accuracy, reduce manual computation, and provide faster production visibility for operational decision making.

The project combined laboratory data processing, production computation, truck weighing integration, and business logic automation into one practical system for a real industrial environment. It demonstrates my ability to understand complex operational workflows and convert them into reliable software solutions that directly improve productivity and accuracy.

✅ Built a C# system for sugar production and molasses computation

✅ Automated laboratory reading calculations for sugar output

✅ Integrated truck scaling logic to estimate sugar bag production

✅ Reduced manual calculation errors and improved processing speed

✅ Supported operational reporting and production monitoring

✅ Created a practical software solution for a real manufacturing environment

✅ Converted complex mill operations into an efficient digital workflow