SUMMARY

• 8 years of IT industry experience in Software Quality Assurance Data Warehousing and ETL & BI applications.
• Experience in DWH ETL methodology for testing and supporting Data Extraction, Transformations and Loading process in a corporate - wide-ETL solution using SQL Server Integration Services (SSIS), Informatica and Data Stage.
• Conversant with all phases of Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC) in Requirement gathering, Analysis, Design, Development, Testing, Deployment and End User Training in models like Waterfall and Agile.
• Extensive IT experience and knowledge of Business processes and work flow in Insurance, Retail, Financial and Health care domains.
• Strong experience in System Testing, Regression Testing, Functional Testing, Sanity testing and End-to-End testing and UAT of Web based and Data Warehousing applications in Windows Environment.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Has experience in Confidential Policy Center/ Billing Center /Claim Center.
• Good experience in analyzing Business Requirements and Source to Target Mapping documents, Test Planning, Developing QA project plans, test plans, test scripts and testing procedures for Business Intelligence applications.
• Ability to develop complicated SQL scripts for Data validation testing and to execute them.
• Proficient in Backend Testing and Data Integrity Testing using SQL and PL/SQL.
• Extensively used Quality Center (QC) and Application Life Cycle Management (ALM) tools for requirements tracking, Test Management, defect tracking, results and status reporting. Worked with Agile Tools, Rally and VersionOne.
• Experience in testing XML files and validating teh data loaded to staging tables.
• Knowledge of UNIX Utilities and Shell Script to automate process. Experience working with scheduling tools for jobs.
• Well versed with teh data modeling to understand teh logical and physical relation between facts and dimensions.
• Experience with integration testing of teh applications using various sources like flat files and various databases.
• Experienced in documenting defect summary, and test progress graphs with overall test summary and sending daily or weekly status reports to teh project manager and business.
• Experience on Front end manual testing and automation testing using QTP.
• Good analytical & communication skills and ability to work independently with minimal supervision and also perform as part of a team.

TECHNICAL SKILLS

Testing Tools: Quality Center 11, ALM 11, Test Director 8.0, Bugzilla, QTP, JIRA, Rally, VersionOne

Programming Languages: SQL, PL/SQL, Shell Scripting, PERL, XML, XSD, VB, T-SQL, Java, C, C++

RDBMS/Database: Oracle 11g/10g/9i, Teradata V2R6, DB2 9.0,SQL Server 2012

ETL/DW Tools: Informatica Power Center, DataStage, SSIS, Abinitio

BI Tools: SSRS, Business Objects XIR4, Cognos, Crystal Reports

Utility & Tools: SSIS, Visual Source Safe, SQL Profiler, MS Office/Outlook Express, Autosys, Maestro, Power Designer

Data Modeling: Erwin 7.0, ER Studio, MS Excel, MS Access

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. QA Tester/Lead

Responsibilities:

• Reviewing and understanding Business Requirements Document and Functional Specification Document, Data models and Mapping document with Business Logic/Transformation rules.
• Developed Test Plans, Test Cases, Test Scripts, Requirement Traceability Matrix and Test Coverage reports for System Integration Testing and Functional Testing.
• Worked on Agile-Scrum methodology. Participated in Sprint planning meetings, Daily scrum meetings and Sprint Review & Retrospective meetings.
• QA Data/ Load Validation Testing. Responsible in testing Initial and incremental loads of ETL jobs. Testing teh Change Data Capture.
• Involving in scrum meetings to discuss daily progress and blockers
• Initial & Incremental Load ETL Testing of Policies & Claims
• Billing Center ETL Testing
• Involved in running teh ETL loads in development server
• Writing SQL Queries to define, Identify and validate teh code for teh data movement into teh Data Warehouse or Data Mart.
• Using Rally on daily basis to work on various tasks of user stories and defects and updating teh timesheet
• Analyzing user stories, writing test cases and executing them.
• Preforming thorough End-to-End testing
• Retesting teh resolved defects/issues after teh developers fix teh defects
• Using SQL server 2008 for querying to generate data for teh specified reports.
• Having sessions with business owners and users and writing down requirements or specifications.
• Having mapping document sessions with development team and collecting requirements
• Comparing teh BO reports (new Confidential DWH) and SSRS (Legacy TWIA DWH) reports.
• Using Policy center and Billing center for information and analysis of policy data
• Checking policy data in policy explorer and Checking claims data in TOS and NOTUS
• Manual testing of missing policies
• Interacted with developers, Business & Management Teams and End Users.
• Sending status report and reviewing teh progress with manager and business on a weekly basis.

