Experience

CNA Financial Services

• Australia
• Financial Services
• 1 - 100 Employee

• Informatica SME /Administrator

  • May 2023 - Present

  Bloomington, MN *Understand the business functionality of all the systems, Study the infrastructure requirements and Capacity requirements and Define Requirements. Involving in discussions with business and App Dev Team to build requirements/ Solution design for the project. *Coordinate with Server Build Team and other Project Build Team like Admin, Storage, Mainframe DB2, Oracle DB Team and share requirement to get ready server for Informatica Installation with all the pre-requisites including RHEL… Show more *Understand the business functionality of all the systems, Study the infrastructure requirements and Capacity requirements and Define Requirements. Involving in discussions with business and App Dev Team to build requirements/ Solution design for the project. *Coordinate with Server Build Team and other Project Build Team like Admin, Storage, Mainframe DB2, Oracle DB Team and share requirement to get ready server for Informatica Installation with all the pre-requisites including RHEL version, Network file system storage, NFS Mount, copy existing Dir/files/soft link, local/AD user creation privileges / permission etc to Newly build server and create required Oracle DB / Users etc. *Install Oracle 12cR1 and Oracle 19c Client on all required nodes and copy TNS entries and check connectivity from Informatica New servers to Domain / Repo schema and Source/target DB. *Start Parallel Upgrade –Install IPC 10.2 -> upgrade to 10.2HF2, update Node name, Domain Name and all other administrative parameter and validate all access and privileges migrated to new servers. *Upgrade Oracle DB from 12cR1 to 19c and did in-place upgrade from 10.2HF2 to 10.5.3. *Create and Restore repository, create Integration services, and get it assigned to all the workflows.

• Informatica SME / Administrator /Technical Lead

  • Sep 2018 - May 2023

  Bloomington, MN *IPC to IICS conversion assessment & IPC upgrade assessment to keep supported and better platform. *Involved in all the phases starting from Requirement gathering for IICS Enterprise project and defined Roadmap for IPC to IICS Conversion and IPC Upgrade 9.x to 10.x, *Upskilling resources in IICS and build capability in Team to execute IICS projects. *Complete Ownership for infrastructure setup and support for IPC, IICS for on-prem and GCP. *Setup DR Environment and successfully… Show more *IPC to IICS conversion assessment & IPC upgrade assessment to keep supported and better platform. *Involved in all the phases starting from Requirement gathering for IICS Enterprise project and defined Roadmap for IPC to IICS Conversion and IPC Upgrade 9.x to 10.x, *Upskilling resources in IICS and build capability in Team to execute IICS projects. *Complete Ownership for infrastructure setup and support for IPC, IICS for on-prem and GCP. *Setup DR Environment and successfully completed DR drill / Exercise. *IICS Secure Agent Installation and setup on GCE’s and On-premises servers & SAML/OKTA Configuration *Saved $ 50k by removing unused product license from 9.6,1 and Decommissioning of IPC 9.1 after doing quick infrastructure assessment and confirmation with App owner and Business. *Responsible for installation, Upgrade, investigate an issue and EBF implementation. *Optimized IPC and IICS User Identity access Management process and manage well as per the compliances. *Administrative support / Team mentoring & Support Team on burning issue, handling escalations and high priority issues. *Job failure / performance issues troubleshooting, Bug fixes, proactive monitoring to run the business. *Code Migration of Informatica 9.1 to 9.6, Power exchange Data Map Migration, regular Deployment across the different repositories for IPC and CI/CD Deployments for IICS



Bayer

• Chemical Manufacturing
• 700 & Above Employee

• Technical Lead

  • Jul 2016 - Sep 2018

  Whippany, New Jersey, United States *Responsible for all Administrative tasks in Informatica Power Center, Informatica MDM, Informatica Data Replication, Teradata Application server, Tibco Data virtualization, WebLogic Application Server *Responsible for 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… Show more *Responsible for all Administrative tasks in Informatica Power Center, Informatica MDM, Informatica Data Replication, Teradata Application server, Tibco Data virtualization, WebLogic Application Server *Responsible for 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/node Logs and investigate and fix. *Every other day backups on TDV/CIS/BD metadata. *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. Show less



Medtronic

• United States
• Medical Equipment Manufacturing
• 700 & Above Employee

• Technical Lead

  • Jun 2014 - Jul 2016

  Minneapolis, MN *Understand the business functionality of all the systems and understand the integration requirements. *Load the data from different source using ETL Tool informatica cloud by Performing the data filtrations, *Validation on schema tables and understanding the data. *Involved in discussions with businesspeople and technical Architect to build requirements for the project. *Worked under the architect’s supervision to provide MDM technical services using Informatica… Show more *Understand the business functionality of all the systems and understand the integration requirements. *Load the data from different source using ETL Tool informatica cloud by Performing the data filtrations, *Validation on schema tables and understanding the data. *Involved in discussions with businesspeople and technical Architect to build requirements for the project. *Worked under the architect’s supervision to provide MDM technical services using Informatica technology. *Worked on mapping spec to point out the data flow and relationships for the MDM schema. *Building the party hierarchy data model and defining the relationships between entities in HM. *Involved in match merging process by using exact match and fuzzy match logic types. *Creating lading tables, Staging tables, and base objects. Involved in Independent Client Calls and presenting Daily Status report to client. *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. *Created mappings to move the data from landing tables to staging tables. Load the base objects and use them. *Trust and Validation rules. Show less



