Candidates About

 

Mohammed Hashem

           

Over 14 plus years of IT experience, Certified (QAI) test professional with experiences in working with various methodologies including Agile Scrum, Improving quality assurance processes and practices. Involved in the recruitment and mentoring of QA Engineers, Developing and driving continuous improvement initiatives. Extensive experience in Business Analysis, Risk Analysis, QA Analysis, System Analysis, Formulating Test Strategy, Functional/Non Functional Test Plans, Test specifications, and all kinds of testing artifacts, Experience in Project management and test automation using Quality Center 10/11& QTP 8.0 9.x. Ten years of experiences in Enterprise data warehousing/Data Migration projects using Informatica, DataStage 4.0/6.0, AbInitio, Infomatica ETL tools. Substantial experiences in managing QA and UAT for SAP projects. Business & QA experiences in Business Intelligence tools like OLAP-Cognos Impromptu and Cognos Web Reports (IWR), SAS Web Report Studio, Oracle Discover, experiences in FIX protocol and SWIFT messaging, Substantial experiences in Aladdin trading suits, thinkFolio, CharlesRiver, PMR trading tools with Portia and Simcorp Dimensions accounting systems contributed to a number of successful projects.

AS A QA Lead/UAT Manager

·         Developing QA and UAT Strategy, Test Plan & Test Cases

·         Improving quality assurance processes and practices. Involved in the recruitment and mentoring of QA Engineers

·         Developing QA Project plan using MS project

·         Developing and mentoring QA team

·         Substantial experience with SDLC  in Agile/Scrum process

·         Delegating and Scheduling resources, Estimating Testing timeline and maintaining testing artifacts

·         Working with SMEs to review and understand business requirements functional and non-functional specifications

·         Developing and executing test cases for various kind of applications including multi trading applications

·         Working closely with and guiding developers as they build automated testing.

·         Facilitating pre & post release scope reviews.

·         Delegating and Scheduling resources and performed testing activities

·         Defining and complying testing Entry & Exit Criteria

·         Working on Web, client-server, and mainframe (CICS, TSO) platforms

·         Experiences in Aladdin Trading Suits (i.e. Trade Entry, Dashboard, Mortgage Browser, Aladdin View ADAM, etc.) with end to end trading life cycle for different asset classes like Equity, Bond, FX, TBA, Futures, Options, etc.

·         Experienced in Charles River Investment Management System –Trades booking, Trade execution, Correction & Cancel

·         Substantial experiences in Simcorp Dimensions using ( Transactions view, Positions, Portfolio calculation, Message queue, etc.) and Portia/WSO systems

·         Experiences in OMS, Equity, Fixed Income, Options, Derivatives – Exchange Traded and OTC, Custody Clients – Trade processing and Settlement, SWIFT Messaging, FIX Messages – Payment instructions and Securities Clearing and Settlement instructions, Merchant Banking, equity and debt markets, Cash Management/Reconciliation, etc.

·         Substantial experience in Data Warehousing/Data Mart. (Multi-Dimensional data warehousing Design  (OLAP/OLTP), ETL tools)

·         Excellent working experience in Informatica, DataStage, AbInitio, SAS, Cognos tools, WebSphere, SharePoint, TIBCO

·         Participated  in validating LDAP integration with single sign-on among various applications

·         Writing complex SQL queries and shell scripts for data validations in the UNIX and Oracle, Main Frame (CICS, SPUFI,VSAM & TSO) & DB2 environments

·         Experiences in ETL/OFSA testing, Configuration and change management

·         Experiences in HP tools (ALM/Quality Center, QTP), Service Now (IT Management), JIRA

·         Helped Business to identify Business Test Scenarios and developing test cases

·         Experiences in ServiceNow and JIRA

·         Experiences in Data Profiling and Data Lineage, Meta Data Management

·         Substantial experiences in ETL and reporting (Informatica, SAP Business Object)

·         Defect / Incident Tracking and managing, creating test metrics

·         Analytical and problem solving skills, good written and oral communication skills.

 

 

TECHNICAL SKILLS

OS:      SunOS 5.5.1, SunSolaris 2.6, SunSolaris 2.8, Linux, VMS/Open VMS, MVS,

                          Windows NT 4.0, Windows 2000, Windows XP, MS Dos

Testing Tool: JIRA, Quality Center, QTP 8.x/9.0, LoadRunner, Rational, SQA Load, Clear Quest  

