data engineer - it
Andalusia Group for Medical Services
Total years of experience :4 years, 3 Months
Responsibilities:
Collecting, managing, and converting raw data into information the
organization parties can interpret.
Implement methods to improve data reliability and quality.
Design and implement data warehouses.
Develop ETL solutions.
Build data cubes for analysis.
Projects:
Contact Center (outbound) data war ehouse and analysis cube:
Digital T r ansformation Unit
Collecting all leads and the outbound activities carried out on them through
the medical and non-medical CRM teams, and showing the achievement of
each department and the details for each campaign, lead source, activity, and
agent.
P A CS and Healthcar e Systems:
R & D Department
Integrating data from PACS (picture archiving and communication system) with
the main healthcare system by loading all the medical imaging data and
patient episodes in a data warehouse. the data cube shows the number of
series per patient, TAT, and the compliance percentage of written reports per
physician.
CPG Car e Calendar:
Digital T r ansformation Unit
Extract the CPG (Clinical Practice Guidelines) details such as services, date,
frequency, and duration. Determine the date of all upcoming visits according
to the frequency and duration, and load all findings into a data warehouse.
extract reports show the most commonly used CPGs, the percentage of
compliance with the request guidelines out of the actual number of visits per
physician, financial return, or potential loss in cases of order and non-ordered
CPGs.
Responsibilities:
Proficient in performance tuning to optimize database operations and enhance overall system efficiency.
Demonstrated expertise in creating and maintaining database structures, ensuring data integrity and scalability.
Designed and implemented new databases, tailoring them to meet specific project requirements and business needs.
Conducted thorough testing of database code, including queries, stored procedures, functions, and triggers to ensure reliability and functionality.
Developed and executed strategies for continuous improvement, staying abreast of industry best practices in database development.
Collaborated with cross-functional teams to gather and analyze requirements, translating them into effective database solutions.
Played a key role in troubleshooting and resolving database-related issues to minimize downtime and optimize performance.
Actively participated in the planning and execution of database-related projects, ensuring successful and timely delivery.
Maintained documentation for database structures, configurations, and processes to facilitate knowledge transfer and future enhancements.
Develop subprograms needed by the work routine and not supported in the main system using SQL Server and reporting tools like SSRS and Power BI.
Support DBMSs like (DotCare Healthcare, CRM Dynamics, Zoho Service Desk, Odoo, and PACS)
Responsibilities:
Correct errors by making appropriate changes.
Rechecking the program to ensure that the desired results are produced.-
Write, update, and maintain computer programs or software packages to
handle specific jobs such as: Tracking inventory, Storing or retrieving data, and
Controlling other equipment.
Responsibilities:
Analysing sales of all items in the branch.
Calculating the shrinking or growth.
Study its causes by analysing the dates of supply.
Alternative products, price changes and offers.
Submit proposed orders according to sales rate and stock quantity.
Graduation Project: 4ebaak an android application and web application that provides an open gate for students for all ages to achieve the knowledge and skills needed for the job market. Role: System Analysis and database