Successful IT Solutions

Case Studies + White Papers

IDI Consulting Projects

 

MAJOR UTILITY:

  • Management Consulting / Project Management / Application Design / Conversions
  • Performed lead roles in startup of this utility as an independent organization
  • Achieved business and Information Technology operational independence within 18 months
  • Replaced over 70 applications
  • Established Data Center support
  • Established hardware, software and telecommunications infrastructure to support new organization
  • Performed Project Management on SAP implementation, including interfaces and data conversions
  • Managed SAP integration projects including imaging, multiple field and administrative applications and outsourced Payroll processing
  • Developed and implemented several corporate and departmental applications to replace Dominion applications, including data conversions
  • Designed and implemented Historical Data Warehouse
  • Managed integration of acquisition into the major utility's applications and processes

 

MAJOR HEALTHCARE PROVIDER ASSESSMENT:

  • Performed Assessment of Project Requests process and procedures for Financial Project Planning
    IT organization.
  • Recommended improvements to current methods

 

INDUSTRIAL DISTRIBUTION COMPANY ASSESSMENT:

  • Performed Assessment to analyze issues involved in the day and night batch loading process of the Data Warehouse production server
  • Analyzed the schedules, load and demand on the production server
  • Recommended corrective action to avert future processing bottlenecks.

 

MAJOR UTILITY FINANCIAL PLAN INTEGRATION APPLICATION:

  • Designed, developed and implemented a browser based application to integrate Financial Forecasting, Budgeting and Actual Cost Reporting
  • Application is used to plan, prepare and monitor departmental budgets and commitments
  • Actual costs are received from corporate Accounting interface

 

MAJOR UTILITY POWER FORECASTING RISK MANAGEMENT APPLICATION:

  • Designed, developed and implemented a browser accessed Business Intelligence application for electric utility to perform in Risk Management of Power Forecasting
  • Enabled in house capability to forecast, manage and account for purchasing of power
  • Established an integrated Oracle data base, enabled performance or the statistical analysis and data manipulation in house, and provided reporting and analytical capabilities

 

MAJOR UTILITY WORK PLAN INTEGRATION APPLICATION:

  • Designed, developed and implemented a browser based application used to plan, manage and report all utility Capital improvement and maintenance projects
  • Enabled integrated forecasting, budgeting, planning, resource allocation and loading and management reporting

 

MAJOR INSURANCE COMPANY PROJECT MANAGEMENT:

  • Performed Project Management on implementation of new integrated Claims Processing application for insurer
  • Planned, directed and managed all testing and implementation phases of business critical application across multiple lines of business replacing several departmental systems

 

PROVIDER OF NUCLEAR TECHNOLOGY REQUIREMENTS ANALYSIS:

  • Performed Requirements Analysis to design integrated data warehouse solution to replace multiple departmental Primavera data bases used to plan, schedule and manage various nuclear power plant projects

 

UTILITY COMPANY ACQUISITION ASSESSMENT:

  • Performed business and application assessment as part of utility potential acquisition analysis

 

MAJOR MANUFACTURER REQUIREMENTS ANALYSIS:

  • Performed Requirements Analysis for implementation of integrated application to manage corporate Industrial Hygiene labs and management reporting

 

RACE TRACK & CASINO MARKETING DATA MART:

  • Designed, developed and implemented an integrated Data Mart for all Marketing related activity for the race track
    and casino
  • Developed policies, procedures and standards to improve operation of IT department

 

MAJOR UTILITY – DATA WAREHOUSE PROJECT

  • Designed and implemented a Customer Data Warehouse. The warehouse provided the Marketing department with the capability to analyze customer electricity usage and provided them with a strategic advantage during the deregulation of the Electric Utility industry in Pennsylvania.
  • Designed the DB2 databases used to support the Customer Data Warehouse.

 

MAJOR UTILITY – DEREGULATION PROJECTS

  • Managed the design and implementation of an electric generation supplier billing system. The system allowed the company to bill electric generation suppliers for transmission and energy imbalance charges.
  • Developed the functional specifications for the electric generation supplier’s forecasting and reconciliation system. The system enabled the company to forecast hourly consumption usage for each supplier’s customers and reconcile the delivered electricity to actual customer usage. The under-supply of electricity to the company resulted in an energy imbalance bill to the supplier.
  • Designed the DB2 databases used to support the electric generation supplier’s forecasting, reconciliation and
    billing systems.

 

