SEEMA RAJARAM acyqha@r.postjobfree.com

TEST MANAGER 848 -247-3355

B.Tech(IT) 1915,Forest Haven Blvd,Edison,NJ 08817

CAREER OBJECTIVE

A forward thinking, capable and committed test manager with a proven ability to meet agreed deadlines, co-ordinate work and work to defined testing methodologies within a structured environment. Focused on any task at hand and able to utilize existing test knowledge and experiences to come up with practical solutions and alternatives to testing processes. Having first class executive leadership, negotiating and communicating skills and capable of providing authoritative guidance and advice to both in house and third party test teams.

PROFESSIONAL EXPERIENCE

Working as a Test Manager at HCL Technologies, Since Apr 2015 to till date.

Worked as Technical Test Lead at IBM, Since June 2011 to Mar 2015.

Worked as a Module Leader at Wipro Technology, Since Aug 2010 to June 2011.

Worked as a Programmer Analyst at Cognizant Technology Solutions, Since April 2007 to Aug 2010.

AREAS OF EXPERTISE

Application Report Testing (Oracle BI Apps Report Testing OBIEE 10g, OBIEE 11g and Fusion, Simcorp v 5 6 Report Testing)

DWH ETL Testing and Test Data Management

People Tools Testing (SAP CRM, HCM, EPM, HFM, Medvantage)

Web Application and Mobile Apps Testing (Manual and Automation)

Mainframe Testing (Manual and Automation)

HIGHLIGHTS OF QUALIFICATION:

The overall planning, budgeting, management and oversight of end to end Testing

Effective liaison with all relevant business stakeholders and system owners to ensure successful Testing outcomes within the planned timelines

Management of the creation, review and gain sign offs for Test Strategy, Test Plan, Test Scenarios and Test Cases, Test Results, Test Status Reports and Test Closure Report

Administration of the sourcing and preparation of Test Data and Test Environments

Supervision of the Testing team and standard Defect Management activities

Management of Testing Risks and Mitigation plan

Certify all Test deliverables are adherence to Software Quality standards and Complaints

Host project status meetings and Defect triage calls and statement the status and Defect Report to Project and Business team

Defined and track quality assurance metrics

Builds a testing team of professionals with appropriate skills, attitudes and motivation

WORK EXPERIENCE SUMMARY

Having around 10 years of experience as a QA Test Manager. I am currently handling team of 42 members (onsite, offshore and remote) and involved in all the phases of Software Testing Life cycle. Have versatile and diverse domain knowledge in Life Sciences (Pharma), Healthcare, Banking and Financial services (Capital Market) and Insurance.

PROJECT # 1A-1C

Projects : OBIA/OBIEE Upgrade, Hyperion Planning enhancement and Lilly Simplicity

Clients : Gilead, Incyte, Covance (US)

Business Unit : LSH - Pharma

Type : Oracle BI Apps Testing, ETL testing, People Tools Testing

Role : Oracle/DWH Test Manager

Environment : OBIEE 10g & 11g, SQL Sever

Tools : BODS, TIPCO, CRM, HCM, HP ALM/JIRA, ILM (TDM), MTM,

Duration Served : Jan 2015 – Jan 2017

Responsibilities:

Adept at developing and implementing SIT test concept, design of test strategy, test activities and responsibilities, test stages and methods, test case design

Trained and coached Testers to help define SIT testing plans and requirements.

Set and implemented product quality standards with effective quality assurance steps.

Scheduled all testing activities and prepared reports of all results

Management of Testing Risks and Mitigation plan

Prepares SIT Test execution plan in accordance with the integrated test plan

Exception handling and reporting

Reviews and approves E2E test approach and scenarios that will be run by the SIT Tester

Sign off SIT scope and Testing Approach

Works with Global Test Team to prepare SIT scripts based on existing global scripts

Perform Review on all SIT Test deliverables

Ensure all documents are adherence to Quality standards and Complaints

Gain sign off of all Test Deliverables such as Strategy, Plan, Scenarios and Scripts

Assess the impact of blocking defects on the testing schedule.

Manages SIT execution performed by Global Testing

Assist SIT Testing Team to perform Test and Defect Management in HP ALM

Prepare Deck on PAT GO/ NO GO and Ensure all Exit Criteria are met

Escalate Testing Issues to Project and Client Manager

Report Daily and weekly status reports, Defect Reports to the project manager and Client Managers

Conduct Daily status and Defect Triage calls with Project Team(BA/Dev/Test) and Business team

Partnering with development and Functional Testing teams across geographies and time zones to provide timely reporting on solutions

