Ysmael Reyes

Data Analyst at Professor Torsten Calvi Corp.
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Metro Manila, National Capital Region, Philippines, PH
Languages
  • English -
  • Tagalog -

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Accelerate Your Career with Python: A FREE 2-hours Masterclass for College Students and Professionals
    CloudxLab
    May, 2023
    - Nov, 2024
  • Everything about GPT4: Know its possibilities, limitations and advantages over GPT3
    CloudxLab
    Apr, 2023
    - Nov, 2024
  • Numpy Module Programming
    MindLuster
    Apr, 2023
    - Nov, 2024
  • SAS in Practice Programming
    MindLuster
    Apr, 2023
    - Nov, 2024
  • SQL for Data Science
    Great Learning
    Apr, 2023
    - Nov, 2024
  • Web Scrapping with Python
    Great Learning
    Apr, 2023
    - Nov, 2024
  • Advanced Microsoft Excel
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Apache Storm
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Bash Scripting Solutions
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Basics of ETL Testing Training
    MindsMapped Consulting
    Mar, 2023
    - Nov, 2024
  • Beautiful Soup 4
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Big Data
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Big Data Analytics Using Apache Spark
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Data Analysis Using PySpark
    Great Learning
    Mar, 2023
    - Nov, 2024
  • Data Analyst
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Data Visualizations
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Data Warehouse and Business Intelligence
    MindsMapped Consulting
    Mar, 2023
    - Nov, 2024
  • Data Warehouse with SQL
    MindsMapped Consulting
    Mar, 2023
    - Nov, 2024
  • Data Warehousing for Beginners
    MindsMapped Consulting
    Mar, 2023
    - Nov, 2024
  • Go Design Patterns
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Golang
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Google Data Studio for Beginners
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Google Tag Manager
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Hadoop Administration
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Hadoop: Map Reduce
    Great Learning
    Mar, 2023
    - Nov, 2024
  • IT for Business Success
    HP LIFE
    Mar, 2023
    - Nov, 2024
  • Linux Shell Scripting Automating Command
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Linux Unix Commands
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Mastering Microsoft Power BI
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Microsoft SQL Server SSIS
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Oracle BI Cloud Service Training
    MindsMapped Consulting
    Mar, 2023
    - Nov, 2024
  • Pandas Programming
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Power BI Fundamentals Tutorial
    MindsMapped Consulting
    Mar, 2023
    - Nov, 2024
  • Power BI Training for Cloud
    MindsMapped Consulting
    Mar, 2023
    - Nov, 2024
  • Presenting Data
    HP LIFE
    Mar, 2023
    - Nov, 2024
  • Python Matplotlib
    Great Learning
    Mar, 2023
    - Nov, 2024
  • Python Pandas
    Great Learning
    Mar, 2023
    - Nov, 2024
  • Python Programming Step-by-Step
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Responsive Design
    MindLuster
    Mar, 2023
    - Nov, 2024
  • SQL Server BI and Data Analytics
    MindsMapped Consulting
    Mar, 2023
    - Nov, 2024
  • Skills for Creating Websites
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Splunk Advanced Visualization Tutorials
    MindsMapped Consulting
    Mar, 2023
    - Nov, 2024
  • Splunk Security App Tutorials
    MindsMapped Consulting
    Mar, 2023
    - Nov, 2024
  • Step by Step SSAS Tutorial
    MindsMapped Consulting
    Mar, 2023
    - Nov, 2024
  • The Complete Splunk Fundamentals Training
    MindsMapped Consulting
    Mar, 2023
    - Nov, 2024
  • Ubuntu Server Setup
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Usability Testing
    MindLuster
    Mar, 2023
    - Nov, 2024
  • Advanced SQL
    Great Learning
    Feb, 2023
    - Nov, 2024
  • Azure Course
    Great Learning
    Feb, 2023
    - Nov, 2024
  • Basics of Python Data Wrangling
    Great Learning
    Feb, 2023
    - Nov, 2024
  • Business Applications of Data Science, AI, and ML
    Great Learning
    Feb, 2023
    - Nov, 2024
  • Data Literacy Essentials
    SAS
    Feb, 2023
    - Nov, 2024
  • Data Science with Python
    Simplilearn
    Feb, 2023
    - Nov, 2024
  • Data Visualization with Power BI
    Great Learning
    Feb, 2023
    - Nov, 2024
  • GO Programming Language
    Great Learning
    Feb, 2023
    - Nov, 2024
  • Introduction to Machine Learning with Scikit-Learn
    Data School
    Feb, 2023
    - Nov, 2024
  • Introduction to NoSQL
    Great Learning
    Feb, 2023
    - Nov, 2024
  • Managing and Using the SAS® Customer Intelligence Common Data Model
    SAS
    Feb, 2023
    - Nov, 2024
  • Marketing and Retail Analytics
    Great Learning
    Feb, 2023
    - Nov, 2024
  • Marketing and Retail Analytics - Advanced
    Great Learning
    Feb, 2023
    - Nov, 2024
  • R for Data Science
    Great Learning
    Feb, 2023
    - Nov, 2024
  • SAS Energy Forcasting Solution: Introduction
    SAS
    Feb, 2023
    - Nov, 2024
  • Splunk Tutorial
    Great Learning
    Feb, 2023
    - Nov, 2024
  • Statistical Analysis
    Great Learning
    Feb, 2023
    - Nov, 2024
  • Tableau Training
    Simplilearn
    Feb, 2023
    - Nov, 2024
  • Big Data Hadoop and Apache Spark Developer Training
    Simplilearn
    Jan, 2023
    - Nov, 2024
  • Business Analytics with Excel Beginner Course
    Simplilearn
    Jan, 2023
    - Nov, 2024
  • Designing the Database to Support SAS Marketing Automation
    SAS
    Jan, 2023
    - Nov, 2024
  • Optimizing Your Work with Microsoft 365
    LinkedIn
    Jan, 2023
    - Nov, 2024
  • Predictive Analytics Essential Training: Data Mining
    LinkedIn
    Jan, 2023
    - Nov, 2024
  • R Essential Training: Wrangling and Visualizing Data
    LinkedIn
    Jan, 2023
    - Nov, 2024
  • Tableau Data Visualization Basics Tutorial
    Simplilearn
    Jan, 2023
    - Nov, 2024
  • Career Essentials in Data Analysis by Microsoft and LinkedIn
    Microsoft
    Dec, 2022
    - Nov, 2024
  • Career Essentials in Software Development by Microsoft and LinkedIn
    Microsoft
    Dec, 2022
    - Nov, 2024
  • Career Essentials in System Administration by Microsoft and LinkedIn
    Microsoft
    Dec, 2022
    - Nov, 2024
  • Collaborating with Microsoft 365
    LinkedIn
    Dec, 2022
    - Nov, 2024
  • Introduction to Career Skills in Data Analytics
    LinkedIn
    Dec, 2022
    - Nov, 2024
  • Introduction to Career Skills in Software Development
    LinkedIn
    Dec, 2022
    - Nov, 2024
  • Learning Data Analytics Part 2: Extending and Applying Core Knowledge
    LinkedIn
    Dec, 2022
    - Nov, 2024
  • Learning Data Analytics: 1 Foundations
    LinkedIn
    Dec, 2022
    - Nov, 2024
  • Learning Data Science: Understanding the Basics
    LinkedIn
    Dec, 2022
    - Nov, 2024
  • Managing Data with Microsoft 365
    LinkedIn
    Dec, 2022
    - Nov, 2024
  • Managing Projects with Microsoft 365
    LinkedIn
    Dec, 2022
    - Nov, 2024
  • Programming Foundations: Beyond the Fundamentals
    LinkedIn
    Dec, 2022
    - Nov, 2024
  • Programming Foundations: Fundamentals
    LinkedIn
    Dec, 2022
    - Nov, 2024
  • Project Management Foundations: Schedules
    LinkedIn
    Dec, 2022
    - Nov, 2024
  • The Non-Technical Skills of Effective Data Scientists
    LinkedIn
    Dec, 2022
    - Nov, 2024
  • What Is Business Analysis?
    Linkedin Learning Courses®
    Dec, 2022
    - Nov, 2024
  • Typing certificate
    Ratatype
    Jan, 2022
    - Nov, 2024
  • Typing certificate
    Ratatype
    Jan, 2022
    - Nov, 2024
  • Introduction to Neural Network
    Great Learning
  • Managing Project Stakeholders
    Linkedin Learning Courses®
  • Optimizing Your Work with Microsoft 365
    Microsoft
  • SAS in Practice in Python Programming
    MindLuster

