Roosevelt Hegmann

Why this persona fits the audience

Builds monthly reporting packs in Excel for a mid-sized services firm, combining exports from accounting, CRM, and ad platforms. Uses formulas, pivots, and commentary cells to clean data and summarize results for a 6-person leadership group.

• Age: 38
• Location: Chicago, IL, USA
• Occupation: Finance operations analyst
• Income: USD 94k
• Education: BS in Accounting
• Company size: 50-100 employees
• Years in role: 5

“The numbers don't lie, but they do require careful interpretation. My job is to make sure the story they tell is accurate and clear.”

Roosevelt Hegmann's journey into finance operations analysis was a natural progression from his early fascination with order and logic. Growing up in a modest household, he learned the value of careful planning and resource management from his parents, who instilled in him a strong work ethic and a deep appreciation for accuracy. His academic path led him to a BS in Accounting, where he excelled in quantitative subjects and developed a keen eye for detail. After a few years in a more traditional accounting role, he found himself drawn to the operational side, seeking to understand how financial data could drive business decisions more effectively. He joined his current mid-sized services firm five years ago, recognizing an opportunity to build out their reporting capabilities. His role is critical: he's the architect of the monthly reporting packs that guide the company's six-person leadership team. This involves a complex dance of data extraction from accounting software, CRM exports, and ad platform analytics, all meticulously woven together in Excel. Roosevelt is a master of formulas, pivot tables, and commentary cells, transforming raw data into actionable insights. He views his work not just as number-crunching, but as building a reliable audit trail and ensuring the integrity of the financial narrative. He's deeply committed to the principle of 'calm execution,' believing that thorough preparation and methodical work prevent chaos. While he's comfortable with his current income and lifestyle, Roosevelt is always looking for ways to optimize his processes, driven by a desire for greater efficiency and accuracy. He sees time as a valuable resource, both for his work and his family, and strives to use it wisely. His financial decisions are guided by a long-term perspective, prioritizing savings and investments for his children's future and his own retirement over immediate gratification.

Background & daily life

A day in their life

Roosevelt's day begins at 6:15 AM. After a quick breakfast and seeing his kids off to school, he’s in his car by 7:15 AM, listening to a podcast on financial trends. He arrives at the office by 7:45 AM, grabbing a coffee before diving into emails and checking overnight data feeds. His morning is dedicated to data extraction and initial cleaning for the upcoming monthly report. Lunch is a quick sandwich at his desk while reviewing industry articles. The afternoon involves building pivot tables, writing commentary for the report, and troubleshooting any data discrepancies. He often stays until 5:45 PM to ensure everything is in order before heading home for family time.

Lifestyle

Roosevelt resides in a comfortable, albeit slightly dated, single-family home in a Chicago suburb with his wife, Sarah, a part-time librarian, and their two children. His daily routine is structured: an early start, a 30-minute commute to the office, a full workday, and then home for family dinner. Weekends are often dedicated to household chores, helping kids with homework, and occasional DIY projects around the house. He's not one for spontaneous spending, preferring to budget carefully and save for long-term goals like college funds and retirement. His social life is modest, primarily revolving around family and a few close friends from college.

Work life

As a finance operations analyst, Roosevelt's primary responsibility is ensuring the accuracy and clarity of financial reporting for his company's leadership team. His days are consumed by data extraction from disparate systems—accounting software, a Salesforce CRM instance, and various ad platform dashboards. He then meticulously cleans, transforms, and synthesizes this data within complex Excel spreadsheets. He relies heavily on VLOOKUPs, INDEX/MATCH, pivot tables, and conditional formatting to identify trends, anomalies, and key performance indicators. The pressure is on to deliver these monthly reporting packs on time and error-free, as the 6-person executive team uses them for critical strategic decisions.

Relationships

Roosevelt is married to Sarah, who manages their household finances with a similar level of diligence. They are a united front on major decisions. His parents, retired teachers, live a few hours away and he calls them weekly. His closest confidante is Mark, a former college roommate who works in IT, offering a different technical perspective.

How they decide

Roosevelt is a cautious and research-driven decision-maker. He thoroughly evaluates options, weighing pros and cons logically. He prefers to understand the underlying mechanics and potential implications before committing. He values evidence and data, and while he respects expert opinions, he ultimately relies on his own analysis.

How they sound

Speaks in a measured, even tone. Avoids jargon unless it's standard financial terminology. His sentences are well-constructed and logical. He tends to pause briefly before answering complex questions, indicating thoughtful consideration. He rarely uses slang and maintains a professional demeanor, even in casual conversation.