Freelancers in Oyster BayFreelancers in Oyster Bay
ProjectsPeople
Bertha Edson's avatar
Bertha Edson
Dar es Salaam, Tanzania
Content and influencer strategy for mission based brands.
8x
Hired
5.0
Rating
30
Followers
Content and influencer strategy for mission based brands.
Cover image for Aroppo Affiliate Micro Creator Campaign
Aroppo Affiliate Micro Creator Campaign
1
4
Cover image for A Winning Social Media Strategy for Skincare Personal Brand
A Winning Social Media Strategy for Skincare Personal Brand
0
40
Cover image for YouTube Growth Strategy for Vibe Coding Tool
YouTube Growth Strategy for Vibe Coding Tool
0
14
Cover image for Creator-Led Marketing Campaign for Amplenote
Creator-Led Marketing Campaign for Amplenote
1
14
Mwanahamisi Juma's avatar
Mwanahamisi Juma
Dar es Salaam, Tanzania
Healthcare Data Analyst | Claims,Operations & Readmission
New to Contra
Healthcare Data Analyst | Claims,Operations & Readmission
Cover image for I ran statistical tests on
I ran statistical tests on 4,500 healthcare insurance claims worth $22.5M, half-expecting patient demographics to explain at least some of the cost variation. They didn't. Age, income, gender, provider specialty, even claim type — none of it came back statistically significant against claim amount or status. What actually stood out was Pediatrics. $4.9M in claims, the highest average claim amount of any specialty. Not a "who's filing the claim" problem — a specialty-specific one. I built four Power BI dashboards (Executive, Patient Insights, Provider Performance, Claims Analysis) so this kind of pattern shows up as it happens, not just in a one-off report six months later. If your team is still reviewing claims by demographic segment, this might be worth a second look.
0
10
Cover image for Where is the money going
Where is the money going — and what is actually driving healthcare claim costs? I analyzed 4,500 healthcare insurance claims worth 22.56M using SQL, Python, and Power BI to identify cost drivers, provider performance patterns, and inefficiencies in claims processing. A few things stood out. Pediatrics accounted for 4.9M in claims, making it the largest expenditure driver among provider specialties. Outpatient services had the highest claim volume, while a small number of diagnosis codes accounted for a disproportionate share of total costs. Claim spending also peaked in November 2023. I then tested whether patient demographics, provider specialty, and claim type were actually driving claim amounts or claim outcomes. The statistical tests found no significant associations, suggesting that clinical and operational factors may matter more than demographics alone. Based on the findings, I recommended monitoring high-cost diagnoses and specialties, investigating the November spending spike, improving the handling of pending and denied claims, increasing electronic claim submission, and incorporating clinical and operational variables into future predictive models. I built interactive Power BI dashboards covering executive KPIs, patient demographics, provider performance, and claims activity — giving healthcare teams a clearer view of where costs are concentrated and where operational problems need investigation. Tools: SQL · Python · Power BI · Excel
0
50
Cover image for Which patients are most likely
Which patients are most likely to be readmitted — and where should a hospital focus its limited follow-up resources? I analyzed hospital readmission patterns using SQL, Power BI, and DAX, looking at diagnoses, prior readmissions, comorbidity burden, discharge disposition, insurance, demographics, and seasonal trends to identify where readmission risk was concentrated. A few things stood out. Patients with no prior readmissions had a 27.79% readmission rate, compared with 69.50% after just one prior readmission. Patients with 4+ comorbidities reached 75.05%+, while high-risk conditions such as sepsis, COPD, heart failure, stroke, and kidney disease showed the highest readmission rates. Skilled nursing facility discharges were also particularly high at 92.80%. The bigger opportunity was turning those patterns into action. I used the findings to define a practical high-risk flagging approach — prioritizing patients with previous readmissions, high comorbidity burden, high-risk diagnoses, or post-acute care needs for earlier follow-up, medication reconciliation, and stronger discharge coordination. I built an interactive Power BI dashboard with executive, clinical, and risk-focused views, turning hospital readmission data into something healthcare teams could actually use to prioritize patients and target intervention where it matters most. Tools: SQL · Power BI · DAX · Excel
0
66
Cover image for I analyzed a hospital's full
I analyzed a hospital's full operations picture — patient demand, physician workload, treatment costs, appointment performance, and billing — using Excel, SQL, and Tableau, to help hospital leadership see where things were quietly going wrong before the losses added up. A few things stood out. Pediatrics and Dermatology carried the highest patient volume and physician workload — meaning a small group of doctors were absorbing most of the pressure, which is a staffing risk if any of them become unavailable. On the revenue side, Chemotherapy and MRI were the top earners (11.6% and 10.5% of total revenue), driven by cost and case complexity rather than sheer demand. The bigger problems were in the pipeline itself: only 23% of appointments were actually completed, with 26% no-shows and 25.5% cancellations — nearly half the appointments never happened. And on the billing side, only 32% of revenue was cleanly collected; 34% sat pending and 33% failed outright. That's close to two-thirds of billed revenue not coming in on the first try. So what does a hospital actually do with this? Based on the data, I recommended: investigating what's driving the near-50% no-show/cancellation rate and testing fixes like reminders or flexible rebooking; reviewing the billing workflow behind the pending/failed payments, since documentation and payer communication were the likely starting points; adding block scheduling or dedicated clinics for high-cost services like Chemotherapy and MRI to raise equipment utilization; and rebalancing appointment volume away from the Central branch, which was absorbing most of the demand while Eastside and Westside sat underused. I built interactive Tableau dashboards so HR, Operations, and Finance could each track the KPIs relevant to their team in real time — turning a pile of scattered hospital data into something leadership could actually act on.
0
67
Joseph Masonda's avatar
Joseph Masonda
Dar es Salaam, Tanzania
Expert in Framer Websites & Brand Strategy
7
Followers
FRAMER_EXPERT

