Sql Developer Server

KAL HAILE

419-***-**** Virginia VA

***.*******@*****.***

Professional Summary

Result-driven professional with 2 years of experience as MSBI developer in various stages of Software Development Life Cycle (SDLC) like planning, Design, production, Development, Implementation and Unit Testing

Developed applications using SQL Server, SSRS, and SSIS.

Experienced in ETL cycle from Data Acquisition Raw Data, Data Cleansing, Data Manipulation, Data Normalization, and Re-calculation. Extensive experience in creating database objects such as Table, Constraints, Indexes, Views, Stored Procedures, UDFs and Triggers using Microsoft SQL Server Management Studio.

Proficient in developing Data Flow Diagrams, Process Models. ER Diagrams, Dimensional Data Models using Business Objects.

Experienced in optimizing Stored Procedures, query performance tuning using SQL profiler.

Proficient in Extract, Transform and Load process using SQL server Integration Services (SSIS).

Strong experience in automation of SSIS Packages by scheduling Jobs Creating and monitoring alerts.

Experienced in debugging and troubleshooting SSIS packages by scheduling Jobs, creating, and monitoring alerts.

Expertise in creating multi valued parameterized reports, multi-level cascading reports, drill down, drill through, sub reports, charts and ad-hoc reports using SQL Server Reporting Services (SSRS).

Good Knowledge Quick Sense Management Console in adding users, assigning tokens, creating security rules, streams, upgrading license.

Good team player, strong analytical, written, communicational and interpersonal skills.

Have proven track record working with various environments and a valuable ability to quickly pick up new technologies and become and asset to the company in a minimal amount of time.

Technical SKILLS

RDBMS / Databases: MS SQL Server 2019,2016,2014, Oracle 8i /10g/11g MS-Access 2007, 2010

Languages: T-SQL, Visual Basic, HTML, C, C++, Visual Studio 2017,2015

MS Team Foundation Server (TFS), (RDBMS & SQL)

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports

Integration Services: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Database Tools MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, DBCC, BCP, OLAP, ADO.NET, Database Engine Tuning Advisor (DTA)

Education

Bachelor’s degree in computer and electrical Engineering at University of District of Columbia 2016-2021

Active Secret Clearance

Professional Experience

Kratos and Defence and Security Solution NOV 2021-Present

SSIS/SSRS Developer

Roles and Responsibilities:

Created packages using various Control flow Elements such as Data Flow task, Execute SQL task, Execute Package task, File System task, For Loop Container, For each Loop Container and more.

Developed Stored Procedures, Tables, Views, and SQL Join statements for applications by using T-SQL and PL/SQL scripts.

Used SSIS and T-SQL Stored procedures to transfer data from source databases to a staging area and finally transfer into a data warehouse.

Took Database Full Backup, Transaction log backup, and differential backup in a daily routine.

Performed maintenance of Stored Procedures to improve the Performance of different front-end Applications and scheduled SSIS packages using SQL Server Agent.

Extracted data from various sources (CSV files, oracle, and MS SQL 2000) and stored data into intermediate Staging Database using the SSIS ETL tool.

Applied several required transformations using Data Flow Task in a Staging Database and made the data ready to load into a cloud-based data warehouses (Azure, AWS) and on-premises hybrid data warehouses.

Designed high-level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse and created SQL server configurations for SSIS packages.

Scheduled Reports to run on a daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet.

Performed maintenance duties like Performance tuning and Optimization of Queries, Functions, and Stored procedures; Monitored and improved Performance using execution plans and Index Tuning.

Environment: MS SQL Server 2016, T- SQL, MS Excel, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Visual Studio 2016, Informatics, TFS, CRM, Jiri, Microsoft Azure, Amazon Web Services (AWS), Azure Data Factory (ADF), Python, C#, .NET Framework.

Sun Trust Bank Intern May 2019-Jan 2020

Arlington VA

ETL/SSIS developer

Roles and Responsibilities:

Created user defined Functions, Store procedures, and Triggers.

Experience in creating small packages.

Designed and created SQL Database, tables, indexes, and views based on user requirements.

Worked with the application developers and provide necessary SQL Script using T-SQL.

Wrote complex SQL queries.

Experienced in SQL joins, sub queries, tracing, and performance tuning for better running of queries.

Extracted data from various sources (CSV files, oracle, and MS SQL 2000) and stored data into intermediate Staging Database using the SSIS ETL tool.

Environment: MS SQL Server, T-SQL, DTS, MS Excel, MS Access, VB Script, Python, Oracle 8i /10g/11g, MS-Access.

Sun Trust Bank Intern May 2018-Sep 2018

Arlington VA

ETL/SSIS/SQL developer

Roles and Responsibilities:

Worked SSIS package, DTS import/Export for transferring data from Database (Oracle) to SQL server.

Using reporting server (SSRS) generated various reports.

Developed, deployed, and monitoring SSIS packages.

Created ETL package using SSIS to extract data from stagging tables to partitioned tables with incremental load.

Wrote SQL queries.

Environment: T-SQL, SQL Server Management Studio (SSMS), SQL Server, SSIS, SSRS, SSAS, Visual Studio, Python.

Contact this candidate