SUMMARY OF QUALIFICATIONS:

• Nine and half (9.6) years of IT experience as Test Lead in Manual and ETL testing and Module Lead in ETL Development.
• Excellent work experience in Quality Center(ALM). Experience in Defect tracking tools like JIRA and ETL Tools like Datastage.
• Experience in Testing Methodologies, Designing Test Plans and Test Cases, Verifying and Validating various applications and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Expert in developing Test Plans, Scenarios, Test Cases, Test Steps. Involved in extensive testing of ETL and web application. Experience in User Acceptance, Back - end, Regression, Functional and Performance testing.
• Involved in writing and enhancing script. Performed Bug and Defect reporting using reporting tools such as Quality center, JIRA and locally developed tools. Involved in maintaining Test Matrix. Excellent troubleshooting, analytical, interpersonal and communication skills.
• Experience with Web Application testing and ETL testing. Experience in developing business based functional test scenarios. Expertise in Problem solving and Bug Tracking Reports using Bug tracking Tools. Scheduling, assigning task and coordinating with the team members.
• Expertise in End-to-End, Functional, Integration, Backend and Regression, UAT Testing. Excellent problem solving skills and testing experience in complex Business systems. Involved in testing methodology.
• Possess Strong analytical and Problem solving skills. Worked as team member as well as Independent. Involvement in various stages of Software Development Life Cycle (SDLC).
• Experience in writing System test plans, defining test cases, developing and maintaining test scripts and documenting all phases of QA process.
• Expertise in both Agile and Waterfall methodologies.
• Experience with working in Database DB2, SQL Server,Oracle and Teradata. DB2 still using in current project. SQL Server is used in old projects, Integration between Taradata and Oracle is used in an other old projects when worked in Datastage tool.
• Experience in analyse and create mappings if required and help the business team to make sure that all the requirements related to the application and its database are aligned properly.
• Experience in explaining the same mappings to the the team and get the questions clarified before the iteration starts.
• Experience in the ETL tool like Datastage both as a Developer, Tester and also worked in Test Data Management team to identify, create and load the data needed for the testing team.
• Expertise in working on ALM for the test case management activities like writing Requirements, assigning them to the respected Test cases, Assuring team members to follow the standards according to format approved by the clients, Executing the test cases on time by all the team members in Test lab and making sure that all the defects raised are linked to the proper test case executions and the proper documentation/test results are maintained with screenshots of application and required DB quiries are saved in the share path and linked to the executions.
• Experience in working on JIRA and Version One tools for Defect Management in Agile environment.
• Experience in supporting the reporting team when worked as an ETL developer to complete the project deliverables on time when ever dependency is needed.
• Experience in working closely with Development team as a QA Lead in Test Driven Development approach.
• Experience in working closely with Business Analysts and Data Architects to know the exact functionality of the Stories and also to know the Data flow between different tables in the system which has to be shared with the entire QA team before the every iteration of the release.
• Experience in discussing with the team members and client about the defects raised in a daily basis by conducting Defect Triage meetings and finalizing the defect's priority, severity with the business and the date fix and retest from the Development team.
• Experience in setting up the meetings with the Automation team leads to summarise what can be automated in the application and what are the Regression tests that should be done as part of each release and help them to give the information on the Back end testing (DB testing) support given when ever required.
• Able to learn new tools as quick as possible as I have both Development and Testing experience and also worked in many domains like Retail, Banking, Finance and Mortgage industries.
• Experience in working in Onsite/Offshore model as most of the projects I worked followed the same model and also lead the team which also involves coordination activities between the team and the client.
• Experience in generating and giving the reports of testing/status in a daily basis to the clients, identifying the issues involved and providing the necessary solutions to fix the issues and to make the deliverables happen on time.
• Excellent team player and able to involve people to execute the project successfully.

TECHNICAL SKILLS:

Testing Tools: Quality Center/ALM, JIRA,VersionOne.

Methodologies: SDLC, STLC, Agile.

Operating Systems: Windows XP, Windows 98/00/Vista.

Databases: MS SQL Server, DB2, Oracle.

Languages: C, C++

Other Tools: Datastage.

PROFESSIONAL EXPERIENCE:

QA Test Lead

Responsibilities:

• Analyzed System specifications, design, development and execution of Test Plans and Test Cases for User Acceptance testing
• Involved in various phases of functionality, regression testing, integration testing and User Acceptance testing.
• Used Quality Center for Identifying the Full Test Coverage. Tested the Web Application for all the functionalities. Organized and managed planning and execution of Test Cases and tracking and fixation of the errors/defects using Quality Center.
• Interacted with the developers and other team members to ensure high quality software. Played a key role in timely delivery of the product.
• Contributed to Risk Management Plan, Communication Plan and Test Plan. Delivered Project Matrices like Defect Reports, Test Coverage, and Test Execution Reports.
• Prepared the Execution plan and assigning the Task to coordinates with the Delivery of WSR (Weekly Status Report) and MSR (Monthly Status Report)
• Analyse the existing system.
• Coordinate with various team members to ensure smooth co-ordination of the projects
• Conduct knowledge sharing session thereby minimizing resource dependencies.

QA Test Lead

Responsibilities:

• Analyzed System specifications, design, development and execution of Test Plans and Test Cases for Manual testing
• Involved in various phases of functionality, regression testing, integration testing and system testing.
• Used Quality Center for Identifying the Full Test Coverage. Tested the Web Application for all the functionalities. Organized and managed planning and execution of Test Cases and tracking and fixation of the errors/defects using Quality Center.
• Interacted with the developers and other team members to ensure high quality software. Played a key role in timely delivery of the product.
• Contributed to Risk Management Plan, Communication Plan and Test Plan. Delivered Project Matrices like Defect Reports, Test Coverage, and Test Execution Reports.
• Prepared the Execution plan and assigning the Task to coordinates with the Delivery of WSR (Weekly Status Report) and MSR (Monthly Status Report)
• Analyse the existing online banking system
• Coordinate with various team members to ensure smooth co-ordination of the projects
• Conduct knowledge sharing session thereby minimizing resource dependencies.

QA Test Lead

Responsibilities:

• Conducted walkthroughs and reviews with designers and developers to establish quality policy conformance. Involved in the development of system test plan and test scripts using business and system requirement documents.
• Tracked bugs and performed regression testing of the entire application once the bugs are fixed. Tested the POS Application for all the functionalities.
• Prepared the Execution plan and assigning the Task to coordinates with the Delivery of WSR (Weekly Status Report) and MSR (Monthly Status Report)
• Reviewed Business requirement documents with the business and development team to understand the architecture and functionality of the application
• Created Test Scenarios and Risk Analysis based on business requirements
• Report to Onsite Project Manager regarding the progress of the project.
• Conduct knowledge sharing sessions thereby minimizing resource dependencies
• Coordinate with various team members to ensure smooth co-ordination of the projects

QA Test Lead

Responsibilities:

• Involved in Writing Test Cases and used Quality Center for Mapping Test Cases with the Requirement and Test case execution.
• Prepared test status reports and Execution plan during test execution process. Written SQL scripts to pull the data from the existing database based on the business rules and updating the database tables for the Backend Testing.
• Interacted with the developers and other team members to ensure high quality software. Played a key role in timely delivery of the product.
• Interacted with Business Analysts and Developers in requirements analysis, design reviews, testing and documentation for application developed in Agile Process.
• Created Test Scenarios and Risk Analysis based on business requirements
• Assisted all agile teams as SME and implemented all test plans in accordance to need of development projects.
• Test the developed code against the test cases generated.
• Report to Onsite Project Manager regarding the progress of the project.
• Tested the derivation of GDSN and Kroger level attributes for unconverted(Mix-U) classes that will be roll out to class cutover on SQL Server platform.
• Reviewed and reported the defects in JIRA in the Defect triage meetings.
• Conduct knowledge sharing sessions thereby minimizing resource dependencies.
• Coordinate with various team members in onsite and offshore to ensure smooth co-ordination of the projects
• Involved in the test data setup analysis with the business team.
• Work with Meta data management specialist to document all changes in every iteration and walkthrough business impact
• Tested and coordinated the data stream from Vender Information Portal (VIP) to Data Migration platform using RDBMS
• Responsible to validate the various data sources(PID,E1,etc.,) to Data migration using SQL queries in each iteration.
• Worked with other feature teams to make sure to create spike/dependencies.
• worked with DBA to ensure all deployment (QA, Stage and Production support)
• Tested the derived reports (eg: supplier engagement) in each iteration by using SQL Server queries.
• Work with Data Architect at the train level BA and Technical team to gather all technical document and directions.
• Support during production deployment activities.

Onsite Lead

Responsibilities:

• Onshore/Offshore Coordination.
• Knowledge Transition to the team.
• Understanding the business specification documents and customer requirements.
• Prepared ETL Specification documents.
• Prepared the technical specification docs need for easy analysis of the project.
• Created mappings, sessions, workflows for performing the ETL action.
• Involved in Code review.
• Involved in Unit testing.
• Actions to take ensuring data availability on time.
• Analyzing requirements and seeking functional clarifications.
• Implementing enhancements.

Module Lead

Responsibilities:

• Onshore/Offshore Coordination.
• Knowledge Transition to the team.
• Understanding the business specification documents and customer requirements.
• Prepared ETL Specification documents.
• Preparing the technical specification docs need for easy analysis of the project.
• Created mappings, sessions, workflows for performing the ETL action.
• Involved in Code review.
• Involved in Unit testing.
• Actions to take ensuring data availability on time.
• Analyzing requirements and seeking functional clarifications.
• Implementing enhancements.

Confidential

ETL Developer

Responsibilities:

• Understanding the business specification documents and customer requirements.
• Prepared ETL Specification documents
• Analyzing the Data according to the client’s requirements.
• Created mappings, sessions, workflows for performing the ETL action.
• Used most of the Transformations such as Aggregator, lookup, Filter, Join etc...
• Used Job parameters, Stage variable and created parameter files for flexible runs of workflows based on changing variable values.
• Optimized the performance by tuning the sources, targets and jobs
• Involved in Code review.
• Involved in Unit testing.
• Automated the flow of execution using sequence.
• Planning activities based on requirements.

 ETL Developer

Responsibilities:

• Understanding the business specification documents and customer requirements.
• Prepared ETL Specification documents
• Analyzing the Data according to the client’s requirements.
• Created mappings, sessions, workflows for performing the ETL action.
• Used most of the Transformations such as Aggregator, lookup, Filter, Join etc...
• Used Job parameters, Stage variable and created parameter files for flexible runs of workflows based on changing variable values.
• Optimized the performance by tuning the sources, targets and jobs
• Involved in Code review.
• Involved in Unit testing.
• Automated the flow of execution using sequence.
• Planning activities based on requirements.