| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Baltimore, MD, 22202 PHONE NUMBER AVAILABLE EMAIL AVAILABLE LINKEDIN LINK AVAILABLE Summary: Accounting analyst with expertise in accounts payable/receivable, process automation, and data analysis, using tools like Excel and Tableau to optimize efficiency and drive business results. EDUCATIONTHE GEORGE WASHINGTON UNIVERSITY, School of Business Washington, D.C. Master of Science in Business Analytics December 2023 UNIVERSITY OF CONNECTICUT, School of Business Storrs, CT Bachelor of Science in Accounting / Bachelor of Arts in Economics May 2020 PROFESSIONAL EXPERIENCEZust Bachmeier of Switzerland Maryland, U.S.Account Payable Specialist May 2024 - Present Developed custom Excel-based tools to automate accounts payable processes, improving efficiency by 85% and increasing on-time payment rates by 75%. Redesigned the accounts payable workflow, shifting from daily processing to a streamlined 4-week cycle, reducing material waste and data transfer time. Cleaned and optimized data from internal systems to ensure seamless integration into subsequent financial processes. Organized files into five categories, reducing communication time with management and operations teams by 50%, and alleviating workload for the accounting department.Accounts Receivable Specialist March 2024 May 2024 Mastered new financial software within one week, creating tools that reduced data download and bank reconciliation time by 90%. Utilized advanced Excel functions like VLOOKUP to design a custom accounts receivable analysis tool, producing weekly statements with increased speed and accuracy.China Tong Cheng Assets Appraisal C., LTD Beijing, China Finance Intern Feb 2021 - Jul 2021 Conducted complex financial analyses for five clients in diverse industries, including metal-casting, utilizing Solvency Ratios to evaluate debt repayment capacity and performance, earning commendations from the supervisor. Utilized specialized accounting valuation models to accurately assess the value of various assets by Excel, including fixed, intangible, and equipment depreciation, streamlining the asset evaluation entry process by 50%. Facilitated communication and alignment between technology and business cross-functional teams, resulting in a 20% reduction in handover process time for automotive value analysis projects. Prepared and designed detailed Tableau financial reports and analyses promptly, supporting informed decision-making processes through clear and concise presentations.PROJECT EXPERIENCEStrategic Sales Analysis of Predictive Report: Dillard, Tableau &Regression Model. Led a sales analysis project to identify high-potential markets for expansion, processing over 107 million rows of data to assess geographic and sales correlations Utilized Tableau and regression models to forecast opportunities, reducing the customer-to-store distance by 45.55 miles, with an estimated revenue increase of $3.48M. Provided actionable insights into sales trends and market dynamics, delivering strategic recommendations via Tableau dashboards to optimize operations and improve market positioning. Bank Customer Segmentation Analysis, SQL&AWS Conducted segmentation analysis for a major Indian bank, cleaning and processing data from over 1 million transactions and 800,000 customers using SQL and AWS. Mapped customer demographics and identified trends, such as a 1:3 female-to-male account holder ratio and key cities with high account balances, informing targeted marketing strategies. Delivered visual reports and bar charts that enabled the bank to refine customer targeting and address gender disparities. ADDITIONAL INFORMATIONSkills:- Data Analytics: Excel (Vlookup, the Solver, Pivotable, Decision Tree), Python, R, SQL, AWS, Machine Learning, Optimization, Statistics, Marketing Analysis, Marketing research, Decision Modeling, Time Series Forecasting, Supply Chain- Data Visualization:Tableau, PowerBI, Microsoft Office- Accountancy: Cost Accounting, Management Accounting, GAAP Extra Curriculum: VP and treasury of Chinese and American Cooperation Association Club at UConn. |
