SYNOPSIS

Masters in Engineering Technology, with twelve years of experience in Software Development Life Cycle and Quality Assurance. Vast experience in requirements analysis, design and automated testing of Client/Server and Web-Based Applications. Highly skilled in automation frameworks, modification and enhancement of automated test scripts. Six years of experience leading and mentoring QA teams. Extensive experience in HP Application Lifecycle Management ALM and IBM Rational Suite. Vast experience in creation of test data using databases, flat files, excel, xml. Actively participated in all the stages of the Software Development Life Cycle and Testing Life Cycle. Consistent performer with excellent verbal, written, communication and professional skills.

SPECIFIC EXPERTISE

• Software Testing and Documentation, Analysis of the Business Requirements and the Software Requirements Specifications
• Formulating Test Plans and Test Cases based on the User Requirements document URD and System Requirements document for the functionality, security, performance, configuration and usability testing
• Vast experience in UAT and assisting end users during acceptance testing.
• Extensive experience in Rational Suite, HP ALM, HP UFT QuickTest Pro and LoadRunner.
• Designing automation test architecture and developing test scripts for smoke, regression and performance testing
• Proficiency in object-oriented programming languages C , JSP and databases - Microsoft SQL, Oracle Sybase on Unix as well as Windows platforms
• Proficiency in testing Client/Server and Web-Applications
• Extensive experience in bug tracking tools Rational ClearQuest and Quality Center

TECHNICAL SKILLS

• Testing Tools HP ALM Quality Center , HP UFT QuickTest Pro , WinRunner, LoadRunner, SilkTest, Rational Robot, Rational TestManager, Rational ClearQuest, Rational RequisitePro.
• Programming Languages C, C , C , Java, Visual Basic, PL/SQL
• Scripting Languages TSL, SQABasic, ASP, JavaScript, VBScript, 4Test
• Operating Systems Windows, UNIX, LINUX, Solaris
• ETLs Informatica 9.5.0, PowerCenter
• Profiling Tools Informatica Developer, Informatica Analyst, Test Data Management
• Databases Oracle, SQL Server, Teradata, Greenplum, Netezza, DB2, Sybase
• Web Technologies HTML, XML, ASP, IIS, Apache, WebLogic, Web Sphere
• Reporting Tools MicroStrategy, COGNOS

EXPERIENCE SUMMARY

Confidential

UAT Lead

Worked as UAT Lead for the Uniform Collateral Data Portal application which is part of the Loan Collateral Advisor Suite. The Uniform Collateral Data Portal application provided real estate collateral data for Lenders to help deliver high quality loans to the GSEs - Freddie Mac and Fannie Mae. As a UAT lead was responsible to analyze business requirements driven by feature enhancements and provide a comprehensive UAT Test Strategy, Plan and Execution.

Responsibilities:

