Senior Software Engineer/Analyst
CME Offshore
Total years of experience :18 years, 3 Months
Insurance project - Claims Management System:
a) Reviewing and following up the team’s work
b) Putting the rules and standards on the database architecture, reviewing the whole design to make sure the right rules and conventions are used by the team for the cleanest and most reliable design.
c) Reverse engineering the client’s database to understand the business and technical points and communicating the requirements with the clients.
d) Writing and supervising the whole process of migrating the database of the insurance company Oracle database into the newly created Oracle 12c database.
d) Leading the team to use the required standards for a clean and dynamic solution.
• Telecom Expense Management Project:
a) Developing a complete Data Warehouse, designing and implementing the whole data migration from an Oracle database to a Sap HANA database.
b) Mentoring/reviewing the team work and advising the team for the best solutions to be used.
c) Communicating with the client the best solutions to follow
d) Guiding the QA team abroad to explain and clarify the new system and how it works so they can use the correct and accurate scenarios
• Developing enhancements and fixing defects in a telecom expense management data warehouse project. Doing all the necessary communications with the client and the QA team. The project consists of a complete data warehouse and an ETL process where direct contact and meetings were with the client in the US. The defects and enhancements include performance issues (solutions using hints, explain plan studies, views and materialized views, indexes, table partitioning, pipelined functions, …), data transformation issues (using tables, staging tables, staging code, oracle packages, procedures and functions)…
Involved in all phases of the projects that include analysis, design, development, testing and maintenance.
a) Developing database objects using Sql*Plus, PLsql, SQL developer and Oracle Enterprise manager (tables, views, indexes, constraints, triggers, functions, stored procedures, packages).
b) Developing user-friendly modules, reporting applet and interfaces following business logic requirements to facilitate and secure the work and the data management.
c) Training users and assisting them to use the ERP application.
The work was concerning all types of credit and debit cards owned by clients. The client can be a person, a bank or a company. The development process was to facilitate the work of the bank's departments and the company's clients in the banking sector. It included banking programs, operational programs, statistical procedures and reports...
• Software Development using Oracle Forms and Sql*Plus.
a) Effectively using and creating stored procedures, functions, packages, indexes, constraints, triggers, pipelined functions, views and materialized views.
b) Optimization and performance tuning (indexes, materialized views, table partitioning and materialized views partitioning, pipelined functions, optimizer, hints and stored outlines).
c) Developing modules using Oracle Forms 3i under UNIX.
• Developing modules using C Language
• Involved in the continuous enhancements and problem fixing of existing modules and procedures.