Ziyad Ali Email & Phone Number

St Paul, Minnesota, United States

• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.• Validated data accuracy and consistency during the ETL process and assisted in data integration. • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.• Gathered and defined requirements for system integrations, correspondences and data… Show more • Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.• Validated data accuracy and consistency during the ETL process and assisted in data integration. • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.• Gathered and defined requirements for system integrations, correspondences and data conversions• Involved with team in designing, configured and deployed Amazon Web Services (AWS) for a multitude of applications• Software Development Life Cycle (SDLC) and their variants; employed best practices in project management and business requirements gathering.• Ensured all revenue management practices adhered to industry regulations and accounting standards, reducing financial risk.• Prepared Test plan for data integration activities between cross- functional teams. .• Managed end-to-end project lifecycle for implementing Contour solutions, from initiation to deployment.• Defined project scope, objectives, and deliverables for Contour integration projects to align with organizational goals.• Lead project kick-off workshops to establish goals, roles, timelines, and deliverables with all stakeholders.• Conduct workshops to identify potential project risks and create mitigation plans collaboratively.• Played a key role in the implementation and enhancement of revenue management systems and tools.• Working knowledge on Data modelling, Advanced SQL with Columnar Databases using AWS. Show less

Clearwater, Florida, United States

• Perform analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.• Gathered requirements and modeled the data warehouse and the underlying transactional database• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.• Developed Azure Build and Jenkins jobs for continuous Integration and Deployment in Test and Production… Show more • Perform analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.• Gathered requirements and modeled the data warehouse and the underlying transactional database• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.• Developed Azure Build and Jenkins jobs for continuous Integration and Deployment in Test and Production Environment• Collecting user stories and groom them for use by the development team for a major configuration project in Azure.• Create and maintain product backlog items, bugs, features, etc. in JIRA and TFS / Azure for story tracking and documentation.• Facilitated seamless communication between cross-functional teams by centralizing information and discussions on Monday.com.• Collaborated with cross-functional teams to evaluate and enhance revenue management strategies, ensuring alignment with business objectives.• Designed and implemented dynamic pricing models, leveraging data analytics to support effective revenue management decisions.• Assisted with establishing, maintaining and monitoring systems and data integration activities.• Developed detailed project plans, timelines, and budgets for Contour implementation and upgrades. Show less

San Francisco, California, United States

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting a document that contains the essential business elements and detailed definitions.• Working with clients to better understand their needs and present solutions using structured SDLC approach.• Involved in data management and documentation of requirements for the acquisition of data from various source systems to the Enterprise Data… Show more • Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting a document that contains the essential business elements and detailed definitions.• Working with clients to better understand their needs and present solutions using structured SDLC approach.• Involved in data management and documentation of requirements for the acquisition of data from various source systems to the Enterprise Data Warehouse.• Manage data conversion into MS Excel based reporting, Dashboards, and Visualization tools• Create and maintain SQL queries and data connection for automatic data pull from the internal data warehouse.• Created test scripts for all the test cases in PL/SQL.• Conducted market analysis and demand forecasting to inform revenue management strategies and optimize resource allocation.• Liaison between Data Warehouse department and Planning department for data integration into Planning Analytics• Establish and maintain standards for project documentation and reporting to ensure clarity, consistency, and alignment with organizational guidelines. Show less