Developer
Tech Lead
Skills
ETL, Data warehouse, Informatica Power Center 8.X,9.0,9.5,9.6.1,10.2, DIH, IDQ, Metadata manager, Data warehouse / mart design principles, Big Data, HDFS, Kafka, Database, Oracle, SQL / PL-SQL, SQL Server, Teradata, Very, BRIO, BRIO Intelligence Server, Hyperion, Cognos, BO, Crystal Reports, Windows NT 4.0/95/98/2000, Linux, Unix, Java, VB, C++, VC++, Perl, Linux Scripting, Data Integration, CRM, Informatica MDM, SAP R3, Salesforce, Data analytics, DB, SFDC, SAP BW, Web service, EDW, XML, Data Quality, SAP, Azure DWH, MDM - Customer, metadata, Master Data management, DWH, analytics, Cloud based integration, Informatica, SAP R/3, Legacy systems, Internet Protocol (IP), modem, PWC, Brio 6.6.4, Hyperion 8.3 suite, Oracle 9i, Siebel, Control-M, information storage, computing platform, Oracle Apps, ETL tool, Salesforce- Oracle
Project history
09/2021
-
09/2021
Tech Lead
Solution
Architect
ETL consultant
Solution
Architect
ETL consultant
09/2021
-
09/2021
Developer
PHILIPS LTD
Work Experience Details
Solution Architect
PHILIPS LTD
Tools Base : Informatica PWC, Informatica Data Quality , Data Integration Hub
Functional Area : Health Care , Lighting ( Date Warehouse and Integration Landscape)
As Solution architect I was responsible in designing end-to-end integration / Data
warehouse solution for various platform
Involving application such SFDC, SAP R3, SAP BW. Experienced in designing solution for
the flowing integration patterns as well,
8) Web service based integration
9) Integrating various source systems with EDW
10) Database based integration ( ORACLE , TERADATA , SQL server)
11) XML, Flat file based integration
12) Message based integration
13) Data Quality using IDQ ( address doctor ) for Master Data management
14) Real time integration between SAP and Azure DWH using Kafka connector ( using
Event Hub )
Designed solution for Customer, Product Master Data integration through Informatica DIH
also involved in profiling Master data from source through Informatica Data quality.
Setting up the Integration platform which involves Infrastructure setup, Installation of
PWC, DIH, IDQ , Metadata Manager
Role and Responsibilities:
* Solution architect for all the Informatica projects.
* Installed and setup the informatica platform.
* Responsible in designing the DWH platform which serves as a platform for various
sales , service analytics
* Part of Philips architect community which is the authority board for platform
definition , tool selection , etc.,
* Designed Integration patterns for Cloud based integration (SFDC), web service based
Integration, and Application based integration.
* Responsible in developing Standards and Guidelines for Informatica platform
* Designed Integration solution for Master Data Management using Informatica DIH
* Responsible in setting up Informatica Metadata Manager in Philips for the first
time.
* Designed solutions to provision Informatica as service through web service hub.
Solution Architect
PHILIPS LTD
Tools Base : Informatica PWC, Informatica Data Quality , Data Integration Hub
Functional Area : Health Care , Lighting ( Date Warehouse and Integration Landscape)
As Solution architect I was responsible in designing end-to-end integration / Data
warehouse solution for various platform
Involving application such SFDC, SAP R3, SAP BW. Experienced in designing solution for
the flowing integration patterns as well,
8) Web service based integration
9) Integrating various source systems with EDW
10) Database based integration ( ORACLE , TERADATA , SQL server)
11) XML, Flat file based integration
12) Message based integration
13) Data Quality using IDQ ( address doctor ) for Master Data management
14) Real time integration between SAP and Azure DWH using Kafka connector ( using
Event Hub )
Designed solution for Customer, Product Master Data integration through Informatica DIH
also involved in profiling Master data from source through Informatica Data quality.
Setting up the Integration platform which involves Infrastructure setup, Installation of
PWC, DIH, IDQ , Metadata Manager
Role and Responsibilities:
* Solution architect for all the Informatica projects.
* Installed and setup the informatica platform.
* Responsible in designing the DWH platform which serves as a platform for various
sales , service analytics
* Part of Philips architect community which is the authority board for platform
definition , tool selection , etc.,
* Designed Integration patterns for Cloud based integration (SFDC), web service based
Integration, and Application based integration.
* Responsible in developing Standards and Guidelines for Informatica platform
* Designed Integration solution for Master Data Management using Informatica DIH
* Responsible in setting up Informatica Metadata Manager in Philips for the first
time.
* Designed solutions to provision Informatica as service through web service hub.
09/2021
-
09/2021
Tech Lead
HCL TECHNOLOGIES
HCL TECHNOLOGIES
Client: * EMC2 Corporation
Tools Base : Informatica PWC, Brio 6.6.4, Hyperion 8.3 suite, Brio Intelligence Server,
Oracle 9i, Siebel, Control-M (Date warehouse Landscape)
Functional Area : Sales, Finance, Project Accounting (Finance), and Commissions.
EMC Corporation is the world leader in products, services, and solutions for
information storage and its management. EMC is the information storage standard for every
major computing platform and, through its solutions, serves as caretaker for more than
two-thirds of the world's most essential information. NRT is a Reporting environment that
supports the business and plays a major role in Sales, Finance, Project Accounting, and
Commission. NRT project is supposed to load the Dimension, fact tables and generate
report out of them
Client: * EMC2 Corporation
Tools Base : Informatica PWC, Brio 6.6.4, Hyperion 8.3 suite, Brio Intelligence Server,
Oracle 9i, Siebel, Control-M (Date warehouse Landscape)
Functional Area : Sales, Finance, Project Accounting (Finance), and Commissions.
EMC Corporation is the world leader in products, services, and solutions for
information storage and its management. EMC is the information storage standard for every
major computing platform and, through its solutions, serves as caretaker for more than
two-thirds of the world's most essential information. NRT is a Reporting environment that
supports the business and plays a major role in Sales, Finance, Project Accounting, and
Commission. NRT project is supposed to load the Dimension, fact tables and generate
report out of them
09/2021
-
09/2021
Developer
SRM Software
SRM Software
Client :* White Bread
Tools Base : Oracle Report 6i, Oracle 9, Oracle Apps.
Functional Area : Supply chain management.
This project involves the Supply Chain Management and Service modeling that was
developed using Oracle Apps
Free Lance
As a consultant I am involved in various Data Integration / orchestration projects using
Informatica as ETL tool.
* CRM data integration involving Sales force and Informatica MDM
* Data integration between SAP R3 and Salesforce- Oracle as Integration Layer
* Code Migration from Informatica 9.0 to 10.2
* IICS Data integration between Real estate platform to EWD to support Data analytics
(Snowflake DB)
Client :* White Bread
Tools Base : Oracle Report 6i, Oracle 9, Oracle Apps.
Functional Area : Supply chain management.
This project involves the Supply Chain Management and Service modeling that was
developed using Oracle Apps
Free Lance
As a consultant I am involved in various Data Integration / orchestration projects using
Informatica as ETL tool.
* CRM data integration involving Sales force and Informatica MDM
* Data integration between SAP R3 and Salesforce- Oracle as Integration Layer
* Code Migration from Informatica 9.0 to 10.2
* IICS Data integration between Real estate platform to EWD to support Data analytics
(Snowflake DB)
01/2014
-
05/2019
Solution Architect
Philips Ltd Solution
As Solution architect I was responsible in designing end-to-end integration / Data warehouse
solution for various platform involving application such SFDC, SAP R3, SAP BW. Experienced in
designing solution for the flowing integration patterns as well,
1) Web service based integration
2) Integrating various source systems with EDW
3) Database based integration (ORACLE , TERADATA , SQL server)
4) XML, Flat file based integration
5) Message based integration
6) Data Quality and Profiling using IDQ
7) Real time integration between SAP and Azure DWH using Kafka ( using Event Hub )
Designed integration solution for MDM - Customer, Product Master Data integration through
Informatica DIH also involved in profiling Master data from source through Informatica Data quality.
solution for various platform involving application such SFDC, SAP R3, SAP BW. Experienced in
designing solution for the flowing integration patterns as well,
1) Web service based integration
2) Integrating various source systems with EDW
3) Database based integration (ORACLE , TERADATA , SQL server)
4) XML, Flat file based integration
5) Message based integration
6) Data Quality and Profiling using IDQ
7) Real time integration between SAP and Azure DWH using Kafka ( using Event Hub )
Designed integration solution for MDM - Customer, Product Master Data integration through
Informatica DIH also involved in profiling Master data from source through Informatica Data quality.
07/2013
-
12/2013
Solution Architect
Sony Software Ltd
Responsible in setting-up Informatica integration standards and involved in designing solution for
metadata manager that will be base for impact analysis.
metadata manager that will be base for impact analysis.
10/2006
-
07/2013
Architect
Wipro Technologies; Philips Ltd
As Architect I was involved in end-to-end ETL Integration, migration, data warehousing design
Philips Ltd: Health care - ETL Tech lead and Solution architect
Bank Of New York Mellon: Securities - ETL Tech lead and Solution architect
Level (3) Communication: Telecommunications - ETL Tech lead
As a Tech Lead I was involved in leading the data warehousing team: Design, development and support
EMC² Corporation: Sales, Finance mart - ETL Tech lead
Philips Ltd: Health care - ETL Tech lead and Solution architect
Bank Of New York Mellon: Securities - ETL Tech lead and Solution architect
Level (3) Communication: Telecommunications - ETL Tech lead
As a Tech Lead I was involved in leading the data warehousing team: Design, development and support
EMC² Corporation: Sales, Finance mart - ETL Tech lead
10/2004
-
10/2006
Tech Lead
HCL Technologies
08/2003
-
09/2004
Developer / Tech Lead
GAVS Technologies Ltd
As a Tech Lead I was involved in leading the data warehousing team: Design, development and support
StorageTek Information Services Ltd: Sales, Finance mart - Developer / ETL Tech lead
StorageTek Information Services Ltd: Sales, Finance mart - Developer / ETL Tech lead
Local Availability
Only available in these countries:
India
