Saranya Devi Rajendran

Professional Summary

Applications Engineer with over 5+ years of successful experience in using TDM tools, ETL/BI, Database and Application development. Clear understanding of any given data requests and trained in delivering solutions to support applications. Expertise in complete Software Development Lifecycle (SDLC) on Windows and UNIX platforms in the phases of analysis, design, development, production support and testing backed by Graduate Degree in Computer Science.

Work History

Nationwide Insurance - Test Data Management Engineer

Columbus, OH

11/2018 - Current

Analyzing requirements, data sources, data needs and target databases from different Business Areas for performing data sourcing, data sub-setting, data masking, data provisioning, data conditioning, data loading and created security roles in Optim TDM.

Constructed Extract, Convert, Insert, Load, Export and Import objects based on requirements using IBM InfoSphere Optim Distributed Application.

Develop masking procedures/routines for masking PII/PCI data in customer databases such as SQL, Oracle, PostgreSQL, Db2, PL/SQL and Teradata in Lua script by consuming Optim Data Privacy Providers (ODPP), a stand-alone API.

Initiated projects and initiatives for CA TDM, including collection and synthesis of requirements, recommendations, working with business and Information Service groups to mask selected data to ensure data compliance as part of POC effort.

Implemented use of Windows batch script and ESP scheduling to automate Extract, Convert and Load process within TDM and Informatica to provide self service capabilities to teams.

Familiarized use of Shell/Unix scripting commands for accessing file contents and data integration.

Fabricated java code for redacting PII information in Oracle tables of datatype CLOB and free-form text by utilizing Java API’s within Optim.

Involved in process of fed server installation to connect to AS400 database and mask sensitive information in it.

Involved in Optim components installation on AWS instance by using S3 bucket and then added them using CloudFormation and CI/CD pipeline services.

Drove operational improvements by involving in IBM cost modeling which resulted in savings.

Compassed and carried out different types of testing using HP ALM and QC testing tool; Automated test cases for regression testing.

Use of Liberman Red Tool for securing confidential data.

Developed team communications and information for TDM weekly updates and meetings.

AZ Technologies, LLC - ETL Developer

Wilmington, DE

09/2018 - 11/2018

Gathered, defined and refined requirements, led project design and implemented required functions.

Developed mappings/Reusable Objects/Transformation/workflows and sessions by using mapping designer, transformation developer and workflow designer in Informatica Power Center to migrate application data from one version to its upgraded version.

Enabled use of Filter transformations in Informatica to create test set of active policies for any regression or functional type testing.

Performance tuning of SQL Queries, Sources, Targets and sessions depending on bottlenecks identified for better performance and efficiency.

Basic understanding of Dimensional Modeling concepts like Star-Schema Modeling, Dimension tables and Pivot tables.

Exhibited motivation to learn and grow thereby impacting overall morale and productivity.

State Compensation Insurance Fund - Test Data Management Analyst Intern

Dublin, CA

09/2017 - 08/2018

Designed, prioritized, and executed test plans, scenarios, and scripts for testing applications of policyholder with compensation insurance using HP ALM and HP QC tool by maintaining traceability of requirements.

Assessed software bugs and compiled findings along with resolution techniques in documentations.

Devised data masking, data sub-setting for retrieving active policy holder numbers by creating relationships using Optim TDM; Optim Designer Installation, Configuration and Administration.

Worked across multiple database like Oracle, SQL and Teradata for data masking and testing requests.

Defects and issue identification, logging, tracking and reporting using Microsoft TFS.

Collaborated with JIVE content management architects and product owners to stay current on intended functionality by reducing estimated SLA by 10%.

Extracted data from heterogeneous sources like text file, Excel sheets, and SQL tables with understanding in data modeling activities using tools like Visio, MS Visual Studio and Toad.

Written SQL queries, views, stored procedures to perform data validation and verification and shell scripts to automate test data process for on-going support.

Nationwide Mutual Insurance - IT Applications Developer Intern

Columbus, OH

05/2017 - 08/2017

Built, tested and deployed scalable, highly available and modular web pages using Angular 1.x, Bootstrap 3, HTML 5 and CSS 3.

Created single page web design with visibility features and components for Retirement Plans group using Angular directives and Material Design.

