Lijo Lawrance
Data Engineer Lead
Pune
Summary
Astute Data/Analytics Engineer with data-driven and technology-focused approach. Communicates clearly with stakeholders and builds consensus around well-founded models. Talented in writing applications and reformulating models.
Overview
11
11
years of professional experience
2
2
years of post-secondary education
3
3
Certifications
Work History
Lead Data Engineer
Citicorp Services India Pvt Ltd
Pune
03.2013 - 06.2022
- Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
- Developed, implemented and maintained data analytics protocols, standards and documentation.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
- Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
- Communicated new or updated data requirements to global team.
- Contributed to internal activities for overall process improvements, efficiencies and innovation.
ETL Developer
Wipro Technologies
Chennai
02.2011 - 01.2013
- Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
- Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
- Directed data transformations and transitions using Pentaho.
- Utilized code versioning systems such as [Type] to reduce development times.
- Verified performance and reliability of development database transformation solutions via extensive simulation testing.
- Wrote and optimized in-application SQL statements.
- Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
Education
Master of Science - Computer Science
MG Univeristy
Kottayam 06.2005 - 07.2007
Skills
SQL
undefinedAccomplishments
- Create 80+ DBT models for Large data warehouse. This increased the data transformation speed by 40%
- Designed Looker Dashboards for client reporting
- Developed a Google cloud (GCP) solution to fetch unstructured Add data including call logs, call recording from Google buckets and process/transform thru the data proc jobs and load into BigQuery.
- Achieved 50% reduction in efforts by introducing ETL framework for Development tasks.
- Developed methods to integrate Collateral ETL flow to significantly improve workflow efficiency which helped in SFTR Regulatory reporting .
- Supervised team of 20+ global staff members.
Certification
AWS Solution Architect -Associate
Timeline
Python - Hackerank
06-2022
Certified Scrum master
02-2022
AWS Solution Architect -Associate
10-2021
Lead Data Engineer
Citicorp Services India Pvt Ltd
03.2013 - 06.2022
ETL Developer
Wipro Technologies
02.2011 - 01.2013
Master of Science - Computer Science
MG Univeristy
06.2005 - 07.2007
Similar Profiles
Kiran Kumar PothurajuKiran Kumar Pothuraju
Operations Personnel at Adecco India Private Limited ( A Project in Citicorp Services India Pvt Ltd)Operations Personnel at Adecco India Private Limited ( A Project in Citicorp Services India Pvt Ltd)
Shahid Javed PathanShahid Javed Pathan
Officer at Citicorp Services India Pvt. Ltd.Officer at Citicorp Services India Pvt. Ltd.
Ashok Kumar BadiginchalaAshok Kumar Badiginchala
Vice President at Citicorp Services India Pvt LtdVice President at Citicorp Services India Pvt Ltd