Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Ishan Rajani

Houston

Summary

Results-driven Business Analyst with expertise in SQL and project management, previously at Yard Sign Plus. Enhanced sales by 15% through data analysis and strategic insights. Proficient in Tableau and Agile methodology, fostering collaboration and driving impactful business decisions. Proven track record in optimizing processes and improving performance across diverse teams.

Overview

8
8
years of professional experience

Work History

Business Analyst

Yard Sign Plus
Houston
01.2023 - Current
  • Leveraged SQL to analyze data from over 1,000 customer transactions, generating detailed reports on sales trends and customer behavior to optimize business strategies, resulting in a 15% boost in sales
  • Pinpointed top 10% of products generating 80% of sales and prioritized expansion of these categories.
  • Minimized shipping costs by 15% annually through strategic carrier selection and packaging optimization
  • Developed and automated Tableau visualizations for tracking and analyzing website traffic and user behavior for over 50,000 visitors, delivering insights that facilitated 20% increase in conversion rates.

Data Analyst

Harris County Department of Education
Houston
07.2018 - 01.2023
  • Formulated innovative strategies for data reporting, enhancing efficiency by over 60% and optimizing communication between center staff and data department.
  • Generated 15 data reports weekly, providing comprehensive enrollment insights to upper management for monitoring weekly metrics.
  • Revamped employee training processes, resulting in a 25% enhancement in average employee performance during the initial two months.
  • Constructed and deployed a relational database in SQL, enhancing the management of student data and facilitating attendance tracking for more than 12 campuses throughout Houston.

Data Analyst

alliantgroup
Houston
02.2017 - 06.2018
  • Implemented 15 data quality control techniques and assurance, as well as handled major technical issues for 75 employees.
  • Executed market analysis of yearly client tax documents, optimizing research methods and achieving 20% rise in sales.
  • Coached a cohort of more than 100 participants in effective strategies for analyzing tax information and boosting performance.
  • Spearheaded a new initiative to receive feedback from over 1,000 clients in order to constantly enhance processes and provide excellent service.

Education

Bachelor of Business Administration - Management Information Systems

University of Houston
Houston, TX
12.2016

Skills

  • Project Management
  • Microsoft Office 365
  • Agile Methodology
  • Statistical Analysis
  • Google Cloud
  • Power BI
  • AWS
  • SQL
  • Database Management
  • Tableau

Languages

  • English, Full Professional Proficiency
  • Hindi, Professional Working Proficiency
  • Urdu, Professional Working Proficiency

Timeline

Business Analyst

Yard Sign Plus
01.2023 - Current

Data Analyst

Harris County Department of Education
07.2018 - 01.2023

Data Analyst

alliantgroup
02.2017 - 06.2018

Bachelor of Business Administration - Management Information Systems

University of Houston
Ishan Rajani