Software Engineer Senior

Mandala Ravi 910-***-****)

Email:ad5vbx@r.postjobfree.com

Professional Summary

Having 6 years of IT experience in actual Data Warehousing with extensive use of ETL tool Informatica, SAP BODS, TES, Cisco Transporter, HPSM Ticketing and Guidewire UI, AWS, SQL Developer, and Redshift tools.

Worked as a Software Test Engineer in Mphasis from Jun 2014 – Sep 2016.

Worked as an Application Support Engineer in HPE through TEK SYSTEMS

from Oct 2016 -Mar 17.

Worked as a Senior Software Engineer in DELL through Test Yantra solutions

from Jul2017 -Sep17 .

Worked as a Consultant in Capgemini India Pvt Ltd from Jul2018 -Jun20.

Worked as a senior Test Engineer in PwC from Feb 2021 -Aug 6th, 2021.

Worked as a Senior Software Engineer in Zensar from Apr 2022 – Dec 2022.

Extensive hands on experience with Informatica Power center 9.6.1/9.5.1/8.6 ETL tool.

Worked with different data sources like free text, fixed width, Delimited, relational, etc.

Worked in Mappings &Sessions for Extracting, Transforming, and Loading the data Using Informatica Power Center Designer, Workflow Manager &Monitor tools.

Strong Experience with Workflow Manager Tools, Workflow – Designer &Monitor.

Practical understanding of the Data Modeling concepts like Star-Schema Modeling, Snowflake Schema Modeling, and Fact and Dimension tables.

Having experience on CI/CD pipeline,Python, AWS services like S3 and Redshift database

Involved in SIT, E2E, Production support, and maintenance of the application.

Involved in Creating jobs in production using Tidal Enterprise Scheduler.

Involved in testing of jobs in production.

Migrating the Jobs from ITG to Production and Production to ITG Environment by using Cisco Transporter.

Skills Profile

Technical

Operating System

Windows XP/windows 7/windows 8/Linux

Environment

Dev and Test

Database

Oracle 12C, Redshift, Oracle SQL Developer, SSMS

Internet Tools

Https, SoapUI

Languages

SQL Plus

Other

Informatica Power center 9x/8x TOAD, Cisco TES, QC, ALM, JIRA, Putty.

Professional Experience

NFUMMutual

APR 2022 to Dec 2022

Zensar - SENIOR Software ENGINEER

The National Farmers Union Mutual Insurance Society Limited, trading as NFU Mutual, is a UK-registered mutual insurance composite. It underwrites life and general insurance lines for rural communities within the UK. NFU Mutual is owned by its Policyholders. Different types of policies have claims. The claim data passes from Guidewire-Guidewire Data Hub tables. The Claims Control File is generated through the ”Tgtworkday” claims table via stage tables. It is having the Aggregated claims data. The Batch jobs are loaded into tables on daily basis.

Responsibilities:

Involved in the functional study using the requirements of the application.

Running the Jobs for ETL processes like Extract and Transform through SAP BODS jobs.

Prepared and ran SQL queries to verify data in SSMS.

Verifying the data in the target database Table or File after the ETL process.

Prepared Test Cases for Validating the data.

Source Prepared test data for testing using Guidewire Datahub via Guidewire Claims.

Verifying the data which is loaded into the target database using AZUREDEVOPS.

Reporting daily testing status report provided to the manager.

Developed, Reviewed & Executed Test Scripts, and Designed test data.

Identified Test Scripts for Regression testing with Generated File.

NFUMMutual

FEB2021 to AUG 2021

PwC - SENIOR TEST ENGINEER

NFUM Organization has different firms throughout the UK. This is insurance related to Home and Building products. Different types of policies like Qualified, Errored, etc. are available for related data with Clients, Locations, Addresses, Coverages, Buildings, Rooms, Roofs, Tiles, etc. related to the Home. The Migration project has different stages. It has Source data from the “Ifaces Server”. It has migrated to PC via TODS, Staging, DBO, and PMT via PC.

The Data reaches PC Guidewire from PMT-IN to PMT-OUT tables. The Data is loaded into the tables Daily. With the help of the data, we can successfully migrate from Source to Target via SAP BODS. The Migration Framework also included processing data from one stage to another Stage.

Responsibilities:

Involved in a functional study using the requirements of the application.

Running the Jobs for ETL processes like Extract, Transform, Quality, PMT, Premigration, and Migration jobs.

Prepared and ran SQL queries to verify data in SSMS.

Verifying the data in the target database or File after the ETL process.

Prepared Test Cases for Validating the data.

