Calen McNickles

Experience

• 

  Arista Networks

  Apr 2018 - Aug 2018

  Internal Audit Intern

  • Assist with and conduct financial, operational, and compliance audit projects• Provide consulting services to Arista management including review and improvement of policies & procedures and design of effective processes and controls• Produce audit reports and other documents with clearly organized thoughts• Present reports and findings to Internal Audit team and members of management• Gained experience utilizing Egnygte, Concur, PowerBI, Excel, GoToMeeting, Intranet and NetSuite. Show less

• 

  EY

  Sept 2019 - May 2021

  Assurance Associate

  • Perform quarterly reviews and year-end audits of private and public companies, in accordance with standards set by regulatory authorities, with a focus in consumer products, biotech, and technology industries.• Perform data analytics procedures to analyze revenue activity to support audit procedures.• Conduct walkthroughs of company processes and test controls in accordance with SOX requirements, including implementation of new controls due to changes in financial reporting requirements. • Perform audit procedures over significant accounts to ensure proper financial reporting requirements.• Perform variance analysis and salary expense forecasting. Show less

• 

  Personal Projects

  May 2021 - Jul 2022

  Personal Projects

  Worked on personal projects and certificate programs while learning as much as I could about Python, R & SQL and their applications in Data Analysis, Finance and Machine Learning. I participated in the 100 day code challenge, if you are interested in seeing my progress I used the below twitter exclusively for this challenge. Never stop learning!https://www.kaggle.com/calenmcnickles/codehttps://github.com/calen-mcnickleshttps://twitter.com/plopunterhttps://leetcode.com/calen-mcnickles/ Show less

• 

  Riverside Insights

  Jul 2022 - now

  • Contributed to the preparation, reporting, and analysis of financial information for the Clinical Business Unit using Python and Excel. Streamlined budgeting and forecasting processes, enhancing monthly analyses of results and improving overall efficiency.• Consolidated, processed, and analyzed usage data from Snowflake reports to transition the finance team to Tableau for smoother updates and improved visualization.• Developed a dynamic model for revenue prediction by analyzing customer use history and testing various package pricing strategies. This modeling helped transition to a subscription-based product.• Utilized Python and SQL (Snowflake) to automate data extraction and manipulation processes.• Leveraged ChatGPT in conjunction with Python and Excel to enhance data manipulation processes, optimizing scripts and facilitating creative problem-solving in financial analysis for the Clinical Business Unit.• Constructed an international budget, using billings assumptions, revenue predictions, and analyzing sales by year and product. This resulted in a comprehensive waterfall chart bridging 2022 results and the 2023 budget. Show less

  • Senior Strategic Finance Analyst

    Apr 2023 - now

  • Strategic Finance Analyst

    Jul 2022 - Apr 2023