Software Developer Project
Resume:
Ramyapriya Radhakrishnan Nair
***********.****@*****.***
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