SUMMARY

• Over Twelve plus years of experience in Business Analysis and Quality Assurance & in Financial Industries, Insurance and Airlines Industry.
• Over an year experience in Development of Struts Framework(Java, OOPS Concepts)
• Having Expertise in Leading & performing Functional, System Integration, Regression, and User Acceptance Testing.
• Expertise in testing Data Warehouse Applications, Client/Server and internet Applications using ETL Frame Work, J2EE, Java, Java Script, Struts, WSAD,UNIX,PL/SQL, Perl, Pro*C,C and Mainframe.
• Experienced in Creating Test Plans, Test Strategy Docs and Test Cases, Executing test cases and tracking defects.
• Experience in analyzing Traceability Matrix using Rational Tools.
• Proficient in estimating and defining detailed steps for testing efforts in all different applications Data Warehouse projects and Partner Launches.
• Hands on Experience in Mobile Applications testing.
• Experienced in Conducting Interviews and selecting the team members for Projects.
• Experience in Black Box and White Box Testing.
• Experience in analyzing UNIX Shell Scripts (Korn, Bourne)
• Experience in GUI, Regression, Data Driven, Functional, Database and User Acceptance Testing.
• Experience in Software Development Life Cycle (SDLC) using the Waterfall Model, Agile and Kanban Methodologies.
• Strong working experience in the Data Analysis, Data Verification and Validation of ETL Applications using Backend/Database Testing.
• Experience in Business Intelligence testing in various reports using Business Objects and Tableau Reports .
• A very good team player with excellent Communication (Verbal and Technical), Presentation and reporting skills.
• Expertise working with Off - shore Team and assigning testing responsibilities and follow up till test completion and reporting status to Project Manager. Responsible for updating the weekly reports.

TECHNICAL SKILLS:

Languages: C, C++, JAVA, SQL, Perl, Pro*C, SAS

Bug Reporting Tools: Test Director, Quality Center, TFS, IBM Clear Quest

Web Technology: Java, J2EE, Servlets, HTML, XML, PHP

Web services: SOAPUI

Databases: ORACLE, Teradata, SQL Server

Utility Tools: SQL Developer, TOAD and SQL Assistant

ETL Tools: Informatica 8.1 and Datastage 7.0 and 8.0

Reporting Tools: Business Objects and Tableau reports

Operating Systems: Windows 98/00/NT/XP, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, TX

SR. Test Engineer

Responsibilities:

• Extensive experience in ETL/ Data warehouse backend testing and Business Intelligence Reports testing.
• Expert Knowledge in creating Test plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.
• Experience in preparing test reports and prepared Daily status reports to communicate the status with the team.
• Actively Involved in User Acceptance testing and Training of the end Users. Participated in cross-functional teams to reengineer and improve business processes.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Extensively interacted with developers, business& management teams to understand the project business requirements and ETL design document specifications.
• Experience in Business Intelligence testing in various reports using Business Objects and Tableau Dashboards.
• Excellent Knowledge in Ms-Office (Word, Excel, PowerPoint), Ms-Access, MS Visio.
• Involved thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
• Defects identified in testing environment are communicated to the developers using IBM Clear Quest - Defects module.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.

Environment: Business Objects Web intelligence 4.2, Tableau 9.3, IBM Rational Tool Suite (ClearCase, ClearQuest), Microsoft Word, and Microsoft Excel, Microsoft Project, Microsoft Visio, SQL Developer, Windows XP/2000/2007

Confidential, Dallas. TX

SR. Quality Assurance Analyst

Responsibilities:

• Developed Test Plans, Test scripts and executed the test scripts for the Data Migration Project.
• Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Written test cases to test the application in Quality Center 9.0 and 11.0(ALM)
• Defects identified in testing environment are communicated to the developers using Quality Center - Defects module.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Setting up, monitoring and using Job Control System in QA
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases,
• Scheduling and automating jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and DB2 server.

Environment: Oracle 10g/11g, Informatica, SAP Business Objects 3.1 - Tableau Reports and Dashboard, HP QC 9.0/11.0, SQL developer, TOAD and SQL.

Confidential, Plano. TX

QA LEAD

Responsibilities:

• Gathering of functional requirements from sales and client service departments.
• Involved in meeting with divisional, regional, district managers to gather the user/real time requirements for devices.
• Created, analyzed and reviewed the software requirements, functional specifications and design documents.
• Responsible for creating Test Plans and Test Strategy Documents.
• Analyze Iphone App, compared with requirement documents and suggested enhancements to developers.
• Led the development and execution of test plans and scripts for project-based, new software rollout. Testing to include unit testing, application testing, integration testing, feature functionality testing, validation testing and regression testing
• Sound experience in Agile development methodologies like TDD and BDD and implementation of tests with selenium, cucumber/capybara in Ruby
• Sound experience in automation ions using Selenium, Selenium RC, Web Driver
• Created automation framework product for selenium test script execution either on Java or .Net connected with Continuous Integration
• Involved in validating different modules in PHP.
• BDD/Cucumber approach which allows non-programming QA engineers to write new automated tests
• Manage daily reviews of automated test run results
• Reusable steps that allow the test creator to specify attributes for identifying UI objects
• Wrote SQL queries and stored procedures to validate data.
• Highly involved in validating all the functionalities on new iPhone App of the company across the intermec /Conventional devices.
• Manage daily reviews of automated test run results

Environment: HP Quality Center 10.0,MS OFFICE, AS400,DB2,PHP,.Net,MySQL, SQL Server Management Studio, Iphone, Mobile/Intermec, Selenium, Cucumber.

Confidential, Arlington. TX

Data Quality Analyst

Responsibilities:

• Responsible for identifying opportunities for business-rule verifications by meeting with business members and other DW personnel.
• Responsible for reviewing the specifications, analyzing the data and provide technical specifications on those verifications to the ETL team for the deployment.
• Continually looks for ways to improve performance by attending seminars, training classes, reading articles, etc
• Performed quality testing for pre-production and ensure all testing results are stored appropriately
• Experience in generating test script (SQL QUERIES) based on BRD, ETL Spec and mapping doc.
• Created, reviewed, and executed SQL test queries to validate transformation rules used in source to target mappings and verify the data in target tables.
• Modification of test cases and test scripts based on the requirement change via Change request.
• Review of Test Case results and Track issues to closure.
• Analyzing defects and finding out the root cause for the issues.
• Responsible for Generating of daily/weekly Status reports.

Environment: Rapid SQL, Informatica 9.10, Remedy Tickets System, COGNOS, BPC reporting Tools, Excel Macros.

Confidential, Malvern.PA

Business Systems Analyst

Responsibilities:

• Used a variety of information gathering techniques (e.g., interviews) to determine system requirements and technology needs.
• Responsible for translating business needs into system and software requirements, and create requirements documents.
• Responsible for Writing use case documents.
• Responsible for Scheduling Peer reviews/Walk through requirements/Design Document Review Meetings.
• Experienced in estimation of Project Timelines and test Plan.
• Responsible for Defining and Driving Test Strategies for Test Data Management.
• Responsible for Testing in Mainframe Batch Processing Applications.
• Having Very good experience in Agile Methodology and Creating User Stories.
• Strong experience in SQLs/Data Management and having ability to write and interpret complex SQL Queries.
• Experience working with Data Modelers and Experience in running Jobs in Mainframe/ControlM/Unix Environment.
• Team player with strong analytical, interpersonal, communication and problem solving skills.
• Having Ability to handle simultaneous projects, meet critical deadlines and timely execution of several client/server projects.

Environment: Mainframe Batch Processing, DB2, Oracle, Control M, SQL, Java Batch, Quality Center, Agility Enterprise, SERENA Business Manager.

Confidential, Wilmington. DE

QA LEAD

Responsibilities:

• Responsible to work on multiple platforms like Web-based applications in Java, .NET, Back-End testing using SQL with Data Feeds in Data stage, ETL environment, Reports in BRIO, Micro strategy and Data Ware house Applications.
• Followed Agile Methodology and weekly releases.
• Involved in manual testing of Web service using XML Data and SOAP UI Tool.
• Responsible for Manual Testing and Involved in writing Complex queries for Data Validations.
• Having Hands on Expertise in Data ware house Concepts/tools(Data Stage), Data Models and Involved in testing ETL Framework applications like PODS
• Developing and Maintaining Test Scripts, analyzing bugs and interacting with development team members in fixing the defects.
• Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• Ensure that all the test cases are updated in the Quality Center along with Master test plan.
• Tested critical bug fixes including critical fixes and coordinated with developers in release of bug fixes meeting tight timeline.
• Involved in Backend Database testing in Oracle using SQL.
• Defects were tracked, reviewed, analyzed and compared using Quality Center
• Responsible to work independently on multiple projects.
• Led a 15 member test team and responsible for Supervising and creating comprehensive test plans for System, Enterprise and Regression testing, creation and maintenance of test cases and test

Environment: Unix, oracle, Java, Net, Control-M, HP quality center 10.0, Data stage, Hyperion, Microstrategy, Teradata, SAS

Confidential, Newark, DE

