Why this persona fits the audience
Supports a 16-person law office in Bengaluru, updating client and matter trackers, cleaning attendance sheets, and converting Excel files into shareable tables for the partners and paralegals. Mostly works in spreadsheets and copy-paste workflows, with no dedicated data team.
- Age: 27
- Location: Bengaluru, India
- Occupation: Office administrator
- Income: ₹6.8 LPA
- Education: BCom
- Company size: 16 employees
- Years in role: 3 years
“The difference between a good case file and a bad one isn't just the law; it's whether the numbers add up and the dates align perfectly.”
Aaratrika Trivedi is a 27-year-old Office Administrator based in Bengaluru, holding a Bachelor of Commerce degree from Bangalore University. Having joined the mid-sized law firm three years ago, she has evolved from a general receptionist to the indispensable data manager for the entire 16-person team. Her career trajectory was not driven by aggressive ambition but by a natural affinity for order and a desire to make her immediate work environment run smoothly. In a firm with no dedicated data analyst, Aaratrika has quietly become the de facto expert in Excel, teaching herself VLOOKUPs and Pivot Tables through late-night YouTube sessions. Her professional life is defined by a relentless cycle of cleaning, converting, and standardizing data. Every week, she receives raw, unformatted spreadsheets from paralegals—files riddled with merged cells, inconsistent date formats, and duplicate entries. Her job is to transform this chaos into polished, shareable tables that the partners can present to clients without embarrassment. This process is entirely manual, relying on copy-paste actions and macro recording, which consumes roughly 60% of her workday. Despite the monotony, she takes immense pride in the precision of her output, viewing errors as personal failures. Financially, Aaratrika earns ₹6.8 Lakhs per annum, a respectable salary for her age and location, though she feels the pinch of inflation in Bengaluru's rising rent costs. She lives in a shared apartment in Indiranagar, where she manages the household budget alongside her mother. Her financial discipline is strict; she allocates 40% of her income to savings and investments, aiming to purchase a small plot of land in her rural hometown within five years. This long-term goal dictates her conservative spending habits and her reluctance to invest in expensive software subscriptions unless absolutely necessary. Her personality is a blend of high conscientiousness and moderate agreeableness. She is deeply committed to maintaining steady routines, both at work and at home. While she enjoys social interactions, she finds energy draining in chaotic environments, preferring structured meetings and clear directives. Her hobbies reflect this need for control: she collects high-end stationery, enjoys cooking elaborate meals from scratch, and watches Kannada films that often feature themes of justice and moral clarity. Recently, she made the decision to stop using multiple versions of the same file, insisting instead on a strict naming convention across the firm, a move that initially caused friction but ultimately reduced confusion. Aaratrika is a person who believes that dignity lies in doing things correctly, even when no one is watching.
Background & daily life
A day in their life
Aaratrika wakes at 6:30 AM, starting her day with a cup of strong tea and checking her WhatsApp for any overnight messages from her mother. By 8:45 AM, she is seated at her desk in the bustling Bengaluru office, immediately opening her master tracker spreadsheet. The first hour is spent clearing the backlog of emails and sorting through three different Excel attachments sent by the litigation team. At 10:30 AM, she attends a brief stand-up where the managing partner asks for a status update on pending court filings, requiring her to quickly pivot and format a complex table. Lunch is eaten quickly at her desk while reviewing a video tutorial on conditional formatting. The afternoon is filled with back-and-forth corrections, fixing formatting errors in a client database, and manually reconciling attendance logs against the biometric machine export. She leaves precisely at 6:30 PM, feeling a mix of relief and fatigue, ready to cook dinner and unwind with a Kannada movie.
Lifestyle
Aaratrika lives in a modest but impeccably tidy apartment in Indiranagar, sharing space with her mother and younger brother who is studying engineering. Her evenings are ritualistic: she prepares dinner using recipes she adapts from YouTube, often focusing on cost-effective Kannada dishes like Bisi Bele Bath or Ragi Mudde. She is an avid collector of high-quality notebooks and gel pens, finding deep satisfaction in the tactile act of writing and organizing physical lists. Health-wise, she prioritizes sleep and tries to avoid processed foods, though traffic jams sometimes disrupt her gym routine. Financially, she is cautious, saving strictly for a future down payment on a small plot of land in her hometown, avoiding unnecessary luxuries despite having a stable income.
Work life
At the law firm, Aaratrika is the central nervous system for data management, operating without a dedicated IT support team. Her day is dominated by the repetitive yet critical task of transforming raw Excel exports from various paralegals into clean, standardized tables for the senior partners. She spends hours manually scrubbing attendance sheets, removing duplicates, and reformatting cell borders to ensure client-facing documents look professional. The pressure is constant; a single error in a case tracker can delay a filing deadline. She relies heavily on copy-paste workflows because the firm's legacy systems don't integrate well, leaving her as the human bridge between messy data and structured reports.
Relationships
She maintains close ties with her family, relying on her mother for emotional grounding after stressful workdays. Her social circle is small, consisting mostly of colleagues from the office and a few university friends she meets for coffee once a month. She values stability in relationships and avoids dramatic conflicts, preferring to listen rather than lead conversations. Her brother looks up to her as the pragmatic role model who manages the household finances, while her boss views her as the most reliable employee who never misses a deadline.
How they decide
Cautious and research-heavy. Aaratrika rarely makes impulsive decisions, especially regarding tools or money. She prefers to test any new software thoroughly in a sandbox environment before adopting it, seeking validation from trusted peers or online forums. She values ease of use and reliability over flashy features, often defaulting to familiar methods if a new option introduces even a slight risk of disruption to her workflow.
How they sound
Her speech is polite, clear, and slightly formal, reflecting her professional environment. She tends to speak in complete sentences and avoids slang, often using terms like 'ensure,' 'verify,' and 'standardize.' When discussing technology, she speaks cautiously, admitting uncertainty with phrases like 'I haven't tried that yet' rather than making bold claims. She rarely raises her voice and often pauses to think before answering direct questions about her workload. She avoids complaining openly about the company's limitations, preferring to frame issues as 'areas for improvement' rather than failures.
Personality traits
- Meticulously organized
- Quietly efficient
- Detail-oriented
- Conflict-averse
- Prone to over-checking work
- Reliable under pressure
- Technically self-taught
- Dislikes ambiguity
- Protective of personal time
- Respectful of hierarchy
Goals
- To automate the weekly attendance reconciliation process to save two hours every Monday morning
- To master Power Query within Excel to handle larger datasets without crashing her laptop
- To secure a promotion to Senior Office Manager within the next 18 months
- To reduce the frequency of 'urgent' requests from partners by better pre-empting their needs
- To build a personal library of reusable Excel templates for common legal reporting tasks
Problems & frictions
- Inconsistent formatting in incoming Excel files from different paralegals forces manual cleanup
- Fear of breaking links when copying large datasets across different workbook versions
- Lack of version control leading to confusion about which file is the 'final' draft
- Time-consuming manual entry of data that could be extracted automatically
- Difficulty collaborating on a single live document without overwriting someone else's work
- Limited access to cloud storage for sharing large sensitive client files securely
Values
- order
- helpfulness
- steady routines
- reliability
- privacy
- pragmatism
Interests
- Kannada films
- cooking
- stationery collecting
- organizing home libraries
- budget meal planning
Media habits
- WhatsApp groups for family and office updates
- YouTube tutorials on advanced Excel functions
- Instagram accounts focused on stationery and office aesthetics
- News channels for local Karnataka politics
- Spotify playlists for background noise while working