SUMMARY

• Having 10+ years of experience of onshore - offshore extensive experience with strong concentration and enormous success in ETL Testing and BI testing projects management with client-focused delivery and maintaining a track record of releasing high quality products within proposed schedule and budget
• Perform team monitoring across all phases of assigned testing projects.
• Worked on test plan, Test design, review, test estimation, Track and report on test status for project.
• Have performed BI Testing using Reporting tool such as Cognos.
• Good work experience on SDLC, QA Process and Methodologies such as BlackBox, Whitebox and Greybox testing.
• Have strong experience on SQL and Database testing and ETL/DWH concepts.
• Validated the data based on data transformation rules and also processed data which are sourcing from Flat files and relational databases such as SQL Server 2008, Oracle 10g.
• Good experience on Data warehouse concepts and its different components.
• Well Communicated with Business & Development teams and getting the clear understanding of the Requirements in the given time and prepare the same as document of understanding.
• Work with SME’s, Data Modeler, DBA team frequently on scope of optimization and on continuous improvement of the Test process to ensure quality of data.
• Track and report overall effort and schedule variance on auditing aspects and taking necessary steps to avoid adverse impacts. Facilitate, implement, and optimize PMO processes.
• Have good knowledge on QTP and Load runner Automation tool however I could not get a permit to work and develop automation test scripts directly hence I supported Automation Testing COE team by providing SQL scripts to perform regression testing and actively involved in review of manual test scripts & SQL scripts.
• Managed and Involved in Adhoc, Functional, Regression, DWBI Testing using ODI and Informatica & Web based applications.
• Experienced in software test management tools like Mercury Quality center
• Worked along with Quality Assurance Pre-Sales team to provide necessary information on DWBI.
• Worked as a DWBI resource recruiter in QA Resource management group.
• Have knowledge on Telecom, Health care and Insurance domain
• Ability to learn new Subject Areas and tools quickly.
• Experienced in DW projects ETL testing against DW with Informatica and have in depth working knowledge and understanding on Data Warehousing, Data Validations, OLAP, Oracle and ETL
• Hard working, highly motivated, and reliable individual with a constructive approach to the business, client and to other team members.
• Tremendous Leadership qualities, problem solving and troubleshooting skills, leadership qualities, strong analytical, organizational, multitasking, execution skills and presentation skills with ability to co-ordinate activities and interact with end users in a fast paced team environment and ensure delivery within time frame.
• Very Good verbal and written Communication; Strong experience interacting with clients, end-users, requirement gathering, understanding requirements, analyzing solutions. Mentor, lead team & be a team player with strong aptitude towards interpersonal communication with ability to work in team and independently.

TECHNICAL SKILLS

Testing Tools: QTP 8.0/11.0

Defect reporting tools: QC 9.2/10/ALM, CQ, JIRA, Test Director

Data Bases: SQL Server2005, MS-Access, Oracle 8/9i/10g/11g.

Operating Systems: UNIX, Windows95/98/2000/ME/XP/7.

SQL tools: SQL Developer, SQL Navigator, Toad, PLSQL Developer

Job scheduler: Control M, Autosys

Document control: Share Point, WIKI

Methodologies: Agile, Spiral & Waterfall

Other Tools: Putty, WinScp3, TextPad, EditPlus, Notepad++, Coreftp, Visual SourceSafe

BI tools: Cognos

Domains: Banking, Capital Market

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Team Lead and Senior QA Analyst

Responsibilities:

