PROFESSIONAL SUMMARY:

• 7+ years of extensive experience in Quality Assurance testing of data warehousing and Business Intelligence processes, Web Based and Client/Server applications.
• Excellent knowledge in implementation of different QA methodologies/policies, strategies and plans in all stages of SDLC.
• Excellent knowledge in test planning, coordinating, execution and leading the testing process.
• Tested various ETL processes developed using ETL tools like Informatica Power center, Ab Initio and Datastage.
• Tested various reports generated by Business Objects, Hyperion and Cognos.
• Proficient in querying various RDMS like Oracle, Teradata, DB2 and SQL server.
• Excellent knowledge of defect management and tracking using Quality Center.
• Adept at backend testing and data validation testing using SQL queries
• Proficient in Functional, Negative, Regression, System, Integration, User Acceptance (UAT), Security, Usability and compatibility testing during the various phases of the development of the application
• Involved in testing the interfacing of the web application with the legacy COBOL/CICS Mainframe programs
• Performed the functional testing, integration testing, system testing and regression testing on the application thoroughly executing the manual/automation testing scripts/test cases
• Experience in performing data validation and preparation of test da in UNIX environment using various UNIX commands and editors.
• Excellent Domain Knowledge in Financial, Retail and Healthcare.
• Hands on experience in both Waterfall and Agile QA methodologies.
• Coordinated testing efforts and effectively managed Off - Shore teams.
• Self-conscientious starter, strong team skills and ability to lead a team toward achieving organizational objectives.

TECHNICAL EXPERTISE:

Operating Systems: UNIX, Linux and Windows 98/NT/2000/XP/7

Languages: SQL, PL/SQL, C, C++

RDBMS: Oracle 8i/9i/10g/11g, Teradata, IBM DB2, and SQL Server 2000/2005/2008

ETL Tools: Informatica Power Center 8.x/9.x, Ab Initio and Datastage

BI Tools: Microstrategy, Business Objects XIR2/XIR3, Cognos and Hyperion

Testing Tools: Rational Clear Quest, HP ALM 11.0

PROFESSIONAL EXPERIENCE:

Confidential, PA

Sr. ETL Tester

Responsibilities:

• Analyzed the Business Requirements Specification Documents and Source to Target Mapping Documents and identified the test requirements.
• Interacted with business users to analyze the business requirements and system functional specifications and prepared Requirements Traceability Matrix (RTM) documents to map the business requirements with the functional and technical requirements and test scenarios.
• Attended daily Scrum Stand-ups for QA updates and defect status.
• Tested the source data for data completeness and data correctness.
• Tested the PL/SQL package that loaded data into staging from the source database.
• Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.
• Writing complex SQL queries for checking the counts and for validating the data at field level.
• Prepared sample test data by inserting data into staging tables.
• Prepared all the test scenarios and shared across the team.
• Involved in testing all the reports that were generated through Microstrategy.
• Tested the format of the reports according to the specifications provided and also compared the data in the reports with the backend datamart through SQL and also using excel for data comparison.
• Involved in end to end testing of the entire process flow starting from the source database to the target datamart to the reports by considering all possible scenarios.
• Was involved in running the informatica jobs from UNIX box for loading the test data into the target and also modified the shell scripts for scheduling purposes.
• Co-ordinated with the offshore counter-part for testing needs and also gave KT sessions on the business requirements.
• Was responsible for maintaining all the test cases and defects in HP ALM 11.0 for all the team members to review.
• Was the point of contact for the QA team for escalations and lead the bug triage meetings.
• Validated the production tickets assigned and once confirming the defect assigned it to the developer for fix.

Environment: Informatica Power Center 9.x, Oracle 10g, Unix, Microstrategy, HP ALM 11.0, Toad for Oracle, MS Office 2007, Windows XP

Confidential, Durham, NC

Sr. QA Tester

Responsibilities:

• Analyzed the Business Requirements Specification Documents and Source to Target Mapping Documents and identified the test requirements.
• Interacted with business users to analyze the business requirements and system functional specifications and prepared Requirements Traceability Matrix (RTM) documents to map the business requirements with the functional and technical requirements and test scenarios.
• Attended daily Scrum Stand-ups for QA updates and defect status.
• Tested the source data for data completeness and data correctness.
• Tested the PL/SQL package that loaded data into staging from the source database.
• Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.
• Writing complex SQL queries for checking the counts and for validating the data at field level.
• Prepared sample test data by inserting data into staging tables.
• Prepared all the test scenarios and shared across the team.
• Involved in testing all the reports that were generated through Microstrategy.
• Tested the format of the reports according to the specifications provided and also compared the data in the reports with the backend datamart through SQL and also using excel for data comparison.
• Involved in end to end testing of the entire process flow starting from the source database to the target datamart to the reports by considering all possible scenarios.
• Was involved in running the informatica jobs from UNIX box for loading the test data into the target and also modified the shell scripts for scheduling purposes.
• Co-ordinated with the offshore counter-part for testing needs and also gave KT sessions on the business requirements.
• Was responsible for maintaining all the test cases and defects in HP ALM 11.0 for all the team members to review.
• Was the point of contact for the QA team for escalations and lead the bug triage meetings.
• Validated the production tickets assigned and once confirming the defect assigned it to the developer for fix.

