Varun Kumar

About Varun Kumar

Experienced Business Analyst with extensive knowledge of all phases of software development life cycle (SDLC) and methodologies such as Waterfall and Agile. Expertise in preparing Business Requirements Document (RBD), Functional Requirements Document (FRD), Refined Process Flows, Use cases, User Stories, Test Scenarios, User Guides, and PRDs.Skilled in managing IT projects across diverse domains. Proficient in stakeholder engagement, requirement gathering, conflict resolution, and ensuring seamless communication for successful project delivery.Why I’m Your BA Unicorn Data Whisperer: I turn raw numbers into clear, actionable strategies. Excel, SQL, Tableau, Power BI—you name it, I use it.Master of Process Fixing: If there’s inefficiency, I’ll find it, crush it, and replace it with something 10x better.Agile Jedi: JIRA, Confluence, Scrum—I help teams stay productive without wanting to throw their laptops out the window.Professional Overthinker (In a Good Way): I ask the right questions before things go wrong, not after.Proficient in utilizing various HTTP methods (GET, POST, PUT, DELETE) to interact with RESTful APIs and web services, including crafting and executing requests to retrieve, create, update, and delete resources, ensuring seamless data management and API functionality.Skills-Business process analysis and improvementRequirements gathering and documentationPrioritization Techniques (MoSCoW, Eisenhower Matrix, Value v/s Effort Matrix, Weighted Scoring Model, RICE Scoring Model)System design and implementationData analysis and visualizationProject management and coordinationStakeholder communication and managementProficient in SQL, Python, JAVAMethodology : Agile(Scrum, Kanban), WaterfallData Visualization Tools : Tableau, Power BIWireframing Tools : Figma, MS VisioProject Management Tools : JIRA, Confluence, Asana, Monday, Trello, Slack, Smartsheet, MS ProjectIndustries I Serve: E-Commerce – Scalable online stores, Shopify, WooCommerce Healthcare & Medical Apps – HIPAA-compliant solutions Real Estate & Property Tech – MLS integration, dynamic search filters Finance & Banking – Secure fintech platforms SaaS & Enterprise Solutions – CRM, ERP, workflow automationIf you’re looking for a Business Analyst who brings both brains and personality to the table, let’s chat. I promise to keep the buzzwords to a minimum.

Experience

1. Business Analyst

   Tech Arch Softwares Pvt. Ltd

   Mar 2025 — Present · Panchkula, IN

   Conducted over 25 structured stakeholder interviews to gather requirements and gather feedback, resulting in a 30% reduction in project requirement ambiguities• Created stored procedures and triggers, automating data processing tasks and reducing processing time by 20%• Integrated Confluence with JIRA to create a seamless workflow for documenting user stories, epics, and sprint planning, streamlining Agile project management• Leveraged JIRA Query Language queries to filter and retrieve specific issue data, facilitating data-driven decision-making• Developed over 10 drill-down dashboards in Tableau, allowing users to explore data at a granular level & uncover hidden insights• Designed & implemented a scalable ETL pipeline, to handle 8 million records incorporating responses to survey questions by patients from 13 clinics, to extract data from various sources, perform data transformations & load data into a database• Performed exploratory data analysis using Python identifying top 3 causes of illness among patients & created executive level dashboards using Power BI to give visibility of survey• Optimized SQL queries in BigQuery, resulting in a 30% reduction in query execution time, which significantly improved data retrieval efficiency• Collaborated with product managers to perform cohort analysis to understand behavior of target customer portion & deduce opportunity to reduce pricing by 10% for a segment of customers• Designed & executed A/B tests to improve open and click-through rates, resulting in a 20% increase in engagement• Built key reports for leadership team in Tableau for KPI’s including Lifetime Value, Net Promoter Score, Funnel conversion, revenue generation & ROI and used statistical methods(t-test, Chi-squared), generating actionable insight

Education

• Stevens Institute of Technology

  MS Information Systems

• Chitkara University

  Bachelor of Engineering , Computer Science

  2015 — 2019