Tibco Spotfire Project 1
Resume:
Mohan D
*****.*****@*****.***
Senior Consultant QA Lead
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