Experience

Evident Change

• Research Services
• 1 - 100 Employee

• SafeMeasures Business Intelligence SQL Developer

  • Oct 2016 - Present

  Supported SafeMeasures (data reporting service for social service agencies) by ensuring that database structures and procedures are assembled efficiently, including new sets of data and features, integrating new information from large and complex client data systems, and keeping it free from potential bugs within the system. Duties included: – Served as lead analyst for SafeMeasures’ largest jurisdiction, CDSS (California Department of Social Services), developing a strong understanding of its social services data systems, business rules and practices. – Collaborated with the operations (front-end display) team to document the database logic-producing reports by translating complex problem solutions using non-technical terms and coordinating the smooth release of all database coding projects and client requests. – Followed established workflow guidelines and standards, striving for concise and informative documentation. – Assisted the major SafeMeasures conversion overhaul project, which migrated the bulk of analysis and internal data infrastructure from Oracle (PL-SQL) to Microsoft SQL Server (T-SQL). Show less



AnchorBank, a division of Old National Bank

• Banking
• 100 - 200 Employee

• Business Intelligence Analyst

  • Feb 2016 - Sep 2016

  Implemented a variety of data mining techniques using SQL and R to find business solutions without neglecting data accuracy, for example: – Designed an SQL built-in logic that identified households across AnchorBank’s portfolio. The bank received three levels of grouping: accounts, customers, and households. Implemented a variety of data mining techniques using SQL and R to find business solutions without neglecting data accuracy, for example: – Designed an SQL built-in logic that identified households across AnchorBank’s portfolio. The bank received three levels of grouping: accounts, customers, and households.



Scotiabank

• Canada
• Banking
• 700 & Above Employee

• Business Intelligence Predictive Modeler Analyst

  • Jan 2013 - Aug 2014

  In charge of developing, maintaining, and enhancing statistical procedures using SQL and SPSS in order to make more accurate marketing campaigns and discover opportunities for business growth, such as: – A segmentation based in statistical multivariate methods that identified different loyalty levels among the bank’s customers portfolio with the purpose of improving client engagement and profitability. – A multivariate regression model built with socio-demographic and financial data that aimed to predict the monthly income of non-customers in order to offer customized retail banking products. – A statistical procedure capable of identifying customers who were the most likely to end their financial relationship with the bank so proactive efforts could be deployed to prevent this from happening. Show less



Autónomo

• Santiago, Santiago Metropolitan Region, Chile

• Statistics, Algebra and Calculus Tutor

  • Jan 2008 - Apr 2014



Universidad de Santiago de Chile

• Chile
• Higher Education
• 700 & Above Employee

• Statistics Capstone Course Teacher Assistant

  • 2013 - 2013