A freelancer getting a permanent residencepráce

Dobrý den, hledáme někoho, kdo by nám pomohl s integrací externího API do našeho e-shopu, který je založený na WordPressu. Součástí integrace je automatické vyřizování objednávek, nahrávání produktů a cen. Bližší informace po domluvě sdělíme. Děkujeme.

Znalost JavaSE/EE a relačních databází. Angular znát není třeba, stačí vůle se ho naučit. Min. 3 roky zkušenost s komerčním vývojem. Znalost automatických testů. Dovednost domluvit se s kolegy anglicky (min B1). Java, Spring, Maven, Hibernate, RabbitMQ, Angular 2, JSP + další webové technologie, Relační databáze + SQL, JavaScript, jQuery, REST, XML a XSLT, JUnit / TestNG, Mockito nebo PowerMock, GIT, základy linuxového skriptování (Bash), Google Analytics / Google Tag Manager, testování zabezpečení webu

Znalost JavaSE/EE a relačních databází. Angular znát není třeba, stačí vůle se ho naučit. Min. 3 roky zkušenost s komerčním vývojem. Znalost automatických testů. Dovednost domluvit se s kolegy anglicky (min B1). Java, Spring, Maven, Hibernate, RabbitMQ, Angular 2, JSP + další webové technologie, Relační databáze + SQL, JavaScript, jQuery, REST, XML a XSLT, JUnit / TestNG, Mockito nebo PowerMock, GIT, základy linuxového skriptování (Bash), Google Analytics / Google Tag Manager, testování zabezpečení webu

...prvo, moram ti priznat, kad god se tu ulogiram, vidim tebe online, i moram ti priznati, impresioniram sam. Rezime ti je odličan, stalno si tu, vjerujem, jako predan poslu, i stoga imam za tebe ponudu. Imamo jednu manju freelancer ekipu, sa svih krajeva svijeta, i surađujemo sa agencijama iz USA i EU, koje nam šalju projekte ili se natječemo za projekte njihovih klijenata. Pošto nam stalno šalju neke ponude, masu toga moramo odbiti, jer smo prebukirani, ili se uopće ne prijavljujemo, a projekti izgledaju jako privlačno. Uglavnom, da ne duljim puno, treba nam pojačanja u ekipi, a rado bi tebe vidio u toj ekipi, jer ovo što vidim iz rezimea, koliko si tu na stranici, nema druge nego da te vrbujem. Na tebi je na koliko ćeš procijeni...

...prvo, moram ti priznat, kad god se tu ulogiram, vidim tebe online, i moram ti priznati, impresioniram sam. Rezime ti je odličan, stalno si tu, vjerujem, jako predan poslu, i stoga imam za tebe ponudu. Imamo jednu manju freelancer ekipu, sa svih krajeva svijeta, i surađujemo sa agencijama iz USA i EU, koje nam šalju projekte ili se natječemo za projekte njihovih klijenata. Pošto nam stalno šalju neke ponude, masu toga moramo odbiti, jer smo prebukirani, ili se uopće ne prijavljujemo, a projekti izgledaju jako privlačno. Uglavnom, da ne duljim puno, treba nam pojačanja u ekipi, a rado bi tebe vidio u toj ekipi, jer ovo što vidim iz rezimea, koliko si tu na stranici, nema druge nego da te vrbujem. Na tebi je na koliko ćeš procijeni...

...Editace poptávek - ( zde by probíhalo i schválení ) - Přidávání poptávek 1.3 - Přehled objednávek a plateb ( za upgrady, zvýhodnění, topování, případně platby za služby ) a jejich stavy 1.4 - Zprávy, seznam zpráv a historie komunikace přes formulář zde si logiku představuji, že uživatel napíše prostřednictvím formuláře dotaz na podporu, ta se zobrazí v tomto modulu, po odpovědi se mu zpráva pošle do přijatých a zároveň odešle emailem notifikace o nové zprávě na portálu. V případě že uživatel odpoví, zpráva se zobraz&iacut...

