Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Chandrakishore Bankhede

Minneapolis,MN

Summary

  • 17+ years of IT experience in Analysis, design, Development, Administration, and support across Data warehousing, Data Integration, and Client Server Business Applications in Healthcare, Banking, Finance, and Insurance domains.
  • Expertise in Informatica Intelligent Data Management Cloud (IDMC), Informatica Intelligent Cloud Services (IICS) and Informatica PowerCenter (IPC)with 10+ years of experience.
  • Strong background in RDBMS Oracle PL/SQL development and Informatica MDM.
  • Currently serving as an Informatica Lead Consultant/SME for IDMC/IICS and IPC Projects.
  • Proficient in project build, enhancements, Development ,upgrade, conversion, migration, deployment release, and regular operational Administrative activities.
  • Skilled in Agile SDLC: requirements analysis, design, development, and UAT of ETL mapping ,mapping task , task flows and scheduling etc.
  • Experienced Technical Lead and Informatica SPOC. Recognized for service excellence and collaboration, both independently and within teams.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Informatica Lead Consultant

CNA Financial
Minneapolis, MN
05.2023 - Current
  • Upgrading Informatica environment from unsupported versions to supported versions and/or re-platforming to IICS/IDMC
  • Understand business requirements and collaborate with business and application owners for implementation
  • Successfully upgraded Informatica PC and PWX from version 9.6.1 to 10.5.3, migrating the DB repository from Oracle 12CR1 to Oracle 19c
  • Setup Grid environment, test failover, and ensure high availability
  • Install Informatica Client tools, configure Domain, validate connections, and manage project folder structure/privileges access
  • Conduct sanity testing of IPC mapping/session/workflow and IPC&PWX connectivity
  • Automate/enhance code deployment, daily repo backup, and health checkup scripts
  • Assist team in code refresh, application checkout, unit testing, and UAT issue troubleshooting
  • Participate in daily standup meetings, weekly App owner meetings, and adhoc calls as a key resource
  • Support production migration/deployment release, CUT-OVER, hypercare, and Go-Live
  • Saved $92k by saving extended support cost after upgrade
  • Install IDMC/IICS secure agents, configure for new applications, and assist in IPC to IICS/IDMC conversion
  • Manage on-prem and GCP connectivity to Informatica Cloud, identity user/group access management through SAML, OKTA single sign-on
  • Setup cloud SQL agent and proxy to connect cloud databases, create various connections
  • Collaborate with business, product owners, and Informatica for IPC to IICS/IDMC conversion/migration assessment
  • Validate IPC to IICS converted mapping and resolve issues
  • Finalize IPU’s for IICS/IDMC environments based on workload/usage
  • Setup infra operational alerts and other Administrator parameters in IDMC
  • Create mappings using different transformations, create mapping tasks/task flows, and conduct testing
  • Conduct code promotion using manual export/import and Automated CI/CD concourse deployments
  • Provide UAT, Go-live support, and lead projects to expedite timely delivery
  • Support BAU Team for high priority P1/P2 Production incidents in IPC/IICS/IDMC area
  • Manage incidents, service requests, and change release management processes.

Informatica SME / Administrator / Technical Lead

CNA Financial
Minneapolis, MN
09.2018 - 05.2023
  • Informatica Projects assessment for upgrade and conversion /Migration from On-Prim IPC to IICS/IDMC along with Providing application and infrastructure support for IPC,PWX and IICS applications
  • Conducted assessments for IPC to IICS conversion and IPC upgrade to ensure platform support and improvement
  • Led requirement gathering for IICS Enterprise project and formulated roadmap for IPC to IICS conversion and IPC upgrade from 9.x to 10.x
  • Facilitated upskilling of resources in IICS and built team capability to execute IICS projects
  • Owned infrastructure setup and support for IPC and IICS on-premises and in GCP
  • Established DR environment and successfully conducted DR drills/exercises
  • Install & configure IICS Secure Agent on GCP and on-premises servers, SAML/OKTA configuration
  • Saved $50k by removing unused product licenses and decommissioning IPC 9.1
  • Managed installation, upgrade, issue investigation, and EBF implementation
  • Optimized IPC and IICS user identity access management processes to ensure compliance
  • Administrative support, mentored team, handled escalations, and addressed high-priority issues
  • Conducted troubleshooting for job failures, performance issues, bug fixes, and proactive monitoring
  • Managed code migration from Informatica 9.1 to 9.6, Power Exchange Data Map Migration, and deployments across different repositories for IPC, as well as CI/CD deployments for IICS
  • Created and managed repository folders, and Informatica connections like ODBC, SFTP, GBQ, PostgreSQL, Salesforce, etc
  • Conducted monthly patching activities, production refresh activities, and addressed vulnerabilities
  • Served as Informatica SME, Lead & Informatica MSP owner, managing self-attestation, SOX audits
  • Implemented several automations for environment health checks & monitoring using Shell script.

