Aditi Kapruwan
Schaumburg,USA
Summary
Technical Business Analyst with 4 years of experience delivering data-driven solutions in Fintech, logistics, and government modernization. Expert in SQL, Tableau, and Python with proven success optimizing workflows, reducing costs, and leading Agile teams. Delivered $3.5M+ in value by driving process improvements and stakeholder collaboration.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Business Analyst Intern
Enterprise Data Group
05.2024 - 05.2025
- Analyzed same-day delivery workflows using SQL, reducing fulfillment delays for 500K+ customers by 15%.
- Identified process gaps in return and shipping workflows, reducing support tickets by 20%.
- Reduced RMA processing time by 10% and saved $200K annually through cross-functional process redesign and application of business process optimization techniques.
- Mitigated inventory mismatches by analyzing demand-return trends, reducing overstock and understock related delays by 30%.
Technical Business Analyst
Blockcube Technology Limited
05.2021 - 07.2023
- Led digital transformation of manual EMI loan workflows for a non-banking financial firm managing 50K+ loans by gathering requirements from 25+ stakeholders, digitizing workflows, and delivering $1.5M savings.
- Managed stakeholder expectations by providing clear updates on project progress, risks, and mitigations.
- Conducted gap analysis between current state systems/processes and future state goals in order to formulate action plans aimed at bridging identified discrepancies.
- Evaluated existing systems for improvement opportunities, resulting in increased performance and reduced costs.
- Conducted project feasibility studies to determine potential return on investment (ROI).
- Supported new project initiatives by analyzing preliminary business needs and defining factors such as budget constraints, time management and resource planning.
- Enhanced system functionality for increased efficiency with comprehensive technical analysis.
- Mitigated high loan default rates by designing SQL-based risk models for a P2P lending platform serving 5K+ borrowers, reducing defaults by 15%.
- Led process improvement initiative to automate certificate verification for 2M+ student records across 500+ institutions by gathering requirements, aligning stakeholders, and managing implementation, cutting turnaround time from 14 to 2 days and increasing user satisfaction by 85%.
- Improved visibility into 10K+ certificate applications across 12 states by designing Tableau dashboards, cutting review time in half and eliminating tracking inefficiencies.
- Accelerated delivery of a $2M government initiative by authoring clear business and technical documentation including Business Requirements Document (BRD), Functional Requirements Document (FRD), user stories, and API specifications.
- Collaborated with UX, development and policy teams to align technical builds with business goals, wireframing standards, user journeys, and functional specifications.
- Led stakeholder-facing User Acceptance Testing (UAT) cycles during Agile sprints, aligning test cases with user stories and acceptance criteria across 15+ business and technical teams.
- Communicated complex technical concepts to non-technical stakeholders and facilitated collaboration among 15+ stakeholders, resolving conflicting priorities to ensure project alignment and timely delivery.
Business Analyst
Intellipaat
03.2020 - 03.2021
- Identified misalignments in ERP and technology training by analyzing client requirements, then redesigned programs to align with learning objectives and business goals, resulting in 95% first-contact resolution and 92% client retention.
- Mapped client journeys and identified workflow gaps by process analysis, driving a 25% increase in upsell conversions worth $300K annually.
- Led self-service transformation initiatives, reducing support ticket volume by 45% and raising user satisfaction scores.
- Transformed user feedback into actionable insights, driving 3 product enhancements in collaboration with sales, product, and content teams.
Education
Master of Science - Data Analytics
University of Illinois
Springfield, IL05.2025
Master of Business Administration - Marketing
ICFAI Business School
Hyderabad, IND02.2020
Bachelor of Technology - Computer Science
Graphic Era University
Dehradun, IND06.2017
Skills
- Data & Analytics: SQL (PostgreSQL, MySQL), Tableau, Python, Excel, Snowflake
- Tools & Platforms: Jira, Azure DevOps, Visio, Figma, Postman, REST APIs, ETL Pipelines, AWS (S3, EC2)
- Business Analysis: BABOK, BRD, FRD, UAT, User Stories, Process Mapping, Wireframing, Gap Analysis, Agile/Scrum, Cross-Functional Collaboration
Certification
- Tableau (Hands-On Data Science)
- MySQL (Data Analytics & BI)
- Python for Data Science & Machine Learning Bootcamp.
Timeline
Business Analyst Intern
Enterprise Data Group
05.2024 - 05.2025
Technical Business Analyst
Blockcube Technology Limited
05.2021 - 07.2023
Business Analyst
Intellipaat
03.2020 - 03.2021
Master of Science - Data Analytics
University of Illinois
Master of Business Administration - Marketing
ICFAI Business School
Bachelor of Technology - Computer Science
Graphic Era University
Similar Profiles
Stephen NyarkohStephen Nyarkoh
Co-Founder at Impact Data Solutions EnterpriseCo-Founder at Impact Data Solutions Enterprise
Karla CoronadoKarla Coronado
Technical Engineer at Enterprise Data ResourcesTechnical Engineer at Enterprise Data Resources
Sara HanySara Hany
Platform Business Development- Section Head at WE Data EnterprisePlatform Business Development- Section Head at WE Data Enterprise
SHIV HEERSHIV HEER
Automotive Technician at Firestone Complete AutoAutomotive Technician at Firestone Complete Auto
Rakan AbushanabRakan Abushanab
Product service Specialist at CATERPILLAR, Inc.Product service Specialist at CATERPILLAR, Inc.