MOHABBAT ALI

***** ***** *** **, ****** MI 313-***-**** adinay@r.postjobfree.com

SUMMARY

Software Quality Assurance Engineer

U.S Citizen with over 10+ years of IT experience as a Software Quality Assurance Test Engineer and ETL Tester. Specialized in Requirements analysis, test planning, developing test cases and test scripts. Profound knowledge in Software Development Life Cycle(SDLC) in decision making and problem solving as a Test Analyst. Extensive experi- ence in testing Web Base, Client Server Database applications, and ETL/Data Warehouse processes. TECHNICAL SKILLS

QA Test tools: Azure DevOps, Team Foundation Server(TFS), Microsoft Test Manager(MTM), JIRA, Quality Center(10/9.0), HP Application Lifecycle Management(ALM), Rally, Quick Test Professional(QTP)

Browsers: IE, Firefox and Chrome

Databases: Oracle 11g/10g, SQL Server 2008, MS Access Other Tools: MS Office, Telnet, FileZilla (FTP), WS_FTP, Putty, Paint, Photoshop Operating Systems: Windows 10, Windows 7, Windows XP, Vista, UNIX Languages: SQL, PL/SQL, Visual Basic, Python

ETL: Informatica, IBM DataStage

EXPERTISE

● Working with Project Leads to identify project scope and finalize requirements.

● Studying and analyzing requirements for usability and testability assessment.

● Creating requirements traceability metrics and performing Gap Analysis.

● Researching requirement changes or design enhancements and making corresponding adjustments on testing activities.

● Making assessments of the project statuses and assisting with reporting the statuses to senior management.

● Strong aptitude in implementing Quality Assurance Standards and testing methodologies for GUI and Web Ap- plications using use case documents, functional specifications and business requirements.

● Good experience in testing and QA practices in Web and Client/Server Applications using ASP, .Net and VB.NET.

● Good experience with databases including Oracle 11g/10g, and SQL Server.

● Adept at testing ETL/Data Warehouse applications developed with third party tools including Informatica, Data- Stage, or through SQL and native Relational Database Management System(RDBMS) tools.

● Excellent SQL skills which were applied for data analysis and data testing.

● Good understanding of Data Warehouse architectures, Dimensional Modeling (Star/Snowflake schema), Slowly Changing Dimensions and late arriving facts.

● Developed test plans and test cases for system, integration and user acceptance testing(UAT)

● Analyzed the test results, tracked the defects and generated reports using Quality Center.

● Developed ORACLE Queries to query the database to test the back end process of the application.

● Generated test plans by including test scenarios, test cases, testing environments, system configurations, and entrance/exit criteria.

● Involved on testing the new functionalities based on test cases and coordinated with the development team in fixing the issues.

● Managing/leading the test Team and monitoring test execution and test Team deliverables.

● Leading functional, integration, system, regression, user acceptance testing initiatives using Quality Center, Azure DevOps, Microsoft Test Manager(MTM) and Team Foundation Server(TFS).

● Tracking defects and work with the Project Manager and Development Team to resolve defects and effectively mitigate risks.

MOHABBAT ALI adinay@r.postjobfree.com PAGE 2

● Working closely with the software test automation Team and ensuring the flow and the process is maintained.

● Test Data creation and conditioning.

● Organizing defect meetings; prioritize and update defects accordingly.

● Responsible for test outputs at the end of test phase prior to the implementation, final test report and sign-off.

● Responsible for scheduling, conducting defect meetings and distributing test reports on a daily basis.

● Perform post implementation production verifications and participate in project wrap-up meetings.

● Prepared and conducted a lesson learn session with the core project Team to identify and list out issues and challenges of the project.

EXPERIENCE

DASSAULT SYSTEMES 3DEXCITE, Royal Oak, MI April 2016 - August 2020 Software Quality Assurance Engineer

● Directed in development of test plan and test cases from functional requirements, technical specification and uti- lize cases documents.

● Constructed manual test scripts for performing functional and regression testing.

● Led in compatibility testing, integration testing and user acceptance testing.

● Collaborate with end users to schedule and support user acceptance testing.

● Designed user acceptance testing(UAT) documentation and oversaw presentations for end users.

● Created and managed regression documents to aid in the QA regression process.

● Used Azure DevOps, Team Foundation Server(TFS) and Microsoft Test Manager(MTM) as test repositories and used it for implementing test cases and scripts.

● Produced various reports and graphs for further analysis.

