SUMMARY

• Over 6 years of extensive and diversified experience in Information Technology with emphasis on Quality Assurance, Data warehousing Testing, ETL Testing, POS testing, GUI, Testing of ERP system, Web, and Client/Server based commercial applications.
• Involved in complete System Analysis, Design, Development, Testing (SDLC), Enhancement and Quality Assurance of software applications.
• Experience in Data Analysis, Data Validation, Data Modeling, Data Mapping, Data Loading, Data Warehousing/ETL testing and BI Reports Testing
• Strong Experience in Variety of Industries like Retail, Telecom, Health Care, Financial services.
• Sound in software testing skills with medium to large projects in all stages of product development.
• Expert in using Defect Management Tools - HP Quality center, Test Director, QA Complete, JIRA
• Worked on Oracle, SQL Server and Teradata Database Platforms
• Worked on various Operating Systems which include Windows, Linux
• Worked with different querying tools like SQL Assistant, TOAD, Oracle SQL Developer, iSQL * plus
• Extensive Quality Testing experience on both ETL and BI solutions for many clients.
• Well versed with Software testing concepts, SDLC, Agile and Waterfall methodologies
• Extensively worked on Dimensional modeling, Data cleansing & Data staging of operational sources.
• Expert in writing Test Plan, Test Strategy, Test Metrics, Test Summary Reports, Test Cases and Test Scripts for Manual testing based on the Business Requirement and System Requirement documents
• Implemented various Test cases for the Functional Testing, System Testing, Unit testing, Regression Testing, Smoke Testing, Integration Testing, Back-End and User Acceptance testing (UAT)
• Involved with preparation, testing and validation of ETL test data for all the ETL mapping rules.
• Expert in documenting the project status, bug tracking and reporting using Quality Center
• Extensive experience in writing SQL and PL/SQL scripts to validate the databases and for backend database testing.
• Experience in Dimensional Data Modeling using Star Schema and Snow Flake Schema.
• Strong working experience with SQL (DML, DDL, DCL) and UNIX Shell scripting and Defect tracking.
• Followed high level of quality standards to complete the work within the project deadline
• Very Strong Analytical, Debugging and Technical skills
• Expert in writing negative scenario test cases and testing.
• Excellent communication skills, Team player, self-starter and a very detail-oriented person.

TECHNICAL SKILLS

Operating Systems: Unix- (Linux, HP Unix), Windows XP/Vista/7/10

Databases: Google Big Query, Oracle 10g/11g, SQL Server, Teradata, MS Access, DB2, Flat Files, CSV Files

Testing Management Tools: HP Quality center 9.2/10, QA Complete, JIRA, ALM

Querying Tools: Oracle SQL Developer, Teradata SQL Assistant, PL/SQL Developer, TOAD

Microsoft products: Word, Excel, Access, PowerPoint, Outlook.

ETL Tools: Informatica 7.1/8.x, Data Stage 7.5, Abinitio

Reporting Tools: Qlikview 10, Tableau, Business Objects, Cognos 8.0, Power BI, SSRS

Scripting/Programming: SQL, PL/SQL, Unix Shell Scripting, PHP, HTML, XML, C, Visual Basic, Python

PROFESSIONAL EXPERIENCE

Confidential, Dallas-Love Field, TX

Sr Data Quality Engineer

Responsibilities:

• Worked on different projects like Crew Pay Analytics, TRiM-Data Migration from Oracle to SQL Server, NOC Dashboard metrics, UFM Upgrade.
• Extensively involved in Business Analysis, Requirements Gathering and interacted with different teams and vendors.
• Involved in development and implementation of test cases, test plans, test data and test scripts for various projects.
• Involved in various kinds of testing like Unit testing, integration testing and regression testing.
• Expertise in writing SQL Statements to validate the data loaded into Data warehouse and Data Mart tables according to Business Rules.
• Extensively used UNIX to run Abinitio graphs and load data to tables and check the error logs.
• Worked on CA TDM (Test Data Management) tool to create bulk test data into tables from complex data models in any given entities.
• Created tables with ER relations in database to work on data bulking and data management tools.
• Documented Proof of concept (POC) for TDM features like Data Profiling, Data Sub-setting and Data Generation.
• Have good understanding of referential integrities, normalized forms and other concepts of data modeling in Enterprise Data Architechture.
• Used alteryx for comparing bulk data from source to target by applying the complex transformation logics.
• Used python for data comparisons and emailing the test results.
• Created flight schedules, trips and assigned crew (IF/FO) to trips using crew scheduling system to test data flowing to downstream.
• Delayed flights, cancelled flights, swapped flights to see the data is being populated correctly in the downstream NOC dashboards for any Irregular operations.
• Worked on Amazon S3 bucket to download the data files received from different internal applications and run the shell scripts and ETL graphs to validate the data being loaded correctly into final EDW tables as part of UFM upgrade testing.
• Participated in Bi-Weekly User Story Grooming sessions and Iteration Planning meetings with Scrum Master, Product Owners, and Agile Team members.
• Reported the testing status for the current Sprint daily during Scrum meetings.
• Attended bug review meetings to discuss the defects with the developers.

