Sql bookkeeping schemadela

- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark

Potrebujemo programerja za občasne dodelave v okolju Microsoft dynamics CRM, office 365 z bazo Microsoft SQL. Plačamo po urnih postavkah.

Izdelava aplikacija (za začetek working verzija - brez avtomatskih in EndToEnd testov) za prikaz: -Drevesnih struktur iz sql tabel -Logiranje -Shranjevanje aktivnosti na drevesnih strukturah -Poročila -Komunikacija med uporabniki Več v priloženem PDFju. Gre za osebni projekt - ne predstavljam podjetja.

...com/file/LJsytcax2WmStFrLOWBgM6/FitApp?type=design&node-id=3-65&mode=design How it works: - The entire user journey is gamification. - The user chooses a project that has x days (screen 1). Then you must mark the completed days (screen 2) in the app to earn coins. - The coins are on the top bar (Fixed) and starts with 0 coins. - The number of user coins and complete days must be saved in a local sql-lite database. Summary: - Create app with Expo 50 and TypeScript; - The data must be saved in a local database. This project is offline, but there must be online synchronization support with the offline-first approach. Save user coins, projects and days complete; - Number of days on screen 2 must be dynamic, according to what is selected by the user; - Create a service wh...

Seeking a developer with experience in C# and SQL for a predictive artificial intelligence project. Your role will involve developing a model to predict user behavior on a vending machine, utilizing data stored in SQL Server. Proficiency in artificial intelligence is required. Please don't send a bid to later try to increase it. Will be declined.

I am seeking an expert in Python to design a basic face recognition attendance system. This project integrates a MySQL database, driven by a Python-based face recognition component. Ideal skills for the project include: - P...recognition attendance system. This project integrates a MySQL database, driven by a Python-based face recognition component. Ideal skills for the project include: - Proficiency in Python - Experience with OpenCV, TensorFlow, Dlib, or comparable libraries - Proficiency with MySQL databases Primary tasks will be: - Developing the face recognition component - Creating and integrating a MySQL database schema - Making informed suggestions regarding model training Your expertise and creative solutions will play a huge role in this project. I look forward to y...

Stepping Back Through Data I have a table of orders, lets say. I'm trying to find all the "Completed" orders, and then step back through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', 'Cancelled') INSERT...

I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and the ability to trace SQL commands accurate...

...balancing both functionality and aesthetics The final product should be a clean, sleek, and easy-to-navigate website, reflecting the minimalistic style while providing exceptional user experience. My expectation is for a thorough, detailed-oriented professional who can capture my vision and translate it into a fully functional portfolio site. Things to be done Load an API data into on premise SQL server database Client will do some data calcution The new data will be available in the database and needs to be show in website with some base UI. Project involves show some other API data on the website as well Need not have a lot of experience in UI design but need experience showing data into a page. Website would look like this --- Odds data should

I am in need of a remote bookkeeper who can manage my financial transactions using the ERPNext software. Weekly only 2-4 hours of work max. I just need my weekly books updated, reports provided and bills collected if any Key Responsibili...and bills collected if any Key Responsibilities: - Reconciling accounts and ensuring accuracy of records. - Updating financial transactions on a weekly basis or as needed. - Regular reporting on financial updates and status. Ideal Candidate: - A good understanding and proficiency in using ERPNext software. - Rigorous attention to details and high level of accuracy. - Experienced in remote bookkeeping. - Can commit to a weekly service. If you meet these requirements and can ensure a consistent, weekly commitment, I look forward to receiving...

I'm looking for a skilled Webflow developer to make strategic improvements to my website. The project involves a mix of SEO tweaks and backend work to enhance user experience. Key Deliverables: SEO work will include (PDF can be provided): changing hreflang, changing url page names, adding meta descriptions, changing headings, replacing text, creating breadcrumbs, Schema Mark Up, adding image alt text, reviewing and removing excess code, update sitemap. Adding additoinal pages: Updating the main menu to add additional pages Creating additional pages Uploading text and images, which will be provided Ensure consistent layout across all pages Ideal Skills: - Proven experience with Webflow - Strong understanding of SEO best practices - Ability to implement and optimize meta tags...

