As an EDI Developer, I am working in a US Based Clearing-House that processes the provider claims, patient eligibility, era retrieval from/to the corresponding insurance. I have expertise in following EDI transactions. - 837 Professional/Institutional/Dental - First level Reports - 999, 277CA (Claim Acknowledgment) - Real-time/Batch Patient Eligibility 270, 271 - Real-time/Batch Claim Status 276, 277 - Payment Posting 835 I have created my own EDI Framework, which is capable of following transactions. - Claim Transaction (837) Generation and Sending it to the Vendor - Retrieval of Reports 999, 277CA and linking reports to the submitted claims. - Showing rejections in claims, received from vendors - Patient Eligibility 270/271 transaction, that will show the eligibility status (Active/InActive), patient benefits, copay, deductible, co-insurance. - Claim Status 276/277, that will show the current status of claim from Payer Adjudication System. - Retrieval of Payment Reports (835/ERA) and will link to the corresponding payer. The system will show the details as Claim Submitted Amount, Allowed Amount, Paid Amount, Patient Responsibility etc. Denial details will also show in case of denial claims. - Many more features to come Please review my EDI Framework in my portfolio (named: The Easy EDI) section.

I build Excel and Google Sheets automation systems that eliminate manual work, fix broken spreadsheets, and turn scattered data into reliable reporting your team can trust. Most businesses I work with struggle with: – Reports that take hours every week – Spreadsheets that break when updated – Data spread across Excel, Google Sheets, CRMs, or e-commerce platforms I replace that with clean, automated systems that save time, reduce errors, and give clear insights for decision-making. ━━━━━━━━━━━━━━━━━━━━ ⚙️ WHAT I BUILD ━━━━━━━━━━━━━━━━━━━━ ✦ Excel VBA automation — remove repetitive tasks and manual reporting ✦ Google Sheets automation — dynamic workflows and real-time updates ✦ Dashboards & reporting systems — sales, operations, KPIs, inventory ✦ Looker Studio dashboards — connected, visual business reporting ✦ Python automation — large data processing, ETL, multi-source consolidation ✦ Data integration — APIs, CSV, Excel, Sheets, CRM, Shopify, WooCommerce ✦ LLM Integration — ChatGPT, Gimini for Dashboard Reporting. ━━━━━━━━━━━━━━━━━━━━ 📊 RESULTS YOU CAN EXPECT ━━━━━━━━━━━━━━━━━━━━ ✦ Hours of manual reporting reduced to minutes ✦ Error-free data processing and reporting ✦ Centralized dashboards for better decision-making ✦ Scalable systems your team can use daily ━━━━━━━━━━━━━━━━━━━━ 🛠 HOW I WORK ━━━━━━━━━━━━━━━━━━━━ ✦ Understand your current workflow and bottlenecks ✦ Design a clean and scalable solution ✦ Build automation with performance and reliability ✦ Deliver a fully documented system (no dependency on me) ━━━━━━━━━━━━━━━━━━━━ 👥 I WORKED WITH ━━━━━━━━━━━━━━━━━━━━ ✔ Small to mid-size businesses ✔ E-commerce brands (Shopify, WooCommerce) ✔ Operations and reporting teams ✔ Agencies handling large datasets ━━━━━━━━━━━━━━━━━━━━ 🚀 LET’S GET STARTED ━━━━━━━━━━━━━━━━━━━━ Send me: ✔ Your current file or workflow ✔ What’s slowing you down ✔ What you want automated I’ll respond with a clear plan and scope within 24 hours.

