SUMMARY

• Over 10 years of IT experience in Manual and Automated testing on Cloud, Web Based, Client - Server, Data warehouse applications.
• Commendable experience with Test Plan, Test Strategy, Test case preparation, Test execution and Test results analyses.
• Strong Experience in data warehouse architecture, Data Modeling, ETL and reporting tools for Data Warehousing.
• Generate Requirement Traceability Matrix (RTM) to trace requirements till implementation.
• Good Experience in Test Life Cycle and Test Methodology primarily on Agile Methodology.
• Excellent knowledge of Software development and testing life cycles, SQA methodology and test process documentation and End user training.
• Possess strong interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management.
• Coordinated with Development, Integration, Configuration Management, Testing, Training and Production teams for Repository build and deployment
• Experience in preparing Analysis Documents and User Acceptance Documents.
• Experience in on shore and off shore model projects.
• Strong debugging and problem-solving skills with excellent understanding of system development methodologies, techniques and tools.
• Prepare backend test jobs, setting up in scheduler, execution of batch jobs and analyzing the job logs and test results.
• Preparing JIL files and force starting Autosys scheduled jobs.
• Strong experience on jobs schedulers on different technical environments and preparing job nets by fulfilling successor and predecessor.
• Wealth experience in Front End and Back End testing.
• Expert in writing complex SQLs and execute them in oracle for validating and analyzing system generated output in backend and Front End.
• Experience in Cross Browser testing
• Tested Web Services /XML / SOAP services using SoapUI tool
• Programming skills using SQL, PL/SQL and Shell Scripts.
• Knowledge of Automated testing using QTP
• Hands on development experience with C++
• Hands on development experience with Informatica Designer, Workflow Manager and Workflow Monitor & Mappings.
• Experience in Core Java, development by applying different concepts like OOPS concepts, Collections, String s, Exception handling, Multithreading, etc.
• Have knowledge on various CLOUD supported authentication systems namely RDS, S3, Postgrep tool .
• Experience in HTML, HTTP, JavaScript, XML.
• Experience in testing Web Services-SOA architecture, XML transactions, SOAP, HTTP, WSDL, and REST using various tools like SOAP UI.
• Modify the existing regression framework as per few functionalities and executed the scripts by using Selenium

TECHNICAL SKILLS

Operating Systems: UNIX, LINUX, Windows NT and MS-DOS

Languages/Tools: Java, ASP .Net, SOAP, UDDI, TCP/IP, HTTP, XML, JMS, WSDL, VBA, PL/SQL, COM/DCOM Informatica PowerCenter 8.6/7.1//6.1/6.2/5.2 , PowerMart 8.6/7.1/6.2/6.1/5.2 , SQL, PL/SQL, SQL Loader, Unix Shell Scripts, Toad7.1.

DBMS: ORACLE, MS Access, MS SQL Server, UDB, SYBASE, DB2

Test Tools Used: QC, QTP, Clear Quest, Test Director, Load Runner, DOORs, Rapid SQL

PROFESSIONAL EXPERIENCE

ETL Developer/Tester

Confidential, VA

Responsibilities:

• Participated requirement review sessions during the Sprint plan phase and understands the requirements conceptually mapping those requirements with future working software product.
• Ensure there are no incompatibilities within requirements and raised clarifications to IA / Product Owner for those requirements are not clear.
• Create the testing process for the project level and review with project manager.
• Create Test Plan and review with team and incorporated the changes requested by team and sign off the test plan document.
• Create less complexity mappings like error handling and loading data to Initial data hub (Landing Area)
• Review the code and logic with Technical lead and made changes suggested by reviewer.
• Create test data that matches business rules.
• Creating Test cases in Excel sheet based on requirements and linked those test cases to requirements.
• Run the test cases review meeting session for testing team, business team and Development Team.
• Incorporated review comments suggested by stake holders in order to maintain good test coverage.
• Creating Test Data in Database as per business transformations by using DDL statements.
• Generate the execution test cases and defects and calculate the percentage of completion and provide the daily status on every Morning in scrum meetings.
• Validate the data at every stage against the business rules.
• Validate the dash boards created by using BI tool.
• Validating the Report headers, column names, color and font.
• Validated the values against database.
• Review the test Results before sending to business review and suggest modifications if anything needed.
• Reported the defects and maintains the defect management by using the JIRA.
• Document the Test results in share point.

