Data Informatica

Sreenivas Kuntala

********@*****.*** +44-795******* (Mobile)

PROFESSIONAL SUMMARY:

Over 18 years IT experience in the Analysis, Design, Development and Implementation of Business Intelligence, Data Migration, Data Governance, Data Quality, Master Data Management, Metadata Management and Data Warehouse solutions.

Proficient in working with Business and Technical stakeholders in Design, Delivery and Governance of end-to-end solutions from inception through successful completion.

Strong knowledge in implementing the Master Data Management, Data Quality and Metadata Management solutions using Informatica Products.

Well versed with the Data Migration activities between Database to Database and Heterogeneous sources to Database and Cloud Application Salesforce.

Strong Data Warehousing & Business Intelligence concepts in designing and implementing the dimensional Star Schema and Snowflakes Schema methodologies.

Worked as Team Lead for Center of Excellence team in defining the Architecture, Design, Solution and documenting the best practices / integration strategy using the Informatica.

Proficient in integrating the data from source Relational Database, ERP, CRM and Legacy systems. Worked actively in defining the data deliverable standards, definitions, data mapping, automated frameworks for Development and Testing.

Advanced TERADATA certified professional

TECHNICAL SKILLS

Technical Experience Summary Table

Group Software Tools/Technologies

ETL Informatica PowerCenter, Informatica Cloud, Power Exchange, IDQ, MDM

OLAP Tools Business objects, Cognos

ERP/CRM SAP, SIEBEL, Oracle EBS, Salesforce CRM

Data Modeling Tools Erwin, Sybase Power Designer

Database Oracle, Teradata, SQL Server, DB2, Sybase, HBase, OrientDB

Languages SAS, SQL, PL/SQL, XML, Perl, Python

Development/Productivity Tools SVN, TOAD, PerForce

PROFESSIONAL EXPERIENCE:

Client

Designation

Duration

Micro Focus

Informatica/Data Specialist

June 2020 - Current

Responsibilities:

-Install, configure and administer the Informatica product suite which comprise of PowerCenter, IDQ, MDM, EDC, AXON and Operational Insights

-Work with vendor team on Solution Design to make sure it align with the Functional requirements

-Participate in building the Data Migration and Data Integration activities

-Design, configure and execute the Disaster Recovery procedures

-Support the testing to resolve the performance blockages

-Work with Data Governance team to configure and implement the Lineage solutions using EDC & AXON

-Perform EDC upgrade from 10.4 to 10.4.1

-Install Axon 7.0, upgrade content from Axon 6.3 to 7.0

Client

Designation

Duration

SAP (formerly Callidus Cloud)

Technical Consultant

May 2017 – June 2020

Responsibilities:

-Currently working with SAP (aka Callidus Cloud) using Callidus Products and Informatica Cloud as ETL for Data Migration and Integration

-Work with Business Analyst to understand the requirements and perform the data analysis

-Install, Configure and implement Data Governance solution using Informatica EDC & Axon for SAP client

-Configure EDC Resources to scan and establish the lineage from the systems using EDC

-Design and implement solution using IDQ for Data Quality and deduplication issues

-Migrate the data using Informatica from Source to target application system

-Implement the solution of Callidus Products on Microsoft Azure

-Data Ingestion, Migration and Cloud Warehouse implementation using SnowFlake

Client

Designation

Duration

CAPITA, UK

Senior Consultant

Nov 2016 – Feb 2017 (Contract)

Direct Line Group, UK

Senior Consultant

Apr 2016 – Oct 2016 (Contract)

Bank of America Merry Lynch, UK

Senior Consultant

Oct 2015 – Apr 2016 (Contract)

Morgan Stanley, UK

Senior ETL/MDM Architect

May 2015 – Oct 2015 (Contract)

Responsibilities:

-Work with Business Stake holders and Technical stake holders to understand the requirements

-Conduct/Participate workshops to evaluate Data Model validation and identifying the Target Architecture

