BI Engineer, Dat Engineer, SQL Developer, ETL/Reports Developer

*

Name: Elias Derbe

Cell: +165*-***-**-**

Email: ************@*****.***

Objective

Seeking an ETL/Reports/SQL/Data Warehouse Developer position to leverage my 6+ years of experience in Microsoft SQL Server and Business Intelligence tools to optimize data integration systems and enhance business process efficiency. I am dedicated to providing excellent service, innovative solutions, and fostering a collaborative team environment to meet and exceed organizational objectives. Professional Experience Summary

More than 6 years of professional experience with knowledge in Data Modeling, Data Warehouse, ETL, T-SQL development, MS Business Intelligence Tools like (SSIS, SSAS, SSRS, POWER BI) in SQL Server 2014/2016/2017/2019/2022.

Utilized expressions to calculate, group, filter, parameterize and format the contents of a report.

Active in all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Bulk Insert, and SSIS and creating Master-Child Packages in SSIS using Kimball methodology.

Expertise with data cleansing operations using SSIS transformations and T-SQL scripts to normalize the data and remove and identify potential problem points when moving information into a data warehouse.

Skilled in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.

Worked on mapping documents creation as well as development for Data migration, data import, Initial and Incremental load.

Configured snapshot replication for reporting, user acceptance test and development servers.

Expert knowledge and experience authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).

Well versed in designing complex reports like Drill-Down reports, Drill-Through Reports, Parameterized Reports, Sub Reports, Ad-hoc reports and Dashboard Reports using SSRS based on client requirement.

Skilled in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.

Adept in SSIS direct and indirect configuration (XML, SQL Server) set up, SSIS audit and logging, error handling, and performance tuning of SSIS Packages.

Participate in Agile – Sprint methodologies to do requirements gathering, analysis and planning.

Designed and developed interactive dashboards and reports in Power BI, ensuring data accuracy and effective visualization.

Developed efficient data models using reporting services like Power BI, Tableau, MicroStrategy, SAP Business Objects(BO) and IBM Cognos adhering to best practices for star schema and dimensional modeling.

Designed and implemented data pipelines using Azure Data Factory to ingest, transform, and orchestrate data from various on-premises and cloud-based sources.

Collaborated with cross-functional teams to integrate Azure Data Factory pipelines with downstream applications such as Azure Synapse Analytics and Power BI. 2

Overall Technical Skills

Technology Description

OS Windows 2016/22 Server, Windows 7.0, Ms-Dos,

Windows XP, Windows 10

RDBMS/Data Access SQL Server 2014/2016/ 2017/2019/2022, SQL, SQL Server Reporting Service(SSRS), SQL Server Integrated Service(SSIS), Analysis Service(SSAS), SQL Server

Common Language Runtime(CLR), Microsoft Dynamics

365, Oracle, Mysql,, Visual Studio, C#, Informatica, Azure SQL, Snowflake(dbt), Azure Data Factory, Synapse and Databricks, BigQuery

Reporting Services SQL Server Reporting Service(SSRS), SQL Server Analysis Service(SSAS), Mircrosoft PowerApps, Visual Studio, Power BI, Tableau, MicroStrategy, SAP Business Objects

(BO) and IBM Cognos, SAS

Data Modeling Erwin, Microsoft Visio, Draw.io

Data Scheduling Microsoft Project, Microsoft Visio CRM & ERP

Power Platform

Application Development

Dynamics 365 => Finance, Marketing

D-365, Power Apps, Power BI

Power Apps(Canvas, Model)

SDLC Methodologies Water Fall Model, Agile, SCRUM

Professional Experience

Title: ETL/Reports Developer/Data Engineer Remote Client: Carrington Mortgage Services, Anaheim, CA

Time Period: July 2023 – Todate

Responsibilities:

Wrote complex store procedures for data profiling process needed to define the structure of the pre staging and staging area, as well as triggers for consistency checks.

Provided security for accessing the reports at the server level, report level and report item level.

Designed ad hoc SSRS reports in the test environment for data validation using SQL Server.

Created Reports using SQL Server Reporting Services to report trends from existing data mart.

Designed SSIS packages using various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations.

Optimized SSIS packages by using various techniques such as use of non-blocking, synchronous communication nature transformations, optimizing sources as well executing packages in parallel.

Created staging database to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.

