|
Client is a nationwide supplier of steel.
Business need
To increase overall sales by extending purchasing opportunities for client’s customer base. Must compute complex product price and delivery schedule using customer's existing enterprise resource planning (ERP) system. Fully integrated e-commerce site supports the order from the internet to the truck. Solution Leapfrog managed the technology team and collaborated with client resources (IT and business) to deliver an industry-leading e-commerce site. Delivered project on time and below budget. Completely automated and fully integrated with JD Edwards (EnterpriseOne), the system provides real time inventory and highly customized order delivery time estimates and price quotes. Leapfrog provided continual project oversight, activity prioritization, representation to executive team, QA coordination, data model design, training and production implementation. Results Sales via e-commerce interface continue to exceed expectations and client receives ongoing positive feedback from buyers regarding their e-commerce experience. Client recently commented that “chat” service is rarely used because the “system works so well, there aren’t any questions!” |
|
Data warehouse and strategic planning initiativeClient is a global forestry-centered investment manager.
Business need
Enhance decision-making capabilities in an environment of significant growth by providing efficient and flexible access to timberland management information from multiple contractors for overseas properties. Contractor operational details are needed to accurately reconcile financial data. Solution Leapfrog standardized and optimized data collection for reporting from a diverse body of non-standardized budget and operational data sources. Created the data model and developed a technical process for interfacing information from international contractors and internal budget analysts. Data reflects domestic and export timber production, expenses and projections. Managed all facets of the project from concept to delivery. Results Completed project includes database, SQL Server Integration Services (SSIS) packages to load vendor extract data. Data model is designed with comprehensive transparency of property, expense/ revenue activity, unit of measure and currency context for every metric. |
|
Conversion of pipeline transmission contractsClient is the largest energy infrastructure company in North America with 84,000 miles of pipeline.
Business need
Convert data from four separate natural gas pipeline operation systems (obtained from company acquisition) into parent company's proprietary system. Pipeline information contains contractual details regarding customer’s purchased rights to use the pipeline for gas transmission. Specifically, data includes contract pricing details, allowable pipeline point quantities, agency agreements and capacity release arrangements in which customers release purchased pipeline rights to others. Solution Leapfrog interpreted pipeline business rules, guided the user community through the data mapping, and created the process for tracking and evaluating each data conversion over a five-year period. Each project phase was critical to the company’s mission to consolidate systems. Accuracy was paramount to ensure natural gas delivery reliability and required consummate documentation as it was subject to thorough review by the FERC (Federal Energy Regulatory Commission). Results Over 28,500 miles of gas pipeline service contracts were successfully converted from the first three pipeline systems (the fourth is in progress). A smooth transition was facilitated by the data conversion preceding the final conversion which allowed customers time to train and review their known contracts. |
|
Power generator optimization data collectionClient is the largest wholesale electricity provider in the Southeast.
Business need
Collect and organize energy load forecast and inter-related generator characteristics from disparate sources into a model designed to minimize energy generation cost while maximizing reliability. Solution Leapfrog was responsible for all facets of the project: planning, implementation, product validation and client communications during the 24-month implementation. Leapfrog managed the communication across multiple customer and technology teams, and designed the data model and the data integration plan to collect and normalize information for all data sources. Results System allows business to collect data, visualize and compare optimized schedules running over 70 generators while honoring all reliability constraints and meeting the projected electricity demand. |