PROFESSIONAL SUMMARY:

• Over 7+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Client - Server and Legacy Mainframe applications and Data Warehousing.
• Worked with IT Operations to ensure test environment readiness.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and validation of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Well versed in GUI application testing, Database testing and Front-end testing.
• Have knowledge on the web services
• Experience in Retail, Financial, Banking, Brokerage, and Securities industries.
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in testing Business Intelligence reports generated by various BI Tools like OBIEE, Cognos and Business Objects.
• Moderate experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Moderate experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Back End Testing experience by writing and executing SQL Queries.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management. f latest trends in Quality Assurance processes and methodologies.
• Good experience in Hyperion Sybase 9.2 Reports and dashboard testing.
• Excellent analytical, multi-tasking, problem-solving, time-management & communication skills with particular emphasis on clearly communicating & documenting detailed Test Requirements & Tests

TECHNICAL SKILLS:

Hive,: Datastage8.0,7.X/6.X (Manager, Designer, Director, Administrator), Ab Initio CO>Op 2.15, GDE 1.15, Informatica 8.6/8.1/7.1/6.1 , SSIS,SSRS,SSAS Data Stage 8.x

Rally, OBIEE,: Hyperion Interactive Reporting 9.3, Business Objects XIR 2/6.5.1/6.0/5.1. x/4.0 (Supervisor, Designer, Reporter), Cognos, Web Intelligence

HP ALM 11.0:, Test Director, HP Quality Center10, Rational Clear Quest, HP QTP 9.2

Programming: UNIX Shell Scripting

Environment: Hadoop, UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Novell NetWare, Win 3.x/95/98, NT 4.0

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, NY

QA /ETL SQL Test Analyst

Responsibilities:

• Developed User stories, Test strategy & test plan and reviewed with all stakeholders, Development team, Infrastructure team and other teams.
• Involved in reviewing and analyzing the functional requirement documents with the Business Analyst
• Execute the UNIX Shell Scripts to Know the Backend Batch Jobs Status.
• Tested Facets for Group Information, Enrolling Subscribers, adding members, Related Entities, Class/Plan definition, Premium Rate Tables and all.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Performed database testing by using SQL queries
• Planned and worked flexibly to meet the dead lines.
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica.
• Validated the HIPPA standard ICD 9-CM code work correctly with ICD10-CM codes based on the business rules
• Tested Cognos reports functionality extensively.
• Reviewed Business Requirements (BRD) and System Requirements
• Performed Black-box testing and supported in White Box Testing
• Created test cases to cover all the requirements
• Used PERL scripts for data parsing, text processing, and database connectivity and to validate the data.
• Performed manual testing, functional testing and usability testing
• Responsible for Smoke Testing for the Build on Daily basis.
• Participated in the Requirement understanding discussion with Business and IT teams.
• Worked in Facets Subscriber/Member Enrollment Application system
• Responsible for documenting the functional requirements in Quality Center within Requirement module and providing linkage to the respective Test Scripts.
• Experienced in writing test cases, test scripts, test plans and execution of test cases Claims data reporting(Cognos) using HP Quality Center
• Worked with various EDI transactions like 834,835,837,276,277in accordance with HIPPA standards
• Used PERL for automating all the types of modules at a time
• Tested the Dashboard reports using Cognos Report Studio and Metric Studio.
• Prepared high level System Test Scenarios and Test Conditions for various functional segments. Worked on the Test schedules, Test estimates for the Test Script development and execution.
• Written Test Cases for various functional segments based on the Detailed Business Requirement (DBR) documents, Detailed Technical Design (DTD) documents and Use Cases in Quality Center.
• Responsible for Test Case Design, Test Scenarios walkthrough with Business and IT teams as part of review process and receive the Signoff approvals.
• Identified the scope of the system that will be modified by the ICD-10 project to accommodate ICD-10 code and /or downstream impacts steaming from ICD-10 codes
• Extensively worked on FACETS claims processing system and worked on its different applications like enroll subscriber/member, Claim processing, Provider and Billing.
• Tested several business reports/Claims Reports on Claims data including Score Cards, KPI's, Summarized, Master-Detailed and Drill Down reports developed by Cognos
• Worked on Informatica Workflow monitor to run workflows.
• Strong Facets member, provider, claims and pricing validations and developed multiple SQL complex join queries.
• Extensively used Rally for tracking & creating user stories, defect logging.
• Daily scrum calls & reported progress to Scrum master & other team mates.

Environment: Hadoop, Hive, Rally, Toad for SQL Server, Agile, Facets, PERL, Informatica, Cognos, SQL, PL/SQL, UNIX, XML, XML Spy, Quality Center 11/HP-ALM, Teradata, Teradata SQL Assistant, QTP.

Confidential, Chicago, IL

QA Test Analyst

Responsibilities:

• Prepared Test Plan from the Business Requirements and Functional Specification.
• Involved in reviewing and analyzing the functional requirement documents with the Business Analyst & stakeholders.
• Developed test strategy & test plan and reviewed with all stakeholders, Development team, Infrastructure team and other teams.
• Testing of Business Objects and Reports which Includes, Database Connectivity, Tested objects in the Universe to ensure the correct mapping of the objects, tested the Universe Structure to ensure that tables are properly uploaded. Tested the aggregate Universe to ensure the query is pulling correct level of Aggregation.
• Involved in Analysis and Implementation of Extranet portal to implement Confidential Management System of HIPAA/EDI
• Tested the configuration of Medicaid Claims and membership Sub-systems in Facets
• Execute the UNIX Shell Scripts to Know the Backend Batch Jobs Status.
• Extensively worked Agile Scrum methodologies of the application and involved in System Integration testing, Smoke, Functional, Regression and User Acceptance Testing.
• Created test design by using Quality Center test Management tool and tracked the defects and reported the defects to the concerned persons
• Performed database testing by using SQL queries
• Extensively used Quick Test Pro for regression testing for automation of multiple modules in the environments.
• Responsible for integrating with Facets .Designing test scripts for testing of Claims in Development, Integration and production environment.
• Worked with PERL for file manipulations, text processing, data parsing and Converted SQL queries results into PERL variable
• Coordinate & schedule the defect triage meetings with the development team and business to discuss about the open issues reported using ALM/ Quality Center.
• Set up Requirements Traceability Matrix with all the testable Business scenarios.
• Created different Traceability views to maintain the Traceability of the requirements and test cases
• Frequently updated the requirements and defect status as per the current status of the testing project.
• Designed Connection Models for receiving EDI Documents and Validating for known source.
• Planned and worked flexibly to meet the dead lines.
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Strong Knowledge and working experience on ICD-9 and ICD-10 conversion and expertise in forward and backward mapping
• Initiated and developed new techniques to improve the testing process and improve the performance of the test scripts.
• Used Facets to provide seamless transactions between the provider, members and the plan.
• Analyzed the change detection process on Facets database tables to capture the daily changes done by Users through Online Facets Application
• Developed SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Tested ad hoc and canned reports for Business objects.
• Coordinated execution of System Testing, regression and integration testing with multiple departments.
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.
• Performed Regression testing of the fixed issues in the new build until no new issues were identified.
• Converted SQL queries results into PERL variable
• Wrote and ran Unix Scripts for batch jobs.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Worked on Medical Network Configuration under Network module in Facets to gather agreement information while processing claims like allowed amount and contract terms and Pricing details to process claims and for successful adjudication.
• Developed data quality test plans and manually executed ETL and BI test cases.
• Involved in data warehouse testing by checking ETL procedures/mappings
• Worked in AGILE Methodology.
• Designed and kept track of Requirement Traceability Matrix in Quality Center and test cases creation, loading and writing Test Plan and executing Test Cases and printing status report for the team meetings and defect tracking
• Functional and Technical understanding of the Claims domain data to validate the data obtained from the Confidential insurance members.
• Run batch jobs for loading database tables from flat files using SQL*Loader
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata

Environment: ALM/HP Quality Center 11, Oracle, Informatica, Facets, PERL, Business Objects, Rational Requisite Pro, SQL, PLSQL, UNIX, SQL Server 2008, XML, Agile

Confidential, Bloomington, IL

QA Analyst

Responsibilities:

• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Experience with onsite -offshore Co-ordination.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Created resource forecast, ramp up plans, & resource utilization plans.
• This work will include loading of historical data onto the Teradata platform, as well as reference data and metadata.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Tested Business Objects reports and Web Intelligence reports.
• Co-ordinate with offshore counterparts to make sure they have the knowledge of the Business requirements and mentored for Test preparation.
• Tested the Informatica Mappings to load data from Source systems to ODS and then to Data Mart
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.
• Based on the business requirements, created Test Plan, Test Cases, and Test Script documents to test the Business Objects reports.
• Created Batch processes using Fast load, BTEQ, Unix Shell and Teradata SQL to transfer, cleanup and summarize data.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Experienced in translating requirements into tasks, milestones, and timelines to ensure project completion in accordance with specified deliverables.
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in Sql Server Database.
• Responsible for Creating and maintaining the development of excel, Access and power point
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Responsible for scheduling and automating jobs to be run in a batch process.
• Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Used Rational Clear Case for version controlling.
• Involved with ETL test data creation for all the ETL mapping rules.
• Preparing and supporting the QA and UAT test environments.
• Tested different detail, summary reports and on demand reports.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Informatica, SQL Server 2008, T-SQL,QTP, Business Objects, SQL, PL/SQL, Teradata V2R6, SSAS, TOAD 9.2, Oracle 9.2, XML, XML Spy 2008, HP Quality Centre 10.0, Autosys, BI Reports, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix Shell Scripting, Windows NT/XP//2003

