Dow Jones Risk and Compliance (DJRC) is a comprehensive, up-to-date database to the identities of government officials, politicians and people of political influence and their associates in every country of the world that provides a comprehensive response to international financial regulations on Politically Exposed Persons(PEPs) and sanctioned individuals and entities. This product contains three modules Editorial Interface, User Interface and Feeds. The EI interface of the application enables editors of the system to update the database. And the UI interface of the application enables end user of the application to search the database of the application along with this additional functionality like news search. Tech Mahindra(TechM) provides IT solutions for the Dow Joness innovative, XML-based and Web services-enabled technology platform, which provides access to this rich content collection via Dow Joness role-specific products – Watch list, Sanction Alerts, Anti-Corrupt

Scotiabank utilizes resources like Sever Space, Network, Tapes, CDs of IBM for their business activities. IBM charges amount from Scotiabank for utilization of their resources on monthly basis. Charges will be divided on the basis of branches and their utilization. The scope of the project is to provide the entire support and maintenance to the applications and Databases being used by various business units and IT within Sotiabank. The project involves enhancements, bug fixing and operational tasks. The requests differ in the nature like extracting and transforming data from different data providers (SSIS), preparing fresh reports (SSRS, Crystal Reports) and web application support (.Net, ASP).

Blue Cross and Blue Shield of Louisiana is a major Health Care provider in Louisiana state, US with aim to improve the lives of Louisianans by providing health guidance and affordable access to quality care. The Health Care major is improving the lives of Louisianans by improving the quality and affordability of the health guidance and healthcare they receive and empowering their members in personal health management. It provides comprehensive, customized health care management solutions that increase practice efficiencies and enhance the quality of patient care. By partnering with the leading specialty therapeutic practices across the state, BCBSLA connects physicians, patients, pharmaceutical companies, and payers to bring these practices new and innovative solutions to important business challenges—from practice efficiency and quality improvement programs to superior patient care solutions.

Westcon-Comstor is the leading global distributor of business technology prodcuts. Westcon working as reseller for the manufacturers like Mitel, Audiocodes, CISCO, Microsoft, Avaya, Juniper and Check Point etc. Westcon use to send POS files to the vendors on daily, weekly and monthly basis as per manufacturer requirement. Westcon will generate the revenue on the sales which they performed on manufacturer products.

CBRE has many separate databases systems across the business. Bringing this separate information together into one data access point allows the company to leverage all CBRE information for countless objectives. The Enterprise Data Platform (EDP) consolidates this data from multiple sources to provide a unified and trusted view of this data set. EDP processes this source data through a transformation process where it is matched, merged and verified.

Ciscoisone of the Global Market Leaders in manufacturing of network equipment. Cisco maintains its own Data Warehouse. All the transactions performed by customers are recorded in oracle systems whichisOLTP data. Using Informatica data from Oracleismigrated to Teradata using Teradata SQL queries. Dataismainly classified under 3 streams: Bookings, Finance and Sales. I majorly dealt with Finance and Bookings streams which are core part of CISCO.

This project mainly aims to develop a best- in-class Enterprise Data Warehouse (EDW) solution which is robust and scalable to address the current and future information needs of GB. The project involves building a new Enterprise Data Warehouse (EDW) and Data Marts, which would be loaded addressing the existing EDW and source data Transformation concerns. Building a Common Integration Framework to integrate data into the new normalized EDW and the dimensional data marts. Transform the extracted data by cleansing, validating, de-duplicating the data against the identified business cleansing rules and derive the Master Data into MDM database. Load the cleansed data into the EDW and downstream the data into the respective data marts.