Gauri Bora
Roseville,CA
Overview
2
2
years of professional experience
Work History
Lead Business Analyst
Pacific Gas & Electric (Contract)
San Francisco, CA
04.2022 - Current
- As a project manager, I spearheaded the development of a sophisticated Excel platform seamlessly integrated with SAP and SQL databases, leveraging Macros and VBA to achieve a 30% reduction in both capital and expense costs. Additionally, I effectively managed a $20 million budget and provided valuable insights into budgeting and forecasting
- Enhanced program visibility by 35% by designing and implementing dashboards for KPIs, SWOT, financial, and stakeholder analysis across various NRM programs using Power BI and Tableau
- Supported accounting by streamlining invoice processing, billing, vendor management, contract review and managing documentation for orders, deeds, and easement recordings through Ariba and Salesforce.
Business Operations Analyst
Adivo Associates LLC
San Francisco, CA
10.2021 - 04.2022
- Assisted payroll and accounting by processing invoices, processing payroll payments and documenting financial records.
- Generated financial reports to analyze revenue forecasting and expense reduction.
- Enhanced senior management's financial acumen through the creation and management of an executive financial dashboard, encompassing the analysis of critical metrics including revenue, expenses, profit margins, cash flow, net income, and key performance indicators (KPIs) using tableau.
Education
Master of Science - Business Analytics
California State University - Sacramento
Sacramento, CA08-2024
Bachelor of Arts - Econometrics And Quantitative Economics
University of California - Davis
Davis, CA06.2021
Bachelor of Arts - International Relations And Affairs
University of California - Davis
Davis, CA06.2021
Skills
- MS Office: Excel,Powerpoint,Word
- Analysis: Python, R, SQL, STATA
- CRM: Salesforce and Oracle
- Strategic Thinking
- Financial Analysis
- Project Management
Projects
PYTHON: https://github.com/gauribora14/projects
- Balance Sheet Analysis using API: Automated financial analysis of balance sheets using API.
- Stock Prediction using ML: Created and trained ML algorithms using 6 months prior data to derive predictive scores for closing prices.
- IMDP Web Scrapper: Created excel files of the top movies from IMDB using web scrapping.
- Movie Correlation Project: Created a regression and correlation project on data metrics for movies. Budget and gross earnings correlation.
TABLEAU: https://public.tableau.com/app/profile/gauri.bora
- Covid-19 Vaccine Tracker: Created a dashboard on data for covid-19 vaccines.
Timeline
Lead Business Analyst
Pacific Gas & Electric (Contract)
04.2022 - Current
Business Operations Analyst
Adivo Associates LLC
10.2021 - 04.2022
Master of Science - Business Analytics
California State University - Sacramento
Bachelor of Arts - Econometrics And Quantitative Economics
University of California - Davis
Bachelor of Arts - International Relations And Affairs
University of California - Davis
Similar Profiles
SHAWN ANDERSONSHAWN ANDERSON
Senior Help Desk Technician at TEKSystems (contract with Oklahoma Gas & Electric)Senior Help Desk Technician at TEKSystems (contract with Oklahoma Gas & Electric)
Juan Gabriel BejarJuan Gabriel Bejar
Material Handler at Pacific Gas & ElectricMaterial Handler at Pacific Gas & Electric
Jose MelgozaJose Melgoza
Field Engineer - General Construction - Electric T&D at Pacific Gas & Electric CompanyField Engineer - General Construction - Electric T&D at Pacific Gas & Electric Company
Toni HoweToni Howe
Customer Service Representative at Horace Mann InsuranceCustomer Service Representative at Horace Mann Insurance
Torrey HigginsTorrey Higgins
Retail/Production Associate at GoodwillRetail/Production Associate at Goodwill