If you are familiar with AWS programming, this should be a simple task for you. I have included an example C# solution using AWS Transcribe that I need to be working. Example Program: AWS Transcribe documentation: Requirements: • I will create a new AWS free account and will supply credentials. • In my AWS account, configure any IAM role/policy/user/credentials needed to run the example program. • Change the example program to accept credentials (accessKey/secretKey) as arguments passed to the executable. • Ensure that the corrected code successfully converts the speech in the audio file to text using the AWS Transcribe service. Deliverables: • All source code • Instructions

I'm in need of an expert who can secure both indoor and outdoor venues for a variety of events including weddings, corporate events, and concerts. The venues should accommodate up to 50 guests. Essential requirements for the job include: - Extensive knowledge of available venues suitable for a range of events - Excellent negotiation skills for getting the best booking rates - An understanding of the logistical requirements for each event type Candidates with experience in event planning, venue sourcing or a related field will be highly regarded. It's crucial that you are detail-oriented – I need someone who will consider all variables to select the perfect venue. You'll be paid a percentage of what the booking fee is. I'm...

Hi Zainab528, I noticed your profile and would like to ask about getting you to redesign / reproduce a couple of Leaflets for me. I have some existing ones for 2 of my products, and will shortly need a third one. The two I already have I need producing into a format that I can upload to my website. I can send you PDF copies of them for you to look at and give me a price? Thanks, Dan

I worked incredibly hard for over a year to bring you a top-notch learning program with Freelancer.com that was never revealed before… It's not just about teaching you everything I know and sharing my journey to the #1 amongst 70 million people; it's also about connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months t...

I am in need of an Adobe Pro expert who excels in creating and manipulating contracts. The ideal candidate will have the following skills and abilitie...specifically on Windows OS. - Ability to create E-signatures. - Capability to design document templates in line with my company's predefined style. - Know-how to devise fillable forms, as part of the contract. - Competence to add permanent fields and signatures in documents. The freelancer should have a good eye for detail ensuring that each contract adheres to the predefined company style and standards. The understanding and application of industry-specific formats will also be a key aspect of the task. High-level proficiency in Adobe Pro and contract design and modification is a must, as the proje...

We are looking for a talented Mexico freelancer who can provide high-quality translation services from English to Spanish. The ideal candidate should have a strong command of both languages and a deep understanding of cultural nuances. This project involves translating various documents, such as articles, blog posts, and marketing materials. Attention to detail and the ability to meet deadlines are crucial. The successful candidate will have proven experience in translation and a portfolio showcasing their skills. Skills: - Fluency in English and Spanish - Excellent writing and grammar skills in both languages - Attention to detail - Cultural understanding and sensitivity Size: Small Duration: Under 1 month Expertise: Intermediate

K zobrazení podrobností se zaregistrujte nebo přihlaste.

I'm looking for someone to help me create a list of 2000 business contacts from specific websites, particularly names, company names, position, location information, event information, number of events, current events, past events in 2024, and email addresses. I would like this list to be compiled through online research only. Key responsibilities: - Researching and compiling a list of business contacts - Ensuring all email addresses are verified and duplicates removed. Note: The focus should be on getting accurate, up-to-date information.

I am seeking a professional grant writer to help me secure available minority grants for my carpet cleaning business. This will mark my first foray into grant applications, hence I am looking for a specialist who can guide me through this process effectively. Specifically, I need assistance with: - Writing a persuasive grant proposal. While I am open to providing any needed information about my business, I rely on your expertise to translate it into compelling content that would maximize my chances of getting the grant. Ideal skills and experience: - Experience with grant applications, particularly minority grants for small businesses. - Outstanding written communication to eloquently express my business needs and potential. - Proven track record of successf...

I'm seeking a talented actor with expertise in drama acting. Your role will be to act as a police officer at my house. It will be a brief, engaging performance lasting no more than 15 minutes. The scene is set at an indoor residence. Here are a few key requirements: • Proven experience in drama acting • Able to convincingly portray a police officer • Comfortable performing in an indoor residential environment • Ability to deliver a compelling performance in less than 15 minutes Please provide a sample of a drama acting role you have performed in the past, particularly if it's similar to this project. Looking forward to collaborating with you on this project.

