4.5 yrs experience in ETL testing

SATYAJEET PARIJA

ETL/DWH Tester,Informatica power center-8.6.2,TOAD, Database,Oracle & SQL

E-mail: *******.***@*****.***

Mobile: +91-730*******

Career Objective

To employ myself in a progressive organization that provides scope to update my practical knowledge and skills in accordance with the latest trends and be part of the team that dynamically works towards growth of the organization.

Professional Summary:-

• Over 4.5 yrs of experience in IT industry as a Software test engineer and data analyst.

• I have 4 years of experience in testing both ETL Testing & Manual testing.

• Good knowledge on Data Ware house concepts.

• Experience in ETL/Manual testing on Windows/Linux Environment. Experience in preparing/reviewing/executing Test cases, Defect logging/tracking/analysis as per the FS.

• Expertise in Test case management tool HPQC- 9.0/10.0, open source defect tracking tools like Jira.

• Good knowledge on Testing Life Cycle, Bug/Defect life cycle, Defect tracking and management.

• Expertise in ETL/DWH testing concepts, Informatica power center 8.6.2, TOAD, Base SAS concepts, basic understanding of Perl.

• Skilled in understanding Business requirements,Designed documents, IEEE 829 Test Plan and STLC.

• Expertise on various manual testing types like System testing, Regression testing, Functional testing, UAT testing etc.

• Worked with Developers to understand requirements for the purpose of generating test cases.

• Knowledge of Global Regulatory compliances like HL7, ICH-E2B, HIPAA, 21 CFR Part 11, CRF, GCP and other standards relevant to the Life Sciences industry.

• Expertise in Bioinformatics and its applications like functional genomics and proteomics, HMM / Neural Network Studies, Disease Profiling, Pharmacovigilance study, Phylogenetic Analysis, Forensic Data Analysis, Immunoinformatics and SNP studies for different cancer studies.

• Flexible to learn advancements in the IT industry, Quick learner, Team Player, willing to learn new technologies.

Professional and Academic Qualifications: -

MSc Bioinformatics (2007) First Division, Utkal University, Orissa.

Skills: -

Operating Systems Windows 98,2000,XP, 7, Unix/Linux,(Ubuntu)

ETL Tools Informatica power center 8.6.2,SAS 9.2

Test management Tools Quality Center9.0/10.0

Defect management Tools Quality Center9.0/10.0 , Jira

Languages Perl, SQL

Database and tools Oracle 8i/10g, TOAD

Project Summary

Project Title LS-AB-EVEREST.

Organization Persistent Systems Ltd

Client Life Tech (Applied Biosystems)

Team Size 12

Environment Windows, UNIX

Designation Test Eng. (Sen. Domain Analyst)

Description Software applications for proper analysis of Forensic evidence records which will help in culprit identification. As a part of USA CODIS database FBI is planning to maintain all the 50 states culprit record. This effort of managing this huge demographic database along with the social identification no has to be accomplished using an ETL tool. Informatica Power centre 8.6.2, which is DB’s strategic ETL tool.

Roles and Responsibilities: Understanding Forensic data and it’s functionalities

Involved in functional study of the application

Running the jobs/Workflows for ETL process

Prepared and ran sql queries to verify Dimensional and Fact tab les.

Verifying the data in target database by ETL process

Verified column mapping between source and target

Prepared test data for functional & Integration testing

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status.

Designed, Reviewed & Executed Test cases.

Identified Test cases for Regression testing

Defect Analyzing and Reporting in QC

Client server testing by doing export and import with good MAC and Bad MAC Id.

Software installation and uninstallation.

Status reporting, project tracking, documentation and reporting.

Duration June 2011 – present

Project Title Human identification (HID)

Organization Persistent System Ltd

Client AIIMS

Team Size 10

Designation Test eng (Domain Analyst)

Description For making intelligent health care decisions based on the data available, current project gives an environment where health professionals can decide the current health conditions of their patients by analyzing the entire patient history. By this individuals can do health care cost analysis and should aware of their health improvements. Region wise data is managed w.r.t height, weight, geographical area and type of disease indivual’s are prone to, symptoms for easy understanding of health professionals. Plots, charts, and graphs are generated by SAS-9.0 for easy reporting. All tables latter mapped by Informatica power center 8.6.2 for decision making.

Duration:

Understanding Functionalities as per the Client.

Data gathering, cleansing and import/export in different formats.

Verifying the data in target database by ETL process

Verified column mapping between source and target

Prepared test data for functional & Integration testing

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status.

Designed, Reviewed & Executed Test cases.

Identified Test cases for Regression testing

Defect Analyzing and Reporting in QC

Communication with client for Data management.

Test case execution.

Dec 2010 - June 2011

Project Title Be-better

Organization BDRC

Client Core soft Pvt Ltd

Team Size 6

Designation Test eng (Analyst)

Description It is an integrated end–to-end hospital Management System that provides relevant information across the hospital to support effective decision making for patient care. The claim data from various venders for different subject areas like medical, pharmacy, dental, disability, worker compensation etc. This will also help client to analyze fraud claims.

