Case Studies - ERP Staffing

CANADIAN PACIFIC RAILWAY

Canadian Pacific Railway (CPR) is an internationally renowned transportation company headquartered in Calgary, Alberta. Since 1881, this company has significantly impacted Canada development and growth. CPR is a significant global player in transportation and logistics, with an expansive network of lines stretching across roughly 20,100 kilometers (12,500 miles) in seven Canadian and American provinces. CP Rail or Canadian Pacific are some commonly used abbreviations for CPR.

Due to its extensive activities, CPR encountered obstacles in maintaining effective coordination between its components and optimizing its operations. ERP Consulting played a crucial role in putting in place a system vital to the company and assuring systematic cooperation across all the components and the principles driving the design and implementation to meet these problems. The ERP Consulting team created the Enterprise Logical Data Model (LDM), supervised JAD sessions to identify data rules, and conducted LDM reviews with Data Subject Matter Experts (SMEs). These initiatives allowed the team to create a complete system matching CPR requirement and streamlined the organization’s operations. ERP Consulting also generated detailed reports with SAP BEx capabilities in SAP BI 7.0 and SAP BW 3.5, such as Query Designer, Analyzer, and Web Application Designer. This method enabled CPR to apply client standards across the system, verify models into and out of the model repository, and record data model translation choices. To further technical improvements, ERP Consulting built and integrated SAP BOBI 4.1 design studio dashboard for iPad/mobile users from SAP HANA, SAP BW, and BOBI 4.1 universe data sources. This method assisted CPR in evaluating architectural compromises between opposing operational and non-functional system requirements. In addition, the ERP Consulting team migrated 50,000 SAP and SAP BO Xi3.1 content users to SAP BOBI 4.1, BI cloud, and Vblock, setting and maintaining security group content in BOBI 4.0, BOBI 4.1, and Xi3.1. Another critical responsibility we fulfilled was migrating 50k users of SAP and SAP BO Xi3.1 content to SAP BOBI 4.1, BI cloud, and Vblock. Our team successfully configured and managed security group content in BOBI 4.0, BOBI 4.1, and Xi3.1. The company entrusted us with gathering user requirements, designing technical solutions, and developing technical documentation. Taking the technological advancements to the next level, we installed BOBI 4.0, Mobile 4.0, and Explorer 4.0 on Windows 2008 64-bit environment and the Virtual server SAP Cloud. Our team also designed and configured Windows AD (SSO) at CP. ERP Consulting was assigned to the collection of user requirements, the implementation of technological solutions, and the creation of technical documentation. BOBI 4.0, Mobile 4.0, and Explorer 4.0 were all delivered on a Windows 2008 64-bit environment, also used for the SAP Cloud Virtual server. Besides that, the team developed and integrated Windows AD (SSO) at CP. ERP Consulting provided CPR with a comprehensive system, which streamlined the organization’s operations and enabled them to make more informed decisions based on examining the data. The team developed a set of Webi reports and dashboards with interactive analytical capabilities related to the SAP ECC 6 and SAP BW modules. These reports and dashboards were generated using and delivered using reporting and dashboard services to integrate SAP ECC, SAP BW, and Bex Queries. By integrating Business Objects Enterprise (BOE) with Business Warehouse (BW) and Enterprise Portal, ERP Consulting was able to improve the performance of the environments that employ Business Objects Enterprise (BOE). The team was responsible for diagnosing and adjusting the CMS and server tuning settings for BOBI 4.0 and Xi3.1 environments. This ensured the system operated efficiently and provided CPR with the information it needed to make intelligent decisions.

CAMECO, SASKATCHEWAN, CANADA

Cameco produces uranium fuel for clean air. Their nuclear fuel products produce clean, secure energy for utilities worldwide. They are addressing the rising need for sustainable baseload electricity and promoting the pursuit of net-zero aspirations. They possess interests in top-tier mining and milling facilities that can produce over 30 million pounds of uranium concentrate per year and have over 469 million pounds of proven and probable mineral reserves. They are also an industry leader in uranium refinement, conversion, and fuel production.