-Architect, Design solutions for Data Migration, Data Warehouse, Data Integration and Master Data Management and Metadata Management

-Define and implement the Data Governance solution for Regulatory Reporting

-Assist the Infrastructure team to install and configure the MDM solution using Informatica

-Hands on development using Informatica and Database applications to implement the solutions for Data Migration, Data Integration for Applications and Data Warehouse

-Migration and Integration of data between Salesforce, Guidewire and Data Warehouse using Informatica

-Customized and implemented the Data Warehouse using the Teradata FSLDM for Direct Line Group

-Participate in understand the issues and identifying the solution for Bank of America data integration solution using the Big Data & Informatica Technologies

-Worked on POC to replace the existing solution with Big Data & Informatica BDM

Environment: Informatica PowerCenter 9.6.1, Infomratica Cloud, IDQ 9.6.1, Informatica BDM, MDM 9.7.1, Cloudera, HDFS, Unix, XML, Oracle, Teradata, SQL Server, JIRA, Salesforce, Guidewire, ERWIN, Perforce, Jenkins

Client

Designation

Duration

Cancer Research, UK

Senior Consultant

Oct 2014 – Apr 2015 (Contract)

Responsibilities:

-Perform gap analysis, data analysis to migrate the data from legacy/redundant systems to SIEBEL

-Document the Data Dictionary, Data mapping and Target Architecture solution

-Design, Develop and Deploy the Data Migration and Data Integration to Data Warehouse

-Create/Update documentation for Best Practices, How-To objects and Security guidelines

-Create reusable objects, framework to promote re-usability across teams

Environment: Informatica PowerCenter, IDQ 9.6.1, Siebel, Unix, XML, Oracle, SQL Server, JIRA

Client

Designation

Duration

HSBC, UK

IDQ/Data Architect

Oct 2013 – Oct 2014 (Contract)

Admin Re, UK (Swiss Re)

ETL Consultant

Jul 2012 – Sep 2013 (Contract)

Friends Life, UK (AXS Sun Life)

Functional Lead

Dec 2010 – Jul 2012 (Contract)

Responsibilities:

-Understand the requirements for Customer Due Diligence, KYC, Entity Reference Data and FATCA regulatory programs

-Implemented Data Integration solution using the Informatica Cloud for HSBC due to the regulatory restrictions on using the on premise PowerCenter application

-Analyze and Design solution for legacy system migration to Oracle EBS

-Design and implement Data Warehouse for Financial, Actuarial Reporting and Solvency II Reporting

-Design, Develop and Implement Data Integration, Data Quality solution

-Define and document the Data Model, Metadata and implement the framework for Migration Control

-Implemented Data Lineage solution using Metadata Manager

-Built framework to automate the deployment process and automated framework for Integration Testing

-Assist projects with Data Integration Design, Architecture and performance reviews

Environment: Informatica Cloud, IDQ 9.5.1/9.6.x, Unix, XML, Oracle, Teradata, IBM RTC, Control-M, JIRA, SVN, Oracle EBS, SVN, Kalido, Cognos

Client / Employer

Designation

Duration

Vodafone, UK

ETL Integration Consultant

Jun 2010 – Dec 2010 (Contract)

ING Direct, UK

ETL Consultant

Jan 2010 – May 2010 (Contract)

Network Rail, UK

Data Warehouse Analyst

Dec 2008 – Jan 2010 (Permanent)

Responsibilities:

-Define ETL Architecture to integrate with SAP and external applications

-Develop Informatica objects to read and load the source data external data to SAP system in IDoc format

-Analyzing and design Data Warehouse using Teradata to integrate European countries data together

-Develop and implement ETL solution using Informatica to load the data to Teradata Warehouse

-Define dimensional model and implement Data Warehouse and Data Marts using Oracle Database

-Migrate the ETL solution from OWB to Informatica

