PROFESSIONAL SUMMARY:

• Approx 7 years’ experience in ETL/MDM/QA testing (Manual and Automation Testing) processes in SDLC methodology. Test Planning, Test Case Design, Test Script Development, Test Environment Setup, Test Data Setup, Defect Management, Test Log, Test Result and Traceability Matrix.
• Expertise lies in ETL testing, Functional testing, Back end Testing, Regression testing, User Acceptance testing UAT, System Integration testing, Smoke testing, Performance testing, Load testing and stress testing in mobile handsets and web based applications.
• Extensively worked on the diversified industry areas e.g. Banking, Insurance, Retail Management, Capital Markets, Telecom, Enterprise Data Warehouse, Financial Crimes and Transaction Monitoring, Corporate Solutions, Risk Assessment etc.
• Responsible to certify the Production data before implementing to various downstream(s) through MDM.
• Good knowledge on Informatica Powercenter - ETL Development tool comprises components such as Repository, Mappings Designer, Workflow Manager & Workflow Monitor.
• Focal point for the Production deployment support occurring every month (MDM releases)
• Excellent understanding of requirements and creating test cases out of Business Requirement Document and Functional Requirement Document. Strong working knowledge in testing all phases of SDLC and STLC and expertise in Waterfall, V-model, Agile with SCRUM lifecycles.
• Hands on experience in working with agile driven projects and worked closely with Scrum Masters, Product Owners.
• Within the overall work tenure, also performed 8 months coding in Application development on C/C++/UNIX platform and 2 months of Audit Readiness experience as part of Control Gaps testing in the different LOBs within the bank.
• Played a key role in creating testing tasking Agile Projects and attended Sprint planning, Scrum Calls, Sprint review meetings.
• Experienced on Service Oriented Architecture and tested SOAP Web Services by using tool like SOAPUI and validated the response XML file.
• Performed Back-end testing using SQL Queries to make sure that data entered has been uploaded correctly into the SQL Database. Write complex SQL queries for retrieval of required data using TOAD..
• Experience in using the Test management and Defect Tracking tools like HP Quality center, Application Lifecycle Management, JIRA.
• Extensively worked on creating Test Summary Reports, Requirements Traceability Matrix and Defect reports.
• Worked on Database/Backend testing and validated the data by writing SQL Queries and experience in working on Oracle and SQL Server databases.
• Excellent knowledge of Agile Scrum development environment, multiple web browsers, and automated testing suites.
• Having excellent problem solving and analytical skills and experience of test plans, strategy and Procedures throughout the life cycle of a project from specification reviews through to User Acceptance.
• Onsite-Offshore Coordination adhering to a Global Delivery Model.
• Review requirements and design documents with developers and quality assurance manager to confirm expected functionality with technical and business needs.
• Implementation, evaluation, and documentation of the developed test cases and scenarios
• Determine test environment and test data requirements, often in concert with integrated systems’ owners.
• Capable of working independently or as part of a QA/Project team, as required by the project. Able to effectively and cooperatively interface with all levels of management and staff.

TECHNICAL SKILLS:

• Languages and Concepts known
• ETL Dev & Testing Tools
• Master Data Management
• SQL
• ETL and Data warehouse concepts
• Web based application flow
• Test Data Management
• C, C++
• UNIX
• UAT
• Performance testing
• Sharepoint
• VB scripting
• Manual Testing, UI Testing, Integration Testing, Regression Testing, Black Box Testing, Sanity testing, Smoke, BlackDuck and Ad-hoc testing.
• Waterfall, Agile/Scrum, SDLC, STLC, Bug life Cycle
• Release Management - ServiceNow
• Toad for Oracle 10.6
• IBM DB2
• SOAP UI
• Data Steward UI
• Hermes (Message Queues)
• Informatica Powercenter 9.5.1,
• MySQL
• Putty
• WinSCP
• JIRA
• HP ALM 11.0(Business Process Test Cases)
• Quality Center
• QTP

