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 experiences about Informatica’s DVO
• Exclusive use Talend for data migration
• Write/edit complex SQL for backend testing
• Broadly knowledge Data warehouse and data mart testing
• Good knowledge of API Testing
• Extensively knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle
• Exclusive knowledge about FixIncome product including Government and Corporative Bond
• Good understanding about Option and Equity Market
• Extensive knowledge to work with off shore team
• Experienced inBig 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
• 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/ALM 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 types 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, Talend

DBMS: ORACLE 9i (x),10g,11g,12c,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, NYC

ETL/Backend QA Analyst

Responsibilities:

• Writing the test plan and test cases base on the business requirement.
• Create the test data for Testing
• Extensively use the Tableau for BI/Report Testing
• Exclusively used the Robot Framework for Automation testing
• 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 DVO for source and target table validation/verification
• Extensively used Rapid SQL for downstream and upstream application testing once data flow from difference vendor
• Loading Data from ORACLE to Hadoop Cluster using Sqoop and all data transfer as expected
• Hands on experience with Spring tool suit for development of Scala Applications
• Write the test plan/test cases and execute them which follow SDLC Process
• 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
• Written Black Box test scripts base on requirement without knowing program logic
• Extensively used Informatica Power Center for ETL process
• 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 SQLscripts 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
• Extensively used Informactica Power Center/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 Fixed Income 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/ALM, JIRA, JAVA, HTML, DHTML, XML, EJB, JSP, Sybase Oracle11g/10g/12c, Sql Server, 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, 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 DVO to write SQL in sqlview, create table pair between source(sqlview) and target(tables) to validation/verify the data
• Frequently developed SQLscripts for Back-End testing
• Used DVO to compare data between tables level
• 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 worked on backend testing of EDR mainframe applications
• Extensively used Rapid SQL for downstream and upstream 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
• Use Talend to extract data from oracle to hive table
• 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
• 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 Power Center 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
• 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 Power Center/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

ETL/Backend QA Analyst

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
• Performed Testing in a big data area
• Extensively used DVO for source and target table validation/verification
• Extensively used Rapid SQL for downstream and upstream application testing once data flow from difference vendor
• Loading Data from ORACLE to Hadoop Cluster using Sqoop and all data transfer as expected
• Creating Hive tables and writing Hive Queries on Data Sets Optimizing Hive Performance
• Hands on experience with Spring tool suit for development of Scala Applications
• 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
• 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 DataMarts.
• Extensively used Informatica PowerCenter for ETL process
• 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 SQLscripts 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 Informactica Power Center/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/ALM, JIRA, JAVA, HTML, DHTML, XML, EJB, JSP, Sybase Oracle11g/10g/12c, 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

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 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