PROFESSIONAL SUMMARY:

• Lead/Senior QA Analyst with more than 10 years in Quality Assurance, methodologies, testing (data warehouse, client/server, and web applications) using manual testing and automation tools.
• Extensive experience testing ETL/BI processes in addition to reports in a very large Enterprise Data Warehouse environment for more than Nine years.
• Hands on experience testing web & Mobile applications.
• Worked on XML, SOAP UI, Web Service, Ad - hoc Testing
• Handled QA teams and Facilitated defect meetings and worked with Developers, Business Analyst, and Business Sponsors to ensure applications met requirements
• Complete understanding of Quality Assurance Life Cycle (QALC), QA Methodology and QA Strategy.
• Experienced in functional, regression, integration, system, database, user acceptance and performance testing for ab Initio, Informatica Power Center for extraction, transformation and loading, ETL analysis and source to target mapping developments.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Validated numerous reports and packages in Cognos, Business objects and SSIS packages.
• Experienced in performance tuning, design, application, memory, disk I/O tuning, SQL and database tuning and Query Optimizer and indexing.
• Developed test scripts for complex ETL tasks using DB2/Oracle/MS SQL Server databases, Good expertise in using TOAD, SQL*Plus and Query Analyzer
• Validated various SSRS reports and Power BI Dashboards.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Teradata, OBIEE (Siebel Analytics), MS Access, Flat files into a staging area.
• Used SQL to test data loads to analysis cubes, Tested the Framework environment in Cognos Framework Manager. Tested fact table data accessed through Business Objects.
• Proficient in UNIX Shell Scripting (used SED, GREP, CUT utilities scheduling extensively).

TECHNICAL SKILLS:

Testing Tools: Test Director 8, Quality Center 9/10/ 11, Clear Case, Clear Quest, and Quick Test Professional, Rational Suite, BugzillaTest Scripting: SQL, TSL, SQA Basic, 4Test Language, VB Script, JavaScript, Agile Testing

ETL Tools: Data Stage, Informatica Power Center 8.0/7x/6x/5.1, Ab Initio, Teradata, SAP Data Services, SSIS

Languages: C, Java, SQL

Web Technologies: HTML, XML, DHTML, FrontPage TL1, SNMP, TCP/IP

Database & Tools: Exadata, MS Access, SQL Server 2008, As 400, Oracle, Teradata, DB2, Toad, DB2 Studio, DB2 Control Center, Data flux, Data Warehouse QA, Quality Assurance Process, Application Testing, CA 7, Autosys. Clarity, JIRA. Version One

Reporting Tools: Business Objects, Cognos 8, Spot fire, Micro strategy, SSIS, SAP Business Objects, Power BI Dashboards

Operating System: Windows NT 4.0/XP/2000/ME/95/98, UNIX, HP AIX, Sun Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Lead ETL/ BI QA

• Extensively involved in all phases of testing including System, Regression, Interface, E2E, Dress rehearsal for various requirements across the project
• Involved in requirements gathering - attended turnover meeting with BA’s and provide QA Inputs with overall test approach.
• Designed the Test strategy and approach for each phase of testing and prepare Master test plan & Functional test plan in each Phase of testing.
• Provided testing templates which includes Test case templates, Test SQL drafting plans, Defect report, and Test summary reports.
• Responsible for data analysis techniques by resolving missing/incomplete information or inconsistencies/anomalies in more complex research/data by using SQL Queries.
• Extensively prepared test cases and scripts to adhere the requirements and perform various testing like Functional Testing, Non-Functional, System Integration Testing, Validation Testing, Static, User Acceptance Testing and Regression Testing.
• Prepared test plans using TFS for each release, wrote test cases and executed them as part of functional testing.
• Verification and validation of implementations of major software releases
• Developed test plans, QA and UAT test cases, test scenarios and test reports.
• Engages with Program and Project Managers, Business Analysts, Development and End Users
• Support continuous improvement of quality assurance process and contribution to project plan development.
• Managed and prioritized test schedules and test events based on project plan
• Facilitated daily update meetings with project team members
• Communicated and worked directly with Data Architect, Data Modelers, Developers, Business Analysts and Project Manager on testing issues and to ensure proper documentation and testing deliverables are met prior to implementing software releases to production environment
• Responsible for verifying data migration/code upgrade from SSIS versions environment on all phases of the testing SDLC
• Developed SQL queries used to test and validate SSIS packages using source to target mappings and business requirements using Microsoft SQL Server 2005, 2012
• Responsible for reporting daily test metrics and analysis to Project Manager and test team
• Created and executed deployment-related test cases. Determined pass/fail criteria for deployments based on ease-of-use documentation.
• Depending on requirements, identified functional testing efforts for all test scenarios. Used MTM to plan and prepare all scenarios and cases.
• Validated various SSRS reports and dashboards
• Verified and validated tabular model and extensive Power BI dashboards like academic / Students dashboards.
• Performed shakeout testing on the historical loads in UAT and PROD environments.
• Worked on integration of all the processes in UAT/PROD.
• Coordinated environment-troubleshooting strategies database administrators when problems occurred to isolate problems to either code or environment being the root cause.

