SUMMARY

• Over 10 years of total I.T. experience of Quality Assurance, Datawarehousing and as a Business Analyst.
• Strong knowledge of all the phases of Software Development Life Cycle and worked on different SDLC methodologies such as Water Fall Model and Agile.
• Expertise in Data Warehouse, ETL testing, data migration/conversion testing. Experience testing MainFrame applications.
• 2 years of experience creating automation scripts using HP QTP. Working knowledge of Selenium WebDriver, Selenium RC.
• Extensive experience in creating test strategy, test cases from business, functional and technical requirements document. Performed Functional, System, Integration, Regression and User Acceptance Testing (UAT) by applying quality assurance principles and testing best practices.
• 3 years experience working as Business Analyst, facilitating JAD sessions with business users, created Business Requirements Document with use cases, technical work flow diagrams. Experience working with cross - functional team and off shore teams.
• Experience in mentoring Junior QAs, providing test effort, test status to upper management, risk analysis, representing QA team on daily calls.
• Extensive experience working on SQL Server 2000/2005/2008 . Performed backend testing, tested SSIS, DTSx packages. Created automated scripts in SQL, PL/SQL to automate testing efforts.
• Experience working on Informatica Powercenter 8.6.
• 3+ years of experience in HP QC 10.0, HP QC 11.0 ALM for traceability matrix, test execution, to track test execution status etc. 2 years of experience working on MS-Team Foundation Server (TFS) and JIRA. Worked on Agile Tools in TFS; example- Kanban, Sprint Planning, Defect Management, Reporting and Dashboards as requested by the Management team.
• 4 years of experience in Business Intelligence (BI) and Reporting tools, SSRS, Business Objects (BO) and MS-Excel.
• Self-starter, focused and pro-active. Able to handle multiple priorities and large volumes of work.
• Attention to detail. Have been recognized by my managers an d was given AT&T Customer Rules award to appreciate my hard work, attention to detail, thoroughness in testing and in depth knowledge about the tool.

TECHNICAL SKILLS

Testing Tools: HP Quality Center 11.0 ALM, Team Foundation Server (TFS) 2008, JIRA, HP Quick Test Professional 9.0

Relational Databases: SQL Server 2000/2005/2008 , Oracle 8i/10g/11g, AS400, DB2, MS-Access, TOAD.

BI/ETL/Reporting Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Reporting Services (SSRS), Business Objects, Informatica 9.5

Object Oriented/Event Driven Languages: Core Java, C, C++, Visual Basic 6.0, VB.NET

Scripting Languages: HTML, Java Script, VB Script, XML, PL/SQL

Reporting Services: SQL Server Reporting Services (SSRS)

Software: MS-Word, MS-PowerPoint, MS-Excel, MS-Visio.

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL QA

Responsibilities:

• Create and execute test cases to validate various SSIS ETL jobs to load source data into the target data mart . Validate the full load and incremental load into the target database. Verify the data completeness, accuracy and various transformation rules as per data load requirements.
• Validate the data in all Fact and Dimension tables.
• Validate On-Demand parameterized SSIS jobs to load selective data into the data mart as and when required.
• Document and execute test cases for reports as per business requirements. Test the reports in Test environment, UAT as well as in Production. Participate in production deployments and perform smoke test during deployment to make sure any new reports or enhancements have been deployed correctly and working as expected.
• Perform regression testing using HP UFT.
• Also tested the reports created in Tableau 10.0
• Worked closely with Business users, SMEs, developers and participate in daily status calls.
• Update the testing progress/activities in JIRA.
• Using ALM QC to generate Requirement Traceability Matrix and reporting to show testing progress, open and closed defects and other testing reports as requested by the project team.
• Discuss any open defects, show stoppers and blockers with the project team. Represent QA team in the daily meetings.

Confidential

Sr. ETL Tester

Responsibilities:

• Performed functional test, regression test, user acceptance test and smoke tests on target system. Executed automation scripts in QTP (HP UFT) for functional regression testing.
• Tested various applications developed in ASP.NET, MuleSoft. Tested MainFrame application with AS/400 which was used to create and edit Customer accounts.
• Involved in testing SalesForce application for one year.
• Written and executed SQL stored procedures to validate the data loaded in target system from various source systems ( SQL Server 2008, AS400, Flat files ) and ETL transformations are done correctly, data is cleansed and standardized according to the mapping documents.
• Executed test cases to validate initial and incremental load from various source systems through ETL and/or web services real time. Identify duplicates, fallouts or missing data. Look into error logs for any rejected data due to missing LOVs, bad input etc.
• Verify that customer data has been matched and merged in MDM HUB based on the match-merge rules.
• Monitored TIBCO queues and Active MQ to capture inbound and outbound XML messages. Manually validate the XML messages and verify that MDM is generating correct SIP messages based on what events are triggered in HUB and is writing the correct data in SIP messages. Validate the conversion of SIP messages into canonical XML messages.
• Participate in weekly architecture meetings to discuss issues and make suggestions to improve the existing code design. Schedule meetings with Business Analysts to review business requirements, discuss any gaps or ambiguities identified in the requirements. Review test cases with the development team and Business Analysts.
• Discuss any open defects with the team in daily scrum call. Schedule meetings with development team to dicuss any critical defects.
• Co-ordinated with different teams sending the data into OVC (target system) as well as with the team consuming the data from OVC. Provided 1st-tier production support and acted as 1st point of conatct for the conusming teams.
• Upload Requirements in HP ALM-QC 11 and map each requirement to the test cases to provide traceability matrix. Log defects in ALM-QC 11 and Mingle.
• Used both Waterfall and Agile methodologies and represent the QA team in daily stand-ups.
• Lead the team of 4 QAs in absence of QA Team Lead.