Sheetal Shingote

Confluence Technologies offers various financial products offering Regulatory Reporting solutions. I worked in parallel on three enterprise scale financial products in a multi-tenant environment, owning database architecture, performance, reliability and scalability. Architect for multiple major feature additions to the product. Resolved severe concurrency and performance issues by implementing horizontal partitioning in a multi-tenant system and applying vertical partitioning where appropriate. Implemented and led extensive SQL performance tuning and schema optimization improving process efficiency and system stability. Designed and delivered reusable frameworks that reduced manual effort, improved consistency, and accelerated delivery: Dynamic source-code generation framework for ETL processes Batch processing pipeline framework for processing client CSV files at scale. Test data generation framework Data purge framework Archival of Data using SSIS

Worked on developing Microsoft's business application to support Volume licensing of Dynamics 365 products. Built complex SSIS pipelines to handle licensing while syncing multiple databases maintained across different platforms. Improved performance of multiple licensing processes through deep SQL optimization. Skills Leveraged: T-SQL, SSIS, ETL Pipelines, Data Engineering

Designed and optimized databases for Deloitte's tax calculation and reporting systems used globally.