The firm is conventionally known to have the knowledge and experience required to mine, process, and convert uranium into a form that expertise can use in nuclear power reactors. We can subsequently accomplish this modification with success. The effective management and analysis of Cameco’s environmental compliance data presented several hurdles for the company. The organization needed to undergo a technological transformation of its systems and procedures to achieve optimal performance in its business operations. In addition, they had to move their Business Objects platform from one environment to another while maintaining timely report publishing and managing their timetable. For Cameco to accomplish these goals, the company sought the assistance of ERP Consulting, a prominent organization in technology consulting. Working with one of the world’s largest uranium producers, ERP Consulting led the technological transformation of systems and processes at Cameco and majorly worked in environmental compliance analytics. Our team of experts designed and deployed two complex universes for Dashboard and Webi report requirements built Xcelsius 2008 Dashboard solutions on Dashboard Builder with interactive analytical capabilities and published Webi reports. We connected difficult SAP Web Intelligence reports to Bex queries SAP BW/NetWeaver 7.0 environments. Also, our expert team designed BI reporting solutions leveraging the full suite of applications, including Web Intelligence, Designer, Xcelsius, and Dashboard. ERP Consulting implemented the best practices for business Objects migrations from the environment to environment and managed migrations in Lifecycle Manager (LCM). We successfully installed BOBI 4.0, 3.1, Mobile 4.0, and Explorer 4.0 on Windows 2008 64-bit environment and Virtual server (VMware). We successfully configured and administered security groups & content and handled troubleshooting/tuning the CMS and server tuning parameters for BOBI 4.0 and Xi3.1. We optimized the performance of the enterprise Business Objects environments for Cameco and quickly diagnosed and resolved problems related to web servers, application servers, and BI web applications. Another critical mission we completed was administering the platform performance monitoring for Business Objects while collaborating with infrastructure groups to give platform availability data. We also ensured the timely publication of reports and schedules.

SERVICE ALBERTA, CANADA

Service Alberta is a government agency responsible for delivering services including information management services, land titles, consumer protection, and vital statistics. The agency saw the need to upgrade its services and proceeded on a project to develop a new reporting architecture based on Business Objects. The agency also moved SAP BO Xi3.1 material to SAP BOBI 4.0 SP2 and BI Cloud. Since the project was complicated and needed extensive knowledge, the agency recruited the assistance of ERP Consulting to give support throughout the implementation process, assuring its success.

ERP Consulting was tasked with deploying a new reporting infrastructure based on Business Objects (BO) and transferring SAP BO Xi3.1 information to SAP BOBI 4.0 SP2 and BI Cloud. The team had to verify that existing and new objects were validated correctly, establish and manage security groups and content, troubleshoot and adjust the CMS and server tuning settings, and alter Universe objects to represent the appropriate logic and meaning of the words. They also had to create and install big Universes to serve a BO reporting environment with a significant, sophisticated database source. The team also provided production support for the BMC ITSM and SAP BOBJ ad hoc reporting, ensuring smooth operations and rapidly resolving problems. The project required a significant amount of expertise and attention to detail. The team exhibited their ability to promptly identify and address web server, application server, and BI web application issues. They also discussed technological issues, procedures, and solutions with business users. Overall, ERP Consulting handled the challenging project effectively, giving vital assistance to ensure the project’s success. An integral part of the transition was to migrate SAP BO Xi3.1 content to SAP BOBI 4.0 SP2 and BI Cloud. Our team efficiently established the reporting test criteria and test plan for the new Universe while demonstrating expertise in supporting SQL Server 2005/2008r2 and SQL Server DBA in a large complex environment. We designed and deployed large Universes to support a BO reporting environment and ensured proper usage of the BO toolset with a significant, complex database source. We identified and communicated technical problems, processes, and solutions with business users. Our team continuously provided the BMC ITSM and SAP BOBJ ad hoc reporting production support for seamless processes. ERP Consulting witnessed the transition of Service Alberta as it implemented a new Reporting infrastructure based on Business Objects (BO) that linked to an ITSM version 7.1 databases on SQL Server 2005. Our team spearheaded the validation of old and new objects to ensure proper tables and joins were employed for the new 7.6 databases. We set up the new Universe to point to a static ITSM test environment and data to provide a pre-implementation testing platform. We handled key responsibilities of configuring, administering security groups & content, and troubleshooting/tuning the CMS and server tuning parameters for the BOBI 4.0 and Xi3.1 environments. In the Business Objects Enterprise environments, our experts demonstrated impeccable ability to quickly diagnose and resolve problems related to web servers, application servers, and BI web applications. We modified the Universe objects that relied on changed usage data elements to ensure that they reflect the proper logic and meaning of the terms.

