RameshGangatharan_9.2 Years QA Analyst

Ramesh Gangatharan

Mob : +91-810-***-****

e-mail : ******.*****@*****.***

IT professional with an enriching cross functional experience of 9.1 years in software testing including international exposure, seeking challenging assignments as Test Lead/Senior Tester in reputed Global Software Organizations.

Key Skills: SOA testing, Web Service testing, ETL testing, Report testing, Black Box testing, People Management, Team Building/Coordination, Customer Relations, Organization Management

Domain Exposure: Banking and Finance, Insurance, Retail and Telecom.

Soft skills: Business Focus ~ Integrity ~ Teamwork ~ Passion for Excellence ~ Accountability ~ Respect

Career Abridgement

As a Test Lead have managed 8-14 members testing teams.

Experience of handling stakeholders across cross-cultural backgrounds in European nations and USA.

Extensive Knowledge of SDLC process, Software Testing Lifecycle (STLC).

Expertise in test estimation, test planning,, Test Case Design and Execution, Task Allocation,Test Report preparation, Defect Analysis & Tracking, Release activities.

In-depth expertise in Application testing, System testing, System Integration testing, PUAT, User Acceptance testing, Regression testing, End-to-End Testing and Automation testing and test methodologies to cover Functionality, Compatibility, Usability and Security.

Experience in ETL(Extract, Transform, Load) Testing, Functional Testing, Web service Testing, API testing, Database Testing, BO Report testing.

Adept at enhancing / modifying existing systems to meet the ever increasing demand of higher performance and turnaround times, added functionality, expandability, and improved user productivity.

Experience of working in Water Fall and Agile methodology.

Transition from an onsite implementation mode to an offshore.

Coordinate with client to support in release process and deployment activities.

Possesses good knowledge in software Process and Quality control.

Sound knowledge of End to End systems used in Telecom (Ordering & Provisioning)

Good working experience with Siebel products (CRM, OMS) and Billing.

Educational Qualification

Masters in Engineering (Computer Science and Technology), Sathyabama University

Masters in Science (Information Technology), Bharathidasan University

Bachelors in Science (Physics), Bharathidasan University

Certifications

NCFM Financial Markets from National Stock Exchange

Areas of Expertise

Banking, Derivatives, Settlement, Core banking System, Insurance and Clearing House activities.

Sales, Accounting, Invoice Retail system and Inventory process.

Telecom Business Support System (Sales & Billing Application) and Inventory Control System.

Test Management – Test Estimation, Test Plan preparation, Monitoring & Tracking project activities

Metrics collection – Planning and Execution Phase and Defect Management

Technical Expertise & Skill Set

Technology

Tools

Manual Testing

Test Planning, Designing and Executing Test cases using Functional Specifications. Reporting the Defect status. Documenting test cases, test results, and reporting to client

Test Analysis

Functional Requirement Gathering & Analysis, Analyzing Business Rules,

Test Flows, Test Planning, Root Cause Analysis of Defects, System Change Request, Impact Analysis

Testing Methodologies

Object Oriented, Keyword Driven and Data Driven testing, Top to Bottom and Bottom to Top test methodology, Requirement based, Risk based, Priority based test methodology,Waterfall, Spiral and Agile

Test Management Tools

TestDirector9.0/8.0/7.5, Quality Center 11/10.0 /9.0/8.2

ETL Tools

Ab Initio 3.X, Data Stage 8.5/7.5,Informatica 9.1.0,OWB,MDM(Asset Control)

Automation Tools

Selenium1.0.6, Win Runner 7.0, Quick Test Professional 9.2,Jmeter

Management Tools

Microsoft Office, MS Project, Time sheet management

Configuration Management

Clear Case, Clear Quest, Test Track Pro, TFS

Bug Reporting

Rational Clear Quest 7.1/7.0.1, Test Director, PVCS tracker, Bugzilla

Version Control

Visual Source Safe 2005, Control Version System CVS

Scripting languages

Java script, VB Script, HTML, XML

Programming Languages

Visual Basic 5.0

Operating Systems

Windows XP/NT/2000, DOS.

Databases

Oracle 10g/9i/8i/7.3, MS SQL Server 6.5/7.0/7.5/2000,Ingress,DB2,PL/SQL

