📊 Data Warehouse/ BI Developer | 📈 Data Enthusiast
Welcome to my GitHub profile! I'm passionate about transforming data into actionable insights and creating data-driven solutions. Take a look at my personal projects and contributions that showcase my skills and expertise in the world of Business Intelligence.
🛢️ Dimensional Modeling with dbt and Snowflake - This project showcases the implementation of dimensional modeling techniques using dbt and Snowflake for analyzing store sales data. Dimensional modeling optimizes data warehousing and analytics by organizing data into dimensions and facts, enabling efficient querying and analysis of business metrics.
📊 Microsoft SSIS ETL projects - This repository serves as a showcase for my collection of Microsoft SQL Server Integration Services (SSIS) ETL projects. Explore a range of data extraction, transformation, and loading solutions developed with SSIS, aimed at streamlining data workflows and ensuring data accuracy. Whether you're interested in data warehousing, data integration, or data migration, these projects demonstrate my expertise in leveraging SSIS to handle complex ETL tasks efficiently. Dive into the code, documentation, and examples to discover the power of SSIS in action.
📈 Python ELT - CSV to SQL Server Script - This repository contains a Python script designed to streamline the process of loading data from CSV files into a SQL Server database. Whether dealing with large datasets or frequent updates, this script offers an efficient and automated solution to ensure your data is seamlessly integrated into your SQL Server environment. Simplify your data-loading workflow with this Python script and accelerate your database management tasks. Make your data migration and integration process more efficient than ever!
📉 Shell Script: Pre-processing of CSV file into detail and control file - This repository contains a handy shell script designed to streamline the process of loading and preprocessing CSV data before it's ingested into a target database. It generates a detail and control files that help ensure data integrity and traceability during the loading process. Whether you're a BI Developer, Data Engineer, or anyone working with CSV data, this script can simplify your ETL (Extract, Transform, Load) process and enhance your data pipeline. Streamline your data workflow today! Feel free to explore the code, contribute, or adapt it to your specific needs.
👔 Data Warehouse Developer at ANZ, Wellington, New Zealand - Teradata | Ab Initio | IBM DataStage.
🔗 My LinkedIn Profile - Connect with me on LinkedIn for a more detailed professional background.
Here are some of the tools and technologies I'm proficient in:
- 📊 Business Intelligence Tools: Power BI
- 📚 Data Warehousing: Snowflake, Teradata
- 🧾 ETL: SSIS, DataStage
- 📈 Data Visualization: Matplotlib, R Shiny
- 💻 Programming Languages: Python, R
I'm always open to exciting opportunities and collaborations. Feel free to reach out to me through:
Let's connect, and together, we can turn data into insights that drive business success! 🚀