ALLIANZ GLOBAL INVESTORS, NYC, NY

Allianz Global Investors of America is a famous asset management firm in the United States. Being a key player in the financial industry, it had to ensure that its procedures and systems were optimized to provide the best quality of client service. Yet, they encountered several obstacles that made their endeavor challenging. The organization struggled with reporting and dashboard needs. They needed SAP skills to create complicated Universes for reporting. They also needed interactive analytical Xcelsius 2008 Dashboard solutions to provide customers with investment information.

The organization also has server management and software upgrading issues. They had to install and operate many servers for AGI and its subsidiary PIMCO, which required a specialist understanding of client environment hardware and software architecture. Software updates in Win 2008 servers and Unix environments were complicated and time-consuming. The organization also struggled with SAP BW/NetWeaver 7.0 connectivity. These setups need SAP technical skills to integrate SAP Web Intelligence information into Bex queries. They also needed to install and configure BOBI 4.0, 3.1, Mobile 4.0, and Explorer 4.0 and configure and manage security groups and content in BOBI and Xi3.1. We led the efforts to connect SAP Web Intelligence reports to Bex queries SAP BW/NetWeaver 7.0 environments. To make the processes seamless, we installed BOBI 4.0, 3.1, Mobile 4.0, and Explorer 4.0 on Windows 2008 64-bit environment and a Virtual server (VMware). We were responsible for configuring and administering security groups and content in BOBI 4.0 and Xi3.1. Our expert team designed and configured Windows AD (SSO) and handled troubleshooting/tuning the CMS and server tuning parameters for BOBI 4.0 and Xi3.1 environments. In the Business Objects Enterprise environments, our experts optimized its performance. They demonstrated impeccable ability to quickly diagnose and resolve problems related to web servers, application servers, and BI web applications. We designed BI reporting solutions leveraging a full suite of applications, including Web Intelligence, Designer, Xcelsius, and Dashboard. To ensure smooth processes, we implemented the best practices of business Objects migrations from the environment to the environment and managed migrations in Lifecycle Manager (LCM). ERP Consulting examined the company’s needs and issues before developing a complete solution. The team created three complicated Universes for Dashboard and Webi report needs, produced Xcelsius 2008 Dashboard solutions with interactive analytical capabilities on Dashboard Builder, and released a set of Webi reports. They also deployed and maintained servers for all their deployment efforts based on the architecture and design of the hardware and software inside the client settings. ERP Consulting oversaw the efforts to connect SAP Web Intelligence reports to Bex queries in SAP BW/NetWeaver 7.0 environments, as well as the installation of BOBI 4.0, 3.1, Mobile 4.0, and Explorer 4.0, as well as the configuration and administration of security groups and content in BOBI 4.0 and Xi3.1. ERP Consulting software updates in Windows 2008 servers and Unix settings, as well as built BI reporting solutions using a comprehensive array of tools such as Web Intelligence, Designer, Xcelsius, and Dashboard. They also established best practices for Business Objects migrations from one environment to another and migration management in Lifecycle Manager (LCM). While maintaining audit reports based on the Business Objects audit database and audit Universe, the team successfully handled Business Objects platform performance monitoring, established users and groups, and administered suitable custom access permissions. They also spearheaded the effort to provide a Disaster Recovery environment for Business Objects. ERP Consulting exhibited an exceptional ability to swiftly identify and address web server, application server, and BI web application difficulties.

SOLO CUP CHICAGO, IL, USA

