Rakesh Ramasamy

Experience

• 

  Aon

  Jun 2007 - Jun 2010

  Implemented a Conversion Out project for EDS Client - The conversion of all the employee details stored in the DB2 should be converted and stored in the form of Generational data sets and delivered to the client. This is done when the client chooses another record keeper for the maintenance of their payroll.Implemented a XML Data Extraction project - Created a customised macro, to write the data from a SAS dataset into a XML file.Intensively used SAS macro programming to make the process more reusable and efficient.Implemented Batch Processing for various clients.Developed and scheduled batch SAS jobs for Health and Group Benefits activities like Annual Enrollment, HR data load, Payroll Activities, Audit Files etc. Created third party vendor reports like Death Master Report, Payroll outbound report as part of the implementation. Show less

  • Senior Batch Analyst

    Feb 2009 - Jun 2010

  • Batch Analyst

    Jun 2007 - Jan 2009
• 

  Capgemini

  Sept 2010 - Nov 2017

  (Project) Insights & Data EDO (Role) Senior Data Analyst (Client) British Gas, UK My responsibilities included understanding the existing Teradata Utility Data Model and provide a helping hand to the business team in designing various solutions/data marts.• Actively involved in designing and developing solutions for Customer requirements, with focus on data analysis and architecture.• Actively involved in designing various Data Source’s for ARM, based on the requirements from the business team.• Involved in designing various data marts/data mapping and assisting the development team in the process of data extraction from Physical Data Model, which would further act as a source for campaign/analytics team.• Involved in SQL Performance Tuning and Optimizing complex SQL Queries.• Acted as a point of contact for both the Customer and Offshore team and liaising between both to ensure all the requirements are met and all the problems are resolved.• Involved in designing a complex month/weekly refresh analytics views which would act as a source for Data Analytics team to have a better understanding on their business and to ease on decision making process.• Involved in various complex data issue investigations with persistence by engaging with various stake holders to get it resolved.• Involved in designing various data extraction process for campaign activities such as Home Care, GAC and KAC Customer Survey, Party Telephone Best etc. Show less (Project) Solvency II QRT Reporting (Role) Data Architect for Solvency II QRT Reporting (Client) MS Amlin Insurance, UK Involved in the design/implementation of the following Key Modules: -Investments, Profit and Loss Modules;• Responsible for the creation of Logical and Physical data models for Investments, Profit and Loss modules.• Involved in the preparation of various QRTs (Quantitative Reporting Templates - Summary of Assets, List of Assets, Open Derivatives, Closed Derivatives, Structured Products, Repos & Assets held as Collateral) for Assets and Investments (including Look-Through approach) as per Solvency II directives for Pillar 3 Reporting.• Responsible for the design of end to end SSIS and Tagetik ETL inclusive of reconciliation and error handling process.• Responsible for the data extraction - Involved in the process of designing source interface for Data extraction. Have been integral part of all discussions with business team related to data extraction. • Responsible for the creation of High level Design and Data Mapping artifacts which has been set as benchmark and have been used across various other work packages.Overall Batch Design• Responsible for the creation of overall batch processing/process control design with various process control tables to control the ETL load processing.Reconciliation• Responsible for the creation of Reconciliation design to compare source and target to ensure that the value/counts are in agreement and are accurate.• Excel reports are produced for the end users and it involves all the key data elements that will enable IT and business to give confidence that data in Solvency data store is complete and accurate. Show less (Project) Solvency II (Role) ETL Senior Developer and Lead Analyst (Client) Direct Line Insurance, UKDeep understanding of Solvency II Data Warehouse tables & Views.Lead a team of around 10 developers and testers, from Onsite location.Worked on complete end-to-end process, starting from user meetings until post production support.Experience in Requirements gathering, Analysis, Coding, Review, System Testing, User-Acceptance Testing, Deployment and post production support.Experience in Change Management Process.Played a major role in the following implementations:-Implementation of Reserving Data Marts.Implementation of Loading client's Assets & Investment Data into Solvency II Warehouse, received from various third party agencies such as Blackrock, Bloomberg etc.Implementation of Capital Modelling Data Marts based on the Assets & Investment Data.Involved in the Preparation of various QRTs (Quantitative Reporting Templates – D1, D1O, D1S, D2O, D3, D4, D5 & D6) for Assets and Investments (including Look-Through approach) as per the Solvency II directives for Pillar 3 Reporting. Show less Involved in the implementation of building Solvency II Data Warehouse - Involved in loading various forms of data such as Policy, Claims, Investments (Bonds, Cash, Fund, Derivatives, Property), Interest Rates, Exchange Rates and GL Transactions into Solvency II Data Warehouse.Involved in the implementation of various Data Marts such as Reserving Data Mart, Capital Modelling Data Mart and Reconciliation Data Mart. Involved in analysing trends and monitoring movements in Claims data using SAS and Excel. Involved in creating Vectors and Triangles for Premiums and Claims from Solvency Data Warehouse.Actively participated in the design decisions. Built various Generic SAS Macros & Generic SAS DI Custom Transformations.Traveled to UK (Client Location) to support the development team during SIT and UAT Testing Phase. Show less

  • Senior Consultant

    Nov 2016 - Nov 2017

  • Senior Consultant

    Feb 2016 - Oct 2016

  • Senior Consultant

    Apr 2014 - Feb 2016

  • Consultant

    Jan 2012 - Mar 2014

  • Associate Consultant

    Sept 2010 - Jan 2012
• 

  Capgemini

  Jan 2019 - now

  • Senior Manager

    Sept 2021 - now

  • Manager

    Jan 2019 - now