Software:          Clear Case, DataStage 4.0/6.0 (ETL), Ab Initio 2.10(ETL), Informatica Power Center,

                         Informatica Metadata Manager, Informatica DQM, OLAP Cognos, OFSA, OFDM, Siebel

                                    UCM, SAS Web Report Studio 3.1, MS Project, Visio Pro 5.0, Requisite Pro 3.1, 

                                    Precise/Indepth for Oracle, TCP/IP, FTP, TIBCO, Lotus Notes 5.x, MS Exchange, Oracle

                                    8I, SQL Server 6.5, DB2, Sybase 11.03, Visual SourceSafe 6, PVCS Tracker, CMS, SQL

                                    Programmer 2001.1, Rapid SQL, Oracle Discoverer, Toad, Reflection 8.0, KEA 4.x,

                                    ConnectDirect, Hummingbird, Tivoli TIM/TAM, JAVA, HTML, XML, DCL, C/C++, 

                                    Visual Basic, PL/SQL, CICS, VSAM, SPUFI, B/K shell, SWIFT, VMWARE.

Aladdin Suits (Blackrock), SimCorp 5.3 & 5.6

Hardware:         SUN Ultra-4500/6800, SUN E10000, VAX, IBM Mainframe, AS400, Laptops, IBM PCs

 

Script :             SQL & Shell

 

 

EXPERIENCE

JLR (Jaguar Land Rover), New Jersey                                                                          Sep 2016 – Current

UAT Lead/Defect Manager

Responsibilities:

·         Analyzing Business Requirements, Creating Test Requirements and Schedules

·         Developing QA strategy, UAT Test plans, and Test cases

·         Coordinate and  Managing UAT Testing for SAP/SalesForce CRM and associated applications

·         Provides End to End test coverage including System testing, UAT & Regression testing

·         Experiences in Mainframe CICS for Data Capturing and data manipulating

·         Improving overall quality assurance processes and practices.

·         Allocating/Mentoring/Delegating tasks and managing QA team

·         Extensively used of Quality Center and promoted Test cases to test Plan module - using created/defined format, Perform Test Execution from test lab, and logged defects in defect module

·         Arranged Status meeting and daily defect calls

·         Data vendors management, maintained vendor’s data for testing

·         Generated Requirement Tractability Matrix using QC.

·         Creating various test metrics and creating Defect reports/ Testing status reports

·         Managing testing efforts in an Agile/Scrum environment with Service Now

·         Experienced in testing SAP migration, SAP -CRM, SAP Financial, SAP BO reporting for Journal & GL accounts.

·         Technical and Functional testing experiences in ERP SAP CRM module

·         Substantial experiences in ETL and reporting (Informatica, SAP Business Object)

·         Experiences in offshore model (UK & India) and successfully delivered product on time.

·         Conducted meetings with QA/Dev/IT managements periodically.

·         Worked closely with Business users, Developers and PM

·         Created QA project plan, Analyse system specifications, requirements and developed detailed QA documentation that included test plan, test strategy, test scenarios, test cases test reports and QA good practices.

·         Experiences in ALM/QC11 and QTP framework for test automation, REST webservices, HTTP protocols.

·         Substantial testing experiences SAP HCMS and FICO modules for full implementation cycles

·         Managed defects and documents in JIRA, SharePoint & Service-now

·         Experience with data flow, data objects, data mapping, etc.

Environment: SAP, CRM-Salesforce, Windows7, Linux, Mainframe, QC, QTP, JAVA, SQL Server, DB2,

 

Neuberger Berman                                                                                           Nov 2012 – Aug 2016

BA/QA Lead

Responsibilities:

·         Improving quality assurance processes and practices.

·         Developing and driving continuous improvement initiatives

·         Mentoring, Delegating tasks and managing QA team

·         Creating various test metrics with writing test strategy, test plan & test cases

·         Managing testing efforts in an Agile/Scrum environment with Service Now

·         Experienced in processing trades via Aladdin (OMS & EMS) and ThinkFolio (OMS) applications for different Asset Classes and Trade Flow by Straight through process (STP) (Middle & Back Offices: Trade Path, Portia and Wall Street Office, SIMCorp, PMR for the asset classes of Loans, Bonds, Fixed Income, FX and Equities).

·         Substantial experiences in SWAPS and OPTIONS

·         Identifying Business Requirements and creating process diagram

·         Experiences in complex scenarios for TBAs

·         Experienced in Middle & Back Offices systems (TradePath, Portia & WSO for Fixed Income with FX, Futures and  PMR & NBBO for Equity Products)

