Resume

Sign in

Data Engineer

Location:
Levittown, NY
Posted:
March 13, 2019

Contact this candidate

Resume:

Femina Daniel

Email ID: ac8rwm@r.postjobfree.com

Cell Phone: - 516-***-****

Summary:

** ***** ** ************ ********** in Software Quality Assurance and Testing in different environments and platforms. Expertise in Manual Testing of Web based and Client-Server applications.

Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.

In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, PL/SQL, XML, SQL Server, Oracle, and ETL.

Automated and scheduled the Informatica jobs using UNIX Shell Scripting.

Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.

Expertise in Oracle 10g/9i/8i/7.3, PL/SQL Development Toad, PL/SQL Developer, UNIX.

Solid Back End Testing experience by writing and executing SQL Queries.

Good understanding of Software Development Life Cycle (SDLC) and all stages of QA and Defect Life Cycles.

Good Experience in Waterfall, Agile Scrum Methodology.

Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Plans, Test Cases and Test Execution.

Extensive experience in Functional testing, Backend database testing and Web service testing.

Actively involved in GUI, Functional, Integration, System, Regression, End to End testing, User acceptance, and Database testing.

Experience in testing Web Services using SOAP UI.

Good expertise in HP Quality Center, Jira and Bugzilla.

System testing, ETL /SQL testing experience in Health Care, Telecom and Airline Domain.

Good exposure in direct interaction with the client for requirement gathering.

Knowledge on XML and other file systems.

Technical Expertise

Elements

Particulars

Primary Skills

ETL Testing, Data Base Testing, Interface testing, Manual Testing

Testing Tools

Soap UI

ETL Tools

Informatica 9.1.0

Databases

Oracle,MS SQL Server

Defect Tracking Tools

HP Quality Center, JIRA.

Domain Knowledge

Health Care, Telecom, Airlines

Operating System

Windows XP,Windows 7, UNIX

Languages

SQL, PL/SQL

Experience Details

Organization

Designation

Duration

Neometrics, a division of Natus Medical Incorporated.

QA Software Lead

April 2015-Till Date

Quintiles Technologies (India) Pvt Ltd

Senior Validation & Testing Engineer

July 2012 – Mar 2015

Cognizant Technology Solutions

Consultant

November 2010 - July 2012

ITC Infotech

Software Engineer

August 2007 - October 2010

Professional Experience

Assignment 1:

Project

NBS Client Server and Web Based Application

Role

QA Software Lead

Organization

Neometrics, a division of Natus Medical Incorporated.

Duration

From 04/2015 – Till Date

Tools

Toad, SQL Server

Project Summary:-

Neometrics systems have been the premier choice of laboratory and case management groups for over 25 years - establishing the largest customer base for newborn screening data management in the United States.

Neometrics case management and reporting tools tightly integrate results for metabolic screening, hearing screening & environmental testing – facilitating rapid follow-up and intervention at the laboratory and state levels.

Neometrics data management products include Metabolic Screening Database System (MSDS), Case Management System (CMS), Lead Follow-up Database System, Internet Newborn Screening Information Transfer (iNSIST)™ Utility, and Voice Response System (VRS).

Role/Responsibilities

I work on multiple Projects with distinct deadlines.

I coordinated with the team to meet the deadlines and discuss about the roadblocks.

Create Test plans, Requirement Traceability Matrix, Business Scenarios and Test Case from requirements, Test Data, design documents and other project documentation.

Test SSRS Reports by validating the data and business Rules.

Participated in peer reviews for requirements and technical specifications.

Involved in meetings to develop test strategies addressing current project needs and concerns.

Involved in meetings with the Developers for in-depth reviews of System Designs and Codes.

Create test data and populated the database according to the System Design.

Write test cases/scenarios for Client Server, Web Based Application, Data conversion and Regression testing.

I work with Business Analyst to clarify and to correct the requirement documents.

Create new bugs and track status of bugs using Quick Base.

Communicate with Business Analyst, Developers, and Client Services Managers on critical issues.

Perform Functional and Regression tests on the targeted software solutions.

Execute SQL queries for Data verification and validation in the back-end database.

Assignment 2:

Project

Clinical Trial Management System

Client

Quintiles

Role

Senior Validation & Testing Engineer

Organization

Quintiles Technologies (India) Pvt Ltd

Duration

From 07/2012 – 03/30/15

Tools

Toad, Informatica 9.1.0, Siebel 7.7, HP Quality Center,Jira

Project Summary:-

Quintiles Transnational, helps improve healthcare worldwide by providing a broad range of professional services, information and partnering solutions to the pharmaceutical, biotechnology and healthcare industries.

The Clinical Trial Management System or CTMS is a platform designed to track, and logically structure information. CTMS will enable clinical teams to track and report clinical trial progress and make better informed decisions to ensure the best quality data and patient safety.

CTMS is integrated with Salesforce to import Accounts, Contacts, Opportunity, Child project codes and Products.

CTMS will eventually reach across CRO and touch every aspect of trial management.

CTMS will enable project teams to better manage the end-to-end clinical trial process through one source of data across the globe.

Role/Responsibilities

I coordinated with Onsite offshore team to meet the deadlines and discuss about the roadblocks.

I was involved in Business analysis and requirements gathering.

Creation of data in Salesforce CRM for specific test criteria and import the records into the CRM database.

Any Transformations between CRM Tables and Siebel Staging would be validated in the CRM Tables and Siebel Staging database.