...proficient in Websocket and SQL, who can help me with an automation project. Key requirements: - Profound knowledge in Python, including advanced topics and best practices. - Strong understanding of Websocket and SQL. - Experience in automation tasks would be highly beneficial. - Ability to adapt to different mentoring methods, such as video calls, live chat, or in-person sessions. Your tasks: - Mentor me through the automation project, providing guidance and support. - Help me understand and implement Python, Websocket, and SQL concepts effectively. - Adapt to my preferred session mode, whether it be video calls, live chat. Ideal skills and experience: - Proven expertise in Python, particularly in automation applications. - Experience working with Websocket and...

Looking for experienced computer programmers skilled in Python for a web development project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in buil...project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in building and maintaining web applications - Familiarity with front-end and back-end development - Ability to implement responsive design and ensure cross-browser compatibility - Good understanding of database management systems and SQL - Knowledge of version control systems and agile development methodologies Timeline: The project is expected to be completed within ...

I'm in need of an experienced developer who's well-versed in ASP.NET a...well-versed in ASP.NET and VB.NET. The project involves the event pages i need where user can login and acess the event throught calender with specific functionality.. i will share feature to slected one ... Ideal Skills and Experience: - Proficiency in ASP.NET & VB.NET is a must, with a proven track record of projects involving user authentication and database integration. - Strong understanding of SQL Server databases and how to effectively integrate them into a .NET environment. - Experience in implementing user authentication systems that cater to both roles and individual accounts. This project requires a developer who can deliver secure and efficient user authentication and database inte...

I require a skilled freelancer with experience in Amazon Web Services (AWS). We have a an ERP Developed on Laravel which is currently on a On-Premise Windows Server. We would like to move the application to AWS using a windows OS and SQL Server Database. Please guide as to which option would be better. The selected freelancer would have to set up a Windows operating system. Skills and Experience Required: - Proficiency in AWS, - Demonstrated experience deploying Please ensure to include examples of your previous AWS work in your bid. Your ability to efficiently handle tasks in the AWS environment is paramount for this project.

...and leveraging social media platforms to reach new clients. We're looking to target US CPA Firms and Bookkeeping companies looking to increase profitability by using manpower available in India. - Deep understanding of the bookkeeping industry and its clientele - Proven experience in marketing and lead generation - Ability to develop strategic partnerships and networking opportunities - Knowledge of digital marketing, including SEO and social media advertising - Excellent communication and project management skills The ideal freelancer will present a clear, actionable plan that resonates with the target market of small businesses, startups, and individuals in need of bookkeeping services. Previous success stories or case studies will be highly valued...

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.

