Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Aadhaar
Disclaimer
Timeline
Generic

P. Ranjini

Data Specialist
Chengalpattu

Summary

Experienced IT Software Tester with over 15 years of dedicated expertise in delivering high-quality solutions to meet client needs. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.

TRAINING & PROJECT - 2024

  • Trained in Python and PySpark for automating ETL processes in Big Data environments.
  • Processed data from multiple formats including CSV, JSON, XLSX, PARQUET, AVRO, PostgreSQL DB, Snowflake DB and Azure.
  • Developed and implemented Python and PySpark scripts for automating data extraction and transformation processes in DataBricks and PyCharm environments.
  • Created Custom Framework and automated test scripts for regression testing, ensuring ongoing integrity of ETL processes

Overview

13
13
years of professional experience
5
5
Certifications
2
2
Languages

Work History

Team Lead

LTI Mindtree Private Limited
Chennai
12.2021 - 01.2023
  • CAOOP -Project is responsible for acquiring and loading data in database to derive the report for Colombia credit bureau.
  • Tested the Ab Initio ETL mappings and other ETL process to make sure the data is getting loaded correctly.
  • Validated data transformations and perform End-to End data validation for ETL & BI systems in various Sprints. Created Python Script to automate data Extraction and validation from various source using DataBricks.
  • Extracted data from API using Python. Used GitHub as repository to store the automation scripts.

Consultant

Cap Gemini India Private Limited
07.2017 - 12.2021
  • Transunion Project is responsible for acquiring and loading data in database to derive the report for Colombia credit bureau.
  • Tested the Ab Initio ETL mappings and other ETL process to make sure the data is getting loaded correctly.
  • Validated data transformations and perform End-to End data validation for ETL & BI systems in various Sprints. Created Unix Shell Script to automate data Extraction and validation.

Team Lead

Cap Gemini India Private Limited
04.2016 - 07.2017
  • Company Overview: Citi is one of the global financial services company headquartered in New York, USA. It provides investment banking, asset management, and wealth management services for private, corporate, and institutional clients worldwide, as well as retail clients.
  • Prepared the Test Strategy, Test Plan & Test Scenarios docs.
  • Preparation of Test Estimation, Capacity Planner, Governance Deck & Test Metrics.
  • Review of Test Cases & results and Track issues to closure.
  • Created, Reviewed, and Executed the SQL test queries to validate transformation rules used in source to target mappings and verify the data in target tables.
  • Modification of test cases based on the requirements change.
  • Performed DIT & Regression Testing.
  • Task allocation to the Team members and monitoring work progress.
  • Preparing the Execution tracker & Efforts tracker on Daily/Weekly basis.
  • Attending the Onshore & Offshore execution status meetings on Daily/Weekly basis.
  • Citi is one of the global financial services company headquartered in New York, USA. It provides investment banking, asset management, and wealth management services for private, corporate, and institutional clients worldwide, as well as retail clients.

Test Lead

Cognizant Technologies Solution Private Limited
03.2013 - 03.2016
  • Prepared the Test Plan & Test Case docs for the same.
  • Review of other epics' Test Cases & results and track issues to closure.
  • Created, reviewed, and executed the SQL test queries to validate transformation rules used in source to target mappings and verify the data in target tables.
  • Involved in various testing activities like Test Data file preparation, ongoing data quality assurance like Skeleton checks in the target system and Metrics validation.
  • Coordinating with onsite counterpart on project related action items on regular intervals.
  • Attending the Onshore & Offshore execution status meetings on Daily/Weekly basis and sending the Status Reports to the customers.

Tester

Cognizant Technologies Solution Private Limited
11.2012 - 02.2013
  • Prepared the Test Plan & Test Case docs for the same.
  • Review of other epics' Test Cases & results and track issues to closure.
  • Created, reviewed, and executed the SQL test queries to validate transformation rules used in source to target mappings and verify the data in target tables.
  • Involved in various testing activities like Test Data file preparation, ongoing data quality assurance like Skeleton checks in the target system and Metrics validation.
  • Coordinating with onsite counterpart on project related action items on regular intervals.
  • Attending the Onshore & Offshore execution status meetings on Daily/Weekly basis and sending the Status Reports to the customers.

Tester

HP Global Soft Private Limited
05.2010 - 10.2012
  • Prepared the Test Plan & Test Case docs for the same.
  • Review of other epics' Test Cases & results and track issues to closure.
  • Created, reviewed, and executed the SQL test queries to validate transformation rules used in source to target mappings and verify the data in target tables.
  • Involved in various testing activities like Test Data file preparation, ongoing data quality assurance like Skeleton checks in the target system and Metrics validation.
  • Coordinating with onsite counterpart on project related action items on regular intervals.
  • Attending the Onshore & Offshore execution status meetings on Daily/Weekly basis and sending the Status Reports to the customers.

Education

BSC. - Mathematics

SKP College
01.2004 - 2009.01

MSC. - IT

Madras University
01.2012 - 2013.01

Skills

  • ETL Tool: SSIS, Abinitio ExpressIT, Informatica, Knime and SAS

  • Project Methodology: Waterfall, Agile

  • Test Management Tools: HP-ALM, Quality Center, JIRA, SOAP UI

  • Database: SQL Server 2008 R2 , DB2, Oracle & Teredata

  • Programming: Python, Java Scripting

  • Test Framework: TestNG, Data Driven

  • Reporting Tools: MSTR,Tableau

  • Automation: ICEDQ, Selenium Training

  • BigData Technology: PySpark, DataBricks

  • ETL Tool: SSIS, Abinitio ExpressIT, Informatica, Knime and SAS

Certification

AWS Cloud Practitioner Certification

Accomplishments

  • Received the 'Team Performance' Award at HP Global Soft.
  • Received the 'Project Star' Award for Q3 - 2012 at Cognizant.
  • Received 'Certificate of Appreciation' and appreciation e-Mails from Clients & Team Leads on various ST/SIT Projects.

Aadhaar

883440665528

Disclaimer

I hereby declare that the details furnished above are true to the best of my knowledge.

Timeline

AWS Cloud Practitioner Certification

01-2025

"ETL and Data Pipelines with Shell, Airflow and Kafka" course authorized by IBM and offered through Coursera.

06-2024

ISTQB - Testing Foundation and Agile

04-2024

"Data Science Hands On (PowerBI, SQL, Tableau, Spark, Python)" offered through Udemy

03-2023

Team Lead

LTI Mindtree Private Limited
12.2021 - 01.2023

Consultant

Cap Gemini India Private Limited
07.2017 - 12.2021

Team Lead

Cap Gemini India Private Limited
04.2016 - 07.2017

Test Lead

Cognizant Technologies Solution Private Limited
03.2013 - 03.2016

Tester

Cognizant Technologies Solution Private Limited
11.2012 - 02.2013

MSC. - IT

Madras University
01.2012 - 2013.01

Tester

HP Global Soft Private Limited
05.2010 - 10.2012

GNIIT-Software Engineering - NIIT

04-2009

BSC. - Mathematics

SKP College
01.2004 - 2009.01
P. RanjiniData Specialist