Syed Jawwad Ali

• Leveraged advanced SQL queries to identify and prioritize potential systems for Forensics audits.
• Conducted various audits, including 0*, ILA 0 confirmation, SPI, Minimize, and Cloud Sandbox, to enhance data management and quality within the Comcast ecosystem.
• Leveraged data visualization tools to effectively communicate business insights.
• Utilizing JIRA's features to efficiently create, identify, and resolve issues in a timely manner.
• Created a comprehensive BIGID Regular Expression documentation to facilitate future classifier development.
• Developed Regular Expression (regex) for OOS database cleaning and created Kibana reports for dx data foundry insights.
• Performed inaugural manual audit of BIGID scan system, identifying discrepancies and recommending regex enhancements.
• Audited over 200 BIGID scan systems, both automated and manual, delivering detailed feedback and an Executive Summary to track and analyze findings.
• Identified and escalated multiple issues in S3 systems during BIGID scan audits, coordinating with stakeholders for timely resolution.
• Collaborated with the BIGID team to enhance regex functionality based on audit tool feedback, analyzing results and communicating findings to leadership.
• Collaborated on stewardship audit tool requirements documentation and conducted UAT, identifying and reporting various issues.
• Developed and maintained documentation for the stewardship audit tool, including issue resolution, user feedback, and change request processes.
• Developed "Auditor User Guide" to streamline the audit process for new team members.
• Resolved issues in Audit Tool database reports by collaborating with relevant authorities.
• Supported the ILV team in meeting quarterly targets by completing over 40 pre-analysis and ILV calls.
• Assisted in identifying and escalating UI issues in the CPP Survey during ILV calls for quick resolution, while offering feedback to enhance the ILV process.

• Executed data mapping between data mart and source systems.
• Supported data management, governance, and quality initiatives for master data.
• Utilized Teradata Studio and SQL Assistant for code execution, data querying, validation, and large-scale analysis.
• Consolidated data from diverse sources onto Teradata platform, enhancing accuracy and reducing data gaps.
• Developed complex SQL queries for Teradata and SQL Server databases.
• Created comprehensive reports using SQL Server and Microsoft Excel.
• Conducted timely data reviews and responded to lender and vendor inquiries.
• Utilized Microsoft Excel and Access for data manipulation, cleansing, and processing of large datasets.
• Applied data analysis practices to solve specified problems and generate analytical reports.
• Implemented a business intelligence strategy ensuring data security, integration, and accessibility.
• Performed in-depth source data analysis and source-to-target gap analysis, documenting mappings for ETL design.
• Developed SQL reports, data extraction, and loading scripts for various databases.
• Contributed to the development of business requirements, GAP analysis, use case diagrams, and data flow diagrams.

• Conducted data cleansing for legacy system migration to new data warehouse and performed data conversion validation testing.
• Utilized PL/SQL tables and Bulk loader programs for data processing and Oracle table loading.
• Applied analytical and methodical approaches to problem-solving, root-cause analysis, conflict resolution, and negotiation strategies.
• Demonstrated proficiency in various testing methodologies, including system, integration, UAT, and regression testing.
• Developed test cases for Enterprise Data Warehousing (EDW) and Data Mart Staging Tables.
• Executed User Interface Testing, System Testing, and Data Quality Testing on configuration designs and prototypes.
• Created Data Dictionary and ER diagrams for data mapping purposes.
• Performed source data profiling to ensure alignment with business requirements.
• Collaborated with technical team to prepare ETL documentation for Teradata to SQL data migration.
• Optimized performance of Informatica sessions for large data files.
• Managed weekly data loads to maintain up-to-date database information on addresses, user, and customer details.
• Actively participated in gathering and analyzing end-user requirements and system specifications.

• Identified and validated high-potential business opportunities for stakeholders.
• Gathered and analyzed business requirements and workflows, defining scope and progressing from problem statements to well-documented designs.
• Processed and transmitted customer claims based on requests.
• Demonstrated excellent knowledge of retail and e-commerce, providing problem-solving assistance.
• Conducted functional walkthroughs and User Acceptance Testing (UAT) sessions.
• Developed various diagrams (Use Case, Business Flow, Activity/State, Sequence) using MS Visio to enhance stakeholder understanding of business processes.
• Worked through the entire Software Development Life Cycle (SDLC), from requirements to implementation and testing.
• Led efforts in drafting, reviewing, and approving artifacts, including use cases and test cases, while tracking stakeholder enhancement requests.
• Implemented Agile methodologies and utilized Jira for project progress tracking and product backlog creation.
• Performed data analysis and profiling using SQL on various source systems.
• Collaborated with multiple retail departments to gather data requirements and facilitate Data Mart loading.

• Gathered and documented user stories, use cases, business requirements, and functional specifications through stakeholder interactions, including control team partners.
• Performed GAP analysis, created product functionality matrices, and developed prototypes.
• Developed automated workflows and approval processes for sales opportunities and lead routing.
• Ensured effective cooperation with stakeholders and supported day-to-day operations across key business units.
• Executed data validation scripts to ensure delivered data aligned with consumer requirements, performing data comparison and reconciliation.
• Conducted logical data model walkthrough and validation.
• Analyzed business requirements and mapped source data using the Teradata Financial Services Logical Data Model tool to the Teradata Physical Data Model.
• Created Data Functional Design documents.
• Documented customer issues and provided progress resolution updates to management.
• Collaborated with project managers and database administrators to ensure smooth operations and promptly identified, tracked, reported, and resolved issues.

• Acquired knowledge in technology areas, adhering to architectural standards and established methodologies.
• Participated in application lifecycle activities, from development through maintenance stages.
• Contributed to discussions on business issue solutions and project planning.
• Supported the development of internal tools, deployment solutions, and processes for the development team.
• Gained experience in analyzing functional components and designing technical solutions across multiple areas.
• Collaborated effectively with teams while taking individual responsibility for assigned software development tasks.
• Developed knowledge in data mapping, specifying data extraction, transformation, and transmission processes.
• Participated in Joint Application Development (JAD) sessions to address critical issues.
• Played a key role in planning, testing, and implementing system enhancements and conversions.