Looking for a personal assistant who is ideally based in Indonesia to support a busy executive/business owner to manager various admin related tasks. These include: - Online research for home renovations / home moving - Bookkeeping and data entry of receipts and audit of existing receipts and invoices - Budget management - Online research for furniture and home decorative items (Gumtree / Facebook Market Place and Google) Immediate start and must be familiar with Google Workspace (G sheets, G docs, Gmail and etc.

I'm in need of a comprehensive AI bookkeeping script that can handle various crucial functions for my clients. We are a bookkeeping firm and handle 50+ clients. I'm looking for something somilar to botkeeper or integra. Key Requirements: - Seamless integration with QuickBooks and banking platforms for real-time data syncing. - Utilize machine learning to categorize bank transactions accurately, providing reliable financial insights. - Ability to reconcile bank transactions, ensuring the accuracy of financial records. - The system should send detailed financial reports via email, keeping stakeholders informed. - Additionally, the script should be able to handle amortization schedules and other related uploads. - A feature for journal entries based on additional upl...

I urgently need an experienced accountant to handle bookkeeping and financial statements preparation tasks. Key Responsibilities: - Bookkeeping: Accurate and timely recording of all financial transactions. - Financial Statements Preparation: Compiling financial data to generate accurate statements. Software Requirements: - Proficiency in Ubs: Familiarity with Ubs is a must as that's my current accounting software. Timeframe: - ASAP: I'm looking for a quick turnaround on this project, so prompt availability and ability to work efficiently is a must. Ideal Candidate: I'm looking for a detail-oriented, experienced accountant with relevant experience in bookkeeping and financial statements preparation. Prior experience with Ubs software is a huge plus. ...

I urgently need an experienced accountant to handle bookkeeping and financial statements preparation tasks. Key Responsibilities: - Bookkeeping: Accurate and timely recording of all financial transactions. - Financial Statements Preparation: Compiling financial data to generate accurate statements. Software Requirements: - Proficiency in Ubs: Familiarity with Ubs is a must as that's my current accounting software. Timeframe: - ASAP: I'm looking for a quick turnaround on this project, so prompt availability and ability to work efficiently is a must. Ideal Candidate: I'm looking for a detail-oriented, experienced accountant with relevant experience in bookkeeping and financial statements preparation. Prior experience with Ubs software is a huge plus. ...

I am in need of a skilled bookkeeping specialist proficient in Tally data entry and Excel data entry and formatting. Key Tasks: - Entering less than 100 entries per week into Tally. - Formatting and managing Excel data. The work will be ongoing, with updates and reports required weekly. Ideal Candidate: - Must possess extensive experience with Tally and Excel. - Proficiency in bookkeeping and data entry. - Ability to handle tasks efficiently and with a high degree of accuracy. - Understanding of financial reports and data reconciliation. The ideal freelancer will be able to deliver clean, well-organized data, and provide timely reports. If you have the skills and experience required, please get in touch.

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 instead of...

I am looking for an experienced accountant who is familiar with Canadian Auditing Standards (CAS) to handle my bookkeeping in Quickbooks online on an annual basis. Your tasks will include: - Managing sales and purchases transactions - Handling payroll transactions A successful freelancer would: - Be proficient with QuickBooks Online - Have a solid understanding of CAS - Have experience in handling sales, purchase, and payroll transactions.

I'm in need of a professional who is skilled in both 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-dri...

...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 a variety of data sizes and formats, as the size of the data may vary If you have previous experience in the trading industry and can confidently handle data analysis and visualisation, this opportunity is perfect for you. Your work will play a vita...

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 need an experienced professional to create an XML file for me. The file will be prim...an experienced professional to create an XML file for me. The file will be primarily text-based, with no need for images or tables. Key Responsibilities: - Create a custom schema for the XML file - Ensure that the text content is structured appropriately within the XML file - Deliver the file in a timely manner Ideal Skills and Experience: - Proficiency in XML creation - Experience in creating custom schemas - Attention to detail - Ability to work independently - Good communication skills, as you may need to clarify certain aspects of the project. Please note, I will rely on your expertise to create a suitable schema for the XML file. The end goal is to have a well-structured and fun...

I'm in need of an experienced financial analyst with expertise in the retail sector. Your role will be predominantly focused on analyzing the following financial metrics: - Profit margin - Liquidity ratios - Debt ratios The ideal candidate has an in-depth understanding of bookkeeping and can provide insights into ways of improving these financial metrics in a retail context. Also, a thorough understanding of tax preparation is appreciated as it can inform the analysis. You should also have experience in presenting complex financial data in an easy-to-understand format.

...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 responsive 5. Integrity, Honesty, Independently initiative, responsible, straight forward, loyal, modest, discipline, emphatically fair, hard wor...

...Amazon Marketplace operations and in-depth knowledge of Payability Inc., to help with the reconciliation of books and preparation of financials. Key Responsibilities: - Reconcile transactions: The primary goal of this project is the reconciliation of transactions. Your role will involve ensuring that all financial records, particularly those from Amazon Marketplace, are accurately reconciled. - Bookkeeping: You would be responsible for ensuring that all financial transactions are accurately recorded. - Financial statement preparation: You will need to prepare financial statements, ensuring that they are accurate, and in line with generally accepted accounting principles. Ideal Skills: - Proficient in Payability Inc.: It is essential that you have a thorough understanding of Pay...

...this project should have proven experience in time series forecasting, Python programming, and developing interactive dashboards. A solid grasp of data visualization principles would be a plus. The output should be in a form of a python file with 4 models above and related dynamic visualizations. The text preprocessing is required and can be done in any necessary technologies (HADOOP/SPARK,NOSQL/SQL databases) - screenshots of the bash code are required....

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.

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 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 require the expertise of a part-time remote accountant who can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely and accurate manner. - Financial analysis: Monitoring, identifying and interpreting financial trends. The ideal candidate should have a good command of QuickBooks and Excel spreadsheets. Familiarity with these tools is crucial for performing tasks efficiently and accurately.

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.

...completion) Whereby; candidates can create a profile upload their CV, images or link to images and videos recruiters can search CVs with a Boolean type search functionality & save searches. Candidates and recruiters can message each other. Admin can manage the back end. Suggested technical skill set but not a complete one… • Cloud-based server solution • Azure or Single server solution • MS SQL Database (NoSQL document database might be more appropriate?) • OAuth • Payment gateway • .net We suggest design led development process where we sign off the look and feel of the web pages… the back end is for the supplier to advise the best scalable solution for the application. Please send your credentials/ skill sets and cost struct...

