Jared Dominic Caraan

Jared Dominic V. Caraan Github: : https://github.com/Jared-Caraan WORK EXPERIENCE (Data Engineer - 2 years, Data Science - 3.5 years) Arch Global Services Inc., Philippines— Junior Data Engineer MAY 2022 - PRESENT Reinsurance Data Hub ● ● ● ● Collaborated on the development of a versatile pipeline capable of ingesting various types of MGAs (Managing General Agent) from flat files into Snowflake. By co-authoring this pipeline, we facilitated seamless data ingestion, enhanced scalability, and promoted consistency in data management practices across the organization. Developed a robust solution to parse XML data and transform it into a tabular format suitable for ingestion into Snowflake. Designed and deployed Streams and Tasks within Snowflake to effectively archive deleted rows from tables. From this, the organization ensured comprehensive data governance, enabled historical data analysis, and maintained data integrity by preserving deleted records for auditing and compliance purposes. Developed comprehensive test cases for the User Acceptance Testing (UAT) phase of an end-to-end validation pipeline, ensuring thorough validation of system functionality and adherence to requirements prior to deployment into production. Azure Deployment and Migration ● ● Implemented Azure DevOps pipelines to automate the deployment of objects to various environments within the development lifecycle. By leveraging Azure DevOps pipelines, the team achieved streamlined deployment workflows, reduced manual intervention, ensured consistency across environments, and accelerated the delivery of software artifacts to production and other target environments. Orchestrated and oversaw the migration of resources between different regions within the Azure environment. MDI Novare Technologies, Philippines— Senior Data Scientist Lead SEPTEMBER 2021 - MARCH 2022 Employee Retention Analysis ● Developed a comprehensive exploratory data analysis report highlighting the relationship between total learning hours and years of tenure within the organization. This analysis facilitated informed decision-making processes and identified potential insights into employee engagement, retention, and professional development within the organization. Team Lead ● ● Produced a comprehensive deck or rulebook outlining best practices and guidelines for team members interacting with the Google Cloud Platform (GCP). By providing clear and concise guidance, the deck or rulebook empowered team members to effectively and efficiently leverage GCP services while ensuring adherence to organizational standards and protocols. Lead daily standups with the team to align ourselves with the latest updates on our respective tasks. This helps the team discuss their blockers, concerns, and achievements. DXC Technology, Philippines— Junior Data Scientist JULY 2018 - SEPTEMBER 2021 Service Now KB Automation ● ● ● Developed and deployed a classification model capable of predicting the optimal resolution for raised issues. This initiative led to a remarkable reduction in story points from 8.75 to 1.09, resulting in significant cost savings estimated at approximately $2000. Leveraged a clustering algorithm to categorize issues based on their descriptions, unveiling underlying patterns and similarities. This approach enhanced organizational understanding of issue dynamics and informed targeted problem-solving strategies. Designed and produced a comprehensive report detailing the performance metrics of the classification tool. This report provided stakeholders with valuable insights into the effectiveness and efficiency of the implemented solution. Knowledge Transfer and Training ● ● Conducted knowledge-sharing sessions to educate an external team on machine learning concepts and methodologies. This initiative empowered the team with the necessary skills and understanding to leverage machine learning techniques effectively in their respective projects, fostering a culture of continuous learning and innovation. Orchestrated and led a comprehensive 3-day bootcamp focused on Python Pandas, basic statistics, and an introduction to machine learning concepts. Manila, Philippines (--m SKILLS Languages ● Python (Primary) ● SQL (Primary) ● R Data Engineering ● Data Warehouse ● Snowflake ● ETL / ELT ● SCD ● CICD Cloud ● ● ● Azure (Primary) GCP AWS Data Science ● Preparation ● Transformation ● Visualization ● AI/ML Others ● ● ● ● Databases MS Products Google Products Version Control LANGUAGES ● Filipino ● English CERTIFICATIONS ● PCEP-Entry Level Python Programmer (March 2022) EDUCATION University of Santo Tomas, BS Computer Science July 2014 - June 2018