
Closed
Posted
I'm seeking an experienced developer to review SQL code for a healthcare dashboard. The dashboard is primarily focused on EOB (Explanation of Benefits) management. Key Tasks: - Review existing SQL code for logic accuracy and completeness - Ensure code meets industry best practices - Provide actionable feedback for any identified issues Ideal Skills: - Proficiency in SQL - Strong understanding of healthcare data and EOB processes - Experience with code review and optimization - Attention to detail and problem-solving skills
Project ID: 40771829
40 proposals
Remote project
Active 6 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
40 freelancers are bidding on average ₹620 INR/hour for this job

EOB queries usually break on claim-to-line fan-out and double-counted adjustments, so each metric gets traced back to its source rows. Days 1-2: full read of the code, with the highest-risk queries flagged first for your check. Day 7: annotated findings per query, with corrected SQL wherever the logic or performance is off. 1. MySQL or Access, and roughly how many queries or views are involved? 2. Can I run it against a sample dataset, or is this a code-only review? Send one query over chat and I can start on it today.
₹590 INR in 7 days
6.2
6.2

Hello! I can review and optimize your SQL code for the healthcare dashboard today. Managing EOB (Explanation of Benefits) data requires strict logical precision to ensure that claims, patient liabilities, and insurance payouts align perfectly without data duplication or mismatched joins. How I will approach your dashboard review: 1. Logic & Completeness Audit: I will verify all joins, aggregations, and subqueries to ensure that EOB metrics (like allowed amounts, co-pays, and deductibles) are reflecting the financial and operational reality accurately. 2. Performance Optimization: Healthcare datasets grow fast. I will review your indexing strategies, CTEs, and execution plans to ensure the dashboard loads smoothly under heavy reporting loads. 3. Actionable Feedback: I will deliver a clean, commented breakdown of any issues found, along with rewritten, optimized snippets that follow industry best practices. I have a strong background in software engineering and database design, making sure business logic translates cleanly into reliable queries. Could you share a bit more about the specific SQL dialect you are using (e.g., PostgreSQL, SQL Server, MySQL) and roughly how many lines of code need to be reviewed? I am available to start immediately. Best regards, Joao
₹600 INR in 10 days
3.5
3.5

Hi, I can review your existing SQL code for the EOB management dashboard, focusing on query logic, completeness, data accuracy, maintainability and performance. My review would cover joins, filters, aggregations, null handling, duplicate records, edge cases and any potential issues that could affect dashboard results. I’ll provide actionable feedback with clear explanations and suggested improvements rather than simply listing problems. I’d first review the database type, SQL files and expected EOB workflows to understand the intended results. I can then prioritise findings by impact and share a concise report with recommended fixes. I can confirm the effort after a quick review of the files. I’m happy to discuss the scope and review process before starting.
₹400 INR in 40 days
3.2
3.2

Dear Client, WiredAI is an AI-first engineering agency with 6+ years of experience in software development and data-driven applications. We can review your healthcare dashboard’s SQL code for logic accuracy, completeness, query performance, and maintainability. Our team will identify potential issues, check data handling and EOB-related calculations against your provided business rules, and deliver actionable recommendations for improvements. We can start by reviewing a sample of your SQL code and then agree on the scope and timeline.
₹400 INR in 40 days
1.5
1.5

Hi, In an EOB dashboard, a query can execute successfully and still produce incorrect results for example, duplicated claim rows from joins, inaccurate patient-responsibility totals, or missing adjustment records. I'd review your existing SQL for logical correctness, join relationships, filtering, aggregation, NULL handling, duplicate records, and performance. I'd compare the query behavior against your documented EOB rules and flag any cases where the intended business logic needs clarification. You'd receive a prioritized review report covering each identified issue, its potential impact, the relevant SQL, and a recommended correction. Where practical, I'd include validation queries and test cases to help verify the fixes without disrupting the existing dashboard. To estimate the review accurately, could you share which SQL database you're using, approximately how many queries need reviewing, and whether the EOB calculation rules are documented? Best regards, Deepak.
₹575 INR in 36 days
1.2
1.2

