Toby
Erkson
Software: Microsoft Access,
Excel, Outlook, PowerPoint, Word, Lotus Notes
Cognos Impromptu Admin 7, Impromptu Web Reports 7, PowerPlay
6.6, Transformer, Upfront 7,
Languages: VBA (Access & Excel), HTML, SQL, AWK, C, COBOL
(1985 Standard and WANG VS 1974), dBase III+, DOS, FORTRAN, FoxPro 2.5(DOS),
BASIC, 6502 Assembly
Intangibles: Analytical,
excellent trouble-shooting, strong team player, works well unsupervised,
creative
Reporting Analyst, Yahoo!,
Run, automate, and maintain reports for the Customer Contact department. Develop, document, and maintain Excel and Access applications. And some other stuff I'm sure but I just started so not much to say right now ;-)
Client: The
Regence Group. Run and
maintain weekly Clarity time-keeping, MS Project, and project dashboard reports
using Excel, Access, and SQL queries.
Develop, document, and maintain Excel and Access applications for the
department. Tasked with building reports
in Crystal Reports and Business Objects Enterprise Web Intelligence against the
department’s Business Objects Universe.
Automated updating of executive dashboards within Excel and thus reduced
creation time from over a day to less than an hour.
Excel Application Developer, Kforce,
Client:
adidas. Developed
application to record sales order entries for sales reps, then export the data
into a tightly-defined Excel format for automated data entry into SAP. Created an Excel add-in that allowed data
from a SAP report export to be either pulled into Excel as a Query Table or
return a table array from the source that could be used within an Excel VLOOKUP
function. This add-in became a critical
part of another application that I developed for their OTS (Open To Ship)
report, which used data files from SAP to build a dynamic OTS workbook.
Hewlett-Packard Case Manager, Stream,
My responsibility as 3rd tier support was to
handle customers whose issues could not be resolved by the front line technical
support, owning them until the issue is resolved. I made every attempt possible to resolve
customers' issues and turn a customer's negative experience with HP into a
positive one. Authorized repairing or
replacing damaged/faulty notebooks, issuing refunds, and adding warranties.
Programmer/Analyst, Business Intelligence, Inc.,
Performed quality assurance and product testing for
in-house software development and also wrote reporting solutions in Microsoft
Excel for customer services, relying on a combination of spreadsheet functions,
ODBC, the company’s data acquisition software, and Visual Basic for
Applications code. One of my successes
that the company marketed was an Excel workbook that would automatically create
key performance indicator graphs for a business in only a few minutes and was
simple enough that the business user wouldn’t need IT’s help.
Programmer/Analyst, Volt Technologies, Wilsonville, OR
Dec.
2005 – Feb. 2006
Client:
InFocus. Operate
and stream-line their monthly commissions payout process as well as operate and
stream-line their weekly channel inventory reports. I also had to learn and document both
processes and then pass this knowledge to the full-time Commissions Analyst
they hired three weeks after my contract began.
The commissions process was a mixture of Access databases and Excel
reports. Though I was able to reduce
some of the Excel reporting by using VBA, the bigger job was thoroughly
documenting the process for the incoming analyst. Since the weekly channel inventory reports
heavily relied on Excel, I was able to take this extremely manual 14 hour
process and reduce it to under 2 hours.
Programmer/Data Entry, Volt Technologies,
Client:
Programmer/Analyst, Business Intelligence, Inc.,
Contracted out to
various local businesses to provide executive level reports, both graphical and
numeric. The primary goal was to
automate as much of the reporting as possible, thus reducing time spent
gathering data and composing reports.
·
Automated daily
executive level financial reports.
- Enabled CFO to reduce report generating time by 10
hours per month.
- Created condensed report for Blackberry device
capability that was e-mailed automatically.
·
Automated daily
customer account statistics.
- Reduced daily report creation time from two hours to
ten minutes.
·
Set up a
‘reporting server’ for scheduling data gathering and report updating.
- Automated report refresh and dissemination processes
with a desktop computer, third-party scheduler, and Visual Basic coding within
Microsoft Excel.
- Ensured reports were updated after the data sources had
been updated.
- Automatically sent out an error report of any failed
processes so the reporting engineer could quickly resolve the issue before the
end user is affected.
·
Produced an
automated customer quote tool for calculating the lowest price for software and
services.
- Sales agents no longer had to manually figure out
lengthy customer quotes.
- Eliminated human error as customer would always get the
lowest price.
Volunteer IT Technician,
Performed various computer and software maintenance
tasks to ease the load on the district IT administration and teaching
staff. Instructed students on how to use
software, write simple documentation for software administration and use,
install/update software and hardware as directed, trouble-shoot problems and
escalate issues beyond my skills to district IT administration as necessary.
Programmer/Analyst, Intel Corporation,
Developed, implemented,
deployed and maintained computer-based systems supporting business customer reporting
requirements that integrated with existing contact management and content
management systems.
·
Created a
reporting environment with Cognos business intelligence software.
- Established standardized reporting processes for the Intel
Customer Support group.
- Greatly reduced report generation time for end users
i.e. from 13 hours per week to 30 minutes.
- Designed ad-hoc (OLAP) and standard reports.
- Trained end users on how to use the tools for business
analysis.
·
Implemented and
maintained 3rd party scheduling software to automate data gathering
and reporting operations.
- Eliminated manual run times and provided current
information to all time zones world wide, including weekends.
- Proactively checked application outputs to insure transformed
data and published reports were current.
Appropriate personnel automatically notified by email if there was a
problem.
·
Self-taught
Microsoft Access 95 and Thompson’s AWK (TAWK) to extract data from various
sources outside the company standard Oracle and SQL Server databases.
- Expanded the information warehouse which reduced end
user time spent generating reports.
·
Documented
reporting processes and development techniques for all reporting capabilities.
- Provided critical operational instruction for back-up
personnel during vacation and other Out Of Office periods.
·
Created detailed
reporting capability and technical user guide documentation for end users.
- Reduced interruptions and reduced wasted time by
allowing users self-help functionality.
·
Ability to work in
highly independent as well as team environments.
- Worked with IT to successfully deploy required
reporting system application components and interfaces to related databases to
meet customer requirements.
- Maintained a centralized reporting web site, assisted
publishing a monthly internal newsletter, and held meetings in virtual and
face-to-face formats to keep management and team members constantly updated.
Sonar Technician Surface, Third Class
6/1994 Southern
·
Bachelors of
Science in Computer Information Systems; Minors in Business Administration,
Photography