Eliza Pokharel

Quality Assurance Analyst

adclqr@r.postjobfree.com

PROFESSIONAL SUMMARY

• Over 5 years of quality assurance, data analysis and testing experience including EDI, Data Warehousing, Teradata, BI Reporting and Data Modeling.

• Experience testing dashboards and user interfaces.

• For MS Dynamics ERP system, found discrepancies between purchase order and invoices for trading partners using the Vantage tool. Read and understood the components of EDI files such as segments, data elements, loops, etc.

• Data testing with Data Mart applications, mainly transformation processes using Informatica tools.

• Write test plans, test cases, scripts and prepared test data and followed STLC extensively for Data Warehouse testing practices.

• Understand data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.

• Proficient using Informatica Workflow Manager and Workflow Monitor to create, schedule and control workflows, tasks, and sessions

• Work in Agile Scrum, Agile, Waterfall and SDLC methodology environments

• Experienced writing SQL query using an enterprise wide RDBMS (Oracle) and familiar with concepts of SQL queries ranging from DML, DDL and TCL

• Expertise in relational database systems like Oracle, SQL Server and Teradata

• Data validation, load processes (ETL) using SQL Developer and briefly TOAD

• Test BI reports generated using BI tools like MicroStrategy and briefly Business Objects

• Test/validate the Source, Stage and Target (End-to-End).

• Performed Functional, System, Integration, Regression, Performance and User Acceptance Testing.

• Understanding business processes/requirements and translate them into technical requirements.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

LPi, New Berlin June 19- Present

Test Lead

•Create and execute the test plan and test scripts based on the developed requirements throughout the software development lifecycle.

•Create test scripts that meet the LPi defined standards and documents results in a clear and consistent format.

•Provide timely, accurate and clear status of progress throughout planning and execution of testing.

•Work collaboratively with business and IT project team members. Use the agreed upon project methodologies to communicate and deliver on project goals.

•Demonstrate a strong understanding of the supported business areas and associated processes in order to provide timely, cost effective testing while minimizing risk.

•Demonstrate an understanding of the proposed software solution, through reading, reviewing and challenging requirements for the project.

•Partner with project leadership and business to review developed plans and scripts, as well as provide timely and clear status of progress.

•Act as a partner within their assigned team to provide accurate estimates, encourage quality practices and presents options with associated risks. Data Warehousing ETL Informatica PowerCenter 8.x/7.x/6.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL, Repository, Metadata, DataMart, FACT & Dimensions tables.

Data Modeling Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams BI Tools MicroStrategy, Business Objects XIR3/XIR2/6.x Databases Oracle 11g/10g/9i/8.0, MySQL 5.4, MYSQL, OLTP, Teradata14.0 Tools TOAD, SQL Developer, Control M

Environment UNIX

Testing Tools HP Quality Center 10, JIRA, TFS

•Worked with CRM data

•Worked with international vendors (London)

•CATFISH testing

•Salesforce testing

•Demonstrate a passion for quality and takes pride in the tested systems

•Familiar with UI/UX interfaces, interactions with backend services, use of multiple browsers and mobile app testing

•Ability to organize and prioritize testing workload

•Strong knowledge of testing tools, testing methodologies, frameworks and processes

•Ability to create documentation for all stakeholders of a product that clearly communicate the process, procedure, and general business data handling

•Ability to work independently and pro-actively under minimal supervision Environment: JIRA, Smartsheet, Saleforce, Google drive, slack Northwestern Mutual, Milwaukee, WI Nov 2017 – Jan 2019 Data Test Analyst

• Participated in Agile/Scrum meetings as Test Analyst including sprint planning, sprint grooming and sprint retro meetings.

• Created and executed test cases and documented test results.

• Tested Power BI dashboards and reports.

• Used Leankit and JIRA for updating daily tasks and logging defects.

• Used Microsoft Visual Studio – Tabular Model for PowerBI metrics and calculations.

• Worked on five different projects within the department that involved wide range of QA effort.

• Worked on data extract work to validate client data.

• Communicated with business users on business requests clarification.

• Tested dashboards’ visual and performed functional testing such as sanity, smoke, integration, regression and UAT

• Used Informatica PowerCenter Workflow Monitor to closely monitor jobs for ETL processing.

• Worked on various databases: Netezza,Redshift,MySQL Workbench 6.3, Rapid SQL 8.5 to retrieve data from different source systems.

• Involved in business meetings with clients to understand business requests and QA approaches.

• Created SQL queries to validate data result while functional testing.

• Proficient using Excel to document test

• Executed both positive and negative test cases to ensure full coverage functional testing.

• Integration, Functional, System, Regression, Sanity and Smoke Testing

• Used Slack and skype for communication

• Gave a presentation to the upper management on the importance of QA and how it plays a vital role in software development life cycle Environment: Windows 10 OS, JIRA software, MYSQL, Leankit, PowerBI, Netezza Milwaukee Tool Corporation, Milwaukee, WI Feb 2017 – Apr 2017 Supply Chain EDI Tester

• Tested EDI data with respect to PO, INV, and ASN and prepared for implementation.

• Worked on Advance Ship Notification (ASN)

