Data System
Resume:
Kumaravel Manivel
acubfi@r.postjobfree.com
Profile:
6+ years of experience in design and development of ETL applications using Ab Initio, UNIX shell scripting and PL/SQL.
6+ years of experience in Insurance domain and implemented various projects in Reinsurance financial accounting.
6+ years of experience in SDLC (all phases) as Team Lead; System Architect/Analyst, System Administrator; Disaster Recovery coordinator between different teams/personnel; Client Presentations/Training, Developer, Quality Analyst, Test Cases.
Actively participated in Ab Initio COE activities and developed few generic scripts for automating code.
Strong experience in Ab Initio Architecture, GDE, Co>Operating System.
Extensively used air commands to check in/check-out and other EME related operations.
Experienced and having good knowledge on developing Ab Initio Batch and Continuous flow graphs
Experienced working on scheduling tools like Autosys
Excellent in doing Business System Analysis and in providing implementable technical solutions.
Migrated Ab Initio jobs from Version 2.15 to 3.0 and converted the sandboxes from Format 2 to Format 3.
Experienced in recoding the complete project of oracle Stored procedures and Unix shell scripting to Ab Initio jobs with drastic improvement in performance.
Strong understanding of Dimensional Modeling, Star and Snowflake Schemas.
Good Knowledge of Data Warehouse design.
Good Exposure in architecture, analysis, design, development, and testing of RDBMS/Data Warehouse/Data mart systems.
Proven ability to handle short deadlines, prioritize multiple projects as well as daily assignments with limited supervision.
Have knowledge of supporting Java application.
Mentored my team members on the Ab Initio and PL/SQL assignments
Self-starter with drive, initiative and a positive attitude. Able to meet very stringent deadlines and always deliver results, even under pressure.
Strong analytical & good communication Skills. Very keen and enthusiastic; constant desire to learn; genuine commitment to excel
Technical:
Operating Systems - UNIX Sun Solaris, MS Windows 2000/XP/7
ETL Knowledge - Ab Initio: Co>Op Sys 2-15-8-4/3.0.3.9
GDE: 1.15.9.2/ 3.0.4.1
Databases - Oracle 11G,MS SQL Server, DB2
Scheduler – Autosys
Languages - PL/SQL,Unix Shell Scripting
Hardware - IBM/Dell Windows Servers
System Design - Thorough knowledge of Analysis, Design, Development & Testing.
Others - SQL Navigator, SQL Loader, Toad, MS Office, Microsoft Visio, SQL Developer
Certification:
INS 21 – Property and Liability Insurance Principles from AICPCU.
INS 23 – Commercial Insurance Principles from AICPCU
ARE 144 – Reinsurance Principles and Concepts from AICPCU
Education:
Bachelor of Engineering from Anna University /Government College of Technology, Coimbatore, Tamil
Nadu.
Work Experience:
Adjustment Module System (AMS) for AIG, USA July 2015 – Jan 2016
Role: Sr. Ab Initio Developer/Onsite Coordinator
AMS (Adjustment module System) is the underwriting application which will adjust the premium based on the loss exposure received from the audit team after the policy period. The system uses Ab Initio as the ETL tool and processed data will be stored in DB2 database and sent to downstream system for booking purpose. System also has a front end Java application which interacts closely with the batch application in each step of the workflow.
Responsibilities:
Responsible for development, integration and support of distributed environments and single server environments. (Part of team in offshore location).
Responsible for gathering and translating detailed Business and Technical Requirements from Clients
Design ETL jobs as per Specifications mentioned in Low-Level, High-level and Functional design documents
Follow TCS process improvement Methodologies (IPMS, IQMS) to expedite process of the existing or new data warehousing system
Involved in Data Migration to process or transferring data from one system to another while changing the storage, database or application using ETL Ab Initio.
Involved in writing SQL –Join queries for data comparison
Involved in Unit testing and System testing.
Used different EME Air commands in project promotion like air tag create, air save, air load, air project export etc.
Scheduling and monitoring jobs in Autosys.
Participate in Change Management procedures by checking in the changed code in PVCS and Ab Initio EME
Performance Tuning and Enhancing the Components depending on the Client requirements.
Co-ordination of work between Onsite and Offshore.
Maintaining the AMS applications and their documentation up to date with proper Maintenance Strategy
Assisted in developing user manuals, system documentation and training material for application users.
Involved in client presentations and user training.
Involved in Status meeting with client and Business representing the Team from Development Side.
Maintaining all the documents in document inventory (eROOM) with version controlled.
Supported my front end Java application from Onsite.
Responsible for client hand off, training, troubleshooting and follow up.
Part of Disaster Recovery Coordination group between different teams/personnel (backup team, system admins, n/w admins, dbas, programmers, analysts, vendors)
Environment: Ab Initio Co>Op Sys 3.0.3.9, GDE 3.0.4.1, DB2, Autosys, Unix Shell Scripting,ETL,PVCS, Putty, Windows 7
Reinsurance Information Management System (RIMS) for AIG, USA Jan 2013 – June 2015
Role: Sr. Ab Initio Developer/Onsite Coordinator
RIMS (Reinsurance Information Management System) is the reporting system providing time persistent snapshot of the Reinsurance information as well as to cater to the demand for quality date by the user group. Processed data are stored in event based fact manner and reporting data are stored as event based data in star schema model for COGNOS reporting. Reports and feeds are created for reinsurers for accounting purposes. The goal of this project is to rewrite the legacy reporting carried out in Oracle stored procedures and Shell scripts to Ab Initio reporting.
Responsibilities:
Responsible for development, installation, upgrade, migration, administration, integration and support of distributed environments and single server environments. (Part of team in offshore location).
Responsible for gathering and translating detailed Business and Technical Requirements from Clients
Design ETL jobs as per Specifications mentioned in Low-Level, High-level and Functional design documents
Follow TCS process improvement Methodologies (IPMS, IQMS) to expedite process of the existing or new data warehousing system
Participate in Change Management procedures by checking in the changed code in PVCS and Ab Initio EME
Performance Tuning and Enhancing the Components depending on the Client requirements.
Developed Ab-Initio graphs using Ab Initio Parallelism techniques, Data Parallelism and MFS Techniques with the Conditional Components and Conditional DML.
Involved in designed and development of integrated Data warehouse environment using Star schema model.
Responsible of scheduling the Ab Initio jobs through Autosys by preparing JIL and maintaining the job run.
Co-ordination of work between Onsite and Offshore.
Maintaining the RIMS applications and their documentation up to date with proper Maintenance Strategy
Assisted in developing user manuals, system documentation and training material for application users.
Involved in client presentations and user training.
Involved in Status meeting with client and Business representing the Team from Development Side.
Maintaining all the documents in document inventory (eROOM) with version controlled.
Responsible for supporting the reporting Team (COGNOS) for fine tuning the report queries and analyzing the poor performance of reports.
Supported my front end Java application from Onsite.
Responsible for client hand off, training, troubleshooting and follow up.
Part of Disaster Recovery Coordination group between different teams/personnel (backup team, system admins, n/w admins, dbas, programmers, analysts, vendors)
Environment: Ab Initio Co>Op Sys 3.0.3.9, GDE 3.0.4.1, Oracle,ETL, Autosys, Unix Shell Scripting, PVCS, Putty, Windows 7
Reinsurance Data Processing System (RDPS) Rewrites for AIG, USA Dec 2009 - Dec 2012
Role: Ab Initio Developer
RDPS (Reinsurance Data Processing System) is the main reinsurance information system for DBG Pro-Rata reinsurance providing automated processing, billing and reporting capabilities. In addition, RDPS provides limited functionality for Excess of Loss (XOL), such as subject base premium reporting for XOL and loss reporting. The goal of the project is to develop and enhance the RDPS Data Warehouse system to make it a single stop shop for all data needs. This project will achieve the business need to avoid reconciliation efforts between different systems when the user needs to generate different reports from different systems.
Responsibilities:
Responsible for gathering detailed Business and Technical Requirements from Clients.
Creates new data analytical region for incorporating the business requests.
Converts the business requirements to detailed technical structure for data warehouse projects
Design ETL jobs as per Specifications mentioned in Low-Level, High-level and Functional design documents.
Involved in creating automated UNIX shell scripts for code checkin and tag creation.
Involved in creating generic graphs for data copy from production region to lower regions for testing purpose.
ETL batch jobs monitoring and status verification.
Ensuring the Quality of delivery by following TCS Methodologies.
Provide Weekly, Biweekly and Monthly Metrics and Status reports in a customizable format and sends for Approval
Understanding existing business model and customer requirements.
Supported the DBA team in designing and maintaining Data Warehouse environment.
Prepared User documentation to train users and functionality of each report.
Provided tier 3 24/7 support to the end users.
Production Support which involves solving user problems
Maintaining the RDPS applications and their documentation up to date with proper Maintenance Strategy
Experienced as Ab Initio pool members supporting various Ab Initio application in AIG account.
Environment: Ab Initio Co>Op Sys 2-15-8-4/3.0.3.9, GDE 1.15.9.2/3.0.4.1, Oracle, Autosys, Unix Shell Scripting, PVCS, Putty, Windows 7
Contact this candidate