Software Engineer Data
Resume:
MERIN MARY THOMAS
PERSONAL INFO
Phone:
Email:
***********@*****.***
LinkedIn:
linkedin.com/merin
CAREER SUMMARY
Talented professional with over 4 years of software development experience with full exposure to software life cycle including analysis, design, development and testing of software.
Worked as Software Engineer in health care domain on Mainframe platform at UST-Global Pvt Ltd, India.
Worked as Junior Consultant at Jigyasa Analytics, New Jersey, USA.
CORE SKILLS
OS: Windows XP, MVS/OS390, Unix
Languages: JCL, SAS 9.1, SQL, Unix
shell scripts.
Databases: Oracle11g, DB2
ETL Tool: INFORMATICA
Power Centre
Tools: TSO/ISPF, Endevor and
FileAid.
EDUCATION
Mahatma Gandhi University, Kerala, India (2002 – 2006)
B. Tech in Electrical and Electronics Engineering
CERTIFICATIONS AND TRAININGS
Certified in IBM DB2 Universal Database V8.1 Family.
Advanced Training: JCL, SAS,
INFORMATICA, DB2, UNIX
Online course for Informatica PowerCenter 9.6/10.1
Software Engineer at UST GLOBAL, India
(Oct 2006- Jan 2010)
Project : New Client Implementation Project (NCI)
Client : WELLPOINT Inc. USA
Platform : IBM Mainframe
OS : Z-OS
Software : SAS, JCL, SQL
ETL Tool : INFORMATICA Power Centre 8.5
Database : Flat files, SAS datasets, Oracle.
Tools : FILEAID, IDCAMS and SORT Utilities.
This project involves a series of phases enabling Well Point to migrate existing clients in the Well Point Claims Processing System (Proserv) to Anthem Prescription Management Claims Processing System (ProPBM) and implementation of New Clients in the ProPBM. This involves the migration of Prior Authorization data, Historical Claims data, Group/Member Eligibility data from ProServ to ProPBM system. The ProServ system manages its client data in IMS DB & small part in DB2 and the ProPBM stores data in Oracle database for different clients. Since ProPBM uses Oracle DB, Informatica serves as an Interface between DB and Mainframes.
Responsibilities
Requirement gathering, understanding the use cases.
Impact Analysis and data quality analysis, estimating the required effort.
Participating in design discussions and preparing the detailed design documents.
Extract the data from the source and transform it to the client specific format and load the transformed data to Oracle database using SAS and ETL tool Informatica Power Center.
Worked extensively on the Power Center tools such as designer, workflow manager, workflow monitor. Created mappings and executed the workflows with tasks, sessions, email components.
Worked on the transformations like joiner, filter, aggregator, expression, look-up, router etc.
Used flat files, xls, csv files, SAS datasets and Oracle database as Power Center source and targets.
Performed the Quality Controller (QC) role for the project.
Project : ANTHEM - DECARE CS90 Dental claims
Client : Anthem, USA
OS : Z-OS
ETL Tool : INFORMATICA Power Center 9.0 Database : Oracle
This project required a new data model to hold all the Decare Dental Claims information obtained from CS90 source system
and an ETL system to load the claims data into the warehouse database. The data from the source file will be landed in a landing zone table and then Decare claims business rules will be applied at the staging area and finally, the data will be loaded into the warehouse database.
Responsibilities
Development of an INFORMATICA based ETL architecture and framework.
Creates the STM (source to target mapping) which is used to prepare the ETL. Once the ETL is created, rigorous testing is done on Unit level.
Assure that INFORMATICA solutions are designed and developed in the optimal manner and in accordance with industry best practices.
Analyze functional requirements, and prepare mapping documents, assist in problem solving and trouble shooting.
Conduct quality assurance activities such as code reviews.
Jr. Consultant at Jigyasa Analytics, New Jersey, USA
(Aug 2011 - Jul 2012)
Project : Data model Automation
Operating System : Windows 98/XP
Software : SAS, JMP, VBA for EXCEL
Jigyasa Analytics enable their clients to adopt analytics to make better decisions in business. The client data have to undergo several modelling techniques to generate a perfect model with the suitable factors that stimulates business. This modelling process involved complex calculations which were automated using VBA for Excel.
I was responsible for the automation of several tools like Forecasting tool, Logistic Results Automation tool, SAS code execution tool and Constant Contact data tools. These automated tools were coded in VBA, tested and delivered. Also, I was involved in the support projects for data modelling using SAS and JMP software.
Responsibilities
Worked extensively in VBA for Excel with minimum guidance.
Good hands on experience with full exposure to software life cycle including analysis, design, development and testing of software in VBA.
Code review and unit test results review and code walkthrough.
Involved in several modelling tasks using SAS and JMP software.
Contact this candidate