• Interact with the Vendor Project Management Team and the GSE Project Teams during requirements review meetings to understand the core functionality on a release.
• Create UAT Test Strategy and UAT Test Plan for each release.
• Interact with Vendor Development and QA Teams to understand the design and enhancements being addressed and the testing goals on a release.
• Create test data required for a release which involved modifying xml files that contain appraisal data.
• Create draft UAT schedule and discuss with Project Teams to get approvals and set timelines.
• Provide project team with UAT timeline estimates and resource requirements.
• Review System Integration Testing SIT test cases and provide feedback with needed changes and provide sign-off prior to commencement of SIT.
• Review SIT results prior to start of UAT to verify all functional testing is completed.
• Manage three UAT environments with test users and maintain test data required in each environment.
• Work with multiple releases of the application back-to-back with parallel swimlanes.
• Maintain a comprehensive Regression suite and execute all regression test cases at the end of UAT cycle.
• Create and track defects using JIRA application for each release.
• Work as SME for the application for any new resources coming onboard to get them up to speed on functionality and operations.
• Provide a daily execution report during UAT cycle and upon completion provide a Test Execution Summary report and acquire approvals from business owners and provide UAT sign-off for deployment to Production.
• Analyze and update Regression Suite with addition or deletion of test cases at the end of each release.
• Manage release test artifacts in HP ALM.
• Create an Automation Framework for Regression Testing in HP UFT to test all rules triggered based on data points.
• Create a modular framework based on Driver script, Environment Settings, Shared Object Repository, Reusable Actions, User Defined Functions and Recovery Scenarios.
• Automation framework is based on a driver script which reads hundreds of test cases validating all the rules defined within the system.
• Driver Script is dependent on Environment Settings which can be customized to suit the requirements of the test smoke, full regression, various environments, result displays.
• Framework was designed in a manner in which when a new rule is created it would automatically be tested without any script vbscript changes.
• Customize UFT execution results in html files through Automation Framework to make it more readable for Business Users.
• Create and publish Framework Design and Automation Guide documents to help any project team member with or without knowledge of HP UFT to run Automation suite.
• Provide training to project team members with setup and execution of Automation Scripts so that the project is not dependent on a single resource.
• Participate in weekly joint Project Manager meeting calls to discuss current project timelines and upcoming future releases.
• Participate in weekly joint QA calls to discuss current QA challenges, defects and improvement to existing processes.

Environment: WebLogic, Oracle, HP ALM 11.52, HP UFT 12.01, JIRA, Sharepoint, XML, Excel

Principal Test Lead/

Business Analyst

Worked as Principal Test Lead for Test Data Management TDM project under Information Lifecycle Management ILM division of Informatica, Hyderabad. ILM Test Data Management, includes Informatica Data Subset and Informatica Data Masking, integrates with Power Center to provide extensive connectivity and to leverage Power Center features. As a Business Analyst, worked on analyzing requirements and finalizing stories for iterations as part of Agile project. ILM Test Data Management provides one ILM solution for a vast array of databases, packaged applications and custom applications. Data Subset feature helps clients to create lean nonproduction systems, such as development, test, or training systems, as small, targeted, and referentially intact copies of production data. Data Masking feature helps client to mask sensitive and confidential data to nonproduction systems. As part of Data Subset and Data Masking implementation, TDM helps to profile data on the source databases to identify sensitive information for subsequent operations. To implement Data Subset and Data Masking operations, DMO Data Masking Object is a custom transformation that provides the masking/privacy function in Power Center.

Responsibilities:

• Work with Informatica Developer IDE team to gather functional specifications for leveraging the profiling features for TDM.
• Review IDE test artifacts to help augment System Test strategy for TDM.
• Acquire complete functionality of IDE to assist project team to understand Informatica profiling features for the release.
• Work as profiling SME/Business Analyst for TDM project team and guide project team in implementation of the features.
• Gather functional requirements and enhancements for TDM 9.5 release and evolve test strategy.
• Work with Product Manager and Senior Management fine tune the requirements and help in scoping for current and future releases.
• Assist in creation of user stories to streamline the requirements and associate stories to iterations as part of project plan driven by Agile Methodology.
• Identify estimates for QA planning and execution based on the stories to Project Management
• Work with Product Manager on a weekly basis to clarify outstanding issues from iteration stories and assist development in understanding requirements.
• Involve Dev and QA teams intermittently in knowledge sharing sessions to help understand Informatica Profiling features and guide them to be knowledge bearers.
• Create a detailed test strategy for data profiling with Primary Key, Foreign Key and Data Domain Discovery.
• Installation and Administration of Power Center and TDM in different Platforms/Environments
• Installation and up gradation of TDM on different platforms in sync with Power Center.
• Preparation of Test Plans and test cases as per the business use cases/stories.
• Work with Product Manager to finalize the PAM Product Availability Matrix and MAT Minimum Acceptance Test documents and publish across project team.
• Maintain a weekly risk register centrally to track any loss of man hours due to unforeseen circumstances sick leave, etc and keep the management appraised of the impact.
• Develop automation scripts using Selenium
• Create input data files in XML to validate various scenarios.
• Execute Selenium automation suite for smoke tests
• Validation of Data Discovery for relationships PK, FK and discover data domains in TDM
• Creating tables across databases oracle, db2, sql server with relationships as part of test data preparation.
• System Test involved discovering data domains and relationships foreign keys across databases
• Create data and test data domains for PCI Payment Card Industry , PHI Personal Health Information and PII Personally Identifiable Information which would be certified as part of the release.
• Validation of Data Subset by creating Entities, Groups and Templates
• Validation of data movement across different target systems for both data masking as well as data subset
• Responsible for Certification and shipping of EBFs Emergency Bug Fixes to the customer

