E-commerce data on laptop
Case Study:

Carbon Emissions Compliance Management System

Marketing Director

Client

Global Retail Inc.

Case_studies_final_industry.svg

Industry

eCommerce & Retail

Case_studies_final_Region.svg

Region

North America & Europes

Challenges

New York City mandates property owners to meet stringent energy compliance regulations under Local Law 84 (annual carbon emission disclosure via the EPA’s Energy Star Portfolio Manager) and Local Law 33 (public display of building energy efficiency grades).

Our client, a service provider managing these regulatory processes for numerous properties, faced operational inefficiencies due to fragmented, manual workflows. LL84 compliance required extensive data gathering, processing, and submission with little visibility or traceability. LL33 demanded online retrieval of energy grade certificates from the Department of Buildings (DOB), preparation of print-ready delivery packages, and shipment coordination — all done manually. These efforts were time-consuming, error-prone, and lacked real-time monitoring or cross-team coordination.

Background pattern
Goals & Objectives

The client was struggling to stay competitive in a rapidly changing market where competitors adjusted pricing thousands of times daily. Their manual monitoring process was slow, inconsistent, and covered only a fraction of their catalog. They needed real-time visibility into competitor pricing across their entire product range to optimize their pricing strategy.

Automate the end-to-end compliance process for New York City’s Local Law 84 and Local Law 33, which mandate annual energy consumption reporting and public display of building energy grades respectively.

Eliminate fragmented workflows and manual dependencies involved in data collection, certificate retrieval, document packaging, and regulatory submission.

Increase traceability, accuracy, and accountability across the compliance lifecycle through real-time tracking, automated updates, and centralized workflow management.

Enable seamless collaboration among cross-functional teams by integrating commonly used platforms (e.g., Dropbox, Asana, FedEx, Gmail) and offering dashboards for operational visibility.

Build a scalable and cost-efficient system capable of managing high-volume customer accounts with minimal incremental resource requirements.

Requirements

A centralized web application that facilitates data collection, task tracking, and ESPM (Energy Star Portfolio Manager) submission for LL84 reporting.

Automation bots and web scrapers capable of extracting billing and energy data from utility PDFs and third-party websites where APIs were unavailable.

A queue management system to efficiently handle large volumes of compliance submissions and processing tasks during peak cycles.

Web automation tools to programmatically retrieve energy grade certificates from the NYC Department of Buildings (DOB) portal for LL33 compliance.

Integration with FedEx APIs for automated shipping label generation, along with tools to compile and print-ready delivery packages containing certificates and related documents.

Seamless integration with Dropbox for document storage, Gmail for communication workflows, and Asana for assigning, tracking, and updating tasks in real time.

A real-time dashboard interface to monitor process stages, highlight bottlenecks, assign responsibilities, and track compliance statuses across departments.

Smiling Man
Solution

We built a custom price aggregation system tailored to the client’s operational and strategic needs:

solution icon
Web Application:

Developed using .NET MVC, C#, and Angular, this centralized platform manages quotes, proposals, contracts, billing, and customer records. It includes key features such as automated email generation, contract workflow review boards, and rule-based business process automation.

solution icon
Desktop Application:

Built with WinForms and DevExpress, this system provides an Excel-like interface tailored for power users. It supports offline access, advanced custom grid views, and embedded automation tools for efficient data management.

solution icon
Supporting Automation:

We implemented intelligent web scrapers and PDF extractors to retrieve billing data from utility websites and documents, converting unstructured inputs into clean, structured records within the system’s database.

Together, these integrated systems streamlined operations, enhanced data accuracy, and provided real-time visibility into the full customer and contract lifecycle.

Background pattern
Results

The automation suite led to a 60–70% reduction in manual labor across both compliance workflows—streamlining certificate downloads, data submissions, and package deliveries.

By integrating systems like Dropbox, Asana, and FedEx APIs, the client achieved real-time visibility and traceability, allowing operations teams to monitor compliance statuses, pending actions, and delivery stages instantly.

The solution enabled error-free and faster ESPM submissions by eliminating fragmented data collection, automating data validation, and enforcing consistent workflows for LL84 compliance.

For LL33, the delivery workflow was transformed from a multi-step manual process into a one-click, fully automated cycle, including dynamic FedEx label generation, document preparation, and proof-of-delivery logging.

The client saw a drastic improvement in cross-functional coordination and task ownership through modular dashboards, automated syncs, and structured workflow queues.

Overall, the system ensured higher compliance accuracy, faster turnaround times, and a scalable foundation to serve a growing customer base with minimal additional overhead.

Technologies Used

Python
Scrapy
Selenium
PostgreSQL
Redis
airflow
Docker
Kubernetes
Power BI
FastAPI
Profile of Lora Smith

It is a long established fact

Iusto quia perspiciatis inventore tempora. Velit vitae tempora et laborum id soluta est ut laboriosam. Eveniet possimus autem ratione aliquid in sunt tempora. Amet rerum suscipit distinctio voluptas. In quis voluptas necessitatibus et aut dolor ut quod. Sapiente et adipisci tenetur voluptatibus qui.

Lora Smith

Ready to harness the power of your data?

Our team of experts is ready to help you transform raw data into actionable intelligence.