offline
Last seen: Jul 28, 2014 5:17 PM EDT
Hire Me!
Rate: $30.00 USD/hour
Follow Invite to Project
 
Browse Similar Freelancers:

IT Technical Specialist

IT technical specialist (Databases ,Business Intelligence,IT development projects)

Username: abdellatif81

  • Has made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has verified their secure phone number.
  • Verified
  • Payment is verified.

Location: Casablanca, Morocco

Member since: August 2013

Reputation:

4.9/5

(18 reviews)

5.3
[see more]

4 users have recommended this freelancer.

My skills:

My projects:

  • $516.70 USD
    4.6
    Profile image for Seller imcbeatch

    imcbeatch

    7 days ago

    Great working with Abdellatif, I will work with him again in the future.<br/>

    Project Description:Help me build a Data Warehouse, create ETL using SSIS and create fact tables and dim tables. Finish the project by creating SSRS reports. There is not a large amount of data, and there will be fewer than 20 tables at the onset...
    [more]
  • $125.00 USD
    5.0
    Profile image for Seller ByChoice8

    ByChoice8

    22 days ago

    Excellent Job!! I will work with this freelancer again.<br/>

    Project Description:Automation - SSRS Report to Excel We have SQL Server 2008 r2, and office 2010. I have created stored procedures that write to SQL tables. Skills needed: SSRS, Excel, .Net, SSRS scheduling of reports...
    [more]
  • $130.00 USD
    5.0
    Profile image for Seller MichaelaHerm

    MichaelaHerm

    23 days ago

    Great work, good communication

    Project Description:Part 1: Develop two data markets; Share dimensions across data markets; Handle semi-additive measures. Requirements: You are asked to use the Foodmart database (file: FOODMART_2000.mdb) that you...
    [more]
  • $55.00 USD
    5.0
    Profile image for Seller caperi

    caperi

    Jun 18, 2014

    Good SQL and Access Programmer - Job done excellent and on time!

    Project Description:error finding
    [more]
  • $400.00 USD
    5.0
    Profile image for Seller caperi

    caperi

    May 29, 2014

    Did a good job and is flexible in making it work!

    Project Description:[This is a Private Project. You must be logged in to view the Project Description]
    [more]
  • $250.00 USD
    5.0
    Profile image for Seller vazman05

    vazman05

    May 10, 2014

    Great communication... quick service.. makes sure he answers any and all questions. 100% satisfied

    Project Description:Hi, I have 5 questions I need to answer in the PDF. These 5 questions are to build queries in the attached database. They queries need to use joins, and question #3 needs to have a crosstab query built
    [more]
  • $230.00 USD
    5.0
    Profile image for Seller michemilio

    michemilio

    Apr 19, 2014

    very professional with great skills

    Project Description:first of all sorry for may bad english but my problem is access i must improve this application in a good way, through skype for example o to have a database complete with query ,join from different database (uno a molti e viceversa)...
    [more]
  • €52.80 EUR
    5.0
    Profile image for Seller maxmaggot123

    maxmaggot123

    Apr 10, 2014

    Very professional. Would work with again.

    Project Description:I have a ms database that is pretty much complete. I have two bugs in it. One i that a DSUM function I have written has stopped working. If you know DSUM this should take 5 minutes to fix The second is a feature...
    [more]
  • $1210.00 USD
    5.0
    Profile image for Seller mmserv

    mmserv

    Apr 6, 2014

    good work.

    Project Description:Good evening, we already talked one week ago regarding that above described subject. At that time we were full of hope that the by us hired developer would finish his work in the and. We failed. He &#039;disappeared&#039; and left hanging us with an almost finished but still a bit buggy solution...
    [more]
  • $510.00 USD
    5.0
    Profile image for Seller mmserv

    mmserv

    Mar 29, 2014

    the developer showed a professional problem solving approach in that printing project. excellent work.

    Project Description:Implementation of a label print functionality in an existent Access/Excel solution based on VBA with multi range selection of records onto a Dymo label printer based on Excel form
    [more]
    IT Technical Specialist has not completed any projects.
  • $250 USD In Progress

    Develop a Microsoft SQL Server Reporting Services Report that will included data as well as GPS Maps and Multiple Database Images. All data will be provided and a sample will also be provided. Access to test data included via SQL connection.Report must have multiple filters to be used for Search criteria, will provide Filter Criteria. Report must be formatted to export to .pdf or Excel.Report must include a Single Datasource for connection. Connection string will be supplied.

    [more]
  • $30 USD/hr In Progress

    On an ongoing basis, I would like to delegate some of our database related work to a qualified and certified DBA.

  • $30 AUD/hr In Progress

    Hi thereI need support with matching/analysing data using Power BI. We are a gym and have 12 months of door access data and client data. Ideally we would like a dashboard that we can update on an ongoing basis quickly and easily with refreshed data (some sourced from a website). We would like to draw insights from the data through the management dashboard.If you&quot;re interested I can provided more detail and write some requirements for us to discuss?Hoping to start in 2 weeks time.ThanksKris

    [more]
  • $5333 HKD 2 days ago

    Looking for people to develop Apps on Ms Access and Ms Excel.

  • $244 USD 2 days ago

    I am needing a MS Access database that allows me to keep track of tickets. I know there are a lot of ticketing systems out there, but this is a custom job. Below are the needed aspects. I would like this to be done in forms. so that it is neater to look at. I am not sure if all of this can be done via Access. If not, please advise.Ticket Type:-Single-ProjectTicket Status:-Pending-ClosedPrimary Dashboard-Option to create new ticket-Option to input a ticket number and open that ticket-Ability to see all previous tickets either by all tickets, or single tickets only or project tickets only.-Ability to see tickets that are NOT in a closed state and are older than 1 day-Ability to see tickets that have not been updated in that last dayNew Ticket Options:-Ability to enter the date the ticket was created-Ability to insert your own ticket number-Ability to choose the ticket type (LAN, Email, HSS--Ticket options:-There needs to be a section where you can enter what type of access is being requested (see above for LAN,EMAIL, HSS). Then you need to have columns for the selections. -------If a user needs 1 group, there needs to be a column for the group, and a column for the approver. -------If a user needs sql access, there needs to be a column for the server, the database, and the type of access (db_datareader,db_datawriter,sp_execute, dbo, custom), as well as a column for the approver.-------If it is email, there needs there needs to be a column to put email, and a column for approver.-------There needs to be some sort of option to add multiple elements for each ticket. So if a user needs a group and sql access, I need the ability to add both to the single ticket.-------There needs to be some sort of option to show which requested part has been &quot;approved&quot;. This can be a checkbox, or whatever works.-------There needs to be a worklog so what has been done can be put in this box.-I need the ability to edit tickets and their worklog, as well as add additional elements that they are requesting to pending tickets.-If a request is &quot;urgent&quot;, I need some sort of way to show that those are urgent and stick out from the rest.-This is all I can think of for now. I know there is a call tracking system for ms access that may be easier to modify for this request: The link is located below:http://office.microsoft.com/en-us/templates/desktop-services-template-TC102489834.aspx

    [more]
  • £5555 GBP 2 days ago

    To setup a data warehouse (SQL)

  • ₹1000 INR/hr 2 days ago

    Develop database, forms and reports to capture operational data. Operations pertain to procurement, processing, storage and sale of horticultural produce, primarily Fruit.Data to be captured is currently maintained in paper forms and registers including Goods (Fruit) Receipt Note, Purchase (Fruit) Bill, Goods Receipt Note by Transporter, Delivery Challan, Stores Receipt Register, Stores Issue Register, Processing Register, Finished Goods Despatch register, Purchase Order from Customer, Goods Receipt Note by Transporter, Delivery Challan, Sales Invoice, Goods Receipt Note from Customer.We are based in Netaji Subhash Place, Pitampura, New Delhi, India and would work only with a local service provider.

    [more]
  • $20 USD/hr 2 days ago

    I need a employee/ subcontractor database that I can easily enter new employees and subcontractors into and then run searches based on the entered information. I will also need to enter information about the employees / subs on an ongoing basis, such as, jobs they work on and their performance on each job.When the database is completed, I should be able to easily input employee info, search the database for employees by location, by skills, and by performance ratings. This is not the only type of search I will need to perform but it is a good example of one type of search.

    [more]
  • $1000 USD 4 days ago

    1.SUMMARY AND BACKGROUNDThe Bar Association of Metropolitan St. Louis (BAMSL), founded in 1874, is a Missouri not-for-profit corporation, the members of which are attorneys principally practicing in the St. Louis metropolitan area. Our mission is to maintain the highest professional standards among attorneys, to enhance the professional competence of attorneys, to improve the administration of justice and promote the rule of law, to serve the needs of our members, and to provide law-related services and education to the public.The Motion for Kids Project (“Project”), co-sponsored by BAMSL and the St. Louis Rams, provides an annual holiday party for St. Louis area children who are in the foster care system, or whose parents are incarcerated, and others whose lives have otherwise been severely impacted by the justice system. Annually, approximately 3,000 children are served from over 750 families.Children are matched up with sponsors from the St. Louis legal community (lawyers, judges,paralegals, office administrators, law students and legal secretaries). Each sponsor is asked topurchase and wrap two gifts from the child’s wish list and to stuff a stocking. Gifts are distributed during the party, to which the children and their families are invited.BAMSL is seeking a proposal from an association management, data management, or other similar company (“Company”) to manage the database, data entry, report generation, and other associated administrative tasks associated with the Project in 2014. PLEASE SEE THE ATTACHED REQUEST FOR PROPOSAL

    [more]
  • $35 USD 4 days ago

    This project is to develop a report form using Microsoft SQL Server Reporting Services (SSRS) 2012. •The report form shall have the identical layout as shown in the attached Blank Report.pdf file, which is designed for the A4 size page setup. •The report shall be developed using Microsoft SQL Server Reporting Services (SSRS) 2012. •The goal of this project is only to do the report layout. The report will not have any datasets or parameters to populate the data in the report. The datasets and parameters will be added later as part of a different project.•The report designer shall deliver a .RDL file that will load in Microsoft SSRS 2012 without any changes.•The report form shall use design requirements shown in the attached Blank Report with Requirement.pdf file. •The final output of this project shall include one .RDL file and one sample print out of the report form in the PDF file format.

    [more]
  • $34 USD 4 days ago

    I have 2 sql stored procedures that when run repeatedly result in concurrency issues. Both of them are being executed in the scope of a transaction so it just doesn&quot;t make sense. I need a sql expert to review them, I have attached them. Basically the Count can go way over 50, sometimes over 100. When UpdateTokenCount is called, the Decrement value is in the range of 0-7.

    [more]
  • ₹13333 INR 6 days ago

    Need someone to write content for my website. This module is based on SQL and so need someone who has good knowledge about SQL. JOINS and SUBQUERIES are the most important part of this module. Need good amount of running queries on these topics.

    [more]
  • £666 GBP 6 days ago

    Wholesale distribution business looking to set up a sophisticated PowerPoint presentation. The company buy and sell large quantities of branded household products from all over the world, and i am looking for somebody to design a sophisticated and sleek website without too many functions on it.The website will most probably contain a few pages showing &quot;About Us&quot; &quot;The goods&quot; so some pictures illustrating the goods we sell &quot;Contact us&quot; and maybe one or two more. We are a wholesale business and will be dealing with other wholesalers so we do not want this to look like a retail site in any way shape or formPlease let me know if this is of an interest.Thanks

    [more]
  • $25 CAD 6 days ago

    I have this stored procedure (attached), it takes a few seconds to run after I fixed itBefore I took almost 12 minutes !!!What I would like to know is what caused it to be so slowYou can see the slow sql in the comment in the sql file

    [more]
  • $444 USD 7 days ago

    We have a window 2012 server running AD. Recently, some of our user PCs/laptops are having problem logging into AD, errors like &quot;Unable to login&quot;, &quot;Computer Not Found on Active Directory&quot;. etc. We need some expert to resolve this ASAP, please post your rate for full problem resolution with report of findings and proposed working solutions.

    [more]
  • ₹400 INR/hr 7 days ago

    I need some database(sql) work

  • $88 USD 7 days ago

    Tengo una base de datos en access y quiero migrar a MS SQL Server , los datos y la estructurala base con datos pesa unos 35 MBahora tengo el front y las tablas por separadonecesito esto muy rapido si alguien puede hacerlo con eficacia le agradesco contactarmeAngel

    [more]
  • $1111 USD 7 days ago

    SQL Server Tuning/Optimization Needed:We make extensive use of a SQL Server 2012 database. We are programmers, not database experts. Our server has periods of very high cpu utilization, we have some deadlock issues, and other typical SQL Server performance issues.We are looking for someone to help us tune and optimize the database, including the following:•Determine what is causing high cpu utilization and how to fix it•Monitor our queries and indexes to assist in optimizing them and improving the database•We have multiple applications using the database, so it may not be possible to change any schema without significant impact to our applications, so we are looking for an expert in helping optimize existing tables•Implement appropriate scheduled maintenance•Implement archiving of older data to an archive database•Apply your experience and expertise in all ways to help us tune and optimize the database•Because you will have access to our internal company data, an NDA will be requiredYou will document everything that you have done and share the documentation with us.Please do not reply to this posting unless you are very comfortable with SQL and databases. Also, please provide us with your credentials, pricing and availability including which days and how many hours each day.

    [more]
  • £155 GBP 7 days ago

    I&quot;m looking for a basic entry system that will allow excel report sheets and some mail merge options. Basic constituent info will be entered along with ward information and any interaction had through Councillors including dates and outcomes of any interaction.

    [more]
  • $33 USD/hr 7 days ago

    Need job support on SSIS packagesI am doing the job on SSIS packages.I need job support for creating the SSIS packagesI am using the script tasks inside the SSIS packages.Skills:SSIS packages

  • $34 USD 8 days ago

    Very easy project hopefully shouldn&quot;t take longer then 30 mins will send details

  • $794 CAD 8 days ago

    We need someone to design an Ordering Database for a small games retailer with multiple locations. The database will be used to enter items that need to be ordered from suppliers. The quantities will flow through the following stages: To be ordered, Ordered, Shipped, Received etc. There will be approximately 10 screens and the date has to flow flawlessly between them. If you are a Database expert, take a look at the attached file and get back to us ASAP.

    [more]
  • $111 USD 8 days ago

    Need your help with a database design assignment. Due soon so I Can work on some of it if you cannot complete it all in time.

    IT Technical Specialist does not have any open projects.
    IT Technical Specialist does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Business Intelligence senior concultant

Mar 2011 - Nov 2013 (2 years)

Accenture Morocco

- BI senior consultant for a variety of projects essentially for french clients (Carrefour,Loreal,Eurovia) <br />- Microsoft BI senior consultant (SSIS ,SSAS,SSRS)<br />- Reporting consultant senior development using Microsoft SSRS .<br />- ETL,project development in SSIS and informatica <br />- SQL Server administration and development.<br />- .Net development.

Microsoft Senior developer (BI & .Net)

Oct 2005 - Feb 2011 (5 years)

Copag Jaouda Morocco

- BI project Senior developer on variety of business actitivities covering three parts: <br />Collection and analysis of customer needs,development, testing and implementations of the solution<br /> - Microsoft Bi senior development using three parts of SQL server Business Intelligence suite (SSIS,SSAS,SSRS)<br />- Writing functional and technical specifications for BI projects.<br />- Advanced SQL server development using SQL and TSQL .<br />- Development of ETL projects using (SSIS ,Informatica).<br />- Development of SSRS proj

Education

Master 1 in computer science

Université de Toulouse-le-Mirail (Toulouse II)

2003-2005

specialised technician in information technology

2001-2003

Certifications

MCTS in Sql server 2008 business intelligence development and maintenance

Microsoft

Microsoft Certified technology specialist in SQL Server 2008 Business Intelligence development and maintenance