MS SQL Server Database Procedure and Script Creation

Hi I have been working with MSSQL for over 14 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

Could you please explain what kind of assistance you gonna need? I am very good at T-SQL so i can deliver whatever you need but would be greatly appreciated if you can show me something so i can know what i am dealing with. Thx

Dear sir, Please let me know the functionality to write the logic for the same, I am expert asp.net and C# developer, let me know the things so we can get started on the same. Thanks Chetan

Hi I am Vinod Kumar. I am working as Senior Software Developer in IT company. I have 4 + years experience in .NET with C#,VB,ASP.NET, Javascript, JQuery, SQL, XML ,XSLT and HTML. Work sample : ALTER PROCEDURE [dbo].[spu_ShareholdersListSearch] @shareholderName VARCHAR(255) = NULL, @shareholderNumber VARCHAR(30)=NULL, @growerNumber VARCHAR(10)=NULL, @abn VARCHAR(14)=NULL, @taxFileNumber VARCHAR(11)=NULL AS BEGIN SELECT * FROM [dbo].[tblShareholderDetails] WHERE (@shareholderName IS NULL OR ShareholderNameLong = @shareholderName ) AND (@shareholderNumber IS NULL OR ShareholderNumber = @shareholderNumber ) AND (@growerNumber IS NULL OR GrowerNumber = @growerNumber ) AND (@abn IS NULL OR ABN = @abn ) AND (@taxFileNumber IS NULL OR TaxFileNumber = @taxFileNumber) END

A proposal has not yet been provided

Over 14 years of experience in Microsoft Technologies. MCTS (Microsoft Certified Technology Specialist) on Web Applications Development with Microsoft .NET Framework 4 (Exam Code: 070-515). Functional experience includes Telecom Application (OSS & BSS Rating and Billing), Financial Application, ERP-Application, and School Application, Central and State Govt. Offices application and development of user interface elements for embedded software. Having good knowledge and skills in OOPS (Object Oriented Programming), ASP.net with C# & VB, Web services (SOAP, WSDL), WCF, MVC, Entity Framework, Visual Basic, Crystal Report, MS SQL Server, Oracle and MS Access. Experience in working VS2012, VS2013 and VS2014 with AngularJS, Knockoutjs, DurandalJS, KendoUI etc all advanced technologies. I have a ready made code for it and can quickly deliver with few tweaks only. Very committed to deliver products matching with requirements on or before time. I will develop and give demonstration frequently to match your expectations. For any clarifications, contact me.

Hi I'm an IT student with good knowledge in sql and database design. Check my review and my portfolio and let me know if you interested to get job done. I can send you more sample if you need. regards

I have 6 Year of experience in SQL Server. i can show you projects on which i had work on. Regards, Vishal Agrawal Pune, India +91 8087087424

Working in Accenture pvt Ltd as senior software engineer (MSBI Developer) ... Have extensive experience in MS sql database creation..... Have good experience in sp and database creation and performance tuning....