Modernise Legacy Reporting System

@shrec

Hello Nice to meet you I understood your requirement I think we can rebuild your app using MEAN or MEVN stack professionally Hope to talk with you Thank you

@tangramua

Dear ,   We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time.   We are 25 years in this business and our technical specialists have strong experience in Project Management, MySQL, Software Development, VB.NET, Continuous Integration, Technical Documentation, Database Management, Architecture, CI/CD and other technologies relevant to your project.   Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews.   Please contact us via Freelancer Chat to discuss your project in details.    Best regards, Sales department Tangram Canada Inc.     

@Feriver

Hello, I can modernize your legacy reporting system by rebuilding it with a clean, maintainable architecture. I will automate headless report generation from MySQL, replace brittle VBA macros with Python (using python-docx/openpyxl) or OpenXML/Aspose libraries, and structure Excel templates with clear input sections, named ranges, and validation. This ensures non-technical staff can confidently manage templates without risk. The solution will separate data extraction, template logic, and output generation, with version-controlled source code and a sensible commit history. Deliverables include a working prototype with sample reports, a documented Excel template, production-ready report module, a concise deployment guide, and a short walkthrough video demonstrating end-to-end flow. My approach emphasizes reliability, maintainability, and scalability while preserving existing business logic. Thanks, Asif

@Herculesz

Hi I can modernize your reporting system by replacing the brittle VBA-driven flow with a cleaner, maintainable architecture that separates data extraction, template mapping, and final document generation. The core technical problem is that report logic is currently trapped inside Excel/Word macros, which makes small changes risky, hard to test, and inaccessible to non-technical staff. My solution would be to keep the generation pipeline headless, preserve your MySQL queue workflow, and move template logic into structured VB.NET services or a VB.NET + Python reporting layer depending on which gives the best long-term maintainability. I have experience with VB.NET, MySQL, Excel/Word automation, OpenXML-style document generation, structured template design, and refactoring legacy reporting systems into readable, testable modules. I would redesign the Excel template with named ranges, validation, and clearly documented input zones so staff can safely update content without touching generation logic. The report engine would be built with modern code replacing VBA macros, while keeping source control, sensible commits, and deployment documentation as part of the deliverable. This approach gives you a stable reporting pipeline that is easier to maintain, safer to evolve, and much less dependent on fragile document-side automation. Thanks, Hercules

@abhisaini0188

My name is Abhishek and as a seasoned full stack developer with over 8 years of experience, I believe I am uniquely qualified to modernize your legacy reporting system. My expertise lies in developing smart, AI-powered applications which aligns perfectly with your need for a system that automates workflows and improves decision-making. In particular, my proficiency in Python and VBA sets me apart. Taking into account your intentions to either refactor or introduce a new python microservice gives us room for innovation. With my extensive background in machine learning integrations, AI APIs and database management (including MySQL), I can create efficient, headless report generation and a structural data pipeline that will make the new system significantly more user-friendly and scalable. One of the most important aspects of my work philosophy is delivering not just clean code, but clean solutions that directly impact business processes. You needn't worry about support after the job is done either - I ensure long-term commitment with all my clients. Let's talk further about how I weigh between options A and B in making this transition easier for your non-technical staff while maximizing efficiency.

@waqarinfo

Hello, I understand that you are looking for an experienced developer to modernize your critical internal reporting system. I specialize in VB.NET and database management and have extensive experience in rebuilding systems with cleaner architectures. To address your needs, I propose automating the report generation process by pulling data from the MySQL queue, creating a well-structured Excel template with clear input sections, and replacing VBA macros with modern, readable code. I will ensure a clean separation between data extraction, template logic, and output generation for easy maintenance and use by non-technical staff. I am confident that my expertise in VB.NET and database management will be instrumental in revamping your reporting system effectively. Let's initiate a chat to discuss your project in detail. Best regards, Waqar H.

@ivaylo8

Hi there, I’m Ivaylo, and I specialise in modernising complex document-generation pipelines. Your current VB.NET with Excel/Word templates and MySQL backend is stable, but the brittle macro layer is the real bottleneck. I’ll architect a clean, maintainable solution that eliminates VBA, isolates data extraction, template logic, and output generation, and provides a reliable, headless report service. Recommended approach: keep VB.NET orchestration surrounding a Python-based or OpenXML/Aspose-driven generation layer, depending on your preference. I’ll deliver a production-ready module that: - fetches data from MySQL queue automatically in a headless, repeatable way - uses a well-structured Excel template with explicit input sections, named ranges, and validation - replaces macro logic with readable, well-documented code - cleanly separates data extraction, template rendering, and output creation - ships with setup documentation, version-controlled source code, and a sensible commit history Deliverables include: a working prototype generating 1-2 sample reports, a documented Excel data template, a production-ready module, a single-page deployment guide, a 10-15 minute walkthrough video, and complete source in version control. I’m happy to discuss Option A or B and tailor the setup guide and CI/CD to your tooling. Best regards, Ivaylo

