Mohammad Jafar Email & Phone Number

Tysons Corner, Va, Us

• Act as the main Subject Matter Expert (SME) of the application during End to End and System Integration testing and assist other team members with testing Sprint requirements and perform regressions during releases.• Lead the end-to-end ownership of a team, including setting the technical vision for developing test frameworks and automation for our systems.• Work with Application Development to increase unit test coverage and overall code quality.• Coordinate and execute Quality Engineering and Quality Control activities to maintain and improve product quality by partnering with the Quality Assurance team.• Participate in all Sprint meetings and obtain necessary technical requirement details. Such meetings include Retro, Demo, Release, Grooming, Sprint Planning, Quarterly PI Planning and Daily Stand-ups.• Provide input to systems and applications developers on testing automation procedures and requirements, schedules, or potential problems. • Provide story points to Agile user stories during Grooming and Planning poker meetings, prepare test plans and track test cases writing and task executions across JIRA and X-Ray.• Work with the offshore teams and manage/distribute the work.• Review testing documentation, develop testing standards, define criteria for testing, analyze test results, and present results to developers and the team. • Integrated test code/scripts into CI/CD pipeline. Review and monitor test results. Working with development to fix and resolve identified issues.• Maintain and automate API services in Karate and Ready API Pro/SOAP UI.• Collaborate with product owners, development leads and other stakeholders to understand product specifics and create corresponding test strategies.• Introduced the automation environment and led the team to test the ETL process with various Testing Stages/Levels/Phases, Testing Techniques and Quality Work Products.

Atlanta, Ga, Us

• Worked with industry leading test automation tools, HP Quick Test Professional (QTP) and HP Quality Center.• Worked with technology team in building cutting edge clearing systems.• Performed troubleshooting software/hardware configuration problems.• Analyzed and participated in specification review meetings and gave suggestions where required.• Used to start testing from the early stages of Software Testing Life Cycle and create Jira tickets if there were defects in the Specification documents, developed application or the application in Production.• Participated in Scrum meetings held on every alternate day by giving the overall status of daily work. • Participated in QA team and Bug tracking or Defect Review meetings.• Maintained and certified automated tests developed by the automation team and provided suggestions to them to give full coverage through each and every test case in Quality Center.• Worked with Iterative and Agile software development methodologies.• Ensured that all QA Tests were carried out on time and in full.• Actively participated in Integration testing across different teams.• Implemented and participated in walkthrough of design session and test plan review sessions.• Delivered presentations to an audience of Manager Level within the business.• Built Message Queues and Topics through IBM Websphere Message Queue Explorer which were used for providing a medium for messages transmission and broadcasting.• Performed manual front-end user testing of features or aspects of clearing applications to test the plan and identified the opportunities for automation.• Provided weekly and monthly reports to senior managers on performance.• Provided Production and Non-Production support to various Trading Members across the Globe on a daily basis.

New York City, Ny, Us

• Actively participated in project meetings and team meetings.• Conducted analysis and review of requirements to create test scenarios.• Provided inputs for software test plans.• Designed test cases for test plans.• Created test scenarios in which tests are carried out.• Reviewed software test cases and check them.• Performed testing on functionality of software.• Reported defects and problems that occurred during the test process.• Built standard regression test cases and ensured ongoing maintenance of the data.• Tracked reported problems using a tracking system.• Prepared software test evaluation reports.• Implemented and participated in walk-through of design and test plan review sessions.

Lexington, Ma, Us

• Created test plans/test cases based on the Business Requirements.• Validated all types of files mainly XML files and flat files.• Monitored and validate the processing of all the incoming files from clients. • Processed and validate all the files on both UNIX and Windows.• Created test files in XML format, flat file format and fixed width formats.• Identified data issues and provided recommendations for resolution to ensure optimal performance.• Facilitated test plans/test case review meetings with project teams.• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.• Used database objects like tables, views, procedures, packages using Oracle tools like PL/SQL developer and SQL Plus.• Worked in both the QA as well as Production environments.• Worked with the offshore teams for the successful implementation and development of new projects.• Analyzed data and produced reports to assist in analysis and decision making to prioritize workload and ensure development and business requirements were met.• Ensured consistency between requirements, analysis, design and the developed applications, online websites and file processing.• Applied business and data manipulation principles and methods to technical problems.• Performed recurring analysis of merchant transaction files to ensure accuracy and identified opportunities for improvement.• Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discussed solution options. • Supported all production operation activities, with focus on integration and development of new and existing products and services.• Advised on technical issues and developed technical and end-user operating instructions and procedures.• Provided assistance to the team on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, coding and testing.

Lexington, Ma, Us

• Participated in all the activities related to Software Testing.• Built, maintained, and executed the test cases to/from the test case libraries. • Kept quality documentations up to date.• Made sure that all QA records, data & information were available to managers.• Wrote complex SQL queries that were required during the testing of applications.• Made arrangements for the repair of any QA related product that was malfunctioning.• Kept full awareness of regulatory requirement expectations.• Ensured activities in the quality plan were carried out. • Coordinated with the investigation of member complaints and issues.• Prepared and analyzed information for the purpose of Management Review.• Delivered specialist quality assurance advice to the company departments as required.

• Project Life Cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.• Created and run sessions and Batches using Server Manager to load the data into the Target Database.• Worked with the Joiner transformation using Normal Join, Master outer join, Detail Outer Join and Full Outer Join. Implemented slowly changing dimension Type 1 and Type 2 for changed data capture.• Worked extensively on data cleansing and data profiling.• Created various Transformations like Joiner, Aggregate, Expression, Filter and update Strategy.• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.• Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer and Server Manager.• Extensively used almost all of the transformations of Informatica including lookups, Stored Procedures, Update Strategy and others.• Developed sessions using Informatica Server Manager.• Solely responsible for the daily loads and handling the reject data.• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.

Master Of Science (Ms), Computer Science

Bachelor Of Engineering (B.E.), Information Technology