SUMMARY:

• Over 7+ years of diversified professional experience in Software Quality Assurance Analyst /Tester/Engineer in testing Web App., Client - Server Appl., Data Warehouses, Databases, ETL Testing and Large Corporate Reporting Structures with immense Information Technology (IT) background, diversified exposure in both Manual Testing and Automation Testing, implementation of QA methodologies and Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC), Agile -Scrum, Agile-Kanban and being involved in the complete Testing Life Cycle
• Hands-on in requirement analysis using Business & Functional Requirement documents, Use Cases, Solution Definition documents, Technical Design documents and conducting knowledge transfer & training along with business analysts, developers and end-users, designed and Developed Test Plans, Test Scenarios, Test Cases, Test Scripts, maintained Traceability Matrix followed by Bug Tracking and Reporting. Strong experience in full Black Box Testing that includes Functional testing, GUI testing, System Integration testing, End-2-End testing, Smoke testing, Regression testing and User Acceptance testing (UAT).
• Well-versed with designing and Developing Test Plans, Test Scenarios, Test Cases, Test Scripts, maintained Traceability Matrix followed by Bug Tracking and Reporting, with Strong hold in full Black Box Testing that includes Functional testing, System Integration Testing (SIT), ETL Testing (End to End), GUI testing, System Integration testing, End-2-End testing, Smoke testing, Regression testing, Production Support and User Acceptance testing (UAT).
• Proficient in database/ Back End Testing by writing & executing SQL Queries and exposure to various relational databases like Oracle, SQL Server, and extensively used various Test Management & Defect tracking tools like Quality Centre, JIRA, and Win Runner, Front end testing for various modules like login, Trading, Risk calculation, Payment options, etc.
• Hands on experience with testing tools such as Selenium 2.0, HP QTP, HP Quality Center, HP BPT and HP ALM.
• Expertise in Selenium automation using Selenium IDE, Selenium RC, Selenium WebDriver.
• Worked with financial, Banking, Credit Card, Commerce Solution, Trading, Investment banking and expertise in Equity and Fixed income securities and derivatives (options and futures) products. Expertise in Merchant On-Boarding Process.
• IT Skills Extensively used various Test Management & Defect tracking tools like Quality Centre, JIRA, and Win Runner, performed web services testing (XML) using Soap UI, XML, performed backend testing using SQL queries to check the data accuracy and integrity, exposure to Version Controlling Tool like SVN and CVS, and experienced in creating & executing test scripts, scenarios, performing UAT, ETL tools (Control-M, Tivoli and Autosys), Unix/Linux Shell Scripting, Java, .Net, SalesForce (Sales, Lead, Oppurtunity Apps), PeopleSoft On-Boarding Application testing
• Industry experience - Banking, Insurance & Financial Services
• Experience in Back end testing using Oracle and SQL Server
• Strong interpersonal skills, written and verbal communication skills, Ability to manage conflicting interests and identify compromises, Ability to deliver results under pressure, Ability to travel as needed.
• Specialize in working with clients, stakeholders and business owners at all levels with superior communication, presentation, analytical and problem solving skill.
• I go beyond expectations for fixing/trouble shooting and issue in no time.

TECHNICAL SKILLS:

ETL Testing Tools: Informatica and Ab Initio

Automation Tools: HP Quick Test Pro, Selenium, iMacros and Excel Macro

Microsoft Testing Tool: Microsoft Visual Studio Team System (Test Edition)

Defect Trackers: Test Director, HP Quality Center, HP ALM, JIRA.

Hadoop Ecosystem: HDFS, MapReduce, Sqoop, Flume, Hive, Pig, HBase, YARN, Oozie, Impala, Zookeeper, Kafka, Cloudera Manager, Spark

Hadoop Distributions: Apache Hadoop, CDH4, CDH5, Hortonworks and aws (amazon web services)

Other Tools: HP BPT, Putty, WinSCP, Control-M, Tivoli, Blueprint, Peoplesoft, MKS and Autosys

Scripting: Unix/Linux Shell Scripting, Java Script, VB Scripting, Python.

Methodologies: Waterfall, iterative, Agile Scrum, Hybrid and Agile Kanban

Languages: Visual Basic Script, ASP.NET, .NET, ADO.NET, SharePoint 2007, C#, C, Java, HTML, XML.

Databases: Oracle 10.7/9i/11i/8.x, MS-SQL Server 7.0/6.5, MS-Access, DBMS, Teradata.

Version Control: MS Visual Source Safe (VSS), Concurrent Versions System (CVS), MS Team Foundation Server (TFS).

Reporting Tools: Cognos Report, PTO and ROL-CST.

Office Tools: MS-Office

Operating Systems: Windows 7/XP/2000/98/Vista/, UNIX, MS-DOS, Windows Server 2003/2008

Business Modeling Tools: MS Visio, MS Excel

PROFESSIONAL EXPERIENCE:

QA Analyst