Solo Cup is a well-known American firm that manufactures disposable drinking cups, plates, and bowls, among other consumer packaging goods. The organization must modify its enterprise resource planning (ERP) system to match its current business requirements during a transition period. Solo Cup had implemented an ERP system, SAP Business Objects Rapid Mart, to administer its e-business application. Regrettably, the organization had difficulties with its ETL operations, BO Universe, and Webi reports, which required customization to match its needs. Solo Cup hired an ERP consulting firm specializing in ad hoc reporting settings to handle these difficulties.

The consulting team was responsible for obtaining Solo Cup users’ needs for ETL tasks, Universe, and Webi reports. This needed a comprehensive knowledge of the organization’s business processes, systems, and data. The team collaborated extensively with Solo Cup’s stakeholders to determine their reporting requirements, data sources, and key performance indicators to develop custom ETL tasks, Universe, and Webi reports. Analyzing and optimizing BOBJ Universes in line with Solo Cup’s new business needs was a significant obstacle for the consulting group. They were responsible for ensuring that the reports had correct and pertinent data that could be utilized to make educated judgments. This needs a comprehensive grasp of the business operations and data of Solo Cup. The team carefully worked to debug, troubleshoot, optimize, and fine-tune the current ETL procedures. They simplified the reports to make them more efficient and user-friendly. They created, developed, and released a collection of web-based financial reports and Xcelsius dashboards with interactive analytical features related to GL accounts. Using Query as a Web Service (QAAWS), Webi, and Crystal Report Services, the consulting team developed and implemented a Crystal Xcelsius Dashboard with dimensional data connectivity. This enabled Solo Cup to easily access and analyze data from many sources, including its ERP system. The ERP consulting team encountered several obstacles throughout the project, including handling data from several sources and ensuring the reports’ integrity. Moreover, they had to guarantee that the reports were user-friendly and accessible. The team collaborated extensively with Solo Cup’s stakeholders to determine their reporting requirements and then crafted the reports appropriately. In addition to ensuring that the reports comply with regulatory requirements and industry standards, the consulting team had to ensure that the reports met all regulatory criteria. This requires an in-depth knowledge of the Solo Cup industry’s norms and standards. Solo Cup utilized the customized ERP system and data to make educated choices and optimize its business operations, resulting in the project’s success. The company’s access to precise and pertinent data enabled it to optimize its operations and enhance its financial performance. The experience of the ERP consulting team was critical to the project’s success. Its capacity to examine Solo Cup’s business processes and data and customize reports to match the company’s particular needs was critical in enhancing its operations. With the assistance of a professional ERP consulting team, Solo Cup was able to adapt its ERP system and optimize its reporting procedures to match its current business requirements. The consulting team’s expertise was essential for evaluating and adjusting BOBJ Universes, planning and constructing web-based financial reports and Xcelsius dashboards, and producing a Crystal Xcelsius Dashboard with a dimensional data link. The customized ERP system and reports assisted Solo Cup in making well-informed choices and enhancing its business operations, eventually increasing financial performance.

BRITISH PETROLEUM (BP), CALGARY, CANADA

BP is a massive oil and gas corporation that works in several nations around the globe. They have their headquarters in London, United Kingdom. They are engaged in various energy-related endeavors, including the discovery and extraction of oil and gas and its refinement and sale. They also provide consumers with sustainable energy solutions and other services. BP contracted with Calgary, a Canada-based ERP consulting firm, to assist with the Land Data Warehouse project. Using SAP and associated tools, the goal was to simplify BP’s procedures and operations.

