PetroleumReports
Streamlined petroleum industry reporting
ANH (National Hydrocarbons Agency) reporting platform for engineers to submit production and loss reports with interactive mapping and dashboard analytics.
ReactNode.jsMaps APIDashboardReporting System
Problem
Petroleum engineers lacked an efficient system to report production data, losses, and maintenance issues to the National Hydrocarbons Agency, leading to delayed reporting and poor communication.
Solution
Developed a comprehensive reporting platform with interactive maps, real-time dashboards, and streamlined communication between wells and engineers for the ANH regulatory requirements.
Results
- Streamlined reporting process for petroleum engineers
- Interactive mapping system for well location tracking
- Real-time dashboard for production and loss monitoring
- Improved communication between wells and engineering teams
- Compliance with ANH regulatory requirements
- Analytics and trend analysis for operational insights
- Mobile-responsive design for field use
Tech stack
Frontend
- React 18
- TypeScript
- Vite
- Tailwind CSS
- Radix UI
- TanStack Query
- React Hook Form
- Leaflet / React-Leaflet
- Recharts
- Wouter
Backend
- Node.js
- Express
- Drizzle ORM
- PostgreSQL (Neon)
- Passport (Local, Google, Microsoft)
- express-session + connect-pg-simple
- Multer
- AWS S3 presigned uploads
- WebSocket (ws)
- Nodemailer / SendGrid
Infrastructure
- Render (deployment)
- Neon serverless Postgres
- AWS S3 storage
- Drizzle Kit migrations
- Esbuild server bundling
Key challenges
- GIS performance and smooth rendering of large GeoJSON maps on low-end devices
- Complex ANH reporting workflows with validations, attachments, and role-based approvals
- Secure file handling with presigned S3 uploads and access control
- Enterprise SSO integration (Google/Microsoft) with hardened session management and email flows