Datawarehouse

@Bhatti1987

I can create a clean, modular, and repeatable SSIS package that extracts data from the AdventureWorks OLTP database and populates a star-schema warehouse. The package will include: DimCustomer and DimDate with surrogate keys and full attributes An AccumulatingFactOrderPerformance fact table capturing key order milestones Support for initial full load and incremental delta loads Parameterized connections for different environments and scheduling capability I will provide: SQL scripts for creating warehouse objects Concise documentation covering package flow, configurations, and guidance for extending the model Use of best practices for lookups, SCD handling, and modular control flow I ensure the package will load only new or changed data during incremental runs, fully tested for accuracy and performance.

@SU790609

Hello there! I've carefully reviewed your project requirements and am excited to offer my services. With over 19 years of experience in full-stack programming and architecture, I believe I'm an ideal match for your needs. My expertise spans a wide range of technologies including Python, Java, Springboot, NodeJS, Django, React, Angular, and Golang. My background in various domains such as Manufacturing, Automotive, GIS, IOT, and Compliance, combined with my experience working with industry leaders like FCA, Cummins, Flex, and Tripwire, equips me with the unique ability to deliver high-quality, timely results. What sets me apart is not just my technical skills, but also my commitment to understanding and meeting your specific needs. I am passionate about leveraging my experience to help guide you towards the best technological solutions for your project. If you find my experience aligns with your project requirements, I would be delighted to further discuss how I can contribute to your success. Please feel free to reach out at a time convenient for you. I am keen on exploring this opportunity to collaborate and drive your project as per your needs. Warm regards, Sujit

@sayarsinghseo

With my combined experience in Data Analysis and my solid knowledge of SQL, I am confident that I can complete your DataWarehouse project. I understand the importance of creating a clean and repeatable package for efficient data extraction and loading, ensuring all necessary attributes and surrogate keys for analysis are accounted for. I have successfully handled similar projects in the past, making me well-versed in the use of best practices for look-ups, SCD handling, as well as parameterizing connections to facilitate easy configuration changes. Finally, I am committed to delivering a highly effective solution that will withstand operational tests. As such, I will run thorough tests on both full loads and incrementally inserted information; a procedure that ensures only deltas reach the warehouse after new data is pushed into your system. As a freelancer who values client satisfaction above all else, I'm eager to bring my skills and passion to enhance your data warehousing experience.

@surya8527

Sir, Project completely understood. SSIS package + SQL scripts + documentation ready. I have attached the PDF/Excel file with full details. I can start immediately.

@Carrs4

HI there from New Zealand, I am a data analyst with proficiency in excel procurement and BOMs. I can provide a sample of work I have done in powerquery in excel if this will assist. kind regards Craig