Hello, I can review the SQL supporting your healthcare dashboard with focused attention to EOB management. I will:• Check logic accuracy, completeness, joins, filters, and edge cases• Review query structure, performance, readability, and maintainability• Consider healthcare data handling and EOB workflow requirements• Provide clear, actionable feedback with prioritized recommendationsI will keep the review practical and focused on improvements that strengthen reporting accuracy and reliability. Could you share the SQL, schema relationships, and a few expected EOB outcomes so I can validate the logic against real reporting requirements?Kind regards, Michel
₹950 INR in 40 days
0.0
0.0

Hello, I see you're looking for someone to review SQL code for your healthcare dashboard focused on EOB management. Ensuring the accuracy and completeness of this code is crucial, especially considering the complexities of healthcare data. One idea I have is to implement a checklist approach during the review to systematically address logic accuracy and adherence to industry best practices. This could streamline the process and ensure that we catch any potential issues efficiently. I can help you by auditing your existing SQL code and providing detailed, actionable feedback on areas for improvement. My approach focuses on clarity and thoroughness, ensuring that your dashboard operates flawlessly. What specific challenges have you encountered with the current code? I’d be more than happy to chat about your project. Worst case, you walk away with a free consultation. Kind Regards, JaydonS2
₹550 INR in 7 days
0.0
0.0

I will review the dashboard SQL for incorrect joins, duplicate counts, missing records, NULL handling and inconsistent EOB totals, then provide reproducible examples and precise correction suggestions. My public Data Cleanup & Excel Dashboard sample demonstrates data checking; for this review, each SQL finding will be tied to the affected dashboard result and an expected-output test. I would start by mapping the queries, schema and data grain. For EOB-specific calculations, I will validate relationships and totals against your field definitions, approved business rules and expected examples. I will also review date/status filters, grouping, rounding and query plans where available. Deliverables: a prioritised findings report, query-level comments, proposed SQL corrections and small regression queries showing the expected result. The review will be read-only, using de-identified sample data or a test environment. Proposed changes will be documented for your approval before anything is applied to a live database. Rate: INR 550/hour, with up to 10 hours per week on a flexible schedule. I suggest a first checkpoint after two hours to show the query map and initial findings, then confirm the remaining estimate based on the code volume. Please share the SQL dialect/version, schema, dashboard queries, business-rule definitions and sample expected outputs. I will flag any unresolved EOB interpretation for confirmation with your domain owner and include reproduction steps for every material issue.
₹550 INR in 10 days
0.0
0.0

With our expertise, your project is in capable hands. At A2 Technologies, we don't just provide code review but ensure that every aspect of your healthcare dashboard aligns perfectly with industry standards and meets best practices. Drawing from 5+ years of experience that includes building smart solutions for the healthcare sector, we're fully versed in the intricacies of healthcare data management, including EOB processes - this means we're on the same page with you from the get-go. Our proficiency in SQL is a tool we've honed over time through multiple successful projects just like yours. We know how to spot discrepancies, optimize code for better performance, and implement solutions that will make a tangible difference to your hospital's operations. But our service doesn't stop at identifying issues - we provide actionable feedback so any problems can be easily rectified and your healthcare dashboard functions smoothly. Throughout the process, you can expect clear communication and regular updates as we believe transparency is key to any successful partnership. Choose us for the diligence of detail-oriented professionals who love problem-solving and creating dynamic solutions tailored perfectly for your needs. Let's turn your vision into reality!
₹570 INR in 40 days
0.0
0.0

Hello, Are you looking for a careful SQL review that prioritizes accuracy, data integrity, and reliable healthcare dashboard performance? I can help review your existing SQL queries for logical inconsistencies, missing conditions, calculation errors, and opportunities to improve query efficiency. I will focus on making the code more reliable, readable, and maintainable while aligning with SQL best practices. Here’s how I can contribute: - Review SQL logic for accuracy and completeness. - Identify potential errors, edge cases, and inconsistencies. - Suggest improvements in query structure, readability, and performance. - Provide clear, actionable feedback with explanations. - Pay particular attention to EOB-related calculations and data relationships, based on the requirements and documentation provided. My approach is detail-oriented and focused on practical recommendations you can implement with confidence. I would be happy to review a sample of the existing SQL code and understand your dashboard requirements before getting started. I look forward to discussing your project! Best regards
₹487 INR in 40 days
0.0
0.0