Report/ETL Testing Accountabilities:

Test Data file Preparation/Manipulation by cloning and Masking the production data based on the Business Requirement

Place the Source files in ETL job directory and Run all the jobs stage by stage to load Source Data to Target Database Systems during Initial and Incremental load

Ensure data completeness and correctness (SQL Query against Oracle database for Count, Duplicates, Rejection and Error handling validation)

Validation of OBIEE 11g Tool Functionality(User Authentication, Navigation to respective portfolios /subject areas, Dimension Structure and Hierarchy, Dimension selection, operation such as filter, aggregation, Customize, Save and Generate Reports in the Bar/Pie etc. charts, Distribution of Reports/dashboards to multiple channels (MS Application latest version Excel, Word, Emails),Scheduling of Reports

Data Transformation Logic Validation as per Business Rules (Risk indicator, FTE, Tax, FedEx and Interest Rates)

Compare the data in the report of upgraded version with the previous version and ensure both are sync

Validation on Accessing of OBIEE Reports from Mobile Apps (Android and iOS), Web browser (Single Sign On/NON SSO)

User security validation based on security matrix for the respective portfolios, Dimensions, Products etc.

Configure, Support and deliver a new functionality for All Assets classes, Risk Management

PROJECT # 2A-2C

Projects : MDM- CL Reload, OBIEE Upgrade 11g, HR Help Desk Upgrade

Client : TD Bank (Canada)

Business Unit : Banking

Type : DWH ETL and Report Testing with TDM, & People Tools Testing

Role : DWH Test Engagement Manager

Environment : UNIX and SQL Server, JCL, IE8

Tool : CRM, HCM, XML Tester, IBM Data Info sphere (TDM)/ILM, Putty Gen, HP ALM

Duration Served : Jul 2012 - Jan 2015.

Test Engagement and Business Relationship Management Roles and Responsibilities:

Worked with testing teams to develop comprehensive test/ assurance strategy plans for all aspects of testing (Unit, Functionality, System, Regression and Integration). Responsibilities include supervising/scheduling the testing staff, project management, overseeing test efforts and all testing phases across multiple projects.

Act as a liaison between HCL leadership and client leadership

Define the strategic direction for software quality assurance

Define tactical steps to achieve objectives, addressing success criteria of projects

Perform Project Manual Testing Activities using Microsoft Test Manager

Ensure QA projects are completed on time and own responsibility for the quality of the product and Effectively define and utilize metrics and reports to manage QA efforts

Provide effort estimates for project schedules for QA team

Review test estimates/schedules for completeness and accuracy and work with Project Management to align expectations on schedules and effort

Balance and manage multiple concurrent projects

Build cross-team alignment around quality objectives and the steps to achieve them

Manage to completion concurrent ad hoc and project related test requests

ETL/Report Testing Responsibilities:

Clone production data using TDM and Manipulate data for Testing as per Test case

Place the test data source files in the ETL Job directory and Run all the Jobs

Query against the tables and validation on Data completeness and correctness as per business requirements and Transformations logic

Validation of report testing tool Functionality and data on report(User Authentication, Navigation to respective portfolios /subject areas, Dimension Structure and Hierarchy, Dimension selection, operation such as filter, aggregation, Customize, Save and Generate Reports in the Bar/Pie etc. charts, Distribution of Reports/dashboards to multiple channels (MS Application latest version Excel, Word, Emails),Scheduling of Reports

SAP CRM/HCM Testing Responsibilities:

Testing & Creation of data the Enterprise Structure (Personnel areas, and Personnel sub areas), the Personnel Structure (Employee groups, Employee sub groups, Payroll Accounting Areas), and the Organizational Structure (Organization Units, Positions, Jobs.

Testing of various master data screens, action menus, and dynamic actions.

Created functional Mapping document and STM (Source to target Mapping)for inbound and outbound interfaces for global payroll interfaces based on the vendor requirement file

Test analysis of Hiring Action that includes all Payroll relevant info types.

Tested the configuration of public holidays, holiday calendars, break schedules, work schedules and work schedule rules.

Tested HR Help Desk Case Management and Workforce module

Expert for data mapping between legacy systems and SAP PA/OM

HR functions including maintaining employee relations, customer & client relationship management etc.

Maintain & Update Client Database

Filing Clients Documents and Telephone Liaison Internal/External

Word Processing of Letters, Documents and Reports and liaison with legal entities

Created Work Schedules, Period Work Schedules, And Daily Work Schedules and Planned Working

Time.

Defined Public Holiday Calendar for Personnel Sub Areas

PROJECT # 2D

Projects : SIMCORP Dimension Upgrade v5 6

Client : TD Bank

Type : SIMCORP testing (Reports)

Role : DWH Test Manager/Lead

Tool : Simcorp v5.6 (DWH Manager & Coric Client Communication Manager), HP ALM/JIRA

Database : IBOR

Duration : Apr 2014- Jan 2015

SIMCORP Testing Responsibilities:

Test Data file Preparation/Manipulation by cloning and Masking the production data based on the Business Requirement (Front office, Back office and Middle office Data)

Place the Source files in ETL job directory and Run all the jobs stage by stage to load Source Data to Target IBOR Database Systems during Initial and Incremental load

Ensure data completeness and correctness (SQL Query against IBOR Database for Count, Duplicates, Rejection and Error handling validation)

Validation of Simcorp Coric Client 5.6 Tool Functionality(User Authentication, Navigation to respective portfolios /subject areas, Dimension Structure and Hierarchy, Dimension selection, operation such as filter, aggregation, Customize, Save and Generate Reports in the Bar/Pie etc. charts, Distribution of Coric Client Reports to multiple channels (MS Application latest version Excel, Word, Emails),Scheduling of Reports

Data Transformation Logic Validation as per Business Rules (Risk indicator, FTE, Tax, FedEx and Interest Rates)

Compare the data in the report of upgraded version with the previous version and ensure both are sync

Validation on Accessing of conic client Reports from Mobile Apps (Android and iOS), Web browser (Single Sign On/NON SSO)

User security validation based on security matrix for the respective portfolios, Dimensions, Products etc.

Configure, Support and deliver a new functionality for All Assets classes, Risk Management

PROJECT # 2E-2F

Projects : BYOD, MCI Upgrade

Client : TD Bank (Canada)

Business Unit : Banking

Type : Web/Mobile Application testing

Role : Test Architect

Environment : IE8, windows

Tool : Mobile devices (IPhone iOS, Samsung Android), HP ALM, HP UFT (QTP)

Duration Served : Jul 2012 - Nov 2014.

Managed a team of testers for complex integrated enterprise systems

Coordinated with engineering teams and maintained documents according to project specifications

Planned all tests on projects and scheduled activities accordingly, developed various initiatives making test cost effective and increasing its efficiency,

Monitored and implemented all testing methodologies, Prepared and designed testing products according to testing standards and policies.

Reviewed staff performance and managed working of all staff members, administered working of vendors and clients and ensured scheduled progress of projects.

Coordinated with engineering teams and maintained documents according to project specifications.

Planned all tests on projects and scheduled activities accordingly.

Developed various initiatives making test cost effective and increasing its efficiency.

Monitored and implemented all automated Testing methodologies.

Prepared and designed testing products according to testing standards and policies.

Reviewed staff performance and managed working of all staff members.

Administered working of vendors and clients and ensured scheduled progress of projects.

Web Application Testing Accountability:

Functionality Testing: Test for user authentication and interaction, entire data work flow, all the links in web pages, database connection, forms used for submitting or getting information from user in the web pages, Cookie testing etc.

Usability testing: Test for navigation, content, Website should be easy to use, Instructions provided should be very clear, Check if the instructions provided are perfect to satisfy its purpose, and Main menu should be provided on each page.

Interface testing: verify the Web server, Application server and Data base server, Check if all the interactions between these servers are executed and errors are handled properly. If database or web server returns any error message for any query by application server then application server should catch and display these error messages appropriately to the users

Compatibility testing: Testing of Browser compatibility, Operating system compatibility, Mobile browsing, Printing options

Performance testing: Test application performance on different internet connection speed, DB response time, multiple user access at the same time

Perform Security testing

Mobile Application testing Responsibilities:

Make sure that Install and uninstall is smooth and hassle free. Also do test the upgrade scenario.

Ensure whether the application has been launched successfully or not.

Test whether the application works as per as requirement whenever the application starts/stops.

Verify all the links and buttons available in the app works as per design.

Validate that app successfully navigates from one page to another.

If a hybrid app, then any web link should open the web browser within the app. (Example Facebook app)

Verify that after tapping on any email links should redirect the installed email apps.

Test that each screen is appropriately displayed in each display mode (landscape, portrait).

Ensure that the app works correctly, if the mobile device resumes from the lock screen.

Test that the app does hang or crash when “Battery low” message appears on the screen or internet speed is low or there is no internet connection or user opens his app while listening to music or user is working on his app and start listening to the music.

Verify that the application should work normally and does not freeze after tapping on the screen ten times at different positions.

To validate that the user receives an appropriate error message like “Network error. Please try after some time” whenever there is any network error.

To validate that the application resumes at the last operation in case of a hard reboot or system crash

Perform Automation Testing of the tested web application during regressing testing using HP UFT(QTP)

PROJECT # 3

Projects : wmA upgrade

Client : Metlife

Business Unit : Insurance

Type : Web Application and ETL testing

Role : Technical test lead

Environment : IE8, windows

Tool : wmA, HP ALM, HP UFT (QTP)

Duration Served : Jun 2011 - Nov 2014.

Especially adept at identifying and recording risks and developing mitigating actions

Adept at developing and implementing SIT test plans and testing processes

Outstanding ability to manage SIT team projects in a timely manner

Strong ability to ensure that the right SIT testing procedures are being applied

Solid ability to manage SIT teams and resolve testing issues

Detailed knowledge of testing tools and procedures and Substantial people management and resource allocation skills

Excellent communications abilities, Trained and coached business users to help define SIT testing plans and requirements.

Set and implemented product quality standards with effective quality assurance steps.

Scheduled all testing activities and prepared reports of all results.

Reviewed testing costs and implemented cost-effective testing procedures.

Managed and supervised SIT testing team and addressed any issues.

Developed implemented and monitored SIT testing and test cases.

PROJECT # 4

Projects : Card Transactions (Debit/Credit)

Client : Mastercard

Business Unit : Banking

Type : Web Application and ETL testing

Role : Technical test lead

Environment : IE8, windows

Tool : wmA, HP ALM, HP UFT (QTP)

Duration Served : Jul 2010 – Aug 2011.

Provided progress reports to all clients and worked with vendors to resolve issues.

Prepared and updated test plans and implemented plans that proved to be effective.

Tracked results of user acceptance tests specific to Banking users.

Prepared and reviewed SIT test implementations and tracked any defects.

Developed and implemented SIT test plans and test cases.

Generated and managed results of all user acceptance tests for ecommerce users.

Monitored working of activities identified issues and documented it to be resolved later.

Determined new methods to test applications and prepared test plans.

Resolved all customer issues and ensured customer satisfaction at all times.

Designed various strategies and ensured program effectiveness

Performed Gray Box Testing, Regression Testing, Manual Testing, Functional Testing, Usability testing

Experience in Unit, Integration, System Testing using different devices(IPhone, IPad, IPod, Web based applications)

Execute Browser Compatibility Testing(IE, Firefox, Chrome, Safari) of a Web based application, Create and execute End to End Use Cases for User Acceptance Testing

Test GUI and functionality on Android and iOS

Test GUI and functionality on Windows 7, MAC OS X, Android, iOS platforms using VMWare and report numerous software defects in that area

ETL: Query against table to test the source to target count, data, mapping rules

PROJECT #5: SIT MEMBER ENROLLMENT APPLICATION

Client : Aetna

Business Unit: HealthCare

Type : Enhancement and Testing and Warranty Support

Role : Team Member / Module Lead, Automation Analysts

Environment: JCL, COBOL, DB2, CICS, .Net, SQL DB2, IBM DB2 and Web Applications

Tools : Endeavor, QC, CQ, File-Aid, ABEND -Aid, Macro & Automation Tool, MTM, HP ALM, HP UFT (QTP)

Duration Served: Apr 2007- Jul 2010

Testing Roles and Responsibilities:

Co-ordinate the work request,Analysis of the Requirement.

Preparation of Test strategy, Test plan, RTM,Test Scripts for Smoke, System, Integration, E-to-E, and Regression Testing using Microsoft Test Startegy

Requesting Test Data from upstream,Processing Job setup and Data setup.

Execution of the Test Scripts in Manual Scripts in MTM and Automated scripts in HP UFT(QTP)

Perform online Transactions(Insert,upate,delete,Inquire)

Prepare Input files,setup/customize JCl,Run batch Jobs and Exception Handling

Verification and Validation of the results,Tracking Issues and log the defects in CQ.

Generate Test reports using QC and Status reporting to onsite POC.

Preparation of production checkout artifacts and execute the scripts in production region.

Preparation of lessons learnt document for every releases and Given KT training sessions for ELTs.

Programming Experince:

Extensive hands on Coding experience with JCL,COBOL,REXX,Stored Procedures of Mainframe Applications

Expertise on writing complex SQL queries in DWH ETL Testing & Mainframe Project.

Skilled on writing VB Scripts to Automate Web based Applications

Good knowledge on HP UFT(QTP) for Autonate Cloud Application

Contact this candidate