Julio Mella

TD Bank

IT Sr Support Analyst

Feb 2018 – Present

• Support LEX related to BCBS and SCCL Regulatory Reporting

Scotiabank

Sr Business Analyst

Feb 2014 – June 2017

• Solves organizational information problems and requirements by analyzing requirements; designing computer programs; recommending system controls and protocols.
• Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats.
• Prepares technical reports by collecting, analyzing, and summarizing information and trends.
• Contributes to team effort by accomplishing related results as needed.

RBC Capital Markets

Technical Systems Analyst

Mar 2009 – Nov 2013

• Streamline process to produce accurate reports by developing programs, methodologies, and files for analyzing and presenting data.
• Use and support of database applications and analytical tools: evaluating data quality, applications, and functions, producing output and maintaining operation.
• Responsible for ongoing analysis of financial market information obtained from a variety of sources. This involves development and preparation of information products. It also requires proficiency with analytical tools (Excel, MS Access), knowledge of data analysis methodology, strong communication skills and a strong commitment to and an affinity for delivering the highest level of accuracy.

Maintaining and supporting RBC DS Inc systems. This includes providing hands-on support to RBC DS Inc Product Control, a back-office team that is responsible for producing the PnL for various trading desks, such as Fixed Income, Equities, Derivatives and FX. I have automated most of their MS Access applications and spreadsheets, to enable them to produce efficient and streamlined reporting and queries. Part of the this process is to gather data from multiple sources and different formats, integrating them into a centralized system. I was involved in GAT (Global Arbitrage Trading) business migration from one front office system to another.

HSBC

Assistant Manager Tax Reporting

Feb 2004 – Feb 2009

• Development and maintenance of the US Reporting database in MS Access, to facilitate accurate and complete 1099, 1042 and 1042-S reporting being submitted to the IRS.
• Reviewing and reconciling information received from DTC and other custodians to validate QI reporting for HCSC as accurate.
• Reconciling tax deducted from customers and paid to the IRS, with IRS and customer records.
• Ensuring that tax payments are made to the IRS for the correct amounts and on the due dates.
• Project managing the Annual Documentation Renewal Project and other projects as assigned.
• Reviewing procedures with the intent to streamline operations and increase accuracy.

Sept 2015

SAS Programming I

Metro College

Jun 2009 – Sep 2013

.NET Certificate

George Brown College