About Me
4 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of larger and complex Data Warehousing and Data Integration Solutions using Informatica Powercenter and OBIEE. Worked on two end to end implementation proj...
Show MoreSkills
Positions
Portfolio Projects
Description
C3PI (Customer Channel Contract Performance Inside): C3PI provides scalable solution which helps to deliver critical insights to managed customer care operations to support business decisions. C3PI is designed to maintain information about customer, channels and their contract with end users with Genentech. Spear is created to validate the data that is provided to Genentech by different senders. This system also gives insights about different measures related to senders and patients.
Show More Show LessDescription
The Operational Data Store (ODS) is built to collate heterogeneous data from various sources like CRM, OBRM, DMS, Portal, USSD, Interconnect, and Mediation. Data obtained from CRM, OBRM, DMS and Portal sources are relational databases (oracle) and for USSD and Mediation, the sources are Flat files or Comma Separated Values (CSVs). The data is extracted, transformed and loaded into Operational Data Store with data integration tool Informatica Power center. The required business rules are applied at data integration and Reporting layers. The data from ODS caters to the reporting requirements with OBIEE reports and dashboards. These reports can be customized as per user requirements.
Show More Show Less
+1 646 305 2118
+91 9875 492266
