最近在建一个外卖送餐的网站，需要接入Xunhupay的（微信和支付宝）支付模块。 网站使用的是foodomaa的整站代码： 需要的技能有： Software Version: PHP 7.x Software Framework: Laravel File Types Included: JavaScript JSJavaScript JSON HTML CSS PHP SQL Layered PNG 如果您感兴趣，可以写信给我，价格好商量。 另外网站还有其它的一些改版工作要做，我们可以具体讨论一下能不能一并做。 等您回复哦……
程序是： 首先 第一步： 随机抽取5个phome_ecms_news里面的id和classid 第二步： 读取phome_ecms_news的id和classid，作为函数使用 第3步： 插入phome_enewspl_1新的内容到数据库 例子：$sql = "insert into phome_enewspl_1(plid, pubid, username, sayip, saytime,id,checked,classid,zcnum, fdnum, userid,isgood,saytext,eipport) values (NULL, '1000310000019701', '', '', unix_timestamp(), '$id', '0', '$classid', '50', '1', '0', '0', '评论内容', '48010')"; 第四步： 更新phome_ecms_news的字段plnum+1并且对应第一步读取的id值 例子：UPDATE phome_ecms_news SET plnum =plnum+1 WHERE id = 20488;
To develop OTD KPI reports on JobBOSS: Calculate OTD archive rate by daily, weekly, monthly, there are two conditions need to be fulfilled, one is quantity delivery fulfillment, the delivered qty should equal to requested qty, another condition is delivered date, the delivered date should equal or be earlier than promised day. Scope: all closed SO which closed on curren...qty, another condition is delivered date, the delivered date should equal or be earlier than promised day. Scope: all closed SO which closed on current day, current week and current month. Set the OTD target If SO was delivered earlier on last month , then the OTD need to be included in last Month’s OTD KPI. by SO + Project number Use Chart display the OTD by day,week and month. Data source: ERP SQL DB Tool: ...
该项目需要开发人员，主要技术为： ASP.net/CS/MVC/WCF框架, DIV+CSS，JS(easyui/jquery/native JS/Ajax/Json). 熟悉Oracle数据库, 精通SQL及PL/SQL. 该项目周期大概两个月，之后会有不定期项目需要开发人员 人员需驻场，地点深圳或者天津。
1、精通VB.net，使用以上语言独立开发或深度参与过项目； 2、掌握SQL数据库的使用，能实现复杂查询语句，具备编写存储过程、触发器和函数的编写能力； 3、熟悉ERP、BOM或者MRP。 联系人：陈经理 联系方式：[REMOVED BY FREELANCER.COM ADMIN]
需要开发一套库存及订单管理系统，要求基于数据库（mysql或sql server均可）开发。 库存管理部分，要求对商品的入库出库有良好的输入及确认界面； 订单管理系统，因为是从客户的服务器上下载txt文件（内容为订单），需要将订单纳入数据库，然后根据库存情况判断能否发货，并在最终确定发货日期及发货数量后生成txt文件并上传回客户的服务器。下载及上传txt文件，有客户提供的软件，只要以命令行方式调用即可。 需要按照客户指定格式打印交货单。
android app & SQL/PHP web DB freelance job 詳情請email 查詢
我们目前有一个基于Windos Access 的一个内部应用软件， 我们希望能将其用WINDEV 来重新开发 以便于我们之后的应用。指定使用WINDEV 开发软件。在我们公司坐班工作，直到项目完成。
looking for male vo talent for a 2-minute tutorial video. Must speak Chinese. must sound young and energetic please use the lines below to send sample. 通过您本地银行支行的柜台用现金存款也是一种快速存款到您博狗账户的方式，因为您的转账存款直接到我们的银行账户，一旦存款成功，仅需扫描柜台存款单在现金存款页面上传即可。 您可以隔您最近的自动柜员机使用我们的银行信息存款，然后扫描存款交易单在自动柜员机存款页面中上传更快确认您的存款信息。
SQL注入/代码审计/数据库权限/渗透测试技术 接渗透单子高手，联系电子邮箱：aqcp#（#改成@）语言要求：中文 熟练掌握各种内网渗透测试工具与相关知识，精通常见安全攻防技术：sql注入、xss、文件上传、文件包含、命令执行等漏洞 熟悉linux、unix、Windows、oracle、J2EE等各种环境下WEB的安全配置与安全检查及WEB漏洞防范； 熟悉各种脚本语言(asp,php,jsp,java,net、perl、python等)具备独立挖掘web安全漏洞与入侵手段 具备一定的网络安全知识，对网络安全结构、系统漏洞、入侵检测、病毒防护等有深入理论基础和实践经验； 熟悉渗透测试黑客攻防的步骤、方法、流程、熟练掌握各种渗透测试攻防工具有实际渗透经验者优先； 求大虾接单，脱裤，要求，电话，手机，姓名，邮箱，其他的一概不要。每笔单1000美金起步，根据站的难度而定价格,具体可以详谈，寻找长期合作. 态度认真、中介勿扰,请技术实力说话。
安全测试、漏洞发掘、漏洞渗透测试、安全审核、安全风险、服务器安全漏洞渗透测试评估与分析及加固； 联系QQ：840555737 2、对产品代码进行审视，找出安全漏洞并提出修改建议； 3、研究各种安全技术，编写和维护用于安全测试的攻击工具、防御工具和分析工具； 4、负责公司Web产品涉及到的安全性研究； 5、负责响应公司的安全事件； 6、为公司员工提供信息安全教育及培训。 岗位要求： 1、熟悉渗透测试的各类技术及方法，熟练掌握各种渗透测试工具；熟练操作各类操作系统、应用平台； 2、精通或熟练掌握php/perl/python/javascript/shell等多种脚本语言； 3、熟悉asp,php、jsp等主流的Web安全技术，包括SQL注入、XSS、CSRF等常见的安全漏洞利用； 4、熟悉国内外主流安全产品、工具，如：AppScan扫描器、wvs等； 5、对Web安全测试有自己的理解； 6、熟悉常见攻击和防御办法，熟悉web安全和渗透技术,能自行进行web渗透测试，恶意代码监测和分析； 7、熟悉ddos攻击类型和原理有一定的ddos攻防经验，能有效防御黑客挂马和恶意流量攻击，会熟练搭建负载均衡系统。
网站用途：园区展示官网 开发语言：php 参考网站： 具体要求： 需要设计的页面数量和网站功能参考附件。 代码要求： 无SQL INJECTION, XSS等漏洞；前端通过HTML和CSS有效验证，class和id等命名符合语义化规范；代码逻辑清晰有注释，方便后期修改升级。 网站维护： 服务商需要提供后期维护支持 其他要求： 服务商最好是成都公司，要有对公账号，可开发票。 请报价格、工期、设计师的portfolio以及在什么开源程序的基础上开发。 熟悉prestashop的优先。
网站建设要求是 网站程序语言是PHP 数据库为SQL Server 不需要做到也下几点： 1、网站界面大气大方 2、网站语言必须为 中午--英文 两种语言 根据访问者的IP来主动换语言 3、一般的交友网站的功能都要做到 4、网站主要功能有一下几点 1、在线聊天 2、在线动态 3、介绍好友 4、相册密码功能 5、在线音乐 6、签到 7、等级功能 8、举报-敏感词 5、这里有几个网站可以拿来参考 这是我的QQ号 929471701
We've developed an MS Access database front end with a SQL Server back end. Now we need to install both of these with government agencies in South America whose IT people only speak Spanish. We provide written installation instructions in English. Our clients can only meet the contractor online for server installations during business hours in American time zones. This is periodic work, installing databases whenever clients request them. At present we have six clients in the queue. The applicant must guide and troubleshoot each installation online in fluent Spanish. The successful applicant will have a record of relevant database work. We're a university-based not-for-profit.
The video needs to show users how to use the site at Video should be similar in style to the videos on or Voiceover can be AI but needs to be realistic with US, UK or Australian accent. I can write the script for the voice over and show the different aspects of the site.
I'm seeking a proficient cybersecurity expert to deliver a tailored training session on network security, incident response, and cloud security to a group of beginners. Key Requirements: - In-depth knowledge of network security, incident response, and cloud security - Proven experience in conducting virtual security training sessions - Ability to simplify complex security concepts for a beginner audience - Familiarity with live virtual class delivery - Strong communication and presentation skills The ideal candidate should be able to engage and educate participants effectively in a live virtual setting. The candidate should be capable of offering a professional, interactive training experience that equips participants with foundational cybersecurity knowledge.
I'm looking for a Python tutor who can help me with the syntax and basic programming concepts, and guide me through the fundamentals of object-oriented programming. Key aspects of the project include: - Tutorials on Python syntax and basic programming concepts - Assistance with understanding and implementing object-oriented programming principles I'd prefer to have our sessions via video call, using platforms like Zoom or Skype. As a beginner, I would appreciate someone who can explain things clearly and help me build a strong foundation in Python. Ideal skills and experience: - Proficiency in Python - Experience in teaching or tutoring Python to beginners - Strong communication skills, especially in explaining complex concepts in an easy-to-understand manner - ...
MUST READ FIRST =============== MUST HAVE - Blazor experience of at least 3 years - Latest version of .NET & SQL Server - At least 1 hour of availability between 6:00PM and 11:00PM EST - Your price is the one that you REALLY want to have with 10% +- NOTE - APIs will be provided (you will not develop APIs) - No development will be done on My Computer. - DO NOT APPLY if your fees can exceed 10% or your bid PROJECT I have C# Blazor Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Make code debuggable. 2- Error message appear with no details, need to make the error message has Show More to display the details of the error. 3- Load Codes from APIs ins...
I am in need of an expert cloud architect skilled in AWS . Your primary responsibilities will include: Teaching me Landing Zones Mentoring Cloud architect Regular consultation in shaping up the cloud architecture as we evolve a...business needs Solution architect Please note: - I am seeking an individual, not a company. Only industry professionals need apply. - You should be able to provide a practical demonstration of your skills in these areas. - Your proficiency with cloud Architect and Cloud operations will be a critical factor in the selection process. NOTE: STRICTLY NO BEGINNERS OR RANDOM WEB DEVELOPERS OR EASY MONEY ATTITUDE PERSONALITIES DO NOT APPLY FOR THIS If you meet these criteria, please apply with details of your relevant experience and a demonstratio...
...can't make it so I want it to work on Zoom because that will be how they will be attending. Their is a tutorial below that describes exactly what I want to do. As explained in the tutorial I like the idea of being able to press 1 to be Biden, 2 Trump, 3 Arnold Schwarzenegger, and so on. I would like to be able to talk and change my facial expressions etc and I want the video experience to be smooth and life-like. I would need it delivered within a week. I don't mind paying a fair wage for this but I want us to be reasonable. I am doing this as a joke and then maybe my kids will get some fun with it. I am flexible but was hoping to get this completed for $250.00 or so. I am much more comfortable with Windows but if it simply won't work...
I'm in need of an AI expert who can assist me in realizing the video output generated by our AI bot. r find other ways to make f...designed to create video content across different genres including: - Comedy skits - Educational videos - How-to tutorials Your role will involve: - Understanding our existing AI bot and its video creation process. - Implementing a solution that can effectively translate the AI's video ideas into a finalized product suitable for adult viewers. - Ensuring the videos are engaging, well-edited, and align with the intended comedic, educational, or tutorial content. Ideal Skills and Experience: - Proficiency in AI and video production. - Previous experience in creating/completing AI-generated content. - Ability to cater the co...
I have a non-commercial C++ application that I've been developing. Here are the details: Project Overview: I require a sequence diagram to visually represent the interactions between objects and functions within my C++ codebase. Requirements: Sequence Diagram ...visually represent the interactions between objects and functions within my C++ codebase. Requirements: Sequence Diagram Generation: I need a sequence diagram that accurately captures the interactions within the code. Preferred Tool or Method: I'd like to use for this project, but I'm open to other tools or methods if you have a better suggestion. Please specify your preferred approach. Reference Material: I've attached a screenshot and a tutorial presentation that exemplify the style and le...
...graphics and Power BI. Let's collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic design - Detail-oriented and data-driven - Can effectively translate data into...
Looking for an experienced data scientist with a strong background in trading or stock market data analysis. Your tasks will revolve around data analysis and visualisation, along with other key data science responsibilities. Contract duration: 3 months to 15 months Position open: 2 Data scientists Key Responsibilities: - Perform data analysis and visualisation on trading or stock market data - Use your data science skills to provide valuable insights - Ensure the accuracy and efficiency of your predictive modeling Ideal Skills and Experience: - Proven experience in trading or stock market data analysis - Proficiency in Python, R, and SQL - Strong analytical and problem-solving skills - Prior experience with predictive modeling and algorithm development - Ability to handle...
Tengo un Insert que proviene de una tabla que esta consumiendo mucho CPU al momento de ejecutarse, es un SP simple pero requiere de índices o validar que los que ya están creados no estén causando conflicto y aumenten el consumo del CPU
I'm in need of a professional content creator who can produce video tutorials for my yoga business. Key Project Deliverables: - Captivating video tutorials that cover yoga poses for beginners Target Audience: - Adults incorporating yoga into their routines. Aim to demonstrate techniques in an approachable manner suitable for beginners and adults of varying skill levels. Ideal Candidate: - Experience in creating fitness or yoga-related content is a plus. - Strong understanding and practice of yoga, particularly focused on beginners. - Good on-camera presence, able to clearly narrate and demonstrate movements. - A background in fitness training or physical education is preferred but not strictly required. Mainly, a clear understanding of ho...
Google app script expert needed for stock price and data for world wide countries. Basically we have done for few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities and criteria : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. 4. Agile, fast delivery, and re...
I have built an Android app in Android Studio (Iguana) but I cannot figure out how to upload it to the Google Play store. Hence, I am seeking a qualified freelancer to provide a 1-hour virtual tutorial explaining the app submission process. I want to be on VTC and share my screen while someone guides me through the process. This tutorial should primarily focus on: - The process of submitting an app to the store. - Understanding the app store's guidelines. - Tips on app signing and security. Upon successful completion of the class, an opportunity to build additional apps may arise. Remember, the ideal freelancer should have verifiable experience in Android app development, app store submissions and previous training/tutoring experience may be an advantage. One addition...
I'm in need of a freelancer with strong Python skills. I require a time series forecast for my Twitter dataset. The forecast should be for 1, 3, and 7 days ahead. The key deliverable is 3 dynamic dashboards that display this forecast in real-time. Key Points to Note: - **Programming Language**: Python - **Time Series Forecasting**: The freelancer is expected to have a solid understanding of time series forecasting methods. The deliverables should include 2 Neural Network and 2 autoregressive models (ARIMA, SARIMA etc…). The validation should demonstrate each model performance. - **Dynamic Dashboard**: I'm looking for a dashboard that's dynamic and interactive. It should display the forecast for the Twitter data using a visually appealing i...
When I open the PDF, it doesn't show me the data on the second page. By changing the code (I provide pictures), it shows the data, but the graphics are bad. The project is small and simple. An opportunity for beginners. I pay max $5 and give a good review. Ideal opportunity for new freelancers.
Answer the attached question correctly, and briefly explain. using principles of subnetting. I'm looking for an expert in networking who can provide correct answer and clear and concise explanation of the attached question. Answer the attached questions, the provide table of the subnets Accepted file format Excel or Word
Se debe mantener un sistema hecho en .Net el cual esta vinculado a una base de datos SQL Server de Microsoft. El postulante debe manejar a la perfeccion el idioma Español.
As a Windows user, I'm looking for someone who can set up an OpenSSH server on my personal computer. This setup should allow connections to IP socks without requiring any authentication. Key Tasks: - Installation and configuration of OpenSSH on my Windows machine. - Ensuring the server is properly set up to connect to IP socks that don't need authentication. Skills and Experience: - Proficient in Windows systems and administration. - Experienced with setting up OpenSSH servers. - Good understanding of networking and IP socks. - Ability to ensure the server is easy to use for beginners. Please ensure that you're able to balance the need for security with the priority of making this setup beginner-friendly.
I'm searching for an expert in Visual Studio 2022, MS SQL, and VB.net, for the main objective of maintaining and updating an existing software application. Key tasks: - Primarily, the project will involve optimizing the application's performance. Skills and experience: - Experience with Visual Studio 2022, MS SQL, and VB.net is a must. - Proven expertise in software optimization. - Knowledge of system maintenance and updating.
I'm looking for an Azure expert who can provide me with comprehensive documentation on how to connect my dbForge client to an Azure MySQL App Services Database. Key Requirements: - **Azure Proficiency**: The ideal candidate should be highly experienced with Azure, especially in working with Azure MySQL App Services Database. - **dbForge Expertise**: Familiarity with dbForge would be an added advantage. Your main goal should be to create a step-by-step, comprehensive guide that will help me effectively use dbForge with Azure, particularly for database management purposes. I'm not looking for a one-time setup, but rather a detailed documentation that will serve as a reference for future tasks.
I'm seeking a professional editor or proofreader for my personal non-fiction book. The primary focus of this book is IT learning for beginners. It's a word document with 6234 words on 29 pages. Key Responsibilities: - Ensure the manuscript's clarity is maintained for a layman. - Fix any grammar issues that may arise. - Ensure the consistency in the writing style. Essential Skills and Experience: - Proven experience in editing and proofreading non-fiction books. - Strong understanding of IT principles, particularly those suitable for beginners. - Excellent grammar and language skills. - A keen eye for detail and consistency. Please share a brief overview of your experience in this area when bidding.
I have a 500MB XML file that I need loaded into SQL across approximately 20 tables. I'm in need of a Python script to handle the transformation. The script will need to handle normalization of the data. Key requirements: - Develop a Python script to read the XML file and transform the data into a normalized structure across 20 tables. - You will need to create the SQL tables as part of the normalization process. - Experience with large data transformations and SQL is vital.
I'm seeking a skilled .Net developer to assist in developing a comprehensive retail system that has features such as user authentication and authorization, inventory and product management. Requirements: - Proficiency in C#, .Net, Entity Framework and SQL Server - Ability to develop a retail project from scratch - Strong understanding of user authentication and authorization - Experience in inventory management and product cataloging It's crucial that the chosen freelancer has prior experience in building online retail systems and a strong understanding of the retail business model. The ideal candidate should be able to deliver a secure, efficient and scalable retail project. Any experience with Angular/react/Node would be plus
I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.
I am looking for a talented and experienced web development team to create a unique, fully functional social media platform. Key Features: - User Profiles: A robust user profile system that allows users to create and customize their profiles. - Messaging System: A secure and interactive messaging feature that enables users to communicate seamlessly. Ideal Skills and Experience: - Proven experience in developing and deploying web applications, preferably in the social media domain. - Proficiency in programming languages and frameworks suitable for developing a dynamic web application. - Strong understanding and implementation of user experience and interface design. - Ability to create scalable, secure, and maintainable code. - Excellent teamwork and communication skills, as...
...distinct functionalities. Ideal skills should include: • Extensive experience with AI/ML models. • Known for providing solutions with Natural Language Processing (NLP) capabilities, recommendation systems, data analysis, and data visualization. • Proficiency with QR, WhatsApp, LLM, DB, managing user profiles, cataloguing orders, generating recommendations, and facilitating payment systems. 1. Implement a QR code as the entry point for users to access WhatsApp chat. 2. Utilize WhatsApp APIs to initiate chat sessions. 3. Employ Language Model (LM) capable of Hindi, English, and Hinglish for conversational interactions. 4. Integrate LM with backend logic for CRUD operations on a DB (SQL/NoSQL). 5. Store restaurant data including name, m...
My very private client has two youtube channels one education youtube channel another gaming youtube channel I want to prepare both youtube channels for for the person who is very expert in this subject and can complete the work in a short period of time, there is a bonus and opportunity to work on the next project from my client.,You are welcome even if you are a fresher we will check your eligibility and appoint you to the project through a conversation with you l YouTube Channel url: Educational : Gaming:
I have comfy UI workflow that I need to find a way to host and access through an API this is a pretty good tutorial to a point but they are selling their inference service which i don't want to use basically the ui will generate this long config file which you need to post to and endpoint so I guess what we need to do is create a container adnt hen figure out go the data is returned and create some kind of logic for handling the images that are returned Please write 'comfyUI' on the first line of your proposal so I can check they also have a WebSockets example but I would rather not use that for this application
As a graphic designer, vide...editor, I require your expertise in producing a variety of videos for my social media platforms. The project entails: - Crafting engaging promotional videos, tutorial videos, and animated videos. - Ensuring the videos are between 1-3 minutes in length. - Tailoring the content for Instagram and YouTube specifically. The ideal candidate for this project should have a creative flair for video production, a solid understanding of social media dynamics, and proficiency in graphic design and video editing tools. It's crucial that you have prior experience in creating content for Instagram and YouTube and can adapt your style to suit the platform's requirements. A portfolio showcasing your past work and examples o...
Description: I am looking for an expert in SQL and R programming for a detailed data analysis project. This project involves extracting, analyzing, and reporting on data from a sophisticated relational database setup. The ideal candidate should have a solid background in data science, with specific skills in SQL and R. Responsibilities: Efficiently query and manage data using SQL from a SQLite3 database. Apply R programming techniques for advanced data cleaning, analysis, and visualization tasks. Ensure data integrity and optimize data processing workflows. Analyze results to derive actionable insights and compile detailed reports. Document all processes and code in a clear and comprehensive manner. Requirements: Profound knowledge of SQL...
I'm in need of an expert who can create compelling, engaging videos using Sora OpenAI. The videos will primarily be explainer, product demonstration, and tutorial videos. They should be less than 1 minute in length and require an English voice-over. Key Requirements: - Proficient in using Sora OpenAI to create engaging and high-quality videos - Experience in creating explainer, product demonstration, and tutorial videos - Skilled in creating videos with less than 1-minute duration - Ability to provide professional English voice-over - Strong understanding of video editing and production techniques The ideal freelancer for this project will have prior experience with Sora OpenAI and a portfolio showcasing similar video creation work. They should also be able to d...
Our company develops both desktop and web applications tailored for analysing insurance premiums. These have been developed in Delphi over the past 25 years. We are seeking to establish a long term relationship with an experienced Delphi programmer with exposure to Microsoft SQL databases. ASP.net application experience is also desirable. Our software packages require continued upgrading and enhancement and given the specialist nature of our software we are seeking to establish a long term relationship. The primary requirements include understanding our business process and system design, determining and articulating technical solutions, and implementing the design into build and install stages. Australian based is preferred, our principal office is based in Sydney NSW. ...
I'm looking for an experienced .NET developer to assist with a project. This project requires someone who has a strong background in .NET technology, particularly in C# programming, ASP.NET development, and SQL database management. Ideal candidates should have experience in developing web applications, creating software solutions, and improving existing systems. The key functionalities to be implemented by the .NET developer in this project include user authentication, data encryption, and payment integration. If you're a .NET developer with a solid understanding of the above technologies and functionalities, please reach out to discuss the project further.
I'm in need of an hacker to perform a thorough black-box penetration test...Responsibilities Include: - Testing the security from an outsider's perspective. - Identifying and using hacking techniques including SQL injections, cross-site scripting attacks, and brute force attacks to hack website as outsider so that we can plug the vulnerability. Ideal candidates should have: - Proven experience in website vulnerability testing. - A strong understanding of WordPress. - Exceptional problem-solving skills. - In-depth knowledge of SQL injections, cross-site scripting attacks, and brute force attacks. My objective is to ensure my website's robust security, and your expertise can help me to achieve this. Your keen eye and tech skills are crucial for this pr...
