Post Job Free
Sign in

Orientation Leader Computer Programmer

Location:
Toronto, ON, Canada
Posted:
February 26, 2022

Contact this candidate

Resume:

ELTON AGUIAR

** ****** ****** ****#****

Toronto, Ontario

M5G 2H5

647-***-****

***********@*****.**

Reporting Analyst Profile

Work with reporting using business intelligence(BI) tools such as PowerBI, QlikSense

Familiarity with Metrolinx IT Systems with 4+ years of experience on Reporting for ITSM(IT Service Management) e.g. working with ServiceNow, PrestoBI/ RAMS reporting, including TVM transactions/revenue, and Presto card transactions

Reporting (including Metrolinx experience) on monthly KPI scorecards, dashboards and PowerPoint slide presentation for I&IT ITSM(IT Service management)

Extensive experience working with SQL (Microsoft SQL Server) e.g. reports based on CUIC (Cisco Unified Intelligence Centre) database

10+ years of reporting work experience with Microsoft Excel(pivots, VLOOKUPs, VBA macros), Microsoft Access, Microsoft PowerPoint, VBA macros, VLOOKUP, ServiceNow Performance Analytics and reporting

Knowledge of current Metrolinx systems and monitoring tools such as ServiceNow, HPE Opsbridge, Cisco Unified Intelligence Centre(CUIC)

Strong experience in automating reporting with SQL queries, BI tools, VBA macros, API

WORK EXPERIENCE

ITSM Reporting Team Lead(contract) January 2018 - present

Metrolinx

Mentoring and training a team of 2 other reporting analysts on QlikSense, Excel based reports to produce dynamic dashboards and monthly slide presentations

Various research and development QlikSense development of KPI

Responsible for the developing IT Service Level statistics through data mining from various IT tools including (Service Now, Excel Data Sheets, SQL Server, Hadoop, HPE Opsbridge, Cisco Unified Intelligence Centre)

Created VBA macros to save work effort and reduce chance for errors in critical metrics related to On-time performance, and reduce manual work effort for mappings Configuration items(Cis) to applications

Performed Data Reconciliation across ServiceNow dataset and various configuration item(CI) related datasets, including reports on duplicates, redundant names, etc.

Performed Quality Assurance(QA) for a critical systems (COE) dashboard with a high visibility to various business units and executives

Analyzed metrics and performed compliance for accuracy and data integrity between reporting systems. Design/Generate tracking systems and/or monitoring tools to validate data

Analyzed statistics to identify trends, and actionable opportunities and recommendations for continuous improvements

Assembled statistics into dashboards, visualizations, and power point presentations for IT Leadership and Business Reviews

Produced metrics into standardize reports, and communicate those understanding with confidence. Review report findings, both verbally and in writing, to IT Service Management Team

Senior Business Analyst(contract)

CIBC – Business Managed Technology January 2017– November 2017

Directed weekly meetings to support managers of finance and treasury on remediating gaps identified by OSFI in compliance of critical applications with BMT requirements such as inventory management, access control, input checks, backup and recovery, change control, application remediation and development, user guide documentation

Assisted and reviewed compliance gaps in XLAudit reports of BMT applications with business users such as formulas with constants, formula errors, incorrect range names

Developed a set of VBA macros in an Excel ribbon that allowed quickly performing BMT related tasks and reduced turnaround time of reviewing XLAudit reports by allowing a reduction a work from business users in reviewing 600K rows to view to around 100 items

Assisted users with knowledge of BMT scoping criteria such as financial statement impact, regulatory purposes to manage their inventory

Worked with technology to facilitate completion of ServiceNow and DataPrivilege requests for folder management such that network paths for BMTs are compliant with access control and entitlement reviews are appropriately completed

Data Scientist (contract) June 2016 – October 2016

Royal Bank of Canada – Capital Markets

Conducted weekly meetings with various stakeholders for key projects related to server compliance, source code risks and vulnerabilities, application access control reporting

