SUMMARY:

• 8+ years career leading the appropriate testing and delivery of quality software, products, systems, and applications to meet business, market and customer needs, utilizing blended onshore / offshore delivery model.
• Experienced in testing Client/Server and web - based applications.
• Extensively knowledge of API Testing
• Very good understanding about Confidential
• Exclusive knowledge about FixIncome product including Government and Corporative Bond
• Good understanding about Confidential and Confidential Market
• Extensive knowledge to work with off shore team
• Experienced in Big Data Technologies - Hadoop ecosystem/HDFS/ Map-Reduce Framework, NoSql DB- Hbase and HIVE data warehousing tool
• Extensive knowledge about Automation Framework Tools like QTP, Selenium, Cucumber, Jenkins, Gherkin, Maven
• Extensively knowledge about UNIX shell Scripts
• Good understanding about ETL process
• Performed data load into database using SQL LOAD utility
• Write/edit the PL/SQL including procedure, function, trigger, package to test database object are working as expected
• Write/edit complex SQL for backend testing
• Extensively experiences to process batch job
• Deeply knowledge about device testing to use QTP
• Extensively worked with SQL queries for back-end testing.
• Broadly working knowledge of using AS400
• Proficient with the AS/400 operating system (OS/400)
• Excessively use cloud Server
• Well versed in circuit analysis of electrical devices, electronic process integration, and device characterization
• Extensive knowledge to test iPhone, iPad, Smart phone, Black Berry, Android
• Experienced in working on both Windows and UNIX platforms.
• Excellent testing knowledge of mobile application
• Extensive working experience to use agile methodology
• Performed Smoke, Integration, Positive, and Negative, UAT, Configuration, Compatibility, Functionality, Regression, and System tests
• Extensive use of QC and its all components for managing Requirement, Test Plan, Test Lab.
• Excellent Knowledge of Mercury Quality Center to maintain Requirements, developed test script, test execution and defect tracking
• Defect track and generate various type of reports.
• Use UNIX shell scripts To check servers, Channels, queues for various import exports activities
• Performed Front-End and Back-End Testing.
• Exclusive experience in designing, developing and implementing automated scripts.
• Developed and/or modified QTP regression scripts to new functionality.
• Experienced in working with business analysts to understand business requirements and prepare test strategy.
• Understanding of Relational Database Concepts.
• Worked closely with Development Team and other Testers to resolve technical and end-user issues.
• Analyzed defects, prepared defect report and done follow-up with design/development team.
• Extensively involved in White-Box and Black Box tests.
• Experienced in Software Verification and Validation (V&V Concept).
• Facilitated project meeting and played active role in Senior Management Review.
• Strong Communication, Presentation and Problem Solving skills as well as very good Interpersonal skills and a Team Player.
• Attending weekly Status meetings with QA team to evaluate the testing process..

TECHNICAL SKILLS:

Operating System: Window, VMWare, UNIX, Linux, MAC OS, AS 400, Sun Solaris

Languages: Java, VB Script, Shell Script, HTML, XML, PL/SQL,, Omniture

GUI: Visual Basic and Power Builder 5.0,Page Builder

Software: TCP/IP, Java, .Net, php, C++,MS Project, Excel, SQL Navigator, TOAD 8.6, SQL Editor, Tera Data, SQL Developer, Rapid SQL, Infomatica Power Center, SSIS,SSRS,DVO

DBMS: ORACLE 9i (x),10g,11g,MongoDB,HadoopDB MS SQL Server, MySql, MS Access

Automation Testing Tools: Mercury QTP, Win Runner, Load Runner and Test Director, QC, test link, JIRA, ALM

Portals: Internet Explorer, Mozilla, Safari, Netscape.

Error Tracking Systems: PVCS Tracker, Sublime, Test Director, Quality Center and Requisite pro

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Backend /ELT Tester

Responsibilities:

