Summary
Overview
Work History
Education
Skills
Timeline
Generic

Prabir Kumar Dhar

Detroit,MI

Summary

  • 17 years of IT experience and technical proficiency in the field of Data management, Data integration, Master data management, Data quality and Data governance.
  • Strong Informatica Administration & Architecture skills in building brand new Informatica Environments.
  • In-depth knowledge of multiple informatica products like Data Engineering Integration (Big Data Management), Data Engineering Quality (Big Data Quality), Data Engineering Quality (Big Data Quality), Enterprise data catalog, Enterprise data preparation, Axon, PowerCenter, Powerexchange CDC and IICS (Informatica Intelligent Cloud Services).
  • Proficient in UNIX/Linux Shell Scripting.
  • Successfully delivered many bigdata projects (including cloud and on-prem clusters) for various informatica customers on Cloudera and Databricks.
  • Good knowledge of python, Scala and pyspark language.
  • Successfully implemented the Kubernetes and docker based deployment of Informatica platforms.
  • Successfully implemented many projects in on-prem as well as public clouds (like AWS and Microsoft Azure).
  • Good knowledge on authentication mechanism of LDAP, Kerberos and SAML which usually configured with integration environment.
  • Collaborate with customer and conduct workshop, sessions and health checks of informatica environments.

Overview

13
13
years of professional experience

Work History

Senior Cloud solution specialist

Various Informatica customers
02.2014 - Current
  • Collaborated with diverse clientele to strategize and execute the seamless transition of Informatica Powercenter infrastructure to IDMC cloud.
  • Performed comprehensive analysis and debugging, effectively resolving product feature gaps by providing innovative and tailored solutions to customers.
  • Demonstrated exceptional problem-solving skills by efficiently managing critical customer blockers, ensuring a successful IDMC go-live.
  • Orchestrated effective communication and collaboration between customers and Research and Development teams to promptly address and rectify critical product bugs, essential for customer go-live.
  • Provided extensive support during customer go-lives and migrations, ensuring a streamlined and enhanced user experience.
  • Optimized customer data pipelines, surpassing Powercenter platform performance in IICS cloud, through meticulous tuning and configuration.
  • Create reference architecture and best practice documents for customer with their informatica infrastructure.
  • Work on advisory role with customers on their data management, data migration and data governance initiatives.
  • Act as an advisor for the customers cloud data lake and data warehouse journey.
  • Help customers with their data governance implementation (EDC, Axon and IDQ/BDQ).
  • Help customer’s architects in their platform sizing, scaling, performance, platform governance and operational issues.

E-Product Datamart, Project Technical Lead

Nationwide Insurance
Columbus, OH
07.2013 - 02.2014
  • Existing requirement analysis and data mapping for the Report attributes
  • Creating a prototype/POC
  • Analysis of all the source system to understand the data load strategy
  • Analysis of the specifications/requirements provided by the business user
  • Analyze and identify the potential performance bottlenecks of the Proto environment
  • Preparation and Updating of the TDD, TAD.
  • Code promotion to Test environment and Support of SIT
  • Preparation of production run book and mapping documents

TSG INFORMATICA ARCHITECT, Project Technical Lead

GE Aviation/Energy TSG
Cincinnati, OH
12.2010 - 07.2013
  • Project lead for a team of 31(6 onsite and 25 offshore)
    Ensuring 24x5 production support and reporting various production issues encountered to customer on daily basis.
  • Involve in the design, development and implementations of the Enterprise Data Warehouse (EDW) Data marts providing inputs and reviews at various stages of the project from run team prospective to improve performance from ETL loading and reporting prospective.
  • Answering the technical queries, driving the product initiatives and metrics collection & analysis.
  • Creating, updating and maintaining technical documentation for tools and projects involved as required.
  • Heading the change managements for code promotions into production for various technologies
  • Inspection, reviews, performance tuning and arranging meetings for defect preventions.
  • Planning the schedules for maintenance of applications and servers.
    Preparing business continuity plan as the DWH reports are used on daily basis to assess the risk of various power projects and make important decisions.
  • Co-ordination with design teams and technical support of different tools to improve performance and availability along with installation and configuration of the data warehouse tools as required.
  • Solution architect for Business and Project teams to choose PowerCenter products
  • Automating Agile manual process in PowerCenter Administration which will reduce tickets and SLA’s.
  • Handling Proof of Concepts for New PowerCenter tools and design configurations to fit GE Environments.
  • Preparing presentation, Case studies with POC results and taking GO or NO – GO decisions

Education

B. E -

Biju Patnaik University of Technology
05.2006

Skills

  • Informatica 10x PC, IDQ, EDC, EDP, DEI
  • Informatica Cloud suit(CDI, CAI, MIS, CIH)
  • Unix, Linux, Solaris, Ubuntu, Centos and Windows
  • SQL, PL/SQL, Unix Shell scripting
  • Oracle, MS SQL Server 2017, My SQL, Teradata, Greenplum, DB2
  • Public cloud: AWS , Azure and GCP
  • Data Platform: Databricks and snowflake

Timeline

Senior Cloud solution specialist

Various Informatica customers
02.2014 - Current

E-Product Datamart, Project Technical Lead

Nationwide Insurance
07.2013 - 02.2014

TSG INFORMATICA ARCHITECT, Project Technical Lead

GE Aviation/Energy TSG
12.2010 - 07.2013

B. E -

Biju Patnaik University of Technology
Prabir Kumar Dhar