Ssi Projects
Looking for freelance Ssi jobs and project work? PeoplePerHour has you covered.
Post an offer to educate them
Past "Ssi" Projects
opportunity
SQL, ssis , powerbi trainer
SQL, SSIS, PowerBI Trainer I am looking for a trainer who can provide training on SQL, ssis, powerbi to an audience with an intermediate level of understanding. The training sessions should be 2 hours long. Requirements: - Expertise in SQL, powerbi and a strong understanding of its various aspects - Proven experience in training individuals on SQL - Ability to explain complex SQL concepts in a clear and concise manner - Familiarity with intermediate-level SQL topics such as joins, subqueries, and optimization techniques - Strong communication and presentation skills Ideal Skills and Experience: - Extensive knowledge and experience in SQL - Previous experience in training individuals on SQL, ssis - Proficiency in using training tools and resources to enhance the learning experience - Familiarity with SSIS and PowerBI is a plus, although not necessary for this particular training If you are passionate about teaching SQL and have the necessary skills and experience, please apply with your relevant qualifications and a brief overview of your training approach.
Need SQL DEVELOPER PER MONTH
Experience of 4+ years 2. Microsoft SQL Server 2008 and above server side development 3. Knowledge of tools like Tableau and/or any other data visual tools 4. T-SQL (Transact SQL) Stored Procedures, Functions and Triggers 5. Need to have good understanding of performance tuning 6. Understanding .NET code/.net development experience is a plus Responsibilities: 1. Excellent design skills for coming up with the schema that can be usable across multiple customers 2. Design and develop T-SQL procedures, query performance tunings and SSIS packages. 3. Develop underlying data models and databases. 4. Develop, manage and maintain data dictionary and or metadata. 5. Ensure compliance of standards and conventions in developing programs. 6. Design, develop and implement complete life cycle of data warehouses. 7. Translate business requirements into software applications and models. 8. Analyse and resolve complex issues without over sight from other people. 9. Perform and execute data extraction, transformation and loading using ETL tools. 10. Maintain and enhance the existing data warehouse, exports, and reports 11. Perform quality checks on reports and exports to ensure exceptional quality 12. Create and maintain documentation for all projects
opportunity
SSIS, Creation of a new ETL package
We currently have a ETL package that runs a number of tasks , those tasks reviews the data for accuracy and appends the data within that file to that files relevant sql table. we require the creation of a new ETL package and Server Agent job (or update of the Server Agent job to reflect a second step) The ETL steps should be identical to those taken by the current job (albeit, for only 4 files)
Detailed drawing to obtain a building warrant in Scotland
Building regulations drawing required for a garage conversion (into a kitchen). Drawings must be detailed enough to obtain building warrant. Previous drawings obtained are deemed not adequate (attached are 3 which is the limit), please only bid if you can prepare the correct drawings to the correct specification for a warrant in scotland. Requirements are at https://www.legislation.gov.uk/ssi/2004/428/schedule/2/made
Detailed drawing to obtain a building warrant in Scotland
Detailed drawings required for a building warrant in Scotland for a garage conversion. Requirements are at https://www.legislation.gov.uk/ssi/2004/428/schedule/2/made Some great work has been done by an architect (see attached files) however unfortunate circumstances has meant the drawings could not be completed. I now require someone to prepare the relevant drawings for submission.
SSIS package development
Hello: I need some assistance with SSIS package to develop for one of our client - it is a simple ETL job loading from Azure DB to another Azure DB with a temporary table and column mapping. We would need the person to work on site in London (we are next to East Croydon station. Please contact us. Thank you. Eric
Domain transfer
Hi there! I wanted to ask if you could help us on transferring a domain from one hosting to another. We have a landing page built on WordPress and hosted on Aruba under www.ssi-universal.com and we are building a website on the Wix platform. We would like to move the domain from Aruba to Wix and change the URL of the landing page. Basically, we would like to use http://www.ssi-universal.com as the main domain on the Wix site and change the url of the landing on Wordpress to something like http://ssi-universal.com/landing-england Would something like this be possible? Thank you! Alex
API Dev help
I need a developer familiar with c# and Visual Studio to reverse engineer an app provided to us from our vendor. I have the solution but am unfamiliar with the syntax. The app pulls desired info into an app form. I need it to provide me the info so I can load it into a MSSQL database. This can be done in the app or by creating a csv file I can then import using SSIS. I tried to work with the vendor, utilizing python but the vendor was unable to get me past the authentication. This should not be too difficult or take too long for someone who understands C# or can use Visual Studio. Unfortunately, I'm not that someone and need help. Thanks, Brian
Professional Copywriting
Buongiorno, Le scrivo a nome di SSi Universal Education, un agenzia che organizza soggiorni studio all'estero per adulti, ragazzi, bambini e professionisti. Stiamo costruendo diverse landing page, e necessitiamo di un copywriter per rielaborare i testi che andranno a popolarle ed ottimizzarli in modo da catturare l'attenzione dei diversi target verso cui sono mirate le landing page. Per favore mi faccia sapere se il progetto e' di interesse e i dettagli che necessita per fornirci un preventivo. Grazie mille, Alessandro
opportunity
SSIS SQL Integration Service/SQL script- move data from flat table into relational db
Hi, I have a database with a flat table. I need either a SSIS job or a T-SQL script that will simply take the flat data and move it into a relational database that I have created. The data will need splitting into 4 tables. I have already created the database and tables and will give you a script or backup so you can create it locally. Then I will give you the flat table pre-populated with data. At the end I want a script that can move the flat data into the relational db and then I can query the relational db and I should get back the same results as the original flat table presented. This can be done via an SSIS package or a T-SQL script. Those are the deliverables. Any questions please ask. You need to have some demonstrable exprience with SQL Server and should be available this week. Regards
About Us Page for my startup property trading company landing page website
Good morning, It a pleasure to be back in contact, we previously discussed you possibly writing 600 words website content for my site like stated I only see £40 for an about ya page for 400 words. Please let me know where I can purchase? So we can get the job started permitting you have time in your schedule. I am a startup property trading company (SSI) selling off market commercial property, residential property and land with or without planning permission primarily in London and surrounding areas. I am based in London and need 600 word seo website content for my brand new website. Target Audience: SSI works with buyers and sellers looking to buy or sell there property off market. I target motivated sellers that need to sell their commercial/residential/land etc quickly and/or discreetly for a variety of reasons; Sellers Type: •equity release •probate •divorce •downsizing •relocation •repossession Buyer Type: ( investors looking for property acquisition help which I charge a 2% finders fee) •high networth investors •property developers •real estate investors •landlords •council/housing association Writing tone: Informative, persuasive and friendly- I would like the content to be informative, well researched, engaging, the text needs to demonstrate an understanding of the customers pains and relate by cultivating well written text for the customers to easily understand the service and want to fill in the form on the website. SSI unique selling point: SSI sell exclusive off market property to our prequalified list of investors from not only the UK but various parts of the world. Most residential and land deals are sold within 30days. What SSI stands for: SSI helps landlords/investors sell there problem property by connecting buyers and sellers to create a win win situation for all party’s involved, which aids a quicker completion time frame in comparison to the traditional estate agent. This is achieved by creating a quick and hassle free sales process for both buyers and sellers. Honesty, integrity and our consistency in meeting our clients demands is what distinguishes us from the others. Keywords: How many keywords will you be using in the content? (Keywords need to be narrow as possible) 600 words broken down; •250 words- explaining service •175 words- explaining the sales •175 words- explaining the buyers Example websites & content I like that are in my indirect and direct market; 1- http://www.offmarketpropertiesuk.com/ (similar service to mine) 2-https://www.loveyourpostcode.com/selling/ 3- http://www.agarchitecture.net/?gclid=CjwKCAjwyMfZBRAXEiwA-R3gM4D5iiwdmoKph8pbJNz1B0Y32r1tUhuXFe_ZVkK9Y4-3J_i9gTCk_xoCxaUQAvD_BwE If you have any questions please do not hesitate to contact me for clarification, I look forward to working with you in this project. Warm regards, Sapphire
Basic database with remote access option
Hi, I have a personal project for research and am looking for help. I would like to have a DB created using csv files from this data source: https://botometer.iuni.iu.edu/bot-repository/datasets.html its cresi2017 file. My difficulty is uploading large files (tried R) to sql server db, and when I am using SSIS I have formatting errors. So basically, I dont need relationship or constraints - it's just getting those files in raw format (special and weird characters etc) to SQL server db. Please specify how fast you can deliver when makin offers! Thanks!
DATA ENTRY - WORDS/EDITING
Hello! There are two parts to this job... 1) See excel sheet with title: WiP VQA SSI benefits Questions List NEW Format. I need you to copy and paste all the info in this document into the second document called NEUTRALISE ALL BENEFITS. However, you must put the data in the format that is in NEUTRALISE ALL BENEFITS, not in the WiP document. I have done the first few so you can see what I mean. In other words, you are leaving out the words: word cloud in column C and also leaving out the words in BOLD in column D, but all other words in column D you are copying and pasting, as well as the words in columns B and C. If this is not clear please let me know. 2) Once all the words are in NEUTRALISE ALL BENEFITS, I ned you to read each sentence in column C and check to see where there are the words boyfriend or girlfriend (or something similar) and change that for the word 'partner' - I have done a couple of examples for you in blue in rows 7 and 253.
DATA ENTRY
Hello! There are two parts to this job... 1) See excel sheet with title: WiP VQA SSI benefits Questions List NEW Format. I need you to copy and paste all the info in this document into the second document called NEUTRALISE ALL BENEFITS. However, you must put the data in the format that is in NEUTRALISE ALL BENEFITS, not in the WiP document. I have done the first few so you can see what I mean. In other words, you are leaving out the words: word cloud in column C and also leaving out the words in BOLD in column D, but all other words in column D you are copying and pasting, as well as the words in columns B and C. If this is not clear please let me know. 2) Once all the words are in NEUTRALISE ALL BENEFITS, I ned you to read each sentence in column C and check to see where there are the words boyfriend or girlfriend (or something similar) and change that for the word 'partner' - I have done a couple of examples for you in blue in rows 7 and 253. As you change these words into 'partner' please highlight that cell in blue so I can see what you've done more easily. Thanks.
Convert csv file to excel (.xlsx) format with preserving special characters
General information for the business: Expertise Kind of development: Customization of existing program Description of requirements/functionality: I have created a c# script that is a part of a SSIS package. The script reads the .csv file and converts it into .xlsx file. The script works fine except two more things that I'm looking to achieve 1. Preserve the special characters from the input file to destination excel file. Currently it's converting the special characters to "?" character when writing to the excel file 2. Add the functionality that converts the excel file to table format so when the user open the excel file; it should open as table format Please find attached sample .csv file along with the script. Looking for quick working solution OS requirements: Windows Extra notes: