Mohamed Hegazi

• Worked with Product Support team to provide troubleshooting and root cause analysis of VMware - Tanzu Postgres Database software (Greenplum)
• Contributed to development of support methodologies for troubleshooting Database functional and performance problems through analysis of Database and application logs using Python Data Science libraries.
• Participated in product testing of new Database Software features.

• Technical experience in analyzing and troubleshooting Teradata DBMS products and process including troubleshooting Database software general features, dump analysis, performance analysis, and Database file system recovery
• Technical experience in software development and data analysis through working individually and collaboratively with different product support teams to automate Global Support process, data collection, and analysis

Projects:

• Perfscan (Python): Developed in 2020-2021 as a set of Python scripts to perform deep analysis of data contained in log archives which are extracted from customer systems during general system performance problems. Findings by analysis of multiple text based logs are consolidated into analysis summary and a list of recommended actions
• MHop (Java): Utilized SSH connectivity API to automate and simplify multi-hop connections and port forwarding to Software machines
• Data Collection Tool (Java): Joined a team of developers from various support teams and interns in 2015 for developing a project to transform Level 1 data collection checklists into a desktop GUI application for automating collection of data that is required for deeper levels of problem analysis. The tool was released with options to collect data at multiple support areas
• Configuration Parser (Java): With Problem recreation and simulation being a key process for troubleshooting most areas of DBMS, a desktop GUI tool was developed in 2013 for parsing customer configuration settings, automated comparison and matching on in-house systems for supporting problem simulation and recreation efforts.

• Technical Experience in analyzing and solving problems with Teradata DBMS, and other Teradata product areas
• Utilized Java programming skills in developing multiple tools for automating various support level tasks in areas of dump analysis, and problem recreation

Projects:

• Problem Recreation Tool (Java): Developed for automating common problem recreation steps that are involved in analyzing query failure and performance problems
• SQL Cleaner (Java): Developed for refining Database dump extracted SQL from various in-memory formats.

• Joined Teradata team for ongoing system implementation project, developing Data Model integrity test

• Attended Teradata Structure, Administration, and Professional Services process courses
• Learned and practiced designing, developing and monitoring ETL projects using Informatica
• Learned and practiced designing, managing and monitoring ETL projects using Oracle ODI
• Developing .NET based Smart ATM application– Simplified CRM Application.