Mohan D

adquhj@r.postjobfree.com

Senior Consultant QA Lead

469-***-****

Summary Of Qualifications:10+ years of professional experience in Testing web based, Client/Server and data warehousing applications in the areas of Investment Banking, Capital Markets, Reference Data Testing, Regulatory Reporting Testing, Client on-boarding Testing, corporate cards.

Professional Summary:

Experience in Software Quality Assurance and Software Testing of Client Server Applications and Web based applications.

Experience in working on DWH Testing, ETL, Google Cloud Platform, Microsoft Azure, Hadoop HDFS, Hive, UNIX, Oracle, Test Environment setup

Running end to end TWS jobs to extract data from source, generating LRF’s and loading into HDFC/Hive

Create complex SQL queries to verify data from source to target to perform data validation on Oracle data ware housing applications.

Experience in Testing Database Applications of RDBMS in ORACLE, MS SQL Server and MS Access.

Extensive experience in running various kinds of tests such as Unit, Functional, Regression, Integration, System, End to End, Performance, Load, Stress, Backend, Black Box, User Acceptance Test (UAT) for Web (N-Tier) and Client/Server Applications.

Expert in Testing Life Cycle, Including Risk Analysis, Planning Process, Test Design, Test Execution, Defect Tracking, Management and Test Reporting.

Flexible and able to work with multiple priorities and collaboratively with Development, Business and QA team.

Flexible and willing to adjust to operational pressures, often at short notice.

Highly motivated, dedicated, hardworking team player and easily adapted to newer environments

Experienced in all phases of life cycle including requirements gathering, risk analysis, project planning, scheduling and mainly involved in Manual, Automation testing, defect tracking management and reporting.

Experience with MS Excel, PowerPoint and Visio.

Experience in UAT and Production Support and Interaction with the client.

Experienced with STLC, BugLifeCycle and QA processes such as preparation and maintenance of Test Plans and Test Cases

Expert in bug report analyzation, creating traceability riskassessment using various testmanagement tool such as Jira, Target Process, Quality Center and Application lifecyclemanagement.

Functional Testing of Stories based on sprint and pushing into proper status and also raisingDefects and issues based on functionality, Discussing with business and end client regarding blocking issues of stories.

Performing Web Services testing on ProductSelectorCorePSC,Content Retrieval ServiceCRS using Soap-U

Well versed with GUIAutomationTesting, SystemTesting including Functionality BlackBox,Performance, Stress, Load, Regression, Integration, White Box Testing and UserAcceptanceTesting.

Experience in Testing Database Applications of RDBMS in ORACLE, MS SQL Server and MS Access.

Created Test Plan, Test Scenarios, and Testcases for all the quarterly releases.

Stored all the test cases and other testing related documents in Test Director.

Flexible and willing to adjust to operational pressures, often at shortnotice.

Highly motivated, dedicated, hardworking team player and easily adapted to newer environments.

Technical Skills:

Functional Testing Tools: Quick Test Pro

ETL Tools: Informatica and Data Stage.

Hadoop Framework: Hive and Impala

Reporting Tools: IBM Cognos and Tibco Spotfire.

Cloud Platform: Google Cloud Platform and Microsoft Azure Testing

Databases: Oracle 7x/8x/9i/10g, DB2/400, SQL Server 2000, SQL Server 2005/2008.TOAD 4.5, SQL Navigator 4.0, Oracle SQL Developer 17.2

Operating Systems: Windows 95/98/2000/NT/XP, UNIX, Linux

Programming Languages: C, C++, SQL, PL/SQL, Java, Visual Basic, HTML, XML, Python

Web Technologies: HTML, DHTML, Xml, Java Script, VB Script, JSP

Test Management Tools: Rational Test Manager, Test Director, QTP9.2, Load Runner.

Bug Reporting ALM and JIRA

Defect Tracking tools: Test Director, Lotus Defect Tracker, Rational Clear Quest, PVCS Tracker, Jira and Bug Zilla

Requirement Gathering Rational Requisite Pro, SAM (System Asset Management)

Processes Software Development Life Cycle, Software Testing Life Cycle, Defect Life Cycle, Spiral Model, V Model, Rational Unified Process, SEI CMM Levels, Testing Methodologies, Black Box Testing Techniques,

Project History:

Volkswagen Group of America Inc (VWoA). Jun 2021 –Till date

