Find Jobs
Hire Freelancers

Report Conversion and Automation: Python

$250-750 USD

Dibatalkan
Disiarkan sekitar 2 tahun yang lalu

$250-750 USD

Dibayar semasa penghantaran
There are about 30 Forms/reports that are to be submitted to Federal semi-annually with very specific requirements. These reports have already been written and designed in SAS programing language. Each Form/report extracts data from the SQL Server Table and then is formatted to the Federal requirement via SAS programs and macros. Once each Form is validated, SAS writes the report in CSV format and saves it in a specific folder. Each report (CSV) is then being validated via Federal validation tools and if it passes the requirements, it will be uploaded to the Federal report repository server. I need these reports to be converted from SAS to Python and be automated to extend possible. Most of SAS logic is straightforward logic such as variable/column name assignment (ex= Sex = Gender). Others are mainly if then else statements. Few use arrays and a bit more complex logic such as SAS macros. Due to very stringent security requirements, I can't share any data. The best scenario and practice is I can provide you the SAS program, you convert to Python, I test and we can both troubleshoot and once each Form/report is 100% validated, we move to the next one. I expect there is a good learning curve at the beginning but once completely grasped the structure, we can fast forward. I would like to get your ideas on how to go about it and if you had any exposure to a similar project. I would also like to know if you have had any SAS programming experiences. If yes, that is a bonus. If not, you may need to do a bit of research and figure out what SAS does in a specific script on your own. The desired outcome would be 100% automation. I have a fixed budget, but I need to hear from you and your background first. Please write a paragraph or two and describe your approach. PS. In order to be fair to those who showed interest in this project, I would like to know if you have any exposure to SAS programming scripting or not. If yes, for how long (no of months). If not, how comfortable you are working with other scripting languages. In this effort, I have provided a light and stripped version of the SAS sample program and I would like you to do the conversion. You can do the conversion of only a few lines so I can compare and contrast. Thank you
ID Projek: 33367417

Tentang projek

