• Strong financial and data analysis skills, including; Financial statement and accounting analysis skills; Ability to use
use data from disparate sources to draw business conclusions; Experience building simplified models to address complex business problems, using Microsoft Excel and other
tools as appropriate; Presentation and communication skills that demonstrate an ability to effectively communicate with different levels of the finance and operations organizations; Excellent interpersonal, teamwork and customer relationship skills; Problem-solving skills; Strong desire
to learn and grow your career within the organization
HARMEET SOHAL
Sacramento, CA
(916)-622-9206 │ [email protected]
LinkedIn: https://www.linkedin.com/in/harmeetkaursohal/
EDUCATION
San Jose State University
MBA Candidate | Cumulative 3.89/4.0 GPA | Graduating Spring 2021
California State University, Sacramento
Bachelor of Science in Finance | Cumulative 3.9/4.0 GPA | Dean’s Scholar| Graduated Summa Cum Laude
Antelope High School
Diploma 2015 | Cumulative 4.2/4.0 GPA| Graduated in the top 40 of a 400 graduating class
PROFESSIONAL EXPERIENCE
Collateral Analyst, BRIDGE BANK, San Jose, CA August 2019 - Present
• Analyzes and assesses collateral information to support portfolio managers in determining risk involved in lending
money to customers.
• Processes client funding requests, including data uploads, reviews backup documentation, collateral verification, debtor
qualifications, and funding submissions for manager approval.
• Promptly informs lenders and clients of any funding issues and assists in resolution.
• Reviews and verifies clients’ borrowing base reports and updates availability on internal system as well as notifies
portfolio managers, credit officers, and clients of any issues.
• Works with clients to manage day to day collateral routines including pay-downs, cash collection activities,
disbursements, collateral reporting, and compliance issues.
• Trains new analysts on collateral monitoring procedures and responsibilities.
Financial Planning Intern, SILICON VALLEY WEALTH ADVISORS, San Jose, CA Summer 2018
• Collaborated with Certified Financial Planners to create and update financial plans for over 120 clients through Excel,
eMoney, Sales Force, and Tamarac; along with utilizing the planning, execution, and feedback aspects of modern
portfolio management in preparation for client meetings.
• Used analytical skills to rebalance clients’ holdings to adjust to market shifts and for tax planning reasons.
• Gained in depth knowledge of 401k’s, restricted stock units, estate planning, IRA’s through client meetings in various
settings.
Student Assistant, CALPIA, Folsom, CA 2017 - 2018
• Used Excel and the department’s automated system, Enterprise Resource Planning System, for reporting and maintain-
ing inventory; created and updated spreadsheets and reports on Excel to analyze financial data.
• Handled and resolved customer dispute letters by analyzing data and making recommendations.
• Supported the Accounts Receivable unit through analysis and data entry of optical orders to achieve billing policies.
Customer Service Representative, CITY MARKET, Sacramento, CA 2014 – 2017
• Updated account information on the store’s database to maintain customer records and inventory levels for the
betterment of the business.
• Provided customers with valuable information and opinions about various products to build customer confidence and
to resolve respective problems.
PROJECTS
Led a group of four to evaluate and analyze stocks using Warren Buffet’s investment style, Discounted Cash Flow Model,
and DuPont Analysis on Excel to price their intrinsic values.
EXTRACURRICULAR ACTIVITIES
• Member of Student Sikh Association at San Jose State University 2019 - 2020
• Member of Jakara and Indian Student Association at CSU Sacramento 2015 - 2017
• Volunteered at Olive Grove Elementary School as a teacher assistant 2010 - 2015
