We provide IT Staff Augmentation Services!

Data Quality Analyst Resume

CA

PROFILE:

  • Offering 11+ years of rewarding experience in Information Technology
  • Experience working as a Data quality Analyst with emphasis on Data visualization and Data Validation in Data Warehousing Environment
  • Experience in Automation testing using Selenium
  • Expertise in managing and leading projects
  • Experienced in Tableau and Excel for data cleaning, data visualization, and predictive analytics
  • Technically Competent and result oriented offering multiple years of progressive experience and hands - on execution of Testing in Software Development Life Cycles with Manual/Automation testing, ETL/Datawarehouse testing, Project management, Test management and Quality Management
  • Strong working knowledge in Supply Chain Management (Manufacturing applications), Pharmaceuticals, Retail(E- Commerce), Telecom, Finance markets (Asset management, Insurance &Credit Cards-payments-Risk solutions) and Travel Industry
  • Developed dashboards, visualizations and interpret data, analyze results using Tableau Desktop
  • Good knowledge in building dashboards and stories based on the available data points.
  • Strong working experience in the Data Analysis, Data Verification and Validation of ETL applications using Backend/Database Testing
  • Strong working experience with Microsoft Office products (Excel, PowerPoint, and Access)
  • Hands-on Database/SQL to create queries to extract data from various databases and systems and compare against data warehouse
  • Strong experience in SDLC processes involving Requirements Gathering, Source Data Analysis, Source to target data mapping, DDL generation and Reports testing
  • Extensively experienced in Data warehousing, reporting and querying tools, Data mining and Spreadsheets
  • Have a good understanding of data modeling, in the context of Data-warehouses and Data-marts
  • Expertise in Defect Management tools with proficiency in managing the team to execute testing strategies, deliverables and methodologies
  • Solid understanding and implementing of principles, practices, and procedures of Software Quality Assurance
  • Experience working in agile projects and good understanding of agile methodologies
  • Excellent communicator with talent for problem solving and ability to handle multiple functions and activities in high pressure environments with tight deadlines
  • Diligent team builder, dedicated, hardworking and focused individual with sound analytical skills

PROFESSIONAL EXPERIENCE:

Data Quality analyst

Confidential, CA

Technology: Oracle, Tableau Desktop, Informatica, MS Excel, JIRA, Python

Responsibilities:

  • Review, analyze, and ensure the quality of data loaded into the database system by utilizing SQL and Excel
  • Create various types of data visualizations using Tableau desktop, analyze data and interpret findings
  • Create rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards and provide summary to management
  • Create test data sets using Python, clean and analyze large datasets in different formats
  • Verify data transformations and perform End-to-End data validation by analyzing the ETL mappings and workflows
  • Participate in standup meetings, sprint planning and retrospective meetings
  • Capture, track data defects and coordinate with development teams using JIRA tool
  • Performed data extraction and data validation against the reports retrieved from the database
  • Coordinate with the development and other departments for the data needs and requirements
  • Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc. and published them to the web
  • Created Data Quality Scripts using SQL to validate successful data load and quality of the data

Confidential

Business Associate

Technology: Informatica 9.1., Oracle 10g, Java, web services, HP ALM 11.0

Responsibilities:

  • Design & Deliver End-to-End ETL testing functionality for CRM tool
  • Involved in data integration of online Confidential application with external resources and derived the customized data solutions to the customer
  • Participate in standup meetings and planning and retrospective to analyze, understand and improvise data validations for ETL workflows developed
  • Validation of data transformations and perform End-to-End data validation by analyzing the mappings
  • Analyze the data and create dashboards to the management for customer behavior and customer feedback and product predictive analysis
  • Extensively used Excel for data cleansing and used various functions like VLOOKUP and pivot tables
  • Performed data extraction and data validation against the reports retrieved from the database
  • Write SQL queries for extracting huge data from multiple source systems and validate against business rules
  • Communicate with the cross functional teams like product, sales, operations, product for understanding the functional requirements and taking best decisions
  • Tracked the defects towards closure and tracked test metrics
  • Responsible for Test Planning which includes but not limited to impact analysis of the existing ETL design and formulate test cycles, scenarios and test cases
  • Develop Test strategy, test plan/design, execute test cases and defect management for the ETL
  • Responsible to design, execute and report the status of test phases
  • Coordinate and conduct the functionality discussions for the customized and Fixed departure packages for the users