Preparation of Test Plan and approach based on the Business requirements.

Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

Validating the reporting objects in the reporter against the design specification document.

Validating the data files from source to make sure correct data has been captured to be loaded to target tables.

Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata.

Identify the primary key (logical / physical) and put update or insert logic.

Reviewed Informatica mappings and test cases before delivering to Client.

Written Test Cases for ETL to compare Source and Target database systems.

Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.

Identifying duplicate records in the staging area before data gets processed.

Ensured that the mappings are correct and conducted data validation testing.

Raised performance issues to developers during the DRT (Dry run Test) with relatively huge data to find any performance issues with ETL jobs.

Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.

Writing SQL queries to validate the data.

Peer review execution results of other members of the team and ensure quality standards are applied correctly.

Review and sign off test cases to ensure requirement traceability is maintained.

Attend design walkthroughs and review design documentation, ensuring that changes are fully understood and considerations/concerns are raised early.

Review all functional changes and ensure that they are documented and incorporated in the requirements.

Effective Logging of defects into test management tool and generation of reports to improve communication thereby reducing delay in defect turnaround time.

Environment: Informatica Power Center,SQL, PL/SQL, HP Quality Center 10.0, Jira, Saleforce.com platform, Siebel CTMS, Active Batch Web Interface,UFT 11.5.

Assignment 3:

Project

NG CRM

Client

Deutsche Telekom.

Role

ETL/Database Tester

Organization

Cognizant Technology Solutions

Duration

From 11/2010 – 07/2012

Tools

Soap UI, HP Quality Center, SQL developer

Project Description

The NG CRM Siebel Application is based on Oracle Siebel CRM 8.1 with an application Kernel common to all DTAG NatCos which is further localized in order to meet the requirements and the specifics of each country. The first NG CRM Siebel Application Kernel covers CRM customer processes and fixed-lines services, while the second Kernel release covers mobile services and other ancillary requirements. The integrated CTI supports routing of channels Call, E-mail, Chat, Fax and Letter.

Role/Responsibilities

Develop, execute, and maintain test designs, including test cases and test scripts.

Develop and maintain test data as necessary to support testing efforts.

Validating the data extracted using the ETL tools.

Verifying all migrated Records from Legacy System into Siebel GUI/Data Base.

Review requirements, designs, and other documentation to ensure testability.

Conduct testing to ensure that functionality, usability, reliability, and performance of IT solutions are consistent with requirements and established acceptance criteria.

Report and manage defects to ensure that all issues are resolved according to established guidelines and expectations.

Assist development team in troubleshooting and determining root-cause of application defects and issues.

Document test results and communicate to Project Management and other Project Stakeholders.

Execution of Test Cases and logging Defects in HPQC.

Tracking the defects and Sending Status reports.

Preparing the Traceability Matrix between Requirements & Test cases.

Environment: SQL, SQL Server 2000/2005, Oracle Database, HP Quality Center 10.0, Siebel CRM 8.1, Siebel partner portal

Assignment 4:

Project

Mexicana –Loyalty

Client

Mexicana Airlines

Role

Siebel QA Tester

Organization

ITC Infotech

Duration

From 07/2007 – 10/2010

Tools

HP Quality Center, SQL developer

Project Description

Siebel Loyalty Management provides a unique multi-channel and multi-partner solution that allows organizations to transform loyalty program effectiveness and significantly increase the customer retention and value. It supports the entire loyalty marketing lifecycle and includes deep industry and the best practices support for member enrollment and management, point’s accrual and redemption, personalized loyalty promotions and member communications, multi-channel customer care, and cross industry Partner management.

Role/Responsibilities

Develop, execute, and maintain test scenarios and test cases.

Develop and maintain test data as necessary to support testing efforts.

Loading and Launching of Campaigns and measuring the time taken for loading and launching.

Written the Test scripts and effectively tested the Interfaces also based on the SOP’s (Standard Operating Procedure).

Also done the Stress testing with multiple Login sessions for various scenarios of loading and launching the Campaigns.

Review requirements, designs, and other documentation to ensure testability.

Conduct testing to ensure that functionality, usability, reliability, and performance of IT solutions are consistent with requirements and established acceptance criteria.

Report and manage defects to ensure that all issues are resolved according to established guidelines and expectations.

Assist development team in troubleshooting and determining root-cause of application defects and issues.

Document test results and communicate to Project Management and other Project Stakeholders.

Execution of Test Cases and Defect logging in HPQC.

Tracking the defects and Sending Status reports.

Preparing the Traceability Matrix between Requirements & Test cases.

Environment: Siebel CRM, Siebel Analytics, Windows XP, MS Office, Quality Center,Jira and Oracle database.

TECHNICAL CERTIFICATIONS:

Certified in ISTQB

Certified in Amadeus Testing from France

APPRAISALS AND AWARD

1)Received ‘Best Performer’ award within the project.

2)Repeatedly received performance points from supervisors and managers.

EDUCATION

Graduated in Computer Science from Christ College, Bangalore University, Bangalore, India.

Other Details:

Contact Information – Mobile Number – 516-***-****

Personal Email ID – ac8rwm@r.postjobfree.com

Previous Organization- Quintiles Technology solutions.

Present Organization – Neometrics, a division of Natus Medical Incorporated.

Declaration:

I hereby declare that all the above information furnished is true to best of my knowledge and belief.

(FEMINA MERSON)



Contact this candidate