ELTON AGUIAR
Toronto, Ontario
M5G 2H5
***********@*****.**
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