MS Suite

MS Office 2000/2003/2007, MS Visio, MS-Project

Domains

Telecom Billing and Provisioning, Insurance, Banking and Retail

Telecom Products

CRM(Siebel), OMS

Career Profile

Mobily InfoTech India Pvt Ltd – Mar 2015 – till date

Primarily responsible for effort estimation, preparing the test strategy and test plan. Working as single point of contact of the testing deliverables with the stake holders, client and involving end to end testing activities and co ordination among cross application groups and application teams.

Tata Consultancy Services Limited – Aug 2011 –Jan 2015

Primarily responsible for effort estimation Analyzing Business Requirements and preparing the test conditions, Test Scenario and Test Data and Preparation of test cases based on RTM Preparation of the Master Test Plan. Working as single point of contact of the testing deliverables to the client and involving end to end testing activities and co ordination among cross application groups and testing teams.

Tech Mahindra Limited - May 2006 – July 2011

Primarily responsible for preparing the Test effort estimation Analyzing Business Requirements and preparing the test conditions, Test Scenario and Test Data and Preparation of test cases based on RTM (Requirements Traceability Matrix).Identifying QC resources and execute the testing flow with the QC team. As a test lead responsible for the QA associates and interfacing the offshore and onsite QA activities.

Highlights of Selected Engagements

Program / Project Name

Role

Location

Client

Finance Enhancements ASSPFM Reports(LTBT)

Test Lead

Offshore

Aviva Central Services UK Limited

European Market Infrastructure Regulation (EMIR)

Test Lead

Offshore

LCH Clearnet Inc.

Group Fees Specialization

Test Lead

Offshore

LCH Clearnet Inc.

eDw, Third Party Logistics

Test Lead

Onshore

Target Corporation Inc.

Advanced Sales Automation Platform (ASAP)

Test Lead

Onshore

American Telephone and Telegraph, Inc. (AT&T)

eSales &Service Edward Jones Inventory

Senior Tester

Offshore

American Telephone and Telegraph, Inc. (AT&T)

Organizational Facets

Assignments at Mobily InfoTech India Pvt Ltd, Bengaluru

Project

Credit Management and Revenue Collections

Customer

Mobily Systems, Riyadh,SA

Period

March 2015 – till date

Role

Test Lead

Description

Mobily Telecom is one of the leading telecom operators in Saudi Arabia having voice and internet solutions. Credit Management & Revenue Collections system tailored to handle and automate all its collection operations for the GSM and Non GSM products for the corporate customers.

Responsibilities

- Involved in reviewing High level Technical Documentation based on specification provided by the Business.

- Prepared the test strategy and test plan for the overall testing requirements.

- Train the testing team on functionalities and assign tasks.

- Reviewed the Functional Test cases for new/enhanced functionalities.

- Coordinating with Onsite Development Lead/ BA for clarifications.

- Developing/ Reviewing the testing deliverables templates.

Environment

Informatica 9.1.0, Oracle SQL Developer 2.1.1.64, Siebel CRM, XML,TDM, BO Reports and Unix

Assignments at Tata Consultancy Services, Bengaluru

Project

Finance Enhancements ASSPFM Reports

Customer

Aviva Central Services UK Limited

Period

March 2014 – Jan 2015

Role

Test Lead

Description

One of reporting tools is a business objects report known as ASPPFM. This report had a number of defects outstanding when Finance Transformation closed down. The ASPPFM Data Mart was signed off to go into production with some outstanding defects on the explicit assumption that these defects would then be addressed under the normal change process.

Responsibilities

- Providing consulting to customer to setup test strategy and processes for the ETL testing requirements.

- Managing the system Integration testing team, ensuring delivery, project/releases quality assurance, templates standardization, setting up processes and mentoring.

- Co-ordination across cross functional Teams and other Project Teams to resolve business related queries.

- Prepared and presented Master Test Plan (MTP), Test Estimates, and Test Strategy to all stakeholders.

- Identified project risks during initial phases, determined mitigation plan and escalated as appropriate.

-Responsible for Conducted Defect triage and Impact analysis for critical defects and determined mitigation plan

