SUMMARY

• 6 years and 9 months of experience in ETL testing with over 4+ years of experience in Retail domain, 1+ year of experience in Banking domain and 1+ year of experience in Advertisement & Media domain
• Expertise in ETL Tool - Informatica and Teradata/Oracle database
• Expertise in Reporting Tools - GoodData and Micro strategy
• Expertise in data which includes data validation from Source File Extract through validation of Staging, Dimension and Fact tables.
• Experienced in Reporting projects which includes data extraction from EDW, validation of extracted data, sync up the data with the reporting tool work space, create graphs and reports as per the requirement of the customer and validate the reports against the source data.
• Expertise in Planning, Tracking and reviewing various Project Reports and presenting them to customer.
• Defining the scope of the project, providing the different level of estimate and word towards it
• Identifying the gaps and providing the ideas to fulfill the business requirements
• Leading a team with 8 resources (1- Onsite & 7 Offshore), across three scrum teams
• Create SQL queries based on the transformation rules and executed it and took ownership in handling the modules.
• Perform Lab testing against multiple devices
• Identify the testing risk & issues and follow the escalation procedure to mitigate it
• Providing RCA and recovery method for major/critical system issues
• Organizing the defect triage meeting and provide the observation to development team
• Following the Agile methodology to execute the test plan and deliver within the committed deadline
• Presenting the live demonstration to business, development and testing team
• Got a lot of appreciation’s from clients and managers against team handling and 0% defect code delivery

TECHNICAL SKILLS

Test Management Tools: JIRA, HP Quality Center, Zephyr, Mingle

File Management Tools: WinScp, FileZilla 3.7.3

Operating Systems: Windows XP/2008/7

Database: Teradata, Oracle, SQL Server 2012, DBeaver

ETL Tools: Informatica 8.6/9.1/9.5, Cloud connect 94.2/99.1

BI Tools: Micro strategy, GoodData

Automation Tools: UFT (vbscript), Selenium (Java) Beginner

Other Tools: UNIX, Mainframe, Qpasa, AppWatch, StarTeam, AnthilMicrosoft Visual Studio 2010 (cURL), SoapUI

Domain Skills: Retail, Media

Testing Type: Manual, Web, Functional, ETL, DWH

PROFESSIONAL EXPERIENCE

Confidential

Test Engineer

Responsibilities:

• Create SQL queries based on the business/transformation rules and execute them in the Teradata database
• Ensure all the business/transformation rules are included in a single query written to validate a table
• Validated the data between Tables/Files - Files/Tables
• Design test cases as per the requirement, Execute them during execution and upload in the test management tool
• Send Daily status reports (DSR) to team, clients and stakeholders
• Gained knowledge in the preparation of the Test plan and Test closure document
• Handled a project individually and shared the knowledge to the peers who joined later
• Effectively communicated with the Onsite counterpart

Confidential

Senior Test Engineer

Responsibilities:

• Create SQL queries based on the business/transformation rules and execute them in the SQL server database
• Validated the data between Tables/Files - Files/Tables - Reports
• Created test plan, test cases and test closure documents for various Projects (Subject areas)
• Played a key role in the team to handle the tasks of the team lead
• Took up additional responsibility to debug the errors in Informatica /Good data and provide a detailed defect report with the fix required for the QA
• To prepare task lists for team members on daily basis and Mentor the team members
• Send Daily status reports (DSR) to team, clients and stakeholders
• Deployed project across various environments including INT, UAT and PROD
• Supported client on UAT deployment
• Provided Demo to client on projects at initial phase
• Responsible to co-ordinate with the Indian customer located at Gurgaon and Business users (UAT users) located in United States of America
• Involved in end to end tasks ranging from gathering requirements to UAT Signoff for major platform upgrade in the area of individual SA
• Working with third party teams in managing the outside stake holders for the customer
• Involved in the Project meetings to represent the QA and Propose challenges and Status
• Providing knowledge transition to Business user who has on boarded at business front
• Trained and Arranged for trainings to teams on different areas of Business and Technical side to keep competent

Confidential

Senior Test Engineer

Responsibilities:

• Created test plan, test cases, test report, test data, DB refresh and traceability matrix documents for various Projects (ITPR’s)
• Reviewed test plan, test cases, test execution and test result document for other team members
• Create SQL queries based on the business/transformation rules and execute them in Oracle/Teradata database
• Validated the data between Source Tables/Files - Lookup Tables - Target Table
• Took up additional responsibility to debug the errors in Informatica/UNIX(Bteq) and provide a detailed defect report with the fix required for the QA
• Performed Data loading across various environments which includes QAT and UAT
• Played a key role in the team on assigned ITPR projects
• Mentor the team members
• Send Daily status reports (DSR) to team and onsite coordinator’s
• Involved in the Project meetings to represent the QA and Propose challenges and Status
• Got appreciation from Onsite coordinator’s regarding my performance

Confidential

Senior Test Engineer

Responsibilities:

• Created test strategy, test cases, test data and trace-ability matrix documents
• Create SQL queries based on the transformation rules and executed in Mainframe Database
• Validated the data between Source Tables/Files-Target Tables-Output Files
• Validate XML request and response through SOAP-UI
• Took up additional responsibility to debug the errors and provide a detailed defect report
• Performed data loading in QA environment with different set of data's
• Took ownership in handling the modules
• Identified the core points missed in design and intimate to developer
• Update Daily status reports (DSR) in the shared drive
• Involved in the Project meetings without any slippages
• Quickly grasp new technology and also adapt to it
• Flexible in adapting to new domain and learned the terminology quickly