• Involved in gathering and analyzing Business, System & Data Mapping Requirements & Design Specification document
• Developed complex queries to validate the Data marts
• Performed ETL/DWH and Database testing.
• Validated the business rule by prepare the SQL queries.
• Responsible for documenting functional requirements & supplementary requirements in Quality Center 11.0
• Facilitated formal review meetings with developers to report, demonstrate, prioritize and suggest resolution to issues discovered during testing cycles
• Developed Test Plans, Test Cases Test Scripts, Test Scenarios, Test Data and Traceability Matrix using Quality Center for Functional and Regression Testing.
• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis
• Testing Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Validated the data derived in the target table is adhering to the standards and business rules.
• Played major role in Test Data Creation and Maintenance.
• Verified if there are any downstream impacts in the warehouse
• Preparing the scripts to complete Testing in the UAT and Pre-Prod environments
• Identifying the defects and raising the defects to the DEV team
• Performing row by row testing using the ETL Automation Tool.
• Analyzing the mismatches, issues and raising the concerns.
• Maintaining the updated TCs with the mapping defects in QC.
• Performing TPR testing (Profile Testing, Validation Testing)
• Performing the source testing and Target testing.
• Working closely with the BSAs and the project related hierarchies.
• Coordinated with the whole testing team to ensure total quality control on all deliverables
• Reported to QA Manager and attended weakly team meetings and provided the production support.
• Collecting the task related info from the stake holders and assigning the tasks to the relevant team members.

Environment: ESP, TOAD 12, Oracle 11g, Squirrel, QC 11, Web Services, XML, Pneuron Networks and AWD, Actimize

Confidential, Boston, MA

Senior QA Analyst and Team Lead

Responsibilities:

• Hands on Project meetings, test plan, tech review meetings.
• Analyzed business requirements, system requirements, data mapping requirement specifications
• Involved in test design, peer review and executed the test cases.
• Prepared Test strategy and test plan documents.
• Performed extensive Back-end Testing by developing, modifying, and executing SQL queries for data validation and data verification on database
• Performed ETL and Database testing.
• Tested the extracting, cleansing, transforming, integrating and loading data.
• Running the jobs in UNIX server and monitoring in Autosys.
• Validated the business rule by prepare the SQL queries.
• Verifying the data from multiple sources into Data Warehouse.
• Generated Ad-hoc reports by using Cognos Framework manger.
• Performed Manual Testing of the application Front-End and Functionality.
• Experience on XML files testing.
• Experienced on Master Data Management (MDM)
• Performed Verification, Validation, and Transformations on the Input data
• Reporting the defects in Quality Center ALM.
• Involving in UAT support.
• Handled multiple releases simultaneously.
• Co-ordinate with offshore team on daily basis, provided the technical solutions if needs.
• Involving in Test metrics, defect metrics, DSR, WSR.
• Developed automation scripts using ETL Testing tool for ETL testing

Environment: Java, Autosys, Data stage 8.5, Oracle 11g, UNIX, RQM, CQ, and SQL Navigator, Informatica MDM

Confidential

Senior QA Analyst

Responsibilities:

• Reviewed test assignments, developed test plan and scripts, and conducted tests as assigned.
• Used Quality Center to organize and manage all phases of the software testing process, including planning tests, executing tests, and tracking defects.
• Automated test cases for GUI, Black Box, Boundary, Security and Regression testing using QTP.
• Involved in the automation effort of End-To-End testing using QTP and responsible for the Quality Assurance of this application to complete testing in record time.
• Preparing the Test schedules as per the production job flows and business users plan
• Solid exposure in data profiling, importing/exporting between production and testing environments using SQL scripts
• Ran Gateway edits and involved in analyzing errors for respective applications.
• Validated the fixes and also performed regression testing for the existing functionality and closed the defects in bug tracker tool.
• Worked on trouble ticket process for the releases using Quality Center.
• Performed ETL cycle testing.
• Using Putty to connect to UNIX machine and validated the application log files in UNIX.
• Involved automated activities to improve the existing processes.
• Used all necessary checkpoints of QTP to make reusable scripts for the enhancements.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Responsible for Oracle Table manipulation using SQL
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Analyze the functional requirements, writing test cases for each and every object. Using test specs and test frames created, automated the test cases using Quality Center.

Environment: J2EE, BEA Web logic 9.2, .Net, IIS Server, iNautilus, SQL Server 2005, Quality Center 9.0

Confidential

Test Engineer

Responsibilities:

