Zia Ahmed
Lead data quality analyst
Suwanee,GA
Summary
Dynamic and results-driven professional with over 20 years of extensive IT experience, specializing in data quality analysis and BI testing and development. Proven track record of enhancing corporate data quality and achieving BI objectives, leading to significant reductions in validation costs while ensuring stakeholder satisfaction. Expertise spans a diverse range of domains, including web analytics, financial institutions, and data warehousing, with successful leadership of multimillion-dollar initiatives delivered on time and under budget. Detail-oriented in data analysis and adept at identifying key problem areas, consistently fostering cross-functional collaboration to deliver high-quality results through hands-on leadership and technical acumen.
Overview
24
24
years of professional experience
Work History
Senior Data Quality Analyst
SPH Analytics.com
05.2018 - 04.2026
- Researched and determined scope and complexity of issues.
- Improved data quality by implementing rigorous validation processes and automated checks.
- Implemented robust monitoring systems to track data quality metrics, facilitating continuous improvement initiatives.
- Ensured timely delivery of accurate reports for stakeholders by streamlining reporting processes.
- Assisted in database migration projects, ensuring a seamless transition with minimal impact on data integrity.
- Enhanced data accuracy through meticulous review and cleansing of large datasets.
- Developed comprehensive documentation on data quality procedures, enabling standardized practices across the organization.
Quality Assurance Analyst III
GPC
05.2017 - 05.2018
- Responsible for testing and maintaining TAMSII POS retail application
- Responsible for supporting various data mart and reporting solutions
- Developed and implemented test cases to ensure product quality and functionality.
- Collaborated with cross-functional teams to identify and resolve software defects.
- Conducted regression testing to validate system updates and enhancements.
- Analyzed test results, documenting findings for continuous improvement initiatives.
- Led efforts in establishing best practices for QA methodologies and processes.
- Mentored junior analysts on testing techniques and quality assurance standards.
ETL/ Data Warehouse Test Lead
TCS/Carnival cruise line
01.2017 - 05.2017
- Responsible for building a new data warehousing test team on onshore offshore model
- Responsible for developing POC to automate BI testing with Informatica DVO
- Led testing initiatives for software applications, ensuring alignment with Carnival's operational requirements.
- Coordinated cross-functional teams to enhance testing processes and drive project success.
- Developed comprehensive test strategies that improved overall product quality and user experience.
- Mentored junior testers, fostering skill development and promoting best practices in quality assurance.
Data Quality/ ETL Test Consultant
Cox
06.2015 - 09.2016
- Responsible for coordination of call center Production data quality issues and resolutions for customer care team spread across the states and offshore
- Worked close with the data steward and do data profile on metadata and data
- Developed and implemented test plans to ensure comprehensive coverage of all application functionalities.
- Collaborated with cross-functional teams to identify issues and drive resolution for software defects.
- Analyzed test data to identify trends, improving overall testing efficiency and effectiveness.
- Oversaw the execution of regression testing cycles, ensuring stability of software releases across platforms.
- Streamlined communication between development and QA teams, resulting in improved collaboration and faster issue resolution.
Sr. Data Quality Analyst consultant
Manheim/Cox Automotive Group
03.2014 - 06.2015
- Responsible for data profiling in the source systems in Agile SDLC
- Engaged in data quality initiatives of Omniture Site Catalyst Web Analytic platform conversion project from Web Trend.
- Responsible for checking data quality in the web analytics data warehouse/reporting
- Responsible to data quality check in MDM source tables
- Validated Jason tags, server calls and tested REST API with SOAP UI embedded in 7 Manheim websites including IOS, Android phones and Tablets
- Created business requirements and validate that it is transformed into technical specification document and perform a thorough gap analysis and recommend fixes
- Analyzed different data sources and create data flow document for Data validation
- Validated BI data from multiple consumer facing websites and mobile devices is captured in the 'Adobe Cloud' and FTP to Manheim as data warehouse feed
- Environment: Java, java script, Webtrend, Omniture Site catalyst, XML, MDM, Microsoft BI Stack.
Sr. lead Data Quality Analyst/BI/ETL
AutoTrader.Com
07.2008 - 03.2014
- Built the Auto trader.com EDSS QA team from scratch and hired and mentored new hires
- Implemented QA process and methodologies and monitored the adherences
- Documented QC artifact in HP ALM
- Reviewed and analyzed business requirement and functional requirement doc and make appropriate recommendations if applicable
- Lead extensive data profiling on the source data system in Agile environment
- Responsible for analyzing the technical specification doc, data model and prepare the test strategy, test plan, test cases and test scripts.
- Responsible for estimating the QA work efforts and the respective timeline
- Lead QA activities throughout the SDLC from initiation to implementation
- Validated Jason Tags, server calls and Rest API with SOAP UI embedded in website
- Validated Micro strategy reports
- Worked closely with ETL Lead, DBA, BI BA and Project Manager on project deliverables
- Responsible for testing the accuracy of the web analytics piece of the BI application
- Responsible for testing newly build MDM with Informatica IDD.
- Verified web strings in the Apache web log are parsed and loaded in the staging tables
- Responsible for data profiling of the source stage tables and make sure they conform to the acceptable company standard
- Developed complex SQL mimicking the actual Informatica ETL mapping to test the ETL transformation rules and the data load into the target fact tables in different databases
- Tuned test SQL to optimize the performance on a billion rows table
- Tested the financial revenue share report derived from the Fact tables of the EDW
- Responsible for integration testing of many internal CRM applications
- Tested multiple reports developed with Micro-Strategy and SAS
- Performed post production regression testing after deployment
- Responsible for first line of defense on all production ETL and reporting issues
- Worked closely with the ETL developers, Report developers and DBAs during code migration to QA and Production from Development Environment
- Responsible for testing Mobile devices including IOS and Android.
- Environment: J2EE/Java, Apache web server, Oracle, Microsoft BI stack, Netezza, Sun UNIX, Informatica, and Micro strategy, SAS, MDM, XML, Open source reporting server.
Lead ETL QA / Reporting Analyst
Macy's System and Technology
11.2007 - 07.2008
- Documented QC artifact in Microsoft Team Foundation Server
- Followed Q4M methodologies and processes in all levels of SDLC
- Analyzed and review System, Functional, Technical Requirement Documentations
- Created test strategy document based on analysis of System Requirement Document
- Created test plan, test cases and test scripts based on the System Requirement
- Tested the data extracted from mainframe and loaded in the Teradata EDW with BTEQ
- Tested conversion and consolidation of data within multiple divisions of Macy's EDW
- Tested 50 + different Merchandising reports extracted from Enterprise Data Warehouse with Business Object and Cognos
- Created UAT test cases and scripts for the project stake holders
- Wrote complex SQL queries to validate data in different system
- Navigated different CICS screen to validate data as a source
- Tested integration between multiple system and validated the data flow
- Participated in daily bug meeting with the development lead and resolve testing issues
- Environment: Mainframe, Teradata, DB2, Oracle, Business Object, Cognos and Windows
SR ETL QA Analyst
Chevron/Texaco
07.2007 - 11.2007
- Worked closely with the Microsoft Services Consulting development team
- Followed Agile/scrum development methodology without any formal documentations
- Tested the Web Report Portal MINERVA based on the business logic and business rules
- Performed data profiling on the source databases to check for data inconsistencies
- Imported different source data with link server into the testing environment for testing
- Executed very complex SQL queries to validate and verify data set per business rules
- Verified the ETL load of Microsoft SQL server SISS Packages from different data sources and made sure it is loaded in the Minerva Cube as per the business logic
- Verified that the data extracted from the Minerva Cube with Microsoft Analysis Service are displayed accurately in the reporting web portal
- Tested corporate web portal developed with C sharp and Microsoft dot net
- Open defects and track resolution on Microsoft Team Foundation Server
- Discussed project progress and issues in the daily scrum meeting with the development team, program manager, scrum master
- Responsible for testing different out going extract files created in XML for different corporate ERP applications
- Environment: Microsoft SQL Server 2005, MSDN, Microsoft Integration Services and Microsoft Analysis services, Oracle, Dot net, XML, C sharp and UNIX
Lead ETL QA Analyst
Cingular/AT&T
03.2007 - 06.2007
- Worked closely with the Deloitte consulting team
- Lead and Prepared test strategy, test plan and test scripts based on the design documents
- Tested interfaces of Apple Computer with Cingular Business Intelligence database
- Tested the revenue sharing joint venture application of Apple computer and AT&T
- Performed data profiling in the source databases and checked for data anomalies
- Performed data analysis based on the business logic in business Intelligence database coming from the various front end ERP applications through Informatica mappings
- Tested Extract files, extracted from Business Intelligence Database for other ERP front end and back end applications
- Created database object model with MS Visio to track data movement in the ERP apps
- Executed complex SQL queries based on the business logic and validated target database and Extract files
- Tested Business Object reports generated from business intelligence database
- Opened bugs in Mercury Quality center
- Participated in the bug report meetings and updated test lead with resolution
- Environment: Teradata, UNIX, informatica, Oracle, Telegance, Care, Amdocs and XML
Callidus / ETL QA Analyst
Bellsouth
09.2006 - 02.2007
- Tested 3rd party Callidus Sales Incentive Compensation Application for the Bellsouth Human Resource Department
- Prepared test strategy, test plan and test scripts based on the Work Requests and Design Documents and Detail Design Documents
- Walked through the user acceptance test results with the business
- Responsible for Level 2 production support for production issues
- Tested incoming data feed from different data marts including HR's People Soft and Siebel CRM
- Confirmed that data is parsed, transformed and loaded per business logic in the Oracle data warehouse through the Informatica mappings
- Tested the accuracy of custom reports generated by the Actuate report server
- Tested the out going payout file sent to the human resource dept.
- Opened up bugs with Mercury Quality center
- Environment: Oracle, Teradata, UNIX Sun Solaris, Informatica, People Soft, Siebel, Brio, Actuate Server, Java, Callidus True Comp
Lead ETL QA Analyst
TSYS - ESC Loyalty
04.2006 - 09.2006
- Developed Test Strategy from Use Cases, Requirement Documents and Software Specification Documents.
- Created Test Plan, Test Cases and Test Scripts in Rational Test Manager
- Install and Configured Oracle client, Toad, Win-SCP, Ultra Edit and Rumba in all QA environment
- Test incoming EBCIDIC nightly batch Files from TSYS TS2 platform and certify that they were loaded in ESC Loyalty's Oracle Platform via the ESC-Loyalty's credit card Reward engine
- Test real time Data packets coming from TSYS TS2 platform in XML format, per XSD and make sure they get loaded in the ESC Loyalty Oracle platform via the ESC-Loyalty's Credit Reward Engine
- Test nightly outgoing Reward files to TSYS TS2 platform in EBCIDIC format
- Test Program configuration of the ESC-Loyalty's Java based Reward Engine
- Test initial conversion account load and historic transaction load via ETL from TSYS TS2 Platform
- Test the cron jobs and see it they are running according to the schedule
- Test account activity history report created by IBM Hyperion application
- Work as a client UAT and production support
- Helped other junior analysts with directions
- Environment: CICS mainframe, Oracle, Informatica, Teradata, Solaris, Windows XP, Java, Jboss, XSD, XML
Lead ETL/Integration Tester
Compu Credit
07.2005 - 03.2006
- Wrote Test Plan, Test Cases and developed Test Strategy based on the FSD and Use Cases
- Wrote complex SQL queries to validate the Informatica ETL load in Oracle Database
- Wrote DML script to create test conditions in the Database
- Tested the Tidal job scheduler to verify if the job scheduler ran as scheduled in Unix environment
- Tested file transfers with the FDR (Credit Card Clearing house), TSYS, Equifax, and Certegy
- Tested loan funding process with ACH processor
- Tested Business Object reports
- Tested User Interface on Java based company website
- Updated project related documents in VSS and CVS
- Reported bugs in Compu Ware Track Record
- Coordinated project meetings if showstoppers ware detected
- Participated in Technical team meetings in all development life cycle from requirement gathering to QA sign off.
- Helped other analysts with technical questions and solutions
- Environment: Oracle, SQL-Server, FDR (CICS Mainframe), Informatica, Unix, Windows XP, Mainframe, Business Object, Java, Dot Net and C sharp, XML
ETL QA Analyst
Premier Health Care
11.2001 - 05.2004
- Worked along with EDW team to create test scripts for validating data loaded
- Executed, tracked and worked with QA to mitigate testing
- Executed test scripts according to the test plan and document all test results
- Participated in review meetings to discuss test script and test results
- Used SQL queries to check the Oracle database and automated the trade's history data
- Validated data at each transformation throughout the ETL process. Documented consistent error patterns. Tested different transformations created by using Informatica
- Environment: ETL Informatica Powercenter 6.1, Business Objects 6.5, PL/SQL, Oracle8i, Solaris 7, Windows NT, Test Director 7.0, Toad.
Education
Bachelor of Science - Network and Communication Management
DeVry University
Atlanta, GA09-2004
Bachelor of Science - Business Administration
DeVry University
Alpharetta, GA09-2004
Skills
- Proficient in agile methodologies
- Full-cycle integration testing
- Validation of data migration
- Data analysis using Data bricks
- Data quality management
- Data pipeline quality assurance
- Testing documentation creation
- Web application functionality testing
- Testing of customer relationship management systems
Accomplishments
- Successfully lead hands on Cingular/AT&T (Apple I phone) in 2007 weeks ahead of schedule
- Lead the BI QA efforts from infancy to a stable ground for the Partnership BI team of AutoTrader.com. Projects including Edmunds new car project, BPM alerts, Revenue share report with all the partners, ATX datamart, OEM specials
- Lead Auto trader.com Type 3 testing efforts on time, under budget and bug free
- Awarded employee of the quarter for leading QA team by AutoTrader.com EDSS dept.
- Awarded team Innovation award by AutoTrader.com supporting BI Reporting Framework
- Awarded business Impact award by AutoTrader.com for Sales reporting
- Awarded SOS award for supporting Microsoft Dynamics CRM project at AutoTrader.com
Abstract
Seeking new opportunity in BI testing/development space. I can bring over my 15 years of hands on IT experience as a Data quality analyst to the table and help companies maximize their corporate data quality / BI goals to enhance their customer satisfaction and profitability.
Timeline
Senior Data Quality Analyst
SPH Analytics.com
05.2018 - 04.2026
Quality Assurance Analyst III
GPC
05.2017 - 05.2018
ETL/ Data Warehouse Test Lead
TCS/Carnival cruise line
01.2017 - 05.2017
Data Quality/ ETL Test Consultant
Cox
06.2015 - 09.2016
Sr. Data Quality Analyst consultant
Manheim/Cox Automotive Group
03.2014 - 06.2015
Sr. lead Data Quality Analyst/BI/ETL
AutoTrader.Com
07.2008 - 03.2014
Lead ETL QA / Reporting Analyst
Macy's System and Technology
11.2007 - 07.2008
SR ETL QA Analyst
Chevron/Texaco
07.2007 - 11.2007
Lead ETL QA Analyst
Cingular/AT&T
03.2007 - 06.2007
Callidus / ETL QA Analyst
Bellsouth
09.2006 - 02.2007
Lead ETL QA Analyst
TSYS - ESC Loyalty
04.2006 - 09.2006
Lead ETL/Integration Tester
Compu Credit
07.2005 - 03.2006
ETL QA Analyst
Premier Health Care
11.2001 - 05.2004
Bachelor of Science - Network and Communication Management
DeVry University
Bachelor of Science - Business Administration
DeVry University