Geetha S

Project 1 – Data-mart for Marketing activities

Project Description:

• The main objective of this project was to build data mart that meets data needs of all marketing campaigns, Mortgage Lead generations, Promotions, offers and
• Wealth Campaigns

Roles and Responsibilities:

• Have built ETL – IICS application that source various systems of bank and loading into single database of 70+ tables with 2.5k attributes for marketing usage
• Currently, supporting various enhancements to the application for enhancing end user experience
• Participated in various activities of projects such as requirement gathering, identify the different sources to be brought in, profiling the source data, preparing the logical data model, building various generic mappings/mapplets for ETL application, preparing High level design, production handover documents
• Have built various IICS mappings, Maplets, Task flows, Data profiling tasks and have scheduled with enterprise level scheduler – CA ESP
• Participation in design sessions with focus in suggesting solutions
• Discussions around Sprint and Backlog prioritization from functional and technical perspective
• Involved in different scrum ceremonies like Daily Stand Up, Sprint Planning, Sprint
• Review & Product Backlog Refinement and delivering demo of working product to clients
• Have involved in debugging different data related issues and making code fixes or suggesting technical enhancement of application to enhance the downstream user experience
• Have involved the testing process and deployed the code to production environment

Project 2 – Design DQ control system for ETL application

Project Description : –

• The main objective of this project was to add data quality checks on various stages of ETL application

Roles and Responsibilities:

• Understanding, analyzing, and implementing the data quality checks using python and pandas to perform various data quality checks on incoming data files which controls the flow of bad data to vendor systems
• End to end testing of python code
• Supporting the deployment activities and was involved in debugging different data related issues and making code fixes or suggesting technical enhancement of application

Project 3 – Voice of client for marketing activities

Project Description:

• The main objective of this project was to collect the customer feedback and process that feedback to enhance the customer experience

Roles and Responsibilities:

• Have built ETL – informatica power center application that source various systems of bank and loading into single database of 70+ tables with 2.5k attributes for marketing usage
• Currently, supporting various enhancements to the application for enhancing end user experience
• Participated in various activities of projects such as requirement gathering, identify the different sources to be brought in, profiling the source data, preparing the logical data model, building various generic mappings/mapplets for ETL application, preparing High level design, production handover documents
• Have built various mappings, Maplets, Task flows, Data profiling tasks and have scheduled with enterprise level scheduler – CA ESP
• Participation in design sessions with focus in suggesting solutions
• Discussions around Sprint and Backlog prioritization from functional and technical perspective
• Involved in different scrum ceremonies like Daily Stand Up, Sprint Planning, Sprint
• Review & Product Backlog Refinement and delivering demo of working product to clients
• Have involved in debugging different data related issues and making code fixes or suggesting technical enhancement of application to enhance the downstream user experience
• Have involved the testing process and deployed the code to production environment.