Resume

Sign in

Manager Test Cases

Location:
Bothell, WA
Posted:
March 17, 2018

Contact this candidate

Resume:

Naveen Davis Vallooran

423-***-****

ac4ud8@r.postjobfree.com

Profile Summary:

** ***** ** ********** ** IT.

More than 6 years of Experience in Informatica and Dataware house technologies.

Experience in all phases of software development life cycle.

Expertise in ETL development and support, SQL.

Proficiency in developing Informatica data load processes and work flows.

Hands on experience with databases including Oracle, PL/SQL and MySql involving stored procedures, triggers, functions, indexes.

Hands on experience in UNIX Shell Script and unix/Linux commands.

Strong analytical skills with ability to quickly understand client’s business needs.

Involved in meetings to gather information and requirements from the clients.

Research-oriented, motivated, proactive, self-starter with strong technical, analytical and interpersonal skills.

More than 4+years of experience in iSeries/AS400,DB2,,SQL RPGLE,RPG,CL,CLLE programming languages .

Good experience in Testing, Test Plan and Test Case creation

Good experience in Report creation and download using SQL

Good experience in writing Test cases, preparing Test data, executing Test cases, Traceability Matrix

Technical Skill Expertise:

Programming Languages

ETL,Informatica9.1,SQL, Unix Shell Script,AS400,RPG/LE,CL,CLLE

Secondary skills

Hadoop,Sqoop,Flume,hive,pig,tableau,Cognos

RDBMS

Oracle,DB2, MYSQL

Source Control

Harvest,Adlon

Operating Systems

Windows 9x/2000/XP, Linux, UNIX,AS400

CERTIFICATIONS

ISTQB – Testing certification

AHM 250 Health care Cognizant Internal certification

Informatia training in Greens Technologies chennai,Adyar

Hadoop/Big Data training completed

EDUCATION DETAILS

B-Tech in Electronics and Communication

Calicut University, Govt. Engineering College Thrissur

Professional Work Experience:

Cigna,Chattanooga,

2015 to till Date

Informatica System Analyst

Project: FFVRDS

This project is to load the Customer and transaction informations from RDBMS oracle database to 'Read only Data store' called FFVRDS. FFV RDS has 3 layers Landing Zone,Stage and Master databases. Golden Gate used to replicate data to Landing Zone.

Informatica ETL process used to transform and load the data to Stage and Master region.

Responsibilities:

Production Support for FFVRDS application.

Oncall support for jobs scheduled in ESP .

Fixing the problems and issues in Informatica Workflows.

Implementing the small enhancement.

Tuning the Performance related issues.

Involved in design, analysis and architectural meetings. Created Architecture Diagrams, and Flow Charts using Microsoft Visio.

Preparing Test Cases for enhancement and implementation.

Unit Testing and Test Case preparation.

Experience on different tools in Informatica Power center. Informatica Power Center client tools have been used for mapping, session, and workflow and execute them.

Repository Manager

Mapping Designer

Source Analyzer

Target Analyzer

Workflow Manager

Workflow monitor

Environment: Informatica 9.1,10.1,Linux,

DataBase: Oracle

Tools:ESP,HARVEST,Toad,SQL Developer.

Cigna,Chattanooga,

2012 to 2016

Informatica System Analyst

Project: Claims RDS

In this project Cigna's different Claims engines claim details pulled through informatica load process and transformed and loaded to a Read Only data store(Oracle database) for using it as a data warehouse.

Responsibilities:

Production Support for Claims RDS application.

Monitoring the jobs and Oncall support for the jobs.

Generating reports using SQL queries and provide to users.

Fixing the problems and issues in Informatica Workflows.

Implementing the small enhancement.

Tuning the Performance related issues.

Involved in design, analysis and architectural meetings. Created Architecture Diagrams, and Flow Charts using Microsoft Visio.

Preparing Test Cases for enhancement and implementation.

Unit Testing and Test Case preparation.

Experience on different tools in Informatica Power center. Informatica Power Center client tools have been used for mapping, session, and workflow and execute them.

Repository Manager

Mapping Designer

Source Analyzer

Target Analyzer

Workflow Manager

Workflow monitor

Environment: Informatica 9.1,10.1,Linux,

DataBase: Oracle

Tools:ESP,HARVEST,Toad,SQL Developer.

UHG, Chennai,India

June 2011 – June 2012

Senior Java/J2EE Developer

Project: UHG OptumRx

Application development for AS400 system in RxClaim PBM system.

Worked as Software Developer

Primary Responsibility of the role:

AS400 application development.

Requirement gathering,Design document preparation

Coding,Unit test plan and Test case preparation

UAT support.

Environment: AS400/RPG/RPGLE Programming/CL/CLLLE programming

Database: DB2

Tools:SQLAldon,X-Analysis,Hawkeye, ROBOT Job scheduler

Skandia, Chennai,India

Software Engineer

June 2010-2011

Project: Skandia Insurance, Production Support

This project was to support Skandia AS400 application production support and application development.

Responsibilities

AS400 application support

Enhancement (application development and Unit Testcase preparation and Testing for AS400 applications.

UAT support.

Environment: AS400/RPG/RPGLE Programming/CL/CLLLE programming

Database: DB2

Tools:SQLAldon,X-Analysis,Hawkeye, ROBOT Job scheduler

Project: Skandia,Insurance

October 2008 – Oct 2010

Software Engineer

This is project is to test the application developed in AS400 for Skandia Insurance. Preparing Test plan,Testing cases and perform the system testing for the applications .

Responsibilities:

Writing Test cases, executing Test cases AS400 application.

Report creation and download using SQL

Test Plan creation

preparing Test data

URD, FDD and TDD analysis

Test plan and Case preparation

Test execution and Defect logging used Quality Center

Environment: AS400, Testing, Quality Center

Hobby Projects:

Good knowledge in Python and C programming. I am doing hobby projects in Python and C programming. I do blog on my hobby projects in www.naveendavisv.blogspot.com

Description of the Python projects:

Pygame using Joystick:

The aim of the project to build a graphics game using Pygame module and Joystick device. This projects gave opportunity to understand on how to build screen and control x,y coordinates of window screen.

The details are available in the link:

http://naveendavisv.blogspot.in/2014/07/raspberry-pi-connecting-with-joystick.html

http://naveendavisv.blogspot.in/2014/07/object-game-in-raspberry-pi-using-pygame.html

Django projects:

The aim of the project to build a web application using Django which is a python web development framework. The web application has admin and login page,home page (url pages) to manage users. This project gives opportunity to learn some python modules and Django web development framework.

The details are available in the link:

http://naveendavisv.blogspot.in/2016/04/django-login-page.html

http://naveendavisv.blogspot.in/2016/04/how-to-build-django-admin-page.html

Other Python/Raspberry Pi experiments:

I am also do some experiments in Raspberry Pi and Python to understand more on C programming and Python. The details are available in the following links:

http://naveendavisv.blogspot.in/search/label/raspberry%20pi

http://naveendavisv.blogspot.in/search/label/python



Contact this candidate