Shivam Garg

Business Analyst @KollegeApply

Gurugram, IN

Owned the end-to-end CRM product on Zoho, designed PRDs by gathering pain-points, feature optimisation, business and functional requirements from stakeholders – wireframed elements and modular workflows - Deals, Accounts, Contacts, Meetings, Collections. • Improved system reliability by 50% and cut data latency by 80% by architecting real-time bi-directional sync between Zoho CRM and PostgreSQL using Python FastAPI. • Reduced manual effort by 60% and errors by 40% through automated record creation, field-level validations and duplicate-prevention logic implemented via Deluge scripting in each sprint backlog. • Decreased approval TAT by 55% by analysing process bottlenecks, implementing multi-level approval workflows, auto-verification triggers, and automated GST/non-GST reconciliation. • Accelerated reporting cycles by 70% and saved 20+ hours/week by designing metrics-driven dashboards and pipelines in Zoho Analytics s using advanced SQL (CTEs, window functions), tracking deal funnel, revenue progress, and SLA compliance, client LTV based on deal metrics. Campaign Decision Analytics (META & Google AdWords) • Improved conversion efficiency by 18% by analysing Cost per Ad, CPC, CVR, CPA and ROI across META and Google AdWords, reallocating 25-30% of budget to higher-ROI channels. • Increased CTR by 12% and conversions by 15% through platform-level hypotheses and A/B testing, validating differences in mean conversion rate, clicks, and conversions using t-tests and p-values. Automated 6Lakh+ SEO content blocks across 52K+ college accounts, saving 450+ hrs/month • Scaled 12-silo content blog using LangChain Chat models of OpenAI, Perplexity, and using Google Apps Script and python scripts. • Reduced manual effort by 90% and used reusable prompts with 35% lower failure rates through generative AI techniques • Web Scraped JSON listing pages 20+ websites using browser automation Python (Selenium, Numpy, Pandas, BeautifulSoup), cleaned.

Delhi Technological University (Formerly DCE)

B.Tech electronics and communication with applied physics Minors In Computer Science