SAP Support for Enterprise Reporting Solution, PennDOT
Overview
The Pennsylvania Department of Transportation (PennDOT) is responsible for a wide range of services that relate to transportation in the state of Pennsylvania. PennDOT is responsible for the upkeep of Pennsylvania's roadways which includes about 41,000 miles of state roads and over 25,000 bridges in the state. In addition to the state's roadway system, PennDOT is responsible for supporting the following aviation, rail traffic, mass transit, intrastate highway shipping traffic, motor vehicle safety & licensing, and driver licensing. PennDOT also supports the Ports of Philadelphia, Pittsburgh, and Erie.
PennDOT is also responsible for vehicle titles and registration of those vehicles and issuing drivers licenses to Pennsylvania citizens. The registration and titles are handled by private and this result in Pennsylvania is the only state to separate motor vehicle offices from its driver license centers. Driver license centers are all run and owned by PennDOT, unlike motor vehicle offices which are strictly run and controlled by PennDOT however they are privately owned and located across the state.
Project Scope
The Pennsylvania Department of Transportation (PennDOT) required an SAP support expertise on all facets of Enterprise Reporting Solution to augment the collaboration between all the stakeholders in their work to find and address key infrastructure requirements, including SAP Business Objects XI3.1/ Crystal Reports 2008 and SAP Business Intelligence 4.1/ Crystal Reports 2013.
Solution
The objective of the project included support on all facets of Enterprise Reporting Solution for achieving the desired business results. To optimize the specific tasks and operations, this project was planned and implemented in line with the support required to effectively consolidate and manage and navigate the infrastructure environment with ease. The Work Breakdown Structure (WBS) for this project included several critical aspects such as gathering the proper assessment of all the needs for augmenting all facets of Enterprise Reporting Solution across the entire business landscape.
Starting with supporting all facets of Enterprise Reporting solution including maintenance of Microsoft Server 2008R2 and 2012R2 and managing application environment including structures and security. V Group successfully supported the department by leading upfront in providing critical technical support associated with server operation and maintenance. We supported the client in data source connections on servers (Oracle, MSSQL, DB2, etc.) and making recommendations to supervisors regarding hardware and software upgrades, and maintenance contract issues, as and when they were needed. We also worked closely with the users to manage report object and historical instances (failed and successful) and helped in purging unused objects. With our smart approach, we performed system maintenance, providing system governance oversight, as and when it occurred.
In addition, the support activities provided by us that have contributed to the success of the Enterprise Reporting Solution include: A thorough Research (along with the development team) on the latest trends in SAP reporting suite of products, providing recommendations to the client was done. Monitored solution status by performing regular checks throughout the day and then provided periodic reviews on failed instances and investigated the issues.
Assisted users with “Best Practices” for the reporting solution and help in troubleshooting the related issues with the solution. Helped them in solution version management, including service pack, fix pack, and hotfix testing and installation to become the solution of choice to meet a range of reporting requirements across the enterprise. As demand for access to data and info upsurges, we added new dimensions to reporting needs and helped the client to grow and expand. Served as a liaison between the Agency and solution’s contract and helped the client in streamlining the workflow and provided them with greater flexibility to meet their data needs to reduce support overhead.