31 cadangan
Projek jarak jauh
Aktif 2 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Being a Financial engineer and avid programmer, I completed a lot of projects in Data analytics, Statistics, ML & Data Extraction in (R, Python, SAS, VBA-Excel); Finance; Reports and homeworks using LaTeX. That being said I always aim to fulfil my tasks quickly and provide the best end product to my customer whilst maintaining a good line of communication all along.
$500 USD dalam 3 hari
4.9 (5 ulasan)
3.2
3.2
31 pekerja bebas membida secara purata $458 USD untuk pekerjaan ini
Avatar Pengguna
Hi Mate, I’m a Professional and Expert Python Developer. I am interested in doing this job for you. I do have the necessary skill set & resources to complete this project. I will provide you project with that covers all the requirements that you are asking for. For the rest of the details, how about connecting on a Chat Box? EXPERTISE: Python, Excel, SQL, Software Architecture, SAS etc.. Looking forward to your soonest reply. Thank you Virang Patel. Bid Amount is just a placeholder, I will share the best timeline and cost once we both will be on the same page.
$500 USD dalam 7 hari
4.8 (42 ulasan)
6.8
6.8
Avatar Pengguna
Python , SQL , Excel Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
$500 USD dalam 6 hari
4.8 (203 ulasan)
6.2
6.2
Avatar Pengguna
Hi, how are you doing? I did a very similar job to this nearly and it was more complex and even involved Natural Language Processing. We did the work exactly as you are suggesting by continuous cycles of development and validation. I will be using a Python notebook for development and after all is done and is good we can convert the code to a simple application for windows. We can work a step by step to convert the SAS logic and get each step validated. For the data it will be great if you can anonymize it to test on it but if it's not possible we can discuss other ways for validation too (by creating fake examples maybe). You can message me to discuss more details.
$550 USD dalam 7 hari
5.0 (21 ulasan)
4.9
4.9
Avatar Pengguna
Hi, I have read this job carefully and i am very interested in this job. I am full stack web developer and i am very experience with Python. I can start working right now and looking for a good long term relationship. Regard, Ionel.
$500 USD dalam 7 hari
4.8 (11 ulasan)
4.4
4.4
Avatar Pengguna
Hi I read what you have described and I am willing to take up the project. I don't know SAS but since the SAS is pretty straightforward I don't think it would be problem to convert it into python. We can get the data from sql using python and format it and save into a csv.
$250 USD dalam 2 hari
5.0 (10 ulasan)
3.9
3.9
Avatar Pengguna
*****Senior C/C++, Python, JAVA, ALGORITHM EXPERT***** Hi, Client. How are you doing? I have deep knowledge and experience of C/C++, Python, Java/Spring/Springboot, Docker, and optimization algorithm. And I have experience of Web Full Stack, too. You can test my skill. I hope to discuss the project in detail and hire me. Budget is negotiable. Give me a chance, please. Thanks & Regards.
$500 USD dalam 7 hari
5.0 (6 ulasan)
4.0
4.0
Avatar Pengguna
SAS is a group of computer programs that work together to store data values and retrieve them, modify data, compute simple and complex statistical analyses, and create reports. I have rich experience in data analysis in SAS as well as macro. I can make this automation by using python. Hope your kind contact so that I can show you my background skills. Best regards!
$300 USD dalam 3 hari
5.0 (2 ulasan)
3.5
3.5
Avatar Pengguna
Hi There, Hope you and your loved once are doing well in this pandemic situation. After reading whole problem statement carefully, I understood that you want a python script which will function like your existing SAP script and also due to security issues, you can't share data to test. I can do this for you and also can provide a dedicated support to you until it gets completed. I am having 4 years of domain expertise and automation hands-on. Looking forward to work with you. Regards, Sameer A
$400 USD dalam 2 hari
5.0 (13 ulasan)
3.5
3.5
Avatar Pengguna
Hi helamob I have reviewed your job description I will provide you with clear, concise codes. I am a senior engineer with 5 years of experience in python, data analysis, automation . I’ve worked on several similar projects. I can deliver quality codes to tight deadlines. I’m interested to hear more about the project from client. If you award me the project, I’d be pleased to discuss this further and get started for you as soon as possible. Thanks! Nikoa
$500 USD dalam 7 hari
4.1 (4 ulasan)
3.3
3.3
Avatar Pengguna
Hi, I have gone through your description. C# is my area of specialization, i can get it done perfectly well in C#. Please ping me in person. I can help you to complete all tasks. I and my team have hands-on experience in programing field. Connect with us for more details, rest assured your satisfaction is guaranteed. Looking forward to your response.
$250 USD dalam 7 hari
5.0 (6 ulasan)
2.4
2.4
Avatar Pengguna
Hi, I believe I can help you in this project . If you are interested, feel free to message me and I will help you immediately. I am available right now -Skill-:- 1. I have 1+ years of experience in Web Scraping/Data mining from web. I can scrap almost any website, extract data and save it in JSON, XML, SQL, Pain Text or any other format you need. There is no limit of fields to be scraped or the number of pages. I mostly use Python script to scrap data but can choose any other programming/scripting language if you want. If you want to scrap any website, let's talk. 2. C# and Visual Basic coding 3. Html CSS and JavaScript 4. WordPress 5. Hosting and cPanel
$250 USD dalam 3 hari
4.5 (3 ulasan)
2.0
2.0
Avatar Pengguna
Hi! I am professional Web programmer with skills including Software Architecture, SQL, Excel, Python and SAS. I always work for the client's happiness and my work style is to meet a deadline with high quality work . Please send a message to discuss more about this project. Thanks & regards Wating for you
$555 USD dalam 4 hari
5.0 (1 ulasan)
1.0
1.0
Avatar Pengguna
Hello sir, I notice the details about this project. I think our team is the best option for this project. Because in our team there are many qualityful person to make this successful. And we also inform you that we will complete this at reasonable price with best quality. For any QUERY feel free to ask us. Stay home and Stay safe, sir. regards Istiak
$500 USD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
PYTHON EXPERT Hello, SOFTWARE ENGINEER I have read your requirements and find myself very suitable for this job. I have the needed skillset and experiences to handle this task .I ensure you to work as per your requirements and within your budget. Looking forward to hear from you. Thanks! CHRIS
$250 USD dalam 7 hari
0.0 (1 ulasan)
0.0
0.0
Avatar Pengguna
10+ years experience of c++/vc++/java/c#. 10+ years experience of the great globe poject. Joined the chinese high-speed railway project. Joined the chinese project of self service bank. Joined the globe project of HP.
$500 USD dalam 7 hari
0.0 (1 ulasan)
0.0
0.0
Avatar Pengguna
Hello I am a data entry operator my experience of 5 year I have best computer and internet connection Time is very important So give this project i complete this work of 4 day I hope you are fine
$300 USD dalam 4 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi, I will create a python script that imports pyodbc library and sets up configuration to connect to a SQL server database. Then we can create a cursor object from our connection and execute the SQL commands. I will then read the table and store it in a pandas dataframe, do some ETLs to meet the Federal requirement. And finally will write the final dataframe in CSV format and saves it in a specific folder.
$500 USD dalam 4 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Based upon the number of macros, data steps and proc steps, involved in the SAS programs, we both can agree upon time frame and budget. You would find most of my profile statistics as blank, as I am not regular in this platform, but trust me, I do have rich expertise in both SAS and Python. My previous project involved similar automation of SAS reports. A little about myself - Currently working as a SAS Developer in a reputed financial services institution. More than 5 years of experience in SAS; Base SAS certified and rich experience in SAS macros. More than 3 years of experience in Data Analysis and Data Visualization using Python and little bit in Django and Flask. Looking to build long term connection with like minded clients.
$500 USD dalam 14 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
HELLO THERE !! GREETINGS OF THE DAY!! we are WONDER POINTS CREATIVE SOLUTION PVT LTD , we are expert in PYTHON DEVELOPER over 10 years , and also we have a professionals team members who can assist you on your project , we have read your proposal carefully and we are ready to work with you lets finish this project as soon as possible. we also want a long term relationship with you please come into the discussion area so that we can discuss more about the project as well as about your essentials regarding your project OUR SERVICES:- *PYTHON *EXCEL *SQL *SOFTWARE ARCHITECTURE *SAS Waiting for your response!! Thank You
$500 USD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera UNITED STATES
Sandy, United States
5.0
1
Kaedah pembayaran disahkan
Ahli sejak Ogo 28, 2020

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.