Completed

SQL/Excel Wizard Needed

My team is looking for an expert in excel. This person should:

1-Be a wizard at building macros in excel pulling data stored in SQL and generating report templates.

2-Have a strong SQL/MySQL background.

3-Have past experience creating dynamic command buttons which sort and screen large datasets.

4-Have past experience with report writing and scheduling development producing high-grade client interfacing reports.

5-Be familiar with report writing tools such as Crystal Reporting Solutions, Quark.ex.

This project will be on going and is looking for someone who is willing to think outside the box and be innovative with their skills.

Thanks..

To add a bit more clarity. We have created one database in MySQL for portfolio modeling and would now like to create a reporting portion based off excel reports sent by a 3rd party. These files will be batched and delivered to a central folder where they will be picked up and automatically ingested into the MySQL database (I can send you sample files if needed). From here you must be able to create dynamic reports. This project is not complex at all however there is a great deal of detail needed for the reporting. I would be open to hiring a freelancer to cover this whole project with right qualifications and recommendations. Please send me your quotes for just the excel portion or the full project along with any questions or concerns. Thanks!

This is my first time using this site and realized I've been going about it all wrong... the more detail I provide the more accurate quote you can provide me. I have a large number of on going project related to the above and would prefer to develop a relationship with a programmer on a project by project basis. Please provide a quote on the below task and I look forward to speaking soon:

Reporting Layer



Workbook
Workbook will consist of several worksheets
Summary page – showing the summarized data with Top and Bottom Factors and other information in a single page
New Securities – securities that are in today’s data but not in previous day’s data.
Missing Securities – securities in previous day’s data but are not in today’s data.
Row Count – Lines previous day’s file compared to lines today’s file
There will be 2 sets of pages that look almost exactly alike:
The data is pulled from tables in SQL and presented with no changes.
Percentile Factors – Data pulled from SQL.
%Tile Factor Score Calculations – Data pulled from SQL.
Raw Factors – Data pulled from SQL
Raw Factor Score Calculations – Data pulled from SQL
Workbook is saved off daily, after processing with an easily understood naming convention and dating method. Such as FactorReport.20110810

Automation

Automatic update of workbook when the data in SQL is updated.

Client can run the Excel portion manually, as long as the data is available in the correct location. This would be most useful if there were several days of reprocessing to be done.

In general it is assumed that the process is daily with little need to go back, and re-process for previous days, but the functionality is desired to be included.

Note: Top Score Improvements and Top 10 Score Reductions
This will require comparing current day’s factor score (%Tile Factor Score Calculations worksheet, Column O) with the previous day’s factor score. The previous day’s scores are available in a SQL table so would require calling the data from SQL and comparing previous day’s to current day’s and then sorting to find highest and lowest 10 changes.

Note: In the Excel workbook Factor Score Reporting Layer – the table data for %Tile Factor Score Calculations and Raw Factor Score Calculations as well as the Percentile Factors and Raw Factors are the same. The file layout will be as is shown but the data is not yet available.

Skills: Excel, Microsoft Access, MySQL, Powerpoint, Report Writing

See more: writing wizard, writing macros in excel, writing macros, writing excel macros, writing crystal reports, reporting writing skills, powerpoint excel expert, macros expert, looking for excel expert, looking for an excel expert, expert with excel, expert powerpoint templates, excel expert skills, excel 0 to expert, crystal reports writing, crystal reports development, be expert in excel, be an expert in excel, sql experience, Expert in Excel, Sql reports, Sql reporting, sql mysql, sql and c, sort excel

About the Employer:
( 1 review ) san francisco, United States

Project ID: #1158969

Awarded to:

fedalal2

Hi, I have more 10 years experience in MS Access, MS Excel and VB (VB.NET), so I'm realy GURU in this. I can help you with this project. Best Regards, Alex

$400 USD in 3 days
(24 Reviews)
5.0

13 freelancers are bidding on average $328 for this job

mrbrave

See PMB for details please..

$300 USD in 5 days
(65 Reviews)
5.3
AccuPro

Can do this.

$500 USD in 5 days
(7 Reviews)
3.7
KarinPinazo

Hello, Please read your PM

$260 USD in 4 days
(1 Review)
1.0
baknige

Hi! please check your PMB. Thank you.

$300 USD in 10 days
(0 Reviews)
0.0
hemesh28

I'd love to do this job.

$250 USD in 7 days
(0 Reviews)
0.0
radovanovic

This is very similar to tasks I have doing for past 5 years. So, I can do that. Please, se PM.

$650 USD in 5 days
(0 Reviews)
0.0
rehankhan85

i am ready to work with [url removed, login to view] check me once. payment will snd me after completing proj.

$300 USD in 5 days
(0 Reviews)
0.0
todsnewlife

I am eager to become your go to guy for these Excel projects. I have over eight years of experience developing and maintaining automated Excel reporting solutions to meet the business needs of various clients. I can su More

$250 USD in 30 days
(0 Reviews)
0.0
samy866866

Dear Sir I am a professional programmer and have previously worked in Visual Basic the primary langauge for writing macros in excel. The data base i used during my programming is sql. I also have the experienc More

$250 USD in 7 days
(0 Reviews)
0.0
iinergi

I have been using Excel macros to mine SQL databases for 10+ years. I bring 18 years of fortune 500 experience completing all types of IT projects.

$250 USD in 10 days
(0 Reviews)
0.0
rapidDev2010

I would like to be considered for this project. I am an honours graduate in Software Engineering and have over 10 years professional experience in Database design and development and am an expert in VBA and office appl More

$250 USD in 4 days
(0 Reviews)
0.0
Lahiru824

please check my p.m.b.

$300 USD in 5 days
(0 Reviews)
0.0