Project Test Cases
Resume:
Isaac Jayaseelan G
E-Mail: ********@*****.*** mailto:*******.***@*****.***
Mobile: +91-989**-*****
Professional summary:-
* ***** ************ ********** ** IT Industries.
* ***** ** ********ce in Data warehouse appliance (Netezza).
Experience in writing Stored Procedures and SQL in Netezza.
Strong fundamental knowledge in SQL queries.
Experience in Tableau and Cognos Reporting tools.
Experience in POC for AWS (Amazon Web Services) – Red Shift.
Experience in creating events and Job schedules in Mainframe Cybermation.
Extensive hands on knowledge of scripts, wrapper for ETL jobs in UNIX environment.
Experience in Unit Testing.
Good knowledge in Health care and Banking Domain.
Working in Agile methodology.
Rewards and Trainings:-
Awarded as Star Performer for the month of May 2013 from Hexaware Technologies Ltd.
Completed IBM Netezza Platform Software v6 certification from IBM.
Technical Skills:-
DW Appliance : Netezza
Languages : SQL, PL/SQL
Operating System : HP-UNIX.
Scripting Language : UNIX Shell
Scheduling Tools : ESP – Cybermation, Control M
CDC tools : IBM Management Console
Employment Profile:-
Working as Tech Lead for Tech Mahindra Technologies Ltd. Bangalore from May 2015 to till date.
Worked as Software-Engineer for Hexaware Technologies Ltd. Chennai from June 2011 to till May 2015.
Project Details:-
Project 1:
Title : BI - Ignite
Client : SunCorp Metway Ltd
Environment : Netezza, LINUX-RHEL, Control M
Duration : May 2015 to Till Date
Team Size : 7
Description:-
Project Ignite is the replacement of Suncorp Bank’s core banking system with a more flexible, efficient and responsive platform. Earlier Oracle based OBP system is used for core banking, but now Ignite is moving to improving the quality of information available to Bank staff when servicing customers.
An important component of this project is the removal of reliance on older technology platforms that are cumbersome to maintain.
This migration includes Collections, Collateral, CASA, Term Deposits, AS-IS reports and Lending. Scope of current task is to migrate data from Oracle to Netezza and build new reports as per requirements set by customer.
This is done to developing an intermediate layer that is called I-Layer and building Dimensions and Facts. Then a report based ROFT layer is build for Reporting purpose. The Fact table is also used for Extracts for which the file will be extracted and provided to customer. Reporting includes Cognos and Tableau.
Responsibilities:-
Understanding the requirement specifications.
Preparing Design Document /LLD from Requirement specifications.
Involved in developing NZ SQLs.
Preparing reports using cognos and Tableau.
Involved in Job Scheduling through Control M.
Identified various test cases and prepared Unit test case document.
Attended daily Stand ups and provide detailed status report to the client.
Project 2:
Title : PI Sizing Migration
Client : IMS Health
Environment : Netezza, HP-UNIX, LINUX-RHEL, Cybermation
Duration : May 2013 to May 2015
Team Size : 5
Description:-
The Rx Sizing process that is currently used in IMS is using Abinitio to a greater extent in accomplishing the task. The Project Independence assignment aims to replace the existing Abinitio components with UNIX scripting and Netezza.
The Scope of current task is to convert the existing Rx Sizing process to execute on Netezza instead of Abinitio. The implementation does not have to reflect conversion of the Abinitio code rather the functionality that is being delivered via the existing Abinitio code.
Sizing process is done to determine the size of the store. It is done either weekly or monthly. The size of store is classified into Local, National and outlet. It will be done only for non-sample stores. Earlier system handles all the three channels, whereas the current system handles only Retail, Long Term Care data.
Responsibilities:-
Understanding the requirement specifications.
Preparing Design Document /LLD from Requirement specifications.
Involved in developing NZ SQLs.
Developing/Reviewing UNIX Scripts to implement Business requirement.
Involved in Job Scheduling through Cybermation, a Mainframe tool.
Identified various test cases and prepared Unit test case document.
Attended weekly status meetings and provide detailed status report to the client.
Project 3:
Title : PI Imputation NPI
Client : IMS Health
Environment : Netezza, HP-UNIX, LINUX-RHEL Cybermation
Duration : Mar 2013 to May 2013
Team Size : 4
Description:-
The Existing Product Imputation is imputing data for the current week based on history data using the same business logic used in Ab-initio. Based on Existing Products Imputation, New Product Imputation is developed. Only few graphs from EPI are used in NPI. New products can be imputed only if it has four weeks of history data.
Responsibilities:-
Understanding the requirement specifications.
Preparing Design Document /LLD from Requirement specifications.
Involved in developing NZ SQLs.
Developing/Reviewing UNIX Scripts to implement Business requirement.
Involved in Job Scheduling through Cybermation, a Mainframe tool.
Identified various test cases and prepared Unit test case document.
Attended weekly status meetings and provide detailed status report to the client.
Project 4:
Title : PI Imputation Migration EPI
Client : IMS Health
Environment : Netezza, HP-UNIX, LINUX-RHEL Cybermation
Duration : Jul 2012 to Feb 2013
Team Size : 4
Description:-
Current Imputations process uses Ab-initio graphs to a greater extent in accomplishing the task. The Project Independence assignment aims to replace the existing Ab-initio components with UNIX scripting and Netezza.
The Scope of this task is to convert the Existing Weekly Imputations process to execute on Netezza instead of Ab-initio. The Imputations process is imputing data for the current week based on history data using the same business logic used in Ab-initio.
Responsibilities:-
Understanding the requirement specifications.
Preparing Design Document /LLD from Requirement specifications.
Involved in developing NZ SQLs.
Developing/Reviewing UNIX Scripts to implement Business requirement.
Involved in Job Scheduling through Cybermation, a Mainframe tool.
Identified various test cases and prepared Unit test case document.
Attended weekly status meetings and provide detailed status report to the client.
Project 5:
Title : DF2 ANEX Table load
Client : IMS Health
Environment : Netezza, HP-UNIX, LINUX-RHEL Cybermation
Duration : Mar 2012 to Jun 2012
Team Size : 4
Description:-
The ANX tables for Reporting and Non Reporting in the prescription database that are to be loaded on a weekly basis using the existing event for Rx fact load (from the Oracle UDB tables).
It covers step by step approach on how to extract the data from the oracle tables and load in to the ANEX tables in TDW through the load tables Reporting and Non Reporting. The jobs for the above loads need to be added to the sequence of job flows that load the DF2 RX fact tables. It also includes the approach on the full load of historical data from the oracle UDB tables to these ANEX tables.
Responsibilities:-
Understanding the requirement specifications.
Preparing Design Document /LLD from Requirement specifications.
Involved in developing NZ SQLs.
Developing/Reviewing UNIX Scripts to implement Business requirement.
Involved in Job Scheduling through Cybermation, a Mainframe tool.
Identified various test cases and prepared Unit test case document.
Attended weekly status meetings and provide detailed status report to the client.
Education Details:-
Completed Bachelor of Science (Computer Science) from PSG CAS, Coimbatore in 2006.
Completed Master of Computer Applications from PARK college of Engg and Tech, Coimbatore in 2009.
Personal Details:-
Personal : Male / Single / Indian.
Date of birth : 07-Apr-1986.
Languages known : English & Tamil.
Contact this candidate