Environment: Java SDK, Power Center, Informatica Data Explorer IDE , Informatica Developer Tool,Test Data Management, Informatica Analyst Tool, Perforce, Linux, Solaris, HP UX, Windows, Oracle, SQL Server, DB2, Sybase, TeraData, Flat files .dic,.txt,.dat

Worked as an Automation Lead for WIAT Web Integrated Audit Trail application. Application allows Market Regulation users to review and analyze market data utilizing various filters to interleave multiple transaction types within a single tabular view. Responsible for a team of testers involved in both manual and automation testing of the application. Tasks include assigning tasks, schedule project deadlines, create test plan and maintaining a regression suite in Quality Center comprising both manual and automated test cases.

Responsibilities:

• Maintain automation suite in Quality Center built in Quick Test Pro
• Maintain regression suite consisting of manual and automation test cases
• Create automation framework for the application.
• Create a QTP framework in descriptive programming to cater to the application upgrade from ADF to GXT.
• Create Test Plan to detail the scope and identify level of testing that needs to be performed for each release and review with Project Management
• Create test strategy for migrating legacy transactions to WIAT
• Identify test scenarios for each enhancement and evolve a test strategy for the release
• Involve in design review meetings to identify the scope of testing for the release.
• Conduct data validation between legacy NYSE and WIAT applications as part of migration effort.
• Maintain test artifacts in Quality Center
• Maintain and enhance smoke test module in Quality Center to test every build of the application during the testing cycle.
• Create traceability matrix for requirements and the designed test cases
• Ensure System Test entrance and exit criteria requirements are adhered to
• Assist testers in creation of new QTP scripts for new functionality in each release and add to regression suite as applicable.
• Conduct defect review meetings and coordinate issues to the Project Management
• Supervise System Testing and Regression Testing for each release
• Maintain Defect Life Cycle in StarTeam
• Work with Dev Team after defects are identified to explain the test scenario and assist in reproducing the problem.
• Conduct functional test of the application each release and upon completion conduct rigorous regression testing of the application to make sure existing functionality is intact.
• Schedule UAT deployment and assist users during Acceptance Testing
• Assist Dev Team during deployment to Production by conducting smoke test of the application
• Provide a detailed Test Execution Report to Project Management at the end of each release

Environment: WebLogic 10, Oracle 10, Netezza, Greenplum 3.3, WinRunner 9.2, QuickTest Pro 10.0, Quality Center 10.0, StarTeam, Frameworks: Struts, YUI js framework , GXT GWT extension

Automation Lead

and external to Fannie Mae to access auctions. Auctions are issued for both Long Term debt and Short Term debt comprising of various program types Benchmark Bills, Discount Notes, Benchmark Notes, Benchmark Bonds, Callable Benchmark Notes, Subordinate Benchmark Notes, Callables, Notes and Bonds. Application catered to Fannie Mae Administrators, Dealers, Executives and Back Office users.

Responsibilities:

• Work in an Agile environment requiring daily standups with status updates.
• As part of Agile methodology participate in design of user stories for each iteration.
• Participate in Iteration Testing based on the stories.
• Help identify the points to be assigned for stories at QA level.
• Work with Business Analysts and Users to understand the requirements and prioritize the test cases.
• Supervise integration testing with downstream applications Security Processor, Benchmark Automated Software Systems and others
• Create various workflow test cases for the life cycle of an auction Create, Announce, Submit Bids, Close and Announce Results.
• Maintain a suite of 200 QTP automation scripts that were outdated and structure the baseline
• Update the data files for automation suite to meet current requirements.
• Assist in creation of scripts that validate new requirements in current iterations/stories.
• Involve in exhaustive system testing
• Execute as a batch the automation suite during System Testing.
• Review and report test results from Quality Center with daily statuses.
• Create test summary reports from QC to provide system test progress.
• Create database scripts to validate auction data at various stages
• Report software defects to development team and work with the team to address any issues

Environment: WebLogic 10, Oracle 10, QuickTest Pro 10.0, Quality Center 10.0

Market Regulation

Regulatory Authority, is the largest independent regulator for all securities firms doing business in the United States.

Worked as an Automation Lead for WIAT Web Integrated Audit Trail application. Application allows Market Regulation users to review and analyze market data utilizing various filters to interleave multiple transaction types within a single tabular view. Tasks include maintaining a regression suite in Quality Center comprising both manual and automated test cases. Create a test strategy for new releases as well as involve in testing interim releases.

Responsibilities:

• Build framework in WinRunner and maintain scripts two years
• Build an alternate framework in QuickTest Pro - QTP upon decommissioning of WinRunner
• Migrate all automated scripts to QTP
• Create a QTP framework in descriptive programming to cater to the application upgrade from ADF to GXT.
• Create automation framework for the application.
• Develop LR framework for performance test Java Server Faces, GWT, ADF
• Identify bottlenecks and work with DBAs and developers to fix issues.
• Use performasure, sitescope and foglight to help identify bottlenecks.
• Perform extensive manual testing of new transactions that are based off metadata files excel .
• Assist in creation and maintenance of manual and automated test cases in Quality Center.
• Create automated test cases to validate front-end of Web application.
• Create different test modules for comprehensive regression Security, Metadata etc
• Plan and execute thorough regression for application every release.
• Involve in testing transaction reports built in COGNOS
• Build test cases for each transaction type around 100 that would test every aspect of the transaction.
• Help testers in building test case files in Excel that would be input files for automation.
• Maintain change requests in StarTeam and involve in entire defect life cycle.
• Perform data analysis, validate drillthroughs to Greenplum, Oracle and Netezza data.
• Help users in performing UAT of the application provide test data and others.
• Assist Dev team in improving quality of unit test cases.
• Create test execution reports in Quality Center and provide Management with test metrics.

Environment: WebLogic 10, Oracle 10, Netezza, Greenplum 3.3, WinRunner 9.2, QuickTest Pro 10.0, Quality Center 10.0, StarTeam, COGNOS, Frameworks: Struts, YUI js framework , GXT GWT extension

Test Lead/Analyst

Worked as a Test Lead in the Fraud Operations division. Worked on a corporate wide Helix Conversion project that involved conversion of US card and Small Business accounts to new TSYS platforms.Other tasks included working on new functionality and enhancements on a variety of fraud detection and decision applications BORIS, FOCUS, FRED. Worked on Credit Management application Merlin which primarily manages customer accounts and decisions credit limits based on customer activity. Worked on semi-annual releases of BORIS/FOCUS and Middleware Odyssey to comply with changes based on Visa/MasterCard updates.

Responsibilities:

• Review requirements and create a test strategy to be implemented
• Involve in meetings with Business Team to acquire core requirements that would help in Test Planning.
• Create Test Plans to detail the scope and level of testing that needs to be performed
• Identify timelines for the different kinds of testing to be performed and estimate the risks involved.
• Part of Agile Team that worked on semi-annual releases of BORIS/FOCUS that targeted changes required based on Visa/MasterCard system updates.
• Perform Test data analysis and ensure data requirements are met prior to start of various testing phases.
• Work on enhancement of automated script in WinRunner to identify good accounts from a list of test account provided to Testing Team.
• Create Test Scripts in Test Director based on SDM standards in place
• Test Control-M schedules for the AbInitio jobs developed to decision customer accounts as part of Credit Management System.
• Create MS Excel template to simulate the calculations needed to determine fraud amounts on Customer accounts based on fraud detection guidelines.
• Involve in System Testing of applications as per the requirements
• Involve in Integration Testing and co-ordinate with different teams to ensure the system is stable in varying conditions
• Involve in End-to-End Test cycles to simulate a real-time scenario and ensure a smooth cycle is completed.
• Perform back-end testing for Credit Management System using TOAD.
• Test various fraud detection defenses developed in Shell scripts that are run on customer dollar and non-dollar transactions to ensure fraud data is identified on customer transactions.
• Identify and execute Regression tests for semi-annual releases of applications related to Visa/MasterCard updates.
• Work as part of Core Helix Testing team and perform extensive tests on TS2 green screens to ensure smooth transition of current accounts to TSYS platform and test the various functionalities.
• Test updates to Offer Management Database based on Teradata as part of Helix Integration Testing.
• Execute tests in Test Director and create detailed Execution reports with the applicable test metrics
• Work with End Users and provide support for UAT.
• Execute test scripts and report defects based on severity in ClearQuest.
• Involve in entire life cycle of defect from submission to close and update accordingly in ClearQuest.
• Involve in reporting Daily Test status with the test metrics to update the Project Management of progress
• Report to Test Manager on a weekly basis with status on different projects

Environment: C , PowerBuilder, Java, UNIX Shell Scripts, Oracle, Teradata, AbInitio, TSYS, WinRunner, TestDirector, ClearQuest, MS Office Suite

Sr. QA Analyst

The Tax Accounting for Debt Automation is designed to automate the current Tax Accounting process by leveraging technology to manage dynamic reporting requirements in the Corporate Tax Division. The Debt project will also minimize the manual preparation of both long-term and short-term debt, which requires using spreadsheets, manual data re-conciliations and validations for the preparation of corporate taxes, thereby changing the current Freddie Mac Tax Debt accounting paradigm from a fragmented EUC/manual process into an automated system.

• Support the drafting of the Business Requirements Document
• Review the Test Plan and identify the scope of Testing
• Evolve an automated test strategy for the calculation engine
• Involve in meetings with Business Users and identify the scenarios for testing
• Meet the Business Users to understand the manual process of implementing Business calculations in Excel spreadsheets
• Simulate the Java Calculation Engine on Excel Spreadsheets to create expected results for manual testing.
• Conduct walkthroughs with Business Users to explain the test strategy and explain the scope of the testing effort.
• Involve and coordinate the design of the calculation engine and web front end to the Development Team based on feedback from the Business Users on critical issues.
• Support the Development Team and Architect in the design of system architecture
• Create the amortization schedules for different types of instruments in Excel spreadsheets
• Implement the logic behind the amortization methods in test scripts using Rational Robot.
• Create User Defined Functions to simulate the different processes through the Calculation Engine.
• Identify the test scenarios for Business Use Cases
• Implement test scripts in Rational Robot for Business Use Cases.
• Involve in creating Test Scripts for Calculation Engine, Front End and Validation Engine
• Create test scripts to validate Micro Strategy reports
• Identify the priorities of the system test scripts and create the Requirements Traceability Matrix
• Implement DB2 Client and Rapid SQL to execute queries in CDW environment.
• Document test scripts for ETL testing.
• Involve in meetings with Development Team to make understand the business logic behind the calculations and help the Development Team to implement the calculations in Java
• Implement Rational ClearCase to manage Test Artifacts
• Implement Rational Test Manager for handling Manual Test Cases
• Implement Rational ClearQuest for Defect tracking purposes.

Confidential aimed at revamping the existing system of producing all the necessary reports for tax filing purposes on a timely basis. The objective of the project is to assess the current status of the system, correct the reports that are incorrect, and provide reports that are required but absent presently. The goal of the assessment is to streamline and/or automate the process of creating the results that are used for Derivatives Tax Filings, while leveraging the maximum number of building blocks from the existing software baseline.