Hi, I can help review your SQL code for the healthcare EOB management dashboard, focusing on query accuracy, data consistency, performance, and maintainability. My approach includes: • Reviewing SQL queries, joins, filters, aggregations, and business logic for correctness and completeness. • Checking EOB-related calculations and data relationships, including claim amounts, patient responsibility, adjustments, and insurance payments, where applicable. • Identifying potential errors, duplicate records, missing data, and performance bottlenecks. • Recommending SQL best practices, indexing improvements, and query optimizations. • Providing clear, actionable feedback with explanations and suggested corrections. I have a strong foundation in SQL, database management, and data analysis, and I approach code reviews methodically to help ensure reliable dashboard results. I will also respect data confidentiality and can work with anonymized or synthetic healthcare data where appropriate. I can begin by reviewing a sample of your existing SQL code, documenting findings by priority, and recommending practical improvements. I look forward to helping you improve the accuracy, reliability, and performance of your healthcare dashboard.
₹575 INR in 15 days
0.0
0.0

This is Thomas, a software architect and senior developer specializing in data-driven applications and backend systems. I’ve reviewed your requirements, and I can help audit your healthcare dashboard SQL for correctness, reliability, and maintainability. My approach is to review query logic, joins, aggregations, EOB data relationships, and edge cases to identify incorrect calculations, missing records, and potential performance issues. Technical risks & solutions: Incorrect EOB calculations: Trace query logic against expected business rules. Missing or duplicated records: Validate joins, filters, and aggregation behavior. Sensitive healthcare data: Recommend appropriate access controls and safe data-handling practices. I’ll provide actionable findings with clear explanations and practical recommendations for each issue identified. Could you share the SQL queries and a brief overview of the EOB workflow so I can understand the logic and focus the review on the most critical areas?
₹650 INR in 40 days
0.0
0.0

Hi there, I see you're looking for a review of SQL code for your healthcare dashboard focused on EOB management. I’ll carefully examine the logic and completeness of your existing code, ensuring it aligns with industry best practices. My background in healthcare data and SQL will allow me to provide you with actionable feedback to optimize performance. Could you share any specific areas of concern or particular challenges you've encountered with the current code? I’d love to discuss how we can enhance the effectiveness of your dashboard. Best Regards, Charl
₹400 INR in 7 days
0.0
0.0

Hi, I'm an actuarial consultant working in healthcare analytics, and I write and review advanced SQL Server code on medical claims and benefit data every day, including fraud, waste and abuse investigations. Reviewing a dashboard's SQL for EOB accuracy is very close to my daily work. I'll check that the logic is correct and complete, covering how claims, line items, adjustments, reversals, denials, member liability and payer amounts flow through to the figures on the dashboard. I'll look for common problems such as duplicated joins inflating totals, mishandled claim status or date logic, missing edge cases, and numbers that don't reconcile to source. I'll also review structure, readability, indexing and performance, and flag anything that doesn't follow best practice. You will receive clear, actionable feedback with each issue explained, its impact, and a suggested fix or rewritten snippet where helpful. Findings will be prioritised so you can see what matters most first. Send over the code and a short description of the dashboard's purpose and I'll confirm scope within a few hours. Kind regards, Malwande
₹575 INR in 20 days
0.0
0.0

You need the SQL behind your EOB dashboard reviewed so the logic is accurate, complete and built to best practice, without rewriting everything. How I'll do it: I'll go through each query against your EOB workflow (claims, adjustments, patient responsibility, denials, partial payments) and check joins, performance, parameterization and readability. I'll flag anything that could put wrong numbers on the dashboard, such as double-counted claims or missing status transitions. I'll work in SQL (MySQL or Access) and run a quick Excel sanity check on a sample extract if you share one. Deliverables: a written report by query with findings, severity and exact fixes; refactored SQL for the highest-impact issues; and a short best-practice checklist for your model. Rate: ₹600/hr, about 8–12 hours in total, with the hours agreed upfront. Delivery in 5–7 days from receiving the code. Quick question: is the dashboard backed by one database, or does the SQL pull from several sources? Vinayan
₹600 INR in 10 days
0.0
0.0