I'm in need of a talented freelancer to assist with content creation. This project is focused on boosting brand awareness and making our products and services more visible to potential customers. Key Responsibilities: - Conceptualize and create compelling content that resonates with our target audience. - Develop engaging written content or video content that clearly communicates our brand message and value proposition. - Ensure that all content aligns with our brand guidelines and voice. Ideal skills and experience: - Proven track record in content creation, preferably with a focus on brand awareness. - Strong writing and/or video production skills. - Ability to understand and effectively communicate brand values. - Experience in a similar project or ind...

I'm looking for an experienced WHMCS developer to help improve an already developed financial history graph. I had a developer from before that told me he could improve the module by take order dates and other dates already in the database to fill in missing data of the graph. Right now the graph just records order and financial information in the database and displays it on the graph. Where there is no data the graph just shows a straight line as shown in the demo screenshot. So I want the graph to show the data that its table is missing by getting this information from the WHMCS database. The end result would fill in the missing data of the straight line and also show the history on the graph from the start of the database, right now it only goes back 3 years be...

...experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, instead of ...

I'm seeking a freelancer who has experience with the platform. This is a 6 months project for customizing the template Previous Experience with this template is a STRICT requirement New Features to be added Design upgrade

I'm looking for someone to help me create a list of 2000 business contacts from specific websites, particularly names, company names, position, location information, event information, number of events, current events, past events in 2024, and email addresses. I would like this list to be compiled through online research only. Key responsibilities: - Researching and compiling a list of business contacts - Ensuring all email addresses are verified and duplicates removed. Note: The focus should be on getting accurate, up-to-date information.

I am seeking assistance with getting my paper published in a SCOPUS listed journal in diversifying areas of law . I have a preference for a particular type of journal, but I am open to suggestions. The desired timeline for publication is as soon as possible. Ideal Skills and Experience: - Knowledge and expertise in the diversifying areas of law - Experience with publishing papers in SCOPUS listed journals - Familiarity with different types of journals in the field of law - Ability to meet tight deadlines and work efficiently

I'm looking for a freelancer to help me extract financial data and regulatory filings from a tax website. This involves scrapping website using the provided credentials by the client, i am looking for getting the python code as i can run the code myself in the future or integrate it to another system. Key Requirements: - I need approximately 300 data points extracted. - The output for these data points should be organized into a PDF or Word. This project is about creating an automated system to generate instant reports about a company. Only difficulty is the website has drops downs to select the period involved and in those 300 data points actually many come from the same source. Ideal Skills and Experience: - Experience in web scraping (P...

Hi Murat K., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

...field oriented control system for a permanent magnet synchronous motor. My goal is to improve the speed response, specifically the acceleration time, deceleration time, and steady state error. The project involves the tuning of PI controllers within the system, meant to enhance its overall performance. For this task, a proficient knowledge of control systems, system modeling, and tuning methods is required. Previous experience with PI tuning is beneficial. Currently, MATLAB/Simulink is being used for modeling and system simulation, hence proficiency in it is crucial. Ideally, the candidate will have extensive experience using MATLAB for complex motor control simulations. However, I haven't defined the specific tuning methods to be used which leaves room for...

I am looking for an expert with solid experience in F...am looking for an expert with solid experience in Field Oriented Control (FOC) of Permanent Magnet Synchronous Motors (PMSM) who can help tune my PI controllers for more precise speed control. Here are the specifics: - I have an established model using MATLAB/Simulink, and the PI controllers are already implemented. - The key outcome I want is to enhance the accuracy of the speed response. The ideal candidate will have: - Extensive knowledge and experience with PMSM and FOC. - Proven background in tuning PI controllers. - Strong proficiency in MATLAB/Simulink. Your task will involve analyzing the existing model, suggesting enhancements for the PI controllers, and implementing these changes to achieve a more precis...