-Reporting solution using Business Objects and Cognos

-Implement the Data Quality solution using IDQ

Environment: Informatica PowerCenter 8.6.1, WebSphere MQ, Informaitca IDQ, XML, SAP, Teradata v12, Oracle 11g, SQL Server, Unix, Business Objects, Cognos

Client / Employer

Designation

Duration

TERADATA Corporation

Technical Consultant

Sep 2007 – Sep 2008

Project. Frontier Communications, USA

Project. Benchmarking (Center of Excellence) for TERADATA Inc.

Responsibilities:

-Define and Architecture and best practice solutions using the Informatica to migrate data from Relational, ERP, CRM and Legacy systems to Teradata Database

-Define the solution with Informatica PowerCenter and Teradata Utilities

-Migration data from legacy acquired business system to target Teradata Data Warehouse

-Design and integrate EAI applications using Informatica Advanced option to load real time data

-Extensively worked with Teradata utilities to build the data migration/transform methodologies

-Investigate and resolve the performance issues with existing Production environment and providing the solutions to reduce the maintenance

-Work as part of the CoE team in identifying the best practices and solutions and participate in RFP

Environment: Informatica PowerCenter 8.6, Informatica Power Exchange 8.6, SQL Server, Oracle 10g, Sybase, TIBCO, Teradata 12, SQL, PL/SQL, Linux, Solaris

Client

Designation

Duration

Saama Technologies, India

Senior Consultant

Feb 2007 – Jul 2007

Responsibilities:

-Designing and implement Data Marts and Data warehouse

-Involved in the analysis, design and development of interface using Informatica Power Center

-Design, Develop and implement real time load solution using Informatica Advanced options

-Design and deploy the Universe for Business Objects users, developed reports

-Worked with Center of Excellence team in testing the Informatica Beta releases

Environment: Informatica PowerCenter 7.1.3 / 8.1.1, Erwin 4.1, TIBCO, Business Objects 6.5/XI, Oracle 9i/10g, SQL Server, SQL, PL/SQL, XML, TOAD, Windows XP, Solaris 10

Client

Designation

Duration

Warner Brothers, UK

ETL Developer

Jun 2006 – Jan 2007

BT Global Services, UK

ETL Developer

Apr 2005 – Jun 2006

HDB, Singapore

Systems Analyst

Mar 2004 – Mar 2005

Responsibilities:

-Analyze, design and development of all the interface’s to SIEBEL and SAP systems using Informatica

-Designing and implementing the Data Marts and Data warehouse

-Developed and implemented Informatica objects to transform and load data to Data warehouse

-Designed and implemented the Metadata Reports using the Informatica Power Analyzer/Metadata Manager

-Install and configure the PowerExchange Change Data Capture

-Designed and deployed the Universe for Business Objects users, developed reports

-Documenting and managing releases after each stage of the testing and defect removal

Environment:

Informatica PowerCenter 7.1.3 / 8.1.1, Erwin 4.1, Business Objects 6.5/XI, Oracle 9i/10g, SQL Server, PL/SQL, XML, Perl, TOAD, Windows XP, Solaris 10, SIEBEL, SAP R/3

Client

Designation

Duration

GCP Inc, India

Developer / Senior Develper

Aug 1999 – Feb 2004

Project : Singapore Telecom, Singapore Senior Consultant

Project: DBS Bank, Singapore Consultant

Responsibilities:

-Involved in business analysis and technical design to develop and document ETL specifications

-Developed Informatica PowerCenter 6.1 to transform data from source systems to Data Warehouse

-Data migration included identifying various databases where the information understanding the complex business rules that need to be implemented and planning the data transformation methodology

-Worked with Business Objects to generate reports for the Management and Business Users

Environment:

Informatica PowerCenter 6.1, Oracle 8i, SQL, PL/SQL, ERwin 4.0, Business Objects 5.1, SAS, Windows 2000, Solaris

Contact this candidate