Birhanu Bizuwork

I hold a BA in Business Management and have completed training as a full-stack developer and database developer to integrate this field with technology. I have earned various certifications and licenses from institutions such as ColaBerry School of Data Science & Data Analytics, Tutorialspoint, and Merit America. My skills and knowledge include creating technical solutions for businesses using BI tools like SQL Server, SSIS, SSRS, Power BI, Tableau, and Excel, as well as developing user interfaces with HTML, CSS, and JavaScript. I have successfully completed projects in various domains, including a mortgage database project, online sales, and other development works. Currently, I am enhancing my skills in back-end technologies and various databases through different courses and practical projects. My goal is to leverage my business management background and technical skills to create efficient and effective solutions for businesses, helping them to achieve their objectives and improve their operations. I am passionate about continuous learning and staying updated with the latest trends and technologies in the field of data science and web development. In my free time, I enjoy working on personal projects, contributing to open-source communities, and exploring new tools and technologies.

• Data Analytics, Colaberry Inc, 02/10/22
• Power BI, Tutorialspoint, 03/22/23
• Tableau, Tutorialspoint, 04/22/23
• Business Analytics, Tutorialspoint, 01/10/23
• Datawerehouse, Tutorialspoint, 02/02/23
• Bookeeping, Tutorialspoint, 03/22/22
• Front end Developer, Tutorialspoint, 08/10/24
• Back end Developer, Tutorialspoint, 03/22/23

Mortgage Project 

Mortgage Database Project, As a database developer, I successfully completed a comprehensive banking mortgage and loan system project. This involved designing and implementing an ETL solution to consolidate loan applications from various sources into a unified Loan Application Database. The process included validating data for required fields and formats, and developing a notification system for loan officers to address any errors. I created a robust data warehouse to store both approved and rejected loans, ensuring scalability for future growth. Additionally, I developed comprehensive reports to provide business intelligence on an hourly, daily, weekly, monthly, quarterly, and yearly basis. The project was executed using Agile methodology, dividing the work into releases, sprints, and user stories to ensure timely and high-quality deliverables. This structured approach enabled the bank to streamline their loan processing and enhance decision-making capabilities., ETL Solution Development: Designed and implemented ETL processes to handle data from online forms, email/fax, and third-party platforms. Consolidated data into the Loan Application Database., Data Validation: Implemented validation rules to check for required fields and correct formats. Developed a notification system for loan officers to address data errors., Error Handling and Resubmission: Created workflows for loan officers to review and correct application errors. Implemented a resubmission process for corrected applications., Daily Application Review: Developed a user interface for loan officers to review applications daily. Integrated functionalities for approving and rejecting applications., Data Warehousing: Designed and built a scalable data warehouse to store approved and rejected loans. Ensured the data warehouse supports future growth., Reporting: Developed reports to provide business intelligence on various time scales. Ensured reports meet the needs of different stakeholders., Agile Methodology Implementation: Divided the project into releases, sprints, and user stories. 

Online Retail Business Sales

Online Sales Project, This project focuses on managing online and retail sales transactions by leveraging two key data processing structures: OLTP (Online Transaction Processing) for live data and OLAP (Online Analytical Processing) for historical data. The project begins with the creation of a Business Requirement Document (BRD) that outlines the business needs and objectives. Based on the BRD, the team receives daily CSV files from various sources, including customer, production, category, and sales data. To ensure data integrity and avoid duplication, the existing data is first truncated before loading the new data into a staging table. The ETL (Extract, Transform, Load) process, facilitated by SSIS (SQL Server Integration Services), extracts the data from the staging table, transforms it as needed, and loads it into the master table. This OLTP process ensures real-time data handling and transaction processing. Once the data is cleaned and transactions are completed, the OLAP process begins. The first three tables (customer, production, and category) populate the master table in the data warehouse as dimensional tables, while the sales table, which serves as the fact table, is moved to the data warehouse for analysis and reporting. This historical data is managed using Slowly Changing Dimensions (SCD) to maintain both current and historical records. Finally, the data is visualized using Power BI, providing insightful reports and dashboards for business analysis and decision-making., ETL Process: Truncate existing data, load new data into staging table, and use SSIS to extract, transform, and load data into the master table., OLTP Process: Handle real-time data and transaction processing., OLAP Process: Move sales table to data warehouse for analysis and reporting. Use Slowly Changing Dimensions (SCD) to manage historical data., Data Visualization: Use Power BI to create reports and dashboards for business analysis and decision-making. 

Other Development Works

 In this project, my role was multifaceted, encompassing planning, designing, coding, and testing. I began by gathering requirements and planning the structure of the blog, ensuring it would meet the needs of its users. I then designed the user interface, focusing on creating a clean and modern look that enhances the user experience. Using HTML, I structured the content of the blog, while CSS was employed to style the elements and ensure a responsive design. JavaScript was used to add interactivity, such as a dark mode toggle, enhancing the overall functionality of the blog. Throughout the project, I conducted thorough testing to ensure the blog was fully functional and free of bugs. Finally, I deployed the blog, making it accessible to users and ready for updates as my programming journey continues. This project not only allowed me to apply my technical skills but also provided a platform to document and share my learning experiences with others., Gathering requirements and planning the structure of the blog., Designing the user interface to enhance the user experience., Structuring the content of the blog using HTML., Styling the elements and ensuring a responsive design using CSS., Adding interactivity, such as a dark mode toggle, using JavaScript., Conducting thorough testing to ensure functionality and bug-free operation., Deploying the blog and making it accessible to users. I have projects in progress that I will present soon