2655 Shadow Woods Circle Marietta, GA 30062 (678) 793-7003 justinasbartkev@gmail.com
SUMMARY OF QUALIFICATIONS Financial Analyst with a background in developing and maintaining financial models that benefit the organization. Hard working, Self-Motivated and Eager to Learn.
AREAS OF EXPERTISE
- Excel Macros and Hyperion Essbase
- Forecasting and Budgeting
- P&L
- Ad-Hoc Analysis
- Report Improvement - Project Management
12/11-Present
Financial Analyst Infor Alpharetta, GA
- Perform monthly financial reporting functions.
06/11-11/11
Financial Analyst Intern Turner Broadcasting Inc.-CNN News Atlanta, GA
- Improved complex financial reports by utilizing Excel Macros, Formulas and Automation.
- Computed total studio rental cost for remote guest appearances during the Casey Anthony Trial on HLN channel.
- Researched CNN Espanol expense drivers for outside services and Identify the vendor billing issue from previous billing cycle.
- Created historic financial statements by utilizing Essbase database, analyzed trends and explained variances to the department manager.
- Ran detailed headcount and business operations reports while prepared for monthly forecasts.
- Prepared budget packages and presentation materials.
- Analyzed monthly financial data by comparing budget, actual and forecast results. Presented analysis to the department manager and discussed findings.
02/11-05/11
Financial Analyst Intern Six50 Capital Management Marietta, GA
- Prepared Excel spreadsheet summarizing all CMBS 2.0 new issue securitizations. Utilized Excel macros to pull key statistics.
- Created Excel spreadsheet capturing key loan metrics for all 2011 CMBS deals.
- Assisted Lead Underwriters in loan level due diligence including gathering market research.
- Ran bond level cash flows for all portfolio holdings using Intex software.
- Supported the work of Credit Officer with security specific research and analysis.
- Provided analysis of loan liquidations in company portfolio including indentified severities with stratifications.
- Reviewed IDC pricing relative to Six50 bond level cash flow projections to determine hold/sell recommendations.
08/10-12/10
Financial Analyst Intern Lindner Capital Advisors, Inc. Roswell, GA
- Applied strategic planning to monitor financial market trends and communicated findings with senior management.
- Utilized Morningstar Office and Orion software to complete historic performance reports.
- Used Federal Reserve data to evaluate current market trends such as employment, manufacturing and GDP.
- Communicated with account executives and provided tools necessary to generate more business.
03/03-08/10
Purchasing Department Manager World on Wheels International, Inc. Marietta, GA
- Increased return on investment to 20% by managing website and marketing efforts.
- Communicated with over 30 wholesale accounts located through out the US.
- Negotiated and appraised 50-100 monthly wholesale offers.
- Maintained a clear track record of having no accounting errors while working with $2,000,000 budget.
- Kept constant communication with senior management regarding the inventory supply to avoid the surplus.
- Managed a team of 6 local and 4 remote team members.
RELATED SKILLS
- Finance: generating and optimizing an investment portfolio, analytical financial statement analysis.
- Computer Skills: proficient in MS Excel and Powerpoint, Essbase, PeopleSoft, Hyperion and Bloomberg (certified).
- Foreign Languages: reading and speaking fluency in Russian, Polish, Lithuanian and English.
- Other: excellent verbal communication and presentation skills, self-motivated, technically savvy, well organized.
HONORS AND ACTIVITIES
- Kennesaw State University Scholar in Finance Award, 2011.
- Beta Alpha Psi Honorary Society – Officer.
- Student Managed investment Fund – Information Technology Manager.
- Atlanta Lithuanian Community - Board Member.
EDUCATION
December 2010 GPA 3.4, Major GPA 3.75
Bachelor of Business Administration in Finance Kennesaw State University (KSU) Kennesaw, GA
