As a key member of BI team, delivered the best results to the development needs, accomplishedsuccessful outcomes by working with T-SQL, SSIS, ADF2, SSAS, Power BI, Tableau and Azuretools; Daily scrum meetings with Project Managers, Business Analysts and end users/clients to gather,analyze and document the business requirements and business rules; discuss the project specsin order to understand the business needs; Assisted and supported the Project Manager in leading multi-functional project teams inimplementing data conversion strategies and communicating essential information to teammembers; Implemented performance tuning on complex stored procedures, views, user defined functionsand queries by creating proper indexes and optimizing the existing ones; Strong experience with SQL Server and T-SQL in implementing, maintaining developing StoredProcedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, UserProfiles, Relational Databases Models, creating and updating tables and checking the databaseconsistency by executing DBCC commands; Developed and deployed a number of Azure-based applications, utilizing services such as AzureVirtual Machines, Azure Storage, Azure SQL Database, and Azure Active Directory; Experience with Azure Resource Manager (ARM) templates, Azure functions and Logic apps,Azure Kubernetes Service (AKS), Azure Container Registry (ACR), Azure Cosmos DB, ADF,Azure Data Lake Storage and Azure Stream Analytics; Performed incremental data loading in order to synchronize data changes between OLTP andOLAP databases using SSIS packages, execute SQL task and merge; Developed filters, reports, dashboards and also created chart types, visualizations and complexcalculations to manipulate the data in Power BI; Involved in building Power BI and Tableau reports/dashboards for different domains such asFinance, Accounting, Management, and other client teams;

 Led the Business Intelligence (BI) team in defining the end-to-end data processing workflow,including data extraction, data ingestion, data modeling, and analytics. Conducted the initial technical planning and requirements gathering phases, overseeingarchitecture, design, development, testing, and project delivery. Constructed logic and created indexed tables, views, and stored procedures based on specificbusiness requirements and rules.1 of 3 Proficient in crafting complex T-SQL queries, intricate joins, and employing commands likeMerge and Except. Played a key role in SSIS (SQL Server Integration Services) development and support, craftingETL (Extract, Transform, Load) solutions for integrating data from diverse sources such as flatfiles (delimited and fixed-width), Excel, SQL Server, raw files, and DB2 into the central OLTP(Online Transaction Processing) database. Utilized C# scripting within script tasks for ETL processes, ensuring high performance andmaintaining ETL packages effectively. Developed, deployed and monitored SSIS Packages with different work flow/data flowcomponents such as execute SQL task, script tasks, lookups, file system tasks, FTP tasks,merge joins, Azure blob sources and send mail tasks. Extracted data from various sources, including SQL Azure databases, SQL Azure DataWarehouse, AWS RDS solutions like MySQL, Aurora, and Redshift, to create data sources forPower BI reports.

Distinguished for a keen understanding of business requirements and translating them intoactionable insights through meaningful reporting. Proficiently designed, coded, and maintained ETL (Extract, Transform, Load) routines anddashboards, consistently delivering high-quality output. Expertly handled data extraction and loading from diverse sources, including Excel, flat files,SQL Server, and Oracle, into the staging area. Constructed complex analytic queries for substantial datasets, developed T-SQL storedprocedures, triggers, and user-defined functions, effectively managing data manipulation tasksas needed. Collaborated with cross-functional teams, including both contract and full-time employees, tocreate business intelligence solutions, stored procedures, and reports. Contributed to the design,development, and management of a data warehouse environment dedicated to analytics andreporting. Identified and proposed enhancements to optimize the ETL environment, implementingmonitoring, quality assurance, and validation processes to ensure data accuracy and integrity. Generated reports through OLAP, sub-reports, bar charts, and matrix reports using SSRS (SQLServer Reporting Services) and Power BI. Developed multidimensional objects such as cubesand dimensions using SQL Server Analysis Services (SSAS). Provided valuable support in implementing BI solutions by monitoring and optimizing queries anddata loading processes, and addressed user inquiries related to functional and technical issues.