Ace Ramos

Business Analyst @ Government of Alberta

About

I started my career in the Philippines; I have worked in the software industry for seven years and developed numerous custom software for insurance companies. And as an intern today, I have a lot of exposure in creating meaningful data-driven reports, in-person-to-person requirements gathering sessions, analysis of prerequisites, and outcome presentations. I am excited to share and apply my competencies for your company and my growth as well.

Country

Canada

City

Edmonton

Industry

Information Technology & Services

Skill

ASP.NET, Microsoft SQL Server, Microsoft Power BI, C#, JavaScript, PHP

Experience

Business Analyst

Government of Alberta

2022-11 - Present · 3 yrs 11 mos

Technical Solution Analyst

PCL Construction

2022-1 - 2022-11 · 11 mos

Edmonton, Alberta, Canada

Technical Solution Analyst Student

PCL Construction

2021-5 - 2021-12 · 8 mos

Edmonton, Alberta, Canada

• Utilized T-SQL (Microsoft SQL Server), Power BI, Data Analysis Expressions (DAX) language, Power Query, and Excel in developing and maintaining Power BI report dashboards • Maintained the SQL Server Database by creating complex SQL views that ease up the querying of data • Extracted information from the corporate scale database, then transforming and loading those data to support different PCL districts on data-driven business decisions • Experienced in one on one or group meetings with different PCL Constructors District’s Proposal Coordinator, Workforce Supervisor, HRPD Advisor, and HRPD Manager in discussions of requirements and suggestions for the Power BI dashboards to be created • Assigned to do some code reviews in one PCL’s proprietary website based on ASP.NET, and Angular • Developed a Human Resource Management System website application mock-up that has a direct integration of Power BI diagrams

Content Specialist II

Reed Elsevier Philippines

2013-7 - 2019-9 · 6 yrs 3 mos

• Hired as a software tester and was crossed-trained less than a year and became a Quote Routine (Delphi-based) programmer; used Object Pascal-based Rate Programming Language • One of only few employees to be promoted as Content Operations Specialist II • Trained and supported a total of 15 new hired programmers in a span of 4 years. • Collaborated regularly with company’s business unit and client executive in the United States • Co-authored programming training materials that is being used in training newly hired programmers • Initiated a yellow belt project that improved the turn around time of bugfixes for about 50%

Education

NAIT (Northern Alberta Institute of Technology)

Information Technology

2020-9 - 2021-12 · 1 yr 4 mos

• Enrolled full-time while working on a part-time job • Focused on developing software through Unified Modeling Language patterns. It provides a standard way to visualize the design of a system, so that ideas could be transformed into codes efficiently • Utilized .NET Framework/Core, C#, SQL (Microsoft SQL Server) technologies in developing custom projects

Bulacan State University

Computer Software Engineering

2008 - 2013 · 5 yrs

Developed an Arduino Integrated Chip Logic Analyzer, deployed in the school laboratory, that is being used by the students on depicting how integrated chips work. Based on C programming language that analyses the timings of each of the most common integrated circuits and displays it on a Java-based application