Combinesd lti skilled Portfolio D
DAVID DADA – MULTI-SKILLED PROFESSIONAL PORTFOLIO
1. DATA ANALYST PROJECTS
🔹 Customer Purchase Behavior Analysis
Tools Used: Excel, Python (Pandas, Matplotlib), Power BI
Description:
- Collected and cleaned 10,000+ customer records from a retail database.
- Identified purchasing trends by age, region, and season.
- Created an interactive Power BI dashboard for the marketing team.
Impact: Improved targeted marketing strategies and increased
engagement by 22%.
🔹 Sales Forecasting with Time Series Analysis
Tools Used: Python (statsmodels), Excel
Description:
- Analyzed 36 months of historical sales data using ARIMA modeling.
- Predicted monthly sales for the next year with 90% confidence interval.
Impact: Helped management plan inventory and staffing more effectively.
2. EMAIL MARKETING MANAGER PROJECTS
🔹 B2B Cold Email Campaign for SaaS Product
Platform Used: Mailchimp, Lemlist
Description:
- Wrote and designed 3-email sequence for a SaaS product targeting HR
managers.
- Conducted A/B testing on subject lines and CTA buttons.
- Segmented leads into behavior-based groups.
Result: Achieved 48% open rate, 12% CTR, and booked 15 demo calls.
🔹 Newsletter Management – Monthly Digest
Platform Used: Mailchimp
Description:
- Managed a 5,000-subscriber list.
- Created monthly content calendars, wrote copy, and managed
scheduling.
- Used analytics to track and optimize email performance.
3. COPYWRITING PROJECTS
🔹 Landing Page Copy for Online Course
Description:
- Researched target audience and wrote persuasive landing page copy for
an AI course.
- Focused on benefits, social proof, and strong CTA.
Result: Conversion rate increased from 3.5% to 7.8%.
Topics Covered: Personal finance, investing tips, and fintech tools
SEO Tools: SurferSEO, Yoast
Result: Articles ranked on Google page 1 for multiple keywords.
4. DATABASE MANAGEMENT PROJECTS
🔹 CRM Database Cleanup & Optimization
Tools Used: Microsoft Access, SQL Server, Google Sheets
Description:
- Standardized fields, removed duplicates, and created data entry rules.
- Built user-friendly dashboards to track client follow-up and sales
progress.
🔹 Inventory Management System Setup
Tools Used: Airtable / Excel / MySQL
Description:
- Designed inventory database with auto-updating stock alerts.
- Integrated order forms and summary reports.
Impact: Reduced stock outages by 40%.
🏆 Skills Summary
Skill Area
Tools & Platforms
Data Analysis
Excel, Python, SQL, Power BI
Email Marketing
Mailchimp, Lemlist, Sendinblue
Copywriting
WordPress, SurferSEO, Grammarly
Database Management
MySQL, Airtable, MS Access,
Google Sheets