Responsible for preparing a Capital Markets(CM) Technology Risk Profile providing a comprehensive view of risk across the associated business units

Arranged meetings with key stakeholders for regulatory requirements for RBC’s Living Will and Resolution Plan submission to regulators, by organizing meetings with the VP of Finance, and various regulatory stakeholders to determine requirements and associated legal entities

Used the RSA eGRC Archer platform to consolidate server compliance data to show a list of servers associated to which department head that are compliant, or failing compliance due to open shares, vulnerabilities, technical security standards

Created data feeds to pull data from various sources into eGRC Archer to consolidate data into dashboards and spreadsheets for employees, application, transits, geography

Created VBA macros to consolidate data from several tabs in a group of spreadsheets in a folder, into a summary tab

Prepared and presented monthly Key Risk Indicators (KRIs) to track changes in risk ranking versus the risk appetite thresholds

Senior Report Fraud Analyst (contract) September 2015 – June 2016

Bank of Montreal

Created an Excel, VBA end-user controls solution to limit editing of a shared workbook using role-based permissions on a Fraud data project involving a shared workbook with multiple users editing simultaneously

Worked with various managers of business lines to gain sign-off for Fraud KRI for regulatory reporting for OSFI requirements, using thresholds of fraud losses using methodology based on an approved risk appetite per business sector

Used SQL queries in MS Access to parse from data from 200 TSYS data pull text files

Used SQL Server 2012 for a deposit fraud detection system sourced from Norkom/MECH

Automated monthly slide decks with VBA code from charts in Excel workbooks for the Fraud losses which had direct visibility from the Vice President of Fraud Management and Enterprise Authentication, head of Retail Banking, head of Retail Payments, Commercial Lending

Produced a monthly summary pivot table to allow the Manager of Fraud Analytics and MIS to quickly consolidate data from various sources

Worked on Excel forecasting models to predict thresholds for fraud losses for risk management and fraud loss planning purposes

Designed and maintained quarterly Excel spreadsheets for Key Risk Indicators(KRIs) per OSFI requirements which facilitated line of business owners at the bank to reduce risk and ultimately fraud losses, unusually high card fraud, breaches across their streams such as Retail Cards, Commercial Cards, Lending using a standard methodology to evaluating risk

Worked on a Detailed Level Plan(DLP) financial spreadsheet for annual budgeting purposes to help the Manager of Finance Reporting and Forecasting to populate and ensure accuracy of the NIX budget allocating FTEs across new cost centers during organizational restructuring

Built macros and quality checks part of a ‘Monthly Performance File’ to help with production of monthly slide decks for reporting fraud loss data for Canadian and USA overall losses (cards,non-cards, lending)

Analyzed Excel spreadsheets to ensure accuracy of Canadian &US Journal entry process spreadsheets and ensure match to underlying monthly and daily TSYS reports

Worked on simplifying and automating Excel reporting templates for quarterly, monthly, and annual data

Performed quality checks on data for metrics that were added or removed

Significantly Improved the quality of the U.S. data by reverse engineering a report and deriving the underlying general ledger entries

Senior Report Analyst (4.5 years full-time) January 2011 – May 2015

International Data Corporation

Used SQL queries within Microsoft SQL Server and Microsoft Access for a complex survey and lead capture tool, and various market research data deliverables

Used VBA Macros to interact with data and text in Microsoft Word, Excel and Microsoft Access, including VBA forms, technical support and debugging

Worked with a variety of QA (quality assurance) tools and methods to ensure data quality

Worked with a data transformation and storage software called Ferda

Built a complicated Excel dashboard to efficiently display market research data including

market and vendor share

Built various ad-hoc reports, including Excel macros, pivot tables, formulas (V-look-ups, sum product, etc.) and automation

Briefly worked with Adobe Photoshop and a proprietary Alinean platform for surveys and

ROI calculators

Performed significant enhancements to VBA Add-ins for Excel and Microsoft Access including crosstab of data, data column transformations, data import automation into Microsoft Access

Simplified our team’s meeting bookings to a simple click using LotusScript

