Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Steven B. | Elance
 
176985602337900
Last Sign-in: Jan 23, 2015

Steven B.

Certified Microsoft Excel Specialist
   United States
  |   Arlington, VA
  |  12:08 pm Local Time

Verified Freelancer

Steven B.'s identity has been verified.  Learn More

Overview

Minimum Hourly Rate $44

Certified Microsoft Excel Specialist with 13 years of Accounting and Data Analysis & Management experience.

Read More »
Apr 26, 2013|Database Development|$250|Completed

View All »

Portfolio

This Excel doc turned a 35+minute paper process into a 3 minute process. Original...

Skills (10)

Tested
Excel
My Score
avg
Microsoft Excel 2003 Test
My Score
avg
Microsoft Excel 2007 Test
My Score
avg
Microsoft Excel 2010 Test
My Score
avg
Microsoft Word 2007 Test
My Score
avg
Microsoft Word 2010 Test
My Score
avg
Email Etiquette Certification
My Score
avg
Passed
Email Handling
My Score
avg
Passed
Computer Skills Test
My Score
avg
Passed
U.S. Culture and Etiquette Test
My Score
avg
Passed
Financial Analysis
My Score
avg
Passed
Organizational Behavior
My Score
avg
Passed
Organizational Behavior Test
My Score
avg

Service Description

I significantly improve productivity by use of dynamic spreadsheets. I work with every level of the corporate ladder to update previously inefficient manual processes and even create new processes from scratch. Functions used include, but are not limited to, the following: Pivot Tables, Macro's Data Tables, V/Hlookus, Concatenate, DSUM, Countif, Sumif, RAND, Name Manager, Time processing functions, Data Validation, Financial Formula's, If/Iferror functions, Conditional Formatting, etc.

I offer online tutoring.

There is no job too big or too small, and I am happy to share my knowledge!

Read More »

Employment

Department of the US Treasury
Data Analyst
2014 - Present
• Reporting to US Treasury Department • Aggregate Housing Finance Agency data for NIBP & TCLP bond programs: SingleFamily & Multifamily Loans. • Aggregate Pension Plan data for all US...
Freelance
Financial Data Analyst
2012 - Present
• Data Analyst for SeniorQuote Insurance Services. Commission Tracking, Licensing and compliance tracking, managed admin. • Weekly PowerPoint Presentations to Board of Directors at SeniorQuote,...
Capital One
Business System Analyst
2013 - 2014
• Ensure accuracy and bank industry compliance of Agile PCR’s; confirming regulatory standards are upheld and/or adressed • Maintain three Outlook Mailboxes, processing internal and external client...
AMN HEALTHCARE
BILLING SPECIALIST/CORPORATE TRINING
2011 - 2012
• Confirm accuracy of medical billing to be compliant with client specific contracts and met state and fed payroll regulations. • Managed $2,000,000+ weekly billing, utilizing APeX, PeopleSoft,...
EXODUS RECOVERY: Walk-In Assessment Clinic
FINANCIAL DATA ANALYST
2009 - 2010
• Reported directly to VP of Operations on clinic’s overall standing of HIPA compliance, medical and insurance regulations. • Generated numerous reports from ‘Anasazi’ Computer Software used for...
Community Research Foundation
Cost Accountant
2007 - 2009
• Aggregated data from 32 satellite sites used to generate company’s key monthly ‘Scope Report’ showing YTD productivity. • Reported to Director of Cost Accounting. Regularly created spreadsheets...
PineLawn Power Operations
Accounts Payable
2006 - 2007
• Aggregated emails & U.S.P.S. mail. Reconciled invoices with purchase orders. Updated GP MATE inventory computer software. • All A/P was reviewed with 3/Way reconciliation. Information was...
Suffolk County Community College
Lead Accounting Tutor
2005 - 2007
• Lead Tutor in Accounting, Business, Business Math, Economics, Microsoft Office, Computer Technology. • Collaborated with all tutors and students for the best scheduling and subject match. •...

Education

Northern Virginia Community College
Business Admin
2015 - Present
Mesa College
GIS Certificate
2010 - 2012
Suffolk County Community College
Business Admin w.e. in Accounting
2005 - 2007
American University, Rome Italy
International Business
2006 - 2006
Overview  |  Job History  |  Portfolio  |  Resume/C.V.

Keywords

Microsoft
Excel
Finance
Database
Dashboard
Analysis
Vlookup
PivotTable
Accounting
My Snapshot
All Categories
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
Spbugge
Type
Individual
Member Since
June 2008
Elance URL
Verifications
Groups
Steven B. | Elance

Steven B.