Home

IRSHAD MANSOORI - ETL Test Lead& Data Analyst

[email protected]

Location: Irving, Texas, USA

Relocation: Yes,

Visa: H1B

PROFESSIONAL SUMMARY: Quality Engineering professional with over 12+ years of experience specializing in requirement analysis, Test Planning, Strategizing, Estimations, Execution and Reporting. End to End testing including integration Testing, API testing, Database Testing, ETL testing, Functional Testing, Regression Testing, Automation Testing, Performance Testing, Load Testing and UAT. Functional experience in Financial, Healthcare, Retail and Banking Projects. TECHNICAL SKILLS: Operating Systems: Windows 98/2000/XP, Windows NT/2000, UNIX, Linux Methodologies SCRUM, Agile, Waterfall, Incremental, V Model Automation Powershell, Selenium, Appium, UFT, Groovy CICD Jenkins, Azure Pipelines Languages Python, Java, Basic Shell Scripting Source code Management GitHub, SVN, bitbucket, Win SCP, Putty Defect Management ALM, JIRA, Bugzilla API Postman, SOAP UI, groovy Reporting Tools: Power BI, SSRS, COGNOS, OBIEE,SSIS Databases: SQL Developer, Oracle, Teradata, DB2, NETEZZA, NoSQL ETL Tools: Informatica PowerCenter, SSIS, Datastage, Talend Cloud : Snowflake, GCP, AWS S3, Redshift, Azure Data Factory Education: Master of Computer Application, Pune University (India) March 2008 - 2011 Certifications: ISTQB Certified Tester, Certified SCRUM Master, NCFM PROFESSIONAL EXPERIENCE: Mphasis Jan 2022 Current CLIENT: Charles Schwab, Irving TX Roles & Responsibilities: Module Lead Test Planning, Test Strategy design, requirement analysis, effort estimation, requirement traceability matrix, defect management, automation of functional and non functional tests, automated job scheduling, DevOps Support, Entry and Exit Criteria evaluation. Developed validation scripts to ensure data accuracy and integrity, resulting in a 20% reduction in data errors and improving overall data quality. Automated regression testing scripts using SQL Script and DataOps, reducing testing time by 50% and enabling faster release cycles. Automated stored procedures and automation scripts to perform Rest API validations, ETL validations, Data Migration, Data Mapping, Data Integrity after transformation, usability testing and user testing. Worked with the development team, BA and other stakeholders in gathering and analyzing functional or technical requirements and acted as a scrum master. Perform data profiling and analysis to understand data quality issues, data anomalies, and data transformation requirements. Participated in the Data migration process implemented in SSIS/SSRS, validating data transformation mapping and workflows to ensure and efficient data loading. Tested and validated ETL processes within SSIS packages to ensure data completeness, accuracy, and integrity Design and execute tests to validate data accuracy, completeness, and integrity throughout the ETL process, including source-to-target data mappings. Execute end-to-end testing of ETL processes, including data extraction, transformation, and loading, to ensure successful data flow and transformation. Validate transformation logic using SQL queries and iCEDQ tool, data integrity and consistency against mapping rules Worked closely with DevOps teams to integrate test scripts into CI/CD pipelines and ensure continuous testing throughout the development lifecycle Developed Smoke, Sanity and regression test suites with stored procedures, selenium and Rest Assured API framework. Utilized Python Pandas for data analysis and multiple files validation like Agents, Firms, Transaction, Master & sub accounts and user file. Develop custom data validation scripts, data validation functions using Python Pandas to simplify and speed up the testing process Defect Management with ALM and JIRA for different projects. Conducted testing of OBIEE reports to ensure accuracy and completeness of data, identified and documented defects, and worked collaboratively with development teams to resolve issues. Lead an Agile Functional, ETL, automation and API testing team. Mentored team members to develop analytical and problem solving skills Conducted Defect Triage with business and development teams Citiustech Inc Mar 2020 Dec 2021 CLIENT: Baylor Scott & White Health, Irving TX Roles & Responsibilities: Technical Specialist Streamlined testing processes for multiple reports across different phases by implementing automation frameworks, saving approximately 30 hours of manual effort per week. Created utilities for Test data creation to bring down the test setup time by 50 % Applied project management practices across all phases of SDLC and STLC Designed test scenarios for the project based on requirements and mapping sheets. Developed complex SQL scripts based on transformation rules spread across multiple servers and multiple tables. Validated data accuracy and completeness for various data integration projects using SQL scripts and Python Managed CI/CD pipelines using tools like GIT and bitbucket. Created a regression script to validate all the QA activities for any changes in backend using Netezza. Integrated ETL testing processes seamlessly with QuerySurge job scheduling, ensuring efficient execution and monitoring of ETL workflows. Conducted and participated in technical reviews/ walkthrough for QA deliverables such as test plan, test strategy, and test cases. Attended Scrums on a daily basis, updated the Scrum board, and coordinated with team for completion of requirements Citiustech Healthcare Technology Sep 2016 Feb 2020 CLIENTS: DAVITA, BSWH & PRESBYTERIAN, Mumbai, MH Roles & Responsibilities: Technical Lead Consistently recognized for excellent problem-solving and analytical skills by developers, project managers and supervisors. Created and executed test plan, test scenarios and test cases ensuring alignment with project requirements and timelines Designed, developed, and executed ETL testing strategies for healthcare data integration projects, ensuring compliance with industry standards such as CCDA, HL7, and FHIR. Planned and executed ETL processes implemented in SSIS, Informatica PowerCenter and DataStage, validating data transformation, mapping and workflows to ensure efficient data loading. Work with Snowflake Data Warehouses, data lakes, and pipelines to ensure integration and ETL process quality Developed snowflake SQL queries to validate the data transformation and perform data quality check. Collaborated closely with COGNOS developers to validate report data and verify report functionality, ensuring alignment with business requirements. Performed data profiling and data analysis using IDQ to identify duplicate and inconsistencies in source data. NSEiT Mar 2011- Aug 2016 CLIENT: NCDEX, Mumbai, MH Roles & Responsibilities: Data Engineer/ BI Tester Worked with Business /Technical Analyst in analysis of functional design specifications of ETL/Data warehouse applications Involved in creation of Test Plans, Test Cases, and Test Execution based on mapping specs to validate the platform data. Designed test scenarios for the project based on requirements and mapping sheets. Developed and executed automated test scripts using Selenium WebDriver with Java and Cucumber to ensure accuracy and efficiency of web application testing Tested ETL and DWH reports by developing and executing different SQL queries. Megasoft Information Technologies Sep 2009 - Feb 2011 CLIENT: TDCC Bank Mumbai, MH Roles & Responsibilities: QA Engineer/ Support Analyzed the Business requirements and developed Test cases based on functional requirements. Attended walkthrough meetings with the Business Analysts and Developer team to get a clear understanding of the business and the applications being used in house. Developed and Designed Test Cases and execution on the Business Rules and Mapping Documents. Validated the source data coming from various databases using complex SQL queries. Created test data and test cases according to scenarios. Keywords: continuous integration continuous deployment quality analyst business analyst user interface business intelligence sthree Texas