offline
Last seen: Jul 12, 2014 1:55 PM EDT
Hire Me!
Rate: $10.00 USD/hour
Follow Invite to Project
 

Jinesh Marasinghe

Microsoft SQL Server 2008 (SSIS, SSAS, SSRS)

Username: marasinghe82

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

Location: Colombo, Sri Lanka

Member since: August 2011

Reputation:

5.0/5

(62 reviews)

5.5
[see more]

No user has recommended this freelancer.

My projects:

  • $45.00 USD
    5.0
    Profile image for Seller wiggy

    wiggy

    2 days ago

    Brilliant!!! a first class worker.

    Project Description:I have a database (Mssql 2008) which I want it installed on a new .asp website (Mssql 2012) and possibly tweaked a little. I am not technically minded or familiar with “techno speak” so please be bear...
    [more]
  • $111.00 USD
    5.0
    Profile image for Seller crobz

    crobz

    Apr 7, 2014

    We will use this contractor again. He does great work!

    Project Description:This report is part of a larger project to create a SQL Server Reporting Service (SSRS) based reporting solution. There will be more report projects posted on this site. The included screen shot is intended for general direction and visual enhancements will be acceptable/desired...
    [more]
  • $111.00 USD
    5.0
    Profile image for Seller crobz

    crobz

    Apr 7, 2014

    We really like this contractor. We will use him again. He is thorough and responsive and does quality work.

    Project Description:This report is part of a larger project to create a SQL Server Reporting Service (SSRS) based reporting solution. There will be more report projects posted on this site. The included screen shot is intended for general direction and visual enhancements will be acceptable/desired...
    [more]
  • $111.00 USD
    5.0
    Profile image for Seller crobz

    crobz

    Apr 3, 2014

    We will use this contractor again. Excellent work!

    Project Description:This report is part of a larger project to create a SQL Server Reporting Service (SSRS) based reporting solution. There will be more report projects posted on this site. The included screen shot is intended for general direction and visual enhancements will be acceptable/desired...
    [more]
  • $111.00 USD
    5.0
    Profile image for Seller crobz

    crobz

    Apr 3, 2014

    This contractor does excellent work. We will use him again.

    Project Description:This report is part of a larger project to create a SQL Server Reporting Service (SSRS) based reporting solution. There will be more report projects posted on this site. The included screen shot is intended for general direction and visual enhancements will be acceptable/desired...
    [more]
  • $111.00 USD
    5.0
    Profile image for Seller crobz

    crobz

    Apr 3, 2014

    We will use this contractor again.

    Project Description:This report is part of a larger project to create a SQL Server Reporting Service (SSRS) based reporting solution. There will be more report projects posted on this site. The included screen shot is intended for general direction and visual enhancements will be acceptable/desired...
    [more]
  • $35.00 USD
    5.0
    Profile image for Seller crobz

    crobz

    Mar 20, 2014

    Excellent work from this contractor. We will use him again.

    Project Description:This report is part of a larger project to create a SQL Server Reporting Service (SSRS) based reporting solution. There will be more report projects posted on this site. The included screen shot is intended for general direction and visual enhancements will be acceptable/desired...
    [more]
  • $111.00 USD
    5.0
    Profile image for Seller crobz

    crobz

    Mar 10, 2014

    Excellent work. We will definitely use this contractor again.

    Project Description:This set of five reports are part of a larger project to create a SQL Server Reporting Service (SSRS) based reporting solution. There will be more report projects posted on this site. The included screen shot is intended for general direction and visual enhancements will be acceptable/desired...
    [more]
  • $111.00 USD
    5.0
    Profile image for Seller crobz

    crobz

    Mar 10, 2014

    Excellent work and very professional. We will use this contractor again.

    Project Description:This report is part of a larger project to create a SQL Server Reporting Service (SSRS) based reporting solution. There will be more report projects posted on this site. The included screen shot is intended for general direction and visual enhancements will be acceptable/desired...
    [more]
  • $111.00 USD
    5.0
    Profile image for Seller crobz

    crobz

    Mar 10, 2014

    Excellent work! We will use this contractor again.

    Project Description:This report is part of a larger project to create a SQL Server Reporting Service (SSRS) based reporting solution. There will be more report projects posted on this site. The included screen shot is intended for general direction and visual enhancements will be acceptable/desired...
    [more]
    Jinesh Marasinghe has not completed any projects.
  • £150 GBP In Progress

    Hi,I have three MSSQL server DB"s filled with news articles in Categories and sub categories. I want the data in these three db"s approx. 25mb, 50mb and 350mb converted into categorised wordpress databases. As I understand it the sub cats can be converted into categories for word press to work properly. The categories must be maintained and carried through. I can supply the db"s in .bak format so that the work can be done locally if needed. Is this something you think you could do?

    [more]
  • $250 USD In Progress

    Only bid if you can produce this report here with crisp quality. Here is a sample report to show you the complex of the report. You will get the data for this report through web services and will convert the report to a pdf.https://ipro.americancentury.com/content/dam/americancentury/ipro/pdfs/factsheet/AllCapGrowth_multi.pdfShow similar work you have done.This will be a ongoing job for the right person.

    [more]
  • $10 AUD/hr In Progress

    Work on SQL Queries

  • $10 USD/hr In Progress

    I need to create 15 SSRS reports. T-SQL skills required in this project. We will provide the Database this project is accepted.

  • $50 USD In Progress

    Write some code to pick and import 2-3 XML Files (embargo Lists US and EU) to MS-SQL Server with all relations. Find some fields within the list (lastname, firstname, adress, and some other) and write them to predefined sql tables. Needs to be done in Visual Studio 2010 with Vb.net.

    [more]
  • $30 USD In Progress

    This is a data cleansing project in Excel.The task is to transfer data from one Excel spreadsheet to another. The first spreadsheet contains tables from an old MS Access database, one worksheet is one table in MS Access. The second spreadsheet contains templates for the new SQL Server database, one worksheet is one table in the SQL Server.You need to transfer data from the Source Spreadsheet (SS) to the Destination Spreadsheet (DS), column by column. This process cannot be fully automated, because the data in the SS must be cleaned before being transferred to the DS. Therefore, the data should be transfer column by column, with clean up and check up.The SS workbook has about 30 worksheets, the DS workbook has about 8 worksheets.The SS workbook contains worksheets of Customers, Stock Items, Purchases etc. There are about 300 customers, 500 Items and 500 Purchase Invoices. The total size of SS in Excel is about 1 MB.It took me about 20 work hours to do the first such transfer myself.This project is for one transfer from SS to DS, but we have about 40 identical projects. If your performance on the first project is good, then you may be invited to continue this work over the next two months.If you are short-listed on this project, you will receive the SS and DS without data but with a count of records in each, to get a better idea of the amount of work and to adjust your bid accordingly.This is a basic level work, which requires no special Excel skills, but it requires from you to be persistent and very, very tidy. The criterion of your achievement is how easily and quickly your DS can be imported into SQL Server. If SQL Server rejects your DS and I have to do many corrections, then you have not done your job well.Please supply any references for similar work done before (person name and email/phone).

    [more]
  • $55 USD Yesterday

    Create a DB on SQL Server 2012.Import a 5GB CSV file and use a spec file to determine field types. Also make sure values do not have quotes around them.Backup the database and send it to me.

  • $25 USD Yesterday

    Hello,using sql 2008, trying to convert a string to intExampleTable1 has a varchar which i want to cast to int00125000000 to int 125000000i used the followingcast(B.[Assessment] as int) as [USER1_01],with the result 125000000Table2 has the same field in a different format.0.00125i need to find a way to convert one of them so they both match. if i did a join and matched the fields.I tried cast (10000000000 * cast([USER1_01] as NUMERIC(6,6)) as INT) as [USER1_01]but for some reason it dosent look like they match, although they look the same. maybe a type problem?.I hope someone can shed some help me, been working on this for a long time :(

    [more]
  • $15 USD 2 days ago

    Hello,using sql 2008, trying to convert a string to intExampleTable1 has a varchar which i want to cast to int00125000000 to int 125000000i used the followingcast(B.[Assessment] as int) as [USER1_01],with the result 125000000Table2 has the same field in a different format.0.00125i need to find a way to convert one of them so they both match. if i did a join and matched the fields.I tried cast (10000000000 * cast([USER1_01] as NUMERIC(6,6)) as INT) as [USER1_01]but for some reason it dosent look like they match, although they look the same. maybe a type problem?.I hope someone can shed some help me, been working on this for a long time :(

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

    I am looking for couple of SSRS report expert who have done print quality reports. This is a long term project.Only bid if you know answers to these questions:1. How to insert eps files into the SSRS (We have our high quality logos in eps format). When converted to outher type formats it looses quality.2. PDF report from SSRS is not high quality. Any suggestion or improvement we could do.3. SSRS is not supporting OFT fonts. What is the solution.Thanks

    [more]
  • $55 USD 9 days ago

    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 should first import in SQL Server Management Studio to develop a sales data market in SQL Server BI Development Studio.The first data market is about the sales business process. Your fact table should be about the sales for 1998 (be careful: not just December 1998). As dimensions, please include:• Product (be careful: product dimension is “snowflaked”)• Time (time by date)• Customer (don’t include the attributes Mi, Address2, …, Address4).• Promotion• StoreYou may wish to include several of the available attributes for the dimensions and also to introduce hierarchies, when possible. As measures in the fact table, please include:• Store Sales• Unit SalesThe second data market is about the inventory business process. Your fact table should be about the inventory for year 1998. As dimensions, please include:• Product• Time (time_by_day)• Store• Warehouse (be careful: warehouse dimension is “snowflaked”)You may wish to include several of the available attributes for the dimensions and also to introduce hierarchies, when possible. As measure in the fact table, please include:• Units orderedHere we make the assumption that after products being ordered (from the supplier), the delivery may not be always successful. Therefore, orders may be repeated over time. This way, you can treat “Units ordered” as a semi-additive measure. Please explain how you can (re-)define1 “Time by Date” as dimension of type “Time” and which Aggregate Function for averaging do you have to use for the “Units ordered” measure.DeliverablesAs deliverables for Part 1, please make:• A brief report with screen-shots and short description of the steps you followed.• One example of a screenshot from the “Browser” for the sales and one for the inventory data market (please pick just the time dimension).--------Part 2: Perform OLAP operations such as roll-up/drill-down/slice; Connect MS SQLServer with MS Excel.RequirementsYou are asked to use the “Sales” cube that you created in Part 1 and generate Excel charts for the following OLAP reports and answer the questions listed below:1. Profit with respect to Gender and Marital Status. Profit can be defined according to Store Sales (or alternatively according to Unit Sales).• Question(s): Is Marital Status a more important factor for Males or Females with respect to profit?2. Profit with respect to all Store Cities in USA and the 4 quarters of year 1998.• Question(s): Which Store City had the largest profit for the fourth quarter of 1998?3. Profit with respect to Promotions in Store State ‘OR’ of USA. Exclude ‘No promotion’ from the result.• Question(s): Which promotion resulted to the largest Profit? Please provide your comment about your answer to the last question.4. Profit with respect to Customers State Province in USA and their Marital Status for the four quarters of year 1998.• Question(s): In which State (or States) is Profit largest in the fourth Quarter of 1998; and is this happening both for ‘Married’ and ‘Single’ customers or only for one of these categories? How could you interpret this conclusion about the found state (or states), assuming that the fourth quarter of the year includes the pre Christmas (data is up to November) shopping period? Drill-down to the level of Customer City for the found state (or states) and check whether this conclusion (i.e., comparison between ‘Married’ and ‘Single’ in Q4) holds for all or some of the cities.DeliverablesAs deliverable for Part 2, please make:• Excel charts showing the results of the OLAP queries.------------------For part 3 and 4 please look at the uploaded PDF document.Budget can be extended to max. $ 50

    [more]
  • $40 AUD/hr 10 days ago

    You will be working for one of Australia"s big 4 banks Oracle PL/SQL Developer - Banking My client is looking for the services of an experienced Oracle PL/SQL Developer to assist them with migration of client-based applications that have been user-developed using the Microsoft Office suite (MSAccess, VBA, MSExcel) onto a client-server based platform, centred around Oracle 11g. Role: Data Layer: Migration of data from existing MSAccess & MSExcel stores, onto some pre-existing Oracle 11g artefacts (our own people will perform this task)Logic Layer: Migration of logic from existing VBA procedures & MS-SQL scripts acting on the existing data artefacts, to Oracle PL/SQL procedures acting on the Oracle 11g artefacts above (the Oracle PL/SQL developer will perform this task)Presentation Layer: Development of presentation layer, using tools compatible with Oracle 11g, to present and publish results (this will be a shared responsibility between our own people and the Oracle PL/SQL developer) Competencies: The Oracle PL/SQL developer will need to be able to understand procedures written in VBA used in conjunction with MS-SQL on MSAccess databases, and be able to functionally translate these procedures to PL/SQL on Oracle Databases.

    [more]
  • $155 USD 10 days ago

    I"m looking for a person who has the knowledge to make a 4-5 table database with Microsoft SQL Server 2012.You will also have to tell me briefly, how it"s done, step by step.What I need to know is how to install the database software, how to create and manage created tables, follow and optimise the database, creating user accounts, etc. I would say it"s pretty much basic stuff, but I still need someone else to do this since I do not have any experience from SQL.We can also make a teamviewer desktop presentation, and you quide me through how to do it. I will give you more details when you contact me.

    [more]
  • $166 USD 10 days ago

    We have a CRM in a MSSQL database.The CRM consist of about 20 users all with their own data and files uploaded to the CRM.We are migrating from windows software running locally MSSQL database to SugarCRMIn this task we need you to :Map all fields from MSSQL to MYSQLMigrate all data from MSSQL users to MYSQL usersUpdate all uploaded file relationships so that the files previously uploaded to the MSSQL crm are available via Sugar CRMOnce done we will test fully.Budget = 250$

    [more]
  • $155 USD 10 days ago

    I"m looking for a person who has the knowledge to make a 4-5 table database with Microsoft SQL Server 2012.You will also have to tell me briefly, how it"s done, step by step.What I need to know is how to install the database software, how to create and manage created tables, follow and optimise the database, creating user accounts, etc. I would say it"s pretty much basic stuff, but I still need someone else to do this since I do not have any experience from SQL.We can also make a teamviewer desktop presentation, and you quide me through how to do it. I will give you more details when you contact me.

    [more]
  • $25 USD 14 days ago

    Just have to ask a couple questions should not take that long

  • $20 CAD 15 days ago

    i need someone to help me solve the sql query right away.It needs to be done within few minutes. Its just I am stuck.SQL Required.

  • $35 AUD 19 days ago

    Please refer to the attachments. Export data from SQL server to excel using the pre-existing template. I require the query in the "Requirements.doc" to export data from SQL into an existing XLS file (not a new file - I can achieve this already). The pre-existing file is attached which includes all the pre-defined columns and all columns are formatted to the type of data that will be in each column. The export process of the data to XLS should be that of a stored procedure and should not alter the column headers - it should simply export the data to the XLS in to the designated columns i.e. PositionNo (SQL) > PositionNo (XLS).

    [more]
  • ₹1300 INR 22 days ago

    SSIS expert must have following skills: -1.Minimum 4-5 years of experience on SQL server and SSIS2.Minimum 1 year experience in ETL development3.Need to understand and clarify analytic reporting needs and design appropriate solutions4.Migrate source data to data warehouse and populate data marts to support reporting and analytics5.Tune cubes, support generation of Universe(s) and reporting solutions6.Required skill set includes strong SQL Server knowledge and experience; including ETL, data warehousing, data modelling, data architecture, and data optimization7.Experience in writing and executing SQL queries.8.Experience in data analysis and profiling using SQL Server.9.Experience in Data warehouse requirements analysis and data modelling10.Technical Skill: SQL Server, SSIS, SSRS, TSQL, Excel

    [more]
  • [Sealed] Jun 13, 2014

    NOTE: No upfront. Payment via Freelancer escrow only. Payment release is by per complete milestone only.I need a solution for the below:1) When there is a new row added for a specific table in mssql server, i want the new row to be added into a specific table in mysql server too2) When there is a new row added for a specific table in mysql server, i want the new row to be added into a specific table in mssql server tooNote: 1) mssql server is on a window server2) mysql server is on a linux server3) It should be as realtime as possible. When the new row appear in either server, it should update the other server in the smallest possible timing.4) Version: MS SQL Server Version 2008 Edition: Microsoft SQL Server Standard Edition (64-bit)If you are interested in this project, please provide the below for my consideration:1) Bid amount2) Time needed to implement the solution3) Solution description (please be specific on what you will be doing so that my requirement is fulfilled)4) Please indicate any limitation for your solutionThanking for your interest.

    [more]
  • $35 USD Jun 12, 2014

    If you are expert in SSIS and visual basic and you want a fast feedback this is right project for you.Project:In a folder (variable) we have a number of the file excels. Every file excel has a different sheet and a numbers of columns that can change for every file excel.RequestReading the first sheet of every file and loading the first three columns that have the same labels and one column with name “ Variable_xyz”// The labels (name of a column) are placed from third row.This is a simple project for who want a fast feedback. You send the package and you will receive a positive feedback.Budget 30 $

    [more]
  • $16 USD/hr Jun 10, 2014

    Is a continuing project on BI Stacks (TSQL,SSIS,). I need some one to help me at least two hour per day for a certain period of time. Compensation "Negotiate"

  • $16 USD/hr Jun 10, 2014

    We are looking for SQL expert who can build SQL queries depends on requirements to pull data out of SQL database and validate data as well.

  • $555 USD Jun 10, 2014

    I have four small questions that need to be done in SQL. Please take a look. They are attached in a zip file. I need them in the next four days. Check them out and make your bid.Thanks.

  • $55 USD Apr 7, 2014

    This project is to:Load data from a text file into SQL Server as FAST AS POSSIBLECode already exists but it is too slow for our needs. It times out often.The existing code:reads the text file (AGS format) into a datasetuploads tables from dataset into SQL Server - it is this write Tables to Database part which is too slowThe Upload needs to retain referential integrities

    [more]
  • $111 USD Feb 8, 2014

    Need to work on SSIS package with , SQL Server & .Net.

    Jinesh Marasinghe does not have any open projects.
    Jinesh Marasinghe does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Software Engineer

Jun 2008 - Apr 2010 (1 year)

LOIT

Software Engineer

Nov 2005 - Jan 2008 (2 years)

Sanje Lanka

Education

BSc in MIS

University College Dublin

2003-2007

Certifications

MCTS

Microsoft

Microsoft Certified Technology Specialist (MCTS) for Microsoft Office SharePoint Server Application Development.

MCTS

Microsoft

Microsoft SQL Server 2008, Business Intelligence Development and Maintenance.