Quality Analyst/Data Migration

BISHNU LAMICHHANE

Quality Analyst/Data Migration

*************@*****.*** 281-***-****

SUMMARY:

More than three years of IT experience in QA and Testing of Software systems and Web-based environments in Windows and UNIX platforms.

Extensively worked in entire QA Life Cycle, which includes designing, developing, and execution of entire QA Process.

Strong knowledge of Software Development Life Cycle (SDLC), and QA Methodologies like Agile, Scrum, Waterfall, Iterative process.

Involved in preparing the Test Plans and Test Cases based on business requirements, rules, data mapping requirements and system specifications.

Experience on Functional Testing, Regression testing, Integration testing, Web Service Testing.

Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and Identifying Data Mismatch.

Experience in interacting with Clients, Business Analysts, UAT Users and Developers.

Understanding of Data Model, Data Schema, ETL and SQL queries to perform back-end data warehousing testing.

Strong experience on SOAP UI tool tested web services based on XML, JSON, Rest endpoints.

Experience on UNIX writing and monitoring the UNIX logs to check for any errors.

Excellent interpersonal communication, documentation and presentation skills. TECHNICAL SKILLS

QA/TESTING Tools HP ALM 11, Soap UI

RDBMS (Database) Oracle 11g/10g/9i, MS SQL Server 2012/2008, DB2 RDBMS Query Tools TOAD, Advance Query Tool v9

ETL TOOL DataStage, Informatica 9

Programming Language JAVA, C#

Operating Systems Microsoft Windows Family, UNIX – Sun Solaris MS Office MS Word, MS Excel, MS-PowerPoint, MS Outlook Professional Experience

BioMarin Pharmaceutical April 16- Present

Role: Data Migration/Data Quality Analyst/ETL Tester

Responsible for source system analysis, data transformation, data loading and data validation from source systems to Transactional Data system and Warehouse System

Involved in writing the test plans, test cases and RTM involved in the process of analyzing the expected and actual results.

Providing data analysis of data as requested by the business for business efficiencies and productivity.

Creating Data mapping, Data dictionary and various low-level document

Extensively written SQL for ETL and Reporting Testing.

End to End testing for Pega application.

Executed various SQL Queries to perform the backend testing.

Had regular meeting with Developers to report various problems.

Clearly communicated and documented test results and defect resolutions during all phases of testing.

Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.

Performed Black box testing, White-box testing, System Testing, Data Integrity Testing and end to end testing.

Implemented SDLC, QA methodologies and concepts in the Project.

Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts.

Used SQL Server management Studio for querying.

Environment: Sql Server, Sales Force, Pega, Sharepoint, Excel, ErWin, ALM, WINSCP, Prime Therapeutics, MN Jun 15 – Feb 16

Role: QA Analyst

Analyzed solution architecture and design documents including Source to Target and detail design documents needed for each tracks and plan test design activities.

Prepared QA project planning like creating testing scenario, test plans, and test scripts and test summary reports.

Drafted complex SQL queries and perform allocation testing from front end/ user interface

Extensively written SQL for ETL and Reporting Testing.

Reviewed the test activities through daily Agile Software development stand-up meetings.

Used Robot Scheduler to load and execution ETL jobs.

Used DB2 to develop and execute test scripts in AQT, to validate the test cases.

Queried various transformation logic using concept of TEMPORAL table

Validate the responses of web services by passing various requests using SOAP UI.

Worked with JSON and REST Services

Interacted with design/development /DBA team to decide on the various dimensions and facts to test the application.

Responsible for documenting the process, issues and lessons for future references.

Responsible for daily, weekly status of meetings showing progress and future testing efforts to the QA Manager.

Review daily test status and issue/ defects with the project team and business. Prepare communication and create daily status and defect reports.

Knowledge on the phases of agile methodology and scrum Methodology.

Excellent interpersonal, communication, documentation and presentation skills. Environment: Agile, Robot Scheduler, DB2, Quality Center ALM 11.0, SOAP UI, PUTTY, WINSCP Niftek Inc, Irving, TX MAY 10- JUL 12

Role: Junior QA Analyst

Prepared test cases and Scripts in Quality center and executed them in test lab module.

Validated the target table column definition with source column definition.

Designed and created Test Plan based on the BRD and SRS. Also referred Technical Design document, Source to Target Detailed mapping document and transformation rules document.

Written SQLs using joins, subqueries, and group functions, to validate the data between source and target.

Presented QA team work update/Status to project / Program Manager in status meeting and also worked with business team to get approval on test plan/test cases.

Involved with Design and Development team to implement the requirements.

Used Informatica Workflow Manager to schedule and run Informatica mappings and workflow Monitor to monitor ETL execution and logs.

Involved in preparation of test data to test the functionality of the sources.

Used SQL queries to extract data from the target tables to prove the data mapping.

Tested various ETL Scripts to load the data into Target Data Warehouse.

Handled the implementation of the project within an Agile environment Environment: SQL, Oracle 11g, Informatica, MS Visio, Agile, SQL Server 2012, UNIX, Putty. Balaji & Compnay Inc, Houston TX May 07 - Feb 10

Role: IT Helpdesk

Responsible for routine analysis of IT systems to identify areas of potential security threats and to ensure data integrity

Improvised data input system by using ERP system designed by EmagineNet.

Provided technical assistance to workstations and POS via remote support

Generate daily, monthly, yearly sales reports.

Developed and maintained store database using MS Excel.

Worked on inventory management application.

Education (2012-2014)

Bachelor of Business Administration

Sam Houston State University TX, USA

Major: - Management Information System

SAP ERP Recognition

United States Citizen

Contact this candidate