Technical Lead

Monsanto / Bayer
Whippany, New Jersey
07.2016 - 09.2018
  • Providing application and infrastructure enhancement and support for Informatica MDM and ETL Informatica data integration platforms
  • Installation, Upgrade, investigate an issue and EBF implementation
  • Team mentoring, support them for troubleshooting an issue and handling high priority P1/P2 issue
  • Manage permissions and privileges for users/groups, grant/invoke access for App Team
  • Code Migration from lower environment to higher environment
  • Create and manage Repository folders, Create, and manage relational connections
  • Investigation for the failure of the Jobs for MDM and for IPC wf/session and fix
  • Make sure all the IPC, IDR, MDM, CIS, IDD, and BD services are up and running
  • Workflow Relation connection management, Password updates as per the compliance
  • Update MDM Country files from Informatica Address dr to Informatica MDM
  • Support for the Informatica MDM applications and provide resolution for the process failure
  • Attend Daily ops call and share business updates, also Play different roles as Independent contributor / Informatica Module Lead / Team mentor/Shift lead / Informatica SPOC
  • Additional competency on WebLogic to work on MDM hosted servers in Linux Environment
  • Implemented monitoring scripts for infrastructure health checks, service availability and uptime monitoring, performance monitoring and optimization, resource utilization tracking, job execution and completion monitoring, error and exception detection and notification, log file monitoring and analysis, backup and recovery status monitoring, system and application event logging, proactive issue detection and resolution, automated notifications and alerts.

Technical Lead

Covidien / Medtronic
Minneapolis, MN
03.2013 - 07.2016
  • Consolidating Customer and Product Data by extracting from diverse source systems, storing in a centralized repository, and loading into Informatica MDM
  • Ensuring a single version of truth (Golden data) for efficient use across multiple systems and requirements
  • Understand business functionalities and integration requirements across systems
  • Utilize Informatica Cloud ETL tool for loading data from various sources, performing filtrations, validations, and schema analysis
  • Collaborate with business stakeholders and technical architects to define project requirements
  • Provide MDM technical services under architect supervision using Informatica technology
  • Develop mapping specifications to illustrate data flow and relationships within MDM schema
  • Building the party hierarchy data model and defining the relationships between entities in HM
  • Create and Execute match merging processes using exact match and fuzzy match logic
  • Creating lading tables, Staging tables, and base objects
  • Configuration of business rules configurations like trust settings, match, and merge rules
  • Creating queries, packages and working with data manager to create display packages and custom packages
  • Build mappings for moving data from landing tables to staging tables, applying trust and validation
  • Configured Informatica Data Director, design workflow customizations for Data Stewards.

Developer and Team Lead

Covidien
Minneapolis, MN
10.2012 - 03.2013
  • Integrating data between SAP and Salesforce using Informatica Cloud
  • Gather requirements by consulting with BA to meet current & future business needs
  • Analyze and formulate logic for new systems based on existing applications and systems
  • Design databases, code, and debug programs
  • Assist in defining and documenting deliverables and specifications in collaboration with project team
  • Develop synchronization services and Oracle PL/SQL objects for critical modules
  • Collaborate with Salesforce and project teams to gather ETL requirements
  • Prepare high-level designs for replication, synchronization, transformation, loading, and task flow
  • Integration between SAP and Barrx SFDC instances for Informatica Cloud development
  • Design, develop, modify, configure, debug, and evaluate application programs for functional areas
  • Troubleshoot data issues partially sent to Salesforce.com (SFDC) cloud system
  • Handle bug fixes, patches, enhancements, and service requests.

Developer and Technical Lead

Covidien
Minneapolis, MN
06.2012 - 09.2012
  • Preparing source feed of SFDC for different objects and regions
  • Participate in requirement gathering, design, development, SFDC testing, UAT, and Go-live support
  • Maintain large datasets through scheduled activities and manage task flows across different time zones
  • Conduct code reviews and handle day-to-day tasks to ensure system functionality.