Environment: Microsoft Sql server stack SSIS SSRS SSAS, SQL server management studio, Team Foundation services, Microsoft test manager SQL Server 2008/12, Query Surge, Quality Center 11.0, Tabular Model, Power BI, and SharePoint.

Confidential, Atlanta, GA

ETL/BI Lead QA

• Worked on various manufacturing phase like Extrusion, Coat & Dye, Waste and validate the key efficiencies.
• Validated all ETL transformations using multiple source systems like CAMS, INFINITY QS to EDW and further to Data mart using complex SQL queries
• Used Query Surge extensively by building Query pairs to perform the system and regression testing
• Validated Business objects Universe with respective the Universe requirements.
• Created and validated numerous Business objects reports and dashboard to match with back end Data mart.
• Facilitated daily Defect/Bug review meetings with business, environment and development team to understand the problem and setting the severity levels and get resolutions for defects logged by team.
• Extensively used Quality Center to log defects and validate test cases and pull status reports respectively
• Worked with Version One tracking tool to log work hours and task’s on daily basis and for testing planning activities via Sprints.
• Capturing/debugging data using Firebug and sending across to development team.
• Performed Mobile and web application testing for Mohawks web apps.
• Developed User acceptance testing templates to provide training for UAT sessions, Work with users to build ad hoc reports.
• Performed and scheduled batch regression suites using Query surge ETL automation tool.
• Validated all the metrics and efficiencies per business requirement document using SQL queries and BO Universe.
• Conducted internal and external reviews as well as formal walkthroughs, and participate in status/SCRUM meetings.

Environment: SAP Business Objects 4.1, SQL Server 2008, Query Surge, TFS, Quality Center 11.0, SAP Data services, Version 1

Confidential, Atlanta, GA

Sr. ETL/BI Onshore/Offshore Lead QA

• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
• Experienced with high volume datasets/Sources from various sources like Teradata, Exadata Oracle, Text Files, and Mainframe and XML targets.
• Prepared documentation for all the testing methodologies including test strategies, test plan QA release notes, estimations QA Project charter used to validate the Data Warehouse.
• Test execution in accordance with test strategy and test schedule, review; issue identification and data mining exercises in accordance with project plan timelines.
• Provided technical leadership and expertise in the reorganization of a complex End-to-End testing effort and Performed system analysis and organizational review of existing QA methodology with special focus on custom test tools.
• Compared, verified and validated data between various sources and targets for the business functionality.
• Created QA templates for Source to target validations which includes ETL validations as well reporting.
• Wrote the SQL queries & PL/SQL code on EDW tables and Cognos Data Mart Staging Tables to validate the data results.
• Backend testing, database table manipulation using TOAD, SQL and database concepts.
• Extraction of test data from DB2 and Oracle 11i tables, Performed Functionality, Integration, Positive and Negative testing.
• Developed Project template for HPQC, folder structures and layouts, reports from HPQC for Project needs.
• Responsible for testing packages using SSIS to verify data completeness, data Transformation, data quality, integration testing, UAT & regression testing.
• Validated reports, Frame work against back end databases as per the BI rules.
• Wrote scripts to perform basic Sanity Testing and uploaded Test Scripts in Test Director.
• Managed project requirements, trace ability and artifacts using ALM/HPQC.
• Responsible for periodic updating of Test Plans and Test Cases as per Requirement Specifications and Business rules.
• Facilitated daily Defect/Bug review meetings with business, environment and development team to understand the problem and setting the severity levels and get resolutions for defects logged by team.
• Involved in FTP process to transfer the files from one server to other, performed quality control analysis and validates results of conversion programs.

