SUMMARY

• Over 9+Years of IT experience in the Software Quality Assurance, working as ETL tester testing in different environments and platforms.
• 3 years of experience in Data Warehouse applications testing using Ab Initio on multiple platforms.
• Experience in Functionality testing, System testing, Ad - hoc testing, Regression testing and E2E testing.
• Estimating the QA timeline, resource allocation and tracking of efforts and issues.
• Worked in Agile Methodology using Version-One for tracking User Story Task and Activity.
• Designed Test Case & Executed in HP-ALM with Defect Tracking.i
• Logged the Business Requirements in IBM Doors with the collaborative effort of Product Owners.
• Experience in full software Development Life Cycle (SDLC) and Quality Assurance Life Cycle (QALC) analysis, design, development, testing, implementation and maintenance in data warehousing environment.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents with Business & Product Owners.
• Prepare QA Documents including Requirements Tractability Metrics, Test Data, Test Result Metrics, and Defect Reports and Test Status Reports.
• Good expertise in using TOAD and SQL*Plus.
• Good Knowledge on Dimensional modeling, Star schema, extraction, transformation and loading (ETL) process.
• Excellent Knowledge in defect tracking and various reports and change request process.
• Experience with various test management tools such as Clear Quest &JIRA.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Excellent experience with Data base testing and strong SQL skills - ORACLE
• Excellent analytical & Testing skills with problem-solving approach

TECHNICAL SKILLS

Testing: Black-Box, White-Box

Testing Tools: HP-ALM, Jira, Bugzilla

ETL Tools: Ab-initio GDE 3.1.7.3, 3.1.5.3

Reporting Tools: Business Object, Cognos, Ab Initio, SSIS, Power BI

Defect/Test Management Tools: Jira,HP- ALM, Bugzilla

Languages: SQL, Unix

Databases: Oracle 10g, SQL

Web Server/App Server: Tomcat, Web logic

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential

ETL Tester

Responsibilities:

• Developed Test Plan and Test Cases based on the ts and performed smoke test to decide credibility of the build in order to initiate
• Create Test design estimations timeline based on reviewed scope.
• Manual testing and regression.
• Conducted Functional and Regression Tests and interacted with developers to fix defects and resolve
• Performed Functional, Integration, System, Regression, and UAT during the various phases of the application.
• Developed complex SQL queries to test the database values for data integrity.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
• Involved in business requirements & user’s requests.
• Closely worked with developers and System Engineers to nail down the technical problems.

Environment: Business Objects, Quality Center/HP-ALM, Oracle, Agile, UNIX, Version One, Rapid-SQL

Confidential, Sanford, NC

ETL Tester

Responsibilities:

• Flexible, resourceful, and self-motivated and can work as a team and independently
• Developed Test Plan and Test Cases based on the requirements and design documents.
• Extensively used HP-ALM for designing Test case & Execution & defect Tracking.
• Worked with Business team very closely for Business requirement changes in Agile Methodology
• Analyzed user requirements, scenarios, and business rules and attended periodic meeting for changes in the application.
• .Logged defect in JIRA / Bugzilla for defect tracking.
• Performed manual testing and regression testing for user stories.
• Involved in Functional testing, business requirement testing, data requirement testing, regression testing, system integration testing, data validation, and non-functional testing.
• Responsiblefor Smoke testing, Regression testing, Integration testing and System testing.
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Prepared Requirement traceability matrix (RTM) for the application.
• Developed complex SQL queries to test the database values for data integrity.
• Prepared agile test approach and test summary report for Release.
• Closely worked with developers and System Engineers to nail down the technical problems.

Environment: Business Objects, Quality Center/ALM, Oracle, Agile, UNIX

Confidential, Pleasanton, CA

ETL Tester

Responsibilities:

• Analyzed user requirements, scenarios, and business rules and attended periodic meeting for changes in the application.
• Worked with cross-functional teams to manage defects, compile test results and communicate issues, risks and status on a timely basis to ensure solution meets the business requirements.
• Involved in Functional testing, business requirement testing, data requirement testing, regression testing, system integration testing, data validation, and non-functional testing.
• Responsiblefor Smoke testing, Regression testing, Integration testing and System testing.
• Involved in Manual Testing to check the basic functionality of the modules under test.
• Prepared test plans and test cases to test application functionality.
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Prepared Requirement traceability matrix (RTM) for the application.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Involved in database testing by writing and executing SQL queries to ensure that data entered has been uploaded correctly into the database.

Environment: Business Objects, Quality Center/ALM, Oracle, Agile, UNIX

Confidential

Senior ETL Tester

Responsibilities:

• Having experience of working at Client Location as Onsite Coordinator in Singapore.
• Preparing ETL Specific Test Plan, Test Case and Test Data for GMBS process
• Participation in Test Readiness Review meeting and Defect Review meeting
• Point of contact for the client data testing, data accuracy and accuracy of functionality
• Leading a team and monitoring End to End ETL execution through Ab-initio graphs.
• SPOC for Testers-clarifying the design related queries of the test team members, bridging the gap between the Design and Testing Team, technical contributions in terms of forming conceptual level and high level designs Test Cases
• Worked with cross-functional teams to manage defects, compile test results and communicate issues, risks and status on a timely basis to ensure solution meets the business requirements.
• Implementation of Innovation and Automation within the project which contributed in increasing efficiency and reducing manual efforts.
• Prepared Requirement traceability matrix (RTM) for the application.
• Prepared Knowledge Management Documents for the Team
• Attended Walk through, Meeting with Project manager & QA team.
• Estimating the QA timeline, resource allocation and tracking of efforts and issues.
• Resource allocation - Deciding on resource allocation as per Work Order and complexity of various modules given for test.
• Tracking of projects - tracking progress of deliverables; maintaining alignment with external Testing Teams; maintaining interaction with users

Environment: Abinitio, Unix,SQL

Confidential

ETL Tester

Responsibilities:

• Usage data analysis from different network elements like
• MSC, IN, SMSC, CGSN, GGSN, Mediated Sources and reconciliation among them
• Non usage data analysis and reconciliation among them like
• HLR, BILLING, Voucher Management Systems etc
• Writing and debugging PL/SQL blocks (Functions, Stored Procedures and Triggers etc.) and performance tuning of the code as well
• Writing and implementing UNIX Shell Scripts for different modules of the One review product suite to make the jobs automated
• Creating aggregate data from detail data source and generating KPI reports from the aggregate data source.
• Involved in ETL process monitoring which includes new job creation and re-initiating failed jobs.
• Involve in Walk through & Inspection.
• Responsible for sending Daily & weekly status report.
• Analyzing raw data and finding the correlation between raw data and transformed one.
• Implementing new tariff systems in the re-rating server and developing multiple procedure and package creation to serve the purpose.
• Responsible for other adhoc as assigned.
• Flexible, resourceful, and self-motivated and can work as a team and independently.

Environment: Unix, SQL,Rating-Billing