The ERP consulting firm was responsible for a variety of responsibilities, including the collection of user requirements, the design of technological solutions, and the creation of technical documentation. To strike a balance between the operational and non-functional requirements of the system, they had to make architectural tradeoff judgments. Converting SAP BW BI reports to the latest version of the SAP Bi business Objects Xi3 Reporting module was one of the most critical tasks. This was accomplished via the installation and use of NetWeaver and Rapid Mart. The consulting team retrieved SAP SCM/SRM data using the SAP BW/BI warehouse. The ERP consulting firm efficiently modeled, presented, and conveyed software design to technical and non-technical project stakeholders. Its specialists directed the design and execution of the Enterprise Business Objects deployment that supported all of the company’s business divisions and the Client Access Reporting System. This deployment included over eight Workflows, twenty Universes, eighty reports, and two thousand users. Also, the consulting group implemented Xcelsius Engage 2008 Dashboard solutions for the Property ID processes module. The ERP consulting company was actively involved in designing and constructing data marts and warehouses across the firm. They installed and configured SAP BOBJ Rapid Mart of SAP FICO, SAP SD, and SAP MM, using SAP Business Objects Data Services Xi3.2. They customized SAP BOBJ predefined Data Mart, Universe, and Webi reports for SAP FICO, SD, and MM modules. The consulting team designed, developed, and coded with ORACLE 10g and Teradata 12 while customizing Teradata database LOVs in Universes for quicker report performance. BP contracted with Calgary, a Canada-based ERP consulting firm, to assist with the Land Data Warehouse project. Using SAP and associated tools, the goal was to simplify BP’s procedures and operations. The ERP consulting firm was responsible for a variety of responsibilities, including the collection of user requirements, the design of technological solutions, and the creation of technical documentation. To strike a balance between the operational and non-functional requirements of the system, they had to make architectural tradeoff judgments. Our team was actively involved in designing and constructing data marts and data warehouses across the firm. When making the complex systems simple, we installed and configured SAP BOBJ Rapid Mart of SAP FICO, SAP SD, and SAP MM 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 the 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, groups 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. The ERP consulting company was critical in streamlining BP’s processes and operations through its SAP and related software expertise. They provided solutions to various challenges, including converting reports, designing and implementing Enterprise Business Objects deployment, designing and constructing data marts and data warehouses, and creating reports with interactive analytical capabilities.

SHIRE PHARMACEUTICAL, CHESTER BROOK, PA

Shire Pharmaceuticals is a pharmaceutical business based in Chesterbrook, Pennsylvania. They focused on pharmaceutical product research & development, production, marketing, and advertising. They have been in the business industry for almost three decades and have a significant presence in over a hundred countries worldwide.

Shire Pharmaceuticals had a significant challenge establishing a comprehensive and effective financial business intelligence system by integrating data from diverse source systems (FBI). They needed a technological partner to help them with data warehouse approaches, Ralph Kimball’s dimensional modeling, ETL, OLAP, and report delivery methodology. The corporation is required to keep the source systems’ lowest level of detail while being able to respond to new business demands.

Shire Pharmaceuticals chose ERP Consulting as its technology partner to handle these difficulties. The team was responsible for translating high-level corporate KPI needs into functional/technical specifications, designing, developing, and deploying a data warehouse, and deploying reporting and Xcelsius dashboard services. The team wanted to merge General Ledger (GL) balances and accompanying journal data from SAP R3, Ross, and HFM sources into a reusable format that could be used for all future reporting needs utilizing Live Office XiR3.

The team designed, built, and delivered web-based financial reports and Xcelsius dashboards with interactive analytical features linked to GL actual. They developed standard Xcelsius 4.5 dashboard reports and analysis routes for Balance Sheets (BS), Profit and Loss (P&L), and Cash Flow analysis, including revenue and cost analysis based on GL data. To meet the business goals, the team built and deployed a Crystal Xcelsius dashboard with dimensional data connection utilizing Query as a Web Service (QAAWS) and Webi, Crystal Report Services.

The project was a success, and the team was able to develop solutions that satisfied the business goals of Shire Pharmaceutical. They also created performance indicators and ratios for BS and cash flows, allowing the organization to analyze its financial performance better. ERP Consulting’s solutions improved the company’s insight into its financial data, making it simpler to make informed business choices.

Shire Pharmaceuticals and ERP Consulting had a fruitful collaboration. Shire Pharmaceuticals was able to combine data from numerous source systems and construct a solid and effective financial business intelligence system due to ERP Consulting’s solutions. The capacity of the team to design, construct, and execute a data warehouse, as well as deploy reporting and Xcelsius dashboard services and generate web-based financial reports and Xcelsius dashboards, was vital to the project’s success. Shire Pharmaceuticals gained more insight into their financial data thanks to ERP Consulting’s solutions, making it simpler to make smarter business choices.

