NodeJs/TypeScript AWS Lambda aplication to extract Excel Data
R$90-750 BRL
完了済み
投稿日: 6年以上前
R$90-750 BRL
完了時にお支払い
The project will be hired in steps. This bid is for the first step of the project:
Knowledge required:
- AWS Lambda Function
- AWS Aurora DataBase (similar to MySql)
- Node.js/Typescript
- AWS S3
- Excel Spreadsheet data extraction, using Node/npm js plug-in
OBJECTIVE:
Create a Lambda Function, using Nodejs/Typescript, triggered by a S3 upload, to extract unstructured data from a Excel file and put the data in the Aurora Database.
TEST CASE:
The end user will just upload the excel files - all files with exactly the same standard - to the S3. A trigger must activate the lambda function.
The lambda function must extract all data in specific cells, and write then in the Aurora DataBase, following the write patterns.
Considerations:
- The Tables in Aurora DataBase will be already created, therefore, the DataBase will be already available and configured;
- We will give you a data dictionary that maps each data to be extracted from the spreadsheet (cell address, such as B1 to [login to view URL]) to the DataBase Table and Column;
- The Excel file is in portuguese, we can help with any translation issue;
- Many fields are text in the spreadsheet, but represents categories in the DataBase. So, it will be necessary find out the correspondent ID of the text, and write the Id at the main table. For example, the field GENDER will be filled at the spreedsheet with Masculino (male) or Feminino (female). It will be necessary find the text at the Gender Table from the Aurora DB, get the genderId and write the genderId at the [login to view URL];
- There are 40 columns to be extracted, at this first step. Arround 15 are categorized fields, and the others are values (number, date, text, boolean);
- The position of the fields at the spreadsheet are not in a table format. They looks like a manual filled form (please see the attached image);
- Some spreadsheet cells must generate one-to-many relationship registers, to attend a specific pattern (we will instruct the bid winner after). For example, the body mass of the Patient will generate a new record, in the table Observation, with name=bodyMass and value=56, and the respective patientId;
- The full source code must be delivered, with instructions to be executed and published;
- It's not necessary a documentation for the code, but the code must be clear, well structured, object oriented, and with comments in - at least - all methods.
I've done similar work see:
https://www.freelancer.com/projects/Python/Python-Lambda-Query-JIRA-enrich/
https://www.freelancer.com/projects/Amazon-Web-Services/Build-AWS-Lambda-function-that-11704845/
Relevant Skills and Experience
I'm expert in Lambda, AWS, RDS, Aurora/mysql
Proposed Milestones
R$749 BRL - Default Milestone
Can you please share your excel file with me?
I am expert for nodejs and AWS system. Also i have AWS account for testing.
Relevant Skills and Experience
I have already work on such system
Proposed Milestones
R$1000 BRL - Complete
Let me know your availability
Hello I am highly interested to do your project . I am able to refresh this with your full satisfaction . I am confident about the work . I believe that , I can do this work properly and in timely according to your instructions. Always determined to give you the best work . Moreover , I have a group which consist of 6 members. Eagerly waiting for your response to start the project . Many Thanks
We are a Team of Technical Consultants and Data Engineers having healthy experience into Big Data technologies,IOT/Cloud/AWS and Python/AI+Machine Learning.
The Dynamic force has qualified engineers having expertise in solving complex problems.
We have Experienced Customer Service Representative with demonstrated history of working in industry.
I’m a Developer at Dafiti.com.br. I currently build statistical model to improve the sales performance and predict sales using Python, Machine Learning and other Data Science Tools.
Relevant Skills and Experience
3+ years experience with Python, javascript, Django, Node, Express
Proposed Milestones
R$105 BRL - Develop the required software
Hi,
I am having good knowledge and experience in NODE JS and AWS.
I am having strong knowledge and experience in AWS-SDK module. I used lambda and S3 and MySQL.
I can assist you to build your application using NODE JS.
Please text me and share more details about your requirements.
Thanks
I am a Lead Developer/Architect having strong background in Object oriented architecture, analysis, design and software development using latest technologies like Java, J2EE , Scala,Python,
Relevant Skills and Experience
Java,python,aws,crm,ml
Proposed Milestones
R$200 BRL - Payment after the completion of project
R$244 BRL - First payment after 60%of waok done
Hello,
I have read your job description very well.I can deliver the project on time.I can complete this job within the required time period.
Regards
Subha Sathi
Relevant Skills and Experience
I have 2 years experience with these type of work
Proposed Milestones
R$466 BRL - Full Task
Hi,
I am currently working on a project which is similar to your requirement. I have relevant experience in working with AWS, MySQL, nodejs.
I assure you that I will deliver the best solution.
Relevant Skills and Experience
I had implemented a mechanism to trigger lambda on arrival of a file(pre-defined naming standard) into S3.
I used MySQL as database for other projects.I have experience parsing Excel programtically.
Proposed Milestones
R$555 BRL - End-to-End implementation of use case
Additional Services Offered
R$100 BRL - Bug fixes and support for 1 month
I have few open questions. Kindly provide me an opportunity to discuss.