Find Jobs
Hire Freelancers

automating a quarterly process in a company

$30-250 USD

Closed
Posted over 8 years ago

$30-250 USD

Paid on delivery
-need help in generating 250 reports in excel, having them posted to SharePoint for people to review and edit, then I need to generate a report that shows all of the people who have checked in their document and edited it on SharePoint. any that are missing get an email sent to them in outlook. at the end of the process we look at write-ups and write-offs per group. this is an estimate to complete project. very manual and takes days to complete. have to review each individual excel sheet and check what is missing.
Project ID: 8470314

About the project

14 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average $203 USD for this job
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
4.9 (419 reviews)
7.6
7.6
User Avatar
I have been working with VBA for three years for companies like IBM, MSCI and Ford Motor Company. I have already created a similar toll that automated report generation for 21 European countries. It runs 21 different SQL queries every night, pastes the results to an Excel workbook and saves the file to the countries' own Sharepoint folder.
$133 USD in 3 days
5.0 (129 reviews)
7.1
7.1
User Avatar
Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access DB. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$242 USD in 3 days
4.7 (91 reviews)
7.3
7.3
User Avatar
A proposal has not yet been provided
$200 USD in 3 days
5.0 (6 reviews)
6.8
6.8
User Avatar
Hi I would like more information about the project. I have been working with MSSQL for over 15 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo
$250 USD in 30 days
5.0 (70 reviews)
6.3
6.3
User Avatar
Dear Sir, Done numerous similar projects in past the and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in MS excel, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$222 USD in 5 days
4.9 (83 reviews)
6.1
6.1
User Avatar
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. I have worked on lot of advance Excel dash boarding and VBA coding using Microsoft access database, SQL and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
$250 USD in 3 days
4.9 (22 reviews)
5.8
5.8
User Avatar
Hello, I have been working as freelancer since last ~ 2.5 years, prior to this was working with a MNC as a Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work; I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov Point5nyble
$250 USD in 3 days
5.0 (52 reviews)
5.5
5.5
User Avatar
I am an experienced SharePoint Developer with 3+ years of experience. My experience revolves around SharePoint(2007,2010,2013), ASP, WCF, Azure, MVC, AngularJS etc. I believe I am well qualified candidate For This Job. Around this requirement I have deep Understanding of - SharePoint Object Model - SharePoint Workflows - SharePoint OOTB - Excel Code My Coding skills are enhanced with Microsoft Programming Practices. From my past experience of different projects I am very good at problem solving and writing maintainable code. Along with code I have deep understanding of various Out of Box Parts of SharePoint as a saying "A SharePoint Developer is by Default SharePoint Administrator". My Experience of working with large scale project awarded me with analytical and management skills. I can handle a project from requirement gathering to delivery. Planning is very important part of software development from small to very large projects, In case of SharePoint it is even more important because we have a huge set of functionality already provided by Microsoft which is just a few click away. I Can Assure you best quality within time.
$266 USD in 3 days
4.8 (6 reviews)
3.9
3.9
User Avatar
Hi, I have extensively worked on SharePoint, with over 5 years of experience in working with leading industries on live projects. I am currently on sabbatical leave and give 100% to this project. Looking forward to working with you. Thanks!!
$155 USD in 10 days
5.0 (1 review)
2.4
2.4
User Avatar
I know your heart is set on Sharepoint, but consider a browser-based cloud database application service that includes ALL IT services in a single plan. During twenty years of creating database applications for clients, I developed a method to support a diverse set of CUSTOM applications. We combine all services: DESIGN, DEVELOPMENT, HOSTING, TRAINING, and SUPPORT into a single plan--one low monthly fee to fully support your IT needs. Search for "Konduit Transaction Editor". I can set up your CUSTOM Project Management database application on a production Transaction Editor (TEd) cloud server within two weeks for just $250. Users can Test Drive the application online for two months as we continue to refine your requirements. You get immediate hands-on experience and we can calculate the affordable monthly recurring fee based on the complexity of the application we build. * Each TEd application combines spreadsheet ease-of-use with the accountability of a database and includes ongoing professional APPLICATION support. * Intuitive SEARCH, SORT, and VIEW-creation capabilities * All user data changes recoverable from CHANGE HISTORY LOG * Column and Row USER-ACCESS CONTROLS * Highly reliable and secure * IMPORT/EXPORT - named VIEWS and file format specifications * JOB scheduling and EVENT-based data modifications * NOTIFY capabilities * and so much more... Contact me for a demonstration.
$277 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$177 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Thank you for viewing my profile! I am a detailed and thorough with over 9 years of Microsoft SharePoint Application development experience – includes WSS 3.0, SharePoint 2007, SharePoint 2010 and SharePoint 2013 on-premise and SharePoint online / office 365 and Azure. I specialize in delivering quality services with respect for strict deadlines and high expectations. I am equipped with dedicated home office complete with high end computer with required software installed and uninterrupted high speed broadband internet connection. I provide effective Enterprise Content Management solutions to the business using Microsoft SharePoint tools and technologies and Office 365. I excel at working with tight deadlines with strict expectations. I possessed the self-discipline and time management skills necessary to have served as virtual employee for the past couple of years. I can bring value to your business using my years of experience as a developer, team lead and project management experience. I have expertise in all development avenues of SharePoint and provide business effective solutions that can be value added to the business and end users. In my 9 years of experience I have been involved in requirement gathering / envisaging, designs of solution, development/implementation, unit testing, packaging, UAT / Production deployment, post production support, end user training and imparting SharePoint technical training.
$277 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Chicago, United States
5.0
3
Payment method verified
Member since Sep 14, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.