● Performed Gap Analysis.

● Responsible for weekly status updates showing progress of testing effort and open issues to be solved.

● Interaction with business analysts and developers to settle technical issues so as to encounter client's require- ment for a better quality software product.

● Works directly with analysts and developers to investigate software defects and accurately and clearly reports those defects in Azure DevOps and Team Foundation Server(TFS).

● Uploaded the test cases in Azure DevOps. Team Foundation Server(TFS) and Microsoft Test Manager(MTM).

● Accomplished test cases in Azure DevOps and Microsoft Test Manager(MTM) test Lab.

● Composing SQL queries for backend testing.

● Built and filed various office documentation using MS Office applications.

● Interaction with business analysts and developers to solve technical issues so as to encounter client's require- ment for a better quality software product.

● Discovered modules were impacted by various change requests.

● Designed progress reports to assure test coverage and results.

● Collaborated with development engineers to build and evaluate test specifications, test coverage, defect discov- ery and resolution.

NEXIENT, Ann Arbor, MI October 2014 - February 2016 Software Quality Assurance Engineer

● Gathered, recorded, and examined the Business Requirements Document(BRD).

● Devised and accomplished test cases from Rally to approve the functionality of the application.

● Accomplished functional, cross platform, security, integration, smoke, regression, End to End and user accep- tance testing(UAT) techniques throughout the Software Development Life Cycle(SDLC).

● Perform several Web-Services testing using SoupUI tool (Get Method, Rest Method) to assure data transfer and validate the XML file was produced by software.

● Performed SQL (Squirrel/SQL Developer) testing to validate data in database and compare number on frontend.

● Executed UNIX commands (Putty, GitBash) to invoke batch file processing.

● Performed UI and user accessibility testing with collaboration of Business analyst and product owner (customer).

● Documentation of all test cases, expected results from tests, and final delivery results of all tests.

● Found, entered and traced defects in defect tracking tool (Rally). MOHABBAT ALI adinay@r.postjobfree.com PAGE 3

● Trained and supported customer support staff on launch of site in production. FINISH LINE INC.(IN), Indianapolis February 2014 - September 2014 Software Tester

● Work extensively on string testing, SIT and some user acceptance testing(UAT) testing of EEM software.

● Construct test scenarios and test cases for validation with respect to sprints.

● Identify supply requirements for achieving test objectives.

● Web testing of www.finishline.com.

● Testing of EOM (Manhattan Associates) to guarantee product UI functionalities.

● Work closely with product owners, BA and SME's to guarantee software functions as intended.

● Execute test cases for string, functional, system and integration testing.

● Updating test cases as and when needed.

● Write detailed defect reports and re-test once the fix has been implemented.

● Maintain defect log and presentation of test summary report, as and when needed.

● Coaching a Team of four testers to execute a test plan in order to meet deadlines.

● Communicate status against test plan.

● Testing iOS based EOM application and verifying its back end processing.

● Manage creation of test cases from Manhattan solution design documents and other artifacts.

● Attends daily stand ups, retrospectives and sprint planning & review meetings. COVENTRY HEALTH CARE, Bethesda, MD October 2012 - January 2014 Software Tester

● Involved in development of test plan and test cases from functional requirements, technical specification and use cases documents.

● Developed manual test scripts for performing functional and regression testing.

● Involved in compatibility testing, integration testing and user acceptance testing.

● Coordinate with end users to schedule and support user acceptance testing.

● Created user acceptance testing(UAT) documentation and conducted presentations for end users.

● Created and maintained regression documents to aid in the QA regression process.

● Used Mercury Quality Center as a test repository and used it for executing test cases and scripts and logging & generated various reports and graphs for further analysis.

● Performed Gap Analysis.

● Responsible for weekly status updates showing progress of Automation testing effort and open issues to be re- solved.

● Interaction with business analysts and developers to resolve technical issues so as to meet client's requirement for a better quality software product.

● Works directly with analysts and developers to investigate software defects and accurately and clearly reports those defects in Quality Center.

● Analysis of application requirements and entering of requirements into HP Application Life Cycle Management

(ALM).

● Uploaded the test cases in HP Application Life Cycle Management(ALM).

● Executed test cases in Quality Center/ALM - Test Lab.

● Involved in writing SQL queries for Backend Testing.

● Created and filed various office documentation using MS Office applications.

● Interaction with business analysts and developers to settle technical issues so as to meet client's requirement for a better quality software product.

