Banner Image

All Services

Programming & Development

Excel and Access services

I build anything you need. Do you have to copy hundreds of files into a spreadsheet or Access database? I'll make it happen in less than 5 minutes. What ever you need done in Excel and Access, I can make it happen. Examples of successes: Created a macro for a financial company for a financial statement that is sent on a weekly basis to multiple vendors. The process involved downloading over 10,000 items that needed to be sorted based on their stock ticker, brokerage information, etc. Additionally, 31 documents needed to be included into the comparison. The macro reduced time to produce the reports from 6 hours to under 10 minutes. Created a capacity model for four departments within operations and determined one was under-staffed by 17 people and another was over-staffed by 20 people. Management then re-allocated resources. The previously under-staffed department increased processing transactions on day 0 from 94% to 99.9% while the over-staffed department suffered no consequences. Built a VBA macro for an excel spreadsheet that needed 45 files downloaded via Oracle and were required to deliver a daily report for management. On average, the report took two hours to generate. Once the macro was built the report took less than ten minutes to generate. Built access database that connected to an Oracle server to generate a report for logins to a website that appeared suspicious. The database provided a user information with the IP address and their personal address for comparison. It allowed them to document whether the item is legitimate or needed additional research. Additionally, the same database allowed report generation for senior management.

About

$45/hr Ongoing

Download Resume

I build anything you need. Do you have to copy hundreds of files into a spreadsheet or Access database? I'll make it happen in less than 5 minutes. What ever you need done in Excel and Access, I can make it happen. Examples of successes: Created a macro for a financial company for a financial statement that is sent on a weekly basis to multiple vendors. The process involved downloading over 10,000 items that needed to be sorted based on their stock ticker, brokerage information, etc. Additionally, 31 documents needed to be included into the comparison. The macro reduced time to produce the reports from 6 hours to under 10 minutes. Created a capacity model for four departments within operations and determined one was under-staffed by 17 people and another was over-staffed by 20 people. Management then re-allocated resources. The previously under-staffed department increased processing transactions on day 0 from 94% to 99.9% while the over-staffed department suffered no consequences. Built a VBA macro for an excel spreadsheet that needed 45 files downloaded via Oracle and were required to deliver a daily report for management. On average, the report took two hours to generate. Once the macro was built the report took less than ten minutes to generate. Built access database that connected to an Oracle server to generate a report for logins to a website that appeared suspicious. The database provided a user information with the IP address and their personal address for comparison. It allowed them to document whether the item is legitimate or needed additional research. Additionally, the same database allowed report generation for senior management.

Skills & Expertise

AccessDataExcelFinanceManagementOracleProcessingReportsResearchSQLVBA

Related Work Collections

0 Reviews

This Freelancer has not received any feedback.