Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Akash Kumar

Southampton,STH

Summary

Results-driven IT professional with 12 years of comprehensive experience in the IT industry, specializing in data warehousing, system migrations, and large-scale IT project delivery. Proven expertise in designing, implementing, and managing end-to-end migration strategies and data-driven solutions to optimise business performance. Adept at leveraging modern technologies and best practices to ensure data integrity, scalability, and seamless project execution. Strong analytical and problem-solving skills combined with a track record of collaborating with cross-functional teams to deliver high-quality results within tight deadlines. Passionate about driving innovation and continuous improvement to support organizational growth and operational excellence.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Senior Technical Lead

HCL Technologies UK LTD
01.2023 - Current
  • Collaborated closely with Data Architects, Business Analysts, and Data Analysts to gain a comprehensive understanding of the source data model, data quality, and target data model requirements.
  • Designed and developed efficient ETL jobs using enterprise ETL tools, including SAP Business Objects Data Services (BODS) and SSIS, to ensure accurate and effective data transformation and integration
  • Designed and built efficient ETL pipelines using SAP BODS and SSIS to support downstream applications and data warehouse operations.
  • Led a team of 7 ETL developers in an onshore-offshore model, ensuring timely delivery of project milestones and adherence to quality standards.
  • Proposed and implemented a value-added solution to automate the deployment of SAP BODS ETL jobs—achieving a non-native feature integration using PowerShell and Jenkins—resulting in significant time and effort savings. This initiative received client approval and commendation.
  • Transitioned into the role of Implementation Manager for a major platform technology migration project from Oracle to PostgreSQL.
  • Coordinated with diverse stakeholders to develop a comprehensive 5-day implementation runbook, ensuring seamless execution of the migration process.
  • Successfully completed the project by driving continuous improvements, incorporating lessons learned from key events such as dry runs and dress rehearsals to optimise processes and minimize risks.

Migration Analyst Developer - MS SSIS

FNZ
10.2021 - 01.2023
  • Analysed client data and models, developing ETL solutions to transform them into target supported data models, while producing business and technical reconciliations for client validation
  • Created databases and schema objects, including tables, indexes, and constraints, and connected various applications to the database, writing functions, stored procedures, and triggers
  • Designed SSIS packages using Business Intelligence Development Studio to transfer data from flat files and SQL Server databases to SQL Server
  • Extensively utilized SSIS transformations such as Lookup, Derived Column, Data Conversion, Aggregate, Conditional Split, SQL Task, Script Task, and Send Mail Task
  • Optimised database performance using Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to enhance query efficiency
  • Established SQL environments and created SQL Agent jobs to schedule and execute SSIS jobs

Technical Lead - SAP BODS

HCL Technologies UK LTD
10.2017 - 10.2021
  • Engaged with customers to discuss project progress, gather feedback at various stages, and address concerns directly
  • Collaborated closely with the testing team to design and develop solutions that met client requirements for functionality, scalability, and performance
  • Developed highly maintainable and reusable SAP BODS ETL code, suitable for both incremental and migration loads
  • Introduced sprint-based development and implemented best practices to enhance code quality and achieve project milestones
  • Managed a team of nine onshore and offshore personnel, focusing on implementing resolutions and updates
  • Prepared detailed reports on project updates, including progress, identified conflicts, and team activities
  • Authored best practices documentation to support training for existing personnel and onboarding of new team members
  • Documented all transactions and support interactions for future reference and knowledge base enhancement
  • Clearly explained technical information to non-technical stakeholders to foster better understanding and collaboration

Senior Software Developer - SAP BODS

HCL Technologies India LTD
12.2014 - 10.2017
  • Prepared Technical Design documents based on Functional documents
  • Prepared technical design documents based on functional specifications
  • Created multiple data store configurations in Data Services' local object library, integrating different databases to establish a unified data store
  • Managed several BODS installations, configured repositories, and established data source connections
  • Actively participated in all technical discussions and meetings, contributing key discussion points
  • Developed Data Integrator mappings for data warehouse loading, utilizing both simple and complex transformations such as Key Generator, Table Comparison, Case, Validation, Merge, and Lookup within Data Flows
  • Interacted with users to gather report requirements, provided mock-ups, and created proof of concept solutions to finalize requirements
  • Managed users and repositories within the Management Console
  • Designed and developed ETL routines in BODS, modifying or creating new Data Services jobs to meet project needs
  • Possessed a strong understanding of the end-to-end data migration process, including extraction, data profiling, transformation, and generation of load-ready data files
  • Skilled in interpreting, configuring, and implementing data mapping and transformation business rules into Data Services