CREDIT SUISSE, NYC, NY

Credit Suisse is a multinational financial services corporation based in New York City, New York. They provide clients with worldwide investment banking, private banking, and asset management services. Credit Suisse collaborated with ERP Consulting to create a server installation request process and tracking system for their provisioning department as part of their technology transformation.

Credit Suisse faced an array of obstacles during its technical transformation. The requirement to create a server installation request procedure and tracking system for their provisioning department was one of the major obstacles. This required the organization to gather user requirements, design technological solutions, and develop technical documentation while balancing the system’s competing operational and non-functional demands. Another obstacle the organization encountered was debugging Business Objects difficulties and offering knowledge transfer to its employees. The technical nature of the project compelled the team to make significant architectural tradeoff judgments, which added layer of difficulty to the project.

Credit Suisse encountered logistical issues relating to project management, communication, team coordination, and technological challenges. Close collaboration between the ERP Consulting team and Credit Suisse personnel was necessary for the project’s success, and excellent communication and project management were vital. Despite these obstacles, Credit Suisse overcame them with the assistance of ERP Consulting, effectively transforming its system and operations.

Our team was integral in gathering user requirements, designing technical solutions, and developing technical documentation. We were responsible for making judgments on architectural tradeoffs between competing operational/non-functional needs of the system and troubleshooting Business Objects issues and knowledge transfer to client staff. We defined, designed, and implemented logical and physical data models for Enterprise reporting and portal applications to streamline the processes. Solutions were provided for different phases of the project life cycle, data profiling, data analysis, data warehouse methodology, data management, and report application development.

Another primary task we fulfilled was designing and deploying universes for end user’s ad GIC and corporate reporting, Dashboard reports, and KPI reports requirements. To make things better organized, our team developed various drive tables to resolve complex business rules. We created joins, contexts, and aliases for determining loops and checked the integrity of the Universes. BO reports were easily accessible through queries, cross tabs, and master detail. At the same time, they were designed using sections, combined questions, sub-queries, calculation contexts, commands, user-defined objects report folding, and calculation in crosstabs.

We could transform the system and processes using BO ad hoc reporting capabilities. With the help of Business Objects’ ad hoc reporting capabilities, the team effectively altered the system and procedures. They created reports with sections, combined queries, sub-queries, calculation contexts, commands, user-defined objects, report folding, and crosstab calculation, making BO reports conveniently available through questions, cross tabs, and master-detail. Overall, ERP Consulting’s work with Credit Suisse aided the organization in streamlining procedures and providing better service to their clients.

DELTA DENTAL, PARSIPPANY, NJ

Delta Dental Washington is one of the largest dental benefits providers in the United States. They are annually covering 3.6 million patients across the state. As the technology evolved, they discovered that their present tools could not satisfy the needs of their constantly expanding knowledge base. Their earlier knowledge management expertise was highly segmented inside different departments. Its primary goal is to provide other people and families with high-quality dental treatment. However, managing a large client base and dental records may be challenging due to the number of patient data handled. To address this obstacle, Delta Dental intended to implement a digital customer record-keeping system to facilitate the processing of patient claims.

Delta Dental was confronted with two sorts of patient data: one that belonged to their network and the other that did not. Thus, the organization sought a solution that could efficiently manage both kinds of data and guarantee the efficient operation of the claims processing system.

To assist Delta Dental in overcoming these obstacles, our consultants performed an ERP consulting investigation to determine the optimal solution. We decided that utilizing Import Wizard to migrate the existing 122 reports from Business Objects 6.5 to Business Objects Xi2 and two Universes would be the optimal method.

The dental insurance company digitized the tracking and maintenance of customer records for seamless patient claim processing. Two types of patient data are handled – one that belongs to the Delta Dental network and the other that doesn’t belong to its network.

By deploying user-friendly technology, we led the transformational journey of Delta Dental and made all the processes for data tracking smooth.

While working with Delta Dental, our team of experts migrated 122 reports from Business Objects 6.5 to Business Objects Xi2 and two Universes by using Import Wizard. We developed 200 canned complexes and 150 ad hoc reports using Dski, Webi, and Voyager reporting components. The challenging task of developing many Voyager reports from Microsoft SQL Server 2005 OLAP Cubs was successfully accomplished by our team.

