Yash - Administrative Assistant with 3 years of experience in office support

Utilized Microsoft Office tools extensively for document preparation, spreadsheets, and presentations.

Supported collaboration and communication tasks using Google Workspace tools such as Gmail, Docs, and Calendar.

Experienced in using Zoom and Slack for virtual meetings and team communication.

Managed calendar scheduling and organized travel arrangements efficiently.

Built and documented Sales Process Analysis (including Sales Funnel Analysis for each User Cohort) using Snowflake Cloud Database integrated with Tableau, and implemented SQL queries for creating required views for further analysis in Tableau, increasing the Conversion Percentage from 10% to 35%, Generated funnel analysis for recruitment pipeline using BreezyHR data integrated with Looker Studio, leading to reduction in applicant processing time by 60% and increased net quarterly income by 85%, Created a Real-time Operational Dashboard using Looker Studio with Google Analytics, for analyzing Organic Performance and Paid Ads Strategy based on different aspects like keywords, search queries, device, campaigns, cost, time, location and demographics, leading to growth in percentage of Qualified Leads from 20% to 95%, Developed a financial analysis report to find the Breakeven Point for different lead generation initiatives using Revenue Forecasting on sales and pricing data, which further helped to explore and analyze data for budget optimization and estimate the percentage contribution of each initiative on the yearly revenue, Reduced the Customer Churn Rate to less than 4% by implementing automated subscription model for Finance Team, developed by integrating Salesforce CRM and billing software Xero

Developed long term sustainable data solutions for the business website and Social Media Marketing Ads by integrating and connecting multiple platforms like Google Analytics, Google Search Console, Social Media Platforms (Facebook, Instagram, LinkedIn), Sendinblue CRM, Jetpack CRM and PostgreSQL Databases, Increased the Lead Conversion Rate from 5% to 12% by implementing Cohort Analysis using Looker Studio for analyzing top performing user cohorts, which were then used for retargeting on Facebook Ads, Built a reproducible funnel analysis report on Jupyter Notebook by developing an end-to-end lead data pipeline using SQL queries with Python on PostgreSQL databases, growing monthly revenue by 150%, Ideated and developed a comprehensive recommendation platform for online business tools and software using WordPress, HTML, CSS, multiple plugins and integrable services, Increased the traffic engagement from blog posts to products from 15% to 75% by implementing Interactive Chatbots created using AI Algorithms for Automatic Platform Guidance based upon user chat input

Reduced 90% (approx.) manual efforts for data tracking by developing, implementing, and automating a Product Engagement Analytics Dashboard using Python and Jupyter Notebooks connected with multiple data sources like Zoho CRM, SherlockScore, Amplitude and Chameleon, Developed, implemented, and documented an in-depth funnel analysis on Tableau for the software product by merging the Zoho CRM database with user activity data from SherlockScore and Amplitude, and then further integrating it to Tableau for analysis, increasing sales win rate from 4% to 12%, Performed multiple linear regression with correlation analysis to design a formula for calculating user engagement score with 95% efficiency and identified the minimum event frequency for user conversion, Lead a team of four to perform Data Migration of complete user database from Zoho to Chargebee using Python and Advanced Excel, Integrated Zoho CRM and SherlockScore data with Custify and created AI algorithms for solving a complex problem of sending automated recommendations to sales team in order to help them identify hot prospects based on their engagement with the product, which in-turn led to 40% growth in yearly revenue