PROFESSIONAL EXPERIENCE:

Confidential

Release Coordinator

Responsibilities:

• Managing Project Management- Release and Change Management using ServiceNow by understanding business needs to implement in IT/Operations.
• Working on projects in Agile and Waterfall Methodology.
• Owns Continuous Improvement in ITIL Practices like change management through Agility in ServiceNow modules like Change Management and Release Management
• Owns Incident and Problem Management Module to ensure the minimal Outage in the Production Environment and Root Cause Analysis of existing issues.
• Manage project technical documentation including design, configuration, and installation for implementation and release.
• Change Agent to staff in all phases of development and implementation process.
• Redesigning Processes to leverage ITIL good practices, including Service Desk, Incident, and Problem Management ServiceNow. 
• Documenting Configuration Management processes and procedures.
• Working on ServiceNow Project Management to manage Project Life Cycle - Transition from Existing Tool to ServiceNow PPM. Waterfall and Agile Both.

Confidential, Los Angeles, CA

MDM QA Lead

Responsibilities:

• Created temporary tables for validations after understanding the transformation logic.
• Validated Message notifications under Pub Sub queues coming from MDM to the various downstream systems
• Validated Survivorship of the Party (customer) during Unmerge and Collapse Parties feature of MDM through Source as well as DSUI tool.
• Created Project, Test Suites, Test Cases and Test Steps in SOAP UI Tools and Validated the Response XML file
• Validated SOA XML Request and Response retrieved as part of various services like Get Party, Search Party and Maintain Party through SOAP UI
• Validated Initial and Incremental Loads of source system(s) into MDM.
• Validated Customer Metrics and Annual Survey performed source wise.
• Certified Production data and part of Production deployment- MDM releases.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Documented the validation rules, error handling and test strategy of the mapping.
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
• Extensively Used HP Quality Center QC /ALM as test management tool and Created and maintained the defects in HP Quality Center/ALM.
• Tested data sheets with Agile and Waterfall methodologies.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Conducted test case daily reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System ETL Mapping Document for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Defect triage with Business Analysts, Data Architects and Developers in order to identify valid defects.
• Responsible for going through the User Stories and creating Test Cases based on the mock ups provided in User Stories
• Create and implemented Test Plan, Test Scripts based on the Software Requirement Specification
• Generated Test Scenarios, Test Case and Test Data and executed test scripts to test the functionality of the application and regression testing.
• Updating the test plan document for every Sprint meeting
• Logging the bugs which are found during Manual Testing and Automation Testing the Suit
• Created automation test suites using data driven framework to test the web applications.
• Served as coordinator for all testing activities during the project.
• Responsible for writing the SQL Queries using Joins to retrieve the data using Toad.
• Shared Daily Status Reports with all the team members, Team Leads, Managers and Clients.
• Logged and tracked to verify the resolutions of software and its specification defects.
• Performed testing on Web Services using WSDL and SOAPUI to check the communication between different services.
• Making sure the resolved bugs are retested and closed if needed.
• Create and Execute automated test scripts for regression testing using QTP.
• Implemented macro logic using VB scripting to read data from the Excel to achieve functional testing with different data
• Involved in testing the Web Services like SOAP by using a tool SOAPUI.
• Involved in d eveloping, document and reviewing performance test plans and strategies to ensure the system can sustain the projected load/volume in production environment. 
• Involved in Planning, designing, implementing and executed Stress/Load/Performance Testing.
• Mapping test cases with the requirement using Requirement Traceability Matrix
• Involved in developing data driven test scripts and executes performance and load testing  of client products.
• Used JIRA as a bug tracking, issue tracking and project management software.
• Analyze the data gathered from performance  tests with an eye towards application, availability and capacity with the goals of ensuring the optimal user experience and reducing hardware costs. 
• Inserted Assertions like XPATH to validate the data against the database data in the response XML
• Developed SQL queries to validate the data integrity of the database

