SUMMARY:

• 8+ years career leading the appropriate testing and delivery of quality software, products, systems, and applications to meet business, market and customer needs for financial/ecommerce.
• Experienced in testing Client/Server and web - based applications .
• Expertise in OBIEE and DWH Concepts
• Good understanding about investment banking process
• Extensively knowledge about full Software Development Life Cycle( SDLC )
• Experienced in Web Services Testing
• Extensively knowledge of Transformation rules verification process and data comparisons
• Experienced knowledge of White Box and Black Box Testing
• Understanding of Relational Database Concepts.
• Extensively know to write difference type of join SQL quires
• Broadly working knowledge about ETL process
• Good understanding about OATS process
• Good knowledge about Python, HTML and Javascript
• Involved in testing application on different mobile Platform such as iOS and Android devices.
• Strong experience in Java Programming, Selenium WebDrive, JUint & TestNG
• Good Experience on Selenium IDE and creating Scripts in selenium --RC by using Java
• Extensively experiences in End to End and Back-end testing
• Good understanding about FixedIncome, Option and Equity market
• Broadly knowledge about upstream down stream testing
• Experienced in Data ware house /BI testing
• Strong knowledge about API Testing
• Extensive experience to write complex SQL
• Knowledge and Experience in Content Management System (CMS)
• Excellent knowledge of Database security testing
• Proficient with the AS/400 operating system (OS/400)
• Extensively use the TSYS & ESYS
• Excellent understanding about CRM System
• Excellent understand about data conversion testing
• Exclusively use ALM to report the management
• Good knowledge about fixed-income
• Extensively worked with SQL queries for back-end testing.
• Experienced to write the Unix shell scripts to load test data
• Extensive knowledge to test iPhone, iPod, Smart phone, Black Berry, Android
• Experienced in working on both Windows and UNIX platforms .
• Extensive working experience to use Agile methodology
• Performed Smoke, Integration, Positive, and Negative, UAT, Configuration, Compatibility, Functionality, Regression, and System testing
• Excellent Knowledge of Mercury Quality Center to maintain Requirements, developed test script, test execution and defect tracking
• Use UNIX shell scripts To check servers, Channels, queues for various import exports activities
• Exclusive experience in designing, developing and implementing automated scripts .
• Developed and/ modified QTP regression scripts to new functionality.
• Experienced in working with Business Analysts to understand business requirements and prepare test strategy .
• 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.
• Tested Web app, Native app using SeeTest for automated the mobile testing and run the scripts for multiple devices with VBScript using QTP, and also perform manual testing according to the requirements

TECHNICAL SKILLS:

Operating System: Window, VMWare, UNIX, Linux, TSYS,ESYS, 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

DBMS: ORACLE 10/11g, Sybase, MS SQL Server MySql, MS Access, BIGDATA(Hadoop)

Automation Testing Tools: Mercury QTP/UFT, Selenium, Win Runner, Load Runner and Test Director

Portals: Internet Explorer, Mozilla, Safari, Google Chrome

Error Tracking Systems: Test Director, QC, JIRA, Test link, ALM

PROFESSIONAL EXPERIENCE:

Confidential, NYC

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
• Extensively used Rapid SQL for down stream and up stream application testing once data flow from difference vendor
• 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.
• 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, DataWarehouse 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 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 Informactica 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,

Backend QA Analyst

Responsibilities:

