* Data analyst/consultant: VBA, SQL, programming for automating database querying, data cleaning and processing, and statistical analyses of moderate sized datasets (~1.5 million records).* Independent statistical programming consultant: Statistical programming in SPSS and VBA to automate generation of reports and product. Created simple user interface for the client allowing them to update parameters and release new versions, as well as create new iterations of products.

* Analyze proprietary data using Latent Class Analysis, Principal Component Analysis, correlations and crosstabs in addition to various descriptive statistics in order to determine the best measures and methods for drawing meaningful insights* Develop new measures to help in the analysis and summarization of proprietary data* Use knowledge of programming to quickly learn IronPython in order to design new data analytics dashboards and automate their creation, reducing the amount of time needed for their creation from more than two days to one hour * Design charts and measures for presentation through interactive business intelligence dashboards using Spotfire, which requires knowledge of SQL* Find new and interesting ways to summarize and display proprietary data* Analyze current processes and suggest or create new, better, and more efficient methods* Contribute to discussions on best practices while pushing toward standardization of processes* Use VBA programming in Excel to create a user interface for creating xml documents, and automate other aspects of data processing

* Used VBA and SQL (SQL Server) programming in Excel to automate and extract data from a database containing billions of records, perform manipulations on the data and initial calculations for preliminary analyses* Used proprietary functions and short interest data in Excel to create and modify Excel spreadsheets used for portfolio analysis and investment screening, then train new and existing clients to make the best use of proprietary short interest data* Contributed data and analyses for research initiatives such as a presentation to the World Economic Forum on global systemic risk given by the CEO, other projects included product enhancement and new product development involving risk adjusted returns

Used VBA and SQL programming in Excel, Access and Oracle to automate tasks, find and alter files, read and create XML files, and interface Excel spreadsheets and Access databases with an Oracle database containing millions of records* Reduced a monthly 24-hour task to 10 minutes and increased the quality of the Commercial Mortgage Backed Securities Index by reducing the number of errors from data entry to zero

* Used SQL programming in Access to conduct queries and perform operations on data sets of more than 1.5 million records* Expedited data entry and analysis in Excel using functions, macros, VBA, and SQL, analyzed survey data to consult senior administrators regarding materials distributed to over 1 million consumers on a 2.2 million dollar contract