Confidential, Chicago, IL

ETL/QA Test Analyst

Responsibilities:

• Interacting with Business Analysts and Development teams to understand the business requirements and giving the estimates from testing prospectus
• Test plan preparation, preparing daily status reports and defect reports.
• Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
• Create custom built reports from the Control-M batch server.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target
• Involved in writing and executing the test cases and involved in Defect reporting and verification.
• Involved in identifying the cause of Defect and reporting the same to developers.
• Validating the data between Oracle Tables and SQL Server Tables by using SQL Statements.
• Testing the data present in fact tables and dimensions tables.
• Loaded data and metadata from flat files through Hyperion Application Link to the Planning application using planning, flat file, and other adapters
• As a part of team, involved in carrying out disaster recovery procedures on Hyperion Testing
• Involved in HUT (Hard unit testing), SIT (System Integration Testing) and WIL (Week in Live Testing) Testing.
• Responsible for performance testing script development and analysis reporting for Hyperion Solutions applications as well as testing methodologies.
• Tested all the entities like customer records, payment records have been loaded target database according to its own table structure during the migration process.
• Tested database integrity referential integrity and constrains during the database migration testing process
• Attending defect triage meetings.
• Control-M agent accounts, and trouble-shooting Control-M production errors and coordinating with vendor when necessary.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Used reusable actions with utilizing the flexible functionalities in Quick Test professional
• Configured Quick Test Professional with Quality center.
• Documenting test procedures, test plans, test cases and test results.
• Wrote complex SQL syntax using case, having, connect by etc

Environment: Informatica 8.6.1, HP Quality Center 9.2,HP QTP 9.2,Oracle 10g, Hyperion, SQL, PL/SQL, SSIS,SQL Server 2008, Quality Center 9.0,, DB2 8.x, IBM AIX 5.5, Autosys, MVS, ISPF, VSAM Files, Flat Files, XML Files, Shell Scripting, PERL, XML, XSD, TOAD, WinSQL

Confidential, CT

QA/ETL Tester

Responsibilities:

• Gathered user requirements from each Business Units for test.
• Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
• Designed and developed Test Plans and Test Cases and executed them.
• Involved in implementation of the Test plans, Test cases and Test scripts.
• Involved in the error checking and testing of the ETL programs using Informatica session log and workflow logs.
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Organized sessions in a batch to run the sessions in a batch in sequential order or start them concurrently by the server.
• Tested data warehouse ETL process using SSIS (Integration Service).
• Initial testing was conducted manually and later phase was executed using Mercury Tools
• Validated the front end reporting components created using OBIEE 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.
• Worked with Quality center to document test results and validate test scripts. Used Quality Center in routing defects, defect resolution and assigning business cases to business users.
• Developed Automated Test Scripts using Win Runner.
• Designed process performance loading strategies. And also wrote the optimizing techniques to improve the process loading time within the streamline using Server Manager to load the data into the Target Database.
• Tested data warehouse ETL process using SSIS (Integration Service).
• Tested the reports like DrillDown, Drill Up and Pivot reports generated from OBIEE.
• Involved in writing Test cases and Test plans which are managed and controlled using HP Test Director. Also used HP Test Director to manage and track defects.
• Documented defects accurately and with sufficient information to enable developers to analyze and reproduce the defect using Test Directors defect reporting tool.
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing and Performance Testing.
• Used various SQL queries to validate the test case results for back-end test cases.
• Well exposed to Software Development Life Cycle and Test methodologies.

Environment: Informatica Power Center 8, Oracle, OBIEE, SQL, PL/SQL, Autosys, UNIX Shell Scripting, XML, TOAD, HP Test Director

Confidential

QA Analyst

Responsibilities:

• Performed an active role in comparing front end data with the data stored in backend.
• Executed and written SQL queries for data comparison.
• Reviewed and analyzed user requirement documents (URD), software requirement specification document (SRS) and prepared System test plan by dividing the application into manageable units
• Interacted with Business Analysts and System Engineers while writing the test plan and test cases.
• Created and executed manual test cases and reviewed test cases developed by others.
• Maintained requirements and created Traceability Matrix between Requirements and Test Cases using Test Director.
• Performed functional and regression testing of the application manually and also automated.
• Performed Data-Driven Testing to read test input data from an Excel File so as to test the application with different Positive and Negative Data.
• Performed cross-browser testing to verify if the application provides accurate information in different (IE, Netscape, AOL) browsers.
• Used Test Director to generate Reports, manage Defects and track them to completion.
• Reported the bugs to the developers and made sure that the bugs were fixed by performing regression testing.
• Documented all the high-level test conditions, test cases and test steps using MS-Excel.
• SQL queries were implemented to validate the data.

Environment: Test Director, Windows, Java, Servlets, Oracle, SQL Html, JavaScript and UNIX