Environment: Teradata, Oracle SQL, Oracle 11, SQL Server 2008,PL/SQL UNIX, Mainframe, Cognos 8, Windows, SSIS, Quality Center 11.0, Toad, Teradata SQL assistant, DB2

Confidential, Atlanta, GA

Sr. ETL/BI Lead QA

• Analyzed the Business requirements, Functional requirements and Design Specifications in order to Design Test Strategy and the Test Plans.
• Developed Test Plans, Test Strategy, Test Scripts and Test Cases in Quality Center and executed them.
• Tested several Informatica Mappings used to load data from flat files, XML data files, DB2, SQL Server, Siebel UCM, third party marketing vendor data (JDE Edwards, TAMS II, AS 400/ CSN400, Cognos etc.) into EDW tables.
• Independently led various modules for the Project releases and Phases.
• Done various testing phases like Functional Testing, Non-Functional (Implementation, Back-out Test, Performance Testing, Purge, Backup & Recovery Test), System Integration Testing, Validation Testing, Static, User Acceptance Testing and Regression Testing.
• Developed various SQL queries to validate the test case results for back-end test cases.
• Worked on Daily Transitions templates and meeting for Onshore - Offshore coordination.
• Well exposed to Software Development Life Cycle and Test methodologies.
• Tested the data and data integrity among various sources and targets including reports.
• Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases.
• Created the test data & Coordinating with Developers/Leads in resolving bugs.
• Supported and worked as single point of contact for any QA issues.
• Prepared QA Test Results after Test case execution. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Providing testing inputs to the Project team (Managers, Designers and the Developers) during the Planning sessions to finalize the Work Breakdown structure.
• Hands on experience setting of Quality center for projects and domains, created user groups and project folder structures.
• Built cycles in Quality center during QA execution phase.
• Good knowledge on the Informatica Repository and code migration between environments and components.
• Validated Cognos Framework Manager, Cubes and reports for Sales promotions report and also customer profitability report
• Tested Components, Templates, created Filters and generated Cognos Reports in grid and graph mode.
• Delivered several Quality assurance documents like Test Strategy, Test plans and cases Metrics, QA Entry and exit criteria document, Weekly reports, End of phase summary reports.
• Knowledge on logical data models, recognized source tables and columns, and tested the built Attributes, Facts, drill-maps, Hierarchies and Relationships necessary for creation of a Micro Strategy project.

Environment: Informatica, Oracle Exadata, SQL, Oracle 11, SQL Server 2008,PL/SQL UNIX, CA Clarity™ Project & Portfolio Manager 12, As 440, Mainframe, JIRA, Cognos 8, Windows, XML, Quality Center 11.0, Toad

Confidential, Atlanta, GA

Sr. QA Analyst