Programmer Analyst

Tsys CardTech
Mumbai, India
01.2011 - 06.2012
  • Development of payment system processing product for credit cards
  • Prepare Technical design document and get final approval from Sme and Development of assigned modules of Issuer system using Oracle PL/SQL objects like procedures, functions, packages, advance Queues and Streams
  • Aid in internal and external QA and bug fixing and Installation & implementation of product at client side
  • Requirement Analysis of new business requirements (Change Requests)
  • Customization Development & Enhancement of Prime as per client’s business requirements using Oracle PL/SQL
  • Performance Tuning & Internal QA, UAT& Project Go Live Support.

Developer (Software Engineer)

L&T Finance
Mumbai, India
01.2010 - 01.2011
  • Implementing and support for loan origination and processing system
  • Analyze requirements and develop SQL check scripts, PL/SQL blocks, stored procedures, functions, and packages for optimization
  • Enhance and maintain Credit Committee functionality to meet business needs
  • Rectify data in the database to improve data integrity
  • Generate MIS reports for Operations and Accounts departments
  • Provide application production support, including handling critical and urgent issues on call.

Developer

RTA
Dubai, UAE
07.2009 - 01.2010
  • Developing enterprise GIS platform for transportation projects
  • Developed optimized SQL check scripts, database design/SQL blocks, stored procedures, functions, and packages for geometry validation and DBQC
  • Implemented triggers to restrict bulk updating of data and performed spatial indexing
  • Developed logical and physical data models for schema generation according to client specifications
  • Loaded data into Oracle Spatial using Oracle shp2sdo, SQL Loader, and Map Builder
  • Managed versioning of spatial data using Workspace Manager and created topology models
  • Established and managed historical archive logs and implemented Log Miner Utility.

Developer

Automotive Navigation Data (AND)
France, France
03.2007 - 06.2009
  • Creating land base and transportation network database
  • Create and manage schema objects such as tables, indexes, synonyms, sequences, and views
  • Develop optimized SQL check scripts, PL/SQL blocks, stored procedures, functions, packages, and triggers for database checks according to client specifications
  • Load spatial data, perform indexing of spatial data, and update SRID in Oracle Spatial
  • Manage historical archives for data
  • Load ASCII data from external files and create TIN using DTM ASCII data.

Education

Skills

  • Informatica Intelligent Data Management Cloud (IDMC)
  • Informatica Intelligent Cloud Services (IICS)
  • Informatica PowerCenter (IPC)
  • Informatica PWX
  • Informatica MDM
  • Informatica Data Replication
  • Informatica Address Doctor
  • Informatica Data Quality(IDQ) /CDQ
  • Tibco Data Virtualization
  • BDD
  • HM
  • Control-m
  • Autosys
  • Sky boat
  • Composer
  • GitHub /GitLab
  • Jira
  • Concourse CI/CD
  • Okta/SAML/SCIM
  • Oracle PL/SQL
  • Oracle Spatial
  • SQL Server
  • Informix
  • Linux/Unix Shell scripting
  • Windows batch scripting
  • Linux
  • Unix
  • Windows
  • Putty
  • SecureCRT
  • Mobaxterm
  • WinSCP

Certification

  • Intelligent Data Management Cloud (IDMC) Foundation
  • Informatica PowerCenter Data Integration 10
  • ITIL Foundation Certificate in IT Service Management
  • Oracle Spatial 10g Advanced

Accomplishments

  • Service excellence Award
  • various Accolades
  • Customer Appreciations

Timeline

Informatica Lead Consultant

CNA Financial
05.2023 - Current

Informatica SME / Administrator / Technical Lead

CNA Financial
09.2018 - 05.2023

Technical Lead

Monsanto / Bayer
07.2016 - 09.2018

Technical Lead

Covidien / Medtronic
03.2013 - 07.2016

Developer and Team Lead

Covidien
10.2012 - 03.2013

Developer and Technical Lead

Covidien
06.2012 - 09.2012

Programmer Analyst

Tsys CardTech
01.2011 - 06.2012

Developer (Software Engineer)

L&T Finance
01.2010 - 01.2011

Developer

RTA
07.2009 - 01.2010

Developer

Automotive Navigation Data (AND)
03.2007 - 06.2009

Similar Profiles

CREATE PROFILE
Chandrakishore Bankhede