Nikita Reddy

Data engineer

Tata Consultancy Services

09.2024 - Current

Client: USAA
Project#4

IT Analyst

Tata Consultancy Services

03.2017 - Current

Role: QA Analyst
Tenure: June 2017- April 2018
Client: Farmers Insurance
Responsibilities:
Involved in end to end delivery of the policy testing lifecycle.
Preparation of Test design report for Auto, Home and Umbrella lines of business in Insurance domain.
Worked on various modules like Policy Validation, Credit, Discount, Coverages, Transaction Completion, Downstream & Forms, to prepare all possible positive and negative test scenarios.
Extensive experience in Test Case/Test Scenarios/Test Conditions Creation from Use Case, Test Case Execution, Test Data Preparation, Test Environment Setup, Defect Verification and Management.
Experience in functional, integration, database, regression testing.
Project#1

Integration Developer

Tata Consultancy Services

01.2024 - 08.2024

Role: Integration Developer
Client: Farmers Insurance
Migration of claims from MetLife Toggle application (DBeaver) to Farmers Guidewire claim center (Oracle).
Performed integrity checks at database level to validate relationship between entities and fixed the issues.
Project#3

Integration Developer

Tata Consultancy Services

04.2018 - 12.2023

Role: Integration Developer
Project: GWPC MW Integration & Release Development
Client: Farmers Insurance
Responsibilities:
Experienced in ETL methodology for supporting data extraction, transformations and loading process in corporate-wide ETL solution using Informatica Power Center 10.4, Informatica Power Exchange.
Hands on experience in working on large volume data integration and data migration projects across disparate data source and target objects (Relational Tables, Flat Files, Mainframe Datasets-using Power exchange, XML & XSD files, JMS Queues etc).
Experience in building Informatica Power Exchange jobs to create files and read files in Mainframes system.
Worked with various transformations like Source Qualifier, Expression, Joiner, Filter, Router, Aggregator, Union, Lookup, UnConnected Lookup, Normalizer, Sorter, Update Strategy, Sequence Generator, XML Generator, XML Parser etc.
Creating effective test data and development of Unit test cases to ensure successful execution of the data & trigger email notifications for failures or to share statistics.
Experienced in Error handling, Troubleshooting using various log files and problem fixing in Informatica.
Hands-on experience in all phases of SDLC like requirements gathering, design, coding, testing, defect management and code deployments, Go-live and hypercare support in production.
Creating Job Dependency flow and integrating jobs among different applications (Informatica, Policy Center, Oracle, DB2, Mainframes, Sterling Integrator) and schedule and automate the process through Autosys after consulting with all upstream and downstream systems including external vendors like state DMVs involved in the batch for the cut off time and SLAs in production.
Proficient in writing SQL Queries in Oracle, SQL Databases. Also, Experienced in basic Unix shell scripting with unix commands needed for Data warehousing projects.
Worked on Release Development project for 1 year and worked on production defect fixes, CRs, preparation of Impact Assessment documents, coordinating with Testing team for QA sign-off.
Involved in end to end delivery of the Middleware Integration lifecycle. Allocation of tasks to juniors, monitoring the progress, risk mitigation, problem solving and final delivery & demo.
Preparing components and DB entry for migration, checking in to Github, coordinating with Configuration Management team and admins to deploy ETL, SI, PWX components in QA and production.
Creating Autosys jobs and deploying in all non- prod regions- Dev and QA via Jenkins.
Hands on experience on personal lines of business like Auto, Home and Umbrella with excellent understanding of insurance concepts.
Driving design workshops to gather requirements, discuss technical feasibility, discussing the approach with the architect, technical and functional SMEs based on the requirements, publishing Integration Design Documents (IDD) and getting them approved by business/SMEs.
Maintaining clear documentation of the requirements and change requests for reference by all concerned in the project.
Building SFTP jobs on IBM B2B Sterling Integrator to interchange files, encrypting files during transfer with different internal and external systems like state DMVs, Insurance service provider vendors.
Responsible for estimating development efforts, calling out blockers or dependencies during PI Planning and aligning the story cards as per the capacity for each iteration and providing status updates in Daily Stand Up meetings.
Responsible for demonstrating critical features built in an iteration to the Agile Release Train in the System demo.
Actively took part in organization wide transformation from Agile Scrum to Scaled Agile practice.
Training and mentoring trainees on Informatica Power Center, Insurance domain and Project Architecture while working remote and making them productive in a short span.
Project#2

Summary

Overview

Work History

Data engineer

IT Analyst

Integration Developer

Integration Developer

Education

BTech - Information Technology

Skills

Timeline

Data engineer

Integration Developer

Integration Developer

IT Analyst

BTech - Information Technology

Similar Profiles

Vrunda ChindhadeVrunda Chindhade

Sreya BasuSreya Basu

Arun VArun V

Naimish AgnihotriNaimish Agnihotri

Divya NelaturiDivya Nelaturi