·         Experienced in Aladdin Trading Suits (i.e. Trade Entry, Dashboard, Mortgage Browser, Aladdin View ADAM, etc.) with end to end trading life cycle for different asset classes like Equity, Bond, FX, TBA/Mortgage, Futures, Options, etc.

·         Experiences in SimCorp Dimensions using (Transactions view, Positions, Portfolio calculation, Message queue, etc.)

·         Verified trade transmission to external systems Market Axess, FXConnect7, and Bloomberg EMS systems using FIX messaging protocol.

·         Experienced in testing SAP migration, SAP Payroll, SAP Financial, SAP BO reporting for Journal & GL accounts.

·         Substantial experiences in offshore model and successfully delivered product on time.

·         Conducted meetings with QA/Dev/IT managements periodically.

·         Created QA project plan, Analyse system specifications, requirements and developed detailed QA documentation that included test plan, test strategy, test scenarios, test cases test reports and QA good practices.

·         QC11 is used as a test management system and QTP scripts for test automation

·         Managed defects and documents in JIRA, SharePoint & Service-now

·         Experiences in Test Driven Development (TDD/BDD)

·         Linux, SQL SERVER, Sybase and Oracle systems used for Bond & Equity Trades

Environment: Windows7, Linux, QC, QTP, JAVA, SQL Server, thinkFolio, MarketAxess, FXConnectv7, FX All, TradePath, Portia,  WSO, Aladdin, Bloomberg EMS, NB Mutual Fund Blotter, JIRA, etc.

Morgan Stanley Smith Barney (MSSB)                                                             Nov 2011 – Oct 2012

QA Lead Consultant

Responsibilities:

·         Analyse system specifications, requirements and developed detailed QA documentation that included test plan, test strategy, test scenarios, test cases, test procedures, test scripts, test reports and QA good practices.

·         Organize multiple ambiguity review sessions with the business and end users in understand the requirements.

·         Assure defects are reported in test director and quality centre with proper severity and priority.

·         Hands-on QA Lead manages both onsite and offsite teams consisting of QA coordinators and Analysts/Engineers responsible for supporting multiple applications/initiatives.

·         Working large, cross platform testing effort of both Private and Global Wealth Management business line initiatives such as Bloomberg, Application Profiling, Data Migration/Conversion, Equity Order Entry, Windows 7 Platform porting from XP

·         Extract data from different source systems using ETL Informatica to the Oracle target systems

·         Implemented quality index and assurance acceptance criteria across products and groups.

·         Partner with development group to improve productivity of development efforts by identifying and focusing on eliminating root causes of defects at early stage of project.

·         Partner with technical project managers to enhance the requirements management process by identifying requirement gaps before development comes to picture.,

·         Participate and conduct walkthroughs and defect report meetings with QA management /PMO periodically.

·         Create and maintain test project plans, status reporting, and critical success criteria for each phase of system   testing at project level.

·         Report on risk and issue with mitigation plan to management for CCAR.

     Environment: Windows NT, Linux, J2EE, JBoss, VBScript, QTP, JAVA, Oracle. MS-SQL, Sybase, Informatica, MDMMainframe 

 

UBS - Wealth Management                                                                                           April 2011 – Oct 2011

QA Lead

Responsibilities:

·         Analyzed and developed business requirements, Developed test strategies, test plans and test cases for various levels of software testing

·         Planned & Delegated testing tasks among onsite and Offshore team members

·         Interacted with business Analysts and developers

·         Identifying test requirements and creating Test data

·         Creating & Settlement of Trades (End to End) for Equities, Options, Fixed Income, Mutual Funds, Alternative Investments using web applications and Mainframe/Unix applications.

·         Running and validating cost base reports.

