We provide IT Staff Augmentation Services!

Sr. Associate; Lead Etl And Mdm Quality Analyst Resume

Nyc, NY

SUMMARY:

  • Over 13+ years of Software Testing and application support, with specialization in Data warehouse (ETL and Report testing) and MDM testing.
  • Expertise in working on projects involving Data warehousing (DW) and Business Intelligence (BI) testing using different tools like Informatica, MSBI and Cognos. Informatica IDQ, Informatica Analyst, Control - M
  • Extensive Experience in Quality Center which includes Uploading Requirement, Preparation of Test cases and uploading, Execution of Test Cases, Logging & tracking Defects, Preparation of Metrics and Preparing Status reports for test design Phase and Execution Phase.
  • Exceptional communications and interpersonal skills with well-developed personal interaction skills.
  • Highly motivated, organized, able to work independently and able to switch between projects quickly.
  • Good knowledge of SDLC and Software Testing Life cycle.
  • Experience, interest and expertise make me suitable for a position in the field of Software Testing and Quality Assurance, and interested in working for an organization that provides excellent growth prospects.
  • Proficient in writing SQL queries.
  • Perform a test coverage traceability analysis to ensure that all requirements and supporting specifications are tested through the Test Cases with duplicates, invalid, and out-of-scope scenarios removed.
  • Good exposure in all phases of software development lifecycle covering requirement capture, analysis, estimation, software integration, implementation and production support.
  • Adequate exposure to status reporting, escalation and executing project as per plan.
  • Good experience in ETL Testing, Report Testing, Database Testing, System Testing, UAT Testing, Performance Testing and Regression Testing.
  • Expertise in working in Unix environment.
  • NSE certified in Finance Marketing (NCFM).
  • Having Informatica and MSBI external certification.
  • Scaled Agile Certified SAFe 4.0 Practitioner.  

TECHNICAL SKILLS:

Operating Systems: Windows and Unix

Languages: SQL, PL/SQL, Basics Unix Shell Scripting

Database: Oracle 10g, Oracle 11g, SQL Server 2005, SQL Server 2008

Data Warehousing Tools: Informatica PowerCenter 8.6, ODI, Micro strategy, MSBI, Control-M, Cognos, Informatica IDQ, Informatica Analyst

Testing Tools: LoadRunner, AppScan, Toad, SQL developer, Putty, Xmanage, Informatica DVO, iCEDQ

Configuration Tools: Visual Source Safe

Project Management Tool: Microsoft Office Project Web Access, Microsoft Project 2013

Quality/Defect Management Tool: Mercury Quality Center, ALM, JIRA, BMC Service Desk Express and BMC Remedy

Agile Tools: Rally, PMF, VersionOne

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Sr. Associate; Lead ETL and MDM Quality Analyst

Responsibilities:

  • Design, develop and execute test strategies/plan, Setting up the testing environment, debug and troubleshoot, perform impact and gap analysis and give inputs for status reporting, issue resolution, defect tracking and defect triage activities.
  • Creating Requirement Traceability Matrix.
  • Providing Story points based estimation.
  • Documenting all the testing needs & status and reporting the project management on regular basis or on need.
  • Performing ETL testing, MDM testing, WebServices testing, Regression testing and Integration testing.
  • Responsible for providing inputs to the daily testing and defect status reports
  • Working with business/Program team in developing End-to-End test cases
  • Develop and execute test scripts to validate the user stories as per acceptance criteria.
  • Assisting the UAT users in identifying the test data and providing clarifications on technical design related queries
  • Coordinating with offshore team to accomplish the tasks as per the project plan.
  • Defect Triage meeting with Downstream systems.
  • Data Analysis to discover useful information, suggesting conclusions, and supporting decision-making for Downstream systems.
  • Data Analysis to find the trend of data based on requirement from Downstream System.
  • Data profiling to see the data quality is at threshold value.
  • Automation using Platinum ( inhouse ) tool
Confidential, Pittsburgh, PA

Sr. Associate; Lead - Quality Analyst