Lead Business Process Analyst/Lead Quality Analyst

Roles and Responsibilities:

• Analyzed Business Responsible for testing Batch processes.
• Responsible for creating Test Plans, Test Cases and test Execution.
• Responsible for Data Conditioning and creating test accounts.
• Responsible for White Box testing.
• Having Expertise to read and understand code in UNIX, Java, Perl and PL/SQL.
• Having expertise in handling multiple projects and multitasking.
• Requirements, Functional and Technical Documents and Developed Test Cases.
• Interacted with developers for any issues/ defects.
• Executed Test cases with by running SQL Queries
• Testing Status has been taken from everybody in the team and Attended Status Meeting everyday
• Developed Testing status reports and have been sent to Managers.
• Involved in Implementing the Work Request’s in Production
• Responsible to validate the Post Implementation
• Responsible for Logging the Existing Production Issues in Test Director.
• Responsible for dealing with Policy/Business Users team, development team, Project Manager, A team and UAT team.
• Given suggestions and process improvement ideas to managers to improve the system.
• Involved in enterprise projects UDAP/REGZ.
• Responsible for writing SAS Scripts and shell scripts.
• Responsible for estimating the level of Effort for given Work Requests.
• Responsible for sending reports to the group from Test Director.
• Familiar with TSYS.
• Created Test Plans for the Projects.
• Mentored Offshore team members.

Environment: Batch Processing, MainFrame, Unix, perl, sql, oracle, Test Director, Java, SAS,.NET,C++

Confidential, Philadelphia, PA

Sr. QUALITY ANALYST

Responsibilities:

• Involved in preparing High Level Test Plan based on user requirement documents.
• Responsible in defining test objectives for the application and performed Manual Testing.
• Involved in all phases of testing, Functional Testing, System Testing, And UAT.
• Analyzed Business Requirements and Technical Specifications to develop Test Cases.
• Responsible for testing on Main Frame/Green Screens.
• Involved in Querying Power MHS
• Responsible for logging the defects
• Interacted with the developers for bug fixes and problem resolution.
• Participated in regular Project Status Meetings related to testing

Environment: Main Frame, DB2, AIX 5.3, Power MHS 6.3.3, Share Point, Quality Center 8.2.

Confidential. Newark, DE

Sr. Business Process Analyst

Responsibilities:

• Responsible for testing on Main Frame/Green Screens involving TSYS.
• Extensively used TSYS Green Screens (IAGI, ICAL, ICAD etc.) to perform day-to-day Job functions.
• Other Mainframe screens used were QDE, SUM, CBR, which were on ACAPS Platform.
• Involved in all phases of Software Development Cycle.
• Responsible for writing Use Cases.
• Used CDN (Credit Decision Navigator) to check process and data flows for code written by developers.
• Analyzed Requirements and Strata Explorer Visio’s to develop Test Cases.
• Tested the business functionality, navigation and validation of the application.
• Performed Positive Testing, Negative Testing and Regression.
• Responsible for Testing on Research Logs.
• Responsible for White Box testing.
• Performed execution of test cases manually to verify the expected results.
• Wrote SQL Queries to get test data from Production.
• Responsible for logging the defects in Test Director/Quality Center.
• Attended Defect review meeting with Team and developers to resolve issues.
• Involved in testing various new Product Launches ( Pier1, BP, TJ Max, Camping World, HEB, etc).
• Involved in testing the migration products (Business First to ACAPS).
• Analysis of business and system requirements of Credit Policy, New Account approvals and declines, credit line assignments etc.
• Communicated with ACAPS via Strata inbound and outbound events.
• Experienced in pulling the Credit Bureau and analyzing Credit Bureau reports for Application Processing.
• Regression Testing was performed and the additional test scripts were generated for each version of code release.

Environment: Main Frame, COBOL, Oracle, MS-Office, and Test Director/Quality Center 8.2.

Confidential, SAN ANTONIO, TX

Java Developer

Responsibilities:

• Configured Business Rules in Navisys Front Office rules engine to calculate the Premium for a Member Applied for Life Insurance Policy.
• Worked in an Agile Test driven Development environment
• Analyzed System requirement and developed the functionalities in Struts Framework.
• Created and modified Struts actions.
• Worked with struts validations & Mappings.
• Modified the JSP pages to meet the requirements.
• Interacted with Testers to resolve Modification Requests
• Attended Defect review meetings with Team to resolve issues
• Experience in managing onsite/Offshore team model

Environment: MAIN FRAME, Java, J2EE, JSP, Servlets, Junit, IBM Web sphere server5.0, IBM HTTP server, Test Director, UNIX, XML,Oracle9i.