Junior Report Analyst (1 year cumulative full-time co-op) Summer 2009 – Summer 2010

Royal Bank of Canada. Greater Toronto Area

Used QlikView dashboards for displaying quality and business financial

department’s data

Developed an Excel VBA script which allows individuals to create a new version of their Activity Sales Action Plan for 2010

Developed an automated method to populate an Access database and generate

summary reports based on data feeds

Performed business analysis in suggesting the best programming language and data

Elements language for various problems

Designed automated Excel ad-hoc reporting by business area from a Microsoft

database

Designed a Project Manager Availability Report which provides a real-time task

management view of project managers availability based on SharePoint data

Mastered the process of producing the Excel timeline, quality, Reports of Daily Client

Service Commitments reporting data from various departments including Business

Financial Service, Cards, Personal Banking Operations

Produced an antifraud report, specifically Anti-Money Laundering – Out of Order Report, which uses data stored in Microsoft Access and summarizes the data in format useful for managers to see a snapshot of the performance and quickly identify the problematic error types and affected departments

Gained understanding of the iGate Service Level Agreements Excel report

Created an Anti-Money Laundering – First Product Opened Weekly report which uses

Microsoft Query to filter Excel data into separate tabs for different provinces and

cities

Computer Programmer/IT Support Technician (4 month full-time Internship) Summer 2008

Electricity Distributors Association (EDA), Vaughan

Programmed an online survey using JSP, JavaScript, MySql to automate, and bring consistency to a formerly tedious analysis and calculation process of the customers’ insurance information

Modified existing online surveys using LotusScript, JavaScript to dynamically display options

Displayed a friendly attitude with professional interaction in supporting 35 customers on various tasks including web development, computer software and hardware troubleshooting

Performed RAM upgrades, replacing motherboards on servers, setting up several workstations on the company network

Updated and created functions using Visual Basic for Applications (VBA) in Microsoft Access to create macros for a performance management survey database

Web Developer (Part-time) Summer 2008

Back2Front, Thornhill

Developed websites using Perl, JavaScript, HTML, MySql databases

Administrative Assistant, IT Support, Filing Clerk Spring 2008

Robert C. Cronish’s Law Firm, Toronto

Designed MS-DOS batch files which allowed a quick search for embedded text within hundreds of networked Microsoft Word, Excel files (faster than the typical Windows XP search)

Technical Associate Spring 2007

Solectron Global Services, Newmarket

Performed functional, RF testing, DataSweep data entry, updated the software on Nokia, Sony Ericsson cell phones

Worked effectively in an assembly line phone repair team environment

Programmed Excel, PowerPoint macros using Visual Basic for Applications (VBA)

EDUCATION

Certified System Administrator (CSA) - ServiceNow December 2021

Successfully completed Certified Administrator course and exam

oCertification # 22712316

Bachelor of Applied Technology, Co-op Software Development September 2006 - 2010

4-year degree program

Seneca at York, Toronto

Graduation in December 2010

Cumulative GPA: 3.8 out of 4.0

Completed Applied Lab exercises including a JavaScript Sliding Tiles game

Created a Client/Server application in Visual Basic for a networking course

AWARDS AND ACHIEVEMENTS

Seneca Academic Scholarship

Fall 2006-2010

$1000 per year for four years for high academic achievement

President’s Honours List for Highest Academic Standing Spring 2007

Awarded to students who carry a 4.0 GPA

VOLUNTEER EXPERIENCE

Orientation Leader Spring 2007

Seneca at York, Toronto

Developed leadership, teamwork, communication, problem solving, and conflict resolution skills through performing of training and experience exercises with other orientation trainees

INTERESTS AND ACTIVITIES

Participated in Google Code Jam contest (2014)

Successfully completed parts one and two of the “IBM Master the Mainframe Contest” (2007)

Participated in Seneca at york’s Club Moz, Firefox web browser extension development (2007)

Enjoys working out, studying personal development, and playing video games



Contact this candidate