SUMMARY

• Over 7 years of experience as a Quality Assurance Test Analyst / Quality Assurance Engineer, performing Manual, Automation and ETL (Data warehousing) testing of applications and Data in teh client server, web and mobile applications in internet/intranet environments using Unified Functional Testing (UFT), Mercury IT Governance center, IBM data Studio, Oracle SQL Developer, Data Stage, Main Frames, HP ALM etc.
• Exposure in Federal, Finance, Banking, Automotive and Health Care industries.
• Involved in Software Testing Lifecycle including Black Box, system, integration, database, performance, GUI, Functional, Regression, Unit testing, User Acceptance, Smoke testing and Sanity testing of both client - server and web-based applications.
• Hands on experience wif all phases of Software Development Life Cycle (SDLC) in Agile & Waterfall methodologies.
• Well conversant wif software testing methodologies including developing Test Plans, Test scenarios, Test Cases, Test procedures, Test reports, Requirements Traceability Matrix and documenting manual and automation tests.
• Expertise in Manual/Functional Testing, Automation, ETL & Data warehouse Testing.
• Experience in RDBMS, Microsoft SQL Server (T-SQL), Oracle (PL/SQL), MS Access and associated SQL Programming Knowledge
• Experience working wif platforms and DBs likeOracle 11g, Cognos, IBM data studio, DB2, Teradata, Mainframe, SQL Server, Informatica, DataStage, GreenPlum and TOAD.
• Proficient in using Microsoft Office tools and Well versed wif SQL, PL/SQL queries to run teh data integrity tests.
• Excellent communication and interpersonal skills wif problem solving abilities, TEMPeffective in working independently and exceptional team player.

TECHNICAL SKILLS

Operating Systems: MS Windows XP/Vista/7, Server 2000/2003/2008 , Linux Ubuntu

Testing Tools: UFT 12.5, QTP/UFT, IBM Data Studio, Toad, Oracle SQL developer, Data Stage, Tidal, PG Admin, SAP BOE & Data Stage Director

Languages: VB Script, UNIX, SQL, PL SQL, XML, JAVA

Databases: SQL Server, Oracle, DB2, Mainframe, Teradata, GreenPlum, MS Access

Methodologies: SDLC, STLC, Agile, Waterfall

Bug Tracking & Management Tools: HP ALM 12.21, HP Quality Center, Version One, RTMs, MS Office Works, JIRA, IBM Rational Quest, Rally

PROFESSIONAL EXPERIENCE:

Confidential

ETL Specialist

Responsibilities:

• Involved in End to End ETL testing process where data resides in Legacy systems to Reporting.
• Managed and conducted System testing, Integration testing and Functional testing and Unit testing.
• Organized teh tune systems and ensured its optimal performances on multiple platforms for Verification, Validation, and Transformations on teh Input data (Text files, XML files) before loading into target database
• Ran & Monitored Control- M workflows using BMC Control - M and also checked session logs in case of aborted/failures.
• Used teh Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Worked wif development teams to understand ETL requirements and designs
• Worked on SQL scripts to load & update data in teh tables
• Responsible for all new and existing ETL data ware house components
• Experienced at testing ETL s' and flat file data transfer wifout relying on GUI layers. Secure FX & Secure CRT was used to copy live files into teh database.
• Used most of teh ETL tools like Informatica, Oracle SQL developer, PG Admin, RMA etc. to manipulate data from multiple databases based upon teh requirement.
• Planned and conducted BOE report tests for wide variety of applications
• Planned, documented and tested extensive data integration process (PL/SQL) in support of financial security data
• Implemented TEMPeffective data quality testing standards, verification procedures and tools

Environment: Informatica Power Center 9.6.1, Oracle 11g, SQL Developer 4.1.2, Shell Scripting, Red Hat Enterprise Linux Server Release 6.9, Control M Enterprise Manager 8.0.00, PostgreSQL Version 1.16.1, SecureCRT 7.3.4, SecureFX 7.3, ClearCase 8.0.0.11, ClearQuest 8.0.0, GreenPlum 4.2.3

Confidential

Automation Test Lead

Responsibilities:

• Provided technical expertise and electronic support wif Onstar design integration of various new car platforms.
• Supported and insured that microphone selection and placement provided optimal performance for both Speech
• Recognition and Hands Free operation of teh Onstar system in all new car and truck platforms.
• Designed and developed an ASR (Automatic Speech Recognition) test bench for voicing utterances, in vehicle testing and validating of various competitive supplier microphone component technology.
• Supported teh design and development of an automated microphone array testing procedure for anechoic chamber, lab and vehicle evaluations for supplier microphone arrays.
• Performed in vehicle testing wif suppliers on their products.
• Designed and fabricated electronic hardware systems, signal interfaces and test benches.
• Delivered and supported evaluations of lab and in vehicle hands free speech testing.
• Developed and wrote detailed product reviews, system performance reports and suggested system improvements.

Environment: Oracle 11g, HP ALM, INFO- Workbench, NGI Bench, Agile, HP UFT, Autosar, Embeded Systems, Infotainment applications

Confidential

DWH Test Lead

Responsibilities:

• Identifying field and data defects wif required information in ETL process in various jobs and one to one mapping.
• Responsible for creating teh Test Plans and given sign offs.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules t
• Validated teh data in teh reports by writing SQL queries in teh transactional system.
• Oversaw teh historical loads in UAT and PROD environments.
• Worked on Integration of all teh processes in UAT/PROD.
• Optimized/Tuned several complex SQL queries for better performance and efficiency.
• Prepared teh Test Cases after thorough analysis of each requirement.
• Prepared test data by modifying teh sample data in teh source systems, to cover all teh requirements and scenarios.
• Conducted and actively participated in reviews, walk-throughs of Test Cases.
• Reviewed teh ETL mappings to ensure teh transformation rules are applied correctly.
• Executed teh workflows in teh workflow manager, to start teh ETL process.
• Created and executed SQL queries to perform source to target testing on DB2 database. Performed teh following tests: Data Completeness, Validity, Uniqueness, Data Integrity, Data Transformation, Data Quality, Initial and incremental load tests
• Coordinated wif different users in UAT execution.

Environment: Oracle 11g, Version One, Data Stage, Unix, MS Work, Mainframe, Cognos, Alpha, Advantage, Windows OS

Confidential

Responsibilities:

• Involved in analyzing system design specifications and developed Test Scenarios and Test Cases to cover overall quality assurance testing.
• Worked on data validation of more TEMPthan 1.3 million records using SQL in IBM Data Studio from Loans and deposits side.
• Identified defects and errors in data prior to data processing.
• Mitigated existing issues and provided solutions.
• Collaborated wif Back end and database developers.
• Also, validated data writing macros.
• Checked whether Data mapping is done correctly and matches teh data.
• Export requirement, Test Cases into teh Quality Center, run manual and automation Test Cases from test lab and log defects from defects module.
• Participated in peer review meeting for creating Test Plan, Test Cases and analyzing various testing documents and defined Testing strategy, scope, objectives, methodology, timeline, resources, environment.
• Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
• Updated RTM in daily, send status report and daily tracking report to test manager.
• Involved in solving teh production issue in mortgage ware house application (wire transfers system was crashing). So was playing a part as an automation tester for 3 weeks.

Environment: IBM Data Studio, HP ALM, MS Excel, SQL, TOAD, UFT, DB2, Teradata, OBIEE

Confidential

SQL Test Engineer

Responsibilities:

• Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applications
• Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
• Developed SQL queries /scripts to validate teh data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Performed data quality analysis using advanced SQL skills.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Extensive SQL querying on Staging Dataware house and DataMarts.
• Ensured Error logs and audit tables are generated and populated properly
• Performed UAT and Regression Testing.
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Tracking and reporting teh issues to project team and management during test cycles.
• Updating and maintaining existing test Matrix and test cases based on code changes and enhancements to assigned applications.
• Contribute in teh development of knowledge transfer documentation.

Environment: Windows XP, Datastage 7.0, Oracle 9i, DB2, SQL Server, Business Objects, MS Office Suite., Visual Basic, SQL, PL/SQL, MS Office

Confidential, Herndon, VA

Quality Analyst:

Responsibilities:

• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Perform both manual and automation testing and created various test results to track teh testing results.
• Export requirement, Test Cases into teh Quality Center, run manual and automation Test Cases from test lab and log defects from defects module.
• Followed up wif standard software testing life cycle (STLC) to perform different types of testing for teh projects.
• Participated to create Test Analysis reports (TAR) and stored them into teh Quality Center.
• Performed UAT testing in teh UAT environment prior to notify to teh customer to start performing UAT testing.
• Performed Functional Testing using Quality Center.
• Developed automation scripts in QTP/UFT to automate smoke and regression testing.
• Used Quality Center to execute automation scripts in batch mode or unattended mode.
• Assisted teh scripts in QTP/UFT by applying checkpoints, parameterizations, synchronization point, data driven tests and creating modular tests.
• Met wif client to present future functionality of teh application, gather information from them to know about their need and send dis information to test manager.
• Assisted in smoke testing, Functional, Integration, System, user interface testing of teh bank loan information web based application.
• Experienced and worked in Agile environment

Environment: HPQC, QTP/UFT, Oracle, SQL, Windows, Agile Environment

Confidential

ETL Tester

Responsibilities:

• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
• Creating test cases for ETL mappings and design documents for production support
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• Extensively worked wif flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Scheduling and automating jobs to be run in a batch process
• TEMPEffectively communicate testing activities and findings in oral and written formats
• Worked wif ETL group for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and SQL Server

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005, Flat Files, DB2, TOAD 9.5, Mercury Quality Center 9.2, Lotus Notes 7.0.3, Agile Scrum

Confidential

Manual Tester

Responsibilities:

• Created and executed Test Cases for new features, while analyzing and documenting teh test outputs
• Managed result defects through re-testing cycles
• Involvement in Manual testing methodologies
• Involved in Graphical User Interface Testing (GUI) of teh application
• Preformed End-to-End Testing of teh application

Environment: HP Quality Center, QTP/UFT, SQL, MS Office, Water Fall