Saul Botier
*** **** **, ********, ** ***** • 646-***-**** • ****.******@*****.***
WORK EXPER IENCE
M I Planning Analyst (Consultant) Ma rch 2013 to P resent
HSBC Bank, New York, NY – HSBC Securities. KYC Services.
• Perform root-cause analysis and resolution on breaks found on actively trading clients to ensure no
t ransactions are executed without the proper KYC profile using internal client data platforms and
customized spreadsheets.
• Propose, test, and implement logic changes to mitigate and resolve data quality issues with the reports
generated, which facilitates the workflow within KYC Services.
• Develop and maintain key contacts and working relationships with various functional servicing and
operational areas to resolve issues and expedite processes required for timely issue processing and solution.
• Generate, maintain and enhance a wide variety of reporting metrics for senior management while meeting
new/updated business requirements.
• Participate in daily/weekly meetings with senior management to discuss review findings and suggest
changes in processes, which has shaped the basis of current procedures.
• Analyze business processes with Subject-Matter Experts and management to coordinate steps toward
resolution of issues and streamline workflow, leading to implementation of best practices.
• Reconcile Global Banking and Markets systems data to KYC master database.
Quality Cont rol Analyst (Consultatnt) October 2011 to June 2012
JPMorgan Chase & Co, Brooklyn, NY – Mortgage Banking and Default Services. OCC Article VI I
I ndependent Foreclosure Review (IFR).
• Performed targeted reviews of all of the departments’ findings of the IFR project to ensure adherence to
p rocedures and quality expectations in regards to the research conducted, as mandated by QC policies.
• • Proactively sought and maintained a working knowledge of the rapidly changing processes and
p rocedures of all the depar tments involved with the project, which proved essential to facili ta te
r esearch and provide accurate quali ty control reviews.
• Created and developed the Excel templates (VBA custom functions, macros, automatization ) used by the
QC department to record and report the department’s figures, such as total number of cases resolved,
passed, failed, all organized by departments, using pivot tables and charts to properly display the
i nformation. This in turn increased the work efficiency of team members across the department by
a llowing the prompt identification and resolution of negative t rends.
• Analyzed team and individual work statistics and performance using customized Excel tables to prepare
reports for supervisor review to allow for the fast implementation of new team strategies for production
enhancement while maintaining the required quality standards.
• Reviewed and evaluated processes for improvement opportunities, to facilitate the development of new
review procedures and spreadsheets used to report findings.
• Validated customer claims by collecting and evaluating loan servicing files and supporting documentation.
Sales and M a rketing I nte rn June to August, 2010
IndexIQ, Rye Brook, NY - Collaborated with the product development and portfolio management team.
• Analyzed and evaluated market data using third party and internal databases to prepare performance
reports for review and recommendation to be used by the investment team.
• Monitored and t racked equity corporate movements and adjustments to relevant indexes and issued
detailed reports to management to take informed decisions.
WORK EXPER IENCE (continued)
• Developed and maintained an efficient and organized client distribution database for the sales team using
v lookups to access the information and macros modified with VBA to properly accomplish the data cleanup
and organization, which allowed for quicker and more efficient communication with current and
p rospective clients.
• Determined key prospective clients through in-depth research and provided contact support to the sales
team.
• Created and updated marketing documents, such as products’ brochures, performance reports and f low
charts, to be distributed to current and potential clients.
COMPUTER/SYSTEMS SKILLS
Advanced knowledge of Microsoft Excel (pivot tables/charts, vlookups, custom functions, macros -VBA-), Access,
Word, PowerPoint, and Visio. Basic Financial Modeling/Analysis skills, basic knowledge of Essbase and
B loomberg Terminal.
LANGUAGES
Bilingual English/Spanish, basic knowledge of Japanese and I talian.
EDUCAT ION
Bachelor of Arts, F inance, Concentration: Accounting, M inors: Political Science and Asian Studies
2011
Manhattanville College, Purchase, NY