+91-9632668877 (M)
Career Objective
To be part of an organization that gives me opportunity to enhance my knowledge and be part of a team that dynamically works towards growth of organization.
Summary of Experience and Qualifications- Having 5.6 years of IT Experience with a focus on with designing, developing, implementing and supporting Data Warehouses.
- Participated in Full life cycle development of Data Warehouse systems including Analysis, Understanding functional need and Translating functional designs into technical Design, Development, unit testing and Technical Documentation.
- Expertise in Querying and testing Data by writing SQL query and Shell scripting on Unix Environments.
- Excellent problem solving skills with strong technical background, excellent team player with interpersonal skills.
- ETL Tool: Informatica Power Center 9.x,Informatica IDQ
- Database: Teradata, Teradata Utilities,Oracle 11g, SQL Server 2008
- Operating System: UNIX, Windows
- Others: Networking, OS, Database, Data structure.
Organizational Experience
- Jan 15 – Till Date : Deloitte Consulting
- Dec 11- Jan 15: Cognizant Technology Solutions
- Vertical: Health and Life Insurance,Telecom, Banking
- Role: Informatica Developer
Current Project
Industry: Health Care and Life Sciences
Role: ETL Developer
Duration:Feb 2015-Sep 2016
Project Name: TUFTS Health Plan (TUFTS)
Client:
Tufts Health Plan is nationally recognized for its commitment to providing innovative, high-quality health care coverage. Tufts Health Plan is one of the few health plans in Massachusetts to participate in the commercial, Medicare and Medicaid/subsidized markets, offering coverage across the life span regardless of age or circumstance.
With headquarters in Massachusetts, Tufts Health Plan also serves members in New Hampshire and Rhode Island. It provides various plans like Medicare, Medicaid and Market place plans offering Health Insurance Coverage across the life span regardless of age or circumstance.
Project:
The main purpose of this project is to provide the provider information in flat file format to HealthRule Payer (HR Payer) system, by reading data from various sources like Express, Cactus and THP systems.
Key Responsibilities:
- Responsible for the complete Design, Development, validation and testing of interfaces by ensuring specific standards and consistency.
- Ensure the quality and timeline of deliverables.
- Understand the business and develop and Unit test the code.
- Perform Peer review and suggest correction, if required.
Industry: Health Care and Life Sciences
Role: ETL Developer
Duration:Feb 2015-Sep 2016
Project Name: PIXProvider Extracts
Client:
Client is one of the nation’s largest health benefits companies, with nearly 34 million members in its affiliated health plans and approximately 65 million individuals served through its subsidiaries. It haslicense in 14 states and provides plans under the Unicare name in other parts of the country.
Project:
DX- Comprehensive care deals with extracting Claims, Provider, ETG, DXCG and Membership attributes out of EDWard on a periodic basis.In addition, two daily CIRS extracts get generated from the input files provided by CIRS system.
The extracts are carried out on a daily/monthly/quarterly basis for the ACO attributed members from EDWard. Business defined transformation logic is applied on Member, Claim, Provider, ETG, DXCG and CIRS data and the same is loaded into Work tables before exporting in the form of files. The requirement for Build 1 is the mapping logic to source data elements from a combination of the Host or Home instances of a claims based on overall data quality as identified in profiling exercise. Upon generating the Extracts for all the subject areas, Files need to FTP’ed to respective ACO folders for ACO processing.
The extracts as part of the requirement will source the attributed members from the strategic source for Payment Innovation.
Key Responsibilities:
- Responsible for the complete Design, Development, validation and testing of interfaces by ensuring specific standards and consistency.
- Designing effective ETL architecture which matches the requirement and provides the required outputs.
- Completely involved right from the beginning of analyzing the existing system and functionality requirements, review of all deliverables
- Preparation of Low Level design documents based on the business logic and requirement.
- Developing and Troubleshooting of Mappings and Workflows for ETL Jobs based on the Low Level design documents and according to the standards of client.
- Preparation & validation of estimations, status reports while coordinating with onshore and driving the offshore team to accomplish the required tasks on time.
- Migration of ETL jobs onto testing and preproduction repository environments.
Other Project Work Experience
- Dec 11 – Jan 15 :Cognizant technology Solutions
- Role: Informatica Developer
Account: One of the leading Bank of UK
Domain: Banking and Financial Services
Summary of Project:
The project provides reports to the HMRC (HM revenue and custom) within 7 days of end of each quarter, the report is then used for analyzing the customers who falls in exceptional and matched categories for PPI related payment for UKRBB cluster.
Then after analysis all customers falling under exception are reported to PPI finance and corrected in timely manner.
For this purpose, we have 3 layer architecture. It involves ETL processes using Informatica Power center9.x, Data is gathered from 2 different source systems, transformed as per the logic and given out in the form of reports to the client, from a relational database and sometimes from flat files.
Responsibilities:
- Responsible for analyzing, designing and developing ETL strategies and processes.
- Work in co-ordination with other application system (developers), Team Lead to understand the requirements and fetch data correctly.
- Involved in developing Mappings and reusable transformations using Informatica Designer.
- Source system data from the distributed environment was extracted, transformed and loaded into the Data warehouse database using Informatica.
- Extracted Data from flat files and various relational databases to Oracle Data warehouse Database.
- Created the unit test cases for mappings developed and verified the data.
- Conducted the peer review for mappings developed and tested.
- Most of the transformations were used like the Source qualifier, expressions, and joiner, Aggregators, Lookups, Filter, Rank and Update Strategy.
- Developed and modified changes in mappings according to business Logic.
- Used Informatica Workflow Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution.
Academic Qualification
- B.E (CSE) from Godavari college of Engg. Jalgaon with 66.15%(Distinction) in 2011.
- H.S.C from Patna Muslim High School (C.B.S.E) with 72.20% in 2007.
- S.S.C Infant Jesus School (C.B.S.E) with 82% in 2005.
Personal Details
- Date of Birth:5th Jan 1990
- Marital Status: Married
- Language Known:English, Hindi
Ekta Kumari
Place:Bengaluru
Signature
Date:17 Mar, 2017