Excel SME - VBA developer, Report Writer Resume - Hire IT People

WORKING EXPERIENCE:

Confidential

Excel SME - VBA developer, Report Writer

Responsibilities:

As part of the Liquidity Risk department, designed and automated and coded Excel-Based reports using VBA and Excel functions
Designed and customized reports using Tableau and Access
Assisted with the firm-wide UAT, quantifying and creating projections for assets and liquidity when applying various stress factors.
Wrote documentation for all processes

Confidential

Excel SME - VBA developer / Technical Writer

Responsibilities:

Remediated and created excel-based reports to track global on-boarding metrics.
Documented and diagrammed processes and developed detailed written project overview, including desk instructions and technical specifications.

Confidential

Excel SME - VBA developer / Technical Writer

Responsibilities:

Remediated excel-based reports consistent with firm-wide update of inventory numbering system.
Documented and diagramed processes and developed detailed written project overview, including desk instructions and technical specifications.
Rebuilt Excel-based Markdowns tool, including, data import formulae, extensive use of index/match and other functions, user input forms with VBA.

Confidential

Excel SME - VBA developer / Technical Writer

Responsibilities:

Documented and diagramed “As-Is” and “To-Be” states and developed a detailed project plan (system overview) using PowerPoint.
Automated and customized high-level reports (which had been manually generated) with VBA and by adding function / lookups to workbook.
Wrote simple and replicable Desk Instructions for staff.

Confidential

Business Analyst - Excel specialist

Responsibilities:

Analyzed and remediated various issues and conflicts arising from Excel 2013 rollout.
Interfaced with Bloomberg, FactSet, and other in-house add-ins to troubleshoot and remediate conflicts.
Diagnosed Excel conflicts and performance issues using MS Telemetry as well as other tools.
Authored technical documentation, and best practices artifacts for users and helpdesk.

Confidential

Business Analyst - Excel specialist / Technical Writer

Responsibilities:

Designed an excel based application to track daily, weekly, and monthly futures quotes in various energy fields to prove compliance with company hedging plans.
Imported and linked data based on financial instrument, created dynamic lookup tables and appropriate links.
Created and revised futures charts and linked with PowerPoint.
Wrote macro in VBA to automate and update data procedure based on workday function.
Documented procedures and processes. Created User Manual. Presented to staff.

Confidential

Access Developer / Excel Analyst / Technical writer

Responsibilities:

Researched and developed documentation for all departmental procedures.
Streamlined and documented data procedures and reports in Access and Excel to assess and track compliance for high need students.
Wrote and revised macros in VBA to automate reporting and data management processes.

Confidential

Access Developer, Technical writer and Project Manager

Responsibilities:

Designed and constructed a database solution to track and report on high level financial transactions which had previously been tracked and reported on from Excel.
Designed and constructed database (including requested queries, forms, custom reports, macros and VBA audit trail routines).
Created safe and verifiable migration plan from Excel to Access.

Confidential

Senior Desktop Software Analyst / Technical Writer / Access Developer / Applications Trainer

Responsibilities:

Developed and maintained Access DB to track copiers through the U.N. Secretariat complex.
Developed documentation for all departmental procedures
Customized Excel projects (with Macros & VBA)
Served as Team SME for Excel, Access, PowerPoint and Word

Confidential

Software Trainer

Responsibilities:

Created and delivered pre-scripted and original needs-based curriculum in classroom and one-on-one settings in all levels of Word, Excel, PowerPoint, Access, Outlook, FrontPage, Quark, HTML and Photoshop.
Created and remediated Excel and Access projects on an ad-hoc basis for private clients.