Environment: MS SQL Server 2008/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Rally, Power Designer v3.1.0, SAP Business Objects 4.0, SAP Data services 4.0, Windows 7, NOTUS, Policy explorer 7.3, Policy Center

Confidential, Richfield, MN

Sr. QA Tester/Lead

Responsibilities:

• Review and understand teh ETL processes, functionality & identify test requirements and coverage.
• Reviewing and understanding Business Requirements Document and Functional Specification Document, Mapping document with business transformation rules and Data Models.
• Prepared Test Plans, Test Cases, Test Scripts, Tractability Matrix and Test Coverage reports for System Integration Testing.
• Performed System testing, Integration testing, Smoke testing, Regression testing and Functional testing.
• Responsible in testing Initial and daily loads of ETL jobs.
• Involved in data mapping, validation and Extract, Transform and Load from one database to another by using SSIS with SQL scripts.
• Modified SSIS packages to clean and load data to data warehouse and to support future enhancements.
• Validated SSIS and SSRS reports according to requirements.
• Reviewing Test cases and scripts based on client requirements in Quality Center, reporting and tracking teh defects in Quality Center.
• Worked on Onsite-Offshore model. Responsible for coordinating off-shore resources.
• Involved in Execution of test cases to verify actual results against expected results.
• Prepared status summary reports with details of executed, passed and failed test cases
• Testing of Data Mapping documents between source and target databases as per teh transforming logic.
• Preparing teh SQL script to verify data and validating data from source and target.
• Responsible in testing Initial and daily loads of ETL jobs. Testing teh change data capture.
• Worked on SQL scripts to load data in teh tables in Test environment.
• Validating data manually during application retirement or Data masking.
• Write custom test management reports using SQL.
• Wrote complex SQL queries to validate several BI Reports, Involved in testing data migration.
• Wrote SQL scripts to validate teh data from source and target and for backend database testing.
• Running of Data warehouse ETL jobs and test data setup, Quality check for test data, Transformation logic verification, RCA for defect found.
• Experience working with scheduling tools for jobs.
• Validated teh data movement and transformations are done correctly
• Interacted with developers, Business & Management Teams and End Users.
• Coordinating with teh offshore team, delegating work to them, resolving issues, getting status from them
• Sending status report and reviewing teh progress with client on a daily basis.

Environment: SSIS, Data warehouse ETL Informatica 9.1, SSRS, Oracle 11g, SQL, PL/SQL, XML Spy 2013, Teradata V2R6, Teradata SQL Assistant 6.0, UNIX, TOAD, XML Files, SOAP UI, XSD, HP Quality Center 10, QTP, Shell Scripting, Business Objects.

Confidential, Foster city, CA

Sr.QA Tester

Responsibilities:

• Reviewing and understanding Business Requirements Document and Functional Specification Document, Data models and Mapping document with business transformation rules.
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Developed Test Plans, Test Cases, and Test Scripts for System Integration Testing.
• Worked on Agile-Scrum methodology. Participated in Sprint planning meetings, Daily stand-up meetings and Sprint Review & Retrospective meetings.
• Performed System testing, Integration testing, Smoke testing, Regression Testing and Functional testing.
• Responsible in testing Initial and daily loads of ETL jobs.
• Involved in data mapping, validation and Extract, Transform and Load from one database to another by using Informatica and doing SQL queries.
• Created SSIS packages to clean and load data to data warehouse
• Validated SSIS and SSRS reports according to requirements.
• Reviewing Test cases and scripts based on client requirements in Quality Center, reporting and tracking teh defects in Quality Center.
• Worked on Onsite-Offshore model. Responsible for coordinating off-shore resources.
• Involved in Execution of test cases to verify actual results against expected results.
• Prepared status summary reports with details of executed, passed and failed test cases
• Testing of Data Mapping documents between source and target databases as per teh transforming logic.
• Preparing teh T-SQL script to verify data and validating data from source and target.
• Validating data manually during application retirement or Data masking.
• Write custom test management reports using SQL.
• Wrote complex SQL queries to validate several BI Reports, Involved in testing data migration.
• Wrote SQL scripts to validate teh data from source and target and for backend database testing.
• Validated teh data movement and transformations are done correctly
• Interacted with developers, Business & Management Teams and End Users.
• Coordinating teh offshore team, delegating work, reviewing and getting status reports.
• Sending status report and reviewing teh progress with client on a daily basis.

Environment: SSRS, Oracle 11g, SQLXML Spy 2013, Teradata V2R6, Teradata SQL Assistant 6.0, UNIX, TOAD, XML Files, SOAP UI, XSD, HP Quality Center 10, Shell Scripting, Business Objects.

Confidential, Madison, WI

ETL QA Analyst

Responsibilities:

• Review teh Business requirements and ensure teh testability of these requirements.
• Developed project plan, Test Plan, Test cases for teh QA Phase of teh Global Data Warehouse.
• Extensively used Informatica client tools to extract data stored in database and for testing purposes.
• Processed a query to update a field in an Oracle database, to ensure dat debt payments are allocated.
• Performed data validation tests using complex SQL statements.
• Reported defects and status of teh defects in HP QC.
• Validated teh data transformations developed by DB2 stored procedures and Informatica.
• Developed complex SQL queries to verify teh data loaded into teh target tables. Validate teh test data using MS access, TOAD, UNIX & MS Excel.
• Connect to telnet to teh UNIX environment and download, transport test data files
• Coordinated and participated in generating teh test data required for various test activities.
• Generate QA progress reports on a daily, weekly and monthly basis.
• Communicated risks and escalated issues to supervising Manager as required.
• Communicate QA progress, % of test cases executed per day to teh supervising authority.
• Conduct walk through meetings with various teams in understanding teh QA processes, bug life cycles, QA documentation.
• Redesigned SSIS packages from scratch after applying necessary transformations.
• Performed database integrity check using SQL and Unix Shell Scripts.
• Performed Functional, Regression, Data Integrity, System, Compatibility, and User Acceptance Testing including GUI testing.
• Involved in backend Data warehouse ETL testing with SQL, check teh data integrity and referential integrity.
• Gather feedback from teh manager to in corporate changes as required for teh QA process documentation.
• Tested teh Exception flows using SOAP UI by passing Exception codes in XML.
• Written several complex SQL queries to validate teh SSRS reports.
• Work with teammates to resolve inter and intra teammate issues without affecting teh project timelines.
• Escalate database downtimes and any issues dat could potential create hindrance to testing progress.
• Perform automated QA reports using Quality Center and Start Team dashboards.
• Participated in pre-release meetings and performed documentation reviews and approvals.
• Train users and provided help in conducting UAT.

Environment: Oracle 1og, SQL, PL/SQL, Data warehouse ETL Informatica 8.6, SSRS, XML Spy 2011, UNIX, TOAD, XML Files, SOAP UI, VSAM Files, HP Quality Center 10,QTP, Shell Scripting, Business Objects XIR3

Confidential, Philadelphia, PA

ETL QA Tester

Responsibilities:

• Actively involved in Agile testing process for Web-Methods System.
• Analyze teh Business requirements and ensured teh testability of teh same.
• Responsible for preparing Resource Sizing and estimation for teh testing efforts.
• Responsible for preparing Testing timelines and resource utilization for various QA components.
• Coordinating off-shore and On-shore Test resources.
• Written complex SQL queries for data completeness, data quality & data transformation.
• Managed multiple data feeds coming from different source systems.
• Developed Test Plan and review teh test cases and test scripts prepared by teh team for teh QA Phase of teh Global Data Warehouse.
• Co-ordinate teh Unit, Integration, Regression, Load and UAT Test phases
• Testing teh POS systems on a daily basis for any possible menu changes.
• Report defects and status of teh defects in Mercury Quality center.
• Analyze teh Data warehouse ETL mappings and generate test scenarios.
• Involved as part of teh team to developed and review teh complex SQL queries for teh entire Data warehouse ETL test components involved.
• Validate teh PL/SQL Procedures and ensure teh data quality.
• Developed XML test data for web services testing and mimicked teh same using XML spy.
• Used SOAP UI evaluation version to affectively test teh Web Services developed by Web Methods to integrate all teh granular level data as per XSD developed by teh POS vendors.
• Tracking teh entire testing process via Quality Center and reporting teh progress on a daily, weekly and monthly basis to teh project manager.
• Trained developers and testing team members on Quality Center.
• Analyze and present teh Load test results to Technical Lead and Project Manager.
• Involved in teh development of a standardized ETL testing framework for teh Data Warehousing QA practices.

Environment: SQL, PL/SQL, Oracle 10g, Web Methods 7.1, Data warehouse ETL Informatica 8.1, SSRS, Oracle SQL Developer, SOAP UI

Confidential, Chicago, IL

ETL/SQL Tester

Responsibilities:

• Worked with teh Subject Matter Experts to ensure dat requirements were correct and complete.
• Responsible for identifying business scenarios / test cases to be used during teh end to end test phase.
• Performed Unit, Integration, End-to-End, Regression and UAT tests phases.
• Executed integration/End to end testing for teh entire process.
• Verification and validation of teh data and mappings during various stages.
• Performed testing to check teh performance of teh server, network, and graphs and documented teh key performance issues to be resolved.
• Designed SSIS packages and schedule them in jobs to load OLTP data every hour.
• Written complex SQL queries to validate teh data conditions based on ETL data mapping document.
• Created SSIS Packages using Derived Columns, Condition Split, Merge Join, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. in SQL Server Integration Services (SSIS).
• Developed reports on test progress, % of test cases execution/day/week/month, defect reports/ day/week/month both manually (Excel) and using test tracking tools (Star Team, Quality Center 9.0).
• Performed cost and budget analysis of QA resources using Microsoft Excel and Power Point.
• Coordinating off-shore and On-shore Test resources on a 24/7 work model and assisted clients in teh resource hiring process for QA (as required)
• Developed and presented power point presentations in walking teh tech, business and sponsors to understand teh QA test plans, progress reports, risks, build release requirements, test prioritization, resource allocation, team training needs and defect life cycles.
• Conduct walk through meetings with various teams in understanding teh QA processes, bug life cycles, QA documentation
• Worked with multiple outsourcing companies and efficiently worked as a liaison b/n teh client and multiple outsourcing companies.
• Work with teammates to resolve inter and intra team issues without affecting teh project timelines.
• Escalate database downtimes and any issues dat could potential create hindrance to testing progress.
• Perform automated QA reports using Quality Center and Start Team dashboards.
• Developed Requirement Traceability Matrix (RTM) for TEMPeffective management, training developers and testing team members on Quality Center.
• Participated in pre-release meetings and documentation approvals
• Train users and help in conducting UAT.

Environment: Oracle 10g, DWH ETL Informatica 6.2, Brio, UNIX, TOAD, SSIS, Quality Center 9.0, XSD, XML, Shell Scripting