Elton Aguiar

Toronto, Canada
2.8 Score: 2.8/10

Skill Summary

  • Web & Programming
  • Business Services


Senior Reporting Analyst Profile • Worked extensively with Excel, MS Access, on an extensive dataset of banking fraud loss data for Canada and USA fraud losses, including cards, non-cards and lending data from TSYS,NCCS and other systems • Built various ad-hoc reports, including Excel macros, pivot tables, formulas (V-look-ups, sum product, etc.) and automation • Worked on PowerPoint macros to automate slide decks and reporting and pull data from various sources • 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 • 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 • 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 • Used QlikView dashboards for displaying quality and business financial department’s data • Built a complicated Excel dashboard to efficiently display market research data including market and vendor share • Excellent Excel (pivot table, v look up, macro), VBA, PowerPoint, Access, SQL, Visio

Read more

Web & Programming

Strength: 1 / 10
Strength: 1 / 10
Strength: 1 / 10
Strength: 10 / 10
Visual Basic
Strength: 1 / 10

Business Services

Business Intelligence
Strength: 10 / 10
Project Management
Strength: 10 / 10


Microsoft Access Microsoft Excel Microsoft Sharepoint Microsoft Visual Studio Microsoft Outlook Microsoft Word