𝗖𝘆𝗯𝗲𝗿𝘀𝗲𝗰𝘂𝗿𝗶𝘁𝘆 | 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝟯𝟲𝟱 & 𝗦𝗵𝗮𝗿𝗲𝗣𝗼𝗶𝗻𝘁 | 𝗪𝗲𝗯 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆 | 𝗗𝗮𝘁𝗮 & 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 🥇 𝗖𝗼𝗺𝗽𝗧𝗜𝗔 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆+ | 𝗠𝗦 𝗦𝗖-𝟵𝟬𝟬 | 𝗚𝗼𝗼𝗴𝗹𝗲 𝗖𝘆𝗯𝗲𝗿𝘀𝗲𝗰𝘂𝗿𝗶𝘁𝘆 | 𝗠𝗦𝗰 𝗜𝗧 🥇 𝗧𝗼𝗽 𝗥𝗮𝘁𝗲𝗱 CompTIA Security+, Microsoft SC-900, and Google Cybersecurity certified professional helping businesses secure their systems, manage Microsoft 365 environments, and eliminate web threats. 𝗖𝘆𝗯𝗲𝗿𝘀𝗲𝗰𝘂𝗿𝗶𝘁𝘆 & 𝗔𝘂𝗱𝗶𝘁𝘀: ✅ Vulnerability assessments & penetration testing (OWASP Top 10, network security) ✅ Security audits with detailed remediation reports ✅ SOC operations, threat detection & incident response 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝟯𝟲𝟱 & 𝗦𝗵𝗮𝗿𝗲𝗣𝗼𝗶𝗻𝘁: ✅ M365 tenant configuration, security policies & compliance setup ✅ SharePoint administration & workflow automation ✅ Exchange Online, Entra ID, Defender & Purview 𝗪𝗲𝗯 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆: ✅ WordPress malware removal & hardening ✅ SSL/TLS configuration, firewall setup & security monitoring ✅ Secure coding review & OWASP compliance 𝗗𝗮𝘁𝗮 & 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻: ✅ Excel/Google Sheets automation, VBA & Apps Script ✅ Data entry, cleanup & process automation ✅ API integrations via Zapier & Make 𝗪𝗵𝘆 𝗪𝗼𝗿𝗸 𝗪𝗶𝘁𝗵 𝗠𝗲: I deliver certified, accurate, deadline-driven work with a security-first mindset. 100% Job Success | Top Rated | 0–4hr response time. Ready to secure your systems? Let's talk.

Hi. My name is Rob Mendell. I'm a Top-Rated Upwork Contractor. I've been a full-time Independent since 2007. • I develop bespoke automation solutions in Word and Excel (and some PowerPoint) using VBA. • I am a Microsoft Certified Master Instructor for Microsoft Office. • I provide issue support like a Help Desk (headers and footers, formulas, whatever). • I assist with, or fully complete, special projects. —|— What do I offer? VBA Development — It's been said that if you want to really learn something, program a computer to do it. I'm a VBA Programmer. VBA -- Visual Basic for Applications -- is a language Microsoft built into some Office applications that allows Developers to create tailor-made dialog boxes and write software code that taps into the objects and power inherent within each application. I know how to create customizations and one-of-a-kind automation inside Microsoft Office using VBA (Word, Excel, and PowerPoint), with a friendly yet professional user interface, when the job requires this. Most people I work with on Upwork were initially unaware of this functional possibility, especially inside Word. Training — It's also been said that if you want to really learn something, teach it. I've been teaching Microsoft Office since 1992: in classroom settings, virtually, and through on-demand deskside services such as Tier 2 and Tier 3 Support. I know what the software can do natively -- without customization -- and how to patiently and clearly present it as a learning opportunity in layman's terms: Word styles, Excel formulas, PowerPoint slide masters, templates, conditional mail merge, and so on. Very few contractors have skills as both a Developer and a Trainer. I do. That's what I offer. I typically approach training from technical awareness, and I approach automation from the user's experience. If Office already has a feature built in, we shouldn't spend time and money to develop specialized code to do the job. I can look at a project and quickly determine which service is best in your specific situation, and then provide it to you. Your deliverable may be a combination of customized development, creation of a special project that uses it, and training on working with tools already available in the software suite. I offer a strong, coherent, and unique set of professional services to companies who want to more fully leverage their investment in Microsoft Office, with workbooks, documents, presentations, and automation templates. —|— Here are examples: VBA Development — Using VBA (Visual Basic for Applications), I design customized and intelligent dialog boxes that ask the pertinent questions, acquire the required answers, and then automate the desired results. I deliver these solutions most often as macro-enabled templates (.dotm for Word, .xltm for Excel, and .potm for PowerPoint). Examples of completed projects include correspondence layouts, code-generated PowerPoint decks, report generators based on sales or survey data, time sheets that perform calculations, budget workbooks that allocate every penny based on performance and longevity ratios, documents that behave, proposal and SOW templates, and so much more. Training — I love teaching Word and Excel, from beginning topics through advanced. I've also taught Outlook, PowerPoint, OneNote, and other programs. I've been teaching Microsoft Office for 30 years. Support — Everyone gets stuck now and then, and you may need assistance. I am available to help you get a complex Word document back on track with styles and multi-section page numbering, or write that elusive set of formulas in Excel. I can work like an experienced outsourced Help Desk or write great documentation to help your employees understand and utilize functionality. Special Projects — Not everyone has the inclination or time to become a power user. I am available to help you by creating an intricate Excel workbook, designing and producing a process illustration or trail graphic in PowerPoint, or applying styles throughout your document and giving it a style-generated Table of Contents. —|— Who hires me? I've worked for 90 law firms, plus companies in a number of other industries including healthcare, manufacturing, finance (banking, capital management, credit, etc.), government, document storage, hotels and hospitality, energy and emissions, data, automotive, museum displays, order fulfillment, insurance, staffing, communication, education, software and technology, construction and renovation, personal growth and coaching, retail sales, executive search, inspections, and many others. If you want more from Microsoft Office in the form of development, training, support, or special projects, or if your document is wonky, or if you're stuck and don't know what you need, let's talk. =Rob Mendell

