Kevin Arakal

Kevin arakal

bookmark on deepenrich
location of Kevin ArakalBengaluru, Karnataka, India
Phone number of Kevin Arakal+91 xxxx xxxxx
Followers of Kevin Arakal267 followers
  • Timeline

    Jun 2005 - Jul 2006

    Kintana Admin

    Washington Mutual Card Services
    Current Company
    Jul 2006 - now

    Data Analyst

    Wipro Technologies
    Jul 2006 - May 2008

    Senior Software Engineer

    Dun and Bradstreet
    Jul 2008 - Dec 2008

    Senior Software Engineer

    Toys"R"Us
    Jan 2009 - Oct 2009

    Consultant

    NATIONAL GRID UK LIMITED
    Nov 2009 - Dec 2010

    Module Lead

    Dun & Bradstreet
    Feb 2011 - Oct 2011

    Module Lead

    RWE Generation UK plc
    Feb 2012 - Nov 2013

    Team Lead

    State Street
    Jan 2013 - Apr 2014

    Associate Consultant

    STMicroelectronics
    Jun 2014 - Feb 2016

    Associate Consultant

    EMC Corporation USA
    Jan 2016 - Jul 2018

    Test Team Lead

    Philips Innovation Campus, Bangalore
    Nov 2018 - Dec 2024

    Data Analyst

    AIB (Allied Irish Banks) Ireland
  • About me

    Data Analyst at AIB (Allied Irish Banks) Ireland

  • Education

    • Bharathidasan university

      1998 - 2001
      Master of computer applications - mca computer applications first

      Activities and Societies: Computer Applications Computer Applications

    • Jayaram college of engineering and technology

      -
      Master of computer applications (m.c.a.) computer science
  • Experience

    • Washington mutual card services

      Jun 2005 - Jul 2006
      Kintana admin

      Kintana is an enterprise management tool for managing IT related functions. In Providian perspective we are using Kintana for managing all the demands (Requests), projects and also the time that a resource worked. It provides step by step process required to complete a project and update the status of the task. Kintana project Manager provides increased visibility for all participants with consideration of the level of complexity required for their job responsibilities. It enables to develop the organization and improve its effectiveness and quality of work under a Centralized Management. Kintana provides all users a complete, real time, overall initiatives in the enterprise at various levels of summarization or detail. Along with built-in reports Kintana also provides options for creating customized reports. Show less

    • Wipro technologies

      Jul 2006 - now
      • Data Analyst

        Oct 2017 - now
      • Team Lead

        Jul 2006 - now
    • Dun and bradstreet

      Jul 2006 - May 2008
      Senior software engineer

      IQ data mart is the Heart of Management Reporting System. This warehouse database (Sybase) contains about 90% of reporting data. Reports generated from these data are used by teams across D&B for Financial planning /analysis /forecasting. Transactions from back office legacy system (BOLT) an online transaction processing systems gets loaded into IQ database on a daily basis. IQ system is feeding many down stream applications like customer knowledge, grasp, OTM etc.

    • Toys"r"us

      Jul 2008 - Dec 2008
      Senior software engineer

      The Vendor Deal Portal application enables Vendors to access the Credit Allowance related information through the Vendor Portal. It is enhanced with many new features for end users including a dashboard. The dash board associated with the VDP application is available for a set of privileged users which helps to access up to date information in various levels of summarization or detail.

    • National grid uk limited

      Jan 2009 - Oct 2009
      Consultant

      A Study was conducted as a part of iGMS Asset Health study project to look into the application components for Business Applications and provide recommendations towards improving the stability and serviceability of the system. One of the key observations of the project was the frequent failure of the Oracle streams process, used for the intra-system communication between the sub-systems of iGMS (Integrated Gas Management System). This is considered to be the transfers a huge amount of data to the MSI side through the oracle stream. A solution has been proposed and implemented as part of iGMS Asset Health for reduction of load via applying a ‘conditional rule based’ capture process of Oracle Streams. Show less

    • Dun & bradstreet

      Nov 2009 - Dec 2010
      Module lead

      The purpose of the project is to drive on-time sales renewals and build new product line for D&B while balancing Customer Satisfaction concerns. Another goal is to introduce various service termination options to increase the revenue by restricting the number of customers receives D&B services beyond contract expiration without signing a new contract. The new product line roll-out will be coupled with the launch of a new pricing model, enabling D&B to more closely align price-to-value and optimize price realization and the new pricing model will address the problems with the current pricing model. All the existing contracts had undergone a onetime migration process, so that it will follow the new pricing model immediately after the current contract terminates. A secondary goal is to provide more transparent reporting about the customers in the bridge period. Show less

    • Rwe generation uk plc

      Feb 2011 - Oct 2011
      Module lead

      The Domino program is driven by the RWE Npower Retail (“Retail”) recognition that it’s key operational and marketing data are critical assets that need to be managed effectively. An exercise was carried out within Data Services to identify best practice approaches to data management and provide recommendations towards improving the stability and serviceability of the system. As part of domino program RWE decided to migrate critical applications like Formfill, PPMS, EPPS servers from the current ‘aged’ servers to a more updated environment for improving accessibility and the performance of the system. All the migrated applications have been tested properly and submitted a detailed performance results. Show less

    • State street

      Feb 2012 - Nov 2013
      Team lead

      ETP application team will assist the business, end-user community and business support groups in implementing various business scenarios, also responsible for the continued integrity of the application and fulfill state street corporation’s overall strategic objectives. The ETP system will accept and process the Portfolio Composition File on a daily basis created by the ETF fund manager after the market close. The information will allow the Portfolio Management team to have visibility into the make up of the fund’s cash component number for the next business day’s estimated cash and trading. The ETP system feed various downstream system also. Reports generated from these data are used by teams across state street for planning /analysis /forecasting etc. Show less

    • Stmicroelectronics

      Jan 2013 - Apr 2014
      Associate consultant

      The Enterprise Hub project encompasses the process to transform the existing Informatica MDM HUB from an analyticalapplication to an operational application, to enable Customer creation and to manage and govern the Enterprise masterdata att ributes of a customer. A new Web Application, designed to leverage the new set of services for Customercreation.A high availability infrastructure to improve response time to the requestor and to enable real time capab ilities. Theauto-create of the customer master record will drive this.• Manage the custom er master data through web application, where the user will submit a request toadd/change data. Based on completeness and accuracy of the data submitted the changes will be applied automaticallyto downstream systems. If the submitted data does not meetthe standards the request will be reviewed before updateis made to downstream systems like Oracle 11i and Propel SAP.Responsibility: A new Web Application, designed to leverage the new set of services for Customercreation.• Design Phase: Each of the requirements analyzed and different design approach was presented. The designdocuments were delivered on time.• Construction Phase: singlehandedly designed and create a work flow management system ;using oraclePL/SQL and which can be processed through IDD .written all customization code for MDM using PL/SQL .Provide necessary guidance to the team, quality review was conducted and necessary steps were taken on theobservations.• Testing Phase: Helped tthe testing team to create th e test cases for system and system integration testing. Reviewed test cases and test implementation plan.• Conducted weekly progress meeting with onsite team, maintained risk registrar, generate tractability matrix foreach transaction. Show less

    • Emc corporation usa

      Jun 2014 - Feb 2016
      Associate consultant

      The Enterprise Hub project encompasses the process to transform the existing Informatica MDM HUB from an analytical application to an operational application, to enable Customer creation and to manage and govern the Enterprise master data attributes of a customer. A new Web Application, designed to leverage the new set of services for Customercreation. A high availability infrastructure to improve response time to the requestor and to enable real time capabilities. The auto-create of the customer master record will drive this.• Manage the customer master data through web application, where the user will submit a request to add/change data. Based on completeness and accuracy of the data submitted the changes will be applied automaticallyto downstream systems. If the submitted data does not meet the standards the request will be reviewed before update is made to downstream systems like Oracle 11i and Propel SAP.RESPONSIBILITIES: Design Phase: Each of the requirements analysed and different design approach was presented. The design documents were delivered on time.• Construction Phase: singlehandedly designed and create a work flow management system using oracle PL/SQL and which can be processed through IDD .written all customization code for MDM using PL/SQL .Provide necessary guidance to the team, quality review was conducted and necessary steps were taken on the observations.• Testing Phase: Helped the testing team to create the test cases for system and system integration testing. Reviewed test cases and test implementation plan.• Knowledge transfer: provide knowledge transfer to support teams in offshore and onsite. Prepared and updated all necessary KT doc and shared with the team and uploaded in the harvest. Show less

    • Philips innovation campus, bangalore

      Jan 2016 - Jul 2018
      Test team lead

      BPDH program aims to implement Informatica MDM as the backbone of Master DataManagement. Informatica MDM will be used by the Philips Healthtech organization for theconsolidation of data for their Business Partner (Customer ,Vendor and PTC),Finance and Product.This project will deliver:Customer A-level data maintenance (including Workflow)Cleansing / De-duplication capabilitAddress ValidationBi-directional integration with SFDCAuditing and DQ monitoringResponsiblity: Lead a team size of 10. Planning task for individuals and tracking the tasks. Provide necessary guidance to the team,Reviewed the test cases.Interacting with the business team to understand the requirements.Prepration test implementation plan.Preparation and execution testcases.support release management activities and production support activitiesConducted weekly progress meeting with onsite team, maintained risk registrar,generate tractability matrix for eachrequirement Show less

    • Aib (allied irish banks) ireland

      Nov 2018 - Dec 2024
      Data analyst

      Data Quality Scorecards are built to provide metrics (Completeness, Consistency, Accuracy, Timeliness) on the quality of data on source systems and the EDW integrated data layer. These scorecards are reviewed by the Data Quality working group who represent the producers and consumers of data across AIB. Any issues identified via the scorecards are discussed with the Data Business Partners at the Data Quality Working Group and reported to the Data Quality & Governance Forum as required. The Existing Data Quality platform is being decommissioned by the end of FY2019. All capabilities, reports, profiles and scorecards will now be hosted on new Qlikview platform. The DQ team will ensure that all key functionality is replicated in the new platforms and providing support throughout the migration.RESPONSIBILITIES: Meet the customers to understand the requirements, gather and document requirements, ensure to meet customer expectations.Identify the existing IDQ Mappings/Maplets ,understand the business logic , prepare the requirement document get it reviewed and share team for migration.Enhancements, maintenance and production support of the existing application.Testing and UAT cycle support.Preparation of data set (successful and failure records)Root cause analysis of failed / mismatch records Show less

  • Licenses & Certifications

    • Snowpro core certification

      Snowflake
      Dec 2024
    • Oracle certified associate - oracle 10g database administrator

      Oracle
      Dec 2015