Summary
Overview
Work History
Education
Skills
Affiliations
Languages
Timeline
Generic

Infant Prashanth Raj John Prabahar

Hartford,CT

Summary

  • 9 years of total experience in Healthcare, Casino and Insurance domains.
  • 6 years of experience as an ETL developer and currently working as a Senior Data Engineer in onshore.
  • 3 years of experience as ETL Tester.
  • Worked extensively in Data warehousing for ETL process involving Ab Initio based transformation with data bases like SQL server, Teradata, Oracle.
  • Developed and used UNIX scripts, SQL scripts, stored procedures and functions to support the ETL processes for delivering complex business solutions.
  • Skilled in mapping client’s business requirements and translating them into functional specifications, and technical specifications, designing solutions & implementations with best practices.
  • Working experience in Agile projects involving Sprint schedule, story point estimation, release planning along with daily scrum ceremonies.
  • Trained and guided junior developers/team members in technical and domain knowledge.
  • Good understanding of other data integration tools like Talend and Informatica.
  • Comprehensive Knowledge in Software Development Life Cycle (SDLC), ETL -Testing methodologies and End – End System testing.
  • Experience in writing Test Cases according to Business, Functional and User Requirement Specifications.
  • Involved in the DW Testing Cycle including Test Analysis, Test planning, Test Case and Test Script Preparation and Test Execution.
  • Good at developing SQL queries for issue analysis.

Overview

9
9
years of professional experience

Work History

Senior Data Engineer

LTI Mindtree
Hartford, CT
10.2019 - Current
  • 4 years of experience as an ETL developer and currently working as a Senior Data Engineer.
  • Extensive knowledge on insurance domain concepts.
  • Extensive knowledge on Ab Initio graph development,ETL processes and data integration,Data warehousing and Data modelling,Performance tuning and optimization.
  • Utilized Ab Initio parallelism features to enhance data processing capabilities, improving job execution times.
  • Implemented parallel data flows to optimize resource utilization and achieve scalability.
  • Created and maintained reusable Ab Initio components and templates, promoting code modularity and accelerating development cycles.
  • Established a library of reusable functions and graphs for common data transformation tasks.
  • Worked closely with data analysts, business stakeholders, and cross-functional teams.
  • Established and enforced data governance policies and procedures to ensure the quality, integrity, and security of insurance data.
  • Implemented data quality frameworks to monitor, measure, and improve the accuracy and completeness of insurance data.
  • Implemented robust data security measures to protect sensitive insurance data against unauthorized access and cyber threats.
  • Led data migration projects, ensuring seamless transitions of insurance data between systems while minimizing disruptions.
  • Implemented data transformation processes to standardize and normalize data formats for consistency and accuracy.
  • Worked extensively in Data warehousing for ETL process involving Ab Initio based transformation with data bases like SQL server, Teradata, Oracle.
  • Developed and used UNIX scripts, SQL scripts, stored procedures and functions to support the ETL processes for delivering complex business solutions.
  • Skilled in mapping client’s business requirements and translating them into functional specifications, and technical specifications, designing solutions & implementations with best practices.
  • Working experience in Agile projects involving Sprint schedule, story point estimation, release planning along with daily scrum ceremonies.
  • Trained and guided junior developers/team members in technical and domain knowledge.
  • Good understanding of other data integration tools like Talend and Informatica.
  • Comprehensive Knowledge in Software Development Life Cycle (SDLC), ETL -Testing methodologies and End – End System testing.
  • Experience in writing Test Cases according to Business, Functional and User Requirement Specifications.
  • Involved in the DW Testing Cycle including Test Analysis, Test planning, Test Case and Test Script Preparation and Test Execution.
  • Good at developing complex SQL queries for issue analysis.

Data Engineer

