Rajalakshmi Ramalingam
E-Mail: adlmig@r.postjobfree.com
H/P: +91-848*******
Professional Summary:
Having 6+ years of Experience in IT Industry in Software Testing with ETL and Pega Functional and Mainframe Testing.
Worked in Agile methodology.
Having Experience in Insurance,Telecom,Utility,Banking,HealthCare Domains.
Experience in Business flows PEGA Functional(E2E) process, involving multiple roles and interfaces
Handled PEGA Agents and activity Integration process flows in Functional Testing widely
Experience in Triggering the PEGA backend data to flow the process into UI, using PEGA studio tool & Agents subject to integration rules
Involved in preparation of ETL and Pega Functional Test scenarios, Test cases and executed the same.
Hands on Experience in ETL and complete project SDLC & STLC (Waterfall) life cycle
ISTQB Foundation Level Certified
Experience in preparing ETL test data for all ETL mapping rules to test the functionality of Informatica and DataStage V9.1 mappings
Extensive experience in Test Data Models and Batch schedule process.
Hands on experience in loading input files into Data ware house tools like Oracle DB and then used to trigger Process through by using UNIX scripts through putty.
Knowledge on Data Integration, Web Integration and PEGA Functional Testing.
Defect Reporting and Tracking using Tools like HP ALM 12.2,Mastercraft,JIRA
Knowledge on basic SQL queries to check the Target data tables.
Hands on experience in Mobile app testing,Ipad Testing
Experience in Maximo anywhere application
Certifications & Competencies Attained
Digital: IBM InfoSphere DataStage_Foundation.
Assurance : Data Warehouse BI Testing
ISTQB Certification
Technical Skills:
ETL Tools : IBM Infosphere Datastage V9.1,Informatica
Database : Oracle 10g
Languages : SQL,Java
Testing Tools : Winscp,Putty,Notepad++
Test Management Tools : HP ALM12.2,Mastercraft,JIRA
Academic Profile:
Completed M.Sc Mathematics at SASTRA UNIVERSITY.
Professional Experience:
Working as ETL Tester,Pega Functional Tester at TATA CONSULTANCY SERVICES from December 2014 to till present.
Project Synopsis:
Project #1:
Title : Technology Inventory Management
Client : Kaiser Permanemte,Chennai.
Technology : ETL,Oracle
Role : I.T Analyst
Description:
Kaiser Permanente is the largest integrated health care and health maintenance organization in US.By avoiding the duplication of customer records and its effort they started to worked in migration by collecting all the source data into Inventory to reduce the effort.
Responsibilities:
Involved in designing ETL Test cases
Creating Test Combinations with respect to business requirements.
Analyzing and Raising defects in JIRA and tracking till closure.
Closely follow-up Development team to fix the Defects
Project #2:
Title : Collection and Recoveries
Client : Lloyds Banking Group,Chennai.
Technology : ETL,Oracle,Unix,Mainframe
Role : I.T Analyst
Description:
Lloyds Bank is part of Lloyds Banking group,the UK’s leading financial services company which includes most of the well known brands Halifax,Bank of scotland.Debt collection is a creditor’s attempt to recover consumer credit and loans that have not been paid by a customer and debt recovery is when a loan such as a credit card balance continues to go unpaid and a creditor hire a third party to focus on collection the money.
Responsibilities:
Involved in designing ETL and Mainframe functional Test cases
Creating Test Combinations with respect to business requirements.
Handled sprint planning and review meetings
Analyzing and Raising defects in HP ALM,JIRA and tracking till closure.
Closely follow-up Development team to fix the Defects
Project #3:
Title : TNB Smart Billing
Client : Tenaga National Berhad,Kuala Lumpur (TCS Client).
Technology : Maximo anywhere,Mastercraft
Role : System Engineer
Description:
Tenaga National Berhad(TNB) is electric utility company in Malaysia and TNB Smart billing is Advanced Metering Infrastructure(AMI). The smart meters are electric-powered reading meters that allow daily electricity consumption to be recorded and converted into data which can be monitored by consumers.
Responsibilities:
Involved in designing Meter Installation type Test Cases.
Creating Test Combinations with respect to business requirements.
Creating manual test cases and executing the same.
Performing End to End testing with BCRM,3MS
Analyzing and Raising defects in HP ALM and tracking till closure.
Closely follow-up Development team to fix the Defects
Project #4:
Title : De-Tariff Insurance
Client : AmGeneral Insurance, Menera Shell, Kuala Lumpur (TCS Client).
Technology : HP ALM, Main Frames (AS 400), Batch Processing
Role : System Engineer
Description:
Tariff for General Insurance in Malaysia is governed by Bank Negara Malaysia. De-Tariff is the act of removing the pricing regulations of an industry set forth by tariffs created by a regulatory body. De-Tariff allows an industry to price its goods or services at market value to promote market equilibrium. AmGeneral Insurance Berhad has chosen the De-Tariff exercise for Motor and Fire products to be implemented in 2016. The de-tariff program is categorized into the following areas: Private Car, Motor Cycle and Commercial Vehicles.
Responsibilities:
Involved in designing Motor and Non Motor Insurance Test Cases.
Creating Test Combinations with respect to business requirements.
Creating manual test cases and executing the same.
Performing End to End testing with KEC and Amcore Applications.
Analyzing and Raising defects in HP ALM and tracking till closure.
Closely follow-up Development team to fix the Defects
Supporting the business users in UAT testing.
Application and Technical Support guidance to stake holders.
Project #5:
Title : Core,Illustration and Servicing
Client : American International Group(AIG)Japan Operations,Chennai
Technology : HP ALM 11.2, ETL DataStage
Role : System Engineer
Description:
AIG Japan plans to consolidate two old and expensive agency systems currently being used by its business unit Fuji Fire and Marine (FFM) and American International Underwriters (AIU) into one agent oriented, feature enriched, shared service system to expand FFM and AIU’s distribution and delivery capabilities, and also reduce system maintenance cost.
Responsibilities:
Involved in PEGA Functional Testing and ETL End to End Integration Testing.
Involved in writing Non-Life Insurance Test Cases with respect to Line Of Business(LOB)
We work with Pega Studio tool to trigger Pega Agent to run the Activity as part of Pega functional testing
As part of Data integration testing we work with Data Load use DataStage in-order to test Internal and External System connectivity.
Date :
Place : Chennai