Roles and Responsibilities: Understanding disease specific Functionalities and clamming

Data capturing in different formats.

Patient study

Reviewing data for cleaning and validation process.

Verifying the data which is loaded into target data bases

Maintained the daily error log for cleaning the data

Developed, Reviewed and Executed Test Scripts.

Test Activities included Functional Testing and Regression Testing.

Test cases management by QC 9.0.

Defect analyzing and reporting by Jira.

Test case up gradation with the newer builds.

ETL, DWH testing knowledge used.

RDBMS concept and SQL applications.

Arrange discussions with dev team for project understanding.

Duration Jan 2009 - Dec 2010

Project Title LS-AB-SOLID-INSTRUMENTATION

Organization BDRC

Client Life Tech (Applied Biosystems- SOLiD Technology

Team Size 9

Environment Windows, Linux

Designation Senior Domain Analyst (Test Eng)

Description Secondary and Tertiary analysis of Primary lab raw reads. Ref. sequence mapping and pairing with Fragment reads. Di Bayes, small indel, Copy number variable study during tertiary analysis. BAM color space sequence and base space sequence analysis.

Roles and Responsibilities: Understanding SOLiD Instrumentation and it’s Functionalities

Browser based (GUI) and command line based application.

Di-Bayes, Small Indel, Large Indel, CNV Annotation.

Reviewing Test Case

Identification / Review of Test Cases & Test Scenarios

Test Case Execution

Bugs tracking and Defect resolution and Management

Communication with client & giving project understanding to Dev team.

Communication with Development team.

SQL querying for retrieving data from Database.

Writing technical documents/emails with the correct level of details.

Duration July 2008 – Jan 2009

Project Title PGM-DX-510k

Organization BDRC

Client Life Tech (Applied Biosystems-ION Technology)

Team Size 7

Environment Windows, Linux

Designation Test Engineer (Domain Analyst)

Description It is most updated Next generation sequencing approach by ion chip technology. Sequencer will come with embedded software. It will analyze reads from PGM by Torrent Server. Ref. sequence mapping and pairing with Fragment reads. Algorithm study for Di Bayes, Variant caller. BAM, SAM, FASTQ, SFF, VCF file formats and conversions.

Roles and Responsibilities: Understanding of ION Torrent Instrumentation and it’s Functionalities

Browser based (GUI) and command line based application.

VMware installation as a simulator with UNIX applications.

Di-Bayes, Variant caller, TMAP, BFAST algorithm testing.

Indexing, Mapping, Aligning Algorithms study.

Writing test cases. Execution of already written test cases.

Test data generation, requirement linking to the test cases.

Black box testing (System, Integration & Regression testing)

Writing Use cases, test estimation, verifying test plan also.

Client server testing.

Reviewing Test Cases w. r. t FS.

Identification / Review of Test Cases & Test Scenarios.

Test case and Defect management by HPQC 10.

Communication with client.

Communications with Development team for code walk through.

Giving Diagnostics approach to team.

Duration Dec 2007 – July 2008

Personal details:-

Father’s Name : Mr. Siba Prasad parija.

Mailing Address: Plot no: 52, 3rd main,1st Phase, 1st Stage, West of Chord Road,

Manjunathnagar, Rajajinagar, Bangalore- 560010

Sex: Male

Marital Status: Married

Hobbies: Listening Music, Playing Computer Games,Cricket,Carrom.

Date of Birth: 06/05/1982

Languages Known: English, Hindi & Oriya.

PAPER PUBLICATION:-

. A Structural Bioinformatics approach to explore the interactions of P53 & BRCA1 gene products on Ovarian & Breast cancer. (International Journal of Bioinformatics and WCCI 2010) http://www.ncbi.nlm.nih.gov/pubmed/21441093 , http://www.bionity.com/en/publications/117492/a-structural-bioinformatics-approach-to-explore-the-interactions-of-p53-and-brca1-gene-products-on-ovarian-and-breast-cancer.html , http://dl.acm.org/citation.cfm?id=1963519 , http://www.informatik.uni-trier.de/~ley/db/journals/ijbra/ijbra7.html

. A comprehensive analysis of Multiple myeloma genes Using Advanced Bioinformatics Tools.

(Published in The Internet Journal of Medical Informatics™ ISSN: 1937-8300).

http://www.ispub.com/journal/the_internet_journal_of_medical_informatics/volume_5_number_2_51/article_printable/a-comprehensive-analysis-of-multiple-myeloma-genes-using-advanced-bioinformatics-tools.html

. Sequence submitted to GenBank:

http://www.ncbi.nlm.nih.gov/nuccore/290783603 , http://www.ncbi.nlm.nih.gov/nuccore/EU428954.1

DECLARATION:

I do hereby declare that all the particulars mentioned above are true to the best of my knowledge & belief.

Place: Bangalore

Date: 22.05.12 Satyajeet Parija

Contact this candidate