SUMMARY:

• ETL Test lead/ Tester, QA Test Lead /QA Tester/ Automation Tester
• Total of 10 years IT experience from ( Confidential ). 9 +years of experience in banking domain (Confidential ) and 1 - year experience in Telecom domain ( Confidential )
• Expertise in creating Test Strategy/Test Plan, Test Estimation, Test scenarios, Test execution, Defect management(ALM/JIRA) and Test summary reports
• Expertise in Workday - Participated in Requirement gathering sessions, Performed Test Planning, Functional Testing, End to End Integration Testing and lead an automation team.
• Expertise in analyzing Database structures/Data models, ETL Source to target mapping document and writing complex SQL queries to verify transformations and business rules from Source to Target and also worked on Micro strategy reports
• Expertise in identifying automation scripts for in sprint and regression automation
• Experienced in creating and running Automation scripts in selenium using TestNG Framework and adopted Page object model design(Gradle Template)
• Experienced in creating and running automation scripts using QTP
• Expertise in Scrum Agile and waterfall testing methodologies
• Facilitated Performance testing and Security Testing in SIT, UAT and PROD environments.

TECHNICAL SKILLS

Operating systems: Windows from XP to 2010, UNIX

Languages: SQL, Java, VB scriptReporting Tools: : Micro strategy reports

Database: Oracle 9i/8i/8/7.x, SQL Server, Netezza 6, 7

SQL Query Tools: Toad Data Point Toad Data Analyst SQL Developer Toad for Oracle

Other Testing Tools: ALM(Defect Management), Quick Test Professional(QTP), Eclipse IDE, Version one, Jira, Putty

Webserver Applications: SharePoint

PROFESSIONAL EXPERIENCE:

Confidential

Data warehouse ETL Quality Analyst/ Automation Tester/Team Lead

• Coordinate with Business, Developers, Product Owners and Project Managers for delivery activities including but not limited to CIT, SIT, UAT and Prod.
• Analyze requirements/stories and create Test Strategy/Plan, Estimation, test scenarios, test scripts, defect management and test summary report.
• Perform Functional Testing on Workday Modules - Recruiting, Talent Management, Time Tracking, Absence, Benefits, and Payroll configuration scripts.
• Perform End to End integration testing for workday. Reports are created out of Workday and the EIB program sends the details to the server after which ETL is run to put the data either in ETL tables or back to the server and from there the data is transmitted directly to end user and they can read their mainframe datasets else data will be sent through EFX to the end user location. This involves testing of mainframe datasets, database tables and provisioning views
• Lead an Automation Testing Team to automate payroll configuration scripts and transactional scripts across modules
• Analyze in-sprint and regression test suite and identify candidates for automation based on business priority and return on investment (ROI) analysis.
• Create and execute scripts in selenium web driver based on Page Object Model design. Work on Gradle Template and TestNG framework. GIT is used as the central repository to maintain code.
• Contribute to the creation of test automation framework that is customized to client’s application and technical landscape using selenium
• Create and execute SQL queries, as per the data model and ETL mapping documents to verify database structures, business rules, transformations and data quality checks
• Create SQL queries to verify micro strategy reports
• Review test data for ETL workflows and Automation use cases
• Lead a team of 20 resources and also performed invoice review and purchase orders for the projects worked in my space.

Confidential

ETL Quality Analyst / Test Coordinator

Responsibilities:

• Analyzing the requirements by coordinating with line of business and providing Estimation.
• Preparation of Test plan and Test scenarios
• Preparation of traceability matrix by mapping requirements to test cases
• Provide suggestions to improve user interface functions and coordinate to implement that as change requests
• Preparation of SQL Queries to verify the transformation from source to target as per ETL mapping document and data model.
• ETL verification of business rules for key business elements received from various sources
• Execution of SQL queries in UAT environment using macros and documenting results
• Identify risks and mitigate issues
• Defect management and Metrics preparation and providing reports to stake holders
• Perform integration End to End testing in UAT environment
• Perform Functional testing and ETL testing in Production environment
• Coordinate production release for all applications

Confidential

Test Coordinator

Responsibilities:

• Responsible for raising defects in ALM for the issues raised in defect management tool - SolMan(Solution Manager)
• Coordinate with developers from different components and triage issues and close it.
• Provide status of daily FPP file run to onshore
• Prepare FSR dashboard for different stakeholders

Confidential

QA Analyst/Automation Tester

Responsibilities:

• Participate in requirement analysis of Customer Experience stories and provide estimation. Work in AGILE scrum Methodology.
• Prepare Test Plan, Test estimation and Test scenarios by coordinating with business Analyst
• Prepare automation test cases in QTP and perform Test Execution
• Prepare Traceability Matrix by mapping requirements to test cases
• Execute SQL queries to verify database structures and business impacts
• Participate in E2E integration testing and execution of test scripts
• Defect management and reporting
• Provide suggestions to improve user interface functions

Confidential

QA Analyst

Responsibilities:

• Work for BAT (Billing and assurance), FTTP and FTTC teams (Fiber to cabinet and fire to premises) and execute new functionality and regression test cases. Work under Scrum Agile methodology.
• Analyze, create and review high level/Low level scenarios for CE stories.
• Conduct triage calls and involve in defect management and reporting
• Support GO-LIVE and warranty periods.