shalini pandey

shalini pandey

Senior Business Analyst Intern
United States of America

About Me

An analytical and data driven Business Analytics graduate student adept at employing analytical techniques and data-driven methodologies. Experienced in conducting comprehensive data analysis, implementing business intel…

Experience

Senior Business Analyst Intern (SQL & Power BI)

Innovative Intelligent Solution, TX, US
Jan 2024 - Present · 2 years 6 months

Developed a comprehensive forecasting cashflow model in SQL for loan portfolios, incorporating all relevant cash flows
Facilitated cross-functional discussions to develop methodologies for converting organizational costs into individual loans
Created an automated Power BI dashboard that included a comparison of forecasted cash flow to actual cash flow, providing up-to-date information on the loan portfolio and insights for risk management and pricing decisions of the loans
Implemented an automated ETL (Extract, Transform, Load) process for monthly reports, reducing manual effort by 90%
The process involved data extraction and transformation using SQL and running the data into a centralized data model in Power BI

Data Science Intern (Python)

Innovative Intelligent Solution, TX US
May 2023 - Aug 2023 · 3 months

Conducted in-depth exploratory data analysis on 500,000 IT tickets, utilizing data visualization techniques to uncover patterns between various platforms
Gained valuable insights into the nature of breakdowns, resulting in informed decision-making
Optimized a Long Short-Term Memory (LSTM) Recurrent Neural Network forecasting model through hyperparameter tuning, achieving an accuracy of 85%
The machine learning model improved the IT management's incident resolution time
Developed a Neural Network-based classification model to categorize IT incidents into different levels
The incident management team utilized the machine learning model to prioritize incidents and reduce user downtime

Skills

Business Analysis Data Science SQL Python SAS Proc SQL Hadoop MongoDB MySQL SQL Server Snowflake Spark Stata Tableau Power BI Microsoft Office Outlook Word PowerPoint Microsoft Excel Pivot table LOOKUP Alteryx Predictive modeling Regression Classification Financial modeling Clustering Time series forecasting Hypothesis testing Prescriptive modeling Business intelligence Data wrangling Data mining Data integration Visualization Data warehousing Root cause analysis Exploratory data analysis Data cleaning Data manipulation Data extraction Aggregation ETL Machine Learning Agile Project management Big data analysis Product Management Ownership Decision-making Critical-thinking Problem-solving
Report this Profile?