Covidien (Medtronic Minimally Invasive Therapies Group)

• United States
• Medical Equipment Manufacturing
• 700 & Above Employee

• Developer and Team Lead

  • Oct 2012 - Jun 2014

  Minneapolis, MN *Requirement gathering by Consult with business analyst and architects to understand, anticipate, and meet Current and future business needs. *Analyze existing applications and systems and formulates logic for new systems. *Database design, perform coding and tests/debugs programs. *Assist in the definition, development, and documentation of deliverables, and specifications defined in the IT Methodology, in collaboration with business analyst and other project team… Show more *Requirement gathering by Consult with business analyst and architects to understand, anticipate, and meet Current and future business needs. *Analyze existing applications and systems and formulates logic for new systems. *Database design, perform coding and tests/debugs programs. *Assist in the definition, development, and documentation of deliverables, and specifications defined in the IT Methodology, in collaboration with business analyst and other project team members. *Develop different synchronization services for Transformation and Loading and develop Oracle PL/SQL Objects like procedures, functions, pl/sol block, SQL scripts as per requirements for Critical Modules to Support the team & meet the project deadlines. *Worked with Salesforce and project team to gather ETL requirements. *Prepare high level design for Replication, Synchronization, Transformation, loading and Task flow. *Management to Transfer information between Given SAP instance and Barrx SFDC instance objects as per Business requirements for ETL- Informatica Cloud development

• Technical Lead

  • Jun 2012 - Sep 2012

  Minneapolis, MN *Involve in requirement gathering, Design, development, SFDC testing, UAT and Go live Support. *Interaction with client to discuss functional requirements and updates, Team handling & Preparing TDN *Maintainability of huge data by scheduled Activity, Maintain Task flow as per different time zones. *Code review and Day-to-day tasks to ensure systems are up and running.



Tsys CardTech

• Programmer Analyst

  • Jan 2011 - Jun 2012

  Mumbai, Maharashtra, India *Prepare Technical design document and get final approval from Smedstad 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… Show more *Prepare Technical design document and get final approval from Smedstad 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 Show less



L&T Finance

• India
• Financial Services
• 700 & Above Employee

• Developer (Software Engineer)

  • Jan 2010 - Jan 2011

  Mumbai, Maharashtra, India *Requirement Analysis and Development for optimizing SQL Check Scripts, PL/SQL blocks, Stored Procedures, functions, packages as per new requirements. *Enhancement & Maintenance of Credit Committee as per business needs *Data rectification in Database to have a better Data Integrity *MIS Reporting to OPERATIONS & ACCOUNTS departments. *Application Production Support to handle critical and Burning Issues this include on call support. Environments: Oracle 10g, SQL Developer… Show more *Requirement Analysis and Development for optimizing SQL Check Scripts, PL/SQL blocks, Stored Procedures, functions, packages as per new requirements. *Enhancement & Maintenance of Credit Committee as per business needs *Data rectification in Database to have a better Data Integrity *MIS Reporting to OPERATIONS & ACCOUNTS departments. *Application Production Support to handle critical and Burning Issues this include on call support. Environments: Oracle 10g, SQL Developer, Toad, Crystal Reports, Windo Show less



RTA

• Developer

  • Jul 2009 - Jan 2010

  Dubai, United Arab Emirates *Developed optimize SQL Check Scripts, Database design/SQL blocks, Stored Procedures, functions, Packages for Geometry validation& DBQC. *Creating Triggers to restrict bulk updating of data, Spatial Indexing *Develop Logical & Physical Data Model for Schema Generation as per client specification. *Data Loading in Oracle Spatial Using Oracle shp2sdo, SQL Loader & Map Builder *Versioning of Spatial Data (Workspace Manager) Topology Model Creation, Topology *Editing, Network Data… Show more *Developed optimize SQL Check Scripts, Database design/SQL blocks, Stored Procedures, functions, Packages for Geometry validation& DBQC. *Creating Triggers to restrict bulk updating of data, Spatial Indexing *Develop Logical & Physical Data Model for Schema Generation as per client specification. *Data Loading in Oracle Spatial Using Oracle shp2sdo, SQL Loader & Map Builder *Versioning of Spatial Data (Workspace Manager) Topology Model Creation, Topology *Editing, Network Data Model Creation. *Create & Manage Historical Archive logs & Implement Log Miner Utility Show less



AND

• Developer

  • Jun 2007 - Jun 2009

  France *Create and manage schema objects like tables, Indexes, synonyms, sequences, views. *Developed optimized SQL Check Scripts, PL/SQL blocks, Stored Procedure, functions, Packages, Triggers for Database check as per Clients Specifications. *Spatial Data Loading, Indexing of Spatial Data & SRID Updating in Oracle Spatial *Create, manage, and use historical archives. *ASCII Data loading from external file & TIN Creation using DTM ASCII Data.