Hello I am looking for an experienced freelancer to help me create an account on , an online translation platform. The selected freelancer will not only be responsible for creating the account but also have the opportunity to use the account for their own translation needs. **Requirements**: * Hold a valid translation certificate or degree in one of the following languages: + English to French, Spanish, Italian, Japanese, or Chinese * Provide a detailed CV highlighting your translation skills and experience * Be able to pass 's verification process with your valid translation certificate or degree **Tasks**: * Create a account with the client's provided information * Configure the account for shared access * Provide login credentials f...

I'm facing an error while deploying my project during its application start-up. The project is currently being deployed to an unspecified environment. I require an experienced deployment specialist to troubleshoot and resolve the deployment issue. Key requirements: - Proficiency in deployment processes - Strong experience in resolving deploym...application start-up. The project is currently being deployed to an unspecified environment. I require an experienced deployment specialist to troubleshoot and resolve the deployment issue. Key requirements: - Proficiency in deployment processes - Strong experience in resolving deployment errors - Ability to work on unspecified deployment environments Your expertise in this area will be vital in getting my project up and runnin...

I'm changing the requirements if that will help. My Quasar Application now has a Node.js server running inside the app. If someone has worked with Anthropic can can get the POST requests to work thats all that I will need. I need a person that has worked with Anthropic AI When you bid on this project start your bid with "I CAN DO THIS" There is so much automated bids that it just wastes time. Also bid responsibly and don't ask " What's your budget" Bid what you think it's worth to you. I want a clean new Quasar Application that you load "@anthropic-ai/sdk": "^0.21.0", and makes a call using Setting up a demo Quasar app takes less than 5 min. my sample code: async sendMessageToClaudeCh...

I'm looking for a professional to perform a comprehensive SEO audit, with a focus on Google, for my website. The ideal candidate should have: - Strong expertise in SEO, particularly Google optimization - Experience in identifying and resolving technical SEO issues - Ability to work with minimal analytics and previous SEO reports Key objectives for this project: - Identify technical SEO issues: My website has been live for a while but is not getting any search traffic. I need a thorough review to pinpoint any underlying technical issues that may be hindering its search visibility. - Recommendations for improvement: Based on the findings, I would like actionable recommendations on how to improve the technical SEO of my website. If you have ...

...specifically interested in a 3D and animated style logo for this project. The logo will primarily be used on our website and Visiting Card and T-Shirt, so it should be versatile enough to look good in both digital and physical formats. You need to bring logo to life in 3D and in ANIMATION also....it should be moving. I have made a rough logo, please refer Attachment with this project, that's important INSTRUCTIONS-: I want this logo to be in Bluish and Orange colour theme Colour of "Resume" icon should remain the same. Icon should animate. Name should wave left to right ...or any other special effects also will do. Tagline to remain still Entire complete logo should appear in some sort of 3D block Background of 3D block of ur choice, as of now its dar...

We are seeking skilled freelance floral designers to join our team and assist with wedding productions. As a floral designer, your main responsibility will be to create stunning floral arrangements that enhance the overall wedding decor. You should have a strong understanding of different flower types, colors, and arrangements, as well as a keen eye for design. Attention to detail, the ability to work under tight deadlines as well as to follow instructions and work well with others on a team are essential. If you are a creative individual with a passion for floral design and have experience in the wedding industry, we would love to hear from you. Skills required: - Proficiency in floral design techniques - Knowledge of different flower types and t...

Looking for an experience smartcontract coder to submit Strict Listing to Jupiter Key Requirements: - Experience working with Jupiter Strict Token Listing - - Proven track record of listing tokens on the Solana network - Ability to work under tight deadlines - Strong communication skills and online availability, as time is of the essence.

* Must have atleast 1 year experience working with on-page/off-page optimization, link-building, directory submissions, blog/forum commenting, article submissions, back link strategy implementation and link wheeling. * Develop and execute SEO strategies to increase organic search rankings and traffic. * Perform keyword research and identify target keywords for optimiza...Analytics and Search Console. * Collaborate with cross-functional teams to implement SEO recommendations. * Be responsible for all regular (and ad hoc) reporting and analysis of digital activity providing crucial insights into further sales and marketing opportunities. Please share your relevant experience and strategies you plan to implement to achieve my goal of increasing website traffic Only Freelancer allowe...

