Summary
Overview
Work History
Education
Skills
Certification
Languages Known
Timeline
CORE COMPETENCIES
CAREER TIMELINE
AdministrativeAssistant
AVINASH KUMAR

AVINASH KUMAR

Pune,DL

Summary

Accomplishment-driven professional with nearly 7.5 years of experience as a Software Engineer, specialising in Oracle database development (11G/12C/19C) and full Agile Software Development Life Cycle (SDLC), including Analysis, Design, Development, Testing, and Deployment. Currently working as Lead Data Engineer at Birlasoft Limited, focusing on back-end system improvements, new feature development. Expertise in driving performance optimization and designing complex database objects like Stored Procedures, Triggers, Tables, Views, Indexes, and Collections. Strong problem-solving capabilities, enhancing legacy code and troubleshooting issues across QA, UAT, and Production environments to ensure system reliability and meet deadlines. Led a process improvement initiative by automating legacy manual report generation using Data Virtualization, SQL Loader, Unix Shell Scripting, and Python, improving efficiency. Continuously upgrading skills with certifications in Oracle PL/SQL, Liquibase, and Deep learning and Neural Network to stay current with industry trends. Proficient in designing, developing, and maintaining Oracle Databases and applications, ensuring high-quality standards, optimizing performance, troubleshooting issues, and collaborating with the team to resolve defects effectively.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Lead Data Engineer

Birlasoft Limited
09.2024 - Current
  • Project Name: FSS DB Stabilization
  • Clients: HPE, Bangalore
  • Technologies Used: SQL, PL/SQL, Informatica, Power BI
  • Tools & Platforms Used: Oracle 19c, PL/SQL Developer, ServiceNow, Git, Bitbucket
  • Description: Managed the archiving of HPI (Hewlett Packard Information) data, ensuring accurate transfer and secure storage of historical records. Extracted and transformed data from HPE systems, preparing it for reporting and visualization.

Associate Senior Software Developer

TSYS Card Tech Services India LLP
07.2023 - 08.2024
  • Project Name: PRIME
  • Clients: Scotiabank, Grupo Carrefour Brasil
  • Technologies Used: SQL, PL/SQL
  • Tools & Platforms Used: Oracle 19c, PL/SQL Developer, JIRA, Git, Bitbucket
  • Description: TSYS Prime is an API-driven, customer-centric payments platform used globally by financial institutions for card management and related applications. Its back-office operations, switching, and authorization features offer significant efficiency and cost savings compared to legacy systems.
  • Key Result Areas:
  • Lead the development of innovative features for the TSYS Prime payment platform, ensuring seamless integration with existing systems and improving user experience.

Senior System Engineer – I

Tata Consultancy Services Ltd.
07.2021 - 07.2023
  • Project Name: CCDW (End in Service & Product Activity)
  • Client: ICICI Lombard., Mumbai
  • Technologies Used: SQL, PL/SQL, Unix Shell Scripting, Python, Data Virtualization
  • Tools & Platforms Used: Oracle 12C, SQL Developer, PuTTY, WinSCP, JIRA, Informatica
  • Description: Developed and maintained insurance claim management applications for ICICI, ensuring accurate processing of claims and payments. Extracted, validated, and mapped insurance data from multiple databases, ensuring correct application of policy rates and claim rules. Streamlined data workflows and business logic to automate claim approvals and reduce processing errors. Generated and processed payment vouchers post-claim, integrating them seamlessly into SAP ERP modules
  • Key Result Areas:
  • Optimized data warehouse processes to ensure timely and accurate billing and inventory management reporting, thereby supporting key business decisions.
  • Developed and maintained SQL scripts and PL/SQL procedures to automate data extraction and transformation, enhancing efficiency.
  • Collaborated with stakeholders to define data requirements and align with business objectives, facilitating data-driven decisions.
  • Automated routine tasks using Unix shell scripts, minimising manual intervention and boosting productivity.

Software Engineer

Eastern Software System Pvt. Ltd.
02.2018 - 11.2020
  • Project Name: ERP Ebizframe
  • Clients: DPL Kenya, Polysmart Packaging Limited Nigeria (onsite 1 year).
  • Technologies Used: Oracle 19c, SQL, PL/SQL, JIRA, Oracle Forms 11g/12c, WebLogic.
  • Tools & Platforms Used: Oracle 11G/12C, SQL Developer, SQL
  • Plus, JIRA, SVN, Oracle Forms & Reports.
  • Description: Server installation using oracle database 12, WebLogic and oracle forms and reports. Developed new product of ERP for DPL, Kenyan client based on their business requirement which includes all the modules. Implemented forms, reports, and triggers to streamline business processes and improve efficiency. For Polysmart (onsite), Integrated ERP modules with Oracle Database 12c to reduce manual errors and improve operational efficiency.
  • Key Result Areas:
  • Collaborated with global teams to gather requirements and implement enhancements, aligning with client needs.
  • Optimized SQL queries and PL/SQL procedures to improve data processing efficiency and system performance.
  • Led database optimization efforts, reducing query times and enhancing responsiveness.
  • Created interactive reports and automated workflows to improve operational efficiency.
  • Production, Inventory, Finance automation using bar-code for every department.

Education

Bachelor of Technology (B.E.) - Computer Science

M.D.U University
Rohtak, Haryana
01.2017

Skills

  • Languages: SQL, PL/SQL, Oracle Forms & Reports, Python
  • Databases: Oracle 11g/12c/19c
  • DevOps & CI/CD: Jenkins
  • Version Control: Git, Liquibase
  • Scripting & Automation: Unix
  • ETL development
  • Python programming
  • Real-time analytics
  • Machine learning
  • Performance tuning
  • Version control
  • SQL and databases
  • Data migration
  • Database design

Certification

  • Introduction to Python – Coursera | 2025-09
  • Deep Learning and Neural Network – Coursera | 2025-09
  • Liquibase Certified Practitioner – Liquibase | 2023-10
  • Oracle Database 12c: Advanced SQL – LinkedIn Learning | 2022-02
  • Oracle PL/SQL Advanced Concepts – Coursera

Languages Known

English
Hindi

Timeline

Lead Data Engineer

Birlasoft Limited
09.2024 - Current

Associate Senior Software Developer

TSYS Card Tech Services India LLP
07.2023 - 08.2024

Senior System Engineer – I

Tata Consultancy Services Ltd.
07.2021 - 07.2023

Software Engineer

Eastern Software System Pvt. Ltd.
02.2018 - 11.2020

Bachelor of Technology (B.E.) - Computer Science

M.D.U University

CORE COMPETENCIES

  • Oracle Database Development
  • Database Architecture & Design
  • SQL Query Designing
  • SQL Query Tuning
  • PL SQL Programming
  • Database Performance Optimization
  • Oracle Forms & Reports
  • Automation & Process Improvement
  • Machine Learning, Deep Learning & NN
  • Agile Development & Sprint Management
  • Version Control & Continuous Integration

CAREER TIMELINE

  • Birlasoft Limited 2024 - Present
  • TSYS Card Tech Services India LLP 2023 - 2024
  • Tata Consultancy Services Ltd. 2021 -2023
  • Eastern Software System (India) Pvt. Ltd. 2018 - 2020

Similar Profiles

CREATE PROFILE
AVINASH KUMAR