§ Data Modelling: Design and develop data models that define the structureand relationships within the data. Constructing Analysis Services (BothMultidimensional and Tabular) reporting models.§ ETL (Extract, Transform, Load) Processes: Build ETL processes to extractdata from various sources, transform it according to business rules andrequirements, and load it into data warehouses or data marts. In theMSBI stack, this often involves tools like SQL Server Integration Services(SSIS).§ Data (Power BI) Visualization: Power BI development, deployment andadministration. Create interactive and visually appealing dashboards,reports, and visualizations using Power BI. RLS implementation on data.Proficiency in crafting DAX queries. Creating visual reports, dashboards,and KPI scorecards using Power BI Desktop.§ Data Analysis: Analyze data to identify trends, patterns, and insights thatcan drive business decisions. This includes performing ad-hoc analysis aswell as creating standardized reports and analyses.§ Performance Tuning: Optimize the performance of BI solutions by finetuningqueries, optimizing data models, and improving ETL processes.This ensures that reports and dashboards load quickly and efficiently.§ Data Governance and Security: Implement data security measures toensure that sensitive data is protected and that users have appropriateaccess levels to data and reports.§ Collaboration: Work closely with business stakeholders, data analysts,and other IT teams to understand requirements, gather feedback, andensure that BI solutions meet business needs.

§ Power BI development, deployment and administration.§ Creating visual reports, dashboards, and KPI scorecards using Power BIDesktop.§ Developing tabular and multidimensional models compatible withwarehouse standards.§ Connecting to data sources, importing, and transforming data forBusiness Intelligence.§ Implementing row-level security on data.§ Creating and scheduling jobs to refresh the reports automatically.§ Proficiency in crafting DAX queries in Power BI Desktop.§ Expertise in advanced-level calculations on datasets.§ Creating new SSIS Packages and Migrate existing SSIS package fromVisual Studio 2008 to 2016 version, maintain TFS for version control.

§ As a Database Developer: Creating Tables, Writing SPs, Functions, Cursors & complex scripts using T SQL and applying Triggers.Schedule SSIS packages execution using SQL Server Agent in SSMS.§ As a SSIS Developer: Design and Implement the ETL processes. Create Packages using SSIS to load data from source to DWH usingdifferent tasks and transformations. Maintains logs and error handling. Create Package configurations and deploy packages totarget server.§ As a SSRS Developer: Work closely with Business Analysts in gathering and clarifying data reporting requirements. Create differenttypes of reports with charts embedded in Tables, Reports with dynamic images, KPIs and Reports with hiding Columns or Rows.Use complex expressions to calculate, group, filter, parameterize, optimize and format custom reports. Knowledge of best practicesfor report writing (optimization, use of joins and sub-queries).§ As a SSAS Developer: Design Cubes, calculated member, Measures, named sets using MDX Script and KPIs.

§ Leading a team of 13 developers, coordinating with other team (SE, Production support, Test etc.).§ Migrating more than 250 SQL jobs and 350 DTS package to SSIS package, replacing the hard-coded value with variables anddynamic values.§ Finding and rectifying Deprecated features in the Database, Stored Procedure and functions etc.§ Replacing the unsupported data types in the tables and their dependencies.§ Documenting possible issues with remedies.

§ Creating Tables, Writing SPs, Functions, Cursors & complex scripts using T SQL and applying Triggers.§ Performance Tuning and Query Optimization.§ Creating SSIS Packages.§ Schedule jobs for SSIS packages execution using SQL Server Agent in SSMS.