Ambar Kumar
San Jose,Ca
Summary
Data-Driven Business Analyst | Leveraging AI & Advanced Analytics to Drive Financial and business Insights | Skilled in Python, R, Excel, Tableau, & Power BI | Willing to remote work and relocation | Business analyst with 3+ years’ experience using business solutions software and analyzing business operations. Aiming to use my strong data skills and analytical ability to achieve the goals of your company. Business analyst professional course certificate holder from Microsoft and B.S. degree in finance from Purdue University.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Business Analyst intern
Sumwon Studios
02.2024 - 04.2024
- Built and automated planning, reporting models, and developed reports and analysis using SQL
- Updated daily sales activities and completed data entry tasks on Excel across all company platforms - Created performance metric boards using Tableau
- Created and implemented Power BI dashboards that visualized key business metrics, including revenues, sales, and costs, leading to data-driven decisions on product listings and sales strategies
- These insights contributed to a 15% improvement in forecast accuracy and a 10% increase in sales efficiency.
Financial and Sales Analyst intern
Aquila Clouds
06.2023 - 08.2023
- Marketed cross-platform performances of cloud hosting optimization software from AWS, Microsoft Azure, GCP, and Oracle Cloud to potential customers
- Presenting use cases of financial operations, billing operations, and demonstrating how cloud optimization software provides an overview of cost allocations, budget allocations, and tools to optimize cloud usage by 50% and reduce spending by up to 75%
- Conducted detailed analyses using R and Python, optimizing KPIs by 20% and supporting clients in reducing AWS and Azure costs by 40%.
Finance Treasury Analyst
Equinix
05.2022 - 07.2022
- Computed daily cash positions for multiple bank accounts, updated financial data on Excel and provided reports to leadership for: FUMG, HSBC, JP Morgan Chase, Citibank for assets greater than $10 Billion USD
- Monitored financial data from PDF statements to Excel for securities and investments, leading to efficient data tracking for accounts worth $500 million+
- Managed and optimized money market and equity accounts, reducing transaction fees by 3-5% weekly, saving approximately $25,000 monthly.
Data Science Analyst intern
UPS
09.2020 - 05.2021
- Researched quantitative data analytics of potential GPOs (group purchasing organization), consulting companies, and 3PNs with minimum AUM > $3 Billion USD
- Perform large-scale data analytics in Excel to detect trends and optimize UPS investment strategies
- Developed large-scale data analytics in Excel and Python, identifying trends that increased potential ROI by 15%
- Build plans to perform algorithmic analysis of public data sets to provide tactics for specific UPS investment opportunities into PE market analysis of companies in private equity valued at 1 billion USD plus.
Education
Bachelor of Science - Finance
Purdue University, Mitchell E. Daniels, Jr. School of Business
West Lafayette, IN12.2023
Skills
- Data Analytics
- ChatGPT4o
- GCP
- Financial Analysis
- Data Strategy
- TTS Data strategies
- Quantitative Analytics
- Allocations
- SAAS
- Analytical Skills
- Problem Solving
- SQL
- Python
- Tableau
- Power BI
- Microsoft Excel Data Entry/analytics
- Data Visualization
- Pivot Tables/Vlookup
- Business Intelligence
- AI and Machine Learning
- Data entry optimization
- Cloud Optimization
- Business processes
- Stakeholder communication
Websites
Certification
- Microsoft – Professional Business Analytics Fundamentals Coursera Certificate
- Coursera Business Analysis and Process Management course completed with 100% score
- Introduction to Data Analysis using Microsoft Excel – Coursera complete course
- Using R and Python for financial analytics models – Coursera course
Projects
NBA Insights Pro, startup developed analytical prediction models using GPT 4o and did financial data analysis with Python running iterations of 300+ times to predict the outcome of NBA games using real world data
Utilized Python, XG Boost, Random Forest, and Linear Regression to develop AI algorithms for predictive analytics. Implemented and tested predictive models, ensuring high performance and reliability through continuous refinement and validation against historical data
Analyzed large datasets to identify key performance indicators and trends, contributing to more accurate and actionable sports predictions.
Timeline
Business Analyst intern
Sumwon Studios
02.2024 - 04.2024
Financial and Sales Analyst intern
Aquila Clouds
06.2023 - 08.2023
Finance Treasury Analyst
Equinix
05.2022 - 07.2022
Data Science Analyst intern
UPS
09.2020 - 05.2021
Bachelor of Science - Finance
Purdue University, Mitchell E. Daniels, Jr. School of Business
Similar Profiles
Rebekah PellotRebekah Pellot
Parking Production at CBS Studios , NBC Studios and Warner Brothers StudiosParking Production at CBS Studios , NBC Studios and Warner Brothers Studios
Mark ScrivenMark Scriven
Owner/Operator at AJ Studios, LLC DBA Board & Brush Creative StudiosOwner/Operator at AJ Studios, LLC DBA Board & Brush Creative Studios
NOAH LASHLYNOAH LASHLY
Production Secretary at Amazon Studios ; NETFLIX ; Walt Disney StudiosProduction Secretary at Amazon Studios ; NETFLIX ; Walt Disney Studios
ASHLEY BARNESASHLEY BARNES
Office Scheduler/Management Assistant at J&M Tech ServicesOffice Scheduler/Management Assistant at J&M Tech Services
KRISTINA KORETKRISTINA KORET
MARKETING MANAGER at San Jose Express Water PoloMARKETING MANAGER at San Jose Express Water Polo