Responsibilities- Leveraging Azure Cosmos DB's integrated global distribution and multi-region writes for global-scale applications. Creating and managing partitioning and processing settings in SSAS cubes, configuring partitioning and processing options for optimal performance and management. Implemented SQL server database data replication for real-time data propagation to reporting systems Assiduously safeguarding report security and access controls in SSRS, ensuring… Show more Responsibilities- Leveraging Azure Cosmos DB's integrated global distribution and multi-region writes for global-scale applications. Creating and managing partitioning and processing settings in SSAS cubes, configuring partitioning and processing options for optimal performance and management. Implemented SQL server database data replication for real-time data propagation to reporting systems Assiduously safeguarding report security and access controls in SSRS, ensuring confidential data remains accessible only to authorized users. Developed and maintained SQL scripts for database data migration and transformation between different database platforms Implemented data partitioning and indexing strategies to optimize query performance and enhance data scalability. Designed and implemented data archival strategies to manage historical data while optimizing storage resources. Collaborated with data governance teams to ensure ETL processes comply with data governance policies and standards Developing and maintaining advanced data governance frameworks in QlikView, including data stewardship, data quality management, and data lifecycle management, to ensure data consistency and reliability. Writing complex SQL scripts, stored procedures, functions, and triggers to automate data operations and business logic Developing and maintaining Power BI reports with dynamic time intelligence calculations for time-based analysis. Collaborating with data engineers to establish data consistency and integrity during data movement within Azure Data Factory, harmonizing data flow within the system Designing and implementing custom error handling, logging mechanisms key vault and secret operations Defining and enforcing custom key rotation policies Azure Synapse to adhere to specific industry regulatory requirements. Key rotation involves regularly updating cryptographic keys used for data encryption to enhance security mitigate potential vulnerabilities. Show less

Responsibilities- Optimizing SSIS packages for peak performance, strategically leveraging parallelism and source/destination-specific enhancements. Crafting ad-hoc and on-demand reports in SSRS, precisely tailored to user requests, showcasing a keen eye for detail in data representation. Designing and implementing database recovery and rollback procedures, establishing processes to recover the database to a consistent state after failures. Developed and maintained data… Show more Responsibilities- Optimizing SSIS packages for peak performance, strategically leveraging parallelism and source/destination-specific enhancements. Crafting ad-hoc and on-demand reports in SSRS, precisely tailored to user requests, showcasing a keen eye for detail in data representation. Designing and implementing database recovery and rollback procedures, establishing processes to recover the database to a consistent state after failures. Developed and maintained data warehousing solutions for storing and accessing structured and unstructured data. Employed transfer learning for domain adaptation in speech recognition tasks, fine-tuning pre-trained models for specific dialects or accents during data analysis. Designing and implementing automated data validation processes to identify data discrepancies in OLAP and OLTP systems Implemented SQL server extended events for database performance monitoring and troubleshooting, identifying and resolving performance bottlenecks Configuring and managing storage modes and partitions in SSAS tabular models, optimizing storage and query performance in tabular models. Conscientiously maintaining SSIS package documentation, including design specifications and data mappings, to efficiently support project execution. Diligently monitoring SSRS report usage and performance metrics, adeptly identifying opportunities for enhancing reporting efficiency and effectiveness. Conducted BI data profiling and metadata management for comprehensive data understanding.  Develop, optimize, and maintain SSIS packages with tasks, transformations, and data flow components for seamless data integration. Skillfully crafting SSIS data flows that seamlessly integrate data across heterogeneous systems and platforms, enabling smooth data exchange and fostering a cohesive data landscape Show less