SUMMARY:

• Over 10 years of IT industry experience as Software Quality Engineering.
• 5+years of expertise in leading/managing Manual/ Automation engineers.
• 10+ years of experience in data, ETL, reports, data warehouse, application, regression, end to end testing for Marketing, Sales, Merchandising, Health care,
• 10+ years of strong Data Ware housing Testing Center using Oracle 9i/8i, SQL Server 2008, SSAS, MS Access, TFS, Procedures and Functions at Database level using PL/SQL, TSQL, Oracle Toad, MDX.
• 8+ years of expertise in fast paced agile environment - Results oriented, expert in analyzing root cause, provided prompt updates to upper management weekly/monthly.
• 5+ years of expertise using JIRA as defect Management tool by utilizing Dashboards, filters, Kanban, workflows, and components, release features.
• Manage Planning & Implementation, Scope, Risk, Quality, Resources, and Delivery.
• Documented each MS project plan schedule by priority, detailing deliverables, critical path, phases; align key milestones, tasks, duration, resources, equipment, costs, interdependencies, WBS|PERT|GANTT charts.
• Publish action plans, metrics, workflow, diagrams, presentations, gap analysis, business cases, overall status reports communicated & delivered to all teams, management, customers, executives, steering committees, sponsors, stakeholders.
• Lead project kick-off meetings, presenting vision, strategy, value, business functional analysis, scope, plans, cost benefit analysis, financials, process flows, constraints, issues, risk, diagrams; set go-live expectations, customer acceptance criteria, service level agreements, contingency strategy, support
• Expertise in developing Test Strategies, Test Plans, Test cases using requirements and Test Scripts from scratch at column level and table level for Source to Target as per the requirement by using mapping design document to encounter duplicate records to find matching records, missing records, nulls, data format, updating existing test scripts to match new business requirements and enhancements and business rules.
• Expertise in Functional, Integration, and regression, positive, negative, cross browser, exploratory testing, Load, Performance, White box, Black box and UAT testing for web, Android, iOS applications.
• Strong knowledge in Software Development Life Cycle (SDLC), Waterfall, Agile, SCRUM testing methodologies.
• Strong analytical and problem solving skills, detail-oriented with focus on driving both quality and process improvements.
• Expertise in coordination of resource across multiple projects and systems, ensuring the results are delivered effectively and meet challenging sprint time lines.
• Actively involved in Sprint Planning Meetings, Daily Scrum Meetings, Sprint Review Meetings and Retrospective Meetings with Business Analyst, End-users to discuss the milestones, functionalities, concerns and valid conclusions .
• Quick learner with excellent communication and leadership skills, recognized for ability to work independently or collaboratively with cross-functional teams worldwide, managing multiple releases at a time. Excellent Team Building, Conflict resolution and Strong interpersonal skills.

TECHNICAL SKILLS:

Data Warehousing ETL/Reporting: InformaticaPowerCenter8.1, Informatica - TDM 9.6.0, Business Objects XI/R2 6.1, Crystal Reports XI, Hyperion9, SSRS 2008, Cognos10.

Databases/ OLAP: Oracle 9i/8i/7.0, MS SQL Server r2, MS Access 7.0, SSAS, SQL*Loader, MDX.

Tools: Wordpress, JIRA, Jenkins, Zephyr, HP quality center, Test Director 8,Atlassian confluence, Lawson, Password Reset Tool, TFS, JSON, PDI-Kettle,Team track, Selenium.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

BI QA Lead

Responsibilities:

• Efficient in Serving as key liaison between Stakeholders, Business, Project Management, and technical development staff to ensure that business requirement are meet
• Efficiently handled projects by leading and managing QA team Onshore/offshore to meet the product goals and hence the organization goals that are derived and achieved
• Established working relationship with client and Vendors.
• Monitoring test progress throughout the project release cycle, providing test results and detailed status reports.
• Defect Management using JIRA - Dashboards, filters, Kanban, workflows.
• Test Case Management using Test Rails - Master test cases, test runs, test status, test results, test strategies.
• Test Data Management using Informatica Test Data management - Policies, Data Discovery, Data Subset, Data Masking, Data Generation.
• Expert in using Atlassin Confluence to document and store QA process, standards, meeting notes, release notes, Status reports, QA WIKI, QA checklist, Actual/estimated level of efforts.
• Provided technical mentoring to more junior team members, raising the bar of technical expertise within the organization
• Established QA processes based on industry best practices and Team culture
• Provided level of efforts, standards/procedures and proposed new strategies for each business as and when needed.
• Prioritized work according to changes, enhancements as per complex business requirements to complete the task efficiently on time.
• Actively Participated in Sprint Planning Meeting, Daily Scrum Meeting, Sprint Review Meeting and Retrospective Meetings with Business Analyst, End-users to discuss the milestones, functionalities and concerns.
• Expertise in Preparing QA Execution Summary / Quality Dashboards which highlight the quality of the current release and provide predictability for production readiness which helps in taking GO or NO Go decisions.
• Performed Functional, Integration, and regression, positive, negative, cross browser, exploratory testing, Load, Performance, White box, Black box and UAT testing for web, Android, iOS applications
• Performed Backend testing using SQL, PL/SQL.
• ETL Testing: Introduced effective complex automation scripts using SQL/Stored procs to ensure data flows successfully for Data Migration (between different database technologies and same database technology) from staging tables and populated in target tables according to Transformation rules in mapping documents, Identify the primary key (logical / physical) and added update or insert logic as needed. Written SQL scripts to identify duplicate records, record count, matching records, missing records, nulls, data formats, and column data types between source and target tables .
• Report Testing: Responsible for report End to End testing which includes report deployments to Share point site, data source connections, cosmetic testing, data validation, drilling functionality, export issues, regression testing, UAT promotion, report deployment to Production.
• Automation/Application Testing/Content Management Testing/Mobile Testing: Expertise in developing automation scripts using Selenium, introduced regression automation scripts. Functionality, regression, cross browser and exploratory testing for Web, Android and iOS applications

Environment: Sql server 2008r2, SSAS 2008, SSIS 2008, Team Track, Visual Studio 2008, Share point, Silver light, Business objects XI R2, Cognos 10, Crystal reports, Informatica,JIRA, Atlassian confluence, Zephyr, Team foundation server, PDI-Kettle, Selenium.

Confidential, Irving, TX

Sr. BI QA /QA PM

Responsibilities:

• Manage Planning & Implementation, Scope, Risk, Quality, Resources, and Delivery.
• Set priorities, provide guidance, strategic direction, driving several projects simultaneously, initiation thru delivery, multiple projects, products, phases, sites, teams, vendors.
• Accountable for Budgets, forecast vs. actual variance reconciliation, making sound decisions, tracking cost, expenses, risk, issues, deployment.
• Gathered requirements, mitigated risks, and streamlined process, delivered results.
• Documented each MS project plan schedule by priority, detailing deliverables, critical path, phases; align key milestones, tasks, duration, resources, equipment, costs, interdependencies, WBS|PERT|GANTT charts.
• Publish action plans, metrics, workflow, diagrams, presentations, gap analysis, business cases, overall status reports communicated & delivered to all teams, management, customers, executives, steering committees, sponsors, stakeholders.
• Lead project kick-off meetings, presenting vision, strategy, value, business functional analysis, scope, plans, cost benefit analysis, financials, process flows, constraints, issues, risk, diagrams; set go-live expectations, customer acceptance criteria, service level agreements, contingency strategy, support.
• Persistent in resolving issues, completing tasks, up-to-date project plans.
• Performed analysis of ETL logic residing in decision stream to uncover data relationships, derived values, calculations, etc. in lieu of proper documentation
• Tested several ETL Mappings to validate the business conditions.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements
• Involved in analysis of defects and found the root cause of the defect.
• Introduced effective complex automation SQL Scripts/stored procs to ensure data flows successfully from staging tables and populated in target tables according to Transformation rules in mapping documents.
• Interacted with Developers and Business Analyst regarding requirements, test scenarios, and defects.
• Analyzed the ETL design documents to understand the logic.
• Executed the test cases for Staging Tables /target tables and validate the data results.
• Updated the test cases on based on the requirement changes and executed the test cases.
• Wrote the SQL queries and Data Mart Staging Tables to validate the data results and documented.
• Prepared Test Plans, Test Scripts, Test cases and validated the Test cases.
• Created and monitored daily incident Report.
• Extensively used Microsoft TFS to maintain the documents and versioning.
• Involved in Regression, Release and System Integration testing.
• Participated in overall end-to-end testing.
• Working with different data sources, like Informix, Flat files, xml files, and handling huge data.
• Participated in validating SSRS/Cognos (frontend) dashboards/reports, and documented results.
• Included in meetings with the Development Team to discuss the open defects.
• Performed functionality, regression, cross browser and exploratory testing for Web, Android and iOS applications
• Extensive experience in Black Box & White-Box Testing.
• Supporting and coordinating onsite/offshore teams.
• QA Project Closer/sign off documentation with Lessons learned, actual/estimated times, exit criteria, transition support, celebrate success.

