Himangini Nigam

Himangini Nigam (Test Engineer) Jaipur, Rajasthan-- Infosys Technologies - March 2012 to Present (5 Yrs) Roles & Responsibilities: Having knowledge in SDLC, Testing methodologies and Testing Techniques. Experience in DB Testing, Report Testing, ETL Testing and Manual Testing. Experience in reviewing and testing of data maps between various legacy systems and relational databases. Involved in Requirement Analysis, Test cases designing, performing the test execution and Reporting. Involved in handling the repository of test cases/scripts/reports & metrics analysis for reporting, tracking & verifying defects. Involved in following testing - DB Testing, ETL Testing, Report Testing, Integration testing, Incremental integration testing, Functional testing, System testing End-to-end testing, Smoke testing, Regression testing, Acceptance testing and Recovery testing. Involved in mapping of business objectives to determine and envisage the business requirements. Analysis of Test Environment & preparation of test data. Addressing the client issues based on the requirements and feedbacks given during requirements analysis phase. Technical Skills Reporting Tools Microstrategy, Oracle Business Intelligence, SAP BusinessObjects, Cognos ETL Tools DataStage Designer and Director, Informatics Workflow Monitor Scheduling Tools Control M, IBM Workload Scheduler 9.3, Tivoli Bug Reporting Tool HP ALM, JIRA Languages VB, Java DB Oracle, Teradata, MongoDB, MySQL Additional Tools Teradata Sql Client V14, Oracle Sql Developer, Microstrategy Integrity Manager-MSIM, Toad for Oracle, Netbeans IDE 8.1, WinSCP, Putty OS Windows 7,10, Unix Project Experience (Domain-Retail): AB - In Bev - Product ID Expansion: The project aims at expansion of the PRODUCT ID field and any supporting logic across the existing applications using ETL, BO reports and BTEQ scripts. Roles and Responsibilities: Extensive domain knowledge of Retail Industry Developed Test Plans, Test case, Traceability Matrices, Test Data, Test summary reports, Defect reports. To Design, develop, and execute test cases as per the Business requirements. Actively involved in walkthroughs of the test scripts , peer reviews. Conducted ETL Testing and BI Report Testing which involved verifying the results with expected results, which should complain with the predefined requirements Updating Test Plans and Documenting the tests to meet the functional, technical requirement Tracking quality defects, identify bugs, isolate issue, report bug using Quality Centre (QC) and work with developers, product managers and ensure they are resolved Involved in defect management, bug reporting and tracking the defect status until closure. Working with the onshore team for testing and validating new features and bug verification. Created the Knowledge Documents and Testing Documents. Tools ETL Tool Used: DataStage Designer and Director Database: Teradata and Oracle Scheduling Tool: Tivoli and IBM Workload Scheduler 9.3 Test Management Tool - HP ALM Additional Tools – Toad for Oracle, Oracle SQL developer, WinSCP, Putty, Teradata SQL Client V14 Reporting Tools – SAP BusinessObjects JCPenney - Assortment Planning / Item Planning (AP/IP): The project focuses on the transformation of the reports by creating an interactive experience for the users, to help them solve problems quickly and efficiently. The quality analysis involved ETL testing of data warehouse, report testing of Oracle Business Intelligence and functional testing of the Oracle Business Intelligence, SharePoint Site and flat files generated as per Client specific needs. JCPenney - Merchandising Financial Planning (MFP): A data migration project focusing on DB testing for validation of the integrity of the data at the destination, ETL testing, manual testing and functional testing of reporting tool, Share Point Site and flat files generated as per client specific needs. Automated the entire process of DB testing using Java and C#. Target – MerchIQ: The project aims at transformation of merchandise reports in an interactive format, to help the merchants in sorting their issues quickly and effectively. The QA analysis followed ETL testing (Star and Snow flake) of data warehouse, report testing using Microstrategy, DB testing for validation of the integrity of the data at the destination, functional testing of Microstrategy, Share Point Site and flat files generated as per client specific needs and UAT. The entire process was automated using java and selenium. Sears – Telluride: A loyalty redemption program which followed functional testing of the website as well as regression and compatibility testing Using services using SOAP UI. Sainsbury’s - Data Migration Project: The project aimed at migrating the database from HP Neoview to Teradata followed by up gradation of the remaining reporting tools (Microstrategy, SAS, Pentaho and TouchPoint) to the latest version which can support Teradata v 14.0. The project required testing of entire ETL flow and the impact of data migration on reporting tools. AWARDS Certificate of Appreciation as Tech Champ Certificate of Appreciation for an Innovative tool Bravo Award for recognizing Superior performer CERTIFICATIONS Certificate in HTML5 with JavaScript and CSS3 Specialist from Microsoft in December, 2012. Certificate in M101J: MongoDB for Java Developers by MongoDB in May 2016. EDUCATION Bachelors in Engineering in Computer Sciences Army Institute of Technology - Pune, Maharashtra 2007 to 2011 ADDITIONAL INFORMATION Gender - MALE Date of birth - 01 May 1987 Nationality - Indian Languages Known - English, Hindi, Malayalam Passport - J- (24 Mar 2021)