● Identified modules were impacted by various change requests.

● Created progress reports to ensure test coverage and results.

● Coordinated with development engineers to design and review test specifications, test coverage, defect discovery and resolution.

WYNN RESORTS, Las Vegas, NV July 2010 - September 2012 ETL/Data Tester

MOHABBAT ALI adinay@r.postjobfree.com PAGE 4

● Worked on completing source to target mappings document.

● Initiated talks with business users in order to get feedback for design of star schema and also for requirements of enhance and brand new reports.

● Ensure processes and controls across major process areas, including but not limited to data quality, ETL and metadata management.

● Led in unit testing of DataStage Jobs, integration testing and system testing in pre-production environment.

● Created SQL (Set Operators- MINU, INTERSECT, UNION), and OLAP functions for validating the ETL processes functionalities including number of rows moved.

● transformations for hotel, and gaming Star schemas.

● Extensively leveraged TeraData BTEQ for transforming data and applying business rules to source data, in order to produce and test different reports.

● BTEQ was also used to export data and reports from TeraData.

● Worked with data profiling, data quality, data verification, data conditioning and data validation.

● Prepared extensive set of validation test cases to establish data.

● Established different data extracts to be sent out to outside vendors and partners.

● Performance tuned most of existing ETL batch jobs.

● Tested the ETL jobs invented through Informatica ETL tool.

● Acted as sole resource for satisfying Ad Hoc SQL requests from business. Provided business with data in form of Excel sheets and Pivot tables.

JPM CHASE, Jersey City, NJ January 2009 - June 2010 ETL/Data Tester

● Building the source to target mappings and technical specifications for the ETL process of the project.

● Collaborated with the developers regarding the defects raised and retested against application.

● Tracing and examining defects and recording variation between expected and actual results.

● Experience testing data conversions and migrations in cross platform scenarios Informatica Power Center.

● Experience in testing data conversions and transformations.

● Designed and constructed UNIX shell scripts as part of the ETL process, automate process of loading, pulling data.

● Prepared extensive set of validation test cases to verify data.

● Devised SQL to perform manual data testing on a regular basis.

● Performed tests in both SIT, QA and contingency/backup environments.

● Collected requirements and tested several business reports and different data extracts.

● Devised and tested event based schedules of reports and built an emailing mechanism to indicate success/failure of schedule.

● The Rational ClearQuest and ClearCase are also utilized as test management tools and repositories of new and existing test cases.

● Involved in a full cycle of code management and communicated defects and initiated change requests using Clear Quest.

● Collected requirements and tested several business reports.

● Involved in user training sessions and assisting in user acceptance testing(UAT).

● Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying tables and.

● columns from data are extracted.

● Involved in unit testing of system and defining test plans for functional and quality assurance testing of ETL and system integration workflows.

CLAIRE'S- HOFFMAN ESTATES, IL June 2007 - December 2008 QA Analyst

● Executed system integration, end to end and user acceptance testing(UAT) cases for web based and .NET ap- plications.

● Performed business functional tests at various stages of Software Testing Life Cycle (STLC) as functional testing, integration, interface, system testing, user acceptance testing(UAT), and regression.

● Testing, sanity and End-to-End testing in Web/Client Servers. MOHABBAT ALI adinay@r.postjobfree.com PAGE 5

● Recorded parameterized scripts to accurately simulate real user behavior.

● Reviewed and studied Business Requirements for Claire's POS application and developed test cases for each functional requirement.

● Assist developers in unit testing codes.

● Performed functional testing, regression testing and performance testing.

● Developed user defined functions for validation and ran test scripts and documented output in Quality Center.

● Created manual test cases and created traceability matrix.

● Led in all phases of the Software Development Life Cycle(SDLC). Planned for manual and automated testing pro- cedures and scripts.

● Involve in developing test plans, test cases, create test scripts and execute.

● Analyzed web based application and identified critical application functionality.

● Examined and studied requirements to document test cases using Quality Center. Created test plan and test cas- es and mapped according to requirements.

● Defect tracking and developing reports for movement. Identified critical functionality for performance testing.

● Collected weekly metrics to keep track of manual testing bugs encountered during system testing, regression and integration testing.

● Reported progress to management. Wrote and reported defects using Quality center, verified fixes and closed bugs during regression testing Other duties as assigned by Team lead. EDUCATION

Bachelor of Science Computer Information System, National University, Dhaka, Bangladesh. Work Status: U.S Citizen.

Contact this candidate