I am in search of a talented 3D animator who can bring my manufacturing machine to life in a technical, yet simplified, animation. Your task will be to create a low-detail model, focusing on basic shapes and forms, rather than getting caught up in the nuts and bolts. Experience in a similar field will be seen favorably. Key responsibilities and required skills include: - Creating and animating a 3D model of a manufacturing machine - Maintaining technical authenticity in the animation - Accuracy in representing basic shapes and forms - Proficiency in 3D animation programs - Effective communication skills While a comprehensive understanding of manufacturing machines is not necessary, an illustrative comprehension of mechanical element...

I am blending Google Sheet data with Google Ads and Analytics data but getting an error message. Need someone to help via screenshare. Thanks!

I worked incredibly hard for over a year to bring you a top-notch learning program with Freelancer.com that was never revealed before… It's not just about teaching you everything I know and sharing my journey to the #1 amongst 70 million people; it's also about connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months t...

I'm looking for a seasoned medical illustrator, ideally with a strong background in cardiovascular disease pathology. Your task will be to create a feature illustration for a magazine "Nature" article on cardiovascular diseases. The style needs to be ccompatible with their style Responsibilities: - Scrutinizing the article content thoroughly - Designing an appealing, realistic illustration that depicts the topic accurately - Getting my approval of sketches before moving onto final work Skills and Experience: - In-depth understanding and ability to illustrate cardiovascular diseases - Excellent grasp of realistic visual art styles - Strong medical illustration track record - Proven experience working with scientific or medical content will ...

We are looking for a skilled 3D Animator who can create a 5-10 minutes demo video in Bengali. The video will be focused on explaining 'how 3D videos work best and help students memorize important concepts". This video will be used as an educational resource for students studying in Bengali. The animator should have experience in creating engaging and visually appealing 3D animations. The ideal candidate should be able to bring concepts to life through animation and capture the attention of the target audience. Add a few important and understandable topic from, Life Science, Physical Science, Geography, History, Maths, (Topic of Bengali and English if possible) Skills required: - Proficient in 3D animation software (e.g. Maya, Blender) - Strong understanding...

I am looking for an URGENT freelancer who can create a Thinkific course with a clean and minimalist design for my Head Spa business. The course should be geared towards working professionals and should incorporate video tutorials, written instructions, and interactive quizzes. |I also require my landing page on Thinkific to be worked on. It's half done but needs refining. You must be fast and efficient with examples of similar work you've competed. Please do not apply if you are juggling multiple projects. I need someone dedicated to getting this completed within a few days. The ideal candidate for this project should have: - Experience with Thinkific course creation - The ability to develop clear and concise video tutorials - Skills to...

I'm interested in getting some photos manipulated to present myself in Basic training at Ft Jackson. The modifications I need are: - Inserting myself into photos with the background of training grounds. - Making it appear as if I'm wearing a camouflage uniform. - Incorporating military equipment in the images as props. - Showcasing Ft Jackson badge clearly. -My last name Johnson on the Uniform Ultimately, these photos are aimed for personal use. As such, the manipulations need to be realistic and professionally done. Below are the skills and experiences I'm looking for in a freelancer: - Extensive skills in using Photoshop or similar photo manipulation software. - Previous work with military-themed imagery would be a plus. - Attention...

I'm interested in getting some photos manipulated to present myself in Basic training at Ft Jackson. The modifications I need are: - Inserting myself into photos with the background of training grounds. - Making it appear as if I'm wearing a camouflage uniform. - Incorporating military equipment in the images as props. - Showcasing Ft Jackson badge clearly. -My last name Johnson on the Uniform Ultimately, these photos are aimed for personal use. As such, the manipulations need to be realistic and professionally done. Below are the skills and experiences I'm looking for in a freelancer: - Extensive skills in using Photoshop or similar photo manipulation software. - Previous work with military-themed imagery would be a plus. - Attention...