Confidential

Test lead

Technology: Selenium 2.45, Java, HP ALM 11.0

Responsibilities:

  • Design & Deliver Hotels module End-to-End testing functionality for CRM tool
  • Collaborate with product managers, and other key stakeholders within MMT to successfully execute projects.
  • Develop testing strategies to ensure that application is stable and production ready.
  • Hands-on experience in developing and executing test scripts
  • Created automation scripts for hotels module using Selenium web driver.
  • Collaborate with development team and requirements team and deliver the functionality of the project within tight deadlines.
  • Create positive/negative scenarios for testing.
  • Identify test cases to be included in test automation.
  • Conduct status and review meetings, track actions as per the defect trends for Pre and Post release.
  • Report and track the defects towards closure.
  • Develop TestNG framework for web application testing
  • Implement parallel testing of different browsers.
  • Implemented Data driven Testing, Cross browser testing and Parallel Test execution using Selenium WebDriver, TestNG.
  • Develop and implement process improvements to enhance testing efficiency.

Confidential

Project Manager

Responsibilities:

  • Successfully coordinated and managed End-to-End Testing efforts in 2 full project cycles/releases.
  • Monitor quality standards and processes that DMs, TMs and Test Leads should follow to manage their areas of responsibilities.
  • Prepare Test reports and analyze test metrics like defect density, Pre ST DRE (Defect removal efficiency), UAT and Turnaround times on all severities
  • Track Release readiness, Bug trends and ensure metrics are met by reviewing existing policies and develop new plans to improve the existing quality system.
  • Experience in project management activities such as project scope definition, schedule, Test strategy, Test Methodology, Change Management and Risk Management.

Confidential

Test lead

Technology: Java, web services, Oracle 10g, Rational Clear Quest, Rational Requisite Pro, Quality Center 10.0

Responsibilities:

  • Test manager and Quality manager for the application and managing delivery efforts Confidential offshore for various projects.
  • Play key role in project scoping, scheduling & planning for QA activities in project life cycle.
  • Conduct weekly status meeting with the team for status and issues/Risks in the delivery or schedule.
  • Review and signoff Approach/Test strategy document.
  • Demonstrated success implementing integrated reviews with SEs to ensure Test Coverage
  • Maintaining periodic interaction with all stakeholders and keeping them abreast with latest changes. Concurrently manage several stakeholders with proper communication plan to gain their trust and satisfaction.
  • Planning on resource acquisition (recruiting/staffing), resource sharing, team building, virtual teams to accommodate project needs
  • Participate in Defect Review Board, SE&A, and war room meetings during deployment/UAT to address the delivery status and escalations if any.
  • Capture lessons learnt every release and feed in actions to upcoming releases.
  • End-to-end responsibility of the projects
  • Co-ordinate activities with cross-functional teams
  • Effectively handle and address issues in change management and Dependency management through effective usage of Vidur tool and project workbook.
  • Identify gaps in process and facilitated improvements to quality by mandating process checkpoints such as peer reviews, external reviews and gate keeping guidelines.
  • Proactively initiated and ensured entry criteria for ST is met 100% by introducing surveillance before 3 weeks of ST start date.
  • Mentor the team regarding career growth and facilitated team building activities
  • Create/Facilitate opportunities Confidential an Account level like sharenet, customer voice tracking and presented knowledge of the team Confidential a senior level.
  • Act as a member of SCCB board for SCM, CR, estimates and maintenance ticket approval.
  • Conduct status and review meetings, track actions as per the defect trends for Pre and Post release.
  • Conduct weekly Critical Thread Review (CTR), Facilitate Quality improvement plan (QIP) and implement SQA best practices for all releases.
  • Defines and implements quality assurance guidelines, standards and measurements. Tracks and reports on defined metrics.
  • Perform all responsibilities of a Test Lead such as monitoring project, conducting conference calls (meetings) for project progress, status reports, effort utilization, creating training plans, taking trainings, client interaction, managing the testing team.
  • Guiding the team to work in more efficient manner, coordinating with team for all testing activities
  • Providing daily, weekly and monthly project status reports to the higher management of project
  • Identify reusable functional scripts and execution using automation tool.