• Exclusively use the TSYS to test the Customer Portfolio Management System
• Extensively use the SQL Loader to load data into data base
• Used SQL Queries for database testing to validate the data base on business requirement
• Produce the report base on business requirement to use the BI
• Test the all business role which related to the ETL
• Write the different types of join SQL to join multiple tables data base on investment role
• Write the complex SQL to pull the data from database & check the portfolio growth base the investment
• Write/Edit Python, HTML and JavaScript for web application
• Test the investment portfolio base the business rules
• Write/edit complex SQL,PL/SQL to validation data
• Extensively use Database to write SQL quires for pulling data & test ETL process are working as expected
• Write different types of SQL quires to join multi tables to produce report for ETL process
• Using the Unix command & write Shell Scripts to validation the Unix feeds
• Working agile team & join scream meeting to discuss about work progress
• Address customer problems and questions to generate business in the fixed income field and to support the growth of assets.
• Monitor and analyze the assets coming into the portfolio
• Using as400 to pull data from database base on business role
• Extensively work with CRM System to check all credit are applied to profile
• Develop business plans to ensure that fixed income business runs optimally
• Extensively write/edit the SQL,PL/Sql to convert data from UI to database
• Exclusively use the TSYS & ESYS to update user account including increase/decrease credit limit, merge credit card, link bank account with credit card account, change address etc
• Frequently use the Tera data/SQL Developer to pull data from data base & check the all DBA objects ( function, procedure, trigger, indexes etc ) are working as expected
• Extensively used Quality Center to upload requirements, write test cases and for reporting and tracking defect
• Free quietly use the Barclays’ CMS process to update all testing document
• Write/Edit the Unix Shell/Python Scripts to test the feed files
• Extensively use the Unix command to test the unix feed
• Created ETL mappings using Informatica Power Center to extract the data from multiple sources like Flat files, Oracle, Xml, csv, Delimited files transformed based on business requirements and loaded to Data Warehouse
• Write/Edit the shell scripts to load data & test the server data according to business requirement
• Written SQL Queries to perform back-end testing to use Oracle/SQL Server
• Extensively used VMware & XP-Mode, Linux, Unix
• 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.
• Involved in comprehensive process for identifying, assessing and monitoring key risks and mitigation process.
• Prepared comprehensive Test Plan for Cash Wire and Key Reapplication.
• 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: Quality, Center, JAVA, HTML, DHTML, XML, EJB, JSP, Oracle11g/10g,TSYS,ESYS,SQL, Tera Data 13.5, PL/SQL, Mercury Interactive, UNIX, Windows NT, Windows 2000, Windows , Oracle 10g/11g,DB2 and SQL Server, PL/SQL

Backend QA Tester

Responsibilities:

• Analyzed functional specifications from the front-end application without any requirement documents.
• Write the PL/SQL to test database using toad & SQL prompt
• Write/edit the complex and dynamic SQL to use oracle & SQL Server for data validation
• Free quaintly use as/400 to test the integration part of the application
• Extensively use Team Foundation Server (TFS) & CMS to upload documentation
• Validation the all types of tax are applied regards of customers category
• Extensively use SSIS for reporting purpose
• Used SQL Queries for database testing to validate the data and mapped back to business requirement
• Free quaintly use Hybris Technique for integration testing
• Write/Edit the shell scripts to test the server data according to business requirement
• Frequently use HTTP Hypertext Transfer Protocol & HTTPS Hypertext Transfer Protocol Secured to test all protocols are connected expected way
• Extensively use the Unix commands & script to test the fee files
• Attended to the Scrum to discuss about project goal & accomplishment
• 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
• 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 .
• 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.
• Involved in comprehensive process for identifying, assessing and monitoring key risks and mitigation process.
• 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.

Environment: Quality Center 9.2, / ALM 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), UNIX, Windows NT, Windows 2000, Windows, and SQL Server

QA Engineer

Responsibilities:

• Analyzed functional specifications from the front-end application without any requirement documents.
• Extensively use the SQL Loader to load data into data base
• Write/edit the pl/sql to pull the data from the Database to verify the profile update base on the investmen t
• Used SQL Queries for database testing to validate the data base on business requirement
• Extensively used Quality Center to upload requirements, write test cases and for reporting and tracking defect
• Created ETL mappings using Informatica Power center to extract the data from multiple sources like Flat files, Oracle, Xml, csv, Delimited files transformed based on business requirements and loaded to Data Warehouse
• Write/Edit the shell scripts to load data & test the server data according to business requirement
• Written SQL Queries to perform back-end testing to use Oracle/SQL Server
• Frequently used different operating system such as MAC, Windows(all version) 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 to test the mobile application
• Wrote automation test plans and prepared the automation test candidate for each regression cycle.
• Implemented web service message flows using SOAP nodes in Web sphere Message Broker 6.1
• Developed and executed various VBScripts using QTP for automated testing of each individual functionality & Regression Testing of the applications
• Managed a comprehensive invoice reconciliation project, identifying billing errors by comparing major vendor’s invoice to internal policies, accessing switches to observe utilization, and producing reports of high bandwidth
• Expertise in using FIX Protocol API . Testing admin and application FIX messages like logon, logout, resend request, reject, sequence, pre-trade, trade and post-trade messages. users to showcase where traffic is going
• 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: Quality Center, JAVA, HTML, DHTML, XML, EJB, JSP, Oracle11g/10g,DB2,SQL, TOAD 8.0, PL/SQL, FIX Protocol API, Mercury Interactive, UNIX, Windows NT, Windows 2000, Windows , Oracle 10g/11g,DB2 and SQL Server, PL/SQL

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.
• 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, HTML, MS-Office, QTP, Oracle9i/10g, LINUX, Internet Explorer, Mozilla Faire Fox, Visual Basic.NET, ASP.NET.Java