Maria Bindhu Sebastian

Work experience:

Senior System Engineer - IBM India Pvt Ltd, India | Jul 2011 - Jan 2023

Data Engineer - ETL Informatica Powercenter,

Data Management Support Specialist - MDM

• Experience in Extraction, Transformation, and Loading data using Informatica Powercenter and MDM.
• Worked as ETL Developer and supported maintenance activities.
• Solved the high priority incidents to support valuable delivery.
• Recorded required statistical information for recording purposes. Working independently as a development and support team member and took complete responsibilities, and sharing knowledge with team members.
• Balancing and utilizing the time in a proper way, as a result, contribution fro both organization and client as well.
• Efficient Data Management.

Assignment history:

Senior ETL Developer CHUBB Insurance, India | Apr 2021 - Jan 2023

Project name: CBD COG, CBD Expansion (CBD-X)

Chubb Limited, is a global provider of insurance products covering property and casualty, accident and health, reinsurance, and life insurance and the largest publicly traded property and casualty company in the world. Chubb has many source systems. The main task here is to bring the data from different source systems, and load it into the target tables for decision making and reporting purposes.

Contribution:

• To Develop Informatica Powercenter mappings to load the data from source system to the stage master tables.
• To Develop View and IICS mappings as per the Mapping Document, to bring the data from stage master tables to the target tables.
• Responsible for testing and validating the data.
• Responsible to fix the defects in SIT, UAT and PROD Environment
• Directly interact with client and onshore team.
• Attend daily defect triage calls, stand up calls, sprint planning calls etc.
• Ensure 100% compliance to SLAs for Project Delivery with quality.

Senior ETL Developer - TD Bank, USA, India | Oct 2019 - May 2020

Project name: RRDW

TD Bank has multiple systems that support its business analytics needs, RRDW is one of these systems. There are existing production jobs written using Informatica Powercenter, which undergo enhancements or defect fixes. Also, there are new source systems being integrated with time. As part of this project, we develop these new components, configure metadata and also provide support to enhance existing code components.

Contribution:

• Develop Informatica mappings as per the design document and SQL scripts.
• Transform legacy SQL code into SQL.
• Responsible to develop the mapping as per the business need, and do Sanity Test.
• Responsible for testing and validating Dev data against Sandbox data.
• Directly interact with client and other vendor teams involved.
• Attend daily/weekly status call with client team lead to get clarification on the assigned task and report if any issues, to update the status of the deliverables etc.
• Ensure 100% compliance to SLAs for Project Delivery with quality.

ETL Developer - CIBC, India | Apr 2019 - Sep 2019

Project name: DCP Phase 2

The Canadian Imperial Bank of Commerce is one of the Big Five banks in Canada. Aside from owning and leveraging shares in Canadian extractive firms, CIBC is also heavily involved in the financing of large-scale industrial projects. Also supports all types and sizes of business activities across a broad range of industries, enabling access to working capital, term and asset-backed loans as well as acquisition and project-level financing. They are also responsible for the management of credit exposure associated with Global Markets Business. DCP Phase 2 project is a short term project, to migrate the jobs from SAS Program to Informatica Mappings.

Contribution:

• Understand the SAS program, create design document based on SAS code, and develop Informatica mappings as per the business requirement.
• Responsible to develop the mapping as per the business need, and do Sanity Test.
• Responsible for preparing the test cases, execute the workflow, validate the result against the test cases, and capture the results for DIT review with Client.
• Attend daily scrum call with the DCP Phase 2 Team.
• Ensure 100% compliance to SLAs for Project Delivery with quality.

MDM Prod Support Developer (Application Maintenance Services) - Citrix Systems, Inc., India | Jan 2017 - Feb 2018

Project name: Citrix AMS Support

Citrix System, Inc. is an American Multinational software company that provides server, application and desktop virtualization, Networking, Software as a Service (SaaS), and cloud computing technologies. Citrix AMS provides the application support that deals with, Technical or Application help (L2 or L3) to users and Incident (Break Fix) or problem management. Application maintenance is generally associated with Application Maintenance and Enhancements (small to medium development projects).

Contribution:

• Provided full support to Level 2 team for all-hands-on-deck production issues.
• Break-fix support and deployment.
• Ensured 100% compliance to SLAs for incident response and incident resolution.
• Guaranteed incident resolution for all production issues and helped the team with the enhancements and the issue tracking.
• Supported in hypercare solution at the quarter end.
• Involved in knowledge sharing to the new team members.

Informatica Production Support Developer - Nationwide Insurance, India | Oct 2011 - Dec 2016

Project name: eProd Auto and Property Support

Nationwide, based in Columbus, Ohio, is one of the largest and strongest diversified insurance and financial services organization in the U.S. The company provides a full range of personalized insurance and financial services, including auto insurance, motorcycle, boat, homeowners, life insurance, farm, commercial insurance, administrative services, annuities, mortgages, mutual funds, pensions, long-term savings plans, and health and productivity services.

The main function of eProd Auto/Property is to bring the data from PCDW_Fire (Teradata) source system to GSRM_Auto/Property Warehouse (Teradata) and provide the reporting for analyzing the cycle time rate changes and provide a competitive pricing model. Contribution:

• Provided development and enhancement solutions for Galaxy Data Warehouse applications using Informatica, Teradata and Unix technologies.
• Monitoring Production Jobs and taking care of Incidents, analyzing the production defects and fixing them permanently and ensure we meet daily/ weekly/monthly SLA's.
• Analysis, design, development, testing, maintenance and implementation of the data warehouse Auto and Property applications.
• Provide on call Production Support (Providing a temporary or a permanent fix which is required for production abends).
• Responsible for creating designs for development projects, provide performance tuning, support testing & deployment.
• Drive for consistency in format, agility in handling ongoing changes, updates as business demands.
• Responsible for effective communication with the upstream and downstream systems
• Working on ad-hoc report requests from customer and supporting the clients for user queries.
• Gathering the requirements and doing Impact Analysis
• Scheduled, executed and monitored Informatica flows using scheduling tool Maestro/ ESP.
• Involved in performance tuning issues at various levels such as target, sessions, mappings and sources.
• Used post session success, post session failure commands in the session task to execute scripts for reconciliation, clean up and updates.
• Involved in writing test scripts, unit testing, system testing and documentation.
• Coordinate with onshore team on Project developments and application support tasks and implement production releases.
• Prepare project related documents like Application Enhancement, design document, technical documents based on the business requirements for the enhancement projects.
• Responsible for understanding the business requirements as per customer needs
• To attend regular project status meetings with different teams to discuss the progress of the project, identify any risks in delivering the project on time etc.
• To migrate the code to production and provide post production support in the warranty period.
• On daily basis need to send the status report to client regarding the production flows.
• In case of abend in production need to resolve the abend within the given SLA time.
• Involved in Knowledge transition and shared knowledge to other team members.