Maris Wanjiku

PORTFOLIO OBJECTIVE & VALUE STATEMENT I create clean, structured CRM data systems and monitor sales pipelines to ensure opportunities progress efficiently. Through audits, follow-ups, and risk analysis, I provide actionable insights that help sales teams improve performance and support business growth. This portfolio demonstrates my ability to analyze, organize, and optimize CRM operations, showing real operational work rather than theory. PORTFOLIO SUMMARY TITLE CRM Operations & Pipeline Analysis Portfolio. PROFESSIONAL FOCUS CRM Data Management, Sales Pipeline Monitoring, and Process Optimization. OVERVIEW I support companies by maintaining clean CRM data, monitoring sales pipeline performance, and designing follow-up systems that reduce deal inactivity and improve forecasting accuracy. CORE CAPABILITIES • • • • • CRM data quality auditing Sales pipeline analysis and reporting Detection of stuck or inactive deals Follow-up workflow design Spreadsheet-based reporting and insights TOOLS 1. Microsoft Excel 2. Google Sheets 3. Zoho CRM Maris Wanjiku – CRM Operations Portfolio -1- TYPICAL PROBLEMS I HELP SOLVE • • • • Incomplete or duplicate CRM records Deals remaining too long in pipeline stages Lack of follow-up activity on leads Unreliable pipeline reporting OUTCOME FOR BUSINESSES; Cleaner CRM data, clearer pipeline visibility, and structured follow-up systems that help sales teams convert deals more efficiently. CRM DATA QUALITY AUDIT PROJECT TITLE CRM Data Cleanup & Quality Audit OBJECTIVE Review CRM records to identify missing or incorrect deal data that could affect reporting and revenue forecasting. TASKS PERFORMED • • • • Checked deals for missing fields (amount, close date, contact) Identified duplicate contacts and companies Flagged incomplete deal records Organized CRM data for accurate reporting Maris Wanjiku – CRM Operations Portfolio -2- EXAMPLE FINDINGS IMPACT; Improved CRM data reliability, ensuring accurate pipeline reports and better sales forecasting. SALES PIPELINE MONITOR PROJECT TITLE: Pipeline Activity Review OBJECTIVE: Track deals across the pipeline to identify slow-moving or stalled opportunities. TASK PERFORMED / EXPLANATION: Monitored each deal’s stage, value, days in stage, last activity, and risk status. Maris Wanjiku – CRM Operations Portfolio -3- Formatting Used: Green - Healthy deals. Yellow - Deals to be monitored. Red – Deals at risk. IMPACT / OBSERVATION: Deals in Proposal or Negotiation stages for extended periods indicate potential delays or gaps in follow-up. RECOMMENDATION: Trigger follow-ups for deals exceeding normal stage duration; review proposal clarity or pricing. PORTFOLIO IMPACT STATEMENT: Identified stalled deals and bottlenecks, enabling proactive pipeline management and higher conversion potential. FOLLOW-UP PROCESS DESIGN PROJECT TITLE: Structured Follow-Up System OBJECTIVE: Maintain consistent prospect communication to prevent deal inactivity. TASK PERFORMED / EXPLANATION: Designed a timeline with follow-up actions (Day 2 reminder, Day 5 second follow-up, Day 8 at risk flag, Day 10 escalation). Maris Wanjiku – CRM Operations Portfolio -4- IMPACT / OBSERVATION: Structured follow-ups reduce inactive deals and increase pipeline efficiency. RECOMMENDATION: Implement automated reminders in the CRM for inactive deals. PORTFOLIO IMPACT STATEMENT: Structured follow-ups to reduce deal inactivity and maintain consistent client engagement. SUMMARY TABLE PROJECT TITLE: Operational Summary OBJECTIVE: Provide a concise overview of CRM data and pipeline health. TASK PERFORMED / EXPLANATION: Consolidated audit findings and pipeline monitoring. Maris Wanjiku – CRM Operations Portfolio -5- IMPACT / OBSERVATION: Highlights operational strengths and areas needing attention quickly. RECOMMENDATION: Regular review to ensure continuous improvement. PORTFOLIO IMPACT STATEMENT: Provided a concise operational overview that highlights key findings. PIPELINE STAGE DISTRIBUTION PROJECT TITLE: Pipeline Visualization OBJECTIVE: Analyze how deals are distributed across sales stages to detect bottlenecks. TASK PERFORMED / EXPLANATION: Counted deals in each stage and generated a visual chart. Maris Wanjiku – CRM Operations Portfolio -6- IMPACT / OBSERVATION: High concentration in the Proposal stage may indicate slow client decisions or delayed follow-ups. RECOMMENDATION: Review proposals and follow-up timing for smoother pipeline progression. PORTFOLIO IMPACT STATEMENT: Visualized deal distribution to detect pipeline bottlenecks and optimize stage progression. OPERATIONAL NOTES PROJECT TITLE: CRM Performance Metrics OBJECTIVE: Track essential metrics to monitor pipeline health and sales operations efficiency. Maris Wanjiku – CRM Operations Portfolio -7- Average Days in Stage Measures the average time deals spend in each pipeline stage. This metric helps detect bottlenecks where opportunities remain longer than expected, indicating delays in the sales process. Deal Activity Tracks the frequency of interactions with prospects such as calls, emails, or meetings. Low activity levels may indicate deals that lack follow-up and risk becoming inactive. Conversion Rate Measures the percentage of deals successfully moving from one stage to the next. It helps evaluate how effective each stage of the sales process is at progressing opportunities. Deal Data Completeness Assesses whether required deal information such as deal value, contact details, or stage information is properly recorded. Complete data ensures accurate reporting and reliable sales forecasting. Pipeline Value Pipeline Value represents the total monetary value of all active deals currently in the sales pipeline. This metric helps estimate potential revenue and allows sales managers to evaluate whether the pipeline contains enough opportunities to meet revenue targets. Maris Wanjiku – CRM Operations Portfolio -8- CLOSING NOTE This portfolio demonstrates practical CRM operations tasks including data quality auditing, sales pipeline monitoring, follow-up process design, and pipeline performance analysis. The examples highlight how structured data management and operational monitoring can support sales teams, improve pipeline visibility, and enable more informed revenue decisions. Maris Wanjiku – CRM Operations Portfolio -9-