CURRICULUM VITAE

Ranjini Gurunathan

Mobile: 978-***-****, 866-***-****

Email: add9cu@r.postjobfree.com

Career Objective

Seeking a position as a Software Engineer in technology-driven organization that encourages a challenging position in a high-quality engineering environment where my resourceful experience and academic skills will add value to organizational operations. PROFESSIONAL SUMMARY

Having 4 years of experience in ETL, Informatica, Oracle Middleware Technologies like SOA and Dell Boomi.

Expertise in ETL (Extract, Transform and Load) design, development, testing and Implementation using tools like Informatica Power Center 10.2, Informatica Designer, Informatica Workflow Manager, Work flow monitor, Repository manager.

Have worked extensively in Informatica tools such as Informatica Power center.

Understanding the business rules and sourcing the data from multiple source system.

Highly adaptive to latest technologies, quick learner of changing tools architecture.

Well acquainted with Informatica Designer Components - Source Analyzer, Target, Transformation Developer and Mapping Designer.

Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Lookups and Aggregators, Sequence Transformation .

Effective in working independently and collaboratively in teams. TECHNICAL EXPERTISE

Data Warehousing : Informatica Power Center 9.6.1,10.2 (Source Qualifier, Mapping Designer, Transformations, Workflow Manager, Workflow Monitor)

Databases : Oracle 11g SOA Servers

Programming : SQL, Unix Scripting Languages

Tools : Service-Now Ticketing tool (Istanbul version), Putty, Control-M, Sitescope

WORK EXPERIENCE

1. Company : TATA CONSULTANCY SERVICES

Duration : April 2019 to till

Role : Software Engineer

Data Warehousing : Informatica Power Center

Project Description:

Title : Nationwide Mutual Insurance Company

Nationwide is a largest building society in London. As part of this project, the team has been engaged to support the main application Policy Center (product of Guidewire) both backend and frontend, where we maintain data of both Commercial Line Transformation and Personal Line Transformation policies. We ETL development team work on to transfer all the Legacy system policies to IS system which then process over Guidewire tool. Job Responsibilities:

Analyze the requirements and had discussion with requirements team.

Based on the requirements Developed the code using by Informatica Power Centre Designer

Worked on Power Centre client tools like Source Analyzer, Warehouse Designer, Mapping Designer, and Transformations Developer, Workflow Manager, Workflow Monitor.

Used Various Transformation like Source Qualifier, Expression, Look up, Router, Aggregator, Sequence Generator, XML parser, XML generator.

Created the parameter file and meta data entry in meta data table.

Unit testing code and promote the code into higher environments through github.

Communicating with onsite team for clarification and status updates. 2. Company : Birlasoft

Duration : October 2018 to March 2019

Role : Software Engineer

Project Description:

Title : Synapse

Environment : Prod

Synapse is a multichannel marketing company. It is the largest consumer magazine distributor in the United States. Synapse expanded their marketing channels to include retailers, airlines, cataloguers and dot-com companies.

Job Responsibilities:

Scheduled jobs on various unix based (Solaris, Linux), windows-based and other platforms using control-m tool.

Research, analyse and report problems to programmer or developer.

Build and manage job flows, calendar requirement and scheduling criteria.

Creating job dependencies and alerts as per application team and business requirement.

Configuring sitescope for agentless server and creating alerts based on thresholds.

Analyze the CPU Utilization, Memory usage, Garbage Collection and DB connections to verify the performance of the applications.

Configuring URL’s of the critical applications for availability monitoring. Company : Birlasoft

Duration : Nov 2016 to September 2018

Role : Software Engineer

Project Description:

Title : Stryker Corporation

Environment : Prod, Dev, QA, Shell Script, SQL

Data Warehousing : Informatica cloud

Stryker Corporation is a Life Science Project related to world’s leading medical equipment manufacturers and suppliers. Here they offer a diverse array of innovative products and services in Orthopaedics, NV, spine, etc.

In Terms of Technology, worked on Dell Boomi, MFT, OSS including various servers. Job Responsibilities:

Manage the functionality and efficiency of all Middleware / SOA servers and SOA based applications.

Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.

Performed the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in DB2, ORACLE and Informatica.

Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.

Experienced in loading data, troubleshooting, debugging mappings, performance tuning of informatica(source, targets, mappings and sessions) and fine-tuned transformations to make them more efficient in terms of session performance.

Design, development and deployment of Integration solutions for Cloud, On-Premises and Hybrid scenarios of Dell Boomi.

Participate in cross-functional team meetings both internal and customer facing.

Actively involved in the implementation and Deployment of Middleware Projects.

Documentation of Knowledge based article and all deployment activities, the installation plans for reference.

Designing the Reports for the analysis.

Company : Ramco Systems Limited, Chennai

Duration : June 2016 to Nov 2016

Role : Project Trainee

Job Responsibilities:

Identifying the new requirements and finding work around and testing the fixes.

Created Table, Stored Procedure view, metadata and Synonym based on our development requirement.

Knowledge to work with Unit Testing,Prepare Package and Deploying the respective server .

Working on screen designing using EDK, Dcube, IEDK and Decision Work tool.

Supported on Cobham, Patria, L3-Mas and Conair projects.

Handling the objects in VSS and SVN.

Verifying and resolving the SQL script issues and Finding and fixing the root cause.

Strong knowledge in writing SQL queries for backend testing.

Good experience on handling runtime Exceptions.

Worked on Strong database skills with DDL, DML, Joins, Functions, and Indexes.

Won best support greeting from RAMCO SYSTEMS for ADAC, AIR INDIA, GOAIR DATA MIGRATION.

Education Qualification

Class/Course Institution Board of

Study

Year of Passing Percentage

/CGPA

B. Tech (I.T) Manakula Vinayagar

Institute of Technology

Pondicherry

University

2012-2016 81.9

HSC AHSS State Board 2011-2012 88.33

SSLC AHSS State Board 2009-2010 95.4

DECLARATION:

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

Place: Puducherry

Date : (G.RANJINI)

Contact this candidate