Involved in Report generation using SSRS and Excel services, Power Pivot and deployed them on SharePoint Server.

Created complex reports that include multiple data sources and stores procedures with nested tabular and matrix forms and formatted the reports using the Global variables and expressions (conditional formatting). 3

Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.

Implemented master child packages so only the Master package has to be scheduled which will in turn fire the other packages.

Involved in report execution based on caching and snapshot. Created and managed normal subscriptions and data-driven subscriptions.

Used Erwin tool for dimensional modeling (Star schema) of the staging database as well as the relational data warehouse

Developed complex mappings using SSIS to transform and load the data from various source systems like Excel, Flat files, Oracle into the SQL Server 2019/2022 Server target staging database.

Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.

Used Power View and created various analytical reports and Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.

Built SSRS project to generate reports with desired formats (Word, PDF, Excel, etc.) to present statistics information according to business requirements.

Designed and implemented complex ETL (Extract, Transform, Load) processes using SSIS to migrate master data across multiple systems and environments.

Wrote SQL queries to validate data on staging tables and data warehouse tables to validate the data results.

Implemented various different SSIS features like loggings, transactions, checkpoints, deployment, and configuration on designed end-to-end ETL strategy so that the developed packages could be optimized to the fullest depth.

Designed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to the business.

Assisting Production(Technical) Support teams with development or maintenance of ETL pipelines, performance tuning of SQL Queries and ETL pipelines and Give solution to deadlocks and bottlenecks.

Integrated SSIS with Master Data Management (MDM) tools to centralize, cleanse, and standardize master data across the organization.

Configured Report Server with SQL Server 2019/2022 to drive Reporting Services(Code review, User- acceptance, Image editing)

Created hierarchy based reports using grouping and drill down options and parameterized them as well.

Optimized the reports by optimizing the embedded queries, or optimized the stored procedures that generate them.

Examined and evaluated the data structures in the source and enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server SQL Server 2019/2022.

Designed and developed interactive Power BI and Tableau dashboards to track key mortgage metrics such as loan origination, delinquency rates, prepayment rates, and portfolio performance.

Set up Power BI data refresh schedules to ensure real-time data availability for business users.

Designed and implemented data pipelines using Azure Data Factory to ingest, transform, and orchestrate data from various on-premises and cloud-based sources.

Collaborated with cross-functional teams to integrate Azure Data Factory pipelines with downstream applications such as Azure Synapse Analytics and Power BI. Tools Used: SQL Server 2019/2022, BIDS/SSDT (SSIS, SSAS, SSRS), Automation, Erwin, Ms Visio, Windows 2019 Server, SP 2010, Power Pivot, Power View, MS Visual Studio 2019, Oracle DB, MySQL DB, Powershell, Power BI, Azure cloud/Data Storage, C#, Informatica, AWS, Varicent, GIT, Azure SQL, Snowflake(dbt), Python Programming, Tableau, Azure DevOps, DAX, Tableau, MicroStrategy, SAP Business Objects (BO) and IBM Cognos, .NET Development Tools, SAS, Azure Databricks 4

Title: SQL/ETL/BI Developer Remote

Client: Inspire Home Loans Inc, Irvine, CA

Time Period: May 2022 – May 2023

Responsibilities:

Was responsible for securing the entire database with various types of encryption techniques along with the use of certificates.

Devised dashboards to contain drill-down capabilities to view requested user information through summary reports and trend charts.

Created complex SSIS packages to pull data from Excel and flat files to SQL server

Implemented appropriate high-availability solution like log-shipping and mirroring which best suited the business needs according to the functionality and the budget requirements.

Was responsible for identifying sources, creating staging database, and data warehouse (Facts and Dimensions).

Extracted large volumes of master data from multiple data sources (SQL Server, Oracle, flat files, etc.) using SSIS packages, ensuring completeness and accuracy.

Gathered requirements from the client, Perform Gap Analysis, Facilitate JAD Sessions.

Implemented various different SSIS features like loggings, transactions, checkpoints, deployment, and configuration on designed end-to-end ETL strategy so that the developed packages could be optimized to the fullest depth.

Scheduled jobs like backups, restoring of databases using the SQL Server Job Agent.

Created several reports using SSRS such as Drill Through reports, Linked, and sub reports.

Was responsible for analyzing various dimensions and facts that could be included in Data Warehouse design using best suited Star-Schema and created logical and physical model of DW in design software like Erwin.

