Suraj Sundararaj Mobile : (***) *** -

****

Email : acd3y3@r.postjobfree.com

SUMMARY

I am a Competent and techno-savvy IT professional with 9 years of software

testing experience both in Engineering and Lead roles in Business

Intelligence/Data warehousing, web-based, stand-alone project assignments

across Retail, E-Commerce, Health Insurance, and Gaming/Embedded Domains.

. Currently lead a team of 24 Senior Testers/Junior Testers both Offshore

and Onsite from inception to delivery for complex technical data

warehousing program initiatives.

. Expert in testing of business intelligence/Data Migration/Data

Conversion solutions using manual/SQL ETL Testing methodologies.

. Strong Test Experience with Extract Transform (ETL) & Load using

Datastage and Extract Load Transform (ELT) based projects using IBM DB2

and TERADATA.

. Proficient in Data warehouse testing methodologies and extensive use of

tools like DataStage, TERADATA, Microstrategy Reporting, Web Focus

Reporting and Control M.

. Implement proven System Integration Test suites for Risk based Testing

methodologies.

. Well versed in Functionality testing, Integration testing, System

testing and Regression Testing.

. Extensive knowledge in Test & Defect Management tools like Quality

Center, ALM, Bugzilla, Sourceforge, JIRA, Zephyr

. Authored Test Plans, Test Strategy, test cases, requirements

traceability, Resource Estimation, Risk/Issues Analysis & Testing

Metrics.

. Extensively worked on file handling solutions with UNIX and XML.

. Proven track record in building strong Traceability Matrix Reports

(RTM).

. Complete and thorough understanding and adoption of the SDLC and STLC

with consistent contribution across the various stages of the Testing

lift cycle.

. Good understanding on tools like Selenium & Quick Test Professional

(QTP).

. Strong proven track record of building and maintaining key client

relationships

. Ability to learn quickly, innovate and apply new tools and technology.

TECHNICAL SKILLS

ETL Tools IBM DataStage, Control M, Informatica

Testing Tools Selenium, Quick Test Professional (QTP), ALM

Defect Tracking Quality Center, Bugzilla, SourceForge, Zephyr, JIRA

Tools

Reporting Tools Microstrategy, Web Focus

Operating System Windows XP/8, Mac OS X

Programming Java, .Net, HTML, XML

Languages

Scripting Languages VB Script, Java Script, UNIX

Database SQL Server, MS Access, DB2, Teradata

PROFESSIONAL EXPERIENCE

Employer: United Solutions Group Inc.

Mar 2013 - present

Client: Independence Blue Cross

Domain: Health Insurance

Designation: Software Test Lead

Project Title Informatics to Highmark Data Conversion & Migration

& Description This project dealt with complex Member Conversions,

Medical and Pharmacy Claims, App Retrofit activities

where the data was being migrated from the existing

Legacy systems along with the current data at IBC to

Highmark.

Highmark has various downstream applications each of

which had unique complex requirements and ensuring data

conversion and data migration happened in an accurate

manner along with reconciliation was the main focus of

this project.

Responsibilit Onsite Technical Lead and SPOC for all Member

ies Conversion, Claims, and Provider subject areas related

initiatives.

Lead a team of testers at offshore and coordinated

testing timelines, delivery and test data related

issues.

Mentor a dynamic team in complex Data Migration and

Conversion initiatives from inception to delivery.

Design, develop and review data migration test cases

for new data warehouse after merger, dealing with

complex data transformations.

Identify, mitigate, and monitor project risk, creating

contingency plans and advising as appropriate.

Work in conjunction with the QA Manager to define,

document, and improve processes supporting Testing

releases.

Efficient in quickly determining key issues, develop

timely strategic options, and design detailed action

plans to achieve the chosen objective.

Proficient skills in writing complex SQL queries for in

depth analysis of issues.

Manage data load activities various Test &

pre-Production environments.

SPOC for all Outbound Data Feeds/ Extracts for all

downstream applications managed by IBC & third party

vendors.

Analyze Source to staging and stage to target mapping

documents based on facts and dimensions and validating

the counts, PK, FK, duplicates, referential integrity

and business rules.

Generated custom test preparation/test execution/ Test

Metric reports in ALM

Employer: Target Corporation

June 2010 - Jan 2013

Domain: Retail/Finance

Designation: Sr. Software Test Engineer/Test Lead

Project Title PARS - Platform Architecture Relationship Support

& Description PARS Project is a business and technological

