Conor Devery Email & Phone Number

Chicago, Il, Us

Denver, Colorado, United States

- Building reporting on the conversion from a Revenue Share to Wholesale pricing model for entangled customer bases across multiple divestitures from Lumen. Reporting used to oversee conversion process as well as assist internal separation efforts.- Provide insights into revenue at risk within Transaction Service Agreements (TSAs) that help guide overall separation strategy and act as a tool to guide negotiation requests with the acquiror.- Managing Statements of Works (SOWs) and Change requests (CRs) associated with the TSAs across divestitures. Coordinating with internal teams as well as with external contractors.- Assessing the impact of divestitures on international wholesale business and domestic strategic alliances.

Broomfield, Colorado, United States

Final Rotation: Corporate Strategy- Constructed competitive analyses of Lumen’s key competition by dissecting earnings reports and SEC filings, as well as additional intelligence about new partnerships and M&A activities in the ecosystem. Provided competitive tables using data sourced from CapIQ to show the relative growth, earnings, and valuation multiples, amongst other information.- Conducted SWOT analysis of Lumen’s products and business segments by investigating external consulting reports analysis reports, market growth reports, as well as working with internal product leaders. Provided insight being used to guide forward strategic planning.Third rotation: FP&A Profitability and Margins- Forecast various expense categories for 2024 using run rates, historical averages, and more complex forecasting methods.- Tracked and monitored various product groups and business segments during month close. Worked with accounting to ensure correct GAAP compliance as well as providing analysis of month of month variances and month versus budget discrepancies.- Led deep dive analysis on significant expense categories being monitored within group. Uncovered various issues and inefficiencies with procedures and systems.Second Rotation: Transaction Management- Managed the development of services and pricing used to support divested assets in the post-sale period. Improved cost tracking mechanism and accountability of internal systems.- Conducted analysis into the profitability of contracts currently supporting two ongoing divestitures. Created a Power BI dashboard tool to allow team to investigate specific margins in contract when negotiating renewals.First Rotation: Customer Financial Services- Increased accuracy of bad debt forecast model, providing statistically backed adjustments to write offs forecasts and decreasing future variance to budget.- Provided an alternative method for predicting cash follows by incorporating a regression model to current modeling.

Broomfield, Colorado, United States

- Analyzed patterns in durations of various capital projects to determine inefficiencies among business practices. Presented findings along with recommendations to the Vice President of Capital planning.- Managed the tracking of projects with cost overruns and implemented strategies to resolve funding issues. Offered guidance as new funding rules were implemented throughout the organization.- Created criteria for managing dormant capital projects. Work assisted in the capitalization of thousands of projects that have been idle for years. - Assisted in estimating customer lifetime value - Set up reports for engineers to track real spending and provide details on where costs arise to better manage budgets.

Boulder, Colorado, United States

- Researched and developed insights for growth opportunities in asset management, hospital group, and banking verticals.- Applied strong analytical skills to narrow down a list of a handful of companies that Zayo should pursue opportunities with and presented key findings to the CIO.- Pulled reports from Salesforce to analyze historic trends and utilized Excel functions to forecast the fourth quarter costs for the Rocky Mountain region.- Learned about different departments of the company during weekly meetings with executives and C-suite employees.

Bloomington, In

- Admitted via competitive application process. Applicants must have received an A on previous Excel courses.- Held weekly meetings with other peer tutors to work with students on critical thinking and problem solving skills.

- Selected by faculty to complete an 8 week comprehensive study of globalization and emerging economies with a focus on businesses of India, followed by a 10-day educational study tour. - Collaborated with a team of four to discover and assess the potential business opportunities in India based on cultural, economic, political, technological, and social factors: India Final Analysis - Strengthened professional experience through participation in interactive events with Cummins, Bharat Forge, Bajaj Finance, and Flame University.

Boulder, Colorado

- Collaborated with banquet leaders in the planning and execution of approximately six functions per week. - Monitored the cleanliness, set-up, and presentation of stations to exceed customer's expectations, driving revenue and brand loyalty.- Held responsibility in delegating tasks to team members and acting as a leader when the manager was unavailable.

Boulder Colorado

360 is a leadership program in Boulder Valley School District for Junior and Senior students. In order to be admitted, one must be selected via an application process and maintain a 3.5 cumulative GPA. I was nominated by my teachers to be a 360 Leader.-Attended weekly meetings to organize different activities for the freshman students so they could quickly acclimatize to a high school environment. -Formulated goals to create a more accepting culture throughout Fairview High School with fellow mentors. -Developed an academic support system for designated freshman, who achieve a 3.2 GPA in their first year.

Boulder Colorado

Youths for Nurturing Minds is an organization started at Fairview High School. The goal of the organization is to create international connections and provide support to The Sega Girls School, a secondary education facility in Morogoro, Tanzania. -Collaborated with fellow members to brainstorm goals and events.-Coordinated monthly meetings to discuss upcoming activities and initiated a correspondence program with the students at The Sega Girls School. -Orchestrated different events that raised more than $13,000 over the course of 3 years.

Finance & Data Analytics, Business

Activities and Societies: Sigma Alpha Mu fraternity, Kelley Living and Learning

Education record

Activities and Societies: Youths for Nurturing Minds, High School Football, High School Soccer, 360 Leader/Mentor