VAIBHAV KHURANA
Chicago, IL 60607 | vaibhavkhuranaaa@[Link] | +1 312 978 0317
Education
University of Illinois at Chicago – College of Business Administration
Bachelor of Science in Information Systems (Business analytics) and Finance
GPA: 3.1 / 4.0 Expected:
December2023
Skills
Business Operations | Data Analysis | Statistical and Quantitative Analysis | Project Management | Data Visualization |
Business Statistics (Trend Analysis) | Relationship Building | Operations Management | Database Management | VBA
| R & Python | SQL | SPSS | Excel | Pivot | Financial Reporting | Problem-Solving and Critical Thinking
Work Experience
University of Illinois at Chicago CATE – Classroom Tech Support Specialist August 2022 - Present
● Solving connectivity problems for students and instructors to access the classrooms technologies and
applications
● Using problem-solving skills and technological knowledge, ensuring the proper functioning of classrooms and
labs around the campus.
● Providing instructors with classroom IT/AV technical support in UIC’s classrooms. This includes fixing issues
with the lectern, projector, mouse, keyboard, HDMI, personal laptops, cameras, microphones, and other
equipment.
Shree Nath Realtors Business Analyst August 2019 - August 2021
● Using pivot to Analyze and visualize real estate sales data of over 50000 sq ft. divided among over 20
properties and worth over 1.5 Million USD
● Forecasting buying patterns and suitable inventory using trend analysis of the client’s prior asset purchasing
patterns and budget.
● Developing a logical database for easy accessibility of the various clientele.
● Analyzing clients’ needs by building relation schemas between clients and available inventory databases.
Pahuja Enterprises Financial Analyst August 2021 – January 2022
● Collected, analyzed, and managed quantitative data and created meaningful reports to lead business
improvement resulting in approximately 15% cost reductions.
● Analyzing and assessing total cost associated with the contract and providing insights to prospective profit
margins.
● Providing strategic forecast support by analyzing revenue, gross Margin, and profitability.
University of Illinois at Chicago Lifeguard May 2022 – August 2022
● Enforcing natatorium rules and policies.
● Attentively observed patrons and kept alert to prevent any loss.
Relevant Academic Coursework
● Business Statistics: Hypothesis testing, confidence intervals, analysis of variance (ANOVA), multivariate
regression, time series, statistical process control, non-parametric methods. Use of statistical software for data
visualization, and analysis.
● Investments: Financial securities in equity, fixed income and derivative market, trading strategies, asset
pricing theory, portfolio management, futures, bonds, and options.
● Data Science Programming: Python package for data storage, manipulation (pandas), cleaning, optimization,
and statistics (SciPy), Machine Learning Package: Mlpy, scikit-learn.
● Business Project Management: Fundamentals, lifecycle, and phases of project management, managing and
controlling projects, Risk Management, and conflict resolution strategies.
● Operations and Supply Chain Management: Product and layout design, forecasting, inventory management,
quality control, and decision theory.
● Business Database Technology: E-R Model, logical database design and relational model, data warehousing
and integration, advanced SQL, big data technology, [Link].
● Business analysis using Spreadsheets: Automate repetitive tasks, VBA, and solve optimization problems
using a solver.
Achievements and Interests
● Actively tracking and analyzing Crypto, NFTs, and significant WEB 3.0 additions.
● Forecasted predictions and managed investment portfolios profiting over 25% HPR.
● Learning portfolio and risk management by being real-time invested in the market.
● UIC Global (Orientation Leader), High School Soccer Team (Co-Captain), Class representative (Senior year)