Ryan Sweeny Email & Phone Number

Columbus, Oh, Us

Columbus, Ohio, Us

-Organize, review and process subcontractor pay applications, analyzing against vendor contracts-Identify and request change orders to purchase orders and service contracts for requests for payment outside of current scope of work-Analyze invoices due on a bi-weekly basis to determine bills to pay and create check run report for tracking and approval processes-Submit monthly owner invoices in accordance with client requirements for lien waivers, billable amounts and payment schedule, processing through Lucernex, Sitefolio, and Tango real estate softwares-Create reports for all projects in construction for monthly job cost review meetings, utilizing Procore reporting tools to extract budget and change order data-Manage the final invoicing portion of each job close-out, communicating with necessary vendors and subcontractors to verify final contract costs-Assist with ad hoc reporting and analysis requests from both internal stakeholders and external partners for full cycle support of the real estate development, construction, capitalization, and asset management process

Cincinnati, Oh, Us

-Support the portfolio of operating companies by providing financial analysis for ongoing company operations-Own quarterly workpapers and oversee all A/R, A/P, payroll, fixed assets, revenue and more for 8+ NAP operating entities and ventures-Communicate externally and internally to coordinate bank transfers ranging in value from $100’s to $1M’s-Upload and code invoices through NexusPayables, coordinating necessary approvals and cash balances to deliver payment to vendors-Created, implemented, and managed monthly processes for $21.7M of backcharges in 2023; organized invoices and appropriate backup monthly to ensure payment and maintain A/R balance-Analyze, adjust, and reconcile the general ledger to ensure appropriate presentation of financial statements to Board and Executives-Collaborate with Partners and accounting, finance, development, and leasing personnel across 5 offices located in Atlanta, Dallas, Ft. Myers, the Space Coast, Cincinnati and remotely-Actively accrue revenue and update actuals (for leasing, management, asset managment, development, construction management fees, etc.) to maintain live status of financial health; provide analysis and insight for quarterly budgeting and reforecasting-Responsible for monitoring, depositing, and recording checks and electronic deposits to appropriate bank accounts for 8+ operating companies and additional corporate entities (~$1-2M in receipts weekly)

Cincinnati, Oh, Us

-On RED team, owned one Industrial deal, one long-term real estate strategy project, and supported a team of Development Managers across Ohio and Northern Kentucky-Assisted with creation of pro formas for new deals-Compiled information and populated purchase and sale agreements-Participated in review of requests for proposals to determine how to fit potential tenant's needs-Attended due diligence, strategy, and other meetings-Conducted due diligence research for traffic implications, water and sewer capacity, and (re-)zoning capabilities

Cincinnati, Oh, Us

-Participated in rotations on the Equity (Investor Relations), Debt, and Underwriting teams-During Equity rotation, supported the Investor Relations team with Offer Memorandums, quarterly reporting, equity draws, marketing materials and investor support, utilizing Juniper Square-Throughout Underwriting rotation, analyzed deals coming through the pipeline, updated pro formas and models to be used by the development and capital teams, and aggregated market data for firm-On Debt rotation, took ownership of loan draws for construction loans, assisted with enhancements of debt analysis tools, organized and documented financial covenants, and assisted with creation of Requests for Proposals (RFPs)-Updated sales and lease comparable database monthly with broker data, and reconciled data as needed-Assisted with ad hoc efforts to streamline financing and analysis process (on Equity, Debt, and Underwriting teams)

Cincinnati, Oh, Us

-Co-op on the fixed asset and job-cost team within the Property Accounting Department-Assisted with construction-in-process reconciliations and co-owned future lease reviews, addition reviews, fixed asset rollforwards, and various fixed asset disposals (lease-related, TI/TIA, amortization, depreciation, etc.)-Collaborated with the CAM team to complete full backup packages for yearly common area maintenance bill reconciliations; researched invoices, general ledgers, insurance and amortization schedules to include for support-Generated fixed asset reports to use for analysis and for various accounting members on other teams-Created and maintained compliance within scope of the job-cost and fixed asset teams in accordance with new regulations following PECO’s entry as a public company-Utilized information systems such as MS Excel, MRI Lease Accounting & Fixed Asset Accounting, NexusPayables as well as Adobe Acrobat DC and Microsoft Office including Teams-Phillips Edison is publicly traded on the Nasdaq (PECO) since 2021, with over a half-billion gross proceeds in the initial public offering (referenced below)

Cincinnati, Ohio, Us