Extracted data from existing system to Staging Area and loaded data to target database by ETL process using Informatica Power Center.

Implemented use of ETL Informatica to retrieve insurer information/payment information from various third-party suppliers based on customer service requests.

Knowledge in creating workbooks, dashboards, performance charts and reports using Tableau.

Designed database objects such as tables, indexes, views, sequences, procedures, functions, packages and Triggers in Development and Production environment using Oracle and SQL data.

California State University East Bay - Java Developer Intern

Hayward, CA

09/2016 - 11/2016

Devised application- Secure Group Key-Aggregate Encryption for shared cloud data in Dropbox for identifying problems in securing candidate information.

Implemented flexible encryption and decryption of communications between data owner and group users using java language and SQL by creating a trusted authority to have key based communications.

NTT DATA GDS, Inc - Applications Developer

Chennai, Tamil Nadu, India

08/2014 - 03/2016

Developed custom Intranet web application that includes functionalities such as Custom Master pages, shared calendars, shared documents, Integrated Dashboards and customized reports using .NET MVC and SQL server.

Designed and implemented stored procedures, views and other application database code objects to aid database mappings, conversions and transformations using Informatica PowerCenter across various RDMS systems.

Used Random and Key masking types under Informatica to mask name, data of birth, contact information and social security fields.

Worked with teams to convert multiple source XML files to single target file using Informatica and verified availability of all source files in target environment.

Identified, troubleshot and corrected bugs and bottlenecks by implementing performance tuning, data profiling, workflows and work-lets in Informatica thereby bolstering efficiency by 40%.

Aadhityaa Infomedia Solutions - Hadoop Developer Intern

Chennai, Tamil Nadu, India

01/2015 - 03/2015

Gathered clinical data and used Hadoop MapReduce technique for processing medical information of clinical patients and prescribed effectual drug without consent of physicians.

Used SQL Queries for querying clinical information and patient records.

Designed Use case diagrams for various modules of application and deployed the application on AWS local host.

Accomplishments

Group Recognition – Bravo - Nationwide Mutual Insurance (TDM team) Feb 11, 2020

Project Name: Data Masking in AS400 database and IBM Licensing Model

· Delivered masked data in AS400 database with minimal exposure to DB2 directory database on Optim.

· Worked on IBM Licensing model based on their Process Value Unit pricing.

Individual Recognition – Bravo - Nationwide Mutual Insurance (TDM team) March 27, 2019

Project Name: Policy Center Guidewire Optim Experiment

· Provided quality results with less exposure to Optim and provided the deliverable on time.

Intern Test Lead – State Compensation Insurance Fund- Project Jive May – Aug 2018

· Led a team of 3 interns for testing Jive applications in UAT testing environment.

· Prepared Master Test Strategy report for the business team.

Hackathon – Nationwide Mutual Insurance August 3-4, 2017

· Won the best team idea award amongst the ten teams participated.

· Built an innovative idea to bridge Nationwide's banking unit and the Mutual Funds Group.

· Developed a prototype of the idea using HTML 5, Ninja Mock and Microsoft Azure.

Skills

Languages: C, C++, Java, JavaScript, Angular 1.x, .NET MVC, XML.

Scripting: Unix Script, Windows Batch Script, IBM Lua Script.

Mark-up Languages: HTML, CSS, XML.

Framework: Bootstrap, Hadoop MapReduce.

Primary Databases: SQL, Oracle.

Secondary Databases(basics): DB2, Teradata, PL/SQL, Hive.

TDM Tools: IBM InfoSphere Optim, CA TDM, IBM ModApp, UMask.

ETL/BI Tools: Informatica PowerCenter, Tableau (Desktop).

Other Tools: DB2 data studio, Visual Studio, Visio, HP ALM, HP QC, Jive, AWS Fundamentals, Microsoft TFS, MS Office Suite.

Source Control Tool: GitHub.

Education

04/2018

California State University

East Bay, Hayward, CA

MS: Computer Science

04/2015

Rajalakshmi Institute of Technology

Chennai, India

BS: Computer Science and Engineering

Certifications

Informatica Tutorial: Beginner to Expert Level by Udemy.com

SQL Essential Training by LinkedIn Learning

Contact this candidate