
Closed
Posted
Paid on delivery
Our in-house desktop billing application has started showing serious data problems—duplicate records pop up, figures drift between screens, and every so often a line item appears that nobody entered. My priority is to uncover the root cause of these inconsistencies, then clean up the database and stop the duplicates for good. What you can expect when you come in: I will give you remote or on-site access to the application, its executables, and the current database dump. The codebase is legacy; language, framework, and DB engine still have to be confirmed, so part of the assignment is to inspect the binaries, identify the tech stack, and map out the architecture before any fixes are applied. The application for coding was done using Microsoft Visual FoxPro, so experience in this field is crucial. Deliverables • Detailed diagnostic report pinpointing why duplicates and mismatches occur, including any schema or transaction-level issues • Action plan for repairing the existing dataset without data loss • Implemented fix that removes current duplicates, prevents new ones, and logs any inconsistent input attempts • Integrity audit results with tests or scripts I can rerun after future updates Acceptance criteria: no duplicate record can be reproduced under normal user workflows; cross-checked fields (totals, item counts, timestamps) must stay in sync across every module; and the audit script returns a clean result on two consecutive business days. If you have solid experience reverse-engineering desktop business apps written using Microsoft Visual FoxPro and tightening database integrity, I’m ready to start as soon as you are.
Project ID: 40520118
17 proposals
Remote project
Active 3 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
17 freelancers are bidding on average ₹7,868 INR for this job

Hi there, We can help investigate the billing application end to end: identify the desktop stack, trace the write paths, diagnose why duplicates and mismatches are appearing, and repair the data layer without losing valid records. We will produce a clear diagnostic report, clean up the current dataset carefully, and implement controls that reduce duplicate creation while keeping key figures in sync across modules. We will also provide rerunnable integrity checks so your team can verify the database after future updates and spot inconsistencies early. If access to the executable, database dump, and a few sample workflows is available, we can begin the analysis right away. Best Regards, 8veer
₹12,500 INR in 10 days
6.3
6.3

With over 7 years of experience in AI, Data Science, and Software Development, I am confident that I have the skills necessary to identify and resolve the root cause of data inconsistencies in your billing software. My expertise in python development and automation, particularly in areas concerning Database designing and testing, places me in an excellent position to diagnose your legacy codebase and map out its architecture.
₹4,500 INR in 2 days
6.0
6.0

Having worked as a Full Stack Developer for over 14 years, I've write your name,Maroof, brought to life numerous mission-critical applications and gained deep expertise in data management. I understand the frustration and impact that data inconsistencies and duplicate records can have on a business's productivity - that is why I believe my skills and experience make me an ideal fit for this task. My specialization extends to Microsoft Visual FoxPro, legacy codes, and database integrity. So rest assured, I can reverse-engineer your desktop billing application, detect the root cause of these discrepancies and implement a fix that not only repairs the existing dataset without any data loss but also ensures these issues don't recur in future. Additionally, my proficiencies in SQL means that I can craft comprehensive audit scripts to avoid any future data inconsistencies. Furthermore, I will leverage my cross-industry experience to bring fresh perspectives to your problem at hand. One example being my work in US Healthcare Echo System wherein I dealt with various aspects of Bill/Invoice processing that highlight how crucial it is to have accurate data in such sensitive matters
₹7,000 INR in 7 days
4.3
4.3

Hi, I can help diagnose and fix the data integrity issues in your in-house desktop billing application, including duplicate records, mismatched figures, unexpected line items, and database inconsistencies. The best solution is to first inspect the application, database dump, executables, and workflow behavior to identify the actual tech stack, schema structure, transaction flow, and where the bad records are being created. Then I’ll trace the duplicate/mismatch patterns, review constraints and indexes, check transaction handling, clean the existing dataset safely, and implement safeguards to prevent the issue from recurring. I’m comfortable with legacy desktop applications, database debugging, reverse engineering business workflows, data cleansing, integrity checks, duplicate detection, transaction-level analysis, audit scripts, software testing, and root-cause reporting. Deliverables will include: * Diagnostic report with root cause * Safe data repair plan * Duplicate cleanup without data loss * Fix to prevent new duplicates * Logging for inconsistent input attempts * Integrity audit script/tests * Final verification report I’ll make sure normal billing workflows can no longer reproduce duplicates and that totals, item counts, timestamps, and related fields stay synchronized across modules. Best regards Ankit
₹5,000 INR in 1 day
2.8
2.8

As an experienced and innovative software developer, I have a strong background in untangling complex digital systems and transforming them into efficient, stable, and user-friendly solutions. Your project resonates with a key part of my expertise - reverse-engineering legacy code bases and tightening database integrity, which have always been the cornerstone of my work in helping businesses solve their technical challenges. My approach is both practical and strategic. I understand that it's not enough to simply identify the problem but to provide concrete action steps for resolution. Considering this, I assure you of a thorough investigation into the root cause of the billing application's data inconsistencies, followed by a detailed diagnostic report that will pinpoint schema or transaction-level issues responsible for these inconsistencies along with a specific action plan for repairing the existing dataset without any data loss. Additionally, I will implement comprehensive measures that eradicate the current duplicates while ensuring prevention of future ones. These alterations will be complemented by logs that document any inconsistent input attempts for traceability purposes.
₹10,000 INR in 5 days
2.6
2.6