• Corrected EDI file mismatches between Purchase Orders and Invoices for MS Dynamics ERP.

• Involved in executing detailed test cases using JIRA for manually testing invoices and purchase orders.

• Responsible for verifying data completeness and data quality

• Experienced in reading and understanding EDI files. Able to distinguish the components of EDI files (AX12) such as segments, data elements, qualifiers, loops etc.

• Worked in Agile Scrum.

• Coordinated testing activities to complete the assigned JIRA tickets.

• Responsible for identifying and defining the defects and logged it on JIRA tickets.

• Familiar with ERP, JDE files, POs, Invoices, Trading Partners.

• Used Vantage Point tool to retrieve POs and Invoices.

• Familiar with using UDT tool (Universal Data Translator)

• Generated latest EDI files for testing.

• Frequently used NODEPAD++ for PO and Invoice files comparison.

• Aware of different EDI document types 214, 810,820,823,824 Environment: Windows 10 OS, JIRA software, RedWorld, MEDIC, Inovisworks, AxProd Northwestern Mutual, Milwaukee, WI Oct 2015 – Dec 2016 Quality Assurance Analyst

• Participated in different Agile/Scrum meetings as Test Analyst including sprint planning, sprint grooming and sprint retro meetings.

• Created and executed more than 75 test cases per sprint, documenting test results.

• Automated testing using JSON script.

• Used Visual Studio Team Foundation Server 2015 for updating daily tasks and logging defects.

• Used in-house data validation tool to compare data between two different databases

(Sybase and DB2)

• Used AutoSys as scheduling tool to kick start jobs for functional testing

• Used Informatica PowerCenter Workflow Monitor to closely monitor jobs for ETL processing.

• Worked on various databases: DB2, Sybase, MySQL Workbench 6.3, Rapid SQL 8.5 to retrieve data from different source systems.

• Involved in cloud testing (data movement and OTL)

• Created SQL queries to validate result while functional testing.

• Proficient using Excel to document test results and beyond.

• Member of an agile team.

• Executed both positive and negative test cases to ensure full coverage functional testing.

• Integration, Functional, System, Regression, Sanity and Smoke Testing

• Participated in Risked-based test training, Agile training.

• Understand business logic and transformation and incorporated in SQL queries to meet the requirements.

• Responsible for reporting defects and providing additional documentation to support that it’s a valid defect (screenshots).

Environment: Windows 10 OS, DB2, Sybase, SOAP UI, TFS, Scrum CVS Caremark, RI Nov 2012 - Feb 2015

Senior ETL/BI Quality Assurance Tester

• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.

• Tested storage and the retrieval of data from the database.

• Wrote complex SQL queries for data validation for verifying data and business Rules.

• Responsible for verifying data completeness, data transformation, data quality, integration testing, UAT & regression testing.

• Experienced in working with Oracle, Teradata, and TOAD.

• Worked in Agile Scrum and waterfall models.

• Created back up tables.

• Wrote source, target SQL’s based on the mapping documents and validating the data.

• Used UNIX as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.

• Coordinate testing activities to complete System Integration and UAT Test preparation on schedule.

• Reviewed the Business Requirement Documents and the Functional Specification.

• Prepared Test Plan from the Business Requirements and Functional Specification.

• Successfully led a team and coordinated the testing activities to complete System, Integration and UAT Test preparation on schedule.

• Defined, created and implemented testing process and methodology for onsite/off-shore team.

• Data verification and validation using complex SQL queries.

• Executed test cases/scripts and accurately & concisely reporting both progress and defect status.

• Utilized various testing methodologies and developed strategies, test cases, and executed testing for reporting and data validation of various Vendor feeds.

• Used SQL for querying the SQL server database for data validation and data conditioning.

• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.

• Responsible for identifying and defining the defects and worked on troubleshooting it.

• Created ETL test data for all ETL mapping rules.

• Experience in creating UNIX scripts for file transfer and file manipulation.

• Worked with Data Extraction, Transformation and Loading (ETL).

• Involved in testing data mapping and conversion in a server based data warehouse.

• Used Quality Center to track and report system defects and writing test cases/scripts.

• Responsible for testing packages using ETL to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.

• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: MSSQL Server 2008, Agile, Teradata SQL Assistant 7.0, XML, UNIX, Shell Scripting, Quality Center, Oracle

Nabil Bank, Nepal April 2007- Jun 2008

ETL Quality Assurance Test Analyst

• Monitored user requests/issues through tracking system & mails.

• Worked with the users to understand the issue/requests.

• Analyzed system errors and worked with the team to set off a plan to resolve it.

• Intensively conducted Functionality, User Interface, Security, and Regression testing during the various phases of the development using Test Director/Quality Center.

• Created enhancements/ bug fix requests and solve these if applicable.

• Created test plans, test cases and test results.

• Performed smoke and regression tests for all releases.

• Handled alerts and worked on finding the root cause of the issue.

• Organized weekly meeting on project’s status and discussed any roadblocks. Environment: Oracle, SQL, Scrum, HP Quality Center EDUCATION:

Bachelor’s Degree in Environmental Studies, St Cloud State University, MN August 2008 – May 2013

Contact this candidate