Ksenia Habiger, FMVA®
Contractor - Financial Analyst at Taiyo Pacific Partners- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Taiyo Pacific Partners
-
United States
-
Investment Management
-
1 - 100 Employee
-
Contractor - Financial Analyst
-
Jun 2023 - Jul 2023
Kirkland, Washington, United States After leaving my Senior Fund Accountant role in order to pursue opportunities outside the firm, I offered to help out on a contractor basis during a busy time. This offer was happily accepted, and I worked remotely for Taiyo, managing the quarterly reporting process. • In charge of quarterly firm-wide reporting to external investors and prospective investors; Managed collaboration among 20+ individuals to gather, analyze, and visualize key performance metrics and other… Show more After leaving my Senior Fund Accountant role in order to pursue opportunities outside the firm, I offered to help out on a contractor basis during a busy time. This offer was happily accepted, and I worked remotely for Taiyo, managing the quarterly reporting process. • In charge of quarterly firm-wide reporting to external investors and prospective investors; Managed collaboration among 20+ individuals to gather, analyze, and visualize key performance metrics and other statistics. • Project work: Developed reusable tool/template to count firm-wide portfolio company meetings inception-to-date, leveraging UNIQUE, FILTER, SUMIFS, COUNTIFS, INDEX/MATCH.
-
-
Financial Analyst - Senior Fund Accountant
-
Jan 2022 - Jun 2023
Kirkland, Washington, United States • Finance Team (50%): In charge of finance operations; Reviewer role on monthly close and reporting packages to investors, prepared and reviewed financial statements, trained and supervised Fund Accountant; Managed on-boarding of several tools and systems; Responsible for external audits. • Ad hoc analysis; Managed shut-down of two funds, forecasted closing expenses; Set up several partnership allocation schedules in Excel. Project work: • Automated daily pricing data import using… Show more • Finance Team (50%): In charge of finance operations; Reviewer role on monthly close and reporting packages to investors, prepared and reviewed financial statements, trained and supervised Fund Accountant; Managed on-boarding of several tools and systems; Responsible for external audits. • Ad hoc analysis; Managed shut-down of two funds, forecasted closing expenses; Set up several partnership allocation schedules in Excel. Project work: • Automated daily pricing data import using VBA, reducing daily reporting process by 40%. • Automated daily index values calculation and upload into the accounting system, using VBA and scheduled tasks. • Streamlined the quarterly budgeting process, consolidated three sets of financials into one, mapping ledger accounts with SUMIFS & FIND functions. Set up variance analysis with conditional formatting. • Created Excel reports from scratch, designed to be reused every month, leveraging INDEX/MATCH, SUMPRODUCT, SMALL/LARGE. • Created solution for the monthly capital statements review process, converting PDFs into Excel and leveraging MID, LEFT/RIGHT, FIND, IFS functions, cutting the review process by 3hrs each month (or 90% of review time). • Streamlined and improved various reporting processes, making Excel spreadsheets more dynamic und user-friendly, adding completeness and reasonableness checks. • Research Analytics Group (50%): Provided support to Portfolio Management, including top-down analysis, analyzing portfolio risk exposures; Ad hoc research and analysis, data manipulation, visualization, presentation. • Managed firm-wide quarterly reporting processes, coordinating with 20+ individuals. • GIPS reporting and annual verification. • Performance attribution and analysis. • Ad hoc financial analysis for RFPs/DDQs/investor meetings. Project work: • Template/tool creation and reporting: Built and improved Excel reporting tools. • Historical factor analysis, using Bloomberg and FactSet, presentation of results to PM Team.
-
-
Fund Accountant
-
May 2019 - Jun 2022
Kirkland, Washington, United States
-
-
Contractor - Fund Accounting
-
Dec 2018 - Apr 2019
Kirkland, Washington, United States
-
-
-
Team for the Planet
-
France
-
Non-profit Organizations
-
700 & Above Employee
-
Retail Investor
-
Jan 2023 - Jul 2023
Seattle, Washington, United States
-
-
-
Washington Conservation Action
-
United States
-
Public Policy Offices
-
1 - 100 Employee
-
Market Research / Data Analyst Volunteer
-
May 2018 - Nov 2018
Seattle, Washington, United States • Built platform to gather and analyze employee benefit data in non-profit environment that is accessible to other organizations and helps to improve benefit status within the organizations. • Performed database project in Salesforce to complete database of endorsed elected officials. • Performed Tableau-based project to visualize voter statistics in preparation for election.
-
-
-
Straker
-
New Zealand
-
Translation and Localization
-
100 - 200 Employee
-
Translator
-
Jan 2018 - Nov 2018
Seattle, Washington, United States • Relocation to United States in November 2017; Work authorization obtained in September 2018. • Translation and review of business and legal documents (English, German, Spanish, Russian).
-
-
-
Mitsubishi Fuso Truck and Bus Corporation
-
Japan
-
Motor Vehicle Manufacturing
-
500 - 600 Employee
-
Pricing Associate, Finance and Controlling Department
-
Apr 2015 - Sep 2015
Tokyo, Japan • Full-time internship between Bachelor and Master program. • Spare parts pricing analysis, to identify high-margin, high potential spare parts to include in marketing efforts. Includes analysis of large data sets, collaboration with engineers and Pricing Team members, distilling data into measurable insights, presenting recommendations to Pricing Team and Marketing Team. • Assisting with the implementation and trouble-shooting SAP add-on (D2S, Demand to Supply).
-
-
-
CORPORACION MITSUBA DE MEXICO S.A. DE C.V.
-
Mexico
-
Appliances, Electrical, and Electronics Manufacturing
-
1 - 100 Employee
-
Quality Management Associate
-
Jan 2014 - Mar 2014
Parque Industrial Silao, Guanajuato, Mexico • Internship following my exchange semester. • Implementing changes to production and assembly processes to comply with industry standard. • Cross-subsidiary communication (German and English to Spanish) to implement audit requirements.
-
-
-
WSB Wolf Beckerbauer Hummel & Partner
-
Germany
-
Accounting
-
1 - 100 Employee
-
Audit Assistant
-
Feb 2013 - Aug 2013
Mannheim Area, Germany • Full-time internship followed by a part-time position. • On-site audit, testing, and production of audit reports for several clients within different industries: financial services, manufacturing.
-
-
Education
-
Eberhard-Karls-Universität Tübingen
Master of Science (M.Sc.), International Business and East Asian Studies -
同志社大学 Doshisha Business School
MBA, Business Administration and Management, exchange semester -
Ewha Womans University, Ewha School of Business, Ewha Graduate School of International Studies
MBA, Business Administration and Management, exchange semester -
Eberhard-Karls-Universität Tübingen
Bachelor of Science (B.Sc.), International Business Administration -
Universidad de Guanajuato
Bachelor's degree, International Trade and Business, exchange semester