Lakshminarayanan Radhakrishnan Contact: 973-***-****

Email id: ac26np@r.postjobfree.com

Location: San Francisco, CA

PROFESSIONAL SUMMARY

ISTQB Certified - Senior QA Test Engineer and Technical Data Analyst having around 6+ years of experience in ETL, Business Intelligence (BI) and Data Warehouse in all phases of Software life cycle (SDLC) including Requirement Analysis, Test Planning, Test Design, Test Environment setup, Test Data setup, Test Execution, Defect Triaging, RCA, Data analysis and Test Closure.

Strong Understanding of Star Schema, Snowflake Schema, Metadata, Facts and Dimensions.

Have expertise in Black box, System Integration testing, UAT, Interface testing, Data Migration testing, Risk based Regression testing and Data Warehouse testing.

Strong experience in different Databases like Oracle, MS SQL Server and MS Access

Experienced working in Agile & Waterfall methodology projects.

Have good working experience in Treasury application such as Wall Street Suit (WSS)

Having good working experience in Salesforce(CRM)

Have domain expertise in Treasury, Capital markets.

Sound knowledge in ETL tool like Informatica 9.5.1, Cognos BI and Cognos EP

Proficient in Defect Tracking Tools: HPQC, HPALM and JIRA

Very good understanding of Data Warehousing concepts, Data Analysis and Data Warehouse Architecture.

End-to-End Defect Management - Detecting defects, co-coordinating with the Business and development to triage and tracking them to closure using Test Management tools like HP Quality Centre/ALM, JIRA

Acquired sound skills in testing methodology - Preparation of test ware like Effort Estimation, Test Plan, Test Scope document, Test Scenarios, Test Scripts, Test cases, run plan, Day-Zero checklist, Test Execution involving End to End Defect Management and Test Summary.

Experienced working in Automation tool to compare huge data base to reduce the manual efforts.

Extensively involved in various User Acceptance Testing and System Integration Testing in Data Warehouse platform by understanding the Business Requirement Documents & Functional Specification Documents, decomposing them into testable functions & executing them.

High-powered, innovative, and technically inclined professional with extensive and progressive background in IT functions with good analytical, presentation and strong communication skills.

TECHNICAL SKILLS

Applications : WSS, Salesforce (CRM)

ETL Tool : Informatica Powercenter 9.5.1

Reporting tool : Cognos EP, Cognos BI 10.2, EP

Agile tool : Rally, JIRA

Databases : Oracle, MS SQL server and MS Access

Front End Tools : SQL Developer

Defect Management tool : HPALM 11.0/ HPQC/ JIRA

S/W Testing Methodologies : Agile, Waterfall Methodology

Data warehouse Model : Star and Snowflake Schema

Education

Masters in Computer Applications from Bharathiar University, Coimbatore, India, 2011

Bachelors in Computer Applications from Bharathiar University, Coimbatore, India, 2008

ISTQB (International Software Testing Quality Board) certified

Certification in NCFM –Interest Rate Derivative.

EXPERIENCE SUMMARY

SQS BFSI INC (formerly known as Thinksoft Global Services Ltd, India)

Designation: Senior Test Engineer

From: July.11.2011 to till date

Project – 1 Dec 2016 – Till Date

Project name : End user compatibility & MDM Testing

Client : Federal Home Loan Bank

Role : Senior Test Engineer

App/Tools : Oracle, MS SQL Server, Macro, Jira & HPALM

Testing Model: Agile Methodology

Location : San Francisco, California

Description:

Currently End user compatibility includes application & Data testing and MDM Testing includes data validation. This project is mainly focussed on reports. Multiple complex Reports are generated from different source systems and will be delivered to client on frequencies (Daily, Monthly, Quarterly and Adhoc).

Responsibilities:

●Currently Handling Offshore Team with 7 Resources.

●Preparing Effort Estimation based on the Testing Scope.

●End-to-End QA Test management.

●Conducting daily meetings with stakeholders to understand progress on Sprint.

●Role includes continuous interaction with Business to understand Business Requirements & Functional Specification documents and transform the information into Test Plan, Test scenarios and Test cases.

●Performing Detail testing on data getting staged and transformed from multiple application via ETL, making sure all the data movements and logics are incorporated across the board till reporting.