Environment: - HP ALM, JIRA, Confluence, Oracle, SQL Server, Teradata, CA TDM, Amazon S3, UNIX, Agile testing, Microsoft Products.

Confidential, Columbus, OH

Sr ETL/DWH Tester

Responsibilities:

• Worked on different projects like NCR Upgrade, Blujay TMS Implementation (decom keywell TMS), Informatica Upgrade (from GIS) - EDI, Appriss Returns Management.
• Gather business requirements and work with product team to convert them into technical specifications.
• Functions as the single point of contact in QA team for any issues, testing status updates, QA estimates, risk analysis and report to product team and Confidential internal teams.
• Discuss with product team and integration teams for scope assessment and resource planning to deliver the Quality product on time.
• Creating and executing Test Cases in JIRA to validate internal development team releases.
• Assess vendor fix packages, test and coordinate releases across Cross-Functional Teams.
• Develop and execute test plan, test cases.
• Proficient in writing complex SQL queries.
• Assisted junior members of team with SQL and business requirement documentation.
• Validated data in multiple databases. (Oracle, Teradata, SQL Server) and XML, JSON format files.
• Worked on JDA allocation application and Manhattan WMOS.
• Involved in supply chain system testing (WMS, Inventory management, Order Management)
• Tested different transactions by using Credit/Debit/Gift cards on POS.
• Created promo sales, returns and tested rewards information on POS.
• Performed split tender transactions on POS using Test Debit card and credit cards
• Tested cubes and reports for data accuracy.
• Analyze, solve and work with product team to solve vendor related issues.
• Develop training materials for the Users.
• Communicate with project management and users on all modules, tasks/status updates.
• Co-ordinate with offshore team for any Blujay product issues.
• Actively involved in CRP meetings and provided support during Cut-Over and implementation.
• Worked on NCR Logix for testing the Products hierarchies and Groups.
• Created Purchase Orders, ASNs, routed POs, build freights to carriers and plan the loads.
• Worked on testing the inbound and outbound EDI(850, 860, 832), ASN, PO files
• Worked on Control Tower, Blujay TMS for freight building and generating Load plans.
• Worked on IBM Sterling B2B Intgrator.
• Good with all EDI formats and EDI testing.

Environment: - QA Complete, JIRA, Microsoft Teams, SQL Developer, Teradata SQl Assistant, EDI, POS systems, BigQuery - GCP.

Confidential, Evansville, IN

Sr ETL QA Analyst

Responsibilities:

• Good working experience in data warehouse and ETL concepts.
• Involved in regular discussions with the business analyst to gather the requirements.
• Extensively used HP Quality center for requirements, test cases, test execution and defect.
• Worked on querying tools like Oracle SQL developer and Teradata SQL assistant to validate the data from reports to EDW (Enterprise Data Warehouse) and source to target systems.
• Tested Complex ETL Mappings based on business requirements and business rules to load data from source to target Data warehouse.
• Involved in preparation of Requirement Traceability Metrics (RTM), Defect Report, Weekly Status Reports.
• Performed Integration Testing, System Testing, Functionality Testing and Regression Testing.
• Involved in testing various reports created in IBM Datastage using SQL queries on the database.
• Effective co-ordination between development team and testing team.
• Performed ETL test scenarios by writing SQL scripts with consideration of Business scenarios
• Exclusively worked with ETL team to analyze the source and Target Database systems
• Developed Test cases for different Loan scenarios
• Used Quality center to track, analyze and document defects.
• Retested the changes once the bugs are fixed.
• Created Test Plans which describes the features and functions to be tested.
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Wrote SQL Statements to retrieve data from backend.
• Responsible for documenting the process for future references.
• Created, Updated and maintained Test Scripts for different builds and releases.
• Extensively worked on debugging the data for any issues.
• Participated in regular sessions and team meetings to discuss the issues arising out of testing and interacted with developers and project managers to deal with any issues found during testing
• Excellent in preparing test data and testing all the possible scenarios for any requirements or transformation logic.
• Extensively worked on Microsoft Excel as a source to extract the data into database.
• Implemented the data validation for reports using data from different sources and writing SQL queries.
• Excellent communication and self-starter with ability to multitask.

Confidential, Plano, TX

QA Analyst

Responsibilities:

• Worked on testing the forms data being loaded correctly to the database tables.
• Prepared test data for both Positive and Negative test scenarios to cover all business requirements
• Extensively used SQL queries to test the data from the database.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Created Test Plans which describes the features and functions to be tested.
• Helped the lead create Traceability Matrix to ensure comprehensive test coverage of requirements, identify all test conditions and test data needs.
• Extensively used HP Quality center for requirements, test cases, defects and test execution.
• Worked on getting requirements from the user, developing crystal reports and maintaining proper documentation of reports for future reference.
• Performed Regression testing for every modification in the application, new builds and defect fixes
• Involved in End-End Testing.
• Created and tested Individual performance reports using SAP crystal reports
• Mapped data between external data base to the crystal reports and validated the data
• Worked on writing complex formulas at summary level and group level to implement the business logic.
• Worked on Report cosmetics.
• Worked in an Agile environment for several projects.
• Performed Data validation to verify the data extracts and record counts in the database tables.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.
• Involved in regular discussions with the business analyst to gather the requirements & for the issues to be resolved.
• Regular interaction with developers for any changes in mapping docs, defects/ code fixes, to run the processes and load data into target tables.
• Initiated Defects review meetings with Developers and communicated with them for whole defect life cycle until the logged defect is closed and verified.
• Submission of weekly status reports.
• Executed all the Test Cases in the test environment and maintained them and documented the test queries and result for future references.
• Testing included Unit, System, Regression testing, Business Objects reports testing.
• Good at analyzing the mapping documents and understanding the data flow.
• Manually written the SQL queries to test the back-end database.

Environment: - HP Quality Centre, SAP Crystal Reports, Microsoft SQL Server management studio, Metastorm BPM designer, Oracle 10g, Microsoft Excel

Confidential, Columbus, OH

ETL/DWH Analyst

Responsibilities:

• Worked on different projects like Sales, Charge Send, Dropship, Amplify (Assortment Planning), Loyalty Members, Data Mart Retirement, New leased Business Units.
• Worked alongside with Business Analyst and Technical Architects in gathering the Business requirements, Functional and Technical Designs.
• Worked extensively on writing complex SQL to extract data from multiple tables and database.
• Tested several dashboards and deployed them across the organization to monitor the performance.
• Excellent at developing advanced SQL queries
• Worked on IBM Sterling B2B Integrator to run the business processes
• Used UNIX for File transfer and File manipulation
• Attended Defect meetings, Sprint meetings, status meetings and standup meetings
• Worked in both Waterfall and Agile Environments.
• Validated Tableau reports and Power BI dashboards for requirements to meet the user acceptance criteria in agile methodology.
• Extensively tested the cubes and reports for data accuracy.
• Created Test plans and test strategy.
• Involved in developing test cases and test scripts as per the BRD and Mapping Documents.
• Conducted review sessions on test case and regression test scripts in Quality Center.
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any change control in requirements leads to test case update.
• Extensively used Quality Centre 9.2 in documenting the test cases, expected results and defect logging.
• Worked on database vs. Business Objects Reports testing
• Worked on POS (Point of Sale) applications.
• Involved in testing the functionalities related to sales tracking, POS scanning, credit card transactions and promotions in POS system.
• Prepared coverage Metrics and Reports for test case creation, test case execution and bugs to better understand the status and quality of the project in a timely manner.
• Worked on front-end Forms to do price changes, purchase orders and to create any test data.
• Tested gift card purchases, promotions and loyalty member accounts.
• Deployed codes for New and Update processes for product and pricing to load ATG tables.
• Performed functional testing, Regression testing, Smoke testing.
• Performed Regression testing for every modification in the application, new builds and defect fixes
• Involved in End-End Testing for many projects. (POS systems - Final tables)
• Good at understanding the business requirements and cover all the positive and negative test scenarios.
• Worked with testing of Data Extraction, Transformation and loading (ETL)
• Received appreciation emails as detailed oriented person and for opening defects from existing processes.
• Excellent communication skills and self-starter with ability to multitask.

Environment: Oracle 10g, Teradata, Tableau, Business Objects, HP Quality Center 9.2, Microsoft Excel, SharePoint Portal

Confidential, Plantation, FL

QA Analyst

Responsibilities:

• Worked alongside with Business Analyst in gathering the Business and Functional requirements.
• Attended team meetings, product walkthrough’s and review meetings.
• Experienced in writing complex SQL queries for extracting data from multiple tables and database.
• Extensively used HP Quality Center 9.2 to maintain test cases, execute them and log defects found in system testing
• Extensively executed SQL queries in order to view successful transactions of data and for validating data in Sql Server Database
• Used Inner and Outer Joins in order to retrieve and validate the various transaction details form multiple tables.
• Written Test Cases for ETL to compare Source and Target database systems
• Design and execute the test cases on the DIRECTV Sales Support Galaxy CRM application as per BRD
• Rigorously performed Regression testing for every modification/enhancement of the project.

Environment: Oracle 10g, Microsoft SQL Server 2008, Teradata, Windows NT, UNIX, TOAD 10.0, HP Quality Center 9.2, Crystal Reports, MS Excel, SharePoint Portal.