expert

Expert in Framer Websites & Brand Strategy
Cover image for MARCA LUNA - Personal Project The
MARCA LUNA - Personal Project The problem Photographers and creatives have incredible portfolios. But their websites feel dated. Flat layouts. No soul. Slow performance. The work gets lost in the noise → potential clients move on. What we’ve built We didn’t just build a gallery. We built an editorial experience. ✔️ 3D Perspective Transitions ✔️ Headless CMS Integration (Sanity.io (http://Sanity.io)) for real-time updates ✔️ Responsive, high-performance animations ✔️ Cinematic "Works" scroll interactions ✔️ A digital space that feels as premium as the work it holds The result → The work is no longer just "on a site." It’s in a gallery. Clean code. Brutalist design. Performance that scales. 💭 What’s the biggest challenge you face when presenting your work online? Lack of immersion? Speed issues? Design that doesn't fit the brand? 📌 Save this if you’re elevating your digital presence in 2026 🚀 checkout this passion project here: https://marc-luna-portfolio-pi.vercel.app/
0
50
Cover image for AfrONet — the African Organic
AfrONet — the African Organic Network. The problem AfrONet is uniting Africa's organic agriculture ecosystem. Connecting farmers, policymakers, researchers, and markets across the continent. 2 million+ farmers reached. 20+ policy roundtables. Funded by AFD. But their digital home didn't carry that weight. What we built A website that finally matches the scale of the mission. ✔️ Clean editorial layout that tells the story — not just lists the facts ✔️ Headless CMS (WordPress) so the team can publish news and updates in real time ✔️ Responsive, high-performance build across all devices ✔️ Structured programme pages that make the work easy to navigate and understand ✔️ A digital presence that says: this organisation is serious The result → afronet.bio (http://afronet.bio) now commands the credibility the work deserves. From smallholder farmer networks in Uganda to policy tables across Africa — the mission is clear the moment you land on the page. Purpose-driven design. Solid build. A website that works as hard as the people behind it. 💭 Does your organisation's website reflect the scale of what you're actually doing — or is it still catching up? 📌 Save this if you're thinking about elevating your digital presence in 2026 🔗 Visit the site: afronet.bio (http://afronet.bio)
0
60
Cover image for Working on this Framer website
Working on this Framer website for a personal project!
1
115
Cover image for Free Framer Template for Interior Designers
Free Framer Template for Interior Designers
0
20
abdul juma's avatar
abdul juma
Dar es Salaam, Tanzania
Logo design & Branding
New to Contra
Logo design & Branding
Cover image for Logo System & Visual Identity Package
Logo System & Visual Identity Package
1
241
Cover image for WEXED AI is an artificial
WEXED AI is an artificial intelligence platform built to power smart workflows and creative operations. The objective was to design a futuristic, sleek visual identity system that positions WEXED as a bold leader in tech innovation. What was done: Symbol & Logo Design: Designed a high-tech geometric mark paired with bold typography to convey speed, connection, and intelligence. Color Palette & Guidelines: Selected Violet, Rich Black, and Pure White tones to evoke innovation and modernity, complete with color codes and typography specs. Brand Applications & Vehicle Wrap: Created stationery systems, digital billboards, and vehicle branding mockups to demonstrate scale. Deliverables: Geometric AI Logo, Color & Typography Guidelines, Vehicle Branding, Stationery, and Digital Advertising Assets.
1
280
Cover image for Kevoo Hair Artist is a
Kevoo Hair Artist is a high-end beauty and hair styling brand dedicated to delivering premium, modern hair artistry. The goal was to build a sleek, sophisticated visual identity that appeals to a fashion-forward clientele and establishes a strong professional presence. What was done: Custom Logo Design: Created an elegant wordmark with refined typography and smooth curves, reflecting style, fluidity, and elegance. Brand Identity & Photography: Developed high-contrast imagery and brand visuals tailored for promotional banners, social media marketing, and salon branding. Storefront & Outdoor Collateral: Designed outdoor signage and hanging banner mockups for physical salon branding. Deliverables: Primary Wordmark Logo, Brand Identity System, Social Media Templates, and Outdoor Signage Mockups.
1
276
Cover image for Kivu Coffee Co. is a
Kivu Coffee Co. is a premium coffee brand focused on delivering rich, organic coffee experiences. The goal was to create a modern, memorable, and cohesive visual identity that reflects the brand's heritage while standing out on retail shelves and digital platforms. What was done: Logo & Monogram: Crafted a primary logo and a secondary circular monogram icon featuring a coffee leaf design for versatile applications. Visual Identity: Combined a deep forest green with warm cream accents for an organic, high-end visual tone. Packaging & Collateral: Designed coffee pouch packaging along with brand stationery, custom cups, and merchandise mockups. Deliverables: Primary & Secondary Logos, Monogram Icon, Brand Color Palette, Packaging Design, and Brand Collateral Suite.
1
300
Ashel Boniface's avatar
Ashel Boniface
Dar es Salaam, Tanzania
Creative Designer Crafting Impactful Brand Visuals
5.0
Rating
1
Followers
Creative Designer Crafting Impactful Brand Visuals
Cover image for I designed social media posters
I designed social media posters to promote the organization’s participation in CSO Week 2024 in Arusha, Tanzania, combining event information with compelling imagery to create engaging content for online audiences.
1
119
Cover image for I designed the logo for
I designed the logo for a mental health awareness campaign called “Kijana Tubonge,” aimed at encouraging university youth to speak openly about their challenges. To support the campaign, I also created T-shirt mockups for printing and designed social media posters to help spread the message online.
1
70
Cover image for In this project, I was
In this project, I was hired to design roll-up banners for an Agroecology Conference. I created the banner layout and visual composition following the campaign branding. The photos used in the design were taken by me during field visits as part of the project, helping to showcase real farmers and the impact of agroecological practices.
1
68
Cover image for In this project, I was
In this project, I was hired to design a logo for a local driving school. After the client was satisfied with the final logo, they trusted me with additional work, including branding their training cars and designing brochures. It was a great experience, and I was proud to see my work help the business present a stronger and more professional brand.
0
59