Ziyad Ali Email & Phone Number

Camden, New Jersey, 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 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.

Detroit, Michigan, 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 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.

Newark, 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.
• 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.