- Participated in Quality control audits for the project and several steering committee meetings.

Environment

Informatica 9.1.0, Oracle SQL Developer 2.1.1.64, BO Reports and Unix

Project

European Market Infrastructure Regulation (EMIR)

Customer

London Clearing House Clearnet Inc

Period

Aug 2013 – Feb 2014

Role

Test Lead

Description

EMIR project provides regulatory information about the central clearing of Over the Counter Trade (OTC) and Exchange Traded Derivatives. This project provides the Trade Repositories (TR’s) and RK (Record Keeping) information for all asset classes from LCH to Regulatory in the form of CSV files. Trade Repositories mainly contains the Positions and Trade information for the 6 Listed derivatives, Exchange Traded Derivatives such as FXC (Forex Clear) and other business streams such as ECL (Equity Clear) &Fixed Income.

6 Listed Derivatives: FEX (Financial and Energy Exchange),LME (London Metal Exchange), EDX (Enclear Exchange), TQD(Torquise/ED2),NLX (Nasdaq London Exchange), NEX (Nodal Exchange)

Responsibilities

-Coordinate with ETL team to implement all ETL test procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.

-Collaborate with Development Manager and perform tests and provide update to all ETL activities within schedule and provide support to all large data volumes and assist in data processing.

-Document all DS and system specifications for all ETL processes and perform tests on all processes and prepare required scripts.

-Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements.

-Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.

-Prepare the DSR,WSR and communicate to stake holders.

Environment

Informatica 9.1.0, Oracle SQL Developer 2.1.1.64, Unix, QC 10

Project

OWB Migration

Customer

London Clearing House Clearnet Inc

Period

Apr 2013 – July 2013

Role

Test Lead

Description

The Global fees ETL that loads Fees related data to the Strategic Data warehouse was migrated from OWB to Informatica. The objective of the testing is To validate Informatica results against OWB results to make sure that the functionality of ETL is not changed after migration to Informatica.

Responsibilities

- Providing consulting to customer to setup test strategy and processes for the ETL requirements.

- Improving performance and scalability by migrating legacy systems to Informatica.

- Managing the system Integration testing team, ensuring delivery, project/releases quality assurance, templates standardization, setting up processes and mentoring.

- Co-ordination across cross functional Teams and other Project Teams to resolve business related queries.

- Prepared and presented Master Test Plan(MTP), Test Estimates, Test Strategy to all stakeholders.

- Identified project risks during initial phases, determined mitigation plan and escalated as appropriate.

-Responsible for Conducted Defect triage and Impact analysis for critical defects and determined mitigation plan

- Participated in Quality control audits for the project and several steering committee meetings.

Environment

Informatica 9.1.0, Oracle SQL Developer 2.1.1.64,Unix, QC 10

Project

Synαpse

Customer

London Clearing House Clearnet Inc

Period

Nov 2012 – March 2013

Role

Test Lead

Description

MDM receives market data (future prices, settlement prices, volatilities, etc.) from the London Metal Exchange (LME) and Reuters via the MDM External Interfaces. It publishes provisional and final (authorized and enriched) market data to Synαpse (BαNCS) system via the Enterprise Service Bus (ESB).

Responsibilities

-Coordinate with ETL team to implement all ETL test procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.

-Maintain MDM test cases in the Quality Center and prepare the status reports on the daily basis.

-Work with SIT/cross functional teams to determine test case reuse opportunities, identify the test case scenarios for the SIT, implement the test case writing standards, review test inventories/deliverables for integrity completeness throughout the end to end business flow.

-Document all Data Services and system specifications for all ETL processes and perform tests on all processes and prepare required scripts.

-Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements.

-Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.

-Prepare the DSR, WSR and communicate to stake holders.

Environment

Informatica 9.1.0, Oracle SQL Developer 2.1.1.64, SQL,Unix, QC 10, MDM Asset Control

Project

Group Fees

Customer

London Clearing House Clearnet Inc

Period

Aug 2012 – Oct 2012

Role

Test Lead

Description

Group Fees is the application for the transactional and reference data for the LCH Clearnet. This application is used to compute Fees and Rebates due from/to the members of the LCH Clearnet Ltd. It receives the Reference data from MDM and transaction data from exchanges and clearing houses. It also Generate Invoices, Accounting, Banking files and MIS reports.