To simplify thing, we developed 50 drive tables to resolve complex business rules and created joins, contexts, and aliases to resolve loops. The integrity of the Universes was maintained regularly. We used @Functions such as @Prompt – to restrict return values and to enter prompt, @Select – to reuse the select statement of another object, and @Variable – to restrict the currently logged user. Our solution streamlined Delta Dental’s patient claim processing system and enabled them to provide quality dental care services to their customers.

CITIGROUP, WARREN, NJ

Citigroup is a multinational corporation that operates as an investment bank and provides a variety of financial services. The organization’s headquarters are situated in the city of New York. Citigroup is a global financial services company that offers a vast array of banking products and services. It works in over 160 countries and provides many funding solutions. This classification includes investment banking, wealth management, and consumer banking.

Citigroup needed help managing and reporting on its investment banking IT procedures. They needed to link processes using Business Objects and produce reports for users so that they could examine intelligence. In addition to this, they were required to transfer their current reporting systems onto the brand-new Business Objects Xir2 platform.

To resolve these issues, Citigroup partnered with a group of seasoned professionals to steer the technical improvement effort. The team installed and configured servers for Business Objects 6.5.1 and Business Objects Xir2 on separate computers to meet the development, testing, and production environment requirements. They also built over 100 corporate reports, more than 300 ad hoc reports, and four universes, all customized to meet Citigroup’s project financing and budgeting needs.

The team successfully connected Business Objects operations at Citigroup, enabling an integrated production environment for accessible reporting. In addition, we also migrated BO 6.1 and 6.5 and Crystal Reports versions 9 and 10 to the Business Objects Xir2 platform. Using Business Objects Xir2 CMC, the team formed many groups and empowered over 600 people by providing them with various rights and permissions. This was done so that customer data could be managed more effectively. Because of the team’s work, Citigroup was able to effortlessly report on the technological processes involved in their investment banking, which provided their users with helpful information.

PFIZER PHARMACEUTICAL, NYC

Pfizer Pharmaceutical, a well-known global biopharmaceutical company located in New York City, found various obstacles while attempting to connect its Safety Analytic and Metrics Management (SAMM) system with its existing system. It sought assistance in enhancing its performance and reporting its compliance to ensure that its safety processes and data met the requisite quality standards and adhered with the regulations.

The prestigious consulting firm ERP Consulting took the initiative and embraced the challenging responsibility of ensuring the success of the SAMM implementation project. Prior to developing a universe solution that met the needs of the reporting analysis, it was necessary to do an in-depth investigation of the company’s problems.

ERP Consulting’s competent and highly qualified experts used the Designer Module to activate the universe, merge tables, issue prompts and queries, and parse objects. The team then exported the universes to the repository so that users may have access to the resources there. ERP Consultancy contained several specified needs to enhance data organization for the 25 classes and 500 objects in the universe. Furthermore, they were helpful in overcoming obstacles such as “Chasm Traps” and “Fan Traps.”

ERP Consulting worked immaculately on aligning the Safety Analytic and Metrics Management (SAMM) system into Pfizer’s system for better performance and compliance reporting to ensure that the company’s safety processes and data meet the expected quality standards and comply with regulatory requirements. Spearheading the project of SAMM deployment, we analyzed business problems and planned the universe solution that satisfies the user needs and reporting analysis. Our experts extensively used the Designer Module to implement the universe, join the tables, create prompts and queries, and parse the objects. We also developed BO reports using queries, cross tabs, and master detail. All these initiatives were led by our team, and we witnessed the transition of Pfizer’s operations into more seamless processes and integrated solutions.

Using queries, cross tabs, and master-detail, the group developed BO reports. ERP Consulting oversaw each of these projects. As a result, Pfizer’s business processes were able to make a seamless shift to more linked systems and procedures.

Pfizer can now claim increased compliance with regulatory regulations, ensuring that data quality standards are fulfilled and ultimately providing its customers with a higher product or service due to the expertise offered by ERP Consulting.