Ramyapriya Radhakrishnan Nair

ac8z6a@r.postjobfree.com

551-***-****

Professional Summary

I have 4+ yrs of experience in IT Industry in data warehousing and data analysis projects that include data integration, data analysis, development, unit system & integration testing for data integration systems. I have worked in projects in insurance domain and have been provide business solutions using Informatica with Oracle and mainframes etc.

Experience with implementing Data solution using Informatica Power Center 9.x.

2+ years of expertise on Informatica: Mappings, Mapplets, transformations, Sessions, command tasks, Workflows, Partitions, Pushdown optimization, Session & Mapping Performance tuning.

Experience in integration of various data sources from Databases like Oracle, Teradata, SQL Server and formats like flat-files, CSV files and COBOL files.

Implemented performance tuning techniques on Targets, Sources, Mappings and Sessions at design and system level.

Experience in writing efficient SQL queries, fine tuning queries and complex SQL queries.

Excellent communication skills, good organizational skills, self-motivated and extremely hardworking with ability to implement business concepts quickly and efficiently.

Good knowledge in Healthcare Domain, insurance, claim process and applications.

Extensively used partitioning, indexes and various join types to improve the performance.

Scheduling & Batch handling: Worked on scheduling tool Control-M to handle Informatica batches/jobs.

Excellent analytical, problem solving and communication skills, with ability to interact with individuals at all levels.

Education Qualifications:

Bachelor of Technology

Certifications and trainings:

DB2 certification

Technical Skills:

ETL

Informatica 9.x

Job Scheduling Tools

Control-M

Database

Teradata, Oracle 10g, SQL SERVER, DB2,

Programming Languages

UNIX Shell Scripting, SQL, Cobol, JCL

Other Tools/Exposures

Mainframe,TOAD, WinSCP, MS Office, Putty, Nexus Query, hpq

Project Experience:

GE Real Estate Service Operations

Client

GE

Duration

JUN 2012 – July 2014 (25 Months)

Technology

Informatica 8.x, Oracle, Unix Shell scripting, TRIRIGA

Project Abstract

The goal of building GERESO DWH was to help and standardize the day to day activities and procedures for easy of handling Real Estate management operations and maintenance . GERESO users use this GERESO DWH for generating various reports for effective analysis purpose. GERESO DWH uses TRIRIGA application (Workplace Management System to manage complete real estate lifecycle)

Roles/Responsibilities

Software developer

Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).

Create various Unix scripts to automate the file process and validation.

Used ETL (Informatica) to load data from sources like Oracle database and Flat Files.

Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.

Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.

Involved in Unit and System testing of developed mapping.

Optimizing Query Performance, Session Performance.

WGS SSCR(Small scale change Requests)-Claims and Pricing

Client

WellPoint

Duration

Mar 2011 – may 2012(14 Months)

Technology

Mainframes(Cobol,JCL,Imsdb);Tools:changeman,Filemanager,FMIMS,,SuperCE,Operating system: MVS/OS390

Project Abstract

Wellpoint is a global leader in health benefits for large and small employer, individual, Medicaid and senior markets. SSCR aims to achieve greater throughput to WellPoint Members by reduce enterprise spend and improve execution efficiency and provide the reports and Metrics to business users to make decision. As the name indicates, the project involves small changes of previously done large scale projects.

Roles/Responsibilities

Senior Software developer

Analyze the business requirements of the clients

Analyzing, Designing and Coding programs.

Preparing Test plans, conducting testing, delivering test results

Unit Testing, System integration Testing

Debugging COBOL and DB2 applications.

Development phase activities for respective tracks assigned

Conducting post implementation reviews and support during implementations

Help and guide the new team members in the team.

Perform lead activities and schedule the tasks.

As the quality controller/defect prevention controller of the project, prepare the weekly metrics and discuss with the team on the defects that were reported.

WGS-Claims – Renovation Project

Client

WellPoint

Duration

DEC 2009 – Feb 2011 (15 Months)

Technology

Mainframe,COBOL,JCL,IBM-DB2

Project Abstract

Wellpoint is a global leader in health benefits for large and small employer, individual, Medicaid and senior markets. This project is to increase the auto-adjudication of claims on WGS 2.0 which require manual processing/manual intervention to process claims. Also, these enhancements will increase the turnaround time of claims processing while keeping the 100% quality and 100% efficiency of claims and reducing the overall cost of the way we process claims today.

Roles/Responsibilities

Business Analyst

Analyze the business requirements of the clients

Analyzing, Designing and Coding programs.

Preparing Test plans, conducting testing, delivering test results

Unit Testing, System integration Testing

Debugging COBOL and DB2 applications.

Development phase activities for respective tracks assigned

Conducting post implementation reviews and support during implementations

As the quality controller/defect prevention controller of the project, prepare the weekly metrics and discuss with the team on the defects that were reported.

Contact this candidate