Responsibilities

-Coordinate with ETL team to implement all ETL test procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.

-Collaborate with Development Manager and perform tests and provide update to all ETL activities within schedule and provide support to all large data volumes and assist in data processing.

-Document all Data Services and system specifications for all ETL processes and perform tests on all processes and prepare required scripts.

-Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements.

-Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.

-Prepare the DSR,WSR and communicate to stake holders.

Environment

Informatica 9.1.0, Oracle SQL Developer 2.1.1.64, SQL,PL/SQL, Unix, QC 10

Project

Trust Express

Customer

Bank of America

Period

Mar 2012 – July 2012

Role

Test Lead

Description

Trust Express is a Global Wealth and Investment Management - Account open and Account close workflow enabled system. It reduces the manual work in submitting questionnaire for different trust account types. Trust Express is connecting to its Mainframe master feed system called PACE to get latest data by nightly batch runs. In Account close, the request will be created and assign to close the account.

Responsibilities

- Involved in the Analysis of Functional Requirements, BR document and identifying the scenarios and estimations.

- Involved Quality centre setup for different projects like Requirements, Test plan and Test lab setup.

- Involved in analysis of regression test scenarios.

- Involved in Knowledge based documentation.

- Involved in preparing test plan and UAT Support .

- Prepared the metrics dashboard at the end of the testing phase.

Environment

Ab Initio 3.X, Oracle SQL Developer 2.1.1.64, Oracle, SQL,PL/SQL, DB2,Teradata 12.0,QC 10,Autosys

Project

ecommerce data warehouse spring

Customer

Target Corporation Inc

Period

Aug 2011 – Feb 2012

Role

Test Lead

Description

eDW (ecommerce data warehouse) serves as a financial reporting data warehouse for items sold on Target.com. It interfaces with other Target.com applications to obtain the operational data. Once/Twice each year an eDW release is imminent to provide more relevant metrics, by way of enhancing calculations and adding attributes to the data warehouse Business Strategy Supported. The primary goal of this project is to provide an enhanced insight into the Target.com business by incorporating recent methodology and business changes. Also ensuring improved system response and performance throughout. Improving Gross Margin and Profitability.

Responsibilities

-Agile Methodology - System Study, Sample analysis, Detailing the risks, assumptions and limitations of the

software testing project

- Assisting peers in creating the Test scenarios, Reviews and Walkthroughs.

- Creation of Test scenarios, Test Cases/Scripts, Test Data.

- Test data management and Defect Reporting and Defect metrics.

- Maintain records of all quality activities as documented in procedures and test methods.

- Evaluate and communicate the achieved test coverage, test results and test effectiveness.

Environment

Data Stage 8.5, Oracle SQL Developer 2.1.1.64, SQL,PL/SQL, DB2, Unix,QC 10, control -m

Assignments at Tech Mahindra Limited, Bengaluru

Project

Consumer Prices Index/Retail Prices Index ONS

Customer

British Telecom, Newport, UK

Period

Jan 2011 – July 2011

Role

Test Lead

Description

The current Consumer Prices Index/Retail Prices Index (CPI/RPI) computer system is used to input consumer prices data, aggregate the data and produce final outputs. In the first phase, the replacement system will deliver the functionality of existing spreadsheets used to capture and calculate indices for centrally sampled items. Once the replacement system has been transitioned into the user environment, the current Ingres system will continue to support local price collection, central shop collection and the production of main indices.

Responsibilities

-Review test deliverables, defects and test results created by team members

-Create reports (DSR, WSR) and create testing metrics as requested by senior management

-Review testers work (during test plan and test execution); ensure testing is completed on time and within budget; resolve conflicts arising between team members or with external team members.

-Identify risks and provide mitigation plan; escalate issues on timely manner to management

-Ensure testing team is following testing standards, guidelines and testing methodology as documented in Test Approach

-Ensures entry criteria are met before starting with testing

-Ensure exit criteria is met and communicates the same to required stake holders

-Creates and signs off the Test Closure Form (also known as Test Closure Memo) and obtains the approval from the required project/release stake holders

