Rabin Lamichhane

• Over 6+ years of experience in the field of Microsoft BI tools (SSIS/SSRS), Data Warehousing and T SQL using SQL Server (2012/2014/2016). • Expertise in Extraction, Transformation, loading data from Oracle, DB2, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS packages. • Hands-on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance. • Experience in developing stored procedures, functions, Joins, triggers, views/materialized views, optimizing • Queries, table normalization and denormalization, clustering, T-SQL, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), RDBMS, data dictionaries, and data integrity. • In-depth experience of Transact-SQL (DDL, DML), Designing and Normalization techniques on the database tables. • Good knowledge in RDBMS concepts, Data warehousing concepts & OLAP. • Data Migration & Integration: ◦ Migrated data from SQL Server and legacy systems. ◦ Designed and scheduled complex SSIS packages for ETL from various sources. ◦ Automated SSIS packages using TIDAL and utilized package configuration wizard. • Reporting & Analytics: ◦ Developed, tested, and maintained Power BI reports and dashboards based on user requirements. ◦ Created and deployed SSRS reports, including drill-down and parameterized options. ◦ Experience in Report Models for ad hoc reporting with SSRS. • OLAP & Data Warehousing: ◦ Created shared dimensions, cubes, and aggregations in SSAS; modified tabular models for new requirements. ◦ Extensive work with Azure SQL Data Factory for data warehousing and analytics. • Database Management: ◦ Skilled in writing stored procedures, views, and functions; experienced in performance tuning using SQL Profiler and Database Tuning Advisor. ◦ Proficient in building Data Lakes and handling bulk data loads. • Cloud & BI Technologies: ◦ Experience with AWS (Amazon Redshift) and GCP (Google Cloud Big Query). ◦ Familiar with Microsoft BI stack, including Power Query and Tableau. ◦ Utilized automation tools like Autosys and Control-M scheduling.