I turn complex business problems into clean, automated solutions — whether that's a powerful no-code app built in AppSheet or a fully automated Excel/Google Sheets system with VBA and dynamic formulas. With 3–4 years of hands-on experience across freelance platforms and offline projects, I've helped businesses streamline their workflows, eliminate manual work, and make smarter decisions with their data. - What I Build with AppSheet ☑️ Custom Mobile Apps tailored to your team's workflow ☑️ No-Code / Low-Code Apps that non-technical teams can actually use ☑️ Database & Workflow Apps to manage operations end-to-end ☑️ Custom CRMs to track leads, clients, and sales pipelines ☑️ Inventory Management Systems with real-time tracking ☑️ Custom Apps built from scratch — whatever your business needs - What I Build with Excel & Google Sheets ☑️ Automated Data Processing & Reporting Tools (VBA/Macros) ☑️ Dynamic Dashboards & Interactive Visualizations ☑️ Quote, Estimation & Proposal Generators ☑️ Complex Data Models & Financial Tools ☑️ Professional Forms & Templates ☑️ Power Query transformations & PowerBI reports - Tools I Work With 🔹 AppSheet 🔹 Excel (VBA, Power Query, Macros) 🔹 Google Sheets (AppScript, Complex formulas etc.) 🔹 PowerBI 🔹 MS Word & MS Project 🔹 Python (for automation) - Why Work With Me? 🔸 Dual Expertise: Strong in both no-code app development (AppSheet) and advanced spreadsheet automation (rare combination). 🔸 Engineer's Mindset: I don't just build what you ask, I think through the problem and build what actually works. 🔸 Fast & Reliable: Timely delivery, high-quality results, no back-and-forth delays. 🔸 Clear Communication: Professional, responsive, and straightforward throughout the project. 🔸 Free Demo Work: Happy to share samples so you know what you're getting. 🔸 Ongoing Support: Revisions and post-delivery support included. Let's talk about your project, I'd love to help you build something that actually makes your work easier.

Looking forward to helping, serving and learning through small custom projects and using upwork to meet potential partners.

