Summary
Timeline
Work History
Education
Skills
Websites
Coursework
Experience Internships
SAKSHAM KANOJIA

SAKSHAM KANOJIA

Summary

Analytical and results-driven professional with a B.Tech in Information Technology and hands-on experience in data analytics, business automation, and AI integration. Adept at transforming raw data into meaningful insights to support strategic decisions across business, finance, and product domains.

Proficient in a wide range of industry-standard tools and technologies, including Power BI, SQL, Excel (Advanced & VBA), Python, R, Tableau, PostgreSQL, MySQL, Pandas, NumPy, and Google Analytics. Skilled in building data pipelines, conducting exploratory data analysis (EDA), performing statistical modeling, and developing interactive dashboards to optimize business performance.

Currently leading automation initiatives at Digital Web Solutions, enhancing reporting efficiency by 40% and reducing manual effort through AI tools like GPT and Gemini. Past roles include delivering financial insights, customer segmentation models, and predictive analytics that drove measurable improvements in revenue, strategy, and decision-making.

Open to opportunities as a Data Analyst, Business Analyst, Finance Analyst, or Product Analyst, with a strong ability to adapt across domains and drive data-informed solutions using modern analytics and visualization tools.

Timeline

Business Automation Trainee - Digital Web Solutions
04.2025 - Current
Data Analytics Internship - Oasis InfoByte
01.2025 - 03.2025
Data Science & Generative AI - IBM SkillBuild
01.2024 - 02.2024
Maharaja Surajmal Institute Of Technology - Bachelor of Technology, Information Technology (IT)
11.2020 - 06.2024

Work History

Business Automation Trainee

Digital Web Solutions
04.2025 - Current
  • Automated data pipeline from Azure SQL to Power BI, boosting reporting efficiency by 40% through advanced data modeling.
    • Used Git for version control of ETL scripts, Python code, and dashboard logic to ensure team collaboration and reproducibility.
    • Developed a chatbot to answer client business queries, capturing user data and storing it securely in Azure/AWS cloud for analysis.
    • Streamlined hiring and competitor tracking workflows using Python, Zapier, and Azure Blob Storage, cutting manual effort by 60%.
    • Built AI-driven automations with GPT, Gemini, Excel macros, and applied regression & hypothesis testing for data-backed decisions

Data Analytics Internship

Oasis InfoByte
01.2025 - 03.2025
  • Performed advanced financial and business analytics using Power BI, Google Analytics, and statistical modeling to uncover actionable insights.
  • Cleaned and transformed large datasets using EDA techniques, improving data accuracy and consistency by 30%.
  • Developed interactive dashboards and reports in Power BI and Google Sheets, driving 28% improvement in strategic planning through customer insights.
  • Collaborated with stakeholders and team leads to define KPIs, gather data requirements, and guide data visualization strategies
  • Leveraged analytics across domains to support data-driven decision-making and resolve key business issues with statistical techniques like regression and hypothesis testing.

Data Science & Generative AI

IBM SkillBuild
01.2024 - 02.2024
  • Utilized R and RStudio to develop statistical models, improving data-driven decision-making and business intelligence insights by 40%| Link
  • Explored Generative AI concepts and tools, enhancing AI driven workflows by 30%
  • Crafted effective prompts to improve LLMs like ChatGPT, boosting response accuracy and relevance by 25%.

Education

Bachelor of Technology - Information Technology (IT)

Maharaja Surajmal Institute Of Technology, New Delhi
11.2020 - 06.2024

CGPA : 8.7

Skills

  • C
  • Python
  • R
  • SQL
  • Tableau
  • Power BI
  • Excel (Advanced)
  • VBA
  • Pandas
  • NumPy
  • Statistical Modeling
  • EDA
  • Data Cleaning
  • MySQL
  • PostgreSQL
  • Jupyter Notebook
  • Google analytics
  • Rstudio

Coursework

  • Data analytics job simulation - Quantium
  • Excel & VBA - Udemy
  • Pre-MBA statistics - IIMA-Coursera (statistical modeling knowledge)
  • Python data analysis - Udemy
  • Power BI - Udemy (BI & visualization focus)

Experience Internships

Digital Web Solutions | Business Automation Trainee  Apr 2025 – Present

  • Built end-to-end data pipelines that ingest SQL outputs, perform advanced data modeling, and surface insights in Power BI; delivered near-real-time dashboards that cut manual reporting effort by 40 % and accelerated decision cycles for senior leadership.
  • Automated recruiting and competitive-intelligence workflows with Python, Zapier, and Make, eliminating 60 % of repetitive tasks and enabling analysts to focus on high-value research; applied regression analysis to pinpoint cost-per-hire drivers and optimize funnel conversion.
  • Deployed AI-driven solutions (OpenAI GPT, Google Gemini, Excel VBA macros) to auto-generate forecasts, emails, and slide decks, halving repetitive back-office work and validating recommendations through A/B tests and hypothesis testing.

Oasis InfoByte |   Data Analytics Intern   Jan – Mar 2025

  • Conducted deep-dive financial and customer analytics with Power BI, Google Analytics 4, and Python statistical modeling, uncovering revenue leakage points and surfacing insights that informed a 28 % lift in quarterly strategic initiatives.
  • Led data quality initiative: cleaned and normalized multi-source datasets via exploratory data analysis (EDA) and SQL transformations, raising data accuracy and consistency by 30 % and setting new governance standards for the team.
  • Designed and published interactive dashboards in Power BI and Google Sheets that visualized cohort behavior, marketing ROI, and product performance, allowing executives to transition from static PDFs to self-serve analytics.
  • Partnered with finance, marketing, and product stakeholders to define KPI frameworks and translate business questions into analytical requirements, routinely presenting findings that influenced budget reallocations and feature roadmaps.
  • Employed regression, segmentation, and hypothesis-testing techniques to validate growth experiments and resolve critical business questions on pricing, churn, and customer lifetime value.

IBM SkillBuild Program | Data Science & Generative AI Trainee  Jan – Feb 2024

  • Developed predictive models in R/RStudio (linear/logistic regression, random forests) that improved forecast accuracy for sample business cases by 40 %, demonstrating advanced statistical proficiency.
  • Explored Generative AI architectures and tooling (LLMs, prompt engineering, vector databases) and integrated them into sample workflows, achieving a 30 % improvement in automation throughput during capstone projects.
  • Crafted high-impact prompts for ChatGPT and other LLMs, boosting response relevance by 25 % in controlled benchmark tests; documented best practices adopted by peers for future cohorts.
SAKSHAM KANOJIA