Source Prepared test data for testing using IFACES.

Verifying the data which is loaded into the target database using AZUREDEVOPS.

Data is stored on the basis of CI/CD basis tested in Azure DevOps

Reporting daily testing status report provided to the manager.

Developed, Reviewed & Executed Test Scripts, and Designed test data.

Identified Test Scripts for Regression testing.

B4C

JUL 2018 to JUN 2020

Consultant

B4C Life and Motor Insurance consist of modules like new Business, policy changes, Re-insurance Agency, Cancellation, Renewal, Quoted, and Bound of Accounts. A new business is a business brought by the agent and his business is called a Proposal. Proposals will be approved by underwriters to convert into a policy. These underwriters check for all the eligible criteria like the Client’s annual income, age, health, etc. along with this proposal needs more amount of money in suspense to convert into a policy. This includes internal and external funds maintenance for the injurer. The agency module maintains all the details about individual and company agents. The brand maintains all the details of the different flavors.

Responsibilities:

Involved in a functional study using the requirements of the application.

Running Jobs for the ETL process.

Prepared and ran SQL queries to verify data in SQL Developer.

Verifying data in the target database or File after the ETL process.

Prepared Test Cases for Validating the data.

Prepared test data for testing using Guidewire UI.

Verifying the data which is loaded into the target database using JIRA.

Reporting daily testing status reports.

Developed, Reviewed & Executed Test Scripts, and Designed test data.

Identified Test Scripts for Regression testing.

Customer MDM

Senior Software Engineer (Jul 17 - Sep 17)

Customer (MDM) simplifies Data Accurately, Unified and Quality maintains enterprise-wide job scheduling, and automates the way business processes are defined and executed. This highly scalable workload automation solution manages diverse business processes across a broad set of applications, systems, and environments. It lowers the cost of data while improving efficiency and throughput.

Oracle SQL Developer V3.2.20.10, Wind 10, Informatica R9.6.1, HPALM V12, Tidal-Scheduling Tools.

Responsibilities:

Creating the users in UI’s and Involved in Developing Scenarios in Test Env by using Oracle SQL Developer.

Involved in Running and Testing the Scenarios in Test Env by using Oracle SQL Developer.

Observing the Data in Different DBs with flows.

Involved in Status Meeting calls with the Management.

Analyzing with Senior members and team members to get completed.

Analyzing the Scenario and resolving the issues within the time.

We will do the Data Validations in Data Base.

Give Support to Automation & Informatica Teams.

Tidal Enterprise Scheduling and Tidal Engineering

Oct 2016-Mar 2017

Application Support Engineer

Cisco Tidal Enterprise Scheduler (TES) simplifies enterprise-wide job scheduling and automates the way business processes are defined and executed. This highly scalable workload automation solution manages diverse business processes across a broad set of applications, systems, and environments. It lowers the cost of data while improving efficiency and throughput.

Environment: Tidal Enterprise Schedule Tools, Transformer, HPSM Ticketing tool

Responsibilities:

Involved in Running jobs in production by using Cisco Tidal Enterprise Scheduler.

Involved in testing of jobs in production.

Involved in testing of jobs in Sap Environment.

Migrating the Jobs from ITG to Production and vice versa by using Cisco Transporter.

Involved in Creating Agents in Production and ITG

Analyzing tickets and RFC `S.

Analyzing the IM Tickets and resolving the issues.

We will do the Agent Upgrade & Restart. Give Support to SAP & Informatica Teams.

Jackson Warehouse System

Jun 2014 to Sep 2016

Software Test Engineer

Jackson National Life Insurance is a life Insurance Product that consists of modules like new Business, policy services, Re-insurance Agency, Moment, Client data bank, and Accounts. A new business is a business brought by the agent and his business is called a Proposal. Proposals will be approved by underwriters to convert into a policy. These underwriters check for all the eligible criteria like the Client’s annual income, age, health, etc. along with this proposal needs more amount of money in suspense to convert into a policy. This includes internal and external funds maintenance for the injurer. The agency module maintains all the details about individual and company agents. The moment module maintains all the modification details of the insurer.

Responsibilities:

Involved in the functional study of the application.

Running the Jobs for the ETL process.

Prepared and ran SQL queries to verify data

Verifying the data in the target database after the ETL process.

Prepared Test Cases for Validating the data.

Prepared test data for testing.

Verifying the data which is loaded into a target database.

Reporting daily testing status reports.

Developed, Reviewed & Executed Test Scripts and Designed test data.

Identified Test Scripts for Regression testing.

Environment: Oracle, Informatica

Contact this candidate