Luke Mcclanahan Email & Phone Number

Washington, Dc, Us

Sterling, Virginia, United States

• Maintaining and optimizing applications used by cooperative membership for financial reporting. Automated existing processes for collecting, transforming, and validating financial reporting data prior to large-scale analysis. Reduced reporting application size by ~60%.• Developing and improving full-stack applications which support financial forecasting and budgeting data models. Development steps include soliciting user feedback from nationwide membership, managing upgrade projects, providing member-facing application support, and writing custom code.• Designing ad hoc data models to meet various member needs. Writing custom SQL and Power Query(M)/DAX to produce speedy and robust Power BI dashboards that support features such as real-time linear regression analysis based on user input.• Assisting cooperative membership with matters such as: financial reporting, budgeting, forecasting, application support, financial report interpretation, data requests, and more.

Fayetteville, Arkansas, United States

• Performing live, solo set lists of original music using guitars, keyboards, drums, and vocals at Hill Records artist showcase concerts. • Independently producing multi-channel audio tracks for use in live performances.• Selected for partnership following the independent composition, recording, production, and submittal of an original song.

Little Rock, Arkansas, United States

• Constructed a concise, comprehensive data model to monitor and control customer and inventory characteristics, sales, and performance in Microsoft Power BI. This achieved significant improvements in the amount of time and processing power required for computation compared to the existing model and provided an organized, modular infrastructure to accommodate more advanced visualizations.• Automated repetitive processes using Microsoft Excel and Visual Basic for Applications, saving several hours of redundant work weekly. Automated tasks included web data scraping, data normalization and transformation, and financial analysis.• Systematized department data analytics efforts by organizing and enabling sweeping updates to company database records. This bolstered analysis accuracy by reducing the number of manual steps (e.g., transformation, correction) required for analysis.

Little Rock, Arkansas, United States

• Developed sweeping billing process improvements within B2W construction software to facilitate internal audit efforts and prepare for implementation.• Exhibited proficiency in Microsoft Excel through daily report generation and troubleshooting.• Streamlined weekly analysis reports pertaining to sales and field crew billing, saving 3-4 labor hours weekly.

Master Of Science - Ms, Operations Management

Graduate Microcertificate in Decision Support Tools Graduate Microcertificate in Data Analytics and Visualizations

Honors Bachelor Of Arts - Ba, Psychology

Activities and Societies: Phi Beta KappaHonors Bachelor of Arts in psychology with minor in philosophy. Completed honors thesis research.