Skip to main content
UploadLanguage (EN)Support
BusinessMobileSocial MediaMarketingTechnologyArt & PhotosCareerDesignEducationPresentations & Public SpeakingGovernment & NonprofitHealthcareInternetLawLeadership & ManagementAutomotiveEngineeringSoftwareRecruiting & HRRetailSalesServicesScienceSmall Business & EntrepreneurshipFoodEnvironmentEconomy & FinanceData & AnalyticsInvestor RelationsSportsSpiritualNews & PoliticsTravelSelf ImprovementReal EstateEntertainment & HumorHealth & MedicineDevices & HardwareLifestyle
TB
Uploaded byTracey Brookes
361 views

CPS Energy Projects.docx

The document discusses several key initiatives and metrics that were tracked using business intelligence applications like the Key Performance Indicator (KPI) Metric Dashboard, SAP Business Warehouse (BW), and Business Planning and Consolidation (BPC). It summarizes initiatives to improve the performance and reliability of BW and Business Objects systems, implement new data models and reports, automate testing, and migrate Crystal reports. Security improvements were also made to the BW and Business Objects platforms.

Business◦
Download to read offline
KEY INITIATIVE TRACKING APPLICATION (KPI METRIC DASHBOARD) Enterprise Application Delivery (EAD) implemented a web application to support the office of the CPS Energy President/CEO to view and track senior executive key initiatives. The application is equipped with a secure web interface, a supporting database, and reports that will facilitate tracking of daily/weekly/monthly management objectives. Metrics that I and my team were responsible for: DASHBOARDS – IT DEPARTMENT OPERATIONS Business Unit, Department and Team Dashboards to assist in tracking system usage, users and peak reporting times to manage system resources and maximize optimal system performance. SAP BUSINESS WAREHOUSE ACCELERATOR (BW ACCELERATOR) A project is under way to implement new hardware appliances that will speed SAP Business Warehouse (BW) reporting by 10-100x. The new BWA addition will be transparent to BW users since there will be no change in the way they interact with the system. BW PERFORMANCE IMPROVEMENTS Restructured and redesigned all cubes in the BW system to improve reporting and loading performance system wide 90% and 45% respectively. BW data was reloaded from source systems into the cubes or moved from one BW or Oracle structure to another to enact the change. The performance improvements also included the logical partitioning of cubes into relevant time periods, but this could be additionally alleviated with the implementation of the BW Accelerator Appliance. The logical partitioning assisted in systematic annual archiving. BPC (BUSINESS PLANNING AND CONSOLIDATION) I oversaw the project team implementing BPC for our organization in coordination with a Big 5 Implementation Partner. NetWeaver BPC version was implemented along with 15-30 reports. BW System Reliability The BW system will be up 95% of the days of the year unless due to planned scheduled outages. Data will be loaded and available before 7:30am each morning. BW system issues will be logged in HPSM Problem detailing the dated BW Load Issue. Statistics collected at the end of the accountable time period will be assessed against 365 availability days of the year. This metric will increase over the next 3 years until 99%. ACTUAL RESULT: 99% for 3 years BI System Reliability The Business Objects system will be up 95% of the days of the year unless due to planned scheduled outages. Business Objects system issues will be logged in HPSM Problem detailing the dated BI Issue. Statistics collected at the end of the accountable time period will be assessed against 365 availability days of the year. This metric will increase over the next 3 years until 99%. ACTUAL RESULT: 98.7% for 3 years
HCM: HEADCOUNT, PA, PD, OM, RECRUITMENT, TM, TRAINING TRAVEL MANAGEMENT INFOCUBE A new Travel Management InfoCube was recently tested in the BW Quality Assurance environment. This InfoCube will provide BW users with Travel and P-card expense information. The new InfoCube will be moved to production after the proper security environment has been put in place that will secure data at the Organizational Unit and individual levels. HCM: HR CYBORG – LEGACY DATA INTEGRATION Integration of HR legacy data from the Cyborg system. Data Retention was the key objective of this project and was in progress upon my leaving the company. FI/GL: FINANCIAL REPORTING Implementation of BW standard infoCubes: AP, GL, PCA, Cash Flow of Funds, Balance Sheet ** new GL extractors available under ECC 6 were not used as ECC system utilized the classic FI-GL module and CCS tables. PM: PLANT MAINTENANCE Implementation of BW standard infoCubes in the area of Plant Maintenance and Work order tracking. WMIS – Work Management Information System, a legacy system capturing the creation of work orders for the Operations/Field workers. SALESCUBE REDESIGN The reengineering of the existing Sales data being captured consisting of customer data: 20 million records per quarter segment. The existing reports were running 3 hours+ and with the restructuring efforts and BW Accelerator, this was reduced further down to 50mins. Business Units required additional data to be added and historically loaded. This project was to start after my departure and continue into 2013. UTILITIES MASTER DATA REPORTING New cubes are now available in Business Warehouse (BW) for Utilities Master Data:  Connection Object  Contract Account  Device  Premise  Utility Contract  Installation  Rate Data between Installation and Devices  Rate Data between Register and Devices In order to access these new infoProviders, select Utilities/Customer Care & Service from the BISC Online Access Request Form on CPSConnect. Detailed documentation can be found on the BI Information Portal via CPSConnect >>Shared Services>>Information and Communication Services (ICS) >>Business Intelligence>>What is available>>Customer Care & Service – What data are available? Or by viewing the lunch & learn presentation on I-Grid under ICS-EAD Resource Page.
NEW METER INSTALLS Reports on New Meter Installs are now available in the BW that details the Energy Delivery Services (EDS) and Retail collaborative definition of ‘New Meter Installations’. Three reports provide managers and business analysts with detailed information about new gas and electric installations:  New Installs (With Device) Report  New Installs (Without Device) Report  New Installs Move-In Versus Installation Date Discrepancy Report In order to access these new infoProviders, select Utilities/Customer Care & Service from the BISC Online Access Request Form on CPSConnect. Detailed documentation can be found on the BI Information Portal via CPSConnect >>Shared Services>>Information and Communication Services (ICS) >>Business Intelligence>>What is available>>Customer Care & Service – What reports are available? or by viewing the lunch & learn presentation on I-Grid under ICS-EAD Resource Page . HR SUPPORT PACKS AND SPK7 UPGRADES In order to be compliant with regulatory regulations, HR support pack 27 contained new IRS tax forms. Support Pack 27, SAP required SPK5 to accomplish this task. BW/BI required SPK7 in order to work properly. A decision was made to go up to SPK 7 which affected BASIS and ABAP objects. This required testing of all SAP modules to make sure everything worked properly due to SPK7 which contained ABAP and Basis object changes. Testing took place in Client SS1 November 15 – December 3rd. Testing was completed in clients QS1/DB11 by December 17th. We did have an SAP outage on December 17th @ 7:00 p.m. through December 18th @ 4:00pm. It has been 6 weeks since we upgraded SAP to SPK7 and applied the HR Support Packs with only few incidences. We would like to thank everyone who participated in testing, scheduling & cutover weekend to accomplish this task by the due date. SYSTEM STABILIZATION – ongoing maintenance objectives. Application of Support Packs annually involving the regression testing of ECC extractors, BW data loads and Business Objects connections. AUTOMATION TESTING SUITE. To implement an automated suite of testing scripts to increase the speed of support pack applications and system upgrades annually. This project was an independently run project specific to my team. A suite of manual test scripts were created across all areas of the BW and BObj systems and upon my leaving, the scripts were yet to be recorded in the Test Director suite software. BW SECURITY AND BOBJ SECURITY This project required the new implementation of BW Analysis Authorization objects, down to infoObject levels defined by Controlling Area, Cost Center and Organizational Unit. Employee Level security was assessed for employee self-service portal reports in addition to leveraging Business Objects security for report/business unit assignments. An integrated strategy on the BI concepts was in progress upon leaving the company with the introduction to SAP Hana. Reports were also secured at the infoArea, InfoCube and report level. CRYSTAL MIGRATION PROJECT The Crystal Migration Project completed successfully in October. Over 2400 Crystal reports were migrated to the upgraded environment, and the new Crystal 2008 client software has been loaded
on over 85 PCs. A new three-tiered landscape for Business Objects was introduced to users and report security has been enhanced. We have already experienced some positive benefits from the new Business Objects systems, particularly around reliability. One of our application servers went down during the storm, but still Business Objects system remained operational. This was due to our new load balancing design. Our other application server managed the traffic and no system outage was experienced by our customers.