@matheussilva114

Hi, I have read your description and I fully understand your needs. I am a senior engineer with over 7 year of experience on Project Management, MySQL, Software Development, VB.NET, Continuous Integration, Technical Documentation, Database Management, Architecture, CI/CD. Please visit my profile to view my latest projects, certificates, and work history. Let's connect in chat to discuss more. Regards, Matheus

@sergiom17

Hi, I am a senior full-stack engineer with strong experience in reporting systems, document generation, data pipelines, and cleaning up legacy architectures without breaking what already works. This project is a strong fit for me because I’m comfortable stepping into stable but brittle systems and modernizing them in a way that makes future changes safer and easier. My recommendation would likely be Option B: keep VB.NET for orchestration if it’s already reliable, and move report generation into a clean Python service. That gives you a better long-term path for readable code, template handling, testing, and maintainability while minimizing disruption to the existing workflow. I can help you separate data extraction, template structure, and output generation properly, remove the VBA dependency, and deliver a documented Excel template your non-technical staff can work with confidently. I’d also provide the prototype reports, deployment guide, walkthrough video, and version-controlled source with a clean commit history. I focus on practical modernization, not unnecessary rewrites, so the end result is easier to maintain and safer to evolve. Looking forward to speaking with you. Sergio

@nemanjac6

Hi there, From your description, this involves a data‑driven reporting workflow, I’d approach it by separating extraction, transformation, and document generation into a clean service architecture. By restructuring the backend pipeline around MySQL queue processing and modular output handlers, we can eliminate the fragile VBA layer entirely. A key risk is the tight coupling between templates and logic, which can cause breakage when non‑technical staff update documents. I’ve delivered similar automated reporting engines using MySQL plus VB.NET/Python hybrids with clean template definitions. I’d break this into: - A headless generation service with APIs or scheduled workers pulling from MySQL and pushing structured data into Excel/Word templates. - A redesigned Excel template using named ranges and validated input sections, enforced by backend validation before output. - A modern document builder (OpenXML/Aspose or Python microservice) that cleanly maps data into templates without macros. A lightweight service boundary between orchestration (VB.NET) and generation logic improves long‑term maintainability. Which option fits better with your current infrastructure: a fully modernised OpenXML/Aspose .NET pipeline or introducing a Python microservice for the generation engine? Open to digging into this further. , Nemanja

@sadam61

Hi there, I've thoroughly reviewed your project and understand the importance of modernising your legacy reporting system. With over 9 years of experience in building scalable data pipelines and reporting tools, I am confident in my ability to cleanly refactor your system and improve its architecture. I propose building a Python microservice for report generation while maintaining the VB.NET orchestration. Switching to modern libraries like python-docx and openpyxl will make your reports more manageable and user-friendly for non-technical staff. I can start immediately and ensure a robust deployment process, complete with documentation and a guide for easy use. I’ve successfully tackled similar projects in the past, and I’m committed to delivering efficient, reliable results. Let's connect to discuss your specific needs further and outline the next steps!

@peterj514

Hi there, I know how painful it is when a trusted reporting system becomes a maintenance bottleneck. I’ve spent the last 4 years solving exactly this type of problem: modernising brittle, macro-driven templates into a clean, maintainable pipeline. I propose a headless, automated report generator that pulls from MySQL, with a well-structured Excel input template (clear sections, named ranges, and validation) and a fully readable code path that replaces VBA macros. The plan: assess the current data flows; design a clean separation between data extraction, template logic, and output; implement a replacement path (Option A: refactor VB.NET stack with OpenXML/Aspose for Word or Option B: VB.NET orchestration with a Python microservice); build a production-ready generator, 1-2 sample reports, and write concise setup docs. I’ll also add CI/CD-friendly sources and a short deployment guide, with a versioned repo and a 10-15 minute walkthrough video.

@stanislavk51

Hello, I am a Software Developer with over 10 years of experience in the VB.NET and MySQL field. I understand your need to modernize the internal reporting system. This upgrade will enhance reliability and reduce maintenance bottlenecks. I can help streamline the report generation process using modern techniques. The plan is to automate report generation while ensuring a clean architecture. I suggest refactoring your existing VB.NET stack and replacing Word macros with OpenXML SDK. This will provide a more robust structure for your reports. I’ll create a well-structured Excel template that non-technical staff can use easily. The deliverables will include a working prototype that generates samples, a documented Excel template, and a production-ready module for report generation. I will provide a user-friendly deployment guide and a video walkthrough to demonstrate the entire process. Thank you for reading my proposal to the end, and I sincerely hope to work on this project with you.

