Krishnan Kannan

Capital One Bank is specialized in Credit Cards,Auto Loans, Banking and Saving Accounts.

Responsibilities:

• Understanding the business rules and sourcing the data from multiple source systems using Informatica Powercenter.
• Designing and customizing data models for Data warehouse supporting data from multiple sources.
• Implemented Type1, Type2, CDC and Incremental load strategies.
• Extracted data from flat files, Excel files and transformed the data based on user requirement using Informatica Power Center.
• Performed analysis on quality of source data to determine accuracy of information being reported.
• Debugging the mappings and used session log files to trace errors that occur while loading.
• Performance tuning by optimizing the mappings and sessions.
• Performed Unit Testing and tuned for better performance.
• Worked closely with DBAs, admins, ETL developers and change control management team for migrating developed mappings across Dev, QA, and PROD environments.
• Provide support for deployment activities and production support activities.
• Environment: Informatica Power Center 10.4/Oracle /Exadata/SQL Server/MongoDB

Synchrony . provides financing, Credit cards, paylater, retail,auto, travel

Responsibilities

• Designed and built Powercenter mappings to extract data from SFDC, Oracle, SQL Server and loaded into Oracle/Designed the ETL flows for generating flat file extracts as per the business need.
• Worked on converting Informatica PowerCenter ETL code to IICS using PC to Cloud Conversion service.
• Involved in enhancements and maintenance activities of the data warehouse.
• Implemented Type1, Type2 and Incremental load strategies in IICS.
• Handled configuration activities like setup run time environment and create connections,schedules,tasks,mappings,mapplets and components.
• Designed Mappings, Integration Templates, Bundles and Task flows.
• Used various transformations to extract data from different formatted files and relational source system.
• Developed and tested Informatica mappings based on the specification.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes, and functions; implement best practices to maintain optimal performance. Developed/Automated (PowerCenter/IICS) jobs through Automic.
• Environment: IICS, Informatica Power Center 10.4/10.2, SalesForce, Oracle, SQL Server,GitHub.

CNO FINANCIAL GROUP provides life and health insurance, annuities, financial services

Responsibilities

• Involved in Requirement gathering, analysis, design and development of the project.
• Worked on design and development of Informatica PowerCenter mappings, workflows to load data from multiple sources into staging area, data warehouse and data marts in SQL Server and Oracle on real time.
• Extensively used Informatica Power Center,IICS to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Used Change Data Capture (CDC) to capture changes in multiple environments and deliver the most accurate data to the business in data warehouse applications.
• Worked on Migrating Informatica PowerCenter code to IICS.
• Experience integrating data using IICS for reporting needs.
• Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of application quality was maintained at all times.
• Providing architecture review for proposed projects and enhancements to aid the governance process in decision making.
• Worked with Repository DB to find the deviations from Company's ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Integrated Data Quality routines in the Informatica mappings to standardize and cleanse the data.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Designed and developed UNIX scripts for scheduling the jobs using PMCMD.
• Involved in providing Technical support to the team members, as well as, the Business.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Successfully Implemented Slowly Changing Dimensions.
• Successfully Integrated Multiple XML sources and created a de-normalized, flat-structured file
• Involved in writing SQL Stored Procedures, Functions, Triggers and Views for Oracle database
• Ensure that all support requests are properly approved, documented, and communicated using Team Foundation Server(TFS).
• Worked with project managers, developers, quality assurance and customers to resolve technical issues.
• Estimated work hours and tracked progress using Agile methodology.
• Reviewed ETL code and worked with development teams to correct problems, run test scenarios and prepare for deployment.
• Met with stakeholders, contractor product teams and customers throughout system development life cycle.
• Delivered and sign-off of deliverables pertaining to the Transactional Data warehouse.
• Tested troubleshooting methods, devised innovative solutions, and documented resolutions for inclusion in knowledge base for support team use.
• Environment: Informatica Power Center 10.2/10.1/9.6/9.1/8.6.1, ,IICS, Informatica Power Exchange 10.2/9.6/9.1/8.6.1, Informatica Data Quality 8.6.1,Google BigQuery, Admin Console, Oracle 12c/11g/10g, SQL Server 2005 ,PL/SQL, UNIX, WindowsNT4.0, Tableau, Power BI,GIT, Team Foundation Server TFS.

Travelers insurance Travelers takes on the risk and provides the coverage need to protect the things that are important home, car

Responsibilities

