Data Analyst Accounting

Valeriia Krotova

Phone: +1-765-***-****

E-mail: ****.*******@*****.*** LinkedIn: linkedin.com/in/valeriiakrotova Product Management Skills

Business & Data Analytics, Market Research, CRM, Documentation, Customer-oriented, Competitive Intelligence, Strategic Planning, Leadership, Negotiation, Problem Solving, Presentation, Writing & Influencing, Audit reporting Technical Skills

R, SQL, Python, Tableau, QuickBooks, R Studio, Microsoft Word, PowerPoint, Excel, OneNote, Google Analytics Education

University of Massachusetts August 2019

Master of Science in Business Analytics (MSBA) (GPA: 3.6) Purdue University May 2017

Bachelor of Science in Accounting and Management (GPA: 3.78) University of Washington – Seattle September 2014 - June 2015 Foster School of Business, General Business and Economics (GPA: 3.60) Seattle Central Community College June 2014

Associate of Arts (A.A.), Business Administration and Management (GPA: 3.95) Professional Experience

PayPal

Data Analyst Intern – Newton, MA May 2019 – March 2020

• Optimized statistical models in Python for customer for customer segmentation using regression model

• Automated data QC for model use in campaigns, improved time efficiency by 70%; data queried using SQL

• Aggregated data from various sources to construct streamlined data pipelines and integrate data from PayPal systems

• Identified key metrics and build exec-facing dashboards to track the progress of the business and its highest priority initiatives

Stone Arch Commodities

Staff Accountant – Minneapolis, MN January 2018 – September 2018

• Processed full-cycle accounts payable for the entire accounting department: data entry, control reports, check printing

• Maintained an adequate system of accounting records and a comprehensive set of controls designed to mitigate risk

• Tracked project expenses, analyzed profit and loss, prepared income and expenses variance report to management

• Managed the payroll processing of weekly and bi-weekly payrolls for over 150 employees locally and multi-state

• Prepared and managed in timely manner accuracy of all EFT, ACH, and wire payments domestically and globally PwC March 2017 – January 2018

Internal Audit/General Accounting – Miami, FL

• Operated software application to produce financial statements and related supporting details in accordance with US GAAP

• Developed plans and conducted audits to analyze, document, validate, and test to assess multi-million clients’ systems

• Managed a variety of audit procedures and prepared reports for >70 annual reports and financial statements of various public funds

• Performed a full spectrum of accounting functions such as audit testing for numerous financial accounts, testing of controls

• Developed an understanding of each client’s business in order to identify issues and provide recommendations in assigned audit areas Procter & Gamble January 2015 – August 2015

Business Analyst – Seattle, WA

• Analyzed quantitative and qualitative business data to develop a solution design capable of fulfilling the customer's

• Revised purchase ordering algorithm to minimize overstock, achieving savings of 25-30% per inventory purchase

• Supported Program Lead with research requests and data validations regarding the CRM system

• Developed and managed SharePoint site to host collections for project analytics, client databases, requirements, reports

• Generated customer segmentation algorithm in R; conducted data preparation, and outlier detection using MS SQL Awards & Achievements

IRS VITA Certification, Active member of Beta Gamma Sigma Honor Society, Purdue Accounting Association Languages: Russian (native), English (fluent), Chinese (limited working proficiency)

Contact this candidate