Kiran K.

Kiran K.

ETL developer/ Data Engineer

Bengaluru , India

Experience: 8 Years

Kiran

Bengaluru , India

ETL developer/ Data Engineer

33364 USD / Year

  • Notice Period: 25 Days

8 Years

Now you can Instantly Chat with Kiran!

About Me

7 years of extensive experience in the field of Information Technology expertise in Business Intelligence solutions in developing large-scale Data warehouse and Client/Server Applications using Informatica Power Center and Oracle. • Involved in ...

Show More

Portfolio Projects

HEDIS (Health Effectiveness Data Information Set)

Company

HEDIS (Health Effectiveness Data Information Set)

Description

Tools : Informatica Power Center, Teradata, UNIX Shell Scripting Team Size : 5 Duration : 3 years Description: The Loading the HEDIS measures which are crucial in determining the score of the Health plan as per the US government terms and conditions which give rating to Organization based on the Health plan Standards

Show More Show Less

SENIOR RISK (SRK)

Company

SENIOR RISK (SRK)

Description

Tools : Informatica Power Center, IBM DB2, UNIX Shell Scripting Team Size : 15 Duration : 1.3 Years Description: As part of this project, we processed the eligible/non-eligible members according to Affordable Care Act. In addition, the enhancements and maintenance of the comprehensive health care reform law enacted in March 2010.

Roles & Responsibilities: • Involved in all phases of SDLC from requirement gathering, design, development, testing and support for production environment. • Mentoring the team to make sure meeting the SLA as expected and monitoring the loads. • Guiding and motivating team when they stuck with requirement analysis or technical roadblocks. • Worked on Performance tuning to decrease the run time of process from 72 hours to 7 hours. • Involved in giving internal and external reviews to the client for developed projects.

Show More Show Less

Wyndham

Company

Wyndham

Description

Tools : Informatica Power Center, Oracle, UNIX Shell Scripting

Team Size : 3 Duration : 1 year Description: The requirement is to utilize Revinate data associated with all survey components and determine the quality score for all WHG properties. Franchisee operations team will utilize the score and take necessary actions to facilitate their business operations. Annual & Quarterly WynReview report generated in Salesforce for Service, Cleanliness and Condition Data feed from Revinate for WynReview manually extracted and loaded to Salesforce. Data feed from Revinate for OTA Guest Satisfaction Ratings extracted and loaded to Salesforce. Responsibilities: • Understanding the Customer Requirements and the Technical Specifications Documents. • Played role of ETL developer in developing mappings, unit testing and resolving the issues in QA testing phase. Also involved in Deployment process while moving components across environments, defect tracking and bug fixing. • Participated in preparing Unit test case documents, detailed design documents and mapping sheets.

Show More Show Less

BCBSMN

Company

BCBSMN

Description

Tools : Informatica Power Center, Teradata 15.1 Team Size : 6 Duration : 1.5 year Description: • Blue Cross Blue Shield Minnesota (BCBSMN) is a leading U.S. Healthcare company, dedicated to providing the best care and optimizing outcomes when care is sought. BCBSMN connects payers, providers and patients in the U.S. healthcare system. BCBSMN’s offerings integrate and automate key business and administrative functions of its payer and provider customers throughout the patient encounter. BCBSMN sells health insurance products for Individual, Small, large groups, Medicare and Medicaid market in the state of Minnesota. • There are 6 different domains in Health Care system namely Member, Claims (Medical & Pharmacy), Provider, Client and Benefit. I had worked for Member domain Roles and Responsibilities • Creation of Informatica mappings. 4 • Creation and scheduling of jobs. • Preparation of UTC documents and review checklists. Coordination of onsite calls. • Worked on tools like ClearCase and Build Forge for Code Migration. • To write SQL scripts for performing the business logics. • Preparation of High-level test scenarios and development of test cases. • Involved in Identification of Test Data using SQL. • Test Execution and Defect logging and tracking of defects till its closure.

Show More Show Less