Mathivathani Manickavasagam Latha
Summary
As a Data Analytical Engineer for 11 years worked in Banking, Insurance, Media and E-commerce domains has gained experience in handling projects from requirement gathering, E2E Analysis, Development , Deployment to production and Post production support.
Have coordinated with teams spread across different geographical locations for different projects in Agile.
Have guided the team and experienced in providing data quality and data governance solutions from RAW Staging layer till the Semantic layer.
Overview
12
12
years of professional experience
Work History
Marketing Optimization Specialist
BOSE NV
11.2021 - 03.2024
As a Marketing Optimization Specialist,
- I am responsible for designing, optimizing and maintaining the Ecommerce data mart.
- Successfully handled migration from Talend tool to DBT.
- Validated the important KPI's using Power BI reporting.
- Handled data quality issues from the business stakeholders and reacted on time for resolution.
Data Integrator Expert
MLOZ- Mutualités Libres / Onafhankelijke Ziekenfon
01.2020 - 09.2021
As a Data Integrator Expert,
- Migrated Netezza stored procedure to ETL Tool DataStage.
- Designed Data Models using Data Vault Modelling Technique.
- Provided solutions to complex Data Vault Modelling issues faced during the development.
- Acquired intense knowledge on Hubs, Link and Satellite and the whole Business purpose between the use of Links.
ETL Analyst/Developer
ROSSSEL MEDIA COMPANY (DATAMIND SPRL)
01.2019 - 12.2020
As a ETL Developer,
- Experienced in extraction from Inputs like API, Database, XML, JSON, Delimited, Salesforce Objects and read into Talend Jobs to perform analytical data streams.
- Experienced in preparing Business requirement Document and Technical requirement document. (100 % French env).
BI Reporting Specialist
DATAMIND SPRL
02.2018 - 12.2018
As a BI Reporting Specialist,
- Created BI Reports using the High chart Reporting Tool.
- Analysed the tables and the UI inputs from the Customer to sort down the MYSQL Procedure.
- Enhanced my analytical skills to sort down the Inputs required for MYSQL Procedure and queries.
ETL Specialist
Bank Of America (TATA CONSULTANCY SERVICES)
05.2015 - 07.2016
As a ETL Specialist,
- Migrated Mainframe code to DataStage using the HLD and LLD provided by the clients. Input received from the upstream is the money transactions made in a day by the end users.
- Gathered business requirements from Business analysts and transformed functionality into ETL objects.
- Prepared technical specifications, created system test plans and system test cases & Unit Testing documents.
BI Developer
MERRILL LYNCH - Bank Of America (TATA CONSULTANCY
09.2012 - 04.2015
As BI Developer,
- Prepared Technical Specification, Test cases and final mapping sign off Document to customers.
- 24/7 on call support to Daily, Weekly, Monthly, Quarterly and Yearly production load schedules.
- Prepared Test Document with capturing Unit test, System test and Regression testing sample results for User Acceptance test.
Education
Master of Engineering - Computer And Communication Engineering
Sri Sai Ram Engineering College
Chennai, India06.2012
Bachelor of Engineering - Information Technology
Avinashilingam University
Coimbatore, India06.2010
Skills
- BI tools - DBT, Datastage, Talend , Airflow , Azure and AWS S3 bucket
- Data Modelling - Kimball and Data vault modelling
- Data Warehouse - Snowflake, BigQuery, Netezza, Oracle
- Version Control - Git HUB
- Source Files - csv, JSON, PARQUET
- Analytical Tools - Adobe Analytics and Google Analytics 4
- Reporting Tools - Power BI and Tableau
- Project Management
- Solution Architect
Languages
English
Bilingual or Proficient (C2)
French
Elementary (A2)
Timeline
Marketing Optimization Specialist
BOSE NV
11.2021 - 03.2024
Data Integrator Expert
MLOZ- Mutualités Libres / Onafhankelijke Ziekenfon
01.2020 - 09.2021
ETL Analyst/Developer
ROSSSEL MEDIA COMPANY (DATAMIND SPRL)
01.2019 - 12.2020
BI Reporting Specialist
DATAMIND SPRL
02.2018 - 12.2018
ETL Specialist
Bank Of America (TATA CONSULTANCY SERVICES)
05.2015 - 07.2016
BI Developer
MERRILL LYNCH - Bank Of America (TATA CONSULTANCY
09.2012 - 04.2015
Master of Engineering - Computer And Communication Engineering
Sri Sai Ram Engineering College
Bachelor of Engineering - Information Technology
Avinashilingam University
Similar Profiles
Alejandro Castañeda PinedaAlejandro Castañeda Pineda
Buyer/Planner at Bose CorporationBuyer/Planner at Bose Corporation
Sheila O’DonnellSheila O’Donnell
Inventory Operations - Material Handler III at Bose CorporationInventory Operations - Material Handler III at Bose Corporation
TANMOY SENTANMOY SEN
Junior Lecturer at SUBHAS BOSE INSTITUTE OF HOTEL MANagementJunior Lecturer at SUBHAS BOSE INSTITUTE OF HOTEL MANagement