Business Intelligence Analyst Resume Somerville, Ma - Hire IT People

Work History:
Business Intelligence Analyst - Confidential, Boston, MA July 2012 to Nov 2012

Conducted fraud and high-risk customer analysis leading to the discovery of a network with a 25% chargeback rate (industry average below 1%). Proactively implemented anti-fraud measures by creating parameters for a velocity checking script and identified fraud-related transactions resulting in over $30,000 in financial return.
Learned Power Pivot and R to conduct a million rows by forty variable customer analysis.
Reverse-engineered chargeback forecasting model in Excel for subscription-based business and re-calibrated to make forecasting more accurate.

Reporting Analyst - Confidential, Newton, MA Dec 2011 to Jul 2012

Driven to automation, I read a Visual Basic for Applications manual and within two months produced an application that took a CSV file, identified all banner level information and fed it to a convenient user-interface. A background script then tailored each report to client presentable specifications, reducing error, while increasing productivity by a factor of 3 by automating reporting production.
Developed dynamic Excel dashboard that automatically detected date data in a report containing marketing leads and then, using this data, reconstructed the campaign on a week-to-week basis. Previous processes required that individuals either reconstruct the campaign manually or look up numbers in outlook E-mails.
Produced an application-level VBA script that moved data across multiple workbooks by defining all workbook-worksheet connections, automatically detecting all data regardless of blank values in Excel cells and pasting it across worksheets the user-specified. Script included formatting options and the ability to paste directly under other datasets.

Patient Care Coordinator - Confidential, Wilmington, MA Oct 2010 to Dec 2011

Developed calendar system in Excel to track future vacation time accumulated.

Mathematics Tutor - Confidential, Galesburg, IL Jan 2008 to May 2010

Taught students advanced mathematics and economics related to statistics, multivariate calculus and linear algebra.

Related Skills:

Expertise in VBA and Excel dashboard creation including effective use of indirect, offset, address, row, column, index, match, dcounta and rept Excel formula.
R data manipulation and SQL.
Experience with 3rd party BI software such as Good Data.
Stanford free-learning courses in machine learning, statistics and computer science.

Education:

Bachelor of Arts, cum laude, International Relations
Double Minors in Economics and Mathematics
Pi Sigma Alpha- Political Science Honors Society

We provide IT Staff Augmentation Services!

Business Intelligence Analyst Resume

Somerville, MA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship