SUMMARY

• Confidential has about 16 years of rich experience in manual testing, automated testing, support and development on proprietary system.
• She has prior experience in managing a team of strength 10 - 12, spread across onshore & offshore locations.
• Her key focus areas have been Test Planning, Estimation, developing Test Scripts, Test Execution, and Defect prevention and ensuring quality deliverables.
• Have gained working knowledge in Data Warehouse Testing.

TECHNICAL SKILLS

• Quality Center
• Teradata
• LoadRunner
• Informatica
• Abinitio
• WebSphere Portal Server
• JBOSS
• JIRABugzilla
• Cruisecontrol
• CVS
• Java
• JSP
• WebSphere App server
• Rational application developer 6.0
• HTML
• CSS
• JavaScript
• VC++/C++
• Perl
• DB2
• Linux
• UNIX
• AIX
• Sun Solaris
• XML

PROFESSIONAL EXPERIENCE

Confidential

QA Test lead / Coordinator

Responsibilities:

• Requirement gathering, analysis from FSD for functional/regression testing/smoke/sanity testing
• Translate these requirements to different testing scenarios /objectives
• Creation of input flat files/xml files/json files with mocked up data to be consumed by Big Data infrastructure using Abinitio as the ETL tool
• Creation of SIT Test Plan doc for Data Warehousing Application
• Creation of Execution Plan doc (the dates to highlight day to day activities in different SIT cycles for an Integrated Release/Independent)
• Design of Test Data requirements and forms to get sign off from the project teams preparing test evidences
• Running autosys jobs for ingestion to consume trade data, consumer lending data and transform them per the business rules to conform based on APP rules
• Creating the test scripts in SQL queries to validate the databases tables and tableau and microstrategy reports data for backend database and UI Testing based on technical specifications/Data design documents and Source to Target mappings
• Worked with Agile (Scrum) and Waterfall software development methodologies
• Defects management experience using JIRA, RALLY
• Involved in different types of testing like Functional, regression, integrated and performance testing
• Test environment management
• Planning and delegating daily tasks to offshore and reviewing them on a daily basis
• Tracking the status on a daily basis including defects in ALM QC
• Worked with the Automation Team (using Java Selenium) to automate DB to DB validation comparing and verifying data between the raw zone and the sanitized zones

Confidential

QA Test lead / Coordinator

Responsibilities:

• Requirement gathering, analysis from HLD/LLD/BRD for functional/regression testing/smoke/sanity testing
• Translate these requirements to different testing scenarios /objectives
• Creation of SIT Test Plan doc for Data Warehousing Application
• Creation of Execution Plan doc (the dates to highlight day to day activities in different SIT cycles for an Integrated Release/Independent)
• Design of Test Data requirements and forms to get sign off from the project teams
• Creating the test scripts in SQL queries to validate the databases tables and tableau and microstrategy reports data for backend database in Teradata and UI Testing based on technical specifications/Data design documents and Source to Target mappings
• Worked with Agile (Scrum) and Waterfall software development methodologies
• Defects management experience in JIRA, Rally
• Involved in different types of testing like Functional, regression, integrated and performance testing
• Test environment management
• Planning and delegating daily tasks to offshore and reviewing them on a daily basis
• Tracking the status on a daily basis including defects in ALM QC
• Automated few AML reports and OFAC reports using Java Selenium Framework

Confidential, Charlotte, NC

Dynamic Application Security Testing Coordinator

Responsibilities:

• Getting the security test objectives from the security architects for different apps based on the release calendar
• Analyzing the security test objectives and identifying test scenarios, test cases, test data and credentials necessary to satisfy those scenarios in coordination with the QA lead for each app
• Develop test strategy with input from QA leads, development teams and business team regarding end to end test coverage, test scenarios, interfaces and defect tracking process
• Document also the test environment, communication, escalation plan/procedures, testing dependencies & risks with requirements, scope, and application availability as well as understanding dependencies between testing teams
• Scheduling a demo with the Dev team and the QA team to understand the new requirements
• Performing a test plan walkthrough with the EIS/VAT tester
• Reviewing the Vulnerability Report created by the VAT tester as an artifact and entering all the findings into the Defect Tracking System
• Managing status reporting/communication of the defects to internal managers/ project stakeholders by coordinating with the Development team when the issue will be fixed (build/release) and how and document the steps if the issue cannot be fixed within the bug bar remediation guidelines after getting approvals from the Security Architecture team and the EIS team