Responsibilities:

  • As a Technical lead - Quality Analyst team for TogetherRx project, involved in the critical data migration part of TogetherRx project. My responsibilities includes,
  • Analyzing the requirements document, business/technical specification document and come up with business test scenarios.
  • Creating Requirement Traceability Matrix.
  • Providing Story points based estimation.
  • Performing ETL testing, Regression testing and Integration testing.
  • Manage, plan, administer and execute Quality Assurance (QA) system test activities.
  • Design, develop and execute test strategies/plan, Setting up the testing environment, debug and troubleshoot, perform impact and gap- analysis and give inputs for status reporting, issue resolution, defect tracking and defect triage activities
  • Documenting all the testing needs & status and reporting the project management on regular basis or on need
  • Responsible for providing inputs to the daily testing and defect status reports
  • Working with business/Program team in developing End-to-End test cases
  • Assisting the UAT users in identifying the test data and providing clarifications on technical design related queries
  • Coordinating with offshore team to accomplish the tasks as per the project plan.
Confidential, Phoenix, AZ

Test Consultant; Lead QA and Business Analyst (Onsite)

Responsibilities:

  • Located at client site for direct interaction on requirement gathering, user story definition, and approval and QA activities.
  • Requirement Analysis/Gathering and liaising with business and technical teams.
  • Performing ETL testing, Regression testing and Integration testing.
  • Creating Requirement Traceability Matrix.
  • Providing Story points based estimation.
  • Prepare QA strategy and QA Plan.
  • Writing/Reviewing test scenarios.
  • Writing/Reviewing/executing test cases.
  • Test Management and Planning.
  • Functional/Regression/Performance/Smoke/Integration Testing
  • Deployment of deliverables
  • Query Resolution of offshore team.
  • Reporting and Status tracking.
Confidential

Lead- Test Consultant

Responsibilities:

  • As a Project Lead, am handing a team of 6 QA and 8 Dev team members responsible for delivery, deadline and quality of Development as well as maintenance projects of 22 different applications of SPTC suite.
  • Prepare Release Milestone Calendar.
  • Prepare Project Plan.
  • Creating Requirement Traceability Matrix.
  • Providing Story points based estimation.
  • Performing ETL testing, Regression testing and Integration testing.
  • Performance Optimization of SQL Scripts.
  • Defines and generates the traceability matrix
  • Review and approve all test cases prior to execution
  • Reviewing QA Strategy, Test Cases and Defects.
  • Conflict Management.
  • Performing Test execution.
  • Build Verification.
  • Sanity testing of a deliverable builds.
  • Defining Product release game plan and prepare Product Readiness document.
  • Coordinating with Business, Architects, DBA, Information Security, Support and on-site Counterpart to get the quality product delivered on time
  • Providing Support for the application
Confidential

Test Consultant (QA Lead)

Responsibilities:

  • Being a QA Lead I handed a team of 5 QA members responsible for Quality of below listed applications:
  • IMU BI - This is a Data warehouse for IMU and is used to generate reports used by IMU business team for reporting different types of returns.
  • Bonaire - This is Report application used by SEI for calculating Fees for the manager.
  • IMU MQ - This is an application to enable Managers to enter their Monthly & quarterly returns for their sub portfolios and composites.
  • Wealth SSRS reports - SSRS Reports for High Net Worth clients
  • BlackRock project - BlackRock Green Package is a third party application for portfolio risk management. NIIT team is involved in the development of the interfaces to and from this application.
  • Bonaire Advisor - Development of interfaces.
  • Canada Factsheet - Development of SSRS reports.
  • IT Advantage fee Cube - Development of Cubes using SSAS and underlying data using SSIS.
  • Compliance Portal – Development of Portal interfaces
  • Performing ETL testing and Report Testing, Regression testing and Integration testing.
  • Define QA Strategy.
  • Defines and generates the requirement traceability matrix
  • Providing testing effort estimation.
  • Review and approve all test cases prior to execution
  • Manages content within the Quality Center environment (requirements, test plan, test lab and defects)
  • Work closely with development to understand requirements and design for the purposes of scoping the project level test plans
  • Design test cases associate to change requests (regression testing)
  • Analyzing the Source to Target mapping (STM) documentation.
  • Test Plan and Test Estimation preparation.
  • Prepared detailed test cases on the basis of Source to Target mapping (STM) documentation.
  • Reviewing and testing for completeness and correctness of data.
  • Coordinated with development team and onsite team for bug fixes.
  • Created Defect report for all releases.
  • Reviewing SPs for performance
  • Support of application after GA production release.
Confidential

Lead Test Engineering

