Omar Abdalla Email & Phone Number

Cambridge, Ontario, Canada

ERP System Development:Led the creation of a comprehensive ERP web application using Node.js, React.js, SQL Server, S3, and AWS.Designed and maintained robust MS SQL Server databases, enhancing data integrity and security.Optimized AWS services, improving system reliability and reducing operational costs.Developed real-time data pipelines handling hundreds of thousands of records, ensuring data accuracy and timeliness.Integrated multiple APIs (DMS, CRM, social media ads) for data synchronization.Unified metrics across departments into a single, actionable dashboard.Automation and Data Integration:Implemented strategic automations to boost operational efficiency:Automated daily reports, reducing data processing times from hours to minutes.Authored Node.js scripts for generating and distributing five daily reports, minimizing manual data handling.Streamlined month-end processes, reducing time from days to hours.Developed Python and Node.js scripts for API data integration into SQL Server, enhancing data flow to visualization tools.Data Strategy and Analytics:Innovated marketing data strategies, reducing lead acquisition costs by 25% and doubling sales conversion rates.Engineered a Python-based predictive model for financial forecasting across 40+ locations, aiding strategic planning and funding.

Cambridge, Ontario, Canada

Waterloo, Ontario, Canada

• PSYCH 207 – Cognitive Processes & PSYCH 261 – Physiological Psychology• Mentored undergraduate students on both personal and school related matters; students who were given my assistance performed above average • Provided feedback to course instructors for continuous improvement of course delivery according to students’ level of comprehension

Waterloo, Ontario, Canada

• Developed and deployed complex data models and ETL pipelines using Python and SQL, enabling the extraction of key research insights from multi-source data sets.• Implemented advanced data processing techniques, including handling outliers, missing data imputation, and data normalization for datasets exceeding millions of records.• Collaborated with various departments to uncover actionable insights, presenting findings to executive leadership and key stakeholders through comprehensive dashboards and reports.• Designed and automated data collection and integration processes, ensuring data accuracy and availability for over 2000 users.

Kitchener, Canada Area

• Instructed classes on Basic Life Support, First Aid, CPR, and refresher courses - Infant/Child/Adult.• Consistent five star reviews of my teaching and communication style; according to one student I gave "the best presentation I've seen in my 20 years of corporate"

Waterloo, Ontario, Canada

•Streamlined the recruitment process that brought in hundreds of participants exceeding sample size expectations by 15% •Influenced the design of a published psychological study by offering tighter experimental conditions that eliminated potential confounding variables

Master Of Arts - Ma, Psychology

Investigating boredom in the Cognitive Neuroscience department, under the supervision of Dr. James Danckert. My project explores cognitive.

Joint Honours Science And Psychology, Biomedical Science And Psychology

Produced an exceptional honours thesis project at a high level of independence with a final score of 92/100. Honours Thesis: "Exploring.