Project 1:
Title: MS CRM 2015 IN KENT
Team Size 3
Tools /Technology: SSIS, SSRS, POWER BI, SQL Server 2012, C#, ASP.Net, MS CRM 2015.
Role/Responsibilities :
• Created Databases, Tables, T-SQL Stored Procedures, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, and Cursors.
• Extracting huge data from different systems by writing Stored Procedures and ETL jobs.
• Creating Check Points and Break Points to trace package errors using SSIS.
• Created event handlers per the package using the event handler tab.
• Deployment and Scheduling of ETL packages.
• Saving the log information in a Text file to track Errors and record package execution status.
• Developing various business reports using SSRS.
Description: Microsoft Dynamics CRM is a customer relationship management software package developed by Microsoft focusing on enhancing customer relationships for any organization. It is one of the leading industry standard CRM software available in the market. Out of the box, the product focuses mainly on the Sales, Marketing, and Customer Service sectors, but Microsoft has been marketing Dynamics CRM as an XRM platform and has been encouraging partners to use its proprietary (.NET based) framework to customize it. There are 40 reports which help the management to know about their
business across different Line of Business (LOB), the reports are developed using SQL 2012(SSRS).