Senthilkumar Kandasamy Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

Bangalore

Project Title : AGS Integration Assured Guaranty FG AMO.Client : Assured GuarantyEnvironment : SQL Server 2016, SSIS, SSRS, SSASDescription : Assured Guaranty is the leading provider of financial guaranty insurance. Assured Guaranty guarantee’sscheduled principal and interest payments when due on municipal, public infrastructure and structured financings.Assured has been spending significant effort and resources in modernizing their existing application infrastructure primarily inDW/BI area since late 2012. Assured has taken up the herculean effort of re-design and develop a new Microsoft DW/BI stackmoving away from the current 25-year-old legacy application Web FOCUSRoles & Responsibilities:• Analyze the source map documents and creating packages to move the data from source to destination.• Development of mappings according to the ETL specifications for the staging area data load & warehouse data loadusing Integration Services.• Actively involving in discussions with clients/business team to gather requirements.• Designing and developing packages according to the ETL Specifications using integration Services (SSIS) and SQLSERVER 2008R2.• Creating and maintaining databases, tables, views, indexes, check constraints, CTE using T-SQL.• Designing and development of the SSAS cubes and MDX queries.• Involving in the SSAS storage, partitions, Aggregations, calculation of queries with MDX, Data Mining Models,developing reports using MDX and SQL Server objects.• Creating tabular, matrix, chart and sub reports in SSRS. Writing stored procedures and functions to create SSRS reports.• Developing all the reports as outlined in the business requirements document.• Responsible for Build and Deployments using Azure DevOps and Octopus.• Managing SQL Server Databases as Visual Studio Projects (SQL Server Data Tools) and deploying databases acrossenvironments using Octopus.

Bangalore

Project : Project Title : Drishti Reporting Portal.Client : Mercedes Benz Environment : SQL Server 2016, SSIS, SSRS, Power BIDescription : The main objective of this module is to load the data from the source to data warehouse. The Business logic is provided by the client and the same is implemented using SSIS in ETL process. The data will be extracted from a share folder having the collection of input excel spreadsheets and loaded to staging tables in SQL Server 2016. The transformations are applied on the Staging tables. Finally the data is integrated and loaded to Counterparty Data Warehouse tables by ETL mappings. Reports are created using SSRS and Power BI from data warehouse.Roles & Responsibilities:Analyze the source map documents and creating packages to move the data from source to destination.Development of mappings according to the ETL specifications for the staging area data load & warehouse data load using Integration Services.Creating packages for implementing ETL by using various control flow items for each loop, for loop and data Flow transformations execute SQL, conditional split, multicast, derived column, lookup, sort, union all etc. Writing stored procedures which meet the requirements.Designing the SSRS and Power BI reports based on Report Specification document. Deploying the generated reports on production server.Also, prepared documentation for the generated reportsInvolved in creating reports for Business analysis process

Bangalore

Project Title : Rankin county hospitalClient : GRM document management.Environment : SQL Server 2014, Power BI Description: This web portal had various modules like Provider Enrollment, Claims Management System and Financial Management to enroll Provider, process claims/invoices and claim settlement to Providers/Customers.Product Features:Provider EnrollmentPrescriptions and Referrals Health Insurance ClaimFinancial Management SystemRoles & Responsibilities:Primarily responsible for queries and extracts of member claims and provider data.Responsible for design and development of analysis and reporting of claim, providers, authorization, members, financials, and clinical data using SQL server tools, statistics, and analytical techniques to fully understanding and trend the efficacy of the report.Experience with data quality control, data manipulation and electronic health records.Responsible for monitor and audit data quality.Analyzing of data historical trends, forecasting data reports and deviations for referential integrity.Prepared Dashboard reports for the various initiatives implemented by the organization

Bangalore

Project1Project Title : Wipro Furniture Order BookClient : WiproEnvironment : SQL Server 2012, SSIS, SSRSDescription : Automating the manual entry process to an online system which enables the authorized users to login, and update the order details as needed. Project and order information is sync from LEAP and SAP system in a daily basis which to be updated by business users to track the status. Developed various BI reports.Project 2: Project Title : AZM Reporting PortalClient : Odyseaaquarium, Detroit zoological society, Newseum, USS Midway.Environment : SQL Server 2012/2014/2016, SSRS,Power BIDescription : Developed various BI reports. Use to tie up with the Galaxy ticketing system and based on their DB structure will create a BI Reports to improve the client business. This applications is developed for both Mobile application and desktop web application.Project 3: Project Title : Wipro Furniture Order BookClient : WiproEnvironment : SQL Server 2012, SSIS, SSRSDescription : Automating the manual entry process to an online system which enables the authorized users to login, and update the order details as needed. Project and order information is sync from LEAP and SAP system in a daily basis which to be updated by business users to track the status. Developed various BI reports.

India

Project 1Project Title : Employee Login SurveyClient : Bajaj Allianz.Environment : SQL Server 2008, SSIS, SSRS 2008R2Description : The main objective of this module is to load the data from the source to data warehouse. The Business logic is provided by the client and the same is implemented using SSIS in ETL process. The data will be extracted from a share folder having the collection of input excel spreadsheets and loaded to staging tables in SQL Server 2008. Data is also loaded from the user input from the web application. This survey is done mainly to know about employee’s satisfaction in the company and share their views and thoughts. Through this application a mail will be sent automatically to the employee’s company id with login URL, user id and password. Through which the employee login to survey and give their ratings. The transformations are applied on the Staging tables. Finally the data is integrated and loaded to Counterparty Data Warehouse tables by ETL mappings. Reports are created using SSRS from data warehouse.Project2Project Title : Maplin’s Electronics, UKClient : Cube soft techEnvironment : SQL Server 2008, SSIS 2008R2, SSRS 2008R2Description : Marks & Spencer is the one of the largest electronics store in UK with many sales and distribution centers all over UK. Marks & Spencer businesses include different Electronics goods like Music Entertainment, Pictures Entertainment, Broadband Entertainment, Computer Entertainment and many others. All over U.K there are more than 300 sales and distribution centers with more than 36000 employees. Marks & Spencer annual turnover is around 1.8 billion pounds, there are different branches allover UK, data from different branches are extracted, transformed into common format and loaded into common warehouse.