• Extensively involved in gathering business requirements and translating them into technical requirements.
• Used Informatica PowerCenter & IICS to extract the data from Mainframe.
• Responsible in strictly maintaining naming standards and warehouse standards for future development.
• Coordination and Leading the offshore in development activities.
• Extracted data from various sources such as Flat Files, Mainframe , SAP and Oracle using Informatica Cloud.
• Designed and Developed Stored Procedures in DB2.
• Achieved performance improvement by tuning SQL queries, extraction procedures between Oracle/DB2 and Power Center.
• Offered 24/7 production support for the application on a time-time basis.
• Developed complex Power Center mappings by using different transformations and components respectively to meet the data integration and data quality requirements.
• Created and monitored workflows/sessions using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
• Performed Unit testing, Integration Testing, and User Acceptance testing to pro-actively identify data discrepancies and inaccuracies.
• Involved in performance tuning at source, target, mapping and session level.
• Prepared design documents, ETL Specifications and migration documents
• Maintained daily Tech Tracker for the updates from the team regarding their objects, issues and progress
• Involved in Informatica Power Center 8.1.1 Repository upgrade to Informatica Power center 8.6.1
• Involved in providing Informatica Technical support to the team members, as well as, the business
• Environment Ab Initio,Informatica Power Center 8.1.1/8.6.1, Teradata, Oracle.

Honeywell Homes/Resideo offers top-of-the-line home automation solutions to set up your best smart home system, including smart thermostats, security cameras

Responsibilities

• Involved in Requirement gathering, analysis, design and development of the project.
• Worked on design and development of Informatica PowerCenter mappings, workflows to load data from multiple sources into staging area, data warehouse and data marts in SQL Server and Oracle on real time.
• Extensively used Informatica Power Center,IICS to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Used Change Data Capture (CDC) to capture changes in multiple environments and deliver the most accurate data to the business in data warehouse applications.
• Worked on Migrating Informatica PowerCenter code to IICS.
• Experience integrating data using IICS for reporting needs.
• Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of application quality was maintained at all times.
• Providing architecture review for proposed projects and enhancements to aid the governance process in decision making.
• Worked with Repository DB to find the deviations from Company's ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Integrated Data Quality routines in the Informatica mappings to standardize and cleanse the data.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Designed and developed UNIX scripts for scheduling the jobs using PMCMD.
• Involved in providing Technical support to the team members, as well as, the Business.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Successfully Implemented Slowly Changing Dimensions.
• Successfully Integrated Multiple XML sources and created a de-normalized, flat-structured file
• Involved in writing SQL Stored Procedures, Functions, Triggers and Views for Oracle database
• Ensure that all support requests are properly approved, documented, and communicated using Team Foundation Server(TFS).
• Worked with project managers, developers, quality assurance and customers to resolve technical issues.
• Estimated work hours and tracked progress using Agile methodology.
• Reviewed ETL code and worked with development teams to correct problems, run test scenarios and prepare for deployment.
• Met with stakeholders, contractor product teams and customers throughout system development life cycle.
• Delivered and sign-off of deliverables pertaining to the Transactional Data warehouse.
• Tested troubleshooting methods, devised innovative solutions, and documented resolutions for inclusion in knowledge base for support team use.
• Environment: Informatica Power Center 10.2/10.1/9.6/9.1/8.6.1, ,IICS, Informatica Power Exchange 10.2/9.6/9.1/8.6.1, Informatica Data Quality 8.6.1,Google BigQuery, Admin Console, Snowflake,Salesforce,Oracle 12c/11g/10g, SQL Server 2005 ,PL/SQL, UNIX, WindowsNT4.0, Tableau, Power BI,GIT, Team Foundation Server TFS.

Honeywell Homes/Resideo offers top-of-the-line home automation solutions to set up your best smart home system, including smart thermostats, security cameras

Responsibilities

• Involved in Requirement gathering, analysis, design and development of the project.
• Worked on design and development of Informatica PowerCenter mappings, workflows to load data from multiple sources into staging area, data warehouse and data marts in SQL Server and Oracle on real time.
• Extensively used Informatica Power Center,IICS to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Used Change Data Capture (CDC) to capture changes in multiple environments and deliver the most accurate data to the business in data warehouse applications.
• Worked on Migrating Informatica PowerCenter code to IICS.
• Experience integrating data using IICS for reporting needs.
• Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of application quality was maintained at all times.
• Providing architecture review for proposed projects and enhancements to aid the governance process in decision making.
• Worked with Repository DB to find the deviations from Company's ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Integrated Data Quality routines in the Informatica mappings to standardize and cleanse the data.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Designed and developed UNIX scripts for scheduling the jobs using PMCMD.
• Involved in providing Technical support to the team members, as well as, the Business.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Successfully Implemented Slowly Changing Dimensions.
• Successfully Integrated Multiple XML sources and created a de-normalized, flat-structured file
• Involved in writing SQL Stored Procedures, Functions, Triggers and Views for Oracle database
• Ensure that all support requests are properly approved, documented, and communicated using Team Foundation Server(TFS).
• Worked with project managers, developers, quality assurance and customers to resolve technical issues.
• Estimated work hours and tracked progress using Agile methodology.
• Reviewed ETL code and worked with development teams to correct problems, run test scenarios and prepare for deployment.
• Met with stakeholders, contractor product teams and customers throughout system development life cycle.
• Delivered and sign-off of deliverables pertaining to the Transactional Data warehouse.
• Tested troubleshooting methods, devised innovative solutions, and documented resolutions for inclusion in knowledge base for support team use.
• Environment: Informatica Power Center 10.2/10.1/9.6/9.1/8.6.1, ,IICS, Informatica Power Exchange 10.2/9.6/9.1/8.6.1, Informatica Data Quality 8.6.1,Google BigQuery, Admin Console, Snowflake,Salesforce,Oracle 12c/11g/10g, SQL Server 2005 ,PL/SQL, UNIX, WindowsNT4.0, Tableau, Power BI,GIT, Team Foundation Server TFS.

