Blessie Labayna

Blessie Joy M. Labayna Data Engineer --Quezon City, Philippines linkedin.com/in/blessie-joy-labayna-9229a014b/ Professional Summary • • • • • • • • Passionate and dedicated Data Engineer with 5 solid years of experience, involved in Requirement Gathering, Analysis, Design, Development, Testing, Production Deployment and Support. Adept in SQL, Data Integration, Ingestion, ETL and Data Warehousing concepts. Strong experienced in Data Modelling and Big Data technologies (Hadoop, Nifi, Hive, Splunk, MongoDB). Strong experienced in Data Visualization using Microsoft Power BI. Experienced in Agile Methodology (Scrum) and Waterfall SDLC. Experienced in Salesforce and web development using Java and C#. A well-organized, eager to learn, goal-oriented, highly-motivated effective team member with excellent communication, time management and problem solving skills. Ability to work well under pressure and consistently meets deadlines and targets while delivering high quality work. Technical Skills Tools: Nifi, Hadoop, Hive, MongoDB, Splunk, Oracle, SSIS, MS SQL Server, MS Azure SQL Database, MS Azure Cosmos DB, MS Office, MS Power BI, MS Power Automate, Salesforce, Shell Scripting, Jira, Confluence Query Language: SQL, SOQL, HiveQL Programming Languages: Java, C#, Python Professional Experience Manulife IT Delivery Center Asia, Inc.- Asia Data Office Data Engineer October 2018 – Present Responsibilities: • Developed Nifi flows that integrates data from DB2, Salesforce, Oracle, Azure Cosmos DB API for MongoDB, & SFTP. Utilized Splunk to monitor Nifi flows, and Monitoring Bulk Data Load Jobs in Salesforce to monitor bulk upsert jobs. • Worked on Nifi framework centric environment that ingests data to HDFS. • Created HiveQL and SOQL scripts to validate ingested data. • Analyze raw data provided by the internal projects of Manulife and create and optimize scalable database schema. o Initiated and developed a web application called Employee Portal using available tools such as C# and MS SQL to provide solutions to existing problems like incorrect and inconsistent data. Designed and built a centralized repository and implemented data validation processes to produce high-quality data to be used in building dashboards. Acted as the main and only developer for both front-end and back-end. • Created SSIS packages and stored procedures to transform and load data from Excel into relational database tables. o Successfully and effectively proved the automation process of ingesting data from an Excel file with a dynamic format into a database for better reporting/data visualization using SSIS & SQL. This success had turned what only started as a proof of concept to a valid internal project. • Conducted SSIS and SQL trainings to help the team improve its efficiency, its team morale and reduce supervisory needs when working with data ingestions and data transformations. • Created a data model, DAX, reports and dashboard in Microsoft Power BI. • Created Microsoft Power Automate Workflows to store Teams Planner data to SharePoint List, Excel and SQL Server. • Created dataflow using Composable Analytics for data ingestion from Oracle & Salesforce to Microsoft Azure SQL Database. Key Achievement: Turned proof of concepts into a valuable product for the company, such as the Utilization Dashboard & Employee Portal. Designed and developed a Nifi flow that loads data from DB2 to Azure Cosmos DB API for MongoDB. Smart Communications, Inc. & Amdocs Philippines Incorporated - CRM Software Development Analyst January 2016 – October 2018 Responsibilities: • Developed and maintained SQL scripts and stored procedures for report generation. • Designed and built database objects like tables, views, materialized views, and stored procedures to be used for reporting. • Used indexes, hints, and bulk collections to improve performance during data retrieval and manipulation. • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. • Developed web pages for reporting of stores transactions using Java. Key Achievement: Project DISC (Digital Scoreboard) - Designed and implemented ETL processes to generate near real-time sales & productivity reports which eliminated the manual tasks by 100% using Oracle PL/SQL. And also, integrated the existing queuing system to the new Scoreboard using Java API and Shell Script. Certifications Trainings Microsoft Certified: Azure Data Engineer Associate Big Data 101 (Fundamentals) June 2021 December 2020 Microsoft Certified: Azure Fundamentals Hadoop 101 (Fundamentals) June 2021 December 2020 Microsoft Certified: Azure Data Fundamentals Python for Everybody Specialization July 2021 March 2021 Microsoft Certified: Azure AI Fundamentals Agile Principles and Methodologies July 2021 December 2020 Education Bachelor of Science in Information Technology Far Eastern University, Diliman, QC, PH • • Dean’s Lister AY 2014 – 2015 Auditor of BSIT Organization Year 2014