PROFESSIONAL SUMMARY:

• Around eight years of IT experience in Quality Assurance and Data Analysis of various business applications in Client/Server environments, Web - based applications, Data Warehousing solutions, ETL and Business Intelligence solutions.
• Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC).
• Strong experience in writing Test Plans, Test Cases & Test Scripts based on business requirements, rules and system specifications.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification.
• Experience in Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, Configuration testing, Interface testing, Stress and Performance Testing.
• Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects XI, Micro Strategy including dashboards, summary reports, master detailed, drill down and score cards, SSRS report validation and cube testing (SSAS).
• Extensively worked on database query tools such as TOAD, SQL Navigator, Rapid SQL and SQL Plus.
• Extensive experience in writing complex SQL and PL/SQL scripts.
• Experience on working with different models such as star and snowflake and strong working knowledge in dimensional modeling.
• Expertise in test management using HP Quality Center and maintained versioned objects using Rational Clear Case.
• Excellent skills in overall Defect Management/Problem Solving, which includes reporting and tracking defects using HP Quality Center, Rational Clear Quest, Bugzilla, Jira.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors.
• Extensively worked on Batch scheduling tools Autosys, Control-M to run and monitor ETL jobs.
• Involved in preparation of RTMs, Defect Reports and Weekly Status Reports.
• Maintained Good rapport with Client Team, Onsite and Offshore teams and addressed all the QA needs on time.
• Extensively used Informatica IDQ for data validation and data profiling and also working knowledge on Informatica MDM.
• Focused more on automating the test cases and reduce manual effort. Hands on expertise in Test Planning, Design, Execution, Scheduling and Reporting for Web and Mainframe applications. Very good at onsite- offshore coordination skills, and working in Agile.
• Experience on Capital Market, Investment Banking domain
• Ability to provide value add and solutions from QA in a dynamic environment and understanding of trade management cycle.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, Informatica IDQ, 9.x/8.x/7.x, Data stage

QA Tools: HP - Quality Center, ALM, JIRA

DBMS / Query Tools: TOAD, Rapid SQL, SQL Developer, SQL Navigator

Languages: SQL, PL/SQL, Java

Databases: Oracle11/g/10g/9i, SQL Server 2012/2008, Teradata V2R6/V2R5

BI / Reporting Tools: IBM Cognos 8.0, Business Objects BOXI, SSRS

Scheduling Tools: Autosys, Control M

Other Tools: TextPad, CompareIT, PuTTY, WinScp, SnagIT

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

ETL EDI Tester | QA Analyst | BI Tester

Responsibilities:

• Developed the complete Test documents like Test Plan, Test Cases, and Test Scripts by analyzing Business requirement documents, Technical and functional design documents, Use cases.
• Performed Manual Testing as well as Automation Testing for the EDI transactions.
• Worked on the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
• Performed Data Validation by testing the delta/daily and reconcile/data loads.
• Created SQL compare statements to validate Actual results with the Expected Results.
• Tracked and executed the User Acceptance Test Cases (UAT) with respect to the requirements to determine the feature coverage.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Good Understanding of the EDI (Electronic data interchange), Implementation and Knowledge of HIPAA code sets.
• Created Data Driven tests using SOAP UI to test the web services with different inputs.
• Worked on Different Modules like Billings, Membership, Claim and Provider in MMIS application.
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions.
• Developed Test cases as well as Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
• Worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End) and Backend (Database).
• Developed and executed test cases and test scripts, and also worked with the UNIX shell scripts.
• Performed Integration, Regression, Performance and Functional Testing.
• Used HP Quality Center as test management tool.
• Validated the responses of web services by passing various requests in SOAP UI.
• Tested Cognos Reports according to the business requirements.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down reports.
• Analyzed and tested Data Stage jobs with OLTP source data, staging and target data.
• Extensively written SQL to confirm the data transfer from sources to target.
• Tested the PL/SQL procedures, functions, packages according to the requirements.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Verified test results (viewing the log files, querying the database) documenting the defects.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Involved in defects tracking meetings for system integration testing and communicated the issues and escalations with the project manager.
• Involved in testing the functionality of Data Stage jobs.
• Executed ETL mappings through data stage director and monitored status.
• Tested the ETL Data Stage and other ETL Processes (DW Testing).
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Environment: UNIX, Informatica 9.1, Data Stage 8.0, SQL, Clear Case, Clear Quest, RequisitePro, Quality Center, SharePoint, Web Services, SOA, Soap UI, Web Services, MDM, Micro Strategy, XML, Oracle 10g, SQL Server 2005/2008, DB2, PL/SQL, PuTTy, Flat Files, Session Logs, Rally.

