SUMMARY:

• Have 17 years of IT experience in Analysis, design and development and testing of different applications which includes Banking, Insurance, Telecom, Insurance industry applications.
• Have extensive knowledge in different SDLC methodologies and Software Quality Standards and Metrics.
• Expert in the Software Testing Life Cycle (STLC) - phases include: Planning Process, Test Design, Test Development, Test Execution, Defect Tracking and Test Reporting.
• Extensive hands on experience in Designing test plans, defining test cases, generating and maintaining test scripts, analyzing bugs, interacting with other team members to debug the errors etc.
• Experience as Team Lead and Onsite Coordinator for Onsite-Offshore model. Managed onsite and offshore testing teams and coordinated activities between both ends.
• Expert in Mainframe, Web, Client/Server, Data Warehouse and database applications testing.
• Strong knowledge in planning and execution of testing for different Sprints in Agile environment.
• Have strong ability to work on multiple applications and perform multi-tasking with diversified technologies.
• Strong working experience in Windows NT, UNIX and Mainframe environments.
• Have good knowledge in Data warehouse testing and validating source and target data models and verifying the reports generated by reporting tools.
• Have good hands on experience in developing and executing automation scripts using Quick Test Pro (QTP) tool. Have good knowledge in developing scripts using VBScript.
• Extensively used SQL and PL/SQL and Unix Shell Scripting.
• Worked on mobile applications and Web Services testing using SOAP UI tool.
• Strong knowledge in preparing and maintaining test data for various testing purposes.
• Have strong knowledge and experience in using LoadRunner for Load and Performance testing.
• Expert in planning and executing Functional Testing, Regression Testing, Integration Testing and System Testing and UAT testing.

TECHNICAL SKILLS:

Languages: HTML, .Net, ASP, Java Script, Java, JSP, VB, Lotus Notes, SQL, PL/SQL, C, COBOL.

Testing Tools: QTP, ALM/Quality Center, Selenium, LoadRunner

Operating System: Windows 10/ 7, MS-DOS, UNIX, Linux, MVS/ESA

Databases: SQL Server, Oracle, Sybase, DB2, MS Access, Lotus Notes

Bug Tracking Tools: Quality Center, Test Director, QA Director, TEAM TRACK, Bug Zilla, JIRA and CLEAR QUEST

App servers: Web logic, Web sphere

Web Servers: IIS, IBM Http Web Server, iPlanet.

Tools: TOAD, Query Analyzer, Sql developer, AQT, Putty, Datastage, Informatica, MDM, Cognos and SOAP UI

PROFESSIONAL EXPERIENCE:

Confidential, NC

QA Lead

Responsibilities:

• Worked on multiple modules and reviewed the business requirements, analysis, developing Test Plan, Test Strategies to perform testing.
• Worked on Agile methodology and involved in testing of different Sprint builds deployed.
• Worked on reviewing the business use case documents and converting them in to manual test cases and documenting them in ALM tool.
• Developed Test Plan and Test Scenarios for Producer Management and Excess Liability modules.
• Involved in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Validated data in between source and target after running Mappings by the Informatica developer team.
• Tested Informatica folders, sources, targets, ODBC connections, FTP connections workflows, data profiling and manage metadata.
• Involved in Production checkout testing, Regression testing, Smoke testing of the application.
• Involved in testing of different areas of application like Producer Management, Producer Licensing, Broker Bulk Upload, Reports validation.
• Validated the Entity relationship d/w parent and child tables.
• Worked on execution of SQL queries to compare the data in database tables vs Reports generated.
• Validated XML data received from different vendors for proper data mapping to the database tables.
• Validated the error logs for the job failures.
• Executed the Testcases in Test Lab for different Test cycles and update the status report on daily and weekly basis.
• Coordinated work with other team members and mentored new members in the team.

Environment: Windows 7, Unix, Java, Quality Center, QTP, JIRA, SharePoint, XML, Oracle 11g, SQL Server 2008, DataStage 9.1, TOAD, SQL Developer, Cognos 10.x, Selenium and VMWare.

Senior QA Analyst

Responsibilities:

• Involved in Regression Testing of the application and executed Regression Test Cases.
• Documented the new test cases in Quality Center for newly added functionality.
• Created different test data files to validate different set of testcases.
• Validated the backend data by writing and executing SQL statements in sql query tools like SQL Developer.
• Documented the defects in JIRA and created the defects reports.
• Executed the Test cases in Quality Center Test Lab.
• Executed the Autosys Jobs to perform different tasks and create the output files.
• Validated daily client reports and compare the values with dashboard.
• Validated oracle backend tables after data is loaded after running daily batch job.
• Deployed the code in UAT and SIT environments for new releases.

