Sql Server Business Intelligence

Shishir Kumar Regmi

Pittsburgh PA, ***** United states 412-***-**** *****************@*****.*** Summary

Experienced SQL/ETL Developer with over 5 years of proficiency in the Microsoft Business Intelligence stack, focusing on OLTP, Data Warehousing, OLAP, and database technologies. Skilled in crafting comprehensive business intelligence solutions using SSIS, SSRS, and SSAS within BIDS. Demonstrated expertise in analyzing, designing, developing, implementing, and testing client/server applications on Microsoft SQL Server and BI suite tools. Proficient in T-SQL for intricate stored procedures, triggers, tables, user-defined functions, and robust data modeling. Capable of seamlessly integrating Microsoft BackOffice components like SharePoint and IIS with MS SQL Server. Proven track record in ETL implementation, SSAS cube development, and generating sophisticated reports. Possessing strong problem-solving abilities and effective communication skills to understand and fulfill diverse business needs. Actively seeking opportunities to contribute experience and technical prowess within a collaborative team environment, driving critical business objectives with precision and efficiency. Experience

SQL/SSIS DEVELOPER COMPASSION CARE CLINIC NOVEMBER 2021 – PRESENT LOCATION: DALLAS, TX 75211

• Managed project lifecycle following Agile methodology, engaging with business users to grasp requirements for the Investments application.

• Developed SSIS packages for ETL processes, integrating OLTP to OLAP systems, and implemented logging for package and task-level data processing.

• Conducted system analysis, modified database structures, and crafted T-SQL scripts to accommodate business process changes.

• Designed dimensions using STAR and SNOWFLAKE schemas, and created SSIS packages for OLTP to data warehouse transformations.

• Oversaw Oracle to SQL Server data warehouse migration, utilizing SSRS for reporting across various SSAS Cubes.

• Administered database objects using T-SQL, including tables, views, users, and indexes.

• Implemented SSAS Cubes with KPIs and actions, generating MDX queries for report generation.

• Developed error handling mechanisms in SSIS, employing fuzzy and exact lookups for data cleansing and standardization.

SQL DATABASE DEVELOPER BHATBHATENI SUPER MARKET JANUARY 2020 - OCTOBER 2021 LOCATION: ANAMNAGAR, KATHMANDU

• Led SDLC from requirements gathering to development and testing using Agile (Scrum).

• Created complex SQL queries, stored procedures, and SSIS packages for data integration.

• Designed and implemented SSIS jobs for automating report generation and cube refresh.

• Architected high-level ETL framework for OLTP to OLAP data transfer with SSIS.

• Executed advanced SSIS ETL operations for data validation, cleansing, and transformation.

• Proficient in SSIS, SSAS, and SSRS, designing cubes and reports with various features.

• Expertise in SQL Server installation, configuration, and performance tuning.

• Developed custom scripts and automation using AWS SDKs and APIs to integrate Amazon S3 with other AWS services and third-party applications.

• Designed and developed a data processing pipeline using python. Page 2

• Designed, developed and maintained Power BI dashboards and making reports accordingly.

• Configured event notifications using Amazon S3 Event Notifications to trigger AWS Lambda functions or other AWS services based on bucket activity.

• Developed parameterized reports, dashboards, and data models for BI solutions. SQL DEVELOPER SIDDHARTHA BANK LIMITED OCTOBER 2018 - DECEMBER 2019 LOCATION: KATHMANDU, NEPAL

• Led daily scrum meetings with project and change management teams to discuss requirements, change requests, and task assignments.

• Designed dynamic SSIS packages for cross-platform data transfer, validation, and archiving.

• Developed, debugged, and tested reports in SQL Server Reporting Services (SSRS).

• Collaborated with data engineers, data scientists, and business stakeholders to understand data requirements and architect end-to-end data solutions using Azure Data Lake and Azure Data Factory.

• Configured event-driven triggers and schedules in Azure Data Factory to automate data ingestion, transformation, and loading processes.

• Utilized SSIS for data integration and transformation within MS SQL environments.

• Created complex SQL queries, stored procedures, and user-defined functions.

• Designed and enhanced data models for ETL projects using ERWIN.

• Optimized SQL performance using tools like SQL Profiler and Query Analyzer.

• Transferred data from various sources to SQL Server, including Oracle and CSV files.

• Implemented indexing and SQL tuning to improve database performance. Education

BACHELOR IN COMPUTER ENGINEERING THAPATHALI CAMPUS INSTITUTE OF ENGINEERING TRIBHUVAN UNIVERSITY, NEPAL

Technical Skills

SQL Server Tools: SSMS, BIDS, Enterprise Manager, DTS, Profiler, DTA ETL & Reporting Tools: SSIS, SSRS, SSAS, BIDS, DTS, Business Objects, PowerPivot. Databases: SQL Server, MS Access, Oracle

Cloud Tools: AWS, Azure

Operating System: Windows, MS DOS, Linux.

Scripting: HTML, JavaScript, ASP.NET, Python

Tools: Erwin, Visual Studio and Report Builder

Industry Experience: Healthcare, Retail, Banking

Contact this candidate