Confidential, Buffalo, NY

ETL Tester | UAT/Web QA Analyst | BI Tester

Responsibilities:

• Reviewed Functional Requirement Specifications and created test cases/test scripts based on test scenarios drawn from functional requirements/technical specifications.
• Performed Automated testing using SQL, Quality Center suite of tools.
• Executed Automated scripts daily for functionality testing.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Wrote Test Cases and Performed Manual & Automation Testing like GUI, Functionality, System, Integration, Regression, UAT, Localization Testing, Black Box testing and performed Positive/Negative, testing for system validations for mainframes, web based & Mobile applications.
• Support for User Acceptance Testing (UAT).
• Tested the web-based application manually and SQL for Automation.
• Created complex SQL queries to perform & validate the backend testing of the Application.
• Created and executed SQL queries to validate the data to verify the front end correctly displays data
• Performed Web Service Testing using SOA Test Tool for Functional & Regression Testing
• Used Quality Center (HP ALM 11.0) for maintaining and tracking defects.
• Experience on Capital Market, Investment Management domain
• Wrote several complex SQL queries for data verification, data validation, data quality checks.
• Extensive querying using Toad to run SQL queries and monitor quality & integrity of data.
• Involved in preparation of System Test Results after Test case execution.
• Worked with data base validation, constraints validation, record counts, source to target validation, random sampling and error processing.
• Performed data validation, accuracy of calculated fields, Accuracy of the data shown, Selection criteria shown, Accuracy of subtotals for the Cognos reports.
• Validated the front end reporting components created using Cognos Reports as well as performed back end testing, making sure that the correct data for a specific report are being pulled out from the Data Warehouse.
• Performed Sanity, Functional, GUI, Unit, Integration and Regression Testing of the Application at different levels
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Involved in O&M mode of project post deployment and resolving deployment issues.
• Tested data migration to ensure that integrity of data was not compromised.
• Used Analytix as a data mapping requirements management tool.
• Extensively used Informatica Workflow to run workflows / mappings and monitored the session logs in Informatica Workflow Monitor.
• Responsible in testing Initial and daily loads of ETL jobs, Involved in Black box testing and White box testing
• Before the Load is accepted to test, have performed the smoke or shake-out test.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Extensively used Informatica IDQ for data validation and data profiling.
• Used Informatica IDQ to perform frequency analysis of data, and cleanse the data,
• Performed data analysis of addresses and their postal codes provided and cleansed them wherever necessary using IDQ.
• Worked in the role of data analyst in mapping and scrubbing sensitive data within the application.
• Verified Informatica session logs to identify the errors occurred during the ETL execution.
• Done regression testing after the defect fixed and change made in Functional or Business Requirement Document.
• Actively participated in stand up meetings, story reviews, and retrospectives of the Agile process.

Environment: Informatica Power center 9.5, IDQ, Oracle 11g, UFT, HP ALM(Quality Center 11.0), JIRA, UAT, SOA Webservices, SQL, PL/SQL, Cognos, SQL Server 2008, T-SQL, SSRS, SharePoint, Jira, UNIX, BMC Remedy.

Confidential, Pittsburgh, PA

ETL Tester | BI Tester

Responsibilities:

• Developed and maintained Test Plans, Test Cases and Test Scripts to ensure the development and delivery of software applications.
• Planned, managed, and executed tests in accordance with Test Strategy.
• Accomplished testing of Reporting System at various stages of Database Migration.
• Validated source and target Tables, Data Structures, Data, Count, duplicates, Lookups, joins, Mapping/ETL rules.
• Reviewed Test Cases and other testing artifacts created by other team members for completeness and accuracy.
• Developed and executed test strategies and plans for various testing types and levels.
• Participated in all phases of SDLC starting from Analysis to Delivery of the projects.
• Worked in all cycles of STLC: Defect Tracing, Defect Raising, Fixing, Retesting, Closing, and Deferring.
• Used Informatica IDQ for data validation and data profiling.
• Verified and maintained Data Quality, Integrity, Data Completeness, ETL rules, Business Logic.
• Conducted Manual/Functional testing such as: Smoke, Integration, Regression, End to End Testing.
• Coordinated testing efforts, responsible for test deliverables, status reporting to management, Issue Escalations.
• Validated the ETL and PL/SQL batch jobs scheduled in Autosys.
• Tested data in Staging area, Operational data store, Base Layer, and BI layer.
• Developed Test cases in a form of SQL query and stored procedures and triggers to verify logic for standard and Custom Reporting system.
• Managed the test cases, scripts and monitored the bug using Quality Center.
• Created/Modified SSIS packages to support future enhancements.
• Created SSIS packages to clean and load data to data warehouse.
• Used JIRA for Test management and task management.
• Worked in accordance to QA methodology, project schedule and time lines.
• Written Complex SQL scripts and analyzed them for effective Data validation and Data Integration purposes during ETL/Backend Testing.
• Tested the presentation layers of the application by cross browser behavior and browser logic to ensure positive experience for end user.
• Validated data moving from source to target using Informatica Data Validation Option.
• Validated the initial and incremental loads.
• Worked on application integration testing in SOA Architecture and validated the SOAP based web services.
• Validated several OBIEE ad hoc reports.
• Used Informatica workflow manager to run the workflows and workflow monitor to verify the session logs.
• Identified the root cause for errors using Informatica workflow designer.
• Validated SSRS packages according to report specification documents.
• Participated in Story reviews, Daily agile scrum meeting, and retrospectives to discuss about the project.
• Validated the OBIEE reports for data quality and lay out of the reports.
• Involved in onshore offshore coordination of projects.

Environment: Informatica 9.1, DVO, IDQ, Oracle 11g, OBIEE reports, SQL, PL/SQL, Toad, SQL Server 2008 R2, SSIS, Quality Center, .Net, UNIX, Shell Scripting, DB2, JIRA, SharePoint, Web Services, SOA, Soap UI

Confidential, Eagan, MN

ETL Tester / UAT Tester

Responsibilities:

• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing (SSAS) and Report testing (SSRS).
• Worked with business analysts in preparing test plan and test cases for the mapping developed through the ETL tool from the requirements.
• Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
• Analyzed the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
• Worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End) and Backend (Database).
• Developed and executed test cases and test scripts, performed Integration, Regression, Performance and Functional Testing.
• Performed Manual Testing as well as Automation Testing for the EDI transactions.
• Conducted GAP analysis and filling gap according to the format set by HIPAA.
• Worked on the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
• Good Understanding of the EDI (Electronic data interchange), Implementation and Knowledge of HIPAA code sets.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands, and worked with the UNIX shell scripts.
• Validated the responses of web services by passing various requests in SOAP UI, and used HP Quality Center as test management tool.
• Tested Cognos Reports according to the business requirements.
• Exclusively used Analysis Studio and Query Studio to test the Cognos Reports.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down reports.
• Analyzed and tested Data Stage jobs with OLTP source data, staging and target data.
• Extensively written SQL to confirm the data transfer from sources to target.
• Tested the PL/SQL procedures, functions, packages according to the requirements.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Verified test results (viewing the log files, querying the database) documenting the defects.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Involved in defects tracking meetings for system integration testing and communicated the issues and escalations with the project manager.
• Involved in testing the functionality of Data Stage jobs.
• Executed ETL mappings through data stage director and monitored status.
• Tested the ETL Data Stage and other ETL Processes (DW Testing).
• Prepared Test Scenarios by creating Mock data based on the different test cases.

