SUMMARY

• Around 8 years of IT experience with an excellent understanding of Software Quality Assurance and Manufacture Domain.
• Good experience in software testing process whichTest Planning, Test Cases Design, Test Environment Setup, Test Data Setup, Defect Management, Test log, Test results, Test Traceability Matrix and Test Metrics.
• Excellent experience with software QA methodologies, planning and execution and providing timely progress reports.
• Created Manual test cases in Mercury Quality Center, and worked on automated test cases in Quick Test Professional and viewing and analyzing the test results in the Mercury Quality Center.
• Experience with various types of testing like manual, white Box Testing, Black Box Testing, functional, system integration, regression, sanity, performance, end - to-end testing.
• Involved in Analysis and Testing of Business Intelligence solutions using Data Warehouse, ETL, OLAP, Client/Server applications.
• Have solid experience on database query tools such as TOAD Data Point, SQL Navigator, Teradata SQL Assistant, Rapid SQL, and SQL Plus.
• Good Experience in testing Initial (Reconcile) and Daily (Delta) ETL loads.
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Worked with Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Experience in ETL methodology for supporting Data Extraction, Transformations and Loading Process in a corporate-wide-ETL solution using IBM Datastage8.0, 7.X /6.X (Manager, Designer, Director and Administrator), Parallel Extender, Data Mining and OLTP.
• Proficient in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center(QC )11,/ALM, Test Director, JIRA, Clear Quest

TECHNICAL SKILLS:

Languages: SQL, C, C++, Visual Basic, VB .Net, PL/SQL

RDBMS: Oracle 11g/10g/9i/8i, Teradata V2R5/V2R6, MS AccessMS SQL Server 2003/2005/2008/2010

Operating Systems: UNIX, Windows vista / XP / 2000 / NT / 98 / 95.

RDMS Query Tools: TOAD, SQL Assistant, SQL Navigator, SQL * Plus, Rapid SQL

Testing Tools: QTP, QC, Win Runner, Load Runner, Test Director, Selenium IDE, Selenium RC, Selenium 2.0 Web Driver

Test Management Tools: HP Quality Center

Version Control Tools: Rational Clear Case

Defect Tracking Tools: Rational Clear Quest, HP Quality Center, JIRA

Incident Mgmt. Tools: BMC Remedy

Scheduling Tools: Autosys, Control-M

Reporting Tools: Crystal Reports, Cognos, SSRS, Micro Strategy

ETL Tools: Ab Initio, Informatica Power Center, Data Stage

Other Tools: Putty, Text Pad, Compare It, WinSCP, Araxis, Beyond Comp

PROFESSIONAL EXPERIENCE:

Confidential - MN

Sr ETL Quality Analyst

Responsibilities:

• Tested different methodologies like Waterfall and AGILE, well versed with both Methodologies of SDLC.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Involved in Gathering and Analyzing Business Requirements, High Level Designing and Detail Technical Design of ETL application.
• Involved in unit testing and integration testing of the developed work Analyzed production support Issues.
• Gathered UI specifications and analyzed business process and established test strategies.
• Tested the values for test, Component parameters in Quality Center.
• Performed Backend Testing, Database validations, patient claims validations by writing complex SQL queries
• Installing, Configuring and maintaining of Load runner and QTP Tools.
• Wrote scripts to perform basic Sanity Testing and uploaded Test Scripts in Test Director.
• Responsible for developing SQL Stored Procedures, Functions, Packages, triggers and other Database objects.
• Worked in Test Director Tool for Test plan, Test reports and user management.
• Logged issues in Test Director and tracked them to see whether the bug is fixed in the next Version.
• Communicated with Developers regarding technical issues.

Environment: Test Director 8.0, SQL server 2005, SQL Server, Windows NT,MS Excel, VSS(Visual SourceSafe), Load Runner, Quality Center 8.2, QTP 8.2

Confidential, Wilmington, DE

Sr. ETL / DW / BI Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Assist in the maintenance of technical and non-technical SDLC documentation.
• Creation of SDLC documentation, including User Requirements, Technical Specifications, and Test Cases.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in understanding Logical and Physical Data model using Erwin Tool.
• Worked onAutosysforBatch ProcessingETL, PL/SQL subprograms and performed backend testing.
• Tested 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.
• Involved in extensive testing of batch processing for positive and negative scenarios.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Extensively tested the Congo’s reports for data accuracy and static errors
• TestedAbInitiographs with both positive and negative scenarios.
• Responsible to test the functionality of Ab Initio graphs.
• Responsible for testing Initial and daily loads of ETL jobs.
• Written Shell scripts to run the Ab Initio developed jobs (.ksh) and Automated the ETL process through scheduling and exception routines.
• Created new projects in Soap UI to validate the web services.
• Worked with regulatory compliance data and did testing for web interface modules for exchanging the data feeds between the systems.
• Performed Negative testing using Ab-Initio GDE to find how the functions and variables perform when it encounters invalid and unexpected values.
• UsedRationalClear Questfor the bug tracking andRationalQuality Managerfor Test Case Management.
• Used Rational Requisite Pro for requirement management.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in validating inbound and outbound batch processes.
• 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.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Ab Initio 2.13,, SQL, SQL Server 2008/2005, SSIS, Rational Clear Quest, Rational Clear Case, Batch Jobs, Shell Scripting, Cognos 8, Autosys, Rational Requisite Pro, OBIEE, XML, XSLT, Web Services, Soap UI, UNIX, Web Logic, WINSQL, Putty, HP Quality Center 10, Oracle10g

