Alec Hunter Email and Phone Number
Hello! I'm Alec Hunter, a third-year student at the University of Wisconsin Oshkosh, proud to call Oshkosh my hometown.My journey revolves around pursuing a degree in Information Systems, specializing in Data Analytics. I thrive on collaborative efforts, whether it's leading discussions or fostering seamless teamwork.Recently, I completed a rewarding 9-month internship in the accounting and finance department at US Venture, gaining invaluable insights into company operations and deepening my understanding of accounting practices.At Oshkosh Corporation, I automated analysis and tracking of amortizable items, developed Excel VBA macros to streamline fixed asset management, and leveraged OneStream for Excel-based data analysis.At US Venture, I utilized various systems to complete cash tie-outs, analyze AP and AR functions, and drive data-driven budget and forecast initiatives.Outside of academics and work, I enjoy camping, fishing, hunting, and coaching wrestling. I'm passionate about contributing to the sport and nurturing the next generation of wrestlers.My aspirations lie in automating and optimizing processes in Financial Services. Currently, I'm a data engineer at Nicolet National Bank, bridging my technical acumen with my finance and accounting experience to drive impactful change.I'm excited to broaden my skill set and pursue opportunities that bring me joy and fulfillment!
-
Business Intelligence InternAmcor Sep 2024 - PresentOshkosh, Wisconsin, United States -
Data Analyst InternNicolet National Bank Apr 2024 - Aug 2024Green Bay, Wisconsin, United States• Led, designed, and transformed the firm's end-to-end mortgage service cash flow analysis by automating processes using Alteryx. Employed Python for data mining augmentations, enhancing accuracy in reports reviewed by the Federal Home Loan Mortgage Corporation. This initiative eliminated manual processing equivalent to 1 FTE, significantly improving accuracy in calculations• Generated monthly reports to track uninsured deposit accounts by extracting data from Nicolet deposit database using MySQL, and efficiently ingested data using Excel and Tableau to adhere to FORVIS Mazars Audit Guidelines• Engineered a transactional database in Alteryx, automating real-time data extraction to provide Tableau with daily visibility into customer transactions. This solution enhanced all branches' access to critical transaction data, optimizing daily operations and strategic decision-making across the bank -
Financial Analyst InternOshkosh Corporation Oct 2023 - May 2024Oshkosh, Wisconsin, United States• Automated analysis and tracking of amortizable items over $20,000 using Excel VBA macros, integrating data from DAS 8 (Data Access Studio 8, a JD Edwards product) to calculate depreciation, post monthly amortization entries, and generate detailed financial reports• Streamlined fixed asset management across 12 business units using Excel VBA macros and Power Query, improving efficiency in summarizing SAGE FAS data for informed financial decision-making• Executed data analysis using Oshkosh Corporation's Performance Management Tool (Onestream) in Excel to automatically pull information from financial statements for U.S. Census Bureau reporting requirements• Verified foreign exchange rates in JDE and FX file, ensuring accurate conversion of international transactions to US Dollars• Managed annual unclaimed property tax processes, compiling lists, sending due diligence letters, and remitting unclaimed amounts to state representatives as required• Conducted detailed reconciliations for Wells Fargo distribution accounts using JDE software, Excel, and BlackLine reconciliation tool, ensuring accuracy, resolving discrepancies, and maintaining precise financial records -
Accounting InternU.S. Venture, Inc. Feb 2023 - Oct 2023Appleton, Wisconsin, United States• Conducted an accounts receivable aging customer portal project, involved a comparison between open invoice portal and US Venture's ERP system. Resulted in a reduction of days sales outstanding by 6 days, considering US Ventures daily revenue of $650k, and accelerated cash inflow of $4 million• Directed data-driven fiscal budget and forecast initiatives through historical analysis and Excel trends. These insights were seamlessly integrated into US Ventures' corporate performance management tool, Anaplan, contributing to well-informed resource allocation• Administered Prophet 21 customer account inbox, methodically onboarded requested customers into US Ventures system to enhance sales potential• Undertook workload of vacant Staff Accountant position at US Lubricants as an intern. Involved strategically managing tasks crucial for advancing company's financial well-being. Subsequently, cross-trained new Staff Accountant by swiftly mastering various aspects of role• Leveraged Dynamics 365 to expertly rectify mistaken invoices through a series of credit and rebill procedures, ensuring precise revenue recognition
Alec Hunter Education Details
-
Accounting
Frequently Asked Questions about Alec Hunter
What company does Alec Hunter work for?
Alec Hunter works for Amcor
What is Alec Hunter's role at the current company?
Alec Hunter's current role is Motivated Information Systems Student at UW Oshkosh | Passionate About Automation and Process Optimization | BI Intern @ Amcor.
What schools did Alec Hunter attend?
Alec Hunter attended University Of Wisconsin Oshkosh, University Of Wisconsin-Parkside.
Who are Alec Hunter's colleagues?
Alec Hunter's colleagues are Marielle Nishimura, Reginaldo Moraes, Jim Johnson, George Bodreau, Jeniffer Rivera, The Chissler, Rosalvo Xavier Da Silva.
Not the Alec Hunter you were looking for?
-
Alec Hunter
Founder & Owner Superstar Fitness Boot Camp / Photographer - Superstar FotoRedondo Beach, Ca3ssfitness.com, ssfitness.com, sag.org2 +161930XXXXX
-
-
Alec Hunter
Cincinnati, Oh2btgpactual.com, rdicorp.com -
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial