Name Yonas Baraki

Phone 443-***-****

Email adzmou@r.postjobfree.com

PROFESSIONAL SUMMARY:

●7+ years of experience in Database Design, Development, Implementation, and Tuning of Relational Database Systems using MS-SQL Server 2008R2/2012/2014/2016/2017/2019.

●Worked with stakeholders and end users to meet business requirements and experienced in the proper documentation of records.

●Experienced with working on Agile Projects with multiple Sprints Cycles and Scrum meetings, and on Waterfall projects with full Software Development Life Cycle

●Strong interpersonal and communication skills; competitive analytical, logical, and problem-solving skills; strong management, administrative and leadership skills; and active and self-learning abilities.

●Detail oriented, working under pressure, and meeting short deadlines with exceptional problem solving and decision-making analytical skills and strong teamwork spirit.

●Experienced in managing SQL Server and writing T-SQL (DDL, DML and TCL) statements; and in creating and maintaining SQL Server database objects such as Tables, Views, Stored Procedures, User Defined Functions, Triggers, Indexes, and Cursors.

●Experienced in optimization and performance tuning.

●Skilled in using table variables and Common Table Expressions (CTEs).

●Expertise in developing complex SQL queries and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Native tools.

●Experience in Extraction, Transformation and Loading (ETL) tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), ETL package design, and RDBM systems.

●Experienced in designing SSIS packages for different Data Flow and Control Flow processes.

●Skilled in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, and Snowflake Schema.

●Well experienced in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

●Generated various Drill-Down Drill-Through reports, Parameterized reports, Tabular reports, and Matrix reports using SQL Server Reporting Services (SSRS).

●Managing and securing reports using SSRS. Created report schedules.

●Experienced in developing Business Intelligence (BI) solutions for Decision Support Systems using SSIS, SSRS, SSAS, and Power BI.

●Experienced in developing and maintaining data warehouse’s functionality; and developed multi-dimensional objects and Cubes using SQL Server Analysis Services (SSAS).

TECHNICAL SKILLS:

●DBMS/RDBMS: MS-SQL Server (2017/2016/2014/2012/2008

●ETL Tools: SQL Server Data Tools (SSDT), SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and T-SQL

●Reporting Tools: SQL Server Reporting Services (SSRS), Power BI

●Programming Languages: T-SQL, PL/SQL

●Tools: Microsoft SQL Server Management Studio, Visual Studio.

Professional Experience:

SQL Developer/ SSIS Developer

First Commonwealth Bank

April /2021 - Present

Responsibilities:

●Developed complex T-SQL codes to create/update database objects such as Tables, Views, Stored Procedures, User Defined Functions, Triggers, Indexes, and Cursors.

●Used Joins, Correlated and Non-Correlated Sub-Queries for complex business queries involving multiple tables & calculations from different databases.

●Experienced with Dynamic SQL and developed procedures utilizing the functionality.

●Used SSIS to create ETL packages to Extract, Transform and Load data to Data Warehouse and Data Mart Databases.

●Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging Database.

●Extracted data from different sources (CSV, Excel, and MSSQL and Oracle database sources) and load to Data Warehouse using SSIS complex data transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split, Lookup, Fuzzy Lookup, Slowly Changing Dimension, Derived Column, Row Count, and more) for existing/new packages.

●Provide Data Lake Access to various groups and users using the ACLs in Azure storage explore

●Developed SSIS packages using For Each Loop Container in the Control Flow

elements to process all Excel files within folder; File System Task to move file into Archive after processing; and Execute SQL task to insert transaction log data into the SQL Table.

●Well experienced in using Table Variables and Common Table Expressions (CTEs).

●Scheduled Jobs for executing the stored SSIS packages which were developed to update the database using SQL Server Agent. Also, involved in deployment of SSIS Packages.

●Used advanced features of T-SQL to Design and Tune T-SQL to interface the database and other applications in most efficient manner.

●Generated Sub-Reports, Crosstab, Conditional, Drill-Down reports Drill-Through reports and Parameterized reports using SSRS.

●Created customer trend visualization in Power BI from dedicated Synapse server source

●Created reports to retrieve data using Stored Procedures that accept parameters.

●Experience on working in Agile/Scrum environments.

Environment: MS SQL Server 2016/2017, DTS, MS Access, SQL Query Analyzer, MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), TSQL, PL/SQL, SQL Profiler, Windows Server 2008/2012, Microsoft Office.

Database Developer

June/2018 – April/2021

Newport Group

Responsibilities:

●Developed Stored Procedures and Functions used for inserting, updating, or transforming data. Also, created scripts for tuning and scheduling.

●Created new tables and wrote stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.

●Creating table indexes and constraints to ensure data integrity and enhance query processing and come up with efficient data retrieval.

●Extensively involved in created SSIS packages to migrate data from different data sources to data warehouse.

●Analyzing Business Intelligence Reporting requirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas and Snowflake Schemas.

●Created SSRS Summary Reports, Sub Reports, and Drill-down Reports (on demand and periodic) by using Expressions.

●Importing Source/Target tables from the respective databases by using Execute Package Task using Control Flow Tasks in SSIS.

●Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequence Container, Email Task and Data Flow Tasks.

●Involved in enhancing and deploying the SSIS Packages from development server to production server.

●Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.

●Scheduled the ETL Package, Email, and Stored Procedures.

●Developed different reports and visualization solutions for internal and external reporting purposes.

Environment: MS SQL Server 2012/2014, MS Visual Studio 2012/2014 (SSIS/SSRS), Power BI, Microsoft Excel, Outlook, MS SQL Profiler, Windows Server 2008/2012.

Costco

January/2016 – June/2018

Database Developer

Responsibilities:

• Gathered, analyzed, classified and documented project requirements from BI analysts and directors and completed data mapping process, related to claim history, property value, three financial sheets, and etc.

• Used T-SQL to create databases objects based on business specifications such as stored procedures, user-defined functions, views in SSMS

• Involved in building Data Warehouse based on Star Schema and Data Marts

• Developed ETL packages in SSIS to import data on a weekly basis from the OLTP system to the landing zone in the staging area and migrate it to Date Warehouse and data marts

• Performed incremental loading task to migrate the data from heterogeneous sources to Data Warehouses and Data Marts as well as implementing the slowing changing dimension to protect or discard historical data based on requirements.

• Cleaned and validated the data in the staging area, corrected and unified the format, handled the missing values, transformed the data and split or combined columns based on specifications

• Created multiple control flows based on specifications including data flow task for data migration or conversion, Script Task for dealing with variables, Foreach Loop Containers for realizing loop functions, File task for creating weekly records

• Applied different types of transformations like Data Conversion, Lookup, Conditional Split, Derived Columns, Merge in SSIS

• Debugged the packages and identified error information and stored it by using breakpoints, analyzing processes, error output in SSIS as well as sending an error email message while a task fails.

• Worked with test team to operate unit testing on completed packages and Production Control Team to schedule the operation of the entire package

• Used pages, cascading parameters, expressions and other features to create drill-down reports, drill-through reports, nested reports as operational reports in SSRS.

• Interacted with the Data Science team, developed risk management reports using Tableau for advanced visualizations

Environment: SQL Server 2010/2012, Oracle 10g, SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), Business Intelligence Development Studio, Visual Studio 2008/2010, Tableau 8/9, MS Office Suite 2013 (Excel/Access/Word/PowerPoint), TFS

Education

Bachelor’s degree

Contact this candidate