Shadya Mariazo

Shadya Mariazo- - Nairobi, Kenya https://www.linkedin.com/in/shadya-mariazo-/ Summary Seasoned BI developer with expertise in ETL, leveraging SQL Server Integration Services (SSIS), Microsoft SQL, and Power BI. Specializing in crafting comprehensive reports and dynamic dashboards to enable data-driven decision-making. Proficient in both relational and non-relational databases. I am a reliable and detail oriented team player capable of delivering in diverse environments. Professional Experience 2022/02 – Present Business Intelligence Developer EPKO Consulting Optimizing SQL queries to improve overall report performance. Creating data models and automating data refresh processes to improve data accuracy and timeliness. Performing ETL processes and data cleansing to improve data quality and minimize errors. Designing and creating interactive dashboards, reports and visualization using BI tools like Power BI to monitor sales performance. Conducting Data warehousing development. Designing, developing, and deploying Power BI scripts and performing efficient detailed analysis. Performing DAX queries and functions in Power BI. Identifying KPIs with clear objectives and monitoring them consistently. • • • • • • • • 2020/03 – 2021/12 BI Developer Mashariki Technologies Ltd Collaborated with business analysts to develop and implement data-driven solutions to improve operational efficiency. Extracting data from various sources and loading to various destinations using SSIS. Extensively using the SSIS transformations such as lookup, derived column, data conversion, working on all activities related to the development, implementation, administration and support. Designed and implemented reporting solutions using Power BI. Actively participated in team activities as an enthusiastic, positive and dependable team member. • • • • • 2018/02 – 2019/12 Insurance Underwriter Kenindia Assurance Company Reviewing, analyzing risk proposals on the basis of past and current guidelines and recommending improving of the same where required. Preparing marine and motor vehicle policy documents and ensured timely delivery to clients. Issuing quotations as per policy guidelines within the TATS and Regulator. Pricing of contracts and identifying liabilities and risks. • • • • Skills Power BI DAX, Data Modelling SQL Microsoft SQL, MySQL,PostgreSQL, Oracle SSIS/SSRS/SSAS Microsoft Office Advanced Excel,Word,Access, Power Point Data Warehousing Azure Databricks, Azure Datafactory Strengths Problem Solver: Proficient in using Power BI DAX formulas to address various business challenges. Collaborator: Demonstrated the ability to collaborate with team members, resulting in faster decision making. Detail oriented: Conducted ETL processes with meticulous attention, achieving data accuracy. • • • Education 2011/05 – 2014/12 Bachelor of Science in Actuarial Science Jomo Kenyatta University of Agriculture and Technology 2006/01 – 2009/11 Kenya Certificate of Secondary Education Turbo Girls High School Certificates Data Analytics Pragim Technologies Actuarial Proffessional Papers IFOA CT1 Financial Mathematics and CT5 Contingecies Languages English IELTS References Available upon request Spanish C2