SUMMARY

• 11.5 Years of proficient experience in Quality Assurance and ETL/DWH/BI Testing for Client - Server/Desktop and Web based applications
• Strong experience in Telecommunications, Finance, Health Care, Investment and Retirement domains
• Expertise in Functional Testing, ETL/DWH/BI Reports Testing, Re-Testing, Regression Testing, Sanity/Smoke Testing, System Testing (ST), System Integration Testing (SIT), Browser Compatibility Testing, User Acceptance Testing (UAT)
• Knowledge on Microsoft Hadoop Distribution Insight (HDI), Parallel Data Warehouse (PDW) and Hadoop/BigData echo system
• Good understanding and testing of OBIEE 11g Subject Areas with Ad-hoc reports generation and RPD
• Hands on experience in writing and debugging SQL queries using DML commands
• Involved in Data Centric Testing to verify Accuracy, Completeness, Correctness and Consistency of the data quality
• Good Knowledge on Data Warehousing concepts and performed testing using Informatica Power Center Client 8.6, 9.1
• Experience in processing the data available in Flat Files and Relational Databases
• Worked on Database Migration projects by automating the ETL workflows/jobs
• Deep knowledge on Sales, Ordering and Provisioning of Telecom Service Delivery flow
• Hands on experience in testing Telecom OSS/BSS applications
• Profound knowledge on Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
• Created Test Plans, Test Scenarios, Test Metrics and Test Estimations
• Experience in designing, developing and executing Test Cases
• Excellent in handling the defects throughout the Bug/Defect life cycle from detection until resolved using defect tracking tools like Bugzilla, Jira and Rational Clear Quest
• Hands on experience in using the SAS Enterprise Guide (SAS EG) and developed, executed, automated the test scripts (writing SQL queries) in SAS EG
• Worked on Reports testing using SAP Business Objects
• Expertise in using Test Management Tools like Zephyr and HP Quality Center/Application Lifecycle Management (ALM)
• Worked with global teams Confidential onshore and offshore in different time zones
• Created Traceability Matrix and Test Summary reports to support quality deliverables
• Exposure to Performance Testing - Load Testing and Stress Testing
• Proficient in Black-Box Test Case Design Techniques
• Possess good communication with Users, Business Process Engineers, Developers, Integration Leads, Business Analysts, Subject Matter Experts and Architects
• Working experience in Agile environment - Scrum/Sprint Model
• Experience in running and validating the ETL jobs/logs on UNIX/AutoSys environment
• Analyzing the technical issues to determine the root cause
• Involved in Test Data preparation for Test Execution and Inventory Build
• Knowledge on Telecom Billing, Revenue Assurance and Fraud Management
• Supported User Certification Testing (UCT) and Operation Readiness Testing (ORT)
• Worked as a Point of Contact/Subject Matter Resource for Top Up and Recharge modules
• Involved in Sanity Testing and Regression Testing by automating Core Test Suite and running the automation scripts using QTP
• Strong analytical skills, quick learner and demonstrated ability to handle multiple tasks/roles as well as work independently or in a team

TECHNICAL SKILLS

Languages: SQL

Databases: Oracle, DB2, MySQL, Sybase and SQL Server, Teradata

ETL Tool: Informatica, Datastage

Reporting/BI Tool: OBIEE (OBIA), SAP Business Objects

Functional Test Tools: QTP 10 (UFT)

Defect Tracking Tools: Bugzilla, Rational Clear Quest and Jira

Test Management Tools: HP Quality Center (ALM) and Zephyr

Other Tools: Snagit, XML Spy, SoapUI, Oracle SQL Developer, SecureFX, SecureCRT, Rapid SQL, BeyondCompare, SSMS, TOAD Data Point, Rally, Notepad++, AQT, PuTTY, WinSCP, FileZilla, SAS EG

ETL Scheduling Tools: AutoSys and Robot Schedule

Technologies: Java, Siebel CRM, Mainframes, VB.Net, SAP, SAS and TIBCO

Operating Systems: Windows 2000/XP/7, UNIX

PROFESSIONAL EXPERIENCE

Confidential - Eagan, MN

ETL QA Lead

Responsibilities:

• Responsible for Test Planning, Estimations, Monitoring, Execution and Closure of Test activities
• Involved in kick-off meetings with Business and System Architects to understand scope of the projects and provided estimations using the Prime’s estimation template
• Creating test artifacts like test plans, test cases, traceability, test summary reports
• Developed and executed the test scripts by using SAS EG
• Uploaded and ran the test cases in ALM, generated weekly status reports, distributed to the project teams
• Attended project meetings with respective project teams on weekly basis to keep status on track
• Tested and verified Business Object reports and worked with Business to align with their expectations, business requirements
• Opened defects for the issues found during testing and worked with team until they closed
• Worked and tested the urgent fixes for production issues
• Validated and performed testing with production data for specific marketplace extracts

Environment: SAS EG, Windows XP, DB2, Oracle, UNIX, Teradata, DataStage

Confidential - Atlanta, GA

Onsite Test Lead

Responsibilities:

• Responsible for Test Planning, Estimation, Monitoring, Execution and Closure of Test activities
• Gathered and reviewed business requirements/user stories and performed the gap analysis to ensure that the requirements/user stories are complete
• Involved in end to end life cycle of testing starting from requirements analysis till UAT/PVT/Production support
• Creating end to end test plans, executing the plans and managing all activities in the plans to ensure that allthe objectives are met
• Designed test scenarios, test cases
• Identified the test data and requested the lab team to configure the devices available for testing
• During the testing cycle, monitor the test progress by constantly assessing the work assignment to each of the resources and re-balance or re-allocate them as required
• Prioritized and assigned test cases, tracked status and quality of test deliverables
• Providing daily/weekly project progress reports to program management teams Confidential both client and organization end
• Adhering to the defect tracking process and monitoring defects to ensure they progress in a timely manner
• Participated in the daily status calls Confidential end of the day for both offshore/onshore and discussed about status, issues, concerns related to project
• Liaising with the project stakeholders to ensure issues are communicated and addressed
• Created and maintained online library ofprojectknowledge documents

Environment: Siebel CRM, Oracle, Amdocs OCX/OMX, Windows 7, Mainframes

Confidential - Irvine, CA

ETL Test Lead

Responsibilities:

• Understand the domain, business requirements and e2e architecture of the systems
• Participate in initial meetings with business, development to understand the project requirements /implementation
• Prepare the test plan, test estimates and review, sign-off from business, development
• Identify e2e scenarios, map to the requirements and review, sign-off from development
• Assign the scenarios to the offshore team to write the test cases
• Refresh the test environment Confidential application, database level and make it ready for test execution
• Divide the test cases between offshore team and track the execution status on daily basis
• Execute the test cases in Quality Center and log the defects in Jira
• Mapping the traceability between Jira story points/QC requirments and test cases in Quality Center for coverage
• Link the defects in Jira to the test cases in Quality Center for tracking of the issues
• Attend the daily, weekly meetings and keeping the projects on track
• Prepare the daily and weekly status reports according to the different project schedules
• Worked with offshore team, assigned /divided the tasks and managed the day to day activities
• Involve in the automation of the test activities and provide the requirements, test scenarios to automation team
• Worked on database migration from Sybase to SQL Server and automated the test scenarios
• Perform the dry run on the automation tool for the test scenarios completed in earlier releases to verify the functionality and performance of the tool

Environment: SQL Server, Sybase, Oracle, UNIX and Windows 7

Confidential - Denver, CO

Sr. ETL/BI Test Engineer

Responsibilities:

• Responsible for extensive client interaction in order to estimate activities, design Test Plans/Strategy and monitor the project QA deliverables
• Attended the Requirements reviews, Design reviews, Code reviews to understand the overall process flow and Source to Target mappings
• Prepared end to end ETL Test Cases for the ETL mappings developed through Informatica tool from the business requirements
• Involved in extensive Data validation, Data load by writing SQL queries on source, target databases and worked on data quality issues
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects
• Deep understanding and working experience on Procurement and Spend Subject Areas in OBIA
• Knowledge on Oracle Spend Classification and implemented on top of OBIA
• Defined entry / exit criteria and provided continual risk assessments to senior management
• Validated data Confidential different levels between source tables, stage tables and target tables
• Performed data validation, constraints check, record counts, source to target mapping, random sampling and error processing
• Identified the issues and analyze the root cause in ETL jobs by verifying the session logs from Informatica and Autosys logs
• Tested and validated the Ad-hoc (Out of Box - OOB), Drill-down reports with filters and conditions, Dashboards on OBIEE by running the SQL queries against the source database
• Preventing occurrences of multiple runs for incremental load by flagging processed dates
• Proactively communicate system and test issues clearly with internal and external stakeholders on the project team
• Tracked the defects using Clear Quest, test cases using Quality Center (ALM) and generated defect, test case summary reports
• Solid understanding of e2e architecture and different environments like Dev, QA, UAT with source, stage, target levels
• Participated in daily and weekly status meetings with the management team and walkthroughs
• Identify improvement areas to enhance and streamline existing quality assurance (QA) practices

Environment: OBIEE, Oracle, UNIX and Windows 7

Confidential - Southfield, MI

Sr. ETL Test Engineer

Responsibilities:

• As a Senior ETL Test Engineer, worked closely with Business Analysts, Architects and Developers for thorough Requirements review for developing the End to End Test Scenarios
• Developed and managed Test Plans including the identification of Detail ETL Test Scripts and the definition of data pools to ensure the developed functionality performs as per requirements
• Prepared the End to End Test Scenarios and executed the same by understanding the end-user requirements
• Verified column data mapping between Source and Target databases
• Reviewed Detail ETL Test Scripts and coordinated with business for process approvals
• Performed the Gap Analysis between the Business Requirements and Technical Design documents
• Documented the Gap Analysis missing requirements and escalated to Test Manager and Test team
• Created new ETL Test Scripts for missing requirements and reviewed with Business and Test teams
• Logged the Defects using Jira, retested, verified and closed with proper Root Cause
• Executed the ETL Test Scripts in Zephyr and prepared different types of status reports, Burn down charts
• Prepared and ran SQL queries on Source and Target databases
• Ran the Jobs / Workflows using Informatica Power Center Client for ETL process and verified the data in Target database after ETL process
• Involved in Test Execution, modification of the ETL Test Scripts and Defects verification
• Performed end to end testing of Data Warehousing system
• Prepared Estimations and performed task allocation to the team members on priority and deliver the same
• Involved in Production Support and retested the Hotfixes
• Attended the defect triage meetings to review the defects which were created by Test team
• Prepared the Daily status and Weekly status reports and attended daily meetings for smooth deliverable
• Performed verification, validation and transformations on the Input data before loading into Target database
• Created Major requirements issues as Observations in Jira for tracking
• Worked with Functional / Development and Business team for any issues identified while testing the application
• Involved in Preparation of Test Results, Test Summary documents
• Escalated the issues about project requirements/execution to Test Manager

Environment: DB2, Oracle, UNIX, Mainframes and Windows 7

Confidential - Middletown, NJ

ETL Test Specialist

Responsibilities:

• Involved in review of ETL Specification and Detailed Technical Design documents for Test process by interacting with Business and Development teams
• Preparation of ETL Test Cases for validation of business functionality
• Conducted and actively participated in reviews, walkthroughs of ETL Test Cases
• Coordinating all applications Confidential onsite and offshore teams involved in the End to End execution
• Prepared draft Test Plans/Test Schedules with inputs from Test Manager and Test team
• Verified the data in Target database after ETL process
• Executed the ETL Test Cases and logged the defects in to QC
• Performed the validation of record count, data and column mapping
• Prepared Test Data by modifying the sample data in the source systems, to cover all the requirements and scenarios
• Validated the load process of ETL to make sure the Target tables are populated according to the data mapping provided that satisfies the transformation rules
• Performed RCA on critical issues and communicated same to developers to fix issues
• Prepared Daily and Weekly Status Reports
• Preventing occurrences of multiple runs by flagging processed dates
• Involved in Result analysis and generation of Status Reports in Quality Center

Environment: Oracle, UNIX, Windows 7, Siebel CRM

Confidential - Atlanta, GA

Sr. Test Analyst, Quality Lead

Responsibilities:

• Responsible for Test Planning, Estimation, Monitoring, Execution and Closure of Test activities
• Involved in BRS, SRS, HLD reviews with Client Business Process Engineers, Tier1, Tier2, Tier3 System Engineers, Integration Leads and understood the End to End flow of the System
• Participated in the High Level Test Scenario reviews and identified the gap between High Level Test Scenarios and SRS
• Understood the High Level Design document for each application in End to End flow
• Authored the End to End Test Cases, getting base lined from IBM, Client and uploading them in to Quality Center
• Executed the Test Cases and logged the defects in to QC
• Participated in Daily Status Calls with Client team
• Executed Tests as per the Test Plan, Test Strategy and Test Schedules
• Prepared Daily and Weekly Status Reports
• Coordinating all applications onsite and offshore teams involved in the End to End flow during execution
• Performed RCA on critical issues and communicated same to developers to fix the defects soon
• Driven defect identification, tracking, resolution and conduct defect Triage meetings
• Responsible for identifying if the requirement change is needed or if the system is working as per requirements
• Reviewed the Test Cases prepared by team and to ensure get base lined
• Managed the offshore team by providing all kind of support/help required in their day to day work in the project assignment
• Responsible for ensure the new requirement do not break the Business as Usual flow
• Provided training on End to End ASE Business Process flow to Graduate Hires in the team
• Prepared Data Validation Test Cases to support backend testing
• Prepared Test Results Summary Report with screen prints of each validation of new requirement as hand over deck to Client Business Process Engineers
• Prepared Desktop UAT and Fallout Determination Matrix for each release
• Supporting UCT and ORT
• Performed Automation Testing using QTP for Sanity and Regression Testing
• Given Demo on End to End Business Process flow to Client BPE’s and End Users
• Supported for Production issues, helps End User to understand the End to End flow and try to get issues resolved soon
• Establish a Quality Procedure to the team and audit to ensure that the team meets the Quality Standards

Environment: Siebel CRM, Oracle, Amdocs Cramer, Windows XP, Mainframes

Confidential

Module Lead and SME

Responsibilities:

• Participated in BRS, Macro and Architecture documents reviews
• Identified the End to End System flows and mapped to the BRS, Macro documents
• Authored Test Scenarios, Test Cases based on BRS, Use Cases, System Flows, Macro and getting base lined from respective vendors and Client
• Reviewed and approved the Test Cases written by team members
• Involved in Sanity, Pairwise, End to End and Pre-Production Testing
• Prepared Test Reports Confidential the end of each testing phase
• Reviewed the deliverables from offshore and get a sign off on the same from Client
• Involved in daily stand-ups and bug triage meetings
• Reviewed and approved the System Testing, Pairwise Testing Test Cases
• Participated in Test Execution and reported the defects using QC
• Prepared the Requirement Traceability Validation Matrix for each build /drop and mapped with the Test Cases
• Logged 50+ defects in a release
• Tested the TIBCO middleware and verified the WSDL’s using SoapUI
• Identified the Regression Test Suite from previous releases and executed on current release
• Worked closely with the Development and Release Management teams for smooth execution and release
• Involved in Daily and Weekly Status Meetings with respective vendors and Client
• Handled Recharge, Voucher Management and Top Up modules in End to End
• Prepared Daily Status Report and Weekly Status Report
• Tested the Android apps on different devices (Mobiles, Tablets) and validated e2e functionality
• Provided KT on TopUp and Recharge flows to other module / team members
• Worked as a Point of Contact / Subject Matter Expert for Top Up and Recharge modules
• Involved in the Demo to the Business and prepared Test Results Summary Report

Environment: SAP CRM, Estel, TIBCO, Ericsson Telcordia, RTTC, SAP CC, SAP CI, Windows XP

Confidential

Test Analyst

Responsibilities:

• Understood the SRS document and participated in review meetings to discuss the issues in product
• Authored Test Cases and Test Conditions on Health, Exam, Hostel and Transport modules
• Reviewed and updated Test Cases for every new build
• Performed the Test Cases execution
• Involved in Functional Testing, Re-Testing and Regression Testing
• Defect Tracking using Bugzilla
• Involved in Weekly and Daily Status Reporting

Environment: VB.Net, MySQL, Windows 2000