SQL/ETL/MSBI Developer

Senait Welde

LANCASTER, PA, ***** 717-***-**** **************@*****.***

www.linkedin.com/in/senait-welde-b2611b262

SQL/ETL/MSBI Developer

Professional Summary

Results-driven SQL/ETL/MSBI Developer with over 9 years of experience designing and implementing robust ETL solutions using SSIS, SSRS, and SQL Server. Proven expertise in developing Power BI dashboards, writing complex T-SQL queries, and integrating data from diverse sources. Skilled in leveraging Azure Data Factory (ADF) for cloud-based pipeline orchestration and using Python for data automation and transformation. Adept at working in both on-premise and Azure cloud environments to deliver scalable, high-performance data solutions.

Experience

Senior SQL/ETL/MSBI Developer

CVS Health Corporation, Scottsdale, AZ 03/2023 – Present

● Designed and implemented SSIS packages to automate complex ETL workflows, integrating healthcare data from multiple sources into SQL Server.

● Built scalable cloud-based ETL pipelines using Azure Data Factory (ADF) to extract, transform, and load data between on-premise systems and Azure SQL Database.

● Automated data validation and transformation using Python scripts embedded within ADF and SQL workflows.

● Developed interactive Power BI dashboards and SSRS reports to support pharmacy operations, patient adherence tracking, and cost analysis.

● Created parameterized and drill-through SSRS reports using Report Designer and Report Builder.

● Optimized T-SQL queries and implemented indexing strategies, reducing report run times by over 30%.

● Scheduled and managed automated report delivery via SSRS Subscriptions and Power BI Paginated Reports.

● Migrated legacy Crystal Reports and static reports to modern Power BI dashboards, improving usability and adoption.

● Collaborated with business users, analysts, and IT teams to gather requirements, define KPIs, and deliver accurate, actionable analytics.

● Enforced HIPAA compliance and internal data governance policies by applying strict access controls and secure data handling procedures.

● Maintained version control and documentation for BI assets, ensuring consistency and maintainability across reporting environments.

Senior SQL/ETL Developer

PNC Financial Services, Pittsburgh, PA 03/2021 – 03/2023

● Developed and maintained SSIS-based ETL pipelines to integrate and transform data from Oracle, SQL Server, and Azure SQL Database into enterprise reporting environments.

● Designed and optimized complex T-SQL stored procedures, functions, views, and indexes to support reporting and analytics workflows.

● Built interactive Power BI dashboards using DAX, custom measures, and calculated columns to deliver actionable insights to business stakeholders.

● Implemented Row-Level Security (RLS) in Power BI to ensure data access compliance across business units.

● Scheduled data refreshes and report distribution using Power BI Gateway and service-based automation.

● Integrated Power BI solutions with Azure Data Lake, Azure Analysis Services, and Blob Storage for scalable cloud analytics.

● Tuned slow-performing queries using SQL Profiler, Execution Plans, and Index Optimization techniques to improve performance by up to 40%.

● Collaborated with business analysts and stakeholders to define reporting requirements, validate data models, and ensure accuracy and usability of delivered reports.

● Documented ETL processes, Power BI solutions, and database schema for auditability, support, and knowledge sharing across teams.

ETL/SQL Developer

Exelon Corporation, Chicago, IL 04/2019 – 02/2021

● Developed and deployed SSIS packages to automate ETL workflows for billing, customer, and contract data migration from flat files and legacy systems.

● Designed and maintained stored procedures, triggers, and views in SQL Server to support business logic, data validation, and referential integrity.

● Created advanced SSRS reports including matrix, drill-down, sub-reports, and chart visualizations to support operational and executive decision-making.

● Used Crystal Reports to track key user engagement metrics such as logins, click-throughs, and session durations from the customer database.

● Improved performance of slow-running queries through index tuning, execution plan analysis, and optimization strategies.

● Built incremental load processes using the MERGE statement, reducing processing time and improving data accuracy.

● Configured alerts for job completion and system errors to proactively monitor ETL processes and ensure reliability.

● Documented ETL designs, data mappings, and workflows to support compliance, future enhancements, and team knowledge sharing.

● Conducted system testing, bug fixes, and performance validation to ensure high data quality and functional accuracy in delivered solutions.

● Ensured secure handling of sensitive customer data and supported audits through well-documented and controlled data flows.

SQL/ETL Developer

Headwaters Investment Bank, Denver, CO 01/2016 – 03/2019

● Designed and developed SSIS packages to automate ETL workflows, integrating financial data from flat files, Excel, and third-party systems into SQL Server databases.

● Wrote efficient T-SQL stored procedures, triggers, and views to support financial reporting, ensuring data accuracy and business logic enforcement.

● Created and maintained relational data models, indexes, and constraints to improve data integrity and query performance.

● Conducted performance tuning and optimization of SQL queries using SQL Profiler and Execution Plans, reducing runtime for key processes.

● Supported business users with the development of ad hoc reports and queries, enabling faster insights and decision-making.

● Implemented data validation and error handling mechanisms in ETL processes to improve pipeline reliability and traceability.

● Prepared technical documentation for database objects, ETL logic, and data flow diagrams to support ongoing development and knowledge transfer.

● Collaborated with analysts and application developers to align database structures with reporting and operational needs.

Education

Bachelor of Science in Electrical Engineering

Bahirdar University Graduated: July 2006

Certifications

● Microsoft Certified Solutions Associate

● Microsoft Certified Solutions Expert

● Data Management and Analytics

● Data Analyst Associate

Technical Skills

● Languages: SQL, T-SQL, Python, C#, Java, PowerShell, Visual Basic, .NET

● Databases: Microsoft SQL Server (2008–2019), Azure SQL Database, Oracle, Teradata

● ETL & Data Integration Tools: SSIS, Azure Data Factory (ADF)

● Business Intelligence & Reporting: Power BI (Desktop & Service), SSRS, Crystal Reports, Azure Analysis Services

● Cloud & Big Data: Azure Data Lake, Azure Blob Storage, Azure Analysis Services

● Development Tools: SSMS, Visual Studio, Oracle SQL Developer, MySQL Workbench

● Operating Systems: Windows, Unix/Linux

References

Available upon request.

Contact this candidate