Senior Data Engineer - Data Warehousing
Property Finder
Total years of experience :15 years, 4 Months
Lead the Cloud Data Lake/Data Warehousing initiatives
Cloud Data Warehousing/Data Lake using Snowflake.
Role : Business Analysis, Requirement Analysis,
Data Modeling, ELT pipelines using DBT, SQL Development, Stakeholder Management
Additional responsibilities : Leading daily scrum, sprint planning, backlog grooming
Data Architect / Solution Architect.
Solution Pre-sales : Oversee RFP process until proposal submission and respond to RFP questionnaire. Collaborate with the partner on proposal writing, solution outline and estimates. Technical delivery assessment & review of the proposed solution.
DataWarehousing/Data Architecture delivery : Requirements Analysis, Source System Analysis, Solution Design, Proof of Concepts, Data Modeling, ETL design, development, implementation & support and Data Visualization/BI analysis.
Handson experience in BI Tools Tableau & ETL tools IBM Datastage
Major Clients : Government Clients Kuwait ( Central Statistics Bureau, Public Institution For Financial Security Kuwait), Dubai Islamic Bank, ABC Bank Bahrain
Spear headed 15+ ETL Datastage development team from offshore for the development of an enterprise datawarehouse using IBM IIW Data Model framework & Agile Scrum process framework for the client Insurance Corporation British Columbia(ICBC), Canada.
Performed Data Mapping role for the development of an enterprise datawarehouse using IBM BDW Model framework for the client ANZ Bank, Australia.
Technologies used : IBM BDW, IBM IIW, Datastage 9.1/8.5, Metadata Workbench, DB2, Teradata, Unix, ERwin, IBM Infosphere Data Architect, Information Analyser
Other Activities : Contributed to the Solution Outline & Architecture of the projects involved. Participated IBM BAO Architect Mobilization Data Modeling workshop during 2013-14.
Created Proof of Concepts(POC) using IBM Infosphere Datastage & Metadata Workbench.
Member of the Technical Panel to support lateral hiring.
Key Trainings Attended : Architect Thinking, IBM BDW Data Model, IBM IIW Data Model, IBM Infosphere Information Analyzer, IBM Infosphere Data Architect, IBM BAO Reference Architecture.
Certifications Done : IBM Infosphere Datastage 8.5 Solution Developer
Performed various roles including ETL Datastage Designer, Data Mapper to create Source to Target Mappings, Mentor etc.
Major Projects Involved :
HR-EUC(HR End User Computing) : The data integration project involves data migration of HR related data from the peoplesoft DB2 database to SQL Server database.
PRISM : To collect the product(item) information when it gets created or modified, generate xml feeds and send to the downstreams.
Technologies Used : Datastage 7.5.2, AIX Unix, DB2, SQL Server, MS Visio
Performed various roles including ETL Datastage Developer, Data Analyst, IIog Jrules Developer & Software Configuration Manager for the internal client Standard Chartered Bank.
Major Projects involved :
Credit Data Warehouse(CDW) for Basel 2 : To create an Enterprise Data Warehouse using
IBM BDW framework.
Data Integration Hub : To create a data integration hub to source and integrate data from multiple source systems.
Technologies Used : Datastage 7.5, Ilog JRules, DB2, Oracle, ERwin, AIX Unix, Cognos
Onsite Exposure : Kuala Lumpur, Malaysia (Oct 2008-Mar 2009)
➢ Worked as Project Trainee/Consultant (Contract) at Standard Chartered-Scope International, Chennai from Jul 06 to Jan 07.
B.Tech Computer Science Engineering 2001-05 batch, Govt College of Engineering, Kannur, Kerala, India