Confidential

Responsibilities:

• Analyzed Business Requirements, User Stories, Functional Requirements and understood customer and developed QA/SIT Test Plan using Testing Methodology.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Testrail.
• Responsible for testing cloud based integrations between different systems ( Confidential to ADP, HCM to Kronos etc.) and component parts of the application to ensure that it functions properly
• Created business flows in the confluence.
• Performed the tasks of testing inter process communication, shared data, and sub systems.
• Performed responsibilities of executing end-to-end testing for each module, components, and sub systems of the application.
• Coordinated with Business Analysts regarding the Gaps in the business requirement document and worked with BA to fix the Gap’s.
• Coordinate with ADP 3rd party testing team for performing integration testing between Confidential to ADP.
• Created test cases for SIT, End to End testing and Regression testing.
• Worked with automation team(selenium) to guide on the which integrations can be automated and how can we make it effective automation testing using Jenkins.
• Performed the tasks of testing inter process communication, shared data, and sub systems
• Entire project is performed in Agile methodology with 3 weeks of sprint cycle

ENVIRONMENT: Testrail, Confluence, Oracle Confidential, Taleo, Oracle Finance, ADP, Kronos, Excel, Jenkins, Mulesoft, IssueTrack

QA/UAT Lead JP Morgan

Confidential

• Analyzed Business Requirements and understood customer and developed QA/SIT Test Plan using Testing Methodology.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Quality Center
• Demonstrated QA Test Plan with cross-functional team to approve business logic and baseline documents.
• Testing ETL components by Executing SQL.
• Created and maintained test scripts in Quality Center and co-ordinate with the Data warehouse ETL group and other developers. Created the test plan and worked with the Business users, PM’s and Dev Lead for Sign off’s.
• Developed Data warehouse ETL test cases for various lines of businesses based on ETL mapping document.
• Backend testing of the Data Base by writing SQL queries to test the integrity of the application and Oracle databases.
• Collected user stories for Agile project from different sources like MKS application and Jira, for waterfall project collected the business requirements from Blueprint, for Hybrid project collected requirements from MKS, Jira and Blueprint.
• Generated Traceability Matrix out of ALM and generated requirement traceability matrix out of Blueprint, generated test execution report in excel for weekly status meetings.
• Performed Daily Status calls and after each call I had sent out daily status email to Business PM’s and all team members involved in the call.
• Upon customer’s request generated On-Demand Reports on the specific data conditions using CST and PTO report application.
• Coordinated with other QA tester for validating the frontend report pulled from CST Report application with backend data for data validations.
• Scheduled meeting with Business SME’s for different Business Area’s to check the impact for current changes.
• Performed UAT assessment on the Impact Matrix.
• Managed team of 2 for ComCard Project and coordinate with the team on daily basis regarding daily tasks and assigning of work on daily basis.
• Performed Salesforce validations for a new merchant by creating the leads object and transferring the leads to opportunity object and perform the onboarding to Peoplesoft via Orbital Gateway (Sales Application in Salesforce).
• Performed Web Services testing using Speedboard application.
• Created the BUC’s (Business Use Cases) for the Paymentech applications like Peoplesoft, PTO report, Salesforce and SpeedBoard
• Enhanced the test scripts for Global Execution.
• Performed daily standup meetings and scrum calls.
• Captured and tested all modifications to proposed functional requirement.
• Created test cases and executed them via ALM.
• Followed complete UAT processes and uploaded the UAT Testing artifacts onto SharePoint
• Communicated frequently with clients regarding applications functionality requirement.
• Met all project timelines and deadlines.

ENVIRONMENT: HP ALM, BRAUT, MSEXCEL, Oracle DB, Teradata, Peoplesoft, Salesforce, PTO Report, Speedboard, CST Report, MKS, Jira, Blueprint, Titan and Orbital Gateway.

Quality Assurance Analyst JPMorgan Chase

Confidential

