Home

Apoorva - Business Analyst

[email protected]

Location: Texas City, Texas, USA

Relocation:

Visa:

Apoorva SKILLS Programming Languages: Python, RStudio, SAS, SQL, VBA Excel, HTML, Java Software & Tools: MS-Office, Tableau, Power BI, Qualtrics Others: Blogging, Social Media Campaign WORK EXPERIENCE Financial Analyst Intern | Upkey | Chicago, IL Oct 2020 Dec 2020 Conducted comprehensive financial analysis and forecasting for client portfolios, resulting in a 10% improvement in investment returns over a three-month period. Assisted in the preparation and presentation of financial reports, including profit and loss statements and cash flow analysis. Performed computations using Power BI and Access to build financial predicative reports which were to be visualized in Tableau. Business Analyst Intern| Asta Infra Projects Pvt. Ltd. | Telangana, India May 2020 Oct 2020 Maintained databases and used various statistical techniques to collect, analyze, and interpret data from consumers and partners to improve performance of the construction equipment. Conducted data analysis and market research to identify potential growth opportunities in the construction industry. Prepared detailed financial reports and performed cost analysis to support decision-making on construction projects, optimizing resource allocation and budget utilization. Desk Attendant |UIC Campus Recreation Chicago, IL May 2021 Jan 2022 Provided exceptional customer service, handling inquiries, facility access, and membership registration. Managed front desk operations, including cash transactions, phone calls, and lost and found. Enforced facility policies and resolved conflicts and concerns to maintain a safe environment. PROJECTS Housing Price Prediction | Python Developed and implemented machine learning models, such as linear regression and random forestto predict housing prices in California based on relevant predictors such as location, number of rooms, and population density. Conducted data preprocessing and feature engineering techniques to clean and transform the dataset, ensuring the accuracy and reliability of the predictive models. Evaluated the performance of the constructed models using appropriate evaluation metrics, such as mean squared error (MSE) or root mean squared error (RMSE), to assess the accuracy and predictive power of the models. Covid-19 Test Prediction Model |R Created a logistic regression model to predict whether a person has Covid-19 based on their symptom data. Performed k-fold Cross Validation to control the hyperparameters of the model to increase the accuracy of the model. Built a decision tree to visualize the decisions that the model makes based on the main factors which are the significant symptoms used to predict Covid-19. LEADERSHIP AND ACTIVITIES Marketing Committee Head| Alpha Kappa Psi Professional Business Fraternity Aug 2021 Oct 2022 Led the marketing committee in developing and executing comprehensive marketing campaigns to promote Alpha Kappa Psi events and initiatives, resulting in increased member engagement and event attendance. Created and managed content for various marketing channels, including social media platforms, and the fraternity's website, effectively communicating the fraternity's brand and values to the target audience. Collaborated with other committees within the fraternity to align marketing efforts with organizational goals, ensuring consistent messaging and branding across all channels. Keywords: business intelligence rlang microsoft Illinois