Junior Software Developer - PL/SQL Oracle (10 G)

Sopra Steria India Limited
01.2014 - 12.2014
  • Participated in the entire project lifecycle, from initial planning to final delivery
  • Interacted with clients to thoroughly understand and document their requirements
  • Developed functions, queries, and triggers to meet application needs
  • Extensively utilized Ref Cursor, Bulk Collect, PL/SQL Collections, Dynamic SQL, and performed performance tuning at the query level
  • Resolved production issues for applications and ensured all support service level agreements were met
  • Prepared root cause analysis reports for problems encountered during production
  • Engaged in SQL query tuning to optimize database performance
  • Completed training in loading data from Oracle databases and text files to target Oracle databases using the ETL tool, Informatica
  • Developed UNIX shell scripts to extract data from Oracle databases into text files

Program Analyst - Mainframe Testing

Cognizant Technology Solutions
09.2011 - 07.2013
  • Collaborated with the development team and subject matter experts (SMEs) to thoroughly understand requirements
  • Prepared detailed test cases, test scenarios, and End of Test Reports (EOTR) for each release
  • Documented defects identified in each Change Request (CR) and release for future reference
  • Conducted system testing to ensure functionality and performance standards were met
  • Played a key role in identifying the root cause of defects and ensured all functionality requirements were fulfilled
  • Participated in System Integration Testing (SIT) and End-to-End (E2E) testing

Education

Bachelor of Engineering - Mechanical and Production Engineering

Sathyabama Institute of Science And Technology
05.2011

Skills

  • SQL (T-SQL), MS-SQL
  • SAP BODS 42
  • SSIS
  • Control-M
  • Azure Data Factory (ADF)
  • Azure Databricks
  • Azure Synapse Analytics
  • Azure Data Lake Storage
  • Azure Stream Analytics
  • Azure Blob Storage
  • Python (pyspark)
  • PowerShell
  • Jenkins
  • Apache Spark
  • Databricks

Certification

  • Microsoft Certified: Azure Administrator Associate - Microsoft (Completed : December 2024)
  • Microsoft Certified: Azure Data Engineer Associate - Microsoft (Completed : January 2025)

Timeline

Senior Technical Lead

HCL Technologies UK LTD
01.2023 - Current

Migration Analyst Developer - MS SSIS

FNZ
10.2021 - 01.2023

Technical Lead - SAP BODS

HCL Technologies UK LTD
10.2017 - 10.2021

Senior Software Developer - SAP BODS

HCL Technologies India LTD
12.2014 - 10.2017

Junior Software Developer - PL/SQL Oracle (10 G)

Sopra Steria India Limited
01.2014 - 12.2014

Program Analyst - Mainframe Testing

Cognizant Technology Solutions
09.2011 - 07.2013

Bachelor of Engineering - Mechanical and Production Engineering

Sathyabama Institute of Science And Technology

Similar Profiles

  • Kannan Natarajan

    Kannan NatarajanKannan Natarajan

    Delivery Head (Digital Business – RCPG, UK&I) at HCL Technologies UK LimitedDelivery Head (Digital Business – RCPG, UK&I) at HCL Technologies UK Limited

  • Sushant Jain

    Sushant JainSushant Jain

    AVP – Finance (Managing $4Bn Business) at HCL Technologies UK Ltd.AVP – Finance (Managing $4Bn Business) at HCL Technologies UK Ltd.

  • Ilakkuvan Parangusamy

    Ilakkuvan ParangusamyIlakkuvan Parangusamy

    Technical Manager at HCL Technologies UK LimitedTechnical Manager at HCL Technologies UK Limited

  • Jayakar Chellappa

    Jayakar ChellappaJayakar Chellappa

    Technical Lead at Tata Consultancy ServicesTechnical Lead at Tata Consultancy Services

  • Tolulope Arogundade

    Tolulope ArogundadeTolulope Arogundade

    Senior administrator, Referral Management Team at University Hospital Southampton - NHS Foundation TrustSenior administrator, Referral Management Team at University Hospital Southampton - NHS Foundation Trust

CREATE PROFILE
Akash Kumar