⭐ About Me ⭐ With over 22 years of hands-on experience in the IT industry, I am a Full Stack Developer, AI Chatbot Builder, and GoHighLevel Automation Expert specialising in building intelligent systems that generate leads, close deals, and run businesses on autopilot. My expertise spans across AI integration, CRM automation, full-stack development, and eCommerce delivering scalable, robust, and high-performing solutions that meet and exceed client expectations. ⭐ I HAVE MY OWN AGENCY WITH 50+ TEAM MEMBERS ⭐ ⭐⭐⭐⭐⭐⭐ Skills & Technologies ⭐⭐⭐⭐⭐⭐ 📌 AI & Automation: AI Chatbots, AI Agents, GoHighLevel (GHL), n8n, Make, Zapier, OpenAI API, LangChain, RAG Pipelines, Twilio Voice Bots, Workflow Automation, CRM Automation 📌 Backend Technologies: Node, Laravel, PHP, Python, ASP (.NET) Core, C#, Express, Flask, Firebase, RabbitMQ, Microservices, Docker, Kubernetes, Postgres 📌 Frontend Technologies: React, Next, Vue, Angular, TypeScript, Socket io, GraphQL, Tailwind CSS, HTML5, CSS3, Web3, React Native 📌 eCommerce Platforms: Shopify, WooCommerce, Multi-vendor Marketplace, Multi Channel Store 📌 CMS Platforms: WordPress, Drupal, Joomla, Wix, Squarespace 📌 Payment Integration: Stripe, PayPal, ACH, Authorize.net 📌 CRM & Marketing Tools: GoHighLevel, HubSpot, Salesforce, Zoho CRM, SharpSpring, Mailchimp, SendGrid 📌 Database: MongoDB, PostgreSQL, MySQL, MSSQL, Redis 📌 DevOps & Cloud: AWS, Docker, Kubernetes, CI/CD Pipelines, DigitalOcean, Linux Servers 📌 Graphic Design: UI/UX Design, Landing Page Design, Banners, Logo, Template Design 📌 Motion & Media: Motion Graphics, Video Editing, VFX, Social Media Posts 📌 SEO & Digital Marketing: SEO, AEO, On-Page SEO, Off-Page SEO, Social Media Marketing, Digital Marketing Strategy ⭐ Full Stack Development: Proficient in building end-to-end solutions combining modern frontend and backend technologies with a performance-first mindset. ⭐ AI Chatbot & Agent Development: Expert in building GPT-4 powered chatbots and autonomous AI agents that integrate into GHL, websites, and CRM systems automating lead follow-up, appointment booking, and customer support without human intervention. ⭐ GoHighLevel Automation: Complete GHL agency setups white-label SaaS, sub-account management, funnel building, pipeline automation, Stripe billing, and snapshot systems. ⭐ MERN Stack Development: Experienced in developing applications using MongoDB, Express, React, and Node ensuring seamless integration and optimal performance. ⭐ Database Management: Skilled in database design, optimisation, and management including MySQL, MongoDB, PostgreSQL, and MSSQL. ⭐ API Development: Expertise in designing and implementing RESTful APIs and GraphQL endpoints for seamless communication between frontend and backend systems. ⭐ Real-Time Applications: Experienced in building real-time systems using WebSockets and Socket io for live data, chat, and event-driven architectures. ⭐ Web3 & Blockchain: Experienced in building Web3-enabled platforms with blockchain frontend integration and smart contract connectivity. ⭐ DevOps & Deployment: Proficient in CI/CD pipelines, Docker, Kubernetes, and containerisation for automated deployment and scalability. ⭐ Why Hire Me? ⭐ 📌 Extensive Experience: 22 years in the IT industry. I have seen every type of project and challenge. Nothing surprises me. 📌 Full Agency Behind You: 50 specialists covering every skill your project needs backend, frontend, AI, DevOps, design, SEO, and motion no outsourcing, full accountability. 📌 Future-Ready Stack: AI Chatbots, GHL Automation, n8n workflows, and full-stack development. I build for where the market is going, not where it was. 📌 Commitment to Quality: Every project delivered with documentation, testing, and post-launch support built in not as an afterthought. 📌 Effective Communication: I send updates before you have to ask. If scope changes, I tell you immediately no hidden hours, no surprises. 📌 Customer-Centric Approach: Dedicated to understanding your business objectives and delivering solutions that exceed expectations and drive real results. ⭐ Industries I Have Served ⭐ eCommerce & Retail Fintech & Finance Healthcare Real Estate SaaS & Software Marketing Agencies Legal | Education Travel & Hospitality Logistics HR & Workforce Manufacturing Digital Marketing Web3 & Blockchain Enterprise Full Stack Developer | AI Chatbot Developer | AI Agent Developer | AI Integration Expert | GoHighLevel Expert | GHL Automation | GHL AI Integration | n8n Developer | Make Automation | Zapier Expert | MERN Stack Developer | Laravel Developer | Node.js Developer | React Developer | Next.js Developer | Python Developer | Shopify Developer | WordPress Developer | WooCommerce Developer | OpenAI API Integration | LangChain Developer | CRM Automation | Marketing Automation | Workflow Automation | API Integration Expert | SaaS Developer | ASP.NET Core Developer | PHP Developer | Full Stack Web Development | Business Automation | RAG Pipeline

