Shanmukha Srinivas Daita
Senior Abinitio Lead
Chennai
Summary
13+ years of experience in scalable ETL solutions. Worked on series of Ab Initio frameworks in the projects for major clients. Developed and implemented ETL processes for data extraction, transformation, and loading into data warehouses specifically using Ab Initio tool.
Has very good knowledge and hands on in using the Ab Initio GDE, experienced in PDL, Express >IT, SQL and has good Unix scripting skills.
Exposure to Databricks,SSIS,Talend open studio,Azure cloud architecture,snowflake.
Has very good communication skills and has enough experience interacting with clients Onshore and in managing client expectations. Has very good leadership capabilities and has valuable experience managing the technical team offshore to deliver the client requirements. Managed deadlines and multiple projects effectively with strong business and technical skills. Strong analytical and interpersonal skills, committed to learning modern technologies. Experience in managing the projects and co ordinating between Client,Onshore and offshore teams.
Good knowledge in Project management concepts ,various methodologies and strategies. Good knowledge in Data warehousing, data governance and ITIL concepts. Understanding of cloud basics.
Professional technical leader with proven ability to spearhead complex projects and drive innovative solutions. Adept in software development, systems architecture, and project management. Strong emphasis on team collaboration and delivering results in dynamic environments. Known for adaptability and reliability. Skilled in coding, debugging, and optimizing performance.
Overview
14
14
years of professional experience
Work History
Senior Ab Initio Technical lead
ELAIT IT Technologies Pvt. Ltd.
04.2022 - Current
- Pension Migration and Reporting: A data hub was implemented to exchange annuities data between the customer ops admin system and payroll, MI reporting, and finance systems. Ab Initio change data capture (CDC) enabled the extraction of data from DB2 & Azure SQL source databases, and delivery via file based, WebSphere MQ, Api’s, and database interfaces.
- An Express>It framework was delivered to streamline onboarding of data feeds and manage migration data. Data obfuscation ensured the migration tranches could be trailed without compromising data security.
- Metadata>Hub was utilized to develop a product framework, and medical questionnaire data repository.
- Roles and Responsibilities:
- Participating in scrum calls, updating the progress to Onshore consultant.
- Participating in the Planning events in Onshore.
- Leading the team to translate the requirements.
- Ensuring the proper review of the development process.
- Participating in the code reviews and ensuring the best practices are met.
- Reviewing the risks, updating the management on the status regularly.
- Review of the monthly efforts and sharing them for the billing.
- Coordinating with the testing and support teams for the graphs developed.
- Coordinating the Knowledge transfer sessions for other teams about the frameworks developed and how to reuse the generic graphs in the other graphs developed.
- Participating in the scrum calls to update the client about the progress.
- Design, development and testing of generic graphs.
- Necessary documentation provided to support the above frameworks.
- Ensuring the team is up to date with the latest advancements in the tool by organizing the training sessions.
- Guiding the team members to work on the requirements.
- Sending weekly/Monthly reports to the management in terms of the progress.
- Mentoring new joiners in the project and ensuring their overall development is met.
Senior Associate Technology
ELAIT IT Technologies Pvt. Ltd.
02.2019 - 03.2022
- Pension Migration and Reporting: A data hub was implemented to exchange annuities data between the customer ops admin system and payroll, MI reporting, and finance systems. Ab Initio change data capture (CDC) enabled the extraction of data from DB2 & Azure SQL source databases, and delivery via file based, WebSphere MQ, Api’s, and database interfaces.
- An Express>It framework was delivered to streamline onboarding of data feeds and manage migration data. Data obfuscation ensured the migration tranches could be trailed without compromising data security.
- Metadata>Hub was utilized to develop a product framework, and medical questionnaire data repository.
- Roles and Responsibilities:
- Design, development and testing of generic graphs.
- Analyze requirements obtained from on site and create detailed design.
- Providing the unit test plan and collecting the test evidence for the frameworks.
- Participating in scrum calls, updating the progress to Onshore consultant.
- Participating in the Planning events in Onshore.
- Leading the team to translate the requirements.
- Ensuring the proper review of the development process.
- Participating in the code reviews and ensuring the best practices are met.
- Coordinating with the testing and support teams for the graphs developed.
- Coordinating the Knowledge transfer sessions for other teams about the frameworks developed and how to reuse the generic graphs in the other graphs developed.
- Participating in the scrum calls to update the client about the progress.
- Necessary documentation provided to support the above frameworks.
- Guiding the team members to work on the requirements.
Onshore Ab Initio consultant
ELAIT IT Technologies Pvt. Ltd.
11.2018 - 01.2019
- Pension Migration and Reporting: A data hub was implemented to exchange annuities data between the customer ops admin system and payroll, MI reporting, and finance systems. Ab Initio change data capture (CDC) enabled the extraction of data from DB2 & Azure SQL source databases, and delivery via file based, WebSphere MQ, Api’s, and database interfaces.
- An Express>It framework was delivered to streamline onboarding of data feeds and manage migration data. Data obfuscation ensured the migration tranches could be trailed without compromising data security.
- Metadata>Hub was utilized to develop a product framework, and medical questionnaire data repository.
- Roles and Responsibilities:
- Gathering requirements from the client from onshore by participating in planning sessions.
- Ensure the requirements are translated from Offshore.
- Participated in workshops with the client while adding new requirements.
- Participated in offshore development review.
- Participating in the scrum calls to update the client about the progress.
- Participating in the Planning sessions conducted Onshore.
- Coordinating with the testing and support teams for the graphs developed.
- Coordinating the Knowledge transfer sessions for other teams about the frameworks developed and how to reuse the generic graphs in the other graphs developed.
- Necessary documentation provided to support the above frameworks.
- Guiding the team members to work on the requirements.
Onshore Ab Initio consultant
ELAIT IT Technologies Pvt. Ltd.
11.2017 - 10.2018
- Media and Marketing Data management: Coordinated onshore and offshore teams to deliver ETL generic frameworks to extract the data from complex macro driven spreadsheets (managing billboards, print & social media) and delivered a reliable and accurate single source system to store the media plan related information into database for analysis and downstream reporting purpose. Delivered an automated template for the onboarding of the client, accelerated on boarding template and solution. With this the clients on boarding were done by the business end with the help of the Express>IT templates provided.
- Roles and Responsibilities:
- Gathering requirements from the client.
- Ensure the requirements are translated from Onshore.
- Participated in workshops with the client while adding new requirements.
- Participated in offshore development review.
- Participating in the scrum calls to update the client about the progress.
- Coordinating with the testing and support teams for the graphs developed.
- Coordinating the Knowledge transfer sessions for other teams about the frameworks developed and how to reuse the generic graphs in the other graphs developed.
- Necessary documentation provided to support the above frameworks.
- Guiding the team members to work on the requirements.
Senior Associate Technology
ELAIT IT Technologies Pvt. Ltd.
11.2013 - 11.2017
- Media and Marketing Data management: Developed ETL generic frameworks to extract the data from complex macro driven spreadsheets (managing billboards, print & social media) and delivered a reliable and accurate single source system to store the media plan related information into database for analysis and downstream reporting purpose. Delivered an automated template for the onboarding of the client, accelerated on boarding template and solution. With this the clients on boarding were done by the business end with the help of the Express>IT templates provided.
- Roles and Responsibilities:
- Design, development and testing of generic graphs.
- Analyze requirements obtained from on site and create detailed design.
- Providing the unit test plan and collecting the test evidence for the frameworks.
- Coordinating with the testing and support teams for the graphs developed.
- Coordinating the Knowledge transfer sessions for other teams about the frameworks developed and how to reuse the generic graphs in the other graphs developed.
Associate Technology
ELAIT IT Technologies Pvt. Ltd.
08.2012 - 10.2013
- Online Betting Data Management: Developed generic ETL frameworks for Audit and logging to handle errors and load to Oracle Tables, housekeeping to clean up UNIX file system, Reconciliation, Recycling, Reference data management, Data Confirmation, Aggregation and Maintain Facts using graph development environment(GDE) and UNIX scripts.
- Roles and Responsibilities:
- Design, development and testing of generic graphs.
- Analyze requirements obtained from on site and create detailed design.
- Providing the unit test plan and collecting the test evidence for frameworks.
- Coordinating with the testing team for testing the graphs developed.
- Coordinating the Knowledge transfer sessions for other teams about the frameworks developed and how to reuse the generic graphs in the other graphs developed.
- Necessary documentation provided to support the above frameworks.
Education
M.S - Information and Communication Engineering
University of Leicester
Leicester, Leicestershire, UK01-2011
B. Tech - Electronics and Communication Engineering
Jawaharlal Nehru Technological University
Hyderabad01-2008
Skills
Skill Areas
Ab Initio (in years): GDE (13), Co-Operating Systems (13), EME (Enterprise Meta Environment) (13), Continuous Flows (7), Conduct > it (12), Express>it (9), BRE (9), Metadata Hub (5), Control Center (12), Authorization Gateway (10), Test Data Management (3),Data governance,Databricks,SSIS,Talend open studio,Azure cloud,Agentic AI
Hardware: UNIX (Sun, HP and Sequent)
OS: Windows 95/98/2000/NT/XP/Vista/10/11, Linux, Unix
Databases: MS SQL, MY SQL, Oracle,DB2
Software: SQL, Unix Shell Script
Tools: Ab Initio (including EME, TOAD, SQL
Timeline
Senior Ab Initio Technical lead
ELAIT IT Technologies Pvt. Ltd.
04.2022 - Current
Senior Associate Technology
ELAIT IT Technologies Pvt. Ltd.
02.2019 - 03.2022
Onshore Ab Initio consultant
ELAIT IT Technologies Pvt. Ltd.
11.2018 - 01.2019
Onshore Ab Initio consultant
ELAIT IT Technologies Pvt. Ltd.
11.2017 - 10.2018
Senior Associate Technology
ELAIT IT Technologies Pvt. Ltd.
11.2013 - 11.2017
Associate Technology
ELAIT IT Technologies Pvt. Ltd.
08.2012 - 10.2013
B. Tech - Electronics and Communication Engineering
Jawaharlal Nehru Technological University
M.S - Information and Communication Engineering
University of Leicester