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)
-
-
-