Menu
Sign in Register

Back to listings

Shortlist
Tweet page Print page

Excel Reporting Services

Typical budget: $3,000 and under
Located in Schofields, NSW, Australia

View website

I have a management consulting background with strong corporate experience. Highly focused & obsessed with customer service and value delivery.

Capabilities:

  1. Microsoft Excel Report Development (17 Years Experience)

    • Creating dashboards / Business Intelligence solutions
    • Troubleshooting & Problem Fixing
    • VBA / Macro design and development
    • Power BI / Power Query / Power Pivot / Power View
    • Excel Training (tutored at University)

  2. Website Development (15 Years experience)

    • Wordpress
    • Prestashop
    • Jquery Development
    • CSS / HTML5
    • E Commerce

  3. Supply Chain Management (12 Years Experience)

    • Supply Chain Strategy
    • Sales & Operations Planning
    • Supply Chain Operations
    • Supply Chain Systems (SAP, Oracle)

  4. Project Management & Leadership (10 Years Experience)

    • Led large teams (20 - 150 people) in the context of enterprise transformation
    • Specialize in managing complex and high pressure projects

Languages:

  • English (Superior / Fluent / Native)
  • Afrikaans (proficient)

Advanced and Intelligent Automated Loan Calculator

CLIENT BRIEF Simplify all macros and logic on the existing loan calculator. Fix faulty macros and optimise and improve the process.

SOLUTION Using power BI, all source data was extracted, transformed, validated and loaded into the tool. All macros were eliminated.

VALUE ADD The logic and functionality of the tool was evolved to the next level, intelligent predictors, insightful charts and scenario planning was developed and incorporated.

Related Services: Excel Troubleshooting and Problem Fixing

Skills & Industries: Advanced Excel, Advanced Reporting, Automation, Data Aggregation, Data Extraction, DAX, Excel, Financial Planning, Loan Calculator, Loans, Macros, Power BI, Power Query, Reports

http://www.excelreporting.com.au

Web Scraping Real Estate Sites

CLIENT BRIEF Rapid extraction and turnaround required from a Real Estate Portal. Detailed and complex filtering rules and data transformation logic to be incorporated into the extraction script.

SOLUTION All 1600 records were extracted within the specified timelines with razor sharp precision and accuracy using specialized tools.

VALUE ADD Solution was white labeled and all scripting was fully shared with client during a thorough handover that included training and skills, knowledge and IP transfer.

Related Services: Excel Reporting,

Skills & Industries: Automation, Data Extraction, Excel, Macros, Scripting, VBA, Web Scraping

http://www.excelreporting.com.au

Business Intelligence Dashboard

ABOUT THE PROJET I love hearing things like: "We never knew Excel could do that?" or "That doesn't even look like Excel anymore"

We cleaned, normalized, validated and transformed our clients data to build an interactive sales dashboard. The client really responded well to the visual nature of the reporting and the overall simplicity of the data model.

Tools used: Power Query, Power Pivot, Power BI

Related Services: Excel Reporting, Business Intelligence

Skills & Industries: Data Processing, Excel, Business Intelligence, Data Cleansing

http://www.excelreporting.com.au

Like what you see? Get in touch with Excel Reporting Services

Contact Excel Reporting Services

Don't forget to say you found them on OzLance.