Scientific Games
Chennai, TamilNadu,India
05.2018 - 09.2019
  • Extensively involved in writing SQL Procedures for populating data for validation purposes.
  • Designed, developed, and optimized stored procedures for efficient data retrieval, manipulation, and transaction processing.
  • Implemented best practices to enhance the performance of stored procedures, reducing query execution times by great extent.
  • Built user-defined functions to encapsulate business logic, improving code modularity and maintainability.
  • Utilized functions for common calculations, data transformations, and code reuse across multiple queries.
  • Optimized complex SQL queries by creating and fine-tuning stored procedures, resulting in improvement in overall database performance.
  • Implemented indexing and query execution plans to enhance the efficiency of data retrieval operations.
  • Implemented robust error-handling mechanisms within stored procedures to ensure graceful handling of exceptions and errors.
  • Utilized try-catch blocks and custom error messages for effective debugging and troubleshooting.
  • Developed parameterized queries and procedures to enhance security and prevent SQL injection vulnerabilities.
  • Established a library of reusable stored procedures and functions, promoting code consistency and reducing development time for similar tasks.
  • Implemented dynamic SQL within stored procedures to handle dynamic table and column references based on runtime conditions.
  • Enhanced flexibility in query execution and adapted to changing business requirements.
  • Adhered to SQL coding standards and best practices to maintain consistency and readability across all SQL code.
  • Conducted code reviews to ensure compliance with coding standards and optimized performance.
  • Extensively involved in test suite creation in SOAP UI for Automation testing purpose.
  • Worked in Basic Groovy scripting for test execution purpose in SOAP UI.
  • Extensively involved in Test data preparation through automation method (QTP tool)

Programmer Analyst

Cognizant Technologies Solutions
Chennai, TamilNadu,India
01.2015 - 04.2018
  • 3 years of extensive experience as ETL Tester.
  • Extensively involved in writing SQL Queries for Data validation process.
  • Demonstrated strong SQL querying skills to design and execute complex queries for data validation and integrity checks.
  • Utilized SQL to verify data consistency between source and target systems during ETL testing.
  • Utilized SQL queries to perform data profiling and identify potential data quality issues.
  • Demonstrated proficiency in ETL tools (e.g., Informatica, Talend) to validate data extraction, transformation, and loading processes.
  • Utilized ETL tool functionalities for data reconciliation, error handling, and logging.
  • Executed performance testing for ETL jobs, identifying bottlenecks and optimizing SQL queries for enhanced data processing speed.
  • Implemented and maintained automated ETL testing scripts using tools such as Selenium or custom frameworks.
  • Automated repetitive SQL-based test scenarios to streamline the testing process.
  • Tested incremental loading scenarios to verify that only new or modified data is processed during subsequent ETL runs.
  • Designed comprehensive test scenarios covering various aspects such as data completeness, accuracy, error handling, and performance.
  • Ensured that test scenarios align with business objectives and data integration requirements.
  • Validation of different Reports impacting various business needs.
  • Involved in Defect root cause analysis with Offshore development team.

Education

Bachelors of Engineering - Electrical And Electronics Engineering

PSNA College of Engineering And Technology
Dindigul,Tamil Nadu,India
05-2014

Skills

Data Analysis and Programming: Abinitio,SQL,Python (NumPy, Matplotlib) Shell Scripts

Statistical Analysis and Visualization:

Tableau, Advanced Excel, JMP Pro

Database Management:

Oracle, MySQL, Microsoft SQL Server, Snowflake Project

Management and Visualization:

MS Project, Visio, JIRA, Agile, SCRUM

Affiliations

  • Travelling mainly to enjoy the views of nature and excited to gain different cultural experiences. Hiking is my favorite part
  • Reading Books(Non fiction).
  • Playing Chess

Languages

Tamil
Native/ Bilingual
English
Full Professional
Hindi
Limited

Timeline

Senior Data Engineer

LTI Mindtree
10.2019 - Current

Data Engineer

Scientific Games
05.2018 - 09.2019

Programmer Analyst

Cognizant Technologies Solutions
01.2015 - 04.2018

Bachelors of Engineering - Electrical And Electronics Engineering

PSNA College of Engineering And Technology

Similar Profiles

CREATE PROFILE
Infant Prashanth Raj John Prabahar