Experience

  • Professor Torsten Calvi Corp.
    • Design
    • 1 - 100 Employee
    • Data Analyst
      • Jul 2019 - Present

      I am into Data Science, a Data Analyst doing Data Analysis with Python and Pandas using Jupyter Notebook (on Linux), while utilizing both Microsoft Excel Power Query and Microsoft Power BI (on Windows). I primarily spend my time data cleaning, transforming data and performing data analysis.● Extracting, performing data cleaning, transformation and data analysis tables and visualization charts.● Initiated Excel Automation Data Analysis reporting presented into Microsoft Excel spreadsheet format.● Instituted automated preparation of Contract proposal documentation using LaTex.● Instituted the automated preparation and presentation of monthly man-hour reports for all active company projects into Microsoft Excel using Python. Show less

    • Information and Database Staff (I.T. Department)
      • Jul 2009 - Jul 2019

      ● Active in the preparation of Gantt Chart Schedules using Taskjuggler program for the company's contract proposal agreements. Also as needed support to Project Managers, and Project Captains for on-going Project update status report information. See details on 'Projects' below.● Administrator of the e-timesheet system using open-source software dotProject. From user-account profiles; security and access privileges; conducting user's training; and back-end data extraction from MySQL to Spreadsheet reporting.● Actively performing data cleaning using awk, sed and related bash scripting, and achieved collating 3 separate databases (from MS Access, dotProject and our present Dbase) into one central database.● Instituted a multi-media information dissemination system (and also the Administrator/ developer) via desktop-client web page (PTCCNET) intranet system using CMS (JOOMLA). Is also the web hosting page to this e-timesheet system and other similar office related information.● Initiated automating Microsoft Excel, LibreOffice spreadsheet.● Linux user since November 2006 using several variants of linux (distros) and utilized VMware softwares.● Optimized pdf file sizes, by reducing large format documents to quality A4-papersizes. Achieving work delivery efficiency to Clients/ stakeholders.● Standardized layout of office forms, calling cards, and Company ID's. ● Achieved quality type-setting documentations using LaTex software. and putting together a 'Drawing Standard Manual' and 'Employee's Manual'. Show less

  • LINUX and Open Source Applications Initiative
    • Enthusiast
      • Nov 2006 - Present

      ● Active Linux enthusiast to popular Linux variants like Ubuntu and Debian. ● Achieved presenting efficient delivery of reports in Microsoft Excel while the underlying processes of mathematical calculations and formulas from utilizing awk, sed and command line tools in Bash scripting. ● Developed many useful scripts (bash).One of the useful script is generating a photo mosaic from a stock of photos; automating music album metadata information and album art while extracting mp3 from video file at single command line. ● Actively managing CMS (Content Management System) JOOMLA - an intranet network for deploying information to every office user workstation. Show less

  • Higher Rock Christian Church
    • Timog, Quezon City
    • Volunteer
      • Mar 1996 - Present

      ● Committed member of this local church --a biblical evangelical church-- and submitted to: the spiritual disciplines of prayer; to avenues of discipleship (such as attending regularly to bible study group and Sunday worship service gatherings; Bible Seminars and conferences), and also submitted to the instituted ordinance of the Lord's Supper. ● Involved in the fellowship and accountability of believers, and the ministry of assisting in the orientation for new comers. ● Volunteer for the Web Committee (Technical) - CMS (JOOMLA) Website. (higherrockchurch.org) [ The Local Church and Why It Matters http://www.gty.org.uk/blog/B130111 John MacArthur on the Importance of Church Membership http://www.gty.org.uk/blog/B130107 Church Membership in the New Testament http://www.gty.org.uk/blog/B130114 ] Show less

  • Actual Work Experience
    • Adept in using Microsoft Excel
      • Nov 1991 - Present

      Adept in Microsoft Excel, LibreOffice/ OpenOffice Spreadsheet. Over 20-years of actual work related experience in utilizing: ● DATA CLEANING commands (like TRIM, LEFT, RIGHT, CLEAN); Converting to proper data types (like INT, STR, FLOAT and DATE-TIME) ● DATA TRANSFORMATION (like IF-ELSE STATEMENT, CONDITIONAL Formatting, CONCATENATE, FIND, SUBSTITUTE, SUMIF, COUNTIF, VLOOKUPS, PIVOT Tables.) Adept in Microsoft Excel, LibreOffice/ OpenOffice Spreadsheet. Over 20-years of actual work related experience in utilizing: ● DATA CLEANING commands (like TRIM, LEFT, RIGHT, CLEAN); Converting to proper data types (like INT, STR, FLOAT and DATE-TIME) ● DATA TRANSFORMATION (like IF-ELSE STATEMENT, CONDITIONAL Formatting, CONCATENATE, FIND, SUBSTITUTE, SUMIF, COUNTIF, VLOOKUPS, PIVOT Tables.)

  • Professor Torsten Calvi Corporation
    • Information and Database Staff
      • Jul 2009 - Jul 2019

      ● Presently developing a software for automating 2D Drawings. First in the office and first in the industry.● Optimizing office applications by building and using command line Bash Scripts.● Personally developed an efficient automated system of creating company ID's with matching pertinent staff data records and ID photos using only bash scripts on a command line console and no other user-interface. Same also for company calling cards for staff personnel.● Initiated and designed an information dissemination system for the entire office via intranet using Joomla as the interface. Also the administrator for this system.● Administrator for an open-source online time sheet system initiated for the office using Dotproject. Orientation and training for new users.● Extracting efficiently data from the back-end of Dotproject database into csv format from terminal console using personnally developed bash scripts, stream editor and csv manipulations for documentation reporting. ● Continues to summarize data and prepares Gantt chart schedules for the company using Taskjuggler program.● Optimizes PDF documents and still maintaining the same output quality.● Continues to be the checker for the visualization exams for applicants. Show less

    • Training Assistant
      • Apr 2008 - Jul 2009

      ● At this time, the company saw a need to put up a Training Committee to over see and look after the growth in terms of technical skills in the office. Aimed to have a system of training for both newly hired personnel and existing regular staff. Focused more on the skills development and on how to share standards of learning in the industry of curtain wall drafting. Am tasked here only to coordinate and distribute inter-department communication.● Tasked still as the only personnel skilled and efficient to prepare gantt chart work schedules using Taskjuggler on Linux. Show less

    • Project Coordinator
      • Nov 2006 - Apr 2008

      ● Customer support to our clients - coordinating informative written response correspondences to email queries daily received from clients concerning the current project documentation needs.● Linux initially introduced using a variant from OpenSuse with Taskjuggler natively installed. Thus am the only personnel staff (with the I.T. as an exception) assigned with two computers on my desk: one in Windows and Linux on the other.● Tasked to learn, study and to master the use of Taskjuggler, in order to prepare gantt chart work schedules as documentation support to our contracts department for client proposals. Show less

    • Documents Controller
      • Aug 2001 - Nov 2006

      ● Upon hiring in this company, Documents Control department was opened and then established, a nerve center to monitor in-coming and out-going email communications and distribution of such document to the concerned inter-office departments. Supporting initially to a staff of 20, then later 100 personnel staff.● Responsible for retrieving and sending electronic documentation to our clients via email or ftp site. There are many times in the past, in my own initiative would open, clean by removing an unessential reference drawing from a drawing work space (not reflected on the paper space), then purging and auditing an electronic drawing file to sensibly reduce file size before sending to clients.● Also comes with the trade to research for freeware softwares that maybe useful to the office.● First to introduce and initiate in this office a system of converting electronic files to pdf format directly from a working office application (not from a scanned printed out output to pdf), and also technical graphs and charts are scanned as images to jpeg formats for data management.● First to introduce a system for file and data management on a central server.● First to introduce and designed for the company a working payroll system in microsoft excel, a small scale managing for 50 to 100 staff personnel.● First to introduce and designed for the company an electronic timesheet recording system on microsoft access, all data of which is stored on a central server, while the data entry point is available to all personnel on every desktop in the office. Show less

  • Home Projects Enthusiast
    • San Mateo, Rizal
    • Modular Kitchen/ Entertainment-Media Center Cabinetry System
      • Apr 2010 - May 2010

      ● Custom Design and Fitting-Out Works of Kitchen/ Media-Entertainment Center kinds of Modular Cabinetry System: From conceptualizing, planning stages to innovative and modern design creations that meets the household needs. ● Utilizing study materials that lasts, marine plyboards plastic laminates, concealed type hinges, pull-out mechanisms, and cabinet accessories. ● Custom Design and Fitting-Out Works of Kitchen/ Media-Entertainment Center kinds of Modular Cabinetry System: From conceptualizing, planning stages to innovative and modern design creations that meets the household needs. ● Utilizing study materials that lasts, marine plyboards plastic laminates, concealed type hinges, pull-out mechanisms, and cabinet accessories.

  • Tconspec Construction
    • Assisting Engineer
      • Dec 2000 - Aug 2001

      Temporarily worked as a fieldwork supervisor for a friend of mine, monitoring renovation construction activity and also prepares construction cost estimates. Temporarily worked as a fieldwork supervisor for a friend of mine, monitoring renovation construction activity and also prepares construction cost estimates.

  • Narel Construction Incorporated
    • Joval Bldg., No.52 National Road, Barangay Putatan, Muntinlupa
    • Quantity Surveyor
      • Jun 2000 - Sep 2000

      Worked temporarily as quantity take-off estimator for medium-cost housing projects for the company. Worked temporarily as quantity take-off estimator for medium-cost housing projects for the company.

  • Punzal Steel Corporation
    • 158 West Avenue, Quezon City
    • Field Engineer
      • Mar 2000 - Jun 2000

      Temporarily worked as a field engineer for a low cost housing subdivision project supervising contracting works for supply and installation of tiling works. Temporarily worked as a field engineer for a low cost housing subdivision project supervising contracting works for supply and installation of tiling works.

  • Yutakasa Chabad Incorporated
    • No.10-12 Sunset Drive, Sunset Village, Barangay Tambo, Paranaque City
    • Cost Engineer
      • Apr 1997 - Oct 1999

      ● Assist in the automation of excel programs for a quarry feasibility study. ● Assist in the layout and preparation of pertinent construction and qualitative engineering documentations. ● Assist in the automation of excel programs for a quarry feasibility study. ● Assist in the layout and preparation of pertinent construction and qualitative engineering documentations.

  • New Riviera Hotels Development Corp
    • 3001 Roxas Boulevard, Manila | Phone (+63) 5237011
    • Project Cost Engineer
      • Jul 1995 - Apr 1997

      ● Prepares Gantt Chart Schedule monitoring for the Traders hotel renovation project. ● Prepares Cost Analysis in Microsoft Excel, monitoring the Budget Vs. Expenses of the renovation project. ● Reviews the billings of all the trade subcontractors for the renovation project. ● Prepares Gantt Chart Schedule monitoring for the Traders hotel renovation project. ● Prepares Cost Analysis in Microsoft Excel, monitoring the Budget Vs. Expenses of the renovation project. ● Reviews the billings of all the trade subcontractors for the renovation project.

  • DVH Builders Incorporated
    • Cost Engineer
      • Feb 1993 - Jul 1995

      ● Coordinates and prepares progress accomplishment billings for both to the clients and subcontractors.● Prepares quantity take-off estimates documentation from bid plans and documents.● Creates and develops automation programs for accounting documentation (billings and cash-flow); construction progress documentation (Gantt Chart Schedules; S-Curve charts; and Project Cash Flow)

    • Technical Staff/ Project Coordinator
      • Nov 1991 - Feb 1993

      ● Project-based assignment to coordinate construction documentation between trade contractors and the Project Management Group.● Coordinates contractors' progress billings and construction documentation.

Education

  • Technological Institute of the Philippines
    Bachelor of Sceince Degree in Civil Engineering, Licensed; Grantee of the Guillermo de Vega Scholarship (for one semester)
    1985 - 1990
  • Trinity University of Asia (formerly Trinity College of Quezon City)
    Secondary School (High School), Outstanding Academic Achivement for Academic Excelence - First Honors of the Class/ Section
    1981 - 1985
  • Quirino Elementary School
    Elementary School, Elementary School
    1975 - 1981

Community

You need to have a working account to view this content. Click here to join now