MSSQL, ORACLE, pgsql,mysql (3966449)

Programming & Development Database Design & Administration

MSSQL, ORACLE, pgsql,mysql

$50/hr Starting at $50

I have 8+ years experienc of administrating, quering, programming MSSQL database and around 6 years of quering and programming Oracle database (administrating no!). I also have experience in sqlj of Oracle. I am using PGsql and MySQL only in my C#, java or VBA applications as datasource, like querying them or calling stored procedures/functions and inserting data from user entry forms. My best work in this category: Cost controllers certificated costs in SAP and it has to be transferred and transformed for our applications to include them in the daily reports. To achive this goal I have developed an interface purely in plsql, oracle-java and tsql. SAP sent us the daily costs in an xml file. The central database (oracle) read this file, extracted the costs and then depending on certain pre-defined conditions it distributed the costs to the proper local database that could be oracle or MSSQL. When the process is successfull the interface sends back to SAP a confirmation xml, or if there are errors in the set of the received data an .xml is returned with the description of the error. The interface also checks it the daily report is already created or accidentally created twice or more, or if the target database can't receive the data for any reason. In all cases a respond is emitted to SAP to let them know what is happening in the database and able to perform the proper action.

Service Thumbnail made by smashingstocks from https://www.flaticon.com/free-icons/database

About

$50/hr Ongoing

Download Resume

I have 8+ years experienc of administrating, quering, programming MSSQL database and around 6 years of quering and programming Oracle database (administrating no!). I also have experience in sqlj of Oracle. I am using PGsql and MySQL only in my C#, java or VBA applications as datasource, like querying them or calling stored procedures/functions and inserting data from user entry forms. My best work in this category: Cost controllers certificated costs in SAP and it has to be transferred and transformed for our applications to include them in the daily reports. To achive this goal I have developed an interface purely in plsql, oracle-java and tsql. SAP sent us the daily costs in an xml file. The central database (oracle) read this file, extracted the costs and then depending on certain pre-defined conditions it distributed the costs to the proper local database that could be oracle or MSSQL. When the process is successfull the interface sends back to SAP a confirmation xml, or if there are errors in the set of the received data an .xml is returned with the description of the error. The interface also checks it the daily report is already created or accidentally created twice or more, or if the target database can't receive the data for any reason. In all cases a respond is emitted to SAP to let them know what is happening in the database and able to perform the proper action.

Service Thumbnail made by smashingstocks from https://www.flaticon.com/free-icons/database

Skills & Expertise

App DevelopmentCrystal ReportsData EntryData ManagementDatabase DevelopmentDistributed ComputingJavaLikesMicrosoft SQL ServerMySQLOracle DevelopmentPgSQLPhone SupportPL/SQLPlsqlProcess DesignProgrammingReportsSQLSQLiteStored ProceduresT SQL Stored ProceduresUser Interface DesignVBAXML

20 Reviews

Sarah 421 says,

Great work and very patient when we had problems with our payment method! Thank you Perceval.

for Marketing automation project on Feb 21, 2019
InterParts says,

Great work, thanks

for Extract data from PDF files into Excel on Oct 17, 2018
Chris 1018 says,

A stellar job one again.

for New program on Sep 28, 2018
InterParts says,

Very highly recommended. Perceval understood the project and was efficient and professional in completing the task. Communication was quick and easy and it was a pleasure working with Perceval. I would not hesitate in hiring Perceval again and would recommend them to others without hesitation. A+++ Many thanks.

for Extract data from PDF files into Excel on Feb 06, 2018
Chris 1018 says,

Exactly what I wanted. Great job once again.

for 3rd GUI program on Dec 08, 2017

Sign up or Log in to see more.

perceval