Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Scott Holtzman | Elance
 
176985602337900
Last Sign-in: Jan 28, 2014

Scott Holtzman

VBA | Spreadsheet Modeling | Database | Scripting
   United States
  |   Wayne, NJ

Verified Freelancer

Scott Holtzman's identity has been verified.  Learn More

Overview

Minimum Hourly Rate $50

Hello. With over 10 years experience across various sectors both in corporations and as a freelancer, I have a vast repertoire of creative yet professionally polished software applications, reporting packages and data management systems.

I have extensive experience programming in Microsoft Office applications (VBA) often piping applications together to create robust, yet very user-friendly systems.

I also have experience utilizing VBS, javascript and perl and have worked with SOAP (web services), sharepoint, html, xml (to create customize...

Read More »
Jul 22, 2013|Database Development|Private|Completed
|
5.0
Apr 29, 2013|Database Development|Private|Completed
|
4.9
Apr 22, 2013|Software Application|Private|Completed
Apr 9, 2013|Software Application|Private|Completed

View All »

Skills (5)

Tested
Visual Basic
Microsoft Excel
Microsoft Excel 2007 Test
My Score
avg
Microsoft Excel 2010 Test
My Score
avg
Microsoft Access Administration
Perl
Javascript

Employment

ADP
Lead Financial Analyst
2012 - 2013
Build, enhance and maintain database and reporting systems to support internal and external partner sales reporting and revenue share payments, utilizing Javascript (Hyperion Brio), Perl, VB and...
Citco Fund Services
Application Developer
2011 - 2012
Manage and develop custom-built Excel / Access applications, equipped with API calls custom ribbons, and integration with other technologies, that facilitate Tax and Financial Reporting related...
Citibank N.A.
AML Analyst
2010 - 2011
Built Excel and Access VBA modules (macros) to support data collection / analysis / validation and report generation across all facets of the AML metrics collection process. Developed Access...
Personal Contact
Application Developer
2010 - 2010
Developed an instructed the use of an end-to-end Excel based reporting package to track user dissatisfaction for a condiment manufacturing company, but managing data input, analysis and final...
Chartis Insurance
Data Validation Analyst
2010 - 2010
Validated data from a newly implemented IBM Cognos system against an existing MRS reporting standard by tying both the numbers and formatting to a high level of detail. Developed process...
Goldman Sachs
Data Strategist
2006 - 2008
Utilized a myriad of financial tools and databases (Factset, AMBest, SNL, SimFunds, Datastream, ACNielsen, CapitalIQ, SDC, Thomson One, et. Al.) along with MS Office (Excel, Word, etc.) to...
Oak Hill Capital Management
Analyst
2005 - 2006
Built and implemented Crystal reports and extensive Excel reports allowing Oak Hill to enhance data productivity and cleanse data. Became the Investor Relations resident expert in TNR - a...
Standard & Poor's
Senior Research Associate
2001 - 2004
Designed, built and maintained several Excel and Access reports and database systems facilitating the analysis of global economic and financial market trends for both internal use and external...
Overview  |  Job History  |  Resume/C.V.

Keywords

VBA
Excel
DataMining
Data Modelling
Access
Javascript
Adobe Acrobat
Perl
Financial Modelling
My Snapshot
IT & Programming
2
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
Private
Private
Total
Per Client
Identity
Username
scotty718
Type
Individual
Member Since
February 2013
Elance URL
Verifications
0
Groups
Scott Holtzman | Elance

Scott Holtzman