Client:
Working with a client which takes apioneering approach to the design of ouradvanced medical products and
services , by securing wider access to our diverse technologies for more customers globally, and by enabling better
outcomes for patients and healthcare systems.
Project Profile:
The embedded reporting can no longer support the required increasingly large data sets nor the frequency at which
reporting is required without impacting the transactional complaint handling. This introduces delays to the
transactional complaint handling lowering the efficiency and endangers compliance with global requirements for
complaint management and 60 day target for complaint closure. At the same time, it negatively impacts stakeholders
relying on complaint data as access to the embedded reporting had to be disabled to ensure a stable system for
transactional complaint handling.

Page 3 of 7

The embedded reporting tool cannot deliver all reports that are required. This has led to issues in FDA audits where
the client was unable to deliver the required data within the expected time-frame to the investigator, and particular
required fields could not be delivered as requested.
The complaint analytics solution shall resolve the issues coming from large data sets, and de-coupling of the
analytics from the transactional database shall eliminate the impact of reporting on transactional complaint handling.
Furthermore, as a result, it will be possible to re-enable stakeholder’s access to complaint analytics reporting. The
solution shall have the option of drag and drop to create ad hoc reports, e.g. needed at an FDA audit to deliver
exactly what is requested by the inspector and within the required time-frame.

Key Responsibilities:
 Developing the sample reports as the requirements given.
 Developing the Reports/Dashboards in the Cognos Environment, and testing the reports against the
database.
 Effectively coordinating with the onsite team to migrate or implement the project from the Dev
environment to the Stage.
 Communicating effectively with the team.
Technical Environment: Cognos 10.2.2, Oracle SQL Server

Client:
Working with a leading Health Care company, which develops, manufactures & markets the medical products and
healthcare services that focuses on critical therapies for life threatening and acute medical conditions.
Project Profile:
This Project is about client consolidating its ERPs down to 4 regional and 1 Bioscience manufacturing JD Edwards’s
instances. An effective Business Intelligence (BI) environment is needed to help realize the benefits from the ERP
consolidation effort. Therefore, the BI Strategy Project is an integrated component of the ERP Consolidation
Project.
Even though the BI Strategy is focused on the requirements of ERP (Finance and Supply Chain), we have taken a
broader, more holistic approach to the scope of the project.
The purpose of this project is to communicate high-level guiding principles that will steer future developmental
phases to the desired end-state
Key Responsibilities:
 Developing the test cases and testing the reports against the database.
 Effectively coordinating with the onsite and client team to migrate or implement the project from the Dev
environment to the Stage and finally to the Production and supporting the system.
 Communicating effectively with the team.
Technical Environment: Cognos 10.2.1, SQL Server

Client Description: Client was in the Health Care Sector
Project Description: The project’s aim is to implement BI solution and create set of reports that helps in gathering
data for Life sciences. Commonly known as SAINT project, is a set of reports that will help users to retrieve the data
based on the technical spec documents provided. SIANT creates report as per the design document and implements
the same set of reports in the Dashboard form using the Data Visualization tool Spotfire.
Key Responsibilities:
 Creating a systemic document for upcoming project to analyze columns in each report, their description,
their availability in the current data warehouse and their association with respective dimension and fact
tables.
 Creating/Developing Cognos reports through the use of both Relational and Dimensional designed
packages.
 Analyze the reports, test them and see the areas where time to execute the reports can be improved i.e.
finding the gaps to improve report performance.
 Learn new technologies like Business objects.
 Development of Dashboards in Spotfire
Technical Environment: Cognos 10.2 BI Report Studio, Framework Manager and Oracle, Spotfire