Utilized the Sassy for code modularity and enhanced maintenance.
React.js
Sass
Bulk Signature Automation
Developed a desktop application using C# .NET for the frontend and Python-based command-line tool for the backend to handle PDF signing.
Built Python-based command-line tool to automate PDF bulk signing, accepting user inputs such as folder containing PDFs, signature location and destination path via command-line arguments.
Streamlined the bulk signing process, significantly reducing manual effort and increasing efficiency.
Developed a landing page for the product "Clipboard" as part of a Frontend Mentor challenge, showcasing its features for tracking and organizing copied content across devices.
Utilized React.js with Vite for efficient development and implemented Tailwind CSS for responsive styling.
Integrated the AOS (Animate On Scroll) library to enhance user engagement with smooth scrolling animations.
React.js
Tailwind CSS
Vite
AOS
Consolidated Action Sheet Tool (CAST) 3D
Automates the extraction of row-based data from Excel register used in model review tracking into sheet-based data.
Generates new sheet from a predefined template for each row, populating it with relevant data and iterating through the entire register.
Embeds associated images into each sheet, which involves handling formatting and placement challenges.
Streamlines documentation for engineering model reviews by producing structured, consistent action sheets.
Developed e-commerce ordering system using Next.js framework with Chakra-UI.
Integrated with Stripe API in test mode to mock receiving payment from users.
Utilized Cloudinary for uploading and storing CDN images.
Next.js
Chakra-UI
Stripe API
MySQL
Webhook
Engineer CV Submission Workflow Automation
Designed a Microsoft Forms-based submission system for engineers to upload CVs, certificates, and personal information for client review and resource planning.
Automated the organization of submitted files using Power Automate, categorizing them by discipline and file type.
Implemented logic to transfer files from OneDrive to structured SharePoint folders, ensuring centralized access and improved traceability.
Supported internal resource coordination by ensuring submitted data and documents were efficiently organized and readily accessible for client submission and manhour planning.
Created pixel perfect website from Frontend Mentor challenge.
Used SCSS to create modular and maintainable styles, enhancing the design and responsiveness of the application.
Sass
Node.js
PDF Comments Text Extraction
Implemented a robust PDF extraction desktop application.
Efficiently extracted metadata and comments from PDF documents using PyMuPDF to streamline reporting tasks.
Provided a user-friendly interface from Tkinter for selecting and processing PDF files.
Generated detailed Excel and Word reports (using Python-docx and OpenPyXL) to organize and analyze extracted data.
Python
Tkinter
OpenPyXL
PyMuPDF
Python-docx
SACS Static Analysis Result Compilation Automator
Developed a Python-based desktop application using PyQt6 to streamline the processing of Bentley SACS Listing Files.
Utilized pandas, NumPy and OpenPyXL to efficiently manipulate data.
Integrated Active Directroy authentication to ensure secure access and compliance.
Python
PyQt6
pandas
NumPy
Python-docx
OpenPyXL
Schedule Report Generator
Developed a scheduling analysis tool using Python Tkinter and Pandas to help project managers track and analyze task delays and deviations from the baseline schedule.
Calculates task delays and schedule deviations by incorporating lag, delay, and task relationships to identify critical path tasks and generate reports.
Outputs the analysis results in an organized Excel file, providing a clear, tabulated view of delays and baseline discrepancies.
Developed a dashboard-style website using HTML5 and Sass to present key statistical data, offering users a clear overview of important metrics.
Leveraged modern web technologies to enhance the interface and improve usability for straightforward data display.
HTML5
Sass
Technical Peer Review (TPR)
Developed a desktop application that digitizes and streamlines the original Excel-based peer review form, ensuring consistency and centralized data management.
Integrated with a shared network drive using MS Access as the backend database, enabling real-time data synchronization across multiple users.
Embedded Excel export functionality that dynamically generates project-specific reports using a custom-built template within the application.
Enhanced data integrity and version control by eliminating offline Excel file dependencies and centralizing form submissions.
C#
.Net Core
Windows Presentation Foundation (WPF)
Transmitted Comments Bot Script
Simplifies feedback tracking from Aconex exports by automating comment aggregation across multiple documents.
Scans multiple folders containing project files and identifies Excel documents based on specific filename prefixes.
Copies relevant Excel files locally for processing, excluding unrelated or non-matching files
Extracts comment data from each Excel file and consolidates it into a single master Excel sheet for centralized review.