EXPLORE

Accounting Excel Proofreading SQL Visual Basic
Profile cover photo
User Avatar

Andrew S.

@artichoke

0.0
0

0.0

0.0

0%

Expert in financial modeling and database design and programming

Flag of

United States (11:21 PM)

・

Joined on August 26, 2008

My expertise includes developing tools, systems and applications (using MS Access, VBA, SQL, MS Excel, macros and modules), building customized financial models (using MS Excel/VBA), creating financial models and stress test scenarios to measure investment and portfolio risk, creating custom reports using native Excel functions and customized macros, using VBA to connect to other MS Office Applications, databases, and data feeds etc. IN FINANCIAL MODELING AND DATABASE

0.0 · 0 Reviews
Reviews

No reviews to see here!

Experience

Senior Consultant

Sep, 2008 - Jan, 2012

•

3 years, 4 months

TopKnobs

Sep, 2008 - Jan, 2012

•

3 years, 4 months

TopKnobs, a distributor of specialty knobs and furnishings for kitchens, baths and living rooms, needed to create a series of customized reports in MS Access that detailed sales for different types of types of knobs and different sales reps in various regions of the USA. In response, i developed a reporting syste in MS Access that created about 40 customized reports showing sales monthly, quarterly and annual sales performance by region, state, product line, product type, and by sales rep.

Sep, 2008 - Jan, 2012

•

3 years, 4 months

Senior Consultant

Jan, 2009 - Jan, 2012

•

3 years

AmerisourceBergen Corp

Jan, 2009 - Jan, 2012

•

3 years

AmerisourceBergen Corporation (Fortune 29 drug delivery company) sought a compensation management system to administer, manage and calculate over $10 million of Annual and Quarterly Incentive Plan payouts to nearly 500 eligible employees. The Incentive Plan included over 600 different performance metrics based on corporate, regional, team and individual performance. In response, I developed a Compensation Management System that managed employee records and related compensation plan data for eligible employe

Jan, 2009 - Jan, 2012

•

3 years

Senior Consultant

Jun, 2008 - Sep, 2008

•

3 months, 2 days

PSelling Solutions

Jun, 2008 - Sep, 2008

•

3 months, 2 days

PSellingSolutions (a contract sales management company) needed an accounting management system to track employees and payroll. In response, I developed an employee management system (MS Access Front-End, SQL Server Backend) that enabled management to manage key employee data, run payroll reports and maintain records of all changes to employee data. Created stored procedures, triggers, audit tables and constraints to record all additions and changes to database. Result: Company could easily manage key employ

Jun, 2008 - Sep, 2008

•

3 months, 2 days

Education

MBA

1969 - 1972

•

3 years

1969 - 1972

•

3 years

Bachelor Of Arts

1965 - 1969

•

4 years

1965 - 1969

•

4 years

Certifications

F

Foundation vWorker Member

Verifications

Registered Users

Total Jobs Posted

Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)

Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)