Confidential, Irving, TX

Quality Analyst III

Responsibilities:

• Design test plans and scripts to test new, customized, software to ensure optimal performance of software before being put into production or installed in network environment.
• Determine a sufficient level of test scenarios that include positive, negative, boundary, edge cases and consider all relevant sources of detail
• Effectively communicate with relevant members of the business to help clarify business requirements, facilitate UAT, discuss Test Plans/Cases, discuss challenges
• Organize documents at the feature level that cover basic process flows, testing/troubleshooting steps, and any other relevant details for future reference by other team members May review and critique test scripts developed by less experienced staff and suggest improvements.
• Document test results, and compile results of other testers into consolidated report for management, clients, and applications staff. May perform regression or other analyses and present in project meeting.
• Evaluate testing methodologies and testing tools available in IT market, and advise management on adopting them.
• Performed functionality, regression and exploratory testing for Web, Android and iOS applications
• Extensive experience in Black Box & White-Box Testing.

Confidential, Irving, TX

QA Analyst

Responsibilities:

• Used TFS to manage the project details and reports.
• Created test cases and test plans for user acceptance testing and system testing based on functional specifications, Technical specification.
• Performed Regression Testing to verify various sections of the system to ensure that changes or fixes in the system not only work, but also do not adversely affect the remainder of the system.
• Created and executed SQL queries to validate the data and used data manipulation language. (DML) to update the data in the database and verify with front end that application handles the changes correctly. Initiated defects and assigned to Development teams with appropriate severity levels.
• Used Team Track tool for bug reporting and Tracking for application while coordinating only with vendor and to track reported defects.
• Participated in walk through and defect report meetings periodically.
• Verified the data flow through the front end to backend and used SQL queries, to extract the data from the database.
• Performed the data validation and verification on all test requirements.
• Tested several Crystal Reports for completeness, quality for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI's, Grouped List, Cascade and Web Reports.
• Tested graphical representation of reports such as Bar charts, Pie charts as per End user requirements.

Environment: Sql server 2008r2, SSAS 2008, SSIS 2008, Team Track, Visual Studio 2008, share point, silver light, Business objects XI R2, Cognos 10, Crystal reports, JIRA, Atlassian confluence, Zephyr, Team foundation server, Selenium IDE.

Confidential, North Richland Hills, TX

ETL Tester

Responsibilities:

• Wrote the Master Test plan, Test plan based on the Requirement definition document, which provides high-level details of the project.
• Attended design walk through meetings.
• Worked closely with ETL Team and BA Tem to ensure business requirements were meet based on Mapping Document.
• Attended the daily status meetings with the project manager, both development and QA teams for defect report meetings and presented progress updates.
• Wrote the Test cases according to the scenarios provided by the data model and Mapping documents.
• Wrote the test Scripts at column level and table level for Source to Target as per the requirement by using mapping design document.
• Wrote the test scripts for Regression testing.
• Performed detailed analysis of query results to ensure accuracy of converted data.
• Logged defects in mercury quality center.
• Documented the test results
• Performed regression, Integration and user acceptance testing.
• Performed in report testing using Hyperion.

Environment: Informatica Power Center 8.1/7.1.4/, Mercury Quality center IBM-Mainframes, Oracle 9i TOAD 9.o, Hyperion 9, Windows XP