Michael Dawoud Email & Phone Number

Rochester, Ny, Us

Rochester, Ny, Us

Rochester, Ny, Us

Data quality testing of a mixed near-real-time and weekly load ETL (Extract, Transform, and Load) system used for customer reporting which includes Oracle to Oracle data transformations.Design and development of a data test framework used for both automated and ad hoc manual testing. In addition, develop automated test framework using Python to process ETL testing data. The framework resides on the database and uses functions, stored procedures, and queries to test both initial and incremental loads.Part of a team using Agile methodology that conducts daily scrums, sprint planning, quarter planning, and more.Tools and Technologies include:- ODI (Oracle Data Integrator) 11g and 12c- TOAD- TAF (in-house Automation Center)- Delphix VDB- BitBucket and Git Extensions- VS Code- Pycharm- SQL and PL/SQL

Pittsford, Ny, Us

Implementation of end-to-end enterprise Business Intelligence (BI) and Analytics solutions: • Created Relational & Multidimensional data models (Star and Snowflake schemas). • Developed ETL using SSIS. • Designed and Implemented dimensional data models to facilitate Ad-Hoc reporting using the flagship BI application on iOS, Android, and Windows. • BI report design, development, enhancement, and support. • Customer engagement and scoping for initial data assessment and problem-solving.Partner On-Boarding North America, Europe, Africa, and Middle East: • Created training curriculum and trained sales, partners, and implementation teams. • Created, maintained, and published product requirement & specifications, and technical and training documentation. • Supported client and partner teams in enterprise deployment and problem resolution. • Acted as a liaison between client/partner teams and the iVEDiX product teams to incorporate customer/partner requirements & prioritize feature development.Technology/Software: • Microsoft SQL Server 2012 & 2014 • mySQL • Microsoft Business Intelligence (MSBI - SSIS) • ER Studio (Data Modeling)

San Ramon, California, Us

• Provided support to ERP warehouse management systems, Baan and Red Prairie, and ensured that the production environments are operational. • Provided support to customer packaging and shipping teams for Ad-Hoc data analytics and extracts. • Monitored Service Desk tickets and resolved or escalated based on service level agreements (SLAs). • Managed support of critical systems to ensure compliance and production downtime (offsite and onsite). • Managed communication with customers including shift coordinators, supervisors, and managers to ensure orders are processed before shipment deadlines.