Tools: Used: HP Quality Center 9.2, Clear Quest, SharePoint

Confidential, Charlotte, NC

Senior Analyst, Quality Advisor

Responsibilities:

• Analyzing the requirements and technical documents for functional/regression testing/smoke testing
• Participate in testing kickoff meetings and meet with all project stakeholders
• Translate the new requirements to different testing scenarios /objectives
• Extensive SQL querying on Staging, Non staging, Datawarehouse and DataMarts
• Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability
• Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.
• Review testing results summary certification and driving the approvals process
• Provide status reporting/communication to project stakeholders on a daily basis including defects
• Creation of Test Data requirements
• Status reporting to client and internal managers with delivery artifacts
• Operated in 2 week sprints writing User Stories based on the requirements gathered from all the stake holders during Sprint Planning.
• Provided daily communications and reported progress to all stakeholders
• Organized and facilitated Agile Scrum meetings during Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective.
• Created data validation, count validation and duplicate validation automation scripts using UNIX Shell Scripting
• Involved in automating micro strategy front-end reports using Qualitia which is basically a script less test automation tool that is language and platform agnostic, and leverages the power of both Selenium and QTP.
• During issue debugging collaborated with the Dev team in reviewing AB Initio ETL graphs

Tools: Used: ALM HP Quality Center 9.2, Netezza, JIRA, Oracle, UNIX, LINUX, SQL Server 2008, SQL Scripting, Agile, Qualitia (Selenium), Abinitio

Confidential

QA Test lead / Coordinator

Responsibilities:

• Requirement gathering, analysis from HLD/LLD/BRD for functional/regression testing/smoke testing
• Translate these requirements to different testing scenarios /objectives
• Creation of SIT Test Plan doc for Data Warehousing Application
• Creation of Execution Plan doc (the dates to highlight day to day activities in different SIT cycles for an Integrated Release schedule/Independent)
• Design of Test Data requirements and forms to get sign off from the project teams
• Creating the test scripts in SQL queries to validate the databases tables and reports data for backend database testing based on technical specifications/Data design documents and Source to Target mappings
• Planning and delegating the tasks to offshore
• Tracking the status on a daily basis including defects
• Making sure all the technical issues are clarified and resolved for the team
• Reviewing the team deliverables
• Status reporting to client and internal managers with delivery artifacts
• Validated the Data on Mainframes using batch testing
• Worked with Upstream application Team to process the files and validate data in interactive Mainframe Environment
• Started Autosys jobs and checked whether they ran to success or if any failures checked the logs to further debug.

Tools: Used: HP Quality Center 9.2, Teradata, SSH Tectia Terminal (LINUX), SQL Scripting, Informatica

Confidential

QA Test Lead / Coordinator

Responsibilities:

• Involved in manual testing and automation of projects using proprietary tools Quality Center, Loadrunner.
• Preparation of Wholesale End to End Test Plan and Test Strategy
• Coordinate/Participate in status and review meetings with the team and the client
• Participated in ETL/ Data warehouse backend testing and BI Intelligence reports testing
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads
• Review of SQL Queries prepared by the team in Teradata based on business requirements, mapping documents, HLDs and LLDs
• Performing SIT Execution in Teradata, reviewing the results and then identifying and investigating issues.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Extracted data from various sources like Oracle, flat files and DB2 server.
• Worked on issues with migration of Data from development to QA-Test Environment
• Analyzing the issues, logging defects in Quality Center
• Documentation of Lessons Learned for future releases.

Tools: Quality Center, Teradata, SSH Tectia Terminal, Informatica (ETL Tool)

Confidential

Performance Analyst/IT Analyst

Responsibilities:

• Performance analysis and applied customized performance testing strategy that includes load, stress and scalability testing for a complex web-based Confidential application Lotus Quickr with Websphere as the application server, DB2 as the backend database and Tivoli Directory Server as the LDAP server for authentication and authorization (single sign-on, JAAS).
• Also used Apache/Tomcat as a hosting environment for several J2EE applications. Defined, developed and executed Performance Test engineering tasks, which include developing and implementation of Performance engineering methodology, Performance test process, Test requirements and analysis, monitoring/analyzing Test results, collecting Test metrics and conducting Test reporting.
• Developed scenarios for performance testing.
• In order to achieve acceptable response time (for our case each transaction should be below 2 seconds), tried to pinpoint different bottlenecks at different levels like the application level, database level, OS level or the network level by constantly increasing the load on the system
• After each run, perform detailed analysis like finding the behavior of Garbage Collection (GC), measured different Db2 metrics like total Select SQL Statements Executed, maximum number of concurrent connections, time waited on locks, etc. to make sure the application is not in a resource deadlock
• When the results of the load test indicate that performance of the system does not meet its expected goals, tried different performance tuning
• Have also used various internal Confidential tools like Heap Analyzer, Confidential Pattern Modeling and Analysis Tool for Java Garbage Collector, Thread Analyzer and DB2 Analysis Tool
• Opened defects through CMVC which is a defect tracking tool if there are any issues with product code. Also interacted with developers to find the faulty Java methods (after a particular function or method has been profiled and tuned) and then coming to a resolution with either a latest patch/modified Java to meet performance requirements of load classes
• Generated graphs from LoadRunner analysis for throughput, response time of different transactions, CPU Utilization of different servers used for measurement (such as the portal server, DB2 server, LDAP server) and JVM heap utilization against load required for the annual performance report.

Tools: LoadRunner, Java/J2EE, DB2, JDBC, WebSphere Portal Server, Performance monitoring infrastructure, DB2, CMVC, CVS, Windows, UNIX, AIX.

Confidential

Ant Developer/ Software Developer

Responsibilities:

• Wrote configuration scripts for a particular SAS application called Strategic Performance Management (SPM release 9.2) testing with application servers like JBoss, WebSphere or WebLogic. Also helped in converting the current build system to iFABS which is an ant-based build system which uses Ivy as the dependency Manager.
• Converted build scripts from Cruise control to support the new Java build model with cross-platform support for various SAS applications and to reduce differences between desktop and production builds.
• Made sure the java code compiles clean without warnings and errors and then properly published with proper naming conventions for instant/development builds also used Buildbot.
• Wrote extension scripts for SPM which involved tasks like creating a data source, copying static content from the installed location to a common location/staging area, copying portlets and par files
• Installed and managed a successful Bug Tracking System Bugzilla
• Used agile development methodology for developing various SAS components. Modified WebServices (service and client) for various modules.

Tools: Ant, Java/J2EE, Web Services, JMS, EJB, XML, WebSphere Application Server, DB2, JDBC, JBoss, CVS, UNIX, Windows.

Confidential

Programmer Analyst

Responsibilities:

• Support applications/application servers in high availability e-commerce environments.
• Monitors performance of production servers and responds to issues that arise related to application servers.
• Troubleshoots complicated application environment issues
• Used agile development methodology for designing and developing various functionalities.
• Supports developers and QA by maintaining test environments and configuring application servers to development specifications.
• Resolve code fixes/defects/issues reported via defect tracking tool like Jira/Remedy and based on test cases/requirements/test plan defined in Testdirector
• Deployed J2EE applications in JBoss Application server for testing and then promote to production servers.
• Performed UAT of J2EE applications based on their functionality and usability.

Tools: Java/J2EE, Jira, Remedy, WebSphere Application Server, JBoss, Oracle, CVS, CruiseControl, Windows, Linux, AIX.

Confidential

WebSphere Portal Level 2 Support

Responsibilities:

• Support of the Confidential WebSphere Portal product version 5.0 through 6.0.1.1, focusing on issues pertaining to Portal Installation/configuration as well as cluster install/config, fixpack and portlet install, security tasks, server start/stop issues, and help customers understand the software/hardware requirements and planning for their businesses through a distributed business application Call Center.
• Interacted with Confidential external/internal customers and helped them in planning their business needs and architecture.
• Provided step by step instructions to install/configure WebSphere Portal product on different platforms like Windows, Linux, HP-UX, AIX, and Sun Solaris.
• Troubleshoot various customer issues like cluster creation, software upgrade, portlet deploy.
• Assisted in integrating portal with backend database like DB2, Oracle, SQL server and LDAP servers like Tivoli Directory Server, Lotus Domino, Sun One.
• Opened defects in a defect tracking tool CMVC for code functionality or documentation changes.

Tools: Java/J2EE, WebSphere Portal Server, WebSphere Content management (WCM), WebSphere Application Server, DB2, Oracle, SQL Server, CMVC, Linux, Windows, AIX.