Environment: Java, Windows 7, Unix, Oracle, XML, Oracle SQL Developer, Putty, WinSCP, Quality Center, Autosys Job Scheduler, JIRA.

Senior QA Analyst

Responsibilities:

• Involved in Requirement Analysis and design and STT (Source to Target) review meetings.
• Validated Table definitions and data in different stages of data loading steps by writing and executing SQL statements in sql query tools like SQL Developer, AQT.
• Validated different Exact Match and Fuzzy Match rules defined by business using MDM tool.
• Involved in Delta detection process and Reject Remediation process at different levels of data loads.
• Executed the different Robot jobs to load the data into Pre-Landing and Landing tables.
• Executed clean-up shell scripts in Test Environment to clear the data in multiple tables.
• Used SOAP UI tool to validate the web service requests and the response data received.
• Validated domain translation rules and Look up values in reference tables.
• Validated referential integrity maintained between parent and child tables during data load and data delete process.
• Used RxExpress and RxClaim Pharmacy related adjudication systems to validate the member information and his benefits, preferences and contact information.
• Used WinSCP and Putty tools to connect to the Unix servers.
• Used Quality Center and JIRA for documenting testcases, execution and defect tracking process.

Environment: Windows 7, Unix, Datastage, Informatica MDM, RxClaim, RxExpress, Oracle, DB2, XML, Oracle SQL Developer, AQT, Putty, WinSCP, SOAP UI, Robot Scheduler, JIRA.

Datawarehouse Consultant

Responsibilities:

• Worked as Informatica consultant and involved in reviewing the requirements and attended design review and daily status meetings.
• Created different complex mappings for different applications using multiple transformations to load data to staging, archive and EDW tables.
• Compared the data loaded in terms of number of rows loaded from source to target tables by writing and executing complex SQL statements in sql query tools like SQL Developer, Win SQL.
• Created different sessions and workflows and parameter files for various modules.
• Used Unix shell scripts to run pre and post session commands in the workflows. Used WinSCP and Putty tools to connect to the Unix servers.
• Used Debugger and Session and Workflow logs for tracing the execution errors.
• Created application and database Change Requests (CR’s) to migrate code from Dev environment to other environments.

Environment: Windows NT, XP, Unix, Informatica 9.1, Oracle, SQL Server, XML, Oracle SQL Developer, Win SQL, Putty, WinSCP, Quality Center .

Sr. QA Analyst/Automation Engineer

Responsibilities:

• Worked as a Senior QA analyst involved in all phased of testing process until project is deployed to production.
• Reviewed business requirements and created different functional testcases based on requirements.
• Used Quality Center for documenting, execution and defect tracking of the application.
• Involving defects triage and status meetings with different project members.
• Involved in system and integration testing with other applications.
• Involved in database validations using complex SQL queries using DB viusalizer tool.
• Validated the source XML data to target data during data migration process.
• Validated the complete order process from front-end via database and storing the data in backend WinDEC system where all the real time parts and customer information is stored.
• Validated the data hierarchy and dependency conditions between primary and secondary records.
• Validated the application in different operating system and browser systems.
• Tested different payment methods, Credit Card validations and order ship methods.
• Involved in Application Fail Over testing.
• Developed regression test steps to develop automate the regression process using QTP tool.
• Worked on internal Webtools application for validating the assigning and deleting different customers and accounts associated to a specific username.

Environment: Windows NT, XP, Unix, Quality Center, XML, QTP, Oracle, DB Visualizer, SQL Developer, TIBCO, Webtools, WinDEC.

Data Warehouse QA Lead

Responsibilities:

• Worked as a QA Lead, coordinating activities on multiple projects, maintaining status reports, Issues Log.
• Coordinated the testing activity between client onsite team and off site team.
• Involved in Business rules and use case documents review of different modules of the application.
• Involving defects triage and status meetings with different project members.
• Validated the different Informatica transformation rules and conditions.
• Validated the xml source data for valid data and developed XSD’s for importing data into right XML format using XML Spy.
• Validated the data hierarchy and dependency conditions between primary and secondary records.
• Used extensive SQL queries to validate the data in different database tables using RazorSQL.
• Documented all the testcases and maintained defects log in IBM Rational Quality Manager.

