Data Analyst
Current- Performed PDF extraction using python and converted the extracted data to JSON format for storage and further analysis and ingestion to database by following the business rules given.- Performed Engineers Data Model (EDM) database assessment for client as a part of data migration exercise from different databases particularly on Operational Data.- Performed analysis and assessment on EDM database to improve the understanding of the data model, structure, quality and inconsistencies for database clean-up exercise.- Performed analysis on OpenWells and COMPASS as a front-end application to EDM database to ensure data integrity, data hygiene and data visibility on the application followed the business rules.- Conducted a proof-of-concept (POC) session to showcase the effectiveness of well survey data migration from different database through back-end method on EDM database to client.- Wrote data migration scripts from different sources of database to target database using Pentaho.- Wrote database clean-up scripts that must follow the business rules given which includes data wrangling, and data transformation using Pentaho.- Wrote an automated Pentaho scripts that can perform QA/QC through back-end on data migration exercise that contributed to the efficiency of the project delivery.