Environment: Data Stage 8.0, SQL, Cognos 8.0, RequisitePro, Quality Center, SharePoint, Web Services, Soap UI, XML, Oracle 10g, SQL Server 2005/2008, DB2, PL/SQL, UNIX

Confidential, Chicago, IL

ETL Tester / QA Analyst

Responsibilities:

• Participated in various meeting like project kick-off, project planning, weekly & monthly client status meetings,
• Extensively involved in writing and reviewing the test scripts.
• Experienced in gathering Functional Requirements, Business Requirements and Design Documents.
• Developed detailed Test Cases based on the Functional Requirements and Design Documents.
• Identified the test data to execute the test cases.
• Wrote complex SQL Queries in Teradata using mapping documents and PDM (Physical Data Model)
• Reported bugs and tracked defects using Quality Center.
• Developed the Test Scripts and Test Cases in Quality Center.
• Error handling and performance tuning in Teradata queries and utilities.
• Data reconciliation in various source systems and in Teradata.
• Performed Functionality, Negative, Security, GUI, Integration, System and Database testing.
• Involved in testing the Data stage jobs, by validating whether the mapping adhere to the development standards and naming conventions; whether the mapping do what the technical design says it should do; whether the mapping work correctly in relation to other processes in your data logistical flow.
• Focused more on automating the test cases and reduce manual effort. Hands on expertise in Test Planning, Design, Execution, Scheduling and Reporting for Web and Mainframe applications. Very good at onsite- offshore coordination skills.
• Experience on Capital Market, Investment Management domain
• Validated OBIEE Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Tested Cascading Prompts and Multi-Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Validated different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Extensively worked on RPD and Dashboards.
• Validated Query Prompts as, Cascading Prompts, Calculations, Conditions & Filters
• Experienced using database query and integration tools such as TOAD, SQL plus etc.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Extensively used SQL to verify and validate the data loaded into Target
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Preparing test data and supporting the QA test environments

Environment: Data Stage, Oracle, Quality Center, SQL Server 2008, SQL Developer, Teradata, OBIEE, XML, PL/SQL, SQL, WinSCP, Putty, TFS, UNIX, Toad, SharePoint, OBIEE, SSRS.

Confidential, Detroit, MI

BI Reports/Manual QA Tester

Responsibilities:

• Attended meetings with the Business Team, and Build Teams to gather the information about the project and the design methodology and the testing requirements
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Participate in weekly meeting with the management team and walkthroughs.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentations.
• Performed Sanity testing, Security testing, black box and web testing.
• Created and executed SQL queries in ORACLE and MS SQL server
• Performed tests on various browsers.
• Validated Business Objects reports for cosmetics and data.
• Performed testing Web based applications (developed in JAVA, .NET)
• Involved in executing the Regression testing on new Builds
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Managed test environments and schedules
• Trained the users for the User Acceptance Testing(UAT) and explained about each link, tab and search functionalities to the users
• Tracked bugs using QC and generated the defect reports for review by the client and the management teams.
• Generated testing reports and metrics, trend graphs according to the test plan.

Environment: MS SQL Server 200, Oracle (SQL, PL/SQL), TOAD, MS Access, Citrix Server, Business Objects, XML, TFS, J2EE .

Confidential, Herndon, VA

Backend Manual Tester/Data Analyst

Responsibilities:

• Developed Test cases based on functional requirements, general requirements and system specifications.
• Performed the data analysis and data mapping and designed and documented the conversion documents.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
• Supported go-live and post-go-live, which included code/process tracing for debugging and performance-tuning.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Participated in developing the file management and ftp process for transmitting the files, also scheduled the daily batch process.
• Worked on issues with migration from development to testing.
• Developed Requirement Traceability Matrix (RTM) by matching the requirements and test cases.
• Performed Regression testing/system integration/integration testing/ System Integration testing/ Smoke testing.
• Used Test Director for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Manually ran the test scripts in Test Director and documented the results.

Environment: Oracle, Toad, SQL, PL/SQL, Cognos, SQL Server 2000, SQL Navigator, Test Director, Windows, UNIX AIX, VI Editor, Putty