PL/SQL,ORACLE 11g, 10g, 9i, 8i, MYSQL, MS Access 2000, J-developer, SQL-Developer, SQL Plus, SQL Navigator 4.5, SQL LOADER, TOAD 9.7.2, Tortoise SVN 184.108.40.206, Erwin 4.1, IBM Rational Rose and UML Design, Load runner 5.0, Winrunner, Informatica 8.6, Crystal Reports, OEL oracle enterprise Linux , Unix, Online Analytical Processing OLAP , Relational databases analysis, design, development, GUI design, development, Online Transaction Processing OLTP , client/Web server systems
Confidential as a lead developer in the BaselDBO database, he was responsible for the new design and development of the Basel II for risk analysis. He was responsible for writing PL/SQL procedures and packages to calculate RWA risk weight assets , LGD loss given default and generate reports based on legal entity id and product ,supplied by the end-user. Confidential other roles included the reverse-engineering of the current schema and partitioning of tables and adding new data files to existing tablespaces to increase space. Also, responsible for production support of high priority code fixes for a major release and modified the SQL in procedures to enhance java component. He implemented new functionality to existing oracle margin-loan functions , and added to calculate the loan to value ratio calculation
Sr. Oracle Developer
Confidential as a senior Oracle developer for the PostalOneProject works in a team of 5 developers to analyze, design, and develop modules using Einduction methodology by following IDEAlliance industry Database standard for efficient communications and mail processing services. Mr. Tesfaldet reverse-engineered the MAILXML data model using SQL Developer's data modeler tool and added 30 tables. To date, his responsibilities also include the implementation and development of releases 32.0.0, 33.0.0 application by coding/developing oracle Programs using PL/SQL which extract data from external sources such as BID business intelligence data and MID system for surface visibility in database designed and implemented in RAC using parallel execution. In addition, Mr. Tesfaldet enhanced and optimized the existing programs to meet optimum query performance by analyzing the execution plan and modifying code using analytical functions and sub-query factoring. In the process, he created oracle scripts that create and partition objects.
Confidential also worked on IFC's Risk management portfolio Applications for WORLD BANK GROUP. His responsibilities included writing new procedures using oracle analytical functions and tuning existing packages to meet front-end application needs. He reverse-engineered the ODS data model and made enhancements and wrote the technical requirement document to meet the business functionality.