Environment: Windows NT, XP, Unix, Rational Quality manager, XML, DB2, MS-Access, Informatica, ClearQuest, XML Spy, RazorSQL, Notepad ++.

Onsite QA Lead

Responsibilities:

• Involved in Business rules and use case documents review of different modules of the application.
• Worked on reviewing the business use case documents and converting them in to manual test cases and documenting them in Quality Center 9.0.
• Documentation review and update the documents in VSS version control system.
• Worked on testing FLASH integration in the application.
• Involved in front end GUI testing and also Backend SQL Server database validations testing.
• Automated some of regression test cases using QTP 9.2. Developed frame work for automation.
• Created different checks in scripts including image, text and database validation check points.
• Worked on execution of high end SQL queries to test backend data insert in proper tables when the user does any transactions in the application.
• Validated XML data received from different vendors for proper data mapping to the database tables.

Environment: Windows NT, XP, Vista, Net, VSS, XML, SQL Server 2005, Quality Center 9.0, QTP 9.2 and FLASH

Onsite QA Lead

Responsibilities:

• Worked in dual roles as Onsite Team Lead and Offshore project coordinator at client place.
• Performed Test Planning and review of Test plans, testing process for different applications.
• Attend in application team meetings to review the testing strategy, high level design and detailed design document reviews for better understanding of the application.
• Co-ordination with application team and offshore testing team about the testing progress.
• Review of BR, TR and test plans and test cases, and tracking of defects documentation in Test Director.
• Performed test execution in validation of data using SQL, and run Shell scripts for batch jobs using Putty.
• Involved in data warehouse testing validating source and target data structures, and data flow processed by Informatica.
• Tested the ETL (Informatica) Mappings and other ETL Processes (Data Warehouse Testing).
• Tested Cognos reports for different scenarios like drill down for correct data.

Environment: Windows NT, ASP, JAVA, UML, XML, Test Director 8.0, WinRunner 8.x, LoadRunner 8.x, WebSphere 4.x/5.x, Oracle 9.x, DB2, Informatica, Control-M and UNIX.

Senior Load Tester

Responsibilities:

• Used the Test Director to document the bugs during the System and performance tests.
• Created the Automated test scripts using WinRunner tool for regression and system thread testing.
• Modified the existing WinRunner scripts according to changes made in application.
• Created the Automated test scripts using LoadRunner for different Web and Client/Server applications.
• Performed monitoring the Unix and Windows server statistics during the performance test.
• Performed Performance/Load Testing of application on different platforms using LoadRunner.
• Conducted different load tests on different environments to find the performance of different applications using different test scenarios using LoadRunner Controller.
• Interacted with business managers, ETL Developers, and Technical development teams to analyze and document user requirements.

Environment: Windows NT, 2000 server, 2003 server, ASP, JAVA, XML, WinRunner 8.x, LoadRunner 7.8/8.0, Test Director 7.8/8.0, WebSphere 4.x/5.x, Oracle 8.x, 9.x Data Stage, Autosys and UNIX.

Quality Assurance Engineer

Responsibilities:

• Formulation of test plan for the smoke testing, navigational, functional testing at the browser level.
• Analyzing user/business requirements, writing test plans for positive and negative scenarios for functional, GUI and security testing.
• Conducted regression testing using WinRunner, identified software errors and interacted with developers to resolve technical issues.
• WinRunner was used to write test scripts for handling complicated scenarios
• Used the Team Track bug-tracking tool to centralize the bugs and to follow up the bugs status.
• Used LoadRunner tool for Stability and Performance testing of applications under different testing environments.

Environment: Windows NT, 95 & 98, JAVA, JSP, HTML, Netscape 4.x, IE 4.0 and 5.0, WinRunner 6.0, LoadRunner 6.0/6.5, Clear Quest, Web logic Server, UNIX and Sybase.

Mainframe Developer

Responsibilities:

• I participated in Analysis of programs, Impact Analysis, Coding and testing of modified source code.
• Involved Analysis of business requirements and system requirements.
• Analyzed the Business and System Requirements of the application.
• Involved in test cases creation, execution and documentation of test Results.
• I involved in creating and modifying JCLs for compilation of programs.
• Involved in connecting to QMF and execute the SQL queries.

Environment: Windows NT, 95, IBM Mainframe, MVS\ESA, VS-COBOL II, CICS, DB2, CA-2000 and JCL