Resume

Sign in

Test Data

Location:
St. Petersburg, Florida, United States
Salary:
10500
Posted:
August 18, 2018

Contact this candidate

Resume:

Vivek Varghese Jacob

Tampa,Florida

Email: ac6pxl@r.postjobfree.com Phone: 201-***-****

EDUCATION

Bachelor in Technology, Information Technology May 2009

Amrita Viswa Vidyapeetham Kerala India

Master in Technology, Software Engineering Jan 2015

Birla institute of Technology and Science. Pilani, India

TECHNICAL SKILLS

Software proficiency: ETL Tools – Abinitio 3.0, Autosys Scheduler, Informatica 9.6,Unix Shell Scripting, Quick Test Professional, Service Now (Tickets & Tasks Tracking),TOAD, PL/SQL Developer, PVCS,DB Visualizer, Liquid XML Studio, HP Quality Center, Tableau, UC4, VersionOne, MicroStrategy.

Languages: Shell Scripting, PL/SQL, JCL, COBOL, Python,PowerShell,Java Script

Databases: Oracle, Sql Server, Netezza, Sybase,DB2

Line of Technology: Abinitio 3.1,Unix,Oracle 11g,Mainframe, Informatica 9.6

Line of business: Commercial Insurance Property and Casualty, Entertainment, Mortgage banking.

PROFESSIONAL EXPERIENCE Total work experience: 9Y

Cognizant Technologies and Solutions, Texas, USA Jan 2018 – July 2018

Client: Cigna, Tennessee

Autosys Job scheduling and testing.

Integration testing between staging and final tables.

Generate Ad-hoc report and downstream application support.

Business requirement document review and updating.

Review testcases and test results.

PROFESSIONAL EXPERIENCE Total work experience: 8Y5M

Cognizant Technologies and Solutions, Texas, USA May 2016 – Dec 2017

Client: FreddieMac, Mclean, VA

Autosys Job testing, Shell script and testing.

Functional and UI testing.

Client saving of 72 PH per year by converting existing manual test scripts to UFT automation scripts.

Webservice testing, Database testing, Report Testing, Batch job testing.

Responsible for preparing Test strategy, Test Estimation, E2E testing and traceability Matrix.

Updating ALM daily based on test execution and defect tracking.

PROFESSIONAL EXPERIENCE Total work experience: 7Y0M

Cognizant Technologies and Solutions, Texas, USA July 2015 – May 2016

Client: Disney, Orlando, Florida

Tools : Version One, Informatica, Ytrail Virtualization,

Job Scheduler: UC4

Team: Disney Vacation Club July 2015 – May 2016

Roles: On-Off shore coordinator, Team Lead

Database: Oracle, Tera-data

Role as a QA Lead and Offshore-Onshore coordinator

ETL QA Lead for DWH.

Functional and ETL testing, Unit Test results verifications.

Analyze business and system requirements, mange development of specifications to create and execute detailed test plans, and verify defect fixes

Analyzing the change requests (CR’s) put forth by the clients and analyzing the impact on constraints.

Responsible for preparing Test strategy, Test Estimation, Scope of IST and E2E testing effort and traceability Matrix.

Team: MyMagic+ Nov 2015 – Apr 2016

Roles: On-Off shore coordinator, Team Lead

Database: Oracle,Sql Server,Teradata

Tools : VersionOne, Ytrail Virtualization

Role as a QA Lead and Offshore-Onshore coordinator

QA Lead for Virtualization Project

Functional and Virtualization testing, UI Testing.

Analyze business and system requirements, mange development of specifications to create and execute detailed test plans, and verify defect fixes

Analyzing the change requests (CR’s) put forth by the clients and analyzing the impact on constraints.

Responsible for preparing Test strategy, Test Estimation, Scope of IST and E2E testing effort and traceability Matrix.

Team: DineTime,- Table Reservation System July 2015 – Oct 2015

Roles: On-Off shore coordinator, Team Lead

Database: Oracle, Tera-data

Role as a QA Lead and Offshore-Onshore coordinator

ETL QA Lead for DWH Data Mart

Functional and ETL testing, Unit Test results verifications.

Analyze business and system requirements, mange development of specifications to create and execute detailed test plans, and verify defect fixes

Analyzing the change requests (CR’s) put forth by the clients and analyzing the impact on constraints.

PROFESSIONAL EXPERIENCE Total work experience: 6Y2M

Cognizant Technologies and Solutions, Texas, USA Nov 2014 – July 2015

Client: Mercury Insurance Corporation, Brea, California

Roles: On-Off shore coordinator, Informatica DWH QA Lead, MicroStartegy BI Testing

