Dorigen Ngunyi

About Dorigen Ngunyi

Highly motivated and experienced Senior Business Intelligence (BI)/SQL Developer with vast experience in designing, developing and implementing complex SQL databases using the Microsoft BI stack. Maintain a deep understanding of database design, data modeling, and data warehousing with extensive experience in developing and optimizing complex T-SQL queries. Proven track record of delivering innovative solutions, optimizing database performance and reducing downtime. Have a strong background in data analysis and data visualization, with a proven ability to develop and maintain data-driven solutions. Skills- Expertise in SQL Server, T-SQL, and SQL Server Management Studio, PostgreSQL, PySQL- Strong knowledge of data warehousing, ETL, reporting and business intelligence- Experience with SSIS/SSRS/SSAS/PowerBI/Azure Data bricks/ Azure Data Factory/ Azure Cloud- Ability to develop complex stored procedures, functions, triggers and various database objects - Proven ability to optimize database performance and reduce downtime- Knowledge of data security, disaster recovery, and backup strategies- Excellent problem-solving, analytical and communication skills- Data Mapping, Gap analysis - Code Reviews

Experience

1. Business Intelligence Developer

   Fay Servicing, LLC

   Oct 2019 — Present · Farmers Branch, TX, US

   Designed, developed and implemented complex database systems for clients• Optimized database performance by identifying and resolving bottlenecks• Created and maintained stored procedures, functions and views to support application requirements• Worked closely with cross-functional teams to develop data-driven solutions• Implemented data security measures to ensure data confidentiality and integrity• Developed and maintained ETL processes to transfer data between systems• Maintained and supported existing database systems, ensuring high availability• Designed, developed, and deployed reports using SSRS for various departments• Used TFS for version control and collaboration with other developers• Mentored and trained junior developers, helped them improve their SQL skills and advance in their careers.• Collaborated with stakeholders and subject matter experts to understand their data needs and developing custom solutions to meet their requirements.• Participated in code reviews and suggesting improvements, helping to maintain high quality standards in the team\'s work.

Education

• University of North Texas

  Bachelor's degree