Banner Image

Skills

  • VBA
  • Data Management
  • Microsoft Access
  • Microsoft Excel
  • SQL
  • Creative
  • Design
  • Microsoft
  • Ado
  • Banking Industry
  • Data Extraction
  • Database Design
  • Feasibility Studies
  • Finance
  • Financial Analysis

Sign up or Log in to see more.

Services

  • Financial Modeling

    $50/hr Starting at $2K Ongoing

    Dedicated Resource

    Financial modeling using Access, Excel, VBA, SQL Balance Sheets  Income Statements  Cashflows  Predictive Analytics Projections  Budgeting Variance Analysis Reconciliations Pricing Models Statistical...

    AdoBanking IndustryDatabase DesignFeasibility StudiesFinancial Analysis

  • Microsoft Access

    $50/hr Starting at $2K Ongoing

    Dedicated Resource

    VBA Code  Create | Edit Queries  Create MS Access Forms Full GUI Design Optimizing Inefficient Access Databases Data Schema  Data Import  Data Scrubbing  Application Design  End-to-end Process Engineering...

    AdoCreativeData ExtractionData ManagementDatabase Design

  • Microsoft Excel

    $50/hr Starting at $2K Ongoing

    Dedicated Resource

    VBA Code  Importing Data  Robust Data Validation Modules Manipulating Data  End-to-End Spreadsheet Design  Excel Templates  Excel Reports Excel Process Optimization Streamlining Excel-based Manual Processes...

    AdoData ManagementDatabase DesignGUIMicrosoft Access

  • MS Access | Excel | VBA | SQL Developer

    $125/hr Starting at $5K Ongoing

    Dedicated Resource

    Delivery-oriented, highly efficient, hands-on, experienced Microsoft Office Developer defining, driving and executing scalable tactical and strategic financial technology roadmaps Create operational efficiencies...

    AdoCreativeData ManagementDatabase DesignDesign

About

Data/Project Management | Technical Business Analysis | Process Engineering | Automated Reporting | Access | Excel | VBA | SQL Solutions

- Specialize in integrating easily supportable, low cost, full featured end-to-end workflow automated solutions, leveraging readily available applications and platforms as Access, Excel, and VBA

- Anticipate internal and external business challenges and/or regulatory issues, and identify and recommend creative approaches for improvement

- Experience in utilizing iterative refinement of requirements and following a proven development method that always exceeds expectations and guarantees additional functionality

- Proven record in implementing conceptual and innovative stop-gap solutions for processes which are missing from Core IT Systems

- Integrate proprietary and vendor systems by engaging business stakeholders, technical leads, and analysts with defining objectives, training, documentation and immediate production support

- Re-engineer user created Excel spreadsheets or inefficient Access databases to optimize performance, eliminate process risks and operational challenges and provide intuitive interfaces and enhanced UX


- Primary technologies:
Microsoft Access | Microsoft Excel | VBA | Visual Basic | VB Script

- Data connectivity:
Microsoft Access | ADO | DAO | Microsoft Excel | HTTP | Microsoft Azure | ODBC | Oracle | SQL Server | Sybase | Text Files | XML | COGNOS | Essbase | Hyperion | Salesforce | SAP

- Databases | Servers:
Microsoft SQL Azure | Oracle | SQL Server | Sybase

- Business intelligence:
Bespoke Excel Reporting Templates | Business Objects | Pivot Tables | Microsoft Power BI | Power Pivot for Excel | Microsoft Power Query | Qlikview | Tableau

- Financial data providers:
Bloomberg | Reuters | OCC

Attachments (Click to Preview)