Felipe Taruselli

703-***-**** adts2g@r.postjobfree.com U.S. Citizen 1342 Monroe St NW, Washington, DC, 20010

Experience

Federal Reserve Board Washington, DC

Financial Data Analyst 2021 May – 2022 Apr

Data gathering, organization, and analysis to complete bank examinations

Filled specific examination requirements based on bank category

Listings of bank information were used to supplement data in the Federal Reserve Community Development division

Examinations utilized by head Economist on project for determination of overall bank status (needs to improve, satisfactory, outstanding) to determine future Federal Reserve Board action for those banks

Database featured dynamic systems to alter certain outputs based on new and future inputs

Siemens Government Solutions Reston, VA

Financial Data Analyst 2019 Jul – 2019 Sept

Created the outline for a database arrangement in Oracle SQL developer

Created templates to improve accuracy, efficiency, and speed of excel calculations

Created form macro inputs for an access log to speed up future inputs

Managed team project workflow and assisted in technical tasks

Taught members about data integrity practices in order to reduce the burden of managing information

Utilized Power BI to organize reports into easy to comprehend visualizations

Freelance Data Analysis and Audio Processing 2018 Dec – 2019 Jul

Statistical assistance to clients who have specific requests on data projects

Assist touring artists in audio engineering and music production for various nightclubs in the Dc area

US Administrative Offices of Federal Courts Washington, D.C.

Financial Analysis and Data Modeling 2018 May – 2018 Dec

Organized excel data, used R to create graphic visualization.

Consolidated across multiple workbooks and created dynamic workbooks for active changes to workbooks.

Used VBA to create custom functions for custom SQL queries.

Compared workbook data across multiple information systems to ensure accuracy of analysis.

Ensured vendor status was recorded in the financial management system and reported data in daily meetings.

Analyzed Past and Current financial data to ensure the validity of current financial data with other team members

Taught fellow team members and public employees how to utilize Tableau for explanatory data visualizations

Universal Audio Arlington, VA

Audio Engineer 2013 Mar – 2016 Jan

Edited audio files and live recordings for clientele.

Programmed macro functions to increase audio processing speed.

Presented edited audio files to clients for review and then refined the files

Brazilian Juvenile Health Foundation Fairfax, VA Staff Accountant 2011 Jan – 2013 Feb

Managed accounts payables and receivables submitted to the CIO in QuickBooks.

Utilized GAAP NFP methods of accounting for the Cash Statement and Bookkeeping

Reconciled ledgers and individual entries from excel logs to Quickbooks workflow of Accounts Receivable

Prepared Monthly Cost Journal entries and assisted with monthly financial closings

Prepared monthly Revenue and Cost analysis

Prepared General Ledger entries and assisted in fundraising and tracking for the NFP, peer to peer fundraising, online portal fundraising tracking, and set up visualizations and presentations on fundraising activities.

Professional Skills:

• Data mining and quality analysis

• Statistical analysis and/or modeling

• Financial, cost, forecasting analysis, SEC reporting, GAAP reporting (NFP and FP)

• Reporting and presentation generation

•Fluency in English, Portuguese, and some Spanish

•Ability to write clearly and appealing to wide audiences

•R, SPSS, SAS, Stata, Tableau, PowerBI, Minitab

•Big Data and Stratified Sampling

•MySQL, QuickBooks, Dynamics, Oracle, VBA, Access, Excel

Education:

Bachelors of Science in Economics, Data Analysis Minor Graduated: 2013 May

George Mason University, (GPA 3.3)

Contact this candidate