Anoop Rana
UNION CITY,CA
Summary
As a business analyst, I am passionate about using data and analysis to drive business strategy and decision-making. My expertise in data analysis, project management, and problem solving allows me to provide valuable insights and recommendations to help organizations to achieve their goals. I am excited to leverage my skills and experience to help organizations thrive and succeed.
Overview
3
3
years of professional experience
Work History
President
QueensClosetOfficial
03.2021 - Current
- Design traditional Indian outfits for clients in the United States and import from India.
- Set up collaborations with photographers for photo shoots and schedule up to 10 models at a time to market new clothing line.
- Manage inventory, track orders, and create invoices using excel and microsoft word.
- Adhere to state and federal laws for a clothing business, gather permits, and prepare all documentation for end of year taxes.
- Increased sales by 15% by analyzing customer data and recommended targeted marketing strategies.
Business Analyst
PG&E
05.2022 - 10.2023
- Utilize Excel to process data requests within 3 days for IE (Independent Evaluator), working alongside SME's, DRU's, Law/Approval, Quality Control and Production teams.
- Lead cross-functional team meetings to evaluate vendor progress and ensure they are honoring contractual commitments in a timely manner.
- Case Manager for a team of 3 to track, report, analyze and redact internal data to accurately produce requests for BVNA.
- Created WMP (Wildfire Mitigate Plan) powerpoint and presented to executives on the steps PG&E took to mitigate wildfires in 2022.
- Improved safety performance by 20% by analyzing incident data and developing targeted safety training program.
Education
Bachelor of Arts - Economics
California State University - Sacramento
Sacramento, CA12.2021
Skills
- Data Analysis
- Critical Thinking
- Project Management
- Detail Oriented
- Problem-Solving
- Customer Service
Tools
Excel, SQL, Tableau, Salesforce, Microsoft Teams, Adobe Acrobat, Sharepoint, Powerpoint, Outlook, Microsoft Office, HTML, Google Analytics, Google Ads, Facebook Ads, Instagram Ads
Projects
- Perform extensive research on the correlation between education and homeownership in the United States using panel data collected from years 2015-2019.
- Utilize Excel and Stata to conduct regression analysis using variables such as age, income, marital status, major, etc.
- Research concluded that education plays a significant role in an individual becoming a future homeowner.
Timeline
Business Analyst
PG&E
05.2022 - 10.2023
President
QueensClosetOfficial
03.2021 - Current
Bachelor of Arts - Economics
California State University - Sacramento