Reporting that outgrew its spreadsheets
Data Engineering and Analytics
Started by
A control called out, with a date on it
They already told the market. Nobody was reading.
One record runs all of it, from the public change that started a pursuit to the documentation the engagement ships with.
The four agents
Monthly reporting rebuild
Hi Dale,
Congratulations on the move into the VP Finance seat. With the monthly reporting still built by hand and a public commitment to changing that, it seems like the next challenge may be doing it without stalling the close.
Opportune works with energy businesses on financial reporting, process and technology as they grow. That got us wondering whether we could help with the rebuild that follows.
Could Opportune help plan the reporting build?
From the record
Each agent hands the next a fuller record than it received. A win six months from now still traces back to the line that started it, dated and sourced.
Your agents
Agent 1 of 4
Reads the public record overnight and stacks the small clues until a company is worth your morning.
SEC filings and their exhibits, job postings, leadership announcements, earnings transcripts, trade press and regulatory dockets
The language a company uses about its own problem, not the keywords a vendor would have picked
A dated signal on the company record, carrying the sentence that caught it and a link back to the source
Faith, every morning, with nothing promoted on its own
Agent 2 of 4
Scores fit, urgency and confidence separately, then checks the name against conflicts, clients and live pursuits before it reaches you.
Every signal Aiden wrote, against the firm's own record of clients, conflicts and open engagements
Fit, urgency and confidence kept apart, so a loud signal on a poor fit never gets promoted on volume alone
A conflict, a name another consultant is already working, and anyone inside a live engagement
Daily against every flight in the air, so a new engagement holds the outreach the day it is entered
Agent 3 of 4
Attaches the matching work the firm has already done, drafts the approach from the evidence itself, and runs the flight that follows.
The signal and its evidence, plus the firm's record of engagements that look like the one being proposed
An approach built from what the company said, with the comparable work named and attached
The flight: a follow, then a like on something they wrote, then the first note, with any stop able to end it
A person, always. Nothing is sent without a signature.
Agent 4 of 4
Turns a won pitch into phases, people and a price, then runs it on budget and burn and keeps the documentation current.
The pursuit record, the signed scope, timekeeping and the team's own skills record, strengths and gaps alike
Phases, a staffed team with its gaps named out loud, and a price built from engagements the firm actually ran
Scope against the SOW, burn against the work still remaining, and every decision that changes what was agreed
The BRD, the TDD and the desk guides, rewritten as the project moves rather than once at the start
The systems it runs on
Eight sources on the left, most of them free and public. One record in the middle. Five systems on the right your team already opens every morning. LinkedIn and Salesforce sit on both sides, because each is read long before it is written to.
Every source, by group
What lands overnight
Every one of these began as a sentence a company published itself. Read, screened and scored while the office was empty.
A green check is Faith clearing it: no current client, no conflict, no live pursuit anywhere in the firm.
How it works
You set it up once and release what you approve. Everything between those two points runs overnight. Gold is you. Every other colour is an agent.
Filing language, a leadership change, a hiring post
The phrases that count, and whose desk it lands on
Everything a company says in public, overnight
Only the industries your practice sells into
Who holds the problem, and how to reach them
Conflicts, current clients and live pursuits
Fit, urgency and confidence, kept separate
The evidence travels with the lead
A one-pager and an intro email, built from the evidence
It sits in your drafts until you send it
Phases, people and a price, on budget and burn
Won or lost, what found it is scored
What happens next
Finding the work is half of it. A flight is the outreach that follows. It starts by showing up rather than asking: a follow, then a like on something they actually wrote. Only then does the first note go out, written from the evidence that started it, and any stop can end the flight.
Data Engineering and Analytics
The change, in their own words, and what it usually costs
A connection note, 183 characters, queued for you
The matching work this firm already delivered, attached
A comment on the thing they posted this week
A short check-in, with a date in it
Close the loop and leave the door open
CraigThe closer
They answered the day 5 email on day 6. Everything still queued was dropped that morning, and the thread moved to the consultant who owns the pursuit.
Valuation
The deal, and the allocation work that follows it
A connection note, queued as a task for you
What a close usually misses, and what a redo costs
A comment on their post about the close
A short check-in, with a date in it
Close the loop and leave the door open
FaithThe gatekeeper
Another practice opened an engagement with this company on day 5. Faith screens every live flight against the firm record daily, so the hold went on the same day the engagement was entered, three days before the next stop was due. The lead went to the relationship partner instead of a consultant who would not have known.
Outsourcing
The gap they announced, and who usually fills it
A connection note, queued as a task for you
The same cover, run twice before, with the numbers
A comment on what their team posted
A short check-in, with a date in it
Close the loop and leave the door open
CraigThe closer
Nobody answered. The flight closed clean on day 14, and the language that found this company was scored down so the next one is better aimed.
Four conditions, checked every day it is in the air. Any one of them ends it, and none of them need a person to notice.
Pipeline
Found work is only interesting if it turns into pipeline. Every pursuit carries the public change that started it, the agent that found it, and the days it took to get where it is.
Data Engineering and Analytics
Started by
A control called out, with a date on it
Valuation
Started by
An asset deal, and the integration behind it
Outsourcing
Started by
A finance seat changing hands
After you win
Bailey reads the signed SOW into a table of deliverables, dates and acceptance criteria, then measures the engagement against it every day it runs.
Power BI rebuild, fourteen monthly reports
Before it is soldWhat would it cost to move the monthly commercial pack out of spreadsheets and into Power BI?Pursuit record, Thursday 11:02
Staffed from the skills record
Quote drafted at 680 hours, three consultants named, one skill gap written into the assumptions
BaileyThe project manager
Everyone on the bench has strengths and gaps on the record. The quote picks the team from that record, prices it off engagements the firm actually ran, and says out loud which gap still needs covering.
Hedge accounting reporting pack
Week 3 of 14While you are in there, can you add the basis positions to the same pack?Project mailbox, Tuesday 09:14
Measured against the SOW
Change order drafted, 36 hours, waiting in your drafts
BaileyThe project manager
Caught on Tuesday, not at closeout. It never reaches the client without a signature, and it never quietly becomes free work.
Midstream close support
Week 9 of 1479% of the budget is spent against 64% of the work.
Timekeeping, Friday 18:00Measured against the plan
Flagged at week 9, with five weeks left to do something about it
BaileyThe project manager
Burn is read against the work remaining, not against the calendar. A budget that is going to run out says so while there is still time to re-plan it.
Two pursuits, one senior analyst
Before either closesBoth of these close in the same month, and both of them want the same person.
Pipeline, weighted 70 percent and upMeasured against the bench
Named two alternates before either engagement was sold
BaileyThe project manager
The staffing question gets answered while the work is still in the pipeline, not the week somebody was supposed to start.
Gas gathering system valuation
The week it closedFinal deliverable accepted. The engagement closed Friday.
Engagement record, Friday 16:20Measured against what was promised
Case study drafted into the quals index, ready for the next pursuit
BaileyThe project manager
The engagement that just closed becomes the proof for the next one. Nobody has to remember to write it up six months later.
Documentation intelligence
A requirements document gets signed at kickoff, and then the build moves on without it. Documentation intelligence follows every step of the project, keeps all three current with what was actually decided, and aims each one at the person who has to read it.
BRD
For the business owner who signed off
What the business asked for, in their own words, with a date and a name on every decision that changed it.
TDD
For the developers who build it
How it actually gets built. Tables, measures, refresh windows and who can see which rows, written while the build happens instead of after it.
Desk Guide
For the analyst who opens it Monday
How to use the thing, in the language of the job. The screens, the steps that matter, and the questions every new user asks in week one.
Every draft carries the record it came from, so a change is visible instead of silent and nobody is reading version four while the build is on version nine. None of it reaches the client without your signature.
Every firm in the market can pull the same titles at the same companies. What none of them can buy is the sentence where a company said out loud what it needs. That is the part ArcHive goes and gets, and it keeps going long after the first email.
Every service line, not one of them. The same machine runs for Complex Financial Reporting, Valuation, Restructuring, Tax, Transactional Advisory and the rest. What changes between them is what each practice says it sells. Nothing underneath it changes at all.
FAQ
A bought list gives you a title at a company. It cannot tell you why that company would take the call. ArcHive starts from the sentence where a company said what it needs, and that sentence stays attached to the name through screening, outreach and delivery.
Filings, dockets, earnings calls, job boards, LinkedIn, licensed business data and the firm's own record. Everything it reads is something a company put where people can see it. What we will not publish is the specific language and sources a practice searches on, because that is the part that took the work and it is the part worth keeping.
Never without you. Every email, message and comment waits in your drafts until you release it, every flight re-screens for conflicts the morning a stop is due, and the whole flight stops the moment anyone replies.
Faith screens every name against the client list, the conflict register and every live pursuit before a consultant sees it, and she re-runs that check the morning each stop is due. An engagement entered today holds a flight today, not at the next scheduled step.
It never acts inside your account. Where a step belongs on LinkedIn it is queued as a task with the draft already written, and you do it. There is no session driving and no automation of anything that carries your name.
Nobody is worked twice. A person already inside another consultant's flight is blocked, and the record shows who holds the pursuit and since when. If it should be yours, it moves with a conversation, not a race.
Everything stops. The remaining stops are dropped the moment a person answers and the thread is yours from there. The flight exists to start the conversation, not to keep talking over it.
Every signal carries the sentence and the source that produced it, so a bad read is visible in seconds rather than discovered on a call. Where the record does not say something, the product says so instead of filling the gap with a guess.
No client data leaves the firm. Prior work is referenced from the firm's own record so a draft can say what we have done before, and that reference never travels outside with the note.
No. It does the reading nobody has time for and hands a consultant something worth a conversation. Every word that reaches a client still goes out because a person released it.
It reads public record and writes back into the systems the firm already pays for. No new platform, no new vendor, nothing for anyone to learn.
Why it exists
Finding work has always been manual: read something, recognise what it means, pick up the phone. ArcHive does the reading every night and hands a person only what is worth a conversation.
Leads the BI and analytics team at Opportune, building the data platforms and reporting the energy practices run on. Came to analytics from a decade in corporate accounting.
Builds the interfaces Opportune's analytics work ends up in, from the first sketch to the screen people actually open.
Built for the Opportune AI Competition.
That is the screen you open in the morning. Found, screened, scored, drafted, waiting on one click from you.
ArcHive does not track you. No analytics, no advertising and nothing sold on. Accept and this browser remembers that you have read this. Choose essential only and nothing is kept at all.