Sql statements help jobs
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I want someone who can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase order, I should be able...
Link to my youtube channel: I need someone to help me with making engaging shorts from my old videos plus my new videos. If I like your work, I will hire you on a weekly basis, so that I can post at least one short video every week. The ideal candidate will: 1) Excellent editing skills to create engaging short content. 2) Provide me with new ideas on short content and help me grow my channel. 3) Commit to deliver everything on time. 4) Use my old videos to make shorts. 5) Use copyright free, royalty free trendy music for my shorts. Since this is a trial I am offering AU$50 for 3 short videos.
I want someone who can help me To extract leads
Im on a 64bit machine.. i want to bring back the resulks from HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsCurrentVersionUninstall AND list the DISPLAYNAMES in a text file... BUT, this i can do, as it shows all results fine only in 64 part of the registry. I also need it to show results for 32 bit also. ive tried subsituing keys KEY_WOW64_32KEY to access the 32-bit view of the registr to access KEY_WOW64_64KEY but it doesnt show 32 results. So i need it to show both 32BIT AND 64BIT DISPLAYNAMES under HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsCurrentVersionUninstall in a text file
I'm in need of a knowledgeable expert to help manage my bookkeeping using FreshBooks. Your tasks will primarily involve: - Maintaining financial records and handling all business transactions - Ensuring accuracy and maintaining systematic order Ideal candidates should be well-versed with FreshBooks and have profound experience in accurate bookkeeping. A strong comprehension of financial statements and the ability to organize large amounts of data are also critical. Previous accounting experience would be a bonus. Prompt, reliable, and detail-oriented professionals are preferred.
I'm seeking an experienced bookkeeper who can assist with financial statements preparation, accounts payable/receivable management, and payroll processing for my business. We are in a stable and growing financial state, so maintaining and improving upon this is crucial. Ideal Skills and Experience: - Proficiency in QuickBooks - Background in managing financial statements, accounts payable/receivable, and payroll - Experience in supporting stable and growing businesses Your role will entail managing financial records and providing a clear overview of financial status. Your ability to ensure accuracy and timeliness will be highly valued.
Hi, I am looking for expert to connect SQL database togoogle looker studio so we can analise data and creat reports, it is a long term coopartion. Please provide implementation cost and hourly charge. Best.
...programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation fro...
We are seeking an experienced freelance developer to design and develop an online service booking platform targeted at legal professionals. The project includes creating both a web application and a mobile application for service providers. Responsibilities:Design and develop an intuitive user int...booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and back-end technologies (e.g., React, Node.js).Experience with SQL or NoSQL understanding of UX/UI design to meet deadlines.
...standards of code quality and push for continuous improvement. **What You Need:** - BS/MS in Computer Science, Engineering, or related field. - 2-3 years of full-stack development experience, with significant focus on mobile apps. - Strong proficiency in Flutter or similar, front-end technologies (HTML5, CSS3, JavaScript), and backend development (Node.js, Django). - Experience with databases (SQL & NoSQL), cloud services (AWS, Google Cloud, Azure), and versioning tools like Git. **Why Join Us?** - Flexible working hours and a chance to work in a dynamic, fast-paced environment. - Continuous learning and professional development opportunities. ? **Apply Now!** Send your resume, a cover letter, and work samples/portfolio demonstrating your expertise relevant to the role. ...
I'm looking for a financial expert skilled in Tally ERP9 to help with specific bookkeeping tasks. This includes bank reconciliation for 1-5 accounts on a monthly basis, as well as the generation of financial statements. Key Responsibilities: - Reconciliation of 1-5 accounts monthly using Tally ERP9 - Generation of monthly financial statements The ideal candidate should: - Be proficient in Tally ERP9 - Have prior experience in bank reconciliation - Possess a strong understanding of financial reporting I need someone who is detail-oriented, has excellent organizational skills, and can provide accurate financial records in a timely manner. Prior experience with similar tasks is a definite plus.
...user login/signup, in-app messaging, push notifications, photo and file upload. Advanced features should also include GEO Fencing, QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, QRCODE/Barcode scanning, Face Recognition - API integration with Google services This project will require rigorous testing to...
I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The p...Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demonstrate your expertise in these areas. I'm looking for a reliable, communicative individual who can deliver a high-quality...
...diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQL - Experience with ER diagram creation - A...
Need support for react web applications i.e., small and medium enhancements to connect daily for 1 hour. Strong react basics including huge knowledge in CSS with Javascript and node js required.
I am looking for a Shopify and Ebay integration expert to help me with the following tasks: - Setting up product listings on Ebay platforms - Clear the errors in integration. Requirements: - Experience in integrating Shopify and Ebay platforms - Proficiency in setting up product listings on eBay Additional Information: - I already have existing product listings on Shopify If you have the necessary skills and experience in Shopify and Ebay integration, please reach out to me to discuss the project in more detail.
I'm looking for a seasoned AWS Data Engineer with over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide examples of your past ...
...aid in accounting and finance. The primary tasks include: - Bookkeeping: This involves accurate record-keeping of all monetary transactions. Your keen attention to detail and remarkable time-management skills would be beneficial. - Financial Reporting: A systematic record of all financial activities is needed for strategic planning. Expertise in preparing income statements, balance sheet reports, and cash flow statements is necessary. - Tax Preparation: Your tax preparation skills should ensure compliance with laws and regulations to avoid penalties. The individual best suited for this role should have a background in accounting, finance, or a related field. Experience working with sole proprietorships is a plus. Excellent analytical skills, familiarity wit...
...preparing and filing various regulatory documents, including SEC filings, annual reports, and proxy statements. - Corporate administration: This includes ensuring the company's records are accurate, up-to-date, and in compliance with regulations. - Financing administration: You should have a good understanding of financial regulations and be able to assist in financing administration. Experience and Skills: - Prior experience as a Corporate Secretary, preferably in a public company. - Strong knowledge of corporate governance and finance. - Excellent organizational and communication skills. - Proficiency in legal and regulatory compliance. - Familiarity with SEC filings, annual reports, and proxy statements. - Ability to work effectively with board members and other ...
We need the following features: 1. Login/ registration 2. Stripe integration 3. Place and order 4. After placing order, user can upload files to start project 5. Admin receives files from order. 6. Email notification about order progress to user and admin 7. Admin uploads final report pdf to order and marks complete 8. User can download report from order page. End of flow. More details: What specific features would you like to include in the SaaS dashboard? User management, Payment processing, Upload and download files How do you envision the user interface of the SaaS dashboard? Modern and intuitive design What level of user access control do you need? Basic (e.g., admin and user roles only)
I need an expert to comprehensively review the quarterly financials of 18 different organizations. You will be looking at the organization's income statements, balance sheets, and cash flow statements from the past year. Your expertise in financial analysis would be a big asset in this project. Key Tasks: - In-depth scrutiny of quarterly income statements - Detailed examination of balance sheets - Profound analysis of cash flow statements Please note, a comparative analysis among the organizations is not required for this project. Your focus should solely be on individual organization's financial health. Ideal Skills: - Experience in financial analysis and accounting - Detail-oriented with proven analytical skills - Ability to interpret complex...
A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...
I'm looking for an expert in Microsoft Power Apps to develop...the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-quality, functional solution w...
Help me with existing project to optimize the performance of core functionality and add some basic new functionalities. If you're genuine bidder then please write "php&python" in starting of your bid. This is kind of urgent and need to do it in around 1-2 weeks.
I have ongoing work related to our previous project 'Please help name our brand-new vehicle tools brand - 09/05/2024 23:04 EDT'
...assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, in...
I'm in need of a professional who can help with my private limited company's annual compliance tasks. Key Tasks: - Filing Annual Financial Statements - Conducting an Audit - Updating Statutory Registers Key Requirements: A. Auditor Appointment & Filing of Form ADT - 01 (Auditor Appointment). B. Preparation & Filing of Form INC - 20A (Declaration of Commencement of Business). C. Assistance & Documents Preparation for Company's Current Bank Account. D. Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, and Director's Report. E. Preparation & Filing of Extract of Annual Returns & Financial Statements (Unlimited Transactions). F. Preparation & Filing of Annual Returns Form AOC - 04 (Financials Re...
I have an iOS app ready to go and an active Apple Developer account. I've managed to set up the app's metadata and assets for the App Store. However, I need someone to assist me with the final step of actually publishing the app. Ideal skills and experience: - Experience with publishing iOS apps to the App Store - Knowledge of Xcode and the iOS development process - Proficiency in managing and navigating the Apple Developer account interface - Ability to troubleshoot and resolve any publishing issues that may arise - Excellent communication skills to guide me through the process and answer any questions I may have This project is quite straightforward as most of the work has already been done. I just need someone to take the reins and ensure the app gets published successfully.
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data nee...
...setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on
...gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept and start work IMMEDIATELY 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 5) Be available to work on weekends. Our projects use: GITLAB so you need to be proficient and be able to use our existing pipelines and also create your own. Our stack: , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product s...
I'm looking for a financial expert skilled in Tally ERP9 to help with specific bookkeeping tasks. This includes bank reconciliation for 1-5 accounts on a monthly basis, as well as the generation of financial statements. Key Responsibilities: - Reconciliation of 1-5 accounts monthly using Tally ERP9 - Generation of monthly financial statements The ideal candidate should: - Be proficient in Tally ERP9 - Have prior experience in bank reconciliation - Possess a strong understanding of financial reporting I need someone who is detail-oriented, has excellent organizational skills, and can provide accurate financial records in a timely manner. Prior experience with similar tasks is a definite plus.
I'm in need of a skilled Flutter developer who can attend to a critical issue in my app. The primary task required is resolving the crashing issue that occurs during app launch. This bug has been hindering user experience and I need it fixed as soon as possible. - Fix critical bug causing app crashes - Issue occurs specifically during app launch Given the urgency of this issue, I'm looking for a developer who can start working on this immediately. Your swift resolution and expertise are highly appreciated.
Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking
I need a professional to prepare my income statement and balance sheet according to IFRS standards. My records are ready, and I only require a summary-level of detail. Ideal skills and experience include: - Proficiency in IFRS (International Financial Reporting Standards) - Proven track record in preparing financial statements, especially income statements and balance sheets - Detail-oriented and able to work with a high level of accuracy - Good communication skills to clarify any details for a summary-level reporting. This is a one-time project, but if successful, there may be more in the future.
I require an experienced accountant to prepare a set of financial documents for my company. Last 2 year Audited Financial statements for the previous 2 fiscal year-ends: Income Statement, Balance Sheet, Cash Flow Statement Interim Financial Statements (Balance Sheet, P&L, Cash Flow Statement) Financial statements for the most recent interim period: Income Statement, Balance Sheet, Cash Flow Statement Merchant Processing Statement
I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.
...The extracted data needs to be exported into a Google spreadsheet. Additionally, I need an interface for users to easily upload these documents. Key Requirements: - Extract data from various financial documents: primarily focusing on Expense reports, W-2 forms, credit card statements, 1099s, and annuities. - Extract specific data from credit card statements such as Transaction amounts, Merchant names, Transaction dates, and also the ability to convert currency and combine rows. - Extract specific data from bank statements like Account balances, Transaction descriptions, and Check numbers. Ideal Skills and Experience: - Proficiency in Azure document intelligence and training models for document data extraction. - Strong experience in working with a variety of tax...
I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the...
2 winners will get 5 euros and a 5-star review. We need your help to report a Facebook user who is damaging our business reputation. Here's how you can enter the lucky draw for a chance to win 5 Euros: 1. Report the user on Facebook using the appropriate reporting tool. 2. Take a screenshot of the report confirmation. 3. Submit the screenshot as your entry. The user to report: []() Rules: - Only one entry per freelancer. - Duplicate
...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mo...
...incorporating all projects and back-office expenses. Features: • Consolidated P/L Dashboard: Aggregates data from all projects and expenses to display a real-time profit and loss statement. • Expense Tracking: Management of back-office expenses including rent, insurance, advertising, and labor costs. • Financial Reports: Generation of detailed reports like balance sheets, income statements, and cash flow statements. • Budget Management: Tools to set budgets, compare actual spending, and forecast future expenses. 3. Employee/Subcontractor Tracker Manages details and costs associated with employees and subcontractors, integrating expense data back into project costs. Features: • W2/1099 Management: Streamline the management of employee and subcontr...
Hi KESHAV INFOTECH, I need your help. In 2017 we did a wordpress site for a client of mine, abgastronomia. they had a problem with their hosting company, and lost the site!! by any chance, do you guys still have a copy of it? thanks
I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...
The title says it all. I want the book I'm publishing weekly on Wattpad to get the attention that it deserves but I'm not the best at putting my story forward. I want to see how far it can go with a little push. I do not want any 'fake' views, I want real engagement. Your job here would be to create engagement and bring readers (using tiktok videos or other social media) towards a book which is fantasy/coming of age. After having received some not so serious offers, I will only away the project to someone who is responsive and actually ready to do the task demanded. If the task is done well on the first week, then I will re-employ and more money can be earned for this job.
Data Specialist: The Data Specialist is responsible for pr...information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ com...
...should also be adept at debugging and ensuring the system seamlessly integrates with our existing customer service processes. The above was generated from Freelancer. Below is more information in my words: I have been trying to design prompts to make my business more efficient. I have come up with a 10-step prompt process, but it doesn’t give me the result that I want, so here I am seeking your help. Firstly, and this will kill this idea straight away, can we create a prompt that will correctly extract information from scanned documents? Okay, if we get past the first question, let’s delve a little deeper into what I am after. We are an outsourced paraplanning business in the field of Financial Planning in Australia. The two major parts of this business that I...
