Project Data
Resume:
THOMAS EMMANUEL KADANKAVIL
Objective: To pursue a highly rewarding career, in a challenging environment of growth and excellence where I could contribute immensely, be part of the growth trajectory and gain exposure to leading technological advances in the Business Intelligence and Analytics space and proactively contribute to consultation and solutions.
Email:
**************@*****.***
Skype:
thomaskadankavil
Contact Number (Mobile):
Personal Data:
DOB: 12th Oct 1981
Sex: Male
Nationality: Indian
Marital Status: Married
Visa: H1-B
Professional Experience Summary
8.5 years of BI experience in Banking,Insurance, Telecom, Energy, Retail and Aerospace.
Presales experience in SAS EBI and Analytical Solutions
6 month Internship with the Corporate MIS Team in Allianz Cornhill
Expertise in SAS V9 BI (Base, Macros, SQL, EG, BI Solutions).
Exposure to BI Tools like IBM COGNOS,MSBI, Netezza
Experience in Data Analysis, Social media Analysis and Segmentation using SAS, Infosys HIMI VOC and Excel.
Experience in Data warehousing,Report Building and Automation
Liaised with Client Architects and Senior Management for requirements gathering and Business Analysis
Educational Summary
Qualification
University, Institute
% / GPA
Year of Completion
Master of Science in
Information Technology(MSIT)
Indian Institute of Information Technology and Management, Kerala,Trivandrum,(IIITM-K)
8.0
2007
Bachelor of Engineering (B.E.) in Electronics and Communication
Vinayaka Missions College of Engineering,,Salem
71.68
2004
ISC
Alphonsa Residential School, Bharananganam
67
2000
ICSE
Alphonsa Residential School, Bharananganam
77.16
1998
Technical Summary
Operating Systems
HP UNIX, MS-DOS, Windows XP/Vista/7,MVS,SOLARIS
BI TOOLS
SAS EBI (SAS Foundation, EG 4.3,DI 4.2,WRS 4.2,OLAP 4.2,MC 4.2),Microsoft BI (SSAS,SSRS), IBM COGNOS Report Studio 10.1, MDX
Scheduling Tools
IBM Tivoli Work Scheduler,JCL, Unix Scripts, Control M
Source Control
Plainview, Visual Source Safe 6.0,SVN
Database
MS SQL Server 2008R2, Oracle 10g
DWH Appliance
IBM PureData System (Netezza )
Corporate Training Summary
1)SAS Anti-Money Laundering (AML) – April2012
2)SAS Enterprise Governance Risk and Control (EGRC) –June 2011
3)SAS Assets and Liability Management (ALM) – May 2011
4)IBM Smarter Planet for Cities – June 2013
5)SAS Enterprise Miner 6 – May 2011
Total Work Experience – 8.5 Years
Organisation
Designation
From
To
Infosys Ltd
Technology Lead
27-SEP-2010
Till Date
Allianz Insurance (ACIS)
Senior Software Engineer
11-DEC-2006
17-SEP-2010
Employment Details with Infosys Limited
Project 1
AMK KYC
Client
Citizens Bank
Duration
6 Months
Team Size
5
Software
Base SAS,SAS SQL,SAS EG 4.3,SAS ECM,Oracle
Overview
Objective of the Project was to Develop and support The Anti Money Laundering Platform which was required by OCC to Risk Rate all customers within the bank.Phase 1 of the project is to build the warehouse to risk rate the customers and to support all future complance related activities to be done on the stored data.Integraion of data from various source systems across technologies and applying regulatory rules to create cases for investigation was the highlight of all activites undertaken in the initial phase
Responsibilities:
1.Data Analysis
2.Business Requirements Gathering
3.Estimation
4.Build Base Layer Integration
5.Testing
6.Production Support
7.Project Management
Project 2
Prescription Reporting and Compliance
Client
CVS CAREMARK
Duration
8 Months
Team Size
6
Software
Base SAS,SAS SQL,SAS EG 4.3,DI Studio, SAS OLAP Studio,Oracle
Overview
Objective of the Project was to support the Develop and maintenance of Compliance Data Marts for the CVS Compliance Department. Data was sourced from the Prescription Data Warehouse Other activities included support from Offshore, Development and Maintenance, Quality and Testing activities and provide accurate and on time delivery of Critical reports to Senior Management. The reports were being used by the compliance department on a regular basis.
Responsibilities:
1.Source Data Analysis
2.Estimation
3.Build-SAS Data Marts and Reports
4.Testing
5.Production Support
6.Project Management
Project 3
Nexus-Operational Reporting
Client
MERCEDEZ BENZ USA
Duration
5 Months
Team Size
6
Software
IBM DB2, IBM COGNOS Report Studio
Overview
Objective of the Project was to support the development and enhancement of New Tax Reports, Finance and Operating Lease Reports created for the State Tax Compliance department in MBFS. Reconciliation of financial data and validation of new and existing reports were part of the project activities. Project was very critical in supporting the client departments in meeting with compliance and regulations.
Responsibilities:
1.Data Analysis
2.Estimation
3.Technical Documentation
4.Report Build
5.Testing
Project 4
CLIENT INSIGHT FOR MOBILITY
Client
BELL CANADA
Duration
20 Months
Team Size
5
Software
Base SAS,Macros, SQL,SAS EG 4.3,DI Studio, OLAP
Overview
Objective of the Project was to Analyse, Develop Data Marts and Analytical reports for the BELL Marketing department for Performance Measurement and Improvement. Data was sourced from Bell Mobility division which included CDR, Devices, Plans, Location etc. Other activities included support from Offshore, Development and Maintenance, Quality and Testing activities and provide accurate and on time delivery of Critical reports to Senior Management. The reports were being used by the Senior Marketing executives on a regular basis and provided critical inputs for decision making. AGILE was the adopted PM Methodology.
Responsibilities:
1.Requirements /Business Analysis
2.Data Analysis
3.Estimation
4.Build-Data Marts and Reports
5.Testing
6.Production Support
Project 5
Enterprise Architecture Source Reporting
Client
BOEING
Duration
12 Months
Team Size
6
Software
IBM Cognos 10.1 Report Studio, Framework Manager, MS SQL Server2008R2
Overview
To build a highly accurate and detailed Reporting framework for the aerospace Major and be able to produce report and/or conduct analysis about logical and physical architecture components for a list of applications. Ensure high security of data and reports in order to maintain confidentiality. Using the Reports users must be able to perform impact analysis for architecture and key business measurements caused by the time and event based migration and changes in infrastructure deployment
Responsibilities:
1.Requirements /Business Analysis
2.Data Analysis
3.Estimation
4.Report Build
5.Testing
6.Deployment
Project 6
SOCIAL MEDIA Analysis (SMA) Innovation Project
Client
VODAFONE
Duration
6 Months
Team Size
4
Software
MS SQL Server2008R2,Infosys HIMI VOC,Hadoop,Google Search Appliance,SSAS
Overview
Objective of the Project was to Analyse and find Insights from Unstructured Data obtained from Client forums coupled with Structured Data .Project used Text Mining and NLP to leverage on the Social Media data crunching exercise, in order to aid the Marketing and Handset division of the Client. Project delivered key insights which gained much appreciation from client.
Responsibilities:
1.Business Case Development
2.Source Identification and Analysis
3.Extraction using Crawler
4.Data Analysis,
5.Reports Development
6.Results Analysis and Client Presentation
7.Project Management
Project 7
Occupational Hazard & Safety Data Marts
Client
CANADA POST
Duration
9 Months
Team Size
10
Software
Base SAS,Macros,SQL,SAS EG 4.3,DI Studio, OLAP,WRS
Overview
Objective of the Project was to Develop Data Marts and Analytical reports for Canada Post in order to Analyse and Track employee accidents during work. Information collected and stored was intended to improve accuracy and efficiency of incident information in order to improve the claims management process, reduce claims and severity and help create a proactive incident prevention strategy
Responsibilities:
1.Reporting Requirement Analysis,
2.Framework Development
3.Build and Support,
4.Data Validation and testing
5.Quality Improvements
Employment Details with Allianz Cornhill Information Services (ACIS)
Project 1
GLM
Client
Allianz Personal Insurance U.K
Duration
18 Months
Team Size
6
Software
Base SAS,MACROS,SQL,Mainframe JCL,Natural,Oracle
Overview
The objective of this project is to model the historic claim cost of the existing business in order to improve our rating structure or adjust the prices in different segments within the existing rating structure. GLM aims to:-
Identify threats where we are overpriced or under-priced & suggest corrective action
Identify opportunities where we can alter the structure to gain a competitive advantage / improve loss ratio.
We provide data to the Actuarial and Planning division; in the way they want it to be suitable for modeling.
Responsibilities:
1. Design the structure of the datasets
2. Formulate the dataset design principles
3. Define rules for the derivation of certain fields
4. Define rules for contra transactions, back dated transactions and earnings pattern.
5. Interact with Actuarial and Planning Division to confirm rules
6. System and Technical Documentation
SAS Programming
Extract data from the Mainframe CSV files using SAS.
Manipulate the data and apply the above mentioned rules to the data and build the Allianz Household MIS datasets using SAS (BASE/Macros)
Identify data issues and take corrective actions.
Create the GLM report
Project 2
Lloyds Daily Reporting
Client
Allianz Commercial,Lloyds UK
Duration
6 Months
Team Size
6
Software
Base SAS,Macros,SQL,SAS EG,Unix Scripts
Overview
This project aims at creating a new set of reports to provide a daily Premium report for the commercial business and the external client Lloyds TSB to provides the business with an analysis
Tool which provides a historical analysis of premium movement and claims development.
Using this report, development of premium movement and claims development can be compared in relation to the business plan. The report also provides a summary of the projected development of claims.
Responsibilities:
1.Prepare the Technical Requirements Document
2.Develop SAS programs to create the report.
3.Create new extracts from the Mainframe Commercial systems
4.Quality Improvement
Project 3
Backups, DR and Improved Efficiency for ACP MIS datasets.
Client
Allianz Personal and Commercial Insurance U.K
Duration
12 Months
Team Size
6
Software
Base SAS,Macros,SQL,SAS EG,Unix Scripts
Overview
This project is initiated with the following objectives:-
Enabling backups of large data files.
Enabling restores and disaster recovery of large data files
Reduces the need for cycling and snapshot versions of large datasets and so reduces the volume of data stored in the data warehouse.
Reduce incremental build times of datasets as only the incremental portion of input files can be read, rather than reading the entire input file.
Responsibilities:
1.Involved in designing the solution for this project
2.Develop the System Requirements and technical solutions document.
3.Amend existing/write new SAS programs to implement the technical solution
Project 4
Claims Knowledge Acquisition project (KAP)
Client
Allianz Claims Department U.K
Duration
12 Months
Team Size
3
Software
Base SAS,Macros,SQL,SAS EG,Unix Scripts
Overview
The objective of the project was to build a comprehensive knowledge repository for the Claims Department falling under the Corporate MIS structure in ACIS. The project was a candidate for OPEX (Operational Excellence), which is a derivative of the famed Six Sigma methodology for process improvement within the Allianz group. Liased with UK Claims business, SAS and Mainframe colleagues.
Responsibilities:
1.Creation of Business Understanding Document
2.Creation of MIS Claims System documentation
3.Liaise with Claims Mainframe Team
4.Understating and standardising Production Support activates
I hereby declare that the above mentioned details are true to the best of my knowledge.
18.12.2015
CRANSTON Thomas Kadankavil
Professional Reference:
1)Yugandhar Kancharala,
SAS Architect,
First Niagara Bank
Pittsburgh,PA
MOB: +1-301-***-****
Email:***********@*****.***
Contact this candidate