Arkajeet Dasgupta

Experience

• 

  Infosys

  Jul 2007 - Oct 2010

  Senior Systems Engineer

  Worked as a junior developer in SQL Server and C#▪ Was a part of a team in charge of enhancements of 7 applications. Designed and developed table schemas, stored procedures for new modules that were created in the applications.▪ Received Spot Award from the Delivery Manager for repeated zero defect deliveries.▪ Developed 20+ reports in SSRS that replaced decommissioned Actuate reports.▪ Built multiple SSIS packages that generated Excel reports for team internal use that showed success rate of our production support team.▪ Performed Production support activities for the SQL Server and C# based applications.Environment: SQL Server Database 2005/2008, SSIS, SSRS, C# Show less

• 

  PwC India

  Oct 2010 - May 2013

  Senior Consultant

  Worked on SQL Server based back end databases and responsible for migration, design, building maintenance plans and ETL solutions for the application databases.▪ Built an entire application database from scratch. Replacing an obsolete application based on oracle and ASP. Including schema design, table partitioning, tempdb and maintenance task design.▪ Performed performance tuning for many application databases with index designing, partition/storage strategy. Tuned all procs and queries to achieve optimal plans.▪ ETL solution to transfer the data from the oracle database for one-time load of archived data as well as the daily incremental load that ran till the older application was decommissioned.▪ Built 20+ GB cube on an existing warehouse. Applied Usage based Aggregation design coupled with other essential dimensions to achieve near instantaneous query response.▪ Mentored three junior developers to become proficient in SQL Server Database and SSIS, who later became a part of our team.Environment: SQL Server Database 2008/2012, SSIS, SSAS (Multidimensional), SSRS, Oracle Database, C#. Show less

• 

  Cognizant

  May 2013 - Feb 2022

  Lead Architect

  Working as a database and business intelligence solution architect on-premise and on Azure cloud.Experience in designing/developing and supporting distributed systems for retail clients. Dedicated for providing optimized solutions for customers' business intelligence and reporting needs with the aid of cloud technologies including Azure SQL DB, Azure Synapse Analytics, Azure data factory, Azure Analysis services and more.▪ Remodeled a 10 TB+ data warehouse, that included structural rebuild of tables and indexes. Included use of slowly changing dimensions and suitably partitioned fact tables.▪ Engineered numerous complex libraries in C# that were used by front end team to generate highly customized reports. Reports were created by generating queries dynamically and use of LINQ based on user inputs.▪ Performance tuned existing Azure Datawarehouse with optimized maintenance plans including index redesign, stats rebuilds and redesigning parts of the database to utilize MPP specific features like optimized data distribution, result set caching, resource class management and Polybase.▪ Designed processing framework of multiple SSAS cubes through AMO in C#. ▪ Developed multiple tabular SSAS cubes on Azure hosted VMs. ▪ Built complex ETL solutions using SSIS and Azure Data Factory.▪ Built numerous reports in Power BI, both imported and connected to SSAS cubes.▪ Coached teammates and new joiners in DBMS with SQL Server and OOP coding in C# Show less

• 

  Microsoft

  Feb 2022 - now

  Senior Software Engineer