I work on Visual FoxPro legacy apps most months, often brought in for exactly this—phantom duplicates, data drift, and line items that appear out of nowhere. Your description points to transactional logic breaking down, possibly from unchecked inserts or partial commits. Here's my process: I’ll review the executable and database, trace code paths that handle inserts/updates, and audit the schema for missing constraints or triggers. After root cause, I clean the live data, script removals, then patch the code to prevent recurrence and set up a logging layer that flags wild inserts before they hit the DB. Do you have regular schema backups, or will I need to dump and snapshot before any operation? I can start this week if access lines up. Pradeep
₹7,000 INR in 7 days
2.4
2.4

Hi — duplicates, drifting totals and phantom rows in a desktop billing app are almost always DB-level: missing unique constraints, non-atomic or retried inserts, races across terminals, or totals stored instead of derived. That root-cause + data-integrity work is my core lane. Approach, diagnose before any fix: - From your DB dump I trace where the dups and mismatches actually originate (schema + transaction level). - I inspect the executables to confirm the real stack (language/framework/DB engine) and map how each screen writes data. Deliverables, matching your list: 1. Diagnostic report: precise root cause of the duplicates and figure-drift. 2. Repair plan for existing data with NO loss — dedupe keys agreed with you, backup first. 3. Implemented fix: clears current dups, prevents new ones (unique constraints + atomic writes), logs rejected input. 4. A rerunnable audit script, built to pass clean across your two-business-day check. Honest note: I confirm the stack from the binaries before changing anything; if a cause sits in compiled app logic of an unusual stack, I'll flag it with options, not guess. Quick Qs: 1. Do you know the DB engine/app language, or is identifying it on me? 2. One machine, or several terminals on one DB? 3. Can you share one concrete duplicate example? Backup-first and reversible throughout.
₹7,000 INR in 7 days
0.4
0.4

I can fix this. My approach works from the database outward — no need to fully reverse-engineer the legacy binary: 1. Analyze database dump: identify schema, find duplicate patterns, trace data drift between screens 2. Root cause: likely a missing UNIQUE constraint + race condition on inserts, or a broken transaction wrapper 3. Cleanup: deduplicate with safe merge (keep latest timestamps, reconcile totals), no data loss 4. Prevention: add constraints, wrap critical writes in transactions, add input validation layer 5. Deliver: diagnostic report + cleanup script + audit script (re-runnable) + prevention patch Experience: built deduplication pipelines for 60M+ records, database integrity fixes, pattern analysis on opaque data sets.
₹7,250 INR in 7 days
0.0
0.0

I am a perfect fit for your project. I understand your need to fix data issues in your billing software. My expertise lies in diagnosing and resolving database inconsistencies to ensure a clean, professional, and seamless user experience. While I am new to Freelancer, I have extensive experience in handling similar projects off-site. To establish trust, I offer discounted pricing without compromising quality. I guarantee satisfaction with the deliverables: a detailed diagnostic report, an action plan for data repair, and implemented fixes to prevent future duplicates. No Satisfaction, No Payment. I would love to chat more about your project! Kind Regards, Jabulani Xaba
₹6,250 INR in 7 days
0.0
0.0

Hello, I have read your job description and I am interested in your job post. I am ready to start now. Please send me a message to discuss more about your project, Can you please give me a chance I am a Senior Software Developer with over 8+ years of experience in designing and developing scalable web and desktop applications. I specialize in Microsoft technologies and delivering high-quality, secure, and performance-driven applications. My Expertise: Backend Development:ASP.NET, ASP.NET Core, MVC, Web API, WebForms, WCF Services Programming Languages:C#, Frontend Development:JavaScript, jQuery, AJAX, HTML, CSS Database Technologies:SQL Server, MySQL Reporting Tools:Crystal Reports, RDLC, SSIS, SSRS
₹6,000 INR in 5 days
0.0
0.0

Hi, the symptoms you're describing, duplicate records, totals drifting between screens, and line items nobody entered, are classic database-integrity and concurrency problems, and root-causing that is squarely my work as a backend/data engineer. My read before seeing anything: duplicates usually mean a missing unique constraint or a non-atomic insert; figures that disagree across screens point to caching or writes not wrapped in proper transactions; phantom rows often come from a retry or a race between concurrent sessions. I'd confirm which it is rather than guess. How I'd work it: 1. Inspect the database dump first: schema, keys, constraints, and the actual duplicate/mismatch patterns, to locate the integrity gaps. 2. Identify the app's stack from the binaries and trace the write paths creating the bad data. 3. Deliver a diagnostic report, a no-data-loss cleanup plan, the implemented fix (dedup + constraints/transaction handling so new duplicates can't form + logging of bad input), and a rerunnable audit script. I'll be straight on one thing: the database side is my strong suit; how deep the desktop reverse-engineering goes depends on what the app is built in, which I'd pin down early. To scope it: any idea of the language and DB engine, and is the app used by several people at once against a shared database?
₹9,000 INR in 10 days
0.0
0.0

Kolkata, India
Member since Jun 17, 2026
$15-25 USD / hour
$30-250 USD
₹600-1500 INR
₹750-1250 INR / hour
$250-750 USD
$300-500 USD
£750-1500 GBP
₹400-750 INR / hour
₹2000-3000 INR
$150-200 USD
₹100-400 INR / hour
$250-750 USD
$10-30 USD
₹3000-6000 INR
₹1500-12500 INR
₹750-1250 INR / hour
₹37500-75000 INR
$1500-3000 AUD
$10-50 AUD
$25-50 AUD / hour