Professional Profile:

• 6 years of experience in IT Industry
• Having good knowledge of Software testing process
• Experience in Manual Testing, Database Testing of the Software application
• Experience in using Quality tools for Control and Improvement of the SDLC process
• Involved in Functional, System, Database, Integration Testing and Regression testing
• Knowledge on the Test management tool like Mercury Quality Center
• Experience in developing data warehouse applications in Extraction and transform loading process using ETL tools
• Indepth knowledge on POS Point of Sale systems.
• Good understanding of development lifecycle of projects with Informatica
• Expertise in working with SQL queries and PL/SQL Stored Procedures, Triggers, Packages/Functions
• Ability to co-ordinate effectively with development team, business partners and end users
• Experience of working in environment with a mix of onsite-offshore Global Delivery model

Technical Skills:

Work Experience:

• Worked as a QA analyst in Wipro Technologies from Jan 2013 to present
• Worked as a ETL developer/Tester in Aditya Birla Minacs from Jun 2009 to Oct 2012.
• Worked as Senior Tester in Hi-Touch Management Consultancy Pvt Ltd. from Nov 2006 to Jun 2009
• Worked as Programer Analyst in Xplore-Tech Services Pvt. Ltd from Jun 2005 to Nov 2006

Project Profile:

Role : QA Analyst

Description: TJX is a leading off-price retailer of apparel and home fashions. In the US, they have three divisions T J Max, Marshalls and Homegoods. The project is MS Patch Management. Microsoft patches are applied to corporate servers every month to meet compliance. When the patches are applied to QA/test servers then QA performs a regression test to ensure that the patches do not negatively impact existing functionality of the POS system.

Responsibilities:

• Developed detailed test cases with all the steps, which can be executed by business users without any help.
• Tested regular and dot net patches released by Microsoft every month.
• Testing included SQL database verification, distributing work objects to a lab via remoteware, ringing transactions at the register and Store Functionality Test.
• Negative testing to ensure manual remediation steps will work if patches fail to apply to one or more system.
• Used MKS Integrity Software for defect tracking.

Project 2 Aditya Birla Minacs :

Confidential

Role : Functional and Database tester

Description: The project was to design, develop and maintain different Data Marts which included General Ledger, Bar Code Med Admin and Chart access. The data used to come from oracle database and in form of flat files and was loaded into the target using Informatica.

Responsibilities:

• Prepare database test plan and test stategy
• Identify key test scenarios, which needs to be tested after application is deployed.
• Develop details test cases with all the steps, which can be executedby business users without any help.
• Prepared Test Metrics and Traceability Matrix
• Bug logged continuously and updated the status in QC till it closed.
• Involved in creation of Logical Data Model for ETL mapping and the process flow diagrams.
• Worked with PL/SQL developer to write the PL/SQL code for data manipulation.
• Involved in unit testing of the mapping and PL/SQL code.
• Developed mappings to load data in slowly changing dimensions.
• Utilized Unix Shell Scripts for adding the header to the flat file targets

Role : QA Analyst

Description: Confidential presents the evolution of media buying integrated, open, cross-platform technology that maximizes intelligence and efficiency in the media buying process. It is powering the future of media buying. The project is based on testing and analyzing the digital and analog applications for media related clients.

Responsibilities:

• Involved in creation of test plan and test cases for testing the enhanced functionality of MBOX.
• Analyzed the systems, met with end users and business units in order to define the requirements.
• Execute end to end test cases and analyze result before logging defect in QC
• Developed and test ETL code by the business logic defined in the Functional Design Document.
• Partnering with project managers and development resources to assist with design changes and design decisions.
• Worked with creation of reports for decision support.
• Involved in analysis of the data in the development and test environment.
• Work with analog team to test the existing application.

Confidential

Role : Functional Analyst

Description : Confidential is a full-service commercial bank providing an array of financial services to individuals, small businesses, middle-market companies, and major corporations.

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis, and testing and project- coordination.
• Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
• Prepare test framework for database testing
• Involve in Test plan and Test stategy preparation
• Design Database and functional test cases.
• Execute database test cases through Toad tool.
• Use Mercury QC for test cases uploading and bug logging
• Create tracebility matrix in QC
• Prepare different metrics for the customer and management
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Confidential

Role : Data warehousing tester

Description : Confidential provides the highest quality reinsurance products and customer services in the market. XLRe is located in different locations all over the world. It is in the process of bringing all the data under one roof.

Responsibilities:

• Understand the business functionalities of XLRe Latin America, Greenwich Insurance Company, Indian Harbor Insurance Company, XL Europe Ltd and XL Singapore-Sydney OBU's data and convert them into Destiny Application based on Destiny Business rules.
• Involve in test plan creating
• Create data warehousing test cases
• Identify the Test Scenario for the Regression Testing Application.
• Extract the data from RSG application to staging area thru flat files and Tables.
• Upload the data from staging area into Destiny database
• Create unit test cases and participate in the test case review process
• Use of QC in every phase of the testing, from requirement phase to logging bug.
• Track requirement coverage through Mercury QC
• Extract the data from RSG application to staging area thru flat files and Tables.
• Extensively used PL/SQL to embed complex business logic in stored procedures.
• Involved in supporting the project and resolved production issues.
• Worked closely with database administrators and reporting team to ensure data is refreshed for each cycle and balancing the reports of converted data

Role : Functional Tester

Description Confidential is one of the top most leading pharmacy companies. Caremark provides health insurance in low cost by providing the best solution through the Caremark sites. People can find a best drug in the low cost through caremark site and caremark provides the health insurance for the people.

Responsibilities:

• As a team member involved in collecting all the requirements for building the project.
• Test Strategy and Plan Preparation
• Test Case Preparation, Review Modification
• Maintains daily status report and sending of weekly data to the onsite team.
• Developed the traceability Matrix for the project
• Interacted with the client for the proper testing flow.
• Logged bugs in the QC.
• Involved in Creation and designed required tables, indexes and constraints for all production activities.
• Used SQL, PL/SQL for database related functionality.