Mathuram Christhudoss
Program Manager
Chennai
Summary
Self-motivated Senior Architect with 17 years of experience in warehouse data management. Collaborates effectively with multi-functional roles to identify and leverage areas for improvement in data systems. Bringing comprehensive understanding of warehouse operations and documentation needs.
Multiple years of core experience in Talend(ETL),Talend(MDM),Talend(ESB), Talend Data Catalog, Talend Data Preparation, Talend Data Stewardship, Talend Data Quality, Talend Data Inventory, Unix, Shell Scripting, Perl, Python, Oracle, Snowflake, Redshift, AWS, MS Azure, Azure Data Factory and Autosys.
Talend CoE lead who involved in creating reusable Assets, Frameworks, RFP contribution to various new business proposals etc..,
Eager to learn new technologies like Gen AI and methodologies to continuously upskill to self and motivate team members to do the same. Involved in Application development, Data Warehousing, Business Intelligence and Data migration projects.
Created the Multi-Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements due to various corporate groups accessing the data.
Created the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation. Interacted with the business users on regular basis to consolidate and analyze the requirements and present them the design results. Evaluated DB2 data model and formulated migration plan for ongoing data warehouse development/Migration(DB2 to MySql). Established Data Management, Governance, and Metadata processes/standards. Working experience in continuous integration/Version control environment using SVN, CVS and Star Team.
Excellent Communication and Project Coordination Skills. Created Data visualization reports using Tableau Business intelligence software. Adaptable and methodical.
Expertise in gathering client requests and considering specified needs in devising innovative and world-class designs. Efficient and insightful in driving full-cycle projects to accomplish client delight.
Overview
17
17
years of professional experience
7
7
years of post-secondary education
Work History
Senior Architect
Capgemini Technology services India Limited
Chennai
2 2021 - Current
- As Senior Architect for Capgemini. At Capgemini, assisting Bayer in their transformation from pharmaceutical company to life science company. This transformation entails rebuilding numerous applications in modern technologies and migrating data centers from on-premise to cloud.
My work is focused on Master Material, which encompasses sales of seeds, crops, and logistics of goods. In this MM4B landscape, Users utilize Stibo STEP system to generate requests in XML format based on business rules and validation. These XMLs are then transmitted to Talend through REST API calls.
Talend ESB routes download those files, perform validation and transformation, and forward them to SAP via BAPI calls. SAP provides response to Talend, which then relays it back to STEP in agreed-upon format. Talend ESB jobs are synchronized through AMQ.BAYER is transforming to life science company from pharmaceutical as part of transformation many of its applications are rebuilding in new age technologies and data centers are moving to Cloud from On-Prem
ETL Architect
L & T Infotech
Chennai
01.2013 - 02.2021
- There are 10000+ Datastage ETL jobs has been converted into Talend ETL jobs in phased manner with help of Blade Bridge automation converting tool
- Jobs get converted into 60% accuracy remaining gap will be done as manual development and testing
- There are various applications and it is spreaded in many layers of ETL
- Source data is generated as parquet file format from various data sources and it will be placed in AWS S3 bucket
- On top of S3 files external tables created using crawler and consumed by Talend ETL jobs through Autosys scheduler
- After various validation, enrichment and transformation data will be loaded into Redshift database.
- Designed and implemented scalable ETL solutions for efficient data extraction, transformation, and loading across various platforms
- Maintained a high level of security within the ETL environment by implementing necessary access controls and performing regular audits to detect potential vulnerabilities
- Created detailed documentation outlining design specifications for each stage of the ETL process, enhancing knowledge sharing among team members
Project Leader
Infinite Computer Solutions
Chennai
06.2012 - 01.2013
- This project is migration of 30 year old legacy SD Løn application data migration
- SD Løn is payroll product used by EG group to calculate payroll end to end solutions to the major municipalities and government organizations across Denmark
- Legacy system is migrated to new environment from mainframe and new UI, database is introduced for migration
- As part of this data need to move from DB2 to new database MySQL
- Using Talend ETL tool data migration has been done phase by phase
- All development, testing and monitoring has been performed automatically using Talend tool.
- Enhanced overall team performance by providing regular coaching, feedback, and skill development opportunities.
- Managed scope changes effectively, minimizing potential disruptions to timelines or budgets while still meeting client expectations.
- Established strong relationships with clients, fostering trust and open communication throughout the entire project lifecycle.
- Conducted thorough post-project evaluations to identify areas for future improvement in both processes and performance metrics.
Team Leader
FIS Global
Chennai
04.2011 - 05.2012
- Client have their data in various sources like Databases, Files and websites
- This data need to moved to cloud data warehouse which is designed in snowflake
- By the way of moving data all ETL process need to be done
- Data profiling, cleaning, validation, transformation and loading
- All the data loaded from multiple sources with legacy data structures has to be moved to new data warehouse
- Facing some challenges like large volume of data and large number of columns in single table handling through various techniques and solutions in ETL using Talend tool
- Also started using Talend MDM for data modeling and onboarding of new customers, roles, accessibility etc., Also used ESB for integration with different applications in different environment.
- Monitored team performance and provided constructive feedback to increase productivity and maintain quality standards.
- Worked with team to identify areas of improvement and devised solutions based on findings.
- Enhanced team productivity by implementing efficient work processes and regularly reviewing performance metrics
ETL Architect
Aequor
Chennai
07.2010 - 03.2011
- This project is migration of 30 year old legacy DOGS application migration
- DOGS is system used by CITI as settlement back office system
- It will maintain end to end information of trade starting from trade booking, enrichment, settlement etc., Application called REFER is performing functionality of DOGS called Feed and Report generation(ETL & Reporting)
- This is pure development project starting from scratch.
- Talend is used to implement to create ETL jobs for data orchestration.
ETL Developer
OFS
Chennai
09.2009 - 06.2010
- This project is CITI internal application used to create workflow of particular process and its validation
- Basically this project has two parts front end is designed in BPM and validation will be done in Talend jobs.
- Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
- Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users.
- Increased data accuracy by implementing thorough validation checks and error-handling mechanisms
- Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users
- Reduced processing time for ETL tasks through implementation of parallel execution strategies
ETL Developer
Photon InfoTech
Chennai
11.2007 - 02.2009
- This project is data migration which will extracts data from various sources like file system, database and load into destination database.
- Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users.
- Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
- Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
- Increased data accuracy by implementing thorough validation checks and error-handling mechanisms
- Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users
Education
BE(Electronics &comm.) - Electrical, Electronics And Communications Engineering
P.S.R Engineering College, Sivakasi, (Anna University, Chennai)
Sivakasi,India 01.2001 - 04.2005
H.S.C - School
Government Hr. Sec School, Thiruvengadam (State Board, Tamilnadu)
Tamilnadu 01.2000 - 04.2001
S.S.L.C - School
Government Hr. Sec School, Thiruvengadam (State Board, Tamilnadu)
Tamilnadu 01.1998 - 04.1999
Skills
- Windows 8/10,UNIX, Linux
- C, C, shell scripting, Perl, Python
MS BI(SSIS,SSAS and SSRS),Tableau, Qlik
- AWS, Azure
- Talend DI, Talend MDM, Talend ESB, Catalog, Preparation, Quality, Stewardship
Strong leadership abilities
Building code compliance
Cost Estimation Accuracy
Project management expertise
Data Governance
Data Warehousing
Data Migration
Areas Of Interest
- Data Analysis
- Data Ware Housing
- Automation
- Scripting
- Object Oriented Concept
Personal Information
- Father's Name: S.Jebadoss
- Date of Birth: 10/28/1983
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Personal Traits
- Good Team Player
- Hard Working Individual
- Interested in working with intuitive and challenging projects
Newknowledgeacquisition
- Completed Denodo Data Virtualization course and completion
- Gen AI(ChatGPT, LLM etc..,) training completed
- MuleSoft anypoint studion 4
Projects
Material Master For BAYER(MM4B), Talend 8.0.1 Real Time Big Data Edition (ESB/DI), Postgres, MS SQL, ActiveMQ, MS Azure, Sap, Life Science, Feb 2021 to Present, Senior Architect, 12, BAYER, Germany, BAYER is transforming to life science company from pharmaceutical as part of the transformation many of its applications are rebuilding in new age technologies and data centers are moving to Cloud from On-Prem. Master Material is one of the area which is concentrating on Sales of Seeds, Corps and Logistics of those goods. In this MM4B landscape there is a Stibo STEP up stream creates requests in xml format based on business rules and validation. Those XMLs are passing to Talend through RestApi calls. Talend ESB routes will download those files and do validation, transformation and send to Sap through Bapi calls. Sap return response back to Talend which in turn sends back to STEP with agreed format. Talend ESB jobs are sync through AMQ. Entire process Talend ESB routes, DI jobs, Execution plans, AMQ and databases are used. Data Stage to Talend Migration(Asset Simplification Program), Talend 7.2 Real Time Big Data Edition (DI),Data Stage, Oracle, Teradata, Redshift, Spectrum, AWS, Python, Shell Scripting and AutoSys, Banking, April 2020 to Jan 2021, ETL Architect, 40, Citizens Bank, US, There are 10000+ Data stage ETL jobs has been converted into Talend ETL jobs in a phased manner with the help of Blage Bridge automation converting tool. Jobs get converted into 60% accuracy remaining gap will be done as a manual development and testing. There are various applications and it is spreaded in many layers of ETL. Source data is generated as parquet file format from various data sources and it will be placed in AWS S3 bucket. On top of S3 files external tables created using crawler and consumed by Talend ETL jobs through Autosys scheduler. After various validation, enrichment and transformation data will be loaded into Redshift data base. DCP Data Ware House, Talend 7.1 Data Fabric(DI,MDM and ESB),Oracle, SQL Server, JSON, Snowflake, Azure,ADF, Manufacturing, Jan 2019 to April 2020, ETL Architect, 12, DCP MidStream, US, Client have their data in various sources like Databases, Files and websites. This data need to moved to cloud data ware house which is designed in snowflake. By the way of moving the data all the ETL process need to be done. Data profiling, cleaning, validation, transformation and loading. All the data loaded from multiple sources with legacy data structures has to be moved to new data ware house. Facing some challenges like large volume of data and large number of columns in a single table handling through various techniques and solutions in ETL using Talend tool. Also started using Talend MDM for data modeling and onboarding of new customers, roles, accessibility etc., Also used ESB for integration with different applications in the environment. EG SD Løn Data Migration(DB2 to MySql), Talend 6.4,DB2 and MySql, Payroll Processing, Nov 2017 to Dec 2018, ETL Architect(Onsite), 10, EG Group, Denmark, This project is migration of 30 year old legacy SD Løn application data migration. SD Løn is a payroll product used by EG group to calculate the payroll end to end solutions to the major municipalities and government organizations across Denmark. Legacy system is migrated to new environment from mainframe and new UI, database is introduced for the migration. As part of this data need to move from DB2 to new database MySQL. Using Talend ETL tool data migration has been done phase by phase. All the development, testing and monitoring has been performed automatically using the Talend tool. CITI Work Flow Management(CWM), Talend 6.2,Tableau,Oracle,Unix and Autosys, Internal Application, Nov 2016 to Oct 2017, ETL Architect, 5, CITI Group, US, This project is a CITI internal application used to create the work flow of a particular process and its validation. Basically this project has two parts front end is designed in BPM and validation will be done in Talend jobs. IPAS2 Data Migration, Talend 5.6,Oracle,MySql and SQL Server, Investment Banking, Jan 2016 to Oct 2016, ETL Architect, 6, CITI Group, US, This project is a data migration which will extracts the data from various sources like file system, database and load into the destination database. DOGS Decommission(REFER Migration), Talend 5.4,Qlik,UNIX,Perl,Shell scripting, Investment Banking, Jan 2013 to Dec 2015, Tech Lead/Architect, 7, CITI, US, This project is migration of 30 year old legacy DOGS application migration. DOGS is a system used by CITI as settlement back office system. It will maintain end to end information of a trade starting from trade booking, enrichment, settlement etc., Our application called REFER is performing a functionality of DOGS called Feed and Report generation(ETL & Reporting). This is a pure development project starting from scratch. Voice Mediation, C,C++,UNIX(AIX),Oracle 10g,Perl,Shell scripting and Linux, Telecom, June 2012 to Jan 2013, Tech Lead, 8, This is the product used in telecom billing system. Main function of this system is to convert the data to user readable format which receives the data from the network. In this system it consists of three major modules called IPTS,IPSTARS,IPLASER.IPTS is the mediation system getting data from network. IPSTARS will do the aggregation of the CSR.IPLASER will send CSR details to the appropriate destination. IST Switch, C,C++ & UNIX(AIX),Oracle 10g, Banking, Apr 2011 to Present, IT Specizlist/Lead, 5, This is a product used for ATM, POS terminals to route the transaction to the exact destination. It is placed between the ATM and the Banks server connected in network. The transaction initiated in atm or pos it will hit the switch and the switch having the functionality like authorize the txn,reject the txn or to route the txn to the issuer of the card which is swipe in atm or pos. Infinys RBM(Rating and Billing Management), C,C++ & UNIX(AIX),Oracle 10g,Perl, Telecom Billing, July 2010 to March 2011, Senior Developer, 35, Convergys CEP (Credit Expansion Program), C,C++ & UNIX(AIX),SYBASE,Shell Scripting, Retail, Oct 2008 to May 2010, Developer, 10, LOWE’S, USA Voice Mediation, C,C++ & UNIX(AIX),SYBASE,Shell Scripting, Retail, Oct 2008 to May 2010, Developer, 10, LOWE’S, USA CALLISTO SERVER (Image Processing), C++,DB2 & UNIX, Publishing, MAY 2008 to Oct 2008, Developer, 3, CENGAGE, USA DDCI (Ada to C++ conversion), C++ & Windows, Jan 2008 to May 2008, Developer, 12, DDCI, USA, It’s a conversion project used in the US defence.client having a project which is working in Ada they want to convert into c++. Gnat-gpl-2007-2-pentium-mingw32msv-bin converter is used for the conversion. One drawback is at a time we have to give 100 lines only 80 lines to be converted remaining we have to do. it is using in the simulator of Apache aircrafts. INTELLI-TICK PBSC (QUIZ Game), C++ with Windows and Socket programming(UDP), Publishing, Nov 2007 to Jan 2008, Developer, 4, PBSC, India, It’s a gaming project using in airlines at the time of traveling. Here using single server multiple client’s concept by the use of socket programming (using UDP protocol) and multi threading concepts. In PBSC the UDP is used for connecting server and client’s communication purposes and also for sending the video and audio files.SDL network library was used for graphics and display images etc. Kernel Device Driver for PCI-DPM Communication Device, C++ & Linux, DEC 2006 To Nov 2007, Developer, 3, Nal, Bangalore, It contains 32 Pentium - III Processors as processing elements. In this we used distributed memory architecture (i.e.) each processor has its own local memory module. So this project solves the data requirement between any two processors through PCI bus and Dual port memory (DPM) device. IT CAN DETECT THE ONE-DAY WEATHER FORECAST WITHIN 30 MINUTES. Multipurpose Credit Card System, C,C++,SQL & UNIX, Banking and Finance, May 2005 to DEC 2006, Developer, 5, SBI, Mumbai, It is a project involving the electronisation of credit card and rectifying all the disadvantages faced by normal credit cards through the introduction of password technique. In our project we use the chip card for three different purposes namely Attendance logging, Internet café accounting and money transaction.
Disclaimer
I hereby declare that the above information is true to the best of my knowledge & belief.
Timeline
ETL Architect
L & T Infotech
01.2013 - 02.2021
Project Leader
Infinite Computer Solutions
06.2012 - 01.2013
Team Leader
FIS Global
04.2011 - 05.2012
ETL Architect
Aequor
07.2010 - 03.2011
ETL Developer
OFS
09.2009 - 06.2010
ETL Developer
Photon InfoTech
11.2007 - 02.2009
BE(Electronics &comm.) - Electrical, Electronics And Communications Engineering
P.S.R Engineering College, Sivakasi, (Anna University, Chennai)
01.2001 - 04.2005
H.S.C - School
Government Hr. Sec School, Thiruvengadam (State Board, Tamilnadu)
01.2000 - 04.2001
S.S.L.C - School
Government Hr. Sec School, Thiruvengadam (State Board, Tamilnadu)
01.1998 - 04.1999
Senior Architect
Capgemini Technology services India Limited
2 2021 - Current
Similar Profiles
Vasu Sagar AbishettiVasu Sagar Abishetti
Finance Controller at Capgemini Technology Services India LimitedFinance Controller at Capgemini Technology Services India Limited
Debjit MukherjeeDebjit Mukherjee
Senior Service Lead – Managed Services at Capgemini Technology Services India LimitedSenior Service Lead – Managed Services at Capgemini Technology Services India Limited
BHAGAVATULA R V S S SAISREEBHAGAVATULA R V S S SAISREE
Senior Analyst/Software Engineer at CAPGEMINI TECHNOLOGY SERVICES INDIA LIMITEDSenior Analyst/Software Engineer at CAPGEMINI TECHNOLOGY SERVICES INDIA LIMITED