Manufacturing

Focused and actionable insights from you data help improve manufacturing operations faster and more efficiently. Discover new ways to streamline operations with Fusion's dashboards and analytics.

Manage your warehouse better, create better demand forecasts for products, get insight into your machine utilization/ effectiveness, and more! Fusion has the expertise with data & manufacturing to help you optimize your business. See below some of the work we have done for our clients in this industry.
SPH-F0210127 - © - DISABILITYIMAGES\SPL

CARUS CORPORATION / Manufacturing Success Story

Our solution has enabled Carus to optimize the efficiency of their sales efforts. They are now able to view interactive, “ad hoc” sales reporting and drill through from sales by market, region, territory, product line, sales channel, and customer to SKU level. They also view YTD and MTD totals at each level for volume, net revenue, average net selling price, contribution margin, and gross margin both actual and budget. As a result they’re now able to improve sales M execution with immediate visibility into areas of opportunity.
CUL-54DDT0120RF - © - Hybrid Images

MITRATECH / Manufacturing Success Story

High tech (software) manufacturing company and an OEM client of BusinessObjects. Purchased services from Fusion to accomplish addressing environmental and WebI report related issues caused by a recent upgrade to Rackspace hosted environment. Also implemented a BusinessObjects 3.0 to 4.0 upgrade.
Automobile manufacturing plant

GULF STATES TOYOTA / Manufacturing Success Story

Brio-to-Business Objects conversion project. Work involved converting over forty Brio reports, rebuilding Brio applications in both VB and JSP, creating a folder structure for Corporate documents within Webi, dynamic/dependant List of Values based on BO prompts within Webi, a Broadcast Agent monitoring and email script for failed jobs, a global email script which parses email addresses out of the Comments section of document properties as well as filters the document based on values assigned to addresses in the Comments section, drill-through from Summary to Detail reports via hyperlinks in PDF, dynamic Webi layouts based on document keywords as well as other Webi customizations through JSP, database tuning and hint integration, configuration of WebLogic against WebIntelligence, an export to Excel utility within Webi for full-client reports.
Y9H-2975724 - © - Richard Levine

FRITO-LAY / Manufacturing Success Story

Created five business objects universes for three separate data warehouses and one transactional database and over thirty reports for six projects. Additional work included data design on the DB2 and Oracle platforms. Assisted in implementing the star schema execution path for Oracle’s optimizer and integrated hints into the universe. Instructed the Pepsico Business Solutions Group on universe design, tricks and techniques, and SQL logic. Devised several strategies for “report bursting” and deployment. Created views and multiple types of indices to improve performance.
A warehouse of a new PepsiCo plant, the US beverage giant, unveiled in Domodedovo, Moscow Region, Russia.

PEPSICO / Manufacturing Success Story

A DB2 to Oracle Business Objects repository migration for all of the Pepsico divisions (approx. 6500 BO users, 6.5 GB). Migration of a custom “User Registration” database as well as Business Objects Auditor. Data movement and mappings were performed using SQL Server DTS. Made a seriesof enhancements to Auditor reports and universes. Creation of custom Java applications, Webi on Unix and Oracle performance tuning.
Workers meeting in manufacturing plant

IOMEGA / Manufacturing Success Story

Re-engineered the HR reporting process during a two-month assignment. Rapidly designed a complex business objects universe against an Oracle data mart and recreated all their reports. Migrated Business Objects to the latest version. Designed and resolved security infrastructure for globally distributed HR querying. Prepared and administered customized training for the HR analysts. Supported HR generalists in new report development. Interfaced with Essbase and Iomega’s Oracle HR data mart, for two of their complex reports that required a combination of the data.
Business people reviewing financial data on digital tablet

USANA, INC / Manufacturing Success Story

Set up a master installation of Business Objects, designed the universe, provided individual training, and recreated five of their top reports in an eight day period. Created an Executive Information System, using ReportScript. Customized drill-down with enhanced security giving end-users the ability to drill only portions of the database. Later work included data design for an additional data warehouse and performance tuning.
JUI-118422 - © - Ian Lishman

TEXTRON / Manufacturing Success Story

Implementation of an HR Data Warehouse from various sources of data. Primary source of HR data was Peoplesoft Transaction system. Additional systems from which the data model and DW was developed included ADP Payroll system extracts, SumTotal Learning Management System and Benefits system.
CIE-412-37923 - © - Agnieszka Olek

ESSILOR / Manufacturing Success Story

Essilor International only has eyes for eyes. Banking on the fact that one-fifth of the world's population wears glasses, the company is a leading maker of ophthalmic products and supplies, particularly corrective lenses. Essilor distributes its lenses through a global network of about 250 company-owned prescription laboratories, as well as through independent labs. We provided ETL expertise and Development of an existing 500 GB enterprise-level data warehouse environment.
1775R-17577

LILLY / Manufacturing Success Story

Pharmaceutical Manufacturer. Designed and developed ETL routines for proof-of-concept phase for a very large data warehouse project. Our responsibilities included working with subject matter experts to analyze business requirements of trial lab results, design and development of mappings, unit and system testing, and extensive documentation of mappings.
CIV-HX05279 - © - Robert Daly

EXEMPLAR / Manufacturing Success Story

Business Objects deployment against SQL Server 2000 and DB2/400 V4R5 databases. Developed a Financials universe against the BPCS ERP application. Created a script to distribute reports via email using collaborative data objects within a Windows 2000 environment. Created a set of Executive Dashboard reports containing hierarchical drilling.