Created and maintained distribution of daily, weekly, and monthly recurrable reports.Queried against lottery's transactional database using T-SQL to answer ad hoc marketing questionsUsed Pivot Tables and Tableau to create various data visualizations showcasing key KPIsReverse-engineered various external reports to maintain reporting during downtimesPresented reports and findings twice a week to Directors and upper level managementUsed both player behavior and external player data sets to segment userbase for more targeted metrics.

Monitored, maintained, and wrote Ad Hoc reports to clean up equipment Wrote SQL codes to access and manipulate CSG Vantage tablesUsed Pivot Tables and Vlookups to analyze tables in Excel

•Support the tax accountants in the tax return preparation•Used Tax Portal to deliver and exchange tax documents with clients•Streamlined certain excel processes to save CPAs time

-Assist in the development of the financial portion of the annual plan-Assist in the development of monthly short term forecasts-Present various financial forecasts to division management-Prepare and submit monthly and quarterly financial reports-Analyze data and prepare variance analysis

Used SAP software to create, confirm, and send out purchase ordersForecasted future sales and repurchased accordinglyCreated excel files to streamline the replenishment processManually calculated inventory for items not calculated in software

Coordinated weekly billing files in compliance with accounting principlesReconciled and researched unapplied payments, ensured proper creditsPrepared Excel spreadsheets and PowerPoint presentations for CFO and investors Participated in monthly inventory at company plantIntegrated expense reports for all employees on a bi-monthly basisUsed simple macros and VLOOKUP to expedite simple tasksAnswered questions for franchisees about timing of automatic ACH payments

2008-2011* Tutored in Calculus, Micro and Macroeconomics, and Statistics* Implemented various studying techniques suited to the individuals' needs* Saw improvements of 10 points or more on test scores by over 75% of students

Summer 2006 and 2007* Handled cashier duties, and managed an individual till daily* Consistently posted most or second-most customers per hour out of 25+ cashiers* Helped customers with product locations and descriptions