@Lazarone1

Hi, that’s great to hear! Your project closely aligns with one I recently worked. In that project, I built a fully automated document-generation pipeline using VB.NET, MySQL, and Aspose libraries, replacing legacy macro-driven workflows with clean, modular code and structured templates to make maintenance effortless for non‑technical teams. For your system, I can help modernise the architecture by introducing a clean separation between data extraction, Excel template logic, and report output, whether through a pure VB.NET refactor with OpenXML/Aspose or a hybrid Python microservice using openpyxl and python‑docx. I’ll also ensure your Excel templates are clearly structured, validated, and safe for staff edits, and deliver a full prototype with documentation, version control, and a walkthrough video. I’d be glad to connect and share my experience in more detail over chat. Thank you. Best regards, Lazar

@andriip30

Hi there. – Do you want to fully eliminate Excel/Word dependencies long-term or keep them as controlled templates for non-technical users? – Is report generation triggered in real-time from queue or batch scheduled processing? This is a great modernization task. I’d separate data, template, and generation layers, remove VBA, and build a headless service using either .NET with OpenXML/Aspose or Python microservice for cleaner maintainability. I worked on similar reporting systems replacing macro-heavy Excel/Word flows. Main issue was fragile templates and hard-to-maintain logic. I solved it by structuring templates with named ranges, moving logic into code, and creating stable pipelines. I can deliver a clean, documented system with easy updates and reliable report generation. Hope to discuss more on chat. Best, Andrii.

@OBRY8246

Hi — I’ve worked on systems like this, and I know how painful VBA-driven reporting can get. I’d keep the good parts (your data flow and templates) and replace the fragile pieces with a clean, separated pipeline. No macros — everything handled in code so it’s stable and easier to maintain. I’d lean toward VB.NET + a clean reporting layer (OpenXML/Aspose), or a small Python service if we want more flexibility — happy to choose based on what fits your setup best. The goal is simple: generate reports reliably, and make the templates safe for non-technical users to edit. Can you share a sample report + template so I can see how it’s structured? I can start right away. Best regards

@invoketech

HELLO, WE HAVE WORKED ON SIMILAR PROJECTS AND CAN PROVIDE EXAMPLES. Your current setup is solid but clearly constrained by VBA complexity and maintainability issues — we’ve handled similar migrations where macro-heavy systems were replaced with clean, structured, and fully automated pipelines. With 10+ years of experience, we focus on removing fragile dependencies, improving clarity for non-technical users, and ensuring long-term stability. We recommend a hybrid approach (VB.NET orchestration + modern document engine) to keep your current flow intact while eliminating VBA entirely. Working Flow: Data Extraction → Pull structured data from MySQL queue with clean service layer Template Processing → Map data into Excel using named ranges + validated structure Report Generation → Generate Word reports using OpenXML / python-docx (no macros) Automation Layer → Headless execution pipeline for scheduled/triggered reports Testing & Delivery → Validate outputs, version control setup, documentation + walkthrough We will deliver a clean, documented system where your team can safely update templates without breaking anything, along with a working prototype and full handover. Looking forward to collaborating on this. Invoke Tech

@SalinaSof30

Hi, After reviewing your project description, I understand that you need to modernise a critical internal reporting system currently built on VB.NET, Excel, and Word templates with macros, transforming it into a clean, maintainable, and automated solution that non-technical staff can use confidently. **User Workflow / What the user will be able to do:** • Staff can queue data in MySQL and trigger automated report generation without touching macros. • Excel templates will have clearly defined input sections, named ranges, and validations, allowing easy data updates. • Reports are generated headlessly in Word (.docx) and Excel formats with accurate, consistent layouts. • Users receive complete reports quickly, and all templates are version-controlled for safe updates. With 8+ years of experience in VB.NET, Python, document automation, and MySQL, I can rebuild the system with either a full VB.NET refactor using OpenXML/Aspose or a hybrid Python microservice for Excel/Word generation, providing clean separation between data extraction, template logic, and output. **Key Features:** • Automated, headless report generation • Modern, macro-free Excel templates • Clear separation of data, template, and output logic • Fully documented setup and source code with version control • Sample reports and short walkthrough video => Unlimited Revisions => On-Time Delivery => 40 hr/week Looking forward to collaborating. Thanks, Sukrati