Confidential, Philadelphia

ETL Data stage Tester

Responsibilities:

• Tested the Online Services application to ensure that the requirements, artifact from each phase, and the final product--are complete and correct.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.
• Monitor security batch processing jobs in multi-platform shop via Control-M & Tidal Schedulers.
• Interacting with the Offshore Team members about the project status thru Conference calls and need to prepare a Teams of Memorandum for the same.
• Used Data Stage to move data to the warehouse using the stored Procedure thereby enabling faster Moment of data.
• Tested various work flows with AGILE methodology, keen interaction with BA’s, Developers and infrastructure team
• Performed backend testing and reviewing DB tables for updates
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Performed the Unit and functional testing which validate the data is mapped correctly which Provides a qualitative check of overall data flow up and deposited correctly in Target Tables
• Tested the application for web functionality, and verified the online modules for broken links.
• Performed SQL validation to verify the data extracts and record counts in the database tables.
• Tested policies, standards and procedures for testing life cycle for the data warehouse and data marts.
• Performed usability testing frequently to ensure continuous availability of online services to Personal clients.
• Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Attended the Requirements reviews, Design reviews, Code reviews to understand the overall Process flow and Source to Target Mappings.
• Writing SQL Queries to retrieve data from data base.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data Transformation, data quality, integration testing, UAT & regression testing.
• Tested transformation functions and record formats for various input data files.
• Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF and many other
• Tested the SSRS report functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Ad hoc, Dashboards etc.
• Performed Data validation to verify the data extracts and record counts in the database tables.
• Conducted weekly batch testing to in corporate changes in new builds.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: IBM Web sphere Data Stage 9.1 /8.5/ 8.0.1/8.0/7.5/7.1 , HP Quality center9.2, QTP 9.2 Selenium, SQL server SSIS (2005), SQL server SSRS (2005), SSAS, Teradata V2R6, Windows 2000, T-SQL, SQL Plus, UNIX, Rational Clear Case,, DB2 8.x, Flat Files, XML Files, Shell Scripting, XML, XSD, TOAD, Win SQL, HP ALM.

Confidential / Hartford, CT- (Off-shore)

Sr. ETL/DWH/BI QA Analyst/Data Analyst

Responsibilities:

• Analyzed the Requirements from the client and developedTest cases based on functional requirements, general requirements and system specifications.
• Experienced business analyst specializing in requirements analysis and SDLC documentation in Waterfall, Agile and Scrum methodologies.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Performed complex data validation using SQL queries.
• Verified the logs to identify the errors occurred during the ETL execution.
• Involved in testing SSIS Packages, and in Data Migration.
• Worked in agile to create, maintain and execute test cases while participating in the validation of functional and non-functional requirements in an agile development environment.
• Actively provided inputs for agile retrospective to improve the process.
• Worked in agile methodology to perform manual exploratory and acceptance testing of new features being iteratively developed
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Tested theInformatica mappings and otherETLProcesses (DW Testing).
• Used Team Foundation Server as a test management tool for preparing test cases and executing them.
• Prepared Mock data based for covering all the scenarios on the different test cases.
• Have tested reconcile and incremental ETL loads for the project.
• Scheduled shell script jobs, creating instances of jobs, verifying logs according to client requirement using Autosys server.
• Written Shell scripts to run Informatica mapping jobs.
• Written Shell scripts to handle data before executing Informatica Maps and to meet pre-requirements to run the Maps.
• Tested data migration to ensure that integrity of data was not compromised.
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
• Used Rational Clear Quest as defect tracking tool.
• Validated various SSIS and SSRS packages according to the functional requirements.
• Worked on application integration testing in SOA Architecture and validated the SOAP based web services.
• 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.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Passed the various requests for web services in Soap UI and validated the responses.
• Validated different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Developed UNIX Shell Scripts for scheduling variousdata cleansingscripts and loading process.

Environment: Informatica Power Center 9.1, Informatica Data Validation Option (DVO), Clear Case, OBIEE, Clear Quest, SQL, UNIX, Putty, Shell Scripting, SSIS, SSRS, SSAS, Flat files, XML files, Sybase, WinSCP, Oracle 11g, Compare IT, Soap UI, HP Quality Center, Autosys, SQL Server 2008, and TOAD.

Confidential / Buffalo, NY

ETL/QA Analyst

Responsibilities:

• Responsible for creating Test plan, development of test scripts, execution and validate Test results and document test evidence.
• Executed test cases, and test scenarios forUser Acceptance (UAT), Functional and Regressiontest cases.
• Reviewed unit test cases and test results and certified the code for integration testing
• Created user acceptance testing documents and reviewed them with the customer.
• Mapped test cases to requirements using quality center
• Involved in entering and tracking defects using Rational Clear Quest.
• Ran Data Stage jobs by using Data Stage Director and by running UNIX scripts as well.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Conducted reviews of test plans, test cases, and prepared test results.
• Used Data Stage Director to run the ETL mappings and monitor the status.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to test business rules and security.
• Validated business objects reports for data and lay out.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Created Test input requirements and prepared the test data for back end testing.
• Involved in testing the reports and UI screens containing those reports.
• Provided status reports on test execution, and defects identified during testing.

Environment: Oracle 9i, Toad, DB2, SQL, Business Objects, MS Visio, data stage, TOAD, XML, Windows, UNIX, SQL Navigator