Top Upwork Freelancers

Clear all filters

Douglas Spence

Douglas Spence

Skilled Developer - T-SQL, C#

United Kingdom - Tests: 9

Currently my strongest skills are C# and SQL Server, but I have used a variety of other programming languages and technologies historically, including: VB3-6, Delphi 4&5, VBA, C++, ASP.NET. I started programming over 20 years ago as a teenager and knew immediately it would be my future career. I am comfortable working with (and enjoy) complex problems and feel this is a specific strength of mine. I prioritise and value long term client relationships where I can build understanding of a problem domain over time and provide development expertise and design solutions that maximise my value. I work well independently and consider myself able (upon understanding a problem domain) to both design and implement a solution. I welcome opportunities to expand and develop my knowledge and skills.

100% Job Success
$27.78 /hr
4,784 hours

Arul R.

Arul R.

VBA / Excel Guru

India - Tests: 16

Microsoft Office VBA Expert. Develop event based multipage UserForms with class objects, Array formulas, Regular expressions(amazing for matching almost all pattern matching requirements and text mining with Excel). Developing Executive summary dynamic dashboards. Ranked in top 1% of all Odesk Excel freelancers. skype me arul.rajesh for instant queries.

$30.00 /hr
12 hours

Tomislav Malis

Tomislav Malis

Excel / VBA Expert / BI Power User

Croatia - Tests: 5 - Portfolio: 6

I'm Business Intelligence / Excel / VBA & ETL Expert with Masters Degree in Civil Engineering, working as project manager professional. For 8+ years I have been working and mainly VBA programming in Excel, Word, PowerPoint, Visio and Access. Excel programming and formulas (regular, DAX), Excel Power BI, Excel Power Map, Project planning and Project tracking using Primavera P6, MS Project and other solutions are my area of expertise. SQL, HTML, CSS, D3.js, AutoHotKEy are also something that I like using in my work. For detail review of profile, portfolio and reviews see also .

$30.00 /hr
0 hours

Mike L.

Mike L.

Expert Crystal Report developer

United States - Tests: 1 - Portfolio: 1

Solutions oriented and highly analytical candidate with extensive experience in the analysis, design and development of Crystal Reports. More than eight years of experience with Crystal Reports with a sound knowledge of SQL, relational database and advanced SQL queries. In-depth knowledge of research methodology and the ability to manage complex data requests. Excellent analytical and troubleshooting skills with the proven ability to provide creative and effective solutions through the use of highly developed technical and problem-solving skills.

$55.56 /hr
0 hours

Simon Jerram

Renewable energy specialist and programmer

United Kingdom - Tests: 4

I have 15 years experience in software development, mostly in the field of set-top-box design, and testing. This work has involved coding in C, bug-fixing, code reviews, plus fixing various build set-ups linux start-up scripts in shell scripting, perl and python. Recently I have taken a career break and completed an MSc in Renewable Energy systems while looking after my son, so small pieces of work in the renewable sector would be welcome.

$18.00 /hr
0 hours

John A.

John A.

Programer / Cad Operator

United States - Tests: 12 - Portfolio: 3

I able to adapt quickly to new environment and fast to learn new task. At Kan Build I learn AutoCad by reading the documentation, in less the 30 days was at the level, of other drafters with formal training and years of experience. During my time in the Navy and at Kan Build, with my knowledge of computer and database implementation, I was able to save money and time, by increasing productivity. One of the many applications I Developed used a database to select and attach detail to a drawing saving the drafter an hour each drawing. I also have some experience in the following areas: Wordpress, CSS, PHP, and other Web design and testing.

$20.00 /hr
4 hours

Neil W.

Neil W.

Web/Software/Database designer/developer

Australia - Tests: 8

Over the past 15 years, I have worked in a variety of roles using the Microsoft Office suite to complete many differing tasks for State Government and small businesses. My motto is 'Work smarter, not harder', leading me to often automate my tasks using a combination of macros and VBA code, making it possible to get more done in less time. I also have experience with C#, HTML, HTML5, CSS, CSS3, ASP.Net, PHP, VB, and have created a few websites for friends who have their own business, both static and dynamic (including Ajax) styles. I also have extensive experience creating, managing, maintaining and improving Access databases and Excel spreadsheets, as well as transitioning Excel spreadsheets into more functional Access databases, increasing data analysis capabilities and ease of use, often also increasing automation with the use of Macros and VBA. Finally, IT work is my full-time job and hobby, having been an enthusiast since I was 6 years old, working with Extended Color BASIC on a TSR-80/Tandy Color Computer 2. I am available most hours, in the short term and the long term to support and enhance the solutions I develop.

$33.33 /hr
0 hours

Sipra Karmakar

Sipra Karmakar Agency Contractor

Excel/VBA Expert/Automation

India - Tests: 15 - Portfolio: 6

I have worked on various projects like preparing excel models, writing VBA codes to automate the process, dashboard, MIS reporting etc. The reports have helped clients gain efficiency and improve quality. Automated repetitive reports using Excel, VBA, SQL, QlikView, Integration with SharePoint - Prepared an excel macro which is connected with Access db and SQL server; pulls data and generates the report in excel. - Excel macro to create slide decks - Excel macro to fetch updated data from the DB, refresh the report and upload the file directly into SharePoint. - Competent in loading data from multiple data sources into Excel Reports using Excel VBA - Created Excel Add-Ins to simplify the process - Designed and automated pipeline, attach dashboards in QlikView. Preparing Regional Gross Margin Report: - The project involves preparing gross margin report per quarter. The report serves the purpose to decide the profit margin per quarter. - The final output of the report goes into PPT. I wrote an excel macro which applies the filter in various sheets and then copies the charts to prepare the slide decks. - The macro has saved 1 FTE for the team. Project Performance Report: - Prepared an Excel/VBA tool to generate project performance reports - The tool allows project leads to select projects and generate the dashboard with just a click of button - It allows to send the report through email as attachment (Excel or PDF) Transaction reporting: - Generating business transaction reports like Project Plan, Labour Booking, Labour Cost, Invoice, Purchase Order and Balance Sheet. It follows three steps process: - Prepared a macro to login to SAP (Compass BW) and extract the data in csv format. - Cleaning and storing the data in Access db/SQL server - Prepared a macro to refresh the excel reports which are linked with the database. Macro also creates a reconciliation report and finally uploads the files in SharePoint.

Associated with: Eazzy Freelancing Agency

$6.67 /hr
103 hours

Michael Yocom

Michael Yocom

Excel Macro/VBA Scripting/Automation Specialist

United States - Tests: 4

Trying to find a project to challenge my automation skill set. I spend my days automating reporting processes and analytical responses in the workplace, but nothing challenging finds its way to my desk these days. I pride myself on the speed and accuracy of the implementation of my advanced and creative solutions to data management, and would love to have something to work on from home when the workday draws to an end. Born and raised in the USA, my fees are very negotiable. ~Michael

$22.22 /hr
21 hours

Adam G.

Adam G.

Business Analyst and Excel Expert

United States - Tests: 5 - Portfolio: 1

Excel expert available for consulting and project work. Highly experienced Excel user capable of complex data analysis. Excellent at setting up programming for easy and repeatable report generation, or drilling down through "data dumps" to locate vital data and identify significant trends. Utilize expert level formulas and macros to minimize end user effort and maximize output that is both useful and meaningful. Very experienced creating a wide variety of aesthetically pleasing charts and tables for high level overviews and intricate outlines of existing data for client presentations.

63% Job Success
$35.00 /hr
18 hours