Database: Sql Server, Netezza

Role as a QA Lead and Offshore-Onshore coordinator

BI Report, Functional and ETL testing and Unit Test results verifications.

Regression Testing, creating test cases and conducting review meetings to better understand requirements.

Setting up test environment.

Work with developers, business analysts, and user representatives in application design and document reviews.

Analyze business and system requirements, mange development of specifications to create and execute detailed test plans, and verify defect fixes.

Wrote many SQL scripts to find the business data exceptions in BI reporting testing and to mock the production environment for the missing test data.

Proved many defects as a change request to the current environment using the test data and business requirement documents and thereby saving many post production defects.

Responsible for preparing Test strategy, Test Estimation, Scope of IST and E2E testing effort and traceability Matrix.

Verify Unit Test results and provide observations once quality assurance process is done to developers and Business analyst to maintain a team rapport.

There were 50 microstrategy reports for the DWH we built and we did the BI testing for the claims DWH.

Lead, mentor and train the team members. Support UAT and Test Results.

Maintaining company standards for testing.

Analyzing the change requests (CR’s) put forth by the clients and analyzing the impact on constraints.

Plan well and meet Quality assurance for the tasks delivered on time and discuss the future challenges on time with the team to execute the project smoothly.

Flexible, proactive and able to multi-task effectively and efficiently by working as a team or individually to meet deadlines.

Maintain a good rapport with the team to avoid escalations and to overcome challenges.

PROFESSIONAL EXPERIENCE Total work experience: 5Y6M

Cognizant Technologies and Solutions, Texas, USA Nov 2014 – Nov 2014

Client: Kering, Secaucus, New Jersey

Roles: Proof Of Concept (POC).I successfully completed 110 test case sql queries in 2 weeks.

Database: Sql Server

PROFESSIONAL EXPERIENCE Total work experience: 5Y5M

Tata Consultancy Services, New Jersey, USA Nov 2009 – Oct 2014

Client: American Insurance Group, New Jersey

Roles: Production Support, maintenance developer,Team Lead, On-Off shore -coordinator,New Enhancement

Database: Oracle -9i -10g -11g, Sybase,DB2

I was the maintenance Oracle developer for AIG’s Data warehouse team for five years.

We have written many System improvement scripts to support end user reporting thereby saving more than 300PH per year.

I have written shell scripts for our maintenance purpose in Unix environment.

I have tuned Oracle SQL scripts and PL/SQL queries for efficient run times by writing bulk fetch cursors.

Gathering detailed business and technical requirements from client.

Supported and maintained MCA(Mission Critical Application) which has 24 downstream applications and more than 10k users.

Translating business requirements of the business users into software requirements specifications.

Preparing the High level, Low level Design Document and ETL Mapping document for all the enhancements.

I Assisted DBAs in converting the Database from 10g to 11g as per maintenance perspective.

Converts the business requirements to detailed technical structure for data warehouse projects.

Design and developing Ab Initio graphs for various enhancements to load the data from different systems such as iSuite, AIQUIC,GPM and PHOENIX into EDW based on the business requirements.

Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like checkin and checkout were used for this purpose.

Developing the reusable generic graphs to unload and loads data from the various tables.

Validating the data loaded against the source by running various queries in Oracle,DB2 for correctness of data.

Create the scripts to promote the jobs into Model and Production environment.

Participate in Change Management procedures by checking the code in PVCS.

Prepare and Schedule the JILS (Job Information Language Scripts) in Autosys Scheduler for automation of job process.

Involve in Requirement meetings, Design meetings and code review session.

Preparing System test plans and test data and performing unit and system testing for all the Enhancements

Providing support for User Acceptance Testing.

Carrying out root cause analysis of the defects prevention.

Guide and Provide technical help to the team.

Providing status report to client on weekly basis.

Ensuring the Quality of deliverable are followed as per the TCS Methodologies.

PROFESSIONAL EXPERIENCE Total work experience: 6M

Amrita Viswa Vidyapeetham, Kerala, India May 2009 – Nov 2009

Client : ACM ICPC Asia Level Coding Contest

Role : Jnr Network Admin

Responsibilities: Setting up Contest Environment

I worked in Mooshak which manages online programming contest.

Unix experience in installing and maintaining the contest servers and replication.

Monitoring Load balancing and failover Checks between the 3 hosted servers.

Certifications

AICPUC - AINS 21 Property and casualty Insurance domain.

INS 21 – TCS Certification

INS 22 – TCS Certification

INS 23 – TCS Certification

Six Sigma GB Certification provided by TCS.

Oracle 9i SQL



Contact this candidate