Confidential

ETL/Functional Tester

Responsibilities:

• Preparation of Test plan, Test Approach, Test Scripts, Requirement Traceability Matrix based on the requirements given in FRD/BRD.
• Writing complex SQL queries for querying data against different databases for data verification process
• ETL validation includes
• File Conformance
• Transformation Logic validation
• Referential Integrity validation
• Source to Target data comparison
• De-duplication validation
• Output MANTAS file validation
• Defect management
• Walkthrough on the overall testing process to the Client team.
• Daily basis reporting of Feed instance keys to entire FCTM file delivery system..
• Preparation of project documents like Application Testing Document, Project workflow docs on File conformance and Staging Validations.
• Analyzing the Business Requirement Document, High level and Low-level design documents.
• Performing Defect Leakage Analysis post every release and report it to the Management.
• Organize weekly meetings with Client leads & Onsite manager regarding the Automation status.
• Point of contact for Process related activities like Metrics reporting & Operation clarity.
• Review - Defect prevention plan and Software configuration management plan.
• Responsible for all aspects of project delivery (Test Design, Test execution and Test summary report) and management (Test metrics and Risk analysis) to client partners, offshore manager and Onsite manager.
• Organize weekly meetings with offshore managers, Onsite Coordinator & Onsite manager to discuss the Project goals and report the health of the overall project status.
• Preparation of Test plan, Test Approach, Test Scripts based on requirements given in FRD/BRD.
• Quality Control Workbook that includes Entry/Exit Criteria Gates
• Project Plan, Test Cycle Matrix documentation
• Test Data Analysis and management
• Rationalized BPT scripts creation
• Defect management/ Defect leakage metrics
• UAT support
• Daily Status Reports
• Other forms of testing like UI vs DB testing, Smoke Bed, Blackduck, Sanity Checks
• Updating the application down time in Environment Tracker during test execution phase.
• Performed Integration Testing in Vendor Development environment and System Testing in SIT environment and User Acceptance Testing in Pre-Production Environment.
• Involved Preparation of Traceability Matrix and mapping the Test Cases with the requirements and Test Metrics in Quality Center.
• Reported bugs in Quality Center with server logs information from Web and DB servers.
• Performed Regression Testing as part of every build.
• Developed SQL Queries for testing various Database validations.
• Independently creating and executing UFT / QTP scripts.
• As part of Audit Readiness within different LOBs of bank, testing the controls placed to remediate an issue identified during Audit.
• Validate their effectiveness and sustainability in the business.
• Present the test results to the Business stakeholders, Issue owners and Action Plan owners.
• Conclude the Closure rating.

Confidential

C/C++/UNIX Developer

Responsibilities:

• Understanding LLD and HLD documents
• Developed convertors responsible from converting payment transactions from different source systems.
• Analysis existing code in the PAID application and grapped generic code that is used/helpful in creation of further applications ( like: Swift tags for Ack and Nack in the code, how it was used in the existing functionality and its generic stubs)
• Inward and outward Message clearing flow
• Swift tags for Ack-Nack
• Malaysia RENTAS inbound/outbound clearing flow
• IMF to ICBC conversion
• CRF/EAPS to IMF conversion
• Creation of Technical Design document
• Unit testing and creation of UTC document.
• Involved in preparing Test data based on business functions.
• Involved in identifying the manual test cases for automation.
• Executing Test Scripts in QC tool for Regression Testing and analyzing the Test results.
• Finding and reporting defect in defect tracking tool Quality Center.
• Involved in giving daily and weekly status reports to clients.
• Involving in resolving valid issues and queries.
• Involved in creating Test metrics.
• Used Quality Center defect tracking tool to report application defects and enhancements request and discussed with developers to resolve technical issues.
• Performed different types of testing like Functionality, system, regression and Retesting.
• Developed Test Scenarios and Test Cases as per the requirement document.