• Exclusively used shell scripts to load data and use UNIX command to check the logs & edit shell scripts
• Written the SQL quire base on business mapping logic
• Extensively used xlm messaging for API level testing
• Experiences Loading Data from ORACLE to Hadoop Cluster using Sqoop
• Test to make sure Hive tables data are loaded as per Hive Queries on Data Sets
• Extensively used DVO for source and target table validation/verification
• Extensively worked on backend testing of EDR mainframe applications
• Extensively used Rapid SQL for down stream and up stream application testing once data flow from difference vendor
• Performed Batch testing for EDR integration
• Work with the Business Analyst or Business user and provide resolution to the requirement queries of the offshore team, Test Planning, Review Test design, Test execution, and Test summary report
• Evaluate Ideal Compression Techniques available in Hadoop to optimally store the data
• Write the test plan/test cases and execute them which follow SDLC Process
• Extensively use Eclipse’s JUnit to write the test cases
• Tested cloud-based mobile applications across multiple platforms touching the full stack across the web.
• Extensively used Automation Framework and development from scratch using Tools like QTP, Selenium, Cucumber, Jenkins, Gherkin, Maven
• Actively involve End to End Testing with difference team
• Run the loading jobs after loaded the data validated and compare them in difference level
• Strong experience in JCL, SQL,DB2,FILE-AID,QMF, SPUFI, Cobol, MVS,VSAM,TSO,ISPF,CICS,QA Testing
• Exclusively used the XML messages for API level testing to check integrate functionality, performance and security are working as expected
• Written Black Box test scripts base on requirement without knowing program logic
• Extensively use FTP/SFTP to make sure OAST are generating the proper message/reports
• Extensively write SQL querying to validation data on Staging, Data Warehouse and Data Marts.
• Extensively used Informatica PowerCenter for ETL process testing
• Validation and comparisons data in difference level
• Performed Regression Testing for every Release Cycle
• Designed developed and implemented web services testing procedures.
• Write/edit complex SQL scripts to display data base on business requirement
• Frequently developed SQL scripts for Back-End testing
• Involving the framework development and Created test scripts using Web driver.
• Create Test cases using Element locators and Selenium WebDriver methods
• Select Manual test cases for Regression and convert them to Python scripts
• Enhanced Test cases using Java programming features and TestNG Annotations
• Extensively used Informatics PowerCenter/Recon for ETL/ Data warehouse backend and BI Intelligence reports testing.
• Frequently followed RDBMS process to used Microsoft SQL Server/Sybase (T-SQL), Oracle (PL/SQL), MS Access, and associated SQL Programming.
• Extensively applied Relational Database Concepts, Entity Relation diagrams and Normalization concepts during load process.
• Extensively used the Rapid SQL to write difference types of SQL join quires to check data integrity
• Using the Unix command & write Shell Scripts to validation the Unix feeds
• Frequently used Rapid SQL/SQL Developer to pull data from data base & check the all DB objects ( function, procedure, trigger, indexes etc ) are working as expected
• Created ETL mappings using Informatica Power Center to extract the data from multiple sources like Flat files, Sybase, Xml, csv, Delimited files transformed based on business requirements and loaded to Database.
• Extensively used Quality Center/JIRA to upload requirements, write test cases and tracking defects
• Analyzed loading data from difference Vendors
• Exclusively used difference types of data like FixedIncome product including Government, Corporation Bond
• Involved in Functional, Regression, Performance and UAT Testing
• Reported and tracked defects , monitored defects reported by team.
• Manage Projects, schedules and status.
• Attended Turnover and Product move meetings
• Working Agile team & join scream meeting to discuss about work progress
• Involved with difference teams to perform end to end testing

Environment: Quality, Center, JIRA, JAVA, HTML , DHTML, XML, EJB, JSP, Sybase Oracle11g/10g,Informatica Power Center, SQL, Rapid SQL , PL/SQL, Mercury Interactive, UNIX, Windows NT, Windows 2000, Windows, Oracle 10g/11g,DB2 and SQL Server, PL/SQL,

Confidential, Park Ridge, NJ

QA Analyst

Responsibilities:

• Analyzed functional specifications from the front-end application without any requirement documents.
• Test database object including procedure, function, trigger, package, indexes, views
• Extensively use the Unix command to execute the batch jobs & validation the feeds base on BDR
• Process the Batch jobs & validation the Unix feeds based on business requirement
• Write/Edit the shell scripts for batch process
• Written SQL Queries to perform back-end testing
• Used SQL Queries for database testing to validate the data and mapped back to business requirement
• Write the complex SQL to validation data using Teradata
• Constantly use the Cloud server to test server load distributed as expected
• Frequently use the proxy to login Cloud Server check the application behavior
• Extensively use AS400 & ESYS to validation integration reservation
• Using WebServices to create, edit & delete data base on Business requirement
• Attended to the Scrum to discuss about project goal & accomplishment
• Exclusively flow the ALM process to upload requirement, write the test cases, execute test cases & report the defects
• Extensively used Quality Center to upload requirements, write test cases and for reporting and tracking defect
• Frequently use the mobile application to verify the application sustain, validation data
• Frequently used different operating system such as MAC, Vista,Windows7, XP to verified software quality
• Extensively used VMware & XP-Mode, Linux, Unix
• Assigned task to team members, provided assistance to team members to clarify functional and technical difficulties.
• Extensively used ipad, iphone & blackberry, android to test the mobile application
• Wrote automation test plans and prepared the automation test matrix for each regression cycle .
• Developed and executed various VBScripts using QTP for automated testing of each individual functionality & Regression Testing of the applications
• Generated test scripts for functional and regression tests using QTP.
• Designed and generated Reusable Test Scripts using QTP.
• Validated data for of the Sybase version of the application with the SQL version in order to check the data integrity of the new version with the older version.
• Interacted with Subject Matter Expert (SME) to gather requirements and designed detailed test plan document for application testing.
• Created Load Test scripts with Virtual users ( VUsers ) and test Scenarios, Executed Record and play back and applied various loads on application successfully.
• Participated in feasibility study meeting and JAD sessions.
• Produced Requirements Trace-ability Matrix to support the application development.
• Deploy functional reports
• Involved in comprehensive process for identifying, assessing and monitoring key risks and mitigation process.
• Reported and tracked defects, monitored defects reported by team.
• Manage Projects, schedules and status.
• Attended Turnover and Product move meetings

Environment: Quality Center 9.2/11(ALM),WebServices JAVA, HTML, DHTML, XML, EJB, JSP, Oracle11g/10g,DB2,SQL, TeraData, PL/SQL, Mercury Interactive Tools (Quality Center, Quick Test Pro 9.2, Load Runner 8.1,QTP11), Visual Source Safe, UNIX, Windows NT, Windows7/XP,MAC Oracle and SQL Server, DashBord,UI

Confidential, New York, NY

QA Analyst

Responsibilities:

• Involved in writing and implementing of the Test Plan, Test Cases, Test Procedures, and Test sets for subscriber flow using Design document and functional specification with Test Director.
• Performed back-end testing to ensure that the user data was updated in database using SQL queries
• Planed, designed, executed test plans and test cases for automated test and manual test to support maintenance releases for multiple web based applications.
• Free quietly use the Unix command to run the batch jobs
• Write/edit the shell scripts to validation feed files
• Extensively use the Teradata to write SQL/complex SQL to pull data from database
• Write/edit PL/SQL Scripts using Toad
• Actively participated in test case automation using a structured, key word driven and hybrid framework with QTP .
• Writing/Edit reusable function using VBScripts
• Used Descriptive Programming in QTP and Shared Object Repository method.
• Generated reports based on log where customers’ requests are recorded.
• Tested integrity and consistency of data in reports.
• Tested enhancements and bug fixes for software releases and patches and document findings
• Created flexible structure for running the test process with parameterized data.
• Provided management with daily status reports.
• Attended status call with all stakeholders to review deployment schedule, issues log and status.
• Designed Performance test scripts using Load Runner, ran Stress test, analyzed the results.
• Developed and tested Shell Scripts to test data integrity.
• Closely interacted with clients for User Acceptance Testing. (UAT)
• Reported and tracked defects, monitored defects reported to use JIRA
• Write the test cases base on Business Requirement & mapped them to the test plan
• Create test bed & test data
• Execute the test cases & participate to select regression set of test cases
• Select the test cases level(L1,L2 & L3) to execute par release
• Participate the release meeting

Environment:: Windows XP,MAC, MS-SQL Server, Test Director, Oracle, Unix and SQL Server, JAVA, HTML, DHTML, XML, EJB, JSP, Oracle9i/10g/11g, SQL, TOAD 8.0, PL/SQL, Mercury Interactive Tools, QTP 10.0

Confidential, New York, NY

QA Engineer

Responsibilities:

• Analyzed functional specifications from the front-end application without any requirement documents.
• Used SQL Queries for database testing to validate the data and mapped back to business requirement
• Extensively use the QTP for mobile platform to test the e-reader application
• Constantly use the Cloud server to test server load distributed as expected
• Frequently use the proxy to login Cloud Server check the application behavior
• Extensively use AS400 to validation integration order
• Attended to the Scrum to discuss about project goal & accomplishment
• Exclusively flow the ALM process to upload requirement, write the test cases, execute test cases & report the defects
• Extensively used Quality Center to upload requirements, write test cases and for reporting and tracking defect
• Frequently use the mobile application to verify the application sustain, validation data
• Written SQL Queries to perform back-end testing
• Frequently used different operating system such as MAC, Vista,Windows7, XP to verified software quality
• Extensively used VMware & XP-Mode, Linux, Unix
• Assigned task to team members, provided assistance to team members to clarify functional and technical difficulties.
• Extensively used ipad, iphone & blackberry, android to test the mobile application
• Wrote automation test plans and prepared the automation test matrix for each regression cycle .
• Developed and executed various VBScripts using QTP for automated testing of each individual functionality & Regression Testing of the applications
• Generated test scripts for functional and regression tests using QTP.
• Designed and generated Reusable Test Scripts using QTP.
• Validated data for of the Sybase version of the application with the SQL version in order to check the data integrity of the new version with the older version.
• Interacted with Subject Matter Expert (SME) to gather requirements and designed detailed test plan document for application testing.
• Created Load Test scripts with Virtual users ( VUsers ) and test Scenarios, Executed Record and play back and applied various loads on application successfully.
• Participated in feasibility study meeting and JAD sessions.
• Produced Requirements Trace-ability Matrix to support the application development.
• Deploy functional reports
• Involved in comprehensive process for identifying, assessing and monitoring key risks and mitigation process.
• Prepared comprehensive Test Plan for Cash Wire and Key Rep application.
• Conducted integration testing for several modules for Cash Wire Application.
• Executed UNIX commands extensively on the backend server to verify backend server logs.
• Reported and tracked defects, monitored defects reported by team.
• Manage Projects, schedules and status.
• Attended Turnover and Product move meetings

Environment: Test Director, Quality Center 9.2, JAVA, HTML, DHTML, XML, EJB, JSP, Oracle11g/10g,DB2,SQL, TOAD 8.0, PL/SQL, Mercury Interactive Tools (Quality Center, Quick Test Pro 9.2, Load Runner 8.1,QTP11,ALM), Visual Source Safe, UNIX, Windows NT, Windows 2000, Windows XP, Oracle and SQL Serve

Confidential, New York, NY

QA Tester

Responsibilities:

• Gathered the Client requirement and analyzed the Strategy and Workflow.
• Analyzed the technical specifications and creating the necessary test scenarios and test cases for verification of data flow from each entry point to each exit point.
• Developed SQL Queries and Stored Procedures to perform database testing.
• Executed the SQL queries on database to verify the report values
• Created Test scripts for testing and validating the Database records using SQL Queries .
• Responsible for ensuring test environment and test data readiness.
• Extensively handled the application response for positive and negative sets of data using data driven testing.
• Reviewed Functional Requirements and Technical Specifications.
• Designed and Developed software quality plans and test cases for various web modules.
• Created and executed test scripts and validated the results against a set of formal requirements.
• Reviewed of System, Regression, and Integration testing test cases.
• Designed and implemented QA environment for automated GUI testing and functional testing based on QTP.
• Used Test Director to organize and manage all phases of the software testing process, including planning tests, executing tests, and tracking defects.
• Developed and executed testing process, created database of automated tests, build test cycles using Test Director.
• Created common repositories using Test Director on the local environment and on the network.
• Created flexible structure for running the test process with parameterized data.
• Provided management with daily status reports.
• Attended status call with all stakeholders to review deployment schedule, issues log and status.

Environment : MS-SQL Server, XML, IIS, HTML, MS-Office, VSS, QTP , Test Director, Oracle9i/10g ,LINUX, Internet Explorer, Netscape, Mozilla Faire Fox, Visual Basic.NET, ASP.NET.

Confidential, VA

QA Analyst

Responsibilities:

• Analysis/Review of business use-cases and providing feedback to the business analysts regarding functional discrepancies in requirements
• Involvement in User Interface walkthroughs to analyze functionality based on the use-cases/ requirements and providing feedback
• Design of test strategies, test cases, test scenarios and test data for unit, integration and regression testing.
• Extensively handled the application response for positive and negative sets of data using data driven testing.
• Created and executed test scripts and validated the results against a set of formal requirements.
• Develop test matrices to map use-case requirements with test-cases
• Execution of test plans and Defect Reporting using Test Director.
• Review meetings with technical teams and business users to discuss functional issues
• Tested and creating response time reports and using Brio
• Run SQL Queries in Toad for Database verification
• Maintain SDLC specification and covering quality assurance of configuration builds and software.

Environment: Windows XP, Oracle, UNIX and SQL Server, Java, J2EE, JavaScript, Oracle, Toad, Test Director, Internet Explorer, Netscape, Mozilla, ASP.NET