So, after taking a glance at WP, it sounds like he died while the season 5 episode "Hero Worship" was in production.
It also appears that during season 4, story treatments(or whatever they're called for television) still needed to be submitted to Gene for approval, but in the case of "Family," a story which Gene thought was too soapy, Berman could "overrule" him.
He was also present at the celebration of TNG's 100th episode, the season 4 finale "Redemption."
He was an EP during season 5, and continued to be credited as such after his death, for the remainder of the season.
I'm just wondering if he was in better health, and been more proactive, would anything else have changed. I'm really impressed at how Paramount TV, Gene and Rick, etc, went about launching TNG in direct syndication so that the major networks couldn't interfere creatively. And how they got local networks to pick up TNG.