Suraj Shrestha

• 5+ years of experience as an SQL/ETL Developer specializing in data integration, transformation, and visualization. • Proficient in SQL Server, Oracle, SSIS, SSRS, and SSAS for data management and reporting. • Experienced in scripting tools such as Python, PowerShell, and Korn Shell for automation and ETL processes. • Strong expertise in database development, monitoring, and optimization for high-volume systems. • Comprehensive understanding of Cloud Services offerings by Microsoft Azure and comparative analysis of Services of other cloud operators like Amazon Web Services and Google Cloud in the regards of Ease of development / deployment and Pricing point of view. • Exceptional problem-solving skills with a focus on delivering reliable, scalable, and maintainable solutions. • Proficient in database backup and recovery techniques using SQL Server Always On and other tools. • Skilled in data cleansing, migration, and integration from various sources, including NoSQL databases. • Highly experienced in Data modeling and Dimension modeling, Entity relationships (Tables' Granularities /Cardinalities and relationships [Master, Transactional, Current and Bridge entities]) and Database normalization (up to 3rd normalization form). • Strong experience in T-SQL programming proven, scalable code using stored procedures, various types of joins, subqueries, user defined function, analytical functions, aggregate function, cross/outer apply, group by, over partition by, cursors, merge, try/catch, dynamically generated scripts, triggers, common table expressions, scalar/table valued functions, create/alter tables/columns, views, primary/foreign key constraints, and indexes. • Expert in SQL Server Business Intelligence suite of products like SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS). • Highly experienced in Dimension modelling using star and snowflake schemas, handling Slowly changing dimension using different techniques like row hash (MD5 and SHA), Slowly changing dimension wizard and Lookup, especially in incremental load of data. • Implemented Data Vault 2.0 to support scaling of Warehouse and minimize efforts required to add new entities (tables). • Implemented Full, Incremental and Remigration ETL workflow and data pipelines for Staging, Data mart and Data Warehouse databases. • Experienced in the development and implementation of Data Warehouse solutions: Data Warehouses and Data Marts and ETL processes and designing of Star and Snowflake data models Schema. • Designed ETL workflows to load data into Staging / Landing, Data Mart / Data Warehouse databases for full, incremental and remigration of data. • Proficient in Dimensional modeling, defining dimension attributes, hierarchies and different types of fact tables and measure granularity. • Designed and developed ETL SSIS process design, architecting the flow of data from various sources to target. • Experienced in SSIS utilities like Import/Export Wizard, Package ISPAC Installation ISDEPLOYMENT Wizard, and SSIS Package Designer. • Developed SSAS Cubes (Dimensions, Hierarchies, Dimension Usage Relation Ships and Measure Groups), Also developed Cube deployment strategy through XMLA file, Processing through SSIS package and SQL Agent Job. • Performed complex queries, data scrubbing, data gathering, data consultation and data analyzing on large volume of data sets. Experienced in Tuning SQL queries and T-SQL queries, MDX, & improving the performance of the queries. • Strong interpersonal and communication skills, facilitating seamless collaboration across teams. • Implemented data integration and ETL processes using Azure Data Factory to streamline data movement and transformation. • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2014. • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters. • Strong knowledge of Data Extraction, Data Mapping, Data Conversion and Data Loading process using UNIX Shell scripting, SQL, PL/SQL and SQL Loader. • Expertise in handling errors using Exceptions with RAISE application clause. • Proficient in development of dashboards using DAX and Power BI for advanced data visualization. • Experienced in Agile methodologies for project development and implementation. • Provide support to junior co-workers and work with offshore resources for knowledge share. • Doing peer/ code review of co-worker and junior developer and make necessary revision to make sure code best practice has been followed and to eliminate errors into PROD environment. • A team player with excellent interpersonal, communication and presentation skills.