Marcos Mesiha Email & Phone Number

Ontario, Canada

The first-choice supplier of software to the online gambling and social gaming industries wasselected as the Ontario Lottery and Gaming Corporation’s (OLG) new digital platform provider.⬥ Worked with customer, old vendor, internal SMEs and other stakeholders to define the source to target mapping sheet for data migration⬥ Performed data analysis on the production data to verify assumptions⬥ Developed the Reconciliation Approach and Data Masking and Obfuscation Logicdocuments⬥ Developed complex test script to mimic the data transformation in the ETL⬥ Managed the Data Migration Testing activities⬥ Developed Testing Strategy and created Data Migration Test Approach, Test Plan, Test cases and Test Scripts for testing the ETL SSIS Packages⬥ Tested Integration with 3rd Parties such as Betbuddy, Paysafe, PLink⬥ Supported the UAT, Dry Runs and Dress Rehearsals

Ontario, Canada

Responsible for the overall quality of the product and was responsible for managing the backlog, analyzing customer’s feedback, working with UI/UX team on the mock-ups⬥ Analyzed customer feedback and ideas and translated them into new features/improvements⬥ Worked closely with the team, and was the go-to person for any questions and ideas⬥ Worked with Data Scientist on developing formulas to calculate the metrics and KPIs according to research both internally and using external data collected from thousands of devices⬥ Worked with other product owners on the integration between the products ⬥ Learned and developed MongoDB queries and aggregation pipeline on both raw and aggregated data for continuous data validation testing⬥ Helped increase the team velocity by highlighting edge cases, minimizing the unknowns and adding more details to the user stories⬥ Helped the QA team members to achieve short and long term goals and expanded our QA team

Ontario, Canada

Hired to build a QA team and apply QA best practices:⬥ Introduced the practice of using Test Cases Management and Bug Tracking tools.⬥ Managed and improved the Quality and Testing processes and played a key role inenhancing the overall quality and value of our applications.⬥ Managed to deliver a high-quality native Android application in 4 weeks in my first 3 months by applying quality best practices after being rejected in UAT for 3.5 months.⬥ Managed the overall testing activities for multiple projects and led the internal UAT with the end users from different departments⬥ Built a QA team including off-shore QAs.

Free Zone Cairo

Worked in multiple products/projects with experience working with customers and gathering requirements as well as working with the product owner to create and test solutions and story writing for a product. Led and coached QA teams on multiple concurrent projects with participation in test cases/scripts development and execution. Created the testing estimated effort, test plan.⬥ Create complex SQL queries to support the ETL and data migration testing⬥ Learned and developed ETL job using IBM DataStage to test complex data loading anddata migration jobs⬥ Solved, documented and created a mock-up for a design challenge on mapping data from different sources to be loaded into one consolidated Data Warehouse.⬥ Developed the testing estimated effort for projects with high accuracy compared to the actual.Sample Project - BI Dashboard for Ministry of Local Development:⬥ Gathered requirements from the customer⬥ Created, defined and validated metrics to be implemented that best serve the customer need and best utilize the data available from Central Agency for Public Mobilization and StatisticsSample Product - Edu 360⬥ Worked with the team to innovate and validate new ideas/metrics that best implement the product strategy⬥ Helped with many ideas that either improved existing features/metrics or even new featuresKey Achievements:⬥ Learned and developed ETL job using IBM DataStage to test complex data loading and data migration jobs which reduced the testing time by 30-40%.⬥ Supported the Performance Testing for 12-15 projects.⬥ Participated in the analysis and gathering of the requirements for external project and Internal Product.⬥ Solved, documented and created a mock-up for a design challenge on mapping different schools’ data to be loaded into one consolidated Data Warehouse.⬥ Developed the testing estimated effort for 5 projects with high accuracy compared to the actual.⬥ Certified ISTQB - Certified Tester Advanced Level – Test Manager.

Developed, executed and maintained test plans, test cases and test scripts for many projects to ensure best achievable project quality. Followed up with the issues until closure, created a smoke test document, reviewed test cases and scripts created by other team members. Coach junior quality engineers and follow up with the testing progress. Key Achievements:⬥ Designed, recorded and executed onsite performance testing for Dubai Government.⬥ Testing BI Reports for Supreme Education Council in Qatar (MS SQL).⬥ Supported the performance testing for many projects as being a member of Performance Subject Matter Experts team.⬥ Developed and executed Automation test scripts for testing 2 telecom projects (Selfcare and eShop).

Free Zone, Cairo

Worked on multiple projects starting from requirements analysis and review, test cases development, test execution and bug reporting.Key Achievements:⬥ Certificates: Oracle PL/SQL Developer Certified , IBM Certified Solution Designer - Rational Functional Tester for Java and IBM Certified Solution Designer - Rational Performance Tester.⬥ Learning tools: Security (IBM AppScan), Automation (IBM Function Tester), Performance Testing (Web Performance Load Tester, Load Runner, Jmeter and IBM Performance Tester), Test Cases Management (ApTest), Bug-Tracking (Jira, Bugzilla).

Giza

Maintenance for the following devices:• Elisa System (Washer & Reader - Dynex)• Auto analyzer System (ACE Alfa Wassermann)• Spectrophotometer System (Stardust MC-15 & FC)• Dry auto analyzer Vitros(950,750,350,250,ECI) (J&J Comp.)• Centrifugal Devices (ALC)

B.Sc. Communication And Electronics, Communication Engineering

Total Grade: Good (71.63%) Rank: 29th Project Grade: Excellent

Education record