Looking for a Microsoft Excel, Access, or VBA expert with years of experience with financial institutions, large datasets?

ELTON AGUIAR

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

Work Terms

Payment 60% down, and 40% upon completion.
I offer a customer satisfaction 100% money-back guarantee. You will be pleased with the results or your money back!