Find Jobs
Hire Freelancers

Comprehensive Medicare Member Database

$30-250 USD

Closed
Posted 3 months ago

$30-250 USD

Paid on delivery
As a new Insurance Health agent, I'm looking for someone proficient in Excel to assist me in designing a Excel spreadsheet that serves as a comprehensive member information database. I needed to easily help me access members information details for fast and efficient customer service. I want to be able to duplicated in multiple worksheet tabs for each member. I believe a VBA codes would help me search for specific tab fast but not sure how that would exactly work. This will include, but is not limited to, the following details: - Name - Phone number - Date of Birth - Address - Email - Emergency contact - Medicare Number - Medicare Part A Coverage date - Medicare Part B Coverage date - Medicaid Number - Medicaid Level - Health Plan enrolled - Health Plan Member ID - Primary care provider - Date of enrollment - Previous Health Plans - Space for member pictures - Space for notes - Call/Contact log with date and comments section The layout should be user-friendly and easily navigable. Would be a plus if you have prior experience in creating similar healthcare databases. Your expertise in data modeling, Excel, and healthcare data management will be greatly appreciated.
Project ID: 37714655

About the project

27 proposals
Remote project
Active 2 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
27 freelancers are bidding on average $142 USD for this job
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$220 USD in 4 days
4.9 (567 reviews)
8.5
8.5
User Avatar
Hi there, I am an expert in Excel with VBA & Macros. I can do your work perfectly as per your requirements. Please contact so that we can discuss & start your work now. Regards Razia
$80 USD in 1 day
5.0 (246 reviews)
7.4
7.4
User Avatar
Hi there! As I have read, I see you need help and I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools. Send me a message so I can show you my previous work and we can discuss more. Best regards. Giovanni. .
$30 USD in 1 day
4.9 (60 reviews)
7.0
7.0
User Avatar
Hi As you need it in Excel, I think ms Access/VBA solution will be also acceptable for you. I can code/develop MS Access desktop app with a very user-friendly GUI. Do you have some raw data in Excel? This will help me to organize tables for your Comprehensive Medicare Member Database. I'm an Access/Excel/SQL/VBA expert and a mathematician from Georgia- a full-time freelancer. I have been coding for over 20 years in this field. Please visit https://www.freelancer.com/u/zu02?w=f Here also you can find feedbacks like: "… Zurab is an MS ACCESS genius …", "... Zurab is Messi of Office" etc. If you award me the project, I’d be pleased to discuss this further and get started for you as soon as possible. Thanks! Zurab
$250 USD in 7 days
4.7 (85 reviews)
6.5
6.5
User Avatar
Hi, I have developed a Home Care app for patient(client) - care giver - care plans - timesheet - claims - communications . I am a programmer skilled in Visual Basic, MS EXCEL and VBA. Providing many ideas and solutions IF NEEDED. Michael
$250 USD in 5 days
5.0 (73 reviews)
6.0
6.0
User Avatar
Hello, I would love to help you on your project. I am a Microsoft Expert and Data Analyst. I currently work F/T for a MCO and I work with Medicaid, Medicare, and CHC. I can create a custom database for you. Have a look at my profile. I have a whole lot more too. I have been certified and working with many Microsoft products. I am well rehearsed in VBA for MS Access as well as EXCEL, and SQL. I have been building custom ACCESS Databases for 30 years. I can take your current data and make it into a database where I can create custom forms, reports, invoices, and many other things. Thanks, Pete
$525 USD in 14 days
5.0 (9 reviews)
5.8
5.8
User Avatar
Dear client, I propose creating a user-friendly Excel spreadsheet with individual tabs for each member, incorporating VBA for efficient data retrieval. The layout will include all specified details, ensuring seamless access to member information. My expertise in Excel, VBA coding, and healthcare data management will guarantee a comprehensive and navigable database. I've successfully designed similar systems, and I'm committed to delivering a solution tailored to your specific needs. Let's collaborate to enhance your customer service efficiency.
$258 USD in 2 days
5.0 (19 reviews)
5.4
5.4
User Avatar
Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of data Microsoft applications Development. I can write clean, Excel, Word, Access, PowerPoint, Power BI, Outlook and creating VBA macros. Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide a high quality of work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, building trust and a long term relationship with customer is my main objective. https://www.freelancer.com/u/GdevDataSceince Choosing me for this project not only means benefiting from my extensive skills in Excel and data analysis but also entrusting your sales data with someone who values precision and confidentiality. Let's begin working together on this valuable project to deliver lasting results that will positively impact your business. Thanks Gdev
$50 USD in 2 days
5.0 (9 reviews)
4.2
4.2
User Avatar
Hi there, I am pleased to present for providing Excel, Excel VBA, and Excel macro services to streamline your data management, automate repetitive tasks, and enhance your productivity. I am of skilled Excel experts with extensive experience in creating custom solutions and automating processes using Excel, VBA, and macros. Data cleaning, validation and transformation to ensure data accuracy and consistency. Writing VBA code to automate repetitive tasks and streamline workflows. Excel dashboards and reports to visualize data insights effectively. Providing clear and actionable visualizations for data-driven decision-making. https://www.freelancer.com/u/RagPy My commitment to client satisfaction is unwavering. Throughout the development process, I priorities open communication, responsiveness, and collaboration. Welcome feedback and are always ready to address any concerns or modifications you may require. Regards @ RagPy
$50 USD in 2 days
5.0 (1 review)
2.0
2.0
User Avatar
Good day Having read your requirements, I am really sure that you need a proper Ms Access database instead of Ms Excel. Ms Access will not require you to manually duplicate sheets, but will automatically give you a blank sheets to input data for a new member. You also have numerous advantages using Ms Access over Ms Excel: - Immaculate, customized data-entry forms to enter and view member details - flexible data-querying interfaces that you can use to enter filtering criteria - customized reports, detailed and summarized that you can automatically produce and email even on pdf - can make the database multi-user accessible so more than one user can work on the database concurrently - can add security features so that different users can have their individual profiles and audit trails If this sound like your required solution. please let me assist you to design the system and build it to your specific requirements. I am an expert in Ms Access database solutions with more than 15 years continuous experience. I will build a neat, very user-friendly database with menu-driven navigation systems, you will feel you are working in any Office application. I have samples that you can check so you can have a clue of how your solution will look and function like.
$140 USD in 7 days
5.0 (1 review)
1.5
1.5
User Avatar
Hey, Karina B., I would like to grab this opportunity and will work till you get 100% satisfied with our work. I am a good and reliable man who has many years of experience on Visual Basic, Excel, Microsoft Access. Please come over chat and discuss your requirement in a detailed way. Regards
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey, How are you? I have 5+ years of working experience doing IT jobs. I am full stack developer have a strong working experience of every framework specially Excel, Visual Basic and Microsoft Access. Please start chat, So we have a detail discussion regarding to project. And I have read your project details as well. You can check my portfolio as well: https://www.freelancer.com/u/Sidrairfan078 Waiting for your Reply. Thanks! Sidra
$155 USD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I have read your details carefully and understood what you want. As a senior full stack developer, I have done many similar projects so far, and have some good solutions for your project. If you let me try, I can prove my skills and deliver great results on time. Can we chat to discuss more details for your project now? Looking forward to hearing from you at the least possible hour. Thank you. Christoper.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
It sounds like the perfect job for me. I have been doing this job for almost 7 years now in the company of my father. It is something that I do every day.I am well-versed in using Excel for data management and have frequently used VBA codes to enhance database functionality.
$100 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hii i am sound knowledge of excel and i worked in accounting firm for 2.5 years so i worked on various speadsheets.
$150 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
With my comprehensive experience in Excel and data management, your project is not a challenge but an opportunity for me to showcase my skills. I have worked with vast amounts of data, effectively organizing them into easily navigable Excel spreadsheets for various clients. My prior experiences in creating databases for healthcare clients have strengthened my understanding of handling sensitive medical information with accuracy and the utmost respect for privacy. What sets me apart from other freelancers is my proactive and detail-oriented approach to data management. I understand the importance of quick access to specific information - and my skillset includes using VBA codes to create seamless search systems that can enable you to find member details on-demand, saving you substantial time and effort. I want nothing more than to contribute to your success as an Insurance Health Agent by providing you with a comprehensive Medicare member database that meets all your needs. From basic details like name and contact information to insurance-specific data like previous health plans, Medicaid level or coverage dates, I will ensure your Excel spreadsheet is tailor-fit for your business operations. Let's bring efficiency and ease to your customer service procedures together!
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am excited to submit my bid for the detailed-oriented freelancer role involving Excel proficiency and financial data analysis. With a proven track record in handling complex financial data and a meticulous approach to manual data entry, I am confident in my ability to deliver accurate and insightful results for your crucial project. Here's why I am the ideal candidate for the job: • I have 18+ years of extensive experience working with Excel, including advanced functions, pivot tables, and data visualization techniques. • My proficiency ensures efficient data handling and the ability to derive meaningful insights from the financial information provided. • I understand the critical importance of precision in manual data entry, especially when dealing with financial data. • My meticulous approach guarantees error-free data input, contributing to the overall accuracy of the analysis. • I have successfully undertaken similar projects in the past, where I've conducted comprehensive analyses of financial data to support informed decision-making. • My expertise extends to identifying trends, anomalies, and key performance indicators, ensuring the data analysis aligns with your specific needs.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Proven experience in designing databases for the healthcare sector, mastery of Excel and VBA codes, efficient in managing healthcare data, I want to work with you!
$120 USD in 7 days
0.0 (1 review)
0.0
0.0
User Avatar
Gusto en saludarle, agradezco la oportunidad que me brinda para ofrecer mis habilidades con el manejo de datos en excel. Llevo más de 25 años trabajando con esta herramienta realizando análisis de datos en la construcción de tablas que permitan el procesamiento de datos para realizar resúmenes con calidad visual que permitan la interpretación de la información en cuadros, gráficos, diagramas, entre otras aplicaciones para el control y seguimiento de gestión.
$100 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
El Paso, United States
0.0
0
Member since Jan 31, 2024

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.