Rakesh Aele Lokesh
Data Analyst
Düsseldorf
Summary
Over 14 years of industry experience with wide range of application development using SAS and Talend tools in Data Analytics, Data warehousing, Business Intelligence and Database administration in Tata Consultancy Services Ltd.
Overview
13
13
years of professional experience
4
4
years of post-secondary education
3
3
Certifications
Work History
Technical Lead
IFRS 17 Project in German insurance company
1 2020 - Current
- Led integration and reporting efforts for IFRS 17 project in German insurance company
- Developed multiple data pipelines to read data from contract and claim systems
- Generated quarterly reports based on future premiums and contracts in force
- Processed input data from DB2 and generated CSV files for analysis
- Worked closely with requirements engineers to design and build data pipelines
- Collaborated with contract operation databases to build reports for various lines of business, including Fleet and KT
- Implemented new entities and changes requested in existing reports, ensuring business needs
- Managed deployment activities using mainframe tools such as Endevour and ISPW
- Coordinated with batch support team to handle production issues efficiently
- Provided production support for legacy systems, ensuring minimal downtime and quick resolution of issues.
SAS Developer
IFRS9 Impairments for Swedish bank
01.2018 - 12.2019
- Worked on implementing IFRS9 standards for a leading Swedish bank
- Engaged in comprehensive analysis of business requirements to ensure alignment with IFRS9 standards
- Developed SAS programs using SAS Enterprise Guide to prepare data for Expected Credit Loss (ECL) calculations
- Managed and implemented change requests for model calibration to ensure accuracy and compliance
- Re-designed existing SAS programs to enhance performance and efficiency.
Data Integration Specialist
EDW project for Allianz Indonesia
12.2015 - 12.2017
- Worked at client's location in Jakarta, Indonesia
- Project aimed to build Enterprise Data Warehouse, incorporating Group Life, Group Health, Individual Life, and Individual Health data
- Source data was read from multiple databases, including Oracle, SQL Server, and manual files
- Collaborated with data modeler’s team to understand source-to-target mapping rules
- Analyzed requirements, framed business logic, and implemented it using Talend
- Participated in design and documentation of ETL processes
- Analyzed and performed data integration using Talend Open Integration Suite, developing jobs for Data Warehouse and Data Mart layers
- Focused on improving performance of Talend jobs
- Created triggers to run Talend jobs automatically on server.
SAS DI Developer
Data warehousing project for Allianz GloBI
01.2014 - 11.2015
- Analyzed and managed risks and challenges, both technical and non-technical, during development process
- Created and deployed jobs across different layers of Data Warehouse and Data Mart
- Developed ETL jobs using SQL pass-through in SAS DI Studio 4.5
- Possessed extensive knowledge of ETL concepts with practical experience using Oracle Database
- Provided support during System Integration Testing (SIT) and User Acceptance Testing (UAT)
- Analyzed ETL designs based on data mapping rules and provided feedback to ETL designers
- Ensured compliance with deployment processes
- Adhered to good programming practices and documented unit-test results using proposed template
- Improved performance of ETL jobs by tuning queries.
AMOS - BI Reporting project for Allianz Globi Services Limited
01.2012 - 12.2013
- Project aimed to create reports related to new business, portfolio, and new offerings
- Reports were delivered with multilingual support (English, French, and Dutch) and output formats included HTML, Excel, and PDF
- Analyzed business specifications to ensure accurate report development
- Applied performance tuning standards and guidelines to enhance report efficiency
- Created various SAS stored process reports based on specific requirements
- Developed graphical reports using SAS procedures
- Created reports using annotations as per requirements
- Coordinated with team and participated in discussions to resolve issues
- Responsible for documenting issues and conducting unit testing.
Education
Bachelor of Engineering - Information Science
Visvesvaraya Technological University
Belgaum 06.2005 - 06.2009
Skills
SQL Server, Oracle, MySQL, DB2
Base and Advance SAS, SQL, JCL
Microsoft Office Suite, JIRA, Confluence
Agile Methodology
Functional requirements understanding
Certification
SAS Certified Base Programmer for SAS 9
Education Summary
Bachelor of Engineering (B.E.), Information Science, Visvesvaraya Technological University (VTU) India, 07/2009
Awards
- Got Best Team Award for successful delivery of few critical projects in TCS.
- Suggested and implemented many Stored Procedures to reduce the efforts of repeated tasks
- Enhancing the efficiency and reliability of data pipelines, resulting in reduced data processing time and improved data quality.
- Providing training or mentoring to junior analysts or cross-functional teams on data analysis techniques and tools.
Languages
en
Bilingual or Proficient (C2)
kannada
Timeline
SAS Developer
IFRS9 Impairments for Swedish bank
01.2018 - 12.2019
Data Integration Specialist
EDW project for Allianz Indonesia
12.2015 - 12.2017
SAS DI Developer
Data warehousing project for Allianz GloBI
01.2014 - 11.2015
AMOS - BI Reporting project for Allianz Globi Services Limited
01.2012 - 12.2013
Bachelor of Engineering - Information Science
Visvesvaraya Technological University
06.2005 - 06.2009
Technical Lead
IFRS 17 Project in German insurance company
1 2020 - Current