Environment: Informatica Power Center 9.x, Oracle 10g, Unix, Microstrategy, HP ALM 11.0, Toad for Oracle, MS Office 2007, Windows XP

Confidential, Boise, ID

Sr. QA Tester/Analyst

Responsibilities:

• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Worked as a consultant in delivering quality data centric solutions for various business domains
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Coordinated the Testing efforts during Integration, System and User Acceptance Testing phases.
• Tested ETL process of data extraction using Ab Initio, executed Ab Initio graphs and created data files.
• Validated data files produced result of Ab Initio graphs and data transformation case studies involved.
• Used Unix environment variables in various .ksh files which comprises of specified locations to build Ab Initio Graphs
• Performed extensive Database Testing by writing complex SQL Queries in DB2 to test the different scenarios in the application.
• Worked on QTP/UFT for Regression, Integration, and system Testing.
• Involved in ETL process testing using Ab Initio ETL tool.
• Involved in Data modeling, normalization, de-normalization, physical database design and relational models, database procedures, functions, packages and triggers for enforcing the business rules using PL/SQL.
• Build a customer data centric data warehouse to analyze transactions across finance, marketing, risk collections and consumer relations for the credit card division. Clean customer data warehouse successfuly implemented on Oracle target, the data warehouse is growing in its analytical richness.
• Supporting presales activity for Data centric warehouse testing projects.
• Tested ETL process of data extraction using Ab Initio, executed Ab Initio graphs and created data files.
• Validated data files produced result of Ab Initio graphs and data transformation case studies involved.
• Managed the test process and execution using Quality Center, generated reports for test coverage analysis.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Performed independent MDM services testing by preparing xml transactions.
• Tested the XMLs feeds received from another source which is a third party for data consistency.
• Tested the ETL with XML as source and tables in the data warehouse as target.
• Tracked defects to closure by coordinating with the dev team.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and coordinated integration testing and regression testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Tested the data consolidation for Master Data Management (MDM)
• Worked with the DSO team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
• Prepared test data to cover all the test scenarios.
• Prepared UNIX scripts to run the informatica ETL jobs from command line.
• Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
• Tested the migration of reports from Business objects XIR2 to XIR3.

Environment: SQL, PL/SQL, HP Quality Center 10.0, XML, QTP, UFT, UNIX, Data Centric Oracle 10g Informatica 8.6, Business Objects XIR3, TOAD for Oracle

Confidential, Bloomington, IL

ETL QA Analyst

Responsibilities:

• Reviewed requirements for testability and usability, and consulted development staff with regards to system functionality.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Involved in ETL process testing using Ab Initio ETL tool
• Tested the flow of data from front end to backend databases.
• Tested the real time updates happening in the databases through web services using SOAP UI.
• Tested the ETL processes that ran to load the reference data into the central repository.
• Develop, maintain and execute manual test cases.
• Performed smoke testing, Functionality testing, Integration testing, and Regression testing.
• Participated in review meetings for creating Test plan and test results summary.
• Analyzing business and functional requirement to design SIT and UAT Test Cases
• Participated to create Test Analysis reports (TAR) and stored them into the Quality Center.
• Updated RTM on daily basis, send status report and daily tracking report to test manager.
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
• Participated in the meetings with business users to present future functionality of the application, gather information from them to know about their need and send this information to test manager.

Environment: SOAP UI, Java, J2EE, SQL Server /Oracle 8i, Windows XP, Test Director 7.6

Confidential

QA / Data Analyst

Responsibilities:

• Involved in Data Analysis and Database Designing.
• Involved in identifying data from BRD to Develop LDM, PDM by studying Data Flow diagrams and State Transition Diagrams.
• Used MS Visio to develop the database design.
• Extensively involved in developing Data Dictionary.
• Created tables and various database objects.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Involved in performing validation of datasets, tables and triggers by performing White Box Testing and code walk-through.
• Performed Data Profiling to improve search abilities by using tags and aliases.
• Dynamically adjusted price breaks in accordance with client pricing groups and allowed editing/addition of customer information to rapidly assemble on-screen, printed and database-recorded quotes.
• Developed test reports and participated in testing prioritization and archived test results and user signoff
• Involve with Design and Development team to implement the requirements.
• Performed execution of test cases manually to verify the expected results.
• Involved in creation of tables, writing stored procedures and Triggers.
• Developed user interface screens using VB, ADO to connect to backend and stored procedures to manipulate data.
• Handling user defined exceptions.
• Involved in testing, implementation & maintenance.

Environment: MS Visio, Crystal Reports 9.0, Metadata Repository, Visual Basic 6.0, SQL Server 2000, SQL, T-SQL, UNIX and Windows NT