SUMMARY:

• Over 8 years of experience in Testing and Development on Web based, Client/Server and Data warehousing applications.
• Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Professional experience in Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing.
• Proficient in different types of testing such as ETL Testing, Web Service testing, Selenium and UI Testing.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Tested the ETL Datastage mappings and other ETL Processes (Data Warehouse Testing)
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2).
• Extensive working experience in various platforms like Mobile Web and Mobile App.
• Experience in Automation using JUnit and Selenium.
• Expertise in specific Agile web platforms like Salesforce and Rally.
• Proactively worked in various Development technologies like COBOL, JCL, JUnit, AS400, XML, HTML5, Databases DB2 and VSAM
• Experience in Web based applications like online banking, transactions applications.
• Experience in SQL and PL/SQL scripting
• Strong experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Experience in using HP Quality Center for Bug Tracking and Defect Reporting.
• Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
• Expertise in querying and testing RDBMS such as MS SQL Server using SQL for data integrity.
• Clear understanding of business procedures and ability to work as an individual and as a part of a team.

TECHNICAL SKILLS:

Testing Tools: ETL Testing, Datastage testing

Web Service testing: SOAP UI, Green Hat and Rational Integration Tester/RIT

Automation Testing: Selenium and JUnit testing, AS400 and Mainframes Testing

Programming Languages: COBOL, JCL, Easytrieve and VSAM

Platforms: Mobile App and Mobile Web testing.

Databases: DB2 v9.1, SQL and QMF

Tools: and Software: Salesforce, Rally, HP Quality Centre, SAR, File Manager, Change man, CA-7, DB2I, SPUFI, SYNCSORT and File-AID

Hardware/Server: IBM Mainframe and Unix, VMS

Analysis Methodologies: Agile methodology and Six Sigma.

Operating Systems: Android, iOS, MS Server 2008R2, Windows 7/ XP/ UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Mobile App/Web Testing, Web service Testing

Responsibilities:

• Performed Integration, End-to-End and system testing.
• Involved in Functional Testing & Regression Testing
• Experience in SDLC and Agile methodologies such as SCRUM.
• Working in Agile environment and involved in 2 week sprint process.
• Conduct comprehensive testing on all software products and applications for different operating systems and mobile (POS) systems.
• Working on end to end mobile app testing (Android and iOS)
• Excellent knowledge and experience working on transact SQL using DDL and DML command.
• Working on conversion of manual tests into automated test scripts
• Creating and Enhancing Selenium scripts for UI Automation.
• Using Salesforce for storing, maintaining the test repository, bug tracking and reporting
• Involved in testing of healthcare application.
• Performed Functional, Smoke, Integration, System, Back-end and User Acceptance Testing using AS400.
• Involving in writing complex SQL queries to verify data from Source to Target.
• Performed data validation testing writing SQL queries.
• Worked with Business Analysts to define testing requirements to satisfy the business objectives.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
• Work closely with developers and business resources during functional and regression testing to ensure that testing activities meet business requirements
• Work together with developers to resolve all identified defects, risks, and issues identified during testing of all assigned cases.
• Anticipate product release problems and take corrective action, escalating as needed, to resolve and achieve business goals.
• Cultivate and disseminate knowledge of Quality Assurance best practices
• Providing Product training to juniors and new hires and managing a team of eight resources.
• Review technical requirements and perform User Acceptance Testing (UAT)
• Coordinating with teams at multiple locations onshore and offshore in providing the requirements and monitoring application’s quality.
• Verify Stability, Interoperability, Portability, Security, and Scalability of system.
• Conducting trial runs of programs and testing of software applications to be sure they will produce the desired information and that the instructions are correct.
• Consolidating class and sequence diagrams and preparing high-level and low-level design documents.

Environment: HP Quality Center, DB2, SQL, TSYS Mainframe, Salesforce, AS400, Mobile App, Selenium

SQL Developer

Responsibilities:

• Involved in ETL process testing using Datastage ETL tool.
• Create automation test scripts on JUNIT for different test cases scenario on User Interface.
• Testing of the codes using Green Hat/Rational Integration Tester (RIT) and SOAP
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Datastage.
• Involved in Datastage testing, both Datastage Designer (for Compiling and running Datastage jobs) and Datastage Director (scheduling, monitoring, and running the Datastage jobs) were used.
• Working on conversion of manual tests into automated test scripts.
• Creating JUnit scripts to Automate System integrated Classes and Methods.
• Prepare and maintain repository of the findings in QC and RQM.
• Rally was also used as part to maintain requirement repositories.
• Prepare High Level Design (HLD) and Low Level Design (LLD).
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Lead a team of fifteen people.
• Test Case Execution and Adhoc testing
• Performed Integration, End-to-End, system testing
• Involving in Functional Testing & Regression Testing
• Developing Automated Test Scripts to perform Functional Testing, Performance Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing, Regression Testing and Volume testing of the application using LoadRunner
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
• Performed data validation testing writing SQL queries.
• Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results
• Experience assessing testing processes, creating and implementing testing strategies in UAT phase.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects
• Developing Test Matrix to give a better view of testing effort

Environment: Datastage Designer, Datastage Director, Green Hat, Rational Integration Tester, SOAP UI, JUnit, HP Quality Center, DB2, SQL, TSYS Mainframe, Rally

Developer

Responsibilities:

• Involved in all phases of Software Development Life Cycle form requirement
• Write COBOL/DB2 programs as part of build process.
• Write JCL, Easytrieve programs for the Mainframe integration.
• Experience with Agile and SCRUM experience and good knowledge of Content Management Systems.
• Prepare High Level Design (HLD) and Low Level Design (LLD).
• Preparing the CA7 Scheduling sheet for job scheduling.
• Code migration to different test and production environments.
• Preparing Daily dashboards and status reports to the client.
• Coordinate the project with business and onshore counter parts and other interfacing systems.
• Compiling and writing documentation of program development and subsequent revisions, inserting comments in the coded instructions.
• Update and modified Store procedure and applied as per business logic and test scenario.
• Create and schedule several SQL jobs for document release and approval.
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Performing database testing to verify backend database transactions.
• Involving in communication between UAT team members, business leaders, and IT.
• Participates in application release planning and status sessions.
• Created, maintained and updated regression suites upon receiving new build.
• Creating traceability relationship between requirements in the same module and also between different modules.
• Extensively used Quality Center for documenting, organizing and tracking requirements.

Environment: COBOL, DB2, JCL, Easytrieve, Agile, CA7, Green Hat, Rational Integration Tester, SOAP UI, JUnit, HP Quality Center, DB2, SQL, TSYS Mainframe, Rally