Managed the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.

Automated and scheduled ETL workflows using SQL Server Agent to ensure timely migration of master data and reduce manual intervention.

Implemented the Master Child Package Model for easier maintenance and better performance.

Managed very large reports that return a large volume of records and optimized their performance using techniques such as Cascading Parameters and Filters.

Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.

Developed and executed strategies for archiving historical master data as part of the migration process, ensuring that legacy data is properly retained or purged based on business requirements.

Created packages with several Transformations in each Package making sure that the data is cleaned and confirmed before being sent to the Staging Area.(Code review, User-acceptance)

Implemented package configurations on the development, test, and production environments.

Integrated data from multiple sources, including CRM systems, loan origination platforms, and financial databases, into Power BI for comprehensive reporting.

Created interactive dashboards to visualize key performance indicators (KPIs) like loan origination, approval timelines, interest rate trends, and customer satisfaction metrics. Tools Used: SQL Server 2017/2019, SSIS, SSAS, SSRS, Automation, Erwin, Windows Server 2016, Ms Visio, Oracle DB, MySQL DB, Visual Studio, Powershell, Power BI, Azure cloud/Data Storage, C#, Informatica 5

AWS, GIT, Azure SQL, Snowflake(dbt), Python Programming, Tableau, MicroStrategy, SAP Business Objects

(BO) and IBM Cognos,, Azure DevOps, DAX, .NET Development Tools,SAS Title: SSIS/Reports Developer Remote

Client: BD Incs, San Diego, CA

Time Period: Sept 2020 - March 2022

Responsibilities:

Involved in Full and daily Incremental loads into Staging and ODS areas, troubleshooting process issues and errors using SQL Server Integration Services (SSIS) 2019.

Optimized ETL packages by optimizing queries and using proper transformations.

Created the T-SQL script to generate all the tables and relationships based on the finalized ER-Diagram.

Involved in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Actively involved in securing the reports created depending upon the level of sensitivity of information that the report contained.

Collaborated with business analysts, data owners, and technical teams to define data migration requirements and ensure successful migration of master data.

Worked with Business Analysts and end users in gathering detailed requirements and specifications.

Included transformations like Slowly Changing Dimensions (Type 1 & 2), Look up, Derived Column, Aggregate, Fuzzy Lookup, Multicast, Conditional Split, Data Conversion, etc. in SSIS Packages.

Wrote complex stored procedures to support HighJump WMS for Data Profiling, Backup the databases as well as handling the index fragmentation.

Supported the logging framework by generating EHR reports to identify the trends and set up the strategy to find bug trends, code changes using Team Foundation Server.

Created views as required by front end developer for easier implementation on web pages, and wrote instead of triggers on those views to provide efficient data manipulation.

Implemented package configurations on the development and test environments.(Code review, User- acceptance)

Formatted and extended interactive SSRS reports by creating parameters within reports, multi-value parameters as well as embedding functions with expressions.

Implemented the Master/Child Package Models to ensure that only the Master Package is scheduled which will in turn fire the other packages.

Implemented error handling techniques like try catch blocks, error functions in T-SQL scripts and stored procedures to support the applications.

Designed and deployed Parameter-driven reports using parameters tab in the SSRS GUI procedures by Setting up the report-level parameters, along with Building parameter-driven queries and stored and placing them, in the data field.

Developed complex mappings using SSIS to transform and load the data from various source systems like Excel, Flat files, Oracle into the SQL 2019 Server target staging database.

Created several ad hoc reports, drill down, drill through, sub, linked, cached and snapshot reports using reporting services.

Created event handlers on every executable in an SSIS package.

Involved in designing the physical database models on SQL Server 2019/2022 RDBMS. 6

Developed complex Stored Procedures, triggers and User Defined Functions for implementing business logic and process in backend, for data extraction, reports and other client interfaces.

Designed the ETL process using SQL Server 2019 SSIS Packages in which the data sources include Oracle.

Involved in Report generation using SSRS and Excel services and deployed them on SharePoint Server.

Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, KPI’s, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.

Tools Used: SQL Server 2019/2022, SSIS, SSRS, Automation, Erwin, Windows Server, Visio, TFS, Power Pivot, MS Visual Studio 2019, Oracle DB, MySQL DB, Powershell, Power BI, Azure cloud/Data Storage, C#, Informatica, AWS, Varicent, GIT, Azure SQL, Python Programming, Jira, .NET Development Tools Title: SQL/ Data Warehouse Developer

