Highly qualified and experienced financial mathematician and derivatives expert with advanced Excel VBA and writing skills. I have real world options and futures trading experience, both open-outcry and screen-based, and have built Excel/VBA -based risk systems for management of traded positions incorporating parametrized volatility surfaces over expiry and strike ranges for STIRS options. Having always worked for small entrepreneurial firms, I've also played a key role in developing and bringing to market innovative but complex products. It has then often been my responsibility to provide not only the requisite technical and regulatory documentation, but also a jargon free description intended to convey the essence to the non-specialist.
Get Your VBA Development Project Started Today!
Post your VBA project on oDesk and find freelance VBA programming experts. These professionals can write VBA code for Excel (e.g. web scraping and graphic charts generation functions), create a visual environment with entry forms, write VBA scripts to change formatting or fill in data from your software, or clean up Excel or Access files (rearranging columns or removing special characters). They can also add FTP upload functions or design VBA-based templates for your Microsoft Word documents, create custom contact forms for Outlook, write VBA macros to export Microsoft Access data in custom formats, and add or remove features in your Access database.
Visual Basic for Applications (VBA) is a Microsoft programming language that enables the development and process automation of user-defined functions. On oDesk, the world’s largest online workplace, experienced VBA developers can manage your Microsoft Office automation or UI modification, review and fix your VBA functions, and help you transfer data automatically between MS Office applications.
VBA Job Cost Overview
Typical total cost of oDesk VBA projects based on completed and fixed-price jobs.
oDesk VBA Jobs Completed Quarterly
On average, 191 VBA projects are completed every quarter on oDesk.
Time to Complete oDesk VBA Jobs
Time needed to complete a VBA project on oDesk.
Average VBA Freelancer Feedback Score
VBA oDesk freelancers typically receive a client rating of 4.79.
Effectively combine my technical expertise and Domain knowledge in conceptualizing and implementing solutions that align IT initiatives to achieve business goals within given TIMELINE, ensuring QUALITY & COST OPTIMIZATION in the best possible way. ================= CORE COMPETENCIES: ================= IT Infrastructure support involving network & server support; Automation through scripting using VBA & VBscripts; Technical documentation; Trainings; Transcription;
Entrepreneurial Spirit with strong analytical, interpersonal, and technical skills. Graduated from University of California, Irvine majoring in Business Economics (analytical), Business Information Management (technical), and International Studies (interpersonal). Have a diverse skillset spanning all areas of business from, Accounting to Finance to Marketing to Sales. Able to understand the business concepts and principles as well as the coding/technical framework and be able to bridge the gap between the two. Able to think forwardly about potential problems and situation that could arise and present a holistic view on the scenario. Able to creatively morph and re-engineer processes and data in order to summarize and present data in views that would not have been possible by the system.
Keashan Jayaweera Agency Contractor
I’m an excel user & an Excel VBA developer with 3 years of experience. Create any kind of macro that automate your works will make me happy. I will create Pivot Charts that give you summarized report or any kind of excel file (Dashboard / Report / etc) which are fitted to your custom needs.
Daniel Fittipaldi Agency Contractor
I have an Excel Consulting company in Brazil. My company's greatest differential is quality, both in services as in costumer relations. We are reliable, communicative, and follow prices and deadlines that were agreed. We are proud to say we never had any complain from any client, and we do everything to keep it that way. We can understand the client's needs beyond the Excel Worksheet, and deliver exactly what he needs and what he was looking for. We have a solid understanding from financial, marketing and other administrative knowledge, and this results in a fully comprehension from the client’s necessities. When this is allied with great VBA and Excel knowledge and experience, we provide a great service. By hiring us, you will have the security of dealing with a company, with a reputation to maintain, easy to contact and very well-known among its customers. Find out why no client ever complaint from us.
For 6 years in IT Industry, Im accustomed in pursuits of best quality services, improvements and real time support in IT infrastructure to achieve company business goals. And meet the client expectation and satisfaction. To excel full customer service as years experience in network consultancy, combining with programming skills.
Over the past 10 years, i have developed and delivered full functional solutions ranging from business insights, Visualizations right up through predictive modelling and statistical learning and analysis and through excel VBA development. I have steadily learned from our experiences and want to leverage this expertise to develop solutions and services to various people across the paradigm and looking forward to get involved in developing a hybrid solutions in order the address the problems and facilitates their growth. Statistics and Reporting: > Coupon Recommendation – Leading the project and developed an algorithm and a web based coupon recommendation engine for leading US wholesaler. Recommended and build unique statistical hybrid algorithm in combination with clustering, item-to-item and user based collaborative filtering (used Mahout, Python, R) > Inventory optimization and Price Simulation Tool – Developed a sophisticated forecasting framework using ARIMA, ARIMAX and exponential smoothing and devised the gap analysis process for inventory optimal recommendation work-stream and devised conjoint, price elasticity, market adjustment process for pricing work-stream. Drove the implementation of end to end one-click automation of this process for automotive dealer (Used R, Tableau, SQL, SSIS, Java) > CRM/Marketing Analytics – Led the offshore team/project and developed simplified K-means clustering methodology for skill rank modelling process and Logistics regression for Churn modelling process. Also revamped the automated campaign reporting tool and proposed improvised personalized recommendation engine (Used Excel VBA, R, Qlikview) > Enterprise Reporting and Dashboard – Handled the enterprise reporting and dashboard development for one of leading US game publisher and revamped and developed an innovative BI dashboards (Tableau & Qlikview) for top management. Automated the dashboard creation using R & Postgres resulted in 52% reduction in dashboard development process > Developed Inventory Simulation and Instock analysis Tool which resulted in 90% Instock against 94% goal for Cosmetics and improved order fill rate from 88% to 92% for Beauty and Order approval rate to 98% from 84% for Toys > Channeled in and Lead the offshore initiative of Forecast Evolution – Re-engineered early warning forecasting system for Hardlines Category. Proposed and implemented the ultra-segmentation techniques (K-means clustering) which resulted in improvement in mature store sales by 100 BP, Instock by 30 BP and forecast by 639 BP (SAS, Excel, MS access) > Maximized category sales by effectively managing open to buy, Merchandise forecast & allocation based on affinity analysis and strategically planning inventory for Advertisement & Company Space promotions for a business category worth over $30M in sales > Developed and standardized performance measurement and productivity dashboards across all categories and teams > Hands on development of regular forecasting model and Automated the forecasting process and developed forecasting engine Kit encompassed with Seven forecasting methodologies > Provided Analytical Solutions and support to business operations in Capacity Planning, Forecasting & Scheduling, Agent Tracking, and real time analysis and support of over 2,000+ FTEs in a multi-site call center environment. Optimized the scheduling process resulted in 20% improvement in schedule efficiency VBA Based Development 1. Developed legacy excel products for automated UI solutions 2. Developed CSV to Excel report generator 3. Developed Petty Push Inventory Tracker Application 4. FAR - Forecast Accuracy Application - Enterprise level 5. INFANT - Instock Fix and analysis Tool 6. MFT - Master Fix Tool 7. LIST - Like Item Selection Tool 9. Automate Everything 10. Invoice Automation & Enterprise level financial reporting automation 11. Capacity & Roster planning tool 12 Merchandise Planning Strategic Planning Dashboard 13. Team Performance Tracking Dashboard