MAJOR UTILITY - APPLICATION INTERGRATION & CONSOLIDATION PROJECT

  • Developed three strategies for AI&C:
  •  Low end - Eliminate Point to Point Integration, Establish Data Packets, Establish Data Exchange Integration
    • Use existing architecture
    • Data Integration in Batch Mode using Hub - Spoke Model
    • BPM from industry organizations
    • CIM Data Model
  • Medium end - Establish Real Time Application Integration
    • Use existing web services
    • Purchase Business Models
    • CIM Data Model
    • Acquire Tools
  • High end - Establish Model Driven Application Integration
    • Establish Utility Integration Bus (UIB)
    • Re-engineer Business Processes
    • CIM Data Model
  • Developed a Data Modeling Software Request For Information and sent to vendors
  • Developed a Business Process Modeling Request For Information and sent to vendors
  • Developed a SOA Request for Information and sent to vendors

 

EDUCATION - REQUEST FOR PROPOSAL PROJECT

  • Developed a Request for Proposal for converting their existing Data Repository from Paradox to SQL Server 2005
  • Completed and submitted the proposal

 

MAJOR MANUFACTURER - MARKETING SCORECARD STORYBOARD PROJECT

  • Developed a Storyboard for a Glass Division Marketing Scorecard
  • dynaSight was used as the Storyboard development tool

 

UNIVERSITY - DELPHI DIABETES MANAGER SOFTWARE AUDIT PROJECT

  • Conducted an audit of the software to determine:
    • The availability and security of the diabetes related data. The hospitals participating in the diabetes project have been entering data into the software since January of 2006. No data has been transferred, to date,
      for review.
    • The data collection process, trending and aggregation of the data for the use of the Diabetes Clinic
    • Validity of the data being reported and the formulas and calculations used to produce the reports.
    • The amount of data being used to produce the reports
    • How and where the data is being stored

 

MAJOR UTILITY - IT ASSET MANAGEMENT DATABASE PROJECT

  • Developed the logical data model for the IT Asset Management Database
  • Implemented the physical data model using SQL Server 2000
  • Wrote the specifications for the application
  • Managed the development of application using 1 developer
  • Tools: dynaSight, SQL Server 2000

 

FOOD PROCESSOR - DASHBOARD REPORTING SYSTEM PROJECT

  • Developed the logical data model for the Dashboard Reporting System
  • Tools: SQL Server 2005

 

SUPPLY CHAIN SOLUTIONS COMPANY - INTEGRATED DATA WAREHOUSE PROJECT

  • Developed the logical data model for the IDW
  • Implemented the physical data model using SQL Server 2005
  • Wrote the specifications for the DW
  • Managed the development of the Data Warehouse using 1 developer
  • Tested the application
  • Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server 2005

 

PROVIDER OF NUCLEAR TECHNOLOGY - WORKFORCE PLANNING DATA MART PROJECT

  • Developed the logical data model for WFP Database
  • Developed the Source to Target mapping for the ETL
  • Implemented the physical data model using SQL Server 2005
  • Tested the application
  • Tools: Business Objects XI, Xcelsius 2008, SQL Server 2005

 

CHURCH ENVELOPE PRODUCER - BUSINESS PROCESS MODELING PROJECT

  • Reviewed existing as-is business process documentation
  • Gained a working knowledge of Epicor processes: Sales Management, Production Management, Material Management, Financial Management
  • Documented the to-be business processes using the Epicor application
  • Tools: Epicor ERP software, Visio Professional 2007

 

MAJOR UTILITY - HISTORICAL DATA WAREHOUSE PROJECT

  • Reverse engineered existing Customer DB2 and Sybase tables
  • Developed the logical data model for the Data Warehouse
  • Created SAP Historical Data Warehouse Tables using Visio
  • Loaded SAP Historical Data Warehouse Tables using flat file input and BIDS packages
  • Tools: Visio Professional 2007, SQL Server Business Intelligence Development Studio, SQL Server 2005 / 2008

 

HEALTHCARE PROVIDER - EVOLENT ETL PROJECT

  • Wrote the ETL specifications for loading Enrollment and Claims data from flat file input to the Evolent Database
  • Managed the development of the ETL using 1 Informatica developer
  • Tested the application
  • Tools: Informatica 9.0, SQL Server 2008

Placeholder

IDI Consulting FacebookIDI Consulting TwitterIDI Consulting LinkedIn

© IDI Consulting, LLC
777 Penn Center East Blvd
Suite 201
Pittsburgh, PA 15235
Phone: 412-829-3010