Dun and Bradstreet provides business intelligence and analytics through proprietary software and a global network.

Responsibilities

• Involved in Requirement gathering, analysis, design and development of the project.
• Worked on design and development of Informatica PowerCenter mappings, workflows to load data from multiple sources into staging area, data warehouse and data marts in SQL Server and Oracle on real time.
• Extensively used Informatica Power Center,IICS to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Used Change Data Capture (CDC) to capture changes in multiple environments and deliver the most accurate data to the business in data warehouse applications.
• Worked on Migrating Informatica PowerCenter code to IICS.
• Experience integrating data using IICS for reporting needs.
• Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of application quality was maintained at all times.
• Providing architecture review for proposed projects and enhancements to aid the governance process in decision making.
• Worked with Repository DB to find the deviations from Company's ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Integrated Data Quality routines in the Informatica mappings to standardize and cleanse the data.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Designed and developed UNIX scripts for scheduling the jobs using PMCMD.
• Involved in providing Technical support to the team members, as well as, the Business.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Successfully Implemented Slowly Changing Dimensions.
• Successfully Integrated Multiple XML sources and created a de-normalized, flat-structured file
• Involved in writing SQL Stored Procedures, Functions, Triggers and Views for Oracle database
• Ensure that all support requests are properly approved, documented, and communicated using Team Foundation Server(TFS).
• Worked with project managers, developers, quality assurance and customers to resolve technical issues.
• Estimated work hours and tracked progress using Agile methodology.
• Reviewed ETL code and worked with development teams to correct problems, run test scenarios and prepare for deployment.
• Met with stakeholders, contractor product teams and customers throughout system development life cycle.
• Delivered and sign-off of deliverables pertaining to the Transactional Data warehouse.
• Tested troubleshooting methods, devised innovative solutions, and documented resolutions for inclusion in knowledge base for support team use.
• Environment: Informatica Power Center 10.2/10.1/9.6/9.1/8.6.1, ,IICS, Informatica Power Exchange 10.2/9.6/9.1/8.6.1, Informatica Data Quality 8.6.1,Google BigQuery, Admin Console, Snowflake,Salesforce,Oracle 12c/11g/10g, SQL Server 2005 ,PL/SQL, UNIX, WindowsNT4.0, Tableau, Power BI,GIT, Team Foundation Server TFS.

Sigma Aldrich provides organic and inorganic chemicals, building blocks, reagents, advanced materials and stable isotopes for chemical synthesis, medicinal chemistry and materials science.

Responsibilities

• Involved in Requirement gathering, analysis, design and development of the project.
• Worked on design and development of Informatica PowerCenter mappings, workflows to load data from multiple sources into staging area, data warehouse and data marts in SQL Server and Oracle on real time.
• Extensively used Informatica Power Center,IICS to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Used Change Data Capture (CDC) to capture changes in multiple environments and deliver the most accurate data to the business in data warehouse applications.
• Worked on Migrating Informatica PowerCenter code to IICS.
• Experience integrating data using IICS for reporting needs.
• Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of application quality was maintained at all times.
• Providing architecture review for proposed projects and enhancements to aid the governance process in decision making.
• Worked with Repository DB to find the deviations from Company's ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Integrated Data Quality routines in the Informatica mappings to standardize and cleanse the data.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Designed and developed UNIX scripts for scheduling the jobs using PMCMD.
• Involved in providing Technical support to the team members, as well as, the Business.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Successfully Implemented Slowly Changing Dimensions.
• Successfully Integrated Multiple XML sources and created a de-normalized, flat-structured file
• Involved in writing SQL Stored Procedures, Functions, Triggers and Views for Oracle database
• Ensure that all support requests are properly approved, documented, and communicated using Team Foundation Server(TFS).
• Worked with project managers, developers, quality assurance and customers to resolve technical issues.
• Estimated work hours and tracked progress using Agile methodology.
• Reviewed ETL code and worked with development teams to correct problems, run test scenarios and prepare for deployment.
• Met with stakeholders, contractor product teams and customers throughout system development life cycle.
• Delivered and sign-off of deliverables pertaining to the Transactional Data warehouse.
• Tested troubleshooting methods, devised innovative solutions, and documented resolutions for inclusion in knowledge base for support team use.
• Environment: Informatica Power Center 10.2/10.1/9.6/9.1/8.6.1, ,IICS, Informatica Power Exchange 10.2/9.6/9.1/8.6.1, Informatica Data Quality 8.6.1,Google BigQuery, Admin Console, Snowflake,Salesforce,Oracle 12c/11g/10g, SQL Server 2005 ,PL/SQL, UNIX, WindowsNT4.0, Tableau, Power BI,GIT, AWS,Redshift