·         Performed Functional, Regression, & User Acceptance Test (UAT) on different trading applications (COE, G2/BonDesk, FIPS, TESA, CTPS, etc.

·         Hands on Back End testing for data validation and web based

·         Quality Center is being used to execute test cases, track test execution and report bugs and issues

·         Reported and provided project status to management.

·         Created and maintained Requirement Traceability Matrix, Test Progress Reports, Test Summary Reports

Environment: IBM Mainframe, CICS, COE(Consolidate Order Entry System), G2/BonDesk, JULIUS, FIPS, TESA, TAPS, TUBA, MFGI, ATS, OLS, OLT, FIPS, CTPS, JAVA, .NET, WEBSPHERE, MS Excel, QC 10.0,  MS Project.

 

The Bank of New York Mellon                                                                                      June 2008 –April 2011

QA Lead

Responsibilities:

·         Functional Review and analysis of the requirements & FRS

·         Project planning & Resource allocation using MS Project

·         Interacted Frequently with Developers and BAs in order to write test artifacts.

·         Worked closely with PMO and managing the QA project

·         Delegating and performing testing activities for BPS (Business Programming Systems) ASP & GSP includes IMMS, CDW, GFC, MQ, DTC, FED RESERVE, PPO, PLEDGES, SPUFI for Derivative Trades on Main Frame environment & GTM, ICO, MIDYS, SWIFT on the windows environment. Used different MTs for SWIFT message type.

·         Automated Mainframe CICS for Data Capturing and Data Entry using MS Excel Addin Macro.

·         Automated Test Data Identification Using Access Database for source applications. This accepts data from different sources like Flat Files, Excels and loads into access database

·         Written complex SQL queries(Inner Joins, Outer Joins, Group By, Etc.) to validated source and target data

·         Expertise in a specific complex domain area of Wash Sales. Came up with various possible combinations for test using Decision Table and Decision Tree for Wash Sales and Account Migration / In-Conversion.

·         One of the key person in managing the Quality Center tool for the CBR project.

·         Quality Center is being used for bug tracking and reporting, Develop Test cases in a loadable format for QC and Loaded them from MS excel to QC.

·         Created trades for Equities, FX, Options, Futures, OTC, Swap & Swaption for Calls/Puts for Buy or Sell, Wash Sale, Trade settlements, DTC, FRB, Euroclear, verifications, etc.

·         Entered and Settled Receive Free (RF), RVP, Deliver Free (DF), DVP trades, verified the middle office processing & validated the back office status upon completion of the order.

·         Performed Functional testing & UAT testing for Derivative processing on Mainframe (CICS/TSO) platform. Test execution for different logical days for each batch cycles.

·         Experiences in Regulatory testing, Performed Functional testing for Cost Base Reporting for Wash sale, Corporate Action, Tax Reporting, Account Migration using CDW, GainsKeeper, IAS &TAS systems on the Mainframe (CICS/TSO) platform. Test execution performed for different logical day batch cycles for Seeding extract and Daily transactions processing with Reconciliation, Position adjustments.

·         Have involved in testing Enterprise data warehouse project using Informatica Power Center.

·         Reporting and providing project status to management.

 

FannieMae, VA                                                                                                             June 2007 – May 2008

QA Consultant III

Responsibilities:

·         Writing test plan and test cases, Delegating & Conducting tests on Windows, Unix, and Mainframe systems

·         Developing MS project plan and defining scope of testing activity, Ensuring Testing compliance

·         Executing System test – Progression & Regression

·         Maintaining test scripts in the Quality Center, Generating Various QC reports

·         Developing complex SQL queries for data validations in the Oracle environment

·         Executing and validating various Batch jobs using Autosys (File Watchers, Inbound outbound files, Log files)

·         Responsible for testing compliance (SDLC process, Defining Entry & Exit criteria, etc.)

·         Using MS Project, Quality Center, Clearcase ClearQuest and SharePoint tools

·         Involved in testing adding pools and loans for single family and multi-family, On boarding issuers, etc

 

The following application is being tested at Fannie Mae

• Whole Loan Remics

Whole Loan REMICS is an application which is designed to securitize pools of Fannie Mae’s single family and multi family loans . The application supports fully guaranteed/ non-guaranteed securities which provide a user-friendly web interface.

       Environment: Java, Quality Center, ClearQuest, Oracle 10g/9i, TOAD, Informatica, MS Project, Visio,

       SharePoint, Sybase, AS 400, IBM Mainframe, UNIX, Autosys.

 

Office of Payroll Administration - The City of New York, NY                                         Aug 2004 –April 2007               

QA Lead

 

Moneyline Telerate, NY                                                                                                Jan 2004 –Aug 2004

Senior QA Analyst/Consultant

 

McKinsey & Company, NY                                                                                            July 2003 – Dec. 2003

Senior Quality Assurance Analyst

AIX, Websphere, Domino.

 

CERTIFICATIONS:

ORACLE - Certified Professional (OCP - PL/SQL, Performance Tuning, Backup & Recovery)   

CSTE - Certified Software Test Engineer since 1997 -   Quality Assurance Institute, USA

 

PROFESSIONAL TRAINING:

Data Warehousing

Reuters Information Technology, Hauppauge, NY

Oracle Discoverer

DeshTech Consulting &Education

UNIX System Administration

Zyncon Inc.    NYC

Oracle Database Administration

Access Computers Inc. Nassau, NY

Tivoli