Client: East West Bank, El Monte, CA Hybrid

Time Period: July 2019 – July 2020

Responsibilities:

Involved in the creation of scheduled jobs for Extracting, transforming and loading operations and database maintenance tasks like de-fragmentation, re-indexing, and recompiling.

Created various data driven subscriptions on a monthly and a quarterly basis for different reports based on requirements.

Performed Functional and Regression Validation on SSRS Reports which implements drill down/drill up, Sub reports and validated the Security on SSRS reports.

Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram.

Responsible for identifying sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions).

Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Used Erwin tool for dimensional modeling (Snowflake schema). Forward Engineered Data Model of data mart to SQL 2017 Server.

Created Document Map to navigate to the particular section of the report.

Created triggers and audit tables in order to capture the incremental data from Online Transaction Processing and created complex stored procedures to perform data profiling in the pre-staging database.

Used SSIS Packages to extract transform and load data from multiple input sources like Excel files, Production SQL Servers (2017/2019) and Oracle into the data mart in optimized way.

Optimized the existing queries to improve performance with the use of Profiler and Execution Plans.

Participated in meetings to develop conceptual database design, improve functionality, and achieve optimal performance and development strategy.

Worked on parent-child architecture on database object including SPs, UDFs and tables with development.

Created many complex stored procedures and used them in Reporting Services directly to generate reports on the fly.

Incorporated Error Redirection during ETL Load in SSIS Packages. Involved in Unit testing and System Testing of ETL Process.

Involved in dimensional data modeling and story boarding ETL processes.

Designed and implemented data warehouse to data-mart using Top-down approach.

Utilized the Dynamic SQL for user customizable queries to be answered by the SQL Server. 7

Generated ad-hoc Reports using SQL 2017 Server Reporting Services to validate the information inserted to the warehouse after refreshing it.

Created Dashboards, Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS. Tools Used: SQL Server 2017/2019, BIDS, SSIS, SSAS, SSRS, Automation, Erwin, Visio, Windows Server, Oracle DB, MySQL DB, Visual Studio, Powershell, Power BI, Azure cloud/Data Storage, C#, Varicent, GIT Title: SQL/ Data Warehouse Developer

Client: Dental Health Services, LB, CA

Time Period: May 2018 – May 2019

Responsibilities:

Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.

Ensured EHR data consistency by creating primary key, foreign keys and appropriate constraints.

Involved in designing of shift based reports, chart reports (line and column), parameterized reports for performance analysis.

Used BCP utility and bulk insert for transferring data between SQL server and flat files.

Facilitated EHR data retrieval and manipulation through implementation of Views, Procedures, Triggers and Cursors.

Created ETL process using SSIS for populating data store in SQL Server 2014.

Successfully implemented indexes on tables and views for optimum performance tuning.

Wrote complex queries, stored procedures, UDFs in support of the ETL processes, front end applications and reports.

Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2014.

Designed strategies for securing the reports created depending upon the level of sensitivity of information that the report contained.

Supported some business specific relationships, and advance constraints by embedding triggers on tables.

Set up scheduled Jobs and alerts for updates and backups.

Created DDL and DML triggers to maintain database integrity

Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.

Tools Used: SQL Server 2014, BIDS, T-SQL, SSIS, SSRS, Automation, Erwin, Visio, Flat Files, Excel, Oracle DB, MySQL DB, Visual Studio, Powershell, Power BI, Azure cloud/Data Storage, C#, GIT, .NET Education

Bsc in Civil Engineering (2002-2007)

Addis Ababa Univerisity

Certification and Extensive Training

Extensive Training On Microsoft SQL Server Database Development and Administration.

Extensive Training On Microsoft SQL Server Integration and Reporting Services

Extensive Training On Microsoft Power Platform(D-365, Power apps, Power Automate, Power BI) Personality

I am a diligent, detail oriented, punctual, professional, known for my helpfulness and strong team spirit. I am sociable, honest, and respectful, with a well-organized and efficient approach to work and my personal life. 8

When I am not working, I cherish spending time with my family and staying active through exercise. I have a passion for travel and enjoy discovering what the world has to offer. I also love learning new things, whether it's mastering new software, acquiring new skills, or engaging in board games.

Contact this candidate