●Working with Business Stakeholders to understand their business requirements and interpreting the same to IT team through requirement elicitation, business requirement analysis.

●Performing detailed impact analysis on business processes/system flows synthesized findings and provides suggestions based on data or functional requirements change.

●Collaborated with cross-functional teams (business users, IT Managers, technical architects and developers) to ensure maximum process quality including process documentation.

●Preparation of Functional Requirement Document and Requirement Traceability Matrix.

●Reviewing technical design documents created by the Development team.

●Co-ordinated Defect Meetings with Development / Business Users

●Analysing & reviewing the tasks created by QA team.

●Participated in the preparation of test cases for User Acceptance Testing.

●Reviewing the implementation of Business requirements in each sprint.

●Preparation of Functional Requirement Document and Requirement Traceability Matrix.

●Creating functional User stories based on business requirement throughout the Agile Process.

●Performing root cause analysis, identifying and resolving data quality issues for remediation.

●Performing data quality audits on project data for business rule violations and incorrect data.

Project – 2 May 2015 – Nov 2016

Project name : Client service Reporting

Client : Bridgewater Associates

Role : Senior Test Engineer

App/Tools : Salesforce, MS SQL Server, Jira

Testing Model : Agile Methodology

Location : Westport, Connecticut

Description:

Client service Reporting is used to consolidate, analyse, prepare and provide investment reports to clients on frequencies (Monthly, Quarterly). Internal applications are used to calculate and analyse the data. The client service reporting is used to perform various tasks such as storage of data from all the source Investment applications, Transform and format the data received from upstream application. Later the downstream applications pull transformed data and generate reports.

Responsibilities:

●Role includes continuous interaction with Business to understand Business Requirements & Functional Specification documents and transform the information into Test Plan, Test scenarios and Test cases.

●Performing Detail testing on data getting staged and transformed from multiple application via ETL, making sure all the data movements and logics are incorporated across the board till reporting.

●Performing detailed impact analysis on business processes/system flows synthesized findings and provides suggestions based on data or functional requirements change.

●Preparation of Functional Requirement Document and Requirement Traceability Matrix.

●Creating functional User stories based on business requirement throughout the Agile Process.

●Performing root cause analysis, identifying and resolving data quality issues for remediation.

●Performing data quality audits on project data for business rule violations and incorrect data.

●Smoke testing the environment once the QA code migration is completed.

●Preparing Effort Estimation based on the Testing Scope.

●End-to-End QA Test management.

●Conducting daily meetings with various stakeholders to understand the progress on Sprint.

●Perform unit testing once the development is completed at end of each sprint.

●Performed salesforce (CRM) application testing.

Project – 3 Jan 2014 – April 2015

Project name : GL Migration

Client : GE Treasury

Role : Test Lead

Tools : Informatica Power Centre 9.5.1, Cognos BI/EP, Oracle, HPALM

Testing Model: Waterfall model

Location : Stamford, Connecticut/Chennai, India

Description:

GE Corporate treasury analyzes, monitors, and strategizes to mitigate business foreign investment risks within GE.

The project mainly aims at migration of Capital data from CCL to new system Oracle GL for the nine treasury Management entities. The Data for the Capital treasury MEs will be routed to GE CAPITAL GLOBAL LEDGER while the data for Capital & Industrial business MEs will continue to be routed to CCL through ESB from different sub ledgers. This document provides you the information of each individual sub ledgers segregated at management entity level and stored into CCL and Oracle GL systems.

GE Capital has mandated businesses to consolidate all General Ledgers under a single general ledger platform and common chart of accounts. Treasury currently operates on the GE Corporate ledger and is an outlier from a GE Capital perspective.

In the wake of GE Enterprise standards, Capital treasury has determined to migrate from CCL (Central Corporate Ledger) to the next platform GE Capital General Ledger (GE CAPITAL GLOBAL LEDGER) for capital businesses.

Responsibilities:

●Working with Business Stakeholders to understand their business requirements and interpreting the same to IT team through requirement elicitation, business requirement analysis.

●Performing detailed impact analysis on business processes/system flows synthesized findings and provides suggestions based on data or functional requirements change.

●Collaborated with cross-functional teams (business users, IT Managers, technical architects and developers) to ensure maximum process quality including process documentation.