• Actively participate in review meeting including Functional Spec, Test Plan and Test Case.
• Create and publish Test cases based on available requirements and functional spec.
• Built a library of test cases for regression testing and automated them using Quick Test Professional.
• Performed extensive Backend Testing by developing, modifying, and executing SQL queries for data validation and data verification on database
• Performed extensive manual testing before doing the automation.
• Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD
• Test software prior to its release to ensure it meets company and customer’s expectations.
• Responsible for quality of assigned functions and features.
• Perform repetitive testing procedures.
• Execute test cases based on product test plan
• With training and supervision, correctly analyze test results
• Review product documentation for technical accuracy
• Thoroughly document problems found
• Reproduce and research problems
• Involved in Functional (positive, negative, null value, boundary value), Integration and Regression Testing.
• Used Quality Center to log defects and monitored the defects for successful resolution.
• Prepared and Documented the test scripts for functional and regression testing
• Wrote SQL queries to check the contents of the application tables
• Participated in weekly meetings to discuss the progress and bugs identified the testing

Environment: J2EE, BEA Web logic 9.2, Sun Solaris, Oracle 10g, 9i, XML, XSL, MVC framework

Confidential

Test Engineer

Responsibilities:

• Actively participate in review meeting including Functional Spec, Test Plan and Test Case.
• Create and publish Test cases based on available requirements and functional spec.
• Built a library of test cases for regression testing and automated them using Quick Test Professional.
• Performed extensive Backend Testing by developing, modifying, and executing SQL queries for data validation and data verification on database
• Performed extensive manual testing before doing the automation.
• Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD
• Test software prior to its release to ensure it meets company and customer’s expectations.
• Responsible for quality of assigned functions and features.
• Perform repetitive testing procedures.
• Execute test cases based on product test plan
• With training and supervision, correctly analyze test results
• Review product documentation for technical accuracy
• Thoroughly document problems found
• Reproduce and research problems
• Involved in Functional (positive, negative, null value, boundary value), Integration and Regression Testing.
• Used Quality Center to log defects and monitored the defects for successful resolution.
• Prepared and Documented the test scripts for functional and regression testing
• Wrote SQL statements and SQL queries to check the contents of the application tables
• Participated in weekly meetings to discuss the progress and bugs identified the testing

Environment: J2EE, BEA Web logic 8.0, Sun Solaris, Oracle 9i, XML, XSL, MVC framework

Confidential

Test Engineer

Responsibilities:

• Actively participate in review meeting including Functional Spec, Test Plan and Test Case.
• Create and publish Test cases based on available requirements and functional spec.
• Built a library of test cases for regression testing and automated them using Quick Test Professional.
• Performed extensive Backend Testing by developing, modifying, and executing SQL queries for data validation and data verification on database
• Wrote SQL queries to check the contents of the application tables
• Performed extensive manual testing.
• Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD
• Test software prior to its release to ensure it meets company and customer’s expectations.
• Responsible for quality of assigned functions and features.
• Perform repetitive testing procedures.
• Execute test cases based on product test plan
• With training and supervision, correctly analyze test results
• Review product documentation for technical accuracy
• Thoroughly document problems found
• Reproduce and research problems
• Involved in Functional (positive, negative, null value, boundary value), Integration and Regression Testing.
• Used Quality Center to log defects and monitored the defects for successful resolution.
• Prepared and Documented the test scripts for functional and regression testing
• Participated in weekly meetings to discuss the progress and bugs identified the testing

Environment: J2EE, BEA Web logic 8.0, Sun Solaris, Oracle 9i, XML, XSL, MVC framework

Confidential

Test Engineer

Responsibilities:

• Actively participate in review meeting including Functional Spec, Test Plan and Test Case.
• Create and publish Test cases based on available requirements and functional spec.
• Built a library of test cases for regression testing and automated them using Quick Test Professional.
• Performed extensive manual testing.
• Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD
• Test software prior to its release to ensure it meets company and customer’s expectations.
• Responsible for quality of assigned functions and features.
• Perform repetitive testing procedures.
• Execute test cases based on product test plan
• With training and supervision, correctly analyze test results
• Review product documentation for technical accuracy
• Thoroughly document problems found
• Reproduce and research problems
• Involved in Functional (positive, negative, null value, boundary value), Integration and Regression Testing.
• Prepared and Documented the test scripts for functional and regression testing
• Participated in weekly meetings to discuss the progress and bugs identified the testing

Environment: Java, JSP, Servlet, Web logic 8.0, Oracle9i, Windows-9x