-Ensures deliverables are created as per Quality Management practices followed by the company or as outlined for the project/release.

-Participate in QA (Quality Assurance) reviews and provides required support and clarifications as need for the reviewers.

Environment

XML, WebLogic, SOAP UI Pro, Siebel CRM, Oracle 9i, TOAD, SQL,JIRA,xml, Jmeter

Project

Advanced Sales Automation Platform (ASAP)

Customer

AT&T, Middletown, NJ

Period

Jan 2009– Dec 2010

Role

Test Lead

Description

Advanced Sales Automation Platform is build out the Target Architecture components for the Sales Domain. This includes the target Pricing tool (ADOPT), target Contract Generation and Management Tool (ABSCON), target ETE Sales Workflow (eCRM) and target Service Order & Billing handoffs. To reduce the Sales cycle time by automating the sales workflow process. The focus is to define requirements that will result in decreased back-office times for the Sales teams, eliminate re-keying of data by the re-use of existing data entered and stored to minimize the amount of user input required to access a particular function of the integrated platform.

Responsibilities

- Involved in End to End testing and Regression testing

- Prepared the Test plan and QA documents

- Creating Bug Report and log the Bugs.

- Coordinated with developers, onsite people and clients.

- Involved in reviews and peer review

- Participated in Quality control audits for the project and Developed the automation frame work.

Environment

XML, WebLogic, SOAP UI Pro, Siebel CRM, Oracle 9i, TOAD, QTP 9.2

Project

eSales &Service Edward Jones Inventory

Customer

AT&T, Middletown, NJ

Period

February 2008 – Dec 2008

Role

Senior Tester

Description

DBOR needs to receive “fielded data” for AVPN-domestic, which includes Site-ID detail in AVPN Stuffer Report that is in a structured format listing every field element in a record layout. DBOR needs to receive the GBP file monthly and format to the Data Dictionary (XML Schema) and sends to Customer when it is complete. DBOR needs to update the existing Data Dictionary (found in BD eBill) to accommodate the additional Site ID Detail for AVPN-Domestic and Canada.

Responsibilities

- Analysis of Functional Requirements, BR document and identifying the scenarios.

- Preparing test cases, log defects, diagnose issues in the HP Quality Centre 9.2 and validation of test results.

- Co-ordination across cross functional Teams and other Project Teams to resolve business related queries.

- Responsible for Conducted Defect triage and Impact analysis for critical defects.

-prepared the DSR and WSR and communicated to the stake holders.

Environment

XML, WebLogic, SOAP UI Pro, Siebel CRM, Data Stage 8.5, Oracle 9i, TOAD and Unix

Project

AVPN e-bonding Inventory

Customer

AT&T, Middletown, NJ

Period

Nov 2007 – January 2008

Role

Tester

Description

Database of records (DBOR) is a repository of database for multiple web-services through a same streamline. It gives the entire process in which the enhancements made and how it is processed. In this project, there are several Web-services, which retrieve the response from different Interfaces. The request is given in the form of XML, which retrieves the response from DBOR and comparing the response with Database UIS.

Responsibilities

- Preparation of test cases.

- Involved in Execution of test cases.

- Performed System Testing and Regression Testing.

- Involved in daily status meetings.

- Preparation of defect reports and reporting in the status call.

Environment

XML, WebLogic, SOAP UI Pro, Siebel CRM, Oracle 9i, TOAD and Unix

Project

CMDB Requirement in Support of General Motors

Customer

AT&T, Middletown, NJ

Period

May 2006 – Oct 2007

Role

Tester

Description

AT&T has a business need to develop the capability of providing General Motors with a centralized view of their current AT&T Business Services inventory. This centralized view stores all Configuration Items (CI) attributes and relationships across all IT components, which is supported by AT&T.

Responsibilities

- Preparation of test cases.

- Involved in Execution of test cases.

- Performed System and Regression Testing.

- Writing SQL queries and extracting data and comparing the values with the reports.

- Preparation of defect reports and reporting in the status call..

Environment

XML, WebLogic, SOAP UI Pro, Siebel CRM, Oracle 9i, TOAD and Unix

Contact this candidate