Justan Lewis Email & Phone Number

Boise, Idaho, United States

Analyze and reconcile data to meet strict daily deadlines for over $60 billion worth of assets. Proficient with tools such as Microsoft SQL Server Management Studio, MS Excel, and Salesforce.Apply concepts of GAAP, Statutory, Tax, FASB, and cost accounting for client accounting reports and maintaining regulatory requirements.Use Excel to comb through large data sets and find errors in bank transactions.Collaborate with several departments and external clients to streamline dataflow for internal and external user experience.Manage automation projects for client accounts; analyze raw data and find historic patterns that can be used to build new processes. Reduced manual tasks by over 50% for multiple clients, resulting in 200 fewer manual work hours needed each month.Lead and participate in audits for internal quality assurance and help audit internal compliance processing.Implemented new company-wide training and several department-wide trainings. I also trained coworkers directly to implement new processes and take on new clients.

Journalized transactions and performed monthly bank reconciliation. Completed a significant correction project for the books that dated back 6 months prior to hiring.Researched tax questions and found proper regulatory treatment for federal, state, and local tax compliance. Implemented new features with the point-of-sale software and instructed sales and management staff on its usage.Migrated data from one point of sale software to another. Set up the new point of sale software to integrate into our bookkeeping software.Analyzed raw data and found anomalies in the accounting and point of sale systems using MS Excel. Monitored the company Ecommerce site and improved sales using various analytics tools.Automated processes such as inventory count and transferring data from sales software to bookkeeping software. Reduced bank reconciliation from a weeklong project to four hours and continually worked to improve efficiencies. Integrated different software and facilitated their communication with each other.

• Adaptation: I adapted my methods and communication style to meet the needs of students in diverse situations. • Ongoing Improvement: I constantly sought additional knowledge and mastery of my field to provide the best service. • Accountability: I responded to all requests in a timely manner and completed daily progress reports.• Customer Service: My attitude stayed positive and cooperative despite stressful environments, and I strove to help others feel more confident in their efforts.

Boise, Idaho Area

Bachelor'S Degree, Accounting, It Management, Finance, 3.81

Related Coursework: SQL & C# Programming QuickBooks Online Certification Power BI Tableau 2020 Certificate of Business Analytics

Business Aa, Accounting, 3.89

Certifications Earned: QuickBooks Desktop MOS Word 2016 MOS Excel 2016