We've recently helped a healthcare provider enhance their data management through a thorough code review. I will help you ensure your SQL code for the healthcare dashboard is logical, complete, and aligned with industry best practices. I noticed your focus on EOB management, which requires precision and a strong grasp of healthcare data. With my proficiency in SQL and experience in code review, I can provide detailed feedback and optimization strategies tailored to your project. I'm new to Freelancer, but not new to the work. I bring real experience and I'm building my profile here, so every client gets my full attention, clear communication, and reliable delivery. I would love to chat to you about your project and hear more about what you’re looking to achieve. There’s absolutely no pressure, the worst that can happen is you walk away with a free consultation and a few helpful ideas for your project. Regards, Melissa
₹400 INR in 7 days
0.0
0.0

We understand the importance of a thorough code review for your healthcare dashboard, especially focusing on EOB management. Ensuring the SQL code is both logically accurate and complete is essential for effective data handling. With our proficiency in SQL and strong background in healthcare data, we will meticulously analyze your existing code, checking for adherence to industry best practices. Our approach includes identifying potential issues and providing actionable feedback to enhance performance and reliability. Could you share more about the specific challenges you've encountered with the current code, or would you prefer a quick chat to discuss this further? Best Regards, WillemS9
₹400 INR in 7 days
0.0
0.0

Hello, I can review the SQL behind your EOB dashboard in writing. I will check join logic (duplicates from claim/line joins are the most common problem), filters and date ranges, NULL handling for paid/denied/adjusted amounts, whether totals match the source data, and performance (indexes, heavy subqueries). You will get a written report: each issue, why it matters, and the corrected SQL. I have 30 years of experience with SQL and reporting, including medical software. I work through written communication only, with written updates. Which database is it (MySQL, SQL Server or Access), and roughly how many queries or views are in scope?
₹700 INR in 10 days
0.0
0.0

Hello, I reviewed your healthcare dashboard project. I have good experience in SQL, MySQL and Microsoft Access. I can review your SQL code for logic, accuracy and best practices. I will check each query, find any issues and give you clear feedback on how to fix it. I am detail oriented and careful with database work. I can start now and provide daily updates. Thanks for considering me.
₹575 INR in 40 days
0.0
0.0

Hi, I can review the SQL behind your EOB dashboard and give you clear, actionable feedback. What I'd check: - Join logic and grain (claim vs. claim line vs. adjustment level), which is where EOB totals most often get double-counted or dropped - Handling of billed, allowed, paid, adjustment and patient-responsibility amounts, including NULLs, zero-pay lines, reversals/voids and re-adjudicated claims - Date logic (service vs. paid vs. processed dates) and filters that might silently exclude records - Readability and best practices: CTEs vs. nested subqueries, naming, duplicated logic that should be a view - Performance: indexes, sargable WHERE clauses, unnecessary DISTINCT/sorts Deliverable: a written report ordered by severity with the exact query/line, why it matters, and a corrected snippet for each issue. Which database engine is it (SQL Server, PostgreSQL, MySQL), and roughly how many queries/views are involved? For a typical dashboard I'd expect around 4-8 hours.
₹400 INR in 10 days
0.0
0.0

Coimbatore, India
Member since Oct 7, 2019
$30-250 USD
₹12500-37500 INR
$250-750 USD
₹750-1250 INR / hour
$250-750 USD
$10-30 USD
₹1250-2500 INR / hour
$250-750 USD
$8-15 USD / hour
$30-250 USD
£5-10 GBP / hour
₹100-400 INR / hour
$250-750 USD
$30-250 USD
₹750-1250 INR / hour
$30-250 USD
₹400-750 INR / hour
₹12500-37500 INR
₹400-750 INR / hour
₹2500-5000 INR