Software Developer with 20 years overall experience located in Orlando, FL. Experienced in C#, ASP .Net MVC, ASP .Net Webforms, SQL Server, T-SQL, Angular, TypeScript, Kendo, EFCore, VB, JavaScript, jQuery, HTML, Entity Framework, Azure, PHP. Dedicated, hard worker determined to get your project complete in the most efficient and cost-effective manner.

.NET and Angular developer with extensive knowledge of application and database development. Over twenty years of experience developing software solutions for government and commercial clients.

✔ EXPERT DEVELOPER with Microsoft Access, Microsoft Excel, SQL Server, VBA, C# and APIs ✔ USER EXPERIENCE, DATA MODELING/REPORTING, APP PERFORMANCE, AND BUSINESS ANALYSIS are focal points of my work ✔ 29 YEARS as an independent software development professional delivering solid custom application solutions, Better Business Bureau A+ rating since 2001 ✔ PROVEN PROCESS MODEL for identifying user requirements, design, development, testing, performance tuning and implementation ✔ LONG-TERM SUPPORT AVAILABLE for maintenance and enhancements Here are the top criteria my clients tell me they value when I work with them: 🔹 Trustworthy and dependable 🔹 Attentive listener 🔹 Honesty and advocate for my best interests 🔹 Shows respect and patience 🔹 Wants to understand my business needs and participate in my success 🔹 Can discuss complex technical issues in language I understand 🔹 Someone who doesn’t try to “sell me” Do you want a consultant who: ◼ Is eager to share ideas for improving your process, data, and business decision-making? ◼ Understands the value of being available for quick updates, errors, bug fixes and answering questions? ◼ Helps you make informed decisions about your project? ◼ Has hands-on experience with owning and operating a business? ◼ Can help you avoid many common software project mistakes that hinder your business processes? Hire me to get these benefits. PROVEN TRACK RECORD I have successfully designed, developed and delivered several hundred applications since 1994 that are in use in the U.S., Canada, Europe and Central America. I have been BBB A+ rated since 2001. YOU MIGHT KNOW SOME OF MY CLIENTS WHO TRUST ME WITH THE APPLICATIONS - CUNA Mutual Group - Valassis - Harley Davidson - Zimmer Biomet (Switzerland) - State of Wisconsin - State of California - U.S. Army National Guard - Novozymes North America - Berry Plastics - American Medical Securities - Legion Insurance Company - Andis Corporation - Insinkerator - SC Johnson Wax - RR Donnelley - State of Georgia - State of Alaska - City of Milwaukee I'd love to add you to my list of great clients. Talk to you soon! ---------- ADDITIONAL TECHNICAL SKILLS ASP.Net, .Net Framework, .Net Core, AJAX, Wix Development, Wix API, Google/Amazon/Other APIs, Excel macros, Excel dashboards, Excel VBA, Word VBA, Outlook VBA, SQL Server, Oracle, MySQL, SQLite, WordPress, PHP