EYOUAL ASEFA

• Developed ETL packages for data loading from various sources such as flat files, XML files and Oracle databases into the Data Warehouse using SSIS.
• Configured error handling for all SSIS packages by establishing connection managers, event handlers and logging to track package execution status.
• Created complex SSIS packages with multiple transformations such as derived columns, lookups, conditional splits, script tasks and execute SQL tasks.
• Optimized existing SSIS packages by performing performance tuning activities like reducing redundant operations, replacing Lookup and Merge Join with Hash Match.
• Collaborated with database administrators to design database objects including tables, views, stored procedures and user-defined functions required for ETL process.
• Tested ETL processes thoroughly prior to deployment in production environment by writing test plans and executing unit tests.

• Developed and tested software components to ensure quality, performance, and scalability.
• Analyzed customer requirements and designed solutions for complex problems.
• Created technical documentation for all development efforts.
• Participated in the design of user interfaces, back-end systems, and databases.
• Implemented automated testing processes to improve product reliability.
• Performed unit tests to verify accuracy of code changes.
• Created database objects like tables, views, indexes and synonyms in Oracle 11g and 12c databases.
• Optimized existing queries for better performance using SQL query tuning techniques.
• Designed complex reports using SQL Server Reporting Services.

.

• Installed and maintained computer systems, networks, printers and scanners.
• Monitored system performance to ensure proper operation of the network and security protocols.
• Developed software applications to meet organizational needs.
• Provided technical assistance to users with hardware and software issues.
• Created user accounts, set passwords and provided access rights to users.
• Implemented backup procedures for data recovery in case of system failure or disaster.
• Tested new technologies and developed strategies for their successful integration into existing systems.
• Managed IT projects from conception through completion.
• Performed troubleshooting on all hardware, software, networking components and peripherals.
• Resolved customer complaints regarding IT services in a timely manner.