Mohamed Elsayed Email & Phone Number

New York, NY, US

NY, NY, US

• Created pivot tables in Google Sheets to summarize and analyze large transactional datasets.
• Created VLOOKUP’s to combine data from several Google sheets and put it all into one sheet.
• Manage and manipulate data in Verizon's concession database tables using Oracle’s Sql DML (Data Manipulation Language) commands, to continually update and refresh concession inventory.
• Work closely with management on ad hoc projects, involving writing complex SQL queries in Oracle to extract requested data-insights. Project results were reported to management, and the data was used to make informed.
• Involved in cross functional team meetings designed to problem solve daily tasks, using SQL and data analytics to strategize solutions.
• Recommend to management operational efficiencies, proposed to monitor equipment inventory at Verizon concession stores. Report recommendation approved and utilized daily.

New York, New York, US

• Analyzed large amounts of complex SQL code housed in a data warehouse for MIS’ Credit Rating Quantitative Tools program. Identified the code's structure and application purpose, in an effort to reduce systemic.
• Effectively communicated SQL code and risks in an easy-to-understand method to non-technical shareholders and software development teams, to be presented to Management, ultimately to help Moody’s produce the most.
• Independently managed a large personal portfolio of SQL code assignments, prioritizing importance of assignments in a fast-paced environment with many deadlines.

New York, New York, US

• Used Python package, Pandas, to clean around 5,000 rows of transactional web based donations on a daily basis.
• Wrote high-level SQL queries to analyze data to answer detailed financial questions about several fundraising initiatives to help senior management make better decisions regarding marketing campaigns and new outreach.
• Created interactive filters, parameters, and calculations for dashboards in Tableau.
• Maintained and Managed existing dashboards in Tableau to provide up to date and accurate data.
• Worked closely with multiple stakeholders throughout UNICEF, including senior level management, senior accountants, and revenue processing supervisors, on data-based projects designed to help increase donor’s awareness.
• Facilitated fundraising events by helping input event data into BBCRM financial database. Help coworkers’ access BBCRM database by creating usernames and accounts.