-Full-time Co-op in the Enterprise Workplace Services (EWS) Division of the Bank, which designs, constructs, brokers, manages, and oversees the lease administration and operations of all corporate, retail banking, and ATM facilities-Assisted the Retail Distribution team with reporting and data analysis-Collaborated with Design, Project Management, Operations, Retail Banking, Finance, Legal (Internal and External), Brokers and other departments to develop the real estate portfolio of the bank-Assisted RE Manager formulate and develop hypothetical pro-formas to anticipate retail asset performance in new markets-Conducted lease and other legal document analysis to ensure proper support of real estate assets-Oversaw the development and organization of the Real Estate team’s legal tracker, in collaboration with General Counsel and external counsel as well as RE Managers-Incorporated the Bank's overall strategy into the development of the real estate portfolio-Utilized ArcGIS, CoStar, MS Excel, PowerPoint, Google Maps/Earth and other information systems on a day to day basis

Erlanger, Kentucky, Us

-Implemented new risk documentation and management processes-Prepared financial statements for Controller and Board of Directors-Improved monthly board statement preparation through implementation of automated functions-Compiled and analyzed data points for cost and profitability analysis-Audited freight bills against shipping receipts to ensure accurate payments-Entered invoices, bills, and credit memos as needed for various lines of business-Supported inventory reconciliations and adjustments quarterly and monthly/as needed-Reported directly to the controller and performed ad hoc analysis as assigned

London, Gb

-Full-time Intern in the Business Consulting practice of Big Four public accounting firm-Assigned to two high-profile client engagements, with both IT/financial audit and strategy consulting focuses-Performed control testing, documentation, and analysis-Identified potential risk and risk management protocol-Researched clients to understand and document internal issues and processes in order to address client needs and optimize their performance

Erlanger, Kentucky, Us

-Created estimates for home build costs based on selections, site specifications and vendor quotes-Made edits to purchase orders and scheduled construction activities as jobs change-Produced estimated gross margin reports for all estimates completed at month-end-Analyzed home blue prints (using SapphireProBuild), comparison reports (utilizing MS Excel), and custom selections to determine appropriate materials and costs-Worked full-time during Fall 2020 Semester while enrolled in full-time coursework; worked part-time in Spring 2021 Semester while enrolled in full-time course work

Cincinnati, Ohio, Us

-Maintained the social media and overall brand of the Eta Chapter-Designed and organized all merchandise orders -Designed posters, flyers, boards, and media for marketing and rush week-Oversaw the Marketing Committee of 4-5 active members and assigned duties as needed-Created and implemented new marketing strategies-Monitored social media and external postings-Responded to external communications and forged relationships with other organizations-Served for the Spring '20 Semester and the '20-'21 Academic Year

Noblesville, Indiana, Us

-Worked with the CEO, Directors, and President of Alpha Kappa Psi National Business Fraternity-Developed a marketing plan for a new product line being introduced in the coming year-Created a logo graphic for new product/program-Determined product values and pain points-Offered advice and perspective in identifying opportunities and weaknesses for the products-Presented value, plan, and potential product implementation to the Fraternity Board of Directors, Heritage Center, Regional Directors, and other full-time staff members

Cincinnati, Ohio, Us

-Promoted to Team Lead (previously Housing Assistant) September of 2019-Provided support to staff of 5-10 Housing Assistants-Processed documents and appropriately filed and stored documentation electronically-Viewed account transactions, and properly forwarded requests for credits to accounts-Assisted with hiring, onboarding, and training of new staff-Led the team of Housing Assistants at Bearcat Brunches and Bearcat Bound Orientations

Cincinnati, Ohio, Us

-Answer incoming calls and assist office traffic of students and parents-Respond to approximately 15-30 emails and 15+ voicemails each day-Remain knowledgeable of housing and food options, dates, and timelines

Cincinnati, Oh, Us

-Worked full-time in the AFG Tax Division alongside approximately 30 federal and state/local tax professionals-Utilized (tax) software such as Corptax, EAS, Peoplesoft, Microsoft Excel and more to complete federal tax assigments-Prepared tax basis, quarterly provisions, compliance and other tax-related materials for 15 assigned company subsidiaries (Federal Tax)-Assisted full-time staff with additional projects as needed; communicating with accounting, IT, and other business professionals-Completed extensions in preparation for returns for approximately 30 company subsidiaries (State/Local Tax), utilizing SuperForm, Corptax, and other software as needed

Cincinnati, Ohio, Us

Cincinnati, Ohio, Us

Cincinnati, Ohio, Us

Bachelor Of Business Administration - Bba, Real Estate And Accounting, Business Law & Ethics

Honors Diploma