...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, menu, pricing, and location details. 6. Capture user profile data such as name, preferences, allergies, and delivery addresses. 7. Manage user records and orders in the backend. 8. Prompt new users to provide necessary details. 9. Facilitate dish selection based on user preferences. 10. Display sorted dish options in sets of four ...

As I'm looking for a skilled ERP and CRM d...- Financial management - Customer relationship management - Indian accounting and taxation Your primary responsibilities will include: - Designing, developing and maintaining the ERP and CRM system - Ensuring the system is fully compliant with GST regulations and other Indian accounting standards - Implement features like: - Lead management - Contact management - Sales forecasting - Bookkeeping - Bank reconciliation - Payroll The successful freelancer should have a robust understanding of ERP and CRM systems, particularly in the context of the Indian market. Experience with manufacturing processes would be highly beneficial. A proactive, self-motivated professional who can deliver accurate, reliable and high-quality cod...

...looking for a skilled WordPress developer to enhance our WooCommerce product pages with schema rating code. We want to optimize our product pages for search engines and provide users with valuable information directly in search results. Requirements: Experience with WordPress and WooCommerce development. Proficiency in schema markup implementation. Ability to ensure compatibility with WooCommerce and display product ratings in search engine results. Clean and efficient coding practices to maintain website functionality. Payment: We will make payment upon successful completion and verification of the project deliverables. Deliverables: Implementation of schema rating code on all product pages. Schema markup compatible with WooCommerce. Product ratings di...

HI, We are looking for a skilled WordPress developer to enhance our WooCommerce product pages with schema rating code. Our website specializes in Skin Care. We want to optimize our product pages for search engines and provide users with valuable information directly in search results. Requirements: Experience with WordPress and WooCommerce development. Proficiency in schema markup implementation. Ability to ensure compatibility with WooCommerce and display product ratings in search engine results. Clean and efficient coding practices to maintain website functionality. Deliverables: Implementation of schema rating code on all product pages. Schema markup compatible with WooCommerce. Product ratings displayed in search engine results. Payment: We will make p...

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 with experience in ...

Looking for a Admin Assistant with experience in HR and Finance to support diary management of the team and executives, managing staff administration, basic bookkeeping and other ad-hoc team support / admin work. This is a full time role - 40 hours per week, you are ideally based in Indonesia as that is where most of our team is based. Must have fluent English and ideally a good understanding of Australian culture is a plus. Budget is $400 AUD per month

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. If you...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

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.

...in need of an hacker to perform a thorough black-box penetration testing on my WordPress website. Key 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 ...

Seeking a reliable part-time QuickBooks Online expert to perform recurrent tasks on a weekly basis. Primary responsibilities include...recurrent tasks on a weekly basis. Primary responsibilities include: - Reconciling accounts - Running financial reports - Performing data entry and categorization Ideal candidates should have proficient knowledge and hands-on experience with QuickBooks Online. Engagement, reliability, and detail-orientation are essential attributes for success in this role. Prior experience in accounting and bookkeeping will be advantageous. Goals of this project include maintaining precise financial records, improving our financial transparency, and making insightful business decisions based on accurate reports. Your diligence and expertise are key to achie...