Kevin O.

IT professional with 23 years of experience implementing software solutions for clients prior to becoming a freelancer. In my career I have worked in all phases of the software development life cycle (SDLC). I'm a problem solver with good communication skills. I have worked with clients at all levels. I bring this wealth of experience to my Upwork clients to effectively and efficiently deliver spreadsheet-based solutions to improve their business processes and save them time. Areas of proficiency and experience: - Complex Formulas (including Array Functions) - Advanced Lookup (including lookup on multiple values/fields) - Dashboards and Data Visualization - Power Query / Data Transformation and Loading - Complex Conditional Formatting - Performance Tuning - Data Validation - Tables and Pivot Tables - Charts - VBA/Macros - User Forms / Input Parameters - Helper Columns Notable Projects: - Automated payroll processing - Dashboards of varying complexity - Data analysis and survey charting - Stock Market Portfolio/Trade tracking (including equities, options, and futures) - Fulfillment/Sales/Inventory (e.g. amazon) - Modeling - Investment Performance and Trade Tracking/Reporting - Monte Carlo Simulation - Estimation/Invoices I am now freelancing exclusively and look forward to the opportunity to work with you.