Environment: Informatica, BI, Putty, WinSCP, Jira, SQL developer 19.2.1 and backend as Oracle 12c

Test Designer

Confidential, VA

Responsibilities:

• Participated requirement review sessions during the Sprint plan phase and understands the requirements conceptually mapping those requirements with future working software product.
• Ensure there are no incompatibilities within requirements and raised clarifications to IA / Product Owner for those requirements are not clear.
• Create test data that matches business rules.
• Generate the execution test cases and defects and calculate the percentage of completion and provide the daily status on every Morning in scrum meetings.
• Review the test Results before sending to business review and suggest modifications if anything needed.
• Creating Test cases in Excel sheet based on requirements and linked those test cases to requirements.
• Run the test cases review meeting session for testing team, business team and Development Team.
• Incorporated review comments suggested by stake holders to maintain good test coverage.
• Creating Test Data in Database as per business transformations by using DDL statements.
• Deployed the code to QA environment by Providing EAR Artifact through Jenkins.
• Select the parameters to deploy the code to QA environment by using Jenkins.
• Verify the deployment, it is success then run the smoke test in QA environment and share the results with the team.
• Executing the Job through EJS job container manually by using force start action “Execute”.
• Validating Log in EJS and then log into Putty and verify whether reports generated or not?
• Validating the Report headers, column names, color, and font.
• Validated the values against database.
• Reported the defects and maintains the defect management by using the JIRA.
• Document the Test results in share point.

Environment: ODI, OBIEE, Putty, WinSCP, Rally, Salesfore, Oracle SQL developer 19.2.1, EJS (Enterprise Job Scheduler), Jenkins, Selenium IDE, Selenium WebDriver, Eclipse, Maven and backend as Oracle 12c

Sr Software Quality Engineer

Confidential, Herndon,VA

Responsibilities:

• Participated requirement review sessions during the Sprint plan phase and understands the requirements conceptually mapping those requirements with future working software product.
• Ensure there are no incompatibilities within requirements and raised clarifications to IA / Product Owner for those requirements are not clear.
• Review test cases provided by the offshore team and generated RTM to make sure all requirements covered or not. Then suggest the modifications.
• Help the team to create test data that matches business rules.
• Generate the execution test cases and defects and calculate the percentage of completion and provide the daily status on every Moring in scrum meetings.
• Review the test Results before sending to business review and suggest modifications if anything needed.
• Motivate the team with collecting appreciation emails from business and share with them.
• Creating Test cases in Excel sheet based on requirements and linked those test cases to requirements.
• Run the test cases review meeting session for testing team, business team and Development Team.
• Incorporated review comments suggested by stake holders to maintain good test coverage.
• Creating Test Data in Database as per business transformations by using DDL statements.
• Validating ETL Initial loads, Truncate and reload as well as incremental loads.
• Validate the source, target counts, duplicate check, and data field to field validations.
• Executing the reports through BIEE Tool
• Validating the reports both GUI and data validations against data base
• Validating the reports in Lower environments like TESDW1/7 and PERF (Image of production data) and higher environment K12PODW (Production).
• Validating the breadcrumbs, filters, and global filters
• Validated application across web browsers.
• Validated data against data base for all possible combinations of filters and global filters.
• Selected the Test Cases to be automated and performed functional testing of the front-end using Selenium (IDE and Web Driver) & Modified the existing Keyword Driven framework and executed.
• Reported the defects and maintains the defect management by using the JIRA.
• Document the Test results in share point.

