Elt Test Consultant Resume
SUMMARY:
- 8+ years of Experience in Software Testing (Manual, Automation, SOA & ETL)
- Contributed in preparation of Test Plan, Estimating & Planning of the Test Schedule, Efforts, Resource Utilization for Optimized Project delivery
- Immense Proficiency in Project setup, Team Handling & Mentoring, IPMS activities & Trainings associates.
- Proficient in Black box and Grey box Functional Testing
- Expertise in Defect / Test Management - HP ALM, TTPro, Smart Test Manager & VS Test Manager 2010
- Hands on experience on preparation of Test Deliverables and Reports i.e. QA Metrics, Test Deliverables, Requirement Traceability Matrix.
- Effective contribution in Designing & Executing Module/System/End to End Test Cases/suits, Test Scenarios
- Executed effective Review System in Projects at Self / Peer / Lead / Cross Team Level
- Contributed in Evaluating Test Results/Defects using different Charts & Pivot to retrospect and optimize STLC.
- Effectively handled and contributed in Onshore/Offshore Team Management, Mentoring & Resourcing
- Coordinating with Client & Business teams to gather, understand & document the Requirements.
- Proficiently Coordinated with customer, business owners & vendor partners for manage, estimate & execute Change Requests throughout SDLC/ Agile - Scrum.
- Contributed to train, mentor and setup Automation team using QTP along with first hand experience on it.
- Hands on experience in SoupUI Web Service Testing using assertions.
- 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.
- Extraction of test data from tables and loading of data into SQL tables.
- Validated the data in the reports by writing simple to complex SQL queries in the transactional system
- Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
- Conducted and actively participated in reviews, walkthroughs of test cases.
- Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.
- Executed the workflows in the workflow manager, to start the ETL process.
- Tested the entire data reconciliation process for multiple source and target systems.
- Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
- Maintained the data integrity and security using integrity constraints and Data base triggers.
- Worked on UNIX Shell scripts
TECHNICAL SKILLS:
Database: SQL Server, Oracle
Testing Tools: Smart Test Manager, HP ALM, QTP, VS Test Manager 2010, TTPro, TFS
Methods: SDLC, Agile - Scrum
Domain Experience: Airline, Automobile & Dealerships Management, e-Commerce, Mining, Logistics
Management Experience: Client Communication, Requirement Management, Team Management, Estimation, Reporting, On Shore - Off Shore Coordination, Change Request Management
PROFESSIONAL EXPERIENCE:
Confidential
ELT Test Consultant
Confidential
Assistant Consultant / CR Manager / Onsite Test Coordinator
Confidential
Assistant Consultant / Team Lead
Confidential
IT Analyst / Test Lead
Confidential
Sr. QA Engineer / Team Lead
Confidential
QA Engineer / Module Lead
Responsibilities:
- Track multiple types of programs per customer, separately or simultaneously
- Manage customer-specific pricing and multiple maintenance billing options
- Enforce contract requirements, such as order and reorder minimums
- Track license consumption by points or units, eliminating exchange rate concerns, or dollars etc…