Confidential

Test lead

Technology: Oracle PIM, Oracle RPAS, Mercury Quality Center (test management) 9.2

Responsibilities:

  • Produce Weekly Status reports, Test Plan and Work planning activities.
  • Track the defects towards closure reporting reduced defect age.
  • Implemented team effort towards learning and technical expertise
  • Performed Peer review, defect log review, task allocation, follow-up and team guidance with respect to correctness, consistency, comprehensiveness and testability
  • Projected risks and escalated issues to ensure there is no slippage of deliverables
  • Proactively initiated Dev-QA meetings and Participate in client meetings for the release deliverables and backup/Rotation plan
  • Created a training planner and responsible for follow-up of skill up gradation of individual resources
  • Identify reusable functional scripts for test automation and verify the test results.
  • Perform QA ambassador role and was responsible to deliver artifacts across projects.
  • Lead the initiative of KYI (Retail) certification across projects for 50 resources
  • Adhere to the communication plan during all the onshore offshore coordination and client deliverables

Quality Analyst

Confidential, New York

Technology: Informatica power center 8.1.6, Oracle 10g, Acqua Data Studio, Quality Centre 9.2

Responsibilities:

  • Test Lead for the application and managed testing personnel onshore and offshore
  • Produce Weekly Status reports to the Manager, Performed Test Planning and Work planning activities.
  • Provide Test estimates and maintain testing schedules.
  • Verification of business logic for the data transformations.
  • Querying the database to verify and validate the new database data against the existing database
  • Managed Defect process, Test Design, Issue tracker and Knowledge Transition documents
  • Performed Peer review, defect log review, task allocation, follow-up and team guidance with respect to correctness, consistency, comprehensiveness and testability
  • Projected risks and escalated issues to the onshore team to take necessary actions so that there is no slippage of deliverables
  • Reviewed the logical model with application developers, ETL Team, DBAs, to provide information about the data model and business requirements.
  • Mentor the team to take up NCFM (Financial Markets Certification) to enhance app knowledge.

Confidential

Senior Software Engineer

Technology: Informatica power center 8.1.6, Oracle 9i, 10g, TOAD

Responsibilities:

  • Test Lead for the application and managed a team size of four.
  • Produced deliverables such as Test Plan, Traceability Matrix, Daily and Weekly Status reports to the management and Test planning that improve business functionality
  • Provided Estimate for the claim in terms of Test Design and Test Execution effort
  • Created Test strategy, Test Plan and managed work planning activities.
  • Query the database to validate the data Confidential all the stages of ETL functionality.
  • Ensure all the transformation logic acts as expected from existing database (Raptor) to new database (DW Main)
  • Performed Peer review, defect log review, task allocation, follow-up and team guidance with respect to correctness, consistency, comprehensiveness and testability
  • Identified gaps and dependencies by proactively involving in Dev-QA meetings
  • Successful in driving the team to meet project delivery commitments
  • Tracking and supporting the testing activities and interacting with cross functional teams for problem resolutions if any
  • Mentored the team and provide direction for identifying and resolving technical issues.

Confidential

Test lead

Technology: .Net 5.1, J2EE

Responsibilities:

  • Prepare KT plan and create of Application Profile documents for the applications.
  • Travelled to U.S.A and performed one on one discussions with client for Knowledge transition, understand workflow, requirement analysis for application and perform reverse KT sessions to the offshore team.
  • Perform Test design, Test Execution and track defects using Mercury Quality Center 8.2
  • Played a lead role in maintaining and managing courses offered by various towers
  • Status reporting each week with latest data to the Manager & Senior manager
  • Role in Functional requirements documentation for OPCF (Online Product Control File) application
  • Understand and acquire knowledge on credit Card processing domain and Created the Functional and Business requirements from the User documentation of OPCF using the client guidelines and templates.

Hire Now