Write some Software

Do you have any recommendations to make this project run successfully? I HAVE 5 YEARS OF EXPERIENCE AND I HAVE DELIVERED 155 PROJECTS WITH 100% CLIENT SATISFACTION Proposal: Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply

Hi I will create SSIS packages to import the data into the SQL. The packages will be called from VB. All the work will be done in SQL with SPs because it is must faster than manipulating data into VB. I have been working with MSSQL for over 17 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 dashboards via Power BI and 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

Do you have any recommendations to make this project run successfully? Yes but let's first see my questions Proposal: Hi Mike, Can you share your files structure and db structure .. and what kind of de duplication you needed there can be many scenarios . You need to be specific with your requirements and also what about email on data. Can you come up with everything in a requirement document in ms word and I think it can't be don under $2000 if you really want to make it perfect

HI, We are an experienced and talented team of Professional SEO consultants. We are passionate about helping you to build and expand your business by doing ethical work. Our skilled SEO team is well-versed in taking businesses to the next level. We believe in building long-term relationships with clients, based upon shared ideals and success. Our SEO agency provides the following and more: SEO Audit Keyword & Market Research Onsite SEO Webpage Content Optimization Content Marketing Link Building Adwords Marketing Reputation Management Reporting & Analysis If you have any question, please feel free to ask me. I will be waiting for your positive and fruitful response. Thank you!!

Do you have any recommendations to make this project run successfully? The project doesn't seem too complex. Nevertheless, we must agree how to handle inconsistencies. I propose you, additionally, having one table per file type where we'll store records that didn't pass integrity checks, holding references to file name and line number for easing the search. Proposal: Hello! I’m Microsoft Certified Professional with 5+ years of experience in SQL Server platform (please have a look at me profile if you like more details). I really like the project since it's well defined. Nevertheless, we must agreed how to handle inconsistencies. I propose you, additionally, having one table per file type where we'll store records that didn't pass integrity checks, holding references to file name and line number for easing the search. I’m very structured and ordered for working, so I'll give you SSIS pakages with logic that is correctly encapsulated and would be easy to mantain or extend in the future. Although the integrity checks you require don't seem too complex, if needed, I can code even more complex validations using C#. I'd like to have production files for unit tests, since results are very data dependent. I look forward hearing from you.

The vast experience in Microsoft SQL Server and the things I have done in the past very much matches to the requirememts you have posted. So, I think I will be a great choice to be considered for this work. Hoping to work with you soon :)

Do you have any recommendations to make this project run successfully? The "hot folder" - we would be able to do this in 2 different ways, your SSIS job scheduler could run every 30 seconds or we can create a C# service that watches the folders and kicks off the job the second they hit the folder. We can use a SQL merge statement to ensure we dont have duplication. Proposal: Good Day, I believe i will be perfect for your project as i have a lot of MS SQL, SSIS and ETL knowledge, which your project will require. I have a lot of fresh ideas for your project that i would love to share with you once you have made your freelancer selection. I would love to be a part of your project as SSIS, Data and ETL processes are some of my favorite tasks. Hope to hear from you soon, Jeandre Knox

I am SQL server developer with 7 years of experience. Familiar with T-SQL, ssis . I can process .CSV transform it using ssis , apply validations through T-SQL code, and provide output file with required columns. You can provide the different workflows and output file formats.

Do you have any recommendations to make this project run successfully? 1-Strong knowledge of ETL using SSIS (different version for SQL server including 2016/2012) 2- Can extract/load data to and from .csv/excel or other format file 3- Load data into target SQL server with using intermediate data validation/data conversion into SSDT (SQL Server Data Tools) Proposal: •Over 10+ years of extensive experience in Database development (SQL 2016/2012/2008 R2). •Very strong knowledge of data ETL using MS Business Intelligence Studio SSIS packages. •Expertise in relational databases SQL Server 2016/2012/2008 R2 and in programming languages like T-SQL (Transact-SQL) for Online Transnational Processing (OLTP) and Online Analytical Processing (OLAP) applications. •Excellent back-end skills in creating SQL objects like Stored Procedures, UDFs, Views, Indexes, Triggers. At present day to day responsibility into design/development and maintaining SSIS packages using SSDT/VS 2015, all the packages would be part of solution and under different projects as per functionality group. SSIS packages are having different source/target including flat files (.csv, fixed length)/excel file/MS SQL DB/Oracle DB MS In Computer Science from Towson University, Maryland USA

Do you have any recommendations to make this project run successfully? Develop ETL processes, using SSIS Control Flow, Data Flow, Parameters, Event Handlers, Package Explorer Proposal: IT professional with more than 10 years of experience in Enterprise Data Warehouse, Enterprise Application Integration ETL/BI, and Cloud Computing in Business and IT, Marketing and Advertising, Health, Telecom, Bank and Finance, Insurance, Energy, and Agriculture sectors. Particular experience in architectural design of the ETL environment and development of scalable enterprise applications and data warehouse development. Skill Summary • Data warehouse/EAI/ETL/BI experience using Informatica, IBM Cognos, BODS, Power BI, Microsoft BI Stack • Built cubes (Multi-dimensional/Tabular), using SSAS, Report Designer/Model, Cognos Power Play Transformer, Framework Manager • Transact-SQL and PL/SQL stored procedures and create database objects • DWH, Database and ETL Architecture design, NoSQL, Storage, VMs, Administration, installation and configuration, performance tuning, on-call support, requirements elicitation and definition • Microsoft Azure technologies (ADF, NoSQL, HDInsight-Hadoop) • Knowledge in AWS EMR, AWS RDS, Redshift, S3, Data Pipeline, Hive, Pig, Cloudera Hadoop distribution, Big Data concepts, HBase, Spark • Data Conversion, Oracle to IBM Panorama, MS SQL to SAP SF, DB2 to SAP/HCL • Data Modeling using SSMS, ErWin for an OLAP/OLTP database environment • Star Schema vs. Snowflake Schema, Kimball vs. Inmon DWH design methodologies • HTML/CSS, jQuery, JavaScript, Python, C#

A proposal has not yet been provided