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

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

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

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

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.