• Involved in multiple releases of ETL applications and ensure defect free implementation into production meeting all business requirements
• Coordinated in UAT for multiple releases with all teams involved.
• Conducted Daily / Weekly meetings to track status, schedules, and defects, cross block impacts and resolved all project related issues.
• Created Test Plan from the Business Requirements/Functional Specifications documents and Technical documents.
• Developed Test cases for the applications in Quality Center and execute the test cases for different testing cycles (i.e SYS, REG, IST, UAT etc)
• Logged defects in Quality Center and reported these defects in daily stand up calls as outstanding issues.
• Created Traceability matrix to keep track of business constraints that the application has to meet.
• Created valid, accurate test data using DEM (Data Element Mapping) and DES (Data Description) documents to meet the expected results
• Worked closely with the onshore, off-shore development and testing teams to meet the project goals and deadlines
• Coordinated with other QA leads, Project Managers, Development Managers and QA core members to make sure all downstream files had been reached to their systems for further processing.
• Validated different stage graphs and implementation plan, validated source files, reports and table watchers
• Created the Pivot table for validations of BASEL application report.
• Tested ILOG software which is customized to Chase POE and ODE applications
• Tested JSP, ILOG and data loaded by Ab-Initio graphs which are integrated with each other.
• Performed validation on c3 side regarding the data sent from ACME reached to C3 system in required ordered
• Worked with Control-M and Tivoli workload scheduler jobs for processing the flat flies that we received.
• Performed ITE recovery by restarting failed job in Tivoli workload scheduler.
• Coordinated with c3 Dev and C3 Business User(UAT) for modifying the ACME file according to business requirement and user’s requirement by doing a screen share with the TSYS system for successful test results.
• Tested Keonization (Same as OES) on ACME application and its down streams using putty tool.
• Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files for trouble shooting issues, removing old files and created a shell script for deleting a dummy file that was creating while job get starts (this prevented in failing the job and stop of processing).
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Performed end to end web testing for the applications CBR and Letter Engine. Where I have created the test cases for cross browser testing, browser upgradation testing and if we enter the data in the front end performed validation on the output generated file and processed that file with the ETL machines.
• Used QTP for performing regression testing.
• RSNG and ODE, ODS are the GUI based applications, tested these applications from end to end and it involved the middle vendors for validations and validated the input results at the backend (database & Unix file system)
• Created templates and BPT components to creates the reusable test cases.

ENVIRONMENT: Oracle Sql Developer, UNIX, MS Word, Winscp, Ab Initio, Windows 7, Tera Data, Tivoli Workload Scheduler,ALM, QTP, TSYS, Control-M and BPT.

Technology Analyst

Confidential

• Developed business process flows “As-Is” and “To-Be” to determine gaps and estimate level of effort (LOE) need for customization.
• Conducted various meetings with business stakeholders to understand high-level business requirements and translated them into functional requirements document as well as the system specification document.
• Conducted meetings to understand the business processes; gathered and documented the business requirements for new database system - Oracle
• Worked closely with business users and technology team to capture system behavior
• Facilitated planning and status meetings with project teams, and follow up on all issues through resolution to ensure on time delivery.
• Developed the test scenarios based on the FSD and BRD.
• Planned, organized and leaded the testing kick-off meetings.
• Communicated key-blockers in testing phase to management and worked closely with developers to fix identified issues.
• Created automation and re-modified the existing scripts using HP QTP.
• Worked in Hybrid Framework (Data-Driven and Keyword Driven).
• Executed automated test scripts using QTP 9.2 to perform through testing
• Quality Center Management.
• Performed Back-End testing using SQL queries within the QTP Script to compare and retrieve data by using Data Base Check points.
• Managed testing timelines and deliverables.
• Wrote and executed manual test scripts based upon existing product functionality, specifications, requirements and other sources as needed
• Used like Agile Methodology.
• Performed functional testing, regression testing, sanity testing, black box testing and UAT Testing.
• Coordinating with offshore team on automation testing.
• Used Quality Center for bug tracking and reporting. I did take the initiation and conducted Test Status Meetings for every release cycle.
• Reviewed defect reports and assign valid defects to the relevant developer/ development manager.
• Record defects in accordance with QA best practices; i.e. with full documentation and information including reproduction steps
• Performed database validations.
• Interfaced with the developers in resolving the defects investigated in the application during testing.
• Interfaced with business people to resolve the defect understanding issue.
• Designed the SQL queries for data saved to database and data extraction.
• Involved in production support and release support.
• Validating the logs.
• Involved in preparing daily status reports.

ENVIRONMENT: HP Quality Center 10.0, HP QTP 9.5, Vb Scripting, MS Sql server, JMX+, Anthill Pro, Web Logic, UNIX, MS EXCEL, MS Visio, Winscp, Windows XP Professional, Java

QA Analyst

Confidential 

• Gathered User and business requirements through interviews, surveys, prototyping and observing Stored and modified requirements in MS Word.
• Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams in MS Visio. Documented all custom and system modification. Assigned problems to appropriate software development team for fixes.
• Created and managed project templates, use-case project templates, requirement types and traceability relationships in Requisite Pro.
• Authored progress and completion reports, which were then submitted to project management on a weekly basis.
• Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.
• Prepared Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Performed functional testing, regression testing, sanity testing, black box testing and UAT Testing.
• Coordinating with offshore team on automation testing.
• Used Quality Center for bug tracking and reporting. I did take the initiation and conducted Test Status Meetings for every release cycle.
• Reviewed defect reports and assign valid defects to the relevant developer/ development manager.
• Record defects in accordance with QA best practices; i.e. with full documentation and information including reproduction steps
• Performed database validations.
• Interfaced with the developers in resolving the defects investigated in the application during testing.

ENVIRONMENT: HP Quality Center, Oracle 10g, Linux, Windows Server 2003, J2EE, IIS, JVM, MS Visio, WinScp, MS Word, MS Excel.