Summary
Overview
Work History
Education
Skills
Organisational Experience
Annexure
Personal Information
Languages
Timeline
Generic

Keerthi HP

Bengaluru

Summary

Dedicated Associate with 5+ years of extensive experience in Informatica powercenter, collaborating with clients, promptly identifying needs and recommending products and services to accomplish clients' goals.

Overview

6
6
years of professional experience

Work History

Associate

Cognizant
04.2018 - Current
  • Informatica developer for one year and currently working as System administrator for SAAS platform-based applications
  • Prioritized tasks to meet tight deadlines, pitching in to assist others with project duties.
  • Worked varied hours to meet seasonal and business needs.
  • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer
  • Worked on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner, XML
  • Extracted data from SAP system to Staging Area and loaded the data to the target database by ETL process using Informatica PowerCenter
  • Proficiency in developing SQL with various relational databases like Oracle, SQL Server
  • Providing support in handling escalation from clients to resolve their concerns and addressing their queries (customer advocacy) from other departments for a smooth ride for customer’s diverse issues.
  • Worked closely with global customers spanning to troubleshoot software problems.
  • Tested troubleshooting methods and documented resolutions for inclusion in knowledge base for support team use.
  • Checked configuration files and logs to uncover root causes of problems.

Education

B.E. (Computer Science and Engineering) -

Don Bosco Institute of Technology
Bengaluru, Karnataka
01.2017

Skills

  • Windows
  • Linux
  • SQL
  • HTML
  • SQL Server 2008
  • Oracle 11g
  • Informatica PowerCenter
  • Project Execution
  • Defect Management
  • Team handling and coordination

Organisational Experience

03/2018, Present, Cognizant, Associate, Informatica developer for one year and currently working as System administrator for SAAS platform-based applications. Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Worked on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner, XML. Extracted data from SAP system to Staging Area and loaded the data to the target database by ETL process using Informatica PowerCenter. Proficiency in developing SQL with various relational databases like Oracle, SQL Server. Providing support in handling escalation from clients to resolve their concerns and addressing their queries (customer advocacy) from other departments for a smooth ride for customer’s diverse issues.

Annexure

  • EPiC TPI Due Diligence Tool, Johnson & Johnson, Support, 10, EPIC: TPI Due Diligence Tool is a system that facilitates the third-party intermediary (TPI) Due Diligence process, which must be conducted before entering a business relationship with a TPI who will interact with or transact business on behalf of J&J with OUS (outside the United States) Government Officials or OUS Health Care Professionals (HCPs). DD is a process to ensure that relevant information is reviewed and properly considered before making the important decision to enter a business relationship with a TPI., Working as System administrator. Monitoring system progress & outstanding issues and ensuring the quality & timeliness of deliverables; extending post-implementation support to team members by identifying defects, inconsistencies & errors. Deployment of code changes and configuration changes to the system. Handling all client queries and issues and providing utmost support in resolving all issues for smooth function. Co-ordinate with Vendor and Client teams in weekly status calls, perform timely system tests to ensure correct functionality and provide support to vendor for release management.
  • Informatica, Johnson & Johnson, Support and Enhancement., The primary objective of this project is to capture different Customers, Products, invoice details, contract details and financial related data from multiple OLTP Systems and Flat files. Extracted Transformed Loaded data into data warehouse using Informatica PowerCenter and generated various reports on a daily, weekly monthly and yearly basis. These reports give details of the various products of J&J. The reports are used to monitor contract expirations and revenue, risk analysis report for business development managers., Understand all the Business documents. Investigating and fixing the bugs occurred in the production environment. Maintained warehouse metadata, naming and warehouse standards for future application development. Used Oracle to write SQL queries that create/alter/delete tables and to extract the necessary data Adding new column to source and mapping. Creating new mapping for new source table. Extracting data from various source through oracle DB links daily and provide necessary reports also perform code changes according to business requirement.

Personal Information

  • Marital Status: Married
  • Date of Birth: 04/24/1996

Languages

English
Bilingual or Proficient (C2)
Kannada
Bilingual or Proficient (C2)
Hindi
Upper intermediate (B2)

Timeline

Associate

Cognizant
04.2018 - Current

B.E. (Computer Science and Engineering) -

Don Bosco Institute of Technology

Similar Profiles

CREATE PROFILE
Keerthi HP