●Preparation of Functional Requirement Document and Requirement Traceability Matrix.

●Reviewing technical design documents created by the Development team.

●Documentations to support Process Diagrams, High Level Designs, Business Data mappings, Data modelling.

●Co-ordinated Defect Meetings with Development / Business Users

●Analysing & reviewing the tasks created by QA team.

●Participated in the preparation of test cases for User Acceptance Testing.

●Reviewing the implementation of Business requirements in each sprint.

●Tracking each business requirement till the closure of the sprint.

●Highlighting the risks and mitigations to Scrum master on daily sprint meetings.

●Conducting daily meetings with stakeholders to understand progress on Sprint.

●Perform unit testing once the development is completed at end of each sprint.

●Identifying business data issues and escalating the same to business team after each sprint

●Extensively worked in Rally tool to update the daily activities during each sprint

●Potential knowledge in running batch loads using Informatica tool

●Responsible for end to end Defect and project tracking

Project – 4 Sep 2013 – Dec 2013

Project name : Wall Street Suite

Client : GE Treasury

Role : Test Engineer

Tools : WSS Application, HPQC

Testing Model: Waterfall model

Location : Stamford, Connecticut/Chennai, India

Description:

GE Corporate treasury analyses, monitors, and strategizes to mitigate business foreign investment risks within GE.GE Treasury uses the WSS application as trading system. All types of trades are initiated and captured in this system.

Responsibilities:

●Role includes Understanding BR/FS decomposing them in Testable functions like Test Scenarios, Test Cases and Test Steps.

●Have delivered multiple releases (Data Migration, Enhancements, New functions, Bug fixes) on success note

●Have written test cases during my offshore tenure

●Involved in Test Scope, Run Plan Preparation and performing regression testing in existing functionalities and defect prone areas.

●Execution of test cases.

●Provided training for new members of the team in Project execution.

●Involved in the enrichment of Test Scripts based on the release changes.

●Prepared Defect logs, Closure logs and Defect Tracking using HPQC.

●Tracking each business requirement till the closure of the sprint.

●Highlighting the risks and mitigations to Scrum master on daily sprint meetings.

●Conducting daily meetings with various stakeholders to understand the progress on Sprint.

●Perform unit testing once the development is completed at end of each sprint.

●Identifying business data issues and escalating the same to business team after each sprint

●Extensively worked in Rally tool to update the daily activities during each sprint

●Ran the batch runs to load the data into necessary interface and applications.

●Responsible for end to end Defect and project tracking

Project - 5 July 2011 – Aug 2013

Project name : Functional Currency simplification

Client : GE Treasury

Role : Test Engineer

Tools : Informatica Power Centre 8.x, Cognos BI/EP, Oracle, HPQC

Testing Model: Waterfall model

Location : Stamford, Connecticut/Chennai, India

GE Corporate treasury analyzes, monitors, and strategizes to mitigate business foreign investment risks within GE. This project will identify accounting exposure either from remeasurement through earnings or revaluation through CTA and it needs to identify and display foreign net investment balances that are subject to revaluation and quantify the potential impact which can be hedged.

Responsibilities:

●Role includes analyzing BR/FS and performing Gap analysis to identify the Gap’s between BR and FS.

●Have delivered multiple releases (New ETL Data warehouse components (ETL), Data Migration, Enhancements, New functions, Bug fixes) on success note

●Have tested multiple Cognos reporting solutions

●Have written test cases during my offshore tenure

●Understanding BR/FS decomposing them in Testable functions like Test Scenarios, Test Cases and Test Steps.

●Involved in Test Scope, Run Plan Preparation and performing regression testing in existing functionalities and defect prone areas.

●Preparing SQL Queries required for the execution of test cases.

●Performing Test Execution in HPQC by running the Test Scripts and Cases.

●Provided training for new members of the team in Project execution.

●Involved in the enrichment of Test Scripts based on the release changes.

●Prepared Defect logs, Closure logs and Defect Tracking using HPQC.

●Day Zero checks and Smoke Testing before the start of QA Test Execution.

PERSONAL DETAILS

Date of Birth : 10-Sep-1988

Visa : H1B (USA)

Visa validity : 10-JUN-18

Contact this candidate