Environment: ODI, OBIEE, Putty, WinSCP, JIRA and, HP ALM, Software Change Management Workbench 12.0, windows XP, Microsoft Visio, Oracle 12c /Exadata SQL Server 2008, VMware, Selenium IDE,, Selenium WebDriver, Eclipse, Maven

Back End Report Tester

Confidential, Reston, VA

Responsibilities:

• Access Individual Student Scores, Electronic Score Reports and registration/score rosters
• View a dashboard where they can analyze scores using a predefined set of student demographics
• Run Insight analysis reports which allow schools, districts and states to take a detailed look at students' skills by providing an analysis of aggregate performance on each test question and skill
• Participated requirement review sessions during the Sprint plan phase and understands the requirements conceptually mapping those requirements with future working software product.
• Check reports available in cloud and export reports to the desktop for validation against base line reports.
• Ensure there are no incompatibilities within requirements and raised clarifications to IA / Product Owner for those requirements are not clear.
• Creating Test cases in Excel sheet based on requirements and linked those test cases to requirements.
• Run the test cases review meeting session for testing team, business team and Development Team.
• Incorporated review comments suggested by stake holders to maintain good test coverage.
• Generated the RTM manually with the help of Test Lead.
• Creating Test Data in Database as per business transformations by using DDL statements.
• Executing the reports through COGNOS portal.
• Validating the reports both GUI and data validations against data base
• Validating the reports in Lower environments like PALM and Apple (Image of production data) and higher environment Pine (Production).
• Validating the breadcrumbs, filters, and global filters
• Validated application across web browsers.
• Validated data against data base for all possible combinations of filters and global filters.
• Reported the defects and maintains the defect management by using the JIRA.
• Selected the Test Cases to be automated and performed functional testing of the front-end using Selenium (IDE and Web Driver) & Modified the existing Keyword Driven framework and executed.
• Created LoadRunner scenarios and scheduled the Virtual Users to generate realistic load on the server using LoadRunner (Load generator machine)
• Document the Test results in share point.
• Supported End user

Environment: Cognos, Cloud, Java, Putty, WinSCP, JIRA and HP ALM, Software Change Management Workbench 12.0, windows XP, Microsoft Visio, Oracle 12c TOAD, LoadRunner

Back End ETL Tester

Confidential, Reston, VA

Responsibilities:

• Participated requirement review sessions during the planning phase and understands the requirements conceptually mapping those requirements with future working software product.
• Ensure there are no incompatibilities within requirements and raised clarifications to BA team for those requirements are not clear.
• Creating Test cases in Quality Center based on requirements and linked those test cases to requirements.
• Run the test cases review meeting session for testing team, business team and Development Team.
• Incorporated review comments suggested by stake holders in order to maintain good test coverage.
• Generated the RTM by using clear case tool with the help of Test Lead.
• Creating Test Data in XML format as per business transformations by using XML SPY Tool.
• Creating Securities, Different types of Buy and SELL Trades by using the mock up data.
• Executing the Workflows by using AUTOSYS Job scheduler.
• Validating the Session logs and verifying the Counts.
• Validating the data at Staging tables and then Target tables (Business rules applied).
• Tested Web Services, Validated Request and Response XML, SOAP Calls, Restful calls and WSDL using SOAPUI tool.
• Validated End Points in WSDL File, XML Schema.
• Added data related assertions to validate response XML in Web Services.
• Validating the CSV files generated by workflows in the SCD Server.
• Validating the data in different screens in SCD (COTS Product)
• Validating the SCD Database (Target) as per business rules.
• Reported the defects and maintains the defect management by using the Clear Quest tool.
• Document the Test results and executing the test cases in Quality center.

Environment: HP Quality Center 10.0, TOAD, Clear Quest, UNIX, AUTOSYS, XML ALTOVA, SCD (COTS Product) Informatica, Java, TIBCO, SoapUI, Web Services.

Back End Tester

Confidential, McLean, VA

Responsibilities:

• Conducted the performance testing (Execution of jobs) by Focusing on lessons learned from Pilot and previous waves to improve efficiency and reduce execution time.
• Involved in risk Based Testing Approach, by testing the identified break points introduced by each upgrade. E.g. Testing of SOX key controls validated.
• Verified the system whether a high level of confidence is achieved for each upgrade and performance is scaled up to handle large volumes.
• Set up the meetings with Bio and Application SME’s for identifying the testing scope.
• Created Test Strategy and Test plan and Review with business team for sign off
• Created both functional and automated test cases in Quality center and QTP.
• Executed the test cases, test scripts and validated results by comparing the actual and expected results.
• Extensively used Quality center to log defects and to track defects until resolution.
• Performed the SPE (Sybase Password Encryption) Verification for Web method and Web-logic Software upgrades.
• Automatically executed the batch jobs by using jobs scheduler and documented the results.
• Documented the test results, reviewed the testing artifacts with businesses team for sign off.
• Provided technical help to team members.

Back End Tester

Confidential, McLean, VA

Responsibilities:

• Created test cases, test scenarios and test scripts based on requirements.
• Test cases have been written in Quality Center and linked to requirements to generate RTM (Requirements Traceability Matrix).
• Created a framework that reads data from source systems to generate the expected results by applying business transformation rules.
• Executed the test cases, test scripts and validated results by comparing the actual and expected results.
• Extensively used Clear Quest to log defects and to track defects until resolution.
• Interacted with the system analysts and developers to discuss the requirements details and testing issues.
• Performed Functional testing.
• Triggered events in MPS database by inserting a new record/updating an existing record in database.
• Verified the data persistence in OEM (Oracle Enterprise Management) through workflow or BPEL (Business Process Events Flow).
• Used SOAPUI to post the message on to the topic for event notifications.
• Tested Web Services, Validated Request and Response XML, SOAP Calls, Restful calls and WSDL using SOAPUI tool.
• Validated End Points in WSDL File, XML Schema.
• Added data related assertions to validate response XML in Web Services.
• Created temp tables to store expected and actual results.
• Extracted data from DSI to create actual results data using X-query.
• Created deal, facility, circle or trade and outstanding objects in LoanIQ tool GUI.
• Participated in daily status meetings to update status of testing to lead and project manager. Also, provided a daily testing project status report the management team.
• Documented test results and saved all the project related documents in the LAN.
• Provided support to team members, if they have any questions.

Environment: HP Quality Center 1.0, Rapid SQL, SQL Developer, Oracle Enterprise Management (OEM), Clear Quest, UNIX, SoapUI, Web Services., Windows 2000/XP

Informatica Developer

Confidential

Responsibilities:

• Studied the project requirement and designed the project.
• Created tables, views, synonyms and sequences
• Created Control files.
• Used SQL Loader for data loading.
• Analyzing Packages, Procedures.
• Tested all the new and modified program units.

Environment: Oracle, UNIX, SQL loader.

DW Developer

Confidential

Responsibilities:

• Created Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.
• Used aggregator, lookup, expression, stored procedure, filters in the mapping.
• Used Sequence Generator Transformation.
• Used ETL to extract and load data from Oracle, SQL Server, and flat files to Oracle.
• Involved in writing lot of Functions, Stored Procedures.
• Created various transformations such as Update Strategy, Look Up, Joiner, Filter and Router Transformations.
• Designing, Creating and testing of Cognos Reports.

Environment: Informatica, Cognos, Oracle 8i

Informatica Developer

Confidential

Responsibilities:

• Worked on Informatica client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Used Informatica to extract and load data from Oracle database and flat files to Oracle tables.
• Created various mappings using Designer which include Expression, Router, Aggregator, Stored Procedure, Update strategy and Look-up Transformations.
• Created Mapplets using Mapplet Designer to reuse in different mappings.
• Created FTP connections, database connections for the sources and targets.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Unit Test case preparation and test data.

Environment: Data warehousing (Informatica, Oracle 8i, UNIX)