• Understood the Business requirements and software specifications.
• Studied functional requirement specifications, technical design documents and related artifacts.
• Responsible for the effort estimation, planning, and execution of chunks of testing activities.
• Participated in BRD walkthroughs and analyzed business requirements, design document and prepared requirement review report.
• Designed test strategy for the project, Converted business requirements into test objectives.
• Extensively tested several Ab Initio graphs used to load data from flat files, XML data files, DB2, SQL Server, Siebel UCM and Query banding.
• Responsible for setting-up the test bed to ensure that all the needed components have been implemented in the test environment.
• Involved in Data analysis and prepared required test data for validation of test cases.
• Reviewed test cases prepared by offshore team in accordance with defined guidelines and processes.
• Performed various testing phases like Functional Testing, Non-Functional (Implementation, Back-out Test, Performance Testing, Purge, Backup & Recovery Test),System Integration Testing, Validation Testing, Static, User Acceptance Testing and Regression Testing.
• Extensively used HP Quality Center 10.0 for Test management and execution of test cases.
• Preparing and updating all business stakeholders regarding project status with daily reports.
• Coordinating with project team members to achieve project goals through status meetings and reviews.
• Tested BTEQ scripts for data loading and knowledge on the utilities like MLOAD, and FLOAD.
• Created the test data & Coordinating with Developers/Leads in resolving bugs.
• Prepared QA Test Results after Test case execution and supported UAT based on business user requirements.
• Conducting Regression Testing whenever some code module is changed.
• Validated marketable Metrics for different reports generated by Micro strategy
• Tested Components, Templates, created Filters and generated Micro Strategy Reports in grid and graph mode.
• Participation in peer reviews of test artifacts. Responsible for periodic updating of Test Plans and Test Cases as per Requirement Specifications.
• Responsible for validating .NET, ASP.NET, and Java web-based application with SharePoint out-of-box and custom code in staging and production environments
• Responsible for validating OMB fillable form data in Adobe Acrobat via SQL Server Reporting Services (SSRS)
• Responsible for validating webMethods Integration Server and MWS deployments running on a Java platform. Deployment artifacts included Integration Server packages, JDBC adapters, MWS shells, skins and .war files. Used IIS, MWS, Designer and Developer during deployment activities
• Interacted with Development managers to discuss the outstanding issues, participating in Retrospectives.
• Attended daily Defect/Bug review meetings with business, environment and development team to understand the problem and setting the severity levels and get resolutions for defects logged by team.
• Conducted Sanity Testing on the load environment before performance test begins.
• End to End testing responsibility for EDW and CRM Projects.
• ETL Testing, Data Validation, Testing Cognos reports and Cubes.
• Validated marketable Metrics for different reports.

Environment: Ab Initio GDE 1.2, Teradata V12, Siebel UCM 8.1, Unica CRM SQL, DB2,SQL Server 2005,PL/SQL UNIX, Maestro, Share Point, Hyperion 9.1, Cognos, Micro strategy 9, Mainframes, Windows, XML and Quality Center 9.2/10, Teradata SQL assistant. JIRA, UNIX, Perl, Python, Putty, DB2, Oracle.

Confidential, NC

Sr. DWH QA Analyst

• Understanding of Business requirements and software specifications.
• Studying functional requirement specifications, technical design documents and related artifacts.
• Responsible for the effort estimation, planning, and execution of chunks of testing activities
• Participated in BRD walkthroughs and analyzed business requirements, design document and prepared requirement review report.
• Designed test strategy for the Project. Responsible for setting-up the test bed to ensure that all the needed components have been implemented in the test environment.
• Converted business requirements into test objectives.
• Extensively used Informatica power center for ETL process.
• Worked on Preparation of ETL mapping specifications.
• Participated in Designing mappings for dimensions and facts.
• Deleting the target data before processing based on logical or physical primary key.
• Design and execute the test cases on the application as per Client standards.
• Written Test Cases for ETL to compare Source and Target database systems.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.
• Responsible for Data mapping testing by writing complex SQL Queries using Toad.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools. Developed test cases to accomplish ETL data migration.
• Involved in Unit testing and integration testing of Informatica mappings.
• Performed Unit, Integration and System Testing.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Involved in Data analysis and prepared required test data for validation of test cases.
• Performing manual testing of the data in various staging locations.
• Liaise with Business Analysts and responsible for driving issue-log meetings on regular basis.
• Extensively used HP Quality Center 9.2 for Test management and execution of test cases.
• Coordinate with project team to achieve project goals through status meetings and reviews.
• Conducting Regression Testing whenever some code module is changed. Participation in peer reviews of test artifacts.
• Responsible for periodic updating of Test Plans and Test Cases as per Requirement Specifications.
• Worked with sport fire report tool to validate reports based on recon work for different source systems.
• Interacted with Development managers to discuss the outstanding issues. Participating in Retrospectives.
• File transferring using FTP from UNIX and also used Filezilla client to transfer files between different servers
• Uploading and downloading files between different servers using FTP.
• Proficient with Test Director and Quality Centre.
• Conducting Sanity Testing on the load environment before performance test begins.
• End to End testing responsibility for a CIDW Database which involves testing requirements, ETL Testing, Data Validation, Testing reports and Cubes.
• Possess good Knowledge on OLTP and OLAP concepts.
• White Box Testing of Informatica Tool. Force Starting ETL jobs and tracking errors.

Environment: Informatica, Oracle 10g, Quality Center 9.2, Business Objects, Windows 2000, UNIX, Spot fire 3.0, Toad, Autosys, JADE, FileZilla, WinScp.