c07-customer-stories

MDIC

The National Department of Commercial Registration (DNRC), a department within the Brazilian government’s MDIC, is tasked with gathering commercial registration information from all 27 states across the country (and across multiple time zones).

“When the government minister asked the question in parliament about the state of business in Brazil, it took one week to find the answer. By introducing a single, trusted, and timely view of company registration information using the Informatica Platform, we can now answer that question in less than one minute.”

Sidnei Yokoyama, Chief Information Officer, MDIC

org-chart-icon.png

Business Need

Provide single, complete, and trusted view of businesses registered in Brazil.

Enable fast, accurate decisions about government industrial policy.

Maximize efficiency of government departments.

challenges_icon.png

Challenges

Registration data arrived in a variety of formats—different flavors of Oracle, SQL Server and DB2-sourced flat files. It arrived at different times of the month depending on which state was sending it. And some of the information coming in was of unreliable quality.

Lower the time and resources needed to integrate the data and share the business intelligence arising from it.

MDIC data analysts could only examine simple statistics, such as the number of new businesses opening across Brazil in one month.

airplane-icon.png

Solutions & Results

Put potential of commercial registration information to work, improving government strategic planning.

Reduced time needed to answer key policy questions from one week to one minute.

Delivered trusted, single view of 53 million companies that is complete, accurate, and timely.

Integrated data quickly and efficiently, regardless of datatype or source.

Helped nurture and grow fledgling businesses.

Identified market and business trends.

tech_use_icon.png

Products & Services

Informatica PowerCenter Advanced Edition

Standardizes data integration at an enterprise level, across numerous projects and departments.

Success Stories

cc01-usgs.png
United States Geological Survey

U.S. Geological Survey improves system performance by 30 percent

cc01-netherlands-ministry-of-defense.png
The Netherlands Ministry of Defense

Deployed PowerCenter to standardize data migration methodology for greater efficiency.

cc01-us-airforce.png
Air Force Knowledge Services

Using Informatica PowerCenter, the Air Force identified more than $600 million in excess parts and recouped $300,000 in excess equipment in one week.