I need a Wordpress expert to create a membership site dedicated to authors posting their books for Amazon book reviews. Key Requirements: - Membership Site: A user-friendly site that allows members to upload their books and assign a token value based on their wallet and how much they are willing to spend per review they are getting on Amazon. Token Value: Users' token value increases as they review books and submit screenshots with all the details. - Reward Points: Reward points are added for successfully completing tasks. - Levels: Every user has levels that get increased based on his or her activity. Authors -You can add books based on the form that is required to upload a book. - Check how many books they have uploaded. Readers - Can bro...

...(maybe in top left corner or similar) NOT TOO LARGE but just somewhere on the flyer nicely please, along with the URL and say: For SEO Services and Google Page 1 Results, visit - PLUS it needs my phone number: (206) 395-6759. I like layers on layers, icons and bright beautiful color, not pastels. I'm in need of a professional flyer that will promote my SEO service specifically targeted towards small and medium businesses. Key Points: - I'm looking for a creative, bright and colorful design which can competently attract potential clients. - The flyer should be able to clearly communicate my SEO services and differentiate my offerings from competitors. - Backlinks, Content Writing, Social Media Management, Traffic Analysis, Keyword Relevancy Image Tags, ...

...tunnel. I would appreciate a talented freelancer to assist in troubleshooting and resolving the problem. Key Details: - The error message I'm encountering is 'invalid HASH_V1 payload length, decryption failed?' - The error seems to be related to not being able to decrypt payloads - Additionally, I'm getting 'No matching CHILD_SA config found for IP/IP. received DELETE for IKE_SA' on the responder side Your Role: - The primary task is to address and rectify the issues causing the tunnel failure - As of now, the problem seems to be primarily on the responder side Ideal Skills for the Job: - Proficient in StrongSwan VPN - Strong troubleshooting skills - Experienced in resolving encryption-related issues - Familiar with debugging and re...

I'm in need of a marketing assistant to support my company's marketing activities. I do NOT want a company, I am after an individual - a single person who is looking to work for a good employer and be part of our team. We will provide a brief on what needs to be done and you will implement these strategies. Proven experience in website optimising an advantage. Basic understanding of online ads is a plus. We will start with one project and then it would become permanent for the right person. Tell me about your experience, where you are located, who you have done work with etc. At the END of your reply, put the word: Understood.

I'm seeking a skilled freelancer to assist me with leveraging the free tier of Google Cloud ($300 credit) . I am a Google Cloud Platform account holder who wants to install and configure S/4HANA 2024. The primary goal for this project is development and testing. I'm looking for a freelancer who has a good understanding of both SAP S/4HANA 2020 and Google Cloud Platform. Your role will be to install and configure the software, ensuring it runs smoothly on the cloud platform. Key requirements include: - Expertise in SAP S/4HANA 2024 - Proficiency in Google Cloud Platform - Experience with installation and configuration processes - Ability to troubleshoot and offer post-installation support if necessary. Your assistance in this proje...

We need t-shirts… taking a tour, and considering getting local custom shirts made in each area

...Management Objective: Develop a Minimum Viable Product (MVP) of an Android application for inventory management and tracking using GPS and Bluetooth beacons. Technology: Flutter Key Requirements The Application -------------------------- - The app should primarily be developed in Flutter. However, since a Foreground service is required to run indefinitely in the background, it is acceptable to create this service in Kotlin or Java. Communication between Flutter and the native code should be done via Platform Channels (MethodChannel and EventChannel). User Interface ----------------------- The app should have three main screens: - Splash Screen: Displays the app logo. - Login Screen: User authentication with username and password. When the login button is pressed, ...

...changing (both up and down ) for 20 times per year. for example prices changing at august 20, 2022 happen for product ids: When 14 for -20%; 25 for +34%; 52 for -40%; 28 for +10%; 55 for +15%; 13 for -70%; 91 for +30% randomly for each product dates and prices changing (both up and down ) for 20 times per year **T1 transactions Product id Date time Store id **T2 prices New price permanent Data Store is **T3 promotions Product id Store id Promotion price Date promotion start How many days promotion lasts **T4 store lookup table Store id Store state Store city **T5 competitors lookup table Competitor ID Competitor state Competitor city **T6 holidays lookup table USA holiday name USA state holyday Holiday date 1 Holiday date 2 Holiday date 3 ***** ...