SUMMARY

• Over 7 years of extensive and diversified experience in Information Technology with emphasis on Quality Assurance, Data warehousing Testing, ETL Testing, TMS testing, WMS 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.
• Experience with AWS Cloud Services like EC2, S3, Glue and Athena for Data Transformations and Querying.
• 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

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 DSW 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,Shipping, Receiving, Appointments, Fulfillments)
• Hands-on experience with integration of JDA WMS to the Blujay TMS.
• Worked on allocating the inventory to different stores through JDA application
• 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, Blujay TMS, JDA application, 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