Arghya Sen Email and Phone Number

⮚ Building centralized Data Warehouse for Enterprise Functions Control⮚ Design, Develop & Deploy a one-stop-shop for viewing the results of all metrics and assessments for Enterprise Functions Operational Risk⮚ Analysis of the requirement provided by the business and transforming them in to functional and technical specification⮚ Involved in development, performance tuning, testing and deploying ETL Packages using MS SQL, SSIS & Alteryx

⮚ Designed centralized data model for overall Pipeline and also dashboard using different sheet objects for the management⮚ Involved in migrating sales data from SQL Server environment to EDH⮚ Implemented numerous components as part of an end-to-end BI Solutions including data mart, ETL design and SQL queries, also implemented jobs and scheduling them as per business needs⮚ Involved in Onsite-Offsite coordination in delivering Business Intelligence Solution⮚ Automation of different excel reports in Qlik Sense to have a proper view of data which must be analyzed

⮚ Understanding of requirement and use cases for the business⮚ Planning and management with proper estimation of effort⮚ To ingest new contents in the Data warehouse and working on CRs and enhancements of existing contents⮚ Automation and Optimization of existing legacy system

⮚ Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions and stored procedures⮚ Successfully migrated data from different sources systems such as flat file, Excel and SQL Server 2008R2 using SSIS⮚ Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job⮚ Deployed database structure and SSIS Package into Production, also used Package configuration to export various package properties to make package environment independent⮚ Identified the bottlenecks (in sources, targets, and packages) and tuning it