We worked on the Land Data Warehouse project with BP. As its technology partner, we ensured streamlining of its processes and operations using SAP and its related software.
We helped gather user requirements, design technical solutions, and develop technical documentation that was crucial to making judgments on architectural tradeoffs between the competing operational/non-functional needs of the system. A big process was to convert SAP BW BI reports into the new version of SAP Bi business Objects Xi3 Reporting module by installing and using NetWeaver and Rapid Mart. Our team was responsible for extracting data from SAP SCM/SRM through SAP BW/BI warehouse.
We effectively modeled, presented, and communicated software design to various project interest groups comprising both technical and non-technical individuals. Our experts led the efforts of designing and implementing the Enterprise Business Objects deployment that supported business units across the firm as well as the Client Access Reporting System. The deployments consisted of over 8 Workflows, 20 Universes, 80 reports, and 2,000 users. Another deployment done was that of Xcelsius Engage 2008 Dashboard solutions for the Property ID workflows module.
Our team was actively involved in the design and construction of data marts and data warehouses across the firm. When it came to making the complex systems simple, we installed and configured SAP BOBJ Rapid Mart of SAP FICO, SAP SD, and SAP MM by using SAP Business Objects Data Services Xi3.2. We were also responsible for customizing SAP BOBJ predefined Data Mart, Universe, and Webi reports for SAP FICO, SAP SD, and SAP MM modules. Our team designed, developed, and coded with ORACLE 10g and Teradata 12, along with customizing Teradata database LOVs in Universes for a quicker performance of reports. We translated business requirements into dimensional and physical data models for an OLAP reporting environment. We turned to technical documentation to provide inputs to the ETL team on the data model.
We were entrusted with the task of streamlining the reports, so, we designed, built, and published a set of Webi reports and Xcelsius Engage 2008 dashboard with interactive analytical capabilities associated with Land. We designed reports using Sections, Combined queries, Sub-queries, Calculation contexts, group by commands, User-defined objects, Report folding, and Calculation in crosstabs. We used @Functions such as @Prompt to restrict return values and to enter prompt and @Select to reuse the select statement of another object. Our experts created Joins, Contexts, and Aliases for resolving loops and checked the integrity of the Universes. To ensure proper functioning thereon, we trained a selected group of BP analysts as power-users for using the new reporting capabilities.