Business Analyst Intern

NEHA FATIMA

San Jose, CA *************@*****.*** 408-***-**** LinkedIn

EDUACTION

MS., Business Analytics

Golden Gate University, CA 3.8/4.0 Jan 2024 - present

Coursework: Predictive Analytics, Data Mining, Machine Learning, Information Systems, ETL, Data Visualization, Big Data Analytics, Business Intelligence tools.

BBA Majoring in Analytics Finance

Osmania University, Hyderabad, India 3.7/4.0 Jul 2019 - Aug 2023

Coursework: Probability & Statistics, Data Analysis, Finance, Data Analytics, Supplier Management, Marketing.

TECHNICAL SKILLS

Programming Languages: Python, SQL, R.

Data Analysis & ETL: Data Models, Data Mining, Data Pipelining, Schema Design, Root Cause Analysis, Data

Data Visualization & BI Tools: Tableau, Power BI, QuickSight, KPI Dashboards, Reporting Automation.

Machine Learning: Predictive Modeling, Statistical Learning, Regression Analysis, Time Series Forecasting.

Project Management: Agile, Asana, Visio, Jira, Strategic Planning, Cross-Functional Collaboration.

Database & Cloud Technologies: MS Office Suit, Advanced Excel, Google Cloud, Ad-Hoc, Azure, AWS.

WORK EXPERIENCE

Business Analyst, Tejas and Harish, Hyderabad, India Oct 2022 – Nov 2023

Individually Managed and analyzed customer and sales data using the company’s CRM system, improving sales forecasting, and enhancing efficiency in daily operations by 17%.

Supported User Acceptance Testing (UAT), working closely with end users to set up the testing environment, execute test cases, and gather feedback for system improvement.

Created and optimized ETL pipelines to process large datasets for customer and sales analysis.

Developed reports using python and tableau on sales trends, inventory levels, and market demand, enabling data driven decision making for business growth and brand development.

Data Analyst, Fama Technologies, Hyderabad, India Dec 2021 – June 2022

Designed & maintained SQL-based ETL workflows for large datasets, improving order processing insights.

Developed interactive KPI tracking dashboards in Power BI, QuickSight and Tableau to help clients track KPIs like order speed, sales volume and customer wait time by 32 hours.

Assisted in pre-sales technical support by analyzing customer requirement using salesforce and recommending cloud-based POS software solutions for quick-service restaurants clients like McDonalds’s and Starbucks.

Worked on technical troubleshooting and system integration, ensuring seamless deployment of POS software.

Business Analyst Intern, Centronics Systems, Hyderabad, India April 2021 – July 2021

Developed and deployed data driven models using regression analysis to optimize supply chain costs efficiency by 22%.

Created data models and wrote SQL queries for real time access to key operational metrics, supporting strategic decisions teams.

Provided technical consulting on IT solutions, ensuring alignment with customer business objectives.

PROJECT EXPERIENCE

Sales Forecasting Using Time Series Analysis (Python, ARIMA, Excel, Tableau) Internship project.

Developed a time series forecasting model using ARIMA to predict future sales for a retail chain, resulting in a 15 % increase in inventory management efficiency.

Visualized sales trends and forecast accuracy using Tableau, providing actionable insights into sales fluctuations and customer demand cycles.

Integrated forecasting insights into marketing strategies to align promotional activities with projected sales trends, improving campaign effectiveness and resource allocation.

Business Process Automation for Financial Reporting (SQL, Python, RPA (UiPath)) Bachelor’s project

Automated the financial reporting process using Robotic Process Automation (RPA) to streamline report generation, reducing reporting time by 30%. Analyzed large transaction datasets with SQL and python to identify reporting inefficiencies, resulting in optimized workflow for faster decision making.

Customer Segmentation for a Retail Business (Python, K-means Clustering, Power BI Bachelor’s project

Built a customer segmentation model to identify purchasing behavior, enabling personalized marketing strategies, and improving customer retention. Visualized segmentation outcomes in Power BI, offering real-time tracking of customer performance metrics.

Contact this candidate