Summary
Overview
Work History
Education
Skills
Certification
Technical skills
Timeline
Generic

D RAMA NAGITHA

Chennai

Summary

Proven ability to excel in fast-paced environments while adapting to sudden changes. Recognized for maintaining high standards of work quality and efficiency under pressure. Consistently delivers results that exceed expectations.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

TVS Credit Services Limited
Chennai
11.2024 - Current
  • Gathering business requirements and analysing the feasibility of implementing it
  • Implemented data quality checks to ensure reliability of financial datasets.
  • Data view scripting and optimizing using PL/SQL Developer on sales and credit data.
  • Internal Tableau dashboard creation to keep track of working tickets.
  • Collaborated with cross-functional teams to optimize data workflows and reporting.

Senior Data Engineer

Skylark
09.2024 - 11.2024
  • Implemented logic for ETL, incremental loading based on respective data.
  • Python scripts to automate the creation of required objects upon the addition of source objects.
  • Requirement analysis for the fact table and its implementation by writing stored procedures.
  • Proficient in PostgreSQL and SQL Server, including the creation of stored procedures and functions.

Data Engineer

Bluepencil
12.2023 - 08.2024
  • Conducted deduplication by analyzing data and identifying duplicates.
  • Identified and corrected inaccuracies, inconsistencies, and missing data.
  • Validated data against predefined quality standards and business rules.
  • Collaborated with program managers to understand data cleansing requirements.
  • Utilized ZinggAI for processing cleansed data with user inputs, loading results into target tables.
  • Implemented SQL logic on cleansed data to calculate HDI, MPI, Credit Score, and Quintiles for analysis based on survey data.

Data Engineer

Proconnect
05.2023 - 11.2023
  • Implemented logic for ETL - incremental loading based on respective data.
  • Requirement analysis for fact table and its implementation by writing stored procedures.
  • Proficient in PostgreSQL and SQL Server, including the creation of stored procedures and functions.
  • Optimization of queries using EXPLAIN and creating necessary indexes and partitioning mechanisms.
  • Usage of version control system - GIT to track changes to database scripts.

Data Engineer

CTI
09.2022 - 04.2023
  • Designed and developed ETL jobs using Talend to extract, transform, and load data from diverse source systems.
  • Implemented data transformation, cleansing, and enrichment workflows to ensure data quality and consistency.
  • Diagnosed and resolved job failures, data inconsistencies, and performance issues.
  • Utilized Talend's debugging and logging tools for error tracing and root cause analysis.
  • Developed reports using TIBCO Jaspersoft Studio by translating business logic into SQL queries and stored procedures.
  • Employed Git for version control to manage and track changes across ETL jobs and report components.

SQL Developer

Ramco Systems
Chennai
11.2018 - 08.2022
  • Designed, developed, and maintained SQL Server databases for new logistics features by creating tables, views, stored procedures, functions, and triggers.
  • Debugged and resolved issues in SQL queries and other database components.
  • Identified performance bottlenecks and optimized query execution plans and indexing strategies.
  • Handled both development and support activities, addressing product and customer issues.
  • Investigated and resolved API-related issues integrated with the logistics system.
  • Utilized Git for version control of database objects, ensuring traceability and collaboration in development.
  • Performed load testing using Neoload and JMeter to validate module performance and server load capacity.

Education

B.E. - Computer Science

Chennai
Chennai
01.2018

SSLC (10th) -

Tuticorin
Tuticorin
01-2012

HSLC (12th) - Computer Science

Tuticorin
Tuticorin

Skills

  • Query optimization
  • Data load and transformation
  • Version control management
  • Data modeling
  • Data warehousing
  • SQL scripting
  • Query optimization
  • Data load and transformation
  • Version control management

Certification

Microsoft Certified: Azure Data Fundamentals DP-900

Technical skills

  • Databases: SQL Server, Oracle, PostgreSQL
  • ETL tools: Talend
  • Languages: SQL, PL/SQL, Python (for scripting and automation)
  • BI tools: Jasper Reports
  • Tools & Utilities: Git and Jira
  • Concepts: Data warehousing, Performance tuning, Root cause analysis

Timeline

Senior Data Engineer

TVS Credit Services Limited
11.2024 - Current

Senior Data Engineer

Skylark
09.2024 - 11.2024

Data Engineer

Bluepencil
12.2023 - 08.2024

Data Engineer

Proconnect
05.2023 - 11.2023

Data Engineer

CTI
09.2022 - 04.2023

SQL Developer

Ramco Systems
11.2018 - 08.2022

B.E. - Computer Science

Chennai

SSLC (10th) -

Tuticorin

HSLC (12th) - Computer Science

Tuticorin
D RAMA NAGITHA