SUMMARY:

• Around ten years of experience in software testing and validation in agile environments. Around two years of experience in PEGA application development/testing.
• Made extensive use of Connectors and Services in PRPC to integrate with the external systems.
• Well versed with Flow Actions, Agents, SLA, Correspondence, PRPC Security, Reports, Listeners (File).
• Experience in troubleshooting & performance tuning of PRPC applications utilizing Clipboard, Tracer and Performance Analyzer (PAL) for performance analysis and Preflight to check application Guardrails Compliance, Live UI, Log Analysis/Log Analyzer.
• Experience in writing, debugging, creating flowcharts, coding, and documenting programs with Business Rule Engine.
• A thorough understanding of the software development and testing life cycle.
• Skilled in writing test cases for black box, manual and automated testing.
• Hands on experience in database (SQL) testing. Experience using Informatica Power Center. Hands on experience with different RDBMS (Oracle, SQL Server and Teradata)
• Hands on experience building automation test scripts from scratch using Selenium Web Driver, TestNG and QTP. Experience building both data - driven and keyword driven automation tests.
• Experience testing Star and Snow flake schema, and dimensional data models.
• Hands on experience testing UNIX shell scripts developed for ETL processes that schedule workflows on Autosys.
• Hands on experience working with different data sources like flat files, XML and other relational database systems.
• Experience includes reviewing application designs, business/functional requirement documents, developing and executing tests and test scripts, documenting software bugs, regression testing and automated test scripts.
• Ability to work independently and as part of a team. Detail oriented and multi-tasking.
• Outstanding interpersonal, communication, organizational, and problem solving skills.

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Lead QA Analyst

Responsibilities:

• Collaborate with offshore teams in verifying and validating the ETL scripts.
• Work with on-shore team lead and validate data in different environments.
• Develop test plan and test cases based on user stories. Worked closely with the product owners and created user stories/epics for the automation teams.
• Responsible for testing and reviewing ETL mapping and transformation specifications based on business requirements from various teams.
• Lead the testing effort for several applications in PEGA. Used multiple mainframe applications to verify and manipulate data.
• Provided business logic inputs that were used to create different functions in the applications.
• Tested transaction postings in the backend mainframe systems (RMS, FDES, BOSS and TSYS).
• Lead the automation efforts by guiding the automation team by providing insights into the business logic.
• Participate in Scrum rituals.

Environment: Pega 7.4, Informatica 9.6, Windows 10, Netezza, Oracle 11g, SQL Server 2008/2012, Selenium, Autosys, IBM Mainframes (TSYS, RMS, FDES, BOSS).

Contractor

Confidential, Westlake, TX

Responsibilities:

• Work closely with development team and business analyst in an agile environment to participate in release planning and story grooming sessions.
• Develop test plan and test cases based on the user story picked by the developer assigned.
• Execute batch jobs to trigger batch e-mails and verify the e-mails.
• Perform functional, and regression testing on the builds deployed in the QA and UAT environments.
• Developed automation test scripts using TestNG and Selenium Web Driver. Performed data driven testing by loading the test data from external files.
• Validated the UI components using Selenium Web Driver. Used XPath to locate the HTML elements on the web page.
• Added assertions to the test scripts to ensure, all the required elements were indeed present. For optional elements added verify as part of the tests.
• Used Junit annotations like @Before, @Test, @Setup etc.
• The REST based web services were validated using SOAP UI, and results reported back to the DEV team.
• Verified data in the database by executing SQL queries against the views created in the database.
• Participate in the daily SCRUM stand-up meetings.
• Verified the stored procedures built by the development team, and ensure the results are returned correctly.

Environment: Java 7, TFS, Jenkins, Windows 7, Oracle 11g, SOAP UI, Selenium IDE, TestNG, Spring Tool Suite.

Contractor

Confidential, Dallas, TX

Responsibilities:

• Work closely with development team in analyzing and validating the system requirements and features.
• Reviewed test cases, logs, test results and test summary reports.
• Participate in daily stand up meetings
• Collaborate with team lead and execute batch jobs to generate system tasks that push notifications to NRA agents.
• Developed automation test scripts using Selenium Web Driver and TestNG for parts of the application to simplify the regression tests pre-release.
• Validate functionality in QA, Pre-Prod and Production environments.
• Verify migration of existing NRA application from Salesforce to HT database.
• Execute SQL queries against the migrated data from Salesforce.
• Worked closely with the team lead, and QA manager to ensure the project was on schedule and all the reported defects were resolved in a timely manner.
• Developed test cases based on mapping/design document.
• Wrote complex SQL queries to validate data on dashboards and reports based on mapping/transformation rules.
• Validated slowly changing dimensions (SCD) type-1, type-2 in QA and UAT environments.
• Extensively tested various types of transformations such as Expression, Joiner, Update strategy, Look up, Router, Filter for mappings.
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams.
• Tested various reusable ETL Transformations which facilitate Daily, Weekly & Monthly loading of data.
• Tested the performance bottle necks at sources, targets, mappings, and sessions and employed required measures.
• Interacted with Developers and management to identify and resolve technical issues.
• Created reusable transformations and Mapplets to use in multiple mappings.
• Tested mappings in Informatica Data Quality (IDQ) for the business and technology users.
• Worked closely with business analysts and developers in setting up test data.
• Tested several dashboards and deployed them across the organization to monitor the performance of the application.

Environment: Java 7, Spira Test, JIRA, Informatica 8.x, Oracle 11g, Windows 7.0, Spring Tool Suite.

Confidential, Irving, Texas

Sr. Quality Assurance Analyst - Contract

Responsibilities:

• Created test cases based on use cases delivered by User Interface developers
• Worked closely with the Business Analysts to ensure the test cases covered all the major areas of functionality. Validated the workflows for different payment types (Credit, Debit, Check etc.).
• Performed regression testing to ensure the weekly builds did not break any old functionality.
• Performed User Acceptance Testing and System Testing on both UAT and DEV environments.
• Primarily used Informatica Power Center to maintain and enhance corporate Oracle Data Warehouse.
• Tested ETL requirements and code modules according to specifications and client standards. Performed data integrity, boundary-value, null-value, and duplicate value testing on the transformed and migrated data.
• Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
• Worked with ETL group for understating mappings for dimensions and facts.

  Testing of migrated data at every stage of ETL process by verification through SQL query against the business rules.

• Wrote Test Cases for ETL to compare Source and Target database systems.
• Used SQL Query to test the Database updates and Modifications.
• Preparation and Review of End to End Test Scenarios/Test Cases, Coverage matrix and Test Data.
• Worked with Informatica Repository Manager, Designer, and Workflow Manager.
• Executed the automated test scripts developed in Selenium for the previous version of the application as part of regression testing.
• Verified the mobile application on iPhone, Android and Windows Smart Phone. Captured the crash logs and provided the information to developers, to debug the issue.
• Performed functional, performance and memory testing for the mobile devices.

Environment: Java, Windows 2008R2, Windows 7, Quality Center, Oracle 11g, Informatica 9.5, DB Visualizer, iOS 7.x, Android 4.x, HTML, CSS, Java Script.

Confidential, Richardson, Texas

Quality Assurance Analyst - Contract

Responsibilities:

• Reviewed functional requirements document and created test cases based on test scenarios drawn from functional requirements.
• Participated in design sessions to analyze business needs and assist in the development of test procedures and test plans.
• Developed test cases from the business requirements document.
• Performed Integration, Regression, User Acceptance testing and Database testing
• Used SQL queries to extract data from the target tables to prove the data mapping.
• Executed SQL queries against the sample data to verify the integrity of the data.
• Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools. Developed test cases to accomplish ETL data migration.
• Involved in integration testing of Informatica mappings and entire application.
• Created sessions and workflows to run with the logic embedded in the mappings using Power Center Designer.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created reusable transformations and Mapplets to use in multiple mappings.

Environment: J2EE, Windows 2008R2, Red Hat Linux 6, Quality Center, Microsoft SQL Server 2008, Oracle 11g, TOAD, Informatica 9.1, ETL, HTML, CSS, Java Script.

Confidential, Irving, Texas

Systems Verification Analyst

Responsibilities:

• Developed test cases based on the requirements from the product requirements document.
• Performed Functionality Testing, Integration Testing, and Regression Testing
• Developed Analysis & Preparation of Functional Test Reports
• Responsible for Regression testing after bug fixes and system enhancements
• Analyzed failures found through the execution of test scripts.

Environment: Windows 2003, Windows XP, Test Director 9.0

TECHNICAL SKILLS:

Operating Systems: Linux, UNIX, Windows family, iOS, Android

Languages: Java, SQL

Databases: Microsoft SQL Server 2008/2012, Oracle 11g, DB2 10.1

Testing Tools: Quality Center 10.0, HP ALM, JIRA, TFS Selenium, TestNG, JUnit

ETL Tools: Informatica 9.x/8.x

Development Methodologies: Scrum/Agile

Browsers: Internet Explorer 9/10/11, Chrome 41, Firefox 31.5

Others: MS-Office, Open Office, DB VisualizerTOAD, Spring Tool Suite