My roles in the project is,

• Design, development and implementation of Pentaho PDI Jobs and Transformations
• Developed ETL to populate the raw data, populate staging tables and store the refined data in partitioned tables in the EDW

My roles in this project is,

• Development and implementation of Pentaho PDI Jobs and Transformations

• Extracting data having different extension txt,csv ,xls and EDI files and load data into single destination system
• Developed ETL to populate the raw data, populate staging tables and store the refined data in partitioned tables in the EDW
• Populate EDW data into reporting tables

• Developed and modified Oracle and SQL Server Stored Procedures to load the data.

• where the data for each client is stored in separate databases with the Client name used as the tenant-id are clubbed into one single database with newly generated ID for each tenant names

My role in the project is,

• Design, development and implementation of Pentaho PDI Jobs and Transformations
• Developed ETL to populate the raw data, populate staging tables and store the refined data in partitioned tables in the EDW
• Populate EDW data into reporting tables
• Multi Tenancy Module Development.
• LDAP integration with Pentaho.
• MongoDB data Integration to DWH data.
• Developed Infobright StoredProcedures to load the data and other stored procedures are used in dashboards and ETL.
• where the data for each client is stored in separate databases with the Client name used as the tenant-id are clubbed into one single database with newly generated ID for each tenant names

My roles in the project is,

• Design, development and implementation of Pentaho PDI Jobs and Transformations
• Developed ETL to populate the raw data, populate staging tables and store the refined data in partitioned tables in the EDW

To implement BI stack such as reporting, CDE dashboards and Analyzer Reports using Pentaho Suite, create a data mart to pull in data from various sources for the reporting and dashboard needs.

Developed an new functionality called overseas purchasing in retail net for Grace Kendy( Customer ) . This development has been completed By using Oracle,PLSQL& D2k ( Forms 9i ) . Retail net product modification / enhancement has been done in other areas like PURCHASING, RECIVING, PRICING & PROMOTIONS etc.

Interact with business people to understand the functionality and generate different documents ( HL and LL ) as per the standard. I have involved in DWH schema design, DATA flow of ETL, over all Functional and technical flow design. Prepare check list for the development and maintained the same till end (deployment). Make sure developers are following the standard and using tuning tool to optimize the code both SQL and PLSQL ( TOAD / Plsql Developer ). Schedule daily stand-up meeting with my team members and submit reports weekly bases to my manger. Attend Project status meeting weekly base with different department mangers ( QA& DEV ) and business team. We followed AGILE methodology while developing the module.

Pictela is a global platform for distributing high definition brand content. They have web analytics feature in their product which does analysis on user impressions on the websites. They are dealing with huge amount of data as data gets generated from web logs. They use cloud infrastructure for the computation of ETL processes. Graymatter empowered them to deal with huge amount of data which ranges more than billion data per day. We redesigned and architected the ETL processes in order to achieve above figures and migrated their backend database from mysql to Infobright.