• Support the drafting of requirements common to Debt and Derivatives initiatives
• Review the Test Plan and identify the scope of Testing
• Evolve an automated test strategy for the calculation engine
• Assist in the design of the new set of QA Processes and Procedures, which encompass all client platforms and applications
• Responsible for developing and conducting tests and analysis to ensure software, systems, and services meet company standards as defined by the 'end-user' via the functional and non-functional system requirements
• Develop Test Scripts for Calculation Engine, Front End, Micro Strategy Reports and Versioning
• Execute tests according to established plans and scripts.
• Perform end-to-end testing of the entire system Base Tables, Calculation Engine, Result Tables, Web Front End and Micro Strategy Reports
• Implement Rational Test Manager for test scripts and manual testing purposes.
• Implement Rational ClearQuest for Defect tracking purposes
• Work on different builds of the application and update the System Test Results document for each build to measure the pass to fail ratio.
• Perform retests of software corrections to ensure proper resolution.
• Regularly identify test data input and expected results with both valid and invalid records to thoroughly test program logic
• Verify system flows and create and execute SQL scripts in order to validate test results.
• Document the test scripts identified by the Business Users for User Acceptance Testing purposes to conform to company standards.
• Assist Business Users to execute UAT tests.

Environment: Rational Test Manager, Rational Robot, Rational ClearQuest, Rational ClearCase, Java, Apache-Tomcat, DB2 UDB, Data Stage, Sybase, Rapid SQL, and DB2 Client

QA Tester

Confidential is a global market leading transportation and logistics engagement Company with 223 offices in 171 cities and 33 countries. Business areas include international air and ocean freight forwarding, import customs brokerage, distribution warehousing and other logistics related activities. As an international logistics system provider, KGIT provides information systems to be used as enablers for improved predictability, and enhanced productivity for Kintetsu World Express KWE and its global trading partners. The application UFS provides all KWE operating companies a unified, integrated system for performing freight operations in Air, Ocean, Rail and Truck.

• Follow RUP Quality Assurance and testing processes. Interact with program management and executive teams regarding quality assurance goals.
• Set up definitions and process for test phases including product test, integration test, and system test. Work to fully implement test phase entry and exit quality criteria, standard test reporting metrics and standard test artifacts.
• Development of standard documentation package Requirements, Specification, Design, Operations, and Quality Testing Plans .
• Develop and maintain proper QA processes in the facility including scope of white and black box test procedures, test plans, and automation test tools.
• Define and continue to evolve QA strategy, performance benchmarks, reliability tests and automation technologies resulting in scalable, reliable quality product releases.
• Develop Quality Assurance Plans in Rational Test Manager and life cycle test documents and conducted Quality Reviews on project artifacts. Also, evaluate product quality and compliance to the Quality Assurance Plan and Catalyst practices.
• Analyze Business requirements and System specifications. Draft test strategies, test plans cases and test scripts for the installation, GUI, functional, Security, recovery, performance and integration testing for multiple software releases using Requisite Pro.
• Create and enhance existing test scripts for the application using Rational Robot.
• Prepare Automated generic Test Scripts and Functions in Rational Robot for functional/GUI and regression Testing
• Meet with client groups to determine user requirements and goals. Utilized Rational Unified Process RUP to configure and develop QA process, standards, and procedures.
• Frequently update the requirement and defect status as per the current status of the testing project in the ClearQuest.
• Support the testing team with interpretation of PowerBuilder code, when required

Environment: PowerBuilder, Forte GL, Oracle, Windows NT/98/2000, Rational Robot, Rational TestManager, Rational ClearQuest.

Graduate Assistant

helping Undergraduate students on the network labs. Worked at Sylvan Testing Center that would register students for various tests TOEFL,GRE,GMAT. Conduct and monitor computer based tests for the registered students. Assist students in computer labs with various issues on Windows, MS applications, IE and others.