initiative, which involved movement of the existing

datawarehouse at Target from IBM DB2 environment to

TERADATA environment. This involved major forklift and

new functionality implementations, which had a huge

impact on the way data was transmitted across various

applications in Target. Existing Data was huge and

migration had to be efficient, effective, economical

and reliable.

Responsibilit Mentored and lead the Data Migration testing activities

ies for all processes connected with core processing

systems common in the Retail/Finance industry.

Implemented innovative QA Best practices for Test

Strategy, Test Plan and Test Estimation by designing

creative reusable templates.

Wrote complex SQL queries to validate data in Landing,

Staging and Foundation tables.

Demonstrated excellent team building and

cross-functional collaboration skills.

Managed testing team execution across multiple subject

areas.

Created robust status reporting for all levels of

management.

Created System testing documentation at all levels of

the project.

Detailed UI and Metric level validation of Front-end

reports with Microstrategy and Web Focus.

Designed, Wrote and executed test cases for ETL based

Jobs.

Designed simple Datastage jobs in Designer for testing

complex data scenarios.

Test for data migration from Source to Target, through

Landing, Dimension, Foundation, Mart and Stage

environments.

Scheduled Jobs through Control M with the help of Visio

diagrams.

Performing the layout level and metric level Reports

validation.

Responsible for preparing weekly status report and test

summary report.

Employer: Bally Technologies Pvt. Ltd.

August 2007 - June 2010

Domain: Casino Gaming/Innovation

Designation: Quality Assurance Engineer

Project Title Virtual Button Deck (VBD) & Casino Enterprise

& Description Progressive System (CEPS)

Virtual button deck is an alternative for the physical

button deck with the default functionality; (reel spin)

comes with attractive features like customizing

language, background and appearance of the buttons. VBD

communicates with the Save State Service to save these

user preferences. It provides bonus games for the user

to earn extra credits and dynamic button loading based

on the game.

CEPS is a tool to manage progressives, progressive

links, progressive levels, Electronic Gaming Machines,

Game information, Jurisdiction information and jackpot

summary with reports which can be generated & viewed.

Responsibilit Understanding CEPS BI business requirements and

ies Identification of test conditions based on

requirements.

Authored of test cases and reviewing of test cases.

Complete End-to-End testing with timely defect

tracking.

Liaison with Test Support team. Designed and developed

automation framework for Sanity build.

Involved in preparation of POC and demonstration before

client.

Involved in developing core generic library functions.

Active communication with Mercury Interactive for QTP

related issues.

Acted as Object Repository manager.

Communication with development team and client in US.

Responsible for preparing weekly status report and test

summary report.

Involved in preparation of interface files for

integration testing.

Detailed understanding of External Progressive

equipments used in Casinos.

Coordinate with the deployment and the development

team.

Contributed to defect logging, tracking and status

reporting.

Anchored the complete Hardware Setup of the team's Slot

Machines and got it up and running.

Employer: Infosys Technologies Limited

May 2005 - July 2007

Domain: Business Analysis/Insurance

Designation: Software Engineer

Project Title

& Description Claims Tracking Management Facility is a web based

application connected with Manhattan application to

keep track of the claims related activities like claims

booking, Claims Notification, approvals for the claims

document management and a lot more.

This application tremendously reduces the

administrative work for the claim manager and the claim

Analyst that in turn has produced effective and faster

means of communication and claim closure.

Responsibilit Identification of test conditions based on

ies requirements.

Authored of test cases and reviewing them.

Involved in complete end-to-end testing of the product.

Actively involved in interaction with the clients.

Involved in preparation of interface files for

integration testing.

Involved in logging defects using a bug-tracking tool.

Participated in Co-ordination between the Program Test

Manager and the Testing team and keeping the schedule

process updated.

Actively involved in interaction with the clients.

Liaison with Test Support team.

Involved in logging and follow up of defects using

Source Forge.

Performed Functional, GUI, Regression, System

Integration, User Acceptance, Configuration and content

testing for this product.

Conducted installation and cross-platform testing of

the product. (various Windows platforms)

EDUCATION

Bachelor of Engineering (Information Science & Technology) at Bangalore

College of Engineering & Technology (Visvesvaraya Technological University)

- 2004

CANDIDATE DETAILS

Name : Suraj Sundararaj

Current Location : Philadelphia

Visa : H1B

Mobile : (484) 686 - 2125

Email : acd3y3@r.postjobfree.com

Contact this candidate