KIRAN Society — Executive BI Suite
End-to-end Looker dashboard ecosystem for IT, Sales, Revenue, Finance, and Database verticals with version-controlled data models and automated stakeholder reporting.
↑ 40% faster C-suite decisions
LookerSQLData ModellingGCPVersion Control
LetsUpgrade — EdTech Growth KPI Dashboard
Power BI & Tableau dashboards tracking student enrollments, completion rates, revenue per cohort, and lead conversion funnels for weekly C-suite review.
Reduced reporting time by 60%
Power BITableauSQLCRMExcel
Unbound Marketing — Scalable Reporting Framework
GCP-backed Power BI infrastructure consolidating multi-channel campaign data into a single executive reporting layer, replacing 6 manual weekly reports.
6 manual reports automated
Power BIGCPPythonSQL
Pipeline Quality & Data Integrity Project
Audited KIRAN Society's upstream data pipelines, introduced automated quality checks, resolved schema drifts and cross-department discrepancies.
↓ 25% report discrepancies
SQLETLData QualityPipeline Ops
High-Value Client Segmentation — LetsUpgrade
SQL-driven RFM and cohort analysis to surface high-intent learner segments. Results fed directly into Sales CRM workflows for precision outreach.
↑ 28% acquisition efficiency
SQLPythonCohort AnalysisRFMCRM
Demand Forecasting & Capital Planning
Regression and time-series models in Python to forecast product demand and capital needs, enabling proactive budget and inventory planning at Unbound.
Forecast accuracy improved 20%
PythonRegressionTime-SeriesExcel
Digital Fundraising — Meta & Google Ads
End-to-end paid digital fundraising campaigns on Meta (Facebook/Instagram) and Google Ads for KIRAN Society — targeting, creative, budget management, and conversion tracking.
- Audience segmentation and lookalike targeting
- A/B testing ad creatives and copy
- Conversion pixel setup and attribution
- Monthly ROI and donor acquisition reports
↑ Donor acquisition via paid channels
Meta AdsGoogle AdsPixel/GTMAnalytics
Crowdfunding & Platform Collaborations
Managed crowdfunding campaigns and built strategic collaborations with fundraising platforms (Milaap, Give India, Ketto) to diversify KIRAN Society's donor channels.
- Campaign creation, content, and storytelling
- Platform onboarding and compliance documentation
- Donor communication and update workflows
- Performance tracking and fund reconciliation
Multi-platform donor base built
Crowdfunding PlatformsContent StrategyDonor Mgmt
Payment Gateway Implementation — Multi-Site
Implemented and integrated payment gateways across multiple KIRAN Society websites — supporting India domestic and cross-border donations, both online and offline workflows.
- Razorpay, PayU, and international gateway setup
- Manual and automated payment reconciliation
- Seamless donor checkout — UPI, cards, net banking, SWIFT
- Cross-border FCRA-compliant donation flow
- Automated donor database records and receipts
- Real-time payment dashboard and MIS reports
India + cross-border donations live
RazorpayPayUFCRAAutomationSQLDashboard
HRM Implementation & Workforce Automation
Full-cycle HRM system deployment at KIRAN Society — from server setup and employee database to payroll, leave management, and role-based access control.
- Employee database — onboarding, records, daily updates
- Server creation and maintenance (on-prem + cloud)
- Automated workflows: attendance, leave, approvals
- Payroll setup — salary slips, compliance, TDS
- Department-wise user training and documentation
- HR analytics dashboard — headcount, attendance, payroll
Payroll & HR fully automated
HRM SoftwareServer AdminAutomationPayrollSQLTraining
ERP/CRM Implementation — Organisation-Wide
Deployed and customised an integrated ERP/CRM across all KIRAN Society departments — eliminating manual work, ensuring data transparency with donors and Govt officials.
- Backend and front-end customisation per department
- Donor and government stakeholder portal setup
- Bulk data filtration, import/export pipelines
- Cross-department workflow automation
- Database integrity and access control management
- End-user training across all verticals
Manual workload reduced org-wide
ERPCRMBackend CustomisationSQLAutomationTraining
KIRAN Society — Main Website
Full-cycle website development for KIRAN Society — from architecture and design to content, SEO, automation, hosting, and cloud deployment.
- Content creation, copywriting, and publishing
- Department-wise pages and workflow integration
- SEO keyword research and on-page optimisation
- Automation: forms, donation flow, email triggers
- Hosting, cloud infrastructure, and domain management
Live — SEO-optimised & automated
CMSSEOCloud HostingAutomationDomain Mgmt
KIRAN Poornima — Dedicated Website
Separate website for KIRAN's Poornima programme — independent design, content strategy, workflow integrations, and SEO tailored to the programme's audience.
- Unique brand identity and design system
- Programme-specific pages and department workflows
- SEO, keyword mapping, and content calendar
- Hosting, SSL, domain, and cloud setup
Standalone programme presence built
CMSSEOBrandingHostingAutomation
KIRAN Livelihood — Dedicated Website
Standalone website for KIRAN's Livelihood initiative — focused on beneficiary storytelling, programme showcases, and donor engagement for livelihood-linked funding.
- Content architecture and beneficiary impact pages
- Department workflow and CTA integration
- SEO and visibility strategy for livelihood sector
- Cloud hosting and domain with uptime monitoring
Dedicated donor engagement built
CMSSEOContent StrategyHosting
Social Media — Daily Automation & Growth
Full social media ownership for KIRAN Society across YouTube, Instagram, Facebook, and X — combining daily post automation, graphic design, and visibility growth.
- Daily post scheduling and automation workflows
- Graphic design and content creation (Canva/Adobe)
- Platform-specific content strategy and marketing
- Hashtag research, engagement tracking, audience growth
- Video content planning and YouTube channel management
↑ Reach across 4 platforms
MetaInstagramYouTubeXCanvaBuffer
WhatsApp Business API — Automation & Campaigns
Implemented WhatsApp Business API for donor communication, staff coordination, and fundraising campaigns — replacing manual messaging with scalable automated workflows.
- Chatbot and CTA workflow setup
- Calendar-based reminder and follow-up automation
- Broadcast campaign management for donors and staff
- Opt-in list management and compliance
- Integration with CRM and payment gateway
Bulk messaging automated at scale
WhatsApp APIAutomationCRM IntegrationCampaigns
IT Department — End-to-End Infrastructure
Complete IT infrastructure ownership at KIRAN Society — from physical security (CCTV), network (WiFi/Firewall), servers, and cloud to asset management and day-to-day support.
- CCTV installation, configuration, and monitoring
- WiFi network design, deployment, and optimisation
- On-prem and cloud server setup and maintenance
- Firewall rules, network security, and VPN management
- IT asset tracking — hardware, software licences
- Cloud infrastructure management (GCP)
- IT support, troubleshooting, and vendor coordination
Zero critical downtime maintained
CCTVWiFiServer AdminFirewallGCPAsset Mgmt
Campaign Performance Analysis — Unbound Marketing
Statistical deep-dive across digital campaigns: A/B testing, hypothesis testing, attribution modelling, and audience segmentation to identify highest-ROI channels.
↑ 34% customer acquisition growth
PythonHypothesis TestingA/B TestingSQLGoogle Analytics
Annual Report & Digital Communications
End-to-end ownership of KIRAN Society's annual impact report, monthly newsletter, and digital communications — blending data storytelling with visual design.
Org-wide content standardised
Adobe AEMContent StrategyData StorytellingDesign
Donor Analytics & Fundraising Dashboard
Built a unified fundraising analytics layer covering all channels — Meta Ads, Google Ads, crowdfunding, and offline. Real-time donor acquisition, cost-per-donor, campaign ROI, and fund reconciliation in one dashboard.
- Cross-channel attribution model for paid and organic donors
- Donor retention, repeat-giving, and LTV analysis
- Monthly campaign performance report for leadership
- Automated reconciliation between platform receipts and internal records
All fundraising channels in one view
Power BISQLMeta AdsGoogle AdsSpreadsheets
Multi-Site Payment Gateway — India & Cross-Border
Implemented and integrated payment gateways across multiple KIRAN Society websites — supporting both domestic (UPI, NetBanking, Cards) and international donations with full donor database management.
- Gateway selection, onboarding, and KYC/compliance documentation
- Embedded checkout integration on 3 websites (KIRAN, Poornima, Livelihood)
- Offline donation capture and reconciliation workflow
- Automated payment confirmation emails and receipts via workflow engine
- Cross-border payment routing and FCRA compliance tracking
- Donor database records — manual entry + automated sync
- Payment dashboard: real-time collections, failures, refunds
Seamless online + offline donation flow
Razorpay / InstamojoUPIFCRAAutomationSQLDashboard
HRM System — Full Implementation & Operations
End-to-end Human Resource Management system implementation at KIRAN Society — from server setup and employee database creation through daily operations, payroll, and automation.
- Employee master database — onboarding, records, documents, history
- Daily attendance, leave, and performance data updation workflows
- Dedicated server setup and maintenance for HRM platform
- Payroll configuration — salary structures, deductions, PF/ESI, tax
- Automated payslip generation and distribution
- Automated workflows: leave approvals, onboarding checklists, exit processes
- End-user training for HR team and department heads
- HRM dashboards: headcount, attrition, payroll cost, leave trends
Full HR cycle automated org-wide
HRM PlatformPayrollServer AdminAutomationSQLDashboardTraining
Donor & Government Stakeholder CRM Portal
Custom CRM portal built within the ERP framework giving donors real-time access to fund utilisation and government officials visibility into compliance — reducing manual reporting requests by building self-serve transparency.
- Role-based access for donors, staff, and government stakeholders
- Live fund utilisation and programme progress views
- Automated compliance report generation for government submissions
- Donor communication history and follow-up workflow
- Bulk data import/export for legacy record migration
Transparency built into every stakeholder layer
CRMERPRole-Based AccessAutomationSQLBulk Import/Export
3-Website Ecosystem — Architecture & Operations
Designed and manages a 3-website digital ecosystem for KIRAN Society (main brand, Poornima programme, Livelihood initiative) — unified hosting infrastructure, shared automation layer, and independent SEO strategy per site.
- Shared cloud hosting with independent domain and SSL per site
- Centralised form and lead capture → CRM auto-sync workflow
- Automated donation redirect and payment gateway routing by site
- Uptime monitoring, backup scheduling, and disaster recovery plan
- Cross-site SEO: keyword mapping, interlinking, and Google Search Console
- Site-speed optimisation and Core Web Vitals monitoring
3 live sites — automated, SEO-ready, cloud-hosted
CMSCloud HostingSEOAutomationSSLGoogle Search Console
Social Media Performance Analytics
Built a social media analytics dashboard aggregating reach, engagement, follower growth, and campaign performance across YouTube, Instagram, Facebook, and X — feeding monthly strategy reviews.
- Multi-platform data aggregation (Meta Insights, YouTube Studio, X Analytics)
- Content performance scoring — reach, saves, shares, CTR
- Best time to post analysis per platform and audience segment
- Monthly growth report with visual trend charts for leadership
- Hashtag and keyword performance tracking
Data-driven content strategy across 4 platforms
Meta InsightsYouTube StudioGoogle Data StudioExcelCanva
Network, Server & Cloud Architecture
Designed and manages KIRAN Society's complete network and cloud architecture — from on-prem server rooms and structured WiFi to GCP cloud services, firewall policy, and real-time monitoring.
- Structured WiFi deployment — access points, VLANs, bandwidth management
- On-prem server setup: domain controller, file server, backup server
- GCP cloud: compute instances, cloud storage, IAM, and billing management
- Firewall rules, IDS/IPS configuration, VPN for remote staff access
- CCTV — IP cameras, NVR, remote monitoring and alert workflows
- IT asset register: hardware lifecycle tracking, warranty, software licences
- SLA-based vendor coordination for ISP, hardware, and cloud providers
Zero critical downtime — 99.9% uptime maintained
GCPLinux ServerFirewallVPNWiFi DesignCCTVAsset Mgmt
Cross-Functional IT & Data Team Leadership
Leading Database, IT, Sales, Revenue, Finance, and Digital departments at KIRAN Society — driving resource allocation, operational budgets, and stakeholder alignment.
6 departments unified under one ops layer
Team LeadershipProject MgmtBudgetingStakeholder Comms
Client Lifecycle Management — LetsUpgrade
Full client journey ownership from onboarding through renewal — retention frameworks, CRM health dashboards, and escalation workflows that measurably reduced churn.
↑ Renewal rates YoY
CRMClient SuccessRetention StrategyReporting
User Training & Digital Literacy Programme
Designed and delivered training programmes for KIRAN Society staff across ERP, HRM, CRM, website CMS, WhatsApp API, and social media tools — ensuring org-wide adoption of all implemented systems.
- Role-specific training modules for HRM, ERP/CRM, and web CMS
- Step-by-step SOPs and video walkthroughs for recurring tasks
- Post-training support desk and issue resolution workflow
- Onboarding kit for new staff covering all digital tools
100% staff adoption of deployed systems
TrainingSOPsERPHRMCRMCMSWhatsApp API
Bulk Data Migration, Filtration & Import/Export
Managed large-scale data migration into KIRAN Society's ERP/CRM — cleansing legacy records, building filtration pipelines, and setting up repeatable bulk import/export processes across departments.
- Legacy data audit and deduplication — 10,000+ records cleaned
- Custom import templates per department with validation rules
- Scheduled bulk export workflows for compliance and audit submissions
- Error-handling pipelines with exception logs and reconciliation reports
- Data dictionary and field-mapping documentation for future teams
Legacy data fully migrated & live in ERP
SQLPythonERP Data ToolsETLExcelData Cleaning
Offline Fundraising & CSR Collaboration
Structured offline fundraising operations at KIRAN Society — building corporate CSR partnerships, grant proposals, and event-based fundraising pipelines alongside the digital channels.
- CSR proposal writing and corporate partner outreach
- Grant identification, application, and compliance documentation
- Fundraising event planning and donor stewardship workflows
- Offline donation capture and reconciliation into central donor database
- Quarterly donor impact reports for corporate and grant funders
Diversified funding — digital + offline + CSR
Proposal WritingCSRDonor MgmtGrant ComplianceReporting
Visual Identity & Graphic Design System
Built and maintains KIRAN Society's visual brand system — creating a consistent design language across all social media, print, digital reports, event collateral, and website assets.
- Brand kit: colour palette, typography, logo usage guidelines
- Social media template library — 50+ reusable post formats
- Campaign creatives for fundraising, events, and awareness drives
- Annual report layout and infographic design
- Banner and collateral design for on-ground events and exhibitions
- Video thumbnail and YouTube channel art
Unified visual identity across all channels
Canva ProAdobe IllustratorAdobe AEMBrand DesignInfographics
IT Security, Asset Management & Compliance
Established KIRAN Society's IT governance framework — covering asset lifecycle management, data security policies, backup and recovery, and regulatory compliance for NGO digital operations.
- IT asset register — hardware, software licences, warranty tracking
- Data backup policies: daily automated backups with off-site copy
- User access management — role-based accounts, password policies, MFA
- FCRA and NGO data compliance documentation
- Incident response process and IT helpdesk workflow
- Vendor SLA management — ISP, hardware, cloud, security providers
IT governance framework established from scratch
Asset MgmtData BackupMFARBACFCRA ComplianceVendor Mgmt
Advanced Google Analytics & SEO Performance
Google Analytics 4 implementation and advanced tracking setup across KIRAN Society's 3 websites and previous roles — enabling full funnel visibility, goal tracking, and data-driven SEO decisions.
- GA4 setup — events, conversion goals, funnel tracking
- Google Tag Manager implementation for marketing pixel management
- Search Console integration — keyword ranking, CTR, impression tracking
- Custom GA dashboards and automated weekly performance reports
- Bounce rate and user journey analysis to optimise landing pages
- SEO keyword mapping, on-page optimisation, and backlink monitoring
Full web analytics stack live on 3 websites
GA4Google Tag ManagerSearch ConsoleSEOLooker Studio
Market Research & Competitive Intelligence — LetsUpgrade
Conducted structured market research and competitive analysis to support LetsUpgrade's product roadmap and expansion into new learner segments — feeding findings directly into strategic planning sessions.
- EdTech market sizing and segment analysis across India
- Competitor benchmarking: pricing, course catalogue, UX, NPS
- Learner demand forecasting for new course verticals
- Survey design, data collection, and statistical analysis
- Executive strategy decks with market entry recommendations
New segments identified → 2 product launches
Market ResearchPythonSurvey AnalyticsExcelPowerPoint
Donor & Payment Intelligence Dashboard
Unified BI dashboard covering all donation channels — online, offline, India domestic, and cross-border — giving leadership real-time visibility into fund flow, donor behaviour, and reconciliation status.
- Real-time donation tracking: collections, pending, failed, refunds
- Donor segmentation: new vs. repeat, channel, geography, amount tier
- FCRA fund utilisation vs target tracking for compliance reporting
- Automated daily reconciliation between gateway and internal records
- Drill-down views by programme, campaign, and time period
360° donor + payment visibility in one view
Power BISQLRazorpay APIAutomationFCRA Tracking
