DATA ARCHITECT, DATA ANALYTICS SPECIALIST, BIG DATA ENGINEER

DATATEAM
Managed and worked graph database projects, data warehousing and data integration projects.
Responsible for data, middleware, ETL and reporting architecture. Worked mainly with government , education and finance user
groups to gather data requirements and design enhancements to the data warehouse. Provided level of effort, duration and work
completion estimates while also providing technical oversight for a team of developers on various projects.
* Established architecture and technical design for data warehouse, ETL and data integration projects along with technical
oversight for resources on all phases of the projects.
* Defined services and solutions in the Information Management practice, such as Enterprise Data Warehousing, Master
Data Management and Data Governance.
* Defined the ETL architecture for staging and reporting schemas, data models, term records process and incremental
versus full data pull strategy on Land Registry and Cadastre Information Project.
* Defined services and solutions in the Business Intelligence practice, such as Data Modelling, Dimensional Modelling
and Reporting.
* Assisted in presales by finishing to Graph POCs.
* Served data architect and data warehouse development on Land Registry and Cadastre Information Project system
implementation.




* Define real-time and batch data ingestion architecture using Lambda approach, including HBase for real-time as well
as Sqoop and Hive for batch layer.
* Migrated and created Stored Procedures from source system codes into the warehouse and created type-2 tables to track
point-in-time data changes.
* Retired the legacy Officially Register Management Replication process from .Net code to SQL Server Stored
Procedures.
* Outline end-to-end strategy and roadmap for data platforms as well as modernize data and infrastructure.
* Served as the big data competence lead responsible for government log data analytics.
* Facilitated end-user training to change Oracle SQL to ANSI SQL.
* Assessed current state of data management, identified gaps, provided recommendations and developed roadmap to
adapting data visualization VisionBI at the enterprise level
* Managed team of developers to complete the migration effort.
* Consulted by team of developers to complete the migration effort from Oracle Database to OBIEE Model.
* Migrated a database in Oracle to PostgreSQL using PostgreSQL migrating workflows and database objects.
* Migrated a database in SQL Server to SQL Server using SSIS workflows and database objects.
* Migrated a database in SQL Server to Hive using Sqoop workflows and database objects.
* Migrated a database in Oracle SQL to PGX using PGQL workflows and database objects.

E-KALITE
Responsible for data, ETL and reporting architecture. Worked mainly with healthcare data requirements and design
enhancements to the data warehouse.
* Defined services and solutions in the Business Intelligence practice, such as Data Modelling, Dimensional Modelling
and Reporting.
* Defined the ETL architecture for staging and reporting schemas, data models, term records process and incremental vs
full data pull strategy on Turboard Business Intelligence Project.
* Developed Turboard Business Intelligence Project with Django and Ember.js.

DATAMIND
Managed and worked data warehousing and data integration projects.
Responsible for data, ETL and reporting architecture. Worked mainly with government , education, insurance, healthcare and
finance user groups to gather data requirements and design enhancements to the data warehouse. Provided level of effort, duration
and work completion estimates while also providing technical oversight for a team of developers on various projects.

* Established architecture and technical design for data warehouse, ETL and data integration projects along with technical
oversight for resources on all phases of the projects.
* Defined services and solutions in the Information Management practice, such as Enterprise Data Warehousing, Master
Data Management and Data Governance.
* Defined services and solutions in the Business Intelligence practice, such as Data Modelling, Dimensional Modelling
and Reporting.
* Assisted in sales cycles by responding to RFPs, creating Statement of Works(SOW) and creating estimates.
* Assisted in presales by finishing to POCs.
* Served data architect and data warehouse development on Transport and Transit Data Reconciliation Project system
implementation.
* Defined the ETL architecture for staging and reporting schemas, data models, term records process and incremental
versus full data pull strategy on Transport and Transit Data Reconciliation Project.
* Acted as solution architect for a multi-phase project to implement a freight data mart to better forecast high-value and
high-potential container.
* Replicated over 50 tables from source system into the warehouse and created type-2 tables to track point-in-time data
changes.
* Outline end-to-end strategy and roadmap for data platforms as well as modernize data and infrastructure.
* Facilitated end-user training to change SQL Server to Native SQL.
* Consulted by team of developers to complete the migration effort from Oracle Database to IBM Cognos Model.
* Consulted by team of developers to complete the migration effort from SQL Server Database to IBM Cognos Model.
* Consulted by team of developers to complete the migration effort from Netezza to IBM Cognos Model.
* Migrated a database in Oracle to Netezza using IBM InfoSphere Datastage workflows and database objects.

FIKKY (SOCIAL MEDIA INITIATIVE)
Responsible for project delivery and business development through pre-sales support, developing go-to-market strategies,
management consulting and community involvement.
* Developed for Android project, upload to market and maintenance.
* Worked on creation of android application based on sign up and login, profiling and editing.
* Defined avatar uploading and displaying, material designing besides that.
* Arranged kinda camera settings and creation of camera interface, in parallel with video recording and transfering to
server.
* Consequently applying of video by users and creation of commenting.