Responsibilities:

  • Defines and generates the traceability matrix
  • Reviews and approves all test cases prior to execution
  • Providing testing effort estimation
  • Manages content within the Quality Center environment (requirements, test plan, test lab and defects)
  • Work closely with development to understand requirements and design for the purposes of scoping the project level test plans
  • Design test cases associate to change requests (regression testing)
  • Analyzing the Source to Target mapping (STM) documentation.
  • Performing ETL testing and Report Testing, Regression testing and Integration testing.
  • Test Plan and Test Estimation preparation.
  • Prepared detailed test cases on the basis of Source to Target mapping (STM) documentation.
  • Reviewing and testing for completeness and correctness of data.
  • Reviewing of the test cases prepared by the team.
  • Coordinated with development team and onsite team for bug fixes.
  • Created Defect report for all releases.
  • Being part of sustaining team, responsible for pre and post production support.
Confidential

Programmer Analyst

Responsibilities:

  • Co-ordination with Client and onsite resources.
  • Analyzing the Source to Target mapping (STM) documentation.
  • Preparing Requirement Traceability matrix.
  • Test Plan and Test Estimation preparation.
  • Performing ETL testing and Report Testing, Regression testing and Integration testing.
  • Prepared detailed test cases on the basis of Source to Target mapping (STM) documentation.
  • Reviewing and testing for completeness and correctness of data.
  • Reviewing of the test cases prepared by the team.
  • Coordinated with development team and onsite team for bug fixes.
  • Created Defect report for all releases.
  • Work closely with development to understand requirements and design for the purposes of scoping the project level test plans
  • Design test cases associate to change requests (regression testing)
  • Manages content within the Quality Center environment (requirements, test plan, test lab and defects)
Confidential

Programmer Analyst

Responsibilities:

  • Analyzing the user specification / Client requirement/ Source to Target Mapping (STM) documentation and Report Specification.
  • Preparing Requirement Traceability matrix.
  • Test Plan and Test Strategy preparation.
  • Providing Testing Effort Estimation
  • Performing ETL testing and Report Testing, Regression testing and Integration testing.
  • Prepared detailed test cases for Historical Load and Incremental Load and covered all the Direct and Indirect Mappings.
  • Peer Reviewing of the test cases prepared by the team.
  • Coordinated with development team and onsite team for bug fixes.
  • Created Defect report for all releases.
Confidential

Test Engineer

Responsibilities:

  • Scheduling and participating in all projects related conference calls with onsite team.
  • Escalate to Test Lead/Manager any issues relating to the project
  • As a member of the team I am responsible for maintenance, monitoring and implementation of Quality standards
  • Develop and execute test cases and carry out Black Box Testing, System Testing, Regression Testing and Functional Testing
  • Creating weekly status reports and presenting them to Project Manager at both end onsite and offsite
  • Analyzing the user specification / Client requirement documentation
  • Performing ETL testing and Report Testing, Regression testing and Integration testing.
  • Checking for Indexes, Procedure and Triggers.
  • Responsible for Audit trail of Database.
  • Preparing Requirement Traceability matrix.
  • Responsible for checking the integrity of UI data with Database Data.
  • Involved in Database Migration for one of our Client.
  • Reviewing unit test cases and provide test data to development team for unit testing
  • Deployment of application on IBM WebSphere Application Server.
  • Develop and execute test cases and carry out Black Box Testing, Database Testing, System Testing, Regression Testing and Functional Testing
  • Ensure assigned tasks are completed on/before project due date.
  • Reporting defects through Defect Tracking System(in-house)
  • Reporting the status of the project to Project lead
  • Involved in Peer Reviewing of the test cases prepared by the team.
Confidential

Testing Engineer

Responsibilities:

  • Develop and execute test cases and carry out ETL Testing, Integration Testing, System Testing, Regression Testing and Functional Testing
  • Responsible for Bug tracking and reporting
  • Involved in the selection process of new candidates
  • Keep a close and a keen eye on the latest market trends and try to implement new technologies as and where necessary
  • Knowledge Transfer for the other Team Members of the Team.
  • Prepared test cases as per Test Plan and SRS.
  • Preparing Requirement Traceability matrix.
  • Executing test cases and analyzing test results.
  • Involved in System Testing and Regression Testing.
  • Execution of Test cases and reporting defects through Microsoft Office Project Web Access 2003.
  • Reporting the status of the project to Test lead
  • Verifying change requests
  • Interacting with Developers for assisting them in the Identification, simulation, resolving and tracking of problem events
Confidential

Software Test Engineer

Responsibilities:

  • Understanding the functionalities of the modules.
  • Designing the test scenarios, test cases and their execution.
  • Preparing Requirement Traceability matrix.
  • Develop and execute test cases and carry out ETL Testing, Black Box Testing, System Testing, Regression Testing and Functional Testing
  • Responsible for Bug tracking and reporting.

Hire Now