Senior Consultant in Atos, ETL - QA Lead in LCA, Phoenix, AZ-USA

Project – CCM – Customer Consent Management

Volkswagen Group of America Inc. (CCM – Customer Consent Management): This project deals with building a consent solution across Volkswagen group, this next generation solution architecture project provides group identity kit as a key component to avoid regulatory compliances across U.S.A and Canada markets. VolkswagenGrouphave resulted in brand specific solution centrally by injecting (VW brand adopting identity kit (IDK) and Audi brand consent store identity number

Volkswagen Group of America (CCM – CustomerConsentManagement) provides a low latency, high velocity, bigdata platform to provide the ability to ingest, store, analyze, and serveevents that are produced and consumed from both internal and external systems.

Responsibilities:

Collaborate with Business Analyst and Business users to understand the business requirement for new data sourcing requirements / existing system and processchange

Running end to end TWS jobs to extract data from source, generating LRF’s and loading into HDFC/Hive depending on Volkswagen (CCM – CustomerConsentManagement) project specifications

Composing TWS schedule files and execute code through schedules

Test conditions and test strategy walk through with ProductOwner, EndUser and teammembers. Responsible to perform, defect analysis and matrixanalysis.

Automation of all possible regression test suites, executing the automated test suite and providing status report for each sprint

Performing Black Box Testing, White Box Testing, Regression Testing, for code changes done in programs and Coordinate with different groups of interfacing system for testing the change with integration

Preparing test solution design documentation to describe the detailed test design which acts as reference for future stories

Coordinating and working with team to explain project requirements and getting the deliverable on timely manner. Also Providing Knowledge transfer to team members

Technical Highlights:

ETL Tool: Apache Hive

Database: HDFS (Hadoop Distributed File System)

American Express Global Business Travel Jan 2019 – Jun 2021

Phoenix, AZ-USA

Project – Big Data Analytics

The Big Data Analytics initiative is American Express Global Business Travel (AMEX-GBT) next generation strategic reference data repository for strategic Business Intelligence system (Travel expenses and Card expenses) data. This initiative is necessary to ensure AMEX-GBT’s strategic repository can fully support all aspects of AMEX’s to provides globally integrated solutions both online and offline, as well as through mobile applications, to help organizations manage and optimize their travel expenses and service their travelling.

Since GBT faces challenges of massive data growth due to new business demands and regulatory requirement. The current reference data infrastructure cannot keep pace with the ever-changing business environment of new markets, products, clients, and strategies. BigData Analytics project will help GBT to effectively manage the digital data challenges it faces by enhancing the capabilities of Information management within the organization.

Responsibilities:

Analyze business requirements and develop test cases based on business objectives and project artifacts

Develop, maintain and execute functional test cases as requested and working with the technology and business counterparts

Interacting with globaldatavendors like Bloomberg, Reuters, etc. to map custom data points with our system.

Experience in Agile deliverymodel – Sprint Testplan, ProductBacklogReview, Dailystand up meetings

Involved in dataAnalysis/ enrichment using Hive/ SQLqueries.

Acting as a bridge between end user and IT to facilitate the communications.

Performing or supporting User Acceptancetesting.

Provide transparency of the progress to the project stakeholders and escalatewhen necessary.

Writing the hive SQLqueries for validating staging tables’ data and Hadoop data base as per requirements.

Technical Highlights:

ETL Tool: Apache Hive

Database: HDFS (Hadoop Distributed File System)

Test Management Tool: HP-ALM

State Street Corporation Jan 2018 – Dec 2018

Boston, MA-USA

Project – MIFID II

MIFID II solution is to provide competent authorities (CA's) with the information about transaction. It aims to provide a representation of transactions that informs the C.A about all relevant circumstances under which the transaction took place. Depending on the trading capacity of the investment firm and whether or not investment firm is dealing for a client, a transaction may have to be reported in more than one report.

Responsibilities:

Supporting Client Implementation system (CIS) functional analysis efforts under GTB technology space

Deriving solution for business requirements and translating them into functional specification documents

Acting as a bridge between end user and IT to facilitate the communications

Performing or supporting User Acceptance testing

Provide transparency of the progress to the project stake holders and escalate when necessary

Technical Highlights

ETL Tool: STATE STREET ESP Tool

RDBMS: ORACLE (10g/11gEXADATA),

Test ManagementTool: JIRA

State Street Corporation Aug 2017 – Dec 2017

Boston, MA-USA

Worked as a Quality Analyst in Global Markets Risk Division Testing web based, Client/Server and data warehousing applications for various projects in Front office, Back office and Risk applications as per Business needs.

Project 1 - Counterparty Credit Stress Testing

Counterparty Credit Risk Stress Testing (CCST) project is intended to perform customized stressed scenarios for various portfolios and their corresponding collateral positions to meet the FED mandatory CCAR (Comprehensive Capital Analysis and Review) compliance. The credit exposures and marked to market values will be computed for a set of customized stress scenarios created at State Street for CCST.

Project 2 - Counterparty Credit Risk - EOD

Counterparty Credit Risk - EOD project is intended to retrieve data from source systems like SMD,IBS,WSS etc. and send the data to downstream applications that use stressed scenarios for various portfolios and their corresponding collateral positions. The data received is sent to downstream systems that calculate credit exposures and marked to market values for each trade retrieved at end of day.

Project 3 - Counterparty Credit Risk - Intraday

Counterparty Credit Risk - Intraday project is intended to enhance the business analytics to achieve real-time exposure management and credit risk monitoring enabling the traders to assess proposed trading activity against approved Risk limits to avoid credit exposure exceeding approved Risk Limits.

Responsibilities:

Supported business / functional analysis efforts for Client on boarding and Account Maintenance in the Global Markets business area

Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.

Analyzing requirements and creating and executing test cases using tools like HP Quality Center.

Perform Functional, Regression, Integration, Stress, Smoke and End-to-End application testing.

Create complex SQL queries to verify data from source to target to perform data validation on Oracle data ware housing applications.

Assessing testing processes, creating and implementing testing strategies in UAT phase.

Use HP QualityCenter and JIRA for storing, maintaining the test repository, bug tracking and reporting.

Retest the existing test cases with the different kind of source systems for different periods of data.

Preparing documentation for some of the recurring defects and resolutions and business comments for those defects

Developed UNIXscripts to validate the flat files and to automate the manual test cases.

Create scripts using in-houseETLAutomation Tool for automating as per business requirements.

Responsible for creating user profiles and provide access privileges for ETL Automation Tool users.

Develop Test Matrix to give a better view of testing effort.

Identify areas for improving efficiency, shortening of test cycles, and automation of test scripts and recommend solutions for improvement using automation testing tools like Ranorex.

Coordinating with onshore & offshore counterparts for project delivery, status reporting &overallproject management.

Validate Spotfire report data to identify any discrepancies.

Create complex SQLqueries to verify data from source to target to perform data validation on Oracledataware housing applications.

Assessing testing processes, creating and implementing testing strategies in UAT phase.

Work with Business Analysts to define requirements to satisfy the business objectives.

Environment: ORACLE (10g/11g, EXADATA), TOAD, SQL DEVELOPER, IBM-ALGO (5.1), Spotfire, Ranorex, HP Quality Center,JIRA, Microsoft Office, Internet Explorer, WindowsNT4.0/2000, HP/Unix.

American Express [Corporate Cards] May 2011 – Aug 2017

Chennai, India

Worked as analyst in Corporate Cards divisionfor sales and reporting system which is used by the end users.

Responsibilities:

Supported business / functional analysis efforts for Instrument Reference Data in the AMEXcorporate cards business area

Gathering the requirements from the clients

Preparing the specification documents and passing it to technology partners

Interacting with global data vendors like Bloomberg, Reuters, etc. to mapcustomdatapoints with our system

On-boarding the new clients and providing support to the existing clients

Interacting with development and testing teams throughout the SDLC

Experience in Agiledeliverymodel – SprintPlanning, ProductBacklogReview, Dailystand up meetings

Involved in dataAnalysis/ enrichmentusingOracle/ SQLqueries

UAT test script design and testing the functionality of the developed software with the system requirements and to acknowledge the developed software.

Providing UATsign – offandproductionroll out after testing the functionality

Environment: ORACLE 10g, SQL Navigator, SQL DEVELOPER, Cognos, HP Quality Center, Microsoft Office, Internet Explorer, WindowsNT4.0/2000, HP/Unix.

Education:

07/2008 – 04/2010 MBA, Banking Technology

Pondicherry Central University, Pondicherry,, India

07/2003 – 04/2007 JNTU, B. Tech in Electrical & Electronics

Jawaharlal Nehru Technological University, Hyderabad, India.

Contact this candidate